Setting Up Resource Availability to Apply at Different Times–Part two

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 repeat “setup” from my previous blog.

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.

image_thumb

Now I will add two resources in the Resource sheet:

image_thumb1

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):

image_thumb2

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):

image_thumb3

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 2 to the TASK 1:

image

and I will get:

image

You can see little “RED MAN” in status column. It means that RESOURCE 2 is over allocated. If you open Team planner you will get:

image

RESOURCE 2 is over allocated from  16.06.2011 to 22.06.2011 because he is available from 01.07.2011 to  15.07.2011. If you open Resource usage sheet you will also see that over allocation:

image15

What can I do with over allocation? First I can leave it: “AS IS”. It means that RESOURCE 2 will work 8 hours even it is not available. Or I can right click on status column and I will get:

image21

I will choose Fix in Task Inspector  and I will get:

image24

You can see the warning message in the upper left corner of the Task Inspector. It says: “Resource assigned in nonworking time _ PRESOURCE 2”. If you don’t want to leave this over allocation “AS IS” you can only choose “Reschedule Task”. I will do and and I will get:

image27

Something is a little bit strange here, isn’t it? I get Duration = 8 days, Start date = 16.06.2011, and End date = 12.07.2011. Let’s look at the Team Planner View:

image30

Here you can see that RESOURCE 2 will actually start with work at 01.07.2011 and it will finish at 12.07.2011. Why? Because RESOURCE 2 is available from 01.07.2011 to 15.07.2011. We needed initially 5 days for the Task (5 days X 8 hours / day = 40 hours)

Now look at the Resource Usage sheet:

image33

RESURCE 2  is 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), remember?

So work schedule for RESOURCE 2 will be:

01.07.2011 –> 4 hours + 04.07.2011 –> 4 hours + 05.07.2011 –> 4 hours + 06.07.2011 –> 4 hours + 07.07.2011 –> 4 hours + 08.07.2011 –> 4 hours + 11.07.2011 –> 8 hours + 12.07.2011 –> 8 hours = 40 hours!

If you were following my example you can try it with TASK “2 and RESOURCE 2.

For the end, be EXTREMELLY CAREFULL when you are using different availability for the resources, because you can get in the trouble if you are not 100% sure what are you doing.

In my next blog I will show how to apply different and multiple pay rates for a Resource

 

See you!

Advertisements

About Nenad Trajkovski

Location: Zagreb, Croatia Occupation: Project Manager Interests: Project Management and MS PROJECT He was born in Zagreb, Croatia at 1963. After completing his college he started working on projects in different business areas (banking, manufacturing, automotive industry, distribution, oil companies, etc.) developing and implementing ERP systems into different companies. He has got a lot of experience working with people in different business processes and also possesses great knowledge in information technologies and financial services. Today he works as a business consultant, adn Project Manager in PERPETUUM MOBILE d.o.o. Zagreb. He is a regular lecturer for Project Management in MS Innovation Center in Varaždin, Logosoft Sarajevo in Bosnia and Herzegovina and SEAVUS GROUP in Skopje Macedonia. He was named the best lecturer of WINDAYS 2008 while his lecture was also voted as the best. In addition, he was in TOP 10 lecturers at the MS SINERGY 2009 and MS VISIA 2009, 2010. Shares first place as the best lecturer of KulenDays 2009 and 2010 and PMI Conference 2009 in Zagreb. He is also a regular lecturer in the MS Community. He is a Certified Accountant and a PMP (Project Manager Professional) and a PMI-RMP (Risk Manager Professional), MCP, MCT, and Microsoft Certified Technical Specialist - Microsoft Project 2010. From 01.01.2012 awarded with MVP (Microsoft Most Valuable Proffesional - Microsoft Project)!
This entry was posted in MICROSOFT PROJECT, Microsoft PRoject 2010, MS PROJECT 2010, PMI, PRoject Management and tagged , , , . Bookmark the permalink.

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