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:
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:
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:
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):
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:
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:
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:
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???? .
In my next Post I will show you something that many of us are considering a a Bug, and many of us does not!
Awesome Ninad. Keep going…