Utility Advisory Committee — Agenda Packet

MEETING: REGULAR MEETING OF THE UTILITY ADVISORY COMMITTEE DATE & TIME: Wednesday, January 28, 2026 at 5:00 PM LOCATION: Germantown Village Hall Board Room N112 W17001 Mequon Road NOTICE: Citizens not wishing to attend the meeting personally or virtually may submit any public comments by sending an email to comments@germantownwi.gov by 4 p.m. on the day of the meeting so that it can be provided to the members of the body for their consideration. AGENDA I. CALL TO ORDER: This meeting has been given public notice in accordance with Section 19.83 and 19.84, Wis. Stats, in such form that will apprise the general public and news media of subject matter that is intended for consideration and action. II. ROLL CALL: III. CITIZEN INPUT: (Please be advised per 19.84(2) that information and comment will be received from the public. It is the policy of this municipality that public input be limited to a four (4) minute period per person with a time extension granted at the discretion of the Chairperson. Be advised that there may be limited discussion of the information received but no action will be taken under public comments.) Comments that may be injurious to village personnel or other individuals will not be allowed. IV. MEETING MINUTES: A. July 30, 2025, Meeting Minutes (ACTION) V. UNFINISHED BUSINESS: VI. NEW BUSINESS: A. Water Utility Cash Flow & Rate Discussion (DISCUSSION) B. Sewer Utility Cash Flow & Rate Discussion (DISCUSSION) C. Report on Old Farm and Main Street Lift Station upgrades. (DISCUSSION) D. Wastewater Utility Lift Station 6 Land Acquisition (ACTION) E. Water Supply Service Area Plan (WSSAP) Review (ACTION) F. Requirements for the installation of deduct meters (DISCUSSION) VII. ADJOURNMENT: UPON REASONABLE NOTICE, efforts will be made to accommodate the needs of disabled individuals through appropriate aids and services. For additional information or to request this service, please contact the Village Clerk at (262)250-4745 at least 2 days prior to the meeting. Notice is hereby given that a possible quorum of other boards, committees, and/or commissions may attend this meeting to gather information about an item over which they have decision-making responsibility. This may constitute a meeting of these bodies per State ex rel. Badke v Greendale Village Board, even though these bodies will not take formal action at this meeting. Page 1 of 87 DRAFT MEETING: REGULAR MEETING OF THE UTILITY ADVISORY COMMITTEE DATE AND TIME: Wednesday, July 30, 2025 5:00 PM LOCATION: Germantown Vi llage Hall Board Room N112 W17001 Mequon Road MINUTES I. CALL TO ORDER: This meeting has been given public notice in accordance with Section 19.83 and 19.84, Wis. Stats, in such form that will apprise the general public and news media of subject matter that is intended for consideration and action. Chai rperson Trustee Robert Warren called the Utility Advisory Committee meeting to order at 5:03 PM. II. ROLL CALL: Present: Chairperson Trustee Robert Warren, Member Steve Wesolowski, Member Peter Nilles, Member James Hansen Excused: Member Scott Hefle Also Present: Public Works Director Matt Mortwedt, Water Superintendent Paul Haugen, Wastewater Superintendent Tim Zimmerman, Village Engineer Kevin Driscoll, Deputy Clerk Maddy Laufenberg III. CITIZEN INPUT: (Please be advised per 19.84(2) that information and comment will be received from the public. It is the policy of this municipality that public input be limited to a four (4) minute period per person with a time extension granted at the discretion of the Chairperson. Be advised that there may be limited discussion of the information received but no action will be taken under public comments.) Comments that may be injurious to village personnel or other individuals will not be allowed. IV. MEETING MINUTES: A. January 27, 2025 (ACTION) Motion: Approve as presented Motioned By: Member Nilles Seconded By: Member Wesolowski Yes: Chairperson Trustee Warren, Member Wesolowski, Member Nilles, Member Hansen No: None Abstain: None Page 2 of 87 DRAFT Page 2 Motion Carried by Voice Vote (Yes 4, No 0, Abstained 0) V. UNFINISHED BUSINESS: VI. NEW BUSINESS: Motion: Move New Business Item C presentation before New Business Item A Motioned By: Chairperson Trustee Warren Seconded By: Member Nilles Yes: Chairperson Trustee Warren, Member Wesolowski, Member Nilles, Member Hansen No: None Abstain: None Motion Carried by Voice Vote (Yes 4, No 0, Abstained 0) C. Presentation by Foth Infrastructure Services on the Water Supply and Storage Analysis (PRESENTATION) Ryan Schultz of Foth Infrastructure Services provided a review of the Village of Germantown's water supply and storage analysis, including the existing water service area and system; existing water supply, use, and demand; and recommendations for future increases in water supply and storage. A. Presentation by Ruekert and Mielke regarding the Old Farm and Main Street Lift Station Study (PRESENTATION) Dave Arnott of Ruekert & Mielke provided the Main Street and Old Farm Lift Station Facilities Plan Report, including a review of the existing conditions at each lift station and recommended improvements. B. Consideration of the Ruekert and Mielke Old Farm and Main Street Lift Station Study. (ACTION) Motion: Recommend approval of the Reukert & Mielke Old Farm and Main Street Lift Station Study to the Public Works and Highways Committee Motioned By: Member Hansen Seconded By: Member Nilles Yes: Chairperson Trustee Warren, Member Wesolowski, Member Nilles, Member Hansen No: None Abstain: None Motion Carried by Voice Vote (Yes 4, No 0, Abstained 0) Page 3 of 87 DRAFT Page 3 D. Potential Kuhn's Pleasant View Utility and Road Project (DISCUSSION) Public Works Director Mortwedt led a discussion of potential utility and road projects being considered for the Kuhn's Pleasant View subdivision and requested feedback from committee members. Motion: Recommend drafting a work plan for the laterals and sewer main to capture MMSD PPI&I funding Motioned By: Member Wesolowski Seconded By: Chairperson Warren Yes: Chairperson Trustee Warren, Member Wesolowski, Member Nilles, Member Hansen No: None Abstain: None Motion Carried by Voice Vote (Yes 4, No 0, Abstained 0) VII. ADJOURNMENT: Chairperson Trustee Warren adjourned the Utility Advisory Committee meeting at 6:55 PM. Page 4 of 87 BUSINESS OF THE UTILITY ADVISORY COMMITTEE MEETING DATE: January 28, 2026 PLACEMENT: Presentation ITEM TITLE: Water Utility Cash Flow & Rate Discussion (DISCUSSION) SUBMITTED BY: SUMMARY EXPLANATION: ATTACHMENT: 1. Germantown Water LRCFA 8-14-23 2. 2025 - Utilties Statement of Cash Flows STAFF RECOMMENDATION: ACTION BY COMMITTEE: Page 5 of 87 Page 6 of 87 Table 1 Water Rate Performance Village of Germantown, WI Est Budget Component Description 2018 2019 2020 2021 2022 2023 Cash Basis 1 Operating and Maintenance $2,122,148 $2,153,550 $2,369,448 $2,582,057 $2,324,833 $2,898,401 2 Debt $136,500 $138,974 $141,204 $138,210 $58,839 $468,923 3 Cash Funded Capital $1,031,590 $320,472 $102,166 $1,430,086 $0 $663,000 Less: Other Revenue $58,590 $69,970 $62,540 $46,282 $93,151 $46,500 Interest Income $31,844 $60,529 $33,007 $1,394 $7,992 $47,000 Revenue Requirement $3,199,804 $2,482,497 $2,517,271 $4,102,677 $2,282,530 $3,936,824 (Costs less Other Income) User Rates Revenue $2,317,394 $2,197,232 $2,451,194 $2,465,047 $3,503,241 $3,503,241 Rate Adequacy ($882,410) ($285,265) ($66,077) ($1,637,630) $1,220,711 ($433,583) Rate Adjustment Needed 38.08% 12.98% 2.70% 66.43% 0.00% 12.38% Utility Basis (PSC) 1 Operating and Maintenance $2,122,148 $2,153,550 $2,369,448 $2,582,057 $2,324,833 $2,898,401 2 Depreciation $870,266 $902,670 $1,041,246 $992,684 $950,876 $970,876 NIRB $13,888,960 $15,189,718 $15,600,894 $15,429,340 $15,741,048 $16,665,100 3 PSC Benchmark ROI (6.2%) $861,115 $941,762 $967,255 $956,619 $975,945 $1,033,236 Less: Other Revenue $58,590 $69,970 $62,540 $46,282 $93,151 $46,500 Interest Income $31,844 $60,529 $33,007 $1,394 $7,992 $47,000 Revenue Requirement $3,763,095 $3,867,483 $4,282,402 $4,483,684 $4,150,511 $4,809,013 (Costs less Other Income) User Rates Revenue $2,317,394 $2,197,232 $2,451,194 $2,465,047 $3,503,241 $3,503,241 Rate Adequacy ($1,445,701) ($1,670,251) ($1,831,208) ($2,018,637) ($647,271) ($1,305,773) Rate Adjustment Needed 62.38% 76.02% 74.71% 81.89% 18.48% 37.27% Shown with no increase Revenue Requirement Germantown Water Utility LRCFA Updated 8-11-23 Prepared 8/14/2023 Page 1 Page 7 of 87 Table 2 Water Utility Rate Performance Charts Village of Germantown, WI $0 $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 $3,500,000 $4,000,000 $4,500,000 2018 2019 2020 2021 2022 2023 Cash  Basis Operating and Maintenance Debt Cash Funded Capital Revenue Requirement User Rates Revenue $0 $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 2018 2019 2020 2021 2022 2023 Utility  Basis Operating and Maintenance Depreciation PSC Benchmark ROI (6.2%) Revenue Requirement User Rates Revenue Germantown Water Utility LRCFA Updated 8-11-23 Prepared 8/14/2023 Page 2 Page 8 of 87 Table 3 Water Utility Cash Flow Analysis - Historical 2018-2022 Village of Germantown, WI Estimated 2018 2019 2020 2021 2022 Revenues Total Revenues from User Rates $2,317,394 $2,197,232 $2,451,194 $2,465,047 $3,503,241 Percent Increase to User Rates Other Revenues Interest Income $31,844 $60,529 $33,007 $1,394 $7,992 Other Income $103,354 $80,637 $65,444 $74,351 $93,933 Total Other Revenues $135,198 $141,166 $98,451 $75,745 $101,925 Total Revenues $2,452,592 $2,338,398 $2,549,645 $2,540,792 $3,605,165 Less: Expenses Operating and Maintenance $1,539,529 $1,538,464 $1,693,573 $1,941,605 $1,704,833 PILOT Payment $582,619 $615,086 $675,875 $640,452 $620,000 Net Before Debt Service and Capital Expenditures $330,444 $184,848 $180,197 -$41,265 $1,280,332 Existing Debt P&I1 $136,500 $138,974 $141,204 $138,210 $58,839 Transfer In (Out)/Cap. Contrib. $61,485 $0 $219,086 $731,253 $0 Less: Capital Improvements $1,031,590 $320,472 $102,166 $1,430,086 $926,000 Debt Proceeds/Grants $0 $0 $0 $0 $4,140,000 Reconcile to Audit -$115,767 $343,279 $80,516 $658,316 Net Annual Cash Flow ($891,928) $68,681 $236,429 ($219,992) $4,435,493 Restricted and Unrestricted Cash Balance: Balance at first of year $2,668,342 $1,776,414 $1,845,095 $2,081,524 $1,861,532 Net Annual Cash Flow Addition/(subtraction) -$891,928 $68,681 $236,429 -$219,992 $4,435,493 Balance at end of year $1,776,414 $1,845,095 $2,081,524 $1,861,532 $6,297,025 Notes: Actual Germantown Water Utility LRCFA Updated 8-11-23 Prepared 8/14/2023 Page 3 Page 9 of 87 Table 4 Water Utility Financial Benchmarking Analysis Village of Germantown, WI Estimated Budget 2018 2019 2020 2021 2022 2023 Target minimum cash balance Target minimum working capital - Ehlers1 1,667,084 1,846,551 1,925,581 1,696,694 2,403,561 2,812,911 Actual Days Cash Available - PSC2 295 310 333 251 1,140 738 Actual Days Cash Available - Moody's3 303 317 339 255 1,151 811 Actual Days Cash Available - S&P4 421 317 339 255 1,151 811 Actual working capital-cash balance 1,776,414 1,845,095 2,081,524 1,861,532 6,297,025 5,986,309 Over (Under) Ehlers target 109,330 (1,456) 155,944 164,839 3,893,464 3,173,397 Over (Under) PSC target (90 days) 205 220 243 161 1,050 648 Over (Under) Moody's target (150 days) 153 167 189 105 1,001 661 Over (Under) S&P target (150 days) 271 167 189 105 1,001 661 Notes: 1) Target capital equals 6 mos of next year's operating expenses, including depreciation, plus 100% of following year's 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 Rate of Return Total Utility Plant in service BOY 20,704,026 21,564,597 24,079,532 22,685,951 24,102,564 25,028,564 Total Utility Plant in service EOY 21,564,597 24,079,532 22,685,951 24,102,564 25,028,564 27,028,113 Average Total Plant in Service 21,134,312 22,822,065 23,382,742 23,394,258 24,565,564 26,028,338 Contributed Plant in Service BOY 20,664,222 21,929,060 22,102,894 25,360,897 25,687,209 25,687,209 Contributed Plant in Service EOY 21,929,060 22,102,894 25,360,897 25,687,209 25,687,209 25,687,209 Avg Contributed Plant in Service 21,296,641 22,015,977 23,731,896 25,524,053 25,687,209 25,687,209 Average Utility Plant in Service 21,134,312 22,822,065 23,382,742 23,394,258 24,565,564 26,028,338 Plus: Materials and Supplies 000000 Less: Utility Plant Accumulated Depreciation 6,743,317 7,221,590 7,462,369 7,736,717 8,346,717 8,976,717 Less: Regulatory Liability 502,035 410,757 319,479 228,201 136,923 45,645 Average Net Investment Rate Base (NIRB) 13,888,960 15,189,718 15,600,894 15,429,340 16,081,924 17,005,976 Net Operating Income (259,645) (454,711) (425,396) (533,953) 661,558 21,340 ROR -1.87% -2.99% -2.73% -3.46% 4.11% 0.13% Benchmark 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% Cost Recovery Operating Revenues 2,375,984 2,267,202 2,513,734 2,511,329 3,596,391 3,549,741 Operating Expenses incl. Depr & Amortization 2,992,414 3,056,220 3,410,694 3,574,741 3,275,709 3,869,277 Operating Expenses w/o Depr & Amortization 2,122,148 2,153,550 2,369,448 2,582,057 2,324,833 2,898,401 Cost Recovery incl. Depr 0.79 0.74 0.74 0.70 1.10 0.92 Cost Recovery w/o Depr 1.41 1.42 1.44 1.38 1.41 1.33 Target 1.00 1.00 1.00 1.00 1.00 1.00 Actual Germantown Water Utility LRCFA Updated 8-11-23 Prepared 8/14/2023 Page 4 Page 10 of 87 Notes: This operating ratio indicates whether operating revenues (mostly charges to customers) were sufficient to cover operations and capital (in the form of depreciation) for the water and/or wastewater utility in the fiscal year. A ratio of less than 1 could be a sign of financial concern. In general, this ratio should be higher than 1 to accommodate future capital investments. Leverage Total Long-Term Debt 911,329 800,911 689,413 571,809 4,471,810 4,228,069 Total Net Assets 43,493,657 46,182,426 48,046,848 49,789,773 50,715,773 52,715,322 Debt-to Equity Ratio 0.02 0.02 0.01 0.01 0.09 0.08 Notes: This indicator measures the existing level of leveraging of assets, and is used by funders and bond rating agencies to evaluate the risk of providing additional loans to the utility. The ratio indicates the amount of long-term debt that exists for every $1 of assets (fund equity). A utility with a ratio greater than 1.0 has more long-term debt than equity in the system’s assets. There are no natural benchmarks for this indicator, and funders and bond rating agencies will assess this ratio in various ways. In general, the higher this ratio, the more likely the utility will be considered to be over-leveraged and the more difficult it will be for the utility to obtain additional loans. For this ratio, Net Assets are equal to the Net Investment Rate Base of the utility. Condition of Assets: Accumulated Depreciation Expense 12,825,362 13,690,844 14,739,200 15,773,624 16,808,048 17,842,472 Total Net Assets 43,493,657 46,182,426 48,046,848 49,789,773 50,715,773 52,715,322 Asset Depreciation 29.49% 29.65% 30.68% 31.68% 33.14% 33.85% Notes: This indicator of infrastructure condition estimates the portion of the average expected life of the utility’s physical assets that has already passed. As this ratio approaches 100%, the capital assets become fully depreciated, and infrastructure needs replacement or rehabilitation. The accuracy of this indicator relies heavily on the accuracy of the depreciation schedule, and historic pricing likely distorts this indicator (newer utilities may be slightly disadvantaged as a result). Asset Efficiency Total Assets 43,493,657 46,182,426 48,046,848 49,789,773 50,715,773 52,715,322 Revenue 2,317,394 2,197,232 2,451,194 2,465,047 3,503,241 3,503,241 Investment to produce $1 Revenue 18.77$ 21.02 $ 19.60 $ 20.20 $ 14.48 $ 15.05$ Notes: This indicator is a measure of how much investment (in $) is necessary to produce $1 of Sales Revenue Wisconsin 2017 Average = 13.52 $ 13.52$ 13.52 $ 13.52 $ 13.52$ Germantown Water Utility LRCFA Updated 8-11-23 Prepared 8/14/2023 Page 5 Page 11 of 87 Table 5 Water Utility Financial Health Charts Village of Germantown, WI Can you pay for 6 mos. Of O&M and next year's debt? Did you generate enough revenues to pay for O&M and capital? Do you generate revenues to pay for O&M and debt service? Did you generate revenues needed to pay for O&M? How much investment in your system produces $1 of Revenue? 0 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 7,000,000 2018 2019 2020 2021 2022 Reserves ‐ Actual vs. Target Target Ending Cash ‐$200,000 $0 $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 $1,400,000 2018 2019 2020 2021 2022 "All‐in" Debt Coverage Existing Debt Min Rec. Avail. Revs for DS Revenues Avail. For D.S. 0.00 0.20 0.40 0.60 0.80 1.00 1.20 2018 2019 2020 2021 2022 Operating Ratio including Depreciation Op Ratio Incl Depr Target 0.00 0.20 0.40 0.60 0.80 1.00 1.20 1.40 1.60 2018 2019 2020 2021 2022 Operating Ratio w/o Depreciation Op Ratio w/o Depr Target ‐4.00% ‐3.00% ‐2.00% ‐1.00% 0.00% 1.00% 2.00% 3.00% 4.00% 5.00% 6.00% 2018 2019 2020 2021 2022 Rate of Return Rate of Return Benchmark  $‐  $5.00  $10.00  $15.00  $20.00  $25.00 2018 2019 2020 2021 2022 Asset Efficiency Asset Efficiency WI Average Germantown Water Utility LRCFA Updated 8-11-23 Prepared 8/14/2023 Page 6 Page 12 of 87 Table 6 Water Utility Capital Improvement Plan Village of Germantown, WI Projects Funding 2023 202 4 2025 2026 2027 2028 2029 2030 2031 2032 Totals Well Rehabilitation 0 Well #2 Cash 150,000 150,000 Well #3 Cash 250,000 250,000 Well #4 Cash 0 Well #5 Cash 150,000 150,000 Well #7 Cash 150,000 150,000 Well #11 Cash 0 Well Roof Shingling-new access hatch 0 #2 (shingles) Cash 15,000 15,000 #4 (shingles) Cash 15,000 15,000 #5 (flat roof) Cash 25,000 25,000 #7 (Shingles) Cash 15,000 15,000 Well house door lock upgrade 0 22 well house and tower doors locks Cash 0 Keyless access Cash 55,000 55,000 Camera all wells Cash 56,000 56,000 Well house VFD 0 #2 Cash 45,000 45,000 #3 Cash 45,000 45,000 #4 Cash 45,000 45,000 #11 Cash 45,000 45,000 Trucks/Equipment 0 Vac/valve turner-2007 Cash 145,000 145,000 Replace Crane Truck - Box, Frame crane Cash 105,000 Well Generators #2 Cash 300,000 300,000 #4 Cash 300,000 300,000 #7 Revenue Debt 300,000 300,000 250KW Load Bank Cash 30,000 30,000 Well Antenna System 0 Well Antenna System Cash 150,000 150,000 Relay Work 0 Well #4-Prelube line and new outlet piping Cash 75,000 75,000 Santa Fe, Apache, Indianwood Dr, Cherokee, Commanche, Pawnee, Council Bluffs-(13) hydrants Cash 150,000 150,000 Misc valve and hydrant work Cash 50,000 50,000 50,000 50,000 50,000 250,000 Transmission/Distribution Mains 0 Glenwood Park Revenue Debt 1,155,770 1,155,770 Meters 0 Various Meter Replacements Cash 50,000 50,000 Fence for Well #5 & #7 Cash 58,000 58,000 Placeholder - Average Capital Expenses (Future yrs) Cash 350,000 350,000 350,000 350,000 4,550,000 Well No. 12 Revenue Debt 480,779 480,779 Well No. 12 Well Facility Revenue Debt 4,615,000 4,615,000 Elevated Tower Revenue Debt 2,200,000 2,200,000 Booster Station Revenue Debt 1,100,000 1,100,000 Actual CIP Costs 1,999,549 8,565,000 470,000 545,000 601,000 345,000 350,000 350,000 350,000 350,000 16,970,54 9 Percent Inflation 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% Inflated Project Costs 1,999,549 8,565,000 470,000 545,000 601,000 345,000 350,000 350,000 350,000 350,000 17,075,54 9 Sources of Funding G.O. Debt 0000000000 0 Revenue Debt 1,336,549 4,915,000 00000000 6,251,549 Grants/Aids 0000000000 0 Special Assessment 0000000000 0 User Fees 0000000000 0 Previously Borrowed Revenue Bonds 300,000 3,300,000 00000000 3,600,000 Equipment Replacement Fund 0000000000 0 Cash 363,000 350,000 470,000 545,000 601,000 345,000 350,000 350,000 350,000 350,000 7,224,000 Total 1,999,549 8,565,000 470,000 545,000 601,000 345,000 350,000 350,000 350,000 350,000 17,075,54 9 Notes: Germantown Water Utility LRCFA Updated 8-11-23 Prepared 8/14/2023 Page 7 Page 13 of 87 Table 7 Capital Improvements Financing Plan Village of Germantown, WI 2024 Revenue  Bonds   2023 + 2024  Projects CIP Projects1 6,251,549 Less Other Available Revenues Cash Available ‐                    ERF Funds ‐                    Net Borrowing Requirement 6,251,549 Debt Service Reserve Debt Service Reserve Funds On Hand (414,000)          New Debt Service Reserve Requirement 966,283           Subtotal Reserve Fund Requirement 552,283 Estimated Issuance Expenses 208,625 TOTAL TO BE FINANCED 7,012,456 Estimated Interest Earnings 3.00% (46,887) Assumed spend down (months) 3.00 Rounding 4,430                NET BOND SIZE 6,970,000        Notes: 1) Source of Project Totals Germantown Water Utility LRCFA Updated 8-11-23 Prepared 8/14/2023 Page 8 Page 14 of 87 Table 8 Water Utility Projected Debt Service Payments (PROPOSED) Village of Germantown, WI AMT DATED MATURE RATE Year Principal Est.  Rate Interest Total Total  Prin Total  Int Total  P&I Prin  Outstanding Year 2023 000 0 2023 2024 0 0 0 6,970,000 2024 2025 80,000 0 468,117 548,117 80,000 468,117 548,117 6,890,000 2025 2026 245,000 0 304,562 549,562 245,000 304,562 549,562 6,645,000 2026 2027 255,000 0 294,165 549,165 255,000 294,165 549,165 6,390,000 2027 2028 265,000 0 283,638 548,638 265,000 283,638 548,638 6,125,000 2028 2029 275,000 0 272,893 547,893 275,000 272,893 547,893 5,850,000 2029 2030 285,000 0 261,919 546,919 285,000 261,919 546,919 5,565,000 2030 2031 295,000 0 250,740 545,740 295,000 250,740 545,740 5,270,000 2031 2032 310,000 0 239,201 549,201 310,000 239,201 549,201 4,960,000 2032 2033 320,000 0 227,231 547,231 320,000 227,231 547,231 4,640,000 2033 2034 335,000 0 214,200 549,200 335,000 214,200 549,200 4,305,000 2034 2035 345,000 0 199,952 544,952 345,000 199,952 544,952 3,960,000 2035 2036 360,000 0 184,915 544,915 360,000 184,915 544,915 3,600,000 2036 2037 380,000 0 168,720 548,720 380,000 168,720 548,720 3,220,000 2037 2038 395,000 0 151,180 546,180 395,000 151,180 546,180 2,825,000 2038 2039 415,000 0 132,239 547,239 415,000 132,239 547,239 2,410,000 2039 2040 435,000 0 111,834 546,834 435,000 111,834 546,834 1,975,000 2040 2041 455,000 0 89,796 544,796 455,000 89,796 544,796 1,520,000 2041 2042 480,000 0 66,068 546,068 480,000 66,068 546,068 1,040,000 2042 2043 505,000 0 40,824 545,824 505,000 40,824 545,824 535,000 2043 2044 535,000 0 13,910 548,910 535,000 13,910 548,910 0 2044 TOTALS 6,970,000 3,976,102 10,946,102 6,970,000 3,976,102 10,946,102 TOTALS Notes: 1) Rate assumes 2) Rate assumes Aa2 sale of 8/8/23 + .75 PROPOSED Water Utility Debt Service Summary 5/1 Water Rev Bonds Series 2024 $6,970,000 NAME 5/1/2024 Germantown Water Utility LRCFA Updated 8-11-23 Prepared 8/14/2023 Page 9 Page 15 of 87 Table 9 Water Utility Cash Flow Analysis - Projected 2023-2032 Village of Germantown, WI Budget 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 Revenues Total Revenues from User Rates1 $3,503,241 $3,726,238 $4,324,174 $4,324,174 $4,363,174 $4,363,174 $4,744,988 $4,744,988 $4,783,988 $4,783,988 Percent Increase to User Rates 0.00% 6.37% 15.00% 0.00% 0.00% 0.00% 8.00% 0.00% 0.00% 0.00% Cumulative Percent Rate Increase 0.00% 6.37% 22.32% 22.32% 22.32% 22.32% 32.11% 32.11% 32.11% 32.11% Dollar Amount Increase to Revenues $222,997 $597,936 $0 $39,000 $0 $381,814 $0 $39,000 $0 Other Revenues Interest Income $47,000 $47,118 $10,951 $12,577 $13,585 $14,108 $15,499 $18,354 $42,092 $47,153 TIDs 6 & 7 Revenues - 2022 Issue $89,067 $72,844 $110,844 $132,544 $133,644 $134,544 $130,344 $126,144 $127,394 $128,947 TIDs 6,7,8 Revenues - 2023 Issue $274,059 $274,059 $274,059 $274,059 $274,059 $274,059 $274,059 $274,059 Other Income $80,300 $80,765 $81,235 $81,709 $82,188 $82,672 $83,161 $83,654 $84,651 $85,668 Total Other Revenues $216,367 $200,726 $477,088 $500,888 $503,476 $505,383 $503,062 $502,211 $528,196 $535,827 Total Revenues $3,719,608 $3,926,964 $4,801,262 $4,825,062 $4,866,649 $4,868,556 $5,248,049 $5,247,198 $5,312,184 $5,319,815 Less: Expenses Operating and Maintenance 2 $2,278,401 $3,014,353 $2,332,284 $2,402,252 $2,474,320 $2,548,549 $2,625,006 $2,703,756 $2,784,869 $2,868,415 PILOT Payment $620,000 $632,400 $645,048 $657,949 $671,108 $684,530 $698,221 $712,185 $726,429 $740,957 Net Before Debt Service and Capital Expenditures $821,207 $280,211 $1,823,930 $1,764,861 $1,721,222 $1,635,477 $1,924,823 $1,831,257 $1, 800,886 $1,710,442 Debt Service Existing Debt P&I $468,923 $426,357 $480,641 $468,624 $466,407 $463,790 $455,872 $395,863 $399,088 $398,366 New (2023-2032) Debt Service P&I $0 $0 $548,117 $549,562 $549,165 $548,638 $547,893 $546,919 $545,740 $549,201 Total Debt Service $468,923 $426,357 $1,028,758 $1,018,186 $1,015,572 $1,012,428 $1,003,765 $942,781 $944,828 $947,567 T r a n s f e r I n ( O u t ) $ 0 $ 0$ 0$ 0$ 0$ 0$ 0$ 0$ 0$ 0 Less: Capital Improvements $1,999,549 $8,565,000 $470,000 $545,000 $601,000 $345,000 $350,000 $350,000 $350,000 $350,000 Debt Proceeds $1,336,549 $4,915,000 $0 $0 $0 $0 $0 $0 $0 $0 Net Annual Cash Flow ($310,716) ($3,796,145) $325,172 $201,674 $104,649 $278,049 $571,058 $538,476 $506,059 $412,876 Restricted and Unrestricted Cash Balance: Balance at first of year $6,297,025 $5,986,309 $2,190,164 $2,515,336 $2,717,010 $2,821,659 $3,099,709 $3,670,766 $4,209,243 $4,715,301 Net Annual Cash Flow Addition/(subtraction) -$310,716 -$3,796,145 $325,172 $201,674 $104,649 $278,049 $571,058 $538,476 $506,059 $412,876 Balance at end of year $5,986,309 $2,190,164 $2,515,336 $2,717,010 $2,821,659 $3,099,709 $3,670,766 $4,209,243 $4,715,301 $5,128,177 Notes: Legend: 1) Includes revenues from the Village of Richfield, starting in 2025 Simplified Rate Case (if eligible) 2) Assumes 3.00% annual inflation beyond budget year. Conventional (Full) Rate Case Projected Germantown Water Utility LRCFA Updated 8-11-23 Prepared 8/14/2023 Page 10 Page 16 of 87 Table 10 Water Utility Operations Cash Flow Analysis Village of Germantown, WI 123456789 1 0 Draft Actual Budget 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 1 Rates % Increase 0.00% 6.37% 15.00% 0.00% 0.00% 0.00% 8.00% 0.00% 0.00% 0.00% 2 Revenue growth assumption 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 2.00% 2.00% 3 Investment income yield 0.25% 0.50% 0.50% 0.50% 0.50% 0.50% 0.50% 1.00% 1.00% 4 Expense growth - Treatment 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 5 Expense growth - Collection Expense 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 6 Expense growth - General and Administrative/Cust 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 10 Beginning net assets 30,878,218 31,625,178 33,368,843 34,501,328 34,498,231 34,865,312 34,451,394 33,385,955 32,878,174 32,448,048 31,97 6,134 31,422,872 31,175,280 30,850,087 30,503,231 11 12 Operating Revenues 13 Water Charges 2,317,394 2,197,232 2,451,194 2,465,047 3,503,241 3,503,241 3,726,238 4,285,174 4,285,174 4,285,174 4,285,174 4,627,988 4, 627,988 4,627,988 4,627,988 14 Water Charges - Richfield 39,000 39,000 78,000 78,000 117,000 117,000 156,000 156,000 15 Other 58,590 69,970 62,540 46,282 93,151 46,500 46,965 47,435 47,909 48,388 48,872 49,361 49,854 50,851 51,868 16 Total Operating Revenues 2,375,984 2,267,202 2,513,734 2,511,329 3,596,391 3,549,741 3,773,203 4,371,608 4,372,083 4,411,562 4,412,0 46 4,794,348 4,794,842 4,834,839 4,835,856 17 18 Operating Expenses 19 Operating and Maintenance 1,539,529 1,538,464 1,693,573 1,941,605 1,704,833 2,198,401 2,264,353 2,332,284 2,402,252 2,474,320 2,548,5 49 2,625,006 2,703,756 2,784,869 2,868,415 20 One-Time Operating Expenses 80,000 750,000 21 Depreciation - Water 870,266 902,670 1,041,246 992,684 950,876 970,876 1,126,357 1,344,157 1,362,534 1,383,460 1,402,604 1,415,474 1,428,4 68 1,441,461 1,454,455 22 Total Operating Expenses 2,409,795 2,441,134 2,734,819 2,934,289 2,655,709 3,249,277 4,140,710 3,676,440 3,764,786 3,857,779 3,951,153 4, 040,480 4,132,224 4,226,330 4,322,870 23 24 Net Operations (33,811) (173,932) (221,085) (422,960) 940,682 300,464 (367,507) 695,168 607,297 553,782 460,893 753,869 662,618 608,509 512,986 25 Non operating revenues (expenses) 26 Interest Income 31,844 60,529 33,007 1,394 7,992 47,000 47,118 10,951 12,577 13,585 14,108 15,499 18,354 42,092 47,153 27 Interest Expense - Existing Debt (38,155) (34,606) (30,785) (26,713) (16,235) (225,182) (146,449) (134,535) (121,289) (107,809) (93,895) (79,646) (65,863) (54,088) (43,366) 28 Interest Expense - New Debt (2023-2032) 00 (468,117) (304,562) (294,165) (283,638) (272,893) (261,919) (250,740) (239,201) 29 Miscellaneous 43,378 10,667 2,904 28,069 782 3,800 3,800 3,800 3,800 3,800 3,800 3,800 3,800 3,800 3,800 30 COI 31 Total non operating revenue (expenses) 37,067 36,590 5,126 2,750 (7,461) (174,382) (95,532) (587,901) (409,474) (384,589) (359,624) (333,240) (305,627) (258,935) (231,614) 32 33 Net increase (decrease) in resources 3,256 (137,342) (215,959) (420,210) 933,221 126,081 (463,038) 107,267 197,823 169,194 101,269 420,629 356,991 349,574 281,373 34 35 Operating Transfer In (Out) 36 Capital Contributions 1,326,323 2,496,093 2,024,319 1,057,565 53,860 80,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 37 Cumulative Effect of Change in Acct Principle 38 PILOT Payment (582,619) (615,086) (675,875) (640,452) (620,000) (620,000) (632,400) (645,048) (657,949) (671,108) (684,530) (698,221) (712,185) (726,429) (740,957) 39 Ending Net Assets 31,625,178 33,368,843 34,501,328 34,498,231 34,865,312 34,451,394 33,385,955 32,878,174 32,448,048 31,976,134 31,422,872 31,175,280 30,850,087 30,503,231 30,073,647 40 CIP Funding 41 Purchase of Capital Assets - Water (1,031,590) (320,472) (102,166) (1,430,086) (926,000) (1,999,549) (8,565,000) (470,000) (545,000) (601,000) (345,000) (350,000) (350,000) (350,000) (350,000) 42 Capital Contributions 61,485 219,086 731,253 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 43 Principal Payments on Existing bonds (98,345) (104,368) (110,419) (111,497) (42,604) (243,741) (279,908) (346,106) (347,336) (358,599) (369,895) (376,226) (330,000) (345,000) (355,000) 44 Debt Proceeds/Grants 4,140,000 1,336,549 4,915,000 45 Transfers - TID 6 & 7 (2022C Issue) 89,067 72,844 110,844 132,544 133,644 134,544 130,344 126,144 127,394 128,947 46 Transfers - TI D 6,7,8 (2024 Issue) 274,059 274,059 274,059 274,059 274,059 274,059 274,059 274,059 Actual Projected Germantown Water Utility LRCFA Updated 8-11-23 Prepared 8/14/2023 Page 11 Page 17 of 87 47 Disposal of Capital Asset 48 Future Debt Principal (2023-2032) 00 (80,000) (245,000) (255,000) (265,000) (275,000) (285,000) (295,000) (310,000) 49 Special Assessment Revenues Collected 1,386 50 Debt Reallocation between funds 51 52 Beginning Cash 2,668,342 1,776,414 1,845,095 2,081,524 1,861,532 6,297,025 5,986,309 2,190,164 2,515,336 2,717,010 2,821,659 3,099,709 3,670 ,766 4,209,243 4,715,301 53 Add net operations (line 24) (33,811) (173,932) (221,085) (422,960) 940,682 300,464 (367,507) 695,168 607,297 553,782 460,893 753,869 662,618 608,509 512,986 54 Add back depreciation (line 21) 870,266 902,670 1,041,246 992,684 950,876 970,876 1,126,357 1,344,157 1,362,534 1,383,460 1,402,604 1,4 15,474 1,428,468 1,441,461 1,454,455 55 Add net non operating (line 31) 37,067 36,590 5,126 2,750 (7,461) (174,382) (95,532) (587,901) (409,474) (384,589) (359,624) (333,240) (305,627) (258,935) (231,614) 56 Add capital and bond (lines 41-50) (1,067,064) (424,840) 6,501 (810,330) 3,171,396 (787,674) (3,827,064) (481,203) (700,733) (776,896) (541,293) (566,824) (534,798) (558,548) (581,995) 57 Add transfer in (out) (582,619) (615,086) (675,875) (640,452) (620,000) (620,000) (632,400) (645,048) (657,949) (671,108) (684,530) (698,221) (712,185) (726,429) (740,957) 58 Net change in balance sheet items (115,767) 343,279 80,516 658,316 000000000 59 Ending Cash 1,776,414 1,845,095 2,081,524 1,861,532 6,297,025 5,986,309 2,190,164 2,515,336 2,717,010 2,821,659 3,099,709 3,670,766 4,209,24 3 4,715,301 5,128,177 60 Restricted Cash 499,887 509,418 507,005 507,005 921,005 921,005 1,473,288 1,473,288 1,473,288 1,473,288 1,473,288 1,473,288 1,473,288 1,473,2 88 1,473,288 61 Unrestricted Cash 1,276,527 1,335,677 1,574,519 1,354,527 5,376,020 5,065,304 716,876 1,042,048 1,243,722 1,348,371 1,626,421 2,197,478 2,73 5,955 3,242,013 3,654,889 62 63 Ending Net Assets 31,625,178 33,368,843 34,501,328 34,498,231 34,865,312 34,451,394 33,385,955 32,878,174 32,448,048 31,976,134 31,422,87 2 31,175,280 30,850,087 30,503,231 30,073,647 Germantown Water Utility LRCFA Updated 8-11-23 Prepared 8/14/2023 Page 12 Page 18 of 87 Table11 Water Utility Financial Benchmarking Analysis Projected 2023 - 2032 Village of Germantown, WI Budget 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 Target minimum cash balance Target minimum working capital - Ehlers1 2,812,911 3,189,502 3,229,554 3,280,016 3,330,269 3,373,115 3,364,985 3,421,207 3,479,480 3,532,965 Actual Days Cash Available - PSC2 738 83 130 161 171 203 269 329 383 423 Actual Days Cash Available - Moody's3 811 87 163 189 199 233 306 369 425 465 Actual Days Cash Available - S&P4 811 87 163 189 199 233 306 369 425 465 Actual working capital-cash balance 5,986,309 2,190,164 2,515,336 2,717,010 2,821,659 3,099,709 3,670,766 4,209,243 4,715,301 5,128,177 Over (Under) Ehlers target 3,173,397 (999,338) (714,218) (563,006) (508,610) (273,406) 305,781 788,035 1,235,821 1,595,212 Over (Under) PSC target (90 days) 648 (7) 40 71 81 113 179 239 293 333 Over (Under) Moody's target (150 days) 661 (63) 13 39 49 83 156 219 275 315 Over (Under) S&P target (150 days) 661 (63) 13 39 49 83 156 219 275 315 Notes: 1) Target capital equals 6 mos of next year's operating expenses, including depreciation, plus 100% of following year's 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 Rate of Return Average Utility Plant in Service 26,028,338 31,310,613 35, 828,113 36,335,613 36,908,613 37,381,613 37,729,113 38,079,113 38,429,113 38,779,113 Plus: Materials and Supplies 0000000000 Less: Utility Plant Accumulated Depreciation 9,317,593 10,103,074 11,106,354 12,128,012 13,170,596 14,232,324 15,306,921 16,394,513 17,4 95,098 18,608,677 Less: Regulatory Liability 45,645000000000 Average Net Investment Rate Base (NIRB) 16,665,100 21, 207,539 24,721,758 24,207,601 23,738,017 23, 149,289 22,422,191 21,684,600 20,934,0 14 20,170,435 Net Operating Income 21,340 (659,031) 390,996 290,224 223,550 117,238 396,524 291,309 222,956 112,905 ROR 0.13% -3.11% 1.58% 1.20% 0.94% 0.51% 1.77% 1.34% 1.07% 0.56% Benchmark 6.50% 6.50% 6.50% 6.50% 6.50% 6.50% 6.50% 6.50% 6.50% 6.50% Cost Recovery Operating Revenues 3,549,741 3,773,203 4,371,608 4,372, 083 4,411,562 4,412,046 4,794,348 4,794,842 4,834,839 4,835,856 Operating Expenses incl. Depr & Amortization 3,249,277 4,140,710 3,676,440 3,764,786 3,857,779 3,951,153 4,040,480 4,132,224 4,226,330 4,322,870 Operating Expenses w/o Depr & Amortization 2,278,401 3, 014,353 2,332,284 2,402,252 2,474,320 2,548,549 2,625,006 2,703,756 2,784,869 2,8 68,415 Cost Recovery incl. Depr 1.09 0.91 1.19 1.16 1.14 1.12 1.19 1.16 1.14 1.12 Cost Recovery w/o Depr 1.43 1.37 1.58 1.57 1.56 1.55 1.54 1.53 1.52 1.51 Target 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Notes: This operating ratio indicates whether operating revenues (mostly charges to customers) were sufficient to cover operations and capital (in the form of depreciation) for the water and/or wastewater utility in the fiscal year. A ratio of < 1 could be a sign of financial concern. In general, this ratio should be > 1 to accommodate future capital investments. Leverage Total Long-Term Debt 4,228,069 10,918,162 10,492,056 9,899, 720 9,286,122 8,651,226 8,000,000 7,385,000 6,745,000 6,080,000 Total Net Assets 52,715,322 61,280,322 61,750,322 62,295, 322 62,896,322 63,241,322 63,591,322 63,941,322 64,291,322 64,641,322 Debt-to Equity Ratio 0.08 0.18 0.17 0.16 0.15 0.14 0.13 0.12 0.10 0.09 Notes: This indicator measures the existing level of leveraging of assets, and is used by funders and rating agencies to evaluate the risk of providing additional loans to the utility. The ratio indicates the amount of long-term debt that exists for every $1 of assets (fund equity). A utility with a ratio > 1 has more long-term debt than equity in the system’s assets. There are no natural benchmarks for this indicator, and funders and rating agencies will assess this ratio in various ways. In general, the higher this ratio, the more likely the utility will be considered to be over-leveraged and the more difficult it will be for the utility to obtain additional loans. Net Assets are equal to the Net Investment Rate Base of the utility. Condition of Assets: Accumulated Depreciation Expense 9,317,593 10,103,074 11, 106,354 12,128,012 13,170,596 14,232,324 15,306,921 16,394,513 17,495,098 18,608 ,677 Total Net Assets 52,715,322 61,280,322 61,750,322 62,295, 322 62,896,322 63,241,322 63,591,322 63,941,322 64,291,322 64,641,322 Asset Depreciation 17.68% 16.49% 17.99% 19.47% 20.94% 22.50% 24.07% 25.64% 27.21% 28.79% Notes: This indicator of infrastructure condition estimates the portion of the average expected life of the utility’s physical assets that has already passed. As this ratio approaches 100%, the capital assets become fully depreciated, and infrastructure needs replacement or rehabilitation. The accuracy of this indicator relies heavily on the accuracy of the depreciation schedule, and historic pricing likely distorts this indicator (newer utilities may be slightly disadvantaged as a result). Asset Efficiency Total Assets 52,715,322 61,280,322 61,750,322 62,295,322 62,896,322 63,241,322 63,591,322 63,941,322 64,291,322 64,641,322 Revenue 3,503,241 3,726,238 4,285,174 4,285,174 4,285,174 4,285,174 4,627,988 4,627,988 4,627,988 4,627,988 Investment to produce $1 Revenue 15.05$ 16.45 $ 14.41 $ 14.54 $ 14.68 $ 14.76 $ 13.74 $ 13.82 $ 13.89 $ 13.97$ Notes: Projected Germantown Water Utility LRCFA Updated 8-11-23 Prepared 8/14/2023 Page 13 Page 19 of 87 Table 12 Water Utility Statement of Projected Revenue Bond Coverage Village of Germantown, WI Less: Existing Rev Debt Year Total Operating Revenues Total O&M Expense Amount Available for Debt Service Total Total Total Water Debt Service Coverage Debt Service Capacity @ 1.25x Max of Plan Debt Service 2023 3,719,608 (2,278,401) 1,441,207 468,923 - 468,923 3.07 684,043 1,028,758 2024 3,926,964 (3,014,353) 912,611 426,357 - 426,357 2.14 303,732 1,028,758 2025 4,801,262 (2,332,284) 2,468,978 480,641 548,117 1,028,758 2.40 946,424 1,028,758 2026 4,825,062 (2,402,252) 2,422,810 468,624 549,562 1,018,186 2.38 920,061 1,028,758 2027 4,866,649 (2,474,320) 2,392,330 466,407 549,165 1,015,572 2.36 898,291 1,028,758 2028 4,868,556 (2,548,549) 2,320,007 463,790 548,638 1,012,428 2.29 843,578 1,028,758 2029 5,248,049 (2,625,006) 2,623,043 455,872 547,893 1,003,765 2.61 1,094,670 1,028,758 2030 5,247,198 (2,703,756) 2,543,442 395,863 546,919 942,781 2.70 1,091,973 1,028,758 2031 5,312,184 (2,784,869) 2,527,315 399,088 545,740 944,828 2.67 1,077,024 1,028,758 2032 5,319,815 (2,868,415) 2,451,400 398,366 549,201 947,567 2.59 1,013,553 1,028,758 Notes: Future Rev Germantown Water Utility LRCFA Updated 8-11-23 Prepared 8/14/2023 Page 14 Page 20 of 87 Table 13 Water Utility Long-Range Planning Analysis Village of Germantown, WI Are rates set to maintain adequate reserves? How much reserves are planned for future projects? Are rates set to pay for financial obligations? 0 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 7,000,000 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 Reserves ‐ Actual vs. Target Target Ending Cash $0 $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 "All‐in" Debt Coverage Existing Debt P&I New (2023‐2032) Debt Service P&I Min Rec. Avail. Revs for DS Revenues Avail. For D.S.  $‐  $1,000  $2,000  $3,000  $4,000  $5,000  $6,000  $7,000 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 In thousands (000s) Reserves (End of Year) Reserves Alloc. For Future Projects  $‐  $20.00  $40.00  $60.00  $80.00  $100.00  $120.00 0.00% 2.00% 4.00% 6.00% 8.00% 10.00% 12.00% 14.00% 16.00% 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 Customer Bill ($) % Rate Increase Rate Increases Rate Increases Customer Bill Germantown Water Utility LRCFA Updated 8-11-23 Prepared 8/14/2023 Page 15 Page 21 of 87 Table 14 Projected Impact of CIP on Typical Residential Utility Bill Village of Germantown, WI Year Increase  Water  Vol.  Charge1  Water  User  Charge2 Utility Bill  (Quarterly) Change Over  Prior Year Utility Bill  (Annual) Change  Over Prior  Year Year Tiered Serv. + PFP 2022 4.15 21.47 71.27$                 285.08$          2022 2023 0.00% 4.15 21.47 71.27$                 ‐$                    285.08$          ‐$                 2023 2024 9.18% 4.53 23.44 77.81$                 6.54$                  311.25$          26.17$             2024 2025 15.00% 5.21 26.96 89.48$                 11.67$                357.94$          46.69$             2025 2026 0.00% 5.21 26.96 89.48$                 ‐$                    357.94$          ‐$                 2026 2027 0.00% 5.21 26.96 89.48$                 ‐$                    357.94$          ‐$                 2027 2028 0.00% 5.21 26.96 89.48$                 ‐$                    357.94$          ‐$                 2028 2029 8.00% 5.63 29.11 96.64$                 7.16$                  386.57$          28.64$             2029 2030 0.00% 5.63 29.11 96.64$                 ‐$                    386.57$          ‐$                  2030 2031 0.00% 5.63 29.11 96.64$                 ‐$                    386.57$          ‐$                 2031 2032 0.00% 5.63 29.11 96.64$                 ‐$                    386.57$          ‐$                 2032 Total Change over planning period 25.37$            101.49 $        Notes: 1. Current water volumetric rate is 4.15 per 1,000 gallons. 2. The water user charges include a quarterly service charge of $19.35 plus a public fire protection charge of $2.13 for a 5/8 inch meter. 3. The usage is assumed to be 12,000 Gallons per quarter. Water Germantown Water Utility LRCFA Updated 8‐11‐23 Prepared 8/14/2023 Page 16 Page 22 of 87 Water Utility Sewer Utility Operating Cash Flows: Total Operating Revenues 3,599,255.83 7,685,363.22 Less: Total Operating Expenses 4,005,523.67 7,927,927.54 Net Operating Income / (Loss) (406,267.84) (242,564.32) Less: Net Changes to Long-Term Assets and (Liabilities) Due to Operations (1,225,000.00) (1,100,000.00) Net Change to Current Position Due to Operations 818,732.16 857,435.68 Less: Net Changes to Short-Term Assets and (Liabilities) Due to Operations 48,193.70 (790,190.86) Net Cash Flow Due to Operations 770,538.46 1,647,626.54 Investing Cash Flows*: Total Investment Interest Revenues 120,764.44 120,800.84 Less: Net Changes to Assets and (Liabilities) Due to Investments (70,000.00) - Net Cash Flow Due to Investments 190,764.44 120,800.84 Capital and Related Financing Cash Flows: Total Capital and Financing Revenues / Inflows of Resources 40,432.69 17,020.80 Less: Total Capital and Financing Expenses / Outflows of Resources 367,630.60 247,632.52 Net Capital and Financing Income / (Loss) (327,197.91) (230,611.72) Less: Net Changes to Capital Assets and (Long-Term Liabilites Due to Financing) 1,435,077.26 511,090.97 Net Cash Flow Due to Capital and Related Financing (1,762,275.17) (741,702.69) Total Net Cash Flows (800,972.27) 1,026,724.69 Beginning Cash (and Investments) Balance 2,213,851.66 3,567,136.86 Ending Cash (and Investments) Balance 1,412,879.39 4,593,861.55 Page 23 of 87 BUSINESS OF THE UTILITY ADVISORY COMMITTEE MEETING DATE: January 28, 2026 PLACEMENT: Presentation ITEM TITLE: Sewer Utility Cash Flow & Rate Discussion (DISCUSSION) SUBMITTED BY: SUMMARY EXPLANATION: ATTACHMENT: 1. Germantown Sewer Rate Presentation 1-24-24 2. 2025 - Utilties Statement of Cash Flows STAFF RECOMMENDATION: ACTION BY COMMITTEE: Page 24 of 87 Village of Germantown, WI 2024 Sewer Rate Study Presentation January 30, 2024 Utility Advisory Committee Page 25 of 87 2 • RFP for Sewer Rate Study – 5-year projection of user rates • Sewer Utility contemplating future capital investment • Ehlers to identify fiscal sustainability • 3 General Scenarios Requested:  Rate decrease over a 5-year period (2024-2028)  No change to user rates over a 5-year (2024-2028)  Rate increase scenario – recommendations as warranted Why are we here? Page 26 of 87 3 • Historical Rate Performance • Historical Benchmarking Analysis  Reserve levels relative to recommended levels • Future Projections  O&M, Depreciation  Funding Project(s): Debt vs. Cash • Rate Impacts by Scenario Process Page 27 of 87 4 Sewer: Historical Rate Performance Page 28 of 87 5 Sewer: Historical Rate Performance Estimated 2019 2020 2021 2022 2023 Revenues Total Revenues from User Rates $6,828,216 $6,787,222 $6,931,180 $7,037,371 $7,175,777 Total Other Revenues $240,915 $138,698 $33,729 ($221,831) $105,500 Total Revenues $7,069,131 $6,925,920 $6,964,909 $6,815,540 $7,281,277 Less: Expenses Operating and Maintenance $5,923,429 $5,788,736 $6,088,401 $5,983,422 $6,111,382 Net Before Debt Service and Capital Expenditures $1,145,702 $1,137,184 $876,508 $832,118 $1,169,895 Existing Debt P&I $54,617 $271,314 $190,192 $202,869 $417,287 Transfer In (Out)/Misc. $231,231 $235,184 $284,370 $122,498 $230,000 Less: Capital Improvements $3,529,009 $3,941,377 $749,221 $7,745,951 $1,235,000 Debt Issued/Grants/Aid $3,108,110 $0 $0 $5,061,617 $0 Reconcile to Audit $272,727 $411,166 ($675,329) $642,193 $0 Net Annual Cash Flow $1,174,144 ($2,429,157) ($453,864) ($1,290,394) ($252,392) Restricted and Unrestricted Cash Balance: Balance at first of year $7,820,872 $8,995,016 $6,565,859 $6,111,995 $4,821,601 Net Annual Cash Flow Addition/(subtraction) $1,174,144 ($2,429,157) ($453,864) ($1,290,394) ($252,392) Balance at end of year $8,995,016 $6,565,859 $6,111,995 $4,821,601 $4,569,209 Actual Page 29 of 87 6 Sewer: Historical Financial Indicators • Reserves to fund capital Page 30 of 87 7 Future Capital Projects 2024 2025 2026 2027 2028 Totals Transportation Equipment 395,000 395,000 Interceptor Main & Accessories 270,000 270,000 Electric Pumping Equipment Lift 7 pump replacement 25,000 25,000 Collecting System 80,000 80,000 Field Mobile Work Stations 3,500 3,500 Relining & Manhole Maint sewer lines 70,000 70,000 70,000 210,000 CIPP waterway crossings 200,000 200,000 400,000 Lift Stations 1,100,000 1,100,000 Truck (552) 2005 Jet Vac Replacement 35,000 35,000 35,000 105,000 Pump Upgrade w/ Controls- Lift 3 110,000 110,000 Old Farm Lift Paralell Force Main-24" 2,100,000 2,100,000 Truck (555) 2009 GMC 2500 4X4 liftgate Replacement 65,000 65,000 Telemetry Equipment 15,000 25,000 40,000 Paralell Force Main from Main Street Lift 1,200,000 1,200,000 Auto Bar Screen-Main Street Lift 180,000 180,000 Actual CIP Costs 1,888,500 685,000 2,405,000 1,305,000 0 6,283,500 • Reserve balances have steadily declined due to capital spending. Are at a level that doesn’t allow for continued use • Will need to consider: • Debt financing, OR • Significant user rate increases to continue cash funding projects Page 31 of 87 8 Sewer Cash Flow: No Rate Increase & Cash Fund CIP Budget 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 Revenues Total Revenues from User Rates1 $7,175,777 $7,175,777 $7,175,777 $7,175,777 $7,175,777 $7,175,777 $7,175,777 $7,175,777 $7,175,777 $7,175,777 Percent Increase to User Rates 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Total Other Revenues $96,834 $97,240 $97,648 $98,059 $98,473 $98,890 $99,309 $99,731 $100,156 $100,584 Total Revenues $7,272,611 $7,273,017 $7,273,425 $7,273,836 $7,274,250 $7,274,667 $7,275,086 $7,275,508 $7,275,933 $7,276,361 Less: Expenses Operating and Maintenance $6,305,754 $6,431,869 $6,560,506 $6,691,716 $6,825,551 $6,962,062 $7,101,303 $7,243,329 $7,388,196 $7,535,960 Net Before Debt Service and Capital Expenditures $966,857 $841,148 $712,919 $582,120 $448,700 $312,605 $173,783 $32,179 ($112,262) ($259,599) Debt Service Total Debt Service $575,181 $531,656 $533,556 $529,881 $531,331 $532,806 $534,194 $535,513 $531,178 $531,188 Transfer In (Out) $230,000 $230,000 $230,000 $230,000 $230,000 $230,000 $230,000 $230,000 $230,000 $230,000 Less: Capital Improvements $1,888,500 $685,000 $2,405,000 $1,305,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 D e b t I s s u e d / G r a n t s / A i d $ 0 $ 0 $ 0 $ 0 $ 0$ 0$ 0 $ 0 $ 0$ 0 Net Annual Cash Flow ($1,266,824) ($145,508) ($1,995,637) ($1,022,761) ($602,632) ($740,201) ($880,411) ($1,023,333) ($1,163,441) ($1,310,786) Restricted and Unrestricted Cash Balance: Balance at first of year $4,569,209 $3,302,385 $3,156,876 $1,161,239 $138,478 ($464,154) ($1,204,355) ($2,084,766) ($3,108,099) ($4,271,539) Net Annual Cash Flow Addition/(subtraction) ($1,266,824) ($145,508) ($1,995,637) ($1,022,761) ($602,632) ($740,201) ($880,411) ($1,023,333) ($1,163,441) ($1,310,786) Balance at end of year $3,302,385 $3,156,876 $1,161,239 $138,478 ($464,154) ($1,204,355) ($2,084,766) ($3,108,099) ($4,271,539) ($5,582,326) Over/Under Targeted Minimum Balance Req. ($922,815) ($1,157,900) ($3,253,304) ($4,365,222) ($5,051,506) ($5,876,637) ($6,843,301) ($7,948,655) ($9,199,909) ($10,604,139) Over/Under Targeted Moody's Minimum Balance Req 18 7 (107) (164) (196) (234) (278) (327) (381) (440) Projected 1. Targeted  minimum balance equates to 6 months operating expense and next year’s principal and interest payments. 2. Moody’s  fund balance is expressed in day’s cash on hand with a target equal to 150 days of cash on hand. Page 32 of 87 9 Sewer: 5-Year Rate Decrease Budget 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 Revenues Total Revenues from User Rates1 $6,960,504 $6,751,689 $6,549, 138 $6,352,664 $6,162,084 $6, 162,084 $6,162,084 $6,162, 084 $6,162,084 $6,162,084 Percent Increase to User Rates -3.00% -3.00% -3.00% -3.00% -3.00% 0.00% 0.00% 0.00% 0.00% 0.00% Cumulative Percent Rate Increase -3.00% -5.91% -8.73% -11.47% -14.13% -14.13% -14.13% -14.13% -14.13% -14.13% Dollar Amount Increase to Revenues -$215, 273 -$208,815 -$202,551 -$196,474 -$190,580 $0 $0 $0 $0 $0 Total Other Revenues $96,834 $97,240 $97,648 $98, 059 $98,473 $98,890 $99,309 $99,731 $100,156 $100,584 Total Revenues $7,057,338 $6,848,928 $6, 646,786 $6,450,723 $6,260,557 $6, 260,974 $6,261,393 $6,261, 815 $6,262,240 $6,262,668 Less: Expenses Operating and Maintenance $6,305,754 $6,431,869 $6,560,506 $6,691, 716 $6,825,551 $6,962,062 $7,101,303 $7,243,329 $7,388,196 $7,535,960 Net Before Debt Service and Capital Expenditures $751,584 $417,059 $86,280 ($240,993) ($564,994) ($701,088) ($839,910) ( $981,514) ($1,125,956) ($1,273,292) Total Debt Service $575,181 $531,656 $533,556 $529,881 $531,331 $532,806 $534,194 $535,513 $531,178 $531,188 Transfer In (Out) $230,000 $230,000 $230,000 $230,000 $230,000 $230,000 $230,000 $230,000 $230,000 $230,000 Less: Capital Improvements $0 $0 $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 $406,403 $115,403 ($217,276) ($540,874) ($866,325) ($1,003,894) ($1,144,104) ($1,287,026) ($1,427,134) ($1,574,479) Restricted and Unrestricted Cash Balance: Balance at first of year $4, 569,209 $4,975,611 $5,091, 014 $4,873,738 $4,332,864 $3,466,539 $2,462,645 $1,318,541 $31,515 ($1,395,619) Net Annual Cash Flow Addition/(subtraction) $406,403 $115,403 ($217,276) ($540,874) ($866,325) ($1, 003,894) ($1,144,104) ($1,287,026) ($1,427,134) ($1,574,479) Balance at end of year $4, 975,611 $5,091,014 $4,873,738 $4,332,864 $3,466,539 $2,462, 645 $1,318,541 $31,515 ($1,395,619) ($2,970,098) Over/Under Minimum Balance Req. $778,021 $827,205 $547,999 ($61,243) ($997,298) ($2,072,201) ($3,288,636) ($4,643,761) ($6,144,786) ($7,798,788) Over/Under Targeted Moody's Min. Bal. Req. 115 116 99 65 14 (42) (103) (168) (239) (313) Projected 1. Targeted  minimum balance equates to 6 months operating expense and next year’s principal and interest payments. 2. Moody’s  fund balance is expressed in day’s cash on hand with a target equal to 150 days of cash on hand. Page 33 of 87 10 Sewer: CIP Borrowing Option Budget 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 Revenues Total Rev enues from User Rates1 $7,175,777 $7,426,929 $7,426,929 $7,686,872 $7,917,478 $8,155,002 $8,399,652 $8,651,642 $8,911,191 $8,911,191 Percent Increase to User Rates 0.00% 3.50% 0.00% 3.50% 3.00% 3.00% 3.00% 3.00% 3.00% 0.00% Cumulative Percent Rate Increase 0.00% 3.50% 3.50% 7.12% 10.34% 13.65% 17.06% 20.57% 24.18% 24.18% Dollar Amount Increase to Revenues $251,152 $0 $259,943 $230,606 $237,524 $244,650 $251,990 $259,549 $0 Total Other Revenues $96,834 $97,240 $97,648 $98,059 $98,473 $98,890 $99,309 $99,731 $100,156 $100,584 Total Revenues $7,272,611 $7,524,169 $7,524,578 $7,784,931 $8,015,951 $8,253,892 $8,498,962 $8,751,373 $9,011,347 $9,011,775 Less: Expenses Operating and Maintenance $6,305,754 $6,431,869 $6,560,506 $6,691,716 $6,825,551 $6,962,062 $7,101,303 $7,243,329 $7,388,196 $7,535,960 Net Before Debt Service and Capital Expenditures $966,857 $1,092,300 $964,071 $1,093,215 $1,190,400 $1,291,830 $1,397,658 $1,508,044 $1, 623,152 $1,475,815 Debt Service Existing Debt P&I $575,181 $531,656 $533,556 $529,881 $531,331 $532,806 $534,194 $535,513 $531,178 $531,188 New (2024-2033) Debt Service P&I $0 $152,713 $150,838 $346,788 $450,450 $450,975 $451,300 $446,288 $450,825 $449,800 Total Debt Service $575,181 $684,369 $684,394 $876,669 $981,781 $983,781 $985,494 $981,800 $982,003 $980,988 Transfer In (Out) $230,000 $230,000 $230,000 $230,000 $230,000 $230,000 $230,000 $230,000 $230,000 $230,000 Less: Capital Improvements $1,888,500 $685,000 $2,405,000 $1,305,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 Debt Issued/Grants/Aid $1,975,000 $0 $2,500,000 $1,380,000 $0 $0 $0 $0 $0 $0 Net Annual Cash Flow $708,176 ($47,069) $604,677 $521,546 ($61,381) $38,049 $142,165 $256,244 $371,149 $224,828 Restricted and Unrestricted Cash Balance: Balance at first of year $4,569,209 $5,277,385 $5,230,316 $5,834,993 $6,356,539 $6,295,158 $6,333,208 $6,475,372 $6,731,616 $7,102,765 Net Annual Cash Flow Addition/(subtraction) $708,176 ($47,069) $604,677 $521,546 ($61,381) $38,049 $142,165 $256,244 $371,149 $224,828 Balance at end of year $5,277,385 $5,230,316 $5,834,993 $6,356,539 $6,295,158 $6,333,208 $6,475,372 $6,731,616 $7,102,765 $7,327,593 Over/Under Minimum Balance Req. $899,473 $764,703 $1,073,663 $1,403,936 $1,263,019 $1,220,454 $1,286,018 $1,460,344 $1,749,345 $1,886,845 Over/Under Targeted Moody's Min. Bal. Req. 132 124 153 175 165 161 162 169 181 186 Projected Page 34 of 87 11 Sewer: Cash Fund CIP Option Budget 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 Revenues Total Revenues from User Rates1 $8,467,417 $8,467,417 $8,721,439 $8,721,439 $8,721,439 $8,721,439 $8,721,439 $8,721,439 $8,721,439 $8,721,439 Percent Increase to User Rates 18.00% 0.00% 3.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Cumulative Percent Rate Increase 18.00% 18.00% 21.54% 21.54% 21.54% 21.54% 21.54% 21.54% 21.54% 21.54% Dollar Amount Increase to Revenues $1,291,640 $0 $254,023 $0 $0 $0 $0 $0 $0 $0 Total Other Revenues $96,834 $97,240 $97,648 $98,059 $98,473 $98,890 $99,309 $99,731 $100,156 $100,584 Total Revenues $8,564,251 $8,564,657 $8,819,088 $8,819,499 $8,819,913 $8,820,329 $8,820,749 $8,821,171 $8,821,596 $8,822,023 Less: Expenses Operating and Maintenance $6,305,754 $6,431,869 $6,560,506 $6,691,716 $6,825,551 $6,962,062 $7,101,303 $7,243,329 $7,388,196 $7,535,960 Net Before Debt Service and Capital Expenditures $2,258,497 $2,132,788 $2,258,581 $2,127,782 $1,994,362 $1,858,267 $1,719,446 $1,577,84 2 $1,433,400 $1,286,064 Total Debt Service $575,181 $531,656 $533,556 $529,881 $531,331 $532,806 $534,194 $535,513 $531,178 $531,188 Transfer In (Out) $230,000 $230,000 $230,000 $230,000 $230,000 $230,000 $230,000 $230,000 $230,000 $230,000 Less: Capital Improvements $1,888,500 $685,000 $2,405,000 $1,305,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 Debt Issued/Grants/Aid $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Net Annual Cash Flow $24,816 $1,146,131 ($449,975) $522,901 $1,193,031 $1,055,461 $915,252 $772,329 $632,222 $484,876 Restricted and Unrestricted Cash Balance: Balance at first of year $4,569,209 $4,594,024 $5,740,156 $5,290,181 $5,813,082 $7,006,113 $8,061,574 $8,976,826 $9,749,155 $10,381,377 Net Annual Cash Flow Addition/(subtraction) $24,816 $1,146,131 ($449,975) $522,901 $1,193,031 $1,055,461 $915,252 $772,329 $632,222 $484,876 Balance at end of year $4,594,024 $5,740,156 $5,290,181 $5,813,082 $7,006,113 $8,061,574 $8,976,826 $9,749,155 $10,381,377 $10,866,253 Over/Under Minimum Balance Req. $368,825 $1,425,380 $875,639 $1,310,929 $2,424,948 $3,400,120 $4,233,759 $4,928,708 $5,477,757 $5,873,830 Over/Under Targeted Moody's Min Bal. Req. 93 153 122 145 203 252 291 321 343 357 Projected 1. Targeted  minimum balance equates to 6 months operating expense and next year’s principal and interest payments. 2. Moody’s  fund balance is expressed in day’s cash on hand with a target equal to 150 days of cash on hand. Page 35 of 87 12 Impact of Scenarios on Avg. Res. Bill Page 36 of 87 13 • Consider capital funding strategy  Debt financing vs. cash financing 2024-2028 CIP projects • Consider reasonable amount of cash funded capital to absorb in the utility rate structure long term Recommendations TONIGHT’s ACTION: Consensus on Sewer rate approach Page 37 of 87 14 Questions? Page 38 of 87 Water Utility Sewer Utility Operating Cash Flows: Total Operating Revenues 3,599,255.83 7,685,363.22 Less: Total Operating Expenses 4,005,523.67 7,927,927.54 Net Operating Income / (Loss) (406,267.84) (242,564.32) Less: Net Changes to Long-Term Assets and (Liabilities) Due to Operations (1,225,000.00) (1,100,000.00) Net Change to Current Position Due to Operations 818,732.16 857,435.68 Less: Net Changes to Short-Term Assets and (Liabilities) Due to Operations 48,193.70 (790,190.86) Net Cash Flow Due to Operations 770,538.46 1,647,626.54 Investing Cash Flows*: Total Investment Interest Revenues 120,764.44 120,800.84 Less: Net Changes to Assets and (Liabilities) Due to Investments (70,000.00) - Net Cash Flow Due to Investments 190,764.44 120,800.84 Capital and Related Financing Cash Flows: Total Capital and Financing Revenues / Inflows of Resources 40,432.69 17,020.80 Less: Total Capital and Financing Expenses / Outflows of Resources 367,630.60 247,632.52 Net Capital and Financing Income / (Loss) (327,197.91) (230,611.72) Less: Net Changes to Capital Assets and (Long-Term Liabilites Due to Financing) 1,435,077.26 511,090.97 Net Cash Flow Due to Capital and Related Financing (1,762,275.17) (741,702.69) Total Net Cash Flows (800,972.27) 1,026,724.69 Beginning Cash (and Investments) Balance 2,213,851.66 3,567,136.86 Ending Cash (and Investments) Balance 1,412,879.39 4,593,861.55 Page 39 of 87 BUSINESS OF THE UTILITY ADVISORY COMMITTEE MEETING DATE: January 28, 2026 PLACEMENT: Presentation ITEM TITLE: Report on Old Farm and Main Street Lift Station upgrades. (DISCUSSION) SUBMITTED BY: Matthew Mortwedt, Public Works Director SUMMARY EXPLANATION: In 2025, an update to the Facilities Plan was drafted and approved by the Village Board. The Facilities Plan projected the need for increased capacity at both lift stations in the near future, especially with development continuing at the current pace. The same plan also discussed the need for mechanical and controls upgrades. Following the Facilities Plan Ruekert-Mielke completed a report that outlined the approach needed for the station upgrades. The upgrades recommended include parallel force mains, pump replacement, impeller replacement, mechanical and controls upgrades and an automatic screening system. The upgrades were estimated at $15,000,000. Considering Old Farm and Main Street Lift Stations are the two largest lift stations in the Village and critical to the function of the conveyance system, staff recommended, and the Village Board approved, $660,000 in the 2026 Wastewater Utility budget for the design of the upgrades at both stations. In early 2026, staff drafted and released an RFP to select consultants. In the coming weeks and months, the result of that RFP will be presented to the Public Works and Highway Committee for award of a contract to a engineering design consultant. Once awarded, the design is expected to take the remainder for 2026 and construction wold proceed in 2027, pending budget approval. ATTACHMENT: STAFF RECOMMENDATION: ACTION BY COMMITTEE: Page 40 of 87 BUSINESS OF THE UTILITY ADVISORY COMMITTEE MEETING DATE: January 28, 2026 PLACEMENT: Action Item ITEM TITLE: Wastewater Utility Lift Station 6 Land Acquisition (ACTION) SUBMITTED BY: Matthew Mortwedt, Public Works Director SUMMARY EXPLANATION: The acquisition of land to relocate Lift Station 6 has been part of the wastewater utility budget for several years. In 2026, it was re-approved for up to $1,200,000. The Wastewater Utility is interested in securing the parcel on the west bank of the Menomonee River on County Line Road. Lift 6 currently resides on the east bank of the Menomonee River, in the right-of-way adjacent to County Line Road and south of the Buffalo Wild Wings Restaurant. The reason for interest in this land is 4-pronged: 1. The capacity of the lift station is confined in the current location. The need to grow in the future, based on development, is not possible. Development in that sewershed is likely in the coming years. 2. The lift station has not had a major rehab in 20+ years and, absent rebuilding it on the other side of the river, that rehab project will need to become part of the 5-10 year plan. In addition to anticipated mechanical and control upgrades, the well in Lift 6 is a steel structure that has a defined period of life that will also need to be addressed. That will make the rehab of Lift 6 essentially a replacement. 3. Development around Lift 6 has caused it to sit at a low point where it is at risk of flooding. This was acutely witnessed in August 2025 when emergency measures narrowly saved Lift 6 from being a total loss to flooding. The proposed location across the river sits higher and is not as prone to flooding. 4. The relocation of Lift 6 could allow for the elimination of Lift 3 which could allow for operational savings, but more importantly one less point of failure in the system. ATTACHMENT: STAFF RECOMMENDATION: Staff are requesting a positive recommendation of the land acquisition moving forward to the Public Works and Highways Committee. ACTION BY COMMITTEE: Page 41 of 87 BUSINESS OF THE UTILITY ADVISORY COMMITTEE MEETING DATE: January 28, 2026 PLACEMENT: Presentation ITEM TITLE: Water Supply Service Area Plan (WSSAP) Review (ACTION) SUBMITTED BY: Matthew Mortwedt, Public Works Director SUMMARY EXPLANATION: State of Wisconsin DNR regulation NR854 required certain water utilities to create a Water Supply Service Area Plan (WSSAP) by the end of 2025. The Germantown Water Utility Plan has been drafted, and we now anticipate it moving through the approval process. That will start with the Utility Advisory Committee, followed by the Public Works and Highway Committee and then at a publicly noticed hearing at the Village Board. The plan is a study on sources of supply for the Village and is intended to look 10 years into the future using an analysis of current supply, anticipated development, land uses, etc. Ultimately, the plan determined that, based on current supply and projected development, there may be a need for an additional well at some point in the 10-year window. The Water Utility currently has two options for a new well location: - The addition of a deep well in the high pressure zone at the Well 12 location. - The addition of a well in the primary zone near County Line Road and Lannon Road. Alternatively, alternate sources previously evaluated may be evaluated again. Though state regulations do not require examination of storage facilities, the analysis provided some insight into that issue as well. Again, depending on development, another tower may be necessary in the high pressure zone in same 10-year window. ATTACHMENT: 1. Germantown NR 854 WSSAP Report (01-08-2026) STAFF RECOMMENDATION: Staff are requesting a positive recommendation of the WSSAP to the Public Works and Highway Committee. ACTION BY COMMITTEE: Page 42 of 87 Page 43 of 87 Plan Water Supply Service Area Plan (WSSAP) Village of Germantown Washington County, Wisconsin December 2025 Project ID: 25G018.03 Solving our clients’ toughest science and engineering challenges. Page 44 of 87 Water Supply Service Area Plan Project ID: 25G018.23 Prepared for Village of Germantown N112 W17007 Mequon Road Germantown, WI 53022 Prepared by Foth Infrastructure & Environment, LLC December 2025 Copyright©, Foth Infrastructure & Environment, LLC 2025 Ballpark Commons Office Building • 7044 South Ballpark Drive, Suite 200 • Franklin, WI 53132 • (414) 336-7900 • foth.com REUSE OF DOCUMENTS This document (including any enclosures and attachments) has been prepared for the exclusive use and benefit of the addressee(s) and solely for the purpose for which it is provided. Any use outside of said purpose and/or by anyone other than the addressee (s) is at the unauthorized user’s sole risk. Page 45 of 87 Water Supply Service Area Plan • Germantown, WI Water Supply Service Area Plan Table of Contents Page Executive Summary 1. Introduction .............................................................................................................................. 1 1.1 Purpose ........................................................................................................................ 1 1.2 Previously Approved Plans and Agreements............................................................. 1 1.3 Scope of Work .............................................................................................................. 1 1.4 Location ........................................................................................................................ 2 1.5 Water Service Area ...................................................................................................... 2 1.6 Land Use ....................................................................................................................... 2 1.7 Population Projections ................................................................................................ 2 2. Sources of Supply .................................................................................................................... 5 2.1 Existing Sources of Supply .......................................................................................... 6 2.2 Alternate Water Supply Sources ................................................................................. 8 2.2.1 Surface Water Supply Source ...................................................................... 8 2.2.2 Groundwater Supply Source ........................................................................ 8 2.2.3 Connection to Neighboring Water Communities ..................................... 10 3. Water Quality of Existing Sources ......................................................................................... 10 4. Existing Water System ........................................................................................................... 10 4.1 Primary Pressure Zone ..............................................................................................12 4.2 High/Boosted Pressure Zone ...................................................................................14 4.3 Low/Reduced Pressure Zone ...................................................................................14 4.4 Interzone Transfer .....................................................................................................14 5. Water Use ................................................................................................................................ 14 5.1 Past and Present Water Demand .............................................................................14 5.2 Average Annual Water Use .......................................................................................14 5.3 Historical Water Sales ...............................................................................................15 5.4 Non-Revenue Water ...................................................................................................15 5.5 Seasonal Water Use...................................................................................................16 5.6 Top 10 Water Users ...................................................................................................16 5.7 Maximum Day Water Use ..........................................................................................17 5.8 Unit Consumption Values..........................................................................................18 Page 46 of 87 Table of Contents (continued) Page Water Supply Service Area Plan • Germantown, WI 5.8.1 Residential Water Use ................................................................................ 19 5.8.2 Multi-Family Water Use .............................................................................. 20 5.8.3 Commercial/Business Park Water Use .................................................... 20 5.8.4 Industrial Water Use ................................................................................... 21 5.8.5 Public Water Use ........................................................................................ 22 5.9 Summary of Design Factors .....................................................................................22 5.10 Design Water Demands .............................................................................................23 6. Supply and Storage Analysis ................................................................................................. 24 6.1 Reliable Supply Capacity Evaluation ........................................................................25 6.2 Water Storage Facilities Design Criteria ..................................................................27 6.3 Water Storage Facilities Evaluation ..........................................................................28 7. WSSAP Recommendations ................................................................................................... 28 7.1 Previously Recommended Sources of Supply .........................................................30 7.2 Alternate Source Evaluation ......................................................................................30 7.3 Recommended Alternative ........................................................................................30 7.4 Environmental Impact ...............................................................................................32 7.5 Economic Impact .......................................................................................................32 7.6 Public Participation....................................................................................................32 7.7 WSSAP Updates .........................................................................................................32 Tables Table 1-1 2035 Service Area Land Use Summary .............................................................................. 5 Table 2-1 Summary of Wells ................................................................................................................ 7 Table 2-2 WDNR Approved Well Capacities ........................................................................................ 7 Table 2-3 Average Well Withdrawal Rates .......................................................................................... 7 Table 2-4 Washington County Bedrock Geology ................................................................................ 9 Table 3-1 Inorganic Raw Water Characteristics ...............................................................................11 Table 3-2 Radionuclide Raw Water Characteristics .........................................................................12 Table 3-3 PFAS Treated Water Characteristics ................................................................................12 Table 5-1 Average Annual Water Use ................................................................................................15 Table 5-2 Historical Water Sales .......................................................................................................16 Table 5-3 Summary for Monthly Water Use from 2014-2024..........................................................16 Table 5-4 2024 Largest Water Users by Volume ..............................................................................17 Table 5-5 Historical Maximum Day Water Use Summary ................................................................18 Page 47 of 87 Table of Contents (continued) Page Water Supply Service Area Plan • Germantown, WI Table 5-6 Maximum Day to Average Day Ratio Evaluation ..............................................................18 Table 5-7 Metered Sales.....................................................................................................................19 Table 5-8 Residential Water Use ........................................................................................................19 Table 5-9 Multi-Family Water Use ......................................................................................................20 Table 5-10 Commercial/Business Park Water Use ..........................................................................21 Table 5-11 Industrial Water Use ........................................................................................................21 Table 5-12 Public Water Use ..............................................................................................................22 Table 5-13 Design Demand Rates .....................................................................................................23 Table 5-14 Ultimate Water Use Design Factors per Acre ................................................................23 Table 5-15 Ultimate Water Use Design Factors per Capita .............................................................23 Table 5-16 Existing Design Demands ................................................................................................24 Table 5-17 2035 Design Demands Classifications ..........................................................................24 Table 5-18 2035 Design Demands ....................................................................................................24 Table 6-1 Existing Reliable Supply and System Capacity Evaluation ..............................................26 Table 6-2 2035 Recommended Reliable Capacity Evaluation .........................................................27 Table 6-3 Reliable Supply and Storage Analysis based on Projected 2035 Demands ..................29 Appendices Appendix A 2014 – 2024 Top 10 Water Users Appendix B Public Review Comments Page 48 of 87 Water Supply Service Area Plan • Germantown , WI Water Supply Service Area Plan (WSSAP) Executive Summary Purpose Wisconsin law requires communities serving a population over 10,000 people that withdraw water from waters of the State to prepare a Water Supply Service Area Plan (WSSAP) by the end of 2025. The purpose of this plan is to help the Germantown Water Utility ensure they can meet water demands for the next 10 years. This is accomplished through a high-level analysis of the existing and anticipated future water supply and storage facilities. Existing Water System Germantown’s water system is comprised of six (6) groundwater wells, two (2) water treatment facilities, four (4) elevated storage tanks, one (1) booster station, and three (3) pressure reducing valve vaults. An additional groundwater well will be placed into service in January 2026. The water distribution system provides a means of transporting and distributing water from the water treatment plants and wells to the utility customers. Within Germantown’s water system, there are three pressure zones including the Primary Pressure Zone, the Low/Reduced Pressure Zone, and the High/Boosted Pressure Zone. The majority of the infrastructure is within the Primary Pressure Zone, but the system can provide water between the three zones. Water Quality Raw water quality is generally good with the exception of radium and iron being present in some of the water captured from the wells. Treatment is completed prior to the water entering the distribution system. All treatment points are regularly monitored to ensure water entering the distribution system meets all state and federal requirements for consumption. Current Water Use Germantown’s average day water demand is approximately 2.1 million gallons per day with a maximum daily demand of approximately 4.2 million gallons/day. 2035 Water Use Projections Germantown’s average day water demand in 2035 is projected to be approximately 3.0 million gallons per day with a maximum daily demand of approximately 6.0 million gallons/day. WSSAP Recommendations Based on the supply analysis, the Village will have sufficient supply through the 10-year planning period. In 2035, the combined reliable supply capacity is anticipated to be at 98%. In addition, the High/Boosted Pressure Zone would have a supply deficit in the event of failure of the booster station supply or discharge main. It is recommended that the Village continue planning for two (2) additional deep wells. One will be located in the Primary Pressure Zone and the second in the High/Boosted Pressure Zone. The Village should also plan for an elevated storage tank in the High/Boosted Pressure Zone. Additionally, the Village should plan to monitor water use annually and review the WSSAP a minimum of every five (5) years. Significant changes to water use may adjust the timeframe for the recommended improvements. Public Participation The Village shall undertake a public participation process and invite comments before finalizing the WSSAP. All comments will be incorporated via Appendix B. Page 49 of 87 Water Supply Service Area Plan • Germantown, WI Foth • 1 1. Introduction The Village of Germantown Water Utility is a municipally owned utility that provides water service to residences and businesses within the Village’s corporate boundaries and a portion of the Village of Menomonee Falls . The Village currently obtains water from six (6) groundwater wells. A seventh (7) well will be placed into service in January 2026. The water from two (2) of the wells is treated using pressure filtration and hydrous manganese oxide (HMO) addition at the well stations prior to being discharg ed to the distribution system. The distribution system is separated into three (3) pressure zones. Wisconsin State Statue s281.348 requires all public water systems serving a population of 10,000 or more that withdraw water from waters of the State to have a water supply service area plan (WSSAP) prepared by December 31, 2025. Requirements and procedur es for the WSSAP, established in Wisconsin Administrative Code NR 854 (Water Supply Service Area Planning Rule), became effective On July 1, 2024. In response to the need for this plan, the Village of Germantown retained Foth Infrastructure and Environment, LLC to prepare a WSSAP to meet the requirements set forth in NR 854. 1.1 Purpose The objective of the WSSAP is to develop a process that helps a water utility ensure they can adequately supply their customers over a 10 -to-20-year planning period. The WSSAP is intended to be used as a planning document and is not meant to contain the level of detail required for an engineered facility plan. The purpose of this plan is to provide background on the Village of Germantown’s existing water system and water use, develop a high -level basis of criteria required to evaluate water supply and storage requirements, and identify the required supply and storage improvements necessary to serve the Village of Germantown over the next 10-year planning period until 2035. 1.2 Previously Approved Plans and Agreements In the development of the WSSAP, the Village was requested to provide all previously approved planning documents to ensure a consistent plan. Planning documents used in the development of the WSSAP include: ◆ Village of Germantown 2050 Comprehensive Plan, Adopted September 26, 2022. ◼ Amendment No. 1 – Adopted May 15, 2023 ◼ Amendment No. 2 – Adopted November 20, 2023 ◆ A Regional Water Supply Plan for Southeastern Wisconsin – Planning Report No. 52, SEWRPC, 2010. ◆ Community Assistance Planning Report No. 70 (2nd Edition), Sanitary Sewer Service Area for the Village of Germantown and Environs, Washington County, Wisconsin, SEWRPC, 2023, 2025. 1.3 Scope of Work The Village requested preparation of a 1 0-year WSSAP to accomplish the objectives set forth in NR 854 of the Wisconsin Administrative Code. The primary objectives of the work are listed below: Page 50 of 87 Water Supply Service Area Plan • Germantown, WI Foth • 2 ◆ Provide background information on the Village of Germantown. ◆ Determine the estimated water service area population throughout the planning period. ◆ Provide a summary of existing sources of supply. ◆ Provide a summary of the existing water system. ◆ Identify water quality issues in the Village’s existing sources of supply. ◆ Determine the Village’s projected water demand throughout the planning period. ◆ Summarize the basis of design criteria used for evaluating supply and storage capacities. ◆ Evaluate alternative water sources. ◆ Provide recommendations for future water system improvements and water sources. ◆ Provide recommendations for the analysis of consistency with other plans and agreements, public participation, and submission policies. ◆ Prepare a report documenting all phases of the plan. 1.4 Location The Village of Germantown is located in the southeast corner of Washington County, Wisconsin. The Village is located north west of Milwaukee and approximately 10 miles west of Lake Michigan. The Village encompasses a combined area of approximately 34.45 square miles. The northern portion of the Village is primarily rural residential and agricultural. The majority of the existing urban development is located in the southern central portion of the Village. The Village is bound on the north by the Town of Jackson, on the west by the Village of Richfield, on the east by the City of Mequon, and on the south by the Village of Menomonee Falls. 1.5 Water Service Area The Village of Germantown currently provides water service within the corporate boundaries of the Village of Germantown and a portion of the Village of Menomonee Falls. As part of this Study, the existing water service area was approximated based on GIS data and billing meter data. The ultimate water service area coincides with the sanitary sewer service area that is anticipated to be approved by the Milwaukee Metropolitan Sewerage District (MMSD) and the Wisconsin Department of Natural Resources (WDNR) in early 2026. The parcels currently served and the ultimate service area are shown in Figure 1-1. Parcels shown on the figure within the ultimate service area boundary that are not served are either not developed or are served by private wells. To determine the proposed service area at the end of the planning period , the Village Staff identified all parcels they anticipate will be developed by 2035. These areas are shown in Figure 1-1. 1.6 Land Use Land use data, when combined with water use data, provides a basis for estimating water demands throughout the Village of Germantown. Existing land use classifications used in this report were based on current zoning information provided by the Village and are shown in Figure 1-2. The future land use for parcels proposed to be developed by 2035 was provided by the Village and is summarized in Table 1-1. 1.7 Population Projections There is generally a close relationship between a community’s population and water use. As a result, it can be expected that water demands will increase as the population grows. Precise Page 51 of 87 PLEASANT HILL RD HOL Y HILL ROAD GOLDENDALE ROAD MAPLE ROAD DIVISION ROAD PIONEER RD FREISTADT ROAD SCENIC RD HOL Y HILL ROAD HUBERTUS RD MEQUON RD DONGES BAY RD COUNTY LINE RD FOND DU LAC AVE WILLOW CREEK RD WASAUKEE RD COUNTRY AIRE DR COLGATE RD BARK LAKE RD DIVISION RD PILGRIM RD COUNTRY AIRE DR PLEASANT VIEW DR HILLSIDE RD VILLAGE OF RICHFIELD VILLAGE OF GERMANTOWN VILLAGE OF LISBON VILLAGE OF MENOMONEE FALLS CITY OF MILWAUKEE CITY OF MEQUON TOWN OF CEDARBURG TOWN OF JACKSON TOWN OF POLK TOWN OF GERMANTOWN TOWN OF GERMANTOWN TOWN OF GERMANTOWN TOWN OF GERMANTOWN P 45 45 167 145 167 175 145 175 41 41 December 2025 ¯ 0 4,0002,000 Feet VILLAGE OF GERMANTOWN FIGURE 1-1: FUTURE WATER SERVICE AREA Path: Q:\Germantown, WI V\Water System Evaluation Study\GIS\aprx\NR 854 Study.aprx Water Service Area 2035 Development Areas to be Served 2035 Development Areas Already Served Municipal Boundaries Parcels Roads Pressure Zone Boundary Properties Currently Served Page 52 of 87 PLEASANT HILL RD HOL Y HILL ROAD GOLDENDALE ROAD MAPLE ROAD DIVISION ROAD PIONEER RD FREISTADT ROAD SCENIC RD HOL Y HILL ROAD HUBERTUS RD MEQUON RD DONGES BAY RD COUNTY LINE RD FOND DU LAC AVE WILLOW CREEK RD WASAUKEE RD COUNTRY AIRE DR COLGATE RD BARK LAKE RD DIVISION RD PILGRIM RD COUNTRY AIRE DR PLEASANT VIEW DR HILLSIDE RD VILLAGE OF RICHFIELD VILLAGE OF GERMANTOWN VILLAGE OF LISBON VILLAGE OF MENOMONEE FALLS CITY OF MILWAUKEE CITY OF MEQUON TOWN OF CEDARBURG TOWN OF JACKSON TOWN OF POLK TOWN OF GERMANTOWN TOWN OF GERMANTOWN TOWN OF GERMANTOWN TOWN OF GERMANTOWN P 45 45 167 145 167 175 145 175 41 41 December 2025 ¯ 0 4,0002,000 Ft VILLAGE OF GERMANTOWN FIGURE 1-2: LAND USE Path: Q:\Germantown, WI V\Water System Evaluation Study\GIS\aprx\NR 854 Study.aprx Existing Land Use Agriculture/Open Land Residential Multi-Family Residential MHP Mobile Home Park Residential Business Industrial Governmental/Institutional PDD Planned Development District Water Service Area Municipal Boundaries Parcels Roads 2035 Development and Rezoning Areas Page 53 of 87 Water Supply Service Area Plan • Germantown, WI Foth • 5 Table 1-1 2035 Service Area Land Use Summary Classification Area (acres) Existing 10 Year Planning Period Add'l Dev. Total Low Density Residential 2,105 153 2,258 Medium Density Residential 0 High Density Residential 308 248 556 Residential Farmstead & Agriculture 230 (52) 178 Mixed Use 878 878 Commercial 664 (5) 659 Governmental/Institutional 467 (10) 457 Industrial 1,236 237 1,473 Park Open Space/Natural 4 4 Total 5,014 1,448 6,462 statistics on population and the number of dwelling units are reported by the Bureau of the Census for each decade. Population projections for each municipality in Wisconsin are developed by the Wisconsin Department of Administration (WDOA) and the Southeastern Wisconsin Regional Planning Commission (SEWRPC). The historic population estimates and WDOA and SEWRPC population projections are shown in Figure 1-3. The water service area population was estimated based on the number of residential customers that are currently served by the Village of Germantown. The water service area population shown in Figure 1-3 does not include Village residents that are served by private wells. It was assumed that by 2050 , the water service population will include all Village residents currently served by private wells. As shown, the population has increased slightly since 2010. WDOA is currently predicting that the Village’s population will begin to decline. This decline contradicts the anticipated growth previously projected by the WDOA and projected by the SEWRPC in the Village’s 2050 Comprehensive Plan. The 2035 and 2050 population, based on SEWRPC projections, is estimated to be 26,304 and 30,766 respectively. For the purposes of this Study, the projected population of the Village will be based on SEWRPC projections. It was assumed that the growth will be linear from 2025 to 2035. The 2035 Village population and water service area population were estimated to be 26,304 and 22,400 respectively. 2. Sources of Supply As part of the requirements for NR 854, the municipality is required to evaluate alternative sources of supply. There are over 11,000 public water systems in the State of Wisconsin, of which 268 are located in Washington County. A total of seven ( 7) of the 268 public water systems in Washington County are classified as municipal community water systems. Surface water and groundwater are both used as sources of supply by communities in the State of Wisconsin. Typically, smaller communities have relied on groundwater sources while larger communities adjacent to major rivers, large lakes, or the Great Lakes have used surface water. Page 54 of 87 Water Supply Service Area Plan • Germantown, WI Foth • 6 Figure 1-3 Population Projection 2.1 Existing Sources of Supply The Village is currently supplied by six (6) groundwater wells. A seventh well (Well No. 12) will be placed in-service in January 2026. A summary of the individual well characteristics is included in Table 2-1. The discharge capacity of the wells is regulated by the WDNR. The WDNR approved well discharge capacities are summarized in Table 2-2. The average annual water withdrawal rate for each of the seven (7) wells over the past 10 years is summarized in Table 2- 3. Page 55 of 87 Water Supply Service Area Plan • Germantown, WI Foth • 7 Table 2-1 Summary of Wells Characteristic Well 2 Well 3 Well 4 Well 5 Well 7 Well 11 Well 12 Construction Date 12/01/64 10/01/67 06/18/75 12/22/87 05/26/94 02/28/09 11/9/21 Service Zone Primary Primary Primary Primary Primary Primary High Diameter of Inner Casing, in 16.375 14 10 12 16 16 24 Depth of Inner Casing, ft 123 531 536.5 102.4 112 617 101 Diameter of Borehole, in 15.25 13.25 10 12 19.25 & 13 15 21 Depth of Borehole, ft 342 1,282 1,271 40 370 1,401 394 Static Water Level(a), ft 9 188 260 1 4.5 326 58 Pumping Water Level(a), ft 63 320 485 19 87.3 528 86 Specific Capacity(a), gpm/ft 9.3 7.6 1.6 44.4 8.5 3.7 28.6 Well Pumping Rate(a), gpm 500 1,001 357 800 700 751 800 (a) As reported on the Well Construction Reports. Table 2-2 WDNR Approved Well Capacities Well WDNR HiCap Well I.D. Approved Pump Capacity (gpm) Approval Date Maximum Monthly Approved Withdrawal (gpd) Well 2 BH245 500 10/12/1962 720,000 Well 3 BH246 680 3/30/1967 979,000 Well 4 BH247 500 6/18/1975 604,000 Well 5 BH277 1,100 9/3/1987 1,224,000 Well 7 HN169 1,200 8/25/1993 1,728,000 Well 11 WJ910 750 5/12/2008 1,080,000 Well 12 AAJ181 800 9/7/2021 691,000 Maximum Average Monthly Withdrawal 6,418,600 Maximum Reliable Monthly Withdrawal 4,690,600 Table 2-3 Average Well Withdrawal Rates Well Average Daily Withdrawal (000’s gpd) Average 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 000’s gpd gpm 2 155 156 198 200 219 182 224 220 179 177 183 190 132 3 231 293 301 218 62 264 349 364 288 243 257 261 181 4 207 245 249 236 270 185 325 172 231 248 248 238 165 5 569 552 388 378 397 333 382 451 422 452 358 425 295 7 611 742 658 543 631 536 691 625 498 526 366 584 406 11 535 305 289 259 347 284 189 232 289 331 321 307 213 12 - - - - - - - - - - - - - Total 2,308 2,292 2,083 1,833 1,926 1,785 2,160 2,064 1,905 1,976 1,733 2,006 1,393 Page 56 of 87 Water Supply Service Area Plan • Germantown, WI Foth • 8 2.2 Alternate Water Supply Sources Alternative water sources near the Village of Germantown evaluated for this Study include surface water, groundwater wells, and connections to neighboring water systems. The following are summaries of the alternative water sources for the Village of Germantown. 2.2.1 Surface Water Supply Source The significant surface waters in the vicinity of the Village of Germantown include the Menomonee River and Lake Michigan. The Menomonee River is not viewed as a suitable source of supply for the Village of Germantown and is not being considered as an alt ernative supply source. Lake Michigan is the source of supply for numerous communities in eastern Wisconsin and is considered a suitable source of supply for the Village of Germantown. 2.2.2 Groundwater Supply Source Groundwater serves as the primary source of supply for all seven (7) of the municipal community water systems in Washington County, including the Village of Germantown. T here are three (3) primary groundwater aquifers in the vicinity of the Village including the Quaternary- age sand and gravel (Sand and Gravel Aquifer), Silurian-age Niagara Formation (Niagara Aquifer), and the Ordovician -age and Cambrian -age s andstone formations (Sandstone Aquifer) . The bedrock geology and known aquifers in the vicinity o f Washington and Ozaukee Counties are shown in Table 2-4. The Sand and Gravel Aquifer consist of outwash, glacial -lake deposits, or alluvium. The thickness of the Sand and Gravel Aquifer varies based on location and is primarily considered an adequate aquifer in areas west of the Village of Germantown. Generally, the Sand and Gravel Aquifer is not considered an adequate source of supply in the vicinity of the Village. The Niagara aquifer in the vicinity of the Village of Germantown is predominantly comprised of dolomite rock. The Niagara Aquifer can be locally confined ; however, it is often hydraulically connected to the overlying S and and Gravel Aquifer. Groundwater flow and availability within the Niagara is often dependent on local horizontal and vertical fracturing, typical of dolomite aquifers; however, more recent studies have shown that porous coarse -grained stratigraphic units, specifically the Racine Formation and Mayville Formation (lowest formation in the aquifer), can significantly contribute to well yield. The Niagara and underlying sandstone aquifers are separated by the Maquoketa shale formation, which is considered a low-permeable aquitard formation. The Sandstone Aquifer includes all Ordovician and Cambrian rocks older than the Maquoketa Shale formation. The Sandstone Aquifer in the Vicinity of the Village of Germantown can be divided into hydraulically connected subgroups consisting of the Galena-Platteville aquifer, upper sandstone aquifer, and lower sandstone aquifer. Of the three primary aquifers (Sand and Gravel, Niagara, and Sandstone) , the Niagara and Sandstone aquifers are considered the most suitable sources of water supply for the Village. Water quality in the individual aquifers varies based on location. Overall, the quality of the groundwater is fair to good; however, some water has characteristics that are unsuitable and require different levels of treatment to be suitable for industrial and domestic uses. Chemical characteristics of concern in the area include hardness, iron and manganese, sulfate, radium and Page 57 of 87 Water Supply Service Area Plan • Germantown, WI Foth • 9 gross alpha, and arsenic. These characteristics need to be evaluated at individual sites to determine the adequacy of the individual aquifers. Table 2-4 Washington County Bedrock Geology System Rock Unit Lithology Aquifer Saturated Thickness Water Yield Comments Quaternary Holocene Deposits Unconsolidated clay, silt, sand, gravel, and organic matter. Sand and Gravel 0 – 500 ft; generally, 0 – 100 ft Up to +500 gpm Sufficient for domestic use Pleistocene Deposits Unconsolidated clay, silt, sand, gravel, cobbles, boulders, and organic matter. Devonian Undifferentiated Dolomite and Shale Dolomite, brown to gray and gray shale. Crevices and solution channels are abundant but discontinuous. Niagara 0 – 700 ft Up to 1,000 gpm; generally 150 – 500 gpm Sufficient for domestic, municipal, industrial, or irrigation use Silurian Undifferentiated Dolomite Dolomite, white to gray. Crevices and solution channels are abundant but discontinuous. Ordovician Maquoketa Shale Shale, dolomitic, blue-gray; dolomitic beds as thick as 65 feet occur at the top. Na Na Confining Galena Dolomite, Decorah Formation, and Platteville Formation, Undifferentiated Dolomite and some slightly shaly dolomite, light-gray to blue-gray. Sandstone 300 – 900 ft Up to 1,200 gpm; generally 300 – 600 gpm Rarely used for domestic use because of depth and cost St. Peter Standstone Sandstone, fine- to medium grained, white to light-gray; dolomitic in some places, shaly at base in some places. Prairie du Chien Group Dolomite, gray or white; some sandstone and sandy dolomite. Camrian Trempealeau Formation Sandstone, very fine to medium grained; dolomite, light gray, interbedded with siltstone. Franconia Sandstone Sandstone, very fine to medium grained, siltstone or dolomite, sandstone, dolomitic at base, medium to coarse grained. Galesville Sandstone Sandstone, fine to medium grained, light gray Eau Claire Sandstone Sandstone, fine to medium grained, light gray to light pink, dolomitic, some shale beds. Mount Simon Sandstone Sandstone, white to light-gray; fine- to coarse-grained, mostly medium; some beds dolomitic, some interbedded shale. Precambrian Precambrian rocks, Undifferentiated Crystalline rocks. Page 58 of 87 Water Supply Service Area Plan • Germantown, WI Foth • 10 2.2.3 Connection to Neighboring Water Communities The municipal community water systems nearest in proximity to the Village of Germantown include the Village of Jackson located approximately 9 miles to the north, the Village of Menomonee Falls located approximately 4 miles to the south, and the City of Mequon located approximately 5 miles to the east. The Village of Jackson is supplied with water from five (5) groundwater wells. The Village of Menomonee Falls is supplied with water from three (3) groundwater wells and surface water from Lake Michigan. The City of Mequon is supplied with surface water from Lake Michigan. The surplus capacities and transmission capacities of these water systems are unknown and are not currently being considered as alternative supply sources for the Village of Germantown. 3. Water Quality of Existing Sources Water quality characteristics determine the level and type of treatment that is required for a municipal water supply. Raw water quality can be generally based on inorganic, radionuclide, and per/poly-fluoroalkyls (PFAS) characteristics. Water quality sample results obtained from the WDNR public water system database were analyzed as part of this Plan. Inorganic raw water quality characteristics from the existing groundwater wells are summarized in Table 3 -1. Radionuclide raw water quality characteristics from the existing groundwater wells are summarized in Table 3-2. As shown in the tables, raw water from Well No. 4 exceeds the secondary standard for iron, raw water from Well No. 12 exceeds the secondary standard for copper, and raw water from all wells except Wells No. 3 and No. 4 exceed the secondary standard for TDS. Raw water from Wells No. 3 and No. 11 exceed the Wisconsin DNR Maximum Contaminant Limit (MCL) for total radium and gross alpha. Raw water samples have been collected at the entry points to the distribution system and analyzed for PFAS. The sampling results for PFAS are summarized in Table 3-3. As shown, PFAS concentrations are all below the MCL in the treated water entering the distribution system. 4. Existing Water System The Village of Germantown’s water system consists of a water distribution system, seven (7) groundwater wells, two (2) water treatment facilities (WTF), four (4) elevated storage tanks, one (1) booster station, and three (3) pressure reducing valve vaults. The water distribution system provides a means of transporting and distributing water from the water treatment plants and wells to the utility customers and other points of usage. Per the Village of Germantown’s 2024 Water, Electric, or Joint Utility Annu al Report submitted to the Wisconsin Public Service Commission (WPSC), the Village’s water distribution system consists of approximately 66.8 miles of water main ranging in size from 4-inch to 16-inch in diameter. The distribution system consists of three (3) pressure zones, including the Primary Pressure Zone, the High/Boosted Pressure Zone, and the Low/Reduced Pressure Zone. The pressure zones operate on different hydraulic grades, allowing the Village to serve a larger elevation range. A schematic of the Village of Germantown’s existing water system is shown in Figure 4-1. Page 59 of 87 Water Supply Service Area Plan • Germantown, WI Foth • 11 Table 3-1 Inorganic Raw Water Characteristics Characteristic Concentration MCL Secondary Standard Well 2(a) Well 3(a) Well 4(a) Well 5(a) Well 7(a) Well 11(a) Well 12(b) Alkalinity, total, mg/l 300 300 260 330 310 210 350 Aluminum, mg/l ND ND ND ND ND ND ND 0.05 to 0.2 Antimony total, mg/l 0.00014 ND ND ND ND ND ND 0.006 Arsenic, mg/l 0.0013 ND 0.00059 0.0011 0.0009 0.0006 0.0017 0.010 Asbestos, FIB/l NT NT NT NT NT NT 7 Barium, mg/l 0.11 0.066 0.057 0.12 0.073 0.011 0.12 2 Beryllium total, mg/l ND ND ND ND ND ND ND 0.004 Cadmium, mg/l ND 0.00011 0.0001 ND ND ND ND 0.005 Calcium, mg/l 110 100 110 92 110 140 96 Chloride, mg/l 81 4.8 5 92 56 18 81 250 Chromium, mg/l ND ND ND ND ND ND ND 0.1 Copper ug/l NT NT NT NT NT NT 2.7 1.0 Cyanide, mg/l NT NT NT NT NT NT ND 0.2 Fluoride, mg/l 0.49 0.41 0.58 0.46 0.51 0.68 0.14 4.0 2.0 Hardness, Total (CaCO3), mg/l 480 380 380 420 440 430 460 Iron, mg/l 0.13 ND 0.3 ND ND ND 0.2 0.3 Lead, ug/l NT NT NT NT NT NT ND Magnesium, mg/l 46 30 25 46 42 23 50 Manganese, ug/l 6.4 9.9 29 17 5.4 ND 17 50 Mercury, mg/l ND ND ND ND ND ND ND 0.002 Nickel, mg/l 0.0061 0.002 0.0011 0.014 0.0032 0.0019 0.0017 0.1 Nitrate, mg/l NT NT NT NT NT NT 0.053 10 Nitrate-Nitrite (N03+N02), mg/l 0.93 ND ND 0.087 0.27 ND 0.053 10 Nitrite (N02-N), mg/l ND ND ND ND ND ND ND 1 Nitrogen-Ammonia as (N), mg/l NT NT NT NT NT NT pH, S.U. 7.19 7.52 7.47 7.25 7.19 7.22 7.27 Residue, TOT, Filt (TDS), mg/l 650 440 460 570 600 640 550 500 Selenium, mg/l ND ND ND ND ND ND ND 0.05 Silver, ug/l ND ND ND ND ND ND ND 0.1 Sodium, mg/l 31 7 7.5 36 33 18 37 Strontium, ug/l NT NT NT NT NT NT Sulfate, mg/l 130 70 110 61 130 240 49 250 Thallium Total, mg/l ND ND ND ND ND ND ND 0.002 NT – Not Tested ND – Non-Detect (a) Results from sample collected on 02/14/2017. (b) Results from sample collected on 11/2/2021. Page 60 of 87 Water Supply Service Area Plan • Germantown, WI Foth • 12 Table 3-2 Radionuclide Raw Water Characteristics Characteristic Activity, pCi/l (unless indicated otherwise) MCL Well 2(a)(e) Well 3(b) Well 4(c)(e) Well 5(a)(e) Well 7(a)(e) Well 11(b) Well 12(d) Radium 226 ND 6.01 2.42 ND 0.553 10.2 ND 5 Radium 228 ND 5.2 1.86 ND ND 4.75 ND 5 Total Combined Radium ND 11.21 4.28 ND 0.553 14.95 ND 5 Gross Alpha (excl. radon & Uranium) 0.921 28.9 11.5 0.822 1.56 32.7 0.97 15 Radon-222 NT NT NT NT NT NT ND Combined Uranium, ug/l 0.575 0.2 0.289 0.351 0.286 0.424 ND 30 NT – Not Tested ND – Non-Detect (a) Results from sample collected on 0 1/29/2020. (b) Results from sample collected on 08/ 05/2025. (c) Results from sample collected on 0 3/07/2023. (d) Results from sample collected on 11/02/2021. (e) Results from grab at entry point to the system Table 3-3 PFAS Treated Water Characteristics Characteristic Concentration, ng/l MCL Well 2(a) Well 3(a) Well 4(a) Well 5(a) Well 7(a) Well 11(b) Well 12(d) PFBS 0.66 NT NT 0.56 0.46 NT 0.41 PFHXS 0.73 NT NT 0.64 0.53 NT 0.68 PFOA ND ND ND ND 0.59 ND 0.54 PFOS 0.64 ND ND 0.34 1.1 ND ND PFOA and PFOS Total 0.64 ND ND 0.34 1.69 ND 0.54 70 NT – Not Tested ND – Non-Detect (a) Results from sample collected on 01/24/2023. 4.1 Primary Pressure Zone The Primary Pressure Zone serves most of the Village and is supplied by six (6) groundwater wells (Wells No. 2, No. 3, No. 4, No. 5, No. 7, and No. 11). Well Stations No. 3 and No. 11 are provided with HMO feed systems and pressure filters for radium removal. Raw water from Wells No. 3 and No. 11 is pumped through pressure filters before being directly discharged to the distribution system. All well stations are provided with chlorination feed systems for disinfection and fluoride feed systems for prevention of dental caries. There are three (3) spheroid style elevated storage tanks that provide storage in the Primary Pressure Zone. Water Tower s No. 1 and No. 2 have tota l volumes of 500,000 gallons . Water Tower No. 3 has a total volume of 1,000,000 gallons. Page 61 of 87 WATER SYSTEM SYMBOL LEGEND Groundwater Well Raw Water Main Flow Control Valve Service Pump Flow Direction Pitless Booster Pump Elevated Storage Tank Municipal Boundary Pressure Zone Boundary Water Treatment Facilities Isolation Valve WTF WELL NO 11 WELL NO. 2 WELL NO. 5 WELL NO. 7 WELL NO. 4 WELL NO. 3 WELL NO. 12 MENOMONEE RIVER 41 41 45 175 145 LOW/REDUCED PRESSURE ZONE PRIMARY PRESSURE ZONE HIGH/BOOSTED PRESSURE ZONE 45 GOLDENDALE BOOSTER STATION 167 45 167 145 WTF FIGURE 7-1 RECOMMENDED WATER SYSTEM SCHEMATIC VILLAGE OF GERMANTOWN WATER SUPPLY SERVICE AREA PLAN WTF TOWER NO. X VOL. MG HWL EL = X,XXX' Normally Closed Note: Distribution system shown is a generic representation of the actual water system and does not reflect actual location of the mains. TOWER NO. 3 1.0 MG HWL EL = 1,040' TOWER NO. 2 0.50 MG HWL EL = 1,040' TOWER NO. 1 0.50 MG HWL EL = 1,040' TOWER NO. 4 0.50 MG HWL EL = 1,100' Page 62 of 87 Water Supply Service Area Plan • Germantown, WI Foth • 14 4.2 High/Boosted Pressure Zone The High/Boosted Pressure Zone serves the northwestern portion of the Village and is supplied by one (1) groundwater well (Well No. 12). Prior to discharge into the distribution system, raw water from Well No. 12 is treated with sodium hypochlorite for disinfection and fluoride for prevention of dental caries. There is one elevated storage tank that provides storage in the High/Boosted Pressure Zone. Water Tower No. 4 has a volume of 500,000 gallons and is a spheroid style tank. 4.3 Low/Reduced Pressure Zone The Low/Reduced Pressure Zone serves the southeastern portion of the Village and is supplied entirely by the Primary Pressure Zone. Water enters the Low/Reduced Pressure Zone through three pressure reducing valve stations. There are currently no groundwater wells or elevated storage tanks in the Low/Reduced Pressure Zone. 4.4 Interzone Transfer The Village operates one booster station. The Goldendale Booster Station houses two (2) service pumps and a flow control valve. In addition, a pitless style booster pump is located at the Goldendale Booster Station site. The service pumps and pitless booster pump allow transfer of water from the Primary Pressure Zone to the High/Boosted Pressure Zone. The flow control valve can transfer water from the High/Boosted Pressure Zone to the Primary Pressure Zone. 5. Water Use The analysis of present and past water use, as well as the projection of future water use, serve as the basis for capital improvements planning for the water supply and distribution system. Present and past water use was analyzed using water use information obtained from the WPSC and the Village. From this information, basic water use design criteria was developed. When applied to the land use and/or population data, the basic water use design criteria can be used to determine the water use requirements at various stages of development. The following sections summarize the methodology used to determine the basic water use design criteria. 5.1 Past and Present Water Demand An analysis of past and present water demand was completed based on information obtained from the PSC and Village. The total volume of water supplied to the users is measured at the well stations. Water use factors that must be determined to design storage, pumping, and pipeline facilities include average annual water use, maximum day water use, and peak hourly fluctuations. 5.2 Average Annual Water Use The volume of water supplied to the Village from 2014 to 2024 was evaluated to determine the average annual water use. A summary of total water pumpage and total water sold is provided in Table 5-1. The total average annual finished water pumpage (treated water entering the Village) has decreased 19.4 percent since 2014 from 2.15 mgd to 1.73 mgd. The total water sold within the Village’s water service area has decreased 18.0 percent since 2014 from 1.798 mgd to 1.475 mgd. For the purposes of this plan, a conservative existing average annual design demand of 2.10 mgd will be used for evaluating system capacities. Page 63 of 87 Water Supply Service Area Plan • Germantown, WI Foth • 15 Table 5-1 Average Annual Water Use Year Total Raw Water Pumpage (000's gal) Total Finished Water Pumpage (000's gal) Avg Annual Demand (gpd) Total Sales (000's gal) Average Annual Sales (mgd) Non- Revenue (000's gal) Non - Revenue (%) Water Loss (000's gal) Water Loss (%) 2014 787,390 784,990 2,150,658 656,303 1.798 128,687 16% 114,673 15% 2015 820,000 820,000 2,246,575 698,737 1.914 121,263 15% 104,459 13% 2016 755,701 755,701 2,064,757 582,434 1.596 173,267 23% 83,209 11% 2017 665,190 665,190 1,822,438 539,912 1.479 125,278 19% 39,280 6% 2018 702,879 702,879 1,925,696 582,561 1.596 120,318 17% 40,318 6% 2019 648,856 648,856 1,777,688 512,608 1.404 136,248 21% 98,407 15% 2020 791,124 791,124 2,161,541 655,106 1.795 136,018 17% 24,018 3% 2021 752,382 752,382 2,061,321 740,013 2.027 12,369 2% 122,631 16% 2022 668,326 668,326 1,831,030 613,236 1.680 55,085 8% 55,085 8% 2023 720,928 720,928 1,975,145 654,907 1.794 66,021 9% 66,021 9% 2024 634,329 634,329 1,733,139 538,236 1.475 96,093 15% 96,093 15% Avg 722,464 722,246 1,977,272 615,823 1.687 106,422 15% 76,745 11% 5yr - Running Avg. 713,418 713,418 1,952,435 640,300 1.754 73,117 10% 72,770 10% 5.3 Historical Water Sales A historical summary of the number of customers served and total water used based on individual customer class is shown in Table 5-2. As shown in the table, the residential, multi- family, commercial, industrial, and public water has been relatively constant. Overall, residential water use consists of approximately 42 percent of the total retail sales, multi-family water use consists of approximately 9 percent of the total retail sales , commercial water use consists of approximately 20 percent of the total retail sales, industrial water use consists of approximately 27 percent of the total retail sales, and public water use consists of ap proximately 2 percent of the total retail sales. 5.4 Non-Revenue Water Non-revenue water includes the water that is pumped but not sold in the water system. Non-revenue water consists of unbilled authorized consumption, apparent losses, and real losses. Unbilled authorized consumption includes some metered uses such as wate r use to prevent freezing and unmetered estimated uses such as hydrant flushing and fire protection. Apparent losses include estimated losses due to unauthorized consumption (theft), data and billing errors, and meter inaccuracies. Real losses include es timated reported and unreported leakage. A summary of the Village’s non-revenue water is included in Table 5-1. The total non- revenue water has ranged from 2 to 23 percent from 2014 to 2024 and averaged 15 percent. The total real losses have ranged from 3 to 16 percent from 2014 to 2024 and averaged 11 percent. For the purposes of this study, a non -revenue water use of 15 percent will be used when determining water demands. Page 64 of 87 Water Supply Service Area Plan • Germantown, WI Foth • 16 Table 5-2 Historical Water Sales Year Total Sales (000's Gal) Residential Multi-Family Commercial Industrial Public 000's Gal % of Retail 000's Gal % of Retail 000's Gal % of Retail 000's Gal % of Retail 000's Gal % of Retail 2014 656,303 264,880 40% 49,317 8% 106,747 16% 227,407 35% 7,952 1% 2015 698,737 270,293 39% 51,143 7% 121,561 17% 247,368 35% 8,372 1% 2016 582,434 262,740 45% 49,760 9% 126,118 22% 134,939 23% 8,877 2% 2017 539,912 255,115 47% 49,659 9% 128,166 24% 96,416 18% 10,556 2% 2018 582,561 249,242 43% 51,029 9% 128,235 22% 144,840 25% 9,215 2% 2019 512,608 242,644 47% 50,407 10% 127,015 25% 82,754 16% 9,788 2% 2020 655,106 248,957 38% 77,153 12% 117,846 18% 203,066 31% 8,084 1% 2021 740,013 242,287 33% 82,109 11% 125,878 17% 281,292 38% 8,447 1% 2022 613,236 241,063 39% 55,748 9% 118,982 19% 185,523 30% 11,925 2% 2023 654,907 258,972 40% 62,921 10% 142,259 22% 179,538 27% 11,217 2% 2024 538,236 241,955 45% 55,103 10% 123,151 23% 108,077 20% 9,950 2% Avg. 42% 9% 20% 27% 2% 5.5 Seasonal Water Use Understanding seasonal fluctuations in water usage are important factors in the design and sizing of water supply and storage facilities. Monthly water use information for the Village was determined using WPSC annual reports from 2014 to 2024. A summary of the monthly water use is included in Table 5-3. Table 5-3 Summary for Monthly Water Use from 2014-2024 Month Water Use Percent of Average Month Average Percent of Total Pump 000’s Gal gpd January 57,693 1,861,070 96% 8% February 49,439 1,765,695 82% 7% March 54,692 1,764,258 91% 8% April 50,976 1,699,191 85% 7% May 61,046 1,969,226 101% 8% June 66,796 2,226,542 111% 9% July 74,495 2,403,076 123% 10% August 74,952 2,417,795 125% 10% September 64,366 2,145,533 107% 9% October 59,115 1,906,941 98% 8% November 53,427 1,780,894 88% 7% December 55,464 1,789,152 92% 8% Total 100% 5.6 Top 10 Water Users The ten (10) largest water users for each year from 2014 through 2024 were provided by the Village. The largest water users by volume, as reported by the Village, in 2024 are summarized in Table 5-4. The largest water user in 2024 was G & H Pets , LLC. These top users make up approximately 30 percent of the total water sales in Germantown. A summary of the top 10 users since 2014 is included in Appendix A. Page 65 of 87 Water Supply Service Area Plan • Germantown, WI Foth • 17 Table 5-4 2024 Largest Water Users by Volume Customer Use Category Amount Sold (000’s gal) Amount Sold (gpd) Percent of Total Annual Water Sold G & H PETS LLC Industrial 86,470(a) 236,904 16.1 DSM FOOD SPECIALTIES Industrial 16,407 44,951 3.0 SUNLITE PLASTICS Industrial 10,059 27,559 1.9 HILLTOP HIGHLANDS/BROOKSIDE Residential 8,711 23,866 1.6 FIRST CHOICE INGREDIENTS Industrial 8,480 23,233 1.6 WEST ROCK Industrial 8,359 22,901 1.6 DSM FOOD SPECIALTIES (METER 2) Industrial 7,600 20,822 1.4 STERLING PHARMA SOLUTIONS Industrial 7,402 20,279 1.4 FAIRWAY KNOLL Multifamily 4,314 11,819 0.8 GERMANTOWN HIGH SCHOOL Institutional 4,042 11,074 0.8 Total 161,884 443,408 30.1 (a) G & H Pets, LLC’s meter was replaced in 2025 due to inaccurate readings. Amount sold in 2024 was estimated based on 4 th quarter readings from 2025. 5.7 Maximum Day Water Use The maximum day demand is defined as the amount of water pumped during a single day of the year with the highest water usage. The maximum day demand is often expressed as a ratio (or factor) of the annual average day pumpage. Maximum day demand ratios vary from municipality to municipality based on factors such as population, primary land use, climate, and economic status. Typically, maximum day demands usually occur during the summer months, on hot days, and during dry periods. The high demands are typically related to watering lawns, irrigation/gardening, washing, and industrial cooling. It is important to note that artificial demands caused by water main breaks, tank filling/overflows, or hydrant flushing b e identified and excluded from the evaluation for determining maximum day demands. Water records were analyzed to determine the maximum daily demand for the Village. Maximum day demand is recorded in the annual WPSC reports. A summary of the historical maximum day water use in the Village is shown in Table 5-5. As shown, the ratio of maximum day water use to average annual water use has ranged from 1.55 to 2.15. The majority of the maximum day demands occur during periods of high demands in summer. However, some of the highest maximum day demands have historically occurred when one of the Village’s largest water consumers takes their private well offline and exclusively relies on the Village as its sole source of supply. For the purposes of this plan, an evaluation was performed to determine the appropriate maximum day demand ratio to be used for evaluating the water system capacity. A summary of the evaluation is shown in Table 5-6. For the years 2014 to 2024, the average maximum day demand ratio was 1.78, with a standard deviation of 16 percent. To evaluate the existing water supply and storage needs for this plan, a maximum day to average day ratio of 2.00 will be used. Even with the artificial maximum day demands, this ratio provides a confidence level greater than 90 percent based on maximum day pumpage ratios reported over the evaluation period. Page 66 of 87 Water Supply Service Area Plan • Germantown, WI Foth • 18 Table 5-5 Historical Maximum Day Water Use Summary Year Avg. Day Max. Day Date of Ratio of Pumpage Pumpage Max. Day of Max. to (MGD) (MGD) Day Week Avg. Day Reason for Max. Day 2014 2.15 4.627 5/21 Wednesday 2.15 Large User On-Line. 2015 2.25 3.695 7/23 Thursday 1.64 High Demand. 2016 2.06 3.643 7/13 Wednesday 1.76 High Demand. 2017 1.82 3.418 8/23 Wednesday 1.88 High Demand. 2018 1.93 3.433 7/13 Friday 1.78 High Demand. 2019 1.78 3.039 9/6 Friday 1.71 High Demand. 2020 2.16 3.342 7/31 Friday 1.55 High Demand. 2021 2.06 4.038 6/9 Wednesday 1.96 High User. 2022 1.83 3.285 8/10 Wednesday 1.79 Summer User. 2023 1.98 3.207 - - 1.62 - 2024 1.73 3.026 - - 1.75 - Table 5-6 Maximum Day to Average Day Ratio Evaluation Item 2014 – 2024 Number of Years of Data 11 Maximum Ratio - Max. to Avg. Day Pumpage 2.15 Minimum Ratio - Max. to Avg. Day Pumpage 1.55 Average Ratio Max. to Avg. Day Pumpage 1.78 Standard Deviation 16% Confidence Level (%) Ratio of Max. to Avg. Day Pumpage 2014 – 2024 80% 1.92 85% 1.95 90% 1.99 95% 2.05 98% 2.11 99% 2.15 5.8 Unit Consumption Values Projections of customer demands serve as the basis for capital improvements planning. Water consumption data for the Village serves as the basis for estimating future water needs within the future water service area. All the residential, commercial, industrial, and public customers in the Village are metered. The water data and number of customers for each customer class are presented in Table 5-7. Water use and customer data can be used to develop per capita and per customer unit consumption values and consumption values on an acreage basis. The per capita and per acreage unit consumption values are necessary to determine future water requirements for the design of supply and storage facilities. Page 67 of 87 Water Supply Service Area Plan • Germantown, WI Foth • 19 Table 5-7 Metered Sales Year Total Sales 000's Gal Residential Multi-Family Commercial Industrial Public 000's Gal No. of Cust. 000's Gal No. of Cust. 000's Gal No. of Cust. 000's Gal No. of Cust. 000's Gal No. of Cust. 2014 656,303 264,880 4,774 49,317 107 106,747 433 227,407 22 7,952 23 2015 698,737 270,293 4,840 51,143 108 121,561 451 247,368 22 8,372 19 2016 582,434 262,740 4,857 49,760 108 126,118 450 134,939 22 8,877 23 2017 539,912 255,115 4,865 49,659 108 128,166 466 96,416 22 10,556 23 2018 582,561 249,242 4,868 51,029 109 128,235 455 144,840 22 9,215 23 2019 512,608 242,644 4,878 50,407 110 127,015 459 82,754 23 9,788 23 2020 655,106 248,957 4,898 77,153 141 117,846 462 203,066 26 8,084 23 2021 740,013 242,287 4,957 82,109 141 125,878 465 281,292 26 8,447 25 2022 613,236 241,063 5,294 55,748 145 118,982 454 185,523 24 11,925 33 2023 654,907 258,972 5,034 62,921 147 142,259 448 179,538 25 11,217 24 2024 538,236 241,955 5,143 55,103 149 123,151 470 108,077 25 9,950 34 5.8.1 Residential Water Use Residential water use consists of dwelling buildings that serve a single family or two - family unit through a single meter. Residential water use accounts for the majority of water use within the Village. The residential water use was estimated based on gallon per capita day (gpcd) and gallon per acreage day (gpad) basis. The residential water use per capita was estimated based on 2024 annual residential water use and estimated water service area population. The estimated water service area population includes customers classified as residential and multi -family. A summary of residential water use is shown in Table 5-8. A per capita average day water use of 50 gpcd will be used for projecting future residential water use. Table 5-8 Residential Water Use Year No. of Customers Est. Water Service Population Annual Water Use (000 gal's) Per Customer (gpd) Per Capita (gpd) 2014 4,774 14,413 264,880 152 50 2015 4,840 14,602 270,293 153 51 2016 4,857 14,646 262,740 148 49 2017 4,865 14,666 255,115 144 48 2018 4,868 14,694 249,242 140 46 2019 4,878 14,740 242,644 136 45 2020 4,898 15,427 248,957 139 44 2021 4,957 15,578 248,957 138 44 2022 5,294 16,522 241,063 125 40 2023 5,034 15,898 258,972 141 45 2024 5,143 16,218 241,955 129 41 Avg. 140 46 Residential water use, on an acreage basis, was estimated based on parcels with access to water service that were zoned as residential in 2024 and annual residential water use. There are approximately 2,105 acres of land within the existing service area that had access to water service that was classified for residential use. Approximately 241,955,000 gallons of water was Page 68 of 87 Water Supply Service Area Plan • Germantown, WI Foth • 20 used for residential purposes in 2024. On this basis, residential water use is 314 gpad. Due to the large fluctuation of dwelling unit densities in residential land, a conservative design factor of 400 gpad will be used for projecting future residential water. 5.8.2 Multi-Family Water Use Multi-family residential water use includes multiple -dwelling unit buildings serving three (3) or more family units through a single meter. The multi-family residential water use was estimated based on per capita and per acreage basis. The multi-family water use per capita was estimated based on annual multi-family water use and estimated water service area population. A summary of multi-family water use is shown in Table 5-9. A per capita average day water use of 10 gpcd will be used for projecting future multi-family water use. Table 5-9 Multi-Family Water Use Year No. of Customers Est. Water Service Population Annual Water Use (000 gal's) Per Customer (gpd) Per Capita (gpd) 2014 107 14,413 49,317 1,263 9 2015 108 14,602 51,143 1,297 10 2016 108 14,646 49,760 1,262 9 2017 108 14,666 49,659 1,260 9 2018 109 14,694 51,029 1,283 10 2019 110 14,740 50,407 1,255 9 2020 141 15,427 77,153 1,499 14 2021 141 15,578 82,109 1,595 14 2022 145 16,522 55,748 1,053 9 2023 147 15,898 62,921 1,173 11 2024 149 16,218 55,103 1,013 9 Avg. 1,269 10 Multi-family water use, on an acreage basis, was estimated using high density land use areas within the existing service area and 202 4 annual multi-family water use. There are approximately 308 acres of land within the existing service area that is classified for multi-family use. Approximately 55,103,000 gallons of water was used for multi-family purposes in 2024. On this basis, multi-family water use is 489 gpad. A conservative design factor of 500 gpad will be used for projecting future multi-family water use. 5.8.3 Commercial/Business Park Water Use Commercial water use consists of business, not -for-profit organizations, and other institutions (with the exception of governmental) that provide goods or services and that take services for non -residential purposes. Commercial type water uses include chu rches, private schools/colleges/universities, restaurants, gas stations, strip malls, co-ops, etc. The commercial water use was estimated based on per capita and per acreage basis. The commercial water use per capita was estimated based on 2024 annual commercial/business park water use and estimated water service area population. A summary of the Village’s existing commercial/business park water use is shown in Table 5-10. A per capita average day water use of 25 gpcd will be used for projecting future commercial water use. Page 69 of 87 Water Supply Service Area Plan • Germantown, WI Foth • 21 Table 5-10 Commercial/Business Park Water Use Year No. of Customers Est. Water Service Population Annual Water Use (000 gal's) Per Customer (gpd) Per Capita (gpd) 2014 433 14,413 106,747 675 20 2015 451 14,602 121,561 738 23 2016 450 14,646 126,118 768 24 2017 466 14,666 128,166 754 24 2018 455 14,694 128,235 772 24 2019 459 14,740 127,015 758 24 2020 462 15,427 117,846 699 21 2021 465 15,578 117,846 694 21 2022 454 16,522 118,982 718 20 2023 448 15,898 142,259 870 25 2024 470 16,218 123,151 718 21 Avg. 742 22 Commercial/business park water use, on an acreage basis, was estimated using commercial land use areas within the existing service area and 202 4 annual commercial water use. There are approximately 664 acres of land within the existing service area that is classified for commercial use. Approximately 123,151,000 gallons of water w as used for commercial purposes in 2024. On this basis, commercial/business park water use is 507 gpad. A design factor of 550 gpad will be used for projecting future commercial/business park water use. 5.8.4 Industrial Water Use Industrial water users include customers that engage in the manufacturing or production of goods. Industrial water use per customer varies greatly depending on the type of industry. The industrial water use was estimated based on per capita and per acreage basis. The industrial water use per capita was estimated based on 2024 annual industrial water use and estimated water service area population. A summary of industrial water use is shown in Table 5-11. A per capita average day water use of 30 gpcd will be used for projecting future industrial water use. Table 5-11 Industrial Water Use Year No. of Customers Est. Water Service Population Annual Water Use (000 gal's) Per Customer (gpd) Per Capita (gpd) 2014 22 14,413 227,407 28,320 43 2015 22 14,602 247,368 30,805 46 2016 22 14,646 134,939 16,804 25 2017 22 14,666 96,416 12,007 18 2018 22 14,694 144,840 18,037 27 2019 23 14,740 82,754 9,858 15 2020 26 15,427 203,066 21,398 36 2021 26 15,578 203,066 21,398 36 2022 24 16,522 185,523 21,178 31 2023 25 15,898 179,538 19,675 31 2024 25 16,218 108,077 11,844 18 Avg. 19,211 30 Page 70 of 87 Water Supply Service Area Plan • Germantown, WI Foth • 22 Industrial water use, on an acreage basis, was estimated using industrial land use areas within the existing service area and 202 4 annual industrial water use. There are approximately 1,236 acres of land within the existing service area that is classified for industrial use. Approximately 108,077,000 gallons of water w as used for industrial purposes in 2024. On this basis, industrial water use is 239 gpad. Due to the large fluctuation in potential water use for an industry, a conservative design factor of 500 gpad will be used for projecting future industrial water use. 5.8.5 Public Water Use Public (Government/Institutional) water users include customers that are agencies of local, state, or federal government, or a local, state, or federal entity. Public water users also include public schools. Public water use was estimated based on per capita and per acreage basis. The public water use per capita was estimated based on 2024 annual public water use and estimated water service area population. A summary of public water use is shown in Table 5-12. A per capita average day water use of 5 gpcd will be used for projecting future public water use. Table 5-12 Public Water Use Year No. of Customers Est. Water Service Population Annual Water Use (000 gal's) Per Customer (gpd) Per Capita (gpd) 2014 23 14,413 7,952 947 2 2015 19 14,602 8,372 1,207 2 2016 23 14,646 8,877 1,057 2 2017 23 14,666 10,556 1,257 2 2018 23 14,694 9,215 1,098 2 2019 23 14,740 9,788 1,166 2 2020 23 15,427 8,084 963 1 2021 25 15,578 8,084 886 1 2022 33 16,522 11,925 990 2 2023 24 15,898 11,217 1,280 2 2024 34 16,218 9,950 802 2 Avg. 1,059 2 Public water use, on an acreage basis, was estimated using public land use areas within the existing service area and 202 4 annual public water use. There are approximately 467 acres of land within the existing service area that is classified for public use. Approximately 9,950,000 gallons of water w as used for public purposes in 2024. On this basis, public water use is 58 gpad. A conservative design factor of 100 gpad will be used for projecting future public water use. 5.9 Summary of Design Factors Demand design factors developed in the previous sections are summarized in Tables 5- 13, 5-14, and 5-15. These factors are used for determining the design demands used to evaluate the required capacities of the proposed supply and storage facilities. Future developments will need to be evaluated to ensure their water use falls within the design criteria. Further evaluations Page 71 of 87 Water Supply Service Area Plan • Germantown, WI Foth • 23 will be required if a development exceeds these design factor s to ensure that the Village can provide adequate service. Table 5-13 Design Demand Rates Demand Parameter Value Maximum Day to Average Day Ratio 2.00 Percent of Non-Revenue Water 15% Table 5-14 Ultimate Water Use Design Factors per Acre User Classification Average Day Value, gpad Residential 400 Multi-Family Residential 500 Commercial/Business Park 550 Industrial 500 Public 100 Table 5-15 Ultimate Water Use Design Factors per Capita User Classification Average Day Value, gpcd Maximum Day Value, gpcd Residential 50 100 Multi-Family Residential 10 20 Commercial/Business Park 25 50 Industrial 30 60 Public 5 10 Total Sales 120 240 Non-Revenue (15%) 18 36 Total Water Use 138 276 5.10 Design Water Demands The existing design demand based on existing water use discussed in the previous sections are summarized in Table 5-16. The proposed design demands anticipated in 2035 were developed based on the design demand factors and land use information obtained from the 2050 Comprehensive Plan. The addition al demands anticipated in 20 35, based on land use classification provided by the Village , are summarized in Table 5-17. The future 2035 water system design demands are summarized in Table 5-18. Page 72 of 87 Water Supply Service Area Plan • Germantown, WI Foth • 24 Table 5-16 Existing Design Demands Demand Criteria Existing Design Demands Combined System Primary & Low/Reduced Pressure Zone High/Boosted Pressure Zone (mgd) (gpm) (mgd) (gpm) (mgd) (gpm) Average Day Demand 2.10 1458 1.85 1285 0.25 174 Max. Day Demand 4.20 2917 3.70 2569 0.50 348 Peak Hour Demand 5.67 3938 4.99 3468 0.68 469 Table 5-17 2035 Design Demands Classifications Classification 2035 Planning Period Add'l Dev. Acres Design Factor (gpad) Water Demand (gpd) Low Density Residential 153 400 61,000 Medium Density Residential 0 400 0 High Density Residential 248 500 124,160 Residential Farmstead & Agriculture (52) 0 0 Mixed Use 878 550 482,829 Commercial (5) 550 (2,778) Governmental/Institutional (10) 100 (1,040) Industrial 237 500 118,260 Park Open Space 0 0 0 Average Day Water Use, gpd 782,431 Non-Revenue Water (15%), gpd 117,365 Total Average Day Demand, gpd 899,796 Total Maximum Day Demand, gpd 1,799,591 Table 5-18 2035 Design Demands Demand Criteria 2035 Design Demands Combined System Primary & Low/Reduced Pressure Zone High/Boosted Pressure Zone (mgd) (gpm) (mgd) (gpm) (mgd) (gpm) Average Day 3.01 2,091 2.23 1,549 0.78 542 Max. Day Demand 6.02 4,182 4.46 3,098 1.56 1,084 Peak Hour Demand 8.13 5,645 6.02 4,182 2.11 1,463 6. Supply and Storage Analysis Reliable supply and storage capacity evaluations were performed to determine if the existing water system could adequately serve the projected 20 35 demand requirements of the Village of Germantown . The reliable supply and storage capacity evaluations and the design criteria used for this evaluation are summarized in the following sections. Page 73 of 87 Water Supply Service Area Plan • Germantown, WI Foth • 25 6.1 Reliable Supply Capacity Evaluation The minimum reliable supply capacity for the combined system and individual pressure zones should equal the maximum day demand with the largest source of supply out -of-service. This will allow pumping units or treatment systems to be taken out -of-service for repair and still enable the utility to meet demand requirements. This will also allow supply facilities to replenish storage facilities during off-peak hours while depletion of available storage occurs during peak demand hours. As previously mentioned, no well s are located in the Low/Reduced Pressure Zone. The sole source of supply for the Low/Reduced Pressure Zone is the Primary Pressure Zone. As a result, for the purposes of this Plan, water demands within the Low/Reduced Pressure Zone are included in the Primary Pressure Zone capacity evaluations. For the Village of Germantown, two (2) criteria were evaluated to determine the reliable supply capacity of the combined system, as well as each individual pressure zone. The t wo (2) criteria included: ◆ Raw water (well) supply capacity. ◆ Interzone transfer capacity. The raw water well supply capacity is the capacity of the existing supply sources (wells) to supply water from the aquifer to the distribution system. For the purposes of this Plan, the individual well reliable capacity will be considered as 100 percent of the design capacity of the well when operating 24 hours per day. The total reliable raw water supply capacity for the system/pressure zone is the sum of the individual well’s reliable capacity less the largest well. The interzone transfer capacity is the capacity of the transfer pumps and/or flow control valves to deliver water from one pressure zone to another pressure zone . The capacity of the transfer pumps is based on several factors including: ◆ Available capacity in the source pressure zone. ◆ Capacity of the transfer pumps and flow control valves. ◆ Supply and discharge main capacity. ◆ Station operation. For the Village of Germantown’s Goldendale Booster Station, the transfer capacity from the Primary Pressure Zone to the High /Boosted Pressure Zone is limited by the supply main capacity of 2,300 gpm and operation of the booster station. The booster station only allows for either the pitless pump or the transfer pumps to operate at one time. A summary of criteria used to determine the reliable supply capacity of each pressure zone and combined system is shown in Table 6-1. As shown in Table 6-1, the Village of Germantown’s combined system reliable capacity is 6.16 mgd. The combined systems’ reliable capacity is limited by the largest well, Well No. 7, being out-of-service. The Primary and Low/Reduced Pressure Zones reliable capacity is 5.00 mgd. The Primary and Low/Reduced Pressure Zones reliable capacity is also limited by the largest well, Well No. 7, being out-of-service. The High/Boosted Zone’s 2035 maximum day demand exceeds Page 74 of 87 Water Supply Service Area Plan • Germantown, WI Foth • 26 Table 6-1 Existing Reliable Supply and System Capacity Evaluation Description Combined System Capacity Main & Low/Reduced Pressure Zone Capacity High/Boosted Pressure Zone Capacity (gpm) (MGD) (gpm) (MGD) (gpm) (MGD) Raw Water Supply (Wells) Well 2 500 0.72 500 0.72 Well 3 700 1.01 700 1.01 Well 4 425 0.61 425 0.61 Well 5 1,100 1.58 1,100 1.58 Well 7 1,200 1.73 1,200 1.73 Well 11 750 1.08 750 1.08 Well 12 800 1.15 800 1.15 Interzone Transfer Capacity Goldendale Transfer Pump 1 850 1.22 Goldendale Transfer Pump 2 850 1.22 Goldendale Pitless Transfer Pump 2,300 3.31 Goldendale Flow Control Valve 1,700 2.45 Criteria 1 – Raw Water Supply Capacity Total Well Supply Capacity 5,475 7.88 4,675 6.73 800 1.15 Less: Largest Well Supply Unit 1,200 1.73 1,200 1.73 800 1.15 Reliable Raw Water Supply Unit 4,275 6.16 3,475 5.00 0 0.00 Criteria 2 – Interzone Transfer Capacity Total Booster Pump Capacity 4,000 5.76 Less: Largest Booster Pump Unit 2,300 3.31 Reliable Transfer Pump Supply 1,700 2.45 Reliable Interzone Transfer Capacity 0 0 1,578 2.27 RELIABLE SUPPLY CAPACITY 4,275 6.16 3,475 5.00 1,578 2.27 the total well capacity in the High/Boosted Zone, so there is no additional capacity for the transfer valve to supply water from the High/Boosted Zone to the Primary Zone. The High/Boosted Pressure Zones reliable capacity is 2.27 mgd. The High/Boosted Zones reliable capacity is limited when the only well in the High/Boosted Zone, Well No. 12, is out-of- service; however , the service pumps at the Goldendale Booster Station allow water to be transferred from the Primary and Low/Reduced Pressure Zones to the High/Boosted Pressure Zone. The allowable transfer capacity was determined to be the difference between the Primary and Low/Reduced Pressure Zones supply capacity and the Pr imary and Low/Reduced Zones 2035 maximum day demand. A recommended reliable capacity evaluation was performed to ensure the reliable supply capacities could meet the projected 2035 water demands. The results of the evaluation are shown in Table 6-2. As shown, the Village currently has adequate supply capacity to meet the projected 2035 demands in the combined system and each pressure zone individually. Page 75 of 87 Water Supply Service Area Plan • Germantown, WI Foth • 27 Table 6-2 2035 Recommended Reliable Capacity Evaluation Criteria Combined System Primary and Low/Reduced Pressure Zone High/Boosted Pressure Zone Total Average Annual Pumpage (MGY) 1,099 814 285 Average Day Pumpage (MGD) 3.01 2.23 0.78 (Gallons Per Minute) 2,091 1,549 542 Design Maximum Day Pumpage (MGD) 6.02 4.46 1.56 (Gallons Per Minute) 4,182 3,098 1,084 Existing Reliable Supply Capacity (MGD) 6.16 5.00 2.27 (Gallons Per Minute) 4,275 3,475 1,578 Additional Reliable Supply Capacity Required (gpm) None None None Note: Design Maximum Day Pumpage is based upon a Maximum Day Demand Factor of 2.00. 6.2 Water Storage Facilities Design Criteria Elevated storage provides water for fire protection, peak demand periods use, and operational flexibility for water supply facilities. Operating storage is required to provide a control range to stop and start pumping equipment. Equalizing (peak hour) st orage furnishes the increments of demand which exceed the capacity of the supply facilities. Firefighting reserve furnishes the increments of demand imposed during a firefighting period that exceeds the capacity of the supply facilities. It is anticipated that the peak hour demands and reliable supply capacities will change as the community grows and water supply improvements are implemented. The fire protection requirements may change dependent on the specific development requirements. To assure a reliable supply for fire protection, this portion of storage should be reserved for emergency use only and should not be utilized to meet peak hour or operation requirements. The criteria used to determine the optimum storage volume for this plan are as follows: ◆ As a minimum, the reliable supply capacity should equal the projected maximum day supply requirements. ◆ The total available storage should be capable of meeting demands in excess of the maximum day demand, as well as fire protection needs. It is possible to reduce required storage volumes if there are excessive supply capacities within the system or if it is possible to transfer water from one pressure zone to another pressure zone. The following criteria may be used to offset storage requi rements when reliable pumping/supply capacity exceeds maximum day demands: ◆ Peak Hour Storage: The reliable pumping capacity in excess of the maximum day demand requirement may be utilized to offset peak hour equalization storage. ◆ Fire Protection Storage: Reliable pumping capacity in excess of the peak hour demand requirement may offset the required fire protection storage needed for the duration of the maximum fire flow requirement for the pressure zone. Page 76 of 87 Water Supply Service Area Plan • Germantown, WI Foth • 28 If an automatic control valve (s) exists that allows water to be transferred from a higher pressure zone to a lower pressure zone, the available storage in the higher pressure zone less the sum of the peak hour equalization storage and the operations storage may offset the fire protection storage requirement in the lower pressure zone based upon the available rate of water transfer when assuming a fire at the most hydraulically remote location in the lower pressure zone with the largest contributing control valve out-of-service. The supply and storage analysis for the Village was completed based on the methodology described above and the following design criteria: Operating Storage: Approx. 30% of gross storage or top 10 feet of tanks. Peak Hour Equalization Storage: As calculated based on a typical diurnal curve. Fire Flow Storage: Primary Pressure Zone: 3,500 gpm for 3 hours (630,000 gallons), as determined by the Village Fire Department. High/Boosted Pressure Zone: 2,500 gpm for 3 hours (450,000 gallons), from previous recommendations. 6.3 Water Storage Facilities Evaluation The results of the storage evaluation are summarized in Table 6-3. As shown and mentioned previously, the Village water system has adequate reliable supply capacity to meet the projected 2035 maximum day demands. The optimum storage requirements are shown in Table 6-3. The optimum storage requirements for the combined system, Primary and Low/Reduced Pressure Zone s, and High/Boosted Pressure Zone are 2,079,000 gallons, 1, 744,000 gallons, and 780,000 gallons, respectively. Based on the existing storage volume and available transfer capacity, the existing storage will be adequate in the Primary Pressure Zone and inadequate in the High/Boosted Pressure Zone in meeting the projected 2035 water demands. As a result, the Village will need to begin evaluating options to either provide additional storage in this zone or provide additional supply to offset storage requirements. 7. WSSAP Recommendations As part of this plan, water system recommendations are provided to ensure the Village can adequately provide water service to its customers over the next 10 years. It should be noted that the recommendations of this Plan are solely directed to sources of supply such as wells, surface water intakes, and connections to neighboring communities. This plan does not provide recommendations for additional or redundant transmission or supply mains. While potential deficiencies with elevated storage and transmiss ion mains are noted in the supply capacity evaluation, further discussion will be required confirming the Village’s design criteria prior to recommending these improvements. Based on the supply analysis presented in the previous sections, the Village will have sufficient supply through the 10-year planning period. However, at the end of the planning period, the Combined System reliable supply capacity will be at approximately 98%. In addition, the Page 77 of 87 Water Supply Service Area Plan • Germantown, WI Foth • 29 Table 6-3 Reliable Supply and Storage Analysis based on Projected 2035 Demands Criteria Combined System Primary and Low/Reduced Pressure Zone High/Boosted Pressure Zone SUPPLY 2035 Supply Requirements Design Average Day Demand (gpm) 2,091 1,549 542 Design Maximum Day Demand (gpm) 4,182 3,098 1,084 Design Peak Hour Demand (gpm) 5,645 4,182 1,463 Present/Proposed Reliable Supply Capacity (gpm) (1) 4,275 3,475 1,578 Reliable Supply Capacity Excess or (Deficiency) (gpm) 93 377 494 STORAGE 2035 Storage Requirements Peak Hour Equalizing Requirements (gallons) (2) 752,000 557,000 190,000 Optimum Fire Protection Needs (gallons) (3) 630,000 630,000 450,000 Operating/Reserve Storage (gallons) (4) 696,100 556,300 139,800 Total Optimum Storage Requirements (gallons) 2,079,000 1,744,000 780,000 Available Effective Storage Capacity (gallons) Tower #1 (327,800 gallons peak hour; 172,200 fire flow) 500,000 500,000 Tower #2 (327,800 gallons peak hour; 172,200 fire flow) 500,000 500,000 Tower #3 (613,100 gallons peak hour; 386,900 fire flow) 1,000,000 1,000,000 Tower #4 (491,700 gallons peak hour; 8,300 fire flow) 500,000 500,000 Total Effective Storage Capacity (gallons) (5) 2,390,400 1,898,700 500,000 Subtotal Capacity Required (gallons) None None 280,000 Credit for Excess Available Reliable System Supply Capacity for Peak Hour (6) 581,000 506,000 190,000 Credit for Excess Available Reliable System Supply Capacity for Fire Protection (7) None None 20,750 Credit for Available FCVs Transfer Capacity for Fire Protection (8) NA 306,000 NA Credit for Available Sporleder Road Booster Station Service Pumps (9) NA NA 22,000 Subtotal of Available Storage and Offsetting Excessive Supply Capacity (Gallons) 581,000 812,000 232,750 Total Storage Capacity Excess or (Deficiency) (Gallons) 581,000 812,000 47,250 1. Reliable Supply Capacities from Table 6-1. 2. Peak hour storage is storage required to meet demands which exceed the maximum day demand rate assuming the reliable supply c apacity is equal to the maximum demand rate. 3. Optimum fire protection based on 3,500 gpm for 180 minutes for the Primary Pressure Zone and 2,500 gpm for 180 minutes for the High/Boosted Pressure Zone . 4. Reserve storage is the storage requirement to provide a start/stop range for pump operation and emergency reserve supply. Ba sed on a SCADA Operating Range of 10 feet to the Overflow. 5. Total effective storage capacity is limited to a total of the optimum fire protection needs plus peak hour available storage. 6. Supply capacity credit cannot exceed peak hour equalization and is calculated utilizing the time -of-day demand curve and current supply capacity. 7. Supply capacity cannot exceed fire protection needs and is calculated as the reliable supply capacity in excess of the peak h our demand x 180 minutes. 8. Available credit when reliable supply capacity exceeds the maximum day demand in the High/Boosted Pressure Zone. Credit is based on three hours of supply and cannot exceed transfer valve capacity. 9. Available credit when reliable supply capacity exceeds the maximum day demand in the Primary Pressure Zone. Credit is based on three hours of supply and cannot exceed booster pump capacity. High/Boosted Pressure Zone would have a supply deficit in the event of failure of the Goldendale Booster Station supply or discharge main. For these reasons, and to offset storage deficiencies and be ready should a high usage customer connect to the water system, Foth recommends the Village continue planning for an additional well. Future deep well sites have been identified in the Primary Pressure Zone and High/Boosted Pressure Zone. The location of the well will be further Page 78 of 87 Water Supply Service Area Plan • Germantown, WI Foth • 30 evaluated based on future development trends. The following sections provide summaries of source water alternatives, and environmental and economic impacts associated with future wells. 7.1 Previously Recommended Sources of Supply The Village is currently planning for a future well in the High/Boosted Pressure Zone , a future well in the Primary Pressure Zone, and a future elevated storage tank in the High/Boosted Pressure Zone. Well Station No. 12 has been designed to accommodate a future expansion to house water treatment facilities required for a deep sandstone well. A rea for a future well site west of Interstate ‘41’ in the Primary Pressure Zone has also been identified in a recently approved development plan. The Village does not have a site selected for the future elevated tank. It is anticipated that the tank will be located in the vicinity of Interstate ‘41’ on the south side of the High/Boosted Pressure Zone. A schematic of the recommended water system is shown in Figure 7-1. With the addition of these wells and elevated storage tank, the Village will have excess supply and storage capacity over the planning period of the WSSAP. 7.2 Alternate Source Evaluation Alternative sources were previously evaluated. SEWRPC prepared a Regional Water Supply Plan for Southeastern Wisconsin in December of 2010 (Report Number 52). The plan included recommendations on the sources of supply for municipalities located within Southeastern Wisconsin. The plan recommended that the V illage of Germantown convert from using groundwater wells to surface water from Lake Michigan. This recommendation was made to allow the deep aquifer to recover, reduce chloride discharges to surface w aters, improve impacts on stream flows, preserve groundwater for other sources, and use available excess production capacity at the Milwaukee Water Works. The Village is aware of the recommendation but is not planning to convert at this time due to the complexity and cost associated with the conversion. As a result, the Village is planning to construct additional groundwater well s when required. A Niagara Aquifer well site investigation was performed in the vicinity of the previously recommended Primary Pressure Zone well site located west of Interstate ‘41’. Results of the investigation indicated that a Niagara well would impact neighboring private wells. To eliminate these concerns, a deep Sandstone Aquifer well was recommended for that location. To avoid interfering with the existing Niagara Aquifer well, any future well on the Well No. 12 site would also be required to be a deep Sandstone Aquifer well. 7.3 Recommended Alternative The deep Sandstone Aquifer wells are estimated to yield between 800 and 1,000 gpm based on similar wells in the Village of Germantown. The proposed well sites are not in close proximity to other municipal wells so they are not anticipated to negatively im pact other well yields. However, prior to moving forward with any new wells, it is recommended that a preliminary well impact assessment be completed to determine expected potential interference between all municipal and other high-capacity wells in the area. Water quality concerns of deep Sandstone Aquifer wells in the vicinity of Germantown primarily include radium and iron. It is anticipated that treatment for one or both of these will be required with the proposed wells. Page 79 of 87 WATER SYSTEM SYMBOL LEGEND Groundwater Well Raw Water Main Flow Control Valve Service Pump Flow Direction Pitless Booster Pump Elevated Storage Tank Municipal Boundary Pressure Zone Boundary Water Treatment Facilities Isolation Valve WTF WELL NO 11 WELL NO. 2 WELL NO. 5 WELL NO. 7 WELL NO. 4 WELL NO. 3 WELL NO. 12 MENOMONEE RIVER 41 41 45 175 145 LOW/REDUCED PRESSURE ZONE PRIMARY PRESSURE ZONE HIGH/BOOSTED PRESSURE ZONE 45 GOLDENDALE BOOSTER STATION 167 45 167 145 WTF FIGURE 7-1 RECOMMENDED WATER SYSTEM SCHEMATIC VILLAGE OF GERMANTOWN WATER SUPPLY SERVICE AREA PLAN WTF TOWER NO. X VOL. MG HWL EL = X,XXX' Normally Closed Note: Distribution system shown is a generic representation of the actual water system and does not reflect actual location of the mains. TOWER NO. 3 1.0 MG HWL EL = 1,040' TOWER NO. 2 0.50 MG HWL EL = 1,040' TOWER NO. 1 0.50 MG HWL EL = 1,040' TOWER NO. 4 0.50 MG HWL EL = 1,100' FUTURE WELL FUTURE WELL FUTURE EST FUTURE WTF FUTURE WTF Page 80 of 87 Water Supply Service Area Plan • Germantown, WI Foth • 32 7.4 Environmental Impact It is not anticipated that deep Sandstone Aquifer wells will have a negative environmental impact on the surrounding area. The Sandstone Aquifer well in the vicinity of Germantown is confined by the Maquoketa Shale. As a result, the wells will not be hy draulically connected to surface waters and will not impact local surface water, wetlands, or flood plains. 7.5 Economic Impact The economic impact of the future sources of supply is highly dependent on water quality and site constraints. For planning purposes, it can be estimated that construction of a future well, well station, and required treatment facilities will be between $3 -$5 million per well. 7.6 Public Participation The Village shall undertake a public participation process to discuss the WSSAP. This will include: ◆ Public notice of the proposed plan. ◆ A minimum of one public hearing on the proposed plan. ◆ Opportunity to provide written comment on the proposed plan. Comments and responses from the public hearing will be included in Appendix B. 7.7 WSSAP Updates The Village shall, at a minimum, review the Water Supply Service Area Plan every 5 years and update the Plan every 10 years. Changes in water use and population shall be monitored by the Village to assess the need to update the plan. Page 81 of 87 Water Supply Service Area Plan • Germantown, WI Foth Appendix A 2014 – 2024 Top 10 Water Users Page 82 of 87 Client: Village of Germantown Title: Appendix A 2014 - 2024 Top 10 Water Users Date: December 2025 Customer Name Yearly Ranking 000's Gal Sold Yearly Ranking 000's Gal Sold Yearly Ranking 000's Gal Sold Yearly Ranking 000's Gal Sold Yearly Ranking 000's Gal Sold Yearly Ranking 000's Gal Sold Yearly Ranking 000's Gal Sold Yearly Ranking 000's Gal Sold Yearly Ranking 000's Gal Sold Yearly Ranking 000's Gal Sold Yearly Ranking 000's Gal Sold GEHL GUERNSEY FARMS 1 163611 1 181696 1 44,607 1 37,098 1 79,169 1 23,884 1 143,121 2 95,994 1 127,388 1 89,655 - - DSM FOOD SPECIALTIES 2 14812 2 15287 2 17,260 2 16,578 2 19,789 2 17,537 2 16,476 1 919,806(a) 2 15,269 3 13,773 2 16,407 DSM FOOD SPECIALTIES (METER 2) 3 11384 6 7290 5 7,861 5 7,559 4 8,613 5 7,644 5 7,247 5 8,700 4 7,043 6 6,372 7 7,600 FIRST CHOICE INGREDIENTS 4 7858 3 8895 3 9,576 8 5,936 6 6,852 6 7,004 6 7,017 7 6,537 6 6,109 8 5,836 5 8,480 STERLING PHARMA SOLUTIONS 5 7726 5 7305 7 5,515 9 4,345 10 3,613 8 4,100 10 4,675 8 4,961 9 5,088 8 7,402 MISTER CAR WASH 6 6663 4 7698 6 7,329 4 8,243 3 11,667 3 9,298 3 8,625 3 10,094 - - - - - - SUNLITE PLASTICS W 7 5080 7 5885 9 5,065 6 6,545 5 8,505 8 5,704 7 5,403 8 6,379 5 6,372 7 5,757 3 10,059 WEST ROCK W 8 5070 8 5861 10 4,862 9 5,255 7 5,315 7 6,696 4 8,023 4 9,719 3 9,437 4 10,143 6 8,359 MGS GROUP NORTH 9 4821 - - - - - - - - - - - - - - - - - - - - STEIN'S GARDEN CENTER 10 3039 - - - - - - - - - - - - - - - - - - - - STERLING PHARMA SOLUTIONS (METER 2) - - 9 5445 8 5,092 - - - - - - - - - - - - 10 4,784 - - GKN SINTER METALS - - 10 4309 4 9,198 7 5,950 - - 4 7,710 9 4,004 - - 9 4,287 - - - - CHRIS JUREWICZ W - - - - - - 3 10,061 - - - - - - - - - - - - - - GEHL GUERNSEY FARMS (METER 2) - - - - - - 10 4,534 10 4,258 9 3,649 - - - - - - - - - - MGS GROUP NORTH - - - - - - - - 8 4,387 - - - - - - - - - - - - L T HAMPEL - - - - - - - - - - - - 10 3,845 9 4,963 7 5,336 - - - - GLENN & KRISTINE - - - - - - - - - - - - - - 6 8,587 - - - - FAIRWAY KNOLL N - - - - - - - - - - - - - - - - 10 4,139 - - 9 4,314 G & H PETS LLC(b) - - - - - - - - - - - - - - - - - - 2 26,820 1 86,470 HILLTOP HIGHLANDS/BROOKSIDE - - - - - - - - - - - - - - - - - - 5 9,429 4 8,711 GERMANTOWN HIGH SCHOOL - - - - - - - - - - - - - - - - - - - - 10 4,042 Average Top 10 Annual Sales (000's Gal) 230,064 249,671 116,365 107,759 152,900 92,739 207,861 155,648 190,341 177,657 161,844 151,457 Total Annual Sales (000's Gal) 656,303 698,737 582,434 539,912 582,561 512,608 655,106 740,013 613,236 654,907 538,236 602,113 Top 10 % of Total Annual Water Sales 35% 36% 20% 20% 26% 18% 32% 21% 31% 27% 30% 25% (a) The reported value for DSM FOOD SPECIALTIES for the year 2021 was ommited as an outlier due to this value being a result of a major water leak. (b) G & H Pets, LLC’s meter was replaced in 2025 due to inaccurate readings. Amount sold in 2024 was estimated based on 4th quarter readings from 2025. 20152014 2022 2023 2024 2016 2017 2018 2019 2020 2021 Page 83 of 87 Water Supply Service Area Plan • Germantown, WI Foth Appendix B Public Review Comments Page 84 of 87 Public Comments Germantown WI V\NR 854 Water Supply Service Area Plan\Report\_Appendices\Appendix B - Public Hearing Comments.docx Page 1 of 2 Village of Germantown Water Service Area Plan Public Hearing Project ID: 25G018.03 Public Hearing ____/____/20____, Start Time ___:___ a.m./p.m. to End Time ___:___ a.m./p.m. NAME PHONE NUMBER(S) COMMENTS RESPONSE Page 85 of 87 Public Comments Germantown WI V\NR 854 Water Supply Service Area Plan\Report\_Appendices\Appendix B - Public Hearing Comments.docx Page 2 of 2 NAME PHONE NUMBER(S) COMMENTS RESPONSE Page 86 of 87 BUSINESS OF THE UTILITY ADVISORY COMMITTEE MEETING DATE: January 28, 2026 PLACEMENT: Presentation ITEM TITLE: Requirements for the installation of deduct meters (DISCUSSION) SUBMITTED BY: Matthew Mortwedt, Public Works Director SUMMARY EXPLANATION: Staff will discuss the regulations surrounding the requirement that certified plumbers install deduct meters for water utility customers. ATTACHMENT: STAFF RECOMMENDATION: ACTION BY COMMITTEE: Page 87 of 87