Question
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
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: $ 190,000 CPP annual maximum pensionable earnings reached on May 31 El annual maximum pensionable earnings reached on May 31 Mariya Lopez, Analyst: Base Salary: $ 75,000 CPP and El annual maximum pensionable earnings not yet reached Gracyn Stiller, Analyst: Base Salary: $ 80,000 CPP and El annual maximum pensionable earnings not yet reached Jun Wang, Analyst: Base Salary: $ 82,000 CPP annual maximum pensionable earnings reached on August 31 El annual maximum pensionable earnings reached on August 31 Jerry Hopper, Administrative Assistant: Base Salary: $ 54,000 CPP and El annual maximum pensionable earnings not yet reached. Employees are paid on the 16th and the last day of the month (28, 29,30,31) as the case may be. This pay is calculated based on the most recent semi-monthly period. E.g., for the semi-monthly period of September 1-15, employees will be paid on September 16 Today is September 13. You will be running the first payrollfor this department in two days. Prior to that, you would like to perform certain payroll and fringe benefit related calculations to use for cross- checking when the main payrollis run. Towards that end, perform the following calculations: Required: All the calculations below pertain to the pay period of September 1-15. Round all calculations to the nearest dollar. Show all your calculations and do not compare with online calculators. You will receive partial marks to the extent they have been calculated correctly. One: (25 marks) Calculate gross pay, Federal Taxes and Provincial (Ontario) taxes that would be deducted from the gross pay of each employee for the semi-monthly period of September 1- 15 APPENDIX ONE Federal Income Tax rates: Tax Rate Taxable Annual Income 15% 20.5% 26% 29% 33% $49,020, and $49,021 up to $98,040, and $98,041 up to $151,978 and $151,979 up to $216,511 and $216,512 and up Ontario Tax rates: Tax Rate 5.05% 9.15% 11.16% 12.16% 13.16% Taxable Annual Income First $45,142 and $45,143 up to $90,287 and $90,288 up to $150,000, and $150,001 up to $220,000, and $220,001 and up
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