Assigning multiple Resources to a Task in Microsoft Project

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!

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s