Skip to content
Omnikalc

Is your project on budget and on schedule?

Enter the budget, planned and actual progress and the cost to date: get the earned value, the cost and schedule indices and variances, the estimate at completion and the TCPI.

Updated on
Your inputs
$

Value out of range

%

Value out of range

%

Value out of range

$

Value out of range

Results

Cost performance index (CPI)

0.87

Significantly over budget

Schedule performance index (SPI)

0.90

Slightly behind schedule

Estimate at completion (BAC ÷ CPI)

$115,556

Planned value (PV)
$50,000
Earned value (EV)
$45,000
Cost variance (EV − AC)
-$7,000
Schedule variance (EV − PV)
-$5,000
Estimate to complete
$63,556
Variance at completion
-$15,556
To-complete performance index (TCPI)
1.15

Earned value management (EVM) answers three questions about a project in common terms: how much work should be done by now, how much has been done and how much has it cost. By valuing progress in money, it shows whether a project is over budget, behind schedule or both, and projects where it will end if nothing changes.

How the calculation works

  • Planned value (PV) = budget × planned progress
  • Earned value (EV) = budget × actual progress
  • CPI = EV ÷ actual cost, and SPI = EV ÷ PV
  • Cost variance = EV − actual cost, and schedule variance = EV − PV
  • Estimate at completion (EAC) = budget ÷ CPI
  • Estimate to complete = EAC − actual cost, and variance at completion = budget − EAC
  • TCPI = (budget − EV) ÷ (budget − actual cost)

Example

A $100,000 project is planned to be 50% done, and is actually 45% done after spending $52,000. PV is $50,000 and EV $45,000. The CPI is 45,000 ÷ 52,000 = 0.87, so each dollar spent has produced 87 cents of work, and the SPI is 0.90. Costs are $7,000 over (the cost variance) and the work is $5,000 behind the plan. If the trend continues, the project will cost $115,556, $15,556 over budget, and the remaining work must be done at a cost efficiency of 1.15 to stay within the budget.

Reading the indices

An index below 1 is a warning, and the farther below, the worse. A project with a CPI below 1 at the 20% mark rarely recovers, so early readings are valuable. A low SPI with a CPI above 1 suggests a resourcing problem; a low CPI with a good SPI suggests that progress is bought at too high a cost.

Using the results

Report EVM regularly, for example every month, and track the trend rather than a single value. Measure progress by finished deliverables, not by effort spent, otherwise earned value will simply follow cost and hide the problem. Revisit the forecast when the scope changes.

Frequently asked questions

What is earned value management?

A project control method that compares planned work, completed work and actual cost to measure progress in money terms.

What do CPI and SPI mean?

CPI is the value of work done per dollar spent; SPI is the work done compared with the work planned. Above 1 is good, below 1 is a problem.

How is the estimate at completion computed?

Here as BAC ÷ CPI, which assumes the cost efficiency so far continues. Other methods assume the overrun is a one-time event.

What does TCPI show?

The cost efficiency you must reach on the remaining work to finish within the budget. A value well above 1 is a warning.

Was this calculator helpful?

Thanks for your feedback!

Results are estimates provided for information purposes. They do not replace professional advice.