Constructelligence
Overview
Free tools Pricing Demo Join the beta
Template · estimating

Construction estimate template: labor, material, equipment and subs by cost code — free Excel

A construction estimate prices the work before it is built: quantity of each item, times what it takes to install, times what that costs, plus markup. The difference between an estimate that wins profitable work and one that loses money is rarely the arithmetic — it is whether the productivity assumptions (hours per unit) are right, and whether the estimate is organised so that actual cost can be compared with it afterwards. This template is built for both: every line is coded to a cost code, labor is built from hours per unit, and the totals feed a price.

Updated · 9 minute read

Key takeaways
  • Code every line to the cost code it will be tracked against.
  • Build labor from hours per unit — the assumption you can check.
  • Markup on cost is not margin on price.
  • Compare actual hours per unit with the estimate on every finished job.

How a line of an estimate is built

Labor hours = quantity × hours per unit
Labor cost = labor hours × loaded rate
Material cost = quantity × unit cost
Total cost = labor + material + equipment + subcontract
Price = total cost × (1 + markup)

Two choices make the estimate useful after award. Code every line to the cost code it will be tracked against, using the same list as job costing (see cost codes). And keep labor as hours, not just dollars — hours per unit is the number you can check against timecards and improve.

A filled-in example

Four lines from the Maple Street Medical Office estimate:

Cost codeItemQtyLabor hLabor $Material $Other $Total costMarkupPrice
09-2116Gypsum partitions14,200 SF639$43,452$19,170—$62,62215%$72,015
03-3000Slab on grade 4"120 CY144$9,792$19,800$2,400$31,99215%$36,791
26-0500Electrical (sub)1 LS———$248,000$248,00010%$272,800
01-5000Temporary facilities1 LS———$8,500$8,50015%$9,775

The partitions line carries 0.045 hours per square foot at $68 an hour. If the crew actually runs at 0.052, the line loses $6,760 — more than half its markup — and the estimate is the only place that assumption is written down.

CalculatorLabor line check

Markup is not margin

A 15% markup on cost is a 13% margin on price: $62,622 × 1.15 = $72,015, and $9,393 ÷ $72,015 = 13.0%. If the company needs a 15% gross margin, the markup has to be 17.6%. The markup vs margin calculator converts either way.

How to fill it in

  1. One row per item of work, coded to the cost code it will be tracked against.
  2. Enter quantity and unit from the takeoff.
  3. Enter labor hours per unit and the loaded rate, material unit cost, and any equipment or subcontract amount.
  4. Set markup per line (or the same on every line); price calculates.
  5. After award, keep the sheet — compare actual hours and cost by cost code with it when the job finishes.
Checklist
Construction estimate template in Excel, filled in with example rows — columns: Item, Cost code, Description, Quantity, Unit, Labor hours per unit, Labor rate ($/h), Labor hours…
The construction estimate template as it opens in Excel: example rows in italics, calculated columns shaded.
Free template · Construction estimate template (Excel & CSV)An Excel workbook with drop-downs, validation and formulas built in — or the same columns as a CSV for Google Sheets and Numbers.
Download Excel (.xlsx)
What this template captures

Everything a line of a construction estimate needs so it can be checked and later compared with actual cost: cost code, quantity and unit, labor productivity and rate, material unit cost, equipment, subcontract, markup — with labor hours, each cost and the price calculated.

16 columns: 11 you fill in and 5 calculated by formula and filled down 200 rows, so nothing is worked out by hand. In the Excel version, 7 columns reject entries of the wrong type (a date column only takes dates, an amount column only numbers), the header row stays frozen with filters on it, and the workbook opens on an Instructions sheet that lists every column below.

Every column, and how it is captured
ColumnTypeWhat goes in it
ItemTextLine number, so the row can be referred to.
Cost codeTextCost code the line will be tracked against after award — the same list as job costing.
DescriptionTextWhat the line is, in words the other party will recognise.
QuantityNumberEnter a number.
UnitTextUnit of measure (EA, LF, SF, CY, HR, LS).
Labor hours per unitNumberProductivity: hours to install one unit, ideally from your own finished jobs.
Labor rate ($/h)Amount ($)Loaded labor rate (wages + burden).
Labor hoursCalculatedCalculated: [Quantity] × [Labor hours per unit]
Labor costCalculatedCalculated: [Labor hours] × [Labor rate ($ ÷ h)]
Material unit costAmount ($)Supplier price per unit, including waste.
Material costCalculatedCalculated: [Quantity] × [Material unit cost]
Equipment costAmount ($)Equipment for the line, owned or rented.
Subcontract costAmount ($)Subcontractor quote for the line, if subcontracted.
Total costCalculatedCalculated: [Labor cost] + [Material cost] + [Equipment cost] + [Subcontract cost]
Markup %PercentOverhead and profit on the line, 0–100.
PriceCalculatedCalculated: [Total cost] × (1 + [Markup %] ÷ 100)

See it on real-looking numbers

Constructelligence is a construction intelligence platform: it reads your ERP, project and field systems read-only and does this arithmetic every week, for every job. The demo runs it on a sample eight-job portfolio.

Try the demoJoin the private beta

Frequently asked questions

What should a construction estimate include?

Every item of work with quantity and unit, labor hours and loaded labor rate, material, equipment and subcontract costs, general conditions, overhead and profit — organised by cost code so it can be compared with actual cost later.

How do you calculate labor in a construction estimate?

Multiply the quantity by the labor hours per unit (productivity) to get hours, then by the loaded labor rate — wages plus payroll taxes, insurance and benefits. Hours per unit are best taken from your own completed jobs.

What is the difference between an estimate and a bid?

The estimate is your internal calculation of cost. The bid is the price you submit, after markup, with the scope, alternates and exclusions the owner asked for — see the construction bid template.

Is Excel good enough for construction estimating?

For small jobs and trade estimates, often yes. Takeoff software and estimating databases save time and errors as volume grows; see the estimating software guide.

CI
Written by the Constructelligence teamConstruction finance and software. Worked examples use the sample demo portfolio; formulas are standard practice. Reviewed September 2026.
Construction estimating software: takeoff and bid tools comparedConstruction estimating and takeoff software for 2026 — Bluebeam, On-Screen Takeoff, PlanSwift, STACK, ProEst, Sage Estimating, HCSS HeavyBid, Accubid and AI takeoff — by trade, with what to check.Construction cost codes: how to structure them and what they can tell youHow construction cost codes work: structure, CSI MasterFormat divisions, cost types, how many codes to use, and how cross-job cost-code analysis separates estimating problems from site problems.Construction labor forecasting: from burn rate to machine learningHow to forecast construction labor hours and cost: productivity factors, earned hours, straight-line vs learning-curve vs machine-learning forecasts, and how to test which one to trust.

More in Templates & forms

All templates & forms resources →