An estimating, bidding and job-costing workbook for general contractors, remodelers and specialty trades. It takes you from a detailed estimate to a client-ready proposal, and then keeps tracking the job once you win it.
What is included
Estimate: up to 300 line items across 16 CSI divisions with quantity, unit, waste, material, trade labor hours and rates, equipment and subcontracts, priced to a line total.
Settings and assemblies: crew rates for 13 trades with labor burden, reusable assemblies and allowances.
Sub bids: 3 quotes per trade with the lowest carried automatically or your own pick.
Bid summary: direct cost by division, then general conditions, contingency, overhead, profit, bond and sales tax, with bid ratios.
Proposal: a client-ready page with price by division, allowances, a payment schedule, terms and signature lines.
After the award: a change-order log, a draw schedule with retainage, an actual-cost log and job costing with percent complete, projected final cost, profit and over or under billing.
Dashboard: headline numbers, a 6-point scorecard against your targets, a verdict and 4 charts.
How to use it
1. Open the Start Here tab: a three-step quick start, a color key and a clickable list of every sheet.
2. Replace the example values in the yellow input cells with your own. Everything else is calculated, and formulas are left visible so you can audit every step.
3. Read the Dashboard. Every number on it traces back to an input, and the scorecard compares the plan with the targets you set.
4. Once you win the job, log change orders, draws and actual costs to follow the projected final cost and margin.
Technical notes
The model is a single .xlsx workbook for Microsoft Excel 2016 or newer and Microsoft 365 on Windows and Mac. It also works in Google Sheets. There are no macros, add-ins, external links or locked cells, and it is set up to print one page wide. It ships with a complete worked example so you can see how everything fits together before entering your own numbers.
Quality: the workbook is generated from code and must pass automated tests against hand-calculated cases with zero formula errors, and it is opened and recalculated in Microsoft Excel before release. We use AI-assisted tooling in our build and testing process; the structure, logic and checks are designed and reviewed by us.
This is a planning and analysis tool, not financial, tax, legal or investment advice.
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Construction, Bid Excel: Construction Estimate and Bid Calculator with Job Costing Excel (XLSX) Spreadsheet, ModelDesk
|
Download our FREE Strategy & Transformation Framework Templates
Download our free compilation of 50+ Strategy & Transformation slides and templates. Frameworks include McKinsey 7-S, Balanced Scorecard, Disruptive Innovation, BCG Curve, and many more. |