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.

Resource Loading - Equipment

6 replies [Last post]
E Kramer
User offline. Last seen 10 years 30 weeks ago. Offline
Joined: 30 Dec 2010
Posts: 4
Groups: None

Has anyone resource loaded their schedule with 'Equipment'? What unit of measure is best used? What kind of output do you produce and how is it useful to the project team?

Replies

Rafael Davila
User offline. Last seen 14 hours 21 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229

There is a misconception by some schedulers that it is better if you plan using only fixed crew composition. Also most software cannot handle the true variable crew models that will yield better schedules adding to the poor resource planning practices. Still are relatively good in the modeling of the simple case of a fixed composition crew.

If this is what you want to model then it is just a matter of fixing your resource quantities and workloads.

The following example is based on two cranes availability. There are no logic links among the activities but a resource to be shared when available. Activity 1 need the crane 6 hours per day or 75%, the same goes for Activity 2 while activity 3 needs a crane 4 hours per day.

Note that assigning a crane 4 hours per day is not the same as 2 cranes 2 hours per day or four cranes 1 hour per day, each would represent different models. 

 photo crane345679_zpscdea4d61.jpg

By using adequate quantity and workload you shall be able to get good resource leveling that will prevent assigning too many tasks to the cranes.

It is very easy once you get it, it is just that usually you do not assign a labor resource to several activities in most construction activities while equipment is frequently shared among activities in parallel. In other job types it is very common to share labor resources on different activities the same day.

E Kramer
User offline. Last seen 10 years 30 weeks ago. Offline
Joined: 30 Dec 2010
Posts: 4
Groups: None

Guys,

Thanks for the responses... that def gives me something to think about. I can see where it gets a bit tricky with different types of equipment. I was looking for a quick way to represent "how much" and "for how long" will certain pieces of equipment be on the project site. I was hoping to load schedule activities with the required equipment needed and as a result show a stacked histogram of equipment hours that will be required over the duration of the project.

 

Thanks again.

Rafael Davila
User offline. Last seen 14 hours 21 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229

Assigned quantity is usually expressed using units and workloads, say one crane [quantity/units] 2 hours per day [workload].

Productivity and work are different and are better expressed using physical measure of work per unit time in case of productivity and volume of work in case of work.

 photo equipment258975_zpsa81a5fb7.jpg

A typical example of equipment workload would be when sharing a piece of equipment among several activities, say a crane shared one hour per day on 12 activities using an 8 hour calendar, a maximum of 8 such activities will be assigned on a single day and remaining will be delayed until the crane is available to work required hours on the remaining activities. 

Some schedulers assign the crane to a hammock activity but this would not correctly resource level the crane usage and might allow for all activities be scheduled during the same day. Others try to assign such equipment using fractions or percentage of equipment but this would allow wrong assignments. Say you have 3 activities that need a crane 5 hours a day and you have 2 cranes. Only two activities can be worked on the same day but the wrong model might allow the 3 activities to be scheduled the same day by assigning unintended distribution of resource hours. Such model might assign Crane 1 five hours to Activity 1, Crane 2 five hours to Activity 2 and the two cranes 2.5 hours to Activity 3 to make the 5 equipment hours. The model would not make this transparent to the scheduler. In the case of five cranes available it might assign five cranes at the same time to a single activity. This can yield impossible assigments such as when a plane can get you from A to B in four hours, then two planes will get you in 2 hours. 

It might look complicated but using good software that provides the correct metrics for such assignments makes it easy once you get used to it, otherwise would be very difficult, impossible or would yield erroneous models. 

It is very common to assign all resources to a fixed Crew, that will result in feasible schedule but not necessarily the most efficient resource planning. Say a crew requires 10 units of Resource A but only 9 are available and the 10 th will be available in 6 weeks, it does not make sense to delay the activity 6 weeks and keep the nine available resources idle. In practice the activity will be started when enough are available, even when total activity duration will be increased it will end way before than if you wait the six weeks. Poor models will not be able to account for this and in the case of hundreds of activities the planner might not notice the opportunity lost. 

Still in your fixed crew if the equipment is a crane to be shared among several activities you shall consider use of partial assigments or workloads.

MK TSE
User offline. Last seen 3 years 46 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None

I make it simple, in unit of piece, i.e. 1 piece of that particular equipment is assigned to support task achievement

Rafael Davila
User offline. Last seen 14 hours 21 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229

About unit of measure we use a unit of measure related to the volume of work. For an excavator we use CM to quantify volume of work, we use CM/Hour to quantify productivity. For asphalt pavement we use tons to quantify volume of work, we use Tons/Hour to quantify productivity.

Machine hours represent effort. Keep in mind different pieces of equipment might produce different amount of work within the same equipment hours. 

For serious resource planning at minimum your software shall differentiate between duration, effort and volume of work. It shall provide good resource leveling algorithms and advanced resource modeling such as skills, multi resources as skills, variable resource quantity and workload that will reduce idle resources in the same way job manager will attempt to do it at the job site. Unfortunately most software with regard to resource planning are a joke and do not provide the tools for serious resource models. 

Rafael Davila
User offline. Last seen 14 hours 21 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229

Crew production is dependent on all resources otherwise would be a waste. They all have some relation to production rate but usually the crew is not 100% balanced. Depending on the composition and production capacity of the resources some resource type will be driving the crew production rate.

If you have a loader that can load 160 cm of soil per hour and 10 trucks that can move 20 cm of soil per hour based on the job conditions the crew production rate will be determined by the loader capacity of 160 cm per hour instead of 200 cm per hour the trucks could handle.

At times you do not know in advance which loader will be available if a 160 cm/hr loader or if a 200 cm/hour so in such case you shall use skills to define crew options that will be selected by the software depending on availability and capacity of resources, also the software shall be able to adjust activity duration in the case the availability of resources can vary while allowing the activity to progress.

You are not to hold an activity for 8 weeks that needs 6 trucks only because 5 are available and the 6th will be after 8 weeks. Therefore your software should be able to model variable resource loading if it is to perform serious real life resource planning. 

The following is an example of a schedule that will select best crew depending upon availability. Note that the cycle will determine how many round trips a truck can do in an hour and therefore how many trucks are needed. Crews with 0 durations were not selected and can be displayed or omitted as per scheduler option. It is good to display all skill options during the initial model set-up. 

 photo EW23456_zpsf67e4732.jpg

There can be more complex scenarios that combine crew selection and productivity based on the season as during the winter or during the summer the equipment selection might be different, but you do not know in advance if activity will move from one season to another. Here summer will be a shift while winter will be another shift where you do not know in advance during which shift will finally work will be performed. In some cases it might be work is done during both seasons. 

Definitively equipment productivity must be considered in your job models.