Cost and Manpower Loading in Primavera P6

Resource loading in Primavera P6 is a time taking process. Normally, clients prefer to get the logic part first; then, they will ask you to load resources, including Cost, Manhours, and Quantities.

Recently, I was deputed where the logic part was finalized, but the resource part was to submit in 3 days only 🙂

It’s a high-rise building of 40 storeys, mind you.

I used here some short cut techniques that may help anybody any day.

Make sure to read till the end then suggest if this is OK to go!

I have divided this into two parts, Cost and Manhours loading.

Files: Download files I used from this link 

Note: This method is best for the Tendering schedule otherwise.

Cost Loading from BOQ

The following steps were performed to load the cost from BOQ.

Step – 1: Below snap of a Demo plan without Budgeted Cost and Budgeted Units

A primavera p6 plan without Budgeted Cost and Budgeted Units

Step -2: Let’s add a materials resource.

Making a Resource for BOQ Cost Loading

Step -3: Put Price/Unit, Default Units/Time & Max Units/Time = 1

Put 1 in all three boxes appear next

Step -4: Apply this resource to all activities. Holding a shift key

Apply BOQ Cost Resources to all the activities in the plan - Milestones are exception

Step -5: This is a just Demo BOQ from which we will upload the cost.

Demo BOQ for Cost Loading

Step -6: After that, I filtered the same type of activities in all areas and divided the cost from BOQ to that number. Like here, I have 3 activities for hardscaping, and I divided 12000 $ by 3 and put this value to the program by a global change as below.

Global change for BOQ Cost Loading in Primavera P6

Step -7: Review the global change and click Commit Changes.

Global change for BOQ Cost Loading in Primavera P6 Confirmation List

Step -8: We got the value as you can see, Apply this to the rest of the activities by following the same global change method. Like here, do it for Structure and Finishing.

Cost Changed as Per BOQ

Step -9: Make sure to apply below global change or else your cost may not Export to other machines – Thanks to Korai from Planning Team for helping here

Must to have a Global change after cost loading via this BOQ Method

Step -10: Now, if you see Budgeted Cost is not equal to Budgeted Units, You can skip this but better to make everything align.

This is to make budgeted Units equal to Budgeted Cost

Step -11: Make below global change to equalize.

This is to make budgeted Units equal to Budgeted Cost.

Step -12: After all this, copy this project and also make an MS Excel export for Resources as below;

This is how you import resources from Primavera P6 to MS Excel

Make a filter like below;

This is how you make filte to import cost from Primavera P6 to MS Excel

Click next and save that MS Excel export at an appropriate location.

Manhours Loading from Cost

Once cost loading is done, then you can go for manhours. See below steps

Step – 1:  Same way, make a Labor resourceResource Loading for Manhors

Step – 2: Select, labor and click next

Resource Loading for Manhors - Make a Labor Resource

Step – 3: Put value = 1 in each box

Put 1 in all the boxes

Step – 4: Apply this to all as we have done in the cost loading section

Apply this Labor resource to all the activities in the plan as we did for cost loading

Step – 5: Our goal is to get Budgeted Units for Manhours equal to that of Budgeted cost or Budgeted units of BOQ Cost Resource

Step – 6:  Apply the below filter and export at an appropriate location

Filter for manpower and cost loading at the same time

Step – 7:  Open both Excel sheets we have exported till now. Apply, VLOOKUP formula in the latest sheet at as in below snip. It will get the same values for Manhour resource

MS Excel Export from Primavera P6 and apply vlookup here

Step – 8:  Values we will get from Cost Loading Excel sheet

Vlookup formula for resource loading through primavera p6

Step – 9: Once you apply vlookup, then copy all the value from the column where we applied vlookup and paste as it is in all the other columns, as you can see below. Make sure it should be as text as Primavera P6 reads in the book. save and Close this sheet.

Paste the values you will receive after vlookup formula is excel

Step – 10: Import the above sheet where we put the same values to the program. This process is simple; you just need to go to  File>Import>Spreadsheet>Next>Locate the Sheet>Check boxes and Finish.

After Vlookup cost got double

Step – 11: Now, the cost values got doubled. Remove the cost from labor by applying below Global Change

Make labor cost is equal to zero in a global change to remove extra cost

Step – 12: Here, I just assumed the manpower required is 10% of the total cost. This is just my assumption from previous projects from the same firm. You can have as per your experience, and it may vary to project types.

Make Labor units 10% of the total cost

Step – 13: This is the final I got from all this process.

Finally we got manhors and cost. All is done by extensive global changes. This is something new for me.

Wrap Up

This cost was further refined as per floors in a meeting with Project Manager, Quantity Surveyor, and other stakeholders. Same way, manhours were adjusted after meeting the site team.

All in all, the refinement was not time taking as it was just a matter of typing.

S Curves were generated, and the program is with the management.

FEATURED POSTS


Download Primavera P6
To download and install Primavera P6 was never that easy as nowadays. By following these steps…

Download Primavera P6

What is PMP?
What does PMP stand for? You are here as you just have heard about PMP, or you know a little already but have some …

What is PMP?

Stakeholer Engagement
A stakeholder is any individual, a group of people or an organization that can affect or be affected positively….

Stakeholer Engagement

Work Breakdown Structure
Work Breakdown Structure is simply a tool that breaks the work down into a structure…

Work Breakdown Structure

Project Management
Project management is how you apply the knowledge, skills, tools, and techniques to get the project management …

Project Management

Gantt Chart
A Gantt chart is also known as bar chart represents a project plan by making each task into a bar and …

Gantt Chart

Planning Engineer
Planning Engineer is considered the right-hand of a Project Manager as he floats the information about project…

Planning Engineer

Team Development
Dr. Bruce W. Tuckman, a psychologist published a theory in 1965 called ‘Tuckman’s Stages of Group Development’.

Team Development


8 thoughts on “Cost and Manpower Loading in Primavera P6”

  1. Nuraslina Junaidi

    tq very much for sharing this helpful tutorial… i did learnt this from my senior planner before.. this will help me for my revision

  2. Great Sir,

    Kindly let us know more such useful tips. will be grateful to you.
    Please share more
    Thanks

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top