calculation EAC of unstarted tasks

# calculation EAC of unstarted tasks

• woensdag 23 mei 2012 16:20

Hi everybody,

Here are my data.

 Task Name VAC SV Planned Value - PV (BCWS) Earned Value - EV (BCWP) AC (ACWP) CV EAC BAC Fixed Cost Remaining Duration Baseline Duration CPI Testing -¥1 880,00 ¥0,00 ¥0,00 ¥0,00 ¥0,00 ¥0,00 ¥10 880,00 ¥9 000,00 ¥0,00 8 days 8 days 0

Current CPI of whole project is 0,97.

The equation should be like this:

EAC = AC +(BAC - EV) / CPI.

Parameters of unstarted task are:

AC = 0, EV = 0, how about CPI? CPI of unstarted task is 0. BAC = 9000

I got the problem. In MS 2010 project, the task which hasnt started, which has remaning duration eqaul to baseline duration has higher EAC than BAC and i can't find out why. Could you please explain it?

### Alle reacties

• woensdag 23 mei 2012 17:29
Moderator

Hi,

By design and logic any task which has Future Start Date (also Future Baseline Start) doesn't gets considered in EV Calculation.

As you mentioned that EAC is greater then BAC in your plan for future task - it could have happened that BAC was manually edited to a lower value then initially planned. Since EAC is not editable it remained same as when plan got Baselined, having said that it implies that BAC is editable and could have been tampered.

Sapna S

• Als antwoord gemarkeerd door donderdag 24 mei 2012 5:24
•
• donderdag 24 mei 2012 1:36
Moderator

EAC is usually BAC / CPI - which is the same as your formula if you reduce it a bit.

If CPI is 0, then I am not sure how BAC is calculated, but my guess is that if CPI = 0, BAC = Cost.

If I am correct, then you should have 10,880 in the Cost field.  Your EAC should recalculate when CPI > 0.

Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky

• donderdag 24 mei 2012 13:41

Hello,

Check the resources you've got assigned to the task now are the same as the resources that were applied at the baseline, and that the rates haven't changed since the baseline was struck.

Use the task usage view, and next to the Work column add in the columns:

• Baseline Work
• Cost
• Baseline Cost

You might be able to see where the discrepancy has come in from this view by looking at the paired columns.

Hope this helps,

Andrew