Loading...
5.a2 Draft 2021 Big Marine Sewer Budget - Scenario B Full FundingDRAFT 2022 UTILITIES BUDGET Scenario B - Full Funding w/ARPA and State Bond DRAFT Fund 602 YTD Actual Est. YE Budget 2019 2020 7/31/2021 2021 2022 2023 2024 2025 2026 REVENUE Charges for services 81,238 85,518 45,861 99,629 109,592 (1) 120,551 132,606 145,867 160,454 Special assessments 4,824 611 139 150 300 0 0 0 0 Intergovernmental 35 138 - - - (2) 715,000 0 0 0 Interest earnings 3,226 770 - 700 35 414 142 131 135 Miscellaneous - - - - - 0 0 0 0 City Bond Proceeds - - - - - (3) 415,000 0 0 700,000 Transfer In - - - - 441,852 (4) 0 0 0 0 TOTAL REVENUES 89,323 87,037 46,000 100,479 551,780 1,250,966 132,749 145,998 860,589 EXPENDITURES Wages 19,476 19,866 6,983 11,665 25,700 (5) 26,214 26,738 27,273 27,818 Materials 996 1,197 625 667 3,700 (5) 3,774 3,849 3,926 4,005 Professional Services 20,978 6,850 6,556 11,850 12,600 (5) 12,852 13,109 13,371 13,638 Repair and Maintenance 17,863 36,668 11,639 17,003 33,200 (5) 33,864 34,541 35,232 35,937 Other 19,072 13,772 4,061 10,033 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 - 24,000 70,980 (7) 1,427,983 13,217 9,652 449,250 Transfer Out - - - - - - - - - TOTAL EXPENDITURES (141,291) (120,996) (29,864) (126,419) (216,430) (1,576,342) (198,060) (197,522) (640,207) NET REVENUE OVER (UNDER) EXPENSE (51,968) (33,959) 16,136 (25,939) 335,350 (325,377) (65,311) (51,523) 220,382 ENDING BALANCE 19,332 15,893 64,943 41,154 428,703 156,570 145,568 149,440 426,325 (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 Projected DRAFT 1 of 8 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 8 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% 2021 2021 2022 2023 2024 2025 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 - - - - - 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 - - - - 585 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 - 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 - - - - 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 - - - - 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 - - - - - Project Big Marine Sewer Capital Improvement Outlay Full Funding Scenario B with ARPA & State Bond Grant DRAFT 3 of 8 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% 2021 2021 2022 2023 2024 2025 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 51 Repairs 2022 2,500.00 - 2,704 2,812 2,925 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 - - - 2,812 - 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 - 1,893 1,969 2,047 67 A/E forcemain 2022 500.00 - - 541 562 585 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 12,000 73,112 1,427,983 13,217 8,482 DRAFT 4 of 8 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 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% 2026 2027 2028 2029 2030 - - - - - - - - - - - - - - - - 12,653 - - - 12,167 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 608 - - - - - 442,862 - - - - - 658 - - - - - 684 - - - - - 712 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 633 - - - - - 658 - - - - - 684 - - - - - 712 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 3,042 - - - - - 633 - - - - - 658 - - - - - 684 - - - - - 99,632 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 608 - - - - - 3,163 - - - - - 658 - - - - - 684 - - - - - - - - - - 99,632 DRAFT 5 of 8 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 51 Repairs 2022 2,500.00 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% 2026 2027 2028 2029 2030 3,042 3,163 3,290 3,421 3,558 - - - - - - 63,266 - - - - - - 684 - - - - - 71,166 - - 6,580 - - - - - - - - - 157,912 - - - - 32,898 - - - - - 68,428 - - - - - - - - - - - 1,217 1,265 1,316 - - - - - 478,999 - - - - - - 2,129 2,214 2,303 2,395 2,491 608 633 658 - - - - - 68,428 - - - - - - - - - - 92,515 364,996 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 388,417 530,484 207,589 625,093 370,417 DRAFT 6 of 8 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 Project Big Marine Sewer Capital Improvement Outlay Full Funding Scenario B with ARPA & State Bond Grant 4.00% 2031 - - - - - 2,220 - - - - - - - - - 740 - - - - - - - - - 3,701 - - - - - - - - - - - 3,701 - - - - - - - - - - 740 - DRAFT 7 of 8 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 51 Repairs 2022 2,500.00 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% 2031 3,701 - - - - - 740 - - - - - - - 1,480 2,590 - - 740 - - - - - - - - 20,353 DRAFT 8 of 8 Presented 12/15/2021