Calculating YTD amounts is NOT required.

The payroll records of Brownlee Company (a Nova Scotia company) provided the following information for the weekly pay period ended March 23, 2023: Overtime for hourly paid employees is calculated on hours more than 40 per week and is calculated at a rate of 1.5 regular rate of pay. Salaried employees are not paid overtime. Vacation pay is retained by the employer until the employee takes time off. All employees contribute 10% of their gross regular pay (no overtime and no vacation pay) to their RRSP. Ray Loran has use of a company owned (and paid for) cell phone as a value of $230 per month. Kathy, Gary, Nicole and Diana are part of the Group Life Insurance Plan - Brownlee Company pays the premiums. The premiums are 2% of the employees gross regular pay (no overtime and no vacation pay). All employees have the basic claim code for federal and provincial income tax. Brownlee's WCB rate is 2.78% and the maximum insurable earnings is $62,800 per year. Required (Prepare the solution in Excel) 1. Using CRA's Online Payroll Deduction Calculator, create and complete a payroll register for the pay period ending March 23, 2023. At minimum, you should have a column for each of the steps (\#2-13) on page 6163 of your textbook