1 2 3 Weekly Sales 4 Social Security Rate 5 Federal Tax Rate 6 7 8 9 on23415 16 17 18 19 10 11 Rick Linda Stan Elaine Burton Don Tridas Paul == A Employee Laurie Ray Sunder Baohong 20 Michael 21 Payroll Totals 22 $ Ready B Directions 25,000 8.2% 29% Hours Worked D TZ Edge - Employee Salary Template Original Weekly Sales = $25,000 35 $ 40 $ 35 $ 33 $ 32 S 23 $ 30 S 34 $ 33 $ 28 $ 42 $ 36 $ 50 $ Hourly Wage 31 Questions: 32 Which employee received the largest paycheck (Net Pay)? 33 What is the total number of hours worked for all employees? 34 What is the minimum Net Pay? Book Order 15.00 12.00 10.00 13.00 10.00 11.00 10.00 12.00 12.00 11.00 13.00 12.00 10.00 Accessibility: Investigate Commision 35 What is the average Net Pay? 36 How much did TZ Edge pay in payroll (use the Gross Pay column)? 37 If Weekly Sales drop to $8,000, which employee will receive the largest paycheck? 38 What would the total Net Pay equal if Weekly Sales was $40,000? 39 40 41 6% 8% 5% 1% 0% 3% Charity Donations 10% 0% 5% 0% 6% 3% 3%