B D E F G H 1 Wage 2 Net Total Rent NAPSA PAYE eductions 3 Pay 4 5 6 7 8 Name Qualifica Salary Bonus Gross P 1 Nyambe PhD 2 Mubita Diploma 3 Nawa Certificate 4 Phiri BBA 5 Banda Certificate 6 Bombe MBA 7 Malambc MBA 8 Mweem. Diploma 9 Chitalu BBA 10 Sampa Diploma TOTAL 9 10 11 12 13 14 15 16 17 75% 18 Salary Bonus 20% 90% 30% 125% 50% 185% 60% 235% 70% Certicate Diploma BBA MBA PhD Rent NAPSA 5% 2% 5% 4% 5% 5% 5% 7% 5% 10% PAYE 1.50% 2.00% 2.50% 3.00% 4.00% 19 20 21 22 23 24 25 26 27 Additional Information: 1 Wage is based on 12,500. 2 Payroll deductions are based on the basic salary 3 The Bonus is based on the basic salary Required: 1 Apply formulars to Cell D1. 2 Complete the payroll using formulars 3 Prepare a Journal Entry for the payroll 28 29 30 31 B D E F G H 1 Wage 2 Net Total Rent NAPSA PAYE eductions 3 Pay 4 5 6 7 8 Name Qualifica Salary Bonus Gross P 1 Nyambe PhD 2 Mubita Diploma 3 Nawa Certificate 4 Phiri BBA 5 Banda Certificate 6 Bombe MBA 7 Malambc MBA 8 Mweem. Diploma 9 Chitalu BBA 10 Sampa Diploma TOTAL 9 10 11 12 13 14 15 16 17 75% 18 Salary Bonus 20% 90% 30% 125% 50% 185% 60% 235% 70% Certicate Diploma BBA MBA PhD Rent NAPSA 5% 2% 5% 4% 5% 5% 5% 7% 5% 10% PAYE 1.50% 2.00% 2.50% 3.00% 4.00% 19 20 21 22 23 24 25 26 27 Additional Information: 1 Wage is based on 12,500. 2 Payroll deductions are based on the basic salary 3 The Bonus is based on the basic salary Required: 1 Apply formulars to Cell D1. 2 Complete the payroll using formulars 3 Prepare a Journal Entry for the payroll 28 29 30 31