Forum Discussion
Resource planning
- 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
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.
when I mark these two task costing $222 each, project adds it to variance column rather than actual cost column.
- John-projectApr 18, 2024Silver Contributor
Sorry but your "screen shots" do not provide enough information. I'd like to see a screen grab (not a picture from your phone) of your Gantt Chart view showing: Indicators, task ID, name, duration, % complete, start, finish, cost, baseline cost, resource names. I'd also like to see your Resource Sheet.
The two tasks at $222 highlighted in your photo have no cost associated with them. All I see is a baseline cost. So if you declared them as 100% complete, there is no "actual cost" because there is no cost. But, because there is a baseline cost value, the 100% complete will result in a negative cost variance.
Based on what I can see from your photos I wonder if you are misinterpreting the various cost fields in Project.
John
- PM_BPBApr 19, 2024Copper Contributor
- PM_BPBApr 19, 2024Copper Contributor
Hi John,
Thanks for your response. As soon as I mark those two highlighted rows as completed, it automatically moves the cost from "Cost" column to "Cost Variance" column.
- John-projectApr 19, 2024Silver Contributor
PM_BPB,
Something is really wrong with your file. I cannot fathom any scenario wherein Project will react the way you describe.
I do see one issue with your file. You have a link on a summary line (i.e. predecessor ID 2 on summary line "Document project one-pager"). In your scenario it is totally redundant but good practice says there should NEVER be predecessors or successors on any summary line.
From what you have presented I see nothing obvious that would cause the behavior you describe. I suspect file corruption. To clear that I suggest you do the following:
1. Zero out any % Complete values wherein the cost value is altered (i.e. revert the file back to its condition before the errant behavior if possible).
2. Save your file as XML.
3. Re-open the XML file in Project. Note, you will lose any custom formatting.
4. Set the tasks of interest to 100% complete.
Does the issue still occur? If it does, are you willing to send me you file so I can take a look? If so, I'll tell you how to send it to me.
John