Fidrel

Costs · Forecast

Estimate at completion in construction: invoiced plus what remains

The textbook formulas for estimate at completion assume an earned value system that most building projects never set up. A project manager still needs the answer: what will this job cost when it is finished? This page explains the bottom-up version that fits a building project, the plain sum of what has been invoiced and what is still to come, and how Fidrel calculates and shows it.

30 days free · No long-term contract.

Cost tracking in Fidrel on a laptop, tablet and phone

Why the answer is hard to get

The formulas need data you do not keep

Dividing the budget by a cost performance index only works if someone measures earned value for every item each month. On a typical building job nobody does, so the formula stays in the training course and the project runs on a guess.

The forecast goes stale

A forecast typed in March is wrong by June, and nothing on the page shows its age. The budget looks fine until an invoice arrives that the forecast never expected.

The budget is mistaken for the answer

When the forecast column is empty, the number people read is the budget. It says what was planned, not what is likely to be paid, and the two part ways quietly.

The calculation Fidrel makes

For a line where a remaining cost forecast has been saved, the estimate at completion is the invoiced cost plus that remaining amount. For a line without one, Fidrel uses the highest of the current budget, the committed cost and the invoiced cost, so a line never reads lower than what is already committed or paid. For example, with a current budget of $100,000, $60,000 invoiced and a remaining forecast of $55,000, the estimate at completion is $115,000, which is $15,000 over. With no forecast saved and $90,000 committed, the same line reads $100,000, the budget.

Cost tracking
The Cost tracking page in Fidrel with cards for budget, costs and forecast, a bridge from original budget to estimate at completion and a cost curve

Why there is no performance index here

The remaining forecast is a person’s judgment, and Fidrel shows it as such. It does not compute a cost performance index from earned value. Instead, budget items can be linked to schedule activities, and an alert warns when costs are ahead of production. That is a plain comparison of money spent with progress entered, which suits a project that keeps progress by activity and does not keep earned value by item.

A locked baseline estimate with current budget, committed, invoiced, estimate at completion and variance, and original budget columns

Building the estimate at completion line by line

  1. Step 1

    Start from an approved budget

    Approve the estimate as the baseline so every priced line becomes a budget item. Approved change orders then move the current budget, so the line you forecast against is the current one and not the original.

  2. Step 2

    Let invoiced cost build up

    Code each vendor invoice to the lines it belongs to and approve it. Approved invoices count in cost tracking, and the table shows the share consumed beside each line’s current budget.

  3. Step 3

    Enter the remaining cost forecast

    For each line where work remains, type the Remaining cost forecast and use Save forecast, with a Reason. Budgets and forecasts are saved as snapshots, so earlier versions are retained and you can see how the forecast moved.

  4. Step 4

    Read the result per line and for the project

    The table shows the estimate at completion, the variance and the amount committed but not invoiced for every line, and the project total above them. Filter to the lines that are over budget to see where the forecast is heading.

  5. Step 5

    Set the thresholds for alerts

    Choose the Alert thresholds so Fidrel flags when the forecast exceeds the budget, when budget consumption runs high, when commitments exceed the budget or when costs are ahead of production.

From one project to the whole portfolio

On the Financials page the same estimate at completion is totaled for each of an organization’s projects. A project reads Over budget when its forecast is above the current budget, and Watch when change orders are pending, invoices are overdue or the forecast is close to the budget. A forecast estimate is also available as a type of estimate, an assessment of the cost at completion that is kept beside the baseline and never approved as the budget.

What this calculation does not do

Fidrel computes no cost performance index, schedule performance index or other earned value measure. The forecast of the remaining work is typed in by a person; Fidrel does not predict it. Work that has been done but not yet invoiced is not counted until the invoice is approved, so it belongs in the remaining forecast.

One project. One subscription. The entire platform included.

Your trial applies to your first own project and starts when that project is created. No card required. Afterwards, choose card or invoice to continue.

  • 30 days free
  • Unlimited participants
  • No minimum term

Costs · Forecast

Frequently asked questions

Anything else on your mind? We are happy to help.

Talk to us

The expected total cost of a job or a cost line when it is finished: what has already been spent plus a realistic estimate of what is still to be spent.