Loading...
Big Marine Sewer Scenario B - State Bonding and ARPA ReceivedDRAFT 2022 UTILITIES BUDGET Scenario B - Full Funding w/ARPA and State Bond DRAFT Fund 602 YTD Actual 2019 2020 7/31/2021 2021 2022 2023 2024 2025 2026 REVENUE Charges for services - 85,518 45861 88,045 109,592 (1) 120,551 132,606 145,867 160,454 Special assessments 1,367 611 139 200 300 0 0 0 0 Intergovernmental 7 138 - - - (2) 715,000 0 0 0 Interest earnings 550 770 - 700 700 6,764 2,777 2,651 2,747 Miscellaneous - - - - - 0 0 0 0 City Bond Proceeds - - - - 415,000 (3) 415,000 0 0 700,000 Transfer In - - - - 441,852 (4) 0 0 0 0 TOTAL REVENUES 1,924 87,037 46,000 88,945 967,444 1,257,315 135,383 148,518 863,201 EXPENDITURES Wages 19,476 19,866 6,983 23,455 25,700 (5) 26,214 26,738 27,273 27,818 Materials 996 1,197 625 3,700 3,700 (5) 3,774 3,849 3,926 4,005 Professional Services 20,978 6,850 6,556 10,200 12,600 (5) 12,852 13,109 13,371 13,638 Repair and Maintenance 17,863 36,668 11,639 31,200 33,200 (5) 33,864 34,541 35,232 35,937 Other 19,072 13,772 4,061 18,250 18,050 (5) 18,411 18,779 19,155 19,538 Depreciation 39,630 42,643 - 51,200 52,200 (5) 53,244 54,309 55,395 56,503 Debt Service Expense - - - - - (6) - 33,518 33,518 33,518 Capital Outlay 23,276 - 29,000 70,980 (7) 1,427,983 13,217 9,652 449,250 Transfer Out - - - - - - - - - TOTAL EXPENDITURES (141,291) (120,996) (29,864) (167,005) (216,430) (1,576,342) (198,060) (197,522) (640,207) NET REVENUE OVER 1,482,292 (UNDER) EXPENSE (139,367) (33,959) 16,136 (78,060) 751,014 (319,028) (62,676) (49,003) 222,994 ENDING BALANCE 19,332 15,893 64,943 (10,967) 792,247 526,464 518,096 524,488 803,985 (1) (2) (3) (4) (5) Small inflationary and market adjustments to operational expenses. See budget detail page. (6) Debt service payments projected to being in 2024 for Big Marine Sewer (7) See attached DRAFT Capital Outlay for details. (8) There are no changes in 2022 based on either funding scenario. The changes only occur 2023 and forward. Projected 10% increase Projected for all future years. Debt payments projections to increase to $220K by 2031. Receipt of State Bond for Bliss Nitrate and Bliss Main Lift Station #2 Upgrade. Projected half the cost of project. Receipt of Bond proceeds from bonds issued by the City. Debt to be paid by users. Recommended allocation of ARPA Funds towards addressing financial shortfall in 602 CASH FLOW ANALYSIS SUMMARY BIG MARINE SEWER FUND SUMMARY BUDGET AND PROJECTIONS w/ STATE AID BONDING & ARPA FUNDING ACTUAL FOR YEAR ENDED DECEMBER 31, 2019 AND 2020, PERIOD TO DATE JULY 31, 2021 AND BUDGET FOR THE YEARS ENDED DECEMBER 31, 2021 & 2022, AND PROJECTIONS THRU YRS 2023-2026 Actual Budget Projected DRAFT 1 of 6 Presented 12/31/2021 2022 Draft Utilities Budget Scenario B - Full Funding w/ARPA and State Bond Draft 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 % Change in Rates 10.00%10.00%10.00%10.00%10.00%10.00%10.00%10.00%10.00%10.00% Base Charge Annual 897.56 987.32 1,086.05 1,194.65 1,314.12 1,445.53 1,590.08 1,749.09 1,924.00 2,116.40 2,328.04 Quarterly 224.39 246.83 271.51 298.66 328.53 361.38 397.52 437.27 481.00 529.10 582.01 Increase Annual 89.76 98.73 108.60 119.47 131.41 144.55 159.01 174.91 192.40 211.64 Quarterly 22.44 24.68 27.15 29.87 32.85 36.14 39.75 43.73 48.10 52.91 Energy Adj Charge Annual 8.00 8.80 9.68 10.65 11.71 12.88 14.17 15.59 17.15 18.86 20.75 Quarterly 2.00 2.20 2.42 2.66 2.93 3.22 3.54 3.90 4.29 4.72 5.19 Projected Revenue 99,629.16 109,592.08 120,551.28 132,606.41 145,867.05 160,453.76 176,499.13 194,149.05 213,563.95 234,920.35 258,412.38 Rates are applied over a total of 111 users of which Bliss has 79 and Anderson Erikson Has 32. Total Sewer Fee Over 10 Yrs.:$16,632.83 Average $ Yearly Increase over 10 Yrs.:$143.05 Current Est. for Private Drainfield Replacement:$17k-$20k Fund 602 Big Marine Sewer Scenario B -State Bonding and ARPA Received Draft 2 of 6 Presented 12/15/2021 DRAFT UTILITIES BUDGET Scenario B - Full Funding w/ARPA and State Bond DRAFT CIP Inflation Factor 0.00%4.00%4.00%4.00%4.00%4.00% 2021 2021 2022 2023 2024 2025 2026 Item #Capital Project Name First Year Costs Budget Budget Projected 1 Bliss facility flow meters to be replaced 2022 18,300.00 - 19,032 - - - - 2 Bliss Test Well #8 Abandonment/Replacement 2022 50,000.00 - 52,000 - - - - 3 Bliss nitrate treatment equipment 2023 960,000.00 - 1,038,336 - - - 4 LS 1 Control Panel 2027 10,000.00 - - - - - - 5 LS 2 Control Panel 2026 10,000.00 - - - - - 12,167 6 LS 2 Control Panel 2031 1,500.00 - - - - - 7 LS #1 (Layton Ave) 2022 500.00 - 520 - - - - 8 LS #1 (Layton Ave) 2023 500.00 - - 541 - - - 9 LS #1 (Layton Ave) 2024 2,500.00 - - 2,812 - - 10 LS #1 (Layton Ave) 2025 500.00 11 LS #1 (Layton Ave) 2026 500.00 - - - - - 608 12 LS #1 (Layton Ave) Rehab 2027 350,000.00 - - - - - - 13 LS #1 (Layton Ave) 2028 500.00 - - - - - - 14 LS #1 (Layton Ave) 2029 500.00 - - - - - - 15 LS #1 (Layton Ave) 2030 500.00 - - - - - 16 LS #1 (Layton Ave) 2031 500.00 - - - - - - 17 LS #2 (189th - Main Station) 2022 500.00 - 520 - - - - 18 LS #2 (189th - Main Station) 2023 2,500.00 - 2,704 - - - 19 LS #2 (189th - Main Station) 2024 500.00 - - - 562 - - 20 LS #2 (189th - Main Station) 2025 500.00 - - - - 585 - 21 LS #2 (189th - Main Station) 2023 350,000.00 - 378,560 - - - 22 LS #2 (189th - Main Station) 2027 500.00 23 LS #2 (189th - Main Station) 2028 500.00 - - - - - - 24 LS #2 (189th - Main Station) 2029 500.00 - - - - - - 25 LS #2 (189th - Main Station) 2030 500.00 - - - - - - 26 LS #2 (189th - Main Station) 2031 2,500.00 - - - - - - 27 LS #3 Pump 1 Replacement 2021 6,000.00 - - - - - 28 LS #3 Pump 2 Replacement 2021 6,000.00 6,000 - - - - - 29 LS #3 (Dosage Tanks) 2022 500.00 - 520 - - - - 30 LS #3 (Dosage Tanks) 2023 500.00 - 541 - - - 31 LS #3 (Dosage Tanks) 2024 500.00 - - - 562 - - 32 LS #3 (Dosage Tanks) 2025 500.00 - - - - 585 - 33 LS #3 (Dosage Tanks) 2026 2,500.00 - - - - 3,042 34 LS #3 (Dosage Tanks) 2027 500.00 35 LS #3 (Dosage Tanks) 2028 500.00 - - - - - - 36 LS #3 (Dosage Tanks) 2029 500.00 - - - - - - 37 LS #3 (Dosage Tanks) 2030 70,000.00 - - - - - - 38 LS #3 (Dosage Tanks) 2031 2,500.00 - - - - - - 39 LS #4 Pump 1 Replacement 2021 6,000.00 - - - - - 40 LS #4 Pump 2 Replacement 2021 6,000.00 6,000 - - - - - 41 LS #4 (Dosage Tanks) 2022 500.00 - 520 - - - - 42 LS #4 (Dosage Tanks) 2023 500.00 - 541 - - - 43 LS #4 (Dosage Tanks) 2024 500.00 - - - 562 - - 44 LS #4 (Dosage Tanks) 2025 500.00 - - - - 585 - 45 LS #4 (Dosage Tanks) 2026 500.00 - - - - 608 46 LS #4 (Dosage Tanks) 2027 2,500.00 47 LS #4 (Dosage Tanks) 2028 500.00 - - - - - - 48 LS #4 (Dosage Tanks) 2029 500.00 - - - - - - 49 LS #4 (Dosage Tanks) 2031 500.00 - - - - - - 50 LS #4 (Dosage Tanks) 2030 70,000.00 - - - - - - 51 Repairs 2022 2,500.00 - 2,704 2,812 2,925 3,042 Project Big Marine Sewer Capital Improvement Outlay Full Funding Scenario B with ARPA & State Bond Grant DRAFT 3 of 6 Presented 12/15/2021 DRAFT UTILITIES BUDGET Scenario B - Full Funding w/ARPA and State Bond DRAFT CIP Inflation Factor 0.00%4.00%4.00%4.00%4.00%4.00% 2021 2021 2022 2023 2024 2025 2026 Item #Capital Project Name First Year Costs Budget Budget Projected Project Big Marine Sewer Capital Improvement Outlay Full Funding Scenario B with ARPA & State Bond Grant 52 Forcemain 2022 500.00 - - 541 562 585 - 53 Forcemain 2026 50,000.00 - - - - - - 54 Forcemain 2028 500.00 - - - - - 55 Forcemain 2030 50,000.00 - - - - - - 56 Forcemain 2028 5,000.00 - - - - - - 57 Forcemain 2031 500.00 - - - - - 58 Connection metering 2028 120,000.00 59 Connection meter equipment 2028 25,000.00 - - - - - - 60 A/E control panel 2029 50,000.00 - - - - - - 61 A/E LS 2022 1,000.00 - 1,082 - - - 62 A/E LS 2024 2,500.00 63 A/E LS 2025 1,000.00 - - - - - 1,217 64 A/E LS 2029 350,000.00 - - - - - - 65 A/E LS 2030 1,000.00 - - - - - - 66 A/E repairs 2022 1,750.00 - 1,893 1,969 2,047 2,129 67 A/E forcemain 2022 500.00 - - 541 562 585 608 68 A/E forcemain 2029 50,000.00 - - - - - - 69 A/E forcemain 2030 500.00 - - - - - 70 A/E connection metering and software 2030 65,000.00 - - - - - - 71 Drainfield Improvements 2026 300,000.00 - - - - - 364,996 72 - - - - - - - - 73 - - - 74 - - - - - - - - - 75 - - - - - - - - - 76 - - - - - - - - - 77 - - - - - - - - 78 Total Capital Projects 3,021,050 12,000 73,112 1,427,983 10,404 7,897 388,417 DRAFT 4 of 6 Presented 12/15/2021 DRAFT UTILITIES BUDGET Scenario B - Full Funding w/ARPA and State Bond DRAFT CIP Inflation Factor 2021 Item #Capital Project Name First Year Costs 1 Bliss facility flow meters to be replaced 2022 18,300.00 2 Bliss Test Well #8 Abandonment/Replacement 2022 50,000.00 3 Bliss nitrate treatment equipment 2023 960,000.00 4 LS 1 Control Panel 2027 10,000.00 5 LS 2 Control Panel 2026 10,000.00 6 LS 2 Control Panel 2031 1,500.00 7 LS #1 (Layton Ave) 2022 500.00 8 LS #1 (Layton Ave) 2023 500.00 9 LS #1 (Layton Ave) 2024 2,500.00 10 LS #1 (Layton Ave) 2025 500.00 11 LS #1 (Layton Ave) 2026 500.00 12 LS #1 (Layton Ave) Rehab 2027 350,000.00 13 LS #1 (Layton Ave) 2028 500.00 14 LS #1 (Layton Ave) 2029 500.00 15 LS #1 (Layton Ave) 2030 500.00 16 LS #1 (Layton Ave) 2031 500.00 17 LS #2 (189th - Main Station) 2022 500.00 18 LS #2 (189th - Main Station) 2023 2,500.00 19 LS #2 (189th - Main Station) 2024 500.00 20 LS #2 (189th - Main Station) 2025 500.00 21 LS #2 (189th - Main Station) 2023 350,000.00 22 LS #2 (189th - Main Station) 2027 500.00 23 LS #2 (189th - Main Station) 2028 500.00 24 LS #2 (189th - Main Station) 2029 500.00 25 LS #2 (189th - Main Station) 2030 500.00 26 LS #2 (189th - Main Station) 2031 2,500.00 27 LS #3 Pump 1 Replacement 2021 6,000.00 28 LS #3 Pump 2 Replacement 2021 6,000.00 29 LS #3 (Dosage Tanks) 2022 500.00 30 LS #3 (Dosage Tanks) 2023 500.00 31 LS #3 (Dosage Tanks) 2024 500.00 32 LS #3 (Dosage Tanks) 2025 500.00 33 LS #3 (Dosage Tanks) 2026 2,500.00 34 LS #3 (Dosage Tanks) 2027 500.00 35 LS #3 (Dosage Tanks) 2028 500.00 36 LS #3 (Dosage Tanks) 2029 500.00 37 LS #3 (Dosage Tanks) 2030 70,000.00 38 LS #3 (Dosage Tanks) 2031 2,500.00 39 LS #4 Pump 1 Replacement 2021 6,000.00 40 LS #4 Pump 2 Replacement 2021 6,000.00 41 LS #4 (Dosage Tanks) 2022 500.00 42 LS #4 (Dosage Tanks) 2023 500.00 43 LS #4 (Dosage Tanks) 2024 500.00 44 LS #4 (Dosage Tanks) 2025 500.00 45 LS #4 (Dosage Tanks) 2026 500.00 46 LS #4 (Dosage Tanks) 2027 2,500.00 47 LS #4 (Dosage Tanks) 2028 500.00 48 LS #4 (Dosage Tanks) 2029 500.00 49 LS #4 (Dosage Tanks) 2031 500.00 50 LS #4 (Dosage Tanks) 2030 70,000.00 51 Repairs 2022 2,500.00 Project Big Marine Sewer Capital Improvement Outlay Full Funding Scenario B with ARPA & State Bond Grant 4.00%4.00%4.00%4.00%4.00% 2027 2028 2029 2030 2031 - - - - - - - - - - - - - - - 12,653 - - - - - - - - - - - - - 2,220 - - - - - - - - - - - - - - - - - - - - 442,862 - - - - - 658 - - - - - 684 - - - - - 712 - - - - - 740 - - - - - - - - - - - - - - - - - - - - - - - - - - 658 - - - - - 684 - - - - - 712 - - - - - 3,701 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 658 - - - - - 684 - - - - - 99,632 - - - - - 3,701 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 658 - - - - - 684 - - - - - - 740 - - - 99,632 - 3,163 3,290 3,421 3,558 3,701 DRAFT 5 of 6 Presented 12/15/2021 DRAFT UTILITIES BUDGET Scenario B - Full Funding w/ARPA and State Bond DRAFT CIP Inflation Factor 2021 Item #Capital Project Name First Year Costs 1 Bliss facility flow meters to be replaced 2022 18,300.00 Project Big Marine Sewer Capital Improvement Outlay Full Funding Scenario B with ARPA & State Bond Grant 52 Forcemain 2022 500.00 53 Forcemain 2026 50,000.00 54 Forcemain 2028 500.00 55 Forcemain 2030 50,000.00 56 Forcemain 2028 5,000.00 57 Forcemain 2031 500.00 58 Connection metering 2028 120,000.00 59 Connection meter equipment 2028 25,000.00 60 A/E control panel 2029 50,000.00 61 A/E LS 2022 1,000.00 62 A/E LS 2024 2,500.00 63 A/E LS 2025 1,000.00 64 A/E LS 2029 350,000.00 65 A/E LS 2030 1,000.00 66 A/E repairs 2022 1,750.00 67 A/E forcemain 2022 500.00 68 A/E forcemain 2029 50,000.00 69 A/E forcemain 2030 500.00 70 A/E connection metering and software 2030 65,000.00 71 Drainfield Improvements 2026 300,000.00 72 - - - 73 - - - 74 - - - 75 - - - 76 - - - 77 - - - 78 Total Capital Projects 3,021,050 4.00%4.00%4.00%4.00%4.00% 2027 2028 2029 2030 2031 - - - - - 63,266 - - - - - - 684 - - - - - 71,166 - - 6,580 - - - - - - - 740 - 32,898 - - - - - 68,428 - - - - - - - 1,265 1,316 - - - - - 478,999 - - - - - - 1,480 2,214 2,303 2,395 2,491 2,590 633 658 - - - - - 68,428 - - - - - - 740 - - - 92,515 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 526,056 49,677 625,093 370,417 20,353 DRAFT 6 of 6 Presented 12/15/2021