Problem 8 – Payroll Register.pdf

Problem 8 – Payroll Register.pdf - Problem 8 Payroll...

This preview shows page 1 - 2 out of 3 pages.

Problem 8 – Payroll Register (PAYROLL) Learning Objectives Prepare and use a payroll register for a sole proprietorship firm that contains both social security and payroll withholdings. Use =IF and =ROUND functions to compute the Social Security tax, Medicare tax, and union dues formulas. Record journal entries for payroll related transactions. Identify behavior patterns among various payroll taxes. Answer What If Scenarios. Adjust the template to include a new employee. Create a Chart showing the percentage of an employee’s gross pay that is withheld for taxes and other deductions, including the amount taken home as net pay. Problem Data The Critter Crates Company has five employees and they are paid on the last day of each month. Payroll data for October of this year is as follows: Employee Gross Pay for October Federal Income Cumulative Pay at Union Tax Withheld 9/30/XX Member Amber Adilla $5,200 $785.00 $??? (See #1 below) Yes Bobby Bonilla 4,300 731.00 38,700 No Candice Chameleon 1,250 112.50 6,750 No Donna Donilla 12,000 1,875.00 119,000 No Freddy Falcon 10,000 1,560.00 110,000 Yes Other Information regarding payroll rates are as follows: a. Social Security taxes are 6.2% of monthly gross pay up to a cumulative total pay of $118,500. Both employer and employees must pay this for each employee up to the maximum given. b. Medicare taxes are 1.45% on monthly gross pay with no upper limit. c. A $50 monthly deduction is made for union dues for all union members. d. Unemployment taxes are paid on monthly gross pay up to the first $7,000 earned by each employee each year. State and local rates are 5.4% and .8% respectively.
Image of page 1

Subscribe to view the full document.

Image of page 2
  • Spring '18
  • Maureen Baker
  • gross pay

{[ snackBarMessage ]}

Get FREE access by uploading your study materials

Upload your study materials now and get free access to over 25 million documents.

Upload now for FREE access Or pay now for instant access
Christopher Reinemann
"Before using Course Hero my grade was at 78%. By the end of the semester my grade was at 90%. I could not have done it without all the class material I found."
— Christopher R., University of Rhode Island '15, Course Hero Intern

Ask a question for free

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern