ABC COMPANY LATE/UNDERTIME DEDUCTION FOR THE MONTH OF JANUARY 2020 PAYROLL DEDUCTION MONTHLY SEMI MONTHLY NO OF HRS MONTHLY NO OF HRS NO OF DAYS DAILY (SM) (SM) RATE HOURLY RATE MINUTE ABSENCES RATE (MINUTES LATE TOTAL HRS TOTAL DEDUCTION GOKONGWEI 10,875.00 192 96 12 906.25 113.28 1.89 0 0 GREY 1 LACHICKA 7,624.50 192 96 12 635.38 79.42 1.32 0 11,624.50 192 96 12 968.71 121.09 2.02 0 2 LOPEZ 3 MAYERS 4NGUYEN 5ORTEGA 6 PARKER 8,620.00 8,115.00 192 96 12 718.33 89.79 1.50 0 7,756.00 6,830.00 6,866.00 7 PING 8,608.00 192 8 RAZON Page 12 676.25 84.53 1.41 0 646.33 80.79 1.35 0 569.17 71.15 1.19 0 Page 2 572.17 71.52 1.19 0 717.33 89.67 1.49 0 12,244.00 192 96 12 1,020.33 127.54 2.13 0 RODRIGUEZ 10,078.00 192 96 12 839.83 104.98 1.75 0 0 SALCEDO 12,374.50 192 96 12 1,031.21 128.90 2.15 0 1 SMITH 9,494.00 192 96 12 791.17 98.90 1.65 0 2 SY 16,272.00 192 96 12 1,356.00 169.50 2.83 0 3 TAN 14,772.00 192 96 12 1,231.00 153.88 2.56 0 4 UCHIHA 6,287.50 192 96 12 523.96 65.49 1.09 0 5 UZUMAKI 7,193.00 192 96 12 599.42 74.93 1.25 0 6 VALDEZ 11,471.00 192 96 12 955.92 119.49 1.99 0 7 VILLA 9,674.00 192 96 12 806.17 100.77 1.68 0 8 VILLAR 9 WILLIAMS 11,991.00 192 96 12 999.25 124.91 2.08 0 6,343.00 192 96 12 528.58 66.07 1.10 0 0 ZAMORA 8,474.00 192 96 12 706.17 88.27 1.47 0 GRAND TOTAL