Hi,
In this blog I will demonstrate how can you set up different resource Availability to the same resource in MS PROJECT 2010.
I will make “set up” for my examples. First I will add two tasks.
TASK 1 will have 5 days duration and it will start at 16.06.2011 and it will finish at 22.06.2011. TASK 2 will have 10 days duration and it will start at 04.07.2011 and it will finish at 15.07.2011.
Now I will add two resources in the Resource sheet:
Finally I will Set up different Availability to each resource. I should open Resource table if I want to do that. I will choose RESOURCE 1 and I will make him available from 01.06.2011 to 20.06.2011 with 100% units (availability), and from 21.06.2011 to 30.06.2011 with 50% units (availability):
That means that RESOURCE 1 will be available only from 01.06.2011 to 30.06.2011 and he will work full time job until 20.06.2011, and part time job (4 hours) from 21.06.2011 to 30.06.2011
Now, I will choose RESOURCE 2 and I will make him available from 01.07.2011 to 10.07.2011 with 50% units (availability), and from 11.07.2011 to 15.07.2011 with 100% units (availability):
That means that RESOURCE 2 will be available only from 01.07.2011 to 15.06.2011 and he will work part time job (4 hours) from 01.07.2011 to 10.07.2011, and full time job from 11.07.2011 to 20.06.2011.
O.K. Now I will assign RESOURCE 1 to the TASK 1:
and I will get:
You can see little “RED MAN” in status column. It means that RESOURCE 1 is over allocated. If you open Team planner you will get:
RESOURCE 1 is over allocated at 21.06.2011 and 22.06.2011 because he is available only 4 hour per day (50%). If you open Resource usage sheet you will see over allocation at 21. and 22.06.2011:
What can I do with over allocation? First I can leave it: “AS IS”. It means that RESOURCE 1 will work 8 hours even it is not available. Or I can right click on status column and I will get:
First I will choose Reduce work and I will get (Open Resource Usage sheet):
You can see that the Task Duration remains same (5 days) but it will take less time at 21.06.2011 and 22.06.2011 (4 hours per day), because RESOURCE 1 is only 50% available at those days. That means that TASK 1 requires only 32 HOURS:
16.06.2011 –> 8 hours + 17.06.2011 –> 8 hours + 20.06.2011 –> 8 hours + 21.06.2011 –> 4 hours + 22.06.2011 –> 4 hours = 32 hours
If I choose Increase Duration I will get:
or, in Resource Usage View:
Task duration is increased for 2 days. Why? Because TASK 1 has initially 5 days duration, and that means 5 days X 8 hours / day = 40 hours. So if I want 40 hours of work and I RESOURCE 1 is available 8 hours / day from 01.06.2011 to 20.06.2011 and 4 hours / day after 20.06.2011 he will work:
16.06.2011 –> 8 hours + 17.06.2011 –> 8 hours + 20.06.2011 –> 8 hours + 21.06.2011 –> 4 hours + 22.06.2011 –> 4 hours + 23.06.2011 –> 4 hours + 24.06.2011 –> 4 hours = 40 hours.
If I choose Fix in Task Inspector I will get:
In Task inspector I can pick one of tree options. First two options are explained before, and the third option offers you to assign additional resource.
In my next blog I will show what happens if you try to assign RESOURCE 2 to the TASK 1 (e.g. when resource is totally unavailable).
See you!
Thank you.. but I have a problem when I move my start day of the project. the problem is that it still have the same resource Availability assingn even if the dates do not correspond!. for example:
resouce 1 _ 01.06.2011 to 30.06.2011 with 50% Availability assingned to task 1 _ 16.06.2011 and it will finish at 22.06.2011 and then I move my start day to 16,05,2011 and still keeps the 50% Availability. But the date do not correspond.
Thanks
Juan
Whne you assign resources to the Task, and than move the project to nwe Date, everything remains the same. Sorry, but that is how MS PROJECT works
Hello ! Thank you for this really well explained post ! I’m using ressources like you propose, to manage teams and I would like to import their availability (from… to… at xx%) from Excel. The avaibility changes everyday and is writen on an excel file for each ressource. Is their a simple way to do this operation ? I searched on the Internet but no one seems to need this kind of opération…
Anyway, your website is a big source of information for me.
Emmanuel
Hello! you can do it with macro like this (I didn’t try it):
Sub Test()
Dim R As Resource
For Each R In ActiveProject.Resources
R.Availabilities.Add “1/1/2012”, “2/1/2012”, 1
Next R
End Sub
Thank you..really informative!!
Wonderful, keep it up thanks.