Can someone do this test ?

profileHugoDelvalle
Payroll_Student_Test_Ver2.xlsx
Home>Business & Finance homework help>Management homework help>Can someone do this test ?

Week 1

Tax Rate 7%
Week 1 Payroll Totals Bonus
Employee PayRate HRSWK Bonus GrossPay Taxes Net Hours Amount
A3121 14.15 56.00 40 100
B4325 12.75 62.50 45 200
H9891 21.95 38.75 50 300
K7198 13.6 42.50 55 400
Total $ - 0 $ - 0 $ - 0 $ - 0 60 500

Week 2

Tax Rate 7%
Week 2 Payroll Totals Bonus
Employee PayRate HRSWK Bonus GrossPay Taxes Net Hours Amount
A3121 14.15 34.75 40 100
B4325 12.75 45.10 45 200
H9891 21.95 40.00 50 300
K7198 13.6 37.85 55 400
Total $ - 0 $ - 0 $ - 0 $ - 0 60 500

Week 3

Tax Rate 7%
Week 3 Payroll Totals Bonus
Employee PayRate HRSWK Bonus GrossPay Taxes Net Hours Amount
A3121 14.15 40.00 40 100
B4325 12.75 48.50 45 200
H9891 21.95 23.75 50 300
K7198 13.6 39.50 55 400
Total $ - 0 $ - 0 $ - 0 $ - 0 60 500

Week 4

Tax Rate 7%
Week 4 Payroll Totals Bonus
Employee PayRate HRSWK Bonus GrossPay Taxes Net Hours Amount
A3121 14.15 52.00 40 100
B4325 12.75 32.50 45 200
H9891 21.95 40.00 50 300
K7198 13.6 62.50 55 400
Total $ - 0 $ - 0 $ - 0 $ - 0 60 500

MonTotals

Tax Rate 7%
Monthly Totals Bonus
Employee PayRate HRSWK Bonus GrossPay Taxes Net Hours Amount
A3121 14.15 40 100
B4325 12.75 45 200
H9891 21.95 50 300
K7198 13.6 55 400
Total $ - 0 $ - 0 $ - 0 $ - 0 60 500