Skip to content

how to calculate the peak consuption of concrete with ms project

Ant PirMember for 13 years 4 months
Created
3
5
0

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 ?

3 replies

Oldest first
  1. 0
    Mike Testro ·

    Hi AntonioThats the best way

    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

  2. 0
    Vladimir Liberzon ·

    Antonino, please clarify what

    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.

  3. 0
    Rafael Davila ·

    Also keep in mind Microsoft

    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/

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?