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.

Primavera 6.7 Challenge Rgd I’nal Resoure pay-rate laws

7 replies [Last post]
Tue, 2010-09-07 03:11
A D
User offline. Last seen 3 years 24 weeks ago. Offline
Joined: 20 May 2007
Posts: 1027
Groups: Accreditation Editors
Here is a something nice to read:

Primavera P6.7 Challenge Regarding International Resource Pay-Rate Laws

http://www.linkedin.com/groupAnswers?viewQuestionAndAnswers=&discussionI...

I’m knee-deep in a resource-loaded schedule for a customer based in Australia. I have created a custom calendar to show a "11-on, 3 off" work schedule. To make things more difficult, the customer informs us that Australian laws require us to pay double-time for any weekend hours, REGARDLESS of hours already worked during the week. Therefore, if a laborer only works Friday, Saturday and Sunday, he/she is still paid double-time for the Saturday and Sunday hours, even if the total hours worked is - for example - thirty hours.

I’m trying to figure out how to program this information into the resource tables of Primavera P6 (most recent version,) so that my baseline costs are properly established for the budgeted labor hours I’ve already provided. My only idea thus far has been to apply TWICE the actual hours spent by a resource for any weekend work, but this of course would drastically affect my CPI values, as well as affect remaining labor hours, etc.

Another idea was to create a second resource just for weekends with a separate pay rates and resource calendars, but this would cause a nightmare once the work actually begins to progress. Also, if I intend to track resources for different skill leves, I’d need weekend resources for EACH skill level... PITA!

I’m looking for the magic button that links calendar assignments to pay rates. I can’t imagine that Primavera doesn’t have a "holiday pay rate" or something similar, but I can’t find it, should it exist...

Thanks for any guidance you may have to share.

Jeffrey S. Knapp
Manager of Project Schedules
Taggart Global, L.L.C.
Pittsburgh, PA
Top

Replies

Wed, 2010-09-08 20:57
#1
Rodel Marasigan
User offline. Last seen 4 days 10 hours ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Vladimir,
The schedule is already done and submitted then come back from client due to additional requirement which is pay rates issues so I change the resource loading and use the model I mention. Meaning the activities timeline is already known.

I agree with Rafael that Pay Rates should not be included in the schedule and let the timesheets and accounting system do the work but for some instance the client requires the cash flow and effect of the pay rates.

If the schedule is from the scratch and just developing then I model it differently using LOE for resources as per example below.
11Days Cycles
Each of the resources was duplicate say R1 for Ordinary and R2 for Weekend then assigned to LOE having duration type of Fixed Unit/ Time. Using this setting Primavera automatically adjusts hour/unit and multiple by rate assigned when they schedule.
Ex:
R1 have task calendar assign Ordinary day Monday to Friday (with 11 day cycle exemption) – single rate
R2 have task calendar assign Week day Sat – Sun (with 11 day cycle exemption) - double rate
In Primavera, Calendar can inherit holiday and non working day to Global calendar (i.e. 11 day cycle)
Activities are defines as Task dependent and using 11 day cycle calendar.

In regards to your query and example machine (R1) = 24hrs and have only one resource (R2) 8hrs. I don’t understand why you need 24hrs cycle to 8hrs operations? I said it out of topic because pay rates is the issues here.

Best Regards,
Rodel
Top
Wed, 2010-09-08 09:15
#2
Rafael Davila
User offline. Last seen 1 day 4 hours ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Groups: Spider Project Team
Weekends are always overtime

Maybe you can make overtime(s) definitions to happen on their own calendar(s) and the activities on their own separate calendar, in this way you can model overtime to happen always on weekends.

To me modeling of overtime to happen always on week-ends is the most easiest, the following are kind of harder to model.

A-On regular week, after five consecutive hours, lunch time is triple pay, after 8 hours, it is 2.0X. Regular week starts on Wednesday first shift.
B-On week-end, after 8 hours per shift (modeling of shifts is a critical issue) following is double while regular is 1.5X, lunch is 3.0X and after 8 hours it is 2.0X.

... too much granularity? To me it is, we simplify our models as long as it has no effect on the schedule. For example some components of a crew work at noon, while the others take a rest, this happens during concrete pours, we schedule regular hours for the hole crew and use average rates that include some allowance for work at noon (lunch time). Schedules are not meant to substitute accounting software, setting one to deppend on the other is a double edge knife, keep "scheduling timesheets" at the portolet, regular Job Costing timesheets should be enough.

Best Regards,
Rafael

P.S. At PA week-ends are for Dorney and Hershey Park, week-end pay shall be at minimum triple.
Top
Wed, 2010-09-08 09:01
#3
Vladimir Liberzon
User offline. Last seen 17 weeks 5 days ago. Offline
Joined: 5 Feb 2001
Posts: 2748
Groups: Accreditation Editors, Board of Advisors, Civil Engineering, GPCCAR Editors, Petro-Chem / Oil & Gas, Regional Representatives, Spider Project Team, TURNAROUND & SHUTDOWN (T/A & S/D)
If you work in shifts then each resource has own calendar and machines work with all of them.
If you use resources with different work time machines shall work with all of them.
Assigning resources R1 and R2 with different calendars you shall know before the scheduling what time they will work on activity. Is it always known without scheduling?

It belongs to the topic and you did not answer my questions or I did not understand your answer.

Best Regards,
Vladimir
Top
Wed, 2010-09-08 07:46
#4
Rodel Marasigan
User offline. Last seen 4 days 10 hours ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Hi Vladimir,
We done this before using different calendar per resource but instead of time this model use days.

In regards to machine allocation, why you need to assigned 24 cycle to 8hrs operating time? (I think it also out of this topic)

Best Regards,
Rodel
Top
Wed, 2010-09-08 07:08
#5
Vladimir Liberzon
User offline. Last seen 17 weeks 5 days ago. Offline
Joined: 5 Feb 2001
Posts: 2748
Groups: Accreditation Editors, Board of Advisors, Civil Engineering, GPCCAR Editors, Petro-Chem / Oil & Gas, Regional Representatives, Spider Project Team, TURNAROUND & SHUTDOWN (T/A & S/D)
And how did you level your resources?

And one more question. Let’s suppose that you have some machine R1 with 24 hours work day and an operator R2 with 8 hours work day. Does it mean that when this operator rests the machine works itself?
Top
Wed, 2010-09-08 06:55
#6
Rodel Marasigan
User offline. Last seen 4 days 10 hours ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
I had been on a similar problem before and the solution the suits is using resource dependent activity. Using this type of activities resource calendar is used instead of activity calendar. Two resources will be assigned with different calendars and pay rates.
Ex:
R1 - calendar Mon - Thu - single rate
R2 - calendar Fri - Sun - double rate.
When the activity is progress and only R1 will fall on Mon - Thu and R2 will fall on Fri - Sun.
I handled it successfully without any problem.

Hope this help.
Top
Tue, 2010-09-07 03:42
#7
David Kelly
User offline. Last seen 1 year 38 weeks ago. Offline
Joined: 19 Oct 2004
Posts: 630
Groups: Petro-Chem / Oil & Gas
This is not easy....

Although Primavera’s timesheet system allows an overtime rate, it is hours above 40, not all hours at the weekend.

The only solution I can think of is to disable "calculate costs from units" so that when you import the timesheet systems hours, you can separately load the costs which will have to be calculated outside Primavera.
Top