The Simple Guide to Earned Value
April 08, 2009
I have written a couple of posts now on agile alternatives to earned value, but lots of people still do not understand traditional earned value. So here is a simple worked example and a one page .PDF summary...
Let’s imagine our project is to build a wall around a garden.
For simplicity, let’s assume 4 equal sides and a budget of $200 per side. Our schedule is one side per day so we should finish in 4 days with a cost of $800.
Here is how the project progresses:
Day 1 Progress: Front wall completed and the budget of $200 spent – perfect!
Day 2 Progress: Side 1 started, but the foundations had to go deeper than expected using more materials so the side was not quite completed and the spend was $220
Day 3 Progress: Side 1 was finished, only half of the back wall was built, but the team left early and only spent $140 that day
So are we ahead or behind?
How much over/under budget are we?
This is the type of thing that happens on real projects, some things go fine; other things go slower than anticipated and before long you need to determine, on balance, how much ahead or behind from the original plan you are.
Just from common sense we can tell we are behind, by the end of day 3 we should have finished 3 sides not 2.5.
Spend wise, we can make some estimates too; we have achieved 2.5 out of 4 sides which is 62.5% (2.5 / 4 *100 = 62.5) of the overall project. We have spent $200 + $220 + $140 = $560 of the $800 which is 70% (560/800 *100 = 70) of the budget. Having spent 70% of your budget and only achieved 62.5% of your budgetted progress indicates you are spending faster than anticipated.
Congratulations you now understand the basics of Earned Value!
Earned Value has some unique terminology that throws off lots of people, but none of it is too complicated, here are the terms:
In our example, at the end of Day 3 we have the following values:
To fill in the remaining fields we need some formulae, again don’t be put off by the terminology, it is really quite easy:
The first two values (Cost Variance and Schedule Variance) are measures of how much ahead or behind cost and schedule we are. Just remember negative values here are negative signs for the project, it means we are over budget or behind schedule.
The next two values (Cost Performance Index and Schedule Performance Index) are factors where the value 1 means on budget or schedule, anything below 1 means behind, anything above 1 means ahead.
So plugging in our numbers we get:
So we can estimate that at this rate it is more likely to cost $900 rather than the $800 budget and given we are only progressing at 83% of the rate we first estimated, this will now take 4.8 days to finish (original 4 days / 0.83 rate of progress = 4.82).
That is it, no quantum mechanics necessary. Negative Variance figures are generally bad as are performance indexes below 1. There are other formulae, and alternative formulae that can be used in certain circumstances, but these are the basics.
All of these numbers were available to us in our initial common sense assessment of progress. Having completed only 2.5 sides instead of 3 by the end of day 3 gives us the 2.5/3 = 0.83 Schedule Performance Index (SPI) we calculated. Likewise spending $560 and only building $500 worth of original plan work is our 500/600 = 0.89 Cost Performance Index (CPI).
You can download a handy one-page summary of all the terms and formulae here.
Download Earned Value - One Page Summary
Agile Issues With Earned Value
Now the value of measuring conformance to a plan that could well be wrong is another discussion. As too is the idea that a linear extrapolation of past performance to predict future performance works for anything except defined, repeatable, low-risk tasks. For discussions on those topics see some of my earlier EV posts.
You have the perfect example going there, and then you complicated it by making 4 walls! Make it only 1 wall, build it left to right, and the height of the wall equals the height of the done line :)
Posted by: Alistair Cockburn | May 16, 2009 at 09:32 AM
Hi Alistair,
Thanks, you are right! One wall, 4 rows high would serve as a simpler example for these same calculations - and I hear what you are saying, our progress is what has been built (height of the done wall/line).
I contrived 4 walls so that day 2 (wall 2) could reasonably take longer than anticipated, but in reality even the simplest of tasks can sometime take longer than anticipated.
Regards
Mike
Posted by: Mike Griffiths | May 16, 2009 at 01:47 PM