Architecture

Writing a construction cost estimate by CSI MasterFormat division

Build a construction cost estimate by CSI MasterFormat division, with takeoff, unit costs, markups in order, AACE estimate class and cost per square foot.

A construction cost estimate organized by CSI MasterFormat puts every cost under the division it belongs to (03 Concrete, 09 Finishes, 22 Plumbing, 23 HVAC, 26 Electrical), prices each line as quantity times unit cost, totals the direct cost by division, and then applies markups to a running subtotal: general conditions, overhead and profit, contingency, and escalation. The example in this article takes a 10,000-square-foot office building from $1,674,890 of direct cost to $2,325,994 total, or $232.60 per square foot. All quantities and prices are illustrative, not current market data.

What do CSI divisions give a construction cost estimate?

MasterFormat is a classification of construction work published by the Construction Specifications Institute (CSI) and Construction Specifications Canada. The 2018 edition has 50 divisions numbered 00 to 49, and many numbers are reserved for future use. Division 00 covers procurement and contracting requirements. Divisions 01 to 49 form the specifications group, which is split into five subgroups:

Subgroup Divisions used in most building estimates
General Requirements 01 General Requirements
Facility Construction 02 Existing Conditions; 03 Concrete; 04 Masonry; 05 Metals; 06 Wood, Plastics, and Composites; 07 Thermal and Moisture Protection; 08 Openings; 09 Finishes; 10 Specialties; 11 Equipment; 12 Furnishings; 13 Special Construction; 14 Conveying Equipment
Facility Services 21 Fire Suppression; 22 Plumbing; 23 Heating, Ventilating, and Air Conditioning (HVAC); 25 Integrated Automation; 26 Electrical; 27 Communications; 28 Electronic Safety and Security
Site and Infrastructure 31 Earthwork; 32 Exterior Improvements; 33 Utilities (34 Transportation and 35 Waterway and Marine Construction serve heavy civil work)
Process Equipment 40 to 49, from 40 Process Interconnections to 48 Electrical Power Generation

Below the division, numbers go to six digits, with optional further detail after a decimal point. For example, 03 30 00 is Cast-in-Place Concrete and 09 29 00 is Gypsum Board. Early estimates often stop at the division or at a four-digit level and add detail as the drawings develop. Some teams start even earlier with a building-systems breakdown such as UniFormat (ASTM E1557) and map it to MasterFormat once the drawings can support a takeoff by trade.

Division 01 is not a trade. It holds the project's general requirements, which an estimate usually prices as general conditions rather than as a line in the takeoff.

How do you get from takeoff to direct cost in an estimate?

Each line needs five things: a code, a description, a quantity, a unit, and a unit cost. The total is =D2*F2 for quantity in D and unit cost in F. Division subtotals come from =SUMIFS(G:G, A:A, "09"), with the division code stored as text so that 09 does not become 9 (see how to keep leading zeros in CSV for the same problem on import).

A unit cost should be installed: material, labor, equipment, and the subcontractor's own overhead and profit. Say which in a notes column. Mixing raw material prices with installed prices on neighboring lines is a common source of gaps.

Keep the takeoff lines on one sheet and the division summary on another, so the summary contains only formulas. Add a column for the source of each unit cost (a subcontractor quote, a historical project, a cost database). Months later, the question you will be asked is where a number came from, not how it was multiplied.

Here is Division 09 for the example building:

Code Description Quantity Unit Unit cost Total
09 29 00 Gypsum board 14,200 SF $3.10 $44,020
09 51 00 Acoustical ceilings 8,400 SF $4.60 $38,640
09 65 00 Resilient flooring 2,100 SF $6.40 $13,440
09 68 00 Carpeting 6,000 SF $5.80 $34,800
09 91 00 Painting 14,200 SF $0.95 $13,490
Division 09 total $144,390

Do the same for each division. The example totals:

Division Direct cost Share
02 Existing conditions $18,000 1.1%
03 Concrete $215,000 12.8%
05 Metals $168,000 10.0%
06 Wood, plastics, and composites $42,000 2.5%
07 Thermal and moisture protection $96,000 5.7%
08 Openings $118,000 7.0%
09 Finishes $144,390 8.6%
10 Specialties $14,500 0.9%
14 Conveying equipment $85,000 5.1%
21 Fire suppression $38,000 2.3%
22 Plumbing $72,000 4.3%
23 HVAC $215,000 12.8%
26 Electrical $198,000 11.8%
27 Communications $24,000 1.4%
28 Electronic safety and security $31,000 1.9%
31 Earthwork $58,000 3.5%
32 Exterior improvements $92,000 5.5%
33 Utilities $46,000 2.7%
Direct cost $1,674,890 100.0%

The share column is =B2/B$20, and it is a useful check. If HVAC is 3% of a building that should be mechanically heavy, something is missing.

Why does the order of markups change a construction estimate?

Direct cost is not the price. Four markups follow, each applied to the running subtotal:

Step Basis Amount Subtotal
Direct cost Takeoff $1,674,890
General conditions 9.0% of direct cost $150,740 $1,825,630
Overhead and profit 10.0% of subtotal $182,563 $2,008,193
Contingency 10.0% of subtotal $200,819 $2,209,012
Escalation 5.30% of subtotal $116,982 $2,325,994
  • General conditions are the time-related costs of running the job: supervision, temporary facilities, insurance, cleanup. Once a schedule exists, build them from duration (months times a monthly rate) instead of a flat percentage.
  • Overhead and profit cover the contractor's home-office costs and fee. Be explicit about whether a figure is a markup on cost or a margin on price. A 10% margin on price equals an 11.1% markup on cost: =cost/(1-margin) versus =cost*(1+markup).
  • Contingency is an allowance for items that are not yet defined. It should shrink as the design matures, and it should be a visible line, not hidden in unit costs.
  • Escalation carries today's prices to the midpoint of construction. At 3.5% a year over 1.5 years, =(1+0.035)^1.5-1 gives 5.30%. See how to calculate percentage change for turning cost indexes into rates.

If every markup is a percentage applied to the running subtotal, the order does not change the final total, because multiplication commutes. The order changes the dollars shown on each line, and it changes the total when you change what each percentage is applied to. Adding the three percentages (9% + 10% + 10% = 29%) to direct cost gives $2,160,608 before escalation. Compounding them (1.09 × 1.10 × 1.10 = 1.3189) gives $2,209,012. The difference is $48,404. Neither is wrong, but your contract or your client's estimating standard defines which one applies, and the spreadsheet must follow it. Lump-sum items added partway through the sequence also break the equivalence, so keep a consistent order and write it down.

Costs outside construction, such as design fees, permits, furniture and owner contingency, are usually carried in the project budget, not in this estimate. Label them separately.

What are AACE estimate classes and how accurate are they?

AACE International Recommended Practice 18R-97 describes five estimate classes by the maturity of project definition. It was written for engineering, procurement and construction in the process industries, and AACE publishes variants for other industries. The accuracy ranges below are the typical ones in 18R-97. Actual ranges depend on the project's complexity, the reference data and the contingency in the estimate.

Class Project definition Typical purpose Low range High range
5 0% to 2% Concept screening -20% to -50% +30% to +100%
4 1% to 15% Study or feasibility -15% to -30% +20% to +50%
3 10% to 40% Budget authorization or control -10% to -20% +10% to +30%
2 30% to 75% Control or bid/tender -5% to -15% +5% to +20%
1 65% to 100% Check estimate or bid/tender -3% to -10% +3% to +15%

If the example were a Class 4 estimate and you picked -20% and +30% from within the class ranges, the final cost could be expected somewhere between $1,860,796 and $3,023,793. State the class on the estimate. A single number with no class invites the reader to treat it as a quote.

How do you calculate cost per square foot and per square meter?

Divide the total by an area, and say which area. =total/gross_area with a total of $2,325,994 and 10,000 gross square feet gives $232.60 per square foot. Direct cost alone is $167.49 per square foot. To convert to square meters, multiply a per-square-foot rate by 10.7639: $232.60 becomes $2,503.68 per square meter, since 10,000 square feet is 929.03 square meters.

The area basis matters more than the arithmetic. A rate on gross area and a rate on net area differ by the grossing factor (what is a grossing factor), and comparing across projects only works on the same basis. The room and area schedules article covers how to keep both areas consistent.

What mistakes make a construction cost estimate wrong?

  • Counting general conditions twice. Unit costs that already include supervision, plus a general conditions percentage, overstate the total.
  • No area basis. A cost per square foot without "gross" or "net" is not comparable.
  • Escalating to the wrong date. Escalation should carry prices from the pricing date to the midpoint of construction, not to bid day or to today.
  • Contingency on part of the estimate. If it covers some divisions and not others, say so, or apply it to the whole running subtotal.
  • Mixing markup and margin. A 10% margin is not a 10% markup.
  • Unit costs without a date or location. Prices from another year or city need an adjustment you can see.
  • Lump sums with no basis. Label allowances as allowances and record what they assume.

Construction cost estimate checklist

  • Set the estimate class and the date prices are valid.
  • Set the area basis (gross or net) before you calculate a rate.
  • Store division codes as text and total by division with SUMIFS.
  • Use installed unit costs, and write down what each includes.
  • Put every markup on its own line with its percentage visible.
  • Document the order of markups and what each percentage applies to.
  • Report the total, the cost per square foot, and the class range together.

The Construction cost estimate by CSI division template from Sheet Reserve is organized by division and comes with example data, and the Space program calculator handles the net-to-gross step that sets your area basis.

Keep reading