Budget

Excel 2016 file:   budget.xlsx

Formula		Cell
Amount Overpaid / Underpaid
=SUM(D2-C2) =SUM(D3-C3) =SUM(D4-C4) =SUM(D5-C5) =SUM(D6-C6) =SUM(D7-C7) =SUM(D8-C8) =SUM(D9-C9) =SUM(D10-C10) =SUM(D11-C11) =SUM(E2:E11) =AVERAGE(E2:E11) =MIN(E2:E11) =MAX(E2:E11)		E2 E3 E4 E5 E6 E7 E8 E9 E10 E11 E13 E14 E15 E16

---

Pay Status
=IF(E2<0,"Underpaid","Paid") =IF(E3<0,"Underpaid","Paid") =IF(E4<0,"Underpaid","Paid") =IF(E5<0,"Underpaid","Paid") =IF(E6<0,"Underpaid","Paid") =IF(E7<0,"Underpaid","Paid") =IF(E8<0,"Underpaid","Paid") =IF(E9<0,"Underpaid","Paid") =IF(E10<0,"Underpaid","Paid") =IF(E11<0,"Underpaid","Paid")		F2 F3 F4 F5 F6 F7 F8 F9 F10 F11

---

Days On Time / Late
=SUM(G2-H2) =SUM(G3-H3) =SUM(G4-H4) =SUM(G5-H5) =SUM(G6-H6) =SUM(G7-H7) =SUM(G8-H8) =SUM(G9-H9) =SUM(G10-H10) =SUM(G11-H11)		I2 I3 I4 I5 I6 I7 I8 I9 I10 I11