Loading...
3.a1b Big Marine Sewer Fund 602 Proposed 2022 Budget and CIPDRAFT 2022 UTILITIES BUDGET Big Marine Sewer Utility Budget Proposal - w/ARPA but no state aid DRAFT Fund 602 YTD Actual Proj 2019 2020 7/31/2021 2021 2021 2022 2023 2024 2025 2026 REVENUE Charges for services 81,238 83,175 45,861 79,093 88,045 109,592 (1) 126,579 146,199 168,859 195,033 Special assessments 4,824 6,844 139 139 200 300 - - - - Intergovernmental 35 47,202 - - - - (2) - - - - Interest earnings 3,226 353 - - 700 49 428 102 52 26 Miscellaneous - - - - - - - - - - City Bond Proceeds - - - - - - (3) 1,070,000 - - 700,000 Transfer In - 550 - - 10,000 441,892 (4) - - - - - - - - - - TOTAL REVENUES 89,323 138,124 46,001 79,232 98,945 551,833 1,197,007 146,301 168,911 895,058 - EXPENDITURES Wages 19,476 19,866 6,983 12,566 23,455 25,700 (5) 26,214 26,738 27,273 27,818 Materials 996 1,197 625 667 3,700 3,700 (5) 3,774 3,849 3,926 4,005 Professional Services 20,978 6,850 6,556 11,850 10,200 12,600 (5) 12,852 13,109 13,371 13,638 Repair and Maintenance 17,863 36,668 11,639 17,003 31,200 33,200 (5) 33,864 34,541 35,232 35,937 Other 19,072 13,772 4,809 10,162 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) - 86,420 86,420 86,420 Capital Outlay 23,276 104,435 - 24,000 29,000 79,612 (7) 1,427,983 13,217 9,652 449,250 Transfer Out - - - - - - - - - - TOTAL EXPENDITURES (141,291) (225,430) (30,612) (76,248) (167,005) (225,062) (1,576,342) (250,962) (250,424) (693,109) Change in balance sheet (373) NET REVENUE OVER (UNDER) EXPENSE (52,341) (87,306) 15,388 2,984 (68,060) 326,771 (379,335) (104,661) (81,513) 201,950 ENDING BALANCE 91,101 46,438 61,826 49,422 29,578 428,393 102,302 51,950 25,833 284,285 (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. 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 PROPOSED FOR APPROVAL 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 ProjectedBudget DRAFT 1 of 7 Presented 12/21/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%15.50%15.50%15.50%15.50%15.50%15.50%15.50%15.50%15.50% Base Charge Annual 897.56 987.32 1,140.35 1,317.10 1,521.26 1,757.05 2,029.39 2,343.95 2,707.26 3,126.89 3,611.55 Quarterly 224.39 246.83 285.09 329.28 380.31 439.26 507.35 585.99 676.82 781.72 902.89 Increase Annual 89.76 153.03 176.75 204.15 235.79 272.34 314.56 363.31 419.63 484.67 Quarterly 22.44 38.26 44.19 51.04 58.95 68.09 78.64 90.83 104.91 121.17 Energy Adj Charge Annual 8.00 8.80 10.16 11.74 13.56 15.66 18.09 20.89 24.13 27.87 32.19 Quarterly 2.00 2.20 2.54 2.93 3.39 3.92 4.52 5.22 6.03 6.97 8.05 Projected Revenue 99,629.16 109,592.08 126,578.85 146,198.57 168,859.35 195,032.55 225,262.59 260,178.29 300,505.93 347,084.35 400,882.42 Target Balance 70,625 127,170 134,928 149,115 146,540 (54,216)109,591 463,403 262,863 49,373 397,174 Over (Under Target (21,203)301,224 (32,626)(97,165)(120,707)338,501 296,745 (311,343)(68,952)451,866 52,553 Balance Projected 49,422 428,393 102,302 51,950 25,833 284,285 406,336 152,061 193,911 501,239 449,728 * Highlight rate % changes are a change since the proposal was 1st presented to the Sewer Committee on 12/15/2021. previous precentage was 10% This change was made to offset the debt in 2023 that origionally included the project's full cost. ARPA must be approated to an eligible expense. Fund 602 Big Marine Sewer Budget Proposal with ARPA but with no State Aid Draft 2 of 7 Presented 12/15/2021 DRAFT UTILITIES BUDGETBig Marine Sewer Utility Budget Proposal - w/ARPA but no state aid DRAFT CIP Inflation Factor 0.00%4.00%4.00% 2021 2021 2022 2023 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 - - 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 - 520 - 18 LS #2 (189th - Main Station) 2023 2,500.00 - 2,704 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 - 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 - - - 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 - - - Project Big Marine Sewer Capital Improvement Outlay 2022 Proposed CIP DRAFT 3 of 7 Presented 12/21/2021 DRAFT UTILITIES BUDGETBig Marine Sewer Utility Budget Proposal - w/ARPA but no state aid DRAFT 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 - - - 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 - 2,704 52 Forcemain 2022 500.00 - - 541 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 - - - 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 67 A/E forcemain 2022 500.00 - - 541 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 A/E 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 DRAFT 4 of 7 Presented 12/21/2021 DRAFT UTILITIES BUDGETBig Marine Sewer Utility Budget Proposal - w/ARPA but no state aid DRAFT 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% 2024 2025 2026 2027 2028 2029 2030 2031 - - - - - - - - - - - - - - - - - - - - - - - - - - - 12,653 - - - - - - 12,167 - - - - - - - - - - - - 2,220 - - - - - - - - - - - - - - - - 2,812 - - - - - - - - 585 - - - - - - - - 608 - - - - - - - - 442,862 - - - - - - - - 658 - - - - - - - - 684 - - - - - - - - 712 - - - - - - - - 740 - - - - - - - - - - - - - - - - 562 - - - - - - - - 585 - - - - - - - - - - - - - - - - - 633 - - - - - - - - 658 - - - - - - - - 684 - - - - - - - - 712 - - - - - - - - 3,701 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 562 - - - - - - - - 585 - - - - - - - - 3,042 - - - - - - - - 633 - - - - - - - - 658 - - - - - - - - 684 - - - - - - - - 99,632 - - - - - - - - 3,701 DRAFT 5 of 7 Presented 12/21/2021 DRAFT UTILITIES BUDGETBig Marine Sewer Utility Budget Proposal - w/ARPA but no state aid DRAFT - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 562 - - - - - - - - 585 - - - - - - - - 608 - - - - - - - - - 658 - - - - - - - - 684 - - - - - - - - - 740 - - - - - - 99,632 - 2,812 2,925 3,042 3,163 3,290 3,421 3,558 3,701 562 585 - - - - - - - - - 63,266 - - - - - - - - - 684 - - - - - - - - 71,166 - - - - - 6,580 - - - - - - - - - - 740 - - - - 157,912 - - - - - - - 32,898 - - - - - - - - 68,428 - - - - - - - - - - - - 1,217 1,265 1,316 - - - - - - - - 478,999 - - - - - - - - - 1,480 1,969 2,047 2,129 2,214 2,303 2,395 2,491 2,590 562 585 608 633 658 - - - - - - - - 68,428 - - - - - - - - - 740 - - - - - - 92,515 - - - 364,996 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 10,404 8,482 388,417 527,321 207,589 625,093 370,417 20,353 DRAFT 6 of 7 Presented 12/21/2021 DRAFT Big Marine Sewer Utility Budget Proposal - w/ARPA but no state aid DRAFT Actual Actual Budget Actual Preliminary dif over PY Summary CategoryType Category Type Code Description 2019 2020 2021 7/31/2021 2022 Budget Notes Sewer fundSpecial assessments Special assessmentsR602-31951 Special Assessments Principal - - - - - - Proposed Budget is based on only receiving APRA funds. Other funding scenarios have been forecasted Sewer fundSpecial assessments Special assessmentsR602-31952 SA Penalties & Interest 777 3,575 200 139 - (200) and are available in this budget packet. Sewer fundIntergovernmental IntergovernmentalR602-33422 Other State Grants & Aids 35 47,202 - - - - 2020 Revenue was a FEMA reimbursement + $30,173 rec'd Sept. 2020 Sewer fundCharges for services Charges for servicesR602-34401 Sewer User Fees & Hookup 81,238 83,175 88,045 45,861 109,592 21,547 Sewer fundCharges for services Charges for servicesR602-34402 Sewer Area Connection Fee - - Sewer fundSpecial assessments Special assessmentsR602-36100 Special Assessments 4,047 3,269 - - 300 300 Sewer fundInterest earnings Interest R 602-36210 Interest Income 3,226 353 700 - 49 (651) Sewer fundRefunds and reimbursements R 602-36250 Misc. Refund - 550 - - - - Transfers from other fundsTransfer in R 602-39200 Interfund Transfers In - - 10,000 - 441,892 431,892 Proposal includes allocation the American Rescue Plan Act TOTAL 602 REVENUE 89,322 138,124 98,945 46,001 551,833 452,888 Sewer fundWages E 602-43210-101 Regular Wages & Salaries 17,996 19,129 20,000 5,541 21,600 1,600 Sewer fundWages E 602-43210-102 OT Regular Wages 1,354 106 - 220 - - " Sewer fundWages E 602-43210-120 Pension Expense (2,714) (3,054) - - - - " Sewer fundWages E 602-43210-121 PERA Coord. Employer Contribute.1,444 1,443 1,500 378 1,600 100 " Sewer fundWages E 602-43210-122 FICA Employer Contribution 1,131 1,128 1,200 334 1,300 100 " Sewer fundWages E 602-43210-126 MEDICARE Employer Contribution 265 260 300 87 300 - " Sewer fundWages E 602-43210-151 Worker s Comp Insurance Prem 585 854 455 422 900 445 " Sewer fundMaterials E 602-43210-200 Office Supplies 134 - 200 75 200 - Sewer fundMaterials E 602-43210-210 Operating Supplies 642 803 2,400 550 2,400 - Additives to help break down the nitrogen - add to lift Station #2 -proposal Sewer fundMaterials E 602-43210-240 Small Tools and Minor Equip 20 147 550 - 550 - Sewer fundProfessional services E 602-43210-303 Engineering Fees 18,522 4,200 8,000 5,146 10,400 2,400 Sewer fundProfessional services E 602-43210-304 Legal Services - - - - - - Sewer fundProfessional services E 602-43210-308 Other Professional Services 2,456 2,651 2,200 1,410 2,200 - PACE testing Sewer fundRepair and maintenance E 602-43210-309 Software Support & Maintenance 1,439 716 1,200 - 1,200 - SCADA computer system Sewer fundRepair and maintenance E 602-43210-311 Contract Permit Inspections - - - - - - Sewer fundOther E 602-43210-317 Employee Training 351 508 1,400 130 1,400 - Sewer fundOther E 602-43210-321 Telephone 2,290 2,255 2,100 1,305 2,100 - SCADA Dialer Com System Sewer fundMaterials E 602-43210-322 Postage 200 247 550 - 550 - Sewer fundOther E 602-43210-331 Travel Expenses 156 - 200 - 200 - Sewer fundOther E 602-43210-334 Licenses & Permits 1,949 754 1,600 714 1,600 - Sewer fundOther E 602-43210-361 Liability/Property Ins 841 1,052 1,100 $1,648.86 900 (200) Sewer fundOther E 602-43210-381 Utilities-Electric & Gas 2,209 1,793 2,500 $1,011.50 2,500 - Sewer fundRepair and maintenance E 602-43210-385 Sewer Pumping & Maintenance 7,243 10,000 9,000 - 11,000 2,000 Sewer fundRepair and maintenance E 602-43210-386 Operation & Maintenance 4,434 9,772 5,000 1,574 5,000 - Sewer fundRepair and maintenance E 602-43210-404 Repair Machinery/Equipment 4,746 16,180 16,000 10,065 16,000 - Sewer fundOther E 602-43210-413 Equipment Rental - - 350 - 350 - Sewer fundDepreciation E 602-43210-420 Depreciation Expense 39,630 42,643 51,200 - 52,200 1,000 Sewer fundOther E 602-43210-438 Misc. Contractual 10,691 7,410 9,000 - 9,000 - Sewer fundOther E 602-43210-439 Refunds Issued - - - - - - Sewer fundPurchase of capital assets E 602-43210-530 Capital Impr Other Than Bldgs.- 104,435 29,000 - 79,612 50,612 Sewer fundPurchase of capital assets E 602-43210-570 Office Equipment - - - - - - Sewer fundPurchase of capital assets E 602-43210-611 Interest Expense - - - - - - Transfers to other fundsTransfers out E 602-43210-720 Operating Transfers - - - - - - TOTAL FUND 602 EXPENDITURES 118,013 225,430 167,005 30,612 225,062 58,057 (28,690) (87,306) (68,060) (68,060) (68,060) 20220 Draft City of Scandia Line-Item Budget Presented 12-21-2021 Big Marine Sewer Fund 602 Budget Proposal w/ ARPA w/o state aid DRAFT 7 of 7 Presented 12/21/2021