Set A 7A-1. MyA a. Calculate the total wages earned for each hourly employee assuming an overtime rate of time and a half over 40 hours. Employee Paula Anderson Olivia Turner Hourly Rate $10 No. of Hours Worked 37 13 41 Kellen Gates 18 45 b. Calculate the total biweekly earnings of these newly hired salaried employees. John Smith Monthly Salary $4,000 $5,000 Jane Doe File Home Page Layout Formulas Data Review View Help Arial 10 ALA 23 Wiap le Pand B AA lill Mergea Center Clipboard Font Alignment 319 X B D E G 1 A EXERCISEYA 1 2 Namne 3 Section Date 6 a Hourly Rate No. Hours Worked Regular Wages Overtime Wages Total Wages Employee Paula Anderson 8 9 Olma Tumer 10 11 Kellen Gates 12 135 Employee 15 John Smith 16 Jane Doe 17 18 Biweekly Earnings 20 21 Type here to search