Levelling Resource Hours only on 1 Activity

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

A
Andrew Podolny 👤 Member for 21 years 6 months

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"

R
Rafael Davila 👤 Member for 22 years 3 months

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.

V
Vladimir Liberzon 👤 Member for 25 years 4 months

If you are looking for functionality try Spider Project.

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

C
Christine Schwartz 👤 Member for 6 years 11 months

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.

R
Raymund de Laza 👤 Member for 16 years 6 months

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.

Z
Zoltan Palffy 👤 Member for 16 years 10 months

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

R
Rafael Davila 👤 Member for 22 years 3 months

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.

Z
Zoltan Palffy 👤 Member for 16 years 10 months

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 

R
Rafael Davila 👤 Member for 22 years 3 months

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

V
Vladimir Liberzon 👤 Member for 25 years 4 months

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.

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts