I need help with the last question on the excel worksheet. and can you make sure the rest of my questions are correct? 3-9A Empty Fields Company pays it's salaried employees monthly on the last day of each month. The annual Salary payroll for 2014 follows. Compute the following for the payroll of December 31.

AC120 2014 Edition 3-1A Rite-Shop Biweekly Taxable Wages Employee No. Employee Name 711 512 624 325 422 210 111 Castro, Manny $493.28 870.00 419.80 523.20 1,100.00 950.00 489.75 Corrales, Pat Guitar, Joseph Moore, Connie Morrison, Harry Robertson, Catherine Swarez, Joseph Totals Employer's OASDI $4,846.03 $4,846.03 $4,846.03 $70.27 3-8A Employer's HI Tax OASDI a b c 9th paycheck 17th paycheck 24th paycheck $7.15 12.62 6.09 7.59 15.95 13.78 7.10 $70.28 Employer's OASDI Tax Total Taxable Wages 3-2A $20.72 36.54 17.63 21.97 46.20 39.90 20.57 $203.53 HI $300.45 Total Taxable Wages Employer's HI Tax OASDI HI $210.80 210.80 210.80 $49.30 49.30 49.30 Salary (a) The amount of FICA taxes that was withheld from his earnings paid by Odesto Company. $64,600 OASDI HI $4,005.20 $936.70 OASDI HI $5,642.00 $1,392.00 Business (b) Henwood's self-employment taxes on net business income from public accounting business. $60,000 3-9A Employee Utley, Genna Werth, Norm Bass, John Ruiz, Sam Compton, Sue Williams, Mary Patel, Raymond Carson, Abe Livinsky, Sarah Harper, Mark Totals Employer's OASDI Tax Employer's HI Tax Annual Salary $22,150 48,900 24,000 107,280 20,900 19,500 106,080 56,900 37,850 51,200 OASDI Taxable Wages $22,150 48,900 24,000 107,280 20,900 19,500 106,080 56,900 37,850 51,200 $494,760.00 OASDI Tax 1,373.30 3,031.80 1,488.00 0.00 1,295.80 1,209.00 6,576.96 3,527.70 2,346.70 3,174.40 $24,023.66 HI Tax $321.18 709.05