Loading...
HomeMy WebLinkAbout6.l. Review Capital Improvement Plan (CIP) EXECUTIVE SUMMARY City Council Regular Meeting: November 20, 2018 AGENDA ITEM: Review Capital Improvement Plan (CIP) AGENDA SECTION: Consent PREPARED BY: Logan Martin, City Administrator Jeff May, Finance Director AGENDA NO. 6.l. ATTACHMENTS: 2019-2028 CIP APPROVED BY: LJM RECOMMENDED ACTION: Motion to adopt the attached 10-year Capital Improvement Plan for 2019 – 2028. BACKGROUND As part of the annual budgeting process, City staff has completed a thorough review and update to the City’s ten-year Capital Improvement Plan (CIP). The three major CIP funds include Streets, Equipment, and Buildings/Facilities. By engaging in a comprehensive capital planning process, the City is able to anticipate and save for large expenditures while ensuring that funds allocated toward these areas remain consistent. After initial review and direction by the City Council, the CIP was presented to the Planning Commission and Parks & Recreation Commission in October. No changes were recommended by either body, and as such the final document is presented to the City Council for formal adoption. Discussion of Significant Projects / Updates Many of the significant projects shown in the CIP address improvements to the City’s park system, roadway infrastructure, and utility projects associated with anticipated developments. Those projects are discussed in greater detail below. Parks & Recreation Projects The City’s CIP continues to show significant investment in the parks and trails system, both to improve the current system and to install new amenities in new neighborhoods. A few examples include: • 2019 - 2020: Skate Park Upgrades (design in ’19, install in ‘20) ($130,000) • 2019: Family Resource Center expansion ($450,000 City share, $450,000 grant from State of MN) • 2019: Dunmore Park Development ($150,000) • 2019: Carrolls Woods Restoration ($150,000) • 2020: UMore Field Improvements Phase 2 ($1.9M) • 2020: Dugouts at Bloomfield Park ($15,000) • 2020: Covered Dugouts at Erickson Park ($70,000) Major Road Projects After a review of MN State Aid (MSA) funds and the City’s pavement management program (PMP), the following priority projects have been identified. 2 • 2019: Bonaire Path – Akron Ave. to Greystone ($2M, including $1M grant from State of MN) o Includes asphalt roadway construction and RR quiet zone installation • 2019: Akron Ave. upgrade to IGH border (ROW acquisition in 2019; $337,500) o Construction slated for 2020, City portion estimated at $1.57M) • 2019: PMP at Chippendale, Dodd, 151st, Crestone, Claret, Cimarron, Connemara ($1.7M) • 2022: Roundabout at Connemara & Diamond Path, shared with Dakota County ($440,000) o Design occurs in 2020, right-of-way acquisition in 2021 Public Works & Utility Projects Beyond normal vehicle replacement schedules, a few key Public Works and Utility projects of note have been identified in the CIP. The timing for many of these large-scale projects is contingent upon development needs. • 2019: Year 2 of fleet leasing program with Enterprise ($62.347, offset by $44,500 in vehicle sales) • 2019: Picnic Table / Planter replacements ($35,000) • 2022: Possible water storage and treatment plant facilities ($22M) • 2022: Well #17 construction ($1.5M) RECOMMENDATION Staff recommends the Council review the proposed projects and approve the attached 10-year Capital Improvement Program for 2019 – 2028. 10-YEAR CIP WORKING PROGRAM 2019-2028 10-YEAR CAPITAL IMPROVEMENT PLAN (CIP) BACKGROUND Historically, the City of Rosemount has usually had some form of CIP in place to utilize for its capital improvements. There have been times where just a single year’s capital improvements have been addressed and funded. For many years a 5-year CIP was utilized. Over time it was felt that the best way to plan for the future was to look out over a period of at least 10 years. What evolved is the following 10-year Capital Improvement Plan. We believe that great strides have been made to more accurately plan for the future of the City of Rosemount. This document is only a working guide that is utilized by the City Council and its staff to prepare for the future. The first year of the plan will be included as part of the formal budget that is prepared yearly as part of our Truth-in-Taxation process with the following years developed as a working tool for future years’ discussions. GENERAL/ADMINISTRATIVE DESCRIPTION The CIP provides for specific funding of items that are generally of a higher estimated cost than $5,000 and will have a life expectancy of 3 years or greater. The source of funding for these expenditures is typically the general tax levy. In some instances, other funding is utilized. For example, revenues received from user fees are being designated in various CIP funds for capital improvement/equipment purchases. Individual departments are designated for each item proposed for purchase in this plan. TYPES OF CAPITAL IMPROVEMENT FUNDS The CIP includes three separate funds to isolate and better track the types of capital improvements being planned for. The following briefly describes each of the three: Building & Facilities CIP Fund - This fund is used to account for the on-going capital improvements and possible additions to government buildings and other facilities. This fund also is utilized for “special projects / items” that are funded mainly with SKB revenues – monies outside of the typical tax levy funding. Street CIP Fund - This fund is used to account for the on-going street and trail construction and reconstruction projects within the City and all other major maintenance items related to both paved and unpaved streets including, but not limited to, street lights, signal lights, sidewalks and gravel road resurfacing. Equipment CIP Fund - This fund is used to account for the on-going replacement of and additions to City equipment. 1 of 11 MSA 11/16/18 Building Funds & Facilities Street Equipment Park Imp From Water Sewer Storm Water Sewer Storm Debt Serv Total Year Item - Description Department CIP CIP CIP Assess Fund State Core Core Core Utility Utility Utility Levy Other Cost 2019 1 LED Lighting Arena 40,000 (1)40,000 2019 2 SAN Replacement Finance 35,000 35,000 2019 3 PC Workstation Upgrades (From 2014) (Admin, Park & Rec)Finance 83,000 83,000 2019 4 Replace Air Compressor @ Station #1 Fire 65,000 65,000 2019 5 Add Station Exhaust Systems @ Station #1 and Station #2 Fire 75,000 75,000 2019 6 Replace Handheld Radios (17)Fire 76,500 76,500 2019 7 City-Wide Software Gen'l. Govt.25,000 25,000 2019 8 Steeple Center Signage Park & Rec 5,000 5,000 2019 9 Steeple Center Assembly Carpet Park & Rec 30,000 30,000 2019 10 Family Resource Center Addition (City Share Only)Park & Rec 450,000 450,000 2019 11 Carpet Cleaner for RCC Park & Rec 7,500 7,500 2019 12 Skate Park Upgrades - Phase 1 (Design)Park & Rec 65,000 (2)65,000 2019 13 Carrolls Woods Restoration Park & Rec 150,000 (2)150,000 2019 14 Trail Plans & Design - Regional Greenways Park & Rec 50,000 50,000 2019 15 Dunmore Park Development Park & Rec 150,000 150,000 2019 16 Squad Camera for CSO Vehicle #3550 Police 8,000 8,000 2019 17 Replace 1/2 of AED's (6)Police 8,000 8,000 2019 18 Replace Pole Camera Police 25,000 25,000 2019 19 Squad Set Up and Equipment Installation Police 30,000 30,000 2019 20 Lease Program - Year 2 Police 61,309 (30,500)(3)30,809 2019 21 Replace Police Portable Radios (Encrypted)Police 162,000 162,000 2019 22 Pedestrian Improvements Program Pub Works 125,000 125,000 2019 23 PMP(Chippendale,Dodd,151st,Crestone,Claret,Cimarron, Connemara A)Pub Works 150,000 1,300,000 50,000 150,000 60,000 1,710,000 2019 24 CR 73 - Bonaire Path to IGH (ROW)Pub Works 337,500 (4)337,500 2019 25 Connemara Trail - East Extension (Construction)Pub Works 800,000 15,000 357,000 (5)1,172,000 2019 26 Bonaire Path - Akron Avenue to Greystone(with Quiet Zone)(Const.)Pub Works 1,000,000 1,000,000 (4)2,000,000 2019 27 Downtown Planter Replacement Program Pub Works 10,000 10,000 2019 28 Picnic Table Replacement Program Pub Works 25,000 25,000 2019 29 Lease Program - Year 2 Pub Works 62,347 8,418 (44,500)(3)26,265 2019 30 Blower Attach for #8418 & #8420 (Replace #0123) (2008)Pub Works 6,000 6,000 2019 31 Equipment Trailer (Replace #0503) (Purchased 1999)Pub Works 12,000 1,500 (6)13,500 2019 32 Bobcat (Replace #8418) (2008 Vehicle)Pub Works 55,000 5,000 (6)60,000 2019 33 JD Tractor (Replace #8406) (2006 Vehicle)Pub Works 83,000 7,000 (6)90,000 2019 34 NEW Portable Generator (#8058)Pub Works 30,000 30,000 30,000 90,000 2019 35 NEW Standby Generator (Well #7)Pub Works 100,000 100,000 2019 36 Utility Pickup w/Crane (Replace #8342) (2007 Vehicle)Pub Works 32,000 31,500 31,500 15,000 (6)110,000 2019 37 Jetter (Replace #8445) (2006 Vehicle)Pub Works 132,500 132,500 25,000 (6)290,000 520,000 1,262,500 879,656 150,000 200,000 2,300,000 15,000 0 0 220,418 344,000 254,000 0 1,590,500 7,736,074 Total CIP Funding Requirements - Year 2019 $2,662,156 $0 (#)These items will be funded with the issuance of Equipment Certificates.$0 (1)LED lighting funding comes from Arena Fund operations/reserves. (2)Skate Park funding will come from the General Fund Parks Maintenance Budget. Carrolls Woods Restoration funding will come from assigned funds. (3)Highlighted items are part of a lease program. This is a summary of the total for the year. Detail is provided in an accompanying document. (4)Other funding for these projects are not included. Costs are Rosemount's share only. The $1,000,000 for Bonaire Path under "Other" is part of our share paid for by the State as part of the 2018 Bonding Bill. (5)Other funding comes from prepaid special assessments collected over the last 5-7 years. (6)Other funding for Public Works equipment comes from trade-in value of old vehicles. Total Building CIP levy for 2019 is $0. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). Total Street CIP levy for 2019 is $852,327. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). Total Equipment CIP levy for 2019 is $620,000. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). 2 of 11 MSA 11/16/18 Building Funds & Facilities Street Equipment Park Imp From Water Sewer Storm Water Sewer Storm Debt Serv Total Year Item - Description Department CIP CIP CIP Assess Fund State Core Core Core Utility Utility Utility Levy Other Cost 2020 1 Scoreboards Arena 22,000 (1)22,000 2020 2 Replace Chiller Barrel Arena 135,000 (1)135,000 2020 3 Phone Server Replacements (From 2015)Finance 20,000 20,000 2020 4 Replace Fire Department Mobile Computers (From 2016)Finance 35,000 35,000 2020 5 3 Server Environment & Storage Replacements (From 2015)Finance 35,000 35,000 2020 6 Aerial Platform Truck Replacement (Purchased in 2020)Fire 1,200,000 (#)1,200,000 2020 7 City-Wide Software Gen'l. Govt.25,000 25,000 2020 8 Skate Park Upgrades - Phase 2 (Installation)Park & Rec 65,000 (2)65,000 2020 9 Dugouts @ Bloomfield Park Park & Rec 15,000 15,000 2020 10 Covered Dugouts at UMore Ball Field & Erickson Park Park & Rec 70,000 70,000 2020 11 Community Center / Armory Remodel Park & Rec 150,000 150,000 2020 12 Umore Ball Field Improvements - Phase 2 Park & Rec 1,900,000 1,900,000 2020 13 Develop Park N-5 Park & Rec 500,000 500,000 2020 14 Squad Set Up and Equipment Installation Police 30,000 30,000 2020 15 Lease Program - Year 3 Police 83,209 (30,000)(3)53,209 2020 16 Pedestrian Improvements Program Pub Works 125,000 125,000 2020 17 PMP (121st St., 124th Ct.)Pub Works 175,000 50,000 225,000 2020 18 Roundabout @ Connemara / Diamond Path (Design)Pub Works 45,000 (4)45,000 2020 19 CR 73 - Bonaire Path to IGH (Construction)Pub Works 1,320,000 75,000 75,000 100,000 (4)1,570,000 2020 20 Biscayne Avenue - Boulder Trail to CR 46 Pub Works 2,000,000 230,000 50,000 (5)2,280,000 2020 21 Downtown Planter Replacement Program Pub Works 10,000 10,000 2020 22 Picnic Table Replacement Program Pub Works 25,000 25,000 2020 23 Lease Program - Year 3 Pub Works 108,872 10,343 1,925 1,925 (99,000)(3)24,065 2020 24 NEW Paint Mixer Pub Works 15,000 15,000 2020 25 Sweeper (Replace #8443) (Purchased 2007)Pub Works 64,500 150,500 15,000 (6)230,000 2020 26 Single-Axle Dump Truck (Replace #8430) (2009 Vehicle)Pub Works 145,000 35,000 (6)180,000 2020 27 Loader, Wing & Plow (Replace #8419) (Purchased 2005)Pub Works 275,000 50,000 (6)325,000 2,170,000 1,620,000 836,581 50,000 500,000 2,045,000 75,000 305,000 100,000 60,343 1,925 152,425 0 1,393,000 9,309,274 Total CIP Funding Requirements - Year 2020 $4,626,581 $0 (#)These items will be funded with the issuance of Equipment Certificates.$1,200,000 (1)Scoreboards & Chiller Barrel Replacement funding comes from Arena Fund operations/reserves. (2)Skate Park funding will come from the General Fund Parks Maintenance Budget. (3)Highlighted items are part of a lease program. This is a summary of the total for the year. Detail is provided in an accompanying document. (4)Other funding for these projects are not included. Costs are Rosemount's share only. (5)Other funding for Biscayne Avenue project for the University of Minnesota are not included. Costs are Rosemount's share only. (The University needs a 2-year notice prior to project start) (6)Other funding for Public Works equipment comes from trade-in value of old vehicles. Total Building CIP levy for 2020 is $0. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). Total Street CIP levy for 2020 is $877,897. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). Total Equipment CIP levy for 2020 is $640,000. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). 3 of 11 MSA 11/16/18 Building Funds & Facilities Street Equipment Park Imp From Water Sewer Storm Water Sewer Storm Debt Serv Total Year Item - Description Department CIP CIP CIP Assess Fund State Core Core Core Utility Utility Utility Levy Other Cost 2021 1 Restroom Rehab - Lower Arena 25,000 (1)25,000 2021 2 Low E-Ceiling Arena 65,000 (1)65,000 2021 3 Aerial Platform Truck Replacement (Year 1 of 5)Fire 252,000 252,000 2021 4 City-Wide Software Gen'l. Govt.25,000 25,000 2021 5 Baseline Fencing for 3 Fields Park & Rec 30,000 30,000 2021 6 Develop Park N-6 Park & Rec 500,000 500,000 2021 7 New Trails on Bonaire Path Park & Rec 200,000 (2)200,000 2021 8 Replace Less Lethal Weapons Police 6,000 6,000 2021 9 Squad Set Up and Equipment Installation Police 45,000 45,000 2021 10 Replace Squad Video System Police 120,000 120,000 2021 11 Lease Program - Year 4 Police 113,209 (32,000)(3)81,209 2021 12 Pedestrian Improvements Program Pub Works 125,000 125,000 2021 13 PMP (Carrolton C, West Ridge B/C, Shannon Pond)Pub Works 900,000 250,000 55,000 160,000 65,000 1,430,000 2021 14 Roundabout @ Connemara / Diamond Path (ROW)Pub Works 78,800 (4)78,800 2021 15 Downtown Planter Replacement Program Pub Works 10,000 10,000 2021 16 Picnic Table Replacement Program Pub Works 25,000 25,000 2021 17 Lease Program - Year 4 Pub Works 157,372 10,343 1,925 1,925 (82,000)(3)89,565 2021 18 Blower Attach for #8409 (Replace #0122) (2001) Pub Works 14,000 1,000 (5)15,000 2021 19 Pavement Roller (Replace #8129) (Purchased 2003)Pub Works 58,000 2,000 (5)60,000 2021 20 Sno Go Blower (Replace #0130) (Purchased 1987)Pub Works 160,000 160,000 65,000 1,025,000 950,581 250,000 500,000 78,800 0 0 0 65,343 161,925 66,925 0 179,000 3,342,574 Total CIP Funding Requirements - Year 2021 $2,040,581 $0 (#)These items will be funded with the issuance of Equipment Certificates.$0 (1)Restroom Rehab (Lower) and Low E Ceiling funding comes from Arena Fund operations/reserves. (2)Other funding for Bonaire Path trails unknown at this time. (3)Highlighted items are part of a lease program. This is a summary of the total for the year. Detail is provided in an accompanying document. (4)Other funding for these projects are not included. Costs are Rosemount's share only. (5)Other funding for Public Works equipment comes from trade-in value of old vehicles. Total Building CIP levy for 2021 is $0. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). Total Street CIP levy for 2021 is $904,234. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). Total Equipment CIP levy for 2021 is $660,000. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). 4 of 11 MSA 11/16/18 Building Funds & Facilities Street Equipment Park Imp From Water Sewer Storm Water Sewer Storm Debt Serv Total Year Item - Description Department CIP CIP CIP Assess Fund State Core Core Core Utility Utility Utility Levy Other Cost 2022 1 Replace Zamboni Batteries Arena 15,000 (1)15,000 2022 2 Restroom Rehab - Upper Arena 20,000 (1)20,000 2022 3 Replace Compressors Arena 70,000 (1)70,000 2022 4 PC Workstation Upgrades (From 2017) (Police, Fire, P.W.)Finance 80,000 80,000 2022 5 Aerial Platform Truck Replacement (Year 2 of 5)Fire 252,000 252,000 2022 6 City-Wide Software Gen'l. Govt.25,000 25,000 2022 7 Central Park Improvements Park & Rec 1,200,000 1,200,000 2022 8 New Neighborhood Park in Umore Park & Rec 500,000 500,000 2022 9 Replace Police Portable Radio Batteries Police 5,000 5,000 2022 10 Squad Set Up and Equipment Installation Police 45,000 45,000 2022 11 Replace Squad Laptops (5) / Printers / Netmotion Police 55,000 55,000 2022 12 Lease Program - Year 5 Police 116,218 (38,000)(2)78,218 2022 13 Pedestrian Improvements Program Pub Works 125,000 125,000 2022 14 PMP (Deepwoods, Jay Simons, White Lake Acres)Pub Works 1,200,000 300,000 280,000 240,000 280,000 2,300,000 2022 15 Roundabout @ Connemara / Diamond Path (Construction)Pub Works 440,000 (3)440,000 2022 16 Picnic Table Replacement Program Pub Works 25,000 25,000 2022 17 Lease Program - Year 5 Pub Works 191,622 12,843 4,425 6,675 (85,000)(2)130,565 2022 18 Shop Hoist (Replace #0002) (Purchased 2006)Pub Works 55,000 5,000 (4)60,000 2022 19 Generator (Replace #8057) (Purchased 1996)Pub Works 35,000 35,000 5,000 (4)75,000 2022 20 Generator (Replace #8059) (Purchased 2003)Pub Works 35,000 35,000 5,000 (4)75,000 2022 21 Well #17 Construction Pub Works 1,500,000 (5)1,500,000 2022 22 Water Storage Facility Pub Works 5,000,000 (5)5,000,000 2022 23 Water Treatment Facility Pub Works 8,500,000 8,500,000 (5)17,000,000 1,225,000 1,325,000 824,840 300,000 500,000 440,000 15,280,000 240,000 280,000 8,582,843 74,425 6,675 0 (3,000)29,075,783 Total CIP Funding Requirements - Year 2022 $3,374,840 $0 (#)These items will be funded with the issuance of Equipment Certificates.$0 (1)Zamboni Battery Replacements, Upper Restroom Rehab & Compressors funding comes from Arena Fund operations/reserves. (2)Highlighted items are part of a lease program. This is a summary of the total for the year. Detail is provided in an accompanying document. (3)Other funding for these projects are not included. Costs are Rosemount's share only. (4)Other funding for Public Works equipment comes from trade-in value of old vehicles. (5)Funding for Well #17, a Water Storage Facility and a Water Treatment Facility will come from a Water Revenue bond issue. Total Building CIP levy for 2022 is $0. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). Total Street CIP levy for 2022 is $931,361. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). Total Equipment CIP levy for 2022 is $680,000. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). 5 of 11 MSA 11/16/18 Building Funds & Facilities Street Equipment Park Imp From Water Sewer Storm Water Sewer Storm Debt Serv Total Year Item - Description Department CIP CIP CIP Assess Fund State Core Core Core Utility Utility Utility Levy Other Cost 2023 1 Replace Skate Tile Arena 90,000 (1)90,000 2023 2 Aerial Platform Truck Replacement (Year 3 of 5)Fire 252,000 252,000 2023 3 City-Wide Software Gen'l. Govt.25,000 25,000 2023 4 Squad Set Up and Equipment Installation Police 55,000 55,000 2023 5 Lease Program - Year 6 Police 119,700 (40,000)(2)79,700 2023 6 Pedestrian Improvements Program Pub Works 125,000 125,000 2023 7 PMP (Biscayne A & B, 145th St. A)Pub Works 250,000 950,000 60,000 175,000 70,000 1,505,000 2023 8 Picnic Table Replacement Program Pub Works 25,000 25,000 2023 9 Lease Program - Year 6 Pub Works 198,275 14,425 4,425 6,675 (77,000)(2)146,800 2023 10 Aerator (Replace #0157) (Purchased 2013)Pub Works 18,000 2,000 (3)20,000 2023 11 Tractor/Backhoe (Replace #8407) (Purchased 2008)Pub Works 105,000 25,000 (3)130,000 25,000 125,000 772,975 250,000 0 950,000 0 0 0 74,425 179,425 76,675 0 0 2,453,500 Total CIP Funding Requirements - Year 2023 $922,975 $0 (#)These items will be funded with the issuance of Equipment Certificates.$0 (1)Skate Tile funding comes from Arena Fund operations/reserves. (2)Highlighted items are part of a lease program. This is a summary of the total for the year. Detail is provided in an accompanying document. (3)Other funding for Public Works equipment comes from trade-in value of old vehicles. Total Building CIP levy for 2023 is $0. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). Total Street CIP levy for 2023 is $959,302. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). Total Equipment CIP levy for 2023 is $700,000. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). 6 of 11 MSA 11/16/18 Building Funds & Facilities Street Equipment Park Imp From Water Sewer Storm Water Sewer Storm Debt Serv Total Year Item - Description Department CIP CIP CIP Assess Fund State Core Core Core Utility Utility Utility Levy Other Cost 2024 1 Replace Skate Sharpener Arena 20,000 (1)20,000 2024 2 Replace Fire Department Mobile Computers (From 2020)Finance 35,000 35,000 2024 3 PC Workstation Upgrades (From 2019) (Admin, Park & Rec)Finance 70,000 70,000 2024 4 Aerial Platform Truck Replacement (Year 4 of 5)Fire 252,000 252,000 2024 5 City-Wide Software Gen'l. Govt.25,000 25,000 2024 6 Squad Set Up and Equipment Installation Police 38,000 38,000 2024 7 Lease Program - Year 7 Police 121,500 (26,000)(2)95,500 2024 8 Pedestrian Improvements Program Pub Works 125,000 125,000 2024 9 PMP (Cameo Ave., 143rd St. W., O'Leary's Hills A/B)Pub Works 650,000 175,000 60,000 175,000 70,000 1,130,000 2024 10 Lease Program - Year 7 Pub Works 204,775 14,425 4,425 6,675 (66,000)(2)164,300 2024 11 Groundsmaster Mower (Replace #8066) (Purchased 2015)Pub Works 87,000 8,000 (3)95,000 2024 12 Groundsmaster Mower (Replace #8073) (Purchased 2015)Pub Works 87,000 8,000 (3)95,000 2024 13 Single-Axle Dump Truck (Replace #8432) (2012 Vehicle)Pub Works 151,000 39,000 (3)190,000 0 775,000 1,071,275 175,000 0 0 0 0 0 74,425 179,425 76,675 0 (17,000)2,334,800 Total CIP Funding Requirements - Year 2024 $1,846,275 $0 (#)These items will be funded with the issuance of Equipment Certificates.$0 (1)Skate Sharpener funding comes from Arena Fund operations/reserves. (2)Highlighted items are part of a lease program. This is a summary of the total for the year. Detail is provided in an accompanying document. (3)Other funding for Public Works equipment comes from trade-in value of old vehicles. Total Building CIP levy for 2024 is $0. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). Total Street CIP levy for 2024 is $988,081. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). Total Equipment CIP levy for 2024 is $720,000. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). 7 of 11 MSA 11/16/18 Building Funds & Facilities Street Equipment Park Imp From Water Sewer Storm Water Sewer Storm Debt Serv Total Year Item - Description Department CIP CIP CIP Assess Fund State Core Core Core Utility Utility Utility Levy Other Cost 2025 1 Replace Ice Edger Arena 8,000 (1)8,000 2025 2 Phone Server Replacements (From 2020)Finance 20,000 20,000 2025 3 PC File Server Replacements & Backup System (From 2020)Finance 120,000 120,000 2025 4 Aerial Platform Truck Replacement (Year 5 of 5)Fire 252,000 252,000 2025 5 City-Wide Software Gen'l. Govt.25,000 25,000 2025 6 Squad Set Up and Equipment Installation Police 58,000 58,000 2025 7 Lease Program - Year 8 Police 124,700 (32,000)(2)92,700 2025 8 Pedestrian Improvements Program Pub Works 125,000 125,000 2025 9 PMP (Biscayne Point A, Shannon Pond E, and Geronime Pond)Pub Works 850,000 250,000 60,000 175,000 70,000 1,405,000 2025 10 Lease Program - Year 8 Pub Works 204,775 14,425 4,425 6,675 (105,000)(2)125,300 2025 11 Water Truck (Replace #8431) (2013 Vehicle)Pub Works 180,000 20,000 (3)200,000 2025 12 Dump Tandem (Replace #8434) (2013 Vehicle)Pub Works 195,000 35,000 (3)230,000 0 975,000 1,179,475 250,000 0 0 0 0 0 74,425 179,425 76,675 0 (74,000)2,661,000 Total CIP Funding Requirements - Year 2025 $2,154,475 $0 (#)These items will be funded with the issuance of Equipment Certificates.$0 (1)Ice Edger funding comes from Arena Fund operations/reserves. (2)Highlighted items are part of a lease program. This is a summary of the total for the year. Detail is provided in an accompanying document. (3)Other funding for Public Works equipment comes from trade-in value of old vehicles. Total Building CIP levy for 2025 is $0. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). Total Street CIP levy for 2025 is $1,017,723. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). Total Equipment CIP levy for 2025 is $740,000. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). 8 of 11 MSA 11/16/18 Building Funds & Facilities Street Equipment Park Imp From Water Sewer Storm Water Sewer Storm Debt Serv Total Year Item - Description Department CIP CIP CIP Assess Fund State Core Core Core Utility Utility Utility Levy Other Cost 2026 1 Replace Ice Resurfacer Arena 120,000 (1)120,000 2026 2 City-Wide Software Gen'l. Govt.25,000 25,000 2026 3 Squad Set Up and Equipment Installation Police 58,000 58,000 2026 4 Lease Program - Year 9 Police 127,300 (32,000)(2)95,300 2026 5 Pedestrian Improvements Program Pub Works 125,000 125,000 2026 6 PMP (Oak Ridge)Pub Works 200,000 50,000 50,000 300,000 2026 7 Lease Program - Year 9 Pub Works 214,275 14,425 4,425 6,675 (96,000)(2)143,800 2026 8 John Deere Trailer (Replace #0525) (Purchased 2010)Pub Works 12,000 12,000 2026 9 Wood Chipper (Replace #8161) (Purchased 2014)Pub Works 45,000 5,000 (3)50,000 0 325,000 481,575 50,000 0 0 0 0 50,000 14,425 4,425 6,675 0 (3,000)929,100 Total CIP Funding Requirements - Year 2026 $806,575 $0 (#)These items will be funded with the issuance of Equipment Certificates. (1)Ice Resurfacer funding comes from Arena Fund operations/reserves.$0 (2)Highlighted items are part of a lease program. This is a summary of the total for the year. Detail is provided in an accompanying document. (3)Other funding for Public Works equipment comes from trade-in value of old vehicles. Total Building CIP levy for 2026 is $0. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). Total Street CIP levy for 2026 is $1,048,255. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). Total Equipment CIP levy for 2026 is $760,000. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). 9 of 11 MSA 11/16/18 Building Funds & Facilities Street Equipment Park Imp From Water Sewer Storm Water Sewer Storm Debt Serv Total Year Item - Description Department CIP CIP CIP Assess Fund State Core Core Core Utility Utility Utility Levy Other Cost 2027 1 PC Workstation Upgrades (From 2022) (Police, Fire, P.W.)Finance 80,000 80,000 2027 2 City-Wide Software Gen'l. Govt.25,000 25,000 2027 3 Squad Set Up and Equipment Installation Police 65,000 65,000 2027 4 Lease Program - Year 10 Police 129,000 (40,000)(2)89,000 2027 5 Pedestrian Improvements Program Pub Works 125,000 125,000 2027 6 PMP (Bloomfield A/B)Pub Works 950,000 275,000 60,000 185,000 75,000 1,545,000 2027 7 Lease Program - Year 10 Pub Works 221,275 14,925 4,925 7,675 (90,000)(2)158,800 2027 8 Groundsmaster Mower (Replace #8068) (Purchased 2018)Pub Works 85,000 10,000 (3)95,000 2027 9 Dump Single (Replace #8437) (2014 Vehicle)Pub Works 170,000 40,000 (3)210,000 2027 10 Sweeper (Replace #8444) (Purchased 2017)Pub Works 110,000 110,000 20,000 (3)240,000 0 1,075,000 885,275 275,000 0 0 0 0 0 74,925 189,925 192,675 0 (60,000)2,632,800 Total CIP Funding Requirements - Year 2027 $1,960,275 $0 (#)These items will be funded with the issuance of Equipment Certificates. (1)xxxxxxxxxxxx funding comes from Arena Fund operations/reserves.$0 (2)Highlighted items are part of a lease program. This is a summary of the total for the year. Detail is provided in an accompanying document. (3)Other funding for Public Works equipment comes from trade-in value of old vehicles. Total Building CIP levy for 2027 is $0. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). Total Street CIP levy for 2027 is $1,079,702. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). Total Equipment CIP levy for 2027 is $780,000. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). 10 of 11 MSA 11/16/18 Building Funds & Facilities Street Equipment Park Imp From Water Sewer Storm Water Sewer Storm Debt Serv Total Year Item - Description Department CIP CIP CIP Assess Fund State Core Core Core Utility Utility Utility Levy Other Cost 2028 1 City-Wide Software Gen'l. Govt.25,000 25,000 2028 2 Squad Set Up and Equipment Installation Police 40,000 40,000 2028 3 Lease Program - Year 11 Police 129,400 (24,000)(2)105,400 2028 4 Pedestrian Improvements Program Pub Works 125,000 125,000 2028 5 PMP (Motz, Rosemount Hills A/B)Pub Works 1,300,000 400,000 65,000 190,000 75,000 2,030,000 2028 6 Lease Program - Year 11 Pub Works 229,275 16,925 4,925 7,675 (99,000)(2)159,800 2028 7 Bobcat (Replace #8420) (2018 Vehicle)Pub Works 40,000 40,000 20,000 (3)100,000 2028 8 Single-Axle Dump Truck (Replace #8433) (2016 Vehicle)Pub Works 185,000 35,000 (3)220,000 2028 9 Tandem-Axle Dump Truck (Replace #8435) (2016 Vehicle)Pub Works 210,000 40,000 (3)250,000 0 1,425,000 858,675 400,000 0 0 0 0 0 81,925 194,925 122,675 0 (28,000)3,055,200 Total CIP Funding Requirements - Year 2028 $2,283,675 $0 (#)These items will be funded with the issuance of Equipment Certificates. (1)xxxxxxxxxxxx funding comes from Arena Fund operations/reserves.$0 (2)Highlighted items are part of a lease program. This is a summary of the total for the year. Detail is provided in an accompanying document. (3)Other funding for Public Works equipment comes from trade-in value of old vehicles. Total Building CIP levy for 2028 is $0. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). Total Street CIP levy for 2028 is $1,112,093. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). Total Equipment CIP levy for 2028 is $800,000. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). 11 of 11 MSA 11/16/18 Building Funds & Facilities Street Equipment Park Imp From Water Sewer Storm Water Sewer Storm Debt Serv Total Year Item - Description Department CIP CIP CIP Assess Fund State Core Core Core Utility Utility Utility Levy Other Cost Future 1 Splash Pad Water Reuse Project Council 750,000 (1)750,000 Future 2 Public Works / City Hall Building Expansion / Police Council 5,000,000 (2)5,000,000 Future 3 Tender Truck (Addition) Fire 180,000 (3)180,000 Future 4 Engine Truck (Addition) Fire 700,000 (4)700,000 Future 5 Add Fire Station #3 (Same time as additional Engine Truck)Fire (4) Future 6 ADA Compliant Upgrades Study Park & Rec 20,000 20,000 Future 7 Community Center Covered Walk Park & Rec 175,000 175,000 Future 8 Flint Hills Athletic Fields Improvements - Phase 3 (Building)Park & Rec 800,000 800,000 Future 9 TH 3 Aesthetic Improvements Pub Works 448,500 (5)448,500 Future 10 North Central Sanitary Sewer Extension Pub Works (6) Future 11 Street Construction - Boulder Avenue Extension Pub Works 3,000,000 (7)3,000,000 Future 12 Shannon Pond Outlet Pub Works (8) Future 13 Gravel Road Improvements Pub Works (8) Future 14 Akron Avenue South of County Road 42 Pub Works 1,250,000 1,250,000 Future 15 CSAH 46 Improvements (2-Lane to 4-Lane Expansion)Pub Works (9) Future 16 Soccer Goal Trailer (Replace #0501) (Purchased 1980)Pub Works 5,000 5,000 Future 17 Hose Trailer (Replace #0502) (Purchased 1990)Pub Works 5,000 5,000 Future 18 Barricade Trailer (Replace #0510) (Purchased 1986)Pub Works 5,000 5,000 Future 19 Hose Trailer (Replace #0517) (Purchased 1995)Pub Works 5,000 5,000 Future 20 Striper Trailer (Replace #0518) (Purchased 1994)Pub Works 5,000 5,000 Future 21 Easement Trailer (Replace #0521) (Purchased 2003)Pub Works 5,000 5,000 Future 22 Puppet Trailer (Replace #0515) (Purchased 1991)Pub Works 8,000 8,000 Future 23 Fire House Trailer (Replace #0519) (Purchased 1994)Pub Works 40,000 40,000 Future 24 Surveillance Trailer (Replace #0523) (Purchased 2008)Pub Works 40,000 40,000 Future 25 Blower Attach for #8071 & #8072 (Replace #0119) (2001)Pub Works 7,500 7,500 Future 26 Crash Attenuator (Replace #0049) (Purchased 2007)Pub Works 20,000 20,000 975,000 0 750,000 0 0 1,250,000 0 0 0 0 0 0 0 9,378,500 12,353,500 Total CIP Funding Requirements - Future Years $1,725,000 $0 (#)These items will be funded with the issuance of Equipment Certificates.$0 (1)Funding and timing for the splash pad water resuse project still to be determined. (2)Funding for the City Hall Expansion ($1,000,000) & PW Building Expansion ($4,000,000) will come from a general bond issue. (3)Funding and timing of purchase of Tender Truck (Addition) still to be determined. (4)Timing for Fire Station #3 and Additional Engine Truck still to be determined. (5)Other funding for TH 3 projects will come from grants or other incentives. (6)Future costs associated with the sanitary sewer will include extensive street reconstruction on the following streets: 124th St, 125th St, Blanca Ave W, 128th St, Bolivia Ave, 130th St W, Biscayne Ave, Bengal Ave, 129th St W, CR 38, 132nd Court and Bonnaire Path. Costs and funding are not available at this time. (7)Other funding for Boulder Avenue extension will come from a Port Authority bond issue. (8)Costs and funding are not available at this time. (9)Further Council discussion and approval required prior to any project work being undertaken. 11/16/18 Equipment Total Year Item - Description Department CIP Other Cost 2018 Jeep Cherokee (Replaced DTF Vehicle) - LEASE Police 6,634 6,634 2018 Dodge Caravan (Replaced #35120) - LEASE Police 5,929 (3,000)(1)2,929 2018 Jeep Cherokee (Replaced 35150) - LEASE Police 7,189 7,189 2018 Ford Police Explorer (Replaced 3520) - LEASE Police 6,819 (8,000)(1)(1,181) 2018 Ford Police Explorer (Replaced 3580) - LEASE Police 6,819 (8,000)(1)(1,181) 2018 Ford Police Explorer (Replaced 35100) - LEASE Police 6,819 (8,000)(1)(1,181) 40,209 (27,000)13,209 Total Lease Funding Requirements - Year 2018 $40,209 (1)Equipment CIP cost is the total annual lease which will be reduced by the resale value in the first year. 11/16/18 Equipment Total Year Item - Description Department CIP Other Cost 2018 Jeep Cherokee (Replaced DTF Vehicle) - LEASE Police 6,634 6,634 2018 Dodge Caravan (Replaced #35120) - LEASE Police 5,929 5,929 2018 Jeep Cherokee (Replaced 35150) - LEASE Police 7,189 7,189 2018 Ford Police Explorer (Replaced 3520) - LEASE Police 6,819 6,819 2018 Ford Police Explorer (Replaced 3580) - LEASE Police 6,819 6,819 2018 Ford Police Explorer (Replaced 35100) - LEASE Police 6,819 6,819 2019 Ford Vehicle (Replace 35010) - LEASE Police 6,900 (9,500)(1)(2,600) 2019 Ford Police Explorer (Replaced 35110) - LEASE Police 7,100 (8,000)(1)(900) 2019 Ford Police Explorer (Replaced 35170) - LEASE Police 7,100 (13,000)(1)(5,900) . 61,309 (30,500)30,809 Total Lease Funding Requirements - Year 2019 $61,309 (1)Equipment CIP cost is the total annual lease which will be reduced by the resale value in the first year. Other funding is the resale for the vehicle. 11/16/18 Equipment Total Year Item - Description Department CIP Other Cost 2018 Jeep Cherokee (Replaced DTF Vehicle) - LEASE Police 6,634 6,634 2018 Dodge Caravan (Replaced #35120) - LEASE Police 5,929 5,929 2018 Jeep Cherokee (Replaced 35150) - LEASE Police 7,189 7,189 2018 Ford Police Explorer (Replaced 3520) - LEASE Police 6,819 6,819 2018 Ford Police Explorer (Replaced 3580) - LEASE Police 6,819 6,819 2018 Ford Police Explorer (Replaced 35100) - LEASE Police 6,819 6,819 2019 Ford Vehicle (Replace 35010) - LEASE Police 6,900 6,900 2019 Ford Police Explorer (Replaced 35110) - LEASE Police 7,100 7,100 2019 Ford Police Explorer (Replaced 35170) - LEASE Police 7,100 7,100 2020 Ford Police Explorer (Replaced 3540) - LEASE Police 7,300 (8,000)(1)(700) 2020 Dodge Truck (Replaced 3550) - LEASE Police 7,300 (14,000)(1)(6,700) 2020 Ford Police Explorer (Replaced 3590) - LEASE Police 7,300 (8,000)(1)(700) 83,209 (30,000)53,209 Total Lease Funding Requirements - Year 2020 $83,209 (1)Equipment CIP cost is the total annual lease which will be reduced by the resale value in the first year. Other funding is the resale for the vehicle. 11/16/18 Equipment Total Year Item - Description Department CIP Other Cost 2018 Jeep Cherokee (Replaced DTF Vehicle) - LEASE Police 6,634 6,634 2018 Dodge Caravan (Replaced #35120) - LEASE Police 5,929 5,929 2018 Jeep Cherokee (Replaced 35150) - LEASE Police 7,189 7,189 2018 Ford Police Explorer (Replaced 3520) - LEASE Police 6,819 6,819 2018 Ford Police Explorer (Replaced 3580) - LEASE Police 6,819 6,819 2018 Ford Police Explorer (Replaced 35100) - LEASE Police 6,819 6,819 2019 Ford Vehicle (Replace 35010) - LEASE Police 6,900 6,900 2019 Ford Police Explorer (Replaced 35110) - LEASE Police 7,100 7,100 2019 Ford Police Explorer (Replaced 35170) - LEASE Police 7,100 7,100 2020 Ford Police Explorer (Replaced 3540) - LEASE Police 7,300 7,300 2020 Dodge Truck (Replaced 3550) - LEASE Police 7,300 7,300 2020 Ford Police Explorer (Replaced 3590) - LEASE Police 7,300 7,300 2021 Ford Police Explorer (Replaced 3530) - LEASE Police 7,500 (8,000)(1)(500) 2021 Ford Police Explorer (Replaced 3560) - LEASE Police 7,500 (8,000)(1)(500) 2021 Ford Police Explorer (Replaced 3570) - LEASE Police 7,500 (8,000)(1)(500) 2021 Ford Police Explorer (Replaced 35140) - LEASE Police 7,500 (8,000)(1)(500) 113,209 (32,000)81,209 Total Lease Funding Requirements - Year 2021 $113,209 (1)Equipment CIP cost is the total annual lease which will be reduced by the resale value in the first year. Other funding is the resale for the vehicle. 11/16/18 Equipment Total Year Item - Description Department CIP Other Cost 2018 Dodge Caravan (Replaced #35120) - LEASE Police 5,929 5,929 2018 Jeep Cherokee (Replaced 35150) - LEASE Police 7,189 7,189 2019 Ford Vehicle (Replace 35010) - LEASE Police 6,900 6,900 2019 Ford Police Explorer (Replaced 35110) - LEASE Police 7,100 7,100 2019 Ford Police Explorer (Replaced 35170) - LEASE Police 7,100 7,100 2020 Ford Police Explorer (Replaced 3540) - LEASE Police 7,300 7,300 2020 Dodge Truck (Replaced 3550) - LEASE Police 7,300 7,300 2020 Ford Police Explorer (Replaced 3590) - LEASE Police 7,300 7,300 2021 Ford Police Explorer (Replaced 3530) - LEASE Police 7,500 7,500 2021 Ford Police Explorer (Replaced 3560) - LEASE Police 7,500 7,500 2021 Ford Police Explorer (Replaced 3570) - LEASE Police 7,500 7,500 2021 Ford Police Explorer (Replaced 35140) - LEASE Police 7,500 7,500 2022 Ford Police Explorer (Replaced 35160) - LEASE Police 7,000 (9,500)(1)(2,500) 2022 Ford Police Explorer (Replaced 3520) - LEASE Police 7,700 (9,500)(1)(1,800) 2022 Ford Police Explorer (Replaced 3580) - LEASE Police 7,700 (9,500)(1)(1,800) 2022 Ford Police Explorer (Replaced 35100) - LEASE Police 7,700 (9,500)(1)(1,800) 116,218 (38,000)78,218 Total Lease Funding Requirements - Year 2022 $116,218 (1)Equipment CIP cost is the total annual lease which will be reduced by the resale value in the first year. Other funding is the resale for the vehicle. 11/16/18 Equipment Total Year Item - Description Department CIP Other Cost 2020 Ford Police Explorer (Replaced 3540) - LEASE Police 7,300 7,300 2020 Dodge Truck (Replaced 3550) - LEASE Police 7,300 7,300 2020 Ford Police Explorer (Replaced 3590) - LEASE Police 7,300 7,300 2021 Ford Police Explorer (Replaced 3530) - LEASE Police 7,500 7,500 2021 Ford Police Explorer (Replaced 3560) - LEASE Police 7,500 7,500 2021 Ford Police Explorer (Replaced 3570) - LEASE Police 7,500 7,500 2021 Ford Police Explorer (Replaced 35140) - LEASE Police 7,500 7,500 2022 Jeep Cherokee (Replaced 35160) - LEASE Police 7,000 7,000 2022 Ford Police Explorer (Replaced 3520) - LEASE Police 7,700 7,700 2022 Ford Police Explorer (Replaced 3580) - LEASE Police 7,700 7,700 2022 Ford Police Explorer (Replaced 35100) - LEASE Police 7,700 7,700 2023 Ford Police Explorer (Replaced 3510) - LEASE Police 7,900 (8,000)(1)(100) 2023 Ford Police Explorer (Replaced 35110) - LEASE Police 7,900 (8,000)(1)(100) 2023 Ford Police Explorer (Replaced 35170) - LEASE Police 7,900 (8,000)(1)(100) 2023 Dodge Caravan (Replaced 35120) - LEASE Police 6,500 (8,000)(1)(1,500) 2023 Jeep Cherokee (Replaced 35150) - LEASE Police 7,500 (8,000)(1)(500) 119,700 (40,000)79,700 Total Lease Funding Requirements - Year 2023 $119,700 (1)Equipment CIP cost is the total annual lease which will be reduced by the resale value in the first year. Other funding is the resale for the vehicle. 11/16/18 Equipment Total Year Item - Description Department CIP Other Cost 2021 Ford Police Explorer (Replaced 3530) - LEASE Police 7,500 7,500 2021 Ford Police Explorer (Replaced 3560) - LEASE Police 7,500 7,500 2021 Ford Police Explorer (Replaced 3570) - LEASE Police 7,500 7,500 2021 Ford Police Explorer (Replaced 35140) - LEASE Police 7,500 7,500 2022 Jeep Cherokee (Replaced 35160) - LEASE Police 7,000 7,000 2022 Ford Police Explorer (Replaced 3520) - LEASE Police 7,700 7,700 2022 Ford Police Explorer (Replaced 3580) - LEASE Police 7,700 7,700 2022 Ford Police Explorer (Replaced 35100) - LEASE Police 7,700 7,700 2023 Ford Police Explorer (Replaced 3510) - LEASE Police 7,900 7,900 2023 Ford Police Explorer (Replaced 35110) - LEASE Police 7,900 7,900 2023 Ford Police Explorer (Replaced 35170) - LEASE Police 7,900 7,900 2023 Dodge Caravan (Replaced 35120) - LEASE Police 6,500 6,500 2023 Jeep Cherokee (Replaced 35150) - LEASE Police 7,500 7,500 2024 Ford Police Explorer (Replaced 3540) - LEASE Police 8,100 (8,000)(1)100 2024 Dodge Truck (Replaced 3550) - LEASE Police 7,500 (10,000)(1)(2,500) 2024 Ford Police Explorer (Replaced 3590) - LEASE Police 8,100 (8,000)(1)100 121,500 (26,000)95,500 Total Lease Funding Requirements - Year 2024 $121,500 (1)Equipment CIP cost is the total annual lease which will be reduced by the resale value in the first year. Other funding is the resale for the vehicle. 11/16/18 Equipment Total Year Item - Description Department CIP Other Cost 2022 Jeep Cherokee (Replaced 35160) - LEASE Police 7,000 7,000 2022 Ford Police Explorer (Replaced 3520) - LEASE Police 7,700 7,700 2022 Ford Police Explorer (Replaced 3580) - LEASE Police 7,700 7,700 2022 Ford Police Explorer (Replaced 35100) - LEASE Police 7,700 7,700 2023 Ford Police Explorer (Replaced 3510) - LEASE Police 7,900 7,900 2023 Ford Police Explorer (Replaced 35110) - LEASE Police 7,900 7,900 2023 Ford Police Explorer (Replaced 35170) - LEASE Police 7,900 7,900 2023 Dodge Caravan (Replaced 35120) - LEASE Police 6,500 6,500 2023 Jeep Cherokee (Replaced 35150) - LEASE Police 7,500 7,500 2024 Ford Police Explorer (Replaced 3540) - LEASE Police 8,100 8,100 2024 Dodge Truck (Replaced 3550) - LEASE Police 7,500 7,500 2024 Ford Police Explorer (Replaced 3590) - LEASE Police 8,100 8,100 2025 Ford Police Explorer (Replaced 3530) - LEASE Police 8,300 (8,000)(1)300 2025 Ford Police Explorer (Replaced 3560) - LEASE Police 8,300 (8,000)(1)300 2025 Ford Police Explorer (Replaced 3570) - LEASE Police 8,300 (8,000)(1)300 2025 Ford Police Explorer (Replaced 35140) - LEASE Police 8,300 (8,000)(1)300 124,700 (32,000)92,700 Total Lease Funding Requirements - Year 2025 $124,700 (1)Equipment CIP cost is the total annual lease which will be reduced by the resale value in the first year. Other funding is the resale for the vehicle. 11/16/18 Equipment Total Year Item - Description Department CIP Other Cost 2023 Ford Police Explorer (Replaced 3510) - LEASE Police 7,900 7,900 2023 Ford Police Explorer (Replaced 35110) - LEASE Police 7,900 7,900 2023 Ford Police Explorer (Replaced 35170) - LEASE Police 7,900 7,900 2023 Dodge Caravan (Replaced 35120) - LEASE Police 6,500 6,500 2023 Jeep Cherokee (Replaced 35150) - LEASE Police 7,500 7,500 2024 Ford Police Explorer (Replaced 3540) - LEASE Police 8,100 8,100 2024 Dodge Truck (Replaced 3550) - LEASE Police 7,500 7,500 2024 Ford Police Explorer (Replaced 3590) - LEASE Police 8,100 8,100 2025 Ford Police Explorer (Replaced 3530) - LEASE Police 8,300 8,300 2025 Ford Police Explorer (Replaced 3560) - LEASE Police 8,300 8,300 2025 Ford Police Explorer (Replaced 3570) - LEASE Police 8,300 8,300 2025 Ford Police Explorer (Replaced 35140) - LEASE Police 8,300 8,300 2026 Jeep Cherokee (Replaced 35160) - LEASE Police 7,800 (8,000)(1)(200) 2026 Ford Police Explorer (Replaced 3520) - LEASE Police 8,300 (8,000)(1)300 2026 Ford Police Explorer (Replaced 3580) - LEASE Police 8,300 (8,000)(1)300 2026 Ford Police Explorer (Replaced 35100) - LEASE Police 8,300 (8,000)(1)300 127,300 (32,000)95,300 Total Lease Funding Requirements - Year 2026 $127,300 (1)Equipment CIP cost is the total annual lease which will be reduced by the resale value in the first year. Other funding is the resale for the vehicle. 11/16/18 Equipment Total Year Item - Description Department CIP Other Cost 2024 Ford Police Explorer (Replaced 3540) - LEASE Police 8,100 8,100 2024 Dodge Truck (Replaced 3550) - LEASE Police 7,500 7,500 2024 Ford Police Explorer (Replaced 3590) - LEASE Police 8,100 8,100 2025 Ford Police Explorer (Replaced 3530) - LEASE Police 8,300 8,300 2025 Ford Police Explorer (Replaced 3560) - LEASE Police 8,300 8,300 2025 Ford Police Explorer (Replaced 3570) - LEASE Police 8,300 8,300 2025 Ford Police Explorer (Replaced 35140) - LEASE Police 8,300 8,300 2026 Jeep Cherokee (Replaced 35160) - LEASE Police 7,800 7,800 2026 Ford Police Explorer (Replaced 3520) - LEASE Police 8,300 8,300 2026 Ford Police Explorer (Replaced 3580) - LEASE Police 8,300 8,300 2026 Ford Police Explorer (Replaced 35100) - LEASE Police 8,300 8,300 2027 Ford Police Explorer (Replaced 3510) - LEASE Police 8,300 (8,000)(1)300 2027 Ford Police Explorer (Replaced 35110) - LEASE Police 8,300 (8,000)(1)300 2027 Ford Police Explorer (Replaced 35170) - LEASE Police 8,300 (8,000)(1)300 2027 Dodge Caravan (Replaced 35120) - LEASE Police 7,000 (8,000)(1)(1,000) 2027 Jeep Cherokee (Replaced 35150) - LEASE Police 7,500 (8,000)(1)(500) 129,000 (40,000)89,000 Total Lease Funding Requirements - Year 2027 $129,000 (1)Equipment CIP cost is the total annual lease which will be reduced by the resale value in the first year. Other funding is the resale for the vehicle. 11/16/18 Equipment Total Year Item - Description Department CIP Other Cost 2025 Ford Police Explorer (Replaced 3530) - LEASE Police 8,300 8,300 2025 Ford Police Explorer (Replaced 3560) - LEASE Police 8,300 8,300 2025 Ford Police Explorer (Replaced 3570) - LEASE Police 8,300 8,300 2025 Ford Police Explorer (Replaced 35140) - LEASE Police 8,300 8,300 2026 Jeep Cherokee (Replaced 35160) - LEASE Police 7,800 7,800 2026 Ford Police Explorer (Replaced 3520) - LEASE Police 8,300 8,300 2026 Ford Police Explorer (Replaced 3580) - LEASE Police 8,300 8,300 2026 Ford Police Explorer (Replaced 35100) - LEASE Police 8,300 8,300 2027 Ford Police Explorer (Replaced 3510) - LEASE Police 8,300 8,300 2027 Ford Police Explorer (Replaced 35110) - LEASE Police 8,300 8,300 2027 Ford Police Explorer (Replaced 35170) - LEASE Police 8,300 8,300 2027 Dodge Caravan (Replaced 35120) - LEASE Police 7,000 7,000 2027 Jeep Cherokee (Replaced 35150) - LEASE Police 7,500 7,500 2028 Ford Police Explorer (Replaced 3540) - LEASE Police 8,300 (8,000)(1)300 2028 Dodge Truck (Replaced 3550) - LEASE Police 7,500 (8,000)(1)(500) 2028 Ford Police Explorer (Replaced 3590) - LEASE Police 8,300 (8,000)(1)300 129,400 (24,000)105,400 Total Lease Funding Requirements - Year 2028 $129,400 (1)Equipment CIP cost is the total annual lease which will be reduced by the resale value in the first year. Other funding is the resale for the vehicle. 11/16/18 Equipment Water Sewer Storm Debt Serv Total YR 2 Item - Description Department CIP Utility Utility Utility Levy Other Cost 2018 1-Ton Pickup w/Dump (Replace #8310) (2003 Vehicle) - LEASE Pub Works 10,360 10,360 2018 1/2-Ton Ex-Cab Pickup (Replace #8329) (2006 Vehicle) - LEASE Pub Works 6,852 6,852 2018 1-Ton Pickup w/Dump (Replace #8340) (2006 Vehicle) - LEASE Pub Works 11,115 11,115 2018 1-Ton Pickup (Replace #8345) (2007 Vehicle) - LEASE Pub Works 8,418 8,418 2018 1/2-Ton Ex-Cab Pickup (Replace #8346) (2006 Vehicle) - LEASE Pub Works 6,020 6,020 2019 1-Ton Pickup Extended Cab (Replace #8330) (2011 Vehicle) - LEASE Pub Works 7,500 (12,000)(1)(4,500) 2019 1-Ton Pickup (Replace #8341) (2011 Vehicle) - LEASE Pub Works 7,500 (16,000)(1)(8,500) 2019 Full Size Van - Park & Rec (Replace #8601) (2003 Vehicle) - LEASE Pub Works 5,000 (3,000)(1)2,000 2019 Caravan - Parks (Replace #8603) (2013 Vehicle) - LEASE Pub Works 4,000 (10,000)(1)(6,000) 2019 Ford Ranger - Inspections (Replace #8615) (2008 Vehicle) - LEASE Pub Works 4,000 (3,500)(1)500 . 62,347 8,418 0 0 0 (44,500)26,265 Total Lease Funding Requirements - Year 2019 $62,347 (1)Equipment CIP cost is the total annual lease which will be reduced by the resale value in the first year. Other funding is the resale for the vehicle. 11/16/18 Equipment Water Sewer Storm Debt Serv Total YR 3 Item - Description Department CIP Utility Utility Utility Levy Other Cost 2018 1-Ton Pickup w/Dump (Replace #8310) (2003 Vehicle) - LEASE Pub Works 10,360 10,360 2018 1/2-Ton Ex-Cab Pickup (Replace #8329) (2006 Vehicle) - LEASE Pub Works 6,852 6,852 2018 1-Ton Pickup w/Dump (Replace #8340) (2006 Vehicle) - LEASE Pub Works 11,115 11,115 2018 1-Ton Pickup (Replace #8345) (2007 Vehicle) - LEASE Pub Works 8,418 8,418 2018 1/2-Ton Ex-Cab Pickup (Replace #8346) (2006 Vehicle) - LEASE Pub Works 6,020 6,020 2019 1-Ton Pickup Extended Cab (Replace #8330) (2011 Vehicle) - LEASE Pub Works 7,500 7,500 2019 1-Ton Pickup (Replace #8341) (2011 Vehicle) - LEASE Pub Works 7,500 7,500 2019 Full Size Van - Park & Rec (Replace #8601) (2003 Vehicle) - LEASE Pub Works 5,000 5,000 2019 Caravan - Parks (Replace #8603) (2013 Vehicle) - LEASE Pub Works 4,000 4,000 2019 Ford Ranger - Inspections (Replace #8615) (2008 Vehicle) - LEASE Pub Works 4,000 4,000 2020 1-Ton Pickup w/Dump (Replace #8306) (2016 Vehicle) - LEASE Pub Works 12,500 (18,000)(1)(5,500) 2020 1-Ton Pickup (Replace #8311) (2016 Vehicle) - LEASE Pub Works 7,700 (16,000)(1)(8,300) 2020 1-Ton Pickup (Replace #8312) (2016 Vehicle) - LEASE Pub Works 1,925 1,925 1,925 1,925 (16,000)(1)(8,300) 2020 1-Ton Pickup - Irrigation (Replace #8331) (2015 Vehicle) - LEASE Pub Works 9,000 (14,000)(1)(5,000) 2020 1-Ton Pickup (Replace #8332) (2015 Vehicle) - LEASE Pub Works 7,700 (17,000)(1)(9,300) 2020 1-Ton Pickup (Replace #8334) (2015 Vehicle) - LEASE Pub Works 7,700 (18,000)(1)(10,300) 108,872 10,343 1,925 1,925 0 (99,000)24,065 Total Lease Funding Requirements - Year 2020 $108,872 (1)Equipment CIP cost is the total annual lease which will be reduced by the resale value in the first year. Other funding is the resale for the vehicle. 11/16/18 Equipment Water Sewer Storm Debt Serv Total YR 4 Item - Description Department CIP Utility Utility Utility Levy Other Cost 2018 1-Ton Pickup w/Dump (Replace #8310) (2003 Vehicle) - LEASE Pub Works 10,360 10,360 2018 1/2-Ton Ex-Cab Pickup (Replace #8329) (2006 Vehicle) - LEASE Pub Works 6,852 6,852 2018 1-Ton Pickup w/Dump (Replace #8340) (2006 Vehicle) - LEASE Pub Works 11,115 11,115 2018 1-Ton Pickup (Replace #8345) (2007 Vehicle) - LEASE Pub Works 8,418 8,418 2018 1/2-Ton Ex-Cab Pickup (Replace #8346) (2006 Vehicle) - LEASE Pub Works 6,020 6,020 2019 1-Ton Pickup Extended Cab (Replace #8330) (2011 Vehicle) - LEASE Pub Works 7,500 7,500 2019 1-Ton Pickup (Replace #8341) (2011 Vehicle) - LEASE Pub Works 7,500 7,500 2019 Full Size Van - Park & Rec (Replace #8601) (2003 Vehicle) - LEASE Pub Works 5,000 5,000 2019 Caravan - Parks (Replace #8603) (2013 Vehicle) - LEASE Pub Works 4,000 4,000 2019 Ford Ranger - Inspections (Replace #8615) (2008 Vehicle) - LEASE Pub Works 4,000 4,000 2020 1-Ton Pickup w/Dump (Replace #8306) (2016 Vehicle) - LEASE Pub Works 12,500 12,500 2020 1-Ton Pickup (Replace #8311) (2016 Vehicle) - LEASE Pub Works 7,700 7,700 2020 1-Ton Pickup (Replace #8312) (2016 Vehicle) - LEASE Pub Works 1,925 1,925 1,925 1,925 7,700 2020 1-Ton Pickup - Irrigation (Replace #8331) (2015 Vehicle) - LEASE Pub Works 9,000 9,000 2020 1-Ton Pickup (Replace #8332) (2015 Vehicle) - LEASE Pub Works 7,700 7,700 2020 1-Ton Pickup (Replace #8334) (2015 Vehicle) - LEASE Pub Works 7,700 7,700 2021 Escape 4x4 (Replace #8303) (2016 Vehicle) - LEASE Pub Works 5,000 (14,000)(1)(9,000) 2021 1/2-Ton Pickup (Replace #8307) (2015 Vehicle) - LEASE Pub Works 7,500 (12,000)(1)(4,500) 2021 1/2-Ton Pickup (Replace #8335) (2015 Vehicle) - LEASE Pub Works 7,500 (12,000)(1)(4,500) 2021 1-Ton Pickup (Replace #8336) (2016 Vehicle) - LEASE Pub Works 8,500 (14,000)(1)(5,500) 2021 1/2-Ton Pickup (Replace #8343) (2016 Vehicle) - LEASE Pub Works 7,500 (12,000)(1)(4,500) 2021 1-Ton Pickup w/Dump (Replace #8344) (2016 Vehicle) - LEASE Pub Works 12,500 (18,000)(1)(5,500) 157,372 10,343 1,925 1,925 0 (82,000)89,565 Total Lease Funding Requirements - Year 2021 $157,372 (1)Equipment CIP cost is the total annual lease which will be reduced by the resale value in the first year. Other funding is the resale for the vehicle. 11/16/18 Equipment Water Sewer Storm Debt Serv Total YR 5 Item - Description Department CIP Utility Utility Utility Levy Other Cost 2018 1-Ton Pickup w/Dump (Replace #8310) (2003 Vehicle) - LEASE Pub Works 10,360 10,360 2018 1/2-Ton Ex-Cab Pickup (Replace #8329) (2006 Vehicle) - LEASE Pub Works 6,852 6,852 2018 1-Ton Pickup w/Dump (Replace #8340) (2006 Vehicle) - LEASE Pub Works 11,115 11,115 2018 1-Ton Pickup (Replace #8345) (2007 Vehicle) - LEASE Pub Works 8,418 8,418 2018 1/2-Ton Ex-Cab Pickup (Replace #8346) (2006 Vehicle) - LEASE Pub Works 6,020 6,020 2019 1-Ton Pickup Extended Cab (Replace #8330) (2011 Vehicle) - LEASE Pub Works 7,500 7,500 2019 1-Ton Pickup (Replace #8341) (2011 Vehicle) - LEASE Pub Works 7,500 7,500 2019 Full Size Van - Park & Rec (Replace #8601) (2003 Vehicle) - LEASE Pub Works 5,000 5,000 2019 Caravan - Parks (Replace #8603) (2013 Vehicle) - LEASE Pub Works 4,000 4,000 2019 Ford Ranger - Inspections (Replace #8615) (2008 Vehicle) - LEASE Pub Works 4,000 4,000 2020 1-Ton Pickup w/Dump (Replace #8306) (2016 Vehicle) - LEASE Pub Works 12,500 12,500 2020 1-Ton Pickup (Replace #8311) (2016 Vehicle) - LEASE Pub Works 7,700 7,700 2020 1-Ton Pickup (Replace #8312) (2016 Vehicle) - LEASE Pub Works 1,925 1,925 1,925 1,925 7,700 2020 1-Ton Pickup - Irrigation (Replace #8331) (2015 Vehicle) - LEASE Pub Works 9,000 9,000 2020 1-Ton Pickup (Replace #8332) (2015 Vehicle) - LEASE Pub Works 7,700 7,700 2020 1-Ton Pickup (Replace #8334) (2015 Vehicle) - LEASE Pub Works 7,700 7,700 2021 Escape 4x4 (Replace #8303) (2016 Vehicle) - LEASE Pub Works 5,000 5,000 2021 1/2-Ton Pickup (Replace #8307) (2015 Vehicle) - LEASE Pub Works 7,500 7,500 2021 1/2-Ton Pickup (Replace #8335) (2015 Vehicle) - LEASE Pub Works 7,500 7,500 2021 1-Ton Pickup (Replace #8336) (2016 Vehicle) - LEASE Pub Works 8,500 8,500 2021 1/2-Ton Pickup (Replace #8343) (2016 Vehicle) - LEASE Pub Works 7,500 7,500 2021 1-Ton Pickup w/Dump (Replace #8344) (2016 Vehicle) - LEASE Pub Works 12,500 12,500 2022 1-Ton Pickup (Replace #8308) (2017 Vehicle) - LEASE Pub Works 6,750 2,250 (17,000)(1)(8,000) 2022 1-Ton Pickup (Replace #8315) (2017 Vehicle) - LEASE Pub Works 9,000 (17,000)(1)(8,000) 2022 1/2-Ton Pickup (Replace #8333) (2017 Vehicle) - LEASE Pub Works 2,500 2,500 2,500 (12,000)(1)(4,500) 2022 1/2-Ton Pickup - Parks (Replace #8336) (2016 Vehicle) - LEASE Pub Works 7,500 (15,000)(1)(7,500) 2022 Escape 4x4 (Replace #8314) (2016 Vehicle) - LEASE Pub Works 5,500 (14,000)(1)(8,500) 2022 Caravan - Admin (Replace #8621) (2017 Vehicle) - LEASE Pub Works 5,500 (10,000)(1)(4,500) 191,622 12,843 4,425 6,675 0 (85,000)130,565 Total Lease Funding Requirements - Year 2022 $191,622 (1)Equipment CIP cost is the total annual lease which will be reduced by the resale value in the first year. Other funding is the resale for the vehicle. 11/16/18 Equipment Water Sewer Storm Debt Serv Total YR 6 Item - Description Department CIP Utility Utility Utility Levy Other Cost 2019 1-Ton Pickup Extended Cab (Replace #8330) (2011 Vehicle) - LEASE Pub Works 7,500 7,500 2019 1-Ton Pickup (Replace #8341) (2011 Vehicle) - LEASE Pub Works 7,500 7,500 2019 Full Size Van - Park & Rec (Replace #8601) (2003 Vehicle) - LEASE Pub Works 5,000 5,000 2019 Caravan - Parks (Replace #8603) (2013 Vehicle) - LEASE Pub Works 4,000 4,000 2019 Ford Ranger - Inspections (Replace #8615) (2008 Vehicle) - LEASE Pub Works 4,000 4,000 2020 1-Ton Pickup w/Dump (Replace #8306) (2016 Vehicle) - LEASE Pub Works 12,500 12,500 2020 1-Ton Pickup (Replace #8311) (2016 Vehicle) - LEASE Pub Works 7,700 7,700 2020 1-Ton Pickup (Replace #8312) (2016 Vehicle) - LEASE Pub Works 1,925 1,925 1,925 1,925 7,700 2020 1-Ton Pickup - Irrigation (Replace #8331) (2015 Vehicle) - LEASE Pub Works 9,000 9,000 2020 1-Ton Pickup (Replace #8332) (2015 Vehicle) - LEASE Pub Works 7,700 7,700 2020 1-Ton Pickup (Replace #8334) (2015 Vehicle) - LEASE Pub Works 7,700 7,700 2021 Escape 4x4 (Replace #8303) (2016 Vehicle) - LEASE Pub Works 5,000 5,000 2021 1/2-Ton Pickup (Replace #8307) (2015 Vehicle) - LEASE Pub Works 7,500 7,500 2021 1/2-Ton Pickup (Replace #8335) (2015 Vehicle) - LEASE Pub Works 7,500 7,500 2021 1-Ton Pickup (Replace #8336) (2016 Vehicle) - LEASE Pub Works 8,500 8,500 2021 1/2-Ton Pickup (Replace #8343) (2016 Vehicle) - LEASE Pub Works 7,500 7,500 2021 1-Ton Pickup w/Dump (Replace #8344) (2016 Vehicle) - LEASE Pub Works 12,500 12,500 2022 1-Ton Pickup (Replace #8308) (2017 Vehicle) - LEASE Pub Works 6,750 2,250 9,000 2022 1-Ton Pickup (Replace #8315) (2017 Vehicle) - LEASE Pub Works 9,000 9,000 2022 1/2-Ton Pickup (Replace #8333) (2017 Vehicle) - LEASE Pub Works 2,500 2,500 2,500 7,500 2022 1/2-Ton Pickup - Parks (Replace #8336) (2016 Vehicle) - LEASE Pub Works 7,500 7,500 2022 Escape 4x4 (Replace #8314) (2016 Vehicle) - LEASE Pub Works 5,500 5,500 2022 Caravan - Admin (Replace #8621) (2017 Vehicle) - LEASE Pub Works 5,500 5,500 2023 1-Ton Pickup w/Dump (Replace #8310) (2018 Vehicle) - LEASE Pub Works 13,000 (18,000)(1)(5,000) 2023 1/2-Ton Ex-Cab Pickup (Replace #8329) (2018 Vehicle) - LEASE Pub Works 8,000 (12,000)(1)(4,000) 2023 1-Ton Pickup w/Dump (Replace #8340) (2018 Vehicle) - LEASE Pub Works 13,000 (18,000)(1)(5,000) 2023 1-Ton Pickup (Replace #8345) (2018 Vehicle) - LEASE Pub Works 10,000 (17,000)(1)(7,000) 2023 1/2-Ton Ex-Cab Pickup (Replace #8346) (2018 Vehicle) - LEASE Pub Works 7,000 (12,000)(1)(5,000) 198,275 14,425 4,425 6,675 0 (77,000)146,800 Total Lease Funding Requirements - Year 2023 $198,275 (1)Equipment CIP cost is the total annual lease which will be reduced by the resale value in the first year. Other funding is the resale for the vehicle. 11/16/18 Equipment Water Sewer Storm Debt Serv Total YR 7 Item - Description Department CIP Utility Utility Utility Levy Other Cost 2020 1-Ton Pickup w/Dump (Replace #8306) (2016 Vehicle) - LEASE Pub Works 12,500 12,500 2020 1-Ton Pickup (Replace #8311) (2016 Vehicle) - LEASE Pub Works 7,700 7,700 2020 1-Ton Pickup (Replace #8312) (2016 Vehicle) - LEASE Pub Works 1,925 1,925 1,925 1,925 7,700 2020 1-Ton Pickup - Irrigation (Replace #8331) (2015 Vehicle) - LEASE Pub Works 9,000 9,000 2020 1-Ton Pickup (Replace #8332) (2015 Vehicle) - LEASE Pub Works 7,700 7,700 2020 1-Ton Pickup (Replace #8334) (2015 Vehicle) - LEASE Pub Works 7,700 7,700 2021 Escape 4x4 (Replace #8303) (2016 Vehicle) - LEASE Pub Works 5,000 5,000 2021 1/2-Ton Pickup (Replace #8307) (2015 Vehicle) - LEASE Pub Works 7,500 7,500 2021 1/2-Ton Pickup (Replace #8335) (2015 Vehicle) - LEASE Pub Works 7,500 7,500 2021 1-Ton Pickup (Replace #8336) (2016 Vehicle) - LEASE Pub Works 8,500 8,500 2021 1/2-Ton Pickup (Replace #8343) (2016 Vehicle) - LEASE Pub Works 7,500 7,500 2021 1-Ton Pickup w/Dump (Replace #8344) (2016 Vehicle) - LEASE Pub Works 12,500 12,500 2022 1-Ton Pickup (Replace #8308) (2017 Vehicle) - LEASE Pub Works 6,750 2,250 9,000 2022 1-Ton Pickup (Replace #8315) (2017 Vehicle) - LEASE Pub Works 9,000 9,000 2022 1/2-Ton Pickup (Replace #8333) (2017 Vehicle) - LEASE Pub Works 2,500 2,500 2,500 7,500 2022 1/2-Ton Pickup - Parks (Replace #8336) (2016 Vehicle) - LEASE Pub Works 7,500 7,500 2022 Escape 4x4 (Replace #8314) (2016 Vehicle) - LEASE Pub Works 5,500 5,500 2022 Caravan - Admin (Replace #8621) (2017 Vehicle) - LEASE Pub Works 5,500 5,500 2023 1-Ton Pickup w/Dump (Replace #8310) (2018 Vehicle) - LEASE Pub Works 13,000 13,000 2023 1/2-Ton Ex-Cab Pickup (Replace #8329) (2018 Vehicle) - LEASE Pub Works 8,000 8,000 2023 1-Ton Pickup w/Dump (Replace #8340) (2018 Vehicle) - LEASE Pub Works 13,000 13,000 2023 1-Ton Pickup (Replace #8345) (2018 Vehicle) - LEASE Pub Works 10,000 10,000 2023 1/2-Ton Ex-Cab Pickup (Replace #8346) (2018 Vehicle) - LEASE Pub Works 7,000 7,000 2024 1-Ton Pickup Extended Cab (Replace #8330) (2019 Vehicle) - LEASE Pub Works 9,000 (17,000)(1)(8,000) 2024 1-Ton Pickup (Replace #8341) (2019 Vehicle) - LEASE Pub Works 9,000 (17,000)(1)(8,000) 2024 Full Size Van - Park & Rec (Replace #8601) (2019 Vehicle) - LEASE Pub Works 6,500 (12,000)(1)(5,500) 2024 Caravan - Parks (Replace #8603) (2019 Vehicle) - LEASE Pub Works 5,000 (10,000)(1)(5,000) 2024 Excape 4x4 - Inspections (Replace #8615) (2019 Vehicle) - LEASE Pub Works 5,000 (10,000)(1)(5,000) 204,775 14,425 4,425 6,675 0 (66,000)164,300 Total Lease Funding Requirements - Year 2024 $204,775 (1)Equipment CIP cost is the total annual lease which will be reduced by the resale value in the first year. Other funding is the resale for the vehicle. 11/16/18 Equipment Water Sewer Storm Debt Serv Total YR 8 Item - Description Department CIP Utility Utility Utility Levy Other Cost 2021 Escape 4x4 (Replace #8303) (2016 Vehicle) - LEASE Pub Works 5,000 5,000 2021 1/2-Ton Pickup (Replace #8307) (2015 Vehicle) - LEASE Pub Works 7,500 7,500 2021 1/2-Ton Pickup (Replace #8335) (2015 Vehicle) - LEASE Pub Works 7,500 7,500 2021 1-Ton Pickup (Replace #8336) (2016 Vehicle) - LEASE Pub Works 8,500 8,500 2021 1/2-Ton Pickup (Replace #8343) (2016 Vehicle) - LEASE Pub Works 7,500 7,500 2021 1-Ton Pickup w/Dump (Replace #8344) (2016 Vehicle) - LEASE Pub Works 12,500 12,500 2022 1-Ton Pickup (Replace #8308) (2017 Vehicle) - LEASE Pub Works 6,750 2,250 9,000 2022 1-Ton Pickup (Replace #8315) (2017 Vehicle) - LEASE Pub Works 9,000 9,000 2022 1/2-Ton Pickup (Replace #8333) (2017 Vehicle) - LEASE Pub Works 2,500 2,500 2,500 7,500 2022 1/2-Ton Pickup - Parks (Replace #8336) (2016 Vehicle) - LEASE Pub Works 7,500 7,500 2022 Escape 4x4 (Replace #8314) (2016 Vehicle) - LEASE Pub Works 5,500 5,500 2022 Caravan - Admin (Replace #8621) (2017 Vehicle) - LEASE Pub Works 5,500 5,500 2023 1-Ton Pickup w/Dump (Replace #8310) (2018 Vehicle) - LEASE Pub Works 13,000 13,000 2023 1/2-Ton Ex-Cab Pickup (Replace #8329) (2018 Vehicle) - LEASE Pub Works 8,000 8,000 2023 1-Ton Pickup w/Dump (Replace #8340) (2018 Vehicle) - LEASE Pub Works 13,000 13,000 2023 1-Ton Pickup (Replace #8345) (2018 Vehicle) - LEASE Pub Works 10,000 10,000 2023 1/2-Ton Ex-Cab Pickup (Replace #8346) (2018 Vehicle) - LEASE Pub Works 7,000 7,000 2024 1-Ton Pickup Extended Cab (Replace #8330) (2019 Vehicle) - LEASE Pub Works 9,000 9,000 2024 1-Ton Pickup (Replace #8341) (2019 Vehicle) - LEASE Pub Works 9,000 9,000 2024 Full Size Van - Park & Rec (Replace #8601) (2019 Vehicle) - LEASE Pub Works 6,500 6,500 2024 Caravan - Parks (Replace #8603) (2019 Vehicle) - LEASE Pub Works 5,000 5,000 2024 Excape 4x4 - Inspections (Replace #8615) (2019 Vehicle) - LEASE Pub Works 5,000 5,000 2025 1-Ton Pickup w/Dump (Replace #8306) (2020 Vehicle) - LEASE Pub Works 12,500 (20,000)(1)(7,500) 2025 1-Ton Pickup (Replace #8311) (2020 Vehicle) - LEASE Pub Works 7,700 (17,000)(1)(9,300) 2025 1-Ton Pickup (Replace #8312) (2020. Vehicle) - LEASE Pub Works 1,925 1,925 1,925 1,925 (17,000)(1)(9,300) 2025 1-Ton Pickup - Irrigation (Replace #8331) (2020 Vehicle) - LEASE Pub Works 9,000 (17,000)(1)(8,000) 2025 1-Ton Pickup (Replace #8332) (2020 Vehicle) - LEASE Pub Works 7,700 (17,000)(1)(9,300) 2025 1-Ton Pickup (Replace #8334) (2020 Vehicle) - LEASE Pub Works 7,700 (17,000)(1)(9,300) 204,775 14,425 4,425 6,675 0 (105,000)125,300 Total Lease Funding Requirements - Year 2025 $204,775 (1)Equipment CIP cost is the total annual lease which will be reduced by the resale value in the first year. Other funding is the resale for the vehicle. 11/16/18 Equipment Water Sewer Storm Debt Serv Total YR 9 Item - Description Department CIP Utility Utility Utility Levy Other Cost 2022 1-Ton Pickup (Replace #8308) (2017 Vehicle) - LEASE Pub Works 6,750 2,250 9,000 2022 1-Ton Pickup (Replace #8315) (2017 Vehicle) - LEASE Pub Works 9,000 9,000 2022 1/2-Ton Pickup (Replace #8333) (2017 Vehicle) - LEASE Pub Works 2,500 2,500 2,500 7,500 2022 1/2-Ton Pickup - Parks (Replace #8336) (2016 Vehicle) - LEASE Pub Works 7,500 7,500 2022 Escape 4x4 (Replace #8314) (2016 Vehicle) - LEASE Pub Works 5,500 5,500 2022 Caravan - Admin (Replace #8621) (2017 Vehicle) - LEASE Pub Works 5,500 5,500 2023 1-Ton Pickup w/Dump (Replace #8310) (2018 Vehicle) - LEASE Pub Works 13,000 13,000 2023 1/2-Ton Ex-Cab Pickup (Replace #8329) (2018 Vehicle) - LEASE Pub Works 8,000 8,000 2023 1-Ton Pickup w/Dump (Replace #8340) (2018 Vehicle) - LEASE Pub Works 13,000 13,000 2023 1-Ton Pickup (Replace #8345) (2018 Vehicle) - LEASE Pub Works 10,000 10,000 2023 1/2-Ton Ex-Cab Pickup (Replace #8346) (2018 Vehicle) - LEASE Pub Works 7,000 7,000 2024 1-Ton Pickup Extended Cab (Replace #8330) (2019 Vehicle) - LEASE Pub Works 9,000 9,000 2024 1-Ton Pickup (Replace #8341) (2019 Vehicle) - LEASE Pub Works 9,000 9,000 2024 Full Size Van - Park & Rec (Replace #8601) (2019 Vehicle) - LEASE Pub Works 6,500 6,500 2024 Caravan - Parks (Replace #8603) (2019 Vehicle) - LEASE Pub Works 5,000 5,000 2024 Excape 4x4 - Inspections (Replace #8615) (2019 Vehicle) - LEASE Pub Works 5,000 5,000 2025 1-Ton Pickup w/Dump (Replace #8306) (2020 Vehicle) - LEASE Pub Works 12,500 12,500 2025 1-Ton Pickup (Replace #8311) (2020 Vehicle) - LEASE Pub Works 7,700 7,700 2025 1-Ton Pickup (Replace #8312) (2020. Vehicle) - LEASE Pub Works 1,925 1,925 1,925 1,925 7,700 2025 1-Ton Pickup - Irrigation (Replace #8331) (2020 Vehicle) - LEASE Pub Works 9,000 9,000 2025 1-Ton Pickup (Replace #8332) (2020 Vehicle) - LEASE Pub Works 7,700 7,700 2025 1-Ton Pickup (Replace #8334) (2020 Vehicle) - LEASE Pub Works 7,700 7,700 2026 Escape 4x4 (Replace #8303) (2021 Vehicle) - LEASE Pub Works 6,000 (12,000)(1)(6,000) 2026 1/2-Ton Pickup (Replace #8307) (2021 Vehicle) - LEASE Pub Works 9,000 (15,000)(1)(6,000) 2026 1/2-Ton Pickup (Replace #8335) (2021 Vehicle) - LEASE Pub Works 9,000 (15,000)(1)(6,000) 2026 1-Ton Pickup (Replace #8336) (2021 Vehicle) - LEASE Pub Works 10,000 (18,000)(1)(8,000) 2026 1/2-Ton Pickup (Replace #8343) (2021 Vehicle) - LEASE Pub Works 9,000 (15,000)(1)(6,000) 2026 1-Ton Pickup w/Dump (Replace #8344) (2021 Vehicle) - LEASE Pub Works 15,000 (21,000)(1)(6,000) 214,275 14,425 4,425 6,675 0 (96,000)143,800 Total Lease Funding Requirements - Year 2026 $214,275 (1)Equipment CIP cost is the total annual lease which will be reduced by the resale value in the first year. Other funding is the resale for the vehicle. 11/16/18 Equipment Water Sewer Storm Debt Serv Total YR 10 Item - Description Department CIP Utility Utility Utility Levy Other Cost 2023 1-Ton Pickup w/Dump (Replace #8310) (2018 Vehicle) - LEASE Pub Works 13,000 13,000 2023 1/2-Ton Ex-Cab Pickup (Replace #8329) (2018 Vehicle) - LEASE Pub Works 8,000 8,000 2023 1-Ton Pickup w/Dump (Replace #8340) (2018 Vehicle) - LEASE Pub Works 13,000 13,000 2023 1-Ton Pickup (Replace #8345) (2018 Vehicle) - LEASE Pub Works 10,000 10,000 2023 1/2-Ton Ex-Cab Pickup (Replace #8346) (2018 Vehicle) - LEASE Pub Works 7,000 7,000 2024 1-Ton Pickup Extended Cab (Replace #8330) (2019 Vehicle) - LEASE Pub Works 9,000 9,000 2024 1-Ton Pickup (Replace #8341) (2019 Vehicle) - LEASE Pub Works 9,000 9,000 2024 Full Size Van - Park & Rec (Replace #8601) (2019 Vehicle) - LEASE Pub Works 6,500 6,500 2024 Caravan - Parks (Replace #8603) (2019 Vehicle) - LEASE Pub Works 5,000 5,000 2024 Excape 4x4 - Inspections (Replace #8615) (2019 Vehicle) - LEASE Pub Works 5,000 5,000 2025 1-Ton Pickup w/Dump (Replace #8306) (2020 Vehicle) - LEASE Pub Works 12,500 12,500 2025 1-Ton Pickup (Replace #8311) (2020 Vehicle) - LEASE Pub Works 7,700 7,700 2025 1-Ton Pickup (Replace #8312) (2020. Vehicle) - LEASE Pub Works 1,925 1,925 1,925 1,925 7,700 2025 1-Ton Pickup - Irrigation (Replace #8331) (2020 Vehicle) - LEASE Pub Works 9,000 9,000 2025 1-Ton Pickup (Replace #8332) (2020 Vehicle) - LEASE Pub Works 7,700 7,700 2025 1-Ton Pickup (Replace #8334) (2020 Vehicle) - LEASE Pub Works 7,700 7,700 2026 Escape 4x4 (Replace #8303) (2021 Vehicle) - LEASE Pub Works 6,000 6,000 2026 1/2-Ton Pickup (Replace #8307) (2021 Vehicle) - LEASE Pub Works 9,000 9,000 2026 1/2-Ton Pickup (Replace #8335) (2021 Vehicle) - LEASE Pub Works 9,000 9,000 2026 1-Ton Pickup (Replace #8336) (2021 Vehicle) - LEASE Pub Works 10,000 10,000 2026 1/2-Ton Pickup (Replace #8343) (2021 Vehicle) - LEASE Pub Works 9,000 9,000 2026 1-Ton Pickup w/Dump (Replace #8344) (2021 Vehicle) - LEASE Pub Works 15,000 15,000 2027 1-Ton Pickup (Replace #8308) (2022 Vehicle) - LEASE Pub Works 8,250 2,750 (18,000)(1)(7,000) 2027 1-Ton Pickup (Replace #8315) (2022 Vehicle) - LEASE Pub Works 11,000 (18,000)(1)(7,000) 2027 1/2-Ton Pickup (Replace #8333) (20 Vehicle) - LEASE Pub Works 3,000 3,000 3,000 (15,000)(1)(6,000) 2027 1/2-Ton Pickup - Parks (Replace #8336) (2022 Vehicle) - LEASE Pub Works 9,000 (15,000)(1)(6,000) 2027 Escape 4x4 (Replace #8314) (2022 Vehicle) - LEASE Pub Works 6,500 (12,000)(1)(5,500) 2027 Caravan - Admin (Replace #8621) (2022 Vehicle) - LEASE Pub Works 6,500 (12,000)(1)(5,500) 221,275 14,925 4,925 7,675 0 (90,000)158,800 Total Lease Funding Requirements - Year 2027 $221,275 (1)Equipment CIP cost is the total annual lease which will be reduced by the resale value in the first year. Other funding is the resale for the vehicle. 11/16/18 Equipment Water Sewer Storm Debt Serv Total YR 11 Item - Description Department CIP Utility Utility Utility Levy Other Cost 2024 1-Ton Pickup Extended Cab (Replace #8330) (2019 Vehicle) - LEASE Pub Works 9,000 9,000 2024 1-Ton Pickup (Replace #8341) (2019 Vehicle) - LEASE Pub Works 9,000 9,000 2024 Full Size Van - Park & Rec (Replace #8601) (2019 Vehicle) - LEASE Pub Works 6,500 6,500 2024 Caravan - Parks (Replace #8603) (2019 Vehicle) - LEASE Pub Works 5,000 5,000 2024 Excape 4x4 - Inspections (Replace #8615) (2019 Vehicle) - LEASE Pub Works 5,000 5,000 2025 1-Ton Pickup w/Dump (Replace #8306) (2020 Vehicle) - LEASE Pub Works 12,500 12,500 2025 1-Ton Pickup (Replace #8311) (2020 Vehicle) - LEASE Pub Works 7,700 7,700 2025 1-Ton Pickup (Replace #8312) (2020. Vehicle) - LEASE Pub Works 1,925 1,925 1,925 1,925 7,700 2025 1-Ton Pickup - Irrigation (Replace #8331) (2020 Vehicle) - LEASE Pub Works 9,000 9,000 2025 1-Ton Pickup (Replace #8332) (2020 Vehicle) - LEASE Pub Works 7,700 7,700 2025 1-Ton Pickup (Replace #8334) (2020 Vehicle) - LEASE Pub Works 7,700 7,700 2026 Escape 4x4 (Replace #8303) (2021 Vehicle) - LEASE Pub Works 6,000 6,000 2026 1/2-Ton Pickup (Replace #8307) (2021 Vehicle) - LEASE Pub Works 9,000 9,000 2026 1/2-Ton Pickup (Replace #8335) (2021 Vehicle) - LEASE Pub Works 9,000 9,000 2026 1-Ton Pickup (Replace #8336) (2021 Vehicle) - LEASE Pub Works 10,000 10,000 2026 1/2-Ton Pickup (Replace #8343) (2021 Vehicle) - LEASE Pub Works 9,000 9,000 2026 1-Ton Pickup w/Dump (Replace #8344) (2021 Vehicle) - LEASE Pub Works 15,000 15,000 2027 1-Ton Pickup (Replace #8308) (2022 Vehicle) - LEASE Pub Works 8,250 2,750 11,000 2027 1-Ton Pickup (Replace #8315) (2022 Vehicle) - LEASE Pub Works 11,000 11,000 2027 1/2-Ton Pickup (Replace #8333) (20 Vehicle) - LEASE Pub Works 3,000 3,000 3,000 9,000 2027 1/2-Ton Pickup - Parks (Replace #8336) (2022 Vehicle) - LEASE Pub Works 9,000 9,000 2027 Escape 4x4 (Replace #8314) (2022 Vehicle) - LEASE Pub Works 6,500 6,500 2027 Caravan - Admin (Replace #8621) (2022 Vehicle) - LEASE Pub Works 6,500 6,500 2028 1-Ton Pickup w/Dump (Replace #8310) (2018 Vehicle) - LEASE Pub Works 15,000 (22,000)(1)(7,000) 2028 1/2-Ton Ex-Cab Pickup (Replace #8329) (2018 Vehicle) - LEASE Pub Works 10,000 (20,000)(1)(10,000) 2028 1-Ton Pickup w/Dump (Replace #8340) (2018 Vehicle) - LEASE Pub Works 15,000 (22,000)(1)(7,000) 2028 1-Ton Pickup (Replace #8345) (2018 Vehicle) - LEASE Pub Works 12,000 (20,000)(1)(8,000) 2028 1/2-Ton Ex-Cab Pickup (Replace #8346) (2018 Vehicle) - LEASE Pub Works 9,000 (15,000)(1)(6,000) 229,275 16,925 4,925 7,675 0 (99,000)159,800 Total Lease Funding Requirements - Year 2028 $229,275 (1)Equipment CIP cost is the total annual lease which will be reduced by the resale value in the first year. Other funding is the resale for the vehicle.