quarta-feira, 23 de maio de 2012 16:20
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.
Todas as Respostas
quarta-feira, 23 de maio de 2012 17:29Moderador
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.
- Marcado como Resposta Lopy quinta-feira, 24 de maio de 2012 05:24
quinta-feira, 24 de maio de 2012 01:36Moderador
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
quinta-feira, 24 de maio de 2012 13:41
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
- 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,