he gross pay to each

worker is solely calculated based on his regular pay and overtime pay. There is a $$50$ tax

deduction per dependent. For example, if an employee has two dependents, then $$100$ of

his gross pay is tax free. Use appropriate Excel functions to find the net payment to each

worker and the total net pay in this week. $($Hint: Use VLOOKUP to calculate the Federal

withholding tax according to the tax table data. FICA is calculated based on the employee's

gross pay. The net pay equals to the gross pay minus the federal withholding tax, and

FICA$).$