10 point payroll

The payroll records of Brownlee Company provided the following information for the weekly pay period ended March 23, 2018: Required: 1. Enter the relevant information in the proper columns of a payroll register and complete the register, calculate CPP and El deductions. Charge the wages of Kathy Sousa to Office Wages Expense and the wages of the remaining employees to Service Wages Expense. Calculate income tax deductions at 20% of gross pay. Employees are paid an overtime premium of 50% for all hours in excess of 40 per week. (Round your intermediate calculations and final answers to 2 decimal places. Leave no cells blank.) Payroll Week Ended March 23, 2018 Payroll Register Earnings Employee Daily Time Total O.T. Reg. Hospital Union O.T. Employees No. Hours Hours Pay Rate Insurance Dues Regular Pay Premium Pay Gross Pay 11 38.00 43.00 1 12 M T W T F S S 8 8 8 8 0 0 0 6 6 6 6 8 8 8 8 8 8 8 4 0 7 8 8 6 8 4 0 Earnings to End of Previous Week 43,300 46,300 22,500 33,500 37,500 Ray Loran Kathy Sousa Gary Smith Nicole Parton 34.00 19.00 19.00 17.00 2 43.00 43.00 13 35.00 3 14 38.00 43.00 4 18.00 17.00 Diana Wood 15 8 8 0 8 8 4 4 39.00 43.00 5 215.00 90.00 Income Union Net Employment Insurance Hospital Insurance Total Deductions Office Service Wages Expense Wages Expense CPP Tax Dues Pay 1 43.00 43.00 19.00 19.00 43.00 17.00 4 43.00 18.00 5 17.00 43.00 215.00 90.00