Payroll Accounting: Chapter 3 - Case Problems

I have attached the information needed for the case problem along with attaching my actual homework assignment.... my homework assingment in excel i have to show the excel formula to get the answer and for it to be correct

Chapter Review 3-8f Problem Set. A . Note- In this chapter and in all succeeding work throughout the course, unless instructed otherwise use the following rates, ceiling and maximum taxes. Employee and Employer OASDI: 6.20% $137,700 58,537.40 Employee and Employer HI: 1.4596 No limit No maximum Self-employed OASDI: 12.4% $137,700 $17,074.80 Self-employed HI: 2.996 No limit No maximum For rounding rules, refer to Key Points Summary 3-9A LO 3 See Example 3-1. Example 3-2 Empty Fields Company pays its salaried employees monthly on the last day of each month. The annual salary payroll for 20-follows. Compute the following for the payroll of December 31: Employee Annual OASDI OASDI Tax HI Taxable HI Tax Salary Taxable Wages Wages Utley, Genna S 37,040 Werth, Norm 48,900 Bass, John 40,000 Ruiz, Sam 139,800 Compton, Sue 36,900 Williams, Mary 49,500 Patel, Raymond 106,080 Carson, Abe 56,900 Livinsky, Sarah 37,850 Harper, Mark 51,200 Totals Employer's OASDI Tax $ Employer's HI Tax $