Please include calculations and proper 2023 rates and please add federal and provincial tax calculations

Assignment Tasks:

1. Review the following situations and determine the employees net pay by figuring out 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. All rates should be based on 2023.
4. When using the PDOC set the date to January 6, 2023
5. Show all calculations and clearly label the numbers you present

Employee Information:

1. Lawrence works in Alberta and is paid on a bi-weekly basis. He has a claim code of 1 on both his TD1 and TD1AB. He has the following type of earnings, benefits & deductions. He will not max out on CPP or EI this pay and will have full deductions.

1. Regular $2,500
2. Vacation Pay $500
3. Group Life Employer paid Taxable benefit $25
4. RRSP contribution Employee deduction $300
5. Coffee Fund $5

Calculate Lawrences 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 his province, pay frequency and claim codes. Once all deductions have been calculated figure out the net pay.

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 Celines 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.