登入
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
calculation EAC of unstarted tasks

Answered calculation EAC of unstarted tasks

  • 2012年5月23日 下午 04:20
     
     
    登入以投票
    0

    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.

     

所有回覆

  • 2012年5月23日 下午 05:29
    版主
     
     已答覆
    登入以投票
    1

    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

    • 已標示為解答 Lopy 2012年5月24日 上午 05:24
    •  
     
  • 2012年5月24日 上午 01:36
    版主
     
     
    登入以投票
    0

    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
     
     
    登入以投票
    0

    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