HomeMy WebLinkAbout2.b. CIP Review
EXECUTIVE SUMMARY
City Council Work Session: November 13, 2017
AGENDA ITEM: Review Capital Improvement Plan AGENDA SECTION:
Discussion
PREPARED BY: Logan Martin, City Administrator
Jeff May, Finance Director AGENDA NO. 2.b.
ATTACHMENTS: 2018-2027 CIP 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. 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.
• 2018 – 2019: Flint Hill Fields improvements ($2.7M)
o Includes the completion of the northern four fields, parking lot, & a small play structure.
• 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 ($300,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
CONCLUSION
Staff will review these projects and others on the CIP with the Council at the November 13 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 5 City Council meeting.
MSA 11/9/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).
1 of 11
MSA 11/9/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).
2 of 11
MSA 11/9/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).
3 of 11
MSA 11/9/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).
4 of 11
MSA 11/9/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).
5 of 11
MSA 11/9/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).
6 of 11
MSA 11/9/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).
7 of 11
MSA 11/9/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).
8 of 11
MSA 11/9/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).
9 of 11
MSA 11/9/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).
10 of 11
MSA 11/9/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.
11 of 11
11/9/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.
11/9/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.
11/9/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.
11/9/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.
11/9/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.
11/9/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.
11/9/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.
11/9/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.