How does MS Project calculates % Work Complete for the Cost Resource? RRS feed

  • Question

  • Hello,

    I added a Cost Resource to couple of tasks. Added some planned and actual costs for testing.

    The Resource Usage view shows the % Work Complete against Cost Resource but I cannot figure out how is it calculating it?

    Thank you and Regards

    Shaikh Tanzim Akhtar

    Tanzim Akhtar

    Thursday, July 10, 2014 8:40 AM

All replies

  • Tanzim --

    If you apply the Task Usage view, apply the Cost table, and then insert the % Work Complete column, you will see that the % Work Complete for the Cost resource is calculated using the formula:

    % Work Complete = Actual Cost/Cost x 100%

    Hope this helps.

    Dale A. Howard [MVP]

    Thursday, July 10, 2014 12:34 PM
  • Thank you Dale for the reply.

    I tried it before posting the question but it doesn't give me the correct value.

    If you see the image (Resource Usage view) that I attached in my original post, the Actual Cost is 7,790, Cost is 19,300 and % Work Complete is 37% for Cost Recourse name "CISCO Hardware" .

    However when I calculate it (Actual Cost/Cost) * 100 it gives me 40% (40.36).

    Tanzim Akhtar

    Thursday, July 10, 2014 1:16 PM