Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Assignment Tasks: Review the following situations and for each pay period determine the employee's net pay by calculating what earnings & benefits are subject to

Assignment Tasks:

  1. Review the following situations and for each pay period determine the employee's net pay by calculating what earnings & benefits are subject to Income Tax, Canada / Quebec Pension Plan, Quebec Parental Insurance Plan (if applicable) and Employment insurance.
  2. Ensure to reduce net and taxable income by any applicable voluntary/non statutory deductions as well.
  3. The amounts to be calculated for each employee are:
  • Taxable income:
  • Insurable income:
  • Pensionable income:
  • Federal tax
  • Provincial tax
  • CPP deduction
  • EI deduction
  • Gross earnings:
  • Total Deductions
  • Net Pay
  1. All rates should be based on 2023.
  2. When using the PDOC set the date to January 6, 2023
  3. Show all calculations and clearly label the numbers you present

Employee Information:

  1. Celine works in Nova Scotia and is paid on a semi-monthly basis.She has a claim code of 2 on both her TD1 and TD1NS. She has the following type of earnings, benefits & deductions. She will not max out on CPP or EI this pay and will have full deductions.

  1. Regular $3,500
  2. Overtime $450
  3. Parking - Employer paid Taxable benefit $50
  4. RPP contribution - Employee deduction $250
  5. Union Dues $50

Calculate Celine's pensionable, insurable and taxable amounts. Then calculate CPP & EI deductions and look up the corresponding federal and provincial tax amounts in the tax tables based on her province, pay frequency and claim codes. Once all deductions have been calculated figure out the net pay.

Assignment Grading Rubric (Clearly label these numbers for marks to be awarded)

  1. 10 Points

1 Point Taxable income:

1 Point Insurable income:

1 Point Pensionable income:

1 Point Federal tax

1 Point Provincial tax

1 Point CPP deduction

1 Point EI deduction

1 Point Gross earnings:

1 Total Deductions

1 Point Net Pay

  1. 10 Points

1 Point Taxable income:

1 Point Insurable income:

1 Point Pensionable income:

1 Point Federal tax

1 Point Provincial tax

1 Point CPP deduction

1 Point EI deduction

1 Point Gross earnings:

1 Total Deductions

1 Point Net Pay

Step by Step Solution

There are 3 Steps involved in it

Step: 1

To calculate the net pay for Celine lets go through each step in detail Given her employment information Earnings and Benefits Regular Earnings 3500 O... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting principles and analysis

Authors: Terry d. Warfield, jerry j. weygandt, Donald e. kieso

2nd Edition

471737933, 978-0471737933

More Books

Students also viewed these Accounting questions