Pay rules for Computing Work Hours and Overtime Rates

Lookup table used for computing timesheet distribution work hours to get their salary on every pay period based on labor law percentage rates.

REGULAR DAY
REG Hr OT Hr ND Hr OTND Hr
100.00% 125.00% 10.00% 137.50%
REST DAY
REG Hr OT Hr ND Hr OTND Hr
130.00% 169.00% 10.00% 185.90%
SPECIAL HOLIDAY
REG Hr OT Hr ND Hr OTND Hr
130.00% 169.00% 10.00% 185.90%
SPECIAL HOLIDAY & REST DAY
REG Hr OT Hr ND Hr OTND Hr
150.00% 195.00% 10.00% 214.56%
REGULAR HOLIDAY
REG Hr OT Hr ND Hr OTND Hr
200.00% 260.00% 10.00% 286.00%
REGULARY HOLIDAY & REST DAY
REG Hr OT Hr ND Hr OTND Hr
260.00% 338.00% 10.00% 371.80%
DOUBLE HOLIDAY
REG Hr OT Hr ND Hr OTND Hr
300.00% 390.00% 10.00% 429.00%
DOUBLE HOLIDAY & REST DAY
REG Hr OT Hr ND Hr OTND Hr
390.00% 507.00% 10.00% 557.70%

REGULAR DAY

  • reg_pay = (item.reg_hrs + item.reg_nd_hrs) * ratePerHour;
  • reg_nd_pay = item.reg_nd_hrs * (ratePerHour * (OT_Rates.h_reg_nd_rate / 100));
  • reg_ot_pay = item.reg_ot_hrs * (ratePerHour * (OT_Rates.h_reg_ot_rate / 100));
  • reg_otnd_pay = item.reg_otnd_hrs * (ratePerHour * (OT_Rates.h_reg_otnd_rate / 100));

**Regular Day = reg_pay + reg_nd_pay + reg_ot_pay + reg_otnd_pay

REST DAY

  • rest_reg_pay = (item.rest_reg_hrs + item.rest_nd_hrs) * (ratePerHour * (OT_Rates.h_rest_rate/ 100));
  • rest_nd_pay = item.rest_nd_hrs * (ratePerHour * (OT_Rates.h_rest_nd_rate / 100));
  • rest_ot_pay = item.rest_ot_hrs * (ratePerHour * (OT_Rates.h_rest_ot_rate / 100));
  • rest_otnd_pay = item.rest_ot_hrs * (ratePerHour * (OT_Rates.h_rest_otnd_rate / 100));

**Rest Day = rest_reg_pay + rest_nd_pay + rest_ot_pay + rest_otnd_pay

Sample formula used in pinoy-web-application.com on how to compute salary on total work hours distribution after Timesheet Processing is done. Employee with a daily allowances the formula computation is [Allowance = Total Regular Hours * (Daily Allowance / 8)]. For the employee with monthly allowances the formula applied is [Allowance = Total Regular Hours * ((Monthly Allowance / 26) / 8).