Shortest possible duration

[Barny Blue]

I am trying to achieve the shortest possible duration for a task. If I know
already the number of hours it is going to take and who is working on it;
should I enter the task as fixed duration or fixed units?

I have two resources for this task; one has her own part time calendar, the
other works full time. I want to assign them to the task (at 100% units) and
get the shortest possible duration - I know there is a fixed amount of hours
work to be done. When I assign the resources, project gives them half the
work each, so my part time worker is doing 20 of the 40 hours which makes the
duration longer than it needs to be. I am trying to get project to take the
two resources, and bearing in mind their availability, use all their time
until the work is done. So, the full time should be doing more of the work
than the part time.

Any ideas?

Blue.

 

[Jan De Messemaeker]

Hi,

IMHO you will have to code the logic you need in VBA. Project doesn't do
this.
HTH

 

[Mike Glen]

Hi Barny,

Welcome to this Microsoft Project newsgroup

For your relatively simple example I would enter the Work hours by day in
the Task Usage view.

FAQs, companion products and other useful Project information can be seen at
this web address: http://www.mvps.org/project/

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP

 

[Steve House [Project MVP]]

As Jan said ... But also an aside the task types such as "fixed work" or
"fixed duration" really only have meaning when you are editing the
assignm,ents of resources already on a task. The magic formula is
Work=Duration * Units. It has a constant term, an independent variable that
you are editing, and a dependent variable that Project is calculating. Task
type simply tells Project which term should be held constant when you edit
one of the other terms, thus indirectly telling it when you edit, say, a
resource's units whether it should recompute the work or the duration for
you.