Answered by:
How the Work Percent Complete is computed for a Task with only cost type resources
Question

Hi,
We have a manual task (fixed units) with 5 days duration and 0 as the work and 0 as the actual work with the following cost type assignments.
Airfare  1000 (cost)  900 (actual cost)  100 (remaining cost)
Meals  (50)  0 (actual cost)  50 (remaining cost)
The Work Percent Complete shows as 45% for the tasks. I don't have any clues how MSP is calculating this value?
What is the logic used by MSP to derive this value?
Thanks,
Murali
Answers

Hi,
The calculation is quite simplistic for manually schedule task. You have 90% for the first task and 0% on the 2nd, thus 90% on 2 cost assignments. Thus Project proposes 90/2=45% completed.
If the task was autoscheduled, Project automatically spreads the actual cost on the duration based on the (planned) cost. Consequently it calculates an actual duration and divides it by the duration for %complete calculation.
Hope this helps,
 Marked as answer by Murali Vendra Wednesday, January 11, 2017 4:35 PM

Murali,
Yeah, that is an interesting and confusing metric. First of all, there is no work so you might expect percent work complete to be zero. In the case of a cost type resource you can mentally convert percent work complete to percent cost complete.
For your example, how does it work? It is easier to understand if you look at the Resource Usage view and display the Cost, Actual Cost, and Percent Work Complete fields. For the airfare assignment you will see the percent work complete is 90% ($900/$1000) and for the meals assignment, the percent work complete is zero. Since there are two assignments for the task (i.e. airfare and meals), the total percent work complete is 90%/2 = 45%
Hope this helps.
John
 Marked as answer by Murali Vendra Wednesday, January 11, 2017 4:36 PM
All replies

Hi,
The calculation is quite simplistic for manually schedule task. You have 90% for the first task and 0% on the 2nd, thus 90% on 2 cost assignments. Thus Project proposes 90/2=45% completed.
If the task was autoscheduled, Project automatically spreads the actual cost on the duration based on the (planned) cost. Consequently it calculates an actual duration and divides it by the duration for %complete calculation.
Hope this helps,
 Marked as answer by Murali Vendra Wednesday, January 11, 2017 4:35 PM

Murali,
Yeah, that is an interesting and confusing metric. First of all, there is no work so you might expect percent work complete to be zero. In the case of a cost type resource you can mentally convert percent work complete to percent cost complete.
For your example, how does it work? It is easier to understand if you look at the Resource Usage view and display the Cost, Actual Cost, and Percent Work Complete fields. For the airfare assignment you will see the percent work complete is 90% ($900/$1000) and for the meals assignment, the percent work complete is zero. Since there are two assignments for the task (i.e. airfare and meals), the total percent work complete is 90%/2 = 45%
Hope this helps.
John
 Marked as answer by Murali Vendra Wednesday, January 11, 2017 4:36 PM

