The URL can be used to link to this page

07-26-2023 HUCCPHUTCHINSON UTILITIES COMMISSION AGENDA REGULAR MEETING July 26, 2023 3:00 p.m. 1. CONFLICT OF INTEREST 2. APPROVE CONSENT AGENDA a. Approve Minutes b. Ratify Payment of Bills 3. APPROVE FINANCIAL STATEMENTS 4. OPEN FORUM 5. COMMUNICATION a. City Administrator b. Divisions C. Human Resources d. Legal e. General Manager 6. POLICIES a. Review Policies i. Section 6 of Exempt Handbook ii. Section 6 of Non -Exempt Handbook iii. Appendices of Exempt Handbook iv. Appendices of Non -Exempt Handbook b. Approve Changes i. Appendix B 7. UNFINISHED BUSINESS 8. NEW BUSINESS a. Re -adopt the Data Practices Act & Public Records Request Policy b. Amend Advertisement for Bid — Hutchinson Substation 83 MVA Transformer C. Approve Rate Changes for the Electric and Natural Gas Divisions 9. ADJOURN MINUTES Special Meeting — Hutchinson Utilities Commission Thursday, July 13, 2023 Call to order — 7:30 a.m. President Anthony Hanson called the meeting to order. Members present: President Anthony Hanson; Vice President Matt Cheney; Commissioner Robert Wendorff; Commissioner Kathy Silvernale; GM Jeremy Carter; Attorney Marc Sebora Absent: Secretary Don Martinez Others Present: John Webster and Angie Radke The purpose of the special meeting is to Approve the Nelson Technologies, Inc. Contract — Filter and Meter Skids for Hutchinson/HCP Natural Gas Interconnect Station. Mr. Webster presented the Approval of the Nelson Technologies, Inc. Contract. Nelson Technologies, Inc. has provided the required Insurance Certificate, Performance Bond and signed copies of the Contract. Motion by Commissioner Cheney, second by Commissioner Silvernale to Approve the Nelson Technologies, Inc. Contract- Filter and Meter Skids for Hutchinson/HCP Natural Gas Interconnect Station. There being no further business, a motion by Commissioner Wendorff, second by Commissioner Cheney to adjourn the meeting at 7:36a.m. Motion carried unanimously. ATTEST: Anthony Hanson, President 1 Don Martinez, Secretary MINUTES Regular Meeting — Hutchinson Utilities Commission Wednesday, June 28, 2023 Call to order — 3:00 p.m. President Anthony Hanson called the meeting to order. Members present: President Anthony Hanson; Vice President Matt Cheney; Secretary Don Martinez; Commissioner Robert Wendorff; Commissioner Kathy Silvernale; Attorney Marc Sebora; GM Jeremy Carter 1. Conflict of Interest President Hanson noted adding a new business item 8d. Approve Awarding the Bid to Nelson Technologies, Inc for Filter and Meter Skids for Hutchinson/HCP Natural Gas Interconnect Station. 2. Approve Consent Agenda a. Approve Minutes b. Ratify Payment of Bills Motion by Commissioner Cheney, second by Commissioner Wendorff to Approve the Consent Agenda. Motion carried unanimously. 3. Approve Financial Statements Mr. Martig presented the financial statements. Electric Division Net Income increased by $207k over May 2022. Which is mostly due to increased sales for resale with Dynasty Contract. Transmission costs increased due to high heat at the end of May. Natural Gas Division bottom line is similar to last month. GM Carter noted that the Dynasty Contract will be discontinuing this month. Motion by Commissioner Silvernale second by Commissioner Cheney to Approve the Financial Statements. Motion carried unanimously. 4. Open Forum 5. Communication a. City Administrator —Matthew Jaunich —Absent b. Divisions i. Dan Lang, Engineering Services Manager — Nothing to report ii. Dave Hunstad, Electric Transmission/Distribution Manager — Nothing to report iii. Mike Gabrielson, Production Manager —Absent iv. John Webster, Natural Gas Division Director — 1. Introduced Bryce Rusch, Transmission Crew Chief who is involved with the Interconnect Station project 2. MNOPS Pipeline Safety Audit was completed last week 1 v. Jared Martig, Financial Manager — Nothing to report c. Human Resources — Angie Radke — i. Finalizing open positions d. Legal — Marc Sebora — Nothing to Report e. General Manager — Jeremy Carter i. MRES update ii. MMUA Task Force update iii. Citizen Survey - looking to send out by end of year. Will send to Commissioners ahead of time for review/updates that may be needed. 6. Policies a. Review Policies No policies to review b. Approve Changes 7. Unfinished Business 8. New Business a. Approve Req#009571- Primary Metering Cabinet Mr. Hunstad reviewed the Approval of Req#009571- Primary Metering Cabinet. The new cabinet would be replacing a failing metering cabinet at the Main Waste Water Lift Station on Ontario St. The current cabinet is starting to corrode. Motion by Commissioner Martinez second by Commissioner Silvernale to Approve Req#009571-Primary Metering Cabinet. Motion carried unanimously. b. Approve Hutchinson Substation 83 MVA Transformer- Advertisement for Bids Mr. Lang presented Approval of Hutchinson Substation 83 MVA Transformer Advertisement for Bids. The transformer being installed at the Hutchinson Substation is part of the 115kV expansion project. Discussion was held on the land that will be used. Motion by Commissioner Wendorff second by Commissioner Cheney to Approve Hutchinson Substation 83 MVA Transformer — Advertisement for Bids. Motion carried unanimously. c. Discussion of Rate Track GM Carter recapped the Rate Track for the Electric and Natural Gas Divisions that were provided to the Commission. Looking for Discussion right now and then in July taking formal action if appropriate on rate changes. The changes would go to the City Council in August for review at first meeting and the second meeting would have approval or veto. Discussion on Demand vs Energy charges were also had. 2 President Hanson looked to the Commissioners to think about and ask GM Carter any questions there may be and to be prepared to vote next month on rate track changes. 8d. Approve Awarding the Bid to Nelson Technologies, Inc for Filter and Meter Skids for Hutchinson/HCP Natural Gas Interconnect Station. Mr. Webster presented Approval of Awarding the Bid to Nelson Technologies, Inc — Filter and Meter Skids for Hutchinson/HCP Natural Gas Interconnect Station. Two responsible bidders were received. Although Nelson Technologies, Inc is $11k higher than the other bid received, recommendation to Nelson Technologies, Inc is requested for 2 reasons; 1) Delivery will be 6 weeks sooner, and 2) Nelson Technologies, Inc is providing a complete SGM4 meter while another bidder is providing a SGM3 meter requiring HUC to upgrade the SGM3 to a SGM4. Mr. Webster noted that all expenses for the construction of Hutchinson Utilities' side of the Hutchinson/HCP Natural Gas Interconnect Station will be expensed to Heartland Corn products. Motion by Commissioner Martinez second by Commissioner Silvernale to Approve Awarding the Bid to Nelson Technologies, Inc for Filter and Meter Skids for Hutchinson/HCP Natural Gas Interconnect Station. Motion carried unanimously. 9. Adjourn There being no further business, a motion by Commissioner Cheney, second by Commissioner Wendorff to adjourn the meeting at 3:53p.m. Motion carried unanimously. ATTEST: Anthony Hanson, President 3 Don Martinez, Secretary 07/19/2023 10:26 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/23/2023 - 07/20/2023 Payee Description Account Dept Page 1/32 Amount Fund: 1 ELECTRIC 06/23/2023 GEN 1437(E)*4 BP CANANDA ENERGY SOLUTIONS Generator 41 Natural Gas 401-547- 01 240.74 GENERATOR 41 NATURAL GAS 401-547- 01 92, 594.40 Generator 41 Aux Boiler 401-547- 01 186.51 GENERATOR 45 NATURAL GAS 401-547- 01 6,177.70 Generator 45 Natural Gas 401-547- 01 37.04 GENERATOR 46 NATURAL GAS 401-547- 01 45.14 GENERATOR 46 NATURAL GAS 401-547- 01 13, 844.50 Generator 47 Natural Gas 401-547- 01 10,788.25 Generator 47 Natural Gas 401-547- 01 45.14 Generator 49 Natural Gas 401-547- 01 115.74 Utility Expenses - Water/Waste 401-930- 08 394.04 HECK GEN 1437(E) TOTAL FOR FUND 1: 124,469.20 06/27/2023 GEN 1453(E)* ALERUS HEALTH INSURANCE 401-926- 08 387.19 06/27/2023 GEN 1475(E) MISO Accounts Payable - Miso 232-000- 00 829.18 06/27/2023 GEN 1476(E) MISO Accounts Payable - Miso 232-000- 00 29,088.45 06/27/2023 GEN 1477(E) MISO Accounts Payable - Miso 232-000- 00 995.35 06/28/2023 GEN 79056*4 ACE HARDWARE Sales Tax Receivable - Replace 186-000- 00 1.27 Sales Tax Receivable - Replace 186-000- 00 0.19 Supplies 401-550- 01 3.61 Accessory Plant - Materials 402-554- 01 18.50 Accessory Plant - Materials 402-554- 01 2.78 Maintenance Other - Materials 402-554- 01 4.26 Maintenance Other - Materials 402-554- 01 69.45 Maintenance Other - Materials 402-554- 01 28.83 HECK GEN 79056 TOTAL FOR FUND 1: 128.89 06/28/2023 GEN 79057* AEM MECHANICAL SERVICES DEP REFUND/APPLIED 235-000- 00 533.00 06/28/2023 GEN 79058* ALEJANDRA BUSTOS MEDIA OR DEP REFUND/APPLIED 235-000- 00 74.75 07/19/2023 10:26 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/23/2023 - 07/20/2023 Payee Description Account Dept Page 2/32 Amount Fund: 1 ELECTRIC 06/28/2023 GEN 79059* AMANDA OR JOSH ZIMMERMANN DEP REFUND/APPLIED 235-000- 00 156.00 06/28/2023 GEN 79060* ANDREW CHILADEK DEP REFUND/APPLIED 235-000- 00 39.00 06/28/2023 GEN 79061 ATLAS TOYOTA LIFT OF MINNESOTA Outside Services 402-554- 01 283.50 06/28/2023 GEN 79062*4 ATLAS TOYOTA LIFT OF MINNESOTA Power Equipment - Materials 402-598- 02 381.88 06/28/2023 GEN 79063* AUSTIN FIELD DEP REFUND/APPLIED 235-000- 00 130.00 06/28/2023 GEN 79064* BARBARA CHRISTOPHER DEP REFUND/APPLIED 235-000- 00 39.00 06/28/2023 GEN 79065* BEN HOFFMAN OR TAYLA CARD DEP REFUND/APPLIED 235-000- 00 221.00 06/28/2023 GEN 79067 BOGATZKI, KATHY Cip - Residential 401-916- 07 30.00 06/28/2023 GEN 79068*4 BORDER STATES ELECTRIC SUPPLY GE LED. Red. 107-362- 00 297.68 GE LED. Green. 107-362- 00 297.68 STATION EQUIPMENT (SWITCHGEAR, 107-362- 00 190. 92 ASSEMBLY, LED, ACORN, GRANVILLE II, 154-000- 00 13,024.60 PARKING STAND, FEED THRU, 200A, 154-000- 00 622.80 LUBE, WIRE PULL, 1 GL JUG, POLYWATER 154-000- 00 126.68 SPLIT BOLT 48 KS-15 Cu BURNDY 154-000- 00 17.60 Sales Tax Receivable - New 186-000- 00 895.44 Sales Tax Receivable - New 186-000- 00 42.76 Sales Tax Receivable - New 186-000- 00 8.71 Sales Tax Receivable - New 186-000- 00 20.47 Sales Tax Receivable - New 186-000- 00 1.21 Sales Tax Receivable - Replace 186-000- 00 20.47 HECK GEN 79068 TOTAL FOR FUND 1: 15,567.02 07/19/2023 10:26 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/23/2023 - 07/20/2023 Payee Description Account Dept Page 3/32 Amount Fund: 1 ELECTRIC 06/28/2023 GEN 79069* BRANDON LUNKLEY DEP REFUND/APPLIED 235-000- 00 130.00 06/28/2023 GEN 79070* BRANDSOY, DALE Cip - Residential 401-916- 07 1,200.00 06/28/2023 GEN 79071 BRUHN, STEVE Cip - Residential 401-916- 07 30.00 06/28/2023 GEN 79072* CALYN LANDFAIR Training - Expense 401-903- 06 145.28 06/28/2023 GEN 79073* CARMEN JAMES DEP REFUND/APPLIED 235-000- 00 48.75 06/28/2023 GEN 79074 CARRIER COMMERCIAL SERVICE GASKET, COND. W/B FR8, ** VOIDED ** GASKET, DISHED HEAD - FRAME 8, ** VOIDED ** Sales Tax Receivable - Replace ** VOIDED ** 06/28/2023 GEN 79075* CARTER, JEREMY J Training - Expense 401-930- 08 242.20 06/28/2023 GEN 79076* CHAD OR MICHELLE PEDERSON DEP REFUND/APPLIED 235-000- 00 58.50 06/28/2023 GEN 79077 CHEIR YOUNG OVERPAYMENTS 142-000- 00 130.35 06/28/2023 GEN 79078*4 CINTAS CORPORATION 4470 Uniforms & Laundry 401-550- 01 250.94 Uniforms & Laundry 401-550- 01 261.69 Uniforms & Laundry 401-550- 01 261.69 UNIFORMS & LAUNDRY 401-588- 02 151.33 UNIFORMS & LAUNDRY 401-588- 02 151.33 UNIFORMS & LAUNDRY 401-588- 02 151.33 HECK GEN 79078 TOTAL FOR FUND 1: 1,228.31 06/28/2023 GEN 79079*4 CITY OF HUTCHINSON Generator 41 Water & Sewer 401-547- 01 1,445.07 Generator 41 Water & Sewer 401-547- 01 1,252.37 Waste Disposal 401-550- 01 1,517.81 Waste Disposal 401-550- 01 51.43 07/19/2023 10:26 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee Fund: 1 ELECTRIC CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/23/2023 - 07/20/2023 Description 06/28/2023 GEN 79080 COLE OR ANGELA COUBROUGH 06/28/2023 GEN 79081 CONTEC SYSTEMS 06/28/2023 GEN 79082 COOLING TOWER DEPOT 06/28/2023 GEN 79083* DANIEL HUNTLEY 06/28/2023 GEN 79084* DAVID OR DARLENE THEIS 06/28/2023 GEN 79085 DEMEYER, JIM 06/28/2023 GEN 79086* DEPARTMENT OF THE TREASURY 06/28/2023 GEN 790874 DESIGN ELECTRIC, INC 06/28/2023 GEN 79088 DGR ENGINEERING Page 4/32 Account Dept Amount Waste Disposal 401-550- 01 574.24 Line - Materials 402-594- 02 145.81 IT ADMIN AND SUPPORT 75/25 401-921- 08 3,406.45 Utility Expenses - Water/Waste 401-930- 08 12.38 Utility Expenses - Water/Waste 401-930- 08 543.21 HECK GEN 79079 TOTAL FOR FUND 1: 8,948.77 OVERPAYMENTS 142-000- 00 71.22 Technical and Software Support 402-554- 01 7,500.00 Dog House, E. Cell Structure, Esc 107-341- 00 31,500.00 MATERIAL DELIVERY 107-341- 00 11,607.41 HECK GEN 79082 TOTAL FOR FUND 1: 43,107.41 GET REFUND/APPLIED 235-000- 00 81.25 GET REFUND/APPLIED 235-000- 00 130.00 Cip - Residential 401-916- 07 30.00 Health Insurance 242-000- 00 129.60 Sales Tax Receivable - Replace 186-000- 00 6.45 Accessory Plant - Materials 402-554- 01 93.82 HECK GEN 79087 TOTAL FOR FUND 1: 100.27 3M Substation Relay and RTU Upgrades 107-362- 00 8,064.00 STATION EQUIPMENT (SWITCHGEAR, 107-362- 00 31.00 Hutchinson Substation 115kV rebuild 107-362- 00 6,048.00 STATION EQUIPMENT (SWITCHGEAR, 107-362- 00 63.50 HECK GEN 79088 TOTAL FOR FUND 1: 14,206.50 07/19/2023 10:26 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/23/2023 - 07/20/2023 Description Fund: 1 ELECTRIC 06/28/2023 GEN 79089 DIEGO DUST 06/28/2023 GEN 790904 DONALDSON COMPANY INC 06/28/2023 GEN 79091* DONAVON DECKER 06/28/2023 GEN 79092*4 E2 ELECTRIC 06/28/2023 GEN 79094* ELEONORA PERNILLADOTTER 06/28/2023 GEN 79095* EMMA OR SPENCER LIGHTFIELD 06/28/2023 GEN 79096* ERIK WILLIAMS 06/28/2023 GEN 79098* FIRST CHOICE FOOD & BEVERAGE 06/28/2023 GEN 79099 FISHER, DAN 06/28/2023 GEN 79100 FISHER, MAVIS 06/28/2023 GEN 79101 GREAT RIVER ENERGY 06/28/2023 GEN 79102 GREENSHAW, RAMONA 06/28/2023 GEN 79104 GRUETT, CLINTON 06/28/2023 GEN 79105* HAGER JEWELRY INC 06/28/2023 GEN 79106* HEALTH PARTNERS Page 5/32 Account Dept Amount OVERPAYMENTS 142-000- 00 57.67 FILTER, HYDRAULIC, DONALDSON - PART # 154-000- 00 508.28 Sales Tax Receivable - New 186-000- 00 36.67 FREIGHT 401-588- 02 25.15 HECK GEN 79090 TOTAL FOR FUND 1: 570.10 DEP REFUND/APPLIED 235-000- 00 65.00 Grounds - Materials 401-935- 08 498.13 DEP REFUND/APPLIED 235-000- 00 97.50 DEP REFUND/APPLIED 235-000- 00 253.50 DEP REFUND/APPLIED 235-000- 00 91.00 BREAKROOM/RECOGNITION BANQUET 401-926- 08 330.00 Cip - Residential 401-916- 07 30.00 Cip - Residential 401-916- 07 30.00 TRANSMISSION EXPENSE 401-565- 03 247, 809. 91 Cip - Residential 401-916- 07 30.00 Cip - Residential 401-916- 07 30.00 Office Supplies 401-921- 08 24.20 HEALTH INSURANCE-85o ELEC 242-000- 00 45,438.75 HEALTH INSURANCE -COBRA 242-000- 00 (101.72) 07/19/2023 10:26 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/23/2023 - 07/20/2023 Payee Description Account Dept Page 6/32 Amount Fund: 1 ELECTRIC HECK GEN 79106 TOTAL FOR FUND 1: 45,337.03 06/28/2023 GEN 79107* HEIDI KIRCHNER DEP REFUND/APPLIED 235-000- 00 65.00 06/28/2023 GEN 79108* HUNTER HOFF OR LILLIAN KASPER DEP REFUND/APPLIED 235-000- 00 48.75 06/28/2023 GEN 79109*4 HUTCHINSON LEADER Advertising/Printing 401-921- 08 420.40 06/28/2023 GEN 79110*4 HUTCHINSON WHOLESALE SUPPLY CO Maintenance Other - Materials 402-554- 01 20.92 06/28/2023 GEN 79111* JANIE GARCIA DEP REFUND/APPLIED 235-000- 00 58.50 06/28/2023 GEN 79112* JILL STAUB DEP REFUND/APPLIED 235-000- 00 110.50 06/28/2023 GEN 79114* JODY SELSETH DEP REFUND/APPLIED 235-000- 00 74.75 06/28/2023 GEN 79115* JOSHUA SCHANTZEN DEP REFUND/APPLIED 235-000- 00 71.50 06/28/2023 GEN 79116* KARL OR LAURETTA MADSEN DEP REFUND/APPLIED 235-000- 00 165.75 06/28/2023 GEN 79117 KAUFMANN, ALICE Cip - Residential 401-916- 07 30.00 06/28/2023 GEN 79118* KEVIN FISHER DEP REFUND/APPLIED 235-000- 00 42.25 DEP REFUND/APPLIED 235-000- 00 48.75 HECK GEN 79118 TOTAL FOR FUND 1: 91.00 06/28/2023 GEN 791194 KURITA AMERICA INC TOWER SHIELD, 5173 154-000- 00 3,349.72 Sales Tax Receivable - Replace 186-000- 00 15.88 Accessory Plant - Materials 402-554- 01 231.00 TAX & FREIGHT 401-588- 02 327.07 HECK GEN 79119 TOTAL FOR FUND 1: 3,923.67 07/19/2023 10:26 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/23/2023 - 07/20/2023 Payee Description Account Dept Page 7/32 Amount Fund: 1 ELECTRIC 06/28/2023 GEN 79120* KYLE STENMARK GET REFUND/APPLIED 235-000- 00 156.00 06/28/2023 GEN 79121* LAUER, TAMMY Cip - Residential 401-916- 07 25.00 06/28/2023 GEN 79122* LAYLA KREUSER-CASTILLO GET REFUND/APPLIED 235-000- 00 149. 50 06/28/2023 GEN 79123* LISSA MICHALSKY OR DANIEL EVERSON GET REFUND/APPLIED 235-000- 00 266.50 06/28/2023 GEN 79124* LOGAN OR MICHELLE SOWERS GET REFUND/APPLIED 235-000- 00 97.50 06/28/2023 GEN 79125* MADELINE LOFSTEDT GET REFUND/APPLIED 235-000- 00 113.75 06/28/2023 GEN 79126 MALORIE MACIK OVERPAYMENTS 142-000- 00 71.26 06/28/2023 GEN 79127 MANTHEY, SUSAN Cip - Residential 401-916- 07 25.00 06/28/2023 GEN 79128* MARILEE CALLAN GET REFUND/APPLIED 235-000- 00 48.75 06/28/2023 GEN 79129* MARY NIECE GET REFUND/APPLIED 235-000- 00 87.75 06/28/2023 GEN 79130 MCLEOD CO 55350 45 GLEN ST LAND OVERPAYMENTS 142-000- 00 170.28 06/28/2023 GEN 79131 MEGARD, MELISSA Cip - Residential 401-916- 07 30.00 06/28/2023 GEN 79132 MIKE WINN Cip - Residential 401-916- 07 30.00 06/28/2023 GEN 791334 NORTHERN STATES SUPPLY INC Sales Tax Receivable - Replace 186-000- 00 2.23 ACCESSORY PLANT - MATERIALS 402-554- 01 32.42 Line - Materials 401-581- 02 0.80 HECK GEN 79133 TOTAL FOR FUND 1: 35.45 06/28/2023 GEN 79136 OLSON, JULIE Cip - Residential 401-916- 07 25.00 07/19/2023 10:26 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/23/2023 - 07/20/2023 Payee Description Account Dept Page 8/32 Amount Fund: 1 ELECTRIC 06/28/2023 GEN 791374 PARMAN ENERGY GROUP CHEVRON RANDO HD 46 154-000- 00 69.55 TAX & FREIGHT 401-588- 02 15.30 CHECK GEN 79137 TOTAL FOR FUND 1: 84.85 06/28/2023 GEN 79138* PHYLLIS LINDSTRAND DEP REFUND/APPLIED 235-000- 00 130.00 06/28/2023 GEN 79139 PLATZ, BRAD Cip - Residential 401-916- 07 25.00 06/28/2023 GEN 79140* PREMIUM WATERS INC OFFICE SUPPLIES -BOTTLED WATER 401-921- 08 32.49 06/28/2023 GEN 791414 PROCHASKA LLC CHLOR 125 (SANI-CHLOR) 154-000- 00 2,254.32 SULFURIC ACID 66 BE 154-000- 00 1,313.33 TAX 401-588- 02 245.54 CHECK GEN 79141 TOTAL FOR FUND 1: 3,813.19 06/28/2023 GEN 79142 QUALUS SERVICES, LLC Plant 41 Feeder Relay Testing 401-926- 08 8,500.00 06/28/2023 GEN 79143* QUINTEN PROEHL OR AKADIA HAGEN DEP REFUND/APPLIED 235-000- 00 78.00 DEP REFUND/APPLIED 235-000- 00 68.25 CHECK GEN 79143 TOTAL FOR FUND 1: 146.25 06/28/2023 GEN 79145 KID EQUIPMENT Power Equipment - Materials 402-598- 02 3,981.30 Power Equipment - Materials 402-598- 02 352.24 Power Equipment - Materials 402-598- 02 2,860.07 CHECK GEN 79145 TOTAL FOR FUND 1: 7,193.61 06/28/2023 GEN 79146* REBECCA OR KENNETH BOOIMAN DEP REFUND/APPLIED 235-000- 00 130.00 06/28/2023 GEN 79147 REINER, RICHARD Cip - Residential 401-916- 07 30.00 06/28/2023 GEN 79148* RELIANCE STANDARD LIFE -LIFE LTD INSURANCE-80o ELEC 242-000- 00 1,603.47 LIFE INSURANCE-80o ELEC 242-000- 00 1,022.72 07/19/2023 10:26 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/23/2023 - 07/20/2023 Payee Description Account Dept Page 9/32 Amount Fund: 1 ELECTRIC HECK GEN 79148 TOTAL FOR FUND 1: 2,626.19 06/28/2023 GEN 79149 REITMAN, ELDONNA Cip - Residential 401-916- 07 30.00 06/28/2023 GEN 79151 ROGER WERSAL Cip - Residential 401-916- 07 25.00 06/28/2023 GEN 791524 RS AMERICAS, INC. END PLATE, TERM ELK, ALTECH CORP 154-000- 00 32.20 CONNECTOR, TERMINAL BLOCK FUSE, 154-000- 00 70.00 FREIGHT 401-588- 02 8.76 HECK GEN 79152 TOTAL FOR FUND 1: 110.96 06/28/2023 GEN 7915314 RUNNING'S SUPPLY INC Sales Tax Receivable - Replace 186-000- 00 21.26 Sales Tax Receivable - Replace 186-000- 00 7.11 Accessory Plant - Materials 402-554- 01 269.99 Accessory Plant - Materials 402-554- 01 90.25 HECK GEN 79153 TOTAL FOR FUND 1: 388.61 06/28/2023 GEN 79154 RUSKAMP, LES Cip - Residential 401-916- 07 30.00 06/28/2023 GEN 79155* RYAN LUHMAN DEP REFUND/APPLIED 235-000- 00 117.00 06/28/2023 GEN 79157* SERENA ROEHL DEP REFUND/APPLIED 235-000- 00 48.75 06/28/2023 GEN 79158 SHARON SCHROEDER Cip - Residential 401-916- 07 30.00 06/28/2023 GEN 791594 T & R ELECTRIC SUPPLY CO INC TRANS, 225 KEA PAD, 3PH 208/120 154-000- 00 11,959.00 TRANS, 75 KVA PAD, 3PH 208/120 154-000- 00 9,356.00 TRANS, 112 KVA PAD, 3PH 208/120 154-000- 00 10,359.00 Sales Tax Receivable - Replace 186-000- 00 2,177.59 FUEL SURCHARGE 401-588- 02 17.81 HECK GEN 79159 TOTAL FOR FUND 1: 33,869.40 06/28/2023 GEN 79160* TAMI PICKELL OR GREG MCCORMICK DEP REFUND/APPLIED 235-000- 00 84.50 07/19/2023 10:26 AM CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES Page 10/32 User: JMartig CHECK DATE FROM 06/23/2023 - 07/20/2023 DE: Hutchinson Utili Check Date Bank Check # Payee Description Account Dept Amount Fund: 1 ELECTRIC 06/28/2023 GEN 791614 TANI DIVISION -BD SHIFFLER INC Sales Tax Receivable - Replace 186-000- 00 433.81 Unit 5 SCR Quote 23-061 402-554- 01 6,160.00 FREIGHT 401-588- 02 150.00 CHECK GEN 79161 TOTAL FOR FUND 1: 6,743.81 06/28/2023 GEN 79162 TANUSHREE SINGHAL OVERPAYMENTS 142-000- 00 213.21 06/28/2023 GEN 79163* THOMAS JANSICK GET REFUND/APPLIED 235-000- 00 162.50 06/28/2023 GEN 79164* TONY MOEN GET REFUND/APPLIED 235-000- 00 52.00 06/28/2023 GEN 79165 TRISHA BUBOLTZ OVERPAYMENTS 142-000- 00 38. 97 06/28/2023 GEN 79166* TROY PETERSEN GET REFUND/APPLIED 235-000- 00 169. 00 06/28/2023 GEN 79168* UNITED INFORMATION SERVICES, INC COLLECTION - MATERIALS 401-903- 06 1,914.86 06/28/2023 GEN 79169* VANESSA LANGE GET REFUND/APPLIED 235-000- 00 208.00 06/28/2023 GEN 79171* VIK'S LANDSCAPING & LAWN CARE, INC GROUNDS - OUTSIDE SERVICES 401-935- 08 3,762.00 GROUNDS - OUTSIDE SERVICES 401-935- 08 4,060.38 CHECK GEN 79171 TOTAL FOR FUND 1: 7,822.38 06/28/2023 GEN 79172 VONBERG, CINDY Cip - Residential 401-916- 07 30.00 06/28/2023 GEN 791734 WARTSILA OF NORTH AMERICA, INC SPINDLE, 352 378 154-000- 00 112.11 NUT, 352 379 154-000- 00 2.70 SEALING RING, 352 381 154-000- 00 5.93 PLATE, PRESSURE, SIDE COVER 154-000- 00 984.28 Sales Tax Receivable - New 186-000- 00 82.07 FREIGHT 401-588- 02 88.72 CHECK GEN 79173 TOTAL FOR FUND 1: 1,275.81 07/19/2023 10:26 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK Payee DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/23/2023 - 07/20/2023 Description Account Dept Page 11/32 Amount Fund: 1 ELECTRIC 06/28/2023 GEN 79174 YOUNG, WILLIAM Cip - Residential 401-916- 07 500.00 06/28/2023 GEN 79175* YRC FREIGHT MAIL SERVICES - UPS, FEDEX 401-921- 08 116.25 06/28/2023 GEN 79176* ZACHARY GRESSEL DEP REFUND/APPLIED 235-000- 00 240.50 07/01/2023 GEN 1454(E)* GUARDIAN DENTAL INSURANCE-80o ELEC 242-000- 00 3,554.93 DENTAL INSURANCE -COBRA 242-000- 00 457.01 HECK GEN 1454(E) TOTAL FOR FUND 1: 4,011.94 07/05/2023 GEN 1456(E) ALERUS Health Insurance 401-926- 08 219.01 07/05/2023 GEN 1462(E)* CITIZENS BANK Office Supplies 401-921- 08 88.16 07/05/2023 GEN 1463(E)* PAY MENTECH collection - Materials 401-903- 06 1,769.59 07/05/2023 GEN 1473(E) MISO Accounts Payable - Miso 232-000- 00 17,133.57 07/05/2023 GEN 1474(E) MISO Accounts Payable - Miso 232-000- 00 948.89 07/10/2023 GEN 1464(E)* INVOICE CLOUD collection - Materials 401-903- 06 1,667.25 07/11/2023 GEN 1471(E) MISO Accounts Payable - Miso 232-000- 00 35,759.81 07/11/2023 GEN 1472(E) MISO Accounts Payable - Miso 232-000- 00 917.64 07/12/2023 GEN 1457(E) ALERUS HEALTH INSURANCE - BADKE 242-000- 00 56. 90 07/12/2023 GEN 1458(E)* CITIZENS BANK collection - Materials 401-903- 06 910.49 07/12/2023 GEN 79178*4 ACE HARDWARE Sales Tax Receivable - Replace 186-000- 00 0.63 Sales Tax Receivable - Replace 186-000- 00 0.11 Supplies 401-550- 01 9.18 Accessory Plant - Materials 402-554- 01 9.18 07/19/2023 10:26 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/23/2023 - 07/20/2023 Payee Description Account Dept Page 12/32 Amount Fund: 1 ELECTRIC Accessory Plant - Materials 402-554- 01 1.59 Maintenance Other - Materials 402-554- 01 12.76 Grounds - Materials 401-935- 08 7.36 HECK GEN 79178 TOTAL FOR FUND 1: 40.81 07/12/2023 GEN 79179 ANN KRAUSE OVERPAYMENTS 142-000- 00 90.67 07/12/2023 GEN 79180*4 ATLAS TOYOTA LIFT OF MINNESOTA Outside Services 402-554- 01 160.11 Outside Services 402-554- 01 109.00 Power Equipment - Materials 402-598- 02 80.24 Power Equipment - Materials 402-598- 02 64.54 Power Equipment - Materials 402-598- 02 54.50 Power Equipment - Materials 402-598- 02 54.50 HECK GEN 79180 TOTAL FOR FUND 1: 522.89 07/12/2023 GEN 79181 BASSLER, MITCH Materials 401-588- 02 160.00 07/12/2023 GEN 79182*4 BORDER STATES ELECTRIC SUPPLY CONDUCTOR, 350 MCM 600V URD TRIPLEX 154-000- 00 17,769.00 Distribution Inventory 154-000- 00 0.18 DISPENSER, TAPE, SLW WRITE -ON WITH SMP 154-000- 00 46.34 FLOOD SEAL, COVERS (LONG) FSS 350L 154-000- 00 519.84 CONNECTOR, PEDESTAL, 500 MCM 6 PLACE, 154-000- 00 1,023.20 SPLICE, 4/0 AL/CU YSD28R28R 154-000- 00 85.50 KIT, T-OP, COMPLETE ASSEMBLY, 600A 154-000- 00 4,301.64 Sales Tax Receivable - New 186-000- 00 1,221.63 Sales Tax Receivable - New 186-000- 00 115.15 Sales Tax Receivable - New 186-000- 00 295.74 HECK GEN 79182 TOTAL FOR FUND 1: 25,378.22 07/12/2023 GEN 79183*4 BRANDED SOLUTIONS Uniforms & Laundry 401-550- 01 454.61 Uniforms & Laundry 401-588- 02 454.61 HECK GEN 79183 TOTAL FOR FUND 1: 909.22 07/12/2023 GEN 79185 CARBON DAY AUTOMOTIVE Structures & Equipment - Mater 402-592- 02 2,143.00 07/19/2023 10:26 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/23/2023 - 07/20/2023 Payee Description Account Dept Page 13/32 Amount Fund: 1 ELECTRIC 07/12/2023 GEN 79186 CCP INDUSTRIES, INC Line - Materials 401-581- 02 164.24 07/12/2023 GEN 79187 CENTRAL HYDRAULICS Vehicles - Material 402-598- 02 12.42 Power Equipment - Materials 402-598- 02 6.21 Power Equipment - Materials 402-598- 02 (12.42) HECK GEN 79187 TOTAL FOR FUND 1: 6.21 07/12/2023 GEN 791894 CHAMBERLAIN OIL COMPANY INC AERO SHELL TURBINE OIL 500 154-000- 00 12,203.84 Sales Tax Receivable - Replace 186-000- 00 839.01 DRUM DEPOSIT 401-550- 01 80.00 TAX 401-588- 02 5.50 to DISCOUNT FOR EARLY PMT 401-588- 02 (61.42) HECK GEN 79189 TOTAL FOR FUND 1: 13,066.93 07/12/2023 GEN 79190 CHRIS BLOMMER OVERPAYMENTS 142-000- 00 136.89 07/12/2023 GEN 79191*4 CINTAS CORPORATION 4470 Uniforms & Laundry 401-550- 01 857.07 Uniforms & Laundry 401-550- 01 250.94 Uniforms & Laundry 401-550- 01 250.94 UNIFORMS & LAUNDRY 401-588- 02 107.15 UNIFORMS & LAUNDRY 401-588- 02 151.33 UNIFORMS & LAUNDRY 401-588- 02 151.33 HECK GEN 79191 TOTAL FOR FUND 1: 1,768.76 07/12/2023 GEN 79192*4 CITY OF HUTCHINSON 3RD QTR PILOT 70/30 234-000- 00 333,293.80 VEHICLE/EQUIPMENT FUEL -POWER 401-550- 01 203.80 VEHICLES/EQUIPMENT FUEL-ELEC 401-588- 02 1,652.74 IT ADMIN AND SUPPORT 75/25 401-921- 08 21, 746.44 LEGAL SERVICES 75/25 401-923- 08 7,875.00 VEHICLES/EQUIPMENT FUEL-ADMIN 55/45 401-935- 08 56.22 HECK GEN 79192 TOTAL FOR FUND 1: 364,828.00 07/12/2023 GEN 79193 GAKODA JOHNSON OVERPAYMENTS 142-000- 00 33.22 07/19/2023 10:26 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/23/2023 - 07/20/2023 Payee Description Account Dept Page 14/32 Amount Fund: 1 ELECTRIC 07/12/2023 GEN 791944 DESIGN ELECTRIC, INC Sales Tax Receivable - Replace 186-000- 00 1.71 Accessory Plant - Materials 402-554- 01 24.83 Maintenance Other - Materials 402-554- 01 19.70 HECK GEN 79194 TOTAL FOR FUND 1: 46.24 07/12/2023 GEN 79195 DIEGO MENDIOLA OVERPAYMENTS 142-000- 00 9.71 OVERPAYMENTS 142-000- 00 24.49 HECK GEN 79195 TOTAL FOR FUND 1: 34.20 07/12/2023 GEN 79198 ERIC WANGEN OVERPAYMENTS 142-000- 00 782.89 07/12/2023 GEN 79199 FASTENAL COMPANY Maintenance Other - Materials 402-554- 01 101.33 Maintenance Other - Materials 402-554- 01 11.71 HECK GEN 79199 TOTAL FOR FUND 1: 113.04 07/12/2023 GEN 792004 FORBES AUTO STORE Sales Tax Receivable - Replace 186-000- 00 1.26 Accessory Plant - Materials 402-554- 01 15.99 Maintenance Other - Materials 402-554- 01 22.64 Maintenance Other - Materials 402-554- 01 (22.64) HECK GEN 79200 TOTAL FOR FUND 1: 17.25 07/12/2023 GEN 79201 FOSTER MECHANICAL Maintenance Other - Materials 402-554- 01 67.33 07/12/2023 GEN 7920214 GOPHER STATE ONE -CALL INC Line - Materials 401-581- 02 228.83 07/12/2023 GEN 79203* HILLYARD/HUTCHINSON Grounds - Materials 401-935- 08 70.93 07/12/2023 GEN 79204* HUTCHFIELD SERVICES Grounds - Outside Services 401-935- 08 1,093.21 07/12/2023 GEN 79206*4 HUTCHINSON LEADER Cip - Marketing 401-916- 07 333.00 Advertising/Printing 401-921- 08 109.45 07/19/2023 10:26 AM CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES User: JMartig CHECK DATE FROM 06/23/2023 - 07/20/2023 DE: Hutchinson Utili Check Date Bank Check # Payee Description Fund: 1 ELECTRIC HECK GEN 79206 TOTAL FOR FUND 1: 07/12/2023 GEN 792074 HUTCHINSON WHOLESALE SUPPLY CO Vehicles - Material Vehicles - Material HECK GEN 79207 TOTAL FOR FUND 1: 07/12/2023 GEN 79208 JORDAN OR JAYLENE VLIET OVERPAYMENTS 07/12/2023 GEN 79209 JULIO CARPIO OR JESSICA DIAZ OVERPAYMENTS 07/12/2023 GEN 79212 KERSTIN SANDERS OVERPAYMENTS 07/12/2023 GEN 792134 KURITA AMERICA INC 07/12/2023 GEN 79215 MAIERS, LARRY 07/12/2023 GEN 792161 MARCO TECHNOLOGIES, LLC 07/12/2023 GEN 792174 MATHESON TRI-GAS INC 07/12/2023 GEN 79218 MAYNOR DANIEL MUNGUTA AGUILAR 07/12/2023 GEN 792194 MCC ENERGY SOLUTIONS, LLC 07/12/2023 GEN 792204 MCMASTER-CARR SUPPLY COMPANY Sales Tax Receivable - Replace Accessory Plant - Materials HECK GEN 79213 TOTAL FOR FUND 1 Cip - Residential OFFICE SUPPLIES Sales Tax Receivable - Replace Generator 41 Material HECK GEN 79217 TOTAL FOR FUND 1 OVERPAYMENTS I AM MANAGEMENT FEES IAM USAGE FEES HECK GEN 79219 TOTAL FOR FUND 1: GAUGE, 0-160, 2 1/2", 1/4" BOTTOM Sales Tax Receivable - Replace FREIGHT Account Dept 402-554- 01 402-598- 02 142-000- 00 142-000- 00 142-000- 00 186-000- 00 402-554- 01 401-916- 07 401-921- 08 186-000- 00 402-554- 01 142-000- 00 401-555- 02 401-556- 03 154-000- 00 186-000- 00 401-588- 02 Page 15/32 Amount 442.45 14.94 290.09 75.96 23.91 10.59 30.00 568.52 13.91 118.25 3,900.00 246.96 20.39 07/19/2023 10:26 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/23/2023 - 07/20/2023 Payee Description Account Dept Page 16/32 Amount Fund: 1 ELECTRIC HECK GEN 79220 TOTAL FOR FUND 1: 279.26 07/12/2023 GEN 79221 MONTANNA NEWCOMBE OR NEVAEH GOLSEN OVERPAYMENTS 142-000- 00 43.11 07/12/2023 GEN 792224 NELSON TECHNOLOGIES INC VALVE, GAS BLOW OFF, W/SOLENOID, 154-000- 00 645.00 Sales Tax Receivable - Replace 186-000- 00 45.99 FREIGHT 401-588- 02 23.93 HECK GEN 79222 TOTAL FOR FUND 1: 714.92 07/12/2023 GEN 79223 NICK KAYSER OVERPAYMENTS 142-000- 00 29.45 07/12/2023 GEN 79225* NUVERA TELEPHONE 401-921- 08 1,942.44 07/12/2023 GEN 79226*4 O'REILLY AUTOMOTIVE INC Vehicles - Material 402-554- 01 8.19 07/12/2023 GEN 79227* ONSOLVE, LLC COLLECTION - MATERIALS 401-903- 06 75.00 07/12/2023 GEN 79229*4 OXYGEN SERVICE COMPANY INC Supplies 401-550- 01 106.75 Supplies 401-550- 01 91.74 Supplies 401-550- 01 83.82 HECK GEN 79229 TOTAL FOR FUND 1: 282.31 07/12/2023 GEN 79230 PAYTON NORSWORTHY OVERPAYMENTS 142-000- 00 257.28 07/12/2023 GEN 792324 PROCHASKA LLC Sales Tax Receivable - Replace 186-000- 00 266.85 TAX 401-588- 02 (245.54) FREIGHT 401-588- 02 313.75 HECK GEN 79232 TOTAL FOR FUND 1: 335.06 07/12/2023 GEN 792334 PSI ENGINEERING LLC Sales Tax Receivable - Replace 186-000- 00 196.27 Shaft Sleeve 9900650-002 402-554- 01 2,477.00 FREIGHT 401-588- 02 15.17 HECK GEN 79233 TOTAL FOR FUND 1: 2,688.44 07/19/2023 10:26 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/23/2023 - 07/20/2023 Description Fund: 1 ELECTRIC 07/12/2023 GEN 79234* RATH RACING, INC 07/12/2023 GEN 792354 RUNNING'S SUPPLY INC 07/12/2023 GEN 79236* SHRED RIGHT 07/12/2023 GEN 79237 SNOW WHITE COTTAGES 07/12/2023 GEN 79239 TERESA AMBERG 07/12/2023 GEN 79240 TESTO 07/12/2023 GEN 79241 TIMOTHY OR LAURIE BEHR 07/12/2023 GEN 79243* UNITED PARCEL SERVICE 07/12/2023 GEN 79244* VERIZON WIRELESS 07/12/2023 GEN 79245 WANDA BUTTERFIELD 07/12/2023 GEN 792464 WAYTEK 07/12/2023 GEN 79247 WILD FLOWER PROPERTIES 07/12/2023 GEN 79248 WILD FLOWER PROPERTIES 07/12/2023 GEN 79249 ZIEGLER POWER SYSTEMS Account Dept Page 17/32 Amount Grounds - Materials 401-935- 08 159.37 Sales Tax Receivable - Replace 186-000- 00 3.10 Accessory Plant - Materials 402-554- 01 39.36 Accessory Plant - Materials 402-554- 01 2.47 HECK GEN 79235 TOTAL FOR FUND 1: 44.93 OFFICE SUPPLIES -SHREDDING SERVICES 401-921- 08 15.47 OVERPAYMENTS 142-000- 00 214.49 OVERPAYMENTS 142-000- 00 39. 46 Testo 34 Kit43 per Quote 23788899 402-554- 01 7,315.10 OVERPAYMENTS 142-000- 00 17.68 MAIL SERVICES - UPS, FEDEX 401-921- 08 163.19 TELEPHONE 401-921- 08 1,036.40 OVERPAYMENTS 142-000- 00 23.81 SPADE CONNECTOR, 16-14 AWG 2.56 154-000- 00 20.00 FREIGHT 401-588- 02 17.19 HECK GEN 79246 TOTAL FOR FUND 1: 37.19 OVERPAYMENTS 142-000- 00 602.65 OVERPAYMENTS 142-000- 00 540.02 2 55 gallon drums Cat NGEO Oil 3368866 401-550- 01 2,332.00 CAT OIL 401-550- 01 0.92 4C4612 Cleaner 402-554- 01 2,841.24 07/19/2023 10:26 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/23/2023 - 07/20/2023 Payee Description Account Dept Page 18/32 Amount Fund: 1 ELECTRIC HECK GEN 79249 TOTAL FOR FUND 1: 5,174.16 07/12/2023 GEN 79250 UPONOR State Sales Tax 242-000- 00 3,408.83 City Sales Tax 242-000- 00 247.91 COUNTY SALES TAX 242-000- 00 247. 92 Large General Service 400-442- 00 137,730.46 HECK GEN 79250 TOTAL FOR FUND 1: 141,635.12 07/12/2023 GEN 8(S) LUBE-TECH & PARTNERS, LLC Supplies 401-550- 01 584.70 Supplies 401-550- 01 (584.70) HECK GEN 8(S) TOTAL FOR FUND 1: 0.00 07/12/2023 GEN 9(S) VIKING ELECTRIC RTL 3397668 SK Compressor 402-554- 01 727.89 S3988991000 COMPRESSOR FOR 3304500 402-554- 01 (727.89) HECK GEN 9(S) TOTAL FOR FUND 1: 0.00 07/16/2023 GEN 1459(E)*4 VISA FRAUD 186-000- 00 6.00 Sales Tax Receivable - Replace 186-000- 00 15.55 Sales Tax Receivable - Replace 186-000- 00 7.87 Sales Tax Receivable - Replace 186-000- 00 4.85 Sales Tax Receivable - Replace 186-000- 00 3.25 Meetings & Travel - Expense (S 401-546- 01 959.19 Generator 41 Material 402-554- 01 5,605.49 Generator 41 Material 402-554- 01 90.36 Generator 41 Outside Services 402-554- 01 1,718.78 Accessory Plant - Materials 402-554- 01 99.90 Accessory Plant - Materials 402-554- 01 199.90 Accessory Plant - Materials 402-554- 01 41.41 Accessory Plant - Materials 402-554- 01 61.56 Maintenance Other - Materials 402-554- 01 83.28 Meetings & Travel - Expense (S 401-580- 02 485.00 Meetings & Travel - Expense (S 401-580- 02 135.00 Line - Materials 401-581- 02 51.76 07/19/2023 10:26 AM CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES User: JMartig CHECK DATE FROM 06/23/2023 - 07/20/2023 DE: Hutchinson Utili Check Date Bank Check # Payee Description Account Dept Fund: 1 ELECTRIC Line - Materials 401-581- 02 Line - Materials 401-581- 02 Vehicles - Material 402-598- 02 Vehicles - Material 402-598- 02 Office Supplies 401-921- 08 Breakroom/Recognition Banquet 401-926- 08 Training - Expense 401-930- 08 HECK GEN 1459(E) TOTAL FOR FUND 1: 07/17/2023 GEN 1466(E) MISO SCHEDULE 10 401-565- 03 07/17/2023 GEN 1467(E) MISO SCHEDULE 1 401-565- 03 SCHEDULE 26 401-565- 03 SCHEDULE 10 401-565- 03 HECK GEN 1467(E) TOTAL FOR FUND 1: 07/17/2023 GEN 1468(E) MISO SCHEDULE 26 401-565- 03 SCHEDULE 26A 401-565- 03 SCHEDULE 26E 401-565- 03 HECK GEN 1468(E) TOTAL FOR FUND 1: 07/18/2023 GEN 1469(E) MISO Accounts Payable - Miso 232-000- 00 07/18/2023 GEN 1470(E) MISO Accounts Payable - Miso 232-000- 00 07/19/2023 GEN 1478(E)* STATE OF MINNESOTA State Sales Tax 242-000- 00 City Sales Tax 242-000- 00 COUNTY SALES TAX 242-000- 00 HECK GEN 1478(E) TOTAL FOR FUND 1: 07/20/2023 GEN 1460(E)*4 BP CANANDA ENERGY SOLUTIONS GENERATOR 41 NATURAL GAS 401-547- 01 GENERATOR 41 NATURAL GAS 401-547- 01 Generator 41 Aux Boiler 401-547- 01 GENERATOR 45 NATURAL GAS 401-547- 01 Page 19/32 Amount 07/19/2023 10:26 AM CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES Page 20/32 User: JMartig CHECK DATE FROM 06/23/2023 - 07/20/2023 DE: Hutchinson Utili Check Date Bank Check # Payee Description Account Dept Amount Fund: 1 ELECTRIC GENERATOR 45 NATURAL GAS 401-547- 01 37.04 GENERATOR 46 NATURAL GAS 401-547- 01 13,844.50 GENERATOR 46 NATURAL GAS 401-547- 01 45.14 Generator 47 Natural Gas 401-547- 01 10,788.25 Generator 47 Natural Gas 401-547- 01 45.14 Generator 49 Natural Gas 401-547- 01 115.74 Utility Expenses - Water/Waste 401-930- 08 394.04 HECK GEN 1460(E) TOTAL FOR FUND 1: 124,469.20 Total for fund 1 ELECTRIC 1,552,525.98 07/19/2023 10:26 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/23/2023 - 07/20/2023 Payee Description Account Dept Page 21/32 Amount Fund: 2 GAS 06/23/2023 GEN 1437(E)*4 BP CANANDA ENERGY SOLUTIONS Gas For Retail 401-807- 04 (1,136.27) GAS FOR RETAIL 401-807- 04 ;70,652.40) 3M 401-807- 04 234,522.23 HTI 401-807- 04 2,955.24 UNG 401-807- 04 373.59 BROWNTON 401-807- 04 1,199.06 Utility Expenses - Water/Waste 401-930- 08 1,817.69 HECK GEN 1437(E) TOTAL FOR FUND 2: 169,079.14 06/27/2023 GEN 1453(E)* ALERUS HEALTH INSURANCE 401-926- 08 129.06 06/28/2023 GEN 79056*4 ACE HARDWARE Materials 401-874- 04 42.73 Materials 402-892- 04 1.71 HECK GEN 79056 TOTAL FOR FUND 2: 44.44 06/28/2023 GEN 79057* AEM MECHANICAL SERVICES DEP REFUND/APPLIED 235-000- 00 287.00 06/28/2023 GEN 79058* ALEJANDRA BUSTOS MEDIA OR DEP REFUND/APPLIED 235-000- 00 40.25 06/28/2023 GEN 79059* AMANDA OR JOSH ZIMMERMANN DEP REFUND/APPLIED 235-000- 00 84.00 06/28/2023 GEN 79060* ANDREW CHILADEK DEP REFUND/APPLIED 235-000- 00 21.00 06/28/2023 GEN 79062*4 ATLAS TOYOTA LIFT OF MINNESOTA Power Equipment - Materials 402-895- 04 381.88 06/28/2023 GEN 79063* AUSTIN FIELD DEP REFUND/APPLIED 235-000- 00 70.00 06/28/2023 GEN 79064* BARBARA CHRISTOPHER DEP REFUND/APPLIED 235-000- 00 21.00 06/28/2023 GEN 79065* BEN HOFFMAN OR TAYLA CARD DEP REFUND/APPLIED 235-000- 00 119.00 07/19/2023 10:26 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/23/2023 - 07/20/2023 Description Fund: 2 GAS 06/28/2023 GEN 79066 BENJAMIN, CYNTHIA 06/28/2023 GEN 79068*4 BORDER STATES ELECTRIC SUPPLY 06/28/2023 GEN 79069* BRANDON LUNKLEY 06/28/2023 GEN 79070* BRANDSOY, DALE 06/28/2023 GEN 79072* CALYN LANDFAIR 06/28/2023 GEN 79073* CARMEN JAMES 06/28/2023 GEN 79075* CARTER, JEREMY J 06/28/2023 GEN 79076* CHAD OR MICHELLE PEDERSON 06/28/2023 GEN 79078*4 CINTAS CORPORATION 4470 Account Dept Page 22/32 Amount Cip - Residential 401-916- 07 350.00 ELL, FEMALE THRD, 90 DEG, 1", BM, CLASS 154-000- 00 36.10 TAPE, TEFLON, 1/2" X 260", HIGH 154-000- 00 7.84 CAP, FEMALE THRD, 1", BM, CLASS 150 154-000- 00 28.40 THREAD-O-LET, 1/4" X 2 1/2" X 1 1/4", 154-000- 00 111.02 ELL, STREET, 90 DEG, 1", BM, CLASS 150 154-000- 00 55.22 TEE, WELD FITTING, STRAIGHT, 2", SMLS, 154-000- 00 99. 54 ELL, WELD FITTING, 90 DEG, 2", SMLS, 154-000- 00 27.86 CAP, 2", SMLS WELD FITTING , STD WGHT 154-000- 00 104.56 TAX 401-874- 04 2.48 Materials 401-874- 04 0.54 TAX 401-874- 04 9.58 Materials 401-874- 04 108.21 SALES TAX 401-874- 04 19.75 HECK GEN 79068 TOTAL FOR FUND 2: 611.10 DEP REFUND/APPLIED 235-000- 00 70.00 Cip - Residential 401-916- 07 350.00 Training - Expense 401-903- 06 145.29 DEP REFUND/APPLIED 235-000- 00 26.25 Training - Expense 401-930- 08 242.19 DEP REFUND/APPLIED 235-000- 00 31.50 UNIFORMS & LAUNDRY 401-880- 04 82.04 UNIFORMS & LAUNDRY 401-880- 04 71.29 07/19/2023 10:26 AM CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES Page 23/32 User: JMartig CHECK DATE FROM 06/23/2023 - 07/20/2023 DE: Hutchinson Utili Check Date Bank Check # Payee Description Account Dept Amount Fund: 2 GAS UNIFORMS & LAUNDRY 401-880- 04 71.29 HECK GEN 79078 TOTAL FOR FUND 2: 224.62 06/28/2023 GEN 79079*4 CITY OF HUTCHINSON IT ADMIN AND SUPPORT 75/25 401-921- 08 1,135.48 Utility Expenses - Water/Waste 401-930- 08 10.17 Utility Expenses - Water/Waste 401-930- 08 434.57 HECK GEN 79079 TOTAL FOR FUND 2: 1,580.22 06/28/2023 GEN 79083* DANIEL HUNTLEY DEP REFUND/APPLIED 235-000- 00 43.75 06/28/2023 GEN 79084* DAVID OR DARLENE THEIS DEP REFUND/APPLIED 235-000- 00 70.00 06/28/2023 GEN 79086* DEPARTMENT OF THE TREASURY Health Insurance 242-000- 00 32.40 06/28/2023 GEN 79091* DONAVON DECKER DEP REFUND/APPLIED 235-000- 00 35.00 06/28/2023 GEN 79092*4 E2 ELECTRIC Tools, Shop & Garage Equipment 107-394- 00 3,266.71 06/28/2023 GEN 79093 EGGERS, HEIDI Cip - Residential 401-916- 07 350.00 06/28/2023 GEN 79094* ELEONORA PERNILLADOTTER DEP REFUND/APPLIED 235-000- 00 52.50 06/28/2023 GEN 79095* EMMA OR SPENCER LIGHTFIELD DEP REFUND/APPLIED 235-000- 00 136.50 06/28/2023 GEN 79096* ERIK WILLIAMS DEP REFUND/APPLIED 235-000- 00 49. 00 06/28/2023 GEN 79097 FASTENAL COMPANY Materials 401-856- 05 27.80 06/28/2023 GEN 79098* FIRST CHOICE FOOD & BEVERAGE BREAKROOM/RECOGNITION BANQUET 401-926- 08 110.00 06/28/2023 GEN 79103 GROEBNER & ASSOCIATES INC Materials 401-874- 04 663.32 07/19/2023 10:26 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/23/2023 - 07/20/2023 Payee Description Account Dept Page 24/32 Amount Fund: 2 GAS Base Repair 6" Turbine Meter WATMOS 416-108- 04 2,700.29 HP Refurbishment, 2" - 6" Turbine Meter 416-108- 04 2,649.07 Additional Parts for AAT-35 Repair 416-108- 04 397.63 CHECK GEN 79103 TOTAL FOR FUND 2: 6,410.31 06/28/2023 GEN 79105* HAGER JEWELRY INC Office Supplies 401-921- 08 19.80 06/28/2023 GEN 79106* HEALTH PARTNERS HEALTH INSURANCE-15o GAS 242-000- 00 11, 359.69 06/28/2023 GEN 79107* HEIDI KIRCHNER DEP REFUND/APPLIED 235-000- 00 35.00 06/28/2023 GEN 79108* HUNTER HOFF OR LILLIAN KASPER DEP REFUND/APPLIED 235-000- 00 26.25 06/28/2023 GEN 79109*4 HUTCHINSON LEADER Cip - Marketing 401-916- 07 250.65 Advertising/Printing 401-921- 08 343.96 CHECK GEN 79109 TOTAL FOR FUND 2: 594.61 06/28/2023 GEN 79110*4 HUTCHINSON WHOLESALE SUPPLY CO Materials 402-892- 04 33.12 Materials 402-863- 05 180.67 Materials 402-863- 05 178.96 CHECK GEN 79110 TOTAL FOR FUND 2: 392.75 06/28/2023 GEN 79111* JANIE GARCIA DEP REFUND/APPLIED 235-000- 00 31.50 06/28/2023 GEN 79112* JILL STAUB DEP REFUND/APPLIED 235-000- 00 59.50 06/28/2023 GEN 79113 JMS CONCRETE Materials 402-892- 04 895.00 06/28/2023 GEN 79114* JODY SELSETH DEP REFUND/APPLIED 235-000- 00 40.25 06/28/2023 GEN 79115* JOSHUA SCHANTZEN DEP REFUND/APPLIED 235-000- 00 38.50 07/19/2023 10:26 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/23/2023 - 07/20/2023 Payee Description Account Dept Page 25/32 Amount Fund: 2 GAS 06/28/2023 GEN 79116* KARL OR LAURETTA MADSEN GET REFUND/APPLIED 235-000- 00 89.25 06/28/2023 GEN 79118* KEVIN FISHER GET REFUND/APPLIED 235-000- 00 22.75 GET REFUND/APPLIED 235-000- 00 26.25 HECK GEN 79118 TOTAL FOR FUND 2: 49.00 06/28/2023 GEN 79120* KYLE STENMARK GET REFUND/APPLIED 235-000- 00 84.00 06/28/2023 GEN 79121* LAUER, TAMMY Cip - Residential 401-916- 07 50.00 06/28/2023 GEN 79122* LAYLA KREUSER-CASTILLO GET REFUND/APPLIED 235-000- 00 80.50 06/28/2023 GEN 79123* LISSA MICHALSKY OR DANIEL EVERSON GET REFUND/APPLIED 235-000- 00 143.50 06/28/2023 GEN 79124* LOGAN OR MICHELLE SOWERS GET REFUND/APPLIED 235-000- 00 52.50 06/28/2023 GEN 79125* MADELINE LOFSTEDT GET REFUND/APPLIED 235-000- 00 61.25 06/28/2023 GEN 79128* MARILEE CALLAN GET REFUND/APPLIED 235-000- 00 26.25 06/28/2023 GEN 79129* MARY NIECE GET REFUND/APPLIED 235-000- 00 47.25 06/28/2023 GEN 791344 NOVASPECT INC FE107 RS-232 COM MODULE 107-370- 00 309.60 FREIGHT 401-874- 04 26.15 HECK GEN 79134 TOTAL FOR FUND 2: 335.75 06/28/2023 GEN 79135 NOVOTNY, FRANK Cip - Residential 401-916- 07 300.00 06/28/2023 GEN 79138* PHYLLIS LINDSTRAND GET REFUND/APPLIED 235-000- 00 70.00 07/19/2023 10:26 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/23/2023 - 07/20/2023 Payee Description Account Dept Page 26/32 Amount Fund: 2 GAS 06/28/2023 GEN 79140* PREMIUM WATERS INC OFFICE SUPPLIES -BOTTLED WATER 401-921- 08 10.83 06/28/2023 GEN 79143* QUINTEN PROEHL OR AKADIA HAGEN DEP REFUND/APPLIED 235-000- 00 42.00 DEP REFUND/APPLIED 235-000- 00 36.75 HECK GEN 79143 TOTAL FOR FUND 2: 78.75 06/28/2023 GEN 79144 RAYMOND, LOUIS Cip - Residential 401-916- 07 300.00 06/28/2023 GEN 79146* REBECCA OR KENNETH BOOIMAN DEP REFUND/APPLIED 235-000- 00 70.00 06/28/2023 GEN 79148* RELIANCE STANDARD LIFE -LIFE LTD INSURANCE-20o GAS 242-000- 00 400.87 LIFE INSURANCE-20o GAS 242-000- 00 255.68 HECK GEN 79148 TOTAL FOR FUND 2: 656.55 06/28/2023 GEN 791504 RHINO MARKING & PROTECTION SYSTEMS MARKER, YELLOW HYBRID 3-RAIL, 62" 154-000- 00 645.00 FREIGHT 401-874- 04 117.59 HECK GEN 79150 TOTAL FOR FUND 2: 762.59 06/28/2023 GEN 79153*4 RUNNING'S SUPPLY INC Materials 401-874- 04 (9.37) Materials 402-863- 05 107.85 HECK GEN 79153 TOTAL FOR FUND 2: 98.48 06/28/2023 GEN 79155* RYAN LUHMAN DEP REFUND/APPLIED 235-000- 00 63.00 06/28/2023 GEN 791564 SCHWEITZER ENGINEERING SEL 3505-3 RTAC 107-370- 00 1,718.20 SALES TAX 401-874- 04 118.13 HECK GEN 79156 TOTAL FOR FUND 2: 1,836.33 06/28/2023 GEN 79157* SERENA ROEHL DEP REFUND/APPLIED 235-000- 00 26.25 07/19/2023 10:26 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/23/2023 - 07/20/2023 Payee Description Account Dept Page 27/32 Amount Fund: 2 GAS 06/28/2023 GEN 79160* TAMI PICKELL OR GREG MCCORMICK DEP REFUND/APPLIED 235-000- 00 45.50 06/28/2023 GEN 79163* THOMAS JANSICK DEP REFUND/APPLIED 235-000- 00 87.50 06/28/2023 GEN 79164* TONY MOEN DEP REFUND/APPLIED 235-000- 00 28.00 06/28/2023 GEN 79166* TROY PETERSEN DEP REFUND/APPLIED 235-000- 00 91.00 06/28/2023 GEN 79167 UNDESSER, MARK Cip - Residential 401-916- 07 25.00 06/28/2023 GEN 79168* UNITED INFORMATION SERVICES, INC COLLECTION - MATERIALS 401-903- 06 1,566.71 06/28/2023 GEN 79169* VANESSA LANGE DEP REFUND/APPLIED 235-000- 00 112.00 06/28/2023 GEN 79170 VERIZON WIRELESS UTILITIES (ELECTRIC, SATELLITE-SCADA 401-856- 05 312.20 06/28/2023 GEN 79171* VIK'S LANDSCAPING & LAWN CARE, INC GROUNDS - OUTSIDE SERVICES 401-935- 08 3,078.00 GROUNDS - OUTSIDE SERVICES 401-935- 08 3,322.12 CHECK GEN 79171 TOTAL FOR FUND 2: 6,400.12 06/28/2023 GEN 79175* YRC FREIGHT MAIL SERVICES - UPS, FEDEX 401-921- 08 38.75 06/28/2023 GEN 79176* ZACHARY GRESSEL DEP REFUND/APPLIED 235-000- 00 129.50 06/28/2023 GEN 79177 ZELM, JEFF Cip - Residential 401-916- 07 350.00 07/01/2023 GEN 1454(E)* GUARDIAN DENTAL INSURANCE-20o GAS 242-000- 00 888.74 07/05/2023 GEN 1462(E)* CITIZENS BANK Office Supplies 401-921- 08 88.15 07/05/2023 GEN 1463(E)* PAY MENTECH Collection - Materials 401-903- 06 1,447.84 07/19/2023 10:26 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/23/2023 - 07/20/2023 Payee Description Account Dept Page 28/32 Amount Fund: 2 GAS 07/10/2023 GEN 1464(E)* INVOICE CLOUD collection - Materials 401-903- 06 1,364.11 07/12/2023 GEN 1458(E)* CITIZENS BANK collection - Materials 401-903- 06 744.94 07/12/2023 GEN 79178*4 ACE HARDWARE Materials 401-874- 04 7.67 Materials 402-892- 04 20.48 Grounds - Materials 401-935- 08 7.37 HECK GEN 79178 TOTAL FOR FUND 2: 35.52 07/12/2023 GEN 79180*4 ATLAS TOYOTA LIFT OF MINNESOTA Power Equipment - Materials 402-895- 04 80.25 Power Equipment - Materials 402-895- 04 64.54 Power Equipment - Materials 402-895- 04 54.50 Power Equipment - Materials 402-895- 04 54.50 HECK GEN 79180 TOTAL FOR FUND 2: 253.79 07/12/2023 GEN 79182*4 BORDER STATES ELECTRIC SUPPLY REDUCER, SWAGE, 2" X 1", STD, BLE X ISE 154-000- 00 99. 88 TAX 401-874- 04 6.87 HECK GEN 79182 TOTAL FOR FUND 2: 106.75 07/12/2023 GEN 79183*4 BRANDED SOLUTIONS Uniforms & Laundry 401-880- 04 454.60 07/12/2023 GEN 79184 BROWN COUNTY RURAL ELECTRIC Utilities (Electric, Satellite 401-856- 05 196.76 07/12/2023 GEN 79188 CENTURYLINK Utilities (Electric, Satellite 401-856- 05 67.16 07/12/2023 GEN 79191*4 CINTAS CORPORATION 4470 UNIFORMS & LAUNDRY 401-880- 04 107.15 UNIFORMS & LAUNDRY 401-880- 04 82.04 UNIFORMS & LAUNDRY 401-880- 04 82.04 HECK GEN 79191 TOTAL FOR FUND 2: 271.23 07/12/2023 GEN 79192*4 CITY OF HUTCHINSON 3RD QTR PILOT 70/30 234-000- 00 142,840.20 07/19/2023 10:26 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee Fund: 2 GAS 07/12/2023 GEN 79196 DOT/PHMSA 07/12/2023 GEN 791974 ENERTECH CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/23/2023 - 07/20/2023 Description 07/12/2023 GEN 79202*4 GOPHER STATE ONE -CALL INC 07/12/2023 GEN 79203* HILLYARD/HUTCHINSON 07/12/2023 GEN 79204* HUTCHFIELD SERVICES 07/12/2023 GEN 79205 HUTCHINSON CO-OP 07/12/2023 GEN 79206*4 HUTCHINSON LEADER 07/12/2023 GEN 79210 JUUL CONTRACTING COMPANY 07/12/2023 GEN 792114 KDUZ/KARP Account Dept Page 29/32 Amount VEHICLE/EQUIPMENT FUEL -GAS 401-880- 04 1,492.19 IT ADMIN AND SUPPORT 75/25 401-921- 08 7,248.81 LEGAL SERVICES 75/25 401-923- 08 2,625.00 VEHICLES/EQUIPMENT FUEL-ADMIN 55/45 401-935- 08 46.00 HECK GEN 79192 TOTAL FOR FUND 2: 154,252.20 REGULATORY EXPENSES 401-928- 08 36, 474.60 2023 Public Awareness Program for 401-874- 04 11,166.43 Public Awareness - Material 401-874- 04 0.27 2023 Public Awareness Program for 416-108- 04 1,143.73 2023 Public Awareness Program for 401-856- 05 3,195.81 HECK GEN 79197 TOTAL FOR FUND 2: 15,506.24 Materials 401-874- 04 228.82 Line - Outside Services 401-856- 05 25.65 HECK GEN 79202 TOTAL FOR FUND 2: 254.47 Grounds - Materials 401-935- 08 70.92 Grounds - Outside Services 401-935- 08 894.44 Vehicles - Material 402-895- 04 1,253.68 Cip - Marketing 401-916- 07 111.00 Cip - Marketing 401-916- 07 178.42 Advertising/Printing 401-921- 08 89.55 HECK GEN 79206 TOTAL FOR FUND 2: 378.97 Materials 402-892- 04 36.00 PUBLIC AWARENESS - MATERIAL 401-874- 04 82.50 PUBLIC AWARENESS - MATERIAL 401-874- 04 82.50 07/19/2023 10:26 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/23/2023 - 07/20/2023 Payee Description Account Dept Page 30/32 Amount Fund: 2 GAS Public Awareness - Material 401-856- 05 27.50 Public Awareness - Material 401-856- 05 27.50 HECK GEN 79211 TOTAL FOR FUND 2: 220.00 07/12/2023 GEN 792144 LOCATORS & SUPPLIES INC PAINT, LOCATING, YELLOW (258), 154-000- 00 538.82 TAX & FREIGHT 401-874- 04 151.93 HECK GEN 79214 TOTAL FOR FUND 2: 690.75 07/12/2023 GEN 79216* MARCO TECHNOLOGIES, LLC OFFICE SUPPLIES 401-921- 08 189.51 07/12/2023 GEN 79224 NORTHERN BORDER PIPELINE CO LINE - OUTSIDE SERVICES -INTERCONNECT 401-856- 05 2,000.00 07/12/2023 GEN 79225* NUVERA TELEPHONE 401-921- 08 647.48 07/12/2023 GEN 79226*4 O'REILLY AUTOMOTIVE INC Materials 402-863- 05 18.08 07/12/2023 GEN 79227* ONSOLVE, LLC COLLECTION - MATERIALS 401-903- 06 75.00 07/12/2023 GEN 79228 OSTENDORF, KAREN Cip - Residential 401-916- 07 325.00 07/12/2023 GEN 79229*4 OXYGEN SERVICE COMPANY INC Materials 401-874- 04 106.74 Materials 401-874- 04 91.73 Materials 401-874- 04 83.82 HECK GEN 79229 TOTAL FOR FUND 2: 282.29 07/12/2023 GEN 79231 PRO AUTO & TRANSMISSION REPAIR Vehicles - Material 402-895- 04 55.16 Vehicles - Material 402-895- 04 155.83 Vehicles - Material 402-895- 04 87.58 HECK GEN 79231 TOTAL FOR FUND 2: 298.57 07/12/2023 GEN 79234* BATH RACING, INC Grounds - Materials 401-935- 08 159.38 07/19/2023 10:26 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/23/2023 - 07/20/2023 Payee Description Account Dept Page 31/32 Amount Fund: 2 GAS 07/12/2023 GEN 79236* SHRED RIGHT OFFICE SUPPLIES -SHREDDING SERVICES 401-921- 08 5.16 07/12/2023 GEN 79238 SOUTH CENTRAL ELECTRIC ASS'N UTILITIES (ELECTRIC, SATELLITE 401-856- 05 51.00 07/12/2023 GEN 79242 TOTAL COMPLIANCE SOLUTIONS INC Training - Expense 401-870- 04 65.00 07/12/2023 GEN 79243* UNITED PARCEL SERVICE MAIL SERVICES - UPS, FEDEX 401-921- 08 54.39 07/12/2023 GEN 79244* VERIZON WIRELESS TELEPHONE 401-921- 08 345.47 07/16/2023 GEN 1459(E)*4 VISA Utilities (Electric, Satellite 401-856- 05 101.54 Breakroom/Recognition Banquet 401-926- 08 6.62 Training - Expense 401-930- 08 315.48 HECK GEN 1459(E) TOTAL FOR FUND 2: 423.64 07/19/2023 GEN 1478(E)* STATE OF MINNESOTA State Sales Tax 242-000- 00 12,981.00 City Sales Tax 242-000- 00 940.00 COUNTY SALES TAX 242-000- 00 940.00 HECK GEN 1478(E) TOTAL FOR FUND 2: 14,861.00 07/20/2023 GEN 1460(E)*4 BP CANANDA ENERGY SOLUTIONS GAS FOR RETAIL 401-807- 04 (6,750.38) GAS FOR RETAIL 401-807- 04 967.60 3M 401-807- 04 234,522.23 HTI 401-807- 04 2,955.24 UNG 401-807- 04 373.59 BROWNTON 401-807- 04 1,199.06 Utility Expenses - Water/Waste 401-930- 08 1,817.69 HECK GEN 1460(E) TOTAL FOR FUND 2: 235,085.03 07/20/2023 GEN 1461(E) PUBLIC ENERGY AUTHORITY OF Gas For Retail 401-807- 04 133,118.65 Contract Gas For Retail 401-807- 04 62.00 HECK GEN 1461(E) TOTAL FOR FUND 2: 133,180.65 07/19/2023 10:26 AM CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES Page 32/32 User: JMartig CHECK DATE FROM 06/23/2023 - 07/20/2023 DE: Hutchinson Utili Check Date Bank Check # Payee Description Account Dept Amount Fund: 2 GAS Total for fund 2 GAS 816,481.58 TOTAL - ALL FUNDS 2,369,007.56 --INDICATES CHECK DISTRIBUTED TO MORE THAN ONE FUND '#'-INDICATES CHECK DISTRIBUTED TO MORE THAN ONE DEPARTMENT HUTCHINSON UTILITIES COMMISSION COMBINED DIVISIONS FINANCIAL REPORT FOR JUNE, 2023 2023 2022 Di %Chnq 2023 2022 Di %Chnq Full Yr Bud %of Bud Combined Division Customer Revenue $ 2,550,802 $ 2,914,786 $ (363,984) (12.5%) $ 18,464,429 $ 19,717,698 $ (1,253,270) (6.4%) $ 38,930,509 47.4% Sales for Resale $ 640,287 $ 411,513 $ 228,774 55.6% $ 2,806,274 $ 1,834,663 $ 971,610 53.0% $ 4,230,000 66.3% NU Transportation $ 86,377 $ 86,247 $ 129 0.1% $ 521,470 $ 522,737 $ (1,267) (0.2%) $ 1,354,349 38.5% Electric Division Transfer $ 59,960 $ 59,724 $ 236 0.4% $ 359,759 $ 358,341 $ 1,417 0.4% $ 719,517 50.0% Other Revenues $ 37,811 $ 140,993 $ (103,182) (73.2%) $ 261,550 $ 346,997 $ (85,447) (24.6%) $ 484,081 54.0% Interest Income $ 115,029 $ 49,552 $ 65,476 132.1% $ 464,096 $ 205,133 $ 258,963 126.2% $ 533,457 87.0% TOTAL REVENUES $ 3,490,265 $ 3,662,816 $ (172,551) (4.7%) $ 22,877,577 $ 22,985,570 $ (107,993) (0.5%) $ 46,251,913 49.5% Salaries & Benefits $ 585,971 $ 547,385 $ 38,586 7.05% $ 3,552,542 $ 3,395,171 $ 157,371 4.6% $ 7,510,583 47.3% Purchased Commodities $ 1,570,353 $ 1,626,322 $ (55,968) (3.4%) $ 10,790,005 $ 11,431,723 $ (641,719) (5.6%) $ 21,566,760 50.0% Transmission $ 322,476 $ 357,390 $ (34,914) (9.8%) $ 1,733,737 $ 1,331,452 $ 402,285 30.2% $ 3,325,000 52.1% Generator Fuel/Chem. $ 127,719 $ 230,932 $ (103,213) (44.7%) $ 513,911 $ 755,250 $ (241,339) (32.0%) $ 1,760,606 29.2% Depreciation $ 361,737 $ 377,210 $ (15,473) (4.1%) $ 2,237,964 $ 2,269,928 $ (31,965) (1.4%) $ 4,400,000 50.9% Transfers (Elect./City) $ 218,671 $ 215,323 $ 3,348 1.6% $ 1,312,026 $ 1,291,938 $ 20,089 1.6% $ 2,624,053 50.0% Operating Expense $ 244,833 $ 218,460 $ 26,372 12.1% $ 1,444,882 $ 1,567,574 $ (122,692) (7.8%) $ 3,209,835 45.0% Debt Interest $ 65,534 $ 75,076 $ (9,542) (12.7%) $ 393,203 $ 450,453 $ (57,250) 12.7% $ 786,406 50.0% TOTAL EXPENSES $ 3,497,294 $ 3,648,097 $ (150,803) (4.1%) $ 21,978,270 $ 22,493,490 $ (515,220) (2.3%) $ 45,183,243 48.6% NET PROFIT/(LOSS) $ (7,029) $ 14,719 $ (21,748) (147.8%)l 899,307 $ 492,080 $ 407,227 82.8% $ 1,068,670 84.2% June June YTD YTD 2023 2022 Change 2023 2022 Change Gross Margin %: 28.4% 26.6% 1.8% 31.4% 30.2% 1.2% Operating Income Per Revenue $ (%): -2.3% -2.4% 0.1% 3.0% 2.1% 0.9% Net Income Per Revenue $ (%): -0.2% 0.4% -0.6% 3.9% 2.1% 1.8% HUTCHINSON UTILITIES COMMISSION ELECTRIC DIVISION FINANCIAL REPORT FOR JUNE, 2023 2023 2022 Di . Electric Division Customer Revenue $ 2,042,192 $ 2,307,919 $ (265,727) Sales for Resale $ 640,287 $ 411,513 $ 228,774 Other Revenues $ 13,710 $ 109,371 $ (95,661) Interest Income $ 58,908 $ 26,170 $ 32,738 TOTAL REVENUES $ 2,755,098 $ 2,854,973 $ (99,876) Salaries & Benefits $ Purchased Power $ Transmission $ Generator Fuel/Chem. $ Depreciation $ Transfers (Elect./City) $ Operating Expense $ Debt Interest $ TOTAL EXPENSES $ NET PROFIT/(LOSS) $ 439,686 $ 416,588 $ 23,098 1,160,601 $ 1,220,140 $ (59,539) 322,476 $ 357,390 $ (34,914) 127,719 $ 230,932 $ (103,213) 271,049 $ 285,881 $ (14,832) 169,911 $ 167,519 $ 2,392 142,044 $ 138,496 $ 3,548 37,738 $ 40,071 $ (2,333) 2,671,223 $ 2,857,016 $ (185,793) 83 918 % Chna 2023 2022 Di . (11.5%) $ 11,258,165 $ 11,852,217 $ (594,052) 55.6% $ 2,806,274 $ 1,834,663 $ 971,610 (87.5%) $ 102,694 $ 179,032 $ (76,338) 125.1% $ 240,412 $ 110,931 $ 129,482 (3.5%)l $ 14,407,546 $ 13,976,843 $ 430,702 5.5% $ 2,692,825 $ 2,566,148 $ 126,677 (4.9%) $ 6,130,423 $ 6,151,267 $ (20,844) (9.8%) $ 1,733,737 $ 1,331,452 $ 402,285 (44.7%) $ 513,911 $ 755,250 $ (241,339) (5.2%) $ 1,693,833 $ 1,721,953 $ (28,120) 1.4% $ 1,019,465 $ 1,005,113 $ 14,353 2.6% $ 1,008,150 $ 1,076,752 $ (68,602) (5.8%) $ 226,428 $ 240,428 $ (14,000) (6.5%) $ 15,018,772 $ 14,848,364 $ 170,408 ?05.3%) $ (611,227) $ (871,521) $ 260,294 2023 2022 Di . % Chna 1 2023 2022 Di . % Chna 50% of Year Comp. Full Yr Bud % of Bud (5.0%) $ 25,750,654 43.7% 53.0% $ 4,230,000 66.3% (42.6%) $ 187,047 54.9% 116.7% $ 283,457 84.8% 3.1%1 $ 30,451,158 47.3% 4.9% $ 5,465,303 49.3% (0.3%) $ 12,862,000 47.7% 30.2% $ 3,325,000 52.1% (32.0%) $ 1,760,606 29.2% (1.6%) $ 3,300,000 51.3% 1.4% $ 2,038,931 50.0% (6.4%) $ 1,954,789 51.6% 5.8% $ 452,856 50.0% 1.1% $ 31,159,485 48.2% (29.9%) $ (708,327) 86.3% 50% of Year Comp. % Chna Full Yr Bud % of Bud Electric Division Residential 5,542,725 5,289,518 253,207 4.79% 25,950,390 25,714,884 235,506 0.92% 54,834,787 47.3% All Electric 153,417 149,753 3,664 2.45% 1,407,999 1,566,948 (158,949) (10.14%) 2,716,035 51.8% Small General 1,723,165 1,596,890 126,275 7.91% 9,135,632 8,974,701 160,931 1.79% 18,332,200 49.8% Large General 7,503,570 7,691,150 (187,580) (2.44%) 38,668,710 41,538,160 (2,869,450) (6.91%) 84,325,256 45.9% Industrial 10,533,000 10,773,000 (240,000) (2.23%)l 53,054,000 56,678,000 (3,624,000) (6.39%) 120,422,724 44.1% Total KWH Sold 25,455,877 25,500,311 (44,434) (0.17%)l 128,216,731 134,472,693 (6,255,962) (4.65%)l 280,631,002 45.7% June June YTD YTD 2023 HUC 2023 2022 Change 2023 2022 Change Budget Target Gross Margin %: 26.7% 21.4% 5.3% 25.7% 24.9% 0.8% 26.7% Operating Income Per Revenue $ (%): 2.3% -3.1% 5.5% -4.6% -6.2% 1.6% -1.9% Net Income Per Revenue $ (%): 3.0% -0.1% 3.1% -4.2% -6.2% 2.0% -2.3% Customer Revenue per KWH: $0.0802 $0.0905 -$0.0103 $0.0878 $0.0881 -$0.0003 $0.0918 $0.0918 Total Power Supply Exp. per KWH: $0.0776 $0.0842 -$0.0065 $0.0819 $0.0768 $0.0051 $0.0786 $0.0786 Notes/Graphs: Net Income increased by $85,918 over June 2022. This is mostly due to our increased sales for resale with the Dynasty contract, higher interest rates, and lower electric procurement costs. Sales for Resale of $640,287 consisted of $113,804 in market sales, $98,000 in capacity sales to Rice Lake, $146,250 in capacity sales to AEP, and $282,233 in Tolling agreement sales to Dynasty Power. June 2022 Sales for Resale of $411,513 included $167,263 in market sales, $146,250 in capacity sales to AEP, and $98,000 in capacity sales to Rice Lake. June 2021 Sales for Resale of $591,916 consisted of $347,666 in market sales, $146,250 in capacity sales to AEP, and $98,000 in capacity sales to Rice Lake. Overall Purchased Power decreased by $59,539. MRES purchases decreased by $28,156 and market purchases/MISO costs decreased by $31,383. The average cost of MISO power was $26.07/mwh (6,148 mwh's purchased), compared to $37.34/mwh (5,520 mwh's purchased) in June 2022. Power Cost Adjustment for June 2023 was $.00000/kwhr bringing in $304,953 YTD. Power Cost Adjustment for June 2022 was $.00000/kwhr bringing in $243,139 YTD. Gas Division Customer Revenue Transportation Electric Div. Transfer Other Revenues Interest Income TOTAL REVENUES Salaries & Benefits Purchased Gas Operating Expense Depreciation Transfers (City) Debt Interest TOTAL EXPENSES NET PROFIT/(LOSS) HUTCHINSON UTILITIES COMMISSION GAS DIVISION FINANCIAL REPORT FOR JUNE, 2023 2023 2022 2 % Chna 2023 2022 2 . $ 508,610 $ 606,867 $ (98,257) (16.2%) $ 7,206,264 $ 7,865,482 $ (659,218) $ 86,377 $ 86,247 $ 129 0.1% $ 521,470 $ 522,737 $ (1,267) $ 59,960 $ 59,724 $ 236 0.4% $ 359,759 $ 358,341 $ 1,417 $ 24,101 $ 31,622 $ (7,521) (23.8%) $ 158,855 $ 167,965 $ (9,109) $ 56,120 $ 23,382 $ 32,738 140.0% $ 223,684 $ 94,202 $ 129,482 $ 735,168 $ 807,843 $ (72,675) (9.0%) $ 8,470,031 $ 9,008,727 $ (538,695) % Chna 50% of Year Full Yr Bud $ 13,179,855 Comp. % of Bud 54.7% (8.4%) (0.2%) $ 1,354,349 38.5% 0.4% $ 719,517 50.0% (5.4%) $ 297,034 53.5% 137.5% $ 250,000 89.5% (6.0%)l $ 15,800,755 53.6% $ 146,286 $ 130,797 $ 15,488 11.8% $ 859,717 $ 829,023 $ 30,694 3.7% $ 2,045,280 42.0% $ 409,752 $ 406,182 $ 3,570 0.9% $ 4,659,582 $ 5,280,457 $ (620,875) (11.8%) $ 8,704,760 53.5% $ 102,789 $ 79,964 $ 22,825 28.5% $ 436,732 $ 490,822 $ (54,090) (11.0%) $ 1,255,046 34.8% $ 90,688 $ 91,329 $ (641) (0.7%) $ 544,131 $ 547,975 $ (3,844) (0.7%) $ 1,100,000 49.5% $ 48,760 $ 47,804 $ 956 2.0% $ 292,561 $ 286,825 $ 5,736 2.0% $ 585,122 50.0% $ 27,796 $ 35,004 $ (7,208) 0.0% $ 166,775 $ 210,025 $ (43,250) 20.6% $ 333,550 50.0% $ 826,071 $ 791,080 $ 34,990 4.4% $ 6,959,498 $ 7,645,126 $ (685,628) (9.0%) $ 14,023,758 49.6% $ (90,903) $ 16,762 $ (107,665) (642.3%) $ 1,510,534 $ 1,363,601 $ 146,933 10.8% $ 1,776,997 85.0% 50% of Year Comp. 2023 2022 2 %Chna I 2023 2022 2 %Chna I Full YrBud %of Bud Gas Division Residential 6,460,534 6,916,001 (455,467) (6.59%) 260,780,683 296,782,802 (36,002,119) (12.13%) 449,212,000 58.1% Commercial 7,900,389 8,653,457 (753,068) (8.70%) 193,532,227 221,471,923 (27,939,696) (12.62%) 350,057,000 55.3% Industrial 46,802,733 52,780,081 (5,977,348) (11.33%) 449,095,058 501,258,324 (52,163,266) (10.41%) 919,535,000 48.8% Total CF Sold 61,163,656 68,349,539 (7,185,883) (10.51%) 903,407,968 1,019,513,049 (116,105,081) (11.39%) 1,718,804,000 52.6% June June YTD YTD 2023 HUC 2023 2022 Change 2023 2022 Change Budget Target Gross Margin %: 35.4% 45.1% -9.7% 41.3% 38.4% 2.9% 40.4% Operating Income Per Revenue $ (%): -21.1% 0.2% -21.3% 16.3% 15.2% 1.1% 10.6% IIIIIIIIIIIIIIIIIIIIII Net Income Per Revenue $ (%): -12.4% 2.1% -14.4% 17.8% 15.1% 2.7% 11.2% IIIIIIIIIIIIIIIIIIIIII Contracted Customer Rev. per CF: $0.0056 $0.0067 -$0.0011 $0.0066 $0.0062 $0.0004 $0.0063 IIIIIIIIIIIIIIII Customer Revenue per CF: $0.0151 $0.0141 $0.0009 $0.0093 $0.0090 $0.0002 $0.0091 M Total Power Supply Exp. per CF: $0.0070 $0.0061 $0.0009 $0.0053 $0.0053 ($0.0000) $0.0053 "' 1° muuuuuuuuuuuu Notes/Graphs: June Net Loss increased by $107,665 due to lower customer revenues as well as higher operating expenses. ere was no fuel cost adjustment for either June 2023 or June 2022. Current Assets UnrestrictedlUndesignated Cash Cash Petty Cash Designated Cash Capital Expenditures - Five Yr. CIP Payment in Lieu of Taxes Rate Stabilization - Electric Rate Stabilization - Gas Catastrophic Funds Restricted Cash Bond Interest Payment 2017 Bond Interest Payment 2012 Debt Service Reserve Funds Total Current Assets Receivables Accounts (net of uncollectible allowances) Interest Total Receivables Other Assets Inventory Prepaid Expenses Sales Tax Receivable Deferred Outflows - Electric Deferred Outflows - Gas Total Other Assets Total Current Assets Capital Assets Land & Land Rights Depreciable Capital Assets Accumulated Depreciation Construction - Work in Progress Total Net Capital Assets HUTCHINSON UTILITIES COMMISSION BALANCE SHEET- CONSOLIDATED June 30, 2023 Electric Gas Total Total Net Change Division Division 2023 2022 Total (YTD) 4,695,961.90 11,755,196.21 16,451,158.11 17,370,140.38 (918,982.27) 680.00 170.00 850.00 850.00 - 2,750,000.00 700,000.00 3,450,000.00 3,450,000.00 - 1,319,414.00 585,122.00 1,904,536.00 1,867,192.00 37,344.00 738,947.11 - 738,947.11 395,204.99 343,742.12 - 585,956.78 585,956.78 572,128.17 13,828.61 800,000.00 200,000.00 1,000,000.00 1,000,000.00 - 1,163,571.33 - 1,163,571.33 1,148,404.60 15,166.73 - 1,092,379.19 1,092,379.19 1,044,170.82 48,208.37 522,335.64 2,188,694.02 2,711,029.66 2,711,029.66 - 11,990,909.98 17,107,518.20 29,098,428.18 29,559,120.62 (460,692.44) 2,655,076.89 648,932.43 3,304,009.32 3,363,210.12 (59,200.80) 59,141.99 59,142.00 118,283.99 94,415.01 23,868.98 2,714,218.88 708,074.43 3,422,293.31 3,457,625.13 (35,331.82) 1,775,379.31 513,831.20 2,289,210.51 2,272,700.76 16,509.75 (26,525.54) 37,720.60 11,195.06 396,725.63 (385,530.57) 266,279.06 - 266,279.06 170,184.12 96,094.94 1,221,397.00 - 1,221,397.00 1,630,746.00 (409,349.00) - 407,133.00 407,133.00 543,582.00 (136,449.00) 3,236,529.83 958,684.80 4,195,214.63 5,013,938.51 (818,723.88) 17, 941, 658.69 18, 774, 277.43 690,368.40 3,899,918.60 112,481,419.63 42,872,726.46 (68,655,802.06) (20,808,506.71) 1,374,036.93 573,880.94 4.5,890,022.90 26,538,019.29 36,715,936.12 38,030,684.26 (1,314,748.14) 4,590,287.00 4,590,287.00 - 155, 354,146.09 153, 821, 510.44 1, 532, 635.65 (89,464,308.77) (85,128,909.08) (4,335,399.69) 1,947,917.87 734,394.73 1,213,523.14 72,428,042.19 74,017,283.09 (1,589,240.90) Total Assets 63,831,681.59 45,312,296.72 109,143,978.31 112,047,967.35 (2,903,989.04) Current Liabilities Current Portion of Long-term Debt Bonds Payable Bond Premium Lease Liability - Solar Array Accounts Payable Accrued Expenses Accrued Interest Accrued Payroll Total Current Liabilities Long -Term Liabilities Noncurrent Portion of Long-term Debt 2017 Bonds 2012 Bonds Bond Premium 2012 Pension Liability- Electric Pension Liability - Electric OPEB Pension Liability - Nat Gas Pension Liability - Nat Gas OPEB Accrued Vacation Payable Accrued Severance Deferred Outflows - Electric Deferred Outflows - Nat Gas Total Long -Term Liabilities Net Position Retained Earnings Total Net Position HUTCHINSON UTILITIES COMMISSION BALANCE SHEET- CONSOLIDATED June 30, 2023 Electric Gas Total Division Division 2023 730,000.00 19, 546.00 2,901,481.15 37,738.02 114,939.72 3,803,704.89 13,300,000.00 482,337.84 4,021,396.00 77,480.00 514,998.51 109,985.36 98,554.00 18,604,751.71 1,825,000.00 185,608.32 598,755.52 27,795.83 37,715.36 2,674,875.03 5,955,000.00 448,553.07 1,340,466.00 25,827.00 185,601.83 30,300.18 32,851.00 8,018,599.08 41,423,224.99 34,618,822.61 41,423,224.99 34,618,822.61 2,555,000.00 185,608.32 19, 546.00 3,500,236.67 65,533.85 152,655.08 6,478,579.92 13,300,000.00 5,955,000.00 930,890.91 4,021,396.00 77,480.00 1,340,466.00 25,827.00 700,600.34 140,285.54 98,554.00 32,851.00 26,623,350.79 Total 2022 2,430,000.00 185,608.32 2,761,941.19 75,075.53 133,703.63 5,586,328.67 14,030,000.00 7,780,000.00 1,149,956.19 2,219,565.00 94,162.00 739,855.00 31,387.00 595,141.98 123,254.85 2,041,393.00 680,464.00 29,485,179.02 76,042,047.60 76,976,459.66 76,042,047.60 76,976,459.66 Net Change Total (YTD) 125,000.00 19, 546.00 738,295.48 (9,541.68) 18, 951.45 892,251.25 (730,000.00) (1,825,000.00) (219,065.28) 1,801,831.00 (16, 682.00) 600,611.00 (5,560.00) 105,458.36 17,030.69 (1,942,839.00) (647,613.00) (2,861,828.23) (934,412.06) (934,412.06) Total Liabilities and Net Position 63,831,681.59 45,312,296.72 109,143,978.31 112,047,967.35 (2,903,989.04) Hutchinson Utilities Commission Cash -Designations Report, Combined June 30, 2023 Change in Financial Annual Balance, Balance, Cash/Reserve Institution Current Interest Rate Interest June 2023 May 2023 Position Savings, Checking, Investments varies varies varies 29,098,428.18 28,250,840.21 847,587.97 Total Operating Funds 29,098,428.18 28,250,840.21 847,587.97 Debt Reserve Requirements Bond Covenants - sinking fund Debt Reserve Requirements Bond Covenants -1 year Max. P & I Total Restricted Funds Operating Reserve Rate Stabalization Funds PILOT Funds Catastrophic Funds Capital Reserves Total Designated Funds Min 60 days of 2023 Operating Bud. Charter (Formula Only) Risk Mitigation Amount 5 Year CIP (2023-2027 Fleet & Infrastructure Maintenance) 2,255,950.52 1,977,500.00 278,450.52 2,711,029.66 2,711,029.66 - 4,966,980.18 4,688,529.66 278,450.52 6,797,207.17 6,797,207.17 - 1,324,903.89 1,296,342.83 28,561.06 1,904,536.00 1,904,536.00 - 1, 000, 000.00 1, 000, 000.00 3,450,000.00 3,450,000.00 - 14,476,647.06 14,448,086.00 28,561.06 YE YE YE YE YTD HUC 2019 2020 2021 2022 2023 Target Debt to Asset 34.9% 32.3% 30.8% 31.4% 30.3% Current Ratio 5.11 5.67 5.22 4.47 4.66 RONA 2.25% 3.62% 0.41% -1.38% 0.94% Change in Cash Balance (From 12131114 to 613012023) Month End Electric Elec. Change Natural Gas Gas Change Total Total Change 6/30/202 3 11, 990, 910 17,107, 518 29, 098, 428 12/31/2022 11,633,212 15,450,554 27,083,766 2,014,663 12/31/2021 12,870,253 (1,237,041) 15,086,000 364,554 27,956,253 (872,487) 12/31/2020 14,239,233 (1,368,981) 15,019,173 66,827 29,258,406 (1,302,153) 12/31/2019 12,124,142 2,115,092 13,837,040 1,182,133 25,961,181 3,297,225 12/31/2018 15,559,867 (3,435,725) 12,335,998 1,501,042 27,895,864 (1,934,683) 12/31/2017 23,213,245 (7,653,378) 10,702,689 1,633,309 33,915,934 (6,020,070) 12/31/2016 8,612,801 14,600,444 9,500,074 1,202,615 18,112,875 15,803,059 12/31/2015 6,170,790 2,442,011 9,037,373 462,701 15,208,163 2,904,712 12/31/2014 3,598,821 2,571,969 6,765,165 2,272,208 10,363,986 4,844,177 * 2017's Significant increase in cash balance is due to issuing bonds for the generator project. Hutchinson Utilities Commission Cash -Designations Report, Electric June 30, 2023 Change in Financial Annual Balance, Balance, Cash/Reserve Institution Current Interest Rate Interest June 2023 May 2023 Position Savings, Checking, Investments varies varies Total HUC Operating Funds tiectric iI Debt Restricted Requirements Bond Covenants - sinking fund Debt Restricted Requirements Bond Covenants -1 year Max. P & I Total Restricted Funds varies 29,098,428.18 28,250,840.21 847,587.97 29,098,428.18 28,250,840.21 847,587.97 1,163,571.33 1,064,999.98 98,571.35 522,335.64 522,335.64 - 1,685,906.97 1,587,335.62 98,571.35 Operating Reserve Min 60 days of 2023 Operating Bud. 4,643,247.50 4,643,247.50 Rate Stabalization Funds $400K-$1.2K 738,947.11 739,200.24 (253.13) PILOT Funds Charter (Formula Only) 1,319,414.00 1,319,414.00 Catastrophic Funds Risk Mitigation Amount 800,000.00 800,000.00 Capital Reserves 5 Year CIP (2023-2027 Fleet & Infrastructure Maintenance) 2,750,000.00 2,750,000.00 Total Designated Funds 10,251,608.61 10,251,861.74 (253.13) YE YE YE YE YTD APPA Ratio HUC 2019 2020 2021 2022 2023 5K-10K Cust. Target Debt to Asset Ratio (* w/Gen.) 34.1% 32.6% 32.2% 34.8% 35.1% 39.8% Current Ratio 5.26 6.18 5.70 4.96 3.95 3.75 RONA -0.4% 2.5% -1.2% -4.2% -1.1% NA >0% Notes/Graphs: Hutchinson Utilities Commission Cash -Designations Report, Gas June 30, 2023 Change in Financial Annual Balance, Balance, Cash/Reserve Institution Current Interest Rate Interest June 2023 May 2023 Position Savings, Checking, Investments varies varies Total HUC Operating Funds Debt Restricted Requirements Bond Covenants - sinking fund Debt Restricted Requirements Bond Covenants -1 year Max. P & I Total Restricted Funds Operating Reserve Rate Stabalization Funds PILOT Funds Catastrophic Funds Capital Reserves Total Designated Funds varies 29,098,428.18 28,250,840.21 847,587.97 29,098,428.18 28,250,840.21 847,587.97 Min 60 days of 2023 Operating Bud. $200K-$600K Charter (Formula Only) Risk Mitigation Amount 5 Year CIP (2023-2027 Fleet & Infrastructure Maintenance) 1,092,379.19 912,500.02 179,879.17 2,188,694.02 2,188,694.02 - 3, 281, 07 3.21 3,101,194.04 179, 879.17 2,153,959.67 2,153,959.67 - 585,956.78 557,142.59 28,814.19 585,122.00 585,122.00 - 200,000.00 200,000.00 700,000.00 700,000.00 - 4,225,038.45 4,196,224.26 28,814.19 YE YE YE YE YTD HUC 2019 2020 2021 2022 2023 AGA Ratio Target Debt to Asset 36.1% 32.0% 28.8% 26.5% 23.6% 35%-50% Current Ratio 4.96 5.18 4.79 4.06 5.64 1.0-3.0 RONA 6.4% 5.3% 2.9% 3.0% 3.9% 2%-5% Notes/Graphs: HUTCHINSON UTILITIES COMMISSION Investment Report For the Month Ended June 30, 2023 Interest Current Date of Date of Par Current Purchase Unrealized Premium Next Institution Description Rate YTM Purchase Maturity Value Value Amount Gain/(Loss) (Discount) Call Date Wells Fargo Money Market 4.370% 4.370% NA NA - 70,172.65 - - - N/A Wells Fargo FHLB 5.000% 5.000% 05/31/2023 11/26/2025 1,000,000.00 989,300.00 1,000,681.44 (11,381.44) 681.44 02/26/2024 Wells Fargo FHLB 4.750% 4.750% 02/01/2023 02/01/2024 1,000,000.00 992,540.00 1,000,000.00 (7,460.00) - N/A Wells Fargo FFCB 4.250% 4.250% 12/20/2022 12/20/2024 1,000,000.00 984,920.00 1,000,000.00 (15,080.00) - N/A Wells Fargo FFCB 4.000% 4.000% 40/10/2023 03/10/2025 580,000.00 570,076.20 580,000.00 (9,923.80) - N/A Wells Fargo FHLB 0.400% 0.587% 01/29/2021 01/29/2026 295,000.00 266,505.95 295,000.00 (28,494.05) - 07/29/2023 Wells Fargo FHLB 0.400% 0.525% 02/09/2021 02/09/2026 470,000.00 422,854.30 470,000.00 (47,145.70) - 08/09/2023 Wells Fargo FHLB 0.750% 1.432% 04/29/2021 04/29/2026 400,000.00 366,144.00 400,000.00 (33,856.00) - 12/29/2023 Wells Fargo FHLB 0.650% 1.069% 06/30/2021 06/30/2026 300,000.00 270,516.00 300,000.00 (29,484.00) - 09/30/2023 Wells Fargo FHLB 0.700% 1.281% 09/30/2021 09/30/2026 250,000.00 226,022.50 250,000.00 (23,977.50) - 09/30/2023 Wells Fargo CD's 2.550% 2.550% 06/17/2022 12/18/2023 245,000.00 241,876.25 245,000.00 (3,123.75) - N/A Wells Fargo CD's 0.300% 0.300% 01/08/2021 01/08/2024 245,000.00 238,693.70 245,000.00 (6,306.30) - N/A Wells Fargo CD's 0.450% 0.450% 04/14/2021 04/15/2024 245,000.00 235,663.05 245,000.00 (9,336.95) - 08/14/2023 Wells Fargo CD's 2.800% 2.800% 06/17/2022 06/17/2024 245,000.00 238,894.60 245,000.00 (6,105.40) - N/A Wells Fargo CD's 0.550% 0.550% 08/02/2021 08/05/2024 245,000.00 232,279.60 245,000.00 (12,720.40) - N/A Wells Fargo CD's 4.800% 4.800% 11/16/2022 11/15/2024 245,000.00 242,839.10 245,000.00 (2,160.90) - N/A Wells Fargo CD's 1.100% 1.100% 01/31/2022 01/31/2025 245,000.00 229,026.00 245,000.00 (15,974.00) - 07/31/2023 Wells Fargo CD's 1.600% 1.600% 02/23/2022 02/24/2025 245,000.00 230,304.90 245,000.00 (14,695.10) - N/A Wells Fargo CD's 4.650% 4.650% 04/12/2023 04/07/2025 245,000.00 241,758.65 245,000.00 (3,241.35) - N/A Wells Fargo CD's 4.650% 4.650% 40/14/2023 04/14/2025 245,000.00 241,734.15 245,000.00 (3,265.85) - N/A Wells Fargo CD's 3.100% 3.100% 06/15/2022 06/16/2025 245,000.00 234,499.30 245,000.00 (10,500.70) - N/A Wells Fargo CD's 3.100% 3.100% 06/15/2022 06/16/2025 245,000.00 234,499.30 245,000.00 (10,500.70) - N/A Wells Fargo CD's 3.300% 3.300% 08/26/2022 08/26/2025 245,000.00 234,555.65 245,000.00 (10,444.35) - N/A Wells Fargo CD's 1.000% 1.000% 05/19/2021 05/19/2026 245,000.00 216,450.15 245,000.00 (28,549.85) - N/A Wells Fargo CD's 1.000% 1.000% 07/28/2021 07/28/2026 245,000.00 214,377.45 245,000.00 (30,622.55) - N/A Wells Fargo CD's 1.050% 1.050% 08/08/2021 08/25/2026 238,000.00 208,399.94 238,000.00 (29,600.06) - N/A Wells Fargo CD's 1.000% 1.207% 07/31/2021 07/13/2028 245,000.00 201,990.25 245,000.00 (43,009.75) 12/13/2023 Broker Total 49.5% 9,453,000.00 9,076,893.64 9,453,681.44 (446,960.45) 681.44 Cetera Investment Services Money Market 0.750% 0.750% N/A N/A - 6,207.21 - - - N/A Cetera Investment Services Municipal Bonds 2.500% 3.181% 12/20/2018 08/01/2023 35,000.00 34,918.45 34,320.05 598.40 (679.95) N/A Cetera Investment Services Municipal Bonds 3.400% 3.148% 12/20/2018 11/01/2023 125,000.00 123,987.50 126,376.25 (2,388.75) 1,376.25 N/A Cetera Investment Services Municipal Bonds 3.400% 3.148% 12/20/2018 11/01/2023 65,000.00 64,473.50 65,715.65 (1,242.15) 715.65 N/A Cetera Investment Services Municipal Bonds 2.854% 3.173% 12/20/2018 02/01/2024 100,000.00 98,279.00 99,605.96 (1,326.96) (394.04) N/A Cetera Investment Services Municipal Bonds 2.977% 3.246% 12/20/2018 03/15/2024 250,000.00 245,570.00 248,743.99 (3,173.99) (1,256.01) N/A Cetera Investment Services Municipal Bonds 1.940% 1.821% 01/13/2020 05/01/2024 65,000.00 63,068.20 65,570.70 (2,502.50) 570.70 N/A Cetera Investment Services Municipal Bonds 5.742% 3.658% 04/11/2019 08/01/2024 190,000.00 190,197.60 208,924.00 (18,726.40) 18,924.00 N/A Cetera Investment Services Municipal Bonds 5.000% 4.253% 02/09/2023 08/15/2024 270,000.00 268,555.50 279,454.50 (10,899.00) 9,454.50 N/A Cetera Investment Services Municipal Bonds 2.400% 2.908% 08/05/2022 08/15/2024 50,000.00 48,341.00 50,070.17 (1,729.17) 70.17 N/A Cetera Investment Services Municipal Bonds 2.402% 2.926% 08/05/2022 10/01/2024 125,000.00 120,537.50 124,674.19 (4,136.69) (325.81) N/A Cetera Investment Services Municipal Bonds 2.033% 4.794% 06/05/2023 10/01/2024 85,000.00 81,400.25 82,332.21 (931.96) (2,667.79) Make -Whole Call Cetera Investment Services Municipal Bonds 5.200% 4.710% 02/21/2023 11/01/2024 30,000.00 29,844.30 30,711.27 (866.97) 711.27 N/A Cetera Investment Services Municipal Bonds 4.000% 4.689% 05/19/2023 12/01/2024 50,000.00 48,961.50 50,428.33 (1,466.83) 428.33 N/A Cetera Investment Services Municipal Bonds 2.528% 1.918% 01/13/2020 12/01/2024 100,000.00 95,857.00 102,999.53 (7,142.53) 2,999.53 N/A Cetera Investment Services Municipal Bonds 1.319% 4.407% 09/26/2022 12/01/2024 50,000.00 46,956.50 47,238.35 (281.85) (2,761.65) N/A Cetera Investment Services Municipal Bonds 3.922% 3.429% 12/20/2018 12/01/2024 204,000.00 198,616.44 208,181.10 (9,564.66) 4,181.10 N/A Cetera Investment Services Municipal Bonds 3.375% 4.693% 06/05/2023 03/01/2025 260,000.00 251,500.60 256,618.05 (5,117.45) (3,381.95) Make -Whole Call Cetera Investment Services Municipal Bonds 4.415% 4.516% 02/21/2023 05/01/2025 60,000.00 59,124.60 59,907.79 (783.19) (92.21) N/A Cetera Investment Services Municipal Bonds 4.400% 3.221% 04/11/2019 07/01/2025 500,000.00 485,790.00 539,101.11 (53,311.11) 39,101.11 07/01/2023 Cetera Investment Services Municipal Bonds 0.824% 4.678% 01/09/2023 08/01/2025 100,000.00 91,342.00 91,160.64 181.36 (8,839.36) N/A Cetera Investment Services Municipal Bonds 5.640% 3.007% 04/18/2019 08/15/2025 205,000.00 182,527.90 169,737.95 12,789.95 (35,262.05) N/A Cetera Investment Services Municipal Bonds 3.743% 2.740% 04/18/2019 09/15/2025 215,000.00 208,666.10 228,334.53 (19,668.43) 13,334.53 N/A Cetera Investment Services Municipal Bonds 3.379% 1.934% 08/19/2019 10/01/2025 310,000.00 295,194.40 339,739.18 (44,544.78) 29,739.18 N/A Cetera Investment Services Municipal Bonds 2.727% 2.271% 03/03/2022 12/01/2025 335,000.00 309,784.55 342,781.72 (32,997.17) 7,781.72 N/A Cetera Investment Services Municipal Bonds 5.600% 1.186% 07/28/2020 12/01/2025 45,000.00 45,432.90 55,250.55 (9,817.65) 10,250.55 N/A Cetera Investment Services Municipal Bonds 4.250% 3.258% 04/11/2019 01/01/2026 500,000.00 485,255.00 529,769.03 (44,514.03) 29,769.03 N/A Cetera Investment Services Municipal Bonds 2.420% 1.175% 10/06/2020 03/01/2026 100,000.00 92,314.00 106,734.28 (14,420.28) 6,734.28 N/A Cetera Investment Services Municipal Bonds 1.609% 1.124% 09/24/2020 04/01/2026 285,000.00 259,352.85 292,370.10 (33,017.25) 7,370.10 N/A Cetera Investment Services Municipal Bonds 6.690% 3.356% 04/18/2019 04/15/2026 60,000.00 51,147.60 47,545.20 3,602.40 (12,454.80) N/A Cetera Investment Services Municipal Bonds 5.900% 1.451% 07/28/2020 06/15/2026 75,000.00 76,672.50 93,741.75 (17,069.25) 18,741.75 N/A Cetera Investment Services Municipal Bonds 0.000% 1.415% 08/13/2020 07/01/2026 100,000.00 84,463.00 92,037.00 (7,574.00) (7,963.00) N/A Cetera Investment Services Municipal Bonds 3.250% 2.903% 04/18/2019 08/01/2026 500,000.00 471,065.00 514,790.69 (43,725.69) 14,790.69 N/A Cetera Investment Services Municipal Bonds 2.116% 3.307% 06/07/2022 08/01/2026 75,000.00 68,800.50 71,565.00 (2,764.50) (3,435.00) N/A Cetera Investment Services Municipal Bonds 2.150% 2.203% 07/01/2019 12/01/2026 40,000.00 36,843.20 40,150.64 (3,307.44) 150.64 N/A Cetera Investment Services Municipal Bonds 1.664% 1.150% 08/27/2020 09/01/2026 225,000.00 201,291.75 231,696.00 (30,404.25) 6,696.00 N/A Interest Current Date of Date of Par Current Purchase Unrealized Premium Next Institution Description Rate YTM Purchase Maturity Value Value Amount Gain/(Loss) (Discount) Call Date Cetera Investment Services Municipal Bonds 2.375% 1.816% 09/04/2019 12/01/2026 90,000.00 82,815.30 93,395.70 (10,580.40) 3,395.70 N/A Cetera Investment Services Municipal Bonds 2.350% 2.191% 07/01/2019 12/01/2026 500,000.00 460,585.00 505,385.00 (44,800.00) 5,385.00 N/A Cetera Investment Services Municipal Bonds 3.000% 1.991 % OS/19/2019 OZ01/2027 50,000.00 47,001.50 53,551.00 (6,549.50) 3,551.00 N/A Cetera Investment Services Municipal Bonds 3.150% 2.034% 08/19/2019 03/15/2027 100,000.00 94,077.00 109,138.50 (15,061.50) 9,138.50 N/A Cetera Investment Services Municipal Bonds 3.332% 3.120% 04/1 8/201 9 04/15/2027 500,000.00 475,575.00 507,783.94 (32,208.94) 7,783.94 N/A Cetera Investment Services Municipal Bonds 3.865% 2.470% 08/1 9/201 9 05/01/2027 55,000.00 53,738.30 60,986.48 (7,248.18) 5,986.48 05/01/2025 Cetera Investment Services Municipal Bonds 3.553% 2.289% 08/1 9/201 9 05/01/2027 55:000.00 51:936.50 60:468.04 (8,53t54) 5:468.04 05/01/2026 Cetera Investment Services Municipal Bonds 3.230% 1.828% 08/1 9/201 9 05/15/2027 145,000.00 136,909.00 160,827.31 (23,918.31) 15,827.31 N/A Cetera Investment Services Municipal Bonds 1.925% 1.719% 11/23/2021 06/01/2027 310,000.00 274,291.10 313,447.46 (39,156.36) 3,447.46 Make -Whole Call Cetera Investment Services Municipal Bonds 1.861% 1.254% 06/07/2021 07/01/2027 410,000.00 364:399.80 412:336.71 (47,936.91) 2:336.71 N/A Cetera Investment Services Municipal Bonds 3.000% 3.101% 05/18/2020 09/01/2027 65,000.00 64,120.55 69,180.58 (5,060.03) 4,180.58 09/01/2025 Cetera Investment Services Municipal Bonds 2.817% 2.817% 09/25/2019 10/01/2027 35,000.00 28,379.75 27,969.55 410.20 (7,030.45) 05/01/2025 Cetera Investment Services Municipal Bonds 1.415% 1.793% 11/23/2021 03/01/2028 100,000.00 86,895.00 98,088.31 (11,193.31) (1,911.69) N/A Cetera Investment Services Municipal Bonds 3.270% 2.141% 08/19/2019 03/15/2028 155:000.00 144:394.90 170,805.09 (26,410.19) 15,805.09 09/15/2027 Cetera Investment Services Municipal Bonds 2.974% 2.574% 11/07/2019 04/01/2028 75,000.00 68,608.50 77,253.00 (8,644.50) 2,253.00 N/A Cetera Investment Services Municipal Bonds 2.125% 1.904% 11/23/2021 06/01/2028 110,000.00 95,760.50 111,525.06 (15,764.56) 1,525.06 N/A Cetera Investment Services Municipal Bonds 2.547% 1.240% 08/10/2021 07/01/2028 125:000.00 113,423.75 136,101.16 (22,677.41) 11,101.16 N/A Cetera Investment Services Municipal Bonds 3.140% 2.004% OS/19/2019 08/01/2028 500,000.00 462,605.00 547,105.00 (84,500.00) 47,105.00 08/01/2027 Cetera Investment Services Municipal Bonds 3.000% 2.199% 05/19/2020 08/15/2028 90,000.00 89,099.10 95,401.80 (6,302.70) 5,401.80 08/15/2025 Cetera Investment Services Municipal Bonds 1.692% 1.813% 11/24/2021 10/01/2028 180,000.00 152,244.00 179,188.74 (26,944.74) (811.26) N/A Cetera Investment Services Municipal Bonds 3.000% 1.942% 08/19/2019 06/01/2029 115,000.00 105,749.40 125,961.80 (20,212.40) 10,961.80 N/A Cetera Investment Services Municipal Bonds 4.000% 3.214% 03/22/2021 09/01/2031 60,000.00 60,061.20 64,292.00 (4,230.80) 4,292.00 09/01/2024 Cetera Investment Services Municipal Bonds 3.500% 2.699% 11/23/2021 02/01/2033 50:000.00 50,024.50 54,390.44 (4,365.94) 4,390.44 02/01/2025 Cetera Investment Services Municipal Bonds 3.250% 2.655% 08/1 9/201 9 06/01/2029 75,000.00 75,183.00 79:860.31 (4,677.31) 4:860.31 02/01/2025 Cetera Investment Services Municipal Bonds 3.125% 2.303% 11/23/2021 10/01/2034 50,000.00 48,914.50 54,773.69 (5,859.19) 4:773.69 04/01/2027 Cetera Investment Services Municipal Bonds 3.125% 2.456% 11/23/2021 OZ01/2035 50,000.00 4$567.00 54,236.11 (5,669.11) 4,236.11 OZ01/2026 Broker Total 50.5% 9,834,000.00 9,257,699.05 10,151,830.24 (900,338.40) 317,830.24 TOTAL INVESTMENTS 100.0% 6/30/2023 % of 5/31/2023 % of Monthly Maturity Current Value Product Type Total Value Total Total Value Total Change Less than 1 year $2,654,344.11 14.5% MH Money Market $76,379.86 0.4% $32,561.23 0.2% $43,818.63 1 - 2 years 4,881,829.99 26.6% CD's 3,917,842.04 21.4% 3,920,385.63 21.4% (2,543.59) 2 - 3 years 5,079,289.85 27.7% Government Bonds 5,088,878.95 27.8% 5,108,349.90 27.8% (19,470.95) 3 - 4 years 3,458,708.04 18.9% Municipal Bonds 9,251,491.84 50.5% 9,294,517.81 50.6% 43,025.97 4 - 5 years 852,559.00 4.7% TOTAL $18 334 592.69 100.0% $18 355 814.57 100.0% $21 22L88 5+ years 1,407,861.70 7.7% TOTAL $18,334,592.69 100.0% Money Market Municipal Bonds 0.4% CD's $6,000,000.00 50.5% lllui �21.4% $5,079,290 $5,000,000.00 $4,000,000.00 ....................... ... ... ....... .,.,.,.,.,.,.,.,., .,.,.,.,.,.,.,.,. .,.,.,.,.,.,.,.,.,.,.,.,.,.. $3,458,708 $3,000,000.00 ......... ....... ........ ........................................................ $2,000,000.00 ., ___ ______ ____ _____ _____ ------------- __ $1,407,862 .... ............ ............. ............ ..........852 559........... ..._ $1,000,000.00 $0.00 Less than 1-2years 2-3years 3-4years 4-Syears 5+years year Government Bonds 27.8% ELECTRIC DIVISION Operating Revenue June 2023 CLASS AMOUNT KWH /KWH Street Lights $19.68 361 $0.05452 Electric Residential Service $544,419.47 5,542,725 $0.09822 All Electric Residential Service $16,507.87 153,417 $0.10760 Electric Small General Service $165,867.90 1,723,165 $0.09626 Electric Large General Service $646,774.07 7,503,570 $0.08620 Electric Large Industrial Service $771,462.82 10,533,000 $0.07324 Total $2,145,051.81 25,456,238 $0.08426 Power Adjustment $0.00000 Rate Without Power Adjustment $0.08426 Electric Division Year -to -Date M2023 $A--t 02022 $A--t ■2023 KWH110 02022 KWH110 18,000,000 16,000,000 14,000,000 12,000,000 10,000,000 8,000,000 6,000,000 4,000,000 2,000,000 0 ,I IIWIIWIIu i IIWIIWIIII I IIWIIWIIII I i IIWIIWIIu I i IIWIIWIIII Street Lights Residential All Elec. Small Gen. Large Gen. Large For Resale Resid. Srv. Srv. Industrial NOTE: Sales for resale includes capacity sales and energy for resale Total NATURAL GAS DIVISION Operating Revenue JUNE 2023 CLASS AMOUNT MCF /$ MCF Residential $135,640.51 6,461 $20.99373 Commercial $100,413.22 7,900 $12.71053 Large Industrial $24,799.14 2,945 $8.42076 Large Industrial Contracts $247,757.23 43,858 $5.64908 Total $508,610.10 61,164 $8.31551 Fuel Adjustment $0.00000 Rate Without Fuel Adjustment $8.31551 Natural Gas Division Year -to -Date ® 2023 $ Amount 0 2022 $ Amount ■ 2023 MCF 13 2022 MCF 9,000,000 8,000,000 7,000,000 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 0 Gas Residential Gas Commercial Large Industrial Large Industrial Total Contracts Monthly Report - Hutchinson Utilities Commission Year Minimum duration Hutchinson Utilities Commission Substation 2023 %0 ----- v Month Maximum duration Circuit 06 - June v ----- v' Annual Report? Top-level Cause Remove Major Events? 0 Yes ----- v Use APPA Event threshold ��w; No IEEE 1366 Statistics Metric Jun 2023 Jun 2022 SAI DI 0.773 0.434 SAI F I 0.00577 0.00779 CAI DI 133.999 55.758 ASAI 99.9981 % 99.9989% Momentary Interruptions 0 0 Sustained Interruptions 1 2 Circuit Ranking - Worst Performing Ranked by Outage Count Circuit Substation Fdr#16 Plant 1 Ranked by Customer Interruptions Circuit Substation Fdr#16 Plant 1 Ranked by Customer Minutes of Duration Number of Outages 1 Customer Interruptions 43 Circuit Substation Customer Minutes of Duration Fdr#16 Plant 1 5,762 Historical Monthly SAIDI Chart 5.0 4.0 3.0 _.... 2.0 1.0 .................... .,, , �r ......... ..., .................. 0.0 r` Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun 2022 2022 2022 2022 2022 2022 2023 2023 2023 2023 2023 2023 Historical Monthly SAIFI Chart 0.12 0.10 u 0.08 0.06 0.04 O.02 --- ::a ................................ s ........%.............................. �w .....,v ............ .................... , , , , Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun 2022 2022 2022 2022 2022 2022 2023 2023 2023 2023 2023 2023 Monthly SAIDI Average of monthly SAIDI values Monthly SAIFI Average of monthly SAIFI values Causes Ranked by Count Cause Non -Utility Excavation Causes Ranked by Duration Cause Count Duration Non -Utility Excavation 5,762 Top 1 Outages for the Month Address Customers Interrupted 1010 Dale St SW 43 Total Customers Affected for the Month: Average Customers Affected per Outage: Duration Customer Minutes of Interruption 134 5,762 Start Date 06/30/2023 43 43 �-01:44 1 Electric Production Work Total Total Order Description Materials Labor Budeeted Actual Difference 12203 Plant 2 Air Dryer - - $ - 29, 705.92 $ 29,705.92 12204 Cooling Tower Repairs $ - 239,115.47 $ 239,115.47 12206 Plant 2 Unilux Boiler - $ - 146,102.00 $ 146,102.00 12301 Plant 2 Ladder Access 225,000:00 $ - 12302 Plant 2 Power Gates 60,000.00 $ 12303 Plant 1 Tuck Pointing 140,000.00 $ - 12304 SWOIS Computer Upgrade U5 400,000.00 $ - 12305 Plant 1 Side Stream Filter 30,000.00 $ - 12306 Cooling Tower Drain Valves Plant 1 80,000.00 $ 12307 Cooling Tower Recirculation 120,000.00 $ 12308 Unit 1 Repairs - $ $ $ $ 414,923.39 $ 414,923.39 Work order Descri tion 22203 Plant 1 Sub SCADA Relays 22204 3M Sub SCADA 22213 EV Charging Station Transformer 22301 Hutch Sub Transformer Upgrade Engineering 22302 Pole Repair and Replacement 22303 Station Equipment 22304 HTI Sub SCADA 22305 Right of Way Clearing 22306 Install Duct 22307 Feeder 16 Reconductor 22308 APR Development (North of 202nd Circle NW) 22309 New Developments 22310 APR Development (North of 202nd Circle NW) 22311 Transformer Replacements 22312 Transformer New Development 22313 Meters 22314 Roberts Road Lights 22315 LED Conversion Electric Distribution Total Total Materials Labor Budgeted Actual Difference - - - 216,574.12 $ 216,574.12 - - - 87,932.99 $ 87,932.99 - - - 1,363.77 $ 1,363.77 200,000.00 200,000.00 23,994.50 $ (176,005.50) 15,000.00 15,000.00 $ (15,000.00) 10,000.00 10,000.00 $ (10,000.00) 125,000.00 125,000.00 $ (125,000.00) 15,000.00 15,000.00 $ (15,000.00) 18,000.00 65,000.00 83,000.00 16,557.52 $ (66,442.48) 42,000.00 75,000.00 117,000.00 49,380.23 $ (67,619.77) 15,000.00 7,000.00 22,000.00 380.96 $ (21,619.04) 60,000.00 60,000.00 39,203.15 $ (20,796.85) 8,000.00 2,000.00 10,000.00 $ (10,000.00) 48,000.00 14,000.00 62000.00 $ (62,000.00) 60,000.00 60:000.00 476.20 $ (59,523.80) 36,000.00 36,000.00 28,720.00 $ (7,280.00) 15,000.00 15,000.00 2,757.66 $ (12,242.34) 175,000.00 35,000.00 210,000.00 4,833.43 205,166.57 $ 842,000.00 $ 198,000.00 $ 1,040,000.00 $ 472,174.53 $ (567,825.47) Administrative Total Total Work Order Description Budgeted Actual Difference 52103 Natural Gas Service Truck $ - $ 71,781.58 $ (71,781.58) 52201 EV Fast Charger - 51,019.00 (51,019.00) 52203 Replace 037 Dump Truck 74,000.00 74,000.00 52204 Replace 130 56,475.48 (56,475.48) 52205 Replace 948 84,000.00 84,000.00 52206 Paint Booth 28,717.81 (28,717.81) 52301 International 4900 w/Altec 310,000.00 - 310,000.00 52302 Replace 995 2010 Dodge Dakota 35,000.00 - 35,000.00 52303 Replace 226 2012 Dodge RAM 1500 55,000.00 - 55,000.00 52304 Single Reel Trailer 20,000.00 21,220.99 (1,220.99) 52305 Underground Locator 7,500.00 - 7,500.00 52306 2023 Chevy Silverado 1500 - 44,509.02 ......................__w - .u,,,MM�............-�. $ 585,500.00 $ 273,723.88 $ (311,776.12) Work Order Descri t ion 62201 2 12" Valves, Vacuum Purging, Pigging Lat Lim 62301 HCP Interconnect 62302 RNG Interconnect 62303 Fairfax Interconnect Downsize 62304 SCADA for HCP Interconnect 62305 SCADA for RNG Interconnect 62306 Misc Developments & System Improvements 62307 City Projects 62308 50 psig Imp Project- Distribution Main 62309 Isolated Main Replacement 62310 Improvements to Regulator Stations 62311 50 psig Improvement Project- DRS 62312 Service Lines 62313 Meters, AMI, and All Fittings 62314 Residential Regulators 62315 Industrial Metering and Regulation 62316 CP AMI Monitors, AMI Pressure Monitors Natural Gas Total Total Materials Labor Bud Feted Actual Difference - - - 258,488.17 258,488.17 875,000.00 3,000.00 878,000.00 192.32 (877,807.68) 950,000.00 4,000.00 954,000.00 - (954,000.00) 65,000.00 1,000.00 66,000.00 - (66,000.00) 27,500.00 3,000.00 30,500.00 3,350.31 (27,149.69) 27,500.00 3,000.00 30,500.00 - (30,500.00) 50,000.00 10,000.00 60,000.00 1,554.12 (58,445.88) 15,000.00 3,000.00 18,000.00 5,665.99 (12,334.01) 700,000.00 3,000.00 703,000.00 - (703,000.00) 27,500.00 5,000.00 32,500.00 - (32,500.00) 20,000.00 5,000.00 25,000.00 - (25,000.00) 275,000.00 1,000.00 276,000.00 - (276,000.00) 57,000.00 15,000.00 72,000.00 19,422.74 (52,577.26) 165,000.00 4,000.00 169,000.00 11,906.66 (157,093.34) 9,000.00 9,000.00 4,546.30 (4,453.70) 25,000.00 3,500.00 28,500.00 24,525.65 (3,974.35) 50,000.00 3,000.00 53,000.00 _._WWWWWWWW - (53,000.00) .............4 $ 3,338,500.00 $ 66,500.00 $ 3,405,000.00 $ 329, 652.26 $ (3,075,347.74) ,c��,« HUTCHINSON UTILITIES COMMISSION Board Action Form f tit W Agenda Item: Review Policies Presenter: Jeremy Carter Agenda Item Type: Time Requested (Minutes): 5 Review Policies Attachments: Yes BACKGROUND/EXPLANATION OFAGENDA ITEM: As part of HUC's standard operating procedures, a continual policy review is practiced. This month, the following policies were reviewed and no changes are recommended on these policies at this time: i. Section 6 of Exempt Handbook ii. Section 6 of Non -Exempt Handbook iii. Appendices of Exempt Handbook iv. Appendices of Non -Exempt Handbook BOARD ACTION REQUESTED: None Fiscal Impact Included in current budget: Budget Change: PROJECTSECTION: Total Project Cost: Remaining Cost: Exempt SECTION 6 - HEALTH AND SAFETY HUC is very concerned about the safety of its employees and the public HUC serves. All employees are required to follow all HUC safety rules and make the safety of themselves, their co- workers, and the public a priority. To encourage a safe workplace, the Commission has adopted the APPA — Utilities Safety Handbook. Compliance with the APPA is "mandatory and is considered a requirement for employment". ACCIDENTS AND INJURIES Employees must immediately report to a Director, Manager or Supervisor j ob-related illnesses, all accidents and injuries (regardless how minor) that occur during the course of employment with HUC. The Employee and Supervisor must fill out and sign an accident report. If a supervisor is not available and the nature of injury or illness requires immediate treatment, the employee is to go to the nearest available medical facility for treatment and, as soon as possible, notify his/her supervisor of the action taken. In the case of a serious emergency, 911 should be called. If the injury is not of an emergency nature, but requires medical attention, the employee will report it to the supervisor and make arrangements for a medical appointment. Worker's compensation benefits and procedures to return to work will be applied according to applicable state and federal laws. Workers Compensation insurer is League of Minnesota Cities Insurance Trust (LMCIT). Pursuant to Minnesota Law, HUC has established a labor-management safety committee that investigates or reviews all accidents to identify causes of the accidents and suggest ways to prevent reoccurrence of the accident. The safety committee may request to interview any employee involved in an accident or any employee who may have knowledge of an accident. All employees are required to cooperate with the safety committee. I UNSAFE CONDITIONS OR PRACTICES Employees are required to report to a Director, Manager or Supervisor any unsafe conditions or practices they observe, including failure of a co-worker to follow safety rules or procedures. EMPLOYEE RIGHT -To -KNOW Minnesota's Employee Right -to -Know law requires HUC to inform employees when they may be exposed to hazardous substances, harmful physical agents, or infectious agents. HUC has adopted a written Employee Right -to -Know program. HUC has evaluated and reevaluates the work sites to determine the presence of hazardous substances. Employees shall become familiar with the location of Safety Data Sheets (SDS) in their work area. APPENDICES I, APPENDIX A - ACKNOWLEDGEMENT acknowledge that I have received a copy of the Hutchinson Utilities Employee Handbook and that I am responsible for being familiar with its contents. I understand the Hutchinson Utilities Employee Handbook does not create a contract between Hutchinson Utilities and me. I also understand that Hutchinson Utilities may revise the contents of the Employee Handbook at its discretion. Date: Employee's Signature 4 APPENDIX C — TEMPORARY EMPLOYEE ACKNOWLEDGEMENT I, ("the Commission") as have been hired by the Hutchinson Utilities Commission which is a temporary position. I acknowledge that this position will not exceed six (6) months and the Commission may terminate it without cause at any time. I also understand I accrue no rights to reappointment to this position if it becomes open again in the future. I understand as a temporary employee, I am not entitled to any benefits, and that I may be terminated from the position at any time and without cause. Date: Employee's Signature 5 APPENDIX D - ACKNOWLEDGEMENT I, acknowledge that I have received a copy of the APPA-Utilities Safety Handbook and that I am responsible for being familiar with its contents. I understand I must follow all safety rules and regulations in the APPA Safety Handbook and any other safety rules adopted by Hutchinson Utilities. Date: Employee's Signature 0 Non -Exempt SECTION 6 — HEALTH AND SAFETY HUC is very concerned about the safety of its employees and the public HUC serves. All employees are required to follow all HUC safety rules and make the safety of themselves, their co- workers, and the public a priority. To encourage a safe workplace, The Commission has adopted the APPA — Utilities Safety Handbook. Compliance with the APPA is "mandatory and is considered a requirement for employment". ACCIDENTS AND INJURIES Employees must immediately report to a Director, Manager or Supervisor j ob-related illnesses, all accidents and injuries (regardless how minor) that occur during the course of employment with HUC. The Employee and Supervisor must fill out and sign an accident report. If a supervisor is not available and the nature of injury or illness requires immediate treatment, the employee is to go to the nearest available medical facility for treatment and, as soon as possible, notify his/her supervisor of the action taken. In the case of a serious emergency, 911 should be called. If the injury is not of an emergency nature, but requires medical attention, the employee will report it to the supervisor and make arrangements for a medical appointment. Worker's compensation benefits and procedures to return to work will be applied according to applicable state and federal laws. Workers Compensation insurer is League of Minnesota Cities Insurance Trust (LMCIT). Pursuant to Minnesota Law, HUC has established a labor-management safety committee that investigates or reviews all accidents to identify causes of the accidents and suggest ways to prevent reoccurrence of the accident. The safety committee may request to interview any employee involved in an accident or any employee who may have knowledge of an accident. All employees are required to cooperate with the safety committee. 7 UNSAFE CONDITIONS OR PRACTICES Employees are required to report to a Director or Manager any unsafe conditions or practices they observe, including failure of a co-worker to follow safety rules or procedures. 91 EMPLOYEE RIGHT -To -KNOW Minnesota's Employee Right -to -Know law requires HUC to inform employees when they may be exposed to hazardous substances, harmful physical agents, or infectious agents. HUC has adopted a written Employee Right -to -Know program. HUC has evaluated and reevaluates the work sites to determine the presence of hazardous substances. Employees shall become familiar with the location of Safety Data Sheets (SDS) in their work area. PRESCRIPTION SAFETY GLASSES Employees must pay for their own eye examination (health insurance will generally cover 100% of examination expense). Any supplier who can provide certification that the prescription glasses meet OSHA safety requirements may fill the prescription. HUC will reimburse full-time employees up to $150.00, once every 12 months. Contact the Administrative/HR Coordinator for information regarding the Safety Glasses program, forms, and participating vendors. 10 I, APPENDICES APPENDIX A - ACKNOWLEDGEMENT acknowledge that I have received a copy of the Hutchinson Utilities Employee Handbook and that I am responsible for being familiar with its contents. I understand the Hutchinson Utilities Employee Handbook does not create a contract between Hutchinson Utilities and me. I also understand that Hutchinson Utilities may revise the contents of the Employee Handbook at its discretion. Date: Employee's Signature 11 APPENDIX B — NEW EMPLOYEE ACKNOWLEDGEMENT I, Commission") as have been hired by the Hutchinson Utilities Commission ("the I acknowledge that I will serve a six (6) month probationary period, ending the day of , 20 , unless the General Manager extends my probation a maximum of three (3) additional months. I understand that until my probationary period is completed, the Commission may terminate me at any time and without cause. Date: Employee's Signature 12 APPENDIX C — TEMPORARY EMPLOYEE ACKNOWLEDGEMENT I, ("the Commission") as have been hired by the Hutchinson Utilities Commission which is a temporary position. I acknowledge that this position will not exceed six (6) months and the Commission may terminate it without cause at any time. I also understand I accrue no rights to reappointment to this position if it becomes open again in the future. I understand as a temporary employee, I am not entitled to any benefits, and that I may be terminated from the position at any time and without cause. Date: Employee's Signature 13 APPENDIX D - ACKNOWLEDGEMENT I, acknowledge that I have received a copy of the APPA-Utilities Safety Handbook and that I am responsible for being familiar with its contents. I understand I must follow all safety rules and regulations in the APPA Safety Handbook and any other safety rules adopted by Hutchinson Utilities. Date: Employee's Signature 14 HUTCHINSON UTILITIES COMMISSION f tit ,c�,« Board Action Form Agenda Item: Approve Policy Changes Jeremv Carter App Changes to Policies es BACKGROUND/EXPLANATION OFAGENDA ITEM: As part of HUC's standard operating procedures, a continual policy review is practiced. The following revisions to the policies below are recommended. Appendix B — Exempt Handbook BOARD ACTION REQUESTED: Approve Policy Changes EXEMPT I, Commission") as APPENDIX B — NEW EMPLOYEE ACKNOWLEDGEMENT have been hired by the Hutchinson Utilities Commission ("the I acknowledge that I will serve a fii* (4) six (6) month probationary period, ending the day of , 20 , unless the General Manager extends my probation a maximum of three (3) additional months. I understand that until my probationary period is completed, the Commission may terminate me at any time and without cause. Date: Employee's Signature HUTCHINSON UTILITIES COMMISSION 9111t Board Action Form WWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW Agenda Item: Re -adopt the Data Practices policy of Hutchinson Utilities Commission Presenter: Marc Sebora Agenda Item Type: Time iRequested (Minutes): New Business Attachments: Yes BACKGROUND/EXPLANATION OFAGENDA ITEM: State law requires that political subdivisions like the Hutchinson Utilities Commission adopt a data practices policy which guides both the Hutchinson Utilities Commission and members of the public in obtaining information that the Hutchinson Utilities Commission retains. The data practices policy informs people of what type of information is public and what is not, how to obtain that information from the Hutchinson Utilities Commission, who is responsible for overseeing the data that is kept by the Hutchinson Utilities Commission, and what the cost is to obtain that data, if any. State law also requires that the Hutchinson Utilities Commission adopt the data practices policy annually prior to August 1 st. For your consideration and approval is the data practices policy for the Hutchinson Utilities Commission. There are no proposed changes from the version we adopted last year. I recommend adoption of the data practices policy. BOARD ACTION REQUESTED: Re -adopt the Hutchinson Utilities Commission Data Practices Policy Fiscal' Impact: 0 Included in current budget: Budget Change: PROJECT SECTION: Total Project Cost: Remaining Cost: Hutchinson Utilities Commission Guidelines and Procedures For the Minnesota Government Data Practices Act Subi ect 1 2 3 M 5 6 7 8 9 Hutchinson Utilities Commission Data Practices Procedures Table of Contents Introduction...............................................................................4 Responsible Authority..................................................................4 Access to Public Data...................................................................4 A. People Entitled to Access..........................................................5 B. Form of Request......................................................................5 C. Time Limits........................................................................ 5 D. Fees....................................................................................5 Access to Data on Individuals..........................................................5 A. People Entitled to Access...........................................................5 B. Form of Request..................................................................... 6 C. Identification of Requesting Party.................................................6 D. Time Limits...........................................................................6 E. Fees.....................................................................................6 F. Summary Data........................................................................ 6 G. Juvenile Records..................................................................... 7 Access to Customer Account Information .......................................... 7 Denialof Access..........................................................................7 Collection of Data on Individuals...................................................... 7 Challenge to Data Accuracy............................................................ 8 DataProtection........................................................................... 8 A. Accuracy and Currency of Data ................................................... 8 B. Data Safeguards.....................................................................8 2 Exhibits Page 1. List of Designees......................................................................... 10 2. Data Request/Cost Calculation Form .................................................. 11 3. Photocopying Charges...................................................................12 4. Consent to Release Private Data........................................................13 5. Information Disclosure Request........................................................14 6. Access and Nondisclosure Agreement................................................15 7. Data Practices Advisory (Tennessen Warning) ...................................... 17 8. Contract Language, Outside Agents .................................................. 18 Appendix Letter Nonpublic, Private & Confidential Data Maintained by the City ..................... A 3 HUTCHINSON UTILITIES COMMISSION DATA PRACTICES PROCEDURES 1. Introduction. These procedures are adopted to comply with the requirements of the Minnesota Data Practices Act (the "Act"), specifically Minn. Stat. Sec. 13.03, Subd. 2 and 13.05, Subd. 5 and 8. 2. Responsible Authority. The person who is the responsible authority for compliance with the Act is the General Manager. The responsible authority has designated certain other HUC employees to assist in complying with the act. These designees are listed on attached Exhibit 1. 3. Access to Public Data. All information maintained by HUC is public unless there is a specific statutory designation, which gives it a different classification. Categories of classification are as follows: Data on Individuals* MS 13.02, Subd. 5 Public Accessible to anyone MS 13.02, Subd. 15 Private Assessable to the data Subject; Not accessible To the public MS 13.02, Subd 12 Confidential Not accessible to the data subject; Not accessible to the public MS 13.02, Subd. 3 Data on Decedents MS 13.10, Subd. 1 Public Accessible to anyone MS 13.02, Subd. 15 Private * * Assessable to the representative of the descendent; Not accessible To the public MS 13.10, Subd 1B Confidential * * Not accessible to the representative of the descendent; Not accessible to the public MS 13.10, Subd. IA Data not on Individuals* MS 13.02, Subd. 4 Public Accessible to anyone MS 13.02, Subd. 14 Nonpublic Accessable to the data subject; Not accessible to the public MS 13.02, Subd 9 Protected Nonpublic Not accessible to the data subject; Not accessible to the Public MS 13.02, Subd. 13 M Individual is defined at MS 13.02, subdivision 8. Individual means a living human being. It does not mean any type of entity created by law, such as a corporation. * * Private and confidential data on decedents become public data ten years after the death of the data subject and 30 years after the creation of the data. A. People Entitled to Access. Any person has the right to inspect and copy public data. The person also has the right to have an explanation of the meaning of the data. The person does not need to state his or her name or give the reason for the request. B. Form of Request. The request for public data may be verbal or written. C. Time Limits. Requests. Requests will be received and processed only during normal business hours. Response._ If copies cannot be made at the time of the request, copies must be supplied as soon as reasonably possible. D. Fees. Fees may be charged only if the requesting person asks for a copy or electronic transmittal of the data. Fees will be charged according to HUC's standard photocopying policy, attached as exhibit 2, unless significant time is required. In that case, the fee will include the actual cost of searching for, retrieving, and copying or electronically transmitting the data. The fee may include time necessary to separate public from non-public data. The responsible authority may also charge an additional fee if the copies have commercial value and are a substantial and discreet portion of a formula, compilation, program, process, or system developed with significant expenditure of public funds. This additional fee must related to the actual development costs of the information. 4. Access to Data on Individuals. Information about individual people is classified by law as public, private, or confidential. A list of the private and confidential information maintained by HUC is contained in Appendix A. A. People Entitled to Access. Public information about an individual may be shown or given to anyone. Private information about an individual may be shown or given to: ► The individual, but only once every six months, unless a dispute has arisen or additional data has been collected. ►A person who has been given access by the express written consent of the data subject. This consent must be on the form attached as Exhibit 4, or a form reasonable similar. ►People who are authorized access by the federal, state, or local law or court order. ►People about whom the individual was advised at the time the data was collected. The identity of those people must be part of the Tennessen warning described below. ►People within HUC staff, HUC Commission Members, and outside agents (such as attorneys) whose work assignments or responsibilities reasonably require access. * Confidential information may not be given to the subject of the data, but may be given or shown to: ►People who are authorized access by federal, state, or local law or court order. ►People within HUC staff, HUC Commission Members, and outside agents (such as attorneys) whose work assignments or responsibilities reasonably require access. B. Form or Request. Any individual may request verbally or in writing. If HUC has stored data about that individual and whether the data is classified as public, private, or confidential. All requests to see or copy private or confidential information must be in writing. An Information Disclosure Request, attached as Exhibit 5, must be completed to document who requests and who receives this information. The responsible authority or designee must complete the relevant portions of the form. The responsible authority or designee may waive the use of this form if there is other documentation of the requesting party's identity, the information requested, and HUC's response. C. Identification of Requesting Party. The responsible authority or designee must verify the identity of the requesting party as a person entitled to access. This can be through personal knowledge, presentation of written identification, comparison of the data subject's signature on a consent form with the person's signature in HUC records, or other reasonable means. D. Time Limits. *Requests. Requests will be received and processed only during normal business hours. *Response. The response must be immediate, if possible, or within 5 working days, if an immediate response is not possible. HUC may have an additional 5 working days to respond if it notifies the requesting person that it cannot comply within 5 days. E. Fees. Fees may be charged in the same manner as for public information. F. Summary Data. Summary data is statistical records and reports derived from data on individuals but which does not identify an individual by name or any other characteristic that could uniquely identify an individual. Summary data derived from private or confidential data is public. The responsible authority or designee will 0 prepare summary data upon request, if the request is in writing and the requesting parry pays for the cost of the preparation. G. The responsible authority or designee must notify the requesting party about the estimated costs and collect these costs before preparing or supplying the summary data. This should be done within 10 days after receiving the request. If the summary data cannot be prepared within 10 days, the responsible authority must notify the requester of the anticipated time schedule and the reason for the delay. Summary data may be prepared by "blacking out" personal identifiers, cutting out portions of the records that contain personal identifiers, programming computers to delete personal identifiers, or other reasonable means. The responsible authority may ask an outside agency or person to prepare the summary data if (1) the specific purpose is given in writing (2) the agency or person agrees not to disclose the private or confidential data, and (3) the responsible authority determines that access by this outside agency or person will not compromise the privacy of the private or confidential data. The responsible authority may use the form attached as Exhibit 6. 5. Access to Customer Account Information. Information pertaining to a customer's account, including names, gas and electric usage and all financial information pertaining to the account, is private information and will only be released to the person named on the account or the person(s) designated on a Consent to Release Private Data form as attached hereto as Exhibit 4. 6. Denial of Access. If the responsible authority or designee determines that the requested data is not accessible to the requesting parry, the responsible authority or designee must inform the requesting party orally at the time of the request or in writing as soon after that as possible. The responsible authority or designee must give the specific legal authority, including statutory section, for withholding the data. The responsible authority or designee must place an oral denial in writing upon request. This must also include the specific legal authority for the denial. 7. Collection of Data on Individuals. The collection and storage of information about individuals will be limited to that necessary for the administration and management of the programs specifically authorized by the state legislature, HUC Board Members, or federal government. When an individual is asked to supply private or confidential information about the individual, HUC employees requesting the information must give the individual a Tennessen warning. This warning must contain the following: C. The purpose and intended use of the requested data, D. Whether the individual may refuse or is legally required to supply the requested data, E. Any known consequences from supplying or refusing to supply the information, and F. The identity of other persons or entities authorized by state or federal law to receive the data. 7 A Tennessen warning is not required when an individual is requested to supply investigative data to a law enforcement officer. A Tennessen warning may be on a separate form or may be incorporated into the form which requests the private or confidential data. See attached Exhibit 7. 8. Challenge to Data Accuracy. An individual who is the subject of public or private may contest the accuracy or completeness of that data maintained by HUC. The individual must notify HUC's responsible authority in writing describing the nature of the disagreement. Within 30 days, the responsible authority or designee must respond and either (1) correct the data found to be inaccurate or incomplete and attempt to notify past recipients of inaccurate or incomplete data, including recipients named by the individual, or (2) notify the individual that the authority believes the data to be correct. An individual who is dissatisfied with the responsible authority's action may appeal to the Commissioner of the Minnesota Department of Administration, using the contested case procedures under Minnesota Statues Chapter 14. The responsible authority will correct any data if so ordered by the Commissioner. 9. Data Protection. b. Accuracy and Currency of Data. A. All employees will be requested, and given appropriate forms, to provide updated personal information to the appropriate supervisor, General Manager, or Business Manager, which is necessary for tax, insurance, emergency notification, and other personnel purposes. Other people who provide private or confidential information will also be encouraged to provide updated information when appropriate. B. Department heads should periodically review forms used to collect data on individuals to delete items that are not necessary and to clarify items that may be ambiguous. C. All records must be disposed of according to the State of Minnesota General Records Retention Schedule. c. Data Safeguards. *Private and confidential information will be stored in files or databases which are not readily accessible to individuals who do not have authorized access and which will be secured during hours when the offices are closed. Such information will be labeled in a manner warning that the information is private and/or confidential and is not to be released to unauthorized individuals. Storage containers for these documents will have substantially the same warning. *Only those employees whose job responsibilities require them to have access will be allowed access to files and records that contain private or confidential information. These employees will be instructed to: A. Not to discuss, disclose, or otherwise release private or confidential data to HUC employees whose job responsibilities do not require access to the data. B. Not leave private or confidential data where non -authorized individuals might see it, and C. Shred private or confidential data before discarding. *When a contract with an outside party requires access to private or confidential information, the contracting party will be required to use and disseminate the information consistent with the Act. HUC may include in a written contract the language contained in Exhibit 8. 9 Exhibit 1 LIST OF DESIGNEES The Minnesota Data Practices Act establishes a system for compilation and distribution of data gathered by government agencies. All data collected and maintained by Hutchinson Utilities Commission ("HUC") is presumed public and is accessible to the public for both inspection and copying, unless classified as Private, Confidential, Nonpublic or Protected Nonpublic in accordance with Federal law, State Statute or a temporary classification. The Hutchinson Utilities Commission has appointed the following position to administer this system. Responsible Authority General Manager Hutchinson Utilities Commission 225 Michigan St. SE Hutchinson, MN 55350 (320) 587-4746 Positions appointed as Designees in system administration are as follows: Official Records Clerk Administrative Coordinator Hutchinson Utilities Commission 225 Michigan St. SE Hutchinson, MN 55350 (320) 587-4746 Other positions responsible for maintenance of HUC Records are as apparent or assigned. 10 Exhibit 2 DATA REQUEST COST CALCULATION FORM Fees charged are in accordance with Minn. Statute Section 13.03 (3) Date of Request: Description of information requested: (Please be specific) Costs for duplication of standard materials are included on Exhibit 3. Please use this section to calculate fees for other data requests. Estimated Cost Actual Cost A. LABOR X 4 Hours Hourly Rate X #Hours Hourly Rate B. PHOTOCOPY X Rate #Pages C. MAILING X D. PRINTING COSTS E. OTHER COSTS (May include computer time, programming, terminal access, microfilming and any other costs not listed above.) 1. 2. 3. 4. TOTAL CHARGES AMOUNT TO BE PREPAID (50% of est. total if exceeds $50) AMOUNT DUE UPON COMPLETION PREPARED BY: DEPARTMENT: DATE: 11 Exhibit 3 Photocopying Charges The following rates shall apply for request of standard materials: STANDARD CHARGES Photo Copies 25 cents/page Document Research $25/hour MN Statute 13.03 Subd. 3. Request for access to data. (a) Upon request to a responsible authority or designee, a person shall be permitted to inspect and copy public government data at reasonable times and places, and, upon request, shall be informed of that data's meaning. If a person requests access for the purpose of inspection, the responsible authority may not assess a charge or require the requesting person to pay a fee to inspect data. (b) For purposes of this section, "inspection" includes but is not limited to, the visual inspection of paper and similar types of government data. Inspection does not include printing copies by the government entity, unless printing a copy is the only method to provide for inspection of the data. (c) The responsible authority or designee shall provide copies of public data upon request. If a person requests copies or electronic transmittal of the data to the person, the responsible authority may require the requesting person to pay the actual costs of searching for and retrieving government data, including the cost of employee time, and for making copies, certifying, compiling, and electronically transmitting the copies of the data, but may not charge for separating public from nonpublic data. If the responsible authority is not able to provide copies at the time a request is made, copies shall be supplied as soon as reasonably possible. 12 Exhibit 4 CONSENT TO RELEASE PRIVATE DATA I, , authorize the Hutchinson Utilities Commission to release the following private data about me: To the following person or people: The person or people receiving the private data may use it only for the purpose or purposes: This authorization is dated and expires on The expiration cannot exceed one year from the date of the authorization, except in the case of authorizations given in connection with applications for life insurance or non -cancelable or guaranteed renewable health insurance and identified as such, two years after the date of the policy. I agree to give up and waive all claims that I might have against HUC, its agents and employees for releasing data pursuant to this request. Signature Identity Verified By: Witness: X Identification: Driver's License, State ID, Passport, other: Comparison with signature on file Other: Responsible Authority/Designee: 13 Exhibit 5 INFORMATION DISCLOSURE REQUEST Minnesota Government Data Practices Act A. Completed by Requester Name (Last, First, MI) Date of Request Street Address City, State, Zip Phone Number Signature Description of the information requested: attach additional sheets if necessary) B. Completed by Hutchinson Utilities Commission Handled by: Information classified as: Public Non -Public Private Protected Non -Public Confidential Action: Approved Approved in part (Explain Below) Denied (Explain Below) Remarks or basis for denial including MN Statute if applicable: Charges: None Photocopy: Pages x cents = Special Rate: Explanation: Other: Explanation: Authorized Signature Identify Verified for Private Information: Identification: Driver's License, Etc. Comparison with Signature on File Personal Knowledge Other: Date 14 Exhibit 6 GOVERNMENT DATA ACCESS AND NONDISCLOSURE AGREEMENT AUTHORIZATION. Hutchinson Utilities Commission ("HUC") hereby authorizes , ("Authorized Party") access to the following government data: 2. PURPOSE. Access to this government data is limited to the objective of creating summary data for the following purpose: 3. COST. (Check which applies): The Authorized Parry is the person who requested the summary data and agrees to bear HUC's costs associated with the preparation of the data which has been determined to be $ The authorized Parry has been requested by HUC to prepare summary data and will be paid in accordance with Attached Exhibit 4. SECURITY. The Authorized Parry agrees that if it and any employees or agents under its control must protect the privacy interests of individual data subjects in accordance with the terms of this Agreement. The Authorized Parry agrees to remove all unique personal identifiers which could be used to identify any individual from data classified by state or federal law as not public which is obtained from HUC records and incorporated into reports, summaries, compilations, articles, or any document or series of documents. Data contained in files, records, microfilm, or other storage media maintained by HUC are HUC's property and are not to leave HUC's custody. The Authorized Party agrees not to make reproductions of any data or remove any data from the site where it is provided, if the data can in any way identify an individual. No data which is not public and which is irrelevant to the purpose stated above will ever be disclosed or communicated to anyone by any means. The Authorized party warrants that the following named individual(s) will be the only person(s) to participate in the collection of the data described above: 15 5. LIABILITY FOR DISCLOSURE. The Authorized parry is liable for any unlawful use or disclosure of government data collected, used and maintained in the exercise of this agreement and is classified as not public under state or federal law. The Authorized Parry understands that it may be subject to civil or criminal penalties under those laws. The Authorized party agrees to defend, indemnify, and hold the HUC, its officers and employees harmless from any liability, claims, damages, costs, judgments, or expenses, omission of the Authorized Party's failure to fully perform in any respect all obligations under this agreement. 6. INSURANCE. In order to protect itself as well as HUC, the Authorized parry agrees at all times during the term of this Agreement to maintain insurance covering the Authorized Party's activities under this Agreement. The insurance will cover $1,000,000 per claimant for personal injuries and/or damages and $1,000,000 per occurrence. The policy must cover the indemnification obligation specified above. 7. ACCESS PERIOD. The Authorized Party may have access to the information described above from to 8. SURVEY RESULTS. (Check which applies): If the Authorized Party is the requester, a copy of all reports, summaries, compilations, articles, publications or any document or series of documents that are created from the information provided under this agreement must be made available to HUC in its entirety. If the Authorized Party is a contractor of HUC, all copies of reports, summaries, compilations, articles, publications or any document or series of documents that are created from the information provided under this agreement must be provided to HUC. The Authorized party may retain one copy for its own records but may not disclose it without HUC permission, except in defense of claims brought against it. AUTHORIZED PARTY: Title (if applicable): HUTCHINSON UTILITIES COMMISSION: Its: Date: Date: 16 Exhibit 7 DATA PRACTICES ADVISORY (Tennessen Warning) Some or all of the information that you are asked to provide on the attached form is classified by State law as either private or confidential. Private data is information that generally cannot be given to the public but can be given to the subject of the data. Confidential data is information that generally cannot be given to either public or the subject of the data. Our purpose and intended use of this information is: You are are not legally required to provide this information. If you refuse to supply the information, the following may happen: Other persons or entities authorized by law to receive this information are: 17 Exhibit 8 SAMPLE CONTRACT PROVISION Data Practices Compliance. Contractor will have access to data collected or maintained by HUC to the extent necessary to perform Contractor's obligation under this contract. Contractor agrees to maintain all data contained from HUC in the same manner as HUC is required under the Minnesota Government Data Practices Act, Minn. Stat. Chap. 13 (the Act). Contractor will not release or disclose the contents of data classified as not public to any person except at the written direction of HUC. Contractor agrees to defend and indemnify HUC from any claim, liability, damage or requirements of the Act or this contract. Upon termination of this contract, Contractor agrees to return data to HUC as requested by HUC. In APPENDIX A NONPUBLIC, PRIVATE & CONFIDENTIAL DATA MAINTAINED BY HUTCHINSON UTILITIES COMMISSION 1. PERSONNEL DATA (PRIVATE) Generally all data about people who are or were an employee, applicant for employment, volunteer, independent contractor, or member of the Hutchinson Utilities Commission is private, with the exceptions noted below. Public Data —Applicants The following data on current and former applicants is public: * Veteran Status * Relevant test scores * Rank on eligible list * Education and training * Work availability * Name, after being certified as eligible for appointment to a vacancy or when considered a finalist for a position of public employment (which occurs when the person has been selected to be interviewed by the appointing authority) * Names and addresses of applicants for appointment to and members of an advisory board or commission. Public Data — Employees The following data on current and former employees, volunteers, independent contractors, and members of advisory boards and commissions are public: * Name * Actual gross salary * Salary range * Contract fees * Actual gross pension * Value and nature of employer paid fringe benefits * Basis for and the amount of added remuneration, including expense reimbursement, in addition to salary * Job title * Job Description * Education and training background * Previous work experience 19 * Date of first and last employment * The existence and status (but not nature) of any complaints or charges against the employee, regardless of whether the complaint or charge resulted in a disciplinary action * Terms of any agreement settling any dispute arising from the employment relationship, including a "buyout" agreement. * Work location * Work telephone number * Badge number * Honors and awards received * Payroll time sheets or other comparable data that are only used to account for employee's work time for payroll purposes, except to the extent that release of time sheet data would reveal the employee's reasons for the use of sick or other medical leave or other non- public data. * City and county of residence Access by Labor Organizations Personnel data may be given to labor organizations and the Bureau of Mediation Services to the extent this it is necessary to conduct elections, notify employees of fair share fee assessments, or to implement state labor laws. Employee Assistance Programs All data associated with employee assistance programs is private. Harassment When there is a harassment complaint against an employee, the employee may not have access to data that would identify the complainant or other witnesses if the data would threaten the personal safety of the complainant or witness, or subject the complainant or witness to harassment. However, this information will be provided to the employee in order for him/her to prepare for a disciplinary proceeding that has been initiated. Peer Counseling Debriefing Data acquired by a peer group member in a public safety peer counseling debriefing is private data on the person being debriefed. Protection of Employee or Others If it is reasonably necessary to protect an employee from harm to self or to protect another person who may be harmed by the employee, information that is relevant to the safety concerns may be released to (1) the person who may be harmed or to the person's attorney when relevant to obtaining a restraining order, (2) a prepetition screening team in the commitment process, or (3) a court, law enforcement agency or prosecuting authority. 2. PROPERTY COMPLAINT DATA (CONFIDENTIAL). Minn. Stat. 13.44 The identities of individuals who register complaints concerning violations of state laws or local ordinances concerning the use of real property. 20 3. PLANNING QUESTIONAIRES (PRIVATE). Minn. Stat. 13.59 Names, addresses, and legal descriptions of property, that are collected in questionnaires or surveys of individuals and businesses for the purposes of planning, development, or redevelopment. 4. SECURITY INFORMATION (Nonpublic). Minn. State. 13.37 Data which is disclosed would be likely to substantially jeopardize the security of information, possessions, individuals or property against the theft, tampering, improper use, attempted escape, illegal disclosure, trespass, or physical injury. This includes crime prevention programs and their home addresses and telephone numbers, but these may be disseminated to other volunteers participating in crime prevention programs. 5. SEALED BIDS (Nonpublic) Minn. Stat. 13.37 6. LABOR RELATIONS INFORMATION (Nonpublic). Minn. Stat. 13.37 Management positions on economic and non -economic items that have not been presented during the collective bargaining process or interest arbitration, including information collected or created to prepare the management position. 7. EXAMINATION DATA (Nonpublic). Minn. Stat. 13.34 Completed versions of personnel and licensing examinations shall be accessible to the individual who completed the examination, unless the responsible authority determines that access would compromise the objectivity, fairness, or integrity of the examination process. 8. ELECTED OFFICIALS CORRESPONDENCE (PRIVATE). Minn. Stat. 13.601 Correspondence between individuals and elected officials is private data on individuals, but may be made pubic by either the sender or the recipient. 9. BENEFIT DATA (PRIVATE). Minn. Stat. 13.462 All data about individuals participating in HUC's rehabilitation program. 10. APPRAISAL DATA (CONFIDENTIAL). Minn. Stat. 13.44 Appraisals made for the purpose of selling or acquiring land. 11. CITY ATTORNEY RECORDS. Minn. Stat. 13.393 Statutes, rules, and professional standards concerning discovery, production of documents, introduction of evidence, and professional responsibility govern the use, collection, storage, and dissemination of data by the city attorney. 12. COMMISSION MEETINGS HAVING DATA CLASSIFIED AS NONPUBLIC Minn. Stat. 13D.05 21 Subd. 2. When meeting must be closed: (a) any portion of a meeting must be closed if expressly required by other law or if the following types of data are discussed: 1. data that would identify alleged victims or reporters of criminal sexual conduct, domestic abuse, or maltreatment of minors or vulnerable adults; 2. internal affairs data relating to allegations of law enforcement personnel misconduct collected or created by a state agency, statewide system, or political subdivision; or educational data, health data, medical data, welfare data, or mental health data that are not public data. (b) A public body shall close one or more meetings for preliminary consideration of allegations or charges against an individual subject to its authority. If the members conclude that discipline of any nature may be warranted as a result of those specific charges or allegations, further meetings or hearings relating to those specific charges or allegations held after that conclusion is reached must be open. A meeting must also be open at the request of the individual who is the subject of the meeting. Subd. 3. When meeting may be closed. (a) a public body may close a meeting to evaluate the performance of an individual who is subject to its authority. The public body shall identify the individual to be evaluated prior to closing a meeting. At its next open meeting, the public body shall summarize its conclusions regarding the evaluation. A meeting must be open at the request of an individual who is the subject of the meeting. (b) Meetings may be closed if the closure is expressly authorized by statute or permitted by the attorney -client privilege. 22 HUTCHINSON UTILITIES COMMISSION��` Board Action Form �r�turscti mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm Agenda Item: Hutchinson Substation 83 MVA Transformer - Advertisement for Bids - Date Extension Presenter: D. Lang Agenda Item; Type: Time Requested (Minutes): 5 New Business Attachments: Yes BACKGROUND/EXPLANATION OFAGENDA ITEM: Staff is requesting Board approval to extend the bid opening date to Sept 7, 2023 at 2:OOpm for bids for a transformer to be installed at the Hutchinson Substation as part of the 115kV expansion project. The revised Advertisement for Bids will be published in the local paper and Addendum #1 will be sent to prospective bidders if extension is approved. Attachments: -Add #1_Hutch Sub Autotransformer.pdf July 2023 BOARD ACTION REQUESTED: Extend bid opening date to Sept 7, 2023 at 2:OOpm for the Hutchinson Substation 83 MVA Transformer Fiscal Impact: TBD Included in current budget: Budget Change: PROJECT SECTION: Total Project Cost: Remaining Cost: DATE: July 27, 2023 DGI ENGINEERING PROJECT: Furnishing and Delivery of a 115/69 kV Autotransformer —Hutchinson Substation Hutchinson Utilities Commission Hutchinson, Minnesota DGR Project No. 428507 BID DUE DATE: September 7, 2023 2:00 P.M. 225 Michigan St. SE, Hutchinson, MN 55350 ADDENDUM NO. 1 This ADDENDUM NO. 1 hereby revises the Contract Documents dated July 5, 2023. Revisions made herein shall become a binding part of the Contract Documents. Advertisement for Bids Sealed bids will be received until 2:00 PM CST, on September 7, 2023 2. General Requirements 1.02 CONTRACT AWARD: A. The Owner will award one (1) Contract for the Autotransformer as deemed in the best interest of the Owner. The following dates represent the proposed schedule for this Contract: Sep 7, 2023 Bid Opening Sep 2023* Owner Awards Contract Jul 31, 2025 + Delivery of Autotransformer Sep 15, 2025 + Field assembly and testing complete * Date subject to change. + Contract Price deductions (liquidated damages) apply to these dates. Delivery of the transformer is desired to be no earlier than September 1, 2024 and no later than July 31, 2025. Based on current material availability, both later and earlier delivery dates will be considered by the Owner. This ADDENDUM NO. 1 shall become a legal and binding part of the Contract Documents. All BIDDERS shall acknowledge receipt of this ADDENDUM NO. 1 on the BID FORM and agree to accept the revisions indicated and prepare proposals in accordance therewith. DGR ENGINEERING Alexander M. Richter, P.E. Minnesota License No. 59098 DGR Engineering — 1302 South Union Street — P.O. Box 511 — Rock Rapids, IA 51246 phone: 712.472.2531 — fax: 712.472.2710 — dgr.com \O,: \�285\07\f:)rc\Sp c\Xfini \Add # 1 1 VuLdh Sub AuLrtairsfa Fnei docx ADVERTISEMENT FOR BIDS * * *NOTE REVISED BID DATE * * * Notice is hereby given that on the 7" day of September 2023, until 2:00 p.m., sealed bids will be received by the Hutchinson Utilities Commission of the city of Hutchinson, Minnesota, at the Hutchinson Utilities office, 225 Michigan St. SE, Hutchinson, MN 55350 and will be publicly opened and read aloud. The material required to be furnished, delivered, and installed is as follows: One (1) 50/66.7/83.3 MVA @65°C rise ONAN/ONAF/ONAF, autotransformer,115GY/69GY kV with LTC and accessories. The above equipment shall be in accordance with the Specifications and proposed form of Contract now on file at the Hutchinson Utilities Commission, Hutchinson, Minnesota by this reference made apart hereof, as though fully set out and incorporated herein. Bidders desiring a copy of the bid forms and Specifications for individual use may obtain them from the Office of the Engineer, DGR Engineering, 1302 South Union, PO Box 511, Rock Rapids, Iowa 51246, telephone 712-472-2531, fax 712-472-2710, website www.dgr.com, e-mail dgr(�dgr.com, no deposit required. Each bid shall be made out on a bid form furnished by the Engineer and shall be accompanied by either a bid Bond issued by a Surety authorized to do business in the State of Minnesota and made payable to the Hutchinson Utilities Commission, or a certified check, cashier's check, or bank draft drawn on a state or national bank made payable to the Hutchinson Utilities Commission in a sum equal to five percent (5%) of the total bid. The bid security must not contain any conditions either in the body or as an endorsement thereon. Such bid security shall be forfeited to the Commission as liquidated damages in the event the successful Bidder fails or refuses to enter into a Contract within fifteen (15) days after the award of Contract and post satisfactory Performance and Payment Bonds. The successful Bidder shall furnish a Performance Bond in an amount equal to one hundred per cent (100%) of the Contract Price and a Certificate of Insurance with appropriate limits to the Owner prior to the approval of the Contract. Bid envelopes must be clearly marked Bid Enclosed — Hutchinson Sub - Furnishing 115/69 kV Autotransformer. Upon shipment of the completed equipment, the Contractor shall submit to the Owner a detailed statement of the equipment shipped and installed. The Owner shall, within thirty (30) days after delivery receipt of the material and associated invoice, pay the Contractor ninety-five percent (95%) of the Base Price of the material. The Owner shall within thirty (30) days after final completion, field assembly, testing, required test reports, record Drawings, final documentation, and certification by Engineer, pay the Contractor the remaining five percent (5%) of the Base Price. All materials shall be delivered by the dates set in the Specifications. The Hutchinson Utilities Commission of the City of Hutchinson, Hutchinson Minnesota reserves the right to defer acceptance of any bid for aperiod not to exceed thirty (30) days after the date bids are received and no bid may be withdrawn during this period. The Commission also reserves the right to waive irregularities and to reject any or all bids as it shall deem to be in the best interest of the Commission. P:A04\285\07\DocASpecAXfmr\A13 Rev l.docx A -I President Date ATTESTED Secretary Date P:A04\285\07\DocASpecAXfmr\AB Rev l.docx A_2 HUTCHINSON UTILITIES COMMISSION��` Board Action Form �r�turscti mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm Agenda Item: Electric & Natural Gas Rate Structure Change Presenter: Jeremy Carter Agenda Item; Type: Time Requested (Minutes): 15 New Business Attachments: Yes BACKGROUND/EXPLANATION OFAGENDA ITEM: Utility Financial Services has been involved in extensive analysis of Hutchinson Utilities Commission business model and cost drivers. As part of this analysis, a Cost of Service study identified various financial benchmarks and recommendations. In addition, considerations were discussed relating to ensuring the various components of how HUC collects revenue through its monthly billing aligns well against the fixed and variable costs of operation. Based on the Cost of Service results and feedback from the Commission, Utility Financial Services proposes a 3 year rate track for both the Electric and Natural Gas division. Please see attached a resolution for approval that would continue to move the various classes towards the cost of service results and continue to align the various revenue components to the operational cost components. Once this resolution is approved, the rate design structures would be communicated to the city council. BOARD ACTION REQUESTED: Approve 3 Year Rate Structure Change Resolution Fiscal Impact: —$650K-$680K Annually Included in current budget: No Budget Change: PROJECT SECTION: Total Project Cost: Remaining Cost: Resolution No. 23-01 A RESOLUTION CHANGING THE HUTCHINSON UTILITIES COMMISSION RATE STRUCTURE FOR 2023, 2024 & 2025 FOR ELECTRIC AND NATURAL GAS DIVISIONS Be It Resolved by the Hutchinson Utilities Commission: That the current Electric and Natural Gas Retail Rates paid by customers of the Hutchinson Utilities Commission be changed as follows: Electric Division Table: Current 2023 2024 2025 Residential Monthly Customer Charge $16.90 $17.00 $17.10 $17.20 Energy Charge (per KWH) $0.07852 $0.08235 $0.08632 $0.09040 Small General Monthly Customer Charge $21.60 $23.90 $26.20 $28.50 Energy Charge (per KWH) Block 1 (0-2000 KWH) $0.08994 $0.09242 $0.09504 $0.09780 Block 2 (More than 2000 KWH) $0.08078 $0.08300 $0.08536 $0.08784 Large General Monthly Customer Charge $107.60 $122.50 $137.40 $152.30 Energy Charge (per KWH) $0.05783 $0.05796 $0.05812 $0.05832 Demand Charge (per KW) $10.00 $10.50 $11.00 $11.50 Large Industrial Monthly Customer Charge $300.80 $344.70 $388.60 $432.50 Energy Charge (per KWH) $0.05274 $0.05328 $0.05385 $0.05445 Demand Charge (per KW) $11.00 $11.50 $12.00 $12.50 Security Lights Monthly Customer Charge Sect 150 $3.00 - - - SecL 250 $3.50 - - - SecL 400 $4.08 - - - SecL 150 Unmetered $7.00 - - - SecL 250 Unmetered $10.00 - - - SecL450 Unmetered $13.26 - - - SecL 70 Watt LED metered $3.00 $3.14 $3.28 $3.42 Sect 70 Watt LED Unmetered $7.00 $7.32 $7.64 $7.99 Natural Gas Division Table: Current 2023 2024 2025 Residential Monthly Customer Charge $16.10 $16.70 $17.30 $17.90 Gas Commodity Charge (per MCF) $7.4040 $7.3000 $7.2000 $7.1000 Commercial Monthly Customer Charge $64.70 $76.70 $88.70 $100.70 Gas Commodity Charge (per MCF) $7.9682 $7.6937 $7.4192 $7.1447 Large Industrial Monthly Customer Charge $285.00 $311.00 $337.00 $363.00 Gas Commodity Charge (per MCF) $7.5450 $7.5450 $7.5450 $7.5450 Demand Charge (Max Daily MCF/month) $8.00 $8.00 $8.00 $8.00 AND BE IT FURTHER RESOLVED, that the General Manager of the Hutchinson Utilities Commission, Jeremy J Carter, shall provide notice of these rate changes to the City Council of the City of Hutchinson. Adopted by the Hutchinson Utilities Commission this day of .2023 Hutchinson Utilities Commission Anthony Hanson, President Attest: Don Martinez, Secretary ELECTRIC RATES Current Rates Residential Monthly Charge $ 16.90 Energy Charge (per Kwh) $ 0.07852 Small General Monthly Charge $ 21.60 Energy Charge (per Kwh) "Block 1" $ 0.08994 Energy Charge (per Kwh) "Block 2" $ 0.08078 Large General Monthly Charge $ 107.60 Energy Charge (per Kwh) $ 0.05783 Demand Charge (per KW) $ 10.00 Industrial Monthly Charge $ 300.80 Energy Charge (per Kwh) $ 0.05274 Demand Charge (per KW) $ 11.00 NATURAL GAS RATES Current Rates Residential Monthly Charge $ 16.10 Gas Commodity Charge (per MCF) $ 7.4040 Commercial Monthly Charge $ 64.70 Gas Commodity Charge (per MCF) $ 7.9682 Large Industrial Monthly Charge $ 285.00 Gas Commodity Charge (per MCF) $ 7.5450 Demand Charge (Max Daily MCF per/month) $ 8.00 Contract Industrial Customers Customer #1 Monthly Charge $ 215.00 Transportation Charge $ 1.00 Demand Charge (Max Daily MCF per/month) $ 10.33 Customer #2 Monthly Charge $ 215.00 Transportation Charge $ 0.4700 Demand Charge (Max Daily MCF per/month) $ 9.00 PROPOSED RATE SCHEDULE Rate Class Annual % Inc.:: 30/1/2023 30/1/2024 30/1/2025 $ 17.00 $ 17.10 $ 17.20 3.70% $ 0.08235 $ 0.08632 $ 0.09040 $ 23.90 $ 26.20 $ 28.50 3.60% $ 0.09242 $ 0.09504 $ 0.09780 $ 0.08300 $ 0.08536 $ 0.08784 $ 122.50 $ 137.40 $ 152.30 1.90% $ 0.05796 $ 0.05812 $ 0.05832 $ 10.50 $ 11.00 $ 11.50 $ 344.70 $ 388.60 $ 432.50 1.90% $ 0.05328 $ 0.05385 $ 0.05445 $ 11.50 $ 12.00 $ 12.50 *PROPOSED RATE SCHEDULE **ALTERNATE RATE SCHEDULE Rate Class I Annual % Inc, 30/1/2023 30/1/2024 30/1/2025 30/1/2023 30/1/2024 30/1/2025 $ 16.70 $ 17.30 $ 17.90 - - - 0.00% $ 7.3000 $ 7.2000 $ 7.1000 - - - $ 76.70 $ 88.70 $ 100.70 - - - 0.00% $ 7.6937 $ 7.4192 $ 7.1447 - - - $ 311.00 $ 337.00 $ 363.00 $ 311.00 $ 337.00 $ 363.00 .1%/.5% $ 7.5450 $ 7.5450 $ 7.5450 $ 7.5450 $ 7.5450 $ 7.5450 $ 8.00 $ 8.00 $ 8.00 p 86 ,,Mu ^; 0m °; 0.1 U $ 322.00 $ 429.00 $ 536.00 $ 322.00 $ 429.00 $ 536.00 .3%/.8% $ 1.00 $ 1.00 $ 1.00 $ 1.00 $ 1.00 $ 1.00 $ 10.33 $ 10.33 $ 10.33 p II. I .PlS p I1 J u °; I }.1.!1' $ 488.00 $ 761.00 $1,034.00 $ 488.00 $ 761.00 $ 1,034.00 .4%/1.0% $ 0.4700 $ 0.4700 $ 0.4700 `> UASMU `> U.IM000 `> U.MIP:SU $ 9.00 $ 9.00 $ 9.00 `> 9. MU `; II U.UU `; I w! u ". 41ralaa d It.il Sch dul II �(as.in annual A% IN atur )I t,.is industrl.�l d.i, i.ibe sh'iIL ""AIbP:n.il R L,9:Sch dul Ml(:�c Lb 'In annual I%N L r)Ir,.is industri.il d.u,i.i be sh'i IL ELECTRIC RATES Monthly Bill by Energy Usage RESIDENTIAL IMPACTS All Energy Current 2023 $ 2024 $ 2025 $ 250 $ 36.53 $ 37.59 $ 38.68 $ 39.50 350 $ 44.35 $ 45.52 $ 47.31 $ 48.84 450 $ 52.23 $ 54.06 $ 55.94 $ 57.88 550 $ 60.09 $ 62.29 $ 64.55 $ 66.92 650 $ 67.94 $ 70.53 $ 73.21 $ 75.96 750 $ 75.79 $ 75.76 $ 81.84 $ 55.00 850 $ 53.64 $ 57.00 $ 90.47 $ 94.04 950 $ 91.49 $ 95.23 $ 99.10 $103.08 1,050 $ 99.35 $103.47 $107.74 $112.12 1,150 $ 107.20 $111.70 $116.37 $121.16 Monthly %Change by Energy Usage All Energy 2023 2024 2025 250 2.9% 2.9% 2.9% 350 3.2% 3.3% 3.2% 450 3.5% 3.5% 3.5% 550 3.7% 3.7% 3.6% 650 3.8% 3.8% 3.8% 750 3.9% 3.9% 3.9% 850 4.0% 4.0% 3.9% 950 4.1% 4.1% 4.0% 1,050 4.1% 4.1% 4.1% 1,150 4.2% 4.2% 4.1% Monthly $ Change by Energy Usage All Energy 2023 2024 2025 250 $ 1.06 $ 1.09 $ 1.12 350 $ 1.44 $ 1.49 $ 1.53 450 $ 1.52 $ 1.59 $ 1.94 550 $ 2.21 $ 2.25 $ 2.34 650 $ 2.59 $ 2.65 $ 2.75 750 $ 2.97 $ 3.05 $ 3.16 850 $ 3.36 $ 3.47 $ 3.57 950 $ 3.74 $ 3.57 $ 3.95 1,050 $ 4.12 $ 4.27 $ 4.35 1,150 $ 4.50 $ 4.67 $ 4.79 ELECTRIC RATES Monthly Bill by Energy Usage SMALL GENERAL IMPACTS Energy Block 1 Block 2 Current 2023 $ 2024 $ 2025 $ 400 400 - $ 57.55 $ 60.57 $ 64.22 $ 67.62 700 700 - $ 54.56 $ 88.59 $ 92.73 $ 96.96 1,000 1,000 - $111.54 $116.32 $121.24 $126.30 1,300 1,300 - $138.52 $144.05 $149.75 $155.64 1,600 1,600 - $165.50 $171.77 $178.26 $184.98 1,900 1,900 - $192.49 $199.50 $ 206.75 $ 214.32 2,200 2,000 200 $ 217.64 $ 225.34 $ 233.35 $ 241.67 2,500 2,000 500 $ 241.87 $ 250.24 $ 258.96 $ 268.02 2,500 2,000 800 $ 266.10 $ 275.14 $ 254.57 $ 294.37 3,100 2,000 1,100 $290.34 $300.04 $310.18 $320.72 Monthly %Change by Energy Usage All Energy 2023 2024 2025 400 5.7% 5.5% 5.3% 700 4.8% 4.7% 4.6% 1,000 4.3% 4.2% 4.2% 1,300 4.0% 4.0% 3.9% 1,600 3.8% 3.8% 3.8% 1,900 3.6% 3.6% 3.6% 2,200 3.5% 3.6% 3.6% 2,500 3.5% 3.5% 3.5% 2,500 3.4% 3.4% 3.4% 3,100 3.3% 3.4% 3.4% Monthly $ Change by Energy Usage All Energy 2023 2024 2025 400 $ 3.29 $ 3.35 $ 3.40 700 $ 4.04 $ 4.13 $ 4.23 1,000 $ 4.75 $ 4.92 $ 5.06 1,300 $ 5.52 $ 5.71 $ 5.59 1,600 $ 6.27 $ 6.49 $ 6.72 1,900 $ 7.01 $ 7.25 $ 7.54 2,200 $ 7.70 $ 8.01 $ 5.32 2,500 $ 5.37 $ 5.72 $ 9.06 2,500 $ 9.04 $ 9.43 $ 9.50 3,100 $ 9.70 $ 10.14 $ 10.55 NATURAL GAS RATES Monthly Bill by Energy Usage NATURAL GAS RATES RESIDENTIAL IMPACTS MCF Usage Current 2023 $ 2024 $ 2025 $ COMMERCIAL IMPACTS 4 $ 45.72 $ 45.90 $ 46.10 $ 46.30 5 $ 53.12 $ 53.20 $ 53.30 $ 53.40 6 $ 60.52 $ 60.50 $ 60.50 $ 60.50 7 $ 67.93 $ 67.50 $ 67.70 $ 67.60 S $ 75.33 $ 75.10 $ 74.90 $ 74.70 9 $ 52.74 $ 52.40 $ 52.10 $ 81.80 10 $ 90.14 $ 59.70 $ 59.30 $ 88.90 11 $ 97.54 $ 97.00 $ 96.50 $ 96.00 Monthly %Change by Energy Usage MCF Usage 2023 2024 2025 4 0.4% 0.4% 0.4% 5 0.2% 0.2% 0.2% 6 0.0% 0.0% 0.0% 7 -0.2% -0.1% -0.1% S -0.3% -0.3% -0.3% 9 -0.4% -0.4% -0.4% 10 -0.5% -0.4% -0.4% 11 -0.6% -0.5% -0.5% Monthly $ Change by Energy Usage MCF Usage 2023 2024 2025 4 $ O.18 $ 0.20 $ 0.20 5 $ 0.05 $ 0.10 $ 0.10 6 $ (0.02) $ - $ - 7 $ (0.13) $ (0.10) $ (0.10) S $ (0.23) $ (0.20) $ (0.20) 9 $ (0.34) $ (0.30) $ (0.30) 10 $ (0.44) $ (0.40) $ (0.40) 11 $ (0.54) $ (0.50) $ (0.50) Monthly Bill by Energy Usage MCF Usage Current 2023 $ 2024 $ 2025 $ 10 $ 144.35 $ 153.64 $ 162.59 $ 172.15 20 $ 224.06 $ 230.57 $ 237.05 $ 243.59 30 $ 303.75 $ 307.51 $ 311.25 $ 315.04 40 $ 353.43 $ 354.45 $ 355.47 $ 356.49 50 $ 463.11 $ 461.39 $ 459.66 $ 457.94 60 $ 542.79 $ 535.32 $ 533.55 $ 529.35 70 $ 622.47 $ 615.26 $ 605.04 $ 600.53 80 $ 702.16 $ 692.20 $ 652.24 $ 672.25 90 $ 781.84 $ 769.13 $ 756.43 $ 743.72 Monthly %Change by Energy Usage MCF Usage 2023 2024 2025 10 6.4% 6.0% 5.7% 20 2.9% 2.8% 2.7% 30 1.2% 1.2% 1.2% 40 0.3% 0.3% 0.3% 50 -0.4% -0.4% -0.4% 60 -0.8% -0.8% -0.8% 70 -1.2% -1.2% -1.2% 80 -1.4% -1.4% -1.5% 90 -1.6% -1.7% -1.7% Monthly $ Change by Energy Usage MCF Usage 2023 2024 2025 10 $ 9.26 $ 9.26 $ 9.26 20 $ 6.51 $ 6.51 $ 6.51 30 $ 3.76 $ 3.77 $ 3.76 40 $ 1.02 $ 1.02 $ 1.02 50 $ (1.73) $ (1.73) $ (1.72) 60 $ (4.47) $ (4.47) $ (4.47) 70 $ (7.22) $ (7.21) $ (7.22) 80 $ (9.96) $ (9.96) $ (9.96) 90 $ (12.71) $ (12.71) $ (12.70) Hutchinson Utilities Commission Electric Rate Design for 2023 Rate Design Summary Projected Projected Projected Projected Revenues Under Revenues Under Revenue Change from Customer Class Current Rates Proposed Rates Change Current Residential $ 5,955,445 $ 6,178,619 $ 223,174 3.7% Small General Service $ 1,839,457 $ 1,906,215 $ 66,758 3.6% Large General Service $ 8,157,524 $ 8,316,216 $ 158,692 1.9% Large Industrial $ 9,338,444 $ 9,520,465 $ 182,021 1.9% TOTALS $ 25,290,870 $ 25,921,515 $ 630,645 2.43% Hutchinson Utilities Commission Electric Rate Design for 2024 Rate Design Summary Projected Projected Projected Projected Revenues Under Revenues Under Revenue Change from Customer Class Current Rates Proposed Rates Change Current Residential $ 6,178,619 $ 6,409,663 $ 231,044 3.7% Small General Service $ 1,906,215 $ 1,975,503 $ 69,288 3.6% Large General Service $ 8,316,216 $ 8,477,571 $ 161,355 1.9% Large Industrial $ 9,520,465 $ 9,705,127 $ 184,662 1.9% TOTALS $ 25,921,515 $ 26,567,864 $ 646,349 2.43% Hutchinson Utilities Commission Electric Rate Design for 2025 Rate Design Summary Projected Projected Projected Projected Revenues Under Revenues Under Revenue Change from Customer Class Current Rates Proposed Rates Change Current Residential $ 6,409,663 $ 6,646,893 $ 237,230 3.7% Small General Service $ 1,975,503 $ 2,047,073 $ 71,570 3.6% Large General Service $ 8,477,571 $ 8,642,476 $ 164,905 1.9% Large Industrial $ 9,705,127 $ 9,893,872 $ 188,745 1.9% TOTALS $ 26,567,864 $ 27,230,314 $ 662,450 2.43% Hutchinson Utilities Commission Natural Gas Rate Design for 2023 Rate Design Summary Projected Projected Projected Projected Revenues Under Revenues Under Revenue Change from Customer Class Current Rates Proposed Rates Change Current Residential $ 4,430,028 $ 4,427,931 $ (2,097) 0.0% Commercial $ 3,238,258 $ 3,238,258 $ - 0.0% Industrial $ 422,436 $ 422,748 $ 312 0.1% Contracted Industrial #1 $ 416,265 $ 417,549 $ 1,284 0.3% Contracted Industrial #2 $ 4,740,652 $ 4,760,308 $ 19,656 0.4% TOTALS $ 13,247,639 $ 13,266,794 $ 19,155 0.14% Hutchinson Utilities Commission Natural Gas Rate Design for 2024 Rate Design Summary Projected Projected Projected Projected Revenues Under Revenues Under Revenue Change from Customer Class Current Rates Proposed Rates Chance Current Residential $ 4,427,931 $ 4,427,403 $ (528) 0.0% Commercial $ 3,238,258 $ 3,238,258 $ - 0.0% Industrial $ 422,748 $ 423,060 $ 312 0.1% Contracted Industrial #1 $ 417,549 $ 418,833 $ 1,284 0.3% Contracted Industrial #2 $ 4,760,308 $ 4,779,964 $ 19,656 0.4% TOTALS $ 13,266,794 $ 13,287,518 $ 20,724 0.16% Hutchinson Utilities Commission Natural Gas Rate Design for 2024 Rate Design Summary Projected Projected Projected Projected Revenues Under Revenues Under Revenue Change from Customer Class Current Rates Proposed Rates Change Current Residential $ 4,427,403 $ 4,426,874 $ (529) 0.0% Commercial $ 3,238,258 $ 3,238,258 $ - 0.0% Industrial $ 423,060 $ 423,372 $ 312 0.1% Contracted Industrial #1 $ 418,833 $ 420,117 $ 1,284 0.3% Contracted Industrial #2 $ 4,779,964 $ 4,799,620 $ 19,656 0.4% TOTALS $ 13,287,518 $ 13,308,241 $ 20,723 0.16%