Please show with formulas included for excel programming. Regular hourly wage rate on excel sheet = C7, $16.00 = E7. Hourly rate for work in excess of 40 hours = C8, $24.00 = E8. Hours worked during a January pay period = C9, 47 = E9, Federal income tax withholding = C10, $95.00 = E10. FICA tax rate = C11, 7.65% = E11.

Gross earnings = i13, Regular pay = j14, Overtime pay = j16, Total Gross Earnings = i16, Gross Earnings = i19, FICA taxes witheld = i20, Federal income taxes witheld = i22, Net pay= i24.