again one interest question from my Blog reader:
Thank you VERY much for your very informative blog! I enjoy reading your posts and visit the site often. I would appreciate if you could answer my question regarding managing exceptions for resources with over 100% availability (I’m a Project 2010 user).
MS Project allows creating resources with over 100% maximum availability. For example, a resource Tester with max availability of 300% means that this is a group of 3 people.
Let’s say that I have assigned this resource to a task. At a later time I found out that one of the people in this group will be unable to work on a 2 specific dates due to medical appointments.
Under normal circumstances, I would edit a resource calendar and specify these dates as an exception (non-working time). However, doing this for the Tester resource takes makes all 3 people unavailable for the dates of exception. One way of preventing this problem (rather than resolving it) is to specify 3 individual resources with 100% max availability each. However, it sort of defeats the convenience of using group resource (with over 100%). I was unable to find the answer to this problem so far anywhere and would appreciate it if you could provide some suggestions.”
I’ll show you how to do it in MS PROJECT 2013, but you can do the same in MS PROJECT 2010!
First I’ll create three Tasks with same duration:
Now I will crate Generic Resource, called Testers with 300% capacity:
Now suppose that one of Testers is on Vacation from Wednesday, 12/18/2013 to Thursday, 13/18/2013. What does it mean? It means that I’ll have only 200% max Units during this period. How to do that? Follow examples below:
As you can see before, and after Vacation period Capacity is 300%, and during the Vacation Period it is 200%. Now I’ll assign Testers to all Tasks, and I’ll get:
They are over allocated. Where, and when? Let’s look at the Resource Usage View:
As you can see all Resource are over allocated during the Vacation time!
Hope this helps!