Example $3-1$In $20--,$ the annual salaries paid 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 spreadsheetCompute 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".$a$.$ November $15$Name and TitleAnnualSalaryOASDI TaxableEarningsOASDI TaxHI Taxable EarningsHI TaxHanks, Timothy, President$$164,340$$fill in the blank $2$$fill in the blank $3$$fill in the blank $4$$fill in the blank $5$Grath, John, VP Finance$138,720$fill in the blank $6$fill in the blank $7$fill in the blank $8$fill in the blank $9$James, Sally, VP Sales$78,000$fill in the blank $10$fill in the blank $11$fill in the blank $12$fill in the blank $13$Kimmel, Joan, VP Mfg$\mathrm{.}52,800$fill in the blank $14$fill in the blank $15$fill in the blank $16$fill in the blank $17$Wie, Pam, VP Personnel$51,600$fill in the blank $18$fill in the blank $19$fill in the blank $20$fill in the blank $21$Grant, Mary, VP Secretary$44,400$fill in the blank $22$fill in the blank $23$fill in the blank $24$fill in the blank $25$b$.$ December $31$Name and TitleAnnualSalaryOASDI Taxable EarningsOASDI TaxHI Taxable EarningsHI TaxHanks, Timothy, President$$164,340$$fill in the blank $26$$fill in the blank $27$$fill in the blank $28$$fill in the blank $29$Grath, John, VP Finance$138,720$fill in the blank $30$fill in the blank $31$fill in the blank $32$fill in the blank $33$James, Sally, VP Sales$78,000$fill in the blank $34$fill in the blank $35$fill in the blank $36$fill in the blank $37$Kimmel, Joan, VP Mfg$\mathrm{.}52,800$fill in the blank $38$fill in the blank $39$fill in the blank $40$fill in the blank $41$Wie, Pam, VP Personnel$51,600$fill in the blank $42$fill in the blank $43$fill in the blank $44$fill in the blank $45$Grant, Mary, VP Secretary$44,400$fill in the blank $46$fill in the blank $47$fill in the blank $48$fill in the blank $49$