Adjust Task Duration For Resource Productivity

[Bill Bradshaw]

Resource 1 by itself will take 5 days duration to complete a task. I want to
add Resource 2 which is 150% more productive than Resource 1. This should
reduce the duration to 2 days from 5 days. By increasing Resource 2's units
from 100% to 150% will give me the correct duration of 2 days but it also
gives me an over allocation error (which it should). So how do I handle
resources assigned to a task which are doing the same work but have different
productivity rates?

<Bill>

 

[Jan De Messemaeker]

Hi,

This may sound crazy, but it works.
Give the laggards a calendar with less than 8 hours work but keep on
assigning everybody as 100%.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Bill Bradshaw]

I am still having a problem. They both work the same number of hours but one
has a more productive piece of equipment (D-8 versus D-9). I created a new
resource and then cut the working hours back for that resource. I can not
seem to make the task adjust properly and also the resource view does not
show the employee working a full workday. I must be missing something - like
can you give me more detailed directions ?

<Bill>

 

[Jim Aksel]

I might be missing something here.... the work that is entered into the task
needs to reflect the hours each will take to accomplish the task.

If Resource2 works at 100% the rate of Resource1 that will reduce the total
number of hours on the job. So enter it that way.

Lay 24 bricks: Worker1 = 24 hours. (1 brick per hour)

Adding worker 2 (at 1.5 bricks per hour)

Let x = number of bricks laid by worker1
Ley 1.5x = number of bricks laid by worker2
1x + 1.5x = 24 bricks
x = 24/2.5 = 9.6 (ok, my math is poor)

Worker 1 will lay 10 bricks, worker2 will lay 14 bricks.

Total work: 10 bricks/ (1 brick/hour) + 14/1.5 = 19.3333 hours

I would enter it as fixed work (the machine produces pieces at a constant
rate?) Worker1 at 10 hours, Worker2 at 10 hours.
Does that help???
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

 

[Jan De Messemaeker]

Hi,

I'm not with you.
When you cut the working hours back for a resource (through tools, change
working time, NOT through tools, options, calendar) working on a task (as
the only resource) the true duration (finish-start) of the task will
increase. It just will.
The duration field will still show the same amount of time, but your
schedule is correct.
Also, of course, the resource usage will show fewer hours worked during
those days.
All true, but I solved your problem, and I hoped that was what you were
looking for...
Greetings,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Bill Bradshaw]

I agree with you. In the end I decided it was easier to figure out the new
duration myself rather than have MP do it. It will be much faster to add the
new resource and then come up with a new duration on my own. The exercise
was valuable from the stand point that I now know for me it is easier that I
come up with a new duration than try to have MP calculate it.

<Bill>