Loading...
HomeMy WebLinkAbout1A 2020-2029 CIP - Workshop Report 2019.07.15 Phone 952.447.9800 / Fax 952.447.4245 / www.cityofpriorlake.com 4646 Dakota Street SE Prior Lake, MN 55372 CITY COUNCIL WORK SESSION REPORT MEETING DATE: JULY 15, 2019 AGENDA #: A PREPARED BY: CATHY ERICKSON, FINANCE DIRECTOR ANDY BROTZLER, PUBLIC WORKS DIRECTOR & CITY ENGINEER PRESENTED BY: CATHY ERICKSON AND ANDY BROTZLER AGENDA ITEM: DRAFT 2020-2024 CAPITAL IMPROVEMENT PROGRAM – PART 2 ACTION REQUESTED: The Council should provide comments on the draft CIP document and its various elements in order that the approval process can proceed as planned. GOAL AREA AND OBJECTIVE: High-Value City Services 1. Establish financial stability for all funds. 2. Design a comprehensive funding strategy for capital needs. Transportation & Mobility 1. Maintain quality local street system based on a financially stable plan that meets Overall Condition targets. 2. Promote neighborhood connectivity and safety through development and street reconstruction projects. 3. Integrate trails to link neighborhoods with city and regional assets. 4. Support complete street designs that ensure pedestrian mobility and multi- modal transportation options. 5. Focus on key corridors that take advantage of collaboration with state and county projects. DISCUSSION: Introduction At the Council workshop on May 20, Staff presented a Five-year Property Tax projection that included the projects identified in the approved 2019-2021 CIP. The projection will be updated based on the outcome of this year’s CIP process. This year, the CIP Council Workshops are divided into two parts. Part 1: This workshop was held on June 17. The purpose of this workshop was to complete a City Council review and receive input regarding the proposed 2020-2024 Capital Improvement Program (CIP) for the following draft plans: 1) Equipment Replacement Plan 2) Park Plan 3) Facilities Management Plan 4) Technology Plan Part 2: The remaining CIP draft plans, noted below, will be reviewed at the July 15 Council workshop 1) Transportation Plan 2) Street Overlay Plan 3) Water Operating Plan 4) Sanitary Sewer Operating Plan 5) Water Quality Operating Plan The July 15 Council workshop will also include the financial analysis of the Capital Improvement Plans. The draft summary documents have been included for City Council review. The supporting documentation for each of the plans is available if needed. Follow-up Item from June Workshop: At the June workshop staff discussed that we are implementing a CIP reporting software to standardize our CIP reporting across funds and provide plan detail in a consistent manner. We have attached a copy of the Equipment Replacement Plan with the supporting Five Yr. Equipment Replacement Plan Detail report that was generated from our new CIP reporting software. (The report is titled Capital Improvement Plan Projects by Category and Department.) 1. Transportation Plan 2020-2024 The 2020-2024 bonding is estimated at $11,440,782.00. Changes include: 1. The Fish Point Road/Hidden Oaks/Timberview/Timber/Millers/Omega/Glory reconstruction project was shifted from 2020 to 2021. This was to account for the change in schedule for the construction of the CSAH 21/TH 13 project which has a modified substantial completion date of July 2020. 2. As previously presented, additional cost associated with the CSAH 21/TH 13 project is proposed to be funded through a combination of sewer and water utility funds, and MSA funds with no additional impact to the tax levy. 3. Currently, the remaining proposed reconstruction projects remains unchanged. 4. The Inguadona/Roosevelt/Ramsey/Green Heights Trail/Park/Pershing/Dunkirk/Roanoke/Green Heights/Spring/Park reconstruction project area was previously shifted from 2019 to 2021. This project includes private streets for which potential funding mechanisms for private streets with utility replacement is being evaluated with the utility rate study currently in progress. With the current condition of the utilities in this area and the number of repairs that have been made, there is some concern about continuing to delay this project area. 5. Identified the Raspberry Ridge/Hidden Pond/Black Oak/Timberglade/Appaloosa Trail/Highland Ct./Island View Cir./Island View Rd./Island Circle reconstruction project area for 2024. 6. Staff is proposing that future improvement project schedules be developed to facilitate bidding projects in November/December of the year prior to scheduled project construction identified in the Transportation Plan. Due to the size, complexity and anticipated level of public engagement that will be necessary for several of the upcoming year’s projects, staff anticipates requesting Council authorization to initiate projects 12 to 14 months in advance of the desired bid date. Staff has updated the Plans and will present the 2020-2024 projects at the workshop for City Council consideration. Attached are the following documents for Council review and discussion at the workshop: • The Summary of the Transportation Plan (10-year) • Transportation Plan Map 2025-2029 Recognizing that projects shift within our five-year CIP, projects scheduled for 2025 – 2029 show general non-specific information. Staff recommends rehabilitation or reconstruction of two miles per year. The plan currently includes one and a half miles per year. 2. Street Overlay Plan Minnesota Statutes, Section 429.091, Subd. 7a, authorizes the issuance of general obligation bonds secured by the revenues of a permanent improvement revolving fund (PIR Fund). In 2017, the Council approved the establishment of the PIR Fund. The plan reflects three to four miles of street overlay annually. W e anticipate that the City will bond for the special assessment portion of the cost and fund the remainder with prepayments of special assessments collected from prior year(s) improvements and an annual tax levy. The fund will be reviewed annually, to monitor cash flow and determine the tax levy needed. The 2020 proposed project currently includes the following streets: • Windsor Lane • Wellington Court • Windom Court • Lexington Court • Crimson Court • Wilderness Trail • Fairway Heights • Fairway Heights Court • Foxtail Trail • Blind Lake • Jeffers Pass • Raspberry Ridge Road • Jeffers Court • Cottonwood Lane This represents approximately 2.3 miles which is less than the target of three to four miles annually. This reflects anticipated cost increases as well as additional concrete work for the 2020 project area. A feasibility report will be completed this fall. 3, 4 and 5. Water, Sewer and Storm Water Plans Utility Capital Projects As a reminder, the Water, Sewer, and Storm Water Plans include projects associated with the Transportation Plan. This means that fund balances are directly impacted by the transportation plan projects where there is utility reconstruction completed below the street. (Funds will be transferred to the Construction fund for the utility cost portion of street projects.) A copy of the transportation plan is attached for reference. Street reconstruction with utilities in 2019: The only 2019 utility work will be on the CSAH 21/TH13/Main Ave/Arcadia road project. The estimated total cost built into the prior year utility plans was $100,000 and $250,000 for the water and sewer utilities respectively. The actual bid for the project utility work came in at $392,000 and $588,000 for the water and sewer utilities respectively. This is a shortfall of $292,000 and $338,000 for the water and sewer utilities respectively. The water and sewer utility funds have been updated to reflect these additional funding needs. Street reconstruction with utilities in 2020: Due to the significant road projects in 2018 and 2019 and delay in the engineering work needed on the 2020 Fish Pt Rd area project, the planned 2020 Fish Pt Rd area project will need to be moved to 2021. Utility reconstruction on private streets in 2021 The transportation plan includes utility reconstruction on the Pershing/Dunkirk area streets in 2021. At this time the utilities under the Inguadona area private streets will also be reconstructed. The street portion of the cost for the Inguadona area private streets is $311,000. This cost is allocated between the Water and Sewer Funds at $172,000 and $139,000 respectively and is included as a use of funds in the plans. Council has directed staff to explore the establishment of a Utility Special District for properties served by private streets. The Utility Special District funds will be collected from the private street properties to help offset the cost to replace the private streets after replacement of the public utilities below the street. This process will start with discussions with HOAs/neighborhoods with private streets to provide education on the use of the funds and respond to resident questions/ concerns. Staff anticipates that this item will be brought to the Council for approval in late 2019. Revenue estimate per year for the special billing district for private streets is $200,000. The revenue is shared equally between the Water and Sewer Funds at $100,000 each and has been included as a source of funds in the plans starting in 2020. Staff has also included use of funds for future private street replacement in the water and sewer plans. Utility Rate Study The city’s planned utility rate study is underway. Staff anticipates bringing the rate study results to the Council in October of this year. The last utility rate study was done in 2004. As part of the utility rate study/plan updates, staff plans to revisit our tiered rate structure to address appropriate charges and number of tiers for high consumption. Currently our summer water usage is up to 3 times our winter usage which can be attributed directly to irrigation. The existing tiered rates have had minimal impact on irrigation usage. Moreover, some decades ago the city implemented a program which encouraged water users to fill their pools early in the year so that water quantity would not be included in the water usage average which determines the bi-monthly sewer usage calculation. This appropriateness of this policy is to come under scrutiny as well (See Sewer Plan discussion below). Considering the significant investment the City is putting into infrastructure to support these uses, it would be beneficial to adjust the tiered rates to collect additional revenue from the users who are largely responsible for these capital improvement costs. Staff also anticipates a base charge for water and sewer services to cover our fixed water and sewer costs and base sewer flow. The rate adjustments developed below are based on our current billing structure and planned projects. This review of our operating and maintenance costs, capital projects, debt etc. will also be provided as inputs for the rate study. This information will be updated based on the results of the utility rate study. Utility Billing System Upgrade The Water and Sewer Plans include a use of funds of $70,000 for an upgraded utility billing system. Incode, our utility billing vendor is requiring an upgrade from our current version. Staff is considering changing to our current financial system vendor, BS&A, so all financial modules are integrated within the same financial software system, and due to the limitations of the Incode product. Staff is proposing to do a RFP in late 2019 with a possible late 2020 implementation date. Water Plan: Utility Capital Projects: The 2020-2024 Water Plan includes $6,166,140 in use of funds that will be transferred to the Construction fund for the utility cost portion of street projects. This includes about $172,000 for the water fund portion of the Inguadona area private street replacement. The contributions from the Water Utility Fund for transportation/ street projects varies by year, based on the projects. The five-year (2020-2024) contribution average is about 1,233,000. This is a 66% increase in the planned five- year contribution average as compared to the prior year CIP. This is primarily due to an increase in estimated future project costs, based on the bids that have been received for recent utility replacement projects. AMRS Project: Council Resolution 18-191 approved amending the 2018 AMRS replacement project costs to a total of $2.2M. This was an increase of about $754k that was not planned in the bonding request. This increase of $377k in each of the water/sewer funds must be absorbed by using fund balance. At the time of Council approval, the fund had adequate reserves to fund this expenditure with cash. However, the scope and planned cost of utility replacement projects has increased dramatically due to a shortage of contractors to do the work and the current bidding environment. Based on this, the future utility rates will need to be adjusted to reflect this additional use of cash for the AMRS project. Staff anticipates that the AMRS replacement project will be completed by the end of 2019. Water Tower Reconditioning: The Water Operating Plan also includes $1M in 2021 (Tower St) and $1.1M in 2024 (Cedarwood St) for the elevated water storage tower reconditioning. 2020 Water Rates: For 2020, staff recommends a rate increase of 7% for the Water Plan primarily to build an adequate fund balance to cover the increasing scope and planned costs for street utility replacements and to replenish the fund for the portion of the AMRS project funded with cash. For 2020 forward, the rate structure will be based on the updated plans from our consultants. Sewer Plan: 2020 Sanitary Sewer Rates: Utility Capital Projects: The 2020-2024 Sanitary Sewer Plan includes $3,632,720 in use of funds that will be transferred to the Construction fund for the sanitary sewer utility cost portion of street projects. This includes about $139,000 for the Inguadona area private street replacement. The contributions from the Sewer Utility Fund for transportation/ street projects varies by year, based on the projects. The five-year (2020-2024) contribution average is about $727,000. This is a 40% increase in the planned five-year contribution average as compared to the prior year CIP. This is primarily due to an increase in the project scope and estimated future project costs, based on the bids that have been received for recent utility replacement projects. Concrete Sewer Lining Replacement: We anticipate that there will be a use of funds for future concrete sewer lining projects. Over the ten-year period beginning in 2022, we have included costs of $1.9M. Staff has been evaluating the impact of billed sewer flows on revenues and the increase in capital project expenditures on the sewer fund reserves. Summer Sewer Lock/Cost Break: We bill sewer based on water consumption, however, we provide a summer sewer lock. Residents pay the average of the Feb and April consumption for the August and October billing cycles. In 2019, the Council modified the summer sewer lock to cover two billing cycles (August and October) instead of four billing cycles (June, August, Oct and December) because the August and October billing cycles more accurately cover the summer time period (May 21-Sept 20). The billing cycles cover the following time periods highlighted in blue: This change should generate about $100,000 in revenue annually. Sewer Fund Balance: Based on the current plans it is likely that the fund balance will drop below the recommended amount in 2019. Staff has identified several options the Council can consider maintaining an appropriate fund balance in the Sewer Fund: 1. Increase the City portion of the sewer rate. 2. Issue debt to fund at least a portion of the 2020/2021 $2.2M capital needs. 3. Consider postponing one or more projects to a future year. 4. Consider a combination of the above. If no change is made to the current billing structure, Staff is recommending a combined approach of a rate adjustment and debt issuance. The proposed 2020 rate increase in the City portion of the rate is $0.50 (7%). The proposed debt issuance is $1.5M. Staff would prefer to finance the sewer fund portion of the transportation projects on a pay-as-you-go basis instead of issuing debt. However, due to the upcoming significant utility replacement projects, a combined approach of a rate adjustment and debt issuance is proposed. The only sewer cost in 2019 is related to the CSAH 21/TH 13 project and that cannot be delayed. The utility work for the Fish Point Road is proposed to be pushed from 2020 to 2021. That street is in very poor condition and would be difficult to delay. In 2021 we are also proposing to complete projects in the Pershing/Green Heights neighborhood, including the private streets such as Inguadona. This will require significant funding from the sewer fund. In 2022 we are proposing mostly full depth reclamation projects to help ease the strain on the sewer fund. Based on this transportation plan there are not a lot of opportunities to reduce the burden on the sewer fund in the near term. For 2021 forward, the rate structure will be based on the updated utility rate study, and Council consideration of the options outlined above MCES impact on the Sewer Fund: The Metropolitan Council Environmental Services (MCES) annual operating budget plans for the resources necessary to support its two core functions: wastewater Month Billing Cycle Feb Nov 21 - Jan 20 Apr Jan 21 - March 20 June March 21 - May 20 Aug May 21 - July 20 Oct July 21 - Sept 20 Dec Sept 20 - Nov 20 collection and treatment and water resource planning. Based on the MCES budget workshop information presented in May, the proposed 2020 cost increase is 7.34%. The MCES sets the rates based on the actual flow from 2018 (two years prior historical). The cost increase is comprised of two components as follows: 1) A volume increase of 3.7% based on the change in metered flow from 2017 to 2018. 2) A rate increase of 3.6%. The MCES total regional wastewater charge is up 3.6%. The total regional flow is down -2.33%, but the cost is still spread over the same users. The City of Prior Lake’s proportionate share results in a 3.6% rate increase. The Sewer plan currently reflects a 7.34% increase in the MCES cost, which will be adjusted if there is a change in the final information that is received from the MCES in early August. Storm Water Plan: The Storm Water Plan includes pond maintenance and retrofit projects. Utility Capital Projects: The 2020-2024 Storm water plan includes $2,515,000 in use of funds that will be transferred to the Construction fund for the water quality cost portion of street projects. The two significant drivers for the anticipated expenditures over the next 10 years from the Storm Water Utility fund is approximately $3.3M for water quality improvements associated with road reconstruction projects. These improvements include the development of ponding for the treatment of storm water runoff to comply with storm water regulations. An additional $1.6M is identified for pond maintenance and clean out projects over the next 10 years. Additional noted projects that are proposed include: • Adelman Street Pond (2025) - $150,000 • Markely Lake Stormwater Study and Erosion Repairs (2020-2026) - $305,000 2020 Storm Water Rates: For 2020, staff recommends a rate increase of $1.51 (10.5%) for the Storm Water Plan due to the increase in stormwater project costs that we are experiencing. ISSUES: Conclusion Once the City Council has completed the review of the CIP plans, and provided direction on project priorities by plan, staff will make any revisions before the public presentation. Council direction is specifically needed on the following items: • Any projects Council is hesitant about proceeding with that are programmed in the CIP. • Proposed rate increases for the utility plans are as follows: o Water – $.34 (7% increase) FINANCIAL IMPACT: o City Sewer – $.50 and MCES Sewer – $.21 (Combined increase of 11%) o Storm Water – $1.51 (10.5% increase) • Proposed debt issuance of $1.5M for the sewer plan to fund the significant utility replacement projects. • Whether the CIP tax levy impact proposed for 2020 is acceptable. A public presentation for the CIP is scheduled at the Council meeting on Monday, August 5. In reviewing the 2020-2024 Capital Improvement Program, the City Council should consider the annual tax impact of the scheduled projects. CIP Bonding: The 2020-2024 CIP includes projects that are funded by bond proceeds. Bonds are issued for the project costs that the City is funding through tax levies as well as the costs that are specially assessed to property owners. The 2020-2024 CIP anticipates the following bonding needs: • Transportation Plan projects for 2020-2024 of $18,174,000. • Bonding for the following major facility repairs, equipment replacements and water/sewer plan capital projects by year: Year Major Facility Repairs Equipment Replacements 2020 - - 2021 - 1,025,000 2022 - - 2023 - - 2024 600,000 - The equipment replacements are a Fire water tanker and pumper in 2019 and 2021 respectively. The major facility expenditures are for City Hall and Police Station HVAC/carpet/ wall coverings, and the Maintenance Center front parking lot and crane. Summary of Projected Debt Balances The chart below reflects the cumulative effect of proposed new debt issued and the retirement of existing debt. Summary of Projected Tax Levy for Debt Service: Bond Repayment through Debt Service Tax Levy: The impact of the 2020-2024 CIP and other anticipated bond payment adjustments on the debt service property tax levy are reflected in the following tables. Projected five-year annual change in debt levy: The table below indicates that we are adding more CIP debt annually than the existing debt that is falling off. Projected change in total CIP Tax Levy: The funds/plans that have a CIP tax levy are shown below. 2020 2021 2022 2023 2024 Debt: Existing CIP 56,457 20,251 (23,733) (214,511) (96,115) New CIP - 284,349 423,539 527,288 232,233 Market Referendum 7,639 11,431 1,150 10,770 15,125 Change in Debt Levy 64,096 316,030 400,956 323,547 151,243 2020-2024 CIP Projected Change in Debt Levy The table below shows the projected change in the CIP tax levy by component before one-time equipment and trail replacement levy adds. The next table below shows the projected change in the CIP tax levy by component after including the following items: • $114k added to 2020 equipment replacement tax levy for Police radio replacement • $90k added to the Parks tax levy for trail replacement The table below summarized the annual projected total CIP tax levy by component. The projected debt service shown above reflects the final 2019A bond issue. This project debt service levy estimates for years 2020-2024 is based on ten-year level annual debt service payments. Bond Repayment Debt Service supported by Water and Sewer Fund Revenues: • Revenues of the Water and Sewer Funds support the annual debt service for the Water Treatment Plant debt refunding bond issues, the AMRS replacement, and the Huron area street improvements. Staff is proposing debt issuance of $1.5M for the sewer plan to fund the significant utility replacement projects. The projected annual debt service for the utility funds is shown below: Tax Levies:2020 2021 2022 2023 2024 Equipment Revolving Fund 25,000 25,000 25,000 25,000 25,000 Revolving Park Equip Fund 29,708 56,000 43,000 31,000 50,000 Facilities Management Fund 30,000 50,000 25,000 35,000 25,000 PIR Fund 35,000 35,000 35,000 - - Debt Service 64,096 316,030 400,956 323,547 151,243 Total CIP Tax Levies 183,804 482,030 528,956 414,547 251,243 2020-2024 CIP Projected Change in CIP Tax Levy Tax Levies:2020 2021 2022 2023 2024 Equipment Revolving Fund 139,000 (89,000) 25,000 25,000 25,000 Revolving Park Equip Fund 119,708 (34,000) 43,000 31,000 50,000 Facilities Management Fund 30,000 50,000 25,000 35,000 25,000 PIR Fund 35,000 35,000 35,000 - - Debt Service 64,096 316,030 400,956 323,547 151,243 Total CIP Tax Levies 387,804 278,030 528,956 414,547 251,243 Projected Change in CIP Tax Levy2020-2024 CIP 2020 2021 2022 2023 2024 Equipment Revolving Fund 739,000 650,000 675,000 700,000 725,000 Revolving Park Equip Fund 409,000 375,000 418,000 449,000 499,000 Facilities Management Fund 30,000 80,000 105,000 140,000 165,000 PIR Fund 130,000 165,000 200,000 200,000 200,000 Debt Service 3,561,284 3,877,314 4,278,270 4,601,817 4,753,060 Total CIP Tax Levies 4,869,284 5,147,314 5,676,270 6,090,817 6,342,060 2020-2024 CIP Tax Levies: Projected CIP Tax Levy Based on Council direction, updated financial information related to the impact of the proposed CIP on debt levels, fund balance reserves and average utility customer will be distributed as part of the public presentation on the CIP at the Monday, August 5 Council meeting. Approval of the CIP does not obligate the City to complete the proposed projects or purchases. The 2020 projects/proposed purchases will be incorporated into the 20202 budget requests for budgeted funds. Further Council approvals may be necessary to comply with state statutes and the city’s purchasing policy. CIP Impact on Long Range Financial Plan: Tonight’s Workshop Topic B is an update to the Long-Range Financial Plan. The financial plan incorporates the debt and tax levy impacts of the Capital Improvement Program that are shown above. 2020 2021 2022 2023 2024 Water Fund 728,500 740,170 749,300 779,870 785,085 Sewer Fund 174,450 349,013 349,213 349,213 349,013 2020-2024 CIP Projected Debt Service (funded by Utility Fund Revenues) Draft 6/17/2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Use of Funds: Fire Dept Total 115,000$ 700,000$ 100,000$ 186,000$ 140,000$ -$ 45,000$ -$ -$ -$ Police Dept Total 334,000 310,000 243,000 230,000 157,000 209,000 263,000 211,000 203,000 261,000 Public Works Dept Total 642,000 738,000 739,000 476,000 502,000 785,000 448,000 819,000 848,000 1,362,000 Total Use of Funds 1,091,000$ 1,748,000$ 1,082,000$ 892,000$ 799,000$ 994,000$ 756,000$ 1,030,000$ 1,051,000$ 1,623,000$ Source of Funds: Interest Earnings (1.5%)7,000 3,000 5,000 2,000 3,000 5,000 9,000 13,000 13,000 13,000 Annual Equipment Levy 625,000 650,000 675,000 700,000 725,000 750,000 775,000 800,000 825,000 850,000 Water Fund Contribution 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 Sewer Fund Contribution 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 Water Quality Fund Contribution 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 Forfeiture Funds / Donations - 33,000 34,000 35,000 - - - 40,000 - - Auction Proceeds 12,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000 Bond Proceeds 1,025,000 - - - 350,000 - - 450,000 Total Source of Funds 824,000$ 1,903,000$ 906,000$ 929,000$ 920,000$ 1,297,000$ 976,000$ 1,045,000$ 1,030,000$ 1,505,000$ Change in Fund Balance (267,000)$ 155,000$ (176,000)$ 37,000$ 121,000$ 303,000$ 220,000$ 15,000$ (21,000)$ (118,000)$ Beginning Fund Balance 453,000$ 186,000$ 341,000$ 165,000$ 202,000$ 323,000$ 626,000$ 846,000$ 861,000$ 840,000$ Ending Fund Balance 186,000$ 341,000$ 165,000$ 202,000$ 323,000$ 626,000$ 846,000$ 861,000$ 840,000$ 722,000$ CITY OF PRIOR LAKE 2020 - 2029 EQUIPMENT REPLACEMENT PLAN Page 1 of 1 Capital Improvement Plan City of Prior Lake, Minnesota PROJECTS BY CATEGORY AND DEPARTMENT 2020 2024thru Total2020 2021 2022 2023 2024 Department Category Fire Equipment: FD-Apparatus 150,000 150,000Lite Rescue Utility Truck FD-9215 103,000 103,0002009 Peterbilt Heavy Rescue FD-9216 0 01993 Peterbilt Pumper FD-9220 700,000 700,0001996 Peterbilt Pumper FD-9221 0 02007 Peterbilt Pumper FD-9222 0 02001 Peterbilt Tanker FD-9260 0 02007 E-One 100ft Aerial FD-9280 0 700,000 150,000 103,000 953,000Sub-Total Equipment: FD-First Response 35,000 35,0002014 Ford F-150 Super Cab (Asst.)FD-9201 37,000 37,0002015 Ford F-150 Super Cab (Asst.)FD-9202 36,000 36,0002015 Ford F-150 Super Cab (Asst.)FD-9203 35,000 36,000 37,000 108,000Sub-Total Equipment: FD-Grass Rigs 65,000 65,0002000 Ford F-350 Crew Cab w/ Pump FD-9270 0 02001 Ford F-350 FD-9271 65,000 65,0002007 Ford F-350 Super Cab (V10)FD-9272 65,000 65,000 130,000Sub-Total Equipment: FD-Other 0 02016 Trailer FD-9276 0 02012 Rescue Boat (Viking)FD-9290 50,000 50,000Fire Radios FD-RADIOS 50,000 50,000Sub-Total 115,000 700,000 100,000 186,000 140,000 1,241,000Department Total: Police Equipment: PD-Emerg. Sirens 20,000 20,0001990 Siren@3375 Crystal Cir NW (15800 Fremont) PD-Siren01 20,000 20,0001990 Siren@15079 Manitou Rd. NE PD-Siren02 20,500 20,5001990 Siren@5569 Cedarwood St. NE PD-Siren03 0 01996 Siren@3765 Willowwood St SW PD-Siren04 20,000 20,0001996 Siren@16776 Fish Point Rd SE (F.S. #1)PD-Siren05 0 01996 Siren@2400 Mystic Lake Cir NW (Casino) PD-Siren06 8,500 8,5001996 Siren@13701 Pike Lake Trl NE PD-Siren07 8,500 8,5001996 Siren@13760 McKenna Rd NW PD-Siren08 Wednesday, July 10, 2019Page 1Produced Using the Plan-It Capital Planning Software Total2020 2021 2022 2023 2024 Department Category 0 01997 Siren@16730 Northwood Rd NW PD-Siren09 21,000 21,0001998 Siren@14649 Glendale Ave SE PD-Siren10 22,000 22,0002003 Siren@16280 Duluth Ave SE PD-Siren11 22,500 22,5002004 Siren@5634 Luther Rd SE PD-Siren12 40,000 40,500 38,000 22,000 22,500 163,000Sub-Total Equipment: PD-Encripted Radios 0 02019 Portable Encrypted Radios PD-Rad01 103,000 103,0002020 Portable Encrypted Radios PD-Rad02 113,000 113,0002021 Portable Encrypted Radios PD-Rad03 103,000 113,000 216,000Sub-Total Equipment: PD-Other 0 02008 Squad-SWAT Van PD-1108 0 02000 Trailer-Speed PD-1293 33,000 33,0002009 Squad-Investigator Car PD-1407 33,000 33,000Sub-Total Equipment: PD-Repl. 35,000 35,0002006 Squad-Pick-Up-1/2 Ton PD-1606 35,000 35,000Sub-Total Equipment: PD-Squads 41,000 41,0002014 Squad-Unmarked PD-1014 42,500 46,500 89,0002016 Squad-Marked SUV PD-116 36,000 36,0002012-Lincoln MKZ PD-1212 40,000 44,000 84,0002017 Squad-Marked SUV PD-1317 44,000 44,0002018 Squad-Marked PD-1518 39,000 42,000 81,0002017 Squad-Unmarked PD-1717 34,000 34,0002015 Drug Task Force Car PD-1815 44,000 44,0002018 Squad-Marked SUV PD-218 41,000 45,000 86,0002016 Squad-Marked SUV PD-316 39,000 42,500 81,5002017 Squad-Marked SUV PD-417 40,000 44,000 84,0002018 Squad-Marked PD-618 39,000 42,500 81,5002015 Squad-Marked SUV PD-715 41,000 41,0002015 Squad-Marked SUV PD-815 158,000 156,500 170,000 208,000 134,500 827,000Sub-Total 334,000 310,000 243,000 230,000 157,000 1,274,000Department Total: Public Works Equipment: PW-Attachments 3,000 3,0002000 SKID STEER COMBO PLANE PW-ATT-250 7,000 7,0002011 SKID STEER BOX BROOM PW-ATT-255 21,000 21,0002012 SKID STEER ASPHALT MILL PW-ATT-258 14,500 14,5002005 SKID STEER JACK HAMMER PW-ATT-259 27,000 27,0002007 SKID STEER MANHOLE CUTTER PW-ATT-261 6,000 6,0002011 TURF AERATOR PW-ATT-262 9,500 9,5002016 TILLER PW-ATT-268 0 02010 BALLFIELD DRAG PW-ATT-271 10,000 10,0002015 STUMP GRINDER PW-ATT-272 34,500 34,5002003 DIRECTIONAL SAFETY SIGN PW-ATT-274 Wednesday, July 10, 2019Page 2Produced Using the Plan-It Capital Planning Software Total2020 2021 2022 2023 2024 Department Category 5,000 5,0002000 CEMENT MIXER PW-ATT-276 6,500 6,5002020 Trail Blower PW-ATT-NEW 29,000 23,000 36,500 34,500 21,000 144,000Sub-Total Equipment: PW-Building 29,000 29,0002012 TRUCK-1 TON BD-397 32,000 32,0002018 FORD SUV BD-398 32,000 29,000 61,000Sub-Total Equipment: PW-Central Garage 20,000 20,000 20,000 20,000 20,000 100,000REFURBISHINGPW-GAR-REF 20,000 20,000 20,000 20,000 20,000 100,000Sub-Total Equipment: PW-Dump Trucks 258,000 258,0002008 TRUCK-9TON-DUMP-TANDEM AXLE PW-HD-519 258,000 258,000Sub-Total Equipment: PW-Emerg. Power 45,000 45,0002008 GENERATORS-TOWABLE PW-GEN-742 45,000 45,0002015 GENERATORS-LIFT STATION PW-GEN-743 0 02009 GENERATORS-FACILITY PW-GEN-744 0 02007 GENERATORS-FACILITY PW-GEN-745 0 02007 GENERATORS-WELLS PW-GEN-746 44,000 44,0002006 GENERATORS-TOWABLE PW-GEN-747 0 02004 GENERATORS-LIFT STATION PW-GEN-748 0 02004 GENERATORS-LIFT STATION PW-GEN-749 0 02003 GENERATORS-LIFT STATION PW-GEN-778 0 02008 GENERATORS-FACILITY PW-GEN-9212 0 02007 GENERATORS-FACILITY PW-GEN-9911 0 02007 GENERATORS-FACILITY PW-GEN-9913 0 44,000 90,000 134,000Sub-Total Equipment: PW-Engineering 0 02018 STAFF CAR EN-396 0 02016 STAFF CAR EN-A111 0 0Sub-Total Equipment: PW-Loaders/Skid Steers 251,500 251,5002007 LOADER-WHEEL PW-HEQ-488 0 02015 PAYLOADER BOOM ATTACHMENT PW-HEQ-488B 0 02015 PAYLOADER BUCKET PW-HEQ-488B 0 02015 PAYLOADER FORKS PW-HEQ-488F 0 02015 PAYLOADER SNOW PLOW AND WING PW-HEQ-488S 62,000 62,0002016 SKID STEER PW-HEQ-501 0 02016 SKID STEER BUCKET PW-HEQ-501B 0 02016 SKID STEER ANGLE BROOM PW-HEQ-501B 0 02016 SKID STEER PALLET FORKS PW-HEQ-501F 0 02016 SKID STEER SNOW PLOW PW-HEQ-501S 87,500 87,5002015 SKID STEER PW-HEQ-502 0 02015 SKID STEER BUCKET PW-HEQ-502B 0 02015 SKID STEER FORKS PW-HEQ-502F 0 02013 72" FLAIL MOWER PW-HEQ-502F 0 02015 SKID STEER GRAPPLE BUCKET PW-HEQ-502G Wednesday, July 10, 2019Page 3Produced Using the Plan-It Capital Planning Software Total2020 2021 2022 2023 2024 Department Category 0 02017 SKID STEER V-PLOW PW-HEQ-502V 0 02015 SKID STEER BUCKET PW-HEQ-781B 0 02015 SKID STEER FORKS PW-HEQ-781F 0 02015 SKID STEER GRAPPLE BUCKET PW-HEQ-781G 0 02011 SKID STEER SNOW BLOWER PW-HEQ-781S 0 02017 SKID STEER V-PLOW PW-HEQ-781V 0 02015 BACKHOE HYDRAULIC BREAKER PW-HEQ-785H 0 02015 BACKHOE PLATE COMPACTOR PW-HEQ-785P 0 02015 PAYLOADER BUCKET PW-HEQ-789B 0 02015 PAYLOADER SNOW PLOW AND WING PW-HEQ-789S 0 339,000 62,000 401,000Sub-Total Equipment: PW-Pick Ups/Vans 150,000 150,0002011 TRUCK-1 TON PW-LD-450 42,500 42,5002013 TRUCK-1 TON PW-LD-457 107,000 107,0002018 TRUCK-1.5TON-DUMP PW-LD-459 31,000 31,0002014 TRUCK-1 TON PW-LD-540 37,500 37,5002011 TRUCK-1/4 TON PW-LD-542 42,500 42,5002013 TRUCK-1 TON PW-LD-543 41,000 41,0002012 TRUCK-1 TON PW-LD-544 60,500 60,5002013 TRUCK-1 TON PW-LD-545 62,000 62,0002014 TRUCK-1 TON PW-LD-547 68,000 68,0002014 TRUCK-1 TON PW-LD-548 106,000 106,0002002 TRUCK-BOOM PW-LD-549 40,000 40,0002012 TRUCK-1 TON PW-LD-751 95,000 95,0002011 TRUCK-1.5TON-DUMP PW-LD-756 82,500 82,5002009 TRUCK-1 TON PW-LD-762 42,500 42,500TRUCK-1.5TON PW-LD-NEW 257,000 122,500 322,000 145,500 161,000 1,008,000Sub-Total Equipment: PW-Street/Sidewalk 0 02002 INFRARED PATCHER PW-STR-2016 30,000 30,0002012 INFRARED PATCHER PW-STR-429 0 02013 ASPHALT MILL PW-STR-430 31,000 31,0002003 ROUTER PW-STR-454 8,500 8,5002003 CRACK SEALER PW-STR-473 29,000 29,0002016 ASPHALT ROLLER PW-STR-474 155,500 155,5002009 SIDEWALK MACHINE PW-STR-506 0 02015 HOLDER ANGLE BROOM PW-STR-506B 0 02015 HOLDER SANDER PW-STR-506S 0 02014 HOLDER SNOW BLOWER PW-STR-506S 0 02015 HOLDER V-PLOW PW-STR-506V 0 30,000 195,000 29,000 254,000Sub-Total Equipment: PW-Trailers 11,500 11,5002000 TRAILER PW-TRL-479 12,500 12,5002011 TRAILER PW-TRL-480 13,500 13,5002008 TRAILER PW-TRL-531 13,500 13,5002008 TRAILER PW-TRL-532 7,000 7,0002012 TRAILER PW-TRL-533 31,000 31,000TRAILER SAFETY SIGN PW-TRL-NEW Wednesday, July 10, 2019Page 4Produced Using the Plan-It Capital Planning Software Total2020 2021 2022 2023 2024 Department Category 58,000 24,000 7,000 89,000Sub-Total Equipment: PW-Tree Care 0 02008 66" TREE SPADE PW-TREE-509 40,000 40,0002012 WOODCHIPPER PW-TREE-510 0 40,000 40,000Sub-Total Equipment: PW-Turf Care 4,500 4,5002014 MOWER WALK BEHIND PW-MOW-151 111,500 111,5002016 MOVER-16FT PW-MOW-503 131,500 131,5002009 TRACTOR PW-MOW-505 0 02013 TRACTOR SNOW BLOWER PW-MOW-505 0 02016 TRACTOR SNOWPLOW PW-MOW-505 122,000 122,0002012 TRACTOR PW-MOW-507 0 02015 TRACTOR LOADER BUCKET PW-MOW-507 0 02015 TRACTOR LOADER FORKS PW-MOW-507 0 02015 TRACTOR LOADER PW-MOW-507 0 02015 TRACTOR FRONT MOUNT SNOW BLOWER PW-MOW-507 46,000 46,0002012 MOWER-6FT PW-MOW-523 38,000 38,0002015 MOWER-6FT PW-MOW-524 39,500 39,5002016 MOWER-6FT PW-MOW-525 39,500 39,5002016 MOWER-6FT PW-MOW-526 19,000 19,0002013 UTILITY VEH-STRIPER PW-MOW-535 27,500 27,500MOWER-6FT PW-MOW-NE 29,000 29,000MOWER-6FT PW-MOW-NE 46,000 131,500 149,500 57,000 224,000 608,000Sub-Total Equipment: PW-Utility Equp. 0 0MN DNR PORTABLE 10" PUMP PW-UTIL-741 0 02013 EASEMENT JETTER PW-UTIL-770 0 0Sub-Total 642,000 738,000 739,000 476,000 502,000 3,097,000Department Total: 1,091,000 1,748,000 1,082,000 892,000 799,000 5,612,000GRAND TOTAL Wednesday, July 10, 2019Page 5Produced Using the Plan-It Capital Planning Software CITY OF PRIOR LAKE Council Workshop 7.15.2019 2020-2029 TRANSPORTATION PLAN Year Improvement Project Type Length Pavement Utility MSA Street Tax Bond Assessments Water Sewer Stormwater/Watermain Sanitary Storm Grant or Other Total City Municipal County State Federal TOTAL PROJECT Miles OCI*OCI*Oversizing Levy Type Utility Fund Utility Fund Water Quality Trunk Fund Trunk Fund Trunk Fund Contribution Cost Cost Cost Cost Cost COST - 2020 CSAH 42 (CR83 to CR17)Partnership NA 389,500 - 155,600 475 - - 60,000 - - 605,100 - - - - 605,100 2020 Project Totals 0 389,500$ -$ 155,600$ -$ -$ -$ -$ -$ 60,000$ -$ -$ 605,100$ -$ -$ -$ -$ 605,100$ 2021 Hidden Oaks/Timberview/Timber (1986)Pavement/Recon 0.4 22 39 - - 806,400 429 345,600 485,000 121,000 136,000 - - - - 1,894,000 - - - - 1,894,000 2021 Millers/Omega/Glory (1982)Pavement/Rehab 0.31 25 79 - - 435,000 429 290,000 41,340 - - - - - 766,340 - - - - 766,340 2021 Fish Point Road (CR 44 to TH 13)Pavement/Recon 0.66 22 40 1,200,000 - 510,000 429 1,140,000 725,000 350,500 220,000 - - - - 4,145,500 - - - - 4,145,500 2021 Colorado Street (Arcadia to Main)Pavement/Recon 0.14 189,400 429 188,000 105,500 81,000 93,000 656,900 656,900 2021 Colorado Street Parking Lot Partnership NA 158,000 429 158,000 162,000 320,000 2021 Inguadona/Roosevelt/Ramsey/Green Hts Trail/Park (private)Pavement/Recon 0.59 475 801,000$ 944,000$ 171,000$ 1,916,000 - - - - 1,916,000 2021 Pershing/Dunkirk/Dutch/Roanoke/Green Hts/Spring (1985)Pavement/Recon 0.76 26 34 - - 1,490,000 429 760,000 739,000 686,000 280,000 - - - - 3,955,000 - - - - 3,955,000 2021 Park Avenue (1985)Pavement/Recon 0.14 24 78 - - 193,000 429 132,000 300,000 200,000 - - - 825,000 - - - - 825,000 - - - - - - - - - - 2021 Project Totals 3 1,200,000$ -$ 3,781,800$ 2,855,600$ 3,196,840$ 2,382,500$ 900,000$ -$ -$ -$ -$ 14,316,740$ -$ 162,000$ -$ -$ 14,478,740$ 2022 Northwood Road (Fremont to Knollridge) (1994)Pavement/Rehab 0.52 29 84 - - 797,000 429 531,500 - - - - - - - 1,328,500 - - - - 1,328,500 2022 Northwood Road (Knollridge to CSAH 12) (1994)Pavement/Recon 0.6 16 79 484,000 - 1,950,000 475 300,000 281,000 74,000 240,000 - - - - 3,329,000 - - - - 3,329,000 2022 Knollridge/Hawk Ridge/Viewcrest (1998) Lake Haven/Shady Cove/Lake Bluff(2000)Fremont Cir/Fremont St/Crystal (1986)Pavement/Rehab NA 37 85 - - 251,000 429 120,000 - - - - - - - 371,000 - - - - 371,000 2022 Frost Point Circle (1974)Pavement/Recon 0.17 24 35 - - 370,000 429 270,000 238,000 169,400 68,000 - - - - 1,115,400 - - - - 1,115,400 2022 Project Totals 1.29 484,000$ -$ 3,368,000$ 1,221,500$ 519,000$ 243,400$ 308,000$ -$ -$ -$ -$ 6,143,900$ -$ -$ -$ -$ 6,143,900$ 2023 Martindale/Henning Circle/Hickory Lane Pavement/Rehab 0.6 487,000$ 429 325,000$ 812,000 812,000 2023 Lakeside Avenue (CR21 to Pleasant)Pavement/Recon 0.34 536,000$ 429 415,280$ 300,000$ 230,000$ 262,000$ 1,743,280 1,743,280 2023 Colorado (Duluth to Arcadia)Pavement/Recon 0.08 132,000$ 429 102,080$ 75,000$ 56,320$ 65,000$ 430,400 430,400 2023 Duluth (CR21 to TH13)Pavement/Recon 0.43 668,000$ 429 522,000$ 374,400$ 288,000$ 330,000$ 2,182,400 2,182,400 - - - - - - - - - - - - 2023 Project Totals 1.45 -$ -$ 1,823,000$ 1,364,360$ 749,400$ 574,320$ 657,000$ -$ -$ -$ -$ 5,168,080$ -$ -$ -$ -$ 5,168,080$ 2024 Raspberry Ridge/Hidden Pond/Black Oak/Timberglade (1987)Pavement/Recon 0.6 23 975,000$ 429 400,000$ 1,200,000$ 202,500$ 300,000$ 3,077,500 2024 Appaloosa Trail/Highland Ct (1996)Pavement/Rehab 0.31 29 141,663$ 429 94,442$ 236,104 2024 Island View Cir/Island View Rd/Island Circle (1977)Pavement/Recon 0.84 20 1,195,720$ 429 797,147$ 500,900$ 680,000$ 350,000$ 3,523,767 - - - - - - - - - - - 2024 Project Totals 1.75 -$ -$ 2,312,382$ 1,291,588$ 1,700,900$ 882,500$ 650,000$ -$ -$ -$ -$ 6,837,371$ -$ -$ -$ -$ -$ 2025 Street Reconstruction Non-Specific Pavement/Recon 1.5 500,000 - 1,420,000 429 355,000 - - - - 2,275,000 - - - - 2,275,000 2025 Project Totals 1.5 500,000$ -$ 1,420,000$ 355,000$ -$ -$ -$ -$ -$ -$ -$ 2,275,000$ -$ -$ -$ -$ 2,275,000$ 2026 Street Reconstruction Non-Specific Pavement/Recon 1.5 - - 1,900,000 429 1,620,000 825,000 634,000 375,000 - - - - 5,354,000 -$ -$ -$ -$ 5,354,000 2026 Project Totals 1.5 -$ -$ 1,900,000$ 1,620,000$ 825,000$ 634,000$ 375,000$ -$ -$ -$ -$ 5,354,000$ -$ -$ -$ -$ 5,354,000$ 2027 Street Reconstruction Non-Specific Pavement/Recon 1.5 - - 1,618,800 429 405,000 - - - - 2,023,800 -$ -$ -$ -$ 2,023,800 2027 Project Totals 1.5 -$ -$ 1,618,800$ 405,000$ -$ -$ -$ -$ -$ -$ -$ 2,023,800$ -$ -$ -$ -$ 2,023,800$ 2028 Street Reconstruction Non-Specific Pavement/Recon 1.5 500,000 - 2,166,000 429 1,850,000 941,000 725,000 428,000 - - - - 6,610,000 -$ -$ -$ -$ 6,610,000 2028 Project Totals 1.5 500,000$ -$ 2,166,000$ 1,850,000$ 941,000$ 725,000$ 428,000$ -$ -$ -$ -$ 6,610,000$ -$ -$ -$ -$ 6,610,000$ 2029 Street Reconstruction Non-Specific Pavement/Recon 1.5 - 1,850,000 429 462,000 - - - - - - - 2,312,000 -$ -$ -$ -$ 2,312,000 2029 Project Totals 1.5 -$ -$ 1,850,000$ 462,000$ -$ -$ -$ -$ -$ -$ -$ 2,312,000$ -$ -$ -$ -$ 2,312,000$ Program Totals 3,073,500$ -$ 20,395,582$ -$ 11,425,048$ 7,932,140$ 5,441,720$ 3,318,000$ -$ 60,000$ -$ -$ 51,645,991$ -$ 162,000$ -$ -$ 44,970,620$ CITY OF PRIOR LAKE Council Workshop 07/15/2019 2020 - 2029 WATER OPERATING PLAN 2020-2029 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Totals Use of Funds: Operations & Maintenance 2,135,718$ 2,242,504$ 2,354,629$ 2,472,361$ 2,595,979$ 2,725,778$ 2,862,066$ 3,005,170$ 3,155,428$ 3,313,200$ 25,577,733 Capital Projects 170,103 4,353,767$ 689,082$ 916,387$ 2,972,577$ 177,560$ 1,006,392$ 186,423$ 1,133,576$ 197,853$ 13,312,693 Interfund Transfer 369,110 378,170$ 387,420$ 396,850$ 406,480$ 416,300$ 426,330$ 436,570$ 447,030$ 457,710$ 4,014,480 Debt Service 728,500 740,170$ 749,300$ 779,870$ 785,085$ 793,962$ 793,807$ 799,533$ 811,300$ 646,217$ 7,710,712 Total Use of Funds 3,403,432 7,714,611 4,180,430 4,565,468 6,760,121 4,113,600 5,088,595 4,427,696 5,547,334 4,614,980 50,615,618 Source of Funds: Water Usage Charge 4,428,971 4,700,047 4,987,449 5,286,984 5,604,344 5,940,573 6,296,774 6,674,112 7,073,821 7,497,202 55,064,579 Special Utility Billing District 50,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 850,000 Other Revenues 130,000 132,600 135,252 137,957 140,716 143,531 146,401 149,329 152,316 155,362 1,383,102 Bond Proceeds - - - - - - - - - - 0 Trunk Fund Contribution - - - - - - - - - - 1,188,000 Total Source of Funds 4,608,971 4,932,647 5,222,701 5,524,941 5,845,060 6,184,104 6,543,175 6,923,441 7,326,136 7,752,564 58,485,680 Change in Fund Balance 1,205,539$ (2,781,964)$ 1,042,271$ 959,473$ (915,060)$ 2,070,504$ 1,454,580$ 2,495,745$ 1,778,802$ 3,137,584$ 7,870,062$ Beginning Fund Balance 3,860,154$ 5,065,693$ 2,283,729$ 3,326,000$ 4,285,474$ 3,370,414$ 5,440,917$ 6,895,497$ 9,391,242$ 11,170,045$ Ending Fund Balance 5,065,693$ 2,283,729$ 3,326,000$ 4,285,474$ 3,370,414$ 5,440,917$ 6,895,497$ 9,391,242$ 11,170,045$ 14,307,629$ CITY OF PRIOR LAKE Council Workshop 07/15/219 2020 - 2029 SANITARY SEWER OPERATING PLAN 2020-2029 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Totals Use of Funds: Operations & Maintenance 1,140,544$ 1,174,760$ 1,210,003$ 1,246,303$ 1,283,692$ 1,322,203$ 1,361,869$ 1,402,725$ 1,444,807$ 1,488,151$ 13,075,059 MCES Fees 1,752,922 1,901,228 2,061,707 2,233,167 2,418,528 2,618,898 2,835,468 3,069,526 3,322,458 3,595,760 25,809,661 Capital Improvement Projects 225,707 2,596,899 472,908 1,026,776 1,366,780 517,391 1,182,548 581,004 1,338,684 271,595 9,580,292 Interfund Transfer 294,110 301,170 308,420 315,850 323,480 331,300 339,330 347,570 356,030 364,710 3,281,970 Debt Service 174,450 349,013 349,213 349,213 349,013 343,613 341,863 344,863 347,363 179,363 3,127,964 Total Use of Funds 3,587,733 6,323,070 4,402,251 5,171,309 5,741,493 5,133,405 6,061,078 5,745,688 6,809,342 5,899,579 54,874,947 Source of Funds: Wastewater Collection Revenue 4,294,716 4,638,582 5,010,341 5,406,959 5,835,430 6,298,290 6,798,271 7,338,321 7,921,618 8,551,589 62,094,118 Special Utility Billing District 50,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 950,000 Other Revenues 15,606 15,918 16,236 16,561 16,892 17,230 17,575 17,926 18,285 18,651 170,881 Interfund Transfer Bond Proceeds 1,500,000 - - - - - - - - - 1,500,000 Total Source of Funds 5,860,322 4,754,500 5,126,577 5,523,520 5,952,323 6,415,520 6,915,846 7,456,248 8,039,903 8,670,240 64,714,999 Change in Fund Balance 2,272,589$ (1,568,570)$ 724,327$ 352,211$ 210,829$ 1,282,116$ 854,768$ 1,710,560$ 1,230,561$ 2,770,661$ 9,840,052$ Beginning Fund Balance 1,500,139$ 3,772,727$ 2,204,157$ 2,928,484$ 3,280,695$ 3,491,524$ 4,773,640$ 5,628,408$ 7,338,968$ 8,569,529$ Ending Fund Balance 3,772,727$ 2,204,157$ 2,928,484$ 3,280,695$ 3,491,524$ 4,773,640$ 5,628,408$ 7,338,968$ 8,569,529$ 11,340,191$ CITY OF PRIOR LAKE Council Workshop 07/15/219 2020-2029 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Totals Use of Funds: Operations & Maintenance 745,017$ 658,560$ 677,585$ 697,194$ 717,403$ 738,233$ 759,703$ 781,833$ 804,643$ 828,155$ 7,408,326$ Capital Projects 75,000 1,025,000 368,000 802,000 683,000 250,000 695,000 100,000 428,000 100,000 4,526,000 Total Use of Funds 820,017 1,683,560 1,045,585 1,499,194 1,400,403 988,233 1,454,703 881,833 1,232,643 928,155 11,934,326 Source of Funds: Interest Earnings (1.5%)7,851$ 7,693$ 11,202$ 4,536$ 6,537$ 3,464$ 2,360$ 7,112$ 6,794$ 14,508$ 72,057$ Charges for Services 1,092,908 1,142,581 1,194,511 1,248,802 1,305,560 1,364,897 1,426,932 1,491,786 1,559,588 1,630,471 13,458,036 Grants - - - - - - - - - - - Total Source of Funds 1,100,759 1,150,273 1,205,713 1,253,338 1,312,097 1,368,362 1,429,293 1,498,900 1,566,385 1,644,983 13,530,103$ Change in Fund Balance 280,742$ (533,286)$ 160,128$ (245,856)$ (88,306)$ 380,128$ (25,410)$ 617,067$ 333,742$ 716,828$ 1,595,777$ Beginning Fund Balance 615,408$ 896,150$ 362,863$ 522,991$ 277,135$ 188,829$ 568,957$ 543,546$ 1,160,612$ 1,494,351$ Ending Fund Balance 896,150$ 362,863$ 522,991$ 277,135$ 188,829$ 568,957$ 543,546$ 1,160,612$ 1,494,351$ 2,211,175$ 2020 - 2029 WATER QUALITY OPERATING PLAN