Loading...
01. 2023 Draft Proposed Sewer Budget 11-15-2022DRAFT PROPOSED 2022 SEWER BUDGET Presented to the City Council and Sewer Advisory Committee 11/15/2022 Pg. 1 of 31 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 Draft 11/15/2022 Sewer Budget Pg. 2 of 31 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 to increase fund balance to increase capacity for anticipated long-range capital expenses. $150k to $200k is the current fund balance goal, but will likely not fully fund future projects. •Includes proposed increases to base fee and consumption fees by 25% over PY. Projected $8,100 increase in rate revenues. •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. Draft 11/15/2022 Sewer Budget Pg. 3 of 31 HIGHLIGHTS OF 2023 UPTOWN SEWER BUDGET •Future considerations for utility: •The future financial viability of this utility will be contingent on its capacity to grow and support more users. Its current limited size, capacity, and service area will continue to present significant financial limitations going forward. •Given the election outcome and potential improved likelihood of state bonding for the Water Tower Barn Arts and Heritage Center Project, this is the right time to consider seeking funding from the State for system expansion. This may include both infrastructural costs and land acquisition. (Additional planning required.) Draft 11/15/2022 Sewer Budget Pg. 4 of 31 DRAFT 2023 SEWER BUDGET Presented 11/15/2022 Joint City Council meeting Scandia Utilities Utility Rate Study Uptown Sewer System Projected Utility Rates 2022 2023 2024 2025 2026 2027 5.00%25.00%25.00%25.00%25.00%25.00% Base Charge Annual 367.50 459.38 574.22 717.77 897.22 1,121.52 Quarterly 91.88 114.84 143.55 179.44 224.30 280.38 % Change from PY 5.00%25.00%25.00%25.00%25.00%25.00% Base Charge Increase Annual 17.50 91.88 114.84 143.55 179.44 224.30 Quarterly 4.38 22.97 28.71 35.89 44.86 56.08 Volume Charge per 1,000 Gallons 52.29 65.36 81.70 102.13 127.66 159.58 % Change from PY 5.00%25.00%25.00%25.00%25.00%25.00% Change from PY 2.49 13.07 16.34 20.43 25.53 31.92 Estimated % Increase (reduction) in Consumption 24.2%2%2%1%-2% Total Units of Consumption (Est.) per Year 273,000 360,000 367,200 374,500 378,200 370,600 Estimated Total Consump Revenue Annual $14,275.17 $23,500.00 $30,000.00 $38,200.00 $48,300.00 $59,100.00 # of Customers 9 9 10 10 10 10 Total Year Revenue Estimate $17,582.67 $27,634.38 $35,742.19 $45,377.73 $57,272.17 $70,315.21 Rounded Total Yr Est for Budget 17,600.00 27,600.00 35,700.00 45,400.00 57,300.00 70,300.00 2021 2020 2019 2018 2017 2016 Total 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.24 Consumption Averages per yr 6 months 332,856.67 2021-2019 283,956.67 2019-2017 351,750.00 Historic Uptown Sewer Total Consumption Data Presented 11/15/2022 Joint City Council meeting DRAFT 2023 SEWER BUDGETPg. 5 of 31 DRAFT 2023 SEWER BUDGET Presented 11/15/2022 Joint City Council meeting Scandia Utilities Utility Rate Study Uptown Sewer System Projected Utility Rates 2028 2029 2030 2031 2032 25.00%25.00%5.00%5.00%5.00% Base Charge Annual 1,401.90 1,752.38 1,840.00 1,932.00 2,028.59 Quarterly 350.48 438.09 460.00 483.00 507.15 % Change from PY 25.00%25.00%5.00%5.00%5.00% Base Charge Increase Annual 280.38 350.48 87.62 92.00 96.60 Quarterly 70.10 87.62 21.90 23.00 24.15 Volume Charge per 1,000 Gallons 52.29 65.36 68.63 72.06 75.67 % Change from PY -67.23%25.00%5.00%5.00%5.00% Change from PY (107.29) 13.07 3.27 3.43 3.60 Estimated % Increase (reduction) in Consumption -3%-4%-5%-6%-8% Total Units of Consumption (Est.) per Year 361,300 347,600 329,900 308,800 285,000 Estimated Total Consump Revenue Annual $18,892.38 $22,700.00 $22,600.00 $22,300.00 $21,600.00 # of Customers 10.46666667 10.6952381 10.92380952 11.15238095 11.38095238 Total Year Revenue Estimate $33,565.61 $41,442.08 $42,699.76 $43,846.35 $44,687.34 Rounded Total Yr Est for Budget 33,600.00 41,400.00 42,700.00 43,800.00 44,700.00 Presented 11/15/2022 Joint City Council meeting DRAFT 2023 SEWER BUDGETPg. 6 of 31 Draft 2023 Sewer Budget Presented 11/15/2022 Joint City Council meeting Inflation Assumptions 1 Revenue (Non-property tax)2.00% 2.00% 2.00% 2.00% 2.00%2.00% 2.00% 2.00% 2.00% 2 Inflation on rates 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 5.00% 5.00% 3 Interest Earnings 1.50% 1.50% 1.50% 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% 3.00% 3.00% 3.00% 5 CIP Inflation Factor 0.00% 0.00% 4.00% 4.00% 4.00%4.00% 4.00% 4.00% 4.00%FINANCIAL MANAGEMENT PLAN SH FLOW ANALYSIS2023 2024 2025 2026 2027 2028 2029 2030 2031 Proposed Projected REVENUE 6 Charges for services 27,600 35,700 45,400 57,300 70,300 87,875 109,844 115,336 121,103 7 Special assessments 0 0 0 0 0 0 0 0 0 8 Intergovernmental 0 0 0 0 0 0 0 0 0 9 Interest 200 200 600 800 1,300 1,229 2,112 3,368 4,714 10 Miscellaneous 0 10,000 0 0 0 11 SHA Expansion (State Bonding)0 574,500 0 0 0 12 13 Total Revenue 27,800 620,400 46,000 58,100 71,600 89,104 111,955 118,704 125,817 EXPENSES 14 Wages 11,300 11,500 11,700 11,900 12,100 12,300 12,500 12,800 13,100 15 Materials 700 700 700 700 700 700 700 700 700 16 Professional services 3,150 3,200 3,300 3,400 3,500 3,600 3,700 3,800 3,900 17 Repair and maintenance 4,200 4,300 4,400 4,500 4,600 4,700 4,800 4,900 5,000 18 Other 2,500 2,600 2,700 2,800 2,900 3,000 3,100 3,200 3,300 19 Depreciation 5,100 5,200 5,300 5,400 5,500 5,600 5,700 5,800 5,900 20 Debt service 0 0 0 0 0 0 0 0 0 21 85,900 22 Total Expenses 26,950 27,500 28,100 28,700 29,300 29,900 30,500 31,200 117,800 23 Revenue Over / (Under) Expenses 850 592,900 17,900 29,400 42,300 59,204 81,455 87,504 8,017 OTHER FINANCING SOURCES / (USES) 24 Bond Proceeds 0 0 0 0 0 225,000 25 Transfers In 0 0 0 0 0 0 0 0 0 26 Purchase of capital assets (4,500) (574,000) (8,200) (3,000) (52,500) (5,922) (3,422) (3,558) (85,854) 27 Advance to other fund 0 0 0 0 0 28 Transfers Out-0 0 0 0 0 29 Total Other Sources / (Uses)(4,500) (574,000) (8,200) (3,000) (52,500) (5,922) (3,422) (3,558)139,146 30 Change in balance sheet 31 Ending Cash 15,700 39,800 54,800 86,600 81,900 140,782 224,515 314,261 467,324 32 Target Cash 11,150 11,400 11,650 11,900 12,150 12,400 12,700 98,900 98,900 33 Over (Under) Target 4,550 28,400 43,150 74,700 69,750 128,382 211,815 215,361 368,424 LAN FUND 612 FINANCIAL MANAGEMENT PLAN Uptown Sewer Fund Presented 11/15/2022 Joint City Council meeting Draft 2023 Sewer BudgetPg. 7 of 31 Draft 2023 Sewer Budget Presented 11/15/2022 Joint City Council meeting Inflation Assumptions 1 Revenue (Non-property tax) 2 Inflation on rates 3 Interest Earnings 4 Expenses 5 CIP Inflation Factor FINANCIAL MANAGEMENT PLAN SH FLOW ANALYSIS REVENUE 6 Charges for services 7 Special assessments 8 Intergovernmental 9 Interest 10 Miscellaneous 11 SHA Expansion (State Bonding) 12 13 Total Revenue EXPENSES 14 Wages 15 Materials 16 Professional services 17 Repair and maintenance 18 Other 19 Depreciation 20 Debt service 21 22 Total Expenses 23 Revenue Over / (Under) Expenses OTHER FINANCING SOURCES / (USES) 24 Bond Proceeds 25 Transfers In 26 Purchase of capital assets 27 Advance to other fund 28 Transfers Out- 29 Total Other Sources / (Uses) 30 Change in balance sheet 31 Ending Cash 32 Target Cash 33 Over (Under) Target 2.00% 2.00% 5.00% 4.00% 1.50% 1.50% 3.00% 3.00% 4.00% 4.00% 2032 2033 127,158 132,244 0 0 0 0 7,010 7,146 134,168 139,390 13,400 13,700 700 700 4,000 4,100 5,100 5,200 3,400 3,500 6,000 6,100 0 0 32,600 33,300 101,568 106,090 0 0 (98,525) (4,003) (98,525) (4,003) 476,367 584,553 13,600 13,900 462,767 570,653 FUND 612 FINANCIAL MANAGEME Presented 11/15/2022 Joint City Council meeting Draft 2023 Sewer Budget FUND 612 FINANCIAL MANAGEMENT PLAN Uptown Sewer Fund Pg. 8 of 31 Revenue and Expense Prejections Compared to Fund Balance $0 $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 Uptown Sewer Revenue Expense Fund Balance * Conveys estimated revenue and expense based on utility rate study and the rates recommended. Spike in 2024 denotes Heritage Alliance expansion which they would be financing. Presented 11/15/2022 Joint City Council meeting Draft 2023 Sewer BudgetPg. 9 of 31 Draft 2023 Sewer Budget Presented 11/15/2022 Joint City Council meeting Inflation Assumptions 5 CIP Inflation Factor 0.00%0.00%4.00%4.00%4.00%4.00% 2021 2023 2024 2025 2026 2027 2028 Capital Project Name Est. Costs 34 Control Panel 60,000.00 - - - - - - 35 Hillside LS 1,000.00 1,000 - - - - - 36 Hillside LS 2,500.00 - 2,500 - - - - 37 Hillside LS 1,000.00 - - 1,170 1,217 - - 38 Hillside LS 40,000.00 - - - - 50,613 - 39 Hillside LS 1,000.00 - - - - - 1,316 40 Hillside LS 2,500.00 - - - - - - 41 Hillside LS 1,000.00 - - - - - - 42 Drainfield LS 500.00 - - - - - - 43 Drainfield LS 2,500.00 2,500 - - - - - 44 Drainfield LS 500.00 - 500 585 608 633 - 45 Drainfield LS 2,500.00 - - - - - 3,290 46 Drainfield LS 500.00 - - - - - - 47 Blower Replacement 4,500.00 - - 5,264 - - - 48 Blower Replacement 5,500.00 - - - - - - 49 Repairs (tanks/castings/etc)1,000.00 1,000 1,000 1,170 1,217 1,265 1,316 50 Repairs (tanks/castings/etc) Forcemain 50,000.00 - - - - - - 51 Repairs (tanks/castings/etc) Forcemain 60,000.00 - - - - - - 52 Drainfield Expansion (2024) SHA Addition 570,000 - 570,000 - - - - 53 Total Capital Projects 806,500 4,500 574,000 8,189 3,042 52,511 5,922 CAPITAL PROJECTS & DEBT LEVY FUND 612 FINANCIAL MANAGEMENT PLAN Uptown Sewer Fund Presented 11/15/2022 Joint City Council meeting Draft 2023 Sewer BudgetPg. 10 of 31 Draft 2023 Sewer Budget Presented 11/15/2022 Joint City Council meeting Inflation Assumptions 5 CIP Inflation Factor Capital Project Name 34 Control Panel 35 Hillside LS 36 Hillside LS 37 Hillside LS 38 Hillside LS 39 Hillside LS 40 Hillside LS 41 Hillside LS 42 Drainfield LS 43 Drainfield LS 44 Drainfield LS 45 Drainfield LS 46 Drainfield LS 47 Blower Replacement 48 Blower Replacement 49 Repairs (tanks/castings/etc) 50 Repairs (tanks/castings/etc) Forcemain 51 Repairs (tanks/castings/etc) Forcemain 52 Drainfield Expansion (2024) SHA Addition 53 Total Capital ProjectsCAPITAL PROJECTS & DEBT LEVY4.00%4.00%4.00%4.00%4.00%4.00% 2028 2029 2030 2031 2032 2033 - - - - 92,367 - - - - - - - - - - - - - - - - - - - - - - - - - 1,316 1,369 1,423 1,480 - - - - - - 3,849 - - - - - - 1,601 - - - - - - - - - - - - - - - - - - 3,290 - - - - - - 684 712 740 770 801 - - - - - - - - - 8,141 - - 1,316 1,369 1,423 1,480 1,539 1,601 - - - 74,012 - - - - - - - - - - - - - - 5,922 3,422 3,558 85,854 98,525 4,003 FUND 612 FINANCIAL MANAGEMENT PLAN Uptown Sewer Fund Presented 11/15/2022 Joint City Council meeting Draft 2023 Sewer BudgetPg. 11 of 31 DRAFT 2023 Budget Actual Budget Actual Proposed TypeCode Description 2021 2022 6/30/2022 2023 % Bud Diff Notes and Descriptions 2023 Draft Proposed Line-Item Budget Detail FUND 612 SEWER - UPTOWN FUND R 612-31000 Washington Cty. Tax Settlement - - - - R 612-33422 Other State Grants & Aids 7 - - - R 612-34105 Sale of Maps and Publications - - - - R 612-34401 Sewer User Fees & Hookup 15,132 19,500 2,033 27,600 41.54% See Rate Study for breakdown R 612-36210 Interest Income 64 92 - 200 117.39% R 612-36250 Misc. Refund - - - - R 612-39203 Transfer from Other Funds - - - - TOTAL 612 REVENUE 15,203 19,592 2,033 27,800 41.89% Fund 612 EXPENSES E 612-43210-101 Regular Wages & Salaries 3,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 Contribution 219 600 231 600 0.00% " E 612-43210-126 MEDICARE Employer Contribution 50 100 58 100 0.00% " E 612-43210-131 Employer Paid Health - - - - " E 612-43210-134 Employer Paid Life - - - - " E 612-43210-135 Employer Paid Disability - - - - " E 612-43210-151 Worker s Comp Insurance Prem 217 - 295 200 " E 612-43210-200 Office Supplies 4 100 - 100 0.00% Office staff pulls from when needed for billing, notices E 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 Fees 7,272 300 - 1,000 233.33% annual drawdown testing E 612-43210-304 Legal Services - - - - E 612-43210-308 Other Professional Services 192 400 162 500 25.00% PACE testing E 612-43210-309 Software Support & Maintenance 80 - - - E 612-43210-311 Contract Permit Inspections - - - - Presented 11/15/2022 Joint City Council meetingPg. 12 of 31 DRAFT 2023 Budget Actual Budget Actual Proposed TypeCode Description 2021 2022 6/30/2022 2023 % Bud Diff Notes and Descriptions 2023 Draft Proposed Line-Item Budget Detail E 612-43210-317 Employee Training 275 350 - 350 0.00% E 612-43210-319 Other Services - - - - E 612-43210-322 Postage 18 - - - E 612-43210-334 Licenses & Permits 209 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 Ins 283 300 334 400 33.33% E 612-43210-381 Utilities-Electric & Gas 522 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/Equipment 767 1,500 - 2,000 33.33% Electrician if bad blower E 612-43210-420 Depreciation Expense 4,876 55,100 - 5,100 -90.74% Error in 2022 Budget to be amended drew number for Fund 602 E 612-43210-438 Misc. Contractual 100 1,200 448 1,300 8.33% E 612-43210-530 Capital Impr Other Than Bldgs.1,456 2,600 - 4,500 73.08% E 612-43210-570 Office Equipment - - - - E 612-43210-720 Operating Transfers - - - - TOTAL FUND 612 EXPENDITURES 19,581 76,850 6,563 31,450 -59.08% NET REVENUE OVER EXPENDITURES (4,378) (57,258) (4,530) 1,450 -102.53% (less depreciation) Presented 11/15/2022 Joint City Council meetingPg. 13 of 31 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. •This project is an unfunded mandate applied upon the City as part of MPCA’s re-permitting process for the WWTP. One of 8 test wells on site has been exceeding 10 mg/L despite the results from other neighboring wells have been well lower than the limit. The EPA implemented this limit to protect against blue-baby syndrome (Methemoglobinemia), a condition where a baby's skin turns blue. This happens when there is not enough oxygen in the blood. It can occur at birth or develop later in life. (Project is required to be completed by June 2025.) •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. Draft 11/15/2022 Sewer Budget Pg. 1 of 31 Pg. 14 of 31 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.48% increase in total revenue for a difference of $32,308. •2023 Expenses went down by 26.06% primarily due to limited scheduled capital improvements for a difference of -$58,662. Most substantial cost increase was for maintenance related to system pumping at approx.. $4,000. •This balanced budget incudes a projected and much needed $30,800 increase in fund balance. •Proposed 25% increase in rates (Base Charge and Energy Adjustments.) Draft 11/15/2022 Sewer Budget Pg. 15 of 31 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) or 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.) Submission of study must be done to score higher on the 2024 list. •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 local bonding or state grant. Draft 11/15/2022 Sewer Budget Pg. 16 of 31 DRAFT 2023 SEWER BUDGET Presented 11/15/2022 Joint City Council meeting 2022 2023 2024 2025 2026 2027 15.50%25.00%25.00%25.00%25.00%25.00% Base Charge Annual $987.28 $1,234.10 $1,542.63 $1,928.28 $2,410.35 $3,012.94 Quarterly $246.82 $308.53 $385.66 $482.07 $602.59 $753.23 % Change from PY 15.50%25.00%25.00%25.00%25.00%25.00% Increase (change over PY) Annual $132.88 $246.82 $308.53 $385.66 $482.07 $602.59 Quarterly $33.12 $61.71 $77.13 $96.41 $120.52 $150.65 Energy Adj Charge (Not Utility Rev) Annual $9.24 $11.55 $14.44 $18.05 $22.56 $28.20 Quarterly $2.31 $2.89 $3.61 $4.51 $5.64 $7.05 # of Customers 115 115 115 115 115 115 Total Year Revenue Estimate 113,537.20 141,921.50 177,401.88 221,752.34 277,190.43 346,488.04 Rounded Total Yr Est for Budget 113,500.00 141,900.00 177,400.00 221,800.00 277,200.00 346,500.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 Study Big Marine Sewer Projected Utility Rates (No State Bonding) Presented 11/15/2022 Joint City Council meeting DRAFT 2023 SEWER BUDGETPg. 17 of 31 DRAFT 2023 SEWER BUDGET Presented 11/15/2022 Joint City Council meeting 2028 2029 2030 2031 2032 25.00%15.50%15.50%15.50%13.25% Base Charge Annual $3,766.17 $4,349.93 $5,024.17 $5,802.92 $6,571.80 Quarterly $941.54 $1,087.48 $1,256.04 $1,450.73 $1,642.95 % Change from PY 25.00%15.50%15.50%15.50%13.25% Increase (change over PY) Annual $753.23 $583.76 $674.24 $778.75 $768.89 Quarterly $188.31 $145.94 $168.56 $194.69 $192.22 Energy Adj Charge (Not Utility Rev) Annual $35.25 $40.71 $47.02 $54.31 $61.51 Quarterly $8.81 $10.18 $11.76 $13.58 $15.38 # of Customers 115 115 115 115 115 Total Year Revenue Estimate 433,110.05 500,242.10 577,779.63 667,335.47 755,757.42 Rounded Total Yr Est for Budget 433,100.00 500,200.00 577,800.00 667,300.00 755,800.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. Scandia Utilities Utility Rate Study Big Marine Sewer Projected Utility Rates (No State Bonding)ing) * 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. Presented 11/15/2022 Joint City Council meeting DRAFT 2023 SEWER BUDGETPg. 18 of 31 DRAFT 2023 Sewer Budget Presented 11/15/2022 Joint City Council Meeting Inflation Assumptions 1 Revenue (Non-property tax) 2.00% 2.00% 2.00% 2.00% 2.00% 2 Inflation on rates 25.00% 25.00% 25.00% 25.00% 25.00% 3 Interest Earnings 1.50% 1.50% 1.50% 1.50% 1.50% 4 Expenses 3.00% 3.00% 3.00% 3.00% 3.00% 5 CIP Inflation Factor 0.00% 0.00% 4.00% 4.00% 4.00% 2023 2024 2025 2026 2027 Proposed Projected REVENUE 6 Charges for services 141,900 177,400 221,800 277,200 346,500 7 Special assessments 600 600 600 600 600 8 Intergovernmental 0 0 0 0 0 9 Interest 400 900 13,000 7,300 15,800 10 American Rescue Plan Act 456,400 0 0 0 11 State bonding 0 0 0 0 0 12 Miscellaneous 0 0 0 0 0 13 Total Revenue 142,900 635,300 235,400 285,100 362,900 EXPENSES 14 Wages 26,600 27,100 27,600 28,200 28,800 15 Materials 5,400 5,500 5,600 5,700 5,800 16 Professional services 24,400 24,900 25,400 25,900 26,400 17 Repair and maintenance 36,400 37,100 37,800 38,600 39,400 18 Other 9,500 9,700 9,900 10,100 10,300 19 Depreciation Expense 54,300 55,400 56,500 57,600 58,800 20 Debt service 0 0 100,500 100,500 184,300 21 Total Expenses 156,600 159,700 263,300 266,600 353,800 22 Revenue Over / (Under) Expenses (13,700)475,600 (27,900)18,500 9,100 OTHER FINANCING SOURCES / (USES) 23 Bond Proceeds 0 1,200,000 0 1,000,000 24 Transfers In 0 0 0 0 0 25 Purchase of capital assets (9,800) (919,800) (406,800) (511,900) (571,600) 26 Transfers Out- 27 Total Other Sources / (Uses)(9,800)280,200 (406,800)488,100 (571,600) 28 Change in balance sheet 29 Ending Cash 56,900 868,100 489,900 1,054,100 550,400 30 Target Cash 52,150 (126,550) 561,550 (248,450) 812,350 31 Over (Under) Target 4,750 994,650 (71,650) 1,302,550 (261,950) FUND 602 FINANCIAL MANAGEMENT PLAN BIG MARINE SEWER FUND FINACIAL MANAGEMENT PLANPresented 11/15/2022 Joint City Council Meeting Draft 2023 Sewer BudgetPg. 19 of 31 Revenue and Expense Prejections Compared to Fund Balance 0 200000 400000 600000 800000 1000000 1200000 1400000 1600000 1800000 2000000 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 Big Marine Sewer Revenue Expense Fund Balance * Conveys estimated revenue and expense based on utility rate study and the rates recommended. Spikes in revenue coincide with projected debt proceeds. Presented 11/15/2022 Joint City Council meeting Draft 2023 Sewer BudgetPg. 20 of 31 DRAFT 2023 Sewer Budget Presented 11/15/2022 Joint City Council Meeting Inflation Assumptions 1 Revenue (Non-property tax) 2 Inflation on rates 3 Interest Earnings 4 Expenses 5 CIP Inflation Factor REVENUE 6 Charges for services 7 Special assessments 8 Intergovernmental 9 Interest 10 American Rescue Plan Act 11 State bonding 12 Miscellaneous 13 Total Revenue EXPENSES 14 Wages 15 Materials 16 Professional services 17 Repair and maintenance 18 Other 19 Depreciation Expense 20 Debt service 21 Total Expenses 22 Revenue Over / (Under) Expenses OTHER FINANCING SOURCES / (USES) 23 Bond Proceeds 24 Transfers In 25 Purchase of capital assets 26 Transfers Out- 27 Total Other Sources / (Uses) 28 Change in balance sheet 29 Ending Cash 30 Target Cash 31 Over (Under) TargetFINACIAL MANAGEMENT PLAN2.00% 2.00% 2.00% 2.00% 2.00% 25.00% 15.50% 15.50% 15.50% 13.25% 1.50% 1.50% 1.50% 1.50% 1.50% 3.00% 3.00% 3.00% 3.00% 3.00% 4.00% 4.00% 4.00% 4.00% 4.00% 2028 2029 2030 2031 2032 433,100 500,200 577,800 667,300 755,800 600 600 600 600 600 0 0 0 0 0 8,300 4,800 15,300 10,800 14,700 442,000 505,600 593,700 678,700 771,100 29,400 30,000 30,600 31,200 31,800 5,900 6,000 6,100 6,200 6,300 26,900 27,400 27,900 28,500 29,100 40,200 41,000 41,800 42,600 43,500 10,500 10,700 10,900 11,100 11,300 60,000 61,200 62,400 63,600 64,900 184,300 184,300 284,800 284,800 184,300 357,200 360,600 464,500 468,000 371,200 84,800 145,000 129,200 210,700 399,900 0 1,200,000 0 0 0 0 0 0 (372,700) (705,500) (492,800) (19,600) (20,400) (372,700)494,500 (492,800) (19,600) (20,400) 322,500 1,023,200 722,000 976,700 ####### 614,550 (151,050) 837,400 364,200 266,900 (292,050) 1,174,250 (115,400) 612,500 ####### FUND 602 FINANCIAL MANAGEMENT PLAN BIG MARINE SEWER FUND Presented 11/15/2022 Joint City Council Meeting Draft 2023 Sewer BudgetPg. 21 of 31 DRAFT 2023 Budget Actual Budget Actual Proposed TypeCode Description 2021 2022 6/30/2022 2023 % Bud Diff Notes and Descriptions 2023 Draft Proposed Line-Item Budget Detail FUND 602 SEWER - BIG MARINE FUND R 602-31951 Special Assessments Principal - - - - R 602-31952 SA Penalties & Interest 624 - - - R 602-33422 Other State Grants & Aids 25 - - - 2020 Revenue was a FEMA reimbursement + $30,173 rec'd Sept. 2020 R 602-34401 Sewer User Fees & Hookup 98,531 109,592 36,000 141,900 29.48% See Rate Study for breakdown R 602-36100 Special Assessments - 300 - 600 100.00% R 602-36210 Interest Income 181 49 - 400 716.33% R 602-36250 Misc. Refund - - - - R 602-39200 Interfund Transfers In - - - - R 602-39310 Bond Proceeds - - - - TOTAL 602 REVENUE 99,361 109,941 36,000 142,900 29.98% Fund 602 EXPENSES E 602-43210-101 Regular Wages & Salaries 11,014 21,600 9,131 22,500 4.17% All wage and benefits a % share of employees completing utility operations work E 602-43210-102 OT Regular Wages 441 - - - " E 602-43210-120 Pension Expense (1,438) - - - " E 602-43210-121 PERA Coord. Employer Contribute.806 1,600 684 1,700 6.25% " E 602-43210-122 FICA Employer Contribution 684 1,300 528 1,400 7.69% " E 602-43210-126 MEDICARE Employer Contribution 156 300 136 300 0.00% " E 602-43210-131 Employer Paid Health - - - - " E 602-43210-134 Employer Paid Life - - - - " E 602-43210-135 Employer Paid Disability - - - - " E 602-43210-151 Worker s Comp Insurance Prem 422 900 1,180 700 -22.22% Change in formula results in lower projected cost share. E 602-43210-200 Office Supplies 109 200 85 200 0.00% E 602-43210-210 Operating Supplies 558 2,400 123 2,500 4.17% Additives to help break down the nitrogen - add to lift Station #2 -proposal E 602-43210-240 Small Tools and Minor Equip - 550 - 600 9.09% E 602-43210-303 Engineering Fees 13,277 10,400 8,081 10,500 0.96% Services related to project planning and operations of wastewater systems E 602-43210-304 Legal Services - - 4,800 - Lobbying expense form 2022 E 602-43210-308 Other Professional Services 3,376 2,200 2,397 2,500 13.64% PACE testing E 602-43210-309 Software Support & Maintenance 716 1,200 - 1,300 8.33% SCADA computer system Presented 11/15/2022 Joint City Council meetingPg. 22 of 31 DRAFT 2023 Budget Actual Budget Actual Proposed TypeCode Description 2021 2022 6/30/2022 2023 % Bud Diff Notes and Descriptions 2023 Draft Proposed Line-Item Budget Detail E 602-43210-311 Contract Permit Inspections - - - - E 602-43210-317 Employee Training 868 1,400 573 1,400 0.00% E 602-43210-321 Telephone 2,413 2,100 1,082 2,400 14.29% SCADA dialers E 602-43210-322 Postage - 550 200 600 9.09% E 602-43210-331 Travel Expenses 8 200 158 200 0.00% educational trips for 2 employees to maintain licensure E 602-43210-334 Licenses & Permits 1,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 Ins 1,039 900 1,003 3,000 233.33% Change in formula. E 602-43210-381 Utilities-Electric & Gas 1,862 2,500 1,043 2,500 0.00% Lift station and aeration electrical use. E 602-43210-385 Sewer Pumping & Maintenance 5,364 11,000 710 15,000 36.36% City has regular rotation of sludge removal of septic tanks E 602-43210-386 Operation & Maintenance 1,574 5,000 712 5,000 0.00% E 602-43210-404 Repair Machinery/Equipment 4,375 16,000 565 16,000 0.00% E 602-43210-413 Equipment Rental - 350 - 400 14.29% E 602-43210-420 Depreciation Expense 48,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. Contractual 3,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 9,800 -87.69% See Capital Improvement Plan E 602-43210-570 Office Equipment - - - - E 602-43210-601 Long Term Debt Principal (New Line might be GL)- - - - Lines added fto record future debt E 602-43210-611 Long Term Debt Interest (New Line)- - - - " E 602-43210-720 Operating Transfers - - - - TOTAL FUND 602 EXPENDITURES 101,243 225,062 80,912 166,400 -26.06% NET REVENUE OVER EXPENDITURES (1,882) (115,121) (44,913) 30,800 126.75% (less depreciation) Presented 11/15/2022 Joint City Council meetingPg. 23 of 31 DRAFT 2023 Sewer Budget Presented 11/15/2022 Joint City Council Meeting Inflation Assumptions 5 CIP Inflation Factor 0.00% 0.00% 4.00% 4.00% 4.00% 2021 2023 2024 2025 2026 2027 Line# Capital Project Name Cost Est.Proposed Projected Bliss Wastewater System 32 Bliss nitrate treatment upgrade project 910,000 - 910,000 - - - 33 Bliss nitrate treatment upgrade project 340,000 - - 397,752 - - 34 LS 1 Control Panel 10,000 - - - - 12,653 35 LS 1 Control Panel 1,500 - - - - - 36 LS 2 Control Panel 10,000 - - - 12,167 - 37 LS 2 Control Panel 1,500 - - - - - 38 LS 2 Control Panel 60,000 - - - - - 39 LS #1 (Layton Ave)500 - - - - - 40 LS #1 (Layton Ave)500 500 - - - - 41 LS #1 (Layton Ave)2,500 - 2,500 - - - 42 LS #1 (Layton Ave)500 - - 585 - - 43 LS #1 (Layton Ave)500 - - - 608 - 44 LS #1 (Layton Ave)385,000 - - - - 487,148 45 LS #1 (Layton Ave)500 - - - - - 46 LS #1 (Layton Ave)500 - - - - - 47 LS #1 (Layton Ave)500 - - - - - 48 LS #1 (Layton Ave)500 - - - - - 49 LS #1 (Layton Ave)2,500 - - - - - 50 LS #1 (Layton Ave)500 - - - - - 51 LS #1 (Layton Ave)2,500 - - - - - 52 LS #1 (Layton Ave)500 - - - - - 53 LS #1 (Layton Ave)500 - - - - - 54 LS #2 (189th - Main Station)500 - - - - - 55 LS #2 (189th - Main Station)2,500 2,500 - - - - 56 LS #2 (189th - Main Station)500 -500 - - - 57 LS #2 (189th - Main Station)500 - - 585 - - 58 LS #2 Main Station Rehab 350,000 - - - 425,829 - 59 LS #2 (189th - Main Station)500 - - - - 633 FUND 602 CAPITAL IMPROVEMENT PLAN BIG MARINE SEWER FUND CAPITAL OUTLAYPresented 11/15/2022 Joint City Council Meeting Draft 2023 Sewer BudgetPg. 24 of 31 DRAFT 2023 Sewer Budget Presented 11/15/2022 Joint City Council Meeting Inflation Assumptions 5 CIP Inflation Factor 2021 Line# Capital Project Name Cost Est. Bliss Wastewater System 32 Bliss nitrate treatment upgrade project 910,000 33 Bliss nitrate treatment upgrade project 340,000 34 LS 1 Control Panel 10,000 35 LS 1 Control Panel 1,500 36 LS 2 Control Panel 10,000 37 LS 2 Control Panel 1,500 38 LS 2 Control Panel 60,000 39 LS #1 (Layton Ave)500 40 LS #1 (Layton Ave)500 41 LS #1 (Layton Ave)2,500 42 LS #1 (Layton Ave)500 43 LS #1 (Layton Ave)500 44 LS #1 (Layton Ave)385,000 45 LS #1 (Layton Ave)500 46 LS #1 (Layton Ave)500 47 LS #1 (Layton Ave)500 48 LS #1 (Layton Ave)500 49 LS #1 (Layton Ave)2,500 50 LS #1 (Layton Ave)500 51 LS #1 (Layton Ave)2,500 52 LS #1 (Layton Ave)500 53 LS #1 (Layton Ave)500 54 LS #2 (189th - Main Station)500 55 LS #2 (189th - Main Station)2,500 56 LS #2 (189th - Main Station)500 57 LS #2 (189th - Main Station)500 58 LS #2 Main Station Rehab 350,000 59 LS #2 (189th - Main Station)500 CAPITAL OUTLAY4.00% 4.00% 4.00% 4.00% 4.00% 2028 2029 2030 2031 2032 - - - - - - - - - - - - - - - - - - - 2,309 - - - - - - - - 2,220 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 658 - - - - - 684 - - - - -712 - - - - - 740 - - - - - 3,849 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - FUND 602 CAPITAL IMPROVEMENT PLAN BIG MARINE SEWER FUND Presented 11/15/2022 Joint City Council Meeting Draft 2023 Sewer BudgetPg. 25 of 31 DRAFT 2023 Sewer Budget Presented 11/15/2022 Joint City Council Meeting Inflation Assumptions 5 CIP Inflation Factor 0.00% 0.00% 4.00% 4.00% 4.00% 2021 2023 2024 2025 2026 2027 Line# Capital Project Name Cost Est.Proposed Projected FUND 602 CAPITAL IMPROVEMENT PLAN BIG MARINE SEWER FUND 60 LS #2 (189th - Main Station)500 - - - - - 61 LS #2 (189th - Main Station)500 - - - - - 62 LS #2 (189th - Main Station)500 - - - - - 63 LS #2 (189th - Main Station)2,500 - - - - - 64 LS #2 (189th - Main Station)500 - - - - - 65 LS #2 (189th - Main Station)500 - - - - - 66 LS #2 (189th - Main Station)500 - - - - - 67 LS #2 (189th - Main Station)2,500 - - - - - 68 LS #2 (189th - Main Station)2,500 - - - - - 69 LS #3 Pump 1 Replacement 6,000 - - - - - 70 LS #3 Pump 2 Replacement 6,000 - - - - - 71 LS #3 (Dosage Tanks)500 - - - - - 72 LS #3 (Dosage Tanks)500 500 - - - - 73 LS #3 (Dosage Tanks)500 -500 - - - 74 LS #3 (Dosage Tanks)500 - - 585 - - 75 LS #3 (Dosage Tanks)2,500 - - - 3,042 - 76 LS #3 (Dosage Tanks)500 - - - - 633 77 LS #3 (Dosage Tanks)500 - - - - - 78 LS #3 (Dosage Tanks)500 - - - - - 79 LS #3 (Dosage Tanks)85,000 - - - - - 80 LS #3 (Dosage Tanks)2,500 - - - - - 81 LS #3 (Dosage Tanks)500 - - - - - 82 LS #3 (Dosage Tanks)500 - - - - - 83 LS #3 (Dosage Tanks)500 - - - - - 84 LS #3 (Dosage Tanks)500 - - - - - 85 LS #3 (Dosage Tanks)2,500 - - - - - 86 LS #4 Pump 1 Replacement 6,000 - - - - - 87 LS #4 Pump 2 Replacement 6,000 - - - - - 88 LS #4 (Dosage Tanks)500 - - - - - Presented 11/15/2022 Joint City Council Meeting Draft 2023 Sewer BudgetCAPITAL OUTLAYPg. 26 of 31 DRAFT 2023 Sewer Budget Presented 11/15/2022 Joint City Council Meeting Inflation Assumptions 5 CIP Inflation Factor 2021 Line# Capital Project Name Cost Est. 500 60 LS #2 (189th - Main Station) 500 62 LS #2 (189th - Main Station)500 63 LS #2 (189th - Main Station)2,500 64 LS #2 (189th - Main Station)500 65 LS #2 (189th - Main Station)500 66 LS #2 (189th - Main Station)500 67 LS #2 (189th - Main Station)2,500 68 LS #2 (189th - Main Station)2,500 69 LS #3 Pump 1 Replacement 6,000 70 LS #3 Pump 2 Replacement 6,000 71 LS #3 (Dosage Tanks)500 72 LS #3 (Dosage Tanks)500 73 LS #3 (Dosage Tanks)500 74 LS #3 (Dosage Tanks)500 75 LS #3 (Dosage Tanks)2,500 76 LS #3 (Dosage Tanks)500 77 LS #3 (Dosage Tanks)500 78 LS #3 (Dosage Tanks)500 79 LS #3 (Dosage Tanks)85,000 80 LS #3 (Dosage Tanks)2,500 81 LS #3 (Dosage Tanks)500 82 LS #3 (Dosage Tanks)500 83 LS #3 (Dosage Tanks)500 84 LS #3 (Dosage Tanks)500 85 LS #3 (Dosage Tanks)2,500 86 LS #4 Pump 1 Replacement 6,000 87 LS #4 Pump 2 Replacement 6,000 88 LS #4 (Dosage Tanks)500 4.00% 4.00% 4.00% 4.00% 4.00% 2028 2029 2030 2031 2032 FUND 602 CAPITAL IMPROVEMENT PLAN BIG MARINE SEWER FUND 658 - - - - - 684 - - - - -712 - - - - - 3,701 - - - - - 770 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 658 - - - - - 684 - - - - - 120,982 - - - - - 3,701 - - - - - 770 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Presented 11/15/2022 Joint City Council Meeting Draft 2023 Sewer Budget 61 LS #2 (189th - Main Station)CAPITAL OUTLAYPg. 27 of 31 DRAFT 2023 Sewer Budget Presented 11/15/2022 Joint City Council Meeting Inflation Assumptions 5 CIP Inflation Factor 0.00% 0.00% 4.00% 4.00% 4.00% 2021 2023 2024 2025 2026 2027 Line# Capital Project Name Cost Est.Proposed Projected FUND 602 CAPITAL IMPROVEMENT PLAN BIG MARINE SEWER FUND 89 LS #4 (Dosage Tanks)500 500 - - - - 90 LS #4 (Dosage Tanks)500 -500 - - - 91 LS #4 (Dosage Tanks)500 - - 585 - - 92 LS #4 (Dosage Tanks)2,500 - - - 3,042 - 93 LS #4 (Dosage Tanks)500 - - - - 633 94 LS #4 (Dosage Tanks)500 - - - - - 95 LS #4 (Dosage Tanks)500 - - - - - 96 LS #4 (Dosage Tanks)85,000 - - - - - 97 LS #4 (Dosage Tanks)500 - - - - - 98 LS #4 (Dosage Tanks)2,500 - - - - - 99 LS #4 (Dosage Tanks)500 - - - - - 100 LS #4 (Dosage Tanks)500 - - - - - 101 LS #4 (Dosage Tanks)500 - - - - - 102 LS #4 (Dosage Tanks)500 - - - - - 103 Repairs (tanks/castings/etc)2,500 2,500 2,500 2,925 3,042 3,163 104 Forcemain 500 500 500 585 - - 105 Forcemain 50,000 - - - 60,833 63,266 106 Forcemain 500 - - - - - 107 Forcemain 50,000 - - - - - 108 Forcemain 500 - - - - - 109 Forcemain 65,000 - - - - - 110 Forcemain 500 - - - - - 111 Forcemain 50,000 - - - - - 112 Forcemain 500 - - - - - 113 Nitrogen Treatment System Repair 130,000 - - - - - 114 Connection Metering 120,000 - - - - - 115 Connection meter equipment/software 25,000 - - - - - Presented 11/15/2022 Joint City Council Meeting Draft 2023 Sewer BudgetCAPITAL OUTLAYPg. 28 of 31 DRAFT 2023 Sewer Budget Presented 11/15/2022 Joint City Council Meeting Inflation Assumptions 5 CIP Inflation Factor 2021 Line# Capital Project Name Cost Est. Bliss Wastewater System89 LS #4 (Dosage Tanks)500 90 LS #4 (Dosage Tanks)500 91 LS #4 (Dosage Tanks)500 92 LS #4 (Dosage Tanks)2,500 93 LS #4 (Dosage Tanks)500 94 LS #4 (Dosage Tanks)500 95 LS #4 (Dosage Tanks)500 96 LS #4 (Dosage Tanks)85,000 97 LS #4 (Dosage Tanks)500 98 LS #4 (Dosage Tanks)2,500 99 LS #4 (Dosage Tanks)500 100 LS #4 (Dosage Tanks)500 101 LS #4 (Dosage Tanks)500 102 LS #4 (Dosage Tanks)500 103 Repairs (tanks/castings/etc)2,500 104 Forcemain 500 105 Forcemain 50,000 106 Forcemain 500 107 Forcemain 50,000 108 Forcemain 500 109 Forcemain 65,000 110 Forcemain 500 111 Forcemain 50,000 112 Forcemain 500 113 Nitrogen Treatment System Repair 130,000 114 Connection Metering 120,000 115 Connection meter equipment/software 25,000 4.00% 4.00% 4.00% 4.00% 4.00% 2028 2029 2030 2031 2032 FUND 602 CAPITAL IMPROVEMENT PLAN BIG MARINE SEWER FUND - - - - - - - - - - - - - - - - - - - - - - - - - 658 - - - - - 684 - - - - - 120,982 - - - - - 740 - - - - - 3,849 - - - - - - - - - - - - - - - - - - - - 3,290 3,421 3,558 3,701 3,849 - - - - - - - - - - 658 684 - - - - - 71,166 - - 658 684 - - - - - 92,515 - - - - - 740 770 - - - - - - - - - - 171,071 - - - - 157,912 - - - - 32,898 - - - - Presented 11/15/2022 Joint City Council Meeting Draft 2023 Sewer BudgetCAPITAL OUTLAYPg. 29 of 31 DRAFT 2023 Sewer Budget Presented 11/15/2022 Joint City Council Meeting Inflation Assumptions 5 CIP Inflation Factor 0.00% 0.00% 4.00% 4.00% 4.00% 2021 2023 2024 2025 2026 2027 Line# Capital Project Name Cost Est.Proposed Projected FUND 602 CAPITAL IMPROVEMENT PLAN BIG MARINE SEWER FUND Anderson-Erickson System 116 General Maintenance 1,000 1,000 1,000 1,170 1,217 1,265 117 General Maintenance 60,000 - - - - - 118 General Maintenance 1,000 - - - - - 119 General Maintenance 2,500 - - - - - 120 General Maintenance 1,000 - - - - - 121 A/E LS Controls 1,750 1,750 1,750 2,047 2,129 2,214 122 A/E LS Control Panel Upgrade 385,000 - - - - - 123 A/E LS Controls 1,750 - - - - - 124 A/E Repairs (tanks/castings/etc) Forcemain 65,000 - - - - - 125 A/E Repairs (tanks/castings/etc) Forcemain 55,000 - - - - - 126 Repairs of Meters 15,000 - - - - - 127 Connection meters: equipment &software - - - - - 143 Total Capital Projects 3,398,000 9,750 919,750 406,819 511,908 571,607 Presented 11/15/2022 Joint City Council Meeting Draft 2023 Sewer BudgetCAPITAL OUTLAYPg. 30 of 31 DRAFT 2023 Sewer Budget Presented 11/15/2022 Joint City Council Meeting Inflation Assumptions 5 CIP Inflation Factor 2021 Line# Capital Project Name Cost Est. Bliss Wastewater SystemAnderson-Erickson System 116 General Maintenance 1,000 117 General Maintenance 60,000 118 General Maintenance 1,000 119 General Maintenance 2,500 120 General Maintenance 1,000 121 A/E LS Controls 1,750 122 A/E LS Control Panel Upgrade 385,000 123 A/E LS Controls 1,750 124 A/E Repairs (tanks/castings/etc) Forcemain 65,000 125 A/E Repairs (tanks/castings/etc) Forcemain 55,000 126 Repairs of Meters 15,000 127 Connection meters: equipment &software 143 Total Capital Projects 3,398,000 4.00% 4.00% 4.00% 4.00% 4.00% 2028 2029 2030 2031 2032 FUND 602 CAPITAL IMPROVEMENT PLAN BIG MARINE SEWER FUND 1,316 - - - - - 82,114 - - - - - 1,423 1,480 1,539 - - - - - - - - - - 2,303 - - - - - 526,899 - - - - - 2,491 2,590 2,694 - 88,957 - - - - - 78,282 - - - - - - - - - - - - 372,738 705,496 492,821 19,613 20,398 Presented 11/15/2022 Joint City Council Meeting Draft 2023 Sewer BudgetCAPITAL OUTLAYPg. 31 of 31