Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
4. 2023 Draft Sewer Budget 10122022 - Read Orientation Small File
DRAFT PROPOSED 2022 SEWER BUDGET Presented at the Sewer Advisory Committee 10/12/2022 SUMMARY OF DISCUSSION •Discussion of Uptown Sewer Budget and Projections •Highlight of Capital Improvements •Discussion on projected Sewer Rates for Uptown –Base and Consumption •Discussion of Big Marine Sewer Budget •Highlight of Capital Improvements •Discussion of debt financing needs for the Bliss Waste Water Treatment Plant Nutrient Treatment Upgrade project. •Discussion on projected Sewer Rates for Uptown –Consumption Presented 10/12/2022 Sewer Advisory Committee Page 2 of 39 HIGHLIGHTS OF 2023 UPTOWN SEWER BUDGET •The Uptown Sewer System serves a limited number of commercial and institutional buildings in the Scandia Village Center. •The System has 9 costumers, 2 of which are the City, and the serves a little over a dozen businesses. •Budget puts fund into balance within 2 years, but includes 40% rate increase (see study) for a projected 26.2% increase in fee revenue for a difference of $7,200. •Anticipated 2023 budgeted expenses are 51.5% lower over prior PY due to an error in budgeted depreciation for a difference of $39,600. •Can be difficult to project system use as commercial and institutional uses in the area have varied use over only a small group of customers. Presented 10/12/2022 Sewer Advisory Committee Page 3 of 39 612 Uptown Sewer Fund Source FY '23 FY '24 FY '25 FY '26 FY '27 14,223 9,973 570,473 578,373 593,273Beginning Balance Revenues and Other Fund Sources Revenue 24,600 21,400 37,700 45,200 54,3001. Charges for Service 0 0 0 0 02. Special Asssessments 0 0 0 0 03. Intergovernmental/Grants 200 200 400 500 8004. Interest 0 0 0 0 05. Miscellaneous 0 570,000 0 0 06. Arts and Heritage Barn Expansion 24,800 591,600 38,100 45,700 55,100Total 39,023 601,573 608,573 624,073 648,373Total Funds Available 24,800 591,600 38,100 45,700 55,100Total Revenues and Other Fund Sources Expenditures and Uses Capital Projects & Equipment Uptown Sewer (1,000)(2,500)(1,000)(1,000)(30,000)Uptown Lift Station Replacement US-004 (1,000)(1,000)(1,000)(1,000)(1,000)Repairs-TBD (Tanks/Castings/etc)US-009 (2,000)(3,500)(2,000)(2,000)(31,000)Total Other Uses (11,300)(11,500)(11,700)(11,900)(12,100)1. Compensation of Personel (700)(700)(700)(700)(700)2. Materials (3,150)(3,200)(3,300)(3,400)(3,500)3. Professional Services (4,200)(4,300)(4,400)(4,500)(4,600)4. Repair and Maintenance (2,500)(2,600)(2,700)(2,800)(2,900)5. Other (5,200)(5,300)(5,400)(5,500)(5,600)6. Depreciation 0 0 0 0 07. Debt Service (Principal and Interest) (27,050)(27,600)(28,200)(28,800)(29,400)Total (29,050)(31,100)(30,200)(30,800)(60,400)Total Expenditures and Uses 9,973 570,473 578,373 593,273 587,973Ending Balance (4,250)560,500 7,900 14,900 (5,300)Change in Fund Balance Monday, October 10, 2022DRAFT 2023 SEWER CIP Page 4 of 39 Draft 2023 Sewer Budget Sewer Advisory Committee Presented 10/12/2022 Inflation Assumptions 1 Revenue (Non-property tax) 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2 Inflation on rates 5.00%40.00% 25.00% 20.00% 20.00% 20.00% 3 Interest Earnings 1.50%1.50% 1.50% 1.50% 1.50% 1.50% 4 Expenses 3.00% 3.00%3.00% 3.00% 3.00% 3.00% 5 CIP Inflation Factor 0.00% 4.00% 4.00% 4.00% 4.00% 4.00% 2022 2023 2024 2025 2026 2027 Budget Proposed Projected REVENUE 6 Charges for services 19,500 24,600 31,400 37,700 45,200 54,300 7Special assessments 0 00000 8Intergovernmental 0 00000 9 Interest 92 200 200 400 500 800 10 Miscellaneous 0 00000 11 SHA Expansion 0 0 570,000000 12 13 Total Revenue 19,592 24,800 601,600 38,100 45,700 55,100 EXPENSES 14 Wages 10,700 11,300 11,500 11,700 11,900 12,100 15 Materials 500 700 700 700 700 700 16 Professional services 2,250 3,150 3,200 3,300 3,400 3,500 17 Repair and maintenance 3,300 4,200 4,300 4,400 4,500 4,600 18 Other 2,400 2,500 2,600 2,700 2,800 2,900 19 Depreciation 55,100 5,100 5,200 5,300 5,400 5,500 20 Debt service 0 00000 21 22 Total Expenses 74,250 26,950 27,500 28,100 28,700 29,300 23 Revenue Over / (Under) Expenses (54,658) (2,150)574,100 10,000 17,000 25,800 OTHER FINANCING SOURCES / (USES) 24 Bond Proceeds 0 00000 25Transfers In 0 00000 26 Purchase of capital assets (2,600) (4,900) (566,900) (7,600) (3,000) (39,900) 27Advance to other fund 0 00000 28Transfers Out-0 00000 29 Total Other Sources / (Uses)(2,600) (4,900) (566,900) (7,600) (3,000) (39,900) 30 Change in balance sheet 31 Ending Cash 14,233 12,300 24,700 32,400 51,800 43,200 FUND 612 FINANCIAL MANAGEMENT PLAN Uptown Sewer Fund CASH FLOW ANALYSISSewer Advisory Committee Presented 10/12/2022 Draft 2023 Sewer BudgetPage 5 of 39 DRAFT 2023 BudgetActual Budget Actual ProposedTypCode Description2021 2022 6/30/2022 2023 % Bud Diff Notes and Discriptions2023 Draft Proposed Line-Item Budget DetailFUND 612 SEWER - UPTOWN FUNDR 612-31000 Washington Cty. Tax Settlement - - - - R 612-33422 Other State Grants & Aids7 - - - R 612-34105 Sale of Maps and Publications- - - - R 612-34401 Sewer User Fees & Hookup15,132 19,500 2,033 24,600 26.15% See Rate Study for breakdownR 612-36210 Interest Income64 92 -200 117.39%R 612-36250 Misc. Refund- - - - R 612-39203 Transfer from Other Funds- - - - TOTAL 612 REVENUE15,203 19,592 2,033 24,800 26.58%Fund 612 EXPENSESE 612-43210-101 Regular Wages & Salaries3,673 9,300 3,974 9,700 4.30%E 612-43210-102 OT Regular Wages- - - - "E 612-43210-120 Pension Expense(630) - - - "E 612-43210-121 PERA Coord. Employer Contribu.259 700 298 700 0.00% "E 612-43210-122 FICA Employer Contribution219 600 231 600 0.00% "E 612-43210-126 MEDICARE Employer Contribution50 100 58 100 0.00% "E 612-43210-131 Employer Paid Health- - - - "E612-43210-134Employer Paid Life- - - - "E612-43210-135Employer Paid Disability- - - - "E 612-43210-151 Worker s Comp Insurance Prem217 - 295 200 "E 612-43210-200 Office Supplies4 100 -100 0.00%Office staff pulls from when needed for billing, noticesE 612-43210-210 Operating Supplies- 200 -300 50.00%E 612-43210-221 Equipment Parts- 200 -300 50.00%E 612-43210-240 Small Tools and Minor Equip- - - - E 612-43210-303 Engineering Fees7,272 300 -1,000 233.33% annual drawdown testingE 612-43210-304 Legal Services- - - - E612-43210-308 Other Professional Services192 400 162 500 25.00% PACE testingE 612-43210-309 Software Support & Maintenance80 - - - E 612-43210-311 Contract Permit Inspections- - - - Sewer Advisory CommitteePresented 10/12/2022Page 6 of 39 DRAFT 2023 BudgetActual Budget Actual ProposedTypCode Description2021 2022 6/30/2022 2023 % Bud Diff Notes and Discriptions2023 Draft Proposed Line-Item Budget DetailE 612-43210-317 Employee Training275 350 -350 0.00%E 612-43210-319 Other Services- - - - E 612-43210-322 Postage18 - - - E 612-43210-334 Licenses & Permits209 400 217 400 0.00%E 612-43210-351 Legal Notices Publishing- - - - E 612-43210-353 Sales& Use Tax- - - - E 612-43210-361 Liability/Property Ins283 300 334 400 33.33%E 612-43210-381 Utilities-Electric & Gas522 1,700 218 1,700 0.00%E 612-43210-385 Sewer Pumping & Maintenance(260) 1,200 327 1,500 25.00%E 612-43210-386 Operation & Maintenance- 600 -700 16.67%E 612-43210-404 Repair Machinery/Equipment767 1,500 -2,000 33.33% Electrician if bad blowerE 612-43210-420 Depreciation Expense4,876 55,100 -5,100 -90.74%E 612-43210-438 Misc. Contractual100 1,200 448 1,300 8.33%E 612-43210-530 Capital Impr Other Than Bldgs1,456 2,600 -10,300 296.15%E 612-43210-570 Office Equipment- - - - E 612-43210-720 Operating Transfers- - - - TOTAL FUND 612 EXPENDITURES19,581 76,850 6,563 37,250 -51.53%NET REVENUE OVER EXPENDITURES(4,378) (57,258) (4,530) (7,350) -87.16%Sewer Advisory CommitteePresented 10/12/2022Page 7 of 39 Draft 2023 Sewer Budget Sewer Advisory Committee Presented 10/12/2022 Inflation Assumptions 5 CIP Inflation Factor 0.00% 4.00% 4.00% 4.00% 4.00% 4.00% 2021 2022 2023 2024 2025 2026 2027 Capital Project Name First Year Costs Projected 32 LS 2022 1,000.00 1,000 - - - - - 33 LS 2023 1,000.00 -1,082 - - - - 34 LS 2024 2,500.00 - - 2,812 - - - 35 LS 2025 1,000.00 - - - 1,170 - - 36 LS 2026 1,000.00 - - - - 1,217 - 37 LS 2027 30,000.00 - - - - -37,960 38 LS 2028 1,000.00 - - - - - - 39 LS 2029 1,000.00 - - - - - - 40 LS 2030 1,000.00 - - - - - - 41 LS 2031 1,000.00 - - - - - - 42 Control panel 2031 50,000.00 - - - - - - 43 Drainfield LS 2022 500.00 500 - - - - - 44 Drainfield LS 2023 2,500.00 -2,704 - - - - 45 Drainfield LS 2024 500.00 - - 562 - - - 46 Drainfield LS 2025 500.00 - - - 585 - - 47 Drainfield LS 2026 500.00 - - - - 608 - 48 Drainfield LS 2027 500.00 - - - - -633 49 Drainfield LS 2028 2,500.00 - - - - - - 50 Drainfield LS 2029 500.00 - - - - - - 51 Drainfield LS 2030 500.00 - - - - - - 52 Drainfield LS 2031 500.00 - - - - - - 53 Blower replacement 2021 4,000.00 - - - - - - 54 Blower replacement 2025 4,000.00 - - - 4,679 - - 55 Blower replacement 2031 4,000.00 - - - - - - 56 Pumping 2022 1,000.00 1,000 - - - - - 57 Pumping 2023 1,000.00 -1,082 - - - - 58 Pumping 2024 1,000.00 - - 1,125 - - - 59 Pumping 2025 1,000.00 - - - 1,170 - - 60 Pumping 2026 1,000.00 - - - - 1,217 - 61 Pumping 2027 1,000.00 - - - - -1,265 62 Pumping 2028 1,000.00 - - - - - - 63 Pumping 2029 1,000.00 - - - - - - 64 Pumping 2030 1,000.00 - - - - - - 65 Pumping 2031 1,000.00 - - - - - - 66 Repairs 2031 50,000 - - - - - - 67 Drainfield Expansion (2024) SHA Addition 2024 500,000 - - 562,432 - - - 77 78 Total Capital Projects 671,500 2,500 4,867 566,931 7,604 3,042 39,858 PROJECTED NEW DEBT TERMS 79 Par Amount (Line 14)- - - - - - 80 Number of Years 10 10 10 10 10 10 81 Interest Rate 2.00%2.50% 3.00% 3.00% 3.00% 3.00% 82 New Debt Utility Rate Levy 0 00000 FUND 612 FINANCIAL MANAGEMENT PLAN Uptown Sewer Fund CAPITAL PROJECTS & DEBT LEVYProject Sewer Advisory Committee Presented 10/12/2022 Draft 2023 Sewer BudgetPage 8 of 39 DRAFT 2013 SEWER BUDGETPresented 10/12/2022Sewer Advisory CommitteeScandia Utilities Utility Rate Study2022202320242025202620275.00% 40.00% 25.00% 20.00% 20.00% 20.00%Base ChargeAnnual367.50 514.50 643.13 771.75 926.10 1,111.32 Quarterly91.88 128.63 160.78 192.94 231.53 277.83 % Change from PY5.00% 40.00%25.00% 20.00% 20.00% 20.00%Base Charge IncreaseAnnual17.50 147.00 128.63 128.63 154.35 185.22 Quarterly4.38 36.75 32.16 32.16 38.59 46.31 Volume Charge per 1,000 Gallons52.29 73.21 91.51 109.81 131.77 158.12 % Change from PY5.00% 40.00% 25.00% 20.00% 20.00% 20.00%Change from PY2.49 20.92 18.30 18.30 21.96 26.35 Total Units of Consumption (Est.) per Year273,000 278,460 284,029 289,710 295,504 301,414 Estimated Total Consump RevenueAnnual$14,275.17 $19,985.24 $24,981.55$29,977.86 $35,973.43 $43,168.11Average per billAnnual$1,586.13 $2,220.58 $2,498.15 $2,997.79 $3,597.34 $4,316.8112 month Avg.$132.18 $185.05 $208.18 $249.82 $299.78 $359.73# of Customers9910101010Total Year Revenue Estimate$17,582.67 $24,615.74 $31,412.80 $37,695.36 $45,234.43 $54,281.31Rounded Total Yr Est for Budget17,600.00 24,600.00 31,400.00 37,700.00 45,200.00 54,300.00 202120202019201820172016Total Consumption for the Yr per gallon 213,950 270,660 367,260 360,250 327,740 457,280 Yearly Consumption Revenue $10,553.10 $12,751.02 $17,261.22 $14,508.84 $5,037.87 $6,987.24Consumption Averages per yr6 months332,856.67 2021-2019283,956.67 2019-2017351,750.00 Historic Uptown Sewer Total Consumption DataUptown Sewer System Projected Utility RatesPresented 10/12/2022Sewer Advisory CommitteeDRAFT 2023 SEWER BUDGETPage 9 of 39 DRAFT 2013 SEWER BUDGETPresented 10/12/2022Sewer Advisory CommitteeScandia Utilities Utility Rate Study202220232024202520262027Rev over Exp -$62,970.00 $30,300.00 $5,300.00 $48,900.00 $79,100.00 $130,300.00602 Big Marine Sewer Fund Projected Revenues/Expenses$0.00$200,000.00$400,000.00$600,000.00$800,000.00$1,000,000.00$1,200,000.002022 2023 2024 2025 2026 2027Presented 10/12/2022Sewer Advisory CommitteeDRAFT 2023 SEWER BUDGETPage 10 of 39 Capital Improvement Program City of Scandia, Minnesota Contact Public Works Director FY '23 FY '27thru Department Uptown Sewer Description Replace pump every five year (2012 new) Project #US-003 Priority 2: High priority Justification End of useful life Budget Impact/Other Useful Life VariableProject Name Drain field Blower Category Wastewater Type Replacement Total Project Cost:$11,000 TotalFY '23 FY '24 FY '25 FY '26 FY '27Expenditures 4,0004,000Equip/Vehicles/Furnishings 4,000 4,000Total Prior 3,000 Total Future 4,000 Total Prior 7,000 Total Future 3,000 Total DRAFT 2023 SEWER CIPSewer Advisory Committee Presented Wednesday, October 12, 2022Page 11 of 39 Capital Improvement Program City of Scandia, Minnesota Contact Public Works Director FY '23 FY '27thru Department Uptown Sewer Description Uptown Drainfield pump 1 Hydromatic Project #US-004 Priority 2: High priority Justification end of usefeul life Budget Impact/Other Useful Life VariableProject Name Uptown Lift Station Replacement Category Wastewater Type Replacement Total Project Cost:$40,500 TotalFY '23 FY '24 FY '25 FY '26 FY '27Expenditures 35,5001,000 2,500 1,000 1,000 30,000Equip/Vehicles/Furnishings 1,000 2,500 1,000 1,000 30,000 35,500Total Prior 1,000 Total Future 4,000 Total TotalFY '23 FY '24 FY '25 FY '26 FY '27Funding Sources 35,5001,000 2,500 1,000 1,000 30,000612 Uptown Sewer Fund 1,000 2,500 1,000 1,000 30,000 35,500Total Prior 1,000 Total Future 4,000 Total DRAFT 2023 SEWER CIPSewer Advisory Committee Presented Wednesday, October 12, 2022Page 12 of 39 Capital Improvement Program City of Scandia, Minnesota Contact Public Works Director FY '23 FY '27thru Department Uptown Sewer Description Uptown Pump 1 - Goulds WS2012BHF Project #US-006 Priority 2: High priority Justification end of usefeul life Budget Impact/Other Useful Life VariableProject Name Drainfield Lift Station Replacement Category Wastewater Type Replacement Total Project Cost:$9,000 TotalFY '23 FY '24 FY '25 FY '26 FY '27Expenditures 4,5002,500 500 500 500 500Equip/Vehicles/Furnishings 2,500 500 500 500 500 4,500Total Prior 500 Total Future 4,000 Total Prior 5,800 Total Future 5,800 Total DRAFT 2023 SEWER CIPSewer Advisory Committee Presented Wednesday, October 12, 2022Page 13 of 39 Capital Improvement Program City of Scandia, Minnesota Contact FY '23 FY '27thru Department Uptown Sewer Description Project #US-009 Priority 2: High priority Justification Budget Impact/Other Useful Life VariableProject Name Repairs-TBD (Tanks/Castings/etc)Category Other Type Maintenance Total Project Cost:$10,000 TotalFY '23 FY '24 FY '25 FY '26 FY '27Expenditures 5,0001,000 1,000 1,000 1,000 1,000Maintenance 1,000 1,000 1,000 1,000 1,000 5,000Total Prior 1,000 Total Future 4,000 Total TotalFY '23 FY '24 FY '25 FY '26 FY '27Funding Sources 5,0001,000 1,000 1,000 1,000 1,000612 Uptown Sewer Fund 1,000 1,000 1,000 1,000 1,000 5,000Total Prior 1,000 Total Future 4,000 Total DRAFT 2023 SEWER CIPSewer Advisory Committee Presented Wednesday, October 12, 2022Page 14 of 39 BIG MARINE SEWER FINANCIAL OBJECTIVES •To Work to thoughtfully consider utility rate impacts on customers while balancing operational and capital needs through the use of forecasting and study. •To build fund balance to address long-term capital and unanticipated system failure and liability. (Just because there is money in the fund should and cannot be the only rational to hold on rate changes. This mentality is what has led to the utility’s financial difficulties.) •Carryout the Bliss Waste Water Nutrient Treatment Project by the close of 2024 (ARPA funds expire at 12/31/2023). The State has project close required by 06/30/2025. Project estimated to be $960k. •Rehabilitation of the Lift Station #2 (the station that feeds to the WWTP) Given the project’s significant projected cost of $350,000, it has been previous included in state bonding requests. Presented 10/12/2022 Sewer Advisory Committee Page 15 of 39 BIG MARINE SEWER FINANCIAL OPTIONS •The City applied to get on the project priority list (PPL) for the state’s water and sewer financing program that receives separate legislative appropriations on a yearly basis. The project remains at a score of 50 without the wastewater infrastructure needs survey (WINS), AKA facilities study, has not been completed. (Lift Station #2 is not included in this request, as it is not part of the MPCA permit conditions.) •Make a second attempt to obtain a infrastructure grant from State Bonding during the 2023 legislative session? (Lobbying efforts were not very fruitful in 2022 legislative session. (Contacts frequently ended back to the low interest loan financing program through the Public Facilities Authority (PFA).) Include Lift Station #2 or not? •Or, seek bond financing? (The current market still has reasonable rates, though not as good as pre- interest rate hikes.) Include Lift Station #2 or not? •The current proposal assumes funding for Nitrate will be obtained through bonding or state grant. Presented 10/12/2022 Sewer Advisory Committee Page 16 of 39 HIGHLIGHTS OF THE 2023 BIG MARINE SEWER BUDGET •This budget proposes the Bliss Waste Water Nitrate Treatment Project is completed in 2024. •Loan financing would be considered next year under this plan. Which would provide opportunity to seek state grant assistance through their infrastructure bonding bill or a PFA Loan by ranking on PPL. •Budget includes a 29.98%increase in total revenue of which 99%is utility rate supported for a difference of $32,959. •Expenses went down by 25.8% primarily due to limited scheduled capital improvements for a difference of -$58,162. Most substantial cost increase was for maintenance related to system pumping at approx.. $4,000. •This balanced budget incudes a $20,300 increase in fund balance. •Proposed 25% increase in rates (Base Charge and Energy Adjustments.) Presented 10/12/2022 Sewer Advisory Committee Page 17 of 39 DRAFT 2013 SEWER BUDGETPresented 10/12/2022Sewer Advisory Committee20222023202420252026202715.50% 25.00% 25.00% 25.00% 20.00% 20.00%Base ChargeAnnual$987.28 $1,234.10 $1,542.63$1,928.28 $2,313.94 $2,776.73Quarterly$246.82 $308.53 $385.66 $482.07 $578.48 $694.18% Change from PY15.50% 25.00% 25.00% 25.00% 20.00% 20.00%Increase (change over PY)Annual$132.88 $246.82 $308.53 $385.66 $385.66 $462.79Quarterly$33.12 $61.71 $77.13 $96.41 $96.41 $115.70Energy Adj Charge (Not Utility Rev)Annual$9.24 $11.55 $14.44 $18.05 $21.66 $25.99Quarterly$2.31$2.89$3.61$4.51$5.41$6.50# of Customers115115115115115115Total Year Revenue Estimate113,537.20 141,921.50 177,401.88 221,752.34 266,102.81 319,323.38 Rounded Total Yr Est for Budget113,500.00 141,900.00 177,400.00 221,800.00 266,100.00 319,300.00 * There are 15 shared systems where one user pays electric and the other pays this fee to offset the cost on the neighbor's bill.* Billing is completed quarterly in March, June, September, and December so timing of receipts for Q4 often have receipts collected in the following year + certified arrears paid the following year.Scandia Utilities Utility Rate StudyBig Marine Sewer Projected Utility Rates (No State Bonding)Presented 10/12/2022Sewer Advisory CommitteeDRAFT 2023 SEWER BUDGETPage 18 of 39 DRAFT 2023 Sewer Budget Presented 10/12/2022 Sewer Advisory Committee Inflation Assumptions 1 Revenue (Non-property tax) 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2 Inflation on rates 15.50% 25.00% 25.00% 25.00% 20.00% 20.00% 3 Interest Earnings 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 4 Expenses 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 5 CIP Inflation Factor 0.00% 0.00% 4.00% 4.00% 4.00% 4.00% 2022 2023 2024 2025 2026 2027 Budget Proposed Projected REVENUE 6 Charges for services 109,592 141,900 177,400 221,800 266,100 319,300 7 Special assessments 300 600 600 600 600 600 8Intergovernmental 000000 9 Interest 0 400 800 900 1,000 1,600 10 American Rescue Plan Act 0 456,400 000 11 State bonding 000000 12 Miscellaneous 000000 13 Total Revenue 109,892 142,900 635,200 223,300 267,700 321,500 EXPENSES 14 Wages 25,700 26,600 27,100 27,600 28,200 28,800 15 Materials 5,100 5,400 5,500 5,600 5,700 5,800 16 Professional services 23,000 24,400 24,900 25,400 25,900 26,400 17 Repair and maintenance 32,350 36,400 37,100 37,800 38,600 39,400 18 Other 7,100 9,500 9,700 9,900 10,100 10,300 19 Depreciation Expense 52,200 54,300 55,400 56,500 57,600 58,800 20 Debt service 0 0 0 41,900 41,900 77,900 21 Total Expenses 145,450 156,600 159,700 204,700 208,000 247,400 22 Revenue Over / (Under) Expenses (35,558) (13,700)475,500 18,600 59,700 74,100 OTHER FINANCING SOURCES / (USES) 23 Bond Proceeds 0 0 500,000 0 430,000 450,000 24Transfers In 000000 25 Purchase of capital assets (79,612) (10,300) (1,025,600)(68,100) (510,100) (530,500) 26 Transfers Out-0 27 Total Other Sources / (Uses)(79,612) (10,300) (525,600) (68,100) (80,100) (80,500) 28 Change in balance sheet 29 Ending Cash 26,145 56,400 61,700 68,700 105,900 158,300 30 Target Cash 130,762 52,150 620,650 164,250 213,350 252,550 31 Over (Under) Target (104,617) 4,250 (558,950) (95,550) (107,450) (94,250) FUND 602 FINANCIAL MANAGEMENT PLAN BIG MARINE SEWER FUND FINACIAL MANAGEMENT PLANPresented 10/12/2022 Sewer Advisory Committee Draft 2023 Sewer BudgetPage 19 of 39 Capital Improvement Program City of Scandia, Minnesota SOURCES AND USES OF FUNDS FY '23 FY '27thru 602 Big Marine Sewer Fund Source FY '23 FY '24 FY '25 FY '26 FY '27 26,145 (922,005)80,445 55,395 (523,155)Beginning Balance Revenues and Other Fund Sources Revenue 141,900 177,400 211,800 266,100 319,3001. Charges for Service 600 600 600 600 6002. Special Assessments 400 800 900 1,000 1,6004. Interest 0 456,400 0 0 05. American Rescue Plan Act Fund 0 500,000 0 430,000 450,0006. Bond Proceeds 142,900 1,135,200 213,300 697,700 771,500Total 169,045 213,195 293,745 753,095 248,345Total Funds Available 142,900 1,135,200 213,300 697,700 771,500Total Revenues and Other Fund Sources Expenditures and Uses Capital Projects & Equipment Big Marine Sewer 0 0 (60,000)0 0A/E Drainfield 201S-002 (960,000)0 0 0 0Bliss nitrate treatment equipment 201S-005 (2,500)0 0 (350,000)0Bliss LS 1 201S-006 (2,500)0 0 (350,000)0Bliss LS 2 201S-007 0 0 0 (2,500)0Bliss LS 3 Dosage Tanks 201S-009 0 0 0 0 (2,500)Bliss LS 4 Dosage Tanks 201S-011 (3,250)(4,750)(3,250)(3,250)(3,250)AE LS 1 Pump 2 201S-015 (11,000)(14,000)(17,000)0 0Distribution Network Replacement 201S-016 0 0 0 (350,000)0Bliss Replace LS 2 201S-019 0 0 0 0 (10,000)Bliss LS 1 ControlPanel 201S-020 0 0 0 (50,000)(50,000)Forcemain replacement 201S--020 0 0 0 (10,000)0Bliss LS 2 Control Panel 201S-021 (979,250)(18,750)(80,250)(1,115,750)(65,750)Total Other Uses (26,600)(27,100)(27,600)(28,200)(28,800)1. Compensation of Personel (5,400)(5,500)(5,600)(5,700)(5,800)2. Materials (24,400)(24,900)(25,400)(25,900)(26,400)3. Professional Services (36,400)(37,100)(37,800)(38,600)(39,400)4. Repair and Maintenance (9,500)(9,700)(9,900)(10,100)(10,300)5. Other (9,500)(9,700)(9,900)(10,100)(10,300)6. Depreciation DRAFT 2023 SEWER CIPSewer Advisory Committee Presented Wednesday, October 12, 2022Page 20 of 39 602 Big Marine Sewer Fund Source FY '23 FY '24 FY '25 FY '26 FY '27 0 0 (41,900)(41,900)(77,900)7. Debt Service (Principal/Interest) (111,800)(114,000)(158,100)(160,500)(198,900)Total (1,091,050)(132,750)(238,350)(1,276,250)(264,650)Total Expenditures and Uses (922,005)80,445 55,395 (523,155)(16,305)Ending Balance (948,150)1,002,450 (25,050)(578,550)506,850Change in Fund Balance DRAFT 2023 SEWER CIPSewer Advisory Committee Presented Wednesday, October 12, 2022Page 21 of 39 DRAFT 2023 Sewer BudgetPresented 10/12/2022Sewer Advisory CommitteeInflation Assumptions5CIP Inflation Factor0.00% 0.00% 4.00% 4.00% 4.00% 4.00%20212022 2023 2024 2025 2026 2027Capital Project NameFirst Year Cost Est.Budget Proposed Projected33 A/E Drainfield300,000 - - - - - - 34 A/E Drainfield-engineering202550,000 - - - 58,493 - - 35- - - - - - 36 Bliss nitrate treatment equipment2024 900,000 - - 1,012,378 - - - 37 LS 1 Control Panel202710,000 - - - - - 12,65338 LS 2 Control Panel202610,000 - - - - 12,167 - 39 LS 2 Control Panel20311,500 - - - - - - 40 LS #1 (Layton Ave)2022500 500 - - - - - 41 LS #1 (Layton Ave)2023500 -500- - - - 42 LS #1 (Layton Ave)20242,500 - - 2,812 - - - 43 LS #1 (Layton Ave)2025500 - - - 585 - - 44 LS #1 (Layton Ave)2026500 - - - - 608 - 45 LS #1 (Layton Ave)2027350,000 - - - - - 442,86246 LS #1 (Layton Ave)2028500 - - - - - - 47 LS #1 (Layton Ave)2029500 - - - - - - 48 LS #1 (Layton Ave)2030500 - - - - - - 49 LS #1 (Layton Ave)2031500 - - - - - - 50 LS #2 (189th - Main Station)2022500 500 - - - - - 51 LS #2 (189th - Main Station)20232,500 -2,500- - - - 52 LS #2 (189th - Main Station)2024500 - - 562 - - - 53 LS #2 (189th - Main Station)2025500 - - - 585 - - 54 LS #2 Main Station Rehab2026 350,000 - - - - 425,829 - 55 LS #2 (189th - Main Station)2027500 - - - - - 63356 LS #2 (189th - Main Station)2028500 - - - - - - 57 LS #2 (189th - Main Station)2029500 - - - - - - 58 LS #2 (189th - Main Station)2030500 - - - - - - 59 LS #2 (189th - Main Station)20312,500 - - - - - - 60 LS #3 Pump 1 Replacement20216,000 - - - - - - 61 LS #3 Pump 2 Replacement20216,000 - - - - - - 62 LS #3 (Dosage Tanks)2022500 500 - - - - - 63 LS #3 (Dosage Tanks)2023500 -500- - - - 64 LS #3 (Dosage Tanks)2024500 - - 562 - - - 65 LS #3 (Dosage Tanks)2025500 - - - 585 - - 66 LS #3 (Dosage Tanks)20262,500 - - - - 3,042 - 67 LS #3 (Dosage Tanks)2027500 - - - - - 63368 LS #3 (Dosage Tanks)2028500 - - - - - - FUND 602 FINANCIAL MANAGEMENT PLANBIG MARINE SEWER FUNDCAPITAL OUTLAYProjectPresented 10/12/2022Sewer Advisory CommitteeDraft 2023 Sewer BudgetPage 22 of 39 DRAFT 2023 Sewer BudgetPresented 10/12/2022Sewer Advisory CommitteeInflation Assumptions5CIP Inflation Factor0.00% 0.00% 4.00% 4.00% 4.00% 4.00%20212022 2023 2024 2025 2026 2027Capital Project NameFirst Year Cost Est.Budget Proposed Projected FUND 602 FINANCIAL MANAGEMENT PLANBIG MARINE SEWER FUNDProject69 LS #3 (Dosage Tanks)2029500 - - - - - - 70 LS #3 (Dosage Tanks)203070,000 - - - - - - 71 LS #3 (Dosage Tanks)20312,500 - - - - - - 72 LS #4 Pump 1 Replacement20216,000 - - - - - - 73 LS #4 Pump 2 Replacement20216,000 - - - - - - 74 LS #4 (Dosage Tanks)2022500 500 - - - - - 75 LS #4 (Dosage Tanks)2023500 - 500 - - - - 76 LS #4 (Dosage Tanks)2024500 - - 562 - - - 77 LS #4 (Dosage Tanks)2025500 - - -585- - 78 LS #4 (Dosage Tanks)2026500 - - - - 608 - 79 LS #4 (Dosage Tanks)20272,500 - - - - - 3,163 80 LS #4 (Dosage Tanks)2028500 - - - - - - 81 LS #4 (Dosage Tanks)2029500 - - - - - - 82 LS #4 (Dosage Tanks)2031500 - - - - - - 83 LS #4 (Dosage Tanks)203070,000 - - - - - - 84 Repairs20222,500 2,500 2,500 2,812 2,925 3,042 3,163 85 Forcemain2022500 500 500 562 585 - - 86 Forcemain202650,000 - - - - 60,833 63,266 87 Forcemain2028500 - - - - - - 88 Forcemain203050,000 - - - - - - 89 Forcemain20285,000 - - - - - - 90 Forcemain2031500 - - - - - - 91 Introduction of Metering2028 120,000 - - - - - - 92 Connection meter equipment202825,000 - - - - - - 93 A/E control panel202950,000 - - - - - - 94 A/E LS20221,000 1,000 1,000 - - - - 95A/E LS20242,500 - - 2,812 - - - 96 A/E LS20251,000 - - -1,1701,217 1,265 97 A/E LS2029 350,000 - - - - - - 98 A/E LS20301,000 - - - - - - 99 A/E repairs20221,750 1,750 1,750 1,969 2,047 2,129 2,214 100 A/E forcemain2022500 500 500 562 585 608 633 101 A/E forcemain202950,000 - - - - - - 102 A/E forcemain2030500 - - - - - - 103 A/E connection metering and software 203065,000 - - - - - - 104 Total Capital Projects2,942,750 8,250 10,250 1,025,594 68,145 510,082 530,484 5 YEAR CAPITAL OUTLAYPresented 10/12/2022Sewer Advisory CommitteeDraft 2023 Sewer BudgetPage 23 of 39 DRAFT 2023 Sewer BudgetPresented 10/12/2022Sewer Advisory CommitteeInflation Assumptions5CIP Inflation Factor0.00% 0.00% 4.00% 4.00% 4.00% 4.00%20212022 2023 2024 2025 2026 2027Capital Project NameFirst Year Cost Est.Budget Proposed Projected FUND 602 FINANCIAL MANAGEMENT PLANBIG MARINE SEWER FUNDProjectPROJECTED NEW DEBT TERMS105 Par Amount (Line 14)--500,000 -430,000 450,000 106 Number of Years20 15 15 15 15 15 107 Interest Rate3.00% 2.50% 3.00% 3.00% 3.00% 3.00%108 New Debt Levy Through Rates0 0 0 43,977 43,977 81,798Presented 10/12/2022Sewer Advisory CommitteeDraft 2023 Sewer BudgetPage 24 of 39 DRAFT 2023 BudgetActual Budget Actual ProposedTypCode Description2021 2022 6/30/2022 2023 % Bud Diff Notes and Discriptions2023 Draft Proposed Line-Item Budget DetailFUND 602 SEWER - BIG MARINE FUNDR 602-31951 Special Assessments Principal - - - - R 602-31952 SA Penalties & Interest624 - - - R 602-33422 Other State Grants & Aids25 - - - 2020 Revenue was a FEMA reimbursement + $30,173 rec'd Sept. 2020R 602-34401 Sewer User Fees & Hookup98,531 109,592 36,000 141,900 29.48% See Rate Study for breakdownR 602-36100 Special Assessments- 300 -600 100.00%R 602-36210 Interest Income181 49 -400 716.33%R 602-36250 Misc. Refund- - - - R 602-39200 Interfund Tranfers In- - - - R 602-39310 Bond Proceeds- - - - TOTAL 602 REVENUE99,361 109,941 36,000 142,900 29.98%Fund 602 EXPENSESE 602-43210-101 Regular Wages & Salaries11,014 21,600 9,131 22,500 4.17% All wage and benefits a % share of employees completing utility operations workE 602-43210-102 OT Regular Wages441 - - - "E 602-43210-120 Pension Expense(1,438) - - - "E 602-43210-121 PERA Coord. Employer Contribu.806 1,600 684 1,700 6.25% "E 602-43210-122 FICA Employer Contribution684 1,300 528 1,400 7.69% "E 602-43210-126 MEDICARE Employer Contribution156 300 136 300 0.00% "E 602-43210-131 Employer Paid Health- - - - "E602-43210-134Employer Paid Life- - - - "E602-43210-135Employer Paid Disability- - - - "E 602-43210-151Worker s Comp Insurance Prem422 900 1,180 700 -22.22% Change in formula results in lower projected cost share.E 602-43210-200 Office Supplies109 200 85 200 0.00%E 602-43210-210 Operating Supplies558 2,400 123 2,500 4.17% Additives to help break down the nitrogen - add to lift Station #2 -proposalE 602-43210-240 Small Tools and Minor Equip- 550 -600 9.09%E 602-43210-303 Engineering Fees13,277 10,400 8,081 10,500 0.96% Services related to project planning and operations of wastewater systtemsE 602-43210-304 Legal Services- - 4,800 - Lobbying expense form 2022E 602-43210-308 Other Professional Services3,376 2,200 2,397 2,500 13.64% PACE testingE 602-43210-309 Software Support & Maintenance716 1,200 -1,300 8.33% SCADA computer systemE 602-43210-311 Contract Permit Inspections- - - - Sewer Advisory CommitteePresented 10/12/2022Page 25 of 39 DRAFT 2023 BudgetActual Budget Actual ProposedTypCode Description2021 2022 6/30/2022 2023 % Bud Diff Notes and Discriptions2023 Draft Proposed Line-Item Budget DetailE 602-43210-317 Employee Training868 1,400 573 1,400 0.00%E 602-43210-321 Telephone2,413 2,100 1,082 2,400 14.29% SCADA dialersE 602-43210-322 Postage- 550 200 600 9.09%E 602-43210-331 Travel Expenses8 200 158 200 0.00% educational trips for 2 employees to maintain licensure E 602-43210-334 Licenses & Permits1,180 1,600 768 1,600 0.00%E 602-43210-351 Legal Notices Publishing- - - - E 602-43210-353 Sales& Use Tax- - - - E 602-43210-361 Liability/Property Ins1,039 900 1,003 3,000 233.33% Change in formula.E 602-43210-381 Utilities-Electric & Gas1,862 2,500 1,043 2,500 0.00% Lift station and ariation electrical use.E 602-43210-385 Sewer Pumping & Maintenance5,364 11,000 710 15,000 36.36% City has regular rotation of sludge removal of septic tanksE 602-43210-386 Operation & Maintenance1,574 5,000 712 5,000 0.00%E 602-43210-404 Repair Machinery/Equipment4,375 16,000 565 16,000 0.00%E 602-43210-413 Equipment Rental- 350 -400 14.29%E 602-43210-420 Depreciation Expense48,667 52,200 -54,300 4.02% Expense that is used towards the increase of fund balance, not actually spent.E 602-43210-438 Misc. Contractual3,775 9,000 1,123 10,000 11.11%E 602-43210-439 Refunds Issued- - - - E 602-43210-530 Capital Impr Other Than Bldgs- 79,612 45,830 10,300 -87.06% See Capitail Improvement PlanE 602-43210-570 Office Equipment- - - - E 602-43210-601 Long Term Debt Principal (New Line migh- - - - Lines added fto record future debtE 602-43210-611 Long Term Debt Interest (New Line)- - - - "E 602-43210-720 Operating Transfers- - - - TOTAL FUND 602 EXPENDITURES101,243 225,062 80,912 166,900 -25.84%NET REVENUE OVER EXPENDITURES(1,882) (115,121) (44,913) 30,300 126.32%(less depreciation)Sewer Advisory CommitteePresented 10/12/2022Page 26 of 39 Capital Improvement Program City of Scandia, Minnesota Contact Engineer FY '23 FY '27thru Department Big Marine Sewer Description engineering 2025 Project #201S-002 Priority 2: High priority Justification Expansion or replacement of the system due to growth in use Budget Impact/Other Useful Life 40 yearsProject Name A/E Drainfield Category Wastewater Type New Total Project Cost:$60,000 TotalFY '23 FY '24 FY '25 FY '26 FY '27Expenditures 60,00060,000Construction 60,000 60,000Total TotalFY '23 FY '24 FY '25 FY '26 FY '27Funding Sources 60,00060,000602 Big Marine Sewer Fund 60,000 60,000Total DRAFT 2023 SEWER CIPSewer Advisory Committee Presented Wednesday, October 12, 2022Page 27 of 39 Capital Improvement Program City of Scandia, Minnesota Contact Engineer FY '23 FY '27thru Department Big Marine Sewer Description nitrate treatment equipment Project #201S-005 Priority 1: Urgent, high priority Justification violation of nitrate levels in well per MPCA Budget Impact/Other Useful Life 40 yearsProject Name Bliss nitrate treatment equipment Category Wastewater Type Improvement Total Project Cost:$960,000 TotalFY '23 FY '24 FY '25 FY '26 FY '27Expenditures 960,000960,000Equip/Vehicles/Furnishings 960,000 960,000Total TotalFY '23 FY '24 FY '25 FY '26 FY '27Funding Sources 960,000960,000602 Big Marine Sewer Fund 960,000 960,000Total Prior 10,000 Total DRAFT 2023 SEWER CIPSewer Advisory Committee Presented Wednesday, October 12, 2022Page 28 of 39 Capital Improvement Program City of Scandia, Minnesota Contact Public Works Director FY '23 FY '27thru Department Big Marine Sewer Description Project #201S-006 Priority 2: High priority Justification end of useful life Budget Impact/Other Useful Life 7 yearsProject Name Bliss LS 1 Category Wastewater Type Replacement Total Project Cost:$355,000 TotalFY '23 FY '24 FY '25 FY '26 FY '27Expenditures 352,5002,500 350,000Equip/Vehicles/Furnishings 2,500 350,000 352,500Total Future 2,500 Total TotalFY '23 FY '24 FY '25 FY '26 FY '27Funding Sources 352,5002,500 350,000602 Big Marine Sewer Fund 2,500 350,000 352,500Total Future 2,500 Total DRAFT 2023 SEWER CIPSewer Advisory Committee Presented Wednesday, October 12, 2022Page 29 of 39 Capital Improvement Program City of Scandia, Minnesota Contact Public Works Director FY '23 FY '27thru Department Big Marine Sewer Description Project #201S-007 Priority 2: High priority Justification end of useful life - purchased in 2014 Budget Impact/Other Useful Life 7 yearsProject Name Bliss LS 2 Category Wastewater Type Replacement Total Project Cost:$355,000 TotalFY '23 FY '24 FY '25 FY '26 FY '27Expenditures 352,5002,500 350,000Equip/Vehicles/Furnishings 2,500 350,000 352,500Total Future 2,500 Total TotalFY '23 FY '24 FY '25 FY '26 FY '27Funding Sources 352,5002,500 350,000602 Big Marine Sewer Fund 2,500 350,000 352,500Total Future 2,500 Total DRAFT 2023 SEWER CIPSewer Advisory Committee Presented Wednesday, October 12, 2022Page 30 of 39 Capital Improvement Program City of Scandia, Minnesota Contact Public Works Director FY '23 FY '27thru Department Big Marine Sewer Description Project #201S-009 Priority 2: High priority Justification end of useful life - purchased in 2014 Budget Impact/Other Useful Life 7 yearsProject Name Bliss LS 3 Dosage Tanks Category Wastewater Type Replacement Total Project Cost:$75,000 TotalFY '23 FY '24 FY '25 FY '26 FY '27Expenditures 2,5002,500Equip/Vehicles/Furnishings 2,500 2,500Total Future 72,500 Total TotalFY '23 FY '24 FY '25 FY '26 FY '27Funding Sources 2,5002,500602 Big Marine Sewer Fund 2,500 2,500Total Future 72,500 Total DRAFT 2023 SEWER CIPSewer Advisory Committee Presented Wednesday, October 12, 2022Page 31 of 39 Capital Improvement Program City of Scandia, Minnesota Contact Public Works Director FY '23 FY '27thru Department Big Marine Sewer Description Project #201S-011 Priority 2: High priority Justification end of useful life - purchased in 2014 Budget Impact/Other Useful Life 7 yearsProject Name Bliss LS 4 Dosage Tanks Category Wastewater Type Replacement Total Project Cost:$72,500 TotalFY '23 FY '24 FY '25 FY '26 FY '27Expenditures 2,5002,500Equip/Vehicles/Furnishings 2,500 2,500Total Future 70,000 Total TotalFY '23 FY '24 FY '25 FY '26 FY '27Funding Sources 2,5002,500602 Big Marine Sewer Fund 2,500 2,500Total Future 70,000 Total DRAFT 2023 SEWER CIPSewer Advisory Committee Presented Wednesday, October 12, 2022Page 32 of 39 Capital Improvement Program City of Scandia, Minnesota Contact FY '23 FY '27thru Department Big Marine Sewer Description Replace AE Lift Station 1, Pump 2 Project #201S-015 Priority 2: High priority Justification Budget Impact/Other Useful Life 15 yearsProject Name AE LS 1 Pump 2 Category Wastewater Type Replacement Total Project Cost:$482,500 TotalFY '23 FY '24 FY '25 FY '26 FY '27Expenditures 17,7503,250 4,750 3,250 3,250 3,250Maintenance 3,250 4,750 3,250 3,250 3,250 17,750Total Prior 3,250 Total Future 461,500 Total TotalFY '23 FY '24 FY '25 FY '26 FY '27Funding Sources 17,7503,250 4,750 3,250 3,250 3,250602 Big Marine Sewer Fund 3,250 4,750 3,250 3,250 3,250 17,750Total Prior 3,250 Total Future 461,500 Total DRAFT 2023 SEWER CIPSewer Advisory Committee Presented Wednesday, October 12, 2022Page 33 of 39 Capital Improvement Program City of Scandia, Minnesota Contact Public Works Director FY '23 FY '27thru Department Big Marine Sewer Description Distribution Network Replacement Project #201S-016 Priority 1: Urgent, high priority Justification Budget Impact/Other Useful Life 40 yearsProject Name Distribution Network Replacement Category Wastewater Type Maintenance Total Project Cost:$55,000 TotalFY '23 FY '24 FY '25 FY '26 FY '27Expenditures 42,00011,000 14,000 17,000Construction 11,000 14,000 17,000 42,000Total Prior 13,000 Total TotalFY '23 FY '24 FY '25 FY '26 FY '27Funding Sources 42,00011,000 14,000 17,000602 Big Marine Sewer Fund 11,000 14,000 17,000 42,000Total Prior 13,000 Total DRAFT 2023 SEWER CIPSewer Advisory Committee Presented Wednesday, October 12, 2022Page 34 of 39 Capital Improvement Program City of Scandia, Minnesota Contact FY '23 FY '27thru Department Big Marine Sewer Description Project #201S-019 Priority N/A Justification Budget Impact/Other Useful LifeProject Name Bliss Replace LS 2 Category Wastewater Type Unassigned Total Project Cost:$350,000 TotalFY '23 FY '24 FY '25 FY '26 FY '27Expenditures 350,000350,000Maintenance 350,000 350,000Total TotalFY '23 FY '24 FY '25 FY '26 FY '27Funding Sources 350,000350,000602 Big Marine Sewer Fund 350,000 350,000Total DRAFT 2023 SEWER CIPSewer Advisory Committee Presented Wednesday, October 12, 2022Page 35 of 39 Capital Improvement Program City of Scandia, Minnesota Contact FY '23 FY '27thru Department Big Marine Sewer Description Project #201S-020 Priority N/A Justification Budget Impact/Other Useful LifeProject Name Bliss LS 1 ControlPanel Category Other Type Unassigned Total Project Cost:$10,000 TotalFY '23 FY '24 FY '25 FY '26 FY '27Expenditures 10,00010,000Equip/Vehicles/Furnishings 10,000 10,000Total TotalFY '23 FY '24 FY '25 FY '26 FY '27Funding Sources 10,00010,000602 Big Marine Sewer Fund 10,000 10,000Total DRAFT 2023 SEWER CIPSewer Advisory Committee Presented Wednesday, October 12, 2022Page 36 of 39 Capital Improvement Program City of Scandia, Minnesota Contact FY '23 FY '27thru Department Big Marine Sewer Description Project #201S--020 Priority 2: High priority Justification Budget Impact/Other Useful Life 40 yearsProject Name Forcemain replacement Category Other Type Replacement Total Project Cost:$150,000 TotalFY '23 FY '24 FY '25 FY '26 FY '27Expenditures 100,00050,000 50,000Equip/Vehicles/Furnishings 50,000 50,000 100,000Total Future 50,000 Total TotalFY '23 FY '24 FY '25 FY '26 FY '27Funding Sources 100,00050,000 50,000602 Big Marine Sewer Fund 50,000 50,000 100,000Total Future 50,000 Total DRAFT 2023 SEWER CIPSewer Advisory Committee Presented Wednesday, October 12, 2022Page 37 of 39 Capital Improvement Program City of Scandia, Minnesota Contact FY '23 FY '27thru Department Big Marine Sewer Description Project #201S-021 Priority 2: High priority Justification Budget Impact/Other Useful Life 20 yearsProject Name Bliss LS 2 Control Panel Category Other Type Replacement Total Project Cost:$10,000 TotalFY '23 FY '24 FY '25 FY '26 FY '27Expenditures 10,00010,000Equip/Vehicles/Furnishings 10,000 10,000Total TotalFY '23 FY '24 FY '25 FY '26 FY '27Funding Sources 10,00010,000602 Big Marine Sewer Fund 10,000 10,000Total DRAFT 2023 SEWER CIPSewer Advisory Committee Presented Wednesday, October 12, 2022Page 38 of 39 Capital Improvement Program City of Scandia, Minnesota PROJECTS BY FUNDING SOURCE FY '23 FY '27thru TotalSourceProject #Priority FY '23 FY '24 FY '25 FY '26 FY '27 602 Big Marine Sewer Fund 201S-002 60,00060,000A/E Drainfield 2 201S-005 960,000960,000Bliss nitrate treatment equipment 1 201S-006 352,5002,500 350,000Bliss LS 1 2 201S-007 352,5002,500 350,000Bliss LS 2 2 201S-009 2,5002,500Bliss LS 3 Dosage Tanks 2 201S-011 2,5002,500Bliss LS 4 Dosage Tanks 2 201S-015 17,7503,250 4,750 3,250 3,250 3,250AE LS 1 Pump 2 2 201S-016 42,00011,000 14,000 17,000Distribution Network Replacement 1 201S-019 350,000350,000Bliss Replace LS 2 n/a 201S-020 10,00010,000Bliss LS 1 ControlPanel n/a 201S--020 100,00050,000 50,000Forcemain replacement 2 201S-021 10,00010,000Bliss LS 2 Control Panel 2 2,259,750979,250 18,750 80,250 1,115,750 65,750602 Big Marine Sewer Fund Total 612 Uptown Sewer Fund US-004 35,5001,000 2,500 1,000 1,000 30,000Uptown Lift Station Replacement 2 US-009 5,0001,000 1,000 1,000 1,000 1,000Repairs-TBD (Tanks/Castings/etc)2 40,5002,000 3,500 2,000 2,000 31,000612 Uptown Sewer Fund Total 2,300,250981,250 22,250 82,250 1,117,750 96,750GRAND TOTAL Presented Wednesday, October 12, 2022DRAFT 2023 SEWER CIP Sewer Advisory Committee Page 39 of 39