Page 51 - DWGFY24AdoptedBudget
P. 51
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
Actual +
Projected Amended
Account Number Account Description Projected Budget
00.4300 Water Sales: Billed 1,362,314 1,267,755 1,267,755 801,635 489,761 1,291,396 23,641 102% 1,546,597 120% 255,201 278,842
00.4305 Sewer Sales: Billed 718,812 692,449 692,449 496,955 204,932 701,886 9,437 101% 769,228 110% 67,341 76,778
00.4315 Permits & Fees:Connection Fees 2,500 1,440 1,440 1,300 300 1,600 160 111% 1,440 90% (160) -
00.4318 Permits & Fees:Sewer Tap Fee - 130 130 390 130 520 390 400% 260 50% (260) 130
00.4320 Permits & Fees:Meter & Tap Fee - 500 500 1,172 350 1,522 1,022 304% 600 39% (922) 100
Total Water/Sewer Sales & Fees $ 2,083,626 $ 1,962,274 $ 1,962,274 $ 1,301,452 695,473 1,996,925 $ 34,650 102% $ 2,318,125 116% $ 321,200 $ 355,850
00.4465 Chrg for Serv:Refuse Collectio 183,837 189,375 189,375 139,452 48,449 187,901 (1,474) 99% 203,345 108% 15,445 13,970
00.4470 Chrg for Serv:Haz Waste Collection Fee 10,449 10,452 10,452 7,782 2,537 10,319 (133) 99% 9,611 93% (708) (841)
Total Charges for Service $ 194,286 $ 199,827 $ 199,827 $ 147,234 50,986 198,220 $ (1,607) 99% $ 212,957 107% $ 14,736 $ 13,130
00.4800 Other Rev:Int from Investments 473 840 840 4,285 2,250 6,535 5,695 778% 6,000 92% (535) 5,160
00.4805 Other Rev:Delinquent Charge 19,579 18,000 18,000 14,686 4,500 19,186 1,186 107% 19,200 100% 14 1,200
00.4810 Other Rev:Cellular Tower Lease 11,019 - - - - - - 0% - 0% - -
00.4816 Other Rev: Sales Tax Discount 96 96 96 63 15 78 (18) 81% 63 81% (15) (33)
00.4820 Other Rev: Eqpt Damage Reimburs 20,230 - - - - - - 0% - 0% - -
00.4887 Other Rev: Grant Cares Act 5,760 - - - - - 0% - 0% - -
00.4890 Other Rev: Miscellaneous 1,675 500 500 18,557 - 18,557 18,057 3711% 500 3% (18,057) -
00.4895 Other Rev: Contributed Capital 67,568 - - - - - - 0% 14,400 0% 14,400 14,400
Total Other Revenue $ 126,400 $ 19,436 $ 19,436 $ 37,590 6,765 44,355 $ 24,919 228% $ 40,163 91% $ (4,192) $ 20,727
00.4900 Transfer In - 5,187 5,187 5,187 - 5,187 - 100% - 0% (5,187) (5,187)
00.4954 Other Rev:Prop/Liab Reimb - - - 16,469 - 16,469 16,469 0% - 0% (16,469) -
00.4955 Lease Proceeds - - - - - - - 0% - 0% - -
00.4960 Proceeds from Sale 5,125 - - - - - - 0% - 0% - -
Total Other Sources $ 5,125 $ 5,187 $ 5,187 $ 21,656 - 21,656 $ 16,469 417% $ - 0% $ (21,656) $ (5,187)
TOTAL REVENUES $ 2,409,437 $ 2,186,725 $ 2,186,725 $ 1,507,932 753,224 2,261,156 $ 74,431 103% $ 2,571,244 114% $ 310,088 $ 384,519
40.6000 Personnel:Salaries Full Time 247,259 285,157 285,157 193,095 72,735 265,830 (19,328) 93% 292,535 110% 26,705 7,378
40.6005 Personnel:Salaries Part Time 2,934 5,148 5,148 1,891 3,400 5,292 144 103% 19,500 369% 14,208 14,352
40.6015 Personnel:Salaries Standby 9,960 10,795 10,795 7,866 2,173 10,039 (755) 93% 11,117 111% 1,078 322
40.6020 Personnel:Salaries Overtime 6,212 10,700 10,700 9,823 2,290 12,113 1,413 113% 15,605 129% 3,492 4,905
40.6025 Personnel:Salaries Sick Leave 2,330 502 502 502 - 502 - 100% 1,384 276% 882 882
40.6036 Personnel:Supplements 9,459 11,734 11,734 7,518 2,591 10,109 (1,625) 86% 11,046 109% 938 (688)
40.6050 Personnel:Service Pay-Longevit 929 783 783 780 - 780 (3) 100% 876 112% 95 93
Total Salaries & Wages $ 279,084 $ 324,819 $ 324,819 $ 221,475 83,190 304,664 $ (20,155) 94% $ 352,063 116% $ 47,399 $ 27,244
40.6027 Personnel:Pre-employment Screening 208 100 100 96 50 146 46 146% - 0% (146) (100)
40.6028 Personnel:Recruiting Costs 455 500 500 - - - (500) 0% - 0% - (500)
40.6030 Personnel:FICA(SS) & MediCare 21,403 24,219 24,219 16,185 6,005 22,189 (2,029) 92% 26,053 117% 3,863 1,834
40.6031 Personnel: SUTA Taxes 51 42 42 38 - 38 (4) 90% 45 120% 7 3
40.6042 Personnel:ER-Life/AD&D Ins 103 106 106 101 38 139 33 131% 172 123% 33 66
40.6045 Personnel:TMRS 20,310 70,853 70,853 48,167 17,713 65,880 (4,973) 93% 79,365 120% 13,485 8,511
40.6046 Personnel:ER Long Term Disab 690 876 876 474 135 609 (267) 70% 613 101% 4 (262)
40.6047 Personnel:Employee Health Ins 31,788 43,638 43,638 25,598 9,153 34,751 (8,887) 80% 48,330 139% 13,578 4,691
40.6048 Personnel:HSA/HRA 5,180 6,389 6,389 6,451 2,221 8,672 2,283 136% 10,100 116% 1,428 3,711
40.6049 Personnel:ER Short Term Disab 493 600 600 384 125 508 (92) 85% 570 112% 62 (30)
40.6099 Personnel:TMRS OPEB Supplemental Exp 1,893 1,000 1,000 - 1,000 1,000 - 100% 1,000 100% - -
Total Taxes & Benefits $ 82,575 $ 148,323 $ 148,323 $ 97,493 36,440 133,933 $ (14,391) 90% $ 166,247 124% $ 32,314 $ 17,924
40.6100 Training & Travel 4,511 10,034 9,725 2,531 2,344 4,876 (4,849) 50% 7,734 159% 2,858 (1,991)
Total Training & Travel $ 4,511 $ 10,034 $ 9,725 $ 2,531 2,344 4,876 $ (4,849) 50% $ 7,734 159% $ 2,858 $ (1,991)
