Forum Discussion

PM_BPB's avatar
PM_BPB
Copper Contributor
Apr 18, 2024

Resource planning

Hello,

I have recently started using resources planning in MS Project. However, when I mark a task as completed, the cost table does not show the cost of staff per hour in the actual cost column. It shows the cost as variance. I’m not sure how to fix this issue. I need this for my weekly project cost updates. Thanks for your help as I learn more about this feature. 

  • John-project's avatar
    John-project
    Apr 20, 2024

    To those who may follow this thread:
    The user sent me the file, I examined it and found the reason for the problem. I feel the answer is worthy of explanation for the benefit of all users.

     

    The user's file had an issue of a link on a summary line but that was easily fixed and had no bearing on the reported problem. All tasks were auto-scheduled, resources properly identified and assigned, and a baseline set.

    The user updated task progress and cost solely by entering a value in the % Complete field. The result was the value in the Cost field was being "transferred" to the "Cost Variance" field. The issue: why did that happen?

    Before progress update:

    After progress update: Note the absence of actual cost values for the two updated tasks

    What I found was the user's options were set for Project to NOT automatically calculate costs.

    With the option off, a user must input actual cost values. But, as noted above, no actual cost values are entered. In Project the Cost field = Actual Cost + Remaining Cost. Since there are no entries for actual cost or remaining cost, when the task was declared complete, (or partially complete), the value in the cost field is decremented by the percent complete value. And, since the Baseline Cost captured the original Cost field value, the Cost Variance, which is calculated as Cost minus Baseline Cost, reflected the negative value.

     

    The solution is to either set the option for Project to automatically calculate actual costs, or to manually enter an actual cost value when task progress is updated. With the option set, this is the result.

    John

  • John-project's avatar
    John-project
    Silver Contributor
    PM_BPB,
    First of all, what version of Project are you using (i.e. standalone desktop 2019, Project Online, Project for the Web, etc.)?

    How are you marking a task as complete? And where do you see the variance? Some screen shots showing the "cost table", "actual cost column" and "variance" would be helpful.

    John
    • PM_BPB's avatar
      PM_BPB
      Copper Contributor
      Thanks for your reply John-project.
      I’m using the desktop version but I also have the option of importing into project on web.
      I mark as task as completed by going into task tab and marking it as 100% complete.
      I see the cost variance in view- tables - cost and also in Report - cost - task cost overview.
      It only happens for cost of work and works properly for cost of materials.
      • PM_BPB's avatar
        PM_BPB
        Copper Contributor

        John-project

        when I mark these two task costing $222 each, project adds it to variance column rather than actual cost column. 

Resources