A construction estimate spreadsheet should do more than add up labour and materials. It should help you turn the expected cost of a job into a selling price that protects the margin you actually want to earn.
Start with direct job cost
Before deciding what to charge, build the expected cost of delivering the work. Typical categories include labour, materials, subcontractors, equipment or plant hire, disposal, travel and other project-specific expenses.
If one major cost category is missing, the quote can look profitable before the job starts and become unprofitable once the work is underway.
Separate cost from selling price
Cost tells you what the job is expected to consume. Selling price is what the customer pays. The difference is gross profit. Your gross margin is gross profit divided by selling price.
That distinction matters because adding 30% to cost does not create a 30% margin. A 30% markup produces only a 23.1% gross margin. If you need a true 30% margin, the correct formula is:
Selling price = Cost ÷ (1 − Target Margin)
Example contractor estimate
Assume the expected costs are:
- Labour: £4,500
- Materials: £6,000
- Subcontractors: £2,000
- Other direct costs: £500
Total expected job cost is £13,000. If the target gross margin is 35%, the required selling price before tax is £20,000. That gives £7,000 gross profit and a 35% gross margin.
If you simply added a 35% markup to £13,000, the price would be £17,550 and the margin would only be about 25.9%.
Build tax separately
Tax, VAT or GST should normally be treated separately from the margin calculation because it is not business profit. A flexible estimate spreadsheet should therefore allow the tax rate to be entered independently and then calculate the final customer-facing quote after the net selling price has been established.
Keep the estimate reusable
A practical spreadsheet should let you replace the example figures with the costs for each new job without rebuilding formulas. The useful structure is simple: cost lines, total direct cost, target margin, required selling price, tax and final quote.
Review the estimate after the job
An estimate becomes much more valuable when you compare it with actual results. If the same category is repeatedly over budget, update your assumptions for future quotes. This is how a spreadsheet evolves from a quoting tool into a pricing system.
Use a margin-protected estimate template
The MarginRidge Contractor Estimate & Quote Calculator lets you enter labour, material, subcontractor and other costs, set a target gross margin and calculate the required selling price automatically.
For a complete system that also tracks actual job cost, change orders, invoices and profit, see Contractor Profit OS.