Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In 20--, the annual salaries paid to each of the officers of Abrew, Inc., follow. The officers are paid semimonthly on the 15 th and
In 20--, the annual salaries paid to each of the officers of Abrew, Inc., follow. The officers are paid semimonthly on the 15 th and the last day of the month. 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 Compute the FICA taxes to be withheld from each officer's pay on (a) November 15 and (b) December 31. Round your answers to the nearest cent. If an amount is zero, enter "0". b. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline \multirow{3}{*}{NameandTitleHanks,Timothy,President} & \multirow{3}{*}{AnnualSalary$169,200} & \multicolumn{8}{|c|}{ December 31} \\ \hline & & \multicolumn{2}{|l|}{OASDITaxableEarnings} & OASDI Tax & & \multicolumn{2}{|l|}{HITaxableEarnings} & \multicolumn{2}{|l|}{ HI Tax } \\ \hline & & 25,910 & x & $ & & 7,050 & $ & 102 & x \\ \hline Grath, John, VP Finance & 149,520 & 3,100 & x & 1,606 & x & 6,230 & & 90 & x \\ \hline James, Sally, VP Sales & 74,400 & 2,250 & x & 192 & x & 3,100 & & 45 & x \\ \hline Kimmel, Joan, VP Mfg. & 54,000 & 2,100 & x & 139 & x & 2,250 & & 33 & x \\ \hline Wie, Pam, VP Personnel & 50,400 & 2,000 & x & 130 & x & 2,100 & & 30 & x \\ \hline Grant, Mary, VP Secretary & 48,000 & 2,000 & & 124 & & 2,000 & & 29 & \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started