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 22, 2019. All are paid on a bi-weekly basis. The first pay day for these employees is Friday Jan 10, 2020. They have three staff in the Customer Service Department answering questions from clients and the general public. A) Marijke has been with Majic for 5 years and is the Customer Service Supervisor. She earns $2000.00 bi-weekly working 35 hours per week. Her employer provides 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 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 3 Answer Gross Pay Gross taxable income CPP contributions El premiums Federal and Provincial taxes Group term life insurance AD & D United Way Mark /1 /1 /1 /1 /1 /1 /1 11 71 71 /10 Net pay Employer health tax Total Marks Pay Period 4 Answer Gross Pay Gross taxable income CPP contributions El premiums Federal and Provincial taxes Group term life insurance AD & D United Way Mark 11 11 /1 /1 /1 11 /1 71 /1 71 110 Net pay Employer health tax Total Marks 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. 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 per pay Calculate the following for Neema: Pay Period 3 Answer Gross Pay Gross taxable income CPP contributions El premiums Federal and Provincial taxes Health and Dental Cost Group term life insurance Mark /1 /1 /1 71 /1 /1 /1 71 71 19 Net pay Employer health tax Total Marks Pay Period 4 Answer Gross Pay Gross taxable income CPP contributions El premiums Federal and Provincial taxes Health and Dental Cost Group term life insurance Mark /1 /1 /1 71 /1 /1 /1 /1 /1 19 Net pay Employer health tax Total Marks Roger started with Majic this year. His first day was January 6, 2020. 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 receive any benefits. He has not taken any days off. 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 June 26, 2020 11 Pay Period 3 Answer Gross Pay Gross taxable income CPP contributions El premiums Federal and Provincial taxes Net pay Employer health tax Total Marks Mark /1 /1 11 /1 11 /1 71 17 Pay Period 4 Answer Gross Pay Gross taxable income CPP contributions El premiums Federal and Provincial taxes Mark /1 /1 /1 11 /1 /1 /1 Net pay Employer health tax D) Now that you have calculated the net pays for each of these employees, calculate the totals for all three for following: Pay Period 3 Answer Total Gross earnings for all 3 employees 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 EHT Total Marks Mark /1 /1 /1 /1 /1 /1 71 /1 71 71 /10 Pay Period 4 Answer Total Gross earnings for all 3 employees 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 Mark 71 /1 /1 /1 /1 /1 71 Total employee portion of Health benefits Total employer portion of Health benefits Total for United Way Total EHT Total Marks 71 /1 71 110 E) Journal Entries for Pay Period 3 and 4 Using the grid below complete the journal entry for the month of February using the amounts you calculated in Section D. Account Wage Expense Debit Credit Mark /1 CPP Expense /1 CPP Payable /1 El Expense /1 El Payable /1 Fed & Prov tax payable 71 /1 Health expense Health payable /1 United Way payable /1 Net Pay /1 Total /1 Total Marks /11 F) As previously mentioned Roger has decided to leave Majic. His last day worked will be June 26th He will require a Record of Employment. Complete the boxes below with the correct amounts that should be included in each of the sections. Amount Box Box 10 Mark /1 Box 11 /1 Box 12 /1 Box 14 /1 Box 15 A /1 Box 15 B /1 Box 16 /1 Box 22 /1 Total Marks 18 G) Year End In this question you will need to complete the boxes for a T4 for Marijke using some of the following information. Enter your answers in the grid provided below the copy of the T4. This would be her 2019 T4. 1. Gross earnings = $50700.00 2. Her taxable benefit for Group term life insurance was $81.50 3. Her taxable benefit for AD&D was $16.25 4. Her employer paid Health and Dental was $440.00 5. Her total Federal and Provincial Taxes were $8825.33 6. Her donations to a charity were $104.00 7. You will need to calculate her CPP and El deductions using 2019 rates. The 2019 rate for CPP is 5.1% and El is 1.62%. T Employer's name - Nom de l'employeur 1.1 Canada Revenue aparece du reveru T4 Agency Year Statement of Remuneration Paid Anne tat de la rmunration paye Employment income-line 101 Income tax deducted line 437 Revenus emploi-lore 101 Imot sur le revenue 437 14 22 54 Employer's contuber / Numero de compte de l'employeur Province of employment Employee's CPP contributions - line 300 Province d'emploi Costos de employd RPC - Igre101 10 16 El insure camings Gains surables CAE 24 Sociale Number Numero assurance sociale Exempt - Eremption CPP OPP EI PPP CPPIOPP perignation RPERRO 12 23HH Employment code cool demploi 29 Employee's OPP congbutions in 300 Cotisations de employer BRRO-ligne 300 17 Gains avant dros 26 RPC/RRO AE RPAP Employee's premine 12 Cotisations de remploye STAE-le 12 18 Union desine 212 Cotisations syndicales ligne 212 Employee's name and address - Nom et adresse de l'employ rah - Nomem Pane-Prenom 44 RPP contribution line 207 Cotisations PA-line 207 Charitable donations Dons de bienfaisance 340 ligne udun SILAUN a Bacau MALM NADAL 20 46 Pension mentine 206 Fachu devalence-fire 200 RPP DPSP registration number Nagriment un PA ou un RPDB 50 52 Employee's PPP premium Over Cotations de femove RPAP-Vorvento 55 PPP insurable aming Gains assurables du RPAP 56 Box Case Amount-Montant Box Case Amount - Mont Box Case Amount - Montant Other information (see over Box Case Amount-Montant Borcane Amount - Montant Bor-Case Amount - Montant AL Autres renseignements (voir au verso) Answer Mark /1 71 /1 /1 /1 Description Company Year Box 10 Province of Employment Box 14 Employment Income Box 16 Employee's CPP contributions Box 18 Employee's El premiums Box 22 Income Tax deducted Box 24 El insurable earnings Box 26 CPP/QPP pensionable earnings Box 46 Charitable Donations Other Information Code 40 Other Taxable Allowances and Benefits Total Marks /1 71 /1 /1 /1 /1 /11 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 22, 2019. All are paid on a bi-weekly basis. The first pay day for these employees is Friday Jan 10, 2020. They have three staff in the Customer Service Department answering questions from clients and the general public. A) Marijke has been with Majic for 5 years and is the Customer Service Supervisor. She earns $2000.00 bi-weekly working 35 hours per week. Her employer provides 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 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 3 Answer Gross Pay Gross taxable income CPP contributions El premiums Federal and Provincial taxes Group term life insurance AD & D United Way Mark /1 /1 /1 /1 /1 /1 /1 11 71 71 /10 Net pay Employer health tax Total Marks Pay Period 4 Answer Gross Pay Gross taxable income CPP contributions El premiums Federal and Provincial taxes Group term life insurance AD & D United Way Mark 11 11 /1 /1 /1 11 /1 71 /1 71 110 Net pay Employer health tax Total Marks 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. 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 per pay Calculate the following for Neema: Pay Period 3 Answer Gross Pay Gross taxable income CPP contributions El premiums Federal and Provincial taxes Health and Dental Cost Group term life insurance Mark /1 /1 /1 71 /1 /1 /1 71 71 19 Net pay Employer health tax Total Marks Pay Period 4 Answer Gross Pay Gross taxable income CPP contributions El premiums Federal and Provincial taxes Health and Dental Cost Group term life insurance Mark /1 /1 /1 71 /1 /1 /1 /1 /1 19 Net pay Employer health tax Total Marks Roger started with Majic this year. His first day was January 6, 2020. 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 receive any benefits. He has not taken any days off. 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 June 26, 2020 11 Pay Period 3 Answer Gross Pay Gross taxable income CPP contributions El premiums Federal and Provincial taxes Net pay Employer health tax Total Marks Mark /1 /1 11 /1 11 /1 71 17 Pay Period 4 Answer Gross Pay Gross taxable income CPP contributions El premiums Federal and Provincial taxes Mark /1 /1 /1 11 /1 /1 /1 Net pay Employer health tax D) Now that you have calculated the net pays for each of these employees, calculate the totals for all three for following: Pay Period 3 Answer Total Gross earnings for all 3 employees 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 EHT Total Marks Mark /1 /1 /1 /1 /1 /1 71 /1 71 71 /10 Pay Period 4 Answer Total Gross earnings for all 3 employees 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 Mark 71 /1 /1 /1 /1 /1 71 Total employee portion of Health benefits Total employer portion of Health benefits Total for United Way Total EHT Total Marks 71 /1 71 110 E) Journal Entries for Pay Period 3 and 4 Using the grid below complete the journal entry for the month of February using the amounts you calculated in Section D. Account Wage Expense Debit Credit Mark /1 CPP Expense /1 CPP Payable /1 El Expense /1 El Payable /1 Fed & Prov tax payable 71 /1 Health expense Health payable /1 United Way payable /1 Net Pay /1 Total /1 Total Marks /11 F) As previously mentioned Roger has decided to leave Majic. His last day worked will be June 26th He will require a Record of Employment. Complete the boxes below with the correct amounts that should be included in each of the sections. Amount Box Box 10 Mark /1 Box 11 /1 Box 12 /1 Box 14 /1 Box 15 A /1 Box 15 B /1 Box 16 /1 Box 22 /1 Total Marks 18 G) Year End In this question you will need to complete the boxes for a T4 for Marijke using some of the following information. Enter your answers in the grid provided below the copy of the T4. This would be her 2019 T4. 1. Gross earnings = $50700.00 2. Her taxable benefit for Group term life insurance was $81.50 3. Her taxable benefit for AD&D was $16.25 4. Her employer paid Health and Dental was $440.00 5. Her total Federal and Provincial Taxes were $8825.33 6. Her donations to a charity were $104.00 7. You will need to calculate her CPP and El deductions using 2019 rates. The 2019 rate for CPP is 5.1% and El is 1.62%. T Employer's name - Nom de l'employeur 1.1 Canada Revenue aparece du reveru T4 Agency Year Statement of Remuneration Paid Anne tat de la rmunration paye Employment income-line 101 Income tax deducted line 437 Revenus emploi-lore 101 Imot sur le revenue 437 14 22 54 Employer's contuber / Numero de compte de l'employeur Province of employment Employee's CPP contributions - line 300 Province d'emploi Costos de employd RPC - Igre101 10 16 El insure camings Gains surables CAE 24 Sociale Number Numero assurance sociale Exempt - Eremption CPP OPP EI PPP CPPIOPP perignation RPERRO 12 23HH Employment code cool demploi 29 Employee's OPP congbutions in 300 Cotisations de employer BRRO-ligne 300 17 Gains avant dros 26 RPC/RRO AE RPAP Employee's premine 12 Cotisations de remploye STAE-le 12 18 Union desine 212 Cotisations syndicales ligne 212 Employee's name and address - Nom et adresse de l'employ rah - Nomem Pane-Prenom 44 RPP contribution line 207 Cotisations PA-line 207 Charitable donations Dons de bienfaisance 340 ligne udun SILAUN a Bacau MALM NADAL 20 46 Pension mentine 206 Fachu devalence-fire 200 RPP DPSP registration number Nagriment un PA ou un RPDB 50 52 Employee's PPP premium Over Cotations de femove RPAP-Vorvento 55 PPP insurable aming Gains assurables du RPAP 56 Box Case Amount-Montant Box Case Amount - Mont Box Case Amount - Montant Other information (see over Box Case Amount-Montant Borcane Amount - Montant Bor-Case Amount - Montant AL Autres renseignements (voir au verso) Answer Mark /1 71 /1 /1 /1 Description Company Year Box 10 Province of Employment Box 14 Employment Income Box 16 Employee's CPP contributions Box 18 Employee's El premiums Box 22 Income Tax deducted Box 24 El insurable earnings Box 26 CPP/QPP pensionable earnings Box 46 Charitable Donations Other Information Code 40 Other Taxable Allowances and Benefits Total Marks /1 71 /1 /1 /1 /1 /11