how to calculate the peak consuption of concrete with ms project

A
Ant Pir 👤 Member for 12 years 11 months

Dear All,

I'm going to create a matirial resource concrete with standar rate  1/hr and assign for each concrete activities in the gant chart the  concrete resourse then in ihe unit I assign the quantity in cubic meter.  Afetr filter for concrete and see the spreadsheet.

Someone meet the same task could someone share or advice ?

R
Rafael Davila 👤 Member for 22 years 3 months

Also keep in mind Microsoft Project resource leveling of resources with partial workloads is flawed.

It is possible that Antonio like many MSP users that realize how poor MSP resource leveling is have no other option than recurring to manual resource leveling.

Resource leveling for material resources or “consumable resources” is lacking in most American software and many schedulers do not understand it.

http://www.pmknowledgecenter.com/node/104

Like P6 it looks that MSP cannot resource level consumable resources and use the field “Type” for other purposes.

I found the following reference that I hope will be of help to Antonio.

https://ntrajkovski.com/2011/07/14/material-resources-in-ms-project-2010/

V
Vladimir Liberzon 👤 Member for 25 years 4 months

Antonino, please clarify what 1 per hour means? Concrete consumption does not depend on activity duration. If for some reason activity finished later than expected it does not mean that more concrete were spent than planned.

Mike uses the software that has poor resource leveling capabilities and thus advises everybody to avoid resource leveling.

This is his personal problem, so don't be afraid to apply resource leveling though remember that MS Project does not level material resources.

M
Mike Testro 👤 Member for 20 years 5 months

Hi Antonio

Thats the best way to display the histogram.

If the peak is too high for your placing resource then move the non critical tasks to fill the troughs.

This is best done by inserting a dummy task called Concrete Production.

DO NOT use resource levelling as you will have no control over the changes.

If the peak is on th critical path then you will have to consider a different placement method.

Best regards

Mike Testro

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts