Percent Allocation shown as Average in Resource Usage View with Groups used

  • Thread starter Dale Howard [MVP]
  • Start date
D

Dale Howard [MVP]

Ahmad Khan --

The Percent Allocation field is calculated by Microsoft Project as Work/Work
Availability. For a typical resource, the Work Availability in any time
period is 8 hours. Thus, if I assign Mickey Cobb to work 2 hours on Monday
when she her Work Availability is 8 hours, then her % Allocation for that
day is 25% (2 divided by 8).

Assume that Mickey Cobb is in the TechEd group with four other team members.
If I group the resources on the Group field in the Resource Usage view, I
can see the % Allocation for the entire group for each time period.
Continuing with this example, the team members are assigned to the following
Work values on Monday:

NAME WORK % ALLOCATION
Carmen Kamper 2 hours 25%
Helen Howard 4 hours 50%
Jeff Holly 8 hours 100%
Mickey Cobb 2 hours 25%
Renee Hensley 0 hours 0%

Adding the values in the Work column, we see that the group has a total of
16 hours of Work assigned to all team members on Monday. Therefore,
Microsoft Project calculates the Percent Allocation vaue for the group for
Monday as 16 divided by 40 or 40%. Therefore, you assumption about how the
software calculates the Percent Allocation is incorrect. Because of this,
now I think you can see that there is no way to sum the values of each team
member to get a group total. Hope this helps.
 
A

Ahmad Khan

Hi All,
In MSP 2003: In the Resource Usage view, if I group the resources by
Worker Classification (or any other field). Now on the right side I
display the "Percent Allocation" field. The problem is that on the
individual resource level the value for 'Percent Allocation' is
correct. But if I look at the Group level, I find that the Percent
Allocation is not added up for all the resources in a group, rather
it's AVERAGE is displayed!

I find that strange, because for all other fields I have seen a sum of
all the resources on the group level rather than the average.

Can anyone tell me how to display the SUM of Percent Allocation field
on the group level rather than average? Or if thats the way its
supposed to be then whats the rational behind it?

Thanks
Ahmad Khan.
 
Top