Loading...
HomeMy WebLinkAbout01(A) - 2023-2027 CIP Presentation City of Prior Lake | 4646 Dakota Street SE | Prior Lake MN 55372 CITY COUNCIL AGENDA REPORT ITEM: 1A MEETING DATE: July 18, 2022 PREPARED BY: Jason Etter, Nicole Klekner and Cathy Erickson PRESENTED BY: Cathy Erickson AGENDA ITEM: Draft 2023-2027 Capital Improvement Program GOAL AREA OBJECTIVE: High-Value City Services 2. Design a comprehensive funding strategy for capital needs. RECOMMENDED ACTION: The Council is asked to provide comments on the draft Capital Improvement Program (CIP) so the CIP process can proceed on schedule. The CIP plans are as follows: • Equipment Replacement Plan • Park Plan • Facilities Management Plan • Pavement Management Plan (transportation and street overlay projects) • Technology Plan • Water Financial Plan • Sanitary Sewer Financial Plan • Water Quality Financial Plan This work session will also include the financial analysis of the CIP plans. The draft summary documents have been included for City Council review. The supporting documentation for each plan is available if needed. BACKGROUND: The CIP has become our most important and impactful financial planning tool for the following reasons: • It sets forth the actions the City intends to take (alone or with others) to restore, build or replace city infrastructure • It is a multi-year document which divides the financial planning focus over nine key infrastructure systems Staff strives to be consistent in the update of each of the plans by using the following methodologies: • Replacement year for existing assets is based on the expected useful life of the asset • Replacement value is based on a current estimated replacement cost inflated appropriately to the scheduled replacement year • Replacement is evaluated each year based on the condition, safety and maintenance needs of the asset, and the CIP is adjusted accordingly Item 1A Page | 2 FULL-TIME FIRE STAFFING MODEL – CIP IMPACTS: As discussed at the June 6 financial planning Council work session, the city has applied for the federal SAFER grant that would fund 100% of the new full-time fire personnel wages and benefits for three years (2023-2025). The firefighter grant funding will only be available for three years, so staff is proposing to incrementally increase the tax levy to prepare for the city fully funding the firefighters in 2026. This would be done through an annual transfer out of the General Fund. Since this funding is in preparation of our 2026 needs, it will be used for capital project funding until needed in 2026 for personnel funding. By doing this, the city will pay for capital purchases on a pay go basis, instead of issuing debt. This will help us minimize future bond issues. The phased tax levy increase and the capital project cost it will fund is shown in the table below: EQUIPMENT REPLACEMENT PLAN (ERP) An evaluation of the condition of the City’s fleet is completed annually and the ERP is updated. A Cartegraph Vehicle Replacement Rating (VRR) is used as a tool in completing equipment evaluations in an objective and systematic way using data collected through the fleet management system. The ERP also includes an inventory and replacement schedule for equipment attachments and the emergency sirens to ensure appropriate funding is identified for these items as well. The cost for these items is updated annually based on recent purchases and other industry changes. See Attachments 1 and 2 for more details. Public Works – Proposed new additions to the fleet: • Two 6-foot mowers (2023 and 2024) – These mowers are proposed additions to the fleet to supplement the four current mowers in service. The 6-foot mowers are used for city facilities, boulevards (both city and county), and non-athletic parks. The proposed additions of these mowers are in anticipation of continued expansion of the city park system and will also support a return to previous service levels. These additions will also provide redundancy for down-time with any of the existing lawn mowers. The 2023 mower is proposed to be a Toolcat mower that can be used year- round for plowing sidewalks as well as mowing. It’s a more versatile and faster machine than a traditional mower. • 1-ton pickup w/plow (2024) – This is a proposed addition to the fleet that will be utilized for asphalt maintenance, utility work, snow plowing and general staff transportation. Currently staff utilizes a variety of former squad cars and UTVs for some transportation. • 1.5-ton pickup w/dump box (2025) – This is a proposed addition to the fleet that will be utilized for parks maintenance, landscaping, field maintenance, and transportation 2023 2024 2025 2026 Year 1 Transfer Out Expenditure for Street Project - Marsh Drive NE Ext.400,000 Year 2 Transfer Out Expenditure for Facilities Capital Maintenance 500,000 Year 3 Transfer Out Expenditure for Equipment - Fire Ladder Truck - 300,000 1,200,000 Year 4 Firefighter personnel costs 1,600,000 Total Expenditures 400,000 800,000 1,200,000 1,600,000 Phased Tax Levy Increase to fund firefighters by 2026 400,000 400,000 400,000 400,000 Item 1A Page | 3 of staff. Currently staff utilizes a variety of former squad cars, UTVs and lawnmowers for transportation. Fire – FD CIP includes three broad categories: Fire Apparatus: This group includes the heavy rescue, pumper, and ladder trucks. Equipment of this nature has an estimated 20-year useful life. Historically, this type of equipment has been kept 25-28 years, which has resulted in significant repair costs and ongoing safety evaluation as the equipment exceeds its useful life. Fire First Response: This includes the fire department pickups, SUVs and grass rigs which are on a replacement schedule based on the useful life of the asset. The replacement is evaluated each year based on the condition, safety, and maintenance needs of the vehicles. Fire – Other Equipment: This includes all other capital items necessary to provide fire response and protection services. It includes items such as staff radios, utility vehicles, generators, etc. The Fire department is currently replacing their radios over the course of four years (2020 - 2023). The radios were originally purchased in 2004 and are no longer supported by Motorola. Police – PD CIP includes three broad categories: Police Fleet: This includes the Police department vehicles which are on a replacement schedule based on the useful life of the asset. The replacement is evaluated each year depending on the condition, safety, and maintenance needs of the vehicles. Emergency Sirens: The Prior Lake Police Department is the Emergency Manager (EM) for the city. As part of the EM duties, staff manages the replacement and maintenance of the emergency warning sirens. In 2023, three of the city’s twelve sirens are due to be replaced. Police - Other Equipment: This includes all other capital items necessary to provide Police services, such as radios and generators. Funding Sources: Based on the planned use of funds for equipment replacement, the annual tax levy needs to increase to meet our needs. Council has directed staff to smooth the levy increase where possible, so an annual increase of approx. $50,000 has been built into the plan. Our goal is to maintain the levy at a level that provides adequate cash flow to cover the next year’s expenditures, to absorb any unplanned equipment failure, or to fund an unanticipated equipment need. Our average annual equipment funding need is $1.47 million per year over the next 10 years. We strive to only bond for Fire apparatus replacements and fund all other equipment purchases on a pay go basis. Our annual equipment pay go funding need is approximately $1,500,000 per year. The proposed funding level for 2023 is $975,000. This includes a tax levy of $750,000 plus transfers in from the utility funds of $217,500. We will continue to incrementally increase the property tax levy to get to our annual funding goal. As discussed above, the Equipment CIP includes transfers in from the General fund of $1,500,000 to pay for the Fire ladder truck on a pay go basis instead of debt issuance. The major equipment purchases greater than $100,000 and all new additions are summarized below. Item 1A Page | 4 2023 Public Works Sidewalk Machine $165,000 Public Works 6-foot Toolcat Mower (NEW add) $90,000 Fire Rescue Unit $200,000 Police Marked Squad (NEW add) $45,500 2024 Public Works 16-foot Mower $155,000 Public Works Tractor $135,000 Public Works 1-ton Pick-up w/Plow (NEW add) $54,000 Public Works 6-foot Mower (NEW add) $45,000 2025 Public Works Mechanical Sweeper $250,000 Public Works Loader Backhoe $177,000 Public Works 1.5-ton dump (NEW add) $125,000 Police Marked Squad (NEW add) $48,000 Police Bearcat $375,000 Fire Ladder Truck $1,500,000 2026 Public Works Wheel Loader $275,000 2027 Public Works 1.5-ton dump $103,000 Public Works 5-ton single axle dump $247,000 Public Works 16-foot mower $155,000 Police Marked squad (NEW add) $50,000 See Attachments 1 and 2 for more details. PARK PLAN New park capital improvements are budgeted in the Capital Park Fund (Fund 225). Existing park capital improvements are budgeted in the Revolving Park Equipment Fund (Fund 430). The purpose of the draft Park Master Plan is to look at current parks and proposed changes/updates as well as the City’s future needs and location of new parks. Based on the current draft Park Master Plan, staff has developed a proposed 10-year plan for improvements in existing neighborhood parks which includes both maintenance activities and proposed replacement/redevelopment. Funding Shortfall: The estimated annual funding shortfall in the 10-year Park Plan for neighborhood park renovations, major equipment replacement, and trail maintenance is $450,000 to $500,000 per year. It is anticipated that following the adoption of the DRAFT Parks and Trails Master Plan, and as part of the Council’s 2023 Strategic Planning work, strategies for the future funding of park needs will begin to be developed. Unfunded Projects of the Park Master Plan: Item 1A Page | 5 • All proposed neighborhood park renovation projects • Funding for proposed city dock replacements at Sand Point and Watzl’s • Ponds Outfield Fencing • Additionally, there is currently no funding plan for Sand Point Beach and Lakefront Park proposed major renovations. Fund 225 – New park improvements In accordance with State Statutes, revenues in the Capital Park Fund may only be used for the acquisition and development or improvement of parks, recreational facilities, playgrounds, trails, wetlands, or open space based on the approved park systems plan. Future trail and neighborhood park development is shown to occur in 2023 and 2026. See Attachment 3 and 5. Fund 430 – Existing park improvement This plan funds capital replacement projects, park amenities, and trail, sidewalk, and boardwalk replacement. The plan proposes a phased increase in the tax levy to cover the capital projects in the plan. See Attachments 4 and 5. The proposed improvements for the next five years include: 2023 Northwood Meadows BB court maintenance $10,000 Ponds Phase 1 (north ½ of wheel) $700,000 Ponds Playground replacement $350,000 Sand Point Park Backstop $10,000 Sand Point Beach Renovation study $75,000 Wilds North BB court maintenance $10,000 TOTAL $1,155,000 2024 Ryan BB court maintenance $15,000 Timbercrest BB court maintenance $10,000 Wilds BB court maintenance $15,000 TOTAL $40,000 2025 Ponds Phase 2 (south ½ of wheel) $800,000 Wilds Parkway Trail replacement $800,000 TOTAL $1,600,000 2026 Cardinal Ridge Parking lot improvements $45,000 Grainwood Crossing Parking lot improvements $5,000 Memorial Parking lot improvements $250,000 Location TBD Playground replacement $250,000 TOTAL $550,000 2027 Crystal Lake Fishing pier $22,000 Item 1A Page | 6 Enclave BB court maintenance $15,000 Howard Lake BB court maintenance $15,000 Memorial Drinking fountain and windscreen $19,000 Woodridge Ballfield backstop $10,000 Location TBD Playground replacement $250,000 TOTAL $331,000 FACILITY MANAGEMENT PLAN (FMP) The FMP was developed to plan for major repairs, replacements, and upgrades for all our facilities. The FMP uses standard life expectancy of the facility components and equipment to determine the appropriate placement in the plan. See Attachments 6 and 7 for more details. The major expenditures are summarized below. The 2023-2027 Personnel Plan includes staff additions for Police and Fire, including the implementation of the Full-time Fire staffing model. Additional costs to support these staffing changes include: • Fire Station #1: Duty crew renovation • Police Station: With the projections of the current personnel plan, we will be running out of parking in our underground facility. The PD owned vehicles would continue to be parked inside but we will need some additional parking for staff that work 24/7. It is an industry standard to have secured employee parking for PD. As discussed above, the Facilities Management CIP includes transfers in from the General fund of $500,000 to pay for planned 2024 roof replacement costs at City Hall and the Police Station on a pay go basis instead of debt issuance. The major equipment purchases and all new additions are summarized below. 2023 City Hall Wall coverings $70,000 Police Overhead folding door, irrigation system, carpet $233,000 Library/CP Remodel – Phase 2 $125,000 Fire 1 Irrigation system, vehicle exhaust system $115,500 Fire 2 Carpet, infrared tube heater $70,000 TOTAL $613,500 2024 City Hall Membrane roofing, irrigation system $283,500 Police Station Membrane roofing $310,000 Library/CP VAV boxes $17,500 Maintenance Center Overhead crane, auto gate $121,000 Fire 1 Wall coverings, turnout lockers, glass doors, tile walls, exhaust fan, damper $104,600 Fire 2 Furnace and AC units (3 each) $60,000 TOTAL $896,600 2025 Police Outdoor secure parking, fencing $300,000 Item 1A Page | 7 Library/CP Parking lot improvements $300,000 Fire Station 1 Rooftop Unit $147,500 TOTAL $747,500 2026 City Hall VAV boxes, doors, flooring, tile, HVAC, carpet, etc. $1,194,500 Police VAV boxes, doors, HVAC, etc. $428,000 Maintenance Center Windows, hoists, etc. $301,500 Fire 2 Membrane roofing $112,000 TOTAL $2,036,000 2027 Police Epoxy flooring $85,000 Library/CP HVAC control system, air handling unit $228,500 Maintenance Center Concrete flooring $209,500 Fire 2 HVAC improvements $95,000 TOTAL $618,000 PAVEMENT MANAGEMENT PLAN – TRANSPORATION AND STREET OVERLAY PLANS The proposed 2023-2027 Pavement Management Plan include the following projects that have been previously discussed with the City Council. 2023 – Fish Point Road Phase II The Fish Point Road Phase II project includes the full street and utility reconstruction of Fish Point Road from 160th Street to TH 13. 2023 – CH 21/Revere Way Intersection Improvements This project includes extending Revere Way north of CH 21 to 170th Street and eliminating the existing 170th Street/CH 21 intersection. The project costs will be shared with Scott County, but the City will be the lead agency for design and project administration. 2023 – Marsh Rd NE Extension With the recent construction of the Pike Lake Landing development north of CH 42 and east of CH 21, Marsh Drive is constructed from CH 21 east approximately 0.30 miles. As a collector road within the city’s transportation plan, Marsh Drive is planned to connect to the existing segment at Pike Lake Trail, ultimately continuing east through the Vierling property to CH 18. The developer of the Pike Lake Landing development has expressed interest in developing additional property that provides an opportunity for the city to complete the connection to Pike Lake Trail. The completion of this connection requires an estimated $800,000 in city funding for the portion of Marsh Drive that would be constructed through city property. Currently city funding in the amount of $400,000 from the General Fund is identified and funding sources for the remaining $400,000 are being evaluated. As a supporting road to CH 42 as a principal arterial, the county has indicated a willingness to evaluate some level of county funding to facilitate the completion of this road connection as a vital part of the long-term overall transportation network in this area The Pavement Management Plan has been updated to identify a combination of mill and overlay, rehabilitation and reconstruction projects based on an average annual funding level of $7.4M for streets beginning in 2024. This is based on the updated Pavement Management Plan completed in 2021 that Item 1A Page | 8 corresponds with the Council’s adoption of an increase in franchise fees with the new franchise fee revenue being dedicated to pavement management. The projected projects for 2024 – 2027 are noted below: 2024 – Wilds/Jeffers mill and overlay (12.5 miles) The majority of the streets within the Wilds and Jeffers Developments based on age and condition are candidates for mill and overlay improvements to extend the life of the pavement. Included within the estimated project cost for these improvements is the replacement of bolts on all watermain fittings and valves due to noted corrosive soil conditions within these developments that has led to premature failures. 2025 – Wilds Parkway reclamation Based on the existing condition of Wilds Parkway, a mill and overlay is not a feasible pavement management strategy. A full-depth removal and replacement of the road and pavement section is proposed as a rehabilitation project. Also included with this project is the replacement of the existing trail along the west side of Wilds Parkway from CH 82 to CH 83. 2025 – Lords Street Bridge Rehabilitation Based on a recent bridge inspection completed by Scott County and additional follow up this past winter, rehabilitation and replacement of the timber pier caps, pile cap plates, and painting of the pilings is recommended to extend the life of the bridge. 2025 – Martindale/Henning/Hickory Reclamation The existing pavement within this rural residential neighborhood continues to deteriorate and nearing the point where maintenance is becoming unfeasible. A full-depth pavement rehabilitation is proposed for this area to extend the life of the pavement section. 2026 – Northwood Phase 1 2027 – Northwood Phase 2 See Attachments 8-10 for further detail of the Pavement Management Program. TECHNOLOGY PLAN The Technology Plan is used to plan for current and long-range IT capital needs including general equipment, network infrastructure and software needs. While this plan is reflective of the needs of our various departments, the actual request could change as part of the budget review process. See Attachment 11. UTILITY FUNDS – FINANCIAL MANAGEMENT PLANS The City’s utility funds finance their portions of the Capital Improvement Program through transfers-out to other funds and by transactions occurring within the specific utility funds themselves. The Utility funds make transfers-out for the Equipment Replacement Plan (ERP) and Facilities Management Plan (FMP) for their portions of equipment purchases or facility projects. Similarly, the Utility funds make transfers-out to the Construction Fund for their portions of the Pavement Management Plan (PMP) projects. Other items that specifically relate only to that utility are accounted for within the fund, such as a water tower rehabilitation occurring in the Water fund. The City develops a financial management plan for each utility fund that includes planning financing sources for capital activities. Item 1A Page | 9 The financial management plans for water, sewer and stormwater utility services achieve the following goals: • Rate Calculation: Provide for a rate calculation that results in equitable and competitive fixed versus variable portion charge to customers and considers conservation impact of tiers and block rates. • Revenue Sufficiency: Focus on revenue sufficiency to provide cash balances that support the following objectives: o Revenue to meet current and future obligations o Avoid future debt issuance consistent with City objectives o Cash on-hand to provide: • Three-months of operating expense • Following-year debt service payments • Following year capital acquisition (planned to be paid from cash) • Reserves for replacement of infrastructure located under private streets • Reserves for future capital improvements 2023 Resident Impact and Sample Bill: The City plans for modest annual increases in utility rates to accomplish the objectives discussed above while moderating the effects on utility users. Based upon the City’s current estimates, utility customers will experience increases of 2.0% - 4.0% per year. In order for the utility funds to support operations and their respective portions of the Capital Improvement Program, the City proposes a Water rate increase of 1.5%, Sewer rate increase of 2%, and Stormwater rate increase of 11.5%. Increase in stormwater fee is due to the decision in 2021 to add storm sewer replacement costs on reconstruction projects to the stormwater utility fund (previously were part of the general levy and assessment cost), as well as adding $950k in funding in 2024 for regional water quality pond project. It should be noted that City utility bills also include an MCES Fee for Sewer. This fee does not support City operations or the Capital Improvement Plan, but rather is a fee collected by the City from residents to pay the Metropolitan Council’s Environmental Services fee for regional wastewater treatment. The fee will increase 3.5% for 2023, reflecting the increased fee that the Metropolitan Council is charging Prior Lake. This fee increase, as well as the utility rate increases needed to support operations and the Capital Improvement Plan is reflected below. A bi-monthly sample bill showing all utility services, and their projected change from 2022 is shown below: Item 1A Page | 10 The Five-Year Financial Management Plan Cash by Purpose and projected change in rates for the Water, Sewer and Water Quality Funds are shown on Attachment 14, 15, and 16. FINANCIAL IMPACT: In reviewing the 2023-2027 Capital Improvement Program, the City Council should consider the annual tax impact of the scheduled projects. CIP Bonding: The 2023-2027 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 2023-2027 CIP anticipates the following bonding needs: • The five-year Pavement Management Plan includes bonding of $17,383,500 for transportation plan projects and $2,506,000 for street overlay projects. The repayment sources for this bonding include: o Tax levy o Project Special Assessment (The city provides the upfront funding for the special assessment portion via bonding) o MN State Aid – a portion of the annual allocation will be used for debt repayment Water, Sewer & Stormwater - 2023 Proposed High Volume Customer Medium Volume Customer Low Volume Customer Gallons Water Billed for Billing Period 78,000 18,000 8,000 Gallons Sewer Billed for Billing Period 47,000 12,000 7,000 Stormwater REU 1 1 1 2022 Base Fee 54.72$ 54.72$ 54.72$ MCES Fee for Sewer 145.71 37.20 21.70 Tier 1 Volume 60.00 60.00 45.45 Tier 2 Volume 72.00 39.24 - Tier 3 Volume 93.60 - - Tier 4 Volume 489.33 - - Total Fee 915.36$ 191.16$ 121.87$ 2023 Base Fee 57.33$ 57.33$ 57.33$ MCES Fee for Sewer 150.87 38.52 22.47 Tier 1 Volume 61.03 61.03 46.22 Tier 2 Volume 73.23 39.86 - Tier 3 Volume 95.20 - - Tier 4 Volume 497.18 - - Total Fee 934.85$ 196.74$ 126.03$ % Increase 2.1%2.9%3.4% $ Increase 19.48$ 5.58$ 4.15$ Item 1A Page | 11 • Bonding for the following major facility repairs, equipment replacements and water/sewer plan capital projects by year: • Year Major Facility Repairs Equipment Replacements 2023 - - 2024 300,000 - 2025 - - 2026 1,740,000 - 2027 - - The major facility expenditures are for City Hall and Police Station replacement of membrane roofing and heating, ventilation and air conditioning (HVAC) updates. Summary of Projected Debt Balances The chart below reflects the cumulative effect of proposed new debt issued (blue section) and the retirement of existing debt (green section). Based on the proposed projects in the CIP, debt is projected to decrease from $33.8M at the end of 2021 to $31.1M at the end of 2027. As mentioned above, staff is proposing a phased tax levy increase to prepare for full-time firefighters by 2026. Since this funding is in preparation of our 2026 needs, it will be used for capital project debt reduction until needed in 2026 for personnel funding. By doing this, the city will pay for capital purchases of $2.4M on a pay go basis, instead of issuing debt. This minimizes the need for future bond issues (debt). Item 1A Page | 12 Summary of Projected Tax Levy for Debt Service: The chart below shows the projected annual tax levy for debt service. The chart illustrates that debt service remains constant from 2021-2025 at about $3,600,000. Based on the proposed projects in the CIP, debt service increases significantly in 2026 and 2027 due to bonding (debt issuance) for two street projects in 2025 (Wilds Pkwy Reclamation and Martindale Area Street projects) and the 2026 bonding for facility work at City Hall and the Police Station. Both buildings were built in 2006. The significant facility project costs are replacement of VAV Boxes, Chillers, Air Handlers, and Carpet. Debt per capita is estimated to decrease from $1,211 in 2021 to $960 in 2027 based on the current capital projects planned. The city is working to manage its debt load while providing needed capital replacement projects in a growing city. Item 1A Page | 13 Bond Repayment through Debt Service Tax Levy: The impact of the 2023-2027 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 planning to reduce our annual debt levy in 2023 and 2024. We are showing an increase in the annual debt levy in 2022 and 2025. Staff will work with our municipal advisor to review options for structuring the debt to minimize the annual debt service impact. The table below is a summary of the annual projected total CIP tax levy by component. Projected change in total CIP Tax Levy: The table below shows the projected change in the CIP tax levy by component. 2023 2024 2025 2026 2027 Debt: Change in Debt Levy (57,218) (22,062) 176,319 468,784 413,992 Projected Change in Debt Levy2023-2027 CIP 2023 2024 2025 2026 2027 Equipment Revolving Fund 750,000 800,000 850,000 900,000 950,000 Revolving Park Equip Fund 440,000 485,000 535,000 595,000 655,000 Facilities Management Fund 155,000 205,000 255,000 305,000 355,000 Debt Service 3,622,149 3,600,087 3,776,406 4,245,189 4,659,181 Total CIP Tax Levies 4,967,149 5,090,087 5,416,406 6,045,189 6,619,181 2023-2027 CIP Tax Levies: Projected CIP Tax Levy 2023 2024 2025 2026 2027 Equipment Revolving Fund 50,000 50,000 50,000 50,000 50,000 Revolving Park Equip Fund 35,000 45,000 50,000 60,000 60,000 Facilities Management Fund 50,000 50,000 50,000 50,000 50,000 Debt Service (57,218) (22,062) 176,319 468,784 413,992 Total CIP Tax Levies 77,782 122,938 326,319 628,784 573,992 2023-2027 CIP Tax Levies: Projected Change in CIP Tax Levy Item 1A Page | 14 This project debt service levy estimates for years 2023-2027is 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. Based on the current projects in the CIP, staff is not proposing any utility funds debt issuance in 2023-2027. The projected annual debt service for the utility funds is shown below: CIP Impact on Long Range Financial Plan: The financial plan incorporates the debt and tax levy impacts of the Capital Improvement Program. Approval of the CIP does not obligate the City to complete the proposed projects or purchases. The 2023 projects/proposed purchases will be incorporated into the 2023 budget requests for budgeted funds. Further Council approvals may be necessary to comply with state statutes and the city’s purchasing policy. Conclusion: The City has been working over the last several years to document its assets and plan for major maintenance or replacements. As these documents have been refined, the financial impacts of our needs are putting pressure on our funding mechanisms given our current funding levels. The update of the gas and electric franchise fees to $5, starting in 2022, will provide a much-needed funding source for pavement management. Department Heads will be participating in the workshop to provide a summary of the proposed capital purchases in their respective departments. The City Council is asked to provide Staff with comments and input on these components of the draft CIP so that they can be refined in preparation for the public review and approval process. A public presentation before the City Council is scheduled for the proposed CIP on Monday, August 15. RECOMMENDED ACTION: The Council is asked to provide comments on the draft CIP plans presented so the CIP process can proceed as planned. ATTACHMENTS: 1. Attach 1 - F410 2022-2031 Sources and Uses of Funds 2. Attach 2 - F410 2022-2031 Projects by Category and Dept 3. Attach 3 - F225 2022-2031 Sources and Uses of Funds 4. Attach 4 - F430 2022-2031 Sources and Uses of Funds 2023 2024 2025 2026 2027 Water 779,100 784,300 789,000 791,950 801,700 Sewer 169,850 169,650 164,250 162,500 165,500 2023-2027 CIP Projected Debt Service (funded by Utility Fund Revenues) Item 1A Page | 15 5. Attach 5 - Parks 2022-2031 Projects by Category and Dept 6. Attach 6 - F440 2022-2031 Sources and Uses of Funds 7. Attach 7 - F440 2022-2031 Projects by Category and Dept 8. Attach 8 - F501 2022-2031 Sources and Uses of Funds 9. Attach 9 - F450 2022-2031 Sources and Uses of Funds 10. Attach 10 - Pavement Management 2022-2031 Projects and Funding by Dept 11. Attach 11 - Tech Plan 2022-2031 Projects by Category and Dept 12. Attach 12 - Water Fund Cash 13. Attach 13 - Sewer Fund Cash 14. Attach 14 - Stormwater Cash 15. Attach 15 - City Total Projects by Department and Funding Source 2023 2024 2025 2026 2027 Revolving Equipment Fund (F410) Beginning Balance 469,000 73,900 436,150 375,650 361,050 Revenues and Other Fund Sources Revenue Tax Levy 750,000 825,000 875,000 925,000 975,000 Water Fund (F601)108,750 73,500 162,450 0 0 Water Quality Fund (F602)0 0 125,000 0 0 Sewer Fund (F604)108,750 73,500 162,450 0 0 Contributions and Donations 0 0 300,000 0 0 Fire Contract (Spring Lake and Credit River)0 0 0 56,000 56,000 Transfer in from General Fund 0 300,000 1,200,000 0 0 Interest Earnings 10,000 7,000 7,000 7,000 7,000 Total Revenues and Other Fund Sources 977,500 1,279,000 2,831,900 988,000 1,038,000 Total Funds Available 1,446,500 1,352,900 3,268,050 1,363,650 1,399,050 Expenditures and Uses Capital Projects & Equipment Building Inspection (38,000)0 0 0 0 Central Garage (20,000)(20,000)(20,000)(20,000)(20,000) Fire (299,000)(102,000)(1,500,000)(49,500)(47,000) Parks (604,500)(430,000)(50,600)(266,000)(380,500) Police (314,100)(284,750)(690,300)(325,600)(329,000) Streets (97,000)(80,000)(631,500)(341,500)(377,500) Total Expenditures and Uses (1,372,600)(916,750)(2,892,400)(1,002,600)(1,154,000) Change in Fund Balance (395,100)362,250 (60,500)(14,600)(116,000) Ending Balance 73,900 436,150 375,650 361,050 245,050 City of Prior Lake, Minnesota Capital Improvement Program 2023 thru 2027 REVOLVING EQUIPMENT FUND (F410) SOURCES AND USES OF FUNDS Capital Improvement Program City of Prior Lake, Minnesota PROJECTS & FUNDING SOURCES BY DEPARTMENT 2023 2027thru Total20232024202520262027DepartmentProject # Streets: Overlay PIR24-000001 6,570,0006,570,000Wilds/Jeffers Mill and Overlay Franchise Fees 3,204,000 3,204,000 G.O. SA Bonds - Overlay Assessment 470,000 470,000 G.O. SA Bonds - Project Levy 1,046,000 1,046,000 Utility: Water Fund (F601)1,850,000 1,850,000 PIR27-000001 990,000990,000NorthwoodsPhase2MillandOverlay G.O. SA Bonds - Overlay Assessment 285,000 285,000 G.O. SA Bonds - Project Levy 705,000 705,000 7,560,0006,570,000 990,000Streets: Overlay Total Streets: Transportation TRN22-000001 5,998,0005,998,000FishPointRoadPhaseII City MSA Funds 1,355,000 1,355,000 G.O. SA Bonds - Project Assessment 440,500 440,500 G.O. SA Bonds - Project Levy 183,000 183,000 G.O. SA Bonds - Project MSA 3,108,000 3,108,000 Utility: Sewer Fund (F604)330,000 330,000 Utility: Water Fund (F601)581,500 581,500 TRN22-000002 5,567,0005,567,000CSAH21 (Revere to 170th St) County 2,274,000 2,274,000 Developer - Upfront Costs 394,000 394,000 Federal Grant 578,700 578,700 G.O. SA Bonds - Project Assessment 806,000 806,000 Street Oversize Fund (F503)1,514,300 1,514,300 TRN23-000001 800,000800,000MarshDrNEExt City - Unidentified Funding Source 40,000 40,000 Construction Fund (F501)60,000 60,000 County 200,000 200,000 General Fund (F101)400,000 400,000 TIF Fund (F414)100,000 100,000 TRN24-000001 4,925,0004,925,000WildsPkwyReclamation G.O. SA Bonds - Project Assessment 400,000 400,000 G.O. SA Bonds - Project Levy 3,400,000 3,400,000 Revolving Park Equip. Fund (F430)800,000 800,000 Utility: Storm Water Fund (F602)0 0 Utility: Water Fund (F601)325,000 325,000 TRN24-000002 300,000300,000LordsStreetBridgeRehab Franchise Fees 300,000 300,000 TRN24-000003 1,355,0001,355,000Martindale/Henning/Hickory Reclamation G.O. SA Bonds - Project Assessment 105,000 105,000 G.O. SA Bonds - Project Levy 1,100,000 1,100,000 Utility: Storm Water Fund (F602)150,000 150,000 TRN25-000001 10,163,00010,163,000NorthwoodPhase1 Franchise Fees 1,948,000 1,948,000 G.O. SA Bonds - Project Assessment 1,000,000 1,000,000 Thursday, June 16, 2022Page1ProducedUsingthePlan-It Capital Planning Software Total20232024202520262027DepartmentProject # G.O. SA Bonds - Project Levy 4,352,000 4,352,000 Utility: Sewer Fund (F604)1,020,000 1,020,000 Utility: Storm Water Fund (F602)693,000 693,000 Utility: Water Fund (F601)1,150,000 1,150,000 TRN26-000001 5,350,0005,350,000NorthwoodPhase2 Franchise Fees 1,151,000 1,151,000 G.O. SA Bonds - Project Assessment 340,000 340,000 G.O. SA Bonds - Project Levy 2,149,000 2,149,000 Utility: Sewer Fund (F604)700,000 700,000 Utility: Storm Water Fund (F602)360,000 360,000 Utility: Water Fund (F601)650,000 650,000 34,458,00012,365,000 6,580,000 10,163,000 5,350,000Streets: Transportation Total GRAND TOTAL 42,018,00012,365,000 6,570,000 6,580,000 10,163,000 6,340,000 Thursday, June 16, 2022Page2ProducedUsingthePlan-It Capital Planning Software Capital Improvement Program City of Prior Lake, Minnesota PROJECTS BY CATEGORY AND DEPARTMENT 2023 2027thru Total20232024202520262027 Department Category Cable Equipment: Audio/Visual 11,650 11,650TightropeFlexLite340 - Control Room COMM-001 12,400 12,400Webstreaming - Control Room COMM-002 52,400 52,400ChambersPresentation - Chambers COMM-003 62,000 62,000ControlRoomProduction - Control Room COMM-004 24,050 52,400 62,000 138,450Sub-Total 24,050 52,400 62,000 138,450DepartmentTotal: Elections I.T.- General Equipment 36,000 36,000PollPads - qty 28 ELEC-001 18,000 20,000 38,000Tabulators - qty 2 ELEC-002 54,000 20,000 74,000Sub-Total 54,000 20,000 74,000DepartmentTotal: Technology I.T.- General Equipment 00EpsonProjector - Parkview TECH-EQ-002 10,600 10,600RicohMPC4503 - CD/Eng TECH-EQ-003 6,500 6,500RicohIMC2500P&R TECH-EQ-004 10,600 10,600RicohMPC4504 - Admin TECH-EQ-005 9,000 9,000RicohMPC3003 - PW TECH-EQ-006 9,500 9,500RicohMPC3504 - Police TECH-EQ-007 6,000 6,000RicohMPC2504TECH-EQ-008 9,000 9,000HPDesignJetT1500 - CD/Eng TECH-EQ-009 18,000 18,000RicohW3601Copier - CD/Eng TECH-EQ-010 6,400 6,400RicohCopier - City Hall Main Floor TECH-EQ-011 40,000 40,000MarcoPhoneUpgradeTECH-EQ-012 32,500 27,000 20,100 46,000 125,600Sub-Total I.T.- Network Infrastructure 12,000 12,000NetworkSwitchTECH-NW-005 15,000 15,000HPProliantDL380ESX01TECH-NW-006 15,000 15,000HPProliantDL380ESX02TECH-NW-007 36,000 36,000DellSANTECH-NW-008 12,000 66,000 78,000Sub-Total 32,500 39,000 20,100 112,000 203,600DepartmentTotal: Tuesday, June 14, 2022Page1ProducedUsingthePlan-It Capital Planning Software Total20232024202520262027 Department Category 86,500 39,000 44,150 164,400 82,000 416,050GRANDTOTAL Tuesday, June 14, 2022Page2ProducedUsingthePlan-It Capital Planning Software Capital Improvement Program City of Prior Lake, Minnesota DEPARTMENT SUMMARY 2023 2027thru Total20232024202520262027Department Building Inspection 38,00038,000 Cable 138,45024,050 52,400 62,000 Central Garage 100,00020,000 20,000 20,000 20,000 20,000 Elections 74,00054,000 20,000 Facilities 4,911,600613,500 896,600 747,500 2,036,000 618,000 Fire 1,997,500299,000 102,000 1,500,000 49,500 47,000 Parks 1,731,600604,500 430,000 50,600 266,000 380,500 Parks: Projects 4,826,0001,805,000 40,000 1,600,000 1,050,000 331,000 Police 1,943,750314,100 284,750 690,300 325,600 329,000 Streets 1,527,50097,000 80,000 631,500 341,500 377,500 Streets: Overlay 7,560,0006,570,000 990,000 Streets: Transportation 34,458,00012,365,000 6,580,000 10,163,000 5,350,000 Technology 203,60032,500 39,000 20,100 112,000 Utility: Sewer Fund 4,334,000641,000 1,675,000 709,500 669,000 639,500 Utility: Storm Water Fund 3,586,000711,000 1,448,000 585,000 402,000 440,000 Utility: Water Fund 1,748,700351,700 185,500 191,500 370,000 650,000 17,946,300 11,770,850 13,350,050 15,857,000 10,254,500 69,178,700TOTAL Thursday, June 16, 2022Page1ProducedUsingthePlan-It Capital Planning Software Capital Improvement Program City of Prior Lake, Minnesota FUNDING SOURCE SUMMARY 2023 thru 2027 TotalSource20232024202520262027 Cable Franchise Fund (F210)138,45024,050 52,400 62,000 Capital Park Fund (F225)1,150,000650,000 0 500,000 City - Unidentified Funding Source 40,00040,000 City MSA Funds 1,355,0001,355,000 Construction Fund (F501)60,00060,000 County 2,474,0002,474,000 Developer - Upfront Costs 394,000394,000 Facilities Management Fund (F440)2,871,600613,500 596,600 747,500 296,000 618,000 Federal Grant 578,700578,700 Franchise Fees 6,603,0003,204,000 300,000 1,948,000 1,151,000 G.O. Capital Improvement Bonds 2,040,000300,000 1,740,000 G.O. SA Bonds - Overlay Assessment 755,000470,000 285,000 G.O. SA Bonds - Project Assessment 3,091,5001,246,500 505,000 1,000,000 340,000 G.O. SA Bonds - Project Levy 12,935,000183,000 1,046,000 4,500,000 4,352,000 2,854,000 G.O. SA Bonds - Project MSA 3,108,0003,108,000 General Fund (F101)671,600486,500 33,000 20,100 112,000 20,000 Revolving Equip. Fund (F410)7,042,3501,372,600 916,750 2,596,400 1,002,600 1,154,000 Revolving Park Equip. Fund (F430)4,476,0001,155,000 40,000 2,400,000 550,000 331,000 Street Oversize Fund (F503)1,514,3001,514,300 TIF Fund (F414)100,000100,000 Utility: Sewer Fund (F604)6,515,000971,000 1,678,000 837,500 1,689,000 1,339,500 Utility: Storm Water Fund (F602)4,914,000711,000 1,448,000 860,000 1,095,000 800,000 Utility: Water Fund (F601)6,351,200933,200 2,038,500 559,500 1,520,000 1,300,000 17,946,300 11,770,850 13,350,050 15,857,000 10,254,500 69,178,700GRANDTOTAL Wednesday, June 22, 2022Page1ProducedUsingthePlan-It Capital Planning Software Water Fund Summary of Key Financial Information Water Fund 2023 2024 2025 2026 2027 Cash by Purpose For future capital improvements 3,798,268 4,368,731 4,246,914 4,562,963 2,603,615 For following year pay-go capital 2,038,500 559,500 1,520,000 1,300,000 3,574,500 For 3-months of operating cash 833,148 845,601 889,356 881,386 905,220 For following year debt service 784,300 789,000 791,950 801,700 810,450 Ending Cash 7,454,216 6,562,832 7,448,220 7,546,049 7,893,784 Total Average Number of Customer Bills 9,678 9,813 9,938 10,063 10,188 Total Water Volume Billed (1,000 of gallons)829,723 839,443 848,443 857,443 866,443 High Volume Customer (78,000 gallons)1.5%1.5%1.5%1.5%1.5% Medium Volume Customer (18,000 gallons)1.5%1.5%1.5%1.5%1.5% Low Volume Customer (8,000 gallons)1.5%1.5%1.5%1.5%1.5% Average Annual % Change in Water Bill for Billing Period Water Fund Capital Improvement Plan Water Fund Project Description 2023 2024 2025 2026 2027 Capital Outlay Transportation Plan 581,500 1,850,000 325,000 1,150,000 650,000 Meter Replacement Program - Software Upgrade - - 12,500 - - Wells 105,000 55,000 57,500 60,000 50,000 Misc projects 105,000 70,000 15,000 300,000 300,000 Current Year Projects - Facilities 135,500 40,500 - - 300,000 Water Storage & Tower Reconditioning 6,200 - - 10,000 - Technology Plan - 3,000 1,500 - - Current year projects - Equipment - - 128,000 - - WTF Rehabs & Equipment - 20,000 20,000 - - Total Capital Outlay 933,200 2,038,500 559,500 1,520,000 1,300,000 Source of Funds Bond proceeds - - - - - Current revenue / use of cash in fund 933,200 2,038,500 559,500 1,520,000 1,300,000 Total Source of Funds 933,200 2,038,500 559,500 1,520,000 1,300,000 Sanitary Sewer Fund Summary of Key Financial Information Sewer Fund 2023 2024 2025 2026 2027 Cash by Purpose For future capital improvements 2,291,671 3,358,320 3,555,413 4,365,425 3,923,333 For following year pay-go capital 1,678,000 837,500 1,689,000 1,339,500 2,641,000 For 3-months of operating cash 868,285 906,921 974,615 992,956 1,045,353 For following year debt service 169,650 164,250 162,500 165,500 168,000 Ending Cash 5,007,606 5,266,991 6,381,528 6,863,381 7,777,686 Total Average Number of Customer Bills 9,539 9,674 9,799 9,924 10,049 Total Sewer Volume Billed (1,000 of gallons)747,778 755,878 763,378 770,878 778,378 High Volume Customer (47,000 gallons)2.0%2.1%2.1%2.1%2.1% Medium Volume Customer (12,000 gallons)2.1%2.2%2.3%2.3%2.3% Low Volume Customer (7,000 gallons)2.1%2.3%2.3%2.4%2.4% Average Annual % Increase for Fees and Charges Sanitary Sewer Fund Capital Improvement Plan Sewer Fund Project Description 2023 2024 2025 2026 2027 Capital Outlay Transportation Plan 330,000 - - 1,020,000 700,000 Meter Replacement Program - - 12,500 - - Sewer Lining - Inflow/Infiltration Prevention 394,000 1,500,000 454,500 468,000 482,000 Lift Station Rehabilitation 247,000 175,000 142,500 150,000 157,500 Technology Plan - 3,000 10,000 - - Generator/Equipment - - 218,000 51,000 - Total Capital Outlay 971,000 1,678,000 837,500 1,689,000 1,339,500 Source of Funds Bond Proceeds - - - - - Current revenue / use of cash in fund 971,000 1,678,000 837,500 1,689,000 1,339,500 Total Source of Funds 971,000 1,678,000 837,500 1,689,000 1,339,500 Storm Water Quality Fund Summary of Key Financial Information Stormwater Fund 2023 2024 2025 2026 2027 Cash by Purpose For future capital improvements 337,338 238,804 10,144 15,610 158,241 For following year pay-go capital 1,448,000 860,000 1,095,000 800,000 949,250 For 3-months of operating cash 196,064 199,580 205,186 242,207 216,899 Ending Cash 1,981,402 1,298,384 1,310,330 1,057,817 1,324,391 Total Average Number of Residential Equivalent Units Billed 11,877 12,012 12,137 12,262 12,387 Per Residential Equivalent Unit 11.5%11.5%8.0%6.0%6.0% Average Annual % Increase for Fees and Charges Storm Water Quality Fund Capital Improvement Plan Stormwater Fund Project Description 2023 2024 2025 2026 2027 Capital Outlay Transportation Plan - - 150,000 693,000 360,000 Pond Maintenance & Retrofit 200,000 206,000 212,000 218,000 225,000 Stormwater Improvements 150,000 150,000 150,000 150,000 150,000 Stormwater Pond Planning 31,000 32,000 33,000 34,000 35,000 Other 50,000 - - - - Misc projects 280,000 110,000 190,000 - 30,000 Regional Water Quality Pond Project 950,000 - - - Equipment - - 125,000 - - Total Capital Outlay 711,000 1,448,000 860,000 1,095,000 800,000 Source of Funds Bond Proceeds - - - - - Current revenue / use of cash in fund 711,000 1,448,000 860,000 1,095,000 800,000 Total Source of Funds 711,000 1,448,000 860,000 1,095,000 800,000 Capital Improvement Program City of Prior Lake, Minnesota PROJECTS BY CATEGORY AND DEPARTMENT 2023 2027thru Total20232024202520262027 Department Category Building Inspection Equipment: Pick Ups/Vans 38,000 38,000TRUCK-1/2 TON 6397 38,000 38,000Sub-Total 38,000 38,000DepartmentTotal: Central Garage Equipment: Miscellaneous 20,000 20,000 20,000 20,000 20,000 100,000RefurbishingREFUR 20,000 20,000 20,000 20,000 20,000 100,000Sub-Total 20,000 20,000 20,000 20,000 20,000 100,000DepartmentTotal: Fire Equipment: Apparatus 200,000 200,000Fire - Heavy Rescue 9215 00FireTruckHeavyRescue (Refurbish)9216 1,500,000 1,500,000FireLadderTruck9280 200,000 0 1,500,000 1,700,000Sub-Total Equipment: First Response 49,500 49,500SquadFire (Chief)9200 52,000 52,000SquadPick-Up 1/2 Ton 9202 46,000 46,000SquadPick-Up 1/2 Ton 9203 46,000 52,000 49,500 147,500Sub-Total Equipment: Grass Rigs 50,000 50,000FireTruck1Ton9272 50,000 50,000Sub-Total Equipment: Other 47,000 47,000UTV9275 53,000 53,000FireRadiosFD-RADIOS 53,000 47,000 100,000Sub-Total 299,000 102,000 1,500,000 49,500 47,000 1,997,500DepartmentTotal: Parks Equipment: Attachments 2,500 2,500SKIDSTEERSNOWBUCKET8256 3,000 3,000SKIDSTEERSNOWBUCKET8257 1,600 1,600SKIDSTEERU-BLADE 8260 00DISC8266 12,000 12,000STUMPGRINDER8272 Tuesday, June 14, 2022Page1ProducedUsingthePlan-It Capital Planning Software Total20232024202520262027 Department Category 18,500 18,500TOPDRESSER8273 22,600 3,000 12,000 37,600Sub-Total Equipment: Loaders/Skid Steers 75,000 75,000SKIDSTEER - TRACKS 8502 17,000 17,000FORKLIFT8558 92,000 92,000Sub-Total Equipment: Pick Ups/Vans 43,000 43,000TRUCK1/2 TON 8508 31,000 31,000TRUCK-1 TON 8540 68,000 68,000TRUCK-1 TON 8543 78,500 78,500TRUCK-1 TON 8545 66,000 66,000Truck-1 Ton Dump 8546 62,500 62,500Truck-1 Ton Dump 8547 68,500 68,500TRUCK-1 TON 8548 146,500 228,000 43,000 417,500Sub-Total Equipment: Street/Sidewalk 165,000 165,000SIDEWALKMACHINE8506 165,000 165,000Sub-Total Equipment: Trailers 3,000 3,000TRAILER-SMALL ENCLOSED 8529 10,000 10,000TRAILER8533 10,000 3,000 13,000Sub-Total Equipment: Tree Care 85,000 85,000WOODCHIPPER8510 85,000 85,000Sub-Total Equipment: Turf Care 155,000 155,000MOWER-16FT 8503 155,000 155,000MOWER-16FT 8504 135,000 135,000TRACTOR8507 6,000 6,000SODCUTTER8512 90,000 90,000TOOLCATW/MOWER NEW 8513 45,000 45,000MOWER - 6 FT NEW 8522 45,000 45,000MOWER-6FT 8524 45,000 45,000MOWER-6FT 8525 45,000 45,000MOWER-6FT 8526 68,000 68,000UTILITYVEH-STRIPER 8535 24,000 24,000UTILITYVEHICLE8536 28,000 28,000UTILITYVEH-FIELD GROOMER 8537 31,500 31,500UTILITYVEH-WATER TANK 8538 29,000 29,000UTILITYVEHICLE8539 293,000 335,000 28,000 35,000 210,500 901,500Sub-Total Equipment: Utility Equp. 20,000 20,000ELECTRICSCISSORLIFT8551 20,000 20,000Sub-Total 604,500 430,000 50,600 266,000 380,500 1,731,600DepartmentTotal: Police Tuesday, June 14, 2022Page2ProducedUsingthePlan-It Capital Planning Software Total20232024202520262027 Department Category Equipment: Emerg. Sirens 10,800 10,8001996Siren@13760McKennaRdNWPD-Siren08 10,800 10,8001997Siren@16730NorthwoodRdNWPD-Siren09 25,000 25,0001998Siren@14649GlendaleAveSEPD-Siren10 25,750 25,7502003Siren@16280DuluthAveSEPD-Siren11 26,500 26,5002004Siren@5634LutherRdSEPD-Siren12 27,300 27,3002005Siren@14998WildsPkwyNWPD-Siren13 28,100 28,1002006Siren@1546BelmontAveNWPD-Siren14 29,000 29,0002007Siren@1500SpringLakeCir., Jordan PD-Siren15 46,600 52,250 27,300 28,100 29,000 183,250Sub-Total Equipment: Squads 45,500 45,500SQUADNEW7114 48,000 48,000SQUADNEW7115 50,000 50,000SQUADNEW7116 50,000 50,000InvestigatorCar (1516)7135 375,000 375,000BearcatNEW7139 40,000 40,000DrugTaskForceCar (1815)7298 182,000 247,500 429,500Squads-Marked Multiple 1 232,500 250,000 482,500Squads-Marked Multiple 2 240,000 240,000Squads-Marked Multiple 3 267,500 232,500 663,000 297,500 300,000 1,760,500Sub-Total 314,100 284,750 690,300 325,600 329,000 1,943,750DepartmentTotal: Streets Equipment: Attachments 00SKIDSTEERTRAILERMOVER8254 26,000 26,000SKIDSTEERASPHALTMILL8258 27,500 27,500SKIDSTEERMANHOLECUTTER8261 25,000 25,0002003DIRECTIONALSAFETYSIGN8426 25,000 26,000 0 27,500 78,500Sub-Total Equipment: Dump Trucks 247,000 247,000TRUCK-5TON-DUMP-SINGLE AXLE 8466 247,000 247,000Sub-Total Equipment: Emergency Power 55,000 55,000Generator - PD GEN-PD 55,000 55,000Sub-Total Equipment: Loaders/Skid Steers 79,500 79,500SKIDSTEER8781 177,000 177,000LOADER-BACKHOE 8785 275,000 275,000LOADERWHEEL8789 256,500 275,000 531,500Sub-Total Equipment: Pick Ups/Vans 103,000 103,000TRUCK-1.5 TON-DUMP 8452 57,000 57,000TRUCK-1 TON 8457 54,000 54,000Pickup1TonNew8550 125,000 125,000Truck - 1.5 Ton - Dump New 8552 57,000 54,000 125,000 103,000 339,000Sub-Total Equipment: Street/Sidewalk Tuesday, June 14, 2022Page3ProducedUsingthePlan-It Capital Planning Software Total20232024202520262027 Department Category 250,000 250,000STREETSWEEPER-MECHANICAL 8472 250,000 250,000Sub-Total Equipment: Trailers 11,500 11,500TRAILER8479 15,000 15,000TRAILER8480 15,000 11,500 26,500Sub-Total 97,000 80,000 631,500 341,500 377,500 1,527,500DepartmentTotal: 1,372,600 916,750 2,892,400 1,002,600 1,154,000 7,338,350GRANDTOTAL Tuesday, June 14, 2022Page4ProducedUsingthePlan-It Capital Planning Software 2023 2024 2025 2026 2027 Capital Park Fund (F225) - NEW PARKS Beginning Balance 2,185,000 2,388,500 2,995,600 3,603,700 3,712,800 Revenues and Other Fund Sources Revenue Charges for Services: Park Dedication Fees 562,500 562,500 562,500 562,500 562,500 Rent 24,000 24,000 24,000 24,000 24,000 Mn DNR Local Trail Grant 250,0000000 Interest Earnings 20,400 24,000 25,000 26,000 27,000 Total Revenues and Other Fund Sources 856,900 610,500 611,500 612,500 613,500 Total Funds Available 3,041,900 2,999,000 3,607,100 4,216,200 4,326,300 Expenditures and Uses Capital Projects & Equipment Parks: Projects Future Neighborhood Park Development 225-001 0 0 0 (500,000) 0 TH13 Trail TRN19-000004 (650,000)0000 Total (650,000) 0 0 (500,000) 0 Other Uses Property Taxes (3,400) (3,400) (3,400) (3,400) (3,400) Total (3,400) (3,400) (3,400) (3,400) (3,400) Total Expenditures and Uses (653,400) (3,400) (3,400) (503,400) (3,400) Change in Fund Balance 203,500 607,100 608,100 109,100 610,100 Ending Balance 2,388,500 2,995,600 3,603,700 3,712,800 4,322,900 City of Prior Lake, Minnesota Capital Improvement Program 2023 thru 2027 CAPITAL PARK FUND (F225) SOURCES AND USES OF FUNDS 2023 2024 2025 2026 2027 Revolving Park Equipment Fund (F430) - REPLACEMENT Beginning Balance 1,398,000 995,700 1,452,700 399,700 456,700 Revenues and Other Fund Sources Revenue Tax Levy 440,000 485,000 535,000 595,000 655,000 Mn DNR Outdoor Recreation Grant 299,000 0 0 0 0 Interest Earnings 13,700 12,000 12,000 12,000 12,000 Total Revenues and Other Fund Sources 752,700 497,000 547,000 607,000 667,000 Total Funds Available 2,150,700 1,492,700 1,999,700 1,006,700 1,123,700 Expenditures and Uses Capital Projects & Equipment Parks: Projects Wilds North BB Court Maintenance 430-010 (10,000) 0 0 0 0 Memorial Windscreen 430-025 0 0 0 0 (7,000) Ponds Phase I Imp 430-028 (700,000) 0 0 0 0 Sand Point Ballfield 430-029 (10,000) 0 0 0 0 Sand Point Beach Renovation Study 430-030 (75,000) 0 0 0 0 Ryan BB Court Surface, Hoop/Stand 430-036 0 (15,000) 0 0 0 Timbercrest BB Court Surface, Hoop/Stand 430-037 0 (10,000) 0 0 0 Memorial Parking Lots (2)430-039 0 0 0 (250,000) 0 Ponds Phase II Imp 430-041 0 0 (800,000) 0 0 Ponds Playground 430-042 (350,000) 0 0 0 0 Cardinal Ridge Parking Lot 430-044 0 0 0 (45,000) 0 Grainwood Crossing Parking Lot 430-045 0 0 0 (5,000) 0 Northwood Meadows BB Court Surface 430-047 (10,000) 0 0 0 0 Crystal Lake Fishing Pier 430-049 0 0 0 0 (22,000) Enclave BB Court Surface 430-050 0 0 0 0 (15,000) Howard Lake BB Court Surface 430-051 0 0 0 0 (15,000) Memorial Drinking Fountain 430-052 0 0 0 0 (12,000) Woodridge Ballfield 430-054 0 0 0 0 (10,000) Wilds North Playground 430-065 0 (15,000) 0 0 0 Wilds Parkway Trail 430-068 0 0 (800,000) 0 0 Misc Playground 0 0 0 (250,000) (250,000) Total (1,155,000) (40,000) (1,600,000) (550,000) (331,000) Other Uses Transfer to Debt Service Funds 00 000 Total 00 000 Total Expenditures and Uses (1,155,000) (40,000) (1,600,000) (550,000) (331,000) Change in Fund Balance (402,300) 457,000 (1,053,000) 57,000 336,000 Ending Balance 995,700 1,452,700 399,700 456,700 792,700 City of Prior Lake, Minnesota Capital Improvement Program 2023 thru 2027 REVOLVING PARK EQUIPMENT FUND (F430) SOURCES AND USES OF FUNDS Capital Improvement Program City of Prior Lake, Minnesota PROJECTS BY CATEGORY AND DEPARTMENT 2023 2027thru Total20232024202520262027 Department Category Parks: Projects New Park Development 0 0 500,000 500,000FutureNeighborhoodParkDevelopment225-001 650,000 650,000TH13TrailTRN19-000004 650,000 0 500,000 1,150,000Sub-Total Park Replacement 10,000 10,000WildsNorthBBCourtMaintenance430-010 7,000 7,000MemorialWindscreen430-025 700,000 700,000PONDSPHASEIIMP430-028 10,000 10,000SandPointBallfield430-029 75,000 75,000SandPointBeachRenovationStudy430-030 00WillowsPlayground430-032 00WoodridgePlayground430-033 00CardinalRidgePlayground430-034 00OaklandBeachPlayground430-035 15,000 15,000RyanBBCourtMaintenance430-036 10,000 10,000TimbercrestBBCourtMaintenance430-037 00KnobHillPlayground430-038 250,000 250,000MemorialParkingLots (2)430-039 00PondsDugouts430-040 800,000 800,000PONDSPHASEIIIMP430-041 350,000 350,000PondsPlayground430-042 45,000 45,000CardinalRidgeParkingLot430-044 5,000 5,000GrainwoodCrossingParkingLot430-045 00MemorialPlayground430-046 10,000 10,000NorthwoodMeadowsBBCourtMaintenance430-047 15,000 15,000WildsBBCourtMaintenance430-048 22,000 22,000CrystalLakeFishingPier430-049 15,000 15,000EnclaveBBCourtMaintenance430-050 15,000 15,000HowardLakeBBCourtMaintenance430-051 12,000 12,000MemorialDrinkingFountain430-052 00SandPointPlayground430-053 10,000 10,000WoodridgeBallfield430-054 800,000 800,000WildsParkwayTrail430-068 250,000 250,000 500,000MISCPLAYGROUNDPLAY 0 0 0 0 00TrailMaintenanceTRAILS 1,155,000 40,000 1,600,000 550,000 331,000 3,676,000Sub-Total 1,805,000 40,000 1,600,000 1,050,000 331,000 4,826,000DepartmentTotal: Tuesday, June 14, 2022Page1ProducedUsingthePlan-It Capital Planning Software Total20232024202520262027 Department Category 1,805,000 40,000 1,600,000 1,050,000 331,000 4,826,000GRANDTOTAL Tuesday, June 14, 2022Page2ProducedUsingthePlan-It Capital Planning Software 2023 2024 2025 2026 2027 Facilities Management Fund (F440) Beginning Balance 941,000 497,100 635,500 556,000 631,000 Revenues and Other Fund Sources Revenue Tax Levy 155,000 205,000 255,000 305,000 355,000 Tax Levy - Debt Service 0 0 360,000 0 0 G.O. Capital Improvement Bonds 0 300,000 0 1,740,000 0 Water Fund (F601) - transfer for portion of maint ctr costs 0 12,000 0 30,000 21,000 Sewer Fund (F604) - transfer for portion of maint ctr costs 0 12,000 0 30,000 21,000 MVTA 0 0 47,000 0 0 Transfer in from General Fund 0 500,000 0 0 0 Interest Earnings 14,600 6,000 6,000 6,000 6,000 Total Revenues and Other Fund Sources 169,600 1,035,000 668,000 2,111,000 403,000 Total Funds Available 1,110,600 1,532,100 1,303,500 2,667,000 1,034,000 Expenditures and Uses Capital Projects & Equipment City Hall (70,000)(283,500)0 (1,194,500)0 Fire Station #1 (115,500)(104,600)(147,500)0 0 Fire Station #2 (70,000)(60,000)0 (112,000)(95,000) Library & Club Prior (125,000)(17,500)(300,000)0 (228,500) Maintenance Center - Total Cost including water & sewer 0 (121,000)0 (301,500)(209,500) Police Station (233,000)(310,000)(300,000)(428,000)(85,000) Total Expenditures and Uses (613,500)(896,600)(747,500)(2,036,000)(618,000) Change in Fund Balance (443,900)138,400 (79,500)75,000 (215,000) Ending Balance 497,100 635,500 556,000 631,000 416,000 City of Prior Lake, Minnesota Capital Improvement Program 2023 thru 2027 FACILITIES MANAGEMENT FUND (F440) SOURCES AND USES OF FUNDS Capital Improvement Program City of Prior Lake, Minnesota PROJECTS BY CATEGORY AND DEPARTMENT 2023 2027thru Total20232024202520262027 Department Category Facilities Facil: City Hall 70,000 70,000WallCoverings440-008 255,500 255,500MembraneRoofing440-017 393,000 393,000VavBoxes440-032 12,000 12,000GlassDoors440-034 16,500 16,500CoilingDoors440-037 281,000 281,000Carpet440-038 28,000 28,000IrrigationSystem440-081 25,000 25,000BrickWallcovering / Cherrywood Paneling 440-088 23,000 23,000ResiliantFlooring440-089 17,000 17,000TileWalls440-090 66,000 66,000BellandGossetPumps (2)440-091 23,500 23,500CabinetUnitHeater440-092 14,000 14,000GreenheckExhaust (2)440-093 145,500 145,500AirHandler (2)440-094 171,500 171,500Chiller440-095 6,500 6,500Miscellaneous440-096 70,000 283,500 1,194,500 1,548,000Sub-Total Facil: Fire Station #1 15,500 15,500IrrigationSystem440-011 21,500 21,500WallCoverings440-018 10,000 10,000TurnoutLockers440-019 35,000 35,000Doors440-020 14,500 14,500TileWalls440-021 15,500 15,500ExhaustFan440-022 8,100 8,100Damper440-023 147,500 147,500RooftopUnit440-031 00RoomDivider / Display Case 440-085 100,000 100,000VEHICLEEXHAUSTSYSTEM440-188 115,500 104,600 147,500 367,600Sub-Total Facil: Fire Station #2 30,000 30,000Carpet440-012 40,000 40,000InfraredTubeHeater440-013 30,000 30,000ForcedAirFurnace (3)440-024 112,000 112,000MembraneRoofing440-039 30,000 30,000ACUnit (3)440-086 15,000 15,000ExhaustFan (2)440-123 20,000 20,000AirExchanger440-124 60,000 60,000Make-Up Air Unit 440-125 70,000 60,000 112,000 95,000 337,000Sub-Total Tuesday, June 14, 2022Page1ProducedUsingthePlan-It Capital Planning Software Total20232024202520262027 Department Category Facil: Library & Club Prior 17,500 17,500VavBoxes440-025 300,000 300,000ParkingLots440-026 131,500 131,500HVACControlSystem440-052 97,000 97,000AirHandlingUnit - Trane 440-110 125,000 125,000REMODELPH2440-187 125,000 17,500 300,000 228,500 671,000Sub-Total Facil: Maintenance Ctr. 40,500 40,500AutoGate440-027 80,500 80,500OverheadCrane440-028 51,500 51,500Windows - Aluminum 440-041 00RoomDivider440-042 154,000 154,000Hoists (In-Ground and Utility)440-043 209,500 209,500ConcreteFloors440-053 28,500 28,500Skylights (3)440-116 24,000 24,000Miscellaneous440-117 43,500 43,500SteelDoorsandFrames440-118 121,000 301,500 209,500 632,000Sub-Total Facil: Police Station 310,000 310,000MembraneRoofing440-029 8,000 8,000OverheadCoilingDoor (2)440-047 13,000 13,000IrrigationSystem440-082 100,000 100,000OverheadFoldingDoor10x14440-083 300,000 300,000Parking / Safety Enhancements 440-087 40,000 40,000FrontEntrySecurityUpdate440-101 19,000 19,000BellandGossetPump440-102 14,000 14,000GreenheckExhaust (2)440-103 79,000 79,000AirHandler - McQuay 440-104 60,000 60,000ACCondenser440-105 208,000 208,000VAVBoxes440-106 85,000 85,000EpoxyFlooring440-107 120,000 120,000CARPET440-185 233,000 310,000 300,000 428,000 85,000 1,356,000Sub-Total 613,500 896,600 747,500 2,036,000 618,000 4,911,600DepartmentTotal: 613,500 896,600 747,500 2,036,000 618,000 4,911,600GRANDTOTAL Tuesday, June 14, 2022Page2ProducedUsingthePlan-It Capital Planning Software 2023 2024 2025 2026 2027 Construction Fund (F501) Revenues and Other Fund Sources Revenue G.O. Special Assessment Bonds - Project Levy 183,000 - 4,500,000 4,352,000 2,149,000 G.O. Special Assessment Bonds - Project Assessment 1,246,500 - 505,000 1,000,000 340,000 G.O. Special Assessment Bonds - Project MSA 3,108,000 - - - - City - MSA Funds 1,355,000 County 2,473,973 - - - - Street Oversize Fund (F503)1,514,290 - - - - Developer Upfront Costs 394,000 - - - - ARPA Funds 578,750 - - - - Franchise Fees - - 300,000 1,948,000 1,151,000 City - Unidentified Funding Source 40,000 - - - - General Fund (F101)400,000 - - - - TIF Funds (F414)100,000 - - - - Revolving Park Equip Funds (F430)- - 800,000 - - Construction Fund (F501)60,000 - - - - Water Fund (F601)581,500 - 325,000 1,150,000 650,000 Water Quality Fund (F602)- - 150,000 693,000 360,000 Sewer Fund (F604)330,000 - - 1,020,000 700,000 Total Revenues and Other Fund Sources 12,365,013 0 6,580,000 10,163,000 5,350,000 Expenditures and Uses Capital Projects & Equipment Streets: Transportation Fish Point Road Phase II TRN22-000001 (5,998,000) - - - - CSAH 21 (Revere to 170th St)TRN22-000002 (5,567,013) - - - - Marsh St Extension TRN23-000001 (800,000) - - - - Wilds Pkwy Reclamation TRN24-000001 - - (4,925,000) - - Lords Street Bridge Rehab TRN24-000002 - - (300,000) - - Martindale/Henning/Hickory Reclamation TRN24-000003 - - (1,355,000) - - Northwood Phase 1 TRN25-000001 - - - (10,163,000) - Northwood Phase 2 TRN26-000001 - - - - (5,350,000) Green Heights Area TRN27-000001 - - - - Sunset Hills Area TRN28-000001 - - - - - Raspberry Ridge Neighborhood TRN29-000001 - - - - - Lords Neighborhood TRN30-000001 - - - - - Village Lake/Tower TRN31-000002 - - - - - Total Expenditures and Uses (12,365,013)0 (6,580,000)(10,163,000)(5,350,000) City of Prior Lake, Minnesota Capital Improvement Program 2023 thru 2027 CONSTRUCTION FUND (F501) SOURCES AND USES OF FUNDS 2023 2024 2025 2026 2027 Perm. Imp. Revolving Fund (F450) Beginning Balance 1,270,000 2,251,210 285,164 285,565 258,370 Revenues and Other Fund Sources Revenue G.O. Special Assessment Bonds - Project Levy 0 1,046,000 0 0 705,000 G.O. Special Assessment Bonds - Overlay Assessment 0 470,000 0 0 285,000 Franchise Fees 1,068,000 1,086,000 0 0 0 Special Assessment Revenue 110,535 212,806 103,930 76,328 159,196 Transfer from Water Fund 0 1,850,000 0 0 0 Interest Earnings 5,700 33,648 4,157 4,163 3,755 Total Revenues and Other Fund Sources 1,184,235 4,698,454 108,087 80,491 1,152,951 Total Funds Available 2,454,235 6,949,664 393,251 366,056 1,411,321 Expenditures and Uses Capital Projects & Equipment Streets: Overlay Wilds / Jeffers Mill and Overlay PIR24-000001 0 (6,570,000) 0 0 0 Northwoods Phase 2 Mill and Overlay PIR27-000001 0 0 0 0 (990,000) Total 0 (6,570,000) 0 0 (990,000) Other Uses Transfer to Debt Service Funds (203,025) (94,500) (107,686) (107,686) (107,686) Total (203,025) (94,500) (107,686) (107,686) (107,686) Total Expenditures and Uses (203,025) (6,664,500) (107,686) (107,686) (1,097,686) Change in Fund Balance 981,210 (1,966,046) 401 (27,195) 55,265 Ending Balance 2,251,210 285,164 285,565 258,370 313,635 City of Prior Lake, Minnesota Capital Improvement Program 2023 thru 2027 PERMANENT IMPROVEMENT REVOLVING FUND (F450) SOURCES AND USES OF FUNDS