Loading...
HomeMy WebLinkAbout6.d. Capital Improvement Plan EXECUTIVE SUMMARY City Council Regular Meeting: December 5, 2017 AGENDA ITEM: Capital Improvement Plan AGENDA SECTION: Consent PREPARED BY: Logan Martin, City Administrator Jeff May, Finance Director AGENDA NO. 6.d. ATTACHMENTS: 2018-2027 CIP APPROVED BY: LJM RECOMMENDED ACTION: Motion to adopt the attached 10-year Capital Improvement Plan for 2018 – 2027. 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 November. 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. • 2018 – 2020: Flint Hill Fields improvements ($2.7M) o Includes the completion of the northern four fields, parking lot, small play structure, and lighting. • 2018: Covered dugouts at UMore & Erickson Park ($70,000) • 2018: Horseshoe Park Phase 1 ($300,000) o Includes installation of trails, play equipment etc. to be fund by Park Dedication fees. • 2019: Baseline fencing for three ball fields ($30,000) • 2020: UMore Field Improvements Phase 2 ($1.9M) 2 Major Road Projects After a review of MN State Aid (MSA) funds and the City’s pavement management program, the following priority projects have been identified. • 2018: McAndrews Road improvements ($533,000) o Includes road widening to allow for dedicated turn lanes, regional trail improvements, and stormwater improvements. This is a cost-share project with Dakota County. • 2018: December Trail area city streets pavement management program ($655,900) • 2018: Akron Ave. paving project design fees cost-share ($200,000) • 2019: Bonaire Path – Akron Ave. to Greystone ($2M) o Includes asphalt roadway construction and RR quiet zone installation • 2022: Roundabout at 140th St. & Diamond Path, shared with Dakota County ($440,000) o Design occurs in 2020, right-of-way acquisition in 2021 Beyond aforementioned street and MSA funded projects, staff has identified three road projects that would provide an economic development benefit to the community if constructed. In order to be prepared to quickly respond to development needs as they arise in these areas, staff would like to develop plans for the three roadways so that construction can occur in a timely manner. The three projects are: Bonaire Path- Pave roadway to urban section from east of Akron Avenue to east of Anderson Drive Connemara Trail- Extension of urban section roadway from Akron Ave east Biscayne Avenue- Pave roadway to urban section from south of Boulder Trail to 160th Design for these projects is slated for 2018, with the understanding that construction timing will be dependent on development needs and funding availability. Staff anticipates further discussion with the Council regarding financing for these projects, which may include the use of MSA funds, developer payments, and assessments. 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. • 2018: Year 1 of fleet leasing program with Enterprise ($43,347) • 2019: Possible water storage and treatment plant facilities • 2022: Well #17 construction RECOMMENDATION Staff recommends the Council review the proposed projects and approve the attached 10-year Capital Improvement Program for 2018 – 2027. 10-YEAR CIP WORKING PROGRAM 2018-2027 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 12/1/17 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 2018 1 Floor Scrubber Arena 9,000 (1)9,000 2018 2 Replace Condenser / Cooling Tower Arena 65,000 (1)65,000 2018 3 Data Center Cabling (Fiber/Copper) @ City Hall Finance 7,000 7,000 2018 4 Replace Council & Staff Tablets Finance 12,500 12,500 2018 5 City Hall Main Network Switch & Host Server Addition Finance 58,000 58,000 2018 6 Replace Handheld Radios (17)Fire 76,500 76,500 2018 7 Add Extrication Tools to New Engine 12 Fire 95,000 95,000 2018 8 City-Wide Software Gen'l. Govt.25,000 25,000 2018 9 Covered Dugouts at UMore Ball Field & Erickson Park Park & Rec 70,000 70,000 2018 10 Flint Hills Field Improvements - Phase 1 (Year 1)Park & Rec 900,000 900,000 2018 11 Trail Plans & Design - Regional Greenways Park & Rec 50,000 50,000 2018 12 Dunmore Park Development Park & Rec 150,000 150,000 2018 13 Horsehoe Lake Park - Phase 1 Park & Rec 300,000 300,000 2018 14 Replace Bikes Police 3,000 3,000 2018 15 Replace Speed Trailers Police 7,000 7,000 2018 16 Evidence Processing Room Equipment Upgrades (Software)Police 9,000 9,000 2018 17 Squad Set Up and Equipment Installation Police 39,000 39,000 2018 18 Replace Squad Mobile Radios Police 54,000 54,000 2018 19 Additional Severe Weather Siren (Flint Hills Fields)Police 75,000 75,000 2018 20 3 Squads (Sell Back 3 - #3520, #3580 & #35120)Police 90,000 20,000 (2)110,000 2018 21 PW Building Addition Lease/Purchase (Year 20 of 20)Pub Works 24,000 10,000 10,000 44,000 2018 22 Pedestrian Improvements Program Pub Works 125,000 125,000 2018 23 PMP (December Trail Area)Pub Works 655,900 262,600 918,500 2018 24 County Road 38 - CSAH 31 to TH 3 (Construction) Pub Works 533,000 300,000 (3)833,000 2018 25 Bonaire Path - Akron Avenue to Greystone(with Quiet Zone)(Design)Pub Works 200,000 (3)200,000 2018 26 CSAH 42 at TH 55 (Construction)Pub Works 35,800 (3)35,800 2018 27 CR 73 - Bonaire Path to IGH (Design)Pub Works 200,000 (3)200,000 2018 28 Biscayne Avenue - Boulder Ave. to CSAH 46 (Design)Pub Works 150,000 (3)150,000 2018 29 Connemara Trail - East Extension (Design)Pub Works 170,000 (3)170,000 2018 30 Lease Program - Year 1 Pub Works 43,347 9,418 (48,500)(4)4,265 2018 31 Bobcat Trailer (Replace #0503) (Purchased 1999)Pub Works 18,500 1,500 (5)20,000 2018 32 Bobcat (Replace #8420) (2008 Vehicle)Pub Works 15,000 50,000 5,000 (5)70,000 2018 33 Groundsmaster Mower (Replace #8068) (Purchased 2008)Pub Works 77,000 8,000 (5)85,000 2018 34 Sidewalk Trac & Blower (Replace #8417 & 0121) (Purchased 2003)Pub Works 130,000 15,000 (5)145,000 2018 35 Single-Axle Dump Truck (Replace #8436) (2005 Vehicle)Pub Works 145,000 35,000 (5)180,000 2018 36 1-Ton Pickup (Replace #8345) (2007 Vehicle)Pub Works 52,000 8,000 (5)60,000 2018 37 Investigate and Seal Wells 1 & 2 Pub Works 150,000 150,000 (6)300,000 2018 38 Extend Utilities to UMore Pub Works 300,000 1,648,000 4,310,000 (7)6,258,000 0 994,000 780,900 979,847 262,600 500,000 1,288,800 300,000 1,648,000 0 221,418 10,000 350,000 0 4,578,000 11,913,565 Total CIP Funding Requirements - Year 2018 $2,754,747 $0 (#)These items will be funded with the issuance of Equipment Certificates.$0 (1)Floor scrubber and replacement of Condenser / Cooling Tower funding comes from Arena Fund operations/reserves. (2)Other funding for Squad Cars comes from auction sales of old vehicles. (3)Other funding for these projects are not included. Costs are Rosemount's share only. (4) 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. (5)Other funding for Public Works equipment comes from trade-in value of old vehicles. (6)Other funding for Wells 1 & 2 project anticipated from a MDH Grant (50% of project). (7)Other funding for Extending Utilities to Umore will come from the University and the developer. Total Building CIP levy for 2018 is $24,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). Total Street CIP levy for 2018 is $783,900. 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. Total Equipment CIP levy for 2018 is $600,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 12/1/17 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 Paint Arena Ceiling Arena 85,000 (1)85,000 2019 2 Replace Chiller Barrel Arena 135,000 (1)135,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 Dugouts @ Bloomfield Park Park & Rec 15,000 15,000 2019 9 Baseline Fencing for 3 Fields Park & Rec 30,000 30,000 2019 10 Community Center / Armory Remodel Park & Rec 150,000 150,000 2019 11 Flint Hills Field Improvements - Phase 1 (Year 2)Park & Rec 900,000 900,000 2019 12 Koch Trail Restoration Park & Rec 50,000 (2)50,000 2019 13 Skate Park Upgrades - Phase 1 Park & Rec 65,000 (2)65,000 2019 14 Develop Park N-5 Park & Rec 200,000 200,000 2019 15 Squad Set Up and Equipment Installation Police 40,000 40,000 2019 16 3 Squads (Sell Back 3 - #35150, #35100 & #35110)Police 93,000 24,000 (3)117,000 2019 17 Replace Police Portable Radios (Encrypted)Police 142,000 142,000 2019 18 Pedestrian Improvements Program Pub Works 125,000 125,000 2019 19 PMP (O'Leary's, Carrollton, Oak Ridge Estates, 145th St.)Pub Works 990,300 430,500 1,420,800 2019 20 CR 73 - Bonaire Path to IGH (ROW)Pub Works 337,500 (4)337,500 2019 21 Connemara Trail - East Extension (Construction)Pub Works 800,000 15,000 312,000 (5)1,127,000 2019 22 Bonaire Path - Akron Avenue to Greystone(with Quiet Zone)(Const.)Pub Works 2,000,000 (4)2,000,000 2019 23 Lease Program - Year 2 Pub Works 62,347 8,418 (44,500)(6)26,265 2019 24 Blower Attach for #8418 & #8420 (Replace #0123) (2008)Pub Works 6,000 6,000 2019 25 Blower Attach for #8071 & #8072 (Replace #0119) (2001)Pub Works 7,500 7,500 2019 26 Replace Paint Mixer Pub Works 15,000 15,000 2019 27 Bobcat (Replace #8418) (2008 Vehicle)Pub Works 45,000 5,000 (7)50,000 2019 28 Sweeper (Replace #8443) (Purchased 2007)Pub Works 101,500 101,500 12,000 (7)215,000 2019 29 Sno Go Blower (Replace #0130) (Purchased 1987)Pub Works 150,000 150,000 2019 30 6" Trash Pump (Replace #8089) (Purchased 1995)Pub Works 16,600 16,700 16,700 50,000 2019 31 Generator (Replace #8057) (Purchased 1996)Pub Works 30,000 30,000 5,000 (7)65,000 2019 32 Utility Pickup w/Crane (Replace #8342) (2007 Vehicle)Pub Works 32,000 32,000 31,000 15,000 (7)110,000 2019 33 Jetter (Replace #8445) (2006 Vehicle)Pub Works 92,500 92,500 25,000 (7)210,000 2019 34 Water Storage Facility Pub Works 5,000,000 (8)5,000,000 2019 35 Water Treatment Facility Pub Works 8,500,000 8,500,000 (8)17,000,000 1,095,000 1,115,300 986,847 430,500 200,000 3,137,500 13,515,000 0 0 8,587,018 171,200 241,700 0 688,500 30,168,565 Total CIP Funding Requirements - Year 2019 $3,197,147 $0 (#)These items will be funded with the issuance of Equipment Certificates.$0 (1)Painting Arena Ceiling & Chiller Barrel Replacement funding comes from Arena Fund operations/reserves. (2)Koch Trail Restoration funding will come from a grant. Skate Park funding will come from the General Fund Parks Maintenance Budget. (3)Other funding for Squad Cars comes from auction sales of old vehicles. (4)Other funding for these projects are not included. Costs are Rosemount's share only. (5)Other funding comes from prepaid special assessments collected over the last 5-7 years. (6)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. (7)Other funding for Public Works equipment comes from trade-in value of old vehicles. (8)Funding for the Water Storage Facility and the Water Treatment Facility will come from a Water Revenue bond issue. 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). 3 of 11 MSA 12/1/17 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 Restroom Rehab - Lower Arena 25,000 (1)25,000 2020 2 Scoreboards Arena 30,000 (1)30,000 2020 3 LED Lighting Arena 65,000 (1)65,000 2020 4 Phone Server Replacements (From 2015)Finance 20,000 20,000 2020 5 Replace Fire Department Mobile Computers (From 2016)Finance 35,000 35,000 2020 6 4 Server Environment & Storage Replacements (From 2015)Finance 75,000 75,000 2020 7 Aerial Platform Truck Replacement (Purchased in 2020)Fire 1,200,000 (#)1,200,000 2020 8 City-Wide Software Gen'l. Govt.25,000 25,000 2020 9 Skate Park Upgrades - Phase 2 Park & Rec 65,000 (2)65,000 2020 10 Flint Hills Field Improvements - Phase 1 (Year 3)Park & Rec 900,000 900,000 2020 11 Umore Ball Field Improvements - Phase 2 Park & Rec 1,900,000 1,900,000 2020 12 Replace 1/2 of AED's (5)Police 8,000 8,000 2020 13 Squad Set Up and Equipment Installation Police 39,000 39,000 2020 14 3 Squads (Sell Back 3 - #3550, #3590 & #35170)Police 96,000 24,000 (3)120,000 2020 15 Pedestrian Improvements Program Pub Works 125,000 125,000 2020 16 PMP (West Ridge A, Chippendale A)Pub Works 621,041 98,875 719,916 2020 17 Roundabout @ 140th Street / Diamond Path (Design)Pub Works 45,000 (4)45,000 2020 18 CR 73 - Bonaire Path to IGH (Construction)Pub Works 1,320,000 (4)1,320,000 2020 19 Biscayne Avenue - Boulder Trail to CR 46 Pub Works 2,000,000 (5)2,000,000 2020 20 Lease Program - Year 3 Pub Works 114,647 8,418 (99,000)(6)24,065 2020 21 Pavement Roller (Replace #8129) (Purchased 2003)Pub Works 58,000 2,000 (7)60,000 2020 22 Single-Axle Dump Truck (Replace #8430) (2009 Vehicle)Pub Works 145,000 35,000 (7)180,000 2,800,000 746,041 615,647 98,875 0 3,365,000 0 0 0 8,418 0 0 0 1,347,000 8,980,981 Total CIP Funding Requirements - Year 2020 $4,161,688 $0 (#)These items will be funded with the issuance of Equipment Certificates.$1,200,000 (1)Lower Restroom Rehab, Scoreboards & LED Lighting funding comes from Arena Fund operations/reserves. (2)Skate Park funding will come from the General Fund Parks Maintenance Budget. (3)Other funding for Squad Cars comes from auction sales of old vehicles. (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)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. (7)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). 4 of 11 MSA 12/1/17 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 Arena Refrigeration / Rink System Arena 375,000 (1)375,000 2021 2 Aerial Platform Truck Replacement (Year 1 of 5)Fire 252,000 252,000 2021 3 City-Wide Software Gen'l. Govt.25,000 25,000 2021 4 Replace Less Lethal Weapons Police 6,000 6,000 2021 5 Squad Set Up and Equipment Installation Police 52,000 52,000 2021 6 Replace Squad Video System Police 120,000 120,000 2021 7 4 Squads (Sell Back 4 - #3530, #3540, #3570 & #35140)Police 128,000 32,000 (2)160,000 2021 8 Pedestrian Improvements Program Pub Works 125,000 125,000 2021 9 PMP (West Ridge C, Shannon Pond, Dodd, Biscayne B, >>)Pub Works 1,437,990 383,921 1,821,911 2021 10 Roundabout @ 140th Street / Diamond Path (ROW)Pub Works 78,800 (3)78,800 2021 11 Lease Program - Year 4 Pub Works 163,147 8,418 (82,000)(4)89,565 2021 12 Shop Hoist (Replace #0002) (Purchased 2006)Pub Works 55,000 5,000 (5)60,000 2021 13 JD Tractor & Blower (Replace #8406 & #0128) (2006 & 2011)Pub Works 108,000 7,000 (5)115,000 PMP (Cont.-Rosemount Hills B, Jay Simons) 0 1,562,990 909,147 383,921 0 78,800 0 0 0 8,418 0 0 0 337,000 3,280,276 Total CIP Funding Requirements - Year 2021 $2,472,137 $0 (#)These items will be funded with the issuance of Equipment Certificates.$0 (1)Arena Refrigeration / Rink System funding comes from Arena Fund operations/reserves. (2)Other funding for Squad Cars comes from auction sales of old vehicles. (3)Other funding for these projects are not included. Costs are Rosemount's share only. (4)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. (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). 5 of 11 MSA 12/1/17 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 Replace Police Portable Radio Batteries Police 5,000 5,000 2022 9 Squad Set Up and Equipment Installation Police 45,000 45,000 2022 10 Replace Squad Laptops (5) / Printers / Netmotion Police 55,000 55,000 2022 11 3 Squads (Sell Back 3 - #3520, #3560 & #3580)Police 100,000 20,000 (2)120,000 2022 12 Pedestrian Improvements Program Pub Works 125,000 125,000 2022 13 PMP (Wensmann A/B/C, December Trail, Stonebridge, >>)Pub Works 2,408,824 752,215 3,161,039 2022 14 Roundabout @ 140th Street / Diamond Path (Construction)Pub Works 440,000 (3)440,000 2022 15 Lease Program - Year 5 Pub Works 197,397 10,918 2,500 4,750 (85,000)(4)130,565 2022 16 Blower Attach for #8409 (Replace #0122) (2001) Pub Works 15,000 15,000 2022 17 Crash Attenuator (Replace #0049) (Purchased 2007)Pub Works 20,000 20,000 2022 18 Loader, Wing & Plow (Replace #8419) (Purchased 2005)Pub Works 275,000 50,000 (5)325,000 2022 19 Well #17 Construction Pub Works 1,500,000 (6)1,500,000 PMP (Cont.-Deepwoods, White Lake Acres) 1,200,000 2,533,824 1,069,397 752,215 0 440,000 1,500,000 0 0 10,918 2,500 4,750 0 90,000 7,603,604 Total CIP Funding Requirements - Year 2022 $4,803,221 $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)Other funding for Squad Cars comes from auction sales of old vehicles. (3)Other funding for these projects are not included. Costs are Rosemount's share only. (4)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. (5)Other funding for Public Works equipment comes from trade-in value of old vehicles. (6)Funding for Well #17 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). 6 of 11 MSA 12/1/17 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 50,000 50,000 2023 5 3 Squads (Sell Back 2 - #3590 & #35110 & 1 New Addition)Police 105,000 16,000 (2)121,000 2023 6 Pedestrian Improvements Program Pub Works 125,000 125,000 2023 7 PMP (Geronime Pond, Town Center, Cameo & 143rd, McNamara)Pub Works 811,581 225,016 1,036,597 2023 8 Lease Program - Year 6 Pub Works 204,050 12,500 2,500 4,750 (77,000)(3)146,800 2023 9 Aerator (Replace #0157) (Purchased 2013)Pub Works 18,000 2,000 (4)20,000 2023 10 Generator (Replace #8059) (Purchased 2003)Pub Works 35,000 35,000 5,000 (4)75,000 0 936,581 654,050 225,016 0 0 0 0 0 47,500 37,500 4,750 0 36,000 1,941,397 Total CIP Funding Requirements - Year 2023 $1,590,631 $0 (#)These items will be funded with the issuance of Equipment Certificates.$0 (1)Skate Tile funding comes from Arena Fund operations/reserves. (2)Other funding for Squad Cars comes from auction sales of old vehicles. (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 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). 7 of 11 MSA 12/1/17 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 30,000 30,000 2024 7 2 Squads (Sell Back 2 - #3510 & #35100)Police 66,000 16,000 (2)82,000 2024 8 Pedestrian Improvements Program Pub Works 125,000 125,000 2024 9 PMP (Boomfield B, O'Leary's Hills C, Connemara A, >>)Pub Works 1,222,832 305,817 1,528,649 2024 10 Lease Program - Year 7 Pub Works 210,550 12,500 2,500 4,750 (66,000)(3)164,300 2024 11 Groundsmaster Mower (Replace #8066) (Purchased 2015)Pub Works 87,000 8,000 (4)95,000 2024 12 Groundsmaster Mower (Replace #8073) (Purchased 2015)Pub Works 87,000 8,000 (4)95,000 2024 13 Single-Axle Dump Truck (Replace #8432) (2012 Vehicle)Pub Works 151,000 39,000 (4)190,000 PMP (Cont.-Auburn Ave., 145th St. A) 0 1,347,832 1,013,550 305,817 0 0 0 0 0 12,500 2,500 4,750 0 25,000 2,711,949 Total CIP Funding Requirements - Year 2024 $2,361,382 $0 (#)These items will be funded with the issuance of Equipment Certificates.$0 (1)Skate Sharpener funding comes from Arena Fund operations/reserves. (2)Other funding for Squad Cars comes from auction sales of old vehicles. (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 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). 8 of 11 MSA 12/1/17 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 75,000 75,000 2025 7 5 Squads (Sell Back 5 - #3530, #3550, #3570, 35140 & #35170)Police 175,000 40,000 (2)215,000 2025 8 Pedestrian Improvements Program Pub Works 125,000 125,000 2025 9 PMP (Bloomfield A, West Ridge B, Country Hills A, >>)Pub Works 1,044,591 351,968 1,396,559 2025 10 Lease Program - Year 8 Pub Works 210,550 12,500 2,500 4,750 (105,000)(3)125,300 2025 11 Water Truck (Replace #8431) (2013 Vehicle)Pub Works 180,000 20,000 (4)200,000 2025 12 Dump Tandem (Replace #8434) (2013 Vehicle)Pub Works 195,000 35,000 (4)230,000 PMP (Cont.-Conley, Chippendale B) 0 1,169,591 1,252,550 351,968 0 0 0 0 0 12,500 2,500 4,750 0 (2,000)2,791,859 Total CIP Funding Requirements - Year 2025 $2,422,141 $0 (#)These items will be funded with the issuance of Equipment Certificates.$0 (1)Ice Edger funding comes from Arena Fund operations/reserves. (2)Other funding for Squad Cars comes from auction sales of old vehicles. (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 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). 9 of 11 MSA 12/1/17 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 45,000 45,000 2026 4 3 Squads (Sell Back 3 - #3520, 3540 & #3580)Police 110,000 24,000 (2)134,000 2026 5 Pedestrian Improvements Program Pub Works 125,000 125,000 2026 6 PMP (Country Hills B, Hawkins Pond, Broback Park, >>)Pub Works 883,238 318,103 1,201,341 2026 7 Lease Program - Year 9 Pub Works 220,050 12,500 2,500 4,750 (96,000)(3)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 (4)50,000 PMP (Cont.-Biscayne A, Autumn Path) 0 1,008,238 457,050 318,103 0 0 0 0 0 12,500 2,500 4,750 0 53,000 1,856,141 Total CIP Funding Requirements - Year 2026 $1,465,288 $0 (#)These items will be funded with the issuance of Equipment Certificates. (1)Ice Resurfacer funding comes from Arena Fund operations/reserves.$0 (2)Other funding for Squad Cars comes from auction sales of old vehicles. (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 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). 10 of 11 MSA 12/1/17 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 45,000 45,000 2027 4 3 Squads (Sell Back 3 - #3560, #35110 & #35120)Police 110,000 20,000 (2)130,000 2027 5 Pedestrian Improvements Program Pub Works 125,000 125,000 2027 6 PMP (Evermoor B, Biscayne Pointe C, Shannon Pond East)Pub Works 804,803 432,028 1,236,831 2027 7 Lease Program - Year 10 Pub Works 229,800 13,000 3,000 3,000 (90,000)(3)158,800 2027 8 Groundsmaster Mower (Replace #8068) (Purchased 2018)Pub Works 85,000 10,000 (4)95,000 2027 9 Dump Single (Replace #8437) (2014 Vehicle)Pub Works 160,000 40,000 (4)200,000 2027 10 Sweeper (Replace #8444) (Purchased 2017)Pub Works 110,000 110,000 20,000 (4)240,000 0 929,803 844,800 432,028 0 0 0 0 0 13,000 3,000 113,000 0 0 2,335,631 Total CIP Funding Requirements - Year 2027 $1,774,603 $0 (#)These items will be funded with the issuance of Equipment Certificates. (1)xxxxxxxxxxxx funding comes from Arena Fund operations/reserves.$0 (2)Other funding for Squad Cars comes from auction sales of old vehicles. (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 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). 11 of 11 MSA 12/1/17 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 Splash Pad - Phase 2 Park & Rec 1,000,000 1,000,000 Future 9 Umore Ball Fields - Phase 2 Park & Rec 2,600,000 2,600,000 Future 10 Flint Hills Athletic Fields Improvements - Phases 2 & 3 Park & Rec 3,200,000 3,200,000 Future 11 TH 3 Aesthetic Improvements Pub Works 448,500 (5)448,500 Future 12 North Central Sanitary Sewer Extension Pub Works (6) Future 13 Street Construction - Boulder Avenue Extension Pub Works 3,000,000 (7)3,000,000 Future 14 Shannon Pond Outlet Pub Works (8) Future 15 Gravel Road Improvements Pub Works (8) Future 16 Akron Avenue South of County Road 42 Pub Works 1,250,000 1,250,000 Future 17 Soccer Goal Trailer (Replace #0501) (Purchased 1980)Pub Works 12,000 12,000 Future 18 Hose Trailer (Replace #0502) (Purchased 1990)Pub Works 12,000 12,000 Future 19 Barricade Trailer (Replace #0510) (Purchased 1986)Pub Works 12,000 12,000 Future 20 Hose Trailer (Replace #0517) (Purchased 1995)Pub Works 12,000 12,000 Future 21 Striper Trailer (Replace #0518) (Purchased 1994)Pub Works 12,000 12,000 Future 22 Easement Trailer (Replace #0521) (Purchased 2003)Pub Works 12,000 12,000 Future 23 Puppet Trailer (Replace #0515) (Purchased 1991)Pub Works 12,000 12,000 Future 24 Fire House Trailer (Replace #0519) (Purchased 1994)Pub Works 12,000 12,000 Future 25 Surveillance Trailer (Replace #0523) (Purchased 2008)Pub Works 12,000 12,000 6,975,000 0 792,000 0 0 1,250,000 0 0 0 0 0 0 0 9,378,500 18,395,500 Total CIP Funding Requirements - Future Years $7,767,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. 12/1/17 Equipment Water Sewer Storm Debt Serv Total Year 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 (7,000)(1)3,360 2018 1/2-Ton Ex-Cab Pickup (Replace #8329) (2006 Vehicle) - LEASE Pub Works 7,852 (9,000)(2)(1,148) 2018 1-Ton Pickup w/Dump (Replace #8340) (2006 Vehicle) - LEASE Pub Works 18,115 (10,000)(2)8,115 2018 1-Ton Pickup (Replace #8345) (2007 Vehicle) - LEASE Pub Works 9,418 (14,500)(2)(5,082) 2018 1/2-Ton Ex-Cab Pickup (Replace #8346) (2006 Vehicle) - LEASE Pub Works 7,020 (8,000)(2)(980) 43,347 9,418 0 0 0 (48,500)4,265 Total Lease Funding Requirements - Year 2018 $43,347 (1)Equipment CIP cost is the total annual lease which will be reduced by the resale value in the first year plus cost for plow ($6,000) and light bar ($1,000). Other funding is the resale for the vehicle. (2)Equipment CIP cost is the total annual lease which will be reduced by the resale value in the first year plus cost for light bar ($1,000). Other funding is the resale for the vehicle. 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. 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 7,700 (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) 114,647 8,418 0 0 0 (99,000)24,065 Total Lease Funding Requirements - Year 2020 $114,647 (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. 12/1/17 Equipment Water Sewer Storm Debt Serv Total Year 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 7,700 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) 163,147 8,418 0 0 0 (82,000)89,565 Total Lease Funding Requirements - Year 2021 $163,147 (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. 12/1/17 Equipment Water Sewer Storm Debt Serv Total Year 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 7,700 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) 197,397 10,918 2,500 4,750 0 (85,000)130,565 Total Lease Funding Requirements - Year 2022 $197,397 (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. 12/1/17 Equipment Water Sewer Storm Debt Serv Total Year 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 7,700 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) 204,050 12,500 2,500 4,750 0 (77,000)146,800 Total Lease Funding Requirements - Year 2023 $204,050 (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. 12/1/17 Equipment Water Sewer Storm Debt Serv Total Year 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 7,700 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) 210,550 12,500 2,500 4,750 0 (66,000)164,300 Total Lease Funding Requirements - Year 2024 $210,550 (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. 12/1/17 Equipment Water Sewer Storm Debt Serv Total Year 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 7,700 (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) 210,550 12,500 2,500 4,750 0 (105,000)125,300 Total Lease Funding Requirements - Year 2025 $210,550 (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. 12/1/17 Equipment Water Sewer Storm Debt Serv Total Year 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 7,700 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) 220,050 12,500 2,500 4,750 0 (96,000)143,800 Total Lease Funding Requirements - Year 2026 $220,050 (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. 12/1/17 Equipment Water Sewer Storm Debt Serv Total Year 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 7,700 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 11,000 (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) 229,800 13,000 3,000 3,000 0 (90,000)158,800 Total Lease Funding Requirements - Year 2027 $229,800 (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.