Dear colleagues, I've notice an anomalous functioning ot remaining cost field in Ms Project. Below the description: I have one task with: 2 Cost resources (whose total "cost" is e.g. 180 Eur) 1 Work resource (whose std rate is 0 E/H and ovt the same) Fixed duration (1 Day). Bi clicking on "100% complete" button I'd expect that "Actual cost" equals "Cost" as "Remaining cost" should be 0 but it is not! Remaining cost is still 180 Eur. Do you know why?
To complete the picture, in case I remove "Work Resource" everything works perfectly. Saving Changes...
Sort By:
Stéphane ParentSelf Employed / Semi-retired| Leader MakerPrince Edward Island, Canada
Do you have the same problem if you update % Work Complete, instead of % Complete. (The latter is the percentage of the duration elapsed. This can be different than the percentage of wrok completed.) Saving Changes...
first of all thanks for your feedback.Yes, I've tried and the result unfortunately is the same. Saving Changes...
Drew CraigSr. Agile & Product Coach| VanguardPhiladelphia, Pa, United States
I wouldn't mix different resources on a single task. It seems the error may be from not using Work Resource properly, or as intended. From this resource “Calculating the cost of a material project resource in might take you back to solving problems in your old high school algebra class. Fortunately, Project 2016 makes a straightforward calculation to arrive at the cost of using a material resource.
When you assign a work resource to a task, Project multiplies its standard hourly rate by the hours of work for the assignment. But material resources don’t have hours of work: You pay for them by the unit quantity, not by the hour. So when you set up a material resource, you specify a standard rate for a single unit (per yard, or ton, or gallon, for example) and assign a certain number of units to each task. The cost is the number of units multiplied by the cost per use.”
And I found this too, which looks like it could prove more helpful. Resource Link URL Do not mix cost and work resources on the same task
“However, please be aware that when assigning a cost resource to a task, best practise dictates that cost resources should not be mixed with any other resources assigned to the task (note this is exactly what Microsoft’s blog article does do!) This is because, if a cost and work resource are assigned to the task, and progress is used to track the task (ie marking it 100% complete), then Project will update progress for the work resource and not for the cost resource. This is because Microsoft did not want you to inadvertently accrue the cost of the cost resource when progressing the task.
If you only have cost resources assigned to a task, then progressing the task (ie marking it 100% complete), will accrue the cost for the cost resource(s) assigned to the task.” Saving Changes...
Dear Andrew, thanks a lot for this precious material. Now I understood I was not following best practices. I agree it is better to separate tasks which may incorporate different types of resource. Unwanted accrual is a potential risk to keep as far as possibile. Saving Changes...
"Not all chemicals are bad. Without chemicals such as hydrogen and oxygen, for example, there would be no way to make water, a vital ingredient in beer."
