Weighted Average (Blended) Overtime Example Calculations

For this example, assume that an employee normally earns $10 an hour working at trade shows, but receives a premium flat rate of $8.75 an hour for travel time. In one week the employee has earned 10 hours of travel time, and 40 hours worked at trade show. The employee in question earns “Daily” overtime.

Regular Rate Calculation

  1. The Weekly Hours Compensation is calculated. All hours worked during the week at different associated rate amounts are taken. Overtime hours are included, but at the rate worked with overtime not yet applied.

    • $10.00 an hour x 40 hours = $400.00

    • $8.75 an hour x 10 hours = $87.50 (flat rate overrides the base pay)

From the Pay Codes section of the program, Holidays and Absences are excluded, and Premiums and Regular amounts are included (as this only applies to amounts from hours worked). Hours can earn the Base Rate, Pay Level, and Premiums.

  1. The Total Weekly Compensation is calculated. Any Premium amounts awarded during the week are added.

    • $400 + 87.50 + 0 = $487.50

The ability exists to include or exclude Disbursements.

  1. The Regular Rate/Average Rate is calculated. The Total Weekly Compensation is divided by Weekly Total Hours (worked hours only).

    • $487.50 / 50 hours = $9.75

From the Threshold Pay Codes, any Worked pay codes and applicable Premium Pay Codes are included, and Holiday and Absence pay codes are excluded.

Weighted Average (Blended) Overtime Calculation

Important: Note that overtime rules for the state of California are different than those of other states. The following example uses the California OT formula of:
(Regular Rate * Multiplier) + Current Rate.

From the above example, assume that the same employee earned 2 hours of “Daily” overtime during the trade shows, 2 hours of “Daily” overtime for travel, and 6 hours of “Weekly” overtime for trade shows.

  1. The Weighted Average Overtime Rate (Blended OT) is calculated using the following formula: Regular Rate * Overtime Multiplier = Overtime Rate

    • Blended OT = $9.75 x 0.5 = $4.875 round = $4.88

    • Blended DT = $9.75 x 1 = 9.75

  1. The Earned Overtime Amount is calculated using the following formula: Overtime Rate + Actual Rate = Blended Overtime Rate.

    • 2 Hours Travel Time Blended OT Amount
      $4.88 (OT Rate) + $8.75 (Premium Flat Rate) = $13.63 Blended OT
      2 Hours * $13.63 = $27.26 Overtime Pay

    • 2 Hours Trade Show Blended OT Amount
      $4.88 (OT Rate) + $10.00 (Base Rate) = $14.88 Blended OT
      2 Hours * $14.88 = $29.76 Overtime Pay
    • 6 Hours Weekly Trade Show Blended OT Amount
      $4.88 (OT Rate) + $10.00 (Base Rate) = $14.88 Blended OT
      6 Hours * $14.88 = $89.28 Overtime Pay

icon_previous_topic.jpg