The URL can be used to link to this page

07-28-2021 HUCCPHUTCHINSON UTILITIES COMMISSION AGENDA REGULAR MEETING July 28, 2021 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 23, 2021 Call to order — 3:00 p.m. President Matt Cheney called the meeting to order. Members present: President Matt Cheney; Vice President Anthony Hanson; Secretary Don Martinez; Commissioner Monty Morrow; Commissioner Robert Wendorff; GM Jeremy Carter; Attorney Marc Sebora Conflict of Interest 2. Approve Consent Agenda a. Approve Minutes b. Ratify Payment of Bills Motion by Commissioner Martinez, second by Commissioner Wendorff to approve the Consent Agenda. Motion carried unanimously. 3. Approve Financial Statements GM Carter presented the Financial Statements. Combined Divisions outstanding receivables are up from last year, one contributing factor to this is switching to a new credit card processor and customers not switching over payments right away. Electric Division usage was up for May with it being a warmer month. Total KWH Sold up 3.5% over last year. There was no Power Cost Adjustment for May 2021. HUC's market sales were higher which led to increased fuel cost. Natural Gas Division is fairly consistent. Rate stabilization is trending up, current balance is about $355K. Commissioner Morrow inquired about the generation and if all the engines are up and running. GM Carter stated for the most part all are up and running, going through some troubleshooting on oil issues for units 6 & 7 but Staff is working with Caterpillar. Motion by Commissioner Hanson, second by Commissioner Morrow to approve the financial statements. Motion carried unanimously. 4. Open Forum 5. Communication a. City Administrator —Matthew Jaunich i. Council awarded bids for new police station, work to start end of July/Aug. ii. Apartments and town homes are all filling up. New Home construction is down due to supplies iii. Mainstreet is starting to see new businesses '7=big0"017 i. Dan Lang, Engineering Services Manager — 1. Capacitor Bank update - completed ii. Dave Hunstad, Electric Transmission/Distribution Manager — 1 . Solar Project Update — project is moving faster than planned; fence is being started 2. Community solar roof top projects are going up 3. Reconductor project update on south part of town. 4. Plant 2 sub update - Transformers are installed, working on getting feeders back up looking at late June/early July. Relays and controls need to be completed to get feeders back up looking at late June/early July. Energizing should be completed in late August. iii. Randy Blake, Production Manager — 1 . Working in conjunction with Dans group 2. Unit 7 update — Discussed gas composition related to oil issues along with boosting the compression ratio. When compression was boosted it changed the characteristics of the engine internally and dynamically. Caterpillar promised to redo the engines, which means 40 new pistons, 40 new liners and 40 new sets of rings at no cost to HUC. Ziegler will be here to start the work in Oct. The 1000hrs break in period will than start over. 3. Finishing up Capital projects 4. Retiring at end of July — Commission thanked Randy for all the years of service. iv. John Webster, Natural Gas Division Director — Absent v. Jared Martig, Financial Manager- Absent c. Human Resources - Brenda Ewing — Absent d. Legal — Marc Sebora — Nothing to Report e. General Manager — Jeremy Carter i. Compensation Study is moving forward ii. Accountant interviews to start happening in next couple of weeks. iii. Legislative Update — 1. Working on budget 2. Clean Energy for America Act 3. ERCOT conversations. 6. Policies a. Review Policies i. Section 6 of Exempt Handbook ii. Section 6 of Non -Exempt Handbook No changes recommended at this time. 7. Unfinished Business a. Status of Governor's Salary Cap - Mr. Sebora stated that there were no conversations on this topic during the Special Session. Commission will need to have conversations on this topic regarding the GM's Compensation. Options are to have this topic on a future agenda, discussions can be made on policy changes, have a 3rd party contract 2 to adjust compensation, wait and see were salary cap lands but that is late for the GM's review, or lastly do nothing. President Cheney looked to the Commission for ideas. It was concluded that Mr. Cheney would speak with all the Commissioners along with reaching out to Ms. Ewing. 8. New Business a. Approve Requisition #8750 — Plant 1 Forcier/Marty's Roofing Mr. Blake presented approval of requisition #8750 - Plant 1 Forcier/Marty's Roofing. The roof at Plant 1 is over 30 years old and needs to be replaced as there are many leaks. Three quotes were received with the lowest bid being Forcier/Marty's Roofing at $29,013.00. This is a 2021 capital expenditure project work order #12103, estimated budget was $40K. Motion by Commissioner Hanson, second by Commissioner Martinez to Approve Requisition #8750 — Plant 1 Forcier/Marty's Roofing. Motion carried unanimously. b. Discussion of Citizen Survey GM Carter discussed the beginning steps of the Citizen Survey. A contract from Polco was just received and sent to the Commissioners prior to the meeting. The intent was to have the Commission look at the pricing structure, the content itself still needs to be reviewed by Staff and Mr. Sebora. Last year when a quote was received from NRC it came in just under $25K, which $25K was budgeted. Since than Polco has now bought out NRC and created a different rate structure system based on customizable surveys for the Energy Industry. These customizable surveys require a 2-year commitment structure. The first year it would cost HUC $30,300; which includes the customizable survey of a three -page survey with one open ended question and the subscription cost. The second year it would cost HUC $19K; which is the subscription cost. Conversations were held on the cost of the new pricing structure, if this is still the right vendor to use and the timing of when this would be completed in relation to the strategic planning meeting. GM Carter will follow up with Polco on a few questions including pushing back the second year along with looking for another company quote. Special meeting may be needed for this topic. 9. Adjourn There being no further business, a motion by Commissioner Wendorff second by Commissioner Hanson to adjourn the meeting at 3:59p.m. Motion carried unanimously. 3 Don Martinez, Secretary ATTEST: Matt Cheney, President 07/21/2021 12:38 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/19/2021 - 07/22/2021 Description Fund: 1 ELECTRIC 06/21/2021 GEN 812(E) MRES 06/21/2021 GEN 818(E)* MINNESOTA REVENUE 06/22/2021 GEN 831(E) MISO 06/29/2021 GEN 832(E) MISO 07/02/2021 GEN 822(E)* CITIZENS BANK 07/06/2021 GEN 833(E) MISO 07/07/2021 GEN 823(E)* INVOICE CLOUD 07/09/2021 GEN 74319 30-30 RENTAL PROPERTIES 07/09/2021 GEN 74320 ADVANCED PROCESS SOLUTIONS Purchased Power STATE SALES TAX STATE SALES TAX City Sales Tax COUNTY SALES TAX HECK GEN 818(E) TOTAL FOR FUND 1: Deferred Energy Cost - Miso Deferred Energy Cost - Miso Office Supplies Deferred Energy Cost - Miso Collection - Materials OVERPAYMENTS Bray electric actuator -quote HU- 5o tariff surcharge HECK GEN 74320 TOTAL FOR FUND 1: 07/09/2021 GEN 74321* AIR -PRO HEATING & COOLING LLC DEP REFUND/APPLIED 07/09/2021 GEN 74322 AL KOHN Cip - Residential 07/09/2021 GEN 74323* ALEXANDER KRIPPNER DEP REFUND/APPLIED 07/09/2021 GEN 74324 ALICE KAUFMANN Cip - Residential 07/09/2021 GEN 74325* ANGELA MAUS DEP REFUND/APPLIED 07/09/2021 GEN 74326* ANGELA PAEHLKE DEP REFUND/APPLIED 07/09/2021 GEN 74327* ANGIE BLOEMKE DEP REFUND/APPLIED 07/09/2021 GEN 74328* ANTHONY INGERSON OR TESSA KILKER DEP REFUND/APPLIED 07/09/2021 GEN 74330* BECKY JO GETZ DEP REFUND/APPLIED Account Dept 401-555- 02 242-000- 00 242-000- 00 242-000- 00 242-000- 00 174-000- 00 174-000- 00 401-921- 08 174-000- 00 401-903- 06 142-000- 00 402-554- 01 402-554- 01 235-000- 00 401-916- 07 235-000- 00 401-916- 07 235-000- 00 235-000- 00 235-000- 00 235-000- 00 235-000- 00 Page 1/24 Amount 855,380.61 72,661.00 58,709.00 4,240.00 726.66 656.53 94.06 743.81 1,528.42 114.25 2,118.94 2,245.73 338.00 30.00 123.50 30.00 169.00 243.75 149.50 227.50 208.00 07/21/2021 12:38 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/19/2021 - 07/22/2021 Description Fund: 1 ELECTRIC 07/09/2021 GEN 74331* BETSY PRICE 07/09/2021 GEN 74332 BILL BREITKREUTZ 07/09/2021 GEN 74333 BILL SNYDER 07/09/2021 GEN 74334*4 BORDER STATES ELECTRIC SUPPLY 07/09/2021 GEN 74335* BRANDON CHATFIELD 07/09/2021 GEN 74336 BRUCE ADAMS 07/09/2021 GEN 74337 BRUCE BJERKLUND 07/09/2021 GEN 74338 BRUCE OLSEN 07/09/2021 GEN 74339* CARY WRIGHT 07/09/2021 GEN 74340 CE POWER 07/09/2021 GEN 74341* CHELSEA SCHMIDT 07/09/2021 GEN 74342* CHRIS GUTORMSON Page 2/24 Account Dept Amount DEP REFUND/APPLIED 235-000- 00 195.00 OVERPAYMENTS 142-000- 00 228.17 Cip - Residential 401-916- 07 30.00 ASSEMBLY, LED, ACORN, GRANVILLE II, 154-000- 00 6,342.02 ASSEMBLY, LED, ACORN, GRANVILLE II, 154-000- 00 0.01 TERMINAL BLOCK, 3 PLACE, "COVERED" CSB 154-000- 00 53.29 CONDUCTOR, 14 TW BLACK SOL $10.10 154-000- 00 147.00 CONDUCTOR, 14 TW BLACK SOL $10.10 154-000- 00 0.01 CONDUCTOR, 14 TW WHITE SOL $10.10 154-000- 00 147.00 CONDUCTOR, 14 TW WHITE SOL $10.10 154-000- 00 0.01 CONDUCTOR, 2-4-2 URD 600V TRIPLEX 154-000- 00 952.00 CONDUCTOR, 2-4-2 URD 600V TRIPLEX 154-000- 00 0.07 CRIMPIT, 44 SIR CU TO 6 SOL, YC4C6 154-000- 00 13.50 TAPE, 88-SUPER-1-1/2" X 36YD 154-000- 00 90.79 Sales Tax Receivable - New 186-000- 00 85.66 Sales Tax Receivable - New 186-000- 00 0.01 Sales Tax Receivable - New 186-000- 00 0.93 BATTERY, SIZE D 401-588- 02 72.36 Materials 402-574- 03 271.80 HECK GEN 74334 TOTAL FOR FUND 1: 8,176.46 Cip - Residential 401-916- 07 225.00 Cip - Residential 401-916- 07 200.00 Cip - Residential 401-916- 07 30.00 Cip - Residential 401-916- 07 30.00 DEP REFUND/APPLIED 235-000- 00 318.50 Plant 2 site work 107-362- 00 68,598.75 Sales Tax Receivable - New 186-000- 00 9,432.33 HECK GEN 74340 TOTAL FOR FUND 1: 78,031.08 DEP REFUND/APPLIED 235-000- 00 178.75 DEP REFUND/APPLIED 235-000- 00 78.00 07/21/2021 12:38 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/19/2021 - 07/22/2021 Payee Description Account Dept Page 3/24 Amount Fund: 1 ELECTRIC 07/09/2021 GEN 74343 CHRIS THORKILDSEN OVERPAYMENTS 142-000- 00 77.50 07/09/2021 GEN 74344* CINDY MATSON DEP REFUND/APPLIED 235-000- 00 84.50 07/09/2021 GEN 74345*4 CINTAS CORPORATION 4470 Uniforms & Laundry 401-550- 01 405.61 Uniforms & Laundry 401-550- 01 415.16 Uniforms & Laundry 401-550- 01 405.61 UNIFORMS & LAUNDRY 401-588- 02 286. 42 UNIFORMS & LAUNDRY 401-588- 02 286. 42 UNIFORMS & LAUNDRY 401-588- 02 286. 42 HECK GEN 74345 TOTAL FOR FUND 1: 2,085.64 07/09/2021 GEN 74346*4 CITY OF HUTCHINSON Generator 41 Water & Sewer 401-547- 01 681.82 Generator 41 Water & Sewer 401-547- 01 641.83 Waste Disposal 401-550- 01 68.10 Waste Disposal 401-550- 01 1,948.46 Line - Materials 402-594- 02 8.66 Utility Expenses - Water/Waste 401-930- 08 58.84 Utility Expenses - Water/Waste 401-930- 08 418.38 Utility Expenses - Water/Waste 401-930- 08 8.62 HECK GEN 74346 TOTAL FOR FUND 1: 3,834.71 07/09/2021 GEN 74347 CREEKSIDE SOILS Materials 401-588- 02 63.59 07/09/2021 GEN 74348 DAKOTA SUPPLY GROUP ELBOW, FIBERGLASS, 2" IPS, .070" WALL, 154-000- 00 1, 036. 93 Sales Tax Receivable - New 186-000- 00 71.29 HECK GEN 74348 TOTAL FOR FUND 1: 1,108.22 07/09/2021 GEN 74349 DALE SCHUMANN Cip - Residential 401-916- 07 30.00 07/09/2021 GEN 74350* DALE SOVICH OR ANDREA KESKE-SOVICH DEP REFUND/APPLIED 235-000- 00 149.50 07/09/2021 GEN 74351 DARLYN EDGE Cip - Residential 401-916- 07 25.00 07/09/2021 GEN 74352 DARREL REMILY Cip - Residential 401-916- 07 30.00 07/09/2021 GEN 74353* DARREON JOHNSTON DEP REFUND/APPLIED 235-000- 00 39.00 07/09/2021 GEN 74354 DEAN GAUER Cip - Residential 401-916- 07 30.00 07/09/2021 GEN 74355 DEBRA MCKITTRICK Cip - Residential 401-916- 07 30.00 07/21/2021 12:38 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/19/2021 - 07/22/2021 Description Fund: 1 ELECTRIC 07/09/2021 GEN 74356* DESHAWN ALLENDALE 07/09/2021 GEN 74357 DGR ENGINEERING 07/09/2021 GEN 74358 DUANE SKORHEIM 07/09/2021 GEN 74359* ELIZABETH PAINSCHAUB 07/09/2021 GEN 74360 EMILY SCHERMANN 07/09/2021 GEN 74361* ERIC BELLIGAN 07/09/2021 GEN 74362* ERIN PETTY 07/09/2021 GEN 74363* ESEESE MAPU OR BILL GAINS 07/09/2021 GEN 74364 EVERETT HANTGE 07/09/2021 GEN 74365* FIRST CHOICE FOOD & BEVERAGE 07/09/2021 GEN 743664 FREMONT INDUSTRIES INC Page 4/24 Account Dept Amount DEP REFUND/APPLIED 235-000- 00 52.00 Outside Services 402-574- 03 4,100.50 Outside Services 402-574- 03 1,423.00 HECK GEN 74357 TOTAL FOR FUND 1: 5,523.50 Cip - Residential 401-916- 07 30.00 DEP REFUND/APPLIED 235-000- 00 65.00 Cip - Residential 401-916- 07 60.00 DEP REFUND/APPLIED 235-000- 00 39.00 DEP REFUND/APPLIED 235-000- 00 104.00 DEP REFUND/APPLIED 235-000- 00 146.25 Cip - Residential 401-916- 07 30.00 BREAKROOM/RECOGNITION BANQUET 401-926- 08 85.50 TOWER INHIBITOR, F-9173 154-000- 00 8,279. 92 TOWER INHIBITOR, F-9173 154-000- 00 0.07 FTR-50, Testing Reagent 401-550- 01 115.75 FTR-50, Testing Reagent 401-550- 01 1.69 FWT-17, PH 4 buffer 401-550- 01 111.15 FWT-17, PH 4 buffer 401-550- 01 1.63 FWT-18, PH 7 buffer 401-550- 01 138.94 FWT-18, PH 7 buffer 401-550- 01 2.03 FWT-19, PH 10 buffer 401-550- 01 83.36 FWT-19, PH 10 buffer 401-550- 01 1.22 FWT-6, 445 Micromho 401-550- 01 85.50 FWT-6, 445 Micromho 401-550- 01 1.25 FWT-7, 2060 Micromho 401-550- 01 19.24 FWT-7, 2060 Micromho 401-550- 01 0.28 FTR-60, Testing Reagent 401-550- 01 355.34 FTR-60, Testing Reagent 401-550- 01 5.20 FTE-163, Bacteria dip slides 401-550- 01 530.83 FTE-163, Bacteria dip slides 401-550- 01 7.76 FTR-17, Testing Reagent 401-550- 01 27.79 07/21/2021 12:38 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/19/2021 - 07/22/2021 Payee Description Account Dept Page 5/24 Amount Fund: 1 ELECTRIC FTR-17, Testing Reagent 401-550- 01 0.41 FTR-42, Testing Reagent 401-550- 01 40.36 FTR-42, Testing Reagent 401-550- 01 0.59 FTR-44, Testing Reagent 401-550- 01 36.34 FTR-44, Testing Reagent 401-550- 01 0.53 FTR-46, Testing Reagent 401-550- 01 35.48 FTR-46, Testing Reagent 401-550- 01 0.06 FRT-2, Testing Reagent 401-550- 01 13.89 FRT-2, Testing Reagent 401-550- 01 0.20 FTR-80, Testing Reagent 401-550- 01 83.36 FTR-80, Testing Reagent 401-550- 01 1.22 FTR-11. Testing Reagent 401-550- 01 96.83 FTR-11. Testing Reagent 401-550- 01 1.42 FWT-7, 2060 Micromho 401-550- 01 82.22 FTR-28, Testing Reagent 401-550- 01 38.19 FTR-29, Testing Reagent 401-550- 01 37.68 HECK GEN 74366 TOTAL FOR FUND 1: 10,237.73 07/09/2021 GEN 74367 GARY FELLBAUM OR SALLY FRYAR OVERPAYMENTS 142-000- 00 302.60 07/09/2021 GEN 74368* GDM SEEDS INC DEP REFUND/APPLIED 235-000- 00 149.50 07/09/2021 GEN 74369 GERALD PETERSON OR KRIS PETERSON OVERPAYMENTS 142-000- 00 520.29 07/09/2021 GEN 74370 GREAT RIVER ENERGY TRANSMISSION EXPENSE 401-565- 03 211,982.41 07/09/2021 GEN 74372* GREG ST HILAIRE OR CAROL ST DEP REFUND/APPLIED 235-000- 00 130.00 07/09/2021 GEN 74373*4 HILLYARD/HUTCHINSON Supplies 401-550- 01 261.85 Grounds - Materials 401-935- 08 34.69 Grounds - Materials 401-935- 08 294.89 Grounds - Materials 401-935- 08 113.61 HECK GEN 74373 TOTAL FOR FUND 1: 705.04 07/09/2021 GEN 74374 HOWARD MADSEN Cip - Residential 401-916- 07 30.00 07/09/2021 GEN 74375* HUTCHFIELD SERVICES INC Grounds - Outside Services 401-935- 08 1,112.73 07/09/2021 GEN 74376* JACOB JORGENSEN OR KATE JORGENSEN DEP REFUND/APPLIED 235-000- 00 130.00 07/09/2021 GEN 74377 JANELLE WALTER Cip - Residential 401-916- 07 30.00 07/09/2021 GEN 74378 JEANETTE MEYER Cip - Residential 401-916- 07 30.00 07/21/2021 12:38 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/19/2021 - 07/22/2021 Payee Description Account Dept Page 6/24 Amount Fund: 1 ELECTRIC 07/09/2021 GEN 74379 JERRY HAYDEN Cip - Residential 401-916- 07 30.00 07/09/2021 GEN 74380* JESSICA SULLIVAN DEP REFUND/APPLIED 235-000- 00 97.50 07/09/2021 GEN 74381 JIM DEMEYER Cip - Residential 401-916- 07 30.00 07/09/2021 GEN 74382 JOHN SPLICHAL Cip - Residential 401-916- 07 30.00 07/09/2021 GEN 74383* JONATHAN ROBLES OR GINA ROBLES DEP REFUND/APPLIED 235-000- 00 234.00 07/09/2021 GEN 74384* JORGE SANDOVAL OR AIDEE SANDOVAL DEP REFUND/APPLIED 235-000- 00 211.25 07/09/2021 GEN 74385 JOSH GASPAR Cip - Residential 401-916- 07 30.00 07/09/2021 GEN 74386 JOSH PETERSON Cip - Residential 401-916- 07 30.00 07/09/2021 GEN 74387 JOYCE THORSON Cip - Residential 401-916- 07 30.00 07/09/2021 GEN 74388 JUDITH KREBSBACH Cip - Residential 401-916- 07 30.00 07/09/2021 GEN 74389* JUSTIN M SPICER DEP REFUND/APPLIED 235-000- 00 78.00 07/09/2021 GEN 74390 KAMARIA BUCHANAN OVERPAYMENTS 142-000- 00 145.16 07/09/2021 GEN 74391 KAREN SCHRADER Cip - Residential 401-916- 07 30.00 07/09/2021 GEN 74392* KATIE CANNON DEP REFUND/APPLIED 235-000- 00 247.00 07/09/2021 GEN 74393* KEITH NELSON Cip - Residential 401-916- 07 25.00 07/09/2021 GEN 74394* KYLIE ROSENQUIST OR BRADLEY WOLFF DEP REFUND/APPLIED 235-000- 00 71.50 07/09/2021 GEN 74395 L & P SUPPLY COMPANY Accessory Plant - Materials 402-554- 01 3.22 07/09/2021 GEN 74396 LEONARD BLAZINSKI Cip - Residential 401-916- 07 30.00 07/09/2021 GEN 74397* LISA WENDINGER DEP REFUND/APPLIED 235-000- 00 48.75 07/09/2021 GEN 74398*4 LOCATORS & SUPPLIES INC SAFETY GLASSES, GRAY, SILVER MIRROR, 401-550- 01 47.04 SAFETY GLASSES, GRAY, SILVER MIRROR, 401-588- 02 47.04 HECK GEN 74398 TOTAL FOR FUND 1: 94.08 07/09/2021 GEN 74399 LOGAN ARNDT OVERPAYMENTS 142-000- 00 57. 90 07/21/2021 12:38 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/19/2021 - 07/22/2021 Payee Description Account Dept Page 7/24 Amount Fund: 1 ELECTRIC 07/09/2021 GEN 74400* LOGAN WELTER DEP REFUND/APPLIED 235-000- 00 169. 00 07/09/2021 GEN 74401 LYLE GIMBERT Cip - Residential 401-916- 07 30.00 07/09/2021 GEN 74402* MACKENZIE REISS OR ANTHONY DEP REFUND/APPLIED 235-000- 00 260.00 07/09/2021 GEN 74403* MANUEL PEREZ JR DEP REFUND/APPLIED 235-000- 00 52.00 07/09/2021 GEN 74404 MARY HENKE Cip - Residential 401-916- 07 30.00 07/09/2021 GEN 74405* MATTHEW BERGMANN DEP REFUND/APPLIED 235-000- 00 169. 00 07/09/2021 GEN 74406* MATTHEW NELSON DEP REFUND/APPLIED 235-000- 00 58.50 07/09/2021 GEN 74407* MATTHEW REINECCIUS DEP REFUND/APPLIED 235-000- 00 45.50 07/09/2021 GEN 74408 MAVIS FISHER Cip - Residential 401-916- 07 30.00 07/09/2021 GEN 74409 MCLEOD COUNTY TREASURER Maintenance Other - Materials 402-554- 01 6.00 07/09/2021 GEN 74410 MELISSA KETCHER Cip - Residential 401-916- 07 30.00 07/09/2021 GEN 74411 MELISSA MEGARD Cip - Residential 401-916- 07 30.00 07/09/2021 GEN 74412* MIA FISCHER DEP REFUND/APPLIED 235-000- 00 26.00 07/09/2021 GEN 74413 MIKE SCHUMANN Cip - Residential 401-916- 07 1,000.00 07/09/2021 GEN 744144 MIRATECH HEAD, CONDENSATE PUMP 154-000- 00 213.65 COOLER BODY, INSULATED 154-000- 00 171.79 INSERT, COOLER 154-000- 00 96.29 SEAL, FILTER COVER 154-000- 00 52.67 PUMP HEAD, CONDENSATE 154-000- 00 334.94 TRANSMITTER, PRESSURE,-0.5/+4 BAR 154-000- 00 252.35 PUMP, SAMPLE GAS 154-000- 00 620.05 VALVE, DOSING, 1.6MM 154-000- 00 317.81 ELL, NO -MEASURING, 0-100 DIM 154-000- 00 1,152.91 ELL, NO MEASURING, 0-500 DIM 154-000- 00 759.61 ELL, NO MEASURING, 0-1000 DIM 154-000- 00 789. 86 ELL, NO MEASURING, 0-2000 DIM 154-000- 00 698.04 ELL, CO MEASURING, 0-500 DIM 154-000- 00 576.46 NOZZLE, INJECTOR, DE75 154-000- 00 286. 62 CAP, AIR ADJUSTMENT, INJECTOR, DE75 154-000- 00 141.36 RING, INJECTOR, (NOZZLE) DE75 154-000- 00 48.78 07/21/2021 12:38 PM CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES Page 8/24 User: JMartig CHECK DATE FROM 06/19/2021 - 07/22/2021 DE: Hutchinson Utili Check Date Bank Check # Payee Description Account Dept Amount Fund: 1 ELECTRIC Quoted components -HUG system 402-554- 01 5,949.91 HECK GEN 74414 TOTAL FOR FUND 1: 12,463.10 07/09/2021 GEN 74415* MN NCPERS LIFE INSURANCE-PERA LIFE 242-000- 00 39.20 07/09/2021 GEN 74416* MUDDY COW GET REFUND/APPLIED 235-000- 00 5,200.00 07/09/2021 GEN 74417 NAN CRARY Cip - Residential 401-916- 07 30.00 07/09/2021 GEN 74418 NAOMI ROSSMAN OR ARRIEL ELIZUR OVERPAYMENTS 142-000- 00 229. 60 07/09/2021 GEN 74419* NATHANIEL DRAXTEN GET REFUND/APPLIED 235-000- 00 195.00 07/09/2021 GEN 74420* NICHOLAS FENNER GET REFUND/APPLIED 235-000- 00 58.50 07/09/2021 GEN 74421* NICHOLAS FENNER GET REFUND/APPLIED 235-000- 00 123.50 07/09/2021 GEN 74422* NICOLE WILER GET REFUND/APPLIED 235-000- 00 42.25 07/09/2021 GEN 74423 NOELLE EVELAND OR GIULIANA HERRERA OVERPAYMENTS 142-000- 00 53.81 07/09/2021 GEN 74424* NOLA BRAATEN GET REFUND/APPLIED 235-000- 00 45.50 07/09/2021 GEN 74425*4 NORTHERN STATES SUPPLY INC Supplies 401-550- 01 27.46 Line - Materials 401-581- 02 27.44 Line - Materials 401-581- 02 53.84 HECK GEN 74425 TOTAL FOR FUND 1: 108.74 07/09/2021 GEN 74426*4 OXYGEN SERVICE COMPANY INC Transportation Equipment 107-392- 00 64.33 Supplies 401-550- 01 43.47 HECK GEN 74426 TOTAL FOR FUND 1: 107.80 07/09/2021 GEN 74427* PARKS KENDALL GET REFUND/APPLIED 235-000- 00 39. 00 07/09/2021 GEN 74428* PATRICIA DALE GET REFUND/APPLIED 235-000- 00 45.50 07/09/2021 GEN 74429 PRO AUTO & TRANSMISSION REPAIR Vehicles - Material 402-554- 01 66.44 07/09/2021 GEN 74430 PROCHASKA LLC CHLOR 125 (SANI-CHLOR) 154-000- 00 987.66 07/21/2021 12:38 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/19/2021 - 07/22/2021 Payee Description Account Dept Page 9/24 Amount Fund: 1 ELECTRIC CHLOR 125 (SANI-CHLOR) 154-000- 00 0.19 HECK GEN 74430 TOTAL FOR FUND 1: 987.85 07/09/2021 GEN 74431 RANDY'S BOBCAT SERVICE & TRUCKING Accessory Plant - Materials 402-554- 01 396.00 07/09/2021 GEN 744324 KID EQUIPMENT WIPER, 2.06 154-000- 00 76.50 Power Equipment - Materials 402-598- 02 76.67 HECK GEN 74432 TOTAL FOR FUND 1: 153.17 07/09/2021 GEN 74433 RENAN BEZERRA OVERPAYMENTS 142-000- 00 39.75 07/09/2021 GEN 74434* RENEE GHERITY OR NOLAN GHERITY DEP REFUND/APPLIED 235-000- 00 221.00 07/09/2021 GEN 74436* ROSA GARCIA DEP REFUND/APPLIED 235-000- 00 195.00 07/09/2021 GEN 74437* RYAN SKLAR DEP REFUND/APPLIED 235-000- 00 71.50 07/09/2021 GEN 74438* SAMANTHA PHILLIPS OR COLLIN DEP REFUND/APPLIED 235-000- 00 156.00 07/09/2021 GEN 74440 SCOTT RYAN Cip - Residential 401-916- 07 25.00 07/09/2021 GEN 74441* SEAN CARLSON DEP REFUND/APPLIED 235-000- 00 143.00 07/09/2021 GEN 74443 SHARON SCHROEDER Cip - Residential 401-916- 07 30.00 07/09/2021 GEN 74444* SHRED RIGHT OFFICE SUPPLIES -SHREDDING SERVICES 401-921- 08 12.60 07/09/2021 GEN 74445* SOFIA RAMIREZ OR ASHLEY RAMIREZ DEP REFUND/APPLIED 235-000- 00 39. 00 07/09/2021 GEN 74447 STEVE STEPIEN OVERPAYMENTS 142-000- 00 108.79 07/09/2021 GEN 74448 SYDNEY REID OVERPAYMENTS 142-000- 00 6.75 07/09/2021 GEN 74449* TALANDIA OR JOHN KACHELMEIER DEP REFUND/APPLIED 235-000- 00 91.00 07/09/2021 GEN 74450 TARGET CORPORATION Cip- Commercial 401-916- 07 3,053.01 07/09/2021 GEN 74451* TERI FISHER DEP REFUND/APPLIED 235-000- 00 48.75 07/09/2021 GEN 74452 TIM WALTERS Cip - Residential 401-916- 07 25.00 07/09/2021 GEN 74453 TOWN & COUNTRY FENCE reistall plant 1 tower fence 107-341- 00 4,692.00 07/21/2021 12:38 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/19/2021 - 07/22/2021 Description Fund: 1 ELECTRIC 07/09/2021 GEN 74454 TRAFFIC CONTROL CORPORATION 07/09/2021 GEN 74455* TYLER BAILEY 07/09/2021 GEN 74457* VICKI SCHLOTTMAN 07/09/2021 GEN 74458* VIDEOTRONIX INC 07/09/2021 GEN 74459 VITALIS IKEM 07/09/2021 GEN 74460 VONNIE BROKEN 07/09/2021 GEN 74461* WENDY ABDEL-AZIZ 07/09/2021 GEN 74462 WESCO RECEIVABLES CORP 07/09/2021 GEN 74463 WILD FLOWER PROPERTIES 07/09/2021 GEN 74464 WILD FLOWER PROPERTIES 07/09/2021 GEN 74465* ZEE SERVICE COMPANY 07/09/2021 GEN 74466 ZIEGLER POWER SYSTEMS 07/09/2021 GEN 74467* ZOFIA SPYRA 07/13/2021 GEN 834(E) MISO Account Dept Page 10/24 Amount SIGNAL, LUMINATION ZEDS, RED TINTED 154-000- 00 60.77 SIGNAL, LUMINATION ZEDS, GREEN TINTED, 154-000- 00 132.23 SIGNAL, LUMINATION ZEDS, GREEN TINTED, 154-000- 00 0.01 SIGNAL, LUMINATION ZEDS, GREEN TINTED, 154-000- 00 78.41 HECK GEN 74454 TOTAL FOR FUND 1: 271.42 DEP REFUND/APPLIED 235-000- 00 97.50 DEP REFUND/APPLIED 235-000- 00 42.25 GROUNDS - OUTSIDE SERVICES 401-935- 08 435.00 Cip - Residential 401-916- 07 30.00 Cip - Residential 401-916- 07 30.00 DEP REFUND/APPLIED 235-000- 00 162.50 Meters (Boxes) 107-370- 00 149.25 OVERPAYMENTS 142-000- 00 386.49 OVERPAYMENTS 142-000- 00 650.92 MISC OTHER - MATERIALS -MEDICAL SUPPLIES 401-935- 08 219.42 OIL, CAT1 NGEO ULTRA 40 154-000- 00 3,826.46 OIL, CAT1 NGEO ULTRA 40 154-000- 00 0.18 OIL, CAT1 NGEO ULTRA 40 154-000- 00 3,719.76 OIL, CAT1 NGEO ULTRA 40 154-000- 00 3,719.76 OIL, CAT1 NGEO ULTRA 40 154-000- 00 3,726.58 OIL, CAT1 NGEO ULTRA 40 154-000- 00 0.06 HECK GEN 74466 TOTAL FOR FUND 1: 14,992.80 DEP REFUND/APPLIED 235-000- 00 71.50 Deferred Energy Cost - Miso 174-000- 00 8,517.03 Deferred Energy Cost - Miso 174-000- 00 752.74 HECK GEN 834(E) TOTAL FOR FUND 1: 9,269.77 07/21/2021 12:38 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK Payee DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/19/2021 - 07/22/2021 Description Account Dept Page 11/24 Amount Fund: 1 ELECTRIC 07/15/2021 GEN 824(E) MISO SCHEDULE 26 401-565- 03 22,056.96 SCHEDULE 26A 401-565- 03 27,639.08 HECK GEN 824(E) TOTAL FOR FUND 1: 49,696.04 07/15/2021 GEN 825(E) MISO SCHEDULE 1 401-565- 03 6,548.93 SCHEUDLE 2 401-565- 03 18,742.85 SCHEDULE 26 401-565- 03 224.33 SCHEDULE 10 401-565- 03 95.37 HECK GEN 825(E) TOTAL FOR FUND 1: 25,611.48 07/16/2021 GEN 826(E) MISO SCHEDULE 10 401-565- 03 8,832.82 07/20/2021 GEN 820(E)*4 BP CANANDA ENERGY SOLUTIONS GENERATOR 41 NATURAL GAS 401-547- 01 200,695.03 GENERATOR 41 NATURAL GAS 401-547- 01 168.78 GENERATOR 43 NATURAL GAS 401-547- 01 12.98 GENERATOR 44 NATURAL GAS 401-547- 01 12.98 GENERATOR 45 NATURAL GAS 401-547- 01 23, 490. 90 GENERATOR 45 NATURAL GAS 401-547- 01 25. 97 Generator 46 Fuel Oil 401-547- 01 57,942.00 Generator 46 Fuel Oil 401-547- 01 31.65 Generator 47 Natural Gas 401-547- 01 44,815.46 Generator 47 Natural Gas 401-547- 01 31.65 Generator 49 Natural Gas 401-547- 01 81.14 Utility Expenses - Water/Waste 401-930- 08 79.53 HECK GEN 820(E) TOTAL FOR FUND 1: 327,388.07 07/20/2021 GEN 835(E) MISO Deferred Energy Cost - Miso 174-000- 00 656.18 07/21/2021 GEN 74471*4 ACE HARDWARE Sales Tax Receivable - Replace 186-000- 00 1.35 Supplies 401-550- 01 9.61 Maint Power Prod Plant - Build 402-554- 01 13.88 GENERATOR 41 MATERIAL $1.30 402-554- 01 18. 90 GENERATOR 45 MATERIAL $.04 402-554- 01 0.63 ACCESSORY PLANT - MATERIALS $.O1 402-554- 01 0.19 Maintenance Other - Materials 402-554- 01 10.68 Maintenance Other - Materials 402-554- 01 16.02 Line - Materials 401-581- 02 22.41 Line - Materials 402-594- 02 2.67 Power Equipment - Materials 402-598- 02 60.26 Power Equipment - Materials 402-598- 02 5.33 HECK GEN 74471 TOTAL FOR FUND 1: 161.93 07/21/2021 12:38 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/19/2021 - 07/22/2021 Description Fund: 1 ELECTRIC 07/21/2021 GEN 74472 AIRGAS NORTH CENTRAL 07/21/2021 GEN 74473*4 BORDER STATES ELECTRIC SUPPLY 07/21/2021 GEN 74476*4 CINTAS CORPORATION 4470 07/21/2021 GEN 74477*4 CITY OF HUTCHINSON 07/21/2021 GEN 74479*4 CREEKSIDE SOILS 07/21/2021 GEN 74480 DAVID FISHER 07/21/2021 GEN 74481 DEPARTMENT OF NATURAL RESOURCE 07/21/2021 GEN 74482 DIANE DAUER Account Dept Page 12/24 Amount AQUA -AMMONIA, 19% NH3 154-000- 00 9,082.41 AQUA -AMMONIA, 19% NH3 154-000- 00 4.71 HECK GEN 74472 TOTAL FOR FUND 1: 9,087.12 CONNECTOR, PEDESTAL, 350 MCM, 8 PLACE 154-000- 00 62.23 TAPE, DUCT, 2 X 60 YD, 3M, 43939 154-000- 00 48.35 LUBE, WIRE PULL, 1 GL JUG, POLYWATER 154-000- 00 103.63 LUBE, WIRE PULL, 1 GL JUG, POLYWATER 154-000- 00 0.01 CONDUIT, SCH 40, 2" X 10, PVC $10.572 154-000- 00 153.78 CONDUIT, SCH 40, 2" X 10, PVC $10.572 154-000- 00 0.02 Sales Tax Receivable - New 186-000- 00 4.28 Sales Tax Receivable - New 186-000- 00 10.57 Line - Materials 402-594- 02 596.94 Materials 402-574- 03 135.90 HECK GEN 74473 TOTAL FOR FUND 1: 1,115.71 Uniforms & Laundry 401-550- 01 466.15 UNIFORMS & LAUNDRY 401-588- 02 431.80 HECK GEN 74476 TOTAL FOR FUND 1: 897.95 Accounts Payable To City Of Hu 234-000- 00 323,385.75 VEHICLE/EQUIPMENT FUEL -POWER 401-550- 01 367.04 VEHICLES/EQUIPMENT FUEL-ELEC 401-588- 02 1, 846.22 IT ADMIN AND SUPPORT 75/25 401-921- 08 17,972.25 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 48.99 HECK GEN 74477 TOTAL FOR FUND 1: 357,696.81 Line - Materials 402-594- 02 6.30 Line - Materials 402-594- 02 63.59 Grounds - Materials 401-935- 08 181.05 HECK GEN 74479 TOTAL FOR FUND 1: 250.94 Cip - Residential 401-916- 07 500.00 Underground Conductor 107-367- 00 28.00 Cip - Residential 401-916- 07 30.00 07/21/2021 12:38 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/19/2021 - 07/22/2021 Description Fund: 1 ELECTRIC 07/21/2021 GEN 74484 FASTENAL COMPANY 07/21/2021 GEN 74485 FS3 INC 07/21/2021 GEN 74486*4 GOPHER STATE ONE -CALL INC 07/21/2021 GEN 744874 GREAT RIVER ENERGY 07/21/2021 GEN 74488 HDR ENGINEERING INC 07/21/2021 GEN 74489 HEARTLAND AG SYSTEMS 07/21/2021 GEN 74492*4 HUTCHINSON LEADER 07/21/2021 GEN 74493*4 HUTCHINSON WHOLESALE SUPPLY CO 07/21/2021 GEN 74494 JEFF CHRISTENSEN 07/21/2021 GEN 74495* JIM TRETTIN 07/21/2021 GEN 74496* JOHN DORIVAL 07/21/2021 GEN 74497 JOHN HENRY FOSTER 07/21/2021 GEN 74498 KATHY MAIERS 07/21/2021 GEN 74499* KEVIN OLESON 07/21/2021 GEN 74500* KIP PAULSON 07/21/2021 GEN 74501 LUBRICATION TECHNOLOGIES INC 07/21/2021 GEN 74502* LYNN REINKE Account Dept Page 13/24 Amount Line - Materials 402-594- 02 27.88 ADHESIVE, BONDUIT BULK KIT, BT-KITB6 154-000- 00 544.15 Line - Materials 401-581- 02 137.70 PURCHASED POWER 401-555- 02 834.00 TRANSMISSION EXPENSE 401-565- 03 244,530.69 HECK GEN 74487 TOTAL FOR FUND 1: 245,364.69 Outside Services 402-554- 01 1,345.61 Power Equipment - Materials 402-598- 02 36.46 Cip - Marketing 401-916- 07 234.30 Advertising/Printing 401-921- 08 166.45 Advertising/Printing 401-921- 08 104.50 HECK GEN 74492 TOTAL FOR FUND 1: 505.25 Supplies 401-550- 01 10.40 Cip - Residential 401-916- 07 200.00 Cip - Residential 401-916- 07 25.00 Cip - Residential 401-916- 07 25.00 FILTER, OIL FILTER ELEMENT, SPIN ON, 154-000- 00 880.72 Cip - Residential 401-916- 07 30.00 Cip - Residential 401-916- 07 200.00 Cip - Residential 401-916- 07 200.00 OIL, MOBIL PEGASUS 1005 154-000- 00 4,818.90 OIL, MOBIL PEGASUS 1005 154-000- 00 0.10 HECK GEN 74501 TOTAL FOR FUND 1: 4,819.00 Cip - Residential 401-916- 07 1,225.00 07/21/2021 12:38 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/19/2021 - 07/22/2021 Payee Description Account Dept Page 14/24 Amount Fund: 1 ELECTRIC 07/21/2021 GEN 74503* MARCO TECHNOLOGIES, LLC Office Supplies 401-921- 08 568.89 07/21/2021 GEN 74504 MATHESON TRI-GAS INC Generator 41 Material 402-554- 01 59.89 07/21/2021 GEN 745054 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 74505 TOTAL FOR FUND 1: 6,950.00 07/21/2021 GEN 74507* MEDICA HEALTH INSURANCE 85% ELEC 242-000- 00 51,143.85 07/21/2021 GEN 74508 MEEKER WASHED SAND AND GRAVEL, INC STATION EQUIPMENT (SWITCHGEAR, 107-362- 00 1, 884.50 07/21/2021 GEN 74510*4 NORTHERN STATES SUPPLY INC Supplies 401-550- 01 6.98 Line - Materials 401-581- 02 6.98 HECK GEN 74510 TOTAL FOR FUND 1: 13.96 07/21/2021 GEN 74511* NUVERA TELEPHONE 401-921- 08 1,971.67 07/21/2021 GEN 74512 O'REILLY AUTOMOTIVE INC Supplies 401-550- 01 30.18 Generator 41 Material 402-554- 01 37.71 ACCESSORY PLANT - MATERIALS 402-554- 01 61.18 HECK GEN 74512 TOTAL FOR FUND 1: 129.07 07/21/2021 GEN 74513*4 OXYGEN SERVICE COMPANY INC Supplies 401-550- 01 43.47 Supplies 401-550- 01 94.49 MATERIALS -NITROGEN 402-574- 03 133.25 HECK GEN 74513 TOTAL FOR FUND 1: 271.21 07/21/2021 GEN 74514 PLASTIC DIP MOLDINGS, Line - Materials 402-594- 02 50.16 07/21/2021 GEN 74515*4 PRO AUTO & TRANSMISSION REPAIR VEHICLES - MATERIAL-ELEC 402-598- 02 1, 305.85 VEHICLES - MATERIAL-ELEC 402-598- 02 45.43 HECK GEN 74515 TOTAL FOR FUND 1: 1,351.28 07/21/2021 GEN 74516* QUADIENT-LEASE LEASE/SERVICE AGREEMENTS 401-921- 08 654.30 LEASE/SERVICE AGREEMENTS 401-921- 08 304. 96 HECK GEN 74516 TOTAL FOR FUND 1: 959.26 07/21/2021 12:38 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/19/2021 - 07/22/2021 Payee Description Account Dept Page 15/24 Amount Fund: 1 ELECTRIC 07/21/2021 GEN 74517 RANDY'S BOBCAT SERVICE & TRUCKING Line - Materials 402-594- 02 142.50 07/21/2021 GEN 74518*4 RUNNING'S SUPPLY INC Power Equipment - Materials 402-598- 02 14.01 07/21/2021 GEN 74519 SCHWEITZER ENGINEERING LABS SEL-2407 satellite clock 107-362- 00 1,570.00 07/21/2021 GEN 74520 TOM MOSES Cip - Residential 401-916- 07 250.00 07/21/2021 GEN 74521*4 TWO-WAY COMMUNICATIONS INC Vehicles - Material 402-598- 02 59.42 07/21/2021 GEN 74522* VERIZON WIRELESS TELEPHONE 401-921- 08 1,301.33 07/21/2021 GEN 817(E)* MINNESOTA REVENUE City Sales Tax 242-000- 00 5,253.00 COUNTY SALES TAX 242-000- 00 5,253.00 HECK GEN 817(E) TOTAL FOR FUND 1: 10,506.00 07/22/2021 GEN 819(E) MRES Purchased Power 401-555- 02 1,101,604.94 Total for fund 1 ELECTRIC 3,607,676.63 07/21/2021 12:38 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/19/2021 - 07/22/2021 Description Fund: 2 GAS 06/21/2021 GEN 818(E)* MINNESOTA REVENUE State Sales Tax State Sales Tax City Sales Tax COUNTY SALES TAX HECK GEN 818(E) TOTAL FOR FUND 2 Account Dept Page 16/24 Amount 242-000- 00 12,339.00 242-000- 00 22,504.00 242-000- 00 1,625.00 242-000- 00 1,625.00 38,093.00 07/02/2021 GEN 822(E)* CITIZENS BANK Office Supplies 401-921- 08 94.05 07/07/2021 GEN 823(E)* INVOICE CLOUD collection - Materials 401-903- 06 1,250.53 07/09/2021 GEN 74321* AIR -PRO HEATING & COOLING LLC DEP REFUND/APPLIED 235-000- 00 182.00 07/09/2021 GEN 74323* ALEXANDER KRIPPNER DEP REFUND/APPLIED 235-000- 00 66.50 07/09/2021 GEN 74325* ANGELA MAUS DEP REFUND/APPLIED 235-000- 00 91.00 07/09/2021 GEN 74326* ANGELA PAEHLKE DEP REFUND/APPLIED 235-000- 00 131.25 07/09/2021 GEN 74327* ANGIE BLOEMKE DEP REFUND/APPLIED 235-000- 00 80.50 07/09/2021 GEN 74328* ANTHONY INGERSON OR TESSA KILKER DEP REFUND/APPLIED 235-000- 00 122.50 07/09/2021 GEN 74329 AV8 FLIGHT SCHOOL Line - Outside Services 401-856- 05 2,842.00 07/09/2021 GEN 74330* BECKY JO GETZ DEP REFUND/APPLIED 235-000- 00 112.00 07/09/2021 GEN 74331* BETSY PRICE DEP REFUND/APPLIED 235-000- 00 105.00 07/09/2021 GEN 74334*4 BORDER STATES ELECTRIC SUPPLY PLUG ,TAPERED SCREW, 1" HEX x 3-1/4", 154-000- 00 88.39 ELL, BF, 90 DEG, 3/4" IDS, 2708 154-000- 00 35.27 PIPE, 3/4" IPS, 2406 MDPE, DR 11, 500 154-000- 00 494.00 PIPE, 3/4" IPS, 2406 MDPE, DR 11, 500 154-000- 00 0.83 KIT, TEE EF, 3/4" IDS W/ COUPLING, 154-000- 00 173.65 CAP, EF 3/4", IDS, 2406 MDPE, 154-000- 00 436.04 CAP, EF 3/4", IDS, 2406 MDPE, 154-000- 00 0.01 WIRE, 410 SOLID BARE CU, WITH 45 MILS 154-000- 00 957.50 WIRE, 410 SOLID BARE CU, WITH 45 MILS 154-000- 00 0.02 CAP, 2", SMLS WELD FITTING , STD WGHT 154-000- 00 15.29 07/21/2021 12:38 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/19/2021 - 07/22/2021 Payee Description Account Dept Page 17/24 Amount Fund: 2 GAS CAP, 2", SMLS WELD FITTING , STD WGHT 154-000- 00 15.29 BATTERY, SIZE D 401-874- 04 72.36 HECK GEN 74334 TOTAL FOR FUND 2: 2,288.65 07/09/2021 GEN 74335* BRANDON CHATFIELD Cip - Residential 401-916- 07 400.00 07/09/2021 GEN 74339* CARY WRIGHT DEP REFUND/APPLIED 235-000- 00 171.50 07/09/2021 GEN 74341* CHELSEA SCHMIDT DEP REFUND/APPLIED 235-000- 00 96.25 07/09/2021 GEN 74342* CHRIS GUTORMSON DEP REFUND/APPLIED 235-000- 00 42.00 07/09/2021 GEN 74344* CINDY MATSON DEP REFUND/APPLIED 235-000- 00 45.50 07/09/2021 GEN 74345*4 CINTAS CORPORATION 4470 UNIFORMS & LAUNDRY 401-880- 04 210.84 UNIFORMS & LAUNDRY 401-880- 04 215.84 UNIFORMS & LAUNDRY 401-880- 04 210.84 HECK GEN 74345 TOTAL FOR FUND 2: 637.52 07/09/2021 GEN 74346*4 CITY OF HUTCHINSON It Admin And Support 401-921- 08 342.31 Utility Expenses - Water/Waste 401-930- 08 507.12 Utility Expenses - Water/Waste 401-930- 08 48.15 Utility Expenses - Water/Waste 401-930- 08 7.05 HECK GEN 74346 TOTAL FOR FUND 2: 904.63 07/09/2021 GEN 74350* DALE SOVICH OR ANDREA KESKE-SOVICH DEP REFUND/APPLIED 235-000- 00 80.50 07/09/2021 GEN 74353* DARREON JOHNSTON DEP REFUND/APPLIED 235-000- 00 21.00 07/09/2021 GEN 74356* DESHAWN ALLENDALE DEP REFUND/APPLIED 235-000- 00 28.00 07/09/2021 GEN 74359* ELIZABETH PAINSCHAUB DEP REFUND/APPLIED 235-000- 00 35.00 07/09/2021 GEN 74361* ERIC BELLIGAN DEP REFUND/APPLIED 235-000- 00 21.00 07/09/2021 GEN 74362* ERIN PETTY DEP REFUND/APPLIED 235-000- 00 56.00 07/21/2021 12:38 PM CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES Page 18/24 User: JMartig CHECK DATE FROM 06/19/2021 - 07/22/2021 DE: Hutchinson Utili Check Date Bank Check # Payee Description Account Dept Amount Fund: 2 GAS 07/09/2021 GEN 74363* ESEESE MAPU OR BILL GAINS DEP REFUND/APPLIED 235-000- 00 78.75 07/09/2021 GEN 74365* FIRST CHOICE FOOD & BEVERAGE BREAKROOM/RECOGNITION BANQUET 401-926- 08 28.50 07/09/2021 GEN 74368* GDM SEEDS INC DEP REFUND/APPLIED 235-000- 00 80.50 07/09/2021 GEN 74371 GREEN EARTH LAWN CARE, INC Services 107-380- 00 320.63 07/09/2021 GEN 74372* GREG ST HILAIRE OR CAROL ST DEP REFUND/APPLIED 235-000- 00 70.00 07/09/2021 GEN 74373*4 HILLYARD/HUTCHINSON Grounds - Materials 401-935- 08 34.69 Grounds - Materials 401-935- 08 241.27 Grounds - Materials 401-935- 08 92.95 HECK GEN 74373 TOTAL FOR FUND 2: 368.91 07/09/2021 GEN 74375* HUTCHFIELD SERVICES INC Grounds - Outside Services 401-935- 08 910.41 07/09/2021 GEN 74376* JACOB JORGENSEN OR KATE JORGENSEN DEP REFUND/APPLIED 235-000- 00 70.00 07/09/2021 GEN 74380* JESSICA SULLIVAN DEP REFUND/APPLIED 235-000- 00 52.50 07/09/2021 GEN 74383* JONATHAN ROBLES OR GINA ROBLES DEP REFUND/APPLIED 235-000- 00 126.00 07/09/2021 GEN 74384* JORGE SANDOVAL OR AIDEE SANDOVAL DEP REFUND/APPLIED 235-000- 00 113.75 07/09/2021 GEN 74389* JUSTIN M SPICER DEP REFUND/APPLIED 235-000- 00 42.00 07/09/2021 GEN 74392* KATIE CANNON DEP REFUND/APPLIED 235-000- 00 133.00 07/09/2021 GEN 74393* KEITH NELSON Cip - Residential 401-916- 07 50.00 07/09/2021 GEN 74394* KYLIE ROSENQUIST OR BRADLEY WOLFF DEP REFUND/APPLIED 235-000- 00 38.50 07/09/2021 GEN 74397* LISA WENDINGER DEP REFUND/APPLIED 235-000- 00 26.25 07/09/2021 GEN 74398*4 LOCATORS & SUPPLIES INC SAFETY GLASSES, GRAY, SILVER MIRROR, 401-880- 04 47.04 07/21/2021 12:38 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/19/2021 - 07/22/2021 Description Fund: 2 GAS 07/09/2021 GEN 74400* LOGAN WELTER 07/09/2021 GEN 74402* MACKENZIE REISS OR ANTHONY 07/09/2021 GEN 74403* MANUEL PEREZ JR 07/09/2021 GEN 74405* MATTHEW BERGMANN 07/09/2021 GEN 74406* MATTHEW NELSON 07/09/2021 GEN 74407* MATTHEW REINECCIUS 07/09/2021 GEN 74412* MIA FISCHER 07/09/2021 GEN 74415* MN NCPERS 07/09/2021 GEN 74416* MUDDY COW 07/09/2021 GEN 74419* NATHANIEL DRAXTEN 07/09/2021 GEN 74420* NICHOLAS FENNER 07/09/2021 GEN 74421* NICHOLAS FENNER 07/09/2021 GEN 74422* NICOLE WILER 07/09/2021 GEN 74424* NOLA BRAATEN 07/09/2021 GEN 74425*4 NORTHERN STATES SUPPLY INC 07/09/2021 GEN 74426*4 OXYGEN SERVICE COMPANY INC 07/09/2021 GEN 74427* PARKS KENDALL Account Dept Page 19/24 Amount DEP REFUND/APPLIED 235-000- 00 91.00 DEP REFUND/APPLIED 235-000- 00 140.00 DEP REFUND/APPLIED 235-000- 00 28.00 DEP REFUND/APPLIED 235-000- 00 91.00 DEP REFUND/APPLIED 235-000- 00 31.50 DEP REFUND/APPLIED 235-000- 00 24.50 DEP REFUND/APPLIED 235-000- 00 14.00 LIFE INSURANCE-PERA LIFE 242-000- 00 24.80 DEP REFUND/APPLIED 235-000- 00 2,800.00 DEP REFUND/APPLIED 235-000- 00 105.00 DEP REFUND/APPLIED 235-000- 00 31.50 DEP REFUND/APPLIED 235-000- 00 66.50 DEP REFUND/APPLIED 235-000- 00 22.75 DEP REFUND/APPLIED 235-000- 00 24.50 Materials 401-874- 04 27.44 Materials 401-874- 04 53.84 HECK GEN 74425 TOTAL FOR FUND 2: 81.28 Materials 401-874- 04 43.46 DEP REFUND/APPLIED 235-000- 00 21.00 07/21/2021 12:38 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/19/2021 - 07/22/2021 Description Account Dept Page 20/24 Amount Fund: 2 GAS 07/09/2021 GEN 74428* PATRICIA DALE DEP REFUND/APPLIED 235-000- 00 24.50 07/09/2021 GEN 74434* RENEE GHERITY OR NOLAN GHERITY DEP REFUND/APPLIED 235-000- 00 119.00 07/09/2021 GEN 74435 RICHARDS MANUFACTURING CO. METER BAR ASSEMBLY, 250, RESIDENTIAL, 154-000- 00 34, 449. 48 METER BAR ASSEMBLY, 250, RESIDENTIAL, 154-000- 00 0.17 HECK GEN 74435 TOTAL FOR FUND 2: 34,449.65 07/09/2021 GEN 74436* ROSA GARCIA DEP REFUND/APPLIED 235-000- 00 105.00 07/09/2021 GEN 74437* RYAN SKLAR DEP REFUND/APPLIED 235-000- 00 38.50 07/09/2021 GEN 74438* SAMANTHA PHILLIPS OR COLLIN DEP REFUND/APPLIED 235-000- 00 84.00 07/09/2021 GEN 74439 SARA JENSEN Cip - Residential 401-916- 07 25.00 07/09/2021 GEN 74441* SEAN CARLSON DEP REFUND/APPLIED 235-000- 00 77.00 07/09/2021 GEN 74442 SENSIT TECHNOLOGIES GAS, CALIBRATION, 2.5% BY VOL.(50oLEL) 154-000- 00 206.37 GAS, CALIBRATION, 100o BY VOL 990 154-000- 00 103.19 HECK GEN 74442 TOTAL FOR FUND 2: 309.56 07/09/2021 GEN 74444* SHRED RIGHT OFFICE SUPPLIES -SHREDDING SERVICES 401-921- 08 4.20 07/09/2021 GEN 74445* SOFIA RAMIREZ OR ASHLEY RAMIREZ DEP REFUND/APPLIED 235-000- 00 21.00 07/09/2021 GEN 74446 SOUTH CENTRAL ELECTRIC ASS'N UTILITIES (ELECTRIC, SATELLITE 401-856- 05 34.00 07/09/2021 GEN 74449* TALANDIA OR JOHN KACHELMEIER DEP REFUND/APPLIED 235-000- 00 49. 00 07/09/2021 GEN 74451* TERI FISHER DEP REFUND/APPLIED 235-000- 00 26.25 07/09/2021 GEN 74455* TYLER BAILEY DEP REFUND/APPLIED 235-000- 00 52.50 07/09/2021 GEN 74456 VERIZON WIRELESS UTILITIES (ELECTRIC, SATELLITE-SCADA 401-856- 05 117.46 07/09/2021 GEN 74457* VICKI SCHLOTTMAN DEP REFUND/APPLIED 235-000- 00 22.75 07/21/2021 12:38 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/19/2021 - 07/22/2021 Description Fund: 2 GAS 07/09/2021 GEN 74458* VIDEOTRONIX INC 07/09/2021 GEN 74461* WENDY ABDEL-AZIZ 07/09/2021 GEN 74465* ZEE SERVICE COMPANY 07/09/2021 GEN 74467* ZOFIA SPYRA 07/20/2021 GEN 820(E)*4 BP CANANDA ENERGY SOLUTIONS 07/20/2021 GEN 821(E) PUBLIC ENERGY AUTHORITY OF 07/21/2021 GEN 74471*4 ACE HARDWARE 07/21/2021 GEN 74473*4 BORDER STATES ELECTRIC SUPPLY 07/21/2021 GEN 74474 BRUCE BLOCK 07/21/2021 GEN 74475 CENTURYLINK Account Dept Page 21/24 Amount GROUNDS - OUTSIDE SERVICES 401-935- 08 435.00 DEP REFUND/APPLIED 235-000- 00 87.50 MISC OTHER - MATERIALS -MEDICAL SUPPLIES 401-935- 08 179.53 DEP REFUND/APPLIED 235-000- 00 38.50 GAS FOR RETAIL 401-807- 04 ;69,440.13) GAS FOR RETAIL 401-807- 04 730.30 HTI 401-807- 04 5,769.94 UNG 401-807- 04 145.44 3M 401-807- 04 137,993.02 BROWNTON 401-807- 04 602.48 Utility Expenses - Water/Waste 401-930- 08 1,253.68 HECK GEN 820(E) TOTAL FOR FUND 2: 77,054.73 Gas For Retail 401-807- 04 127,005.45 Contract Gas For Retail 401-807- 04 7,743.75 Contract Gas For Retail 401-807- 04 54.00 HECK GEN 821(E) TOTAL FOR FUND 2: 134,803.20 Services 107-380- 00 28.07 Materials 401-874- 04 1.60 Materials 402-892- 04 3.74 Materials 402-892- 04 2.98 Vehicles - Material 402-895- 04 29.26 Grounds - Materials 401-935- 08 48.00 HECK GEN 74471 TOTAL FOR FUND 2: 113.65 PIPE, 2", ELK STEEL, BARE, API-5L, 154-000- 00 443.68 PIPE, 2", ELK STEEL, BARE, API-5L, 154-000- 00 0.07 HECK GEN 74473 TOTAL FOR FUND 2: 443.75 Cip - Residential 401-916- 07 350.00 Utilities (Electric, Satellite 401-856- 05 60.10 07/21/2021 12:38 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/19/2021 - 07/22/2021 Payee Description Account Dept Page 22/24 Amount Fund: 2 GAS 07/21/2021 GEN 74476*4 CINTAS CORPORATION 4470 UNIFORMS & LAUNDRY 401-880- 04 318.63 07/21/2021 GEN 74477*4 CITY OF HUTCHINSON Accounts Payable To City Of Hu 234-000- 00 143,412.27 VEHICLE/EQUIPMENT FUEL -GAS 401-880- 04 2, 024.41 IT ADMIN AND SUPPORT 75/25 401-921- 08 5, 990.75 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 40.08 HECK GEN 74477 TOTAL FOR FUND 2: 156,159.70 07/21/2021 GEN 74478 CONTROL EQUIPMENT SALES Operating & Maint-Brownton 416-108- 04 120.45 07/21/2021 GEN 74479*4 CREEKSIDE SOILS Grounds - Materials 401-935- 08 148.13 07/21/2021 GEN 74483 ERIC TOPERO Cip - Residential 401-916- 07 350.00 07/21/2021 GEN 74486*4 GOPHER STATE ONE -CALL INC Materials 401-874- 04 137.70 Line - Outside Services 401-856- 05 52.65 HECK GEN 74486 TOTAL FOR FUND 2: 190.35 07/21/2021 GEN 74490 HUGHES NETWORK SYSTEMS Telephone 401-921- 08 106. 94 07/21/2021 GEN 74491 HUTCHINSON CO-OP Other Labor 401-880- 04 32.81 07/21/2021 GEN 74492*4 HUTCHINSON LEADER Cip - Marketing 401-916- 07 191.70 Advertising/Printing 401-921- 08 136.19 Advertising/Printing 401-921- 08 85.50 HECK GEN 74492 TOTAL FOR FUND 2: 413.39 07/21/2021 GEN 74493*4 HUTCHINSON WHOLESALE SUPPLY CO Materials 402-892- 04 20.39 Vehicles - Material 402-895- 04 21.45 Other Equipment - Materials 402-895- 04 371.24 HECK GEN 74493 TOTAL FOR FUND 2: 413.08 07/21/2021 GEN 74495* JIM TRETTIN Cip - Residential 401-916- 07 400.00 07/21/2021 GEN 74496* JOHN DORIVAL Cip - Residential 401-916- 07 50.00 07/21/2021 GEN 74499* KEVIN OLESON Cip - Residential 401-916- 07 350.00 07/21/2021 12:38 PM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 06/19/2021 - 07/22/2021 Description Fund: 2 GAS 07/21/2021 GEN 74500* KIP PAULSON 07/21/2021 GEN 74502* LYNN REINKE 07/21/2021 GEN 74503* MARCO TECHNOLOGIES, LLC 07/21/2021 GEN 74506 MCLEOD COOPERATVIE POWER ASSN 07/21/2021 GEN 74507* MEDICA 07/21/2021 GEN 74509 NORTHERN BORDER PIPELINE CO 07/21/2021 GEN 74510*4 NORTHERN STATES SUPPLY INC 07/21/2021 GEN 74511* NUVERA 07/21/2021 GEN 74513*4 OXYGEN SERVICE COMPANY INC Account Dept Cip - Residential 401-916- 07 Cip - Residential 401-916- 07 OFFICE SUPPLIES 401-921- 08 UTILITIES (ELECTRIC, SATELLITE-MCLEOD 401-856- 05 HEALTH INSURANCE 15% GAS 242-000- 00 LINE - OUTSIDE SERVICES -INTERCONNECT 401-856- 05 MATERIALS 401-874- 04 TELEPHONE 401-921- 08 Materials 401-874- 04 Materials 401-874- 04 HECK GEN 74513 TOTAL FOR FUND 2: 07/21/2021 GEN 74515*4 PRO AUTO & TRANSMISSION REPAIR VEHICLES - MATERIAL -GAS VEHICLES - MATERIAL -GAS HECK GEN 74515 TOTAL FOR FUND 2: 07/21/2021 GEN 74516* QUADIENT-LEASE 07/21/2021 GEN 74518*4 RUNNING'S SUPPLY INC 07/21/2021 GEN 74521*4 TWO-WAY COMMUNICATIONS INC 07/21/2021 GEN 74522* VERIZON WIRELESS 07/21/2021 GEN 817(E)* MINNESOTA REVENUE LEASE/SERVICE AGREEMENTS LEASE/SERVICE AGREEMENTS HECK GEN 74516 TOTAL FOR FUND 2: Other Equipment - Materials Vehicles - Material TELEPHONE State Sales Tax City Sales Tax COUNTY SALES TAX 402-895- 04 402-895- 04 401-921- 08 401-921- 08 402-895- 04 402-895- 04 401-921- 08 242-000- 00 242-000- 00 242-000- 00 Page 23/24 Amount 350.00 400.00 189.63 38.66 9,025.38 2,000.00 6.97 657.22 43.46 137.95 48.02 256.50 304.52 218.10 101.66 319.76 142.97 69.42 433.78 186.00 910.00 07/21/2021 12:38 PM CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES Page 24/24 User: JMartig CHECK DATE FROM 06/19/2021 - 07/22/2021 DE: Hutchinson Utili Check Date Bank Check # Payee Description Account Dept Amount Fund: 2 GAS HECK GEN 817(E) TOTAL FOR FUND 2: 2,006.00 Total for fund 2 GAS 478,456.48 TOTAL - ALL FUNDS 4,086,133.11 --INDICATES CHECK DISTRIBUTED TO MORE THAN ONE FUND '#'-INDICATES CHECK DISTRIBUTED TO MORE THAN ONE DEPARTMENT HUTCHINSON UTILITIES COMMISSION COMBINED DIVISIONS FINANCIAL REPORT FOR JUNE, 2021 2021 2020 pi . Combined Division Customer Revenue $ 2,759,340 $ 2,501,996 $ 257,343 Sales for Resale $ 591,916 $ 265,551 $ 326,365 NU Transportation $ 83,322 $ 82,789 $ 533 Electric Division Transfer $ 56,879 $ 55,440 $ 1,439 Other Revenues $ 21,954 $ 357,977 $ (336,023) Interest Income $ 32,699 $ 31,656 $ 1,043 TOTAL REVENUES $ 3,546,110 $ 3,295,408 $ 250,702 Salaries & Benefits $ 549,159 $ 579,727 $ (30,568) Purchased Commodities $ 1,530,911 $ 1,448,908 $ 82,004 Transmission $ 326,583 $ 227,762 $ 98,821 Generator Fuel/Chem. $ 361,275 $ 58,242 $ 303,033 Depreciation $ 366,238 $ 320,371 $ 45,867 Transfers (Elect./City) $ 212,479 $ 211,040 $ 1,439 Operating Expense $ 133,076 $ 159,779 $ (26,704) Debt Interest $ 83,542 $ 89,542 $ (6,000) TOTAL EXPENSES $ 3,563,262 $ 3,095,370 $ 467,892 NET PROFIT/(LOSS) $ (17,153) $ 200,038 $ (217,191) %Chng 1 2021 2020 Di %Chng I Full YrBud %of Bud 10.3% $ 20,584,325 $ 16,862,241 $ 3,722,083 22.1% $ 35,545,920 57.9% 122.9% $ 2,037,248 $ 1,035,205 $ 1,002,043 96.8% $ 3,360,000 60.6% 0.6% $ 502,981 $ 496,840 $ 6,140 1.2% $ 998,904 50.4% 2.6% $ 341,275 $ 332,642 $ 8,633 2.6% $ 682,550 50.0% (93.9%) $ 216,230 $ 632,061 $ (415,831) (65.8%) $ 355,204 60.9% 3.3% $ 205,927 $ 251,717 $ (45,790) (18.2%) $ 383,456 53.7% 7.6% $ 23,887,985 $ 19,610,706 $ 4,277,279 21.8% $ 41,326,034 57.8% (5.27%) $ 3,327,672 $ 3,293,766 $ 33,906 1.0% $ 7,076,247 47.0% 5.7% $ 13,537,818 $ 9,447,859 $ 4,089,959 43.3% $ 18,426,340 73.5% 43.4% $ 1,432,841 $ 1,007,600 $ 425,241 42.2% $ 3,200,000 44.8% 520.3% $ 633,806 $ 123,075 $ 510,731 415.0% $ 699,492 90.6% 14.3% $ 2,200,581 $ 1,953,653 $ 246,929 12.6% $ 4,100,000 53.7% 0.7% $ 1,274,871 $ 1,266,240 $ 8,630 0.7% $ 2,549,742 50.0% (16.7%) $ 1,092,815 $ 1,116,213 $ (23,399) (2.1%) $ 2,941,142 37.2% (6.7%) $ 501,253 $ 537,253 $ (36,000) 6.7% $ 990,507 50.6% 15.1% $ 24,001,657 $ 18,745,660 $ 5,255,997 28.0% $ 39,983,470 60.0% (108.6%) $ (113,672) $ 865,046 $ (978,717) (113.1%) $ 1,342,564 (8.5%) June June YTD YTD 2021 HUC 2021 2020 Change 2021 2020 Change Budget Target Gross Margin % 26.5% 28.8% -2.3% 25.0% 33.4% -8.4% 35.3% 26%-28% Operating Income Per Revenue $ (%) 0.4% -3.4% 3.8% -0.1% 3.0% -3.1% 4.3% 1%-4% Net Income Per Revenue $ (%): -0.5% 6.1% -6.6% -0.5% 4.4% -4.9% 3.2% 0%-1% Accounts past due by 30 days has increased during the time of no disconnects. Here is where we are at now compared to one year ago March 2020: $59,428 March 2021: $137,298 June 2020: $94,209 June 2021: $208,197 HUTCHINSON UTILITIES COMMISSION ELECTRIC DIVISION FINANCIAL REPORT FOR JUNE, 2021 2021 2020 Di . Electric Division Customer Revenue $ 2,305,472 $ 2,124,144 $ 181,328 Sales for Resale $ 591,916 $ 265,551 $ 326,365 Other Revenues $ 2,238 $ 264,034 $ (261,796) Interest Income $ 17,743 $ 17,222 $ 522 TOTAL REVENUES $ 2,917,370 $ 2,670,951 $ 246,419 % Chna 2021 2020 Di . 8.5% $ 12,119,878 $ 11,364,732 $ 755,146 122.9% $ 2,037,248 $ 1,035,205 $ 1,002,043 (99.2%) $ 81,000 $ 437,738 $ (356,738) 3.0% $ 111,257 $ 134,223 $ (22,966) 9.2%1 $ 14,349,383 $ 12,971,898 $ 1,377,486 % Chno 50% of Year Full Yr Bud $ 25,441,420 Comp. % of Bud 47.6% 6.6% 96.8% $ 3,360,000 60.6% (81.59/c) $ 99799 81.2% (17.1%) $ 208:456 53.4% 10.6%1 $ 29,109,675 49.3% Salaries & Benefits $ 410,475 $ 432,818 $ (22,343) (5.2%) $ 2,474,586 $ 2,459,563 $ 15,024 0.6% $ 5,175,775 47.8% Purchased Power $ 1,299,366 $ 1,250,842 $ 48,524 3.9% $ 6,631,712 $ 6,343,186 $ 288,526 4.5% $ 12,888,000 51.5% Transmission $ 326,583 $ 227,762 $ 98,821 43.4% $ 1,432,841 $ 1,007,600 $ 425,241 42.2% $ 3,200,000 44.8% Generator Fuel/Chem. $ 361,275 $ 58,242 $ 303,033 520.3% $ 633,806 $ 123,075 $ 510,731 415.0% $ 699,492 90.6% Depreciation $ 275,417 $ 229,358 $ 46,059 20.1% $ 1,655,601 $ 1,426,362 $ 229,239 16.1% $ 3,000,000 55.2% Transfers (Elect./City) $ 164,674 $ 163,236 $ 1,439 0.9% $ 988,046 $ 979,413 $ 8,633 0.9% $ 1,976,093 50.0% Operating Expense $ 104,085 $ 103,109 $ 976 0.9% $ 747,245 $ 695,411 $ 51,833 7.5% $ 1,900,106 39.3% Debt Interest $ 43,321 $ 44,471 $ (1,150) (2.6%) $ 259,928 $ 266,828 $ (6,900) Lj.6% $ 507,857 51.2% TOTAL EXPENSES $ 2,985,196 $ 2,509,837 $ 475,359 18.9% $ 14,823,765 $ 13,301,438 $ 1,522,328 11.4% $ 29,347,323 50.5% NET PROFIT/(LOSS) $ (67,826) $ 161,114 $ (228,940) (142.1%) j $ (474,382) $ (329,540) $ (144,842) 44.0% $ (237,648) 199.6% 2021 2020 Di . %Chna 2021 2020 Di . %Chna Full YrBud %of Bud Electric Division Residential 6,048,035 5,434,335 613,700 11.29% 25,683,985 24,927,651 756,334 3.03% 53,519,179 48.0% All Electric 180,617 164,298 16,319 9.93% 1,405,133 1,395,295 9,838 0.71% 2,646,623 53.1% Small General 1,767,132 1,615,672 151,460 9.37% 8,915,624 8,659,330 256,294 2.96% 19,052,314 46.8% Large General 7,763,500 7,084,770 678,730 9.58% 41,169,260 37,350,750 3,818,510 10.22% 81,184,946 50.7% Industrial 11,045,000 10,053,000 992,000 9.87% 58,399,000 57,065,000 1,334,000 2.34% 124,696,169 46.8% Total KWH Sold 26,804,284 24,352,075 2,452,209 10.07%1 135,573,002 129,398,026 6,174,976 4.77%1 281,099,231 48.2% June June YTD YTD 2021 HUC 2021 2020 Change 2021 2020 Change Budget Target Gross Margin % 20.0% 22.6% -2.6% 25.3% 25.5% -0.2% 29.0% Operating Income Per Revenue $ (%) -1.5% -3.1% 1.6% -2.8% -4.8% 2.0% 0.2% 0%-5% Net Income Per Revenue $ (%): -2.3% 6.0% -8.4% -3.3% -2.5% -0.8% -0.8% 0%-5% Customer Revenue per KWH: $0.0847 $0.0858 -$0.0010 $0.0889 $0.0873 $0.0016 $0.0900 $0.0900 Total Power Supply Exp. per KWH: $0.0865 $0.0760 $0.0105 $0.0781 $0.0716 $0.0064 $0.0730 $0.0730 Net Income decreased by $228,940 due mostly to an increase in Expenses and a drop in Other Revenues. The other revenues received in 2020 were from the transformer fire insurance proceeds. Customer Revenue and usage were up due to an almost 50% increase in cooling degree days. Expenses such as transmission, purchased power, and fuels that are associated with increased usage were also up. Sales for Resale of $591,916 consisted of $347,666 in market sales, $98,000 in capacity sales to Rice Lake and $146,250 in capacity sales to AEP. 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. June 2019 Sales for Resale of $218,270 consisted of $6,578 in market sales, $36,400 in Transalta tolling fees, $25,792 in Transalta energy sales, $136,000 in capacity sales to SMMPA, and $13,500 in capacity sales to AEP. Overall Purchased Power increased by $48,524. MRES purchases decreased by $43,851 and market purchases/MISO costs increased by $92,375. There was no Power Cost Adjustment for June 2021 leaving the total at $674,248 YTD. Last year's power cost adjustment for June 2020 was also zero for the month with $249,141 YTD. This may be the final month of zero power cost adjustments as $107,583 was taken from the Rate Stabilization Fund causing it to fall below the threshold for charging customers. HUTCHINSON UTILITIES COMMISSION GAS DIVISION FINANCIAL REPORT FOR JUNE, 2021 2021 2020 Di %Chna 2021 2020 Di %Chna Full YrBud %of Bud Gas Division Customer Revenue $ 453,867 $ 377,852 $ 76,016 20.1% $ 8,464,447 $ 5,497,509 $ 2,966,938 54.0% $ 10,104,500 83.8% Transportation $ 83,322 $ 82,789 $ 533 0.6% $ 502,981 $ 496,840 $ 6,140 1.2% $ 998,904 50.4% Electric Div. Transfer $ 56,879 $ 55,440 $ 1,439 2.6% $ 341,275 $ 332,642 $ 8,633 2.6% $ 682,550 50.0% Other Revenues $ 19,716 $ 93,943 $ (74,227) (79.0%) $ 135,229 $ 194,323 $ (59,093) (30.4%) $ 255,405 52.9% Interest Income $ 14,955 $ 14,434 $ 522 3.6% $ 94,670 $ 117,494 $ (22,824) (19.4%) $ 175,000 54.1% TOTAL REVENUES $ 628,740 $ 624,457 $ 4,282 0.7% $ 9,538,602 $ 6,638,808 $ 2,899,794 43.7% $ 12,216,359 78.1% Salaries & Benefits $ 138,685 $ 146,909 $ (8,225) (5.6%) $ 853,085 $ 834,203 $ 18,882 2.3% $ 1,900,472 44.9% Purchased Gas $ 231,545 $ 198,066 $ 33,479 16.9% $ 6,906,107 $ 3,104,674 $ 3,801,433 122.4% $ 5,538,340 124.7% Operating Expense $ 28,991 $ 56,670 $ (27,680) (48.8%) $ 345,570 $ 420,802 $ (75,232) (17.9%) $ 1,041,036 33.2% Depreciation $ 90,821 $ 91,013 $ (192) (0.2%) $ 544,980 $ 527,291 $ 17,690 3.4% $ 1,100,000 49.5% Transfers (City) $ 47,804 $ 47,804 $ - 0.0% $ 286,824 $ 286,827 $ (3) (0.0%) $ 573,649 50.0% Debt Interest $ 40,221 $ 45,071 $ (4,850) 0.0% $ 241,325 $ 270,425 $ (29,100) 10.8% $ 482,650 50.0% TOTAL EXPENSES $ 578,066 $ 585,533 $ (7,467) (1.3%) $ 9,177,892 $ 5,444,222 $ 3,733,669 68.6% $ 10,636,147 86.3% NIETPROFIT/(LyyOSS) $ 50,674 $ 38,924 $ 11,749 30.2% $ 1,580,212 22.8% $ 360,710 $ 1,194,586 $ (8p33,876) (69.8%) ppyy�pp 50% of Year Camp', 2021 2020 Di %Chng 2021 2020 Di %Chng Full YrBud %ofBud Gas Division Residential 6,524,004 6,798,626 (274,622) (4.04%) 241,019,843 245,603,400 (4,583,557) (1.87%) 429,017,000 56.2% Commercial 7,500,172 7,657,105 (156,933) (2.05%) 181,779,784 182,169,034 (389,250) (0.21%) 336,067,000 54.1% Industrial 51,605,073 47,342,246 4,262,827 9.00% 456,265,277 472,611,802 (16,346,525) (3.46%) 781,920,000 58.4% Total CF Sold 65,629,249 61,797,977 3,831,272 6.20% 879,064,904 900,384,236 (21,319,332) (2.37%)l 1,547,004,000 56.8% June June YTD YTD 2021 HUC 2021 2020 Change 2021 2020 Change Budget Target Gross Margin % 58.3% 57.7% 0.6% 24.6% 49.1% -24.5% 50.5% Operating Income Per Revenue $ (%) 9.5% -4.7% 14.2% 4.0% 18.4% -14.4% 14.1% Net Income Per Revenue $ (%): 8.5% 7.5% 1.0% 3.9% 18.9% -15.0% 13.4% Contracted Customer Rev. per CF: $0.0041 $0.0035 $0.0006 $0.0073 $0.0036 $0.0037 $0.0040 Customer Revenue per CF: $0.0157 $0.0124 $0.0033 $0.0119 $0.0085 $0.0034 $0.0088 Total Power Supply Exp. per CF: $0.0038 $0.0035 $0.0002 $0.0080 $0.0036 $0.0044 $0.0038 June 2021 net income increased by $11,749 due mainly to decreased expenses and increased Customer Revenue. The large decrease in Other Revenues was from a large customer service connection installed in 2020. June 2021 fuel cost adjustment was $.91 per MCF which brought in $14,608 for the month with a total of $1,083,635 YTD. June 2020 credits totalled $16,884 for the month and $460,188 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, 2021 Electric Gas Total Division Division 2021 Total Net Change 2020 Total (YTD) 7,048,092.40 11,042,960.83 18,091,053.23 16,541,670.67 1,549,382.56 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 - 364,336.05 - 364,336.05 372,736.68 (8,400.63) - 373,639.52 373,639.52 538,223.27 (164,583.75) 800,000.00 200,000.00 1,000,000.00 500,000.00 500,000.00 1,389,999.52 - 1,389,999.52 1,287,549.49 102,450.03 - 1,194,462.50 1,194,462.50 1,164,245.84 30,216.66 522,335.64 2,188,694.02 2,711,029.66 2,711,029.66 - 14,168,986.61 16,273,575.87 30,442,562.48 28,433,497.61 2,009,064.87 2,574,364.39 681,562.06 3,255,926.45 2,873,190.66 382,735.79 48,992.65 48,992.65 97,985.30 115,964.64 (17,979.34) 2,623,357.04 730,554.71 3,353,911.75 2,989,155.30 364,756.45 1,540,607.52 495,583.93 2,036,191.45 1,928,010.82 108,180.63 446,351.59 21,323.06 467,674.65 208,599.63 259,075.02 115,074.72 - 115,074.72 106,727.52 8,347.20 313,166.00 - 313,166.00 219,249.00 93,917.00 - 104,390.00 104,390.00 73,083.00 31,307.00 2,415,199.83 621,296.99 3,036,496.82 2,535,669.97 500,826.85 19,207,543.48 17,625,427.57 36,832,971.05 33,958,322.88 2,874,648.17 690,368.40 3,899,918.60 4,590,287.00 4,590,287.00 - 108,014,738.78 42,490,114.65 150,504,853.43 133,978,155.35 16,526,698.08 (62,193,765.00) (18,770,313.30) (80,964,078.30) (77,673,088.47) (3,290,989.83) 1,872,610.72 125,427.00 1,998,037.72 16,270,485.32 (14,272,447.60) 48,383,952.90 27,745,146.95 76,129,099.85 77,165,839.20 (1,036,739.35) 67,591,496.38 45,370,574.52 112,962,070.90 111,124,162.08 1,837,908.82 Current Liabilities Current Portion of Long-term Debt Bonds Payable Bond Premium Accounts Payable Accrued Expenses Accrued Interest Accrued Payroll Total Current Liabilities Long -Term Liabilities Noncurrent Portion of Long-term Debt 2017 Bonds 2012 Bonds Bond Premium 2012 Pension Liability- Electric Pension Liability - Electric OPEB Pension Liability - Nat Gas Pension Liability - Nat Gas OPEB Accrued Vacation Payable Accrued Severance Deferred Outflows - Electric Deferred Outflows - Nat Gas Total Long -Term Liabilities Net Position Retained Earnings Total Net Position HUTCHINSON UTILITIES COMMISSION BALANCE SHEET - CONSOLIDATED JUNE 30, 2021 Electric Gas Total Division Division 2021 675,000.00 2,890,671.56 302,249.31 102,498.74 3,970,419.61 14,730,000.00 549,251.76 3,026,207.00 84,054.00 426,032.31 92,360.61 123,417.00 19,031,322.68 1,565,000.00 185,608.32 577,013.74 281,545.83 35,242.56 2,644,410.45 9,510,000.00 819,769.71 1,008,736.00 28,018.00 158,832.06 32,026.46 41,139.00 11,598,521.23 2,240,000.00 185,608.32 3,467,685.30 583,795.14 137,741.30 6,614,830.06 14,730,000.00 9,510,000.00 1,369,021.47 3,026,207.00 84,054.00 1,008,736.00 28,018.00 584,864.37 124,387.07 123,417.00 41,139.00 30,629,843.91 Total 2020 2,100,000.00 185,608.32 3,164,786.78 89,542.20 120,870.22 5,660,807.52 15,405,000.00 11,075,000.00 1,588,086.75 2,686,985.00 76,502.00 895,662.00 25,501.00 526,336.29 115,100.18 550,772.00 183,591.00 33,128,536.22 Net Change Total (YTD) 140,000.00 302,898.52 494,252.94 16,871.08 954,022.54 (675,000.00) (1,565,000.00) (219,065.28) 339,222.00 7,552.00 113,074.00 2,517.00 58,528.08 9,286.89 (427,355.00) (142,452.00) (2,498,692.31) 44,589,754.09 31,127,642.84 75,717,396.93 72,334,818.34 3,382,578.59 44,589,754.09 31,127,642.84 75,717,396.93 72,334,818.34 3,382,578.59 Total Liabilities and Net Position 67,591,496.38 45,370,574.52 112,962,070.90 111,124,162.08 1,837,908.82 Hutchinson Utilities Commission Cash -Designations Report, Combined 6/30/2021 Change in Financial Annual Balance, Balance, Cash/Reserve Institution Current Interest Rate Interest June 2021 May 2021 Position Savings, Checking, Investments varies varies Total Operating Funds Debt Reserve Requirements Bond Covenants - sinking fund Debt Reserve Requirements Bond Covenants -1 year Max. P & I Total Restricted Funds varies 30,442,562.48 29,939,976.06 502,586.42 30,442,562.48 29,939,976.06 502,586.42 2,584,462.02 2,315,253.16 269,208.86 2,711,029.66 2,711,029.66 - 5,295,491.68 5,026,282.82 269,208.86 Operating Reserve Min 60 days of 2021 Operating Bud. 5,965,162.00 5,965,162.00 Rate Stabalization Funds 737,975.57 827,556.68 (89,581.11) PILOT Funds Charter (Formula Only) 1,867,192.00 1,867,192.00 Catastrophic Funds Risk Mitigation Amount 1,000,000.00 1,000,000.00 Capital Reserves 5 Year CIP ( 2021-2025 Fleet & Infrastructure Maintenance) 3,450,000.00 3,450,000.00 Total Designated Funds 13,020,329.57 13,109,910.68 (89,581.11) YE YE YE YE YTD 2017 2018 2019 2020 2021 Debt to Asset 40.2% 37.7% 34.9% 32.3% 33.0% Current Ratio 3.36 3.93 5.11 5.67 4.70 RONA 1.82% 3.16% 2.25% 3.62% -0.11% HUC Target >0% Change in Cash Balance (From 12131114 to 613012021) Month End Electric Elec. Change Natural Gas Gas Change Total Total Change 6/30/2021 14,168,987 16, 273, 576 30,442, 562 12/31/2020 14,239,233 (70,247) 15,019,173 1,254,403 29,258,406 1,184,157 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 Signifcant increase in cash balance is due to issuing bonds for the generator project. Hutchinson Utilities Commission Cash -Designations Report, Electric 6/30/2021 Change in Financial Annual Balance, Balance, Cash/Reserve Institution Current Interest Rate Interest June 2021 May 2021 Position Savings, Checking, Investments varies varies varies 30,442,562.48 29,939,976.06 502,586.42 Total HUC Operating Funds 30,442,562.48 29,939,976.06 502,586.42 Debt Restricted Requirements Debt Restricted Requirements Total Restricted Funds Bond Covenants - sinking fund Bond Covenants -1 year Max. P & 1 1,389,999.52 522,335.64 1,912,335.16 1,291,428.16 522,335.64 1,813,763.80 98,571.36 - 98,571.36 Excess Reserves Less Restrictions, Electric 12,256,651.45 0: e Operating Reserve Min 60 days of 2021 Operating Bud. 4,379,554.00 4,379,554.00 - Rate Stabalization Funds $400K-$1.2K 364,336.05 471,919.06 (107,583.01) 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 ( 2021-2025 Fleet & Infrastructure Maintenance) 2,750,000.00 2,750,000.00 Total Designated Funds 9,587,433.05 9,695,016.06 (107,583.01) Excess Reserves Less Restrictions & Designations, Electric 2,669,218.40 2,413,172.16 256,046.24 YE YE YE YE YTD APPA Ratio HUC 2017 2018 2019 2020 2021 SK-10K Cust. Target Debt to Asset Ratio (* w/Gen.) 35.4% 35.7% 34.1% 32.6% 34.0% 50.1% Current Ratio 4.36 3.63 5.26 6.18 4.28 2.43 RONA -0.6% -0.3% -0.4% 2.5% -0.8% NA >0% Hutchinson Utilities Commission Cash -Designations Report, Gas 6/30/2021 Change in Financial Annual Balance, Balance, Cash/Reserve Institution Current Interest Rate Interest June 2021 May 2021 Position Savings, Checking, Investments varies varies Total HUC Operating Funds Debt Restricted Requirements Bond Covenants - sinking fund Debt Restricted Requirements Bond Covenants -1 year Max. P & I Total Restricted Funds Operating Reserve Rate Stabalization Funds PILOT Funds Catastrophic Funds Capital Reserves Total Designated Funds varies 30,442,562.48 29,939,976.06 502,586.42 30,442,562.48 29,939,976.06 502,586.42 Min 60 days of 2021 Operating Bud. $200K-$600K Charter (Formula Only) Risk Mitigation Amount 5 Year CIP ( 2021-2025 Fleet & Infrastructure Maintenance) 1,194,462.50 1,023,825.00 170, 637.50 2,188,694.02 2,188,694.02 - 3,383,156.52 3,212,519.02 170,637.50 1,585,608.00 1,585,608.00 - 373,639.52 355,637.62 18,001.90 573,649.00 573,649.00 - 200,000.00 200,000.00 700,000.00 700,000.00 - 3,432,896.52 3,414,894.62 18,001.90 YE YE YE YE YTD HUC 2017 2018 2019 2020 2021 APGA Ratio Target Debt to Asset 47.6% 40.7% 36.1% 32.0% 31.4% TBD Current Ratio 2.74 4.33 4.96 5.18 5.35 TBD RONA 5.0% 8.3% 6.4% 5.3% 0.9% TBD HUTCHINSON UTILITIES COMMISSION Investment Report For the Month Ended June 30, 2021 Interest Current Date of Date of Par Current Purchase Unrealized Premium Next Institution Description Rate YTM Purchase Maturity Value Value Amount Gaird(Loss) (Discount) Call Date Wells Fargo Money Market 0.010% 0.010% NA NA - 1,454.44 - - - N/A Wells Fargo FHLMC 0.320% 0.320% 07/20/2020 10/20/2022 305,000.00 305,000.00 305,000.00 - 07/20/2021 Wells Fargo FHLB 0.300% 0.525% 02/09/2021 02/09/2026 470,000.00 466,949.70 470,000.00 (3,050.30) - 08/09/2021 Wells Fargo FHLB 0.300% 0.587% 01/29/2021 01/29/2026 295,000.00 292,822.90 295,000.00 (2,177.10) - 07/29/2021 Wells Fargo FHLB 0.300% 1.432% 04/29/2021 04/29/2026 400,000.00 399,588.00 400,000.00 (412.00) - 10/29/2021 Wells Fargo FHLB 0.650% 1.069% 06/30/2021 06/30/2026 300,000.00 299,529.00 300,000.00 (471.00) - 09/30/2021 Wells Fargo CD's 1.700% 1.700% 02/21/2020 02/22/2022 245,000.00 247,609.25 245,000.00 2,609.25 - N/A Wells Fargo CD's 1.300% 1.300% 03/31/2020 09/30/2021 245,000.00 245,781.55 245,000.00 781.55 - N/A Wells Fargo CD's 1.900% 1.900% 08/21/2019 08/23/2021 174,000.00 174,481.98 174,000.00 481.98 - N/A Wells Fargo CD's 0.450% 0.450% 04/14/2021 04/15/2024 245,000.00 245,120.05 245,000.00 120.05 - 08/14/2021 Wells Fargo CD's 1.000% 1.207% 07/31/2021 07/13/2028 245,000.00 245,000.00 245,000.00 - - 10/13/2021 Wells Fargo CD's 0.500% 0.698% 07/30/2020 07/30/2025 245,000.00 245,071.05 245,000.00 71.05 - 07/30/2021 Wells Fargo CD's 0.300% 0.300% 01/08/2021 01/08/2024 245,000.00 245,066.15 245,000.00 66.15 - 08/08/2021 Wells Fargo CD's 2.000% 2.000% 08/29/2020 08/22/2022 200,000.00 203,554.00 200,000.00 3,554.00 - 09/29/2021 Wells Fargo CD's 1.000% 1.000% 05/19/2021 05/19/2026 245,000.00 247,021.25 245,000.00 2,021.25 - N/A Wells Fargo CD's 1.750% 1.750% 01/29/2020 07/29/2021 245,000.00 245,333.20 245,000.00 333.20 N/A Broker Total 29.5% 4,104,000.00 4,109,382.52 4,104,000.00 3,928.08 - Cetera Investment Services Money Market 0.010% 0.010% N/A N/A - 2,973.83 - - - N/A Cetera Investment Services Municipal Bonds 3.139% 2.190% 12/11/2017 09/01/2021 300,000.00 301,311.00 310,116.00 (8,805.00) 10,116.00 N/A Cetera Investment Services Municipal Bonds 2.875% 2.121% 04/29/2016 09/01/2021 250,000.00 251,110.00 259,467.50 (8,357.50) 9,467.50 N/A Cetera Investment Services Municipal Bonds 3.751% 2.399% 04/29/2016 11/01/2021 250,000.00 252,935.00 267,330.00 (14,395.00) 17,330.00 N/A Cetera Investment Services Municipal Bonds 3.436% 3.436% 12/20/2018 12/15/2021 50,000.00 49,848.50 45,155.00 4,693.50 (4,845.00) N/A Cetera Investment Services Municipal Bonds 2.655% 2.208% 12/11/2017 03/01/2022 300,000.00 304,707.00 305,314.92 (607.92) 5,314.92 N/A Cetera Investment Services Municipal Bonds 3.000% 3.118% 12/20/2018 08/01/2022 50,000.00 51,156.00 50,377.67 778.33 377.67 N/A Cetera Investment Services Municipal Bonds 3.633% 3.116% 12/20/2018 09/01/2022 250,000.00 259,660.00 257,217.48 2,442.52 7,217.48 N/A Cetera Investment Services Municipal Bonds 3.650% 3.004% 12/20/2018 02/01/2023 250,000.00 258,005.00 256,165.00 1,840.00 6,165.00 N/A Cetera Investment Services Municipal Bonds 3.240% 3.240% 11/17/2017 02/15/2023 80,000.00 79,512.00 69,633.48 9,878.52 (10,366.52) N/A Cetera Investment Services Municipal Bonds 3.075% 3.236% 12/20/2018 06/01/2023 50,000.00 52,305.00 49,746.15 2,558.85 (253.85) N/A Cetera Investment Services Municipal Bonds 5.290% 2.724% 04/18/2019 06/01/2023 260,000.00 282,713.60 291,059.96 (8,346.36) 31,059.96 N/A Cetera Investment Services Municipal Bonds 2.500% 3.181% 12/20/2018 08/01/2023 35,000.00 36,134.00 34,320.05 1,813.95 (679.95) N/A Cetera Investment Services Municipal Bonds 3.400% 3.148% 12/20/2018 11/01/2023 125,000.00 132,998.75 126,376.25 6,622.50 1,376.25 N/A Cetera Investment Services Municipal Bonds 3.400% 3.148% 12/20/2018 11/01/2023 65,000.00 69,159.35 65,715.65 3,443.70 715.65 N/A Cetera Investment Services Municipal Bonds 2.854% 3.173% 12/20/2018 02/01/2024 100,000.00 105,828.00 99,605.96 6,222.04 (394.04) N/A Cetera Investment Services Municipal Bonds 2.977% 3.246% 12/20/2018 03/15/2024 250,000.00 266,097.50 248,743.99 17,353.51 (1,256.01) N/A Cetera Investment Services Municipal Bonds 1.940% 1.821% 01/13/2020 05/01/2024 65,000.00 67,235.35 65,570.70 1,664.65 570.70 N/A Cetera Investment Services Municipal Bonds 5.742% 3.658% 04/11/2019 08/01/2024 355,000.00 385,242.45 464,344.41 (79,101.96) 109,344.41 N/A Cetera Investment Services Municipal Bonds 2.528% 1.918% 01/13/2020 12/01/2024 100,000.00 104,878.00 102,999.53 1,878.47 2,999.53 N/A Cetera Investment Services Municipal Bonds 3.922% 3.429% 12/20/2018 12/01/2024 204,000.00 224,036.88 208,181.10 15,855.78 4,181.10 N/A Cetera Investment Services Municipal Bonds 4.400% 3.221% 04/11/2019 07/01/2025 500,000.00 517,555.00 539,101.11 (21,546.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 193,009.55 169,737.95 23,271.60 (35,262.05) N/A Cetera Investment Services Municipal Bonds 3.743% 2.740% 04/18/2019 09/15/2025 215,000.00 239,813.15 228,334.53 11,478.62 13,334.53 N/A Cetera Investment Services Municipal Bonds 3.379% 1.934% 08/19/2019 10/01/2025 310,000.00 337,825.60 339,739.18 (1,913.58) 29,739.18 N/A Cetera Investment Services Municipal Bonds 5.600% 1.186% 07/28/2020 12/01/2025 45,000.00 54,264.60 55,250.55 (985.95) 10,250.55 N/A Cetera Investment Services Municipal Bonds 4.250% 3.258% 04/11/2019 01/01/2026 500,000.00 560,600.00 529,769.03 30,830.97 29,769.03 N/A Cetera Investment Services Municipal Bonds 2.420% 1.175% 10/06/2020 03/01/2026 100,000.00 105,290.00 106,734.28 (1,444.28) 6,734.28 N/A Cetera Investment Services Municipal Bonds 1.609% 1.124% 09/24/2020 04/01/2026 285,000.00 287,781.60 292,370.10 (4,588.50) 7,370.10 N/A Cetera Investment Services Municipal Bonds 6.690% 3.356% 04/18/2019 04/15/2026 60,000.00 54,954.00 47,545.20 7,408.80 (12,454.80) N/A Cetera Investment Services Municipal Bonds 5.900% 1.451% 07/28/2020 06/15/2026 75,000.00 89,362.50 93,741.75 (4,379.25) 18,741.75 N/A Cetera Investment Services Municipal Bonds 0.000% 1.415% 08/13/2020 07/01/2026 100,000.00 91,005.00 92,037.00 (1,032.00) (7,963.00) N/A Cetera Investment Services Municipal Bonds 3.250% 2.903% 04/18/2019 08/01/2026 500,000.00 543,620.00 514,790.69 28,829.31 14,790.69 N/A Cetera Investment Services Municipal Bonds 2.150% 2.203% 07/01/2019 12/01/2026 40,000.00 40,690.00 40,150.64 539.36 150.64 N/A Cetera Investment Services Municipal Bonds 1.664% 1.150% 08/27/2020 09/01/2026 225,000.00 229,320.00 231,696.00 (2,376.00) 6,696.00 N/A Cetera Investment Services Municipal Bonds 2.375% 1.816% 09/04/2019 12/01/2026 90,000.00 95,592.60 93,395.70 2,196.90 3,395.70 N/A Cetera Investment Services Municipal Bonds 2.350% 2.191% 07/01/2019 12/01/2026 500,000.00 516,570.00 505,385.00 11,185.00 5,385.00 N/A Cetera Investment Services Municipal Bonds 3.000% 1.991% 08/19/2019 02/01/2027 50,000.00 53,727.00 53,551.00 176.00 3,551.00 N/A Cetera Investment Services Municipal Bonds 3.150% 2.034% 08/19/2019 03/15/2027 100,000.00 109,846.00 109,138.50 707.50 9,138.50 N/A Cetera Investment Services Municipal Bonds 3.332% 3.120% 04/18/2019 04/15/2027 500,000.00 555,990.00 507,783.94 48,206.06 7,783.94 N/A Cetera Investment Services Municipal Bonds 3.865% 2.470% 08/19/2019 05/01/2027 55,000.00 60,847.60 60,986.48 (138.88) 5,986.48 05/01/2025 Cetera Investment Services Municipal Bonds 3.553% 2.289% 08/19/2019 05/01/2027 55,000.00 59,935.15 60,468.04 (532.89) 5,468.04 05/01/2026 Cetera Investment Services Municipal Bonds 3.230% 1.828% 08/19/2019 05/15/2027 145,000.00 160,501.95 160,827.31 (325.36) 15,827.31 N/A Cetera Investment Services Municipal Bonds 1.861% 1.254% 06/07/2021 07/01/2027 50,000.00 50,966.50 52,169.22 (1,202.72) 2,169.22 N/A Cetera Investment Services Municipal Bonds 3.000% 3.101% 05/18/2020 09/01/2027 65,000.00 70,303.35 69,180.58 1,122.77 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,960.05 27,969.55 990.50 (7,030.45) 05/01/2025 Cetera Investment Services Municipal Bonds 3.270% 2.141% 08/19/2019 03/15/2028 155,000.00 171,030.10 170,805.09 225.01 15,805.09 09/15/2027 Cetera Investment Services Municipal Bonds 2.974% 2.574% 11/07/2019 04/01/2028 75,000.00 78,462.75 77,253.00 1,209.75 2,253.00 N/A Cetera Investment Services Municipal Bonds 3.140% 2.004% 08/19/2019 08/01/2028 500,000.00 544,505.00 547,105.00 (2,600.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 96,352.20 95,401.80 950.40 5,401.80 08/15/2025 Cetera Investment Services Municipal Bonds 3.000% 1.942% 08/19/2019 06/01/2029 115,000.00 128,403.25 125,961.80 2,441.45 10,961.80 N/A Cetera Investment Services Municipal Bonds 4.000% 3.214% 03/22/2021 09/01/2031 60,000.00 63,547.80 64,292.00 (744.20) 4,292.00 09/01/2024 Cetera Investment Services Municipal Bonds 3.250% 2.655% 08/19/2019 06/01/2029 75,000.00 80,608.50 79,860.31 748.19 4,860.31 02/01/2025 Broker Total 70.5% 9,264,000.00 9,809,088.01 9,719,973. 13 86,141.05 455,973.13 TOTAL INVESTMENTS 100.0% $ 13,368,000.00 $ 13,918,470.53 $ 13,823,973.13 $ 90,069.13 $ 455,973.13 Product Type Total Value Total Total Value Total Change Less than 1 year $2,077,545.75 14.9% 10.7% uuuMoney Market $4,428.27 0.0% $32,009.821,491,905.60 ,• (248,106.61) Government Bonds ., :, ELECTRIC DIVISION Operating Revenue June 2021 CLASS AMOUNT KWH /KWH Street Lights $19.46 357 $0.05451 Electric Residential Service $578,844.64 6,048,035 $0.09571 All Electric Residential Service $18,293.81 180,617 $0.10129 Electric Small General Service $168,433.61 1,767,132 $0.09531 Electric Large General Service $684,836.16 7,763,500 $0.08821 Electric Large Industrial Service $820,711.45 11,045,000 $0.07431 Total $2,271,139.13 26,804,641 $0.08473 Power Adjustment $0.00000 Rate Without Power Adjustment $0.08473 Electric Division Year -to -Date M2021$A--t 02020$A--t ■2021 KWH110 02020KWH110 16,000,000 14,000,000 12,000,000 10,000,000 8,000,000 6,000,000 4,000,000 2,000,000 0 ,I IIWIIWIIu � i IIWIIWIIII I IIWIIWIIII I i IIWIIWIIu I i IIWIIWIIII 1 Street Lights Residential All Elec. Small Gen. Large Gen. Large For Resale Resid. Srv. Srv. Industrial NOTE: Sales for resale includes capacity sales, market sales and Transalta sales. Total NATURAL GAS DIVISION Operating Revenue JUNE 2021 CLASS AMOUNT MCF /$ MCF Residential $130,301.83 6,524 $19.97269 Commercial $103,006.63 7,500 $13.73422 Large Industrial $18,249.95 2,011 $9.07506 Large Industrial Contracts $202,309.07 49,594 $4.07931 Total $453,867.48 65,629 $6.91565 ® 2021 $ Amount 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 Fuel Adjustment $0.91000 Rate Without Fuel Adjustment $6.00565 Natural Gas Division Year -to -Date 0 2020 $ Amount ■ 2021 MCF 132020 MCF Gas Residential Gas Commercial Large Industrial Large Industrial Total Contracts IFIMO IN eReliability I Monthly Statistics Monthly Report - Hutchinson Utilities Commission Year 2021 Month 06 - June Annual Report? Yes Oio No Hutchinson Utilities Commission Minimum duration Maximum duration Top-level Cause Substation Circuit Remove Major Events? https://re liability.publicpower.org/reports/monthly/utility/91 /?year=2021 &month=6&is_annual_report=no&minimum_outage_duration=&maxim um_outag... 1 /6 7/22/2021 eReliability I Monthly Statistics IEEE 1366 Statistics Metric Jun 2021 Jun 2020 SAIDI 2.01 None SAIFI 0.0266 None CAI DI 75.573 None ASAI 99.9951 % 100% Momentary Interruptions 0 0 Sustained Interruptions 6 0 Circuit Ranking - Worst Performing Ranked by Outage Count Circuit Substation Number of Outages Fdr#15 Plant 1 2 Fdr#16 Plant 1 2 Fdr#18 Plant 1 2 Ranked by Customer Interruptions Circuit Substation Customer Interruptions Fdr#16 Plant 1 108 Fdr#18 Plant 1 54 Fdr#15 Plant 1 28 Ranked by Customer Minutes of Duration Circuit Substation Customer Minutes of Duration Fdr#18 Plant 1 9,433 https://re liability.publicpower.org/reports/monthly/utility/91 /?year=2021 &month=6&is_annual_report=no&minimum_outage_duration=&maxim um_outag... 2/6 IFIMO IN eReliability I Monthly Statistics Circuit Substation Customer Minutes of Duration Fdr#16 Plant 1 3,280 Fdr#15 Plant 1 1,646 https://re liability.publicpower.org/reports/monthly/utility/91 /?year=2021 &month=6&is_annual_report=no&minimum_outage_duration=&maxim um_outag... 3/6 7/22/2021 eReliability I Monthly Statistics Historical Monthly SAIDI Chart Historical Monthly SAIFI Chart 0.20 Mor thly Ave age 0.15 0.10 .... _... ��....................................................... 0.05 y, 0.00 Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun 2020 2020 2020 2020 2020 2020 2021 2021 2021 2021 2021 2021 SAIDI of monthly SAIDI values SAIFI of monthly SAIFI values https://re liability.publicpower.org/reports/monthly/utility/91 /?year=2021 &month=6&is_annual_report=no&minimum_outage_duration=&maxim um_outag... 4/6 IFIMO IN Causes Ranked by Count eReliability I Monthly Statistics Cause Electrical Failure Heat Vehicle Accident Causes Ranked by Duration Cause Electrical Failure Vehicle Accident Heat Count 4 Duration 12,794 1,250 315 https://re liability.publicpower.org/reports/monthly/utility/91 /?year=2021 &month=6&is_annual_report=no&minimum_outage_duration=&maxim um_outag... 5/6 7/22/2021 eReliability I Monthly Statistics Top 6 Outages for the Month Customers Customer Minutes of Address Interrupted Duration Interruption Start Date 1265 Carolina Ave 47 194 9,118 06/05/2021 NW Miller Merril VFI 100 24 2,400 06/22/2021 145 Glen St NW 25 50 1,250 06/25/2021 Grove St SW 8 110 880 06/21/2021 West Elementary 3 132 396 06/18/2021 1255 Hwy 7 West 7 45 315 06/10/2021 Total Customers Affected for the Month: Average Customers Affected per Outage: 190 31.666667 https://re liability.publicpower.org/reports/monthly/utility/91 /?year=2021 &month=6&is_annual_report=no&minimum_outage_duration=&maxim um_outag... 6/6 Work Order D,esc,r,iRti,on 12101 Plant 1 Cooling Tower Fence 12102 Plant 1 Brick in Vent Opening 12103 Plant 1 Roof Replacement 12104 Units 6 & 7 Roof Exhaust Fans 12105 CEMS Data Logger Software for Unit 1 12106 Pressure Calibration Machine Electric Production Total Materials Labor Budgeted $ 7,000.00 $ - $ 7,000.00 $ 7,000.00 - 7,000.00 40,000.00 $ 40,000.00 30,000.00 - $ 30,000.00 70,000.00 2,000.00 $ 72,000.00 15,000.00 ................169,000.00 $ 15,000.00 $..... 2,000.00 $ $ 171,000.00 $ Total Percentage Actual Difference C, ompleted 4,692.00 $ (2,308.00) - (7,000.00) - $ (40,000.00) - $ (30,000.00) 50,207.11 $ (21,792.89) 11,036.10 $ (3,963.90) 65,935.21 $ (105,064.79 Work order Description 22101 Pole Repair or Replacement 22102 Install Duct for Reconductor 22103 Feeders 15 & 16 Reconductor 22104 Feederl2A Reconductor 22105 Civil Air Patrol 22106 Century Court Apartments 2nd Addition 22107 City Road Projects 22108 New Developments 22109 Feederl2A Reconductor 22110 Transformer Replacements 22111 Transformer New Developments 22112 Century Court Apartments 2nd Addition 22113 Civil Air Patrol 22114 Meters Electric Distribution Total Total Materials Labor B,ud, emoted Actual Difference $ 15,000.00 $ - $ 15,000.00 $ $ (15,000.00) 15,000.00 65,000.00 80,000.00 13,147.18 $ (66,852.82) 35,000.00 75,000.00 110,000.00 9,920.80 $ (100,079.20) 30,000.00 20,000.00 50,000.00 - $ (50,000.00) 7,000.00 2,000.00 9,000.00 - $ (9,000.00) 10,000.00 15,000.00 25,000.00 76.54 $ (24,923.46) 10,000.00 10,000.00 20,000.00 264.63 $ (19,735.37) 50,000.00 - 50,000.00 3,535.11 $ (46,464.89) 15,000.00 7,000.00 22,000.00 $ (22,000.00) 40,000.00 14,000.00 54,000.00 97.14 $ (53,902.86) 50,000.00 50,000.00 11,397.48 $ (38,602.52) 15,000.00 3,000.00 18,000.00 - $ (18,000.00) 4,000.00 1,000.00 5,000.00 $ (5,000.00) 30,000.00 30,000.00 149.25 $ (29,850.75) $ 326,000.00 $ 212,000.00 $ 538,000.00 $ 38,588.13 $ (499,411. 87) Percentage Coq eted Work Order Description 52101 Vactron 52102 Directional Borer 52103 Natural Gas Service Truck 52104 Misc Tools 52007 Replace #357 Welding Truck Administrative Total Total Budgeted Actual Difference $ 72,000.00 $ 97,061.28 $ (25,061.28) 167,000.00 - 167,000.00 75,000.00 - 75,000.00 10,000.00 - 10,000.00 92,700.00 68,930.55 23,769.45 $ 416,700.00 $ 165,991.83 $ (250,708.17) Percentage Completed Natural Gas Work Total Total Percentage Order Description Materials Labor Budgeted Actual Difference Completed. 62101 Misc Developments $ 50,000.00 $ 7,500.00 $ 57,500.00 $ 3,648.53 $ (53,851.47) 62102 Dale St SW (Roberts to South Grade) 5,000.00 1,500.00 6,500.00 (6,500.00) 62103 SCD Trunk Storm 7,500.00 3,000.00 10,500.00 (10,500.00) 62104 Washington Ave (Lynn to Main) 7,500.00 2,000.00 9,500.00 (9,500.00) 62105 Roberts Road SW (Alan to Dale) 15,000.00 5,000.00 20,000.00 (20,000.00) 62106 1st Ave NE (Main to Adams) 5,000.00 2,000.00 7,000.00 (7,000.00) 62107 1st Ave SE (Main to Adams) 5,000.00 2,000.00 7,000.00 (7,000.00) 62108 2nd Ave SW (Franklin to Main) 5,000.00 2,000.00 7,000.00 (7,000.00) 62109 Isolated Main Replacement (Btn Barley and Glenda) 95,000.00 5,000.00 100,000.00 3,540.28 (96,459.72) 62110 Improvements to Regulator Stations 20,000.00 3,000.00 23,000.00 39.98 (22,960.02) 62111 Service Lines 57,000.00 35,000.00 92,000.00 38,890.40 (53,109.60) 62112 Meters, AMI, and All Fittings 100,000.00 4,000.00 104,000.00 10,241.97 (93,758.03) 62113 Residential Regulators 15,000.00 - 15,000.00 (15,000.00) 62114 Industrial Metering and Regulation 80,000.00 5,000.00 85,000.00 2,594.90 (82,415.10) 62115 Pressure Monitors - AMI System 25,000.00 _ 1,500.00 26,500.00 1,772.08 (24,727.92) $ 492,000.00 $ 78,500.00 $ 570,500.00 $ 60,718.14 $-- (509,781.86) HUTCHINSON UTILITIES COMMISSION ,c�,« Board Action Form 'AlUTlt 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 1 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