Page 57 - City of DWG FY 2022-23 BUDGET
P. 57
120 - ENTERPRISE FUND 2020-21 2021-22 2021-22 2022-23 Variance Variance
FY 22/23 FY 22/23
% Proposed Proposed Proposed
VARIANCE
FY 21/22 Amended YTD Actual + Actual + Projected % of Proposed Budget vs Budget Budget
v
ACTUAL Amended FY 21/22 vs s
Budget Budget Projected vs Amended Budget Budget Actual plus FY 21/22 FY 21/22
Budget
Projected Amended
Actual +
Account Number Account Description Projected Budget
40.7225 Contractual:Cedit CardProcessing 12,192 7,700 7,700 10,692 2,992 139% 10,500 98% (192) 2,800
40.7226 Contractual:Call Notification Fees 301 300 300 546 246 182% 600 110% 55 300
40.7227 Contractual:CC Online Trans Fee 2,171 3,900 3,900 4,758 858 122% 4,700 99% (58) 800
40.7300 Contractual:Computer System 19,689 23,507 23,591 25,722 2,131 109% 27,882 108% 2,160 4,291
40.7415 Contractual:Contract Labor - 3,116 3,116 0% - 0% (3,116) -
40.7505 Contractual:Liability Insur 3,097 4,323 4,323 4,304 (19) 100% 4,770 111% 467 447
40.7510 Contractual:Worker's Compens 3,210 2,806 2,806 2,848 42 102% 2,859 100% 11 53
40.7600 Contractual:Refuse Collectio 163,801 169,517 169,517 165,339 (4,178) 98% 171,833 104% 6,494 2,316
40.7601 Contractual:Haz Waste Collection 9,711 9,249 9,249 9,265 16 100% 9,302 100% 37 53
40.7605 Contractual:Water System Fee 2,587 2,587 2,587 2,631 44 102% 2,587 98% (44) -
40.7615 Contractual:Sewer Treatment 345,398 348,109 348,109 374,595 26,486 108% 363,932 97% (10,663) 15,823
40.7650 Contractual:Water Purchase 479,312 471,273 471,273 633,459 162,187 134% 609,624 96% (23,835) 138,352
40.7655 Contractual:Water Testing 1,521 - 1,640 2,088 448 127% 31,640 1515% 29,552 30,000
40.7699 Contractual:Cost O/H Expense 21,753 23,938 23,938 20,102 (3,836) 84% 24,432 122% 4,330 494
Total Contractual $ 1,064,745 $ 1,067,209 $ 1,068,932 1,259,464 $ 190,532 118% $ 1,264,662 2453% $ 5,197 $ 195,730
40.7834 Capital Lease: Principal Expense 78,863 81,606 81,606 81,636 30 100% 84,444 103% 2,808 2,838
40.7835 Capital Lease: Interest Expense 12,989 10,186 10,186 10,131 (55) 99% 7,348 73% (2,783) (2,838)
Total Debt $ 91,852 $ 91,792 $ 91,792 91,767 $ (25) 100% $ 91,792 4973% $ 25 $ 0
40.8005 W/S ROW Cost Recovery Fee 66,000 66,000 - - - 0% - 0% - -
40.8010 Other:Membership &Dues 130 1,347 1,347 1,500 153 111% 1,683 112% 183 336
40.8020 Other:Meetings - - - - - 0% - 0% - -
40.8025 Other:Mileage Reimbursement 48 300 - 0 0 0% - 0% (0) -
40.8028 OtherLCell Phone Reimbursement 300 - 525 695 170 132% 1,260 181% 565 735
40.8040 Other:Bank Charges 373 - 600 1,304 704 217% 1,680 129% 376 1,080
40.8070 Other:Miscellaneous 301 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 1,506 1,985 1,985 1,395 (590) 70% 818 59% (577) (1,167)
Total Other $ 68,659 $ 69,732 $ 4,557 4,994 $ 436 110% $ 5,541 111% $ 547 $ 983
40.9005 Capital Outlay-Building - - - 19,357 19,357 0% - 0% (19,357) -
40.9010 Capital Outlay-Computer/Off Eq 5,900 - - - - 0% - 0% - -
40.9100 Capital Outlay-Vehicles - - - - - 0% - 0% - -
40.9200 Capital Outlay - Water System 39,911 - 114,114 109,260 (4,854) 96% - 0% (109,260) (114,114)
40.9205 Capital Outlay - Sewer System - - - - - 0% - 0% - -
40.9350 Capital Outlay - Equipment - 94,779 75,422 75,422 - 100% 62,540 83% (12,882) (12,882)
Total Capital Outlay $ 45,811 $ 94,779 $ 189,536 204,039 $ 14,503 108% $ 62,540 31% $ (141,498) $ (126,996)
40.9700 Transfer Out - - - - - 0% - 0% - -
40.9701 Transfer Out:W/S Cost OH - - 66,000 66,000 - 100% 66,000 100% - -
40.9710 Loss of Asset Disposition - - - - - 0% - 0% - -
Total Other Uses $ - $ - $ 66,000 66,000 $ - 100% $ 66,000 100% $ - $ -
TOTAL EXPENSES $ 1,778,411 $ 1,978,069 $ 2,144,999 2,337,812 $ 192,813 109% $ 2,186,725 94% $ (151,087) $ 41,726
Revenue Over/Under) Expenses $ 202,617 $ (0) $ (90,617) 102,444 $ 193,060 -113% $ (0) 0% $ (102,444) $ 90,617
