Skip to Content
0
May 25, 2011 at 05:58 PM

Issue with Unpaid Absence for Rotating Shift Employees with Averaging Hours

134 Views

We run a biweekly payroll where full time employees are paid based on an 80 hr work shift per pay period. We have a requirement where employees in production are on a rotating shift. They may work 80, 88 or 72 hrs per pay period because their work schedule rule is defined this way. However, regardless if they worked 80, 88 or 72 hrs, these employees should still be paid based on 80 hrs of work (overtime will be paid extra). Currently, our system handles it this way.

However, a problem comes up when the employee has an unpaid absence for the period. The WT /801 is calculating a factor that results in incorrect pay. For example, if an employee has an hourly rate of $10 (biweekly rate of $ 800), with a work shift of 88 hrs and 24 hrs unpaid absence for the period, the rule KPPF is calculating the factor (/801) to be: 64/88 = .7272, and therby paying 581.76 ($800 x .7272). The calculation of /801 comes from the formula:

total hrs worked (88) - unpaid hrs (24)

-


total hrs worked (88)

Given our requirement, the correction calculation for the factor should be:

80 - 24 = .7

-


80

and the correct pay should be $560 ($800 x .7)

I tried modifying rule KPPF, along with KPP0 and KPP1 and was able to make it work to fit our requirements. However, the modification I made only works when there is only 1 WPBP record. If there are multiple WPBP records , possibly caused by an personnel action , change of IT0007 or IT0008 in the middle of the pay period, it becomes way too complicated to modify the rule to handle each and every scenario.

If anyone has come across a similar requirement, I would really appreciate if you could assist on how this should be handled.

Thanks.

Malou Navera