X fic Fox Lake Country Club - Employee Salary Template Fox Lake Country Club - Employee Salary Template $ 20,000.00 rity Rate Employee Hours Worked Hourly Wage Gross Pay Federal Soc Sec Pay Tax Tax Net Pay Mary 3 J 7 Roll Total 3 Instructions: 4 Insert a function to calculate Gross Pay (In other words, if an employee receives a commission then hisher Gross Pay will equal (Hours Worked Hourly Wage)+(Commission % * Weekly Sales). Weekly Sales is cell B3 6 Insert a formala to calculate the amount of Federal Tax (Note: Federal and Soc See Tax are a percentage of the gross pay) 7 Insert a formala to calculate the amount of Soc Sec Tax 3 Inserta forma a tocaklase each employees Net Pay (the difference between gross pay and the tax) Inserta formal to cakulate the Payroll Totals for Hours Worked. Gross Pay, and Net Pay. 1 Questions: 2 21. Which employee received the largest paycheck (Net Pay)? 3 22. What is the total number of hours worked for all employees! 4 22. What is the al Gross Pay for all employees who are in Accounting? s 24. What is the minimum Net Pay? 6 25. What is the average Gros Pay! 7 26. How much did Fox Lake payin payroll use the Gross Pay column)? 3 27. If Weekly Sales increases to $10,000, which employee will receive the largest paycheck? 28. What does the Weekly Sales need to be in order for the total net pay to equal $15.500?