PROJECT MANAGEMENT TRAINING AFRICA
  • Home
  • About
    • Who is PMTA?
    • Trainer >
      • Dave Fourie
    • Clients
  • Courses
    • PMP/CAPM exam preparation
    • CEPM - Construction and Engineering Project Management
    • Best Practice Project Management
    • MS Project 2010, 2013, 2016 and 2019
    • Quality management on Projects
    • Risks management on Projects
  • Downloads
  • Publications
  • Contact

Earned Value Management made simple.

3/1/2015

15 Comments

 
What are the building blocks we need for EVM? We need three basic pieces of information to do the calculations:
  • What have we scheduled to do up to date? – (PV)
  • What have we actually done up to date? – (EV)
  • What did it the work we have done actually cost us? – (AC)

Picture
The objective of this presentation is to make Earned Value Management (EVM) as simple and easy as possible, therefore we will only discuss the basic and most commonly used formulas. So let’s have a look what EVM is all about.

What is Earned Value Management?

EVM is a method for measuring project performance. It compares what is actually happening on the project against the approved baselines and helps us to answer questions such as:
  • Where are we on the project money and time wise?
  • Will we make it within budget and schedule?
  • What do we need to do to get back on track?
It is important to note that EVM does not measure in days, weeks or months - It measures in monetary terms. 
To determine this we need:
  • The project schedule indicating which portion of the project activities are planned to be done by this date as well as 
  • The estimated cost of each activity – The Budget at Completion or BAC of the activity.

Let’s assume that we have an activity that we estimate will cost $40K to complete. (BAC). Let’s also assume that we have only scheduled 25% of the activity to be done by the reporting date. The PV will then be 25% of the BAC, which is 25% of $40K = $10K.
Picture
How do we determine Planned Value (PV)?

We need to know what portion of the project is scheduled to be completed by the reporting date – normally referred to as “today”. 
 As time moves on we will see that the PV becomes more. Let’s now assume that the timeline has moved on and that by today we have scheduled 50% of the activity to be done. The PV will now be 50% of the BAC, which is $20K. At 75% scheduled the PV will be $30K. Once the reporting date is the same or later than the scheduled finish date of the activity it means that the total activity was scheduled to be completed by this date. Therefore the PV now becomes and stays the same as the BAC = $40K. The planned value is therefore that portion of the BAC estimate of the activity that is scheduled to be done by the reporting date.
How do we determine Earned Value (EV)?

EV is also based on the BAC of the activity. EV is determined by calculating what portion of the BAC has been done, irrespective of what portion was scheduled to be done. 
Picture
So what do we need to calculate EV? – We need to know:
  • The estimated total cost for each activity (BAC) from the budget, and 
  • The progress made with completing the activities (percent complete) – this we get from the  progress reporting.

Let’s assume that we have an activity that we estimate will cost $40K to complete. (BAC). Let’s also assume that we have already completed 25% of the activity by the reporting date. The EV will then be 25% of the BAC, which is 25% of $40K = $10K. The passage of time does not change the EV – only the amount of progress made in completing the activity. Let’s now assume that we have completed 50% of the activity. The EV will now be 50% of the BAC, which is $20K. At 75% completed the EV will be $30K. Once the activity has been 100% completed it means the EV now becomes and stays the same as the BAC, in this example $40K. The earned value is therefore that portion of the BAC of the activity that is completed, whether it was scheduled to be done or not.

How do we determine Actual Cost?
The Actual Cost is the amount that it actually cost to do the work that was done to date.  AC is not based on BAC. AC does not depend on what portion was scheduled (PV). AC is influenced by EV in as far as that there should not be a value for AC if EV is zero, in other words only when some work is done there should be values for AC and EV although these two values can differ vastly as AC can be less, the same as or more than the EV amount.

Picture
How do we determine the variances?

How do we calculate the variances on the project? In other words how do we determine how our time and cost performance measures against our baselines? Let’s assume that we have a project with the following measurements: We have planned to do $40K worth of work (PV), we have done $40K worth of work (EV), and it actually cost us $40K to do the work (AC).

Even without the use of formulas we can see that in this example the project is exactly on schedule and on budget, but let us look at the variance formulas.

 What will the schedule variance (SV) be?  SV is determined by comparing what we have done (EV) with what we have planned to do (PV). Therefore SV = EV – PV. In this example SV = $40K -$40K and that equals 0. In other words no schedule variance as we are on schedule.

How would we determine the cost variance? CV is determined by comparing what we have done (EV) with what it cost us to do it (AC). Therefore CV = EV – AC. In this example CV = $40K - $40K and that equals zero indicating that we have no cost variance as we are exactly on budget. 
Picture
Let’s now assume that we have a project where we:
  • Planned to do $20K worth of work (PV).
  • Have done $30K worth of work (EV).
  • The work actually cost us $40K.

In this case the SV = $30K (EV) - $20K (PV) that gives us $10K indicating we are ahead of schedule.

The CV = $30K (EV) - $40K (AC) that gives us minus $10K indicating that we are over budget.
How do we determine the Indices?

Let’s assume again we have a project where the PV, EV and AC are exactly the same on $40K. From the variance analysis we saw that the project was on schedule and on budget. For calculating indices we again only use PV, EV and AC – but as we are now looking at the relationship between them and not the variance, we divide EV by PV for the Schedule Performance Index (SPI) and divide EV by AC for the Cost Performance Index (CPI). Here we see that SPI = EV / PV and that gives us $40K / $40K = 1. A SPI of 1 means that our schedule progress on the project is exactly as we have planned. Therefore we are progressing at 100% of the rate scheduled. CPI = EV / AC and that gives us $40K / $40K = 1. A CPI of 1 means that for every $1 we invest in the project we are making $1 worth of progress. Therefore we are exactly on budget
Let’s assume that the measurements on our project are now PV = $40K, EV = $30K and AC = $33K.

The SPI = EV / PV. Therefore it is $30K / $40K = 0.75. The SPI of 0.75 indicates that we are only progressing at 75% of the rate as per the authorised schedule. We are therefore behind schedule.

The CPI = EV / AC. Therefore it is $30K / $33K = 0.91. The CPI of 0.91 indicates that for every $1 we invest in the project we are only progressing 91 cents worth of work. We are therefore over budget.

Picture
How can we use EVM to do forecasting?

The most commonly used forecasts are:
  • ETC – how much money do we need to complete the rest of the project?
  • EAC – how much will the project cost us in total?
  • VAC – how much will we be over or under budget at the end of the project?

How do we determine the Estimate to Completion?

Picture
The Estimate to Completion (ETC) is a forecast of how much money we need to complete the project.

If we have a forecast of how much money the project is going to cost in total (the EAC figure), we can subtract how much we have already spent on the project. In other words ETC = EAC – AC. We will see just now that there are various ways we can forecast the value of EAC.


In the example above the BAC is $60K and the forecasted EAC is $66K. Therefore $66K (EAC) - $33K (AC) = $33K (ETC). In other words our latest estimate is that we need $33K to complete the project. 

Another way is to re-estimate all the work that still needs to be done on the project. This can be more accurate but also a much more time consuming estimate. Should we not have enough of the original budget left to cover the forecasted ETC, we will have to decide what corrective actions are required, if any.

How do we determine the Estimate at Completion?

The Estimate at Completion is a forecast of how much we at this stage estimate the total project will cost. One way to calculate EAC would be to determine what the estimated worth of the uncompleted tasks are (BAC – EV) and then add what we have already spent on the project (AC) to that. That would give us a formula where EAC = (BAC – EV) + AC.
Picture
In the example BAC = $60K, EV = $30K and AC = $33K. Therefore EAC = ($60K – $30K) + $33K = $63K. This method assumes that all uncompleted work will be done at the budgeted rate in other words the future CPI will be 1.

Calculating EAC = BAC / CPI is also frequently used and here it is assumed that what we have experienced on the project to date will continue into the future. This method gives an EAC of $65.9K.  

We see the EAC is higher as our previous forecast. The reason for this is that up to now our cost performance was not too good (CPI = 0.91) and therefore if we continue this trend we will need a larger budget for the project.

If we know what ETC is we can add what we have already spent (AC) to the ETC to arrive at a forecasted EAC. Let us assume that we re-estimated the ETC to be $35K and AC is $33K. Therefore we will forecast an EAC of $68K for the project.

As previously stated re-estimating the ETC can be more accurate but also more time consuming. This method takes our experiences on the project to date into account and the forecasted ETC also takes applicable risk responses and corrective actions into consideration.

How much will the budget to be over or under (VAC)?

Variance at Completion, what we normally refer to as how much will we be over or under budget at completion, is calculated by subtracting EAC from BAC. Therefore VAC = BAC – EAC. The forecasted value of the VAC will obviously depend on our forecasted value of EAC. If for example BAC = $60K and EAC = $68K then VAC = $60K (BAC) - $68K (EAC) indicating that we forecast the project to exceed the approved budget by $8K. Using one of the other methods to calculate the EAC, we will obviously calculate a different value for VAC.

Please take note that there are much more to EVM – this discussion only covered the most basic aspects.

15 Comments
Darrel Raynor link
3/1/2015 11:23:26

Nice piece, added to my list of references for my students. Let me know if you need any help there, love to visit Africa again! We do PM, Business Analysis, Leadership, and intro courses for Data Analysis and Lean Six Sigma, as well as full range of consulting.

Reply
Dave link
3/1/2015 14:11:52

Thanks Darrel. Thanks also for the offer to help - will keep that in mind1

Reply
DrPDG link
3/1/2015 20:33:02

Hi Dave,
Couple of comments-
#1) Why are you using PMI's acronyms when just about everyone else, including MS Project continue to use ACWP, BCWP and BCWS?

#2) Why don't you EXPAND your course to include ALL the EVM metrics as shown on the DAU Gold Card? https://acc.dau.mil/CommunityBrowser.aspx?id=19577

#3) You missed perhaps one of the most important aspects of Earned Value and that is to link work performed to prompt payment. Go HERE http://pmworldjournal.net/wp-content/uploads/2013/07/pmwj12-jul2013-giammalvo-practical-look-enterpreneurial-contractors-evm-FeaturedPaper.pdf and scroll down to figure 1 on page 2 to see how earned value was originally designed to work. (Henry Gantt and Frederick Taylor for more on this important subject)

Bottom line- IF you are going to teach Earned Value, then doesn't it make sense to teach it COMPLETELY? "A little bit of knowledge can be a dangerous thing......"

BR,
Dr. PDG, Jakarta

Reply
Dave link
3/1/2015 23:58:07

Hi Dr. Paul,

Thank you for your valuable comments. As stated in the first and last sentence of my discussion it is intended to only include the basic and most commonly used formulas as the intended audience are those people who find EVM extremely challenging. I am sure that your comments are of great value for those that understand the basics of EVM.

Regards,

Dave.

Reply
DrPDG link
4/1/2015 03:23:09

Understood Dave but one of my arguments has long been that BECAUSE people like us focus ONLY on PART of the picture, is the root cause WHY so many people find EVM intimidating or confusing......

In other words, by trying to OVER SIMPLIFY things (like using PMI's AC, EV, PV) we are actually making things MORE confusing and harder to understand......

I am shocked at how few people even know or understand that Earned Value originated on the factory floors of the 17th and 18th century sweat shops in the form of "earned time" or "piecework". Thus the whole concept of "earned value management" is based on "pay for performance" and yet I am astounded to find out how many supposedly sophisticated users (INCLUDING my own US Government!!!) have disconnected payment from performance......

And who is to blame for allowing this to happen? Educators who themselves neither know or fully understand how to apply EVM along with organizations such as PMI who publish only part of the story.....

Bottom line- PLEASE, if you are going to teach EVM then tell the WHOLE story and not just part of it.... Otherwise what you end up with is the 7 blind men describing the elephant.....

BR,
Dr. PDG, Jakarta, Indonesia
http://www.build-project-management-competency.com

Reply
John
4/1/2015 10:15:39

Very helpful.. Thanks

Reply
Dave link
4/1/2015 14:23:08

Thanks John.

Reply
Carig
4/1/2015 21:18:52

Good Job !! Well presented.
Thanks
Craig

Reply
Dave link
4/1/2015 22:24:59

Thank you Craig, much appreciated.

Reply
Philip
5/1/2015 02:26:55

Thanks, this is a great article, well presented, structured, ans easy to follow.

Reply
Dave link
5/1/2015 02:47:46

Thanks Philip - I really appreciate the feedback.

Reply
Mohammed Abdul Kaleem link
28/1/2015 02:52:07

Its really a very good presentation.
How do we determined the estimation to completion?.
ETC=EAC-AC which is incorrect. as per the data given AC=$33K.
Where as it is written as $60K.
It is supposed to come ETC=EAC-AC
ETC=$66K-$33K=$33K

Thanks once again for good presentation.

Regards
Mohammed Abdul Kaleem

Reply
Dave link
28/1/2015 13:25:44

Hi Mohammed - You are correct, I have used the wrong figure in the calculation. I have now updated the blog. Thank you for making me aware of it.

Regards,
Dave

Reply
DrPDG link
28/1/2015 04:12:26

Actually the formula is wrong. If you look at the DAU Gold Card https://acc.dau.mil/adl/en-US/19577/file/59124/gold%20card%20one%20sided%20November%202010.pdf there are two formula:

Estimate @ Completion = Actuals to Date + [(Remaining Work) / (Performance Factor)]
EACCPI = ACWPCUM + [(BAC – BCWPCUM) / CPICUM]

EACComposite = ACWPCUM + [(BAC – BCWPCUM) / (CPICUM * SPICUM)]

There is a third formula that contractors often use which tends to be the most ACCURATE method and that is ACWPCUM + ETC (Estimate to Complete) = EAC

BR,
Dr. PDG, Jakarta, Indonesia

Reply
Marie link
2/1/2021 01:59:00

Great post, thank you

Reply



Leave a Reply.

    Author

    Dave Fourie - freelance project management trainer.

    Archives

    March 2015
    February 2015
    January 2015
    December 2014

    Categories

    All

    RSS Feed

    Subscribe and be the first to be informed of new blog posts and free downloads!

    * indicates required
    Email Format
Powered by Create your own unique website with customizable templates.