The URL can be used to link to this page

12-21-2022 HUCCPHUTCHINSON UTILITIES COMMISSION AGENDA REGULAR MEETING December 21, 2022 3:00 p.m. 1. CONFLICT OF INTEREST 2. APPROVE CONSENT AGENDA a. Approve Minutes b. Ratify Payment of Bills 3. APPROVE FINANCIAL STATEMENTS 4. OPEN FORUM 5. COMMUNICATION a. City Administrator b. Divisions C. Human Resources d. Legal e. General Manager 6. POLICIES a. Review Policies No Policies to Review b. Approve Changes 7. UNFINISHED BUSINESS a. None 8. NEW BUSINESS a. Approve 2023 Pay Grid b. Approve 2023 Budgets & CIP c. Approve Cancellation of PO#008631 — 2021 Ram 3500 Cab & Chassis d. Approve Req#009402 — ABM Equipment Utility Body e. Approve Req#009403 — DUALDRAW Paint Booth f. Approve Transmission Facilities Assignment Agreement — MRES g. Conduct the Performance Review of Hutchinson Utilities Commission General Manager Pursuant to Minnesota Statute 13D.05 Subd. 3(a) 9. ADJOURN MINUTES Regular Meeting — Hutchinson Utilities Commission Wednesday, November 23, 2022 Call to order — 3:00 p.m. President Matt Cheney called the meeting to order. Members present: President Matt Cheney; Vice President Anthony Hanson; Secretary Don Martinez; Commissioner Robert Wendor f; Commissioner Kathy Silvernale; 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 Hanson to Approve the Consent Agenda. Motion carried unanimously. 3. Approve Financial Statements Mr. Martig presented the financial statements. Electric Division Sales for Resales continues to be up due to the Dynasty contract. Everything else is similar. Motion by Commissioner Silvernale second by Commissioner Wendorff to Approve the Financial Statements. Motion carried unanimously. 4. Open Forum 5. Communication a. City Administrator —Matthew Jaunich — 1. Working on Finalizing budgets 2. Truth and Taxation December 6tn 3. Getting ready for next year's construction projects b. Divisions i. Dan Lang, Engineering Services Manager — Absent ii. Dave Hunstad, Electric Transmission/Distribution Manager — 1. Caught up with Fall projects iii. Mike Gabrielson, Production Manager — 1 . November 12-19 had 4 Mechanics and 2 Electricians over in Kiel Germany for Caterpillar training. 2. Caterpillar Staff from Germany was on site a couple of weeks ago to do warranty work on Unit 6 and completed oil consumption test on Units 6 & 7 which was part of the retainer. Initial reports are within specs. 3. Abatement of units 3 & 4 will be starting this next week. 4. Phase 1 of Cooling Tower project will be starting next week along with tower pipe rework that needs to be completed. iv. John Webster, Natural Gas Division Director — 1. Performed required verification digs on 12" lateral line v. Jared Martig, Financial Manager — 1. Nothing to Report c. Human Resources —Angie Radke —Nothing to Report d. Legal — Marc Sebora — Nothing to report e. General Manager — Jeremy Carter — Nothing to report 6. Policies a. Review Policies i. CIP Rebate Level of Authority ii. Delegation of Authority Policy iii. Financial Reserve Policy iv. Investment Policy v. Purchasing Policy/Credit Cards/Fixed Assets vi. Service Beyond City Limits of Hutchinson vii. Surplus Property Policy No changes recommended at this time. b. Approve Changes i. Payments of HUC Payables Ms. Radke spoke of the changes to the Payments of HUC Payments. Looking to update the year to 2023 along with amending the date of the change. Motion by Commissioner Martinez, second by Commissioner Hanson to Approve the Policy Changes. Motion carried unanimously. 7. Unfinished Business 8. New Business a. Approve Non -Waiver of Tort Liability Limits for General Liability Insurance GM Carter presented the requirement by League of Minnesota Cities Insurance Trust. Staff is recommending to not waive the tort liability limits. Completion of the Wavier form is done annually. In the past HUC has not waived the municipal tort limit. Motion by Commissioner Hanson, second by Commissioner Wendorff to Approve Non -Waiver of Tort Liability Limits for General Liability Insurance. Motion carried unanimously. b. Approve Customer Uncollectable Write-offs Mr. Martig presented the Customer Uncollectable Write -Offs. HUC is requesting to approve write-offs of $7,492.23. This amount is less than last year. 2 Motion by Commissioner Silvernale second by Commissioner Wendorff to Approve Customer Uncollectable Write-offs. Motion carried unanimously c. Approve Req#009373 - Re -Working of Cooling Tower Piping Plant 1 for Engine Removal Mr. Gabrielson presented Approval of Req#009373 — Re -working of Cooling Tower Piping Plant 1 for Engine Removal. The cooling water pipping from the cooling tower needs to be removed from Units 3, 4 and 8 and looped back to the cooling tower. The cooling towerwill be down and drained during this time for Phase 1 of the cooling tower repair so this will be a good time to do this project. Pioneer Power was the lowest bid at $38,500.00. Motion by Commissioner Wendorff, second by Commissioner Martinez to Approve Req#009373 — Re -Working of Cooling Tower Piping Plant 1 for Engine Removal. Motion carried unanimously. d. Approve Req#009374 — WSB 2023 Regulatory Program Updates Mr. Webster presented Approval of Req#009374 — WSB 2023 Regulatory Program Updates. The Natural Gas Division is required to update the Division's Operations and Maintenance Manual, Emergency Response Plan and Transmission Integrity Management Plan due to PHMSA. Looking to have WSB help with the updates. WSB proposes to have the updates completed in 2023. Engineering work in 2023 budget. Motion by Commissioner Silvernale, second by Commissioner Hanson to Approve Req#009374—WSB 2023 Regulatory Program Updates. Motion carried unanimously. e. Discussion/Approval of Rescheduling the December 28, 2022 Regular Commission Meeting if needed. Ms. Radke presented Approval of Rescheduling the December 28, 2022 Regular Commission Meeting if needed. Looking at rescheduling the meeting to December 21, 2022. Motion by Commissioner Hanson, second by Commissioner Martinez to Approve Rescheduling the December 28, 2022 meeting to December 21, 2022 at 3pm. Motion carried unanimously. f. Discussion of reappointment of Matthew Cheney to the Hutchison Utilities Commission President Cheney began the discussion of reappointment to the Hutchinson Utilities Commission. President Cheney stated he has enjoyed his time spent on the Commission Board and is willing to be re -appointed for his first 5-year term. Commissioner Hanson took over the agenda item and looked for a motion to re- appoint Matthew Cheney to the Hutchinson Utilities Commission. 3 Motion by Commissioner Martinez, second by Commissioner Wendorff to Re- appoint Matthew Cheney to the Hutchinson Utilities Commission for a full 5-year term. Motion carried unanimously. g. Discuss Date for Performance Review of Hutchinson Utilities General Manager Ms. Radke discussed the Date for Performance Review of Hutchinson Utilities General Manager. Per the General Manager's contract with Utilities, an annual Performance Review is to be conducted. Generally, this review has occurred in December at the scheduled Commission Meeting or it can occur at a Special Meeting. It is up to the Commission on when the Performance Review should be held. GM Carter would have the opportunity to decide if it would be an open or closed session. When the date is decided, review forms will be sent to all the Commissioners. After Commissioners have completed and returned review forms, all results will be compiled for discussion at the review. After discussion, GM Carter and Commissioners agreed to have the review at the regular re -scheduled Commission Meeting on December 21, 2022. 9. Adjourn There being no further business, a motion by Commissioner Silvernale, second by Commissioner Martinez to adjourn the meeting at 3:21 p.m. Motion carried unanimously. ATTEST: Matt Cheney, President 12 Don Martinez, Secretary MINUTES Special Meeting — Hutchinson Utilities Commission Wednesday, November 23, 2022 Call to order — 2:00 p.m. President Matt Cheney called the meeting to order. Members present: President Matt Cheney; Vice President Anthony Hanson; Secretary Don Martinez; Commissioner Robert Wendor f; Commissioner Kathy Silvernale; GM Jeremy Carter; Attorney Marc Sebora Others present: John Webster, Dave Hunstad, Jared Martig, Mike Gabrielson and Angie Radke The purpose of the special meeting is to have a Budget Workshop. GM Carter thanked the Commissioners for coming and noted that these are preliminary budget numbers and the Commissioners will have 4 weeks to review before final budget numbers need to be approved. GM Carter stated that MISO did approve the substation, which will start in the next 3-5 years. Discussion was held on past project approvals, front loaded Cap X projects and the flexibility of moving projects if needed. GM carter presented HUC's 2023 preliminary budget, which is the same format as previous years but a few more graphs have been added. GM Carter highlighted for combined division, revenues are at $46.2M with expenses at $45.3M with a Net Profit of $908K, which was an increase in net profit over last year. Combined Division shows adding $400K in the Power Cost Adjustment. Electric Division Revenues are at $30AM with expenses at $31.3M with a Net Loss of $847K; this is about $480K worse than last year. Gas Division Revenues are at $15.8M with expenses at $14M with a Net Profit of $1.8M which is about $700K better than last year. Electric Division, Retail Customer sales $25.7M which is fairly consistent with last year. Power Cost Adjustment is $1.6M compared to $1.2M in 2022. Residential, Small General, Large General and Industrial Sales are fairly consistent with past years: which means HUC's loads are fairly consistent. Overall kwhr sales are essentially flat. GM Carter pointed out that Sales for Resales has increased by $538K over 2022 budget due to a decrease in Market Sales of $521 K but an increase in Dynasty Sales of $1.1 M Other Revenues of $429K is made up of Additional customer charges of $145K, Interest Earnings of $250K and Bond Premiums of $33K. GM Carter reviewed the Pictorial Graphs; these graphs show the overall comparison as to how the revenue is derived. The Consumption History graph shows a snapshot of each customer class loads, which is fairly flat. As long as consumption stays consistent HUC is right on track with Glide paths. Overall consistent. GM Carter spoke on the Electric Division Expense Budget Highlights. Health Insurance will be moving to Health Partners with a 4% decrease. Dental Insurance will be moving to Guardian with a 10% decrease. HUC did shop around for both Health and Dental Insurance. LTD, Basic Life and AD&D benefits remain the same. PILOT does have an increase of 2%. GM Carter reviewed the GRE/MISO Transmission Expense along with the MRES Baseload Contract Expense of a $221 K decrease, MISO Expenses of a $671 K increase and the Bright Energy Choices Program of $115K. Additional Operating Expenses of $25K for GRE O&M Agreement & updating relays, $20K for Substation breaker inspection and maintenance, $126K for Plant 1 window frame removal/replacement; which is a carryover from 2022, $30K for Plant 1 Louver Brick replacement and $40K for Solar Land lease agreement were also highlighted. GM Carter reviewed the pictorial graphs of the Electric Division Expenses. After discussion of the Electric Division preliminary budget, GM Carter gave an overview of the Natural Gas Division. Retail Customer Sales has an increase of $317K and shows a 1.3% increase in forecasted Retail MCF's sold. Contract Sales of 3M and HTI/TDK show an increase in revenue of $833K. GM Carter highlighted Other Revenues of $2.6M; which are made up of N.U/HCP/UFC/UNG Transport/Reservation Fees of $1.4M, Electric Division Transportation Fees of $719K, Bond Premiums of $186K, Customer Charges of $56K, Interest Income of $250K and Brownton & HCP operation/maintenance Agreement of $33K. GM Carter concluded by reviewing the pictorial graphs and expense budget highlights of the Natural Gas Division. GM Carter noted that the Retail Customer Gas purchases show an increase of the $337K, Contracted Customers Gas purchases increase of $738K, PILOT 2% increase of $11 K and Additional Operating Expenses of $200K for Engineering Cost for PHMSA's New Programs and $40K for Transmission ROW Maintenance and Painting. Discussion was held on what was driving the increase in operating expenses along with any research of prices softening in the future. GM Carter looked to the Commission for questions, concerns or comments on the 2023 Budget Presentation. There were no concerns from the Commissioners. There being no further business, a motion by Commissioner Hanson, second by Commissioner Silvernale to adjourn the meeting at 2:57p.m. Motion carried unanimously. ATTEST: Matt Cheney, President 2 Don Martinez, Secretary MINUTES Special Meeting — Hutchinson Utilities Commission Thursday, December 5, 2022 Call to order — 7:35 a.m. President Matt Cheney called the meeting to order. Members present: President Matt Cheney; Vice President Anthony Hanson; Secretary Don Martinez; Commissioner Robert Wendorff; Commissioner Kathy Silvernale; GM Jeremy Carter; Attorney Marc Sebora Others Present: Mike Gabrielson, Angie Radke 1. Reject Bids - Unit 1 Oil Leak Repair and Depot Service Mr. Gabrielson presented Rejecting Bids — Unit 1 Oil Leak Repair and Depot Service. There were 2 Bids that were received from the November 21, 2022 Bid Opening. Both companies that provided a bid did not provide a bid bond at time of bid submittal, therefore both companies are non -responsive and both bids need to be rejected. Discussion was held on when the proposed date to have the Unit back and running which is looking to be June 1, 2023. Motion by Commissioner Hanson, second by Commissioner Martinez to Approve Reject Bids - Unit 1 Oil Leak Repair and Depot Service. Motion carried unanimously. 2. Approve new RFP for Unit 1 Oil Leak Repair and Depot Service Mr. Gabrielson presented Approval of new RFP for Unit 1 Oil Leak Repair and Depot Service. The revised RFP now clearly states that a Bid Bond is mandatory upon Bid submittal along with stating when a Performance Bond and Payment Bond are required. Motion by Commissioner Silvernale, second by Commissioner Wendorff to Approve new RFP for Unit 1 Oil Leak Repair and Depot Service. Motion carried unanimously. 3. Approve Re -Advertisement for Bid — Unit 1 Oil Leak Repair and Depot Service Mr. Gabrielson presented Approval of Re -Advertisement for Bid for Unit 1 Oil Leak Repair and Depot Service. Advertisement for Bid has updated dates along with clarification of what is needed. Motion by Commissioner Martinez, second by Commissioner Hanson to Approve Re - Advertisement of Bid — Unit 1 Oil Leak Repair and Depot Service. Motion carried unanimously. 4. Approve Requisition for Voltage Regulator Unit 1 Mr. Gabrielson presented Approval of Requisition for Voltage Regulator Unit 1. The regulator needs to be replaced in order for unit 1 to run. Staff would like to have a new regulator in place to ensure adequate performance prior to the LM6000 going out of service as a result of the oil leak issues. Turbine Diagnostic Services has an aftermarket option that will replace the old analog regulator with a new digital regulator which will provide greater reliability. This option is more cost effective and timely then the second quote. Motion by Commissioner Silvernale, second by Commissioner Wendorff to Approve Requisition for Voltage Regulator Unit 1. Motion carried unanimously. There being no further business, a motion by Commissioner Hanson, second by Commissioner Martinez to adjourn the meeting at 7:44a.m. Motion carried unanimously. ATTEST: Matt Cheney, President 2 Don Martinez, Secretary 12/16/2022 09:22 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 11/21/2022 - 12/18/2022 Payee Description Account Dept Page 1/25 Amount Fund: 1 ELECTRIC 11/22/2022 GEN 1255(E) MISO Deferred Energy Cost - Miso 174-000- 00 747.81 11/25/2022 GEN 1236(E)*4 BP CANANDA ENERGY SOLUTIONS GENERATOR 41 NATURAL GAS 401-547- 01 86, 899. 03 GENERATOR 41 NATURAL GAS 401-547- 01 181.70 GENERATOR 45 NATURAL GAS 401-547- 01 16,369.13 GENERATOR 45 NATURAL GAS 401-547- 01 27. 95 GENERATOR 46 NATURAL GAS 401-547- 01 11, 682.05 GENERATOR 46 NATURAL GAS 401-547- 01 34.07 Generator 47 Natural Gas 401-547- 01 19,318.76 Generator 47 Natural Gas 401-547- 01 34.07 Generator 49 Natural Gas 401-547- 01 87.36 Utility Expenses - Water/Waste 401-930- 08 455.40 HECK GEN 1236(E) TOTAL FOR FUND 1: 135,089.52 11/28/2022 GEN 1246(E)* ALERUS HEALTH INSURANCE 401-926- 08 393.00 11/29/2022 GEN 1238(E) BOND TRUST SERVICES CORPORATION 2017 ELECTRIC BONDS 221-000- 00 700,000.00 2017 BOND INTEREST 237-000- 00 240,428.13 HECK GEN 1238(E) TOTAL FOR FUND 1: 940,428.13 11/29/2022 GEN 1256(E) MISO Deferred Energy Cost - Miso 174-000- 00 7,765.70 11/29/2022 GEN 1257(E) MISO Deferred Energy Cost - Miso 174-000- 00 814.72 12/01/2022 GEN 77804* ABBY OR ISAIAH BARLOW DEP REFUND/APPLIED 235-000- 00 188.50 12/01/2022 GEN 77805*4 ACE HARDWARE Sales Tax Receivable - Replace 186-000- 00 3.37 Sales Tax Receivable - Replace 186-000- 00 2.47 Sales Tax Receivable - Replace 186-000- 00 2.61 Supplies 401-550- 01 2.54 Supplies 401-550- 01 4.91 Supplies 401-550- 01 36.49 Accessory Plant - Materials 402-554- 01 48.99 Accessory Plant - Materials 402-554- 01 35.97 Accessory Plant - Materials 402-554- 01 37.99 12/16/2022 09:22 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 11/21/2022 - 12/18/2022 Payee Description Account Dept Page 2/25 Amount Fund: 1 ELECTRIC Maintenance Other - Materials 402-554- 01 18.16 HECK GEN 77805 TOTAL FOR FUND 1: 193.50 12/01/2022 GEN 77806* ADAM HARTWIG DEP REFUND/APPLIED 235-000- 00 325.00 12/01/2022 GEN 77807* AMBER CARLSON DEP REFUND/APPLIED 235-000- 00 58.50 12/01/2022 GEN 77808 AMERICAN TEST CENTER INC Vehicles - Material 402-598- 02 1,700.00 12/01/2022 GEN 77809* ASHLEY OR BRANDON CHRISTENSON DEP REFUND/APPLIED 235-000- 00 211.25 12/01/2022 GEN 77810 AUDREY LUKES OVERPAYMENTS 142-000- 00 54. 93 12/01/2022 GEN 77811* BAUNE, ROBERT Cip - Residential 401-916- 07 200.00 12/01/2022 GEN 77812*4 BORDER STATES ELECTRIC SUPPLY FUSE HOLDER, AIS SWITCH (SML-20) 154-000- 00 2, 519. 64 CONDUCTOR, 44/0 600V URD TRIPLEX 154-000- 00 13,492.00 BASEMENT, (GROUND SLEEVE), 3 PH JOT, 154-000- 00 337.89 KIT, SPLICE, QS4-15SP-QCI-2-4/0-BCA 154-000- 00 3,652.56 SHOVEL, SPADE D-HANDLE FPS, 4 3/4" x 154-000- 00 221.40 Sales Tax Receivable - New 186-000- 00 927.72 Sales Tax Receivable - New 186-000- 00 23.23 Sales Tax Receivable - New 186-000- 00 266.35 Sales Tax Receivable - Replace 186-000- 00 173.23 Materials 401-588- 02 2.20 HECK GEN 77812 TOTAL FOR FUND 1: 21,616.22 12/01/2022 GEN 77813 BRIAN JENSEN OVERPAYMENTS 142-000- 00 6.05 12/01/2022 GEN 77814* BRYAN HASBARGEN DEP REFUND/APPLIED 235-000- 00 58.50 12/01/2022 GEN 77816 CE POWER ENGINEERED SERVICES, LLC Generator Testing Ul 402-554- 01 4,394.00 Generator Testing U9 402-554- 01 2,197.00 CHECK GEN 77816 TOTAL FOR FUND 1: 6,591.00 12/16/2022 09:22 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 11/21/2022 - 12/18/2022 Payee Description Account Dept Page 3/25 Amount Fund: 1 ELECTRIC 12/01/2022 GEN 77817*4 CINTAS CORPORATION 4470 Uniforms & Laundry 401-550- 01 496.30 Uniforms & Laundry 401-550- 01 541.35 Uniforms & Laundry 401-550- 01 481.95 UNIFORMS & LAUNDRY 401-588- 02 655.71 UNIFORMS & LAUNDRY 401-588- 02 463.18 UNIFORMS & LAUNDRY 401-588- 02 284.88 HECK GEN 77817 TOTAL FOR FUND 1: 2,923.37 12/01/2022 GEN 77818*4 CITY OF HUTCHINSON Generator 41 Water & Sewer 401-547- 01 437.77 Generator 41 Water & Sewer 401-547- 01 691.10 Waste Disposal 401-550- 01 930.86 Waste Disposal 401-550- 01 53.48 Waste Disposal 401-550- 01 525.82 VEHICLES/EQUIPMENT FUEL-ELEC 401-588- 02 1,679.51 Line - Materials 402-594- 02 13.00 IT ADMIN AND SUPPORT 75/25 401-921- 08 3, 960.81 Utility Expenses - Water/Waste 401-930- 08 8.62 Utility Expenses - Water/Waste 401-930- 08 497.39 Bond Service Fees 427-000- 08 345.45 HECK GEN 77818 TOTAL FOR FUND 1: 9,143.81 12/01/2022 GEN 77819* COMPASS OCCASIONS DEP REFUND/APPLIED 235-000- 00 325.00 12/01/2022 GEN 77820 CORE & MAIN Elec MTR 16S CL200 107-370- 00 8,600.00 Electric MTR 9s CL20 Spec 16902 107-370- 00 445.00 HECK GEN 77820 TOTAL FOR FUND 1: 9,045.00 12/01/2022 GEN 77821 CTW GROUP OVERPAYMENTS 142-000- 00 267.04 12/01/2022 GEN 778224 CULLIGAN ULTRAPURE OF NORTHFIELD VALVE, MAIN, AQMATIC 40 RO, 1071233 154-000- 00 1, 968.44 FREIGHT 401-588- 02 36.98 HECK GEN 77822 TOTAL FOR FUND 1: 2,005.42 12/01/2022 GEN 77823 DARLA STARK OVERPAYMENTS 142-000- 00 50.50 12/16/2022 09:22 AM CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES Page 4/25 User: JMartig CHECK DATE FROM 11/21/2022 - 12/18/2022 DE: Hutchinson Utili Check Date Bank Check # Payee Description Account Dept Amount Fund: 1 ELECTRIC 12/01/2022 GEN 77824 DESIGN ELECTRIC, INC Supplies 401-550- 01 63.05 12/01/2022 GEN 77825* DEVON MARKGBAF OR PAITYN BINSFELD DEP REFUND/APPLIED 235-000- 00 201.50 12/01/2022 GEN 77826* ELDA MORALES DOMINGUEZ DEP REFUND/APPLIED 235-000- 00 52.00 12/01/2022 GEN 77827 EMILY BARCUS OVERPAYMENTS 142-000- 00 60.86 12/01/2022 GEN 77828* ERIC ELWOOD DEP REFUND/APPLIED 235-000- 00 178.75 12/01/2022 GEN 77829 ETERNITY KRAMPITZ OVERPAYMENTS 142-000- 00 69. 65 12/01/2022 GEN 77830 FASTENAL COMPANY Uniforms & Laundry 401-550- 01 18.33 12/01/2022 GEN 77831 FEDDICK GLOVE, SIZE 3XL, 5488 LINED DEERSKIN 401-550- 01 195.00 12/01/2022 GEN 77832* FIRST CHOICE FOOD & BEVERAGE BREAKROOM/RECOGNITION BANQUET 401-926- 08 193.50 12/01/2022 GEN 778334 FS3 INC CONDUCTOR, 46, 1-1/4" UL 40, BLACK/RED 154-000- 00 8,520.00 Sales Tax Receivable - New 186-000- 00 585.75 Crimper 6 ton LI,STD,CJD3BG 120V 401-581- 02 5,296.48 HECK GEN 77833 TOTAL FOR FUND 1: 14,402.23 12/01/2022 GEN 77834* GABRIELLE ENGSTROM DEP REFUND/APPLIED 235-000- 00 71.50 12/01/2022 GEN 77837 GREAT RIVER ENERGY TRANSMISSION EXPENSE 401-565- 03 142,158.34 12/01/2022 GEN 77838 HAND, TONY Production Operations 401-546- 01 15.05 12/01/2022 GEN 77839* HAYDEN WAGONER DEP REFUND/APPLIED 235-000- 00 97.50 12/01/2022 GEN 77840 HEATHER WHITE OVERPAYMENTS 142-000- 00 52.65 12/01/2022 GEN 77841* HILLYARD/HUTCHINSON Grounds - Materials 401-935- 08 63.67 12/01/2022 GEN 77842* HUTCHINSON APARTMENTS LLC DEP REFUND/APPLIED 235-000- 00 1,358.50 12/16/2022 09:22 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 11/21/2022 - 12/18/2022 Payee Description Account Dept Page 5/25 Amount Fund: 1 ELECTRIC 12/01/2022 GEN 77843* HUTCHINSON APARTMENTS LLC DEP REFUND/APPLIED 235-000- 00 1,381.25 12/01/2022 GEN 77844*4 HUTCHINSON WHOLESALE SUPPLY CO Electric Transmission Maintenance 402-574- 03 7.24 12/01/2022 GEN 77845 HUTTON, KIM Cip - Residential 401-916- 07 25.00 12/01/2022 GEN 77846 IEM ENERGY CONSULTANTS Development of RFP LM6000 402-554- 01 2, 856.00 Generator 41 Outside Services 402-554- 01 12.75 U9 retaining ring testing and Gen Test 402-554- 01 214.54 Generator 49 Labor 402-554- 01 0.46 HECK GEN 77846 TOTAL FOR FUND 1: 3,083.75 12/01/2022 GEN 77847* ISIAH HEROUT DEP REFUND/APPLIED 235-000- 00 65.00 12/01/2022 GEN 77848* JENNA VIKSE DEP REFUND/APPLIED 235-000- 00 84.50 12/01/2022 GEN 77849* JESUS GONZALEZ DEP REFUND/APPLIED 235-000- 00 260.00 12/01/2022 GEN 77850* JOHN KOBOW DEP REFUND/APPLIED 235-000- 00 130.00 12/01/2022 GEN 77851* JOSH RATHKE DEP REFUND/APPLIED 235-000- 00 130.00 12/01/2022 GEN 77852* KANISHA HARRIS DEP REFUND/APPLIED 235-000- 00 123.50 12/01/2022 GEN 778534 KURITA AMERICA INC F-9918 154-000- 00 657.47 TOWER SHIELD, 5173 154-000- 00 3,187.36 Sales Tax Receivable - Replace 186-000- 00 271.00 FREIGHT 401-588- 02 97.06 HECK GEN 77853 TOTAL FOR FUND 1: 4,212.89 12/01/2022 GEN 77854* LANCE GERBER DEP REFUND/APPLIED 235-000- 00 52.00 12/16/2022 09:22 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 11/21/2022 - 12/18/2022 Payee Description Account Dept Page 6/25 Amount Fund: 1 ELECTRIC 12/01/2022 GEN 77855* LARRY OR KAY PRAY DEP REFUND/APPLIED 235-000- 00 130.00 12/01/2022 GEN 77856* LAURAN JOHNSON DEP REFUND/APPLIED 235-000- 00 58.50 12/01/2022 GEN 77857* LYNETTE HART DEP REFUND/APPLIED 235-000- 00 39. 00 12/01/2022 GEN 77858* MARCO TECHNOLOGIES, LLC OFFICE SUPPLIES 401-921- 08 521.68 12/01/2022 GEN 77860 MEA ENERGY ASSOCIATION Dues/Membership Expense 401-930- 08 1,609.30 12/01/2022 GEN 77861* MEDICA HEALTH INSURANCE 85% ELEC 242-000- 00 51,143.84 HEALTH INSURANCE -COBRA 242-000- 00 1,918.15 HECK GEN 77861 TOTAL FOR FUND 1: 53,061.99 12/01/2022 GEN 77862* MICHAEL BURANDT DEP REFUND/APPLIED 235-000- 00 130.00 12/01/2022 GEN 77863* MID-AMERICAN RESEARCH CHEMICAL Grounds - Materials 401-935- 08 63.42 12/01/2022 GEN 77865 NERC Purchased Power 401-555- 02 4,440.02 12/01/2022 GEN 77866 NORTHERN STATES SUPPLY INC Supplies 401-550- 01 29.49 12/01/2022 GEN 77867* ONEIL, HERBERT Cip - Residential 401-916- 07 200.00 12/01/2022 GEN 77868*4 OXYGEN SERVICE COMPANY INC Supplies 401-550- 01 64.80 12/01/2022 GEN 77869* PATRICK ZIMMERMAN DEP REFUND/APPLIED 235-000- 00 143.00 12/01/2022 GEN 77870* PIERCE LUEDERS DEP REFUND/APPLIED 235-000- 00 65.00 12/01/2022 GEN 77871*4 PRO AUTO & TRANSMISSION REPAIR VEHICLES - MATERIAL-ELEC 402-598- 02 367. 92 12/01/2022 GEN 778724 PROCHASKA LLC SULFURIC ACID 66 BE 154-000- 00 1,313.33 12/16/2022 09:22 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee Fund: 1 ELECTRIC CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 11/21/2022 - 12/18/2022 Description 12/01/2022 GEN 77873* RELIANCE STANDARD LIFE -LIFE 12/01/2022 GEN 77874* RICKERTSON, MARK 12/01/2022 GEN 77875*4 RUNNING'S SUPPLY INC 12/01/2022 GEN 77877 S.T. COTTER 12/01/2022 GEN 77879* STANDARD PRINTING & MAILING 12/01/2022 GEN 77880 STATE OF MINNESOTA 12/01/2022 GEN 77881 TARGET CORPORATION 12/01/2022 GEN 77883 TIFFT, DAVE 12/01/2022 GEN 77884* TRACEY HUNTER 12/01/2022 GEN 77885* TREVOR STRADTMANN 12/01/2022 GEN 77886* UIS/SOURCECORP 12/01/2022 GEN 77888* VIDEOTRONIX INC 12/01/2022 GEN 778894 VIKING ELECTRIC Page 7/25 Account Dept Amount Sales Tax Receivable - Replace 186-000- 00 96.73 FREIGHT 401-588- 02 93.69 HECK GEN 77872 TOTAL FOR FUND 1: 1,503.75 LTD INSURANCE-80o ELEC 242-000- 00 1,559.77 LIFE INSURANCE-80o ELEC 242-000- 00 855.38 HECK GEN 77873 TOTAL FOR FUND 1: 2,415.15 Cip - Residential 401-916- 07 200.00 Line - Materials 401-581- 02 140.23 LM6000 End Bell Removal and Install 402-554- 01 1,303.02 Remove End Bell Unit 9 402-554- 01 2,679.48 Acuren NDE Alloy Analyzer coollector 402-554- 01 2,559.18 CHECK GEN 77877 TOTAL FOR FUND 1: 6,541.68 Office Supplies 401-921- 08 46.49 Regulatory Expenses 401-928- 08 770.81 Cip- Commercial 401-916- 07 7,450.00 Training - Expense 401-546- 01 39.41 DEP REFUND/APPLIED 235-000- 00 32.50 DEP REFUND/APPLIED 235-000- 00 211.25 COLLECTION - MATERIALS 401-903- 06 1,906.41 GROUNDS - OUTSIDE SERVICES 401-935- 08 392.73 S3988991000 Compresssor for 3304500 402-554- 01 727.89 12/16/2022 09:22 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 11/21/2022 - 12/18/2022 Payee Description Account Dept Page 8/25 Amount Fund: 1 ELECTRIC FREIGHT 401-588- 02 38.57 HECK GEN 77889 TOTAL FOR FUND 1: 766.46 12/01/2022 GEN 778924 WARTSILA OF NORTH AMERICA, INC RING, SEALING, EXHAUST, 200 028 154-000- 00 138. 96 Sales Tax Receivable - New 186-000- 00 12.80 FREIGHT 401-588- 02 47.21 HECK GEN 77892 TOTAL FOR FUND 1: 198.97 12/01/2022 GEN 77893* ZEULI'S AUTOMOTIVE MACHINE SHOP DEP REFUND/APPLIED 235-000- 00 162.50 12/02/2022 GEN 1248(E)* CITIZENS BANK Office Supplies 401-921- 08 124.44 12/02/2022 GEN 1253(E)* PAY MENTECH collection - Materials 401-903- 06 1,741.84 12/06/2022 GEN 1258(E) MISO Deferred Energy Cost - Miso 174-000- 00 50,219.56 12/06/2022 GEN 1259(E) MISO Deferred Energy Cost - Miso 174-000- 00 850.99 12/09/2022 GEN 1254(E)* INVOICE CLOUD collection - Materials 401-903- 06 1,616.99 12/13/2022 GEN 1260(E) MISO Deferred Energy Cost - Miso 174-000- 00 781.04 12/14/2022 GEN 1250(E) MISO 10 401-565- 03 5,858.20 12/14/2022 GEN 1251(E) MISO SCHEDULE 2 401-565- 03 11,487.85 SCHEDULE 1 401-565- 03 3,943.74 SCHEDULE 10 401-565- 03 59.26 SCHEDULE 26A 401-565- 03 154.77 SCHEDULE 26 401-565- 03 160.59 HECK GEN 1251(E) TOTAL FOR FUND 1: 15,806.21 12/14/2022 GEN 1252(E) MISO 26 401-565- 03 15,177.08 26A 401-565- 03 29,169.50 26E 401-565- 03 1.45 HECK GEN 1252(E) TOTAL FOR FUND 1: 44,348.03 12/16/2022 09:22 AM CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES Page 9/25 User: JMartig CHECK DATE FROM 11/21/2022 - 12/18/2022 DE: Hutchinson Utili Check Date Bank Check # Payee Description Account Dept Amount Fund: 1 ELECTRIC 12/15/2022 GEN 77894* RIVER HOUSE Breakroom/Recognition Banquet 401-926- 08 444.26 12/15/2022 GEN 77895 3D CNC Cip- Commercial 401-916- 07 566.20 12/15/2022 GEN 77896 3D CNC Cip- Commercial 401-916- 07 596.00 12/15/2022 GEN 77897*4 ACE HARDWARE Sales Tax Receivable - Replace 186-000- 00 0.69 Supplies 401-550- 01 9.88 Generator 41 Material 402-554- 01 9.99 Line - Materials 401-581- 02 17.08 HECK GEN 77897 TOTAL FOR FUND 1: 37.64 12/15/2022 GEN 778984 AIRGAS NORTH CENTRAL AQUA -AMMONIA, 19% NH3 154-000- 00 10, 760.26 Sales Tax Receivable - Replace 186-000- 00 865.16 FUEL & SURCHARGE FEES 401-588- 02 225.87 HECK GEN 77898 TOTAL FOR FUND 1: 11,851.29 12/15/2022 GEN 77899 ANTONIO HUERTA OR LANETT SCHEMMEL OVERPAYMENTS 142-000- 00 206.47 12/15/2022 GEN 77900* BERRY, FRANK Cip - Residential 401-916- 07 18.00 12/15/2022 GEN 77901*4 BORDER STATES ELECTRIC SUPPLY DUST CAP, 200A 160 DRG, COOPER LPC215 154-000- 00 655.75 BUSHING, WELL INSERT, FEED THRU 200A 154-000- 00 412.41 SPLIT BOLT 48 KS-15 Cu BURNDY 154-000- 00 35.20 CONDUCTOR, 41/0 15 KV SOL At, TRXLP, 154-000- 00 19, 014.84 Sales Tax Receivable - New 186-000- 00 45.08 Sales Tax Receivable - New 186-000- 00 28.35 Sales Tax Receivable - New 186-000- 00 2.42 Sales Tax Receivable - Replace 186-000- 00 1,307.63 Materials 401-588- 02 5.34 HECK GEN 77901 TOTAL FOR FUND 1: 21,507.02 12/15/2022 GEN 77903 CARLY'S SHOE STORE Uniforms & Laundry 401-588- 02 229.49 Uniforms & Laundry 401-588- 02 184.99 Uniforms & Laundry 401-588- 02 229.49 12/16/2022 09:22 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 11/21/2022 - 12/18/2022 Payee Description Account Dept Page 10/25 Amount Fund: 1 ELECTRIC HECK GEN 77903 TOTAL FOR FUND 1: 643.97 12/15/2022 GEN 77904* CARTER, JEREMY J Training - Expense 401-930- 08 33.37 12/15/2022 GEN 77907*4 CINTAS CORPORATION 4470 Uniforms & Laundry 401-550- 01 533.53 UNIFORMS & LAUNDRY 401-588- 02 308.11 HECK GEN 77907 TOTAL FOR FUND 1: 841.64 12/15/2022 GEN 77908*4 CITY OF HUTCHINSON VEHICLE/EQUIPMENT FUEL -POWER 401-550- 01 276.69 VEHICLES/EQUIPMENT FUEL-ELEC 401-588- 02 1,518.32 Vehicles - Material 401-921- 08 124.43 IT ADMIN AND SUPPORT 75/25 401-921- 08 2,521.77 Grounds - Outside Services 401-935- 08 10,603.46 VEHICLES/EQUIPMENT FUEL-ADMIN 55/45 401-935- 08 82.20 HECK GEN 77908 TOTAL FOR FUND 1: 15,126.87 12/15/2022 GEN 77909 CORE & MAIN Electric MTR 16s CL200 Spec 17867 107-370- 00 890.00 12/15/2022 GEN 77910 DESIGN ELECTRIC, INC Maintenance Other - Materials 402-554- 01 42.69 Maintenance Other - Materials 402-554- 01 32.65 HECK GEN 77910 TOTAL FOR FUND 1: 75.34 12/15/2022 GEN 77912* ELECTRO WATCHMAN INC Grounds - Outside Services 401-935- 08 934.62 Grounds - Outside Services 401-935- 08 47.38 HECK GEN 77912 TOTAL FOR FUND 1: 982.00 12/15/2022 GEN 77913 FOSTER MECHANICAL Heat Project 150,000 BTU high Eff 402-554- 01 6,861.38 Basement heater Project (3) Heaters 402-554- 01 19,600.00 Boiler Expansion Tank 402-554- 01 1,240.00 Boiler Service Work 402-554- 01 1,796.13 HECK GEN 77913 TOTAL FOR FUND 1: 29,497.51 12/15/2022 GEN 77914* GAUDETTE, MICHAEL Cip - Residential 401-916- 07 25.00 12/16/2022 09:22 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 11/21/2022 - 12/18/2022 Payee Description Account Dept Page 11/25 Amount Fund: 1 ELECTRIC 12/15/2022 GEN 77915 GOODIN COMPANY Supplies 401-550- 01 42.14 12/15/2022 GEN 7791614 GOPHER STATE ONE -CALL INC Line - Materials 401-581- 02 64.80 12/15/2022 GEN 77917 GREEN EARTH LAWN CARE, INC Line - Materials 401-581- 02 351.08 Line - Materials 401-581- 02 302.99 HECK GEN 77917 TOTAL FOR FUND 1: 654.07 12/15/2022 GEN 77919 HANSEN GRAVEL INC Line - Materials 401-581- 02 389.03 12/15/2022 GEN 77920* HARVEY, STEVEN Cip - Residential 401-916- 07 25.00 12/15/2022 GEN 77921 HILLYARD/HUTCHINSON Supplies 401-550- 01 487.87 12/15/2022 GEN 77922* HUTCHFIELD SERVICES Grounds - Outside Services 401-935- 08 1,093.21 12/15/2022 GEN 77923*4 HUTCHINSON CO-OP Vehicle/Equipment Fuel 401-550- 01 1,001.41 12/15/2022 GEN 77924* HUTCHINSON LEADER Advertising/Printing 401-921- 08 184.08 Advertising/Printing 401-921- 08 21.45 HECK GEN 77924 TOTAL FOR FUND 1: 205.53 12/15/2022 GEN 77925 HUTCHINSON WHOLESALE SUPPLY CO Power Equipment - Materials 402-598- 02 7.14 12/15/2022 GEN 77926 IEM ENERGY CONSULTANTS Development of RFP LM6000 402-554- 01 735.00 Generator 41 Outside Services 402-554- 01 2.50 U9 retaining ring testing and Gen Test 402-554- 01 4,511.65 Generator 49 Labor 402-554- 01 3.35 HECK GEN 77926 TOTAL FOR FUND 1: 5,252.50 12/15/2022 GEN 77927* INNOVATIVE OFFICE SOLUTIONS Office Supplies 401-921- 08 116.18 Office Supplies 401-921- 08 43.22 HECK GEN 77927 TOTAL FOR FUND 1: 159.40 12/16/2022 09:22 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 11/21/2022 - 12/18/2022 Payee Description Account Dept Page 12/25 Amount Fund: 1 ELECTRIC 12/15/2022 GEN 77929 KUCERA, CATHRYN Cip - Residential 401-916- 07 25.00 12/15/2022 GEN 77930* LAUINGER, GARY Cip - Residential 401-916- 07 25.00 12/15/2022 GEN 779314 LOCATORS & SUPPLIES INC PAINT, LOCATING, INVERTED SURVEY 154-000- 00 755.86 Sales Tax Receivable - New 186-000- 00 58.36 FREIGHT 401-588- 02 93.03 HECK GEN 77931 TOTAL FOR FUND 1: 907.25 12/15/2022 GEN 77932 LUANN LANG OVERPAYMENTS 142-000- 00 39.58 12/15/2022 GEN 77933* MADSEN, KARL Cip - Residential 401-916- 07 25.00 12/15/2022 GEN 779344 MATHESON TRI-GAS INC Sales Tax Receivable - Replace 186-000- 00 10.54 Generator 41 Material 402-554- 01 153.46 HECK GEN 77934 TOTAL FOR FUND 1: 164.00 12/15/2022 GEN 779354 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 77935 TOTAL FOR FUND 1: 6,950.00 12/15/2022 GEN 77937 MIDWEST MACHINERY CO Power Equipment - Materials 402-598- 02 685.57 12/15/2022 GEN 77938* MINNESOTA COMMERCE DEPT Doc - Cip Assessment 401-916- 07 5,602.65 12/15/2022 GEN 77941* NUVERA TELEPHONE 401-921- 08 1,830.26 12/15/2022 GEN 77942*4 O'REILLY AUTOMOTIVE INC Supplies 401-550- 01 41.29 Power Equipment - Materials 402-598- 02 15.02 HECK GEN 77942 TOTAL FOR FUND 1: 56.31 12/15/2022 GEN 77944*4 OXYGEN SERVICE COMPANY INC Supplies 401-550- 01 87.27 Supplies 401-550- 01 72.79 12/16/2022 09:22 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee Fund: 1 ELECTRIC CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 11/21/2022 - 12/18/2022 Description 12/15/2022 GEN 77945* PREMIUM WATERS INC 12/15/2022 GEN 779474 PROCHASKA LLC 12/15/2022 GEN 77948 QUADE ELECTRIC 12/15/2022 GEN 77949* QUADIENT-POSTAGE 12/15/2022 GEN 779514 RUNNING'S SUPPLY INC 12/15/2022 GEN 77952 RYAN RAISANEN 12/15/2022 GEN 77955* SCHIEG, MATTHEW 12/15/2022 GEN 77956 SCHWEITZER ENGINEERING LABS Account Dept Page 13/25 Amount HECK GEN 77944 TOTAL FOR FUND 1: 160.06 OFFICE SUPPLIES -BOTTLED WATER 401-921- 08 19. 88 CHLOR 125 (SANI-CHLOR) 154-000- 00 1,127.16 Sales Tax Receivable - New 186-000- 00 83.92 FREIGHT 401-588- 02 93.53 HECK GEN 77947 TOTAL FOR FUND 1: 1,304.61 Line - Materials 401-581- 02 34.13 POSTAGE 401-921- 08 2,381.81 Sales Tax Receivable - Replace 186-000- 00 0.74 Supplies 401-550- 01 30.19 Supplies 401-550- 01 21.56 Line - Materials 401-581- 02 2.63 Line - Materials 402-594- 02 9.38 CHECK GEN 77951 TOTAL FOR FUND 1: 64.50 OVERPAYMENTS 142-000- 00 65.93 Cip - Residential 401-916- 07 25.00 SEL-787 Transformer Protection Relay 107-362- 00 4,238.00 SEL-751 Feeder Protection Relay 107-362- 00 2,958.00 SEL-751 Feeder Protection Relay 107-362- 00 3,098.00 SEL-751 Relay 107-362- 00 3,142.51 SEL-751 Relay 107-362- 00 5,321.02 SEL-751 Relay 107-362- 00 2,660.51 SEL-751 Relay 107-362- 00 3,246.51 Sales Tax Receivable - Replace 186-000- 00 666.51 Sales Tax Receivable - Replace 186-000- 00 465.18 HECK GEN 77956 TOTAL FOR FUND 1: 25,796.24 12/16/2022 09:22 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 11/21/2022 - 12/18/2022 Description Fund: 1 ELECTRIC 12/15/2022 GEN 77957* SHRED RIGHT 12/15/2022 GEN 77958* STANDARD PRINTING & MAILING 12/15/2022 GEN 77959 STOCK, WYNN 12/15/2022 GEN 77960* SURVALENT TECHNOLOGY, INC 12/15/2022 GEN 77961 TK ELEVATOR CORPORATION 12/15/2022 GEN 77962* TRANS 12/15/2022 GEN 77963* UNITED PARCEL SERVICE 12/15/2022 GEN 77964* VANDERPOL, JASON 12/15/2022 GEN 77965*4 VERIZON WIRELESS 12/15/2022 GEN 779664 WESCO RECEIVABLES CORP 12/15/2022 GEN 77967*4 WEST CENTRAL SANITATION INC 12/15/2022 GEN 77968 WHEELHOUSE INDUSTRIAL Account Dept Page 14/25 Amount OFFICE SUPPLIES -SHREDDING SERVICES 401-921- 08 15.24 Office Supplies 401-921- 08 66.13 Cip - Residential 401-916- 07 25.00 SILVER SCADA SUPPORT PLAN 401-921- 08 9, 525.68 Outside Services 402-554- 01 300.00 LEASE/SERVICE AGREEMENTS 401-921- 08 1,023. 94 MAIL SERVICES - UPS, FEDEX 401-921- 08 208. 95 Cip - Residential 401-916- 07 200.00 TELEPHONE 401-921- 08 1,108.39 JUNCTION BOX, 3 PH (600A), 154-000- 00 6,820.00 Sales Tax Receivable - New 186-000- 00 522.59 FREIGHT 401-588- 02 781.20 HECK GEN 77966 TOTAL FOR FUND 1: 8,123.79 GENERATOR 41 WATER & SEWER -INDUSTRIAL 401-547- 01 115.46 WASTE DISPOSAL-4TH AVE 401-550- 01 186.41 UTILITY ESP - WATER/WASTE 55/45- 401-930- 08 281.68 HECK GEN 77967 TOTAL FOR FUND 1: 583.55 Ladder, Plantform, & Handrail Plant 1 107-341- 00 35,003.07 Structures & Improvements (Bui 107-341- 00 24.78 Sales Tax Receivable - Replace 186-000- 00 2,408.16 HECK GEN 77968 TOTAL FOR FUND 1: 37,436.01 12/16/2022 09:22 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 11/21/2022 - 12/18/2022 Payee Description Account Dept Page 15/25 Amount Fund: 1 ELECTRIC 12/15/2022 GEN 77970 WOODSTONE SENIOR LIVING Cip- Commercial 401-916- 07 375.00 12/15/2022 GEN 779724 ZIEGLER POWER SYSTEMS TRANSMITTER, CYLINDER PRESSURE 154-000- 00 7, 350.00 PAINT, CAT YELLOW, 5900196 154-000- 00 182.98 FREIGHT 401-588- 02 11.63 FREIGHT 401-588- 02 14.60 HECK GEN 77972 TOTAL FOR FUND 1: 7,559.21 Total for fund 1 ELECTRIC 1,719,497.79 12/16/2022 09:22 AM CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES User: JMartig CHECK DATE FROM 11/21/2022 - 12/18/2022 DE: Hutchinson Utili Check Date Bank Check # Payee Description Account Dept Fund: 2 GAS 11/25/2022 GEN 1236(E)*4 BP CANANDA ENERGY SOLUTIONS GAS FOR RETAIL 401-807- 04 GAS FOR RETAIL 401-807- 04 3M 401-807- 04 HTI 401-807- 04 UNG 401-807- 04 BROWNTON 401-807- 04 Utility Expenses - Water/Waste 401-930- 08 HECK GEN 1236(E) TOTAL FOR FUND 2: 11/28/2022 GEN 1246(E)* ALERUS HEALTH INSURANCE 401-926- 08 11/29/2022 GEN 1237(E) BOND TRUST SERVICES CORPORATION 2012 GAS BONDS 221-000- 00 2012 BOND INTEREST 237-000- 00 HECK GEN 1237(E) TOTAL FOR FUND 2: 12/01/2022 GEN 77804* ABBY OR ISAIAH BARLOW DEP REFUND/APPLIED 235-000- 00 12/01/2022 GEN 77805*4 ACE HARDWARE Mains 107-367- 00 Mains 107-367- 00 Mains 107-367- 00 Mains 107-367- 00 Mains 107-367- 00 Materials 402-863- 05 HECK GEN 77805 TOTAL FOR FUND 2: 12/01/2022 GEN 77806* ADAM HARTWIG DEP REFUND/APPLIED 235-000- 00 12/01/2022 GEN 77807* AMBER CARLSON DEP REFUND/APPLIED 235-000- 00 12/01/2022 GEN 77809* ASHLEY OR BRANDON CHRISTENSON DEP REFUND/APPLIED 235-000- 00 12/01/2022 GEN 77811* BAUNE, ROBERT Cip - Residential 401-916- 07 Page 16/25 Amount 12/16/2022 09:22 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 11/21/2022 - 12/18/2022 Payee Description Account Dept Page 17/25 Amount Fund: 2 GAS 12/01/2022 GEN 77812*4 BORDER STATES ELECTRIC SUPPLY PRE - MCO110-06-27 6INX27FT 107-367- 00 3,119.94 PRIMER, TEMCOAT 3000, ANTICORROSION, 154-000- 00 201.48 TAPE, BELOW GROUND USE, 41 WAX, 4" X 9 154-000- 00 822.24 SALES TAX 401-874- 04 284.88 HECK GEN 77812 TOTAL FOR FUND 2: 4,428.54 12/01/2022 GEN 77814* BRYAN HASBARGEN DEP REFUND/APPLIED 235-000- 00 31.50 12/01/2022 GEN 77815 BUBOLTZ, ADAM Cip - Residential 401-916- 07 350.00 12/01/2022 GEN 77817*4 CINTAS CORPORATION 4470 UNIFORMS & LAUNDRY 401-880- 04 150. 96 UNIFORMS & LAUNDRY 401-880- 04 150. 96 UNIFORMS & LAUNDRY 401-880- 04 150. 96 HECK GEN 77817 TOTAL FOR FUND 2: 452.88 12/01/2022 GEN 77818*4 CITY OF HUTCHINSON VEHICLE/EQUIPMENT FUEL -GAS 401-880- 04 1,454.75 IT ADMIN AND SUPPORT 75/25 401-921- 08 1, 320.28 Utility Expenses - Water/Waste 401-930- 08 7.05 Utility Expenses - Water/Waste 401-930- 08 397.91 Bond Service Fees 427-000- 08 345.45 HECK GEN 77818 TOTAL FOR FUND 2: 3,525.44 12/01/2022 GEN 77819* COMPASS OCCASIONS DEP REFUND/APPLIED 235-000- 00 175.00 12/01/2022 GEN 77825* DEVON MARKGBAF OR PAITYN BINSFELD DEP REFUND/APPLIED 235-000- 00 108.50 12/01/2022 GEN 77826* ELDA MORALES DOMINGUEZ DEP REFUND/APPLIED 235-000- 00 28.00 12/01/2022 GEN 77828* ERIC ELWOOD DEP REFUND/APPLIED 235-000- 00 96.25 12/01/2022 GEN 77832* FIRST CHOICE FOOD & BEVERAGE BREAKROOM/RECOGNITION BANQUET 401-926- 08 64.50 12/16/2022 09:22 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 11/21/2022 - 12/18/2022 Payee Description Account Dept Page 18/25 Amount Fund: 2 GAS 12/01/2022 GEN 77834* GABRIELLE ENGSTROM DEP REFUND/APPLIED 235-000- 00 38.50 12/01/2022 GEN 77835 COUP, MIKE Cip - Residential 401-916- 07 350.00 12/01/2022 GEN 77836 GOODIN COMPANY COMPOUND, PIPE JOINT, BLUE MONSTER 154-000- 00 56.65 12/01/2022 GEN 77839* HAYDEN WAGONER DEP REFUND/APPLIED 235-000- 00 52.50 12/01/2022 GEN 77841* HILLYARD/HUTCHINSON Grounds - Materials 401-935- 08 63.68 12/01/2022 GEN 77842* HUTCHINSON APARTMENTS LLC DEP REFUND/APPLIED 235-000- 00 731.50 12/01/2022 GEN 77843* HUTCHINSON APARTMENTS LLC DEP REFUND/APPLIED 235-000- 00 743.75 12/01/2022 GEN 77844*4 HUTCHINSON WHOLESALE SUPPLY CO Power Equipment - Materials 402-895- 04 14. 94 12/01/2022 GEN 77847* ISIAH HEROUT DEP REFUND/APPLIED 235-000- 00 35.00 12/01/2022 GEN 77848* JENNA VIKSE DEP REFUND/APPLIED 235-000- 00 45.50 12/01/2022 GEN 77849* JESUS GONZALEZ DEP REFUND/APPLIED 235-000- 00 140.00 12/01/2022 GEN 77850* JOHN KOBOW DEP REFUND/APPLIED 235-000- 00 70.00 12/01/2022 GEN 77851* JOSH RATHKE DEP REFUND/APPLIED 235-000- 00 70.00 12/01/2022 GEN 77852* KANISHA HARRIS DEP REFUND/APPLIED 235-000- 00 66.50 12/01/2022 GEN 77854* LANCE GERBER DEP REFUND/APPLIED 235-000- 00 28.00 12/01/2022 GEN 77855* LARRY OR KAY PRAY DEP REFUND/APPLIED 235-000- 00 70.00 12/16/2022 09:22 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 11/21/2022 - 12/18/2022 Payee Description Account Dept Page 19/25 Amount Fund: 2 GAS 12/01/2022 GEN 77856* LAURAN JOHNSON DEP REFUND/APPLIED 235-000- 00 31.50 12/01/2022 GEN 77857* LYNETTE HART DEP REFUND/APPLIED 235-000- 00 21.00 12/01/2022 GEN 77858* MARCO TECHNOLOGIES, LLC OFFICE SUPPLIES 401-921- 08 173.89 12/01/2022 GEN 778594 MCLEOD COOPERATVIE POWER ASSN MISC EXPENSE -GAS LINE PUMP 401-880- 04 61.29 UTILITIES (ELECTRIC, SATELLITE-MCLEOD 401-856- 05 38.66 UTILITIES (ELECTRIC, SATELLITE -PIPELINE 401-856- 05 39.56 HECK GEN 77859 TOTAL FOR FUND 2: 139.51 12/01/2022 GEN 77861* MEDICA HEALTH INSURANCE 15% GAS 242-000- 00 9,025.39 12/01/2022 GEN 77862* MICHAEL BURANDT DEP REFUND/APPLIED 235-000- 00 70.00 12/01/2022 GEN 77863* MID-AMERICAN RESEARCH CHEMICAL Grounds - Materials 401-935- 08 63.42 12/01/2022 GEN 77864 NELSON TECHNOLOGIES INC Recertification of Dresser Model 5 402-895- 04 6,923.02 12/01/2022 GEN 77867* ONEIL, HERBERT Cip - Residential 401-916- 07 350.00 12/01/2022 GEN 77868*4 OXYGEN SERVICE COMPANY INC Materials 401-874- 04 64.80 12/01/2022 GEN 77869* PATRICK ZIMMERMAN DEP REFUND/APPLIED 235-000- 00 77.00 12/01/2022 GEN 77870* PIERCE LUEDERS DEP REFUND/APPLIED 235-000- 00 35.00 12/01/2022 GEN 77871*4 PRO AUTO & TRANSMISSION REPAIR Vehicles - Material 402-895- 04 50.00 Vehicles - Material 402-895- 04 216.95 Vehicles - Material 402-895- 04 196.75 Vehicles - Material 402-895- 04 713.85 Vehicles - Material 402-895- 04 646.13 Vehicles - Labor 401-935- 08 68.22 12/16/2022 09:22 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee Fund: 2 GAS CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 11/21/2022 - 12/18/2022 Description 12/01/2022 GEN 77873* RELIANCE STANDARD LIFE -LIFE 12/01/2022 GEN 77874* RICKERTSON, MARK 12/01/2022 GEN 77875*4 RUNNING'S SUPPLY INC 12/01/2022 GEN 77876 RUSCH, JUSTIN 12/01/2022 GEN 77878 SOUTH CENTRAL ELECTRIC ASS'N 12/01/2022 GEN 77879* STANDARD PRINTING & MAILING 12/01/2022 GEN 77882 TDW US INC. 12/01/2022 GEN 77884* TRACEY HUNTER 12/01/2022 GEN 77885* TREVOR STRADTMANN Account Dept Page 20/25 Amount HECK GEN 77871 TOTAL FOR FUND 2: 1,891.90 LTD INSURANCE-20o GAS 242-000- 00 389.95 LIFE INSURANCE-20o GAS 242-000- 00 213.85 HECK GEN 77873 TOTAL FOR FUND 2: 603.80 Cip - Residential 401-916- 07 350.00 Mains 107-367- 00 94.84 Mains 107-367- 00 127.91 UTILITIES (ELECTRIC, SATELLITE 401-856- 05 33.00 Office Supplies 401-921- 08 15.50 In -Line Inspection of 12" Lateral 107-367- 00 46,720.00 DEP REFUND/APPLIED 235-000- 00 17.50 DEP REFUND/APPLIED 235-000- 00 113.75 12/01/2022 GEN 77886* UIS/SOURCECORP COLLECTION - MATERIALS 401-903- 06 12/01/2022 GEN 77887 VERIZON WIRELESS UTILITIES (ELECTRIC, SATELLITE-SCADA 401-856- 05 12/01/2022 GEN 77888* VIDEOTRONIX INC GROUNDS - OUTSIDE SERVICES 401-935- 08 12/01/2022 GEN 77890 VONCO II, LLC Mains 107-367- 00 12/01/2022 GEN 77891 WAGNER, BEN Cip - Residential 401-916- 07 12/01/2022 GEN 77893* ZEULI'S AUTOMOTIVE MACHINE SHOP DEP REFUND/APPLIED 235-000- 00 12/02/2022 GEN 1248(E)* CITIZENS BANK Office Supplies 401-921- 08 1,559.80 156.27 321.34 82.17 300.00 87.50 124.43 12/16/2022 09:22 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 11/21/2022 - 12/18/2022 Description Fund: 2 GAS 12/02/2022 GEN 1253(E)* PAY MENTECH 12/09/2022 GEN 1254(E)* INVOICE CLOUD 12/15/2022 GEN 77894* RIVER HOUSE 12/15/2022 GEN 77897*4 ACE HARDWARE 12/15/2022 GEN 77900* BERRY, FRANK 12/15/2022 GEN 77901*4 BORDER STATES ELECTRIC SUPPLY 12/15/2022 GEN 77902 BROWN COUNTY RURAL ELECTRIC 12/15/2022 GEN 77904* CARTER, JEREMY J 12/15/2022 GEN 77905 CENTURYLINK 12/15/2022 GEN 779064 CHAMPION CHARTER 12/15/2022 GEN 77907*4 CINTAS CORPORATION 4470 12/15/2022 GEN 77908*4 CITY OF HUTCHINSON Account Dept Page 21/25 Amount Collection - Materials 401-903- 06 1,425.14 Collection - Materials 401-903- 06 1,323.00 Breakroom/Recognition Banquet 401-926- 08 363.49 Services 107-380- 00 16.61 Cip - Residential 401-916- 07 25.00 PLUG ,TAPERED SCREW, 1" HEX x 3-1/4", 154-000- 00 90.10 COUPLING, FEMALE THRD, 1/4", BM, CLASS 154-000- 00 9.21 THREAD-O-LET, 3/4" x 36" x 1 1/2", 3000 154-000- 00 42.90 VALVE, METER, 1 1/4", INS, LOCKWING, 154-000- 00 45.83 SALES TAX 401-874- 04 6.19 SALES TAX 401-874- 04 0.63 SALES TAX 401-874- 04 6.10 HECK GEN 77901 TOTAL FOR FUND 2: 200.96 Utilities (Electric, Satellite 401-856- 05 201.09 Training - Expense 401-930- 08 33.38 Utilities (Electric, Satellite 401-856- 05 66.07 METER LOOP, 2" SCH 40, A53F, 180 154-000- 00 1,488.00 SALES TAX 401-874- 04 102.30 HECK GEN 77906 TOTAL FOR FUND 2: 1,590.30 UNIFORMS & LAUNDRY 401-880- 04 162.60 VEHICLE/EQUIPMENT FUEL -GAS 401-880- 04 3,199.63 12/16/2022 09:22 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 11/21/2022 - 12/18/2022 Payee Description Account Dept Page 22/25 Amount Fund: 2 GAS IT ADMIN AND SUPPORT 75/25 401-921- 08 840.60 Grounds - Outside Services 401-935- 08 8,675.57 VEHICLES/EQUIPMENT FUEL-ADMIN 55/45 401-935- 08 67.27 Vehicles/Equipment Fuel 401-935- 08 27.62 HECK GEN 77908 TOTAL FOR FUND 2: 12,810.69 12/15/2022 GEN 77911 DONE RITE POWDER COATING LLC Services 107-380- 00 200.00 12/15/2022 GEN 77912* ELECTRO WATCHMAN INC Grounds - Outside Services 401-935- 08 764.69 Grounds - Outside Services 401-935- 08 38.77 HECK GEN 77912 TOTAL FOR FUND 2: 803.46 12/15/2022 GEN 77914* GAUDETTE, MICHAEL Cip - Residential 401-916- 07 50.00 12/15/2022 GEN 77916*4 GOPHER STATE ONE -CALL INC Materials 401-874- 04 64.80 Line - Outside Services 401-856- 05 35.10 HECK GEN 77916 TOTAL FOR FUND 2: 99.90 12/15/2022 GEN 77918 GROEBNER & ASSOCIATES INC Sensus P/N# 006-46-317-23 23T Gear, 402-892- 04 23.33 Sensus P/N# 006-46-444-38 Deburred 402-892- 04 15.84 Sensus P/N# 006-24-035-00 Wheel Worm 402-892- 04 1.96 FREIGHT & TAXES 402-892- 04 24. 91 CHECK GEN 77918 TOTAL FOR FUND 2: 66.04 12/15/2022 GEN 77920* HARVEY, STEVEN Cip - Residential 401-916- 07 50.00 12/15/2022 GEN 77922* HUTCHFIELD SERVICES Grounds - Outside Services 401-935- 08 894.44 12/15/2022 GEN 77923*4 HUTCHINSON CO-OP Vehicle/Equipment Fuel 401-880- 04 1,167.74 12/15/2022 GEN 77924* HUTCHINSON LEADER Advertising/Printing 401-921- 08 17.55 12/15/2022 GEN 77927* INNOVATIVE OFFICE SOLUTIONS Office Supplies 401-921- 08 38.73 12/16/2022 09:22 AM CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES User: JMartig CHECK DATE FROM 11/21/2022 - 12/18/2022 DE: Hutchinson Utili Check Date Bank Check # Payee Description Account Dept Fund: 2 GAS Office Supplies 401-921- 08 HECK GEN 77927 TOTAL FOR FUND 2: 12/15/2022 GEN 77928 JUUL CONTRACTING COMPANY Services 107-380- 00 12/15/2022 GEN 77930* LAUINGER, GARY Cip - Residential 401-916- 07 12/15/2022 GEN 77933* MADSEN, KARL Cip - Residential 401-916- 07 12/15/2022 GEN 779364 MCLEOD COOPERATVIE POWER ASSN MISC EXPENSE -GAS LINE PUMP 401-880- 04 UTILITIES (ELECTRIC, SATELLITE-MCLEOD 401-856- 05 HECK GEN 77936 TOTAL FOR FUND 2: 12/15/2022 GEN 77938* MINNESOTA COMMERCE DEPT Doc - Cip Assessment 401-916- 07 12/15/2022 GEN 77939 MRC GLOBAL Electric Services - Material 416-105- 04 12/15/2022 GEN 77940 NORTHERN BORDER PIPELINE CO LINE - OUTSIDE SERVICES -INTERCONNECT 401-856- 05 12/15/2022 GEN 77941* NUVERA TELEPHONE 401-921- 08 12/15/2022 GEN 77942*4 O'REILLY AUTOMOTIVE INC Power Equipment - Materials 402-895- 04 12/15/2022 GEN 77943 OMEGA RAIL MANAGEMENT RAILROAD LICENSES 401-856- 05 12/15/2022 GEN 77944*4 OXYGEN SERVICE COMPANY INC Materials 401-874- 04 Materials 401-874- 04 HECK GEN 77944 TOTAL FOR FUND 2: 12/15/2022 GEN 77945* PREMIUM WATERS INC OFFICE SUPPLIES -BOTTLED WATER 401-921- 08 12/15/2022 GEN 77946 PRO AUTO & TRANSMISSION REPAIR Vehicles - Material 402-895- 04 Vehicles - Material 402-895- 04 HECK GEN 77946 TOTAL FOR FUND 2: Page 23/25 Amount 14.40 53.13 12.78 50.00 400.00 68.41 1,945.99 73.98 2,000.00 610.09 15.02 1,956.83 87.26 6.62 215.03 1,206.10 1,421.13 12/16/2022 09:22 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 11/21/2022 - 12/18/2022 Description Fund: 2 GAS 12/15/2022 GEN 77949* QUADIENT-POSTAGE 12/15/2022 GEN 77950 R & R EXCAVATING 12/15/2022 GEN 77953 RYAN, SCOTT 12/15/2022 GEN 77954 SANDER RESOURCES, LLC 12/15/2022 GEN 77955* SCHIEG, MATTHEW 12/15/2022 GEN 77957* SHRED RIGHT 12/15/2022 GEN 77958* STANDARD PRINTING & MAILING 12/15/2022 GEN 77960* SURVALENT TECHNOLOGY, INC 12/15/2022 GEN 77962* TRANS 12/15/2022 GEN 77963* UNITED PARCEL SERVICE 12/15/2022 GEN 77964* VANDERPOL, JASON 12/15/2022 GEN 77965*4 VERIZON WIRELESS 12/15/2022 GEN 77967*4 WEST CENTRAL SANITATION INC 12/15/2022 GEN 77969 WILNAT, INC 12/15/2022 GEN 77971 WSB Account Dept Page 24/25 Amount Postage 401-921- 08 793.94 Mains 107-367- 00 7,785.50 Cip - Residential 401-916- 07 25.00 Materials 401-874- 04 5,000.00 Cip - Residential 401-916- 07 50.00 OFFICE SUPPLIES -SHREDDING SERVICES 401-921- 08 5.08 Office Supplies 401-921- 08 22.04 SILVER SCADA SUPPORT PLAN 401-921- 08 9, 525.68 LEASE/SERVICE AGREEMENTS 401-921- 08 341.31 MAIL SERVICES - UPS, FEDEX 401-921- 08 69.65 Cip - Residential 401-916- 07 350.00 UTILITIES (ELECTRIC, SATELLITE-SCADA 401-856- 05 0.01 TELEPHONE 401-921- 08 369.46 HECK GEN 77965 TOTAL FOR FUND 2: 369.47 UTILITY EST - WATER/WASTE 45/55- 401-930- 08 230.48 Materials 402-892- 04 848.75 Engineering Review of ILI Data 401-856- 05 5,829.00 Line - Outside Services 401-856- 05 33.00 HECK GEN 77971 TOTAL FOR FUND 2: 5,862.00 12/16/2022 09:22 AM CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES Page 25/25 User: JMartig CHECK DATE FROM 11/21/2022 - 12/18/2022 DE: Hutchinson Utili Check Date Bank Check # Payee Description Account Dept Amount Fund: 2 GAS Total for fund 2 GAS 2,352,610.60 TOTAL - ALL FUNDS 4,072,108.39 --INDICATES CHECK DISTRIBUTED TO MORE THAN ONE FUND '#'-INDICATES CHECK DISTRIBUTED TO MORE THAN ONE DEPARTMENT HUTCHINSON UTILITIES COMMISSION COMBINED DIVISIONS FINANCIAL REPORT FOR NOVEMBER, 2022 Combined Division Customer Revenue Sales for Resale NU Transportation Electric Division Transfer Other Revenues Interest Income TOTAL REVENUES Salaries & Benefits Purchased Commodities Transmission Generator Fuel/Chem. Depreciation Transfers (Elect./City) Operating Expense Debt Interest TOTAL EXPENSES NET PROFIT/(LOSS) 2022 2021 2 %Chnq 2022 2021 2 %Chnq FuIIYrBud %of Bud $ 2,990,040 $ 3,152,826 $ (162,786) (5.2%) $ 34,516,919 $ 35,277,704 $ (760,785) (2.2%) $ 37,355,080 92.4% $ 366,224 $ 385,131 $ (18,906) (4.9%) $ 4,865,070 $ 3,909,088 $ 955,982 24.5% $ 3,692,000 131.8% $ 87,272 $ 84,446 $ 2,826 3.3% $ 1,006,300 $ 971,083 $ 35,218 3.6% $ 1,010,124 99.6% $ 59,724 $ 56,879 $ 2,844 5.0% $ 656,959 $ 625,671 $ 31,289 5.0% $ 716,383 91.7% $ 58,631 $ 108,767 $ (50,136) (46.1%) $ 617,618 $ 514,104 $ 103,514 20.1% $ 479,700 128.8% $ 57,410 $ 20,901 $ 36,509 174.7% $ 474,909 $ 372,974 $ 101,935 27.3% $ 383,456 123.8% $ 3,619,301 $ 3,808,950 $ (189,649) (5.0%) $ 42,137,776 $ 41,670,624 $ 467,152 1.1% $ 43,636,743 96.6% $ 582,472 $ 532,802 $ 49,671 9.32% $ 6,197,919 $ 5,929,493 $ 268,425 $ 1,766,915 $ 1,771,951 $ (5,036) (0.3%) $ 19,586,776 $ 21,248,283 $ (1,661,507) $ 215,776 $ 207,514 $ 8,262 4.0% $ 2,715,826 $ 2,688,839 $ 26,986 $ 62,400 $ 179,865 $ (117,464) (65.3%) $ 2,566,634 $ 1,716,239 $ 850,395 $ 375,446 $ 370,709 $ 4,737 1.3% $ 4,150,556 $ 4,052,895 $ 97,661 $ 215,323 $ 212,479 $ 2,844 1.3% $ 2,368,552 $ 2,337,263 $ 31,289 $ 237,594 $ 224,859 $ 12,735 5.7% $ 2,902,575 $ 2,215,424 $ 687,152 $ 75,076 $ 83,542 $ (8,467) (10.1%) $ 825,831 $ 918,964 $ (93,133) $ 3,531,002 $ 3,583,720 $ (52,718) (1.5%) $ 41,314,669 $ 41,107,401 $ 207,269 $ 88,299 $ 225,230 $ (136,931) (60.8%) $ 823,107 $ 563,224 $ 259,883 November November YTD YTD 2022 2021 Change 2022 2021 Change Gross Margin %: 30.2% 32.6% -2.4% 29.5% 28.2% 1.3% Operating Income Per Revenue $ (%): 1.9% 5.3% -3.5% 1.8% 1.6% 0.1% Net Income Per Revenue $ (%): 2.4% 5.9% -3.5% 2.0% 1.4% 0.6% Notes/Graphs: 4.5% $ 7,270,807 85.2% (7.8%) $ 19,927,587 98.3% 1.0% $ 3,325,000 81.7% 49.5% $ 1,219,698 210.4% 2.4% $ 4,400,000 94.3% 1.3% $ 2,583,875 91.7% 31.0% $ 3,367,066 86.2% 10.1% $ 900,907 $ 42,994,940 91.7% 96.1% 0.5% 46.1% $ 641,803 128.2% HUTCHINSON UTILITIES COMMISSION ELECTRIC DIVISION FINANCIAL REPORT FOR NOVEMBER, 2022 yyg 2022 2021 2 %Chna 2022 2021 2 %Chna Full YrBud %ofBud Electric Division Customer Revenue $ 1,746,668 $ 1,981,224 $ (234,555) (11.8%) $ 22,805,357 $ 23,341,010 $ (535,653) (2.3%) $ 25,325,244 90.0% Sales for Resale $ 366,224 $ 385,131 $ (18,906) (4.9%) $ 4,865,070 $ 3,909,088 $ 955,982 24.5% $ 3,692,000 131.8% Other Revenues $ 30,497 $ 37,045 $ (6,548) (17.7%) $ 292940 $ 206,636 $ 86,305 41.8% $ 188,599 155.3% Interest Income $ 30,099 $ 11,845 $ 18,255 154.1% $ 252:824 $ 201,770 $ 51,054 25.3% $ 208,456 121.3% TOTAL REVENUES $ 2,173,489 $ 2,415,244 $ (241,755) (10.0% $ 28,216,191 $ 27,658,503 $ 557,688 2.0% $ 29,414,299 95.9% Salaries & Benefits $ 462,595 $ 398,556 $ 64,039 16.1% $ 4,723,195 $ 4,396,225 $ 326,970 7.4% $ 5,319,511 88.8% Purchased Power $ 911,213 $ 1,051,533 $ (140,321) (13.3%) $ 11,805,391 $ 12,350,402 $ (545,010) (4.4%) $ 12,297,526 96.0% Transmission $ 215,776 $ 207,514 $ 8,262 4.0% $ 2,715,826 $ 2,688,839 $ 26,986 1.0% $ 3,325,000 81.7% Generator Fuel/Chem. $ 62,400 $ 179,865 $ (117,464) (65.3%) $ 2,566,634 $ 1,716,239 $ 850,395 49.5% $ 1,219,698 210.4% Depreciation $ 285,424 $ 279,498 $ 5,926 2.1% $ 3,150,041 $ 3,046,962 $ 103,080 3.4% $ 3,300,000 95.5% Transfers (Elect./City) $ 167,519 $ 164,674 $ 2,844 1.7% $ 1,842,707 $ 1,811,419 $ 31,289 1.7% $ 2,010,226 91.7% Operating Expense $ 174,416 $ 158,960 $ 15,456 9.7% $ 2,113,353 $ 1,518,145 $ 595,208 39.2% $ 1,928,042 109.6% Debt Interest $ 40,071 $ 43,321 $ (3,250) (7.5%) $ 440,785 $ 476,535 $ (35,750) JL $ 480,857 91.7% TOTAL EXPENSES $ 2,319,413 $ 2,483,921 $ (164,508) (6.6%) $ 29,357,932 $ 28,004,765 $ 1,353,168 4.8% $ 29,880,860 98.2% NET PROFIT/(LOSS) $ (145,924) $ (68,677) $ (77,248) 112.5% $ (1,141,741) $ (346,261) $ (795,480) 229.7% $ (466,561) 244.7% 2022 2021 2 %Chna 2022 2021 2 %Chna Full YrBud %ofBud Electric Division Residential 3,852,964 3,750,336 102,628 2.74% 48,831,354 49,096,546 (265,192) (0.54%) 54,152,764 90.2% All Electric 243,651 232,138 11,513 4.96% 2,413,684 2,246,118 167,566 7.46% 2,641,117 91.4% Small General 1,400,360 1,343,125 57,235 4.26% 16,621,910 16,467,919 153,991 0.94% 18,688,349 88.9% Large General 6,257,710 6,454,940 (197,230) (3.06%) 77,335,410 78,654,670 (1,319,260) (1.68%) 83,253,310 92.9% Industrial 7,438,000 9,176,000 (1,738,000) (18.94%) 105,007,000 111,226,000 (6,219,000) (5.59%) 122,088,679 86.0% Total KWH Sold 19,192,685 20,956,539 (1,763,854) (8.42%) 250,209,358 257,691,253 (7,481,895) (2.90%) 280,824,218 89.1% November November YTD YTD 2022 HUC 2022 2021 Change 2022 2021 Change Budget Target Gross Margin %: 25.3% 26.8% -1.5% 24.1% 25.9% -1.8% 29.2% 24%-28% Operating Income Per Revenue $ (%): -7.2% -2.5% -4.7% -4.0% -0.8% -3.2% -0.7% Net Income Per Revenue $ (%): -6.7% -2.8% -3.9% -4.0% -1.3% -2.8% -1.6% Customer Revenue per KWH: $0.0910 $0.0945 -$0.0035 $0.0911 $0.0906 $0.0006 $0.0902 Total Power Supply Exp. per KWH: $0.0828 $0.0831-$0.0003 $0.0843 $0.0785 $0.0058 $0.0736 $0.0736 Net Income decreased by $77,248 over November 2021. The primary reason for this decrease was the decrease in revenue both in customer revenue as well as sales for resale. Sales for Resale of $366,224 consisted of $25,717 in market sales, $98,000 in capacity sales to Rice Lake, $146,250 in capacity sales to AEP, and $96,257 in Tolling agreement sales to Dynasty Power. November 2021 Sales for Resale of $385,131 included $140,881 in market sales, $146,250 in capacity sales to AEP, and $98,000 in capacity sales to Rice Lake. November 2020 Sales for Resale of $246,864 consisted of $2,614 in market sales, $146,250 in capacity sales to AEP, and $98,000 in capacity sales to Rice Lake. Overall Purchased Power decreased by $140,321. MRES purchases decreased by $34,581 and market purchases/MISO costs decreased by $105,740. The average cost of MISO power was $37.06/mwh (2,921 mwh's purchased), compared to $40.24/mwh (1,608 mwh's purchased) in November 2021. Power Cost Adjustment for November 2022 was $.00199 bringing in an additional $38,383 for the month and $1,321,853 YTD. Power Cost Adjustment for November 2021 was $.00772 bringing in an additional $162,091 for the month and $1,493,007 YTD. HUTCHINSON UTILITIES COMMISSION GAS DIVISION FINANCIAL REPORT FOR NOVEMBER, 2022 2022 2021 Di . %Chna 2022 2021 Di . %Chna Full YrBud %of Bud Gas Division Customer Revenue $ 1,243,371 $ 1,171,602 $ 71,769 6.1% $ 11,711,562 $ 11,936,694 $ (225,132) (1.9%) $ 12,029,836 97.4% Transportation $ 87,272 $ 84,446 $ 2,826 3.3% $ 1,006,300 $ 971,083 $ 35,218 3.6% $ 1,010,124 99.6% Electric Div. Transfer $ 59,724 $ 56,879 $ 2,844 5.0% $ 656,959 $ 625,671 $ 31,289 5.0% $ 716,383 91.7% Other Revenues $ 28,134 $ 71,722 $ (43,588) (60.8%) $ 324,678 $ 307,469 $ 17,209 5.6% $ 291,101 111.5% Interest Income $ 27,311 $ 9,057 $ 18,255 201.6% $ 222,085 $ 171,204 $ 50,880 29.7% $ 175,000 126.9% TOTAL REVENUES $ 1,445,812 $ 1,393,706 $ 52,106 3.7% $ 13,921,585 $ 14,012,121 $ (90,536) (0.6%) $ 14,222,444 97.9% Salaries & Benefits $ 119,878 $ 134,246 $ (14,368) (10.7%) $ 1,474,724 $ 1,533,269 $ (58,544) (3.8%) $ 1,951,296 75.6% Purchased Gas $ 855,702 $ 720,418 $ 135,284 18.8% $ 7,781,385 $ 8,897,881 $ (1,116,496) (12.5%) $ 7,630,061 102.0% Operating Expense $ 63,178 $ 65,900 $ (2,722) (4.1%) $ 789,222 $ 697,278 $ 91,944 13.2% $ 1,439,024 54.8% Depreciation $ 90,022 $ 91,210 $ (1,189) (1.3%) $ 1,000,515 $ 1,005,934 $ (5,419) (0.5%) $ 1,100,000 91.0% Transfers (City) $ 47,804 $ 47,804 $ 0.0% $ 525,845 $ 525,845 $ 0 0.0% $ 573,649 91.7% Debt Interest $ 35,004 $ 40,221 $ (5,217) 0.0% $ 385,046 $ 442,429 $ (57,383) 13.0% $ 420,050 91.7% TOTAL EXPENSES $ 1,211,589 $ 1,099,799 $ 111,790 10.2% $ 11,956,737 $ 13,102,636 $ (1,145,899) (8.7%) $ 13,114,080 91.2% NET PROFIT/(LOSS) $ 234,224 $ 293,907 $ (59,683) (20.3%)l $ 1,964,848 $ 909,485 $ 1,055,363 116.0% $ 1,108,364 177.3% 2022 Gas Division Residential 48,758,250 Commercial 35,800,685 Industrial 75,228,476 2021 45,617,684 32,515,811 76,390,812 Di 3,140,566 3,284,874 (1,162,336) %Chnq 6.88% 10.10% (1.52%) 2022 388,727,115 303,889,074 807,368,273 2021 322,606,990 252,129,511 765,124,672 Di 66,120,125 51,759,563 42,243,601 %Chnq 20.50% 20.53% 5.52% Full YrBud 439,919,000 347,946,000 873,587,000 %of Bud 88.4% 87.3% 92.4% Total CF Sold 159,787,411 154,524,307 5,263,104 3.41% 1,499,984,462 1,339,861,173 160,123,289 11.95% 1,661,452,000 90.3% November November YTD YTD 2022 HUC 2022 2021 Change 2022 2021 Change Budget Target Gross Margin %: 37.7% 43.0% -5.3% 40.5% 32.7% 7.7% 39.9% Operating Income Per Revenue $ (%): 15.6% 19.6% -3.9% 13.8% 6.6% 7.2% 8.2% Net Income Per Revenue $ (%): 16.2% 21.1% -4.9% 14.1% 6.5% 7.6% 7.8% Contracted Customer Rev. per CF: $0.0062 $0.0050 $0.0012 $0.0062 $0.0063 $0.0000 $0.0056 Customer Revenue per CF: $0.0091 $0.0100 -$0.0009 $0.0094 $0.0121 -$0.0026 $0.0088 Total Power Supply Exp. per CF: $0.0054 $0.0049 $0.0006 $0.0053 $0.0068 ($0.0015) $0.0050 $0.0050 November 2022 net income decreased by $59,683 mainly due to the increased purchased gas costs. November 2022 fuel cost credit adjustment was zero for the month and $89,419 YTD. November 2021 fuel cost adjustment was $.75 per MCF which brought in $60,846 for the month with a total of $1,277,158 YTD. HUTCHINSON UTILITIES COMMISSION BALANCE SHEET - CONSOLIDATED NOVEMBER 30, 2022 Electric Gas Total Total Net Change Division Division 2022 2021 Total (YTD) Current Assets UnrestrictedlUndesignated Cash Cash 6,482,426.19 11,706,223.11 18,188,649.30 14,647,324.52 3,541,324.78 Petty Cash 680.00 170.00 850.00 850.00 - Designated Cash Capital Expenditures - Five Yr. CIP 2,750,000.00 700,000.00 3,450,000.00 3,450,000.00 - Payment in Lieu of Taxes 1,293,543.00 573,649.00 1,867,192.00 1,867,192.00 - Rate Stabilization - Electric 395,204.99 - 395,204.99 364,336.05 30,868.94 Rate Stabilization - Gas - 579,822.98 579,822.98 546,216.85 33,606.13 Catastrophic Funds 800,000.00 200,000.00 1,000,000.00 1,000,000.00 - Restticted Cash Bond Interest Payment 2017 699,999.92 - 699,999.92 1,882,856.32 (1,182,856.40) Bond Interest Payment 2012 - 0.02 0.02 2,047,550.00 (2,047,549.98) Debt Service Reserve Funds 522,335.64 2,188,694.02 2,711,029.66 2,711,029.66 - Total Current Assets 12,944,189.74 15,948,559.13 28,892,748.87 28,517,355.40 375,393.47 Receivables Accounts (net of uncollectible allowances) 1,946,893.56 1,317,725.80 3,264,619.36 3,219,818.95 44,800.41 Interest 47,207.51 47,207.50 94,415.01 97,985.30 (3,570.29) Total Receivables 1,994,101.07 1,364,933.30 3,359,034.37 3,317,804.25 41,230.12 Other Assets Inventory 1,691,724.79 514,997.29 2,206,722.08 2,216,324.14 (9,602.06) Prepaid Expenses (322,805.91) 70,171.60 (252,634.31) 133,293.11 (385,927.42) Sales Tax Receivable 208,512.05 - 208,512.05 140,461.73 68,050.32 Deferred Outflows- Electric 1,630,746.00 - 1,630,746.00 313,166.00 1,317,580.00 Deferred Outflows - Gas - 543,582.00 543,582.00 104,390.00 439,192.00 Total Other Assets 3,208,176.93 1,128,750.89 4,336,927.82 2,907,634.98 1,429,292.84 Total Current Assets 18,146,467.74 18,442,243.32 36,588,711.06 34,742,794.63 1,84.5,916.43 Capital Assets Land & Land Rights 690,368.40 3,899,918.60 4,590,287.00 4,590,287.00 - Depreciable Capital Assets 111,117,844.02 42,656,015.41 153,773,859.43 151,834,624.92 1,939,234.51 Accumulated Depreciation (66,836,894.54) (20,172,642.41) (87,009,536.95) (82,718,679.18) (4,290,857.77) Construction - Work in Progress 1,463,763.39 487,581.39 1,951,344.78 2,303,591.24 (352,246.46) Total Net Capital Assets 46,435,081.27 26,870,872.99 73,305,954.26 76,009,823.98 (2,703,869.72) Total Assets 64,581,549.01 45,313,116.31 109,894,665.32 110,752,618.61 (857,953.29) 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 NOVEMBER 30, 2022 Electric Gas Total Division Division 2022 730,000.00 1,692,373.12 0.03 90,938.21 2,513,311.36 13,300,000.00 501,854.40 2,219,565.00 94,162.00 431,660.51 91,639.00 2,041,393.00 18,680,273.91 1,825,000.00 185,608.32 1,194, 321.66 0.02 30,035.77 3,234,965.77 5,955,000.00 556,824.59 739,855.00 31,387.00 163,481.47 31,615.85 680,464.00 8,158,627.91 43,387,963.74 33,919,522.63 43,387,963.74 33,919,522.63 2,555,000.00 185,608.32 2,886,694.78 0.05 120,973.98 5,748,277.13 13,300,000.00 5,955,000.00 1,058,678.99 2,219,565.00 94,162.00 739,855.00 31,387.00 595,141.98 123,254.85 2,041,393.00 680,464.00 26,838,901.82 77,307,486.37 77,307,486.37 Total 2021 2,430,000.00 185,608.32 3,520,937.93 10,999.68 102,213.47 6,249,759.40 14,030,000.00 7,780,000.00 1,277,744.27 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 28,108,566.71 76,394,292.50 76,394,292.50 Net Change Total (YTD) 125,000.00 (634,243.15) (10, 999.63) 18, 760.51 (501,482.27) (730,000.00) (1,825,000.00) (219,065.28) (806,642.00) 10,108.00 (268,881.00) 3,369.00 10,277.61 (1,132.22) 1,917,976.00 639,325.00 (1,269,664.89) 913,193.87 913,193.87 Total Liabilities and Net Position 64,581,549.01 45,313,116.31 109,894,665.32 110,752,618.61 (857,953.29) Hutchinson Utilities Commission Cash -Designations Report, Combined November 30, 2022 Change in Financial Annual Balance, Balance, Cash/Reserve Institution Current Interest Rate Interest November 2022 October 2022 Position Savings, Checking, Investments varies varies varies 28,892,748.87 31,005,263.98 (2,112,515.11) Total Operating Funds 28,892,748.87 31,005,263.98 (2,112,515.11) Debt Reserve Requirements Debt Reserve Requirements Total Restricted Funds Operating Reserve Rate Stabalization Funds PILOT Funds Catastrophic Funds Capital Reserves Total Designated Funds Bond Covenants - sinking fund Bond Covenants -1 year Max. P & I Min 60 days of 2022 Operating Bud. Charter (Formula Only) Risk Mitigation Amount 5 Year CIP (2022-2026 Fleet & Infrastructure Maintenance) 699,999.94 3,302,877.54 (2,602,877.60) 2,711,029.66 2,711,029.66 3,411,029.60 6,013,907.20 (2,602,877.60) 6,432,490.00 6,432,490.00 975,027.97 1,002,657.33 (27,629.36) 1,867,192.00 1,867,192.00 1, 000, 000.00 1, 000, 000.00 3,450,000.00 3,450,000.00 13,724,709.97 13,752,339.33 (27,629.36) YE YE YE YE YTD HUC 2018 2019 2020 2021 2022 Target Debt to Asset 37.7% 34.9% 32.3% 30.8% 29.7% Current Ratio 3.93 5.11 5.67 5.22 5.39 RONA 3.16% 2.25% 3.62% 0.41% 0.84% Change in Cash Balance (From 12131114 to 1113012022) Month End Electric Elec. Change Natural Gas Gas Change Total Total Change 11/30/2022 12, 944,190 15, 948, 559 28, 892, 749 12/31/2021 12,870,253 73,937 15,086,000 862,559 27,956,253 936,496 12/31/2020 14,239,233 (1,368,981) 15,019,173 66,827 29,258,406 (1,302,153) 12/31/2019 12,124,142 2,115,092 13,837,040 1,182,133 25,961,181 3,297,225 12/31/2018 15,559,867 (3,435,725) 12,335,998 1,501,042 27,895,864 (1,934,683) 12/31/2017 23,213,245 (7,653,378) 10,702,689 1,633,309 33,915,934 (6,020,070) 12/31/2016 8,612,801 14,600,444 9,500,074 1,202,615 18,112,875 15,803,059 12/31/2015 6,170,790 2,442,011 9,037,373 462,701 15,208,163 2,904,712 12/31/2014 3,598,821 2,571,969 6,765,165 2,272,208 10,363,986 4,844,177 * 2017's Significant increase in cash balance is due to issuing bonds for the generator project. Hutchinson Utilities Commission Cash -Designations Report, Electric November 30, 2022 Change in Financial Annual Balance, Balance, Cash/Reserve Institution Current Interest Rate Interest November 2022 October 2022 Position Savings, Checking, Investments varies varies Total HUC Operating Funds Debt Restricted Requirements Bond Covenants - sinking fund Debt Restricted Requirements Bond Covenants -1 year Max. P & I Total Restricted Funds varies 28,892,748.87 31,005,263.98 (2,112,515.11) 28,892,748.87 31,005,263.98 (2,112,515.11) 699,999.92 1,542,023.36 (842,023.44) 522,335.64 522,335.64 1,222,335.56 2,064,359.00 (842,023.44) Operating Reserve Min 60 days of 2022 Operating Bud. 4,430,143.33 4,430,143.33 Rate Stabalization Funds $400K-$1.2K 395,204.99 395,204.99 PILOT Funds Charter (Formula Only) 1,293,543.00 1,293,543.00 Catastrophic Funds Risk Mitigation Amount 800,000.00 800,000.00 Capital Reserves 5 Year CIP (2022-2026 Fleet & Infrastructure Maintenance) 2,750,000.00 2,750,000.00 Total Designated Funds 9,668,891.32 9,668,891.32 - Excess Reserves Less Restrictions & Designations, Electric 2,052,962.86 1,851,944.69 201,018.17 YE YE YE YE YTD APPA Ratio HUC 2018 2019 2020 2021 2022 5K-10K Cust. Target Debt to Asset Ratio (* w/Gen.) 35.7% 34.1% 32.6% 32.2% 32.8% 39.8% ONE Current Ratio 3.63 5.26 6.18 5.70 6.08 3.75 RONA -0.3% -0.4% 2.5% -1.2% -1.9% NA >0% Hutchinson Utilities Commission Cash -Designations Report, Gas November 30, 2022 Change in Financial Annual Balance, Balance, Cash/Reserve Institution Current Interest Rate Interest November 2022 October 2022 Position Savings, Checking, Investments varies varies Total HUC Operating Funds Debt Restricted Requirements Bond Covenants - sinking fund Debt Restricted Requirements Bond Covenants -1 year Max. P & I Total Restricted Funds varies 28,892,748.87 31,005,263.98 (2,112,515.11 28,892,748.87 31,005,263.98 (2,112,515.11 0.02 1,760,854.18 (1,760,854.16) 2,188,694.02 2,188,694.02 2,188,694.04 3,949,548.20 (1,760,854.16) Operating Reserve Min 60 days of 2022 Operating Bud. 2,002,346.67 2,002,346.67 Rate Stabalization Funds $200K-$600K 579,822.98 607,452.34 (27,629.36) PILOT Funds Charter (Formula Only) 573,649.00 573,649.00 Catastrophic Funds Risk Mitigation Amount 200,000.00 200,000.00 Capital Reserves 5 Year CIP ( 2022-2026 Fleet & Infrastructure Maintenance) 700,000.00 700,000.00 Total Designated Funds 4,055,818.65 4,083,448.01 (27,629.36) YE YE YE YE YTD HUC 2018 2019 2020 2021 2022 AGA Ratio Target Debt to Asset 40.7% 36.1% 32.0% 28.8% 25.1% 35%-50% Current Ratio 4.33 4.96 5.18 4.79 4.86 1.0-3.0 RONA 8.3% 6.4% 5.3% 2.9% 5.0% 2%-5% HUTCHINSON UTILITIES COMMISSION Investment Report For the Month Ended November 30, 2022 Interest Current Date of Date of Par Current Purchase Unrealized Premium Next Institution Description Rate YTM Purchase Maturity Value Value Amount Gain/(Loss) (Discount) Call Date Wells Fargo Money Market 3.170% 3.170% NA NA - 15,015.00 - - - N/A Wells Fargo US Treasury Note 1.625% 1.414% 06/07/2022 12/15/2022 1,000,000.00 999,270.00 1,001,090.63 (1,820.63) 1,090.63 N/A Wells Fargo US Treasury Note 2.375% 1.677% 06/07/2022 01/31/2023 1,000,000.00 996,910.00 1,004,471.88 (7,561.88) 4,471.88 N/A Wells Fargo US Treasury Note 2.500% 1.942% 06/07/2022 03/31/2023 1,000,000.00 993,270.00 1,004,471.88 (11,201.88) 4,471.88 N/A Wells Fargo US Treasury Note 2.750% 2.128% 06/07/2022 05/31/2023 1,000,000.00 990,890.00 1,006,000.00 (15,110.00) 6,000.00 N/A Wells Fargo FHLB 0.400% 0.587% 01/29/2021 01/29/2026 295,000.00 263,098.70 295,000.00 (31,901.30) - 01/29/2023 Wells Fargo FHLB 0.400% 0.525% 02/09/2021 02/09/2026 470,000.00 417,773.60 470,000.00 (52,226.40) - 02/09/2023 Wells Fargo FHLB 0.750% 1.432% 04/29/2021 04/29/2026 400,000.00 365,908.00 400,000.00 (34,092.00) - 12/29/2022 Wells Fargo FHLB 0.650% 1.069% 06/30/2021 06/30/2026 300,000.00 267,522.00 300,000.00 (32,478.00) - 12/30/2022 Wells Fargo FHLB 0.700% 1.281% 09/30/2021 09/30/2026 250,000.00 223,187.50 250,000.00 (26,812.50) - 12/30/2022 Wells Fargo CD's 2.550% 2.550% 06/17/2022 12/18/2023 245,000.00 239,387.05 245,000.00 (5,612.95) - N/A Wells Fargo CD's 0.300% 0.300% 01/08/2021 01/08/2024 245,000.00 233,105.25 245,000.00 (11,894.75) - N/A Wells Fargo CD's 0.450% 0.450% 04/14/2021 04/15/2024 245,000.00 230,692.00 245,000.00 (14,308.00) - 02/14/2023 Wells Fargo CD's 2.800% 2.800% 06/17/2022 06/17/2024 245,000.00 237,529.95 245,000.00 (7,470.05) - N/A Wells Fargo CD's 0.550% 0.550% 08/02/2021 08/05/2024 245,000.00 228,009.25 245,000.00 (16,990.75) - N/A Wells Fargo CD's 4.800% 4.800% 11/16/2022 11/15/2024 245,000.00 244,468.35 245,000.00 (531.65) - N/A Wells Fargo CD's 1.100% 1.100% 01/31/2022 01/31/2025 245,000.00 225,941.45 245,000.00 (19,058.55) - 01/31/2023 Wells Fargo CD's 1.600% 1.600% 02/23/2022 02/24/2025 245,000.00 227,970.05 245,000.00 (17,029.95) - N/A Wells Fargo CD's 3.100% 3.100% 06/15/2022 06/16/2025 245,000.00 234,514.00 245,000.00 (10,486.00) - N/A Wells Fargo CD's 3.100% 3.100% 06/15/2022 06/16/2025 245,000.00 234,514.00 245,000.00 (10,486.00) - N/A Wells Fargo CD's 3.300% 3.300% 08/26/2022 08/26/2025 245,000.00 235,001.55 245,000.00 (9,998.45) - N/A Wells Fargo CD's 1.000% 1.000% 05/19/2021 05/19/2026 245,000.00 214,994.85 245,000.00 (30,005.15) - N/A Wells Fargo CD's 1.000% 1.000% 07/28/2021 07/28/2026 245,000.00 213,003.00 245,000.00 (31,997.00) - N/A Wells Fargo CD's 1.050% 1.050% 08/08/2021 08/25/2026 238,000.00 207,286.10 238,000.00 (30,713.90) - N/A Wells Fargo CD's 1.000% 1.207% 07/31/2021 07/13/2028 245,000.00 200,414.90 245,000.00 (44,585.10) 12/13/2022 Broker Total 49.7% 9,383,000.00 8,939,676.55 9,399,034.39 (474,372.84) 16,034.39 Cetera Investment Services Money Market 0.350% 0.350% N/A N/A - 30,810.45 - - - N/A Cetera Investment Services Municipal Bonds 3.650% 3.004% 12/20/2018 02/01/2023 250,000.00 249,587.50 256,165.00 (6,577.50) 6,165.00 N/A Cetera Investment Services Municipal Bonds 3.240% 3.240% 11/17/2017 02/15/2023 80,000.00 79,225.60 69,633.48 9,592.12 (10,366.52) N/A Cetera Investment Services Municipal Bonds 3.075% 3.236% 12/20/2018 06/01/2023 50,000.00 49,525.00 49,746.15 (221.15) (253.85) N/A Cetera Investment Services Municipal Bonds 5.290% 2.724% 04/18/2019 06/01/2023 260,000.00 260,546.00 291,059.96 (30,513.96) 31,059.96 N/A Cetera Investment Services Municipal Bonds 2.500% 3.181% 12/20/2018 08/01/2023 35,000.00 34,430.90 34,320.05 110.85 (679.95) N/A Cetera Investment Services Municipal Bonds 3.400% 3.148% 12/20/2018 11/01/2023 125,000.00 122,977.50 126,376.25 (3,398.75) 1,376.25 N/A Cetera Investment Services Municipal Bonds 3.400% 3.148% 12/20/2018 11/01/2023 65,000.00 63,948.30 65,715.65 (1,767.35) 715.65 N/A Cetera Investment Services Municipal Bonds 2.854% 3.173% 12/20/2018 02/01/2024 100,000.00 97,439.00 99,605.96 (2,166.96) (394.04) N/A Cetera Investment Services Municipal Bonds 2.977% 3.246% 12/20/2018 03/15/2024 250,000.00 244,955.00 248,743.99 (3,788.99) (1,256.01) N/A Cetera Investment Services Municipal Bonds 1.940% 1.821% 01/13/2020 05/01/2024 65,000.00 62,626.85 65,570.70 (2,943.85) 570.70 N/A Cetera Investment Services Municipal Bonds 5.742% 3.658% 04/11/2019 08/01/2024 190,000.00 192,650.50 208,924.00 (16,273.50) 18,924.00 N/A Cetera Investment Services Municipal Bonds 2.400% 2.908% 08/05/2022 08/15/2024 50,000.00 48,224.00 50,070.17 (1,846.17) 70.17 N/A Cetera Investment Services Municipal Bonds 2.402% 2.926% 08/05/2022 10/01/2024 125,000.00 120,600.00 124,674.19 (4,074.19) (325.81) N/A Cetera Investment Services Municipal Bonds 2.528% 1.918% 01/13/2020 12/01/2024 100,000.00 95,513.00 102,999.53 (7,486.53) 2,999.53 N/A Cetera Investment Services Municipal Bonds 1.319% 4.407% 09/26/2022 12/01/2024 50,000.00 46,705.00 47,238.35 (533.35) (2,761.65) N/A Cetera Investment Services Municipal Bonds 3.922% 3.429% 12/20/2018 12/01/2024 204,000.00 199,813.92 208,181.10 (8,367.18) 4,181.10 N/A Cetera Investment Services Municipal Bonds 4.400% 3.221% 04/11/2019 07/01/2025 500,000.00 486,460.00 539,101.11 (52,641.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 180,719.80 169,737.95 10,981.85 (35,262.05) N/A Cetera Investment Services Municipal Bonds 3.743% 2.740% 04/18/2019 09/15/2025 215,000.00 209,893.75 228,334.53 (18,440.78) 13,334.53 N/A Cetera Investment Services Municipal Bonds 3.379% 1.934% 08/19/2019 10/01/2025 310,000.00 298,576.50 339,739.18 (41,162.68) 29,739.18 N/A Cetera Investment Services Municipal Bonds 2.727% 2.271% 03/03/2022 12/01/2025 335,000.00 308,762.80 342,781.72 (34,018.92) 7,781.72 N/A Cetera Investment Services Municipal Bonds 5.600% 1.186% 07/28/2020 12/01/2025 45,000.00 46,252.80 55,250.55 (8,997.75) 10,250.55 N/A Cetera Investment Services Municipal Bonds 4.250% 3.258% 04/11/2019 01/01/2026 500,000.00 491,845.00 529,769.03 (37,924.03) 29,769.03 N/A Cetera Investment Services Municipal Bonds 2.420% 1.175% 10/06/2020 03/01/2026 100,000.00 91,236.00 106,734.28 (15,498.28) 6,734.28 N/A Cetera Investment Services Municipal Bonds 1.609% 1.124% 09/24/2020 04/01/2026 285,000.00 257,711.25 292,370.10 (34,658.85) 7,370.10 N/A Cetera Investment Services Municipal Bonds 6.690% 3.356% 04/18/2019 04/15/2026 60,000.00 49,531.20 47,545.20 1,986.00 (12,454.80) N/A Cetera Investment Services Municipal Bonds 5.900% 1.451% 07/28/2020 06/15/2026 75,000.00 77,876.25 93,741.75 (15,865.50) 18,741.75 N/A Cetera Investment Services Municipal Bonds 0.000% 1.415% 08/13/2020 07/01/2026 100,000.00 83,959.00 92,037.00 (8,078.00) (7,963.00) N/A Cetera Investment Services Municipal Bonds 3.250% 2.903% 04/18/2019 08/01/2026 500,000.00 473,025.00 514,790.69 (41,765.69) 14,790.69 N/A Cetera Investment Services Municipal Bonds 2.116% 3.307% 06/07/2022 08/01/2026 75,000.00 68,571.75 71,565.00 (2,993.25) (3,435.00) N/A Cetera Investment Services Municipal Bonds 2.150% 2.203% 07/01/2019 12/01/2026 40,000.00 36,706.40 40,150.64 (3,444.24) 150.64 N/A Cetera Investment Services Municipal Bonds 1.664% 1.150% 08/27/2020 09/01/2026 225,000.00 202,749.75 231,696.00 (28,946.25) 6,696.00 N/A Cetera Investment Services Municipal Bonds 2.375% 1.816% 09/04/2019 12/01/2026 90,000.00 82,515.60 93,395.70 (10,880.10) 3,395.70 N/A Cetera Investment Services Municipal Bonds 2.350% 2.191% 07/01/2019 12/01/2026 500,000.00 457,785.00 505,385.00 (47,600.00) 5,385.00 N/A Cetera Investment Services Municipal Bonds 3.000% 1.991% 08/19/2019 02/01/2027 50,000.00 46,942.50 53,551.00 (6,608.50) 3,551.00 N/A Cetera Investment Services Municipal Bonds 3.150% 2.034% 08/19/2019 03/15/2027 100,000.00 94,616.00 109,138.50 (14,522.50) 9,138.50 N/A Cetera Investment Services Municipal Bonds 3.332% 3.120% 04/18/2019 04/15/2027 500,000.00 472,395.00 507,783.94 (35,388.94) 7,783.94 N/A Interest Current Date of Date of Par Current Purchase Unrealized Premium Next Institution Description Rate YTM Purchase Maturity Value Value Amount Gain/(Loss) (Discount) Call Date Cetera Investment Services Municipal Bonds 3.865% 2.470% 08/19/2019 05/01/2027 55,000.00 54,120.55 60,986.48 (6,865.93) 5,986.48 05/01/2025 Cetera Investment Services Municipal Bonds 3.553% 2.289% 08/19/2019 05/01/2027 55,000.00 52,584.40 60,468.04 (7:88164) 5:468.04 05/01/2026 Cetera Investment Services Municipal Bonds 3.230% 1.828% 08/19/2019 05/15/2027 145,000.00 135,331.40 160,827.31 (25,495.91) 15,827.31 N/A Cetera Investment Services Municipal Bonds 1.925% 1.719% 11/23/2021 06/01/2027 310,000.00 271,048.50 313,447.46 (42,398.96) 3:447.46 Make -Whole Call Cetera Investment Services Municipal Bonds 1.861% 1.254% 06/07/2021 07/01/2027 410,000.00 357,405.20 412,336.71 (54,931.51) 2,336.71 N/A Cetera Investment Services Municipal Bonds 3.000% 3.101% 05/18/2020 09/01/2027 65,000.00 64,941.50 69,180.58 (4,239.08) 4,180.58 09/01/2025 Cetera Investment Services Municipal Bonds 2.817% 2.817% 09/25/2019 10/01/2027 35,000.00 27:433.00 27,969.55 (536.55) (7,030.45) 05/01/2025 Cetera Investment Services Municipal Bonds 1.415% 1.793% 11/23/2021 03/01/2028 100,000.00 84,527.00 98,088.31 (13,561.31) (1:911.69) N/A Cetera Investment Services Municipal Bonds 3.270% 2.141% 08/1 9/201 9 03/15/2028 155,000.00 142,837.15 170,805.09 (27,967.94) 15,805.09 09/15/2027 Cetera Investment Services Municipal Bonds 2.974% 2.574% 11/07/2019 04/01/2028 75,000.00 68,046.00 77,253.00 (9,207.00) 2,253.00 N/A Cetera Investment Services Municipal Bonds 2.125% 1.904% 11/23/2021 06/01/2028 110,000.00 94,248.00 111:525.06 (17,277.06) 1,525.06 N/A Cetera Investment Services Municipal Bonds 2.547% 1.240% 08/10/2021 07/01/2028 125,000.00 111,620.00 136,101.16 (24,481.16) 11,101.16 N/A Cetera Investment Services Municipal Bonds 3.140% 2.004% 08/19/2019 08/01/2028 500,000.00 454,825.00 547,105.00 (92,280.00) 47,105.00 08/01/2027 Cetera Investment Services Municipal Bonds 3.000% 2.199% 05/19/2020 08/15/2028 90,000.00 89,374.50 95,401.80 (6,027.30) 5,401.80 08/15/2025 Cetera Investment Services Municipal Bonds 1.692% 1.813% 11/24/2021 10/01/2028 180,000.00 150,971.40 179,188.74 (28,217.34) (811.26) N/A Cetera Investment Services Municipal Bonds 3.000% 1.942% 08/19/2019 06/01/2029 115,000.00 104,960.50 125,961.80 (21,001.30) 10,961.80 N/A Cetera Investment Services Municipal Bonds 4.000% 3.214% 03/22/2021 09/01/2031 60,000.00 59,669.40 64,292.00 (4,622.60) 4:292.00 0/01/2024 Cetera Investment Services Municipal Bonds 3.500% 2.699% 11/23/2021 OZ01/2033 50,000.00 49,815.00 54,390.44 (4,575.44) 4,390.44 OZ01/2025 Cetera Investment Services Municipal Bonds 3.250% 2.655% 08/19/2019 06/01/2029 75,000.00 75, 114.75 79,860.31 (4,745.56) 4,860.31 02/01/2025 Cetera Investment Services Municipal Bonds 3.125% 2.303% 11/23/2021 10/01/2034 50,000.00 47,603.00 54,773.69 (7,170.69) 4:773.69 04/01/2027 Cetera Investment Services Municipal Bonds 3.125% 2.456% 11/23/2021 02/01/2035 50,000.00 48,573.50 54,236.11 (5,662.61) 4,236.11 02/01/2026 Broker Total 50.3% 9,619,000.00 9,062,759.62 9,967,822.04 (935,872.87) 348,822.04 TOTAL INVESTMENTS 100.0% $ 19,002,000.00 $ 18,002,436.17 $ 19,366,856.43 $ (1R10,245.71) $ 364,856.43 Product Type 11/30/2022 Total Value % of Total 10/31/2022 Total Value % of Total Monthly Change Maturity Less than 1 year 1 - 2 years Current Value $4,886,406.25 2,179,687.20 % 27.1 % 12.1 % ME Money Market $45,825.45 0.3% $45,082.21 0.3% $743.24 CD's 3,406,831.75 18.9% 3,165,696.52 18.0% 241,135.23 2-3years 2,675,623.02 14.9% Government Bonds 5,517,829.80 30.7% 5,491,562.85 31.2% 26,266.95 3-4years 4,324,294.55 24.0% ,.'. Municipal Bonds 9,031,949.17 50.2% 8,916,318.93 50.6% 115,630.24 4-5years 2,153,825.05 12.0% TOTAL $18,002,436.17 100.0% $17,618,660.51 100.0% $383,775.66 5+years 1,782,600.10 9.9% TOTAL $18,002,436.17 100.0% Municipal Bonds Money Market $5,000,000.00 4 886,406 S , 50.2% 0.3% CD's 18.9% $4,500,000.00 $4,324,295 $4,000,000.00 .... ....... ....... ......... ......... ....... $3,500,000.00 .. $ 3, 000, 000.00 ... ..... ..... ..... ..... ..... $2,675,623 ,. $2,500,000.00 ... ... ..... ..... ..... ..... - $2,179,687 $2,153,825 $2,000,000.00 - --- $1,782600 $1,500,000.00 -- - _ -- -- $1,000,000.00 IIII�I $500,00.00 $0.00 .. Less than 1-2years 2-3years 3-4years 4-5years 5+years Government Bonds year 30.7% ELECTRIC DIVISION Operating Revenue November 2022 CLASS AMOUNT KWH /KWH Street Lights $37.98 697 $0.05449 Electric Residential Service $419,228.33 3,852,964 $0.10881 All Electric Residential Service $24,002.01 243,651 $0.09851 Electric Small General Service $142,746.13 1,400,360 $0.10194 Electric Large General Service $569,739.74 6,257,710 $0.09105 Electric Large Industrial Service $590,914.14 7,438,000 $0.07945 Total $1,746,668.33 19,193,382 $0.09100 Power Adjustment $0.00199 Rate Without Power Adjustment $0.08901 Electric Division Year -to -Date M2022$A--t 02021$A--t ■2022KWH110 02021 KWH110 29,000,000 28,000,000 27,000,000 26,000,000 25,000,000 24,000,000 23,000,000 22,000,000 21,000,000 20,000,000 19,000,000 18,000,000 17,000,000 16,000,000 15,000,000 14,000,000 13,000,000 12,000,000 11,000,000 10,000,000 9,000,000 8,000,000 7,000,000 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 0 Street Lights Residential All Elec. Small Gen. Large Gen. Large For Resale Total Resid. Srv. Srv. Industrial NOTE: Sales for resale includes capacity sales and market sales. NATURAL GAS DIVISION Operating Revenue NOVEMBER 2022 CLASS AMOUNT MCF /$ MCF Residential $448,403.52 48,758 $9.19651 Commercial $322,828.23 35,801 $9.01730 Large Industrial $35,127.28 4,287 $8.19391 Large Industrial Contracts $437,012.19 70,941 $6.16022 Total $1,243,371.22 159,787 $7.78143 Fuel Adjustment $0.00000 Rate Without Fuel Adjustment $7.78143 Natural Gas Division Year -to -Date ® 2022 $ Amount 0 2021 $ Amouni ■ 2022 MCF 132021 MCF 13,000,000 12,000,000 11,000,000 10,000,000 9,000,000 8,000,000 7,000,000 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 0 Gas Residential Gas Commercial Large Industrial Large Industrial Total Contracts Monthly Report - Hutchinson Utilities Hutchinson Utilities Commission Commission Year Minimum duration Substation 2022 V Month 11 - November Annual Report? Yes No 5 Maximum duration Top-level Cause Circuit Remove Major Events? IEEE 1366 Statistics Metric Nov 2022 Nov 2021 SAIDI 2.078 None SAIFI 0.013 None CAIDI 159.556 None ASAI 99.995% 100% Momentary Interruptions 0 0 Sustained Interruptions 2 0 Circuit Ranking - Worst Performing Ranked by Outage Count Circuit Substation Fdr#17 Plant 1 Ranked by Customer Interruptions Circuit Substation Fdr#17 Plant 1 Number of Outages 1 Customer Interruptions 96 Ranked by Customer Minutes of Duration Circuit Substation Customer Minutes of Duration Fdr#17 Plant 1 15,456 Historical Monthly SAIDI Chart 5.0 DI values Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov 2021 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 2022 Historical Monthly SAIR Chart 0.030 FI values Causes Ranked by Count Cause Squirrel Contractor -Dig -In Causes Ranked by Duration Cause Contractor -Dig -In Count Duration 15,456 Squirrel 21 Top 2 Outages for the Month Customers Address Interrupted 8th ave 96 SW 3M 1 Customer Minutes of Duration Interruption 161 15,456 21 21 Total Customers Affected for the Month: Average Customers Affected per Outage: Start Date 11 /07/2022 11 /01 /2022 97 48.5 Work Order De9690" 12201 Plant 1 Asphalt Parking Lot 12202 Control Room A/C 12203 Plant 2 Air Dryer 12204 Cooling Tower Repairs 12205 Power Plant Exhaust Fan and Controls 12206 Plant 2 Unilux Boiler Electric Production Total Total Materials Labor Buclizeted Actual Difference $ 150,000.00 $ - $ 150,000.00 $ 120,543.00 $ (29,457.00) 16,000.00 3,000.00 19,000.00 12,130.32 (6,869.68) 16,000.00 3,000.00 $ 19,000,00 29,705.92 $ 10,705.92 175,000.00 - $ 175,000.00 19,352.92 $ (155,647.08) 19,000.00 2,000.00 $ 21,000.00 36,275.84 $ 15,275.84 - $ 146,102.00 � $ 146,102.00 $ 376,000.00 $ 8,000.00 $ 384, 000.00 $ 364,110.00 $ (19,890.00) (1989000 ) Work Order Descr�tion 22103 Feeders 15 & 16 Reconductor 22201 Pole Repair and Replacement 22202 Hutch Sub SCADA 22203 Plant 1 Sub SCADA Relays 22204 3M Sub SCADA 22205 Station Equipment 22206 Right of Way Clearing 22207 Install Duct 22208 Feeder 12A Reconductor 22209 Civil Air Patrol 22210 City Road Projects 22211 New Developments 22212 Feeder12A Reconductor 22213 EV Charging Station Transformer 22214 Transformer Replacements 22215 Transformer New Developments 22216 Meters 22217 LED Conversion Electric Distribution Total Total Materials Labor Bud eted Actual Difference $ 35,000.00 $ 75,000.00 $ 110,000.00 $ 28,056.76 $ (81,943.24) 15,000.00 - 15,000.00 - $ (15,000.00) 125,000.00 - 125,000.00 - $ (125,000.00) 80,000.00 16,000.00 96,000.00 196,096.43 $ 100,096.43 40,000.00 5,000.00 45,000.00 39,946.82 $ (5,053.18) 10,000.00 - 10,000.00 1,767.04 $ (8,232.96) 15,000.00 65,000.00 80,000.00 121,398.88 $ 41,398.88 30,000.00 20,000.00 50,000.00 107,858.20 $ 57,858.20 7,000.00 2,000.00 9,000.00 12,137.70 $ 3,137.70 10,000.00 10,000.00 20,000.00 22,494.62 $ 2,494.62 50,000.00 - 50,000.00 84,998.30 $ 34,998.30 15,000.00 7,000.00 22,000.00 8,659.46 $ (13,340.54) 10,000.00 1,000.00 11,000.00 1,181.73 $ (9,818.27) 40,000.00 14,000.00 54,000.00 - $ (54,000.00) 50,000.00 50,000.00 24,621.35 $ (25,378.65) 30,000.00 - 30,000.00 24,161.58 $ (5,838.42) 175,000.00 35,000.00 210,000.00 190,296.03 $ (19,703.97) $ 737,000.00 $ 250,000.00 $ 987,000.00 $ 863,674.90 $ (123,325.10) Work Order Description 52103 Natural Gas Service Truck 52201 EV Fast Charger 52202 EV Level 2 Charger 52203 Replace #037 Dump Truck 52204 Replace #130 52205 Replace #948 52206 Paint Booth Administrative Total Total Budgeted Actual Difference $ 72,000.00 $ 14,527.35 $ 57,472.65 60,000.00 51,019.00 8,981.00 10,000.00 - 10,000.00 66,950.00 - 66,950.00 75,190.00 - 75,190.00 75,190.00 - 75,190.00 2,000.00 - 2,000.00 $ 361,330.00 $ 65,546.35 $ (295,783.65) Natural Gas Work Order Description Materials Labor 62109 Isolated Main Replacement (Btn Barley & Gler $ 27,500.00 $ 5,000.00 62201 2 12" Valves, Vacuum Purging, Pigging Lat Lint 800,000.00 5,000.00 62202 Specific Gravity Meter 50,000.00 500.00 62203 Pipeline Satellite Imagery 26,500.00 1,000.00 62204 Misc Developments and System Improvemeni 50,000.00 10,000.00 62205 City Projects 15,000.00 6,500.00 62206 50 psig Improvement Project -Distribution 520,000.00 5,000.00 62207 Regulator Station Improvements 20,000.00 5,000.00 62208 50 psig Improvement Project- DRS 230,000.00 1,000.00 62209 Service Lines 57,000.00 35,000.00 62210 Meters, AMI, and All Fittings 150,000.00 4,000.00 62211 Residential Regulators 9,000.00 - 62212 Industrial Metering and Regulation 20,000.00 3,500.00 62213 CP AMI Monitors, AMI Pressure Monitors 50,000.00 3,000.00 $ 2,025,000.00 $ 84,500.00 Total Total Budgeted Actual Difference $ 32,500.00 $ 4,790.12 $ (27,709.88) 805,000.00 254,606.12 (550,393.88) 50,500.00 - (50,500.00) 27,500.00 21,630.00 (5,870.00) 60,000.00 16,077.89 (43,922.11) 21,500.00 27,157.77 5,657.77 525,000.00 - (525,000.00) 25,000.00 - (25,000.00) 231,000.00 - (231,000.00) 92,000.00 67,827.02 (24,172.98) 154,000.00 50,375.93 (103,624.07) 9,000.00 - (9,000.00) 23,500.00 8,747.49 (14,752.51) 53,000.00 10,942.51 (42,057.49) $ 2,109,500.00 $ 462,154.85 $ (1,647,345.15) HUTCHINSON UTILITIES COMMISSION��` Board Action Form �r�turscti mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm Agenda Item: Consideration of 2023 Non -Union Pay Grid Presenter: Jeremy Carter Agenda Item; Type: Time Requested (Minutes): 10 New Business Attachments: Yes BACKGROUND/EXPLANATION OFAGENDA ITEM: Per the objectives of the HUC Compensation Plan for non -union employees, HUC will: a) Establish and maintain a compensation plan that enables HUC to be highly competitive within our defined industry. b) Lead or exceed the market in attracting and retaining qualified, reliable and motivated employees who are committed to quality and excellence for those we serve. c) Ensure, subject to the financial condition of HUC, that employees receive fair and equitable compensation in relation to their individual contributions to HUC's success. To accomplish this, HUC annually considers a market adjustment to the current pay grid based on market statistics. 2022 Statistics below: 1. U.S: CPI-U: 7.1 %, CPI-W: 7.1 %, Mpls/St. Paul CPI-U: 5.3%, CPI-W: 5.7% (Nov.) 2. Social Security: COLA increase for 2023 - 8.7%, 2022 - 5.9% COLA for 2021 - 1.3% 3. Hutchinson Unemployment rate - 1.9% (Oct.) 4. Employee turnover rate - less than 2% 5. Bargaining Unit Increase - 4% 1/1/2022 & 4% 1/1/2023 6. Upper-midwest/other salary market data: Public /Private Sector 3% - 4.87% Attached is the recommended non -union pay grid for 2023 that incorporates a 4% grid shift BOARD ACTION REQUESTED: Approve the proposed 2023 non -union pay grid. Fiscal Impact: $40,000-$67,000 Included in current budget: Yes Budget Change: PROJECT SECTION: Total Project Cost: Remaining Cost: 2022 PAY GRID Between Grades: 6% Range: Starting midpoint: 0 2022 Salary Range Grade Min Mid Max 1 47,100.81 55,343.46 63,586.10 2 49,926.86 58,664.06 67,401.26 3 52,922.47 62,183.91 71,445.34 4 56,097.82 65,914.94 75,732.06 5 59,463.69 69,869.84 80,275.98 6 63,031.51 74,062.03 85,092.54 7 66,813.40 78,505.75 90,198.09 8 70,822.21 83,216.09 95,609.98 9 75,071.54 88,209.06 101,346.57 10 79,575.83 93,501.60 107,427.38 11 84,350.38 99,111.69 113,873.02 12 1 89,411.40 105,058.40 120,705.40 13 94,776.09 111,361.90 127,947.71 14 100,462.65 118,043.61 135,624.58 15 106,490.41 125,126.24 143,762.05 16 112,879.83 13 2,633.80 15 2,387.77 17 119,65 2.62 140,591.84 161,531.05 18 126,831.78 149,027.35 171,222.90 19 1 134,441.69 157,968.99 181,496.28 20 142,508.19 167,447.13 19 2,386.06 21 151,058.68 177,493.95 203,929.22 22 160,122.20 188,143.59 216,164.98 2022 Hourly Rate Range Min Mid Max 22.645 26.607 30.570 24.003 28.204 32.404 25.443 29.896 34.349 26.970 31.690 36.410 28.588 33.591 38.594 30.304 1 35.607 40.910 32.122 37.743 43.364 34.049 40.008 45.966 36.092 42.408 48.724 38.258 44.953 51.648 40.553 47.650 54.747 42.986 50.509 58.031 45.565 53.539 61.513 48.299 56.752 65.204 51.197 60.157 69.116 54.269 63.766 73.263 57.525 67.592 77.659 60.977 71.645 1 82.319 64.635 75.947 87.258 68.514 80.503 92.493 72.624 85.334 98.043 76.982 90.454 103.925 2023 PAY GRID RECOMMENDATION - 4% Increase to Grid Between Grades: 6% Range: Starting midpoint: 0 2023 Salary Range Grade Min Mid Max 1 48,984.84 57,557.20 66,129.54 2 51,923.93 61,010.63 70,097.31 3 55,039.37 64,671.26 74,303.15 4 58,341.73 68,551.54 78,761.34 5 1 61,842.24 72,664.63 83,487.02 6 65,552.77 77,024.51 88,496.24 7 69,485.94 81,645.98 93,806.01 8 73,655.09 86,544.73 99,434.38 9 78,074.40 91,737.42 105,400.44 10 82,758.86 97,241.66 111,724.47 11 87,724.40 103,076.16 118,427.94 12 1 92,987.86 109,260.74 125,533.61 13 98,567.13 115,816.38 133,065.62 14 104,481.15 12 2,765.36 141,049.57 15 110,750.03 130,131.28 149,512.53 16 117,395.03 137,939.15 158,483.28 17 124,438.73 146, 215.51 167,99 2.29 18 131,905.05 154,988.44 178,071.82 19 139,819.35 164, 287.75 188,756.13 20 148, 208.5 2 174,145.01 200,081.50 21 157,101.03 184,593.71 212,086.39 22 166,527.09 195,669.33 224,811.58 2023 Hourly Rate Range Min Mid Max 23.550 27.672 31.793 24.963 29.332 33.701 26.461 31.092 35.723 28.049 32.957 37.866 29.732 34.935 40.138 31.516 37.031 42.546 33.407 39.253 45.099 35.411 41.608 47.805 37.536 44.105 50.673 39.788 46.751 53.714 42.175 49.556 56.937 44.706 52.529 60.353 47.388 55.681 63.974 50.231 59.022 67.812 53.245 62.563 71.881 56.440 66.317 76.194 59.826 70.296 80.766 63.416 74.514 85.611 67.221 78.984 90.748 71.22 53.724 96.193 75.529 88.747 101.965 80.061 94.072 108.082 Positions Grade Positions Grade Purchasing/Inventory Agent 7 Electric Transmission/Distribution Manager 15 Account Supervisor 8 Production Manager 15 Adinlnl li�Uv(: ( nni dun Lw 8 Rec)ay,toi 1adeII (Adni ffR""nidirm0m) Financial Manager 16 Accountant 8 Engineering Services Manager 16 Energy Conservation Administrator 9 Natural Gas Director 17 Computer Systems Analyst 10 General Manager 21 HUTCHINSON UTILITIES COMMISSION��` Board Action Form �r�turscti mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm Agenda Item: 2023 Electric & NG Operating Budgets & 5 Year Capital Improvement Program (CIP) Presenter: Jeremy Carter Agenda Item; Type: Time Requested (Minutes): 10 New Business Attachments: Yes BACKGROUND/EXPLANATION OFAGENDA ITEM: Attached is the final 2023 operating budgets and 5 year (2023-2027) CIP for the Electric and Natural Gas Divisions. At the November meeting on 11-23-22 a high level overview of the 2023 budgets were reviewed and the major changes budgeted from 2022 to 2023 were discussed in detail. Since that time, some additions & reductions have been made on the revenue/expense side of the 2023 electric & natural gas division operating budgets reflected in the final budgets. These adjustments increase the P/L statements bottom line by: (+$160,630) 50% GIS staff position reimbursement - revenue (+$64,074), GRE O & M agreement - expense (+$10,000), Equipment Insurance Premium - expense (-$106,556). On the 5 Year CIP there were no adjustments. Management recommends the Commission approve the final 2023 Operating budgets and 5 - Year CIP Program (2023-2027). As is customary, the 5 - Year CIP changes from year to year and will be reviewed and updated as needed moving into 2023. 0 BOARD ACTION REQUESTED: Approve 2023 Electric and Natural Gas Division Operating Budgets & 5 Yr. CIP FiscalImpact: Included in current budget: No Budget Change: PROJECT SECTION: Total Project Cost: Remaining Cost: COMBINED DIVISIONS (ELECTRIC & NATURAL GAS) Dollar %change YEAR 2019 Actual 2020 Actual 2021 Actual 2022 Budget 2023 Budget Inc/(Decr.) 2022/2023 REVENUES: Customer Sales 35,656,669 33,509,883 38,852,224 36,155,080 .37„.3.30,509 1,175,429 3.25% Sales for Resale 2,773,852 2,709,012 4,221,535 3,692,000 4„230„000 538,000 14.57% Power Cost Adjustments - - - 1,200,000 11.,600„000 400,000 33.33% NU/3rd Party Agreements 1,040,698 1,042,274 1,058,042 1,010,124 71.„354„349 344,225 34.08% Electric Division Transfer 659,783 665,283 682,550 716,383 771.9„51.7 3,134 0.44% Other Revenues 709,652 2,252,960 658,439 513,157 51.7„539 4,382 0.85% Interest Earnings 617,458 737,923 43,805 350,000 50(),00O 150,000 42.86% TOTAL REVENUES: $ 41,458,111 $ 40,917,336 $ 45,516,594 $ 43,636,744 $ 46,251,914 $ 2,615,170 5.99% EXPENSES: Personnel Costs 6,165,652 6,387,327 6,261,814 7,222,143 7„468„587 246,444 3.4% Purchased Power/Gas 19,737,334 18,424,450 23,251,253 19,927,587 271.,566,760 1,639,173 8.2% Transmission 2,856,868 2,136,904 2,845,628 3,325,000 .3 325,000 - 0.0% Generator Fuel/Chemicals 655,943 494,627 1,649,998 1,097,614 11,445,689 348,075 31.7% Depreciation 3,807,479 3,893,093 4,431,549 4,400,000 4„400„000 - 0.0% Transfers (Electric/City) 2,261,207 2,532,475 2,549,742 2,583,875 2„624„053 40,178 1.6% Operating Expense 2,526,166 2,273,824 2,891,417 3,537,815 .3,566,749 28,934 0.8% Debt Interest 1,160,215 1,067,506 983,040 900,907 786,406 (114,501) -12.7% TOTAL EXPENSES: $ 39,170,863 $ 37,210,206 $ 44,864,441 $ 42,994,941 $ 45,183,244 $ 2,188,303 5.09% ELECTRIC DIVISION Dollar %change YEAR 2019 Actual 2020 Actual 2021 Actual 2022 Budget 2023 Budget Inc/(Decr.) 2022/2023 REVENUES: Residential 5,638,725 5,692,685 6,013,886 5,785,565 5,856,154 154 70,589 1.22% Small General 1,949,017 1,767,463 1,875,538 1,826,955 11,799„063 (27,892) -1.53% Large General 7,617,714 7,143,657 7,856,316 7,400,876 7„51.0„203 109,327 1.48% Industrial 9,667,324 8,963,654 9,524,147 8,973,871 8„845,750 (128,121) -1.43% Power Cost Adjustments - - - 1,200,000 11.,600„000 400,000 33.33% Street Lighting 147,456 141,886 137,710 137,977 139„484 1,507 1.09% Sales for Resale 2,773,852 2,709,012 4,221,535 3,692,000 4„230„000 538,000 14.57% Other Revenues 319,841 1,893,902 307,538 222,056 220„505 (1,551) -0.70% Interest Earnings 308,607 368,961 21,851 175,000 250„000 75,000 42.86% TOTAL REVENUES: $ 28,422,536 $ 28,681,220 $ 29,958,520 $ 29,414,300 $ 30,451,159 1,036,859 3.53% EXPENSES: Personnel Costs 4,574,592 4,794,769 4,650,959 5,263,206 5,43.3,804 170,598 3.24% Purchased Power 13,776,294 12,835,939 13,420,688 12,297,526 71.2„862„000 564,474 4.59% Transmission 2,856,868 2,136,904 2,845,628 3,325,000 .3 325,000 - 0.00% Generator Fuel/Chemicals 655,943 494,627 1,649,998 1,097,614 11,445,689 348,075 31.71% Depreciation 2,728,998 2,804,539 3,334,286 3,300,000 91„'91Op„OOp - 0.00% Transfers (Electric/City) 1,766,062 1,958,826 1,976,093 2,010,226 2,038,931 28,705 1.43% Operating Expense 1,758,807 1,535,453 2,110,198 2,106,432 2„3071,206 194,774 9.25% Debt Interest 556,573 531,506 505,606 480,857 452„856 (28,001) -5.82% TOTAL EXPENSES: $ 28,674,137 $ 27,092,563 $ 30,493,456 $ 29,880,861 $ 31,159,486 1,278,625 4.28% r NATURAL GAS DIVISION Dollar %change YEAR 2019 Actual 2020 Actual 2021 Actual 2022 Budget 2023 Budget Inc/(Decr.) 2022/2023 REVENUES: Residential 3,981,709 3,663,453 4,639,771 4,024,211 4„2271,049 196,838 4.89% Commercial 3,417,002 3,050,239 3,807,629 3,412,215 .:: @,5912„91919 120,124 3.52% Contracted Industrial 3,237,722 3,086,848 4,997,227 4,593,410 5,426,467 833,057 18.14% NU/3rd Party Agreements 1,040,698 1,042,274 1,058,042 1,010,124 71.„354„349 344,225 34.08% Electric Division Transfer 659,783 665,283 682,550 716,383 771.9„51.7 3,134 0.44% Other Revenues 389,811 359,058 350,902 291,101 297„034 5,933 2.04% Interest Earnings 308,850 368,961 21,954 175,000 250„000 75,000 42.86% TOTAL REVENUES: $ 13,035,575 $ 12,236,116 $ 15,558,074 $ 14,222,444 $ 15,800,755 1,578,311 11.10% EXPENSES: Personnel Costs 1,591,060 1,592,558 1,610,855 1,958,937 2„034„783 75,846 3.87% Purchased Gas 5,961,040 5,588,511 9,830,566 7,630,061 8„704„760 1,074,699 14.09% Depreciation 1,078,481 1,088,555 1,097,263 1,100,000 Opp„OOp - 0.00% Transfers (City) 495,145 573,649 573,649 573,649 585,122 11,473 2.00% Operating Expense 767,359 738,371 781,219 1,431,383 11.,20:5,543 (165,840) -11.59% Debt Interest 603,642 536,000 477,433 420,050 333„550 (86,500) -20.59% TOTAL EXPENSES: $ 10,496,726 $ 10,117,644 $ 14,370,985 $ 13,114,080 $ 14,023,758 909,678 6.94% Detailed Income Statement Combined Divisions (Electric & Natural OPERATING REVENUES Electric Energy Sales Natural Gas Sales Other Operating Revenues Total Operating Revenues OPERATING EXPENSES Production $ 28,562,552 $ 27,794,087 $ 26,418,356 $ 29,629,132 $ $ 11,080,727 $ 10,636,433 $ 9,800,539 $ 13,444,627 ;; $ $ 1,849,854 $ 1,961,587 $ 1,761,939 $ 1,829,095 $ $ 41,493,133 $ 40,392,107 $ 37,980,835 $ 44,902,854 $ Operations $ 3,510,634 $ 3,170,009 $ 2,924,641 $ 4,281,814 Maintenance Operations $ 409,983 $ 606,236 $ 558,908 $ 770,277 Purchased Power/Gas $ 20,717,620 $ 19,737,334 $ 18,424,450 $ 23,251,253 Other Power Supply $ 543,339 $ 261,556 $ 340,060 $ 319,382 Transmission: Operations $ 2,786,536 $ 3,530,680 $ 2,796,858 $ 3,511,512 Maintenance $ 28,686 $ 29,786 $ 21,001 $ 74,406 Distribution Expense: Operations $ 1,635,183 $ 1,795,547 $ 1,820,741 $ 1,805,178 Maintenance $ 577,200 $ 552,560 $ 613,205 $ 625,624 Customer Accounts Expense $ 421,909 $ 425,636 $ 442,141 $ 437,383 Sales Expense $ 412,606 $ 304,720 $ 340,932 $ 211,320 Administrative & General $ 1,711,878 $ 1,946,234 $ 2,031,234 $ 2,152,987 Depreciation $ 3,804,484 $ 3,807,479 $ 3,893,093 $ 4,431,549 Contribution to the City of Hutchinson $ 1,398,853 $ 1,675,116 $ 1,867,192 $ 1,867,192 Total Operating Expenses $ 37.958.911 $ 37.842.891 $ 36.074.458 $ 43.739.878 Operating Income (Loss) $ NONOPERATING REVENUES (EXPENSES) Interest Income $ Merchandise & Contract Work, Net $ Miscellaneous Income $ Gain (Loss) on Disposal of Assets $ Bond Service Fees $ Bond Premium $ Prior Period Adjustment $ Interest Expense - Customer Deposits $ Interest Expense - Bonds $ Total Nonoperating Revenus (Expenses) $ Net Income (Loss) !dd�9 Gross Profit Gross Margin Operating Margin (%) Net Income (%) of Operating Sales N.I. (%) of Operating Sales (after cap labor) 28,634,697 $ 28,801,421 $ 29,017,244 $ 29,980,654 10,191,668 $ 10,104,500 $ 12,029,836 $ 13,179,855 1.811.523 $ 1.818.050 $ 1.987.600 $ 2.275.266 $ 40,723,971 $ 43,034,680 $ $ 3,315,441 $ 3,242,868 $ 3,846,295 $ 4,473,985 $ 601,351 $ 633,410 $ 733,283 $ 865,150 $ 19,252,477 $ 18,426,340 $ 19,927,587 $ 21,566,760 $ 242,317 $ 252,318 $ 256,354 $ 282,627 $ 3,359,520 $ 3,899,235 $ 4,096,145 $ 4,226,330 $ 74,938 $ 162,096 $ 434,094 $ 88,427 $ 2,300,811 $ 2,260,512 $ 2,483,280 $ 2,546,553 $ 795,121 $ 819,927 $ 730,787 $ 750,933 $ 481,650 $ 499,481 $ 511,067 $ 535,115 $ 486,232 $ 503,007 $ 501,628 $ 496,141 $ 2,032,871 $ 2,232,978 $ 2,237,723 $ 2,165,681 $ 3,925,000 $ 4,100,000 $ 4,400,000 $ 4,400,000 $ 1,867,192 $ 1,867,192 $ 1,867,192 $ 1,904,536 3,534,222 $ 2,549,216 $ 1,906,377 $ 1,162,976 $ 1,902,967 $ 1,824,607 $ 1,009,246 $ 1,133,537 408,996 $ 617,458 $ 737,923 $ 43,805 $ 350,000 $ 350,000 $ 350,000 $ 500,000 12,512 $ (63,841) $ 177,633 $ (38,937);;, $ 1,500 $ (59,500) $ (34,500) $ (60,500) 105,444 $ 138,334 $ 1,686,795 $ 164,760 $ - $ $ $ 64,074 17,853 $ - $ 54,617 $ 85,318 $ - $ $ $ - (925) $ - $ (475) $ (475);;, $ (1,000) $ (500) $ (500) $ (500) 219,065 $ 219,065 $ 219,065 $ 219,065 $ 219,064 $ 219,064 $ 219,064 $ 219,065 (83,203) $ - $ - $ - $ - $ - $ - $ - (6,967) $ (11,818) $ (6,824) $ (356);; $ (100) $ (100) $ (100) $ (100) 1,231,469) $ (1,161,165) $ (1,067,981) $ (983,515),, $ (1,075,007) $ (991,007) $ (901,407) $ (786,906) $ 27,996,798 $ 27,335,600 $ 25,065,918 $ 32,208,644 $ 26,846,044 $ 26,616,266 $ 29,293,758 $ 31,503,279 $ 13,496,336 $ 13,056,507 $ 12,914,917 $ 12,694,210 $ 13,791,844 $ 14,107,705 $ 13,740,923 $ 13,932,496 33% 32966 34% 28966 34% 35% 32966 31% 9% 6% 5% 3% 5% 4% 2% 2% 7% 6% 10% 1% 3.4% 3.3% 1.5% 2.4% - - - - 4.7% 3.7% 4.2% 3.0% 2023 COMBINED INC. STATEMENT 2023 Net Income $ 1,068,670 Capitalized Labor - Production $ 20,000 Capitalized Labor - Distribution $ 198,000 Capitalized Labor - Natural Gas $ 66,500 Combined INC STMNT $ 1,353,170 2023 COMBINED CASH FLOW STATEMENT 2023 Net Income $ 1,068,670 Depreciation $ 4,400,000 Bond Premium $ (185,608) 2023 Total Cap Exp $ (6,022,000) Principal Debt Payments $ (2,555,000) SOE Proceeds $ 88,000 Third -Party Reimbursements $ 1,945,000 Combined Cash Flow $ (1,260,938) 2023 Cap Ex (As necessary) $ Detailed Income Statement Electric Division 2018 2019i 2020 20211�1 2020 2021 2022' 2023 Actual 1 Actual Actual Actual Budget Budget Budget Budget OPERATING REVENUES Energy Sales Revenue Sales - Electric Energy (440, 442, 444) Power Cost Adjustments Other Energy Sales (447) Total Energy Sales Revenue (440, 442, 444, 447) Revenue From Other Sources Revenue From Other Sources (450, 451) Security Lights (454.01) Pole Rental (454.02, 454.03) Total Revenue From Other Sources (450, 451, 454) TOTAL OPERATING REVENUES OPERATING EXPENSES Production Operations Operation Supervison & Engineering (546) Fuel(547) Operating Supplies and Expense (550) Total Production Operations (546, 547, 550) Maintenance Operations Structures (554) Generating Units (554) Other Equipment (554) Total Maintenance Operations (554) Other Power Supply Expense Purchased Power(555) System Control & Load Dispatch (556) Engineering Services (557) Total Other Power Supply Expense (555, 556, 557) Transmission Expense Transmission Expense Operation (560) Transmission Expense Operation (565) Transmission Expense Operation (567) Transmission Expense Maintenance (574) Total Transmission Expense (560, 565, 567, 574) Distribution Expense: Distribution Operation (580, 581, 586, 588, 589) Distribution Maintenance (592, 594, 595, 596, 598) Total Distribution Expense (580 ,581, 586, 588, 589, 592, 594, 595, 596, 598) Customer Service and Collection Meter Reading (902) Collection Expense (903) Bad Debt Write offs (904) Customer Services (906) Total Customer Service and Collection (902, 903, 904, 906) Sales Expense Supervison (911) Misc. Selling Expense (916) Total Sales Expense (911, 916) $23,806,052 $23,139,852 $23,066,242 $23,896,845 $ 24,127,447 $ 24,141,421 $ 24,125,244 $ 24,150,654 $ 1,685,401 $ 1,880,384 $ 643,102 $ 1,510,752 $ 1,500,000 $ 1,300,000 $ 1,200,000 $ 1,600,000 $ 3,071,099 $ 2,773,852 $ 2,709,012 $ 4,221,535 $ 3,007,250 $ 3,360,000 $ 3,692,000 $ 4,230,000 $ 28,562,552 $27,794,087 $26,418,356 $29,629,132 $ 28,634,697 $ 28,801,421 $ 29,017,244 $ 29,980,654 $ 171,831 $ 177,600 $ 31,442 $ 56,300 $ 169,500 $ 88,800 $ 177,600 $ 134,400 $ 11,005 $ 10,905 $ 10,817 $ 10,597 $ 10,000 $ 11,000 $ 11,000 $ 11,000 $ 182,836 $ 188,505 $ 42,259 $ 66,897 $ 179,500 $ 99,800 $ 188,600 $ 145,400 $ 28,745,388 $27,982,592 $26,460,615 $29,696,029 111111 $ 28,814,197 $ 28,901,220 $ 29,205,844 $ 30,126,054 $ 1,689,922 $ 1,791,618 $ 1,691,235 $ 1,648,442 $ 1,788,183 $ 11816,326 $ 11863,414 $ 1,901,362 $ 1,710,866 $ 1,200,463 $ 1,073,484 $ 2,357,038 $ 1,364,758 $ 1,262,790 $ 1,819,233 $ 2,359,623 $ 109,845 $ 177,927 $ 159,922 $ 276,334 $ 162,500 $ 163,752 $ 163,648 $ 213,000 $ 3,510,634 $ 3,170,009 $ 2,924,641 $ 4,281,814 $ 3,315,441 $ 3,242,868 $ 3,846,295 $ 4,473,985 $ 9,583 $ 4,371 $ 18,208 $ 8,636 $ 10,000 $ 10,000 $ 83,000 $ 36,000 $ 293,927 $ 467,394 $ 339,140 $ 507,501 $ 551,351 $ 442,410 $ 353,283 $ 524,150 $ 106,472 $ 134,471 $ 201,561 $ 254,141 $ 40,000 $ 181,000 $ 297,000 $ 305,000 $ 409,983 $ 606,236 $ 558,908 $ 770,277 $ 601,351 $ 633,410 $ 733,283 $ 865,150 $ 14,633,533 $ 13,776,294 $ 12,835,939 $ 13,420,688 $ 13,480,332 $ 12,888,000 $ 12,297,526 $ 12,862,000 $ 543,339 $ 254,249 $ 340,060 $ 319,382 $ 242,317 $ 252,318 $ 256,354 $ 282,627 $ - $ 7,307 $ - $ - $ - $ - $ - $ - $ 15,176,872 $14,037,850 $13,175,998 $13,740,070 $ 13,722,649 $ 13,140,318 $ 12,553,880 $ 13,144,627 $ 169,311 $ 184,831 $ 187,870 $ 197,074 $ 165,000 $ 175,000 $ 190,000 $ 190,000 $ 2,454,965 $ 2,856,868 $ 2,136,904 $ 2,845,628 $ 2,680,000 $ 3,200,000 $ 3,325,000 $ 3,325,000 $ 11,028 $ - $ - $ - $ - $ - $ - $ 40,000 $ 27,843 $ 23,042 $ 9,767 $ 67,769 $ 69,688 $ 115,283 $ 31,094 $ 32,381 $ 2,663,147 $ 3,064,741 $ 2,334,542 $ 3,110,471 1111111 $ 2,914,688 $ 3,490,283 $ 3,546,094 $ 3,587,381 $ 947,724 $ 1,034,834 $ 1,086,352 $ 1,037,787 $ 1,347,183 $ 1,348,396 $ 1,397,146 $ 1,371,030 $ 403,836 $ 333,359 $ 399,505 $ 408,868 $ 414,851 $ 391,536 $ 433,610 $ 447,466 $ 1,351,560 $ 1,368,192 $ 1,485,857 $ 1,446,654 $ 1,762,034 $ 1,739,932 $ 1,830,756 $ 1,818,497 $ 19,421 $ 10,311 $ 4,553 $ 5,101 $ 25,267 $ 26,030 $ 27,071 $ 16,723 $ 155,143 $ 153,784 $ 163,398 $ 172,186 $ 170,182 $ 176,512 $ 178,627 $ 201,993 $ (4,247) $ 17,513 $ 23,567 $ 1,253 $ 5,500 $ 5,500 $ 5,500 $ 4,000 $ 55,986 $ 59,168 $ 61,088 $ 61,655 $ 66,460 $ 68,849 $ 71,298 $ 74,147 $ 226,303 $ 240,776 $ 252,607 $ 240,195 $ 267,408 $ 276,891 $ 282,496 $ 296,863 $ 286,184 $ 181,504 $ 237,281 $ 107,256 $ 333,948 $ 336,281 $ 334,882 $ 307,729 $ 286,184 $ 181,504 $ 237,281 $ 107,256 $ 333,948 $ 336,281 $ 334,882 $ 307,729 Detailed Income Statement Electric Division 2018 2019i 2020 20211�1 2020 2021 2022' 2023 Actual 1 Actual Actual Actual Budget Budget Budget Budget Administrative and General Adminstrative and General Labor (920) Office Supplies and Expenses (921) Outside Services (923) Property Insurance (924) Employee Pension & Benefits (926) Regulatory Expense(928) Misc. General Expense (930) Maint. Of General Plant (935) Total Administrative and General (920, 921, 923, 924, 926, 928, 930, 935) Other Expenses Depreciation Expense(403) Payment in Lieu of Taxes (408) Contribution To City - Roadway Lighting (408) Total Other Expenses (403, 408) TOTAL OPERATING EXPENSES OPERATING INCOME (LOSS) NONOPERATING REVENUES/(EXPENSES) Merchandise & Contract Work, Net Interest Income Misc. Income Interest- Customer Deposits Bond Service Fees Interest Expense - 2017B Bonds Bond Premium Gain (Loss) On Disposal Prior Period Adjustment TOTAL NONOPERATING REVENUES/(EXPENSES) NETINCOME COGS Gross Profit Gross Margin Operating Margin Net Income (%) of Operating Sales Net Income (%) of Operating Sales (after cap labor) $ 454,453 $ 467,610 $ 494,674 $ 492,700 $ 257,839 $ 319,123 $ 251,847 $ 246,645 $ 120,425 $ 95,056 $ 98,403 $ 91,928 $ 114,394 $ 140,368 $ 194,883 $ 328,326 $ 114,255 $ 220,559 $ 229,083 $ 188,880 $ 21,573 $ 6,717 $ 8,459 $ 4,483 $ 82,658 $ 78,492 $ 76,834 $ 93,313 $ 45,218 $ 88,494 $ 94,731 $ 114,195 $ 1,210,816 $ 1,416,419 $ 1,448,914 $ 1,560,471 $ 486,404 $ 505,050 $ 513,307 $ 547,969 $ 281,545 $ 264,901 $ 257,908 $ 279,727 $ 99,306 $ 127,981 $ 116,994 $ 70,014 $ 193,177 $ 333,337 $ 371,596 $ 277,156 $ 206,431 $ 201,276 $ 204,729 $ 210,311 $ 20,000 $ 15,000 $ 15,000 $ 1,000 $ 99,836 $ 100,536 $ 96,336 $ 99,553 $ 74,975 $ 67,359 $ 67,405 $ 45,754 $ 1,461,674 $ 1,615,441 $ 1,643,276 $ 1,531,484 $ 2,770,697 $ 2,728,998 $ 2,804,539 $ 3,334,286 $ 2,900,000 $ 3,000,000 $ 3,300,000 $ 3,300,000 $ 882,327 $ 1,106,279 $ 1,293,543 $ 1,293,543 $ 1,293,543 $ 1,293,543 $ 1,293,543 $ 1,319,414 $ 147,384 $ 73,692 $ - $ - $ - $ - $ - $ - $ 3,800,408 $ 3,908,969 $ 4,098,082 $ 4,627,829 $ 4,193,543 $ 4,293,543 $ 4,593,543 $ 4,619,414 $28,635,906 $27,994,695 $26,516,830 $29,885,038 $ 28,572,735 $ 28,768,967 $ 29,364,504 $ 30,645,130 $ 109,481 $ (12,103) $ (56,215) $ (189,009) $ 241,462 $ 132,253 $ (158,660) $ (519,076) $ (36,559) $ (85,497) $ 79,988 $ (40,569) $ (1,000) $ (70,000) $ (35,000) $ (61,000) $ 204,498 $ 308,607 $ 368,961 $ 21,851 $ 175,000 $ 175,000 $ 175,000 $ 250,000 $ 71,834 $ 68,189 $ 1,667,724 $ 108,497 $ - $ - $ - $ 41,648 $ (4,528) $ (7,681) $ (4,435) $ (232) $ - $ - $ - $ - $ (925) $ - $ (475) $ (475) $ (1,000) $ (500) $ (500) $ (500) $ (562,765) $ (556,573) $ (531,506) $ (505,606) $ (533,657) $ (507,857) $ (480,857) $ (452,856) $ 33,457 $ 33,457 $ 33,457 $ 33,457 $ 33,456 $ 33,456 $ 33,456 $ 33,457 $ 11,789 $ - $ 31,158 $ 37,150 $ - $ - $ - $ - $ (62,402) $ - $ - $ - $ - $ - $ - $ - $ (345,601) $ (239,497) $ 1,644,872 $ (345,928) $ (327,201) $ (369,901) $ (307,901) $ (189,251) $ (236,120) $ (251,600) $ 1,588,657 $ (534,936) $ (85,739) $ (237,648) $ (466,561) $ (708,327) $21,760,635 $20,878,835 $18,994,090 $21,902,632 $ 20,554,129 $ 20,506,879 $ 20,679,552 $ 22,071,143 $ 6,984,752 $ 7,103,757 $ 7,466,525 $ 7,793,396 $ 8,260,068 $ 8,394,341 $ 8,526,292 $ 8,054,911 24.3% 25.4% 28.2% 26.2% 28.791 29.0% 29.2% 26.791 0.4% 0.0% -0.21% -0.64% 0.8% 0.5% -0.5% -1.791 -0.8% -0.9% 6.0% -1.8% -0.3% -0.8% -1.6% -2.4% - - - - 0.5% -0.1% -0.791 -1.6% NET INCOME 2023 Net Income $ (708,327) Cap. Labor - Production $ 20,000 Cap. Labor - Distribution $ 198,000 2022 Net Income $ (490,327) CASH FLOW STATEMENT 2023 Net Income $ (708,327) Depreciation $ 3,300,000 2017B Principal Debt Payment $ (730,000) 2023 Cap Exp $ (2,525,500) SOE Proceeds $ 67,000 2023 Electric Cash Flow $ (596,827) 2023 Cap Exp (As necessary) "9'Ni Detailed Income Statement Natural Gas Division OPERATING REVENUES Energy Sales Revenue Sales - Natural Gas --Retail Contract Sales to Large Customers (Includes 3M & HTI transport) New Ulm, HCP, & UFC Transportation Transportation --Electric Division Total Energy Sales Revenue (440, 442, 444, 447) Revenue From Other Sources Revenue From Other Sources (450,451) Total Revenue From Other Sources (450, 451, 454) TOTAL OPERATING REVENUES OPERATING EXPENSES Purchased Gas $ 7,636,736 $ 7,398,711 $ 6,713,692 $ 8,447,400 $ 7,188,881 $ 7,168,300 $ 7,436,426 $ 7,753,388 $ 3,443,991 $ 3,237,722 $ 3,086,848 $ 4,997,227 $ 3,002,787 $ 2,936,200 $ 4,593,410 $ 5,426,467 $ 940,990 $ 1,040,698 $ 1,042,274 $ 1,058,042 $ 898,640 $ 998,904 $ 1,010,124 $ 1,354,349 $ 656,366 $ 659,783 $ 665,283 $ 682,550 $ 665,283 $ 682,550 $ 716,383 $ 719,517 $ 12,678,083 $12,336,914 $ 11,508,097 $ 15,185,219 $ 11,755,591 $ 11,785,954 $13,756,343 $ 15,253,721 $ 69,663 $ 72,601 $ 12,123 $ 21,606 $ 69,663 $ 72,601 $ 12,123 $ 21,606 $ 12,747,746 $12,409,515 $ 11,520,219 $ 15,206,825 $ 68,100 $ 36,797 $ 72,493 $ 56,OOC $ 68,100 $ 36,797 $ 72,493 $ 56,OOC $ 11,823,691 $11,822,751 $13,828,836 $ 15,309,721 Purchased Gas for Retail (807) $ 3,579,198 $ 3,428,182 $ 3,295,846 $ 5,832,171 $ 3,557,453 $ 3,472,253 $ 3,971,246 $ 4,307,762 Contract Gas for Large Customer (807) $ 2,504,889 $ 2,532,858 $ 2,292,665 $ 3,998,395 $ 2,214,692 $ 2,066,087 $ 3,658,815 $ 4,396,998 Total Purchased Gas $ 6,084,086 $ 5,961,040 $ 5,588,511 $ 9,830,566 $ 5,772,145 $ 5,538,340 $ 7,630,061 $ 8,704,760 Transmission Gas Transmission System Control Operations (851) $ - $ 312,414 $ 246,894 $ 246,339 ;;'' $ 264,102 $ 258,985 $ 307,292 $ 300,398 Gas Transmission Operations (856) $ 151,232 $ 176,567 $ 225,190 $ 222,470 $ 250,417 $ 265,250 $ 273,853 $ 370,932 Gas Transmission Maintenance (863) $ 843 $ 6,744 $ 11,234 $ 6,636 $ 5,250 $ 46,812 $ 403,000 $ 56,045 Total Transmission (851, 856, 863) $ 152,076 $ 495,725 $ 483,317 $ 475,446 $ 519,770 $ 571,047 $ 984,145 $ 727,375 Distribution Operations Supervision and Engineering (870) $ 391,213 $ 438,724 $ 337,127 $ 379,876 ;;'' $ 518,685 $ 458,416 $ 530,632 $ 532,524 Mains and Services (874) $ 103,422 $ 116,806 $ 192,426 $ 131,216 $ 207,000 $ 189,000 $ 258,902 $ 285,053 Meters (878) $ 18,415 $ 13,599 $ 9,854 $ 22,988 $ 29,137 $ 10,000 $ 964 $ 21,023 Misc. (880) $ 174,409 $ 191,585 $ 194,982 $ 233,312 ,; $ 198,806 $ 254,700 $ 295,635 $ 336,923 Total Distribution Operation (870, 874, 878, 880) $ 687,459 $ 760,714 $ 734,390 $ 767,391 $ 953,628 $ 912,116 $ 1,086,134 $ 1,175,523 Distribution Maintenance Lines --Services and Mains (892) $ 110,325 $ 171,156 $ 148,324 $ 141,692 $ 194,516 $ 240,806 $ 210,725 $ 207,309 Meters and House Regulators (893) $ - $ 478 $ 12,377 $ 15,624 $ 25,944 $ 26,280 $ 27,952 $ 29,657 Maintenance of Other Plant (895) $ 63,039 $ 47,567 $ 53,000 $ 59,441 ,; $ 159,810 $ 161,306 $ 58,500 $ 66,500 Total Distribution Maintenance (892, 893, 895) $ 173,364 $ 219,201 $ 213,700 $ 216,757 .' $ 380,270 $ 428,392 $ 297,177 $ 303,467 Customer Service and Collection Meter Reading (902) $ 15,136 $ 5,882 $ 3,656 $ 4,355 ;;'' $ 20,672 $ 21,297 $ 22,149 $ 23,500 Collection Expense (903) $ 125,679 $ 124,877 $ 133,722 $ 141,811 ,,'' $ 149,694 $ 140,462 $ 143,588 $ 153,085 Bad Debt Write offs (904) $ 8,983 $ 5,690 $ 2,175 $ 577 $ 4,500 $ 4,500 $ 4,500 $ 1,000 Customer Services (906) $ 45,808 $ 48,411 $ 49,982 $ 50,445 $ 39,376 $ 56,331 $ 58,335 $ 60,666 Total Customer Service and Collection (902, 903, 904, 906) $ 195,606 $ 184,860 $ 189,534 $ 197,188 $ 214,242 $ 222,590 $ 228,571 $ 238,252 Sales Expense Supervison (911) $ - $ - $ - $ - $ - $ - $ - $ - Misc. Selling Expense (916) $ 126,422 $ 123,216 $ 103,652 $ 104,064 ,; $ 152,284 $ 166,726 $ 166,746 $ 188,412 Total Sales Expense (911, 916) $ 126,422 $ 123,216 $ 103,652 $ 104,064 .' $ 152,284 $ 166,726 $ 166,746 $ 188,412 Administrative and General Adminstrative and General Labor (920) $ 154,594 $ 159,570 $ 169,546 $ 169,114 ;;'' $ 162,134 $ 168,349 $ 171,103 $ 183,010 Office Supplies and Expenses (921) $ 84,274 $ 147,944 $ 98,183 $ 80,642 ,,'' $ 90,310 $ 96,834 $ 95,003 $ 102,776 Outside Services (923) $ 51,315 $ 37,782 $ 41,079 $ 48,668 $ 36,769 $ 55,994 $ 52,332 $ 32,005 Property Insurance (924) $ 32,870 $ 46,071 $ 50,491 $ 75,553 $ 49,399 $ 50,739 $ 54,739 $ 57,155 Employee Pension & Benefits (926) $ 54,889 $ 10,533 $ 91,788 $ 75,880 :,'' $ 73,227 $ 71,092 $ 72,910 $ 74,270 Regulatory Expense (928) $ 35,313 $ 35,996 $ 37,077 $ 35,582 ,,'' $ 40,000 $ 55,000 $ 40,000 $ 85,000 Misc. General Expense (930) $ 55,049 $ 60,497 $ 47,417 $ 75,523 $ 64,558 $ 70,758 $ 59,558 $ 65,558 Maint. Of General Plant (935) $ 32,758 $ 31,422 $ 46,738 $ 31,555 $ 54,800 $ 48,773 $ 48,804 $ 34,425 Total Administrative and General (920, 921, 923, 924, 926, 928, 930, $ 501,062 $ 529,815 $ 582,320 $ 592,516 $ 571,197 $ 617,538 $ 594,447 $ 634,197 Detailed Income Statement Natural Gas Division Other Expenses Depreciation Expense (403) Payment in Lieu of Taxes (408) Total Other Expenses (403, 408) TOTAL OPERATING EXPENSES OPERATING INCOME (LOSS) NONOPERATING REVENUES/(EXPENSES) Merchandise & Contract Work, Net Interest Income Misc. Income Bond Premium Interest Expense - Bonds Interest Expense - Customer Deposits Gain (Loss) On Disposal Prior Period Adjustment TOTAL NONOPERATING REVENUES/(EXPENSES) NETINCOME COGS Gross Profit Gross Margin Operating Margin (%) Net Income (%) of Operating Sales Net Income (%) of Operating Sales (after cap labor) $ 1,033,788 $ 1,078,481 $ 1,088,555 $ 1,097,263 $ 1,025,000 $ 1,100,000 $ 1,100,000 $ 1,100,000 $ 369,142 $ 495,145 $ 573,649 $ 573,649 $ 573,649 $ 573,649 $ 573,649 $ 585,122 $ 1,402,930 $ 1,573,626 $ 1,662,204 $ 1,670,912 $ 1,598,649 $ 1,673,649 $ 1,673,649 $ 1,685,122 $ 9,323,005 $ 9,848,197 $ 9,557,627 $ 13,854,840 $ 10,162,185 $ 10,130,397 $12,660,930 $ 13,657,108 $ 3,424,741 $ 2,561,319 $ 1,962,592 $ 1,351,985 $ 1,661,506 $ 1,692,353 $ 1,167,906 $ 1,652,613 $ 49,071 $ 21,655 $ 97,645 $ 1,632 $ 2,500 $ 10,500 $ 500 $ 500 $ 204,498 $ 308,850 $ 368,961 $ 21,954 $ 175,000 $ 175,000 $ 175,000 $ 250,000 $ 33,610 $ 70,145 $ 19,071 $ 56,263 $ - $ - $ - $ 22,426 $ 185,608 $ 185,608 $ 185,608 $ 185,608 $ 185,608 $ 185,608 $ 185,608 $ 185,608 $ (668,704) $ (604,592) $ (536,475) $ (477,908) $ (541,350) $ (483,150) $ (420,550) $ (334,050) $ (2,439) $ (4,137) $ (2,388) $ (124) $ (100) $ (100) $ (100) $ (100) $ 6,063 $ $ 23,458 $ 48,168 $ - $ - $ - $ - $ (20,801) $ $ - $ - $ - $ - $ - $ - $ (213,093) $ (22,470) $ 155,880 $ (164,407),; $ (178,342) $ (112,142) $ (59,542) $ 124,384 $ 3,211,648 $ 2,538,849 $ 2,118,472 $ 1,187,578 $ 1,483,164 $ 1,580,211 $ 1,108,365 $ 1,776,997 $ 6,236,162 $ 6,456,765 $ 6,071,828 $ 10,306,012 $ 6,291,915 $ 6,109,387 $ 8,614,206 $ 9,432,135 $ 6,511,583 $ 5,952,751 $ 5,448,391 $ 4,900,813 $ 5,531,776 $ 5,713,364 $ 5,214,630 $ 5,877,586 51% 48% 47% 32% 47% 48% 38% 38% 27% 21% 17% 9% 14% 14% 8% 11% 25% 20% 18% 8% 13% 13% 8% 12% - - - - 13% 14% 9% 12% NET INCOME 2023 Net Income $ 1,776,997 Cap. Labor- Nat. Gas $ 66,500 2023 Net Income $ 1,843,497 CASH FLOW STATEMENT 2023 Net Income $ 1,776,997 Depreciation $ 1,100,000 Bond Premium $ (185,608) 2023 Cap Exp $ (3,496,500) 2012A Principal $ (1,825,000) SOE Proceeds $ 21,000 Third -Party Reimbursements $ 1,945,000 2023 Cash Flow $ (664,111) 2023 Cap Exp (As necessary)�� Electric Production Capital Projects Production Capital Budget 2023 Acct # Project List Material Labor Total $ - $ $ 340 Total Account 340 Ladder Access Plant 2 $ 225,000 $ $ 225,000 Power Gates Plant 2 $ 60,000 $ $ 60,000 Cooling Tower Repairs Phase II $ 150,000 $ 20,000 $ 170,000 Plant 1 - Tuck Pointing (Yr. 1 of 3 year project) $ 140,000 $ - $ 140,000 $ 575,000 $ 20,000 $ 595,000 341 Total Account 341 $ $ $ 342 Total Account 342 $ $ $ - 343 Total Account 343 SWOIS Computer Upgrade U5 $ 400,000 $ $ 400,000 Removal of Units 3, 4, 8 $ - $ $ - $ 400,000 $ $ 400,000 344 Total Account 344 Plant 1 Side Stream Filter $ 30,000 $ $ 30,000 Cooling Tower Drain Valves Plant 1 $ 80,000 $ $ 80,000 Cooling Tower Recirculation and Chemical Injection $ 120,000 $ $ 120,000 $ 230,000 $ $ 230,000 345 Total Account 345 $ $ $ 346 Total Account 346 Production Capital Budget 2024 Acct # Project List Material Labor Total $ - $ $ - 340 Total Account 340 Plant 1 - Tuck Pointing (Yr. 2 of 3 year project) $ 145,000 $ $ 145,000 Rubber Roof Repairs - West portion of Plant 1 $ 42,000 $ $ 42,000 Side Stream Filter Building and Chemical Injection $ 250,000 $ 20,000 $ 270,000 Plant 1 Pump Room Ventilation $ 30,000 $ - $ 30,000 Plant 1 Combustable gas detection system $ 100,000 $ - $ 100,000 $ 567,000 $ 20,000 $ 587,000 341 Total Account 341 $ $ $ 342 Total Account 342 $ $ $ - 343 Total Account 343 Plant 1 Control Panel Upgrade $ 100,000 $ $ 100,000 $ 100,000 $ $ 100,000 344 Total Account 344 Aux Boiler Feed Water and Piping Update $ 173,865 $ $ 173,865 Plant 1 North Ground Fans $ 35,000 $ $ 35,000 $ 208,865 1 $ 1 $ 208,865 345 Total Account 345 $ $ $ 346 Total Account 346 Production Capital Budget 2025 Acct # Project List Material Labor Total $ - $ $ 340 Total Account 340 Plant 1 - Tuck Pointing (Yr. 3 of 3 year project) $ 150,000 $ $ 150,000 Unit 1 Boiler House Building Repair $ 150,000 $ 20,000 $ 170,000 Plant 2 Parking Lot Repair $ 175,000 $ - $ 175,000 Plant 1 Camera System $ 100,000 $ $ 100,000 $ 575,000 $ 20,000 $ 595,000 341 Total Account 341 $ $ $ 342 Total Account 342 $ $ $ 343 Total Account 343 $ $ $ - 344 Total Account 344 Plant 2 Automatic Valves Cooling Tower $ 90,000 $ $ 90,000 $ 90,000 $ $ 90,000 345 Total Account 345 $ $ $ 346 Total Account 346 Production Capital Budget 2026 Acct # Project List Material Labor Total $ $ $ 340 Total Account 340 New Roof Switch Gear Building 4160 $ 60,000 $ 10,000 $ 70,000 $ 60,000 $ 10,000 $ 70,000 341 Total Account 341 $ $ $ 342 Total Account 342 $ $ $ 343 Total Account 343 $ $ $ 344 Total Account 344 $ 1 $ 1 $ 345 Total Account 345 $ $ $ 346 Total Account 346 Production Capital Budget 2027 Acct # Project List Material Labor Total $ $ $ 340 Total Account 340 New Roof Switch Gear Building (Sub -Stations) $ 140,000 $ $ 140,000 $ 140,000 $ $ 140,000 341 Total Account 341 $ $ $ 342 Total Account 342 $ $ $ 343 Total Account 343 $ $ $ 344 Total Account 344 $ 1 $ 1 $ 345 Total Account 345 $ $ $ $ $ $ 346 Total Account 346 Electric Transmission Capital Projects Electric Transmission Capital Expenditure Programming 110 2023 2024 2025; 2026 2027 350 352 353 354 355 356 357 358 $ $ $ 200,000 $ 15,000 $ - $ $ $ $ $ $ 125,000 $ 15,000 $ - $ $ $ $ $ $ $ 15,000 $ - $ $ $ $ $ $ $ 15,000 $ - $ $ $ $ $ $ 10,000 $ 15,000 $ - $ $ $ $ - $ - $ 335,000 $ 75,000 $ - $ $ $ TcrYal 25;t10(1 1401,040 15;t140 15,t140 25;a40 46;t10(1- TRANSMISSIONELECTRIC Acct # Project List Material Labor Total 350 $ $ 352 $ $ $ 353 Hutch Sub Trans. Upgrade - Engineering $ 200,000 $ $ 200,000 354 Pole Repair or Replacement $ 15,000 $ $ 15,000 355 $ $ $ - 356 $ $ $ 357 $ $ $ 358 TRANSMISSIONELECTRIC $ $ $ Acct # Project List Material Labor Total 350 $ $ $ 352 $ $ $ - 353 McLeod Sub Relay Replacement Total Account 353 $ 125,000 $ $ 125,000 $ 125,000 $ $ 125,000 354 Pole Repair Replacement $ 15,000 $ $ 15,000 355 $ $ $ - 356 $ $ $ 357 $ $ $ 358 TRANSMISSIONELECTRIC $ $ $ Acct # Project List Material Labor Total 350 $ $ $ 352 $ $ $ 353 Total Account 353 $ $ $ - 354 Pole Repair Replacement $ 15,000 $ $ 15,000 355 $ $ $ - 356 $ $ $ 357 $ $ $ 358 TRANSMISSIONELECTRIC $ $ $ Acct # Project List Material Labor Total 350 $ $ $ 352 $ $ $ 353 Total Account 353 $ $ $ - 354 Pole Repair Replacment $ 15,000 $ $ 15,000 355 $ - $ $ - 356 $ $ $ 357 $ $ $ 358 TRANSMISSIONELECTRIC $ $ $ Acct # Project List Material Labor Total 350 $ $ $ 352 $ $ $ - 353 McLeod Substation Batteries Total Account 353 $ 10,000 $ $ 10,000 $ 10,000 $ $ 10,000 354 Pole Repair Replacment $ 15,000 $ $ 15,000 355 $ - $ $ - 356 $ $ $ 357 $ $ $ 358 $ $ $ Electric Distribution Capital Projects Elect �ic ale utloh Gapita Xpen" I 're Prof�ramm rrg 2�?2'3 2 . ... 2 . ...... 2 6 2-02" 360 $ $ $.... _.... $ $ 361 $ $ $ $ $ - $ 362 $ 185,000 $ 10,000 $ 10,000 $ 10,000 $ 30,000 $ 245,000 364 $ - $ - $ $ - $ - $ - 365 $ 15,000 $ - $ - $ - $ - $ 15,000 366 $ 83,000 $ 83,000 $ 83,000 $ 83,000 $ 83,000 $ 415,000 367 $ 199,000 $ 167,000 $ 185,000 $ 60,000 $ 60,000 $ 671,000 368 $ 132,000 $ 122,000 $ 122,000 $ 122,000 $ 122,000 $ 620,000 369 $ - $ - $ - $ - $ - $ - 370 $ 36,000 $ 36,000 $ 36,000 $ 36,000 $ 36,000 $ 180,000 371 $ 1,000 $ 1,000 $ 1,000 $ 1,000 $ 1,000 $ 5,000 373 $ 225,000 1 $ 210,000 $ 210,000 1 $ 210,000 $ 210,000 1 $ 1,065,000 Total 876;at)tl" 629;aflft 64 ";aaa 522,af►ft 54 ,4►fla 3, 16;pf1f1 DISTRIBUTIONELECTRIC Acct # Project List Material Labor Total 360 $ $ $ 361 1HTI $ $ $ 362 3M Sub SCADA - Phase II Sub SCADA Station Equipment Total Account 362 $ $ $ 50,000 125,000 10,000 $ $ $ $ $ $ 50,000 125,000 10,000 $ 185,000 $ $ 185,000 364 $ $ $ $ - $ $ - 365 Right of way Clearing $ 15,000 $ $ 15,000 366 Install Duct $ 18,000 $ 65,000 $ 83,000 367 Fdr 16 Reconductor APR Development (North of 202nd Circle NW) New Developments Total account 367 $ $ $ 42,000 15,000 60,000 $ $ $ 75,000 7,000 - $ $ $ 117,000 22,000 60,000 $ 117,000 $ 82,000 $ 199,000 368 APR Development (North of 202nd Circle NW) Transformer Replacements Transformer New Developments Total Account 368 $ $ $ $ 8,000 48,000 60,000 - $ $ $ $ 2,000 14,000 - $ $ $ 1 $ 10,000 62,000 60,000 $ 116,000 $ 16,000 $ 132,000 369 $ - $ - $ - 370 Meters Total Account 370 $ 36,000 $ $ 36,000 $ 36,000 $ $ 36,000 371 Installation on Customer Premises (Security Lights) $ 1,000 $ $ 1,000 373 Roberts Road Lights LED St light Conversion Total account 373 $ $ 15,000 175,000 $ 35,000 $ $ 15,000 210,000 $ 190,000 1 $ 35,000 1 $ 225,000 Tow, Cedric f istributic�n Capitia�Budgef 07 Mf1f1 198;aflft 876;af►ft DISTRIBUTIONELECTRIC Acct # Project List Material Labor Total 360 $ - $ $ 361 $ $ 362 Station Equipment Total Account 362 $ $ 10,000 $ $ $ 10,000 $ 10,000 $ $ 10,000 364 $ $ $ 365 Right of way Clearing $ $ $ - 366 Install Duct $ 18,000 $ 65,000 $ 83,000 367 Fdr #22 Loop New Developments Total account 367 $ $ 72,000 60,000 $ $ 35,000 - $ $ 107,000 60,000 $ 132,000 $ 35,000 $ 167,000 368 Transformer Replacements Transformer New Developments Total Account 368 $ $ 48,000 60,000 $ $ 14,000 - $ $ 62,000 60,000 $ 108,000 $ 14,000 $ 122,000 369 $ - $ - $ - 370 Meters Total Account 370 $ 36,000 $ $ 36,000 $ 36,000 $ $ 36,000 371 Installation on Customer Premises (Security Lights) $ 1,000 $ $ 1,000 373 LED Conversion $ 175,000 $ 35,000 $ 210,000 ata tiecttic Bisttibutfon Capital B009011 480,4100 149;afltt 629;afltt DISTRIBUTIONELECTRIC Acct # Project List Material Labor Total 360 $ - $ $ 361 $ $ - 362 Station Equipment Total Account 362 $ 10,000 $ $ 10,000 $ 10,000 $ $ 10,000 364 $ $ $ 365 Right of way Clearing $ $ $ - 366 Install Duct $ 18,000 $ 65,000 $ 83,000 367 Energy Park New Developments Total account 367 $ $ $ 90,000 - 60,000 $ $ $ 35,000 $ $ $ 125,000 60,000 $ 150,000 $ 35,000 $ 185,000 368 Transformer Replacements Transformer New Developments Total Account 368 $ $ 48,000 60,000 $ $ 14,000 - $ $ 62,000 60,000 $ 108,000 $ 14,000 $ 122,000 369 $ - $ - $ - 370 Meters Total Account 370 $ 36,000 $ $ 36,000 $ 36,000 $ $ 36,000 371 lInstallation on Customer Premises (Security Lights) $ 1,000 $ $ 1,000 373 ILED Conversion $ 175,000 $ 35,000 $ 210,000 t dtai ECectt,d b1sttib4dd Capital Budget 49 �4►f1f1 149;aflft 647;aflft ELECTRIC DISTRIBUTION PLANT 2026 Acct # Project List Material Labor Total 360 $ - $ $ 361 $ $ 362 Station Equipment Total Account 362 $ $ 10,000 - $ $ $ $ 10,000 $ 10,000 $ $ 10,000 364 $ $ $ 365 Right of way Clearing $ $ $ - 366 Install Duct $ 18,000 $ 65,000 $ 83,000 367 New Developments Total account 367 $ 60,000 $ $ 60,000 $ 60,000 $ $ 60,000 368 Transformer Replacements Transformer New Developments Total Account 368 $ $ 48,000 60,000 $ $ 14,000 - $ $ 62,000 60,000 $ 108,000 $ 14,000 $ 122,000 369 $ - $ - $ - 370 Meters Total Account 370 $ 36,000 $ $ 36,000 $ 36,000 $ $ 36,000 371 lInstallation on Customer Premises (Security Lights) $ 1,000 $ $ 1,000 373 ILED Conversion $ 175,000 $ 35,000 $ 210,000 ta!,ECectric istributidnCapita Budget" 44 �41f1f1 114,aE►ft 522'000, ELECTRIC DISTRIBUTION PLANT 2027 Acct # Project List Material Labor Total 360 $ - $ $ 361 13M/Plant $ $ - 362 Station Equipment #1 Substation Batteries Total Account 362 $ $ 10,000 20,000 $ $ $ $ 10,000 20,000 $ 30,000 $ $ 30,000 364 $ $ $ 365 Right of way Clearing $ $ $ - 366 Install Duct $ 18,000 $ 65,000 $ 83,000 367 New Developments Total account 367 $ 60,000 $ $ 60,000 $ 60,000 $ $ 60,000 368 Transformer Replacements Transformer New Developments Total Account 368 $ $ 1 $ 48,000 60,000 - $ $ $ 14,000 - - $ $ $ 62,000 60,000 $ 108,000 $ 14,000 $ 122,000 369 $ - $ - $ - 370 Meters Total Account 370 $ 36,000 $ $ 36,000 $ 36,000 $ $ 36,000 371 lInstallation on Customer Premises (Security Lights) $ 1,000 $ $ 1,000 373 ILED Conversion $ 175,000 $ 35,000 $ 210,000 ta!,ECecft,-k tributic�nCapita Budget" 114,aE►ft 542;af►ft Administrative - Electric Division General Plant Capital Expenditure Programming 2023 2024 2025 2026 2027 389 $ $ $ $ $ $ 390 $ $ $ $ $ $ 391 $ $ $ $ $ $ 392 $ 420,000 $ 60,000 $ 111,000 $ 250,000 $ 426,000 $ 1,267,000 393 $ - $ - $ - $ - $ - $ - 394 $ 7,500 $ $ $ $ $ 7,500 395 $ - $ $ $ $ $ - 396 $ $ $ $ $ $ 397 $ $ $ $ $ $ 399 $ $ $ $ $ $ Administrative 2023 Acct # Project List Electric Gas Total 389 $ $ $ 390 $ $ $ 391 Total Account 391 $ $ $ 392 International 4900 w/Altec 2010 Dodge Dakota (995) 2012 Dodge Ram 1500 (226) Single Reel Trailer Total Account 392 $ 310,000 $ 35,000 $ 55,000 $ 20,000 $ $ $ $ $ $ $ $ 310,000 35,000 55,000 20,000 $ 420,000 $ $ 420,000 393 Total Account 393 $ - $ - 394 Underground Locator Total Account 394 $ 7,500 $ $ 7,500 $ 7,500 $ $ 7,500 395 $ - $ $ - 396 $ $ $ 397 $ $ $ 399 $ $ $ Administrative 2024 Acct # Project List Electric Gas Total 389 $ $ $ 390 $ $ $ 391 Total Account 391 $ $ $ - 392 2014 GMC Sierra 4WD Ext Cab TRK 181 E 2014 GMC Sierra 4WD Ext Cab TRK 376 Total Account 392 $ 30,000 $ 30,000 $ $ $ 30,000 $ 30,000 $ 60,000 $ $ 60,000 393 Total Account 393 $ $ $ 394 Total Account 394 $ $ $ 395 $ $ $ 396 $ $ $ 397 $ $ $ 399 $ $ $ Administrative 2025 Acct # Project List Electric Gas Total 389 $ $ $ 390 $ $ $ 391 Total Account 391 $ $ $ 392 Vac Machine (Ring o matic) Truck 881 2013 Chevrolet 4 X 4 1 Total Account 392 $ 75,000 $ 36,000 $ $ $ 75,000 $ 36,000 $ 111,000 $ $ 111,000 393 Total Account 393 $ $ $ 394 Total Account 394 $ $ $ 395 $ $ $ 396 $ $ $ 397 $ $ $ 399 $ $ $ Administrative 2026 Acct # Project List Electric Gas Total 389 $ $ $ 390 391 Total Account 391 $ $ $ 392 1999 Freightliner Bucket truck 72' #454 Total Account 392 $ 250,000 $ $ 250,000 $ 250,000 $ $ 250,000 393 Total Account 393 $ $ $ 394 Total Account 394 $ $ $ 395 $ $ $ 396 $ $ $ 397 $ $ $ 399 $ $ $ TMORW General Plant 2027 Acct # Project List Electric Gas Total 389 $ $ $ 390 391 Total Account 391 $ $ $ 392 2017 Ford Versa lift Bucket truck #110 Directional Drill 2014 Vactron #270 1 Total Account 392 $ 170,000 $ 180,000 $ 76,000 $ $ $ $ 170,000 $ 180,000 $ 76,000 $ 426,000 $ $ 426,000 393 Total Account 393 $ $ $ 394 Total Account 394 $ $ $ 395 $ $ $ 396 $ $ $ 397 $ $ $ 399 $ $ $ Gas Transmission Capital Projects Gas Transmission Capital Expenditure Programming Totals 2023 2024 2025 2026 2027 Account# 365 $ $ $ $ $ $ 366 $ $ $ $ $ $ 367 $ $ $ $ $ $ 368 $ $ $ $ $ $ 369 $ 1,898,000 $ $ $ $ $ 1,898,000.00 370 $ 61,000 $ $ $ $ $ 61,000.00 371 $ - $ $ $ $ $ Total $ 1,959,000 $ $ $ $ $ 1,959,000.00 GAS TRANSMISSION PLANT Acct # Project List Material Labor 365-0100 $ 366-0100 $ 367-0100 $ 368-0100 $ 369-0100 FICP Interconnect RNG Interconnect Fairfax Interconnect - Downsize Total $ 875,000 $ 950,000 $ 65,000 $ 3,000 $ 4,000 $ 1,000 $ 878,000 $ 954,000 $ 66,000 $ 1,890,000 $ 8,000 $ 1,898,000 370-0100 SCADA for HCP Interconnect SCADA for RNG Interconnect Total $ 27,500 $ 27,500 $ 3,000 $ 3,000 $ 35 500 $ 30,500 $ 55,000 $ 6,000 $ 61,000 371-0100 $ - Total Gas Transmission Capital Budget2023 $ 1,945,000 $ 14,000 $ 1,959,000 GAS TRANSMISSION PLANT Acct # Project List Material Labor Total 365-0100 $ 366-0100 $ 367-0100 $ $ $ 368-0100 $ 369-0100 370-0100 $ 371-0100 $ Total Gas Transmission Capital Budget 2024 $ $ $ GAS TRANSMISSION PLANT 11111 Acct # Material Labor Total 365 $ $ $ 366 $ $ $ 367 $ $ $ 368 $ $ $ 369 $ $ $ 370 $ $ $ 371 $ $ $ Total Gas Transmission Capital Budget 2025 $ $ $ GAS TRANSMISSION PLANT Acct # Project List Material Labor Total 365 $ $ $ 366 $ $ $ 367 $ 368 $ $ $ 369 $ $ $ 370 $ $ $ 371 $ $ $ Total Gas Transmission Capital Budget 2026 $ $ $ GAS TRANSMISSION PLANT Acct # Project List Material Labor Total 365 NA $ $ $ 366 NA $ $ $ 367 NA $ $ $ 368 NA $ $ $ 369 NA $ $ $ 370 NA $ $ $ 371 NA $ $ $ Total Gas Transmission Capital Budget 2027 $ $ $ Gas Distribution Capital Projects Gas Distribution Capital Expenditure Programming Totals Account# 2023 2024 2025 2026 2027 376 $ 813,500 $ 93,000 $ 93,500 $ 63,500 $ 60,000 $ 1,123,500 378 $ 301,000 $ 25,000 $ 25,000 $ 18,000 $ - $ 369,000 379 $ - $ - $ - $ - $ - $ - 380 $ 72,000 $ 72,500 $ 72,500 $ 70,000 $ 87,200 $ 374,200 381 $ 169,000 $ 260,000 $ 260,000 $ 210,000 $ 210,000 $ 1,109,000 383 $ 9,000 $ - $ - $ - $ - $ 9,000 385 $ 28,500 $ 28,500 $ 28,500 $ $ $ 85,500 386 $ - $ - $ - $ $ $ - 387 $ 53,000 $ 28,000 $ 23,000 $ 8,000 $ $ 112,000 Total $ 1,446,000 $ 507,000 $ 502,500 $ 369,500 $ 357,200 $ 3,182,200 GAS DISTRIBUTION PLANT 2023 Acct # Project List Material Labor Total 376 376 Misc Developments & System Improvements City Projects 50 psig Improvement Project - Distribution Main/Fittings Isolated Main Replacement (Between Barley & Glenda Ln) Total $50,000.00 $15,000.00 $700,000.00 $27,500.00 $792,500.00 $10,000.00 $3,000.00 $3,000.00 $5,000.00 $21,000.00 $60,000.00 $18,000.00 $703,000.00 $0.00 $32,500.00 $813,500.00 378 Improvements to Regulator Stations 50 psig Improvement Project - DRS Total $ 20,000.00 $ 275,000.00 $ 5,000.00 $ 1,000.00 $ 2570.00 $ 276,000.00 $ 295,000.00 $ 6,000.00 $ 301,000.00 379 $ - $ - $ - 380 Service Lines $ 57,000.00 $ 15,000.00 $ 72,000.00 381 Meters, AMI and All Fittings $ 165,000.00 $ 4,000.00 $ 169,000.00 383 Residential Regulators $ 9,000.00 $ - $ 9,000.00 385 Industrial Metering and Regulation $ 25,000.00 $ 3,500.00 $ 28,500.00 386 $ - $ - $ - 387 Cp AMI Monitors, AMI Pressure Monitors, Methane Detector $ 50,000.00 $ 3,000.00 $ 53,000.00 Total Gas Distribution Capital Budget 2023 $1,393,500.001 $52,500.001 $1,446,000.00 GAS DISTRIBUTION PLANT 2024 Acct # Project List Material Labor Total 376 Misc Developments & System Improvements City Projects Total $ $ 65,000.00 15,000.00 $ 10,000.00 $ 3,000.00 $ 75,000.00 $ 18,000.00 $ 80,000.00 $ 13,000.00 $ 93,000.00 378 Improvements to Regulator Stations $ 20,000.00 $ 5,000.00 $ 25,000.00 379 $ - $ - $ - 380 Service Lines $ 57,500.00 $ 15,000.00 $ 72,500.00 381 Meters, AMI and All Fittings, Replace AMI Modules $ 250,000.00 $ 10,000.00 $ 260,000.00 383 $ - $ - $ - 385 Industrial Metering and Regulation $ 25,000.00 $ 3,500.00 $ 28,500.00 386 $ - $ - $ - 387 Cathodic Protection Monitoring Equipment Leak Detector $ 25,000.00 $ 3,000.00 $ 28,000.00 Total Gas Distribution Capital Budget 2024 $ 457,500.00 $ 49,500.00 $ 507,000.00 GAS DISTRIBUTION PLANT 2025 Acct # Project List Material Labor Total 376 Misc. Developments & System Improvements City Projects Total $ 65,000.00 $ 15,000.00 $ 10,000.00 $ 3,500.00 $ 75,000.00 $ 18,500.00 $ 80,000.00 $ 13,500.00 $ 93,500.00 378 Improvements to Regulator Stations $ 20,000.00 $ 5,000.00 $ 25,000.00 379 $ - $ - $ - 380 Service Lines $ 57,500.00 $ 15,000.00 $ 72,500.00 381 Meters, AMI and All Fittings, Replacment AMI Modules $ 250,000.00 $ 10,000.00 $ 260,000.00 383 $ - $ - $ - 385 Industrial Metering and Regulation $ 25,000.00 $ 3,500.00 $ 28,500.00 386 $ - $ $ - 387 Cathodic Protection Monitoring Equipment $ 20,000.00 $ 3,000.00 $ 23,000.00 Total Gas Distribution Capital Budget 2025 $ 452,500.00 $ 50,000.00 $ 502,500.00 GAS DISTRIBUTION PLANT 2026 Acct # Project List Material Labor Total 376 Misc. Developments & System Improvements City Projects Total $ 50,000.00 $ 5,000.00 $ 7,500.00 $ 1,000.00 $ 57,500.00 $ 6,000.00 $ 55,000.00 $ 8,500.00 $ 63,500.00 378 Improvements to Regulator Stations $ 15,000.00 $ 3,000.00 $ 18,000.00 379 $ - $ - $ - 380 Service Lines $ 55,000.00 $ 15,000.00 $ 70,000.00 381 Meters, AMI and All Fittings, Replacement AMI Modules $ 200,000.00 $ 10,000.00 $ 210,000.00 383 $ - $ - $ - 385 $ $ $ 386 $ $ $ - 387 Leak Detector $ 8,000.00 $ $ 8,000.00 Total Gas Distribution Capital Budget 2026 $ 333,000.00 $ 36,500.001$ 369,500.00 GAS DISTRIBUTION PLANT 2027 Acct # Project List Material Labor Total 376 Misc. Developments & System Improvements City Projects Total $ 50,000.00 $ 2,000.00 $ 7,500.00 $ 500.00 $ 57,500.00 $ 2,500.00 $ 52,000.00 $ 8,000.00 $ 60,000.00 378 $ - $ - $ - 379 $ - $ - $ - 380 Service Lines $ 55,000.00 $ 32,200.00 $ 87,200.00 381 Meters, AMI and All Fittings, Replacement AMI Modules $ 200,000.00 $ 10,000.00 $ 210,000.00 383 $ - $ - $ - 385 $ $ $ 386 $ $ $ 387 $ $ $ - Total Gas Distribution Capital Budget 2027 $ 307,000.00 $ 50,200.00 $ 357,200.00 Administrative ADMINISTRATION 2023 Acct N Project List Electric Natural Gas Total Replace Vehicle 037 - Dump Truck (Per Schedule) $ - $ 74,000.00 $ 74,000.00 392 Replace Vehicle 948 - Cab & Chassis +Utility Body (Per Schedule) $ - $ 84,000.00 $ 84,000.00 $ - $ 158,000.00 $ 158,000.00 Annual Vehicle Budget 393 $ $ $ $ - $ - $ - Total Account 393 394 $ $ $ $ - $ - $ - Total Account 394 Total Administration Capital Budget 2023 $ - $ 158,000.00 $ 158,000.00 ADMINISTRATION 2024 Acct N Project List Electric Natural Gas Total 389 $ $ $ $ - $ - $ - Total Acccount 389 390 $ $ $ $ - $ - $ - Total Account 390 $ $ $ 391 $ - $ - $ - Total Account 391 Replace Vehicle #113 $ 42,500.00 $ 42,500.00 392 $ - $ 42,500.00 $ 42,500.00 Total Account 392 393 $ $ $ $ - $ - $ - Total Account 393 397 $ $ $ $ - $ - $ - Total Account 397 Total Administration Capital Budget 2024 $ - $ 42,500.00 $ 42,500.00 ADMINISTRATION 2025 Acct N Project List Electric Natural Gas Total 389 $ $ $ $ - $ - $ - Total Acccount 389 390 $ $ $ $ - $ - $ - Total Account 390 391 $ $ $ $ - $ - $ - Total Account 391 Replace Vehicle #451, Welding Truck $ - $ 105,000.00 $ 105,000.00 392 $ $ $ $ - $ 105,000.00 $ 105,000.00 Total Account392 393 $ $ $ $ - $ - $ - Total Account 393 394 $ $ $ $ - $ - $ - Total Account 394 395 $ $ $ $ - $ - $ - Total Account 395 Total Administration Capital Budget 2025 $ - $ 105,000.00 $ 105,000.00 ADMINISTRATION 2026 Acct N Project List Electric Natural Gas Total 389 $ $ $ $ - $ - $ - Total Acccount 389 390 $ $ $ $ - $ - $ - Total Account 390 391 $ $ $ $ - $ - $ - Total Account 391 Total Administration Capital Budget 2026 $ - $ - $ - ADMINISTRATION 2027 Acct N Project List Electric Natural Gas Total 389 $ $ $ $ - $ - $ - Total Acccount 389 390 $ $ $ $ - $ - $ - Total Account 390 391 $ $ $ $ - $ - $ - Total Account 391 Total Administration Capital Budget 2027 $ - $ - $ - HUTCHINSON UTILITIES COMMISSION��` Board Action Form �r�turscti mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm Agenda Item: Cancellation of Purchase Order 008631, 2021 Ram 3500 Cab & Chassis Presenter: John Webster Agenda Item Type: Time Requested (Minutes): 1 New Business Attachments: Yes BACKGROUND/EXPLANATION OFAGENDA ITEM: The Hutchinson Utilities Commission approved the purchase of the following cab and chassis on January 28, 2021: The cab and chassis that is being recommended by Hutchinson Utilities is a 2021 Ram 3500 Crew Cab and Chassis, SRW with 4-wheel drive. As of December 13th, 2022 the manufacturer has not accepted the order to establish a build date. A utility body was purchased for this vehicle in 2021 and is currently sitting outside at Crysteel Truck Equipment in Lake Crystal, MN. Due to cab to axle dimensions this utility body can only be installed on a Dodge/Ram or Ford cab and chassis. It is my recommendation that this order be cancelled and the Natural Gas Division be allowed to pursue a cab and chassis through other channels BOARD ACTION REQUESTED: Cancellation of Purchase Order 008631. Fiscal Impact: ($43,636.00) Included in current budget: Budget Change: No PROJECT SECTION: Total Project Cost: Remaining Cost: John Webster From: Todd Prissel <tprissel@dodgeofburnsville.com> Sent: Tuesday, December 13, 2022 7:59 AM To: Bryce Rusch Cc: John Webster Subject: RE: Truck E Tii'JIIR',,i' .1, iCIIIMAIIIIE Al Eitr: This message originated from outside the City of Hutchinson email system. Unless you recognize the sender and know the content, DO NOT click links or open attachments. Good morning Bryce, I totally understand if you do not want the truck any more. I have 11 trucks that were ordered late 2021 and still do not have build dates on them and one is yours. If you want to cancel the truck just let me know and I will cancel it. Thank You, Cii!iiunnii,u„u..� hall / IP feel! VAanager T ICIkrr1P:uIL' Sales tl 952-767-2702 Direct 952-894-9000 Main Office From: Bryce Rusch <BRusch@hutchinsommn.gov> Sent: Tuesday, December 13, 2022 7:45 AM To: Todd Prissel <tprissel@dodgeofburnsville.com> Cc: John Webster <JWebster@hutchinsommn.gov> Subject: Truck Todd, Any Update in regards to the Truck?? We are getting to the end of the year again and the PO will expire! If there is still no word with it, wondering what it would take to cancel the order? Let me know. Thanks Bryce B. Rusch Hutchinson Utilities Commission Natural Gas Division -Metering 225 Michigan St SE Hutchinson, MN 55350 320-583-9146 Cell HUTCHINSON UTILITIES it SS 1 <,i a4i DODGE OF BURNSVILLE INC 12101 HIGHWAY 35W S BURNSVILLE, MN 55337 Note: Description: PURCHASE REQUISITION HUTCHINSON UTILITIES COMMISSION 225 MICHIGAN ST SE HUTCHINSON, MN 55350 Phone:320-587-4746 Fax:320-587-4721 Date Requisition No. 01/08/2021 �L_008631 Required by: Requested by: JWebster Item part No. Description Qty Unit Due Date Unit Price Ext. Amount No. 2021 SLT RAM 3500 CREW CAB CHASSIS, SRW, - 4X4, 60CA, 6.41- V8, 2GA DD81-93. TO INCLUDE LICENSE AND REGISTRATION. 1 1.00 EA 11/04/2021 143,636,000 143,636,00 'PER QUOTE BY TODD PRISSEL STATE CONTRACT BID # 170309 T-636(5) MFG. PART: Total: 43,636.00 Date Printed: 01/22/2021 Requisitioned By: JWebster Page: 1/1 HUTCHINSON UTILITIES COMMISSION��` Board Action Form �r�turscti mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm Agenda Item: Approval of Requisition 009402, ABM Equipment Utility Body Presenter: John Webster Agenda Item Type: Time Requested (Minutes): 5 New Business Attachments: Yes BACKGROUND/EXPLANATION OFAGENDA ITEM: The replacement vehicle for truck number 130, 2011 Chevrolet 2500HD, was ordered on April 28th, 2022. Requisition 009402 is for the service body, related work equipment, miscellaneous materials and all labor required for the installation on a 2022/23 GMC 3500, currently on order. Vehicle and service body being purchased as per HUC vehicle purchasing program. This utility body is being ordered through the Minnesota State Purchasing Program. BOARD ACTION REQUESTED: Approval of requisition 009402 Fiscal Impact: $33,563 Included in current budget: Yes Budget Change: No PROJECT SECTION: Total Project Cost: $79924 Remaining Cost: 0 �. HUTCHINSON UTILITIES Note: PURCHASE REQUISITION HUTCHINSON UTILITIES COMMISSION 225 MICHIGAN ST SE HUTCHINSON, MN 55350 Phone:320-587-4746 Fax:320-587-4721 ABM EQUIPMENT & SUPPLY INC 333 2ND ST NE HOPKINS, MN 55343 Description: Date Requisition No. 12/13/2022 009402 Required by: Requested by: JWebster Item part No. Description Qty Unit Due Date Unit Price Ext. Amount No. FIBERGLASS UTILITY/SERVICE BODY AS PER - QUOTATION NUMBER 111522-233-02 REVISED. CONTOURED BODY FOR SINGLE REAR WHEEL, 56" CA APPLICATION - WHITE GELCOAT. CHASSIS CA DIMENSION - 56" BODY LENGTH - 96" BODY WIDTH - 82.75" 1 BODY HEIGHT - 42" 1.00 EA 06/15/2024 $33,563.000 $33,563.00 COMPARTMENT DEPTH - 15" MAKE & MODEL- BRAND FX BFXB - 56LS INCLUDES ALL OPTIONS AND MODIFICAITONS AS LISTED ON QUOTATION: 111522-233-02 REVISED DATED DECEMBER 12, 2022 MINNESOTA STATE CONTRACT: 214522 MFG. PART: Total: 33,563.00 Date Printed: 12/13/2022 Requisitioned By: JWebster Page: 1/1 333 2"d Street NE Hopkins, MN 55343 952-938-5451 800-229-5451 Fax 952-938-0159 www.abmet ui ).com Custom Truck Equipment for the Utility, Construction, Municipal and Refuse Industries Quotation # 111522-233-02 REVISED Hutchinson Public Utilities 225 Michigan Street NE Hutchinson, MN 55350 Attn: Mr. Matt Maiers December 12, 2022 Mr. Maiers, In response to your request for a revised price quotation on a fiberglass sei vice body to fit your single rear wheel 2023 GMC 3500 pickup (diesel/manual tailgate) with a 56" C/A, we are pleased to submit the following (per MN State Contract # 214522): FIBERGLASS UTILITY/SERVICE BODY 1.05 Contoured body for a Single Rear Wheel 56" CA application - White lcoat. Chassis CA Dimension — 56" Body Length — 96" Body Width — 82.75" Body Height — 42" Compartment Depth — 15" Make & Model Brand FX BFXB — 56LS.........................................................................Price: $,' 10,364.00 Installation of Utility/Service Body ................................ 6................................................... Price: $ 1 100.00 Price of FMVSS 108 lighting package....................................................................................................Inc. Installation of FMVSS 108 lighting package..........................................................................................Inc. Warranty.................................................................................................................................... One Year 1.12.3 Galvanized sure step with pintle recess - Single rear wheel................................................Price: -33.00 1.12.6 Installation of bumper............................................................................................................Price: w.32.1..,.00 1.11.1 10" aluminum tailgate with automotive style latch.........................................................................Included Misc. 3/16" smooth aluminum floor with non-skid coating.........................................................Price: $m709...00.* 1.5.6 Fibreglo flexible tubular lighting on 3 sides of compartment - wired to OEM switch in cab ($133 per compartment x 6)........................................................................................Price: 798.00 1.10.2 Recessed floor tie down - two (2) at 12" in from front transverse wall andl0" in from cargo wall and two (2) at rear 10" in from tailgate and 10" in from cargo wall ($110 each x 4)......................................................................................................................Price: m440.00 1.9.27 Furnish and install rear mud flap (set)...................................................................................Price: $ 1,89.00 1.9.11 DEF tank kit (required for diesel engines)............................................................................Price: 208.00 1.5.1 Over center spring door stops for vertical doors ($77 per compartment x 4).......................Price: 3108.00 BRINGING YOU THE BEST NAMES IN THE BUSINESS An Equal Opportunity Employer 333 2" Street NE Hopkins, MN 55343 952-938-5451 800-229-5451 Fax 952-938-0159 www.abmealui com Custom Truck Equipment for the Utility, Construction, Municipal and Refuse Industries Quotation # 111522-233-02 REVISED -2- December 12, 2022 1.23.18 Mount OEM back up camera (must be ordered with truck).................................................Price: 131.00 1.13.4 Class V receiver hitch installed and reinforced for towing (includes adjustable hitchplate)..........................................................................................................................Price:.$ ,068.00 1.9.12 Furnish and install Berg 7-way (spade) trailer socket and boot with weatherproof connection..............................................................................................................................Price: 138.00 1.22.4 Recessed LED amber warning flashers in body at rear - one (1) each side wired to OEM switch in cab ($310 each x 2)..................................................................................Price: 620.00 Misc. Two (2) amber LED warning flashers (ECCO 3811A) mounted on grille and wired to g _ 475.00 same dash switch as above strobe lights ................................................................................Price•. Misc. Two (2) Whelen MCFLED2A Micro Freedom amber LED lighthead mounted on aluminum riser post at front of body — (1) each side - wired to same dash switch as abovestrobe lights..............................................................................................................Price: $ 2,116.00 1.9.21 Furnish and install aluminum riser post for strobe (above cab level) ($176 each x 2)......... Price: 1 352.00 1.23.2 Auxiliary fuel fill kit for pickup box removal - Chevrolet ....................................................Price: 420. 00 1.14.1 Load wall liner, aluminum ($375 per side x 2).....................................................................Price: 750.00 Misc. Aluminum overlay on transverse........................................................................................Price: 49400 .*. Misc. Non-skid coating on all aluminum cargo walls..................................................................Price: 705.00 1.9.4 Punched aluminum shovel basket 5" H x 15" W x 85" L mounted curbside ........................ Price: 653,.00 1.9.17 Furnish and install adjustable LED work light at rear of aluminum shovel basket wired toOEM switch in cab............................................................................................................Price: 282.00 1.23.4 Credit for pickup box (new only).....................................................................................Price: $ (-$525.00) 1.23.28 Install & wire Chevrolet upfitter switch fuse panel and harness (must be ordered with truck)..Price: ` 475.00 1.23.29 Reprogram chassis ECM for LED lights - Required for non -factory box delete 56 C/A .... Price: 378.00 11.2.10 DSI-12/3000 Dimension Heavy Duty 3000 watt pure sine inverter w/fuse installed in S 1 compartment at bottom facing upwards .....................................................Price: $, 5 002 ,,00 11.2.29 1PLT2 G.F.I. outlet with cover plate (interior mount add'l parts req'd exterior mounting) mounted at rear of body curbside top wired to inverter.......................................Price: 370.00 11.2.30 6C657 G.F.I. exterior outlet cover (allows exterior surface mounting of 1PLT2)...............Price: , 12000 11.2.31 7120001 G.F.I. exterior gang box (allows exterior mounting of 1PLT2)..............................Price: 59.00 BRINGING YOU THE BEST NAMES IN THE BUSINESS An Equal Opportunity Employer ABM EQUIPMENT 333 2" Street NE Hopkins, MN 55343 952-938-5451 800-229-5451 Fax 952-938-0159 MID .abme ui ).com Custom Truck Equipment for the Utility, Construction, Municipal and Refuse Industries Quotation # 111522-233-02 REVISED -3- December 12, 2022 INDIVIDUALIZED COMPARTMENTATION STREETSIDE: S1 - 1.3.3 (3) adjustable fiberglass shelves................................................................................Price: „420.00 S2 - 1.3.2 (2) adjustable fiberglass shelves ................................................. ...............................Price: w" 316.00 1.3.7 Divider pack for fiberglass shelves (4 dividers) ($21/pk x 2).....................................Price: 42.00 S3 - 1.5.2 Locking swivel hooks 1-3-1 ($39 each x 5)..............................................................Price: " 195.00 CURBSIDE: Cl - 1.18.1 Molded in fiberglass transverse.................................................................................Price: 688.00 Misc. Cage & four drawers -pull one side (full width) with (3) 3"D and (1) bottom drawer4"D..........................................................................................................Price: m ..2;420.00 C2 - 1.4.3 (12) drawer metal cabinet installed (2 rows of 6)......................................................Price: 575.00 C3 1.3.3 (3) adjustable fiberglass shelves.................................................................................Price: 420._00 TOTAL PRICE AS DESCRIBED, FOB HOPKINS, MN.................................6.......... 6............... $ 33,563.00 * Due to extended lead times and the volatility of the market, we reserve the right to impose a surcharge on the quoted price of non -contract items. We are experiencing surcharges from our suppliers and it has become necessary to pass these on to our customers. ABM Equipment will inform you of these surcharges prior to beginning of the build for your order. If ABM Equipment is unable to proceed with the build at the scheduled time due to unavailability of the chassis, ABM Equipment will invoice the customer for the cost of the equipment on hand and payment will be due per our normal terms. NOTE: Customer is responsible for transportation of truck to and from ABM Equipment. THE ABOVE PRICES DO NOT INCLUDE ANY APPLICABLE TAX(ES) Thank you for your interest in ABM Equipment. I hope the above information will allow you to place this business with us. Should you have any questions or need additional information, please do not hesitate to contact Paul Stromstad. Best regards, am Fahey Sales Coordinator BRINGING YOU THE BEST NAMES IN THE BUSINESS An Equal Opportunity Employer HUTCHINSON UTILITIES COMMISSION��` Board Action Form �r�turscti mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm Agenda Item: Approval of Requisition 009403, DUALDRAW Paint Booth Presenter: John Webster Agenda Item Type: Time Requested (Minutes): 2 New Business Attachments: Yes BACKGROUND/EXPLANATION OFAGENDA ITEM: In accordance with the report provided by the MMUA Safety Team on October 1, 2021, which states "This shop built paint booth located under the stairway to the mezzanine area does not meet the requirements necessary for painting activities." I wish to purchase and install an approved fume removal system. Two such units were found to meet the size requirement of Hutchinson Utilities: DUALDRAW and Marathon. Based on the specifications of each unit, Hutchinson Utilities recommends the unit provided by DUALDRAW, for the following reasons- 1 . Unit is constructed of aluminum - spark resistant 2. Provides for both downdraft and backdraft airflow 3. Two (2) hazardous duty motors, three phase 4. Ease of filter change 5. Left side wing opens for large objects 6. Ten (10) year warranty 7. Excellent customer service BOARD ACTION REQUESTED: Approval of Requisition 009403. Fiscal Impact: $25,218 Included in current budget: Yes Budget Change: No PROJECT SECTION: Total Project Cost: Remaining Cost: e ,tuPURCHASE REQUISITIONHUTCHI HUTCHINSON UTILITIES COMMISSIONDate Requisition No. UTILITIES 225 MICHIGAN ST SE 12/14/2022 009403 mission HUTCHINSON, MN 55350 Phone:320-587-4746 Fax:320-587-4721 DUALDRAW 4934 LIMA STREET DENVER, CO 80239 Note: Description: Item part No. Description No. TB3072AIN-NS, 30" X 72" HEAVY DUTY - DOWNDRAFT BOOTH WITH VENTED BACK, NON -SPARK CONFIGURATION, INTERNAL FILTRATION SYSTEM, 4,500 CFM, (2) HAZARDOUS DUTY MOTORS; CLASS I 1 DIVISION II, DOUBLE MOTOR/BLOWER/FILTRATION SYSTEM PROPOSAL NUMBER: 120222-SlS2, DATED DECEMBER 9TH, 2022, PROVIDED BY KRISTEN SUMMER. MFG. PART: VFD5, VARIABLE FREQUENCY DRIVE, LOWERS - NOISE LEVEL, ENERGY SAVINGS 2 SLOW START, ALLOWS OPERATOR TO CONTROL FAN SPEED FROM 0 - 4,600 CFM. MFG. PART: HNG-WING, LEFT SIDED (FRONT FACING) - 3 HINGED TB SIDE WING FOR EASE OF ACCESS WITH LARGE PARTS MFG. PART: DP-LIGHT-HZ2, HAZARDOUS DUTY LIGHT, 4 CLASS I DIVISION II MFG. PART: CS3072, HEAVY DUTY LOCKING CASTER 5 WHEELS - MFG. PART: Required by: Requested by: JWebster Qty I Unit I Due Date � Unit Price lExt. 1.00 1 EA 102122/20231 $16,900.0001 $16,900.00 1.00 1 EA 102/22/2023 1.00 1 EA 1102/22/2023 1.00 I EA 102/22/2023 1.00 1I EA 102/22/2023 PRE-FS, PRE -FILTER SHEET WITH VELCRO - STRIP TO PROTECT VENT BACK, WITH 3 6 COMPLIMENTARY PRE CUT SHEETS TO SHIP 1.00 EA 02/22/2023 WITH UNIT MFG. PART: $1,450.000 1I $1,450.00 $1,578.0001 $1,578.00 $1,250.000 1 $1,250.00 $750.000 1 $750.00 $275.0001 $275.00 Date Printed: 12/16/2022 Requisitioned By: JWebster Page: 1/2 HUTCHINSON UTILITIES Commission DUALDRAW 4934 LIMA STREET DENVER, CO 80239 Note: Description: PURCHASE REQUISITION HUTCHINSON UTILITIES COMMISSION 225 MICHIGAN ST SE HUTCHINSON, MN 55350 Phone:320-587-4746 Fax:320-587-4721 Date Requisition No. 12114/2022 009403 Required by: Requested by: JWebster Item No. part No. Description Oty Unit Due Date Unit Price Ext. Amount EX -SCOOP, EXHAUST SCOOPS TO REDIRECT MFG. 7 PARR 1.00 EA 02/22/2023 $570.000 $570.00 RM3072, NON-MARRING/NON-SCRATCH TABLE - MAT FOR 72".UNIT 8 MFG. PART: 1.00 EA 02/22/2023 $400.000 $400.00 RFK0000010, REPLACEMENT FILTER KIT, - INCLUDES (4) 2" PRE -FILTERS AND (4) 2" 9 CARBON FILTERS FOR ONE COMPLETE 1.00 EA 02/22/2023 $415.000 $415.00 CHANGE OUT MFG. PART: ESTIMATED FREIGHT - MFG. PART: 10 1.00 EA 02/22/2023 $1,630.000 $1,630.00 Total: 26,218.00 Date Printed: 12/16/2022 Requisitioned By: JWebster Page: 2/2 EQUIPMENT PROPOSAL DATE 12/9/2022 PROPOSAL NUMBER 120222-S1S2 UNDERSTANDING: Hutchinson Utilities contacted DualDraw to discuss potential solutions to an air quality issue due to fumes from a painting process. As requested, a proposal is attached for review. WHY DUALDRAW: Our equipment and company are unique in the marketplace for a number of reasons that we believe make us an excellent choice to address your air quality issues: ✓ The Value Leader in air pollution control products ✓ Patented air flow design ensures high quality equipment performance ✓ Unmatched multiyear warranty; check specifications for length of warranty on proposed equipment ✓ Satisfaction guaranty; 100% refund if equipment does not meet specifications ✓ Flexible fastening system allows for cost-effective modifications to suit any unique specification ✓ Multiple long lasting filtration designs to match all dust, smoke, and fume producing applications ✓ Units are built to order to ensure high -quality air filtration performance ✓ Self-contained air flow filtration system does not impact HVAC costs or require replacement air ✓ User-friendly, straightforward equipment -- all standard units shipped complete and ready to operate ✓ In-house design team will cost-effectively customize units for special applications ✓ Responsiveness, integrity, and service ✓ Manufactured 100% in the USA We appreciate your interest in DualDraw and thank you for the opportunity to earn your business. Please do not hesitate to contact us with questions or visit our website at yw............... .... ..........N CUSTOMER CONTACT Jeremy Carter ORGANIZATION Hutchinson Utilities PHONE 320-296-6772 E-MAIL 1I LCarter@hutchinsommn.gov DUALDRAW CONTACT .......................................... Kristin Summer .................... PHONEw 303-853 4083............................................................................................................ N..... ..., _ EMAIL ksummer@dualdraw.com WEBSITE www.dualdraw.com CORPORATE TAX ID . 84-1525885 ...�.� .... .... ..- DUNS NUMBER 13493431.�� DA .0 N. E CODE �,...... 1CtLZ3 GSA SCHEDULE 6S-25F-0161M IIIC'ft�IIIIIIIC'uira �iiim� �uallii°IPA L�'��iIII';�¢.��u��t i'ia��iw�faatau,r�u,. www,D gall'Ill:)ra ,(!!°!w n 0 (800) 5-2.`12.5 Page 5 of 10, continued DUADRAW MODELNAME: TB3072AIN-NS Non -Sparking Downdraft Booth with Vented Back with Double Internal Filter tern . ..... ..§ffi ........... UNDERSTANDING OF USE: To remove harmful fumes from operators breathing zones and eliminate cross contamination of adjacent processes and equipment SPECIFICATIONS: Characteristics Patented DualDraw design; evenly distributed clowndraft across perforated surface and vented back stop. . . .. ............. ... . .. Footprint Dimensions . .... .... Approximately 33"D X 84"L X 80"H Work Surface Area 28.6'X 72" with 5" perforated C-channel grates; Patented design 3/16" x 1/2" ventilated2q!jorations Table Capacity . . ............ 500-1,000 lbs distributed weight I'll, ....... . ........ ........ . . ..... Non -Sparking Nonsparking table grates, vent back, side wings, and blower fan wheel; AMCA spark class B construction Cabinet 12-16-gauge uni-body construction Finish Electro-galvanized metal. Galaxy Finish. Pre -Filter Sheet (optional) .......................... 24" x 72" Pre -filter Sheet; Velcro strip to suspend pre -filter sheet to protect vent back from overspray Pre -Filter Two (2) 24" x 24" x 2" pleated pre -filter 40% efficient to 0.7 microns MERV 8 Carbon Filters Four (4) 24" x 24" x 2" heavy duty activated carbon filters; 12 lbs activated carbon each filter ho9 sin " ..... P9_ .......................... After Filter two-(�j i4 x 24" x 2" pleated pre-fifter 40% efficient to 0.7 microns MERV 8 Dust Pan Removable front dust pan for easy clean out . .................................. Electrical Units come pre -wired with thermally protected manual motor starter; NEMA 12/4X enclosure Hazardous Duty Motors Two (2) 2 HP hazardous duty motors 230/460 volt, three phase, TEFC blower motor 6.2/3.1 amps each motor; Non -Spark AMCA Spark Class B Fan Wheel Capture Velocity .......... Approximately 300 FPM feet per minute with new filters; 65% table top and 35% vent back Air Volume 4,500 nominal CFM — self contained Magnehelic Gauge Indicates when filters should be checked and/or changed Lighting Internal LED lighting IP65 rated Sound Level 72 to 78 d13 at operator work zone Unit Weight 1000 lbs uncrated, 1350 lbs. crated for shipment . . ........... . .... . Freight Class 250 OSHA Helps most OSHA Standard 1910.1000 (air contaminants) WARRANTY 10 years from date of purchase, parts and labor DELIVERY Typically ' ' ' 8 to 10 weeks ARO subject to factory conditions. Please confirm with factory for current conditions when placing an order. SHIPPING FOB Denver, CO USA PAYMENT TERMS 50% deposit, Balance net 30 days ASSEMBLY None required; Customer required for connecting three phase power to the �eqyipmeqt; fork) reguired to unload the eqyipMept DuW1kiraw www,Dua�!Dii�aw.coim a (800) 9,77 212 5 6 Page 6 of 10, continued DUALDRAW m�um�we�wwwuaiMum min�titinmmoiw�!�iaimuiuiuiuiuidiumNw!�uuoumm�m�WW»immv�nriwwwww��.mu��onmiaivi�wua�wonmeaumom�mm�i no��mm�riumnenr��m�mmma��ux�uu�bra�s�wmrv�amr�mmr�re;��ariror�vaaru�:mnv�b�a�±ur�o-�av�;uo�miiw��uwou�u�mwomu+r��mm;�wrommammrv�i�+��i��Mmu��uira�mmaow�drcv�wfir.�r�e PHOTOS AND DRAWINGS TB3072AIN-NS Vented Back Downdraft Booth Double Motor & Internal Filter System Patented Non -Spark Work Surface Design &f Vented Back .................®.. 34� Access Door 72„ Dust Pan for Easy Clean Out Motor Controller NOTE: Drawings may not be to exact specifications 80" Motor Cover (extends 6" on each side) iDulw alDraw liiur "::Rw.w Ili �r � uli'II w°rm ,urw: �wuww wul',w w.ww.rii,,. wYvw.D wwIIIV': r w, om a (801) 977... 1l1.'2 Page 7 of 10, continued ��ati��u��ir� '111110 DUALDRAW IIYIWWIIm�wd�ID1YITM1%M1M 1I0111au TB3072AIN-NS Non -Spark Downdraft Booth with Vented Back; Double Motor & Internal Filter System NOTE: Photos may not be to exact specifications; Optional caster wheels and exhaust scoops shown Du,d�)iiraw Ar Quaky EqLd.iinnieint Mall ln!Llfa c:tui.ei. Page 8 of 10, continued OWN December 9, 2022 TOTAL ESTIMATED PRICE: UNIT ... ....... PRICE PER UNIT QTY PRICE . . ........... . . . ...... . ....... TB3072AIN - NS (30" x 72" Heavy Duty) Downdraft Booth with Vented Back Non -Spark Configuration Internal Filtration System 4,500 CFM (2) Hazardous Duty Motors; Class I Division II Double Motor/Blower/Filter System VFD, Recommend $16,900 1 $16,900 OPTION: VFD5 - Variable Frequency Drive; Lowers Noise Level; Energy Saving Slow Start; Allows Operator to Control Fan Speed $1,450 1 $1,450 From 0-4500 CFM OPTION: HNG-WING Left Sided (Front Facing) Hinged TB Side Wing for Ease $1,578 1 $125781. of Access with Large Parts OPTION: W-Ught—HZ2 OPTR U t ass v sion . ........ . $1,250 . . . ........... 1 $1,250 OPTION: CS3072 - Heavy Duty Locking Caster Wheels; Will Add 4" to Height $750 1 $750 - Bolted On Not Welded ............................................... OPTION: PRE-FS - Pre -Filter Sheet with Velcro Strip to Protect Vent Back 1 $275 - With 3 Compj!Menl�ajr Pre C $"2.75_ OPTION: EX -SCOOP - Exhaust Scoops to Redirect Air $570 1 $570 OPTION: P143072 - Non-MarringINon Scratch Table Mat for 72" Unit $400 1 $400 OPTION: RFK0000010 Replacement Filter Kit; Includes (4) 2" Pre Filters and $415 1 $415 4 lete Change Out Carbon Filters for One Comp . .......................... ..................................... . . . . . ................................. ............. -mwmwmwmwFOB $23,588 1ESTWATED FREIGHT to 55350) Origin $1,630 GRAND TOTAL $25,218 . .. . ........ Our product is 100% made in the USA * Quote valid for 30 days 9 Call us at 800-977-2125 with questions DuWllll�N,aw wmrw.Divafl)raw,coin 0 (800)97711113 Page 9 of 10, continued 0100/11000 DUALDRAW 0�'Nlfi�itllM1iFFAP00N0YnPMIIfiY�VINM�RIIY�FB!IkIiIR(�PftlNNA!Imll�(�IN�YM�?P1'TJMNm0mW.99�40WNWAMUI4Y�V8�NUUYINUNMMiM�NNPWItl!WNNONiiAmWl�nmmMNMfiYM1�tiVnH�Y�tl�iWmNM�nu�tt�mmimm�NIJf59G1hA �l nx �npnu�Xpmmmlhh NMlxx �nHpi�YAi�XI�uW�M�M1�ykilry,IXi1�11�11�11�1tt111f�hNIVNMi81�INtlgMNlYtlikll��04�'.W@4'�I�u`�A�i�%iY.4itA1 il0i1i0000011Nf�rn NOTE: DualDraw manufactures air pollution control equipment for a variety of applications. Air pollution control equipment and fans/blowers require that data regarding composition, particle size, combustibility, particulate concentrations (density/loading), air stream temperature, and air stream moisture content be supplied to DualDraw by the customer. This information is.used to calculate and establish the proper equipment selection. DualDraw cannot be held responsible or liable for performance of the equipment or system if this information is not provided or provided and proves to be incorrect. With regard to special airstream constituents (including, but not limited to, aluminum, titanium, flour, sawdust, etc.), Dua/Draw cannot be held responsible or liable for equipment and/or system performance which may be exposed to explosive dusts or damaging chemical dusts unless advised of the specific application of the equipment and/or system prior to the time of quotation or proposal. The buyer is cautioned to adhere to prescribed OSHA, Federal, State and Local codes and regulations applicable to industrial ventilation systems, which Dua/Draw LLC equipment may be applied on. The buyer assumes the responsibility for contacting their insurance underwriter and advising Dua/Draw LLC in regard to specific application requirements of explosion venting or if additional fire protection and safety equipment may be required. D ui'nu llll lllD ira iii oi° � Ill iir �° IIIIIIIC u.0 iii ll�:�u u� ui n u.n u.0 t� u�: uu a ur�. w u.DuaMraw,c((wirn (800)9772125 Page 10 of 10, continued ild&4W'r7WC�4'��MNN�IOI��M�NiVfl�MORNI@ri0ttJF4 b�4rvM�M'�C�6u"M4�WOThAM1MiMi�11H�NIf�INONOIMXM'�%MMA106Mfl�M1Mi'�HVM1�If��W�X'MMGI!!f!WMPpF91fa�Wf'A:WI�N�QOmI�tiSihllm(tlI�N6Y�@I�III�ImINPAiM19}g9�II1011MIIIIImIl01101NW16116'IdIMtlI01N�tlII1W11!W1YY�W'B�YHYtl11!�IYlYA41YUlh%WdPWIWYUYNM➢�V�fY9M'PNi9�1WW4'Wu'u AID 4M�tlOFO �rihFh'�nm �tinmNI01 WiY�MNDN'�IIIWN!WWWWINVI010101010101!WIINVJIWWN�d9p�W'd�UM TERMS AND CONDITIONS OF SALE Acceptance. We accept your order upon the express condition that you agree to accept and be bound by the terms and conditions set forth herein. Shipment by Seller (Dualdraw, LLC) and acceptance by Buyer of, or payment for, all or any part of the articles or equipment covered by this Sales Order (the "Articles") shall constitute acceptance by Buyer of this Sales Order and all the terms hereof. Prior to acceptance by Buyer, Seller may withdraw or modify this Sales Order. Full Agreement. The agreement between Seller and Buyer (the "Sales Contract") with respect to the Articles shall consist of the terms and conditions contained in the accompanying Proposal or Quotation and this Sales Order together with any additions to or revisions of such terms mutually agreed to in writing by Seller and Buyer. Seller shall not be bound by any additional or different terms, whether printed or otherwise, in Buyer's purchase order, or any other communication from Buyer to Seller unless specifically agreed to by Seller in writing. Prior courses of dealing usages of the trade, and verbal agreements not reduced to a writing and signed by Seller, to the extent that they modify, add to, or detract from the Sales Contract, shall not be binding on the Seller. Modification. Except as provided herein, the terms of the Sales Contract may not be modified, terminated or repudiated, in whole or in part, except by a writing signed by Seller and Buyer. Seller may, at its option, treat any attempted modification, termination or repudiation to which it does not assent as a breach of the entire Sales Contract and claim all proper damages and resulting, reasonable legal fees. If all or part of the Sales Contract is terminated by agreement of the parties, and if there is no contrary written agreement between Seller and Buyer, Buyer shall pay termination charges as follows: (a) the price provided in such order for all Articles assembled prior to the agreement by Seller to termination, plus (b) the actual expenditures made and liabilities incurred by Seller in connection with the uncompleted portion of the order, plus (c) a reasonable estimated profit on the uncompleted portion of the order Purchase Price and Delivery. Unless provided to the contrary - see (5) below - Buyer shall pay the purchase price in full prior to date of shipment. Terms are F.O.B. factory unless otherwise stated. Buyer shall pay all shipping costs and bear the risk of loss after Seller completes delivery to the carrier. ilia 5. Payment Terms. Net payment in full on all invoices is due prior to shipment unless otherwise stated on the invoice or as otherwise stated on the equipment quotation. Any account unpaid 30 days after shipment is subject to a service charge of 1.5% per month on the unpaid balance. 11 Sales or Use Taxes. The price shown on the face hereof does not include sales taxes as appropriate or other governmental charge upon the sale, shipment or use of the Articles which Seller is required to pay or collect from the Buyer. Any such tax or charge shall be paid by Buyer to Seller unless Buyer furnishes Seller with exemption certificates acceptable to the appropriate taxing authority. Time of Delivery. Shipment schedules are approximate and are based on conditions at the time of acceptance. Seller shall in good faith attempt to effect delivery by the date specified but shall not be responsible or liable for delays in or failure to make deliveries due to its ceasing to manufacture any Article or to causes beyond its control and not occasioned by its negligence. In such cases, Seller reserves the right to terminate the order or to reschedule delivery within a reasonable time. In no event shall Seller be liable for incidental or consequential damages resulting from failure to meet requested delivery schedules. Warranty. Seller does not warrant any Article delivered under this Sales Contract except as stated in the equipment proposal. Any warranty provided is provided by the manufacturer of the Article and is subject to the specific warranty requirements of the Article manufacturer. Seller has no obligations under the manufacturer's warranty. Seller does not warranty merchantability or fitness for any particular purpose, or make any other warranty or agreement express or implied with respect to any Article or Articles delivered under the sales contract. If any model or sample was shown to buyer, such model or sample was used merely to illustrate the Article and not to represent that any Article delivered hereunder would conform to the model or sample. Seller assumes no liability or responsibility whatsoever with respect to facility and/or plant, manufacturing or personal liability that may be incurred by the buyer. Force Majeure. Seller shall not be liable for failure to deliver or delays in delivery occasioned by strikes, labor disputes, fires and other natural disasters, inability to obtain materials or shipping space, breakdowns, delays of carriers or suppliers, governmental acts and regulations, and other causes beyond Seller's control. Infringement. The Buyer will indemnify and hold Seller harmless against all damages, costs, expenses or attorneys' fees arising from claims of infringement of patents, designs, copyrights or trademarks with respect to all Articles manufactured or assembled either in whole or in part to Buyer's specifications. Seller further reserves the right to cancel any order for Articles the manufacture, sale, and/or use of which, in the opinion of Seller would infringe upon any patent, design, copyright or trademark. Applicable Law. This Sales Contract shall be governed by the laws of the State of Colorado. Du iir 'uu I` II'ii II':w,;ml.I llw I mu°°uI: w Iu°wl w iiwuuw,ii,. ww. .III':°'Iu,iia I ii,aw,coinI 00) 977-2'.3.2 The booth should be a size that gives you a comfortable area around the item that you are painting, not just for ease of movement, but so that the air flows around the item easily, and effectively. These booths are designed to provide "Big Booth" performance and functionality in a small and convenient space (see the specifications chart below). ions ..... ...... IN AIIII umeasuo°s:ou e nU, m uu°wded to ffie nearest s',o-*Wil: 1a'8 inch. Standard Ii nt • 18 Gauge galvanized steel construction. • Class I, Division II LED UL Listed lighting fixture. • Complete 4 Stage filtration for startup. • Fan, motor, manometers, and 4 castor wheels (2 locking wheels). • All parts, switches, hardware, and wire assemblies for complete assembly. • A Variable Frequency Drive (VFD) is standard on SPB-76 and all "F" (Floor Length) models. Optional ur l u i nt • Ask us about our ducting options (may be required for some applications). • Plug and Play package - Completely assembled and wired (see pricing chart below left). • Bright White Powder Coating Package (see pricing chart below right). Our unique custom 4 Stage filtration system captures over 99% of wet & dry airborne particulates and overspray. We use heavy duty V-Bank "Active Carbon" filters that help to mitigate some of the fumes, solvents, and VOCs*. Easy to remove and replace. Note: Filters should always be disposed of according to the prevailing applicable regulations. V�p' µuous'ulColr:nuanr::��n uu �� u� a� n' Call us at 800 919-9035 and let's talk about getting you into the perfect small parts booth, as well as the options you want. You'll see why we say that Marathon Finishing is the benchmark for spray painting solutions. Ph:800-919-9035 • www.MarathonSprayBooths.com • info@MarathonFinishing.com ��"'4jj jpN � a Paint Booth Frrr PiD}a, Pr a John Webster Cc Jeremy Carter; Angie Radke A'',I 6 ), r,ua EXTERNAL EMAOL Al ER" - This message originated from outside the City of Hutchinson email system. Untess you recognize the sender and know the content, DO NOT' click links or open attachments. John — I've put together a recommendation report regarding the paint booth that used and in place in the shop., Please see the attachedquestions, h " lu- ivy r ,,Poo Schmidt, CSP Regional Safety Coordinator /1 i 9 .0823 Minnesota Municipal titiffiies Association 3131 , Larne N., Ste_ 200 Pmmouthll MN 5544 -5337 RE: Paint Booth Fg � rJhy NESENE711-W—T R11 IT; =T. I I 7u John Webster S e ""f � Friday, October 1, 202 111:09 AM EXTERNAL EMAIL A1,,ERT- This message originated from outside the City of Hutchinson email system. Unless you recognize the sender and know the content, DO NOT click links or open attachments. .Joe Schnaldt, CSP MMUA Reglonall Safety Coordinator NA: 218.280.0823 From: John Webster<JWebster@cLhutchinson.mnus> Sent. Friday,, October 1, 2021,11:07 AM To; Joe Schmidt <jschmid1t@mmua.org> Subject: RE. Paint Booth ,J(3E, I 11E I "'r"11VA, BUH�TBY'11 1E COP471',,IACITOR W �E?',,! Off"?, FAX'."'JLTIIES INERE 1,4�f,3';'T REINW)DEI El[)ti I DO ?1R,3`['1,1A,VE ANN ID) %,AS'l IAQ-10 �,,-WE("'" I I � I "U, A,Ys r' YOZY10 KN,0V)('11i'AV'F p"'l R5 W.WNS 1A(E COBBI-E'D 'rOGETI IER, ,PD1,1114 'VVEBST'E,R — . � ..... . .... . " " � ��") FZ . ..... t',JA rl,ffldd- Gu�13C)nnslu",I K11" F " clrv?"JX)r,f LJTH I'FIES 2, 21 5 N,4JC;V'-HGAkN S*r SE I" IUTCHMISON, W4, 553 5( "1" (320), 2,34-0507 C (320) 58'31-�?325 This shop built paint booth located under the stairway to the mezzanine area does not meet the requirements necessary for painting activities. The Dupli Color paint that is used to paint gas fixtures and parts, is considered a class I flammable substance. (see SDS) As such, the paint booth must be so equipped to prevent an explosion. According to OSHA regulations 1910.307 & 1910.399, this area would be considered a class I, division 1 hazardous location. Those regulations require that the electric equipment be intrinsically safe and permitted for the hazardous location. The plastic sheeting that is draped around also creates and unsafe situation should an explosion occur. It is recommended that this paint booth be removed from service and replaced with one that is designed for that purpose. A quick google search resulted in:as a vendor that may meet the needs. Here is a link to more information to their products that may be appropriate. httw':m Ill ui r� ym+ m � Diu, a ium, g u �m „ul� u� ° � ; ai�� ipw�, wail Joe Schmidt HUTCHINSON UTILITIES COMMISSION��` Board Action Form �r�turscti mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm Agenda Item: Transmission Facilities Assignment Agreement - MRES Presenter: J. Carter Agenda Item Type: Time Requested (Minutes): 5 New Business Attachments: Yes BACKGROUND/EXPLANATION OFAGENDA ITEM: This is a supplemental agreement to the Transmission Facilities Assignment Agreement (TFAA) with Missouri River Energy Services (MRES) entered into on Oct 31, 2016. The purpose of this agreement is to declare the new equipment that is to be added to the Hutchinson Substation in the upcoming years and include it in the TFAA. MRES is the designated Transmission Owner for HUC and the TFAA allows MRES to obtain revenue from HUC Transmission Facilities for HUC. BOARD ACTION REQUESTED: Approval of the Supplemental Agreement to the Transmission Facilities Assignment Agreement with Missouri River Energy Services Fiscal Impact: $0 Included in current budget: No Budget Change: No PROJECT SECTION: Total Project Cost: $0 Remaining Cost: Exhibit B-I SUPPLEMENTAL AGREEMENT TO TRANSMISSION FACILITIES ASSIGNMENT AGREEMENT MRES - Hutchinson This Supplemental Agreement to Transmission Facilities Assignment Agreement (the "Supplemental Agreement") is made and entered into , 202 (the "Effective Date"), by and between Missouri Basin Municipal Power Agency d/b/a Missouri River Energy Services, a body corporate and politic organized under the laws of the State of Iowa and existing under the intergovernmental cooperation laws of the States of Iowa, Minnesota, North Dakota and South Dakota ("MRES"), and the Hutchinson Utilities Commission of Hutchinson, Minnesota, a municipal corporation of the State of Minnesota ("Municipality"). MRES and Municipality are at times referred to herein collectively as the "Parties" and each individually as a "Party". WHEREAS, MRES and Municipality are parties to that certain Transmission Facilities Assignment Agreement dated October 31, 2016 (the "Assignment Agreement"), pursuant to which Municipality assigned functional control of the Transmission Facilities to MRES, and MRES agreed to serve as Transmission Owner of Municipality with respect to the Transmission Facilities, all for the purpose of enabling Municipality to derive and obtain revenue from the Transmission Facilities. Capitalized terms used in this Supplemental Agreement, but not defined herein, shall have the meanings given to them in the Assignment Agreement. WHEREAS, Municipality intends to construct additional transmission facilities as further described in Appendix 1 to this Supplemental Agreement (the "Additional Facilities") WHEREAS, the Midcontinent Independent System Operator ("MISO") Transmission Owners Agreement provides that affected Transmission Owner(s) of an approved MISO-wide transmission plan ("MISO Plan") shall make a good faith effort to design, certify, and build the designated facilities set forth in the approved MISO Plan, and in doing so, shall enter into additional agreement(s) with MISO (the "Additional Agreements") with respect to the designated facilities. WHEREAS, the Additional Agreements will impose obligations on MRES in addition to those obligations accepted by MRES under the Assignment Agreement. WHEREAS, Section 1.3(b) of the Assignment Agreement provides that, if MRES is required by FERC, the RTO or applicable law to enter into any agreement requiring it to undertake any obligations in excess of those stated in the Assignment Agreement, Municipality must assume, carry out and be responsible for such obligations and MRES may require Municipality to enter into a supplemental agreement further defining such obligations. WHEREAS, MRES, as a condition to executing the Additional Agreements, requires that the Parties enter into this Supplemental Agreement to further define Supplemental Agreement to Transmission Facilities Assignment Agreement Page 1 Municipality's obligations with respect to the Additional Agreements. NOW THEREFORE, the Parties agree as follows: 1. Obligations of Municibalit)�. Municipality affirms its obligations under Section 1.3 of the Assignment Agreement. Without limiting the generality of the foregoing, Municipality agrees as follows with respect to the Additional Agreements: a. Municipality shall construct, care for, control and own the Additional Facilities, all in accordance with the terms and conditions of the Additional Agreements and applicable laws, rules and regulations. The Additional Facilities shall constitute Transmission Facilities under the Assignment Agreement for all purposes described therein, and the Parties shall update Exhibit A to the Assignment Agreement accordingly. b. Municipality shall assume, carry out and be responsible for any and all terms and conditions of the Additional Agreements which in any way: (i) relate to the construction, care or control of the Additional Facilities or any other Transmission Facilities, or (ii) obligate MRES to perform any obligations outside of the revenue sharing services of MRES described in the Assignment Agreement. C. Municipality shall reimburse MRES for any and all out-of-pocket costs, expenses, taxes or other charges incurred by MRES in connection with the Additional Agreements, it being the intent of the Parties that MRES shall not incur any costs or other charges as a result of the Additional Agreements or the performance thereof. d. Municipality shall immediately transmit to MRES copies of all notices, invoices, and other communications Municipality receives under or in connection with the Additional Agreements, if and to the extent such notices, invoices or other communications were not indicated to have been provided to MRES directly. e. Municipality shall provide to MRES all information reasonably requested by MRES to enable it to comply with its obligations under the Additional Agreements and the Assignment Agreement, including without limitation all documentation necessary to document Municipality's costs and expenses for which it may seek cost recovery. f. Municipality shall maintain all insurance required to be maintained by MRES under the terms of the Additional Agreements. If the Additional Agreements require insurance in excess of the coverages required of Municipality under the Assignment Agreement, Municipality shall obtain insurance equal to such excess required amounts. If Municipality fails to obtain such additional insurance, MRES may obtain such insurance and charge the cost thereof to Municipality pursuant to Section 2.4 of the Assignment Agreement. All such Supplemental Agreement to Transmission Facilities Assignment Agreement Page 2 insurance shall: (i) name MRES, Western Minnesota Municipal Power Agency, and their directors, officers, agents, servants and employees as additional insureds; (ii) waive all rights of subrogation in accordance with the terms of the Additional Agreements; and (iii) contain provisions specifying that such policies of Municipality are primary and apply to such extent without consideration for other policies separately carried. g. Municipality shall indemnify, defend and hold harmless MRES, Western Minnesota Municipal Power Agency and their officers, directors, employees and agents from and against any and all claims, damages (including without limitation liquidated damages), liabilities, costs and expenses, including attorneys ' fees, arising out of or related to the Additional Agreements or the performance or non- performance of any obligations thereunder, unless such claim, damages or liability arises from the gross negligence of MRES. Such indemnification obligations shall survive the termination of this Agreement and shall be in addition to all indemnification obligations of Municipality under the Assignment Agreement. h. Municipality shall compensate MRES for its expenses in connection with this Supplemental Agreement and the Additional Agreements, by paying MRES a fixed fee as may be established by the MRES Board of Directors from time to time. Such fee, if established, shall be in addition to any fees and costs payable by Municipality pursuant to Section 2.4 of the Assignment Agreement. i. If Municipality fails to take any action or perform any obligation required of it under this Supplemental Agreement, MRES may, but shall not be obligated to, take such action or perform such obligation, either itself or through a third party, and directly charge Municipality for reimbursement of any associated costs thereof pursuant to Section 2.4 of the Assignment Agreement. 2. Obligations of MRES. MRES agrees as follows with respect to the Additional Agreements: a. MRES shall not execute any Additional Agreements, or any amendment thereto, without Municipality's review and approval thereof, which review and approval shall not be unreasonably delayed or withheld. Nothing contained in this section shall in any way limit or otherwise alter Municipality's obligations under the Assignment Agreement or this Supplemental Agreement. b. MRES shall consult and cooperate with Municipality regarding the election of any options or alternatives under the Additional Agreements and any other matters under the Additional Agreements relating to the Additional Facilities. C. MRES shall immediately transmit to Municipality copies of all notices, invoices, and other communications MRES receives under or in connection with the Additional Agreements, if and to the extent such notices, invoices or other communications were not indicated to have been provided to Supplemental Agreement to Transmission Facilities Assignment Agreement Page 3 Municipality directly. d. MRES shall provide to Municipality all information reasonably requested by Municipality to enable it to comply with its obligations under this Supplemental Agreement and the Additional Agreements. e. To the extent permitted by the Additional Agreements, MRES shall comply with the reasonable instructions of Municipality with respect to the performance of Municipality's obligations under this Supplemental Agreement. f. To the extent requested by Municipality and if supported by appropriate documentation from Municipality, MRES shall seek reimbursement of all costs and expenses to which Municipality may be entitled under the Additional Agreements, subject to the terms and conditions of the Assignment Agreement and the Additional Agreements. 3. Additional Agreements. A copy of the Additional Agreements will be attached to Appendix 2. 4. Term. This Supplemental Agreement shall become effective on the Effective Date and shall continue in full force and effect until either the Parties agree to mutually terminate this Supplemental Agreement or earlier termination as provided for under this Supplemental Agreement. 5. Cooperation. The Parties shall take all such additional actions as may be required to carry out the terms of this Supplemental Agreement and the Additional Agreements. 6. Termination of Assignment Agreement. Upon termination of the Assignment Agreement for any reason, Municipality's obligations under this Supplemental Agreement shall continue for the respective terms of the Additional Agreements, unless and until Municipality causes MRES to be released from MRES's obligations under the Additional Agreements, in accordance with Section 3.3 of the Assignment Agreement. 7. No Other Additions or Modifications. The Parties hereby affirm the Assignment Agreement in all respects. The terms of this Supplemental Agreement are in addition to, and not in derogation of, the terms of the Assignment Agreement. This Supplemental Agreement is in all respects subject to, and incorporates by reference, the terms of the Assignment Agreement. Supplemental Agreement to Transmission ransmission Facilities Assignment Agreement Page 4 IN WITNESS WHEREOF, the Parties hereto have duly executed and delivered this Supplemental Agreement to Transmission Facilities Assignment Agreement as of the date set forth above. MISSOURI BASIN MUNICIPAL POWER AGENCY d/b/a MISSOURI RIVER ENERGY SERVICES Sign: Print: Title: HUTCHINSON UTILITIES COMMISSION Sign: Print: Title: HUTCHINSON UTILITIES COMMISSION Sign: Print: Title: Supplemental Agreement to Transmission ransmission Facilities Assignment Agreement Page 5 APPENDIX 1 ADDITIONAL FACILITIES Supplemental Agreement to Transmission Facilities Assignment Agreement Page 6 APPENDIX LA Hutchinson Substation Rebuild The addition of a 2nd 115/69 kV transformer, circuit breaker, disconnect switches, bus conductor, and other necessary equipment to connect the transformer and convert the 115 kV yard to a ring bus. MISSOURI BASIN MUNICIPAL POWER AGENCY d/b/a MISSOURI RIVER ENERGY SERVICES Sign: Print: Title: HUTCHINSON UTILITIES COMMISSION Sign: Print: Title: HUTCHINSON UTILITIES COMMISSION Sign: Print: Title: Supplemental Agreement to Transmission Facilities Assignment Agreement Page 7 APPENDIXAdditional Aureements Supplemental Agreement to Transmission Facilities Assignment Agreement Page 8