none
Actual cost calculations RRS feed

  • Question

  • Good morning, everyone,

    1.  I'm using MSP 2007 and noticed that the ACWP changes if I uncheck the "Actual costs are always calculated by Microsoft Office Project".  Why does this happen?

    2.  The ACWP definition states the calculation is done on the Status Date or the Current Date.  What is the order of precedence for this and when would it happen?

    Thank you.

    Roy

    Wednesday, September 21, 2011 12:58 PM

Answers

  • Hi Roy,

    You can refer to the help file of MS Project it provides details about impact of checking/unchecking this option. It says :

    Clear the check box if you want to turn off all calculations of actual costs by Project so that you can enter or import actual cost values manually. By default, this check box is selected.

    Further, if you uncheck the Actual Cost calculated by MS Project, then the "Edits to total actual cost will be spread to the Status Date" Check box becomes activated. [If you check this box, then the manual edits to assignment or Actual Cost fiels will distribute in time phased manner]. Edits to Actual Cost is distributed equally over time phased cells, starting after the last time in which time-phased Actual Cost was recorded through the Status Date OR Current Date if Status Date is not defined.

    Hope it answers both your points.


    Sapna S
    Wednesday, September 21, 2011 2:00 PM
    Moderator
  • 1.  If you uncheck the box, then you must manually enter actual costs.  you can see this experimentally if you create a task, assign a resource with a rate greater than $0.  Status the task as 50% complete and observe that the Actual Cost is greater than $0.  Now, uncheck the box, and observe that Actual Cost changes to $0.

    2.  If Status Date is not set (the value NA appears in the field), then the Current Date will be used.  Otherwise, the Status Date will be used.


    Reid McTaggart Partner DeltaBahn LLC
    • Marked as answer by Roy_Welch Thursday, September 22, 2011 12:26 PM
    Wednesday, September 21, 2011 2:01 PM

All replies

  • Hi Roy,

    You can refer to the help file of MS Project it provides details about impact of checking/unchecking this option. It says :

    Clear the check box if you want to turn off all calculations of actual costs by Project so that you can enter or import actual cost values manually. By default, this check box is selected.

    Further, if you uncheck the Actual Cost calculated by MS Project, then the "Edits to total actual cost will be spread to the Status Date" Check box becomes activated. [If you check this box, then the manual edits to assignment or Actual Cost fiels will distribute in time phased manner]. Edits to Actual Cost is distributed equally over time phased cells, starting after the last time in which time-phased Actual Cost was recorded through the Status Date OR Current Date if Status Date is not defined.

    Hope it answers both your points.


    Sapna S
    Wednesday, September 21, 2011 2:00 PM
    Moderator
  • 1.  If you uncheck the box, then you must manually enter actual costs.  you can see this experimentally if you create a task, assign a resource with a rate greater than $0.  Status the task as 50% complete and observe that the Actual Cost is greater than $0.  Now, uncheck the box, and observe that Actual Cost changes to $0.

    2.  If Status Date is not set (the value NA appears in the field), then the Current Date will be used.  Otherwise, the Status Date will be used.


    Reid McTaggart Partner DeltaBahn LLC
    • Marked as answer by Roy_Welch Thursday, September 22, 2011 12:26 PM
    Wednesday, September 21, 2011 2:01 PM
  • Thank you all for the answers.

    Roy

    Thursday, September 22, 2011 12:27 PM
  • You are most Welcome Roy :)
    Sapna S
    Thursday, September 22, 2011 12:50 PM
    Moderator