Homework Help is Here – Start Your Trial Now!
Business
Accounting
Bart Consulting Firm has the following payroll information for the week ended March 20th: Name Earnings at the end of the previous week Sun. Mon. Tues. Wed. Thurs. Fri. Sat. Pay Rate Federal Income Tax Lauren, F 14,400   8 8 8 8 8   30.00 222.52 Baylor, M 12,000     8 8 8 8 8 25.00 178.55 Lims, T 7,200   8 8 8 8 8   15.00 78.00 Tate, C 6,000   8 8 8 8 8   15.00 62.00 Musker, J 4,320     8   8   8 15.00 15.00 Mako, W 3,888   8   8     8 13.50 11.00 Additional Information: Taxable earnings for Social Security are based on the first $132,900. Taxable earnings for Medicare are based on all earnings. Taxable earnings for federal and state unemployment are based on the first $7,000. Employees are paid time-and-a-half for work in excess of 40 hours per week. Round amounts to the nearest penny. What you must do: Complete the attached Payroll Register (Excel Spreadsheet). Use the following information to help: The Social Security tax rate is 6.2 percent. The Medicare tax rate is 1.45 percent. Begin payroll checks with No. 1050.   Employee Name Total Hours EARNINGS DEDUCTIONS PAID Regular Overtime Total Social Medicare Federal Retirement Total Net Ck. Security Tax Income Savings Pay No. Tax   Tax                                                                                                                                                                               How do I solve this problem?

Bart Consulting Firm has the following payroll information for the week ended March 20th: Name Earnings at the end of the previous week Sun. Mon. Tues. Wed. Thurs. Fri. Sat. Pay Rate Federal Income Tax Lauren, F 14,400   8 8 8 8 8   30.00 222.52 Baylor, M 12,000     8 8 8 8 8 25.00 178.55 Lims, T 7,200   8 8 8 8 8   15.00 78.00 Tate, C 6,000   8 8 8 8 8   15.00 62.00 Musker, J 4,320     8   8   8 15.00 15.00 Mako, W 3,888   8   8     8 13.50 11.00 Additional Information: Taxable earnings for Social Security are based on the first $132,900. Taxable earnings for Medicare are based on all earnings. Taxable earnings for federal and state unemployment are based on the first $7,000. Employees are paid time-and-a-half for work in excess of 40 hours per week. Round amounts to the nearest penny. What you must do: Complete the attached Payroll Register (Excel Spreadsheet). Use the following information to help: The Social Security tax rate is 6.2 percent. The Medicare tax rate is 1.45 percent. Begin payroll checks with No. 1050.   Employee Name Total Hours EARNINGS DEDUCTIONS PAID Regular Overtime Total Social Medicare Federal Retirement Total Net Ck. Security Tax Income Savings Pay No. Tax   Tax                                                                                                                                                                               How do I solve this problem?

Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
8th Edition
ISBN:9781305961883
Author:Carl Warren
Publisher:Carl Warren
Chapter8: Liabilities And Stockholders' Equity
Section: Chapter Questions
Problem 8.2.1MBA
See similar textbooks
icon
Related questions
Question

Bart Consulting Firm has the following payroll information for the week ended March 20th:

Name Earnings at the end of the previous week Sun. Mon. Tues. Wed. Thurs. Fri. Sat. Pay Rate Federal Income Tax
Lauren, F 14,400   8 8 8 8 8   30.00 222.52
Baylor, M 12,000     8 8 8 8 8 25.00 178.55
Lims, T 7,200   8 8 8 8 8   15.00 78.00
Tate, C 6,000   8 8 8 8 8   15.00 62.00
Musker, J 4,320     8   8   8 15.00 15.00
Mako, W 3,888   8   8     8 13.50 11.00

Additional Information:

  • Taxable earnings for Social Security are based on the first $132,900.
  • Taxable earnings for Medicare are based on all earnings.
  • Taxable earnings for federal and state unemployment are based on the first $7,000.
  • Employees are paid time-and-a-half for work in excess of 40 hours per week.
  • Round amounts to the nearest penny.

What you must do:

Complete the attached Payroll Register (Excel Spreadsheet). Use the following information to help:

  • The Social Security tax rate is 6.2 percent.
  • The Medicare tax rate is 1.45 percent.
  • Begin payroll checks with No. 1050.

 

Employee Name Total Hours EARNINGS DEDUCTIONS PAID
Regular Overtime Total Social Medicare Federal Retirement Total Net Ck.
Security Tax Income Savings Pay No.
Tax   Tax      
                       
                       
                       
                       
                       
                       
                       

How do I solve this problem?

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Administration and Procedures
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS