Troubleshooting
Problem
This technote defines how the MM (Man Month) is calculated in the IBM® Rational® Portfolio Manager (RPM) Resource Utilization Monthly Pivot.
Resolving The Problem
The Actual MM in the Monthly Resource Utilization (RU) Pivot for a Project / Resource / Month (the fully expanded row) is calculated as Actual Work / Selected Month Availability.
For example:
A resource is available for 160 hours in April, 160 hours in May, and 160 hours in June.
This resource is assigned to a project, and as the only resource assigned to the project, for 40 hours in April, 160 hours in May, and 120 hours in June.
Actual was reported on this assignment for 40 hours in April, 160 hours in May, and 40 hours in June.
So, what you will see in the RU pivot is:
April - 40 hours / 160 hours = 25 % Actual MM
May - 160 hours / 160 hours = 100 % Actual MM
June - 40 hours / 160 hours = 25 % Actual MM
Grouping the pivot results using the Project ID and using the SUM function to aggregate the Actual MM column, you would see 150% or (25 + 100 + 25).
If you used the AVG function to aggregate the Actual MM column, you would see 50% or ((25 + 100 + 25) / 3).
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21240733