Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
08.e1 Staff Report - 2024 Sewer Budgets
Staff Report Date of Meeting: October 17, 2023 For: Honorable Mayor and Council From: Kyle Morell, City Administrator Subject: 2024 Sewer Budgets Background: The City hired Ehlers to review and assist with future planning for its sewer funds in 2020. The result was a rate study that established rates for both sewer funds the next decade. Current Proposal: The currently proposed 2024 sewer budgets call for a 25% increase in the rate from 2023. Despite this significant increase, neither fund is projected to make money in 2024. A deeper dive into the funds is warranted, and perhaps a review of the rate study by Ehlers to make sure we are still hitting our targets. No action is needed at this time. The budgets are presented for your review. Attachments: 2024 Sewer Budgets 2020 Rate Study City of Scandia 2024 Proposed Budget 2020 2021 2022 3-Yr Avg 2023 Budget 2023 BUDGET 10/1/2023 2023 Budget 2024 Actual Actual Actual Actual Proposed AMENDED YTD Actual Projected Budget BIG MARINE SEWER FUND REVENUES Revenues 602-43210-31951 Special Assessments Principal -$ 2,887$ 962$ 2,065.94$ 602-43210-31952 SA Penalties & Interest 3,575$ 624$ 579$ 1,593$ 600$ 257.92$ 600$ 602-43210-33422 Other State Grants & Aids 47,163$ 25$ 74$ 15,754$ 602-43210-34401 Sewer User Fees 74,387$ 98,531$ 106,717$ 93,212$ 140,700$ 72,340.60$ 172,775$ 602-43210-34402 Sewer Connection Fee 8,000$ 8,000$ 5,333$ -$ 8,000.00$ -$ 602-43210-36100 Special Assessments -$ -$ 602.43210.36102 Penalties and I 68.03$ 602-43210-36210 Interest Income -$ 181$ 301$ 161$ 400$ 300$ 602-43210-36250 Misc. Refund 550$ 183$ 602-43210-39200 Interfund Tranfers In -$ -$ Total Big Marine Sewer Fund Revenues 125,676$ 107,361$ 118,557$ 117,198$ 141,700$ -$ 82,732.49$ 173,675$ Expenditures BIG MARINE SEWER FUND EXPENDITURES 602-43210-101 Regular Wages & Salaries 18,626$ 11,014$ 21,714$ 17,118$ 22,500$ 15,321.76$ 23,303$ 602-43210-102 OT Regular Wages 106$ 35$ -$ 602-43210-120 Pension Expense -$ (1,438)$ (693)$ (710)$ -$ -$ 602-43210-121 PERA Coord. Employer Contribu. 1,404$ 806$ 1,629$ 1,280$ 1,700$ 1,146.93$ 1,748$ 602-43210-122 FICA Employer Contribution 1,090$ 684$ 1,284$ 1,019$ 1,400$ 892.98$ 1,445$ 602-43210-126 MEDICARE Employer Contribution 260$ 156$ 299$ 238$ 300$ 223.34$ 340$ 602-43210-131 Employer Paid Health -$ -$ -$ -$ -$ -$ 602-43210-134 Employer Paid Life -$ -$ -$ -$ -$ -$ 602-43210-135 Employer Paid Disability -$ -$ -$ -$ -$ 602-43210-151 Worker s Comp Insurance Prem 854$ 422$ 1,215$ 830$ 700$ 736.40$ 750$ 602-43210-200 Office Supplies -$ 109$ 128$ 79$ 200$ -$ 130$ 602-43210-210 Operating Supplies 752$ 558$ 680$ 664$ 2,500$ 1,485.64$ 1,000$ Daily use items, hardwares, misc. items 602-43210-240 Small Tools and Minor Equip 113$ -$ 217$ 110$ 600$ -$ 600$ Hand tools, septic/water sample tools 602-43210-303 Engineering Fees 12,082$ 13,277$ (1,538)$ 7,940$ 10,500$ 61,200.25$ 11,025$ 5% increase 602-43210-304 Legal Services -$ -$ 6,000$ 2,000$ 18.00$ -$ 602-43210-308 Other Professional Services 2,651$ 3,376$ 5,814$ 3,947$ 2,500$ 4,798.00$ 5,000$ Water/Wastewater analytical testing 602-43210-309 Software Support & Maintenance 716$ 716$ 756$ 729$ 1,300$ -$ 1,300$ SCADA 602-43210-317 Employee Training 508$ 868$ 925$ 767$ 1,400$ -$ 1,400$ Wastewater training 602-43210-321 Telephone 2,061$ 2,413$ 1,751$ 2,075$ 2,400$ 2,016.55$ 2,500$ SCADA dialers 602-43210-322 Postage 247$ -$ 200$ 149$ 600$ -$ 600$ 602-43210-331 Travel Expenses -$ 8$ 158$ 55$ 200$ 632.55$ 750$ 602-43210-334 Licenses & Permits 754$ 1,180$ 824$ 919$ 1,600$ 729.00$ 2,000$ Wastewater Certification/Permit Renewal 602-43210-361 Liability/Property Ins 1,052$ 1,039$ 1,003$ 1,031$ 3,000$ 3,449.06$ 3,622$ 5% increase 602-43210-381 Utilities-Electric & Gas 1,620$ 1,862$ 3,473$ 2,318$ 2,500$ (4,268.96)$ 5,000$ 3,000$ 602-43210-385 Sewer Pumping & Maintenance 10,000$ 5,364$ 11,410$ 8,925$ 15,000$ 3,770.22$ 20,000$ Residential holding tank pumping 602-43210-386 Operation & Maintenance 2,627$ 1,574$ 2,888$ 2,363$ 5,000$ 2,139.00$ 5,000$ 602-43210-404 Repair Machinery/Equipment 16,180$ 4,375$ 5,857$ 8,804$ 16,000$ 12,100.90$ 16,000$ Pump and control repair/replacement 602-43210-413 Equipment Rental -$ -$ -$ -$ 400$ 1,000$ 602-43210-420 Depreciation Expense -$ 48,667$ 50,174$ 32,947$ 54,300$ 58,000$ approximate 602-43210-438 Misc. Contractual 7,410$ 3,775$ 2,550$ 4,578$ 10,000$ 280.00$ 10,000$ Emergency or additional holding tank pumping and maintenance, Lift station inspection/pump testing 602-43210-439 Refunds Issued -$ -$ -$ 602-43210-530 Capital Impr Other Than Bldgs 103,000$ 3,278$ 35,426$ 9,800$ 9,900$ Pump replacement 602-43210-570 Office Equipment -$ -$ -$ 602-43210-720 Operating Transfers -$ -$ Total Big Marine Sewer Fund Expenditures 184,113$ 100,803$ 121,995$ 135,637$ 166,400$ -$ 106,671.62$ 180,412$ Revenues / Expenses (58,437.79)$ 6,558.70$ (3,437.59)$ (18,438.90)$ (24,700.00)$ -$ (23,939.13)$ -$ (6,737.44)$ UPTOWN SEWER FUND REVENUES Revenues 612-43210-33422 Other State Grants & Aids 7$ 29$ 12$ -$ 612-43210-34401 Sewer User Fees 6,460$ 15,132$ 17,442$ 13,012$ 22,300$ 10,408.64$ 27,873.00$ 25% increase over 2023 612-43210-34402 Sewer Connection Fee -$ -$ 612-43210-36210 Interest Income 64$ 55$ 40$ 200$ -$ 50.00$ 612-43210-36250 Misc. Refund -$ -$ 612-43210-39203 Transfer from Other Funds -$ -$ Total Uptown Sewer Fund Revenues 6,460$ 15,203$ 17,526$ 13,063$ 22,500$ -$ 10,408.64$ 27,923.00$ UPTOWN SEWER FUND EXPENDITURES Expenditures 612-43210-101 Regular Wages & Salaries 5,020$ 3,673$ 9,282$ 5,991$ 9,700$ 6,442.64$ 10,037$ 612-43210-102 OT Regular Wages -$ -$ -$ -$ 612-43210-120 Pension Expense -$ (630)$ 1,164$ 178$ -$ -$ 612-43210-121 PERA Coord. Employer Contribu. 377$ 259$ 697$ 444$ 700$ 482.40$ 753$ 612-43210-122 FICA Employer Contribution 290$ 219$ 550$ 353$ 600$ 375.33$ 622$ 612-43210-126 MEDICARE Employer Contribution 70$ 50$ 126$ 82$ 100$ 97.79$ 146$ 612-43210-131 Employer Paid Health -$ -$ -$ -$ -$ 612-43210-134 Employer Paid Life -$ -$ -$ -$ -$ 612-43210-135 Employer Paid Disability -$ -$ -$ -$ -$ 612-43210-151 Worker s Comp Insurance Prem 95$ 218$ 304$ 205$ 200$ 315.60$ 300$ 612-43210-200 Office Supplies -$ 4$ -$ 1$ 100$ -$ 100$ billing 612-43210-210 Operating Supplies -$ -$ 500$ 167$ 300$ -$ 500$ Daily use items, hardwares, misc. items 612-43210-221 Equipment Parts 139$ -$ -$ 46$ 300$ -$ 500$ 612-43210-303 Engineering Fees 600$ 7,272$ -$ 2,624$ 1,000$ -$ 1,050$ 5% increase 612-43210-308 Other Professional Services 519$ 192$ 884$ 531$ 500$ 733.00$ 1,400$ 750$ Wastewater Analytical testing 612-43210-309 Software Support & Maintenance 80$ 80$ 84$ 81$ -$ 84$ 612-43210-317 Employee Training 114$ 275$ -$ 130$ -$ 200$ 612-43210-319 Other Services -$ -$ -$ -$ -$ 1,500$ 612-43210-322 Postage -$ 18$ -$ 6$ -$ 612-43210-334 Licenses & Permits 259$ 209$ 217$ 228$ 224.00$ 300$ 612-43210-361 Liability/Property Ins 320$ 283$ 334$ 312$ 400$ 477.82$ 502$ 5% increase 612-43210-381 Utilities-Electric & Gas 482$ 522$ 697$ 567$ 1,700$ 579.08$ 1,500$ 612-43210-385 Sewer Pumping & Maintenance -$ (260)$ 327$ 22$ 1,500$ 1,500.00$ 1,500$ 612-43210-386 Operation & Maintenance -$ -$ 462$ 154$ 700$ -$ 1,000$ 612-43210-404 Repair Machinery/Equipment -$ 767$ 465$ 411$ 2,000$ -$ 2,000$ 612-43210-420 Depreciation Expense -$ 4,876$ 4,877$ 3,251$ 5,100$ -$ 4,900$ 612-43210-438 Misc. Contractual -$ 100$ 548$ 216$ 1,300$ 140.00$ 1,500$ Lift Station Inspection/Pump Testing 612-43210-530 Capital Impr Other Than Bldgs -$ 1,456$ -$ 485$ 4,500$ -$ 9,900$ Pump Replacement 612-43210-570 Office Equipment -$ -$ -$ -$ 612-43210-720 Operating Transfers -$ -$ -$ -$ 2,640$ Reimbursement to 401 for 2013 loan Total Uptown Sewer Fund Expenditures 8,363$ 19,582$ 21,516$ 16,487$ 30,700$ -$ 11,367.66$ 42,284$ Revenues / Expenses (1,903.21)$ (4,379.01)$ (3,990.23)$ (3,424.15)$ (8,200.00)$ -$ (959.02)$ -$ (14,360.69)$