Advanced Overtime Calculation—Exercises

Basic Data Setup

Purpose: The purpose of this exercise is to set up the basic data required for running this functionality. To enter this data, follow the instructions in the Administering Wage Codes, Administering Work Hour Rules and Administering Working Hours Schedules exercises. If you have already completed these exercises, the data you need should already be in the database, and you can proceed directly to the main exercises.

Main Exercises

Purpose: The purpose of this lesson is to show you how to handle functions such as replace normal clockings, flexible work time, and periodic calculation of overtime. 

Windows:
Work Hour Rules
Employee Schedules and Rules
Wage Codes
Time Card – Day
Time Card – Week
Overtime for Compensatory Time
PeriodicResult

Replace Normal Clockings

Purpose: The purpose of this exercise is to explore how overtime can be retrieved without forcing the employees to use the overtime in- and out-buttons on the clocking device.

Windows:
Work Hour Rules
Employee Schedules and Rules
Time Card – Day

  1. Open the Work Hour Rules window.
  2. Copy the overtime rule that you created in the Administering Work Hour Rules exercise, and rename this rule. 
  3. In the Replace Normal Clocking list, select Overtime Cash.
  4. Copy your rule type, rename it, and save your changes. Add your new overtime rule to the new rule type.
  5. Open the Employee Schedules and Rules window.
  6. Assign the new rule type to your employee. 
  7. Clear the Entitled to Overtime Compensation check box. 
  8. Open the Time Card – Day window.
  9. Make an overtime cash clocking sometime before the normal scheduled start. Make a normal clocking in the afternoon. Save your changes. What happened? Change the out time so that it is after your normal scheduled finish time. Are there any changes?
  10. Return to the Employee Schedules and Rules window, and select the Entitled to Overtime Compensation check box.
  11. Return to Time Card – Day window, and enter a normal clocking before the normal schedule start. It must be within the flex limit.
  12. Click the Result tab. What wage codes or time types are generated?
  13. Go back to the overtime rule. In the Replace Normal Clocking list, select No. Recalculate the day in the Time Card – Day window. What happens?
  14. If the Replace Normal Clocking list is set to Overtime Comp, how do you get cash for overtime instead of comp time issued that day?

Flexible Work Time

Purpose: The purpose of this exercise is to explore the use of flexible work time in the schedule connection.

Windows
Work Hour Rules
Employee Schedules and Rules
Time Card – Day

  1. Open the Work Hour Rules window, and click the Overtime tab.
  2. In the Replace Normal Clocking list, select No.
  3. Open the Employee Schedules and Rules window.
  4. Select the Flexible Work Time check box.
  5. Open the Time Card – Day window.
  6. Make a normal in stamp before your normal scheduled starts. Make an out clocking according to the schedule. Click the Result tab. Which wage codes or wage types were used to generate the results?
  7. Change the in time type to overtime cash. What happens?
  8. Change the out time type to overtime cash. What happens now?
  9. Return to the overtime rule. In the Replace Normal Clocking list, click Overtime Cash. Repeat the clocking you made in the previous step. Which wage codes or wage types were used to generate results?

Note: You will not get overtime when you clock in earlier than the scheduled start time and flexible work time is used. Overtime is issued only at the end of a workday when you use this parameter.

Periodic Overtime Calculation

Purpose: The purpose of this exercise is to explore the use of the periodic overtime calculation. 

Windows:
Work Hour Rules
Working Hours Schedules
Overtime for Compensatory Time
Schedules and Rules/Wage Codes
Wage Codes
Time Card – Day
Time Card – Week
Periodic Result

  1. Open the Work Hour Rules window, click the Overtime tab and use the overtime rule you created in the exercises above to complete the steps in this exercise.
  2. Click the Periodic – Basis tab, and note the following:
    1. Set the Period Unit to Days, and set the value in the Period Quantity field to 7. 
    2. Set the Period Start to a Monday (or Sunday if applicable) at least a couple of weeks back in time.
    3. The basis for calculation should be normal scheduled hours.
    4. The Payroll Transfer Variant field should be set to include a divided last weeks increment if calculated.
    5. There are no specific limits, and there is no filling-up absence wage code.
  3. Click the Periodic – Reduce Order tab. Enter the wage codes registered in the day types of your day schedule. In this example, the most expensive overtime wage code should always be reduced first.
  4. Click the Periodic – Increments tab. On this tab, you translate the basic overtime wage codes from the day types in your schedule, to the wage codes that should be generated in the periodic calculation.
  5. Create two new wage codes for the periodic calculation in the Wage Codes window. 
    1. One wage code to use for the first six hours of overtime. The wage code ID should be 380, and the first 6 hours of the lowest wage rate should go here.
    2. Another wage code to use for all other overtime up to 20 hours. The wage code ID should be 381.
    3. The overtime with the lowest wage rate is calculated first.

Note: If the employee has worked more than the total number of hours stated on the wage codes, these hours will disappear. In this example, the maximum overtime for one week is 26 hours.

  1. The overtime should be generated as follows:
    1. The first six hours of overtime increases pay by 50%. Use Wage Code 380.
    2. The following 20 hours of overtime increases pay by 100%. Use Wage Code 381. For the wage codes on row one to be included in the second row and for these hours not to disappear, these wage codes must appear the second row as well. 
    3. Enter the cash wage code and comp wage code from the Overtime for Compensatory Time window that have the same time basis, i.e., 1:1.5 for overtime, on one row. They have the same max hours and generate the same wage code. 
  2. Open the Time Card – Day window. Use your own employee. Return to last week. 
    1. Enter three hours of Overtime Cash for Monday. 
    2. Enter three hours of Overtime Cash for Tuesday. 
    3. Enter two hours of Overtime Comp for Wednesday. 
    4. Enter two hours of Overtime Cash for Thursday 
    5. Enter two hours of Overtime Comp for Friday.
  3. Open the Time Card – Week window, and query for your employee.
  4. Right-click and then click Execute Periodic Calculation. Choose the option Select Period. Choose period start and end dates from the List of Values to match the period to last week.
  5. Open the Periodic Result window. Populate and view the rows generated by the calculation. 
    1. You should get only six hours of Wage Code 380.
    2. There should be six hours overtime on Wage Code 381.
    3. The dates should be Monday through Sunday of last week.