Page 54 - DWGFY24AdoptedBudget
P. 54
120 - ENTERPRISE FUND 2021-22 2022-23 OCT-JUN JUL-SEP 2022-23 2023-24 Variance Variance
FY 23/24 FY 23/24
% Proposed Proposed Proposed
VARIANCE
9 months 3 months % of Budget vs Budget Budget
Original Amended YTD Actual + Actual + Projected Proposed
v
ACTUAL Actual Projected Amended FY 22/23 vs s
Budget Budget Projected vs Amended Budget
Oct - Jun Jul - Sep Budget Actual plus FY 22/23 FY 22/23
Budget
Projected Amended
Actual +
Account Number Account Description Projected Budget
40.7225 Contractual:Cedit CardProcessing 11,276 10,500 10,500 10,463 3,493 13,956 3,456 133% 14,730 106% 774 4,230
40.7226 Contractual:Call Notification Fees 545 600 600 274 105 379 (221) 63% 500 132% 121 (100)
40.7227 Contractual:CC Online Trans Fee 4,775 4,700 4,700 3,831 1,275 5,106 406 109% 5,200 102% 94 500
40.7300 Contractual:Computer System 25,247 27,882 27,882 16,204 11,439 27,643 (240) 99% 27,638 100% (5) (245)
40.7415 Contractual:Contract Labor 1,837 - - - - - - 0% - 0% - -
40.7505 Contractual:Liability Insur 4,304 4,770 4,770 3,651 1,217 4,868 97 102% 4,868 100% (0) 97
40.7510 Contractual:Worker's Compens 2,848 2,859 2,859 1,630 715 2,344 (515) 82% 3,292 140% 948 433
40.7600 Contractual:Refuse Collectio 165,745 171,833 171,833 126,380 44,331 170,711 (1,122) 99% 186,812 109% 16,101 14,979
40.7601 Contractual:Haz Waste Collection 9,283 9,302 9,302 6,929 2,259 9,188 (114) 99% 8,577 93% (611) (725)
40.7605 Contractual:Water System Fee 2,631 2,587 2,587 2,631 - 2,631 44 102% 2,700 103% 69 113
40.7615 Contractual:Sewer Treatment 372,353 363,932 363,932 254,190 124,137 378,328 14,396 104% 417,270 110% 38,942 53,338
40.7650 Contractual:Water Purchase 624,520 609,624 609,624 369,983 421,141 791,124 181,500 130% 647,020 82% (144,104) 37,396
40.7655 Contractual:Water Testing 2,088 31,640 31,640 913 304 1,218 (30,422) 4% 31,640 2598% 30,422 -
40.7699 Contractual:Cost O/H Expense 17,619 24,432 22,867 17,224 2,959 20,183 (2,684) 88% 31,652 157% 11,469 8,785
Total Contractual $ 1,245,072 $ 1,264,662 $ 1,263,097 $ 814,301 613,376 1,427,677 $ 164,580 113% $ 1,381,897 3593% $ (45,780) $ 118,800
40.7834 Capital Lease: Principal Expense 81,606 84,444 84,444 84,437 - 84,437 (7) 100% 87,381 103% 2,944 2,937
40.7835 Capital Lease: Interest Expense 10,161 7,348 7,348 9,128 - 9,128 1,780 124% 6,184 68% (2,944) (1,164)
Total Debt $ 91,767 $ 91,792 $ 91,792 $ 93,565 - 93,565 $ 1,773 102% $ 93,565 7257% $ 0 $ 1,773
40.8010 Other:Membership &Dues 392 1,683 1,683 441 - 441 (1,241) 26% 760 172% 318 (923)
40.8020 Other:Meetings - - - - - - - 0% - 0% - -
40.8025 Other:Mileage Reimbursement 0 - - - - - - 0% - 0% - -
40.8028 Other:Cell Phone Reimbursement 695 1,260 1,260 808 233 1,040 (220) 83% 930 89% (110) (330)
40.8040 Other:Bank Charges 1,270 1,680 1,680 1,208 375 1,583 (97) 94% 1,500 95% (83) (180)
40.8070 Other:Miscellaneous 10 100 100 - 100 100 - 100% 100 100% - -
40.8085 Other:Interest on Cash Deficit - - - - - - - 0% - 0% - -
40.8100 Other:Cash-Short/Over - - - - - - - 0% - 0% - -
40.8199 Other:Cost O/H Expense 2,966 818 2,383 1,936 547 2,483 100 104% 1,311 53% (1,172) (1,072)
Total Other $ 5,334 $ 5,541 $ 7,106 $ 4,393 1,255 5,648 $ (1,458) 79% $ 4,601 81% $ (1,047) $ (2,505)
40.9005 Capital Outlay-Building 21,004 - 4,910 4,649 - 4,649 (261) 95% - 0% (4,649) (4,910)
40.9010 Capital Outlay-Computer/Off Eq - - - - - - - 0% 1,600 0% 1,600 1,600
40.9020 Capital Outlay-Water Tank - - - - - - - 0% 21,000 0% 21,000 21,000
40.9100 Capital Outlay-Vehicles - - - - - - - 0% - 0% - -
40.9200 Capital Outlay - Water System 109,260 - - - 2,400 2,400 2,400 0% 217,777 9074% 215,378 217,777
40.9205 Capital Outlay - Sewer System - - - - - - - 0% - 0% - -
40.9350 Capital Outlay - Equipment 61,894 62,540 70,849 8,309 - 8,309 (62,540) 12% 8,000 96% (309) (62,849)
Total Capital Outlay $ 192,157 $ 62,540 $ 75,759 $ 12,958 2,400 15,358 $ (60,401) 20% $ 248,377 1617% $ 233,019 $ 172,618
40.9700 Transfer Out - - - - - - - 0% - 0% - -
40.9701 Transfer Out:W/S Cost OH 66,000 66,000 66,000 49,500 16,500 66,000 - 100% 66,000 100% - -
Total Other Uses $ 66,000 $ 66,000 $ 66,000 $ 49,500 16,500 66,000 $ - 100% $ 66,000 100% $ - $ -
TOTAL EXPENSES $ 2,225,597 $ 2,186,725 $ 2,229,269 $ 1,444,132 853,355 2,297,487 $ 68,218 103% $ 2,551,149 111% $ 253,662 $ 321,881
Revenue Over/Under) Expenses $ 183,840 $ 0 $ (42,544) $ 63,800 (100,131) (36,331) $ 6,213 85% $ 20,095 -55% $ 56,426 $ 62,639
