CELL REFERENCE PLS

K L M N O P O R S 4 5 B D E F G H I J Below is the bi-weekly payroll for all employees at Auger Company for Jun 22, 2021 Employees normally work 80 hours per pay period. The employer retains 6% vacation for all employees. The employer would like to keep track of salary expenses by department (Field and Office) The employer follows the Employment Standards Act of Ontario. 6 7 8 9 10 11 12 Distribution Field Office Salaries Salaries 1140.00 1424.00 13 14 Earnings Deductions Clock Total 0.1. Reg Pay Regular OT Prem Gross | EI Income Hospital Total Net Cheque Card # Hours Hours Rate Pay Pay Pay Premiums Premiums Taxes Insurance Deductions Pay Number Dept. 1250 80 14.25 1140.00 1140.00 54.79 18.01 117.47 25.00 215.27 924.73 122 Field 1487 86 6 16.00 1376.00 48.00 1424.00 70.27 22.50 172.77 25.00 290.54 1133.46 123 Field 1006 88 8 22.00 1936.00 88.00 2024.00 102.97 31.98 313.20 40.00 488.15 1535.85 124 Office 1101 84 41 18.00 1512.00 36.00 1548.00 77.03 24.46 199.28 40.00 340.77 1207.23 125 Field 1089 80 20.00 1600.00 1600.00 79.86 25.28 208.99 40.00 354.13 1245.87 126 Office 1322 80 18.00 1440.00 1440.00 71.14 22.75 176.71 25.00 295.60 1144.40 127 Office 9,004.00 172.00 9,176.00 456.06 144.98 1,188.42 195.00 1,984.46 7.191.54 15 Employee Auger, John Boar, Tina Drill, Tim Spin, Melissa Turnner, Joe Twisty, Sue Totals 2024.00 16 1548.00 17 18 1600.00 1440.00 4,112.00 5,064.00 19 20 21 1 Prepare the necessary journal entry to record the bi-weekly payroll to employees assuming it is not paid until tomorrow The employer would like you to split the salaries expense between the two departments. Do not leave any blank spaces between account names/amounts. 22 23 A B C D E F G H 1 K M N O P Q R S 20 21 22 1 Prepare the necessary journal entry to record the bi-weekly payroll to employees assuming it is not paid until tomorrow The employer would like you to split the salaries expense between the two departments. Do not leave any blank spaces between account names/amounts. 23 24 Date Account Name Debit Credit 3.5 marks 25 26 Jun 22 27 28 29 30 31 32 33 34 2 Prepare the necessary journal entry to pay the employees on June 23 1 mark 35 36 Jun 23 37 38 A E 1 L M N o P R S 39 B C D F G H 3 Prepare the journal entry on Jun 22 to accrue the employer payroll costs. Assume the employer pays the same as the employee for hospital insurance, WSIB rate is $3.62 and 6% vacation. Company is EHT exempt. 40 41 5 marks 42 43 Jun 22 44 45 46 47 48 49 50 51 52 53 54 4 On Jul 15, record the journal entry to pay the remittance that would need to be made to CRA only. 55 56 Jul 15 2.5 marks 57 58 59 K L M N O P O R S 4 5 B D E F G H I J Below is the bi-weekly payroll for all employees at Auger Company for Jun 22, 2021 Employees normally work 80 hours per pay period. The employer retains 6% vacation for all employees. The employer would like to keep track of salary expenses by department (Field and Office) The employer follows the Employment Standards Act of Ontario. 6 7 8 9 10 11 12 Distribution Field Office Salaries Salaries 1140.00 1424.00 13 14 Earnings Deductions Clock Total 0.1. Reg Pay Regular OT Prem Gross | EI Income Hospital Total Net Cheque Card # Hours Hours Rate Pay Pay Pay Premiums Premiums Taxes Insurance Deductions Pay Number Dept. 1250 80 14.25 1140.00 1140.00 54.79 18.01 117.47 25.00 215.27 924.73 122 Field 1487 86 6 16.00 1376.00 48.00 1424.00 70.27 22.50 172.77 25.00 290.54 1133.46 123 Field 1006 88 8 22.00 1936.00 88.00 2024.00 102.97 31.98 313.20 40.00 488.15 1535.85 124 Office 1101 84 41 18.00 1512.00 36.00 1548.00 77.03 24.46 199.28 40.00 340.77 1207.23 125 Field 1089 80 20.00 1600.00 1600.00 79.86 25.28 208.99 40.00 354.13 1245.87 126 Office 1322 80 18.00 1440.00 1440.00 71.14 22.75 176.71 25.00 295.60 1144.40 127 Office 9,004.00 172.00 9,176.00 456.06 144.98 1,188.42 195.00 1,984.46 7.191.54 15 Employee Auger, John Boar, Tina Drill, Tim Spin, Melissa Turnner, Joe Twisty, Sue Totals 2024.00 16 1548.00 17 18 1600.00 1440.00 4,112.00 5,064.00 19 20 21 1 Prepare the necessary journal entry to record the bi-weekly payroll to employees assuming it is not paid until tomorrow The employer would like you to split the salaries expense between the two departments. Do not leave any blank spaces between account names/amounts. 22 23 A B C D E F G H 1 K M N O P Q R S 20 21 22 1 Prepare the necessary journal entry to record the bi-weekly payroll to employees assuming it is not paid until tomorrow The employer would like you to split the salaries expense between the two departments. Do not leave any blank spaces between account names/amounts. 23 24 Date Account Name Debit Credit 3.5 marks 25 26 Jun 22 27 28 29 30 31 32 33 34 2 Prepare the necessary journal entry to pay the employees on June 23 1 mark 35 36 Jun 23 37 38 A E 1 L M N o P R S 39 B C D F G H 3 Prepare the journal entry on Jun 22 to accrue the employer payroll costs. Assume the employer pays the same as the employee for hospital insurance, WSIB rate is $3.62 and 6% vacation. Company is EHT exempt. 40 41 5 marks 42 43 Jun 22 44 45 46 47 48 49 50 51 52 53 54 4 On Jul 15, record the journal entry to pay the remittance that would need to be made to CRA only. 55 56 Jul 15 2.5 marks 57 58 59