90.2K

Verified Solution

Link Copied!

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

Answer & Explanation Solved by verified expert

See Answer