Muyni
← Back to Lisbon

Public Works & Utility Committee

Regular Meeting

Lisbon, WI · July 17, 2024

AgendaMinutes

Minutes

VILLAGE OF LISBON Public Works & Utility Committee Minutes July 17, 2024 DRAFT PUBLIC WORKS & UTILITY COMMITTEE MINUTES The regular meeting of the Lisbon Public Works & Utility Committee was held on Wednesday, July 17, 2024, at the Lisbon Village Hall, W234 N8676 Woodside Road, Lisbon, WI. Committee Chair Marc Moonen called the meeting to order at 5:00 p.m. Roll Call: Present: Trustee Marc Moonen; Trustee Linda Beal (Vice-Chair); Committee members Jane Mueller, Joe Eberle, and Dan Plese; Utility District Accountant Mike Sargent; DPW Director Nick Wilichowski; Administrator Kathy Nickolaus; and Clerk Elisa Cappozzo Katch to record the minutes. Clerk Cappozzo noted Village Engineer Don Neitzel was running late. Pledge of Allegiance The Committee and members of the public recited the Pledge of Allegiance. Citizen Comment Gretchen Hoffman, W225N8080 Rolling Hills Drive, requested two stop signs on the intersection of Rolling Hills Drive and Longview due to a recent accident and safety concerns for children and pedestrians in the area. Mr. Moonen acknowledged the resident's statement and directed her to either leave her phone number with the clerk or have neighbors send comments to him or the Clerk. Minutes – 6/19/2024 Public Works & Utility Committee Marc Moonen invited comments on the draft minutes. Member Mueller asked if the location of sewer pump station could be included in the item approving Brabazon’s repair quote. Motion by Eberle, second by Plese, to approve the minutes of the June 19, 2024, Public Works & Utility Committee meeting as amended. Motion carried unanimously. Department Reports A. Dept. of Public Works DPW Director Nick Wilichowski gave a brief update on current DPW projects and accomplishments (see attached). No action was taken. B. Utility District Utility Administrator Mike Sargent reported successfully posting the C-MAR and noted that residential billing went out on July 1st. An increase of 26% in metered consumption by the end of June was observed, indicative of higher sewer processing volumes. Office: (262)246-6100 | Email: villagehall@lisbonwi.gov | Web: www.LisbonWI.gov Public Works & Utility Committee Minutes July 17, 2024 Page 2 of 3 Engineer Don Neitzel gave a brief update of current Utility District projects and accomplishments. He informed the committee that average flow data for June was discussed, and updates on sewer system maps and maintenance were included. It was noted that one section of sewer near Janine might need cleaning due to ponding water. Members questioned cleaning contracts and meter measurements, to which Engineer Neitzel explained there were no massive issues but recommended occasional cleaning for proper maintenance. New Business A. Sewer Rate Study presentation by Ehlers & recommendation to Village Board Jon Cameron and Ariana Schmidt from Ehlers provided an overview of the sewer rate study, which included examining historical rate performance, the upcoming wastewater treatment facility project in Sussex, and the potential impact on residential bills. Two options were outlined. Committee members debated the implications of both options, including rate increases and impact on cash flow. Most favored applying cash reserves considering future developments and possible rate stabilization. "Motion to recommend Option 2 with a set annual rate increase of 2%, starting in 2025, while using cash reserves for the project costs." Motion by Eberle, seconded by Beal. Motion passed unanimously. B. Request for speed controls at intersection of McKerrow & William Drives Chair Moonen reviewed the resident request for speed controls on McKerrow and William Drives. The results of the Sheriff's speed study, conducted between June 11th and June 26th, indicated that approximately 3% of the vehicles exceeded the speed limit of 25 mph. Consequently, the committee decided against making any changes to the current speed limit. "Motion to take no action on changing the speed limits on McKerrow and William Drives." Motion by Mueller, seconded by Beal. Motion passed unanimously. Unfinished Business A. Richmond School plans to address ongoing utility issues Don Neitzel mentioned discussions with school representatives regarding various maintenance issues including possible groundwater or septic issues impacting the area. A meeting with Adam Landowski from the school was scheduled to address and gather details on the highlighted concerns. Members emphasized the need to ensure that the school addresses maintenance issues to avoid further complications related to utility systems. No action taken. Office: (262)246-6100 | Email: villagehall@lisbonwi.gov | Web: www.LisbonWI.gov Public Works & Utility Committee Minutes July 17, 2024 Page 3 of 3 Items for next Public Works & Utility agenda Marc Moonen proposed creating a formal process for handling traffic complaints and digitalizing it for easier navigation by staff and residents. Committee members showed support for this initiative. Additionally, the committee will be tasked with reviewing a stop sign request at the intersection of Rolling Hills Drive and Longview. Adjournment There being no further business, Beal moved to adjourn. The motion was seconded by Moonen, was voted on, and carried unanimously. The meeting was adjourned at 6:14p.m. Respectfully submitted, Elisa Cappozzo Katch, WCMC Lisbon Village Clerk Office: (262)246-6100 | Email: villagehall@lisbonwi.gov | Web: www.LisbonWI.gov

Agenda

VILLAGE OF LISBON W234 N8676 Woodside Rd Lisbon, WI 53089-1545 Join Zoom Online: https://us06web.zoom.us/j/88319721129?pwd=Rm1tdkgzcW9PMG5HY051MlBpbzR4UT09 Join Zoom by Phone: Dial 1-312-626-6799 Meeting ID: 883 1972 1129 Passcode: 027704 PUBLIC WORKS & UTILITY COMMITTEE AGENDA Lisbon Village Hall Wednesday, July 17, 2024 5:00P.M. 1. Call to Order & Roll Call 2. Pledge of Allegiance 3. Citizen Comment (Please limit comments to three minutes) 4. Approval of Meeting Minutes • June 19, 2024 Public Works & Utility Committee 5. Department Reports A. Dept. of Public Works – Nick Wilichowski B. Utility District – Don Neitzel & Mike Sargent 6. New Business A. Discussion and necessary action re: Sewer Rate Study, and recommendation to Village Board of the same (Ehlers) B. Discussion and necessary action re: resident request for speed controls on McKerrow & William Drives, review of related Speed Study, and recommendation to the Village Board of the same (Deputy) 7. Unfinished Business A. Review, discussion, and necessary action re: Richmond School plans to address ongoing utility issues, and recommendation to the Village Board of the same (Don) 8. Items to be Placed on a Future Agenda 9. Adjournment NOTE: It is possible that members of and possibly a quorum of other governmental bodies may attend the above meeting to gather information. No action will be taken by any governmental body other than specifically noticed above. Requests from persons with disabilities who need assistance to participate in this meeting or hearing should be made to the Lisbon Clerk’s office at 262-246-6100 at least 72 hours in advance of the meeting. Office: (262) 246-6100 | Email: villagehall@lisbonwi.gov | Website: www.lisbonwi.gov VILLAGE OF LISBON Meeting Minutes June 19, 2024 DRAFT PUBLIC WORKS & UTILITY COMMITTEE The regular meeting of the Lisbon Public Works & Utility Committee was held on Wednesday, June 19, 2024, at the Lisbon Village Hall, W234 N8676 Woodside Road, Lisbon, WI. Committee Chair Marc Moonen called the meeting to order at 5:03 p.m. Roll Call: Present: Trustees Marc Moonen and Linda Beal (Vice-Chair); Committee members Jane Mueller, Joe Eberle, and Dan Plese; Utility District Accountant Mike Sargent; DPW Director Nick Wilichowski; and Clerk Elisa Cappozzo Katch to record the minutes. Administrator Kathy Nickolaus was absent and excused. The Committee and members of the public recited the Pledge of Allegiance. Citizen Comments None. Minutes – 5/15/2024 Public Works & Utility Committee Motion by Beal, second by Eberle, to approve the minutes of the May 15, 2024 Public Works & Utility Committee meeting as presented. Motion carried unanimously. Department Reports A. Dept. of Public Works DPW Director Nick Wilichowski gave a brief update on current DPW projects and accomplishments. No action was taken. B. Utility District Utility Administrator Mike Sargent reported on April flows for the Utility District, and Utility Engineer Don Neitzel reviewed highlights from his monthly report. No action was taken. Unfinished Business A. Approve Sabel Mechanical quote for Air Relief Valves for the Richmond Force Main Engineer Neitzel reviewed the quote for installation of Air Relief Valves to alleviate pressure issues, while also acknowledging that installing new valves could be experimental in resolving ongoing pump issues. Discussion on installing air relief valves for the Richmond Force Main noted various possible solutions and costs, concluding that further precision on exact issues within the force main was essential. Office: (262)246-6100 | Email: villagehall@lisbonwi.gov | Web: www.LisbonWI.gov Public Works & Utility Committee Minutes June 19, 2024 Page 2 of 4 Motion by Moonen, second by Mueller, to TABLE the decision on purchasing Air Relief Valves for Richmond Force Main until further updates are available. Motion carried unanimously. B. Request for approval of Brabazon repair/replace quote for sewer pump The committee discussed options for repairing or replacing a failed pump. The repair and replacement costs were both presented. Motion by Mueller, second by Eberle, to APPROVE the repair of the pump at a cost of $4,535 plus freight, and recommendation to Village Board of the same. Motion carried unanimously. C. Discussion only re: Richmond School/ Fire Dept cost split agreements Discussion reiterated the current cost division between Richmond School and the Fire Department, emphasizing the longstanding 65/35 cost split agreement since 1997, allocated for maintenance issues. No action taken. D. Request for speed reduction on Mary Hill Road Citizens requested a speed reduction due to increased traffic. A comprehensive discussion ensued, including speed study results indicating substantial ongoing traffic and potential changes with approaching residential developments. Monitoring strategies included temporary speed signs installation, followed by reassessment. Motion by Mueller, second by Plese, to TABLE until September to allow time for additional data to be collected and analyzed. Motion carried unanimously. E. Request for speed controls on Batterjohn Despite previous data, an updated speed study highlighting minor violations suggested no current traffic and speed controls were sufficient. Motion by Mueller, second by Plese, to DENY the request for speed controls. Motion carried unanimously. F. Request for speed controls on Walnut Grove Similar to Batterjohn, an additional speed study indicated reduced vehicle numbers and violations. Due to the large difference in numbers compared to a previous speed study, committee requested a third study be conducted to verify second set of results. Motion by Mueller, second by Eberle, to TABLE further action on Walnut Grove speed controls until the new July study results. Motion carried unanimously. Office: (262)246-6100 | Email: villagehall@lisbonwi.gov | Web: www.LisbonWI.gov Public Works & Utility Committee Minutes June 19, 2024 Page 3 of 4 G. Request for STOP signs in Harvest Ridge subdivision A comprehensive discussion supported installing stop signs at key intersections within the newly constructed subdivision, with the developer willing to cover any costs. Motion by Eberle, second by Plese, to APPROVE installation of three-way stop signs at the intersection of Harvest Ridge, Autumn Run, and Crispin Court with cost being invoiced to the developer, and recommendation to Village Board of the same. Motion carried unanimously. New Business A. Richmond School plans to address ongoing utility issues Don Neitzel updated the committee on needs for further investigation linked to roof drain issues and infiltration. Initial approaches included direct communication with the new ground keeping officials and potential testing emphasizing current infrastructure optimization. Discussion revolved around meeting with the new groundskeeper and possibly performing smoke and dye testing to find more data on existing issues. No action taken; bring back for further discussion if/when additional information is available. B. Approve mower radio work and strobe puck installation Detailed work required on a new tractor outlined including lights and radios. It was recommended to forward the details to the board, allowing staff authority to handle the developments. Direction was given to staff to handle radio and strobe light work within the already budgeted parameters. No formal action taken. C. Award 2024 Crack Fill bid and recommendation to Village Board DPW Director Willichowski noted there were 2 bids received: Thunder Road and Fahrner. Thunder Road completed other similar work in years past in Lisbon and there were concerns with how it was wearing. Additionally, they may not be a qualified bid due to materials proposed. His recommendation was to award bid to Fahrner based on compliance with bid specs and previous satisfactory work results. Motion by Mueller, second by Eberle, to award base and alternate crack fill bids to Farner in an amount not to exceed $99,123.00, and recommendation to Village Board of the same. Motion carried unanimously. D. Award 2024 Seal Coat bid and recommendation to Village Board DPW Director Willichowski noted there were 2 bids received: Scott was low for Base and overall, and Fahrner was low for Base + Alternate #1. Office: (262)246-6100 | Email: villagehall@lisbonwi.gov | Web: www.LisbonWI.gov Public Works & Utility Committee Minutes June 19, 2024 Page 4 of 4 Motion by Mueller, second by Eberle, to award Base + Alternate #1 + Alternate #2 of the seal coat bid to Scott Construction in an amount not to exceed $168,288.50, and recommendation to Village Board of the same. Motion carried 4:1 with Beal dissenting. Items for next Public Works & Utility agenda Suggestions included gravity sewer updates, Richmond School interaction outcomes, and specific speed evaluations' results in the upcoming meetings. Adjournment There being no further business, Mueller moved to adjourn. The motion was seconded by Plese, was voted on, and carried unanimously. The meeting was adjourned at 7:25p.m. Respectfully submitted, Elisa Cappozzo Katch, WCMC Lisbon Village Clerk Office: (262)246-6100 | Email: villagehall@lisbonwi.gov | Web: www.LisbonWI.gov DPW Monthly Report (June) Highway • Service on trucks • Service on equipment • Pressure washing and cleaning trucks and equipment post brush pickup • Started mowing • George has been assigned building the new pickup truck • Patching holes • Paved park path for Sussex • Lots of washout repairs due to excessive rain • Tree cleanup due to storms and excessive rain, lots of bucket truck work • Ditching Jolyn Drive, Longview and Mountain Shadows • Paved section of Mary Hill Director • Invoices • Permits • Weed letters • Job Interviews with Kathy • Check out ditch complaints and shot numbers with transit • Patched holes • Shouldering and washout repairs • Paved Sussex’s park path • Bucket truck work • Storm clean up • Ditching Jolyn Drive, Longview and Mountain Shadows • Paved Section of Mary Hill Parks • Mowing • Maintenance in the park (edging, weed whacking, weeding) • Baseball Field grooming • Prepping for Community Fest • Repairing John Deere Mower SEWER UTILTY ACCOUNTANT REPORT TO PUBLIC WORKS COMMITTEE JUNE -JULY 2024 1) The CMAR was filed and accepted by the DNR 2) July 1, 2024 residential billing was completed. Village of Lisbon, WI 2024 Sewer Long Range Cash Flow Analysis July 17, 2024 Public Works & Utility Committee Why are we here? • Ehlers to identify fiscal sustainability • Funding for Sussex Wastewater Treatment Facility • Our Process:  Historical Rate Performance  Future Projections  O&M, Depreciation  Funding Project  Rate Impact 2 Historical Rate Performance Cash Basis $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 $0 2019 2020 2021 2022 2023 2024 Operating and Maintenance Debt Cash Funded Capital Revenue Requirement User Rates Revenue 3 Historical Financial Indicators Reserves - Actual vs. Target 1,200,000 Actual Estimated Budget 1,000,000 2019 2020 2021 2022 2023 2024 800,000 Target minimum cash balance 600,000 Target minimum working capital - Ehlers 1 233,442 162,766 213,765 209,242 214,308 231,165 400,000 Actual Days Cash Available - PSC2 127 621 1,130 918 1,129 1,208 200,000 Actual Days Cash Available - Moody's 3 (88) 328 626 491 594 688 0 Target minimum working capital - S&P4 (88) 328 626 491 594 688 2019 2020 2021 2022 2023 Actual working capital-cash balance 169,298 695,200 825,592 919,316 1,071,328 1,180,554 Target Ending Cash Over (Under) Ehlers target (64,144) 532,434 611,828 710,075 857,020 949,389 Over (Under) PSC target (90 days) 37 531 1,040 828 1,039 1,118 Over (Under) Moody's target (150 days) (238) 178 476 341 444 538 Over (Under) S&P target (150 days) (238) 178 476 341 444 538 Notes: 1) Target capital equals 6 mos of next year's operating expenses, including depreciation, plus 100% of debt. 2) PSC formula = O&M expense + taxes + interest on long term debt ÷ 365 to get expense per day. Then Unrestricted Cash ÷ expense per day 3) Moody's Formula = [(Unrestricted Cash + Liquid Investments) * 365 days] ÷ Total O&M Expenses less Depreciation 4) S&P Formula = [(Unrestricted Cash + Liquid Investments) * 365 days] ÷ Total O&M Expenses less Depreciation; include designated reserve funds: ERFs, RSFs, etc 4 Future Capital – Option 1 • Project: Sussex Wastewater Treatment Facility • Estimated Funding: Sussex’s Clean Water Fund Program • Estimated Annual Debt Service Payment: about $40,000 Projects Funding 2024 2025 2026 2027 2028 Sussex WWTF Repairs Revenue Debt 638,875 Actual CIP Costs 0 638,875 0 0 0 Sources of Funding 2024 2025 2026 2027 2028 G.O. Debt 0 0 0 0 0 Revenue Debt 0 638,875 0 0 0 Grants/Aids 0 0 0 0 0 Special Assessment 0 0 0 0 0 User Fees 0 0 0 0 0 Tax Levy 0 0 0 0 0 Equipment Replacement Fund 0 0 0 0 0 Cash 0 0 0 0 0 Total 0 638,875 0 0 0 5 Future Projection – Option 1 Budget Projected 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 Revenues Total Revenues from User Rates 1 $411,132 $411,132 $431,689 $444,639 $457,978 $471,718 $485,869 $500,445 $515,459 $530,923 Percent Increase to User Rates 0.00% 0.00% 5.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% Cumulative Percent Rate Increase 0.00% 0.00% 5.00% 8.15% 11.39% 14.74% 18.18% 21.72% 25.38% 29.14% Dollar Amount Increase to Revenues $0 $20,557 $12,951 $13,339 $13,739 $14,152 $14,576 $15,013 $15,464 Other Revenues Interest Income $48,000 $49,440 $50,923 $52,451 $54,024 $55,645 $57,315 $59,034 $60,805 $62,629 Other Income $6,710 $0 $0 $0 $0 $0 $0 $0 $0 $0 Total Other Revenues $54,710 $49,440 $50,923 $52,451 $54,024 $55,645 $57,315 $59,034 $60,805 $62,629 Total Revenues $465,842 $460,572 $482,612 $497,090 $512,003 $527,363 $543,184 $559,479 $576,264 $593,552 Less: Expenses Operating and Maintenance $356,616 $367,314 $378,334 $389,684 $401,374 $413,416 $425,818 $438,593 $451,750 $465,303 PILOT Payment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Net Before Debt Service and Capital Expenditures $109,226 $93,258 $104,278 $107,406 $110,628 $113,947 $117,366 $120,887 $124,513 $128,249 Debt Service Existing Debt P&I $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 New (2024-2033) Debt Service P&I $0 $7,555 $40,161 $40,154 $40,147 $40,140 $40,132 $40,124 $40,116 $40,108 Total Debt Service $0 $7,555 $40,161 $40,154 $40,147 $40,140 $40,132 $40,124 $40,116 $40,108 Transfer In (Out) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Less: Capital Improvements $0 $638,875 $0 $0 $0 $0 $0 $0 $0 $0 Debt Issued/Grants/Aid $0 $638,875 $0 $0 $0 $0 $0 $0 $0 $0 Net Annual Cash Flow $109,226 $85,703 $64,116 $67,252 $70,481 $73,808 $77,234 $80,762 $84,397 $88,141 Restricted and Unrestricted Cash Balance: Balance at first of year $1,071,328 $1,180,554 $1,266,257 $1,330,373 $1,397,625 $1,468,107 $1,541,914 $1,619,148 $1,699,910 $1,784,307 Net Annual Cash Flow Addition/(subtraction) $109,226 $85,703 $64,116 $67,252 $70,481 $73,808 $77,234 $80,762 $84,397 $88,141 Balance at end of year $1,180,554 $1,266,257 $1,330,373 $1,397,625 $1,468,107 $1,541,914 $1,619,148 $1,699,910 $1,784,307 $1,872,448 Notes: Legend: 6 1) Assumes no changes in customer count or usage beyond Test Year. Increase depicted to maintain with assumed O&M inflation Increase needed above inflationary adjustment Future Projection – Option 1 Budget Projected 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 Target minimum cash balance Target minimum working capital - Ehlers 1 231,165 277,187 282,855 288,693 294,707 300,900 307,280 313,851 320,619 327,590 Actual Days Cash Available - PSC2 1,208 1,233 1,235 1,263 1,291 1,320 1,349 1,378 1,408 1,437 Actual Days Cash Available - Moody's 3 688 754 793 833 873 913 953 992 1,031 1,070 Target minimum working capital - S&P4 688 754 793 833 873 913 953 992 1,031 1,070 Actual working capital-cash balance 1,180,554 1,266,257 1,330,373 1,397,625 1,468,107 1,541,914 1,619,148 1,699,910 1,784,307 1,872,448 Over (Under) Ehlers target 949,389 989,069 1,047,518 1,108,932 1,173,400 1,241,014 1,311,868 1,386,060 1,463,688 1,544,858 Over (Under) PSC target (90 days) 1,118 1,143 1,145 1,173 1,201 1,230 1,259 1,288 1,318 1,347 Over (Under) Moody's target (150 days) 538 604 643 683 723 763 803 842 881 920 Over (Under) S&P target (150 days) 538 604 643 683 723 763 803 842 881 920 Notes: 1) Target capital equals 6 mos of next year's operating expenses, including depreciation, plus 100% of debt. 2) PSC formula = O&M expense + taxes + interest on long term debt ÷ 365 to get expense per day. Then Unrestricted Cash ÷ expense per day 3) Moody's Formula = [(Unrestricted Cash + Liquid Investments) * 365 days] ÷ Total O&M Expenses less Depreciation 4) S&P Formula = [(Unrestricted Cash + Liquid Investments) * 365 days] ÷ Total O&M Expenses less Depreciation; include designated reserve funds: ERFs, RSFs, etc 7 Impact on Avg. Res. Bill – Option 1 Sewer Sewer Change Change Sewer User Utility Bill Utility Bill % of MHI Year Increase Vol. Over Prior Over Prior Year Charge1 (Quarterly) (Annual) (121,530) Charge1 Year Year 1,000 Gal 2024 0.00% 0.00 155.00 $ 155.00 $ - $ 620.00 $ - 0.51% 2024 2025 0.00% 0.00 155.00 $ 155.00 $ - $ 620.00 $ - 0.51% 2025 2026 5.00% 0.00 162.75 $ 162.75 $ 7.75 $ 651.00 $ 31.00 0.54% 2026 2027 3.00% 0.00 167.63 $ 167.63 $ 4.88 $ 670.53 $ 19.53 0.55% 2027 2028 3.00% 0.00 172.66 $ 172.66 $ 5.03 $ 690.65 $ 20.12 0.57% 2028 2029 3.00% 0.00 177.84 $ 177.84 $ 5.18 $ 711.37 $ 20.72 0.59% 2029 2030 3.00% 0.00 183.18 $ 183.18 $ 5.34 $ 732.71 $ 21.34 0.60% 2030 2031 3.00% 0.00 188.67 $ 188.67 $ 5.50 $ 754.69 $ 21.98 0.62% 2031 2032 3.00% 0.00 194.33 $ 194.33 $ 5.66 $ 777.33 $ 22.64 0.64% 2032 2033 3.00% 0.00 200.16 $ 200.16 $ 5.83 $ 800.65 $ 23.32 0.66% 2033 Total Change over planning period $ 45.16 $ 180.65 Notes: 1. The current Residential Sewer volumetric rate is $155 per quarter. 8 Future Capital – Option 2 • Project: Sussex Wastewater Treatment Facility • Estimated Funding: Sussex’s Clean Water Fund Program • Utilize remaining cash on hand (after meeting target minimum working capital to hold in reserves) Projects Funding 2024 2025 2026 2027 2028 Sussex WWTF Repairs Cash 638,875 Actual CIP Costs 0 638,875 0 0 0 Sources of Funding 2024 2025 2026 2027 2028 G.O. Debt 0 0 0 0 0 Revenue Debt 0 0 0 0 0 Grants/Aids 0 0 0 0 0 Special Assessment 0 0 0 0 0 User Fees 0 0 0 0 0 Tax Levy 0 0 0 0 0 Equipment Replacement Fund 0 0 0 0 0 Cash 0 638,875 0 0 0 Total 0 638,875 0 0 0 9 Future Projection – Option 2 Budget Projected 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 Revenues Total Revenues from User Rates 1 $411,132 $423,466 $423,466 $436,170 $436,170 $449,255 $449,255 $462,733 $476,615 $490,913 Percent Increase to User Rates 0.00% 3.00% 0.00% 3.00% 0.00% 3.00% 0.00% 3.00% 3.00% 3.00% Cumulative Percent Rate Increase 0.00% 3.00% 3.00% 6.09% 6.09% 9.27% 9.27% 12.55% 15.93% 19.41% Dollar Amount Increase to Revenues $12,334 $0 $12,704 $0 $13,085 $0 $13,478 $13,882 $14,298 Other Revenues Interest Income $48,000 $49,440 $50,923 $52,451 $54,024 $55,645 $57,315 $59,034 $60,805 $62,629 Other Income $6,710 $0 $0 $0 $0 $0 $0 $0 $0 $0 Total Other Revenues $54,710 $49,440 $50,923 $52,451 $54,024 $55,645 $57,315 $59,034 $60,805 $62,629 Total Revenues $465,842 $472,906 $474,389 $488,621 $490,194 $504,900 $506,570 $521,767 $537,420 $553,542 Less: Expenses Operating and Maintenance $356,616 $367,314 $378,334 $389,684 $401,374 $413,416 $425,818 $438,593 $451,750 $465,303 PILOT Payment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Net Before Debt Service and Capital Expenditures $109,226 $105,591 $96,055 $98,937 $88,820 $91,485 $80,751 $83,174 $85,669 $88,239 Debt Service Existing Debt P&I $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 New (2024-2033) Debt Service P&I $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Total Debt Service $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Transfer In (Out) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Less: Capital Improvements $0 $638,875 $0 $0 $0 $0 $0 $0 $0 $0 Debt Issued/Grants/Aid $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Net Annual Cash Flow $109,226 ($533,284) $96,055 $98,937 $88,820 $91,485 $80,751 $83,174 $85,669 $88,239 Restricted and Unrestricted Cash Balance: Balance at first of year $1,071,328 $1,180,554 $647,270 $743,326 $842,263 $931,083 $1,022,567 $1,103,318 $1,186,492 $1,272,162 Net Annual Cash Flow Addition/(subtraction) $109,226 ($533,284) $96,055 $98,937 $88,820 $91,485 $80,751 $83,174 $85,669 $88,239 Balance at end of year $1,180,554 $647,270 $743,326 $842,263 $931,083 $1,022,567 $1,103,318 $1,186,492 $1,272,162 $1,360,401 10 Future Projection – Option 2 Budget Projected 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 Target minimum cash balance Target minimum working capital - Ehlers 1 223,610 237,026 242,701 248,546 254,567 260,768 267,155 273,734 280,511 287,490 Actual Days Cash Available - PSC2 1,208 643 717 789 847 903 946 987 1,028 1,067 Actual Days Cash Available - Moody's 3 688 138 227 313 385 454 510 565 617 669 Target minimum working capital - S&P4 688 138 227 313 385 454 510 565 617 669 Actual working capital-cash balance 1,180,554 647,270 743,326 842,263 931,083 1,022,567 1,103,318 1,186,492 1,272,162 1,360,401 Over (Under) Ehlers target 956,944 410,244 500,625 593,716 676,516 761,799 836,163 912,758 991,651 1,072,911 Over (Under) PSC target (90 days) 1,118 553 627 699 757 813 856 897 938 977 Over (Under) Moody's target (150 days) 538 (12) 77 163 235 304 360 415 467 519 Over (Under) S&P target (150 days) 538 (12) 77 163 235 304 360 415 467 519 Notes: 1) Target capital equals 6 mos of next year's operating expenses, including depreciation, plus 100% of debt. 2) PSC formula = O&M expense + taxes + interest on long term debt ÷ 365 to get expense per day. Then Unrestricted Cash ÷ expense per day 3) Moody's Formula = [(Unrestricted Cash + Liquid Investments) * 365 days] ÷ Total O&M Expenses less Depreciation 4) S&P Formula = [(Unrestricted Cash + Liquid Investments) * 365 days] ÷ Total O&M Expenses less Depreciation; include designated reserve funds: ERFs, RSFs, etc 11 Impact on Avg. Res. Bill – Option 2 Sewer Sewer Change Change Sewer User Utility Bill Utility Bill % of MHI Year Increase Vol. 1 Over Prior Over Prior Year Charge (Quarterly) (Annual) (121,530) Charge1 Year Year 1,000 Gal 2024 0.00% 0.00 155.00 $ 155.00 $ - $ 620.00 $ - 0.51% 2024 2025 3.00% 0.00 159.65 $ 159.65 $ 4.65 $ 638.60 $ 18.60 0.53% 2025 2026 0.00% 0.00 159.65 $ 159.65 $ - $ 638.60 $ - 0.53% 2026 2027 3.00% 0.00 164.44 $ 164.44 $ 4.79 $ 657.76 $ 19.16 0.54% 2027 2028 0.00% 0.00 164.44 $ 164.44 $ - $ 657.76 $ - 0.54% 2028 2029 3.00% 0.00 169.37 $ 169.37 $ 4.93 $ 677.49 $ 19.73 0.56% 2029 2030 0.00% 0.00 169.37 $ 169.37 $ - $ 677.49 $ - 0.56% 2030 2031 3.00% 0.00 174.45 $ 174.45 $ 5.08 $ 697.82 $ 20.32 0.57% 2031 2032 3.00% 0.00 179.69 $ 179.69 $ 5.23 $ 718.75 $ 20.93 0.59% 2032 2033 3.00% 0.00 185.08 $ 185.08 $ 5.39 $ 740.31 $ 21.56 0.61% 2033 Total Change over planning period $ 30.08 $ 120.31 Notes: 1. The current Residential Sewer volumetric rate is $155 per quarter. 12 Recommendations • Determine source of Project Cost repayment: Debt vs. Cash on Hand • If Debt (option 1)  Transition from Property Tax Levy to Sanitary District User Rates  Incorporate 10% increase in 2026  Incorporate annual inflationary user rate increases starting in 2027 • If Cash (option 2)  Incorporate inflationary user rate increases, starting in 2025, to rebuild Cash Reserves 13 TONIGHT’s ACTION: Consensus on sewer rate approach Questions? 14 REQUEST FOR CONSIDERATION Committee/Board: Public Works & Utility Committee Topic: McKerrow/William Dr. Speed & Traffic Concerns Department: Administration Date of Committee Action (if needed): July 17, 2024 Date of Village Board Action: August 14, 2024 INFORMATION Background/Rationale A request from residents was received regarding the speed limit and traffic along McKerrow Drive and William Drive. The WCSD conducted a speed study in the area, and a Deputy will be at the Committee meeting to present it and answer any questions from the Committee. Recommended Action MOTION to approve / deny the request for Traffic Controls in the form of _________________ in the area of McKerrow & William Drives, and recommendation to Village Board of the same. -or- DIRECTION to staff as deemed appropriate (ex: gather information, etc.). Attachment 1. Speed Study Default Report Title Use Preferences to Define Titles SPEED DATA ANALYSIS Default Report Title Use Preferences to Define Titles Speed Enforcement Evaluator Location MCKERROW DR / WILLIAM DR Total Percentage of Enforceable Violations Analysis Dates Posted Speed Limit 25 MPH Start: 6/11/2024 Enforcement Tolerance 15 MPH End: 6/23/2024 Enforcement Limit Greater than 40 MPH Installed By R. KRUEGER #9182 Percent Speeding: 3% Rating: Low Percent Speeding: 3% Percent Speeding: 3% Rating: Low Rating: Low Default Report Title Use Preferences to Define Titles LENGTH DATA ANALYSIS Default Report Title Use Preferences to Define Titles Best Times for Speed Enforcement Location MCKERROW DR / WILLIAM DR Analysis Dates Start: 6/11/2024 End: 6/26/2024 Installed By R. KRUEGER #9182 Combined Approaching, Near Lane Receding, Far Lane AM PM AM PM AM PM Monday 7:00 - 9:00 5:00 - 7:00 7:00 - 9:00 5:00 - 7:00 9:00 - 11:00 No count data Tuesday No count data 7:00 - 9:00 No count data No count data No count data 7:00 - 9:00 Wednesday No count data 1:00 - 3:00 No count data 1:00 - 3:00 No count data No count data Thursday 8:00 - 10:00 6:00 - 8:00 10:00 - 12:00 12:00 - 2:00 8:00 - 10:00 6:00 - 8:00 Friday 5:00 - 7:00 12:00 - 2:00 5:00 - 7:00 12:00 - 2:00 No count data 7:00 - 9:00 Saturday 9:00 - 11:00 12:00 - 2:00 9:00 - 11:00 12:00 - 2:00 No count data No count data Sunday 7:00 - 9:00 1:00 - 3:00 7:00 - 9:00 1:00 - 3:00 No count data No count data Combined Approaching, Near Lane Receding, Far Lane Monday 7:00AM - 11:00AM 7:00AM - 11:00AM 9:00AM - 1:00PM Tuesday 7:00PM - 11:00PM No count data 7:00PM - 11:00PM Wednesday 1:00PM - 5:00PM 1:00PM - 5:00PM No count data Thursday 6:00PM - 10:00PM 12:00PM - 4:00PM 6:00PM - 10:00PM Friday 5:00AM - 9:00AM 5:00AM - 9:00AM 7:00PM - 11:00PM Saturday 9:00AM - 1:00PM 9:00AM - 1:00PM No count data Sunday 7:00AM - 11:00AM 7:00AM - 11:00AM No count data Default Report Title Use Preferences to Define Titles Default Report Title Use Preferences to Define Titles Default Report Title Use Preferences to Define Titles Default Report Title Use Preferences to Define Titles Site Code: 0001 Comment 1: Station ID: Comment 2: Location 1: MCKERROW Comment 3: DR / WILLIAM DR Location 2: Comment 4: Location 3: Latitude: 43.109946 Location 4: Volume Sorted by Speed for 6/11/2024 to 6/23/2024 Longitude: -88.252199 Combined Speed Volume (MPH) 4 0 5 0 6 9 7 5 8 6 9 5 10 7 11 11 12 19 13 15 14 14 15 9 16 11 17 7 18 9 19 15 20 18 21 13 22 24 23 20 24 30 25 22 26 59 27 53 28 69 29 64 30 67 31 68 32 80 33 54 34 76 35 48 36 41 37 21 38 22 39 22 40 12 41 14 42 7 43 3 44 2 45 1 46 0 47 0 48 0 49 0 50 0 51 0 52 0 53 0 54 0 Default Report Title Use Preferences to Define Titles Site Code: 0001 Comment 1: Station ID: Comment 2: Location 1: MCKERROW Comment 3: DR / WILLIAM DR Location 2: Comment 4: Location 3: Latitude: 43.109946 Location 4: Volume Sorted by Speed for 6/11/2024 to 6/23/2024 Longitude: -88.252199 Approaching, Near Lane Speed Volume (MPH) 4 0 5 0 6 2 7 0 8 3 9 3 10 1 11 4 12 11 13 8 14 7 15 3 16 9 17 5 18 5 19 9 20 17 21 8 22 17 23 13 24 20 25 14 26 43 27 29 28 47 29 36 30 44 31 46 32 57 33 39 34 51 35 33 36 30 37 15 38 12 39 15 40 6 41 9 42 5 43 2 44 1 45 0 46 0 47 0 48 0 49 0 50 0 51 0 52 0 53 0 54 0 Default Report Title Use Preferences to Define Titles Site Code: 0001 Comment 1: Station ID: Comment 2: Location 1: MCKERROW Comment 3: DR / WILLIAM DR Location 2: Comment 4: Location 3: Latitude: 43.109946 Location 4: Volume Sorted by Speed for 6/11/2024 to 6/23/2024 Longitude: -88.252199 Receding, Far Lane Speed Volume (MPH) 4 0 5 0 6 7 7 5 8 3 9 2 10 6 11 7 12 8 13 7 14 7 15 6 16 2 17 2 18 4 19 6 20 1 21 5 22 7 23 7 24 10 25 8 26 16 27 24 28 22 29 28 30 23 31 22 32 23 33 15 34 25 35 15 36 11 37 6 38 10 39 7 40 6 41 5 42 2 43 1 44 1 45 1 46 0 47 0 48 0 49 0 50 0 51 0 52 0 53 0 54 0 Default Report Title Use Preferences to Define Titles Site Code: 0001 Comment 1: Station ID: Comment 2: Location 1: MCKERROW DR / WILLIAM DR Comment 3: Location 2: Comment 4: Location 3: Latitude: 43.109946 Location 4: Longitude: -88.252199 Combined Lanes 6/11/2024 to 6/23/2024 Pace Speed - MPH Classes Excluded From Pace: None Speed Number Percent 26 - 35 638 60.58879% Percentile Speeds Percentile 5th 10th 15th 20th 25th 30th 35th 40th 45th 50th 55th 60th 65th 70th 75th 80th 85th 90 Speed - MPH 12 16 20.4 23.1 24.9 26.1 27.2 27.8 28.9 29.7 30.4 31.3 32 32.7 33.5 34.2 35.1 36 Vehicles Traveling Greater Than 50.0 MPH Total Volume 1,053 Total Greater Than 50.0 1 Percent Greater Than 50.0 0.1% Mean, Median, and Mode Averages Mean: 28.4 Median (50th %): 29.7 Mode: 33.7 1 Default Report Title Use Preferences to Define Titles Site Code: 0001 Comment 1: Station ID: Comment 2: Location 1: MCKERROW DR / Comment 3: WILLIAM DR Location 2: Comment 4: Location 3: Latitude: 43.109946 Location 4: Averaged Daily Totals Longitude: -88.252199 Combined <= 20 >20 to 22 >22 to 24 >24 to 26 >26 to 28 >28 to 30 >30 to 32 >32 to 34 >34 to 36 >36 to 38 >38 to 40 >40 to 42 > 42 Total Sunday 11 0 4 7 7 4 14 19 5 6 3 0 2 82 Monday 16 3 3 6 7 12 15 16 13 9 6 3 0 109 Tuesday 12 2 3 7 13 10 8 10 9 4 3 1 1 83 Wednesday 14 2 4 11 14 11 19 18 10 6 5 1 0 115 Thursday 15 7 4 10 14 13 17 17 7 3 5 3 3 118 Friday 10 2 4 5 4 8 8 10 9 4 3 2 1 70 Saturday 14 1 2 5 7 5 7 4 7 1 3 1 1 58 Total 92 17 24 51 66 63 88 94 60 33 28 11 8 635 Default Report Title Use Preferences to Define Titles Site Code: 0001 Comment 1: Station ID: Comment 2: Location 1: MCKERROW DR / WILLIAM DR Comment 3: Location 2: Comment 4: Location 3: Latitude: 43.109946 Location 4: Longitude: -88.252199 1

Get email alerts for Lisbon

A daily email when new agendas and minutes are posted.

Report an issue with this meeting