Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

How to make a labor, equipment mobilization plan in Primavera P6

In a project plan beside the Start and Finish date of activity, we also need to know When we need resource, and How many resource we need.

I will show you how to do it.

We have a simple project with 3 activities and is assigned resource as follow:

  • Activity A : 10 worker and 1 Crane
  • Activity B : 5 worker and 2 Crane
  • Activity C : 20 worker

How to make a labor, equipment mobilization plan in Primavera P6 - 1

Now we will make a Labor, Equipment mobilization plan so that we know when we need the resource and how many we need.

First we need to make some configuration. Go to menu Admin -> Admin Preferences. Click on Time Periods tab. Edit the Hours value to match with your Project calendar.

For example if you use 6 days work-week, you have to adjust Hours/Week is 48, Hours/Month is 208 (8 x 26), Hours/Year is 2496 (208 x 12)

how-to-make-a-labor-equipment-mobilization-plan-in-primavera-p6-1

After finish, click Close button.

Click on Resource Usage Spreadsheet button.

How to make a labor, equipment mobilization plan in Primavera P6 - 2

Hold Ctrl button and select 2 resource : Worker and Crane

How to make a labor, equipment mobilization plan in Primavera P6 - 3

Now data will show on the right.

But all data is in Units format. We may don't care number of unit, we only care number of person or equipment.

You will right click on the table and select Spreadsheet Options

How to make a labor, equipment mobilization plan in Primavera P6 - 4

Click on Calculate Average and Base on Hours per Time Period

How to make a labor, equipment mobilization plan in Primavera P6 - 5

Now you can see the figure show in number of person and equipment.

How to make a labor, equipment mobilization plan in Primavera P6 - 6

On the week of 29-Sep you will need total 35 workers and 3 cranes.

You can also print the report by going to Print Preview

How to make a labor, equipment mobilization plan in Primavera P6 - 7

With this Resource Mobilization Plan you know when you need resource and how many.

Thank you for your time to read this article.

 

You can also find other post at my personal blog : https://doduykhuong.com

Comments

What if each activity works

What if each activity works on a different work week.  Say activity 1 works on a 6 days work week each 8 hours per day, say activity 2 works at night 5 days a week 6 hours per day and activity 3 works only on weekends 10 hours per day.  Then activity 1 starts on day 1, activity 2 on day 8 and activity 3 on day 29 at mid day.

After you figure it out then add a second shift to each activity, one shift as previously indicated and a second shift four days a week 7 hours per day from 1 pm to 8 pm.  Then for fun assign the cranes a 40% workload as it is common to share equipment such as a crane between some activities during the same day.  Say you only have 2 tower cranes and it is a multistory building.

No single conversion factor will make it.

I am trying to replicate your

I am trying to replicate your sample schedule using more advanced software capable of differentiating between effort and resource quantity but it looks like there is a mismatch no matter if I use 5 days work week as per time period shown with 8 work hours per day, 40 work hours per week or 6 days or maybe 7 days as per activity duration and Start and Finish dates as shown in your figure.

Note that during the week of 29-Sep only Activity C will be active as Activities A & B have been finished as per your figure.

 photo MP03_zpst7gw6ka8.jpg

To say a simple conversion factor will make it is in error.  Under partial workloads resource leveling for effort [units] is flawed, so much that it will not always identify all overloads.

http://www.mediafire.com/file/t17wh3tzhtmxn3a/Presentation_-_Resource_Quantities.pdf

Please I would like to know the calendar details including the day for start of week you are using.  Some of the finish dates you are showing happens on Sunday and it is confusing.  At home in some jobs we run payroll from Thursday to following week Wednesday, I am not sure which day is the start of your week.

Start of Week photo start of week_zpsonly9igu.jpg

Best Regards,

Rafael

(No subject)

 photo Quantity vs Effortjpg_Page1_zpsi68bw6c0.jpg

Market Place

Primavera P6 and Microsoft Project books, on-line video training courses and training material available from an internationally recognised publisher. Teach yourself using on-line or book based learning or run your own in-house or public courses.