Loading...
Buffalo Grove CIPSECTION SIX: CAPITAL IMPROVEMENT CAPITAL IMPROVEMENT PLAN – CAPITAL IMPROVEMENT STREETS – CAPITAL IMPROVEMENT FACILITIES – MOTOR FUEL TAX Water & Sanitary Sewer 18% Building and Grounds 32% Golf Course Improvements 1% Street, Sidewalk, & Bikepath 42% Strom Water Management 4% Technology 3% 2019 Capital Project Requests by Category CAPITAL IMPROVEMENT REQUEST SUMMARY The Capital Improvement Plan (CIP) is intended to be a decision-making tool for the Village Board and staff. Capital improvement projects represent the equipment and infrastructure that must be provided to residents and businesses. The need for capital expenditures are weighed against the ability of the Village to finance these projects. The Village Board’s ultimate approval of the CIP does not authorize spending on the included projects. Staff continues to review and evaluate each project throughout the 2019 budget cycle. Projects identified for FY 2019 total $20,908,728 and fall under six categories. The following chart illustrates each category’s percentage as it relates to the capital requests received for FY 2019. The CIP was changed from a five year projection to a twenty year projection in 2019. The increase in the rage of the plan allows for a more accurate projection of the village’s capital needs. The Village maintains multiple capital assets and infrastructure systems that are costly to operate and replace. For reference, the FY2019 budget requests and funding schedule and the 5-year forecast of funding requests for capital project improvements are included. Page 137 of 424 2019 Capital Projects Budgeted by Fund General Fund Requested Budgeted Annual Sidewalk/Bike Path Maintenance $325,000 $175,000 Cardiac Monitors - Fire Department (Reserve) $31,000 $0 EOC Radio Replacement - Fire Department (Reserve) $45,000 $0 Storm Water System Upgrades and Repairs $750,000 $300,000 Villagewide Comprehensive Plan $150,000 $150,000 Subtotal $1,301,000 $625,000 Motor Fuel Tax Fund Annual Street Maintenance $7,140,000 $1,500,000 Subtotal $7,140,000 $1,500,000 Capital Project- Streets Fund Collector Route Maintenance and Rehabilitation Program $145,000 $145,000 Lake Cook Road Improvement $210,000 $210,000 Municipal Parking Facility $310,000 $0 Weiland Road/Prairie Road Improvements $750,000 $750,000 Subtotal $1,415,000 $1,105,000 Capital Projects - Facilities Fund Building Replacement - CAFT $305,195 $305,195 Fire Station Sign Replacement $28,000 $0 Fire Station 25 Replacement $350,000 $0 Fire Station 26 Addition $0 $0 Fire Station 27 Remodel $0 $0 Flooring Capital Replacement Projects $98,154 $0 Police Headquarters $150,000 $0 Public Works Facility $5,000,000 $0 Roof Capital Replacement Projects $518,954 $0 Village Campus Long Range Planning $80,000 $80,000 Village Gateway Feature $25,000 $0 Village Hall Office Remodel $68,425 $0 Subtotal $6,908,728 $385,195 Page 138 of 424 2019 Capital Projects Budgeted by Fund Continued Information Technology Fund Laserfiche $28,000 $28,000 Microsoft Licensing $52,000 $52,000 Multiple Area Network (Reserve) $150,000 $0 Police Mobile Computers ( DUI Fund) $120,000 $0 Server Replacement $25,000 $25,000 Telephone System $0 $0 Antenna Towers $25,000 $25,000 Subtotal $400,000 $130,000 Water & Sewer Fund Capacity Management Operations & Maintenance $64,000 $64,000 Lift Station Repair & Rehabilitation $850,000 $850,000 Pump House Repairs & Security Improvements $150,000 $150,000 Villagewide Sanitary Sewer Replacement $1,185,000 $525,000 Villagewide Water Main Replacement $1,540,000 $700,000 SCADA Improvements $140,000 $140,000 Subtotal $3,929,000 $2,429,000 Golf Fund Golf Course Improvements $75,000 $0 Golf Course Irrigation Improvements $25,000 $0 Golf Course Parking Lot Maintenance $0 $0 Subtotal $100,000 $0 Total $21,193,728 $6,174,195 General Fund 10% Motor Fuel Tax Fund 24% Capital Project- Streets Fund 18% Capital Projects - Facilities Fund 6% Infromation Technology Fund 2% Water & Sewer Fund 40% Golf Fund 0% 2019 Capital Projects Budgeted by Fund Page 139 of 424 2019 Capital Projects Forecasted Requests by Fund Capital Projects Facilities 2019 2020 2021 2022 2023 Total Building Replacement - CAFT 305,195 - - - - 305,195 Flooring Capital Replacement Projects 98,154 20,000 20,000 20,000 20,000 178,154 Fire Station 27 Remodel - - 868,655 - - 868,655 HVAC Unit Replacements -120,000 120,000 120,000 120,000 480,000 Police Headquarters 150,000 100,000 100,000 100,000 100,000 550,000 Roof Capital Replacement Projects 518,954 25,000 85,000 420,000 -1,048,954 Fire Station Sign Replacement 28,000 28,000 28,000 - - 84,000 Village Campus Long Range Planning 80,000 - - - - 80,000 Village Gateway Feature 25,000 50,000 25,000 - - 100,000 Fire Station 26 Addition -2,745,712 - - - 2,745,712 Public Works Facility 5,000,000 25,000,000 2,000,000 -- 32,000,000 Village Hall Office Remodel 68,425 - - - - 68,425 Fire Station 25 Replacement 350,000 3,500,000 - - - 3,850,000 Subtotal $6,623,728 $31,588,712 $3,246,655 $,000 $240,000 $42,359,095 Golf Course Improvements Golf Course Improvements 75,000 75,000 75,000 40,000 250,000 515,000 Golf Course Irrigation Improvements 25,000 55,000 - - - 80,000 Golf Course Parking Lot Maintenance -14,000 - - - 14,000 Subtotal $100,000 $144,000 $75,000 $40,000 $250,000 $609,000 Capital Projects Streets Annual Street Maintenance 7,140,000 10,633,200 7,251,600 9,123,600 6,856,000 41,004,400 Collector Route Maintenance and Rehabilitation Program 145,000 770,000 770,000 770,000 500,000 2,955,000 Lake Cook Road Improvement 210,000 210,000 210,000 - - 630,000 Weiland Road/Prairie Road Improvements 750,000 50,000 - - - 800,000 Municipal Parking Facility 310,000 174,000 149,000 100,000 100,000 833,000 Subtotal $8,555,000 $11,837,200 $8,380,600 $9,993,600 $7,456,000 $46,222,400 General Fund Villagewide Comprehensive Planning and Design 150,000 100,000 - - - 250,000 Annual Sidewalk/Bike Path Maintenance 325,000 325,000 325,000 325,000 325,000 1,625,000 Storm Water System Upgrades 750,000 420,000 420,000 400,000 400,000 2,390,000 Cardiac Monitors - Fire 31,000 31,000 31,000 - - 93,000 EOC Radio Replacement - Fire 45,000 - - - - 45,000 Subtotal $1,301,000 $876,000 $776,000 $725,000 $725,000 $4,403,000 Page 140 of 424 2019-2038 CAPITAL IMPROVEMENT PLAN 2 019 BUDGET CYCLE PRELIMINARY REQUESTS Page 142 of 424 Villagewide Comprehensive Planning and Design Project #1001 Category 1-Buildings and Grounds Priority 4-Contributory Useful Life 10 Years Origination Planning Tool User Department Community Development Coordinator Community Development Current Budget 100,000$ Initial Proposal Date 2018 Design Work 2019 Project Work N/A Location Reoccurance 2030 Asset Valuation N/A Last Deferred N/A Last Incurred 2018 Fund General Fund Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ 50,000$ 50,000$ 2019 2020 2021 2022 2023 Short Term Short Term 150,000$ 100,000$ -$ -$ -$ 250,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ 250,000$ 250,000$ 250,000$ 500,000$ 10 Year Financial Trend Financial Impact Planning Document Issue The Village’s Comprehensive Plan was last updated in 2009. Furthermore, the request would address the creation of design and streetscape guidelines for the recently adopted Lake Cook Corridor Plan. Solution The Village Board and staff have set a goal to update the Village Wide Comprehensive Plan. Completing this task would fulfill goals and recommendation outlined in both the Economic Development Plan and the Village’s Strategic Plan. This would be a 2-year project with the first phase estimated at $100,000 for 2019. The creation of design and streetscape guidelines for the Lake Cook Corridor would address the goals outlined in the Lake Cook Corridor Plan and also provide clear design criteria to future developments in the corridor. Staff is estimating that the cost to complete this task would be $50,000. CIP $- $50,000 $100,000 $150,000 $200,000 2014201520162017201820192020202120222023Page 143 of 424 Building Replacement - CAFT Project #1002 Category 1-Buildings and Grounds Priority 2-Essential Useful Life 30 Years Origination New User Department Fire Coordinator Fire Current Budget 1,065,195$ Initial Proposal Date 2016 Design Work 2017 Project Work 2019 Location Reoccurance 2034 (First Renovation) Asset Valuation 1,200,000$ Last Deferred N/A Last Incurred 2000 Fund Capital Projects - Facilities Account Number 160.75.560.20 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ 45,000$ -$ 45,000$ 2019 2020 2021 2022 2023 Short Term Short Term 305,195$ -$ -$ -$ -$ 305,195$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ 50,000$ -$ 50,000$ 305,195$ 355,195$ 10 Year Financial Trend Financial Impact Krause Drive Combined Area Fire Training Site Issue In 2000, the CAFT training center was constructed of donated office trailers with the intent of replacing the structure with a permanent building in 10 years. The temporary building was demolished in 2016 due to health hazards associated with animal infestation and mold. Solution Building estimates have been gathered from architects and pre-fabricated building manufacturers which resulted in a construction estimate of $1,065,195. This cost would be divided by the five (5) CAFT fire departments with each being responsible for their cost of $195,000. The BGFD would be responsible for an additional $110,195 which would add an apparatus bay and offices that would allow the building to be used as a temporary fire station when needed. CIP $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 2014201520162017201820192020202120222023Page 144 of 424 Flooring Capital Replacement Projects Project #1003 Category 1-Buildings and Grounds Priority 4-Contributory Useful Life 10 Years Origination Major Maintenance User Department PW Coordinator PW Current Budget 82,768$ Initial Proposal Date 2015 Design Work 2018 Project Work 2019 Location Reoccurance Yearly Asset Valuation 1,200,000$ Last Deferred N/A Last Incurred 2018 Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ 32,452$ 44,932$ 159,033$ 82,768$ 319,185$ 2019 2020 2021 2022 2023 Short Term Short Term 98,154$ 20,000$ 20,000$ 20,000$ 20,000$ 178,154$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 250,000$ 250,000$ 250,000$ 750,000$ 178,154$ 928,154$ 10 Year Financial Trend Financial Impact Village Buildings Issue On average, carpet is 4-6 years past the date it was scheduled to be replaced. Solution 2019 flooring replacement projects include carpet and tile at Village Hall. For 2020-2023, flooring replacements would continue at each of the fire stations. CIP $- $50,000 $100,000 $150,000 $200,000 2014201520162017201820192020202120222023Page 145 of 424 Fire Station #27 Remodel Project #1004 Category 1-Buildings and Grounds Priority 3-Sustaining Useful Life 20 Years Origination New User Department Fire Coordinator Fire Current Budget -$ Initial Proposal Date 2016 Design Work 2021 Project Work 2021 Location Reoccurance 2041 Asset Valuation 5,469,400$ Last Deferred N/A Last Incurred N/A Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term -$ -$ 868,655$ -$ -$ 868,655$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ -$ -$ 868,655$ 868,655$ 10 Year Financial Trend Financial Impact Fire Station #27 Issue Fire Station 27 was built in 1993 as a full time fire station and is the newest of the three fire stations. The 2014 and 2017 space needs assessments, both defined the need for renovated space and a fire sprinkler installation on the first floor. Solution Wold Architects recommended a moderate renovation of the residential space (700 sq ft/$87,500) and completing the first floor fire sprinkler system ($100,000). Other costs identified by Wold included Soft Costs ($74,130), Facility analysis ($30,250), Furniture/Fixtures/Equipment ($15,000) and contingency ($61,775) for a total of $868,655. CIP $- $200,000 $400,000 $600,000 $800,000 $1,000,000 2014201520162017201820192020202120222023Page 146 of 424 HVAC Unit Replacements Project #1005 Category 1-Buildings and Grounds Priority 2-Essential Useful Life 18 Years Origination Major Maintenance User Department PW Coordinator PW Current Budget -$ Initial Proposal Date 2015 Design Work 2018 Project Work 2019 Location Reoccurance 2036 Asset Valuation -$ Last Deferred 2018 Last Incurred 2018 (Unbudgeted) Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ 92,237$ 550,000$ 250,000$ 892,237$ 2019 2020 2021 2022 2023 Short Term Short Term -$ 120,000$ 120,000$ 120,000$ 120,000$ 480,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 250,000$ 250,000$ 250,000$ 750,000$ 480,000$ 1,230,000$ 10 Year Financial Trend Financial Impact Village Facilities Issue The Village maintains 61 HVAC units in total and more than half are currently exceeding their 18 year life expectancy. Solution In 2018, replacements of HVAC units are planned at Police (1 units and controls), Village Hall (6 units), and BG Golf Course (1 unit). Several failures during the year have lead to emergency expenses, although no money was budgeted in 2018. Due to these end of year replacements, no request is being made in 2019. CIP $- $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 2014201520162017201820192020202120222023Page 147 of 424 Roof Capital Replacement Projects Project #1006 Category 1-Buildings and Grounds Priority 3-Sustaining Useful Life 30 Years Origination Major Maintenance User Department PW Coordinator PW Current Budget -$ Initial Proposal Date 2014 Design Work 2018 Project Work 2019 Location Reoccurance 2048 Asset Valuation 2,000,000$ Last Deferred 2018 Last Incurred 2017 Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ 197,766$ 72,000$ 276,850$ -$ 546,616$ 2019 2020 2021 2022 2023 Short Term Short Term 518,954$ 25,000$ 85,000$ 420,000$ -$ 1,048,954$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 191,800$ 250,000$ 300,000$ 741,800$ 1,048,954$ 1,790,754$ 10 Year Financial Trend Financial Impact Village Facilities Issue Roof replacement projects were identified during the 2018 roof inspection reports prepared by Industrial Roofing Services. Solution For 2019, work is planned to include Police, Public Service Center, and Well #1. CIP $- $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 2014201520162017201820192020202120222023Page 148 of 424 Fire Station Sign Replacement Project #1007 Category 1-Buildings and Grounds Priority 4-Contributory Useful Life 20 Years Origination Major Maintenance User Department Fire Coordinator Fire Current Budget -$ Initial Proposal Date 2016 Design Work 2019 Project Work 2019 Location Reoccurance 2041 Asset Valuation 84,000$ Last Deferred 2017 Last Incurred N/A Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term 28,000$ 28,000$ 28,000$ -$ -$ 84,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ -$ -$ 84,000$ 84,000$ 10 Year Financial Trend Financial Impact Fire Stations 25, 26, & 27 Issue The current signs are deteriorated and poorly oriented for visibility. Solution Plan for replacement of one sign at each fire station, over each of three years. CIP $- $5,000 $10,000 $15,000 $20,000 $25,000 $30,000 2014201520162017201820192020202120222023Page 149 of 424 Village Campus Long Range Planning Project #1008 Category 1-Buildings and Grounds Priority 4-Contributory Useful Life 10 years Origination New User Department Community Development Coordinator Community Development Current Budget 80,000$ Initial Proposal Date 2017 Design Work 2018 Project Work N/A Location Reoccurance As Needed Asset Valuation N/A Last Deferred N/A Last Incurred 2017 Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ 20,000$ -$ 20,000$ 2019 2020 2021 2022 2023 Short Term Short Term 80,000$ -$ -$ -$ -$ 80,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ -$ -$ 80,000$ 80,000$ 10 Year Financial Trend Financial Impact Village Campus Planning Issue Several buildings on the Village Campus are nearing the end of their useful life and do not fit the space or configuration required for current Village operations. Solution In 2017, the Village used Wold Architects to begin a space needs assessment of the currentl buildings. 2019 work will continue to evaluate solutions for either major renovations and remodeling, or a move to new buildings. CIP $- $20,000 $40,000 $60,000 $80,000 $100,000 2014201520162017201820192020202120222023Page 150 of 424 Village Gateway Feature (Milwaukee Ave/Deerfield Ave) Project #1009 Category 1-Buildings and Grounds Priority 4-Contributory Useful Life 20 Years Origination New User Department Community Development Coordinator Community Development Current Budget 25,000$ Initial Proposal Date 2017 Design Work 2019 Project Work 2020 Location Reoccurance 2030 (First Maintenance) Asset Valuation 100,000$ Last Deferred 2018 Last Incurred N/A Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term 25,000$ 50,000$ 25,000$ -$ -$ 100,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ 10,000$ -$ 10,000$ 100,000$ 110,000$ 10 Year Financial Trend Financial Impact Corner of Milwaukee Ave and Deerfield Ave Issue As part of the Woodman's project, staff has proposed the replacement of the Village entrance sign with a new "gateway" feature. Solution A new gateway feature, possibly including a new sign, landscaping, and pedestrian amenities would be designed in 2019 for construction in 2020-2021. CIP $- $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 2014201520162017201820192020202120222023Page 151 of 424 Police Headquarters Project #1010 Category 1-Buildings and Grounds Priority 4-Contributory Useful Life 15 Years Origination Major Maintenance User Department Police Coordinator PW Current Budget -$ Initial Proposal Date 2019 Design Work 2019 Project Work 2019 Location Reoccurance 2034 Asset Valuation 11,920,340$ Last Deferred N/A Last Incurred N/A Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term 150,000$ 100,000$ 100,000$ 100,000$ 100,000$ 550,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 9,540,000$ 850,000$ -$ 10,390,000$ 550,000$ 10,940,000$ 10 Year Financial Trend Financial Impact Police Headquarters Issue Police Headquarters was originally built in 1988, with the last major addition in 1997. Major maintenance and remodeling are required. Solution For 2019, Police is requesting two areas of major work. First, the locker room shower areas, in both the men's and women's locker rooms needs a full remodel with work to reconfigure the space to add privacy. All tile work and plumbing is original and showing wear and tear beyond what regular maintenance can repair. Second, the patio area outside of the training room needs work to repair or replace heaved sections of concrete and eliminate trip hazards. Some landscaping work is needed to keep dirt off the walkway and patio, through landscaped terrace work. Finally, the patio furnishings need replacement. CIP $- $50,000 $100,000 $150,000 $200,000 2014201520162017201820192020202120222023Page 152 of 424 Fire Station #26 Addition Project #1011 Category 1-Buildings and Grounds Priority 3-Sustaining Useful Life 20 Years Origination Major Maintenance User Department Fire Coordinator Fire Current Budget -$ Initial Proposal Date 2019 Design Work 2019 Project Work 2020 Location Reoccurance 2035 (First Renovation) Asset Valuation -$ Last Deferred 2009 Last Incurred N/A Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term -$ 2,745,712$ -$ -$ -$ 2,745,712$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ 250,000$ 250,000$ 2,745,712$ 2,995,712$ 10 Year Financial Trend Financial Impact Fire Station 26 Issue Fire Station 26 was built in 1980. The fire station has been remodeled a number of times including an administrative wing addition in 1993. The 2014 and 2017 space needs assessments, both defined the need for both renovated and additional space. Solution Wold Architects recommended a major renovation (7,000 sq ft/$301,00) and adding an additional 1,500 square feet ($1,175,000). The apparatus bays and support areas would be remodeled but would remain substantially the same. Other costs identified by Wold included Soft Costs ($265,152), Facility analysis ($733,600), Furniture & Equipment ($50,000) and contingency ($220,960) for a total of $2,745,712. CIP $- $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 2014201520162017201820192020202120222023Page 153 of 424 Public Works Facility Project #1012 Category 1-Buildings and Grounds Priority 2-Essential Useful Life 40 Years Origination New User Department PW Coordinator PW Current Budget -$ Initial Proposal Date 2019 Design Work 2019 Project Work 2020-2021 Location Reoccurance 2035 (First Renovation) Asset Valuation 30,000,000$ Last Deferred 2008-2018 Last Incurred N/A Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term 5,000,000$ 25,000,000$ 2,000,000$ -$ -$ 32,000,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ 250,000$ 250,000$ 32,000,000$ 32,250,000$ 10 Year Financial Trend Financial Impact TBD Issue The Public Service Center was constructed in 1976, with major remodeling in 1988 and 1992. Major building additions have been deferred since 2007. Solution Public Works has outgrown both its facility and the yard space available on the current parcel as discussed in detail in the 2017 Facility Space Needs Assessment. This project would move Public Works to a new site, with all associated land acquisition, land development, and building expenses. Land Acquisition, planning and engineering are programmed for 2019, with major facility consturction programmed for 2020. CIP $- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 $30,000,000 2014201520162017201820192020202120222023Page 154 of 424 Village Hall - Office Remodel Project #1013 Category 1-Buildings and Grounds Priority 4-Contributory Useful Life 15 Years Origination Major Maintenance User Department OVM Coordinator PW Current Budget -$ Initial Proposal Date 2019 Design Work 2019 Project Work 2019 Location Reoccurance 2034 Asset Valuation 3,847,200$ Last Deferred N/A Last Incurred N/A Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term 68,425$ -$ -$ -$ -$ 68,425$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 4,300,000$ -$ -$ 4,300,000$ 68,425$ 4,368,425$ 10 Year Financial Trend Financial Impact Village Hall Issue Village Hall was built in 1970 and underwent major renovations in 1988 and 1993. With the OVM office area due for remodeling, rearrangement of workspaces and security improvements through keycard access control are requested. Solution Project would include design work, construction, and key card access control for the space. Design and construction are being programmed for 2019. CIP $- $20,000 $40,000 $60,000 $80,000 2014201520162017201820192020202120222023Page 155 of 424 Fire Station 25 Replacement Project #1014 Category 1-Buildings and Grounds Priority 4-Contributory Useful Life 40 Years Origination New User Department Fire Coordinator Fire Current Budget -$ Initial Proposal Date 2019 Design Work 2019 Project Work 2020 Location Reoccurance 2060 Asset Valuation 4,457,930$ Last Deferred N/A Last Incurred N/A Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term 350,000$ 3,500,000$ -$ -$ -$ 3,850,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ -$ -$ 3,850,000$ 3,850,000$ 10 Year Financial Trend Financial Impact Fire Station 25 Issue Fire Station 25 was built in 1972 and underwent major renovations in 1992, 1997, and 2004. As Buffalo Grove and surrounding communities grew, the location of the fire station is not optimal for fire and EMS response times. The building and infrastructure is 44 years old. Solution Relocating and building a replacement Fire Station 25 would provide a building that would be more energy efficient, designed for its intended purpose as a full time fire station, would better serve the citizens by being better located for the current Buffalo Grove boundaries and would have a useful life of 50 years. Construction costs are based on a 10,000 square foot fire station at $350 per square foot. Costs do not include the property values of the current Fire Station 25 location and its relocated property. CIP $- $1,000,000 $2,000,000 $3,000,000 $4,000,000 2014201520162017201820192020202120222023Page 156 of 424 Golf Course Improvements Project #2001 Category 2-Golf Course Improvements Priority 3-Sustaining Useful Life 20 Years Origination Major Maintenance User Department Golf Coordinator Golf Current Budget 25,000$ Initial Proposal Date 2016 Design Work 2019 Project Work 2019 Location Reoccurance 2039 Asset Valuation -$ Last Deferred N/A Last Incurred N/A Fund Golf Reserves Account Number 0 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term 75,000$ 75,000$ 75,000$ 40,000$ 250,000$ 515,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ -$ -$ 515,000$ 515,000$ 10 Year Financial Trend Financial Impact Golf Courses Issue Due to the age of the courses, several land restoration projects are needed to maintain golfability. Solution In 2019 through 2021, a three year project to restore all 69 sand traps at Arboretum is being programed ($75k each year). Proposed for 2022 is the design for the removal of sediment from the pond at the 15th hole at Arboretum ($40k) with construction planned for 2023 ($250k). CIP $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 2014201520162017201820192020202120222023Page 157 of 424 Golf Course Irrigation Improvements Project #2002 Category 2-Golf Course Improvements Priority 3-Sustaining Useful Life 20 Years Origination Major Maintenance User Department Golf Coordinator Golf Current Budget 33,000$ Initial Proposal Date 2016 Design Work 2019 Project Work 2019 Location Reoccurance 2039 Asset Valuation -$ Last Deferred N/A Last Incurred N/A Fund Golf Reserves Account Number 0 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ 19,000$ 19,000$ 2019 2020 2021 2022 2023 Short Term Short Term 25,000$ 55,000$ -$ -$ -$ 80,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ -$ -$ 80,000$ 80,000$ 10 Year Financial Trend Financial Impact Golf Courses Issue Irrigation repairs and piping replacements are due at both golf courses. Solution For 2019, the irrigation pumps at Arboretum are planned for replacement. Additional work to irrigation pumps and control systems is being programmed through 2020. CIP $- $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 2014201520162017201820192020202120222023Page 158 of 424 Golf Course Parking Lot Maintenance Project #2003 Category 2-Golf Course Improvements Priority 3-Sustaining Useful Life 20 Years Origination Major Maintenance User Department Golf Coordinator Engineering Current Budget -$ Initial Proposal Date 2018 Design Work 2019 Project Work 2019 Location Reoccurance 2039 Asset Valuation -$ Last Deferred N/A Last Incurred N/A Fund Golf Reserves Account Number 0 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ 23,225$ 23,225$ 2019 2020 2021 2022 2023 Short Term Short Term -$ 14,000$ -$ 30,000$ -$ 44,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 40,000$ 25,000$ 25,000$ 90,000$ 44,000$ 134,000$ 10 Year Financial Trend Financial Impact Golf Courses Issue Golf course parking lots require routine sealing, restriping, and reconstruction in order to maintain driveability. This includes two lots at BGGC and one lot at Arboretum. In total, 231,372 sqft of parking lot requires ongoing maintenance. Solution The 2018 improvements included the Buffalo Grove Golf Course main lot maintenance ($8k) and Arboretum Golf Course parking lot maintenance ($15k). There are no improvements scheduled for 2019. CIP $- $5,000 $10,000 $15,000 $20,000 $25,000 $30,000 $35,000 2014201520162017201820192020202120222023Page 159 of 424 Annual Sidewalk/Bike Path Maintenance Project #3001 Category 3-Street, Sidewalk & Bikepath Priority 1-Mandatory Useful Life 30 Years Origination Major Maintenance User Department PW Coordinator Engineering Current Budget 200,000$ Initial Proposal Date Ongoing Design Work 2018 Project Work 2019 Location Reoccurance Yearly Asset Valuation 26,913,277$ Last Deferred 2017 ($125,000) Last Incurred 2017 ($200,000) Fund General Fund Account Number 100.55.10.535.05 (Estimated) 2014 2015 2016 2017 2018 Historical Historical 422,421$ 242,094$ 284,223$ 150,000$ 200,000$ 1,298,738$ 2019 2020 2021 2022 2023 Short Term Short Term 325,000$ 325,000$ 325,000$ 325,000$ 325,000$ 1,625,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 1,625,000$ 1,750,000$ 1,750,000$ 5,125,000$ 1,625,000$ 6,750,000$ 10 Year Financial Trend Financial Impact Village Right of Way Issue A sidewalk and bikepath repair program helps maintain the pedestrian and bicycle routes within the village Solution The Village performs an annual sidewalk and bikepath mainteance program. The 2019 project is currently focusing on sidewalk and bikepath repair located primarily in the southern section of the Village. CIP $- $100,000 $200,000 $300,000 $400,000 $500,000 2014201520162017201820192020202120222023Page 160 of 424 Annual Street Maintenance Project #3002 Category 3-Street, Sidewalk & Bikepath Priority 3-Sustaining Useful Life 20 Years Origination Major Maintenance User Department Engineering Coordinator Engineering Current Budget 1,000,000$ Initial Proposal Date Ongoing Design Work 2018 Project Work 2019 Location Reoccurance Yearly Asset Valuation 190,080,000$ Last Deferred 2017 ($3,800,000) Last Incurred 2017 (1,200,000) Fund Capital Projects - Streets Account Number 160.75.560.20 (Estimated) 2014 2015 2016 2017 2018 Historical Historical 2,014,665$ 1,688,228$ 7,011,616$ 1,201,000$ 1,000,000$ 12,915,509$ 2019 2020 2021 2022 2023 Short Term Short Term 7,140,000$ 10,633,200$ 7,251,600$ 9,123,600$ 6,856,000$ 41,004,400$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 33,085,200$ 20,000,000$ 20,000,000$ 73,085,200$ 41,004,400$ 114,089,600$ 10 Year Financial Trend Financial Impact Village Right of Way Issue The Villages streets need to be maintained on a reoccuring basis. Solution The annual street maintenance and rehabilitation program is covered in each year's CIP. The Village streets are reviewed annual and evaluated for all types of maintenance or improvement, with the annual budgetary need set at about $9,504,000 per year. CIP $- $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 2014201520162017201820192020202120222023Page 161 of 424 Collector Route Maintenance & Rehabilitation Project Project #3003 Category 3-Street, Sidewalk & Bikepath Priority 3-Sustaining Useful Life 20 Years Origination Major Maintenance User Department Engineering Coordinator Engineering Current Budget 300,000$ Initial Proposal Date 2017 Design Work 2017-2019 Project Work 2020-2021 Location Reoccurance Yearly Asset Valuation N/A Last Deferred N/A Last Incurred N/A Fund Capital Projects - Streets Account Number 160.75.560.20 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ 300,000$ 300,000$ 600,000$ 2019 2020 2021 2022 2023 Short Term Short Term 145,000$ 770,000$ 770,000$ 770,000$ 500,000$ 2,955,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 2,500,000$ 1,200,000$ 1,550,000$ 5,250,000$ 2,955,000$ 8,205,000$ 10 Year Financial Trend Financial Impact Village Right of Way Issue The Villages streets need to be maintained on a reoccuring basis. Solution These Village streets have been identified by the Illinois Department of Transportation as collector routes due to their width and amount of traffic. Federal funding is available at up to 80% reimbursement for design and construction as part of the Federal process. Currently, Brandywyn Lane and Thompson Blvd are in design for anticipated 2020 and 2021 construction and has been awarded $10 million in grant funds. Bernard Drive is proposed to begin the Phase I process in 2019. CIP $- $200,000 $400,000 $600,000 $800,000 $1,000,000 2014201520162017201820192020202120222023Page 162 of 424 Lake Cook Road Improvement Project #3004 Category 3-Street, Sidewalk & Bikepath Priority 1-Mandatory Useful Life 20 Years Origination Major Maintenance User Department Engineering Coordinator Engineering Current Budget -$ Initial Proposal Date 2008 Design Work 2008-2018 Project Work 2018-2021 Location Reoccurance N/A Asset Valuation N/A Last Deferred N/A Last Incurred 2017 Fund Capital Projects - Streets Account Number 160.75.560.20 (Estimated) 2014 2015 2016 2017 2018 Historical Historical 63,000$ 5,000$ 112,556$ 35,000$ -$ 215,556$ 2019 2020 2021 2022 2023 Short Term Short Term 210,000$ 210,000$ 210,000$ -$ -$ 630,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ -$ -$ 630,000$ 630,000$ 10 Year Financial Trend Financial Impact County Right of Way Issue The Cook County Highway Department is planning on improving Lake Cook Road from Lexington Drive to Raupp Blvd. Solution The Village is responsible for a local share of the cost for such items as pedestrian facilities, street lights, and utility relocations. The local share is $2.13 million, however the Village received a $1.5 million Surface Transportation Program Grant which reduced the total to $630,000 over three years. CIP $- $50,000 $100,000 $150,000 $200,000 $250,000 2014201520162017201820192020202120222023Page 163 of 424 Weiland/Prairie Road Improvements Project #3005 Category 3-Street, Sidewalk & Bikepath Priority 1-Mandatory Useful Life 20 Years Origination Major Maintenance User Department Engineering Coordinator Engineering Current Budget 300,000$ Initial Proposal Date 2008 Design Work 2008-2018 Project Work 2018-2020 Location Reoccurance N/A Asset Valuation N/A Last Deferred N/A Last Incurred 2013 Fund Capital Projects - Streets Account Number 160.75.560.20 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ 300,000$ 300,000$ 2019 2020 2021 2022 2023 Short Term Short Term 750,000$ 50,000$ -$ -$ -$ 800,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ -$ -$ 800,000$ 800,000$ 10 Year Financial Trend Financial Impact County Right of Way Issue The Lake County Department of Transportation is planning on improving Weiland Road and Prairie Road from Route 22 to Lake Cook Road. Solution The Village is responsible for a local share of the cost for such items as pedestrian facilities, street lights, and utility relocations. CIP $- $200,000 $400,000 $600,000 $800,000 2014201520162017201820192020202120222023Page 164 of 424 Municipal Parking Facility Maintenance Project #3006 Category 3-Street, Sidewalk & Bikepath Priority 3-Sustaining Useful Life 20 Years Origination Major Maintenance User Department Engineering Coordinator Engineering Current Budget 276,850$ Initial Proposal Date Ongoing Design Work 2018 Project Work 2019 Location Reoccurance Yearly Asset Valuation -$ Last Deferred N/A Last Incurred N/A Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical 110,000$ 116,828$ 99,787$ 125,000$ 129,187$ 580,802$ 2019 2020 2021 2022 2023 Short Term Short Term 310,000$ 174,000$ 149,000$ 100,000$ 100,000$ 833,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 625,000$ 700,000$ 750,000$ 2,075,000$ 833,000$ 2,908,000$ 10 Year Financial Trend Financial Impact Village Parking Lots Issue Routine sealing, restriping, and reconstruction of municipal lots is required. Solution The 2019 planned improvements include parking lots at the Metra Station ($30k), Police Station ($50k), the Public Service Center ($185k), Fire Station #25 (50k) and #26 ($3k), and Village Reservoirs #1, #2, and #6 ($2k). CIP $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 2014201520162017201820192020202120222023Page 165 of 424 Storm Water System Upgrades Project #4001 Category 4-Storm Water Management Priority 2-Essential Useful Life 50 Years Origination Major Maintenance User Department PW Coordinator Engineering Current Budget 300,000$ Initial Proposal Date Ongoing Design Work 2018 Project Work 2019 Location Reoccurance Yearly Asset Valuation 250,078,002$ Last Deferred N/A Last Incurred 2017 Fund General Fund Account Number 100.55.25.560.40 (Estimated) 2014 2015 2016 2017 2018 Historical Historical 505,031$ 408,162$ 307,639$ 402,239$ 349,660$ 2,506,071$ 2019 2020 2021 2022 2023 Short Term Short Term 750,000$ 420,000$ 420,000$ 400,000$ 400,000$ 2,390,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 2,125,000$ 2,250,000$ 3,500,000$ 7,875,000$ 2,390,000$ 10,265,000$ 10 Year Financial Trend Financial Impact Village Easements and ROW Issue The storm sewer system requires annual maintenance. Solution This program provides for the annual televising inspection program and the resulting storm sewer lining, point repairs, or replacements at priority locations within the Village's storm sewer network as identified through this program. Additionally, this includes the rear yard storm sewer repairs, repairs associated with road improvement projects by the Village as well as other jurisdictions and limited streambank restoration efforts. The 2019 amount also includes $170,000 for a storm water study. CIP $- $200,000 $400,000 $600,000 $800,000 2014201520162017201820192020202120222023Page 166 of 424 SCADA Improvements Project #5001 Category 5-Technology Priority 2-Essential Useful Life 8 Years Origination Major Maintenance User Department PW Coordinator PW Current Budget -$ Initial Proposal Date 2012 Design Work 2013 Project Work 2014-2020 Location Reoccurance Yearly Asset Valuation 1,500,000$ Last Deferred 2017-2018 Last Incurred 2016 Fund Water & Sewer Fund Account Number 170.55.35.560.60 (Estimated) 2014 2015 2016 2017 2018 Historical Historical 129,042$ 25,000$ 180,000$ -$ -$ 334,042$ 2019 2020 2021 2022 2023 Short Term Short Term 140,000$ 20,000$ 20,000$ 20,000$ 20,000$ 220,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 100,000$ 100,000$ 100,000$ 300,000$ 220,000$ 520,000$ 10 Year Financial Trend Financial Impact Public Works Infrasturcture Issue Improvements and component upgrades are detailed in the SCADA System Master Plan. Supervisory Control and Data Acquisition are a vital function of both the water pumping stations and sanitary lift stations. Solution This work was defered in 2017 and 2018, and is being requested again in 2019. Work is needed for hardware and software within the SCADA system in order to update security and alarming functionality, and replace key components which are no longer serviceable due to manufacturer obsolescence. CIP $- $50,000 $100,000 $150,000 $200,000 2014201520162017201820192020202120222023Page 167 of 424 Laserfiche Project #5003 Category 5-Technology Priority 2-Essential Useful Life 5 Years Origination Scheduled Upgrades User Department IT Coordinator IT Current Budget -$ Initial Proposal Date 0 Design Work 2018 Project Work 2019 Location Reoccurance 2024 Asset Valuation -$ Last Deferred N/A Last Incurred N/A Fund IT Fund Account Number 211.92.555.40 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term 28,000$ -$ -$ -$ -$ 28,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ -$ -$ 28,000$ 28,000$ 10 Year Financial Trend Financial Impact Village Network Issue In order to maintain Laserfiche functionality though upgrade cycles, and also to open up a public portal to access Freedom of Information Act (FOIA) documents, infrastructure upgrades are needed. Solution Laserfiche required updgrades include file storage (9TB for $15,000), Server 2016 licensing ($3500), SQL Server 2018 ($4500), plus training and authorized reseller support. CIP $- $5,000 $10,000 $15,000 $20,000 $25,000 $30,000 2014201520162017201820192020202120222023Page 168 of 424 Microsoft Licensing Project #5004 Category 5-Technology Priority 2-Essential Useful Life 5 Years Origination Scheduled Upgrades User Department IT Coordinator IT Current Budget -$ Initial Proposal Date 0 Design Work 2018 Project Work 2019 Location Reoccurance 2024 Asset Valuation -$ Last Deferred 2015 Last Incurred 2010 Fund IT Fund Account Number 211.92.555.40 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ 41,000$ 41,000$ 2019 2020 2021 2022 2023 Short Term Short Term 52,000$ 52,000$ 70,450$ 52,000$ 52,000$ 278,450$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 250,000$ 250,000$ 250,000$ 750,000$ 278,450$ 1,028,450$ 10 Year Financial Trend Financial Impact Village Network Issue Microsoft software requires regular updates. The office suite was last upgraded in 2010. Solution For 2019, IT will migrate to Office 365. 250 licenses will cost $52,000 per year. CIP $- $20,000 $40,000 $60,000 $80,000 2014201520162017201820192020202120222023Page 169 of 424 Multiple Area Network Project #5005 Category 5-Technology Priority 2-Essential Useful Life 7 Years Origination Major Maintenance User Department IT Coordinator IT Current Budget -$ Initial Proposal Date 2018 Design Work 2018 Project Work 2018-2019 Location Reoccurance 2026 Asset Valuation 200,000$ Last Deferred N/A Last Incurred 0 Fund IT Fund Account Number 211.92.555.40 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ 12,000$ 12,000$ 2019 2020 2021 2022 2023 Short Term Short Term 150,000$ 25,000$ -$ -$ -$ 175,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 200,000$ 250,000$ 300,000$ 750,000$ 175,000$ 925,000$ 10 Year Financial Trend Financial Impact Antenna Towers Issue The current Radwin network is experiencing issues due to bandwidth limitations. Solution All four sectors require new antennas. CIP $- $50,000 $100,000 $150,000 $200,000 2014201520162017201820192020202120222023Page 170 of 424 Police Mobile Computers Project #5006 Category 5-Technology Priority 2-Essential Useful Life 5 Years Origination Major Maintenance User Department Police Coordinator IT Current Budget -$ Initial Proposal Date 2013 Design Work 2018 Project Work 2019 Location Reoccurance 2024 Asset Valuation 120,000$ Last Deferred N/A Last Incurred 2013 Fund DUI Fund Account Number 211.92.555.40 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term 120,000$ -$ -$ -$ -$ 120,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 120,000$ 120,000$ 120,000$ 360,000$ 120,000$ 480,000$ 10 Year Financial Trend Financial Impact Police Vehicles Issue Ruggedized laptops in the Police vehicles are on a 5 year replacement schedule per the standards set by the GovIT Consortium. In 2019, new CAD software will be implemented by Northwest Central Dispatch. Solution In conjunction with the CAD implementation in 2019, all twenty-two mobile laptops in the Police vehicles are up for replacement. The current computers will be 7 years old at the time of replacement. In addition, there may be other hardware needs as the CAD system is implemented. CIP $- $20,000 $40,000 $60,000 $80,000 $100,000 $120,000 $140,000 2014201520162017201820192020202120222023Page 171 of 424 Server Replacements Project #5007 Category 5-Technology Priority 2-Essential Useful Life 5 years Origination Scheduled Upgrades User Department IT Coordinator IT Current Budget -$ Initial Proposal Date 2019 Design Work 2019 Project Work 2019 Location Reoccurance 2024 Asset Valuation 100,000$ Last Deferred 2017 Last Incurred 2016 Fund IT Fund Account Number 211.92.555.40 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term 25,000$ -$ -$ 12,000$ -$ 37,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 50,000$ 50,000$ 50,000$ 150,000$ 37,000$ 187,000$ 10 Year Financial Trend Financial Impact Village Network Issue Computer Server Rack Equipment is scheduled for replacement on a 5 year cycle. Solution For 2019, three servers are up for replacement. They will be replaced by two upgraded servers at $12,500 each. CIP $- $5,000 $10,000 $15,000 $20,000 $25,000 $30,000 2014201520162017201820192020202120222023Page 172 of 424 Telephone System Project #5009 Category 5-Technology Priority 2-Essential Useful Life 10 Years Origination Scheduled Upgrades User Department IT Coordinator IT Current Budget -$ Initial Proposal Date 0 Design Work 2020 Project Work 2021 Location Reoccurance 2031 Asset Valuation 150,000$ Last Deferred N/A Last Incurred 2010 Fund IT Fund Account Number 211.92.555.40 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term -$ -$ 150,000$ -$ -$ 150,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ 150,000$ -$ 150,000$ 150,000$ 300,000$ 10 Year Financial Trend Financial Impact Village Facilities Issue The telephone system was installed in 2011 and will need to be upgraded in 2021 Solution This project plans to begin the search for the next phone system in 2020 in order to budget for Villagewide replacement in 2021. CIP $- $50,000 $100,000 $150,000 $200,000 2014201520162017201820192020202120222023Page 173 of 424 Antenna Towers Project #5011 Category 5-Technology Priority 2-Essential Useful Life 30 Years Origination Major Maintenance User Department IT Coordinator IT Current Budget -$ Initial Proposal Date 2018 Design Work 2019 Project Work 2020 Location Reoccurance 2050 Asset Valuation -$ Last Deferred N/A Last Incurred N/A Fund IT Fund Account Number 211.92.555.40 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ 10,000$ 10,000$ 2019 2020 2021 2022 2023 Short Term Short Term 25,000$ 25,000$ -$ -$ -$ 50,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 100,000$ 100,000$ 100,000$ 300,000$ 50,000$ 350,000$ 10 Year Financial Trend Financial Impact Various Village Sites Issue There are nine (9) antenna towers installed at Village facilities. These towers need regular inspection and maintenance. Solution For 2019, IT will coordinate a review and engineering inspection of all tower sites so that any major upcoming maintenance work or replacements can be scheduled for 2020 and beyond. CIP $- $5,000 $10,000 $15,000 $20,000 $25,000 $30,000 2014201520162017201820192020202120222023Page 174 of 424 Fire - Cardiac Monitors Project #5012 Category 5-Technology Priority 2-Essential Useful Life 10 Years Origination Scheduled Upgrades User Department Fire Coordinator Fire Current Budget -$ Initial Proposal Date 2019 Design Work 2019 Project Work 2019-2021 Location Reoccurance 2029 Asset Valuation 93,000$ Last Deferred N/A Last Incurred N/A Fund General Fund Account Number 0 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term 31,000$ 31,000$ 31,000$ -$ -$ 93,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ 93,000$ -$ 93,000$ 93,000$ 186,000$ 10 Year Financial Trend Financial Impact BGFD Fire Apparatus Issue The cardiac monitors in use on the fire apparatus are at the end of their useful life. The fire apparatus cardiac monitors are not capable of providing real time recording of a cardiac event. Solution Purchase one replacement cardiac monitor each year for the next three years to upgrade the Advanced Life Support capabilities of the fire apparatus. CIP $- $5,000 $10,000 $15,000 $20,000 $25,000 $30,000 $35,000 2014201520162017201820192020202120222023Page 175 of 424 Fire - EOC Radio Replacement Project #5013 Category 5-Technology Priority 3-Sustaining Useful Life 10 Years Origination Scheduled Upgrades User Department Fire Coordinator Fire Current Budget -$ Initial Proposal Date 2019 Design Work 2019 Project Work 2019 Location Reoccurance 2029 Asset Valuation 45,000$ Last Deferred N/A Last Incurred N/A Fund General Fund Account Number 0 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term 45,000$ -$ -$ -$ -$ 45,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ 45,000$ -$ 45,000$ 45,000$ 90,000$ 10 Year Financial Trend Financial Impact Emergency Management Agency Issue The radios in MobileComm and the EOC are at the end of their useful life. For the Village to effectively respond to and mitigate a variety of natural and man made events, the ability to provide communications is critical to life safety and property conservation. Solution MobileComm (8 radios), Emergency Operations Center (8 radios), and two spare radios (1-UHF, 1-VHF) radios are being requested for replacement in 2019. CIP $- $10,000 $20,000 $30,000 $40,000 $50,000 2014201520162017201820192020202120222023Page 176 of 424 SECTION SIX: CAPITAL IMPROVEMENT CAPITAL IMPROVEMENT PLAN – CAPITAL IMPROVEMENT STREETS – CAPITAL IMPROVEMENT FACILITIES – MOTOR FUEL TAX Water & Sanitary Sewer 18% Building and Grounds 32% Golf Course Improvements 1% Street, Sidewalk, & Bikepath 42% Strom Water Management 4% Technology 3% 2019 Capital Project Requests by Category CAPITAL IMPROVEMENT REQUEST SUMMARY The Capital Improvement Plan (CIP) is intended to be a decision-making tool for the Village Board and staff. Capital improvement projects represent the equipment and infrastructure that must be provided to residents and businesses. The need for capital expenditures are weighed against the ability of the Village to finance these projects. The Village Board’s ultimate approval of the CIP does not authorize spending on the included projects. Staff continues to review and evaluate each project throughout the 2019 budget cycle. Projects identified for FY 2019 total $20,908,728 and fall under six categories. The following chart illustrates each category’s percentage as it relates to the capital requests received for FY 2019. The CIP was changed from a five year projection to a twenty year projection in 2019. The increase in the rage of the plan allows for a more accurate projection of the village’s capital needs. The Village maintains multiple capital assets and infrastructure systems that are costly to operate and replace. For reference, the FY2019 budget requests and funding schedule and the 5-year forecast of funding requests for capital project improvements are included. Page 137 of 424 2019 Capital Projects Budgeted by Fund General Fund Requested Budgeted Annual Sidewalk/Bike Path Maintenance $325,000 $175,000 Cardiac Monitors - Fire Department (Reserve) $31,000 $0 EOC Radio Replacement - Fire Department (Reserve) $45,000 $0 Storm Water System Upgrades and Repairs $750,000 $300,000 Villagewide Comprehensive Plan $150,000 $150,000 Subtotal $1,301,000 $625,000 Motor Fuel Tax Fund Annual Street Maintenance $7,140,000 $1,500,000 Subtotal $7,140,000 $1,500,000 Capital Project- Streets Fund Collector Route Maintenance and Rehabilitation Program $145,000 $145,000 Lake Cook Road Improvement $210,000 $210,000 Municipal Parking Facility $310,000 $0 Weiland Road/Prairie Road Improvements $750,000 $750,000 Subtotal $1,415,000 $1,105,000 Capital Projects - Facilities Fund Building Replacement - CAFT $305,195 $305,195 Fire Station Sign Replacement $28,000 $0 Fire Station 25 Replacement $350,000 $0 Fire Station 26 Addition $0 $0 Fire Station 27 Remodel $0 $0 Flooring Capital Replacement Projects $98,154 $0 Police Headquarters $150,000 $0 Public Works Facility $5,000,000 $0 Roof Capital Replacement Projects $518,954 $0 Village Campus Long Range Planning $80,000 $80,000 Village Gateway Feature $25,000 $0 Village Hall Office Remodel $68,425 $0 Subtotal $6,908,728 $385,195 Page 138 of 424 2019 Capital Projects Budgeted by Fund Continued Information Technology Fund Laserfiche $28,000 $28,000 Microsoft Licensing $52,000 $52,000 Multiple Area Network (Reserve) $150,000 $0 Police Mobile Computers ( DUI Fund) $120,000 $0 Server Replacement $25,000 $25,000 Telephone System $0 $0 Antenna Towers $25,000 $25,000 Subtotal $400,000 $130,000 Water & Sewer Fund Capacity Management Operations & Maintenance $64,000 $64,000 Lift Station Repair & Rehabilitation $850,000 $850,000 Pump House Repairs & Security Improvements $150,000 $150,000 Villagewide Sanitary Sewer Replacement $1,185,000 $525,000 Villagewide Water Main Replacement $1,540,000 $700,000 SCADA Improvements $140,000 $140,000 Subtotal $3,929,000 $2,429,000 Golf Fund Golf Course Improvements $75,000 $0 Golf Course Irrigation Improvements $25,000 $0 Golf Course Parking Lot Maintenance $0 $0 Subtotal $100,000 $0 Total $21,193,728 $6,174,195 General Fund 10% Motor Fuel Tax Fund 24% Capital Project- Streets Fund 18% Capital Projects - Facilities Fund 6% Infromation Technology Fund 2% Water & Sewer Fund 40% Golf Fund 0% 2019 Capital Projects Budgeted by Fund Page 139 of 424 2019 Capital Projects Forecasted Requests by Fund Capital Projects Facilities 2019 2020 2021 2022 2023 Total Building Replacement - CAFT 305,195 - - - - 305,195 Flooring Capital Replacement Projects 98,154 20,000 20,000 20,000 20,000 178,154 Fire Station 27 Remodel - - 868,655 - - 868,655 HVAC Unit Replacements -120,000 120,000 120,000 120,000 480,000 Police Headquarters 150,000 100,000 100,000 100,000 100,000 550,000 Roof Capital Replacement Projects 518,954 25,000 85,000 420,000 -1,048,954 Fire Station Sign Replacement 28,000 28,000 28,000 - - 84,000 Village Campus Long Range Planning 80,000 - - - - 80,000 Village Gateway Feature 25,000 50,000 25,000 - - 100,000 Fire Station 26 Addition -2,745,712 - - - 2,745,712 Public Works Facility 5,000,000 25,000,000 2,000,000 -- 32,000,000 Village Hall Office Remodel 68,425 - - - - 68,425 Fire Station 25 Replacement 350,000 3,500,000 - - - 3,850,000 Subtotal $6,623,728 $31,588,712 $3,246,655 $,000 $240,000 $42,359,095 Golf Course Improvements Golf Course Improvements 75,000 75,000 75,000 40,000 250,000 515,000 Golf Course Irrigation Improvements 25,000 55,000 - - - 80,000 Golf Course Parking Lot Maintenance -14,000 - - - 14,000 Subtotal $100,000 $144,000 $75,000 $40,000 $250,000 $609,000 Capital Projects Streets Annual Street Maintenance 7,140,000 10,633,200 7,251,600 9,123,600 6,856,000 41,004,400 Collector Route Maintenance and Rehabilitation Program 145,000 770,000 770,000 770,000 500,000 2,955,000 Lake Cook Road Improvement 210,000 210,000 210,000 - - 630,000 Weiland Road/Prairie Road Improvements 750,000 50,000 - - - 800,000 Municipal Parking Facility 310,000 174,000 149,000 100,000 100,000 833,000 Subtotal $8,555,000 $11,837,200 $8,380,600 $9,993,600 $7,456,000 $46,222,400 General Fund Villagewide Comprehensive Planning and Design 150,000 100,000 - - - 250,000 Annual Sidewalk/Bike Path Maintenance 325,000 325,000 325,000 325,000 325,000 1,625,000 Storm Water System Upgrades 750,000 420,000 420,000 400,000 400,000 2,390,000 Cardiac Monitors - Fire 31,000 31,000 31,000 - - 93,000 EOC Radio Replacement - Fire 45,000 - - - - 45,000 Subtotal $1,301,000 $876,000 $776,000 $725,000 $725,000 $4,403,000 Page 140 of 424 2019-2038 CAPITAL IMPROVEMENT PLAN 2 019 BUDGET CYCLE PRELIMINARY REQUESTS Page 142 of 424 Villagewide Comprehensive Planning and Design Project #1001 Category 1-Buildings and Grounds Priority 4-Contributory Useful Life 10 Years Origination Planning Tool User Department Community Development Coordinator Community Development Current Budget 100,000$ Initial Proposal Date 2018 Design Work 2019 Project Work N/A Location Reoccurance 2030 Asset Valuation N/A Last Deferred N/A Last Incurred 2018 Fund General Fund Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ 50,000$ 50,000$ 2019 2020 2021 2022 2023 Short Term Short Term 150,000$ 100,000$ -$ -$ -$ 250,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ 250,000$ 250,000$ 250,000$ 500,000$ 10 Year Financial Trend Financial Impact Planning Document Issue The Village’s Comprehensive Plan was last updated in 2009. Furthermore, the request would address the creation of design and streetscape guidelines for the recently adopted Lake Cook Corridor Plan. Solution The Village Board and staff have set a goal to update the Village Wide Comprehensive Plan. Completing this task would fulfill goals and recommendation outlined in both the Economic Development Plan and the Village’s Strategic Plan. This would be a 2-year project with the first phase estimated at $100,000 for 2019. The creation of design and streetscape guidelines for the Lake Cook Corridor would address the goals outlined in the Lake Cook Corridor Plan and also provide clear design criteria to future developments in the corridor. Staff is estimating that the cost to complete this task would be $50,000. CIP $- $50,000 $100,000 $150,000 $200,000 2014201520162017201820192020202120222023Page 143 of 424 Building Replacement - CAFT Project #1002 Category 1-Buildings and Grounds Priority 2-Essential Useful Life 30 Years Origination New User Department Fire Coordinator Fire Current Budget 1,065,195$ Initial Proposal Date 2016 Design Work 2017 Project Work 2019 Location Reoccurance 2034 (First Renovation) Asset Valuation 1,200,000$ Last Deferred N/A Last Incurred 2000 Fund Capital Projects - Facilities Account Number 160.75.560.20 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ 45,000$ -$ 45,000$ 2019 2020 2021 2022 2023 Short Term Short Term 305,195$ -$ -$ -$ -$ 305,195$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ 50,000$ -$ 50,000$ 305,195$ 355,195$ 10 Year Financial Trend Financial Impact Krause Drive Combined Area Fire Training Site Issue In 2000, the CAFT training center was constructed of donated office trailers with the intent of replacing the structure with a permanent building in 10 years. The temporary building was demolished in 2016 due to health hazards associated with animal infestation and mold. Solution Building estimates have been gathered from architects and pre-fabricated building manufacturers which resulted in a construction estimate of $1,065,195. This cost would be divided by the five (5) CAFT fire departments with each being responsible for their cost of $195,000. The BGFD would be responsible for an additional $110,195 which would add an apparatus bay and offices that would allow the building to be used as a temporary fire station when needed. CIP $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 2014201520162017201820192020202120222023Page 144 of 424 Flooring Capital Replacement Projects Project #1003 Category 1-Buildings and Grounds Priority 4-Contributory Useful Life 10 Years Origination Major Maintenance User Department PW Coordinator PW Current Budget 82,768$ Initial Proposal Date 2015 Design Work 2018 Project Work 2019 Location Reoccurance Yearly Asset Valuation 1,200,000$ Last Deferred N/A Last Incurred 2018 Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ 32,452$ 44,932$ 159,033$ 82,768$ 319,185$ 2019 2020 2021 2022 2023 Short Term Short Term 98,154$ 20,000$ 20,000$ 20,000$ 20,000$ 178,154$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 250,000$ 250,000$ 250,000$ 750,000$ 178,154$ 928,154$ 10 Year Financial Trend Financial Impact Village Buildings Issue On average, carpet is 4-6 years past the date it was scheduled to be replaced. Solution 2019 flooring replacement projects include carpet and tile at Village Hall. For 2020-2023, flooring replacements would continue at each of the fire stations. CIP $- $50,000 $100,000 $150,000 $200,000 2014201520162017201820192020202120222023Page 145 of 424 Fire Station #27 Remodel Project #1004 Category 1-Buildings and Grounds Priority 3-Sustaining Useful Life 20 Years Origination New User Department Fire Coordinator Fire Current Budget -$ Initial Proposal Date 2016 Design Work 2021 Project Work 2021 Location Reoccurance 2041 Asset Valuation 5,469,400$ Last Deferred N/A Last Incurred N/A Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term -$ -$ 868,655$ -$ -$ 868,655$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ -$ -$ 868,655$ 868,655$ 10 Year Financial Trend Financial Impact Fire Station #27 Issue Fire Station 27 was built in 1993 as a full time fire station and is the newest of the three fire stations. The 2014 and 2017 space needs assessments, both defined the need for renovated space and a fire sprinkler installation on the first floor. Solution Wold Architects recommended a moderate renovation of the residential space (700 sq ft/$87,500) and completing the first floor fire sprinkler system ($100,000). Other costs identified by Wold included Soft Costs ($74,130), Facility analysis ($30,250), Furniture/Fixtures/Equipment ($15,000) and contingency ($61,775) for a total of $868,655. CIP $- $200,000 $400,000 $600,000 $800,000 $1,000,000 2014201520162017201820192020202120222023Page 146 of 424 HVAC Unit Replacements Project #1005 Category 1-Buildings and Grounds Priority 2-Essential Useful Life 18 Years Origination Major Maintenance User Department PW Coordinator PW Current Budget -$ Initial Proposal Date 2015 Design Work 2018 Project Work 2019 Location Reoccurance 2036 Asset Valuation -$ Last Deferred 2018 Last Incurred 2018 (Unbudgeted) Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ 92,237$ 550,000$ 250,000$ 892,237$ 2019 2020 2021 2022 2023 Short Term Short Term -$ 120,000$ 120,000$ 120,000$ 120,000$ 480,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 250,000$ 250,000$ 250,000$ 750,000$ 480,000$ 1,230,000$ 10 Year Financial Trend Financial Impact Village Facilities Issue The Village maintains 61 HVAC units in total and more than half are currently exceeding their 18 year life expectancy. Solution In 2018, replacements of HVAC units are planned at Police (1 units and controls), Village Hall (6 units), and BG Golf Course (1 unit). Several failures during the year have lead to emergency expenses, although no money was budgeted in 2018. Due to these end of year replacements, no request is being made in 2019. CIP $- $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 2014201520162017201820192020202120222023Page 147 of 424 Roof Capital Replacement Projects Project #1006 Category 1-Buildings and Grounds Priority 3-Sustaining Useful Life 30 Years Origination Major Maintenance User Department PW Coordinator PW Current Budget -$ Initial Proposal Date 2014 Design Work 2018 Project Work 2019 Location Reoccurance 2048 Asset Valuation 2,000,000$ Last Deferred 2018 Last Incurred 2017 Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ 197,766$ 72,000$ 276,850$ -$ 546,616$ 2019 2020 2021 2022 2023 Short Term Short Term 518,954$ 25,000$ 85,000$ 420,000$ -$ 1,048,954$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 191,800$ 250,000$ 300,000$ 741,800$ 1,048,954$ 1,790,754$ 10 Year Financial Trend Financial Impact Village Facilities Issue Roof replacement projects were identified during the 2018 roof inspection reports prepared by Industrial Roofing Services. Solution For 2019, work is planned to include Police, Public Service Center, and Well #1. CIP $- $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 2014201520162017201820192020202120222023Page 148 of 424 Fire Station Sign Replacement Project #1007 Category 1-Buildings and Grounds Priority 4-Contributory Useful Life 20 Years Origination Major Maintenance User Department Fire Coordinator Fire Current Budget -$ Initial Proposal Date 2016 Design Work 2019 Project Work 2019 Location Reoccurance 2041 Asset Valuation 84,000$ Last Deferred 2017 Last Incurred N/A Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term 28,000$ 28,000$ 28,000$ -$ -$ 84,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ -$ -$ 84,000$ 84,000$ 10 Year Financial Trend Financial Impact Fire Stations 25, 26, & 27 Issue The current signs are deteriorated and poorly oriented for visibility. Solution Plan for replacement of one sign at each fire station, over each of three years. CIP $- $5,000 $10,000 $15,000 $20,000 $25,000 $30,000 2014201520162017201820192020202120222023Page 149 of 424 Village Campus Long Range Planning Project #1008 Category 1-Buildings and Grounds Priority 4-Contributory Useful Life 10 years Origination New User Department Community Development Coordinator Community Development Current Budget 80,000$ Initial Proposal Date 2017 Design Work 2018 Project Work N/A Location Reoccurance As Needed Asset Valuation N/A Last Deferred N/A Last Incurred 2017 Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ 20,000$ -$ 20,000$ 2019 2020 2021 2022 2023 Short Term Short Term 80,000$ -$ -$ -$ -$ 80,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ -$ -$ 80,000$ 80,000$ 10 Year Financial Trend Financial Impact Village Campus Planning Issue Several buildings on the Village Campus are nearing the end of their useful life and do not fit the space or configuration required for current Village operations. Solution In 2017, the Village used Wold Architects to begin a space needs assessment of the currentl buildings. 2019 work will continue to evaluate solutions for either major renovations and remodeling, or a move to new buildings. CIP $- $20,000 $40,000 $60,000 $80,000 $100,000 2014201520162017201820192020202120222023Page 150 of 424 Village Gateway Feature (Milwaukee Ave/Deerfield Ave) Project #1009 Category 1-Buildings and Grounds Priority 4-Contributory Useful Life 20 Years Origination New User Department Community Development Coordinator Community Development Current Budget 25,000$ Initial Proposal Date 2017 Design Work 2019 Project Work 2020 Location Reoccurance 2030 (First Maintenance) Asset Valuation 100,000$ Last Deferred 2018 Last Incurred N/A Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term 25,000$ 50,000$ 25,000$ -$ -$ 100,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ 10,000$ -$ 10,000$ 100,000$ 110,000$ 10 Year Financial Trend Financial Impact Corner of Milwaukee Ave and Deerfield Ave Issue As part of the Woodman's project, staff has proposed the replacement of the Village entrance sign with a new "gateway" feature. Solution A new gateway feature, possibly including a new sign, landscaping, and pedestrian amenities would be designed in 2019 for construction in 2020-2021. CIP $- $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 2014201520162017201820192020202120222023Page 151 of 424 Police Headquarters Project #1010 Category 1-Buildings and Grounds Priority 4-Contributory Useful Life 15 Years Origination Major Maintenance User Department Police Coordinator PW Current Budget -$ Initial Proposal Date 2019 Design Work 2019 Project Work 2019 Location Reoccurance 2034 Asset Valuation 11,920,340$ Last Deferred N/A Last Incurred N/A Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term 150,000$ 100,000$ 100,000$ 100,000$ 100,000$ 550,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 9,540,000$ 850,000$ -$ 10,390,000$ 550,000$ 10,940,000$ 10 Year Financial Trend Financial Impact Police Headquarters Issue Police Headquarters was originally built in 1988, with the last major addition in 1997. Major maintenance and remodeling are required. Solution For 2019, Police is requesting two areas of major work. First, the locker room shower areas, in both the men's and women's locker rooms needs a full remodel with work to reconfigure the space to add privacy. All tile work and plumbing is original and showing wear and tear beyond what regular maintenance can repair. Second, the patio area outside of the training room needs work to repair or replace heaved sections of concrete and eliminate trip hazards. Some landscaping work is needed to keep dirt off the walkway and patio, through landscaped terrace work. Finally, the patio furnishings need replacement. CIP $- $50,000 $100,000 $150,000 $200,000 2014201520162017201820192020202120222023Page 152 of 424 Fire Station #26 Addition Project #1011 Category 1-Buildings and Grounds Priority 3-Sustaining Useful Life 20 Years Origination Major Maintenance User Department Fire Coordinator Fire Current Budget -$ Initial Proposal Date 2019 Design Work 2019 Project Work 2020 Location Reoccurance 2035 (First Renovation) Asset Valuation -$ Last Deferred 2009 Last Incurred N/A Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term -$ 2,745,712$ -$ -$ -$ 2,745,712$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ 250,000$ 250,000$ 2,745,712$ 2,995,712$ 10 Year Financial Trend Financial Impact Fire Station 26 Issue Fire Station 26 was built in 1980. The fire station has been remodeled a number of times including an administrative wing addition in 1993. The 2014 and 2017 space needs assessments, both defined the need for both renovated and additional space. Solution Wold Architects recommended a major renovation (7,000 sq ft/$301,00) and adding an additional 1,500 square feet ($1,175,000). The apparatus bays and support areas would be remodeled but would remain substantially the same. Other costs identified by Wold included Soft Costs ($265,152), Facility analysis ($733,600), Furniture & Equipment ($50,000) and contingency ($220,960) for a total of $2,745,712. CIP $- $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 2014201520162017201820192020202120222023Page 153 of 424 Public Works Facility Project #1012 Category 1-Buildings and Grounds Priority 2-Essential Useful Life 40 Years Origination New User Department PW Coordinator PW Current Budget -$ Initial Proposal Date 2019 Design Work 2019 Project Work 2020-2021 Location Reoccurance 2035 (First Renovation) Asset Valuation 30,000,000$ Last Deferred 2008-2018 Last Incurred N/A Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term 5,000,000$ 25,000,000$ 2,000,000$ -$ -$ 32,000,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ 250,000$ 250,000$ 32,000,000$ 32,250,000$ 10 Year Financial Trend Financial Impact TBD Issue The Public Service Center was constructed in 1976, with major remodeling in 1988 and 1992. Major building additions have been deferred since 2007. Solution Public Works has outgrown both its facility and the yard space available on the current parcel as discussed in detail in the 2017 Facility Space Needs Assessment. This project would move Public Works to a new site, with all associated land acquisition, land development, and building expenses. Land Acquisition, planning and engineering are programmed for 2019, with major facility consturction programmed for 2020. CIP $- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 $30,000,000 2014201520162017201820192020202120222023Page 154 of 424 Village Hall - Office Remodel Project #1013 Category 1-Buildings and Grounds Priority 4-Contributory Useful Life 15 Years Origination Major Maintenance User Department OVM Coordinator PW Current Budget -$ Initial Proposal Date 2019 Design Work 2019 Project Work 2019 Location Reoccurance 2034 Asset Valuation 3,847,200$ Last Deferred N/A Last Incurred N/A Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term 68,425$ -$ -$ -$ -$ 68,425$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 4,300,000$ -$ -$ 4,300,000$ 68,425$ 4,368,425$ 10 Year Financial Trend Financial Impact Village Hall Issue Village Hall was built in 1970 and underwent major renovations in 1988 and 1993. With the OVM office area due for remodeling, rearrangement of workspaces and security improvements through keycard access control are requested. Solution Project would include design work, construction, and key card access control for the space. Design and construction are being programmed for 2019. CIP $- $20,000 $40,000 $60,000 $80,000 2014201520162017201820192020202120222023Page 155 of 424 Fire Station 25 Replacement Project #1014 Category 1-Buildings and Grounds Priority 4-Contributory Useful Life 40 Years Origination New User Department Fire Coordinator Fire Current Budget -$ Initial Proposal Date 2019 Design Work 2019 Project Work 2020 Location Reoccurance 2060 Asset Valuation 4,457,930$ Last Deferred N/A Last Incurred N/A Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term 350,000$ 3,500,000$ -$ -$ -$ 3,850,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ -$ -$ 3,850,000$ 3,850,000$ 10 Year Financial Trend Financial Impact Fire Station 25 Issue Fire Station 25 was built in 1972 and underwent major renovations in 1992, 1997, and 2004. As Buffalo Grove and surrounding communities grew, the location of the fire station is not optimal for fire and EMS response times. The building and infrastructure is 44 years old. Solution Relocating and building a replacement Fire Station 25 would provide a building that would be more energy efficient, designed for its intended purpose as a full time fire station, would better serve the citizens by being better located for the current Buffalo Grove boundaries and would have a useful life of 50 years. Construction costs are based on a 10,000 square foot fire station at $350 per square foot. Costs do not include the property values of the current Fire Station 25 location and its relocated property. CIP $- $1,000,000 $2,000,000 $3,000,000 $4,000,000 2014201520162017201820192020202120222023Page 156 of 424 Golf Course Improvements Project #2001 Category 2-Golf Course Improvements Priority 3-Sustaining Useful Life 20 Years Origination Major Maintenance User Department Golf Coordinator Golf Current Budget 25,000$ Initial Proposal Date 2016 Design Work 2019 Project Work 2019 Location Reoccurance 2039 Asset Valuation -$ Last Deferred N/A Last Incurred N/A Fund Golf Reserves Account Number 0 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term 75,000$ 75,000$ 75,000$ 40,000$ 250,000$ 515,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ -$ -$ 515,000$ 515,000$ 10 Year Financial Trend Financial Impact Golf Courses Issue Due to the age of the courses, several land restoration projects are needed to maintain golfability. Solution In 2019 through 2021, a three year project to restore all 69 sand traps at Arboretum is being programed ($75k each year). Proposed for 2022 is the design for the removal of sediment from the pond at the 15th hole at Arboretum ($40k) with construction planned for 2023 ($250k). CIP $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 2014201520162017201820192020202120222023Page 157 of 424 Golf Course Irrigation Improvements Project #2002 Category 2-Golf Course Improvements Priority 3-Sustaining Useful Life 20 Years Origination Major Maintenance User Department Golf Coordinator Golf Current Budget 33,000$ Initial Proposal Date 2016 Design Work 2019 Project Work 2019 Location Reoccurance 2039 Asset Valuation -$ Last Deferred N/A Last Incurred N/A Fund Golf Reserves Account Number 0 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ 19,000$ 19,000$ 2019 2020 2021 2022 2023 Short Term Short Term 25,000$ 55,000$ -$ -$ -$ 80,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ -$ -$ 80,000$ 80,000$ 10 Year Financial Trend Financial Impact Golf Courses Issue Irrigation repairs and piping replacements are due at both golf courses. Solution For 2019, the irrigation pumps at Arboretum are planned for replacement. Additional work to irrigation pumps and control systems is being programmed through 2020. CIP $- $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 2014201520162017201820192020202120222023Page 158 of 424 Golf Course Parking Lot Maintenance Project #2003 Category 2-Golf Course Improvements Priority 3-Sustaining Useful Life 20 Years Origination Major Maintenance User Department Golf Coordinator Engineering Current Budget -$ Initial Proposal Date 2018 Design Work 2019 Project Work 2019 Location Reoccurance 2039 Asset Valuation -$ Last Deferred N/A Last Incurred N/A Fund Golf Reserves Account Number 0 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ 23,225$ 23,225$ 2019 2020 2021 2022 2023 Short Term Short Term -$ 14,000$ -$ 30,000$ -$ 44,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 40,000$ 25,000$ 25,000$ 90,000$ 44,000$ 134,000$ 10 Year Financial Trend Financial Impact Golf Courses Issue Golf course parking lots require routine sealing, restriping, and reconstruction in order to maintain driveability. This includes two lots at BGGC and one lot at Arboretum. In total, 231,372 sqft of parking lot requires ongoing maintenance. Solution The 2018 improvements included the Buffalo Grove Golf Course main lot maintenance ($8k) and Arboretum Golf Course parking lot maintenance ($15k). There are no improvements scheduled for 2019. CIP $- $5,000 $10,000 $15,000 $20,000 $25,000 $30,000 $35,000 2014201520162017201820192020202120222023Page 159 of 424 Annual Sidewalk/Bike Path Maintenance Project #3001 Category 3-Street, Sidewalk & Bikepath Priority 1-Mandatory Useful Life 30 Years Origination Major Maintenance User Department PW Coordinator Engineering Current Budget 200,000$ Initial Proposal Date Ongoing Design Work 2018 Project Work 2019 Location Reoccurance Yearly Asset Valuation 26,913,277$ Last Deferred 2017 ($125,000) Last Incurred 2017 ($200,000) Fund General Fund Account Number 100.55.10.535.05 (Estimated) 2014 2015 2016 2017 2018 Historical Historical 422,421$ 242,094$ 284,223$ 150,000$ 200,000$ 1,298,738$ 2019 2020 2021 2022 2023 Short Term Short Term 325,000$ 325,000$ 325,000$ 325,000$ 325,000$ 1,625,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 1,625,000$ 1,750,000$ 1,750,000$ 5,125,000$ 1,625,000$ 6,750,000$ 10 Year Financial Trend Financial Impact Village Right of Way Issue A sidewalk and bikepath repair program helps maintain the pedestrian and bicycle routes within the village Solution The Village performs an annual sidewalk and bikepath mainteance program. The 2019 project is currently focusing on sidewalk and bikepath repair located primarily in the southern section of the Village. CIP $- $100,000 $200,000 $300,000 $400,000 $500,000 2014201520162017201820192020202120222023Page 160 of 424 Annual Street Maintenance Project #3002 Category 3-Street, Sidewalk & Bikepath Priority 3-Sustaining Useful Life 20 Years Origination Major Maintenance User Department Engineering Coordinator Engineering Current Budget 1,000,000$ Initial Proposal Date Ongoing Design Work 2018 Project Work 2019 Location Reoccurance Yearly Asset Valuation 190,080,000$ Last Deferred 2017 ($3,800,000) Last Incurred 2017 (1,200,000) Fund Capital Projects - Streets Account Number 160.75.560.20 (Estimated) 2014 2015 2016 2017 2018 Historical Historical 2,014,665$ 1,688,228$ 7,011,616$ 1,201,000$ 1,000,000$ 12,915,509$ 2019 2020 2021 2022 2023 Short Term Short Term 7,140,000$ 10,633,200$ 7,251,600$ 9,123,600$ 6,856,000$ 41,004,400$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 33,085,200$ 20,000,000$ 20,000,000$ 73,085,200$ 41,004,400$ 114,089,600$ 10 Year Financial Trend Financial Impact Village Right of Way Issue The Villages streets need to be maintained on a reoccuring basis. Solution The annual street maintenance and rehabilitation program is covered in each year's CIP. The Village streets are reviewed annual and evaluated for all types of maintenance or improvement, with the annual budgetary need set at about $9,504,000 per year. CIP $- $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 2014201520162017201820192020202120222023Page 161 of 424 Collector Route Maintenance & Rehabilitation Project Project #3003 Category 3-Street, Sidewalk & Bikepath Priority 3-Sustaining Useful Life 20 Years Origination Major Maintenance User Department Engineering Coordinator Engineering Current Budget 300,000$ Initial Proposal Date 2017 Design Work 2017-2019 Project Work 2020-2021 Location Reoccurance Yearly Asset Valuation N/A Last Deferred N/A Last Incurred N/A Fund Capital Projects - Streets Account Number 160.75.560.20 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ 300,000$ 300,000$ 600,000$ 2019 2020 2021 2022 2023 Short Term Short Term 145,000$ 770,000$ 770,000$ 770,000$ 500,000$ 2,955,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 2,500,000$ 1,200,000$ 1,550,000$ 5,250,000$ 2,955,000$ 8,205,000$ 10 Year Financial Trend Financial Impact Village Right of Way Issue The Villages streets need to be maintained on a reoccuring basis. Solution These Village streets have been identified by the Illinois Department of Transportation as collector routes due to their width and amount of traffic. Federal funding is available at up to 80% reimbursement for design and construction as part of the Federal process. Currently, Brandywyn Lane and Thompson Blvd are in design for anticipated 2020 and 2021 construction and has been awarded $10 million in grant funds. Bernard Drive is proposed to begin the Phase I process in 2019. CIP $- $200,000 $400,000 $600,000 $800,000 $1,000,000 2014201520162017201820192020202120222023Page 162 of 424 Lake Cook Road Improvement Project #3004 Category 3-Street, Sidewalk & Bikepath Priority 1-Mandatory Useful Life 20 Years Origination Major Maintenance User Department Engineering Coordinator Engineering Current Budget -$ Initial Proposal Date 2008 Design Work 2008-2018 Project Work 2018-2021 Location Reoccurance N/A Asset Valuation N/A Last Deferred N/A Last Incurred 2017 Fund Capital Projects - Streets Account Number 160.75.560.20 (Estimated) 2014 2015 2016 2017 2018 Historical Historical 63,000$ 5,000$ 112,556$ 35,000$ -$ 215,556$ 2019 2020 2021 2022 2023 Short Term Short Term 210,000$ 210,000$ 210,000$ -$ -$ 630,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ -$ -$ 630,000$ 630,000$ 10 Year Financial Trend Financial Impact County Right of Way Issue The Cook County Highway Department is planning on improving Lake Cook Road from Lexington Drive to Raupp Blvd. Solution The Village is responsible for a local share of the cost for such items as pedestrian facilities, street lights, and utility relocations. The local share is $2.13 million, however the Village received a $1.5 million Surface Transportation Program Grant which reduced the total to $630,000 over three years. CIP $- $50,000 $100,000 $150,000 $200,000 $250,000 2014201520162017201820192020202120222023Page 163 of 424 Weiland/Prairie Road Improvements Project #3005 Category 3-Street, Sidewalk & Bikepath Priority 1-Mandatory Useful Life 20 Years Origination Major Maintenance User Department Engineering Coordinator Engineering Current Budget 300,000$ Initial Proposal Date 2008 Design Work 2008-2018 Project Work 2018-2020 Location Reoccurance N/A Asset Valuation N/A Last Deferred N/A Last Incurred 2013 Fund Capital Projects - Streets Account Number 160.75.560.20 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ 300,000$ 300,000$ 2019 2020 2021 2022 2023 Short Term Short Term 750,000$ 50,000$ -$ -$ -$ 800,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ -$ -$ 800,000$ 800,000$ 10 Year Financial Trend Financial Impact County Right of Way Issue The Lake County Department of Transportation is planning on improving Weiland Road and Prairie Road from Route 22 to Lake Cook Road. Solution The Village is responsible for a local share of the cost for such items as pedestrian facilities, street lights, and utility relocations. CIP $- $200,000 $400,000 $600,000 $800,000 2014201520162017201820192020202120222023Page 164 of 424 Municipal Parking Facility Maintenance Project #3006 Category 3-Street, Sidewalk & Bikepath Priority 3-Sustaining Useful Life 20 Years Origination Major Maintenance User Department Engineering Coordinator Engineering Current Budget 276,850$ Initial Proposal Date Ongoing Design Work 2018 Project Work 2019 Location Reoccurance Yearly Asset Valuation -$ Last Deferred N/A Last Incurred N/A Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical 110,000$ 116,828$ 99,787$ 125,000$ 129,187$ 580,802$ 2019 2020 2021 2022 2023 Short Term Short Term 310,000$ 174,000$ 149,000$ 100,000$ 100,000$ 833,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 625,000$ 700,000$ 750,000$ 2,075,000$ 833,000$ 2,908,000$ 10 Year Financial Trend Financial Impact Village Parking Lots Issue Routine sealing, restriping, and reconstruction of municipal lots is required. Solution The 2019 planned improvements include parking lots at the Metra Station ($30k), Police Station ($50k), the Public Service Center ($185k), Fire Station #25 (50k) and #26 ($3k), and Village Reservoirs #1, #2, and #6 ($2k). CIP $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 2014201520162017201820192020202120222023Page 165 of 424 Storm Water System Upgrades Project #4001 Category 4-Storm Water Management Priority 2-Essential Useful Life 50 Years Origination Major Maintenance User Department PW Coordinator Engineering Current Budget 300,000$ Initial Proposal Date Ongoing Design Work 2018 Project Work 2019 Location Reoccurance Yearly Asset Valuation 250,078,002$ Last Deferred N/A Last Incurred 2017 Fund General Fund Account Number 100.55.25.560.40 (Estimated) 2014 2015 2016 2017 2018 Historical Historical 505,031$ 408,162$ 307,639$ 402,239$ 349,660$ 2,506,071$ 2019 2020 2021 2022 2023 Short Term Short Term 750,000$ 420,000$ 420,000$ 400,000$ 400,000$ 2,390,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 2,125,000$ 2,250,000$ 3,500,000$ 7,875,000$ 2,390,000$ 10,265,000$ 10 Year Financial Trend Financial Impact Village Easements and ROW Issue The storm sewer system requires annual maintenance. Solution This program provides for the annual televising inspection program and the resulting storm sewer lining, point repairs, or replacements at priority locations within the Village's storm sewer network as identified through this program. Additionally, this includes the rear yard storm sewer repairs, repairs associated with road improvement projects by the Village as well as other jurisdictions and limited streambank restoration efforts. The 2019 amount also includes $170,000 for a storm water study. CIP $- $200,000 $400,000 $600,000 $800,000 2014201520162017201820192020202120222023Page 166 of 424 SCADA Improvements Project #5001 Category 5-Technology Priority 2-Essential Useful Life 8 Years Origination Major Maintenance User Department PW Coordinator PW Current Budget -$ Initial Proposal Date 2012 Design Work 2013 Project Work 2014-2020 Location Reoccurance Yearly Asset Valuation 1,500,000$ Last Deferred 2017-2018 Last Incurred 2016 Fund Water & Sewer Fund Account Number 170.55.35.560.60 (Estimated) 2014 2015 2016 2017 2018 Historical Historical 129,042$ 25,000$ 180,000$ -$ -$ 334,042$ 2019 2020 2021 2022 2023 Short Term Short Term 140,000$ 20,000$ 20,000$ 20,000$ 20,000$ 220,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 100,000$ 100,000$ 100,000$ 300,000$ 220,000$ 520,000$ 10 Year Financial Trend Financial Impact Public Works Infrasturcture Issue Improvements and component upgrades are detailed in the SCADA System Master Plan. Supervisory Control and Data Acquisition are a vital function of both the water pumping stations and sanitary lift stations. Solution This work was defered in 2017 and 2018, and is being requested again in 2019. Work is needed for hardware and software within the SCADA system in order to update security and alarming functionality, and replace key components which are no longer serviceable due to manufacturer obsolescence. CIP $- $50,000 $100,000 $150,000 $200,000 2014201520162017201820192020202120222023Page 167 of 424 Laserfiche Project #5003 Category 5-Technology Priority 2-Essential Useful Life 5 Years Origination Scheduled Upgrades User Department IT Coordinator IT Current Budget -$ Initial Proposal Date 0 Design Work 2018 Project Work 2019 Location Reoccurance 2024 Asset Valuation -$ Last Deferred N/A Last Incurred N/A Fund IT Fund Account Number 211.92.555.40 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term 28,000$ -$ -$ -$ -$ 28,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ -$ -$ 28,000$ 28,000$ 10 Year Financial Trend Financial Impact Village Network Issue In order to maintain Laserfiche functionality though upgrade cycles, and also to open up a public portal to access Freedom of Information Act (FOIA) documents, infrastructure upgrades are needed. Solution Laserfiche required updgrades include file storage (9TB for $15,000), Server 2016 licensing ($3500), SQL Server 2018 ($4500), plus training and authorized reseller support. CIP $- $5,000 $10,000 $15,000 $20,000 $25,000 $30,000 2014201520162017201820192020202120222023Page 168 of 424 Microsoft Licensing Project #5004 Category 5-Technology Priority 2-Essential Useful Life 5 Years Origination Scheduled Upgrades User Department IT Coordinator IT Current Budget -$ Initial Proposal Date 0 Design Work 2018 Project Work 2019 Location Reoccurance 2024 Asset Valuation -$ Last Deferred 2015 Last Incurred 2010 Fund IT Fund Account Number 211.92.555.40 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ 41,000$ 41,000$ 2019 2020 2021 2022 2023 Short Term Short Term 52,000$ 52,000$ 70,450$ 52,000$ 52,000$ 278,450$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 250,000$ 250,000$ 250,000$ 750,000$ 278,450$ 1,028,450$ 10 Year Financial Trend Financial Impact Village Network Issue Microsoft software requires regular updates. The office suite was last upgraded in 2010. Solution For 2019, IT will migrate to Office 365. 250 licenses will cost $52,000 per year. CIP $- $20,000 $40,000 $60,000 $80,000 2014201520162017201820192020202120222023Page 169 of 424 Storm Water System Upgrades Project #4001 Category 4-Storm Water Management Priority 2-Essential Useful Life 50 Years Origination Major Maintenance User Department PW Coordinator Engineering Current Budget 300,000$ Initial Proposal Date Ongoing Design Work 2018 Project Work 2019 Location Reoccurance Yearly Asset Valuation 250,078,002$ Last Deferred N/A Last Incurred 2017 Fund General Fund Account Number 100.55.25.560.40 (Estimated) 2014 2015 2016 2017 2018 Historical Historical 505,031$ 408,162$ 307,639$ 402,239$ 349,660$ 2,506,071$ 2019 2020 2021 2022 2023 Short Term Short Term 750,000$ 420,000$ 420,000$ 400,000$ 400,000$ 2,390,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 2,125,000$ 2,250,000$ 3,500,000$ 7,875,000$ 2,390,000$ 10,265,000$ 10 Year Financial Trend Financial Impact Village Easements and ROW Issue The storm sewer system requires annual maintenance. Solution This program provides for the annual televising inspection program and the resulting storm sewer lining, point repairs, or replacements at priority locations within the Village's storm sewer network as identified through this program. Additionally, this includes the rear yard storm sewer repairs, repairs associated with road improvement projects by the Village as well as other jurisdictions and limited streambank restoration efforts. The 2019 amount also includes $170,000 for a storm water study. CIP $- $200,000 $400,000 $600,000 $800,000 2014201520162017201820192020202120222023Page 166 of 424 SCADA Improvements Project #5001 Category 5-Technology Priority 2-Essential Useful Life 8 Years Origination Major Maintenance User Department PW Coordinator PW Current Budget -$ Initial Proposal Date 2012 Design Work 2013 Project Work 2014-2020 Location Reoccurance Yearly Asset Valuation 1,500,000$ Last Deferred 2017-2018 Last Incurred 2016 Fund Water & Sewer Fund Account Number 170.55.35.560.60 (Estimated) 2014 2015 2016 2017 2018 Historical Historical 129,042$ 25,000$ 180,000$ -$ -$ 334,042$ 2019 2020 2021 2022 2023 Short Term Short Term 140,000$ 20,000$ 20,000$ 20,000$ 20,000$ 220,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 100,000$ 100,000$ 100,000$ 300,000$ 220,000$ 520,000$ 10 Year Financial Trend Financial Impact Public Works Infrasturcture Issue Improvements and component upgrades are detailed in the SCADA System Master Plan. Supervisory Control and Data Acquisition are a vital function of both the water pumping stations and sanitary lift stations. Solution This work was defered in 2017 and 2018, and is being requested again in 2019. Work is needed for hardware and software within the SCADA system in order to update security and alarming functionality, and replace key components which are no longer serviceable due to manufacturer obsolescence. CIP $- $50,000 $100,000 $150,000 $200,000 2014201520162017201820192020202120222023Page 167 of 424 Laserfiche Project #5003 Category 5-Technology Priority 2-Essential Useful Life 5 Years Origination Scheduled Upgrades User Department IT Coordinator IT Current Budget -$ Initial Proposal Date 0 Design Work 2018 Project Work 2019 Location Reoccurance 2024 Asset Valuation -$ Last Deferred N/A Last Incurred N/A Fund IT Fund Account Number 211.92.555.40 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term 28,000$ -$ -$ -$ -$ 28,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ -$ -$ 28,000$ 28,000$ 10 Year Financial Trend Financial Impact Village Network Issue In order to maintain Laserfiche functionality though upgrade cycles, and also to open up a public portal to access Freedom of Information Act (FOIA) documents, infrastructure upgrades are needed. Solution Laserfiche required updgrades include file storage (9TB for $15,000), Server 2016 licensing ($3500), SQL Server 2018 ($4500), plus training and authorized reseller support. CIP $- $5,000 $10,000 $15,000 $20,000 $25,000 $30,000 2014201520162017201820192020202120222023Page 168 of 424 Microsoft Licensing Project #5004 Category 5-Technology Priority 2-Essential Useful Life 5 Years Origination Scheduled Upgrades User Department IT Coordinator IT Current Budget -$ Initial Proposal Date 0 Design Work 2018 Project Work 2019 Location Reoccurance 2024 Asset Valuation -$ Last Deferred 2015 Last Incurred 2010 Fund IT Fund Account Number 211.92.555.40 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ 41,000$ 41,000$ 2019 2020 2021 2022 2023 Short Term Short Term 52,000$ 52,000$ 70,450$ 52,000$ 52,000$ 278,450$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 250,000$ 250,000$ 250,000$ 750,000$ 278,450$ 1,028,450$ 10 Year Financial Trend Financial Impact Village Network Issue Microsoft software requires regular updates. The office suite was last upgraded in 2010. Solution For 2019, IT will migrate to Office 365. 250 licenses will cost $52,000 per year. CIP $- $20,000 $40,000 $60,000 $80,000 2014201520162017201820192020202120222023Page 169 of 424 HVAC Unit Replacements Project #1005 Category 1-Buildings and Grounds Priority 2-Essential Useful Life 18 Years Origination Major Maintenance User Department PW Coordinator PW Current Budget -$ Initial Proposal Date 2015 Design Work 2018 Project Work 2019 Location Reoccurance 2036 Asset Valuation -$ Last Deferred 2018 Last Incurred 2018 (Unbudgeted) Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ 92,237$ 550,000$ 250,000$ 892,237$ 2019 2020 2021 2022 2023 Short Term Short Term -$ 120,000$ 120,000$ 120,000$ 120,000$ 480,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 250,000$ 250,000$ 250,000$ 750,000$ 480,000$ 1,230,000$ 10 Year Financial Trend Financial Impact Village Facilities Issue The Village maintains 61 HVAC units in total and more than half are currently exceeding their 18 year life expectancy. Solution In 2018, replacements of HVAC units are planned at Police (1 units and controls), Village Hall (6 units), and BG Golf Course (1 unit). Several failures during the year have lead to emergency expenses, although no money was budgeted in 2018. Due to these end of year replacements, no request is being made in 2019. CIP $- $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 2014201520162017201820192020202120222023Page 147 of 424 Roof Capital Replacement Projects Project #1006 Category 1-Buildings and Grounds Priority 3-Sustaining Useful Life 30 Years Origination Major Maintenance User Department PW Coordinator PW Current Budget -$ Initial Proposal Date 2014 Design Work 2018 Project Work 2019 Location Reoccurance 2048 Asset Valuation 2,000,000$ Last Deferred 2018 Last Incurred 2017 Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ 197,766$ 72,000$ 276,850$ -$ 546,616$ 2019 2020 2021 2022 2023 Short Term Short Term 518,954$ 25,000$ 85,000$ 420,000$ -$ 1,048,954$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 191,800$ 250,000$ 300,000$ 741,800$ 1,048,954$ 1,790,754$ 10 Year Financial Trend Financial Impact Village Facilities Issue Roof replacement projects were identified during the 2018 roof inspection reports prepared by Industrial Roofing Services. Solution For 2019, work is planned to include Police, Public Service Center, and Well #1. CIP $- $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 2014201520162017201820192020202120222023Page 148 of 424 Fire Station Sign Replacement Project #1007 Category 1-Buildings and Grounds Priority 4-Contributory Useful Life 20 Years Origination Major Maintenance User Department Fire Coordinator Fire Current Budget -$ Initial Proposal Date 2016 Design Work 2019 Project Work 2019 Location Reoccurance 2041 Asset Valuation 84,000$ Last Deferred 2017 Last Incurred N/A Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term 28,000$ 28,000$ 28,000$ -$ -$ 84,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ -$ -$ 84,000$ 84,000$ 10 Year Financial Trend Financial Impact Fire Stations 25, 26, & 27 Issue The current signs are deteriorated and poorly oriented for visibility. Solution Plan for replacement of one sign at each fire station, over each of three years. CIP $- $5,000 $10,000 $15,000 $20,000 $25,000 $30,000 2014201520162017201820192020202120222023Page 149 of 424 Village Campus Long Range Planning Project #1008 Category 1-Buildings and Grounds Priority 4-Contributory Useful Life 10 years Origination New User Department Community Development Coordinator Community Development Current Budget 80,000$ Initial Proposal Date 2017 Design Work 2018 Project Work N/A Location Reoccurance As Needed Asset Valuation N/A Last Deferred N/A Last Incurred 2017 Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ 20,000$ -$ 20,000$ 2019 2020 2021 2022 2023 Short Term Short Term 80,000$ -$ -$ -$ -$ 80,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ -$ -$ 80,000$ 80,000$ 10 Year Financial Trend Financial Impact Village Campus Planning Issue Several buildings on the Village Campus are nearing the end of their useful life and do not fit the space or configuration required for current Village operations. Solution In 2017, the Village used Wold Architects to begin a space needs assessment of the currentl buildings. 2019 work will continue to evaluate solutions for either major renovations and remodeling, or a move to new buildings. CIP $- $20,000 $40,000 $60,000 $80,000 $100,000 2014201520162017201820192020202120222023Page 150 of 424 Village Gateway Feature (Milwaukee Ave/Deerfield Ave) Project #1009 Category 1-Buildings and Grounds Priority 4-Contributory Useful Life 20 Years Origination New User Department Community Development Coordinator Community Development Current Budget 25,000$ Initial Proposal Date 2017 Design Work 2019 Project Work 2020 Location Reoccurance 2030 (First Maintenance) Asset Valuation 100,000$ Last Deferred 2018 Last Incurred N/A Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term 25,000$ 50,000$ 25,000$ -$ -$ 100,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ 10,000$ -$ 10,000$ 100,000$ 110,000$ 10 Year Financial Trend Financial Impact Corner of Milwaukee Ave and Deerfield Ave Issue As part of the Woodman's project, staff has proposed the replacement of the Village entrance sign with a new "gateway" feature. Solution A new gateway feature, possibly including a new sign, landscaping, and pedestrian amenities would be designed in 2019 for construction in 2020-2021. CIP $- $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 2014201520162017201820192020202120222023Page 151 of 424 Police Headquarters Project #1010 Category 1-Buildings and Grounds Priority 4-Contributory Useful Life 15 Years Origination Major Maintenance User Department Police Coordinator PW Current Budget -$ Initial Proposal Date 2019 Design Work 2019 Project Work 2019 Location Reoccurance 2034 Asset Valuation 11,920,340$ Last Deferred N/A Last Incurred N/A Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term 150,000$ 100,000$ 100,000$ 100,000$ 100,000$ 550,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 9,540,000$ 850,000$ -$ 10,390,000$ 550,000$ 10,940,000$ 10 Year Financial Trend Financial Impact Police Headquarters Issue Police Headquarters was originally built in 1988, with the last major addition in 1997. Major maintenance and remodeling are required. Solution For 2019, Police is requesting two areas of major work. First, the locker room shower areas, in both the men's and women's locker rooms needs a full remodel with work to reconfigure the space to add privacy. All tile work and plumbing is original and showing wear and tear beyond what regular maintenance can repair. Second, the patio area outside of the training room needs work to repair or replace heaved sections of concrete and eliminate trip hazards. Some landscaping work is needed to keep dirt off the walkway and patio, through landscaped terrace work. Finally, the patio furnishings need replacement. CIP $- $50,000 $100,000 $150,000 $200,000 2014201520162017201820192020202120222023Page 152 of 424 Fire Station #26 Addition Project #1011 Category 1-Buildings and Grounds Priority 3-Sustaining Useful Life 20 Years Origination Major Maintenance User Department Fire Coordinator Fire Current Budget -$ Initial Proposal Date 2019 Design Work 2019 Project Work 2020 Location Reoccurance 2035 (First Renovation) Asset Valuation -$ Last Deferred 2009 Last Incurred N/A Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term -$ 2,745,712$ -$ -$ -$ 2,745,712$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ 250,000$ 250,000$ 2,745,712$ 2,995,712$ 10 Year Financial Trend Financial Impact Fire Station 26 Issue Fire Station 26 was built in 1980. The fire station has been remodeled a number of times including an administrative wing addition in 1993. The 2014 and 2017 space needs assessments, both defined the need for both renovated and additional space. Solution Wold Architects recommended a major renovation (7,000 sq ft/$301,00) and adding an additional 1,500 square feet ($1,175,000). The apparatus bays and support areas would be remodeled but would remain substantially the same. Other costs identified by Wold included Soft Costs ($265,152), Facility analysis ($733,600), Furniture & Equipment ($50,000) and contingency ($220,960) for a total of $2,745,712. CIP $- $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 2014201520162017201820192020202120222023Page 153 of 424 Public Works Facility Project #1012 Category 1-Buildings and Grounds Priority 2-Essential Useful Life 40 Years Origination New User Department PW Coordinator PW Current Budget -$ Initial Proposal Date 2019 Design Work 2019 Project Work 2020-2021 Location Reoccurance 2035 (First Renovation) Asset Valuation 30,000,000$ Last Deferred 2008-2018 Last Incurred N/A Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term 5,000,000$ 25,000,000$ 2,000,000$ -$ -$ 32,000,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ 250,000$ 250,000$ 32,000,000$ 32,250,000$ 10 Year Financial Trend Financial Impact TBD Issue The Public Service Center was constructed in 1976, with major remodeling in 1988 and 1992. Major building additions have been deferred since 2007. Solution Public Works has outgrown both its facility and the yard space available on the current parcel as discussed in detail in the 2017 Facility Space Needs Assessment. This project would move Public Works to a new site, with all associated land acquisition, land development, and building expenses. Land Acquisition, planning and engineering are programmed for 2019, with major facility consturction programmed for 2020. CIP $- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 $30,000,000 2014201520162017201820192020202120222023Page 154 of 424 Village Hall - Office Remodel Project #1013 Category 1-Buildings and Grounds Priority 4-Contributory Useful Life 15 Years Origination Major Maintenance User Department OVM Coordinator PW Current Budget -$ Initial Proposal Date 2019 Design Work 2019 Project Work 2019 Location Reoccurance 2034 Asset Valuation 3,847,200$ Last Deferred N/A Last Incurred N/A Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term 68,425$ -$ -$ -$ -$ 68,425$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 4,300,000$ -$ -$ 4,300,000$ 68,425$ 4,368,425$ 10 Year Financial Trend Financial Impact Village Hall Issue Village Hall was built in 1970 and underwent major renovations in 1988 and 1993. With the OVM office area due for remodeling, rearrangement of workspaces and security improvements through keycard access control are requested. Solution Project would include design work, construction, and key card access control for the space. Design and construction are being programmed for 2019. CIP $- $20,000 $40,000 $60,000 $80,000 2014201520162017201820192020202120222023Page 155 of 424 Fire Station 25 Replacement Project #1014 Category 1-Buildings and Grounds Priority 4-Contributory Useful Life 40 Years Origination New User Department Fire Coordinator Fire Current Budget -$ Initial Proposal Date 2019 Design Work 2019 Project Work 2020 Location Reoccurance 2060 Asset Valuation 4,457,930$ Last Deferred N/A Last Incurred N/A Fund Capital Projects - Facilities Account Number 150.75.560.30 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term 350,000$ 3,500,000$ -$ -$ -$ 3,850,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ -$ -$ 3,850,000$ 3,850,000$ 10 Year Financial Trend Financial Impact Fire Station 25 Issue Fire Station 25 was built in 1972 and underwent major renovations in 1992, 1997, and 2004. As Buffalo Grove and surrounding communities grew, the location of the fire station is not optimal for fire and EMS response times. The building and infrastructure is 44 years old. Solution Relocating and building a replacement Fire Station 25 would provide a building that would be more energy efficient, designed for its intended purpose as a full time fire station, would better serve the citizens by being better located for the current Buffalo Grove boundaries and would have a useful life of 50 years. Construction costs are based on a 10,000 square foot fire station at $350 per square foot. Costs do not include the property values of the current Fire Station 25 location and its relocated property. CIP $- $1,000,000 $2,000,000 $3,000,000 $4,000,000 2014201520162017201820192020202120222023Page 156 of 424 Golf Course Improvements Project #2001 Category 2-Golf Course Improvements Priority 3-Sustaining Useful Life 20 Years Origination Major Maintenance User Department Golf Coordinator Golf Current Budget 25,000$ Initial Proposal Date 2016 Design Work 2019 Project Work 2019 Location Reoccurance 2039 Asset Valuation -$ Last Deferred N/A Last Incurred N/A Fund Golf Reserves Account Number 0 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term 75,000$ 75,000$ 75,000$ 40,000$ 250,000$ 515,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ -$ -$ 515,000$ 515,000$ 10 Year Financial Trend Financial Impact Golf Courses Issue Due to the age of the courses, several land restoration projects are needed to maintain golfability. Solution In 2019 through 2021, a three year project to restore all 69 sand traps at Arboretum is being programed ($75k each year). Proposed for 2022 is the design for the removal of sediment from the pond at the 15th hole at Arboretum ($40k) with construction planned for 2023 ($250k). CIP $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 2014201520162017201820192020202120222023Page 157 of 424 Golf Course Irrigation Improvements Project #2002 Category 2-Golf Course Improvements Priority 3-Sustaining Useful Life 20 Years Origination Major Maintenance User Department Golf Coordinator Golf Current Budget 33,000$ Initial Proposal Date 2016 Design Work 2019 Project Work 2019 Location Reoccurance 2039 Asset Valuation -$ Last Deferred N/A Last Incurred N/A Fund Golf Reserves Account Number 0 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ 19,000$ 19,000$ 2019 2020 2021 2022 2023 Short Term Short Term 25,000$ 55,000$ -$ -$ -$ 80,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term -$ -$ -$ -$ 80,000$ 80,000$ 10 Year Financial Trend Financial Impact Golf Courses Issue Irrigation repairs and piping replacements are due at both golf courses. Solution For 2019, the irrigation pumps at Arboretum are planned for replacement. Additional work to irrigation pumps and control systems is being programmed through 2020. CIP $- $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 2014201520162017201820192020202120222023Page 158 of 424 Multiple Area Network Project #5005 Category 5-Technology Priority 2-Essential Useful Life 7 Years Origination Major Maintenance User Department IT Coordinator IT Current Budget -$ Initial Proposal Date 2018 Design Work 2018 Project Work 2018-2019 Location Reoccurance 2026 Asset Valuation 200,000$ Last Deferred N/A Last Incurred 0 Fund IT Fund Account Number 211.92.555.40 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ 12,000$ 12,000$ 2019 2020 2021 2022 2023 Short Term Short Term 150,000$ 25,000$ -$ -$ -$ 175,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 200,000$ 250,000$ 300,000$ 750,000$ 175,000$ 925,000$ 10 Year Financial Trend Financial Impact Antenna Towers Issue The current Radwin network is experiencing issues due to bandwidth limitations. Solution All four sectors require new antennas. CIP $- $50,000 $100,000 $150,000 $200,000 2014201520162017201820192020202120222023Page 170 of 424 Police Mobile Computers Project #5006 Category 5-Technology Priority 2-Essential Useful Life 5 Years Origination Major Maintenance User Department Police Coordinator IT Current Budget -$ Initial Proposal Date 2013 Design Work 2018 Project Work 2019 Location Reoccurance 2024 Asset Valuation 120,000$ Last Deferred N/A Last Incurred 2013 Fund DUI Fund Account Number 211.92.555.40 (Estimated) 2014 2015 2016 2017 2018 Historical Historical -$ -$ -$ -$ -$ -$ 2019 2020 2021 2022 2023 Short Term Short Term 120,000$ -$ -$ -$ -$ 120,000$ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term 120,000$ 120,000$ 120,000$ 360,000$ 120,000$ 480,000$ 10 Year Financial Trend Financial Impact Police Vehicles Issue Ruggedized laptops in the Police vehicles are on a 5 year replacement schedule per the standards set by the GovIT Consortium. In 2019, new CAD software will be implemented by Northwest Central Dispatch. Solution In conjunction with the CAD implementation in 2019, all twenty-two mobile laptops in the Police vehicles are up for replacement. The current computers will be 7 years old at the time of replacement. In addition, there may be other hardware needs as the CAD system is implemented. CIP $- $20,000 $40,000 $60,000 $80,000 $100,000 $120,000 $140,000 2014201520162017201820192020202120222023Page 171 of 424