Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the attached template, you are to compute the gross pay, federal withholding, Social Security withholding, Medicare withholding and the net payment for this company.Assume

Using the attached template, you are to compute the gross pay, federal withholding, Social Security withholding, Medicare withholding and the net payment for this company.Assume there is no state income tax.Overtime is paid at a rate of 1.5 times the normal wage rate.

In addition,creategross pay, federal withholding, Social Security withholding, Medicare withholding and net payment for all the employees.

Further,createindicating the total gross pay, Social Security withholding, Medicare withholding and net pay for wage employees and for salary employees.

image text in transcribed Employee Numbers Pay Rate 1 $ 44.00 2 $ 56.00 3 $ 35.00 4 $ 3,200.00 5 $ 23.00 6 $ 19.00 7 $ 33.00 8 $ 3,100.00 9 $ 2,400.00 10 $ 32.00 11 $ 23.00 12 $ 37.00 13 $ 2,450.00 14 $ 41.00 15 $ 23.00 16 $ 36.00 17 $ 4,100.00 18 $ 2,100.00 19 $ 40.00 20 $ 27.00 21 $ 31.00 22 $ 2,200.00 23 $ 26.00 24 $ 18.00 25 $ 31.00 26 $ 2,900.00 27 $ 2,850.00 28 $ 30.00 29 $ 41.00 30 $ 36.00 31 $ 2,560.00 32 $ 22.00 33 $ 42.00 34 $ 31.00 35 $ 1,800.00 36 $ 1,900.00 37 $ 35.00 38 $ 53.00 39 $ 32.00 40 $ 3,600.00 41 $ 25.00 Regular Hours Overtime Worked Hours Worked Gross Pay 40 6 40 40 9 1 40 2 1 40 9 1 1 40 6 40 40 9 1 40 2 1 40 9 1 1 40 6 40 40 9 1 40 2 1 40 9 1 1 40 6 40 40 9 1 40 2 1 40 9 1 1 40 6 40 40 9 1 40 2 Federal W/H Rate Federal W/H 0.25 0.28 0.15 0.25 0.25 0.15 0.28 0.28 0.28 0.25 0.28 0.15 0.25 0.25 0.15 0.28 0.28 0.28 0.25 0.28 0.15 0.25 0.25 0.15 0.28 0.28 0.28 0.25 0.28 0.15 0.25 0.25 0.15 0.28 0.28 0.28 0.25 0.28 0.15 0.25 0.25 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 68 69 70 71 72 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 19.00 29.00 5,000.00 1,900.00 22.00 31.00 52.00 1,900.00 22.00 18.00 28.00 3,300.00 2,100.00 37.00 52.00 19.00 4,200.00 15.00 21.00 35.00 3,500.00 2,200.00 38.00 51.00 41.00 1,875.00 27.00 33.00 27.00 3,700.00 2,600.00 1 40 1 1 40 40 40 1 40 1 40 1 1 40 40 40 1 40 1 40 1 1 40 40 40 1 40 1 40 1 1 9 6 9 2 9 6 9 2 9 6 9 2 9 0.15 0.28 0.28 0.28 0.25 0.28 0.15 0.25 0.25 0.15 0.28 0.28 0.28 0.25 0.28 0.15 0.25 0.25 0.15 0.28 0.28 0.28 0.25 0.28 0.15 0.25 0.25 0.15 0.28 0.28 0.28 Tax Rates 6.20% 1.45% SS W/H Medicare W/H Net Pay Type Wage Wage Wage Salary Wage Wage Wage Salary Salary Wage Wage Wage Salary Wage Wage Wage Salary Salary Wage Wage Wage Salary Wage Wage Wage Salary Salary Wage Wage Wage Salary Wage Wage Wage Salary Salary Wage Wage Wage Salary Wage Wage Wage Salary Salary Wage Wage Wage Salary Wage Wage Wage Salary Salary Wage Wage Wage Salary Wage Wage Wage Salary Salary Wage Wage Wage Salary Wage Wage Wage Salary Salary

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial And Managerial Accounting

Authors: Carl S. Warren, Jefferson P. Jones, William Tayler

16th Edition

0357714040, 9780357714041

More Books

Students also viewed these Accounting questions

Question

work settings of recent graduates;

Answered: 1 week ago