How To Calculate EAC & ETC With Typical CPI Trend?

  • Project Management
Created on :
September 1, 2014
iZenBridge
Updated on :
March 24, 2023
0 Comments
Blog-Image

When we evaluate our performance, we need to also forecast how much more money is needed in this project and what could be the revised budget. Revised budget is nothing but EAC (Estimate At Completion) which will be different from initial planned numbers i.e. BAC (Budget at completion). EAC and ETC (Estimate To Complete) can be calculated in different ways depending on the reason of variations. In this blog, I’m going to discuss one of its variants that are Typical.

Before we get into details of this blog, I just want to ensure that you have a good understanding of what is EAC and ETC. You may like to give a quick recap of my blog, ‘What is EAC & ETC and What are its Variants?’

Now let’s come to the variant typical or as defined in PMBOK® Guide  EAC forecast for ETC work performed at the present CPI. As per PMBOK® Guide.

This method assumes what the project has experienced to date can be required to continue in the future. The ETC work is assumed to be performed at the same cumulative cost performance index (CPI) as that incurred by the project to date

In other words, Typical means, Current variations are GOING to continue at the current CPI rate. Project, from this point on-wards, has to consider current CPI variations to forecast the revised budget of the project.

Let’s take an example and try to understand and discuss on an atypical variant of EAC and ETC. Let’s assume a Movers & Packers company took a project of shifting stuff from one place to another. The full project is planned for 5 hours as below:

PMP- atypical variant

There are total 4 activities booking, loading, unloading and completion & handover. Booking need 1 person for the first hour and will cost 1K, loading needs 5 persons for 2 hours so planned to cost 10000, Unloading needs 5 persons for 1 hour, so planned to cost 5000 and completion and handover needs 1 person for one hour so planned to take 1000. On the basis of this we have a BAC planned to be 17000 at the end of 5th Hour

Let’s access the situation at the end of 2nd hour of work. We have observed some variation to our plan as below:

CPI trend

The variation we faced in the above example is “labor not available”. As we are discussing typical scenario, we are sure that current variation is going to continue at current CPI rate e.g. There is full day local festival and labor cost will be on and off, current cost variation is going to continue at the same rate or are typical in nature. The rest of the work (ETC) will be done at CPI rate we have today. In this case we can calculate the EAC as

  • EAC = AC (already gone can’t do anything) + (BAC-EV) /CPI. In this (BAC-EV)/CPI is nothing but what is left to do i.e. ETC. ETC has taken current variations of CPI into account
  • We generally see simplified version of this formula. If we substitute the value of CPI = EV/AC in this we shall realize that we will get the formula for EAC = BAC/CPI.
  • EAC = AC+{(BAC-EV) * AC}/EV = AC [1+(BAC-EV)/EV]
  • EAC = AC [1+(BAC/EV) -1] = AC*BAC/EV = BAC/CPI = 17000/0.6667 = 25499.87
  • Don’t confuse with ETC ever. Whatever left after AC is ETC only and in this case (BAC-EV) /CPI = (17000-5000) /0.6667 = 17999

It’s very important to understand that if we have not faced any variations and we are going as per plan AC = EV i.e. CPI = 1 and our formula will automatically reduce to EAC = BAC i.e. we are on plan. Even if we put this in full formula, we shall get same result i.e. EAC = AC + (BAC-EV) /CPI = AC+BAC-EV/1 = BAC

You may wonder what to do if variations are not typical with the CPI trend? Yes, we have other ways of calculating EAC &ETC.

In a similar scenario where we observe the current variances are typical and both CPI and SPI variations are going to continue for the rest of the work, we need to consider CPI & SPI both in our calculations for EAC, for more details check out our blog on ‘How to Calculate EAC & ETC with Typical SPI & CPI  Trends?’

In a different scenario when we observe the current variance are the atypical i.e. current variances were one time and the rest of the work will be done at budgeted rate. We don’t need to consider variations in the rest of the work, for more details check our blog on ‘How To Calculate ETC When Variance Is Atypical?’

There could be a case where you find the initial estimate of the project having errors and these errors cannot be fixed just by taking into account the current variances. So what to do? Simple, we need to re-estimate for the remaining project duration.

Understanding this concept is very important from PMP® exam point. By now, you must have clearly understood ‘How To Calculate EAC & ETC With Typical CPI Trend.’ For further questions and doubts on the subject, drop us a comment on our Discussion Forum. You can also log into our YouTube channel watch the video on the related topics.

Enroll to our FREE PMP® Introductory Program to learn more about PMP® certification 
Name Date Place
PMP Certification and Training 18 Apr – 17 May 2024 Pune More Details
PMP Certification and Training 4 May – 2 June 2024 Chennai More Details