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.

Levelling Resource Hours only on 1 Activity

10 replies [Last post]
Christine Schwartz
User offline. Last seen 4 years 42 weeks ago. Offline
Joined: 1 Jul 2019
Posts: 4
Groups: None

Hi there

I have an Engineering design schedule where one of my resources is 100% allocated to the project. We have loaded his hours on his design activities however when he is not busy on specific design deliverables the remainder of his time is dedicated to supervising others and various other admin tasks. My problem is the flexible nature of these "Admin" hours. In a busy month he is unlikely to do much but yet with the uniform spread of any admin hours I add it can show him as overallocated in some months and underallocated in others.

Is there a way to create a resource assignment where only on the one activity it will allocate hours monthly based on the resources remaining available time after all activity assignments are accounted for and his remaining availability is determined?

This impacts our cost forecasting and I havent managed to find another way to handle this.

Any help would be hugely appreciated.

Kind Regards

Christine

Replies

Andrew Podolny
User offline. Last seen 41 weeks 3 days ago. Offline
Joined: 16 Nov 2004
Posts: 130

In order to load the remaining available units (after all direct assignments for the admin have been completed) - use 1 activity LOE as it was suggested before but load it with the Admin resourse using Future Buckets (i.e. per each month manually entering the Budgeted Hours which is your remaining available hours for Admin res).

Use https://docs.oracle.com/cd/E90748_01/client_help//en_US/helpmain.htm

And search for "Entering and editing data in future period buckets - Future period bucket planning FAQ"

Rafael Davila
User offline. Last seen 1 day 4 hours ago. Offline
Joined: 1 Mar 2004
Posts: 5229

You can download demo from Spider Project Website and give it a try.  It is a full version download limited to a small number of activities.  It shall take 2 minutes to download, and 2 minutes to install with just one click of the mouse.

Once you install demo you can download the file shown in the video from the following link and run it.

http://www.mediafire.com/file/7bdtxf1a061z7p7/Workloads-C.022.sprj/file

Good luck.

If you are looking for functionality try Spider Project.

If you need to use P6 look for workarounds like one that I suggested.

Christine Schwartz
User offline. Last seen 4 years 42 weeks ago. Offline
Joined: 1 Jul 2019
Posts: 4
Groups: None

Thanks for the suggestion. Think this might be my best option. Unfortunately guess this confirms my suspicion that Primavera doesnt have the functionality I was looking for.

Raymund de Laza
User offline. Last seen 31 weeks 6 days ago. Offline
Joined: 23 Nov 2009
Posts: 762

In P6 Create a dedicated Resource Calendar.

Then Set the Effective Date of the Rates in the Units and Prices Tab.

You can set different Effective Dates with the same Rates.

 

Hoping this will Help.

Zoltan Palffy
User offline. Last seen 4 weeks 3 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

a loe wil spread the resouce from the start of the predcessor to the finish of its successor.

to get it to spread you have to assign a resource curve or it will stack up on tha data dtae

Rafael Davila
User offline. Last seen 1 day 4 hours ago. Offline
Joined: 1 Mar 2004
Posts: 5229

I cannot see how a resource curve will make it.

https://www.ronwinterconsulting.com/Reviewing_Resource_Leveled_Schedules.pdf

  • Resource curves to a resource on a LOE activity can constantly change because the duration of a LOE activity can constantly change.
  • Resources on LOE and WBS Summary activities are not taken into account during resource leveling in P6
  • LOE and WBS Summary activities should not have critical resources assigned to them. It is preferable that no resources be assigned to these types of activities.
  • P6 does not consider resource usage curves when resource leveling.
  • The P6 resource leveling process does not consider resources assigned to Level Of Effort (LOE) and WBS Summary type activities.

As P6 does not levels LOE activities their resource assignments can show overloads.

Manually leveling resource assignments in constantly changing schedules can be a nightmare.

P6 resource curves are defined in 1/10th of activity duration.  If LOE duration is longer than 10 days and every day you can get different assignment resource curves will not make it as you will get wrong distribution.

Zoltan Palffy
User offline. Last seen 4 weeks 3 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

not really what you can do is create  LOE activity and assign a curve to the resource 

the LOE will spread the manhours from the start of the 1st activity it is tied to last activity that it is tied to 

make the predcessor  a SS relationship to the 1st activty of the month and make the successor a FF relationship to the last activity for that month. Activity type LOE 

Rafael Davila
User offline. Last seen 1 day 4 hours ago. Offline
Joined: 1 Mar 2004
Posts: 5229

Easy in Spider Project, I cannot imagine scheduling design jobs without partial workloads and variable quantities and workloads.

I am curious about how others do it.

Variable-Workloads-Supervisory-Role-2

In Spider Project we call this variable resource assignment and it is easy to model.

I don't know similar feature in P6 and suggest to use following workaround.

Create artificial resource AdminCost that will be assigned at the hammock (LOE) activity that lasts from the project start to the project finish and set its hourly rate as the rate of your Admin.

Assign Admin to activities that require his personal efforts. Resource Admin hourly rate = 0.

This way you will get necessary information - right cost of your project, Admin project work hours and Admin "admin" hours as the difference between AdminCost and Admin work hours.