Question
Calculate the EI, CPP , Federal tax, Provincial tax and Net pay for each of the following students. All are bi-weekly pays. Student Gross Pay
Calculate the EI, CPP , Federal tax, Provincial tax and Net pay for each of the following students. All are bi-weekly pays.
Student | Gross Pay | Code | EI | CPP | Fed Tax | Prov Tax | Net |
|
|
|
|
|
|
|
|
Student A |
500.23 |
2 |
|
|
|
|
|
Student B |
1000.49 |
2 |
|
|
|
|
|
Student C |
245.74 |
3 |
|
|
|
|
|
Student D |
1345.85 |
0 |
|
|
|
|
|
Student E |
1234.85 |
1 |
|
|
|
|
|
Student F |
2345.99 |
4 |
|
|
|
|
|
Student G |
654.00 |
2 |
|
|
|
|
|
Student H |
555.23 |
1 |
|
|
|
|
|
Student I |
678.00 |
2 |
|
|
|
|
|
Student J |
333.33 |
2 |
|
|
|
|
|
Student K |
2332.99 |
3 |
|
|
|
|
|
Student L |
765.99 |
1 |
|
|
|
|
|
Calculate the following payroll and demonstrate steps to get to your calculations. The following employees are paid b-weekly and are claim code 2.
Employee #1 ($15.00/hr)
Mon, Tue and Wed 7 am 3 pm , 1 hour lunch un-paid
Thurs and Fri --- 11 am 7 pm , lunch un-paid
Employee #2: ($15.00/hr)
Mon to Fri ---- 7 am -2 pm hour lunch un-paid
Every second Saturday 8 am- 12 noon (no lunch)
Employee#3: ($15.00)hr
Mon, Tues --- 9 am 5 pm 1 hour lunch un paid
Wed 8 am 3 pm hour lunch unpaid
Thur 7 am 4 pm 1 hour lunch un-paid
Fri 10 am 2 pm no lunch
Employee # 4
Makes $35,000 per year, works 40 hours a week
How much does he/she make per hour
Employee #5
Makes $38,000 per year works Mon Fri 7.5 hours a day
How many hours per pay period does he/she work?
How much does he/she get paid per hour?
Employee | EI | CPP | Fed Tax | Prov Tax | Net |
Employee 1 |
|
|
|
|
|
Employee 2 |
|
|
|
|
|
Employee 3 |
|
|
|
|
|
Employee 4 |
|
|
|
|
|
Employee 5 |
|
|
|
|
|
Totals |
|
|
|
|
|
Calculate:
Part A: Employees Contribution
Part B: Employers contribution
Part C: Employers remittance
Employee 1
Employee 4
CPP____________________CPP_____________________
EI____________________EI_______________________
Fed tax_____________________Fed tax___________________
Provincial_____________________Provincial _________________
Employee 2 Employee 5
CPP _____________________CPP____________________
EI ______________________EI ______________________
Fed tax ____________________Fed tax __________________
Provincial____________________Prov tax __________________
CPP _____________________
EI________________________
Fed tax____________________
Provincial__________________
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