AutoSave OF AAP 2G ... Chapter 9 Exercises Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial v 10 ~ A X G 25 Wrap Text General Insert v AY 0 v Delete Paste B I U U Y AvA = = = Merge & Center v $ % 4 Conditional Format Cell Formatting es Table Styles Sort & Filter # Format Find & Select Analyze Data Sensitivity V a20 fx A B C D E F G H I J K K L M N 0 a R S T V Name: Date: When the calculations for the payroll totals are correct, the cells will change to yellow. Mest Company has nine employees. FICA Social Security taxes are 6.2% of the first $137,700 paid to each employee, and FICA Medicare taxes are 1.45% of gross pay. FUTA taxes are 0.6% and SUTA taxes are 5.4% of the first $7,000 paid to each employee. Cumulative pay for the current year for each of its employees follows. Employee Cumulative Pay Employee Cumulative Pay Employee Cumulative Pay KB S $6,000 Julie W $143.500 Christina S $140,200 Tim V 40,400 Michael M 106.900 Kitty O 36,900 Steve S 87,000 Zach R 137,700 John W 4,000 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 a. Compute the amounts in this table for each employee. b. For the company, compute each total for FICA Social Security taxes, FICA Medicare taxes, FUTA taxes, and SUTA taxes. Hint: Remember to include in those totals any employee share of taxes that the company must collect. 1234567899HHBU898d89%B Pay Subject to FICA Social Security D Employee Cumulative Pay Pay Subject to FICA Medicare Pay Subject to FUTA Taxes Pay Subject to SUTA Taxes Ken 5 Tim V Steve S Julie W Michael M Zach R Christina S Kitty O John W Totals $6,000 40,400 87,000 143,500 106,900 137,700 140.200 36,900 4,000 $702,600 31 32 33 34 Exercise 9-11 Exercise 9-12 Exercise 9-17 P 9-1A P 9-54 + Ready + 140%