Earned Value Schedule Variance and SPI Calculator
Check schedule performance against planned value at the same status date.
Compare earned value with actual cost to calculate CPI and cost variance. Actual cost must be positive for the index, and both amounts must cover the same work and status date.
Measure project cost performance by comparing earned value with actual cost for the same work. The cost performance index expresses value earned per unit spent, while cost variance shows the difference in budget currency.
Use one budget baseline and status date. Earned work and actual expenditure must cover comparable activities before their ratio can describe cost performance.
Divide earned value by actual cost. One means the amounts match; below one means less budgeted value earned per unit of cost, and above one means more.
Subtract actual cost from earned value. A negative result shows the included actual cost exceeds the budgeted value earned, while a positive result shows the reverse.
Sample inputs demonstrate the method. They are not a forecast or product offer.
The first example has €80,000 earned value and €100,000 actual cost. Dividing gives CPI of 0.8. Subtracting actual cost from earned value gives a negative cost variance of €20,000.
Sample inputs demonstrate the method. They are not a forecast or product offer.
The index and variance describe performance to the measurement point. They do not automatically predict final project cost or the efficiency of all remaining work.
An index of 0.8 means €0.80 of earned budget value for each €1 of actual cost. It should not be casually relabelled a 20% cost overrun, because that alternative statement uses a different denominator.
No. Forecasting final cost requires assumptions about remaining work. This calculator reports observed cost performance only.
Read our calculation and testing approach.