Overtime calc tied to a specific pay code
Has anyone successfully tied a paycode to a separate overtime calculation?
The PR132 calculates the hours times the EE's rate of pay.
Management wants to see the overtime for the shift premium separate from the calculation of normal overtime and they want to see it by the difference in overtime calcs – 1.5, 2.0, etc.
Earnings Hours Amount
Regular 80.00 836.07
Ovt 1.5 29.05 460.07
Ovt 2.0 1.00 21.33
Shift Prem 80.00 20.00
Shift Ovt 1.5 29.05
Shift Dbl Ovt 2.0 1.00
Shift Prem Reg of 80 hours x .25
Shift Prem OT of 29.05 hours x .25 x 1.5
Shift Prem Double Time of 1.0 hour x .25 x 2.0
For the overtime code (Shift Ovt 1.5) we attempted to tie the shift table to the pay code so that the overtime calc would occur on the shift amount, but it created all sorts of havoc in the PR132.
Any suggestions as to how this could work?
Thanks!