Contractor field notesHow This Calculator WorksFormula, worked example, assumptions, common pitfalls, and FAQs
Forecast final cost, not only spending to date
A job under budget to date may still finish over budget. This calculator adds actual costs, estimated remaining work, and unpaid commitments not already included in either field. It compares that forecast with revised budgets and checks the expected effect on project gross profit.
Revised budget and forecast variance
Revised budget = original budget + approved revisions. Forecast cost = actual to date + estimated cost to complete + additional commitments. Variance = revised budget − forecast cost. Forecast gross profit = forecast revenue − forecast cost.
Worked example
A labor budget of $20,000 plus a $1,000 approved revision gives $21,000. With $9,000 actual cost and $13,000 cost to complete, the forecast is $22,000. Variance is −$1,000, or −4.76% of revised budget: an anticipated overrun. Do not add a commitment again if it is already in the $13,000 remaining-cost forecast.
Assumptions and common pitfalls
- Only add commitments that are excluded from both actuals and the estimate to complete.
- Budget revisions and change-order revenue are different inputs.
- Gross profit does not deduct unallocated company overhead, tax, or financing unless included in cost categories.
Frequently asked questions
What does a negative cost variance mean?
Variance is budget minus forecast cost. A negative amount means the forecast exceeds the revised budget; a positive amount indicates anticipated savings.
Can I reduce a budget with an approved revision?
Yes. Revisions can be positive or negative, but each resulting revised category budget must remain nonnegative.
How is profit erosion calculated?
The original gross profit is original contract revenue minus original cost budget. Profit erosion is that original gross profit minus the forecast gross profit.
