Earned Value Calculator (CPI, SPI, EAC)
Cost and schedule performance of a project from its budget, planned value, earned value and actual cost, with the forecast cost at completion.
Results
Cost performance index (CPI)
0.833
Schedule performance index (SPI)
0.875
Cost variance (EV − AC)
-7000.00
Schedule variance (EV − PV)
-5000.00
Estimate at completion (BAC ÷ CPI)
120,000.00
Expected overrun (BAC − EAC)
-20,000.00
Efficiency needed from now on (TCPI)
1.121
What this tool does
Earned value compares three numbers at the same date: what you planned to have done, what you actually got done (valued at its budget) and what it actually cost. A CPI below 1 means each euro buys less than a euro of planned work; an SPI below 1 means you are behind. The forecast BAC ÷ CPI assumes the cost efficiency so far continues — on real projects it rarely improves much after the first fifth, which is why the TCPI, the efficiency you would need from now on to finish on budget, is a useful reality check.
Formula
CPI = EV ÷ AC · SPI = EV ÷ PV · EAC = BAC ÷ CPI · TCPI = (BAC − EV) ÷ (BAC − AC)
Variables
| Symbol | Meaning | Unit |
|---|---|---|
bac | Budget at completion (BAC) | — |
pv | Planned value to date (PV) | — |
ev | Earned value — work actually done (EV) | — |
ac | Actual cost to date (AC) | — |
CPI | Cost performance index (CPI) | — |
SPI | Schedule performance index (SPI) | — |
CV | Cost variance (EV − AC) | — |
SV | Schedule variance (EV − PV) | — |
EAC | Estimate at completion (BAC ÷ CPI) | — |
VAC | Expected overrun (BAC − EAC) | — |
TC | Efficiency needed from now on (TCPI) | — |
Worked example
- Budget at completion (BAC)100,000
- Planned value to date (PV)40,000
- Earned value — work actually done (EV)35,000
- Actual cost to date (AC)42,000
- Cost performance index (CPI)0.833
- Schedule performance index (SPI)0.875
- Cost variance (EV − AC)-7000.00
- Schedule variance (EV − PV)-5000.00
- Estimate at completion (BAC ÷ CPI)120,000.00
- Expected overrun (BAC − EAC)-20,000.00
- Efficiency needed from now on (TCPI)1.121
Limitations
- The result is an estimate based only on the values you type. Real situations often include factors this calculator does not know about.
- The tool works with whatever currency you use for the inputs; it does not convert between currencies.