Payroll Part1

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 3

Employee Payroll Mr.

Sansen
Hours Worked
Last Name First Name Hourly wage 1-Jan 8-Jan 15-Jan
Colipano Sansen ₱ 15.00 41 40 41
Bagas Roxanne ₱ 22.00 42 41 42
Diamante Romena ₱ 33.00 41 42 42
Colipano Dann ₱ 44.00 40 35 23
Nadine Lustre ₱ 55.00 41 45 12
Reid James ₱ 12.00 41 41 42
Pascual Piollo ₱ 32.00 42 42 45
Curtis Anne ₱ 42.00 42 32 43
Geronimo Sarah ₱ 52.00 42 31 46
Gabule James ₱ 12.00 45 35 45
Bond James ₱ 12.00 46 41 47
Holmes Shelrlock ₱ 12.00 47 41 31
Michael John ₱ 34.00 48 41 38
Mouse Micky ₱ 45.00 46 42 41
Mouse Minny ₱ 64.00 45 43 41
Roiles Sansen ₱ 45.00 43 25 47
Juab Mialene ₱ 454.00 39 42 31

Max ₱ 454.00 48
Minimum ₱ 12.00 39
Average ₱ 57.94 43
Total 731
Overtime hours pay
22-Jan 29-Jan
40 40 1 ₱ 615.00
41 40 2 ₱ 924.00
41 40 1 ₱ 1,353.00
39 40 0 ₱ 1,760.00
32 40 1 ₱ 2,255.00
24 40 1 ₱ 492.00
23 40 2 ₱ 1,344.00
12 40 2 ₱ 1,764.00
22 40 2 ₱ 2,184.00
41 40 5 ₱ 540.00
4 40 6 ₱ 552.00
48 40 7 ₱ 564.00
30 40 8 ₱ 1,632.00
31 40 6 ₱ 2,070.00
31 40 5 ₱ 2,880.00
41 40 3 ₱ 1,935.00
42 40 0 ₱ 17,706.00

₱ 17,706.00
₱ 492.00
₱ 2,386.47
₱ 40,570.00
overtime bunos Total

₱ 7.50 ₱ 622.50
₱ 22.00 ₱ 946.00
₱ 16.50 ₱ 1,369.50
₱ - ₱ 1,760.00
₱ 27.50 ₱ 2,282.50
₱ 6.00 ₱ 498.00
₱ 32.00 ₱ 1,376.00
₱ 42.00 ₱ 1,806.00
₱ 52.00 ₱ 2,236.00
₱ 30.00 ₱ 570.00
₱ 36.00 ₱ 588.00
₱ 42.00 ₱ 606.00
₱ 136.00 ₱ 1,768.00
₱ 135.00 ₱ 2,205.00
₱ 160.00 ₱ 3,040.00
₱ 67.50 ₱ 2,002.50
₱ - ₱ 17,706.00

₱ 160.00 ₱ 17,706.00
₱ - ₱ 498.00
₱ 47.76 ₱ 2,434.24
₱ 812.00 ₱ 41,382.00

You might also like