Adjust Task Duration For Resource Productivity

Adjust Task Duration For Resource Productivity

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>

date: Mon, 6 Oct 2008 12:25:01 -0700 author: Bill Bradshaw

Re: Adjust Task Duration For Resource Productivity

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"  wrote in message 
news:AF917F12-9771-4494-9AAC-58E807332E0D@microsoft.com...
> 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>

date: Mon, 6 Oct 2008 21:33:16 +0200 author: Jan De Messemaeker

Re: Adjust Task Duration For Resource Productivity

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>

"Jan De Messemaeker" wrote:

> 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"  wrote in message 
> news:AF917F12-9771-4494-9AAC-58E807332E0D@microsoft.com...
> > 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?

date: Mon, 6 Oct 2008 15:16:01 -0700 author: Bill Bradshaw

Re: Adjust Task Duration For Resource Productivity

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



"Bill Bradshaw" wrote:

> 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>
> 
> "Jan De Messemaeker" wrote:
> 
> > 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"  wrote in message 
> > news:AF917F12-9771-4494-9AAC-58E807332E0D@microsoft.com...
> > > 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?
>

date: Mon, 6 Oct 2008 18:56:00 -0700 author: Jim Aksel

Re: Adjust Task Duration For Resource Productivity

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"  wrote in message 
news:939DC15E-AC29-41B3-B94B-8583CC409776@microsoft.com...
>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>
>
> "Jan De Messemaeker" wrote:
>
>> 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"  wrote in message
>> news:AF917F12-9771-4494-9AAC-58E807332E0D@microsoft.com...
>> > 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?
>

date: Tue, 7 Oct 2008 10:20:22 +0200 author: Jan De Messemaeker

Re: Adjust Task Duration For Resource Productivity

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>

"Jim Aksel" wrote:

> 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
> 
> 
> 
> "Bill Bradshaw" wrote:
> 
> > 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>
> > 
> > "Jan De Messemaeker" wrote:
> > 
> > > 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"  wrote in message 
> > > news:AF917F12-9771-4494-9AAC-58E807332E0D@microsoft.com...
> > > > 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?
> >

date: Tue, 7 Oct 2008 10:53:01 -0700 author: Bill Bradshaw