Public Works Committee

1 VILLAGE OF WATERFORD PUBLIC WORKS & UTILITIES COMMITTEE July 19th, 2021, 4:00 pm DPW Building, 801 Ela Ave. 1. Call to Order 2. Roll Call 3. Comments and Correspondence 4. Public Appearances: 5. Reading and Approval of Min: 06.21.21 PW&U 6. Special Event Permits: 7. Reports: Streets Supervisor, Parks Supervisor, Engineer New Business 1. Discussion on alternate side of the street parking. Ord #207-14; consider an appropriate motion for action. 2. Discussion on sewer rate proposal; consider an appropriate motion for action. 3. Discussion on Ordinance #684-071221, Amending Chapter 207 of the Code of the Village of Waterford to Change the Method of Enforcement of Parking related to the use of the Village’s Boat Launches, Docks, and Other Water Access Facilities. 4. Discussion on upgrading key fob and security system at Village facilities; consider an appropriate motion for action. 5. Discussion on spot repair to the sewer main on Elizabeth St.; consider an appropriate motion for action. 6. Discussion on asphalt patching in Rivermoor subdivision; consider an appropriate motion for action. 7. Discussion on possible change in committee meeting hours. Adjournment Public Notice Questions regarding the nature of the agenda items or more detail on the agenda items listed above scheduled to be considered by the governmental body listed above can be directed to Zeke Jackson, Village Administrator at 262-806-1750 or at zjackson@waterfordwi.org. It is possible that members of and possibly a quorum of members of other governmental bodies of the municipality may be in attendance at the above-stated meeting to gather information; no action will be taken by any governmental body at the above-stated meeting other than the governmental body specifically referred to above in this notice. Upon reasonable notice, a good faith effort will be made to accommodate the needs of disabled individuals through sign language interpreters or other auxiliary aid at no cost to the individual to participate in public meetings. Due to the difficulty in finding interpreters, requests should be made as far in advance as possible preferably a minimum of 48 hours. For additional information or to request this service, contact the Village Staff at 262-534-7912, or by writing to the Village Administrator at the Village Administration Building, 123 N. River St, Waterford WI, 53185 Copies of reports and other supporting documentation are available for review at the Village Administrator’s Office, Administration Building, 123 N. River St, Waterford WI 53185 during operating hours. (8 a.m. – 5 p.m. weekdays). Posted: 7/15/21; 6:30 p.m.  2 1 VILLAGE OF WATERFORD 2 Public Works & Utilities Committee Meeting Minutes 3 Held in Ten Club Park 4 June 21st 2021 5 6 Meeting was called to order by Chair Koeller at 4:00pm 7 8 Present: Mike Baker, Fred Koeller, Pat Goldammer, Carl Oberhardt, Kim Migazzi, Don Houston 9 Others present: Colleen Schauer, Rick Huening, Mike Sponholtz, Zeke Jackson 10 11 Minutes: Motion by Oberhardt to approve the 5-17-2021 minutes. Second by Migazzi. All aye. Motion 12 carried. 13 14 New Business: 15 HVAC: All Pro Mechanical spoke to the work that needs to be done on the Village Hall HVAC system. 16 Motion by Oberhardt to recommend the mechanical work, bearings and control system, that needs to 17 be done on the HVAC system at Village Hall. Second by Houston. All aye. Motion carried. 18 19 Rhoda and Oak: Brett Biwer from Baxter and Woodman spoke to the bids that came in for the 20 reconstruction of Rhoda Drive and Oak Drive. Motion by to recommend to the Village Board the bid 21 from Willkomm Excavating & Grading for the road work needed on Rhoda Drive and Oak Drive 22 eliminating alternate B. Second by Goldammer. All aye. Motion carried. 23 24 AMI; Supervisor Huening gave an update on the status of updating the water meters and AMI system. 25 26 Pool fills: Motion by Houston to not do pool fills. Second by Oberhardt. All aye. Motion carried. 27 28 CCC: Discussion was had on the current Cross Connection Control program. Motion by Oberhardt to 29 reach out to our non-compliant customers. Second by Migazzi. All aye. Motion carried. 30 31 Well Water Solution: Motion by Oberhardt to approve the proposal for preventative maintenance 32 testing on the Village’s water wells and booster pumps from Water Well Solutions. Second by 33 Goldammer. All aye. Motion carried. 34 35 Supervisor Huening gave an update on water restrictions and the DNR noncompliance issues, and the 36 Local Road Improvement Project. 37 38 Ice Rink: Discussion was had on the winter ice rink. 39 40 Motion by Oberhardt to adjourn at 4:54 pm. Second by Goldammer. All aye. Motion carried. 41 42 Respectfully submitted by, 43 Colleen Schauer, PIO  3 VILLAGE OF WATERFORD PUBLIC WORKS AND UTILITY MEETING For additional information: http://www.waterfordwi.org Meeting Date: July 2021 Public works:  Started taking flags down  Crew has been very busy preparing for events  Crew worked with Mike in 10 club cutting trees  Rhoda & Oak starting this week  I have been very busy jumping from project to project going on around the Village Utilities:  Hydrant flushing is completed  Sent out notices to residents on Elizabeth St. educating them on the problems of flushing the so called flushable wipes.  Talked to vender abbot chlorine shortage I’m told that we are fine the manufacture there own product Updates:  AMI  Truck order  Well Water Solution annual maintenance  Advertising new water operator Rick Huening Public Works/Utilities Supervisor Name: i:\1. 2017 agendas\board\2017_04\02a br 2017 bridenhagen.docx Created: 4/13/2017 4:46 PM Printed: 4/14/2017 2:38 PM Author: Robert Kufrin Last Saved By: Zeke Jackson Revision: 2  4 VILLAGE OF WATERFORD PUBLIC WORKS AND UTILITY MEETING Facilities and parks update Meeting Date: July 2021 Facilities -New dry system fire protection pipes have been installed in the attic, waiting on the nitrogen generator to be installed and the system will be up and running again. Design Build fire protection has begun fire protection system inspections at the library as well. -Working on light fixture replacements at the library, many lights in and outside are not working. Removed a large spruce tree growing next to the building and removed a bunch of tall invasive grasses in the drainage swale behind the library. -Hired a new cleaning company to service the village hall and the Seidel building. The people that cleaned for many years have retired. -Working on plumbing repairs at Whitford bathrooms, as well as many other building repairs. -Completing ongoing general repairs, maintenance and organization of all facilities. Parks -Working very hard behind the scenes on the many events going on in the village, Our crew has really been stepping it up and taking pride in these events. Many hours are dedicated to this. -On going and endless work keeping up with Whitford Park. The age of this park is showing badly. Trying to gather support from various organizations to help form a plan. -Removed several dead trees, as well as some weed trees, shrubs and rocks at ten Club Park in preparation for a large Lions club event and Circus event in August. -Completing ongoing mowing,weeding, watering, mulching, spraying and general outside maintenance village-wide. Respectfully submitted, Mike Sponholtz Facilities and parks supervisor.  5 Village of Waterford, WI Tuesday, June 22, 2021 Chapter 207. Traffic and Parking Article II. Parking Regulations § 207-14. All-night parking prohibited; alternate-side parking. [Amended 8-23-2004 by Ord. No. 457; 9-26-2005 by Ord. No. 484, effective 1-1-2006] A. No person shall stop, park or leave standing any vehicle on a state or county trunk highway within the Village between the hours of 2:00 a.m. and 6:00 a.m. B. No person shall stop, park or leave standing any vehicle on any street or alley in the Village which is not a state or county trunk highway between the hours of 2:00 a.m. and 6:00 a.m., except as herein provided: (1) On even-numbered calendar dates, vehicles may be parked on the side of the street adjacent to lots and houses which have been assigned even numbers. On odd-numbered calendar dates, vehicles may be parked on the side of the street adjacent to lots and houses which have been assigned odd numbers. Alternate-side parking rules are determined on the calendar date after 12:00 midnight; e.g.: It is December 3, at 10:00 p.m., and a person does not plan to move his or her vehicle until the next morning; that person would park on the even side of the street because it will be December 4 after midnight, and alternate-side parking is in effect from 2:00 a.m. to 6:00 a.m. (2) Alternate side-parking. [Amended 5-9-2016 by Ord. No. 634] (a) Where alternate-side parking is not available, including but not limited to a cul-de-sac or a block where no parking is allowed on one side of the street at any time, parking during the specified hours shall be allowed on the only available side of the street. (b) Where a street is circular and there are no odd-numbered addresses, the person shall park on the outside (even side) of the circle on even days and the inside of the circle on odd days. (3) Parking of 60 minutes shall be allowed in designated areas in front of all overnight business establishments from 2:00 a.m. to 6:00 a.m., except during snow emergencies. C. This section shall not apply to physicians on emergency calls or other emergency vehicles.  6 Village of Waterford Sewer Fund Rate Increase Proposal June 7, 2021 Draft  7 Village of Waterford Sewer Fund Utility Rate Analysis T ABLE OF CONT ENT S Page Executive summary 1 Exhibit 1 - Projected Revenue Requirement 2 Exhibit 2 - Projected Revenue Required T hrough rates 3 Exhibit 2 - 2019 Predictive Revenue 4 Exhibit 3 - Sewer Operating Expenses 5 Exhibit 4 - Sewer debt Service and Coverage Amount 6 Draft  8 Village of Waterford Executive Summary: 1). Assumes the following debt obligations: 2010 Clean Water fund Loan will be paid off with existing cash 2021 Revenue Bond $2,835,000 at 4% 2). 2021 Operating expenses of $1.487.000, excluding depreciation and tax equivalent 3). Assumes 30 new residential/multi-family customers in 2021 and no other growth in revenue classes 4). Assumed no significant volume changes 5). Assumes no connection fee revenue in 2021 6). Assumes equipment replacement of $25,000 We recommend the following rates be revised to meet the revenue requirements of the utility: Recommended Recommended Current Rates Increase Rates Monthly Fixed Charges: Quarterly Draft 5/8" and 3/4" $67.19 14% $ 76.60 1" $153.93 14% $ 175.48 1 1/4" $224.40 14% $ 255.82 1.5" $292.25 14% $ 333.17 2" $467.06 14% $ 532.45 3" $641.67 14% $ 731.50 4" $1,063.00 14% $ 1,211.82 6" $1,420.45 14% $ 1,619.31 8" $1,826.41 14% $ 2,082.11 Volume Charge (per 100 ccf) $ 6.28 14% $ 7.16 The new rates are subject to the Village's ordinance amendment procedures. The ordinance should be amended by Board action. Average Average Quarterly Quarterly Sewer Sewer Bill Bill Current Recommended Rates Rates Average Residential User 20,000 gal / qtr $ 192.79 $ 219.80 Increase per QTR $ 27.01 1  9 EXHIBIT 1 Village of Waterford Sewer Fund PROJECTED REVENUE REQUIREMENT The revenue requirement of the utility is as follows: Projection At Current Rates With rate Increase Net revenues through user charges $1,434,200 $ 1,635,700 Sewer hook-up fees 75,000 75,000 Interest revenue 7,800 7,800 Subtotal Revenue Requirement $ 1,517,000 $ 1,718,500 Less Operation and maintenance excluding depreciation and tax equivalent (1,376,000) (1,376,000) Less annual replacement funding (25,000) (25,000) Total Net Revenues $ 116,000 $ 317,500 Annual Debt Service $206,500 $206,500 Coverage Ratio Required 125% 125% Required Revenue requirement $ 258,100 $ 258,100 Amount Above (Below) Revenue Requirement $ (142,100) $ 59,400 Draft 2  10 EXHIBIT 2 Village of Wate rford Se we r Fund PRO JECTED REVENUE REQ UIREMENT T he revenue requirement of the utility is as follows: 2022 Projection Operating Expenses - Exh.2 $ 1,376,000 Replacement Fund 25,000 Debt service requirement 206,500 T ax equivalent 111,000 Subtotal Expenditures $ 1,718,500 Less Interest and Other Revenue 7,800 Less: Sewer Hook-up fee 75,000 T otal Revenue Required through Rates $ 1,635,700 User Charge Revenue Generated $1,434,200 Draft Net (Surplus) Shortfall 201,500 Percent (%) Increase Needed 14.0% 3  11 Exhibit 3 Village of Waterford Sewer Fixed and Usage Charge Revenue 2021 Predictive Revenue Public Residential Commercial Multi-Family Industrial Authority Units Units Units Units Units Total Predictive Volume 89,197 15,213 9,752 2,992 2,623 119,777 Rate Per Gallon $ 6.28 $ 6.28 $ 6.28 $ 6.28 $ 6.28 Predictive Unit Revenues $ 560,200 $ 95,500 $ 61,200 $ 18,800 $ 16,500 $ 752,200 Average No. Average No. of Average No. of Average No. Average No. of Meters Meters Meters of Meters of Meters Meter Size Base Charge Totals 5/8" $67.19 951 79 1 5 1 1,036 3/4" $67.19 1,018 50 17 3 4 1,075 1" $153.93 0 14 11 2 5 21 1 1/4" $224.40 0 0 0 0 0 0 Draft 1 1/2" $292.25 0 6 17 1 0 7 2" $467.06 0 7 5 1 3 11 2 1/2" $0.00 0 0 0 0 0 0 3" $866.25 0 1 0 1 4 6 4" $1,435.05 0 0 0 0 2 2 6" $1,917.61 0 0 0 0 0 0 8" $2,465.65 0 0 0 0 0 0 10" $0.00 0 0 0 0 0 0 12" $0.00 0 0 0 0 0 0 Total Meters 1,969 157 51 13 19 2,158 Fixed Revenues Per Qtr. $ 132,300 $ 16,700 $ 10,200 $ 2,500 $ 8,800 $ 170,500 Annual Fixed Revenues $529,200 $66,800 $40,800 $10,000 $35,200 $682,000 Total Volume Revenue $ 560,200 $ 95,500 $ 61,200 $ 18,800 $ 16,500 $ 752,200 Total Revenues Per Analysis $1,089,400 $162,300 $102,000 $28,800 $51,700 $1,434,200 4  12 Exhibit 4 Village of Waterford Sewer Operating Expenses Actual Actual Budget 2019 2020 2021 Bank Fees $ 1,331 $ 1,281 $ 1,100 Salaries and Wages 176,422 246,513 313,878 Administrative wages 52,095 133,977 141,050 Social Security 12,822 18,270 24,012 Health/Life and Disability 37,685 46,629 60,074 Retirement 11,131 15,330 18,990 Continuing education 1,267 321 1,600 Accounting 8,283 7,500 7,500 Engineering 1,879 3,500 53,000 GIS License Fee - - - Legal 117 - 1,500 Pumping Power 8,175 6,829 7,000 Telephone 1,937 2,427 2,800 Other Repairs 10,522 - 3,000 Collection System Repairs 16,439 9,694 20,000 Lift Station Repairs 8,415 15,947 12,000 Well 4 - 17,118 - Draft IT Expenses - - 10,000 Cell Phone - 917 3,108 Other IT expenses 1,369 7,073 - Digger's Hotline 967 969 750 Regulatory expense 2,288 - - Sewer cleaning 11,394 13,088 12,000 Sewer treatment 607,316 581,866 619,500 Other supplies and expense - - 500 Office supplies and expense 814 932 2,608 Postage 3,238 2,947 3,000 Subscription and dues - - 200 Chemicals sewer treatment - 5,896 5,000 Tools and Equipment - PPE 464 - 1,500 Tools 1,445 - - Other Tools and Equipmnt - 1,549 - Fuel 666 996 2,000 Vehicle Maintenance 3,098 4,485 8,500 Miscellaneous General Expense 2,939 10,245 15,000 sCADA Water 1,061 780 5,000 Insurance 6,777 7,048 7,330 Rents and Leases 7,500 7,500 10,000 Tax Equivalent - - - Uncollectible accounts - - 2,500 Other Conservation and Development 3,562 - - Total operation and maintenance $ 1,003,418 $ 1,171,627 $ 1,376,000 5  13 Exhibit 5 Village of Waterford Sewer Debt Schedule $2,835,000 Total Year MRB Principal & Coverage Coverage 2021 Interest Ratio needed 2021 P I 0.00 0.00 1.25 - 2022 P 95,000.00 I 111,500.00 206,500.00 1.25 258,100 2023 P 100,000.00 I 107,600.00 207,600.00 1.25 259,500 2024 P 105,000.00 I 103,500.00 208,500.00 1.25 260,625 2025 P 105,000.00 I 99,300.00 204,300.00 1.25 255,375 2026 P 110,000.00 I 95,000.00 205,000.00 1.25 256,250 2027 P 115,000.00 I 90,500.00 205,500.00 1.25 256,875 2028 P 120,000.00 I 85,800.00 205,800.00 1.25 257,250 2029 P 125,000.00 I 80,900.00 205,900.00 1.25 257,375 2030 P 130,000.00 Draft I 75,800.00 205,800.00 1.25 257,250 2031 P 135,000.00 I 70,500.00 205,500.00 1.25 256,875 2032 P 140,000.00 I 65,000.00 205,000.00 1.25 256,250 2033 P 145,000.00 I 59,300.00 204,300.00 1.25 255,375 2034 P 155,000.00 I 53,300.00 208,300.00 1.25 260,375 2035 P 160,000.00 I 47,000.00 207,000.00 1.25 258,750 2036 P 165,000.00 I 40,500.00 205,500.00 1.25 256,875 2037 P 170,000.00 I 33,800.00 203,800.00 1.25 254,750 2038 P 180,000.00 I 26,800.00 206,800.00 1.25 258,500 2039 P 185,000.00 I 19,500.00 204,500.00 1.25 255,625 2040 P 195,000.00 I 11,900.00 206,900.00 1.25 258,625 2041 P 200,000.00 I 4,000.00 204,000.00 1.25 255,000 2042 P I 0.00 1.25 - P $ 2,835,000.00 $ - I $ 1,281,500.00 $ 4,116,500.00 6  14 Village of Waterford Sewer Fund Rate Increase Proposal June 7, 2021 Draft  15 Village of Waterford Sewer Fund Utility Rate Analysis T ABLE OF CONT ENT S Page Executive summary 1 Exhibit 1 - Projected Revenue Requirement 2 Exhibit 2 - Projected Revenue Required T hrough rates 3 Exhibit 2 - 2019 Predictive Revenue 4 Exhibit 3 - Sewer Operating Expenses 5 Exhibit 4 - Sewer debt Service and Coverage Amount 6 Draft  16 Village of Waterford Executive Summary: 1). Assumes the following debt obligations: 2010 Clean Water fund Loan 2021 Revenue Bond $2,835,000 at 4% 2). Operating expenses of $1,376,000, excluding depreciation and tax equivalent. These were based on 2021 budget 3). Assumes 30 new residential/multi-family customers in 2021 and no other growth in revenue classes 4). Assumed no significant volume changes 5). Assumes connection fee revenue of $75,000 (30 times $2,500) 6). Assumes equipment replacement of $25,000 We recommend the following rates be revised to meet the revenue requirements of the utility: Recommended Recommended Current Rates Increase Rates Monthly Fixed Charges: Quarterly Draft 5/8" and 3/4" $67.19 19% $ 79.96 1" $153.93 19% $ 183.18 1 1/4" $224.40 19% $ 267.04 1.5" $292.25 19% $ 347.78 2" $467.06 19% $ 555.80 3" $641.67 19% $ 763.59 4" $1,063.00 19% $ 1,264.97 6" $1,420.45 19% $ 1,690.34 8" $1,826.41 19% $ 2,173.43 Volume Charge (per 100 ccf) $ 6.28 19% $ 7.47 The new rates are subject to the Village's ordinance amendment procedures. The ordinance should be amended by Board action. Average Average Quarterly Quarterly Sewer Sewer Bill Bill Current Recommended Rates Rates Average Residential User 20,000 gal / qtr $ 192.79 $ 229.36 Increase per QTR $ 36.57 1  17 EXHIBIT 1 Village of Waterford Sewer Fund PROJECTED REVENUE REQUIREMENT The revenue requirement of the utility is as follows: Projection % At Current Rates With rate Increase Increase Revenues Generated through user charges $1,434,200 $ 1,702,300 18.7% Sewer hook-up fees 75,000 75,000 Interest revenue 7,800 7,800 Subtotal Revenue Requirement $ 1,517,000 $ 1,785,100 Less Operation and maintenance excluding depreciation and tax equivalent (1,376,000) (1,376,000) Less annual replacement funding (25,000) (25,000) Total Net Revenues $ 116,000 $ 384,100 Annual Debt Service $273,064 $273,064 Coverage Ratio Required 125% 125% Required Revenue requirement $ 341,300 $ 341,300 Amount Above (Below) Revenue Requirement $ (225,300) $ 42,800.00 Draft 2  18 EXHIBIT 2 EXHIBIT 2 SEWER FUND PRO JECTED REVENUE REQ UIRED THRO UGH RATES Projection Operating Expenses - Exh.2 $ 1,376,000 Replacement Fund 25,000 Debt service requirement 273,100 T ax equivalent 111,000 Subtotal Expenditures $ 1,785,100 Less Interest and Other Revenue 7,800 Less: Sewer Hook-up fee 75,000 T otal Revenue Required through Rates $ 1,702,300 User Charge Revenue Generated Current Rates $1,434,200 Draft Net (Surplus) Shortfall 268,100 Percent (%) Increase Needed 18.7% 3  19 Exhibit 3 Village of Waterford Sewer Fixed and Usage Charge Revenue 2021 Predictive Revenue Public Residential Commercial Multi-Family Industrial Authority Units Units Units Units Units Total Predictive Volume 89,197 15,213 9,752 2,992 2,623 119,777 Rate Per Gallon $ 6.28 $ 6.28 $ 6.28 $ 6.28 $ 6.28 Predictive Unit Revenues $ 560,200 $ 95,500 $ 61,200 $ 18,800 $ 16,500 $ 752,200 Average No. Average No. of Average No. of Average No. Average No. of Meters Meters Meters of Meters of Meters Meter Size Base Charge Totals 5/8" $67.19 951 79 1 5 1 1,036 3/4" $67.19 1,018 50 17 3 4 1,075 1" $153.93 0 14 11 2 5 21 1 1/4" $224.40 0 0 0 0 0 0 Draft 1 1/2" $292.25 0 6 17 1 0 7 2" $467.06 0 7 5 1 3 11 2 1/2" $0.00 0 0 0 0 0 0 3" $866.25 0 1 0 1 4 6 4" $1,435.05 0 0 0 0 2 2 6" $1,917.61 0 0 0 0 0 0 8" $2,465.65 0 0 0 0 0 0 10" $0.00 0 0 0 0 0 0 12" $0.00 0 0 0 0 0 0 Total Meters 1,969 157 51 13 19 2,158 Fixed Revenues Per Qtr. $ 132,300 $ 16,700 $ 10,200 $ 2,500 $ 8,800 $ 170,500 Annual Fixed Revenues $529,200 $66,800 $40,800 $10,000 $35,200 $682,000 Total Volume Revenue $ 560,200 $ 95,500 $ 61,200 $ 18,800 $ 16,500 $ 752,200 Total Revenues Per Analysis $1,089,400 $162,300 $102,000 $28,800 $51,700 $1,434,200 4  20 Exhibit 4 Village of Waterford Sewer Operating Expenses Actual Actual Budget 2019 2020 2021 Bank Fees $ 1,331 $ 1,281 $ 1,100 Salaries and Wages 176,422 246,513 313,878 Administrative wages 52,095 133,977 141,050 Social Security 12,822 18,270 24,012 Health/Life and Disability 37,685 46,629 60,074 Retirement 11,131 15,330 18,990 Continuing education 1,267 321 1,600 Accounting 8,283 7,500 7,500 Engineering 1,879 3,500 53,000 GIS License Fee - - - Legal 117 - 1,500 Pumping Power 8,175 6,829 7,000 Telephone 1,937 2,427 2,800 Other Repairs 10,522 - 3,000 Collection System Repairs 16,439 9,694 20,000 Lift Station Repairs 8,415 15,947 12,000 Well 4 - 17,118 - Draft IT Expenses - - 10,000 Cell Phone - 917 3,108 Other IT expenses 1,369 7,073 - Digger's Hotline 967 969 750 Regulatory expense 2,288 - - Sewer cleaning 11,394 13,088 12,000 Sewer treatment 607,316 581,866 619,500 Other supplies and expense - - 500 Office supplies and expense 814 932 2,608 Postage 3,238 2,947 3,000 Subscription and dues - - 200 Chemicals sewer treatment - 5,896 5,000 Tools and Equipment - PPE 464 - 1,500 Tools 1,445 - - Other Tools and Equipmnt - 1,549 - Fuel 666 996 2,000 Vehicle Maintenance 3,098 4,485 8,500 Miscellaneous General Expense 2,939 10,245 15,000 sCADA Water 1,061 780 5,000 Insurance 6,777 7,048 7,330 Rents and Leases 7,500 7,500 10,000 Tax Equivalent - - - Uncollectible accounts - - 2,500 Other Conservation and Development 3,562 - - Total operation and maintenance $ 1,003,418 $ 1,171,627 $ 1,376,000 5  21 Exhibit 5 Village of Waterford S ewer Debt S chedule $1,050,807 $2,835,000 Total Year Sewer CWF MRB P rincipal & Coverage Coverage 2011 2021 Interest Ratio needed 2021 P 52,968.33 I 13,610.64 0.00 66,578.97 1.25 83,224 2022 P 54,245.39 95,000.00 I 12,318.17 111,500.00 273,063.56 1.25 341,300 2023 P 55,553.25 100,000.00 I 10,994.56 107,600.00 274,147.81 1.25 342,685 2024 P 56,892.64 105,000.00 I 9,639.02 103,500.00 275,031.66 1.25 343,790 2025 P 58,264.32 105,000.00 I 8,250.79 99,300.00 270,815.11 1.25 338,519 2026 P 59,669.07 110,000.00 I 6,829.11 95,000.00 271,498.18 1.25 339,373 2027 P 61,107.69 115,000.00 I 5,373.15 90,500.00 271,980.84 1.25 339,976 2028 P 62,581.00 120,000.00 I 3,882.08 85,800.00 272,263.08 1.25 340,329 2029 P 64,089.83 125,000.00 Draft I 2,355.07 80,900.00 272,344.90 1.25 340,431 2030 P 65,635.03 130,000.00 I 791.23 75,800.00 272,226.26 1.25 340,283 2031 P 135,000.00 I 70,500.00 205,500.00 1.25 256,875 2032 P 140,000.00 I 65,000.00 205,000.00 1.25 256,250 2033 P 145,000.00 I 59,300.00 204,300.00 1.25 255,375 2034 P 155,000.00 I 53,300.00 208,300.00 1.25 260,375 2035 P 160,000.00 I 47,000.00 207,000.00 1.25 258,750 2036 P 165,000.00 I 40,500.00 205,500.00 1.25 256,875 2037 P 170,000.00 I 33,800.00 203,800.00 1.25 254,750 2038 P 180,000.00 I 26,800.00 206,800.00 1.25 258,500 2039 P 185,000.00 I 19,500.00 204,500.00 1.25 255,625 2040 P 195,000.00 I 11,900.00 206,900.00 1.25 258,625 2041 P 200,000.00 I 4,000.00 204,000.00 1.25 255,000 2042 P I 0.00 1.25 - P $ 591,006.55 $ 2,835,000.00 $ - I $ 74,043.82 $ 1,281,500.00 $ 4,781,550.37 6  22 ORDINANCE NO. 684-071221 Amending Chapter 207 of the Code of the Village of Waterford to Change the Method of Enforcement of Parking related to the use of the Village’s Boat Launches, Docks, and Other Water Access Facilities. The Village Board of the Village of Waterford, Racine County, Wisconsin, do ordain as follows: I. That Chapter 207 of the Code of the Village of Waterford, Racine County, Wisconsin, Parking and Traffic, Section 207-19, Enforcement, is hereby amended as follows: USE OF PARKING, STREETS AND PARKS FOR WATER ACCESS TO LAKE AND RIVER. (1) No person shall launch a motorboat, sailboat, iceboat, canoe, kayak, or an all-terrain vehicle in public parking lot areas in the Village of Waterford without first obtaining a launch access permit and paying the fee for same, which fee shall be established by the DPW Committee. Said permit shall be displayed in or on the launcher's accompanying motor vehicle in such location as designated by the DPW Committee. (2) It shall be unlawful for any person to park, stop or leave standing any vehicle, whether attended or unattended, in any area in a public park in the Village of Waterford that has been designated by order of the DPW Committee as a public parking lot unless said vehicle properly displays the permit required in Subsection (1) above. (3) No person shall launch or dock or remove any watercraft from the lake or river lot between the hours of xxxx p.m. and xxxx a.m. (4) Any person violating any provision of this ordinance shall be subject to a forfeiture of not less than one hundred dollars ($100) nor more than five hundred dollars ($500) with each separate day to be considered a separate offense. II. It is further ordained that this ordinance shall become effective from and after its passage and publication as required by law. All other language as contained in Chapter 207 of the Code of the Village of Waterford shall remain without change and in full force and effect. Introduced: August xx, 2021 Passed and adopted: August xx, 2021 BY ORDER OF THE VILLAGE BOARD Donald Houston, President  23 ATTEST: Rachel Ladewig, Clerk  24 QUOTE From: Mike Fay Date: July 14, 2021 Attn: Mike Sponholtz Customer: Waterford Village Project Type: Access Control Upgrade 801 Ela Ave. Waterford, WI 53185 Thank you for the opportunity of offering this proposal regarding your security concerns. F.I.R.S.T. Security LLC has over 30 years of experience in the security industry. We look forward to providing you with quality service, security, and equipment. Quantity Description Option 1: Upgrade equipment. New software. One software. Link Village Hall, Fire Dept, Library, and DPW thru network for programming. Well 5, Pavilion, and Seidel to be programmed on site directly with same software. 8 PXL500P Master control panels, ( same as existing but with the latest firmware.) ( replace existing ) 8 Keri Power Supplies w/12VDC Batteries, ( separate panel power from lock power ) 4 Lan520 Network Cards ( for Village Hall, Fire Dept, Library, and DPW ) 1 Database Conversion ( convert existing database to the new Doors.Net software ) 1 Tie in existing reader, strikes, and power supplies 1 Labor and Misc. materials Option 1 Cost $11835.00 + Tax Option 2: Separate Fire Dept from the rest of the system. Replace remaining systems with PXL panels with latest firmware. Programming of remaining systems to be completed with a combination of network and on site programming with customer supplied laptop. 6 PXL500P Master control panels, ( same as existing but with the latest firmware.) ( replace existing ) ( replacing DPW, Library, Village Hall, Seidel, Well 5, & Pavilion ) 6 Keri Power Supplies w/12VDC Batteries, ( separate panel power from lock power ) 3 Lan520 Network Cards ( for Village Hall, Library, and DPW ) 1 Tie in existing readers, strikes, and power supplies 1 Software and programming Customer to run network wires to all panels going on network Option 2 Cost $8365.00 + Tax All Permits, Fees and inspections are strictly the responsibility of the customer, Not that of FIRST Security LLC. This quote is good for 30 days. Any changes to the scope of the project may result in a change order. By signing below you accept the terms, materials listed, and all costs shown. Please Initial work requested, add total, sign and Total $ email to MFAY@firstsecurtyllc.net Approved Signature Printed Name Date  25 QUOTE From: Mike Fay Date: July 14, 2021 Attn: Mike Sponholtz Customer: Waterford Village Project Type: Access Control Upgrade 801 Ela Ave. Fire Dept Only Waterford, WI 53185 Thank you for the opportunity of offering this proposal regarding your security concerns. F.I.R.S.T. Security LLC has over 30 years of experience in the security industry. We look forward to providing you with quality service, security, and equipment. Quantity Description Separate Fire Dept from the rest of the system. Upgrade Fire Dept to new NXT Panels Programming of Fire Dept to be run from Fire Dept Computer. 1 NXT 4D Master Control Panel ( replacing existing 2 panels at Fire Dept 4 Keri MS Reader Interface Modules 1 Keri Power Supply w/12VDC Battery, ( separate panel power from lock power ) 1 Tie in existing readers, strikes, and power supplies 1 Software and Programming Customer to run network wires to all panels going on network All Permits, Fees and inspections are strictly the responsibility of the customer, Not that of FIRST Security LLC. This quote is good for 30 days. Any changes to the scope of the project may result in a change order. By signing below you accept the terms, materials listed, and all costs shown. Please Initial work requested, add total, sign and Total $ 3376.00 + Tax email to MFAY@firstsecurtyllc.net Approved Signature Printed Name Date