CELL REFERENCE PLS

Below is a partially completed weekly payroll register for Tart and Pie Company located in Ontario. Employees normally work a 40 hour week and are paid overtime at time and a half for hours worked over 44 per week. All overtime at the time and a half rate are recorded in the overtime column. Employees are only paid for time worked. There are no allowances or taxable benefits. All employees contribute to RRSP but the employer does not pay any amounts towards this. The employer retains 4% vacation. Using the information given, the text and government websites (use PDOC), complete the pay register. Assume basic amounts for purposes of taxes. Do not add any rows or columns to the payroll register. TART AND PIE COMPANY Payroll Register Week ended Mar 31 Gross Earnings Total Employee Hours Net Hourly Rate Deductions Income Tax Gross Pay Regular Overtime CPP RRSP Total Pay Data 52 pays per year 44 hours then OT 1.5 Overtime rate 5.45% CPP Rate $3,500 CPP exemption 1.58% El Rate 4% Vacation $14.25 Minimum wage $ 20.00 46 75.00 B. Butters C. Cherry C. Crust Totals $ 25.00 $ 258.59 30.00 20.00 $ 75.00 $ 801.41 8 marks 9 marks 19 11 marks 4 marks 48 14.22 How much vacation has been accrued by the employer for this pay period? 2 marks Below is a partially completed weekly payroll register for Tart and Pie Company located in Ontario. Employees normally work a 40 hour week and are paid overtime at time and a half for hours worked over 44 per week. All overtime at the time and a half rate are recorded in the overtime column. Employees are only paid for time worked. There are no allowances or taxable benefits. All employees contribute to RRSP but the employer does not pay any amounts towards this. The employer retains 4% vacation. Using the information given, the text and government websites (use PDOC), complete the pay register. Assume basic amounts for purposes of taxes. Do not add any rows or columns to the payroll register. TART AND PIE COMPANY Payroll Register Week ended Mar 31 Gross Earnings Total Employee Hours Net Hourly Rate Deductions Income Tax Gross Pay Regular Overtime CPP RRSP Total Pay Data 52 pays per year 44 hours then OT 1.5 Overtime rate 5.45% CPP Rate $3,500 CPP exemption 1.58% El Rate 4% Vacation $14.25 Minimum wage $ 20.00 46 75.00 B. Butters C. Cherry C. Crust Totals $ 25.00 $ 258.59 30.00 20.00 $ 75.00 $ 801.41 8 marks 9 marks 19 11 marks 4 marks 48 14.22 How much vacation has been accrued by the employer for this pay period? 2 marks