How do you compute the gross pay, federal withholding, Social Security withholding, Medicare withholding and the net payment, plus assuming there are no state income tax.Overtime is paid at a rate of 1.5 times the normal wage rate. for this company that I attached the spreadsheet.

In addition,how do you compute the totalgross pay, federal withholding, Social Security withholding, Medicare withholding and net payment for all the employees.How do youproduct a pivot tableindicating the total gross pay, Social Security withholding, Medicare withholding and net pay for wage employees and for salary employees.

Employee Numbers Regular Hours Overtime Pay Rate Worked Hours Worked Gross Pay 1 $ 44.00 40 6 2 $ 56.00 40 3 $ 35.00 40 9 4 $ 3,200.00 1 5 $ 23.00 40 2 6 $ 19.00 1 7 $ 33.00 40 9 8 $ 3,100.00 1 9 $ 2,400.00 1 10 $ 32.00 40 6 11 $ 23.00 40 12 $ 37.00 40 9 13 $ 2,450.00 1 14 $ 41.00 40 2 15 $ 23.00 1 16 $ 36.00 40 9 17 $ 4,100.00 1 18 $ 2,100.00 1 19 $ 40.00 40 6 20 $ 27.00 40 21 $ 31.00 40 9 22 $ 2,200.00 1 23 $ 26.00 40 2 24 $ 18.00 1 25 $ 31.00 40 9 26 $ 2,900.00 1 27 $ 2,850.00 1 28 $ 30.00 40 6 29 $ 41.00 40 30 $ 36.00 40 9 31 $ 2,560.00 1 32 $ 22.00 40 2 33 $ 42.00 1 34 $ 31.00 40 9 35 $ 1,800.00 1 36 $ 1,900.00 1 37 $ 35.00 40 6 38 $ 53.00 40 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 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 68 69 70 71 72 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 32.00 3,600.00 25.00 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 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 40 40 40 1 40 1 40 1 1 9 2 9 6 9 2 9 6 9 2 9 6 9 2 9 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 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