TAB "PAYROLL"

5. Calculate Gross Earnings

6. Calculate Deduction amount (Deduction amount = HCSP + Retirement + 401(k) + Health Insurance + Dental Insurance + Parking). Remember that employees might not have all of those deduction types.

7. Calculate Withholding amount. (Withholding amount = State WH + Federal WH + Social Security Tax + Medicare tax)

Please put totals in for the columns in requirements 5-7 (use of the SUM function is recommend