The URL can be used to link to this page

2024-08-05 - Village Board Committee of the Whole - Agenda Packet BUFFALO GROVE VILLAGE BOARD BUFFALO Committee of the Whole: August 5, 2024 at 7:30 PM Gl "'u Jeffrey S. Braiman Council Chambers Fifty Raupp Blvd Buffalo Grove, IL 60089-2139 1 . Call to Order a. Pledge of Allegiance b. Roll Call 2. Village President's Report 3. Special Business a. Oath of Office and Badge Presentation to Battalion Chief Daniel Pasquarella (Trustee Cesario, Lawrence Kane) b. Badge Presentation to Lt. Daniel Downey (Trustee Cesario, Lawrence Kane) c. The Rotary Club of Buffalo Grove will be presenting the Bill Reid Award to Paul Zucker (President Smith, Molly Gillespie) d. Staff presentation regarding strategic planning efforts for the Rick Kahen Commission for Residents with Disabilities (Trustee Stein, Mike Skibbe) e. 2025 Capital Improvement Program Requests (Trustee Stein, Kyle Johnson) f. 2025 General Wage Increase and Merit Pool Recommendation (Trustee Ottenheimer, Kathryn Golbach) g. FY 2024- Six Month Report (Trustee Bocek, Chris Black) h. 2024 Preliminary Tax Levy (Trustee Bocek, Chris Black) 4. Public Comment Public Comment is limited to items that are not on the regular agenda. In accordance with Section 2.02.070 of the Municipal Code, discussion on questions from the audience will be limited to 5 minutes and should be limited to concerns or comments regarding issues that are relevant to Village Board business.All members of the public addressing the Village Board shall maintain proper decorum and refrain from making disrespectful remarks or comments relating to individuals. Speakers shall use every attempt to not be repetitive of points that have been made by others. The Village Board may refer any matter of public comment to the Village Manager, Village staff or an appropriate agency for review. 5. Executive Session Page 1 of 2 inairt.v id Iheairt. 50 I5faupp Blvd, BuffaloC'rove, IHI 60089 °,,: 04.7-459-2SOO,,s vk.g.org a. Executive Session - Section 2(C)(2) of the Illinois Open Meetings Act: Collective Negotiating Matters Between the Public Body and Its Employees or Their Representatives, or Deliberations Concerning Salary Schedules for One or More Classes of Employees. b. Executive Session - Section 2(C)(5) of the Illinois Open Meetings Act: (5) the Purchase or Lease of Real Property for the Use of the Public Body, Including Meetings Held for the Purpose of Discussing Whether a Particular Parcel Should be Acquired. 6. Adjournment The Village Board will make every effort to accommodate all items on the agenda by 10:30 p.m. The Board does, however, reserve the right to defer consideration of matters to another meeting should the discussion run past 10:30 p.m. The Village of Buffalo Grove, in compliance with the Americans with Disabilities Act, requests that persons with disabilities who require certain accommodations to allow them to observe and/or participate in this meeting or have questions about the accessibility of the meeting or facilities, contact the ADA Coordinator at 847-459-2500 to allow the Village to make reasonable accommodations for those persons. Page 2 of 2 i rhai . ird Il ea it . 50 I5laupp Blvd, Buffalo(-",xrove, IHI 60089 °,,: 84.7-459-2SOO,,s vi.g.org umlli II lBUFFALO uuuuuuu IIIIII uuuuuull uuumuuum uuuuuuu uuml BUFFALO GROVE VILLAGE BOARD Gl�,IIZQVE I Committee of the Whole: August 5, 2024 AGENDA ITEM .a. Oath of Office and Badge Presentation to Battalion Chief Daniel Pasquarella Contacts Liaison: Trustee Cesario Staff: Lawrence Kane Staff Recommendation Staff recommends presentation. Summary Battalion Chief Daniel Pasquarella will receive his oath of office for Battalion Chief and will be presented with his badge. Strategic Alignment Guiding Principle Principle 2: Outstanding Village Services Goal Goal 1: Maintained effective village government: fiscally responsible and providing outstanding, responsive services File Attachments None Page 1 of 1 i rha iif1.v I'd Il ea it. 50I5laupp Blvd, Buffalo(-",xrove, IHI 60089 °,,: 847-459-2SOO,,s vk.g.org umlli II lBUFFALO uuuuuuu IIIIII uuuuuull uuumuuum uuuuuuu uuml BUFFALO GROVE VILLAGE BOARD Gl�,IIZQVE I Committee of the Whole: August 5, 2024 AGENDA ITEM . . Badge Presentation to Lt. Daniel Downey Contacts Liaison: Trustee Cesario Staff: Lawrence Kane Staff Recommendation Staff recommends presentation. Summary Badge presentation to newly promoted to Lt. Daniel Downey Strategic Alignment Guiding Principle Principle 2: Outstanding Village Services Goal Goal 1: Maintained effective village government: fiscally responsible and providing outstanding, responsive services File Attachments None Page 1 of 1 i rha iif1.v I'd Il ea it. 50I5laupp Blvd, Buffalo(-",xrove, IHI 60089 °,,: 847-459-2SOO,,s vk.g.org umlli II lBUFFALO uuuuuuu IIIIII uuuuuull uuumuuum uuuuuuu uuml BUFFALO GROVE VILLAGE BOARD Gl�,IIZQVE I Committee of the Whole: August 5, 2024 AGENDA ITEM .c. The Rotary Club of Buffalo Grove will be presenting the Bill Reid Award to Paul Zucker Contacts Liaison: President Smith Staff: Molly Gillespie Staff Recommendation Staff recommends presentation. Summary The Rotary Club of Buffalo Grove will present its annual Bill Reid award to 2023 recipient and longtime village volunteer Paul Zucker. The award honors outstanding individuals in the community who have demonstrated long-term commitments to enhancing the spirit and betterment of Buffalo Grove. Strategic Alignment Guiding Principle Principle 6: Engages Our Residents Goal Goal 3: Strengthened Buffalo Grove community identity and pride File Attachments None Page 1 of 1 i rh uur .v i,d Il ea it . 50I5laupp Blvd, Buffalo(_`xrove, IHI 60089 °,,: 847-459-2SOO,,s vk.g.org umlli II lBUFFALO uuuuuuu IIIIII uuuuuull uuumuuum uuuuuuu uuml BUFFALO GROVE VILLAGE BOARD Gl�,IIZQVE I Committee of the Whole: August 5, 2024 AGENDA ITEM . . Staffpresentation regarding strategic planning efforts for the Rick Kahen Commission for Residents with Disabilities Contacts Liaison: Trustee Stein Staff: Mike Skibbe Staff Recommendation Staff recommends presentation. Summary Staff will be providing an overview of the strategic planning efforts for the Rick Kahen Commission for Residents with Disabilities. Strategic Alignment Guiding Principle Principle 6: Engages Our Residents Goal Goal 3: Strengthened Buffalo Grove community identity and pride File Attachments None Page 1 of 1 i rh uu, . i,d Il ea it . 50I5laupp Blvd, Buffalo(-",xrove, IHI 60089 °,,: 847-459-2SOO,,s vk.g.org umlli II lBUFFALO uuuuuuu IIIIII uuuuuull uuumuuum uuuuuuu uuml BUFFALO GROVE VILLAGE BOARD Gl�,IIZQVE I Committee of the Whole: August 5, 2024 AGENDA ITEM .e. 2025 Capital Improvement Program Requests Contacts Liaison: Trustee Stein Staff: Kyle Johnson Staff Recommendation Staff recommends discussion. Summary Attached please find the initial presentation of the 2025 Capital Improvement Program (CIP) requests. Staff will present the requests to the Village Board for discussion purposes only. Strategic Alignment Guiding Principle Principle 1: Financially Responsible and Sound Goal Goal 1: Maintained effective village government: fiscally responsible and providing outstanding, responsive services File Attachments 1. 8.5.24 CIP Request Presentation 2. 2025 Draft Request Budget Pages Page 1 of 1 i rha iif1.v I'd Il ea it. 50I5laupp Blvd, Buffalo(-",xrove, IHI 60089 °,,: 847-459-2SOO,,s vk.g.org U) �a cl? 3 s� EL 0 C _0 m C) 10- o _ x � %0000/ IIIIIIIIIIIIII IIIIIIIIIIII �%,�/ "° � !�� Is ........ 17 �..... V) Q +-b —C IIIII IIIIIIIIIIII f C� "=a C� I......... 0 M) U C ai/ n �I mommimm C"\j C'\I C`J IIIIIIIIIIIIIIIIIII t"Y} CNJ MEN= C' NONE= MEN= C o.l IIIIIIIIIIIIIIIIII IIIIIIIIIIIIIIII IIIIIIIIIIIIIIIIIIIIIIIII �1 III IIIIIIIIIIIIIIIIIIIIIIIII c;-� II�IIIIIIIIIIIIIIIIIIII IIIIIC�� C o..l C-) C-) C::::) CD CD CJ C:7 C...D C.... C� :tea C) G.:...7 CD C...a C,:..1 C (.wa C_:) C..:) C) C` �C.) L(a (y) C\1 4:/"7- a✓+ A:::A':.7- 4J=} a::� .fib# .a. . 4- N uuuuuuuullllllllllllllllllllllll Illlllllllllllllllllllllllllllllllllllllllllllllllllluuuuuuum�� p � o N o 0 IR V N IIIIIIIIIIIIIIIIII IIIIIIIIIII QJ � � N � III IIIIIIIIIIIIIIIIIIIII v � � � � O Q in n IIIIII V m QD 66 O - C V Q� Q IIIIIIIIIIIIIIIIIIIIIII � v uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu N O o- c� .Q V a� L o N f O � � O0 o >� Ev N > Q) p o S Olt I MENEM= C\,I NONE= , C\1 C\.I III IIIIIIIIIIIIIIIIIIIIIIIII Cy-) C'J C") C"\J III�IIIIIIIIIIIIIIIIIIII C'\I C`t.l r C"\.I IIIIIIIIIIIIIIIIIIIIIIIII III IIIIIIIIIIIIIIIIIIIIIIIII IIIIIIIIIIIIIIIIIIIIIII C;> C\.J C) C) C.D C.D C to C:..:.J C..:) G:-) ). .. C . C 7 C:') C:,::) CD C) C \.J' Cv'7 k79 Ln aN 0 MENNIMM r4 �NoMy,Ip W Y �yp�do U) MEIN= d W u a W r'4 4 a ca `y ul rp^'4 � �A,.,.,A M W me. 4 n' 6 cw & Mw µ.,,,i) ym G�M CD 0 ✓ 0 w M � ✓ — 0 0 0 �,��yy„y mm��WW,,,,, nn ppe�w... ��pq,rr wm�„��y „y �pp�„y p „y q„+. �.Iw. '6,w.0 waw '.Wd �"*,II 'r l"M 06 ^+kxd °+N 'o M r-N a,,,,,,,I q ate, a N 4J 06 U O ; 4 N E O +� O cn - OE = o6 +- O N o � � a , � a � � oQ +� U c o � � Q � � � a� _ 1 � � a� � C zU� — maaacnUaUvmaU cry IIIIIIIIIIIIIIIIIII • • • • • • • • • • • • • • IIII IIIIIIIIIIIIIIIIIIIII Lr Im uuuuuu II IIIIIIIIIIIIIIIIIII oiiiiiiil � uuu uuu IIIIIIIIIIIIIIII IIIIIIII IIIIIIIIIII i � � uuuuuuuum u uuuu O IIIIIIIII IIIIIIIIIII ��iiiiiiiiiouuuu � u ul rL 16 IIIIIIIIIIIIIIIIIIIII IIIIIIIIIII IIIII IIII Ills � �,uuuuuuuuum r 2 rq uuumou ® .u° �4 � u„ Im ouuiioiiiiiiiii 4,1111111111111111111 111°°°°°° uuuulm, �uuuumuu,m luuummll v uuuuuuuuuuuuu uuuuuuuum uu uuuu cu �y up uuuuuu OIR " co uuuuuu M 0 U V) IPuuuuuuuuu rrf j r 10 °n uuuuuuuuuuuuuuuuuuuuuuii i / Li- uuuuiuuuuuu� ._ uuuuuuuuuii� "' ` ; IIII uuuuuuuuu� ' � IIII IIII ui IIII i j iiuuuuuuuuuui � IIII , � M VVVVVVVVVVVVVVIV Y�i�uuuuuuVuuuuuuuuuuuuuuuuuuuuuuu � IIII """"' i •' s In= c\� CXD C\j NONNI= ('C:..;l \.I tS: C.:D MENEM= C\I in C\J , II C\cr IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII �� ca ... n C\.I IIIIIIIIIIIII C� C\I IM, C'�1 Cr C I iiiiii II IIIIIIIIIIIIIIIIIIIIIIIII C\j C\j MEE= III III C\I CD C\� Cy`-� C C:..a C..:.> 4:.�� D C C�) C-') CJ C) C�) Cm"J C—) C ) 7 6 C 5 C:J C.7 C 7 C—) C) CC) CD CD C=) >t Village Campus Long Range Planning II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 1001 Category 1-Buildings and Grounds Priority 4-Contributory Useful Life 10 years r Origination Planning Tool User Department Community Development Coordinator Community Development Current Budget $ 40,000 Initial Proposal Date 2017 Design Work 2020-2024 Project Work N/A Location Village Campus Planning Recurrence As Needed Asset Valuation N/A Several buildings on the Village Campus are nearing the end Last Deferred N/A Issue of their useful life and do not fit the space or configuration Last Incurred 2022 required for current Village operations. Fund General Fund Account Number 150.75.560.30 10 Year Financial Trend In 2017,the Village used Wold Architects to begin a space $50,000 needs assessment of the current buildings.In 2019 the $40,000 Village began to evaluate solutions for facility options,with $30,000 Solution Village continuing on an as needed basis. In 2024,as Public Works leaves its current site additional options will be $�0,000 explored through conceptual study and design. $10,000 $ w .... O W W Q1 N N N N N N N N N O O O O O 0 O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ 9,000 $ - $ - $ 15,000 $ 25,000 $ 49,000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 40,000 $ 25,000 $ 25,000 $ - $ - $ 90,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ - $ - $ - $ $ 90,000 $ 90,000 umum Page 19 of 104 Village wide Comprehensive Plan and Design ��wlU�wlU�wlU�wlU�wlU�wlU� ��wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU� Project# 1002 Category 1-Buildings and Grounds Priority 4-Contributory Useful Life 10 Years Origination Planning Tool f User Department Community Development Coordinator Community Development Current Budget $ Initial Proposal Date 2018 Design Work 2019-2024 Project Work N/A Location Planning Document Recurrence 2033 Asset Valuation N/A '.The Village Board and staff have set a goal to update the Last Deferred N/A Issue Village's Comprehensive Plan. Last Incurred 2022 Fund General Fund Account Number 150.75.560.30 Completing this task would fulfill goals and 10 Year Financial Trend recommendations in both the Economic Development Plan $140,000 and the Village's Strategic Plan.This is a multi-year project $120,000 NZ that began in 2019 and is continuing into 2024 due to the $100,000solution COVID-19 delay.The Comprehensive Plan project includes a $80,000 village-wide analysis,vision,and plan; a deeper dive $60,000 analysis and plan for the Milwaukee Avenue and Dundee $40,000 Road corridors;and design guidelines for the Lake Cook $20,000Corridor. $- o N m a n o co m 0 0 O N 0 0 0 0 N N N O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ 103,620 $ 120,000 $ 73,000 $ 25,000 $ $ 321,620 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ _ $ _ $ _ $ _ $ $ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 20,000 $ 250,000 $ $ 270,000 $ $ 27Q000 umum Page 20 of 104 Flooring Capital Replacement Projects II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 1003 Category 1-Buildings and Grounds Priority 4-Contributory Useful Life 10 Years Origination Major Maintenance User Department PW Coordinator PW ............ ,,,,,,, ,,,,,,... Current Budget $ 10,500 Initial Proposal Date 2015 Design Work 2018 Project Work 2024 Location Village Buildings Recurrence Yearly Asset Valuation $ 1,200,000 Last Deferred 2019-2023 On average,carpet is 4-6 years past the date it was ISSU2 Last Incurred 2022 scheduled to be replaced. Fund Capital Projects-Facilities Account Number 150.75.560.30 10 Year Financial Trend $200,000 FY25 proposed work to include the Buffalo Grove pro shop $150,000 Solution and restaurant carpet($10.5k);also misc cleaning at various $100,000 facilities $50,000 N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ - $ 45,000 $ 108,000 $ 165,000 $ 30,000 $ 348,000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 10,500 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 50,s00 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 300,000 $ 300,000 $ 200,000 $ 800,000 $ 50,500 $ 85Q500 umum Page 21 of 104 Fire Station #27 Remodel II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 1004 Category 1-Buildings and Grounds Priority 3-Sustaining Useful Life 20 Years �, ''ii y '"i((lllllllll Origination Major Maintenance User Department Fire ,ro�mm Sri iar' Coordinator Fire IIII�I^jmmp Current Budget $ 30,000 IIII Initial Proposal Date 2016 Design Work 2026 Project Work 2027 Location Fire Station#27 Recurrence 2045 Asset Valuation $ 2,130,066 Fire Station 27 was built in 1993 as a full time fire station Last Deferred 2018-2023 and is the newest of the three fire stations.The 2017 space ISSU2 needs assessments identified the need for a space Last Incurred N/A renovation and fire sprinklers for the first floor. Fund Capital Projects-Facilities Account Number 150.75.560.30 10 Year Financial Trend $1,400,000 Proposed 2025 projects include replacement windows $1,200,000 ($30k)and a traffic signal loop for exiting onto Rt.22($25k). $1,000,000 Solution A renovation of the residential space is proposed with $800,000 design in 2026($102k)and construction in 2027($1.28 $600,000 million-adjusted for inflation in the figures below). $400,000 $200,000 N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ - $ $ 48,000 $ 20,000 $ 55,000 $ 123,000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 55,000 $ 99,200 $ 1,240,000 $ - $ - $ 1,394,200 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ - $ - $ - $ $ 1,394,200 $ 1,394,200 umum Page 22 of 104 HVAC Unit Replacements II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 1005 �� '4 VuuuuuuuuuuuuuuuuVV�V� VV III I�III�IIIIII ��ii Category 1-Buildings and Grounds Priority 2-Essential Useful Life 18Years Origination Major Maintenance User Department PW Coordinator PW i i u 1 II4 +'h i t Current Budget $ 75,000 io Initial Proposal Date 2015 Design Work 2022 Project Work 2024 Location Village Facilities Recurrence 2041 Asset Valuation $ 1,580,038 Last Deferred 2018-2023 The Village maintains 61 HVAC units in total and more than ISSU2 half are currently exceeding their 18 year life expectancy. Last Incurred 2022 Fund Capital Projects-Facilities Account Number 150.75.560.30 10 Year Financial Trend $200,000 $150,000 Solution The FY25 request is to replace 2 RTU's at the Police Station. $100,000 $50,000 �um �.... $- Y L........ .... I ....Y ....T N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ - $ 50,000 $ 55,000 $ 175,000 $ 12,000 $ 292,Ooo Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 75,000 $ 30,000 $ 50,000 $ 10,000 $ 10,000 $ 175,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 750,000 $ 875,000 $ 1,000,000 $ 2,625,000 $ 175,000 $ 2,800,000 umum Page 23 of 104 Roof Capital Replacement Projects II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 1006 Category 1-Buildings and Grounds ii4omw;ydm Da ` ,gat � „ Priority 3-Sustaining Useful Life 30Years Origination Major Maintenance o " User Department PW Coordinator PW Current Budget $ 900,000 Initial Proposal Date 2014 Design Work 2018 Project Work 2024 Location Village Facilities Recurrence 2052 Asset Valuation $ 2,000,000 Roof replacement projects were identified during the 2018 Last Deferred 2018-2023 Issue roof inspection reports prepared by Industrial Roofing Last Incurred 2022 Services. Fund Capital Projects-Facilities Account Number 150.75.560.30 10 Year Financial Trend $1,000,000 FY25 proposed roof project is for the flat roof at Village Hall $800,000 including replacement of roof membrane($440k),repair and $600,000 Solution including of the Police roof($400k),also roof replacments at 4 Metra warming shelters($60k). $400,000 $200,000 $- ' Y Y ..""I Y ....Y I ....I o �..I, N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ - $ 30,000 $ 354,000 $ 105,000 $ 250,000 $ 739,000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 900,000 $ 250,000 $ 50,000 $ 50,000 $ 50,000 $ 1,300,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 500,000 $ 750,000 $ 1,000,000 $ 2,250,000 $ 1,300,000 $ 3,550,000 umum Page 24 of 104 Combined Area Fire Training Facility II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 1007 Category 1-Buildings and Grounds std� Priority 3-Sustaining Useful Life 20 Years Origination Major Maintenance User Department Fire Coordinator Fire r ————— ——— n-- n-- Current Budget $ Initial Proposal Date 2022 Design Work 2023 Project Work 2024 Location Combined Area Fire Training Facility Recurrence 2042 The CAFT was built in 1997 as a fire training location for area Asset Valuation $ 500,000 departments and was rebuilt in 2017.Maintenance is Last Deferred N/A Issue needed to keep the overall facility in good condition to be Last Incurred N/A used for fire training.The cost is split between the five member communities. Fund Capital Projects-Facilities Account Number 100.40.580.20 10 Year Financial Trend $1,000,000 $800,000 Solution Following the CAFT Facility updates in 2024,the site has only $600,000 programmed shoreline stabilization for 2025($40k). $400,000 $200,000 �0 oo am 0 N N N 0 N CD N N N O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ _ $ $ $ $ 865,000 $ 865,000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 40,000 $ $ $ $ - $ 40,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ _ $ $ 400,000 $ 400,000 $ 40,000 $ 44Q000 IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII� °� _��, Page 25 of 104 Electric Charging Stations II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 1008 Category 1-Buildings and Grounds Priority 3-Sustaining Useful Life 30Years Origination Major Maintenance � �M4 User Department IT Coordinator IT F Current Budget $ 10,000 Initial Proposal Date 2023 Design Work 2024 Project Work 2024 Location Village Facilities Recurrence 2043 Asset Valuation $ 1,000,000 Last Deferred 2023 Electric Charging Stations are being requested at six Village ISSU2 Last Incurred 0 facilities. Fund Capital Projects-Facilities Account Number 150.75.560.30 10 Year Financial Trend $12,000 .., $10,000 The Village has not received any grants to support this $8,000 Solution endevor but will continue to apply and look for $6,000 opportunities. $4,000 $2,000 .., $ � 0 M � V1 l0 I� W Q1 N N N N N N N N O O O O 0 O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ $ $ $ $ $ Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 50,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 $ 50,000 $ 20Q000 IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII� '� ��, Page 26 of 104 Unified Development Ordinance ��wlU�wlU�wlU�wlU�wlU�wlU� ��wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU� Project# 1009 Category 1-Buildings and Grounds Priority 4-Contributory Useful Life 10 years Origination Planning Tool User Department Community Development Coordinator Community Development g Current Budget $ 80,000 Initial Proposal Date 2022 Design Work 2024 Project Work 2024 Location Village Ordinance Recurrence As Needed Asset Valuation N/A '.The Village Board and staff have set a goal to create a Last Deferred N/A Issue Unified Development Ordinance. Last Incurred 0 Fund General Fund Account Number 150.75.560.30 10 Year Financial Trend Completing this task would fulfill goals and recommendations in both the Economic Development Plan $100,000 and the Village's Strategic Plan.This is a multi-year project $80,000 that would begin in late-2024.The Unified Development $60,000 SOIUtIOn Ordinance combines and integrates content from the Zoning,Subdivision,and Sign Ordinances into one-user $40,000 friendly document that would implement the $20,000 Comprehensive Plan. O N m a n �0 00 m O 0 0O0 N N N N 000 O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ _ $ _ $ _ $ _ $ _ $ _ Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 80,000 $ 40,000 $ $ $ $ 120,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ - $ 40,000 $ $ 40,000 $ 120,000 $ 16Q000 umum Page 27 of 104 Police Headquarters II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 1010 Category 1-Buildings and Grounds Priority 4-Contributory ` i Useful Life 20 Years �n i lip rowvEmwuimi�wrm�l�➢io"'�"� ��r Origination Major Maintenance User Department Police „ Coordinator PW -° - Current Budget $ 556,000 °� °�` � Initial Proposal Date 2019 Design Work 2026 Project Work 2024 Location Police Headquarters Recurrence 2043 Asset Valuation u Police Headquarters was originally built in 1988,with the Last Deferred 2019-2023 Issue last major addition in 1997.Major maintenance and Last Incurred 2022 remodeling are needed but are frequently delayed. Fund Capital Projects-Facilities Account Number 150.75.560.30 10 Year Financial Trend Proposed 2025 projects include the an illuminated POLICE sign above the main entrance($10k);heating issues in front $14,000,000 lobby necessary to serve as warming shelter($40k);main $12,000,000 level bathroom stall replacement($7k);Interlock system $10,000,000 sOlUtlOn $ ,000,000 repair/replacement($9k);new A/V equipment for training 6 $6,000,000 room($15k);life safety improvements($475k).A major $4,000,000 renovation/building addition is proposed in 2027,with $2,000,000 design starting in 2026. $_ .... �� ...., M 'T V1 lb 00 0) 0 N N N N 0 0 0 0 N O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ _ $ $ 50,000 1 $ 50,000 1 $ 160,000 1 $ 260,000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 556,000 $ 997,500 $ 13,300,000 $ - $ - $ 14,853,s00 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ - $ 200,000 $ - $ 200,000 $ 14,853,500 $ 15,053,500 umum Page 28 of 104 Fire Station #26 Addition/Remodel II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 1011 Category 1-Buildings and Grounds Priority 3-Sustaining Useful Life 20 Years Origination Major Maintenance User Department Fire Coordinator Fire Current Budget $ 589,000 aroumv m Initial Proposal Date 2019 — ---- m. Design Work 2025 Project Work 2026 Location Fire Station 26 Recurrence 2042 Fire Station 26 was built in 1980 and has been remodeled a Asset Valuation $ 3,202,902 number of times since 1993.Two space needs assessments Last Deferred 2019-2023 Issue defined the need for renovated and additional space.A new Last Incurred N/A space needs assessment is warranted and a new remodel program needs to be redeveloped. Fund Capital Projects-Facilities Account Number 150,75,560.30 10 Year Financial Trend $8,000,000 A major renovation is proposed for design in 2025($589k). $6,000,000 Solution $7.6 million is proposed for construction in 2026 for the $4,000,000 station. $2,000,000 $ �� O ci N M � u'1 LD I, W Ol N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ _ $ _ $ _ $ _ $ _ $ _ Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term Fs 589,000 $ 7,600,000 $ $ $ - $ 8,189,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ _ $ - $ 250,000 $ 250,000 $ 8,189,000 $ 8,439,000 Page 29 of 104 Public Works Facility ��wlU�wlU�wlU�wlU�wlU�wlU� ��wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU� Project# 1012 Category 1-Buildings and Grounds - ` ! Priority 2-Essential ° Useful Life 50 Years Origination New User Department PW Coordinator PW Current Budget $ Initial Proposal Date 2007 Design Work 2023 Project Work 2024 Location 1650 Leider Lane Recurrence 2062 Asset Valuation $ 6,656,826 The Public Works Department has outgrown its existing Last Deferred N/A Issue facility and a new site was purchased in 2022,followed Last Incurred 2022 closely by design and construction. Fund Capital Projects-Facilities Account Number 150.75.560.30 10 Year Financial Trend $15,000,000 Remodeling completed in 2024. Longterm maintenance $10,000,000 Solution costs include possible roof repairs/replacement;HVAC maintenance&repairs/replacement $5,000,000 $- ...'mAl , mm mmm�xmimmm�xmimmmw�xmimm....I O c-I N M I VI l0 n W M N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ $ $ 13,450,000 $ 5,909,136 $ 14,258,844 $ 33,617,980 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ $ $ _ $ - $ 100,000 $ 100,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 300,000 $ 100,000 $ 250,000 $ 650,000 $ 100,000 $ 75Q000 umum Page 30 of 104 Village Hall ��wlU�wlU�wlU�wlU�wlU�wlU� ��wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU� Project# 1013 Category 1-Buildings and Grounds Priority 4-Contributory 1 Useful Life 20 Years Origination Major Maintenance User Department OVM r Coordinator PW Current Budget $ ........... ....... ,h. ,h h h h, ,h...... Initial Proposal Date 2005 Design Work 2024 Project Work 2024 Location Village Hall Recurrence 2042 Asset Valuation $ 3,626,916 Village Hall was built in 1970 and underwent major Last Deferred 2019-2023 Issue renovations in 1988 and 1993.A major renovation is needed Last Incurred N/A in the near future. Fund Capital Projects-Facilities Account Number 150.75.560.30 10 Year Financial Trend $10,000,000 $8,000,000 Solution A major remodel is proposed in 2028 for$7.7 million with $6,000,000 design starting in 2027($597k) $4,000,000 $2,000,000 N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ $ $ - $ 20,000 $ $ 20,000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ $ $ 596,750 $ 7,700,000 $ $ 8,296,7s0 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ $ $ - $ - $ 8,296,750 $ 8,296,7s0 umum Page 31 of 104 Fire Station #25 Rebuild II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 1014 Category 1-Buildings and Grounds Priority 3-Sustaining Useful Life 40 Years e Origination Major Maintenance User Department Fire Coordinator Fire Current Budget $ 10,800,000 Initial Proposal Date 2019 Design Work 2022 Project Work 2024 Location Fire Station 25 Recurrence 2063 Asset Valuation $ 1,813,050 The station was built in 1972 and the surrounding Last Deferred 2019-2023 infrastructure was built before that.It had major Last Incurred N/A Issue renovations in 1992,1997,2004 and is in need of a major remodel/renovation. Fund Capital Projects-Facilities Account Number 150.75.560.30 10 Year Financial Trend $12,000,000 $10,000,000 The design of a major renovation to Fire Station 25 was $8,000,000 Solution started in 2022.Construction is proposed to start in 2025 at $6,000,000 a cost of$10.8 million. $4,000,000 $2,000,000 $ .... �� O c-I N M � V1 tD I� W Ol N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ - $ $ 36,000 $ 150,000 $ 882,400 $ 1,068,400 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 10,800,000 $ $ - $ - $ - $ 10,800,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ - $ $ 250,000 $ 250,000 $ 10,800,000 $ 11,05Q000 umum Page 32 of 104 Pace/Metra Facility II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 1015 Category 1-Buildings and Grounds Priority 4-Contributory -mumrur�narmawxs Useful Life 15 Years rcwaeuma,.aaw�:..a� ,, " sT k? / Origination Major Maintenance User Department PW i Coordinator PW r�ir�irrAa� � . Current Budget $ 290,000 Initial Proposal Date 2020 Design Work 2022 Project Work 2024 Location Metra Train Station Area Recurrence 2037 Asset Valuation $ 4,500,000 Ongoing maintenance of the Pace/Metra facility is needed Last Deferred 2023 Issue to parking lots,grounds,and buildings.With less commuters Last Incurred N/A post Covid parking lot removal is anticipated. Fund Metra Parking Fund Account Number 120.81.535.25 10 Year Financial Trend For 2025,Funds are requested for engineering,design and $350,000 construction services associated with parking lot removal $300,000 and detention area work($250k),further improvements to $250,000 $200,000 Solution the current camera security system($20k),and $150,000 sealcoating/striping activities in drives and parking lots $100,000 ($20k) $50,000 N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ - $ - $ - $ $ 20,000 $ 2Q Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 290,000 $ 40,000 $ 20,000 $ $ - $ 350,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 40,000 $ 40,000 $ 60,000 $ 140,000 $ 350,000 $ 49Q000 umum Page 33 of 104 Outdoor Warning Siren Upgrades/Replacements II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 1019 IIIIIIIIpIIIIpIIIIIIIIIIIVIIIIpllllpllllllllplllplllllpllllllpllllpllllplllltpllllpllllpllllllllllpllllpllllpllllpllllpllllpllll jllpllllllllllllllllllllllplllllpllllpllllpllllplllllllljll �L Category 1-Buildings and Grounds Priority 4-Contributory i r / Useful Life 30 Years Origination Major Maintenance User Department Fire a Coordinator Fire Current Budget $ 30,000 . „.,. Initial Proposal Date 2021 Design Work N/A Project Work 2024 Location Various Locations Recurrence 2053 Asset Valuation $ 250,000 The Village has 7 outdoor warning sirens that are reaching Last Deferred N/A Issue the end of their expected thirty year life cycles. Last Incurred N/A Fund Capital Projects-Facilities Account Number 150.75.560.30 10 Year Financial Trend $35,000 .., $30,000 ,000 Solution multi-year plan to replace/upgrade started in 2022 to $2$25,000 replace them at a 30 year service life cycle. $15,000 $10,000 .. $5,000 $ O c-I N m V1 to I, oo M N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ - $ $ 12,500 $ 30,000 $ $ 42,500 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 30,000 $ $ 30,000 $ 30,000 $ $ 90,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 60,000 $ 30,000 $ - $ 90,000 $ 90,000 $ 18Q000 umum Page 34 of 104 Water and Truck Weighing Station II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 1020 f Category 1-Buildings and Grounds Priority 4-Contributory I l® Useful Life 30 Years Origination Major Maintenance r User Department PW/PD Coordinator PW Current Budget $ ................ ...... Initial Proposal Date 2021 Design Work 2022 Project Work 2024 Location Deerfield Parkway and Krause Drive near C.A.F.T.Facility Recurrence 2053 Police and Public Works are proposing a central location for Asset Valuation N/A truck weight checks and water filling.The permanent scales Last Deferred N/A will allow Police to weigh trucks safely and efficiently,while ISSU2 potentially selling this service to other municipalities as well. Last Incurred N/A It also allows Public Works to have an efficient and easy to use water filline station to sell water in bulk to contractors Fund Water&Sewer Fund Account Number 170.55.35.560.60 10 Year Financial Trend $500,000 The design for the truck weighing station and water filling $400,000 Solution station was started in 2022.In 2024 the pull through and $300,000 water assembly will be constructed($400k)followed by the $200,000 addition of the truck scales in 2027($100k). $100,000 $- (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ $ $ 35,000 1 $ 15,000 1 $ 400,000 $ 450,000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ $ $ 100,000 $ 20,000 $ - $ 120,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 45,000 $ 50,000 $ 50,000 $ 145,000 $ 120,000 $ 265,000 umum Page 35 of 104 Village Entrance Signage II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 1021 Category 1-Buildings and Grounds Priority 4-Contributory Useful Life 30 Years ` Origination Replacement/New User Department Communications Coordinator Communications Current Budget $ 400,000 Initial Proposal Date 2024 Design Work 2024 Location Lake Cook Road,IL Routes 21,22 and 68,Buffalo Grove Project Work 2025 Road,Arlington Heights Road Recurrence 2055 Asset Valuation N/A Current signage is past its useful life and not in line with the Last Deferred N/A Issue updated Village Branding. Last Incurred N/A Fund Capital Projects-Facilities Account Number 150.75.560.30 10 Year Financial Trend Following the development of the Village's brand in late $500,000 2023 and early 2024,new entry monuments will be $400,000 designed this year($35k). Each location will be selected $300,000 Solution designed major roadways at the Village's border.For consistency across all signage it is recommended all 12 $�00,000 locations be installed by one vendor in one project($400k). $100,000 O N m a n �0 00 m O 0 0O0 N N N N 000 O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ _ $ $ $ $ 35,000 $ 35,000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 400,000 $ $ $ $ - $ 400,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 $ 400,000 $ 70Q000 umum Page 36 of 104 Clove Park ��wlU�wlU�wlU�wlU�wlU�wlU� ��wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU� Project# 1022 �� T *' Category 1-Buildings and Grounds � " Priority 4-Contributory �ivy� � ,� Useful Life 50 Years Origination New rf / User Department Community Development ° Coordinator Community Development /,� �a/i,.,, ic� ��.. //, o Current Budget $ 25,000 Initial Proposal Date 2024 Design Work 2024 Location Project Work 2026 The Clove Recurrence 2076 Asset Valuation N/A Within the Clove development the Village now owns and Last Deferred N/A Issue maintains an acre park for its use. Design,planning and Last Incurred N/A programming is set to begin in 2024. Fund TIF Account Number N/A 10 Year Financial Trend $2,000,000 In 2025 the Village intends to employ a landscape architect to conceptualize the Clove Park($25k),followed by detailed $1,500,000 Solution design in 2026($1501k). The Village will seek grants for the $1,000,000 construction but currently estimates costs around$1.5 million. $500,000 N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ _ $ _ $ _ $ _ $ _ $ _ Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 25,000 $ 150,000 $ 1,500,000 $ $ $ 1,675,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 20,000 $ 65,000 $ 200,000 $ 285,000 $ 1,675,000 $ 1,96Q000 umum Page 37 of 104 Village Green II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 1023 Category 1-Buildings and Grounds Priority 4-Contributory Useful Life 50 Years Origination New User Department Public Works Coordinator Public Works 'wV � i u i I�IOiV�ulNu�ll u uu�u u u Current Budget $ 76,000 Initial Proposal Date 2024 ...... Design Work N/A Location Project Work 2024 Village Rotary Green Recurrence 2076 Asset Valuation $ 2,000,000 Significant repairs are needed at the Village Green along Last Deferred N/A with an overall"refresh"of the Green that reflects the new ISSU2 branding of the Village as well as the development of the Last Incurred N/A Clove adjacent to the park. Fund Capital Projects-Facilities Account Number 150.75.560.30 10 Year Financial Trend Replacement of the structural columns is needed to support the roof($2k);Roof replacement including water damaged $80,000 areas of decking along with new flashing&gutters($25k); $60,000 complete painting of the structure including brick work to SOIUtIOn match the Clove($5k);painting all lamp poles($25k); $40,000 removal,leveling and reinstalltion of brick pavers($6k); $20,000 walking path repairs and sealcoating of asphalt path($7k); new illuminated park sign($61k) $- ....... mm I O M �t V1 W W Q1 N N N N N N N N O O 0 0 O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ _ $ $ $ $ $ Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 76,000 $ $ $ $ $ 76,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ - $ $ $ $ 76,000 $ 76,000 umum Page 38 of 104 Buffalo Creek Greenway Planning & Stormwater Management ��wlU�wlU�wlU�wlU�wlU�wlU� ��wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU� Project# 1024 .- Category 4-Storm Water Management �h %�i42 Priority 3-Sustaining /'o Useful Life 100Years Origination New User Department Public Works Coordinator Public Works s p Current Budget $ 1,050,000 Initial Proposal Date 2024 Design Work 2024 Location Buffalo Creek Area Project Work 2034 Recurrence 2076 Asset Valuation $ 75,000,000 The confluence of Buffalo Creek,Farrington Ditch and White Last Deferred N/A Issue Pine Ditch contributes to the most significant structure Last Incurred N/A flooding in the Village. Fund General Fund Account Number 160.75.560.20 10 Year Financial Trend $1,200,000 Through a cooperative effort of Stormwater Management $1,000,000 Engineering and Landscape Architect the Buffalo Creek area $800,000 Solution can achieve form and function. This effort will be strategic, $600,000 over a number of years,optimizing external funding and $400,000 land use of the area. $ rv .... �0 oo am 0 N N N 0 N CD N N N O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ _ $ _ $ _ $ _ $ _ $ _ Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 1,050,000 $ 250,000 $ 100,000 $ $ $ 1,400,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 50,000,000 $ $ - $ 50,000,000 $ 1,400,000 $ 51,400,000 umum Page 39 of 104 Emergency Operations Center (EOC) II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 1025 t Category 1-Buildings and Grounds �i EST2 , Priority 2-Essential Useful Life 50 Years 1A �J Origination New User Department All Departments Coordinator Public Works Current Budget $ 228,533 Initial Proposal Date 2023 Design Work 2024 Location Public Service Center/Village Hall Project Work 2025 Recurrence 2075 The Village has been awarded$171,400 in Feder grant funds Asset Valuation $ 500,000 from the FFY24 Emergency Operations Center(EOC)grant Last Deferred N/A Issue program. This work requires a$57,133 local match and Last Incurred N/A must be used in the next 36 months. Fund Capital Projects-Facilities Account Number 150.75.560.30 10 Year Financial Trend $250,000 Design of the area will begin in late 2024 and continue $200,000 Solution through 2025. Construction will occur as soon as design $150,000 permits. $100,000 $50,000 $ O N m a n �0 00 m O 0 0O0 N N N N 000 O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ _ $ _ $ _ $ _ $ _ $ _ Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 228,533 $ $ 50,000 $ $ 50,000 $ 328,533 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ - $ $ - $ $ 328,533 $ 328,533 umum Page 40 of 104 Buffalo Grove Golf Course Improvements ��wlU�wlU�wlU�wlU�wlU�wlU� ��wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU� Project# 2001 Category 1-Buildings and Grounds Priority 4-Contributory Useful Life 20Years �V Origination Major Maintenance User Department Golf Coordinator Golf Current Budget $ 169,000 Initial Proposal Date 2018 ssss .11111 Design Work 2024 Project Work 2024 Location Buffalo Grove Golf Course Recurrence 2042 Asset Valuation N/A At the Buffalo Grove Golf Course,the major infrastructure Last Deferred N/A Issue needing upgrades includes cart paths,parking lot repairs, Last Incurred 2022 patio reconstruction and HVAC system replacement. Fund Golf Fund Account Number 190.84.535.40 10 Year Financial Trend $200,000 Proposed 2025 projects are parking lot improvements $150,000 Solution ($44k); cart path repairs($100k-ongoing);patio $100,000 replacement($25k) $50,000 $- O N N m c Ln In r, m m N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ - $ 10,270 $ 115,000 $ 140,000 $ 144,000 $ 409,270 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 169,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 569,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 500,000 $ 600,000 $ 600,000 $ 1,700,000 $ 569,000 $ 2,269,000 umum Page 41 of 104 Arboretum Golf Course Improvements ��wlU�wlU�wlU�wlU�wlU�wlU� ��wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU� Project# 2002 �� Cate or 1-Buildings and Grounds jPriority 4-Contributory Useful Life 20 Years Origination Major Maintenance User Department Golf f Coordinator Golf r Current Budget $ 336,000 „,-----, ,-- �.�. , .�, ,,� � „,�,— ,- - Initial Proposal Date 2018 Design Work 2024 Project Work 2024 Location Arboretum Golf Course Recurrence 2042 Asset Valuation N/A At Arboretum Golf Course,the major infrastructure needs Last Deferred N/A Issue include irrigation work,sand trap reconstruction,and Last Incurred 2022 dredging of waterways. Fund Golf Fund Account Number 190.84.535.40 10 Year Financial Trend $1,000,000 In 2025,work includes replacement/repair of cart paths $800,000 ($100k-ongoing),irrigation nozzle replacement($11k),and Solution 3 controller satellite replacement($45k),bunker,hole and $600,000 tee restoration and/or redesign($180k).This bunker/hole $400,000 work is also proposed in 2026 ($85k)and 2027($85k). $200,000 N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ - $ 17,000 $ 795,000 $ 20,000 $ 336,000 $ 1,168,000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 336,000 $ 95,000 $ 85,000 $ 85,000 $ 85,000 $ 686,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 736,000 $ 600,000 $ 750,000 $ 2,086,000 $ 686,000 $ 2,772,000 umum Page 42 of 104 Annual Sidewalk Maintenance ��wlU�wlU�wlU�wlU�wlU�wlU� ��wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU� Project# 3001 ,., Category 3-Street,Sidewalk&Bike path Priority 3-Sustaining Useful Life 30 Years Origination Major Maintenance User Department Engineering min 941 Coordinator Engineering Current Budget $ 300,000 Initial Proposal Date Ongoing Design Work Yearly Project Work Yearly Location Road Right of Ways Recurrence Yearly Asset Valuation $ 18,000,000 The Village maintains a large sidewalk system that promotes Last Deferred 2022 safe and accessible passage around town for our residents.A Issue Last Incurred 2024 maintenance program helps keep these facilities in compliance with ADA accessible guidelines. Fund Capital Projects-Streets Account Number 160.75.560.20 Fund Code MFT Eliglbe 10 Year Financial Trend $600,000 The Village's policy is to replace or repair as many sidewalks $500,000 Solution as funding,time and manpower permits at its own $400,000 discretion every year($300k replacement). $300,000 $200,000 $100,000 O ci N M � u'1 1p h O] Ol N N N N N N N N N N 0 0 0 0 0 0 0 0 0 0 N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ 198,030 $ 175,300 $ 350,000 $ 541,000 $ 254,000 $ 1,518,330 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term Fs 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 1,500,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 1,500,000 $ 1,500,000 $ 1,500,000 $ 4,500,000 $ 1,500,000 $ 6,000,000 Category: Sidewalks and Bike Paths Notes: *The Village has an extensive pedestrian/biking system that requires yearly maintenance *Grant funding may be available to help reduce Village funds needed to maintain the sidewalk and bike paths *Maintaining these facilities will help keep the Village's facility rating at a consistant level Page 43 of 104 Annual Bike Path Maintenance Project# 3002 Category 3-Street,Sidewalk&Bike path Priority 3-Sustaining Useful Life 30 Years Origination Major Maintenance User Department Engineering Coordinator Engineering Current Budget $ 100,000 Initial Proposal Date Ongoing Design Work Yearly Project Work Yearly Location Village Right of Way Recurrence Yearly The Village has a large bike path system that requires Asset Valuation $ 9,000,000 maintenance to provide safe and accessible facilities Last Deferred 2021 Issue throughout Buffalo Grove.A maintenance program helps Last Incurred 2024 maintain compliance with ADA accessible guidelines and provides a safe and passable system for Village residents. Fund Capital Projects-Streets Account Number 160,75,560.20 10 Year Financial Trend $120,000 $100,000 The Village's policy is to replace or repair as many bike paths $8D,000 Solution as funding,time and manpower permits at its own $60,000 discretion($1001k). $40,000 $20,000 N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ - $ - $ 25,000 $ 75,000 $ 70,000 $ 170,000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term Fs 100,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 500,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 500,000 $ 500,000 $ 500,000 $ 1,500,000 $ 500,000 $ 2,000,000 Category: Sidewalks and Bike Paths Notes: *The Village has an extensive pedestrian/biking system that requires yearly maintenance *Grant funding may be available to help reduce Village funds needed to maintain the sidewalk and bike paths *Maintaining these facilities will help keep the Village's facility rating at a consistant level Page 44 of 104 Weiland/Prairie Road Improvements II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 3006 Category 3-Street, Side walk path r r hr Priority 1-Mandatory if Useful Life 20 Years Origination Major Maintenance User Department Engineering Coordinator Engineering c i " Current Budget $ Initial Proposal Date 2008 Design Work 2008-2018 Project Work 2019-2022 Location Lake County Right of Way Recurrence 2024 Asset Valuation N/A The Lake County Department of Transportation has recently Last Deferred N/A Issue completed the Weiland Road widening project and is now Last Incurred 2022 proposing improvements to Prairie Road in 2024 Fund Capital Projects-Streets Account Number 160.75.560.20 Fund Code MFT Eliglbe 10 Year Financial Trend The Village is responsible for a local share of the cost for $600,000 such items as pedestrian facilities,street lights,and traffic $500,000 Solution signals.Prairie Road is proposed to be repaired in 2026 with $400,000 the costs split over two years in 2026 and 2027($500k per $300,000 year)and includes a water main connection across Aptakisic $200,000 Road. $100,0 00 .... ATI O ci N m �t V1 LD CO m N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ 400,000 $ - $ 43,000 $ $ $ 443,000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ - $ 500,000 $ 500,000 $ $ $ 1,000,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ $ _ $ _ $ $ 1,000,000 $ 1,000,000 umum Page 45 of 104 Annual Street Maintenance II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I� Project# 3003 n �I Category 3-Street,Sidewalk&Bike path Priority 3-Sustaining y"W yn Useful Life 20 Years Origination Major Maintenance User Department Engineering n ��d Coordinator Engineering i Current Budget $ 8,116,000 W;• Initial Proposal Date Ongoing u�Fl a Gn .o,xPM Design Work Yearly Project Work Yearly Location Village Right of Way Recurrence Yearly 'Maintenance of the Villages streets is a core function of the Asset Valuation $ 190,080,000 Last Deferred 2022 Public Works Department.A proper maintenance program 155Ue Last Incurred 2024 keeps the streest in optimum condition for the full extent of their lifespan Fund Capital Projects-Streets Account Number 160.75.560.20 Fund Code 2020 GO FY22 STIR The annual street maintenance and rehabilitation program is a central piece of the annual CIP. Streets are reviewed 10 Year Financial Trend annually and evaluated for several strategies of maintenance or improvement.Patching($400k),pavement $20,000,000 Solution striping($100k),crack sealing($50k),preservation($100k), $15,000,000 the Northwood Improvement project($4.2M),Mill Creek Phase 1($30011 a widespread resurfacing project($2.6M) $10,000,000 and design/management efforts($930k). There is approximately$40 million in backlogged street work which $5,000,000 � is proposed at$8 million per year for 5 years. O N N M � u'1 lD h W O1 N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ 4,753,000 1 $ 3,500,000 1 $ 1,167,000 1 $ 525,000 1 $ 675,000 1 $ 10,620,000 2025 2026 2027 2028 2029 Short Term Financial Impact Short Term $ 16,116,000 1 $ 8,000,000 $ 8,000,000 1 $ 8,000,000 1 $ 8,000,000 1 $ 4s,116,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 22,500,000 1 $ 22,500,000 1 $ 22,500,000 1 $ 67,500,000 1 $ 48,116,000 1 $ 115,616,000 Category: Roads Notes: *The Village invests significantly in the roads every year as funding is available *The Village has been able to successfully leverage significant grant funding to help maintain the Village's roads *Significant funding over time can maintain the rating while additional funding can improve this score llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll''°'. ,,, Page 46 of 104 Collector Route Maintenance & Rehabilitation Projects II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 3004 Category 3-Street,Sidewalk&Bike path Priority 3-Sustaining Useful Life 20 Years Origination Major Maintenance - User Department Engineering Coordinator Engineering Current Budget $ 9,350,000 Initial Proposal Date 2017 Design Work 2022 Project Work 2022-2025 Location Village Right of Way Recurrence Yearly Asset Valuation N/A The Villages streets need to be maintained on a reoccurring Last Deferred N/A Issue basis.These collector routes have the possibility of receiving Last Incurred 2024 federal funding. Fund Capital Projects-Streets Account Number 160.75.560.20 Fund Code MFT Eliglbe 10 Year Financial Trend The Village has several collector routes that are eligible for Federal reimbursement for design and construction.Bernard $10,000,000 Drive began the Phase II process in 2021 with$350k in grant $8,000,000 Solution funding and will continue through the various phases of $6,000,000 construction. Phase II will continue in 2025($9.1M-$5.OM $4,000,000 STP and$1.8M ITEP),as well as starting Checker Drive Phase I $2,000,000 ($250k). O N N M I u'1 10 I, W M N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ 1,800,000 $ 3,350,000 $ 3,300,000 $ 350,000 $ 4,300,000 $ 13,100 000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term Fs 9,350,000 $ 250,000 $ 250,000 $ 250,000 $ 4,000,000 $ 14,100,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 5,150,000 $ 1,250,000 $ 1,250,000 $ 7,650,000 $ 14,100,000 $ 21,750,000 Category: Roads Notes: *The Village invests significantly in the roads every year as funding is available *The Village has been able to successfully leverage significant grant funding to help maintain the Village's roads *Significant funding over time can maintain the rating while additional funding can improve this score Page 47 of 104 L Lake Cook Road Improvement II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 3005 Category 3-Street,Sidewalk&Bike path Priority 1-Mandatory Useful Life 20 Years i Origination Major Maintenance User Department Engineering �� r,� � ,�„ 6 „�� G�i r , �i�rr � r ✓ Coordinator Engineering Current Budget $ 535,000 Initial Proposal Date 2022 Design Work 2022-2024 Project Work 2032 Location Cook County Right of Way Recurrence 2052 The Cook County Highway Department is responsible for Asset Valuation N/A Lake Cook Road in the Village of Buffalo Grove.The Village is Last Deferred N/A Issue leading the Phase 1 Engineering Study of Lake Cook Road Last Incurred 2022 from Raupp Blvd.to Arlington Heights Road which will last for three to four years. Fund Capital Projects-Streets Account Number 160.75.560.20 Fund Code MFT Eliglbe 10 Year Financial Trend $600,000 The Village has received a$500k Invest in Cook Grant to $500,000 Solution start the phase 1 for widening of Lake Cook Road to the west $400,000 of Raupp Blvd to Arlington Heights Road($1.61 millions split $300,000 over four years). $200,000 .... .... V $100,000 N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ 370,000 $ 265,000 $ 282,000 $ 250,000 $ 535,000 $ 1,702,000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term Fs 535,000 $ 535,000 $ 330,000 $ - $ - $ 1,400,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 5,000,000 $ $ - $ 5,000,000 $ 1,400,000 $ 6,400,000 Page 48 of 104 Municipal Parking Facility Maintenance II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 3007 Category 3-Street,Sidewalk&Bike path Priority 3-Sustaining i Useful Life 20Years r GYn� Origination Major Maintenance User Department Engineering Y Coordinator Engineering Current Budget $ 70,000 ................ ............. Initial Proposal Date Ongoing Design Work Yearly Project Work Yearly Location Village Parking Lots Recurrence Yearly Asset Valuation $ 2,500,000 Routine maintenance of municipal parking facilities such as '.seal coating,patching,reconstruction and restriping is Last Deferred N/A Issue needed to maintain the Village's parking lots in a safe and Last Incurred 2019 economical way while extending their useful life cycle. Fund Capital Projects-Facilities Account Number 160.75.560.20 10 Year Financial Trend $80,000 .., In 2025 funding is requested for sealcoating and restriping $60,000 on the municipal campus($25k)Fire Station#26($5k) Solution on Golf Course($181K),and resurfacing at Fire $40,000 Station#27($22k) $20,000 O ci N M � V1 lD h 00 Ol N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ 45,150 $ $ - $ 43,000 $ - $ 88,150 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 70,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 270,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 325,000 $ 340,000 $ 350,000 $ 1,015,000 $ 270,000 $ 1,285,000 OMINotes: Category: Parking Lots *The Village parking lots are in slightly below average shape and are typically tied to the Village facilities *Replacing or major repairs of Village facilities will also include parking lot improvements *Maintaining these facilities will help keep the Village's facility rating at a consistent level umum Page 49 of 104 Buffalo Grove Road Improvement II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 3008 Category 3-Street,Sidewalk&Bike path Priority 1-Mandatory I Useful Life 20 Years Origination Major Maintenance User Department Engineering Coordinator Engineering Current Budget $ Initial Proposal Date 2020 Design Work 2023 Project Work 2025-2026 Location County Right of Way Recurrence 0 Asset Valuation N/A The Lake County Department of Transportation is proposing widening from Route 22 to Route 45 in 2026-2027. Last Deferred N/A Issue Additionally Cook County will reconstruction south of Lake Last Incurred 2022 Cook in 2027-2028 in connection with Village utility work. Fund Capital Projects-Streets Account Number 160.75.560.20 Fund Code MFT Eliglbe 10 Year Financial Trend $6,000,000 The Village is responsible for a local share of the cost for $5,000,000 such items as pedestrian facilities,street lights,and traffic $4,000,000 Solution signals. CCDOTH will reconstruct Buffalo Grove Road south $3,000,000 of St.Marys starting in 2027. $2,000,000 $1,000,000 $- , O ci N M � u'1 Ln I, W M N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ 479,600 $ 480,000 $ 485,000 $ - $ $ 1,444,600 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ - $ 400,000 1 $ 5,000,000 $ 5,000,000 1 $ $ 10,400,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ $ $ _ $ $ 10,400,000 $ 10,400,000 Page 50 of 104 Arlington Heights Road Improvement II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 3009 Category 3-Street,Sidewalk&Bike path M ,/,// o/f,,i, , ;// r, � � �•%� Priority 1-Mandatory Useful Life 20 Years Origination Major Maintenance artment User De Engineering P Coordinator Engineering A% Current Budget $ 329,094 Initial Proposal Date 2021 Design Work 2023 Project Work 2024 Location County Right of Way Recurrence 2044 Asset Valuation N/A The Lake County Highway Department of Transportation is Last Deferred N/A Issue planning on improving Arlington Heights Road from Lake Last Incurred 2024 Cook Road to Route 83. Fund Capital Project-Facilities Account Number 160.75.560.20 10 Year Financial Trend $350,000 The Village is responsible for a local share of the cost for $300,000 such items as pedestrian facilities,street lights,and traffic $250,000 Solution signals.The local share is approximately$660k,half paid in $200,000 each year of 2024 and 2025. Water main programmed $150,000 seperately. $100,000 $50,000 N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ _ $ $ $ $ 329,094 $ 329,094 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 329,094 $ $ $ $ - $ 329,094 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ _ $ $ $ $ 329,094 $ 329,094 umum Page 51 of 104 Aptakisic Road Improvement II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�II n PROJECT LOCATION ,:; Project# 3010 Category 3-Street,Sidewalk&Bike path k d° Priority 1-Mandatory LOGATI T 4ry aPATIO i Useful Life 20 Years r, Origination Major Maintenance User Department Engineering Coordinator Engineering �� (» Current Budget $ (120,000) ^ i Initial Proposal Date 2019 Design Work 2022 iiyA��JJJJJJJJJJJJJJJJJJJJJyJJy1JyJJyJJyJJyJJyJJyJJyJJyJJyJJyJJyJJyJJyJJyJJyJJyJJyJJyJJyJJyJJJJyJJyJJyJJyJJyJJyJJyJJy�)y Project Work 2024 Location Lake County Right of Way Recurrence 2044 Asset Valuation N/A The Lake County Highway Department of Transportation is Last Deferred N/A Issue planning on improving Aptakisic Road from Route 83 to Last Incurred 2024 Buffalo Grove Road. Fund Capital Project-Facilities Account Number 160.75.560.20 10 Year Financial Trend The Village is responsible for a local share of the cost for $500,000 such items as pedestrian facilities,street lights,and traffic $400,000 Solution signals.The local share was estimated to be$433k,which $300,000 was paid at the start of the job. Due to adjustments in the $200,000 work,the Village will only about$300k-depending on final $100,000 quantities,so a credit will be due at the end. $_ ...,.� o N m a M W n or m S(100,000) 8 8. 8 a a.. a 2 8 N N N N N N N N N N S(200,000) (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ $ $ $ 433,172 1 $ $ 433,172 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ (120,000) $ I $ I $ $ I $ (120,000) Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ $ $ $ $ (120,000) $ (120,000) umum Page 52 of 104 Median and Street Scalping Improvements II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 3011 Category 3-Street,Sidewalk&Bike path Priority 4-Contributory Useful Life 20 Years Origination Major Maintenance User Department Engineering Coordinator Engineering Current Budget $ - fi�� Initial Proposal Date 2021 Design Work 2024 Project Work 2024 Location State,County or Village Right of Ways Recurrence Yearly Asset Valuation N/A Last Deferred The medians and road right-of-ways need regular 23 ISSU2 maintenance and beautification Last Incurred N/A Fund Capital Project-Facilities Account Number 160.75.560.20 10 Year Financial Trend $250,000 The Village is creating a native landscape vegetation $200,000 Solution management plan for improving and maintaining medians $150,000 around the Village($40k)in 2025 and 2026($30k). $100,000 $50,000 �0 00 m N N N O 0 0 N N N O O 0 0 O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ - $ - $ $ 210,000 $ $ 210,000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 40,000 $ 30,000 $ $ - $ $ 70,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 60,000 $ 100,000 $ 90,000 $ 250,000 $ 70,000 $ 32Q000 umum Page 53 of 104 L Street Light LED Conversion II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 3012 Category 3-Street,Sidewalk&Bike path Priority 4-Contributory Useful Life 20 Years jj Origination Major Maintenance g User Department Engineering Coordinator Engineering Current Budget $ Initial Proposal Date 2022 Design Work 2024 Project Work 2024 Location State or County Right of Ways Recurrence 2042 The Village has converted all of the street lights on local Asset Valuation $ 23,854,665 Last Deferred 2022 streets.The street lights on other agency roads still need to ISSU2 be replaced with LED light bulbs which reduce energy and Last Incurred N/A maintenance costs Fund Capital Project-Facilities Account Number 160.75.560.20 10 Year Financial Trend $300,000 $250,000 The Village is proposing to replace all of the High Pressure $200,000 Solution Sodium lights with LED lights on other agency roads within $150,000 the next three years. $100,000 .... .... $50,000 N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ $ $ $ $ $ Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 240,000 $ 65,000 $ 210,000 $ $ $ 515,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 120,000 $ 140,000 $ 140,000 $ 400,000 $ 515,000 $ 915,000 Category: Street Lights Notes: *The Village street lights are an important aspect of the Buffalo Grove neighborhoods *All of the local streets and some of the larger roads'streetlights have been coverted to LED *Converting the remaining lights to LEDs and providing adequate maintenance will improve the rating Page 54 of 104 Deerfield Parkway Intersection Improvements ��wlU�wlU�wlU�wlU�wlU�wlU� ��wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU� Project# 3013 Category 3-Street,Sidewalk&Bike path Priority 1-Mandatory fL ?x f Useful Life 20 Years r Ql Origination Major Maintenance User Department Engineering Coordinator Engineering Current Budget $ Initial Proposal Date 2020 Design Work 2023 Project Work 2024 Location County Right of Way Recurrence 2044 Asset Valuation N/A The Lake County Highway Department of Transportation has Last Deferred N/A proposed improving the intersection of Milwaukee Avenue ISSU2 with the widening of Deerfield Road to the east of Buffalo Last Incurred N/A Grove which is scheduled for 2024. Fund Capital Projects-Streets Account Number 160.75.560.20 10 Year Financial Trend The Village is responsible for a local share of the cost for $350,000 such items as pedestrian facilities,street lights,and traffic $300,000 signals. LCDOT will widen and reconstruct Deerfield Road $250,000 Solution $ ,000 from Route 21 to Saunders Road starting in 2025,the Village $150o,000 is responsible for their modifications to street lights and $100,000 sidewalks($300k). $50,000 N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical ' Historical $ _ $ _ $ _ $ _ $ _ $ _ Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ $ 300,000 $ $ $ $ 300,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ $ $ $ $ 300,000 $ 300,000 umum Page 55 of 104 Stormwater System Improvements II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project#4001 mvnar�i�� ) ��Il��liuuuuuuuuudm iiVuiuui�m,8ip,^V4 Viiiifll{V°� �� i)ri ��.. '� iP 1111° Category 4-Storm Water Management liu Priority 2-Essential Useful Life 50 Years Origination Major Maintenance User Department Engineering Coordinator Engineering Current Budget $ 7,100,000 Initial Proposal Date Ongoing Design Work Yearly — — — -- � "�� ' �"�"`� Project Work Yearly Location Village Right of Way and easements Recurrence Yearly Asset Valuation $ 250,078,002 Last Deferred N/A Issue The storm sewer system requires annual maintenance. Last Incurred 2024 Fund General Fund Account Number 160.75.560.20 Fund Code 2020 GO FY22 STIR This program provides for an annual televising inspection 10 Year Financial Trend program,storm sewer lining,point repairs,and replacements at priority locations within the Village's storm $8,000,000 sewer network($100k).In 2025 the Village and Vernon $6,000,000 Solution Township are reciving a $5.5 million DCEO Grant from SMC for the Northwood/Horation Gardens Subdivision project $4,000,000 ($364 Project Expense Match).$1.0 million is for the $2,000,000 restoration and improvement of Bordeaux Ct,which has $550k in a DCEO grant N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ 260,600 $ 565,000 $ 500,000 $ 150,000 $ 200,000 $ 1,675,600 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term Fs 7,100,000 $ 655,000 $ 655,000 $ 100,000 $ 750,000 $ 9,260,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 2,450,000 $ 2,250,000 $ 2,250,000 $ 6,950,000 $ 9,260,000 $ 16,210,000 Category: Storm Sewer Notes: *The storm sewer and stormwater conveyance system in the Village is an important part of the infrastructure *The storm sewer maintenance fee provides additional funding to help maintain the system *Continuing to fund storm sewer improvements and maintain system will improve rating Page 56 of 104 Service Delivery Communication Software ��wlU�wlU�wlU�wlU�wlU�wlU� ��wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU� Project# 5004 Category 5-Technology a0 Priority 4-Contributory Useful Life 20 Years Origination New� f User Department PW , ��!�1 i Coordinator IT u; Current Budget $ 500,000 Initial Proposal Date 2021 Design Work 2022 Project Work 2024 Location Public Service Center Recurrence Yearly Asset Valuation N/A The Public Works Department desires to purchase a Last Deferred N/A program that improves communication for emergency ISSU2 service interruption that can also be used for all Village Last Incurred N/A communication purposes. Fund IT Fund Account Number 211.92.555.40 10 Year Financial Trend $600,000 $500,000 The Public Works Department is proposing to purchase a $400,000 Solution communication program that will meet the Village's $300,000 communication needs. $200,000 $100,000 N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ - $ - $ - $ - $ 100,000 $ 10Q Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 500,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 900,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 500,000 $ 500,000 $ 500,000 $ 1,500,000 $ 900,000 $ 2,40Q000 umum Page 57 of 104 Police Tasers II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 5005 Category 5-Technology Priority 2-Essential o� Useful Life 5 Years Origination New User Department Police Coordinator IT Current Budget $ Initial Proposal Date 2022 Design Work N/A Project Work 2024 Location Police Department and Officers Recurrence 2029 Asset Valuation $ 750,000 Tasers require routine replacement and maintenance,along Last Deferred N/A Issue with certification and training. They are estimated to have a Last Incurred N/A 5 year use period. Fund Supervision Fund Account Number 211.92.555.40 10 Year Financial Trend $200,000 Tasers and bodycams purchased in 2024. Ongoing software $150,000 Solution costs will be$133,660 annually with anticipated $100,000 replacements on a 10 year cycle. $50,000 N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ $ _ $ _ $ - $ 177,600 $ 177,600 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ $ 133,660 $ 133,660 $ 133,660 $ 133,660 $ 534,640 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 734,640 $ 668,300 $ 754,640 $ 2,157,580 $ 534,640 $ 2,692,220 umum Page 58 of 104 Police/Fire Mobile Devices II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 5006 `777" Category 5-Technology 0 Priority 2-Essential Useful Life 5 Years Origination Scheduled Upgrades User Department Police Coordinator IT Current Budget $ 120,000 Initial Proposal Date 2019 Design Work N/A Project Work 2024 Location Police Vehicles Recurrence 2025 Asset Valuation $ 120,000 Rugged laptops in the Police vehicles are on a 5 year Last Deferred N/A replacement schedule per the standards set by the GovIT ISSU2 Last Incurred 2013 Consortium. For 2025,Police and Fire needs several new mobile devices,cradle points and tough books($120,000) Fund Supervision Fund Account Number 211.92.555.40 10 Year Financial Trend $140,000 $120,000 There are 22 mobile laptops in Police vehicles that were $100,000 Solution purchased in 2020(with mostly grant funds)and are $80,000 replaced on a 5 year schedule. $60,000 $40,000 $20,000 N 0 O N 0 0 0 0 N N N O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ 114,000 $ $ $ $ 74,500 $ 188,500 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 120,000 $ $ $ $ - $ 120,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 125,000 $ 125,000 $ 125,000 $ 375,000 $ 120,000 $ 495,000 umum Page 59 of 104 Server and Hardware Replacements ��wlU�wlU�wlU�wlU�wlU�wlUl ��wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU� 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 N/A Project Work 2026 Location Village Network Recurrence 2026 Asset Valuation $ 500,000 '.Village Hardware and Computer Server Rack Equipment are Last Deferred N/A Issue scheduled for replacement on a 5 year cycle Last Incurred 2022 Fund IT Fund Account Number 155.75.560.50 10 Year Financial Trend $100,000 Staff continues to evaluate cloud solutions to reduce onsite server presence while also considering long-term server $80,000 Solution installations in connection with the facilities planning. In $60,000 2025 nothing is anticipated,costs remain based on $40,000 anticipated annual needs $20,000 O c-I N M Ln ko r 00 0) N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ $ $ - $ 59,500 $ 91,500 $ 151,000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ $ $ 35,000 $ - $ - $ 35,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 100,000 $ 126,000 $ 236,000 $ 462,000 $ 35,000 $ 497,000 umum Page 60 of 104 f Aerial Mapping Ortho Imagery II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 5008 VI Category 5-Technology u W s 1 Priority 4-Contributory Useful Life 5 years Origination IT trtrartrrrra i�� fih �i� fay //// User Department IT �wrra "r � V /Oo l% Coordinator IT Current Budget $ - Initial Proposal Date 2022 Design Work N/A Project Work 2024 Location Village Network Recurrence 2027 Asset Valuation $ '.Aerial Mapping Imagy is used by the Village for various Last Deferred N/A Issue projects including for stormwater management. Last Incurred 2020 Fund IT Fund Account Number 155.75.560.50 10 Year Financial Trend $120,000 $100,000 An aerial mapping of the Village was completed in 2023. As $80,000 .... .... Solution the Village changes,another flyover will be needed,which is $60,000 currently estimated in 2026.Costs remain on 5 year cycle $20,000 $ O c-I N m Ln to r 00 a) N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ $ _ $ $ 76,000 $ $ 76,000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ $ 100,000 $ $ - $ $ 100,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 $ 100,000 $ 40Q000 - Page 61 of 104 f HR Travel and Training Software II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 5009 fa�^ wwi�na� I�I Category 5-Technology Priority 4-Contributory iVVu� Useful Life 5 years Origination IT User Department HR Coordinator IT '%'!��1G�!�! ,�Attionmtuim!tnw�roJi... 4 a. ....mm Current Budget $ - ° °°° °��° Initial Proposal Date 2022 Design Work N/A Project Work 2024 Location Village Network Recurrence 2027 Asset Valuation $ New software will be implemented in 2024 per K.G. No Last Deferred N/A Issue anticipated need beyond that in forseeable future. Last Incurred N/A Fund IT Fund Account Number 155.75.560.50 10 Year Financial Trend $25,000 .., $20,000 ... A new travel and training program is proposed to be $15,000 Solution implemented in the future. $5,000 ... $- All c c-I N m zr Vn lD n W Ql N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ $ $ $ $ 20,200 $ 2Q Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ $ $ $ $ _ $ Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ $ $ $ $ $ Page 62 of 104 Network & Security Improvements II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 5010 - Category 5-Technology I ,„gym rvp Priority 2-Essential �r(loll iI�iONr� ki. i � j w� Useful Life 10 Years Origination Scheduled Upgrades User Department IT Coordinator IT Current Budget $ . "°� `"` ......� "°� � Initial Proposal Date 2021 Design Work N/A Project Work 2024 Location Village Buildings Recurrence 2031 The Village network needs to be upgraded to accommodate Asset Valuation $ 1,000,000 web based software at many facilities and for remote site Last Deferred N/A access and to enable the Village's mobile workforce.Storage Issue Area Network solutions with Cloud Storage are needed to Last Incurred 2023 provide basic disaster recovery for continuity of operations and expanded archival storage. Fund IT Fund Account Number 155.75.560.50 10 Year Financial Trend $300,000 $250,000 For FY25 nothing is budgeted. Long term costs associated $200,000 Solution with various upgrades. $150,000 $100,000 $50,000 N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ $ 150,000 $ 265,000 $ 165,000 $ 105,000 $ 685,000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term Fs $ $ $ 75,000 1 $ 50,000 $ 125,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 125,000 $ 125,000 1 $ 360,000 1 $ 610,000 1 $ 125,000 $ 735,000 umum Page 63 of 104 Fire External CPR Device Replacement II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 5011 Category 5-Technology Priority 2-Essential Useful Life 5 Years Origination Scheduled Upgrades User Department Fire Coordinator Fire Current Budget $ 38,000 Initial Proposal Date 2022 Design Work N/A Project Work 2024 Location BGFD Fire Apparatus Recurrence 2027 Asset Valuation $ 60,000 Once the LUCAS device is applied to the patient,it stays with Last Deferred N/A the patient until they arrive at the emergency department.A ISSU2 device is needed for the reserve ambulance and for Last Incurred 2020 emergencies. Fund General Fund Account Number 150.75.560.30 10 Year Financial Trend $40,000 .., $30,000 .., All LUCAS CPR Devices are up to date but more are Solution All for replacement in 2025 and future years. $20,000 $10,000 $- .., ,... wiv N N 0 N N 0 N N N N O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ 29,000 $ - $ - $ 19,000 $ - $ 48,000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 38,000 $ 38,000 $ 19,000 $ - $ 20,000 $ 115,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 25,000 $ 30,000 $ 30,000 $ 85,000 $ 115,000 $ 20Q000 umum Page 64 of 104 Fire Radio Replacement II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project ff 5013 Category 5-Technology Priority 3-Sustaining Useful Life 8 Years Origination Scheduled Upgrade User Department Fire lose Coordinator Fire Current Budget $ Initial Proposal Date 2019 Design Work N/A Project Work 2024 Location BGFD Fire Apparatus Recurrence 2030 Asset Valuation $ 150,000 Last Deferred 2020-2021 Dependable radios are essential and are required for fire ISSU2 and safety operations. Last Incurred 2021 Fund General Fund Account Number 150.75.560.30 10 Year Financial Trend $350,000 $300,000 The BGFD portable radios were purchased in 2012 with just $250,000 Solution one spare.6 additional portable radios were purchased in $200,000 2022.Nothing is budgeted for replacement in FY25. $150,000 $100,000 $50,000 $- Y .,.. I 'All mmmm....I O c-I N M � Vt t0 I� W 01 N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ $ - $ 54,000 $ $ 70,400 $ 124,400 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ $ 175,000 $ 300,000 $ $ - $ 475,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 56,000 $ 128,000 $ - $ 184,000 $ 475,000 $ 659,000 umum Page 65 of 104 Fire SCBA Equipment II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 5014 Category 5-Technology Priority 2-Essential � { Useful Life 9 Years r �i Origination Scheduled Upgrade User Department Fire �t Coordinator Fire Current Budget $ 350,000 Initial Proposal Date 2020 Design Work N/A Project Work 2024 Location BGFD Fire Apparatus Recurrence 2033 The Self Contained Breathing Apparatus(SCBA)are essential Asset Valuation $ 420,000 for fire and safety operations,they have a 9 year life cycle Last Deferred N/A Issue and can be replaced with FEMA grant funding.The SCBA air Last Incurred 2022 compressor was replaced in 2022 with a 15 year life cycle. Fund General Fund Account Number 150.75.560.30 10 Year Financial Trend $400,000 The SCBA units are proposed for replacement in 2025 $300,000 ($350k)to stay compliant with NFPA Standards.90%FEMA Solution grant funding may be available to reduce costs so a grant $200,000 writer will be utilized in 2024 to start this process. $100,000 O c-I N M Ln to r, W m N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ - $ $ 60,000 $ $ 2,000 $ 62,000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 350,000 $ $ - $ $ - $ 350,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 350,000 $ 70,000 $ 350,000 $ 770,000 $ 350,000 $ 1,12Q000 umum Page 66 of 104 Fire Extrication Equipment II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 5015 Category 5-Technology oi' �� Priority 2-Essential �� Useful Life 20 Years �Qs � Origination New User Department Fire Coordinator Fire it Current Budget $ 65,000 Initial Proposal Date 2022 Design Work N/A Project Work 2025 Location BGFD Fire Apparatus Recurrence 2045 Asset Valuation $ 40,000 The Fire Department's extrication equipment was purchased Last Deferred N/A Issue in 2005,it has a life cycle of 20 years and is in need of Last Incurred 2002 replacement in approximately 2025.($65k) Fund General Fund Account Number 150.75.560.30 10 Year Financial Trend $70,000 ... $60,000 One extrication unit is proposed for replacement in 2024, $50,000 Solution with a second unit and air bags in 2025 and finally another $40,000 air bag in 2026. $30,000 ... $20,000 .., $10,000 .. N N N N N N N N N N O O O O O O O O O O AZ N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ _ $ _ $ $ $ 45,000 $ 45,000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 65,000 $ 20,000 $ $ $ - $ 85,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 40,000 $ 40,000 $ 40,000 $ 120,000 $ 85,000 $ 205,000 umum Page 67 of 104 L Automated License Plate Readers ��wlU�wlU�wlU�wlU�wlU�wlU� ��wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU� Project# 5016 Category 5-Technology Priority 3-Sustaining Useful Life 10 Years Origination New g User Department Police Coordinator Police 1 W Il Current Budget $ Initial Proposal Date 2024 ,--- »w,-- ,---- ,.,.--------- --- Design Work N/A Project Work 2024 Location Police Department and Officers Recurrence 2034 Asset Valuation $ 500,000 With the growing reaches of technology into Police Operations,Automated License Plate Readers have found a Last Deferred N/A Issue way to support operations without negatively impacting Last Incurred N/A privacy. Fund Supervision Fund Account Number 211.92.555.40 10 Year Financial Trend $60,000 .., $50,000 .., The Police Department is seeking funding to add ALPRs $40,000 Solution methodically over the next number of years at critical $30,000 intersections in cooperation with surrounding agencies. S20,000 .. M11-1 $10,000 $- .....mmmm�mmimmmmmgmm 11 N N 0 N N 0 N N N N O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ $ _ $ _ $ - $ 45,000 $ 45,000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ $ 45,000 $ 45,000 $ 50,000 $ - $ 140,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 90,000 $ 90,000 $ 90,000 $ 270,000 $ 140,000 $ 41Q000 umum Page 68 of 104 f Unmanned Aerial Vehicle - Drones ��wlU�wlU�wlU�wlU�wlU�wlU� ��wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU� Project# 5017 Category 5-Technology Priority 4-Contributory e` Useful Life 5 Years Origination New User Department Multiple Coordinator Police Current Budget $ Initial Proposal Date 2023 Design Work N/A Project Work 2024 Location Police Department and Officers Recurrence 2029 Asset Valuation $ 50,000 Small drones have shown the ability to support a number of Village functions,across a number of Departments. Police Last Deferred N/A Issue have demonstrated the most immediate need with event Last Incurred N/A monitoring and other uses. Fund Supervision Fund Account Number 211.92.555.40 10 Year Financial Trend $20,000 .., The Police Department purchased a drone in FY24 using seizure funds,and have subsequently received a$15k grant $15,000 Solution for the purchase of another drone. Staff anticipates a life $10,000 cycle of 5 years for the drones. No funding request for FY25, funding for 5 year program cycle $5,000 $ 0 0 V1 l0 I� W Q1 N N N N N N N N O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ $ $ $ $ 10,000 $ 10,000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ $ $ $ $ 15,000 $ 15,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 20,000 $ 25,000 $ 25,000 $ 70,000 $ 15,000 $ 8s,000 Page 69 of 104 f Website Update ��wlU�wlU�wlU�wlU�wlU�wlU� ��wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU� Project# 5018 Category 5-Technology Biajfalo Grove Priority 4-Contributory Hum rar.r r�r y ro-x� Useful Life 5 Years Origination Scheduled Upgrade User Department Multiple t ,r uo Coordinator OVM Current Budget $ L &I it, Initial Proposal Date 2023 Design Work N/A Project Work 2024 Location Internet based Recurrence 2029 Asset Valuation N/A A continual effort to communicate and connect with the Last Deferred N/A Issue Public. Last Incurred 2019 Fund IT Fund Account Number 155.75.560.50 10 Year Financial Trend $60,000 .., $50,000 Website refresh in an effort to connect with residents $40,000 Solution through content and mechanisms they utilize. Anticipated $30,000 costs on rolling 3 year cycle. $20,000 $10,000 N N O O 0 O O 0 N N N N N N O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ $ $ _ $ $ 45,000 $ 45,000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ $ $ 50,000 $ $ - $ 50,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 105,000 $ 115,000 $ 60,000 $ 280,000 $ 50,000 $ 33Q000 Page 70 of 104 L °w Laserfiche Cloud ��wlU�wlU�wlU�wlU�wlU�wlU� ��wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU� Project# 5019 Category 5-Technology Priority 2-Essential Useful Life 5 Years Origination New T„ User Department Multiple Coordinator IT '000, '000, Current Budget $ 85,000 Initial Proposal Date 2024 Design Work N/A Project Work 2024 Location Village Network Recurrence 2029 Laserfiche is the Village's primary document management Asset Valuation $ 50,000 and retention system.The software is currently hosted on Last Deferred N/A servers maintained by the Administrative Services ISSU2 Department.Significant technical expertise is required to Last Incurred N/A maintain the servers and frequent intervention by IT personnel is necessary to ensure uotime. Fund IT Fund Account Number 155.75.560.50 10 Year Financial Trend $100,000 Laserfiche offers a cloud-based hosting service that would $80,000 reduce the technical requirements,significantly expand the Solution software's capabilities,and allow for automatic updates and $60,000 upgrades.Anticipated implentation costs($85k)with annual $40,000 ongoing costs estimated($85k). $20,000 o N m a n �0 00 m N 0 O N 0 0 0 0 N N N O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical ' Historical $ _ $ _ $ _ $ _ $ _ $ _ Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 85,000 $ 85,000 $ 85,000 $ 85,000 $ 85,000 $ 425,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 425,000 $ 450,000 $ 450,000 $ 1,325,000 $ 425,000 $ 1,75Q000 Page 71 of 104 f Finance Software Update ��wlU�wlU�wlU�wlU�wlU�wlU� ��wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU�wlU� Project# 5020 Category 5-Technology Priority 2-Essential Useful Life 5 Years Origination New User Department Multiple Coordinator IT Current Budget $ 150,000 � 1X� 7N11 N� Initial Proposal Date 2024 Design Work N/A Project Work 2024 Location Village Network Recurrence 2029 Asset Valuation $ 50,000 Tyler Technologies New World is the Village's financial Last Deferred N/A Issue enterprise software.Tyler Technologies is anticipating a Last Incurred N/A gradual phase out of the New World product. Fund IT Fund Account Number 155.75.560.50 10 Year Financial Trend $200,000 In order to maintain financial operations,the Village needs $150,000 Solution to evaluate and select a new enterprise product,engage with an implementation vendor,and ultimately transition to $100,000 a new enterprise system. $50,000 o N m a n �0 00 m N N N O 0 0 N N N O O 0 0 O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ $ $ $ $ $ Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 150,000 $ 150,000 $ 125,000 $ 125,000 $ 125,000 $ 675,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 625,000 $ 625,000 $ 625,000 $ 1,875,000 $ 675,000 $ 2,SSQ000 Page 72 of 104 f Water Meter Software II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 5021 Category 5-Technology � IUDu Priority 2-Essential Useful Life 5 Years Origination New User Department PW Coordinator IT Current Budget $ 66,617 Initial Proposal Date 2024 ...... .... ..... Design Work N/A Project Work 2024 Location Village Network Recurrence 2029 Asset Valuation $ 50,000 With the installation of new meters in 2014 the consultant Last Deferred N/A Issue included software. That licience agreement has run through Last Incurred N/A its duation. Fund IT Fund Account Number 155.75.560.50 10 Year Financial Trend $70,000 .., Logis SaaS was the old program which came with the $60,000 onboarding. Sensus Analytics Hosting allows for a safe and $50,000 SOIUtIOn $ ,000 secure mechanism for the Village to utiltize its water meter 30 $so,000 .. .. data. $20,000 .. $10,000 .., N N 0 N N 0 N N N N O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ _ $ _ $ _ $ _ $ _ $ _ Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 66,617 $ 38,238 $ 40,150 $ 42,158 $ 44,265 $ 231,428 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 242,059 $ 280,613 $ 325,307 $ 847,979 $ 231,428 $ 1,079,407 Page 73 of 104 Capacity Management Operations and Maintenance II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 6001 Category 5-Technology Priority 1-Mandatory Useful Life Ongoing ufi Origination MWRD Requirement User Department PW Coordinator PW Current Budget $ 240,000 Initial Proposal Date Ongoing Design Work Yearly Project Work Yearly Location Village Sanitary Sewer System Recurrence Yearly The Watershed Management Ordinance(WMO)of the Asset Valuation N/A MWRD and the 2022 Lake County Sanitary Sewer Last Deferred N/A Agreement,outlines the requirements of the Last Incurred 2024 Issue Inflow/Infiltration Control Program(IICP)that applies to the Village's sanitary sewer system.The primary purpose of the CMOM is to reduce sanitary sewer overflows(SSOs)and basement backups(BBs). Fund Water&Sewer Fund Account Number 170.55.36.560.70 Fund Code 2020 GO FY22 SWR 10 Year Financial Trend The Village's capacity management operations and maintenance program is a joint effort between the Village's $ ,000 Public Works Department and a consulting engineer to run $2500,000 Solution and administer the inflow/infiltration reduction program $200,000 within the Village in accordance with the County's $150,000 requirements($90k).Sanitary sewer televising is proposed $100,000 in 2025($150k) $50,000 $- .. N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ 7,000 $ 19,000 $ 39,000 $ 194,000 $ 240,000 $ 499,000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term Fs 240,000 $ 260,000 $ 270,000 $ 275,000 $ 280,000 $ 1,325,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 1,475,000 $ 1,600,000 $ 1,725,000 $ 4,800,000 $ 1,325,000 $ 6,125,000 Page 74 of 104 L Lift Station Repair and Rehabilitation II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 6002 Category 6-Water&Sanitary Sewer Priority 2-Essential Useful Life 30 Years Origination Major Maintenance User Department PW i� Coordinator PW Current Budget $ 2,500,000 z � Initial Proposal Date Ongoing ,,,,,,,a,....... Design Work Yearly Project Work Yearly Location Twelve Lift Station Sites Recurrence Yearly Asset Valuation $ 100,000,000 Lift Stations require rehabilitation or replacement every 15 Last Deferred N/A to 25 years.Routine maintenance helps reduce costly ISSU2 repairs,equipment failures,and extends the useful life of Last Incurred 2024 the facility. Fund Water&Sewer Fund Account Number 170.55.36.560.70 Fund Code 2020 GO FY22 SWR 10 Year Financial Trend $7,000,000 This program manages the Village's lift stations. In late 2025 $6,000,000 carrying over into 2026 the Raupp Lift Station/Old $5,000,000 SOIUtIOn Treatment Plant combination will take place along with the $4,000,000 advance design work for Buffalo Grove Road($150k). $3,000,000 $2,0Do,D0o $1,000,000 O c-I N M 0 W r 00 M N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ 1,320,000 $ 450,000 $ 3,750,000 $ 200,000 $ 200,000 $ 5,920,000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 2,500,000 $ 6,650,000 $ 3,600,000 $ 140,000 $ 1,750,000 $ 14,640,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 5,950,000 $ 4,300,000 $ 6,200,000 $ 16,450,000 $ 14,640,000 $ 31,09Q000 umum Page 75 of 104 Pump House Repairs and Upgrades II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 6003 � Category 6-Water&Sanitary Sewer Priority 3-Sustaining /I t i Useful Life 50 Years jOrigination Major Maintenance User Department PW Coordinator PW Current Budget $ 500,000 Initial Proposal Date Ongoing Design Work Yearly Project Work Yearly Location Four Water Pumping Stations Recurrence Yearly Asset Valuation $ 30,000,000 Pump House repairs were identified by a required Last Deferred N/A vulnerability study and a Comprehensive Water Study. Issue Several Vertical Turbine pumps are reaching manufacturers Last Incurred 2024 recommended rebuild timelines. Fund Water&Sewer Fund Account Number 170.55.35.560.60 Fund Code 2020 GO FY22 WTR 10 Year Financial Trend $800,000 Proposed in 2025 are various improvements in process $600,000 Solution components($50K).Vertical Turbine Pump Maintenance and Rebuilds($150K).Well Maintenance($300K). $400,000 $200,000 $- m .... El , N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ - $ - $ 500,000 $ 50,000 $ 200,000 $ 750,000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term Fs 500,000 $ 500,000 $ 750,000 $ 750,000 $ 750,000 $ 3,250,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 85,000 $ 1,500,000 $ 2,000,000 $ 3,585,000 $ 3,250,000 $ 6,835,000 umum Page 76 of 104 Village wide Sanitary Sewer Replacement II�I�I�I�I�I�I II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I Project# 6004 Category 6-Water&Sanitary Sewer Priority 3-Sustaining Useful Life 75 Years Origination Major Maintenance (il�ll h I�III�� User Department PW Coordinator PW Current Budget $ 350,000 Initial Proposal Date Ongoing Design Work Yearly Project Work Yearly Location Village Right of Way and easements Recurrence Yearly Asset Valuation $ 57,739,000 A program is needed to maintain sanitary sewer systems Last Deferred N/A Issue which have a projected life of 60 years. Last Incurred 2024 Fund Water&Sewer Fund Account Number 170.55.36.560.70 Fund Code 2020 GO FY22 SWR 10 Year Financial Trend $800,000 This program provides funding sanitary sewer lining,point $600,000 repairs,or replacements as identified by the Village.Funding $OIUtIOn is being requested for sanitary sewer lining($200k)and $400,000 manhole repair and lining($150k). o N m a 0 o r, m m N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ 600,000 $ 750,000 $ 680,000 $ 350,000 $ 350,000 $ 2,73Q000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 350,000 $ 355,000 $ 360,000 $ 365,000 $ 370,000 $ 1,800,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 1,925,000 $ 2,050,000 $ 2,175,000 $ 6,150,000 $ 1,800,000 $ 7,950,000 Category: Sanitary Sewer and Distribution System Notes: *The sanitary sewer and distribution system in the Village is an important part of the Village's infrastructure *The Village has lined a large part of sanitary sewer pipe in the system *Continuing to line sanitary sewers helps maintain or improve the rating Page 77 of 104 Village wide Water Main Replacement II�I�I�I�I�I� II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I� Project# 6005 Category 6-Water&Sanitary Sewer Priority 3-Sustaining i r Useful Life 60 Years Origination Major Maintenance � User Department PW I Coordinator PW Current Budget $ 5,300,000 Initial Proposal Date Ongoing . .. ... ...,...... .,..... ....,..... Design Work Yearly Project Work Yearly Location Village Right of Way and easements Recurrence Yearly Asset Valuation $ 68,742,000 A program is needed to maintain the Village's water main Last Deferred N/A Issue which have a projected life of 75 years. Last Incurred 2024 Fund Water&Sewer Fund Account Number 170.55.35.560.60 Fund Code 2020 GO FY22 WTR 10 Year Financial Trend This program provides for replacing aging water main $10,000,000 throughout the Village.In 2025 proposed work includes the $8,000,000 design of aging water main infrastructure in I.M.P.projects Solution ($500k),construction of the Mill Creek(#1)Street&Utility $6,000,000 project($2.3M),Bernard Water Main($1.4M),water main $4,000,000 on Arlington Heights Road($500k)and construction of a $2,000,000 main connection on Prairie Road($600k). s- (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ 3,791,000 $ 5,100,000 $ 8,200,000 $ 400,000 $ 3,800,000 $ 21,291,000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 5,300,000 $ 6,500,000 $ 6,801,000 $ 4,100,000 $ 4,100,000 $ 26,801,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 43,331,400 $ 57,711,100 $ 27,285,000 $ 128,327,500 $ 26,801,000 $ 155,128,500 Category: Water Main and Distribution System 00=Notes: *The water main and distribution system in the Village is an important part of the Village's infrastructure C+ *The Village has an active water main replacement strategy *Continuing to replace or repair water main witll help to maintain or improve the rating Page 78 of 104 Water Loss Management II�I�I�I�I�I� II�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I�I� Project# 6006 Category 6-Water&Sanitary Sewer Priority 3-Sustaining i r Useful Life 60 Years Origination Major Maintenance � User Department PW I Coordinator PW Current Budget $ 117,000 Initial Proposal Date 2022 . .. ... ...,...... .,..... ....,..... Design Work Yearly Project Work Yearly Location Village Right of Way and easements Recurrence Yearly Asset Valuation $ 250,000 Receiving Lake Michigan water requires constant monitoring Last Deferred N/A Issue of the water distribution system for water loss that wastes Last Incurred 2024 water and Village revenue. Fund Water&Sewer Fund Account Number 170.55.35.560.60 Fund Code 2020 GO FY22 WTR 10 Year Financial Trend $140,000 ., $120,000 ^ — Funding is proposed to monitor the water system for water $100,oDo Solution loss by using data,analytics,monitoring,maintenance and $80,000 repair plans for the next 5 years. $60,000 $40,000 $20,000 N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ - $ - $ 86,000 $ 84,000 $ 80,000 $ 250,000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term $ 117,000 $ 120,000 $ 130,000 $ 130,000 $ 120,000 $ 617,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 650,000 $ 750,000 $ 1,000,000 $ 2,400,000 $ 617,000 $ 3,017,000 Page 79 of 104 SCADA Hardware and Software Updates IIUIUIIUIIUIIUIIU IUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIUIIU Project# 6007 �4 Category 6-Water&Sanitary Sewer A Priority 3-Sustaining Useful Life 10 Years Origination Scheduled Upgrade ice ' �iy'i User Department PW Coordinator PW Current Budget $ 500,000 Initial Proposal Date 2022 Design Work 2023 Project Work 2024 Location Department Recurrence 2033 The components and software for the Supervisory Control Asset Valuation $ 400,000 And Data Acquisition(SCADA)for the Village's utility systems Last Deferred N/A need to be maintained and upgraded on a regular basis.The Last Incurred 1990 Issue need system needs repairs and is not compatible with current infrastructure or technological advancements in the industry. Fund Water&Sewer Fund Account Number 170.55.36.560.70 Fund Code 2020 GO FY22 SWR 10 Year Financial Trend $600,000 $500,000 In tandem with the system and facility improvements,a long $400,000 term plan is proposed to upgrade the system with new Solution $300,000 software and primary components($350k)in 2025 and secondary components($75k)in 2026 $200,000 $100,000 S- 7`s ; o N m � n � n w m N N N N N N N N N N O O O O O O O O O O N N N N N N N N N N (Estimated) 2020 2021 2022 2023 2024 Historical Historical $ - I $ - I $ I $ 50,000 I $ 50,000 I $ 100,000 Financial 2025 2026 2027 2028 2029 Short Term Impact Short Term 1 $ 500,000 $ 75,000 $ 75,000 $ - $ 75,000 $ 725,000 Year 6-10 Year 11-15 Year 16-20 Long Term Short Term Total 20 Year Long Term $ 360,000 1 $ 360,000 1 $ 360,000 1 $ 1,080,000 1 $ 725,000 1 $ 1,805,000 uuu Illllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll@ C Page 80 of 104 Requested Budgeted GrlPn enea ud Village Campus Long Range Planning 40,000 40,000 ,Village de w Co�pre B es e n 'V PI a a n n d D es g 1 n Unified Development Ordinance 80,000 80,000 Fir External l, PR Device Replacement e e a C a ce38,000 38,000 Fire Radio Replacement - - IFire SCBA E u, ment 350,000 350 000 q p ,,u,� Fire Extrication Equipment 65,000 65,000 Automated License Plate Readers Unmanned Aerial Vehicle Drones Buffalo Creek Greenway Planning &Stormwater Man agement 1050,000 1050,000 Subtotal 1,623,000 1,623,000 Capital Projects - Facilities - 150.75.560.30 Flooring Capital Replacement Projects 10,500 10,500 Fire Station #27 Remodel 55,000 30,000 HVAC Unit Replacements 75,000 75,000 Roof Capital Replacement Projects 900,000 900,000 Combined Area Fire Training Facility 40,000 Electric Charging Stations 10,000 10,000 •,��Police H�e�a�duarters51�000556000�� q Fire Station #26 Addition/Remodel 589,000 589,000 Public Works Facility Village Hall - - Fire Station #25 Rebuild 10,800,000 0 800 000 10,800,000 Pace/Metra Facility 290,000 290,000 Outdoor Warning Siren Upgrades/Replacements 30,000 30 000 Village Entrance Signage 400,000 400,000 (Clove Park 25,000 5 000 25,000 Village Green 76,000 76,000 Emer g enc Y p )Operations Center EOC 228,533 228,533 Subtotal 14,085,033 14,020,033 Capital Projects - Streets 160.75.560.20 Annual Sidewalk Maintenance 300,000 300,000 Annual Bike Path Maintenance 100,000 100000 Annual Street Maintenance 16,116,000 8,116,000 Collector Route Maintenance & Rehabilitation Projects 9110 000 9,350,000 Lake Cook Road Improvement 535,000 535,000 Weiland/Prai irie Road Improvements - - Page 81 of 104 Municipal Parking Facility Maintenance 70,000 70,000 Buffalo Grove Road Improvement - - Arlington Heights Road Improvement 329,094 329,094 Aptakisic Road Improvement (120,000) (120,000) Median and Street Scaping Improvements 40,000 - Street Light LED Conversion 240,000 Deerfield Parkway Intersection Improvements nts - - Stormwater System Improvements 7,100,000 7,100,000 Sub�tota�l 3�4,060,�0�9�4 �25,780,094 Water &Sewer Fund - 170.55.560.60/70 ater and Truck�Weighing Station - - Capacity Management Operations and Maintenance 240,000 240,000 iftStation Repair and Rehabilitation 2,500,000 2,500,000 Pump House Repairs and Upgrades 500,000 500,000 Village wi nary Sewer Repla de San' cement 350,000 350,000 Village wide Water Main Replacement 5,300,000 5,300,000 Water Loss Management 111,000 117000 SCADA Hardware and Software Updates 500,000 500,000 �� Subtotal� � 9,507,000 �5�0�7�0 0 0 9,507,000 � �� Information Technology Fund - 155.75.560.50 „Service Delivery Communication Software 500,000 500,000 sw,v � � Police Tasers - - Police/Fire Mobile Devices , ,120000 120000 Server and Hardware Replacements - - Aerial Mapping Ortho Imagery HR Travel and Training Software - ........... - N�etwo�r�k&Sec Security Improvements Website Update - - ILaserfiche Cloud 85,000 85,000 .Finance Software Update 150,000 150,000 Water Meter Software 66,617 66,617 Subtotal 921,617 921,617 Golf Fund 180.84.560.80 190.84.560.80 Buffalo Grove Golf Course Improvements 169,000 169,000 Arboretum Golf Course Improvements 336,000 336,000 Subtotal 505,000 505,000 Total 60,701,744 52 356 744 Page 82 of 104 umlli II lBUFFALO uuuuuuu IIIIII uuuuuull uuumuuum uuuuuuu uuml BUFFALO GROVE VILLAGE BOARD Gl�,IIZQVE I Committee of the Whole: August 5, 2024 AGENDA ITEM J. 2025 General Wage Increase and Merit Pool Recommendation Contacts Liaison: Trustee Ottenheimer Staff: Kathryn Golbach Staff Recommendation Staff recommends discussion. Summary Please see the attached memorandum for more details. Strategic Alignment Guiding Principle Principle 1: Financially Responsible and Sound Principle 3: Plan and Invest in the Future Principle 4: High Performing Village Team Goal Goal 1: Maintained effective village government: fiscally responsible and providing outstanding, responsive services File Attachments 1. 2025 GWI and Merit Pool Recommendation 7.26.24 Page 1 of 1 i rha iif1.v I'd Il ea it. 50I5laupp Blvd, Buffalo(-",xrove, IHI 60089 °,,: 847-459-2SOO,,s vk.g.org BUFFALO IIIIII III°° IIIII II ° GROVE DATE: August 5, 2024 TO: Village Manager Dane Bragg FROM: Human Resources Director Kathryn Golbach SUBJECT: 2025 General Wage Increase and Merit Pool Recommendation .Illll i° jI III' III"""IIII ' III Based on internal and external factors, staff recommend approval of a 3%general wage increase for non-represented employees in 2025. Additionally, staff recommends continuing the pay-for performance program which includes an estimated merit pool of$290,500 for all eligible non- represented employees. Annually, staff evaluates general wage increases and merit pool data for non-represented employees to support the Village's compensation strategy.This process includes reviewing salary data from comparable communities, evaluating the Village's financial data, and analyzing the external labor market.The pay-for-performance program has been in place for many years and works well maintaining equity between our represented and non-represented employes as well as providing continued motivation of our outstanding workforce. In concept,the general wage increase adjusts the minimum and maximum pay ranges for all non- represented pay grades, while merit increases are performance based and determine an employee's mid-year salary adjustment. kqN 56 General Wage Increase Multiple scenarios have been run by staff based on estimated employee totals and estimated general wage increase percentages. At present, the Village currently has 130 non-represented employees (inclusive of full-time and part-time employees) who would be eligible for a general wage increase in 2025. Page 1 of 3 ui ° ul . i. Il e s ll, 50 I aupp Boulevard, Buffalo Grove, 10_. 60089 47--459-. ff:00 vb .org General Wage Increasefor Non-P-epresented Employees Estimated Percent(%)Increase Number of Employees I Total Gross Salary 2.50% Difference 3.0% Difference 3.25% Difference 130 1 $ 13,891,582.12 $ 14,238,871.67 $ 347,289.55 $14,308,329.58 $ 416,747.46 $14,343,058.54 $ 451,476.42 The estimated general wage increase totals are based on the previously mentioned internal and external factors,taking into consideration our comparable communities of similarly situated employers and internal equity with our represented employees.The average estimated general wage increase of these communities was 3.25%.A general wage increase of 3.25%would yield a net cost of$451,476.42. General Wage lncreaseforFbpresented Employees EstimatedPercent(%)Increase Position Number of Employees Total Gross Salary 2.0% Difference 2.5% Difference 3.0% Difference Firefighter/Paramedic 40 $ 4,308,151.38 $ 4,394,314.41 $ 86,163.031 $ 4,415,855.16 $ 107,703.78 $ 4,437,395.92 $129,244.54 Firefighter Lieutenant 9 $ 1,243,193.90 $ 1,268,057.78 $ 24,863.881 $ 1,274,273.75 $ 31,079.85 $ 1,280,489.72 $ 37,295.82 Police Officer 42 $ 4,564,639.04 1 $ 4,655,931.821 $ 91,292.781 $ 4,678,755.02 1 $ 114,115.981 $ 4,701,578.21 1 $136,939.17 Totals 1 91 1 $ 10,115,984.32 $10,318,304.01 1 $ 202,319.69 1 $10,368,883.93 1 $ 252,899.611 $10,419,463.851 $303,479.53 Although negotiations have not yet begun for 2025, estimated general wage totals have been calculated for 2025. These percentages are based on historical trends from previous collective bargaining agreements as well as agreements that were ratified this year. The general wage increase received this year for firefighter/paramedic was 3.5%and 2%for Firefighter/Lieutenant.The police officergeneral wage increase for 2024 is estimated to be 3%, however,that agreement has not been ratified. Merit The village's compensation strategy is based on a pay for performance model,which ties a non- represented employee's merit increase to their annual performance review.A merit increase should not be confused with a bonus, as awarded merit increases move employees through their range. Conversely, our represented employees move through their range via a step plan negotiated through collective bargaining which is not based on performance, but rather based on their years of service. The chart on page three shows the difference between a represented employee and a non-represented employee as they progress through their pay range. Based on annual increases, it takes three years longer for a non-represented employee to reach their maximum pay within their pay range. The Village continues to use the same rating scale as in the past to determine awarded merit pay. For example, an employee who scores a 2 ("Needs Improvement") would receive no merit pay, however, an employee who scores a 3 ("Meets Expectations") would receive on average a 3% increase. Eligible employees include non-represented employees who have been with the Village for at least six full months and are not at the top of their pay range. As employees achieve longer tenure with the organization,fewer employees are eligible for merit increases as merit increases are not awarded to employees at the top of their pay range.The closer an employee is to reaching the maximum of their pay range,the smaller their merit increase may be. Conversely,the closer an employee is to the Page 2 of 3 ui ° ul . i. Il e s ll, 50 I aupp Boulevard, Buffalo Girove, 1L. 60089 47--459-. ff:00 vbg.org minimum of their pay range,the larger their merit increase may be. The table below outlines the merit pool totals over the last three years including estimated totals for 2025. Merit Pool Totals for Non-Represented ($) Fiscal Year Merit Pool Totals Number of Eligible Employees Average Wage Increase 2022 $ 215,402.72 60 $ 3,033.00 2023 $ 333,459.36 99 $ 3,309.44 2024 $ 267,329.92 65 $ 3,570.65 2025 $ 290,500 (estimated) 75 $ 3,500 (estimated) As illustrated in the table above,the number of eligible employees for merit has decreased since 2023. This decrease can be attributed to the changes that were applied to our pay plan in 2023, which expanded the pay grades for a number of positions making those who were previously ineligible in 2022, eligible for a merit increase in 2023.The estimated increase for 2025 takes into account the number of new hires and promotions welcomed in 2024, who will become eligible for a full or pro-rated increase in 2025. III'°) Next steps for implementing a general wage increase and continuing with our pay-for-performance program involve securing concurrence from the Village Board. Following the approval of staff's recommendation,the estimated totals for the general wage increase and merit pool for 2025 will be incorporated into the 2025 budget. Page 3 of 3 50 I aupp Boulevard, Buffalo Grove, 10_. 60089 47--459-. ff:00 vb .org umlli II lBUFFALO uuuuuuu IIIIII uuuuuull uuumuuum uuuuuuu uuml BUFFALO GROVE VILLAGE BOARD Gl�,IIZQVE I Committee of the Whole: August 5, 2024 AGENDA ITEM . . FY 2024 - Six MonthReport Contacts Liaison: Trustee Bocek Staff: Chris Black Staff Recommendation Staff recommends discussion. Summary See Attached Memo for Details Strategic Alignment Guiding Principle Principle 1: Financially Responsible and Sound Goal Goal 1: Maintained effective village government: fiscally responsible and providing outstanding, responsive services File Attachments 1. COW 08.05.24 FY 2024 Six Month Report Page 1 of 1 i rha iif1.v I'd Il ea it. 50I5laupp Blvd, Buffalo(-",xrove, IHI 60089 °,,: 847-459-2SOO,,s vk.g.org BUFFALOIIIIIIIII'"' °"' """' W IM G�OVE DATE: August 5, 2024 TO: Village Manager Dane Bragg FROM: Director of Finance Chris Black SUBJECT: FY 2024 Budget- Six Month Status Update III';''i"I III „�IIII' "�UIII 'IIII'1 The six-month revenue and expenditure report provides an overview of current year performance measured against the 2024 Budget and the prior year's six-month totals. The six-month report provides information to make any necessary adjustments in spending and service delivery to respond to an unanticipated revenue decline or unforeseen expenditures. The Village's 2024 budget consists of $145,869,362 in forecasted total revenue and $163,177,555 in planned expenses. It is important to note that expenditures planned to exceed revenues include $25.6 million in capital outlays from reserve funds and bond proceeds. The budget includes a planned surplus in the pension funds ($8.3 million). In a typical year, revenues and expenses would be approximately 50 percent of the annual budget. Some major revenue sources have seasonal variations that could lead to a variance from the expected amount. Expenses traditionally will be less than 50 percent due to the timing of payroll, debt service payments, and construction and equipment purchases. ��ii,' ��iral �uii°°md IIIP. eveuii°m�ie Ilh°°°IIIPm lllh Ill t Nearly 82 percent of the General Fund's revenue is comprised of five sources of revenue including property tax, sales tax, use tax, income tax and excise taxes. Provided below is a chart of the total General Fund Revenue collected to date and a description of the major revenues. General Fund revenues are trending at 57 percent of the 2024 budget. Collections have increased 0.1 percent, or $32,300 from the first six months of2023. The following is a review of all major sources of revenue. Page 88 of 104 Property Taxes 16,780,272 8,673,671 52% 8,216,192 49% 6% 457,479 ----------------------------------------------------------------------------............................. ................................................................................................................................... Base Sales Tax 9.233.683 5,037,776 55% 4,990,908 60% 1% 46,868 Home Rule Sales Taxes 6 792 420 3,742,665 55% 3 775 914 62% _1% (33,249) Income"Taxes........................................... 6,525,012 4,086,444 63% 3,788,680 67% 8% 297,764 Use Tax-Local 1,728,480 855,507 49% 941,501 57% _9%---11--------------------------------------- ......... Use Taxes-Electricity 1 600000 699,683 43% 719553 45% -4% (28,870) Use Taxes-Natural Gas 1,100,000 809,677 74% 850,018 77% -5% ................................................................................................................................................................................................................................................................. elecomrn/Excise Taxes 650,000 343,265 53% 323,107 47% 6% 20,158 Fines and Fees 2,476,645 1,937,780 78% 1,696,052 92% 14% 241,728 .. .........................................................................................................................................................................................................................................................................................................................Real Estate Transfer Tax 990,000 511,019 52% 536,099 49% -5% (25.080) 'Food and Beverage Tax 900,000 478,420 53% 455,821 59% 5% 22,599 ------------------------1111111111111i 60611_1_1_1_1_1_11111 I'll-1-1-11,11,111,11'll""I'll""I'll",Ill""-,-1-1-1-1-1-1-1-1-1-1-1-l-l1-11,111,111,111,1111,'ll""I-11,111,111,11'll""I',,1-1-1-1-1-1-1-1-1-1-1-,I 1219 125% 27,160 39% 221% 60,058 !Development Fees&Permits 1,262,800 824,105 65% 1,526,321 125% -46.01% Business&Liquor Licensing 411,422 256,328 62% 242,256 69% 6% 14,072 Interest Income 440,000 1,318,327 300% 991,590 1692% 33% 326,738 --------------------------------------------- .................................................................................................................................................... 'Operating Transfers 830,000 415,000 50% 390,000 50% 6% 25,000 �All Other Revenue 6,235,864 3,044,822 49% 3,609,233 122% -160 (564,411)1 ..................................... .................... . .......................... Total 58,026,598 33,112,708 57% 33,080,405 65% 0.10% 32,303 ............... ....................................................................................................................................................................................................... • Property Taxes-51.7% Revenue to date represents the first installments of the 2023 levy extensions for both Lake and Cook counties. Receipts are typical of historical levels. Generally, 99.8 percent of taxes levied are collected so budget estimates will likely be realized byyear-end. • Combined Sales Taxes (Base/Home Rule) -54.8% Base Sales Tax and Home Rule net receipts are slightly over budget. Retail sales have slowed from the prior year and receipts are approximately 0.2 percent more than the prior year. The largest generators of sales tax are grocery stores and building and electrical supplies. • Income Tax-62.6% Income tax revenues are performing significantly above budget expectations. The Village anticipates, based on a revised Illinois Municipal League estimate, to outperform the $6.5 million budget by approximately $0.80 million in 2024. Total receipts are $299,700 more than the first six months of 2023. • Use and Utility Taxes (Local Use-49.5% /Electricity- 43.2 %/Naturall Gas- 73.6% Local Use Tax is applicable to purchases made where Illinois sales tax has not been charged and the purchase will be used or consumed in Illinois. The primary example is non-taxed internet sales. The Local Use Tax is expected to end the year at approximately 90 percent of the budgeted amount. Electricity Use Tax is nearly at the benchmark with higher usage in summer months in the second half of the year. Typically,75 percent of the annual budget of Natural Gas Use Tax revenues are received during the first six months of the year because usage is highest during the winter months. Both revenue sources will likely meet the annual budget target. Page 89 of 104 • Real Estate Transfer Tax-51.6% Receipts from the Real Estate Transfer Tax have decreased 4.7 percent from the prior year. We anticipate the revenue source will meet the annual budget target. • Telecommunications Tax-52.8% Telecommunications Excise Tax is levied at a rate of 6 percent collected by the retailer and submitted to the State of Illinois.The revenue is up $20,158 from the previousyear. The revenue source continues to decline for many municipalities as telecommunication providers receipts decrease due to many factors, including the switch from landlines to mobile phones and data packages not being subject to the tax. Revenues are expected to end the year at or slightly under budget. • Prepared Food and Beverage Tax -53.2% Revenue to date generated from the Village's 1 percent Prepared Food and Beverage Tax is $478,420 or $22,599 more than the previous year. Annual revenues are expected to exceed pre-pandemic levels for the third consecutive yea r. • Development Fees/Permits- 65.3% Construction and development related fees and licenses are in both the General and Water Funds. This revenue is a strong indicator of the development occurring in Buffalo Grove. Revenue is generated from permits, inspections, and associated development and engineering fees. Total revenue is 46 percent less than the first six months of 2023, mainly due to a large permit related to the new Clove development issued last year. • All Other Revenue This line is comprised of cable franchise, medical marijuana, storm water, sale of assets and other fees. These revenues are 48.8% of budget for the first six months ofthe year and are expected to meet the annual budget target for fiscal year 2024. a°er Ei d ei.. IIII°:' ,iii°°i d IICZeuein a qln III...III[is llll m H5,3lli Ifs The following chart is the distribution of Water & Sewer Fund revenue and performance to date. ;Sales of Water 16,041,374 7 . ° 7,222,22624% 281 0 503,319 47/0 46/0 4 93 Development Fees and Permits 116,000 53,425 46% 1,924,252 1659% -97% 1,870,827 All other Revenue 452,230 348,561 77% 180,813 344% 93% 167,748 Total 16,609,604 7,905,305 48% 9,327,291 59% 15% 1,421,986 Page 90 of 104 • Sales of Water -46.8% Revenue is typically less than 50 percent of the annual budget for the first six months of the year. Billing of residential users is two months in arrears and for commercial and multi-family customers the lag is one month. Revenue is approximately 4 percent greater than last year. • All other Revenue is at 77 percent of the annual budget as investment income is strong and the Village received a rebate from the Northwest Water Commission that is normally received later in the year. Golf lIevem m el Illh°1��IIL°m llllgmg lh"vfs Buffalo Grove Golf Club Through June 30, 2024, a total of$842,245 or 58.2 percent of the annual budget was generated in operating and non-operating revenue. Revenues are 16.4 percent higher than the same period the prior year as the weather was warmer earlier in the year than in 2023. itl IIµ u::. d�w.� m m � �' qm N w' !� ::. q'N • III II II III. 1 Greens Fees 824 000 431 857 52% 372 974 47% 16% 58,883 ,,,,,,, .. ,,,,,,„„„ Power Cart Rental 210,000 101,549 48% 99,098 44% 2% 2 450 Driving Range 160,000 90,748 57% 80,389 62%� 1300 10,359 Memberships 79,000 98,143 124% 78,766 105% 25% 19,377 Merchandise Sales 70,000 32,269 46% 28,500 43% 13% 3,769 Rent&Utility Reimbursement 66,000 49323 75% 39,187 41% 26% 1Q 136 All Other Revenue 38,000 38,357 101% 24,507 55% 57% 13,850 .mmm .,mmn nmm, .mmm . nmmh Total 1,447,000 842,245 58% 723,421 50% 160 118,824 Revenues at the golf course tend to be less than the 50 percent benchmark as the highest number of rounds are generally played in July and August. Through the midpoint of the year,17,109 rounds have been played as compared to 14,755 a year ago, an increase of 15.9 percent. Arboretum Golf Club: Arboretum Golf Club six-month operating revenue totaled $916,047 or 61.9 percent of annual budget compared to the previous year's revenue of$801,031 or 57.7 percent of the budget amount. Page 4 of 9 sin i of [)ear . 50 Raupp lBoulevard, Buffalo Grave, V1_ 60089 847-459 2500 ;�„ vbg,org W IIII I I I II II AI IIII (IIIII lUl I II IIIII , IIIII I I IIII I II'hill w �IIIII µ I Greens Fees 886,000 477,425 54% 411,530 49% 16% 65,895 Power Cart Rental 252.000 177 647 70% 127 501 53% 39% 50 145 f Memberships 114 000 123,530 108% 118,250 108% 4% 5,280 Merchandise Sales,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,60,000 45223 75% 39931 ,,,,,,,,,,,,,,,,,,71% " 13% 5292ff. J Rent&Utility Reimbursement 137 667 65 067 47% 72,175 66% 10% 7 108 . . nnnn, .,nnnn .,nnnn .,nnnn .,nnnn .,nnnn .,,,nnn .,nnnn ............................................................. lal Other Revenue 30,200 27,156 90% 31,643 101% -14% 4,488 mmm mmn mmm mmh Total 1 479 867 916 047 62% 801 031 58% 14% 115,016 To date, 14,623 rounds have been played. At the same point last year 13,482 rounds were played, a 8.5 percent increase. All Otheir Vittage Ili'eur°id IIIR veiiIil.Illles The remaining funds revenues are listed below: ,I L II IIII II IIIII I I III IIIIIII I 'il"� ""'� .�I IIII„II II II I IIII IIIII III II I I m (IIIII ullll„ i u�iVi� Parking Lot 215,200 35,216 16% 41,887 20% 16% (6 670) Motor Fuel Tax 1,814,900 914,01950% 886,301 55% 3% 27,718 ,Local Motor Fuel Tax 682,700 282,349 41% 307,096 63% 8% (24,747) Capital Pro ects Facilities 14 976 224 7 566 699 51% 4 032 689 52%° 88%° 3 534 011)JI ,Capital Projects Streets 15,036 000 7,518,000 50% 1,373,000 50% 448% 6,145,000 Debt Service 4,410,481 2,211,305 50% 2,397,982 50% 8% 186,677 Information Technology 2,330,678 1,101,497 47% 641,443 32% 72% 460,053 --------------- Central Garage 1,921,815 808,383 42%° 823,456 44% 2% 15 073 Building Maintenance 2,073,629 903,854 44% 1,005,054 55% 10% 101 200 Police Pension 11,190,1325,595,06650% 3,642,149 50% 54% 1,952,917 ,Fire 372%%06ion 84 96 453 Pens 9 030 4 518 420 50% 2 787 50 6 1 7 nnnn nnnn, nnnn nnnn �nn nnnn, nnnn nnnn nnnn nnn nnnn nnnn nnnn Refuse 1,210,560 594,526 49% 688,479 58% -14% (93,953) .mmm .,mmn nmm, .mmm Total 64,899,159 32,049,335 49% 18,620,503 50% 72% 13,428,832 The largest variancesyear overyear are: • Capital Projects are funded through operating transfers and grants and at this point half of those funds have been allocated even though all projects may not have begun at this point in the year. The budget for Capital Projects- Facilities is $15.0 million in 2024 versus $7.69 million in 2023. The budget for Capital Projects-Streets is $15.0 million in 2024 versus $2.7 million in 2023. • The revenue for Information Technology, Central Garage and Building Maintenance Funds is allocated based on what was spent instead of a pro-rated amount of 50% of what was budgeted. The Information Technology Fund has spent $1.1 million in 2024 versus $0.64 million in 2023. Conversely, the Building Maintenance Fund has spent $0.90 million in 2024 versus $1.0 million in 2023 • Police and Fire pension fund revenues are a pro-rated portion of the budget. For 2024, the budgets for both police pension and fire pension were increased, in large part due to an increase in anticipated investment income. Page 5 of 9 sii n lug t. withVi leart. 50 Raupp lBoulevard, Buffalo Grove, R.. 60089 847-459 2500 vbg,org Gel iei�'al m tfL l`111E? IIIIe ie Expenditures to date total $27,218,550 or 47 percent of the approved budget. This compares to $24,151,764 or 47.4 percent in FY 2023. General Fund expenses will likely be slightly less than the 2024 budget at year end. The following chart depicts expenditure performance: lb Personal Services 24,955,886 11,850,880 47% 11,383,411 48% 4.1% 467,468 Personal Benefits",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,12,142,473 5,613,132 46% 5,652,373 48% 1% 39 242 ,Operating Expenses 3977647 1725509 43% 1576132 44% 9% 149377 Insurance 1,307,639 1,030,090 79% 1,000,118 91% 3% 29,972 1f 1 Legal Services 440,000 138,065 31% 125,335 28% 10% 12,730 ff Committees&Commissions 149,500 46,409 31% 42,555 30% 9% 3,854 J Commodities 380,850 212,670 56% 293,714 75% 28% 81 044 ff . . Maintenance&Repair Facilities 2 064 141 706,224 34% 706,149 40% 0% 75 f Maintenance&Repair Other 58,120 12,098 21% 11,911 21% 2% 188 J Maintenance&Repair Vehicle 1,677,534 838,767 50% 1,070,162 66% 22% 231,395 Capital Equipment 1 915 731 454 0% 15 844 2% 15 390 Capital Projects 200,000 54,674 27% 26,508 13% 106% S28 165)J Operating Transfer 4,968,448 2 484 224 50% 926 000 50% 168% 1,558,224 .,,nnn .,nnnn .,nnnn .nn .,nnnn .,,nnn .,nnnn .,,,nnn .,n,nn .,nnnn .,n.,,n .,nnnn .,nnnn,,,,,. la Other Expenses 3785,445 2,505 355 66% 1,321,551 39% 90% 1,183,803 -------------------------- Total 58,023 414 27 218 550 47% 24,151,764 47% 13% 3,066,786 ��mm�m .,n............mmmm .,nnn.........mmmmmmm.. Personal Services/ Personal Benefits-47.5 percent/46.2 Personal Services is the single largest expense account category budgeted by the Village. In terms of total budget, Personal Services and Benefits account for 63.9 percent of expenditures. Salary typically trends just below the 50 percent benchmark due to the timing of payroll and the accrual of the first payroll of the year. Wage and benefit expenditures are approximately 2.5 percent more than the prior year,which is expected due to the increased budget in 2024 as compared to 2023. Most spending categories are below or at expected levels through the first six months oftheyear. Operating transfers are higher than the previousyear as the overall budget is $3.1 million higher in 2024 than in 2023. Other expenses include sales tax incentive payments. Finally, over three quarters of the entire budget for insurance is expended because the general liability and worker compensation insurance premium is paid annually in January. Water & Sewer :'��iii� Illl x w liirmsl,l�� IIII'°� 'I �r As of June 30, 2024, the Water and Sewer fund has expended 44.4 percent of its budget. Page 6 of 9 siin i It. withVileart. 50 Raupp lBoulevard, Buffalo Grave, R.. 60089 847-459 2500 vbg,org Personal Services 1,219,069 616,449 51% 552,343 46% 12% 64,106 ......................................................................................................................... Personal Benefits 432,206 228,707......53% 198,374 45% 15% 30,334 ,Operating Expenses 2,461,784 1,225,673 50% 554,424 23% 121% 671,248 ---11----------------------------------------------------------- Insurance 165,595 25 0% - 0% 25 'Commodities 4,149,100 1,319,700 32% 3,399,323 81% -61 0 � M,.................................................................................................................................................................................................................................11111111111111� � ", " Maintenance&Repair 1,325,125 463,096 35% 526,475 47% -12% Capital Project-Water 7,188,000 3,545,176 49% 263,576 12% 1245% 3,281,600 Capital Equipment 36,000 - 0% 9,932 0% - (9,932) 'Debt Service 2,590,526 1,295,213 50% 1,452,447 50% -11%...........................................................................................................(J5 1, N, Operating Transfer 830,000 415,000 50% 390,000 50% 6% 25,000 'All Other Expenses 89,661 - 0% - 0% - - ------ ----------- ----------- ---------- ---- Total 20,487,066 9,109,039 44% 7,346,893 47% 24% 1,762,146 ............... ................................................................................................................. The largest notable variances are in Commodities and Capital Projects-Water. Commodities are less because of timing of payments made to Lake County for sanitary sewer fees. Capital Projects-Water has increased because a larger volume of capital project work is budgeted and completed in 2024 as compared to the prioryear. Golf Illl ite� pirise ise 114Ieview The Buffalo Grove Golf Club and Arboretum Club combined have expended 46.3 percent of the annual budget in the first six months of fiscal year 2024. The most significant change is in capital projects as projects began much earlier in 2024 than in 2023. 'Personal Services 355,223 159,342 45% 147,774 46% 8% 11,568 .. ...................................................................................................................................................................................................................................................................................Personal Benefits 73,833 35,413 48% 34,299 47% 3% 1,115 �Operating Expenses 638,156 316,060 50% 272,354 45% 16.05% 43,706 ff Insurance 21,007 0% 0% Commodities 0% 0% Maintenance&Rep.-Facilities 150,058 64,571 43% 79,452 57% -19% 14,881 'Maintenance&Rep.-Other - - 0% - 0% - Maintenance&Rep.-Vehicles 8,500 2,873 34% - 0% - 2,873 !Capital Project-Facilities 144,000 118,829 83% 3,770 1% 100.00% 115,059 Capital Equipment 0% 0% 'Operating Transfer 0% 0% 1�4ll.................................................................................................. Other Expenses - - 0% - 0% - - ..............................................................................................- Total 1,390,777 697,088 50% 537,649 37% 30% 159,439 ............... ........................ Page 7 of 9 sii nw of Vileart. 50 Raupp lBoulevard, Buffalo Grove, R_ 60089 847-459 2500 vbg,org III IIII .0 uu mi W uu u e IP m uu III Personal Services 237,943 125,716 53% 111,459 58% 13% 14,258 Personal Benefits" 37,358 19,482 52% 18,140 53%° 7% 1,342 Operating Expenses 1,019,098 542,198 53% 405,498 40% 34% 136,700 f , Insurance ,,,,,,,,,,,,,,,,,,",,,,,,,,,,,,,,,,,,,,,",,,,,,,,,,,,,,,,,,,",,,,,,,,,,,,,,,,,,,,,",,----- 0% 0%° Commodities 0% 0%° J Maintenance&Rep.-Facilities 135,476 58,802 43% 66,941 52% 1200 8 140 Maintenance&Rep Other 0% 0% f Maintenance&Rep.-Vehicles 0% 0%0 J J ® Jf Capital Project Facilities 336 000 17 335 5% 0% 100% 17,335 J Capital Equipment 0%,,,.,,.,,.,,„„ .0% Operating Transfer 0% 0% mmmmmmmmmmmmmmm,,,nn � mmmmmm��mmm. ��... mmmmmm, mmm„ �1 All Other Expenses - 0% - 0% - Total 1,766,425 763,533 43% 602,038 39% 27% 161,495 I Ot h e iiiI Villiage I1'L,uu d III'Illllx:III' Ili rldit uui ' S41,Illla'III' 'eiiise The remaining funds are listed below: III, IIII III�I III IIII II 'i��'I I°I„I� ` Parking Lot 215,012 34,011 16% 36,731 18% 7% Motor Fuel Tax 2,461,552 1,230,776 50%%, 975,000 50% 26% 255,776 Local Motor Fuel Tax 960,000 480,000 50% 208,246 50% 130% 271,754 Capital Projects Facilities 16,505,244 8,092,915 49% 270,405 2% 2893% 7,822,510 ,Capital Projects Streets 15,036,000 3,026,402 20% 395,218 0% 666% 2,631,184 J Debt Service 4,410,481 894,653 "" 20% 1,207,469 25% 312,815 Information Technology 1,515,859 607,084 40% 641,443 0% 5% (34 359)J Central Garage 1,921,815 808,383 "" 42% 823,456 0% 2% 15 073 Building Maintenance 2,073,629 903,854 44% 1,005,054 55% 10% 101 200 ff Police Pension 6,756,000 3,378,000 "" 50% 2,825,078 0% 20% 552,922 ,Fire Pension 5,144,650 2,572,325 50% 2,282,786 0% 13% 289,539 J Refuse 1,242,320 480,216 39% 536,387 0% -10% 56,171 .mmm .,mmn nmm, .mmm min, Total 58,242,562 22,508,619 39% 11,207,273 26% 101% 11,301,346 • The Parking lot fund annual major expense for the land lease payment to Com Ed is made in the second half of the year. • The timing of construction impacts the recognition of the Capital Project Fund's expenditures. These budgets are planned and are typically spent in full. • MFT expenditures include transfers to both debt service and capital projects and are pro-rated at the six-month amount. All eligible expenses are determined at year-end and all applicable qualifying expenditures are transferred upon completion of the expense reconciliation. • The Refuse Fund is billed in arrears by SWANNC and the first quarterly payment is annually accrued back to the prior fiscal period. Page 8 of 9 sully u�t. withVi leart. 50 Paupp If oulevard, Buffallo grove, IL 60089 84;7-459...2500 vbg,org The following chart provides a snapshot of budget performance to date for various Village Funds. r«irll�lCll��lClC��r I��r � r General 33,1 550 5 12,708 27,218, 894,158 Water&Sewer„ 7,905,305 9,106,468 (1,201,163) BGGC 842,245 697,088 145,157 AGC 916,047 763,533 152,514 Parking., , Lot,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, 35,216 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, 34,011,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, 1,205 ,,, Motor Fuel Tax.. .. 914,019,,, ,,,,,,,,, ,437,500,,,,,. ,,,,,,,,476,519 Local Motor Fuel Tax 282,349 230,000 52,349 Capital Projects Facilities,,,,,,,. 8,092,915,,, ,,.,,,,,8,092,915,,,,,, ,,,,,,,,, 0 Capital Projects Streets 3,026,402 3,026,402 0 Information Technology......... 1,101,497,,, ,,,,,,,,, ,607,084,,,,,. ,,,,,,,,494,413 Central Garage 808,383 808,383 0 Building Maintenance 903,854,,, ,,,,,,,,, ,903,854 Debt Service 894,653 894,653 0 Police Pension... .. 5,595,066,,, ,,.,,,,,3,378,000,,,,,. ,,,,,2,217,066 Fire Pension 4,518,420 2,572,325 1,946,095 Refuse 594,526 480,216 114,310 Total 69,543,605 59,250,982 10,292,623 Department directors will continue to monitor spending on a monthly basis. Staff will present a series of budget amendments in tandem with the development of the FY 2025 budget. Page 9 of 9 50 Raupp lBoulevard, Buffalo grove, R.. 60089 84;7-459 2500 "' vbg,org umlli II lBUFFALO uuuuuuu IIIIII uuuuuull uuumuuum uuuuuuu uuml BUFFALO GROVE VILLAGE BOARD Gl�,IIZQVE I Committee of the Whole: August 5, 2024 AGENDA ITEM . . 2024 Preliminary Tax Levy Contacts Liaison: Trustee Bocek Staff: Chris Black Staff Recommendation Staff recommends discussion. Summary See attached memorandum. Strategic Alignment Guiding Principle Principle 1: Financially Responsible and Sound Goal Goal 1: Maintained effective village government: fiscally responsible and providing outstanding, responsive services File Attachments 1. COW 8.5.24 Preliminary Tax Levy Page 1 of 1 i rha iif1.v I'd Il ea it. 50I5laupp Blvd, Buffalo(-",xrove, IHI 60089 °,,: 847-459-2SOO,,s vk.g.org ��olsoll BUFFALO III G�OVE DATE: August 5, 2024 TO: Village Manager Dane Bragg FROM: Chris Black, Finance Director SUBJECT: Proposed Tax Levy 2024 '' COMM N ..i.. IIII'"� IIII Staff recommends consideration of total levy prior to abatement of $21,452,086, a 1.2 percent increase from the prior year. With the proposed abatements, the proposed net levy is $17,444,5471, an increase of1.9 percent or $329,006 year-over-year. Staff recommends an abatement of $4,007,S39 consisting of $566,925 on the series 2012 bonds, $383,631 on the Series 2016 Bonds, $2,243,900 on the Series 2020 bonds, and $813,083 on the Series 2022 bonds. IIL 1"„`III��"CIIII'�i" 1�III 'IIII' I n conjunction with the development of the FY 2025 Village Budget,staff is developing a recommendation for the FY 2024 Property Tax Levy to be extended and collected in 2025. The current year's levy (2023 Tax Levy/collected in 2024) is $21,187,752, minus abatements of $4,072,211, resulting in a net levy of $17,115,541. The net levy was at the same level as the prior year for an increase of 0.0 percent. The components of the change were the following: ® ® ® ® ® ® ® ® ® ® ® IIIII IIn III m nn n .. 0.0% llllln, m nu �, nw °" 0.0% m nlu nw 0.0% IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII -7.2% y IIII" ... �„ ��:��ll4oiii��f�y'IIL"' 7�°: Ill��ev�� iii :Dili �°��o� Jl� a��°��,�u�iii��c°m��iii��.�� ... Ill...11iii��:e cin&i ion Since this preliminary request is being developed early in the budget process and prior to having a full understanding of general fund revenue needs,staff is presenting three scenariosthat increase propertytax revenuesfor operations by1.9 percent,3.0 percent, and 4.0 percent. Page 1 of 5 siin i�It. with Vi ear . SO Paupp l oulevard, Buffalo grove, R.. 60089 ,;;,. 847-459-2S00 "„ vbg.org In the first scenario the village would set the levy amount to obtain taxes on new property and annexations that have occurred since 2019, the last time the village increased the property tax levy. The village has experienced approximately $38.2 in new property growth, $37.7 million in Lake County, over the last five years. Since the village has not increased the tax levy during the time period, the growth in new property has effectively lowered property taxes on the village portion of the tax bill for existing property owners. The amount of the increase attributable to new property totals $329,006. This was calculated by multiplying last's years village tax rate by the amount of new property growth. This results in a proposed levy (prior to abatement consideration) of $21,452,086 or a 1.2 percent change would result in a 1.9 percent increase in the property tax levy after abatement consideration. The components of the change are as follows: Table 1.1.9%Increase Scenario IIIIII ° n n IIIIIIIIIIIIIIIII 3.6% $329,006 IIIIII ' �w �W nn 0.0% $0 IIIIIIC"" 0.0% $nn mi m lu nn a n_ IIII iii�m m -1.5% $64,672 A proposed levy (prior to abatement consideration) of $21,636,546 or a 2.1 percent increase would result in a 3.0 percent increase in the property tax levy after abatement consideration. The components of the change are as follows: Table 2.3.0%Increase Scenario ® s m d s® 513 466 Illlll�n�� n n�� . s,6�ra , Illllln n iii° n 0.0% $0 0.0% $0 nn m a m nn m i_ IIIIII!!!� n� =IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII —1.5% $64,672 A proposed levy (prior to abatement consideration) of $21,807,701 or a 2.9 percent increase would result in a 4.0 percent increase in the propertytax levy after abatement consideration. The components of the change are as follows: Table 3.4.0%Increase Scenario IIIIIII�� IIIIIIIIIIIIIIIIIIIIIIII 7,5°� $684,621 IIIIII �� I I.� � � n�� 0.0% $0 un i m im IIII un m u IIIIIIQM �� °�°��I�un m� m m ua lu i. III w � i u 0.0% $0 1111111111,11 i,S SOMEONE. -7.2% -$64,672 Page 2 of 5 sii,n i�I of [ie r . 50 Raupp Boulevard, Buffalo grove, R.. 60089 ,;;,. 847-459-2500 "„ vbg.org The purpose of this preliminary report is to present the levy including the full debt service amount (principal and interest) prior to discussion about tax abatement. The final levy will be adjusted contingent upon capacity within the budget for a supplemental transfer of recurring revenues to lower the gross tax extension amount. Coiiqlpx:�iirate Ill ev The amount requested of$9,500,994 represents an increase of3.6%from the prioryear for the Corporate Levy which is used to support public safety operations. The Village usesthe Municipal Cost Index (MCI) to measure inflation.The MCI is a composite index that adjusts to the cost of materials and supplies, wages and contracted-for services. The composite index includes the Consumer Price Index, Producer Price Index, and a construction cost index. The MCI for the annual period ending May 2024 is - 2.1% percent. Ilh °m 'Seiii.v'ice The current year's debt service requirement was $4,407,408 Next year's debt service is $4,342,808. The debt service payment on the Series 2020 Bonds declines $80,000. The components of the debt payments are as follows: . _ ® (IIIIII II I� IIII II III II II �� III III�I��II ll��n u II I Iln III (IIIIII $566,925 13.0% IIIIII IIII u I III IIII IgI��ISp `h III I m li I IIII I II ml 11 A�III i0 Ili Itl l IIIIII $383,631 8.[8�(}l(}%� $255,702 5.✓ IIIIII IIII II II III IIII III III 'I III I III I�In ,. �I II a m. �II4 IIIY nn ,w @, m n u n nnl I u lIn nn a IYIn nn�ml(�I �p IIIIII III II II II IIII I�IIIII� I II III II II IIII II �m III I III II I Ihlllll II III Ihl IIII $2,243,900 51.7% III l II iil ill,IIII(IIII IIII Illu III nl III lil II III Iln II III I 892,650 20.6 f The Village will make debt service payments on five existing bond issues in 2025. The Village has committed a combination of general fund revenue and water/sewer revenue to service both the 2020 Bonds and 2022 Bonds. When factoring in these abatements, the debt service levy has not increased everyyear since 2019. fIeiirms )ins An independent actuary calculates the amount to be levied for both the Police and Fire pension funds on an annual basis. In the past, the Village has funded above the actuarily required contribution if financially feasible while maintaining a stable property tax levy. The Village's history of meeting its annual pension funding obligations and high funding levels is an important element to our AAA bond rating. The proposed levy is above the actuarily required contribution for the third consecutive year. For the 2023 levy (collected in 2024) the property tax levies for police and fire pension were $554,700 greater than the required contribution for the two pension funds. For 2024 levy,the proposed Firefighter Pension Levy is$2,371,240 and the Police Pension Levy is $3,446,992. The total combined amount for the police and Page 3 of 5 shin l�I of [ile ri . 50 Raupp lBoulevard, Buffalo Grove, R.. 60089 ,;;,. 847-459-2500 "„ vbg.org fire pension levies is $5,818,162, the same as the prior year, and $376,700 above the required contribution for the two funds. In future years,the Village will be required to increase the levy for police and fire pensions. As recent as the 2020 Levy, the combined required contribution for police and fire pensions increased $604,300. The additional contribution will allow the Village to lessen the impact of reduced investment returns projected in the upcoming years and possibly mitigate volatility in future police and fire pension contributions. The Village Board has successfully used this approach in the past to moderate future tax levy spikes. The Illinois Municipal Retirement Fund (IMRF) calculates the employer portion of the pension. The IMRF and Social Security portion of the levy will remain the same as the prior year. Assessed Values 'IIII The Village's EAV increases by an estimated 5.25 percent for the 2023 levy (collected in 2024). The EAV is not available for the portion of the village located in Cook County. The total EAV in Buffalo Grove is estimated at$1.9 billion.The change between the two counties was disproportionate as Lake County increased by 6.46 percent and Cook County is estimated to increase by 1.0 percent. EAV calculations reside with each county's assessor's office. Lake County properties are assigned 80 percent of the total property tax burden for the Village. The final percentage allocation is assigned by the Illinois Department of Revenue. Below is a graph depicting the growth of EAV over the last ten years. EAV 2014 - 2023 2,500 ® 2,000 1,816 1, 2 1,917 1,614 1,660 1,687 1,785 1,749 1,500 1,425 1,476 1,000 500 0 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 Page 4 of 5 siin i It. with [ie r . 50 Raupp lBoulevard, Buffalo Grove, R.. 60089 ,;;,. 847-459-2500 "„ vbg.org N 11 ySIS The tentative proposed levy based on the first scenario detailed earlier in the memo, prior to abatement, of$21,452,086 or a 1.2 percent change. At this point in the process the gross levy appears as follows: County Tax Burden 20.00% 80.00% 100.00% 100.00% .............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................. Tax Levies: ............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................ Police Protection 799,560 3,198,241 3,668,795 3,997,801 ............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................ Fire Protection 1,100,639 4,402,554 5,503,193 5,503,193 i M W IMRF/Social Security 358,024 1,432,098 1,790,122 1,790,122 Corp. Purpose Bonds Roads(2012) 113,385 453,540 555,925 566,925 ............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................ Corp. Purpose Bonds Roads(2016) 76,725 306,905 379,931 383,631 2019 Series GO Bonds 51,140 204,563 255,074 255,702 ............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................ 2020 Series GO Bonds 448,780 1,795,120 2,323,900 2,243,900 ............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................ 2022 Series GO Bonds 178,530 714,120 892,650 892,650 ............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................ Police Pension 689,384 2,757,538 3,794,077 3,446,922 Fire Pension 474,248 1,896,992 2,024,085 2,371,240 i ME i i Staff recommends an abatement of $4,007,539 consisting of $566,925 on the series 2012 bonds, $383,631 on the Series 2016 Bonds, $2,243,900 on the Series 2020 bonds, and $813,083 on the Series 2022 bonds. With the proposed abatements,the proposed net levy is $17,444,547, an increase of 1.9 percent or $329,006 year-over-year. It should be noted a percentage increase or decrease in the levy does not equal the change in a homeowner's tax bill, depending upon growth in EAV and redistribution of assessed values across different real estate types (residential, industrial,commercial, and agricultural). III IIIw IIII J��IAC..I.. The proposed net levy is $17,444,547, provides an increase of 1.9 percent or $329,006 year-over-year in property tax revenue. IIIII X:""'III""" ""'III"""IIIII III, This proposed tax levy request will be formally made at the November 41h board meeting as part of the truth-in-taxation resolution. The truth-in-taxation levy growth (which excludes debt service) is estimated to be 1.9 percent. A public hearing will not be required. Page 5 of 5 sign l�I of [sear . 50 Ra u p p Boulevard, Buffalo Grove, l i_ 60089 ,;;,. 847-459-2500 "„ vbg.o rg umlli II lBUFFALO uuuuuuu IIIIII uuuuuull uuumuuum uuuuuuu uuml BUFFALO GROVE VILLAGE BOARD Gl�,IIZQVE I Committee of the Whole: August 5, 2024 AGENDA ITEM .a. Executive Session - Section ( )( )of the Illinois Open MeetingsAct: Collective Negotiating Matters Between the Public Body and Its Employees or Their Representatives,or Deliberations Concerning Salary Schedules for One or More Classes of Employees. Contacts Liaison: President Smith Staff: Dane Bragg Staff Recommendation Staff recommends move to Executive Session. Summary Executive Session - Section 2(C)(2) of the Illinois Open Meetings Act: Collective Negotiating Matters Between the Public Body and Its Employees or Their Representatives, or Deliberations Concerning Salary Schedules for One or More Classes of Employees. Strategic Alignment Guiding Principle N/A Goal N/A File Attachments None Page 1 of 1 i:h uur . I'd Il ea it . 50I5laupp Blvd, Buffalo(-",xrove, IHI 60089 °,,: 847-459-2SOO,,s vk.g.org umlli II lBUFFALO uuuuuuu IIIIII uuuuuull uuumuuum uuuuuuu uuml BUFFALO GROVE VILLAGE BOARD Gl�,IIZQVE I Committee of the Whole: August 5, 2024 AGENDA ITEM . . Executive Session - Section ( )( )of the Illinois Open MeetingsAct: ( )the Purchase or Lease of Real Property for the Use of the Public Body, Including Meetings Held for the Purpose of Discussing Whether a Particular Parcel Should be Acquired. Contacts Liaison: President Smith Staff: Dane Bragg Staff Recommendation Staff recommends move to Executive Session. Summary Executive Session - Section 2(C)(5) of the Illinois Open Meetings Act: (5) the Purchase or Lease of Real Property for the Use of the Public Body, Including Meetings Held for the Purpose of Discussing Whether a Particular Parcel Should be Acquired. Strategic Alignment Guiding Principle N/A Goal N/A File Attachments None Page 1 of 1 i:h uur .v I'd Il ea it . 50 I5laupp Blvd, Buffalo(-",xrove, IHI 60089 °,,: 8,6.7-459-2S00,/,/s vk.g.org