standard philippines wage and deductions.

PAYSLIP PREPARATION Using an e-spreadsheet application (or using a yellow paper following the format we discuss). prepare the payslip of the employee below: Mr. Kawaki Uzumaki (Emp. No: 19-0012) is an Assistant Cook of Thunder Burger at Konoha City. His daily rate is P920. Assume that the employee was exempted from any personal income tax. From his work, the following data for the Month of December 2021 were given: Variables Value No. of Days Present 23 No. of Overtime Hours No. of Night Shift Hours 12 No. of Rest Days Worked "Overtime Hours during his Rest Day **Regular Holiday, December 25 & 30, 2021 No of Special Days Worked No of Holidays Worked 2 Note: Deductions are based on the BASIC PAY. 11 4 ON PAYSLIP EMPLOYEE NAME EMPLOYEE NO. POSITION DAILY RATE PAY DATE No. of Days Present No. of Overtime Hours No. of Night No. of Rest Days No. of Special Days Shift Hours Worked Worked No. of Holidays Worked AMOUNT AMOUNT EARNINGS BASIC PAY OVERTIME PAY HOLIDAY PAY PREMIUM PAY NIGHT SHIFT DIFFERENTIAL OTHERS DEDUCTIONS SSS / GSIS PHILHEALTH PAG IBIG WITHHOLDING TAX OTHERS GROSS EARNINGS TOTAL DEDUCTIONS NET EARNINGS PAYSLIP PREPARATION Using an e-spreadsheet application (or using a yellow paper following the format we discuss). prepare the payslip of the employee below: Mr. Kawaki Uzumaki (Emp. No: 19-0012) is an Assistant Cook of Thunder Burger at Konoha City. His daily rate is P920. Assume that the employee was exempted from any personal income tax. From his work, the following data for the Month of December 2021 were given: Variables Value No. of Days Present 23 No. of Overtime Hours No. of Night Shift Hours 12 No. of Rest Days Worked "Overtime Hours during his Rest Day **Regular Holiday, December 25 & 30, 2021 No of Special Days Worked No of Holidays Worked 2 Note: Deductions are based on the BASIC PAY. 11 4 ON PAYSLIP EMPLOYEE NAME EMPLOYEE NO. POSITION DAILY RATE PAY DATE No. of Days Present No. of Overtime Hours No. of Night No. of Rest Days No. of Special Days Shift Hours Worked Worked No. of Holidays Worked AMOUNT AMOUNT EARNINGS BASIC PAY OVERTIME PAY HOLIDAY PAY PREMIUM PAY NIGHT SHIFT DIFFERENTIAL OTHERS DEDUCTIONS SSS / GSIS PHILHEALTH PAG IBIG WITHHOLDING TAX OTHERS GROSS EARNINGS TOTAL DEDUCTIONS NET EARNINGS