How is % complete calculated with multiple resources
Featured Partner
Top Posters
Zine Eddine
2 posts
Alex Lyaschenko
27 posts
mxsiegel
0 posts
Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts
Jeamiell Ostrovsky
2 posts
Our Partners
In MSP, % Complete is about Duration.
% Complete = Actual Duration/Total Duration.
It has nothing to do with the Resources and it makes no difference whether zero or 50 Resources are assigned to a Task.
It also has nothing to do with the Cost($) or the Work (Hours), although Cost and Work will both be calculated from % Complete if that option is set.
It especially has nothing to do with how much of the "Task" has been done or remains to be done.
Each of Duration, Cost and Work, and the Task itself (ie 4 things) have a total, actual, remaining and %.
In MSP only % Duration Complete (ie "% Complete") and % Work Complete are built-in fields, but % Task Complete and % Cost Complete can also be readily calculated in spare fields.
So, eg, you might set out to lay 10000 bricks in 10 Days, with one bricklayer for 80 Hours at $50/hour and 10000 bricks at $1/brick ($14000).
At the end of Day 6, % Complete = 60% and you expect 6000 bricks or 60% of the Task to be done, at a Cost of 60% of $14000, and Work = 60% of 80 Hours (48 Hours).
Leaving out Cost and Work for a moment, and considering just the Duration and the bricks,...
Suppose you find that only 3000 bricks have been laid?
After you type in 6 Days in Actual Duration, and since Total Duration = 10 Days and Remaining Duration = 4 Days, % Complete = 60%. You dont have to type in the % Complete and shouldnt, because MSP calculates it for you.
Since you discover that your initial 10 Day estimate was way low and/or your bricklayer is not as good as you hoped, you must re-estimate the Remaining Duration, ie you are laying bricks at 500/day instead of 1000/day and 7000 bricks remain, so Remaining Duration is 14 Days.
After you type in 14 Days in Remaining Duration, % Complete = 30%.