Assignment II Payroll Administration Payroll Register and Journal For the following employer, prepare an appropriate register, journal entries and create a ledger for payroll using an Excel spreadsheet Suncor Office Supply has two salaried and three hourly employees in Toronto, as follows: TD1 TD1 Pay Basis Hour Departm Monthly Fed ON Rate s ent Life Insuran ce* Anita 1 1 $110,0 Annua Manager 56.00 00 1 Basil 2. 1 $5,500 Month Office 38.00 ly Manis 3 2. $25.00 Hour 35 Office 18.50 ha Carol 4 2 $17.00 Hour 44 Sales Nil Debbi 5 5 $35.00 Hour 40 Sales 20.50 1 1 e * Includes Ontario tax Basil is also paid an automobile allowance of $100 per month. We have received a garnishment order for Manisha requiring a withholding equal to 20% of "net" pay. The payroll is processed for all employees on a weekly basis and this payroll is for the week ending March 31st, 2019. There will be 52 regular pays in the year. Suncor Office Supply pays overtime at the minimum Ontario standard. The employer pays 4% vacation to hourly employees with each pay and accrues 6% for salaried employees. The employer is estimates current year W.S.I.B. premiums at $3.18 per $100 of assessable earnings. Apply present EHT for Ontario. Hourly paid employees are members of a Union with dues per week of $25. All employees contribute $7.00 per pay to the "United Way" through payroll deduction. All employees are between the ages of 20 and 65. The calculation of statutory deductions should be done by using the CRA online tables. Assignment II Payroll Administration Payroll Register and Journal For the following employer, prepare an appropriate register, journal entries and create a ledger for payroll using an Excel spreadsheet Suncor Office Supply has two salaried and three hourly employees in Toronto, as follows: TD1 TD1 Pay Basis Hour Departm Monthly Fed ON Rate s ent Life Insuran ce* Anita 1 1 $110,0 Annua Manager 56.00 00 1 Basil 2. 1 $5,500 Month Office 38.00 ly Manis 3 2. $25.00 Hour 35 Office 18.50 ha Carol 4 2 $17.00 Hour 44 Sales Nil Debbi 5 5 $35.00 Hour 40 Sales 20.50 1 1 e * Includes Ontario tax Basil is also paid an automobile allowance of $100 per month. We have received a garnishment order for Manisha requiring a withholding equal to 20% of "net" pay. The payroll is processed for all employees on a weekly basis and this payroll is for the week ending March 31st, 2019. There will be 52 regular pays in the year. Suncor Office Supply pays overtime at the minimum Ontario standard. The employer pays 4% vacation to hourly employees with each pay and accrues 6% for salaried employees. The employer is estimates current year W.S.I.B. premiums at $3.18 per $100 of assessable earnings. Apply present EHT for Ontario. Hourly paid employees are members of a Union with dues per week of $25. All employees contribute $7.00 per pay to the "United Way" through payroll deduction. All employees are between the ages of 20 and 65. The calculation of statutory deductions should be done by using the CRA online tables