# calculation EAC of unstarted tasks

• 2012年5月23日 下午 04: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.

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?

### 所有回覆

• 2012年5月23日 下午 05:29
版主

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

• 已標示為解答 2012年5月24日 上午 05:24
•
• 2012年5月24日 上午 01:36
版主

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

• 2012年5月24日 下午 01: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