You are the payroll manager at Widgets R Us. You need to calculate an employee’s gross and net pay based on the table below

You are the payroll manager at Widgets R Us. You need to calculate an employee’s gross and net pay based on the table below

soffix

  • $12.99


You are the payroll manager at Widgets R Us. You need to calculate an employee’s gross and net pay based on the table below

You are the payroll manager at Widgets R UsYou need to calculate an employee’s gross and net paybased on the table belowSandy worked overtime this past week and would like to know what her grossand net pay will beYour job is to calculate this using the following data.NoteThe company policy isthat she is entitled to time and a half for any hours worked over 40.Using Excelcalculate Sandy’s grosspay and net payYou must use a function or formula.

Pay Rate: $10.00/Hour

Federal Tax Rate: 20%

Hours Worked: 50

State Tax Rate: 10%

FICA 5%

Sandy’s Gross Pay

Sandy’s Net Pay


We Also Recommend


Sale

Unavailable

Sold Out