By Brett Pierce
I’m often asked this question when someone needs to understand how to report on time in Microsoft Project Server (EPM). Now they can read my blog and I can rather clear my inbox.
So lets say John and Tom are assigned to a 32 hour task on a project. John and Tom are both on 8 hour calendars in EPM. John and Tom are also set to a 100% assignment as well. This means that each resource will be assigned 16 hours of work (32 hours / 2 resources) and each resource will have the capacity to fulfill 8 hours of work per day. So the task itself will have a duration of 2 working days at 8 hours per day.
Still confused? Let’s look at the table below:
Task | Resource | Day 1 | Day 2 |
Task 1 | John | 8 | 8 |
Tom | 8 | 8 |
Both John and Tom can work 8 hours each per day, which means that 16 hours of work can be done on the task with both resources assigned to it.
Now lets say John is at 100% capacity and Tom is at 50%. This means that John can be assigned a full 8 hours of work every day, whereas Tom can only be assigned 4 hours of work per day. So John can perform twice as much work as Tom in a day. (wow, this is starting to sound like a grade school math problem).
With 12 hours of work being performed on the task each day (John = 8, Tom = 4), there will be 8 hours work remaining after two days. Because we have a 2:1 ratio between John and Tom, 2/3 of the work will be performed by John and 1/3 of the work will be performed by Tom.
Task | Resource | Day 1 | Day 2 | Day 3 |
Task 1 | John | 8 | 8 | 5.33 |
Tom | 4 | 4 | 2.67 |
I hope that explains it!