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. Sandy worked overtime this past week and would like to know what her gross and net pay will be. Your job is to calculate this using the following data.Note: The company policy is that she is entitled to time and a half for any hours worked over 40.Using Excel, calculate Sandy's gross pay and net pay. You 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