At the end of week two, you can now check the project status :
- Schedule Variance SV = EV-PV = $480-$400 = $80 : your project is ahead schedule as you performed more work than initially planned.
- Cost Variance CV=EV-AC = $480-$600 = $-120 : your project exceeds your budget.
What will be the total cost of the project?
What benefits can you have of using the Earned Value ? As we already saw it, Earned Value can be used to see if the project is on the track for a given point of time, both on schedule and costs points of view.
But we can also use the Earned Value to evaluate the remaining needed costs to finish the project, the so-called Estimated to Complete (ETC) and the Estimate At Completion (EAC).
There are different ways to calculate these two values, it depends on how you "feel" the rest of the project.
Let's stick with our example. If you consider that the additional resource was just an "extra" and that you plan to finish the web site alone, you will not consider the Cost Variance for the rest of the project. In this case, the Estimate to Complete will be $120 (60% remaining of Contents task) + $200 + $200 (2 last tasks not started yet). At the end, the Estimate At Completion will be $600 (AC)+$520 (ETC)=$1120.
So the first way to get the Estimate At Completion is: EAC = AC + ETC
As the Estimate To Complete is calculated by difference of the Budget At Completion (BAC) and the Earned Value, you can also replace ETC in the previous formula by (BAC-EV). So an alternative way to calculate EAC is: EAC = AC + (BAC-EV)
But if you think that the extra resource must continue to help you because you globally underestimated the work to perform, you will include the Cost Variance impact for the rest of the project.
We will then use a new concept, the Cost Performance Index (CPI) that shows, for 1 consumed $, how many dollars you achieved to produce. In our case, at the end of week 2, CPI = $480 (EV) / $600 (AC) = 0.8
Now we have to consider that to finish the project, we will consume the first cost estimation updated by the Cost Performance Index.
In this second case, EAC = $600 (AC) + $520 (ETC) / 0.8 = $1250
So the second way to get the Estimate At Completion is: EAC = AC + ETC/CPI
By replacing ETC by its calculation using the project Budget At Completion, you get:
EAC = AC + (BAC-EV)/CPI
What will be the global duration of the project?
By applying the same philosophy on the Schedule Variance, you may revise your schedule by using the effects of the Schedule Variance. For that purpose you may calculate the
Schedule Performance Index (SPI) by applying the following formula:
SPI = EV / PV.
You will then be in position to extrapolate the time adjustment and calculate the date when 100% of the job will be done. Or, if your deadline is not moveable, you can calculate what will be the tasks completion rate at this fixed date by using this index.