PAYROLL Using the data provided, complete the payroll calculations table. Download the deductions table from Accounting Supplemental
Question:
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 |
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill