As physical % complete does not roll-up summary tasks, I created a column called 'physical percent complete'. I think I need to link this column to Budgeted Cost of Work Performed (BCWP), just so I can have a more accurate Equivalent Annual Cost (EAC) based on the physical percent complete.

I have tried creating a new column and adding the formula:

baseline cost * physical percent complete

though it does not want to work. My plan was to then create another column for 'estimated at completion' based on the result from previous formula.

Does anyone have an idea on how I can achieve a more accurate EAC based on the customised column for physical percent complete?

Thank you.

  • Had to guess on the acronyms. If they're incorrect, please correct them. – Sarov Feb 13 at 14:09
  • The acronyms are the actual field names in MS Project and as such should not be changed. FYI: EAC = Estimate At Completion. – Rachel Hettinger Feb 13 at 19:20

BCWP is a non-customizable field in MS Project. However, you can use a customizable field, such as Cost1 to add a formula that uses your other customized field, 'physical percent complete'.

Presuming you used Number1 for that field, enter this as the formula in Cost1:

[Baseline Cost]*[Number1]

Note that even if you override the label for Number1 to say 'physical percent complete', the formula still references the underlying field name, Number1.

Your Answer

 

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.