Weighted Average Overtime

From your , ,

Applies to , , ,

Overview

If an employee works more than one position with different pay rates in the work week, When I Work calculates an employee’s overtime using the weighted average wages of the positions worked.

Considerations

  • Weighted average overtime is currently only supported on weekly or every two week pay periods.
  • Weighted average overtime is only calculated on the payroll exports.

Weighted average overtime calculation

Calculate weighted average overtime by following these steps:

  1. Calculate the ratio of hours worked across all positions worked. Divide the hours worked in a certain position by the total worked hours.
  2. Find the number of overtime hours attributable to each position. Take the total number of hours worked in the week and subtract by the weekly overtime threshold. Then multiply by the ratio of hours worked for that position.
  3. Find the regular worked hours for each position. Subtract the total hours worked in a position from the number of overtime hours that are attributable to that position.
  4. Calculate the regular pay for each position by multiplying the regular hours by the the position’s wage rate. Then calculate overtime hours for each position by multiplying the overtime hours by the positions wage rate multiplied 1.5
  5. Calculate the attributed pay. Add together the regular and overtime pay for each position.

Example calculation

In this example:

  • The employee works two different positions during the week:
    • Roaster at $20/hour for 8 hours.
    • Barista at $10/ hour for 40 hours.
  • The account’s weekly overtime threshold is set to 40 hours/week.
  1. Calculate the ratio of hours worked:
    PositionRoaster
    Calculation8 / (8 + 40) = 16.67 %
    PositionBarista
    Calculation40 / (8 + 40) = 83.33%
    Position Calculation
    Roaster 8 / (8 + 40) = 16.67 %
    Barista 40 / (8 + 40) = 83.33%
  2. Calculate the number of overtime hours for each position:
    PositionRoaster
    Calculation(48 – 40) x 16.67% = 1.333333333
    PositionBarista
    Calculation(48-40) x 83.33% = 6.666666666
    Position Calculation
    Roaster (48 – 40) x 16.67% = 1.333333333
    Barista (48-40) x 83.33% = 6.666666666
  3. Calculate the regular hours for each position:
    PositionRoaster
    Calculation8 – 1.333333333 = 6.666666667
    PositionBarista
    Calculation40 – 6.666666667 = 33.333333333
    Position Calculation
    Roaster 8 – 1.333333333 = 6.666666667
    Barista 40 – 6.666666667 = 33.333333333
  4. Calculate the regular and overtime pay for each position:
    PositionRoaster
    Wage20
    Regular pay calculation20 x 6.666666667 = $133.3333
    Overtime pay calculation20 x 1.333333333 x 1.5 = $40.00
    PositionBarista
    Wage10
    Regular pay calculation10 x 33.333333333 = $333.3333
    Overtime pay calculation 10 x 6.666666667 x 1.5 = $100.00
    Position Wage Regular pay calculation Overtime pay calculation
    Roaster 20 20 x 6.666666667 = $133.3333 20 x 1.333333333 x 1.5 = $40.00
    Barista 10 10 x 33.333333333 = $333.3333  10 x 6.666666667 x 1.5 = $100.00
  5. Find the total attributed pay: (133.3333 + 333.3333) + (40.00 + 100.00) = $606.6667 The Adjusted Hourly Rates for the example employee are as follows:
    Adjusted Hourly Rate
    606.6667 / 48 = $12.6389
    Adjusted Overtime Hourly Rate
    140 / 8 = $17.50
    Adjusted Hourly Rate 606.6667 / 48 = $12.6389
    Adjusted Overtime Hourly Rate 140 / 8 = $17.50
Updated on November 20, 2019

Was this article helpful?

Related Articles

Still Need Help?

Open a ticket with our customer care team.

Submit a Ticket