Question

Financial Accounting AC1130 Question #1 Complete the Payroll Register using the following information: Required: You are the Payroll Manager for Potter Corp. Complete the payroll register for the month ending January 31, 2020. Note: • Hours in excess of 160 in any given month are paid at time and a half to all employees, including salaried employees • The Qatari employees receive QR 700 Social Allowance per month • All Canadian employees contribute QR 60 towards social club fees. Ron Weasley, and Neville Longbottom receive a housing allowance of QR 3,000 per month . This is the last month of employment after a 5 year contract for Hermione Granger. End of service gratuity is paid at a rate of 3 weeks pay for each year of service. Round your numbers to the nearest 2 decimal points Hours Hr. Rate/ Employee Name Nationality Week 3 Week 4 Total Week 1 Harry Potter Qatar Ron Weasley Canada Luna Lovegood Spain Hermione Granger Canada Draco Malfoy England Rubeus Hagrid Canada Albus Dumbledoor Qatar Serius Black Spain Minerva McGonagal Qatar Neville Longbottom Ireland Salary 4,600.00 45.00 35.00 3,600.00 2,600.00 30.00 4,800.00 32.00 4,000.00 34.00 COLLEGE OF THE NORTH ATLANTIC) |[Assi

Answer 1

Earnings Allowances Deductions Housing QNP Gross Pay Allowance Allowance Special Service gratuity Nationality hr rate/ Salary Hrs Worked Regular Overtime and Other Calculations Social Club Net pay Name Harry Potter Ron Weasley Qatar 4600 160 4600 0 4600 700 0 5300 472.5 (167-160) *45*1.5 Canada 45 167 7515 7987.5 0 3000 60 10927.5 Luna Lovegood 315 (166-160)*35*1.5 Spain 35 166 5810 6125 0 6125 Three weeks payNo. of 3540 years of service (5) Three Weeks pay 3600* 3/4 Hermione Granger Canada 3600 160 3600 0 3600 0 60 2700 gratuity 2700*5 13500 2600 1.5*(165- 160)/160 Draco Malfoy England 2600 165 2600 121.875 2721.875 0 2721.875 Rebeus Hagrid Canada 30 145 4350 0 4350 60 4290 4800 1.5*(180- 900 160)/160 6400 Albus Dumbledore Qatar 5700 4800 180 4800 700 Spain 32 Serious Black 153 4896 0 4896 0 4896 4000 1.5*(176- 600 Minerva McGonagal Qatar 4000 176 4000 4600 700 5300 160)/160 Neville Longbottem Ireland 5610 255 (165-160)*34*1.5 5865 3000 34 165 0 0 8865 Total 47781 50445.38 2100 2664.375 6000 180 58365.375

Note - As no information was given about Qatar National Pension, the column has remain blank. If Deduction of 5% of gross pay is considered for QNP, then Payroll will be as following

Earnings Allowances Deductions QNP (5% of Gross Social Club Net pay Special Housing Allowance Allowance Pay) Nationality hr rate/ Salary Hrs Worked Regular Overtime and Other Calculations Gross Pay Name Harry Potter 4600 5070.00 Qatar 4600 160 0 4600 700 230 0 Ron Weasley Luna Lovegood 472.5 (167-160) *45*1.5 Canada 10528.13 45 167 7515 7987.5 3000 399.375 60 315 (166-160) 35*1.5 6125 Spain 35 166 5810 0 306.25 0 5818.75 Hermione Granger Canada 3600 3600 160 3600 0 180 60 3360.00 0 0 2600 1.5*(165- 160)/160 2585.78 Draco Malfoy England 2600 165 2600 121.875 2721.875 0 136.0938 0 Rebeus Hagrid Canada 217.5 4072.50 30 145 4350 0 4350 0 60 4800 1.5*(180- 900 Albus Dumbledore Qatar 285 4800 180 4800 5700 700 0 6115.00 160)/160 Serious Black 4896 Spain 32 153 4896 0 0 244.8 4651.20 4000*1.5*(176- 600 160)/160 Minerva McGonagal Qatar 4000 176 4000 4600 700 230 0 5070.00 Neville Longbottem Ireland 255 (165-160) 34*1.5 34 165 5610 5865 3000 293.25 0 8571.75 180 55843.106 Total 50445.38 47781 2664.375 2100 6000 2522.269