Preprocessing overtime example
Use overtime preprocessing to change the way in which worked time is allocated to be paid. You can specify how hours are paid under specific criteria, for example, a requirement that a regular-hours threshold is met before overtime is paid.
Consider the following scenario: There is an overtime rule requiring employees to work 39 hours in a week before any overtime is counted as payable. There are daily overtime rules that also apply:
- Daily OT 8.5 — An employee working more than 8.5 hours in a day is paid 1.5 times the regular pay rate.
- Daily OT 12.5 — An employee working more than 12.5 hours in a day is paid 2.0 times the regular pay rate.
Using overtime preprocessing, when an employee does not reach 39 weekly hours with regular time, overtime can be used to reach that threshold. The overtime that would qualify as Daily OT 12.5 type hours paid at the regular rate first.
Setup for the overtime, combination rules, and pay code distribution that governs how this employee is paid:
Overtime and Combination Rules | Definition | Payout Rate (based on Pay Code Distribution) |
---|---|---|
Daily OT 8.5 (overtime preprocessing is selected) | Daily overtime @ 1.5 regular pay for more than 8.5 hours | Regular rate |
Daily OT 12.5 (overtime preprocessing is selected) |
Daily overtime @ 2.0 regular pay for more than 12.5 hours |
Regular rate |
Weekly Over 39 | Sets minimum number of weekly hours (39) before daily overtime is paid | Regular rate under 39 hours, overtime over 39 hours |
Daily over 8.5 + Weekly over 39 | Daily overtime @ 1.5 regular pay if weekly overtime is more than 39 hours | 1.5 times regular rate |
Daily OT 12.5 + Weekly 39 | Daily overtime @ 2.0 regular pay if weekly overtime is more than 39 hours | 2.0 time regular rate |
The processing order for the overtime rules is chronological with rules listed in the Total Last option box as:
- Daily OT 12.5 (first)
- Daily OT 8.5 (second)
When processing occurs without overtime preprocessing, the Total Last order does not take effect because the processing logic uses any daily hours accumulated beyond 8.5 hours to meet the weekly Over 39 hours rule. The Over 8.5 hours threshold is always reached before the Over 12.5 hours threshold, so the Over 8.5 hours are used first for meeting the 39-hour minimum.
When processing occurs with overtime preprocessing, the Total Last order does take effect and Daily OT 12.5 hours, which are marked as a separate set of hours, can be used first to backfill the 39 weekly hours for regular pay. With overtime preprocessing, hours can be processed in an order that is “out-of order.”
This employee works the following schedule during a week.
Day | Working Time | Worked Hours |
---|---|---|
Monday | 9 AM to 11 PM | 14 hours |
Tuesday | 9 AM to 5 PM | 8 hours |
Wednesday | 9 AM to 5 PM | 8 hours |
Thursday | 9 AM to 1 PM | 4 hours |
Friday | 9 AM to 11 PM | 14 hours |
|
Total Hours | 48 hours |
Daily hours for this schedule are accumulated as follows:
Day | Worked Hours | Marked hours |
---|---|---|
Monday | 14 hours |
8.5 hours regular time 4 hours overtime applying the Daily Over 8.5 rule 1.5 hours applying the Daily Over 12.5 rule |
Tuesday | 8 hours |
8 hours regular time |
Wednesday | 8 hours |
8 hours regular time |
Thursday | 4 hours |
4 hours regular time |
Friday | 14 hours |
8.5 hours regular time 4 hours overtime applying the Daily Over 8.5 rule 1.5 hours overtime applying the Daily Over 12.5 rule |
Totals for the week | 48 hours | 37 hours regular time, 8 hours applying the Daily Over 8.5 rule, 3 hours applying the Daily Over 12.5 rule |
Because the total number of regular hours does not reach the 39-hour weekly minimum, some of the daily overtime hours are used as backfill. These hours are paid as regular time.
The selection of overtime hours to be paid as regular time varies, depending on the selection of overtime preprocessing, as illustrated in the following cases.
With overtime preprocessing selected: Hours are paid as follows:
Day | Worked Hours | Paid hours |
---|---|---|
Monday | 14 hours |
10 hours regular time (includes 1.5 hours of the Daily Over 12.5 hours time) 4 hours overtime at 1.5 the regular rate |
Tuesday | 8 hours | 8 hours regular time |
Wednesday | 8 hours | 8 hours regular time |
Thursday | 4 hours | 4 hours regular time |
Friday | 14 hours |
9 hours regular time (includes 0.5 hour of the Daily Over 12.5 hours time) 4 hours overtime at 1.5 the regular rate 1.0 hours overtime at 2.0 times the regular rate |
Totals for the week |
48 hours |
39 hours regular time, 8 hours overtime at 1.5 the regular rate, 1 hour at 2.0 times the regular rate |
Without overtime preprocessing: The hours are paid as follows:
Day | Worked Hours | Paid hours |
---|---|---|
Monday | 14 hours |
10.5 hours regular time 2 hours overtime at 1.5 the regular rate 1.5 hours overtime at 2.0 times the regular rate |
Tuesday | 8 hours | 8 hours regular time |
Wednesday | 8 hours | 8 hours regular time |
Thursday | 4 hours | 4 hours regular time |
Friday | 14 hours |
8.5 hours regular time 4 hours overtime at 1.5 the regular rate 1.5 hours overtime at 2.0 times the regular rate |
Totals for the week | 48 hours |
39 hours regular time, 6 hours overtime at 1.5 the regular rate, 3 hours overtime at 2.0 times the regular rate |
These two calculations differ with respect to the time that is counted to meet the 39 hour weekly rule and therefore the overtime that is paid.
When overtime preprocessing is in effect, hours from an overtime category are paid as regular time, using the Daily Over 12.5 hours type first and the Daily Over 8.5 hours type second. The “out-of-order” setup pays Daily Over 12.5 type hours from both Monday and Friday as regular time, leaving most of the remaining overtime as the Daily Over 8.5 hours type.
When overtime preprocessing is not in effect, overtime hours are counted chronologically as regular time until 39 hours are reached. The remaining hours are designated overtime using the overtime rules that apply for each day.