Due to popular demand :) I'm covering different formulas for calculating Estimate At Completion (EAC) in Earned Value Management (EVM). The PMBOK Guide, Fourth Edition mentions four different ways of calculating the EAC. We'll review each of them and reinforce the concepts with the help of a case study.
EAC is a "forecast" of the project cost, as the project progresses. Before the start of the project, EAC is the same as Budget At Complete (BAC). However, as the project progresses, EAC may differ from BAC depending upon the project performance.
Case study: You are a project manager on a really large construction project. Your project requirement is to build a shopping mall on a square piece of land. However, due to economic crisis, the project is scaled down and reduced to building just the boundary walls !! The height of the wall needs to be a staggering 2m. As per the original estimate, it will take 1 week to build one side of the boundary and cost $1000 per side. So, your original budget (BAC) is $4000 and you have 4 weeks to complete the project. Without further ado, let's get on with laying the bricks.
Now let's look at 4 scenarios and the corresponding equations to calculate EAC.
-
Original estimate is no longer valid. Either the original estimate was fundamentally flawed or is no longer valid due to change in circumstances (for example change in scope).
EAC = AC + bottom-up ETC
Let's say at the end of the Week 1, you completed one side of the wall and the cost came out to be exactly $1000. However, your customer asks you to raise the height of the walls by another 0.5m, but still complete the project within 4 weeks. You re-estimate the costs. You need to buy more raw material and hire more workers. For the side already completed, you need another $500 to raise its height by another 0.5m. For the remaining 3 sides, you need $1500 per side.
Estimate To Complete (ETC) the remaining work = $500 + 3 * $1500 = $5000
EAC = 1000 + 5000 = $6000
-
The current cost performance (CPI) will continue in the future.
EAC = BAC / CPI
Let's say after completing the first side, you spent $1200 instead of the original estimate of $1000/side. The increased cost was due to the fact that it required more raw material to build the wall than what you originally estimated. You think that you are likely to spend $1200 for each of the remaining 3 sides as well.
CPI = EV / AC = 1000 / 1200 = 0.833
EAC = 4000 / 0.833 = $4800
-
The current cost performance is atypical for future project work. Future cost performance will be in line with the original estimate.
EAC = AC + (BAC - EV)
Let's say after completing the first side, you spent $1200 instead of the original estimate of $1000/side. However, the extra $200 were spent because of an accidental damage to the first side. You implement a risk mitigation plan to avoid this risk for the remaining work. You still believe that $1000/side is a good estimate for the remaining 3 sides.
EAC = 1200 + (4000 - 1000) = 1200 + 3000 = $4200
-
Project needs to meet a deadline. This following equation takes into consideration the schedule performance (SPI) and cost performance (CPI) to date.
EAC = AC + (BAC - EV) / (SPI * CPI)
Let's say by the end of Week 1, you built only 1.6m (instead of 2m) of the first side (or 80%) and you spent $1200 on it. So, you completed $800 (EV) of work, spent $1200 (AC) on it, when you were supposed to complete $1000 (PV) worth of work. However, you still need to complete all 4 sides in 4 weeks. You might even have to hire extra workers to meet the original schedule of 4 weeks.
SPI = EV / PV = 800 / 1000 = 0.8
CPI = EV / AC = 800 / 1200 = 0.66
EAC = 1200 + (4000 - 800) / (0.8 * 0.66) = $7200
Image Credit: Flickr / Giuseppe Bognanni
Related article:



















16 comments: