Tools › Project Management › Schedule › Earned Value › Example
Lipke 2003 Table 1: earned schedule of an early-finish project
| Tool | Earned Value |
| Source | Lipke, W. (2003). "Schedule is Different." The Measurable News, March 2003. Table 1. |
| Level | Professional |
Problem
The same 12-month baseline (BAC 2,823; cumulative planned value 105, 200, 515, 845, 1,175, 1,475, 1,805, 2,135, 2,435, 2,665, 2,760, 2,823) is worked ahead of plan, with cumulative earned value 115, 220, 530, 870, 1,215, 1,525, 1,860, 2,190, 2,500, 2,740 and 2,823 at month 11. Compute the monthly schedule variance and SPI in money and the earned-schedule ES, SV(t) and SPI(t), and show how the two sets of indicators behave as the project finishes a month early.
Inputs to Enter
- BAC 2,823; cumulative table values; 11 period rows of PV and EV (no AC column needed)
- Status period 8 (or any month)
Answers
- SV($) by month 10, 20, 15, 25, 40, 50, 55, 55, 65, 75, 63; SPI($) 1.095 … 1.023
- ES by month 1.105 (the article prints 1.095, equal to SPI($), where its own rule gives 1 + (115 − 105)/(200 − 105)), 2.063, 3.045, 4.076, 5.133, 6.152, 7.167, 8.183, 9.283, 10.789, 12.000
- SPI(t) by month 1.105 (article 1.095), 1.032, 1.015, 1.019, 1.027, 1.025, 1.024, 1.023, 1.031, 1.079, 1.091
- Month 11: ES = 12 = PD, SV(t) = +1.000 month (finished one month early)
Notes
Replace the default EV column with the Table 1 values and drop the AC column (two numbers per line are read as PV, EV); the 12th baseline row keeps PV = EV = 2,823.