You have been hired to do the payroll for a small software development start-up company in...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 but you simply need to let them know the amounts to pay. Employee 1 - Sakura Tanaka (Sales and Marketing) Paid semi-monthly Has a company owned automobile 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: Saa naurall tah 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. Name of 1st employee Employee #1 Sakura Tanaka Automobile taxable benefit Semi-monthly Pay Date Beginning (Jun 30) 15-Jul-21 31-Jul-21 Name of 2nd employee Employee #2 Susan Campbell Bi-weekly Pay Date Gross Pay Gross Pay Address of first employee 1 City Street, Ottawa ON K4P OV3 $236.40 per pay Federal Tax Provincial Tax Address of second employee 9 Princess Lane, Ottawa ON K7P 9J3 Federal Tax Provincial Tax CPP CPP Social Insurance Number 440 963 935 ΕΙ Net Pay Social Insurance Number 234 567 899 ΕΙ Net Pay Year-to-date amounts Pensionable CPP Insurable ΕΙ Earnings Max Earnings Max Max $61600 $3,166.45 Max $56300 $889.54 $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 Year-to-date amounts Pensionable CPP Earnings Max Max $61600 $3,166.45 Insurable Earnings Max $56300 ΕΙ Max $889.54 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 Name of 2nd employee Employee #2 Susan Campbell Bi-weekly Pay Date Beginning (Jun 30) 9-Jul-21 23-Jul-21 Name of 3rd employee Employee #3 Jeremy Karr Monthly Pay Date Gross Pay Gross Pay Address of second employee 9 Princess Lane, Ottawa ON K7P 9J3 Federal Tax Provincial Tax Address of third employee 1 King Street, Ottawa ON K4C 1V0 Federal Tax Provincial Tax CPP CPP Social Insurance Number 234 567 899 ΕΙ Net Pay Social Insurance Number 445 111 222 ΕΙ Net Pay Year-to-date amounts Pensionable CPP Insurable EI Earnings Max Earnings Max Max $61600 $3,166.45 Max $56300 $889.54 $39,000.00 $2,030.08 $39,000.00 $616.20 $2,030.08 $39,000.00 $616.20 $39,000.00 $39,000.00 $2,030.08 $39,000.00 Year-to-date amounts Pensionable CPP Earnings Max Max $61600 $3,166.45 $616.20 Insurable ΕΙ Earnings Max Max $56300 $889.54 Bi-weekly Pay Date Beginning (Jun 30) 9-Jul-21 23-Jul-21 Name of 3rd employee Employee #3 Jeremy Karr Monthly Pay Date Beginning (Jun 30) 31-Jul-21 Gross Pay Gross Pay Federal Tax Provincial Tax Address of third employee 1 King Street, Ottawa ON K4C 1V0 Federal Tax Provincial Tax CPP CPP EI Net Pay Social Insurance Number 445 111 222 EI Net Pay Pensionable CPP Earnings Max Max $61600 $3,166.45 Insurable EI Earnings Max Max $56300 $889.54 $39,000.00 $2,030.08 $39,000.00 $616.20 $39,000.00 $2,030.08' $2,030.08 $39,000.00 $39,000.00 $616.20 $39,000.00 $2,030.08 $39,000.00 $616.20 Year-to-date amounts Pensionable CPP Insurable Earnings Max Earnings Max $61600 $3,166.45 Max $56300 $54,000.00 $2,847.63 $54,000.00 $54,000.00 $2,847.63 $54,000.00 EI Max $889.54 $853.20 $853.20 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 but you simply need to let them know the amounts to pay. Employee 1 - Sakura Tanaka (Sales and Marketing) Paid semi-monthly Has a company owned automobile 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: Saa naurall tah 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. Name of 1st employee Employee #1 Sakura Tanaka Automobile taxable benefit Semi-monthly Pay Date Beginning (Jun 30) 15-Jul-21 31-Jul-21 Name of 2nd employee Employee #2 Susan Campbell Bi-weekly Pay Date Gross Pay Gross Pay Address of first employee 1 City Street, Ottawa ON K4P OV3 $236.40 per pay Federal Tax Provincial Tax Address of second employee 9 Princess Lane, Ottawa ON K7P 9J3 Federal Tax Provincial Tax CPP CPP Social Insurance Number 440 963 935 ΕΙ Net Pay Social Insurance Number 234 567 899 ΕΙ Net Pay Year-to-date amounts Pensionable CPP Insurable ΕΙ Earnings Max Earnings Max Max $61600 $3,166.45 Max $56300 $889.54 $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 Year-to-date amounts Pensionable CPP Earnings Max Max $61600 $3,166.45 Insurable Earnings Max $56300 ΕΙ Max $889.54 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 Name of 2nd employee Employee #2 Susan Campbell Bi-weekly Pay Date Beginning (Jun 30) 9-Jul-21 23-Jul-21 Name of 3rd employee Employee #3 Jeremy Karr Monthly Pay Date Gross Pay Gross Pay Address of second employee 9 Princess Lane, Ottawa ON K7P 9J3 Federal Tax Provincial Tax Address of third employee 1 King Street, Ottawa ON K4C 1V0 Federal Tax Provincial Tax CPP CPP Social Insurance Number 234 567 899 ΕΙ Net Pay Social Insurance Number 445 111 222 ΕΙ Net Pay Year-to-date amounts Pensionable CPP Insurable EI Earnings Max Earnings Max Max $61600 $3,166.45 Max $56300 $889.54 $39,000.00 $2,030.08 $39,000.00 $616.20 $2,030.08 $39,000.00 $616.20 $39,000.00 $39,000.00 $2,030.08 $39,000.00 Year-to-date amounts Pensionable CPP Earnings Max Max $61600 $3,166.45 $616.20 Insurable ΕΙ Earnings Max Max $56300 $889.54 Bi-weekly Pay Date Beginning (Jun 30) 9-Jul-21 23-Jul-21 Name of 3rd employee Employee #3 Jeremy Karr Monthly Pay Date Beginning (Jun 30) 31-Jul-21 Gross Pay Gross Pay Federal Tax Provincial Tax Address of third employee 1 King Street, Ottawa ON K4C 1V0 Federal Tax Provincial Tax CPP CPP EI Net Pay Social Insurance Number 445 111 222 EI Net Pay Pensionable CPP Earnings Max Max $61600 $3,166.45 Insurable EI Earnings Max Max $56300 $889.54 $39,000.00 $2,030.08 $39,000.00 $616.20 $39,000.00 $2,030.08' $2,030.08 $39,000.00 $39,000.00 $616.20 $39,000.00 $2,030.08 $39,000.00 $616.20 Year-to-date amounts Pensionable CPP Insurable Earnings Max Earnings Max $61600 $3,166.45 Max $56300 $54,000.00 $2,847.63 $54,000.00 $54,000.00 $2,847.63 $54,000.00 EI Max $889.54 $853.20 $853.20
Expert Answer:
Answer rating: 100% (QA)
Employee Pay period type Gross pay CPP EI Federal tax Provincial tax Net pay Sakura Tanaka Semimonthly 390000 6162 2550 53838 33740 293610 Susan Campb... View the full answer
Related Book For
Accounting Information Systems
ISBN: 978-0133428537
13th edition
Authors: Marshall B. Romney, Paul J. Steinbart
Posted Date:
Students also viewed these accounting questions
-
You have been hired to examine Brahe Corporations financial statements for the year ending December 31, 2016. Brahe was organized in January 2016 by Moses and Price, the original owners of options to...
-
You have been hired to develop group support software. Describe the features you would include in your new GSS software.
-
You have been hired as an operations research consultant by a company to reevaluate the inventory policy for one of its products. The company currently uses the basic EOQ model. Under this model, the...
-
kindly interpret the R squared In order to test its job candidates' technical skills, a company creates a timed Excel test (in minutes) to be completed during the interview. The company asks its...
-
Develop a brief answer to each of the following questions: 1. How arc expenses and withdrawals similar, and how are they different? 2. In what ways are CVS and Southwest Airlines comparable? Not...
-
Consider the linear calibration curve, which is derived from the 14 corrected absorbances in the shaded region at the right side of. Create a least-squares spreadsheet like Figure 4 - 15 to compute...
-
Which of the following statements is false? a. Transactions are frequently analyzed using a T-account. b. All T-accounts have both a debit and a credit side. c. The left side of a T-account is called...
-
Consider the following note payable transactions of Caldwell Video Productions. 2016 Apr. 1 Purchased equipment costing $56,000 by issuing a seven-year, 13% note payable. The note requires annual...
-
Preparing and Adjusting Profit Equation Assume Strands Salon, a San Diego hair salon, provides haircuts for $ 6 0 . Annual fixed costs are $ 5 7 6 , 0 0 0 and the company estimates $ 1 5 . 3 0 in...
-
Ryan is 26 years old and weighs 213 pounds. He works a full-time construction job during the day and squeezes in online classes at the community college in the evenings. He recently started working...
-
(a) The production function is given as F(x, y) = 10xy where x and y are the amount of inputs. Confirm if this function is Homogeneous Function. If it is, what is the degree? In order to double the...
-
Find the function f(x) described by the given initial value problem. f(x) = f(x)=0, f'(-3)=2, f(-3)=5
-
Cloudy Company manufactures pipes and applies manufacturing overhead costs to production at a budgeted overhead rate of $21 per direct labour hour. The following data are obtained from the accounting...
-
Relationship marketing, as defined by Cuofano (2023), revolves around businesses and their brands establishing lasting connections with customers. The primary objective of relationship marketing is...
-
Proctor Cleaning Products manufactures a product using a process that allows for substitution between two materials, X-1 and Y-7. The company has the following direct materials data for its product:...
-
If a venture has $100,000 of net sales and EBIT of $35,000, what would be its NOPAT Margin, given that it has a 25% corporate tax rate
-
Based on the textbook, there are 3 Types of Dismissals from an Organization, Institution or Company. Which of the following is NOT one of the 3 Types of Dismissals? a. Furloughs b. Firings c. Downsizi
-
This problem continues the Draper Consulting, Inc., situation from Problem 12-45 of Chapter 12. In October, Draper has the following transactions related to its common shares: Oct 1 Draper...
-
Stans Southern Barbeque Supply Store orders mass-produced barbecue products from various suppliers. Stans maintains information about a contact person at each supplier along with all required address...
-
Wright Companys information system was developed in stages over the past five years. During the design process, department heads specified the information and reports they needed. By the time...
-
The Mesa Veterinary Hospital is run by Dr. Brigitte Roosevelt. She has two employees in the office and has asked you to develop a database to help better track her data. Dr. Roosevelt currently uses...
-
Andrea Lima is attempting to sell her business to Alfonso Moreno. The company has assets of $1,800,000, liabilities of $1,600,000, and stockholders equity of $200,000. Both parties agree that the...
-
When faced with lawsuits, many companies recognize a loss and therefore credit a liability or reserve account for any future losses that may result. For instance, in the famous WorldCom case,...
-
Rothberg Corporations management took the following actions, which went into effect on January 2, 20x7. Each action involved an application of the time value of money. a. Established a new retirement...
Study smarter with the SolutionInn App