PAYROLL Using the data provided, complete the payroll calculations table. Download the deductions table from Accounting Supplemental Material Page. Submit your reconciliation in Accounting Competency  Note: Any hours over 44 per week is paid as overtime at a rate of 1.5 times the hourly rate. 1. Jim Brown is paid weekly at $21.15 per hour. He worked 37 hours this week. His federal tax code is 1 and his provincial tax code is 2. 2. George Bell is paid weekly at $27.80 per hour. He worked 43.5 hours this week; he usually works 40 hours per week. His federal tax code is 2 and his provincial tax code is 3. 3. Linda Gray is paid weekly at $28.70 per hour. She worked 36.5 hours this week. Her federal tax code is 2 and her provincial tax code is 1. 4. John Smith is paid weekly at $19.20 per hour. He worked 37.5 hours this week. His federal tax code is 3 and his provincial tax code is 1. 5. Sarah Lee is paid weekly at $20.50 per hour. She worked 40 hours this week plus .5 hours overtime. Her federal tax code is 1 and her provincial tax code is 2.

Use the format below: ( Canadian TAX)

TAX CODE

NAME

PAY RATE

FED

PROV

REG HOURS

O/T HRS

REG EARN

O/T EARN

GROSS EARN

FED TAX

PROV TAX

CPP

EIP

NET PAY