Utility Commission

AGENDA VILLAGE OF LITTLE CHUTE UTILITY COMMISSION MEETING PLACE: Village of Little Chute – Board Room DATE: Tuesday, April 19, 2022 TIME: 6:00 p.m. Join Zoom Meeting https://us06web.zoom.us/j/85191188726 Meeting ID: 851 9118 8726 One tap mobile +13126266799,,85191188726# US (Chicago) A. Call to Order B. Roll Call C. Public Appearance for Items Not on the Agenda 1. Approval of Minutes Utility Commission Minutes of March 15, 2022 2. Discussion—2021 Annual Report for Public Service Commission (click for link) 3. Progress Reports a. MCO Operations Update b. Director of Public Works c. Finance Director 4. Approval of Vouchers 5. Unfinished Business 6. Items for Future Agenda 7. Adjournment Requests from persons with disabilities who need assistance to participate in this meeting should be made with as much advance notice as possible to the Clerk's Office at 108 West Main Street, (920) 423-3852 Prepared: April 13, 2022  MINUTES OF THE UTILITY COMMISSION MEETING OF MARCH 15, 2022 Call to Order The Utility Commission meeting was called to order at 6:00 P.M. by Kevin Coffey, Chair Roll Call PRESENT: Kevin Coffey, Chair Mark Gloudemans Tom Buchholz Jessica Schultz Michael Vanden Berg ALSO PRESENT: Village Administrator Beau Bernhoft, Director of Public Works Kent Taylor, Finance Director Lisa Remiker-DeWall, Jerry Verstegen, MCO Public Appearance for Items Not on the Agenda None Approval of Minutes from the Utility Commission Meeting of February 15, 2022 Moved by T. Buchholz, seconded by J. Schultz to Approve Minutes from the Utility Commission of February 15, 2022 All Ayes – Motion Carried Progress Reports MCO Operations Update Mr. Jerry Verstegen, MCO updated the Commission on projects and issues in the month of February. Director of Public Works Director Taylor went over the Monthly Utility Report for the month of February. Finance Director Director Remiker-DeWall will have financials out by end of week. Approval of Vouchers Moved by T. Buchholz, seconded by M. Gloudemans to Approve and Authorize payment of Vouchers and draw from the respective funds All Ayes – Motion Carried Discussion of Recent Sanitary Sewer Overflow Commissioner Taylor discussed an overflow that took place on March 7, 2022 near Heesakker Park, east of Garfield. A report has been filed on time, the overflow was caught and taken care of very quickly. Community reach-out will be taking place to raise awareness of the issue and prevent further incidents. Action/Discussion – MS4 Review and Recommendation to the Village Board Commissioner Taylor presented the MS4 Annual Report for 2021. Moved by K. Coffey, seconded by J. Schultz to Recommend and Approve MS4 to Village Board. All Ayes – Motion Carried Unfinished Business None Items for Future Agenda None Adjournment Moved by M. Gloudemans, seconded by T. Schultz to Adjourn the Utility Commission Meeting at 6:11 p.m. All Ayes – Motion Carried VILLAGE OF LITTLE CHUTE By: Kevin Coffey, Chair Attest: Laurie Decker, Village Clerk  Engineering Department & Department of Public Works Monthly Utility Commission Report for March 2022 STREET NOTES: Sanitary Sewer • Employees maintained and read laser meters in the sanitary collection system.. • 12,595 feet of sanitary sewer main were jetted. • Completed modifications to the covered trailer that houses the sanitary sewer camera. Mainline sewer inspections are planned to start in April. • The Village responded to and cleared a sanitary sewer overflow (SSO) on March 7, 2022. The SSO occurred in Heesakker Park approximately 480’ East of the 1300 block of Garfield Avenue. Storm Sewer • New development site plans were reviewed. • Storm water permits were reviewed and managed. • Performed erosion control monitoring and management. • The annual MS4 (Municipal Separate Storm Sewer Systems) annual report was submitted to the WDNR. • Street sweepers were sent out for the first time this year. • Frost depths have been driven deeper this winter, we have experienced frozen mini storm sewers more than usual. Storm Ponds • Invasive animals in the storm ponds are being removed. • Trash racks have been inspected and cleaned. • Weekly inspections of lift pumps have been completed. Water • Nothing to report.  ENGINEERING NOTES: 2022 Utility Projects – March In the month of March, the utilities listed below were installed with the removals also listed. March 2022 - Utility Installation and Abandonements Village of Little Chute - Vandenbroek Pond Construction WATER MAIN Units Installed Abandoned/Removed 8" PVC Water Main L.F. 97.5 97.5 8" Water Valve & Valve Box E.A. 2.0 1.0 SANITARY SEWER Units Installed Abandoned/Removed None N.A. None STORM SEWER Units Installed Abandoned/Removed 15" RCP Storm Sewer Main L.F. 27.7 30" RCP Storm Sewer Main L.F. 72.7 54" RCP Storm Sewer Main L.F. 62.5 5' Diameter - Standard Storm Manhole E.A. 1.0 5' Diameter - Storm Inlet Manhole E.A. 1.0 6' Diameter - Storm Inlet Manhole E.A. 1.0 8' Diameter - Storm Inlet Manhole E.A. 1.0 Pine Street Parking Lot and Pedestrian Mall – This project is currently on hold with a redesign of the project and utilities to be started in April. Pheasant Run Storm Sewer – This project was on hold for the month of March waiting for the WDNR to schedule a meeting to discuss the stream enclosure. Top Priorities for April 2022 Pine Street Parking Lot and Pedestrian Mall – This project is being redesigned due to changes in the project area and scope. Our focus for this project will be to install new sanitary and storm sewers. The water main will have only minor changes. CTH OO Water Main (Bohm to Joyce) – This project was awarded on April 6th and the contract documents were signed by the Village and have been submitted to the Contractor for their signature. Top priority is to obtain the Contractor’s schedule. CTH OO Sanitary Sewer Lining (Lamers to Bohm) – This project was awarded on April 6th and the contract documents were signed by the Village and have been submitted to the Contractor for their signature. Top priority is to obtain the Contractor’s schedule. Pheasant Run Storm Sewer – A meeting is scheduled on April 13th on-site with the WDNR to discuss the stream enclosure permit. This project cannot begin until after fish spawning in the Fox River. Vandenbroek Pond Construction – The utility construction for this pond is scheduled to be completed in early April with the excavation of the pond scheduled to begin on April 20 th. VILLAGE OF LITTLE CHUTE SEWER UTILITY Change BUDGET STATUS 2022 2021 from PY BUDGET ACTUAL ACTUAL Revenue = > MAR YTD REVENUE Multi‐family Residential 220,000 59,551 54,124 10.03% Residential 1,210,000 297,720 301,085 ‐1.12% Commercial 225,000 75,823 49,514 53.13% Industrial 740,000 138,874 136,880 1.46% Public Authority 400,000 11,440 7,901 44.79% Sales Subtotal 2,795,000 583,408 549,504 6.2% % of CY Budget All Other 139,909 (40,841) (5,332) 665.96% TOTAL REVENUE 2,934,909 542,567 544,172 % of CY Budget 18% ‐0.3% 2022 2021 BUDGET ACTUAL ACTUAL Expense = > MAR YTD EXPENSES Financing 250,784 63,708 61,031 4.39% Treatment 2,381,600 555,381 503,052 10.40% Collection 257,412 96,943 45,639 112.41% Billing 144,707 34,267 24,552 39.57% Admin 184,507 55,927 35,096 59.35% TOTAL EXPENSE 3,219,010 806,226 669,370 % of CY Budget 25% 20.4% CASH FLOW ‐OPERATIONS (284,101) (263,659) (125,198) 110.59% ADD: DEPRECIATION 236,000 58,998 55,733 ADD: NEW DEBT ‐ ‐ ‐ LESS: PRINCIPAL PAID (47,132) ‐ ‐ LESS: FIXED ASSETS (242,866) (10,758) (8,041) NET CASH FLOW (338,099) (215,419) (77,506) NOTE : Outagamie County Landfill is billed quarterly so no revenues included for 2022 YTD, GLK Strength for first quarter not billed until April as need labs Continue to see interest and investment income impacted as result of market changes due to COVID‐19. The unrealized losses that exist now will not be recognized if the assets are held until maturity. The Village invests in varying maturities to match cash flow needs. An unrealized loss exists when a longer term asset the Village owns price has declined in the market place due to varying interest rates. Each month end, Generally Accepted Accounting Principles require that we record an unrealized loss (or gain) to recognize market impacts. Property, Auto and Workers Compensation first and second quarter premiums have been paid so six months of expense have occurred Collection expense is up due to sewer camera purchase, MCO spending additional time for billing related to cellular meters and Admin increase due to sewer rate study Administration is up due to rate study in process Reminder that capital assets are shown as expense in utilities until capitalized as part of year end audit preparation along with a few other annual processes  VILLAGE OF LITTLE CHUTE SEWER UTILITY DEBT SCHEDULE 2012A Issue G O 2019 Refunding Sanitary Sanitary Year Principal Interest Total Principal Interest Total 2022 17,684.00 265.27 17,949.27 30,000.00 5,700.00 35,700.00 2023 40,000.00 4,800.00 44,800.00 2024 40,000.00 3,600.00 43,600.00 2025 40,000.00 2,400.00 42,400.00 2026 35,000.00 1,350.00 36,350.00 17,684.00 265.27 17,949.27 185,000.00 17,850.00 202,850.00 TOTAL DEBT Sanitary Year Principal Interest Total 2022 47,684.00 5,965.27 53,649.27 2023 40,000.00 4,800.00 44,800.00 2024 40,000.00 3,600.00 43,600.00 2025 40,000.00 2,400.00 42,400.00 2026 35,000.00 1,350.00 36,350.00 202,684.00 18,115.27 220,799.27 VILLAGE OF LITTLE CHUTE WATER UTILITY Change BUDGET STATUS 2022 2021 from PY BUDGET ACTUAL ACTUAL Revenue = > MAR YTD REVENUE Multi‐family Residential 133,900 35,170 32,531 8.11% Residential 954,100 224,220 223,688 0.24% Commercial 154,500 47,387 34,466 37.49% Industrial 450,000 104,297 105,246 ‐0.90% Private Fire 59,000 15,233 14,523 4.89% Public Fire 424,000 106,605 105,999 0.57% Public Authority 47,000 8,636 8,300 4.05% Sales Subtotal 2,222,500 541,548 524,753 3.2% % of CY Budget 24% All Other 102,076 (7,015) 13,045 ‐153.78% TOTAL REVENUE 2,324,576 534,533 537,798 % of CY Budget 23% ‐0.6% Expense = > MAR YTD 2022 2021 EXPENSES BUDGET ACTUAL ACTUAL Financing 753,841 186,763 177,535 5.20% Wells/Source 16,500 2,422 53,562 ‐95.48% Pumping 271,987 49,340 37,339 32.14% Treatment 475,030 115,909 106,330 9.01% Distribution 655,726 164,109 132,263 24.08% Billing 61,307 13,905 11,734 18.50% Admin 204,858 49,938 43,480 14.85% TOTAL EXPENSE 2,439,249 582,386 562,243 % of CY Budget 24% 3.6% CASH FLOW ‐OPERATIONS (114,673) (47,853) (24,445) 95.75% ADD: DEPRECIATION 520,000 129,999 119,674 ADD: NEW DEBT ‐ ‐ LESS: PRINCIPAL PAID (389,547) ‐ LESS: FIXED ASSETS (214,927) (9,556) (5,175) NET CASH FLOW (199,147) 72,590 90,054 NOTE : Continue to see interest and investment income impacted as result of market changes due to COVID‐19. The unrealized losses that exist now will not be recognized if the assets are held until maturity. The Village invests in varying maturities to match cash flow needs. An unrealized loss exists when a longer term asset the Village owns price has declined in the market place due to varying interest rates. Each month end, Generally Accepted Accounting Principles require that we record an unrealized loss (or gain) to recognize market impacts. Property, Auto and Workers Compensation first and second quarter premiums have been paid so six months of expense have occurred. Pumping was down in 2021 due to time spent with Well # 3, Treatment up in 2022 as working on Well # 4 softener valves, Distribution is up due to cellular meter technology costs and implementation Water Utility makes payment to MCO a month in advance per terms of agreement so additional month hits expense until December when no expense is charged. Reminder that capital assets are shown as expense in utilities until capitalized as part of year end audit preparation along with a few other annual processes  VILLAGE OF LITTLE CHUTE WATER UTILITY DEBT SCHEDULE 2012A Issue 2014A Issue 2017B Issue Water Water Water Year Principal Interest Total Principal Interest Total Principal Interest Total 2022 80,524.00 1,207.85 81,731.85 45,000.00 2,587.50 47,587.50 1,443.63 288.32 1,731.95 2023 45,000.00 1,608.75 46,608.75 1,464.25 245.00 1,709.25 2024 45,000.00 551.25 45,551.25 1,546.74 201.08 1,747.82 2025 1,691.11 154.68 1,845.79 2026 1,711.73 103.94 1,815.67 2027 1,752.96 52.58 1,805.54 80,524.00 1,207.85 81,731.85 135,000.00 4,747.50 139,747.50 9,610.42 1,045.60 10,656.02 2016 Water Revenue 2017 Safe Drinking Bonds 2019A Issue Water Water Water Year Principal Interest Total Principal Interest Total Principal Interest Total 2022 75,000.00 6,237.50 81,237.50 55,982.37 17,534.04 73,516.41 35,000.00 8,950.00 43,950.00 2023 75,000.00 5,037.50 80,037.50 56,967.66 16,540.07 73,507.73 35,000.00 7,900.00 42,900.00 2024 80,000.00 3,720.00 83,720.00 57,970.29 15,528.62 73,498.91 35,000.00 6,850.00 41,850.00 2025 80,000.00 2,280.00 82,280.00 58,990.57 14,499.38 73,489.95 40,000.00 5,800.00 45,800.00 2026 80,000.00 760.00 80,760.00 60,028.80 13,451.99 73,480.79 40,000.00 4,600.00 44,600.00 2027 61,085.31 12,386.19 73,471.50 40,000.00 3,400.00 43,400.00 2028 62,160.41 11,301.63 73,462.04 40,000.00 2,200.00 42,200.00 2029 63,254.43 10,197.98 73,452.41 40,000.00 1,000.00 41,000.00 2030 64,367.71 9,074.91 73,442.62 2031 65,500.58 7,932.06 73,432.64 2032 66,653.39 6,769.11 73,422.50 2033 67,826.49 5,585.69 73,412.18 2034 69,020.23 4,381.43 73,401.66 2035 70,234.99 3,155.99 73,390.98 2036 71,471.13 1,908.98 73,380.11 2037 72,729.02 640.01 73,369.03 390,000.00 18,035.00 408,035.00 1,024,243.38 150,888.08 1,175,131.46 305,000.00 40,700.00 345,700.00 2019 Refunding 2020 Issue TOTAL DEBT Water Water Water Year Principal Interest Total Principal Interest Total Principal Interest Total 2022 50,000.00 7,950.00 57,950.00 50,000.00 7,750.00 57,750.00 392,950.00 52,505.21 445,455.21 2023 50,000.00 6,450.00 56,450.00 55,000.00 6,750.00 61,750.00 318,431.91 44,531.32 362,963.23 2024 55,000.00 4,950.00 59,950.00 55,000.00 5,650.00 60,650.00 329,517.03 37,450.95 366,967.98 2025 55,000.00 3,300.00 58,300.00 55,000.00 4,550.00 59,550.00 290,681.68 30,584.06 321,265.74 2026 55,000.00 1,650.00 56,650.00 55,000.00 3,450.00 58,450.00 291,740.53 24,015.93 315,756.46 2027 55,000.00 2,350.00 57,350.00 157,838.27 18,188.77 176,027.04 2028 60,000.00 1,800.00 61,800.00 162,160.41 15,301.63 177,462.04 2029 60,000.00 1,200.00 61,200.00 163,254.43 12,397.98 175,652.41 2030 60,000.00 600.00 60,600.00 124,367.71 9,674.91 134,042.62 2031 65,500.58 7,932.06 73,432.64 2032 66,653.39 6,769.11 73,422.50 2033 67,826.49 5,585.69 73,412.18 2034 69,020.23 4,381.43 73,401.66 2035 70,234.99 3,155.99 73,390.98 2036 71,471.13 1,908.98 73,380.11 2037 72,729.02 640.01 73,369.03 265,000.00 24,300.00 289,300.00 505,000.00 34,100.00 539,100.00 2,714,377.80 275,024.03 2,989,401.83 VILLAGE OF LITTLE CHUTE STORM UTILITY Change BUDGET STATUS 2022 2021 from PY BUDGET ACTUAL ACTUAL Revenue = > MAR YTD REVENUE Multi‐family Residential 80,000 20,029 20,030 0.00% Residential 356,000 89,226 88,522 0.80% Commercial 495,000 127,516 122,780 3.86% Industrial 155,000 38,415 38,390 0.07% Public Authority 75,000 19,245 18,711 2.85% Sales Subtotal 1,161,000 294,431 288,433 2.1% % of CY Budget 25% All Other 81,220 (69,414) (10,050) 590.69% TOTAL REVENUE 1,242,220 225,017 278,383 % of CY Budget 18% ‐19.2% Expense = > MAR YTD 2022 2021 EXPENSES BUDGET ACTUAL ACTUAL Financing 537,964 132,214 121,668 8.67% Pond Maintenance 146,281 13,115 10,586 23.89% Collection 456,498 30,696 30,672 0.08% Billing 56,685 13,876 11,753 18.06% Admin 230,924 58,396 59,906 ‐2.52% TOTAL EXPENSE 1,428,352 248,297 234,585 % of CY Budget 17% 5.8% CASH FLOW ‐OPERATIONS (186,132) (23,280) 43,798 ‐153.15% ADD: DEPRECIATION 430,000 118,000 109,233 ADD: NEW DEBT ‐ ‐ ‐ LESS: PRINCIPAL PAID (304,500) ‐ ‐ LESS: FIXED ASSETS (667,083) (25,389) (5,770) NET CASH FLOW (727,715) 69,331 147,261 NOTE : Continue to see interest and investment income impacted as result of market changes due to COVID‐19. The unrealized losses that exist now will not be recognized if the assets are held until maturity. The Village invests in varying maturities to match cash flow needs. An unrealized loss exists when a longer term asset the Village owns price has declined in the market place due to varying interest rates. Each month end, Generally Accepted Accounting Principles require that we record an unrealized loss (or gain) to recognize market impacts. Financing is up due to depreciation expense as asset base continues to grow Property, Auto and Workers Compensation first and second quarter premiums have been paid so six months of expense have occurred. Reminder that capital assets are shown as expense in utilities until capitalized as part of year end audit preparation along with a few other annual processes  VILLAGE OF LITTLE CHUTE STORM UTILITY DEBT SCHEDULE 2012A G O Note 2016 Storm Revenue 2010 Clean Water Fund Storm Storm Storm Year Principal Interest Total Principal Interest Total Principal Interest Total 2022 53,132.00 796.98 53,928.98 80,000.00 33,312.00 113,312.00 23,753.78 6,321.76 30,075.54 2023 80,000.00 31,712.00 111,712.00 24,502.73 5,561.01 30,063.74 2024 80,000.00 30,192.00 110,192.00 25,275.30 4,776.24 30,051.54 2025 84,000.00 28,716.00 112,716.00 26,072.23 3,966.75 30,038.98 2026 84,000.00 27,120.00 111,120.00 26,894.29 3,131.75 30,026.04 2027 84,000.00 25,440.00 109,440.00 27,742.27 2,270.38 30,012.65 2028 92,000.00 23,542.00 115,542.00 28,616.98 1,381.89 29,998.87 2029 92,000.00 21,426.00 113,426.00 29,519.28 465.37 29,984.65 2030 96,000.00 19,168.00 115,168.00 2031 100,000.00 16,718.00 116,718.00 2032 100,000.00 14,118.00 114,118.00 2033 104,000.00 11,364.00 115,364.00 2034 108,000.00 8,340.00 116,340.00 2035 112,000.00 5,040.00 117,040.00 2036 112,000.00 1,680.00 113,680.00 53,132.00 796.98 53,928.98 1,408,000.00 297,888.00 1,705,888.00 212,376.86 27,875.15 240,252.01 2019 Refunding 2020 G O Note TOTAL DEBT Storm Storm Storm Year Principal Interest Total Principal Interest Total Principal Interest Total 2022 95,000.00 14,700.00 109,700.00 50,000.00 7,400.00 57,400.00 301,885.78 62,530.74 364,416.52 2023 95,000.00 11,850.00 106,850.00 50,000.00 6,400.00 56,400.00 249,502.73 55,523.01 305,025.74 2024 95,000.00 9,000.00 104,000.00 50,000.00 5,400.00 55,400.00 250,275.30 49,368.24 299,643.54 2025 100,000.00 6,150.00 106,150.00 55,000.00 4,400.00 59,400.00 265,072.23 43,232.75 308,304.98 2026 105,000.00 3,150.00 108,150.00 55,000.00 3,300.00 58,300.00 270,894.29 36,701.75 307,596.04 2027 ‐ 55,000.00 2,200.00 57,200.00 166,742.27 29,910.38 196,652.65 2028 ‐ 55,000.00 1,650.00 56,650.00 175,616.98 26,573.89 202,190.87 2029 ‐ 55,000.00 1,100.00 56,100.00 176,519.28 22,991.37 199,510.65 2030 55,000.00 550.00 55,550.00 151,000.00 19,718.00 170,718.00 2031 100,000.00 16,718.00 116,718.00 2032 100,000.00 14,118.00 114,118.00 2033 104,000.00 11,364.00 115,364.00 2034 108,000.00 8,340.00 116,340.00 2035 112,000.00 5,040.00 117,040.00 2036 112,000.00 1,680.00 113,680.00 490,000.00 44,850.00 534,850.00 480,000.00 32,400.00 512,400.00 2,643,508.86 403,810.13 3,047,318.99  UTILITY COMMISSION April 19, 2022 Utility Bills List April 19, 2022 The above payments are recommended for approval on April 19, 2022. $ 307,979.57 Rejected: UTILITY INVOICES PAID WITH VILLAGE BILLS - MARCH 11 - MARCH 31 $ 277,038.87 UTILITY INVOICES PAID WITH VILLAGE BILLS - APRIL 1 - APRIL 13 $ 29,714.61 TOTAL $ 614,733.05 Approved: April 19, 2022 Kevin Coffey, Chairperson Laurie Decker, Clerk H:\FINANCE\ACCOUNT PAYABLE\UTILITY COMMISSION LIST VILLAGE OF LITTLE CHUTE Invoice Register-UTILITY BILLS LIST Page: 1 Input Dates: 4/19/2022 - 4/19/2022 Apr 13, 2022 12:39PM Invoice Type Description Total Cost Terms 1099 PO Number GL Account BADGER METER INC (517) 80095950 Invoi CELLULAR ENDPOINTS 30.26 Open Non 620-53644-253 Total BADGER METER INC (517): 30.26 COMPASS MINERALS AMERICA (4500) 981095 Invoi COARSE SOLAR SALT 3,417.68 Open Non 620-53634-224 981706 Invoi COARSE SOLAR SALT 3,419.04 Open Non 620-53634-224 981708 Invoi COARSE SOLAR SALT 3,421.76 Open Non 620-53634-224 982236 Invoi COARSE SOLAR SALT 3,307.52 Open Non 620-53634-224 Total COMPASS MINERALS AMERICA (4500): 13,566.00 DONALD HIETPAS & SONS INC. (209) 040222 Invoi REPAIRED 12" STORM SEWER ON MCKINLEY & W 1,373.76 Open Non 630-53442-251 Total DONALD HIETPAS & SONS INC. (209): 1,373.76 GRAINGER (2338) 9262933626 Invoi ZINC PLATED SCREWS 12.43 Open Non 620-53644-251 9265942285 Invoi SHELF BIN 144.80 Open Non 620-53644-251 Total GRAINGER (2338): 157.23 HAWKINS INC (1918) 6145352 Invoi AZONE 533.21 Open Non 620-53634-214 6145352 Invoi SODIUM SILICATE 2,083.90 Open Non 620-53634-220 Total HAWKINS INC (1918): 2,617.11 HEART OF THE VALLEY (280) 040622 Invoi MARCH WASTEWATER 229,778.78 Open Non 610-53611-225 040622 Invoi FOG CONTROL 125.00 Open Non 610-53611-204 040622MP Invoi MARCH HOV METER PAYABLE 8,112.00 Open Non 610-21110 Total HEART OF THE VALLEY (280): 238,015.78 MCO (2254) 28186 Invoi MAY 2022 OPERATIONS 30,514.27 Open Non 620-53644-115 28186 Invoi MAY 2022 HEALTH & LIABILITY INS 6,917.66 Open Non 620-53644-115 Total MCO (2254): 37,431.93 MIDWEST METER INC (4407) 141820 Invoi METER BASE AND ACCESSORIES 13,125.00 Open Non 620-53644-301 141821 Invoi IR COMM DEVICE CELLULAR 150.00 Open Non 620-53644-301 Total MIDWEST METER INC (4407): 13,275.00 TRILOGY CONSULTING LLC (5323) 1323 Invoi WASTEWATER RATE STUDY 1,512.50 Open Non 610-53614-204 Total TRILOGY CONSULTING LLC (5323): 1,512.50 Grand Totals: 307,979.57 Report GL Period Summary VILLAGE OF LITTLE CHUTE Invoice Register-UTILITY BILLS LIST Page: 2 Input Dates: 4/19/2022 - 4/19/2022 Apr 13, 2022 12:39PM Vendor number hash: 42271 Vendor number hash - split: 46723 Total number of invoices: 15 Total number of transactions: 18 Terms Description Invoice Amount Net Invoice Amount Open Terms 307,979.57 307,979.57 Grand Totals: 307,979.57 307,979.57 VILLAGE OF LITTLE CHUTE Invoice Register - UTILITY INVOICES PAID WITH VILLAGE BILLS Page: 1 Input Dates: 3/11/2022 - 3/31/2022 Apr 13, 2022 12:41PM Report Criteria: Invoice Detail.GL Account = "6200000000"-"62099999999","61000000000"-"61099999999","63000000000"-"63099999999" Invoice Type Description Total Cost Terms 1099 PO Number GL Account AT& T (409) 92078873810963 0 Invoi MAR/APR SERVICE 70.31 Open Non 620-53924-203 Total AT& T (409): 70.31 AT&T LONG DISTANCE (2751) 03/22 845626857 Invoi JAN/FEB CHARGES 1.28 Open Non 620-53924-203 Total AT&T LONG DISTANCE (2751): 1.28 BADGER METER INC (517) 80093667 Invoi ORION CELLULAR LTE SERV UNIT 26.70 Open Non 620-53904-204 Total BADGER METER INC (517): 26.70 BUILDING SERVICE INC (4436) 158239 Invoi OFFICE FURNITURE-PENNEY/50% DEPOSIT 552.00 Open Non 610-53614-221 158239 Invoi OFFICE FURNITURE-PENNEY/50% DEPOSIT 521.00 Open Non 620-53924-221 158239 Invoi OFFICE FURNITURE-PENNEY/50% DEPOSIT 919.00 Open Non 630-53444-221 Total BUILDING SERVICE INC (4436): 1,992.00 CELLCOM (4683) 103718 Invoi IPAD STORM 23.59 Open Non 630-53442-218 103718 Invoi IPAD SANITARY SEWER 23.59 Open Non 610-53612-218 Total CELLCOM (4683): 47.18 CIVIC SYSTEMS LLC (705) CVC21772 Invoi ADDITIONAL CONCURRENT LICENSE 390.00 Open Non 610-53614-208 CVC21772 Invoi ADDITIONAL CONCURRENT LICENSE 371.00 Open Non 620-53924-208 CVC21772 Invoi ADDITIONAL CONCURRENT LICENSE 647.00 Open Non 630-53444-208 Total CIVIC SYSTEMS LLC (705): 1,408.00 COMPASS MINERALS AMERICA (4500) 955225 Invoi COATING REMOVAL DISCS 3,420.40 Open Non 620-53634-224 957110 Invoi COATING REMOVAL DISCS 3,444.88 Open Non 620-53634-224 963792 Invoi COARSE SOLAR SALT 3,419.04 Open Non 620-53634-224 965038 Invoi COARSE SOLAR SALT 3,454.40 Open Non 620-53634-224 Total COMPASS MINERALS AMERICA (4500): 13,738.72 DORNER COMPANY (4840) 161006 Invoi FLOWSEAL BUTTERFLY VALVES 20,005.11 Open Non 620-53634-255 Total DORNER COMPANY (4840): 20,005.11 EHLERS INVESTMENT PARTNERS LLC (1425) FEBRUARY 2022 Invoi FEBRUARY INVESTMENT MANAGEMENT 209.15 Open Non 610-53614-229 FEBRUARY 2022 Invoi FEBRUARY INVESTMENT MANAGEMENT 104.58 Open Non 620-53924-229 FEBRUARY 2022 Invoi FEBRUARY INVESTMENT MANAGEMENT 376.47 Open Non 630-53444-229 VILLAGE OF LITTLE CHUTE Invoice Register - UTILITY INVOICES PAID WITH VILLAGE BILLS Page: 2 Input Dates: 3/11/2022 - 3/31/2022 Apr 13, 2022 12:41PM Invoice Type Description Total Cost Terms 1099 PO Number GL Account Total EHLERS INVESTMENT PARTNERS LLC (1425): 690.20 FASTENAL COMPANY (847) WIKIM272593 Invoi CABLE TIES 331.75 Open Non 620-53644-252 Total FASTENAL COMPANY (847): 331.75 FERGUSON WATERWORKS LLC #1476 (221) 353753 Invoi STAINLESS STEEL CLAMPS 197.60 Open Non 620-53644-251 353908 Invoi PVC CAP FOR WELL 39.42 Open Non 610-53614-218 Total FERGUSON WATERWORKS LLC #1476 (221): 237.02 GARROW OIL (4236) FEBRUARY 2022 Invoi OFF ROAD DIESEL 1.15 Open Non 610-53612-247 FEBRUARY 2022 Invoi OFF ROAD DIESEL 3.46 Open Non 620-53644-247 Total GARROW OIL (4236): 4.61 GRAINGER (2338) 9238113980 Invoi CAR WASH/CAR WASH BRUSH & HANDLE/GREAS 161.39 Open Non 620-53644-221 Total GRAINGER (2338): 161.39 HAWKINS INC (1918) 6122873 Invoi AZONE 506.15 Open Non 620-53634-214 6122873 Invoi SODIUM SILICATE 2,057.27 Open Non 620-53634-220 6127582 Invoi AZONE 432.71 Open Non 620-53634-214 6127582 Invoi SODIUM SILICATE 1,684.59 Open Non 620-53634-220 Total HAWKINS INC (1918): 4,680.72 HEART OF THE VALLEY (280) 030322MP Invoi FEBRUARY HOV METER PAYABLE 6,760.00 Open Non 610-21110 030722 Invoi FEBRUARY WASTEWATER 153,980.48 Open Non 610-53611-225 030722 Invoi FOG CONTROL 141.00 Open Non 610-53611-204 Total HEART OF THE VALLEY (280): 160,881.48 JACOBUS ENERGY LLC (4955) 2436524 Invoi DIESEL FUEL 782.83 Open Non 620-53624-248 Total JACOBUS ENERGY LLC (4955): 782.83 KAUKAUNA UTILITIES (234) MARCH 2022 Invoi PUMP STATION JEFFERSON ST 811.99 Open Non 620-53624-249 MARCH 2022 Invoi #4 WELL EVERGREEN DR 4,213.87 Open Non 620-53624-249 MARCH 2022 Invoi #3 WELL WASHINGTON ST 1,690.79 Open Non 620-53624-249 MARCH 2022 Invoi STEPHEN ST TOWER/LIGHTING 188.89 Open Non 620-53624-249 MARCH 2022 Invoi DOYLE PARK WELL 2,881.04 Open Non 620-53624-249 MARCH 2022 Invoi 1800 STEPHEN ST STORM 396.24 Open Non 630-53441-249 Total KAUKAUNA UTILITIES (234): 10,182.82 LINDNER ACE HARDWARE LITTLE CHUTE (4702) 273820-325003 Invoi PVC CAP 1.59 Open Non 620-53634-255 VILLAGE OF LITTLE CHUTE Invoice Register - UTILITY INVOICES PAID WITH VILLAGE BILLS Page: 3 Input Dates: 3/11/2022 - 3/31/2022 Apr 13, 2022 12:41PM Invoice Type Description Total Cost Terms 1099 PO Number GL Account 274085-325003 Invoi SHOVEL 18.99 Open Non 620-53644-218 Total LINDNER ACE HARDWARE LITTLE CHUTE (4702): 20.58 MCCLONE (4766) 6268 Invoi 2ND QTR WORKERS COMP 1,515.00 Open Non 610-53614-230 6268 Invoi 2ND QTR WORKERS COMP 2,181.00 Open Non 630-53444-230 6268 Invoi 2ND QTR WORKERS COMP 649.00 Open Non 620-53924-230 6268 Invoi 2ND QTR WORKERS COMP 30.00 Open Non 610-53614-230 6268 Invoi 2ND QTR WORKERS COMP 29.00 Open Non 620-53924-230 6268 Invoi 2ND QTR WORKERS COMP 24.00 Open Non 630-53444-230 6268 Invoi 2ND QTR AUTO LIABILITY 5,304.00 Open Non 610-53614-231 6268 Invoi 2ND QTR AUTO LIABILITY 99.00 Open Non 620-53924-231 6268 Invoi 2ND QTR AUTO LIABILITY 598.00 Open Non 630-53444-231 6268 Invoi 2ND QTR GENERAL LIABILITY 417.00 Open Non 610-53614-231 6268 Invoi 2ND QTR GENERAL LIABILITY 269.00 Open Non 620-53924-231 6268 Invoi 2ND QTR GENERAL LIABILITY 774.00 Open Non 630-53444-231 Total MCCLONE (4766): 11,889.00 MCO (2254) 28094 Invoi APRIL 2022 OPERATIONS 30,514.27 Open Non 620-53644-115 28094 Invoi APR 2022 HEALTH & LIABILITY INS 6,917.66 Open Non 620-53644-115 28132 Invoi JANUARY MILEAGE REIMBURSEMENT 411.45 Open Non 620-53644-247 Total MCO (2254): 37,843.38 MIDWEST METER INC (4407) 0141004 Invoi ENCODERS FOR METERS 900.00 Open Non 620-53644-301 Total MIDWEST METER INC (4407): 900.00 MULCAHY SHAW WATER (5150) 323995 Invoi MODULE FOR SANITARY LASER METER 2,724.00 Open Non 610-53612-256 Total MULCAHY SHAW WATER (5150): 2,724.00 OUTAGAMIE COUNTY HIGHWAY DEPT (2053) 1019247 Invoi ULTRA LOW SULFUR DIESEL 47.15 Open Non 620-53644-250 1019254 Invoi PERMIT FOR VANDENBROEK POND 603.75 Open Non 630-51214-263 Total OUTAGAMIE COUNTY HIGHWAY DEPT (2053): 650.90 OUTAGAMIE COUNTY TREASURER (486) 1019260 Invoi FEBRUARY FUEL BILL 28.73 Open Non 630-53441-247 1019260 Invoi FEBRUARY FUEL BILL 293.46 Open Non 630-53442-247 1019260 Invoi FEBRUARY FUEL BILL 63.12 Open Non 610-53612-247 1019260 Invoi FEBRUARY FUEL BILL 448.31 Open Non 620-53644-247 Total OUTAGAMIE COUNTY TREASURER (486): 833.62 POSTAL EXPRESS & MORE LLC (5093) 227992 Invoi POSTAGE-WATER TESTS 17.99 Open Non 620-53644-204 228192 Invoi POSTAGE-WATER TESTS 17.70 Open Non 620-53644-204 228263 Invoi POSTAGE-WATER TESTS 18.00 Open Non 620-53644-204 VILLAGE OF LITTLE CHUTE Invoice Register - UTILITY INVOICES PAID WITH VILLAGE BILLS Page: 4 Input Dates: 3/11/2022 - 3/31/2022 Apr 13, 2022 12:41PM Invoice Type Description Total Cost Terms 1099 PO Number GL Account Total POSTAL EXPRESS & MORE LLC (5093): 53.69 SPEEDY CLEAN DRAIN & SEWER (122) 75431 Invoi TELEVISE SANITARY LATERAL FOR PHEASANT R 530.00 Open Non 630-51140-204 Total SPEEDY CLEAN DRAIN & SEWER (122): 530.00 TIME WARNER CABLE (89) 03/22 20279 Invoi MARCH/APRIL SERVICE 116.16 Open Non 620-53924-203 Total TIME WARNER CABLE (89): 116.16 TRILOGY CONSULTING LLC (5323) 1310 Invoi WASTEWATER RATE STUDY 1,842.50 Open Non 610-53614-204 Total TRILOGY CONSULTING LLC (5323): 1,842.50 U.S. BANK (5015) 03/22 59455565491 Invoi SARA III PERMIT 630.39 Open Non 620-53634-255 Total U.S. BANK (5015): 630.39 ULINE (2543) 145399863 Invoi DRY ERASE BOARD/CORK BOARD/MATS 1,000.67 Open Non 620-53924-206 Total ULINE (2543): 1,000.67 US POSTMASTER (264) DPW SPRING 2022 Invoi 2022 DPW SPRING NEWSLETTER 307.79 Open Non 620-53924-226 DPW SPRING 2022 Invoi 2022 DPW SPRING NEWSLETTER 153.95 Open Non 630-53444-226 Total US POSTMASTER (264): 461.74 USA BLUEBOOK (1117) 883707 Invoi ROUNDED GRABBER SOCKET 493.53 Open Non 620-53644-251 Total USA BLUEBOOK (1117): 493.53 VILLAGE OF LITTLE CHUTE (1404) MARCH 2022 Invoi 3609 FREEDOM RD 18.15 Open Non 630-53441-249 MARCH 2022 Invoi 1200 STEPHEN ST 13.20 Open Non 620-53624-249 MARCH 2022 Invoi 625 E EVERGREEN ST 104.78 Open Non 620-53624-249 MARCH 2022 Invoi #3 WELL WASHINGTON ST 12.38 Open Non 620-53624-249 MARCH 2022 Invoi DOYLE PARK WELL #1 12.95 Open Non 620-53624-249 MARCH 2022 Invoi PUMP STATION JEFFERSON ST 36.82 Open Non 620-53624-249 Total VILLAGE OF LITTLE CHUTE (1404): 198.28 WE ENERGIES (2788) 4054315574 02/22 Invoi PLANT #1 (100 WILSON ST) 394.48 Open Non 620-53624-249 4054315574 02/22 Invoi PUMP STATION @ EVERGREEN & FRENCH 57.20 Open Non 620-53624-249 4054315574 02/22 Invoi 920 WASHINGTON ST 125.97 Open Non 620-53624-249 4054315574 02/22 Invoi LC WELL # 4 PUMPHOUSE 718.73 Open Non 620-53624-249 4054315574 02/22 Invoi PLANT #2 (1118 JEFFERSON ST) 311.93 Open Non 620-53624-249 VILLAGE OF LITTLE CHUTE Invoice Register - UTILITY INVOICES PAID WITH VILLAGE BILLS Page: 5 Input Dates: 3/11/2022 - 3/31/2022 Apr 13, 2022 12:41PM Invoice Type Description Total Cost Terms 1099 PO Number GL Account Total WE ENERGIES (2788): 1,608.31 Grand Totals: 277,038.87 Report GL Period Summary Vendor number hash: 121985 Vendor number hash - split: 223896 Total number of invoices: 45 Total number of transactions: 86 Terms Description Invoice Amount Net Invoice Amount Open Terms 277,038.87 277,038.87 Grand Totals: 277,038.87 277,038.87 Report Criteria: Invoice Detail.GL Account = "6200000000"-"62099999999","61000000000"-"61099999999","63000000000"-"63099999999" VILLAGE OF LITTLE CHUTE Invoice Register - UTILITY INVOICES PAID WITH VILLAGE BILLS Page: 1 Input Dates: 4/1/2022 - 4/13/2022 Apr 13, 2022 12:43PM Report Criteria: Invoice Detail.GL Account = "6200000000"-"62099999999","61000000000"-"61099999999","63000000000"-"63099999999" Invoice Type Description Total Cost Terms 1099 PO Number GL Account AT&T LONG DISTANCE (2751) 04/22 845626857 Invoi FEB/MAR CHARGES 1.15 Open Non 620-53924-203 Total AT&T LONG DISTANCE (2751): 1.15 BOND TRUST SERVICES CORP (4071) 70169 Invoi PAYING AGENT FEE-REF 70169 PA 400.00 Open Non 630-53444-229 70170 Invoi PAYING AGENT FEE-REF 70170 PA 400.00 Open Non 620-53924-229 Total BOND TRUST SERVICES CORP (4071): 800.00 COMPASS MINERALS AMERICA (4500) 974459 Invoi COARSE SOLAR SALT 3,273.52 Open Non 620-53634-224 Total COMPASS MINERALS AMERICA (4500): 3,273.52 DAMAGE PREVENTION SERVICES (4068) 3748 Invoi MARCH LOCATES 1,885.75 Open Non 610-53612-209 3748 Invoi MARCH LOCATES 3,029.50 Open Non 620-53644-209 3748 Invoi MARCH LOCATES 1,971.75 Open Non 630-53442-209 Total DAMAGE PREVENTION SERVICES (4068): 6,887.00 FASTENAL COMPANY (847) WIKIM273244 Invoi SPRAY PAINT 58.73 Open Non 630-53444-218 Total FASTENAL COMPANY (847): 58.73 GRAINGER (2338) 9255021587 Invoi DRIVE BELT 5.36 Open Non 620-53634-255 9256968604 Invoi GASKETS & HARDWARE 675.77 Open Non 620-53634-302 9256968612 Invoi STAINLESS STEEL SCREWS 87.01 Open Non 620-53634-302 9256968620 Invoi STAINLESS STEEL SCREWS 136.73 Open Non 620-53634-255 Total GRAINGER (2338): 904.87 HAWKINS INC (1918) 6136375 Invoi AZONE 533.21 Open Non 620-53634-214 6136375 Invoi SODIUM SILICATE 1,764.45 Open Non 620-53634-220 6137312 Invoi SODIUM SILICATE 532.41 Open Non 620-53634-220 Total HAWKINS INC (1918): 2,830.07 HEARTLAND BUSINESS SYSTEMS (3449) 507756-H Invoi FEBRUARY BILL PRINT QNTY 3911 136.89 Open Non 610-53614-206 507756-H Invoi FEBRUARY BILL PRINT QNTY 3911 136.89 Open Non 620-53904-206 507756-H Invoi FEBRUARY BILL PRINT QNTY 3911 136.87 Open Non 630-53443-206 508501-H Invoi MARCH BILL PRINT QNTY 3900 136.50 Open Non 610-53614-206 508501-H Invoi MARCH BILL PRINT QNTY 3900 136.50 Open Non 620-53904-206 508501-H Invoi MARCH BILL PRINT QNTY 3900 136.50 Open Non 630-53443-206 Total HEARTLAND BUSINESS SYSTEMS (3449): 820.15 VILLAGE OF LITTLE CHUTE Invoice Register - UTILITY INVOICES PAID WITH VILLAGE BILLS Page: 2 Input Dates: 4/1/2022 - 4/13/2022 Apr 13, 2022 12:43PM Invoice Type Description Total Cost Terms 1099 PO Number GL Account MCC INC (480) 293959 Invoi COLD MIX 521.19 Open Non 620-53644-216 Total MCC INC (480): 521.19 MCMAHON ASSOCIATES INC (276) 926001 Invoi PHEASANT RUN STORM SEWER 2,858.49 Open Non 630-51140-204 Total MCMAHON ASSOCIATES INC (276): 2,858.49 MCO (2254) 28174 Invoi FEBRUARY MILEAGE REIMBURSEMENT 390.65 Open Non 620-53644-247 Total MCO (2254): 390.65 MENARDS - APPLETON EAST (319) 16928 Invoi CLEANING SUPPLIES 22.91 Open Non 620-53644-218 Total MENARDS - APPLETON EAST (319): 22.91 O'REILLY AUTOMOTIVE INC (1036) 2043-315359 Invoi DISCS FOR CAMERA 12.48 Open Non 610-53612-251 Total O'REILLY AUTOMOTIVE INC (1036): 12.48 OUTAGAMIE CTY RECYCLING & SOLID WASTE (5051) 24401 Invoi STREET SWEEPINGS 2,513.00 Open Non 630-53442-204 24401 Adju STREET SWEEPINGS 2,513.00- Open Non 630-53442-204 24401-1 Invoi STREET SWEEPINGS 2,513.00 Open Non 630-53442-204 Total OUTAGAMIE CTY RECYCLING & SOLID WASTE (5051): 2,513.00 PRIMADATA LLC (4671) APRIL 2022 Invoi APRIL POSTCARD POSTAGE 300.00 Open Non 610-53613-226 APRIL 2022 Invoi APRIL POSTCARD POSTAGE 300.00 Open Non 620-53904-226 APRIL 2022 Invoi APRIL POSTCARD POSTAGE 300.00 Open Non 630-53443-226 Total PRIMADATA LLC (4671): 900.00 VACUUM PUMP & COMPRESSOR INC (4267) 108783-00 Invoi INDUSTRIAL POND PUMP 5,283.12 Open Non 630-53441-204 Total VACUUM PUMP & COMPRESSOR INC (4267): 5,283.12 VERIZON WIRELESS (3606) 9901820427 Invoi FEBRUARY/MARCH SERVICE 64.16 Open Non 620-53924-203 Total VERIZON WIRELESS (3606): 64.16 WE ENERGIES (2788) 4091132585 03/22 Invoi PLANT #2 (1118 JEFFERSON ST) 233.00 Open Non 620-53624-249 4091132585 03/22 Invoi LC WELL # 4 PUMPHOUSE 532.34 Open Non 620-53624-249 4091132585 03/22 Invoi 920 WASHINGTON ST 71.86 Open Non 620-53624-249 4091132585 03/22 Invoi PUMP STATION @ EVERGREEN & FRENCH 517.40 Open Non 620-53624-249 4091132585 03/22 Invoi PLANT #1 218.52 Open Non 620-53624-249 VILLAGE OF LITTLE CHUTE Invoice Register - UTILITY INVOICES PAID WITH VILLAGE BILLS Page: 3 Input Dates: 4/1/2022 - 4/13/2022 Apr 13, 2022 12:43PM Invoice Type Description Total Cost Terms 1099 PO Number GL Account Total WE ENERGIES (2788): 1,573.12 Grand Totals: 29,714.61 Report GL Period Summary Vendor number hash: 70193 Vendor number hash - split: 119588 Total number of invoices: 25 Total number of transactions: 39 Terms Description Invoice Amount Net Invoice Amount Open Terms 29,714.61 29,714.61 Grand Totals: 29,714.61 29,714.61 Report Criteria: Invoice Detail.GL Account = "6200000000"-"62099999999","61000000000"-"61099999999","63000000000"-"63099999999"