Newby question about amounts in an activity

[shawn]

To all

Please forgive this newby question but I have been trying for a while to
figure it out with little success.

I have an activity : lets say the activity is to move a pile of gravel. The
pile is 10 tons and I can move 1 ton per day on average. How do I create
this activity in project where i can enter the tons and the resource to move
the pile and it will give me a duration. The next activity after that one is
another pile that is a different tonnage (say 12.6 tons).

The question is .. where do I put the tonnage into the activity? Is it a
material resource or something along those lines.. it is not very clear in
MS Project where you can place the amount within the activity?


AHGA!

Shawn
(e-mail address removed) (remove the remove to email to me.. thanks!)

 

[vanita]

Hi Shawn

As Trevor has advised, MSP does not consider quantities, productivity and
duration calculations.

Normally we build up quantities and productivity data and calculate
durations in Excel. Then Map the Durations column from Excel to MSP.
But after this, in MSP if you want to show the quantities of various tasks
alongwith Duration column, you may insert a Text column, in which you can
write any alpha-numeric information. Customise it through 'Customise Fields'
option to rename it as 'Qty. of work' or any other appropriate Title and
insert quantities date for each task or map the quantities column from Excel
into this column.

I hope it helps.
Vanita

 

[shawn]

Trevor

Thank you very much for that great explaination. It is unfortunate that
Project can't do this natively. I have a fixed amount of material and
depending on how many resources or the rate I apply to the resource I will
draw down that amount until it reaches 0.

As you suggest I'll look at the other fields and build a macro that will
recalculate the duration when I enter an amount into the custom field called
quantity. I think that way I can then assign resourced applied to the fixed
Duration activity.

Again thanks for your help.

Shawn