| Monk's Café | ||||||
| Week 3 Payroll | ||||||
| Employee | Rate of Pay | Total Hours Worked | Regular Hours Worked | Overtime Hours Worked | Gross Pay | |
| Ashley Zwierlein | 7.75 | 48 | =IF(C5>$D$14,$D$14,C5) | =IF(C5>$D$14,C5-$D$14,0) | =(D5*B5)+(E5*B5*$D$15) | |
| Uncle Leo | 9.5 | 56.5 | =IF(C6>$D$14,$D$14,C6) | =IF(C6>$D$14,C6-$D$14,0) | =(D6*B6)+(E6*B6*$D$15) | |
| Frank Costanza | 8 | 39 | =IF(C7>$D$14,$D$14,C7) | =IF(C7>$D$14,C7-$D$14,0) | =(D7*B7)+(E7*B7*$D$15) | |
| Cosmo Kramer | 14.75 | 16.5 | =IF(C8>$D$14,$D$14,C8) | =IF(C8>$D$14,C8-$D$14,0) | =(D8*B8)+(E8*B8*$D$15) | |
| Estelle Costanza | 6 | 44 | =IF(C9>$D$14,$D$14,C9) | =IF(C9>$D$14,C9-$D$14,0) | =(D9*B9)+(E9*B9*$D$15) | |
| Bob Saccamena | 10.25 | 36.5 | =IF(C10>$D$14,$D$14,C10) | =IF(C10>$D$14,C10-$D$14,0) | =(D10*B10)+(E10*B10*$D$15) | |
| Total | =SUM(C5:C10) | =SUM(D5:D10) | =SUM(E5:E10) | =SUM(F5:F10) | ||
| Overtime Hour Limit | 40 | |||||
| Overtime Pay Increase | 1.5 | |||||