11A CH6 PR3,4,9,11,15 eBook Show Me How The form below shows the amounts that appear in the Earnings to Date column of the employees' earnings records for 10 Tuil- and part-time workers in Unger Company. These amounts represent the cumulative earnings for each worker as of October 4, the company's last payday. The form also gives the gross amount of earings to be paid each worker on the next payday, October 11. In the state where Unger Company is located, the tax rates and bases are as follows: Tax on Employees: FICA-OASDI 6.2% on first $132,900 FICA-HI 1.45% on total earnings 0.5% on first $8,000 SUTA Tax on Employer: FICA-OASDI 6.2% on first $132,900 FICA-HI FUTA 1.45% on total earnings 0.6% on first $7,000 1.8% on first $8,000 SUTA This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet Required: In the appropriate columns of the form shown below, do the following: 1. Compute the amount to be withheld from each employee's earnings on October 11 for (a) FICA-OASDI, (b) FICA-HI, and (C) SUTA, and determine the total employee taxes. 2. Record the portion of each employee's earnings that is taxable under FICA, FUTA, and SUTA, and calculate the total employer's payroll taxes on the October 11 payroll. 11A CH6 PR3,4,9,11,15 eBook Show Me How Taxes to Be Withheld from Employees' Earnings Under Gross Employer Taxes: Portion of Employees' Earnings Taxable Under FICA Earnings FICA Employee Earnings to Date $138,255 Oct. 11 OASDI HI SUTA OASDI HI FUTA SUTA 1. Weiser, Robert A. $2,070 $ 0 25.96 x $ $ 0 0 $ 0 07 si 2,000 X $ $ 2. Stankard, Laurie C. 15,035 275 18.29 X 3. Grow, Joan L. 4,055 280 18.29 X 4. Rowe, Paul C. 8,120 205 5. McNamara, Joyce M. 7,490 230 6. O'Connor, Roger T. 132,780 1,645 7. Carson, Ronald B. 8,800 275 8. Kenny, Ginni C. 4,270 165 9. Devery, Virginia S. 56,915 605 10. Wilson, Joe W. 3,620 180 Total employee taxes $ 155.31 X $ $ Total taxable earnings $ $ Applicable tax rate (enter as decimals, not percentages) Totals $ $ Total payroll taxes