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

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Manhours Calculation for Resource Loading

6 replies [Last post]
Suhaila Tsu
User offline. Last seen 4 days 4 hours ago. Offline
Joined: 6 Jun 2011
Posts: 17

Dear All 

I need  some explanation on manhours calculation for resource loading for p6 and MSp

As for my understanding, in p6 the manohurs is called - Budgeted Labor Unit

And for MSp it is called work hour

Quest 1 - Is my understading correct for the above?

 

Before we come out with the manhours for each activity in the schedule. we must have the productivity for each activity.

Production rate = Qty / unit time

Productivity = manhours / production rate

Estimated manhours = productivity * material qty

Quest 2- Is the above formula correct?

 

 

 

 

 

 

Replies

Suhaila Tsu
User offline. Last seen 4 days 4 hours ago. Offline
Joined: 6 Jun 2011
Posts: 17

Thank u so much for the detail Mr Rodel Marasigan

Rafael Davila
User offline. Last seen 46 min 31 sec ago. Offline
Joined: 1 Mar 2004
Posts: 5060

When you add shifts with different crews and different production rates it gets a bit complicated for manual scheduling.

Rafael Davila
User offline. Last seen 46 min 31 sec ago. Offline
Joined: 1 Mar 2004
Posts: 5060

As far as I recall P6 does not have productivity(volume of work per hour) field, multi-resources, nor resource quantity(ea) so you will have to figure out activity duration and for each resource calculate resource units or effort hours.

2021-09-05-19-43-41

2021-09-04-20-07-10

The basic formulas would be:

activity duration(hrs) = volume of work / volume per hour

  • = 90/40 = 2.25 hours

units for each reasource = Resource Quantity(ea) x Workload x Duration(hrs)

  • for Laborers = 4 Laborers x 1.00(100% as a real number) x 2.25 hours = 9.00 resource-hours [Remaining]

Suhaila Tsu
User offline. Last seen 4 days 4 hours ago. Offline
Joined: 6 Jun 2011
Posts: 17

Thank u Mr Davila. 

But are there  Productivity in Activity Type in P6?  

Rafael Davila
User offline. Last seen 46 min 31 sec ago. Offline
Joined: 1 Mar 2004
Posts: 5060

Most work is done by many members of different skills working as a team/crew.  You need to distribute the total man-hours among each of the resource skill.  Easy if you know the volume of work, the production rate of your crew and the crew composition.  At home, estimators and experienced Project Managers are good at this, they use the company records for their estimates and for tasks they have no record they use references such as RS Means.

RS Means Basic Calculations

www click on thumbnail.

If production type, enter the volume of work, select the crew and the production rate and the software will determine the activity duration, if duration type duration is fixed. When using multi-resources the whole crew is assigned; resource quantity for each resource and their workload if part-time and everything else is done by the software, transparent and so easy.  I expect P6 to be a bit different but as easy.

Rodel Marasigan
User is online Online
Joined: 25 Oct 2006
Posts: 1590

Hi Suhaila,

P6 Resources:
1) Labor = Unit (hours)
2) Non-Labor (equipment) = Unit (hours)
3) Material = qty (per unit of measure)

MSProject
1) Work = Type: Work = Hours (labor or equipment) 
2) Work = Type: Material = qty (per Material Label or unit of measure in P6)
3) Work = Type: Cost = Cost (expenses in P6)

Input for each Resources and Resources Type:
P6 Resources Assignment:
Depends on the settings of Activity Duration Type:
1) Fixed Duration & Units = Direct input on the Resources Tab - Budgeted Unit (Budget hours/ qty on the task or activity) the duration will not change. Duration Change - Budgeted Unit will not change. Remaining Unit/time - variable and changing based on the input duration or units (Remaining Unit/Time = Budgeted Unit/ Duration).
2) Fixed Duration and Units/Time = Direct input on the Resources Tab - Budget Unit (Budget hours/qty on the task or activity) the duration will not change. Duration Change - Budgeted Unit will change - become variable and changing based on input. Raimaining Unit/time change - budgeted unit will change, duration will not change (Budget Unit = Duration * Remaining Unit/Time).
3) Fixed Units = Direct input on the Resources Tab - Budget Unit (Budget hours/qty on the task or activity) the duration will change. Duration Change - Budgeted Unit will not change. Remaining Unit Change - Duration Change (Budgeted Unit / Ramaining Unit/Time). 
4) Fixed Unit/Time = Direct input on the Resources Tab - Budget Unit (Budget hours/qty on the task or activity) the duration will change. Duration change - Budget Unit Change. Remaining Unit/Time change - Duration will change.(Bugeted Unit / Remaining Unit/Time)

MSProject
Depends on Settings of Task Duration Type:
1) Type: Fixed Duration , Effort Driven - Yes (tick) - Duration change - Work units change. Work unit change - duration not change. Resource Unit Change (unit/day) - Duration not change, Work unit change. (P6 equivalent - Fixed Duration & Unit)
2) Type: Fixed Duration, Effiort Driven - No (not tick)  - Duration change - Work units change. Work unit change - duration not change. Resource Unit Change (unit/day) - Duration not change, Work unit change. (P6 equivalent - Fixed Duration and Unit/Time)
3) Type: Fixed Unit, Effort Driven - Yes (tick) - Duration change - Work Unit change. Work Unit Change - Duration Change. Resource Unit Change - Duration Change.(P6 equivalent - Fixed Unit/Time)
4) Type: Fixed Unit, Effort Driven - No (not tick) - Duration change - Work Unit change. Work Unit Change - Duration Change. Resource Unit Change - Duration Change.(P6 equivalent - Fixed Unit/Time)
5) Type: Fixed Work, Effort Driven -Yes (always tick) - Duration change - Work Unit no change. Work Unit Change - Duration Change. Resource Unit Change - Duration Change.(P6 equivalent - Fixed Unit)