10 pts D Question 9 What is Miguel's formula for Net Pay? O-(B5*C5)-(B5%C5.28) O -(B5%C5)-(B5*C5.28) =D5-F5 O (B5%C5)-(B5*C5)* 28 10 pts D Question 10 What is Ray's Overtime Pay in dollars? 142.83 $142.83 O $241.25 O $214.25 X X X X X X X X X X X DF use this spreadsheet along with the information in the question to find the correct answer. use these formulas to calculate Gross Pay (Hourly Rate X Hours), Taxes (Gross Pay x tax %), and Net Pay (Gross Pay - Taxes). calculate taxes as 28% of gross pay and consider overtime to be time and a half (e.g., $6.00 an hour would be $9.00 an hour of overtime). D Taxes Net Pay 1 2 Name Ray Marcia Brittany Miguel Totals Hourly Rates Total Hours (regular) Total Hours (Overtime) Gross Pay $12.42 40 11.5 $8.33 23.25 0 $14.33 40 4.25 0 24.75 $9.44 3 5 6 10 pts