Utility Commission

AGENDA VILLAGE OF LITTLE CHUTE UTILITY COMMISSION MEETING PLACE: Little Chute Village Hall, Board Room DATE: Tuesday, May 17, 2022 TIME: 6:00 p.m. Join Zoom Meeting https://us06web.zoom.us/j/85432799270 Meeting ID: 854 3279 9270 Dial by your location: +1 312 626 6799 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 April 19th, 2022 2. Progress Reports a. MCO Operations Update b. Director of Public Works c. Finance Director 3. Approval of Vouchers 4. Closed Session: 19.85(1)(g) Conferring with legal counsel for the governmental body who is rendering oral or written advice concerning strategy to be adopted by the body with respect to litigation in which it is or is likely to become involved (Outagamie County Landfill) 5. Return to Open Session 6. Unfinished Business 7. Items for Future Agenda 8. 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  MINUTES OF THE UTILITY COMMISSION MEETING OF APRIL 19, 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, EXCUSED: Jerry Verstegen, MCO Public Appearance for Items Not on the Agenda None Approval of Minutes from the Utility Commission Meeting of March 15, 2022 Moved by M. Gloudemans, seconded by T. Buchholz to Approve Minutes from the Utility Commission of March 15, 2022 All Ayes – Motion Carried Discussion of 2021 Annual Report for Public Service Commission Finance Director Lisa Remiker-DeWall presented the Annual Report. Water loss is down 10% this year, last year was 12%. Progress Reports MCO Operations Update Mr. Jerry Verstegen, MCO was excused from this meeting Director of Public Works Director Taylor went over the Monthly Utility Report for the month of March. Finance Director Approval of Vouchers Moved by T. Buchholz, seconded by J. Schultz to Approve and Authorize payment of Vouchers and draw from the respective funds All Ayes – Motion Carried Unfinished Business None Items for Future Agenda Update on new equipment performance Adjournment Moved by K Coffey, seconded by M. Gloudemans to Adjourn the Utility Commission Meeting at 6:12 p.m. All Ayes – Motion Carried  VILLAGE OF LITTLE CHUTE By: Kevin Coffey, Chair Attest: Laurie Decker, Village Clerk VILLAGE OF LITTLE CHUTE SEWER UTILITY Change BUDGET STATUS 2022 2021 from PY BUDGET ACTUAL ACTUAL Revenue = > APR YTD REVENUE Multi‐family Residential 220,000 80,868 74,256 8.90% Residential 1,210,000 390,417 406,859 ‐4.04% Commercial 225,000 100,232 69,092 45.07% Industrial 740,000 295,909 203,365 45.51% Public Authority 400,000 104,294 10,410 901.86% Sales Subtotal 2,795,000 971,720 763,982 27.2% % of CY Budget 35% All Other 139,909 (27,975) (448) 6144.42% TOTAL REVENUE 2,934,909 943,745 763,534 % of CY Budget 32% 23.6% 2022 2021 BUDGET ACTUAL ACTUAL Expense = > APR YTD EXPENSES Financing 250,784 83,994 80,397 4.47% Treatment 2,381,600 776,181 667,242 16.33% Collection 257,412 124,632 65,240 91.04% Billing 144,707 43,963 35,575 23.58% Admin 184,507 70,922 52,405 35.33% TOTAL EXPENSE 3,219,010 1,099,692 900,859 % of CY Budget 34% 22.1% CASH FLOW ‐OPERATIONS (284,101) (155,947) (137,325) 13.56% ADD: DEPRECIATION 236,000 78,664 74,433 ADD: NEW DEBT ‐ ‐ ‐ LESS: PRINCIPAL PAID (47,684) ‐ ‐ LESS: FIXED ASSETS (242,866) (16,734) (12,710) NET CASH FLOW (338,651) (94,017) (75,602) NOTE : Outagamie County Landfill is billed quarterly (first quarter billed in April). Strength customers Agropur, Bel Brands, Nestle and GLK April billing not completed as waiting on 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 = > APR YTD REVENUE Multi‐family Residential 133,900 47,047 44,234 6.36% Residential 954,100 295,460 301,711 ‐2.07% Commercial 154,500 62,482 47,502 31.54% Industrial 450,000 141,508 147,694 ‐4.19% Private Fire 59,000 20,406 19,413 5.12% Public Fire 424,000 142,145 141,402 0.53% Public Authority 47,000 10,794 10,474 3.06% Sales Subtotal 2,222,500 719,842 712,430 1.0% % of CY Budget 32% All Other 102,076 (6,977) 19,393 ‐135.98% TOTAL REVENUE 2,324,576 712,865 731,823 % of CY Budget 31% ‐2.6% Expense = > APR YTD 2022 2021 EXPENSES BUDGET ACTUAL ACTUAL Financing 753,841 257,274 245,899 4.63% Wells/Source 16,500 2,984 56,735 ‐94.74% Pumping 271,987 61,767 49,890 23.81% Treatment 475,030 127,325 127,308 0.01% Distribution 655,726 200,889 161,550 24.35% Billing 61,307 18,309 17,784 2.95% Admin 204,858 62,906 57,963 8.53% TOTAL EXPENSE 2,439,249 731,454 717,129 % of CY Budget 30% 2.0% CASH FLOW ‐OPERATIONS (114,673) (18,589) 14,694 ‐226.50% ADD: DEPRECIATION 520,000 173,332 159,844 ADD: NEW DEBT ‐ ‐ ‐ LESS: PRINCIPAL PAID (392,950) (130,982) (130,014) LESS: FIXED ASSETS (214,927) (9,583) (7,602) NET CASH FLOW (202,550) 14,178 36,922 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 mete technology costs and implementation Water Utility makes payment to MCO a month in advance per terms of agreement so additiona 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 processe  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 = > APR YTD REVENUE Multi‐family Residential 80,000 26,706 26,707 0.00% Residential 356,000 118,978 118,139 0.71% Commercial 495,000 172,795 163,983 5.37% Industrial 155,000 51,311 51,187 0.24% Public Authority 75,000 25,720 24,948 3.09% Sales Subtotal 1,161,000 395,510 384,964 2.7% % of CY Budget 34% All Other 81,220 (86,471) 10,625 ‐913.84% TOTAL REVENUE 1,242,220 309,039 395,589 % of CY Budget 25% ‐21.9% Expense = > APR YTD 2022 2021 EXPENSES BUDGET ACTUAL ACTUAL Financing 537,964 191,617 179,935 6.49% Pond Maintenance 146,281 16,213 42,400 ‐61.76% Collection 456,498 52,485 54,969 ‐4.52% Billing 56,685 18,281 17,802 2.69% Admin 230,924 80,987 86,927 ‐6.83% TOTAL EXPENSE 1,428,352 359,583 382,033 % of CY Budget 25% ‐5.9% CASH FLOW ‐OPERATIONS (186,132) (50,544) 13,556 ‐472.85% ADD: DEPRECIATION 480,000 157,000 145,933 ADD: NEW DEBT ‐ ‐ LESS: PRINCIPAL PAID (301,886) (123,754) (103,028) LESS: FIXED ASSETS (667,083) (177,965) (9,097) NET CASH FLOW (675,101) (195,263) 47,364 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 May 17, 2022 Utility Bills List May 17, 2022 The above payments are recommended for approval on May 17, 2022 $ 431,570.15 Rejected: UTILITY INVOICES PAID WITH VILLAGE BILLS - APRIL 14 - APRIL 30 $ 348,145.01 UTILITY INVOICES PAID WITH VILLAGE BILLS - MAY 1 - MAY 12 $ 19,194.80 TOTAL $ 798,909.96 Approved: May 17, 2022 Kevin Coffey, Chairperson Laurie Decker, Clerk H:\FINANCE\ACCOUNT PAYABLE\UTILITY COMMISSION LIST VILLAGE OF LITTLE CHUTE Invoice Register - UTILITY INVOICES PAID WITH VILLAGE BILLS Page: 1 Input Dates: 4/14/2022 - 4/30/2022 May 11, 2022 02:49PM 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 APR/MAY SERVICE 70.31 Open Non 620-53924-203 Total AT& T (409): 70.31 BADGER METER INC (517) 80095950 Invoi CELLULAR ENDPOINTS 30.26 Open Non 620-53644-253 Total BADGER METER INC (517): 30.26 BATTERIES PLUS LLC (652) P50397932 Invoi SANITARY SEWER METER BATTERIES 39.72 Open Non 610-53612-251 Total BATTERIES PLUS LLC (652): 39.72 CELLCOM (4683) 231822 Invoi IPAD STORM 23.59 Open Non 630-53442-218 231822 Invoi IPAD SANITARY SEWER 23.59 Open Non 610-53612-218 Total CELLCOM (4683): 47.18 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 985876 Invoi COARSE SOLAR SALT 3,268.08 Open Non 620-53634-224 Total COMPASS MINERALS AMERICA (4500): 16,834.08 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 EHLERS INVESTMENT PARTNERS LLC (1425) MARCH 2022 Invoi MARCH INVESTMENT MANAGEMENT 230.07 Open Non 610-53614-229 MARCH 2022 Invoi MARCH INVESTMENT MANAGEMENT 115.04 Open Non 620-53924-229 MARCH 2022 Invoi MARCH INVESTMENT MANAGEMENT 414.12 Open Non 630-53444-229 Total EHLERS INVESTMENT PARTNERS LLC (1425): 759.23 GARROW OIL (4236) MARCH 2022 Invoi OFF ROAD DIESEL 6.00 Open Non 610-53612-247 MARCH 2022 Invoi OFF ROAD DIESEL 3.00 Open Non 620-53644-247 Total GARROW OIL (4236): 9.00 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 VILLAGE OF LITTLE CHUTE Invoice Register - UTILITY INVOICES PAID WITH VILLAGE BILLS Page: 2 Input Dates: 4/14/2022 - 4/30/2022 May 11, 2022 02:49PM Invoice Type Description Total Cost Terms 1099 PO Number GL Account 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 HERRLING CLARK LAW FIRM LTD (208) 1Q/22 131-10Q Invoi STORM 40.50 Open Atto 630-53444-262 1Q/22 131-47Q Invoi STORM 35.00 Open Atto 630-53444-262 Total HERRLING CLARK LAW FIRM LTD (208): 75.50 KAUKAUNA UTILITIES (234) APRIL 2022 Invoi 1800 STEPHEN ST STORM 1,167.16 Open Non 630-53441-249 APRIL 2022 Invoi DOYLE PARK WELL 2,708.65 Open Non 620-53624-249 APRIL 2022 Invoi STEPHEN ST TOWER/LIGHTING 158.44 Open Non 620-53624-249 APRIL 2022 Invoi #3 WELL WASHINGTON ST 1,658.61 Open Non 620-53624-249 APRIL 2022 Invoi #4 WELL EVERGREEN DRIVE 4,016.21 Open Non 620-53624-249 APRIL 2022 Invoi PUMP STATION JEFFERSON ST 731.74 Open Non 620-53624-249 Total KAUKAUNA UTILITIES (234): 10,440.81 KERBERROSE SC (2740) 276141 Invoi PROGRESS BILLING FOR AUDIT OF FINANCIAL S 3,761.00 Open Non 610-53614-262 276141 Invoi PROGRESS BILLING FOR AUDIT OF FINANCIAL S 5,179.00 Open Non 620-53924-262 276141 Invoi PROGRESS BILLING FOR AUDIT OF FINANCIAL S 6,237.00 Open Non 630-53444-262 Total KERBERROSE SC (2740): 15,177.00 LINDNER ACE HARDWARE LITTLE CHUTE (4702) 274193-325003 Invoi HARDWARE 7.59 Open Non 620-53644-253 274298-325001 Invoi PVC CAP 5.59 Open Non 610-53612-251 274377-325003 Invoi HANDLE 19.98 Open Non 620-53644-221 274425-325001 Invoi BRACKETS 23.90 Open Non 630-53441-253 274441-325003 Invoi HOSE CLAMP 14.34 Open Non 620-53644-252 Total LINDNER ACE HARDWARE LITTLE CHUTE (4702): 71.40 MCMAHON ASSOCIATES INC (276) 926169 Invoi PHEASANT RUN STORM SEWER 394.20 Open Non 630-51140-204 Total MCMAHON ASSOCIATES INC (276): 394.20 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 VILLAGE OF LITTLE CHUTE Invoice Register - UTILITY INVOICES PAID WITH VILLAGE BILLS Page: 3 Input Dates: 4/14/2022 - 4/30/2022 May 11, 2022 02:49PM Invoice Type Description Total Cost Terms 1099 PO Number GL Account 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 OUTAGAMIE COUNTY TREASURER (486) 1019299 Invoi MARCH FUEL BILL 30.51 Open Non 630-53441-247 1019299 Invoi MARCH FUEL BILL 476.57 Open Non 630-53442-247 1019299 Invoi MARCH FUEL BILL 451.41 Open Non 610-53612-247 1019299 Invoi MARCH FUEL BILL 575.32 Open Non 620-53644-247 Total OUTAGAMIE COUNTY TREASURER (486): 1,533.81 PROFESSIONAL SERVICE INDUSTRIES INC (4579) 811974 Invoi SOIL DRILLING/GEOTECHNICAL ENGR REPORT 2,047.50 Open Non 610-51230-204 811974 Invoi SOIL DRILLING/GEOTECHNICAL ENGR REPORT 682.50 Open Non 630-51140-204 Total PROFESSIONAL SERVICE INDUSTRIES INC (4579): 2,730.00 SPEEDY CLEAN DRAIN & SEWER (122) 75752 Invoi TELEVISE STORM ON VANDENBERG LANE 1,220.00 Open Non 630-53442-204 75754 Invoi TELEVISE STORM ON RAINBOW LANE 1,220.00 Open Non 630-53442-204 75774 Invoi PRE-BORE TELEVISE AND LOCATE 795.00 Open Non 630-53442-204 75774 Invoi PRE-BORE TELEVISE AND LOCATE 795.00 Open Non 610-53612-204 Total SPEEDY CLEAN DRAIN & SEWER (122): 4,030.00 STEIER, MATTHEW (4014) 2022-04 Invoi REPLACE CURB BOX & CONCRETE SLAB-2308 JP 1,000.00 Open Non 620-53644-252 Total STEIER, MATTHEW (4014): 1,000.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 U.S. BANK (5015) 04/22 59455565491 Invoi INDUSTRIAL POND FLOATS 75.14 Open Non 630-53441-218 Total U.S. BANK (5015): 75.14 VAN ASTEN, DONNA (2946) 2022 Invoi DRAINAGE EASEMENT & INGRESS/EGRESS 150.00 Open Non 630-53442-260 Total VAN ASTEN, DONNA (2946): 150.00 VERIZON WIRELESS (3606) 9904143108 Invoi MARCH/APRIL SERVICE 95.20 Open Non 620-53924-203 Total VERIZON WIRELESS (3606): 95.20 VILLAGE OF LITTLE CHUTE (1404) APRIL 2022 Invoi PUMP STATION JEFFERSON ST 36.82 Open Non 620-53624-249 APRIL 2022 Invoi DOYLE PARK WELL #1 13.53 Open Non 620-53624-249 APRIL 2022 Invoi #3 WELL WASHINGTON ST 12.38 Open Non 620-53624-249 VILLAGE OF LITTLE CHUTE Invoice Register - UTILITY INVOICES PAID WITH VILLAGE BILLS Page: 4 Input Dates: 4/14/2022 - 4/30/2022 May 11, 2022 02:49PM Invoice Type Description Total Cost Terms 1099 PO Number GL Account APRIL 2022 Invoi 625 E EVERGREEN DR 104.78 Open Non 620-53624-249 APRIL 2022 Invoi 1200 STEPHEN ST 13.20 Open Non 620-53624-249 APRIL 2022 Invoi 3609 FREEDOM RD 18.15 Open Non 630-53441-249 Total VILLAGE OF LITTLE CHUTE (1404): 198.86 Grand Totals: 348,145.01 Report GL Period Summary Vendor number hash: 107768 Vendor number hash - split: 143818 Total number of invoices: 41 Total number of transactions: 65 Terms Description Invoice Amount Net Invoice Amount Open Terms 348,145.01 348,145.01 Grand Totals: 348,145.01 348,145.01 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: 5/1/2022 - 5/12/2022 May 11, 2022 02:50PM Report Criteria: Invoice Detail.GL Account = "6200000000"-"62099999999","61000000000"-"61099999999","63000000000"-"63099999999" Invoice Type Description Total Cost Terms 1099 PO Number GL Account BATTERIES PLUS LLC (652) P50725382 Invoi SANITARY SEWER METER BATTERIES 79.44 Open Non 610-53612-251 Total BATTERIES PLUS LLC (652): 79.44 CIVIC SYSTEMS LLC (705) CVC21844 Invoi EMPLOYEE TRAINING-MACK 621.00 Open Non 610-53614-201 CVC21844 Invoi EMPLOYEE TRAINING-MACK 586.50 Open Non 620-53924-201 CVC21844 Invoi EMPLOYEE TRAINING-MACK 1,035.00 Open Non 630-53444-201 Total CIVIC SYSTEMS LLC (705): 2,242.50 DAMAGE PREVENTION SERVICES (4068) 3781 Invoi APRIL LOCATES 341.00 Open Non 610-53612-209 3781 Invoi APRIL LOCATES 990.00 Open Non 620-53644-209 3781 Invoi APRIL LOCATES 594.00 Open Non 630-53442-209 Total DAMAGE PREVENTION SERVICES (4068): 1,925.00 DONALD HIETPAS & SONS INC. (209) 030122 Invoi DRILLED FOR WATER BREAK ON WABASH ST 740.03 Open Non 620-53644-251 030822 Invoi REPAIRED WATER BREAK @ BUCHANAN & ELM 2,156.28 Open Non 620-53644-251 Total DONALD HIETPAS & SONS INC. (209): 2,896.31 EHLERS INVESTMENT PARTNERS LLC (1425) APRIL 2022 Invoi APRIL INVESTMENT MANAGEMENT 220.09 Open Non 610-53614-229 APRIL 2022 Invoi APRIL INVESTMENT MANAGEMENT 110.05 Open Non 620-53924-229 APRIL 2022 Invoi APRIL INVESTMENT MANAGEMENT 396.16 Open Non 630-53444-229 Total EHLERS INVESTMENT PARTNERS LLC (1425): 726.30 FERGUSON WATERWORKS LLC #1476 (221) 356841 Invoi FRAME AND MANHOLE LID 485.33 Open Non 610-53612-251 Total FERGUSON WATERWORKS LLC #1476 (221): 485.33 HAWKINS INC (1918) 6158886 Invoi AZONE 678.27 Open Non 620-53634-214 6158886 Invoi SODIUM SILICATE 2,749.41 Open Non 620-53634-220 6164713 Invoi AZONE 357.12 Open Non 620-53634-214 6164713 Invoi SODIUM SILICATE 1,711.21 Open Non 620-53634-220 Total HAWKINS INC (1918): 5,496.01 HEARTLAND BUSINESS SYSTEMS (3449) 514875-H Invoi APRIL BILL PRINT QNTY 3897 136.40 Open Non 610-53614-206 514875-H Invoi APRIL BILL PRINT QNTY 3897 136.40 Open Non 620-53904-206 514875-H Invoi APRIL BILL PRINT QNTY 3897 136.38 Open Non 630-53443-206 Total HEARTLAND BUSINESS SYSTEMS (3449): 409.18 LEAGUE OF WI MUNICIPALITIES (653) 84133 Invoi LEAF COLLECTION STUDY 2020-2023 1,000.00 Open Non 630-53444-204 VILLAGE OF LITTLE CHUTE Invoice Register - UTILITY INVOICES PAID WITH VILLAGE BILLS Page: 2 Input Dates: 5/1/2022 - 5/12/2022 May 11, 2022 02:50PM Invoice Type Description Total Cost Terms 1099 PO Number GL Account Total LEAGUE OF WI MUNICIPALITIES (653): 1,000.00 MCC INC (480) 295409 Invoi CLEAN STONE 7.56 Open Non 610-53612-216 295409 Invoi CLEAN STONE 7.56 Open Non 620-53644-216 295409 Invoi CLEAN STONE 7.56 Open Non 630-53442-216 Total MCC INC (480): 22.68 MCO (2254) 28289 Invoi MARCH MILEAGE REIMBURSEMENT 495.30 Open Non 620-53644-247 Total MCO (2254): 495.30 PRIMADATA LLC (4671) MAY 2022 Invoi MAY POSTCARD POSTAGE 300.00 Open Non 610-53613-226 MAY 2022 Invoi MAY POSTCARD POSTAGE 300.00 Open Non 620-53904-226 MAY 2022 Invoi MAY POSTCARD POSTAGE 300.00 Open Non 630-53443-226 Total PRIMADATA LLC (4671): 900.00 R.N.O.W. INC (5085) 2022-62535 Invoi CLAW WHEELS 949.32 Open Non 610-53612-251 2022-62561 Invoi REPLACEMENT LENSE FOR SEWER CAMERA 274.93 Open Non 610-53612-251 Total R.N.O.W. INC (5085): 1,224.25 TRILOGY CONSULTING LLC (5323) 1332 Invoi WASTEWATER RATE STUDY 1,292.50 Open Non 610-53614-204 Total TRILOGY CONSULTING LLC (5323): 1,292.50 Grand Totals: 19,194.80 Report GL Period Summary Vendor number hash: 38325 Vendor number hash - split: 71757 Total number of invoices: 17 Total number of transactions: 31 Terms Description Invoice Amount Net Invoice Amount Open Terms 19,194.80 19,194.80 Grand Totals: 19,194.80 19,194.80 VILLAGE OF LITTLE CHUTE Invoice Register - UTILITY INVOICES PAID WITH VILLAGE BILLS Page: 3 Input Dates: 5/1/2022 - 5/12/2022 May 11, 2022 02:50PM Terms Description Invoice Amount Net Invoice Amount Report Criteria: Invoice Detail.GL Account = "6200000000"-"62099999999","61000000000"-"61099999999","63000000000"-"63099999999" VILLAGE OF LITTLE CHUTE Invoice Register-UTILITY BILLS LIST Page: 1 Input Dates: 5/17/2022 - 5/17/2022 May 11, 2022 02:47PM Invoice Type Description Total Cost Terms 1099 PO Number GL Account BADGER METER INC (517) 80098084 Invoi CELLULAR ENDPOINTS 32.93 Open Non 620-53644-253 Total BADGER METER INC (517): 32.93 BATTERIES PLUS LLC (652) P50424802 Invoi BATTERIES 24.96 Open Non 620-53634-255 Total BATTERIES PLUS LLC (652): 24.96 COMPASS MINERALS AMERICA (4500) 991437 Invoi COARSE SOLAR SALT 3,225.92 Open Non 620-53634-224 991440 Invoi COARSE SOLAR SALT 3,391.84 Open Non 620-53634-224 995530 Invoi COARSE SOLAR SALT 3,292.56 Open Non 620-53634-224 Total COMPASS MINERALS AMERICA (4500): 9,910.32 DONALD HIETPAS & SONS INC. (209) 040122 Invoi CHANGED STOP BOX ON NORTH AVE 926.50 Open Non 620-53644-252 042522 Invoi REPAIRED WATER BREAK @ 1004 SHERIDAN CT 3,040.00 Open Non 620-53644-251 Total DONALD HIETPAS & SONS INC. (209): 3,966.50 DORNER INC (4710) 2021006 Invoi VANDENBROEK POND CONSTRUCTION 142,721.01 Open Non 630-51214-263 Total DORNER INC (4710): 142,721.01 FERGUSON ENTERPRISES LLC #448 #1020 (2046) 6586672 Invoi GATE VALVE 3,289.40 Open Non 620-53644-251 Total FERGUSON ENTERPRISES LLC #448 #1020 (2046): 3,289.40 FERGUSON WATERWORKS LLC #1476 (221) 348938 Invoi PIPE FITTINGS & KEY STOP VALVE 1,185.31 Open Non 620-53644-252 348938 Invoi METER INSETTERS 3,250.00 Open Non 620-53644-253 Total FERGUSON WATERWORKS LLC #1476 (221): 4,435.31 HEART OF THE VALLEY (280) 050422 Invoi APRIL WASTEWATER 220,641.76 Open Non 610-53611-225 050422 Invoi FOG CONTROL 158.50 Open Non 610-53611-204 050422MP Invoi APRIL HOV METER PAYABLE 5,408.00 Open Non 610-21110 Total HEART OF THE VALLEY (280): 226,208.26 MCO (2254) 28304 Invoi JUNE 2022 OPERATIONS 30,514.27 Open Non 620-53644-115 28304 Invoi JUNE 2022 HEALTH & LIABILITY INS 6,917.66 Open Non 620-53644-115 Total MCO (2254): 37,431.93 PIEPER ELECTRIC INC (4851) 828272 Invoi NEW BREAKER FOR BOOSTER PUMP 3,495.00 Open Non 620-53624-255 Total PIEPER ELECTRIC INC (4851): 3,495.00 VILLAGE OF LITTLE CHUTE Invoice Register-UTILITY BILLS LIST Page: 2 Input Dates: 5/17/2022 - 5/17/2022 May 11, 2022 02:47PM Invoice Type Description Total Cost Terms 1099 PO Number GL Account POSTAL EXPRESS & MORE LLC (5093) 230263 Invoi POSTAGE-WATER TESTS 18.17 Open Non 620-53644-204 230477 Invoi POSTAGE-WATER TESTS 18.48 Open Non 620-53644-204 230553 Invoi POSTAGE-WATER TESTS 17.88 Open Non 620-53644-204 Total POSTAL EXPRESS & MORE LLC (5093): 54.53 Grand Totals: 431,570.15 Report GL Period Summary Vendor number hash: 45008 Vendor number hash - split: 47763 Total number of invoices: 17 Total number of transactions: 20 Terms Description Invoice Amount Net Invoice Amount Open Terms 431,570.15 431,570.15 Grand Totals: 431,570.15 431,570.15