| ← Back to Dashboard | |||||||
| PROJECT SETUP & GENERAL INFORMATION | |||||||
| Construction Project Cost Estimation Model | |||||||
| PROJECT DETAILS | |||||||
| Project Name: | [Enter Project Name] | ||||||
| Project ID / Code: | PROJ-2026-001 | ||||||
| Project Location: | [Enter Location] | ||||||
| Project Type: | Commercial / Industrial / Residential | ||||||
| Client / Owner: | [Enter Client Name] | ||||||
| Project Manager: | [Enter PM Name] | ||||||
| Estimator: | [Enter Estimator Name] | ||||||
| Date of Estimate: | 2/12/2026 | ||||||
| Estimate Revision: | Rev 0 - Initial Estimate | ||||||
| Project Description: | [Enter brief project description] | ||||||
| KEY DATES & TIMELINE | |||||||
| Project Start Date: | 03/01/2026 | ||||||
| Planned Completion Date: | 02/28/2028 | ||||||
| Mobilization Date: | 02/15/2026 | ||||||
| Substantial Completion: | 12/31/2027 | ||||||
| Final Completion: | 02/28/2028 | ||||||
| Duration (Months): | 23.9 | ||||||
| COST ASSUMPTIONS & PARAMETERS | |||||||
| Currency: | USD | ||||||
| Base Year for Pricing: | 2026 | ||||||
| Escalation Rate (Annual %): | 3.5% | Annual cost escalation factor | |||||
| Contingency Rate (%): | 10.0% | Applied to base estimate for unknowns | |||||
| Management Reserve (%): | 5.0% | Additional reserve for scope changes | |||||
| Overhead Rate (%): | 15.0% | General & Administrative overhead | |||||
| Profit Margin (%): | 8.0% | Contractor profit percentage | |||||
| Sales Tax Rate (%): | 6.5% | Applicable state/local sales tax | |||||
| Bond / Insurance Rate (%): | 2.0% | Performance / payment bond | |||||
| Mobilization / Demobilization (%): | 3.0% | Site mobilization percentage | |||||
| ESTIMATE APPROVAL | |||||||
| Role | Name | Signature | Date | ||||
| Prepared By: | |||||||
| Reviewed By: | |||||||
| Approved By: | |||||||
| Client Approval: | |||||||
| NOTES & INSTRUCTIONS | |||||||
| 1. Blue cells are editable inputs. Black text = calculated formulas. | |||||||
| 2. Cost assumptions drive calculations across the entire model. | |||||||
| 3. WBS sheet contains the hierarchical work breakdown structure. | |||||||
| 4. Cost Estimation sheet provides detailed cost entry by category. | |||||||
| 5. Contingency rate applies to base estimate before markups. | |||||||
| 6. All sample data is for illustration - replace with actual data. | |||||||
| 7. Change Orders should be logged on the Change Orders sheet. | |||||||
| 8. Update Actual Costs regularly to monitor project health. | |||||||
| COLOR CODING LEGEND | |||||||
| Blue Text | Hardcoded input (user editable) | ||||||
| Black Text | Calculated formula (within same sheet) | ||||||
| Green Text | Cross-sheet reference (links from other sheets) | ||||||