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

3-8g Problem Set. B . 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 $8,537,40 Employee and Employer HI: 1.45% No limit No maximum Self-employed OASDI: 12.496 $137.700 $17,074.800 Self-employed HI: 2.99 No limit No maximum For rounding rules, refer to Kay Points Summary 3-9B LO 3 See Example 3-1. Example 3-2 Haggerty 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 Stern. Myra $ 42,150 Lundy, Hal 39,500 Franks, Rob 46,000 Haggerty, Alan 161,280 Ward, Randy 40.800 Hoskin, AB 39,600 Wee, Pam 145,500 Prince Harry 76,800 Maven, Mary 52,000 Harley David 68,960 Totals Employer's OASDI Tax $ Employer's HI Tax $