Loading...
5.a4 Draft 2021 Big Marine Sewer Budget - Scenario D No Aid.pdfDRAFT 2022 UTILITIES BUDGET Scenario D - No Financial Aid DRAFT Fund 602 YTD Actual Proj Budget 2019 2020 7/31/2021 2021 2022 2023 2024 2025 2026 REVENUE Charges for services - 85,518 45861 88,045 121,548 (1) $149,504 $186,879 $233,599 $291,999 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 35 $17 $145 $194 $281 Miscellaneous - - - - - $0 $0 $0 $0 City Bond Proceeds - - - - - (3) $23,276 $0 $0 $470,000 Transfer In - - - - - (4) $0 $0 $0 $0 TOTAL REVENUES 1,924 87,037 46,000 88,945 121,883 887,797 187,024 233,794 762,280 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) - 60,575 60,575 60,575 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) (225,116) (224,579) (667,264) NET REVENUE OVER (UNDER) EXPENSE (139,367) (33,959) 16,136 (78,060) (94,547) (688,546) (38,092) 9,215 95,017 ENDING BALANCE 19,332 15,893 64,943 (10,967) (53,314) (688,615) (672,399) (607,789) (456,269) (1) (2) (3) (4) (5) Small inflationary and market adjustments to operational expenses. See budget detail page. (6) Debt service payments projected to begin 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. 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 WITH NO STATE FINANCIAL AID 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 Projected 10% increase Projected for all future years. Debt payments projections to increase to $220K by 2031. DRAFT 1 of 8 Presented 12/15/2021 2022 Draft Utilities Budget Scenario D - No Financial Aid Draft 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 % Change in Rates 22.00%23.00%25.00%25.00%25.00%24.00%24.00%5.00%5.00%5.00% Base Charge Annual 897.56 1,095.02 1,346.88 1,683.60 2,104.50 2,630.62 3,261.97 4,044.84 4,247.09 4,459.44 4,682.41 Quarterly 224.39 273.76 336.72 420.90 526.12 657.66 815.49 1,011.21 1,061.77 1,114.86 1,170.60 Increase Annual 197.46 251.86 336.72 420.90 526.12 631.35 782.87 202.24 212.35 222.97 Quarterly 49.37 62.96 84.18 105.22 131.53 157.84 195.72 50.56 53.09 55.74 Energy Adj Charge Annual 8.00 9.76 12.00 15.01 18.76 23.45 29.07 36.05 37.85 39.75 41.73 Quarterly 2.00 2.44 3.00 3.75 4.69 5.86 7.27 9.01 9.46 9.94 10.43 Projected Revenue 99,629.16 121,547.58 149,503.52 186,879.40 233,599.25 291,999.06 362,078.83 448,977.75 471,426.64 494,997.97 519,747.87 Average $ Yearly Increase over 10 Yrs.:$378.49 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.:$30,453.94 Current Est. for Private Drainfield Replacement:$17k-$20k Fund 602 Big Marine Sewer Scenario D - No Financial Aid Draft 2 of 8 Presented 12/15/2021 DRAFT UTILITIES BUDGET Scenario D - No Financial Aid 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 2,022.00 18,300.00 - 19,032 - - - 2 Bliss Test Well #8 Abandonment/Replacement 2,022.00 50,000.00 - 52,000 - - - 3 Bliss nitrate treatment equipment 2,023.00 960,000.00 - 1,038,336 - - 4 LS 1 Control Panel 2,027.00 10,000.00 - - - - - 5 LS 2 Control Panel 2,026.00 10,000.00 - - - - - 6 LS 2 Control Panel 2,031.00 1,500.00 - - - - 7 LS #1 (Layton Ave) 2,022.00 500.00 - 520 - - - 8 LS #1 (Layton Ave) 2,023.00 500.00 - - 541 - - 9 LS #1 (Layton Ave) 2,024.00 2,500.00 - - 2,812 - 10 LS #1 (Layton Ave) 2,025.00 500.00 - - - - 585 11 LS #1 (Layton Ave) 2,026.00 500.00 - - - - - 12 LS #1 (Layton Ave) Rehab 2,027.00 350,000.00 - - - - - 13 LS #1 (Layton Ave) 2,028.00 500.00 - - - - - 14 LS #1 (Layton Ave) 2,029.00 500.00 - - - - - 15 LS #1 (Layton Ave) 2,030.00 500.00 - - - - 16 LS #1 (Layton Ave) 2,031.00 500.00 - - - - - 17 LS #2 (189th - Main Station) 2,022.00 500.00 - 520 - - - 18 LS #2 (189th - Main Station) 2,023.00 2,500.00 - 2,704 - - 19 LS #2 (189th - Main Station) 2,024.00 500.00 - - - 562 - 20 LS #2 (189th - Main Station) 2,025.00 500.00 - - - - 585 21 LS #2 (189th - Main Station) 2,023.00 350,000.00 - 378,560 - - 22 LS #2 (189th - Main Station) 2,027.00 500.00 - - - - - 23 LS #2 (189th - Main Station) 2,028.00 500.00 - - - - - 24 LS #2 (189th - Main Station) 2,029.00 500.00 - - - - - 25 LS #2 (189th - Main Station) 2,030.00 500.00 - - - - - 26 LS #2 (189th - Main Station) 2,031.00 2,500.00 - - - - - 27 LS #3 Pump 1 Replacement 2,021.00 6,000.00 - - - - 28 LS #3 Pump 2 Replacement 2,021.00 6,000.00 6,000 - - - - 29 LS #3 (Dosage Tanks) 2,022.00 500.00 - 520 - - - 30 LS #3 (Dosage Tanks) 2,023.00 500.00 - 541 - - 31 LS #3 (Dosage Tanks) 2,024.00 500.00 - - - 562 - 32 LS #3 (Dosage Tanks) 2,025.00 500.00 - - - - 585 33 LS #3 (Dosage Tanks) 2,026.00 2,500.00 - - - - 34 LS #3 (Dosage Tanks) 2,027.00 500.00 - - - - 35 LS #3 (Dosage Tanks) 2,028.00 500.00 - - - - - 36 LS #3 (Dosage Tanks) 2,029.00 500.00 - - - - - 37 LS #3 (Dosage Tanks) 2,030.00 70,000.00 - - - - - 38 LS #3 (Dosage Tanks) 2,031.00 2,500.00 - - - - - 39 LS #4 Pump 1 Replacement 2,021.00 6,000.00 - - - - 40 LS #4 Pump 2 Replacement 2,021.00 6,000.00 6,000 - - - - 41 LS #4 (Dosage Tanks) 2,022.00 500.00 - 520 - - - 42 LS #4 (Dosage Tanks) 2,023.00 500.00 - 541 - - 43 LS #4 (Dosage Tanks) 2,024.00 500.00 - - - 562 - 44 LS #4 (Dosage Tanks) 2,025.00 500.00 - - - - 585 45 LS #4 (Dosage Tanks) 2,026.00 500.00 - - - - 46 LS #4 (Dosage Tanks) 2,027.00 2,500.00 47 LS #4 (Dosage Tanks) 2,028.00 500.00 - - - - - 48 LS #4 (Dosage Tanks) 2,029.00 500.00 - - - - - 49 LS #4 (Dosage Tanks) 2,031.00 500.00 - - - - - 50 LS #4 (Dosage Tanks) 2,030.00 70,000.00 - - - - - Project Big Marine Sewer Capital Improvement Outlay Full Funding Scenario D No Financial Aid DRAFT 3 of 8 Presented 12/15/2021 DRAFT UTILITIES BUDGET Scenario D - No Financial Aid 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 D No Financial Aid 51 Repairs 2,022.00 2,500.00 - 2,704 2,812 2,925 52 Forcemain 2,022.00 500.00 - - 541 562 585 53 Forcemain 2,026.00 50,000.00 - - - - - 54 Forcemain 2,028.00 500.00 - - - - 55 Forcemain 2,030.00 50,000.00 - - - - - 56 Forcemain 2,028.00 5,000.00 - - - - - 57 Forcemain 2,031.00 500.00 - - - - 58 Connection metering 2,028.00 120,000.00 - - - - - 59 Connection meter equipment 2,028.00 25,000.00 - - - - 60 A/E control panel 2,029.00 50,000.00 - - - - - 61 A/E LS 2,022.00 1,000.00 - 1,082 - - 62 A/E LS 2,024.00 2,500.00 63 A/E LS 2,025.00 1,000.00 - - - - - 64 A/E LS 2,029.00 350,000.00 - - - - - 65 A/E LS 2,030.00 1,000.00 - - - - - 66 A/E repairs 2,022.00 1,750.00 - 1,893 1,969 2,047 67 A/E forcemain 2,022.00 500.00 - - 541 562 585 68 A/E forcemain 2,029.00 50,000.00 - - - - - 69 A/E forcemain 2,030.00 500.00 - - - - 70 A/E connection metering and software 2,030.00 65,000.00 - - - - - 71 Drainfield Improvements 2,026.00 300,000.00 - - - - - 72 - - - - - 73 - - - - - 74 - - - - - 75 - - - - 76 - - - - - 77 - - - - - 78 Total Capital Projects 3,021,050 12,000 73,112 1,427,983 10,404 8,482 DRAFT 4 of 8 Presented 12/15/2021 DRAFT UTILITIES BUDGET Scenario D - No Financial Aid DRAFT CIP Inflation Factor 2021 Item #Capital Project Name First Year Costs 1 Bliss facility flow meters to be replaced 2,022.00 18,300.00 2 Bliss Test Well #8 Abandonment/Replacement 2,022.00 50,000.00 3 Bliss nitrate treatment equipment 2,023.00 960,000.00 4 LS 1 Control Panel 2,027.00 10,000.00 5 LS 2 Control Panel 2,026.00 10,000.00 6 LS 2 Control Panel 2,031.00 1,500.00 7 LS #1 (Layton Ave) 2,022.00 500.00 8 LS #1 (Layton Ave) 2,023.00 500.00 9 LS #1 (Layton Ave) 2,024.00 2,500.00 10 LS #1 (Layton Ave) 2,025.00 500.00 11 LS #1 (Layton Ave) 2,026.00 500.00 12 LS #1 (Layton Ave) Rehab 2,027.00 350,000.00 13 LS #1 (Layton Ave) 2,028.00 500.00 14 LS #1 (Layton Ave) 2,029.00 500.00 15 LS #1 (Layton Ave) 2,030.00 500.00 16 LS #1 (Layton Ave) 2,031.00 500.00 17 LS #2 (189th - Main Station) 2,022.00 500.00 18 LS #2 (189th - Main Station) 2,023.00 2,500.00 19 LS #2 (189th - Main Station) 2,024.00 500.00 20 LS #2 (189th - Main Station) 2,025.00 500.00 21 LS #2 (189th - Main Station) 2,023.00 350,000.00 22 LS #2 (189th - Main Station) 2,027.00 500.00 23 LS #2 (189th - Main Station) 2,028.00 500.00 24 LS #2 (189th - Main Station) 2,029.00 500.00 25 LS #2 (189th - Main Station) 2,030.00 500.00 26 LS #2 (189th - Main Station) 2,031.00 2,500.00 27 LS #3 Pump 1 Replacement 2,021.00 6,000.00 28 LS #3 Pump 2 Replacement 2,021.00 6,000.00 29 LS #3 (Dosage Tanks) 2,022.00 500.00 30 LS #3 (Dosage Tanks) 2,023.00 500.00 31 LS #3 (Dosage Tanks) 2,024.00 500.00 32 LS #3 (Dosage Tanks) 2,025.00 500.00 33 LS #3 (Dosage Tanks) 2,026.00 2,500.00 34 LS #3 (Dosage Tanks) 2,027.00 500.00 35 LS #3 (Dosage Tanks) 2,028.00 500.00 36 LS #3 (Dosage Tanks) 2,029.00 500.00 37 LS #3 (Dosage Tanks) 2,030.00 70,000.00 38 LS #3 (Dosage Tanks) 2,031.00 2,500.00 39 LS #4 Pump 1 Replacement 2,021.00 6,000.00 40 LS #4 Pump 2 Replacement 2,021.00 6,000.00 41 LS #4 (Dosage Tanks) 2,022.00 500.00 42 LS #4 (Dosage Tanks) 2,023.00 500.00 43 LS #4 (Dosage Tanks) 2,024.00 500.00 44 LS #4 (Dosage Tanks) 2,025.00 500.00 45 LS #4 (Dosage Tanks) 2,026.00 500.00 46 LS #4 (Dosage Tanks) 2,027.00 2,500.00 47 LS #4 (Dosage Tanks) 2,028.00 500.00 48 LS #4 (Dosage Tanks) 2,029.00 500.00 49 LS #4 (Dosage Tanks) 2,031.00 500.00 50 LS #4 (Dosage Tanks) 2,030.00 70,000.00 Project Big Marine Sewer Capital Improvement Outlay Full Funding Scenario D No Financial Aid 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 - - - - - - 658 - - - - - 684 - - - - - - - - - - 99,632 DRAFT 5 of 8 Presented 12/15/2021 DRAFT UTILITIES BUDGET Scenario D - No Financial Aid DRAFT CIP Inflation Factor 2021 Item #Capital Project Name First Year Costs 1 Bliss facility flow meters to be replaced 2,022.00 18,300.00 Project Big Marine Sewer Capital Improvement Outlay Full Funding Scenario D No Financial Aid 51 Repairs 2,022.00 2,500.00 52 Forcemain 2,022.00 500.00 53 Forcemain 2,026.00 50,000.00 54 Forcemain 2,028.00 500.00 55 Forcemain 2,030.00 50,000.00 56 Forcemain 2,028.00 5,000.00 57 Forcemain 2,031.00 500.00 58 Connection metering 2,028.00 120,000.00 59 Connection meter equipment 2,028.00 25,000.00 60 A/E control panel 2,029.00 50,000.00 61 A/E LS 2,022.00 1,000.00 62 A/E LS 2,024.00 2,500.00 63 A/E LS 2,025.00 1,000.00 64 A/E LS 2,029.00 350,000.00 65 A/E LS 2,030.00 1,000.00 66 A/E repairs 2,022.00 1,750.00 67 A/E forcemain 2,022.00 500.00 68 A/E forcemain 2,029.00 50,000.00 69 A/E forcemain 2,030.00 500.00 70 A/E connection metering and software 2,030.00 65,000.00 71 Drainfield Improvements 2,026.00 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 527,321 207,589 625,093 370,417 DRAFT 6 of 8 Presented 12/15/2021 DRAFT UTILITIES BUDGET Scenario D - No Financial Aid DRAFT CIP Inflation Factor 2021 Item #Capital Project Name First Year Costs 1 Bliss facility flow meters to be replaced 2,022.00 18,300.00 2 Bliss Test Well #8 Abandonment/Replacement 2,022.00 50,000.00 3 Bliss nitrate treatment equipment 2,023.00 960,000.00 4 LS 1 Control Panel 2,027.00 10,000.00 5 LS 2 Control Panel 2,026.00 10,000.00 6 LS 2 Control Panel 2,031.00 1,500.00 7 LS #1 (Layton Ave) 2,022.00 500.00 8 LS #1 (Layton Ave) 2,023.00 500.00 9 LS #1 (Layton Ave) 2,024.00 2,500.00 10 LS #1 (Layton Ave) 2,025.00 500.00 11 LS #1 (Layton Ave) 2,026.00 500.00 12 LS #1 (Layton Ave) Rehab 2,027.00 350,000.00 13 LS #1 (Layton Ave) 2,028.00 500.00 14 LS #1 (Layton Ave) 2,029.00 500.00 15 LS #1 (Layton Ave) 2,030.00 500.00 16 LS #1 (Layton Ave) 2,031.00 500.00 17 LS #2 (189th - Main Station) 2,022.00 500.00 18 LS #2 (189th - Main Station) 2,023.00 2,500.00 19 LS #2 (189th - Main Station) 2,024.00 500.00 20 LS #2 (189th - Main Station) 2,025.00 500.00 21 LS #2 (189th - Main Station) 2,023.00 350,000.00 22 LS #2 (189th - Main Station) 2,027.00 500.00 23 LS #2 (189th - Main Station) 2,028.00 500.00 24 LS #2 (189th - Main Station) 2,029.00 500.00 25 LS #2 (189th - Main Station) 2,030.00 500.00 26 LS #2 (189th - Main Station) 2,031.00 2,500.00 27 LS #3 Pump 1 Replacement 2,021.00 6,000.00 28 LS #3 Pump 2 Replacement 2,021.00 6,000.00 29 LS #3 (Dosage Tanks) 2,022.00 500.00 30 LS #3 (Dosage Tanks) 2,023.00 500.00 31 LS #3 (Dosage Tanks) 2,024.00 500.00 32 LS #3 (Dosage Tanks) 2,025.00 500.00 33 LS #3 (Dosage Tanks) 2,026.00 2,500.00 34 LS #3 (Dosage Tanks) 2,027.00 500.00 35 LS #3 (Dosage Tanks) 2,028.00 500.00 36 LS #3 (Dosage Tanks) 2,029.00 500.00 37 LS #3 (Dosage Tanks) 2,030.00 70,000.00 38 LS #3 (Dosage Tanks) 2,031.00 2,500.00 39 LS #4 Pump 1 Replacement 2,021.00 6,000.00 40 LS #4 Pump 2 Replacement 2,021.00 6,000.00 41 LS #4 (Dosage Tanks) 2,022.00 500.00 42 LS #4 (Dosage Tanks) 2,023.00 500.00 43 LS #4 (Dosage Tanks) 2,024.00 500.00 44 LS #4 (Dosage Tanks) 2,025.00 500.00 45 LS #4 (Dosage Tanks) 2,026.00 500.00 46 LS #4 (Dosage Tanks) 2,027.00 2,500.00 47 LS #4 (Dosage Tanks) 2,028.00 500.00 48 LS #4 (Dosage Tanks) 2,029.00 500.00 49 LS #4 (Dosage Tanks) 2,031.00 500.00 50 LS #4 (Dosage Tanks) 2,030.00 70,000.00 Project Big Marine Sewer Capital Improvement Outlay Full Funding Scenario D No Financial Aid 4.00% 2031 - - - - - 2,220 - - - - - - - - - 740 - - - - - - - - - 3,701 - - - - - - - - - - - 3,701 - - - - - - - - - 740 - DRAFT 7 of 8 Presented 12/15/2021 DRAFT UTILITIES BUDGET Scenario D - No Financial Aid DRAFT CIP Inflation Factor 2021 Item #Capital Project Name First Year Costs 1 Bliss facility flow meters to be replaced 2,022.00 18,300.00 Project Big Marine Sewer Capital Improvement Outlay Full Funding Scenario D No Financial Aid 51 Repairs 2,022.00 2,500.00 52 Forcemain 2,022.00 500.00 53 Forcemain 2,026.00 50,000.00 54 Forcemain 2,028.00 500.00 55 Forcemain 2,030.00 50,000.00 56 Forcemain 2,028.00 5,000.00 57 Forcemain 2,031.00 500.00 58 Connection metering 2,028.00 120,000.00 59 Connection meter equipment 2,028.00 25,000.00 60 A/E control panel 2,029.00 50,000.00 61 A/E LS 2,022.00 1,000.00 62 A/E LS 2,024.00 2,500.00 63 A/E LS 2,025.00 1,000.00 64 A/E LS 2,029.00 350,000.00 65 A/E LS 2,030.00 1,000.00 66 A/E repairs 2,022.00 1,750.00 67 A/E forcemain 2,022.00 500.00 68 A/E forcemain 2,029.00 50,000.00 69 A/E forcemain 2,030.00 500.00 70 A/E connection metering and software 2,030.00 65,000.00 71 Drainfield Improvements 2,026.00 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