Profitability forecasting is predicting a project's final profit margin from the cost incurred so far, the costs already committed and the work still to be bought. It answers the question "what will this job make?" using current facts instead of the original estimate.
Worked example
A £1,500,000 contract was budgeted at £1,320,000 cost, a margin of 12%, or £180,000. At the end of month five:
| Line | Amount |
|---|---|
| Cost to date | £610,000 |
| Committed, not yet invoiced | £420,000 |
| Still to commit (estimate) | £360,000 |
| Forecast final cost | £1,390,000 |
| Forecast profit (£1,500,000 less cost) | £110,000 |
| Forecast margin | 7.3% |
The forecast is £70,000 below budget. Because the uncommitted £360,000 is only an estimate, it is where most of the risk sits.
Building the forecast from real numbers
Start with the three cost layers: what has been spent, what is on order, and what has not been bought yet. The first two come from your records. The third is judgement, so give it the most attention. A forecast that is simply budget minus spend is not a forecast. It assumes nothing goes wrong.
On the income side, use the contract sum plus agreed variations. Pending variations can sit in a separate line. Forecast margin is then the same figure the CVR shows, which keeps the two reports consistent.
Good practice:
- Forecast every month on the same day, so you can compare month on month.
- Keep a note of why the forecast moved, such as a new order, a Variation or a revised estimate.
- Flag risks to the uncommitted portion, such as packages not yet tendered or materials with volatile prices.
- Roll the job forecasts up to a company view so that cash and margin across all live jobs can be seen together.
Forecasting is only as good as the commitments recorded. An order raised late, or a Subcontract variation held in someone's inbox, shows up as profit that does not exist.
Related terms
Cost Forecasting, Cost to Complete, Profit Fade, Cost Value Reconciliation (CVR), Earned Value Management (EVM).
Planyard's construction forecasting builds forecast margin from budgets, committed costs and Cost-to-Complete estimates, so each job's expected profit updates as orders and variations are entered.