Spreadsheet: 825329d1681248054-forecasting-with-gaps-book1
Sheet: Expense

DEPTID | 2023_01 | 2023_02 | 2023_03 | 2023_04 | 2023_05 | 2023_06 | 2023_07 | Expense Total | PROJECTION | Proj-2023_08 | Proj-2023_09 | Proj-2023_10 | Proj-2023_11 | Proj-2023_12 | Average Monthly Expense | YTD Paid FTEs | Avg Monthly Cost Per | FTE-Based  Proj Exp in Remaining Months | Exp-Based  Proj Exp in Remaining Months | Final Projection | Difference To Load
AEDAPS | 21.66 | 2.06 | 0 | 0 | 0 | 0 | 0 |  | 95 |  |  |  |  |  |  | 1.1
APS0 | 0 | 35.42 | 35.42 | 35.42 | 35.42 | 35.42 | 16.94 | 194.04 | 57 |  |  |  |  |  |  | 5.8
BKGOSS | 0 | 67.91 | 67.91 | 67.91 | 67.91 | 67.91 | 107.49 | 447.04 | 1058 |  |  |  |  |  |  | 11.6
CACSPS | 226.29 | -226.29 | 0 | 0 | 0 | 0 | 0 |  | 1 |  |  |  |  |  |  | 0
CACSPS | 0 | 452.58 | 226.29 | 226.29 | 226.29 | 226.29 | 226.29 | 1584.03 | 33639 |  |  |  |  |  |  | 7
COACCP | 0 | 0 | 0 | 0 | 22.67 | 208.12 | 208.12 | 438.91 | 923 |  |  |  |  |  |  | 5.5
COACRS | 0 | 136.93 | 86.28999999999999 | 86.28999999999999 | 255.03 | 588.22 | 558.6899999999999 | 1711.45 | 33434 |  |  |  |  |  |  | 11.8
EPR0 | 82.08 | 82.08 | 82.08 | 82.08 | 82.08 | 0 | 0 |  | 903 |  |  |  |  |  |  | 5
FFFINV | 0 | 0 | 0 | 0 | 166.47 | 186.47 | 186.47 | 539.41 | 1412 |  |  |  |  |  |  | 3
FFFLEG | 0 | 0 | 0 | 0 | 0 | 4.94 | 136.45 | 141.39 | 341 |  |  |  |  |  |  | 1.3
FFFQRT | 0 | 0 | 539.45 | 736.47 | 744.03 | 1909.29 | 681.9500000000002 | 4611.19 | 8644 |  |  |  |  |  |  | 20.7
MEDOTH | 0 | 0 | 0 | 0 | 0 | 145.09 | 144.58 | 289.67 | 580 |  |  |  |  |  |  | 2.3
OCACEN | 618.9599999999999 | 604.85 | 0 | 0 | 0 | 0 | 0 |  | 4895 |  |  |  |  |  |  | 5.5
OCACEN | 2456.300000000001 | 2456.3 | 3.86 | 0 | 0 | 0 | 0 |  | 19666 |  |  |  |  |  |  | 22
OCACEN | 3791.74 | 3922.52 | 3923.41 | 0 | 0 | 0 | 0 |  | 46551 |  |  |  |  |  |  | 32
OCACEN | 229.26 | 229.26 | 0 | 0 | 0 | 0 | 0 |  | 1834 |  |  |  |  |  |  | 2
OOACRS | 0 | 0 | 2452.44 | 2456.3 | 2456.3 | 2456.3 | 2456.300000000001 | 12277.64 | 24553 |  |  |  |  |  |  | 55
OOACSS | 0 | 0 | 229.26 | 229.26 | 229.26 | 229.26 | 229.26 | 1146.3 | 2293 |  |  |  |  |  |  | 5
OOADPS | 0 | 0 | 580.41 | 580.41 | 580.41 | 580.41 | 806.2600000000001 | 3127.9 | 5804 |  |  |  |  |  |  | 22
PERETV | 0 | 0 | 21.5 | 21.44 | 21.44 | 21.44 | 21.44 | 107.26 | 215 |  |  |  |  |  |  | 5
PGSADS | 0 | 0 | 0 | 0 | 0 | 820.46 | 820.46 | 1640.92 | 5743 |  |  |  |  |  |  | 8
PGSADS | 0 | 0 | 0 | 0 | 0 | 3993.54 | 3993.539999999999 | 7987.079999999998 | 0 |  |  |  |  |  |  | 36
PGSADS | 0 | 0 | 0 | 0 | 0 | 1523.57 | 1523.57 | 3047.14 | 0 |  |  |  |  |  |  | 16
PGSCEN | 5871.78 | 6077.869999999997 | 6203.36 | 6433.649999999999 | 6475.139999999999 | 0 | 0 |  | 68336 |  |  |  |  |  |  | 155.9
PGSCEN | 540.87 | 560.87 | 580.87 | 334.98 | 327.61 | 0 | 0 |  | 114305 |  |  |  |  |  |  | 9.2
PGSCPS | 820.46 | 820.46 | 820.46 | 820.46 | 820.46 | 0 | 0 |  | 9025 |  |  |  |  |  |  | 20
PGSLOG | 0 | 0 | 0 | 0 | 0 | 77.47 | 77.47 | 154.94 | 0 |  |  |  |  |  |  | 2
PGSLOG | 0 | 0 | 0 | 0 | 0 | 2109.6 | 2109.6 | 4219.200000000001 | 0 |  |  |  |  |  |  | 16
PGSLOG | 0 | 0 | 0 | 0 | 0 | 327.61 | 327.61 | 655.22 | 328 |  |  |  |  |  |  | 1
PGSPSO | 0 | 0 | 0 | 0 | 0 | 1662.72 | 1648.85 | 3311.570000000001 | 0 |  |  |  |  |  |  | 15.6
PGSREG | 3802.73 | 3924.99 | 3924.99 | 3944.99 | 3944.99 | 0 | 0 |  | 42994 |  |  |  |  |  |  | 84
PGSWSS | 0 | 0 | 0 | 0 | 0 | 879.46 | 894.4599999999999 | 1773.92 | 0 |  |  |  |  |  |  | 12.6
WDDOSS | 0 | 0 | 0 | 0 | 0 | 304.08 | 409.91 | 713.99 | 2129 |  |  |  |  |  |  | 3
01ADDINH | 0 | 0 | 0 | 0 | 0 | 270.97 | 234.4 | 505.37 | 1897 |  |  |  |  |  |  | 3
02ADDINH | 0 | 0 | 0 | 0 | 0 | 230 | 230 | 460 | 0 |  |  |  |  |  |  | 2
04ADDINH | 0 | 0 | 0 | 0 | 0 | 166.23 | 170.74 | 336.97 | 0 |  |  |  |  |  |  | 1.8
05ADDINH | 0 | 0 | 0 | 0 | 110.2 | 132.08 | 132.08 | 374.36 | 1585 |  |  |  |  |  |  | 2.3
07ADDINH | 0 | 0 | 0 | 0 | 0 | 321.83 | 321.0699999999999 | 642.8999999999999 | 0 |  |  |  |  |  |  | 4
07CDDRGS | 0 | 0 | 0 | 4.93 | 30.85 | 30.85 | 30.85 | 97.47999999999999 | 200 |  |  |  |  |  |  | 4
08ADDEAS | 203.41 | -203.41 | 0 | 0 | 0 | 0 | 0 |  | 0 |  |  |  |  |  |  | 0
08ADDEAS | 0 | 406.8200000000001 | 203.41 | 203.41 | 223.41 | 223.41 | 223.41 | 1483.87 | 2521 |  |  |  |  |  |  | 7
09CDDELG | 0 | 5.75 | 10.97 | 10.97 | 10.97 | 10.97 | 85.07 | 134.7 | 109 |  |  |  |  |  |  | 6.5
09CDDFAD | 0 | 0 | 203.33 | 203.33 | 203.33 | 203.33 | 203.33 | 1016.65 | 26033 |  |  |  |  |  |  | 5
10ADDINH | 0 | 0 | 0 | 0 | 0 | 292.09 | 310 | 602.0899999999999 | 0 |  |  |  |  |  |  | 1.3
3ECBCCOA | 0 | 226.82 | 226.82 | 226.82 | 226.82 | 226.82 | 226.82 | 1360.92 | 2495 |  |  |  |  |  |  | 6
3ECDDFBS | 85.27 | 85.27 | 85.27 | 85.27 | 85.27 | 0 | 0 |  | 17438 |  |  |  |  |  |  | 5
3WINVRGS | 0 | 58.09 | 67.03999999999999 | 67.03999999999999 | 67.03999999999999 | 67.03999999999999 | 67.03999999999999 | 393.29 | 18718 |  |  |  |  |  |  | 5.6
6ACDDFAD | 1772.08 | 1613.79 | 106.3 | 0 | 0 | 0 | 0 |  | 13969 |  |  |  |  |  |  | 12.9
6BCDDCLC | 0 | 0 | 0 | 0 | 60.09 | 65.94 | 65.94 | 191.97 | 504 |  |  |  |  |  |  | 2.7
8ACBCCOA | 286.29 | 0 | 0 | 0 | 0 | 0 | 0 |  | 2004 |  |  |  |  |  |  | 1
8BCBCOVR | 0 | 2370.41 | 2390.41 | 2410.41 | 2410.41 | 2430.41 | 2450.41 | 14462.46 | 27927 |  |  |  |  |  |  | 71.9