Description Unit outcomes addressed in this unit: Use Functions and Formulas to determine data outcomes. Course outcome(s) practiced in this unit: GEL-2.3: Solve real-world problems using mathematical skills. Scenario: 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