As projects progressesprogress, the project manager might want to get a real-time view of his resources' work loads based on actual approved time. This report provides visibility of free resources & helps the PM adjust allocations to ensure optimal resource utilization.
This report is a dynamic report that displays the Free hours for resources (resource row) and real-time estimated hours based on actual-approved hours and remaining work at the task and project rows. For past dates, the free hours are based on the actual-approved hours, whereas for present & future dates, the remaining work is computed real-time and spread proportional to the resource's availability.
Lets take an example:
A resource Arnold is assigned to a task 'Project KickOff'
- Task Schedule: From 11th to 13th in a month i.e 3 days
- Allocation: 50%
- Work: 12h (Work)
- Allocation: 50%
So, the allocation for Arnold (Hours (Est)) the Planned Hours will be divided across the planned dates for the task according to availability and allocation (50%) which is as follows:
11th | 12th | 13th |
|---|---|---|
| 4 | 4 | 4 |
Arnold fills time-entry of 4 hours for 11th. Today is 12th, 12 :00 PM. PM. This is reflected on 11th (past) for that task row. The remaining effort for the task is now (12 - 4) = 8 hours, which will be spread over today and future duration of the task proportional to Arnold's availability.
As 4 hours of Arnold's working time as today has already passed (8AM-5PMelapsed (regular working times: 8 AM-5 PM), the remaining available hours for today is 4 and for next day is 8. So, Arnold is available 12h 's remaining availability is 12 h to complete the 8h 8 h of remaining work for over the planned dates remaining duration of the task.
So, todayToday(12th at 12:00 PM), Arnold will have to do 2.7h 7 h of work in 4h
i, i.e For 8 hours of remaining work, Arnold is available for 12 hours. So, how much work should he do for 4 hours of availability? (8*4)/12=2.7
And remaining 5.3h (8-2.7) on is for 13th for this task.
So, for Arnold, remaining availability (free hours) for the dates is as follows:
11th (past) | 12th (present) | 13th (future) |
|---|---|---|
| 4 (8-4 approved hours) | 2.7 (8-5.3) | 5.3 (8-2.7) |
| Info |
|---|
If a task is completed before schedule (i.e. %Complete = 100%) then the remaining work (if any) will not be spread over the future duration of the task. |