HOW TO DO THE PAYROLL

HANDS-ON QUIZ #1 – PAYROLL

INSTRUCTIONS:
1. Create a payroll report using your QUIZZES WORKBOOK together with your other quizzes
previously.
2. Be sure that calculations are being done in the cell to earn points in your answers.
3. Analyze carefully the given data below before calculating.
4. Do not forget to attach this DOCUMENT FULLY ANSWERED AND THE QUIZZES Workbook
that you use in your submission.


DEDUCTIONS
EMPLOYEE DAILY HOURS DAYS
PAG- CASH
NO. RATE OVERTIME ABSENT TAX SSS CANTEEN
IBIG ADVANCE
1 300.00 20 0 10% 300.00 300.0 300.00
OF 0
2 350.00 20 1 THEIR 350.00 350.0 250.00
GROSS 0 20% OF
3 400.00 15 0 PAY 400.00 400.0 THEIR 200.00
0 GROSS
4 450.00 15 2 450.00 450.0 PAY 300.00
0
5 500.00 10 1.5 500.00 500.0 250.00
0
Additional Information:
 You are to make a payroll for a 13-days work
 The overtime rate per hour of employees is computed 10% of their daily rate




SOLVE FOR THE FOLLOWING AND SUPPLY THE ANSWERS BELOW.


EMPLOYEE OVERTIME GROSS TOTAL NET
ABSENCES
NO. PAY PAY DEDUCTIONS PAY

1 600.00 - 4500.00 2250.00 2250.00



2 700.00 350.00 4900.00 2420.00 2480.00



3 600.00 - 5800.00 2740.00 3060.00



4 675.00 900.00 5625.00 2887.50 2737.50



5 500.00 750.00 6250.00 3125.00 3125.00