Workload without Resources in MS PROJECT–what will happen?–PART 2 of 2

 

Hi,

in my previous Post I wrote about assigning resources to the Task when they already have workload. Now I will show what happens I f I add additional resource to the Tasks, regarding of Task Type in MS PRIJECT 2010!

Here are Tasks:

image

As you can see, First task Fixed Units, and third task Fixed Duration are non effort driven, and second task Fixed work is effort driven by default. Fourth task (Fixed units Effort driven), and fifth task (Fixed duration effort driven) are effort driven.

Now I will assign one resource to each Task, and I will get:

image

Here is explanation:

  • All task have 12 hours of work, because I said so BEFOR I have assigned any resource to them
  • Task Fixed units  has 1,5 days Duration because Resource has 100% fixed units, and that means that it will work 8 hours per day. Since 12 hours are needed for the task, 12/8 = 1,5 days
  • Task Fixed work has 1,5 days Duration because Resource has 12 hours fixed works, in fixed work type, in formula DURATION = UNITS * WORK, Duration is changed and that means DURATIN = 100% * 12 = 1,5 day
  • Task Fixed duration has 1 day Duration. Because Resource has 1to work 12 hours, and duration is fixed it has to work with 150% capacity (units).

Now I will assign additional resource to the Fixed units Task:

image

Since task is non effort driven, Resource 2 has to work 12 hours, and the total work is 24 hours. Duration and units are unchanged.

Now I will assign additional resource to the Fixed work Task (which is effort driven by default):

image

As you can see, work is fixed (12 hours of total work), and because the Task is effort driven, each Resource will work 6 hours per day. And duration is now 6 hours of work / 8 hours of working day = 0,75 days!

Now I will assign additional resource to the Fixed duration Task:

image

Now what? Task is non effort driven! Additional task will work 8 hours because fixed duration is 1 day, and 100% units means 8 hours per day. Assignment for Resource 1 remains the same. Total work is 20 hours. It may seem strange, weird or odd, but that is how MS PROJECT 2010 works!

Now I will assign additional resource to the Fixed units Effort driven Task:

image

Because the Task is effort driven, Resource 1 will now work 6 hours, Resource 2 also, so the total work is 12 hours. Duration is 0,75 days as I have explained before.

Finally, I will assign additional resource to the Fixed Duration Effort driven:

image

This is hard one! Total work is 12 hours. Because Resource 1 had 150% units (before I have assigned Resource 2) the formula is 150%  Units of Resource 1 + 100% Units of Resource 2 = 12 hours. Back to the school:

  • Work of Resource 1 + Work of Resource 2 = 12 hours => FORMULA 1
  • Work of Resource 1 = 1,5 * Work of Resource 2 => FORMULA 2
  • I will put Formula 2 in Formula 1 –> 1,5 * Work of Resource 2 + Work of Resource 2 = 12 hours. –> 2,5 * Work of Resource 2 = 12 hours –> Work of Resource 2 = 12/2,5 = 4,8 hours
  • Back to Formula 1 –> Work of Resource 1 + Work of Resource 2 = 12 hours –> Work of Resource 1 + 4,8 hours = 12 hours –> Work of Resource 1 = 12 hours – 4,8 hours –> Work of Resource 1 = 7,2 hours

Simple, isn’t it???? Smile.

In my next Post I will show you something that many of us are considering a a Bug, and many of us does not!

 

Regards!

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.

One Response to Workload without Resources in MS PROJECT–what will happen?–PART 2 of 2

  1. Prakash Vaidhyanathan says:

    Awesome Ninad. Keep going…

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