Problem AI$-1$A Payroll register and payroll deductions LO$2,3$

The payroll records of Brownlee Company provided the following information for the weekly pay period ended March $23,2021$

Required:

Enter the relevant information in the proper columns of a payroll register and complete the register, calculate CPP and EI 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.$)$

Payroll Week Ended March $23,2021$

$\backslash$table$[[$Payroll Register$],[,$Employee,,,,,,,,Total,O$.$T$.,$Reg.,Hospital,Union,$\backslash$table$[[$Earnings$],[$to End of$]],$Earnings,$],[,$Daily Time,,O$.$T$.,,],[$Employees$,$No$.,$M$,$T$,$w$,$T$,$F$,$s$,$s$,$Hours,Hours,Pay Rate,Insurance,Dues,$\backslash$table$[[$Previous$],[$Week$]],\backslash$table$[[$Regular$],[$Pay$]],\backslash$table$[[$Premium$],[$Pay$]],$Gross Pay,$],[$Ray Loran,$11,8,8,8,8,8,4,0,,,40\mathrm{.}00,4000,1600,43,000,,,,1],[$Kathy Sousa,$12,7,8,6,7,8,4,0,,,36\mathrm{.}00,4000,1500,46,000,,,,2],[$Gary Smith,$13,8,8,0,8,8,4,4,,,3200,4000,14\mathrm{.}00,21,000,,,,3],[$Nicole Parton,$14,8,8,8,8,8,0,0,,,4000,4000,1600,32,000,,,,4],[$Diana Wood,$15,0,6,6,6,6,8,8,,,3600,4000,16\mathrm{.}00,36,000,,,,5],[,,,,,,,,,,,,20000,7700,,,,,6]]$