Weighted Average Overtime Rates
If you are using weighted-average overtime rates (that is, you selected the Use weighted average overtime rates check boxes in both PR Craft Classes and JC Jobs), the system uses a weighted-average rate adjustment when applying auto overtime to timecards posted to jobs, crafts, and classes.
- If the Average By field is set to Day for either the Job or the Craft/Class on the timecard, the system uses the daily weighted-average rate to calculate the overtime rate.
- If the Average By field is set to Week for both the Job and the Craft/Class on the timecard, the system uses the weekly weighted-average rate to calculate the overtime rate.
The Overtime setting for an employee in PR Employees (Additional Info tab) determines whether the employee is eligible for overtime and if so, whether they receive daily and weekly overtime or weekly only. It does not affect whether the system uses a daily or weekly weighted-average rate (or neither) when processing any specific overtime hours for the employee.
During auto-overtime processing (in PR Auto Overtime), the system starts with the daily overtime calculations first (for applicable employees), and then calculates weekly overtime for any remaining overtime hours not already processed. In each case, the system uses the specified weighted-average overtime calculation method to determine the overtime rate.
The following discusses how the system handles overtime calculations based on the Average By method.
Overtime Calculations Using Weighted-average by Day
- The system calculates a weighted-average regular rate for each day as the sum of the employee’s straight-time earnings for the day divided by his total hours for the day (only earnings subject to OT with a factor of 1.0 are included).
- When processing a timecard for a given day (based on posted date), the system sets an overtime rate adjustment as the average regular rate for that day times the OT factor less one. For example, if the OT factor is 1.50, the overtime rate adjustment is calculated as: daily average regular rate x .50 (1.50 - 1.00).
- As either daily or weekly overtime hours are processed, if both the Job and the Craft/Class posted on the timecard indicate that weighted-average overtime should be applied, and either the Job or the Craft/Class indicate weighted-average overtime by day in particular, then this overtime rate adjustment is added to the posted rate on the timecard to yield the overtime rate. If it is not the case that both the Job and Craft/Class indicate weighted-average overtime, then regular overtime rates are used.
For example:
Posted Timecards for the Day
| Post Seq | Hours | Earn Code | Rate | Earnings | Wghtd Avg OT |
|---|---|---|---|---|---|
| 1 | 4 | 1 | 25.00 | 100.00 | Y |
| 2 | 6 | 1 | 30.00 | 180.00 | Y |
| Total | 10 | 280.00 |
Daily weighted-average regular rate = straight-time earnings divided by total hours
280.00 / 10 = $28.00
OT Factor = 1.50
OT Rate Adjustment = 14.00 (28.00 x .50 (1.50 - 1.00))
After OT is processed
| Post Seq | Hours | Earn Code | Rate | Earnings |
|---|---|---|---|---|
| 1 | 4 | 1 | 25.00 | 100.00 |
| 2 | 4 | 1 | 30.00 | 120.00 |
| 3 (New) | 2 | 2 | 44.00 (posted rate + OT rate adj (30.00 + 14.00)) | 88.00 |
| TOTAL | 308.00 | |||
Total Reg Hours for the Day = 8
Total OT Hours for the Day = 2 (2 hrs of reg earnings are converted to OT)
Total Earnings for the Day = $308.00
Posting Seq 2 is subject to weighted-average OT by day (say, based on its Job and Craft/Class), so when its hours are reduced by the 2 hours of OT, Seq 3 is added using the posted rate plus the overtime rate adjustment.
Overtime Calculations Using Weighted-average Rate by Week
- The system calculates a weighted-average regular rate for the week for each employee subject to overtime. This average is calculated as the sum of the employee’s straight-time earnings for the week divided by his total hours for the week (only earnings subject to OT with a factor of 1.0 are included).
- An overtime rate adjustment is then set as the average regular rate for the week times the OT factor less one. For example, if the OT factor is 1.50, the overtime rate adjustment is calculated as: weekly average regular rate x .50 (1.50 - 1.00)
- As either daily or weekly overtime hours are processed, if both the Job and the Craft/Class posted on the timecard indicate that weighted-average overtime should be applied, and both the Job and the Craft/Class also indicate weighted-average overtime by week in particular, then this overtime rate adjustment is added to the posted rate on the timecard to yield the overtime rate. If it is not the case that both the Job and Craft/Class indicate weighted-average overtime, then regular overtime rates are used.
For example:
| Post Seq | Hours | Earn Code | Rate | Earnings | Wghtd Avg OT |
|---|---|---|---|---|---|
| 1 | 30 | 1 | 10.00 | 300.00 | Y |
| 2 | 15 | 1 | 8.00 | 120.00 | N |
| 3 | 5 | 1 | 8.00 | 40.00 | Y |
| Total | 50 | 460.00 |
Weekly weighted-average regular rate = straight-time earnings divided by total hours
460.00 ÷ 50 = $9.2
OT Factor = 1.50
OT Rate Adjustment = $4.60 (9.20 x .50 (1.50 -1.00))
After OT is processed:
| Post Seq | Hours | Earn Code | Rate | Earnings |
|---|---|---|---|---|
| 1 | 30 | 1 | 10.00 | 300.00 |
| 2 | 10 | 1 | 8.00 | 80.00 |
| 3 | 5 | 2 | 12.60 (posted rate + OT rate adj (8.00 + 4.60)) | 63.00 |
| 4 (new) | 5 | 2 | 12.00 (posted rate x 1.5 | 60.00 |
| TOTAL | 503.00 | |||
Total Reg Hours = 40
Total OT Hours = 10 (10 hrs of reg earnings are converted to OT)
Total Earnings = $503.00
Posting Seq 3 is subject to weighted-average OT by week (say, based on its Job and Craft/Class), so it uses the posted rate plus the overtime rate adjustment.
The remaining 5 hours of OT are pulled from Seq 2, which is not subject to weighted-average overtime of any kind. A new Seq is added using the posted rate times the OT earnings factor (1.5), and the hours on Seq 2 are reduced accordingly.
