This page (revision-7) was last changed on 26-Nov-2021 10:22 by jmyers

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
7 26-Nov-2021 10:22 7 KB jmyers to previous
6 26-Nov-2021 10:22 7 KB jmyers to previous | to last
5 26-Nov-2021 10:22 12 KB jmyers to previous | to last
4 26-Nov-2021 10:22 12 KB jmyers to previous | to last
3 26-Nov-2021 10:22 2 KB JMyers to previous | to last
2 26-Nov-2021 10:22 2 KB JMyers to previous | to last
1 26-Nov-2021 10:22 2 KB JMyers to last

Page References

Incoming links Outgoing links
UPFLSABONUS
UPFLSABONUS

Version management

Difference between version and

At line 1 added 2 lines
[{TableOfContents }]
At line 2 changed one line
\\
!!Overview
When ever bonuses are paid to employees for prior period earnings, [FLSA] calculations are affected when any overtime hours were worked within the prior period. In normal situations, these earnings would be dated appropriately in the prior period and FLSA would be automatically invoked during the calculation of the employee pay. If that is the case, then this process is not required and the normal pay cycle will handle the reassessment of FLSA.\\ \\
If however these bonuses are considered part of the employee’s base wage, then the normal FLSA reassessment will not work since it would only use the employee wage as of the prior period. UPFLSABONUS adjusts the ‘Rate of Pay’ by the value of the bonus and then recalculates FLSA earnings to be paid in the prior ‘Bonus Period’.
The calculations used by this process are actually completely separate from the normal FLSA process and they do not cooperate with each other. It is important not to confuse the two since each considers the employee salary/compensation differently.\\ \\
There can be any number of different bonus periods; some examples are Monthly, Quarterly and Annual. Educational institutions will often have a ‘Semester’ or ‘Term’ bonus as well.
!!Calendar Definition
Each different bonus period (Monthly, Quarterly, Yearly etc) will require a unique calendar to be set up in order to define that bonus period. The calendar is defined in function Define Business Calendars ([IDCL]) form. A calendar can be of any duration and is restricted ONLY in that it must be contiguous from the first entry through to the last entry.\\ \\
Any of these calendars can easily be extended when needed by the ‘Extend Calendar’ button in IDCL.\\ \\
3 Element Definition
The User The formulae/Calculation used by UPFLSABONUS requires that ‘Elements’ be set up to calculate the total value for hours and earnings in a bonus period.
These are all required and UPFLSABONUS will terminate prematurely if any are missing.
An Element is required for ‘Regular Hours’. These are any ‘Worked Hours’ that are paid at a regular rate of Pay.
An Element is required for ‘Overtime Hours’. These are any ‘Worked Hours’ that are paid at 1.5 times the regular rate of Pay.
An Element is required for ‘Double time Hours’. These are any ‘Worked Hours’ that are paid at 2 times the regular rate of Pay.
4 FLSA Pay Component Definition
One Earnings Pay Component must be set up. This Pay Component is used to record any calculated FLSA on the prior period earnings.
Although there can be multiple ‘Bonus Periods’, only one ‘FLSA Earnings’ Pay Component should be setup. When recording any FLSA Earnings into this component, any values previously given are taken into consideration so that the FLSA is not overpaid.
This Pay Component should be defined as shown below. Be sure to toggle the Pay Component as ‘Store Results’.
5 Bonus Pay Components
For each different Bonus Period, a separate Pay Component must be set up for the actual Bonus Earnings. This Pay Component is used to record the actual Bonus Earnings for each employee when the Bonus Pay is entered before running UPFLSABONUS.
Separate Pay Components for each type are necessary to keep the bonus earnings separated for each type of bonus period.
An example of one is shown below.
6 The Calculations
For the Bonus Batch selected, Pay is evaluated for the bonus period to determine if any additional FLSA earnings need to be recorded.
Each of the Pays with a ‘Pay Issue Date’ within the bonus period is evaluated separately.
The formulae used on each pay is exactly as shown below. Dates and values have been plugged in to better illustrate the calculations.
Bonus earnings in the batch must be dated on the last day of the Bonus Period.
(A) Hourly Rate of Pay on 11-May-2007 ==> $41.03/HR
(B) Quarterly Incentive from 01-Jan-2007 to 31-Mar-2007 ==> $1,000.00
(C) Regular Hours from 01-Jan-2007 to 31-Mar-2007 ==> 144.00
(D) Overtime Hours from 01-Jan-2007 to 31-Mar-2007 ==> 7.00
(E) Double time Hours from 01-Jan-2007 to 31-Mar-2007 ==> 7.00
(F) Quarterly Regular Earnings: $5,907.69 = (A) $41.03 X (C) $144.00
(G) Quarterly Regular Plus Incentive: $6,907.69 = (B) $1,000.00 + (F) $5,907.69
(H) Quarterly Adjusted Rate: $47.97 = (G) $6,907.69 / (C) $144.00
(I) Quarterly Hourly Rate Increment: $6.94 = (H) $47.97 - (A) $41.03
(J) Quarterly Overtime FLSA: $72.92 = (I) $6.94 * (D) $7.00 * 1.5
(K) Quarterly Overtime FLSA: $97.22 = (I) $6.94 * (D) $7.00 * 2.0
(L) Quarterly FLSA Total: $170.14 = (J) $72.92 + (K) $97.22 * 2.0
(M) Quarterly FLSA Previously Paid: $0.00
(N) Quarterly FLSA Retroactive Added: $170.14
The FLSA earnings (N) are logged into the same batch as the Bonus Earnings. This batch is provided as a Report Parameter.
When any FLSA is recorded the Bonus Pay (As well as the Batch) is marked as ‘To Be Audited’. UPAUDT must be executed before the Bonus Batch of Incentive Earnings and FLSA Earnings (Added here) can be paid to the Employee.
7 Report Parameters
Each type of Bonus Period is processed separately. For example, the ‘Monthly’ Bonus is executed separately from the ‘Term Bonus’. Be careful to select the correct ‘Bonus Pay Component’ for the type of Bonus.
The single Batch Number selected contains the Bonus Earnings for each Employee paid a bonus. There can be more than one Bonus Batch, however they are processed separately.
8 Report Output
The output consists of Execution Run Logs only. Any errors and warnings are logged here. All FLSA is recorded into the batch selected on the parameter form, and the results can be seen by printing UPAUDT for the batch.
Generate FLSA on Prior Bonus Earnings
Execution # 307024
Function: UPFLSABONUS
Run By: RDEPAPP
Run Start Date: Mar 9, 2010 11:54:52 AM
Entity: USA CITY
Payroll: BW HOURLY
Bonus Batch Number: 8987
Bonus Calendar: MONTHLY
Bonus Period: 200701
Trial: Yes
Exception Level: 1-User Trace
User Comment: Rudy Comment
Bonus Pay Component: 1121
FLSA Pay Component: 1225
Regular Hours: REG HOURS
Overtime Hours: OT HOURS 1.5
Double Time Hours: OT HOURS 2.0
Lv Module Context Message
1 RETROFLSA FLSA Bonus Calculator Version 20100309
1 RETROFLSA BONUS Calendar (MONTHLY) Monthly Payroll
1 RETROFLSA BONUS Period (200701) From 01-JAN-2007 to 31-JAN-2007
0 RETROFLSA Trial: Y
0 RETROFLSA Process Bonus Batch number 8987
1 RETROFLSA Bonus Pay Component: (1121) Monthly Incentive Bonus $
1 RETROFLSA FLSA Pay Component: (1225) FLSA on Incentive Bonus
1 RETROFLSA Regular Hours Element: (REG HOURS) Regular Hours
1 RETROFLSA Overtime Hours Element: (OT HOURS 1.5) Overtime Hours
1 RETROFLSA Double Time Hours Element: (OT HOURS 2.0) OT Hours at 2.0
1 RETROFLSA Period Begin Date: 01-JAN-2007
1 RETROFLSA Period End Date: 31-JAN-2007
1 RETROFLSA FLSA Bonus Calculator Version 20100309
1 RETROFLSA ***************************
| (BONUS 1) Mckenzie, Bob |
***************************
1 RETROFLSA Bonus Before Bonus End Date: $0.00
1 RETROFLSA Bonus on Bonus End Date: $750.00
1 RETROFLSA Bonus After Bonus End Date: $0.00
1 RETROFLSA ***************************
| (BONUS 1) Mckenzie, Bob |
***************************
1 RETROFLSA Rate of Pay on 11-MAY-2007 ==> $80,000.00/YR
1 RETROFLSA (A) Hourly Rate of Pay on 11-MAY-2007 ==> $41.03/HR
1 RETROFLSA (B) Incentive from 01-JAN-2007 to 31-JAN-2007 ==> $750.00
1 RETROFLSA (C) Regular Hours from 01-JAN-2007 to 31-JAN-2007 ==> 144.00
1 RETROFLSA (D) Overtime Hours from 01-JAN-2007 to 31-JAN-2007 ==> 7.00
1 RETROFLSA (E) Doubletime Hours from 01-JAN-2007 to 31-JAN-2007 ==> 0.00
1 RETROFLSA (F) Regular Earnings: $5,907.69 = (A) $41.03 X (C) $144.00
1 RETROFLSA (G) Regular Plus Incentive: $6,657.69 = (B) $750.00 + (F) $5,907.69
1 RETROFLSA (H) Adjusted Rate: $46.23 = (G) $6,657.69 / (C) $144.00
1 RETROFLSA Rate increased by $5.21
1 RETROFLSA (I) Hourly Rate Increment: $5.21 = (H) $46.23 - (A) $41.03
1 RETROFLSA (J) Overtime FLSA: $54.69 = (I) $5.21 * (D) $7.00 * 1.5
1 RETROFLSA (K) Overtime FLSA: $0.00 = (I) $5.21 * (E) $0.00 * 2.0
1 RETROFLSA (L) FLSA Total: $54.69 = (J) $54.69 + (K) $0.00 * 2.0
1 RETROFLSA (M) FLSA Previously Paid: $0.00
1 RETROFLSA (N) FLSA Retroactive Added: $54.69
1 RETROFLSA FLSA Bonus Calculator Version 20100309
1 RETROFLSA *****************************
| (BONUS 2) Mackenzie, Doug |
*****************************
1 RETROFLSA Bonus Before Bonus End Date: $0.00
1 RETROFLSA Bonus on Bonus End Date: $700.00
1 RETROFLSA Bonus After Bonus End Date: $0.00
1 RETROFLSA *****************************
| (BONUS 2) Mackenzie, Doug |
*****************************
1 RETROFLSA (A) Hourly Rate of Pay on 11-MAY-2007 ==> $28.00/HR
1 RETROFLSA (B) Incentive from 01-JAN-2007 to 31-JAN-2007 ==> $700.00
1 RETROFLSA (C) Regular Hours from 01-JAN-2007 to 31-JAN-2007 ==> 144.00
1 RETROFLSA (D) Overtime Hours from 01-JAN-2007 to 31-JAN-2007 ==> 10.00
1 RETROFLSA (E) Doubletime Hours from 01-JAN-2007 to 31-JAN-2007 ==> 0.00
1 RETROFLSA (F) Regular Earnings: $4,032.00 = (A) $28.00 X (C) $144.00
1 RETROFLSA (G) Regular Plus Incentive: $4,732.00 = (B) $700.00 + (F) $4,032.00
1 RETROFLSA (H) Adjusted Rate: $32.86 = (G) $4,732.00 / (C) $144.00
1 RETROFLSA Rate increased by $4.86
1 RETROFLSA (I) Hourly Rate Increment: $4.86 = (H) $32.86 - (A) $28.00
1 RETROFLSA (J) Overtime FLSA: $72.92 = (I) $4.86 * (D) $10.00 * 1.5
1 RETROFLSA (K) Overtime FLSA: $0.00 = (I) $4.86 * (E) $0.00 * 2.0
1 RETROFLSA (L) FLSA Total: $72.92 = (J) $72.92 + (K) $0.00 * 2.0
1 RETROFLSA (M) FLSA Previously Paid: $0.00
1 RETROFLSA (N) FLSA Retroactive Added: $72.92
1 RETROFLSA Number of Incentive Bonus Pays 2
1 RETROFLSA Number of FLSA Lines Added ==> 2
1 RETROFLSA Amount of FLSA Added ==> 127.61
1 RETROFLSA All Data has been Rolled Back
1 P2K_PMRPT CREATE_MEX Starting create_mex p_mfn_id = 4272 v_mex.id: 307024
1 P2K_PMRPT CREATE_MEX Starting create_mex UPDATE p2k_am_executions SET id = 307024,DESTYPE = 'CACHE',PRINT_ORIENTATION = 'PORTRAIT',RETURN_CODE = '00',DESFORMAT = 'PDF',DESTINATION = 'REPMERCURY' WHERE id = 307024
1 INIT Init k_trace_level: 1, k_sort_stage=10, k_sort_thread=0
This page (revision-7) was last changed on 26-Nov-2021 10:22 by jmyersTop