Cleanest way to....

[Jason]

Quick background: I manage industrial projects from design, fabrication to
installation. I have been asked by my company to schedule the work flow
through microsoft project 2003.

What is the best way to allocate resources to the fabrication? A typical
scenario would be 6 pieces of equipment going through the shop at one time. I
have the estimated hours for each piece of equipment. We run a shop that at
peak levels has 20 fabricators. Can I simply have one resource called
fabrication at 2000% and adjust the percentage of that resource assigned to
each piece of equipment?

An example would be an item that takes 200hrs to complete. That would
typically have three fabricators working full time (10hr/day) or would be
complete in 7 working days.

Can I have a single fabrication resource? Or do I need 20 seperate
fabricator resources?

Thanks

Jason

 

[JulieS]

Hello Jason,

If you haven't any need to specifically identify one of the 20
fabricators for purposes of pay rate or holiday time, I would set
up the multiple unit resource such as you suggest. If all 20 of
your fabricators work the 10-hour shift shift that would mean a
max. unit of 2000%.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

 

[Jason]

How do I go about applying the resource to the task? If 2000% is max but only
300% would work on the project in reality?

How do I incorporate the 200 estimated time it takes to build a piece of
equipment when in reality the duration with 3 fabricators working 10hr/day is
6-7 days?

Thanks

 

[JulieS]

Hello Jason,

I am a big fan of splitting the screen from the Gantt chart to
show the Task Form in the lower pane. Choose Window > Split, to
show the task form.

After you have created the resources on the resource sheet, you
can use the Task form to select the resource, assign the
assignment units (under Units), enter the work and Project will
recalculate the duration of the task based upon the work you
entered and the resource units you entered.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project