Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
Payroll and Government Reporting ASSIGNMENT -1 15% IN THE FINAL DUE ON FEB 14th: 2021 BEFORE 11.59 PM Spieth Company employees had the following earnings
Payroll and Government Reporting ASSIGNMENT -1 15% IN THE FINAL DUE ON FEB 14th: 2021 BEFORE 11.59 PM Spieth Company employees had the following earnings records at the close of the November 30, Monthly payroll period. Name o the Employee Weekly hours Hourly Rate Scott Quageber Flint Okonkwo Linea Spieth Company's payroll taxes expense for each employee include: 5.25% CPP on the annual pensionable earnings. ( with the first $3,500 exempt), and 1.4 times the employees El rate of 1.58%. As well, 15% federal and 5.05% provincial income taxes will be deducted from the employees' gross pay. Calculate the following for each worker. 1. Determine the amount of Gross Earnings 80 70 65 85 90 16.50 18.50 20.00 22.50 25.00 2. Determine the amount of Pensionable Earnings 3. Determine the amount of contributory Earnings 4. Determine the amount of insurable Earnings 5. Determine the amount of Taxable Earnings 6. Determine Employee CPP deduction 7. Determine Employee EI deduction 8. Determine Federal tax deduction 9 Determine Provincial tax deduction 10. Determine Total tax Deductions 11. Total employee deductions 12. Employer CPP contribution 13. Employer El contribution 14. Employer total Benefit expense 15. Employer payroll liability 16. Net Pay Payroll and Government Reporting ASSIGNMENT -1 15% IN THE FINAL DUE ON FEB 14th: 2021 BEFORE 11.59 PM Spieth Company employees had the following earnings records at the close of the November 30, Monthly payroll period. Name o the Employee Weekly hours Hourly Rate Scott Quageber Flint Okonkwo Linea Spieth Company's payroll taxes expense for each employee include: 5.25% CPP on the annual pensionable earnings. ( with the first $3,500 exempt), and 1.4 times the employees El rate of 1.58%. As well, 15% federal and 5.05% provincial income taxes will be deducted from the employees' gross pay. Calculate the following for each worker. 1. Determine the amount of Gross Earnings 80 70 65 85 90 16.50 18.50 20.00 22.50 25.00 2. Determine the amount of Pensionable Earnings 3. Determine the amount of contributory Earnings 4. Determine the amount of insurable Earnings 5. Determine the amount of Taxable Earnings 6. Determine Employee CPP deduction 7. Determine Employee EI deduction 8. Determine Federal tax deduction 9 Determine Provincial tax deduction 10. Determine Total tax Deductions 11. Total employee deductions 12. Employer CPP contribution 13. Employer El contribution 14. Employer total Benefit expense 15. Employer payroll liability 16. Net Pay
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started