70.2K

Verified Solution

Link Copied!

1. Review the background, facts and general information on the data tab.

2. Using information from the Data tab, calculate the pay cycle gross earnings for each of the 3 employees. Enter your answers in the gross pay column on the payroll tab. Round answers to 2 decimal places

3. Using the Payroll Deduction On-line Calculator (not the tables), calculate the statutory deductions for each employee for each pay. Enter your answers in the appropriate columns on the payroll tab.

4. Using a formula, calculate the net pay for each employee. Enter your answers in the net pay column on the payroll tab.

5. Answer the questions found on the Questions tab of this workbook by entering your answers into the appropriate boxes.

Background: You have been hired to do the payroll for a small software development start-up company in Kanata, Ontario with 3 employees. This is one of several clients you have. The payroll must be done on certain days of the month (pay days) but you can process the payroll at any time during the day on these pay days. You have the choice of processing the payroll from home or going into the office to process the payroll. You and the company have agreed to be paid $80 per month to process the payroll for the month (for all pay cycle types). The company will pay the remittances Facts: Employee 1 - Sakura Tanaka (Sales and Marketing) Paid semi-monthly Has a company owned automobile Works 40 hours per week Employer retains vacation No vacation taken during July Employee 2 - Susan Campbell (Software/Hardware Developer) Paid bi-weekly Works 40 hours per week Employer retains vacation No vacation taken during July Has been paid 13 times until the end of June Has $20 extra deducted for federal income tax per pay. Employee 3 - Jeremy Karr (Manager) Paid monthly Works 40 hours per week Employer retains vacation No vacation taken during July General information: See payroll tab. Year-to-date amounts for CPP pensionable earnings, CPP, El insurable earnings and El are up to June 30 (Beginning numbers). All employees started working for the company in 2020. No employees have been or will be paid for overtime or any other additional payments other than their regular salary. All employees claim the basic personal amount for tax purposes. The only deductions off employees pay are statutory deductions. All current employees are between the ages of 20 - 60. M M N O Q R s T U V W CPP rate 5.45% Exemption $3,500.00 Max Pension $61,600 El rate 1.58% Max Insurable $56,300 Social Insurance Number Year-to-date amounts Pensionable CPP Insurable EI Earnings Max Earnings Max Max $61600 $3,166.45 Max $56300 $889.54 Net Pay $51,436.80 $2,707.92 $48,600.00 $767.88 $51,673.20 $2,707.92 $48,600.00 $767.88 $51,909.60 $2,707.92 $48,600.00 $767.88 Social Insurance Number 234 567 899 B DE F G H I J G H K L L 1 Payroll Register 30 Marks 2 Month of July 2021 3 4 Name of Company Business Number 5 TJI Incorporated 1234 56789 RP 0001 6 7 Name of 1st employee Address of first employee 8 Employee #1 Sakura Tanaka 1 City Street, Ottawa ON K4P OV3 9 10 Automobile taxable benefit $236.40 per pay 11 12 Semi-monthly Federal Provincial 13 Pay Date Gross Pay Tax Tax CPP 14 15 Beginning (Jun 30) 16 TO 17 15-Jul-21 18 19 31-Jul-21 20 21 Name of 2nd employee Address of second employee 22 Employee #2 Susan Campbell 9 Princess Lane, Ottawa ON K7P 933 23 24 25 26 Bi-weekly Federal Provincial 27 Pay Date Gross Pay Tax Tax CPP 28 29 Beginning (Jun 30) 30 31 9-Jul-21 32 33 23-Jul-21 34 35 Name of 3rd employee Address of third employee 36 Employee #3 Jeremy Karr 1 King Street, Ottawa ON K4C 1V0 37 38 39 40 Federal Monthly * Provincial 41 Pay Date Gross Pay Tax Tax CPP 7 42 10 43 Beginning (Jun 30) 44 45 31-Jul-21 46 Year-to-date amounts Pensionable CPP Insurable EI Earnings Max Earnings Max Max $61600 $3,166.45 Max $56300 $889.54 EI Net Pay $39,000.00 $2,030.08 $39,000.00 $616.20 $39,000.00 $2,030.08 $39,000.00 $616.20 $39,000.00 $2,030.08 $39,000.00 $616.20 Social Insurance Number 445 111 222 Year-to-date amounts Pensionable CPP Insurable Earnings Max Earnings Max Max $61600 $3,166.45 Max $56300 $889.54 Net Pay $54,000.00 $2,847.63 $54,000.00 $853.20 $54,000.00 $2,847.63 $54,000.00 $853.20 47 B E F H J L M N o P Q R C D 17 Marks 1 Questions 1 Based on the background information on the data tab, would you be considered and employee or sub-contractor when processing payroll for this company? 2 Marks 4 5 6 7 2 Is Sakura Tanaka's SIN correct? 2 Marks Working area 3 What is Susan Campbell's annual salary? 2 Marks Working area 4 How much would Jeremy Karr earn for each overtime hour worked based on a 50% premium over base rate. Overtime Rate 2 Marks Working area 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 5 Enter the employer portion of the total statutory deductions for the month of June 2021. CPP 6 Marks total for this question EI IDIO Federal tax Provincialtan 6 Would Susan Campbell be eligible for holiday pay for Canada Day? 1 Mark 7 You get a garnishment from the Small Claims Court for Jeremy Karr. What is the deduction that you would withhold from his paycheque? 2 Marks Working area

Answer & Explanation Solved by verified expert

See Answer