Duration based on total resource quantity and rate of use

[Steve NCC]

In Suretrack, there is a process where for an assigned resource there are
fields for "quantity at completion" (say 10,000 tonnes), "rate of use" (say
1,000 tonnes/hr) and "duration" which is calculated (10hrs). How do I
replicate this in Project

 

[Rod Gill]

You will need to create and then assign material resources. Search help on
material resources.

 

[Steve House [MVP]]

That's the way material resources are tracked. Create a resource "Coal" as
a material resource, material label "pounds." Create a task X. In the
Window menu choose "split" to split the screen With task X selected, assign
the resource coal, set the units to "50/day" and the work to "600" and
you'll find it calculates the duration to be 12 days. Be very very careful
with this, though, because if you assign a work resource as well, the work
resources will over-ride the duration calculated by the usage of the
material resource - in my example if you add resource Bill at 100%
everything with be fine at first BUT if you then try to change the total
coal to be used to 1000 pounds you'll find the duration number doesn't
change but the elasped time shown by the Gantt bar does! It's as if Bill's
work governs the duration numbers but the usage of coal governs the elapsed
time! I'd strongly suggest manually estimating the duration rather than
asking Project to do it for you to avoid those sorts of problems.

 

[Steve NCC]

Having created the task, assigned the resource and set the units, where do I
enter the work

 

[Steve NCC]

cancel that last question, i found it under task usage

 

[Steve House [MVP]]

Also, if you split the screen and select the task in the top window, the
Task Form in the bottom window includes resource information and the work
field is shown in several of the views available there.