How Resource Projected Utilization Is Calculated
The Update Resource Utilization Data process updates projected utilization for individual resources and resource pools for the current week and cumulative intervals for the next 2 weeks, 4 weeks, 8 weeks, and 13 weeks.
Run the Update Resource Utilization Data process often enough to account for:
-
New resources or assignments
-
Changes to resource pool membership dates
-
Changes to resource calendars
Factors That Affect Resource Projected Utilization
The following factors affect Resource Projected Utilization.
-
The Update Resource Utilization Data process defines a week as Sunday through Saturday. The current week includes all 7 days from Sunday through Saturday, regardless of the day that you run the process.
-
If you run the Update Resource Utilization Data process after Sunday, the first day of the current week is the preceding Sunday.
-
If you run the process on Sunday, the current week begins that day.
-
-
A resource's available hours are based on the resource calendar. An example of a resource calendar is Monday through Friday, 8 hours a day. The application doesn't consider company holidays when determining a resource's available hours.
-
The number of hours that a resource is assigned to work on project assignments includes assignments that are in a status of Confirmed, Reserved, or Pending Adjustment.
-
The Update Resource Utilization Data process calculates projected utilization for all resources who are current members of a resource pool except for the Inactive Resource Pool Memberships pool.
How Resource Projected Utilization Is Calculated
Projected utilization is calculated for individual resources in a resource pool and rolled up to a projected utilization for the pool.
To calculate a resource's projected utilization for the current week and the next 12 weekly intervals, the Update Resource Utilization Data process divides the number of hours that a resource is assigned to work on project assignments each week by the number of available hours for the resource that week.
The process also calculates cumulative projected utilization for the 13 week period. For example, the process calculates projected utilization for a 4 week interval by dividing the sum of hours that a resource is assigned to work on project assignments by the number of available hours for the resource for the current week and the next 3 weeks.
On the Resource Manager Dashboard you can view projected utilization for resources or resource pools for the current week and cumulative intervals for the next 2 weeks, 4 weeks, 8 weeks, and 13 weeks.