Loading...
HomeMy WebLinkAbout10-28-2019 Council Work Session PacketOrono City Council Work Session Monday, October 28, 2019 Council Chambers 5:00 p.m. AGENDA 1. Sanitary Service Line Point of Sale Inspections 2. 2020 Utility Billing and Rates a. Utility Rates b. Monthly vs. Quarterly Billing c. Water Utility Shut -Off Policy 3. Capital Improvement Plan Annual: • Budget: Part of June, All of July, August and October. • City Administrator & Police Chief Update (3 times per year for 15 minutes) Previous Work Session Topics October 14, 2019 • Receive and Discuss proposals to purchase City Parcels on Crystal Bay Road. o Proposals: ■ William L. Wolfson, 3407 Crystal Bay Road proposal to purchase PID:1711723430115 for $50,000 ■ Yousry Elshazaly, 3415 Crystal Bay Road proposal to purchase PID: 1711723430117 for $50,000. ■ Scott A. Brown, 3435 Crystal Bay Road proposal to purchase PID: 1711723430119 for $50,000. ■ Jon and Kelly Eiss, 3445 Crystal Bay Road proposal to purchase PID: 1711723430123 for $50,000 September 23, 2019 • Slope Stabilization Minnetonka Beach Water Services Agreement Discussion Dakota Trail Extension Update August 26, 2019 • Budget • Department Mission/ Vision/ and Goals • City Owned Properties (Policy) (added 6-24) • Marinas Item XX — Work Session CITY OF ORONO MEMORANDUM DATE: October 26, 2019 TO: Orono City Council FROM: Adam Edwards, P.E., Public Works Director / City Engineer RE: Sanitary Sewer Service Line Point of Sale Inspection 1. Purpose. The purpose of this work session item is to discuss whether or not the City should develop and adopt a Point of Sale Inspection Ordinance for Sanitary Sewer Service Pipe. . 2. Background. The City continues to work toward reducing Inflow and Infiltration (I&I) into the City's sanitary sewer system. Infiltration is clear water that enters the sanitary sewer system through broken or cracked pipes, defective joints, faulty connections, or other defects in the mains, services, or manholes. Inflow is clear water that enters the sanitary sewer system through direct connections such as rain leaders, area drains, sump r pump connections, foundation drain tile, or commercial/industrial discharges. (see illustration to right) Excessive I/I can create backup problems as it — overwhelms our system, it is also very expensive. Orono pays the Metropolitan (Met) Council to treat all of our sewage. Sewage from the City flows into the Met Council interceptor system and is routed to their treatment plants. If clear water enters the sanitary sewer, we have to pay to have it treated by the Met Council. This raises the sewer I&I March & July 2019 rates. I&I is monitored by the Metropolitan Council Environmental Services (MCPS) The Cit 's bill is Il Report for ORON0435 Y adjusted year to year based on the previous year's flows going into the Met Council system. In addition the city is fined for any exceedances of our flow allocations. The exceedance warnings and fines are closely associated with i a ° high rainfall events and saturated soils pointing to an I&I issue (See charts at right). To date the vast majority of I&I mitigation work has been on public infrastructure (pipes and manholes) and while these have shown some improvement there is still considerable I&I entering our system. While there is still work to be done on the city mains and manholes as key contributor to the I&I we are experience is very likely the private service lines that connect to our system. MCES estimates that as much as 80% of I&I may come from private sources. One method of addressing I&I coming into the sewer system via private service lines is with a point of sale inspection policy. Several Communities within the metro area have developed point of sale inspection policies/ programs. The city does provide for inspections in our current ordinance however it is focused on illicit discharges into the system such as cross connections from sump pumps. A part of any new inspection program should include the televising of service lines to identify infiltration as well as cross connections. 3. Point of Sale Policy. In general a point of sale inspection program has three main components. a. Inspection requirement. The City would require that all properties connected to the City sewer complete and inspection of the sewer service line prior to sale. Some municipalities also require inspections as part of their pavement management program by requiring inspection of any properties impacted by a street project to also have a sewer service inspection. Inspection would be performed by a Public Works employee. To facilitate inspection the City would develop a scheduling procedure, procure televising equipment and establish appropriate fees for the inspections. The inspection would include looking for infiltration into the sewer service line via cracks, separations or root intrusions as well as looking to inflow via cross connection from gutters, sump pumps, and foundation drains. b. Compliance requirement. If the inspection shows the property to be fully compliant then a certificate of compliance would be issues. Certificate would be good for 10 years. If the property is not compliant a correction notice would be issued and the corrections made by the property owner with in a given time period (current code says 14 days however other municipalities have as long as 180 days). Once corrected the property owner would schedule a follow on inspection and if the compliant a compliance certificate issued. c. Funding component. Looking at some of programs in the area this part can vary. Some municipalities place the cost of the inspections and any required repairs on the property owner. Some offer the inspection as a free service funded by the cities I&I Program. Some allow property owners to assess a portion 85%) of any repair costs with the city providing the funding for the remaining portion (15%). Funds used for private I&I improvement can be counted by the city for MCES exceedance credit. Periodically there are grants available that the City could administer to provide funding for service line repairs. 4. Discussion points. a. Should the City develop a Point of Sale Policy and associated Ordinance? b. What should the funding component of a point of sale policy look like? 5. Council action requested. Discussion on the merits of a Point of Sale Sanitary service line program and initial guidance to staff on the same. Exhibits A. Current City ordinance relative to Sanitary Sewer B. Example Ordinance Language for Point of Sale Inspections. C. Fact Sheets and Forms Used in Other Municipalities. References MCES I&I Website: https://metrocouncil.org/Wastewater-Water/Planning/Wastewater/Inflow-and- Infiltration.aspx City of West Saint Paul I&I Website: https://wspmn.gov/403/Inflow-and-Infiltration City of Golden Valley I&I Website: http://www.goidenvalleymn.gov/homeyard/utilities/ii-inspection.phl2 Exhibit A Sec. 14-189. - Prohibited discharges of groundwater/stormwater into the sanitary sewerage system. (a) No person shall discharge or cause to be discharged, directly or indirectly, any stormwater, surface water, groundwater, roof runoff, subsurface drainage or cooling water to any sanitary sewer. Any person having a roof drain, sump pump, unauthorized swimming pool discharge, cistern overflow pipe or surface drain connected and/or discharging into the sanitary sewer shall disconnect and remove any piping or system conveying such water to the sanitary sewerage system. (b) Every person owning improved real estate that discharges into the city's sanitary sewerage system shall allow inspection by authorized city employees or its agents of all properties or structures connected to the sanitary sewerage system to confirm there is no sump pump or other prohibited discharge into the sanitary sewerage system. In lieu of authorizing a city inspection of the property, the property owner may furnish a certificate from a licensed plumber, in a form acceptable by the city, certifying that the property has no prohibited discharge in the municipal sanitary sewer system. (c) Any owner of any property found to be in violation of this section shall make the necessary changes to comply with this division, and such change shall be verified by authorized city employees or agents. Any property or structure not inspected or not in compliance shall, following notification from the city, comply within 14 calendar days or be subject to the surcharge as provided in subsection (f) of this section. (d) Existing buildings with sump pumps and all newly constructed buildings with sumps shall have a discharge pipe installed to the outside wall of the building. The pipe attachment must be of rigid permanent -type plumbing, such as PVC, copper or galvanized pipe. The discharge shall extend outside of the foundation and may not be pumped directly onto any public right-of-way unless approved by the public service director or his designee. Any disconnects or openings in the sanitary sewer shall be closed and repaired in compliance with applicable codes. (e) Upon verified compliance with this chapter, the city reserves the right to reinspect such property or structure or require the property owner to provide a certificate of compliance from a licensed plumber in a form acceptable to the city at least annually to confirm continued compliance. Any property found not to be in compliance upon reinspection by the city shall, following notification from the city, comply within 14 calendar days or be subject to the surcharge provided for in subsection (f) of this section. (f) A surcharge set by the annual fee schedule adopted by the city council is imposed and shall be added to every utility billing to properties not in compliance with this chapter. The surcharge shall be added to every quarterly utility billing until the property is in compliance as determined by the city. If the surcharge is not paid in a timely manner, the delinquent payments may be certified for collection with the following years' property taxes. (g) The city council, upon recommendation of the city administrator and the city engineer, shall hear and decide requests for temporary waivers from the provisions of this division where strict enforcement would cause a threat to public safety because of circumstances unique to the individual property under consideration. Any request for a temporary waiver shall be submitted to the city administrator in writing within 14 calendar days of notification of noncompliance. Upon approval of a temporary waiver from the provisions of this division, the property owner shall agree to pay an additional fee for sanitary sewerage services based on the number of gallons discharged into the sanitary sewerage system as estimated by the city engineer. (h) Stormwater and all other unpolluted drainage shall be discharged to such drainage facilities as are specifically designated by the city engineer. (i) The imposition of the surcharge shall not limit the right of the city to seek an injunction in district court ordering the person to disconnect the nonconforming connection to the sanitary sewer or from pursuing any other legal remedies available; or in the alternative, the city may correct the violation and certify the costs of correction as an assessment against the property on which the correction was made. (Ord. No. 129 2nd series, § 2, 10-24-1994; Ord. No. 50 3rd series, § 1, 10-13-2008) Example Language from the Inflow and Infiltration, LMC Model Ordinance -OR- Exhibit B Unless the property owner already has a valid certificate of compliance issued by the City for the property, the owner or owner's representative is required to complete an inspection and obtain a certificate of compliance issued by the City before such property is offered for sale, gifted or transferred, and before the owner or owner's representative enters into any contract for deed or other transaction changing the party responsible for the property. A certificate of compliance shall be issued by the city upon successful completion of an inspection. A certificate of compliance shall be valid for ten years. The owner or owner's representative is required to complete an inspection and obtain a certificate of compliance issued by the City before such property is offered for sale, gifted or transferred, and before the owner or owner's representative enters into any contract for deed or other transaction changing the party responsible for the property. A certificate of compliance shall be issued by the City upon successful completion of an inspection. A certificate of compliance shall be valid until the property is again offered for sale, gifted or transferred, and before the owner or owner's representative enters into any contract for deed or other transaction changing the party responsible for the property. Exhibit C Fact Sheets, Processes and Forms Used in Some Other Municipalities. -i/ 'Golden 'Malley u Custom Search News & City City City Your Home Parks Ir About Golden Events • Government, Departments Services • ar Yard • Recreation • !1 Valley YOU ARE HERE: Homes Your Home & Yards Utilrr�es >I n9ow and Infiltration n Steps For Ill In0 IJ spection © 11 The appointment will take approximately one and one-half hours for residential properties and a n7immum ofthree hours for commercial or muni -unit properties. A responsible adult must be present at all limes during the inspection. 4. Prepare For Inspection Before the i nspection, the property -owner must do the following: 1. Make sure the water is turned on at the property- The inspection cannot be completed without water. 2. Locate the four -inch diameter vertical wastewater pipe that runs down through the basement from a bathroom above. This pipe will have an access point called a cleanout. Cteanouts are usually located on the pipe between approximately six inches and two feet from the basensent floor. 3. Make sure the cleanout cover is in working condition before the inspection can be performed. To ensure the cleanoul cover is in swror" condition_ the cover should be loosened and removed. then reinstalled so that a watertight seal is achieved. 91 r 4. Make sure the floor area around the cleanout is clear (a five-foot radius). 5. It [here is a cleanout cover located on the floor in the basement, [his cover should be in wortdng condition. The inspector may need to gain access to any cleanoul covers located in the basement floor, but _ the inspection cannot be performed through this type of cleanoul. Even if the property owner has a cleanoul cover'located in the floor that is easily accessible and used for sewer cleaning. the inspector must use the cleanout in the vertical four -inch diameter waslewaler pipe. 6. It you have a sump,pump, make sure it is accessible for inspection. 7. Make sure the sump pump discharge piping is visible. S. Wait For Review Allow up 10 five waking days for the Cay to review the inspection video and issue a compliance certificate or correction notice.. If problems are found 1. You will receive a correction notice from the City identifying the problem(s).Repairs should be completed within 180 days of the first inspection. and the City can grant an exlensaon of another 189 days. It repairs are not completed within one year of the fust inspection, the inspeclion becomes invalid and the process starts again, which includes paying the applicable inspection fee. 2. Correct fie problems (geeing use correct Inspections for the work dome along the way) and call the Public Works Department to schedule another 919 inspection. tlnflovr & Infltralion Contractor List Jw-j 3. If your property is then found compliant., you will receive your compliance certificate. It the property is not compliant after two inspections, an additional applicalian fee ($250 for residential properties: 5750 for commercial properties) may be charged. Steps For Inflow and Infiltration Inspection Inflow and Infiltration Sump Pumps 1. Verify Meed For Certification Call the City at 763-5933962 to verity that your property is in need of certification Contact Us before beginning the I!I inspection process. Golden valley Physical 2, Submit Application and Pay Fee Development Department— Public Works The applicalian fee is $250 for residential properties and $750 (per building) for 78(14 Gclden Valley Rd commercial or multi -unit buildings. Golden tealey, MN 55427 •_ By (Nail or In Person: You can submit your application J- and fee paid 8ycherk Phone: 763-593-8030 via mail or in person all the Public Works Department in C41y Hall. Fax: 763-593-3988 --; Online: Applications may also be submitted online and use fee paid by credit card TTY: 763-593-3%8 (residential application, commercial application). Email Us Please note. water must be available at the property for the inspection to be Office Hours completed. Monday - Friday Sam -4:30 prn 3. Schedule Inspection Call 763-593-3962 between 7 am and 3 prn to schedule an inspection. Provide permit number. if application was submitted online., and at least 24-hour advance notice. The appointment will take approximately one and one-half hours for residential properties and a n7immum ofthree hours for commercial or muni -unit properties. A responsible adult must be present at all limes during the inspection. 4. Prepare For Inspection Before the i nspection, the property -owner must do the following: 1. Make sure the water is turned on at the property- The inspection cannot be completed without water. 2. Locate the four -inch diameter vertical wastewater pipe that runs down through the basement from a bathroom above. This pipe will have an access point called a cleanout. Cteanouts are usually located on the pipe between approximately six inches and two feet from the basensent floor. 3. Make sure the cleanout cover is in working condition before the inspection can be performed. To ensure the cleanoul cover is in swror" condition_ the cover should be loosened and removed. then reinstalled so that a watertight seal is achieved. 91 r 4. Make sure the floor area around the cleanout is clear (a five-foot radius). 5. It [here is a cleanout cover located on the floor in the basement, [his cover should be in wortdng condition. The inspector may need to gain access to any cleanoul covers located in the basement floor, but _ the inspection cannot be performed through this type of cleanoul. Even if the property owner has a cleanoul cover'located in the floor that is easily accessible and used for sewer cleaning. the inspector must use the cleanout in the vertical four -inch diameter waslewaler pipe. 6. It you have a sump,pump, make sure it is accessible for inspection. 7. Make sure the sump pump discharge piping is visible. S. Wait For Review Allow up 10 five waking days for the Cay to review the inspection video and issue a compliance certificate or correction notice.. If problems are found 1. You will receive a correction notice from the City identifying the problem(s).Repairs should be completed within 180 days of the first inspection. and the City can grant an exlensaon of another 189 days. It repairs are not completed within one year of the fust inspection, the inspeclion becomes invalid and the process starts again, which includes paying the applicable inspection fee. 2. Correct fie problems (geeing use correct Inspections for the work dome along the way) and call the Public Works Department to schedule another 919 inspection. tlnflovr & Infltralion Contractor List Jw-j 3. If your property is then found compliant., you will receive your compliance certificate. It the property is not compliant after two inspections, an additional applicalian fee ($250 for residential properties: 5750 for commercial properties) may be charged. The sewer system within the City of West St. Paul is comprised of roughly 66 -miles of underground pipes. INlany of the pipes are publicly owned; however, the sewer laterals are enti rely owned by the private property owner they serve. The laterals extend from the building to the mainline within the street (or within an easement at the rear of your home). The laterals typically range from four to six inches in diameter while the City's mainline is typically at least eight inches in diameter. The private property owner is responsible for the entire length of the lateral, which includes that portion of the pipe that may be located within the public right of way (in the street) and its physical connection to the city main. Unfortunately, sewer laterals are not often maintained by private property owners until a disaster occurs. Out of sight, out of mind is a typical approach to sewer lateral maintenance and operation by many. It is a good idea to maintain your lateral through proper cleaning, repair, and replacement of the pipe as needed, and do not place improper items into the sewer such as fats, oils, and grease or make improper connections to the sewer. plumbing drains into sewer lateral TYPICAL SEWER CONNECTION rleanntii[ clean«ut '� side+valla street Owl private sewer lateral" sewer �^" sewer (�/j main Dig -up -and -Replace The traditional dig -up -and -replace repair method requires excavating a long, deep trench to remove the old pipes and install new ones. Most often utilized in spot repair and collapsed pipe situations, this repair can cost $50-$250 per foot, depending on the length and depth of the existing pipes, and the ease of access. Pipe Lining or CIPP This trenchless method, commonly referred to as Cured - in -Place -Pipe, is a flexible felt tube coated with resin that is blown or pulled into the damaged pipe and inflated. The resin then hardens (cures), creating a pipe within a pipe that has no joints and is corrosion resistant. Expect to pay about $70 per foot for longer lengths and up to $150 per foot for shorter repair jobs. Bursting or Splitting This method is similar to a Cl PP replacement in that it doesn't require total excavation of the damaged sewer lines. The bursting head splits the old pipe apart while the new pipe is pulled into place. $100 -$150 per foot. National High Repair $11,200 Average - $2,800 WSP - r Average $5,700 Law 2 $3.,600 days 'According to HomeAdvisor_com FACT SHEET p '; .4� mill Repair Funding Programs - It is the policy of the City of West 5t. Paul to minimize the sources of inflow and infiltration (water that doesn't require treatment) from entering the sanitary sewer system. Upon discovery, private sewer laterals that require rehabilitation or replacement will be required to be repaired as per City Code §50.08. Repair Funding Example: A single-family, owner -occupied home built in 1958, has sewer lateral defects for 64 feet. The owners elect to have the sewer lined at a total cost of $5,600. At the completion of the repair, the owners have $4,760 assessed to their taxes. This equates to a monthly payment of $45,96 over 10 years. The City funds the remaining $840 of the total cost, and pays $5,600 directly to the contractor. T Tax Assessment • 85% of repair cost • Term of 10 years at 3% interest • Must sign an Assessment Agreement City Funding • 15% of repair costs • Any type of I&I repair is eligible • Maximum subsidy amount is $5000 Assessment Deferral • Must be at least 65 yearn old or • Retired due to a permanent disability • Limited financial resources 2019 City of Ely Digital Copy f3Written Report ❑ POINT-OF-SALE SANITARY SEWER INSPECTION Date PID No. CODE SECTIONS SECTION I. Chapter 3, Section 3.68, of the City Code of the City of Ely, hfinnesnta is amended to read as follows: SECTION 3.08, POINT OF SALE CERTIFICATION. Subd. 1. Scope and Intent. The provisions of this Section shall apply to all real estate which is connected to the City's sanitary sewer and located within the City. It is the Intent of this ordinance to identify and eliminate inflow and infiltration resulting from cracked and leaking pipes, foundation drain connections, roof -drain connections, and SUMP pump connections. This Certification form shall be completed and requires one digital copy of the televising report provided to the City along with a written report including description of pipe condition from dwelling tta the city main. PROPERTY ADDRESS AbbkM; OWNER INFORMATION OWNt.R NAME: LICENSE NO: MONE NO: t 7 ADDRESS: CITY: STATE: ZIP: QIIALIT MI) PERSON INFORMATION NAME: LICENSE NO: PHONE NO: ADDRSS& CITY: $TATE ZIF; System Roof drains and leaders Roof drains should not be connected to the sanitary sewer but should discharge to the ground outside of a building. If the roof drains are connected to the sanitary sewer, disconnect them, plug any open connections to the sanitary sewer using a non -shrink permanent material, and redirect the roof drains onto the ground outside the building. Pass Fail. Notes Foundation drains are underground pipes that collect storm water from around the base of a building and into a sump basket, where it is then pumped outside of the building. Foundation drains should not be connected to the sanitary sewer. Pass Fail. Notes Sump pumps are designed to capture surface or ground water that enters basements or crawl spaces and pump it away from the house. The basic sump system includes drain tile, a sump pit, a sump pump, a float or switch, and a drain litre. Sump pumps should not be connected to the sanitary sewer. Pass Fail. Nates Sanitary Sewer Inflow & Infiltration (III) Compliance Inspection Sanitary Sewer Lines. All sanitary sewer lines serving Property, from the house to the main line, shall be in a safe and functional condition and shall be free from all leaks, failures including but not limited to sags, partially collapsed sections or tree root intrusion. the sanitary sewer lines shall meet the City Code standards and specifications Pass Fail. Notes Compliance Inspection Certification The undersigned hereby acknowledges the requirements in City Ordinance No. 306.2nd Series_ All deficiencies discovered during the Inspection shall be disclosed prior to Closing and shall be corrected iwilhin tiwelve (12) months fi om the Closing. The Seller shall provide proof to the City that funds were placed in an escrow account at Closing to cover the required repairs. The undersigned hereby certifies that the above information is true andcorrect sect to the best of their knowledge: Qualified Person's Signature: Date: Owner's Signature: Date: City of Fly POINT-OF-SALE SANITARY SEWER INSPECTION Written Report Date PII] No. PROPERTY ADDRESS ADDRES& Person Performing Inspection: Weather Conditions: Approximate Depth of Service: Type & Size of Service: Condition of Service Pipe Please note all connections, fittings, points of concern on service line including infiltration, tree root, cracks, misaligned joints, etc. This report must include a digital copy of the televising. Feet Comment Start from 4" Clean out In NE Corner of Basement Misallgned joints causing infiltration Example: 0 1-15 tl Total Footage: Location of discharge point for foundation drain/roof drain/ sump pump: Person's Performing Inspection Signature: Date: TO: Mayor Walsh and Council Members FROM: Ron Olson, Finance Director DATE: October 28, 2019 SUBJECT: 2020 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. In conjunction with this review of rates staff has identified some possible changes that could be made to our billing process. The changes are: transitioning from a quarterly to a monthly billing cycle, instituting a water shutoff policy, examining sewer service connections. The rates and other changes 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 our I&I issues, there is significant upward pressure on sewer rates. The rates being presented are calculated based on the following: • 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 significant increases for next year. The reason for this is level of capital expenditures over the near term. Higher increases next year, allow 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 the water rates were increased by 35%. The current analysis indicates that the 2020 rates will require an addition 35% increase in 2020. This would be followed with a 20% in 2021 and a 10% increase in 2022. In the years after 2022 the increases could be reduced to either an annual increase in the 1% to 2% range. Staff is recommending a new rate category be instituted for our customers on Long Lake water. Long Lake currently charges water using a tiered system that does not match Orono's. Long Lake's structure is: usage from 0 — 8,000 gallons is tier one, >8,000 — 22,000 is tier 2, and over 22,000 is tier 3. Our tier cutoffs are at 10,000 and 25,000 gallons. This will not have a significant impact on revenue, but would match up the tiers which is already the case with customers served by Wayzata. Another change that staff is recommending is that commercial and multifamily residential buildings have their base fee calculated on the number of SAC units attributed to the building by the Metropolitan Council. This change is seen as a fairness issue with a resident of an apartment paying only a small percentage of the base fee while a resident in a single family home pays $50. This change would increase revenue by $26,000. The water rate charts have been prepared with this change. Staff is also considering reducing the tier structure for these properties and is currently working on a revenue estimate. Other options that are shown on the rate charts include moving the antenna revenue back to the Water Fund. One scenario would be to phase this in starting in 2023 once the Pavement Management Levy can provide sufficient funding. The other would be to move it starting in 2020, this would have the greatest impact in next year's rates — decreasing the increase to 25% instead of 30%. The greatest impact to rates moving forward would be if Minnetonka Beach enters into an agreement to purchase water from Orono. The rate increases for the next two years would be reduced to 20% and 16% repeatedly. Unless an agreement with Minnetonka Beach is reach by the end of the year, staff would suggest approving rates with the assumption that Minnetonka Beach is not purchasing water for 2020. A comparison chart is included so these changes can be easily compared. Stormwater The Stormwater Fund also needs a significant rate increase, but the current fee is much lower than the other utility fees so the impact on the customer will be less. Charts have been prepared detailing a 60% increase in 2020 and a 40% increase in 2021. This would provide adequate funding, but in 2025 the rate would be nearing $60 per quarter. If the council is willing, staff would recommend a 95% increase in 2020 with a 7% increase in 2021. This would provide the needed funding but would keep the 2025 rate at $55. The third stormwater chart is based on moving $100,000 for culverts out of this fund and into the Street Department. Sewer The calculated amounts for Sewer are based on a 20% increase in 2020 with a 15% increase in 2021. In years after 2021, the rate increases would be in the 2% range. Recyclin2 As discussed when the recycling RFP was approved, recycling rates need a significant (60%) increase next 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. This would be followed by a 10% increase in 2021 and 4% increases thereafter. Future increases could be less if there is a recovery in the recycled materials market. 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. Other Issues • One of the growing complaints that we are receiving concerns the cost of the utilities. Staff feels that part of this concern is a direct result of our quarterly billing cycle. Currently, customers that are connected to both the water and sewer systems are seeing bills approaching $400 or more. If we billed customers quarterly, a $400 quarterly bill would be reduced to $133 per month. This amount is in the same range as cable TV, cell phones, electricity, and gas. The City also has a relatively high number of customers that have all or part of their bills certified for collection with their taxes. Monthly billing may help reduce this occurrence. Monthly billing would help to equalize cash flow from payments, with a smaller amount collected every month versus the quarterly collection of a larger amount. Staff is also considering a shut off policy to help reduce the number of delinquent accounts. This would only work for accounts on water system which on an annual basis represent approximately one-third of the certifications. Monthly billing would also help identify high usage do to leaks in a more timely matter. This would reduce customer frustration at receiving large bills for water that is wasted. Staff estimates that a monthly billing cycle would add around $25,000 in expenses, not including staff time. • Staff is also exploring ways to televise individual sewer connections. It has been estimated that as much as 80% of I&I occurs in these private sewer connection. The City has been contacted by a company that provides insurance for private water and sewer connections. Staff has discussed offering to televise sewer service connections at no charge for residents that sign up for this insurance. Staff has also discussed adding an $8.00 to $10.00 fee to customer's bills and the City would in effect self -insure the private connections. There is also the possibility to work with the Metropolitan Council for funding assistance for servicing private sewer connections. Staff is looking for council input on this matter. • Staff is also considering a water shutoff policy. This would be a more effective method of collecting delinquent accounts than the certification process. It will only impact around 1/3 of the customers that are regularly certified. It is possible that this could be negatively received by the public. Staff is looking for direction on the utility rate increases and if the council is interested in monthly billing, a service line inspection program, and water shutoffs. Water Rate Summary Current Rates - 2019 Quarterly Flat Rate $50.00 Tier 1 $5.24 Tier 2 $7.33 Tier 3 $11.00 2020 2021 2022 2023 2024 2025 Standard Increase 35% 20% 10% 1% 1% 1% Phase In $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $8.02 $7.07 $8.49 $9.34 $9.43 $9.53 $9.62 $11.44 $9.90 $11.87 $13.06 $13.19 $13.32 $13.461 $19.27 $14.85 $17.82 $19.60 $19.80 $20.00 $20.20 With Minnetonka Beach 20% 16% 2% 2% 2% 2% Phase In $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $8.02 $6.29 $7.29 $7.44 $7.59 $7.74 $7.90 $11.44 $8.80 $10.20 $10.41 $10.62 $10.83 $11.04 $19.27 $13.20 $15.31 $15.62 $15.93 $16.25 $16.57 With Antenna Lease Phase In 35% 20% 6% 1% 1% 1% Phase In $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $8.02 $7.07 $8.49 $9.00 $9.09 $9.18 $9.27 $11.44 $9.90 $11.87 $12.59 $12.71 $12.84 $12.971 $19.27 $14.85 $17.82 $18.89 $19.08 $19.27 $19.46 With Minnetonka Beach & Antenna Lease 20% 9% 2% 2% 2% 2% Phase In $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $8.02 $6.29 $6.85 $6.99 $7.13 $7.27 $7.42 $11.44 $8.80 $9.59 $9.78 $9.97 $10.17 $10.381 $19.27 $13.20 $14.39 $14.68 $14.97 $15.27 $15.57 Increase with Antenna Lease 25% 20% 2% 2% 1% 1% $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $6.55 $7.86 $8.02 $8.18 $9.18 $9.27 $9.16 $11.00 $11.21 $11.44 $12.84 $12.971 $13.75 $16.50 $16.83 $17.17 $19.27 $19.461 2020 - 2025 Water Fund Forecast Base Charge Increase 2% or $ 50.00 Active Rate Increase from Prior Year 35% 20% 10% 1% 1% 1% Inflation - 5 Yr Forecast Budgeted Amt 2.04% 2.07% 2.12% 2.07% 2.07% Tier 1 to 2 Rate Increase 26% Inactive Tier 2 to 3 Rate Increase 50% Inactive Based on 2013-2018 Avg Consumption 2019 2020 2021 2022 2023 2024 2025 Calculated Calculated Calculated Calculated Calculated Calculated Calculated Amount Amount Amount Amount Amount Amount Amount Total Estimated Revenue $ 881,213.78 $ 1,144,624.49 $ 1,287,205.32 $ 1,388,353.82 $ 1,399,480.16 $ 1,410,717.75 $ 1,422,067.73 Estimated Cash Expenses 1,138,155.00 1,253,735.00 1,289,943.98 1,330,069.66 1,331,467.77 1,301,608.30 1,369,247.32 Gain / (Loss) - Non-cash basis (48,496.22) 156,374.49 277,816.34 348,356.16 318,731.39 295,716.45 279,659.41 Gain / (Loss) - Cash basis (256,941.22) (109,110.51) (2,738.66) 58,284.16 68,012.39 109,109.45 52,820.41 Beg. Cash 610,690.31 Cash Balance 353,749.09 244,638.58 241,899.93 300,184.09 368,196.48 477,305.93 530,126.34 average capital expenditure requirements with 3% inflation ................................................................................................................................................................... $ 234,966.00 ..... $ ............................................. 242,014.98 $ 249,275.43 ............................................. $ ............................................. 256,753.69 $ ............................................. 264,456.30 $ ............................................. 272,389.99 $ ............................................ 280,561.69 Operation Reserve Goal 25% of Expenses $ 92,971.00 $ 148,237.50 $ 201,877.80 $ 259,999.42 $ 270,187.19 $ 278,750.33 $ 285,602.08 Capital Reserve 25% of expenses $ - $ - $ - $ 25,675.37 $ 39,668.45 $ 54,478.00 $ 70,140.42 Total Cash Reserve Required 92,971.00 148,237.50 201,877.80 285,674.78 309,855.64 333,228.32 355,742.50 Excess Funds over Cash Reserve 260,778.09 96,401.08 40,022.13 14,509.30 58,340.84 144,077.60 174,383.83 Flat Rate $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 Tier 1 $5.24 $7.07 $8.49 $9.34 $9.43 $9.53 $9.62 Tier 2 $7.33 $9.90 $11.87 $13.06 $13.19 $13.32 $13.46 Tier 3 $11.00 $14.85 $17.82 $19.60 $19.80 $20.00 $20.20 2020 - 2025 Water Fund Forecast With Minnetonka Beach Base Charge Increase 2% or $ 50.00 Active Rate Increase from Prior Year 20% 16% 2% 2% 2% 2% Inflation - 5 Yr Forecast Budgeted Amt 2.04% 2.07% 2.12% 2.07% 2.07% Tier 1 to 2 Rate Increase 26% Inactive Tier 2 to 3 Rate Increase 50% Inactive Based on 2013-2018 Avg Consumption 2019 2020 2021 2022 2023 2024 2025 Calculated Calculated Calculated Calculated Calculated Calculated Calculated Amount Amount Amount Amount Amount Amount Amount Total Estimated Revenue $ 881,213.78 $ 1,233,320.47 $ 1,356,376.50 $ 1,377,989.62 $ 1,400,035.00 $ 1,422,521.30 $ 1,445,457.32 Estimated Cash Expenses 1,138,155.00 1,378,735.00 1,289,943.98 1,330,069.66 1,331,467.77 1,301,608.30 1,369,247.32 Gain / (Loss) - Non-cash basis (48,496.22) 245,070.47 346,987.52 337,991.96 319,286.24 307,520.00 303,049.00 Gain / (Loss) - Cash basis (256,941.22) (145,414.53) 66,432.52 47,919.96 68,567.24 120,913.00 76,210.00 Beg. Cash 610,690.31 Cash Balance 353,749.09 208,334.57 274,767.08 322,687.04 391,254.28 512,167.27 588,377.27 average capital expenditure requirements with 3% inflation ........................................................................................................................................................................ $ 234,966.00 $ ............................................. 242,014.98 $ 249,275.43 ............................................. $ ............................................. 256,753.69 $ ............................................. 264,456.30 $ ............................................. 272,389.99 $ ............................................ 280,561.69 Operation Reserve Goal 25% of Expenses $ 92,971.00 $ 148,237.50 $ 201,877.80 $ 259,999.42 $ 270,187.19 $ 278,750.33 $ 285,602.08 Capital Reserve 25% of expenses $ - $ - $ - $ 64,188.42 $ 66,114.08 $ 68,097.50 $ 70,140.42 Total Cash Reserve Required 92,971.00 148,237.50 201,877.80 324,187.84 336,301.27 346,847.82 355,742.50 Excess Funds over Cash Reserve 260,778.09 60,097.07 72,889.29 (1,500.80) 54,953.01 165,319.45 232,634.77 Flat Rate $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 Tier 1 $5.24 $6.29 $7.29 $7.44 $7.59 $7.74 $7.90 Tier 2 $7.33 $8.80 $10.20 $10.41 $10.62 $10.83 $11.04 Tier 3 $11.00 $13.20 $15.31 $15.62 $15.93 $16.25 $16.57 Minnetonka Beach Water Rate 6.29 $7.29 $7.44 $7.59 $7.74 $7.90 2020 - 2025 Water Fund Forecast with Antenna Lease Phase In Base Charge Increase 2% or $ 50.00 Active Rate Increase from Prior Year 35% 20% 6% 1% 1% 1% Inflation - 5 Yr Forecast Budgeted Amt 2.04% 2.07% 2.12% 2.07% 2.07% Tier 1 to 2 Rate Increase 26% Inactive Tier 2 to 3 Rate Increase 50% Inactive Based on 2013-2018 Avg Consumption 2019 2020 2021 2022 2023 2024 2025 Calculated Calculated Calculated Calculated Calculated Calculated Calculated Amount Amount Amount Amount Amount Amount Amount Total Estimated Revenue $ 881,213.78 $ 1,144,624.49 $ 1,287,205.32 $ 1,372,894.42 1 $ 1,408,616.16 $ 1,444,445.12 $ 1,480,382.37 *Antenna Lease Phase in Starts 2022 Estimated Cash Expenses 1,138,155.00 1,253,735.00 1,289,943.98 1,330,069.66 1,331,467.77 1,301,608.30 1,369,247.32 Gain / (Loss) - Non-cash basis (48,496.22) 156,374.49 277,816.34 332,896.76 327,867.40 329,443.82 337,974.05 Gain / (Loss) - Cash basis (256,941.22) (109,110.51) (2,738.66) 42,824.76 77,148.40 142,836.82 111,135.05 Beg. Cash 610,690.31 Cash Balance 353,749.09 244,638.58 241,899.93 284,724.69 361,873.08 504,709.90 615,844.95 average capital expenditure requirements with 3% inflation .................................................................................................................................................................................................................................................................................................................................................................................................................................................. $ 234,966.00 $ 242,014.98 $ 249,275.43 $ 256,753.69 $ 264,456.30 $ 272,389.99 $ 280,561.69 Operation Reserve Goal 25% of Expenses $ 92,971.00 $ 148,237.50 $ 201,877.80 $ 259,999.42 $ 270,187.19 $ 278,750.33 $ 285,602.08 Capital Reserve 25% of expenses $ - $ - $ - $ 25,675.37 $ 39,668.45 $ 54,478.00 $ 70,140.42 Total Cash Reserve Required 92,971.00 148,237.50 201,877.80 285,674.78 309,855.64 333,228.32 355,742.50 Excess Funds over Cash Reserve 260,778.09 96,401.08 40,022.13 (950.10) 52,017.45 171,481.58 260,102.45 Flat Rate $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 Tier 1 $5.24 $7.07 $8.49 $9.00 $9.09 $9.18 $9.27 Tier 2 $7.33 $9.90 $11.87 $12.59 $12.71 $12.84 $12.97 Tier 3 $11.00 $14.85 $17.82 $18.89 $19.08 $19.27 $19.46 2020 - 2025 Water Fund Forecast With Minnetonka Beach and Antenna Lease Phase In Base Charge Increase 2% or $ 50.00 Active Rate Increase from Prior Year 20% 9% 2% 2% 2% 2% Inflation - 5 Yr Forecast Budgeted Amt 2.04% 2.07% 2.12% 2.07% 2.07% Tier 1 to 2 Rate Increase 26% Inactive Tier 2 to 3 Rate Increase 50% Inactive Based on 2013-2018 Avg Consumption 2019 2020 2021 2022 2023 2024 2025 Calculated Calculated Calculated Calculated Calculated Calculated Calculated Amount Amount Amount Amount Amount Amount Amount Total Estimated Revenue $ 881,213.78 $ 1,233,320.47 $ 1,291,164.49 $ 1,336,473.37 $ 1,382,188.43 $ 1,428,317.79 $ 1,474,869.74 Estimated Cash Expenses 1,138,155.00 1,253,735.00 1,289,943.98 1,330,069.66 1,331,467.77 1,301,608.30 1,369,247.32 Gain / (Loss) - Non-cash basis (48,496.22) 245,070.47 281,775.51 296,475.71 301,439.66 313,316.49 332,461.42 Gain / (Loss) - Cash basis (256,941.22) (20,414.53) 1,220.51 6,403.71 50,720.66 126,709.49 105,622.42 Beg. Cash 610, 690.31 Cash Balance 353,749.09 333,334.57 334,555.07 340,958.78 391,679.44 518,388.93 624,011.35 average capital expenditure requirements with 3% inflation $ 234,966.00 $ 242,014.98 $ 249,275.43 $ 256,753.69 $ 264,456.30 $ 272,389.99 $ 280,561.69 ..................................................................................I.............................. Operation Reserve Goal 25% of Expenses ....................................................... $ 92,971.00 ............................................ $ 148,237.50 ............................................ $ 201,877.80 ............................................. $ 259,999.42 ............................................. $ 270,187.19 ............................................. $ 278,750.33 ............................................. $ 285,602.08 Capital Reserve 25% of expenses $ - $ - $ - $ 64,188.42 $ 66,114.08 $ 68,097.50 $ 70,140.42 Total Cash Reserve Required 92,971.00 148,237.50 201,877.80 324,187.84 336,301.27 346,847.82 355,742.50 Excess Funds over Cash Reserve 260,778.09 185,097.07 132,677.28 16,770.94 55,378.18 171,541.11 268,268.85 Flat Rate $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 Tier 1 $5.24 $6.29 $6.85 $6.99 $7.13 $7.27 $7.42 Tier 2 $7.33 $8.80 $9.59 $9.78 $9.97 $10.17 $10.38 Tier 3 $11.00 $13.20 $14.39 $14.68 $14.97 $15.27 $15.57 Minnetonka Beach Water Rate 6.29 $6.85 $6.99 $7.13 $7.27 $7.42 2020 - 2025 Water Fund Forecast with Antenna Lease Base Charge Increase 2% or $ 50.00 Active Rate Increase from Prior Year 25% 20% 2% 2% 1% 1% Inflation - 5 Yr Forecast Budgeted Amt 2.04% 2.07% 2.12% 2.07% 2.07% Tier 1 to 2 Rate Increase 26% Inactive Tier 2 to 3 Rate Increase 50% Inactive Based on 2013-2018 Avg Consumption 2019 2020 2021 2022 2023 2024 2025 Calculated Calculated Calculated Calculated Calculated Calculated Calculated Amount Amount Amount Amount Amount Amount Amount Total Estimated Revenue $ 881,213.78 $ 1,182,187.15 $ 1,312,280.51 $ 1,331,011.71 $ 1,350,117.54 $ 1,359,861.51 $ 1,369,702.92 Estimated Cash Expenses 1,138,155.00 1,253,735.00 1,289,943.98 1,330,069.66 1,331,467.77 1,301,608.30 1,369,247.32 Gain / (Loss) - Non-cash basis (48,496.22) 193,937.15 302,891.53 291,014.05 269,368.77 244,860.21 227,294.60 Gain / (Loss) - Cash basis (256,941.22) (71,547.85) 22,336.53 942.05 18,649.77 58,253.21 455.60 Beg. Cash 610, 690.31 Cash Balance 353,749.09 282,201.24 304,537.77 305,479.82 324,129.59 382,382.80 382,838.40 average capital expenditure requirements with 3% inflation $ 234,966.00 $ 242,014.98 $ 249,275.43 $ 256,753.69 $ 264,456.30 $ 272,389.99 $ 280,561.69 ..................................................................................I.............................. Operation Reserve Goal 25% of Expenses ....................................................... $ 92,971.00 ............................................ $ 148,237.50 ............................................ $ 201,877.80 ............................................. $ 259,999.42 ............................................. $ 270,187.19 ............................................. $ 278,750.33 ............................................. $ 285,602.08 Capital Reserve 25% of expenses $ - $ - $ - $ 25,675.37 $ 39,668.45 $ 54,478.00 $ 70,140.42 Total Cash Reserve Required 92,971.00 148,237.50 201,877.80 285,674.78 309,855.64 333,228.32 355,742.50 Excess Funds over Cash Reserve 260,778.09 133,963.74 102,659.97 19,805.03 14,273.95 49,154.48 27,095.90 Flat Rate $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 Tier 1 $5.24 $6.55 $7.86 $8.02 $8.18 $8.26 $8.34 Tier 2 $7.33 $9.16 $11.00 $11.21 $11.44 $11.55 $11.67 Tier 3 $11.00 $13.75 $16.50 $16.83 $17.17 $17.34 $17.51 Stormwater Rate Summary Current Rates - 2019 *10% increase from 2018 Quarterly Amount $24.34 Yearly Amount $97.36 2020 2021 2022 2023 2024 2025 Standard Increase 60% 40% 3% 2% 2% 2% *Start Phase -back in 2022 38.94 54.52 56.16 57.28 58.43 59.59 $155.78 $218.09 $224.63 $229.12 $233.70 $238.38 Front End Hit 95% 7% 2% 2% 2% 2% *Start Phase -back in 2022 47.46 50.79 51.80 52.84 53.89 54.97 $189.85 $203.14 $207.20 $211.35 $215.58 $219.89 Less Culverts $100k 90% 2% 2% 2% 2% 2% *Start Phase -back in 2022 46.25 47.17 48.11 49.08 50.06 51.06 $184.98 $188.68 $192.46 $196.31 $200.23 $204.24 2020 - 2025 Stormwater Fund Forecast 2019 2020 2021 2022 2023 2024 2025 Rate Increase 60% 40% 3% 2% 2% 2% Rate = $24.34 Rate = $38.94 Rate = $54.52 Rate = $56.16 Rate = $57.28 Rate = $58.43 Rate = $59.59 Total Total Total Total Total Total Total Estimated Revenue 352,218.06 569,935.70 797,909.99 821,847.29 838,284.23 855,049.92 872,150.91 Inflation Budgeted Amt 2.04% 2.07% 2.12% 2.07% 2.07% Total Cash Expenditure 976,685.00 991,425.00 735,464.40 855,073.43 703,390.39 817,232.55 796,616.44 Gain / (Loss) - Non-cash basis (4,591.94) 196,935.70 409,111.59 419,798.86 421,096.84 424,752.37 426,530.48 Gain / (Loss) - Cash basis (624,466.95) (421,489.30) 62,445.59 (33,226.14) 134,893.84 37,817.37 75,534.48 Beg Cash 1,293,812.81 669,345.87 247,856.57 310,302.15 277,076.01 411,969.85 449,787.22 Year End Cash Balance 669,345.87 247,856.57 310,302.15 277,076.01 411,969.85 449,787.22 525,321.69 average capital expenditure requirements with 3% inflation (2018-2034) ................................................................................................................. 648,643.00 ....................................................................................................................................................................................................................................................................................................................................... 668,102.29 688,145.36 708,789.72 730,053.41 751,955.01 774,513.66 Operation Reserve Goal 25% of Expenses 89,202.50 93,250.00 97,199.60 100,512.11 104,296.85 107,574.39 111,405.11 Capital Reserve 25% of expenses 0.00 0.00 172,036.34 177,197.43 182,513.35 187,988.75 193,628.42 Total Cash Reserve Required 89,202.50 93,250.00 269,235.94 277,709.54 286,810.20 295,563.14 305,033.53 Excess Funds over Cash Reserve 580,143.37 154,606.57 41,066.21 (633.53) 125,159.65 154,224.08 220,288.17 2020 - 2025 Stormwater Fund Forecast 2019 2020 2021 2022 2023 2024 2025 Rate Increase 95% 7% 2% 2% 2% 2% Rate = $24.34 Rate = $47.46 Rate = $50.79 Rate = $51.8 Rate = $52.84 Rate = $53.89 Rate = $54.97 Total Total Total Total Total Total Total Estimated Revenue 352,218.06 694,609.14 743,231.78 758,096.41 773,258.34 788,723.51 804,497.98 Inflation Budgeted Amt 2.04% 2.07% 2.12% 2.07% 2.07% Total Cash Expenditure 976,685.00 991,425.00 735,464.40 855,073.43 703,390.39 817,232.55 796,616.44 Gain / (Loss) - Non-cash basis (4,591.94) 321,609.14 354,433.38 356,047.99 356,070.95 358,425.96 358,877.54 Gain / (Loss) - Cash basis (624,466.95) (296,815.86) 7,767.38 (96,977.01) 69,867.95 (28,509.04) 7,881.54 Beg Cash 1,293,812.81 669,345.87 372,530.00 380,297.38 283,320.37 353,188.32 324,679.28 Year End Cash Balance 669,345.87 372,530.00 380,297.38 283,320.37 353,188.32 324,679.28 332,560.82 average capital expenditure requirements with 3% inflation (2018-2034) ......................................................................................................................................................................................................................................................................................................................................................................................................................................................... 648,643.00 668,102.29 688,145.36 708,789.72 730,053.41 751,955.01 774,513.66 Operation Reserve Goal 25% of Expenses 89,202.50 93,250.00 97,199.60 100,512.11 104,296.85 107,574.39 111,405.11 Capital Reserve 25% of expenses 0.00 0.00 172,036.34 177,197.43 182,513.35 187,988.75 193,628.42 Total Cash Reserve Required 89,202.50 93,250.00 269,235.94 277,709.54 286,810.20 295,563.14 305,033.53 Excess Funds over Cash Reserve 580,143.37 279,280.00 111,061.44 5,610.83 66,378.12 29,116.14 27,527.30 2020 - 2025 Stormwater Fund Forecast less 100k for Culverts (phase in start 2022) 2019 2020 2021 2022 2023 2024 2025 Rate Increase 90% 2% 2% 2% 2% 2% Rate = $24.34 Rate = $46.25 Rate = $47.17 Rate = $48.11 Rate = $49.08 Rate = $50.06 Rate = $51.06 Total Total Total Total Total Total Total Estimated Revenue 352,218.06 676,798.65 690,334.62 704,141.31 718,224.14 732,588.62 747,240.40 Inflation Budgeted Amt 2.04% 2.07% 2.12% 2.07% 2.07% Total Cash Expenditure 976,685.00 891,425.00 635,464.40 780,073.43 653,390.39 792,232.55 796,616.44 Gain / (Loss) - Non-cash basis (4,591.94) 303,798.65 301,536.22 302,092.88 301,036.75 302,291.08 301,619.96 Gain / (Loss) - Cash basis (624,466.95) (214,626.35) 54,870.22 (75,932.12) 64,833.75 (59,643.92) (49,376.04) Beg Cash 1,293,812.81 669,345.87 454,719.51 509,589.73 433,657.62 498,491.37 438,847.44 Year End Cash Balance 669,345.87 454,719.51 509,589.73 433,657.62 498,491.37 438,847.44 389,471.40 average capital expenditure requirements with 3% inflation (2018-2034) ......................................................................................................................................................................................................................................................................................................................................................................................................................................................... 648,643.00 668,102.29 688,145.36 708,789.72 730,053.41 751,955.01 774,513.66 Operation Reserve Goal 25% of Expenses 89,202.50 93,250.00 97,199.60 100,512.11 104,296.85 107,574.39 111,405.11 Capital Reserve 25% of expenses 0.00 0.00 172,036.34 177,197.43 182,513.35 187,988.75 193,628.42 Total Cash Reserve Required 89,202.50 93,250.00 269,235.94 277,709.54 286,810.20 295,563.14 305,033.53 Excess Funds over Cash Reserve 580,143.37 361,469.51 240,353.80 155,948.08 211,681.16 143,284.30 84,437.87 2020 - 2025 Sewer Fund Forecast 2019 2020 2021 2022 2023 2024 2025 Rate Increase 20% 15% 2% 2% 2% 2% Rate By Unit $156.80; Add'I $138.60 $188.16; Add'I $166.32 $216.38; Add'I $191.27 $220.71; Add'I $195.09 $225.13; Add'I $199 $229.63; Add'1 $202.98 $234.22; Add'I $207.03 Rate By Flow (Base & per thousand) 15.00 5.80 6.96 8.00 8.16 8.33 8.49 8.66 Rate Amount Rate Amount Rate Amount Rate Amount Rate Amount Rate Amount Rate Amount Total Estimated Revenue 1,581,459.80 1,893,777.96 2,167,561.30 2,206,871.17 2,248,437.91 2,285,575.63 2,330,935.76 Expenditure Inflation: Budgeted Amt 2.04% 2.07% 2.12% 2.07% 2.07% Total Expenditure - Cash Basis 2,324,243.00 2,447,350.00 2,352,427.04 2,240,542.43 2,499,585.03 1,985,166.05 2,688,992.26 Beg. Cash 2,578,241.13 Gain / (Loss) - Cash basis (742,783.20) (553,572.04) (184,865.74) (33,671.26) (251,147.12) 300,409.58 (358,056.49) Estimated YE Cash Balance 1,835,457.93 1,281,885.89 1,097,020.15 1,063,348.89 812,201.78 1,112,611.36 754,554.86 average capital expenditure requirements with 3% inflation (2018-2034) .................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................. 792,795.00816,578.85 841,076.22 866,308.50 892,297.76 919,066.69 946,638.69 Operation Reserve Goal 2S% of Expenses 406,043.75 447,800.00 461,006.76 473,599.86 484,792.76 495,319.51 505,949.31 Capital Reserve 25% of expenses 0.00 0.00 1 210,269.05 216,577.13 223,074.44 229,766.67 236,659.67 Total Cash Reserve Required 671,275.81 690,176.98 707,867.20 725,086.19 742,608.99 Excess Funds over Cash Reserve 425,744.34 373,171.91 104,334.58 387,525.17 11,945.88 2020 - 2025 Recycling Fund Forecast 2019 2020 2021 2022 2023 2024 2025 Rate Increase 60% 10% 4% 4% 4% 4% Rate = $10 Rate = $16 Rate = $17.6 Rate = $18.3 Rate = $19.04 Rate = $19.8 Rate = $20.59 Total Revenue 156,494.00 230,632.00 251,195.20 260,243.01 269,652.73 279,438.84 289,616.39 Inflation Budgeted Amt 4.0% 4.0% 0.0% 4.0% 4.0% Total Cash Expenditure 162,239.40 216,700.00 225,368.00 234,382.72 234,382.72 243,758.03 2531508.35 Gain / (Loss) - Cash basis (5,745.40) 13,932.00 25,827.20 860.29 10,270.01 10,680.81 111108.04 Beg Cash 65,122.31 59,376.91 73,308.91 99,136.11 99,996.40 110,266.41 1201947.21 Year End Cash Balance 59,376.91 73,308.91 99,136.11 99,996.40 110,266.41 120,947.21 132,055.26 2020 - 2025 Sample Bills Quarter XYZ Quarter XYZ Quarter XYZ Quarter XYZ Year 2019 Year 2020 Year 2021 Year 2022 BILL DETAIL BILL DETAIL BILL DETAIL BILL DETAIL Usage Usage Usage Usage WATER 15 $139.05 WATER 15 $170.22WATER 15 $194.26 WATER 15 $208.69 SEWER FLAT $ 156.80 SEWER FLAT $ 188.16 SEWER FLAT $ 216.38 SEWER FLAT $ 220.71 WATER TEST FEE $ 1.59 WATER TEST FEE $ 1.59 WATER TEST FEE $ 1.59 WATER TEST FEE $ 1.59 STORM WATER $ 24.34 STORM WATER $ 38.94 STORM WATER $ 54.52 STORM WATER $ 56.16 RECYCLING $ 10.00 RECYCLING $ 16.00 RECYCLING $ 17.60 RECYCLING $ 18.30 Total Amount Due $ 331.78 Total Amount Due - Qrtly $ 414.91 Total Amount Due - Qrtly $ 484.36 Total Amount Due - Qrtly $ 505.45 *2019 is based on Actual Rates Total Amount Due - Mos $ 138.30 Total Amount Due - Mos $ 161.45 Total Amount Due - Mos $ 168.48 Increase from Prior Year 25% 17% 4% Quarter XYZ Quarter XYZ Quarter XYZ Year 2023 Year 2024 Year 2025 BILL DETAIL BILL DETAIL BILL DETAIL Usage Usage Usage WATER 15 $210.27WATER 15 $211.88 WATER 15 $213.50 SEWER FLAT $ 225.13 SEWER FLAT $ 229.63 SEWER FLAT $ 234.22 WATER TEST FEE $ 1.59 WATER TEST FEE $ 1.59 WATER TEST FEE $ 1.59 STORM WATER $ 57.28 STORM WATER $ 58.43 STORM WATER $ 59.59 RECYCLING $ 19.04 RECYCLING $ 19.80 RECYCLING $ 20.59 Total Amount Due - Qrtly $ 513.31 Total Amount Due - Qrtly $ 521.32 Total Amount Due - Qrtly $ 529.49 Total Amount Due - Mos $ 171.10 Total Amount Due - Mos $ 173.77 Total Amount Due - Mos $ 176.50 Increase from Prior Year 2% 2% 2% 2020 - 2025 Sample Bills with Minnetonka Beach Contract Quarter XYZ Quarter XYZ Quarter XYZ Quarter XYZ Year 2019 Year 2020 Year 2021 Year 2022 BILL DETAIL BILL DETAIL BILL DETAIL BILL DETAIL Usage Usage Usage Usage WATER 15 $139.05 WATER 15 $156.86WATER 15 $173.96 WATER 15 $176.44 SEWER FLAT $ 156.80 SEWER FLAT $ 188.16 SEWER FLAT $ 216.38 SEWER FLAT $ 220.71 WATER TEST FEE $ 1.59 WATER TEST FEE $ 1.59 WATER TEST FEE $ 1.59 WATER TEST FEE $ 1.59 STORM WATER $ 24.34 STORM WATER $ 38.94 STORM WATER $ 54.52 STORM WATER $ 56.16 RECYCLING $ 10.00 RECYCLING $ 16.00 RECYCLING $ 17.60 RECYCLING $ 18.30 Total Amount Due $ 331.78 Total Amount Due - Qrtly $ 401.55 Total Amount Due - Qrtly $ 464.05 Total Amount Due - Qrtly $ 473.20 *2019 is based on Actual Rates Total Amount Due - Mos $ 133.85 Total Amount Due - Mos $ 154.68 Total Amount Due - Mos $ 157.73 Increase from Prior Year 21% 16% 2% Quarter XYZ Quarter XYZ Quarter XYZ Year 2023 Year 2024 Year 2025 BILL DETAIL BILL DETAIL BILL DETAIL Usage Usage Usage WATER 15 $178.97WATER 15 $181.54 WATER 15 $184.18 SEWER FLAT $ 225.13 SEWER FLAT $ 229.63 SEWER FLAT $ 234.22 WATER TEST FEE $ 1.59 WATER TEST FEE $ 1.59 WATER TEST FEE $ 1.59 STORM WATER $ 57.28 STORM WATER $ 58.43 STORM WATER $ 59.59 RECYCLING $ 19.04 RECYCLING $ 19.80 RECYCLING $ 20.59 Total Amount Due - Qrtly $ 482.00 Total Amount Due - Qrtly $ 490.99 Total Amount Due - Qrtly $ 500.17 Total Amount Due - Mos $ 160.67 Total Amount Due - Mos $ 163.66 Total Amount Due - Mos $ 166.72 Increase from Prior Year 2% 2% 2% TO: Mayor Walsh and Council Members FROM: Ron Olson, Finance Director DATE: October 28, 2019 SUBJECT: 2020 Enterprise Fund Budgets Attachments: 1. Enterprise Funds Summary 2. Enterprise Fund Line Items 3. CIP Pages The enterprise fund budgets consist of the Water, Sewer, Stormwater, Recycling and Cable TV Funds. Unlike the General Fund, the accounting in the enterprise funds is similar to the accounting practices of private enterprise. The goal of the enterprise funds is to operate independent of tax support. 2012 was the first year that a formal budget was adopted for the enterprise funds. Prior to 2010, the enterprise funds did not attempt to cover depreciation expenses. Beginning with the completion of the 2009 rate study, the suggested rate increases were designed to cover depreciation. The rate study is reviewed annually and the suggested rate increases are used to set the annual revenue budget. Updated rate study information is included with this memo. Water Fund In 2018 the Water Fund experienced an operating loss of $129,659. In previous years, operating losses were offset by the lease revenue received from the telecommunications companies with antennas on the tower. In 2018, this revenue source was moved to the Pavement Management Fund to help fund the City's road infrastructure. As a result of the reduction of this revenue the operating loss was not offset and the Fund experiences a net loss of $96,264. Expenditures for capital improvements and debt service impact cash flow but are balance sheet items and are not recorded on the income statement. When these items are included and depreciation (a non-cash expenditure) is backed out, the fund had a negative cash flow of $287,401. The current cash balance of the fund is $217,004. The expenditure budget information was provided to the Council as part of the August 26' work session. The expenditure budget is increasing by $57,230 (6.2%). $38,000 of the increase is in the Other Expenses Category. Specific line items increasing are Gas and Electric, Depreciation, and Intergovernmental Services. The increased utilities and depreciation are the result of the addition of Well number four to the water system. Intergovernmental Services are charges from Long Lake and Wayzata for properties connected to their utility systems. The $16,000 increase in Professional Services is partially offset by a reduction in the Supplies and Maintenance category. This is the result of shifting expenses to the new IT Fund and Fleet services. The line items recording the expenses are now under Professional Services instead of Supplies and Maintenance. Personal services are increasing by $5,670 which is the result of an increase in contract wages and in the City's insurance benefit contribution. A total of $335,855 of capital expenditures are identified in the 2019 draft CIP include: Valve Replacements ($166,000) and the replacement of the water main at CSAH15/19. In order to fund infrastructure improvements without using special assessments or tax support, the water rates will need to increase significantly. Information on utility rates for all of the Enterprise Funds are included with the utility rates memo. The Water Fund's current cash balance is $217,004. Sewer Fund In 2018 the Sewer Fund experienced an operating gain of $116,218. When non-operating revenues like interest earnings and connection fees are added, the fund experienced a net profit of $155,000. The expenditure budget information was provided to the Council as part of the August 26th work session. The expenditure budget is increasing by $171,025 (9.9%). $108,225 of the increase is in the Other Expenses Category. Specific line items increasing are MCES-Sewer, Depreciation, and Intergovernmental Services. The increased MCES charges are based on the metered flow into the Met Council sewer mains. The recent string of wet summers has resulted in significant I&I in the system and as a result, the City's MCES charges have increased from $359,863 in 2013 to $619,395 in 2020. This is a 72% increase in the largest single line item and it will likely increase significantly again in 2021. Intergovernmental Services are charges from Long Lake and Wayzata for properties connected to their utility systems. The other significant increase is the line for I&I reduction; this is increasing by $50,000. Personal services are increasing by $3,750 which is the result of an increase in contract wages and in the City's insurance benefit contribution. A total of $744,000 of capital expenditures are identified in the 2020 draft CIP include: Sewer Rehabilitation ($290,000); a Generator for Lift Station #3 and #13 ($150,000); Lift Station #19 and #30 Rehabilitation ($120,000); Windjammer Road Main Rehabilitation ($24,750) and the replacement of the force main at CSAH15/19 ($180,000). In order to fund infrastructure improvements without using special assessments or tax support, the water rates will need to increase. Information on utility rates for all of the Enterprise Funds are included with the utility rates memo. Storm Water The Stormwater Fund is for the most part project based. Operating expenditures are mainly limited to engineering associated with NPDES, SWPPP and other state and federal requirements. Public Works time and materials spent on culvert cleaning/replacement are also charged to this fund. The purpose of this fund is to collect money for future Stormwater projects. The funds current cash balance is $580,000. Potential CIP projects in 2020 include: Projects in Conjunction with Road Projects ($128,925), Casco Point Park Outlet — SWMP 0-1 ($58,000), Casco Point Park Bioretention Basin — SWMP CB - 1 ($55,000), South Casco Point Road Sump ($36,000), East long Lake Road N ($102,000), Storm Sewer Improvements ($200,000). Recyclin2 The Recycling Fund expenditure budget is increasing by $79,670 (59.2%). Its major expenditure line is for contracted recycling charges. The newly approved contract with Waste Management is increasing by $73,120 (62%). This large increase is the result of a historically weak recycled materials market. The income that haulers used to receive by selling the materials collected, are now being recovered through rate increases. The full time wages that are charged to the fund represent 10% of the City Clerks wages. The current cash balance is $40,302. Cable The Cable fund was new for the 2015 budget. The projected revenues are based on current subscriber information and rates. The line item for Internet/Other communications covers the costs associated with streaming and online access of council meetings. It has been increased to pay for the increased cost of our fiber internet connection. Revenue for the fund is in the from franchise fees that are set by the City's franchise agreement with Mediacom. There are no capital expenditures planned for 2020. The current cash balance of the fund is $155,252. With the replacement the replacement of the video equipment and the remodeling of the council chambers scheduled for December, the cash balance is projected to be $30,000 on 12/31/19. 2020 Budget All Funds Total Governmental Funds 8,193,401 Dollar % 9,143,200 2018 2018 2019 2020 Increase Increase 691,611 Budget Actual Budget Recommended (Decrease) (Decrease) General Fund 8,193,401 8,023,605 8,577,280 9,143,200 565,920 6.60% Park Fund - 194,551 - - - 0.00% Drug/Felony Forfeitrure Fund - 4,006 - - - 0.00% Senior Housing TIF Fund - 1,557 - - - 0.00% 2004 Refunding Bond Fund - 3 - - - 0.00% 2005 HRA Public Project Bond Fund - 44,449 - - - 0.00% 2008 Improvement Bond Fund - 87,803 - - - 0.00% 2009 Imp Refunding Bond Fund - 2 - - - 0.00% 2010 Improvement Bond Fund - 266,919 - - - 0.00% 2010 Improvement Bond Fund - 421,150 - - - 0.00% MSA - 3,670,531 - - - 0.00% Improvement & Equip Outlay - 863,911 - - - 0.00% Permanent Improvement Ref (PIR) - 40,533 - - - 0.00% Community Investment Fund - 117,938 - - - 0.00% Pavement Mgmt Fund - 11338,734 - - - 0.00% Police Capital Projects - - - - - 0.00% Total Governmental Funds 8,193,401 15,075,690 8,577,280 9,143,200 565,920 6.60% Water Operating Fund 691,611 654,206 929,710 988,250 58,540 6.30% Sewer Operating Fund 1,520,240 1,110,919 1,734,175 1,906,200 172,025 9.92% Contracted Recycling Fund 130,150 127,256 134,530 216,700 82,170 61.08% Cable Televeision 50,545 47,473 67,030 71,200 4,170 6.22% Stormwater Operating Fund 161,132 123,546 356,810 373,000 16,190 4.54% Total Enterprise Funds 2,553,678 2,063,400 3,222,255 3,555,350 333,095 10.34% Fleet Fund - 111,206 133,250 153,800 20,550 15.42% Insurance Fund - 338,240 11,680 340,400 328,720 2814.38% IT Fund - - 73,650 214,300 140,650 190.97% Total Internal Services Funds - 449,447 218,580 708,500 489,920 224.14% Total Combined Funds 10,747,078 17,588,536 12,018,115 13,407,050 1,388,935 11.56% 2020 Water Fund Operating Budget Departmental Summary 49400 Total Water Operating Fund 664,630 899,586 929,710 524,684 988,250 PROGRAM DESCRIPTION & OBJECTIVES: The Water Operating Fund provides for the funding of the City's water distribution system. These funds are accounted for separately and are designed to be funded primarily through water rates. OPERATING COST ACTIVITIES: *Included in 'Personal Services' are the wages and employment taxes for the Water Department Staff. Staff includes: Director of Public Works (20%), Public Works Supervisors (25%), Maintenance Workers (25%) and a Seasonal Employee. *Supplies & Maintenance' includes the operating supplies and maintenance for the water distribution system. *Professional Services' includes a portion of the costs related to the City's annual financial audit, IT Services, and engineering consulting costs related to water projects. *Other Expenses' include power supply costs, purchased water from the City of Wayzata, and a depreciation charge on the fixed assests. Increase (Decrease) 3.14% -4.14% 45.78% 10.33% 8.54% 58,540 6.30% Dollar 2017 2018 2019 Y -T -D 2020 Increase Budget Actual Budget Sep 30, 2019 Recommended (Decrease) Personal Services 182,150 239,060 247,730 185,356 255,500 7,770 Supplies & Maintenance 139,700 209,490 130,810 99,810 125,400 (5,410) Professional Services 22,700 22,909 36,700 15,387 53,500 16,800 Insurances 10,280 10,280 7,070 5,303 7,800 730 Other Expenses 254,800 362,847 452,400 177,578 491,050 38,650 Operating Transfers 55,000 55,000 55,000 41,250 55,000 0 Total Water Operating Fund 664,630 899,586 929,710 524,684 988,250 PROGRAM DESCRIPTION & OBJECTIVES: The Water Operating Fund provides for the funding of the City's water distribution system. These funds are accounted for separately and are designed to be funded primarily through water rates. OPERATING COST ACTIVITIES: *Included in 'Personal Services' are the wages and employment taxes for the Water Department Staff. Staff includes: Director of Public Works (20%), Public Works Supervisors (25%), Maintenance Workers (25%) and a Seasonal Employee. *Supplies & Maintenance' includes the operating supplies and maintenance for the water distribution system. *Professional Services' includes a portion of the costs related to the City's annual financial audit, IT Services, and engineering consulting costs related to water projects. *Other Expenses' include power supply costs, purchased water from the City of Wayzata, and a depreciation charge on the fixed assests. Increase (Decrease) 3.14% -4.14% 45.78% 10.33% 8.54% 58,540 6.30% Personal Services Full -Time Employees Regular Full -Time Employees Overtime Part -Time Employees Temporary/Seasonal Employees PERA FICA City Benefit Contribution OPEB Expense Worker's Comp Insurance Prem City of Orono 2020 Line Item Budget Water 49400 2017 2018 2019 Actual Actual Budget Y -T -D 2020 Sep 30, 2019 Recommended Dollar Increase Decrease Increase Decrease 108,869 161,106 147,460 120,837 152,700 5,240 3.55% 14,185 5,531 10,000 6,379 10,000 0 0.00% 12,183 14,994 15,510 11,175 15,900 390 2.51% 0 0 7,500 0 5,200 (2,300) -30.67% 10,068 11,988 12,980 10,379 13,400 420 3.24% 10,213 12,280 13,810 10,588 14,100 290 2.10% 21,970 25,371 29,860 19,389 34,300 4,440 14.87% 0 3,284 1,800 0 1,800 0 0.00% 4,440 4,506 8,810 6,608 8,100 (710) -8.06% Total Personal Services 181,929 239,060 247,730 185,356 255,500 7,770 3.14% Supplies & Maintenance Office supplies Books & Periodicals Motor Fuels & Lubricants Chemicals and Chem Products Equipment Parts & Accessories Vehicle Equipment & Parts Bldg/Grounds Maint. Supplies Clothing & personal equipment Utility System Maint. Supplies Small Tools and Minor Equip Repairs/Maint-Office Equip Repairs/Maint-Auto Equip Repairs/Maint-Misc. Equip Repairs/Maint-Bldgs/Grounds Repairs/Maint-Watermains/plant Software Licensing 44 0 200 16 100 (100) -50.00% 0 0 0 0 0 0 N/A 0 4,500 4,680 3,510 0 (4,680) -100.00% 32,621 40,500 35,000 30,198 37,300 2,300 6.57% 272 0 0 169 0 0 N/A 23 1,007 1,150 863 0 (1,150) -100.00% 1,364 1,269 200 4,038 1,400 1,200 600.00% 461 141 1,000 73 1,000 0 0.00% 18,775 39,182 25,000 8,455 27,900 2,900 11.60% 808 2,500 2,500 225 2,500 0 0.00% 173 44 0 0 200 200 N/A 1,574 0 0 0 0 0 N/A 1,733 7,000 6,080 7,635 0 (6,080) -100.00% 2,442 3,008 4,000 769 4,000 0 0.00% 33,332 104,907 51,000 43,859 51,000 0 0.00% 4,272 5,432 0 0 0 0 N/A Total Supplies & Maintenance 97,893 209,490 130,810 99,810 125,400 (5,410) -4.14% City of Orono 2020 Line Item Budget Water cont. 49400 Dollar 2017 2018 2019 Y -T -D 2020 Increase Increase Actual Actual Budget Sep 30, 2019 Recommended Decrease Decrease Professional Services Auditing and Acct'g Services 4,500 5,000 5,000 5,000 5,000 0 0.00% Engineering -Consulting 12,444 8,333 15,000 1,090 10,600 (4,400) -29.33% GIS/Mapping 0 0 0 4,621 2,500 2,500 N/A Legal -Consulting 2,430 4,469 3,000 588 3,000 0 0.00% Bank Fees 2,114 5,108 2,400 4,088 3,700 1,300 54.17% IT Services 0 0 11,300 0 17,300 6,000 53.10% Fleet Services 0 0 0 0 11,400 11,400 N/A Professional Services 2,544 0 0 0 0 0 N/A Total Professional Services 24,032 22,909 36,700 15,387 53,500 16,800 45.78% Insurances General Liability Ins 4,000 4,000 3,000 2,250 3,600 600 20.00% Umbrella Liability Ins 1,800 1,800 0 0 0 0 N/A Property Insurance 3,800 3,800 3,440 2,580 3,500 60 1.74% Equipment Floaters Ins 380 380 330 248 400 70 21.21% Automotive Insurance 300 300 300 225 300 0 0.00% Total Insurances 10,280 10,280 7,070 5,303 7,800 730 10.33% Other Expenses Telephone Postage General Advertising Printing & Publishing Gas & Electric Water Utilities Intergovernmental Services Depreciation & Amortization Other Equipment Rentals Memberships Training & Development Administrative Charge Licenses & Taxes Fines & Penalties Other Miscellaneous Charges Total Other Expenses City of Orono 2020 Line Item Budget Water cont. 49400 326,478 341,367 430,360 155,547 468,950 38,590 8.97% Total Operating Expenses 640,611 823,105 852,670 461,403 911,150 58,480 6.86% Non -Operating Expenses Dollar 2017 2018 2019 Y -T -D 2020 Increase Increase Actual Actual Budget Sep 30, 2019 Recommended Decrease Decrease 2,398 4,173 2,500 3,502 3,400 900 36.00% 729 708 1,050 328 800 (250) -23.81% 0 0 0 0 0 0 N/A 143 468 1,000 465 400 (600) -60.00% 74,461 81,706 73,000 53,004 79,700 6,700 9.18% 880 933 1,100 639 1,000 (100) -9.09% 40,618 35,452 30,000 11,069 38,800 8,800 29.33% 178,222 186,568 207,400 0 225,800 18,400 8.87% 0 53 0 260 0 0 N/A 657 452 650 879 650 0 0.00% 3,442 3,701 3,500 4,218 3,500 0 0.00% 16,000 16,000 102,660 76,995 107,400 4,740 4.62% 2,644 882 3,500 544 3,500 0 0.00% 0 7,031 0 0 0 0 N/A 6,286 3,241 4,000 3,645 4,000 0 0.00% 326,478 341,367 430,360 155,547 468,950 38,590 8.97% Total Operating Expenses 640,611 823,105 852,670 461,403 911,150 58,480 6.86% Non -Operating Expenses Bond Interest 23,071 21,480 22,040 22,031 22,100 60 0.27% Other Long -Term Oblig Interest 0 0 0 0 0 0 N/A Other Interest Expense 0 0 0 0 0 0 N/A Operating Transfers 55,000 55,000 55,000 41,250 55,000 0 0.00% Total Non -Operating Expenses 78,071 76,480 77,040 63,281 77,100 0 0.00% Total Water Fund 718,682 899,586 929,710 524,684 988,250 58,480 6.29% 2020 Sewer Fund Operating Budget Departmental Summary 49450 PROGRAM DESCRIPTION & OBJECTIVES: The Sewer Operating Fund provides for the funding of the City's sewer collection system. The funds are accounted for separately and are designedto be funded primarily through sewer unit charges. OPERATING COST ACTIVITIES: *Included in 'Personal Services' are the wages and employment taxes for the Sewer Department Staff. Staff includes: Director of Public Works (30%), Public Works Supervisors (25%), Maintenance Workers (25%) *'Supplies & Maintenance' includes the operating supplies and maintenance for the sewer collection system. *'Professional Services' includes a portion of the costs related to the City's annual financial audit, IT Services, and engineering consulting costs related to sewer projects. *'Other Expenses' includes the City's disposal charges with the MCES, and a depreciation charge on fixed assets. Dollar % 2017 2018 2019 Y -T -D 2020 Increase Increase Budget Actual Budget Sep 30, 2019 Recommended (Decrease) (Decrease) Personal Services 309,360 275,168 276,750 202,298 281,500 4,750 1.72% Supplies & Maintenance 142,450 148,495 202,470 79,706 238,200 35,730 17.65% Professional Services Auditing and Acct'g Services 6,500 6,500 6,500 6,500 6,500 0 0.00% Engineering -Consulting 15,000 4,141 15,000 1,482 11,000 (4,000) -26.67% GIS/Mapping 0 0 0 6,202 4,000 4,000 N/A Legal -Consulting 1,000 222 1,000 186 1,000 0 0.00% Bank Fees 3,000 2,590 3,000 2,044 3,500 500 16.67% IT Services 0 0 17,250 0 17,300 50 0.29% Fleet Services 0 0 0 0 16,500 16,500 N/A Professional Services 0 0 0 0 0 0 N/A Professional Services 25,500 13,452 42,750 16,414 59,800 17,050 39.88% Insurances 18,930 18,930 12,730 9,548 14,000 1,270 9.98% Other Expenses 873,590 933,316 1,089,475 589,695 1,197,700 108,225 9.93% Operating Transfers 110,000 110,000 110,000 82,500 115,000 5,000 4.55% Total Sewer Operating Fund 1,479,830 1,499,362 1,734,175 9801161 1,906,200 172,025 9.92% PROGRAM DESCRIPTION & OBJECTIVES: The Sewer Operating Fund provides for the funding of the City's sewer collection system. The funds are accounted for separately and are designedto be funded primarily through sewer unit charges. OPERATING COST ACTIVITIES: *Included in 'Personal Services' are the wages and employment taxes for the Sewer Department Staff. Staff includes: Director of Public Works (30%), Public Works Supervisors (25%), Maintenance Workers (25%) *'Supplies & Maintenance' includes the operating supplies and maintenance for the sewer collection system. *'Professional Services' includes a portion of the costs related to the City's annual financial audit, IT Services, and engineering consulting costs related to sewer projects. *'Other Expenses' includes the City's disposal charges with the MCES, and a depreciation charge on fixed assets. Personal Services Full -Time Employees Regular Full -Time Employees Overtime Part -Time Employees Temporary/Seasonal Employees PERA FICA City Benefit Contribution OPEB Expense Worker's Comp Insurance Prem Total Personal Services Supplies & Maintenance Office supplies Motor Fuels & Lubricants Equipment Parts & Accessories Vehicle Equipment & Parts Bldg/Grounds Maint. Supplies Clothing & personal equipment Utility System Maint. Supplies Small Tools and Minor Equip Repairs/Maint-Office Equip Repairs/Maint-Auto Equip Repairs/Maint-Misc. Equip Repairs/Maint-Bldgs/Grounds Repairs/Maint-Swr lines/lifts Repairs/Maint-I&I Reduction City of Orono 2020 Line Item Budget Sewer 49450 2017 2018 2019 Y -T -D Actual Actual Budget Sep 30, 2019 2020 Do,__---,I_A Dollar Increase Decrease Increase Decrease 190,299 162,890 158,250 125,261 163,800 5,550 3.51% 19,618 4,346 12,000 3,644 12,000 0 0.00% 12,183 14,994 15,510 11,175 15,900 390 2.51% 0 10,764 15,730 9,126 10,400 (5,330) -33.88% 16,657 15,251 13,940 10,506 14,400 460 3.30% 16,661 15,308 15,420 10,503 15,500 80 0.52% 37,554 31,629 30,950 22,520 35,400 4,450 14.38% 0 3,489 2,200 0 2,200 0 0.00% 16,190 16,498 12,750 9,563 11,900 (850) -6.67% 309,163 275,168 276,750 202,298 281,500 4,750 1.72% 98 440 400 0 400 0 0.00% 0 9,000 8,840 6,849 0 (8,840) -100.00% 410 1,500 1,530 4,998 0 (1,530) -100.00% 0 5,162 2,300 2,439 0 (2,300) -100.00% 3,295 1,888 1,000 66 2,700 1,700 170.00% 2,596 163 1,000 124 1,500 500 50.00% 7,550 5,381 9,000 899 7,500 (1,500) -16.67% 1,194 2,505 2,500 829 2,500 0 0.00% 1,342 656 0 0 1,100 1,100 N/A 7,082 3,124 1,440 1,080 0 (1,440) -100.00% 2,028 5,000 960 4,683 0 (960) -100.00% 36 347 1,500 0 500 (1,000) -66.67% 117,867 108,735 147,000 57,738 147,000 0 0.00% 33,425 0 25,000 0 75,000 50,000 200.00% Total Supplies & Maintenance 176,923 143,901 202,470 79,706 238,200 35,730 17.65% 2017 Actual Professional Services City of Orono Auditing and Acct'g Services 6,500 Engineering -Consulting 11,237 GIS/Mapping 0 Legal -Consulting 0 Bank Fees 4,252 IT Services 0 Fleet Services 0 Professional Services 288 3,200 Total Professional Services 22,276 2,800 Insurances 9.80% General Liability Ins 8,000 Umbrella Liability Ins 3,600 Property Insurance 3,200 Equipment Floaters Ins 1,230 Automotive Insurance 2,900 Increase Total Insurances 18,930 13,452 City of Orono 16,414 59,800 17,050 39.88% 2020 Line Item Budget 6,750 9,900 900 10.00% 3,600 Sewer cont. 0 0 0 N/A 3,200 49450 1,913 2,800 250 9.80% 1,230 330 248 300 Dollar -9.09% 2018 2019 Y -T -D 2020 Increase Increase Actual Budget Sep 30, 2019 Recommended Decrease Decrease 6,500 6,500 6,500 6,500 0 0.00% 4,141 15,000 1,482 11,000 (4,000) -26.67% 0 0 6,202 4,000 4,000 N/A 222 1,000 186 1,000 0 0.00% 2,590 3,000 2,044 3,500 500 16.67% 0 17,250 0 17,300 50 0.29% 0 0 0 16,500 16,500 N/A 0 0 0 0 0 N/A 13,452 42,750 16,414 59,800 17,050 39.88% 8,000 9,000 6,750 9,900 900 10.00% 3,600 0 0 0 0 N/A 3,200 2,550 1,913 2,800 250 9.80% 1,230 330 248 300 (30) -9.09% 2,900 850 638 1,000 150 17.65% 18,930 12,730 9,548 14,000 1,270 9.98% Other Expenses Telephone Postage Travel Expenses General Advertising Printing & Publishing Gas & Electric Water Utilities MCES-Sewer Intergovernmental Services Depreciation & Amortization Other Equipment Rentals Software Licensing Memberships Training & Development Administrative Charge Meeting Expenses Special Equipment Replacement Licenses & Taxes Other Miscellaneous Charges Total Other Expenses Total Operating Expenses City of Orono 2020 Line Item Budget Sewer cont. 49450 Dollar 2017 2018 2019 Y -T -D 2020 Increase Increase Actual Actual Budget Sep 30, 2019 Recommended Decrease Decrease 4,110 3,548 5,000 2,307 4,000 (1,000) -20.00% 1,946 1,262 4,800 1,257 1,700 (3,100) -64.58% 0 0 100 0 100 0 0.00 0 0 0 0 0 0 N/A 885 42 300 0 300 0 0.00% 22,945 29,123 35,000 16,203 35,000 0 0.00% 0 1,066 0 0 0 0 N/A 431,942 473,217 555,365 462,804 619,400 64,035 11.53% 70,594 58,174 45,000 23,709 65,700 20,700 46.00% 308,847 315,278 330,000 0 353,600 23,600 7.15% 0 350 1,000 0 1,000 0 0.00% 4,757 4,594 0 0 0 0 N/A 63 309 1,250 253 1,200 (50) -4.00% 1,815 3,938 4,500 3,941 4,500 0 0.00% 32,000 32,000 102,660 76,995 107,400 4,740 4.62% 0 0 0 0 0 0 N/A 0 0 0 0 0 0 N/A 374 32 1,000 45 300 (700) -70.00% 8,710 14,976 3,500 2,183 3,500 0 0.00% 888,987 937,910 1,089,475 589,695 1,197,700 108,225 9.93% 1,416,279 1,389,362 1,624,175 897,661 1,791,200 167,025 10.28% City of Orono 2020 Line Item Budget Sewer cont. 49450 2017 2018 2019 Actual Actual Budget Y -T -D 2020 Sep 30, 2019 Recommended Dollar Increase Decrease Increase Decrease Non -Operating Expenses Other Interest Expense 0 0 0 0 0 0 N/A Operating Transfers 100,000 110,000 110,000 82,500 115,000 5,000 4.55% Total Non -Operating Expenses 100,000 110,000 110,000 82,500 115,000 5,000 4.55% Total Sewer Fund 1,516,279 1,499,362 1,734,175 980,161 1,906,200 172,025 9.92% 2020 Recycling Fund Operating Budget Departmental Summary 49500 Dollar 2020 Increase Increase Recommended (Decrease) (Decrease) 10,200 2,800 37.84% 0 0 N/A 193,500 75,620 64.15% 0 (500) (1) 13,000 4,250 48.57% Recycling Total 125,000 127,256 134,530 126,296 216,700 PROGRAM DESCRIPTION & OBJECTIVES: The city participates in a program to provide curbside recycling service. In addition, the city also provides a spring cleanup day for residents who have materials unsuitable for curbside recycling pickup. OPERATING COST ACTIVITIES: *Personal Services are a portion of the City Clerk's wages and the wages for City Staff whom participate in the spring cleanup. *Other Expenses includes disposal of items collected during the clean up day and materials related to organics recycling. *'Professional Services includes the costs associated with recycling collection. 82,170 61.08 2017 2018 2019 Y -T -D Budget Actual Budget Sep 30, 2019 Personal Services 6,830 6,980 7,400 10,066 Supplies & Maintenance 1,000 0 0 0 Professional Services 110,500 110,424 117,880 104,453 Insurances 500 0 500 0 Other Expenses 6,170 9,851 8,750 11,778 Dollar 2020 Increase Increase Recommended (Decrease) (Decrease) 10,200 2,800 37.84% 0 0 N/A 193,500 75,620 64.15% 0 (500) (1) 13,000 4,250 48.57% Recycling Total 125,000 127,256 134,530 126,296 216,700 PROGRAM DESCRIPTION & OBJECTIVES: The city participates in a program to provide curbside recycling service. In addition, the city also provides a spring cleanup day for residents who have materials unsuitable for curbside recycling pickup. OPERATING COST ACTIVITIES: *Personal Services are a portion of the City Clerk's wages and the wages for City Staff whom participate in the spring cleanup. *Other Expenses includes disposal of items collected during the clean up day and materials related to organics recycling. *'Professional Services includes the costs associated with recycling collection. 82,170 61.08 City of Orono 2020 Line Item Budget Recycling 49500 Dollar 2017 2018 2019 Y -T -D 2020 Increase Increase Actual Actual Budget Sep 30, 2019 Recommended Decrease Decrease Personal Services Full -Time Employees Regular 5,900 6,030 6,380 8,015 7,200 820 12.85% Full -Time Employees Overtime 0 0 0 0 0 0 N/A Part -Time Employees 0 0 0 0 0 0 N/A Temporary/Seasonal Employees 0 0 0 0 0 0 N/A PERA 442 450 480 602 500 20 4.17% FICA 366 460 490 603 600 110 22.45% City Benefit Contribution 0 0 0 808 1,800 1,800 N/A Worker's Comp Insurance Prem 40 40 50 38 100 50 100.00% Total Personal Services 6,748 6,980 7,400 10,066 10,200 2,800 37.84% Supplies & Maintenance Equipment Parts & Accessories 0 0 0 0 0 0 N/A Repairs/Maint-Office Equip 0 0 0 0 0 0 N/A Total Supplies & Maintenance 0 0 0 0 0 0 N/A Professional Services Legal -Consulting 0 0 0 465 0 0 N/A IT Services 0 0 0 0 2,500 2,500 N/A Contract Recycling Pickup 104,205 110,424 117,880 103,988 191,000 73,120 62.03% Professional Services 0 0 0 0 0 0 N/A Total Professional Services 104,205 110,424 117,880 104,453 193,500 75,620 64.15% City of Orono 2020 Line Item Budget Recycling cont. 49500 Dollar 2017 2018 2019 Y -T -D 2020 Increase Increase Actual Actual Budget Sep 30, 2019 Recommended Decrease Decrease Other Expenses Printing & Publishing 0 0 0 45 0 0 N/A General Liability Ins 500 0 500 0 0 (500) -100.00% Software Licensing 1,740 0 1,750 0 0 (1,750) -100.00% Administrative Charge 2,500 625 2,500 1,875 2,500 0 0.00% Spring,Fall,X-mas Cleanup 7,510 464 4,000 9,858 10,000 6,000 150.00% Organics Recycling 0 0 500 0 500 0 0.00% Total Other Expenses 12,250 1,089 9,250 11,778 13,000 3,750 40.54% Total Recycling Fund 123,203 118,494 134,530 126,296 216,700 82,170 61.08% 2020 Stormwater Fund Operating Budget Departmental Summary 49910 PROGRAM DESCRIPTION & OBJECTIVES: The Stormwater Operating Fund provide sfunding to for the City's Stormwater responsibilities. The funds are accounted for separately and are designedto be funded primarily through stormwater service and trunk fees. OPERATING COST ACTIVITIES: *Included in 'Personal Services' are the wages and employment taxes for the Public Works Department Staff. Staff includes: Director of Public Works (10%), Public Works Supervisors (25%), Maintenance Workers (5%) * Supplies & Maintenance includes material associated with culvert maintenance. *Other Expenses includes depreciation and an administrative charge and the annual LMCD Levy. *'Professional Services includes engineering and annual audit charges. Dollar 2017 2018 2019 Y -T -D 2020 Increase Increase Budget Actual Budget Sep 30, 2019 Recommended (Decrease) (Decrease) Personal Services 47,380 47,545 128,190 105,622 132,500 4,310 3.36% Supplies & Maintenance 30,000 11,261 31,530 14,131 21,500 (10,030) -31.81% Professional Services 19,500 15,663 21,500 17,395 37,200 15,700 73.02% Insurances 1,970 1,970 3,380 2,423 3,900 520 15.38 Other Expenses 52,700 67,926 172,210 84,123 177,900 5,690 3.30% Total Stormwater Operating Fund 151,550 144,365 356,810 223,694 373,000 16,190 4.54% PROGRAM DESCRIPTION & OBJECTIVES: The Stormwater Operating Fund provide sfunding to for the City's Stormwater responsibilities. The funds are accounted for separately and are designedto be funded primarily through stormwater service and trunk fees. OPERATING COST ACTIVITIES: *Included in 'Personal Services' are the wages and employment taxes for the Public Works Department Staff. Staff includes: Director of Public Works (10%), Public Works Supervisors (25%), Maintenance Workers (5%) * Supplies & Maintenance includes material associated with culvert maintenance. *Other Expenses includes depreciation and an administrative charge and the annual LMCD Levy. *'Professional Services includes engineering and annual audit charges. City of Orono 2020 Line Item Budget Storm Water 49910 Total Personal Services 42,134 47,545 128,190 105,622 132,500 4,310 3.36% Supplies & Maintenance Dollar Office supplies 2017 2018 2019 Y -T -D 2020 Increase Increase Equipment Parts & Accessories Actual Actual Budget Sep 30, 2019 Recommended Decrease Decrease Personal Services 0 826 0 0 0 0 N/A Full -Time Employees Regular 32,836 36,677 78,640 72,703 81,100 2,460 3.13% Full -Time Employees Overtime 96 377 0 5,600 0 0 N/A Temporary/Seasonal Employees 0 0 15,000 0 15,600 600 4.00% PERA 2,470 2,779 5,900 5,469 6,100 200 3.39% FICA 2,581 2,881 7,170 5,646 7,400 230 3.21% City Benefit Contribution 3,101 3,104 14,350 11,253 15,300 950 6.62% OPEB Expense 0 670 530 0 500 (30) -5.66% Worker's Comp Insurance Prem 1,050 1,057 6,600 4,950 6,500 (100) -1.52% Total Personal Services 42,134 47,545 128,190 105,622 132,500 4,310 3.36% Supplies & Maintenance Office supplies 0 0 0 0 0 0 N/A Equipment Parts & Accessories 0 1,300 1,530 1,148 0 (1,530) -100.00% Bldg/Grounds Maint. Supplies 0 826 0 0 0 0 N/A Utility System Maint. Supplies 1,249 3,894 9,500 5,179 5,000 (4,500) -47.37% Small Tools and Minor Equip 695 1,000 1,000 805 1,000 0 0.00% Repairs/Maint-Office Equip 0 0 1,500 0 1,500 0 0.00% Repairs/Maint-Auto Equip 4,033 4,000 4,000 3,000 0 (4,000) -100.00% Repairs/Maint-Bldgs/Grounds (129) 242 0 0 0 0 N/A Repairs/Maint-Swr lines/lifts (1,371) 0 14,000 4,000 14,000 0 0.00% Total Supplies & Maintenance 4,477 11,261 31,530 14,131 21,500 (10,030) -31.81% Professional Services Auditing and Acct'g Services Engineering -Consulting GIS/Mapping Legal -Consulting IT Services Fleet Services Professional Services Total Professional Services Insurances General Liability Ins Umbrella Liability Ins Equipment Floaters Ins Automotive Insurance Insurance Agent of Record Insurance Deductibles 500 500 City of Orono 2,213 3,500 550 18.64% 220 2020 Line Item Budget 0 0 0 N/A 1,250 1,250 Storm Water cont. 210 300 20 7.14% 0 0 49910 0 100 (50) -33.33% 0 0 0 0 0 Dollar N/A 2017 2018 2019 Y -T -D 2020 Increase Increase Actual Actual Budget Sep 30, 2019 Recommended Decrease Decrease 3,500 3,500 3,500 3,500 3,500 0 0.00% 31,990 11,942 15,000 7,414 8,000 (7,000) -46.67% 0 0 0 5,395 6,000 6,000 N/A 0 222 1,000 1,086 1,000 0 0.00% 0 0 2,000 0 5,000 3,000 150.00% 0 0 0 0 13,700 13,700 N/A 0 0 0 0 0 0 N/A 35,490 15,663 21,500 17,395 37,200 15,700 73.02% 500 500 2,950 2,213 3,500 550 18.64% 220 220 0 0 0 0 N/A 1,250 1,250 280 210 300 20 7.14% 0 0 150 0 100 (50) -33.33% 0 0 0 0 0 0 N/A 0 0 0 0 0 0 N/A Total Insurances 1,970 1,970 3,380 2,423 3,900 520 15.38% City of Orono 2020 Line Item Budget Storm Water cont. 49910 Dollar 2017 2018 2019 Y -T -D 2020 Increase Increase Actual Actual Budget Sep 30, 2019 Recommended Decrease Decrease Other Expenses Postage 1,946 1,262 5,100 1,257 1,700 (3,400) -66.67% Travel Expenses 0 0 0 0 0 0 N/A Printing & Publishing 0 24 0 24 0 0 N/A Depreciation & Amortization 41,685 46,257 53,500 0 62,000 8,500 15.89% Other Equipment Rentals 0 0 0 0 0 0 N/A Software Licensing 3,352 3,208 2,000 0 0 (2,000) -100.00% Memberships 0 1,020 58,780 44,345 59,000 220 0.37% Training & Development 321 155 500 0 500 0 0.00% Administrative Charge 16,000 16,000 51,330 38,498 53,700 2,370 4.62% Licenses & Taxes 0 0 0 0 0 0 N/A Other Miscellaneous Charges 46,819 0 1,000 0 1,000 0 0.00% Total Other Expenses 110,123 67,926 172,210 84,123 177,900 5,690 3.30% Total Operating Expenses 194,193 144,365 356,810 223,694 373,000 16,190 4.54% Non -Operating Expenses Easements & Rights of Way 272 0 0 0 0 0 N/A Storm Sewer Utility Const 0 0 0 0 0 0 N/A Total Non -Operating Expenses 272 0 0 0 0 0 N/A Total Stormwater Fund 194,465 144,365 356,810 223,694 373,000 16,190 4.54% 2020 Cable TV Operating Budget Departmental Summary 49840 Total Sewer Operating Fund 40,760 52,363 67,030 58,711 71,200 4,170 6.22% PROGRAM DESCRIPTION & OBJECTIVES: The Cable TV Fund was created to account for the Franchise fees that are collectected as part of the City's Franchise agreement with Mediacom. Expenditures include costs associated with recording and streaming meetings. OPERATING COST ACTIVITIES: *Included in 'Personal Services' are 10% of the wages for the IT Tech *'Professional Services includes IT Services and audit charges. * Other Expenses include webcasting/online content and an administrative charge to the General Fund Dollar % 2017 2018 2019 Y -T -D 2020 Increase Increase Budget Actual Budget Sep 30, 2019 Recommended (Decrease) (Decrease) Personal Services 13,660 14,445 18,430 21,294 20,600 2,170 11.77% Supplies & Maintenance 500 330 2,000 0 0 (2,000) -100.00% Professional Services 4,500 5,335 9,500 3,840 16,000 6,500 68.42% Other Expenses 22,100 32,253 37,100 33,577 34,600 (2,500) -6.74% Total Sewer Operating Fund 40,760 52,363 67,030 58,711 71,200 4,170 6.22% PROGRAM DESCRIPTION & OBJECTIVES: The Cable TV Fund was created to account for the Franchise fees that are collectected as part of the City's Franchise agreement with Mediacom. Expenditures include costs associated with recording and streaming meetings. OPERATING COST ACTIVITIES: *Included in 'Personal Services' are 10% of the wages for the IT Tech *'Professional Services includes IT Services and audit charges. * Other Expenses include webcasting/online content and an administrative charge to the General Fund Personal Services Full -Time Employees Regular Full -Time Employees Overtime PERA FICA City Benefit Contribution Worker's Comp Insurance Prem Total Personal Services Professional Services Auditing and Acct'g Services Legal -Consulting IT Services Professional Services Total Professional Services Other Expenses Internet/Other Communications Repairs/Maint-Office Equip Depreciation & Amortization Administrative Charge City of Orono 2020 Line Item Budget Cable Franchise 49840 2017 2018 2019 Actual Actual Budget Y -T -D 2020 Sep 30, 2019 Recommended Dollar Increase Decrease Increase Decrease 10,267 12,470 13,990 17,462 14,800 810 5.79% 0 0 0 0 0 0 N/A 880 935 1,050 1,310 1,100 50 4.76% 730 954 1,080 1,341 1,100 20 1.85% 0 0 2,200 1,098 3,500 1,300 59.09% 80 86 110 83 100 (10) -9.09% 11,957 14,445 18,430 21,294 20,600 2,170 11.77% 2,000 2,000 2,000 2,000 2,000 0 0.00% 0 0 0 0 0 0 N/A 0 0 7,500 0 10,000 2,500 33.33% 4,335 3,335 0 1,840 4,000 4,000 N/A 6,335 5,335 9,500 3,840 16,000 6,500 68.42% 13,175 24,863 30,000 31,702 30,000 0 0.00% 985 330 2,000 0 0 (2,000) -100.00% 4,312 4,890 4,600 0 4,600 0 0.00% 2,500 2,500 2,500 1,875 0 (2,500) -100.00% Total Other Expenses 20,972 32,583 39,100 33,577 34,600 (4,500) -11.51% Total Operating Expenses 39,264 52,363 67,030 58,711 71,200 4,170 6.22% Total Cable TV Fund 39,264 52,363 67,030 58,711 71,200 4,170 6.22% Capital Improvement Plan, City of Orono Summary of Costs 2020 5 -Year CIP Planning Period CIP 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Parks (A-1) $488,885 $30,000 $225,042 $380,000 $10,000 $234,946 $180,000 $235,890 $214,700 $567,000 Equipment (A -2a) $313,600 $306,000 $285,300 $168,000 $151,500 $450,000 $185,800 $124,500 $90,461 $60,000 Building (A -2b) $275,000 $57,000 $820,320 $75,000 $320,000 $209,000 $160,000 $160,000 $160,000 $160,000 IT (A -2c) $0 $15,000 $115,000 $0 $0 $12,000 $22,000 $43,000 $15,000 $0 Long Lake Fire (A-3) $9,350 $110,500 $46,750 $0 $0 $114,750 $0 $51,000 $488,750 $76,500 Community Investment (A-4) $0 $0 $568,970 $0 $0 $0 $0 $0 $0 $0 Public Works - Streets - PMF & MSA (A-5) $935,567 $1,301,067 $850,167 $1,541,700 $838,400 $1,550,000 $1,581,000 $1,612,620 $1,644,872 $1,677,770 Public Works - Water (A-6) $335,855 $354,760 $379,131 $420,094 $375,308 $422,833 $488,528 $484,544 $348,973 $306,742 Public Works - Sanitary Sewer (A-7) $784,750 $744,000 $633,250 $520,550 $424,480 $1,061,000 $631,700 $638,534 $645,505 $652,615 Public Works - Storm Sewer (A-8) $580,425 $418,120 $456,160 $372,610 $479,605 $440,000 $442,800 $503,641 $448,569 $451,541 Police (A-9) $170,391 $171,883 $202,389 $207,911 $182,448 $198,002 $187,572 $190,159 $163,264 $248,386 Totals $3,893,823 $3,508,330 $4,582,479 $3,685,865 $2,781,741 $4,692,530 $3,879,400 $4,043,887 $4,220,093 $4,200,554 Debt Service Levy Debt Issue 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2010 Street Reconstruction Bonds $134,825 $131,520 $133,325 $134,530 $130,000 $130,725 $0 $0 $0 $0 2014 Garage, Water, Refunding Bonds $162,900 $166,700 $161,000 $282,000 $277,000 $277,000 $278,857 $278,000 $278,000 $278,000 2016 GO Refunding $413,275 $412,780 $416,675 $0 $0 $0 $0 $0 $0 $0 Current Debt Levy $711,000 $711,000 $711,000 $416,530 $407,000 $407,725 $278,857 $278,000 $278,000 $278,000 Capital Improvement Plan, City of Orono Parks CIP Table A-1 5 -Year CIP Planning Period Project 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Trail Construction along CSAH 19 (Livingston to Dakota) $115,000 East Long Lake Road to Trail $120,000 Summit Beach Improvements (paved parking and playground) $140,000 Big Island ADA Trails, amenities, restroom $80,000 Picnic Table and shade Sail at Community Garden $7,000 Lurton gravel trails $20,000 Basket Ball Court Surfacing - Crystal Bay $10,000 CSAH 112 PH 3 Trail (School to CSAH 6) $188,640 CR 6 Trail (OCB - Willow) Improvement $36,402 Trail construction along North Arm drive to Lakeview Legacy Park $80,000 Hackberry Improvements $300,000 Dock Replacement (15 year life) $10,000 $10,000 Trail Construction along CCB and North Shore (Luce Line to Dakota) $567,000 Trail Construction along Hunter or Ferndale Roads connection lace line to northern boundary $133,890 Park Equipment (Navarre, Hackberry, Bederwood, Crystal Bay, Fagerness) $64,946 Trail Access to Lowry Woods $100,000 GC Fire Pit $26,885 GC Wetland and Fairway #4 Improvements $160,000 GC Lawn Bowling $80,000 GC Tow Rope $102,000 GC Perimeter Trail $214,700 Totals $488,885 $30,000 $225,042 $380,000 $10,000 $234,946 $180,000 1 $235,890 $214,700 $567,000 Capital Improvement Plan, City of Orono Equipment CIP Table A -2a Equipment Description Purchase Year Expected Life (yrs) 2020 2021 5 Year CIP 2022 2023 2024 2025 2026 Planning Period 2027 2028 2029 Truck, 1 Ton Dump Truck w/Plow and Sander (new Engine) 2008 15 $15,000 Anti Icing Tank and Pump $27,600 Televising equipment $100,000 Tractor (ROW Mower) 2005 15 $53,000 Flail Mower 2013 5 1 $35,000 Aerator 1988 25 $24,000 Generator, 30KW w/ light tower 1984 30 $20,000 brine tank/distributer $20,000 Broom 2013 5 $12,000 Mower (Parks) $7,000 Jet Rodder 1976 40 $300,000 Utility Service Truck with hoist 2012 10 $63,000 Fertilizer Spreader 20 $6,000 Hot Patch Truck 1999 20 $188,000 Sprayer 2002 20 $34,300 Skid loader $2,003 20 $53,500 Truck, 3/4 Ton Pickup w/Plow 2008 15 $50,000 Tee Mower 2004 20 $38,000 Top Dresser 30 $16,800 Greens Mower 2004 20 $9,700 Chipper 2004 20 $40,500 Chevy 3/4 Ton Pickup w/Plow 2012 10 $37,000 Trailer 2012 15 $9,000 Crack Sealing Equipment $65,000 Vactor Truck 2000 25 $450,000 Rough Mower 20 $65,500 Mower (Big island) 2018 10 $8,961 Greens / Turf Roller 30 $13,000 Building Inspection Vehicle 2011 15 $40,300 Tractor Loader Backhoe 2006 20 $145,500 Ford 3/4 Ton Pickup 2013 15 $37,000 Skid loader 2013 20 $70,000 Trailer 2012 1 15 $9,000 Truck, 3/4 Ton Pickup w/Plow (Sign Truck) 2019 15 $60,000 Snow blower 2013 15 $11,500 Totals $ 313,600 $ 306,000 $ 285,300 $ 168,000 $ 151,500 $ 450,000 $ 185,800 $ 124,500 $ 90,461 $ 60,000 Capital Improvement Plan, City of Orono Building CIP Table A -2b 5 -Year CIP Planning Period Project 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Council Chambers Remodel $70,000 Park and Ride (striping) $12,000 Park and Ride Overlay $25,000 PW Cold Storage $30,000 City Hall Carpet $20,000 Public Works Parking Lot Repave $119,560 Emergency Generator $175,000 City Hall Parking Lot chip Seal (7years) $35,000 Public Works Roof Replacement $665,760 PW Air Handling System Refurbish $75,000 City Hall Roof Replacement $320,000 Police Department Roof Replacement 1 1 $209,000 Future Facilities Improvements 1 1 $160,000 $160,000 $160,000 1 $160,000 Totals 1 $275,000 $57,000 $820,320 $75,000 1 $320,000 1 $209,000 $160,000 $160,000 $160,000 1 $160,000 Capital Improvement Plan, City of Orono IT CIP Table A -2c 5 -Year CIP Planning Period Project 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Wireless Access Points - City Hall & PW $15,000 $18,000 File Servers X 2 (5 Years) $12,000 Switch (Every 6 Years - 6 Switches) $15,000 $22,000 $15,000 Phone Replacement (10 Years) $100,000 Web Site Upgrade $25,000 Totals $0 $15,000 $115,000 $0 $0 $12,000 $22,000 $43,000 $15,000 $0 Capital Improvement Plan, City of Orono Long Lake Fire CIP Table A-3 Purchase Year Expected Life (yrs) 5 -Year CIP Planning Period Project 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Upgrade LDH Discharges 10 $11,000 Replace U11 with New Utility Vehicle 1999 10 $130,000 Replace CMD2 with New CMD1 2011 10 $55,000 Replace U11 with New Utility Truck 2000 20 $135,000 Replace CMD2 with New CMD1 2013 15 $60,000 Replace 1311 and Trailer 1 15 1 1 $90,000 Replace E21 with New Rescue Pumper 2003 15 $575,000 Totals: $11,000 $130,000 $55,000 $0 $0 $135,000 $0 $60,000 $575,000 $90,000 City of Orono's Portion (85%) $9,350 1 $110,500 $46,750 $0 $0 1 $114,750 $0 $51,000 1 $488,750 1 $76,500 Totals $9,350 $110,500 $46,750 $0 $0 $114,750 $0 $51,000 $488,750 $76,500 Capital Improvement Plan, City of Orono Community Investment CIP Table A-4 5 -Year CIP Planning Period Project 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 County Road 112 Turn Back (Lighting/Sidewalks) * $568,970 Totals $0 $0 $568,970 $0 $0 $0 $0 $0 $0 $0 * The scope of the County Road 112 Turn Back Project is yet to be determined. Therefore, the cost estimate for the project is subject to change and refinement as the project development process proceeds. The City's final share of the project will be established by the County's cost sharing policy and the final scope of the project as developed by the City of Orono and Hennepin County. Capital Improvement Plan, City of Orono Public Works - Streets CIP Table A-5 5 -Year CIP Planning Period Project Type 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Smith and Lyman Avenues Reclaim $170,500 Livingston & Navarre Aves Reclaim $234,700 Windjammer (North Arm to End) Reclaim $70,400 Casco Circle Mill and Overlay $156,300 Rest Point Lane Mill and Overlay $37,100 Dickenson& Russel Street Mill and Overlay $99,800 Togo Road Mill & Overlay $94,900 Park Lane & Elm Street Mill and Overlay $111,200 Fox Street - Orono Orchard to East End Pave $77,800 Fox Street- Brown -Orono Orchard Reconstruct $1,040,200 Orchard Park Road Mill & Overlay $184,400 Ferndale Road West Mill & Overlay $168,300 Glendale Drive Mill & Overlay $43,700 Kelley Parkway - OCB Rd to Stone Bay Mill & Overlay $88,600 Willow Drive - Fox St- Brown Road Mill & Overlay $293,300 Townline Road Reconstruct $365,600 Navarre East Roads (Kenwood Way, Navarre Lane, Olive Avenue, Bayview place, Lafayette Ridge Ct) Mill & Overlay $314,100 North Arm Drive Mill & Overlay $365,300 Forest Lake Drive Mill & Overlay $75,900 Eileen Street Mill & Overlay $26,600 Crestview Avenue Mill & Overlay $59,200 Livingston Avenue - CR15 to Blaine Mill & Overlay $150,600 Old Long Lake Road Mill & Overlay $385,200 Orono Lane Mill & Overlay $48,100 Crystal Bay Roads (Briar*, Arbor, Prospect, Crystal, Spates) Mill & Overlay $254,500 Future road reconstructions/ M&O and Reclaims (per Year) $1,150,000 $1,173,000 $1,196,460 $1,220,389 $1,244,797 Total - Pavement Management Fund 1 $863,700 $1,229,200 $778,300 $1,206,700 $838,400 $1,150,000 $1,173,000 $1,196,460 $1,220,389 $1,244,797 Capital Improvement Plan, City of Orono Public Works - Streets CIP Table A-5 5 -Year CIP Planning Period Project Type 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 MSA Streets: Ferndale Road North (Shared with Plymouth) Mill & Overlay $71,867 $71,867 $71,867 Brown Road North Mill and Overlay $335,000 Future MSA road projects (per year) Mill and Overlay $400,000 $408,000 $408,000 $416,160 $416,160 $424,483 $424,483 $432,973 $432,973 Total MSA Streets: $71,867 $71,867 $71,867 $335,000 $0 $400,000 MSA Debt Service $143,111 $139,661 $141,061 $141,945 $137,468 $137,687 $142,625 TotalsStreets $935,567 $1,301,067 $850,167 1 $1,541,700 1 $838,400 1 $1,550,000 1 $1,581,000 1 $1,612,620 1 $1,644,872 1 $1,677,770 Capital Improvement Plan, Citv of Orono Public Works - Water CIP Table A-6 5 -Year CIP Planning Period Project 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Water Valve replacement Togo Road $36,000 Water Valve replacement Livingston Road $42,000 Water Valve replacement Casco Circle $60,000 Water Main Replacement (CSAH15/19) W/Road $169,855 South Tower Repaint and Rehabilitation $350,000 Water Main replacement CSAH 19 South of CSAH 15 $181,000 North Distribution Extension (West of OCB) $120,000 Navarre Plant Control Upgrade $55,200 Water Main Loop Concordia $230,000 Water Main replacement E. Navarre Streets W/Road $327,880 North Water Tower Maintenance $62,500 $69,000 Well #4 Inspection & Maintenance (every 10 yrs) $20,000 North Well house Upgrade (sewer) North Water Plant Painting $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 Well #3 Inspection & Maintenance (every 10 yrs) $20,000 Water Valve Replacements (4 /Year) $28,000 $28,560 $29,131 $29,714 $30,308 $27,833 $28,528 $29,242 $29,973 $30,722 Water Meter Replacement $90,000 $95,000 $170,000 Water Main Replacement/Rehab (per Year) $250,000 $255,000 $265,302 $276,020 Totals $335,855 $354,760 $379,131 $420,094 $375,308 $422,833 $488,528 $484,544 $348,973 $306,742 Capital Improvement Plan, City of Orono Public Works - Sanitary Sewer CIP Table A-7 5 -Year CIP Planning Period Project 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Sewer Rehabilitation $290,000 $290,000 $290,000 $290,000 $290,000 $290,000 $290,000 $290,000 $290,000 $290,000 Lift Station #3 Generator $75,000 Lift Station #13 Generator $75,000 Lift Station #15 Generator $75,000 Grinder Station #10 $20,000 Lift Station #19 Rehab $60,000 Lift Station #30 Rehab $60,000 Lift Station #11 Rehab $62,000 Lift Station #3 Rehab $62,000 Lift Station #5 Rehab $64,000 Lift Station #4 Rehab $64,000 Lift Station #16 Rehab $25,000 Lift Station #28 Rehab $65,600 Grinder Station #8 Rehab $67,240 Lift Station #10 Rehab $67,240 Lift Station Rehab (2 per year) $135,000 $137,700 $140,454 $143,263 $146,128 Windjammer Main Rehab with road $24,750 Force Main replacement with CSAH 19/15 Project $180,000 Force main Replacement Tonkawa PH2 $225,000 Sewer Meter installation (into Long Lake) $30,000 Northern Utilities Expansion $436,000 Capital Improvement Plan, City of Orono Public Works - Sanitary Sewer CIP Table A-7 5 -Year CIP Planning Period Project 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Force Main Replacement Tonkawa PH3 $215,250 Force Main Replacement Tonkawa PH4 $139,950 Sewer Main Replacements 1 $200,000 $204,000 $208,080 1 $212,242 $216,486 Totals $784,750 1 $744,000 1 $633,250 1 $520,550 1 $424,480 1 $1,061,000 1 $631,700 $638,534 1 $645,505 $652,615 Capital Improvement Plan, City of Orono Public Works - Storm Sewer CIP Table A-8 5 -Year CIP Planning Period Project 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Smith and Lyman Avenues $25,575 Livingston & Navarre Aves $35,205 Windjammer (North Arm to End) $9,930 Casco Circle $23,445 Rest Point Lane $5,565 Dickenson& Russel Street $14,970 Togo Road $14,235 Park Lane & Elm Street $11,355 Fox Street - Orono Orchard to East End $6,195 Fox Street- Brown -Orono Orchard $150,570 Orchard Park Road $27,660 Ferndale Road West $25,245 Glendale Drive $6,555 Kelley Parkway - OCB Rd to StoneBay $13,290 Willow Drive - Fox St- Brown Road $46,410 Navarre East Roads (Kenwood Way, Navare Lane, Olive Avenue, Bayview place, Lafayette Ridge Ct) $47,115 North Arm Drive $54,795 Forest Lake Drive $11,385 Eileen Street $3,990 Crestview Avenue $8,880 Townline Road $23,445 Capital Improvement Plan, City of Orono Public Works - Storm Sewer CIP Table A-8 5 -Year CIP Planning Period Project 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Livingston Avenue - CR15 to Blaine $22,590 Old Long Lake Road $57,780 Orono Lane $7,215 Crystal Bay Roads (Briar*, Arbor, Prospect, Crystal,Spates) $38,175 Street Stormwater Improvements (per year) $140,000 $142,800 $145,656 $148,569 $151,541 Casco Point Park Outlet (SWMP 0-1) $58,000 Casco Cove Outlet (SWMP 0-2) $80,000 Casco Point Park Bioretention Basin (SWMP CB -1) $55,000 South Casco Point Road Sump (SWMP CB -2) $36,000 Casco Cove Bioretention Basin (CB -3) $57,000 East Long Lake Road N Improvements (SWMP LL -1) $102,500 Cherry Place Ravine Improvement (SWMP NA -1) $23,000 Surface Water Management Projects, Unnamed (Per Year) $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 Pond Cleaning/Maintenance (1/year) $50,000 $53,845 $57,985 Storm Sewer Improvements/Replacements (Per Year) $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 Totals $580,425 1 $418,120 1 $456,160 1 $372,610 1 $479,605 1 $440,000 1 $442,800 1 $503,641 $448,569 $451,541 Capital Improvement Plan, City of Orono Police CIP Table A-9 Project Purchase Year Expected 5 -Year CIP Planning Period Life (yrs) 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Squad 242 (Ford SUV) CSO 2015 4 $38,500 $41,000 $42,500 Squad 244 (AWD Charger) 2016 4 $38,500 $41,000 $42,500 Squad 246 (AWC Charger) 2017 4 $38,500 $41,000 $42,500 Squad 248 (Ford SUV) 2017 4 $38,500 $41,000 $43,000 Squad 249 (Ford SUV) 2017 4 $40,000 $41,000 $43,000 Squad 250 (Ford SUV) 2017 4 $40,000 $41,000 $43,000 Squad 251 (Ford SUV) 2017 4 $40,000 $42,000 Squad 253 (AWD Charger) 2018 4 $40,000 $42,000 Squad 254 (Ford SUV) 2018 4 $40,000 $42,000 Squad 258 (Dodge Durango) 2019 4 $40,000 $42,500 Squad 259 (Dodge Durango) 2019 4 $40,000 $42,500 Squad 260 (Dodge Durango) 2019 4 $40,000 $42,500 Squad 261 (Dodge Durango) Chief 2019 6 $42,000 Squad 843 (Tahoe -Mound) SRO 2010 12 $40,000 Squad 255 (Dodge Durango) SRO 2018 6 $42,500 Squad 247 (Dodge Ram) Investigations 2016 6 $40,000 $43,000 Squad 257 (Dodge Jouney) Deputy Chief 2018 6 $41,000 Squad 256 (Dodge Journey) Investigations 2018 6 $41,000 Technology Replacement $10,927 $11,255 $11,593 $11,941 $12,299 $12,668 $13,048 $13,439 $13,842 $14,258 Weapons - Rifles $10,000 $5,000 Weapons - Handguns $20,000 Supported or Partially Funded through Police Account in the PIR Fund Mobile Radios $50,000 $50,000 Squad/Body Video Cameras $35,000 $15,000 $15,000 $15,000 Mobile Data Computer $5,464 $5,628 $5,796 $5,970 $6,149 $6,334 $6,524 $6,720 $6,921 $7,129 Totals $170,391 $171,883 $202,389 $207,911 $182,448 $198,002 $187,572 $190,159 $163,264 $248,386 NOTES: *Funding for the Police CIP is accounted for in the General Fund to accurately charge our contract cities for the cost of policing. Capital Improvement Plan, City of Orono Park Fund Current Balance: Current Balance: $695,544 Current Balance: $356,309 Table B-2 Table B-1 Project 2020 2021 2022 2023 2024 1 2025 2026 2027 2028 Project 2020 2021 Project 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Operation and Maintenance (1) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 CIP Expenditures $462,000 $30,000 $225,042 $380,000 $10,000 $74,946 $0 $133,890 $0 $567,000 Total Expenses $462,000 $30,000 $225,042 $380,000 $10,000 $74,946 $0 $133,890 $0 $567,000 $180,000 $102,000 $214,700 $0 Total Expenses $615,485 $378,000 $1,220,620 $243,000 $471,500 $831,000 $547,800 Revenues(2) $4,681 $2,382 $2,106 ($123) $0 $0 $0 $0 $0 $0 Annual Balance ($457,319) ($27,618) ($222,936) ($380,123) ($10,000) ($74,946) $0 ($133,890) $0 ($567,000) Year End Cash Balance $238,225 $210,608 ($12,328) ($392,452) ($402,452) ($477,398) ($477,398) ($611,288) ($611,288) 1 ($1,178,288) Improvement/Equipment Outlay Fund Current Balance: Current Balance: $316,138 Current Balance: $356,309 Table B-2 Project 2020 2021 2022 2023 2024 1 2025 2026 2027 2028 Project 2020 2021 2022 2023 2024 2025 1 2026 1 2027 1 2028 1 2029 Equipment, CIP $313,600 $306,000 $285,300 $168,000 $151,500 $450,000 $185,800 $124,500 $90,461 $60,000 Building CIP $275,000 $57,000 $820,320 $75,000 $320,000 $209,000 $160,000 $160,000 $160,000 $160,000 IT, CIP $0 $15,000 $115,000 $0 $0 $12,000 $22,000 $43,000 $15,000 $0 Golf, CIP $26,885 $0 $0 $0 $0 $160,000 $180,000 $102,000 $214,700 $0 Total Expenses $615,485 $378,000 $1,220,620 $243,000 $471,500 $831,000 $547,800 $429,500 $480,161 $220,000 Revenues (interest) $5,449 $5,503 $5,558 $0 $0 $0 $0 $0 $0 $0 Revenues (Transfer) $215,000 $255,000 $315,000 $315,000 $315,000 $315,000 $315,000 $315,000 $315,000 $315,000 Transfer from Enterprise Funds $120,000 $300,000 $63,000 $0 $37,000 $450,000 $145,500 $0 $0 $0 Annual Balance ($280,485) $177,000 ($842,620) $72,000 ($119,500) ($66,000) ($87,300) ($114,500) ($165,161) $95,000 Year End Cash Balance $75,824 $252,824 ($589,796) ($517,796) ($637,296) ($703,296) ($790,596) ($905,096) ($1,070,256) ($975,256) Improvement/Equipment Outlay Fund - Long Lake Fire Account Current Balance: Current Balance: $316,138 Table B-3 Table B-4 Project 2020 2021 2022 2023 2024 1 2025 2026 2027 2028 2029 Long Lake Fire CIP $9,350 $110,500 $46,750 $0 $0 1 $114,750 $0 $51,000 $488,750 $76,500 Total Expenses $9,350 $110,500 $46,750 $0 $0 $114,750 $0 $51,000 $488,750 $76,500 $0 $0 $0 $0 $0 Community Improvement CIP $0 $0 Revenue - General Fund Transfer (2) $85,000 $85,000 $85,000 $85,000 $85,000 $85,000 $85,000 $85,000 $85,000 $85,000 Revenues-Interest(2) $1,506 $3,933 $3,717 $4,137 $5,028 $5,929 $5,690 $6,597 $7,003 $3,036 Annual Balance $77,156 ($21,567) $41,967 $89,137 $90,028 ($23,821) $90,690 $40,597 ($396,747) $11,536 Year End Cash Balance $393,294 $371,727 $413,694 $502,831 $592,859 $569,038 $659,728 $700,326 $303,579 $315,115 Community Investment Fund Current Balance: $544,895 Table B-4 Project 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Annual Expenditures $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Community Improvement CIP $0 $0 $568,970 $0 $0 $0 $0 $0 $0 $0 Debt Service $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Total Expenses $0 $0 $568,970 $0 $0 $0 $0 $0 $0 $0 Revenues (interest) $5,449 $5,503 $5,558 $0 $0 $0 $0 $0 $0 $0 Year End Cash Balance $550,344 $555,847 ($7,564) ($7,564) ($7,564) ($7,564) ($7,564) ($7,564) ($7,564) ($7,564) Capital Improvement Plan, City of Orono MSA Fund Current Balance: Current Fund Balance: $0 State MSA Construction Balance= $550,000 Table 13-5b Table 13-5a Project 2020 2021 Project 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Annual Expenditures (MSA CIP) $71,867 $71,867 $71,867 $335,000 $0 $400,000 $408,000 $416,160 $424,483 $432,973 Annual MSA Maintenance Payment to the City $39,438 $39,438 $39,438 $39,438 $39,438 $39,438 $39,438 $39,438 $39,438 $39,438 Debt Service (interest) -from MSA maintenance account. $28,113 1 $24,663 1 $21,063 1 $17,000 1 $12,469 1 $7,688 $2,625 1 $0 1 $0 $0 Debt Service (Principal) -from MSA Construction Account $115,000 $115,000 $120,000 $125,000 $125,000 $130,000 $140,000 $0 $0 $0 Total Expenses $254,417 $250,967 $252,367 $516,438 $176,906 $577,125 $590,063 $455,598 $463,921 $472,410 $900,000 $900,000 Annual Balance ($246,250) ($479,200) $71,700 ($6,700) $361,600 $50,000 $27,000 $3,540 ($20,389) Yearly Allocation - MSA Maintenance $123,833 $123,833 $123,833 $123,833 $123,833 $123,833 $123,833 $123,833 $123,833 $123,833 Yearly Allocation - MSA Construction $201,751 $201,751 $201,751 $201,751 $201,751 $201,751 $201,751 $201,751 $201,751 $201,751 Annual Balance $71,167 $74,617 $73,217 ($190,854) $148,678 ($251,541) ($264,479) ($130,014) ($138,337) ($146,826) Year End Cash Balance $71,167 $145,784 $219,001 $28,148 $176,825 ($74,716) ($339,194) ($469,208) ($607,544) ($754,371) Pavement Management Fund Current Balance: -$61,122 $217,004 Table 13-5b Table B-6 Project 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Annual Operation and Maintenance (1) $0 1 $0 1 $0 1 $0 $0 $0 $0 1 $0 $0 $0 CIP Expenditures $863,700 $1,229,200 $778,300 $1,206,700 $838,400 $1,150,000 $1,173,000 $1,196,460 $1,220,389 $1,244,797 Total Expenses $863,700 $1,229,200 $778,300 $1,206,700 $838,400 $1,150,000 $1,173,000 $1,196,460 $1,220,389 $1,244,797 $375,308 $422,833 $488,528 $484,544 $348,973 $306,742 Total Expenses $1,479,535 $1,521,329 $1,575,959 Revenues(1) $0 $0 $0 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 Pavement Management Levy $617,450 $750,000 $850,000 $900,000 $900,000 $900,000 $900,000 $900,000 $900,000 $900,000 Annual Balance ($246,250) ($479,200) $71,700 ($6,700) $361,600 $50,000 $27,000 $3,540 ($20,389) ($44,797) Year End Cash Balance ($307,372) ($786,572) ($714,872) ($721,572) ($359,972) (309,972) (282,972) (279,432) (299,822) (344,619) Water Fund Current Balance: $217,004 Table B-6 Project 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Annual Operation and Maintenance (1) $988,250 $1,009,388.98 $1,039,998 $1,080,749 $1,115,001 $1,142,408 $1,170,969 $1,200,243 $1,230,249 $1,261,005 Debt Service $155,430 $157,180 $156,830 $100,430 $98,570 $101,550 $100,500 $104,000 $100,600 $103,000 CIP Expenditures $335,855 $354,760 $379,131 $420,094 $375,308 $422,833 $488,528 $484,544 $348,973 $306,742 Total Expenses $1,479,535 $1,521,329 $1,575,959 $1,601,273 $1,588,879 $1,666,791 $1,759,997 $1,788,786 $1,679,822 $1,670,747 Revenues (1) $1,134,237 $1,276,818 $1,377,966 $1,389,093 $1,400,331 $1,411,681 $1,454,031 $1,497,652 $1,542,582 $1,588,859 Add back Depreciation $225,800 $231,385 $245,889 $269,805 $287,271 $297,544 $304,983 $312,607 $320,422 $328,433 Assessments $10,387 $10,387 $10,387 $10,387 $10,387 $10,387 $10,387 $0 $0 $0 Annual Balance ($109,111) ($2,739) $58,283 $68,013 $109,109 $52,821 $9,404 $21,473 $183,182 $246,545 Year End Cash Balance $107,894 $105,155 $163,438 $231,451 $340,560 $393,381 $402,785 $424,258 $607,440 $853,985 Capital Improvement Plan, City of Orono Sewer Fund Improvement Revolving (PIR) Fund Current Balance: $2,364,946 $1,428,299 Amount Available for Police Purchases= $268,823 Table B-9 Table B-7 Project 2020 2021 2022 Project 1 2020 2021 2022 2023 2024 2025 1 2026 1 2027 1 2028 1 2029 Operation and Maintenance (1) $1,791,200 $1,844,027.04 $1,894,399.43 $1,939,171.03 $1,981,278 $2,023,797 $2,074,392 $2,126,252 $2,179,408 $2,233,893 Debt Service $110,000 $110,000 $110,000 $0 $0 $0 $0 $0 $0 $0 CIP Expenditures $784,750 $744,000 $633,250 $520,550 $424,480 $1,061,000 $631,700 $638,534 $645,505 $652,615 Transfer to Equipment Fund for Sewer Equip $115,000 $31,500 $0 $450,000 $0 $35,000 $0 $0 $0 $0 Total Expenses $2,800,950 $2,729,527 $2,637,649 $2,909,721 $2,405,758 $3,119,797 $2,706,092 $2,764,786 $2,824,913 $2,886,508 Revenues (1) $569,936 $797,910 $821,847 $838,284 $855,050 $872,151 $889,594 $907,386 $925,534 $944,044 Revenues (1) $1,858,429 $2,137,193 $2,179,937 $2,223,536 $2,268,007 $2,313,367 $2,359,634 $2,406,827 $2,454,963 $2,504,063 Add back Depreciation $353,600 $377,100 $397,107 $410,136 $420,592 $430,805 $441,575 $452,615 $463,930 $475,528 Assessments $35,349 $30,368 $26,934 $24,902 $17,569 $17,569 $10,939 $2,000 $0 $0 Annual Balance ($553,572) ($184,866) ($33,671) ($251,147) $300,410 ($358,056) $106,056 $96,655 $93,980 $93,082 Year nd Cash Balance $1,811,374 $1,626,508 $1,592,837 $1,341,690 $1,642,099 $1,284,043 $1,390,099 $1,486,754 $1,580,734 $1,673,817 Storm Water Fund Improvement Revolving (PIR) Fund Current Balance: $1,223,743 $1,428,299 Amount Available for Police Purchases= $268,823 Table B-9 Table B-8 Project 2020 2021 2022 Project 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Operation and Maintenance (1) $373,000 $388,798.40 $402,048.43 $417,187.39 $430,298 $445,620 $456,761 $468,180 $479,884 $491,882 CIP Expenditures $580,425 $418,120 $456,160 $372,610 $479,605 $440,000 $442,800 $503,641 $448,569 $451,541 Transfer to Equipment Fund for Storm Equip $100,000 $0 $75,000 $0 $0 $12,000 $600,000 $0 $0 $0 Total Expenses $1,053,425 $806,918 $933,208 $789,797 $909,902 $897,620 $1,499,561 $971,821 $928,454 $943,422 ($8,181) ($43,470) Year End Cash Balance $1,435,131 $1,408,855 $1,402,147 $1,360,198 $1,367,651 $1,359,993 $1,367,069 $1,374,020 $1,365,839 Revenues (1) $569,936 $797,910 $821,847 $838,284 $855,050 $872,151 $889,594 $907,386 $925,534 $944,044 Add back depreciation $62,000 $71,454 $78,135 $86,407 $92,670 $101,004 $103,529 $106,117 $108,770 $111,490 Annual Balance ($421,489) $62,446 ($33,226) $134,894 $37,818 $75,534 ($506,438) $41,682 $105,850 $112,112 Year End Cash Balance $802,254 $864,700 $831,473 $966,367 $1,004,185 $1,079,720 $573,282 $614,964 $720,814 $832,926 Permanent Improvement Revolving (PIR) Fund Current Balance: $1,428,299 Amount Available for Police Purchases= $268,823 Table B-9 Project 2020 2021 2022 2023 2024 1 2025 2026 2027 2028 2029 Police Expenses 1 $5,464 $40,628 $20,796 $55,970 $6,149 1 $21,334 $6,524 $6,720 $21,921 $57,129 Total Expenses $5,464 $40,628 $20,796 $55,970 $6,149 $21,334 $6,524 $6,720 $21,921 $57,129 Revenues $12,296 $14,351 $14,089 $14,021 $13,602 $13,677 $13,600 $13,671 $13,740 $13,658 Annual Balance $6,832 ($26,276) ($6,708) ($41,949) $7,453 ($7,657) $7,076 $6,951 ($8,181) ($43,470) Year End Cash Balance $1,435,131 $1,408,855 $1,402,147 $1,360,198 $1,367,651 $1,359,993 $1,367,069 $1,374,020 $1,365,839 $1,322,369 NOTES: (1) Expenses and Revenues are based on the City's 2011 budget. For Planning purposes a 2.5% annual inflation factor has been used to project future costs. (2) Revenues are based on a 1.5% increased contribution starting in 2016 and adding a 1% interest earned on the previous year's balance.