HomeMy WebLinkAbout2.b. Review Capital Improvement Plan
EXECUTIVE SUMMARY
City Council Work Session: November 4, 2019
AGENDA ITEM: Review Capital Improvement Plan AGENDA SECTION:
Discussion
PREPARED BY: Logan Martin, City Administrator
Jeff May, Finance Director AGENDA NO. 2.b.
ATTACHMENTS: 2020-2029 CIP & Lease Programming APPROVED BY: LJM
RECOMMENDED ACTION: Review and provide direction on the 10-year CIP
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 review and direction by the City Council, the CIP will be presented to the Planning Commission and
Parks & Recreation Commission (already completed). The ten-year CIP will ultimately be considered for
final adoption by the City Council in December.
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. A number of smaller or more routine projects can be discussed during the
presentation at the worksession, if necessary.
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.
• 2020: Community Center / Armory remodel ($150,000)
• 2020: UMore Field Improvements Phase 2 design ($400,000)
o Construction slated for 2021 ($3M)
• 2020: Skate Park upgrades (65,000 from Parks Maint., the remainder from Park Dedication)
• 2020: Indoor Rec Center construction (total cost of approx. $30M in 2021)
• 2020: Replace Arena Scoreboards ($22,000 donated funds) and Chiller Barrel ($135,000)
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.
• 2019 (postponed): Connemara Trail eastern extension ($800,000)
o Extends roadway east of Akron Ave. to support development
• 2020: Akron Ave. construction & utilities ($1.615M)
• 2020: Biscayne Ave. construction & utilities ($5.09M)
o Requires approx. $3.1M in Municipal State Aid funding (City receives $950,000 annually)
• 2020: Autumn Path construction & utilities ($1.51M)
• 2020: Deepwoods Court improvements ($250,000)
• 2022: Roundabout at 140th St. & Diamond Path, cost shared with Dakota County ($440,000)
o Design occurs in 2020 ($45,000) right-of-way acquisition in 2021 ($78,800)
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.
• 2022: Well #17 construction
• 2022: Water Treatment Facility and Water Storage Facility
RECOMMENDATION
Staff will review these projects and others on the CIP with the Council at the November 4 work session.
At that time, the Council should provide direction to staff on any requested changes in project scheduling
prior to further review of the CIP by Planning Commission and Parks & Recreation Commission.
Final Council action on the 10-year CIP will take place at the December City Council meeting.
MSA 11/1/19
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 29,000 (1)29,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 P & R Surveillance Cameras(Community Center/Steeple Center)-Year 1 Finance 20,000 20,000
2020 5 Replace Fire Department Mobile Computers (From 2016)Finance 35,000 35,000
2020 6 3 Server Environment & Storage Replacements (From 2015)Finance 35,000 35,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 (Installation)Park & Rec 65,000 (2)65,000
2020 10 Dugouts @ Bloomfield Park Park & Rec 15,000 15,000
2020 11 Roof Repair @ Steeple Center Park & Rec 25,000 25,000
2020 12 Community Center / Armory Remodel Park & Rec 150,000 150,000
2020 13 Umore Ball Field Improvements - Phase 2 (Design Services)Park & Rec 400,000 400,000
2020 14 Body Worn Cameras Police 24,000 (*)24,000
2020 15 Replace 5 Carbines (3 INV Squads, Commander & Chief)Police 10,000 10,000
2020 16 Squad Set Up and Equipment Installation Police 30,000 30,000
2020 17 Lease Program - Year 3 Police 80,248 (28,500)(3)51,748
2020 18 Pedestrian Improvements Program Pub Works 125,000 125,000
2020 19 PMP (121st St., 124th Ct.)Pub Works 175,000 50,000 225,000
2020 20 Roundabout @ Connemara / Diamond Path (Design)Pub Works 45,000 (4)45,000
2020 21 CR 73 - Bonaire Path to IGH (Construction)Pub Works 1,320,000 120,000 75,000 100,000 (4)1,615,000
2020 22 Biscayne Avenue - Boulder Trail to CR 46 Pub Works 1,500,000 3,100,000 330,000 160,000 (5)5,090,000
2020 23 Autumn Path - Bonaire to North Bella Vista Pub Works 854,700 332,000 26,000 297,300 (6)1,510,000
2020 24 Deepwoods Court Pub Works 162,500 87,500 250,000
2020 25 Stormwater Improvement Program Pub Works 200,000 200,000
2020 26 Downtown Planter Replacement Program Pub Works 10,000 10,000
2020 27 Picnic Table Replacement Program Pub Works 25,000 25,000
2020 28 Lease Program - Year 3 Pub Works 117,164 11,360 4,625 4,625 (84,000)(3)53,774
2020 29 NEW Paint Mixer Pub Works 15,000 15,000
2020 30 Sweeper (Replace #8443) (Purchased 2007)Pub Works 64,500 150,500 15,000 (7)230,000
2020 31 Single-Axle Dump Truck (Replace #8430) (2009 Vehicle)Pub Works 145,000 35,000 (7)180,000
2020 32 Plow for Large Tractor (Replace old dump truck plow that was used)Pub Works 15,000 100 (7)15,100
2020 33 NEW Asphalt Trailer Pub Works 35,000 35,000
2020 34 NEW Wing Flail for Large Tractor (#8409)Pub Works 15,000 20,000 35,000
2020 35 NEW Athletic Field Painter Pub Works 40,000 40,000
2020 36 Trailer for Pump Equipment (Replace #0502 & #0517)Pub Works 12,000 500 (7)12,500
625,000 2,637,200 701,912 1,637,500 0 3,145,000 452,000 431,000 100,000 171,360 4,625 387,125 0 1,688,400 11,981,122
Total CIP Funding Requirements - Year 2020 $3,964,112 $0
(#)The Aerial Truck will be funded with the issuance of Equipment Certificates or a Lease-Purchase.
(*)Use funds assigned from previous years.
(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)Benefit appraisals are still being completed for landowners so Assessment funding amounts could change.
(6)Other funding comes from prepaid special assessments collected with Bella Vista. East half special assessments to reimburse Street CIP upon development.
(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).
1 of 11
MSA 11/1/19
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 P & R Surveillance Cameras(Community Center/Steeple Center)-Year 2 Finance 20,000 20,000
2021 4 Aerial Platform Truck Replacement (Year 1 of 5)Fire 252,000 252,000
2021 5 City-Wide Software Gen'l. Govt.25,000 25,000
2021 6 Rec Center Park & Rec 30,000,000 (2)30,000,000
2021 7 New Trails on Bonaire Path Park & Rec 200,000 (2)200,000
2021 8 Umore Ball Field Improvements - Phase 2 (Construction)Park & Rec 3,000,000 3,000,000
2021 9 Develop Park M-1 (Dunmore)Park & Rec 200,000 200,000
2021 10 Replace Less Lethal Weapons Police 6,000 6,000
2021 11 Squad Set Up and Equipment Installation Police 45,000 45,000
2021 12 Replace Squad Video System Police 120,000 120,000
2021 13 Lease Program - Year 4 Police 110,248 (32,000)(3)78,248
2021 14 Pedestrian Improvements Program Pub Works 125,000 125,000
2021 15 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 16 Roundabout @ Connemara / Diamond Path (ROW)Pub Works 78,800 (4)78,800
2021 17 Roundabout @ TH3 and RHS Entrance Pub Works 330,000 770,000 (5)1,100,000
2021 18 Stormwater Improvement Program Pub Works 200,000 200,000
2021 19 Downtown Planter Replacement Program Pub Works 10,000 10,000
2021 20 Picnic Table Replacement Program Pub Works 25,000 25,000
2021 21 Lease Program - Year 4 Pub Works 162,164 11,360 4,625 4,625 (84,000)(3)98,774
2021 22 Fuel Pumps and Software (Replace Existing)Pub Works 65,000 5,000 5,000 5,000 80,000
2021 23 Sno Go Blower (Replace #0130) (Purchased 1987)Pub Works 160,000 160,000
2021 24 Loader, Wing & Plow (Replace #8419) (Purchased 2005)Pub Works 275,000 50,000 (6)325,000
3,035,000 1,025,000 1,240,412 250,000 200,000 408,800 0 0 0 71,360 169,625 274,625 0 30,994,000 37,668,822
Total CIP Funding Requirements - Year 2021 $5,300,412 $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 Rec Center and Bonaire Path trails uncertain 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 from MNDot Local Partnership Program grant.
(6)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).
2 of 11
MSA 11/1/19
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 (Funds Available?????)Park & Rec 1,200,000 1,200,000
2022 8 Develop Park N-2 Caramore Phase 1 Park & Rec 300,000 300,000
2022 9 Replace Police Portable Radio Batteries Police 5,000 5,000
2022 10 Replace Rifle Plates for Officer Response Kits Police 10,000 10,000
2022 11 Squad Set Up and Equipment Installation Police 45,000 45,000
2022 12 Replace Squad Laptops (5) / Printers / Netmotion Police 55,000 55,000
2022 13 Lease Program - Year 5 Police 117,584 (33,500)(2)84,084
2022 14 Pedestrian Improvements Program Pub Works 125,000 125,000
2022 15 PMP (Jay Simons, White Lake Acres)Pub Works 1,100,000 225,000 280,000 240,000 280,000 2,125,000
2022 16 Roundabout @ Connemara / Diamond Path (Construction)Pub Works 440,000 (3)440,000
2022 17 Stormwater Improvement Program Pub Works 200,000 200,000
2022 18 Picnic Table Replacement Program Pub Works 25,000 25,000
2022 19 Lease Program - Year 5 Pub Works 201,414 16,110 9,375 9,375 (91,000)(2)145,274
2022 20 NEW Groundmaster (#8067)Pub Works 105,000 105,000
2022 21 New Dump Single (#8438)Pub Works 190,000 190,000
2022 22 Well #17 Construction Pub Works 1,500,000 (5)1,500,000
2022 23 Water Storage Facility Pub Works 5,000,000 (5)5,000,000
2022 24 Water Treatment Facility Pub Works 8,500,000 8,500,000 (5)17,000,000
1,225,000 1,225,000 1,085,998 225,000 300,000 440,000 15,280,000 240,000 280,000 8,516,110 9,375 209,375 0 (19,500)29,016,358
Total CIP Funding Requirements - Year 2022 $3,535,998 $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).
3 of 11
MSA 11/1/19
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 New Neighborhood Park N-1 Park & Rec 500,000 500,000
2023 5 New Neighborhood Park N- 2 Park & Rec 300,000 300,000
2023 6 Replace Half of AED's (6)Police 9,000 9,000
2023 7 Squad Set Up and Equipment Installation Police 55,000 55,000
2023 8 Lease Program - Year 6 Police 127,000 (40,000)(2)87,000
2023 9 Pedestrian Improvements Program Pub Works 125,000 125,000
2023 10 PMP (Biscayne A & B, 145th St. A)Pub Works 250,000 950,000 60,000 175,000 70,000 1,505,000
2023 11 Stormwater Improvement Program Pub Works 200,000 200,000
2023 12 Picnic Table Replacement Program Pub Works 25,000 25,000
2023 13 Lease Program - Year 6 Pub Works 216,425 19,375 9,375 9,375 (77,000)(2)177,550
2023 14 Aerator (Replace #0157) (Purchased 2013)Pub Works 18,000 2,000 (3)20,000
2023 15 Blower Attachment for #8418 & #8420 (Replace #0123) (2008)Pub Works 6,000 6,000
2023 16 Blower Attachment for #8409 (Replace #0122) (2001)Pub Works 24,000 1,000 (3)25,000
2023 17 Pavement Roller (Replace #8129) (Purchased 2003)Pub Works 58,000 2,000 (3)60,000
2023 18 Tractor/Backhoe (Replace #8407) (Purchased 2008)Pub Works 105,000 25,000 (3)130,000
2023 19 Generator (Replace #8057) (Purchased 1996)Pub Works 25,000 25,000 25,000 5,000 (3)80,000
2023 20 Generator (Replace #8059) (Purchased 2003)Pub Works 25,000 25,000 25,000 5,000 (3)80,000
25,000 125,000 895,425 250,000 800,000 950,000 0 0 0 129,375 234,375 329,375 0 13,000 3,751,550
Total CIP Funding Requirements - Year 2023 $1,045,425 $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).
4 of 11
MSA 11/1/19
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 New Neighborhood Park in Umore Park & Rec 500,000 500,000
2024 7 Squad Set Up and Equipment Installation Police 38,000 38,000
2024 8 Lease Program - Year 7 Police 129,600 (34,000)(2)95,600
2024 9 Pedestrian Improvements Program Pub Works 125,000 125,000
2024 10 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 11 Stormwater Improvement Program Pub Works 200,000 200,000
2024 12 Lease Program - Year 7 Pub Works 219,875 19,375 9,375 9,375 (73,000)(2)185,000
2024 13 Groundsmaster Mower (Replace #8066) (Purchased 2015)Pub Works 95,000 10,000 (3)105,000
2024 14 Groundsmaster Mower (Replace #8073) (Purchased 2015)Pub Works 95,000 10,000 (3)105,000
2024 15 Single-Axle Dump Truck (Replace #8432) (2012 Vehicle)Pub Works 151,000 39,000 (3)190,000
0 775,000 1,110,475 175,000 500,000 0 0 0 0 79,375 184,375 279,375 0 (28,000)3,075,600
Total CIP Funding Requirements - Year 2024 $1,885,475 $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).
5 of 11
MSA 11/1/19
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 Replace Police Portable Radio Batteries Police 5,500 5,500
2025 7 Squad Set Up and Equipment Installation Police 58,000 58,000
2025 8 Lease Program - Year 8 Police 132,800 (32,000)(2)100,800
2025 9 Pedestrian Improvements Program Pub Works 125,000 125,000
2025 10 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 11 Stormwater Improvement Program Pub Works 200,000 200,000
2025 12 Lease Program - Year 8 Pub Works 227,250 19,950 9,950 9,850 (140,000)(2)127,000
2025 13 Water Truck (Replace #8431) (2013 Vehicle)Pub Works 190,000 20,000 (3)210,000
2025 14 Dump Tandem (Replace #8434) (2013 Vehicle)Pub Works 195,000 35,000 (3)230,000
0 975,000 1,225,550 250,000 0 0 0 0 0 79,950 184,950 279,850 0 (109,000)2,886,300
Total CIP Funding Requirements - Year 2025 $2,200,550 $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).
6 of 11
MSA 11/1/19
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 New Neighborhood Park N- 5 Park & Rec 500,000 500,000
2026 4 Replace Half of AED's (6)Police 9,500 9,500
2026 5 Replace Duty Handguns (35)Police 21,000 21,000
2026 6 Squad Set Up and Equipment Installation Police 58,000 58,000
2026 7 Lease Program - Year 9 Police 135,400 (32,000)(2)103,400
2026 8 Pedestrian Improvements Program Pub Works 125,000 125,000
2026 9 PMP (Oak Ridge)Pub Works 200,000 50,000 50,000 300,000
2026 10 Stormwater Improvement Program Pub Works 200,000 200,000
2026 11 Lease Program - Year 9 Pub Works 229,250 19,950 9,950 9,850 (97,000)(2)172,000
2026 12 John Deere Trailer (Replace #0525) (Purchased 2010)Pub Works 12,000 12,000
2026 13 Wood Chipper (Replace #8161) (Purchased 2014)Pub Works 45,000 5,000 (3)50,000
2026 14 Jetter (Replace #8445) (2006 Vehicle)Pub Works 132,500 132,500 25,000 (3)290,000
0 325,000 535,150 50,000 500,000 0 0 0 50,000 19,950 142,450 342,350 0 21,000 1,985,900
Total CIP Funding Requirements - Year 2026 $860,150 $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).
7 of 11
MSA 11/1/19
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 Stormwater Improvement Program Pub Works 200,000 200,000
2027 8 Lease Program - Year 10 Pub Works 235,250 20,450 10,450 10,350 (104,000)(2)172,500
2027 9 Groundsmaster Mower (Replace #8068) (Purchased 2018)Pub Works 95,000 10,000 (3)105,000
2027 10 Dump Single (Replace #8437) (2014 Vehicle)Pub Works 170,000 40,000 (3)210,000
2027 11 Sweeper (Replace #8444) (Purchased 2017)Pub Works 110,000 110,000 20,000 (3)240,000
0 1,075,000 909,250 275,000 0 0 0 0 0 80,450 195,450 395,350 0 (74,000)2,856,500
Total CIP Funding Requirements - Year 2027 $1,984,250 $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).
8 of 11
MSA 11/1/19
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 Replace Police Portable Radio Batteries Police 6,000 6,000
2028 3 Squad Set Up and Equipment Installation Police 40,000 40,000
2028 4 Lease Program - Year 11 Police 129,400 (24,000)(2)105,400
2028 5 Pedestrian Improvements Program Pub Works 125,000 125,000
2028 6 PMP (Motz, Rosemount Hills A/B)Pub Works 1,300,000 400,000 65,000 190,000 75,000 2,030,000
2028 7 Stormwater Improvement Program Pub Works 200,000 200,000
2028 8 Lease Program - Year 11 Pub Works 242,250 22,450 10,450 10,350 (102,000)(2)183,500
2028 9 Bobcat (Replace #8420) (2018 Vehicle)Pub Works 35,000 35,000 15,000 (3)85,000
2028 10 Single-Axle Dump Truck (Replace #8433) (2016 Vehicle)Pub Works 185,000 35,000 (3)220,000
2028 11 Tandem-Axle Dump Truck (Replace #8435) (2016 Vehicle)Pub Works 210,000 40,000 (3)250,000
0 1,425,000 872,650 400,000 0 0 0 0 0 87,450 200,450 320,350 0 (36,000)3,269,900
Total CIP Funding Requirements - Year 2028 $2,297,650 $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).
9 of 11
MSA 11/1/19
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
2029 1 City-Wide Software Gen'l. Govt.25,000 25,000
2029 2 Squad Set Up and Equipment Installation Police 40,000 40,000
2029 3 Lease Program - Year 12 Police 0 (24,000)(2)(24,000)
2029 4 Pedestrian Improvements Program Pub Works 125,000 125,000
2029 5 PMP ()Pub Works 0 0 0 0 0 0
2029 6 Stormwater Improvement Program Pub Works 200,000 200,000
2029 7 Lease Program - Year 12 Pub Works 250,000 23,000 11,000 11,000 (102,000)(2)193,000
2029 8 Gator TS (Replace 8402) (2017 Vehicle)Pub Works 13,500 1,500 (3)15,000
2029 9 RTV Kubota (Replace 8401) (2017 Vehicle)Pub Works 26,000 4,000 (3)30,000
2029 10 Skid-Steer (Replace 8418) (2019 Vehicle)Pub Works 55,000 5,000 (3)60,000
0 125,000 409,500 0 0 0 0 0 0 23,000 11,000 211,000 0 (115,500)664,000
Total CIP Funding Requirements - Year 2029 $534,500 $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 2029 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 2029 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 2029 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).
10 of 11
MSA 11/1/19
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 50,000 50,000
Future 24 Surveillance Trailer (Replace #0523) (Purchased 2008)Pub Works 50,000 50,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
2030 27 Shop Hoist (Replace #0002) (Purchased 2006)Pub Works 55,000 5,000 60,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 of 11
11/1/19
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/1/19
Equipment Total
Year Item - Description Department CIP Other Cost
2018 Jeep Cherokee (Replaced #35180) - 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,650)(1)(550)
2019 Ford Police Explorer (Replaced 35170) - LEASE Police 7,100 (17,990)(1)(10,890)
.
61,309 (25,640)35,669
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/1/19
Equipment Total
Year Item - Description Department CIP Other Cost
2018 Jeep Cherokee - INV (Replaced #35180) - LEASE Police 6,636 6,636
2018 Dodge Caravan (Replaced #35120) - LEASE Police 5,652 5,652
2018 Jeep Cherokee (Replaced 35150) - LEASE Police 6,696 6,696
2018 Ford Police Explorer (Replaced 3520) - LEASE Police 5,304 5,304
2018 Ford Police Explorer (Replaced 3580) - LEASE Police 5,520 5,520
2018 Ford Police Explorer (Replaced 35100) - LEASE Police 5,304 5,304
2019 Jeep Cherokee INV (Replace 35010) - LEASE Police 6,312 6,312
2019 Dodge Durango (Replaced 35110) - LEASE Police 5,928 5,928
2019 Dodge Durango (Replaced 35170) - LEASE Police 3,696 3,696
2020 Ford Police Explorer (Replaced 3540) - LEASE Police 7,300 (7,500)(1)(200)
2020 Dodge Truck (Replaced 3550) - LEASE Police 7,300 (14,000)(1)(6,700)
2020 Ford Police Explorer (Replaced 3590) - LEASE Police 7,300 (7,000)(1)300
2020 Ford Police Explorer (Unknown #) - LEASE Police 7,300 7,300
80,248 (28,500)51,748
Total Lease Funding Requirements - Year 2020 $80,248
(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/1/19
Equipment Total
Year Item - Description Department CIP Other Cost
2018 Jeep Cherokee (Replaced #35180) - LEASE Police 6,636 6,636
2018 Dodge Caravan (Replaced #35120) - LEASE Police 5,652 5,652
2018 Jeep Cherokee (Replaced 35150) - LEASE Police 6,696 6,696
2018 Ford Police Explorer (Replaced 3520) - LEASE Police 5,304 5,304
2018 Ford Police Explorer (Replaced 3580) - LEASE Police 5,520 5,520
2018 Ford Police Explorer (Replaced 35100) - LEASE Police 5,304 5,304
2019 Ford Vehicle (Replace 35010) - LEASE Police 6,312 6,312
2019 Ford Police Explorer (Replaced 35110) - LEASE Police 5,928 5,928
2019 Ford Police Explorer (Replaced 35170) - LEASE Police 3,696 3,696
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
2020 Ford Police Explorer (Unknown #) - 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)
110,248 (32,000)78,248
Total Lease Funding Requirements - Year 2021 $110,248
(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/1/19
Equipment Total
Year Item - Description Department CIP Other Cost
2018 Dodge Caravan (Replaced #35120) - LEASE Police 5,652 5,652
2018 Jeep Cherokee (Replaced 35150) - LEASE Police 6,696 6,696
2019 Ford Vehicle (Replace 35010) - LEASE Police 6,312 6,312
2019 Ford Police Explorer (Replaced 35110) - LEASE Police 5,928 5,928
2019 Ford Police Explorer (Replaced 35170) - LEASE Police 3,696 3,696
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 (Unknown #) - 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 35180) - LEASE Police 7,000 (9,500)(1)(2,500)
2022 Ford Police Explorer (Replaced 3520) - LEASE Police 7,700 (8,000)(1)(300)
2022 Ford Police Explorer (Replaced 3580) - LEASE Police 7,700 (8,000)(1)(300)
2022 Ford Police Explorer (Replaced 35100) - LEASE Police 7,700 (8,000)(1)(300)
117,584 (33,500)84,084
Total Lease Funding Requirements - Year 2022 $117,584
(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/1/19
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 (Unknown #) - 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)
127,000 (40,000)87,000
Total Lease Funding Requirements - Year 2023 $127,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/1/19
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
2024 Ford Police Explorer (Replaced Unknown #)Police 8,100 (8,000)(1)100
129,600 (34,000)95,600
Total Lease Funding Requirements - Year 2024 $129,600
(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/1/19
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 Unknown #)Police 8,100 8,100
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
132,800 (32,000)100,800
Total Lease Funding Requirements - Year 2025 $132,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.
11/1/19
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 Unknown #)Police 8,100 8,100
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
135,400 (32,000)103,400
Total Lease Funding Requirements - Year 2026 $135,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/1/19
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 Unknown #)Police 8,100 8,100
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)
137,100 (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/1/19
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/1/19
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 9,448 9,448
2018 1/2-Ton Ex-Cab Pickup (Replace 8329) (2006 Vehicle) - LEASE Pub Works 4,959 4,959
2018 1-Ton Pickup w/Dump (Replace 8340) (2006 Vehicle) - LEASE Pub Works 8,592 8,592
2018 1-Ton Pickup (Replace 8345) (2007 Vehicle) - LEASE Pub Works 6,735 6,735
2018 1/2-Ton Ex-Cab Pickup (Replace 8346) (2006 Vehicle) - LEASE Pub Works 3,990 3,990
2019 1-Ton Pickup Extended Cab (Replace 8330) (2011 Vehicle) - LEASE Pub Works 8,785 (14,000)(1)(5,215)
2019 1-Ton Pickup (Replace 8341) (2011 Vehicle) - LEASE Pub Works 8,443 (14,000)(1)(5,557)
2019 Full Size Van - Park & Rec (Replace 8601) (2003 Vehicle) - LEASE Pub Works 6,179 (3,000)(1)3,179
2019 Caravan - Parks (Replace 8603) (2013 Vehicle) - LEASE Pub Works 5,449 (10,000)(1)(4,551)
2019 Ford Ranger - Inspections (Replace 8615) (2008 Vehicle) - LEASE Pub Works 5,694 (3,500)(1)2,194
.
61,539 6,735 0 0 0 (44,500)23,774
Total Lease Funding Requirements - Year 2019 $61,539
(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/1/19
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 9,448 9,448
2018 1/2-Ton Ex-Cab Pickup (Replace 8329) (2006 Vehicle) - LEASE Pub Works 4,959 4,959
2018 1-Ton Pickup w/Dump (Replace 8340) (2006 Vehicle) - LEASE Pub Works 8,592 8,592
2018 1-Ton Pickup (Replace 8345) (2007 Vehicle) - LEASE Pub Works 6,735 6,735
2018 1/2-Ton Ex-Cab Pickup (Replace 8346) (2006 Vehicle) - LEASE Pub Works 3,990 3,990
2019 1-Ton Pickup Extended Cab (Replace 8330) (2011 Vehicle) - LEASE Pub Works 8,785 8,785
2019 1-Ton Pickup (Replace 8341) (2011 Vehicle) - LEASE Pub Works 8,443 8,443
2019 Full Size Van - Park & Rec (Replace 8601) (2003 Vehicle) - LEASE Pub Works 6,179 6,179
2019 Caravan - Parks (Replace 8603) (2013 Vehicle) - LEASE Pub Works 5,449 5,449
2019 Ford Ranger - Inspections (Replace 8615) (2008 Vehicle) - LEASE Pub Works 5,694 5,694
2020 1-Ton Pickup w/Dump (Replace 8306) (2016 Vehicle) - LEASE Pub Works 12,500 (18,000)(1)(5,500)
2020 1/2-Ton Pickup (Replace 8307) (2015 Vehicle) - LEASE Pub Works 7,500 (12,000)(1)(4,500)
2020 1-Ton Pickup (Replace 8312) (2016 Vehicle) - LEASE Pub Works 2,125 2,125 2,125 2,125 (14,000)(1)(5,500)
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 8,500 (14,000)(1)(5,500)
2020 1/2-Ton Pickup (Replace 8335) (2015 Vehicle) - LEASE Pub Works 7,500 (12,000)(1)(4,500)
2020 1-Ton Pickup (NEW - Parks Crew Lead) - LEASE Pub Works 8,500 8,500
2020 1/2-Ton Pickup (NEW - Utilities Supervisor) - LEASE Pub Works 2,500 2,500 2,500 7,500
117,164 11,360 4,625 4,625 0 (84,000)53,774
Total Lease Funding Requirements - Year 2020 $117,164
(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/1/19
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 9,448 9,448
2018 1/2-Ton Ex-Cab Pickup (Replace 8329) (2006 Vehicle) - LEASE Pub Works 4,959 4,959
2018 1-Ton Pickup w/Dump (Replace 8340) (2006 Vehicle) - LEASE Pub Works 8,592 8,592
2018 1-Ton Pickup (Replace 8345) (2007 Vehicle) - LEASE Pub Works 6,735 6,735
2018 1/2-Ton Ex-Cab Pickup (Replace 8346) (2006 Vehicle) - LEASE Pub Works 3,990 3,990
2019 1-Ton Pickup Extended Cab (Replace 8330) (2011 Vehicle) - LEASE Pub Works 8,785 8,785
2019 1-Ton Pickup (Replace 8341) (2011 Vehicle) - LEASE Pub Works 8,443 8,443
2019 Full Size Van - Park & Rec (Replace 8601) (2003 Vehicle) - LEASE Pub Works 6,179 6,179
2019 Caravan - Parks (Replace 8603) (2013 Vehicle) - LEASE Pub Works 5,449 5,449
2019 Ford Ranger - Inspections (Replace 8615) (2008 Vehicle) - LEASE Pub Works 5,694 5,694
2020 1-Ton Pickup w/Dump (Replace 8306) (2016 Vehicle) - LEASE Pub Works 12,500 12,500
2020 1/2-Ton Pickup (Replace 8307) (2015 Vehicle) - LEASE Pub Works 7,500 7,500
2020 1-Ton Pickup (Replace 8312) (2016 Vehicle) - LEASE Pub Works 2,125 2,125 2,125 2,125 8,500
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 8,500 8,500
2020 1/2-Ton Pickup (Replace 8335) (2015 Vehicle) - LEASE Pub Works 7,500 7,500
2020 1-Ton Pickup (NEW - Parks Crew Lead) - LEASE Pub Works 8,500 8,500
2020 1/2-Ton Pickup (NEW - Utilities Supervisor) - LEASE Pub Works 2,500 2,500 2,500 7,500
2021 Escape 4x4 (Replace 8303) (2016 Vehicle) - LEASE Pub Works 6,500 (14,000)(1)(7,500)
2021 1-Ton Pickup (Replace 8334) (2015 Vehicle) - LEASE Pub Works 8,500 (16,000)(1)(7,500)
2021 1-Ton Pickup (Replace 8336) (2016 Vehicle) - LEASE Pub Works 8,500 (16,000)(1)(7,500)
2021 1/2-Ton Pickup (Replace 8343) (2016 Vehicle) - LEASE Pub Works 7,500 (12,000)(1)(4,500)
2021 1/2-Ton Pickup (Replace 8613) (2016 Vehicle) - LEASE Pub Works 7,500 (12,000)(1)(4,500)
2021 Escape 4x4 (Replace 8614) (2016 Vehicle) - LEASE Pub Works 6,500 (14,000)(1)(7,500)
162,164 11,360 4,625 4,625 0 (84,000)98,774
Total Lease Funding Requirements - Year 2021 $162,164
(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/1/19
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 9,448 9,448
2018 1/2-Ton Ex-Cab Pickup (Replace 8329) (2006 Vehicle) - LEASE Pub Works 4,959 4,959
2018 1-Ton Pickup w/Dump (Replace 8340) (2006 Vehicle) - LEASE Pub Works 8,592 8,592
2018 1-Ton Pickup (Replace 8345) (2007 Vehicle) - LEASE Pub Works 6,735 6,735
2018 1/2-Ton Ex-Cab Pickup (Replace 8346) (2006 Vehicle) - LEASE Pub Works 3,990 3,990
2019 1-Ton Pickup Extended Cab (Replace 8330) (2011 Vehicle) - LEASE Pub Works 8,785 8,785
2019 1-Ton Pickup (Replace 8341) (2011 Vehicle) - LEASE Pub Works 8,443 8,443
2019 Full Size Van - Park & Rec (Replace 8601) (2003 Vehicle) - LEASE Pub Works 6,179 6,179
2019 Caravan - Parks (Replace 8603) (2013 Vehicle) - LEASE Pub Works 5,449 5,449
2019 Ford Ranger - Inspections (Replace 8615) (2008 Vehicle) - LEASE Pub Works 5,694 5,694
2020 1-Ton Pickup w/Dump (Replace 8306) (2016 Vehicle) - LEASE Pub Works 12,500 12,500
2020 1/2-Ton Pickup (Replace 8307) (2015 Vehicle) - LEASE Pub Works 7,500 7,500
2020 1-Ton Pickup (Replace 8312) (2016 Vehicle) - LEASE Pub Works 2,125 2,125 2,125 2,125 8,500
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 8,500 8,500
2020 1/2-Ton Pickup (Replace 8335) (2015 Vehicle) - LEASE Pub Works 7,500 7,500
2020 1-Ton Pickup (NEW - Parks Crew Lead) - LEASE Pub Works 8,500 8,500
2020 1/2-Ton Pickup (NEW - Utilities Supervisor) - LEASE Pub Works 2,500 2,500 2,500 7,500
2021 Escape 4x4 (Replace 8303) (2016 Vehicle) - LEASE Pub Works 6,500 6,500
2021 1-Ton Pickup (Replace 8334) (2015 Vehicle) - LEASE Pub Works 8,500 8,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/2-Ton Pickup (Replace 8613) (2016 Vehicle) - LEASE Pub Works 7,500 7,500
2021 Escape 4x4 (Replace 8614) (2016 Vehicle) - LEASE Pub Works 6,500 6,500
2022 1-Ton Pickup (Replace 8308) (2017 Vehicle) - LEASE Pub Works 2,250 2,250 2,250 2,250 (17,000)(1)(8,000)
2022 1-Ton Pickup (Replace 8311) (2016 Vehicle) - LEASE Pub Works 9,000 (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-Ton Pickup w/Dump (Replace 8344) (2016 Vehicle) - LEASE Pub Works 12,500 (18,000)(1)(5,500)
2022 Caravan - Admin (Replace 8621) (2017 Vehicle) - LEASE Pub Works 6,500 (10,000)(1)(3,500)
201,414 16,110 9,375 9,375 0 (91,000)145,274
Total Lease Funding Requirements - Year 2022 $201,414
(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/1/19
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 8,785 8,785
2019 1-Ton Pickup (Replace 8341) (2011 Vehicle) - LEASE Pub Works 8,443 8,443
2019 Full Size Van - Park & Rec (Replace 8601) (2003 Vehicle) - LEASE Pub Works 6,179 6,179
2019 Caravan - Parks (Replace 8603) (2013 Vehicle) - LEASE Pub Works 5,449 5,449
2019 Ford Ranger - Inspections (Replace 8615) (2008 Vehicle) - LEASE Pub Works 5,694 5,694
2020 1-Ton Pickup w/Dump (Replace 8306) (2016 Vehicle) - LEASE Pub Works 12,500 12,500
2020 1/2-Ton Pickup (Replace 8307) (2015 Vehicle) - LEASE Pub Works 7,500 7,500
2020 1-Ton Pickup (Replace 8312) (2016 Vehicle) - LEASE Pub Works 2,125 2,125 2,125 2,125 8,500
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 8,500 8,500
2020 1/2-Ton Pickup (Replace 8335) (2015 Vehicle) - LEASE Pub Works 7,500 7,500
2020 1-Ton Pickup (NEW - Parks Crew Lead) - LEASE Pub Works 8,500 8,500
2020 1/2-Ton Pickup (NEW - Utilities Supervisor) - LEASE Pub Works 2,500 2,500 2,500 7,500
2021 Escape 4x4 (Replace 8303) (2016 Vehicle) - LEASE Pub Works 6,500 6,500
2021 1-Ton Pickup (Replace 8334) (2015 Vehicle) - LEASE Pub Works 8,500 8,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/2-Ton Pickup (Replace 8613) (2016 Vehicle) - LEASE Pub Works 7,500 7,500
2021 Escape 4x4 (Replace 8614) (2016 Vehicle) - LEASE Pub Works 6,500 6,500
2022 1-Ton Pickup (Replace 8308) (2017 Vehicle) - LEASE Pub Works 2,250 2,250 2,250 2,250 9,000
2022 1-Ton Pickup (Replace 8311) (2016 Vehicle) - LEASE Pub Works 9,000 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-Ton Pickup w/Dump (Replace 8344) (2016 Vehicle) - LEASE Pub Works 12,500 12,500
2022 Caravan - Admin (Replace 8621) (2017 Vehicle) - LEASE Pub Works 6,500 6,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 8,000 (12,000)(1)(4,000)
216,425 19,375 9,375 9,375 0 (77,000)177,550
Total Lease Funding Requirements - Year 2023 $216,425
(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/1/19
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/2-Ton Pickup (Replace 8307) (2015 Vehicle) - LEASE Pub Works 7,500 7,500
2020 1-Ton Pickup (Replace 8312) (2016 Vehicle) - LEASE Pub Works 2,125 2,125 2,125 2,125 8,500
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 8,500 8,500
2020 1/2-Ton Pickup (Replace 8335) (2015 Vehicle) - LEASE Pub Works 7,500 7,500
2020 1-Ton Pickup (NEW - Parks Crew Lead) - LEASE Pub Works 8,500 8,500
2020 1/2-Ton Pickup (NEW - Utilities Supervisor) - LEASE Pub Works 2,500 2,500 2,500 7,500
2021 Escape 4x4 (Replace 8303) (2016 Vehicle) - LEASE Pub Works 6,500 6,500
2021 1-Ton Pickup (Replace 8334) (2015 Vehicle) - LEASE Pub Works 8,500 8,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/2-Ton Pickup (Replace 8613) (2016 Vehicle) - LEASE Pub Works 7,500 7,500
2021 Escape 4x4 (Replace 8614) (2016 Vehicle) - LEASE Pub Works 6,500 6,500
2022 1-Ton Pickup (Replace 8308) (2017 Vehicle) - LEASE Pub Works 2,250 2,250 2,250 2,250 9,000
2022 1-Ton Pickup (Replace 8311) (2016 Vehicle) - LEASE Pub Works 9,000 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-Ton Pickup w/Dump (Replace 8344) (2016 Vehicle) - LEASE Pub Works 12,500 12,500
2022 Caravan - Admin (Replace 8621) (2017 Vehicle) - LEASE Pub Works 6,500 6,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 8,000 8,000
2024 1-Ton Pickup Extended Cab (Replace 8330) (2019 Vehicle) - LEASE Pub Works 9,500 (17,000)(1)(7,500)
2024 1-Ton Pickup (Replace 8341) (2019 Vehicle) - LEASE Pub Works 9,500 (17,000)(1)(7,500)
2024 Full Size Van - Park & Rec (Replace 8601) (2019 Vehicle) - LEASE Pub Works 7,000 (12,000)(1)(5,000)
2024 Caravan - Parks (Replace 8603) (2019 Vehicle) - LEASE Pub Works 6,000 (12,000)(1)(6,000)
2024 Excape 4x4 - Inspections (Replace 8615) (2019 Vehicle) - LEASE Pub Works 6,000 (15,000)(1)(9,000)
219,875 19,375 9,375 9,375 0 (73,000)185,000
Total Lease Funding Requirements - Year 2024 $219,875
(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/1/19
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 6,500 6,500
2021 1-Ton Pickup (Replace 8334) (2015 Vehicle) - LEASE Pub Works 8,500 8,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/2-Ton Pickup (Replace 8613) (2016 Vehicle) - LEASE Pub Works 7,500 7,500
2021 Escape 4x4 (Replace 8614) (2016 Vehicle) - LEASE Pub Works 6,500 6,500
2022 1-Ton Pickup (Replace 8308) (2017 Vehicle) - LEASE Pub Works 2,250 2,250 2,250 2,250 9,000
2022 1-Ton Pickup (Replace 8311) (2016 Vehicle) - LEASE Pub Works 9,000 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-Ton Pickup w/Dump (Replace 8344) (2016 Vehicle) - LEASE Pub Works 12,500 12,500
2022 Caravan - Admin (Replace 8621) (2017 Vehicle) - LEASE Pub Works 6,500 6,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 8,000 8,000
2024 1-Ton Pickup Extended Cab (Replace 8330) (2019 Vehicle) - LEASE Pub Works 9,500 9,500
2024 1-Ton Pickup (Replace 8341) (2019 Vehicle) - LEASE Pub Works 9,500 9,500
2024 Full Size Van - Park & Rec (Replace 8601) (2019 Vehicle) - LEASE Pub Works 7,000 7,000
2024 Caravan - Parks (Replace 8603) (2019 Vehicle) - LEASE Pub Works 6,000 6,000
2024 Excape 4x4 - Inspections (Replace 8615) (2019 Vehicle) - LEASE Pub Works 6,000 6,000
2025 1-Ton Pickup w/Dump (Replace 8306) (2016 Vehicle) - LEASE Pub Works 14,000 (20,000)(1)(6,000)
2025 1/2-Ton Pickup (Replace 8307) (2015 Vehicle) - LEASE Pub Works 8,500 (16,000)(1)(7,500)
2025 1-Ton Pickup (Replace 8312) (2016 Vehicle) - LEASE Pub Works 2,500 2,500 2,500 2,500 (18,000)(1)(8,000)
2025 1-Ton Pickup - Irrigation (Replace 8331) (2015 Vehicle) - LEASE Pub Works 10,000 (18,000)(1)(8,000)
2025 1-Ton Pickup (Replace 8332) (2015 Vehicle) - LEASE Pub Works 10,000 (18,000)(1)(8,000)
2025 1/2-Ton Pickup (Replace 8335) (2015 Vehicle) - LEASE Pub Works 8,000 (16,000)(1)(8,000)
2025 1-Ton Pickup (NEW - Parks Crew Lead) - LEASE Pub Works 10,000 (18,000)(1)(8,000)
2025 1/2-Ton Pickup (NEW - Utilities Supervisor) - LEASE Pub Works 2,700 2,700 2,600 (16,000)(1)(8,000)
227,250 19,950 9,950 9,850 0 (140,000)127,000
Total Lease Funding Requirements - Year 2025 $227,250
(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/1/19
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 2,250 2,250 2,250 2,250 9,000
2022 1-Ton Pickup (Replace 8311) (2016 Vehicle) - LEASE Pub Works 9,000 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-Ton Pickup w/Dump (Replace 8344) (2016 Vehicle) - LEASE Pub Works 12,500 12,500
2022 Caravan - Admin (Replace 8621) (2017 Vehicle) - LEASE Pub Works 6,500 6,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 8,000 8,000
2024 1-Ton Pickup Extended Cab (Replace 8330) (2019 Vehicle) - LEASE Pub Works 9,500 9,500
2024 1-Ton Pickup (Replace 8341) (2019 Vehicle) - LEASE Pub Works 9,500 9,500
2024 Full Size Van - Park & Rec (Replace 8601) (2019 Vehicle) - LEASE Pub Works 7,000 7,000
2024 Caravan - Parks (Replace 8603) (2019 Vehicle) - LEASE Pub Works 6,000 6,000
2024 Excape 4x4 - Inspections (Replace 8615) (2019 Vehicle) - LEASE Pub Works 6,000 6,000
2025 1-Ton Pickup w/Dump (Replace 8306) (2016 Vehicle) - LEASE Pub Works 14,000 14,000
2025 1/2-Ton Pickup (Replace 8307) (2015 Vehicle) - LEASE Pub Works 8,500 8,500
2025 1-Ton Pickup (Replace 8312) (2016 Vehicle) - LEASE Pub Works 2,500 2,500 2,500 2,500 10,000
2025 1-Ton Pickup - Irrigation (Replace 8331) (2015 Vehicle) - LEASE Pub Works 10,000 10,000
2025 1-Ton Pickup (Replace 8332) (2015 Vehicle) - LEASE Pub Works 10,000 10,000
2025 1/2-Ton Pickup (Replace 8335) (2015 Vehicle) - LEASE Pub Works 8,000 8,000
2025 1-Ton Pickup (NEW - Parks Crew Lead) - LEASE Pub Works 10,000 10,000
2025 1/2-Ton Pickup (NEW - Utilities Supervisor) - LEASE Pub Works 2,700 2,700 2,600 8,000
2026 Escape 4x4 (Replace 8303) (2016 Vehicle) - LEASE Pub Works 7,000 (15,000)(1)(8,000)
2026 1-Ton Pickup (Replace 8334) (2015 Vehicle) - LEASE Pub Works 9,000 (18,000)(1)(9,000)
2026 1-Ton Pickup (Replace 8336) (2016 Vehicle) - LEASE Pub Works 9,000 (18,000)(1)(9,000)
2026 1/2-Ton Pickup (Replace 8343) (2016 Vehicle) - LEASE Pub Works 8,000 (16,000)(1)(8,000)
2026 Escape 4x4 (Replace 8614) (2016 Vehicle) - LEASE Pub Works 7,000 (15,000)(1)(8,000)
2026 Caravan - Admin (Replace 8621) (2017 Vehicle) - LEASE Pub Works 7,000 (15,000)(1)(8,000)
229,250 19,950 9,950 9,850 0 (97,000)172,000
Total Lease Funding Requirements - Year 2026 $229,250
(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/1/19
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 8,000 8,000
2024 1-Ton Pickup Extended Cab (Replace 8330) (2019 Vehicle) - LEASE Pub Works 9,500 9,500
2024 1-Ton Pickup (Replace 8341) (2019 Vehicle) - LEASE Pub Works 9,500 9,500
2024 Full Size Van - Park & Rec (Replace 8601) (2019 Vehicle) - LEASE Pub Works 7,000 7,000
2024 Caravan - Parks (Replace 8603) (2019 Vehicle) - LEASE Pub Works 6,000 6,000
2024 Excape 4x4 - Inspections (Replace 8615) (2019 Vehicle) - LEASE Pub Works 6,000 6,000
2025 1-Ton Pickup w/Dump (Replace 8306) (2016 Vehicle) - LEASE Pub Works 14,000 14,000
2025 1/2-Ton Pickup (Replace 8307) (2015 Vehicle) - LEASE Pub Works 8,500 8,500
2025 1-Ton Pickup (Replace 8312) (2016 Vehicle) - LEASE Pub Works 2,500 2,500 2,500 2,500 10,000
2025 1-Ton Pickup - Irrigation (Replace 8331) (2015 Vehicle) - LEASE Pub Works 10,000 10,000
2025 1-Ton Pickup (Replace 8332) (2015 Vehicle) - LEASE Pub Works 10,000 10,000
2025 1/2-Ton Pickup (Replace 8335) (2015 Vehicle) - LEASE Pub Works 8,000 8,000
2025 1-Ton Pickup (NEW - Parks Crew Lead) - LEASE Pub Works 10,000 10,000
2025 1/2-Ton Pickup (NEW - Utilities Supervisor) - LEASE Pub Works 2,700 2,700 2,600 8,000
2026 Escape 4x4 (Replace 8303) (2016 Vehicle) - LEASE Pub Works 7,000 7,000
2026 1-Ton Pickup (Replace 8334) (2015 Vehicle) - LEASE Pub Works 9,000 9,000
2026 1-Ton Pickup (Replace 8336) (2016 Vehicle) - LEASE Pub Works 9,000 9,000
2026 1/2-Ton Pickup (Replace 8343) (2016 Vehicle) - LEASE Pub Works 8,000 8,000
2026 Escape 4x4 (Replace 8614) (2016 Vehicle) - LEASE Pub Works 7,000 7,000
2026 Caravan - Admin (Replace 8621) (2017 Vehicle) - LEASE Pub Works 7,000 7,000
2027 1-Ton Pickup (Replace 8308) (2017 Vehicle) - LEASE Pub Works 2,250 2,250 2,250 2,250 (18,000)(1)(9,000)
2027 1-Ton Pickup (Replace 8311) (2016 Vehicle) - LEASE Pub Works 10,000 (18,000)(1)(8,000)
2027 1-Ton Pickup (Replace 8315) (2017 Vehicle) - LEASE Pub Works 10,000 (18,000)(1)(8,000)
2027 1/2-Ton Pickup (Replace 8333) (2017 Vehicle) - LEASE Pub Works 3,000 3,000 3,000 (16,000)(1)(7,000)
2027 1/2-Ton Pickup - Parks (Replace 8336) (2016 Vehicle) - LEASE Pub Works 9,000 (16,000)(1)(7,000)
2027 1-Ton Pickup w/Dump (Replace 8344) (2016 Vehicle) - LEASE Pub Works 14,000 (18,000)(1)(4,000)
235,250 20,450 10,450 10,350 0 (104,000)172,500
Total Lease Funding Requirements - Year 2027 $235,250
(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/1/19
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,500 9,500
2024 1-Ton Pickup (Replace 8341) (2019 Vehicle) - LEASE Pub Works 9,500 9,500
2024 Full Size Van - Park & Rec (Replace 8601) (2019 Vehicle) - LEASE Pub Works 7,000 7,000
2024 Caravan - Parks (Replace 8603) (2019 Vehicle) - LEASE Pub Works 6,000 6,000
2024 Excape 4x4 - Inspections (Replace 8615) (2019 Vehicle) - LEASE Pub Works 6,000 6,000
2025 1-Ton Pickup w/Dump (Replace 8306) (2016 Vehicle) - LEASE Pub Works 14,000 14,000
2025 1/2-Ton Pickup (Replace 8307) (2015 Vehicle) - LEASE Pub Works 8,500 8,500
2025 1-Ton Pickup (Replace 8312) (2016 Vehicle) - LEASE Pub Works 2,500 2,500 2,500 2,500 10,000
2025 1-Ton Pickup - Irrigation (Replace 8331) (2015 Vehicle) - LEASE Pub Works 10,000 10,000
2025 1-Ton Pickup (Replace 8332) (2015 Vehicle) - LEASE Pub Works 10,000 10,000
2025 1/2-Ton Pickup (Replace 8335) (2015 Vehicle) - LEASE Pub Works 8,000 8,000
2025 1-Ton Pickup (NEW - Parks Crew Lead) - LEASE Pub Works 10,000 10,000
2025 1/2-Ton Pickup (NEW - Utilities Supervisor) - LEASE Pub Works 2,700 2,700 2,600 8,000
2026 Escape 4x4 (Replace 8303) (2016 Vehicle) - LEASE Pub Works 7,000 7,000
2026 1-Ton Pickup (Replace 8334) (2015 Vehicle) - LEASE Pub Works 9,000 9,000
2026 1-Ton Pickup (Replace 8336) (2016 Vehicle) - LEASE Pub Works 9,000 9,000
2026 1/2-Ton Pickup (Replace 8343) (2016 Vehicle) - LEASE Pub Works 8,000 8,000
2026 Escape 4x4 (Replace 8614) (2016 Vehicle) - LEASE Pub Works 7,000 7,000
2026 Caravan - Admin (Replace 8621) (2017 Vehicle) - LEASE Pub Works 7,000 7,000
2027 1-Ton Pickup (Replace 8308) (2017 Vehicle) - LEASE Pub Works 2,250 2,250 2,250 2,250 9,000
2027 1-Ton Pickup (Replace 8311) (2016 Vehicle) - LEASE Pub Works 10,000 10,000
2027 1-Ton Pickup (Replace 8315) (2017 Vehicle) - LEASE Pub Works 10,000 10,000
2027 1/2-Ton Pickup (Replace 8333) (2017 Vehicle) - LEASE Pub Works 3,000 3,000 3,000 9,000
2027 1/2-Ton Pickup - Parks (Replace 8336) (2016 Vehicle) - LEASE Pub Works 9,000 9,000
2027 1-Ton Pickup w/Dump (Replace 8344) (2016 Vehicle) - LEASE Pub Works 14,000 14,000
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 (18,000)(1)(8,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 (22,000)(1)(10,000)
2028 1/2-Ton Ex-Cab Pickup (Replace 8346) (2018 Vehicle) - LEASE Pub Works 9,000 (18,000)(1)(9,000)
242,250 22,450 10,450 10,350 0 (102,000)183,500
Total Lease Funding Requirements - Year 2028 $242,250
(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.