Utility Commission

AGENDA VILLAGE OF LITTLE CHUTE UTILITY COMMISSION MEETING PLACE: Little Chute Village Hall, Board Room DATE: Tuesday, May 23, 2023 TIME: 6:00 p.m. Join Zoom Meeting: https://us06web.zoom.us/j/81603266765 Meeting ID: 816 0326 6765 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 April 18, 2023 2. Discussion—Landfill Update 3. Discussion—Nestle Sanitary Sewer Metering 4. Discussion—Heart of the Valley Metro Sewerage District 5. Progress Reports a. MCO Operations Update b. Director of Public Works c. Finance Director 6. Approval of Vouchers 7. Unfinished Business 8. Items for Future Agenda 9. 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 (Non-Compliant Connections) 10. Return to Open Session 11. 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: May 18, 2023  MINUTES OF THE UTILITY COMMISSION MEETING OF APRIL 18, 2023 Call to Order The Utility Commission meeting was called to order at 6:00 PM by Kevin Coffey, Chair Roll Call PRESENT: Kevin Coffey, Chair Tom Buchholz Michael Vanden Berg Jessica Schultz ALSO PRESENT: Village Administrator Beau Bernhoft, Kent Taylor, Lisa Remiker-Dewall, Jerry Verstegen with MCO Public Appearance for Items Not on the Agenda None Approval of Minutes from the Utility Commission Meeting of March 21, 2023 Moved by T. Buchholz, seconded by K. Coffey to Approve Minutes from the Utility Commission of March 21, 2023 All Ayes – Motion Carried Discussion – 2022 Water Utility Annual Public Service Commission Report Finance Director Remiker-Dewall presented the Annual Report, explained major statistics, and asked for questions. None. Discussion/Action—Professional Service Quote for Bidding/Design of Well #1 Roof Replacement Mr. Verstegen presented and explained proposals received. Two proposals were received from McMahon’s for $3,500 and SEH for $12,580. Recommends the commission approves McMahon’s proposal. Moved by K. Coffey, seconded by J. Schultz to accept the proposal from McMahon for $3,500. All Ayes – Motion Carried Discussion/Action—CCR Report Mr. Verstegen explained the Report. Stated no further action is required, it has been filed with the DNR and published in the Department of Public Works Newsletter, mailed to all residents in April of 2023. Any questions from residents were answered, no complaints have been received. Progress Reports Kent Taylor explained I & I issues. Discussing with Heart of the Valley Metropolitan Sewer District heavy snow melt and rain may have affected our issues. Construction updates: crews have started on Buchanan, starting on the sanitary main, they intend to finish up in the next few days and move onto water installation. Randolph drive crews are working on storm installation. J. Schultz asked about timing when illegal connections are found. Kent explained we follow specific Village Ordinances on how long residents have to make upgrades ect. 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 Agendas Adjournment Moved by K. Coffey seconded by T. Buchholz to Adjourn Utility Commission Meeting at 6:16PM All Ayes – Motion Carried VILLAGE OF LITTLE CHUTE By: ___________________________________ Kevin Coffey, Chair Attest: Laurie Decker, Village Clerk INDUSTRIAL STRENGTH BILLINGS Suspended Suspended Payments Volume BOD Solids Sewer Volume BOD Solids Sewer Applied Period Volume Charges Charges Charges Meter TOTAL Volume Charges Charges Charges Meter TOTAL Difference in A/R June/July 2021 5,015,000 $ 25,299.13 3,059,150 $ 22,943.63 $ 2,343.50 $ 12.00 $ 25,299.13 ‐ Invoiced at 61% ‐ no documentation or meter to substantiate 25,299.13 July/August 2021 5,781,000 43,357.50 4,428.61 ‐ 12.00 47,798.11 3,526,410 26,448.08 2,701.45 ‐ 12.00 29,161.53 18,636.58 Invoiced per meters per ordinance 47,798.11 August/Sept 2021 6,116,000 45,870.00 6,117.80 ‐ 12.00 51,999.80 3,730,760 27,980.70 3,731.86 ‐ 12.00 31,724.56 20,275.24 Invoiced per meters per ordinance 31,724.56 11,612.28 20,112.28 Sept/Oct 2021 4,842,000 36,315.00 4,843.43 ‐ 12.00 41,170.43 2,953,620 22,152.15 2,954.49 ‐ 12.00 25,118.64 16,051.79 Invoiced per meters per ordinance 41,170.43 October/Nov 2021 4,755,000 35,662.50 4,200.26 411.51 12.00 40,286.27 2,900,550 21,754.13 2,562.16 251.02 12.00 24,579.31 15,706.96 Invoiced per meters per ordinance 40,286.27 Nov/Dec 2021 3,767,000 28,252.50 3,327.53 326.01 12.00 31,918.04 2,297,870 17,234.03 2,029.79 198.86 12.00 19,474.68 12,443.36 Invoiced per meters per ordinance 31,918.04 Dec 2021/Jan 2022 2,960,000 22,200.00 2,614.67 256.17 12.00 25,082.84 1,805,600 13,542.00 1,594.95 156.26 12.00 15,305.21 9,777.63 Invoiced per meters per ordinance 25,082.84 Jan/Feb 2022 3,389,000 25,417.50 3,056.98 313.01 12.00 28,799.49 2,067,290 15,504.68 1,864.76 190.94 12.00 17,572.38 11,227.11 Invoiced per meters per ordinance 17,572.38 Feb/March 2022 3,197,000 23,977.50 2,208.64 ‐ 12.00 26,198.14 1,950,170 14,626.28 1,347.27 ‐ 12.00 15,985.55 10,212.59 Invoiced per meters per ordinance 11,442.47 March/April 2022 3,833,000 28,747.50 2,648.02 ‐ 12.00 31,407.52 2,338,130 17,535.98 1,651.29 ‐ 12.00 19,199.27 12,208.25 Invoiced per meters per ordinance April/May 2022 4,636,000 34,770.00 3,202.78 ‐ 12.00 37,984.78 2,827,960 21,209.70 1,953.69 ‐ 12.00 23,175.39 14,809.39 Invoiced per meters per ordinance May/June 2022 5,146,000 38,595.00 3,463.99 50.14 12.00 42,121.13 3,139,060 23,542.95 2,113.04 30.59 12.00 25,698.58 16,422.55 Invoiced per meters per ordinance June/July 2022 4,356,000 32,670.00 2,932.21 42.45 12.00 35,656.66 2,657,160 19,928.70 1,788.65 25.89 12.00 21,755.24 13,901.42 Invoiced per meters per ordinance 21,755.24 July/August 2022 5,230,000 39,225.00 3,520.54 50.96 12.00 42,808.50 3,190,300 23,927.25 2,147.53 31.09 12.00 26,117.87 16,690.63 Invoiced per meters per ordinance 26,117.87 August/Sept 2022 5,942,000 44,565.00 3,448.91 1,153.00 12.00 49,178.91 3,624,620 27,184.65 2,103.83 703.33 12.00 30,003.81 19,175.10 Invoiced per meters per ordinance 30,003.81 Sept/Oct 2022 4,741,000 35,557.50 2,751.81 919.95 12.00 39,241.26 2,892,010 21,690.08 1,678.61 561.17 12.00 23,941.86 15,299.40 Invoiced per meters per ordinance 23,941.85 Oct/Nov 2022 5,354,663 40,159.97 3,108.00 1,039.03 12.00 44,319.00 3,266,344 24,497.58 1,895.88 633.81 12.00 27,039.27 17,279.73 Invoiced per meters per ordinance 27,039.27 Nov/Dec 2022 3,428,261 25,711.96 2,150.99 ‐ 12.00 27,874.95 2,091,239 15,684.29 1,312.11 ‐ 12.00 17,008.40 10,866.55 Invoiced per meters per ordinance 17,008.40 Dec 2022/Jan2023 3,465,852 25,993.89 2,174.58 ‐ 12.00 28,180.47 2,114,170 15,856.28 1,326.49 ‐ 12.00 17,194.77 10,985.70 Invoiced per meters per ordinance 17,194.77 Jan/Feb 2023 3,920,323 29,402.42 2,243.07 ‐ 12.00 31,657.49 2,391,397 17,935.48 1,368.27 ‐ 12.00 19,315.75 12,341.74 Invoiced per meters per ordinance 19,315.75 Feb/March 2023 3,196,009 23,970.07 3,311.07 629.31 12.00 27,922.45 1,949,565 14,621.74 2,019.75 383.88 12.00 17,037.37 10,885.08 Invoiced per meters per ordinance 17,390.43 Applied extra payment here above 61% level ‐ nothing provided with payment March/April 2023 3,413,947 25,604.60 3,536.85 672.22 12.00 29,825.67 2,082,508 15,618.81 2,157.48 410.05 12.00 18,198.34 11,627.33 Invoiced per meters per ordinance PAST DUE‐MAY 14 April/May 2023 4,544,815 34,086.11 4,708.44 894.89 12.00 39,701.44 2,772,337 20,792.53 2,872.15 545.88 12.00 24,222.56 15,478.88 Invoiced per meters per ordinance Due June 15 May/June 2023 ‐ 826,432.48 514,129.47 312,303.01 472,061.62 PAYMENTS 09/01/2021 47,798.11 09/08/2021 25,299.13 11/03/2021 41,170.43 11/30/2021 40,286.27 12/30/2021 31,918.04 02/15/2022 25,082.84 07/01/2022 Applied To Aug/Sept 21 11,612.28 08/10/2022 Applied To Aug/Sept 21, Jan/Feb 2022 & Feb/March 2022 49,127.13 09/26/2022 47,873.11 11/15/2022 53,945.66 01/09/2023 27,039.27 02/17/2023 34,203.17 04/05/2023 36,706.18 472,061.62 Balance due per Accounts Receivable System $ 354,370.86 Nestle paying currently at 61% (312,303.01) AMOUNT DUE TO STAY CURRENT WITH PAYING 61% $ 42,067.85  Engineering Department & Department of Public Works Monthly Utility Commission Report for April 2023 STREET NOTES: Sanitary Sewer • Employees maintained and read laser meters in the sanitary collection system. • 4,770 feet of sanitary sewer main were jetted. • Monitored sanitary sewer system for inflow and infiltration (I&I), televised sanitary mains, sanitary manholes were inspected, and the sewer jetter was operating in the system. • Two employees attended a sewer jetting seminar. Storm Sewer • Development site plans were reviewed. • Street sweeping continued. Storm Ponds • Checked outfalls and cleaned trash racks. • Cleaned up trash in all ponds. • Cleared out plugged storm inlets in heavy rain events. • Mowed the pond perimeters. Water • Nothing to report.  ENGINEERING NOTES: 2023 Utility Projects – April In the month of April, the table below identifies the installed or removed public utilities. April 2023 - Utility Installation and Abandonments Village of Little Chute - BUCHANAN STREET WATER MAIN Units Installed Abandoned/Removed 6" PVC Water Main/Hydrant Lead L.F. 17.0 17.0 6" Water Valves E.A. 2.0 2.0 Fire Hydrant E.A. 2.0 2.0 8" PVC Water Main L.F. 621.5 621.5 8" Water Valves E.A. 3.0 3.0 SANITARY SEWER Units Installed Abandoned/Removed 8" PVC Sanitary Sewer Main L.F. 1125.70 1125.70 4' Diameter, Standard Pre-cast Manhole V.F. 83.27 64.10 6" PVC Sanitary Lateral E.A. 1.00 1.00 STORM SEWER Units Installed Abandoned/Removed None NA None April 2023 - Utility Installation and Abandonments Village of Little Chute - RANDOLPH DRIVE WATER MAIN Units Installed Abandoned/Removed None NA None SANITARY SEWER Units Installed Abandoned/Removed None NA None STORM SEWER Units Installed Abandoned/Removed 24" x 38" RCP Storm Sewer Main L.F. 153.9 29" x 45" RCP Storm Sewer Main L.F. 1158.5 36" RCP Storm Sewer Main L.F. 127.7 6' Diameter - Storm Manhole V.F. 50.6 Buchanan Street Utilities & Concrete Paving Project – The Village has received all permits including the approval from CN for the proposed water main jack and bore to be installed below the existing railroad tracks. Kruczek is coordinating with the railroad to provide necessary information and to schedule railroad flaggers required prior to construction of the water main bore. Kruczek completed construction of both the sanitary sewer main and the water main between Main Street and the railroad tracks. The contractor is currently installing new water services and sanitary laterals in the Village right-of-way. Staff are also working with residents to coordinate private sanitary lateral replacement for properties that were evaluated and deemed sub-standard. This work is part of the Sanitary Infiltration & Inflow reduction efforts; private laterals are being contracted, repaired, and paid, by the property owners directly and are not being financed by the Village. Randolph Drive Utilities & Concrete Paving Project – Coordination continues to relocate private utilities owned by WE-Energies (Gas) and TDS (Fiber) which conflict with proposed Village utilities. Don Hietpas & Sons is working on installation of mainline storm sewer. Crews began construction on the east end of the project near the intersection of Randolph Drive and Hartzheim Drive, work on the storm sewer continued south, then west on Randolph Drive. Top Priorities for May 2023 Buchanan Street Utilities & Concrete Paving Project - The Village has received the approved railroad permit. The Contractor is responsible for and continues coordination of proposed work, proper submittals, and scheduling of required flaggers prior to beginning water main construction within the railroad clear zone. The contractor is currently working on the installation of new water services and sanitary laterals in the Village right-of-way. Staff will continue to focus on construction inspection, management, and administration, as well as continued community outreach and communication with effected residents throughout construction. Randolph Drive Utilities & Concrete Paving Project - Don Hietpas & Sons continues construction of proposed storm sewer mainline. Once completed, Hietpas will begin work on the sanitary sewer. Staff continues to review contractor submittals, prepare for construction inspection, management, and administration. Coordination and community outreach to continue throughout construction. Crosswinds Estates Sidewalk Installation - General Contractor (Sommers Construction) has completed excavation and construction of the concrete curb and gutter, sidewalks, and handicap ramps. Sub-contractor Superior Sewer & Water, Inc. has begun backfilling and placement of topsoil; restoration work continues, the contractor will apply Hydromulch after all areas have been filled. Miscellaneous – Staff has been working with Finance and other departments, researching, preparing estimated project costs, ranking village roads and utilities to evaluate and recommend 5-year (and out years) CIP projects. Continued efforts creating record documents and inputting this information into the GIS database. Staff will be walking all completed project site locations to create the project punch-lists of items to be completed, repaired, or adjusted. o Railroad Quiet Zone – (CLOSED) VILLAGE OF LITTLE CHUTE SEWER UTILITY BUDGET STATUS 2023 2022 % Change $ Change BUDGET ACTUAL ACTUAL from PY from PY Revenue = > APR YTD REVENUE Multi‐family Residential 240,000 77,877 80,868 ‐3.70% (2,991) Residential 1,185,000 391,903 390,417 0.38% 1,486 Commercial 280,000 99,500 100,232 ‐0.73% (732) Industrial 850,000 241,213 295,909 ‐18.48% (54,696) Public Authority 375,000 76,811 104,294 ‐26.35% (27,483) Sales Subtotal 2,930,000 887,304 971,720 ‐8.7% (84,416) % of CY Budget 30% All Other 742,875 233,610 (27,975) ‐935.07% 261,585 TOTAL REVENUE 3,672,875 1,120,915 943,745 % of CY Budget 31% 2023 2022 BUDGET ACTUAL ACTUAL Expense = > APR YTD EXPENSES Financing 255,518 85,664 83,994 1.99% 1,670 Treatment 2,401,600 856,312 776,181 10.32% 80,131 Collection 228,442 68,888 124,632 ‐44.73% (55,744) Billing 161,673 45,303 43,963 3.05% 1,340 Admin 205,121 63,411 70,922 ‐10.59% (7,511) TOTAL EXPENSE 3,252,354 1,119,578 1,099,692 1.81% 19,886 % of CY Budget 34% CASH FLOW ‐OPERATIONS 420,521 1,337 (155,947) ADD: DEPRECIATION 242,000 80,664 78,664 ADD: NEW DEBT ‐ ‐ ‐ LESS: PRINCIPAL PAID (40,000) (40,000) ‐ LESS: FIXED ASSETS (422,357) (154,929) (16,734) NET CASH FLOW 200,164 (112,928) (94,017) NOTE : Landfill revenue for Sewer Utility is billed on a quarterly billing. The first quarter was billed in April. April strength invoices have not been issued to Bel Brands, Oh Snap and Nestle as waiting on lab results. Continue to see interest and investment income impacted as result of market changes. The unrealized loss that exists now will not be recognized as long as 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. The market to face value total for the Village at the end of April is a $328,341 unrealized loss. The positive news is that interest earnings have escalated from minimal returns in past. Property, Auto and Workers Compensation first quarter premiums have been paid so six months of expense have hit income statement. Treatment is up as volume increased 20,648,000 gallons along with suspended solids, ammonia and chloride volumes from same time last year. Collection is down due to the sewer camera purchase last year. Admin is down due to sewer rate study expenses in 2022 this time last year. Capital Contributions (revenue) are not recorded until year end (capital assets paid for by TID or contributed by developers) in the Sewer Utility ($626,000). 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 2019 Refunding Sanitary Year Principal Interest Total 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 155,000.00 12,150.00 167,150.00 TOTAL DEBT Sanitary Year Principal Interest Total 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 155,000.00 12,150.00 167,150.00 VILLAGE OF LITTLE CHUTE WATER UTILITY BUDGET STATUS 2023 2022 % Change $ Change BUDGET ACTUAL ACTUAL from PY from PY Revenue = > APR YTD REVENUE Multi‐family Residential 140,000 45,046 47,047 ‐4.25% (2,001) Residential 945,000 296,188 295,460 0.25% 728 Commercial 190,000 62,275 62,482 ‐0.33% (207) Industrial 470,000 181,537 141,508 28.29% 40,029 Private Fire 60,000 23,027 20,406 12.84% 2,621 Public Fire 424,000 142,880 142,145 0.52% 735 Public Authority 47,000 17,921 10,794 66.03% 7,127 Sales Subtotal 2,276,000 768,874 719,842 6.8% 49,032 % of CY Budget 34% All Other 827,420 34,732 (6,977) ‐597.81% 41,709 TOTAL REVENUE 3,103,420 803,606 712,865 % of CY Budget 26% Expense = > APR YTD 2022 2021 EXPENSES BUDGET ACTUAL ACTUAL Financing 761,212 255,971 257,274 ‐0.51% (1,303) Wells/Source 95,200 6,438 2,984 115.76% 3,454 Pumping 265,891 80,292 61,767 29.99% 18,525 Treatment 483,035 138,926 127,325 9.11% 11,601 Distribution 844,422 297,838 200,889 48.26% 96,949 Billing 74,447 19,975 18,309 9.10% 1,666 Admin 189,099 68,301 62,906 8.58% 5,395 TOTAL EXPENSE 2,713,306 867,741 731,454 18.63% 136,287 % of CY Budget 32% CASH FLOW ‐OPERATIONS 390,114 (64,135) (18,589) ADD: DEPRECIATION 525,000 175,000 173,332 ADD: NEW DEBT 700,000 ‐ ‐ LESS: PRINCIPAL PAID (318,432) (131,968) (130,982) LESS: FIXED ASSETS (521,357) (11,488) (9,583) NET CASH FLOW 775,325 (32,591) 14,178 NOTE : Continue to see interest and investment income impacted as result of market changes. The unrealized loss that exists now will not be recognized as long as 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. The market to face value total for the Village at the end of April is a $335,286 unrealized loss. The positive news is that interest earnings are back on the rise from minimal returns in past. Property, Auto and Workers Compensation first quarter premiums have been paid so six months of expense have hit income statement. Water Utility makes payment to MCO a month in advance per terms of agreement so additional month hits expense in December when no expense is charged. Variation in where MCO spending time in early past of year compared to last year at this time due to operational needs. Pumping is up as utilities have increased $5K over same time last year and the effluent meter at pump # 2 failed. Distribution is up due to purchase of cellular meters compared to same time last year. Capital Contributions (revenue) are not recorded until year end (capital assets paid for by TID or contributed by developers) in the Water Utility ($736,000). Capital assets are shown as expense in utilities for monitoring until capitalized as part of year end audit preparation.  VILLAGE OF LITTLE CHUTE WATER UTILITY DEBT SCHEDULE 2014A Issue 2017B Issue 2016 Water Revenue Water Water Water Year Principal Interest Total Principal Interest Total Principal Interest Total 2023 45,000.00 1,608.75 46,608.75 1,464.25 245.00 1,709.25 75,000.00 5,037.50 80,037.50 2024 45,000.00 551.25 45,551.25 1,546.74 201.08 1,747.82 80,000.00 3,720.00 83,720.00 2025 1,691.11 154.68 1,845.79 80,000.00 2,280.00 82,280.00 2026 1,711.73 103.94 1,815.67 80,000.00 760.00 80,760.00 2027 1,752.96 52.58 1,805.54 90,000.00 2,160.00 92,160.00 8,166.79 757.28 8,924.07 315,000.00 11,797.50 326,797.50 2017 Safe Drinking Bonds 2019A Issue 2019 Refunding Water Water Water Year Principal Interest Total Principal Interest Total Principal Interest Total 2023 56,967.66 16,540.07 73,507.73 35,000.00 7,900.00 42,900.00 50,000.00 6,450.00 56,450.00 2024 57,970.29 15,528.62 73,498.91 35,000.00 6,850.00 41,850.00 55,000.00 4,950.00 59,950.00 2025 58,990.57 14,499.38 73,489.95 40,000.00 5,800.00 45,800.00 55,000.00 3,300.00 58,300.00 2026 60,028.80 13,451.99 73,480.79 40,000.00 4,600.00 44,600.00 55,000.00 1,650.00 56,650.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 968,261.01 133,354.04 1,101,615.05 270,000.00 31,750.00 301,750.00 215,000.00 16,350.00 231,350.00 2020 Issue TOTAL DEBT Water Water Year Principal Interest Total Principal Interest Total 2023 55,000.00 6,750.00 61,750.00 318,431.91 44,531.32 362,963.23 2024 55,000.00 5,650.00 60,650.00 329,517.03 37,450.95 366,967.98 2025 55,000.00 4,550.00 59,550.00 290,681.68 30,584.06 321,265.74 2026 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 455,000.00 26,350.00 481,350.00 2,321,427.80 222,518.82 2,543,946.62 VILLAGE OF LITTLE CHUTE STORM UTILITY BUDGET STATUS 2023 2022 % Change $ Change BUDGET ACTUAL ACTUAL from PY from PY Revenue = > APR YTD REVENUE Multi‐family Residential 80,000 27,928 26,706 4.6% 1,222 Residential 356,000 114,334 118,978 ‐3.9% (4,644) Commercial 535,000 190,440 172,795 10.2% 17,645 Industrial 155,000 58,204 51,311 13.4% 6,893 Public Authority 90,000 39,987 25,720 55.5% 14,267 Sales Subtotal 1,216,000 430,893 395,510 8.9% 35,383 % of CY Budget 35% All Other 907,890 39,191 (86,471) ‐145.3% 125,662 TOTAL REVENUE 2,123,890 470,084 309,039 52.1% 161,045 % of CY Budget 22% Expense = > APR YTD 2023 2022 EXPENSES BUDGET ACTUAL ACTUAL Financing 557,497 199,915 191,617 4.3% 8,298 Pond Maintenance 147,544 17,073 16,213 5.3% 860 Collection 226,283 42,321 52,485 ‐19.4% (10,164) Billing 63,039 18,761 18,281 2.6% 480 Admin 247,029 97,945 80,987 20.9% 16,958 TOTAL EXPENSE 1,241,392 376,014 359,583 4.6% 16,431 % of CY Budget 30% CASH FLOW ‐OPERATIONS 882,498 94,071 (50,544) ADD: DEPRECIATION 505,000 168,332 157,000 ADD: NEW DEBT ‐ ‐ LESS: PRINCIPAL PAID (249,503) (104,503) (123,754) LESS: FIXED ASSETS (506,347) (12,455) (177,965) NET CASH FLOW 631,648 145,445 (195,263) NOTE : Continue to see interest and investment income impacted as result of market changes. The unrealized loss that exists now will not be recognized as long as 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. The market to face value total for the Village at the end of April is a $328,341 unrealized loss. The positive news is that interest earnings have escalated from minimal returns in past. Property, Auto and Workers Compensation first quarter premiums have been paid so six months of expense have hit income statement. Collection is down due to operational staff priorities in other funds in April. Administration is up due to allocation of overhead for MSB and Village Hall (calculated on asset basis) plus progress billing for audit occurred earlier than prior year. Capital Contributions (revenue) are not recorded until year end (capital assets paid for by TID or contributed by developers) in the Storm Utility ($842,000) Capital assets are shown as expense in utilities for monitoring until capitalized as part of year end audit preparation.  VILLAGE OF LITTLE CHUTE STORM UTILITY DEBT SCHEDULE 2016 Storm Revenue 2010 Clean Water Fund 2019 Refunding Storm Storm Storm Year Principal Interest Total Principal Interest Total Principal Interest Total 2023 80,000.00 31,712.00 111,712.00 24,502.73 5,561.01 30,063.74 95,000.00 11,850.00 106,850.00 2024 80,000.00 30,192.00 110,192.00 25,275.30 4,776.24 30,051.54 95,000.00 9,000.00 104,000.00 2025 84,000.00 28,716.00 112,716.00 26,072.23 3,966.75 30,038.98 100,000.00 6,150.00 106,150.00 2026 84,000.00 27,120.00 111,120.00 26,894.29 3,131.75 30,026.04 105,000.00 3,150.00 108,150.00 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 1,328,000.00 264,576.00 1,592,576.00 188,623.08 21,553.39 210,176.47 395,000.00 30,150.00 425,150.00 2020 G O Note TOTAL DEBT Storm Storm Year Principal Interest Total Principal Interest Total 2023 50,000.00 6,400.00 56,400.00 249,502.73 55,523.01 305,025.74 2024 50,000.00 5,400.00 55,400.00 250,275.30 49,368.24 299,643.54 2025 55,000.00 4,400.00 59,400.00 265,072.23 43,232.75 308,304.98 2026 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 430,000.00 25,000.00 455,000.00 2,341,623.08 341,279.39 2,682,902.47  UTILITY COMMISSION May 16, 2023 Utility Bills List May 16, 2023 $ 285,218.80 The above payments are recommended for approval on May 16, 2023 Rejected: UTILITY INVOICES PAID WITH VILLAGE BILLS - APRIL 14 - APRIL 30 $ 328,572.98 UTILITY INVOICES PAID WITH VILLAGE BILLS - MAY 1 - MAY 11 $ 161,016.44 TOTAL $ 774,808.22 Approved: May 17, 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: 5/16/2023 - 5/16/2023 May 10, 2023 01:03PM Invoice Type Description Total Cost Terms 1099 PO Number GL Account BADGER METER INC (517) 80126956 Invoi CELLULAR ENDPOINTS 416.52 Open Non 620-53904-214 Total BADGER METER INC (517): 416.52 FARRELL EQUIPMENT & SUPPLY CO INC (4598) 30228 Invoi 50LB BAG FARRELL VERTICAL PATCH 197.94 Open Non 630-53442-216 Total FARRELL EQUIPMENT & SUPPLY CO INC (4598): 197.94 FERGUSON WATERWORKS LLC #1476 (221) 385124 Invoi CURB BOX AND LID 699.00 Open Non 620-53644-252 Total FERGUSON WATERWORKS LLC #1476 (221): 699.00 GRAINGER (2338) 9688829077 Invoi STAINLESS STEEL PIPE 282.98 Open Non 620-53604-257 9688829093 Invoi STAINLESS STEEL PIPE 24.31 Open Non 620-53604-257 Total GRAINGER (2338): 307.29 HAWKINS INC (1918) 6461533 Invoi AZONE 948.16 Open Non 620-53634-214 6461533 Invoi SODIUM SILICATE 3,655.94 Open Non 620-53634-220 Total HAWKINS INC (1918): 4,604.10 HEART OF THE VALLEY (280) 050823 Invoi APRIL WASTEWATER 228,613.18 Open Non 610-53611-225 050823 Invoi FOG CONTROL 108.00 Open Non 610-53611-204 Total HEART OF THE VALLEY (280): 228,721.18 MCO (2254) 29678 Invoi JUNE 2023 OPERATIONS 31,429.70 Open Non 620-53644-115 29678 Invoi JUNE 2023 HEALTH & LIABILITY INS 7,355.64 Open Non 620-53644-115 Total MCO (2254): 38,785.34 MIDWEST SALT LLC (5001) P467939 Invoi INDUSTRIAL SOUTHERN COARSE SALT 3,774.00 Open Non 620-53634-224 P468061 Invoi INDUSTRIAL SOUTHERN COARSE SALT 3,886.20 Open Non 620-53634-224 P468062 Invoi INDUSTRIAL SOUTHERN COARSE SALT 3,751.90 Open Non 620-53634-224 Total MIDWEST SALT LLC (5001): 11,412.10 POSTAL EXPRESS & MORE LLC (5093) 242601 Invoi POSTAGE-WATER TESTS 16.54 Open Non 620-53644-204 242766 Invoi POSTAGE-WATER TESTS 18.73 Open Non 620-53644-204 243014 Invoi POSTAGE-WATER TESTS 20.03 Open Non 620-53644-204 243413 Invoi POSTAGE-WATER TESTS 20.03 Open Non 620-53644-204 Total POSTAL EXPRESS & MORE LLC (5093): 75.33 Grand Totals: 285,218.80 Report GL Period Summary VILLAGE OF LITTLE CHUTE Invoice Register-UTILITY BILLS LIST Page: 2 Input Dates: 5/16/2023 - 5/16/2023 May 10, 2023 01:03PM Vendor number hash: 49839 Vendor number hash - split: 54291 Total number of invoices: 15 Total number of transactions: 18 Terms Description Invoice Amount Net Invoice Amount Open Terms 285,218.80 285,218.80 Grand Totals: 285,218.80 285,218.80 VILLAGE OF LITTLE CHUTE Invoice Register - UTILITY INVOICES PAID WITH VILLAGE BILLS Page: 1 Input Dates: 4/14/2023 - 4/30/2023 May 10, 2023 12:57PM Report Criteria: Invoice Detail.GL Account = "6200000000"-"62099999999","61000000000"-"61099999999","63000000000"-"63099999999" Invoice Type Description Total Cost Terms 1099 PO Number GL Account AL HARDWARE COMPANY (4702) 279448-325003 Invoi CONNECTORS 3.99 Open Non 620-53634-255 279517-325003 Invoi CONNECTORS 15.18 Open Non 620-53634-255 279521-325003 Invoi CONNECTORS 15.77 Open Non 620-53634-255 279576-325003 Invoi SCREWDRIVER SET 35.99 Open Non 620-53624-221 CM279588-325003 Invoi MERCHANDISE RETURN 19.77- Open Non 620-53634-255 Total AL HARDWARE COMPANY (4702): 51.16 AT& T (409) 92078873810963 0 Invoi APR/MAY SERVICE 70.31 Open Non 620-53924-203 Total AT& T (409): 70.31 AT&T LONG DISTANCE (2751) 04/23 845626857 Invoi FEB/MAR CHARGES 2.40 Open Non 620-53924-203 Total AT&T LONG DISTANCE (2751): 2.40 AXLEY BRYNELSON LLP (5230) 928336 Invoi LEGAL SERVICES 4,029.30 Open Atto 610-53614-262 Total AXLEY BRYNELSON LLP (5230): 4,029.30 BADGER METER INC (517) 80124262 Invoi CELLULAR ENDPOINTS 1,212.18 Open Non 620-53904-214 Total BADGER METER INC (517): 1,212.18 BATTERIES PLUS LLC (652) P61096548 Invoi SANITARY SEWER METER BATTERIES 79.44 Open Non 610-53612-251 Total BATTERIES PLUS LLC (652): 79.44 CELLCOM (4683) 734324-APRIL Invoi IPAD STORM 23.59 Open Non 630-53442-218 734324-APRIL Invoi IPAD SANITARY SEWER 23.59 Open Non 610-53612-218 Total CELLCOM (4683): 47.18 DONALD HIETPAS & SONS INC. (209) 040523 Invoi REPAIRED WATER BREAK ON LINCOLN ST 1,772.21 Open Non 620-53644-251 Total DONALD HIETPAS & SONS INC. (209): 1,772.21 FASTENAL COMPANY (847) WIKIM283259 Invoi CONNECT FITTINGS 58.69 Open Non 620-53634-255 WIKIM283293 Invoi CONNECT FITTINGS 55.20 Open Non 620-53634-255 Total FASTENAL COMPANY (847): 113.89 FERGUSON WATERWORKS LLC #1476 (221) 382456-1 Invoi CURB STOPS 423.49 Open Non 620-53644-252 VILLAGE OF LITTLE CHUTE Invoice Register - UTILITY INVOICES PAID WITH VILLAGE BILLS Page: 2 Input Dates: 4/14/2023 - 4/30/2023 May 10, 2023 12:57PM Invoice Type Description Total Cost Terms 1099 PO Number GL Account Total FERGUSON WATERWORKS LLC #1476 (221): 423.49 GARROW OIL (4236) MARCH 2023 Invoi OFF ROAD DIESEL 5.70 Open Non 630-53441-247 MARCH 2023 Invoi OFF ROAD DIESEL 5.70 Open Non 630-53442-247 MARCH 2023 Invoi OFF ROAD DIESEL 14.67 Open Non 610-53612-247 MARCH 2023 Invoi OFF ROAD DIESEL 33.34 Open Non 620-53644-247 Total GARROW OIL (4236): 59.41 HAWKINS INC (1918) 6416890 Invoi AZONE 773.12 Open Non 620-53634-214 6416890 Invoi SODIUM SILICATE 3,895.17 Open Non 620-53634-220 6427205 Invoi AZONE 712.45 Open Non 620-53634-214 6427205 Invoi SODIUM SILICATE 3,176.50 Open Non 620-53634-220 Total HAWKINS INC (1918): 8,557.24 HEART OF THE VALLEY (280) 041123 Invoi MARCH WASTEWATER 243,407.46 Open Non 610-53611-225 041123 Invoi FOG CONTROL 87.00 Open Non 610-53611-204 Total HEART OF THE VALLEY (280): 243,494.46 KAUKAUNA UTILITIES (234) APRIL 2023 Invoi 1800 STEPHEN ST STORM 1,486.46 Open Non 630-53441-249 APRIL 2023 Invoi DOYLE PARK WELL 3,441.31 Open Non 620-53624-249 APRIL 2023 Invoi STEPHEN ST TOWER/LIGHTING 156.85 Open Non 620-53624-249 APRIL 2023 Invoi #3 WELL WASHINGTON ST 2,293.60 Open Non 620-53624-249 APRIL 2023 Invoi #4 WELL EVERGREEN DRIVE 4,831.67 Open Non 620-53624-249 APRIL 2023 Invoi PUMP STATION JEFFERSON ST 1,061.19 Open Non 620-53624-249 Total KAUKAUNA UTILITIES (234): 13,271.08 KEITH PETERSEN PLUMBING INC (2267) 20571 Invoi INSTALLATION OF BRASS BALL VALVE 298.87 Open Non 620-53644-253 20609 Invoi INSTALLATION OF BRASS BALL VALVE 460.66 Open Non 620-53644-253 Total KEITH PETERSEN PLUMBING INC (2267): 759.53 LAZER UTILITY LOCATING LLC (5357) 1247 Invoi MARCH LOCATES 226.00 Open Non 610-53612-209 1247 Invoi MARCH LOCATES 630.50 Open Non 620-53644-209 1247 Invoi MARCH LOCATES 303.00 Open Non 630-53442-209 Total LAZER UTILITY LOCATING LLC (5357): 1,159.50 MCO (2254) 29598 Invoi MAY 2023 OPERATIONS 31,429.70 Open Non 620-53644-115 29598 Invoi MAY 2023 HEALTH & LIABILITY INS 7,355.64 Open Non 620-53644-115 Total MCO (2254): 38,785.34 MGD INDUSTRIAL CORP (5118) 214149 Invoi MARKING PAINT & GLOVES 88.20 Open Non 610-53612-218 214149 Invoi MARKING PAINT 32.26 Open Non 620-53644-218 VILLAGE OF LITTLE CHUTE Invoice Register - UTILITY INVOICES PAID WITH VILLAGE BILLS Page: 3 Input Dates: 4/14/2023 - 4/30/2023 May 10, 2023 12:57PM Invoice Type Description Total Cost Terms 1099 PO Number GL Account 214149 Invoi MARKING PAINT 32.26 Open Non 630-53442-218 Total MGD INDUSTRIAL CORP (5118): 152.72 MIDWEST SALT LLC (5001) P467673 Invoi INDUSTRIAL SOUTHERN COARSE SALT 3,617.60 Open Non 620-53634-224 P467710 Invoi INDUSTRIAL SOUTHERN COARSE SALT 3,928.70 Open Non 620-53634-224 Total MIDWEST SALT LLC (5001): 7,546.30 OUTAGAMIE COUNTY TREASURER (486) 1019937 Invoi MARCH FUEL BILL 17.77 Open Non 630-53441-247 1019937 Invoi MARCH FUEL BILL 840.57 Open Non 630-53442-247 1019937 Invoi MARCH FUEL BILL 450.11 Open Non 610-53612-247 1019937 Invoi MARCH FUEL BILL 478.54 Open Non 620-53644-247 Total OUTAGAMIE COUNTY TREASURER (486): 1,786.99 POSTAL EXPRESS & MORE LLC (5093) 241657 Invoi POSTAGE-WATER TESTS 16.57 Open Non 620-53644-204 241706 Invoi POSTAGE-WATER TESTS 18.86 Open Non 620-53644-204 241850 Invoi POSTAGE-WATER TESTS 20.04 Open Non 620-53644-204 Total POSTAL EXPRESS & MORE LLC (5093): 55.47 TIME WARNER CABLE (89) 04/23 20279 Invoi APRIL/MAY SERVICES 116.16 Open Non 620-53924-203 Total TIME WARNER CABLE (89): 116.16 TOTAL ENERGY SYSTEMS LLC (1607) 96873 Invoi ON-SITE REPAIR 1,569.22 Open Non 620-53624-248 96875 Invoi COMPLETED INSPECTION 1,699.11 Open Non 620-53624-248 TOTAL ENERGY SYSTEMS LLC (1607): 3,268.33 U.S. BANK (5015) 04/23 59455565491 Invoi SKUNK TRAPS FOR STORM POND 76.90 Open Non 630-53441-218 04/23 59455565491 Invoi SANITARY CAMERA REPAIR 450.61 Open Non 610-53612-204 04/23 59455565491 Invoi 10 INCH EXHAUST FAN 107.04 Open Non 630-53441-253 04/23 59455565491 Invoi WEEKLY PLANNERS 42.44 Open Non 620-53924-206 Total U.S. BANK (5015): 676.99 USA BLUEBOOK (1117) 319110 Invoi UTILITY DIAL CALIPERS 63.95 Open Non 620-53644-221 319252 Invoi SONOSCOPE LEAK DETECTOR 71.44 Open Non 620-53644-221 319259 Invoi STAIN REMOVAL & FIBERGLASS 513.04 Open Non 620-53644-254 Total USA BLUEBOOK (1117): 648.43 VERIZON WIRELESS (3606) 9932493128 Invoi MAR/APR SERVICES 187.30 Open Non 620-53924-203 Total VERIZON WIRELESS (3606): 187.30 VILLAGE OF LITTLE CHUTE Invoice Register - UTILITY INVOICES PAID WITH VILLAGE BILLS Page: 4 Input Dates: 4/14/2023 - 4/30/2023 May 10, 2023 12:57PM Invoice Type Description Total Cost Terms 1099 PO Number GL Account VILLAGE OF LITTLE CHUTE (1404) APRIL 2023 Invoi PUMP STATION JEFFERSON ST 36.82 Open Non 620-53624-249 APRIL 2023 Invoi DOYLE PARK WELL #1 13.30 Open Non 620-53624-249 APRIL 2023 Invoi #3 WELL WASHINGTON ST 12.38 Open Non 620-53624-249 APRIL 2023 Invoi 625 E EVERGREEN DR 152.32 Open Non 620-53624-249 APRIL 2023 Invoi 1200 STEPHEN ST 13.20 Open Non 620-53624-249 APRIL 2023 Invoi 3609 FREEDOM RD-WATER/SEWER 18.15 Open Non 630-53441-249 Total VILLAGE OF LITTLE CHUTE (1404): 246.17 Grand Totals: 328,572.98 Report GL Period Summary Vendor number hash: 108171 Vendor number hash - split: 177575 Total number of invoices: 40 Total number of transactions: 68 Terms Description Invoice Amount Net Invoice Amount Open Terms 328,572.98 328,572.98 Grand Totals: 328,572.98 328,572.98 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/2023 - 5/11/2023 May 10, 2023 01:01PM 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) 05/23 845626857 Invoi MAR/APR CHARGES 20.71 Open Non 620-53924-203 05/23 845626857 Invoi MAR/APR CHARGES 1.09 Open Non 620-53924-203 Total AT&T LONG DISTANCE (2751): 21.80 FERGUSON WATERWORKS LLC #1476 (221) 384911 Invoi SEALANT 153.88 Open Non 610-53612-251 384911 Invoi SEALANT 153.88 Open Non 630-53442-251 Total FERGUSON WATERWORKS LLC #1476 (221): 307.76 GUSSERT, ZACH (5346) 03/23 REIMBURSE Invoi DNR ELC RENEWAL FEE 45.90 Open Non 610-53614-201 03/23 REIMBURSE Invoi WRWA TRAINING FEE 116.35 Open Non 610-53614-201 Total GUSSERT, ZACH (5346): 162.25 HAWKINS INC (1918) 6437339 Invoi AZONE 750.53 Open Non 620-53634-214 6437339 Invoi SODIUM SILICATE 3,192.00 Open Non 620-53634-220 Total HAWKINS INC (1918): 3,942.53 HEART OF THE VALLEY (280) 050823MP Invoi APRIL HOV METER PAYABLE 1,431.00 Open Non 610-21110 Total HEART OF THE VALLEY (280): 1,431.00 KLINK HYDRAULICS LLC (5005) 29092 Invoi BRASS COUPLINGS 424.40 Open Non 620-53644-254 Total KLINK HYDRAULICS LLC (5005): 424.40 KRUCZEK CONSTRUCTION INC (5425) 2023004 Invoi 2023 RECONSTRUCTION PROJECT BUCHANAN S 135,699.12 Open Non 610-51222-263 Total KRUCZEK CONSTRUCTION INC (5425): 135,699.12 MCO (2254) 29628 Invoi MARCH MILEAGE REIMBURSEMENT 436.15 Open Non 620-53644-247 Total MCO (2254): 436.15 MENARDS - APPLETON EAST (319) 36806 Invoi PARTS FOR EXHAUST FAN-FRENCH POND 61.15 Open Non 630-53441-253 Total MENARDS - APPLETON EAST (319): 61.15 MIDWEST SALT LLC (5001) P467770 Invoi INDUSTRIAL SOUTHERN COARSE SALT 3,644.80 Open Non 620-53634-224 P467803 Invoi INDUSTRIAL SOUTHERN COARSE SALT 3,774.00 Open Non 620-53634-224 P467839 Invoi INDUSTRIAL SOUTHERN COARSE SALT 3,870.90 Open Non 620-53634-224 P467861 Invoi INDUSTRIAL SOUTHERN COARSE SALT 3,955.90 Open Non 620-53634-224 VILLAGE OF LITTLE CHUTE Invoice Register - UTILITY INVOICES PAID WITH VILLAGE BILLS Page: 2 Input Dates: 5/1/2023 - 5/11/2023 May 10, 2023 01:01PM Invoice Type Description Total Cost Terms 1099 PO Number GL Account Total MIDWEST SALT LLC (5001): 15,245.60 PREFORM CONCRETE LLC (5347) 34141 Invoi RISER RINGS 227.10 Open Non 610-53612-251 34141 Invoi RISER RINGS 227.10 Open Non 630-53442-251 34142 Invoi RISER RINGS 284.07 Open Non 610-53612-251 34142 Invoi RISER RINGS 284.07 Open Non 630-53442-251 Total PREFORM CONCRETE LLC (5347): 1,022.34 PRIMADATA LLC (4671) MAY 2023 Invoi MAY POSTCARD POSTAGE 350.00 Open Non 610-53613-226 MAY 2023 Invoi MAY POSTCARD POSTAGE 350.00 Open Non 620-53904-226 MAY 2023 Invoi MAY POSTCARD POSTAGE 350.00 Open Non 630-53443-226 Total PRIMADATA LLC (4671): 1,050.00 WE ENERGIES (2788) 4091132585 04/23 Invoi PLANT #1 (100 WILSON ST) 144.57 Open Non 620-53624-249 4091132585 04/23 Invoi PUMP STATION @ EVERGREEN @ FRENCH 611.44 Open Non 620-53624-249 4091132585 04/23 Invoi 920 WASHINGTON ST 39.55 Open Non 620-53624-249 4091132585 04/23 Invoi LC WELL #4 PUMPHOUSE 308.36 Open Non 620-53624-249 4091132585 04/23 Invoi PLANT #2(1118 JEFFERSON ST) 108.42 Open Non 620-53624-249 Total WE ENERGIES (2788): 1,212.34 Grand Totals: 161,016.44 Report GL Period Summary Vendor number hash: 61676 Vendor number hash - split: 103100 Total number of invoices: 17 Total number of transactions: 29 Terms Description Invoice Amount Net Invoice Amount Open Terms 161,016.44 161,016.44 Grand Totals: 161,016.44 161,016.44 Report Criteria: Invoice Detail.GL Account = "6200000000"-"62099999999","61000000000"-"61099999999","63000000000"-"63099999999"