calculation EAC of unstarted tasks
-
23. května 2012 16:20
Hi everybody,
could you please help me with calculation EAC of unstarted task.
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?
Thank in advance.
Všechny reakce
-
23. května 2012 17:29Moderátor
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
- Označen jako odpověď Lopy 24. května 2012 5:24
-
24. května 2012 1:36Moderátor
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
-
24. května 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