Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

As projects progresses, 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. 

 

Lets take an example:

A resource Peter Parker Arnold is assigned to a task 'Setup CubiclesProject KickOff'

  • Task Schedule: From 10th 11th to 17th 13th in a month i.e 6 3 days
  • Work: 12h 19h (Work)
  • Allocation: 25%50%

So, the allocation for Peter Arnold (Hours (Est)) will be divided across the planned dates for the task (12h / 6daccording to availability and allocation (50%) which is as follows:

...

16th17th
11th
12th
15th13th
4
4
222222

...

4

Arnold fills time-entry for of 4 hours on 10th and is approved. So, on 10th (past date), the real-time assignment for Peter on 10 is 4h. Now, the remaining work is 8h which is divided across the available duration of the task i.e. 8/4=2h from 12th of the month; excluding today.for 11th. Today is 12th 12:00 PM. 
As 4 hours of Arnold's working time as already passed (8AM-5PM), the remaining available hours for today is 4 and for next day is 8. So, Arnold is available 12h to complete the 8h of remaining work for the planned dates of the task.
So, today(12th 12:00 PM), Arnold will have to do 2.7h of work in 4h
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 13th for this task.

So, for Arnold, remaining availability for the dates is as follows:

11th
12th
13th
4 (8-4 approved hours)5.3 (8-2.7)2.7 (8-5.3)