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

Posted Sat, 2016-11-26 03:27 by Khuong Do

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

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)

After finish, click Close button.

Click on Resource Usage Spreadsheet button.

Hold Ctrl button and select 2 resource : Worker and Crane

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

Click on Calculate Average and Base on Hours per Time Period

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

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

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

by Rafael Davila - 22 Dec 2016 - 10:34

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

by Rafael Davila - 23 Dec 2016 - 13:39

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.

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.