The URL can be used to link to this page

07-20-2022 HUCCPHUTCHINSON UTILITIES COMMISSION AGENDA REGULAR MEETING July 20, 2022 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. Appendices of Exempt Handbook ii. Appendices of Non -Exempt Handbook b. Approve Changes 7. UNFINISHED BUSINESS 8. NEW BUSINESS a. Re -adopt the Data Practices Act & Public Records Request Policy 9. ADJOURN MINUTES Regular Meeting — Hutchinson Utilities Commission Wednesday, June 22, 2022 Call to order — 3:00 p.m. President Matt Cheney called the meeting to order. Members present: President Matt Cheney; Vice President Anthony Hanson; Commissioner Robert Wendorff; GM Jeremy Carter Absent: Secretary Don Martinez; Attorney Marc Sebora President Matt Cheney noted that an additional new business item 8h Approve Requisition #009212- Removal of Asbestos at Plant 1 will be added to the Agenda. 1. Conflict of Interest 2. Approve Consent Agenda a. Approve Minutes b. Ratify Payment of Bills Motion by Commissioner Wendorff, second by Commissioner Hanson to approve the Consent Agenda. Motion carried unanimously. 3. Approve Financial Statements Mr. Martig presented the Financial Statements. In June invested $5M in short-term CD's ($1 M) and Treasuries($4M). Electric Division did not have a Power Cost Adjustment in May, may start charging in June. Motion by Commissioner Silvernale, second by Commissioner Hanson 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 — Absent ii. Dave Hunstad, Electric Transmission/Distribution Manager — 1. Construction Season 2nd Ave, North Highway 15 2. Routine maintenance at HTI substation iii. Mike Gabrielson, Production Manager — 1. Run season iv. John Webster, Natural Gas Division Director — 1. Performed a preliminary review of 4 sites proposed by Heartland Corn Products for Pipeline Interconnect Station v. Jared Martig, Financial Manager — Nothing to report 1 c. Human Resources — Brenda Ewing- Absent —Angie Radke i. Hired a Welder/Service Person position in the Natural Gas Dept d. Legal — Marc Sebora — Absent e. General Manager — Jeremy Carter i. Reviewed Emergency Load Shed Event 6. Policies a. Review Policies i. Section 6 of Exempt Handbook ii. Section 6 of Non -Exempt Handbook No changes recommended at this time. b. Approve Changes No changes 7. Unfinished Business 8. New Business a. Approve Requisition #9187 — Re -Tubing of Aux Boiler at Plant 2 Mr. Gabrielson presented Approval of Requisition #9187 Re -Tubing of Aux Boiler Plant 2. Staff recommends using Twin Cities Boiler Repair, Inc (TCBR). TCBR guarantees the use of OEM Manufacturer replacement tubes and understands the scope of the work. A motion by Commissioner Wendorff, second by Commissioner Hanson to Approve Requisition #9187 — Re -Tubing of Aux Boiler at Plant 2. Motion carried unanimously b. Approve Requisition #9199 — Replacement Windows at Plant 1 Mr. Gabrielson presented Approval of Requisition #9199 — Replacement Windows at Plant 1. This is phase 2 of the Asbestos Abatement project. Replacement of the windows and frames is a better option of removing, cleaning and re -installing the existing window and frames. The new windows will provide energy efficiency, is an estimated savings of $30K in asbestos abatement removal on existing windows and frames and has a better coordination and timing on the Asbestos Abatement project. A motion by Commissioner Hanson, second by Commissioner Silvernale to Approve Requisition #9199 — Replacement Windows at Plant 1. Motion carried 2 unanimously. c. Approve Requisition #9200 — Soil Corrections of Parking Lot and South Side of Plant 1 Mr. Gabrielson presented Approval of Requisition #9200 - Soil Corrections of Parking Lot and South Side of Plant 1. Looking to remove old fill and replace with crushed granite in the main parking lot, south side of the plant and switch gear buildings. This will help correct the slope to get water away from the building and switch gear buildings and fix basement water issues. A motion by Commissioner Hanson, second by Commissioner Silvernale to Approve Requisition #9200 — Soil Corrections of Parking Lot and South Side of Plant 1. Motion carried unanimously. d. Approve Dynasty Power Tolling Agreement GM Carter presented Approval of Dynasty Power Tolling Agreement. GM Carter recapped conversations from workshop about finalizing another tolling agreement similar to the one entered back in 2015. A motion by Commissioner Wendorff, second by Commissioner Hanson to Approve Dynasty Power Tolling Agreement. Motion carried unanimously. e. Approve Advertisement for Bids - Generator Removal GM Carter presented Approval of Advertisement for Bids — Generator Removal. GM Carter recapped conversations from the April Commission meeting and Board approval of disposing the 3 old generators in Plant 1 (Unit #3, Unit #4, and Unit #8). A motion by Commissioner Silvernale, second by Commissioner Wendorff to Approve Advertisement for Bids — Generator Removal. Motion carried unanimously. f. Approve DER Resolution for Interconnection Process Mr. Hunstad presented Approval of DER Resolution for Interconnection Process. Currently HUC already has a process that was adopted in 2018. Since that time Minnesota Municipal Utilities Association has updated the process. HUC now needs to approve the updated process. This interconnection process document is designed to be customer -centric when explaining the steps and details to interconnect DER systems to the distribution grid. A motion by Commissioner Hanson, second by Commissioner Silvernale to Approve DER Resolution for Interconnection Process. Motion carried unanimously. g. Adopt DER Resolution Tariff 3 Mr. Hunstad presented Adoption of DER Resolution Tariff. This is in relation to item number 8f and needs to updated as well. A motion by Commissioner Wendorff, second by Commissioner Silvernale to Approve Adoption of DER Resolution Tariff. Motion carried unanimously. h. Approve Requisition #9212 - Removal of Asbestos at Plant 1. Mr. Gabrielson presented Requisition #9212 — Removal of Asbestos at Plant 1. This is phase 1 of the Asbestos Abatement project. Asking for Board approval to remove asbestos in the window glazing, wall ring insulation and units 3 & 4 Exhaust insulation at Plant 1. A motion by Commissioner Hanson, second by Commissioner Wendorff to Approve Requisition #9212 - Removal of Asbestos at Plant 1. Motion carried unanimously. 9. Adjourn There being no further business, a motion by Commissioner Silvernale, second by Commissioner Hanson to adjourn the meeting at 3:56p.m. Motion carried unanimously. ATTEST: Matt Cheney, President 12 Don Martinez, Secretary 07/13/2022 02:07 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK Payee DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/18/2022 - 07/13/2022 Description Account Dept Page 1/26 Amount Fund: 1 ELECTRIC 06/20/2022 GEN 1115(E)*4 BP CANANDA ENERGY SOLUTIONS GENERATOR 41 NATURAL GAS 401-547- 01 12,062.23 Generator 41 Aux Boiler 401-547- 01 8.94 GENERATOR 45 NATURAL GAS 401-547- 01 6,654.87 GENERATOR 46 NATURAL GAS 401-547- 01 56, 348.17 Generator 47 Natural Gas 401-547- 01 32,004.04 GENERATOR 49 NATURAL GAS 401-547- 01 8, 054.88 Utility Expenses - Water/Waste 401-930- 08 214.33 HECK GEN 1115(E) TOTAL FOR FUND 1: 115,347.46 06/20/2022 GEN 1127(E) ALERUS HEALTH CARE - LIESTMAN 242-000- 00 48.62 06/20/2022 GEN 1128(E)* RELIANCE STANDARD LIFE -LIFE LTD INSURANCE-80o ELEC 242-000- 00 1, 545.40 LIFE INSURANCE-80o ELEC 242-000- 00 891.98 HECK GEN 1128(E) TOTAL FOR FUND 1: 2,437.38 06/21/2022 GEN 1120(E) MRES Purchased Power 401-555- 02 861,285.72 06/21/2022 GEN 1135(E) MISO Deferred Energy Cost - Miso 174-000- 00 48,059.86 Deferred Energy Cost - Miso 174-000- 00 698.52 HECK GEN 1135(E) TOTAL FOR FUND 1: 48,758.38 06/23/2022 GEN 76667 TWIN CITIES BOILER REPAIR 30o Down Payment for Uni-Lux Boiler 107-344- 00 42,567.00 06/28/2022 GEN 1126(E)* ALERUS HEALTH INSURANCE 401-926- 08 389.06 06/28/2022 GEN 1136(E) MISO Deferred Energy Cost - Miso 174-000- 00 18,146.57 06/28/2022 GEN 1137(E) MISO Deferred Energy Cost - Miso 174-000- 00 666.33 06/30/2022 GEN 76765* A R ENGH HEATHING AND AIR COND, Grounds - Materials 401-935- 08 611.25 Grounds - Materials 401-935- 08 356.25 HECK GEN 76765 TOTAL FOR FUND 1: 967.50 06/30/2022 GEN 76767*4 ACE HARDWARE Sales Tax Receivable - Replace 186-000- 00 1.21 Accessory Plant - Materials 402-554- 01 17.58 07/13/2022 02:07 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee Fund: 1 ELECTRIC CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/18/2022 - 07/13/2022 Description 06/30/2022 GEN 76768* AL MOLINA 06/30/2022 GEN 76769* ANDREW S ROSS 06/30/2022 GEN 76770* ANDREW S ROSS 06/30/2022 GEN 76771 ANIXTER INC 06/30/2022 GEN 76772* ASHLEY NELSON 06/30/2022 GEN 76773* AUSTIN ZWEIBOHMER 06/30/2022 GEN 76775* BERGS PROPERTIES LLC 06/30/2022 GEN 76776 BLAINE WUOLLET 06/30/2022 GEN 76777 BLAINE WUOLLET 06/30/2022 GEN 76778*4 BORDER STATES ELECTRIC SUPPLY Page 2/26 Account Dept Amount Accessory Plant - Materials 402-554- 01 5.34 Accessory Plant - Materials 402-554- 01 11.31 Maintenance Other - Materials 402-554- 01 4.91 Line - Materials 401-581- 02 5.96 Materials 401-588- 02 12.81 Other Equipment - Materials 402-598- 02 5.33 CHECK GEN 76767 TOTAL FOR FUND 1: 64.45 DEP REFUND/APPLIED 235-000- 00 52.00 DEP REFUND/APPLIED 235-000- 00 195.00 DEP REFUND/APPLIED 235-000- 00 39.00 Tray cable. 18 ga/9c. 402-554- 01 83.09 SALES TAX & FREIGHT 402-554- 01 107.27 HECK GEN 76771 TOTAL FOR FUND 1: 190.36 DEP REFUND/APPLIED 235-000- 00 169.00 DEP REFUND/APPLIED 235-000- 00 227.50 DEP REFUND/APPLIED 235-000- 00 796.25 OVERPAYMENTS 142-000- 00 45.68 OVERPAYMENTS 142-000- 00 4.15 POLE, HAPCO PRESIDENTIAL CAST ALUM 154-000- 00 1,030.77 GLOBE, ACORN, WITHOUT CUT-OFF, 154-000- 00 1,821.00 GLOBE, ACORN, WITHOUT CUT-OFF, 154-000- 00 1,821.00 POLE, STANDARD FIBERGLASS BG WITH 154-000- 00 9,913.53 ELL, 1/0, 15KV 1STR-1/OSOL, .70-.91, 154-000- 00 567.00 Sales Tax Receivable - New 186-000- 00 70.87 07/13/2022 02:07 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/18/2022 - 07/13/2022 Description Account Dept Page 3/26 Amount Fund: 1 ELECTRIC Sales Tax Receivable - New 186-000- 00 125.19 Sales Tax Receivable - New 186-000- 00 125.19 Sales Tax Receivable - New 186-000- 00 681.56 Sales Tax Receivable - New 186-000- 00 38.47 Line - Materials 402-594- 02 (864.49) Line - Materials 402-594- 02 (1,371.91) HECK GEN 76778 TOTAL FOR FUND 1: 13,958.18 06/30/2022 GEN 76779* BRENDAN TOMENES DEP REFUND/APPLIED 235-000- 00 45.50 06/30/2022 GEN 76780* CARTER, JEREMY J Training - Expense 401-930- 08 31.01 06/30/2022 GEN 76781 CENTRAL HYDRAULICS Power Equipment - Materials 402-598- 02 7.99 Power Equipment - Materials 402-598- 02 20.17 HECK GEN 76781 TOTAL FOR FUND 1: 28.16 06/30/2022 GEN 76782* CHARLES BERGUM DEP REFUND/APPLIED 235-000- 00 204.75 06/30/2022 GEN 76783*4 CINTAS CORPORATION 4470 Uniforms & Laundry 401-550- 01 571.10 UNIFORMS & LAUNDRY 401-588- 02 288.08 HECK GEN 76783 TOTAL FOR FUND 1: 859.18 06/30/2022 GEN 76784*4 CITY OF HUTCHINSON Generator 41 Water & Sewer 401-547- 01 298.89 Generator 41 Water & Sewer 401-547- 01 241.17 Waste Disposal 401-550- 01 962.66 Waste Disposal 401-550- 01 44.20 Waste Disposal 401-550- 01 527.53 Line - Materials 402-594- 02 8.66 IT ADMIN AND SUPPORT 750 401-921- 08 5, 626.09 Utility Expenses - Water/Waste 401-930- 08 8.62 Utility Expenses - Water/Waste 401-930- 08 499.02 HECK GEN 76784 TOTAL FOR FUND 1: 8,216.84 07/13/2022 02:07 PM CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES User: JMartig CHECK DATE FROM 06/18/2022 - 07/13/2022 DE: Hutchinson Utili Check Date Bank Check # Payee Description Account Dept Fund: 1 ELECTRIC 06/30/2022 GEN 7678514 COUNTY OF MCLEOD Building & Grounds - Materials 402-592- 02 Grounds - Materials 401-935- 08 HECK GEN 76785 TOTAL FOR FUND 1: 06/30/2022 GEN 76786 CREEKSIDE SOILS Underground Conductor 107-367- 00 06/30/2022 GEN 76787 CULLIGAN ULTRAPURE OF NORTHFIELD CAP, 521, LIMIT STOP, P/N 43724 154-000- 00 CAP, 521, LIMIT STOP, P/N 43724 154-000- 00 HECK GEN 76787 TOTAL FOR FUND 1: 06/30/2022 GEN 76788 DARYL THOENNES OR ANGIE THOENNES OVERPAYMENTS 142-000- 00 06/30/2022 GEN 767894 DGR ENGINEERING Plant 41 Relay and RTU Upgrades 107-362- 00 Station Equipment (Switchgear, 107-362- 00 3M Substation Relay and RTU Upgrades 107-362- 00 STATION EQUIPMENT (SWITCHGEAR, 107-362- 00 Electric Distribution System Study 402-592- 02 Electric Distribution Maintenance 402-592- 02 BES Transmission Coordination Study 402-574- 03 Outside Services 402-574- 03 HECK GEN 76789 TOTAL FOR FUND 1: 06/30/2022 GEN 76790* E2 ELECTRICAL SERVICES, INC Grounds - Outside Services 401-935- 08 06/30/2022 GEN 76791 EMBROIDERY PLUS T-SHIRT, NAVY BLUE, SIZE XX-LARGE 401-550- 01 T-SHIRT, NAVY BLUE, SIZE XXX-LARGE 401-550- 01 T-SHIRT, NAVY BLUE, SIZE XXX-LARGE 401-550- 01 T-SHIRT, NAVY BLUE, SIZE XX-LARGE 401-550- 01 T-SHIRT, NAVY BLUE, SIZE LARGE REGULAR, 401-550- 01 HECK GEN 76791 TOTAL FOR FUND 1: 06/30/2022 GEN 76792 EXCELSIOR HOMES INC OVERPAYMENTS 142-000- 00 06/30/2022 GEN 76793 FLOYD KARPINSKE OVERPAYMENTS 142-000- 00 06/30/2022 GEN 767944 FS3 INC INTERDUCT, 4", SDR 13.5 ELK/WITH 3 RED 154-000- 00 Page 4/26 Amount 246.75 9.50 256.25 69.20 303.45 22.96 24,522.00 78.00 4,536.00 64.00 2,300.00 38.00 4,400.00 8,931.38 912.50 329.00 410.00 1,762.50 44.15 80.56 3,210.00 07/13/2022 02:07 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/18/2022 - 07/13/2022 Payee Description Account Dept Page 5/26 Amount Fund: 1 ELECTRIC Sales Tax Receivable - New 186-000- 00 224.82 Materials 401-588- 02 60.16 HECK GEN 76794 TOTAL FOR FUND 1: 3,494.98 06/30/2022 GEN 76796 GREAT RIVER ENERGY TRANSMISSION EXPENSE 401-565- 03 146,754. 91 06/30/2022 GEN 76797* GREGORY CLEMENS GET REFUND/APPLIED 235-000- 00 45.50 06/30/2022 GEN 76799 GROEHLER, FLOYD Cip - Residential 401-916- 07 25.00 06/30/2022 GEN 76800* H FIT 360 GET REFUND/APPLIED 235-000- 00 1,820.00 06/30/2022 GEN 76801* HAGER JEWELRY INC Office Supplies 401-921- 08 10.68 06/30/2022 GEN 76802* HALL, NANCY Cip - Residential 401-916- 07 25.00 06/30/2022 GEN 76803* HANNAH STARKE GET REFUND/APPLIED 235-000- 00 65.00 06/30/2022 GEN 76804 HANSON & EASED CONSTRUCTION, INC Underground Conductor 107-367- 00 1,575.00 06/30/2022 GEN 76805 HEARTLAND AG SYSTEMS Power Equipment - Materials 402-598- 02 30.62 06/30/2022 GEN 76806*4 HILLYARD/HUTCHINSON Supplies 401-550- 01 260.24 Grounds - Materials 401-935- 08 205.40 HECK GEN 76806 TOTAL FOR FUND 1: 465.64 06/30/2022 GEN 76807 HLAVKA, LEROY Cip - Residential 401-916- 07 25.00 06/30/2022 GEN 76808*4 HUTCHINSON WHOLESALE SUPPLY CO Vehicles - Material 402-598- 02 122.90 Power Equipment - Materials 402-598- 02 8.78 Power Equipment - Materials 402-598- 02 51.97 HECK GEN 76808 TOTAL FOR FUND 1: 183.65 06/30/2022 GEN 76809* JACKSON WOLFF GET REFUND/APPLIED 235-000- 00 58.50 07/13/2022 02:07 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/18/2022 - 07/13/2022 Payee Description Account Dept Page 6/26 Amount Fund: 1 ELECTRIC 06/30/2022 GEN 768104 JOHN HENRY FOSTER FILTER, INLET AIR FILTER ELEMENT, QGD, 154-000- 00 177.35 FILTER, INLET AIR FILTER ELEMENT, QGD, 154-000- 00 11.30 OIL, COMPRESSOR, QYN-SYN PLUS, QUINCY 154-000- 00 1,246.28 OIL, COMPRESSOR, QYN-SYN PLUS, QUINCY 154-000- 00 79.43 Sales Tax Receivable - Replace 186-000- 00 104.57 Sales Tax Receivable - Replace 186-000- 00 6.66 Zeks Air Dryer Sercice Quote 4AAAQ17154 402-554- 01 3,495.73 HECK GEN 76810 TOTAL FOR FUND 1: 5,121.32 06/30/2022 GEN 76811* JOHN OR ELAINE SNYDER GET REFUND/APPLIED 235-000- 00 136.50 06/30/2022 GEN 76812 KOPF, THOMAS Cip - Residential 401-916- 07 25.00 06/30/2022 GEN 76813* KRISTI BOTZEK GET REFUND/APPLIED 235-000- 00 130.00 06/30/2022 GEN 76814* LANCE CRUCKSON GET REFUND/APPLIED 235-000- 00 91.00 06/30/2022 GEN 76815* LINDA UBER GET REFUND/APPLIED 235-000- 00 130.00 06/30/2022 GEN 76816*4 LOCATORS & SUPPLIES INC PAINT, LOCATING, INVERTED SURVEY 154-000- 00 683.86 PAINT, LOCATING, INVERTED SURVEY 154-000- 00 93.37 Sales Tax Receivable - New 186-000- 00 53.94 Sales Tax Receivable - New 186-000- 00 7.37 HECK GEN 76816 TOTAL FOR FUND 1: 838.54 06/30/2022 GEN 76817* LUKE NAROG GET REFUND/APPLIED 235-000- 00 48.75 06/30/2022 GEN 76818* MARCO TECHNOLOGIES, LLC OFFICE SUPPLIES 401-921- 08 667.66 06/30/2022 GEN 768194 MECHANICAL SYSTEMS INC PUMP,KNF, 41I SERIES (75-111553-01) 154-000- 00 1,323.60 Sales Tax Receivable - Replace 186-000- 00 92.45 FREIGHT 401-588- 02 21.07 HECK GEN 76819 TOTAL FOR FUND 1: 1,437.12 07/13/2022 02:07 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/18/2022 - 07/13/2022 Payee Description Account Dept Page 7/26 Amount Fund: 1 ELECTRIC 06/30/2022 GEN 76820* MEDICA HEALTH INSURANCE -COBRA 242-000- 00 1,918.15 HEALTH INSURANCE 85% ELEC 242-000- 00 51,916.14 HECK GEN 76820 TOTAL FOR FUND 1: 53,834.29 06/30/2022 GEN 76821* MEGAN RITZIER DEP REFUND/APPLIED 235-000- 00 48.75 06/30/2022 GEN 76822* MICHAEL OR DIANE ROHLING DEP REFUND/APPLIED 235-000- 00 146.25 06/30/2022 GEN 76823* MICHAEL OR JENNIFER BARTLEY DEP REFUND/APPLIED 235-000- 00 299.00 06/30/2022 GEN 76824 MIDWEST OVERHEAD CRANE Oil Filter hoist Inspection 402-554- 01 887.10 06/30/2022 GEN 76825 MIRATECH FILTER ELEMENT, 2U 154-000- 00 510.00 FILTER ELEMENT, 2U 154-000- 00 43.10 HECK GEN 76825 TOTAL FOR FUND 1: 553.10 06/30/2022 GEN 76826 MISSOURI RIVER ENERGY SERVICES Structures & Equipment - Mater 402-592- 02 4,696.55 06/30/2022 GEN 76827 MN MUNICIPAL UTILITIES ASSOCIATION Training - Expense 401-546- 01 975.00 06/30/2022 GEN 76828* NATALIE RANIERI DEP REFUND/APPLIED 235-000- 00 260.00 06/30/2022 GEN 76829* NOAH IVERSON DEP REFUND/APPLIED 235-000- 00 81.25 06/30/2022 GEN 768304 NORTHERN STATES SUPPLY INC WIRE BUFFING WHEEL. 154-000- 00 314.04 WIRE BUFFING WHEEL. 154-000- 00 9.98 DISC, FLAP, 4 1/2" X 7/8", 60 GRIT, 154-000- 00 63.75 DISC, FLAP, 4 1/2" X 7/8", 60 GRIT, 154-000- 00 2.02 Sales Tax Receivable - New 186-000- 00 26.80 Other Equipment - Materials 402-598- 02 39.34 HECK GEN 76830 TOTAL FOR FUND 1: 455.93 06/30/2022 GEN 768314 OXYGEN SERVICE COMPANY INC GLOVES, WELDING, MID 39, XL, DEERSKIN 154-000- 00 48.20 GLOVES, WELDING, MID 39, XL, DEERSKIN 154-000- 00 7.14 07/13/2022 02:07 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/18/2022 - 07/13/2022 Payee Description Account Dept Page 8/26 Amount Fund: 1 ELECTRIC WIRE BUFFING WHEEL. 413131 154-000- 00 143.36 WIRE BUFFING WHEEL. 413131 154-000- 00 21.25 Distribution Inventory 154-000- 00 31.84 Distribution Inventory 154-000- 00 4.72 Sales Tax Receivable - New 186-000- 00 17.82 Sales Tax Receivable - New 186-000- 00 2.64 MATERIALS -NITROGEN 402-574- 03 28.84 HECK GEN 76831 TOTAL FOR FUND 1: 305.81 06/30/2022 GEN 76832* PAIGE ROUSH DEP REFUND/APPLIED 235-000- 00 130.00 06/30/2022 GEN 76833* PAUL OR LAURE JELLISON DEP REFUND/APPLIED 235-000- 00 175.50 06/30/2022 GEN 76834*4 PRO AUTO & TRANSMISSION REPAIR Vehicles - Labor 402-554- 01 20.14 Vehicles - Material 402-598- 02 215.77 HECK GEN 76834 TOTAL FOR FUND 1: 235.91 06/30/2022 GEN 768354 PROCHASKA LLC CHLOR 125 (SANI-CHLOR) 154-000- 00 2,054.06 Sales Tax Receivable - Replace 186-000- 00 154.09 FREIGHT 401-588- 02 187.32 HECK GEN 76835 TOTAL FOR FUND 1: 2,395.47 06/30/2022 GEN 768364 QUADE ELECTRIC Sales Tax Receivable - Replace 186-000- 00 5.89 Sales Tax Receivable - Replace 186-000- 00 34.81 Accessory Plant - Materials 402-554- 01 81.30 Accessory Plant - Materials 402-554- 01 506.40 HECK GEN 76836 TOTAL FOR FUND 1: 628.40 06/30/2022 GEN 76837* RALPH GROSS III DEP REFUND/APPLIED 235-000- 00 195.00 06/30/2022 GEN 76838* RAVEN KOLTES OR MAX SCHEELER DEP REFUND/APPLIED 235-000- 00 48.75 06/30/2022 GEN 76839* RELIANCE STANDARD LIFE -LIFE LTD INSURANCE-80o ELEC 242-000- 00 1,569.30 07/13/2022 02:07 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/18/2022 - 07/13/2022 Payee Description Account Dept Page 9/26 Amount Fund: 1 ELECTRIC LIFE INSURANCE-80o ELEC 242-000- 00 833.38 HECK GEN 76839 TOTAL FOR FUND 1: 2,402.68 06/30/2022 GEN 7684014 RUNNING'S SUPPLY INC Sales Tax Receivable - Replace 186-000- 00 54.31 Accessory Plant - Materials 402-554- 01 690.00 Line - Materials 401-581- 02 237.31 Line - Materials 401-581- 02 4.04 HECK GEN 76840 TOTAL FOR FUND 1: 985.66 06/30/2022 GEN 76841* SAWYER MIES DEP REFUND/APPLIED 235-000- 00 48.75 06/30/2022 GEN 76842 SC SUPPLY COMPANY, LLC CONES, TRAFFIC, 28", ORANGE, BLACK BASE 154-000- 00 512.10 ONES, TRAFFIC, 28", ORANGE, BLACK BASE 154-000- 00 250.00 HECK GEN 76842 TOTAL FOR FUND 1: 762.10 06/30/2022 GEN 76843* SOMERS WILLOCK DEP REFUND/APPLIED 235-000- 00 39.00 06/30/2022 GEN 76844 STATE OF MINNESOTA Regulatory Expenses 401-928- 08 1,752.58 06/30/2022 GEN 76846* SUSAN KROYER DEP REFUND/APPLIED 235-000- 00 208.00 06/30/2022 GEN 76847 T & R ELECTRIC SUPPLY CO INC TRANS, 100 KVA PAD, 1 PHASE, 120/240 154-000- 00 9, 472.00 TRANS, 100 KVA PAD, 1 PHASE, 120/240 154-000- 00 9.51 Sales Tax Receivable - New 186-000- 00 651.85 HECK GEN 76847 TOTAL FOR FUND 1: 10,133.36 06/30/2022 GEN 76848* THEODORE HONDA DEP REFUND/APPLIED 235-000- 00 45.50 06/30/2022 GEN 76849 THOMAS POHLEN OVERPAYMENTS 142-000- 00 67.33 06/30/2022 GEN 76850 TIMOTHY BURNHAM OVERPAYMENTS 142-000- 00 115.12 06/30/2022 GEN 76851* TINA MYLLYKANGAS DEP REFUND/APPLIED 235-000- 00 175.50 07/13/2022 02:07 PM CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES Page 10/26 User: JMartig CHECK DATE FROM 06/18/2022 - 07/13/2022 DE: Hutchinson Utili Check Date Bank Check # Payee Description Account Dept Amount Fund: 1 ELECTRIC 06/30/2022 GEN 76852* TRAVIS COPE DEP REFUND/APPLIED 235-000- 00 52.00 06/30/2022 GEN 76853 TRENCHERS PLUS INC Power Equipment - Materials 402-598- 02 58.58 06/30/2022 GEN 76854 TYLER GREEDER OVERPAYMENTS 142-000- 00 24.15 06/30/2022 GEN 76855* UIS/SOURCECORP COLLECTION - MATERIALS 401-903- 06 1,848.91 COLLECTION - MATERIALS 401-903- 06 1,849.65 HECK GEN 76855 TOTAL FOR FUND 1: 3,698.56 06/30/2022 GEN 768574 WARTSILA OF NORTH AMERICA, INC KIT, REPAIR STARTING VALVE 154-000- 00 2, 504.30 Sales Tax Receivable - New 186-000- 00 26.67 FREIGHT 401-588- 02 162.56 HECK GEN 76857 TOTAL FOR FUND 1: 2,693.53 06/30/2022 GEN 76858* WEBSTER, JOHN Cip - Residential 401-916- 07 225.00 06/30/2022 GEN 76859 WILKE, RICK Cip - Residential 401-916- 07 25.00 06/30/2022 GEN 76860* WYATT ACKERSON DEP REFUND/APPLIED 235-000- 00 65.00 06/30/2022 GEN 76861* ZACHARY GUTHMILLER DEP REFUND/APPLIED 235-000- 00 214.50 07/01/2022 GEN 1143(E)* ARGUS DENTAL DENTAL INSURANCE -COBRA 242-000- 00 507.81 DENTAL INSURANCE-80o ELEC 242-000- 00 3,873.26 HECK GEN 1143(E) TOTAL FOR FUND 1: 4,381.07 07/05/2022 GEN 1130(E)* CITIZENS BANK Office Supplies 401-921- 08 88.81 07/05/2022 GEN 1138(E) MISO Deferred Energy Cost - Miso 174-000- 00 703.63 07/05/2022 GEN 1140(E)* PAY MENTECH collection - Materials 401-903- 06 1,634.67 07/06/2022 GEN 1144(E)*4 ALERUS HEALTH INSURANCE - HAND 401-546- 01 634.22 07/13/2022 02:07 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/18/2022 - 07/13/2022 Payee Description Account Dept Page 11/26 Amount Fund: 1 ELECTRIC HEALTH INSURANCE - MASON 401-556- 03 1,217.01 HECK GEN 1144(E) TOTAL FOR FUND 1: 1,851.23 07/11/2022 GEN 1134(E)* INVOICE CLOUD collection - Materials 401-903- 06 1,563.95 07/12/2022 GEN 1139(E) MISO Deferred Energy Cost - Miso 174-000- 00 693.67 07/12/2022 GEN 1145(E)*4 ALERUS HEALTH INSURANCE - HEITMAN, R 401-546- 01 6, 948.60 HEALTH INSURANCE - CARTER JJ 401-926- 08 534.27 HECK GEN 1145(E) TOTAL FOR FUND 1: 7,482.87 07/13/2022 GEN 76862*4 ACE HARDWARE Sales Tax Receivable - Replace 186-000- 00 0.23 Sales Tax Receivable - Replace 186-000- 00 0.32 Accessory Plant - Materials 402-554- 01 3.40 Accessory Plant - Materials 402-554- 01 4.59 Line - Materials 401-581- 02 42.71 Line - Materials 401-581- 02 38.12 Line - Materials 401-581- 02 17.28 HECK GEN 76862 TOTAL FOR FUND 1: 106.65 07/13/2022 GEN 76863 ANDERSON, DOUGLAS Cip - Residential 401-916- 07 25.00 07/13/2022 GEN 76864 AP+M GASKET, LM6000 (HCU) FILTER, 154-000- 00 55.62 GASKET, LM6000 (HCU) FILTER, 154-000- 00 19.34 HECK GEN 76864 TOTAL FOR FUND 1: 74.96 07/13/2022 GEN 76865 ATLAS COPCO COMPRESSORS LLC Service of Compressor Controller 402-554- 01 1,005.00 07/13/2022 GEN 76867*4 BORDER STATES ELECTRIC SUPPLY INHIBITOR, OXIDE, DE-OX, 8 OR, ILSCO 154-000- 00 69. 96 CONDUCTOR, 14 TW BLACK SOL 154-000- 00 133.00 TAPE, 33+SUPER-1-1/2X36YD 154-000- 00 107.70 Natural Gas Inventory 154-000- 00 (379.94) Sales Tax Receivable - New 186-000- 00 14.27 Sales Tax Receivable - New 186-000- 00 7.40 HECK GEN 76867 TOTAL FOR FUND 1: (47.61) 07/13/2022 02:07 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/18/2022 - 07/13/2022 Payee Description Account Dept Page 12/26 Amount Fund: 1 ELECTRIC 07/13/2022 GEN 76868 BRIANNA GASTERLAND OVERPAYMENTS 142-000- 00 14.41 07/13/2022 GEN 7687114 CINTAS CORPORATION 4470 Uniforms & Laundry 401-550- 01 478.93 Uniforms & Laundry 401-550- 01 478.93 UNIFORMS & LAUNDRY 401-588- 02 288.08 UNIFORMS & LAUNDRY 401-588- 02 288.08 HECK GEN 76871 TOTAL FOR FUND 1: 1,534.02 07/13/2022 GEN 76872*4 CITY OF HUTCHINSON Accounts Payable To City Of Hu 234-000- 00 323,385.75 VEHICLE/EQUIPMENT FUEL -POWER 401-550- 01 256.94 VEHICLES/EQUIPMENT FUEL-ELEC 401-588- 02 3,269. 12 IT ADMIN AND SUPPORT 750 401-921- 08 19, 769. 43 LEGAL SERVICES 75/25 401-923- 08 7,875.00 HUMAN RESOURCES SERVICES 75/25 401-923- 08 6,201.56 VEHICLES/EQUIPMENT FUEL-ADMIN 55/45 401-935- 08 145.90 HECK GEN 76872 TOTAL FOR FUND 1: 360,903.70 07/13/2022 GEN 76873 CREEKSIDE SOILS Materials 401-588- 02 46.30 07/13/2022 GEN 76874 DONALDSON COMPANY INC FILTER, HYDRAULIC, DONALDSON - PART 4 154-000- 00 498. 32 FILTER, HYDRAULIC, DONALDSON - PART 4 154-000- 00 21.86 Sales Tax Receivable - Replace 186-000- 00 35.87 Sales Tax Receivable - Replace 186-000- 00 1.57 HECK GEN 76874 TOTAL FOR FUND 1: 557.62 07/13/2022 GEN 76875 ELISEO SALOMON SANCHEZ OVERPAYMENTS 142-000- 00 161.63 07/13/2022 GEN 76876 ERNESTO ARREDONDO OVERPAYMENTS 142-000- 00 52.70 07/13/2022 GEN 76877* FAHEY, JIM Cip - Residential 401-916- 07 200.00 07/13/2022 GEN 768784 FS3 INC INTERDUCT, 4", SIR 13.5 ELK/WITH 3 RED 154-000- 00 3,210.00 Sales Tax Receivable - New 186-000- 00 220.69 Materials 401-588- 02 201.95 HECK GEN 76878 TOTAL FOR FUND 1: 3,632.64 07/13/2022 02:07 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/18/2022 - 07/13/2022 Description Fund: 1 ELECTRIC 07/13/2022 GEN 76879 GABRIELLE ERICKSON 07/13/2022 GEN 76880 GARY KOEHRING 07/13/2022 GEN 76881 GLENDORIS STOWE 07/13/2022 GEN 76882 GOODIN COMPANY 07/13/2022 GEN 7688314 GOPHER STATE ONE -CALL INC 07/13/2022 GEN 76884 GRANT BANGEN 07/13/2022 GEN 76885* HALL, JOHN 07/13/2022 GEN 76886 HANSEN GRAVEL INC 07/13/2022 GEN 76887 HER ENGINEERING INC OVERPAYMENTS OVERPAYMENTS OVERPAYMENTS STRUCTURES & IMPROVEMENTS (BUI Line - Materials OVERPAYMENTS Cip - Residential Line - Materials Outside Services 07/13/2022 GEN 76888*4 HILLYARD/HUTCHINSON Supplies Grounds - Materials Grounds - Materials HECK GEN 76888 TOTAL FOR FUND 1: 07/13/2022 GEN 76889* HUTCHFIELD SERVICES INC Grounds - Outside Services 07/13/2022 GEN 76890*4 HUTCHINSON CO-OP Supplies Vehicle/Equipment Fuel HECK GEN 76890 TOTAL FOR FUND 1: 07/13/2022 GEN 76891* HUTCHINSON LEADER Cip - Marketing 07/13/2022 GEN 768924 HUTCHINSON WHOLESALE SUPPLY CO Maintenance Other - Materials Power Equipment - Materials HECK GEN 76892 TOTAL FOR FUND 1: 07/13/2022 GEN 76893 IRBY TOOL & SAFETY Line - Materials Account Dept 142-000- 00 142-000- 00 142-000- 00 107-341- 00 401-581- 02 142-000- 00 401-916- 07 401-581- 02 402-554- 01 401-550- 01 401-935- 08 401-935- 08 401-935- 08 401-550- 01 401-550- 01 401-916- 07 402-554- 01 402-598- 02 401-581- 02 Page 13/26 Amount 43.41 47.86 56.96 2,738.83 270.00 57.87 200.00 115.43 1,968.70 110.27 266.55 1,168.37 88.77 330.75 12.11 24.28 07/13/2022 02:07 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/18/2022 - 07/13/2022 Payee Description Account Dept Page 14/26 Amount Fund: 1 ELECTRIC Line - Materials 401-581- 02 139.90 HECK GEN 76893 TOTAL FOR FUND 1: 164.18 07/13/2022 GEN 76894* JENSEN, BRADY ADVERTISING/PRINTING - SCHOLARSHIP 401-921- 08 275.00 07/13/2022 GEN 76896 JOHNSON, DARLENE Cip - Residential 401-916- 07 25.00 07/13/2022 GEN 76897 KAMRATH, JOSHUA Cip - Residential 401-916- 07 72.00 07/13/2022 GEN 76898 KATHERINE KALENBERG OVERPAYMENTS 142-000- 00 36. 90 07/13/2022 GEN 76899 KAUFAMANN, WARREN Cip - Residential 401-916- 07 25.00 07/13/2022 GEN 76901 KEVIN HERMANN OR HEALTH/HUMAN SERV OVERPAYMENTS 142-000- 00 548.57 07/13/2022 GEN 76902 KURITA AMERICA INC TOWER SHIELD, 5173 154-000- 00 4,781.04 TOWER SHIELD, 5173 154-000- 00 101.29 TOWER SHIELD, 5173 154-000- 00 3,187.36 TOWER SHIELD, 5173 154-000- 00 101.55 Sales Tax Receivable - New 186-000- 00 226.61 Sales Tax Receivable - New 186-000- 00 7.22 Sales Tax Receivable - Replace 186-000- 00 335.66 HECK GEN 76902 TOTAL FOR FUND 1: 8,740.73 07/13/2022 GEN 76903 KYLE MONEY OR HARLEY MONEY OVERPAYMENTS 142-000- 00 117.29 07/13/2022 GEN 76904*4 LOCATORS & SUPPLIES INC PAINT, LOCATING, INVERTED SURVEY 154-000- 00 624. 96 PAINT, LOCATING, INVERTED SURVEY 154-000- 00 90.29 Sales Tax Receivable - New 186-000- 00 49.67 Sales Tax Receivable - New 186-000- 00 7.18 HECK GEN 76904 TOTAL FOR FUND 1: 772.10 07/13/2022 GEN 76905 LUBE-TECH & PARTNERS, LLC OIL, MOBIL PEGASUS 1005 154-000- 00 14, 495.16 07/13/2022 GEN 76906 MARISSA BONDERSON OR JEREMY OVERPAYMENTS 142-000- 00 1.01 07/13/2022 GEN 769074 MATHESON TRI-GAS INC Sales Tax Receivable - Replace 186-000- 00 6.91 Sales Tax Receivable - Replace 186-000- 00 23.69 07/13/2022 02:07 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/18/2022 - 07/13/2022 Payee Description Account Dept Page 15/26 Amount Fund: 1 ELECTRIC Generator 41 Material 402-554- 01 100.53 Generator 41 Material 402-554- 01 344.55 HECK GEN 76907 TOTAL FOR FUND 1: 475.68 07/13/2022 GEN 76908 MAURICE VAN HOUTTE OVERPAYMENTS 142-000- 00 525.43 07/13/2022 GEN 76909 MCCULLUM, KATHY Cip - Residential 401-916- 07 25.00 07/13/2022 GEN 769104 MCC ENERGY SOLUTIONS, LLC I AM MANAGEMENT FEES 401-555- 02 3,900.00 IAM USAGE FEES 401-556- 03 3,050.00 CHECK GEN 76910 TOTAL FOR FUND 1: 6,950.00 07/13/2022 GEN 76912* MN MUNICIPAL UTILITIES ASSOCIATION MISC SERVICES-QTR SAFETY/MGMT 750 401-923- 08 4,921.87 07/13/2022 GEN 76915* NUVERA TELEPHONE 401-921- 08 1,953.64 07/13/2022 GEN 76916*4 OXYGEN SERVICE COMPANY INC Maintenance Other - Materials 402-554- 01 83.22 Maintenance Other - Materials 402-554- 01 69.76 HECK GEN 76916 TOTAL FOR FUND 1: 152.98 07/13/2022 GEN 76919 QUADE ELECTRIC Maintenance Other - Materials 402-554- 01 131.22 07/13/2022 GEN 76920* QUADIENT-LEASE LEASE/SERVICE AGREEMENTS 401-921- 08 355. 82 LEASE/SERVICE AGREEMENTS 401-921- 08 654.30 HECK GEN 76920 TOTAL FOR FUND 1: 1,010.12 07/13/2022 GEN 76921* RADKE, ANGIE Training - Expense 401-930- 08 128.50 07/13/2022 GEN 76922*4 RUNNING'S SUPPLY INC Maintenance Other - Materials 402-554- 01 18.87 07/13/2022 GEN 76923 RYAN RAPING OVERPAYMENTS 142-000- 00 577.50 07/13/2022 GEN 76924* SHRED RIGHT OFFICE SUPPLIES -SHREDDING SERVICES 401-921- 08 14.00 07/13/2022 GEN 76926 SOUTHWEST INITIATIVE Cip- Commercial 401-916- 07 878.58 07/13/2022 02:07 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/18/2022 - 07/13/2022 Description Fund: 1 ELECTRIC 07/13/2022 GEN 76927 STANDARD PRINTING & MAILING 07/13/2022 GEN 76929 TWARDY, RONALD 07/13/2022 GEN 76930 TWO-WAY COMMUNICATIONS INC 07/13/2022 GEN 76931* UNITED PARCEL SERVICE 07/13/2022 GEN 76932* VERIZON WIRELESS 07/13/2022 GEN 76933 WAYTEK 07/13/2022 GEN 76934 WESCO RECEIVABLES CORP 07/13/2022 GEN 76935 WILD FLOWER PROPERTIES 07/13/2022 GEN 76936 WILD FLOWER PROPERTIES 07/13/2022 GEN 76937 WILD FLOWER PROPERTIES 07/13/2022 GEN 76938 WILD FLOWER PROPERTIES 07/13/2022 GEN 76940* YRC FREIGHT 07/13/2022 GEN 76941 ZIEMANN, DALLAS Account Dept Page 16/26 Amount Mail Services - Ups, Fedex 401-921- 08 8.40 Cip - Residential 401-916- 07 30.00 Office Supplies 401-921- 08 534.32 MAIL SERVICES - UPS, FEDEX 401-921- 08 132.56 TELEPHONE 401-921- 08 1,898.28 RING TERMINAL. 22-18 AWG. 410, 30703 154-000- 00 15.80 RING TERMINAL. 22-18 AWG. 410, 30703 154-000- 00 16.77 HECK GEN 76933 TOTAL FOR FUND 1: 32.57 ELL, 1/0, T&B 161LR-B5230 15KV 200A 154-000- 00 3,950.00 Sales Tax Receivable - New 186-000- 00 271.56 HECK GEN 76934 TOTAL FOR FUND 1: 4,221.56 OVERPAYMENTS 142-000- 00 445.75 OVERPAYMENTS 142-000- 00 677.96 OVERPAYMENTS 142-000- 00 656.20 OVERPAYMENTS 142-000- 00 448.46 MAIL SERVICES - UPS, FEDEX 401-921- 08 200. 12 Cip - Residential 401-916- 07 30.00 Total for fund 1 ELECTRIC 1,865,335.78 07/13/2022 02:07 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK Payee DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/18/2022 - 07/13/2022 Description Account Dept Page 17/26 Amount Fund: 2 GAS 06/20/2022 GEN 1115(E)*4 BP CANANDA ENERGY SOLUTIONS Mains 107-367- 00 27, 186.63 GAS FOR RETAIL 401-807- 04 ;92,437.24) 3M 401-807- 04 260,892.84 HTI 401-807- 04 12,307.11 UNG 401-807- 04 1,428.48 BROWNTON 401-807- 04 2,746.80 Utility Expenses - Water/Waste 401-930- 08 1,604.80 HECK GEN 1115(E) TOTAL FOR FUND 2: 213,729.42 06/20/2022 GEN 1116(E) PUBLIC ENERGY AUTHORITY OF Gas For Retail 401-807- 04 279,768. 96 Contract Gas For Retail 401-807- 04 62.00 HECK GEN 1116(E) TOTAL FOR FUND 2: 279,830.96 06/20/2022 GEN 1128(E)* RELIANCE STANDARD LIFE -LIFE LTD INSURANCE-20o GAS 242-000- 00 386.36 LIFE INSURANCE-20o GAS 242-000- 00 223.00 HECK GEN 1128(E) TOTAL FOR FUND 2: 609.36 06/28/2022 GEN 1126(E)* ALERUS HEALTH INSURANCE 401-926- 08 129.69 06/30/2022 GEN 76765* A R ENGH HEATHING AND AIR COND, Grounds - Materials 401-935- 08 203.75 Grounds - Materials 401-935- 08 118.75 HECK GEN 76765 TOTAL FOR FUND 2: 322.50 06/30/2022 GEN 76766 AAA GALVANIZING - WINTED Mains 107-367- 00 1,041.04 06/30/2022 GEN 76767*4 ACE HARDWARE VALVE, 1" BALL, FULL PORT, BRASS 154-000- 00 53. 97 Materials 401-874- 04 6.40 Materials 401-874- 04 3.71 Materials 402-892- 04 5.96 Materials 402-892- 04 1.60 Materials 402-892- 04 5.10 Materials 402-892- 04 4.68 HECK GEN 76767 TOTAL FOR FUND 2: 81.42 07/13/2022 02:07 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/18/2022 - 07/13/2022 Description Fund: 2 GAS 06/30/2022 GEN 76768* AL MOLINA 06/30/2022 GEN 76769* ANDREW S ROSS 06/30/2022 GEN 76770* ANDREW S ROSS 06/30/2022 GEN 76772* ASHLEY NELSON 06/30/2022 GEN 76773* AUSTIN ZWEIBOHMER 06/30/2022 GEN 76774 B & C PLUMBING AND HEATING 06/30/2022 GEN 76775* BERGS PROPERTIES LLC 06/30/2022 GEN 76778*4 BORDER STATES ELECTRIC SUPPLY 06/30/2022 GEN 76779* BRENDAN TOMENES 06/30/2022 GEN 76780* CARTER, JEREMY J Account Dept Page 18/26 Amount DEP REFUND/APPLIED 235-000- 00 28.00 DEP REFUND/APPLIED 235-000- 00 105.00 DEP REFUND/APPLIED 235-000- 00 21.00 DEP REFUND/APPLIED 235-000- 00 91.00 DEP REFUND/APPLIED 235-000- 00 122.50 Mains 107-376- 00 2,095.86 DEP REFUND/APPLIED 235-000- 00 428.75 BRACKET, WALL MT RISER, 2", REFER TO 154-000- 00 224.60 RISER, TRANSITION, ANODELESS FLEX, 3/4" 154-000- 00 602.14 FLUID, LEAK DETECTION, TYPE III, 154-000- 00 55.31 TEE, WELD FITTING, STRAIGHT, 2", SMLS, 154-000- 00 68. 02 PLUG, SQ HEAD, MALE THRD, 1", FORGED 154-000- 00 11.30 REDUCER, SWAGE, 2" X 1", STD, BLE X ISE 154-000- 00 74.60 FITTING, WELD STOP 3", LOW PRESSURE 154-000- 00 734. 82 TAX 401-874- 04 15.44 SALES TAX 401-874- 04 41.40 SALES TAX 401-874- 04 3.80 SALES TAX 401-874- 04 11.10 1443097, EKS - 8610005, BARREL LOCK 401-874- 04 345.78 Materials 401-874- 04 0.05 SALES TAX 401-874- 04 50.52 HECK GEN 76778 TOTAL FOR FUND 2: 2,238.88 DEP REFUND/APPLIED 235-000- 00 24.50 Training - Expense 401-930- 08 31.00 07/13/2022 02:07 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/18/2022 - 07/13/2022 Description Fund: 2 GAS 06/30/2022 GEN 76782* CHARLES BERGUM 06/30/2022 GEN 76783*4 CINTAS CORPORATION 4470 06/30/2022 GEN 76784*4 CITY OF HUTCHINSON 06/30/2022 GEN 76785*4 COUNTY OF MCLEOD 06/30/2022 GEN 76790* E2 ELECTRICAL SERVICES, INC 06/30/2022 GEN 76795 GOSSE, JON 06/30/2022 GEN 76797* GREGORY CLEMENS 06/30/2022 GEN 767984 GROEBNER & ASSOCIATES INC 06/30/2022 GEN 76800* H FIT 360 06/30/2022 GEN 76801* HAGER JEWELRY INC Account Dept Page 19/26 Amount DEP REFUND/APPLIED 235-000- 00 110.25 UNIFORMS & LAUNDRY 401-880- 04 170.64 IT ADMIN AND SUPPORT 250 401-921- 08 1,875.37 Utility Expenses - Water/Waste 401-930- 08 7.05 Utility Expenses - Water/Waste 401-930- 08 399.21 HECK GEN 76784 TOTAL FOR FUND 2: 2,281.63 Grounds - Materials 401-935- 08 9.50 Grounds - Outside Services 401-935- 08 5,954.24 Cip - Residential 401-916- 07 25.00 DEP REFUND/APPLIED 235-000- 00 24.50 BARKSDALE TRANSDUCER, 425X-22, 0-60 107-387- 00 2,753.75 BARKSDALE TRANSDUCER, 425X-22, 0-60 107-387- 00 23.92 TEE, TAPPING, ASBLY, 4" X 3/4" IPS MDPE 154-000- 00 3,159.00 Materials 401-874- 04 1,481.04 Materials 401-874- 04 18.96 TAX 401-874- 04 190.96 FREIGHT & TAX 401-874- 04 253.58 Sensus AAT-90-125, AutoAdjust Meter, 416-108- 04 21,251.47 Sensus AAT-90-125, AutoAdjust Meter, 416-108- 04 272.10 HECK GEN 76798 TOTAL FOR FUND 2: 29,404.78 DEP REFUND/APPLIED 235-000- 00 980.00 Office Supplies 401-921- 08 8.74 07/13/2022 02:07 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/18/2022 - 07/13/2022 Payee Description Account Dept Page 20/26 Amount Fund: 2 GAS 06/30/2022 GEN 76802* HALL, NANCY Cip - Residential 401-916- 07 50.00 06/30/2022 GEN 76803* HANNAH STARKE GET REFUND/APPLIED 235-000- 00 35.00 06/30/2022 GEN 76806*4 HILLYARD/HUTCHINSON Grounds - Materials 401-935- 08 205.40 06/30/2022 GEN 76808*4 HUTCHINSON WHOLESALE SUPPLY CO Materials 401-874- 04 58.45 Power Equipment - Materials 402-895- 04 8.78 Power Equipment - Materials 402-895- 04 51.97 Gas Transmission Maintenance 402-863- 05 93.98 HECK GEN 76808 TOTAL FOR FUND 2: 213.18 06/30/2022 GEN 76809* JACKSON WOLFF GET REFUND/APPLIED 235-000- 00 31.50 06/30/2022 GEN 76811* JOHN OR ELAINE SNYDER GET REFUND/APPLIED 235-000- 00 73.50 06/30/2022 GEN 76813* KRISTI BOTZEK GET REFUND/APPLIED 235-000- 00 70.00 06/30/2022 GEN 76814* LANCE CRUCKSON GET REFUND/APPLIED 235-000- 00 49.00 06/30/2022 GEN 76815* LINDA UBER GET REFUND/APPLIED 235-000- 00 70.00 06/30/2022 GEN 76816*4 LOCATORS & SUPPLIES INC RAIN COAT, NASCO, NOMEX 1503JFY, 2XL 401-880- 04 125.00 RAIN PANTS, NASCO, NOMEX 1501TFY, 2XL 401-880- 04 84.00 SAFETY VEST, MLK-FM389Z-2XL 401-880- 04 79. 00 Uniforms & Laundry 401-880- 04 35.40 HECK GEN 76816 TOTAL FOR FUND 2: 323.40 06/30/2022 GEN 76817* LUKE NAROG GET REFUND/APPLIED 235-000- 00 26.25 06/30/2022 GEN 76818* MARCO TECHNOLOGIES, LLC OFFICE SUPPLIES 401-921- 08 222.56 07/13/2022 02:07 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/18/2022 - 07/13/2022 Payee Description Account Dept Page 21/26 Amount Fund: 2 GAS 06/30/2022 GEN 76820* MEDICA HEALTH INSURANCE 15% GAS 242-000- 00 9,161.68 06/30/2022 GEN 76821* MEGAN RITZIER DEP REFUND/APPLIED 235-000- 00 26.25 06/30/2022 GEN 76822* MICHAEL OR DIANE ROHLING DEP REFUND/APPLIED 235-000- 00 78.75 06/30/2022 GEN 76823* MICHAEL OR JENNIFER BARTLEY DEP REFUND/APPLIED 235-000- 00 161.00 06/30/2022 GEN 76828* NATALIE RANIERI DEP REFUND/APPLIED 235-000- 00 140.00 06/30/2022 GEN 76829* NOAH IVERSON DEP REFUND/APPLIED 235-000- 00 43.75 06/30/2022 GEN 76832* PAIGE ROUSH DEP REFUND/APPLIED 235-000- 00 70.00 06/30/2022 GEN 76833* PAUL OR LAURE JELLISON DEP REFUND/APPLIED 235-000- 00 94.50 06/30/2022 GEN 76834*4 PRO AUTO & TRANSMISSION REPAIR Vehicles - Material 402-895- 04 58.30 Vehicles - Material 402-895- 04 47.75 Vehicles - Material 402-895- 04 3,340.85 HECK GEN 76834 TOTAL FOR FUND 2: 3,446.90 06/30/2022 GEN 76837* RALPH GROSS III DEP REFUND/APPLIED 235-000- 00 105.00 06/30/2022 GEN 76838* RAVEN KOLTES OR MAX SCHEELER DEP REFUND/APPLIED 235-000- 00 26.25 06/30/2022 GEN 76839* RELIANCE STANDARD LIFE -LIFE LTD INSURANCE-20o GAS 242-000- 00 392.33 LIFE INSURANCE-20o GAS 242-000- 00 208.35 HECK GEN 76839 TOTAL FOR FUND 2: 600.68 06/30/2022 GEN 76840*4 RUNNING'S SUPPLY INC Materials 401-874- 04 4.04 Power Equipment - Materials 402-895- 04 15.05 HECK GEN 76840 TOTAL FOR FUND 2: 19.09 07/13/2022 02:07 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/18/2022 - 07/13/2022 Description Fund: 2 GAS 06/30/2022 GEN 76841* SAWYER MIES 06/30/2022 GEN 76843* SOMERS WILLOCK 06/30/2022 GEN 76845 STEARNSWOOD 06/30/2022 GEN 76846* SUSAN KROYER 06/30/2022 GEN 76848* THEODORE HONDA 06/30/2022 GEN 76851* TINA MYLLYKANGAS 06/30/2022 GEN 76852* TRAVIS COPE 06/30/2022 GEN 76855* UIS/SOURCECORP 06/30/2022 GEN 76856 VERIZON WIRELESS 06/30/2022 GEN 76858* WEBSTER, JOHN 06/30/2022 GEN 76860* WYATT ACKERSON 06/30/2022 GEN 76861* ZACHARY GUTHMILLER 07/01/2022 GEN 1143(E)* ARGUS DENTAL 07/05/2022 GEN 1130(E)* CITIZENS BANK 07/05/2022 GEN 1140(E)* PAY MENTECH Account Dept Page 22/26 Amount DEP REFUND/APPLIED 235-000- 00 26.25 DEP REFUND/APPLIED 235-000- 00 21.00 Materials 401-874- 04 500.18 DEP REFUND/APPLIED 235-000- 00 112.00 DEP REFUND/APPLIED 235-000- 00 24.50 DEP REFUND/APPLIED 235-000- 00 94.50 DEP REFUND/APPLIED 235-000- 00 28.00 COLLECTION - MATERIALS 401-903- 06 1,512.75 COLLECTION - MATERIALS 401-903- 06 1,513.36 HECK GEN 76855 TOTAL FOR FUND 2: 3,026.11 UTILITIES (ELECTRIC, SATELLITE-SCADA 401-856- 05 161.34 Cip - Residential 401-916- 07 400.00 DEP REFUND/APPLIED 235-000- 00 35.00 DEP REFUND/APPLIED 235-000- 00 115.50 DENTAL INSURANCE-20o GAS 242-000- 00 968. 32 Office Supplies 401-921- 08 88.81 Collection - Materials 401-903- 06 1,337.45 07/13/2022 02:07 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/18/2022 - 07/13/2022 Description Fund: 2 GAS 07/06/2022 GEN 1144(E)*4 ALERUS 07/11/2022 GEN 1134(E)* INVOICE CLOUD 07/12/2022 GEN 1145(E)*4 ALERUS 07/13/2022 GEN 76862*4 ACE HARDWARE 07/13/2022 GEN 76866 B & C PLUMBING AND HEATING 07/13/2022 GEN 76867*4 BORDER STATES ELECTRIC SUPPLY 07/13/2022 GEN 76869 BROWN COUNTY RURAL ELECTRIC 07/13/2022 GEN 76870 CENTURYLINK 07/13/2022 GEN 76871*4 CINTAS CORPORATION 4470 07/13/2022 GEN 76872*4 CITY OF HUTCHINSON Account Dept Page 23/26 Amount HEALTH INSURANCE 401-851- 05 995.73 Collection - Materials 401-903- 06 1,279.59 Health Insurance 401-926- 08 178.09 Materials 401-874- 04 16.22 Materials 401-874- 04 38.11 Materials 401-874- 04 17.29 HECK GEN 76862 TOTAL FOR FUND 2: 71.62 Mains 107-376- 00 1,753.18 FITTING, WELD STOP 3", LOW PRESSURE 154-000- 00 445. 42 ELL, FEMALE THRD, 90 DEG, 3/4", BM, 154-000- 00 21.01 Materials 401-874- 04 30.62 TAX 401-874- 04 1.44 HECK GEN 76867 TOTAL FOR FUND 2: 498.49 Utilities (Electric, Satellite 401-856- 05 195.32 Utilities (Electric, Satellite 401-856- 05 69.38 UNIFORMS & LAUNDRY 401-880- 04 170.64 UNIFORMS & LAUNDRY 401-880- 04 250.68 HECK GEN 76871 TOTAL FOR FUND 2: 421.32 Accounts Payable To City Of Hu 234-000- 00 143,412.25 VEHICLE/EQUIPMENT FUEL -GAS 401-880- 04 3,035.19 IT ADMIN AND SUPPORT 250 401-921- 08 6,589.82 LEGAL SERVICES 75/25 401-923- 08 2,625.00 HUMAN RESOURCES SERVICES 75/25 401-923- 08 2,067.19 VEHICLES/EQUIPMENT FUEL-ADMIN 55/45 401-935- 08 119.39 HECK GEN 76872 TOTAL FOR FUND 2: 157,848.84 07/13/2022 02:07 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/18/2022 - 07/13/2022 Payee Description Account Dept Page 24/26 Amount Fund: 2 GAS 07/13/2022 GEN 76877* FAHEY, JIM Cip - Residential 401-916- 07 300.00 07/13/2022 GEN 76883*4 GOPHER STATE ONE -CALL INC Materials 401-874- 04 270.00 Line - Outside Services 401-856- 05 55.35 HECK GEN 76883 TOTAL FOR FUND 2: 325.35 07/13/2022 GEN 76885* HALL, JOHN Cip - Residential 401-916- 07 350.00 07/13/2022 GEN 76888*4 HILLYARD/HUTCHINSON Grounds - Materials 401-935- 08 266.54 Grounds - Materials 401-935- 08 110.27 HECK GEN 76888 TOTAL FOR FUND 2: 376.81 07/13/2022 GEN 76889* HUTCHFIELD SERVICES INC Grounds - Outside Services 401-935- 08 955.93 07/13/2022 GEN 76890*4 HUTCHINSON CO-OP Vehicle/Equipment Fuel 401-880- 04 104.78 07/13/2022 GEN 76891* HUTCHINSON LEADER Cip - Marketing 401-916- 07 110.25 07/13/2022 GEN 76894* JENSEN, BRADY ADVERTISING/PRINTING - SCHOLARSHIP 401-921- 08 225.00 07/13/2022 GEN 76895 JMS CONCRETE Materials 402-892- 04 800.00 07/13/2022 GEN 769004 KDUZ/KARP PUBLIC AWARENESS - MATERIAL 401-874- 04 76.50 PUBLIC AWARENESS - MATERIAL 401-874- 04 76.50 Public Awareness - Material 401-856- 05 25.50 Public Awareness - Material 401-856- 05 25.50 HECK GEN 76900 TOTAL FOR FUND 2: 204.00 07/13/2022 GEN 76904*4 LOCATORS & SUPPLIES INC Materials 401-874- 04 315.30 07/13/2022 GEN 76911 MCMASTER-CARR SUPPLY COMPANY SS pipe fitting 401-856- 05 65.19 Materials 401-856- 05 0.01 07/13/2022 02:07 PM CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES User: JMartig CHECK DATE FROM 06/18/2022 - 07/13/2022 DE: Hutchinson Utili Check Date Bank Check # Payee Description Account Dept Fund: 2 GAS HECK GEN 76911 TOTAL FOR FUND 2: 07/13/2022 GEN 76912* MN MUNICIPAL UTILITIES ASSOCIATION MISC SERVICES-QTR SAFETY/MGMT 250 401-923- 08 07/13/2022 GEN 76913 NELSON TECHNOLOGIES INC Dresser Model 5 Prover Smart Prove 401-874- 04 Dresser Model 5 Prover IR 401-874- 04 TAX & FREIGHT 401-874- 04 HECK GEN 76913 TOTAL FOR FUND 2: 07/13/2022 GEN 76914 NORTHERN BORDER PIPELINE CO LINE - OUTSIDE SERVICES -INTERCONNECT 401-856- 05 07/13/2022 GEN 76915* NUVERA TELEPHONE 401-921- 08 07/13/2022 GEN 76916*4 OXYGEN SERVICE COMPANY INC Materials 401-874- 04 Materials 401-874- 04 HECK GEN 76916 TOTAL FOR FUND 2: 07/13/2022 GEN 76917 PALMER WAHL INSTRUMENTS INC. IN: 1P5BPIKP59A1, Recorder, 8", Poly 107-367- 00 IN: P 0-3000-8, REC Chart, 8", 0-3000 107-367- 00 HECK GEN 76917 TOTAL FOR FUND 2: 07/13/2022 GEN 76918 PRO AUTO & TRANSMISSION REPAIR Vehicles - Material 402-895- 04 07/13/2022 GEN 76920* QUADIENT-LEASE LEASE/SERVICE AGREEMENTS 401-921- 08 LEASE/SERVICE AGREEMENTS 401-921- 08 HECK GEN 76920 TOTAL FOR FUND 2: 07/13/2022 GEN 76921* RADKE, ANGIE Training - Expense 401-930- 08 07/13/2022 GEN 76922*4 RUNNING'S SUPPLY INC Mains 107-376- 00 07/13/2022 GEN 76924* SHRED RIGHT OFFICE SUPPLIES -SHREDDING SERVICES 401-921- 08 Page 25/26 Amount 65.20 1,640.63 1,284.00 255.00 129.68 1,668.68 2,000.00 651.22 83.23 1,297.07 3,241.92 118.60 105.13 323.59 4.67 07/13/2022 02:07 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/18/2022 - 07/13/2022 Description Fund: 2 GAS 07/13/2022 GEN 76925 SOUTH CENTRAL ELECTRIC ASS'N 07/13/2022 GEN 76928 TDW US INC. 07/13/2022 GEN 76931* UNITED PARCEL SERVICE 07/13/2022 GEN 76932* VERIZON WIRELESS 07/13/2022 GEN 76939 WSB UTILITIES (ELECTRIC, SATELLITE In -Line Inspection of 12" Lateral HT .04, Hot Tap 4 Inch TRV.MOB.DEMOB, TDW MOB AND DEMOB TRV.EQUIP.MOB, MOBILIZATION FOR HECK GEN 76928 TOTAL FOR FUND 2: MAIL SERVICES - UPS, FEDEX TELEPHONE Project Management, Meetings & Engineering Review of ILI Data Line - Outside Services HECK GEN 76939 TOTAL FOR FUND 2: Account Dept 401-856- 05 107-367- 00 107-367- 00 107-367- 00 107-367- 00 401-921- 08 401-921- 08 401-856- 05 401-856- 05 402-863- 05 07/13/2022 GEN 76940* YRC FREIGHT MAIL SERVICES - UPS, FEDEX 401-921- 08 Total for fund 2 GAS TOTAL - ALL FUNDS '*'-INDICATES CHECK DISTRIBUTED TO MORE THAN ONE FUND '#'-INDICATES CHECK DISTRIBUTED TO MORE THAN ONE DEPARTMENT Page 26/26 Amount 33.00 45,929.53 2,706.00 5,340.00 9,380.00 63,355.53 44.19 632.76 1,642.20 2,418.60 66.71 809,495.72 2,674,831.50 HUTCHINSON UTILITIES COMMISSION COMBINED DIVISIONS FINANCIAL REPORT FOR JUNE, 2022 2022 2021 2 . Combined Division Customer Revenue $ 2,914,786 $ 2,759,340 $ 155,447 Sales for Resale $ 411,513 $ 591,916 $ (180,403) NU Transportation $ 86,247 $ 83,322 $ 2,925 Electric Division Transfer $ 59,724 $ 56,879 $ 2,844 Other Revenues $ 140,993 $ 21,954 $ 119,039 Interest Income $ 49,552 $ 32,699 $ 16,853 TOTAL REVENUES $ 3,662,816 $ 3,546,110 $ 116,706 Salaries & Benefits $ 555,696 $ 549,668 $ 6,028 Purchased Commodities $ 1,636,904 $ 1,530,911 $ 105,992 Transmission $ 290,630 $ 326,583 $ (35,953) Generator Fuel/Chem. $ 225,990 $ 365,729 $ (139,738) Depreciation $ 377,109 $ 368,746 $ 8,363 Transfers (Elect./City) $ 215,323 $ 212,479 $ 2,844 Operating Expense $ 175,764 $ 191,266 $ (15,502) Debt Interest $ 75,076 $ 83,542 $ (8,467) TOTAL EXPENSES $ 3,552,491 $ 3,628,923 $ (76,432) NET PROFIT/(LOSS) $ 110,325 $ (82,813) $ 193,138 %Chnq 1 2022 2021 2 %Chnq I Full YrBud %of Bud 5.6% $ 19,717,698 $ 20,584,325 $ (866,626) (4.2%) $ 37,355,080 52.8% (30.5%) $ 1,834,663 $ 2,037,248 $ (202,585) (9.9%) $ 3,692,000 49.7% 3.5% $ 522,737 $ 502,981 $ 19,756 3.9% $ 1,010,124 51.7% 5.0% $ 358,341 $ 341,275 $ 17,066 5.0% $ 716,383 50.0% 542.2% $ 346,997 $ 216,538 $ 130,459 60.2% $ 479,700 72.3% 51.5% $ 205,133 $ 205,927 $ (794) (0.4%) $ 383,456 53.5% 3.3% $ 22,985,570 $ 23,888,293 $ (902,723) (3.8%) $ 43,636,743 52.7% 1.10% $ 3,432,386 $ 3,308,379 $ 124,007 3.7% $ 7,270,807 47.2% 6.9% $ 11,488,413 $ 13,537,818 $ (2,049,406) (15.1%) $ 19,927,587 57.7% (11.0%) $ 1,264,692 $ 1,432,303 $ (167,611) (11.7%) $ 3,325,000 38.0% (38.2%) $ 750,309 $ 638,259 $ 112,050 17.6% $ 1,219,698 61.5% 2.3% $ 2,269,827 $ 2,207,190 $ 62,637 2.8% $ 4,400,000 51.6% 1.3% $ 1,291,938 $ 1,274,871 $ 17,067 1.3% $ 2,583,875 50.0% (8.1%) $ 1,510,978 $ 1,165,842 $ 345,136 29.6% $ 3,367,066 44.9% (10.1%) $ 450,453 $ 501,253 $ (50,800) 10.1% $ 900,907 50.0% (2.1%) $ 22,458,996 $ 24,065,917 $ (1,606,921) (6.7%) $ 42,994,940 52.2% (233.2%) $ 526,574 $ (177,624) $ 704,198 (396.5%) $ 641,803 82.0% June June YTD YTD 2022 HUC 2022 2021 Change 2022 2021 Change Budget Target Gross Margin %: 28.5% 26.1% 2.4% 30.2% 25.0% 5.3% 32.6% Operating Income Per Revenue $ (%): 0.3% -1.5% 1.8% 2.3% -0.4% 2.7% 2.2% N Net Income Per Revenue $ (%): 3.0% -2.3% 5.3% 2.3% -0.7% 3.0% 1.5% N Notes/Graphs: HUTCHINSON UTILITIES COMMISSION ELECTRIC DIVISION FINANCIAL REPORT FOR JUNE, 2022 2022 2021 Di . %Chna 2022 2021 Di %Chna Full YrBud %of Bud Electric Division Customer Revenue $ 2,307,919 $ 2,305,472 $ 2,447 0.1% $ 11,852,217 $ 12,119,878 $ (267,661) (2.2%) $ 25,325,244 46.8% Sales for Resale $ 411,513 $ 591,916 $ (180,403) (30.5%) $ 1,834,663 $ 2,037,248 $ (202,585) (9.9%) $ 3,692,000 49.7% Other Revenues $ 109,371 $ 2,238 $ 107,133 4,786.3% $ 179,032 $ 81,309 $ 97,724 120.2% $ 188,599 94.9% Interest Income $ 26,170 $ 17,743 $ 8,427 47.5% $ 110,931 $ 111,257 $ (326) (0.3%) $ 208,456 53.2% TOTAL REVENUES $ 2,854,973 $ 2,917,370 $ (62,397) (2.10 $ 13,976,843 $ 14,349,691 $ (372,848) (2.6%) $ 29,414,299 47.5% Salaries & Benefits $ 425,240 $ 410,856 $ 14,384 3.5% $ 2,599,364 $ 2,459,251 $ 140,113 5.7% $ 5,319,511 48.9% Purchased Power $ 1,230,695 $ 1,299,366 $ (68,671) (5.3%) $ 6,207,930 $ 6,631,712 $ (423,782) (6.4%) $ 12,297,526 50.5% Transmission $ 290,630 $ 326,583 $ (35,953) (11.0%) $ 1,264,692 $ 1,432,303 $ (167,611) (11.7%) $ 3,325,000 38.0% Generator Fuel/Chem. $ 225,990 $ 365,729 $ (139,738) (38.2%) $ 750,309 $ 638,259 $ 112,050 17.6% $ 1,219,698 61.5% Depreciation $ 285,780 $ 276,785 $ 8,995 3.2% $ 1,721,852 $ 1,658,790 $ 63,062 3.8% $ 3,300,000 52.2% Transfers (Elect./City) $ 167,519 $ 164,674 $ 2,844 1.7% $ 1,005,113 $ 988,046 $ 17,066 1.7% $ 2,010,226 50.0% Operating Expense $ 114,974 $ 138,716 $ (23,741) (17.1%) $ 1,040,090 $ 794,077 $ 246,013 31.0% $ 1,928,042 53.9% Debt Interest $ 40,071 $ 43,321 $ (3,250) (7.5%) $ 240,428 $ 259,928 $ (19,500) JL $ 480,857 50.0% TOTAL EXPENSES $ 2,780,901 $ 3,026,030 $ (245,129) (8.1%) $ 14,829,779 $ 14,862,367 $ (32,588) (0.2%) $ 29,880,860 49.6% NET PROFIT/(LOSS) $ 74,072 $ (108,660) $ 182,732 (168.2%) $ (852,936) $ (512,676) $ (340,260) 66.4% $ (466,561) 182.8% 2022 2021 Di . %Chna 2022 2021 Di %Chna Full YrBud %of Bud Electric Division Residential 5,289,518 6,048,035 (758,517) (12.54%) 25,714,884 25,683,985 30,899 0.12% 54,152,764 47.5% All Electric 149,753 180,617 (30,864) (17.09%) 1,566,948 1,405,133 161,815 11.52% 2,641,117 59.3% Small General 1,596,890 1,767,132 (170,242) (9.63%) 8,974,701 8,915,624 59,077 0.66% 18,688,349 48.0% Large General 7,691,150 7,763,500 (72,350) (0.93%) 41,538,160 41,169,260 368,900 0.90% 83,253,310 49.9% Industrial 10,773,000 11,045,000 (272,000) (2.46%) 56,678,000 58,399,000 (1,721,000) (2.95%) 122,088,679 46.4% Total KWH Sold 25,500,311 26,804,284 (1,303,973) (4.86%) 134,472,693 135,573,002 (1,100,309) (0.81%)l 280,824,218 47.9% June June YTD YTD 2022 HUC 2022 2021 Change 2022 2021 Change Budget Target Gross Margin %: 23.8% 19.5% 4.3% 25.0% 25.2% -0.2% 29.2% Operating Income Per Revenue $ (%): -0.3% -2.9% 2.5% -6.1% -3.1% -3.0% -0.7% Net Income Per Revenue $ (%): 2.6% -3.7% 6.3% -6.1% -3.6% -2.5% -1.6% Customer Revenue per KWH: $0.0905 $0.0860 $0.0045 $0.0881 $0.0894 -$0.0013 $0.0902 $0.0902 Total Power Supply Exp. per KWH: $0.0816 $0.0870 -$0.0054 $0.0767 $0.0781 -$0.0014 $0.0736 $0.0736 Net Income increased by $182,732 over June 2021. The primary reason for this increase was an additional $107,133 in Other Revenues from the sale of surplus property. Purchased power and generator fuels were also way down with the decreased usage and market sales. Sales for Resale of $411,513 consisted of $167,263 in market sales, $98,000 in capacity sales to Rice Lake and $146,250 in capacity sales to AEP. June 2021 Sales for Resale of $591,916 included $347,666 in market sales, $146,250 in capacity sales to AEP, and $98,000 in capacity sales to Rice Lake. June 2020 Sales for Resale of $265,551 consisted of $21,301 in market sales, $146,250 in capacity sales to AEP, and $98,000 in capacity sales to Rice Lake. Overall Purchased Power decreased by $68,671. MRES purchases decreased by $48,913 and market purchases/MISO costs decreased by $19,758. Power Cost Adjustment for June 2022 was $.00422 bringing in an additional $107,536 for the month and $243,139 YTD. There was also no power cost adjustment for June 2021 with the total amount collected through May at $674,248. HUTCHINSON UTILITIES COMMISSION GAS DIVISION FINANCIAL REPORT FOR JUNE, 2022 2022 2021 Di . Gas Division Customer Revenue $ 606,867 $ 453,867 $ 153,000 Transportation $ 86,247 $ 83,322 $ 2,925 Electric Div. Transfer $ 59,724 $ 56,879 $ 2,844 Other Revenues $ 31,622 $ 19,716 $ 11,906 Interest Income $ 23,382 $ 14,955 $ 8,427 TOTAL REVENUES $ 807,843 $ 628,740 $ 179,103 Salaries & Benefits $ 130,455 $ 138,812 $ (8,357) Purchased Gas $ 406,208 $ 231,545 $ 174,663 Operating Expense $ 60,789 $ 52,550 $ 8,239 Depreciation $ 91,329 $ 91,961 $ (632) Transfers (City) $ 47,804 $ 47,804 $ Debt Interest $ 35,004 $ 40,221 $ (5,217) TOTAL EXPENSES $ 771,590 $ 602,893 $ 168,697 NET PROFIT/(LOSS) $ 36,253 $ 25,847 $ 10,406 % Chna 1 2022 2021 Di . 33.7% $ 7,865,482 $ 8,464,447 $ (598,965) 3.5% $ 522,737 $ 502,981 $ 19,756 5.0% $ 358,341 $ 341,275 $ 17,066 60.4% $ 167,965 $ 135,229 $ 32,735 56.3% $ 94,202 $ 94,670 $ (468) 28.5% $ 9,008,727 $ 9,538,602 $ (529,875) (6.0%) $ 833,022 $ 849,128 $ (16,106) 75.4% $ 5,280,483 $ 6,906,107 $ (1,625,624) 15.7% $ 470,888 $ 371,765 $ 99,122 (0.7%) $ 547,975 $ 548,400 $ (425) 0.0% $ 286,825 $ 286,824 $ 0 0.0% $ 210,025 $ 241,325 $ (31,300) 28.0% $ 7,629,217 $ 9,203,550 $ (1,574,333) 40.3%1 $ 1,379,510 $ 335,052 $ 1,044,458 % Chna I Full Yr Bud % of Bud (7.1%) l $ 12,029,836 65.4% 3.9% $ 1,010,124 51.7% 5.0% $ 716,383 50.0% 24.2% $ 291,101 57.7% (0.5%) $ 175,000 53.8% (5.6%) $ 14,222,444 63.3% (1.9%) $ 1,951,296 42.7% (23.5%) $ 7,630,061 69.2% 26.7% $ 1,439,024 32.7% (0.1%) $ 1,100,000 49.8% 0.0% $ 573,649 50.0% 13.0% $ 420,050 50.0% (17.1%) $ 13,114,080 58.2% 311.7% $ 1,108,364 124.5% 2022 Gas Division Residential 6,916,001 Commercial 8,653,457 Industrial 52,780,081 2021 6,524,004 7,500,172 51,605,073 Di 391,997 1,153,285 1,175,008 %Chna 6.01% 15.38% 2.28% 2022 296,782,802 221,471,923 501,258,324 2021 241,019,843 181,779,784 456,265,277 Di 55,762,959 39,692,139 44,993,047 %Chna 23.14% 21.84% 9.86% Full YrBud 439,919,000 347,946,000 873,587,000 %of Bud 67.5% 63.7% 57.4% Total CF Sold 68,349,539 65,629,249 2,720,290 4.14% 1,019,513,049 879,064,904 140,448,145 15.98% 1,661,452,000 61.4% June June YTD YTD 2022 HUC 2022 2021 Change 2022 2021 Change Budget Target Gross Margin %: 45.3% 58.2% -12.9% 38.4% 24.6% 13.8% 39.9% Operating Income Per Revenue $ (%): 2.7% 5.3% -2.6% 15.4% 3.7% 11.7% 8.2% Net Income Per Revenue $ (%): 4.5% 4.1% 0.4% 15.3% 3.5% 11.8% 7.8% Contracted Customer Rev. per CF: $0.0067 $0.0041 $0.0027 $0.0062 $0.0073 -$0.0011 $0.0056 Customer Revenue per CF: $0.0141 $0.0157 -$0.0015 $0.0090 $0.0119 -$0.0029 $0.0088 III Total Power Supply Exp. per CF: $0.0061 $0.0038 $0.0023 $0.0053 $0.0080 ($0.0027) $0.0050 $0.0050 June 2022 net income increased by $10,406. Usage and customer revenue were up but were mostly offset by increased purchased gas. There was no fuel cost adjustment for June 2022 and also zero YTD. June 2021 fuel cost adjustment was $14,608 for the month and $1,083,635 YTD. 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 Total Assets HUTCHINSON UTILITIES COMMISSION BALANCE SHEET - CONSOLIDATED JUNE 30, 2022 Electric Gas Total Division Division 2022 Total Net Change 2021 Total (YTD) 5,823,577.81 11,631,253.06 17,454,830.87 17,586,302.27 (131,471.40) 680.00 170.00 850.00 850.00 - 2,750,000.00 700,000.00 3,450,000.00 3,450,000.00 - 1,293,543.00 573,649.00 1,867,192.00 1,867,192.00 - 395,204.99 - 395,204.99 364,336.05 30,868.94 - 572,128.17 572,128.17 373,639.52 198,488.65 800,000.00 200,000.00 1,000,000.00 1,000,000.00 - 1,148,404.60 - 1,148,404.60 1,389,999.52 (241,594.92) - 1,044,170.82 1,044,170.82 1,194,462.50 (150,291.68) 522,335.64 2,188,694.02 2,711,029.66 2,711,029.66 - 12,733,746.04 16,910,065.07 29,643,811.11 29,937,811.52 (294,000.41) 2,511,794.46 794,952.39 3,306,746.85 3,255,865.00 50,881.85 47,207.51 47,207.50 94,415.01 97,985.30 (3,570.29) 2,559,001.97 842,159.89 3,401,161.86 3,353,850.30 47,311.56 1,742,407.38 519,959.56 2,262,366.94 2,049,593.10 212,773.84 301,453.84 95,399.93 396,853.77 467,717.81 (70,864.04) 169,467.00 - 169,467.00 115,374.85 54,092.15 1,630,746.00 - 1,630,746.00 313,166.00 1,317,580.00 - 543,582.00 543,582.00 104,390.00 439,192.00 3,844,074.22 1,158,941.49 5,003,015.71 3,050,241.76 1,952,773.95 19,136,822.23 18,911,166.45 38,047,988.68 36,341,903.58 1,706,085.10 690,368.40 3,899,918.60 4,590,287.00 4,590,287.00 - 111,116,759.95 42,656,015.41 153,772,775.36 150,778,693.58 2,994,081.78 (65,408,705.42) (19,720,102.57) (85,128,807.99) (80,970,687.02) (4,158,120.97) 500,450.76 212,310.76 712,761.52 1,845,525.95 (1,132,764.43) 46,898,873.69 27,048,142.20 73,947,015.89 76,243,819.51 (2,296,803.62) 66,035,695.92 45,959,308.65 111,995,004.57 112,585,723.09 (590,718.52) HUTCHINSON UTILITIES COMMISSION BALANCE SHEET - CONSOLIDATED JUNE 30, 2022 Electric Gas Total Total Net Change Division Division 2022 2021 Total (YTD) Current Liabilities Current Portion of Long-term Debt Bonds Payable 700,000.00 1,730,000.00 2,430,000.00 2,240,000.00 190,000.00 Bond Premium - 185,608.32 185,608.32 185,608.32 - Accounts Payable 2,094,593.17 579,891.29 2,674,484.46 3,650,542.23 (976,057.77) Accrued Expenses Accrued Interest 40,071.36 35,004.17 75,075.53 88,542.01 (13,466.48) Accrued Payroll 100,047.87 33,655.76 133,703.63 137,741.30 (4,037.67) Total Current Liabilities 2,934,712.40 2,564,159.54 5,498,871.94 6,302,433.86 (803,561.92) Long -Term Liabilities Noncurrent Portion of Long-term Debt 2017 Bonds 14,030,000.00 - 14,030,000.00 14,730,000.00 (700,000.00) 2012 Bonds - 7,780,000.00 7,780,000.00 9,510,000.00 (1,730,000.00) Bond Premium 2012 515,794.80 634,161.39 1,149,956.19 1,369,021.47 (219,065.28) Pension Liability- Electric 2,219,565.00 - 2,219,565.00 3,026,207.00 (806,642.00) Pension Liability - Electric OPEB 94,162.00 - 94,162.00 84,054.00 10,108.00 Pension Liability- Nat Gas - 739,855.00 739,855.00 1,008,736.00 (268,881.00) Pension Liability - Nat Gas OPEB - 31,387.00 31,387.00 28,018.00 3,369.00 Accrued Vacation Payable 431,660.51 163,481.47 595,141.98 584,864.37 10,277.61 Accrued Severance 91,639.00 31,615.85 123,254.85 124,387.07 (1,132.22) Deferred Outflows - Electric 2,041,393.00 - 2,041,393.00 123,417.00 1,917,976.00 Deferred Outflows - Nat Gas - 680,464.00 680,464.00 41,139.00 639,325.00 Total Long -Term Liabilities 19,424,214.31 10,060,964.71 29,485,179.02 30,629,843.91 (1,144,664.89) Net Position Retained Earnings 43,676,769.21 33,334,184.40 77,010,953.61 75,653,445.32 1,357,508.29 Total Net Position 43,676,769.21 33,334,184.40 77,010,953.61 75,653,445.32 1,357,508.29 Total Liabilities and Net Position 66,035,695.92 45,959,308.65 111,995,004.57 112,585,723.09 (590,718.52) Hutchinson Utilities Commission Cash -Designations Report, Combined June 30, 2022 Change in Financial Annual Balance, Balance, Cash/Reserve Institution Current Interest Rate Interest June 2022 May 2022 Position Savings, Checking, Investments varies Total Operating Funds Debt Reserve Requirements Debt Reserve Requirements Total Restricted Funds Operating Reserve Rate Stabalization Funds PILOT Funds Catastrophic Funds Capital Reserves Total Designated Funds varies varies 29,643,811.11 29,624,811.81 18,999.30 Bond Covenants - sinking fund Bond Covenants -1 year Max. P & I Min 60 days of 2022 Operating Bud. Charter (Formula Only) Risk Mitigation Amount 5 Year CIP (2022-2026 Fleet & Infrastructure Maintenance) 29,643,811.11 29,624,811.81 18,999.30 2,192,575.42 1,914,999.89 277,575.53 2,711,029.66 2,711,029.66 - 4,903,605.08 4,626,029.55 277,575.53 6,432,490.00 6,432,490.00 967,333.16 991,451.43 (24,118.27) 1,867,192.00 1,867,192.00 1, 000, 000.00 1, 000, 000.00 3,450,000.00 3,450,000.00 13,717,015.16 13,741,133.43 (24,118.27) YE YE YE YE YTD HUC 2018 2019 2020 2021 2022 Target Debt to Asset 37.7% 34.9% 32.3% 30.8% 31.2% Current Ratio 3.93 5.11 5.67 5.22 5.63 RONA 3.16% 2.25% 3.62% 0.41% 0.53% Change in Cash Balance (From 12131114 to 613012022) Month End Electric Elec. Change Natural Gas Gas Change Total Total Change 6/30/2022 12,733,746 16,910,065 29,643,811 12/31/2021 12,870,253 (136,507) 15,086,000 1,824,065 27,956,253 1,687,558 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, 2022 Change in Financial Annual Balance, Balance, Cash/Reserve Institution Current Interest Rate Interest June 2022 May 2022 Position Savings, Checking, Investments varies varies varies 29,643,811.11 29,624,811.81 18,999.30 Total HUC Operating Funds 29,643,811.11 29,624,811.81 18,999.30 Debt Restricted Requirements Debt Restricted Requirements Total Restricted Funds Bond Covenants - sinking fund Bond Covenants -1 year Max. P & 1 1,148,404.60 522,335.64 1,670,740.24 1,049,999.91 522,335.64 1,572,335.55 98,404.69 - 98,404.69 Excess Reserves Less Restrictions, Electric 11,063,005.80 :0 Operating Reserve Min 60 days of 2022 Operating Bud. 4,430,143.33 4,430,143.33 Rate Stabalization Funds $400K-$1.2K 395,204.99 395,204.99 PILOT Funds Charter (Formula Only) 1,293,543.00 1,293,543.00 Catastrophic Funds Risk Mitigation Amount 800,000.00 800,000.00 Capital Reserves 5 Year CIP (2022-2026 Fleet & Infrastructure Maintenance) 2,750,000.00 2,750,000.00 Total Designated Funds 9,668,891.32 9,668,891.32 Excess Reserves Less Restrictions & Designations, Electric 1,394,114.48 :0 YE YE YE YE YTD APPA Ratio HUC 2018 2019 2020 2021 2022 5K-10K Cust. Target Debt to Asset Ratio (* w/Gen.) 35.7% 34.1% 32.6% 32.2% 33.9% 39.8% ONE Current Ratio 3.63 5.26 6.18 5.70 5.40 3.75 RONA -0.3% -0.4% 2.5% -1.2% -1.4% NA >0% Hutchinson Utilities Commission Cash -Designations Report, Gas June 30, 2022 Change in Financial Annual Balance, Balance, Cash/Reserve Institution Current Interest Rate Interest June 2022 May 2022 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 varies 29,643,811.11 29,624,811.81 18,999.30 1,044,170.82 864,999.98 179,170.84 2,188,694.02 2,188,694.02 - 3,232,864.84 3,053,694.00 179,170.84 Operating Reserve Min 60 days of 2022 Operating Bud. 2,002,346.67 2,002,346.67 Rate Stabalization Funds $200K-$600K 572,128.17 596,246.44 (24,118.27) PILOT Funds Charter (Formula Only) 573,649.00 573,649.00 Catastrophic Funds Risk Mitigation Amount 200,000.00 200,000.00 Capital Reserves 5 Year CIP ( 2022-2026 Fleet & Infrastructure Maintenance) 700,000.00 700,000.00 Total Designated Funds 4,048,123.84 4,072,242.11 (24,118.27) YE YE YE YE YTD HUC 2018 2019 2020 2021 2022 AGA Ratio Target Debt to Asset 40.7% 36.1% 32.0% 28.8% 27.5% 35%-50% Current Ratio 4.33 4.96 5.18 4.79 5.90 1.0-3.0 RONA 8.3% 6.4% 5.3% 2.9% 3.5% 2%-5% HUTCHINSON UTILITIES COMMISSION Investment Report For the Month Ended June 30, 2022 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 0.240% 0.240% NA NA - 30,283.66 - - - N/A Wells Fargo US Treasury Note 1.625% 1.414% 06/07/2022 12/15/2022 1,000,000.00 996,440.00 1,001,090.63 (4,650.63) 1,090.63 N/A Wells Fargo US Treasury Note 2.375% 1.677% 06/07/2022 01/31/2023 1,000,000.00 998,750.00 1,004,471.88 (5,721.88) 4,471.88 N/A Wells Fargo US Treasury Note 2.500% 1.942% 06/07/2022 03/31/2023 1,000,000.00 997,730.00 1,004,471.88 (6,741.88) 4,471.88 N/A Wells Fargo US Treasury Note 2.750% 2.128% 06/07/2022 05/31/2023 1,000,000.00 998,670.00 1,006,000.00 (7,330.00) 6,000.00 N/A Wells Fargo FHLB 0.400% 0.587% 01/29/2021 01/29/2026 295,000.00 272,585.90 295,000.00 (22,414.10) - 07/29/2022 Wells Fargo FHLB 0.400% 0.525% 02/09/2021 02/09/2026 470,000.00 433,236.60 470,000.00 (36,763.40) - 08/09/2022 Wells Fargo FHLB 0.750% 1.432% 04/29/2021 04/29/2026 400,000.00 376,644.00 400,000.00 (23,356.00) - 12/29/2022 Wells Fargo FHLB 0.650% 1.069% 06/30/2021 06/30/2026 300,000.00 277,974.00 300,000.00 (22,026.00) - 09/30/2022 Wells Fargo FHLB 0.600% 1.281% 09/30/2021 09/30/2026 250,000.00 232,722.50 250,000.00 (17,277.50) - 09/30/2022 Wells Fargo CD's 2.000% 2.000% 08/29/2020 08/22/2022 200,000.00 199,884.00 200,000.00 (116.00) - 09/29/2022 Wells Fargo CD's 2.550% 2.550% 06/17/2022 12/18/2023 245,000.00 243,177.20 245,000.00 (1,822.80) - N/A Wells Fargo CD's 0.300% 0.300% 01/08/2021 01/08/2024 245,000.00 234,834.95 245,000.00 (10,165.05) - N/A Wells Fargo CD's 0.450% 0.450% 04/14/2021 04/15/2024 245,000.00 233,242.45 245,000.00 (11,757.55) - 08/14/2022 Wells Fargo CD's 2.800% 2.800% 06/17/2022 12/18/2023 245,000.00 242,748.45 245,000.00 (2,251.55) - N/A Wells Fargo CD's 0.550% 0.550% 08/02/2021 08/05/2024 245,000.00 231,390.25 245,000.00 (13,609.75) - N/A Wells Fargo CD's 1.100% 1.100% 01/31/2022 01/31/2025 245,000.00 231,402.50 245,000.00 (13,597.50) - 07/31/2022 Wells Fargo CD's 1.600% 1.600% 02/23/2022 02/24/2025 245,000.00 234,107.30 245,000.00 (10,892.70) - N/A Wells Fargo CD's 3.100% 3.100% 06/15/2022 06/16/2025 245,000.00 242,964.05 245,000.00 (2,035.95) - N/A Wells Fargo CD's 3.100% 3.100% 06/15/2022 06/16/2025 245,000.00 242,964.05 245,000.00 (2,035.95) - N/A Wells Fargo CD's 1.000% 1.000% 05/19/2021 05/19/2026 245,000.00 224,121.10 245,000.00 (20,878.90) - N/A Wells Fargo CD's 1.000% 1.000% 07/28/2021 07/28/2026 245,000.00 222,548.20 245,000.00 (22,451.80) - N/A Wells Fargo CD's 1.050% 1.050% 08/08/2021 08/25/2026 238,000.00 216,822.76 238,000.00 (21,177.24) - N/A Wells Fargo CD's 1.000% 1.207% 07/31/2021 07/13/2028 245,000.00 214,860.10 245,000.00 (30,139.90) 12/13/2022 Broker Total 48.9% 9,093,000.00 8,830,104.02 9,109,034.39 (309,214.03) - Cetera Investment Services Money Market 0.010% 0.010% N/A N/A - 6,061.50 - - - N/A Cetera Investment Services Municipal Bonds 3.000% 3.118% 12/20/2018 08/01/2022 50,000.00 50,038.00 50,377.67 (339.67) 377.67 N/A Cetera Investment Services Municipal Bonds 3.650% 3.004% 12/20/2018 02/01/2023 250,000.00 250,385.00 256,165.00 (5,780.00) 6,165.00 N/A Cetera Investment Services Municipal Bonds 3.240% 3.240% 11/17/2017 02/15/2023 80,000.00 78,526.40 69,633.48 8,892.92 (10,366.52) N/A Cetera Investment Services Municipal Bonds 3.075% 3.236% 12/20/2018 06/01/2023 50,000.00 49,900.50 49,746.15 154.35 (253.85) N/A Cetera Investment Services Municipal Bonds 5.290% 2.724% 04/18/2019 06/01/2023 260,000.00 264,693.00 291,059.96 (26,366.96) 31,059.96 N/A Cetera Investment Services Municipal Bonds 2.500% 3.181% 12/20/2018 08/01/2023 35,000.00 34,654.55 34,320.05 334.50 (679.95) N/A Cetera Investment Services Municipal Bonds 3.400% 3.148% 12/20/2018 11/01/2023 125,000.00 125,176.25 126,376.25 (1,200.00) 1,376.25 N/A Cetera Investment Services Municipal Bonds 3.400% 3.148% 12/20/2018 11/01/2023 65,000.00 65,091.65 65,715.65 (624.00) 715.65 N/A Cetera Investment Services Municipal Bonds 2.854% 3.173% 12/20/2018 02/01/2024 100,000.00 99,211.00 99,605.96 (394.96) (394.04) N/A Cetera Investment Services Municipal Bonds 2.977% 3.246% 12/20/2018 03/15/2024 250,000.00 249,365.00 248,743.99 621.01 (1,256.01) N/A Cetera Investment Services Municipal Bonds 1.940% 1.821% 01/13/2020 05/01/2024 65,000.00 63,372.40 65,570.70 (2,198.30) 570.70 N/A Cetera Investment Services Municipal Bonds 5.742% 3.658% 04/11/2019 08/01/2024 275,000.00 282,752.25 302,390.00 (19,637.75) 27,390.00 N/A Cetera Investment Services Municipal Bonds 2.528% 1.918% 01/13/2020 12/01/2024 100,000.00 97,531.00 102,999.53 (5,468.53) 2,999.53 N/A Cetera Investment Services Municipal Bonds 3.922% 3.429% 12/20/2018 12/01/2024 204,000.00 205,177.08 208,181.10 (3,004.02) 4,181.10 N/A Cetera Investment Services Municipal Bonds 4.400% 3.221% 04/11/2019 07/01/2025 500,000.00 500,310.00 539,101.11 (38,791.11) 39,101.11 07/01/2023 Cetera Investment Services Municipal Bonds 5.640% 3.007% 04/18/2019 08/15/2025 205,000.00 181,603.35 169,737.95 11,865.40 (35,262.05) N/A Cetera Investment Services Municipal Bonds 3.743% 2.740% 04/18/2019 09/15/2025 215,000.00 217,197.30 228,334.53 (11,137.23) 13,334.53 N/A Cetera Investment Services Municipal Bonds 3.379% 1.934% 08/19/2019 10/01/2025 310,000.00 307,718.40 339,739.18 (32,020.78) 29,739.18 N/A Cetera Investment Services Municipal Bonds 2.727% 2.271% 03/03/2022 12/01/2025 335,000.00 319,600.05 342,781.72 (23,181.67) 7,781.72 N/A Cetera Investment Services Municipal Bonds 5.600% 1.186% 07/28/2020 12/01/2025 45,000.00 48,128.40 55,250.55 (7,122.15) 10,250.55 N/A Cetera Investment Services Municipal Bonds 4.250% 3.258% 04/11/2019 01/01/2026 500,000.00 510,550.00 529,769.03 (19,219.03) 29,769.03 N/A Cetera Investment Services Municipal Bonds 2.420% 1.175% 10/06/2020 03/01/2026 100,000.00 95,463.00 106,734.28 (11,271.28) 6,734.28 N/A Cetera Investment Services Municipal Bonds 1.609% 1.124% 09/24/2020 04/01/2026 285,000.00 267,786.00 292,370.10 (24,584.10) 7,370.10 N/A Cetera Investment Services Municipal Bonds 6.690% 3.356% 04/18/2019 04/15/2026 60,000.00 52,122.00 47,545.20 4,576.80 (12,454.80) N/A Cetera Investment Services Municipal Bonds 5.900% 1.451% 07/28/2020 06/15/2026 75,000.00 81,099.00 93,741.75 (12,642.75) 18,741.75 N/A Cetera Investment Services Municipal Bonds 0.000% 1.415% 08/13/2020 07/01/2026 100,000.00 85,404.00 92,037.00 (6,633.00) (7,963.00) N/A Cetera Investment Services Municipal Bonds 3.250% 2.903% 04/18/2019 08/01/2026 500,000.00 496,090.00 514,790.69 (18,700.69) 14,790.69 N/A Cetera Investment Services Municipal Bonds 2.116% 3.307% 06/07/2022 08/01/2026 75,000.00 70,337.25 71,565.00 (1,227.75) (3,435.00) N/A Cetera Investment Services Municipal Bonds 2.150% 2.203% 07/01/2019 12/01/2026 40,000.00 37,848.00 40,150.64 (2,302.64) 150.64 N/A Cetera Investment Services Municipal Bonds 1.664% 1.150% 08/27/2020 09/01/2026 225,000.00 208,327.50 231,696.00 (23,368.50) 6,696.00 N/A Cetera Investment Services Municipal Bonds 2.375% 1.816% 09/04/2019 12/01/2026 90,000.00 85,077.00 93,395.70 (8,318.70) 3,395.70 N/A Cetera Investment Services Municipal Bonds 2.350% 2.191% 07/01/2019 12/01/2026 500,000.00 475,280.00 505,385.00 (30,105.00) 5,385.00 N/A Cetera Investment Services Municipal Bonds 3.000% 1.991% 08/19/2019 02/01/2027 50,000.00 48,615.50 53,551.00 (4,935.50) 3,551.00 N/A Cetera Investment Services Municipal Bonds 3.150% 2.034% 08/19/2019 03/15/2027 100,000.00 97,198.00 109,138.50 (11,940.50) 9,138.50 N/A Cetera Investment Services Municipal Bonds 3.332% 3.120% 04/18/2019 04/15/2027 500,000.00 492,650.00 507,783.94 (15,133.94) 7,783.94 N/A Cetera Investment Services Municipal Bonds 3.865% 2.470% 08/19/2019 05/01/2027 55,000.00 55,717.75 60,986.48 (5,268.73) 5,986.48 05/01/2025 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 3.553% 2.289% 08/19/2019 05/01/2027 55,000.00 53,931.90 60,468.04 (6,536.14) 5,468.04 05/01/2026 Cetera Investment Services Municipal Bonds 3.230% 1.828% 08/19/2019 05/15/2027 145,000.00 141,344.55 160,827.31 (19,482.76) 15,827.31 N/A Cetera Investment Services Municipal Bonds 1.925% 1.719% 11/23/2021 06/01/2027 310,000.00 284,812.50 313,447.46 (28,634.96) 3,447.46 Make -Whole Call Cetera Investment Services Municipal Bonds 1.861% 1.254% 06/07/2021 07/01/2027 410,000.00 373,723.20 412,336.71 (38,613.51) 2,336.71 N/A Cetera Investment Services Municipal Bonds 3.000% 3.101% 05/18/2020 09/01/2027 65,000.00 65,603.20 69,180.58 (3,577.38) 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,481.25 27,969.55 511.70 (7,030.45) 05/01/2025 Cetera Investment Services Municipal Bonds 1.415% 1.793% 11/23/2021 03/01/2028 100,000.00 88,898.00 98,088.31 (9,190.31) (1,911.69) N/A Cetera Investment Services Municipal Bonds 3.270% 2.141% 08/19/2019 03/15/2028 155:000.00 149,953.20 170,805.09 (20,851.89) 15,805.09 09/15/2027 Cetera Investment Services Municipal Bonds 2.974% 2.574% 11/07/2019 04/01/2028 75,000.00 70,631.25 77,253.00 (6,621.75) 2,253.00 N/A Cetera Investment Services Municipal Bonds 2.125% 1.904% 11/23/2021 06/01/2028 110,000.00 100,028.50 111,525.06 (11,496.56) 1,525.06 N/A Cetera Investment Services Municipal Bonds 2.547% 1.240% 08/10/2021 07/01/2028 125,000.00 116,828.75 136,101.16 (19,272.41) 11,101.16 N/A Cetera Investment Services Municipal Bonds 3.140% 2.004% 08/19/2019 08/01/2028 500,000.00 477,070.00 547,105.00 (70,035.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 90,209.70 95,401.80 (5,192.10) 5,401.80 08/15/2025 Cetera Investment Services Municipal Bonds 1.692% 1.813% 11/24/2021 10/01/2028 180,000.00 156,177.00 179,188.74 (23,011.74) (811.26) N/A Cetera Investment Services Municipal Bonds 3.000% 1.942% 08/19/2019 06/01/2029 115,000.00 109,937.70 125,961.80 (16,024.10) 10,961.80 N/A Cetera Investment Services Municipal Bonds 4.000% 3.214% 03/22/2021 09/01/2031 60,000.00 59,841.00 64,292.00 (4,451.00) 4,292.00 09/01/2024 Cetera Investment Services Municipal Bonds 3.500% 2.699% 11/23/2021 02/01/2033 50,000.00 49:937.50 54,390.44 (4,452.94) 4,390.44 02/01/2025 Cetera Investment Services Municipal Bonds 3.250% 2.655% 08/19/2019 06/01/2029 75,000.00 75,086.25 79,860.31 (4,774.06) 4,860.31 OZ01/2025 Cetera Investment Services Municipal Bonds 3.125% 2.303% 11/23/2021 10/01/2034 50,000.00 47,748.50 54,773.69 (7,025.19) 4:773.69 04/01/2027 Cetera Investment Services Municipal Bonds 3.125% 2.456% 11/23/2021 OZ01/2035 50,000.00 49,089.00 54,236.11 (5,147.11) 4,236.11 OZ01/2026 Broker Total 51.1 % 9,529,000.00 9,245,391.03 9,889,683.00 (650,353.47) 360,683.00 TOTAL INVESTMENTS 100.0% Product Type 6/30/2022 Total Value % of Total 5/31/2022 Total Value % of Total Monthly Change Maturity Lessthan 1year 1 - 2 years Current Value $4,921,362.06 1,590,873.90 % 27.2% 8.8% ME Money Market $36,345.16 0.2% $64,764.89 0.5% ($28,419.73) CD's 3,215,067.36 17.8% 2,257,684.64 17.2% 957,382.72 2-3years 1,768,288.48 9.8% Government Bonds 5,584,753.00 30.9% 1,606,808.15 12.2% 3,977,944.85 3-4years 3,888,165.10 21.5% ,.: Municipal Bonds 9,239,329.53 51.1 % 9,222,698.65 70.1 % 16,630.88 4 - 5 years 3,582,701.41 19.8 % TOTAL $18,075,495.05 100.0% $13,151,956.33 100.0% $4,923,538.72 5+years 2,324,104.10 12.9% TOTAL $18,075,495.05 100.0% Municipal Bonds Money Market $5,000,000.00 $4,921,362,,,,,,, 51.1% 0.2/ a CD's 17.8% $4,500,000.00 $4,000,000.00 $3,888,165 o' $3,582,701 $3,500,000.00 .. ..... ......... ......... .. ......... ......... $3,000,000.00 ... ...- ..-. ' $2,324,104 $2,000,000.00 - -- -4 $1,768,288 _ $1,590,874 $1,000,000.00 $500,000.00 $0.00 .....:::: Less than 1-2years 2-3years 3-4years 4-5years 5+years Government Bonds year 30.9% ELECTRIC DIVISION Operating Revenue June 2022 CLASS AMOUNT KWH /KWH Street Lights $19.24 353 $0.05450 Electric Residential Service $546,144.81 5,289,518 $0.10325 All Electric Residential Service $16,773.29 149,753 $0.11201 Electric Small General Service $163,035.33 1,596,890 $0.10210 Electric Large General Service $698,289.58 7,691,150 $0.09079 Electric Large Industrial Service $849,162.48 10,773,000 $0.07882 Total $2,273,424.73 25,500,664 $0.08915 Power Adjustment $0.00422 Rate Without Power Adjustment $0.08493 Electric Division Year -to -Date M2022$A--t 02021$A--t ■2022KWH110 02021 KWH110 15,000,000 14,000,000 13,000,000 12,000,000 11,000,000 10,000,000 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 Street Lights Residential All Elec. Small Gen. Large Gen. Large For Resale Total Resid. Srv. Srv. Industrial NOTE: Sales for resale includes capacity sales and market sales. NATURAL GAS DIVISION Operating Revenue JUNE 2022 CLASS AMOUNT MCF /$ MCF Residential $138,417.41 6,916 $20.01408 Commercial $106,737.41 8,653 $12.33531 Large Industrial $34,548.25 4,211 $8.20429 Large Industrial Contracts $327,164.23 48,569 $6.73607 Total $606,867.30 68,349 $8.87895 Fuel Adjustment $0.00000 Rate Without Fuel Adjustment $8.87895 Natural Gas Division Year -to -Date ® 2022 $ Amount 0 2021 $ Amouni ■ 2022 MCF 132021 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 2022 Month 06 - June Annual Report? Yes Oio No Hutchinson Utilities Commission Minimum duration 5 Maximum duration Top-level Cause Substation Circuit Remove Major Events? IEEE 1366 Statistics Metric Jun 2022 Jun 2021 SAI D I 0.434 2.01 SAIFI 0.00779 0.0266 CAI DI 55.758 75.573 ASAI 99.9989% 99.9951 % Momentary Interruptions 0 0 Sustained Interruptions 2 6 Circuit Ranking - Worst Performing Ranked by Outage Count Circuit Substation Fdr#14 Plant 1 Fdr#22 Plant 2 Ranked by Customer Interruptions Circuit Substation Fdr#22 Plant 2 Fdr#14 Plant 1 Ranked by Customer Minutes of Duration Circuit Substation Fdr#22 Plant 2 Fdr#14 Plant 1 Number of Outages 1 1 Customer Interruptions 47 11 Customer Minutes of Duration 2,585 649 Historical Monthly SAIDI Chart 0.50 Mo hly Avg age 0.40 .......... .. .' 0.30 .............. .. 0.20 ... ::.................................................................................. 0.10 ................................................................... .......................... 0.001 Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun 2021 2021 2021 2021 2021 2021 2022 2022 2022 2022 2022 2022 Historical Monthly SAIFI Chart 0.015 f Mo thly Ave age 0.010 0.005 ........................ .. i �..�,.. 0.000 ,�a Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun 2021 2021 2021 2021 2021 2021 2022 2022 2022 2022 2022 2022 SAIDI of monthly SAIDI values SAIFI of monthly SAIFI values Causes Ranked by Count Cause Heat Non -Utility Excavation Causes Ranked by Duration Cause Non -Utility Excavation Count Duration 2,585 Heat 649 Top 2 Outages for the Month Customers Address Interrupted 1267 Denver Ave 47 SE 422 Jefferson St 11 SE Total Customers Affected for the Month: Average Customers Affected per Outage: Customer Minutes of Duration Interruption 55 2,585 59 649 Start Date 06/24/2022 06/20/2022 58 29 HUTCHINSON UTILITIES COMMISSION f tit ,c�,« Board Action Form Agenda Item: Review Policies Jeremv Carter Review Policies BACKGROUND/EXPLANATION OFAGENDA ITEM: es 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: Appendices of Exempt Handbook Appendices of Non -Exempt Handbook BOARD ACTION REQUESTED: None EXEMPT 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 I APPENDIX B — NEW EMPLOYEE ACKNOWLEDGEMENT I, Commission") as have been hired by the Hutchinson Utilities Commission ("the I acknowledge that I will serve a nine (9) 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 APPENDIX C — TEMPORARY EMPLOYEE ACKNOWLEDGEMENT I, Commission") as have been hired by the Hutchinson Utilities Commission ("the 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 3 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 4 NON-EXEMPT 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 5 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 0 APPENDIX C — TEMPORARY EMPLOYEE ACKNOWLEDGEMENT I, Commission") as have been hired by the Hutchinson Utilities Commission ("the 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 7 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 91 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