Loading...
05. Draft 2025 Sewer Budget1 Staff Report Date of Meeting: October 30, 2024, City Council Meeting To: Committee Members From: Kyle Morell, City Administrator Re: Draft Proposed 2025 Sewer Budgets ______________________________________________________________________________ The proposed 2025 sewer budgets are attached. In 2024, we worked to separate the revenues and expenses for the Bliss and Anderson Erickson systems. This separation now shows the City with three separate sewer funds. Bliss Fund This fund has 79 users. Its total projected expenses are $150,959. Engineering Fees and Other Professional Services have been increased to reflect the amounts actually spent. Depreciation has been reduced to reflect only the equipment in the Bliss system. User fees have been increased by 25% to cover expenses. Uptown Fund This system has nine users, two of whom are the city. Expenses are projected at $42,685, and revenues are projected at $28,050. This is based on a 25% increase in user fees. Usage increased in the third quarter of 2024, perhaps due to the Café reopening. Hopefully, this trend continues. I do not believe we can increase user fees more than we are projecting. The fund will have to operate in a deficit for an additional year. Anderson Erickson Fund 2024 is the first year we separated expenses for the A&E system. Total expenses are projected at $51,154. Depreciation has been divided between the two systems. We have also added expenses related to the pumping or residential tanks. User fees on this system will increase by 10% to cover the cost of operations. 10/25/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 2024 Budget 7/31/2024 2025 Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A 79 Users BLISS SEWER FUND REVENUES Revenues 602-43210-31951 Special Assessments Principal 2,887$ -$ -$ 2,652$ -$ 602-43210-31952 SA Penalties & Interest 624$ 579$ 403$ 420$ 318$ 400$ 602-43210-33422 Other State Grants & Aids 25$ 74$ 20$ -$ -$ -$ 602-43210-34401 Sewer User Fees 98,531$ 106,717$ 139,546$ 125,230$ 51,750$ 152,311$ 25% increase - $160.67 per month 602-43210-34402 Sewer Connection Fee 8,000$ 8,000$ 8,000$ -$ -$ -$ 602-43210-36100 Special Assessments -$ -$ 47$ -$ 602-43210-36102 Penalties & Interest 183$ -$ 82$ -$ 602-43210-36210 Interest Income 181$ 301$ 1,380$ 210$ -$ 200$ 602-43210-36250 Misc. Refund -$ -$ -$ -$ 602-43210-39200 Interfund Tranfers In -$ -$ -$ -$ Total Bliss Sewer Fund Revenues 107,361$ 118,557$ 149,532$ 125,860$ 54,849$ 152,911$ Expenditures BLISS SEWER FUND EXPENDITURES E 602-43210-101 Regular Wages & Salaries602-43210-101 Regular Wages & Salaries 11,014$ 21,714$ 20,576$ 17,458$ 11,664$ 18,119$ E 602-43210-120 Pension Expense602-43210-120 Pension Expense (1,438)$ (693)$ 7,430$ -$ -$ -$ E 602-43210-121 PERA Coord. Employer Contribu.602-43210-121 PERA Coord. Employer Contribu. 806$ 1,629$ 1,542$ 1,309$ 874$ 1,359$ E 602-43210-122 FICA Employer Contribution602-43210-122 FICA Employer Contribution 684$ 1,284$ 1,216$ 1,082$ 680$ 1,123$ E 602-43210-126 MEDICARE Employer Contribution602-43210-126 MEDICARE Employer Contribution 156$ 299$ 284$ 253$ 174$ 263$ E 602-43210-131 Employer Paid Health602-43210-131 Employer Paid Health -$ -$ -$ -$ -$ -$ E 602-43210-210 Operating Supplies602-43210-151 Worker s Comp Insurance Prem 422$ 1,215$ 736$ 525$ 783$ 800$ E 602-43210-240 Small Tools and Minor Equip602-43210-200 Office Supplies 109$ 128$ 48$ 91$ 102$ 200$ E 602-43210-303 Engineering Fees602-43210-210 Operating Supplies 558$ 680$ 1,823$ 700$ 19$ 1,000$ Daily use items, hardwares, misc. items E 602-43210-304 Legal Services602-43210-240 Small Tools and Minor Equip -$ 217$ -$ 420$ -$ 500$ Hand tools, septic/water sample tools E 602-43210-308 Other Professional Services602-43210-303 Engineering Fees 13,277$ (1,538)$ 1,409$ 8,880$ 68,017$ 12,000$ 35% increase E 602-43210-309 Software Support & Maintenance602-43210-304 Legal Services -$ 6,000$ 18$ -$ -$ E 602-43210-317 Employee Training602-43210-308 Other Professional Services 3,376$ 5,814$ 7,773$ 3,500$ 13,565$ 20,000$ Water/Wastewater analytical testing, Lobbying E 602-43210-321 Telephone602-43210-309 Software Support & Maintenance 716$ 756$ 529$ 910$ -$ 1,745$ SCADA & Utility Billing E 602-43210-322 Postage 602-43210-317 Employee Training 868$ 925$ 336$ 980$ 598$ 1,400$ Wastewater training E 602-43210-331 Travel Expenses602-43210-321 Telephone 2,413$ 1,751$ 2,656$ 1,750$ 1,194$ 1,750$ SCADA dialers E 602-43210-334 Licenses & Permits602-43210-322 Postage -$ 200$ 200$ 420$ -$ 500$ E 602-43210-361 Liability/Property Ins602-43210-331 Travel Expenses 8$ 158$ 633$ 525$ 78$ 750$ E 602-43210-381 Utilities-Electric & Gas602-43210-334 Licenses & Permits 1,180$ 824$ 729$ 1,400$ 505$ 1,500$ Wastewater Certification/Permit Renewal E 602-43210-385 Sewer Pumping & Maintenance602-43210-361 Liability/Property Ins 1,039$ 1,003$ 3,449$ 764$ 2,383$ -$ 5% increase E 602-43210-386 Operation & Maintenance602-43210-381 Utilities-Electric & Gas 1,862$ 3,473$ 3,936$ 2,100$ 563$ 2,750$ E 602-43210-404 Repair Machinery/Equipment602-43210-385 Sewer Pumping & Maintenance 5,364$ 11,410$ 4,695$ 14,000$ 1,245$ 15,000$ Residential holding tank pumping E 602-43210-413 Equipment Rental602-43210-386 Operation & Maintenance 1,574$ 2,888$ 2,639$ 3,500$ -$ 3,500$ E 602-43210-420 Depreciation Expense602-43210-404 Repair Machinery/Equipment 4,375$ 5,857$ 12,101$ 11,200$ 795$ 12,000$ Pump and control repair/replacement E 602-43210-438 Misc. Contractual602-43210-413 Equipment Rental -$ -$ -$ 700$ -$ 700$ E 602-43210-439 Refunds Issued602-43210-420 Depreciation Expense 48,667$ 50,174$ 50,428$ 40,600$ -$ 40,000$ approximate E 602-43210-530 Capital Impr Other Than Bldgs602-43210-438 Misc. Contractual 3,775$ 2,550$ 2,660$ 7,000$ 765$ 7,000$ Emergency or additional holding tank pumping and maintenance, Lift station inspection/pump testing E 602-43210-720 Operating Transfers602-43210-439 Refunds Issued -$ -$ -$ -$ 602-43210-530 Capital Impr Other Than Bldgs 3,278$ (8,448)$ 6,930$ -$ 7,000$ Pump replacement 602-43210-720 Operating Transfers 17,584$ -$ Total Bliss Sewer Fund Expenditures 100,803$ 121,995$ 119,398$ 126,997$ 121,587$ 150,959$ Page 21 of 23 10/25/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 2024 Budget 7/31/2024 2025 Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A 9 Users UPTOWN SEWER FUND REVENUES Revenues 612-43210-33422 Other State Grants & Aids 7$ 29$ 1$ -$ -$ -$ 612-43210-34401 Sewer User Fees 15,132$ 17,442$ 22,166$ 22,400$ 7,659$ 28,000$ 25% increase 612-43210-34402 Sewer Connection Fee -$ -$ -$ 612-43210-36210 Interest Income 64$ 55$ 326$ 50$ -$ 50.00$ 612-43210-36250 Misc. Refund -$ -$ -$ 612-43210-39203 Transfer from Other Funds -$ -$ -$ Total Uptown Sewer Fund Revenues 15,203$ 17,526$ 22,493$ 22,450$ 7,659$ 28,050$ UPTOWN SEWER FUND EXPENDITURES Expenditures 612-43210-101 Regular Wages & Salaries 3,673$ 9,282$ 8,559$ 10,725$ 4,702$ 11,134$ 612-43210-120 Pension Expense (630)$ 1,164$ 3,619$ -$ -$ -$ 612-43210-121 PERA Coord. Employer Contribu. 259$ 697$ 642$ 804$ 352$ 835$ 612-43210-122 FICA Employer Contribution 219$ 550$ 505$ 665$ 273$ 690$ 612-43210-126 MEDICARE Employer Contribution 50$ 126$ 118$ 156$ 70$ 161$ 612-43210-151 Worker s Comp Insurance Prem 218$ 304$ 316$ 300$ 522$ 550$ 612-43210-200 Office Supplies 4$ -$ -$ 100$ -$ 100$ billing 612-43210-210 Operating Supplies -$ 500$ 320$ 500$ -$ 500$ Daily use items, hardwares, misc. items 612-43210-221 Equipment Parts -$ -$ -$ 500$ -$ 500$ 612-43210-303 Engineering Fees 7,272$ -$ -$ 630$ -$ 1,000$ 5% increase 612-43210-308 Other Professional Services 192$ 884$ 733$ 750$ 310$ 900$ Wastewater Analytical testing 612-43210-309 Software Support & Maintenance 80$ 84$ 84$ 84$ -$ 87$ 612-43210-317 Employee Training 275$ -$ -$ 200$ 1,138$ 200$ 612-43210-319 Other Services -$ -$ -$ 1,500$ -$ 1,500$ 612-43210-322 Postage 18$ -$ -$ -$ -$ 100$ 612-43210-334 Licenses & Permits 209$ 217$ 247$ 250$ 231$ 250$ 612-43210-361 Liability/Property Ins 283$ 334$ 478$ 351$ 464$ 487$ 5% increase 612-43210-381 Utilities-Electric & Gas 522$ 697$ 863$ 1,000$ 265$ 1,000$ 612-43210-385 Sewer Pumping & Maintenance (260)$ 327$ 1,800$ 1,500$ -$ 1,250$ 612-43210-386 Operation & Maintenance -$ 462$ -$ 1,000$ -$ 1,000$ 612-43210-404 Repair Machinery/Equipment 767$ 465$ -$ 2,000$ -$ 1,500$ 612-43210-420 Depreciation Expense 4,876$ 4,877$ 4,876$ 4,900$ -$ 4,900$ 612-43210-438 Misc. Contractual 100$ 548$ 140$ 1,500$ 449$ 1,500$ Lift Station Inspection/Pump Testing 612-43210-530 Capital Impr Other Than Bldgs 1,456$ -$ -$ 9,900$ 9,900$ Pump Replacement 612-43210-570 Office Equipment -$ -$ -$ -$ 612-43210-720 Operating Transfers -$ -$ 2,640$ 2,640$ Total Uptown Sewer Fund Expenditures 19,582$ 21,516$ 23,299$ 41,955$ 8,774$ 42,685$ Page 22 of 23 10/25/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 2024 Budget 7/31/2024 2025 Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A 33 Users ANDERSON-ERICKSON SEWER FUND REVENUES Revenues 624-43210-31951 Special Assessments Principal 2,887$ -$ -$ 624-43210-31952 SA Penalties & Interest 624$ 579$ 180$ 200$ 624-43210-33422 Other State Grants & Aids 25$ 74$ -$ -$ 624-43210-34401 Sewer User Fees 98,531$ 106,717$ 53,670$ 21,921$ 55,999$ 10% increase 624-43210-34402 Sewer Connection Fee 8,000$ 8,000$ -$ -$ -$ 624-43210-36100 Special Assessments -$ -$ 624-43210-36102 Penalties & Interest -$ 30$ -$ 624-43210-36210 Interest Income 181$ 301$ 90$ 100$ 624-43210-36250 Misc. Refund -$ -$ 624-43210-39200 Interfund Tranfers In -$ 17,584$ -$ Total Anderson-Erickson Sewer Fund Revenues 107,361$ 118,557$ -$ 53,940$ 39,535$ 56,299$ Expenditures ANDERSON-ERICKSON SEWER FUND EXPENDITURES 624-43210-101 Regular Wages & Salaries -$ 7,482$ -$ 7,765$ 624-43210-121 PERA Coord. Employer Contribu. -$ 561$ -$ 582$ 624-43210-122 FICA Employer Contribution -$ 464$ -$ 481$ 624-43210-126 MEDICARE Employer Contribution -$ 108$ -$ 113$ 624-43210-151 Worker s Comp Insurance Prem -$ 225$ -$ -$ 624-43210-200 Office Supplies -$ 39$ -$ $200 624-43210-210 Operating Supplies -$ 300$ -$ $300 Daily use items, hardwares, misc. items 624-43210-240 Small Tools and Minor Equip -$ 180$ 44$ $200 Hand tools, septic/water sample tools 624-43210-303 Engineering Fees 320$ -$ -$ $4,000 5% increase 624-43210-304 Legal Services -$ -$ -$ $0 624-43210-308 Other Professional Services -$ 1,500$ -$ $1,500 Water/Wastewater analytical testing 624-43210-309 Software Support & Maintenance -$ 390$ 310$ $634 SCADA & Utility Billing 624-43210-317 Employee Training 227$ 420$ -$ $400 Wastewater training 624-43210-321 Telephone -$ 750$ 109$ $750 SCADA dialers 624-43210-322 Postage 253$ 180$ 425$ $200 624-43210-331 Travel Expenses 80$ 225$ -$ $225 624-43210-334 Licenses & Permits -$ 600$ 78$ $750 Wastewater Certification/Permit Renewal 624-43210-361 Liability/Property Ins -$ -$ 231$ $254 10% increase 624-43210-381 Utilities-Electric & Gas -$ 900$ 985$ $1,000 624-43210-385 Sewer Pumping & Maintenance 43$ 6,000$ 283$ $6,000 Residential holding tank pumping 624-43210-386 Operation & Maintenance -$ 1,500$ -$ $1,500 624-43210-404 Repair Machinery/Equipment -$ 4,800$ -$ $4,000 Pump and control repair/replacement 624-43210-413 Equipment Rental 408$ 300$ 230$ $300 624-43210-420 Depreciation Expense -$ 17,400$ -$ $10,000 approximate 624-43210-438 Misc. Contractual -$ 3,000$ -$ $4,000 Emergency or additional holding tank pumping and maintenance, Lift station inspection/pump testing 624-43210-439 Refunds Issued -$ 4,368$ $3,000 624-43210-530 Capital Impr Other Than Bldgs 2,990$ 2,970$ $3,000 Pump replacement 624-43210-570 Office Equipment -$ -$ 624-43210-720 Operating Transfers -$ -$ Total Anderson-Erickson Sewer Fund Expenditures -$ -$ 4,320$ 50,294$ 7,064$ 51,154$ Page 23 of 23