Construction Estimate Template

What a construction estimate is — and what it is not

A construction estimate is the internal build-up of what a job will cost you and what you need to charge for it. It lists the materials you will buy, the hours you will spend, the equipment you will rent and the subcontractors you will hire, adds the costs that ride on top (sales tax, contingency, overhead), and finishes with the profit you intend to keep. It is a worksheet, and its audience is you.

It is not the document the customer signs. That is a quote for a small, direct, fixed-price job, or a bid proposal for a competitive bid to a GC. Both carry the number this worksheet produces; neither should show the unit costs and margin behind it. And once the job is won, the estimate has a third life: its sections become the job cost budget you track actual costs against, and they map onto the schedule of values you bill from.

The pricing ladder, line by line

The four sections above the ladder are just quantity × unit cost. The ladder is where estimates go wrong, so the template makes every step explicit:

Two check rows in the Excel version show the equivalent markup on cost + overhead and recompute profit ÷ price, so the margin you entered is the margin you get.

Markup vs. margin — the mistake this template is built around

Markup is a percentage of cost. Margin is a percentage of price. A 15% markup on $10,000 of cost gives an $11,500 price, but $1,500 ÷ $11,500 is only a 13% margin. To keep 15% of the price you have to mark cost up 17.6%. Most estimating spreadsheets multiply cost by a markup and call it the margin; over a year of bids the difference is real money that was never priced.

This template prices by margin. Overhead goes on first, as a cost, and profit is solved from the price: price = (cost + overhead) ÷ (1 − margin). The workbook’s Markup vs Margin sheet has a live calculator and a conversion table (10% markup = 9.1% margin, 25% = 20%, 50% = 33.3%). To check a number without the workbook, use the free markup vs margin calculator; the full explanation is in our guide to markup vs. margin in construction.

A worked example: a $486,200 mechanical bid

The completed example is the estimate behind a mechanical subcontract on a medical office building — the same job that appears on our change order, schedule of values and pay application templates, so the numbers reconcile across the set. Materials come to $187,400 (rooftop units at $74,800 from a vendor budget quote, copper, DWV pipe, fixtures, controls hardware), labor to $106,770 across plumbers, pipefitters, sheet metal and a foreman at loaded rates of $66 to $84 an hour, equipment to $14,700 (two crane days for the RTU sets, lifts, tools), and four subcontractor quotes to $52,732. Direct cost: $361,602.

Denver sales tax at 8.81% on the materials adds $16,509.94 and a 3% contingency adds $10,848.06, for a total estimated cost of $388,960. Overhead at 10% is $38,896, and profit at a 12% margin is $58,344 — an estimate total of $486,200.00, which was submitted as the lump-sum base bid and became the contract sum. The same profit expressed as a markup is 13.6%: the number an estimator who prices by markup would have needed to type, and usually did not.

Estimate vs. quote vs. bid proposal vs. schedule of values

• Estimate — internal; cost by section plus the ladder; the source of the number and, later, the cost budget.
• Quote — customer-facing, fixed price, one page, for small direct jobs; line items at sell price, options, deposit, acceptance signature. Quote template.
• Bid proposal — customer-facing, for competitive work; scope, base bid with alternates, inclusions and exclusions, terms. Bid proposal template.
• Schedule of values — after award; the contract sum broken into billable lines for monthly pay applications. SOV template.

The relationship is one-way: the estimate feeds the others. If the proposal total and the estimate total ever differ, the estimate is the one that explains why.

Estimate templates by trade

This worksheet is for pricing a bid to a GC or owner against drawings and specs. If you sell directly to homeowners or property managers, start from a customer-ready estimate built for your trade instead. Each one comes with a takeoff sheet that does your trade's quantity math: roofing (squares and pitch), HVAC (duct runs and line-set charge), electrical (device counts to labor hours), plumbing (fixture rough-in and trim), concrete (cubic yards, base and rebar), drywall (board count and mud), painting (paintable area and gallons), flooring (square footage with waste), fence (posts, pickets and concrete bags) and landscaping (sod, mulch and plants). For work without its own template, the free calculators do the takeoff math: the deck calculator counts boards, joists, footings and screws, the asphalt calculator turns area and compacted thickness into tons and truckloads, and the stair stringer calculator works out risers, treads and stringer stock.

Common estimating mistakes this template is built to catch

• Pricing labor at the wage instead of the loaded rate — the single biggest quiet loss. The free labor burden calculator works out the loaded rate from the wage.
• Forgetting sales tax on materials, or applying it to labor and subs as well.
• Multiplying by a markup and reporting it as a margin.
• Taking overhead out of profit instead of pricing it as a cost.
• Carrying no contingency on an incomplete drawing set, then eating the RFIs.
• Accepting the lowest sub quote without leveling scope — use the bid tabulation template before you pick one.
• Leaving the basis of estimate blank, so the exclusions never make it onto the proposal.

For the full process from takeoff to submission, read how to create a construction bid; for the math, markup vs. margin.