Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Background You are the HR Manager of a home improvement and repairs company in Waterloo ( Ontario ) region, Handy Howie's ( HH ) .
Background
You are the HR Manager of a home improvement and repairs company in Waterloo Ontario region, Handy Howie's HH Recently HH completed a hiring campaign and created a new department, 'Special Projects' The headcount of this department is five. It is led by the Director, Special Projects, and includes three analysts and an administrative assistant. Compensation details of all employees in this department areas follows:
Shahid Singh, Director:
Base Salary: $
CPP annual maximum pensionable earnings reached on May
El annual maximum pensionable earnings reached on May
Mariya Lopez, Analyst:
Base Salary: $
CPP and EI annual maximum pensionable earnings not yet reached.
Gracyn Stiller, Analyst:
Base Salary: $
CPP and EI annual maximum pensionable earnings not yet reached.
Jun Wang, Analyst:
Base Salary: $
CPP annual maximum pensionable earnings reached on August
Jerry Hopper, Administrative Assistant:
Base Salary: $
and annual maximum pensionable earnings not yet reached.
Employees are paid on the th and the last day of the month as the case may be This pay is calculated based on the most recent semimonthly period. Eg for the semimonthly period of September employees will be paid on September
Payroll trial calculations: marks
Today is September You will be running the first payroll for this department in two days. Prior that, you would like to perform certain payroll and fringe benefit related calculations to use for cr checking when the main payroll is run.
Towards that end, perform the following calculations:
Required:
All the calculations below pertain to the pay period of September Round all calculations tc nearest dollar. Show all your calculations and do not compare with online calculators. You will partial marks to the extent they have been calculated correctly.
One: marks
Calculate gross pay, Federal Taxes and Provincial Ontario taxes that would be deducted from the pay of each employee for the semimonthly period of September Use information provide Appendix one.
Two: marks
Calculate the amount of CPP and EI that would be deducted from the gross pay of each employee the bimonthly period of September Use information provided in Appendix two and three.
Calculate the employers' contribution of CPP and EI which STI has to pay for each employee. Use information provided in Appendix two and three.
Three: marks
Based on your calculations in required one and two above, calculate the net pay for each employe
Two: marks
Calculate the amount of CPP and EI that would be deducted from the gross pay of each employee for the bimonthly period of September Use information provided in Appendix two and three.
Calculate the employers' contribution of CPP and EI which STI has to pay for each employee. Use information provided in Appendix two and three.
Three: marks
Based on your calculations in required one and two above, calculate the net pay for each employee for the pay period September Use information provided in Appendix three.
Four: marks
Calculate the total payroll cost for the Corporate Services department for the pay period: September Use relevant data from calculations performed earlier in required one three.
Five: marks
In Appendix four you are provided with a list of ten fringe benefit items. If you were an employee in this company which five fringe benefits would be most important for you? Select them and calculate their cost for this pay period. The expenses will be paid for by the company. Alongside each benefit selected, indicate the reason as to why the choice was made.
Deliverables:
You will complete your work on the Excel template and upload the same to eConestoga.
APPENDIX ONE
Federal Income Tax rates:
tableTax Rate,Taxable Annual Income$ and$ up to $ and$ up to $ and$ up to $ and$ and up
tableOntario Tax rates:Tax Rate,Taxable Annual IncomeFirst $ and$ up to $ and
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started