Multiple Labor Costs

OK, here’s my scenario. I have employees that can work in various parts of the country, and their hourly labor differs based on their current location. So a person may be based in location A, and work in 1 project that spans locations A and B. When he is working in Location A, he is paid labor rate X and when he is working in Location B he is paid labor rate Y. I’m not so much worried about how to account for the locations when it comes to payroll, but I want the project to be charged correctly. I initially considered using 2 Resource Groups - one for each location - that had labor and burden costs set appropriately. But I’ve come to learn that the labor cost portion of the resource group doesn’t post cost to the job (even though it says COST).

Oh, and to add one more wrinkle - the employees are hourly and get paid regular, overtime, and double time. I’d like to be able to accurately capture this cost on the project as well. I also tried assigning roles to the employee with different time types to account for this, but now I understand that this too has no effect on the cost posted to the project, only in billing rates for invoicing.

Has anyone else run into a situation like this? If so, is there some feature I’m missing that makes this all work like magic?

Thanks in advance!

My thought is that you may want to have two different Employee IDs for the person; one for Location A with the hourly rate for Location A and one for Location B with the hourly rate for Location B.

@MickStiers There is not a feature I am aware of, but it is possible to set the LaborDtl.LaborRate on start activity. We have different rates based on departments. I know it gets posted because one of the jobs picked in this years audit had multiple rates so I had to explain how that worked.

In EmpBasic make UDs for your location rates and determine how to know where they are working by job.

Pre processing in Labor.Update
LaborType is P, RowMod is A, ActiveTrans is true.

The OT and double are trickier and I have not ever tried that, but the LaborHed records have all of the clocking data for the week so it is possible.

The project billing module allow labor rates.

Project Billing Module.

Employee > Role > Role Rates

  1. Select the employee you want to set up rates for.
  2. Click on the “Pay Information” tab.
  3. In the “Role Rates” tab, you would see fields for “Regular Rate,” “Overtime Rate,” and “Double Time Rate.”
  4. Enter the appropriate rates for each field.
  5. Save your changes.

Once you’ve set up the rates for an employee, the system will automatically apply the appropriate rate based on the employee’s hours worked. For example, if the employee works more than the designated number of hours for overtime, the system will automatically apply the overtime rate for those additional hours. Similarly, if the employee works more than the designated number of hours for double time, the system will apply the double time rate.