Page 53 - City of DWG FY 2022-23 BUDGET
P. 53
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
ACTUAL Amended FY 21/22 vs s
v
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
00.4300 Water Sales: Billed 1,082,239 1,090,905 1,090,905 1,399,447 308,542 128% 1,267,755 91% (131,692) 176,850
00.4305 Sewer Sales: Billed 651,704 655,665 655,665 718,914 63,249 110% 692,449 96% (26,465) 36,784
00.4315 Permits & Fees:Connection Fees 1,919 1,200 1,200 2,480 1,280 207% 1,440 58% (1,040) 240
00.4318 Permits & Fees:Sewer Tap Fee 260 130 130 130 - 100% 130 100% - -
00.4320 Permits & Fees:Meter & Tap Fee 1,175 1,000 1,000 500 (500) 50% 500 100% - (500)
Total Water/Sewer Sales & Fees $ 1,737,297 $ 1,748,900 $ 1,748,900 2,121,471 $ 372,571 121% $ 1,962,274 92% $ (159,197) $ 213,375
00.4465 Chrg for Serv:Refuse Collectio 179,945 186,939 186,939 183,460 (3,479) 98% 189,375 103% 5,915 2,436
00.4470 Chrg for Serv:Haz Waste Collection Fee 10,361 10,392 10,392 10,410 18 100% 10,452 100% 42 60
Total Charges for Service $ 190,306 $ 197,331 $ 197,331 193,870 $ (3,461) 98% $ 199,827 103% $ 5,957 $ 2,496
00.4800 Other Rev:Int from Investments 1,624 240 240 485 245 202% 840 173% 355 600
00.4805 Other Rev:Delinquent Charge 20,917 19,271 19,271 18,717 (554) 97% 18,000 96% (717) (1,271)
00.4810 Other Rev:Cellular Tower Lease 6,122 12,243 12,243 11,019 (1,224) 90% - 0% (11,019) (12,243)
00.4815 Other Rev:CC Online Payments 1,168 - - - - 0% - 0% - -
00.4816 Other Rev: Sales Tax Discount 61 84 84 96 12 114% 96 100% 0 12
00.4820 Other Rev: Eqpt Damage Reimburs - - - 20,230 20,230 0% - 0% (20,230) -
00.4887 Other Rev: Grant Cares Act 8,824 - - - - 0% - 0% - -
00.4890 Other Rev: Miscellaneous 14,709 - - 1,675 1,675 0% 500 30% (1,175) 500
00.4895 Other Rev: Contributed Capital - - 76,313 67,568 (8,745) 89% - 0% (67,568) (76,313)
Total Other Revenue $ 53,425 $ 31,838 $ 108,151 119,790 $ 11,638 111% $ 19,436 16% $ (100,354) $ (88,715)
00.4900 Transfer In - - - - - 0% 5,187 0% 5,187 5,187
00.4955 Lease Proceeds - - - - - 0% - 0% - -
00.4960 Proceeds from Sale - - - 5,125 5,125 0% - 0% (5,125) -
Total Other Sources $ - $ - $ - 5,125 $ 5,125 0% $ 5,187 101% $ 62 $ 5,187
TOTAL REVENUES $ 1,981,028 $ 1,978,069 $ 2,054,382 2,440,255 $ 385,873 119% $ 2,186,725 90% $ (253,531) $ 132,343
40.6000 Personnel:Salaries Full Time 239,595 267,913 267,913 244,586 (23,328) 91% 285,157 117% 40,572 17,244
40.6005 Personnel:Salaries Part Time 707 - - 2,964 2,964 0% 5,148 174% 2,184 5,148
40.6015 Personnel:Salaries Standby 10,568 10,184 10,184 9,817 (368) 96% 10,795 110% 978 610
40.6020 Personnel:Salaries Overtime 7,760 6,051 6,051 6,356 304 105% 10,700 168% 4,345 4,649
40.6025 Personnel:Salaries Sick Leave 2,786 2,919 2,919 2,330 (588) 80% 502 22% (1,828) (2,417)
40.6036 Personnel:Supplements 14,670 15,488 15,488 9,778 (5,710) 63% 11,734 120% 1,956 (3,754)
40.6050 Personnel:Service Pay-Longevit 961 1,161 1,161 929 (231) 80% 783 84% (146) (378)
Total Salaries & Wages $ 277,046 $ 303,716 $ 303,716 276,759 $ (26,957) 91% $ 324,819 117% $ 48,060 $ 21,103
40.6027 Personnel:Pre-employment Screening - - - 281 281 0% 100 36% (181) 100
40.6028 Personnel:Recruiting Costs - - - 455 455 0% 500 110% 45 500
40.6030 Personnel:FICA(SS) & MediCare 19,802 22,475 22,475 20,309 (2,166) 90% 24,219 119% 3,910 1,744
40.6031 Personnel: SUTA Taxes 1,023 1,174 1,174 48 (1,126) 4% 42 87% (6) (1,132)
40.6042 Personnel:ER-Life/AD&D Ins 128 126 126 104 (22) 82% 106 102% 3 (20)
40.6045 Personnel:TMRS 25,472 66,446 66,446 60,088 (6,357) 90% 70,853 118% 10,765 4,408
40.6046 Personnel:ER Long Term Disab 751 832 832 691 (141) 83% 876 127% 185 44
40.6047 Personnel:Employee Health Ins 37,245 42,911 42,749 32,107 (10,642) 75% 43,638 136% 11,531 889
40.6048 Personnel:HSA/HRA 4,414 4,683 4,683 5,124 441 109% 6,389 125% 1,264 1,705
40.6049 Personnel:ER Short Term Disab 525 618 618 494 (124) 80% 600 121% 106 (18)
40.6099 Personnel:TMRS OPEB Supplemental Exp 1,688 1,000 1,000 1,000 - 100% 1,000 100% - -
Total Taxes & Benefits $ 91,048 $ 140,266 $ 140,104 120,702 $ (19,402) 86% $ 148,323 123% $ 27,621 $ 8,219
40.6100 Training & Travel 2,958 11,601 11,601 9,606 (1,996) 83% 10,034 104% 428 (1,568)
Total Training & Travel $ 2,958 $ 11,601 $ 11,601 9,606 $ (1,996) 83% $ 10,034 104% $ 428 $ (1,568)
