Loading...
HomeMy WebLinkAbout10-26-2020 Council Work Session PacketCouncil Work Session Monday, October 26, 2020 5:00 P.M. Orono Council Chambers, 2780 Kelley Parkway, Orono, MN 55356 WORK SESSION AGENDA The Orono Council Work Session is open to the public 1. 2021 CIP Discussion a. Water b. Sewer 2. 2021 Police CIP Discussion 3. Utility Rate Study Council Work Session Monday, October 26, 2020 5:00 P.M. Orono Council Chambers, 2780 Kelley Parkway, Orono, MN 55356 Past Meeting Agendas October 12, 2020  2021 CIP Discussion a. Streets b. Stormwater September 28, 2020  Long Lake Creek Subwatershed Presentation by MCWD  Parks and Equipment CIP Discussion September 14, 2020  Building and Community Investment CIP Discussion Annual Discussions Timeframe:  Budget: Part of June, All of July, August and October.  City Administrator & Police Chief Update (3 times per year for 15 minutes) 2020 CIP – Page 1 MEMORANDUM To: Mayor Walsh and Orono City Council From: Dustin Rief, City Administrator Subject: Water and Sewer CIP Date: October 26, 2020 Staff has continued to work on the 2021 budget. The Water Utility CIP ad Sanitary Sewer CIP information and correlating fund balance information is provided for discussion. Issues for discussion: • Water Fund – The Water Utility Fund is funded by water service usage fees with a 2020 projected yearend cash balance of $219,364 and estimated revenues of $1,202,914 for 2021. The capital expenditures for 2021 are proposed at $420,500. • Sanitary Sewer Fund – The Sewer Utility Fund is funded by sewer access charges at a flat rate. The 2020 year-end projected cash balance is $1,640,125 with an estimated revenue for 2021 of $2,108,959. The proposed capital expenditures are $833,000. Capital Improvement Plan, City of Orono Public Works - Water CIP Table A-6 Project 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Water Sytem work with Road Projects (Valve replacements)148,500$ -$ 16,500$ -$ 40,000$ 40,000$ 40,000$ 40,000$ 40,000$ Navarre Plant Control Upgrade 55,200$ Water Meter Replacement 90,000$ 95,000$ 170,000$ Walters Port Watermain Replacement 160,000$ South Tower Repaint and Rehabilitation 350,000$ North Water Tower deep clean/Inspection and repairs 75,450$ Water main Replacement CSAH 19 (CSAH 15 to Kelly)270,900$ Water main Replacement CSAH 19 (Kelly to W. Lafayette)238,600$ North Distribution Extension (West of OCB)120,000$ Well #4 Inspection & Maintenance (every 10 yrs)20,000$ North Water Plant 30,000$ South Water Plant Painting 60,000$ Navarre Plant Salt Brine Tank Rehab.350,000$ Well #1 Inspection and Maintenance (every 10 yrs)20,000$ Well #2 Inspection and Maintenance(every 10 yrs)20,000$ Water Main Loop Concordia 230,000$ North Well house Upgrade (sewer) Well #3 Inspection & Maintenance (every 10 yrs)20,000$ Water Valve Replacements (4 / Year)22,000$ 22,440$ 22,889$ 23,347$ 27,833$ 28,528$ 29,242$ 29,973$ 30,722$ 30,722$ Water Main Replacement/Rehab 250,000$ 250,000$ 250,000$ Totals 420,500$ 348,540$ 277,989$ 193,797$ 397,833$ 428,528$ 489,242$ 459,973$ 420,722$ 320,722$ 5-Year CIP Planning Period Capital Improvement Plan, City of Orono Public Works - Sanitary Sewer CIP Table A-7 Project 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Sewer Rehabilitation 290,000$ 290,000$ 290,000$ 290,000$ 290,000$ 290,000$ 290,000$ 290,000$ 290,000$ 290,000$ Road Project Sanitary Adjustements 63,000$ 24,000$ 55,500$ 28,500$ 109,500$ 50,000$ 50,000$ 50,000$ 50,000$ 50,000$ Lift Station #15 Generator 75,000$ Lift Station #16 Rehab 60,000$ Lift Station #17 Rehab 60,000$ Lift Station #11 Rehab 60,000$ Lift Station #3 Rehab 60,000$ Lift Station #5 Rehab 60,000$ Lift Station #4 Rehab 60,000$ Lift Station #28 Rehab 60,000$ Grinder Station #8 Rehab 60,000$ Lift Station #10 Rehab 60,000$ Lift Station #27Rehab 60,000$ Lift Station Rehab (2 per year)120,000$ 120,000$ 120,000$ 120,000$ 120,000$ Force main Replacement Tonkawa PH2 225,000$ Sewer Meter installation (into Long Lake)60,000$ Force Main Replacement Tonkawa PH3 215,250$ Force Main Replacement Tonkawa PH4 139,950$ Sewer Main Replacements 200,000$ 200,000$ 200,000$ Totals 833,000$ 434,000$ 680,750$ 578,450$ 519,500$ 660,000$ 460,000$ 660,000$ 460,000$ 660,000$ Planning Period5-Year CIP 2021 CIP – Page 1 MEMORANDUM To: Dustin Rief, City Administrator From: Correy Farniok, Police Chief Subject: Police CIP Date: October 20, 2020 Attachments: Budget Information Police CIP information and correlating fund balance information is provided for discussion. Issues for discussion: • Police Capital Improvement Plan- The 2021-2030 CIP items and projected cost for each of those items have been updated. The largest CIP item are for squad camera upgrades, body cameras, weapon mounted cameras and the storage and installation of these systems. Projected costs are just under $200,000. Funding for the Police CIP is supported or partially funded through Police Account in the PIR Fund. The Police DWI Forfeiture Fund will also be used to cover the cost of implementing this project. • Body-Worn Camera Policy – MN law requires public comments at three junctures in the process. First, the police department must provide an opportunity for public comment before implementing a BWC system. Minimally, we must receive comments by mail or email. Second, the council with budget oversight needs to allow public comment at a regular Council meeting. Third, the Police department must allow for public comment and input when developing the BWC policies. • Camera Systems - Police body-worn cameras (BWC), weapon-mounted cameras, upgrades to squad cameras and storage solution has been researched by staff and vendors have been selected. Watch Guard has been selected for the BWC’s, squad cameras and storage solution. Viridian has been selected for the weapon-mounted cameras. 2021 CIP – Page 2 o Watch Guard - 30 BWC’s and 13 squad cameras Evidence Library software and licensing and warranty Onsite storage and servers $156,865.00 o Viridian - 30 weapon-mounted cameras and holsters $ 27,780.00 o Streicher’s – Remove/install 13 - squad cameras $ 6,500.00 Total $191,145.00 City of Orono Police Equipment Funds Retained Funds 2010-2019 617,805 Expenditures - To Date 2013 9,497 L3 Squad Cameras (2)5/23/2013 21,247 800 MHZ Radio (5)5/20/2013 29,746 800 MHZ Radio (7)10/16/2013 60,490 2014 15,420 L3 Squad Cameras (3)3/7/2014 15,420 2015 14,760 L3 Squad Cameras (3)5/12/2015 4,970 L3 Squad Camera 10/16/2015 19,730 2016 32,050 Portable Radios (10)3/27/2016 5,094 Rifle Sights (6)3/24/2016 6,637 Handguns (15)6/11/2016 1,344 Holsters 6/11/2016 2,106 Chargers/Jacke Radios 6/22/2016 570 Optic Mounts 8/4/2016 20,000 Police Records 8/30/2016 67,801 2017 32,050 Portable Radios (10)1/12/2017 120,000 Police Records 1/31/2017 152,050 2018 40,455 Portable Radios (10)1/26/2018 40,455 2019 - Current Balance 261,859 Expenditures - Future 2020-2021 45,000 Squad Cameras 2020-2021 40,000 Body Cameras (15,000 Cameras, Server for Storage 25,000) 2022 25,000 Rifles and accessories 2023 20,000 Handguns and holsters 2021-2022 40,000 Card Reader/Camera Upgrade 2026 50,000 Portable Radios (15) 2027 50,000 Portable Radios (15) 2023 120,000 Police Records 390,000 Balance (128,141) City of Orono Police Equipment Funds Retained Funds 2015 43,004 6,695 15.57%2,541 5.91%33,768 78.52% 2016 52,483 8,413 16.03%3,258 6.21%40,812 77.76% 2017 80,712 13,328 16.51%5,125 6.35%62,259 77.14% 2018 63,421 10,793 17.02%3,598 5.67%49,031 77.31% 2019 22,239 3,544 15.94%1,147 5.16%17,548 78.91% 261,860 42,773 16.33%15,669 5.98%203,418 77.68% * Spent funds are allocated on a first in first out basis. Spring Park Mtka Beach Orono TO: Mayor Walsh and Council Members FROM: Maggie Ung, Accountant DATE: October 26, 2020 SUBJECT: 2021 Utility Billing and Rates Attachments: 1. Rate Study As part of the utility fund’s budget process, staff has been looking at the rates that are needed to fund our utility systems. The rates will be explained in the rest of this memo. Rate Study Staff has been working on updating the annual rate study on which to base future utility rates. Some of the challenges that have been encountered include the following: • Higher than normal capital expenditures in the near term due to delayed projects • Relatively low number of water users especially on the North system • Low density of users on the sewer system • A complex sewer collection system with 45 lift stations • High levels of I&I in the sewer system • An increase of road projects impacts utilities in the road corridors Because our water system has a low number of users, the overhead of two water plants, four wells, and two water towers is spread over far fewer customers that some of our neighboring cities. This puts significant pressure on our water rates. With 45 lift stations we have approximately one lift station for every 50 connections. A city like Plymouth, with a higher population density and less geographical challenges, has approximately one lift station for every 5,000 connections. When the complexity of our system is combined with the I&I issues, there is significant upward pressure on sewer rates. The rates being presented are calculated based on the following goals: • Maintain an operating reserve of 25% of operating expenditures – City Policy and Best Practice • Maintain a capital reserve of 25% of capital expenditures – City Policy and Best Practice • Normalize capital expenditures • Normalize revenue to meet expenditures • Capture 100% of Depreciation • Create a stable rate structure that does not require borrowing or Special Assessments Staff is recommending the following increases for next year: 10% to Water, 10% to Sewer, 1% to Stormwater, and 10% Recycling. These increases next year allows the City to meet funding goals while keeping rates lower in future years. Water Rates: The Water Fund has the most significant funding issues. In 2019 and 2020, the water rates were increased by 35% each year. The currently analysis suggests rates should increase from 10% to 15% in 2021. Future increases could be held in the 2% to 3% range. Staff is recommending an updated tier structure be instituted due to switching to monthly billing to round tiers to the nearest hundredth gallons as shown below for residential: The same rounding would be applied to multi-family and commercial tiers. This will not have a significant impact on revenue. Stormwater The Stormwater Fund saw a 90% increase in 2020 in order to meet the requirements needed. This significant rate increase allows future rates to be as low as 1%. Sewer Based on the 2019 rate study, sewer rates were increased 20% in 2020. With updated 2020 year-end cash balance projections, staff is providing 2 two options: a 10% increase in 2021, followed by a 3% increase in future years; the other option would be to increase 15% in 2021 followed by 2% increases in future years. Recycling As discussed when the recycling RFP was approved in 2020, recycling rates needed a significant (60%) increase this year. This is due to an increase from 3.07 per month in 2018 to the new rate of 5.05 per month per household. 2021 needs to follow with a 10% increase and 4% increases thereafter. Cable The Cable Fund is funded through a franchise fee on Cable bills. No rate adjustment is needed. Cable franchises are currently trying to apply the value of the free service provided to municipalities to the amount required under the franchise agreement. If this happens, revenues to the fund would decrease. Current Proposed Current Proposed Current Proposed Tier 1 0 - 3,333 0 - 3,300 0 - 5,000 5,000 0 - 2,666 0 - 2,600 Tier 2 3,333 - 8,333 3,300 - 8,300 5,000 - 8,333 5,000 - 8,300 2,666 - 7,333 2,600 - 7,300 Tier 3 8,333 +8,300 + 8,333 +8,300 + 7,333 +7,300 + Chevy Chase AreaNavarre Area Long Lake Area Ba s e  Ch a r g e  In c r e a s e 2 % o r  Fl a t  Ba s e  Ra t e 5 0 . 0 0 $   Ac t i v e Ra t e  In c r e a s e  fr o m  Pr i o r  Ye a r 35 % 10 % 3% 3% 3% 3%3% In f l a t i o n  ‐   5  Yr  Fo r e c a s t B u d g e t e d  Am t 2. 0 4 % 2. 0 7 % 2. 1 2 % 2. 0 7 % 2.07%2.07% Ti e r  1  to  2  Ra t e  In c r e a s e 26 % I n a c t i v e Ti e r  2  to  3  Ra t e  In c r e a s e 50 % I n a c t i v e Ba s e d  on  20 1 3 ‐20 1 8  Av g  Co n s u m p t i o n Ca l c u l a t e d   Am o u n t Ca l c u l a t e d   Am o u n t Ca l c u l a t e d   Am o u n t Ca l c u l a t e d   Am o u n t Ca l c u l a t e d   Am o u n t Calculated  AmountCalculated Amount To t a l  Es t i m a t e d  Re v e n u e 1, 1 4 4 , 6 2 4 . 4 9 $           1, 2 0 2 , 9 1 4 . 9 1 $           1, 2 3 0 , 7 3 0 . 7 4 $           1, 2 5 9 , 3 8 1 . 0 6 $           1, 2 8 8 , 8 9 0 . 8 8 $           1,319,285.99 $      1,350,592.96 $       Es t i m a t e d  Ca s h  Ex p e n s e s 1, 1 5 1 , 7 3 5 . 0 0                1, 3 1 5 , 6 8 0 . 0 0                1, 2 5 8 , 6 4 6 . 6 0                1, 1 8 4 , 6 6 5 . 0 6                1, 0 7 7 , 5 3 6 . 4 6                1,300,805.47         1,345,889.91          Ga i n  / (L o s s )  ‐   No n ‐ca s h  ba s i s 15 6 , 3 7 4 . 4 9 2 3 3 , 5 1 4 . 9 1 2 3 1 , 5 6 5 . 1 4 2 2 0 , 3 2 9 . 9 9 2 1 6 , 4 5 0 . 4 2 2 2 0 , 3 1 9 . 5 3 2 2 7 , 5 9 8 . 0 5 Ga i n  / (L o s s )  ‐   Ca s h  ba s i s (7 , 1 1 0 . 5 1 ) ( 1 1 2 , 7 6 5 . 0 9 ) ( 2 7 , 9 1 5 . 8 6 ) 74 , 7 1 5 . 9 9 2 1 1 , 3 5 4 . 4 2 1 8 , 4 8 0 . 5 3 4 , 7 0 3 . 0 5 Be g .  Ca s h 21 9 , 4 7 5 . 1 2                      Ca s h  Ba l a n c e 21 2 , 3 6 4 . 6 1 9 9 , 5 9 9 . 5 2 7 1 , 6 8 3 . 6 6 14 6 , 3 9 9 . 6 5 3 5 7 , 7 5 4 . 0 7 3 7 6 , 2 3 4 . 6 0 3 8 0 , 9 3 7 . 6 6 av e r a g e  ca p i t a l  ex p e n d i t u r e  re q u i r e m e n t s  wi t h   3%  in f l a t i o n 24 2 , 0 1 4 . 9 8 $                 24 9 , 2 7 5 . 4 3 $                 25 6 , 7 5 3 . 6 9 $                 26 4 , 4 5 6 . 3 0 $                 27 2 , 3 8 9 . 9 9 $                 280,561.69 $         288,978.54 $          Op e r a t i o n  Re s e r v e  Go a l  25 %  of  E xp e n s e s 14 8 , 2 3 7 . 5 0 $                 19 3 , 88 0 . 0 0 $                 24 9 , 79 1 . 4 0 $                 25 9 , 7 6 2 . 7 7 $                 26 8 , 1 1 0 . 1 1 $                 274,741.62 $         280,748.73 $          Ca p i t a l  Re s e r v e  25 %  of  ex p e n s e s ‐ $ ‐ $ 25 , 6 7 5 . 3 7 $                     39 , 6 6 8 . 4 5 $                     54 , 4 7 8 . 0 0 $                     70,140.42 $           72,244.64 $            To t a l  Ca s h  Re s e r v e  Re q u i r e d 14 8 , 2 3 7 . 5 0 1 9 3 , 8 8 0 . 0 0 2 7 5 , 4 6 6 . 7 7 2 9 9 , 4 3 1 . 2 1 3 2 2 , 5 8 8 . 1 1 3 4 4 , 8 8 2 . 0 4 3 5 2 , 9 9 3 . 3 6 Ca s h  Ba l a n c e  af t e r  Ca s h  Re s e r v e 64 , 1 2 7 . 1 1 (9 4 , 2 8 0 . 4 8 ) ( 2 0 3 , 7 8 3 . 1 1 ) ( 1 5 3 , 0 3 1 . 5 6 ) 35 , 1 6 5 . 9 6 3 1 , 3 5 2 . 5 6 2 7 , 9 4 4 . 2 9 Fl a t  Ra t e $1 6 . 6 7 $1 6 . 6 7 $1 6 . 6 7 $1 6 . 6 7 $1 6 . 6 7 $16.67 $16.67 Ti e r  1 $7 . 0 7 $7 . 7 8 $8 . 0 1 $8 . 2 6 $8 . 5 0 $8.76 $9.02 Ti e r  2 $9 . 9 0 $1 0 . 8 9 $1 1 . 2 1 $1 1 . 5 5 $1 1 . 8 9 $12.25 $12.62 Ti e r  3 $1 4 . 8 5 $1 6 . 3 4 $1 6 . 8 3 $1 7 . 3 3 $1 7 . 8 5 $18.39 $18.942026 20 2 1  ‐   20 2 6  Wa t e r  Fu n d  Fo r e c a s t 20 2 4 2025 20 2 0 20 2 1 20 2 2 20 2 3 Water Option 1 Ba s e  Ch a r g e  In c r e a s e 2 % o r  Fl a t  Ba s e  Ra t e 5 0 . 0 0 $                                     Ac t i v e Ra t e  In c r e a s e  fr o m  Pr i o r  Ye a r 35 % 15 % 2% 2% 2% 2%2% In f l a t i o n  ‐   5  Yr  Fo r e c a s t B u d g e t e d  Am t 2. 0 4 % 2. 0 7 % 2. 1 2 % 2. 0 7 % 2.07%2.07% Ti e r  1  to  2  Ra t e  In c r e a s e 26 % I n a c t i v e Ti e r  2  to  3  Ra t e  In c r e a s e 50 % I n a c t i v e Ba s e d  on  20 1 3 ‐20 1 8  Av g  Co n s u m p t i o n Ca l c u l a t e d   Am o u n t Ca l c u l a t e d   Am o u n t Ca l c u l a t e d   Am o u n t Ca l c u l a t e d   Am o u n t Ca l c u l a t e d   Am o u n t Calculated  AmountCalculated Amount To t a l  Es t i m a t e d  Re v e n u e 1, 1 4 4 , 6 2 4 . 4 9 $           1, 2 4 5 , 0 6 0 . 1 1 $           1, 2 6 4 , 4 4 6 . 9 1 $           1, 2 8 4 , 2 2 1 . 4 4 $           1, 3 0 4 , 3 9 1 . 4 6 $           1,324,964.89 $      1,345,949.78 $       Es t i m a t e d  Ca s h  Ex p e n s e s 1, 1 5 1 , 7 3 5 . 0 0                1, 3 1 5 , 6 8 0 . 0 0                1, 2 5 8 , 6 4 6 . 6 0                1, 1 8 4 , 6 6 5 . 0 6                1, 0 7 7 , 5 3 6 . 4 6                1,300,805.47         1,345,889.91          Ga i n  / (L o s s )  ‐   No n ‐ca s h  ba s i s 15 6 , 3 7 4 . 4 9 2 7 5 , 6 6 0 . 1 1 2 6 5 , 2 8 1 . 3 1 2 4 5 , 1 7 0 . 3 8 2 3 1 , 9 5 1 . 0 1 2 2 5 , 9 9 8 . 4 2 2 2 2 , 9 5 4 . 8 7 Ga i n  / (L o s s )  ‐   Ca s h  ba s i s (7 , 1 1 0 . 5 1 ) ( 7 0 , 6 1 9 . 8 9 ) 5, 8 0 0 . 3 1 9 9 , 5 5 6 . 3 8 2 2 6 , 8 5 5 . 0 1 2 4 , 1 5 9 . 4 2 59.87 Be g .  Ca s h 21 9 , 4 7 5 . 1 2                      Ca s h  Ba l a n c e 21 2 , 3 6 4 . 6 1 1 4 1 , 7 4 4 . 7 3 1 4 7 , 5 4 5 . 0 4 24 7 , 1 0 1 . 4 1 4 7 3 , 9 5 6 . 4 2 4 9 8 , 1 1 5 . 8 4 4 9 8 , 1 7 5 . 7 1 av e r a g e  ca p i t a l  ex p e n d i t u r e  re q u i r e m e n t s  wi t h   3%  in f l a t i o n 24 2 , 0 1 4 . 9 8 $                 24 9 , 2 7 5 . 4 3 $                 25 6 , 7 5 3 . 6 9 $                 26 4 , 4 5 6 . 3 0 $                 27 2 , 3 8 9 . 9 9 $                 280,561.69 $         288,978.54 $          Op e r a t i o n  Re s e r v e  Go a l  25 %  of  E xp e n s e s 14 8 , 23 7 . 5 0 $                 19 3 , 88 0 . 0 0 $                 24 9 , 7 9 1 . 4 0 $                 25 9 , 7 6 2 . 7 7 $                 26 8 , 1 1 0 . 1 1 $                 274,741.62 $         280,748.73 $          Ca p i t a l  Re s e r v e  25 %  of  ex p e n s e s ‐ $                                             ‐ $                                             25 , 6 7 5 . 3 7 $                     39 , 6 6 8 . 4 5 $                     54 , 4 7 8 . 0 0 $                     70,140.42 $           72,244.64 $            To t a l  Ca s h  Re s e r v e  Re q u i r e d 14 8 , 2 3 7 . 5 0 1 9 3 , 8 8 0 . 0 0 2 7 5 , 4 6 6 . 7 7 2 9 9 , 4 3 1 . 2 1 3 2 2 , 5 8 8 . 1 1 3 4 4 , 8 8 2 . 0 4 3 5 2 , 9 9 3 . 3 6 Ca s h  Ba l a n c e  af t e r  Ca s h  Re s e r v e 64 , 1 2 7 . 1 1 (5 2 , 1 3 5 . 2 7 ) ( 1 2 7 , 9 2 1 . 7 3 ) ( 5 2 , 3 2 9 . 8 0 ) 15 1 , 3 6 8 . 3 1 1 5 3 , 2 3 3 . 8 0 1 4 5 , 1 8 2 . 3 4 Fl a t  Ra t e $1 6 . 6 7 $1 6 . 6 7 $1 6 . 6 7 $1 6 . 6 7 $1 6 . 6 7 $16.67 $16.67 Ti e r  1 $7 . 0 7 $8 . 1 4 $8 . 3 0 $8 . 4 6 $8 . 6 3 $8.81 $8.98 Ti e r  2 $9 . 9 0 $1 1 . 3 8 $1 1 . 6 1 $1 1 . 8 4 $1 2 . 0 8 $12.32 $12.56 Ti e r  3 $1 4 . 8 5 $1 7 . 0 8 $1 7 . 4 2 $1 7 . 7 7 $1 8 . 1 2 $18.49 $18.852026 20 2 1  ‐   20 2 6  Wa t e r  Fu n d  Fo r e c a s t 20 2 4 2025 20 2 0 20 2 1 20 2 2 20 2 3 Water Option 2 Ra t e  In c r e a s e 90 % 1% 1% 1% 1% 1% 1% Ra t e  = $1 5 . 4 2 R a t e  = $1 5 . 5 7 R a t e  = $1 5 . 7 3 R a t e  = $1 5 . 8 8 R a t e  = $1 6 . 0 4 R a t e  = $16.2 R a t e  = $16.36 To t a l To t a l To t a l To t a l To t a l To t a l Total Es t i m a t e d  Re v e n u e 67 6 , 7 9 8 . 6 5            68 3 , 5 6 6 . 6 3            69 0 , 4 0 2 . 3 0            69 7 , 3 0 6 . 3 2                70 4 , 2 7 9 . 3 9                711,322.18                        718,435.40              Bu d g e t e d  Am t 2 . 0 4 % 2. 0 7 % 2. 1 2 % 2. 0 7 % 2. 0 7 % 2.07% 65 1 To t a l  Ca s h  Ex p e n d i t u r e 81 5 , 1 4 0 . 0 0            91 6 , 3 5 0 . 0 0            71 0 , 0 1 1 . 1 9            77 4 , 3 7 8 . 7 9                89 4 , 0 8 0 . 6 9                665,525.73                        918,161.99              Ga i n  / (L o s s )  ‐   No n ‐ca s h  ba s i s 30 3 , 7 9 8 . 6 5 2 8 0 , 3 6 6 . 6 3 2 7 3 , 7 0 1 . 1 1 2 6 5 , 1 5 5 . 5 3 2 5 8 , 7 0 8 . 7 0 2 5 0 , 1 1 2 . 4 5 2 4 7 , 2 4 4 . 4 1 Ga i n  / (L o s s )  ‐   Ca s h  ba s i s (1 3 8 , 3 4 1 . 3 5 ) ( 2 3 2 , 7 8 3 . 3 7 ) ( 1 9 , 6 0 8 . 8 9 ) ( 7 7 , 0 7 2 . 4 7 ) ( 1 8 9 , 8 0 1 . 3 0 ) 45,796.45 (199,726.59) Be g  Ca s h 1, 1 5 1 , 7 0 0 . 3 8 1 , 0 1 3 , 3 5 9 . 0 3 7 8 0 , 5 7 5 . 6 6 7 6 0 , 9 6 6 . 7 7 6 8 3 , 8 9 4 . 3 1 4 9 4 , 0 9 3 . 0 0 5 3 9 , 8 8 9 . 4 5 Ye a r  En d  Ca s h  Ba l a n c e 1, 0 1 3 , 3 5 9 . 0 3 78 0 , 5 7 5 . 6 6 7 6 0 , 9 6 6 . 7 7 6 8 3 , 8 9 4 . 3 1 4 9 4 , 0 9 3 . 0 0 5 3 9 , 8 8 9 . 4 5 3 4 0 , 1 6 2 . 8 6 av e r a g e  ca p i t a l  ex p e n d i t u r e  re q u i r e m e n t s  wi t h   3%  in f l a t i o n  (2 0 1 8 ‐20 3 4 ) 66 8 , 1 0 2 . 2 9 6 8 8 , 1 4 5 . 3 6 7 0 8 , 7 8 9 . 7 2 7 3 0 , 0 5 3 . 4 1 7 5 1 , 9 5 5 . 0 1 7 7 4 , 5 1 3 . 6 6 7 9 7 , 7 4 9 . 0 7 Op e r a t i o n  Re s e r v e  Go a l  25 %  of  Ex p e n s e s 93 , 2 5 0 . 0 0 1 0 0 , 8 0 0 . 0 0 1 0 4 , 1 7 5 . 3 0 1 0 8 , 0 3 7 . 7 0 1 1 1 , 3 9 2 . 6 7 1 1 5 , 3 0 2 . 4 3 1 1 7 , 7 9 7 . 7 5 Ca p i t a l  Re s e r v e  25 %  of  ex p e n s e s 0. 0 0 1 7 2 , 0 3 6 . 3 4 1 7 7 , 1 9 7 . 4 3 1 8 2 , 5 1 3 . 3 5 1 8 7 , 9 8 8 . 7 5 1 9 3 , 6 2 8 . 4 2 1 9 9 , 4 3 7 . 2 7 To t a l  Ca s h  Re s e r v e  Re q u i r e d 93 , 2 5 0 . 0 0 2 7 2 , 8 3 6 . 3 4 2 8 1 , 3 7 2 . 7 3 2 9 0 , 5 5 1 . 0 5 2 9 9 , 3 8 1 . 4 3 3 0 8 , 9 3 0 . 8 5 3 1 7 , 2 3 5 . 0 2 Ca s h  Ba l a n c e  af t e r  Ca s h  Re s e r v e 92 0 , 1 0 9 . 0 3 5 0 7 , 7 3 9 . 3 2 4 7 9 , 5 9 4 . 0 5 3 9 3 , 3 4 3 . 2 5 1 9 4 , 7 1 1 . 5 8 2 3 0 , 9 5 8 . 6 0 22,927.852026 20 2 1  ‐   20 2 6  St o r m w a t e r  Fu n d  Fo r e c a s t 20 2 0 20 2 1 20 2 2 20 2 3 20 2 4 2025 Ra t e  In c r e a s e 2 0 % 1 0 % 3 % 3 % 3 % 3 % 3 % Ra t e  By  Un i t      $6 2 . 7 2 ;          Ad d ' l  $5 5 . 4 4      $6 8 . 9 9 ;          Ad d ' l  $6 0 . 9 8      $7 1 . 0 6 ;          Ad d ' l  $6 2 . 8 1      $7 3 . 1 9 ;          Ad d ' l  $6 4 . 7      $7 5 . 3 9 ;          Ad d ' l  $6 6 . 6 4      $7 7 . 6 5 ;      Add'l  $68.64    $79.98;     Add'l  $70.7 Ra t e  By  Fl o w  (B a s e  & pe r  th o u s a n d ) 6. 9 6                                                      7. 6 6                                                      7. 8 9                                                      8. 1 2                                                      8. 3 7                                                      8.62                            8.88                             Ra t e A m o u n t R a t e A m o u n t R a t e A m o u n t R a t e A m o u n t R a t e A m o u n t R a t e A m o u n t R a t e A m o u n t To t a l  Es t i m a t e d  Re v e n u e 1, 9 2 4 , 9 7 7 . 9 6                        2, 1 0 8 , 9 5 9 . 8 6                        2, 1 6 7 , 8 8 3 . 6 1                        2, 2 3 0 , 0 8 0 . 1 0                        2, 2 8 8 , 9 0 2 . 4 4                        2,357,042.45             2,427,226.65              Bu d g e t e d  Am t 2. 0 4 % 2. 0 7 % 2. 1 2 % 2. 0 7 % 2.07%2.07% To t a l  Ex pe n d i t u r e  ‐  Ca s h  Ba s i s 2, 4 7 7 , 6 0 0 . 0 0                        2, 4 6 5 , 6 0 0 . 0 0                        2, 1 6 1 , 1 1 7 . 8 2                        2, 2 6 7 , 8 1 5 . 1 2                        2, 6 4 8 , 3 6 7 . 3 7                        2,472,949.66             2,347,676.06              Be g .  Ca s h 2, 1 9 2 , 7 4 7 . 2 4                        Ga i n  / (L o s s )  ‐   Ca s h  ba s i s (5 5 2 , 6 2 2 . 0 4 ) (3 5 6 , 6 4 0 . 1 4 ) 6, 7 6 5 . 7 9 (3 7 , 7 3 5 . 0 2 ) (3 5 9 , 4 6 4 . 9 2 ) (115,907.21)79,550.59 Es t i m a t e d  YE  Ca s h  Ba l a n c e 1, 6 4 0 , 1 2 5 . 2 0 1, 2 8 3 , 4 8 5 . 0 6 1, 2 9 0 , 2 5 0 . 8 5 1, 2 5 2 , 5 1 5 . 8 3 89 3 , 0 5 0 . 9 1 777,143.70 856,694.29 av e r a g e  ca p i t a l  ex p e n d i t u r e  re q u i r e m e n t s   wi t h  3%  in f l a t i o n  (2 0 1 8 ‐20 3 4 ) 81 6 , 5 7 8 . 8 5 84 1 , 0 7 6 . 2 2 86 6 , 3 0 8 . 5 0 89 2 , 2 9 7 . 7 6 91 9 , 0 6 6 . 6 9 946,638.69 975,037.85 Op e r a t i o n  Re s e r v e  Go a l  25 %  of  Ex p e n s e s 44 7 , 8 0 0 . 0 0 47 4 , 9 2 5 . 0 0 48 7 , 8 0 6 . 2 1 49 9 , 3 0 0. 2 8 51 0 , 1 2 7 . 3 4 521,063.66 532,312.77 Ca p i t a l  Re s e r v e  25 %  of  ex p e n s e s 0. 0 0 21 0 , 2 6 9 . 0 5 21 6 , 5 7 7 . 1 3 22 3 , 0 7 4 . 4 4 22 9 , 7 6 6 . 6 7 236,659.67 243,759.46 To t a l  Ca s h  Re s e r v e  Re q u i r e d 44 7 , 8 0 0 . 0 0 68 5 , 1 9 4 . 0 5 70 4 , 3 8 3 . 3 3 72 2 , 3 7 4 . 7 2 73 9 , 8 9 4 . 0 1 757,723.34 776,072.23 Ca s h  Ba l a n c e  af t e r  Ca s h  Re s e r v e 1, 1 9 2 , 3 2 5 . 2 0 59 8 , 2 9 1 . 0 0 58 5 , 8 6 7 . 5 2 53 0 , 1 4 1 . 1 1 15 3 , 1 5 6 . 8 9 19,420.36 80,622.062026 20 2 1  ‐   20 2 6  Se w e r  Fu n d  Fo r e c a s t 20 2 3 20 2 4 2025 20 2 0 20 2 1 20 2 2 Sewer Option 1 Ra t e  In c r e a s e 2 0 % 1 5 % 2 % 2 % 2 % 2 % 2 % Ra t e  By  Un i t      $6 2 . 7 2 ;          Ad d ' l  $5 5 . 4 4      $7 2 . 1 3 ;          Ad d ' l  $6 3 . 7 6      $7 3 . 5 7 ;          Ad d ' l  $6 5 . 0 3      $7 5 . 0 4 ;          Ad d ' l  $6 6 . 3 3      $7 6 . 5 4 ;          Ad d ' l  $6 7 . 6 6      $7 8 . 0 7 ;      Add'l  $69.01    $79.64;     Add'l  $70.39 Ra t e  By  Fl o w  (B a s e  & pe r  th o u s a n d ) 6. 9 6                                                      8. 0 0                                                      8. 1 6                                                      8. 3 3                                                      8. 4 9                                                      8.66                            8.84                             Ra t e A m o u n t R a t e A m o u n t R a t e A m o u n t R a t e A m o u n t R a t e A m o u n t R a t e A m o u n t R a t e A m o u n t To t a l  Es t i m a t e d  Re v e n u e 1, 9 2 4 , 9 7 7 . 9 6                        2, 2 0 3 , 4 4 1 . 3 0                        2, 2 4 3 , 4 6 8 . 7 7                        2, 2 8 5 , 7 6 7 . 4 7                        2, 3 2 3 , 6 5 1 . 7 7                        2,369,773.43             2,416,817.52              Bu d g e t e d  Am t 2. 0 4 % 2. 0 7 % 2. 1 2 % 2. 0 7 % 2.07%2.07% To t a l  Ex pe n d i t u r e  ‐  Ca s h  Ba s i s 2, 4 7 7 , 6 0 0 . 0 0                        2, 4 6 5 , 6 0 0 . 0 0                        2, 1 6 1 , 1 1 7 . 8 2                        2, 2 6 7 , 8 1 5 . 1 2                        2, 6 4 8 , 3 6 7 . 3 7                        2,472,949.66             2,347,676.06              Be g .  Ca s h 2, 1 9 2 , 7 4 7 . 2 4                        Ga i n  / (L o s s )  ‐   Ca s h  ba s i s (5 5 2 , 6 2 2 . 0 4 ) (2 6 2 , 1 5 8 . 7 0 ) 82 , 3 5 0 . 9 5 17 , 9 5 2 . 3 5 (3 2 4 , 7 1 5 . 5 9 ) (103,176.22)69,141.46 Es t i m a t e d  YE  Ca s h  Ba l a n c e 1, 6 4 0 , 1 2 5 . 2 0 1, 3 7 7 , 9 6 6 . 5 0 1, 4 6 0 , 3 1 7 . 4 5 1, 4 7 8 , 2 6 9 . 8 0 1, 1 5 3 , 5 5 4 . 2 1 1,050,377.99 1,119,519.44 av e r a g e  ca p i t a l  ex p e n d i t u r e  re q u i r e m e n t s   wi t h  3%  in f l a t i o n  (2 0 1 8 ‐20 3 4 ) 81 6 , 5 7 8 . 8 5 84 1 , 0 7 6 . 2 2 86 6 , 3 0 8 . 5 0 89 2 , 2 9 7 . 7 6 91 9 , 0 6 6 . 6 9 946,638.69 975,037.85 Op e r a t i o n  Re s e r v e  Go a l  25 %  of  Ex p e n s e s 44 7 , 8 0 0 . 0 0 47 4 , 9 2 5 . 0 0 48 7 , 8 0 6 . 2 1 49 9 , 3 0 0. 2 8 51 0 , 1 2 7 . 3 4 521,063.66 532,312.77 Ca p i t a l  Re s e r v e  25 %  of  ex p e n s e s 0. 0 0 21 0 , 2 6 9 . 0 5 21 6 , 5 7 7 . 1 3 22 3 , 0 7 4 . 4 4 22 9 , 7 6 6 . 6 7 236,659.67 243,759.46 To t a l  Ca s h  Re s e r v e  Re q u i r e d 44 7 , 8 0 0 . 0 0 68 5 , 1 9 4 . 0 5 70 4 , 3 8 3 . 3 3 72 2 , 3 7 4 . 7 2 73 9 , 8 9 4 . 0 1 757,723.34 776,072.23 Ca s h  Ba l a n c e  af t e r  Ca s h  Re s e r v e 1, 1 9 2 , 3 2 5 . 2 0 69 2 , 7 7 2 . 4 5 75 5 , 9 3 4 . 1 2 75 5 , 8 9 5 . 0 8 41 3 , 6 6 0 . 2 0 292,654.65 343,447.212026 20 2 1  ‐   20 2 6  Se w e r  Fu n d  Fo r e c a s t 20 2 3 20 2 4 2025 20 2 0 20 2 1 20 2 2 Sewer Option 2 20 2 0 20 2 1 20 2 2 20 2 3 20 2 4 2025 2026 Ra t e  In c r e a s e 60 % 10 % 4% 4% 4% 4%4% Ra t e  = $5 . 3 3 R a t e  = $5 . 8 7 R a t e  = $6 . 1 0 R a t e  = $6 . 3 5 R a t e  = $6 . 6 0 R a t e  = $6.86 R a t e  = $7.14 To t a l  Re v e n u e 23 0 , 6 3 2 . 0 0            25 1 , 1 9 5 . 2 0        26 0 , 2 4 3 . 0 1            26 9 , 6 5 2 . 7 3                27 9 , 4 3 8 . 8 4                289,616.39         300,201.05          Bu d g e t e d  Am t 4 . 0 % 4 . 0 % 0. 0 % 4. 0 % 4.0%4.0% 60 3 To t a l  Ca s h  Ex p e n d i t u r e 21 6 , 7 0 0 . 0 0            22 5 , 3 6 8 . 0 0        23 4 , 3 8 2 . 7 2            23 4 , 3 8 2 . 7 2                24 3 , 7 5 8 . 0 3                253,508.35         263,648.68          Ga i n  / (L o s s )  ‐   Ca s h  ba s i s 13 , 9 3 2 . 0 0 2 5 , 8 2 7 . 2 0 8 6 0 . 2 9 1 0 , 2 7 0 . 0 1 1 0 , 6 8 0 . 8 1 1 1 , 1 0 8 . 0 4 1 1 , 5 5 2 . 3 6 Be g  Ca s h 50 , 9 0 4 . 8 5 64 , 8 3 6 . 8 5 9 0 , 6 6 4 . 0 5 9 1 , 5 2 4 . 3 4 1 0 1 , 7 9 4 . 3 5 1 1 2 , 4 7 5 . 1 5 1 2 3 , 5 8 3 . 2 0 Ye a r  En d  Ca s h  Ba l a n c e 64 , 8 3 6 . 8 5 9 0 , 6 6 4 . 0 5 9 1 , 5 2 4 . 3 4 1 0 1 , 7 9 4 . 3 5 1 1 2 , 4 7 5 . 1 5 1 2 3 , 5 8 3 . 2 0 1 3 5 , 1 3 5 . 5 6 20 2 1  ‐   20 2 6  Re c y c l i n g  Fu n d  Fo r e c a s t Mo n t h XY Z Mo n t h XY Z Mo n t h XY Z Mo n t h XYZ Ye a r 20 1 9 Ye a r 20 2 0 Ye a r 20 2 1 Ye a r 2022 Us a g e Us a g e Us a g e Usage WA T E R 5 $ 4 6 . 3 6 W A T E R 5 $ 5 6 . 7 5 W A T E R 5 $ 6 0 . 8 5 W A T E R 5 $ 6 2 . 1 8 SE W E R  FL A T 52 . 2 7 $                               SE W E R  FL A T 62 . 7 2 $                               SE W E R  FL A T 68 . 9 9 $                               SE W E R  FLAT 71.06 $                 WA T E R  TE S T  FE E 0. 5 3 $                                   WA T E R  TE S T  FE E 0. 8 1 $                                   WA T E R  TE S T  FE E 0. 8 1 $                                   WA T E R  TEST  FEE 0.81 $                   ST O R M  WA T E R 8. 1 1 $                                   ST O R M  WA T E R 15 . 4 2 $                               ST O R M  WA T E R 15 . 5 7 $                               ST O R M  WATER 15.73 $                 RE C Y C L I N G 3. 3 3 $                                   RE C Y C L I N G 5. 3 3 $                                   RE C Y C L I N G 5. 8 7 $                                   RE C Y C L I N G 6.10 $                   To t a l  Am o u n t  Du e 11 0 . 6 0 $                           To t a l  Am o u n t  Du e 14 1 . 0 3 $                           To t a l  Am o u n t  Du e 15 2 . 0 9 $                           To t a l  Amount  Due 155.87 $               In c r e a s e  fr o m  Pr i o r  Ye a r 28 % 8% 2.5% *B a s e d  on  Mo n t h l y  Eq u i v a l e n t  Ac t u a l  Ra t e s * B a s e d  on  Ac t u a l  Ra t e s Mo n t h XY Z Mo n t h XY Z Mo n t h XY Z Mo n t h XYZ Ye a r 20 2 3 Ye a r 20 2 4 Ye a r 20 2 5 Ye a r 2026 BI L L  DE T A I L BI L L  DE T A I L Us a g e Us a g e Us a g e Usage WA T E R 5 $ 6 3 . 5 4 W A T E R 5 $ 6 4 . 9 5 W A T E R 5 $ 6 6 . 2 9 W A T E R 5 $ 6 7 . 7 8 SE W E R  FL A T 73 . 1 9 $                               SE W E R  FL A T 75 . 3 9 $                               SE W E R  FL A T 77 . 6 5 $                               SE W E R  FLAT 79.98 $                 WA T E R  TE S T  FE E 0. 8 1 $                                   WA T E R  TE S T  FE E 0. 8 1 $                                   WA T E R  TE S T  FE E 0. 8 1 $                                   WA T E R  TEST  FEE 0.81 $                   ST O R M  WA T E R 15 . 8 8 $                               ST O R M  WA T E R 16 . 0 4 $                               ST O R M  WA T E R 16 . 2 0 $                               ST O R M  WATER 16.36 $                 RE C Y C L I N G 6. 3 5 $                                   RE C Y C L I N G 6. 6 0 $                                   RE C Y C L I N G 6. 8 6 $                                   RE C Y C L I N G 7.14 $                   To t a l  Am o u n t  Du e 15 9 . 7 7 $                           To t a l  Am o u n t  Du e 16 3 . 7 9 $                           To t a l  Am o u n t  Du e 16 7 . 8 2 $                           To t a l  Amount  Due 172.07 $               In c r e a s e  fr o m  Pr i o r  Ye a r 2. 5 % 2. 5 % 2. 5 % 2.5% 20 2 1  ‐   20 2 6  Sa m p l e  Bi l l s BI L L  DE T A I L BI L L  DE T A I L BI L L  DE T A I L BI L L  DE T A I L BILL  DETAIL BILL  DETAIL Ba s e d  on  Wa t e r  Op t i o n  1  & Se w e r  Op t i o n  1