RecordWell Data

Packet

Walworth County · Walworth County · meeting of Nov 19, 2026 · Agenda packets

Open the original document More from Walworth County

Text

Extracted automatically from the original. Tables and formatting may not survive; the original document is authoritative.

November 19, 2026 Finance Committee Agenda NOVEMBER 19, 2026 FINANCE COMMITTEE AGENDA.PDF November 19, 2026 Finance Committee Packet NOVEMBER 19, 2026 FINANCE COMMITTEE PACKET-ONLINE VERSION.PDF 1. Documents: 2. Documents: Walworth County Finance Committee MEETING NOTICE Thursday, November 19, 2026 10:00 AM County Board Room 114 Walworth County Government Center 100 W. Walworth St., Elkhorn, Wisconsin Sheila Reiff, Chair Dennis Karbowski, Vice-Chair Supervisor Kathy Ingersoll Supervisor Joseph Schaefer Supervisor Tyler Schneider (Posted in compliance with Sec. 19.84, Wis. Stats.) A quorum of the Health & Human Services Board and Lakeland Health Care Center Board of Trustees will be in attendance. It is possible that a quorum of the County Board or any of its other committees could be in attendance at this meeting. Agenda enclosures are available upon request from the County Administrator’s Office or on the County’s web page (www.co.walworth.wi.us). A G E N D A Note: All agenda items are subject to action. 1. Call to order 2. Roll call of committee members 3. Agenda withdrawals, if any 4. Agenda approval 5. Approval of minutes A. October 22, 2026, Finance Committee Meeting (encl. pp. 1-6) 6. Public comment period 7. Consent Items A. Budget Adjustments and Transfers NOTICE: THIS MEETING IS PLANNED TO PROVIDE FOR REMOTE OR OFF -SITE ATTENDANCE BY COMMITTEE MEMBERS. THE PUBLIC CAN WATCH THE MEETING STREAMING LIVE AT https://bit.ly/2026NovFIN Individuals wanting to provide a Public Comment can do so in person or remotely by telephone. Those wishing to comment by telephone must contact the County Administrator’s Office at 262-741- 4357 on the day of the meeting and at least 15 minutes prior to the start of the meeting to obtain instructions. AGENDA – Walworth County Finance Committee Thursday, November 19, 2026, at 10:00 AM Page 2 of 3 1. Children with Disabilities Education Board (CDEB) a. Adjust for a portion of revenue shortfalls regarding general aid and tuition payments (encl. pp. 7-8) b. Adjust for substitute teacher and aide needs (encl. p. 9) 2. Health and Human Services and Risk Management Fund a. Prepay 2026 liability claims and increase Risk Management Fund revenues (encl. pp. 10-11) 3. Health and Human Services a. Reallocate Fit Family Grant revenues and expenditures to Special Supplemental Nutrition Program for Women, Infant, and Children (WIC) Grant Program (encl. pp. 12-13) 4. Lakeland Health Care Center a. Adjust for exhaust fans replacement (encl. p. 14) b. Adjust for Food and Nutrition casual and pool staff payroll costs (encl. pp. 15-16) c. Adjust for therapy expenses from increased resident census (encl. p. 17) d. Adjust for overtime coverage (encl. p. 18) 5. Recovery Grants Fund a. Adjust for design/installation of davit crane at Law Enforcement Center (encl. p. 19) 6. Sheriff’s Office a. Adjust for projected shortfall in Prisoner Transport overtime (encl. p. 20) b. Adjust for projected shortfall in Corrections food costs (encl. p. 21) B. Purchasing Request for Approval 1. Contract award recommendation for the County’s Stop Loss Insurance for the Health Insurance Fund (encl. pp. 22-33) C. Reports 1. Update on tax incremental financing districts (TIDs) (encl. pp. 34-35) 2. Sales tax report – August 2026 (encl. p. 36) 3. Quarterly investment report – 3rd quarter 2026 (encl. pp. 37-39) 4. Out-of-state travel a. Finance 1. C. Holt, National Institute of Public Procurement Forum, Columbus, OH (encl. pp. 40-41) b. Public Works 1. E. Sturtevant, Illinois Public Service Institute, Effingham, IL (encl. p. 42) 8. New Business A. Walworth County Housing Authority Update on Affordable Housing and Potential Memorandum of Understanding (MOU) Extension (encl. pp. 43-45) B. Res. No. **-12/26 Authorizing the Addition of the Substance Use Prevention, Treatment, and Recovery Services Block Grant Supplemental Award to Previously Established Pre-Approved Recurring Grants List (encl. pp. 46-47) AGENDA – Walworth County Finance Committee Thursday, November 19, 2026, at 10:00 AM Page 3 of 3 C. Res. No. **-12/26 Authorizing the Addition of the Community Mental Health Block Grant Supplemental Award to Previously Established Pre-Approved Recurring Grants List (encl. pp. 48-49) D. Res. No. **-12/26 Authorizing the Public Works Department to Apply for the Federal Recreational Trails Program Grant (RTP) and Adding the Grant to Previously Established Pre-Approved Recurring Grants List (encl. pp. 50-52) E. 2027 Strategic Planning Discussion 1. Updated Strengths, Weaknesses, Opportunities, and Threats (SWOT) Analysis (encl. pp. 53-63) 2. 2027 Updated Strategic Plan Overview (encl. pp. 64-68) 3. Res. No. **-12/26 Approving the Updated 2027 Strategic Plan Overview (encl. pp. 69-71) 4. Potential Request for Special Committee of the Whole Meeting in March 2027 Regarding Examples of the Extent of County Budgetary Control F. Opportunity to Provide Feedback Regarding Reporting of Capital Improvement Plan Budget Information (encl. pp. 72-92) G. Money Market Investment Opportunity (encl. pp. 93-94) 9. Announcements and Updates A. Finance Department Announcements and Updates (encl. pp. 95-96) B. American Rescue Plan Act (ARPA) Financial Update (encl. pp. 97-99) C. Announcements and Correspondences by Chairperson 10. Set/confirm next meeting date and time – Thursday, December 17, 2026, at 10:00 a.m., County Board Room 114 at the Government Center 11. Adjournment Submitted by: Sheila Reiff, Committee Chairperson Jessica Conley, Finance Director Posted: November 12, 2026 DRAFT Walworth County Board of Supervisors Fin ance Committee Meeting Minutes Thursday, October 22, 2026 Walworth County Government Center, County Board Room 114 100 West Walworth Street, Elkhorn, Wisconsin Vice-Chair Dennis Karbowski called the meeting to order at 10:00 a.m. R oll call was conducted and the following members were present: Chair Sheila T. Reiff; Vice-Chair Dennis Karbowski; Supervisors Kathy Ingersoll, Joseph Schaefer, and Tyler Schneider (Present at 10:06 a.m.). A quorum was declared. O thers in Attendance County Staff: Walworth County Administrator Mark W. Luberda; Corporation Counsel/Director- Land Use and Resource Management Michael Cotter; Director-Finance Jessica Conley; County Treasurer Valerie Etzel; Clerk of Courts Michele Jacobs; Business Office Supervisor Kristina Secord; and Director-Special Education Matthew Huettl On motion by Vice-Chair Karbowski, second by Supervisor Schaefer, the agenda was approved with no withdrawals. On motion by Supervisor Ingersoll, second by Vice-Chair Karbowski, the September 17, 2026, Finance Committee meeting minutes were approved. P ublic Comment – There was none. C onsent Items 7A. Budget Adjustments and Transfers 1. Capital Projects and Land Use and Resource Development a. Transfer for new 2026 capital project - Comprehensive Land Use Plan 2029 Update Director-Finance Jessica Conley discussed the Memorandum and amendment included on Pages 6-7 of the packet. Conley indicated LURM is seeking authorization to create a capital project for 2026 and initiate a $25,000 budget amendment to commission Southeastern Wisconsin Regional Planning Commission (SEWRPC’s) services for the plan update. Supervisor Ingersoll offered a motion, second by Supervisor Schaefer, to approve Item 7A.1.a. Motion carried 4-0 . 2. C hildren with Disabilities Education Board (CDEB) a. Adjust for contracting vision impaired teacher position Vi ce-Chair Karbowski offered a motion, second by Supervisor Ingersoll, to approve Item 7A.2.a. Motion carried 4-0. 3. P ublic Works-Highway a. Adjust for forecasted increase in fuel costs 4. S heriff’s Office a. Adjust for forecasted increase in fuel cost Supervisor Schaefer offered a motion, second by Vice-Chair Karbowski, to approve Items 7A.3a. and 7A.4.a. Motion carried 4-0. 1 of 99 Walworth County Board of Supervisors October 22, 2026 Finance Committee Meeting Minutes Page 2 of 6 7B. Purchasing Requests for Approval 1. Finance: Non-Project Contract Re-issuance Approval for Investment Advisor for Other Post- Employment Benefits 2. Information Technology: Proposal Award Recommendation for Service, Asset, and Project Management Software 3. Public Works: Non-Project Contract Re-issuance Approval for Janitorial Cleaning Services 4. Public Works: Qualification Award Recommendation for Emergency Mitigation Services Vice-Chair Karbowski offered a motion, second by Supervisor Ingersoll, to approve Item 7B.1., 7B.2., 7B.3., and 7B.4. Conley explained Item 7B.1., regarding the reissuance of the Investment Advisor contract for Other Post-Employment Benefits, was returned to the Finance Committee. She said the Finance Department plans to revisit this annually. Conley noted the County benefits from working with the current advisor and recommended continuing the partnership unless a change is needed, in which case there would be time to seek alternatives. Walworth County Administrator Mark W. Luberda summarized Item 7B.4., the Emergency Mitigation Services contract, as a proactive step by Public Works and Director Hough to ensure the County can respond quickly to disasters. With prescreening and evaluation already done, the County can immediately secure a contract and begin recovery if needed. Motion carried 4-0. 7C . Purchasing Reports 1. Ordinance Exempt Procurement a. Clerk of Courts: Court Appointed Attorney Clerk of Courts Michele Jacobs spoke on Item 7C.1.a., included on Page 28 of the packet, noting the Clerk of Courts has a number of attorneys under contract. The $150,000 listed on the Purchasing Report is an estimate for the first year and the four contract extensions. The cost varies by attorney and depends on how many cases they take, and the time spent on the cases. Jacobs said she estimates the Clerk of Courts would spend approximately $30,000 per year in fees at a rate of $100 per hour. This amount is charged to the Clerk of Courts on a monthly invoice. 2. Waiver of Competition a. Lakeland Health Care Center: Point Click Care module upgrades There were no questions on this item, and no action was needed by the Committee. 7D . Reports 1. Update on tax incremental financing districts (TIDs) Conley referenced her Memorandum, included on Pages 35-36 of the packet. She provided an update on the Village of Fontana and the City of Elkhorn’s annual meeting. She noted that at the City of Elkhorn meeting, there was a discussion of the amendment for TID #5; stating that she intends to vote affirmative on that TID today. Conley also provided updates on the Village of Bloomfield TID#1 Annual JRB Meeting and the Village of East Troy Annual JRB Meeting. 2. Sales tax report – July 2026 3. Quarterly property loss report – 3rd quarter 2026 4. Quarterly delinquent tax report – 3rd quarter 2026 5. Report on County owned property sales County Treasurer Valerie Etzel referenced the Report on County owned property sales, included on Page 49 of the packet, noting the report contained the last two parcels the County owns 2 of 99 Walworth County Board of Supervisors October 22, 2026 Finance Committee Meeting Minutes Page 3 of 6 through tax foreclosures. She stated, as of yesterday, both have been paid and transferred to the new owners. Etzel requested the Finance Committee accept the report. Supervisor Ingersoll offered a motion, second by Supervisor Schaefer, to approve Item 7D.5. Motion carried 5-0. 6. Report on related revenue budget amendments under $25,000 – 3rd quarter 2026 Conley explained the Report on related revenue budget amendments under $25,000 – 3rd quarter 2026, included on Pages 50-51 of the packet, pertains to HHS grants. When the Treasurer prints things for different departments, their revenues go up and the cost has to be offset from other departments. Conley highlighted the following: Lakeland Health Care Center (LHCC) had some increases in both expenses and revenues related to Medicare; Transit had a change related to a grant; Children with Disabilities Education Board (CDEB) had some additional insurance recovery; and UW Extension had some program charges. Conley explained that is why there were both increased revenues and expenses in each of the scenarios. 7. Out-of-state travel a. Finance 1. C. Holt, National Institute of Public Procurement Forum, Columbus, OH b. Health and Human Services c. P. Gladden et al., Netsmart Connections Conference, Denver, CO Information Technology 1. D. Joseph, FalCon Conference, Las Vegas, NV Vice-Chair Karbowski offered a motion, second by Supervisor Schaefer, to approve Item 7D.a.1., 7D.b., and 7D.c.1. Supervisor Ingersoll noted the discrepancy in Item 7a.1., the report stated C. Holt left and returned on the same day, with a hotel cost of $965.56. Conley stated she would get the Report corrected and bring it back to the Finance Committee next month. The following amendment was added to the motion: an amendment to 7D.a.1. to bring back the correction next month. Motion carried 5-0. New Business 8A. 2027 Preliminary Budget (An additional opportunity for discussion or to propose amendments, if any), including but not limited to the following 1. Additional Budget Highlights 2. County Budget Dashboard and Strategic Plan Websites 3. Amendment A: Add CDEB Special Education Aide (1.0 FTE) 4. Other Proposed Amendments from Supervisors or Committees (if any) Conley noted that one transfer was not correctly identified between two departments of one of the staff related to the Treatment Alternatives and Diversion Program. This transfer was moved from Clerk of Courts to Health and Human Services (HHS). This was not disclosed in the first version. She indicated that the transfer is correct in the preliminary book. Conley highlighted the three new budget highlights: #13 – Sheriff’s Office Budget Overview and Highlights; #14 – Government Center Project Components in the CIP; and #15 – Examples of the Extent of County Budgetary Control. Conley stated there was a presentation at the Executive Committee for the Sheriff’s Office Budget Overview and Highlights. 3 of 99 Walworth County Board of Supervisors October 22, 2026 Finance Committee Meeting Minutes Page 4 of 6 Luberda introduced and thoroughly explained the process and steps involved in Item #15, Examples of the Extent of County Budget Control, which is a guide for supervisors and department heads preparing for the 2028 budget development. Luberda explained unless he hears differently from the County Board or Committees, he will proceed as discussed and come back to the Finance Committee to formally ask for its support for a targeted March Committee of the Whole on the controlled service contraction and the 2028 budget. He concluded by stating this explanation gives the Finance Committee the next step of where he sees the budget development process after approval of the 2027 budget. C onley discussed Item 8A.2., County Board Dashboard and Strategic Plan Websites, indicating the sites are available to view. She stated her presentation will focus on pointing people to the website, the 2027 dashboard, and the strategic plan. She highlighted the layout of the sites and demonstrated how to navigate the websites. Corporation Counsel/Director-Land Use and Resource Management Michael Cotter emphasized that department heads are relying heavily on the Finance Committee and County Board for guidance during the challenging 2028 budget process. Armed with helpful planning tools from Luberda’s presentation, he urged the board to remain creative, ask questions, explore new ideas with an open mind, and take advantage of the ample time available to navigate the upcoming budget. C onley discussed Item 8A.3. Amendment A: Add CDEB Special Education Aide (1.0 FTE). She stated the aide position is required for a new tuition-based student based on the student’s individual education program (IEP). She explained that in 2027, part of the aide position will be funded through tuition revenue, and partially by use of fund balance. The following year, the Finance Committee will start to see the tuition coming in for the full school year. Director-Special Education Matthew Huettl explained this a unique situation because it is for a tuition student. The forwarding school is Lakeland School’s funding source. If the student leaves Lakeland School, the aide position is eliminated. Supervisor Schaefer offered a motion, second by Supervisor Schneider, to recommend including Item 8A.3. in the 2027 budget. Motion carried 5-0. Conley concluded by stating that next month, staff will bring forward the draft of the Strengths, Weaknesses, Opportunities, and Threats (SWOT) Analysis, and a draft of the Strategic Plan. 8B . Ord. No. ****-11/26 Amending Section 30-286 of the Walworth County Code of Ordinances Relative to Fees Vice-Chair Karbowski offered a motion, second by Supervisor Ingersoll, to approve Item 8B., the resolution Amending Section 30-286 of the Walworth County Code of Ordinances Relative to Fees. Motion carried 5-0. 8C . Res. No. **-11/26 Adopting the 2027 Appropriation of the Walworth County Budget and Capital Improvement Plan and Approving Years One Through Five of the 10-Year Capital Improvement Plan Supervisor Schaefer offered a motion, second by Supervisor Schneider, to approve Item 8C., the resolution Adopting the 2027 Appropriation of the Walworth County Budget and Capital Improvement Plan and Approving Years One Through Five of the 10-Year Capital Improvement Plan. Conley explained she redlined this Resolution to highlight pertinent information and information forthcoming for full consideration by the full County Board. Motion carried 5-0. 4 of 99 Walworth County Board of Supervisors October 22, 2026 Finance Committee Meeting Minutes Page 5 of 6 8D. Res. No. **-11/26 Establishing the County Tax Levy to Support the 2027 Budget Appropriation Vice-Chair Karbowski offered a motion, second by Supervisor Schaefer, to approve Item 8D., the resolution Establishing the County Tax Levy to Support the 2027 Budget Appropriation. Motion carried 5-0. 8E . Res. No. **-11/26 Delaying Increase in Current Active Employees’ Share of Health Insurance Premium Equivalents for the First Four Months of 2027 and Amending the Budget to Transfer 2026 General Fund Salary Reserves to the Health Insurance Fund and Decrease the 2027 Health Insurance Fund Revenues Supervisor Schaefer offered a motion, second by Supervisor Schneider, to approve Item 8E., the resolution Delaying Increase in Current Active Employees’ Share of Health Insurance Premium Equivalents for the First Four Months of 2027 and Amending the Budget to Transfer 2026 General Fund Salary Reserves to the Health Insurance Fund and Decrease the 2027 Health Insurance Fund Revenues. Motion carried 5-0. 8F . Res. No. **-11/26 Authorizing the Creation of a 1.00 FTE Special Education Aide Position at Lakeland School Supervisor Ingersoll offered a motion, second by Supervisor Schneider, to approve Item 8F., the resolution Authorizing the Creation of a 1.00 FTE Special Education Aide Position at Lakeland School. Motion carried 5-0. 8G . Res. No. **-11/26 Authorizing Acceptance of Community Project Funding/Congressionally Directed Spending (CPF/CDS) Grant Supervisor Schneider offered a motion, second by Supervisor Schaefer, to approve Item 8G., the resolution Authorizing Acceptance of Community Project Funding/Congressionally Directed Spending (CPF/CDS) Grant. Motion carried 5-0. 8 H. Res. No. **-11/26 Accepting a Non-Cash Donation of $20,000 from the K9 Hudson Memorial for the Support of the Sheriff’s Office K-9 Unit and Authorizing Related Budget Amendment Supervisor Ingersoll offered a motion, second by Supervisor Schneider, to approve Item 8H., the resolution Accepting a Non-Cash Donation of $20,000 from the K9 Hudson Memorial for the Support of the Sheriff’s Office K-9 Unit and Authorizing Related Budget Amendment. Motion carried 5-0. 8I . Res. No. **-11/26 Authorizing the Transition of Alzheimer’s Family Caregiver Support Program (AFCSP) Funding Distribution from Wisconsin Department of Health Services (DHS) to the Greater Wisconsin Agency on Aging Resources (GWAAR) Supervisor Schneider offered a motion, second by Supervisor Ingersoll, to approve Item 8I., the resolution Authorizing the Transition of Alzheimer’s Family Caregiver Support Program (AFCSP) Funding Distribution from Wisconsin Department of Health Services (DHS) to the Greater Wisconsin Agency on Aging Resources (GWAAR). Motion carried 5-0. 8J . Resolutions Committing Available Fund Balances and Designating Available Net Positions Conley explained these resolutions will allow you to take last year’s 2025 year end returns and put them in the different reserves that the Finance Department is recommending in front of you. 5 of 99 Walworth County Board of Supervisors October 22, 2026 Finance Committee Meeting Minutes Page 6 of 6 1. Res. No. **-11/26 Committing Children with Disabilities Education Board Available Fund Balance 2. Res. No. **-11/26 Authorizing Internal Allowances for Lakeland Health Care Center Available Net Position 3. Res. No. **-11/26 Committing General Fund Available Fund Balance and Authorizing Budget Amendment for Related Transfers Vice-Chair Karbowski offered a motion, second by Supervisor Ingersoll, to approve Item 8J.1., the resolution Committing Children with Disabilities Education Board Available Fund Balance, Item 8J.2., the resolution Authorizing Internal Allowances for Lakeland Health Care Center Available Net Position, and Item 8J.3. the resolution Committing General Fund Available Fund Balance and Authorizing Budget Amendment for Related Transfers. Motion carried 5-0. Announcements and Updates 9A. Finance Department Announcements and Updates Conley referenced the Memorandum, included on Pages 185-186 of the packet, which provided current updates on special projects, regulatory updates, and staffing updates. Discussion ensued. 9B. American Rescue Plan Act (ARPA) Financial Update Conley referred to and provided details of the Memorandum, included on Page 187 of the packet. She highlighted and gave details of the remaining project, the Lakeland Animal Welfare Society (LAWS) Animal Shelter Small Animal Cages. 9C. Announcements and Correspondences by Chairperson There were none. Confirmation of next meeting date and time: The next meeting was confirmed for Thursday, November 19, 2026, at 10:00 a.m. Adjournment On motion and second by Supervisor Schneider and Vice-Chair Karbowski, Chair Reiff adjourned the meeting at 10:49 a.m. _________________________________________________________________________________ Submitted by Kathleen Aukland, Administrative Assistant. Meeting minutes are not considered final until approved by the Finance Committee at the next regularly scheduled meeting. 6 of 99 *NOTICE OF APPROVAL* This Finance Committee Budget Adjustment or Transfer document has been approved by Finance Department staff as to account information and form. Budget Adjustment or Transfer approved by Finance Committee on ________________________. Preparer: Lauren Kuntz Budget Adjustments, Transfers, and Amendments Form 1-215-B Walworth County Finance Committee Budget Adjustment or Transfer Reference Number: 110015 Department: Approvers: COUNTY ADMINISTRATOR Mark Luberda FINANCE DIRECTOR Jessica Conley CHILD. W/ DISAB. ED BD Matt Huettl Amendment Type: FC ADJ Posting Month/Year: 11/2026 Reason for Request: Department: Children with Disabilities Education Board (CDEB) The purpose of this budget amendment is to address a portion of the revenue shortfalls related to both General CDEB aid and tuition payments. The County is experiencing a $150,000 shortfall in General CDEB aid due to lower -than-expected payments, along with a $263,000 shortfall in tuition revenue. A portion of the General CDEB aid shortfall, totaling $30,000, was previously addressed through July Finance Committee Budget Amendment 70038, which increased interest revenue in response to higher-than-anticipated interest earnings. September Finance Committee Budget Amendment 90007 addressed an additional $65,000 by reallocating salary contingency funds that had been budgeted for the salary study, which is no longer expected to be implemented until 2027. This budget amendment addresses an additional $53,219 by increasing interest revenue and utilizing summer school savings that resulted from budgeting for three weeks of summer school when only two weeks were ultimately held. After this amendment is applied, the remaining unaddressed General CDEB aid shortfall will be $0. Tuition revenue was lower than anticipated, in part because several new tuition students began attending later than originally budgeted. A portion of the tuition revenue shortfall, totaling $57,000, was previously addressed through September Finance Committee Budget Amendment 90007, which reallocated transportation funds that had been reserved in the event a tuition student required transportation services. This budget amendment addresses an additional $30,432 by increasing interest revenue due to higher-than anticipated interest earnings. After this amendment is applied, the remaining unaddressed tuition revenue shortfall will be approximately $175,000. Other revenue shortfalls include a High Cost Aid deficit of $105,000, primarily due to lower -than-anticipated reimbursement rates, and a Medicaid settlement shortfall of $84,000 due to declining reimbursement rates. In total, the remaining revenue deficit is approximately $364,000. Additional adjustments will be made throughout the year as revenue overages or expenditure savings become available. 7 of 99 *NOTICE OF APPROVAL* This Finance Committee Budget Adjustment or Transfer document has been approved by Finance Department staff as to account information and form. Budget Adjustment or Transfer approved by Finance Committee on ________________________. Preparer: Lauren Kuntz Budget Adjustments, Transfers, and Amendments Form 1-215-B Accounts Description Org Object Project Account Type Amount ST GRT - OPERATING 2310A03 42310 Revenue $53,219 STRAIGHT TIME 2344 51105 Expense -$19,805 RETIREMENT 2344 51520 Expense -$1,699 SOCIAL SECURITY 2344 51530 Expense -$1,533 SHORT TERM DISABILITY INSUR 2344 51543 Expense -$103 TRANSPORTATION SERVICES 2344 52150 Expense -$9,975 RECREATIONAL ACTIVITIES 2344 52570 Expense -$892 PROGRAM SUPPLIES 2344 53405 Expense -$1,321 FOOD AND BEVERAGE 2344 53410 Expense -$900 PAPER/PLASTIC/SMALL WARES 2344 53435 Expense -$100 LONG TERM DISABILITY INSURANCE 2344 51545 Expense -$191 STUDENT FEES 2344 43525 Revenue $640 LIFE INSURANCE 2344 51515 Expense $3 SHORT TERM DISABILITY INSUR 2344 51543 Expense $225 LOC TUITION 2310 42655 Revenue $30,432 INTEREST ON INVESTMENTS 2310 44305 Revenue -$48,000 Subtotal by Expense: -$36,291.00 Subtotal by Revenue: $36,291.00 8 of 99 *NOTICE OF APPROVAL* This Finance Committee Budget Adjustment or Transfer document has been approved by Finance Department staff as to account information and form. Budget Adjustment or Transfer approved by Finance Committee on ________________________. Preparer: Lauren Kuntz Budget Adjustments, Transfers, and Amendments Form 1-215-B Walworth County Finance Committee Budget Adjustment or Transfer Reference Number: 110030 Department: Approvers: COUNTY ADMINISTRATOR Mark Luberda FINANCE DIRECTOR Jessica Conley CHILD. W/ DISAB. ED BD Matt Huettl Amendment Type: FC ADJ Posting Month/Year: 11/2026 Reason for Request: Department: Children with Disabilities Education Board (CDEB) T he purpose of this budget amendment is to increase the budget for the school's substitute payroll account to offset costs incurred due to staffing vacancies. The amendment will be funded using payroll savings realized from the vacant Early Childhood Teacher position. Accounts Description Org Object Project Account Type Amount STRAIGHT TIME 2342A01 51105 Expense -$23,018 LIFE INSURANCE 2342A01 51515 Expense -$11 RETIREMENT 2342A01 51520 Expense -$1,658 SOCIAL SECURITY 2342A01 51530 Expense -$1,762 WORKERS COMP 2342A01 51540 Expense -$52 SHORT TERM DISABILITY INSUR 2342A01 51543 Expense -$73 LONG TERM DISABILITY INSURANCE 2342A01 51545 Expense -$69 STRAIGHT TIME 23502A01 51105 Expense $23,018 LIFE INSURANCE 23502A01 51515 Expense $11 RETIREMENT 23502A01 51520 Expense $1,658 SOCIAL SECURITY 23502A01 51530 Expense $1,762 WORKERS COMP 23502A01 51540 Expense $52 SHORT TERM DISABILITY INSUR 23502A01 51543 Expense $73 LONG TERM DISABILITY INSURANCE 23502A01 51545 Expense $69 Subtotal by Expense: $0.00 Subtotal by Revenue: 9 of 99 *NOTICE OF APPROVAL* This Finance Committee Budget Adjustment or Transfer document has been approved by Finance Department staff as to account information and form. Budget Adjustment or Transfer approved by Finance Committee on ________________________. Preparer: Shelby Bechman Budget Adjustments, Transfers, and Amendments Form 1-215-B Walworth County Finance Committee Budget Adjustment or Transfer Reference Number: 110002 Department: Approvers: COUNTY ADMINISTRATOR Mark Luberda FINANCE DIRECTOR Jessica Conley HEALTH & HUMAN SVC Carlo Nevicosi COUNTY ADMINISTRATOR Mark Luberda Amendment Type: FC ADJ Posting Month/Year: 11/2026 Reason for Request: Department: Health and Human Services T he purpose of this Finance Committee adjustment is to increase the 2026 budget to prepay the liability claims of $40,016 scheduled for 2027. The agency reviewed payroll savings and identified position 210650 Court Services Specialist and 210706 Admin Clerk III with available savings. This budget amendment increases revenue and adds to the fund balance, but does not increase expenditures , so it is deemed to be a Finance Committee adjustment not a transfer. Accounts Description Org Object Project Account Type Amount HEALTH INSURANCE 2138 51505 Expense -$6,374 DENTAL INSURANCE 2138 51510 Expense -$216 LIFE INSURANCE 2138 51515 Expense -$5 RETIREMENT 2138 51520 Expense -$1,065 SOCIAL SECURITY 2138 51530 Expense -$1,132 WORKERS COMP 2138 51540 Expense -$157 SHORT TERM DISABILITY INSUR 2138 51543 Expense -$54 LONG TERM DISABILITY INSURANCE 2138 51545 Expense -$99 HEALTH INSURANCE 2138 51505 Expense -$2 STRAIGHT TIME 212010 51105 Expense -$6,721 HEALTH INSURANCE 212010 51505 Expense -$10,633 DENTAL INSURANCE 212010 51510 Expense -$196 10 of 99 *NOTICE OF APPROVAL* This Finance Committee Budget Adjustment or Transfer document has been approved by Finance Department staff as to account information and form. Budget Adjustment or Transfer approved by Finance Committee on ________________________. Preparer: Shelby Bechman Budget Adjustments, Transfers, and Amendments Form 1-215-B LIFE INSURANCE 212010 51515 Expense -$5 RETIREMENT 212010 51520 Expense -$484 SOCIAL SECURITY 212010 51530 Expense -$513 WORKERS COMP 212010 51540 Expense -$4 SHORT TERM DISABILITY INSUR 212010 51543 Expense -$25 LONG TERM DISABILITY INSURANCE 212010 51545 Expense $89 PROPERTY/LIABILITY INSURANCE 2110 54205 Expense $27,596 ADD/(USE) OF FUND BALANCE 780 48000 Revenue $40,016 INSURANCE PAID BY COUNTY 7810 43282 Revenue -$40,016 Subtotal by Expense: $0.00 Subtotal by Revenue: $0.00 11 of 99 *NOTICE OF APPROVAL* This Finance Committee Budget Adjustment or Transfer document has been approved by Finance Department staff as to account information and form. Budget Adjustment or Transfer approved by Finance Committee on ________________________. Preparer: Shelby Bechman Budget Adjustments, Transfers, and Amendments Form 1-215-B Walworth County Finance Committee Budget Adjustment or Transfer Reference Number: 110006 Department: Approvers: COUNTY ADMINISTRATOR Mark Luberda FINANCE DIRECTOR Jessica Conley HEALTH & HUMAN SVC Carlo Nevicosi Amendment Type: FC ADJ Posting Month/Year: 11/2026 Reason for Request: Department: Health and Human Services The purpose of this budget amendment is to reallocate the 2184FB01 Fit Families budget to the 2184 WIC budget. Federal funding for the fit families program ended in 2025 therefore the budget for 2026 will not be utilized. The 2026 - 2027 WIC grant award came in higher than anticipated which will be utilized to offset the decreased revenue and cover expenses from the fit families program. Accounts Description Org Object Project Account Type Amount ST GRT - OPERATING 2184FB01 42310 Revenue $19,459 STRAIGHT TIME 2184FB01 51105 Expense -$19,385 HEALTH INSURANCE 2184FB01 51505 Expense -$6,990 DENTAL INSURANCE 2184FB01 51510 Expense -$259 LIFE INSURANCE 2184FB01 51515 Expense -$9 RETIREMENT 2184FB01 51520 Expense -$1,396 SOCIAL SECURITY 2184FB01 51530 Expense -$1,484 WORKERS COMP 2184FB01 51540 Expense -$208 SHORT TERM DISABILITY INSUR 2184FB01 51543 Expense -$73 LONG TERM DISABILITY INSURANCE 2184FB01 51545 Expense -$29 MOBILE TELEPHONE/DEVICE 2184FB01 52731 Expense -$708 MILEAGE 2184FB01 53310 Expense -$354 EMPLOYEE TRAINING/TRAVEL 2184FB01 53325 Expense -$252 PROGRAM SUPPLIES 2184FB01 53405 Expense -$2,513 12 of 99 *NOTICE OF APPROVAL* This Finance Committee Budget Adjustment or Transfer document has been approved by Finance Department staff as to account information and form. Budget Adjustment or Transfer approved by Finance Committee on ________________________. Preparer: Shelby Bechman Budget Adjustments, Transfers, and Amendments Form 1-215-B PRINTING I/D CHARGES 2184FB01 53940 Expense -$73 ST GRT - OPERATING 2184 42310 Revenue -$19,459 STRAIGHT TIME 2184 51105 Expense $19,385 HEALTH INSURANCE 2184 51505 Expense $6,990 DENTAL INSURANCE 2184 51510 Expense $259 LIFE INSURANCE 2184 51515 Expense $9 RETIREMENT 2184 51520 Expense $1,396 SOCIAL SECURITY 2184 51530 Expense $1,484 WORKERS COMP 2184 51540 Expense $208 SHORT TERM DISABILITY INSUR 2184 51543 Expense $73 LONG TERM DISABILITY INSURANCE 2184 51545 Expense $29 MOBILE TELEPHONE/DEVICE 2184 52731 Expense $708 MILEAGE 2184 53310 Expense $354 EMPLOYEE TRAINING/TRAVEL 2184 53325 Expense $252 PROGRAM SUPPLIES 2184 53405 Expense $2,513 PRINTING I/D CHARGES 2184 53940 Expense $73 ST GRT - OPERATING 2184 42310 Revenue $374 ST GRT - OPERATING (2) 2184 42311 Revenue -$3,024 MOBILE TELEPHONE/DEVICE 2184 52731 Expense $216 SMALL ITEMS OF EQUIPMENT 2184 53115 Expense $200 MILEAGE 2184 53310 Expense $66 EMPLOYEE TRAINING/TRAVEL 2184 53325 Expense $1,680 PROGRAM SUPPLIES 2184 53405 Expense -$374 PRINTING I/D CHARGES 2184 53940 Expense $862 Subtotal by Expense: $2,650.00 Subtotal by Revenue: -$2,650.00 13 of 99 *NOTICE OF APPROVAL* This Finance Committee Budget Adjustment or Transfer document has been approved by Finance Department staff as to account information and form. Budget Adjustment or Transfer approved by Finance Committee on ________________________. Preparer: Carol Mast Budget Adjustments, Transfers, and Amendments Form 1-215-B Walworth County Finance Committee Budget Adjustment or Transfer Reference Number: 110001 Department: Approvers: COUNTY ADMINISTRATOR Mark Luberda FINANCE DIRECTOR Jessica Conley HEALTH & HUMAN SVC Carlo Nevicosi PUBLIC WORKS Richard Hough Amendment Type: FC ADJ Posting Month/Year: 11/2026 Reason for Request: Department: Lakeland Healthcare Center (LHCC) T he purpose of this budget amendment is to transfer funds for exhaust fan replacements at LHCC. This amendment requires Finance Committee approval as $25,000 has already been transferred to the Machinery & Parts -LHCC Building Account in 2026. The original plan was to have a vendor replace the LHCC exhaust fans (half in 2026 and half in 2027), however, staff is now planning to purchase the units in 2026 and installation will be completed by the maintenance techs. Funding is available in the Repairs & Maintenance Facilities-LHCC Building Account as the exhaust fan replacement project was budgeted in this account for 2026. This budget amendment is shifting the funds to the proper expense account now that the replacements will be done in-house. Funding is also available in the Road Oil-LHCC Building Account as the reclamite oil application on the parking lots has been completed. Accounts Description Org Object Project Account Type Amount MACHINERY & EQUIPMENT PARTS 512050 53720 Expense $12,000 R/M COUNTY FACILITIES 512050 52805 Expense -$5,000 ROAD OIL 512050 53840 Expense -$7,000 Subtotal by Expense: $0.00 Subtotal by Revenue: 14 of 99 *NOTICE OF APPROVAL* This Finance Committee Budget Adjustment or Transfer document has been approved by Finance Department staff as to account information and form. Budget Adjustment or Transfer approved by Finance Committee on ________________________. Preparer: Lauren Kuntz Budget Adjustments, Transfers, and Amendments Form 1-215-B Walworth County Finance Committee Budget Adjustment or Transfer Reference Number: 110003 Department: Approvers: COUNTY ADMINISTRATOR Mark Luberda FINANCE DIRECTOR Jessica Conley HEALTH & HUMAN SVC Carlo Nevicosi Amendment Type: FC ADJ Posting Month/Year: 11/2026 Reason for Request: Department: Lakeland Health Care Center (LHCC) T his budget amendment increases the Food Service budget to support the use of pool and casual staff to cover employee absences and assist with operational priorities that were deferred during periods of staffing shortages. Historically, payroll savings from Food Service vacancies and turnover helped offset these costs; however, with improved staffing levels, those savings are no longer available. Payroll savings generated through CNA vacancies and turnover will fund this amendment. Accounts Description Org Object Project Account Type Amount STRAIGHT TIME 513010 51105 Expense -$35,698 HEALTH INSURANCE 513010 51505 Expense -$61,076 DENTAL INSURANCE 513010 51510 Expense -$2,102 LIFE INSURANCE 513010 51515 Expense -$7 RETIREMENT 513010 51520 Expense -$2,569 SOCIAL SECURITY 513010 51530 Expense -$2,728 WORKERS COMP 513010 51540 Expense -$315 SHORT TERM DISABILITY INSUR 513010 51543 Expense -$130 LONG TERM DISABILITY INSURANCE 513010 51545 Expense -$375 STRAIGHT TIME 5187 51105 Expense $49,442 RETIREMENT 5187 51520 Expense $1,285 SOCIAL SECURITY 5187 51530 Expense $1,364 15 of 99 *NOTICE OF APPROVAL* This Finance Committee Budget Adjustment or Transfer document has been approved by Finance Department staff as to account information and form. Budget Adjustment or Transfer approved by Finance Committee on ________________________. Preparer: Lauren Kuntz Budget Adjustments, Transfers, and Amendments Form 1-215-B WORKERS COMP 5187 51540 Expense $158 SHORT TERM DISABILITY INSUR 5187 51543 Expense $65 LONG TERM DISABILITY INSURANCE 5187 51545 Expense $188 STRAIGHT TIME 518701 51105 Expense $49,441 RETIREMENT 518701 51520 Expense $1,284 SOCIAL SECURITY 518701 51530 Expense $1,364 WORKERS COMP 518701 51540 Expense $157 SHORT TERM DISABILITY INSUR 518701 51543 Expense $65 LONG TERM DISABILITY INSURANCE 518701 51545 Expense $187 Subtotal by Expense: $0.00 Subtotal by Revenue: 16 of 99 *NOTICE OF APPROVAL* This Finance Committee Budget Adjustment or Transfer document has been approved by Finance Department staff as to account information and form. Budget Adjustment or Transfer approved by Finance Committee on ________________________. Preparer: Lauren Kuntz Budget Adjustments, Transfers, and Amendments Form 1-215-B Walworth County Finance Committee Budget Adjustment or Transfer Reference Number: 110093 Department: Approvers: COUNTY ADMINISTRATOR Mark Luberda FINANCE DIRECTOR Jessica Conley HEALTH & HUMAN SVC Carlo Nevicosi Amendment Type: FC ADJ Posting Month/Year: 11/2026 Reason for Request: Department: Lakeland Health Care Center T he purpose of this budget adjustment is to increase Physical Therapy, Speech Therapy and Occupational Therapy expense lines due to an increase in resident census and increased costs that were not anticipated during the budget development process. Budget savings have been identified in Ancillary Medicare A expense for less than anticipated ancillary where pharmacy expenses have been lower than originally budgeted. Accounts Description Org Object Project Account Type Amount MEDICARE - PART A 516015 52310 Expense $24,250 MEDICARE - PART A 516515 52310 Expense $22,000 MEDICARE - PART A 517015 52310 Expense $800 MEDICARE - PART B 516015 52311 Expense $3,000 MEDICARE - PART A 5130 52310 Expense -$50,050 Subtotal by Expense: $0.00 Subtotal by Revenue: 17 of 99 *NOTICE OF APPROVAL* This Finance Committee Budget Adjustment or Transfer document has been approved by Finance Department staff as to account information and form. Budget Adjustment or Transfer approved by Finance Committee on ________________________. Preparer: Lauren Kuntz Budget Adjustments, Transfers, and Amendments Form 1-215-B Walworth County Finance Committee Budget Adjustment or Transfer Reference Number: 110014 Department: Approvers: COUNTY ADMINISTRATOR Mark Luberda FINANCE DIRECTOR Jessica Conley HEALTH & HUMAN SVC Carlo Nevicosi Amendment Type: FC ADJ Posting Month/Year: 11/2026 Reason for Request: Department: Lakeland Health Care Center (LHCC) T he purpose of this budget amendment is to increase funding for the CNA/CMA Overtime account due to staffing vacancies. The amendment will be funded through payroll savings from the RN/LPN Overtime accounts, which are projected to have year-end savings. Accounts Description Org Object Project Account Type Amount OVERTIME WORKED 513020 51110 Expense -$17,500 OVERTIME WORKED 513030 51110 Expense -$17,500 OVERTIME WORKED 513010 51110 Expense $35,000 Subtotal by Expense: $0.00 Subtotal by Revenue: 18 of 99 *NOTICE OF APPROVAL* This Finance Committee Budget Adjustment or Transfer document has been approved by Finance Department staff as to account information and form. Budget Adjustment or Transfer approved by Finance Committee on ________________________. Preparer: Richard Abbott Budget Adjustments, Transfers, and Amendments Form 1-215-B Walworth County Finance Committee Budget Adjustment or Transfer Reference Number: 110293 Department: Approvers: COUNTY ADMINISTRATOR Mark Luberda FINANCE DIRECTOR Jessica Conley COUNTY ADMINISTRATOR Mark Luberda PUBLIC WORKS Richard Hough Amendment Type: FC ADJ Posting Month/Year: 11/2026 Reason for Request: Department: Recovery Grants T he purpose of this budget adjustment is to allocate American Rescue Plan Act (ARPA) interest to properly install the Davit crane that was unable to be installed as part of the ARPA grant Safety Project. The Davit was to be installed on the Law Enforcement Center; however, the intended location was unable to structurally support the crane mounts. A request of $10,000 is for pre-design and consulting work, along with an estimated $25,000 to complete the project. Accounts Description Org Object Project Account Type Amount SAFETY IMPROVEMENTS 259105 58130 W2439 Expense $35,000 CONTINGENCY TRANSFER 259105 55110 Expense -$35,000 Subtotal by Expense: $0.00 Subtotal by Revenue: 19 of 99 *NOTICE OF APPROVAL* This Finance Committee Budget Adjustment or Transfer document has been approved by Finance Department staff as to account information and form. Budget Adjustment or Transfer approved by Finance Committee on ________________________. Preparer: Kristy M Secord Budget Adjustments, Transfers, and Amendments Form 1-215-B Walworth County Finance Committee Budget Adjustment or Transfer Reference Number: 110089 Department: Approvers: COUNTY ADMINISTRATOR Mark Luberda FINANCE DIRECTOR Jessica Conley SHERIFF'S OFFICE Tom Hausner Amendment Type: FC ADJ Posting Month/Year: 11/2026 Reason for Request: Department: Sheriff's Office T he purpose of this Finance Committee adjustment is to cover the increase in the Prisoner Transport overtime budget as well as the associated fringe benefits utilizing salary savings in Patrol due to vacancies. Accounts Description Org Object Project Account Type Amount STRAIGHT TIME 1570 51105 Expense -$22,885 SCHOOL CREDIT ALLOWANCE 1570 51610 Expense -$46 UNIFORM ALLOWANCE 1570 51615 Expense -$701 HEALTH INSURANCE 1570 51505 Expense -$6,516 DENTAL INSURANCE 1570 51510 Expense -$154 LIFE INSURANCE 1570 51515 Expense -$5 RETIREMENT 1570 51520 Expense -$3,284 SOCIAL SECURITY 1570 51530 Expense -$2,079 WORKERS COMP 1570 51540 Expense -$210 OVERTIME WORKED 153010 51110 Expense $29,000 RETIREMENT 153010 51520 Expense $4,382 SOCIAL SECURITY 153010 51530 Expense $2,219 WORKERS COMP 153010 51540 Expense $279 Subtotal by Expense: $0.00 Subtotal by Revenue: 20 of 99 *NOTICE OF APPROVAL* This Finance Committee Budget Adjustment or Transfer document has been approved by Finance Department staff as to account information and form. Budget Adjustment or Transfer approved by Finance Committee on ________________________. Preparer: Kristy M Secord Budget Adjustments, Transfers, and Amendments Form 1-215-B Walworth County Finance Committee Budget Adjustment or Transfer Reference Number: 110090 Department: Approvers: COUNTY ADMINISTRATOR Mark Luberda FINANCE DIRECTOR Jessica Conley SHERIFF'S OFFICE Tom Hausner Amendment Type: FC ADJ Posting Month/Year: 11/2026 Reason for Request: Department: Sheriff's Office T he purpose of this Finance Committee adjustment is to cover the projected $65,000 shortfall in the Jail food services budget for inmate meals, utilizing salary savings in Corrections due to vacancies. As a result of higher -than-average daily jail populations, expenditures related to food services also increased. Accounts Description Org Object Project Account Type Amount STRAIGHT TIME 1560 51105 Expense -$49,007 SCHOOL CREDIT ALLOWANCE 1560 51610 Expense -$178 UNIFORM ALLOWANCE 1560 51615 Expense -$3,427 HEALTH INSURANCE 1560 51505 Expense -$5,147 DENTAL INSURANCE 1560 51510 Expense -$172 LIFE INSURANCE 1560 51515 Expense -$1,593 RETIREMENT 1560 51520 Expense -$2,994 SOCIAL SECURITY 1560 51530 Expense -$1,790 WORKERS COMP 1560 51540 Expense -$287 SHORT TERM DISABILITY INSUR 1560 51543 Expense -$251 LONG TERM DISABILITY INSURANCE 1560 51545 Expense -$154 FOOD SERVICES 1560 52865 Expense $65,000 Subtotal by Expense: $0.00 Subtotal by Revenue: 21 of 99 Walworth County 2027 Stop Loss Renewal Recommendation Executive Summary Walworth County transitioned its stop loss coverage from Voya to QBE effective January 1, 2024. The current stop loss program includes:  Specific deductible of $175,000 (increased from $150,000 in 2026)  No new lasers at renewal  50% renewal rate cap  Coverage for both pre-65 and post-65 retirees  Experience Refund provision Through September 2026, six members have exceeded the $175,000 specific deductible, with an additional seven members currently above $125,000 in claims and approaching the stop loss threshold. Claims exceeding the specific deductible total $1,730,169 year-to-date, compared to $4,268,747 in the prior plan year. While large claim activity has moderated, current results remain well above the threshold required to qualify for an Experience Refund, and no refund is anticipated for 2026. Initial Renewal Offers QBE's initial renewal proposals for 2027 reflected significant premium increases: Specific Deductible Premium Increase $175,000 40.26% $200,000 26.90% $225,000 17.41% Market Review Hausmann Group marketed the stop loss program to 17 carriers to ensure Walworth County received the most competitive renewal terms available. Quotes were received from QBE, HCC, PartnerRe, Sun Life, Symetra, Voya, and Wellpoint. Ten additional carriers declined to provide terms. 22 of 99 The market generated highly competitive alternatives, including proposals from Voya and Wellpoint that significantly improved upon QBE's initial renewal pricing. These competing offers, combined with additional information regarding ongoing high-cost claimants, enabled Hausmann Group to negotiate substantially improved terms with the incumbent carrier. Following a final round of negotiations, both QBE and Voya submitted materially reduced pricing. Final Renewal Results (Appendix A) QBE's final renewal proposal maintains two important contract protections:  No new lasers at renewal  50% renewal rate cap As part of the negotiations, the Experience Refund provision was removed, generating approximately 5% in premium savings. QBE's final renewal options are: Specific Deductible Premium Change $175,000 12.45% $200,000 2.30% $225,000 -4.67% Voya's final proposal produced total premiums approximately $4,000 lower than QBE's $175,000 option. However, the Voya proposal includes a shorter run-in period (24/12 versus QBE's 60/12) and a higher aggregate attachment point, resulting in greater overall financial exposure for the County. Aggregate Coverage Analysis Aggregate stop loss coverage serves as the County's financial protection against overall claims volatility. Through negotiations, QBE reduced aggregate premiums from $3.85 PEPM to $2.22 PEPM, generating annual savings of approximately $14,357. Additionally, QBE's proposal increases the County's maximum liability exposure by only 3.09% over 2026 levels, while Voya's proposal would increase maximum liability by approximately $160,000 more than QBE. Specific Deductible Analysis Hausmann Group modeled multiple deductible scenarios to determine the most cost-effective stop loss strategy for 2027. Based on projected claim activity and premium costs, the analysis indicates that maintaining 23 of 99 the $175,000 specific deductible provides the strongest balance between premium expense and expected reimbursement value. See Appendix B for detailed modeling results. Experience Refund Considerations QBE's 2026 contract included an Experience Refund provision designed to return premium dollars when claims performance met specific targets. Walworth County qualified for and received a refund of $47,969 based on 2024 results. No refund was earned for the 2025 plan year, and none is expected for 2026 given the current loss ratio of approximately 82%, compared to the required threshold of 65% or less. The Experience Refund feature carries an estimated premium load of approximately 5%. As part of the renewal negotiations, QBE removed this provision, reducing fixed costs by approximately $171,000 annually. Given both the historical performance and future refund prospects, the premium savings associated with removing the rider outweigh the potential value of retaining it. Final Recommendation Hausmann Group recommends renewing stop loss coverage with QBE for the 2027 plan year with a specific deductible of $175,000. This option provides the most favorable overall value by:  Maintaining no individual laser liability  Preserving the no new lasers renewal protection  Retaining the 50% renewal rate cap  Limiting aggregate liability exposure relative to competing proposals  Including Gene Therapy protection to mitigate exposure to high-cost gene therapy treatments  Delivering the most cost-effective balance between premium expense and risk assumption by the County At the $175,000 deductible level, QBE's final renewal reflects an approximately 11.9% increase in total stop loss premium, while continuing to provide the contractual protections and risk management features that best align with Walworth County's long-term objectives. 24 of 99 Walworth County Effective: 1/1/2027 Current Renewal 1 Option 1 Option 2 Option 3 Carrier QBE QBE Voya Wellpoint Symetra Policy Wellpoint Life and Health Individual Specific Deductible $175,000 $175,000 $175,000 $175,000 $175,000 Specific Contract 48/12 60/12 24/12 24/12 36/12 Annual Specific Premium $ 3 ,077,073 $ 3,460,098 $ 3,450,949 $ 3,689,400 $ 4,182,028 Aggregate Contract 48/12 60/12 24/12 24/12 36/12 Aggregate Benefits Included Med + Rx Med + Rx Med + Rx Med + Rx Med + Rx Annual Aggregate Premium $ 3 3,911 $ 1 9,554 $ 24,751 $ 29,948 $ 44,393 Aggregate Attachment Point $ 2 3,987,485 $ 24,727,754 $ 24,881,249 $ 24,707,112 $ 26,709,994 Lasers and Restrictions None None None None Claimant 1 @ $1M Annual Fixed Premium (Spec & Agg Premium) $ 3 ,110,984 $ 3,479,652 $ 3,475,700 $ 3,719,348 $ 4,226,421 % Difference 11.85% 11.72% 19.56% 35.85% GTS Annual Total $ 4 1,838.00 $ 41,838.00 $ 41,838.00 $ 41,838.00 $ 41,838.00 Maximum Cost Liability (Fixed + Attachment + GTS + Amwins Advance) $ 2 7,140,307 $ 28,249,244 $ 28,398,787 $ 28,468,298 $ 30,978,253 % Difference 4.09% 4.64% 4.89% 14.14% Commissions 0% 0% 0% 0% 0% SUMMARY The above content is a high-level summary of carrier, plan, and product information. Please refer to the complete proposal for further detail. Appendix A 25 of 99 Walworth County Effective: 1/1/2027 Current Renewal 1 Option 1 Option 2 Option 3 Carrier QBE QBE Voya Wellpoint Symetra Policy Wellpoint Life and Health Carrier Rating A A A A A TPA Auxiant Auxiant Auxiant Auxiant Auxiant PPO Network HPS,PHCS HPS,PHCS HPS,PHCS HPS,PHCS HPS,PHCS UR Vendor American Health Holding, Inc. American Health Holding, Inc. American Health Holding, Inc. American Health Holding, Inc. American Health Holding, Inc. PBM Prime Therapeutics Prime Therapeutics Prime Therapeutics Prime Therapeutics Prime Therapeutics Specific Benefits Included Med + Rx Med + Rx Med + Rx Med + Rx Med + Rx Plan Lifetime Maximum Unlimited Unlimited Unlimited Unlimited Unlimited Individual Specific Deductible: $175,000 $175,000 $175,000 $175,000 $175,000 Specific Contract 48/12 60/12 24/12 24/12 36/12 Spec TLO No No Yes 3 Months No No 275 EE Only 147.79$ 166.60$ 179.20$ 177.20$ 208.51$ 459 Family 470.11$ 528.38$ 519.17$ 563.66$ 634.34$ 734 Composite 349.35$ 392.84$ 391.80$ 418.87$ 474.80$ Annual Specific Premium $ 3,077,073 $ 3,460,098 $ 3,450,949 $ 3,689,400 $ 4,182,028 % Difference 12.45% 12.15% 19.90% 35.91% Disclosure Status Firm Through 10/16/2026 Firm Through 10/16/2027 Firm Through 10/9/2026 Firm Through 10/5/2026 Lasers and Restrictions None None None Claimant 1 @ $1M No New Laser + Rate Cap Included + 50% Rate Cap Included + 50% Rate Cap Included + 50% Rate Cap Included + 50% Rate Cap Included + 50% Rate Cap Experience Refund Yes Not Included Not Included Yes Yes GTS (PEPM) $ 4.75 $ 4.75 $ 4.75 $ 4.75 $ 4.75 Am wins Advance (PEPM) Not Included Not Included Not Included Not Included Not Included Commissions 0% 0% 0% 0% 0% SPECIFIC STOP LOSS All applicable legal terms and conditions governing this proposal are outlined on the Contingency page; please review that section for complete details. 26 of 99 Walworth County Effective: 1/1/2027 Current Renewal 1 Option 1 Option 2 Option 3 Carrier QBE QBE Voya Wellpoint Symetra PPO Network HPS,PHCS HPS,PHCS HPS,PHCS HPS,PHCS HPS,PHCS Individual Specific Deductible: $175,000 $175,000 $175,000 $175,000 $175,000 Specific Contract 48/12 60/12 24/12 24/12 36/12 Aggregate Contract 48/12 60/12 24/12 24/12 36/12 Aggregate Benefits Included Med + Rx Med + Rx Med + Rx Med + Rx Med + Rx Aggregate Corridor 125% 120% 125% 125% 125% Annual Max Reimbursement $1,000,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000 Aggregate TLO Included ($1.04) Included ($1.04) Included Not Included Not Included 734 Composite 3.85$ 2.22$ 2.81$ 3.40$ 5.04$ Annual Aggregate Premium 33,911$ 19,554$ 24,751$ 29,948$ 44,393$ Aggregate Attachment 275 EE Only 1,328.54$ 1,387.24$ 1,353.17$ 1,368.40$ 1,688.00$ 459 Family 3,559.06$ 3,658.29$ 3,706.57$ 3,665.83$ 3,837.98$ 734 Composite 2,723.37$ 2,807.42$ 2,824.85$ 2,805.08$ 3,032.47$ Aggregate Attachment Point 23,987,485$ 24,727,754$ 24,881,249$ 24,707,112$ 26,709,994$ % Difference 3.09% 3.73% 3.00% 11.35% Commissions 0% 0% 0% 0% 0% All applicable legal terms and conditions governing this proposal are outlined on the Contingency page; please review that section for complete details. AGGREGATE STOP LOSS 27 of 99 Walworth County Effective: 1/1/2027 Current Renewal 2 Option 4 Option 5 Option 6 Carrier QBE QBE Voya Wellpoint Symetra Policy Wellpoint Life and Health Carrier Rating A A A A A TPA Auxiant Auxiant Auxiant Auxiant Auxiant PPO Network HPS,PHCS HPS,PHCS HPS,PHCS HPS,PHCS HPS,PHCS UR Vendor American Health Holding, Inc. American Health Holding, Inc. American Health Holding, Inc. American Health Holding, Inc. American Health Holding, Inc. PBM Prime Therapeutics Prime Therapeutics Prime Therapeutics Prime Therapeutics Prime Therapeutics Specific Benefits Included Med + Rx Med + Rx Med + Rx Med + Rx Med + Rx Plan Lifetime Maximum Unlimited Unlimited Unlimited Unlimited Unlimited Individual Specific Deductible: $175,000 $200,000 $200,000 $200,000 $200,000 Specific Contract 48/12 60/12 24/12 24/12 36/12 Spec TLO No No Yes 3 Months No No 275 EE Only 147.79$ 150.51$ 163.68$ 163.02$ 188.30$ 459 Family 470.11$ 483.75$ 475.63$ 518.57$ 579.12$ 734 Composite 349.35$ 358.90$ 358.76$ 385.36$ 432.70$ Annual Specific Premium $ 3,077,073 $ 3,161,178 $ 3,159,915 $ 3,394,250 $ 3,811,183 % Differ ence 2.73% 2.69% 10.31% 23.86% Disclosure Status Firm Through 10/16/2026 Firm Through 10/16/2027 Firm Through 10/9/2026 Firm Through 10/5/2026 Lasers and Restrictions None None None Claimant 1 @ $1M No New Laser + Rate Cap Included + 50% Rate Cap Included + 50% Rate Cap Included + 50% Rate Cap Included + 50% Rate Cap Included + 50% Rate Cap Experience Refund Yes Not Included Not Included Yes Yes GTS (PEPM) $ 4.75 $ 4.75 $ 4.75 $ 4.75 $ 4.75 Am wins Advance (PEPM) Not Included Not Included Not Included Not Included Not Included Commissions 0% 0% 0% 0% 0% SPECIFIC STOP LOSS All applicable legal terms and conditions governing this proposal are outlined on the Contingency page; please review that section for complete details. 28 of 99 Walworth County Effective: 1/1/2027 Current Renewal 2 Option 4 Option 5 Option 6 Carrier QBE QBE Voya Wellpoint Symetra PPO Network HPS,PHCS HPS,PHCS HPS,PHCS HPS,PHCS HPS,PHCS Individual Specific Deductible: $175,000 $200,000 $200,000 $200,000 $200,000 Specific Contract 48/12 60/12 24/12 24/12 36/12 Aggregate Contract 48/12 60/12 24/12 24/12 36/12 Aggregate Benefits Included Med + Rx Med + Rx Med + Rx Med + Rx Med + Rx Aggregate Corridor 125% 120% 125% 125% 125% Annual Max Reimbursement $1,000,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000 Aggregate TLO Included ($1.04) Included ($1.04) Included Not Included Not Included 734 Composite 3.85$ 2.29$ 3.62$ 3.45$ 5.16$ Annual Aggregate Premium 33,911$ 20,171$ 31,885$ 30,388$ 45,450$ Aggregate Attachment 275 EE Only 1,328.54$ 1,409.09$ 1,381.88$ 1,421.54$ 1,711.43$ 459 Family 3,559.06$ 3,715.90$ 3,785.23$ 3,808.19$ 3,891.27$ 734 Composite 2,723.37$ 2,851.63$ 2,884.79$ 2,914.01$ 3,074.57$ Aggregate Attachment Point 23,987,485$ 25,117,175$ 25,409,251$ 25,666,593$ 27,080,835$ % Difference 4.71% 5.93% 7.00% 12.90% Commissions 0% 0% 0% 0% 0% All applicable legal terms and conditions governing this proposal are outlined on the Contingency page; please review that section for complete details. AGGREGATE STOP LOSS 29 of 99 Walworth County Effective: 1/1/2027 Current Renewal 3 Option 7 Option 8 Option 9 Carrier QBE QBE Voya Wellpoint Symetra Policy Wellpoint Life and Health Carrier Rating A A A A A TPA Auxiant Auxiant Auxiant Auxiant Auxiant PPO Network HPS,PHCS HPS,PHCS HPS,PHCS HPS,PHCS HPS,PHCS UR Vendor American Health Holding, Inc. American Health Holding, Inc. American Health Holding, Inc. American Health Holding, Inc. American Health Holding, Inc. PBM Prime Therapeutics Prime Therapeutics Prime Therapeutics Prime Therapeutics Prime Therapeutics Specific Benefits Included Med + Rx Med + Rx Med + Rx Med + Rx Med + Rx Plan Lifetime Maximum Unlimited Unlimited Unlimited Unlimited Unlimited Individual Specific Deductible: $175,000 $225,000 $225,000 $225,000 $225,000 Specific Contract 48/12 60/12 24/12 24/12 36/12 Spec TLO No No Yes 3 Months No No 275 EE Only 147.79$ 138.22$ 150.85$ 148.85$ 171.96$ 459 Family 470.11$ 449.74$ 439.14$ 473.48$ 534.47$ 734 Composite 349.35$ 333.03$ 331.13$ 351.85$ 398.65$ Annual Specific Premium $ 3,077,073 $ 2,933,294 $ 2,916,589 $ 3,099,133 $ 3,511,329 % Difference -4.67% -5.22% 0.72% 14.11% Disclosure Status Firm Through 10/16/2026 Firm Through 10/16/2027 Firm Through 10/9/2026 Firm Through 10/5/2026 Lasers and Restrictions None None None Claimant 1 @ $1M No New Laser + Rate Cap Included + 50% Rate Cap Included + 50% Rate Cap Included + 50% Rate Cap Included + 50% Rate Cap Included + 50% Rate Cap Experience Refund Yes Not Included Not Included Yes Yes GTS (PEPM) $ 4.75 $ 4.75 $ 4.75 $ 4.75 $ 4.75 Amwins Advance (PEPM) Not Included Not Included Not Included Not Included Not Included Commissions 0% 0% 0% 0% 0% SPECIFIC STOP LOSS All applicable legal terms and conditions governing this proposal are outlined on the Contingency page; please review that section for complete details. 30 of 99 Walworth County Effective: 1/1/2027 Current Renewal 3 Option 7 Option 8 Option 9 Carrier QBE QBE Voya Wellpoint Symetra PPO Network HPS,PHCS HPS,PHCS HPS,PHCS HPS,PHCS HPS,PHCS Individual Specific Deductible: $175,000 $225,000 $225,000 $225,000 $225,000 Specific Contract 48/12 60/12 24/12 24/12 36/12 Aggregate Contract 48/12 60/12 24/12 24/12 36/12 Aggregate Benefits Included Med + Rx Med + Rx Med + Rx Med + Rx Med + Rx Aggregate Corridor 125% 120% 125% 125% 125% Annual Max Reimbursement $1,000,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000 Aggregate TLO Included ($1.04) Included ($1.04) Included Not Included Not Included 734 Composite 3.85$ 2.34$ 3.85$ 3.65$ 5.29$ Annual Aggregate Premium 33,911$ 20,611$ 33,911$ 32,150$ 46,595$ Aggregate Attachment 275 EE Only 1,328.54$ 1,427.25$ 1,401.04$ 1,474.68$ 1,730.38$ 459 Family 3,559.06$ 3,763.80$ 3,837.69$ 3,950.56$ 3,934.36$ 734 Composite 2,723.37$ 2,888.39$ 2,924.78$ 3,022.95$ 3,108.62$ Aggregate Attachment Point 23,987,485$ 25,440,936$ 25,761,429$ 26,626,129$ 27,380,709$ % Difference 6.06% 7.40% 11.00% 14.15% Commissions 0% 0% 0% 0% 0% All applicable legal terms and conditions governing this proposal are outlined on the Contingency page; please review that section for complete details. AGGREGATE STOP LOSS 31 of 99 Walworth County Effective: 1/1/2027 Amwins Gene Therapy Solutions 734 Composite 4.75$ Monthly Specific Premium 3,486.50$ Annual Specific Premium 41,838.00$ GTS Covers Zolgensma Elevidys Tecelra Luxturna Casgevy Encelto Spinraza Lyfgenia Kebilidi Zynteglo Lenmeldy Zevaskyn Skysona Abecma Itvisma Roctavian Carvykti Hemgenix Rethymic 32 of 99 Walworth County - Deductible Selection Worksheet (2027) Enrolled Employees 10/1/2026 Single 275 Family 459 Total 734 Stop Loss Options Current Option 1 Option 2 Option 3 QBE QBE QBE QBE ISL Deductible $175,000 $175,000 $200,000 $225,000 Contract Basis 48/12 60/12 60/12 60/12 Aggregate Rate $3.85 $2.22 $2.29 $2.34 Aggregate Premium $33,911 $19,554 $20,170 $20,611 Change from Current -42.3% -40.5% -39.2% QBE Composite $349.35 $392.84 $358.90 $333.03 QBE Premium $3,077,075 $3,460,135 $3,161,191 $2,933,328 Change from Current 12.4% 2.7% -4.7% Total Stop Loss Premium $3,110,986 $3,479,688 $3,181,362 $2,953,939 Change from Current 11.9% 2.3% -5.0% Premium + No Claims $3,479,688 $3,181,362 $2,953,939 Premium + 1 Claim $3,654,688 $3,381,362 $3,178,939 Premium + 2 Claims $3,829,688 $3,581,362 $3,403,939 Premium + 3 Claims $4,004,688 $3,781,362 $3,628,939 Premium + 4 Claims $4,179,688 $3,981,362 $3,853,939 Premium + 5 Claims $4,354,688 $4,181,362 $4,078,939 Premium + 6 Claims $4,529,688 $4,381,362 $4,303,939 Premium + 7 Claims $4,704,688 $4,581,362 $4,528,939 Premium + 8 Claims $4,879,688 $4,781,362 $4,753,939 Premium + 9 Claims $5,054,688 $4,981,362 $4,978,939 Premium + 10 Claims $5,229,688 $5,181,362 $5,203,939 Premium + 11 Claims $5,404,688 $5,381,362 $5,428,939 Premium + 12 Claims $5,579,688 $5,581,362 $5,653,939 Premium + 13 Claims $5,754,688 $5,781,362 $5,878,939 Premium + 14 Claims $5,929,688 $5,981,362 $6,103,939 Premium + 15 Claims $6,104,688 $6,181,362 $6,328,939 Premium + 16 Claims $6,279,688 $6,381,362 $6,553,939 Premium + 17 Claims $6,454,688 $6,581,362 $6,778,939 Premium + 18 Claims $6,629,688 $6,781,362 $7,003,939 Premium + 19 Claims $6,804,688 $6,981,362 $7,228,939 Premium + 20 Claims $6,979,688 $7,181,362 $7,453,939 Represents being within 5% of the minimum value, which is indicated with bolded text, in that row. 33 of 99 Finance | 100 W. Walworth St. | PO Box 1001 | Elkhorn, WI 53121 www.co.walworth.wi.us | (262) 741-4242 (o) | (262) 741-4384 (f) Memorandum T o: Walworth County Finance Committee From: Jessica Conley, Finance Director Date: November 10, 2026 RE: Update on Tax Incremental Districts (TID) Ci ty of Elkhorn TID #5 Project Plan Amendment Organizational Meeting The City of Elkhorn Joint Review Board (JRB) met on October 22nd and approved the City’s amended project plan for TID #5. The new development (US Shelter/Market Street Development) has been added to the project plan with expected 43 single-family homes expected. The project plan did not reduce the number of units expected for the Neumann Sugar Creek Ridge development in the event the school district decides at some point in the future to sell the land needed to the developer to allow the construction of the additional units. Ci ty of Delavan Annual JRB Meeting TID #4 (open since 2003) could close as soon as 2028 or 2029. The City of Delavan needs to decide whether it will transfer $1,250,000 as allowed by a previous amendment before closing to assist TID #5. They would also likely need to modify a Lake Lawn Resort agreement before closing to renegotiate the terms of the remaining liabilities and incentives. The TID has achieved more than $85 million in incremental growth through 2025. T he City’s Downtown TID #5 (open since 2012) expects some redevelopment of town houses by Habitat for Humanity as affordable housing (16 units/8 buildings). T ID #6 expects construction by JJ Superior Metals of 4 buildings between 2026 and 2028 with $2 million in construction growth expected by the end of 2027. The development of the Marina at Harbor Club expects a value of $1.7 million during 2026. A YMCA is also a potential consideration in this TID, with no decision at this time. Ci ty of Delavan reflects 2025 TID costs to be recovered of $4,926,778 for TID #4, $1,524,057 for TID #5, and $1,679,516 for TID #6. 34 of 99 Finance | 100 W. Walworth St. | PO Box 1001 | Elkhorn, WI 53121 www.co.walworth.wi.us | (262) 741-4242 (o) | (262) 741-4384 (f) Village of Darien Annual JRB Meeting The Village of Darien JRB met on November 10th. TID #3 has seen $12.7 million of equalized value growth to date. No new development is currently expected; however, the expenditure period is not complete until 2030. TID #4 has not incurred any significant growth or projects costs as the intended development failed to occur. The Village intends to keep both TIDs open to allow additional time to pursue and support potential future development opportunities that may arise. TID #3 has a current surplus of $1,166,792 with no unpaid liabilities to report. TID #4 outstanding costs to be recovered is $4,450. Upcoming Meetings Remaining annual TID Joint Review Board (JRB) meetings on the horizon: City of Whitewater annual meeting: November 19th at 4 p.m. Village of Sharon annual meeting: December 16th at 9:30 a.m. JC/pjs 35 of 99 HISTORY OF WALWORTH COUNTY SALES TAX 2017 To Present 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 MONTH MONTH Actual Rec'd Actual Rec'd Actual Rec'd Actual Rec'd Actual Rec'd Actual Rec'd Actual Rec'd Actual Rec'd Actual Rec'd Actual Rec'd % Change vs EARNED REC'D for Budget for Budget for Budget for Budget for Budget for Budget for Budget for Budget for Budget for Budget Same Period year 2017 year 2018 year 2019 year 2020 year 2021 year 2022 year 2023 year 2024 year 2025 year 2026 in Prior Year January March 653,588.40 603,061.37 689,905.21 749,644.48 760,422.16 934,329.35 929,433.71 918,229.30 951,797.88 1,203,877.59 26.48% February April 585,020.49 502,914.94 575,790.17 760,367.13 950,956.42 948,148.07 842,952.33 810,284.11 986,059.55 1,194,290.80 21.12% March May 729,429.69 791,163.24 897,284.23 727,388.04 988,918.78 966,634.45 1,120,961.41 1,451,566.38 1,457,910.70 1,327,385.46 -8.95% April June 807,715.11 890,373.03 816,241.08 805,240.04 1,189,965.42 1,350,363.64 1,386,168.13 1,146,499.11 1,013,648.03 1,337,424.64 31.94% May July 773,713.75 895,613.27 968,512.70 1,100,058.94 1,285,093.47 1,312,459.51 1,143,411.98 1,288,399.63 1,797,319.86 1,598,956.51 -11.04% June August 984,900.40 1,247,597.55 1,238,960.27 1,169,447.81 1,197,968.98 1,388,866.19 1,659,061.28 1,632,779.22 1,675,904.57 1,637,504.74 -2.29% July September 971,548.68 848,184.68 910,191.31 1,096,639.32 1,357,861.65 1,443,766.55 1,485,712.24 1,408,496.65 1,604,808.96 1,666,939.76 3.87% August October 843,114.54 995,499.44 1,120,647.54 1,125,370.18 1,219,965.94 1,248,926.29 1,276,757.18 1,524,588.16 1,735,914.28 1,754,228.67 1.06% September November 962,463.85 1,068,611.11 1,088,346.99 897,540.81 1,160,672.04 1,300,534.52 1,454,077.57 1,530,755.10 1,247,546.19 October December 776,591.51 750,988.81 761,217.96 996,016.91 1,164,702.86 1,218,717.52 1,206,376.78 1,136,497.10 1,344,930.49 November January 583,148.58 851,216.51 952,350.56 931,170.36 923,798.31 923,683.83 852,405.97 1,443,055.12 1,272,571.96 December February 941,217.76 877,010.80 827,395.02 924,810.21 1,190,562.04 1,518,454.55 1,662,212.63 1,335,718.68 1,300,755.14 9,612,452.76 10,322,234.75 10,846,843.04 11,283,694.23 13,390,888.07 14,554,884.47 15,019,531.21 15,626,868.56 16,389,167.61 11,720,608.17 8,000,000.00 8,825,000.00 9,100,000.00 10,000,000.00 10,600,000.00 11,600,000.00 12,700,000.00 14,000,000.00 14,800,000.00 15,800,000.00 8,125,000.00 8,868,919.00 9,100,000.00 10,000,000.00 14,000,000.00 11,600,000.00 12,775,000.00 14,000,000.00 14,800,000.00 15,800,000.00 1,487,452.76 1,453,315.75 1,746,843.04 1,283,694.23 (609,111.93) 2,954,884.47 2,244,531.21 1,626,868.56 1,589,167.61 (4,079,391.83) YTD $ Change vs Same Periods in Prior Year 371,796.63 709,781.99 524,608.29 436,851.19 2,107,193.84 1,163,996.40 464,646.74 607,337.35 762,299.05 497,244.34 YTD % Change vs Same Periods in Prior Year 4.02% 7.38% 5.08% 4.03% 18.67% 8.69% 3.19% 4.04% 4.88% 4.43% SUMMARY: PRIOR YEARS CURRENT (1987 - 2025) YEAR TOTAL Actual Receipts all periods 276,995,675.39 11,720,608.17 288,716,283.56 Note: 10/2025 first month utilities were tax exempt year-round Less: Rev Budget thru current pd (12/2025) 252,819,445.00 10,563,033.45 263,382,478.45 Starting 10/2025 Wisconsin residents will no longer pay sales tax on home electricity and natural gas Net over (under) budget 24,176,230.39 1,157,574.72 25,333,805.11 This was the case previously for November - April, new law adds May through October *2026 County Sales Tax revised budget reflects the following budget amendments: Bud. Amendment Increase / Decrease TOTAL RECEIVED ORIGINAL BUDGET REVISED BUDGET * NET OVER (UNDER) REVISED BUDGET Sales tax excemption is for permanent residents only, does not include commercial properties, seasonal homes, cabins, vacation rentals, or RVs S:\Finance\Administration\Sales Tax Reports\2026\summary of sales tax-2026 36 of 99 September 30, 2026 WALWORTH COUNTY, WISCONSIN Quarterly Investment Report 1 3rd QUARTER 2026 FINANCIAL HIGHLIGHTS Total Investment Portfolio as of September 30, 2026 Actual Benchmark1 Budget2 Realized Year to Date Interest Income Net of Fees $ 6,277,211 $ 6,258,638 $ 5,268,735 Current Holdings - Yield to Maturity at Cost 3.90% 3.81% n/a 3rd Quarter Average Return at Cost Annualized 3.80% 3.72% 2.95% Year to Date Rate of Return at Cost Annualized 3.70% 3.69% 3.11% Rolling 1 Year Average Return at Cost 3.76% 3.78% 3.21% Average Weighted Duration in Years 1.18 n/a n/a Average Weighted Duration in Years – Core 2.65 n/a n/a 2026 Fixed Income Purchases To Date: Average Weighted Duration: 4.39 Years Weighted Yield to Maturity: 4.27% 1 The County has selected the Local Government Investment Pool (LGIP) rate as the benchmark. 2 The budget rates of return are calculated based on budgeted amounts and the actual average daily balance. • Budget Compliance: Walworth County’s total investment portfolio has exceeded year-to-date budget expectations by $1,008,476 net of fees. The non-departmental portion of the portfolio, which excludes interest allocated to reserves and d onations based on the LGIP rate, has exceeded year-to-date budget expectations by $688,703 before unrealized losses. • Unrealized Gains/Losses: The County’s unrealized loss as of September 30, 2026 is $2,787,296. The County reserves $4 m illion in its investment market adjustment fund balance account in the event a yearend loss is incurred. • Budget Action Required: No action is required at this time. M ARKET PERSPECTIVE • The U.S. Federal Reserve (FED) increased rates at their September 2026 meeting. The target interest rate is now at 3.75% to 4.00%. • U.S. Treasury interest rate for the five-year term, the longest we may invest, was 5.09% as of 09/30/2026. Over the last five years, between 10/01/2021 and 09/30/2026, the five-year U.S. Treasury yield has averaged 3.69%, with a low of 0.93% and a high of 5.09%. • We currently hold $1 million in securities with a yield to maturity under 1.5% that are scheduled to mature in October. A ll remaining holdings carry a yield to maturity of 3.07% or higher. TO TAL INVESTMENT PORTFOLIO EXECUTIVE SUMMARY • Definition: The County’s total investment portfolio shall be defined as all county cash and investments not reserved in a separately maintained account for a specific purpose. Funds are valued in this report at bank statement value as of the date specified. Accounts not included in the total investment portfolio are restricted by a third party. The OPEB Trust is reviewed separately from our operating investment portfolio, as this portfolio is invested with a different investment philosophy due to its long-term nature. • Philosophy: Walworth County’s investment portfolio is maintained with prudent investment principles to enable the County to soundly meet its financial obligations. The key objectives are to provide safety of principal, to ensure liquid- ity to meet operating requirements, to generate a market rate of return (“yield”), and to manage the portfolio within ap- plicable laws. Investments are diversified into different investment vehicles to provide safety. In addition, all securities he ld are either backed by the U.S. Government or meet minimum ratings set by specified agencies. 37 of 99 September 30, 2026 WALWORTH COUNTY, WISCONSIN Quarterly Investment Report 2 REQUIREMENTS AND COMPLIANCE Walworth County’s investment portfolio is currently in compliance with Wisconsin statutes, the Walworth County Code of Ordinances and the County’s Administrative Procedures Manual. ITEM DESCRIPTION OF REQUIREMENT ACTUAL PORTFOLIO Credit Risk: Collateral Policy Investments other than U.S. Treasury backed securities or in- vestments not under FDIC or WI guarantee shall be collateral- ized for a minimum of 102-110% of the deposits. Current financial insti- tutions comply Security Diversification No single agency shall hold more than 50% of the core portfolio, currently $46,840,500. All institutions comply Financial Institutions Limits Investments held at any one institution shall be limited to 50% of the core portfolio, currently $46,840,500. All institutions comply Municipal Debt Limits Debt investments held for any one governing district/municipal- ity shall be limited to $3 million. All institutions comply Liquidity Risk Liquid cash shall be maintained at $20 million and available with 1 day notice. $ 70.4 million or 34% Reinvestment Risk Callable securities shall not exceed 50% of securities held. $ 0 million or 0% Market Risk: Maturity Restrictions Investments greater than 6 months shall be a minimum of 25% of the core portfolio, currently $23,420,250. $ 86.4 million or 92% Investments greater than 6 months and less than 5 years shall not exceed 100% of the core portfolio, currently $93,681,000. $ 86.4 million or 92% INVESTMENT CATEGORY MAXIMUM MATURITY AUTHORIZED LIMIT ACTUAL PORTFOLIO Certificates of Deposit 5 years 50% 2% Operating Cash N/A N/A 2% LGIP N/A 75% 4% Money Markets N/A 95% 48% U.S. Agency Securities 5 years 75% 27% U.S. Treasury Securities 5 years 75% 16% Municipal Debt 5 years 25% 1% CD 2% CASH 2% LGIP 4% MONEY MARKETS 48% U.S. AGENCY 27% U.S. TREAS 16% MUNI 1%INVESTMENT TYPE MARKET VALUE (in thousands) Certificates of Deposit $ 4,123 Cash - Depository Bank 4,782 LGIP 8,049 Money Markets 96,363 Portfolio Money Market 2,068 U.S. Agency Securities 55,007 U.S. Treasury Securities 32,881 Municipal Debt 2,819 Total $ 206,092 38 of 99 Definitions of each section below: Time Period Local Gov Investment Pool Advia CU Money Market CD Operating Bank Money Market Citizens Bank Money Market Huntington Portfolio Operating Bank Checking/ Sweep Total Investments 2025 4th Quarter 1.03% 1.06% 1.17% 0.99% 1.09% 0.92% 0.00% 0.98% 2026 1st Quarter 0.91% 0.92% 1.10% 0.87% 0.95% 0.93% 0.02% 0.91% 2nd Quarter 0.91% 0.91% 1.11% 0.88% 0.94% 0.96% 0.02% 0.92% 3rd Quarter 0.93% 0.97% 1.11% 0.90% 0.95% 1.00% 0.01% 0.95% One Year Ending 2025 4th Quarter 4.30% 4.35% 4.49% 4.14% 4.46% 3.46% 0.04% 3.91% 2026 1st Quarter 4.13% 4.17% 4.49% 3.97% 4.28% 3.57% 0.05% 3.86% 2nd Quarter 3.95% 3.99% 4.49% 3.80% 4.10% 3.69% 0.05% 3.80% 3rd Quarter 3.78% 3.86% 4.49% 3.64% 3.93% 3.81% 0.05% 3.76% Time Period Local Gov Investment Pool Advia CU Money Market CD Operating Bank Money Market Citizens Bank Money Market Huntington Portfolio Operating Bank Checking/ Sweep Total Investments 2025 4th Quarter 65,638 417,776 30,142 24,292 510,124 889,088 90 1,937,151 2026 1st Quarter 157,460 367,734 28,464 55,991 450,547 870,097 977 1,931,270 2nd Quarter 287,054 368,458 28,720 87,614 425,394 894,553 1,068 2,092,860 3rd Quarter 372,548 392,345 32,567 89,958 430,013 935,017 632 2,253,081 One Year Ending 2025 4th Quarter 1,144,137 1,690,454 114,789 194,496 2,019,607 3,170,900 2,038 8,336,421 2026 1st Quarter 1,026,810 1,636,939 115,284 197,539 1,994,923 3,335,341 2,581 8,309,417 2nd Quarter 940,363 1,583,354 115,789 229,700 1,907,604 3,478,994 2,915 8,258,720 3rd Quarter 882,700 1,546,313 119,892 257,855 1,816,078 3,588,755 2,767 8,214,361 Time Period Local Gov Investment Pool Advia CU Money Market CD Operating Bank Money Market Citizens Bank Money Market Huntington Portfolio Operating Bank Checking/ Sweep Total Investments 2025 4th Quarter 6,361,666 39,505,851 2,572,375 2,461,957 46,920,847 96,344,487 3,611,317 197,778,500 2026 1st Quarter 17,341,540 39,904,202 2,583,920 6,400,000 47,408,574 93,084,454 5,304,249 212,026,939 2nd Quarter 31,464,002 40,271,502 2,595,615 10,000,000 45,227,555 93,387,162 4,908,070 227,853,907 3rd Quarter 39,964,214 40,642,105 2,933,579 10,000,000 45,174,968 93,525,632 5,904,759 238,145,256 One Year Ending 2025 4th Quarter 26,276,557 38,871,071 2,555,361 4,659,589 45,289,138 91,604,186 4,142,082 213,397,984 2026 1st Quarter 24,296,937 39,283,188 2,566,605 4,986,301 46,651,074 93,334,949 4,403,186 215,522,240 2nd Quarter 23,591,689 39,686,811 2,578,098 6,158,904 46,487,454 94,253,203 4,774,918 217,531,078 3rd Quarter 23,797,106 40,081,361 2,672,059 7,212,329 46,178,888 94,092,832 4,930,126 218,964,700 Description LGIP Portfolio Rate of Return - Quarterly 0.93% 0.95% Rate of Return - Annualized 3.78% 3.76% Investment Yield (Net of Management Fees) Investment Revenue (Net of Management Fees/Gross of Market Adjustments) Average Daily Balance Average Daily Balance shows the average daily cash balance invested for each investment tool on a quarterly and one year rolling period. Comparison to Benchmark: WALWORTH COUNTY INVESTMENT PORTFOLIO VALUATION AT COST As of 09/30/2026 Investment Yield is the investment revenue divided by the average daily balance to show the quarterly yield and a one year rolling yield. Investment Revenue shows the interest earned by each investment tool on a quarterly and one year rolling period. 3 39 of 99 Employee/Official: Event: Location: Date: Time: Personal Vehicle: Miles round trip: @ $ /mile $ or County Owned Vehicle: Miles round trip: Commercial Travel (indicate type) : Hotel Costs: Registration Fee: Meals (total cost of meals not included in registration fee) : Misc Costs (explain) : Total Cost: Remaining budget available: $ Description of Conference/Additional Information: Actual Expenses: Date: Time: Mileage: DEPARTURE RETURN Department: Form 1-651-B: OUT-OF-STATE TRAVEL REPORT for CONFERENCE, CONVENTION, SEMINAR, TRAINING Required for All Out-of-state Travel in Excess of 100 Miles from Walworth County Obtaining/maintaining a required certification Obtaining/maintaining a desired certification that will improve an employee's job performance The purpose of this travel was (check one or more reasons) : Org No. Employee Signature(s): Supervisor's Signature: Amount Visiting vendors or other municipalities prior to making a major purchase Department Head Signature: Date: Submit this form to the Finance Department within 20 calendar days after the travel date. Meetings or training in connection with major information technology investments or other large purchases Learning about a specific change in the law or a new mandate Improving job-related skills Learning about a new program Listening to information regarding a number of new programs Influencing State legislation Influencing Federal legislation Networking Other (If "other", please explain) Approved: Enacted: 09/10/2010 Revised: 07/02/2019 Out-of-State Travel Report Form 1-651-B $ 10/27/2026 40 of 99 Attachment to Out-Of-State Travel Report Form #1-651-A Re : Carolyn Holt, 2026 NIGP Forum – Columbus, OH The reimbursement is being requested in the amount of the cost of airfare in the amount of $249.00 rather than the amount for the mileage expense. A search on flight costs was conducted on July 27, 2026, in which the lowest cost option was a round- trip flight with one stop from Milwaukee to Columbus, OH totaling $249.00. The employee made the decision to drive her personal vehicle rather than fly to the training. The total roundtrip mileage from the employee’s home in Walworth to the location was 814 miles and multiplied by the Federal rate of $.76 per mile would total $618.64 in reimbursable mileage. The determination was made to reimburse the lesser of the two amounts. Therefore, the employee is requesting $249.00 as the reimbursement mileage amount. 41 of 99 42 of 99 Finance | 100 W. Walworth St. | PO Box 1001 | Elkhorn, WI 53121 www.co.walworth.wi.us | (262) 741-4242 (o) | (262) 741-4384 (f) Memorandum To: Walworth County Finance Committee From: Jessica Conley, Finance Director Date: November 9, 2026 RE: Walworth County Housing Authority Update on Affordable Housing and Potential Memorandum of Understanding (MOU) Extension The County originally established an MOU as part of the American Rescue Plan Act (ARPA) grant funding with the Walworth County Housing Authority to increase and preserve affordable housing as part of the 2022 budget. Terms included providing $40,000/unit from the County to increase affordable housing by up to 25 units (total of $1,000,000), with the Housing Authority preserving an additional 25 units of affordable housing that was deemed at risk of losing this status. The MOU was later updated to utilize ARPA interest to allow for the agreement to extend beyond the grant obligation deadline. The MOU is set to expire on December 31, 2026, unless otherwise renewed. The Housing Authority has already met the agreement to preserve 25 units which had been at risk of losing this status in the Town of Delavan. Project Update In the attached update provided by Housing Authority’s Executive Director Sarah Boss, the City of Elkhorn’s Habitat for Humanity project is projecting to have the 4 units ready to rent by early spring of 2027. The County has already provided $160,000 of funding to assist this project. It appears there may be other possible units (1 to 4 units) on the first floor of this building. The Whitewater construction for an additional 5 units has been designed and is awaiting cost estimates before construction can begin with Habitat for Humanity with units expected to be ready to rent by early fall of 2027. Recommendation to Extend MOU With the potential for additional units in Elkhorn and the 5 units in Whitewater pending construction, it would be appropriate for the County to extend the MOU agreement through December 31, 2027. Absent further direction from the Committee, staff will work to extend the MOU for one year. 43 of 99 Finance | 100 W. Walworth St. | PO Box 1001 | Elkhorn, WI 53121 www.co.walworth.wi.us | (262) 741-4242 (o) | (262) 741-4384 (f) Representatives from the Housing Authority were not available to attend November’s meeting due to the time conflict with their own board meeting, but they could be invited to attend a future meeting for any additional questions. JC/pjs A ttachment 44 of 99 WALWORTH COUNTY HOUSING AUTHORITY affordable housing is the foundation to build a strong community ____________________________________________________________________________ 20 N. Church Street, Suite 1 · Elkhorn, Wisconsin 53121 Phone: 262-723-6123 · Fax: 262-723-2079 November 9, 2026 Walworth County Housing Authority Progress Report Re: Subrecipient Agreement for Increase in and Preservation of Affordable Housing Units Within Walworth County 1. Purchase of Vacant Commercial Building – 422 N. Wisconsin Street in Elkhorn • 4 rental units are under construction on the second floor of this building. Rental units are framed out; mechanicals are being installed and layout for an elevator has begun. • We are working with the City of Elkhorn to add 1-4 units on the first floor which will require a text amendment to the zoning. • The second-floor units will be available to rent in late Winter, early Spring of 2027. • Habitat for Humanity of Walworth County is our general contractor for this project. 2. Purchase of Vacant Commercial Building – 209 S. Taft Street in Whitewater • Architectural plans have been completed, and building permits have been issued. • 5 rental units will be developed in this building and small commercial space on the first floor. • Habitat for Humanity of Walworth County is our general contractor for this project and is completing its cost estimate for the renovation. • The City of Whitewater has been very supportive of the project. • Rental units will be available to rent – estimated in Summer to early fall of 2027. 45 of 99 1 Resolution No. **-12/26 Authorizing the Addition of the Substance Use Prevention, Treatment, and Recovery Services Block Grant Supplemental Award to Previously Established Pre-Approved Recurring Grants List Moved/Sponsored by: Finance Committee 1 2 WHEREAS, the State of Wisconsin Department of Health Services (DHS), Division of Care 3 and Treatment Services annually awards the Substance Use Prevention, Treatment, and 4 Recovery Services Block Grant (SUPTRSBG) to Walworth County Department of Health & 5 Human Services (WCDHHS) for substance use treatment and prevention services; and, 6 7 WHEREAS, the State of Wisconsin DHS grants supplemental SUPTRSBG awards to counties 8 when funding is available, for the purpose of expanding the general treatment and recovery 9 services, women’s treatment, and prevention services provided under the base grant award; and, 10 11 WHEREAS, there is no required tax levy match on the funds and these services would 12 otherwise be funded with tax levy; and, 13 14 WHEREAS, WCDHHS desires to add the grant noted to the pre-approved recurring grants list 15 until such a time as a change in conditions of the grant; and, 16 17 WHEREAS, the Walworth County Health and Human Services Board recommended this grant 18 be added to the pre-approved grant list in October 2026. 19 20 NOW, THEREFORE, BE IT RESOLVED that the Walworth County Board of Supervisors 21 authorizes staff to add the grant to the aforementioned pre-approved recurring grants list. 22 23 24 25 Rick Stacey Susi Pike 26 County Board Chair County Clerk 27 28 County Board Meeting Date: December 8, 2026 29 30 Action Required: Majority Vote X Two-thirds Vote Other 31 Policy and Fiscal Note is attached. Reviewed and approved pursuant to Section 2-91 of the Walworth County Code of Ordinances: ___________________________________ ___________________________________ Michael P. Cotter Date Jessica Conley Date Corporation Counsel Finance Director ___________________________________ Mark W. Luberda Date County Administrator If unsigned, exceptions shall be so noted by the County Administrator. 46 of 99 2 Policy and Fiscal Note Resolution No. **-12/26 I. T itle: Authorizing the Addition of the Substance Use Prevention, Treatment, and Recovery Services Block Grant Supplemental Award to Previously Established Pre- Approved Recurring Grants List II. P urpose and Policy Impact Statement: Walworth County Department of Health and Human Services (WCDHHS) receives an annual award for the Substance Use Prevention, Treatment, and Recovery Services Block Grant (SUPTRSBG) from the State of Wisconsin Department of Health Services (DHS). DHS grants supplemental SUPTRSBG awards to counties when funding is available to expand the treatment, recovery, and prevention services provided under the base grant funding. III. B udget and Fiscal Impact: There is no current impact on the budget. If WCDHHS is awarded a SUPTRSBG Supplemental Award, it may result in an increase in both the grant revenue and related grant expenditure budget. I V. Referred to the following standing committee(s) for consideration and date of referral: C ommittee: Finance Committee Date: November 19, 2026 V ote: County Board Meeting Date: December 8, 2026 Policy and fiscal note has been reviewed and approved as an accurate statement of the probable policy and fiscal impacts associated with passage of the attached ordinance/resolution. ____ _______________________________ ____________________________________ Michael P. Cotter Date Jessica Conley Date Corporation Counsel Finance Director Mark W. Luberda Date County Administrator 47 of 99 1 Resolution No. **-12/26 Authorizing the Addition of the Community Mental Health Block Grant Supplemental Award to Previously Established Pre-Approved Recurring Grants List M oved/Sponsored by: Finance Committee 1 2 WHEREAS, the State of Wisconsin Department of Health Services (DHS), Division of Care 3 and Treatment Services annually awards the Community Mental Health Services Block Grant 4 (CMHSBG) to Walworth County Department of Health & Human Services (WCDHHS) for 5 community-based services for adults with serious mental illness or children with severe 6 emotional disorders; and, 7 8 WHEREAS, the State of Wisconsin DHS grants supplemental CMHSBG awards to counties 9 when funding is available, for the purpose of expanding the community-based services for adults 10 and children provided under the base grant award; and, 11 12 WHEREAS, there is no required tax levy match on the funds and these services would 13 otherwise be funded with tax levy; and, 14 15 WHEREAS, WCDHHS desires to add the grant noted to the pre-approved recurring grants list 16 until such a time as a change in conditions of the grant; and, 17 18 WHEREAS, the Walworth County Health and Human Services Board recommended this grant 19 be added to the pre-approved grant list in October 2026. 20 21 NOW, THEREFORE, BE IT RESOLVED that the Walworth County Board of Supervisors 22 authorizes staff to add the grant to the aforementioned pre-approved recurring grants list. 23 24 25 26 Rick Stacey Susi Pike 27 County Board Chair County Clerk 28 29 County Board Meeting Date: December 8, 2026 30 31 Action Required: Majority Vote X Two-thirds Vote Other 32 Policy and Fiscal Note is attached. Reviewed and approved pursuant to Section 2-91 of the Walworth County Code of Ordinances: ____ _______________________________ ___________________________________ Michael P. Cotter Date Jessica Conley Date Corporation Counsel Finance Director ____ _______________________________ Mark W. Luberda Date County Administrator I f unsigned, exceptions shall be so noted by the County Administrator. 48 of 99 2 Policy and Fiscal Note Resolution No. **-12/26 I. T itle: Authorizing the Addition of the Community Mental Health Block Grant Supplemental Award to Previously Established Pre-Approved Recurring Grants List II. P urpose and Policy Impact Statement: Walworth County Department of Health and Human Services (WCDHHS) receives an annual award for the Community Mental Health Services Block Grant (CMHSBG) from the State of Wisconsin Department of Health Services (DHS). DHS grants supplemental CMHSBG awards to counties when funding is available to expand the community-based services provided under the base grant funding for adults with serious mental illness or children with severe emotional disorders. III. B udget and Fiscal Impact: There is no current impact on the budget. If WCDHHS is awarded a CMHSBG Supplemental Award, it may result in an increase in both the grant revenue and related grant expenditure budget. I V. Referred to the following standing committee(s) for consideration and date of referral: C ommittee: Finance Committee Date: November 19, 2026 V ote: County Board Meeting Date: December 8, 2026 Policy and fiscal note has been reviewed and approved as an accurate statement of the probable policy and fiscal impacts associated with passage of the attached ordinance/resolution. ____ _______________________________ ____________________________________ Michael P. Cotter Date Jessica Conley Date Corporation Counsel Finance Director Mark W. Luberda Date County Administrator 49 of 99 1 Resolution No. **-12/26 Authorizing the Public Works Department to Apply for the Federal Recreational Trails Program Grant (RTP) and Adding the Grant to Previously Established Pre-Approved Recurring Grants List Moved/Sponsored by: Parks Committee, Public Works Committee, and Finance Committee 1 2 WHEREAS, the Walworth County Public Works Department would like to apply for the 3 Federal Recreational Trails Program (RTP) Grant to be used for future improvement projects on 4 the White River State Trail; and, 5 6 WHEREAS, Section 30-313 of the Walworth County Code of Ordinances allows the 7 establishment, by resolution, of a list of authorized recurring grants; and, 8 9 WHEREAS, Resolution 08-05/05 established a list of pre-approved, recurring grants; and, 10 11 WHEREAS, the Public Works Department desires to add the RTP grant to the aforementioned 12 list; and, 13 14 WHEREAS, inclusion of a grant on the authorized list provides authority to the County 15 Administrator to approve the application and receipt of a grant so included until such time as a 16 material change in conditions of a grant occurs; and, 17 18 WHEREAS, a material change in conditions of a grant includes, but is not limited to, capital 19 expenditures, capital acquisitions, increase in percentage of County match or variation from the 20 original intent of the grant; and, 21 22 WHEREAS, the authorized list, at a minimum, will be reviewed on an annual basis and 23 revisions proposed as necessary; and, 24 25 WHEREAS, new grant opportunities for Walworth County departments may be added by 26 authorization of the County Board at a future date; and, 27 28 WHEREAS, the Director of Public Works has identified a future funding shortfall for the White 29 River State Trail, a state asset; and, 30 31 WHEREAS, per agreement with Wisconsin Department of Natural Resources (WDNR) the 32 County limits maintenance expenditures to $5,000 but has a major backlog in trail and trail 33 bridge maintenance; and, 34 35 WHEREAS, the RTP grant may be applied to recreational trail and recreational trail facility 36 improvements. 37 38 50 of 99 2 NOW, THEREFORE, BE IT RESOLVED that the Public Works department is authorized to 1 apply for and accept the Federal Recreational Trail Program Grant which will be incorporated 2 into the budget through future capital budget processes. 3 4 BE IT FURTHER RESOLVED by the Walworth County Board of Supervisors that the Federal 5 Recreational Trail Program Grant be added to the previously established pre-approved recurring 6 grants list. 7 8 9 10 Rick Stacey Susi Pike 11 County Board Chair County Clerk 12 13 County Board Meeting Date: December 8, 2026 14 15 Action Required: Majority Vote X Two-thirds Vote Other 16 Policy and Fiscal Note is attached. Reviewed and approved pursuant to Section 2-91 of the Walworth County Code of Ordinances: ____________________________ _____________________________ Michael P. Cotter Date Jessica Conley Date Corporation Counsel Finance Director Mark W. Luberda Date County Administrator If unsigned, exceptions shall be so noted by the County Administrator. 51 of 99 3 Policy and Fiscal Note Resolution No. **-12/26 I. T itle: Authorizing the Public Works Department to Apply for the Federal Recreational Trails Program Grant (RTP) and Adding the Grant to Previously Established Pre- Approved Recurring Grants List II. P urpose and Policy Impact Statement: The purpose of this resolution is to authorize the Public Works Department to apply for the Federal Recreational Trail Program grant, available through the Wisconsin Department of Natural Resources (WDNR). The RTP grant shall be added to the list of recurring grants which may be applied for without further County Board action. The grant will help support the Public Works Department’s goal of maintaining a quality recreational trail system. III. B udget and Fiscal Impact: Passage of this resolution will not have an impact on the 2027 adopted budget. The next grant cycle is the spring of 2027. I V. Referred to the following standing committee(s) for consideration and date of referral: C ommittee: Parks Committee Date: November 16, 2026 V ote: C ommittee: Public Works Committee Date: November 16, 2026 V ote: C ommittee: Finance Committee Date: November 19, 2026 V ote: C ounty Board Meeting Date: December 8, 2026 Policy and fiscal note has been reviewed and approved as an accurate statement of the probable policy and fiscal impacts associated with passage of the attached ordinance. ____ _______________________________ ____________________________________ Michael P. Cotter Date Jessica Conley Date Corporation Counsel Finance Director Mark W. Luberda Date County Administrator 52 of 99 Long-Term Planning: SWOT Analysis (Strengths, Weaknesses, Opportunities, and Threats) One useful tool to assist the County in long-range planning is a process known as SWOT analysis. SWOT stands for strengths, weaknesses, opportunities, and threats. Many businesses review their own strategic goals through SWOT analysis, but the tool is just as valuable to government. The first two letters in the acronym direct our attention to factors within Walworth County government. Taking an honest look at our organization: what are our strong points and what areas need to be improved? By understanding our strengths, we can leverage them to accomplish even more. Taking stock of our weaknesses allows us to shore them up to protect our organization and its mission. Opportunities and threats represent factors present in the environment in which the County operates. Although we may not be able to control them, it is critical that we understand them. During 2026, the County did an in-depth review of its SWOT Analysis. Each County Board Standing Committee was invited to participate in a review of the document so that a broader array of considerations would be incorporated. Additionally, committees were given an initial presentation explaining the document and the intent of the review and then the discussion was held at a subsequent month’s meeting. This ensured that each committee and individual could really put some thought into the evaluation of the document. These meetings were also open to the public and available for public comment. The in-depth review will occur on a rotating basis (generally every 3 years) as part of the County’s strategic planning process. STRENGTHS Countywide Personnel The County’s workforce represents one of its greatest assets. The County continues to attract quality employees. We have many experienced employees who can work efficiently and have a thorough knowledge of our organization. This conclusion is supported by the average tenure of a Walworth County employee, which currently stands at 8.9 years. The U.S. Department of Labor Bureau of Labor Statistics reported that the median number of years that wage and salary workers had been with their current employer was 4.1 years in January 2026 and 5.6 years for the public sector. Longer position tenures reduce the frequency of training and ramp-up periods for new employees and preserves extended periods of high efficiency. All of this supports the County Administrator’s belief that we have quality department heads and the department heads’ general contention that the County has a strong “depth chart” of management talent in key departments. A comprehensive classification and compensation study that is nearing conclusion, a recently implemented Supervisor Skill Development program for new and existing supervisors, a planned review of non-wage benefits in 2027, and hiring ordinances that allow targeting candidates with experience should further support the employee retention and attraction efforts. Financial Policies and Resulting Fund Balances Walworth County continues to maintain strong financial policies, which include strong grant administration review policies, line-item budgeting, centralized purchasing, fully-funded other post- employment benefits (OPEB), and required bid processes, which result in tight controls on 53 of 99 spending. The County has developed several policies related to funding commitments and internally designated net positions for the purpose of funding future debt calls, severance liabilities, building maintenance, equipment replacement, severe weather season or events, and road and bridge reconstruction. Committed fund balance accounts also exist to protect against revenue fluctuation. This includes: 1) the investment income committed account to fund temporary market losses during rapidly changing fixed income rate environments and 2) the short-term revenue stabilization reserve of the 0.5% county sales tax, realized investment income, and interest and penalties on delinquent property taxes, which are key revenues affected by economic changes. In 2026, the County tightened controls on the use of fund balance reserves and specific budgets have been set-up so that the County can react to unforeseen needs of these funds with action required by management or the Finance Committee. For example, $150,000 of the Severe Weather reserve allowance is budgeted in the event an immediate need is identified. In 2027, an expanded use of appropriated contingencies where portions not expected to be used were funded with fund balance provides for greater application of levy to fund operations. The use of unbudgeted reserves, however, even those utilized for the prescribed reserve purposes, requires a two-thirds majority vote by the County Board to establish a budget appropriation. Altogether, the result is that the County consistently maintains its minimum fund balance and net position policy, generally at the maximum level. Details of each fund and specific policies are found on the County’s Strategic Plan website as Long-Term Fund Balance Planning Financial Policies and Current Balances at www.co.walworth.wi.us/1222/Strategic-Plan. Debt The County has not borrowed money since 2011 and has no outstanding general obligation debt. Further, the County does not project the need to borrow in the five-year capital plan. The County achieved its debt-free status by taking advantage of excess cash reserves and a strong fund balance/net position. As a result, the County has the highest (Aaa) debt rating assigned by Moody’s Investors Service. A lack of debt is a strength for two reasons. First, interest costs associated with debt have no direct benefit and are only a drag on resources. Second, since debt is a standard, acceptable, statutorily authorized funding mechanism for certain governmental operations, the County is in a very strong position should a crisis or unique circumstance require debt issuance. The 2025 expansion of its capital planning process from a 5-year CIP to a 10-year CIP review and the continued increase in the comprehensiveness of the projects incorporated will aid the County in monitoring and mitigating the potential risk of future debt because an extended planning period provides more opportunity to implement a corrective course of action. The benefit of remaining debt free, historically a priority concern of the County, remains a strong incentive to take proactive steps to continue to ensure it remains debt free, as evidenced by the planned “controlled service contraction” review to occur in 2027. (For more information on said review, please see the 2027 County Administrator’s Budget Letter.) Organizational Adaptability, Resiliency, and Responsiveness The global financial crisis of 2007 and 2008; ongoing levy limits; the adoption of Act 10; social and political upheaval, including riots in nearby communities; the 2016 oil crash; the wars in Ukraine and Iran; and, of course, the Coronavirus pandemic followed by multiple years of higher-than- average inflationary trends. A nearly 20-year period of arguably unparalleled volatility and trekking through unknown territory as an organization. Nonetheless, each crisis was addressed head on. For example, shortly after the global financial crisis, Walworth County undertook eliminating debt. 54 of 99 During the pandemic when the world nearly shut down, Walworth County stayed focused, maintained operations, and never closed the Government Center. The County is continuing to respond in such a proactive and flexible fashion. For example, in the 2027 County Administrator’s Budget Letter, the Administrator identified that the County had “reached the boundary of sustaining current operations within the levy limits” and has recommended undertaking an extensive review of operations during 2027 for consideration of controlled service contraction. That ability to stay focused and maintain operations, no matter the external influences, exhibits an organizational adaptability, resiliency, and responsiveness that must be considered a strength. T echnology The County is proactive with respect to implementation of new information technology. Recent years emphasized a significant public safety radio system upgrades, multiple large departmental enterprise system replacements; telematics to provide better data to improve the County’s fleet management, safety, and accountability objectives; data governance and security enhancements including data loss prevention, as well as additional movement of more critical systems to cloud management and storage; and enhancements to cybersecurity protections, which are critical to maintaining and securing any technology infrastructure. The County has coordinated and targeted implementation of artificial intelligence and project management tools and features. Additionally, the County has restructured and grown the Information Technology Department to address the growing demands. In short, the County has embraced the benefits of modern technology to improve and protect operational capabilities. O ther Infrastructure The County has a demonstrated commitment to maintaining its roads and bridges. The County has established a ten-year improvement plan, which is anticipated to be funded without the need to borrow funds. The County Board adopted an ordinance establishing highway maintenance and improvement standards codifying a County policy to maximize the useful life of its highway infrastructure. The 2027-2036 Highway Improvement plan will upgrade 54.3 miles of road but nominally stretches the replacement cycle to 37 years - beyond the preferred 30-35 years. The anticipated $56.77 million in construction costs assume approximately 20% federal funding, which poses some risk. Nonetheless, the County is not in a position of deferred maintenance, so any significant risks are far off providing plenty of time to react. E nhanced Community Services: Lakeland School and Lakeland Health Care Center Walworth County invests considerable time, effort, resources, and property tax dollars into the operation of the Lakeland Health Care Center and the Lakeland School, under the Children with Disabilities Education Board. These services are not statutorily required, but given their magnitude and scope of service, they represent the pinnacle of voluntary public services. In doing so, they serve populations with special needs that might not otherwise have access to the quality of care they receive from these facilities. The continued dedication to retain and support these facilities is a testament to the County’s service provision philosophy. One could not summarize Walworth County’s strengths without identifying the Lakeland Health Care Center and the Lakeland School as a symbol of those strengths. Although remaining a strength, Lakeland School is currently at a point of fiscal constraint negatively impacting operations due to insufficient State support for special education. The County is actively addressing the constraints, but, importantly, the fiscal constraints on the school do not threaten other County services as their levy authority is independent from the General Fund levy authority. Lakeland Health Care Center, on the other hand, is continuing to benefit from increases in Medicaid funding that has continued to reduce its reliance on the County’s General Fund. 55 of 99 Department Specific La nd Use and Resource Management Department (LURM) Wisconsin is the only state in the country to tie conservation districts directly to county government, as established in Wisconsin Statue Statute Chapter 92. State appropriations provide funding for LURM conservation staff, landowner cost-sharing, and runoff management projects within the county, and provide relief from fluctuations in federal conservation funding sources. Loca ting conservation within the county structure provides local employment opportunities, access to local funding, integration with other county departments, and better opportunities to coordinate with local efforts. LURM routinely works with local partners and area stakeholders on projects, such as those within the Delavan Lake Watershed, to improve soil health, reduce runoff, and protect the county’s natural resources. WEA KNESSES Co untywide T ransportation: Shared-Ride Taxi Service Although the Shared-Ride Taxi Service, rebranded as Walworth County Connect, qualifies as an enhanced community service as defined above, the rapid increase in demand for transportation services reveals the potential, pent-up demand. The result is that the relatively new service for Walworth County, having only started in earnest in 2017, should arguably be defined as a weakness at this time because the full potential demand remains undefined. Additionally, this designation stems from consideration of the following threats identified below: 1) Employment Base and the Changing Workforce Environment, 2) the Increasing Economic Instability, and 3) the Demand for Health and Social Services. These societal influences all have the potential to create demands on the transportation system that exceed the capacity or service hours, thereby revealing the existing service as a weakness. E mergency Preparedness Emergency government preparedness, including such components as public health readiness and institutional training, can be a valuable step in meeting certain core governmental duties and responsibilities. After all, the breadth of governmental services touches so many aspects of daily life within the County such that in times of crisis or natural emergency it is incumbent upon government to respond. Although the County’s organizational adaptability, resiliency, and responsiveness have been identified as a strength, enhanced preparation can improve the County’s responsiveness to a crisis, emergency, or natural disaster. This risk was highlighted following the significant weather event that transpired on July 3, 2026. The severe and widespread damage that occurred inspired significant County cooperation with other local governments but also highlighted the need to further institutionalize such coordinated, supportive responses. O PPORTUNITIES Co untywide Loca tion Conducive to Economic Development The County is strategically located in southeast Wisconsin, approximately 85 miles northwest of the City of Chicago, 50 miles southwest of the City of Milwaukee, and 65 miles southeast of the City of 56 of 99 Madison. The County’s tax base is diverse and does not rely on the success of a single, particular business or industry. The County promotes and supports this position by continuing to actively support the County’s public/private economic development organization Walworth County Economic Development Alliance (WCEDA), including financial support of a proposal by WCEDA to expand their business retention and attraction effort through a two-year pilot “Enhanced Economic Development” program, as well as a three-year WCEDA contract to continue to engage local governments and the public in efforts to expand workforce housing. Additionally, Walworth County’s sales tax receipts have continued to experience year-after-year growth that reflects a second primary component of economic activity and economic benefits within the County. I ntergovernmental Cooperation As towns and municipalities face tighter budgets, the need for intergovernmental cooperation will increase. The County may provide services to local governments or vice versa. In any case, intergovernmental cooperation holds the promise or potential of lower costs to taxpayers or, at least, enhanced services at similar costs. Recent efforts supporting this position include the County’s building out a modern public safety radio system and providing funding for local governments to acquire compatible radios, an intergovernmental Fire EMS Study Committee evaluating the provision of EMS services, the County funding WCEDA’s efforts to promote incorporated local government support for advancing affordable housing, the Sheriff’s Office provision of direct law enforcement coverage for multiple local governments experiencing staffing shortages, and the County’s funding of a Communications Division study including the option of consolidated dispatch countywide. The Medical Examiner engages in intergovernmental cooperation through involvement in several multidisciplinary teams, such as Child Death Review, Traffic Safety Commission, Suicide Prevention and Overdose Fatality Review. Health and Human Services has numerous partnerships with local school districts. Lakeland School is undertaking district partnership meetings to develop a consistent understanding of the partners’ expectations and responsibilities. Additional coordination topics are underway, such as sharing of technology costs and County and local government public works departments sharing of equipment. I ntergovernmental cooperation can extend upward to the State as well, where the County can engage more regularly with state level elected officials to promote policies and to address needs that could benefit the County. Such interactions could be direct communication, hosting a local legislative day, or participating in similar events hosted by the Wisconsin Counties Association and the many other various professional organizations promoting public policy issues in Wisconsin. Such actions could position Walworth County well as a leader among counties. H igher Education and Other Community Partners UW-Whitewater, a premier university that is home to nearly 12,000 students, and Gateway Technical College (GTC) offer quality programs to students. While the County has collaborated with the schools in the past, such as with student internship opportunities which are still being pursued, the County has yet to scratch the surface in terms of goals that could be accomplished together. The UW-Whitewater’s staff is highly approachable and supportive of collaborative efforts. In fact, a member of Human Resources recently joined an employer advisory panel for UW-Whitewater and three are members of GTC’s program advisory boards. At the same time, other community partnerships could be developed or enhanced. Increased direct engagement by funding programs for implementation by the Walworth County Economic Development Alliance (WCEDA) or the tourism organization could also fit into this category. 57 of 99 THREATS Co untywide Emp loyment Base, the Changing Workforce Environment, and the Ability to Find Workers Wisconsin is experiencing a change in its population by age. Between 2010 and 2021, the drop in population for those under age 25 was reflected in a negative average annual growth rate over that period. Conversely, there has been a significant increase in individuals over age 55, and as they progress toward retirement, they will only be partly replaced by the 45-54 year age group, which has experienced the largest negative average annual growth rate over that period. The shrinking employment base and loss of experienced workers results in a very challenging environment in which to find workers. The remaining employment base can then be further negatively impacted by lack of access to childcare, transportation, and housing. T he County’s workforce is exhibiting the impacts of this societal shift. The average age of a County employee is 42.9 years, and nine percent of employees are over the age of 60. With more than 70 County permanent positions remaining unfilled at this time, the more concerning issue has become the ability – or inability – to fill vacant positions with quality candidates in the competitive labor market. Private sector wages, remote-work employers, and healthcare systems out-compete counties for talent. The modern workforce increasingly prioritizes flexibility, remote-work options, and greater work-life balance, including more time off and control over scheduling. These expectations create challenges for all employers, but they are especially difficult for roles that require physical presence and 24/7 reliability, such as corrections, law enforcement, and nursing. In these mission-critical positions, staff must be on-site, fully staffed, and consistently available, which limits the ability to offer remote work or flexible schedules. As a result, public-safety and direct-care agencies like Lakeland Health Care Center face a widening gap between what employees want and what the work itself requires. This intensifies recruitment and retention pressures in smaller communities with already limited labor pools. W orkforce Housing Shortages A shortage of affordable housing at all levels has been identified across the State and is evident in Walworth County as well. Economic conditions, housing supply and demand factors, the rate and cost of new housing construction, demographic factors impacting households, housing price increases relative to personal income increases, and other systemic challenges have all created a housing shortage that has the potential to negatively impact our local economic development and quality of life. It is a significant issue that has the ability to have long-term impacts. The State has adopted various laws aimed at easing housing development constraints, while the County has contracted with the Walworth County Economic Development Alliance to actively engage in workforce housing promotion. In both instances, successes are encouraging, but limited. The bottom line is that the factors are largely beyond local control. I ncreasing Economic Instability US-China trade tensions, wars in Ukraine and Iran, political fragmentation between and within countries, inflation, tariffs, worker shortages, and geo-economic fragmentation are reflected in what the International Monetary Fund identifies as elevated levels of economic uncertainty. Uncertainty and instability go hand-in-hand, as expressed by the Secretary-General of the United Nations at the World Economic Forum annual meeting in 2020. Closer to home, fluctuations in the stock market, housing prices, gas prices, and interest rates – all of which are recently evident in the Wisconsin and United States economy – can have significant impacts on more localized economic instability. 58 of 99 Associated reductions in economic growth, supply chain issues, restricted sales tax receipts, lower net new construction, and less competition for bid awards are all effects of economic instability; and all can significantly negatively influence the environment in which the County operates. Th e Demand for Health and Social Services “Counties serve as the arms of the state....Counties in Wisconsin primarily provide state-mandated services at the local level….In many ways, counties act more as the local offices of state agencies than independent bodies. The reason is state law…. Unlike other county departments, human services are funded with a mix of federal and state money. When other revenues fall short, however, local taxpayers make up the difference….Counties have little discretion over the services they must provide, but unlike state agencies, their operations are not fully funded by the state. Without adequate state funding, county supervisors must raise local taxes to compensate for any shortfalls.” [The Wisconsin Taxpayer, Vol. 84, Number 8, August 2016. A service of the Wisconsin taxpayers Alliance.] The County provides a vast array of human services on behalf of the State. Demand for these services is often driven by factors outside of the County’s control, such as a lack of access to adequate housing, food, and healthcare, both physical and mental. In 2026, the County has a budget with over $32 million in expenditures in the Health and Human Services special revenue fund. At $13 million, the Department of Health and Human Services is allocated approximately 20.4 percent of the County’s 2026 tax levy. Should demand for health and human services increase, the demand on County-supported funding could become problematic. Additionally, the demand for mandatory services can negatively impact important, but not mandated services or service levels, such as Supportive Home Care, Respite Care, Home Delivered Meals, and Hello Baby. E ver-Advancing Technology Ever-advancing technology pays no attention to fiscal constraints and limited resources. For example, drones, which were novelty items 10 years ago, are now essential tools (with short life spans) for multiple departments. Additionally, their features and complexity are now making them increasingly more expensive. The entire computer industry is quickly migrating from purchased software with years of life to licensed software with significant annual maintenance costs. Vehicle maintenance benefits from telemetrics systems that were previously uncommon. Building security and operations require swipe cards, security cameras, and key management systems. Computer productivity demands multiple monitors. Artificial intelligence add-ons and software tools create new monthly user fees while only still promising incredible benefits. Despite technology being identified as a strength, that claim is an acknowledgement of our status today. Technology, however, does not stand still. Failure to keep pace with ever-advancing technology is an ongoing threat that can render operations inefficient and ineffective. E mployee Health Costs The Patient Protection and Affordable Health Care Act will continue to limit the County’s flexibility in terms of providing health coverage for its employees. Additionally, medical inflation costs will continue to rise, posing a definite threat to the County’s ability to provide quality benefits to its employees. New, specialty pharmaceuticals can demand exorbitant prices until their patents and intellectual property rights expire. Options that can significantly reduce or restrain costs are likely to have a negative impact on the ability to attract and retain employees. Rising health-care costs make it harder for the County to remain competitive because employees increasingly compare total compensation packages, and higher premiums or out-of-pocket expenses can push candidates 59 of 99 toward private-sector employers with richer benefits. As costs rise, the County must either absorb the increases, straining the County Budget, or pass them on to employees, which can erode satisfaction and retention. C uts to State and Federal Funding The County derives a significant amount of its funding from State and Federal grants and reimbursements. In many cases, these are on the decline or not keeping pace with inflation and not in the County’s control. Similarly, since 2020, the County has benefited from a variety of additional funding directly related to the pandemic, such as the $20.2 million direct allocation, which had generally discontinued as a new resource after 2024. A dditionally, the significant State and Federal payments related to the Covid-19 pandemic could result in a backlash of future cuts. The State and Federal government have been handing out money at a time when their own revenues are being constrained, and the Federal deficit has increased substantially. Ultimately, they will have to reconcile their huge outflow of cash with their ongoing budget demands. It is quite possible that local government programming and support will get caught in the crosshairs and suffer cuts. There is a risk of not being able to build predictable strategies in the face of funding uncertainties. S tate Levy Limits State statutes mandate a levy limit on the County’s tax levy. The limit is detailed in the annual Adopted Budget Book in the budget summary section. The inability to raise the tax levy greatly limits the County’s flexibility should we encounter some unexpected loss of revenue or additional expense. Furthermore, the levy limit’s annual allowable growth routinely fails to keep pace with inflationary factors, which compounds the problem over time. Additionally, such restrictions and limitations can create lost opportunities (opportunity costs) from not pursuing proactive or leading- edge programs that are voluntary in nature. T he 2027 County Administrator’s Budget Letter identifies that “the 2027 budget has effectively consumed much of our remaining capacity to absorb and withstand the continued chokehold the levy limit has had on local government services for over a decade and a half.” It concludes that the 2027 budget “positioned the operating budget at the boundary of sustaining current operations within the levy limits.” This resulted in the County Administrator proposing that the County commence a process of planning for controlled service contraction for development of the 2028 budget. La ck of State Funding for Critical Infrastructure and Regional Construction Costs In 2023, Walworth County initiated a progressive highway infrastructure funding strategy to supplement once-in-a-generation grant opportunities. While the Bipartisan Infrastructure Bill and Wisconsin Local Roads Improvement Program - Supplemental (LRIP-S) grant programs remain funded for the next few years, the County highway improvement plan assumes continued funding over the coming decade. Meanwhile, new infrastructure challenges are emerging in Wisconsin through large culverts and increased infrastructure standards. While WisDOT intends to initiate a statewide asset inventory, no replacement grant funding program exists for the County to leverage. T he strain of insufficient state funding is enhanced by increased regional construction costs. Mortenson’s Regional Construction Cost Index (CCI) demonstrates that the Milwaukee Region is among the markets most affected by development and development-related inflation. In the fourth quarter of 2025 alone, Milwaukee recorded the highest regional inflation average at 1.96%. Trade 60 of 99 partner activity saw an increase of 6.2%, with associated labor inflation at 5.6% and material costs rising by 9.1%. Despite indications of moderation, ongoing increases in fuel and energy prices and a smaller, more competitive labor pool are expected to impact numerous public construction projects well into the future. T he Rising Cost of Living The rising cost of living is an underlying threat that is evident throughout this SWOT document. Gas prices were referenced as playing a role in increasing economic instability. Housing costs and housing price increases relative to personal income increases were called out as negatively impacting our local economic development and quality of life. Ever-advancing technology drives new cost centers just to keep pace. Employee health costs and medical inflation costs strain the County budget while creating circumstances that threaten our ability to attract and retain employees. Higher employee premiums and out-of-pocket costs sap the power of wage increases. Regional construction cost pressures were highlighted in relation to infrastructure and building projects. W hen considering the rising cost of living for the individual, it seems unnecessary to quote statistics on the rising cost of gas, electricity, food, health care, childcare, housing, entertainment, or any number of items because such stories are ubiquitous. Multiple national media sources, such as Forbes, suggest that recent election results at the national level were driven by an affordability crisis. Affordability has become the catch phrase for the same threat that historically has been commonly referred to as the cost of living. More officially, the U.S. Bureau of Labor Statistics measures inflation and price changes over time through a variety of Consumer Price Index (CPI) measurements. A ccording to Gallup News, the consequence of a rising cost of living is the erosion of economic security and standard of living for everyday families, driven by the fact that essential prices have risen much faster than earnings. The County operates in the same economic arena as families and, therefore, can experience the same burdens from a rising cost of living (price increases) outpacing earnings (revenues constrained by levy limits). D epartment Specific C hildren with Disabilities Education Board The school is dependent upon a state CDEB appropriation. With few CDEBs operating statewide, it may be easier for the Legislature to end this appropriation. While this threat can never be completely ruled out, CDEB funding has avoided many other budget cuts that the State Legislature has enacted. S upplemental Note: With student enrollment continuing to decline as more student needs are met within local school districts rather than the County’s special needs school, the decision has been made to consider the acceptance of more tuition-based students to keep costs and tax levy needs manageable. Tuition rate calculations have been reviewed and revamped and several new service costs have been incorporated which will allow additional students to be served as tuition-based students from other districts outside of Walworth County. While planning efforts have been made, it remains to be seen if outside districts will be interested in the County’s program. 61 of 99 Mark W. Luberda, County Administrator | County Administration | mluberda@co.walworth.wi.us 100 W. Walworth St., Elkhorn, WI 53121 | Room 112 | P.O. Box 1001 www.co.walworth.wi.us | (262) 741-4357 (o) | (262) 741-4390 (f) M emorandum To: Finance Committee From: Mark W. Luberda, County Administrator Date: November 13, 2026 RE: Committee/Board Input for the SWOT Analysis (Strengths, Weaknesses, Opportunities, and Threats) In a memorandum dated April 19, 2026, to all committees, I requested the committees review and discuss the existing SWOT analysis and provide input as to what each committee would like to include or have taken into consideration for an updated 2027 SWOT analysis. Committees were expressly instructed to make recommendations in the form of an approved motion if they wanted the recommendation considered for incorporation. This ensured broader support for the idea being proposed. At one of the meetings, I was asked to provide the approved motions as recommended when the SWOT was advanced for to committee for review. This memo fulfills that request. T here was much discussion, but only a few motions. The following points of discussion were brought up as motions and approved by the various committees. Com mittee Motions and Recommendations: • On Thursday, May 21, 2026, at the Finance Committee meeting, Supervisor Schneider offered a motion, second by Supervisor Ingersoll, to include another section of threats on the rising cost of living for the SWOT Analysis. • On Wednesday, May 20, 2026, at the Health and Human Services Board Meeting, Supervisor Schneider offered a motion, seconded by Supervisor Holt, to incorporate some kind of language into the SWOT Analysis for a local legislative day. • On Monday, May 18, 2026, at the Land Conservation Committee Meeting, Vice- Chair Stacey offered a motion, seconded by Supervisor Reiff, promoting that County Administrator Luberda work off Bonneville’s language found on page 21 of the packet for inclusion in the strengths; and to highlight the concern of representation of the Agricultural Community in general for inclusion in the 62 of 99 weaknesses. [Note: the two paragraphs of Bonneville’s language is not incorporated in this memo but is incorporated, with only a minor change, into the SWOT.] A dditionally, at some meetings, the minutes reflect that I mentioned potential changes that I anticipated would be included. Since my statements at each meeting may have influenced someone from making a motion, following is a list of those references : • On Wednesday, May 20, 2026, at the Children with Disabilities Education Board Meeting, Administrator Luberda indicated that the opportunities section should include intergovernmental cooperation and recommended highlighting CDEB’s recent efforts to enhance cooperation and communication with school districts, which are expected to have long-term benefits. • On Monday, June 15, 2026, at the Executive Committee meeting Administrator Luberda agreed to soften the report’s language regarding borrowing, emphasizing that debt remains a last resort. • On Wednesday, May 20, 2026, at the Lakeland Health Care Center Board of Trustees Meeting, Supervisor Holt noted concerns regarding unpredictable reimbursement funding, noting that recent federal policy changes affecting funding at the state and local levels make it difficult to plan budgets for next year. Administrator Luberda indicated that he would add that the County does focus on the funding and infrastructure side; but does not make a reference to the other burdens that the state or federal levels place upon the county level beyond just fiscal. E ach of these areas was addressed in some form or fashion within the document. M WL/sa 63 of 99 Strategic Plan Overview Walworth County Vision Statement: Walworth County strives for a safe, thriving community environment by providing efficient and effective county services, programming, and partnerships that promote the health and well-being of County residents, the community workforce, and visitors. Walworth County Focus Areas: GOOD GOVERNMENT FISCAL RESPONSIBILITY COUNTY WORKFORCE COMMUNITY SAFETY, HEALTH, AND QUALITY OF LIFE COMMUNITY ASSETS Introduction: The Strategic Plan Overview is adopted by resolution of the County Board in order to establish the high-level strategic components of the Detailed Strategic Plan. It will be adopted in conjunction with or immediately subsequent to the annual budget and will continue to be included in the final, annual Adopted Budget document. At this level, the Walworth County Vision Statement, focus areas, and the various underlying objectives of each focus area are established. Not reflected in the Strategic Plan Overview are the action plan items associated with each objective or the list of progress, accomplishments, or future plans under each action plan item. For more information as to the structure, intent, timing, and history of the Strategic Plan Overview, please see the sections following the Statement of the Focus Areas and Objectives. Timeline: Between December of 2026 and July of 2027, the County is undertaking a detailed review of operations and programs as part of an effort for advanced planning for controlled service contraction in the 2028 budget. This detailed, comprehensive review could end up altering previous expectations related to Objectives and a mid-year amendment to Objectives in the Strategic Plan Overview is possible. This strategic plan is intended to focus on meeting Objectives through action plans and accomplishments from 2026 through 2030. 64 of 99 Walworth County, Wisconsin Statement of Focus Areas and Objectives Focus Area 1: GOOD GOVERNMENT Maximize the efficiency and effectiveness of overall county operations. Communicate and serve the public in a way that provides easy access to information and a transparent, relevant, and understandable message. Comply with applicable federal, state, and other agency regulations; work with local governments to share services and expertise; and promote a stable, reasonable, and predictable taxation and regulatory environment designed to retain, attract, and grow businesses. Objective 1: Modernize workflow, technology, and policies to pursue continuous improvement and process innovation and achieve operational efficiencies and/or program enhancements. Objective 2: Improve accessibility of information and increase transparency with consistent messages communicating County objectives, accomplishments, and action plans to the community. Objective 3: Coordinate with community service partners and local governments to evaluate community needs and identify ways to utilize these partnerships to improve services offered to County citizens. Focus Area 2: FISCAL RESPONSIBILITY Maintain and adhere to financial policies and practices that are responsible and transparent. Build the County’s long-term, durable financial strength by investing in staff, technology, resources, and new solutions that maximize efficiencies and manage risks and associated liabilities. Objective 1: Perform ongoing review of expenditure programs to consider reconciling service demands/needs with mandated service level requirements; to develop value, cost savings, and efficiency enhancements; and to identify opportunities for a controlled service contraction. Investigate, enhance, and manage revenue sources. Objective 2: Identify risks in the County and develop initiatives and policies to increase security and reduce liabilities associated with the identified risks, including, but not limited to, strengthening of the County’s risk management, cybersecurity, business continuity (including disaster recovery), and physical security action plans. Objective 3: Update purchasing policies and practices to encourage competition, clarify processes, increase efficiency, and improve access to information. Objective 4: Ensure the fiscal sustainability of Lakeland School while addressing student service needs and growing school district partner relationships. 65 of 99 Focus Area 3: COUNTY WORKFORCE A ttract and invest in a diverse, professional, and dedicated workforce to create an environment that encourages staff to provide effective, innovative, and efficient services and that promotes ethical behavior, accountability, fairness, health, and safety. Develop a motivated and engaged workforce. O bjective 1: Enhance recruitment, promotion, and retention efforts by modernizing recruitment strategies, considering and adopting certain flexible wage and benefit options, reviewing and incorporating modifications and updates to work rules, pay ranges, and benefits, and creating a culture of recognition and appreciation. O bjective 2: Create an employee culture that integrates integrity, accountability, and growth to retain productive and innovative employees contributing to the overall effectiveness of our county services through employee engagement. O bjective 3: Encourage health, well-being, safety, and risk reduction as it relates to employees. O bjective 4: Create a culture of customer care. Fo cus Area 4: COMMUNITY SAFETY, HEALTH, AND QUALITY OF LIFE P rovide quality services that enhance and promote public safety, directly through law enforcement and indirectly through well-maintained infrastructure. Generate positive countywide health outcomes by assuring access to quality services and resources. Ensure non-economic, quality-of- life factors are considered in policy development and resource allocation. O bjective 1: In conjunction with the Walworth County Sheriff, improve organizational and physical components of the Sheriff’s Office to further enhance and promote public safety. O bjective 2: Support the transportation needs of the community through the continued growth of the shared-ride program. O bjective 3: Develop sustainable operations which provide services to residents through the Lakeland Health Care Center renovation of the vacant wing, while continuing to enable older adults to maintain their health, safety, dignity, and quality of life. O bjective 4: Promote programs and policies to improve access for citizens with mental and physical health needs. O bjective 5: Advance community health and wellbeing by aligning systems and partnerships, promoting cross-sector action, and unifying efforts in support of community priorities, such as in supporting the community’s opioid response. 66 of 99 Focus Area 5: COMMUNITY ASSETS P rotect, maintain, and enhance the life and sustainability of our community’s environment and assets; including natural resources, land, buildings, equipment, and infrastructure. O bjective 1: Improve access to infrastructure that meets public needs, such as broadband/internet, affordable workforce housing, open park space, etc. O bjective 2: Identify and support a sustainable and functional maintenance plan for highway infrastructure. O bjective 3: As part of County master facility planning, update County space, security, and facilities policies and strategies to minimize capital and maintenance costs, enhance security, support service needs, and improve user relations. O bjective 4: Develop and implement a 10-year Capital Improvement Plan to ensure fiscal stability and operational sustainability in capital asset management. O bjective 5: Determine future of downtown Government Center area and Veterans Park, along with future location of departments in the current building. A dditional Information About the Strategic Plan Overview Structure and Intent of the Strategic Plan Overview: The Vision Statement reflects a long-term perspective. Focus areas are broad, simply-stated, core categories that comprise the essence of what the County is trying to accomplish, achieve, or address. Each is followed by a statement that identifies the broad scope and intent of services or issues and helps define the components and breadth of the focus area. Each focus area also has a limited number of identified objectives that can generally overlay broadly across the County organization, but they can also appear to apply directly to only one department or division. Ob jectives reflect near-term priority considerations, whether stated as short-term, specific issues or long-term, ongoing expectations. This means objectives the County may have for which there are no near-term activities anticipated are not listed. Similarly, work toward objectives that reoccur annually are not listed. For example, many important efforts of the County, such as the ongoing annual effort to identify new revenue sources or to manage the health insurance fund and employee health benefits or to constantly improve and provide child support services, are not listed. The result is that objectives are not all-inclusive and are not intended to reflect all county services and programming. However, as structured, departmental goals and objectives identified throughout the budget document in the divisional budget summaries may be designated to address either a focus area or an identified countywide objective within a focus area. F rom time-to-time portions of this document are presented in a “red-lined” version to show changes from a previous iteration of this document. When presented in this manner, it enables County Board Supervisors and the public to track changes on existing focus areas and objectives and to identify new items. It also helps to identify items that are removed from the list because they have moved on to ongoing status or because of priority changes. Items or text removed are shown with a strike through (strike through). Items or text added are underlined (underlined). 67 of 99 2027 Special Circumstances: Between December of 2026 and July of 2027, the County is undertaking a detailed review of operations and programs as part of an effort for advanced planning for controlled service contraction beginning in 2028 for the 2028 budget. This will provide the County Board with the time to consider its options, alternatives, and priorities so it can establish its policy directives. It will also provide added time for increased community engagement and input. This detailed, comprehensive review could end up altering previous expectations related to Objectives, action plan items, and the expectations under those action plan items. A mid-year amendment to Objectives in the Strategic Plan Overview is possible. As such, those additional components of the Detailed Strategic Plan will be incorporated into the document around the mid- point of 2027. At that point, the details should be posted to the County’s website as “Walworth County’s Detailed Strategic Plan.” R elationship to the Detailed Strategic Plan: The Strategic Plan Overview presents the current, County Board-approved version of the Walworth County Vision Statement and the strategic planning Focus Areas and Objectives under each Focus Area. This document will typically appear within the adopted budget book. The County Administrator and Finance Director are authorized by resolution to take the subsequent steps to incorporate the necessary detail to complete the Detailed Strategic Plan, including continuing to update it from time to time. Th e Detailed Strategic Plan is an administratively prepared document that incorporates the action plan items associated with each Objective and the list of progress, accomplishments, or future plans under each action plan item. The Detailed Strategic Plan document generally presents information with a span of four to six years centered around the applicable budget year. In that way, each Objective shows the two-to-three-year, recent history of action plans associated with each Objective and the list of progress or recent accomplishments under each action plan item, as well as the two-to-three-year future plans for those areas. A s the Detailed Strategic Plan continues to mature and develop over time, the intent is to re- envision it to exhibit both a focus-area-based sorting and a level-based sorting. Level-based sorting identifies whether the item is County Board policy driven, administrative or operational initiatives affecting all or many departments and taking multiple years, or significant departmental initiatives taking multiple years. Th e Detailed Strategic Plan and the Strengths, Weaknesses, Opportunities, and Threats (SWOT) analysis and will be posted to the County’s Strategic Planning webpage. 68 of 99 1 Resolution No. **-12/26 Approving the Updated 2027 Strategic Plan Overview Moved/Sponsored by: Finance Committee 1 2 WHEREAS, the Walworth County Administrator reviewed the feedback received at all June 3 and July committee meetings regarding suggested considerations that should be addressed in the 4 Strengths, Weaknesses, Opportunities, and Threats (SWOT) analysis and updated the SWOT 5 analysis from prior years; and, 6 7 WHEREAS, the Walworth County Administrator presented the updated SWOT analysis to the 8 Finance Committee on November 19, 2026; and, 9 10 WHEREAS, the Finance Committee has requested the updated SWOT analysis be posted to the 11 County’s Strategic Planning website for further review by staff, citizens, and County Board 12 members as a long-term planning document; and, 13 14 WHEREAS, the Administrator also presented the Finance Committee with an updated Strategic 15 Plan Overview including the Vision Statement, Focus Areas, and Objectives, which was 16 reviewed in conjunction with the SWOT analysis by the Finance Committee on November 19, 17 2026; and, 18 19 WHEREAS, the County Board acknowledges that the Strategic Plan Overview, which includes 20 the Walworth County Vision Statement, the Focus Areas, and the Objectives under each Focus 21 Area, may be subsequently amended following or in conjunction with an organization-wide 22 effort to undertake planning for controlled service contraction. 23 24 NOW, THEREFORE, BE IT RESOLVED by the Walworth County Board of Supervisors 25 that the Strategic Plan Overview, including the Walworth County Vision Statement, the Focus 26 Areas, and the Objectives under each Focus Area, are adopted and approved as presented in 27 Exhibit A. 28 29 BE IT FURTHER RESOLVED that the Strategic Plan Overview be presented in the 2027 30 Adopted Budget Book and posted to the County’s website. 31 32 BE IT FURTHER RESOLVED that the Administrator and Finance Director are hereby 33 authorized to continue to update action plans and corresponding lists of progress, 34 accomplishments, and future year plans of the Strategic Plan Overview, as approved herein or 35 subsequently, as it relates to actual 2026 and 2027 activity, adopted 2027 budget information, 36 and other known future year plans, including but not limited to, as determined by department 37 goals or the current 10-year capital improvement plan, which altogether shall comprise the 38 Detailed Strategic Plan as it is administratively updated and published to the County’s website 39 from time to time. 40 41 42 43 Rick Stacey Susi Pike 44 County Board Chair County Clerk 45 46 County Board Meeting Date: December 8, 2026 47 48 69 of 99 2 Action Required: Majority Vote X Two-thirds Vote Other ______ 1 Policy and Fiscal Note is attached. Reviewed and approved pursuant to Section 2-91 of the Walworth County Code of Ordinances: ____ _______________________________ ___________________________________ Michael P. Cotter Date Jessica Conley Date Corporation Counsel Finance Director ____ _______________________________ Mark W. Luberda Date County Administrator I f unsigned, exceptions shall be so noted by the County Administrator. 70 of 99 3 Policy and Fiscal Note Resolution No. **-12/26 I. Title: Approving the Updated 2027 Strategic Plan Overview II. Purpose and Policy Impact: The purpose of this resolution is to approve the Strategic Plan Overview, including the Walworth County Vision Statement and the strategic planning Focus Areas and Objectives under each Focus Area. The resolution further authorizes the Administrator and Finance Director to take the subsequent steps to incorporate the necessary detail to complete the Detailed Strategic Plan, including continuing to update it from time to time. The resolution contemplates a potential update to Focus Areas or Objectives following the 2027 process of planning for controlled service contraction, as recommended during the budget process. The Strategic Plan Overview lays the groundwork, along with other long term planning information which has been compiled in an updated SWOT analysis, for administrative completion of the Detailed Strategic Plan that incorporates the action plan items associated with each Objective or the list of progress, accomplishments, or future plans under each action plan item. Both the SWOT analysis and Strategic Plan Overview will be posted to the County’s Strategic Planning website. Note that “Exhibit A” is not part of the name of the Strategic Plan Overview document but is used only for reference in this resolution. III. Budget and Fiscal Impact: There are no immediate budget or fiscal impacts related to this resolution. IV. Referred to the following standing committee(s) for consideration and date of referral: Committee: Finance Committee Date: November 19, 2026 Vote: County Board Meeting Date: December 8, 2026 Policy and fiscal note has been reviewed and approved as an accurate statement of the probable policy and fiscal impacts associated with passage of the attached resolution. ___________________________________ ____________________________________ Michael P. Cotter Date Jessica Conley Date Corporation Counsel Finance Director Mark W. Luberda Date County Administrator 71 of 99 Finance | 100 W. Walworth St. | PO Box 1001 | Elkhorn, WI 53121 www.co.walworth.wi.us | (262) 741-4242 (o) | (262) 741-4384 (f) Memorandum To: Walworth County Finance Committee From: Jessica Conley, Finance Director Date: November 9, 2026 RE: Opportunity to Provide Feedback Regarding Reporting of Capital Improvement Plan Budget Information The County’s current implementation of new financial reporting software (Workiva), along with changes to the Government Finance Officers Association (GFOA) Distinguished Budget Presentation Award criteria, provide the perfect opportunity to rethink the information collected, stored, and provided every year as part of the annual budget process. Our first review process will be the Capital Improvement Plan (CIP). Our goal is to provide staff and management involved in carrying out capital projects, County Board decisionmakers, and interested County citizens with accurate and organized capital information based on the needs of each group. Capital Budget Review Process: Each group below is asked to review entry forms, internal processes, and formally posted information including the 2027 Budget Dashboard capital section, the Budget Book, and the Capital Improvement Plan Supplemental Document and be ready to share comments and suggestions for improvements. October/November 2026: Opportunity for key capital budget players (County Administrator, Public Works Director, Information Technology Director, and Finance Department budget staff) to review and develop ideas for additional data gathering, process improvement, and report outputs. November 17, 2026: The Walworth County Leadership team will meet to brainstorm additional ideas. November Finance Committee meeting: Opportunity to provide feedback for County Board Supervisors. 72 of 99 Finance | 100 W. Walworth St. | PO Box 1001 | Elkhorn, WI 53121 www.co.walworth.wi.us | (262) 741-4242 (o) | (262) 741-4384 (f) Department Review Process: The County Administrator, Public Works Director, and Finance Department budget staff brainstormed a number of additional fields and information they would like the new system to track regarding categorization and ranking of priorities, projects that are associated with one another, better detailed financial account information, surplus asset expectations, and future year operating impacts and projections. A sample form of information that key capital budget players would like to see gathered in the new software will be reviewed with the Department Leadership team for further refinement of information gathering and department report needs. Q uestions for County Board Consideration: What changes should we consider making in capital budget reports and the related process? 1) D ata/Reports provided: a. Capital Definition and Process (attached) b. Funding Summary (attached) c. Project Summary (attached) d. Project Details (example page attached) 2) Timeline of 6-10 Year CIP being earlier in the year (June Public Works Committee/July County Board) 3) Timeline of 1-5 Year CIP (September Public Works Committee - initial presentation, October Public Works Committee - additional opportunity to discuss, November County Board - adoption) 4) Presentation of CIP information to Public Works Committee 5) Anything else? I h ave also attached the Capital Budget criteria section provided by GFOA to assist you in reviewing aspects they consider important. J C/pjs A ttachments 73 of 99 Capital Improvement Plan (CIP) Capital expenditures are projects to maintain or improve a County asset such as infrastructure, software, or equipment. The projects are usually nonrecurring expenditures for a physical improvement with a long useful life. Projects require an up-front commitment of resources which benefit the County and its citizens by extending the useful life of existing assets and creating new ones. Decisions regarding the financing of these capital improvements affect the availability of resources for the operating budget. C apital Project Definition C apital projects included in the CIP must meet ONE of the following: • N ew construction, expansion, renovation, or replacement project for an existing facility or f acilities. Projects must have a total cost of at least $25,000 over the life of the project. Costs can include the cost of land, engineering, architectural planning, contracted services and in some cases, staff time to complete the project. • A purchase of equipment that will be capitalized. Typically, this is a purchase of major e quipment costing $10,000 or more, with a useful life of at least 3 years. It may also qualify as a capital asset under highway or Medicaid requirements with a lesser cost. • A collectively significant group purchase of multiple like assets that are non-consumables with a useful life of one year or more, where the aggregate purchase exceeds $50,000. • A major maintenance or rehabilitation project for an existing facility or existing equipment repair with a cost of $25,000 or more, and an economic life of at least 10 years. • A ll initial start-up costs related to the implementation of a new information technology system when year one costs are $25,000 or greater. P rioritization of Capital Projects T he County uses a number of considerations when deciding on its capital plan, including the following priority ratings presented for each of the proposed projects with a 2027 appropriation. 1. M andated or legal obligation: resolving a mandate by State Statute or action of the County Board or Committee of the County Board. Projects where there is little or no choice in w hether or not the project should be included. 2. S afety issue or concern: addressing a current safety issue, concern or problem. 3. R eplacement – out of service: replacing necessary County assets not working, broken or out of service. This may include fleet equipment or vehicles needing replacement before scheduled replacement. 4. Productivity improvement or operational savings: expecting to improve County services or operations. This includes projects where one-time investments are anticipated to lead to on -going budget savings in future years. 335 74 of 99 Capital Improvement Plan (CIP) 5. F acility or grounds repair/maintenance: repairing or maintaining current existing County facilities and grounds. 6. S cheduled replacement: replacing a current county asset on a replacement schedule. This may include fleet equipment or vehicles. 7. N ew capital asset: increasing the number of County assets. This may include additions to fleet equipment or vehicles. 8. N ew County program or service: enabling a new County program or service proposed for the future (needed but not mandated). C apital Improvement Plan (CIP) Definition – Long-term Planning T he goal of the CIP is to create a logical, data-driven, comprehensive, integrated and transparent capital investment strategy that addresses infrastructure needs, reflects County values, supports County operations, programs and services and exemplifies financial and environmental best practices. Future operating budget impacts are estimated where practicable and are incorporated into the 5-year operating forecast. While the County strives to create a comprehensive capital plan, inevitably, a current capital request rises to a higher priority as more information becomes available, new ideas are formed, or in the event of a safety concern. The capital improvement plan (CIP) identifies capital needs or projects organized into two separate and distinct sections. Fi ve-year CIP: The County recognizes and annually approves the 5-year plan which encompasses all anticipated and known capital needs for this period in time. While the 5-year CIP includes a projected funding plan, only projects with a first-year appropriation without an administrative hold, have expenditure authority. Projects with an administrative hold status require appropriate committee or County board approval to move forward with spending and contractual agreements. A listing of all the 5-year projects as well as details for all projects with a 2027 appropriation are presented in this book. The details for all the 5-year projects can be found in the Preliminary Capital Improvement Plan Supplemental Document here: https://www.co.walworth.wi.us/1292/Dashboard-to-the-2027-Budget Te n-year CIP: Beginning in 2025, Walworth County has more formally incorporated years 6 to 10 projected capital needs referred to as the 10-year CIP. The preparation and review of its 121 projects was a significant addition to the already tight review timeline. Therefore, this budget cycle moved up the preparation and review of years 6 to 10, which were formally approved by County Board resolution on July 14, 2026. T he goal in expanding the CIP beyond 5 years was for greater insight into forecasting and projecting future needs in a transparent manner and as an additional long-term planning tool. The County does not formally adopt these out years by each individual year, it is provided as a planning tool where the focus is on understanding potential out year plans and objectives. The further out a capital plan forecasts, the greater the potential for changes, but the ability to see what is on the horizon encourages transparent discussion and creative solutions. This may lead to a delay in a 336 75 of 99 Capital Improvement Plan (CIP) project by identifying alternative solutions to anticipated costly improvement needs or perhaps prioritizing the needs in a manner that can be funded when it moves into the 5-year CIP. I n prior years, Public Works has maintained a 10-year plan regarding major highway/bridge improvement plan, campus asphalt plan, and equipment plans. The facilities master plan, along with individual building assessments, reflect a ten-to-fifteen-year time horizon. When looking at generational projects, funding cash flows for not only construction, but maintenance, may be projected as far as thirty years into the future. D epartments with capital replacement schedules or anticipated needs are encouraged to share any capital needs, either new or anticipated replacements. Vehicle replacements for all departments are captured in the 10-year CIP. Technology networking and hardware replacement capital needs are incorporated in the 10-year CIP; however, with software needs constantly changing and many software vendors moving to software as a service (SaaS) environment, these costs are likely already incorporated through the annual operating budget and have not been included in the 10- year CIP unless a new software solution need is anticipated. A listing of all the 10-year projects is presented in this book. The details for all the 10-year projects can be found in the Preliminary Capital Improvement Plan Supplemental Document here: https://www.co.walworth.wi.us/1292/Dashboard-to-the-2027-Budget F unding of 10-year CIP: A formal funding plan of the 6 to 10-year CIP is not created as timing is more subject to changing priorities. Movement into the 5-year plan requires a funding strategy to be disclosed. As part of the annual CIP process, the County’s Comptroller provides an analysis of capital reserves anticipated along with any projections of grants, donations, or other specific non- levy funds to determine if any projects may need to consider alternative funding sources, such as the need for debt service borrowings. The Administrator and Finance Director review this analysis to bring any concerns regarding projected funding to the County Board. At this time, no debt service is expected to result for the projects identified in the 10-year CIP. L ife Cycle of a Capital Improvement Plan Capital needs are determined Funding sources are identified Timelines are established Projects are published in a CIP 337 76 of 99 Department 2027 2028 2029 2030 2031 Total Capital Projects Department: Government Center Building 50,000$ 7,938,000$ 2,890,000$ 2,105,000$ 30,000$ 13,013,000$ Health & Human Services Building - - - 306,500 340,000 646,500 Judicial Center Building 430,000 1,260,000 840,000 6,280,000 2,782,000 11,592,000 Law Enforcement Center Building 1,278,500 1,030,000 1,215,000 56,000 36,000 3,615,500 Other Grounds & Buildings 25,000 1,750,000 7,445,000 825,000 - 10,045,000 Clerk of Courts Projects 180,000 100,000 190,000 175,000 125,000 770,000 Corporation Counsel Projects 150,000 - - - - 150,000 County Board Projects 100,000 - - - - 100,000 Finance Projects - 50,000 - - - 50,000 Health & Human Services Projects - 65,000 255,000 410,000 - 730,000 Information Technology Projects 885,000 1,113,000 659,200 430,000 365,000 3,452,200 Land Use & Resource Management Projects - - - 65,000 136,000 201,000 Public Works - Facilities Projects 275,000 370,000 - 35, 000 89,000 769,000 Public Works - Parks Projects 964,000 257,000 29,000 288,000 - 1,538,000 Register of Deeds Projects 170,000 - - - - 170,000 Sheriff's Office Projects 803,000 1,384,000 3,035,000 2,920,000 1,207,000 9,349,000 Roadway Infrastructure Projects 4,806,000 6,354,102 6,846,000 7,282,000 6,165,000 31,453,102 Subtotal of Capital Projects Department 10,116,500$ 21,671,102$ 23,404,200$ 21,177,500$ 11,275,000$ 87,644,302$ Children with Disabilities Education Board 1,491,000 925,000 2,348,000 130,000 180,000 5,074,000 Lakeland Health Care Center 5,452,500 1,044,100 246,700 408,100 2,360,900 9,512,300 Information Technology - Land Information 20,000 160,000 - 60,000 - 240,000 Public Works - Highway 2,080,100 3,013,400 8,346,300 2,413,100 1,443,200 17,296,100 Sheriff's Office - Sheriff Restricted 165,000 336,500 55,000 40,000 40,000 636,500 Transit 171,930 177,088 167,868 172,904 178,091 867,881 TOTAL 19,497,030$ 27,327,190$ 34,568,068$ 24,401,604$ 15, 477,191$ 121,271,083$ Funding Source 2027 2028 2029 2030 2031 Total Tax Levy 4,648,645$ -$ -$ -$ -$ 4,648,645$ To Be Determined - 3,693,868 3,375,524 3,353,531 3,341,568 13,764,491 Interest Income 1,250,000 750,000 250,000 - - 2,250,000 State Supplemental Aid to Counties 150,000 150,000 150,000 150,000 150,000 750,000 Subtotal of County Budget-year Resources 6,048,645$ 4,593,868$ 3,775,524$ 3,503,531$ 3,491,568$ 21,413,136$ Unallocated Road/Bridge Construction Funds 585,839 - 2,207,144 1,182,000 2,550,000 6,524,983 Capital Projects Fund Capital Improvement Funds 1,095,691 13,381,000 15,106,200 12,716,250 4,577,000 46,876,141 Capital Projects Fund Parks Funds 964,000 257,000 29,000 288,000 - 1,538,000 General Fund Short-term Rental Program Funds - - - 65,000 136,000 201,000 Children with Disabilities Education Board Funds 1,491,000 925,000 2,248,000 130,000 180,000 4,974,000 Lakeland Health Care Center Funds 4,452,500 1,044,100 246,700 408,100 2,276,400 8,427,800 Land Information Restricted Funds 190,000 140,000 - 40,000 - 370,000 Highway Funds 2,080,100 3,013,400 8,346, 300 2,413,100 1,443,200 17,296,100 Sheriff Restricted Funds 165,000 336,500 55,000 40,000 40,000 636,500 Subtotal of Existing Funding 11,024,130$ 19,097,000$ 28,238,344$ 17,282,450$ 11,202,600$ 86,844,524$ Debt Proceeds * - - - - - - Proceeds from the Sale of Assets 64,050 91,050 91,050 91,050 91,050 428,250 Grant Funds 2,347,705 3,545,272 1,723,150 3,404,573 691,973 11,712,673 Donated Funds 12,500 - 172,000 120,000 - 304,500 Reimbursement from Municipalities - - 568, 000 - - 568,000 Subtotal of Grant or Other Financing 2,424,255$ 3,636,322$ 2,554,200$ 3,615,623$ 783,023$ 13,013,423$ TOTAL 19,497,030$ 27,327,190$ 34,568,068$ 24,401,604$ 15,477,191$ 121,271,083$ Walworth County Capital Improvement Plan Funding Summary Preliminary Budget * A formal funding plan of years 6 to 10 of the plan is not presented, as timing is more subject to changing priorities. There is, however, no borrowing anticipated for the duration of the 10-year plan. 338 77 of 99 Walworth County 2027 Capital Improvement Plan Years 1 through 5 Preliminary Budget 2027 - 2031 County Budget- year Resources Existing Funding Debt Financing Grant or Other Financing 20302027 2028 2029 2031 Capital Projects Dept - Building - Government Center 50,00050,000GC Asbestos Survey & Abatement Government Center Remodel 5,225,000 GC Full Roof Replacement 1,653,000 GC Exterior Building Repairs 600,000 GC Electric Dist, ATS, & Generator 150,000 1,000,000 GC Building Network Infrastructure 120,000 GC Backup Circulation Pump 65,000 GC Fire Sprinkler System; Ceiling Tiles 60,000 745,000 GC Sanitary Ejector Pump Replacement 35,000 GC Flooring Replacement - Annual 30,000 30,000 30,000 GC West Elevator 675,000 GC Valve Replacement & Tank Removal 190,000 GC Chiller & Pump(s) Replacement 60,000 850,000 GC HVAC Balancing Study & Rebalance 55,000 225,000 GC Boardroom Remodel 50,000 400,000 GC Heating Boiler Replacement (3) 45,000 550,000 GC Radio Tower Barn Demolition 40,000 GC Veteran Memorial 80,000 50,000 50,000 7,938,000 2,890,000 2,105,000 30,000 Capital Projects Dept - Building - Health & Human Services HHS Building Network Infrastructure 225,000 HHS Building Infrastructure Assessment 41,500 HHS Flooring Replacement - Annual 40,000 40,000 HHS Sound Mitigation 200,000 HHS Staff Automatic Door Openers 100,000 306,500 340,000 Capital Projects Dept - Building - Judicial Center 165,000165,000JC Data Closet Expansion 110,000 75,00075,000JC Replace HVAC Valves 60,00060,000JC Heating Boiler Replacement 850,000 50,00050,000JC Flooring Replacement - Annual 50,000 50,000 50,000 50,000 50,00050,000JC Building Assessment 30,00030,000JC Data Center Cooling Sys Replacement 210,000 JC Generator Docking Station 40,000 Judicial Center Renovations 600,000 5,000,000 JC Building Network Infrastructure 130,000 JC Elevator Renovations 60,000 860,000 840,000 JC Emergency Generator Replacement 245,000 JC Window Replacement 75,000 1,000,000 JC Air Handling Unit Upgrades 50,000 800,000 JC Rolling File Demo and Floor Repair 92,000 430,000 175,000 255,000 1,260,000 840,000 6,280,000 2,782,000 339 78 of 99 County Budget- year Resources Existing Funding Debt Financing Grant or Other Financing 20302027 2028 2029 2031 Capital Projects Dept - Building - Law Enforcement Center 910,000910,000Jail Ceiling Replacement 188,500188,500SO Huber Exterior Wall Replacement 70,00070,000Jail Inmate Window Replacement 442,000 70,00070,000SO Main Entrance Repairs 40,00040,000Jail Water Closet "T" Replacement 40,000 40,000 20,000 SO Liebert CRAC Unit Replacement 400,000 Jail Dorms H to L Mechanical Upgrades 70,000 1,000,000 SO Building Infrastructure Assessment 50,000 SO Range ALC Upgrade 28,000 SO Buildings Network Infrastructure 175,000 SO Exhaust Fan Replacements (4) 36,000 36,000 1,278,500 950,000 328,500 1,030,000 1,215,000 56,000 36,000 Capital Projects Dept - Building - Other 25,00025,000Webster House ADA Ramp Campus Sanitary & Storm Sewer Repairs 950,000 911 Communications Center 800,000 7,200,000 Campus Bike Paths 120,000 Campus Planters & Tree Planting 75,000 75,000 HHS Chapter 980 Residence 50,000 500,000 Webster House Repairs 250,000 25,000 25,000 1,750,000 7,445,000 825,000 Capital Projects Dept - Dept Req - Clerk of Courts 150,000150,000Court Room Technology Refresh Cycle 100,000 190,000 175,000 125,000 30,00030,000JC Clerk of Courts Waiting Area Remodel 180,000 150,000 30,000 100,000 190,000 175,000 125,000 Capital Projects Dept - Dept Req - Corporation Counsel 100,000100,000JC Child Support Office/Entrance Rebuild 50,00050,000ADA Digital Web Content Compliance 150,000 150,000 Capital Projects Dept - Dept Req - County Board 50,00050,000Board Meeting Videos & Streaming 50,00050,000Board Meeting System 100,000 100,000 Capital Projects Dept - Dept Req - Finance E-Procurement Software Replacement 50,000 50,000 Capital Projects Dept - Dept Req - Health & Human Services HHS Fleet Expansion Vehicle 55,000 55,000 Public Health Lab Incubator Replacement 10,000 HHS Passenger Vehicle Replacements (3) 190,000 310,000 Public Health Water Sample Sealer Repl 10,000 HHS Door Widening 100,000 65,000 255,000 410,000 340 79 of 99 County Budget- year Resources Existing Funding Debt Financing Grant or Other Financing 20302027 2028 2029 2031 Capital Projects Dept - Dept Req - Information Technology 260,000 40,000300,000Storage Area Network (SAN) Refresh Cycle 325,000 200,000200,000Backup & Recovery Network Infrastructure 75,809 49,191125,000Data Center Infrastructure Maintenance 110,000 125,000 50,000 250,000 60,00060,000Audio Video Device Refresh 60,000 60,000 50,00050,000Phone System Replacement 600,000 50,00050,000Virtual Server Refresh Cycle 50,000 50,000 55,000 55,000 50,00050,000Project Management Systems 50,00050,000AI Solutions, Training, & Licensing Multi-Function Printer Replacements 135,000 135,000 Cyber Recovery Data Vault 100,000 County Business Processing System-Forms 50,000 Application Prog. Interface (API) System 50,000 JC EOC-IT Training Room Enhancements 18,000 164,200 County Telecloset Security Enhancement 125,000 885,000 685,809 159,191 40,000 1,113,000 659,200 430,000 365,000 Capital Projects Dept - Dept Req - LURM LURM Vehicle Replacement 65,000 136,000 65,000 136,000 Capital Projects Dept - Dept Req - Public Works - Facilities 140,000140,000DPW Building Network Infrastructure 135,000135,000Facilities Automated Mowing Equipment County Asset Management System 300,000 Facilities Tractor (Steiner) Replacement 70,000 Facilities Tractor Replacement 35,000 35,000 Rough Terrain Vehicle (RTV) Repl 54,000 275,000 275,000 370,000 35,000 89,000 Capital Projects Dept - Dept Req - Public Works - Parks 750,000750,000Park Expansion and/or Development 110,000110,000Price Park Disc Golf Course 42,00042,000Forestry Head Mulcher 28,00028,000WRP Barn Repairs 257,000 18,00018,000Tilt Equipment Trailer 16,00016,000Open Front Brush Cutter Price Park Service Road Resurfacing 29,000 288,000 964,000 964,000 257,000 29,000 288,000 Capital Projects Dept - Dept Req - Register of Deeds 120,000120,000ROD Deed Scanning 50,00050,000ROD Indexing Records 170,000 170,000 341 80 of 99 County Budget- year Resources Existing Funding Debt Financing Grant or Other Financing 20302027 2028 2029 2031 Capital Projects Dept - Dept Req - Sheriff's Office 602,000 63,000665,000Squad Replacement Purchase (7) 1,030,000 1,070,000 1,110,000 1,140,000 50,00050,000SO Server Hosts Infrastructure 48,00048,000SO Kitchen Assessment 12,500 12,50025,000K-9 Unit Replacement 13,950 1,05015,000Patrol Drone Replacement 15,000 15,000 15,000 15,000 Law Enforcement Center Remodel 180,000 1,800,000 Patrol Ballistic Plates 159,000 SO Property Barn Expansion 150,000 1,500,000 Jail Body Scanner Replacement 295,000 3D Scanner for Crashes & Crime Scenes 52,000 803,000 678,450 48,000 76,550 1,384,000 3,035,000 2,920,000 1,207,000 Capital Projects Dept - Roadway Infrastructure 1,192,590 473,4101,666,000CTH B (County Line to CTH C) 509,249 696,7511,206,000CTH ES (USH 12 to CTH A) 428,000428,000CTH E (CTH J to Waukesha Co. Limits) 389,000389,000CTH B (CTH U to Kenosha Co. Line) 326,000326,000CTH A (CTH P South to CTH H) 3,870,000 205,161 32,839238,000CTH L (STH 20 to Racine Co. Line) 3,326,000 156,000156,000CTH O (I-43 to Delavan City Limits) 117,000117,000CTH I (CTH J to Waukesha Co. Limits) 100,000100,000Culvert Ultraviolet (UV) Lining 100,000 100,000 100,000 100,000 75,00075,000Highway Bridge Repairs 600,000 40,00040,000CTH G (STH 120 to Austin St.) 150,000 1,237,000 40,00040,000CTH L Intersection Improvement 30,000 500,000 25,00025,000CTH A (CTH H to USH 12) 130,000 1,304,000 CTH DD (CTH JS to CTH D) 4,467,000 Unallocated Road Construction 792,102 CTH B Culvert Replacements (3) 60,000 309,000 2,656,000 CTH B (Linton Road to STH 120) 25,000 30,000 321,000 4,315,000 CTH K (S. Cty Line to USH 14) 25,000 30,000 378,000 CTH C (Salt Box Rd. to Martin St.) 15,000 105,000 749,000 County Highway Technical Survey 175,000 CTH F (STH 67 to STH 50) 25,000 30,000 CTH P (CTH M to CTH A) 573,000 CTH C (State Line to STH 67) 20,000 4,806,000 3,050,000 585,839 1,170,161 6,354,102 6,846,000 7,282,000 6,165,000 342 81 of 99 County Budget- year Resources Existing Funding Debt Financing Grant or Other Financing 20302027 2028 2029 2031 Children with Disabilities Education Board Dept 765,000765,000CDEB Chiller & Partial Roof Replacement 191,000191,000Pool UV Light & Controls Upgrade 186,000186,000CDEB Building Network Infrastructure 80,00080,000Transport Van/Bus Replacement 83,000 80,00080,000CDEB Cabinet Storage Remodel 65,00065,000CDEB West Playground Replacement 635,000 60,00060,000Pool Deck & Grate Reno; Pool Window 650,000 54,00054,000Smart Board Replacements (12) 40,000 40,000 40,000 40,000 10,00010,000Replace Roof-Mounted Exhaust Systems 90,000 Corridor Flooring Replacement 55,000 1,500,000 Commercial Appliance Replacement 50,000 50,000 CDEB Flooring Replacement - Annual 40,000 40,000 40,000 40,000 CDEB Building Infrastructure Assessment 50,000 CDEB Roof Replacement 60,000 CDEB Parking Lot Refurbishment 40,000 1,491,000 1,491,000 925,000 2,348,000 130,000 180,000 343 82 of 99 County Budget- year Resources Existing Funding Debt Financing Grant or Other Financing 20302027 2028 2029 2031 Lakeland Health Care Center Dept 3,000,000 1,000,0004,000,000Vacant Wing Modification 1,000,0001,000,000LHCC North Parking Lot Replacement 155,000155,000LHCC Furniture Replacements 140,000 40,000 150,000150,000Courtyard Sunshades & Access 50,00050,000LHCC Chiller Replacement 500,000 25,40025,400Full Body Lifts (2) 25,400 25,400 25,400 25,400 25,00025,000Laundry Washing System 17,70017,700Sit to Stand Lifts (2) 17,700 17,700 17,700 17,700 12,00012,000Food Holding/Transport Carts (2) 12,000 5,9005,900Air Mattresses (2) 5,900 5,900 5,0005,000Ice Maker & Storage Bin 4,0004,000Stand On Scale 2,5002,500Wheelchair Scale 2,500 2,500 LHCC Emergency Generator Replacement 285,000 Industrial Freezer/Cooler Refurbishment 70,000 Resident Room/Household Recliners (2) 6,000 6,000 LHCC Ext Siding & Window Replacement 50,000 250,000 2,000,000 Whirlpool Tubs 25,000 25,000 25,000 Industrial Washer-Extractors 25,000 25,000 25,000 Reach-In Freezer 9,000 Omni Cycle Rehab System 9,000 Food Waste Disposer 8,000 Food Processor 8,000 Semi-Automatic Food Slicer 8,000 Automatic Meat Slicer 7,500 7 Quart Food Processor 6,000 Bi-directional Physio Trainer 2,200 Bladder Scanners 15,000 15,000 Shortwave Diathermy Device 9,500 Recumbent Cross Trainer 8,000 Robot Coup Ultra Food Processer 7,500 Solid Door Reach-In Cooler 4,500 Conveyor Dishwasher 50,000 Combination Oven/Steamer 26,000 French Door Refrigerators (14) 28,000 Vital Signs Monitors (2) 10,400 LHCC Building Network Infrastructure 130,000 5,452,500 4,452,500 1,000,000 1,044,100 246,700 408,100 2,360,900 Land Information Dept 20,00020,000Land Information Drone GIS Environment System 100,000 Orthophotography Acquisition 60,000 60,000 20,000 20,000 160,000 60,000 344 83 of 99 County Budget- year Resources Existing Funding Debt Financing Grant or Other Financing 20302027 2028 2029 2031 Public Works - Highway Dept 528,500528,500Tandem Axle Patrol Truck Replacement 1,710,000 1,217,500 1,298,700 473,000 310,000310,000Vehicle Wash Bay Enhancements 240,000240,000Grader Replacement 190,000190,000Tractor Replacement 185,500185,500Patrol Truck Replacement (2) 208,500 221,000 117,100 145,000145,000DPW Skid Loader Replacement 132,500132,500Tanker Replacement 80,00080,000DPW Garage Doors Replacement (Annual) 80,000 80,000 50,000 80,00080,000DPW Automatic Flagger Unit 62,70062,700Mower Attachment Replacements (2) 94,000 50,00050,000Truck Scale Maintenance 40,00040,000Brine Tanks Storage 35,90035,900Air Compressor Replacement 40,300 Public Works Parking Lot Replacement 600,000 5,400,000 Crack Filler Tub Replacement 184,400 DPW Cold Storage Facility 100,000 1,300,000 DPW New Warm Storage Boiler Upgrade 70,000 DPW Trench Drain Replacement 70,000 VMF Backup Circulation Pump 60,000 DPW Finance HVAC Replacement 45,000 Crash Attenuator Trailer 60,000 63,100 DPW Admin Office Window Repair / Replace 40,000 200,000 Excavator Replacement 540,300 VMF HVAC Equipment Upgrades 40,000 500,000 Flatbed Truck Replacement 194,700 Hot Patch Trailer Replacement 106,800 DPW Heating Boiler Replacement 20,000 Skid Steer Pavement Planer Attach Repl 31,600 2,080,100 2,080,100 3,013,400 8,346,300 2,413,100 1,443,200 Sheriff's Office - Sheriff Restricted Dept 125,000125,000Jail Cell Water Controls Replacement 40,00040,000Jail Flooring Replacement - Annual 40,000 40,000 40,000 40,000 Jail Dental Suite Remodel 137,500 Jail Oven Replacement 99,000 Jail Washer & Dryer Replacements 60,000 Jail Huber Chiller Removal 15,000 165,000 165,000 336,500 55,000 40,000 40,000 Transit Dept 34,386 137,544171,930Passenger Wheelchair Access Repl (2) 177,088 167,868 172,904 178,091 171,930 34,386 137,544 177,088 167,868 172,904 178,091 345 84 of 99 County Budget- year Resources Existing Funding Debt Financing Grant or Other Financing 20302027 2028 2029 2031 Grand Total 6,048,645 11,024,130 2,424,255 24,401,60419,497,030 27,327,190 34,568,068 15,477,191 * For the 2027 Capital Improvement Plan, County Budget-year Resour ces include property tax levy, investment income, and State s upplemental aid to counties. “ADMIN HOLD" Status Projects Projects with an "ADMIN HOLD" status require appropriate approval to move forward with spending and contractual agreements. Capital Projects Dept - Building - Government Center: GC Asbestos Survey Abatement (County Board) Capital Projects Dept - Dept Req - Public Works - Parks: Park Expansion and/or Development (County Board) Lakeland Health Care Center Dept: Vacant Wing Modification (County Board) 346 85 of 99 Walworth County 2027 Capital Improvement Plan Years 6 through 10 Preliminary Plan 2032 - 2036 2032 2033 2034 2035 2036 Capital Projects Dept - Building - Government Center GC LURM Furniture Replacement 250,000 GC LURM Offices Remodel 225,000 GC Exterior Cladding Replacement 640,000 6,000,000 GC Roof Drains & Domestic Water Lines 165,000 GC Window Replacements 1,000,000 475,000 805,000 7,000,000 Capital Projects Dept - Building - Health & Human Services HHS Flooring Replacement - Annual 40,000 40,000 40,000 40,000 40,000 Public Health Spectrophotometer Replaced 10,000 HHS Chiller Replacement 40,000 500,000 Public Health Lab Incubator Replacement 12,000 40,00050,000 92,000 540,000 40,000 Capital Projects Dept - Building - Judicial Center JC Window Replacement 1,000,000 JC Air Handling Unit Upgrades 800,000 JC Elevator Renovations 200,000 JC Exterior Sealant 180,000 JC Flooring Replacement - Annual 50,000 50,000 50,000 50,000 50,000 JC Emergency Generator Replacement 256,000 JC IT Liebert CRAC Unit Replacement 225,000 275,0002,230,000 50,000 50,000 306,000 Capital Projects Dept - Building - Law Enforcement Center SO Huber Roof Replacement 550,000 SO Exterior Sealant 380,000 SO 2nd Floor Admin HVAC Renovation 100,000 SO Range Phase Converter System Replace 50,000 SO Exhaust Fan Replacements (4) 36,000 36,000 36,000 36,000 SO Jail Intake Remodel/Update 25,000 150,000 SO Administration Area Elevator Rehab 400,000 SO Energy Recovery Unit Replacement 30,000 375,000 SO Chiller Rehab or Replacement 50,000 1,000,000 1,036,0001,141,000 616,000 461,000 Capital Projects Dept - Dept Req - Clerk of Courts Court Room Technology Refresh Cycle 120,000 222,000 200,000 130,000 200,000120,000 222,000 130,000 Capital Projects Dept - Dept Req - Health & Human Services HHS Meals on Wheels Vehicle Repl. (2) 180,000 HHS Passenger Vehicle Replacements (2) 84,000 168,000 264,000 168,000 347 86 of 99 2032 2033 2034 2035 2036 Capital Projects Dept - Dept Req - Information Technology Buildings Network Infrastructure Repl. 325,000 175,000 340,000 260,000 150,000 Data Center Core Network Infrastructure 145,000 130,000 60,000 Server Host Infrastructure Replacement 55,000 90,000 57,500 57,500 60,000 Storage Infrastructure Replacement 350,000 375,000 Backup Infrastructure Replacement 175,000 250,000 Conference Room Displays (8) Repl. 80,000 80,000 IT Fleet Vehicle Replacement 63,000 JC & SO Firewall Replacement 300,000 Multi-Function Printer Replacements 150,000 150,000 607,500525,000 1,000,000 647,500 1,098,000 Capital Projects Dept - Dept Req - LURM LURM Vehicle Replacement 66,000 66,000 Capital Projects Dept - Dept Req - Public Works - Facilities Facilities Truck w/ Dump Insert Repl 115,000 Facilities Truck & Plow Replacement (1) 100,000 206,000 108,500 Facilities UTV Replacement 35,000 Facilities Brine Sprayer (3) Replacement 66,000 108,500250,000 206,000 66,000 Capital Projects Dept - Dept Req - Public Works - Parks White River Parking Lot Resurfacing 286,000 Park and Open Space Plan 50,000 336,000 Capital Projects Dept - Dept Req - Sheriff's Office Squad Replacement Purchase (10) 1,180,000 1,230,000 1,270,000 1,310,000 1,360,000 K-9 Unit Replacement 43,000 50,000 56,000 Patrol Drone Replacement 18,441 19,087 19,756 20,448 21,164 Mobile Emergency Response Vehicle Repl. 1,500,000 Portable and Mobile Radio Replacement 800,000 800,000 800,000 Dive Air Hose Replacement 30,600 2,186,4481,241,441 2,749,087 2,139,756 2,211,764 348 87 of 99 2032 2033 2034 2035 2036 Capital Projects Dept - Roadway Infrastructure CTH K (S. Co. Line to US-14) 5,091,000 CTH F (STH 67 to STH 50) 259,000 2,692,000 CTH C (State Line to STH-67) 108,000 1,448,000 CTH F Realignment - Lake Prie. Bus. Park 50,000 100,000 100,000 Unallocated Road Construction 205,000 1,084,000 CTH ES (USH 12 to CTH D) 30,000 261,000 3,507,000 CTH N (STH-20 to CTH J) 30,000 104,000 1,403,000 CTH P (CTH M to CTH A) 6,791,000 CTH F (STH 50 to USH-11) 30,000 150,000 2,019,000 CTH P Bridge over Bluff Creek 30,000 157,000 1,465,000 Whitewater Lake Dam Spillway Reconstruct 50,000 CTH H (LG City Limits to Williams St) 30,000 185,000 CTH P (CTH A to USH-12) 30,000 491,000 5,377,0005,508,000 4,405,000 8,300,000 4,310,000 Children with Disabilities Education Board Dept CDEB Parking Lot Refurbishment 2,430,000 CDEB Roof Replacement 1,300,000 CDEB South Playground Replacement 650,000 CDEB Flooring Replacement - Annual 60,000 60,000 60,000 60,000 60,000 CDEB Air Handling Unit Upgrades 50,000 1,000,000 Smart Board Replacement Cycle (7) 42,000 42,000 42,000 45,000 45,000 CDEB Emergency Generator Replacement 250,000 CDEB Bleacher Replacements (2) 100,000 105,0004,532,000 1,352,000 102,000 205,000 349 88 of 99 2032 2033 2034 2035 2036 Lakeland Health Care Center Dept Kitchen Hood & Controls 75,000 Whirlpool Tubs 25,000 25,000 25,000 30 Quart Floor Mixer 14,000 Full Body Lift 13,000 13,000 13,000 13,000 13,000 Food Holding/Transport Carts (2) 12,000 12,000 Vital Signs Monitors (2) 10,400 Sit to Stand Lift 9,000 9,000 9,000 9,000 9,000 Cook & Hold Oven 8,500 Double Deck Convection Oven 8,300 Ice & Water Dispenser 6,500 26,000 13,000 Resident Room/Household Recliners (2) 6,000 6,000 French Door Refrigerators (2) 4,000 4,000 4,000 4,000 4,000 Wheelchair Scale 2,500 2,500 25 Gallon Natural Gas Steam Kettle 40,000 Wheelchair Washer 17,000 Omni Cycle Rehab System 9,000 Automated External Defibrillators (3) 7,500 Air Mattresses (2) 5,900 Meat Grinder/Chopper 15,000 Natural Gas Deep Fryer 15,000 Commercial Food Cutter 12,000 6 Gallon Electric Steam Kettle 7,000 3.5 Quart Food Processor 5,000 Chest Freezer 4,000 Combination Oven/Steamer 26,000 Steam Table 4,300 LHCC Wheelchair Accessible Vehicle Repl 102,000 Nurse Call Light System 350,000 535,800194,200 105,400 102,000 90,000 Land Information Dept GIS Environment System 100,000 100,000 Orthophotography Acquisition 60,000 60,000 LIDAR Flight 100,000 100,000160,000 60,000 100,000 350 89 of 99 2032 2033 2034 2035 2036 Public Works - Highway Dept Tandem Axle Patrol Truck Replacement 485,000 500,000 1,024,000 1,050,000 1,080,000 Patrol Truck Replacement (2) 237,600 126,000 119,800 DPW Heating Boiler Replacement 200,000 Foreman Truck Replacement 155,300 164,700 Superintendent Vehicle Replacement 72,000 73,000 74,000 Forklift Replacement 45,366 48,200 Mower Attachment Replacement 38,100 39,000 Tandem Utility Trailer Replacement 26,000 28,500 Aerial Bucket Replacement 325,000 Flat Bed Truck Replacement 195,000 201,000 Wood Chipper Replacement 75,000 DPW Scale Replacement 40,000 225,000 Parts Truck Replacement 74,000 Portable and Mobile Radio Replacements 70,000 70,000 70,000 Broom Brush Attachment Replacement 17,500 Tractor Replacement 208,000 Dump Truck Single Axle Replacement 400,000 1,707,3001,259,366 1,208,000 2,024,400 1,358,000 Sheriff's Office - Sheriff Restricted Dept Jail Flooring Replacement - Annual 40,000 40,000 40,000 40,000 40,000 Jail Washer & Dryer Replacements 76,000 40,00040,000 40,000 116,000 40,000 Transit Dept Passenger Wheelchair Access Repl (4) 382,747 299,761 291,907 217,795 224,329 217,795382,747 299,761 291,907 224,329 Grand Total 12,536,34318,324,754 13,312,248 22,224,563 10,245,093 351 90 of 99 Walworth County 2027 Capital Projects Details and Operating Budget Impacts Preliminary Budget County Budget-year Resources Existing Funding Debt Grant or Other Financing Funding Source 2027 Project Cost Capital Projects Dept - Building - Government Center 50,000 Comprehensive asbestos containing material (ACM) identification survey and mapping with abatement for the government center facility. GC Asbestos Survey & Abatement No significant operating impact. 50,0002 - Safety issue or security concern ADMIN HOLD. County budget-year resources.Funding Description: Operating Budget Impact: Capital Projects Dept - Building - Judicial Center 165,000 Construct new ~300sqft IT closet behind existing closet in Clerk of Courts Dpt. Separation of DAIT, CCAP, and County IT equipment and address space limitations, code compliance, and allow for additional courtrooms in the future. 2028 move equipment. JC Data Closet Expansion No significant operating impact. 165,0007 - New capital asset Use of Capital Projects Fund capital improvement committed fund balance. Funding Description: Operating Budget Impact: 75,000 Additional funding required for existing project to complete the entire building. HVAC balancing, isolation and control valves are failing and replacement is required. Replacement includes over 100 valves. Existing budget is $336,000. JC Replace HVAC Valves No significant operating impact. 75,0003 - Replacement - end of life cycle County budget-year resources.Funding Description: Operating Budget Impact: 60,000 Heating boilers (2003) are original to the facility and have exceeded their life cycle (estimated at 20 years). Heating boilers are critical to the business operations of the facility and should be replaced to meet building specifications. JC Heating Boiler Replacement No significant operating impact. 60,0003 - Replacement - end of life cycle Use of Capital Projects Fund capital improvement committed fund balance. Funding Description: Operating Budget Impact: 352 91 of 99 /i255 /i255 /2 /3 /4 /5 /3 /6 /7 /8 /3 /4 /9 /10 /11 /i255 /13 /8 /11 /7 /10 /5 /i255 /14 /15 /10 /4 /10 /6 /5 /16 /5 /3 /17 /6 /i255 /18/19/16/15 /11 /i255 /20 /i255 /21 /22 /23 /24 /25 /22 /2 /i255 /26 /27 /28 /27 /29 /30 /i255 /i255 /i255 /i255 /i255/32 /33 /34 /35 /i255 /36 /37/i255 /i255 /i255 /38 /39 /40 /41 /42 /39 /43 /i255 /45 /46 /47 /48 /49 /42 /i255 /50 /51 /52 /53 /54 /51 /52 /55 /i255 /i255 /56 /57 /51 /52/58/55/51 /59 /i255 /60/61 /54 /62 /53 /52 /63 /64 /65 /i255 /50 /63 /64 /62 /52 /66 /54 /51 /55 /53 /52 /63 /64 /62 /i255 /i255 /56 /67 /54 /68 /63 /64 /66 /55 /51 /59 /i255 /60 /61 /54 /62 /53 /52 /63 /64 /62 /65 /i255 /69 /63/70/i255/52 /62/i255 /68 /55 /71 /52 /53 /55 /72 /i255 /62 /71 /54 /64 /66 /52 /64 /73 /i255 /66 /54 /74 /52 /64 /54 /66 /75 /i255/76/i255/78 /79/33 /80 /i255 /81 /82 /i255 /80 /79 /35 /i255 /83 /35 /84 /81 /85 /81 /80 /81 /86 /85 /i255 /86 /84 /i255 /87 /33 /88 /81 /80 /33 /89 /90 /i255 /76/i255/91/82 /i255 /80 /79 /81 /82 /i255 /83 /35 /84 /81 /85 /81 /80 /81 /86 /85 /i255 /92 /82 /35 /83 /i255 /87 /86 /85 /82 /81 /82 /80 /35 /85 /80 /89 /93 /i255 /33 /87 /94 /86 /82 /82 /i255 /80 /79 /35 /i255 /95 /92 /83 /34 /35 /80 /90 /i255 /96/97/55 /53 /i255 /52 /62/i255 /53 /97 /54 /i255 /72 /54 /98 /54 /72 /i255 /63 /74 /i255 /68 /55 /71 /52 /53 /55 /72 /i255 /62 /71 /54 /64 /66 /52 /64 /73 /75 /i255/76/i255/99/86 /100 /i255 /81 /82 /i255 /80 /79 /35 /i255 /89 /35 /101 /35 /89 /i255 /86 /84 /i255 /87 /33 /88 /81 /80 /33 /89 /i255 /82 /88 /35 /85 /83 /81 /85 /34 /i255 /83 /35 /80 /35 /94/102/81/85 /35 /83 /90 /i255 /76/i255/99/33 /82 /i255 /87 /33 /88 /81 /80 /33 /89 /i255 /82 /88 /35 /85 /83 /81 /85 /34 /i255 /81 /85 /87 /94 /35 /33 /82 /35 /83 /103 /83 /35 /87 /94 /35 /33 /82 /35 /83 /90 /i255 /76/i255/99/86 /100 /i255/102/92/87 /79 /i255 /87 /33 /88 /81 /80 /33 /89 /i255 /82 /88 /35 /85 /83 /81 /85 /34 /i255 /81 /82 /i255 /88 /33 /94 /80 /i255 /86/84 /i255 /94 /35 /87 /92 /94 /94 /81 /85 /34 /i255 /88 /94 /86 /34 /94 /33/102/90/i255 /69 /63/70/i255/55 /51/54 /i255 /68 /55 /71 /52 /53 /55 /72 /i255 /71 /51 /63 /104 /54 /68 /53 /62 /i255 /71 /51 /52 /63 /51 /52 /53 /52 /105 /54 /66 /75 /i255/76/i255/99/86 /100 /i255 /100 /35 /94 /35 /i255 /85 /35 /35 /83 /82 /i255 /83 /35 /80 /35 /94/102/81/85 /35 /83 /90 /i255 /76/i255/78 /79/33 /80 /i255 /92 /85/102/35/80 /i255 /85 /35 /35 /83 /82 /i255 /33 /94 /35 /i255 /85 /86 /80 /i255 /95 /92 /83 /34 /35 /80 /35 /83/i255 /84 /86 /94 /i255 /80 /79 /81 /82 /i255 /93 /35 /33 /94 /90 /i255 /76/i255/99/86 /100 /i255 /83 /86 /i255 /93 /86 /92 /i255/102/33/85 /33 /34 /35 /i255 /89 /81 /84 /35 /87 /93 /87 /89 /35 /i255 /87 /86 /82 /80 /82 /i255 /86/84 /i255 /33 /82 /82 /35 /80 /82 /90 /i255 /69 /63/70/i255/52 /62/i255 /53 /97 /54 /i255 /68 /55 /71 /52 /53 /55 /72 /i255 /106 /61 /66 /73 /54 /53 /i255 /74 /61 /64 /66 /54 /66 /75 /i255/76/i255/78 /79/33 /80 /i255 /94 /35 /101 /35 /85 /92 /35 /i255 /82 /86 /92 /94 /87 /35 /82 /i255 /87 /86 /85 /80 /94 /81 /95 /92 /80 /35 /i255 /80 /86 /i255 /87 /33 /88 /81 /80 /33 /89 /i255 /82 /88 /35 /85 /83 /81 /85 /34 /90 /i255 /107 /62 /i255 /68 /55 /71 /52/53 /55 /72 /i255 /62 /71 /54 /64 /66 /52 /64 /73 /i255 /74 /63 /51 /i255 /64 /54/70/i255/55 /62 /62 /54 /53 /62 /108 /i255 /51 /54 /71 /72 /55 /68 /54/58/54/64 /53 /i255 /55 /62 /62 /54 /53 /62 /108 /i255 /63 /51 /i255 /53 /63 /i255 /51 /54 /97 /55 /106 /52 /72 /52 /53 /55 /53 /54 /i255 /54 /109 /52 /62 /53 /52 /64/73 /i255 /55 /62 /62 /54 /53 /62 /75 /i255 /76/i255/78 /79/93 /i255 /33 /94 /35 /i255 /85 /35 /100 /i255 /88 /94 /86 /110 /35 /87 /80 /82 /i255 /85 /35 /87 /35 /82 /82 /33 /94 /93 /90 /i255 /76/i255/78 /79/33 /80 /i255 /87 /33 /88 /81 /80 /33 /89 /i255 /82 /88 /35 /85 /83 /81 /85 /34 /i255 /81 /82 /i255 /84 /86 /94 /i255 /85 /35 /100 /i255 /88 /94 /86 /110 /35 /87 /80 /82 /90 /i255 /76/i255/78 /79/33 /80 /i255 /87 /33 /88 /81 /80 /33 /89 /i255 /82 /88 /35 /85 /83 /81 /85 /34 /i255 /81 /82 /i255 /84 /86 /94 /i255 /94 /35 /88 /89 /33 /87 /35/102/35/85 /80 /82 /i255 /111 /86 /94 /i255/102/33/110 /86 /94 /i255 /94 /35 /79 /33 /95 /112 /90 /i255 /76/i255/78 /79/33 /80 /i255 /81 /82 /i255 /80 /79 /35 /i255 /86 /88 /35 /94 /33 /80 /81 /85 /34 /i255 /81/102/88/33 /87 /80 /i255 /33 /85 /83 /i255 /84 /92 /80 /92/94 /35 /i255 /87 /86 /82 /80 /i255 /86 /84 /i255 /83 /35 /84 /35 /94 /94 /35 /83 /i255 /87 /33 /88 /81 /80 /33 /89 /i255 /82 /88 /35 /85 /83 /81 /85 /34 /90 /i255 /76/i255/78 /79/33 /80 /i255 /33 /94 /35 /i255 /84 /92 /80 /92 /94 /35 /i255 /86 /88 /35 /94 /33 /80 /81 /85 /34 /i255 /87 /86 /82 /80 /82 /i255 /33 /85 /83 /i255/87 /33 /85 /i255 /80 /79 /35 /i255 /95 /92 /83 /34 /35 /80 /i255 /33 /87 /87 /86/102/102/86/83 /33 /80 /35 /i255 /81 /80 /90 /i255 /i255 /i255 /i255 /96/97/55 /53 /i255 /55/51 /54 /i255 /53 /97 /54 /i255/58/55/104 /63 /51 /i255 /71 /51 /63 /104 /54 /68 /53 /62 /75 /i255/76/i255/78 /79/33 /80 /i255 /95 /35 /85 /35 /84 /81 /80 /i255 /100 /81 /89 /89 /i255 /88 /94 /86 /110 /35 /87 /80 /82 /i255 /88 /94 /86 /101 /81 /83 /35 /90 /i255 /76/i255/78 /79/35 /85 /i255 /33 /94 /35 /i255 /88 /94 /86 /110 /35 /87 /80 /82 /i255 /35 /113 /88 /35 /87 /80 /35 /83 /i255 /80 /86 /i255 /86 /87 /87 /92 /94/90 /i255 /76/i255/99/86 /100 /i255 /33 /94 /35 /i255 /88 /94 /86 /110 /35 /87 /80 /82 /i255 /84 /92 /85 /83 /35 /83 /i255 /111 /84 /92 /85 /83 /81 /85 /34 /i255 /82 /86 /92 /94 /87 /35 /82 /112 /90 /i255 /76/i255/114/94 /35 /i255 /88 /94 /86 /110 /35 /87 /80 /82 /i255 /84 /92 /89 /89 /93 /i255 /84 /92 /85 /83 /35 /83 /90 /i255 /76/i255/114/94 /35 /i255 /33 /85 /93 /i255 /88 /94 /86 /110 /35 /87 /80 /82 /i255 /87 /86 /85 /80 /81 /85 /34 /35 /85 /80 /i255 /86 /85 /i255 /94 /35 /87 /35 /81 /101/81 /85 /34 /i255 /84 /92 /80 /92 /94 /35 /i255 /84 /92 /85 /83 /81 /85 /34 /i255 /87 /86/102/102/81/80/102/35/85 /80 /82 /90 /i255 /i255 92 of 99 Finance | 100 W. Walworth St. | PO Box 1001 | Elkhorn, WI 53121 www.co.walworth.wi.us | (262) 741-4242 (o) | (262) 741-4384 (f) Memorandum T o: Walworth County Finance Committee From: Jessica Conley, Finance Director Date: November 9, 2026 RE: Money Market Investment Opportunity A nnually, staff contact local banks and credit unions to discuss certificates of deposits (CDs)and money market opportunities to determine whether the financial institutions would like to continue to receive our monthly requests for CDs or would be willing to provide the County a money market that exceeds Local Government Investment Pool (LGIP) and is appropriately collateralized. This year during our review process, Fort Community Credit Union offered the County a third party collateralized money market account at 45 basis points above the prior month’s LGIP rate. M oney Market Investment Holding Change As of October 31, 2026, the County held $86.7 million in money market funds, including $41.1 million at Advia Credit Union (rate equal to prior month’s LGIP) and $45.6 million at Citizens Bank (rate equal to LGIP plus 10 basis points). Staff contacted both financial institutions, who agreed to match the rate offered by Fort Community Credit Union. M oving forward, once account details and third-party collateral have been established with Fort Community Credit Union, the County will split the funding currently held between the three financial institutions. Based on the current balance and interest-rate index, the additional 45 basis points are expected to generate approximately $344,366 in additional annual interest income. C ollateral Terms Advia Credit Union pledges U.S. Treasury and federal agency securities in Walworth County’s name at the Federal Home Loan Bank of Indianapolis. These securities serve as collateral for deposits exceeding the federally insured limit of $250,000. Ci tizens Bank maintains an irrevocable letter of credit with the Federal Home Loan Bank of Chicago in lieu of pledged collateral to secure deposits exceeding the federally insured limit of $250,000. 93 of 99 Finance | 100 W. Walworth St. | PO Box 1001 | Elkhorn, WI 53121 www.co.walworth.wi.us | (262) 741-4242 (o) | (262) 741-4384 (f) Fort Community Credit Union has agreed to an irrevocable letter of credit with the Federal Home Loan Bank of Chicago to secure deposits exceeding the federally insured limit of $250,000. Conclusion Staff are in progress with the account set-up at Fort Community Credit Union. The Credit Union has requested we consider an alternative approach to the collateral holdings. We have been unable to connect with the Credit Union team prior to this memo, but we may have additional information at the Finance Committee meeting. Fort Community Credit Union understands that no change can be made until the Finance Committee has received additional information regarding their preferred custodial agreement terms and approved a change to the investment guide. Fort Community Credit Union understands the earliest that a decision could be made regarding this change is the December Finance Committee. Staff will be available for questions at the November meeting. JC/pjs 94 of 99 Finance | 100 W. Walworth St. | PO Box 1001 | Elkhorn, WI 53121 www.co.walworth.wi.us | (262) 741-4242 (o) | (262) 741-4384 (f) Memorandum T o: Walworth County Finance Committee From: Jessica Conley, Finance Director Date: November 10, 2026 RE: Finance Department Announcements and Updates T he following updates highlight key efforts of the Finance Department. S pecial Projects: Financial Reporting Software ($200,000): The first priority of the financial reporting software project is creating the County’s yearend financial statements with greater automation and in a format that meets website compliance requirements. Currently expected to be ready for yearend reporting needs in early 2027. Phase 2 capital planning is in process of being designed by County staff. V endor Verification Software ($60,000): Early meetings regarding the vendor verification project have included the County’s bank regarding set-up. Bank representatives stated they were very excited to hear about the County’s decision to implement this software. The software target start date is January 2027. R egulatory Updates: Proposed Changes to Federal Grant Uniform Guidance: The changes proposed to the Federal Grant Uniform Guidance have been delayed until December 11, 2026, with a chance this could again be delayed. Staff are monitoring updates for how we can be prepared. S taffing Updates: 27.55 FTEs (29 employees): 1 remaining vacancy Th e Accounts Payable/Purchasing Administrative Clerk III position has been filled with a former Finance Department employee who previously worked part-time for us. Kyra Chochola will be with us beginning Monday, November 16, 2026. 95 of 99 Finance | 100 W. Walworth St. | PO Box 1001 | Elkhorn, WI 53121 www.co.walworth.wi.us | (262) 741-4242 (o) | (262) 741-4384 (f) The Accountant position supporting Health and Human Services (HHS) and Lakeland Health Care Center is vacant following Shelby Bechman’s recent promotion to the full- time Senior Accountant position with HHS. If any new information develops, I will share these announcements at the meeting. JC/pjs 96 of 99 Finance | 100 W. Walworth St. | PO Box 1001 | Elkhorn, WI 53121 www.co.walworth.wi.us | (262) 741-4242 (o) | (262) 741-4384 (f) Memorandum To: Walworth County Finance Committee From: Jessica Conley, Finance Director Date: November 10, 2026 RE: American Rescue Plan Act (ARPA) Financial Update The third quarter summary report reflecting the totals provided to the U.S. Treasury is attached. It reflects all but $20,000 of spending completed with just over a month to finalize the remaining project of the Lakeland Animal Welfare Society (LAWS) animal shelter small animal cages. Lakeland Animal Welfare Society Small Animal Cages The small animal cages were delivered November 5, 2026. We are currently awaiting installation, verification of completion, and payment. Per contract with LAWS, this process must be completed by December 4, 2026, to utilize the grant funding. Automated External Defibrillator (AED) The 15 AEDs funded with Local Assistance and Tribal Consistency Fund (LATCF) grant funding are in process of being ordered. An additional budget amendment of $1,077 from the County’s ARPA interest reserves was utilized to finalize the purchase due to an increase in the cost per unit. Staff will be available to answer any ARPA or LATCF grant-related questions at the meeting. JC/pjs Attachment 97 of 99 Walworth County Recovery Grant Actual 2021 to 3Q 2026 + Remaining Obligations Gray designation indicates that project is likely complete. Post Obligation Deadline 2021-2024 2025 2026 2026 2026 2026 2026 Expense Category (EC) Combined YTD Actual YTD Actual 1st Qtr Claim 2nd Qtr Claim 3rd Qtr Claim YTD Actual Remaining Obligations Actual + Remaining Obligations Public Health (EC 1) Mental Health Services in the Jail 149,156.38 51,455.01 16,269.83 7,274.17 - 23,544.00 - 224,155.39 Embedded Crisis Liaison Program Expansion (Net Revenue) 436,146.65 - - - - - - 436,146.65 Public Health Mobile Vehicle 177,030.79 - - - - - - 177,030.79 Mental Health Support for Students and Schools 90,498.03 - - - - - - 90,498.03 Drinking Fountain Upgrades in County Buildings 11,318.85 - - - - - - 11,318.85 Pandemic Prisoner Transports 175,000.00 - - - - - - 175,000.00 County Pandemic Response Supplies 12,384.29 - - - - - - 12,384.29 Health Insurance Reimbursement 634,567.57 94,375.04 - 27,810.00 - 27,810.00 - 756,752.61 Subtotal (EC 1) 1,686,102.56 145,830.05 16,269.83 35,084.17 - 51,354.00 - 1,883,286.61 Negative Economic Impacts (EC 2) Social Service Organization Grants (United Way) 475,000.00 238,100.00 - 160,900.00 1,000.00 161,900.00 - 875,000.00 Aid to Tourism, Travel or Hospitality (WCVB) 34,000.00 - - - - - - 34,000.00 Tourism Industry Promotion and Development 5,000.00 - - - - - - 5,000.00 Veterans Impacted by Pandemic 95,899.48 - - - - - - 95,899.48 Veterans Benefit Navigator 24,182.87 - - - - - - 24,182.87 Financial Coaching/Economic Assistance 57,000.00 1,600.00 - - - - - 58,600.00 Walworth County Housing Authority 160,000.00 - - - - - - 160,000.00 Subtotal (EC 2) 851,082.35 239,700.00 - 160,900.00 1,000.00 161,900.00 - 1,252,682.35 Public Health-Negative Economic Impact Public Sector Capacity (EC3) Emergency Management Program Assistant (Moved to EC 6) 163,572.57 - - - - - - 163,572.57 Pandemic Entrance Monitors 104,999.83 - - - - - - 104,999.83 WCEDA - Child Care Study 9,500.00 - - - - - - 9,500.00 Pandemic-Impacted Court Backlog 90,883.08 39,394.49 - - - - - 130,277.57 Subtotal (EC 3) 368,955.48 39,394.49 - - - - - 408,349.97 Premium Pay (EC 4) Sheriff's Office Dispatch and Corrections Premiums 54,247.54 - - - - - - 54,247.54 Mass Transit Drivers Premium Pay (Moved to EC 6) 164,544.99 - - - - - - 164,544.99 Subtotal (EC 4) 218,792.53 - - - - - - 218,792.53 Infrastructure-Water, Sewer & Broadband (EC 5) Broadband Expansion-Charter - 500,000.00 - - - - - 500,000.00 Broadband Expansion-Edge - 25,000.00 - - - - - 25,000.00 Subtotal (EC 5) - 525,000.00 - - - - - 525,000.00 Revenue Replacement (EC 6) Transportation Program Vehicles-2023 462,401.38 - - - - - - 462,401.38 Transportation Program Vehicles-2024 326,663.13 - - - - - - 326,663.13 HR Personnel (Remote Training - Learning Management System ) 26,638.17 - - - - - - 26,638.17 IT Personnel (Cybersecurity ) 274,734.80 - - - - - - 274,734.80 Pretrial Services Coordination 52,360.95 - - - - - - 52,360.95 Management Analyst 43,428.72 - - - - - - 43,428.72 Deputy Assigned Squads-2023 307,720.00 - - - - - - 307,720.00 Deputy Assigned Squads-2024 312,964.68 - - - - - - 312,964.68 Medical Support for Low-income Individuals 414,202.00 203,564.00 34,152.00 61,128.00 36,981.00 132,261.00 - 750,027.00 Dispatch Staffing 86,692.19 - - - - - - 86,692.19 HR Generalist 151,798.86 - - - - - - 151,798.86 Buyer 224,529.64 87,897.40 - - - - - 312,427.04 Systems Analyst/Developer 84,523.23 - - - - - - 84,523.23 Library Service 45,948.00 - - - - - - 45,948.00 HR Administration Clerk III 56,248.07 49,818.18 14,271.85 - - 14,271.85 - 120,338.10 Sheriff Personnel (Text-to-911/911 System & CAD-to-CAD SWAP ) 122,459.64 - - - - - - 122,459.64 98 of 99 Walworth County Recovery Grant Actual 2021 to 3Q 2026 + Remaining Obligations Gray designation indicates that project is likely complete. Post Obligation Deadline 2021-2024 2025 2026 2026 2026 2026 2026 Expense Category (EC) Combined YTD Actual YTD Actual 1st Qtr Claim 2nd Qtr Claim 3rd Qtr Claim YTD Actual Remaining Obligations Actual + Remaining Obligations Revenue Replacement (EC 6) (continued) SO OT (Emergency Medical Dispatch Automation Swap ) 70,000.00 - - - - - - 70,000.00 IT Business Analysts Services 314,164.52 - - - - - - 314,164.52 HHS Electronic Health Record System 276,081.00 - - - - - - 276,081.00 911 Municipal Radio System Replacement 2,973,715.49 - - - - - - 2,973,715.49 911 Center Radio System Replacement 981,304.27 590,114.17 - - - - - 1,571,418.44 Walworth County Economic Development Alliance- 123,309.92 86,974.84 4,715.24 - - 4,715.24 - 215,000.00 UTVs (2) and trailer (net any trade-in from ATVs (2)) 67,218.08 - - - - - - 67,218.08 Clerk of Court - Court Backlog and Consultant 485,504.75 139,495.00 - 75,000.00 - 75,000.00 - 699,999.75 District Attorney - Law Clerk 49,384.47 89,173.75 - - - - - 138,558.22 IT-Upgrades at HHS Auditorim (County Board Room) 13,894.92 - - - - - - 13,894.92 CTH O (CTH A to USH 12 North) 2,000,000.00 - - - - - - 2,000,000.00 Epidemiologist 14,749.51 - - - - - - 14,749.51 Storage Area Network (SAN) IT 126,428.97 - - - - - - 126,428.97 Community Action Agency Financial Support - 167,000.00 - 18,000.00 - 18,000.00 - 185,000.00 Emergency Management Program Assistant (Moved from EC 3) 150,994.52 92,581.60 24,703.17 24,081.70 16,160.49 64,945.36 - 308,521.48 Emergency Medical Service (EMS) Study 13,250.00 13,250.00 - - - - - 26,500.00 Mass Transit Drivers Premium Pay (Moved from EC 4) 13,583.82 - - - - - - 13,583.82 Dive Boat - - - 346,164.00 - 346,164.00 - 346,164.00 Masks and AEDs in Squads 93,258.00 86,871.18 - - - - - 180,129.18 LURM-Conservation Tech 17,980.11 86,597.28 - - - - - 104,577.39 Health System Analyst - 170,114.74 4,385.26 - - 4,385.26 - 174,500.00 LAWS-Small Dog Cages - - - - - - 20,000.00 20,000.00 White River Park-Pavillion and Overflow Parking 17,054.00 217,633.10 - - - - - 234,687.10 Webster House Repairs 95,508.00 104,492.00 - - - - - 200,000.00 IT-Minivan 42,962.02 - - - - - - 42,962.02 Risk Management-Safety Equipment 43,834.59 11,705.92 - - 2,658.00 2,658.00 - 58,198.51 911 System-County Towers 1,311,322.49 - - - - - - 1,311,322.49 Subtotal (EC 6) 12,288,816.91 2,197,283.16 82,227.52 524,373.70 55,799.49 662,400.71 20,000.00 15,168,500.78 Administrative Services (EC 7) County Administrative Support Recovery Grant Manager, Audit, and Consulting 469,349.75 142,428.54 - - - - - 611,778.29 HR Generalist 6,539.06 - - - - - - 6,539.06 Accountant 26,448.75 - - - - - - 26,448.75 Buyer 7,830.69 - - - - - - 7,830.69 Systems Analyst/Developer/Temp Help 42,149.78 - - - - - - 42,149.78 Municipal Consulting Services 23,782.19 - - - - - - 23,782.19 Subtotal (EC 7) 576,100.22 142,428.54 - - - - - 718,528.76 TOTALS 15,989,850.05 3,289,636.24 98,497.35 720,357.87 56,799.49 875,654.71 20,000.00 20,175,141.00 Amount spent thru 3Q 2026 20,155,141.00 LAWS-Small Dog Cages 20,000.00 Subtotal Remaining Obligations 20,000.00 Total Actual Spent + Remaining Obligations Total Actual Spent + Remaining Obligations 20,175,141.00 99 of 99

Source: Walworth County website. First collected Nov 17, 2026.