Page 47 - CityofDalworthingtonGardensFY25AdoptedBudget
P. 47
120 - ENTERPRISE FUND 2022-23 2023-24 OCT-JUN JUL-SEP 2023-24 2024-25 Variance Variance
FY 24/25 FY 24/25
% Proposed Proposed Proposed
VARIANCE
9 months 3 months % of Budget vs Budget Budget
Original Amended YTD Actual + Actual + Projected Proposed
ACTUAL Actual Projected Amended FY 23/24 vs s
v
Budget Budget Projected vs Amended Budget
Oct - Jun Jul - Sep Budget Actual plus FY 23/24 FY 23/24
Budget
Projected Amended
Actual +
Account Number Account Description Projected Budget
00.4300 Water Sales: Billed 1,349,861 1,546,597 1,546,597 877,112 575,505 1,452,617 (93,980) 94% 1,583,322 109% 130,705 36,725
00.4305 Sewer Sales: Billed 712,254 769,228 769,228 533,029 217,351 750,380 (18,848) 98% 768,552 102% 18,172 (676)
00.4315 Permits & Fees:Connection Fees 2,040 1,440 1,440 1,760 360 2,120 680 147% 1,440 68% (680) -
00.4318 Permits & Fees:Sewer Tap Fee 650 260 260 260 - 260 - 100% 260 100% - -
00.4320 Permits & Fees:Meter & Tap Fee 3,369 600 600 2,052 - 2,052 1,452 342% 600 29% (1,452) -
Total Water/Sewer Sales & Fees 2,068,174 $ 2,318,125 $ 2,318,125 $ 1,414,212 793,216 2,207,428 $ (110,697) 95% $ 2,354,174 107% $ 146,746 $ 36,049
00.4465 Chrg for Serv:Refuse Collectio 187,153 203,345 203,345 150,380 50,413 200,793 (2,553) 99% 213,132 106% 12,339 9,787
00.4470 Chrg for Serv:Haz Waste Collection Fee 10,285 9,611 9,611 7,176 2,407 9,583 (28) 100% 9,836 103% 253 225
Total Charges for Service 197,437 $ 212,957 $ 212,957 $ 157,556 52,819 210,375 $ (2,581) 99% $ 222,968 106% $ 12,593 $ 10,012
00.4800 Other Rev:Int from Investments 7,701 6,000 6,000 6,837 1,500 8,337 2,337 139% 8,051 97% (286) 2,051
00.4805 Other Rev:Delinquent Charge 21,675 19,200 19,200 20,811 7,500 28,311 9,111 147% 33,600 119% 5,289 14,400
00.4810 Other Rev:Cellular Tower Lease - - - - - - - 0% - 0% - -
00.4816 Other Rev: Sales Tax Discount 86 63 63 114 39 153 90 242% 168 110% 15 105
00.4820 Other Rev: Eqpt Damage Reimburs - - - - - - - 0% - 0% - -
00.4879 Other Rev: DWG Contribution - - - 2,500 - 2,500 2,500 0% - 0% (2,500) -
00.4887 Other Rev: Grant Cares Act - - - - - - - 0% - 0% - -
00.4890 Other Rev: Miscellaneous 18,647 500 500 210 - 210 (290) 42% - 0% (210) (500)
00.4895 Other Rev: Contributed Capital - 14,400 14,400 - 32,400 32,400 18,000 225% - 0% (32,400) (14,400)
Total Other Revenue 48,108 $ 40,163 $ 40,163 $ 30,471 41,439 71,910 $ 31,747 179% $ 41,819 58% $ (30,091) $ 1,656
00.4900 Transfer In 5,187 - - - - - - 0% - 0% - -
00.4954 Other Rev:Prop/Liab Reimb 16,469 - - - - - - 0% - 0% - -
00.4955 Lease Proceeds - - - - - - - 0% - 0% - -
00.4960 Proceeds from Sale - - - - - - - 0% - 0% - -
Total Other Sources 21,656 $ - $ - $ - - - $ - 0% $ - 0% $ - $ -
TOTAL REVENUES 2,335,376 $ 2,571,244 $ 2,571,244 $ 1,602,240 887,474 2,489,714 $ (81,530) 97% $ 2,618,961 105% $ 129,247 $ 47,717
40.6000 Personnel:Salaries Full Time 265,280 292,535 292,535 147,743 52,732 200,475 (92,060) 69% 278,138 139% 77,663 (14,397)
40.6005 Personnel:Salaries Part Time 7,131 19,500 19,500 13,760 7,550 21,310 1,810 109% 39,858 187% 18,548 20,358
40.6015 Personnel:Salaries Standby 10,563 11,117 11,117 6,762 2,985 9,747 (1,370) 88% 11,374 117% 1,626 257
40.6020 Personnel:Salaries Overtime 13,470 15,605 15,605 4,426 970 5,396 (10,209) 35% 8,124 151% 2,728 (7,481)
40.6025 Personnel:Salaries Sick Leave 502 1,384 1,384 517 - 517 (867) 37% 573 111% 56 (811)
40.6036 Personnel:Supplements 10,130 11,046 11,046 22,479 10,475 32,955 21,908 298% 31,844 97% (1,110) 20,798
40.6050 Personnel:Service Pay-Longevit 780 876 876 712 - 712 (164) 81% 758 107% 46 (118)
Total Salaries & Wages 307,856 $ 352,063 $ 352,063 $ 196,399 74,713 271,112 $ (80,951) 77% $ 370,669 137% $ 99,557 $ 18,606
40.6027 Personnel:Pre-employment Screening 149 - - - - - - 0% - 0% - -
40.6028 Personnel:Recruiting Costs - - - - - - - 0% - 0% - -
40.6030 Personnel:FICA(SS) & MediCare 23,219 26,053 26,053 14,436 5,471 19,907 (6,145) 76% 27,429 138% 7,522 1,377
40.6031 Personnel: SUTA Taxes 47 45 45 565 - 565 520 1253% 787 139% 222 742
40.6042 Personnel:ER-Life/AD&D Ins 139 172 172 88 32 120 (52) 70% 189 158% 69 17
40.6045 Personnel:TMRS 88,119 79,365 79,365 42,342 15,938 58,280 (21,085) 73% 79,295 136% 21,016 (69)
40.6046 Personnel:ER Long Term Disab 609 613 613 312 108 420 (194) 68% 568 135% 148 (46)
40.6047 Personnel:Employee Health Ins 34,604 48,330 48,330 23,629 8,644 32,273 (16,056) 67% 59,883 186% 27,610 11,554
40.6048 Personnel:HSA/HRA 8,669 10,100 10,100 4,736 1,287 6,023 (4,076) 60% 6,828 113% 805 (3,271)
40.6049 Personnel:ER Short Term Disab 508 570 570 296 107 404 (166) 71% 606 150% 202 36
40.6099 Personnel:TMRS OPEB Supplemental Exp 349 1,000 1,000 - 1,000 1,000 - 100% 1,000 100% - -
Total Taxes & Benefits 156,412 $ 166,247 $ 166,247 $ 86,405 32,587 118,991 $ (47,256) 72% $ 176,586 148% $ 57,595 $ 10,339
