You are the payroll manager at Widget R Us. You

You are the payroll manager at Widget 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 workrd over 40.

Using Excel calculate Sandy’s Gross Pay and Net Pay. You must use a function or formula.

1. Calculate Sandy’s Gross pay by using Function or formulas.

2. Calculate Sandy’s Net Pay by using function and Formulas