Part C Case Study In this case study you will be required to calculate the gross to net pay for three employees. You will also be required to calculate other employer costs based on the information provided. This case study will demonstrate that you know how to use what you have learned in this course. Majic Corporation sells phone cases to public and private companies. They are located at 123 Locus Rd, Toronto, ON M1H 453. They employ 200 full time employees who work in sales, customer service and office support roles. They have had an annual remuneration of over $1,000,000 for the past several years therefore their EHT rate is 1.95%. Pay period #1 started December 27, 2020. All are paid on a bi-weekly basis. All benefits are processed each pay on an as enjoyed basis. The first pay day for employees is Jan 13, 2021. They have three staff in the Customer Service Department answering questions from clients and the general public. They all work Monday to Friday and do not work statutory holidays but are paid for them. mphoses is van 18,2 A) Marijke has been with Majic for 5 years and is the Customer Service Supervisor. She ears $2000.00 bi-weekly working 35 hours per week. She does not work any overtime. She received a $300.00 one-time bonus pay period 6 Her employer provides her with the following: Health and Dental - fully paid for by the employer at a monthly cost of $469.00 Group Term life insurance - 2x her annual salary at a cost of $0.69 per month per $1000 of coverage paid for by the employer AD&D - $50,000.00 at a cost of $0.19 per month per $1000 of coverage paid for by the employer I She has the following personal deductions from her pay: $5.00 per pay donation to the United Way Federal and Provincial income tax - she is claiming maximum tax (Claim Code 0) plus an additional $10.00 per pay Pay Period 6 Answer Gross Pay Gross taxable income CPP contributions El premiums Federal and Provincial taxes Group term life insurance AD&D United Way Net pay Employer health tax Total Marks Mark 11 71 11 /1 11 11 71 11 /1 /1 710 Pay Period 7 B Group term life insurance AD & D United Way Net pay Employer health tax Total Marks 71 71 71 /1 71 11 710 Pay Period 7 Answer Gross Pay Gross taxable income CPP contributions El premiums Federal and Provincial taxes Group term life insurance AD & D United Way Net pay Employer health tax Total Marks Mark 11 11 71 11 11 11 /1 71 /1 11 /10 B) Neema has been with Majic for 3 years and answers calls specifically from clients She earns $18.25 per hour and works 35 hours per week. She also does not work any overtime. She is paid bi-weekly. Her employer provides the following: Health and Dental - at a total cost of $469.00 per month, 50% is paid by the employer and 50% is paid for by Neema Group Term life - $50,000.00 at a cost of $0.45 per month per $1000 of coverage paid for by the employer She does not receive AD&D She has the following deductions: Federal and Provincial taxes - she is claiming basic tax (Claim code 1) plus an additional $5.00 perpay Calculate the following for Neema: Pay Period 6 Answer Gross Pay Gross taxable income CPP contributions El premiums Federal and Provincial taxes Health and Dental Cost Group term life insurance Net pay Employer health tax Total Marks Mark 71 71 /1 71 /1 71 71 71 11 19 Pay Period 7 Answer Gross Pay Gross taxable income CPP contributions El premiums Federal and Provincial taxes Health and Dental Cost Group term life insurance Net pay Employer health tax Total Marks Mark /1 /1 /1 71 71 11 11 /1 19 C) Roger started with Majic this year. His first day was January 6, 2021. He was hired on a temporary basis to cover an employee who was off on maternity leave. He earns $16.50 per hour. He is covered under the Employment Standards Act of Ontario. He works 7 hours per day 5 days per week and receives 4% vacation pay on each pay cheque. He does not C) Roger started with Majic this year. His first day was January 6, 2021. He was hired on a temporary basis to cover an employee who was off on maternity leave. He earns $16.50 per hour. He is covered under the Employment Standards Actof Ontario. He works 7 hours per day 5 days per week and receives 4% vacation pay on each pay cheque. He does not receive any benefits nor does he work overtime. He has taken one unpaid day off March 30th. He receives 7 hours of statutory holiday pay for any statutory holidays and does not work those days. He too is paid bi-weekly He has the following deductions: Federal and Provincial taxes - he is claiming basic tax (Claim code 1) He has found a full-time job and his last day to work will be May 13, 2021 Pay Period 6 Answer Gross Pay Gross taxable income CPP contributions El premiums Federal and Provincial taxes Net pay Employer health tax Total Marks Mark /1 11 /1 11 /1 /1 71 17 I Pay Period 7 Answer Gross Pay Gross taxable income CPP contributions El premiums -1 p i-1 Mark /1 71 /1 71 14 Pay Period 7 Answer Gross Pay Gross taxable income CPP contributions El premiums Federal and Provincial taxes Net pay Employer health tax Total Marks Mark /1 /1 /1 11 11 11 71 17 : D) Now that you have calculated the net pays for each of these employees, calculate the totals for all three employees for following: Pay Period 6 Answer Mark Total Gross earnings for all 3 employees Total Taxable income for all 3 employees 1 Total employee portions for CPP Total employer portions for CPP Total employee portions for El Total employer portions for El Total Federal and Provincial taxes Total employee portion of health benefits Total employer portion of health benefits Total for United Way Total life insurance Total AD&D Total EHT 16.5 Total Marks m7 Total Marks 76.5 Pay Period 7 Mark Answer Total Gross earnings for all 3 employees Total Taxable income for all 3 employees I Total employee portions for CPP Total employer portions for CPP Total employee portions for El Total employer portions for El Total Federal and Provincial taxes Total employee portion of health benefits Total employer portion of health benefits Total for United Way Total Life insurance Total AD&D Total EHT Total Marks 16.5 Part C Case Study In this case study you will be required to calculate the gross to net pay for three employees. You will also be required to calculate other employer costs based on the information provided. This case study will demonstrate that you know how to use what you have learned in this course. Majic Corporation sells phone cases to public and private companies. They are located at 123 Locus Rd, Toronto, ON M1H 453. They employ 200 full time employees who work in sales, customer service and office support roles. They have had an annual remuneration of over $1,000,000 for the past several years therefore their EHT rate is 1.95%. Pay period #1 started December 27, 2020. All are paid on a bi-weekly basis. All benefits are processed each pay on an as enjoyed basis. The first pay day for employees is Jan 13, 2021. They have three staff in the Customer Service Department answering questions from clients and the general public. They all work Monday to Friday and do not work statutory holidays but are paid for them. mphoses is van 18,2 A) Marijke has been with Majic for 5 years and is the Customer Service Supervisor. She ears $2000.00 bi-weekly working 35 hours per week. She does not work any overtime. She received a $300.00 one-time bonus pay period 6 Her employer provides her with the following: Health and Dental - fully paid for by the employer at a monthly cost of $469.00 Group Term life insurance - 2x her annual salary at a cost of $0.69 per month per $1000 of coverage paid for by the employer AD&D - $50,000.00 at a cost of $0.19 per month per $1000 of coverage paid for by the employer I She has the following personal deductions from her pay: $5.00 per pay donation to the United Way Federal and Provincial income tax - she is claiming maximum tax (Claim Code 0) plus an additional $10.00 per pay Pay Period 6 Answer Gross Pay Gross taxable income CPP contributions El premiums Federal and Provincial taxes Group term life insurance AD&D United Way Net pay Employer health tax Total Marks Mark 11 71 11 /1 11 11 71 11 /1 /1 710 Pay Period 7 B Group term life insurance AD & D United Way Net pay Employer health tax Total Marks 71 71 71 /1 71 11 710 Pay Period 7 Answer Gross Pay Gross taxable income CPP contributions El premiums Federal and Provincial taxes Group term life insurance AD & D United Way Net pay Employer health tax Total Marks Mark 11 11 71 11 11 11 /1 71 /1 11 /10 B) Neema has been with Majic for 3 years and answers calls specifically from clients She earns $18.25 per hour and works 35 hours per week. She also does not work any overtime. She is paid bi-weekly. Her employer provides the following: Health and Dental - at a total cost of $469.00 per month, 50% is paid by the employer and 50% is paid for by Neema Group Term life - $50,000.00 at a cost of $0.45 per month per $1000 of coverage paid for by the employer She does not receive AD&D She has the following deductions: Federal and Provincial taxes - she is claiming basic tax (Claim code 1) plus an additional $5.00 perpay Calculate the following for Neema: Pay Period 6 Answer Gross Pay Gross taxable income CPP contributions El premiums Federal and Provincial taxes Health and Dental Cost Group term life insurance Net pay Employer health tax Total Marks Mark 71 71 /1 71 /1 71 71 71 11 19 Pay Period 7 Answer Gross Pay Gross taxable income CPP contributions El premiums Federal and Provincial taxes Health and Dental Cost Group term life insurance Net pay Employer health tax Total Marks Mark /1 /1 /1 71 71 11 11 /1 19 C) Roger started with Majic this year. His first day was January 6, 2021. He was hired on a temporary basis to cover an employee who was off on maternity leave. He earns $16.50 per hour. He is covered under the Employment Standards Act of Ontario. He works 7 hours per day 5 days per week and receives 4% vacation pay on each pay cheque. He does not C) Roger started with Majic this year. His first day was January 6, 2021. He was hired on a temporary basis to cover an employee who was off on maternity leave. He earns $16.50 per hour. He is covered under the Employment Standards Actof Ontario. He works 7 hours per day 5 days per week and receives 4% vacation pay on each pay cheque. He does not receive any benefits nor does he work overtime. He has taken one unpaid day off March 30th. He receives 7 hours of statutory holiday pay for any statutory holidays and does not work those days. He too is paid bi-weekly He has the following deductions: Federal and Provincial taxes - he is claiming basic tax (Claim code 1) He has found a full-time job and his last day to work will be May 13, 2021 Pay Period 6 Answer Gross Pay Gross taxable income CPP contributions El premiums Federal and Provincial taxes Net pay Employer health tax Total Marks Mark /1 11 /1 11 /1 /1 71 17 I Pay Period 7 Answer Gross Pay Gross taxable income CPP contributions El premiums -1 p i-1 Mark /1 71 /1 71 14 Pay Period 7 Answer Gross Pay Gross taxable income CPP contributions El premiums Federal and Provincial taxes Net pay Employer health tax Total Marks Mark /1 /1 /1 11 11 11 71 17 : D) Now that you have calculated the net pays for each of these employees, calculate the totals for all three employees for following: Pay Period 6 Answer Mark Total Gross earnings for all 3 employees Total Taxable income for all 3 employees 1 Total employee portions for CPP Total employer portions for CPP Total employee portions for El Total employer portions for El Total Federal and Provincial taxes Total employee portion of health benefits Total employer portion of health benefits Total for United Way Total life insurance Total AD&D Total EHT 16.5 Total Marks m7 Total Marks 76.5 Pay Period 7 Mark Answer Total Gross earnings for all 3 employees Total Taxable income for all 3 employees I Total employee portions for CPP Total employer portions for CPP Total employee portions for El Total employer portions for El Total Federal and Provincial taxes Total employee portion of health benefits Total employer portion of health benefits Total for United Way Total Life insurance Total AD&D Total EHT Total Marks 16.5