Construction cost overrun calculator
Find out where a job will finish while there is still time to change it. Enter the budget, what has been spent and how far along the work really is — the calculator forecasts cost at completion from the job’s own performance and from its recent burn, and tells you when the two disagree.
Cost overrun & forecast at completion
Enter the budget, what you have spent and how far along the work is. You get the forecast two ways — performance-based and burn-based — and the verdict tells you when the two disagree, because that is usually the first sign of an overrun.
Job inputs
Result
Earned value = BAC × % complete. CPI = EV ÷ AC (below 1 means you are paying more than the work is worth). EAC (performance) = BAC ÷ CPI. EAC (burn) = AC + (spend ÷ 3) × months remaining. VAC = BAC − EAC. TCPI = what the remaining work must achieve to still land on budget — above 1.1 is usually not going to happen. Months to exhaustion = (BAC − AC) ÷ monthly burn.
How to use it
- Enter the budget at completion — the job’s total cost budget.
- Enter cost to date from the job cost ledger.
- Enter work complete from the schedule or installed quantities — not from cost.
- Optionally add the last three months’ spend and the months remaining for the burn forecast.
A worked example
Questions
How do you calculate a construction cost overrun?
Forecast cost at completion (EAC) and subtract the budget. The usual EAC is budget ÷ CPI, where CPI is earned value (budget × % complete) divided by actual cost.
What is a good CPI on a construction job?
1.0 or above means the work is costing what it was budgeted to cost or less. Between 0.95 and 1.0 deserves watching; below 0.95 is usually a real overrun.
What does TCPI tell me?
The cost performance the remaining work must achieve to finish on budget: (BAC − EV) ÷ (BAC − AC). A TCPI well above the CPI you are running means the budget is no longer realistic.
Why are there two forecasts?
The performance forecast carries the job’s cost efficiency forward; the burn forecast carries its recent spending rate forward. When they disagree by more than 10% of budget, percent complete or the recent burn is usually wrong.
More free calculators
Want this on your live data, every morning?
These tools are manual. The dashboard does the same arithmetic across every job, every company and every week — plus the money-at-risk view, the audit findings and the overrun radar. Join the private beta and we will connect it to the systems you already run.