Example $3-1$

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 is and $($b$)$ December $31.$

Round your answers to the nearest cent. If an amount is zero, enter $"0."$

a$.$

$\backslash$table$[[$Name and Title,$\backslash$table$[[$Annual$],[$Salary$]],$November $15],[\backslash$table$[[$OASDI Taxable$],[$Earnings$]],$OASDI TaX,$\backslash$table$[[$HI Taxable$],[$Earnings$]],,$HI Tax$],[$Hanks$,$ Timothy, President,$$185,040,$$$,$$$,s,1,$$