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".$

a$.$

November $15$

Name and Title Annual

Salary OASDI Taxable

Earnings

OASDI Tax HI Taxable

Earnings

HI Tax

Hanks, Timothy, President $$169,380$ $fill in the blank $2$

$fill in the blank $3$

$fill in the blank $4$

$fill in the blank $5$

Grath, John, VP Finance $148,560$ fill in the blank $6$

fill in the blank $7$

fill in the blank $8$

fill in the blank $9$

James, Sally, VP Sales $70,800$ fill in the blank $10$

fill in the blank $11$

fill in the blank $12$

fill in the blank $13$

Kimmel, Joan, VP Mfg$.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 $52,800$ fill in the blank $18$

fill in the blank $19$

fill in the blank $20$

fill in the blank $21$

Grant, Mary, VP Secretary $46,800$ 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 Title Annual

Salary OASDI Taxable

Earnings

OASDI Tax HI Taxable

Earnings

HI Tax

Hanks, Timothy, President $$169,380$ $fill in the blank $26$

$fill in the blank $27$

$fill in the blank $28$

$fill in the blank $29$

Grath, John, VP Finance $148,560$ fill in the blank $30$

fill in the blank $31$

fill in the blank $32$

fill in the blank $33$

James, Sally, VP Sales $70,800$ fill in the blank $34$

fill in the blank $35$

fill in the blank $36$

fill in the blank $37$

Kimmel, Joan, VP Mfg$.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 $52,800$ fill in the blank $42$

fill in the blank $43$

fill in the blank $44$

fill in the blank $45$

Grant, Mary, VP Secretary $46,800$ fill in the blank $46$

fill in the blank $47$

fill in the blank $48$

fill in the blank $49$