Home      Ask a Question      My Stuff      Help   
  
Blended Rate OT Calculation
For TimeWorks:

Go to > Accountant Menu > Change Pay Period / OT Rules > MULTIPLE PAY RATE BEHAVIOR there is the option "A. Add all the hours together and calculate a blended rate. Then calculate overtime based on that rate."


For TimeWorks Plus:

Go to > Accountant Menu > Processing Rules > Pay Rate Calculation (radio button) > BlendPayRates and follow the instructions to choose the blending method.


The way the system calculates this is to add up the total amount of pay (rates * hours) in a pay period then divide that by the amount of hours worked in that same pay period. It then uses that rate when promoting to OT.

For example an employee has 10 hours at a rate of $5.00 ($50.00) and 10 hours at $10.00 an hour ($100.00). It would take the total amount earned ($50 + $100 = $150) and then divide that by the total amount of hours worked ($150 / 20 = $7.50). So for OT promotion it would use $7.50 * 1.5 as the OT rate ($7.50 * 1.5 = $11.25).

$50.00 + $100.00 = $150 / 20 = $7.50 * 1.5 = $11.25 OT

ID
730
Category
<Unassigned>
Date Created
7/12/2012 2:10:38 PM
Date Updated
12/23/2014 11:40:36 AM
Back to Search Results