The U.S. Department of Labor Employment Standards Administration Wage and Hour Division states, “Unless specifically exempted, employees covered by the Act must receive overtime pay for hours worked in excess of 40 in a workweek at a rate not less than time and one-half their regular rates of pay . . . Where an employee in a single workweek works at two or more different types of work for which different straight-time rates have been established, the regular rate for that week is the weighted average of such rates. That is, the earnings from all such rates are added together and this total is then divided by the total number of hours worked at all jobs.” This information originates from the following website: http://www.dol.gov/esa/regs/compliance/whd/whdfs23.htm.
Weighted average rate is a rate that is calculated by adding the labor amount from several timesheet lines and dividing that sum by the total number of hours from those timesheet lines. This concept is critical for employees who perform contract work, where different pay rates are assigned to different projects.
You can determine and apply weighted average rates based on screen settings and the rules assigned to the Timesheet Cycle in the Weighed Average Overtime Setup screen.
Only employees whose pay class and FLSA Exempt status match one of the selected pay class/FLSA exempt status combinations from the Weighed Average Overtime Setup screen are selected for processing.
This program gives you the option of processing all unposted timesheets when recasting the overtime premium. If this utility finds a posted timesheet for which a new weighted average rate should be applied, it generates a warning report notifying you that the Retroactive Timesheet Adjustments utility needs to be executed.
You have the option to apply weighted average to all unposted timesheets for the login company or just one Timesheet Cycle/Timesheet Period combination.
Run this screen after entering regular timesheets but before processing them to Payroll, computing leave, or posting them to the General Ledger. This screen recomputes only "R-Regular," "D-Replacement," and "L-Labor-Only" timesheets; other timesheet types ("Correcting," "Bonus," etc.) are not processed. If you are also using the Recast Overtime Premium utility, you must run it after this utility. If you do not run this utility program first, the correct overtime premium amounts will not be recasted for hourly non-exempt employees.
Use this group box to select the timesheet cycle or cycles you want to recompute.
Select this checkbox to process all timesheet cycles and timesheet periods with unposted timesheets. Selecting this checkbox disables the Timesheet Period and Weighted Average Period group boxes.
If you did not select All Timesheet Cycles, you must enter, or use Lookup to select, a timesheet cycle here. Entering a value here enables the Timesheet Period and Weighted Average Period group boxes.
Only employees whose pay class and FLSA exempt status match one of the selected pay class/FLSA exempt status combinations from the Weighted Average Overtime Setup screen will be selected for processing.
If the Timesheet Cycle you entered has a Period Type of Timesheet Period in the Weighted Average Overtime Setup screen, you must use this group box to enter the start date and end date of the timesheet period you want to process. Lookup displays the start dates and end dates of all valid timesheet periods.
Enter, or use Lookup to select, the start date of the timesheet period you want to process. After you select the date, the application automatically enters the end date in the End Date field for this timesheet period.
Enter, or use Lookup to select, the end of the timesheet period you want to process. If you did not enter a date in the Start Date field but enter an end date here, the application automatically inserts the start date for this timesheet period in the Start Date field.
If the Timesheet Cycle you entered has a Period Type of Weighted Average Period in the Weighted Average Overtime Setup screen, you must use this group box to enter the start date and end date of the timesheet period you want to process. Lookup displays the start dates and end dates of all valid timesheet periods.
Enter, or use Lookup to select, the start date of the timesheet period you want to process. After you select the date, the application automatically enters the date in the End Date field for this timesheet period.
Enter, or use Lookup to select, the end of the timesheet period you want to process. If you did not enter a date in the Start Date field but enter an end date here, the application automatically inserts the start date for this timesheet period.
If the Period Type assigned to the Timesheet Cycle is “Weighted Average Period” in the Weighed Average Overtime Setup screen and weighted average is processed for a period, the weighted average period’s Processed flag in the Weighed Average Periods table will be set to “Y” (Yes).
This non-editable field displays the status of the report.
Select this button on the toolbar to begin the recomputing process. You must have already printed the report (while still in this screen) to enable this button.
Select this button on the toolbar to print the report and then continue immediately into the recomputing process.
There are several important timing and processing considerations when using this program:
You should run this screen after entering regular timesheets, but before processing or posting them in any way, or before exporting them to your outside payroll service.
This program recomputes only "R" (Regular), "D" (Replacement), and "L" (Labor Only) timesheets; it will not recompute other timesheet types ("Correction," "Bonus," etc.), and each timesheet will be recomputed by itself, even if several are included in the selected time range.
If an employee's hourly rate is changed in the Salary Info and History screen in Costpoint Employee after the timesheets are entered but before this program has been run, the weighted average hourly rate will not be correct.
All overtime pay types are recomputed even if you selected the Recalculate radio button in the Weighted Average Rate group box in the Pay Types screen.
Back up the Timesheet file before beginning this process so that you can return to the original files if necessary.
This screen updates the following tables:
Timesheet Line - TS_LN - Regular timesheets that are recomputed are updated to the Timesheet Line file; the eligible timesheet lines have their labor costs adjusted.
Timesheet Header - TS_HDR
Timesheet Line - TS_LN
Weighted Average Setup - WT_AVG_SETUP - This table stores setup information so that Costpoint has a record of what kind of timesheets were selected for a specific timesheet cycle. This information is required by the Retroactive Timesheet Adjustments utility.