case study

case study

HUMR-1007 Payroll and Taxable Benefits
Case Study 2 using 2022 Rates as found in learn
in tab labelled 2022 forms
Total Marks /63
For the following employee:
1. Complete a current year Federal and Provincial TD1 form for the employee. And
use these totals to identify the claim code for Federal and Provincial tax.
(6 Marks)
Note: Include these as additional attachments in the LEARN Dropbox (either
image file or document file). Fillable forms are available on the CRA website.
2. Calculate the net payable, using the format below, for the last three bi-weekly pay
periods (note: each pay period covers a Sunday – Saturday period with the last
period in covering August 21st – September 3rd, showing all the appropriate subcalculations of gross pays and deductions.
(39 Marks)
3. Linda Buckley has accepted an offer of employment with one of Diverse’s
competitors. Linda’s last day at Diverse was August 26th. Linda has not taken any
vacation. Prepare a Record of Employment for the employee. Hint: Use a calendar
to help calculate all the required pay periods gross earnings and hours.
(18 Marks)
Note: Include this as additional attachment in the LEARN Dropbox (either
image file or document file). Fillable forms are available in the Case Study 2
content section in LEARN.
Information:
Province of employment:
Employer:
Employer RCT No.:
Employee Name:
Position:
Birth Date:
SIN:
Pay method:
Pay frequency:
Number of hours worked per pay period
Pay rate:
Start Date:
Termination Date:
Last pay period ending date:
Manitoba
Diverse Enterprises Inc.
123 Street.
Winnipeg, Manitoba, R2R 2R2
102 345 678 RP0001
Linda Buckley
420 Ash St
Wpg, MB R3R 1C1
Technician
August 21, 1992
627-673-327
Salary
Bi-weekly
80/8 hours per day
$42,000 annually
March 14, 2022
August 26, 2022
September 3, 2022
Miscellaneous deductions:
Extended Health Benefits
Dental premium
Registered Co. Pension Plan
$10.00 per pay
$14.00 per pay
1.6% of gross pay per pay
Additional information:
•
Monthly downtown parking fees of $63.00 (includes GST) are paid by the
employer and a prorated taxable benefit is included on each pay.
•
Diverse Enterprises was closed for the Civic Holiday in August and all salaried
employees were paid for their regular hours/pay for the day.
•
Employees at Diverse work a Monday to Friday work week.
•
Linda Buckley is married and is supporting her husband who currently has no
income. Linda claims her spouse on both her TD1 forms.
•
Linda’s final pay included her vacation pay and regular pay.
_______________________________________________________________
Question 1:
Include TD1 forms as additional attachments in the LEARN Dropbox.
Question 2:
Period covered:
July 24 to August 6
Regular hours
hours____ X _______ = ______________
Total Gross Pay
___________________________________
Tax Ben _______
___________________________________
Gross Taxable
___________________________________
_______________
___________________________________
Net Taxable
___________________________________
CPP
___________________________________
EI
_______________________________________
FED TAX
(CC____)
___________________________________
PROV TAX
(CC____)
___________________________________
________________
___________________________________
________________
___________________________________
________________
___________________________________
Net Pay
___________________________________
Period covered:
August 7 to August 20
Regular hours
hours____ X _______ = ______________
Total Gross Pay
___________________________________
Tax Ben _______
___________________________________
Gross Taxable
___________________________________
_______________
___________________________________
Net Taxable
___________________________________
CPP
___________________________________
EI
_______________________________________
FED TAX
(CC____)
___________________________________
PROV TAX
(CC____)
___________________________________
________________
___________________________________
________________
___________________________________
________________
___________________________________
Net Pay
___________________________________
Period covered:
August 21 to September 3
Regular hours
hours____ X _______ = ______________
Vacation Pay
______________________________
Total Gross Pay
___________________________________
Tax Ben _______
___________________________________
Gross Taxable
___________________________________
_______________
___________________________________
Net Taxable
___________________________________
CPP
___________________________________
EI
_______________________________________
FED TAX
(CC____)
___________________________________
PROV TAX
(CC____)
___________________________________
________________
___________________________________
________________
___________________________________
________________
___________________________________
Net Pay
___________________________________
Question 3:
Use the provided fillable ROE form (located in the Case Study content section in
LEARN), and include these as additional attachments in the LEARN Dropbox.