The URL can be used to link to this page

12-18-2024 HUCCPHUTCHINSON UTILITIES COMMISSION AGENDA REGULAR MEETING December 18, 2024 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 No Changes to Policies 7. UNFINISHED BUSINESS a. None 8. NEW BUSINESS a. Approve 2025 Non -Union Pay Grid Adjustment and Job Position Reclassification b. Approve 2025 Electric and Natural Gas Operating Budgets & 5 Year CIP c. Conduct the Performance Review of Hutchinson Utilities Commission General Manager Pursuant to Minnesota Statute 13D.05 Subd. 3(a) 9. ADJOURN MINUTES Special Meeting — Hutchinson Utilities Commission Wednesday, November 27, 2024 Call to order — 2:00 p.m. President Don Martinez called the meeting to order. Members present: President Don Martinez; Vice -President Matt Cheney; Secretary Kathy Silvernale; Commissioner Anthony Hanson; Commissioner Troy Pullis; GM Jeremy Carter Others present: Jared Martig, Dave Hunstad, Mike Gabrielson, and Angie Radke Absent: Attorney Marc Sebora 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 about 3 weeks to review before final budget numbers need to be approved. Discussion was held on cash flow between the departments along with bonding. GM carter presented HUC's 2025 preliminary budget, which is the same format as previous years. GM Carter highlighted the combined divisions, revenues are at $45AM with expenses at $43.6M with a Net Profit of $1.9M, which is an increase in net profit over last year. Electric Division shows an increase of $500K in the Power Cost Adjustment. Sales for Resales shows a decrease of $191 K. Electric Division Revenues are at $29.6M with expenses at $30.7M with a Net Loss of $1 M; this is about $100K better than last year. Gas Division Revenues are at $15.8M with expenses at $12.9M with a Net Profit of $2.9M which is about $300K better than last year.GM Carter reviewed the Combined Division graphs. Electric Division, Retail Customer sales of $25.6M which is an increase from last year. Power Cost Adjustment is $900K compared to $400K in 2024. Residential, Small General, Large General and Industrial Sales are fairly consistent with past years: which means HUC's loads are fairly consistent. Overall Kwhr volume sales show a 2.45% decrease. GM Carter pointed out that Sales for Resales has decreased by $190K over 2024 budget due to a decrease in Capacity Sales (4MW's/$92,750 and Market Sales $98K) Other Revenues of $525K are made up of Additional customer charges of $145K, Interest Earnings of $300K, Bond Premiums of $33K, and GIS Reimbursement of $47K. 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. GM Carter spoke on the Electric Division Expense Budget Highlights. Health Insurance will be moving to Medica with a 3% decrease. Dental Insurance will be moving to Sun Life with a 3% decrease. LTD, Basic Life and AD&D benefits remain the same. There will be reduction of 1 FTE (split between the divisions). PILOT remains the same. GM Carter reviewed the GRE/MISO Transmission Expense along with the MRES Baseload Contract Expense of a $364K increase, MISO Expenses of a $429K decrease and the Bright Energy Choices Program of $122K which is an increase of $27K from last year. Additional Operating Expenses of $40K for Generator Stack Testing, $8K for Trane System upgrades, $25K for Technology Updates, $11 K for Office Building Improvements, 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 $57K and shows a decrease of 3.69% in forecasted Retail MCF's sold, decrease in FCA Credits. Contract Sales of 3M, TDK, UFC and Brownton show an increase in revenue of $126K. GM Carter highlighted Other Revenues of $3.4M; which are made up of N.U/HCP/UFC/UNG Transport/Reservation Fees of $2M, Electric Division Transportation Fees of $728K, Bond Premiums of $186K, Customer Charges of $52K, Interest Income of $300K, Brownton & HCP Operation/Maintenance Agreement of $30K, and GIS Reimbursement of $25K. 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 a decrease of $242K, Contracted Customers Gas purchases increase $151 K, PILOT remains the same and Additional Operating Expenses of $50K for Engineering Cost for PHMSA's changes in programs and Flying Line, Patrolling and System Improvements, $8K for Trane System Upgrades, $11 K for Office Building Improvements and $8K for Technology Updates. GM Carter looked to the Commission for questions, concerns or comments on the 2025 Budget Presentation. President Martinez asked the Commissioners to spend time with GM Carter and ask questions about the budget between now and December 18tn There were no concerns from the Commissioners. Commissioners stated that the information was detailed and clear and to continue to present in the same format. There being no further business, a motion by Commissioner Pullis, second by Commissioner Cheney to adjourn the meeting at 2:55p.m. Motion carried unanimously. ATTEST: Don Martinez, President Kathy Silvernale, Secretary MINUTES Regular Meeting — Hutchinson Utilities Commission Wednesday, November 27, 2024 Call to order — 3:00 p.m. President Don Martinez called the meeting to order. Members present: President Don Martinez; Vice President Matt Cheney; Secretary Kathy Silvernale; Commissioner Anthony Hanson; Commissioner Troy Pullis; GM Jeremy Carter Absent: Attorney Marc Sebora 1. Conflict of Interest 2. Approve Consent Agenda a. Approve Minutes b. Ratify Payment of Bills Motion by Commissioner Cheney, second by Commissioner Silvernale to Approve the Consent Agenda. Motion carried unanimously. 3. Approve Financial Statements Mr. Martig presented the Financial Statements. There was a $3M bond payment made today, next month the Financial Statements will reflect the payment. Net Loss increased over October 2023. Increase is due to a payment of $253K for lighting at VMF Field along with Salaries and Benefits had a miscalculation accrued wage entry in 2023. November will have the opposite effect. Motion by Commissioner Hanson, second by Commissioner Pulis to Approve the Financial Statements. Motion carried unanimously. 4. Open Forum 5. Communication a. City Administrator —Matthew Jaunich — i. Working on Budget, Truth and Taxation meeting is next Tuesday b. Divisions i. Dan Lang, Engineering Services Manager — Absent ii. Dave Hunstad, Electric Transmission/Distribution Manager — 1. Finished projects up. iii. Mike Gabrielson, Production Manager — 1. Tower pumps and side stream filter install 2. LM6000 final phase should be starting next week. 3. December the Stacks from Unit 3 & 4 will be coming down. iv. Jared Martig, Financial Manager- Nothing to Report c. Human Resources — Angie Radke - 1. Natural Gas Meter Crew Chief position has been filled 1 2. 2025 Benefits have been finalized 3. Next week information will be sent out to the Commissioners regarding General Manager Jeremy Carter's annual review. d. Legal — Marc Sebora — Absent e. General Manager — Jeremy Carter i. Wrapping up Year End 6. Policies a. Review Policies i. CIP Rebate Level of Authority ii. Financial Reserve Policy iii. Service Beyond City Limits of Hutchinson iv. Surplus Property Policy v. Investment Policy No changes recommended at this time. b. Approve Changes i. Delegation of Authority Policy ii. Payments of HUC Payables iii. Purchasing Policy/Credit Cards/Fixed Assets Ms. Radke presented approval of policy changes. Delegation of Authority is being updated to reflect the Engineering Services Manager instead of Natural Gas Division Director. Payments of HUC Payables being updated with next year's date. Purchasing Policy/Credit Cards/Fixed Assets verbiage being updated to reflect managers. Motion by Commissioner Cheney, second by Commissioner Silvernale to Approve Policy Changes. Motion carried unanimously. 7. Unfinished Business 8. New Business a. Approve Non -Wavier of Tort Liability Limits for General Liability Insurance Mr. Martig presented Approval of Non -Wavier Tort Liability Limits for General Liability Insurance, which is a requirement by the 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 Pullis to Approve Non - Wavier of Tort Liability Limits for General Liability Insurance. Motion carried unanimously. 2 b. Approve Customer Uncollectable Write -Offs Mr. Martig presented the Customer Uncollectable Write -Offs. HUC is requesting to approve write-offs of $11,385.26. Motion by Commissioner Silvernale, second by Commissioner Cheney to Approve Customer Uncollectable Write -Offs. Motion carried unanimously. c. Approve Interconnect and Natural Gas Firm Transportation Capacity Agreement for Ung-Brownton GM Carter presented Approval of Interconnect and Natural Gas Firm Transportation Capacity Agreement for UNG and Brownton. GM Carter recapped the Brownton Agreements from last month stating this is the last of the 4 agreements. The ending term of this agreement coincides with the other agreements in place between HUC and Brownton which is ending in November 2029. With the approval of this agreement, an acknowledgment exists that allows HUC the ability to fulfill the terms and conditions of the agreements in place with the City of Brownton (Transportation, Commodity and O&M Agreements). Motion by Commissioner Pullis, second by Commissioner Hanson to Approve Acknowledgment of the Interconnect Agreement between the City of Brownton and UNG. Motion carried unanimously. d. Approve Audit Services with Conway Deuth & Schmiesing Mr. Martig presented Approval of the Audit Services with Conway Deuth & Schmiesing. For fiscal year 2024, Audit Services have increased to $30,000. Mr. Martig provided a 10-year history for review. Motion by Commissioner Hanson, second by Commissioner Cheney to Approve 2024 Audit Services with Conway Deuth & Schmiesing. Motion carried unanimously. e. Approve Req#010068 — City of Hutchinson LED Street Light Conversion Mr. Hunstad presented Approval of Req#010068 — City of Hutchinson LED Street Light Conversion. Requisition is for the fourth year of LED fixtures that are scheduled for delivery in February. Motion by Commissioner Cheney, second by Commissioner Pullis to Approve Req#010068 — City of Hutchinson LED Street Light Conversion. Motion carried 3 unanimously. f. Approve Contract for Hutchinson Substation Capacitor Voltage and Potential Transformers to Border States Electric GM Carter presented Approval of Contract for Hutchinson Substation Capacitor Voltage and Potential Transformers to Border States Electric. In September the Commission approved to Award the Contracts to Border States Electric, now Staff and DGR Engineering are recommending to enter into a purchase agreement with Border States Electric for capacitor voltage and potential transformers to be installed at the Hutchinson Substation for a total contracted price of $210,188.84. Motion by Commissioner Silvernale, second by Commissioner Hanson to Approve Contract for Hutchinson Substation Capacitor Voltage and Potential Transformers to Border States Electric. Motion carried unanimously. g. Approve Advertisement for Bids — Hutchinson Substation Construction Improvements GM Carter presented Approval of Advertisement for Bids — Hutchinson Substation Construction Improvements. Staff is requesting Board approval to advertise for bids for construction improvements at the Hutchinson Substation as part of the 115kV expansion project. The work will include the civil, mechanical, and electrical components required for substation completion. HUC will receive sealed bids until 2.00 pm on January 15, 2025. Motion by Commissioner Pullis, second by Commissioner Silvernale to Approve Advertisement for Bids — Hutchinson Substation Construction Improvements. Motion carried unanimously. h. Discussion of Appointment of Tom Lambert to the Hutchinson Utilities Commission President Martinez began the discussion of Appointment of Tom Lambert to the Hutchinson Utilities Commission. Generally, after discussion, Commissioners will make a recommendation to the Council on the appointment. Commissioners please feel free to reach out to Tom. Tom was recommended by the Mayor. Tom does have a strong interest in being part of the Commission. Mr. Jaunich will bring to the City Council in December. GM Carter also reminded the Commissioners to think about officer positions for the upcoming year. 12 9. Adjourn There being no further business, a motion by Commissioner Pullis, second by Commissioner Silvernale to adjourn the meeting at 3:19p.m. Motion carried unanimously. ATTEST: Don Martinez, President 5 Kathy Silvernale, Secretary W H E� H H N D EO � N z\ O M z\ H N U p z x N O N w\ N � N O a w a o a z w w w wFX El u� Q a z x �Q U � w Q U x U w x U ro a ZH- 14 U U w x 00 � o � N b O H - i Ul -) ri 1J O U Q N f7 J-) H .D Q Ln Ln N N H h N Ln N N l0 m N O H O O h M H i' Ln H H H O O O O O O H H H N m O O O O O O O O O O O un un O O O O O i' i' m Ln ,i' i' O O O O un un un O M M M 0 0 0 0 un un un Ln CSl I I I I I I I I I I I h h l0 l0 l0 l0 H N N H H O O O O O O O O O O O H H H H H H 3' 3' 3' �1' 3' rn O O l0 O O un un O l0 N O M f— H w a w a Q J-) J-) (0 (0 (0 (0 . W W W Q Q Q Q H aaaaaa 0 riri �I Cia � a) U U rt H � � > > > > U U w w w w x is W N w w U U U U (0 +) O wwaaaa #I-f2L4 oo x x x x �-4 >1 z rt rt rt (0 0�-4 H W O O H H H H a) +) O rt c �7 co � � � � � -I � c � x a) a) a) a) a) a) �a4 a) a) a) �5 U U U H H H H �, rl U +) O w U U (0 (0 (0 (0w U ro�-4 x W N O N 00 U z H W a � H U W W N O H N Q0 H Cia H O O O O O O O O un un O Ln* N N 61 N O un H H N H O O O O O O O O H O M O O O O O O O O M O (1 O O OLn* Ln O O O (1 O O O un un 61 61 un un O 61 H M O N l0 l0 N O O 61 N H H un H H M f � � O N O H H H H H H H H O O O O O O O O O O O O O O O O I I I I I I I I I I I I I I I O H H H O 61 O un un un un un un un un O CSl CSl 61 O un O un un un un un un un un O I I I I I I I I I I I I I I I O O O un O O O O O O O O O O M W U1 U1 � x xxy E E O O O Q H a) u u Q U rf) rf) Cia W Cia Q PQ PQ 0 H a O O 0 Cia H H Cia a I 0 rt Q w x x w 0 Q 4ri 4ri N 4ri H a)ri H x x H f a l) l) (\J l) H J-) N Qz� Qz� N L1a CD (0 UN ON 04 N (\] N x a) F4 O Q Q O W F4 FC '0 oo '0 o a w U H H U W oc \ .� .li .1i H H W �D �D Ga H Q v) v z v xrf) w a Q Q a r z z a) a) W a) 1, rt w O w w O�-1 W W �D a H Gw a s Gw f24W H �7 04 w x W U Ul O w w w W> O x a u a a x H au a� a> a> a> a> ., .' x .� a) rt H W�-1 x W U U U U cn x a, Q x U Q z O U H z a a a O a H z � cn w i7 H Q cn U z z a w H w Ha� h o U) Q a H a w a O U Q h H W Q x U U U O w w f::) >! 0 f2L4 N co Oo N N N N N N O O O O O O N N N N N N Oo 00 00 00 Oo Oo w w w w w w Ln m m m m M O 31 M O N m 31 H O un M H N l0 N 1-1 • • • • Ln Ln Ln Ln Ln H H H H H N x O N l0 U1 U x x �D Sa I N Q U O a a Q H O � x 0 '04 D M H 0 cn M a H ,sz H U i > W W Q +) w a z M H m O .Q N N N N N N N O O O O O O O N N N N N N N N N N N N N N H H H H H H H H H H H H H H O w H E H H N D Fo � N z\ 0 " z\ H N U N � �D o O 4-) a N a 0 \ r N S4-1 p \ N U m a a Q w � a 0 a z w w w w FX El U1 Q a z x CQ U � w Q u x u w x u a ZH- 14 u U � H w 1i x 00 � o � N b O H -) U 1J O O Q N f7 J-) x U H .D Q u O M m O N un O N 1-0 1-0 1-0 N O un H M N N H o mmCDQ0Q0Q0 h m N m 31 O O O H H N H O O O O h l0 l0 l0 O l0 l0 l0 H N 3' N N H H H H v un N m Ln Ln m O O M N of i' H H H un H un m O Ln OJ l0 m M N M h m M l0 M �' M l0 N Ln m m H N l0 N O l0 H H un H N un O O O O un N Ln i' Ln N N Ln Q0 ,3' H O H l0 H H OJ Ln Ln � i' i' Ln of of M M M O �3' N N 3' 3' H l0 H �' N N 61 H 6 N N M L H H O O O O N N H H H H N N N H H H H H N f� OJ OJ N N O M M M O O O O O O O O O O O O O O O O O O O O O O O O O O O O I I I I I I O O O O OJ OJ I I I I I I I O O O O OJ OJ OJ I I I I I I I I I h h O O O �' l0 O O I I N N I O I I I u� h h O O O O OJ OJ un un un un of of of i' i' un un un of H M M of of O l0 l0 l0 O O O O un un un un un un un un un un un un un un un of 61 61 Ln Ln O un un un I I I I I I �' l0 l0 l0 H H I I I I I I I H H H H H H H I I I I I I I I I H H H H H N H H H I I N N I N I I I H H H un m m m O O O O O O O O O O O O O O O O O O O O 3' O O O H H H H 3' 3' 3' 3' 3' �1' �1' �1' 3' 3' 3' 3' 3' 3' 3' 3' 3' 3' 3' 3' H 3' 3' 3' H � O a H H H U H H J-) C C7 a) Q Q a) a) Q U1 rt Q Q H rt .D .7 co co .7 . a) .7 .7 w w w w w a 3 3 a � �� w a) a a \\ a V) a a H z z a 0 0 3 3 0 rt 0 0 n w w a) a) a) w n w w a 0 0 w W H H H H H H rl .� H U1 H sz sz sz 0 �-1 0 1 1 0 +) +) 0 z 0 H H H H H 0 5 5 5 Q Q Q 4-)4-) cr) cr) cr) A A a CO V w i O �/ �/ �/ N H b a) a) M 11 ri X a) a) h U1 a) a) a) M S: U1 U1 M S-1 S-I M W U U M a a a a a a a � 0:) 0 0 0 a) a) a a 00 li li 0 H o�� oo H � � � � � � Ra Ra Ra J-) -' x x Q Q z H a) a) x x x 'z, z Sa S-1 m m m (0 S-1 W W z z W U) U) U) rt rt rt W U1 U1 U1 U1 U1 U1 U1 W O i- O i- rl Q ri Q rl Q rt W U .,i U W ri C7 U1 H a) W a) C7 U S-I Sa Sa Sa L� a L� (0 ( l-) l-) S4 S4 o U U U x O O O O o 0 o x ��-4 w w w I -rl -rl x +) +) x a U) .� .� x a w w w 0 44 44 44 44 w w w 0 w w -P -P -P w r1 r1 0 U U 0 a 0 H H H W rl ri rl ri H H H W �', �', CO CO CO rl Qa -r1 -ri W a) a) W W J-) +� W 04 Uri Uri Uri FA FA U � �� U �� a U�� U w w u H H 0 0 u O z z � 0 0 H z U z W 0 U a �D Q a � w w 0 x H H [x n 0 z a H H C 7 I -a a 0 0 M M M M M O O O O O N N N N N 00 00 00 00 00 0 w w w w w H U W a W N N N N N O O O O O H N N N N N Q0 Q0 Q0 Q0 Q0 O w H N H H N D EO � N z\ O z\ H N U �D O o +� a N Q O \ , N S4-1 p N U a \ U) H a Q w � a O a z w w w w FX El u) Q a �D x �Q u � w Q u x u W x u ro a ZH- 14 u u z H a 1i x 00 � o � N b O H -) U O O Q N f7 J-) H .D Q O O 61 O un M N un H l0 O 3' h 3' 3' m N 00 O h h h m 1-0 H 3' H M m l0 O H M 3' H H O f� O un H l0 O H O l0 [-- CD O M Ln h l0 61 O Ln h H un N 3' H N l0 O N O O M O h h M ,3' O 3' h N h M 61 l0 M N 61 61 H O 00 N O h 3' O h 00 O h h O l0 O O H H N OJ H H H m m m m O O f O H f N O O O O O O O O O O O O O O O O O O O I I H 3' I O I O I I I I H H H H I O I O I l0 I I O 3' I l0 I un I I un un N Ln Ln Ln N N N N O O H O un H Ln 31 CSl un un un 61 61 m m O O 61 O un 61 Ln M M I I I I I I I I I I I I I I I I I O O O O O O O O 3' 3' O oo O O O O O J-) a) H H O H z O z �a4 z w w a w Q a o f24a o a, o w w li w a rt w w O sz �-4 O �-4 U O H H H 4 4-) �-4 Ul a) Ul Ul Ul Ul N . i 'H (0 oc) 'ri S-I r1 J-) M a) U a) a) a) a) i) a) 3, 1) a) i O un 'li o C O o C 3 w a) o r1 N U1 U1 a) a) H N a) O r1 N R14 �-4 R., R., R., R., 00 H H '� fx #I- oo P, W oo �-14 a) �-14 �-14 �4 �4 z z rt �5 n �5 �5 �5 z w w x z z U1 U1 U1 U1 U1 U1 U1 W , , a) (0 O +) +) O �7 U 'ri H H U U U O .Y. L14 L1a I �a4 �a4 1 'l 'l 'li U a a a) a) U U a) a) U LH R4 p, 4-1 4-1 4-1 4-1 W W W R, —1 W R, �4 '0 O W LH �5 �5 w w w w x > > .11 (0 a) x .11 �5 'ri O x O O m U) O O O O u O O u cn 0 u U a cn 9 u O u a z a O Pa H � �D w O a U cn cn W z z w U H H a H x o w a o w H \ O > W a Q H h 1 z H '.7 H (� a w . z x x x H Oo 0) Cl H N co co 0 0 0 0 0 N 00 N 00 N 00 N N 00 00 H U W a W N N N N N O O O O O H N N N N N Q0 Q0 w H H H H H u z U) O z O � 1 a U) u H wf2L4 a H a z z ww O h w a w z w O M u OD 0 0 0 0 N N N N OD OD oo oo w w w w N N N N O O O O N N N N N N N N H H H H H H H H 61 H co LO LO 0 0 0 N N N OD OD OD w w w N N N O O O N N N N N N H H H H H H • • M N N ,3' 3' N N O 00 O 3' N N 3' O 61 un l0 M O h 61 un un M O H h h N H N N O H H Q w a O O U W W a a w W H 60 o 60 o H O 00 00 1 3' W Ln W U o z z H w u Q H x a a u W w H a I W w H Q a Q w u w a 0 N OD z W N O N N H H OJ O OJ OJ O O O O I I I I H O un un N O M M G) O 0) 0) I I I I H N H H O 3' O O ,3' H 3' 3' rt H a +) �-1 (r) (r) O H H a n a) a) z u W a) a a n O C7 C7 rG a z a x cn H H 0 0 0 N N N Oo Oo Oo w w w N N N O O O N N N N N N H H H H H H W H E� H H N D Fo � N z\ O " z\ H N U �D O a o +) 0 N Q Ga \ S4 r N -I p N U \ m a a Q w � a O a z w w w w FX El U1 Q a z x CQ U U2 W Q U x U w x U ro a ZH- 14 U U � H w -) x 00 � o � 1J O O Q N f7 J-) x U H .D Q U Q0 O O M ,3' O O l0 � Ln Ln i, N N M H Q0 H m H 1-0 h m aT H 61 O H O N m H h l0 ,3' N ,3' l0 N l0 f� O f� 1-0 O H 3' O m O H M O 61 3' un M m h H m � 61 un m O m N O M H H H H O O m m l0 l0 ,3' O m m O O O O H H O O N Ln l0 l0 l0 l0 l0 H N N H H O O un 61 O OJ M O N � O M OJ O 3' O ,3' f� O N O O O H H H H N O O H H N N N H H H N N H N O O O O O O O O O O O O O O O O O O O O O O O O O I I I l0 O OJ I I I I I I I I O O O 3' 3' 3' 3' m I O I O I I I I I 3' 3' m m m I O I I I I O O OJ OJ I I O OJ H O OJ O O O un un un un 61 O O un un M M M un un un m m un 61 61 O un O O O un un un un un O O un un un un un un un un un un un un I I I H �' H I I I I I I I I l0 l0 l0 N N N N N I N I N I I I I I N N N N N I H I I I I H H H H I I H N O un O OJ m OJ O O O O O 3' 3' O O O O O O O O O O O O ,3' H 3' H H H 3' 3' 3' 3' 3' H H 3' 3' 3' 3' �1' �1' �1' �1' �1' �1' �1' �1' N H O H O Q I Q 'D M 'D W 0 W H a a O a O aw r� aW O °Q 0 0 H H H rt W CSl rl U) H un J-) 0 O U O N a) N 03 03 a U x U a H U a w x a x U U U) W U w a w Q � w �5 N O H �-o �-o O O N N oo oo w w C7 C7 N N O O N N Q0 N N H H H H Ln OJ N M O ,3' H H H H U U U z z z z . . . . H H H (r) (r) (r) (r) W CO V) V) W W V) W Q Q Q H H H H H H H H a) a) a) rt rt rt rt a rt rt rt a a rt a a a a '� '� '� '� O '� '� O O O W W W W a) a) a) a) a) a) a) a) sz sz sz (0 O O �-1 O O 'ri H H S-I S-I S-I a s H H U) l) 'H 'H 'H l) l) l) l) a) (\j a) W J-) l) l) un O J-) H a) a) a) r, r, r, r, +) 1-0 U U�i rl rl 1-0 r a rl [-- U U U fo fo fo (o (o O H H a) a) a) O O a a) O a) a) a) H H H H X N U) U) 'J ,'� r, r, �, N a a s N , (\j a a a f2L4 04 04 Pa 00 H H �-4 a R, R, R, 00 0 p, 00 z z a) W 'li 'ri 'ri W W W W W ri x x x z W W U) U) z z z rt rt (0 H H H O O O O w a) C7 a) W tr W tr W tr W w U) U) w tr w W C7 (l) (l) (l) (l) H '0 C) V) UZ UZ UZ UZ UZ UZ U Pa Pa 'H H S-I S-I S-I O O O O O a) a) a) a) a) a) a) 'li U a a cr) U) a) a) a) U w w w w w U a) U H H H U U U U, Il W W W J-) H 3 3 3 W .1 'H 'H H H W S-I 3 W rt (0 (0 U U U U a) x > > �5 p 0 0 0 x rl r z z x a) O x U) U) U) FC FC FC FC > U O O O O f2L4 f2L4 0. U �D �D �D U f2L4 0. U cQ U) 0 O z U H a �a Q H a O O � o a z z z W O O O w cn 0 u Q o a � O x Q H ° a H U) 0 w a w a H z H u u u N M J' u7 61 O H O O O O O O O N N N N N N N Oo Oo Oo Oo Oo Oo Oo w w w w w w w C7 C7 C7 C7 C7 C7 C7 N N N N N N N O O O O O O O N N N N N N N N N N N N N N H H H H H H H O M H Ln a) a w H E� H H N D Fo � N z\ O " z\ H N U �D o o +� a N a O \ , N S4-I N U E1 \ U) a a Q w � a O a z w w w w FX El � Q a �D x �Q u � w Q u u W x u ro a ZH- 14 u U � H w 1i x 00 � o � O O Q N f7 J-) H .D Q Ln N M N N l0 M C un O M M H H CSl M H O H O O O O O O I I I I O Ln 31 O O un M O I I I I O O O OJ H 3' H H un O O O O M 3' O 3' O N N O O O O N N O h un O h O O O O M l0 CSl CSl N un N 3, O N 3' M 3' l0 O O l0 un l0 M h h H 61 N N H O H H H H a) a) Q O O z l) (0 . H S; H w a) r, a) a a as O w t7' a) W a) H H H sz co U sQ O U + Q0 U a) [-- u a) O O a) a) H a) N a x w a oo x >1 x z H O H �7 UZ U1 l) U1 U1 a) rl a) a) U cn a 9 cn w N M l0 r r r O O O N N N Oo Oo Oo U w w w H U W a , 3 W N N N O O O H N N N w H H H N O H O N M N 3' O H O O M N O l0 h 31 61 N M N N O O O O O H O O O O O O O O O O O O I I I I I I I I I l0 l0 l0 O O un O N N M M M O O un O 0) 61 I I I h h h I N I N I N I N I I H H O O O 3' 3' O 3' O O a) � H H a .D Q Q FG �D �D W W w w a a s ,Qw-0 o o a) H C Gw Q Q > w aw O O Ln H O H H O H H a) H H H H sz U O O oo 0 CD� CD H W W °' a s oo a ro z z z O W w 0 0 w oaoa 0 '10� U H u a s e a u � C H x > > � > a s x x x u O O O O Q Q u w w Q Q O O z w a a a w Z w w a x a Q u z o W H cn Q w w w w w C W 0) Cl H N f C C W W W O O O O O O N N N N N N OD OD OD OD OD OD w w w w w w N N N N N N O O O O O O N N N N N N N N N N N N H H H H H H N O N H M H O H h l0 N N 3' Ln O H M 0 h un H H N M H N H O H O O O O O O O O O I I I I I I I I O l0 Ln O L N un M Ln Ln Ln Ln L L I I H H I I H H I N I H I I H H O O O O O O O O H H a) O H H a) H Q Q H �D rt w (0 w o o w +) w rt rt aa aa Ul Ul O H a) rn Ln �-4 oo rt O H oo + a) oo O O O a +) O a s N H oo a b oo +) H -li a) c o w w 5 a o w o a w w �a 0 w u z H a z U O 0 w a z z w H O z a x H H x h Q a a ° Q a w w Q a OO 00 00 00 00 Oo Oo O O O O O O N N N N N N Oo Oo Oo Oo Oo Oo w w w w w w N N N N N N O O O O O O N N N N N N N N N N N N H H H H H H O W H E� H H N D EO � N z\ O " z\ H N U N � �D o 0 N Q w \ S4 ' N -1 N NU\ m a a Q W � a O a z w W W W FX El � Q a Y m u u) W Q u x U W x U ro a ZH- 14 u U � H w 1i x 00 � o � O O Q N 17 J-) H .D Q H f� in in O H N M N N 1-0 m M l0 h h N N 61 H H H OJ 61 O H 00 31 N O O Ln 31 O O M h N M 0 O 3' O O l0 l0 0-) O l0 N N O O h in in M O Ln N H Ln 0-) O M M O oo 3, Q0 O H o Ln O O H f-� in H N 0-) AM 00 H H N N m H O O O O 00 N M O O O O O O O O O O O O O O I I I I I I I I I I I I I I M in in 0 of M in O O O O N in in 61 Ln Ln Ln Ln 0-) Ln O O O O 0-) Ln Ln I I I I I I H H N H N H I N I N I N I N I N I H I I H H O O O O O O O 3' 3' 3' 3' O O O C7 H a M W O a O O H El � �D �D H � w w rt w w a a 1 U o° ,D O N O w w w w a W W a ,D U C� c/n aI n w W z H O O H w H a> a w oo EW-I L1a EW-I a 00) J4--) N 'HZ, cn 0-) a a CD CD � z � w O 'D Ot 00 a) H H H H Q W w 00 Ot W O z z z z Ra C7 �5 FC, W z U U a U U x +) w w w w U � x H H w H H u a a a a 1 u O x x H x x W 'ri w w w w 4-1 W �-4 w w w w x rt > > > > w x 0 >> >> U O O O O O H H U t w U w a a can a a W cn U n W H a o 1 o w x a w O z a O n U 0 H N U Qon on a w o w w H z z w H w H H a w O w w w w w W W a w x x x� o o 0) O H N co LO rr oo 0 01 01 01 0) 01 0) 0) 0) O O O O O O O O O N oo N oo N oo N oo N oo N oo N oo N oo N oo U w w w w w w w w w H U W a W N N N N N N N N N O O O O O O O O O H N N N N N N N N N 00 31 M 0- Ln O l0 h l0 M h l0 6 H 3' N N in M 0-) 31 O 31 0 0-) Ln 0-) H M H Ln Q0 DJ H N N N O H 00 f O 00 H H 00 O O O O O O O O O I I I I I I I I I ,i' in M H O N in in N M Ln of 0-) O 0-) Ln Ln 0-) I I I f N H I H I N I H I I I H H H O O O O 3' O O O O H 3' 3' 3' H 3' 3' 3' �1' +) w w w w Q O O w w t7' rl W rt a I a O H a) (0O �-4 +) 'H +) (0 �-4 0-) O a) rn a) O a) l) O Ul H H H fo N U1 cn N W #I- 00 H 00 z 1 SDI O w .11 ul ul w O C7 U a) a) C7 rt 1 L14 L14 H H .Y. a s� w Qo H w W u a w 0 u z H o �z H o H z U w U Q �D > O a f24 H � z z O w W z w o (5) CDN LO 0 (1) O O O O O H H H H N N N N N Oo 00 00 00 00 w w w w w N N N N N O O O O O N N N N N N N N N N H H H H H u z a w 3 w a w r O N oo z W N O N \ N H w H E� H H N D EO � N z\ O " z\ H N U �D o o +� a N a O \ , N S4-1 N U p\ m a a Q w � a O a z w w w w FX E1 U� Q a �D x m U � w Q U x U w x U N ro a ZH- 14 U U � H a 1i x 00 � o � O O Q N f7 J-) H .D Q H Q0 H M O H H O un O M N O H un un H l0 N 61 H 61 N O h 31 un O Cl) I N H m O N H N H N l0 O M 61 O N l0 Ln M 31 O 31 M 0 O Ln r- O N H 3' N H ,3' H M Q0 Q0 N 00 O O O O O N O O O O O O O O I I 00 H I I I I I I O O O O O O) 61 N O O O O O OJ un 61 O O O O O un I I N H I I I I I I I I 1 l0 l0 H O O un un un O O O H H H H O O N N El O O H H Q a a Q 'z, z w OW OW U z z O W U1 U1 w a O W O cn H aa Ln Ln W N N rl ri H M N N N N H U U � a x x a a w oo Wwy a a w U1 fr. M M w Wl Ow H H iW7 W H U1 U1 U1 H N N H U o p p cn cn Q u a a w a z O H U1 U1 Uz � H cn a w 0 I El � w rG H Q U a a a OD O O H N N N oo oo oo U w w w H U W a W N N N O O O H N N N w H H H 61 O 3' 61 M 00 � h O 61 3' 61 N 61 H Ln* un O 3' 61 H 61 N 31 O 3' un H M H N M 61 m un O M N N l0 H 61 H H M M h h M H Ol O H H (3) N 0 03 03 03 03 t� 03 H H 03 03 �.0 03 o O O O O O O O O O O O O O O I I I I I I I I I I I I I I O N N N N H N Ln Ln M M O N O O 61 61 61 61 61 Ol un Ln 61 61 61 Ol O I I I I I I I I I I I I I I M O O O O O O O O O O O O 3' 31 11 11 31 U1 J-) U U1 w �'. w O O O Q w w Q U1 w Q x o o a a H H IW-I 1 rt -0 co '� H a U1 co U) Ul l0 11 S: N N f� Pa W N W N H J-) U N Ul N �" Pa H H H H H J-) H U1 a H a H (\j N a ,7 J-) �5 (\J I w U) \ f2L4 a 04 a 00 Sa O 00 U H Q Pa a s a w N O z H z ,D U) U) U) U) W N S: co W H f24 w C7 f24 O N N co C7 H W W W N W N �11 '0 '0 U U1 P: U U U U .'�. a O rl (0 rl .Y. W Pa H H H H U N 4-1 U) S-I �5 U a a P.' Pa w 4--1 w 4-4 W a H .11 J-) bi O W a H W w w w w w x .1 �i �5 a�-4 x O > Q O O O O U U H �D O �D i7 U U O U z H z w H U a z H 11 o a u p a O o a H H a H 0 O H P Q W W axa o °a o Q u Q FA H a a a 9 H W Q Q Q W > O GH+ W H H f24rzQ� x E H H Y z z U1 U1 U1 U1 U1 H H H H �D �D �D N M W 61 Cl --I N M J' LO H H H H H N N N N N N N N N N N N N N N N N OD OD OD OD OD oo OD oo oo oo oo z z z z z z z z z z z W W W W W W W W W W W N N N N N N N N N N N O O O O O O O O O O O N N N N N N N N N N N \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ N N N N N N N N N N N H H H H H H H H H H H w H N H H N D EO � N z\ O " z\ H N U N � �D O o +� a N a O \ , N S4-I p N U a \ U) a Q w � a O a z w w w w FX El u� Q a z x m u � w Q U u W x u N N a ZH- 14 u U � H a 1i x 00 � o � O O Q N f7 J-) H .D Q O o 31 O N 3' N M h �3' Q0 N ,31 CD H Q0 Q0 Ln oo Q0 N h 61 O M 1 H 31 H N � Q0 rn Ln O M 31 6 in M N N N N O H Ln of O H 61 of 61 � l0 M H H N un OJ Ln H Ln O O OJ O O N H H OJ O O O O O O O O O O O I I I I I I I I I I ,3' 3' M O O O 1' un M O M M 61 O O un un un 61 O I I I I I I I I I I O O O un of O O O O H a H x Ln w U w w Ln w w w Ln w Q a a, a, 0 a 0 H 0 H aw awaw 0 0 O A O a x w O w H H H � � H l) l) Sa l0 ri h �, of U U N N '0 N N i) H U H H H N N N N H U1 N U1 w w� Ln a oc oc w a x z W S-I S-I W (0W O H W O 0 0 C7 H C7 H Q C7 W Z E co co �.' ,`i, H co H ,`i. a r l N N E U Ui N H U W H a U a U U O W �D H W W cn H W W J-) U U x O ro a x w H x > O �7 u x cn w U x U O H u z H U F H u a o W H H x H H H O n z H a W w W o a H w a w C7 H U W Z � H H H H H 0 r oo N N N N N N N N OD OD OD OD H w w w w H U W a W N N N N O O O O H N N N N w H H H H I U? w H E H H N D Fo � N z\ O " U1 � z\ H N U E� �D O x o a N a O \ ,4 N S-I p N U a \ U) a Q w � a o a z w w w w FX El U) Q a z x CQ U � w Q u x u w x u a ZH- 14 u U � H w 1i x 00 � o � O O Q N 17 J-) H .D Q un O O O l0 O O O Ln O O Q0 O M N 00 � O O O O I I in l0 I I N in M H 0) O 0) 0) OJ H I I H H I I N l0 O O O H ,3' 3' 3' 3' O O O O l0 un O un f� N m Ln Ln N f� O O O O m Ln M N N l0 un N H M O . . . . . . . . . . . . . . . l0 O u� CSl u� �' h N OJ �' OJ M O M OJ in 0-) 0-)M H N �' 3' 3' O un in 3' N N M OJ H w Q H , (0 w � a a) O w rt H O �7 0 a f N a) OJ � U? u � �I l) a) U U a w u H z w Q w h z o h as 0. H w N N N O O O N N N OD OD OD w w w C7 C7 C7 C7 N N N O O O N N N N Qo Qo Qo w H H H N H N O 3' 3' 3' N O OJ OJ OJ Ln O rn rn rn Ol Ln H H H l0 M H H H N O un l0 Ln Ln H rn r H O Ln OJ h H M H 3' o Ln o 0 0 0 0 0 0 31 31 31 31 31 t� O O O O O O O O O O O O O O O O O O I I I I I I I I I I I I I I I I I I O un O O O O O O O h h h h h H OJ OJ OJ O OJ O O O O O O O OJ OJ OJ OJ OJ CSl OJ OJ OJ I I I I I I I I I I I I I I I I I I M O un un un un un un un O O O O O O O O O U1 N � H � W I 0. U O W H U1 H a a �D H a U) a \ FA a x c H w w W 5 W H FA O C� 0 aN ,T, 0 0 W 04 z - H w w a Q Q N H a a Q x a 0 H 0 x 0 W a) O C7 c H Q H H a a a H H U1 Q H I M H H f0 Q Q Q a a C7 U1 H H ,5 x n O Mo .1i z z z N Mo a Ex Q oc) ()o Q +) a \ H 16 16 w a W H W a H W O O O Q H> 04 H> u w w w U F4 0 Ga-1 H H H, Q z z z Q a W w z w H H H H H U u �D �D �D U a w w Uz O U h a a a u z Uz a w O W w x z H � w O Ela O H z °a w W Q FC FC a U OD 0) Cl H N N N M M M O O O O O N N N N N OD OD OD OD OD w w w w w C7 C7 C7 C7 C7 N N N N N O O O O O N N N N N N N N N N H H H H H H H H H H H O M O rn Ln Q0 � Q0 3' � 03 03 03 O O O O I I I l0 O O O H M M O C C Ol O I I I I O O O N ,3' 3' 3' N a) a) Q CO CO �D (0 (0 w � � a O a) w J-) J-) O H � ai of cn Ga l) a) a) N a) x Q Q 0 u � f) l) l) U1 H U a � � x 0 U�D �D U cQ z w O x 0 U Uz x w O U� x w H x u w M u} M M O O N N Oo Oo w w C7 C7 N N O O N N N N H H H H W H N H H N D Fo � N z\ O " z\ H N u 1 �D O o +� a N a O \ , N S4-1 p N U a \ U) a Q w � a O a z w W W W FX El u) Q a �D x �Q u u) W H x Q u x u W x u a ZH- 14 u u z H w 1i x 00 � o � N b O H -) U O O Q N f7 J-) H .D Q O Ln m rn 31 M Q0 Ln i, H m H N N M ,31 O O Ln H O O M un O un H O O N M H 3' f� H Ln O Ln oo i, M in in N M 10 3' r N M un M l0 3, 61 O Q0 � o 31 O H O 3' l0 M O 01 01 O O H l0 00 O 3' N ,31 00 Q0 Q0 -o Ln O O 3' O Q0 H M O 61 M 3' O h H 61 00 in 3' 61 61 N O l0 h H M H H 00 31 00 00 00 00 � o 31 31 o 31 31 Ln o 0 O O O O O O O O O O O O O O O O I I I I I I I I I I I I I I I I N CSl N N N N H O h h O h CSl un O O 0) O 0) 0) 0) 0) 61 O 00 00 O 00 00 00 O O I I I I I I I I I I I I I I I I O O O O O O O un O O un O O O 3' 3' W N H N in (\j N W M W W W a z a w a a O O O f24 O O W p rf) F 0 a ro O x O a) w O 60 O H H H oo O H rt C H W U1 a) U1 U1 U1 U1 N .11 in pi l0 a) u) O u) N 1 3' a) l) a) a) a) a) 3' l) 3, Qa Ln 'z, I W in .li O 0 O x O W W U O r1 N a) W H N W a N U u 'may N Q!a Q!a Q!a Q!a Q!a 00 '� H w oo O H fa�C. 00 Q Q Q Q Qa4 a a �5 �5 �5 �5 �5 z (r) U W z c z �D z cn (r) cn cn cn cn W a) O W b c H W Q �D cn W a C7 a a Q 0 i N C7 rf) z C 7 U U U U U O .Y. .Y. S: S-I .Y. a .r1 .11 .11 ri r1 .ri U C7 U rl W a) U a W U w w � wwww wwww w x a � � w�c rt H qw x O O O O O u u W H u H f2L4 H u a s u O u a z a O Pa H � �D a w O z W u H a H O W a o a W n H F-D �D z x H OD H N co O O O N N N OD OD OD w w w C7 C7 C7 C7 N N N O O O N N N N W H H H W W a H H W z H a W � o Q ) a w x �D x U n H H H H �a w a o O O O O O O N N N N N N OD OD OD OD OD OD w w w w w w C7 C7 C7 C7 C7 C7 N N N N N N O O O O O O N N N N N N N N N N N N H H H H H H H H H H H H O H 00 31 Ln O O O O O O I I I I I I H O l0 in in in G) Oo Oo Oo Oo Oo I I I I I I H H H N N N O O O O O O u I W H H a a a a w F� cn W W W O a) H Q r H n R , W � � � c W W w w w � W a a a H H ' D f2L4 f2L4 f2L4 z a U Q z H O a oEll FM4 H w w H a a H Q N � O O O O O N N N N oo oo oo oo w w w w C7 C7 C7 C7 N N N N O O O O N N N N Q0 Q0 H N N N H H H H N H H H H O I w H N H H N D Fo � N z\ O "' z\ H N U N � �D O o +� a N Q O \ , N S4-I p N U a \ U) a Q w � a O a z w w w w FX El � Q a �D x �Q U � w Q U x U w x U ro a ZH- 14 U U � H a 1i x 00 � o � O O Q N f7 J-) H .D Q H O O O m m H31 n m H m O 3' H O f� un un O M un H l0 N M N m N H 1-0 N M M N O N N O 61 3' 31 Ln N 31 O O Ln r rn rn O H H f M H H H O O O O O l0 M O un N rn Ln O r Ln M N O 0 un N N M O O un h N N N O h N h H 0 0 0 31 31 31 31 Ln Ln 31 31 o t� o0 o0 O O O O O O O O O O O O O O O I I I I I I I I I I I I I I I O O O h h h CSl un un O O CSl H N N O O O O O O O O O Oo Oo M CSl CSl CSl I I I I I I I I I I I I I I I un un un O O O O O O O O O O O O H H H a N a N N N w M �D H H �D W W w Q X N w H H w ,D ,D w a H H H a s ow ow o o H rt rt w PQ PQ w a, Qa 00 H a a, x H U U H .rl H H H O W f2L4 H O .11 .1 �-1 O H H O H H Q H i-I i-I P: P: H H H H H z W Ln l0 U U 'Z, z O C 7 C'J (\j to M W �.o a) a) 7 7 h S: J-) O O O O C'J O H H O O U U O N FC, l0 N W W a s N .1i N W W N a Oo Oo +- a s Oo z ��x co z z +� (r) z w a o H W w n n w a) a O O W Oa Oa . w � 4-) a .Y. W U w f-I .Y. .rl .11 O O .4 Ul 1 .4 U > ,D > a) U H H w w U rl U ww a x rt x � 4 w w x � li a s x U a H H H x U �D �D �D �D U H U a a U a U H �a � w U w � w H a a u a z �a a H w o w O a �HC x w o � w H H � H O O O a U a x aqq " " fx a cn W rG H Q H oa H z� a 0 w a cQ m U U U Q w OD O l.0 l.0 l.0 I— C" C" W O O O O O O O N N N N N N N OD OD OD OD oo oo oo w w w w w w w C7 C7 C7 C7 C7 C7 C7 C7 N N N N N N N O O O O O O O N N N N N N N N w H H H H H H H un oc M 3' N h l0 r 1 oc) O H M 1 Ln H H H � Ln oo 31 o0 O O O O O I I I I I h un N h M O O O 61 I I H H I H I I H H O O O O O ,31 31 31 31 31 f� 3' O M 31 O rn 1 Ln � � H H O N N z z .ti .ti w w 0 0 w w U M rl f-I OJ Oo Oo O a +-) O (r) Oo Z:7) z Oo 4-) Ul H O w U H W +) W +) O W a 0 0 U z H a u z u o w z 0 a x w z H H h Q a Q a a 0 x x M f OO Oo Oo Oo O O O N N N 00 00 00 w w w C7 C7 C7 N N N O O O N N N N N N H H H 00 31 O O I �n N M CSl O I I H N O O ,3' 3' w H Pa a ° w O U Q z a O x x U U w w O W 61 O O N N oo oo w w C7 C7 N N O O N N N N H H 0 w H E� H H N D EO � N z\ O " z\ H N U �D O o +� a N as O \ , N S4-1 p N U a \ U) a Q w � a O a z w W W w FX El U1 Q a �D x m u � w Q U x u w x u ro a ZH- 14 U U � H a, 1i x 00 � o � O U Q N 17 J-) H .D Q O O H O O O N 00 3' ,3' 3' � H O 00 Q0 31 O O Ln O O O 3' in 61 O O in H 61 O h f� H in O in oo h O h OJ N O un un H M H un O H OJ H N 3' L Ln 0-) Q � Ln M N in H M 31 OJ O l0 H m oo H OJ Ln N h O N l0 rn rn O O rn Q0 Ln O ,3' OJ F- O OJ �1' 3' N l0 M G) ,3' � O Ln Q0 N N H ,31 31 31 � 00 00 � � Ln 31 31 oc) 31 31 oc) 31 �11 oo o Ln O O O O O O O O O O O O O O O O O O O O I I I Ln Ln Ln I Q0 I H I Ln I Q0 I Q0 I Q0 I I i, Ln I H I I 31 31 I H I I Ln Ln I H I I O Q0 61 61 61 —1 N M r1 r1 in h O N h h N 0) 0) N O un Oo Oo Oo CSl CSl 61 G) G) Oo 03 r1 G) OJ oo 0) oo oo 0) O oo I I I N N N I H I H I H I H I H I H I I H l0 I H I I H H I H I I N N I H I I l0 H O O O O O O O O O O r1 O O O O O O O oo O 31 U O W C Ln Ln O N �D W �D �D W w w w w w aaa z �D �D �D O a O O O O w w w w U1 w H w w Q W U1 U1 FC FC w U1 w � 17 C7ri J-) H a) H a rf) 0 0 0 o o H H a a a U U1 H a s J-) U) w W W O .1i cn a'T Q0 cn w w oo O H H H rn +) W a) a) +) W z O O W H H o a) r1 O is H J-) U1 is Q r1 r1 H H O r1 N a) F4 (0U1 a) H x N N F4 N U r1 N Oo a, FC n n 00 oo a, oo U (r) oo ri asrl H O as I 1 J-) U1 �D as M .7 � �/-� W co co �D �5 U1 U1 U1 W a) U1 .11 a) O N W 'Z, H H W U1 U1 U) W bi O W W W W u a O a a a xEi W a s bi H I U U U .Y. 1 U S: I I C'J H ,Y, as S-I S-I .'�. U U U .Y. S-I .'�. H H H U H w H U w a) a) u H H H U J-) a) u x x x W a, w O U as z w n w a +) +- w w x x W (r) rl W W W W x .11 w S-I O r1 H a as x W x w W W x O H r1 x u u O Q u a w z U H u O u a u a u W u a a W H a O a O u a z a W H U1 H a 0 0 0 a a H U1 H W U1 H z a, a, cn > w a, 0 z H H U H U1 W oa � H Q u u a a z z Q O O H H H O z W lzi w a u a H w I a w H O z u O H H o qW Q w a z w O Q U z z z z a x w o z H w H O O o x a a x w a z z z O a a a a 61 C) H M OD 0) Cl 61 61 (1) CD O O O O O O O O H O O OOD H H H H H H H H H H N N N N N N N N N N N N N OD oo oo OD oo oo oo oo oo oo oo OD z z z z z z z z z z z z z W W W W W W W W W W W W W C7 C7 C7 C7 C7 C7 C7 C7 C7 C7 C7 C7 C7 C7 N N N N N N N N N N N N N O O O O O O O O O O O O O N N N N N N N N N N N N N N \ \ \ \ \ \ \ \ \ \ \ \ \ w H H H H H H H H H H H H H I w H E� H H N D Fo � N z\ O " z\ H N U �D o o +) a N Q O \ , N S4-I p N U a \ U) a Q w � a O a z w W W W FX El u� Q a z x �Q u � w Q u x u W x U a ZH- 14 U N u � H a 1i x 00 � o � 1J O O Q N fo J-) x U H .D Q u O aT O O O N H un aT O h l0 l0 h Q0 �n oo rn rn l0 un H M un f— N H f� O O H un O O N O O � M O 61 M 0 00 Ln 31 o0 o0 o0 O O O O O O O I I I I I I I O N Ln 61 N N N O 61 O O 61 61 61 I I I I N I I I H H H M O O O O O O W •• U N H � W Q W H �D cn a (r) W a H �7 w rt a z H O r W Q Q x H W U1 P H H I H 1-0 f2L4 w W N w N Pa H a N H H H H Q a �a4 a �a4 w U) w tr cU) U) w W H W C7 a U H S-I U u U H a N H H H U Pa W H ,L,' 4-I W 4-4 W Q 0 � 0 0 0 0 w z � w � a U H a H � w �7 a z W H cn H H wO a a x a a u a W rz� x O O E H H H H H H H H H H N N N N N oo oo oo oo oo w w w w w C7 C7 C7 C7 C7 C7 N N N N N O O O O O N N N N N N W H H H H H Ln Ln 00 Q0 31 00 l0 l0 61 M l0 O N O oo 31 31 O o0 l0 H O l0 O 0) Ln 00 00 00 QQ 00 00 O O O O O O I I 00 0o I H I r� I H I o N N N O N M I I H H I H I H I H I H O O O O O O N I Q Ln �D Ln W x a w w O Q H W W W cn a) o a aco w co H �D C C H FC N �a4 �a4 Oo w z H x a W 0 0 w C HH 0 W rt rt � U w FA 0 a a a ro a s w H u � H z W u H a Z w u Q w z U H W W a o 00� rz0 o w w W a 0 0 O O Z a Z F F W w O H Q Q U Q Q a W W O CQ W H �D �D N N H H * * * * Q Q C" 61 cn J' OD H H H H H U U N oo N oo N oo N oo N oo W W U U w w w w w co co C7 C7 C7 C7 C7 F, N H H N N N N N z z O N O N O N O N O N H H H H H H H N N N N N H H H H H HUTCHINSON UTILITIES COMMISSION COMBINED DIVISIONS FINANCIAL REPORT FOR NOVEMBER, 2024 Combined Division Customer Revenue Sales for Resale NG 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) 91.7% of Year Comp. 2024 2023 Di %Chna 2024 2023 Di %Chna Full Yr Bud %of Bud $ 2,895,643 $ 2,824,342 $ 71,300 $ 277,262 $ 291,786 $ (14,524) $ 177,458 $ 88,158 $ 89,299 $ 60,383 $ 59,960 $ 424 $ 40,898 $ 46,897 $ (5,999) $ 72,373 $ 93,821 $ (21,447) $ 3,524,016 $ 3,404,964 $ 119,052 2.5% $ 31,756,554 $ 31,841,347 $ (84,793) (0.3%) $ 37,151,166 85.5% (5.0%) $ 3,260,810 $ 4,779,659 $ (1,518,849) (31.8%) $ 3,681,000 88.6% 101.3% $ 1,830,988 $ 971,571 $ 859,418 88.5% $ 2,108,203 86.9% 0.7% $ 664,217 $ 659,557 $ 4,659 0.7% $ 724,600 91.7% (12.8%) $ 1,370,549 $ 504,404 $ 866,145 171.7% $ 481,893 284.4% (22.9%) $ 901,257 $ 902,280 $ (1,023) (0.1%) $ 783,457 115.0% 3.5% $ 39,784,376 $ 39,658,818 $ 125,557 0.3% $ 44,930,319 88.5% $ 614,937 $ 697,283 $ (82,346) (11.81%) $ 7,099,886 $ 6,488,241 $ 611,644 9.4% $ 7,969,960 89.1% $ 1,534,647 $ 1,485,509 $ 49,137 3.3% $ 17,072,711 $ 17,766,767 $ (694,056) (3.9%) $ 20,379,028 83.8% $ 189,757 $ 196,042 $ (6,285) (3.2%) $ 2,276,971 $ 2,800,639 $ (523,668) (18.7%) $ 2,755,000 82.6% $ 28,658 $ 40,542 $ (11,884) (29.3%) $ 1,108,843 $ 1,317,596 $ (208,754) (15.8%) $ 1,364,260 81.3% $ 301,045 $ 363,582 $ (62,536) (17.2%) $ 3,929,152 $ 4,059,383 $ (130,231) (3.2%) $ 4,430,000 88.7% $ 222,269 $ 218,671 $ 3,598 1.6% $ 2,444,959 $ 2,405,382 $ 39,577 1.6% $ 2,667,226 91.7% $ 188,722 $ 193,037 $ (4,314) (2.2%) $ 3,162,267 $ 2,498,903 $ 663,365 26.5% $ 3,268,836 96.7% $ 58,438 $ 65,534 $ (7,096) (10.8%) $ 643,918 $ 720,872 $ (76,954) 10.7% $ 702,457 91.7% $ 3,138,473 $ 3,260,199 $ (121,726) (3.7%) $ 37,738,706 $ 38,057,782 $ (319,076) (0.8%) $ 43,536,767 86.7% $ 385,543 $ 144,765 $ 240,778 166.3%1 2,045,669 $ 1,601,036 $ 444,633 27.8% $ 1,393,552 146.8% November November YTD YTD 2024 2023 Change 2024 2023 Change Gross Margin %: 37.3% 36.1% 1.3% 34.0% 32.5% 1.5% Operating Income Per Revenue $ (%): 10.2% 2.6% 7.6% 1.6% 2.9% -1.2% Net Income Per Revenue $ (%): 10.9% 4.3% 6.7% 5.1% 4.0% 1.1% 2024 HUC Budget Target 33.6% 2.3% 11%-4% 3.1%N uuuuNN HUTCHINSON UTILITIES COMMISSION ELECTRIC DIVISION FINANCIAL REPORT FOR NOVEMBER, 2024 11miN�rtm'�N�ri , 91.7% of Year Comp. 2024 2023 Di . %Chna 2024 2023 Di %Chna Full YrBud %of Bud Electric Division Customer Revenue $ 1,754,086 $ 1,736,326 $ 17,760 1.0% $ 21,927,978 $ 21,173,604 $ 754,374 3.6% $ 24,902,363 88.1% Sales for Resale $ 277,262 $ 291,786 $ (14,524) (5.0%) $ 3,260,810 $ 4,779,659 $ (1,518,849) (31.8%) $ 3,681,000 88.6% Other Revenues $ 17,116 $ 13,434 $ 3,682 27.4% $ 307,617 $ 204,629 $ 102,988 50.3% $ 188,770 163.0% Interest Income $ 37,581 $ 48,304 $ (10,724) (22.2%) $ 465,963 $ 466,690 $ (727) (0.2%) $ 408,457 114.1% TOTAL REVENUES $ 2,086,045 $ 2,089,850 $ (3,806) (0.2%) $ 25,962,368 $ 26,624,582 $ (662,214) (2.5%) $ 29,180,590 89.0% Salaries & Benefits $ 473,011 $ 520,600 $ (47,589) (9.1%) $ 5,323,604 $ 4,882,804 $ 440,800 9.0% $ 5,777,096 92.2% Purchased Power $ 792,430 $ 780,494 $ 11,936 1.5% $ 10,767,375 $ 11,020,701 $ (253,326) (2.3%) $ 12,638,152 85.2% Transmission $ 189,757 $ 196,042 $ (6,285) (3.2%) $ 2,276,971 $ 2,800,639 $ (523,668) (18.7%) $ 2,755,000 82.6% Generator Fuel/Chem. $ 28,658 $ 40,542 $ (11,884) (29.3%) $ 1,108,843 $ 1,317,596 $ (208,754) (15.8%) $ 1,364,260 81.3% Depreciation $ 209,277 $ 271,223 $ (61,947) (22.8%) $ 2,913,097 $ 3,054,861 $ (141,764) (4.6%) $ 3,330,000 87.5% Transfers (Elect./City) $ 172,534 $ 169,911 $ 2,623 1.5% $ 1,897,869 $ 1,869,020 $ 28,849 1.5% $ 2,070,402 91.7% Operating Expense $ 127,659 $ 104,570 $ 23,089 22.1% $ 2,223,254 $ 1,690,177 $ 533,076 31.5% $ 2,111,928 105.3% Debt Interest $ 35,305 $ 37,738 $ (2,433) (6.4%) $ 388,352 $ 415,118 $ (26,767) JLILI $ 423,657 91.7% TOTAL EXPENSES $ 2,028,631 $ 2,121,120 $ (92,490) (4.4%) $ 26,899,365 $ 27,050,916 $ (151,551) (0.6%) $ 30,470,495 88.3% NET PROFIT/(LOSS) $ 57,414 $ (31,270) $ 88,684 (283.6%) $ (936,997) $ (426,334) $ (510,663) 119.8% $ (1,289,905) 72.6% 01 (1JJ J�/j,�((�,J(JJJ1J�!�/ � i �I�I�� 110101lrt ll 11 llllllllllllllll�f iifffffllllllllllll R RI(� f 1f(IIIIIIIIIIIIIIIII�II , 91.7% of Year Comp. 2024 2023 Di . %Chna 2024 2023 Di %Chna Full YrBud %of Bud Electric Division Residential 3,837,549 3,799,282 38,267 1.01% 47,621,832 49,508,495 (1,886,663) (3.81%) 54,084,350 88.1% All Electric 212,744 216,055 (3,311) (1.53%) 1,925,463 2,202,855 (277,392) (12.59%) 2,585,300 74.5% Small General 1,362,710 1,328,341 34,369 2.59% 15,793,106 16,972,166 (1,179,060) (6.95%) 18,348,996 86.1% Large General 6,057,170 5,936,850 120,320 2.03% 71,983,853 73,824,970 (1,841,117) (2.49%) 83,540,973 86.2% Industrial 7,421,000 7,938,000 (517,000) (6.51%) 100,502,000 98,978,000 1,524,000 1.54% 113,841,379 88.3% Total KWH Sold 18,891,173 19,218,528 (327,355) (1.70%) 237,826,254 241,486,486 (3,660,232) (1.52%)l 272,400,998 87.3% November November YTD YTD 2024 HUC 2024 2023 Change 2024 2023 Change Budget Target Gross Margin %: 32.7% 32.2% 0.5% 28.0% 27.2% 0.8% 27.1% Operating Income Per Revenue $ (%): 2.6% -2.1% 4.7% -4.6% -2.1% -2.5% -4.6% IIIIIIIIIIIIIIIII Net Income Per Revenue $ (%): 2.8% -1.5% 4.2% -3.6% -1.6% -2.0% -4.4% IIIIIIIIIIIIIIIII Customer Revenue per KWH: $0.0929 $0.0903 $0.0025 $0.0922 $0.0877 $0.0045 $0.0914 Total Power Supply Exp. per KWH: $0.0729 $0.0720 $0.0009 $0.0767 $0.0786 -$0.0019 $0.0769 �IIIIIIIIIIII' Net Income increased by $88,684 over November 2023. Salaries and Benefits were down due to the error discussed last month when they were higher. This is only for comparison purposes as the 2024 numbers are correct. The year to date numbers for both years are also correct. Sales for Resale of $277,262 consisted of $33,012 in market sales, $98,000 in capacity sales to Rice Lake, and $146,250 in capacity sales to AEP. November 2023 Sales for Resale of $291,786 included $47,536 in market sales, $98,000 in capacity sales to Rice Lake, $146,250 in capacity sales to AEP. November 2022 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 and energy sales to Dynasty Power. Overall Purchased Power increased by $11,936. MRES purchases increased by $24,528 and market purchases/MISO costs decreased by $12,592. The average cost of MISO power was $22.37/mwh (1,802 mwh's purchased), compared to $25.41/mwh (1,762 mwh's purchased) in November 2023. There was no Power Cost Adjustment for the month leaving the total at $556,670 YTD. There was no Power Cost Adjustment for November 2023 and $305,137 YTD. Gas Division Customer Revenue Transportation Electric Div. Transfer Other Revenues Interest Income TOTAL REVENUES Salaries & Benefits Purchased Gas Operating Expense Depreciation Transfers (City) Debt Interest TOTAL EXPENSES NET PROFIT/(LOSS) HUTCHINSON UTILITIES COMMISSION GAS DIVISION FINANCIAL REPORT FOR NOVEMBER, 2024 91.7% of Year Comp. 2024 2023 2 %Chna 2024 2023 2 . %Chna Full YrBud %of Bud $ 1,141,556 $ 1,088,016 $ 53,540 4.9% $ 9,828,576 $ 10,667,743 $ (839,167) (7.9%) $ 12,248,803 80.2% $ 177,458 $ 88,158 $ 89,299 101.3% $ 1,830,988 $ 971,571 $ 859,418 88.5% $ 2,108,203 86.9% $ 60,383 $ 59,960 $ 424 0.7% $ 664,217 $ 659,557 $ 4,659 0.7% $ 724,600 91.7% $ 23,782 $ 33,464 $ (9,682) (28.9%) $ 1,062,932 $ 299,775 $ 763,157 254.6% $ 293,123 362.6% $ 34,792 $ 45,516 $ (10,724) (23.6%) $ 435,294 $ 435,590 $ (296) (0.1%) $ 375,000 116.1% $ 1,437,972 $ 1,315,114 $ 122,858 9.3% $ 13,822,008 $ 13,034,236 $ 787,771 6.0% $ 15,749,729 87.8% $ 141,926 $ 176,683 $ (34,757) (19.7%) $ 1,776,281 $ 1,605,437 $ 170,844 10.6% $ 2,192,864 81.0% $ 742,216 $ 705,015 $ 37,201 5.3% $ 6,305,336 $ 6,746,066 $ (440,730) (6.5%) $ 7,740,876 81.5% $ 61,063 $ 88,467 $ (27,403) (31.0%) $ 939,014 $ 808,725 $ 130,288 16.1% $ 1,156,908 81.2% $ 91,768 $ 92,358 $ (590) (0.6%) $ 1,016,055 $ 1,004,522 $ 11,533 1.1% $ 1,100,000 92.4% $ 49,735 $ 48,760 $ 975 2.0% $ 547,090 $ 536,362 $ 10,728 2.0% $ 596,824 91.7% $ 23,133 $ 27,796 $ (4,662) 0.0% $ 255,567 $ 305,754 $ (50,187) 16.4% $ 278,800 91.7% $ 1,109,842 $ 1,139,079 $ (29,236) (2.6%) $ 10,839,341 $ 11,006,866 $ (167,525) (1.5%) $ 13,066,272 83.0% $ 328,129 $ 176,035 $ 152,094 86.4%1 2,982,666 $ 2,027,370 $ 955,296 47.1% $ 2,683,457 111.2% "'Ij-' �ir i iriiiiiii�� Ii �i I �� 2024 2023 2 . %Chnq Gas Division Residential 43,366,109 43,176,205 189,904 0.44% Commercial 31,466,155 33,330,434 (1,864,279) (5.59%) Industrial 75,469,425 72,020,269 3,449,156 4.79% I�f�ff(�ffh��ii�� 2024 2023 p %Chnq 297,844,748 345,019,697 (47,174,949) (13.67%) 233,605,013 272,399,787 (38,794,774) (14.24%) 683,140,443 714,559,282 (31,418,839) (4.40%) 91.7% of Year Comp. Full YrBud %of Bud 450,091,000 66.2% 350,477,000 66.7% 908,618,000 75.2% Total CF Sold 150,301,689 148,526,908 1,774,781 1.19% 1,214,590,204 1,331,978,766 (117,388,562) (8.81%) 1,709,186,000 71.1% November November YTD YTD 2024 HUC 2024 2023 Change 2024 2023 Change Budget Target Gross Margin %: 44.2% 42.5% 1.7% 46.4% 43.8% 2.6% 46.0% Operating Income Per Revenue $ (%): 21.5% 10.4% 11.1% 14.5% 13.3% 1.1% 15.5% Net Income Per Revenue $ (%): 22.8% 13.4% 9.4% 21.6% 15.6% 6.0% 17.0% Contracted Customer Rev. per CF: $0.0072 $0.0058 $0.0014 $0.0067 $0.0063 $0.0004 $0.0060 Customer Revenue per CF: $0.0079 $0.0087 -$0.0008 $0.0097 $0.0098 -$0.0001 $0.0083 Total N.G. Supply Exp. per CF: $0.0051 $0.0048 $0.0003 $0.0055 $0.0052 $0.0003 $0.0048 $0.0048 Notes/Graphs: November Net Income increased by $152,094 led by an increase in usage and the same salaries and benefits issue discussed on the electric income statement. November 2024 Fuel Credit Adjustment was $1.21633/MCF crediting customers $98,722 for the month and $278,046 YTD. November 2023 FCA was $.54307/MCF bringing in an additional $41,909 for the month and YTD. Current Assets UnrestrictedlUndesignated Cash Cash Petty Cash Designated Cash Capital Expenditures - Five Yr. CIP Payment in Lieu of Taxes Rate Stabilization - Electric Rate Stabilization - Gas Catastrophic Funds Restricted Cash Bond & Interest Payment 2017 Bond & Interest Payment 2012 Debt Service Reserve Funds Total Current Assets Receivables Accounts (net of uncollectible allowances) Interest Total Receivables Other Assets Inventory Prepaid Expenses Sales Tax Receivable Deferred Outflows - Electric Deferred Outflows - Gas Total Other Assets Total Current Assets Capital Assets Land & Land Rights Depreciable Capital Assets Accumulated Depreciation Construction - Work in Progress Total Net Capital Assets HUTCHINSON UTILITIES COMMISSION BALANCE SHEET - CONSOLIDATED NOVEMBER 30, 2024 Electric Gas Total Total Net Change Division Division 2024 2023 Total (YTD) 703,387.04 12,717,040.07 13,420,427.11 13,456,963.88 (36,536.77) 680.00 170.00 850.00 850.00 - 2,750,000.00 700,000.00 3,450,000.00 3,450,000.00 - 1,345,802.00 596,824.00 1,942,626.00 1,904,536.00 38,090.00 540,964.58 - 540,964.58 653,471.96 (112,507.38) - 615,294.19 615,294.19 626,564.78 (11,270.59) 800,000.00 200,000.00 1,000,000.00 1,000,000.00 - - - - 1,656,428.08 (1,656,428.08) - - - 1,991,775.04 (1,991,775.04) 1,183,656.00 2,072,000.00 3,255,656.00 2,711,029.66 544,626.34 7,324,489.62 16,901,328.26 24,225,817.88 27,451,619.40 (3,225,801.52) 1,728,999.02 1,157,100.15 2,886,099.17 3,039,605.75 (153,506.58) 70,706.31 70,706.32 141,412.63 118,283.99 23,128.64 1,799,705.33 1,227,806.47 3,027,511.80 3,157,889.74 (130,377.94) 1,997,641.02 552,863.10 2,550,504.12 2,371,905.03 178,599.09 350,746.93 43,011.77 393,758.70 (71,641.06) 465,399.76 392,805.82 - 392,805.82 306,145.18 86,660.64 741,556.00 - 741,556.00 1,221,397.00 (479,841.00) - 247,185.00 247,185.00 407,133.00 (159,948.00) 3,482,749.77 843,059.87 4,325,809.64 4,234,939.15 90,870.49 12,606,944.72 18,972,194.60 690,368.40 3,899,918.60 113,790,112.72 43,426,992.03 (73,214,356.90) (22,362,532.25) 6,396,138.52 1,358,970.84 47,662,262.74 26,323,349.22 31,579,139.32 34,844,448.29 (3,265,308.97) 4,590,287.00 4,590,287.00 - 157,217,104.75 156,896,197.22 320,907.53 (95,576,889.15) (91,255,299.98) (4,321,589.17) 7,755,109.36 2,038,059.27 5,717,050.09 73,985,611.96 72,269,243.51 1,716,368.45 Total Assets 60,269,207.46 45,295,543.82 105,564,751.28 107,113,691.80 (1,548,940.52) Current Liabilities Current Portion of Long-term Debt Bonds Payable Bond Premium Lease Liability - Solar Array Accounts Payable Accrued Expenses Accrued Interest Accrued Payroll Total Current Liabilities Long -Term Liabilities Noncurrent Portion of Long-term Debt 2017 Bonds 2012 Bonds Bond Premium 2012 Pension Liability- Electric Pension Liability - Electric OPEB Pension Liability - Nat Gas Pension Liability - Nat Gas OPEB Accrued Vacation Payable Accrued Severance Deferred Outflows - Electric Deferred Outflows - Nat Gas Total Long -Term Liabilities Net Position Retained Earnings Total Net Position HUTCHINSON UTILITIES COMMISSION BALANCE SHEET - CONSOLIDATED NOVEMBER 30, 2024 Electric Gas Total Division Division 2024 790,000.00 19, 546.00 2,275,537.30 123,287.81 3,208,371.11 11,750,000.00 434,940.48 2,776,372.00 64,096.00 527,144.22 121, 598.92 998,815.00 16,672,966.62 1,980,000.00 185,608.32 884,017.86 39,744.07 3,089,370.25 2,080,000.00 185,607.95 925,458.00 21,365.00 191,450.10 32, 321.13 332,938.00 3,769,140.18 2,770,000.00 185,608.32 19, 546.00 3,159, 555.16 163,031.88 6,297,741.36 11,750,000.00 2,080,000.00 620,548.43 2,776,372.00 64,096.00 925,458.00 21,365.00 718, 594.32 153,920.05 998,815.00 332,938.00 20,442,106.80 Total Net Change 2023 Total (YTD) 2, 655, 000.00 115, 000.00 185,608.32 - - 19,546.00 3,513,284.29 (353,729.13) (0.03) 0.03 138,948.94 24,082.94 6,492,841.52 (195,100.16) 12,540,000.00 (790,000.00) 4,060,000.00 (1,980,000.00) 839,613.71 (219,065.28) 4,021,396.00 (1,245,024.00) 77,480.00 (13,384.00) 1,340,466.00 (415,008.00) 25,827.00 (4,462.00) 700,600.34 17,993.98 140,285.54 13,634.51 98,554.00 900,261.00 32,851.00 300,087.00 23,877,073.59 (3,434,966.79) 40,387,869.73 38,437,033.39 78,824,903.12 76,743,776.69 2,081,126.43 40,387,869.73 38,437,033.39 78,824,903.12 76,743,776.69 2,081,126.43 Total Liabilities and Net Position 60,269,207.46 45,295,543.82 105,564,751.28 107,113,691.80 (1,548,940.52) Hutchinson Utilities Commission Cash -Designations Report, Combined 11/30/2024 Financial Institution Current Interest Rate Annual Interest Balance, November 2024 Balance, October 2024 Change in Cash/Reserve Position Savings, Checking, Investments varies varies varies 24,225,817.88 26,582,894.88 (2,357,077.00) Total Operating Funds 24,225,817.88 26,582,894.88 (2,357,077.00) Debt Reserve Requirements Bond Covenants - sinking fund Debt Reserve Requirements Bond Covenants -1 year Max. P & I Total Restricted Funds Operating Reserve Rate Stabalization Funds PILOT Funds Catastrophic Funds Capital Reserves Total Designated Funds Min 60 days of 2024 Operating Bud. Charter (Formula Only) Risk Mitigation Amount 5 Year CIP (2024-2028 Fleet & Infrastructure Maintenance) 3,077,668.22 (3,077,668.22) 3,255,656.00 3,255,656.00 3,255,656.00 6,333,324.22 (3,077,668.22) 6,631,467.17 6,631,467.17 - 1,156,258.77 1,123,925.94 32,332.83 1,942,626.00 1,942,626.00 - 1, 000, 000.00 1, 000, 000.00 3,450,000.00 3,450,000.00 - 14,180,351.94 14,148, 019.11 32,332.83 YE YE YE YE YTD HUC 2020 2021 2022 2023 2024 Target Debt to Asset 32.3% 30.8% 31.4% 28.6% 25.3% Current Ratio 5.67 5.22 4.47 4.48 4.35 RONA 3.62% 0.41% -1.38% 1.96% 2.15% Change in Cash Balance (From 12131114 to 1113012024) Month End Electric Elec. Change Natural Gas Gas Change Total Total Change 11/30/2024 7,324,490 16,901,328 24,225,818 12/31/2023 12,158,338 (4,833,848) 15,622,242 1,279,086 27,780,580 (3,554,762) 12/31/2022 11,633,212 525,126 15,450,554 171,688 27,083,766 696,815 12/31/2021 12,870,253 (1,237,041) 15,086,000 364,554 27,956,253 (872,487) 12/31/2020 14,239,233 (1,368,981) 15,019,173 66,827 29,258,406 (1,302,153) 12/31/2019 12,124,142 2,115,092 13,837,040 1,182,133 25,961,181 3,297,225 12/31/2018 15,559,867 (3,435,725) 12,335,998 1,501,042 27,895,864 (1,934,683) 12/31/2017 23,213,245 (7,653,378) 10,702,689 1,633,309 33,915,934 (6,020,070) 12/31/2016 8,612,801 14,600,444 9,500,074 1,202,615 18,112,875 15,803,059 12/31/2015 6,170,790 2,442,011 9,037,373 462,701 15,208,163 2,904,712 12/31/2014 3,598,821 2,571,969 6,765,165 2,272,208 10,363,986 4,844,177 * 2017's Significant increase in cash balance is due to issuing bonds for the generator project. Hutchinson Utilities Commission Cash -Designations Report, Electric 11/30/2024 Change in Financial Annual Balance, Balance, Cash/Reserve Institution Current Interest Rate Interest November 2024 October 2024 Position �' Rr Savings, Checking, Investments varies varies Total HUC Operating Funds tiectric ��iyyIIIIII �iJ� ++ Debt Restricted Requirements Bond Covenants - sinking fund Debt Restricted Requirements Bond Covenants -1 year Max. P & I Total Restricted Funds Operating Reserve Rate Stabalization Funds PILOT Funds Catastrophic Funds Capital Reserves Total Designated Funds varies 24,225,817.88 26,582,894.88 (2,357,077.00) 24,225,817.88 26,582,894.88 (2,357,077.00) Min 60 days of 2024 Operating Bud. $400 K-$1.2 K Charter (Formula Only) Risk Mitigation Amount 5 Year CIP (2024-2028 Fleet & Infrastructure Maintenance) 1,085,018.22 (1,085,018.22) 1,183, 656.00 1,183, 656.00 1,183,656.00 2,268,674.22 (1,085,018.22) 4,593,259.83 4,593,259.83 - 540,964.58 514,335.18 26,629.40 1,345,802.00 1,345,802.00 - 800,000.00 800,000.00 2,750,000.00 2,750,000.00 - 10,030,026.41 10,003, 397.01 26,629.40 YE YE YE YE YTD APPA Ratio HUC 2020 2021 2022 2023 2024 5K-10K Cust. Target Debt to Asset Ratio (* w/Gen.) 32.6% 32.2% 34.8% 34.0% 33.0% 39.8% Current Ratio 6.18 5.70 4.96 4.35 3.33 3.75 RONA 2.5% -1.2% -4.2% -0.9% -1.7% NA >0% Notes/Graphs: Hutchinson Utilities Commission Cash -Designations Report, Gas 11/30/2024 Change in Financial Annual Balance, Balance, Cash/Reserve Institution Current Interest Rate Interest November 2024 October 2024 Position 51' Rr Savings, Checking, Investments varies varies Total HUC Operating Funds ��yyIIIIII ��JJ� ++ Debt Restricted Requirements Bond Covenants - sinking fund Debt Restricted Requirements Bond Covenants -1 year Max. P & I Total Restricted Funds Operating Reserve Rate Stabalization Funds PILOT Funds Catastrophic Funds Capital Reserves Total Designated Funds varies 24,225,817.88 26,582,894.88 (2,357,077.00) 24,225,817.88 26,582,894.88 (2,357,077.00) Min 60 days of 2024 Operating Bud. $200K-$600K Charter (Formula Only) Risk Mitigation Amount 5 Year CIP (2024-2028 Fleet & Infrastructure Maintenance) 1,992,650.00 (1,992,650.00) 2,072,000.00 2,072,000.00 2,072,000.00 4,064,650.00 (1,992,650.00) 2,038,207.33 2,038,207.33 - 615,294.19 609,590.76 5,703.43 596,824.00 596,824.00 - 200,000.00 200,000.00 700,000.00 700,000.00 - 4,150,325.52 4,144,622.09 5,703.43 YE YE YE YE YTD HUC 2020 2021 2022 2023 2024 AGA Ratio Target Debt to Asset 32.0% 28.8% 26.5% 21.0% 15.1% 35%-50% Current Ratio 5.18 4.79 4.06 4.61 5.39 1.0-3.0 RONA 5.3% 2.9% 3.0% 6.2% 7.5% 2%-5% VW UUU Notes/Graphs: ELECTRIC DIVISION Operating Revenue November 2024 CLASS AMOUNT KWH /KWH Street Lights $26.60 488 $0.0545 Electric Residential Service $440,751.94 3,837,549 $0.1149 All Electric Residential Service $22,719.34 212,744 $0.1068 Electric Small General Service $147,401.12 1,362,710 $0.1082 Electric Large General Service $547,160.76 6,057,170 $0.0903 Electric Large Industrial Service $596,026.65 7,421,000 $0.0803 Total $1,754,086.41 18,891,661 $0.0928 Power Adjustment $0.00000 Rate Without Power Adjustment $0.09285 Electric Division Year -to -Date ® 2024 $ Amount ❑ 2023 $ Amount ® 2024 KWH110 ❑ 2023 KWH110 20,000,000 18,000,000 16,000,000 14,000,000 12,000,000 10,000,000 8,000,000 6,000,000 4,000,000 2,000,000 0 Street Lights Residential All Elec. Resid. Small Gen. Srv. Large Gen. Srv. Large Industrial For Resale Total NOTE: Sales for resale includes capacity sales and energy for resale NATURAL GAS DIVISION Operating Revenue November 2024 CLASS AMOUNT MCF /MCF Residential $353,849.06 43,366 $8.1596 Commercial $246,114.11 31,466 $7.8216 Large Industrial $42,465.58 6,180 $6.8710 Large Industrial Contracts $499,127.56 69,289 $7.2036 Total $1,141,556.31 150,302 $7.5951 Fuel Adjustment-$1.21633 Rate Without Fuel Adjustment $8.81143 Natural Gas Division Year -to -Date ❑ 2024 $ Amount ❑ 2023 $ Amount m 2024 MCF ❑ 2023 MCF 9,000,000 8,000,000 7,000,000 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 0 Gas Residential Gas Commercial Large Industrial Large Industrial Total Contracts � U N N N N N N O N N O N N 0 0 0 Q Q 0 0 0 0 0 0 E Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q s Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q z R Z Z Z Z O O O O O O '-Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z M Z Z Z Z Z> Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z > O O m V 0 ccioo V OIL M M MG OM W �co 0MWNLOM W 000r-00o0 00 0000000 't0t I� � W � O� 0 M NCO -0 CoN �M O�-I-�O NN - WINO COO 7 = W I� C00 W O N 60i CO W W �6Ni OM CNONMWMC00 MO 0VCM060iM06WiN6M W W6Wi I� 0 0 W M V 0 r � M" `-'� W N Mrl-m N I� r� M V,- I� V, CONMMN I�Or E V O W W N N V V V 0 W M 0 r O 0 W V r N W r V M C O M� M I� 0 r O V I� M `-' V .- N .- N d 0 N aaaaaaa� as �� s � �� , �� 00 CO 000000) O)CO ON 0000 �� 00-0O� 00 0 M M� Ool W' �1) OMWN�M W � 00 O O 0 O V OCO00000 VMO 00 co �V 00 �� co COOS O V NCO �� 00 �O co M OCO O M NCO �0 N V �M MM�V V O NCO �NOO CO�NOV V0�0�6l1-0 N 0m W W� W r0 W NMMO�N CO NMM V I-I--t - M � W 0� ��mm W � WCON W ONMr V WW c) �, COW000�-COW WOO N M0 W O�N� co M��cor0 V CO CO CO CONS 0 MIS 01 co N0 W W I�� rO NI��CO�MONCO�OCOO��CO ITV OI�CO W V N W O) V CO I N� W co V CO .- I� r O M 0 0 W V I 0 O V 0 r .- W W V V - 0 0 r V 0 W W N W N W CO .- N I� r 0 r W .- W R J .- Oi of N 0 0 V 1- O) V N V N6 O CO of l: c6 a; a; N W W IC CO CS a OON 00000 V W 0 V 00000000000000 O co MM 00 M� Co m M�r Lo MO co W 0ON r0 C000 C�00 �00rl-Lo . . . . 0 . c) c) 00000 co W 000000000000000 V W 0 W W MI) OIL mmcOO OO V M O��I� O�Om mcO co MCOW N C 00 00000� N� M� 00000000000000 0 N M( W 0000 MMMW(NCO MO) I� V VM 0 W�O)NmM - - co W6� R 00 OOOOON 00 W 00000000000000 CO OWN NCO 0 �� I�MIlIlNIl I� V M�I-OI��CONMMN1�01� t p 006� �000000 ��- W V �� W � �� N O NIA W CO N06�.-6� W6�N�6� C06� NI�MN V �-0�-0M�M1�0�1�000 �- IL rn000000000000�0000��00��o�oom rn000000000000000c) c) 0000000000000 0000 V Lo0000 LoOON OLoOCO NCO t t ' W O NM OV CO -00000 CON 00 NNOM00 V CO VI,-OOLntOOMOLo I,-OOI,-V "I- c) OON co ISM V NO0 NCO co co m� CO V NIA VW 0c)c)c) O�0M NCO �co OM V O�M06�co O mco00��M NIA OIL ON OM M Obi NM coCMO M0M �� NN OMi CrO �00i M V �0 M V 0000� NO) V CO- WCOW�N N V I��I� � MV �� Cfl W I� N MAW OMi W I� N 0 0 W M O I� 0 W r 0 W W M M M M N M N CO 0 M CO 0 0 0 0 V 0 W 0 W I W M CO CO T r N M CO CO N W N W V O CO 0 W V I 0 M ' M 0 r 0 W 0 W M M 0 W O V V V V V V V M M V N V V N V 0� V N V M N N� O V M M N N N N N N N N N N N N N N W�- 0 2 N O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O N O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O g ro 0000000000000000000000000000 0000000000000000000000000000000000 @ R- OOO �O 000 000 of � �� of c) c) V OOOOO g Og 00g gO c) c) O OOOOOOO O C y.� d R O co N 0r 00 �r OCO �0 V V V V V V V V V V M V V V O� O (0 CO O OR c) m OOM W CO ISO c) 0Rm c) OOWN M NN NN NN NN NN NN NN N �- NN �- ��-NNMM � �-�-N �-� N�- � N�-� �- ci Q 0 � N W o Z N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N ��a o._ o000000000000000000000000000 0000000000000000000000000000000000 H W= Q N N N N N N N N N N N N N N N N N N N N N N N N N N N n Q N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N Z O O u% � � 6� 0 0 C0 W � O V I� V CO CO C0 6� W Iz L � � M � � � � � � � � � � � � � � � � � � � � � � L Z 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O 0 0 0 0 0 0 0 0 0 7 0 0 y= g N MO O N0 0 00 NO 00 WO MO O N0 0 0 0 0 0 0 0 - 0 0 N N N N O O O O O O O O 00 0 0O WO 00 00 NO NO 00 00 00 Z y �+ y N M V V V V V V NN MM NN N�- V M V� M ON W M MM 6�M 6�6�6�N06� OM 06�006�N6�0 VO�O�O�V NON NON_NON NON NON NON NON ONN NON NON NON NON_N O6�ooOOOOO OOOOOOOOOOOO,OOO,OO,OROO ... O,,, O Z0 W W6�N�N�ON��O`ZO 000NNN 0 a N 0 0 8 0 0 0 0 8 0 0 V O O O O O O O 0 00 00 0 00 0 0 0 8 0 8 8 0 0 0 8 00 0O WO 0 0 0 0 0 0 0 0 0 00 C o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ` 000� I�� N0 0 V r000000000000001� 06� W I� 6�M MCO W I�OV�CO W �I� V W MI)MO WCO��W V 000 I�� 00 WN MCO W I, W M M 00 �� 000000 �O �O W O N00� NIA O VMI�W I�� N��-000�6��6�6��M NI�� CNN ON LoL V O N�- W N NCO CO CO �� M00Lo 0Lo ON V W 0 V V CO rl- N0001�m �-N �O HMV V mcoN COOO U V V V V 0 0 "m V V V V V M M M V V V -- O V V M V V "m V M M M N m N ',I- "I N M N V N o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 y RI�� 00 �� 0� O� 000000 �� 0000000O m0 �0 Io 0� ON VIo NOu% N006o 00 �� CO W Io co O O� M COW CNN 001�1� OIL 0 000� CoNCO CO �� MOOS O� 6�0 V O Lo �M m6�M O V V coI�MI�CON V O CO C06�0 N��CO�MMOOMW6� C ,I- ',I- V OOO N 0 0 00 V V V MM M V- ',I-V O V N�-MM N V V O MMN V NM CO O MNN�-VNNM MMM U U U O 'o 'o 'o 'o 'o 'o 'o F c c c c c c c c c c c c c c c c c c c c c c c c c c c c c c c c c c O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O 0] 0] 0] 0] 0] 0] 0] 0] 0] 0] 0] 0] 0] 0] 0] 0] 0] 0] 0] 0] 0] 0] 0] 0] 0] 0] 0] 0] 0] 0] 0] 0] 0] 0] N N N O � N N t6 t6 t6 t6 t6 t6 t6 t6 t6 t6 t6 t6 t6 t6 t6 t6 t6 t6 t6 t6 t6 t6 t6 t6 t6 t6 t6 t6 t6 t6 t6 t6 w rn m c c c c c c c c c c c c c c c c c c c c c c c c c c c c c c c c c c c L IL LLLD LL LL LL LL LL LL LLLD DL=L UU UU UU UU UU UU UU 2E2E 2E2E 2E2E 2E2E 2E2E 2E2E2E2E2E2E 2E2E 2E2E2E2E 2E2E2E2E2E2E2E2E2E2E2E2E2: O O O O O O O O O O O O O O O O O O O O O O O O O O O N N N N N N N N N N N N N N N N N N N N N N N N N N N LL LL LL LL LL LL LL LL LL LL LL LL LL LL LL LL LL LL LL LL LL LL LL LL LL LL LL >N >N >N >N >N >N >N >N >N >N >N >N >N >N >N >N >N >N >N >N >N >N >N >N >N >N >N > > > > > > > > > > > > > > > > > > > > > > > > > > > O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L c c c c c c c c c c c c c c c c c c c c c c c c c c c c c c c c c c c N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N E O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > N L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U LO LO LO .0 00 LO LO (D d N O N N N N N N N N N N N jp O L 00 O 00 O 00000 U n N m o 6) W W M M N N V N O O O O O O O O O O O O V CO COo m O)Oo CO 00 CO V IS O CO OM V M ..OM IT oO V CO 000� O coNOO coCOO V V M(O� E COr-o. OO�on LO E;::.o CO N O)OO M CO > co V MCO mmo n0 D,;T� V I�CO IT 0)m 0)CO ISM O V W V M_OO)CONLO V COO�O)MNO)MCO�N E UL0 L0MN V V�LON�� Ln VI�I�O� V N V V V V ` A V ao NCO CO�MO��OCO�00 V V NO W OM V CO�� CO NCO OIL V MNOO)O)O V O)00)N�CO V O)LO COS y LI�CO co VNV MNI� V OoEmI oI��O V ONNI� ry o0 CO 0 L000 NN V L0 V o0V W r00 M Ln W 0 V .J.. CO001 00)I V LDCO - 0O(O CO �Or W �COCO W W CO O)NI��NCOOCOOCO I�CO CO� VCO V�M�� V� 7 t� V co �0000 �0)O CO CO 00 V V IS O CO OM V -m OM IT�Ln LOM000� OCO-oM COO V V MCO� y CO 000) CO 0M00- LO 0M.0 000 N O20OMCO N ICON V M CO (D CO O LO N O OCO V I�CO V 0)')0)C0 ISM R V W V M, 0)0 W NLO- V 00-Cl) )M CO INN o V M NNE L0 E CO co CO N O)LV m CO 0 CNO 1�L0 L0 0. L00000 n o o o 00 L0 0000 L000000 L000 CO I�CO 0) CD COON O V CO OO(Do NCD 000 N 0)0 n CO L0 0 CO 000 00)0 0) LO CO COMNNCO W �r V CO V CO 00)CO O)NCO 00)CO CO >- GICONCo I� -CO NCOMCO LD1 L00) V V 0)-00)O)M �M�O V V 0,00 0) co CO O)O O)O)O V COO) � >L0 V ��CO MO)L01�0� V NCO NCNOOCO Ln NIn� V V 000000000000000000000000 000000000000000000000000 000000000000000000000000 w000000000000000000000000 R L0- r00 Ln OLn Ln OLn OOO O Ln Ln Ln O0000 R >L0 'V co m OLO I��N 00)CO NCNO�CO co 0�ln LO o CO co CO co CO co W W 0)0)0)0)M O) V o N N N N N N N N N N N N N N N N N N M M M N M M O •- 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 � O R 0 �.L. Cn I�.OMM V COW W OM V.ON 0 0 0 0 0 . 0 0 0 0 . 0 0 0 . 0 0 0 . 0 0 0 .0 . 0 00)�O)O)��O)O� OM O O N N N 0 N 0 0 N N 0 N N N N 0 N N N N 0 N N p R 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 000000000 N N N N N N N N N N N N N N N N N N N N N N N N R `��MI��LnM �I�MO�� V OLn� W NOM�MM R� WO WNMW �W 0 0- 0 0 0- 0 � � 0 0 0- 0 0 0 0 0 0 K�00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 CO O) V �I�M� V V O V 0)MMMNM V E0)L0 MC0 N �L00co 0) V I�0 V 00)co �0 V (D 0m L00L0 I�N�CO I��L00)NO�CO O)�O)MNOCO O M V o 0 0 o 0 o 0 o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 � yMOLO�OI�L00 V Ln I�OONNOOL00�OOL0 Ln O RLOMN COO��I�I�N V V 00)CO Ln 00)O W OLONN �L0N0)CO OCO V NO)�LOB O(O I�ONOO)oO f M M M N M N N N M M- V V M o V M M M M M F Z _ W prn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn R •aaaaaaaaaaaaaaaaaaaaaaaa0 M Q ............... C C C C C C C C C F W U O O O O O O O O O O O O O O O O O O O O O O O O m m m m m m m m m m m m m m m m m m m m m m m m W � N (6 (6 (6 (6 (6 (6 (6 (6 (6 (6 (6 (6 (6 (6 (6 (6 75 76 76 76 76 76 76 76 C Z W !? !? !? !? !? !? !? !? !? !? !? !? !? !? !? !? !? !? !? !? !? !? !? !? J 0 0 0 0 0 0 0 0 0 0 0 0 0.0 0.0 0.0 0.0 0.0 Oco o m Q ..................... EEE F ........................ 0 N N N N N N N N N N N N N N N N N N N N N N N N g o 0 o g o 0 o g o 0 0 0 0 0 0 o g o 0 o g g g Cn O J) N N N N N N N N N N N N N N N N N N N N N N y Cn Cn Cn Cn Cn Cn Cn Cn Cn Cn Cn Cn Cn Cn Cn Cn Cn Cn Cn Cn Cn Cn Cn Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y ........................ N N N N N N N N N N N N N N N N N N N N N N N N c E E E E E E E E E E E E E E E E E E E E E E E E (n fn fn fn fn fn fn fn fn fn fn fn fn fn fn fn fn fn fn fn fn fn fn fn > > > > > > > > > > > > > > > > > > > > > > > > m m m m m m m m m m m m m m m m m m m m m m m m 0 C) C) C) C) C) C) C) C) C) C) C) C) C) C) C) C) C) C) 0 O v N � 0 0 0 0 0 0 0 O n CL ei 00 W N '^ o O N M O) ItN M N N OI, O' NOW M O O O O O o0 M N M M I- M 00 `~ M o0 O Lo o0 O) V f- ' W- > Ln M N (00 O O r o V > N Oro V(D N N � ei M i N N M V Ln T N + J N M V Lo m n r Mf O o R i L R H o O o o o N o o O O o o o o o o o O o o o o o O o o o o O o o o o O o o o 0 b J o O o w 0 I� 0 0 o Vf a 0 M 0 N ei �. y -Cr O) O) O M O) O O) (O (O Lo M O) -: LO .."" r_ o0 M (M N N O) r- O M Z e H m Lo Lo _ N Oro N O L (O V O) O Y fL p R o o o 0 O Lo Lo M o O � E 0 N ♦+ r- a C e F O N N Lo O W O >o O O ,,.....: y I- M O o0 w w M N (O N 7 N> N- N O) V M N V N r M R M Ln V W O) V N O) Lo M fl m 0 0 0 0 0 V, N M- O O o F N N Lo O 0" 00 O O Lo M M N O) M 00 >" m� y O N o0 W V o V W O r 1,11I��1111��1111�1 J O R M N V O N r o Lo M W r- �U � N a 0 v 7 0 a Y O N N m O C (L e O :� a N o C Electric Production Work Order Description Materials 12203 Plant 2 Air Dryer 12204 Cooling Tower Repairs 138,695.00 12401 Tuck Pointing Phase 2 140,000.00 12402 Plant 1 Combustible Gas Detection System 100,000.00 12403 SWOIS Computer Upgrade U5 490,000.00 12404 Plant 1 Side Stream Filter 40,000.00 12405 Tower Water Pumps Plant 1 60,000.00 12406 Plant 2 Overhead Crane 15,207.00 $ 983,902.00 $ Total Total Labor Budgeted Actual Difference $ - 38,902.37 $ 38,902.37 20,000.00 $ 158,695.00 524,375.92 $ 365,680.92 - $ 140,000.00 138,230.28 $ (1,769.72) $ 100,000.00 $ (100,000.00) $ 490,000.00 $ (490,000.00) $ 40,000.00 50,900.00 $ 10,900.00 $ 60,000.00 58,052.43 $ (1,947.57) $ 15,207.00 $ 20,893.70 $ (5,686.70) .. 20,000.00 $ 1,003,902.00 $ 831,354.70 $ 2,547.3030) (172 Work Order scri io 22301 Hutch Sub Transformer Upgrade Engineering 22401 Hutch Substation Transformer 22402 McLeod Sub Relay Replacement 22403 Pole Repair and Replacement 22404 Station Equipment 22405 3M Sub SCADA Phase 2 22406 HTI Sub SCADA 22407 V F Ball Field Lighting 22408 Install Duct 22409 Les Schwab Tire 22410 Fairgrounds Upgrade 22411 New Developments 22412 Les Schwab Tire Transformer 22413 Fairgrounds Upgrade Transformer 22414 Transformer New Developments 22415 Transformer Replacements 22416 Meters 22417 LED Street Light Conversion 22418 Road Projects 22419 Feeder 14 22420 Feeder 16 Total Total Materials Labor ftete Actual Difference 999,127.64 $ 999,127.64 - - 829,569.71 $ 829,569.71 125,000.00 - 125,.00 - $ (125,000.00) 15,00.00 - 15,00.0 - (15,0.) 10,000.0 - 10,00.0 - $ (10,000.00) 87,000.00 - 87,.00 878.35 (86,121.65) 125,000.0 - 125,000.00 45,46.45 (79,953.55) 305,0. - 305,000.00 - (35,000.00) 1,00.0 65,000.00 83,0.00 11,06.57 (71,193.43) 5,000.00 3,000.00 8,00.0 3,33.20 (4,366.80) 7,000.00 4,000.00 11,000.00 42,643.13 $ 31,643.13 60,000.00 15,000.00 75,000.00 145,879.91 $ 70,87 .91 10,000.00 1,500.00 11,5.00 14,965.83 3,465.83 15,000.00 2,000.00 17,000.00 12,176.41 $ (,823.59) 60,000.00 10,000.00 70,0 0.00 3,761.76 (66,238.24) 75,000.00 15,00.00 90,00.00 8,645.21 (81,354.79) 75,000.00 - 75,000.00 11,018.4 $ (63,981.56) 175,000.00 35,00.00 210,00.00 22,650.00 $ (187,350.00) 40,000.00 - 40,000.00 42,287.52 $ 2,287.52 - - - 21,341.26 21,31.26 - - .... - ..... - 53,934.31 (53,934.31) $ 1,207,000.00150,500.0 $ 1,357,500.00 2,269,365.70 $ 911,865.69 Administrative Total Total Work Order Description Budgqed Actual Difference 52203 Replace 037 Dump Truck 81,806.91 (81,806.91) 52204 Replace 130 Ford F350 Super Duty 96,934.41 (96,934.41) 52205 Replace 948 58,480.08 (58,480.08) 52301 international 4900 w/Altec 320,945.90 (320,945.90) 52302 Replace 995 2010 Dodge Dakota 44,504.92 (44,504.92) 52303 Replace 226 2012 Dodge RAM 1500 - 53,052.33 (53,052.33) 52401 Vacuum Excavator 95,000.00 73,784.87 21,215.13 52402 Replace 2014 GIVIC Sierra 181 40,000.00 40,955.96 (955.96) 52403 Replace 2014 GIVIC Sierra 376 40,000.00 40,955.96 (955.96) 52404 Servvice Body for Metering Truck 32,000.00 32,000.00 52405 Replace 2014 SUV 113 40,977.00 58,480.08 (17,503.08) 52406 Trencher/Plow Machine 65,000.00 55,512.33 9,487.67 $ 312,977.00 $ 925,413.75 $ 612,436.75 Work Order Descriation 62301 HCP Interconnect 62303 Fairfax Interconnect Downsize 62304 SCADA for HCP Interconnect 62401 Hanska Station Topsoil Removal and Rock 62402 Misc Developments & System Improvements 62403 City Projects 62404 Isolated Main Replacement (Btn Barley & Gler 62405 Improvements to Regulator Stations 62406 Service Lines 62407 Meters, AMI, and All Fittings 62408 Residential Regulators 62409 Industrial Metering and Regulation 62410 Methane Detector, Electro Fusion Machine Natural Gas Materials Labor 20,000.00 1,500.00 25,000.00 5,000.00 7,000.00 2,000.00 27,500.00 5,000.00 20,000.00 3,500.00 57,000.00 15,000.00 165,000.00 4,000.00 5,000.00 - 25,000.00 3,500.00 40,000.00 1,000.00 $ 391,500.00 $ 40,500.00 $ Total Total Budgeted Actual Difference 807,105.36 807,105.36 2,340.92 2,340.92 58,711.30 58,711.30 21,500.00 17,825.00 (3,675.00) 30,000.00 11,465.91 (18,534.09) 9,000.00 24,923.74 15,923.74 32500.00 - (32,500.00) 23,500.00 - (23,500.00) 72,000.00 74,462.76 2,462.76 169,000.00 4,195.22 (164,804.78) 5,000.00 - (5,000.00) 28,500.00 22,411.65 (6,088.35) 41,000.00 499.84 (40,500.16) 432,000.00 $ 1,023,941.70 $ 591,941.70 HUTCHINSON UTILITIES COMMISSION � Board Action Form 'XA61Tl`' Agenda Item: Consideration of the 2025 Non -Union Pay Grid Adjustment & Position Reclassification 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. 2024 Statistics below: 1. U.S. CPI-U: 2.7%, U.S. CPI-W: 2.6%, Midwest Region CPI-U: 2.6% 2. Mpls/St. Paul CPI-U: 1.7%, Mpls/St. Paul CPI-W: 1.9% 3. Social Security COLA: 2025 - 2.5%, 2024 - 3.2%, 2023 - 8.7% 2022 - 5.9% 4. Hutchinson Unemployment rate - 2.7% 5. Employee turnover rate - less than 2% 6. Bargaining Unit Increases: 2025: 4.5%, 2024: 5%, 2023: 4%, 2022: 4% 7. Upper-midwest/other salary market data: Public /Private Sector 3.6% - 4.0% Attached is the recommended non -union pay grid for 2025 that incorporates a 4.5% grid shift. BOARD ACTION REQUESTED: Approve the proposed 2025 non -union pay grid and job position reclassification Fiscal Impact: $41,000-$66,000 Included in current budget: Yes Budget Change: PROJECT SECTION: Total Project Cost: Remaining Cost: 0 o O m m txo c °1 0 Q m _0 N OA N C N � m 0 O Ln 00 I, m zt m zt rl n d' N m r, rl t O I, m 00 I, m t t 00 00 m O m I- N m O r,O (V m r, zt Obi N W al rl Ln O lD d' d' lD al d' N rl d' W lD lD m m Ln Ln W rl Ln 00 t to m zt to m N m 00 N to O d' 00 m 00 to Ol = m m m v v v v Ln Ln Ln �o �o n n n oo oo rn rn 0 O N �p m Ln to m N N O d' d' I, Ln 00 to N I- to N O to to 00 O 'O to m 00 rl rl rl to rl m m m lD I, O Ln lD Ol m Ol N I, m m lD Ol O to Il d' tq to n m rl Co Il Co lD Co 00 F, m N T O N t to W O m m W rl .4 r,rl .4W N r,rl lD rl I, mO m m m m m zt zt zt zt Ln Ln Ln to to to 1, 1, oo oo rn rn O Lo o W M O n � � W ri � N O rn N zt � n -i W W N Ln I" Ol O lq N d' to 00 rl m to Ol rl Ln dN' 00 ONl rl lq Ln Ol m 00 N I, N N N m m m m m v v v ztLn Ln Ln lD lD lD l, l, oo oo Om Ln n m I� to to m t m 00 t O I, N m O lD N rl 00 r�l lD m lD lD O I, N lD lD I, Ln m lD d' I, Ln ON ' 00 'tO m m to to N m m m N m rl 'tto to ti N O O N O m 00 t t O to m m N o0 rl m rl n Ln Ol Ln d' lD rl c7 N Ol Ln Ln N Ol Ol n n O lD n d' O d' 00 M m d' m Ln rl n Ln m r, N lD lD N lD rl lD rl ^ rl rl rl rl rl rl rl rl rl rl rl rl N N N N N C ON Ol N N d' N Ol Ln d' I, n m rl Ln 00 to Ol Ln rl N 4 O oo �' m m Ln N Ln n Ol O I, to zt rl m oo 00 00 o lD m y lD m y ,� v o of `L Lin o m ti�-4 Ln lD rn lD o 1-100 o� n O o o� Ln m In O In N o� O zt v Ln rn lD O rl 0l m N n m m m O lD m m n d' N rl O O O rl N d' Lo rl rl rl rl rl rl rl rl rl rl rl rl N N N O N rl m Ln lD Ol W Ln Ln m lD 0� m 00 Ln I, Ol Ol N 00 Ol O Ln lD Ln rn d' m I� 'tOd' lD m 00 Il n rl 00 of m Ln l6 r, m of r� r� Ln o N o rIj to m .� I, Ol Ln N .4 to O Ln mLn r, ro d m N I Nd n c7 m O 00 ci N 00 lD 00 N O N - oo lD ztrl Ln 00 00 Ln to I' zt d' lD N m N I, N m Ln lD Ln O to 't to I, to rl I" lD r,00 O Ln 00 O 0) lD 0) O O rl N N m i Ln lD I, 00 rl rl rl rl rl rl rl rl rl rl rl N (gyp rl N m ztoo Ln to I, � O rl rl rl r, rl m rl 'tLn rl rl lD r n rl oo rl Ol rl O N rl N r,L N N c X m 00 m to m 00 w m Ln m 0 O Ln I, m Ln m ^ Ol m d' rl (V v Iq lD d' v Ln m m I, v Ol m rl O Ln O 0 N m Ln Ol m m lD Ln m 00 I� Ol Ln O m rq m to m n rl n to m O N rl n Ln n d' Ln n 0 O O O oo 0 O W d' oo N w W Ol oo 00 w N Ln rn m O o m O n o W d' m O N m Ln Ol I, Ln N m to o0 O o0 d' to Ln m rl m rl Ol d' O d' Ln Ln Ol d' O o0 00 rl 00 rl 00 m Ln to I, Ol m rl m m rl 00 I, T O Ol ^ O lD N lD d' lD to W 00 N rl lD m m to O Ol O N rl Ln d' 00 al rl lD Ln lD Ol W m N 00 al N al I, rl m I, 00 N m m m m m d' d' d' d' Ln Ln Ln to to to I, n o0 00 Ol Ol O d N O N 00 N d' r 00 N I, N m I, d' r I, m I, r, oo I, r, r,to t N rl 00 Ln rl Ol I, 00 rl r, oo d' Ln d' O to rl 00 00 rl O to I� d' N to n n d' Ol N rl O m O Ln ri n `' Ol ZT Ol to I, Ol n N Ol Ln N Ol 00 N Ln to Ln O 00 d' to Ol O d' N N N N m m m m m d' d' d' d' Ln Ln Ln to to I, n n 00 N 00 rl rl n Ln rl O to m zt m O m to m O zt r, rl to O rl m d' m O m `~ `' m N al O rl d' al d' al Ln I: rl x m to O O m O o0 N 00 r, rl m m m O N m O w lD N Oo O r,rl d' rl rl O 000 m r,m 00 m m v to o to to m v d D m m oc n rn v m rn- O D O d' O O rl r, rl zt N ri m m m 00 d' to m to to lD n to 00 00 m O rl N N to m rl rl rl rl rl rl rl rl rl rl rl rl N N N N C O m zt oo r, m I, n m N m rl mto zt to Ol O -O O Ln � zt rl Ol 0o I,: Izt Ln 00 rl N 4 n m Ol Ol r, m rl n lD m 00 n rl lD N lD 00 n rl N N N m m 00 N O N N O O m m N m O Ln N Ln V% d' O Ol a N 00 I, W m '- N N 00 I, zt lD rl 17 00 lD to 00 ztm Ln I, N Ln N 00 N 00 m d' Ln �. 0 � r ^ lo W W a) a) O rl O rl rl rl N rl N rl m rl i rl Ln rl lD rl I, rl 00 rl Ol rl O N N O N 00 m d' N Ln ZT Ln N O N Ln ooto r%4 zt oo zt O rI m 00 m d N 00 rl 00 lD N dam' N Ln m m Ol O d' T o rl oo -4o o I, oo l6 o r-:Ln Ln r" 'to 0 o W lO m `L m d' N Ln m I- m N m Ol m W to Ol m m n Ol m W r rl m - m O n 00 N to N to lD O Ln r 00 r lD m Ol m 00 rl -4 r,rl -4 oo N r,rl lD N r- m 0) lD m O 00 lO Ln d' d' Ln Ln Ln to to to I, n 00 00 Ol Ol O O rl N m m d' Ln to I, rl rl rl rl rl rl rl rl rl rl N rl N m d' Ln lD r, oo � O rl N m tLn to I, 00 Ol O rl N � rl rl rl rl rl rl rl rl rl rl N N N N 10 L Ln Ln l0 l0 I� rl (7 rl rl rl rl rl N i �IC4 Ld L I, 00 13, Ol ci � 7 0p ^a; OC a a w ,` O co C N N > VI O co N O O co O O ? � •C t t Ou Ou w a)w 'r a° a- <<Lu a �C bakertill y Baker Tilly Advisory Group, LP 30 East Seventh Street, Ste. 3025 St. Paul, MN 55101 Tel: 651-223-3000 MEMORANDUM TO: Angie Radke, Administrative/HR Coordinator FROM: Baker Tilly Advisory Group, LP DATE: November 26, 2024 SUBJECT: Request for Review and Reclassification of Account Supervisor Baker Tilly Advisory Group, LP ("Baker Tilly") has completed the request for review of an Account Supervisor. We gained input from the organization utilizing a provided updated job description. The position was evaluated using Baker Tilly's SAFE System to ensure the position is assigned to the appropriate salary grade and to ensure that internal equity exists among positions within the department, as well as those currently classified by the organization. The Systematic Analysis and Factor Evaluation (SAFE) is a point factor evaluation process developed specifically for the comparison of local government positions. SAFE is comprised of nine compensable factors: Our review of your position using SAFE has resulted in the following recommendation: In reviewing the documentation you submitted, we identified new information that would result in a change to the evaluation of the Account Supervisor position. Therefore, Baker Tilly recommends a change to the SAFE points of the Account Supervisor position from 270 points to 310 points. This corresponds to a grade change from grade 8 to grade 9. This placement on the pay scale maintains internal equity within the Department and positions classified across the organization. The Title and Grade information appear below. Division Position Points Grade Administrative Account Supervisor 310 9 CC bakertilly Grade assignments must be made based on job evaluation to be compliant with the Minnesota Local Government Pay Equity Act. Should you have any questions or need additional information, please feel free to contact us at (651) 223-3000. Thank you. HUTCHINSON UTILITIES COMMISSION Board Action Form '�XA61Tl�`' Agenda Item: 2025 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 preliminary 2025 operating budgets and 5 year (2025-2029) CIP for the Electric and Natural Gas Divisions. At the November meeting on 11-27-24 a high level overview of the 2025 budgets were reviewed and the major changes budgeted from 2024 to 2025 were discussed in detail. As of the November meeting, there have been no amendments to the preliminary budget. The current budget reflects a 4.5% grid shift for non -union employees and a general wage adjust of 4.5% for union employees. Management recommends the Commission approve the final 2025 Operating budgets and 5 - Year CIP Program (2025-2029) as presented in the packet. BOARD ACTION REQUESTED: Approve as presented the 2025 Electric and Natural Gas Division Operating Budgets &5Yr. CIP Fiscal Impact: Included in current budget: No Budget Change: PROJECT SECTION: Total Project Cost: Remaining Cost: General 2025 Budget Items o Budget currently reflects a 3% decrease in Health Insurance premiums compared to the 2024 budget based on a $5500/$11000 deductible program which includes a 25% co-insurance portion. The plan also continues to include the HRA embedded program within the insurance plan. In addition, the budget continues to reflect an 80%/20% employer/employee premium split for exempt and non-exempt employees. The LTD, and Basic Life & AD&D will remain unchanged from the 2024 rates while Dental decreased 3%. Worker's Comp expense is budgeted at a 0% rate increase over 2024. The WC mod factor is currently budgeted the same as 2024. o Budget reflects a continual allocation of benefits to the various cost centers. (System Controls/Load Dispatch, Electric Distribution, Electric Production, Customer Service, and General Administration) o Budget continues to reflect a salary/benefit allocation of system control personnel to the Natural Gas Division. o Budget reflects a slight increase in the budgeted amount for 2025 to administer the Energy Conservation and Optimization (ECO) program to the current intentions of the State Statute language. (1.5% energy savings goal, 1.5% spending goal) However, the budgeted amount may not all be expended in 2025.2024 Budget: $307,118; 2025 Budget: $312,263 o Budget reflects an Electric Division PILOT transfer of 4.50% of 2023 audited operating revenues in the amount of $1,345,802 to the City of Hutchinson. This is the same amount budgeted for in 2024. In addition, the budget continues a city reimbursement for IT and Legal services. Electric Operating Revenues o Retail Sales Forecast: o For 2025, retails sales are budgeted at a 2.84% increase in revenue over the 2024 budget, but a 2.45% decrease in KWHR consumption based off a weighted average of the 3, 4, and 5-year averages. This shorter duration forecasting equates to 265,722,875 KWHRs in sales. The 2025 budget also reflects the 2nd of 3 years in retail rate adjustments based on the latest Cost of Service Study. o Power Cost Adjustment: o Power Cost Adjustments (PCA's) of $900,000 are budgeted and allocated between the different customer rate classifications. This is the additional amount charged to customers when the monthly power supply costs exceed $54/Mwhr and the rate stabilization fund cash balance is below $400,000. The PCA for 2025 is forecasted to generate an additional $500,000 over the budgeted 2024 total of $400,000. o KWHR Allocation used to determine KWHR retail sales by customer classes areas follows: o Electric Residential 20.26% o All Electric Residential .93% o Electric Small General Service 6.8% o Electric Large General Service 30.41% o Large Industrial 41.6% o Wholesale sales (Sales for Resale): o Capacity Sales are budgeted at $2,838,250; AEP - $1,221,250, Rice Lake Utility - $1,176,000, NextEra - $441,000 o Market sales are budgeted at $652,000 for 2025. o Other Revenues: o The 2025 budget shows $224,583 budgeted in miscellaneous revenue for areas including: GIS reimbursement, customer late payment and finance charges, security light fees, and bond premium revenue. In addition, the 2025 budget reflects $300,000 in investment earnings from investing cash in the secondary market. Electric Operating Expenses o Purchased Power: o MRES power expense is budgeted at purchasing 219,000 MWHR's at an average blended price of $51.27 per/MWHR. HUC will receive 219,000 MWHR's, with no system power loss factored as part of the purchases. MRES power received equates to 80.39% of power supply needed based on 2025 projections. o MISO LMP (Market) expense is budgeted on a 2021-2024 weighted average HUC LMP price. The budget reflects an average market price of $31.89 per MWHR and purchasing 32,261 MWHRs. LMP power needs equate to 11.84% of power supply needed based on 2025 projections. o Generation/Hedging expense is budgeted in various other expense categories. 21,171 MWHR's are budgeted for Hedging in 2025. Generation hedging equates to 7.77% of power supply needed based on 2025 projections. o Electric Production Expenses: o Fuel: Includes $195,900 in summer contracted natural gas at $3.75 per MMBTU for units #5, #6 & #7 hedging, $486,600 at a spot market price of $3.00 per MMBTU for units #5, #6, #7 hedging & market sales, and $441,000 in natural gas budgeted for strictly market sales on unit #1. There are also other operating expenses budgeted for chemicals, lubricants, water & sewer, and boiler to run generation. o In addition, production area includes $727,666 in natural gas transport expense. The transport expense reflects 1/3 of the annual principal and interest payments on the outstanding Revenue Refunding Bonds, Series 2012A to construct the natural gas transmission pipeline. The 1/3 transport expense is adjusted annually to reflect the current years P&I schedule. o The 2025 budget reflects generating 21,171 MWHR's for hedging purposes and 18,000 MWHR's for Market Sales. Market Sales MWHR's generated will fluctuate based on Market Prices. o Electric Transmission Expenses: o Electric transmission expenses are budgeted to increase by $260,064 over the 2024 budget. GRE - $2,315,064, MISO - $700,000 o Electric Distribution Expenses: o Roughly, 85% of the expenses in the distribution area are personnel related expenses. This area consists of routine replacement and maintenance related to distribution infrastructure, work on city infrastructure projects, street lighting replacements, and build outs for new developments. atural Gas Division General 2025 Budget Items o Budget currently reflects a 3% decrease in Health Insurance premiums compared to the 2024 budget based on a $5500/$11000 deductible program which includes a 25% co-insurance portion. The plan also continues to include the HRA embedded program within the insurance plan. In addition, the budget continues to reflect an 80%/20% employer/employee premium split for exempt and non-exempt employees. The LTD, and Basic Life & AD&D will remain unchanged from the 2024 rates while Dental decreased 3%. Worker's Comp expense is budgeted at a 0% rate increase over 2024. The WC mod factor is currently budgeted the same as 2024. o Budget reflects a continual allocation of benefits to the various cost centers. (Gas Transmission, Gas Distribution, Customer Service and General Administration) o Budget reflects a salary/benefit allocation of system control personnel to the Natural Gas Division. o Budget reflects a slight increase in the budgeted amount for 2025 to administer the Energy Conservation and Optimization (ECO) program to the current intentions of the State Statute language. (1.0% energy savings goal, .5% spending goal) However, the budgeted amount may not all be expended in 2025. 2024 Budget: $191,265; 2025 Budget: $192,410 o Budget reflects a Natural Gas Division PILOT transfer of 4.5% of 2023 audited operating revenues in the amount of $596,824 to the City of Hutchinson. This is the same amount budgeted in 2024. In addition, the budget continues a reimbursement for IT and Legal services. Natural Gas Operating Revenues o Retail Sales Forecast: o Retail Customer (Residential, Commercial, & 1 Industrial) volume sales forecasted on a 5-year average (2019-2023) at 841,926 MCF for 2025. o Contracted Customer Industrial volume sales forecasted on a 5-year (3M) and 3-year (Highland Park) average at 826,673 MCF's for 2025. Two of the three industrial customers are transport customers only with HUC providing the commodity as a pass through. Forecasted Industrial transport revenue sales are based off a transport charge on transported volumes of 826,673 MCF. The revenue generated from a forecasted blended natural gas price of $5.24 per DTH will have an offsetting expense for HUC to purchase the natural gas. The 2025 budget reflects the recent rate adjustments based on the Cost of Service Study. o Fuel Cost Adjustment: o Fuel Cost Adjustment (FCA's) credits of $600,000 are budgeted and allocated between residential, commercial, and (1) industrial customer, excluding the contracted transport industrial customers. Since the rate stabilization fund cash balance is above $600,000 any monthly system gas costs below $5.25 per MCF would result in customers receiving a credit back on their monthly bill. o Other Revenues: o Budgeted $822,278 for the N.U. Contract o Budgeted $1,128,300 for HCP Reservation & Transportation Contracts o Budgeted $727,666 for the capacity used on the pipeline by the Electric Division's generation/production area. This is a transfer between divisions. o United Farmers Coop Transportation agreement - $120,640 o Operating Revenue to maintain the Brownton distribution system is budgeted at $30,000. o Misc. customer service billing revenue is budgeted at $52,000 o Bond Premium is budgeted at $185,608 o Investment Earnings are budgeted at $300,000 Natural Gas Operating Expenses o Purchased Gas Expense o Retail Customers: The expense for this class is based off a 14-year average (2011-2024) consumption level at 864,604 MCF's. Contracted Gas makes up —78% of the Dth's needed in 2025 for retail customers at an average price of $4.08 per Dth. The remaining — 22% of retail gas needed will be purchased swing gas at an estimated price of $3.00 per Dth. Total average weighted natural gas price budgeted for retail customers is $3.84 per Dth. This price excludes the additional natural gas prepaid discount for 2025 of a portion of the volumes at 10 cents/Dth. o Contracted Industrial Customers: consumption based on a 5-year (3M) or 3-year (Highland Park) average. The budget is based on 826,673 MCF's at an estimated blended gas price of $5.24 DTH. o * Total blended budgeted expense is $4.52 per DTH o Natural Gas Transmission Expense o Mostly personnel costs, Public Awareness Materials, and routine maintenance & repairs based on MNOPS program requirements. o Natural Gas Distribution Expense o Mostly personnel costs, routine maintenance & repair costs based on MNOPS program requirements. LA o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N a O l0 00 O Ln rV 00 O O .-7 O I� m 0 Ln .-7 l0 I� .-7 l0 .-7 m o m l0 N O .-7 Ln V O 00 rIt N N N N O O O N N H O LA1 M; cci N -i o N ^ a) O O N l0 n O r� Ln O 00 to O N r� �D �D �D O to m O n Ln v C >r cLi Q1 I� O Q1 O Q1 O N O GO O l0 O O 00 N LO 40 N O) a)' O O l0 m .-1 O r� l0' fV O l0 O m � l0 00 00 = w m O m Ln H t fV l0 Oo rV N O r4 Qm V H Ln H V Ln N rV V H H V V C U l 0 0 00 LD 00 0 11, 11, "11" �,N a ^"N 11, n Ln N i LD Q Nu n m LD LD Q A' � tto ,q u�� u� N a .." ul, 1, n N LD � m LD Ln 11, �N �N u', N N u." u1, u1,Ll NNO, N, 0r 00 0 m �s Ln ,a, 00 0m �s m mM� N O N i/T i/T -4R1 l0 O O m 0 .-7 O N w O O O l0 N n O 00 M Y y l0 O O O O m 0 N l0 N O l0 O rN m m w Ln to .-7 O O rV l0 m C M Oo O O rV O rV Ililz: n Lift; 'O .-7 .-7 O Oo t N O O N m N:t O n fV rq LO 7 N 00 O O rq .-7 Ln M rq r� Ln m l0 m 0 M m m to :t r� Ln r� (n a) m r� m :t to m r- Ln m N m rf r`i ; o i � i M V ri O H N AA. AA. i/I•'; .-7 00 .-7 m rq m (n a) :t O n O n O rq h .-i t m m O O N fV l0 .-7 r� O a) Ln 00 rq H _ a) Ln Ln 00 O O 00 l0 O N O l0 m 't LO N V O O m m m l0 .-i 00 Ln oo r� oo oo rV O Ln Ln M N O l0 00 M O N O Ln :t m 00 m rq rq :t 00 00 N r V oc (11 l0 10 m 00 N `3 Ln O O l0 rV O Ln Ln LID a en Q 00 rV r-7 r-7 LO l0 Ln rq r-7 m rV m Z O N M M LO M M V m l0 r� rq Ln l0 O r� l0 m n O m 00 m r-7 r-7 l0 m V 00 N m N r� r� Ln 00 00 1p H V a) Ln (::Ln' O � .-7 O a) a)Ln O � m Lr �-7 � O a) N w m m m t lD m m N 00 N Q L H N r-7 mn m rV 00 O r-7 rV rV l0 r- M LM J en NO a) `~ O r- r-m rn N �-I �-7 00 a .-7 l0 O m l0 O r- a) m �-7 N m O RT 00 R^# y Lo Ln m O t oo m r� to m O m .-+ O Ln a) Ln H m co 00 r� 00 O m m .-+ N m 00 O r- m to M M r, `3� ' Ln to m m t to rn to Ln 00 om N Ln co rn Ln (::m � m r-i .-i r.i to m m r� .-i LO (n 1p; G Q a) .4 a) .-+ N r� m 00 N 00 m m 00 O a) M G rq m O r� to 00 omo' Lr M V .-+ Ln 00 to Ln Ln Ln 00 N N rV r rf N Le W O z N i/T i/T i/I•'; Fa t Ln rV O a) Ln m 00 m a) rq rq O V H N rV m Ln m O m r-7 Ln rV rV O Ln O V O v rV Ln O Ln lz: oc fV .-7 00 rV 00 m LA LO oc rV l0 l0 Ln rl m O .-7 .-7 Ln O .-7 a) O m m M 10 N Q Ln rV Ln 00 Ln oc rV O l0 l0 H Ln l0 Ln a) m Ln 00 N rV oc I� Ln r- a) LO 00 LM W rq N 00 :t r-I Ln l0 rn N r-7 rV rV a O N m rV m O m r� O :t n m Ln Ln l0 LO n m jp 00 .-7 r� 00 l0 fV M rV Ln O N a) r- N O O N. Y 00 O rV rV a) a) M m a) l0 O 00 Ln N ei a) a) rq Ln rq r�n <D :t Cry N Cry r- O I*+. Q O O :t l0 Ln m rq 00 rq m a) a) m r- l0 rq O O N Ln r� O l0 rV r� M N �-7 N m a .-7 00 Ln rV O m � l0 GO rV m rV rV �-7 N M h :. ttiy O N AA. 4A. a W u Q h u h h J a U h W N y 1 O O N at W U 01 N .4 y W O r C N Q N i zj y O O G 3 i 01 k h O Ln w U 5 w U a W a` W w Wa LL W W W 01 Q J a0.a0. W , Z i O 01 Q z i s Q 'ti Q J C1C W N O. a.. y i W W 3 a O a 'r" '" ?C W 3 i W W C W Q w OC U to a M W 0 I— w o. Ln N r_ O fV n .- L1 n 00 O l0 to O lz� l0 rV m O lz� .-i O O N Ln r-� l0 Ln O Ln m 00 O rV lz� lz� a) 1-1 a) 1-1 LO LO N rIt 10 m N O O m N Ln .-7 O fV H m o a) to m 0 .-7 n O 00 U N N Ln n a) Ln O H O Ln 0 O Q) t 0 0 to N O (n M LR i a) 00 O to O N N N O Ln m N l0 l0 O to fV O N M 00 N O) n O to N O m O N m M to N O to O m .-7 O N e^I' N .-i M O r" Q�1 V M GO m QO V VLf) V a � N � V N N C O m Ul u...p LD 0 0 11' Q m Q m m "'1 Q Q m "„1 1, O a"N O m O u.ul !w'b m O Ln e..p m LD O O LD aN,N U"'b H LO ,u , 'uN , v . Ln y v LD 0 Z N. N 00 O m m e...p m 0 N m 0 N�N m 4"1, LD m e...�p 'II! �,N m N LO �N,N 0 a p u.ul 0 4"1, 0 m m LD a N�N N�N �,N m n LO e1'.:. O Ln LD a p p',' m m' u�b a��H m a p m aNN aq, MI N N e O N .-7 :t N Ln O 00 O 00 O m N O O O N N n rq LO Ln '.. W a-7 m .-7 m O O O N O m N m 0 to O O O m m Oto ' to Ln a) O O N O Ln O It O N Olzl O to V m 'O n .-7 O 00 O:t .-7 fV m O N 00 Ln t 0 0:t m O a 7 00 m m to O fV 00 fV r� 00 :t m N :t m r- l0 N 1� 00 m O 00 r� l0 :t H l0 N m rq r� l0 r� m m O :t -T N a l0 r- 00 m m Ln fV rl� m fV rI O V n M r-7 Ln fV fV r-7 00 fV rq O Ln O O to Ln r� to a) :t a) O :t 00 O N .-7 :t .-7 n fV m O :t V _ rl to a) to m Ln m Ln M m a) fV O 00 m a) O LO M. V N l0 O N O m m 00 O LO fV � n 00 m Ln .-7 m LO C0 m m fV a) a) 00 r-7 O 1� N r� 00 m O N Ln Ln Ln 00 rq o Ln m rn m 00 co c o o rl .-+ m 00 m en Q Ln to r� N N � a) fV r-7 fV r-7 N N 14 a) a) Ln 00 :t O m Ln m :t n .-7 .-7 fV m O H Ln CF H N r� r� Ln 00 r� m r� 00 LO r-7 00 fV r� l0 m H N N LO _ o rn Ln Ln LO Ln Ln rn m u1 00 > t m Ln a) o Ln r- 00 o m a) m to 00 co O Le G .-+ Ln to to m N o r� t to M O Ln O .-+ N m r� Ln O :t n LO M V ena) N 00 a) O Ln 00 Ln rq m m O m m O .-+ Ln rIT m m fV fV m Ln O N .-i N �— N AA. V _ m O a) n O m .-7 00 m .-7 fV to Ln m W J Ln 00 M W N O � a) a) Na) 00 r-7 00 Q) rq :t N m LO N a) a) a) 00 Ln fV Ln fV l0 m m N n fV n N rq m Ln. N',. Q (7) fV m o 00 to n Q) m fV to O O (,00 V Ln. rq .-7 O a) m:t l0 m RT rq l0 00 m:t .-i O n -T m N N .-7 a) n a) .-7 :t rq :t l0 H r- 00 Ln rq O t .-7 00 to :t O to :t Ln m fV fV m fV fV LO N Cr N O M M to 00 to r� O Ln 00 .-+ a) 00 00 m to m m l0 O LO 00 m .-+ :t .-+ m m Ln N Ln 00 N fV 00 a) r� O Ln M m Ln m rl Ln Ln co Ln c to to to N O Ln to V m m Ln o � .-; � .-; 00 o o Ln o n o (7) Ln M cf" Q r� n N Lm N O N Ln La) m r� to O n N m M N O 00 00 Ln r+ N m o a m o) to :t 00 r� m a) a) Ln m i rf V o Ln O N M N Ln m n l0 fV rq .-7 a) a) :t n a) l0 m l0 O M h'. jp 00 to Ln Ln 00 .-7 O to N to m O fV m fV Ln O LO Ln O to to to 00 O a) (T) N n a) a) to Ln 00 � Ln Ln l v fV n M M .-7 a) M 00 �--I' t Ln lD :t 00 Ln .-7 N 00 Q a) to :t to :t O a) l0 00 a) m m m O m m m m 00' O N to N .-+ m .-+ N w m Ln r- 00 fl� LO 00 N w .-+ � w m m m fV fV fl� O Ln 1 O N N a ,1 Q N N W 01 V i i H W Ln Q > O O Q N G w O O G 3 G W k h O. V LL W a k. W a:. 01 01 a O 01 W W W 01 01 a i G z 01 L. J cc N H .� .O. ate. i s a W J OG ate. 01 N CL W 01 a s O a }C 01 3 O 01 W O O. 01 W'. 0: Ln J a Lnh �— W a Q. �— a s 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00 N O N to to r.n N :t O m 1-1 lz� n 1-1 O I� V n .- O 7 O I� a1 rV .-7 a) O rV ri O V 0'. Off r0 .-7 O N .-7 O O O rV O m .-i O O 00 r� rV 01 L v M N i i o N m 00 :t n io rn o n rV N o �D 0 Lo e1 t rV In 00 to O O (n 00 O O r.n 0 F� h i u N .-i a) O O I� lD lD O l0 00 w Lr �o �o m Ln M a) O o �o ui M N `^ rn 00 N Qp V C n lD 1•'r M 00 LD i 0 0 a ID �p O N �'N 4"1, O �,N 4"1, O (n M' co ,q N„ e p gyp„ �N M �. N pn,,. 'ttoO LD aN,N O m �,„. v �p p11 p11 �,N m O V �',i`a„ �N �N, u,�a„ "^�, �,N m N 00 �u'„N u'l p M 11, O �N„ u,ui, a p„ u�l a ��N 00 00 R1' M ..; Lnm m u.ul �IN Ln �,N Yl, a p e...p N N'..... N O N m O m 0 m to O:t m 0 (n N h'. y m m N O O rq 0 N m N O rq m 0 N LM to m rl l0 rl to O I� 00 00 O Oo a) Oo N cf 'O .-7 rq :t Oo t m N (n O O O lD 00 w w M 7 m .-7 :t O fV m N RT GO t O m to N w 00.; m w rq r-7 r-7 N N m N H N H N H N O W a m m I.n rl 1fl N I- O Lo w O t�D O .-+ m r+ N O m�D m m m co t m m N 0 O N .-+ w in in m Lo el — � rn N rn oc �o in u1 m N m m In a m rq w m m m N o N m rri t N w rqi 00 cvi N O N m N m O m 0 00 N �o N m w m N LM I v l0 .-i 00 to to O M to r.n a) � 00 fV 1' 40 M Q rq rq Cry r-7 r-7 N r-7 1.r) (n N.''... Z \ H O Oq V). Vf H �_ _ r0 lD r� lD lD r� N rq t 00 r� H H a) Lf) l0 00 r-7 r� I.r) N lD 00 r-7 :t H N r- 00 (n Ln h . N',. 0 Y a) -t N N' - - r l .-7 m .-7 to a) V rl , v a) a) r� a) a1 a)r- N .-i N n N 00 00 l0 Ln Q t 00 m � H N r� Ln N m a) 00 00 N Ln 01'. a a) .-7 00 O r� m lD N 00 lD O Ln 00 m M M N m' O J a N AA. .A. 44 oo �o � oo m r m rq rq a) a) in N N 00 It .-7 .-7 m N 00 a) r.n M rq N � � W � rq n*•I ',. a O oc to to Lr 0q 00 rl to l0 00 l0 z V m Q1 m to N m 00 m to N m m N m M Q N N .-7 m .-7 m m V m m m N O .-7 (n LM N F rfry N O V l0 00 .-7 m N fV O fV : m to m m O m jp N N rq :t m O m N N lD lD :t m m (n N O rl l0 rl O r.n a) a) O Oo r.n rl to rl lzl V L' Q Q1 I� N w N O .-7 00 O O N m 0 N O n m O m r.n 00 r.n rV Ln .-7 m a) r� 00 n N 00 N lD 00 a) O to m Ln lD 00 O Ln r- :t M ',. rqrq O N m a) 00 :t m 00 .-7 l0 00 .-7 r.n a) rV O Ln eq rn m a r- 00 rn �o rq rn r+ rn r� O V N N co rl rl O ci rn rn rn io m (:: Lc ef' m o �o r-i Ln a) 00 Lc r-i 00 00 m 00 �D N OD' Q �D rn 00 :t �D rn �o M a) 00 00 r� m m rq vi O N m m �D O O Om� m' ' m' .-7 N N rrn O Ln r� Ln n .-i N H 14 O rq a W O � N h a •� a � e oC h rii N ' ui > e a' c wtm N a N .03 .O W tj `t WJ "^mW 0. , W W 01 01 X W y ZZa NG— °iv i a h ti- LU w o o er + oc oc��MWo O h x u, w a w a a w aao1-oo O �+ z OPERATING REVENUES Electric Energy Sales Natural Gas Sales Other Operating Revenues Total Operating Revenues OPERATING EXPENSES Production: Operations Maintenance Operations Purchased Power/Gas Other Power Supply Transmission: Operations Maintenance Distribution Expense: Operations Maintenance Customer Accounts Expense Sales Expense Administrative & General Depreciation Contribution to the City of Hutchinson Total Operating Expenses Detailed Income Statement Combined Divisions (Electric & Natural Gas) 2020 2021 2022 2023 10/31/24 YTD 2022 2023 2024 2025 Actual Actual Actual Actual Actual 11 Budget I Budget I Budget Budget $ 26,418,356 $ 29,629,132 $ 30,321,138 $ 28,055,608 $ 23,157,440 $ 29,017,244 $ 29,980,654 $ 28,583,363 $ 29,099,467 $ 9,800,539 $ 13,444,627 $ 13,520,128 $ 11,976,909 $ 8,687,020 $ 12,029,836 $ 13,179,855 $ 12,248,803 $ 12,431,928 $ 1,761,939 $ 1,829,095 $ 2,004,144 $ 1,968,198 $ 2,434,287 $ 1,987,600 $ 2,275,266 $ 3,028,903 $ 2,995,384 37 0 $ 42.000.715 $ 2,924,641 $ 4,281,814 $ 5,702,451 $ 4,168,168 $ 3,513,472 $ 558,908 $ 770,277 $ 1,009,833 $ 826,298 $ 742,584 $ 18,424,450 $ 23,251,253 $ 22,521,870 $ 19,688,330 $ 15,538,064 $ 340,060 $ 319,382 $ 299,646 $ 296,849 $ 308,970 $ 2,796,858 $ 3,511,512 $ 3,618,364 $ 3,744,020 $ 2,822,788 $ 21,001 $ 74,406 $ 113,737 $ 47,432 $ 37,617 $ 1,820,741 $ 1,805,178 $ 2,027,000 $ 2,082,423 $ 1,903,797 $ 613,205 $ 625,624 $ 1,057,997 $ 1,043,217 $ 958,446 $ 442,141 $ 437,383 $ 475,356 $ 463,463 $ 493,416 $ 340,932 $ 211,320 $ 232,897 $ 208,673 $ 199,924 $ 2,031,234 $ 2,152,987 $ 2,257,061 $ 2,248,222 $ 1,892,401 $ 3,893,093 $ 4,431,549 $ 4,533,000 $ 4,423,776 $ 3,628,107 $ 1,867,192 $ 1,867,192 $ 1,867,192 $ 1,904,536 $ 1,871,477 $ 3,846,295 $ 4,473,985 $ 4,233,849 $ 4,192,817 $ 733,283 $ 865,150 $ 799,603 $ 916,977 $ 19,927,587 $ 21,566,760 $ 20,379,028 $ 20,256,167 $ 256,354 $ 282,627 $ 247,256 $ 349,208 $ 4,096,145 $ 4,226,330 $ 3,664,169 $ 3,833,169 $ 434,094 $ 88,427 $ 85,604 $ 72,262 $ 2,483,280 $ 2,546,553 $ 2,801,033 $ 2,676,338 $ 730,787 $ 750,933 $ 788,308 $ 973,951 $ 511,067 $ 535,115 $ 568,295 $ 514,605 $ 501,628 $ 496,141 $ 498,383 $ 504,673 $ 2,237,723 $ 2,165,681 $ 2,293,886 $ 2,370,116 $ 4,400,000 $ 4,400,000 $ 4,430,000 $ 4,310,000 $ 1,867,192 $ 1,904,536 $ 1,942,626 $ 1,942,626 Operating Income (Loss) $ 1,906,377 $ 1,162,976 $ 129,006 $ 855,308 $ 367,686 $ 1,009,246 $ 1,133,537 $ 1,129,029 $ 1,613,871 NONOPERATING REVENUES (EXPENSES) Interest Income $ 737,923 $ 43,805 $ (878,836) $ 1,354,735 $ 801,003 $ 350,000 $ 500,000 $ 750,000 $ 600,000 Merchandise & Contract Work, Net $ 177,633 $ (38,937) $ 18,439 $ 7,262 $ 1,334 $ (34,500) $ (60,500) $ (67,000) $ (13,500) Miscellaneous Income $ 1,686,795 $ 164,760 $ 96,081 $ 244,975 $ 909,113 $ $ 64,074 $ 67,186 $ 71,733 Gain (Loss) on Disposal of Assets $ 54,617 $ 85,318 $ (3,693) $ - $ $ $ - $ - $ - Bond Service Fees $ (475) $ (475) $ (820) $ (475) $ (475)'', $ (500) $ (500) $ (850) $ (475) Bond Premium $ 219,065 $ 219,065 $ 219,065 $ 219,065 $ 182,554 $ 219,064 $ 219,065 $ 219,065 $ 219,065 Prior Period Adjustment $ - $ - $ (28,044) $ (28,044) $ $ - $ - $ - $ - Interest Expense - Customer Deposits $ (6,824) $ (356) $ (653) $ (15,079) $ (2,519)'', $ (100) $ (100) $ (600) $ (1,800) Interest Expense - Bonds $ (1,067,981) $ (983,515) $ (892,185) $ (779,885) $ (585,480) $ (901,407) $ (786,906) $ (703,277) $ (596,732) Total Nonoperating Revenus(Expenses) $ 1,800,753 $ (510,334) $ (1,470,645) $ 1,002,555 $ 1,305,531 $ (367,443) $ (64,867) $ 264,524 $ 278,291 Net Income (Loss) $ 3,707,129 $ 652,642 $ (1,341,639) $ 1,857,863 $ 1,673,217 $ 641,803 $ 1,068,670 $ 1,393,553 $ 1,892,161 COGS $ 25,065,918 $ 32,208,644 $ 33,265,901 $ 28,771,096 $ 22,963,495 $ 29,293,758 $ 31,503,279 $ 29,409,508 $ 29,620,600 Gross Profit $ 12,914,917 $ 12,694,210 $ 12,579,509 $ 13,229,619 $ 11,315,253 $ 13,740,923 $ 13,932,496 $ 14,451,561 $ 14,906,180 Gross Margin 34% 28966 27% 31% 33% 32966 31% 33% 33% Operating Margin (%) 5% 3% 0% 2% 1% 2% 2% 3% 4% Net Income (%) of Operating Sales 10% 1% -3% 4% 5% 1.5% 2.4% 3.2% 4.2% N.I. (%) of Operating Sales (after cap labor) - - - - - 4.2% 4.2% 4.5% 4.4% 2025 COMBINED INCOME STATEMENT 2025 Net Income $ 1,892,161 Capitalized Labor - Production $ 25,000 Capitalized Labor - Distribution $ 30,000 Capitalized Labor - Natural Gas $ 18,500 Combined INC STMNT $ 1,965,661 2025 COMBINED CASH FLOW STATEMENT 2025 Net Income $ 1,892,161 Depreciation $ 4,310,000 Bond Premium $ (185,608) 2025 Total Cap Exp $ (1,874,500) Principal Debt Payments $ (2,685,000) SOE Proceeds $ 12,000 2025 Combined Cash Flow $ 1,469,053 Detailed Income Statement Electric Division 2020 2021 2022 2023 10/31/24 2022 2023 2024 2025 Actual Actual Actual Actual YTD Actual 11 Budget Budget I 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 Supery ison (911) Misc. Selling Expense (916) Total Sales Expense(911, 916) $ 23,203,684 $ 23,759,403 $ 23,287,218 $ 22,629,937 $ 19,617,222 $ 24,125,244 $ 24,150,654 $ 24,502,363 $ 24,709,217 $ 505,660 $ 1,648,194 $ 1,587,435 $ 305,137 $ 556,670 $ 1,200,000 $ 1,600,000 $ 400,000 $ 900,000 $ 2,709,012 $ 4,221,535 $ 5,446,484 $ 5,120,534 $ 2,983,548 $ 3,692,000 $ 4,230,000 $ 3,681,000 $ 3,490,250 $ 26,418,356 $ 29,629,132 $ 30,321,138 $ 28,055,608 $ 23,157,440 $ 29,017,244 $ 29,980,654 $ 28,583,363 $ 29,099,467 $ 31,442 $ 56,300 $ 132,161 $ 137,699 $ 122,892 $ 177,600 $ 134,400 $ 135,100 $ 135,000 $ 10,817 $ 10,597 $ 10,515 $ 91150 $ 7,938 $ 11,000 $ 11,000 $ 10,000 $ 9,500 $ 26,460,615 $ 29,696,029 $ 30,463,813 $ 28,202,457 $ 23,288,270 $ 188,600 $ 145,400 $ 145,100 $ 144,500 $ 29,205,844 $ 30,126,054 $ 28,728,463 $ 29,243,967 $ 1,691,235 $ 1,648,442 $ 2,255,577 $ 1,994,967 $ 11788,138 $ 1,863,414 $ 1,901,362 $ 2,041,089 $ 2,106,951 $ 1,073,484 $ 2,357,038 $ 3,234,043 $ 1,896,121 $ 1,564,952 $ 11819,233 $ 2,359,623 $ 1,954,760 $ 1,876,166 $ 159,922 $ 276,334 $ 212,830 $ 277,080 $ 160,382 $ 163,648 $ 213,000 $ 238,000 $ 209,700 $ 2,924,641 $ 4,281,814 $ 5,702,451 $ 4,168,168 $ 3,513,472 $ 3,846,295 $ 4,473,985 $ 4,233,849 $ 4,192,817 $ 18,208 $ 8,636 $ 90,602 $ 21,609 $ 19,423 $ 83,000 $ 36,000 $ 21,000 $ 26,000 $ 339,140 $ 507,501 $ 576,007 $ 511,006 $ 479,260 $ 353,283 $ 524,150 $ 569,603 $ 606,977 $ 201,561 $ 254,141 $ 343,224 $ 293,683 $ 243,901 $ 297,000 $ 305,000 $ 209,000 $ 284,000 $ 558,908 $ 770,277 $ 1,009,833 $ 826,298 $ 742,584 $ 733,283 $ 865,150 $ 799,603 $ 916,977 $ 12,835,939 $ 13,420,688 $ 13,164,998 $ 12,053,183 $ 9,974,945 $ 12,297,526 $ 12,862,000 $ 12,638,152 $ 12,605,893 $ 340,060 $ 319,382 $ 299,646 $ 296,849 $ 308,970 $ 256,354 $ 282,627 $ 247,256 $ 349,208 $ 13,175,998 $ 13,740,070 $ 13,464,644 $ 12,350,032 $ 10,283,914 $ 12,553,880 $ 13,144,627 $ 12,885,408 $ 12,955,101 $ 187,870 $ 197,074 $ 203,256 $ 213,925 $ 186,417 $ 190,000 $ 190,000 $ 200,000 $ 212,000 $ 2,136,904 $ 2,845,628 $ 2,882,993 $ 3,009,524 $ 2,087,214 $ 3,325,000 $ 3,325,000 $ 2,755,000 $ 3,015,064 $ - $ - $ 9,128 $ 2,118 $ 15,704 $ - $ 40,000 $ 40,000 $ 30,000 $ 9,767 $ 67,769 $ 94,083 $ 30,488 $ 28,056 $ 31,094 $ 32,381 $ 43,538 $ 32,097 $ 2,334,542 $ 3,110,471 $ 3,189,459 $ 3,256,055 $ 2,317,391 1111111 $ 3,546,094 $ 3,587,381 $ 3,038,538 $ 3,289,161 $ 1,086,352 $ 1,037,787 $ 1,126,088 $ 1,166,114 $ 1,150,619 $ 1,397,146 $ 11371,030 $ 1,620,455 $ 1,466,320 $ 399,505 $ 408,868 $ 828,836 $ 759,979 $ 622,684 $ 433,610 $ 447,466 $ 486,587 $ 628,870 $ 1,485,857 $ 1,446,654 $ 1,954,924 $ 1,926,093 $ 1,773,303 $ 1,830,756 $ 1,818,497 $ 2,107,042 $ 2,095,190 $ 4,553 $ 5,101 $ 4,705 $ 4,126 $ 32,624 $ 27,071 $ 16,723 $ 14,207 $ 31,566 $ 163,398 $ 172,186 $ 186,732 $ 187,070 $ 177,006 $ 178,627 $ 201,993 $ 221,115 $ 202,927 $ 23,567 $ 1,253 $ (1,472) $ 3,785 $ - $ 5,500 $ 4,000 $ 4,000 $ 4,000 $ 61,088 $ 61,655 $ 63,138 $ 61,457 $ 59,884 $ 71,298 $ 74,147 $ 73,840 $ 48,889 $ 252,607 $ 240,195 $ 253,103 $ 256,437 $ 269,513 $ 282,496 $ 296,863 $ 313,162 $ 287,382 $ 237,281 $ 107,256 $ 137,673 $ 120,808 $ 120,536 $ 334,882 $ 307,729 $ 307,118 $ 312,263 $ 237,281 $ 107,256 $ 137,673 $ 120,808 $ 120,536 $ 334,882 $ 307,729 $ 307,118 $ 312,263 Detailed Income Statement Electric Division 2020 2021 2022 2023 10/31/24 2022 2023 2024 2025 Actual Actual Actual Actual YTD Actual 11 Budget Budget I Budget Budget Administrative and General Adminstrative and General Labor(920) $ 494,674 $ 492,700 $ 527,645 $ 556,002 $ 467,270 $ 513,307 $ 547,969 $ 532,533 $ 579,462 Office Supplies and Expenses(921) $ 251,847 $ 246,645 $ 291,532 $ 271,655 $ 268,400 $ 257,908 $ 279,727 $ 290,961 $ 319,462 Outside Services (923) $ 98,403 $ 91,928 $ 99,983 $ 104,238 $ 66,685 $ 116,994 $ 70,014 $ 74,815 $ 75,907 Property Insurance(924) $ 194,883 $ 328,326 $ 391,607 $ 311,023 $ 271,740 $ 371,596 $ 277,156 $ 318,355 $ 331,014 Employee Pension & Benefits (926) $ 229,083 $ 188,880 $ 161,872 $ 213,671 $ 190,992 $ 204,729 $ 210,311 $ 236,387 $ 213,576 Regulatory Expense(928) $ 8,459 $ 4,483 $ 5,784 $ 1,350 $ 375 $ 15,000 $ 1,000 $ 1,400 $ 900 Misc. General Expense (930) $ 76,834 $ 93,313 $ 97,259 $ 92,203 $ 68,680 $ 96,336 $ 99,553 $ 106,659 $ 107,352 Maint. Of General Plant(935) $ 94,731 $ 114,195 $ 66,414 $ 49,755 $ 25,557 $ 67,405 $ 45,754 $ 69,058 $ 55,419 $ 1,643,276 $ 1,531,484 $ 1,630,167 $ 1,683,093 Total Administrative and General (920, 921, 923, 924, 926, 928, 930, 935) $ 1,448,914 $ 1,560,471 $ 1,642,096 $ 1,599,897 $ 1,359,699 Other Expenses Depreciation Expense (403) $ 2,804,539 $ 3,334,286 $ 3,440,752 $ 3,326,461 $ 2,703,820 $ 3,300,000 $ 3,300,000 $ 3,330,000 $ 3,200,000 Payment in Lieu of Taxes (408) $ 1,293,543 $ 1,293,543 $ 1,293,543 $ 1,319,414 $ 1,121,503 $ 1,293,543 $ 1,319,414 $ 1,345,802 $ 1,345,802 Contribution To City - Roadway Lighting (408) $ - $ - $ - $ - $ 252,620 $ - $ - $ - $ - $ 4,593,543 $ 4,619,414 $ 4,675,802 $ 4,545,802 Total Other Expenses (403, 408) $ 4,098,082 $ 4,627,829 $ 4,734,295 $ 4,645,875 $ 4,077,943 TOTAL OPERATING EXPENSES $ 26,516,830 $ 29,885,038 $ 32,088,477 $ 29,149,662 $ 24,458,356 $ 29,364,504 $ 30,645,130 $ 29,990,689 $ 30,277,787 OPERATING INCOME (LOSS) $ (56,215) $ (189,009) $ (1,624,664) $ (947,205) $ (1,170,085) $ (158,660) $ (519,076) $ (1,262,226) $ (1,033,820) NONOPERATING REVENUES/(EXPENSES) Merchandise & Contract Work, Net $ 79,988 $ (40,569) $ (17,798) $ (21,798) $ (20,012) $ (35,000) $ (61,000) $ (55,000) $ - Interest Income $ 368,961 $ 21,851 $ (439,383) $ 677,583 $ 400,502 $ 175,000 $ 250,000 $ 375,000 $ 300,000 Misc. Income $ 1,667,724 $ 108,497 $ 64,639 $ 208,842 $ 136,550 $ - $ 41,648 $ 43,671 $ 46,626 Interest- Customer Deposits $ (4,435) $ (232) $ (424) $ (9,801) $ (1,637) $ - $ - $ (300) $ (1,000) Bond Service Fees $ (475) $ (475) $ (820) $ (475) $ (475) $ (500) $ (500) $ (850) $ (475) Interest Expense - 2017B Bonds $ (531,506) $ (505,606) $ (478,523) $ (450,423) $ (353,047) $ (480,857) $ (452,856) $ (423,657) $ (393,257) Bond Premium $ 33,457 $ 33,457 $ 33,457 $ 33,457 $ 27,881 $ 33,456 $ 33,457 $ 33,457 $ 33,457 Gain (Loss) On Disposal $ 31,158 $ 37,150 $ (3,693) $ - $ - $ - $ - $ - $ - Amortization - Solar Array Land Lease $ - $ - $ (28,044) $ (28,044) $ - $ - $ - $ - $ - $ (307,901) $ (189,251) $ (27,679) $ (14,649) TOTAL NONOPERATING REVENUES/(EXPENSES) $ 1,644,872 $ (345,928) $ (870,589) $ 409,341 $ 189,762 NET INCOME COGS Gross Profit Gross Margin Operating Margin (%J Net Income (%J of Operating Sales Net Income (%J of Operating Sales (after cap labor) $ 1,588,657 $ (534,936) $ (2,495,253) $ (537,864) $ (980,323) $ (466,561) $ (708,327) $ (1,289,905) $ (1,048,469) $ 18,994,090 $ 21,902,632 $ 23,366,387 $ 20,600,553 $ 16,857,362 $ 20,679,552 $ 22,071,143 $ 20,957,398 $ 21,354,056 $ 7,466,525 $ 7,793,396 $ 7,097,426 $ 7,601,905 $ 6,430,908 $ 8,526,292 $ 8,054,911 $ 7,771,065 $ 7,889,911 28.2% 26.2% 23.3% 27.0% 27.6% 29.2% 26.7% 27.1% 27.0% -0.21% -0.64% -5.33% -3.36% -5.02% -0.5% -1.7% -4.4% -3.5% 6.0% -1.8% -8.2% -1.9% -4.2% -1.6% -2.4% -4.5% -3.6% - - - - - -0.7% -0.7% -1.6% -3.4% NET INCOME 2025 Net Income $ (1,048,469) Cap. Labor - Production $ 25,000 Cap. Labor- Distribution $ 30,000 2025 Net Income $ (993,469) CASH FLOW STATEMENT 2025 Net Income $ (1,048,469) Depreciation $ 3,200,000 2017B Principal Debt Payment $ (790,000) 2025 Cap Exp $ (1,482,000) SOE Proceeds $ 12,000 2025 Electric Cash Flow $ (108,469) 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 Purchased Gas for Retail (807) Contract Gas for Large Customer (807) Total Purchased Gas Transmission Gas Transmission System Control Operations (851) Gas Transmission Operations (856) Gas Transmission Maintenance (863) Total Transmission (851, 856, 863) Distribution Operations Supervision and Engineering (870) Mains and Services (874) Meters (878) Misc.(880) Total Distribution Operation (870, 874, 878, 880) Distribution Maintenance Lines --Services and Mains (892) Meters and House Regulators (893) Maintenance of Other Plant (895) Total Distribution Maintenance (892, 893, 895) 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 Supery ison (911) Misc. Selling Expense (916) Total Sales Expense(911, 916) 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) Total Other Expenses (403, 408) TOTAL OPERATING EXPENSES OPERATING INCOME (LOSS) uezauea Income simememi Natural Gas Division 2020 2021 2022 2023 10 31 24 2022 2023 2024 2025 Actual Actual I Actual I Actual I WD Actual Budget I Budget I Budget I Budget $ 6,713,692 $ 8,447,400 $ 8,200,434 $ 7,139,133 $ 4,811,780 '.. $ 7,436,426 $ 7,753,388 $ 7,104,128 $ 7,160,799 $ 3,086,848 $ 4,997,227 $ 5,319,694 $ 4,837,776 $ 3,875,240 '.. $ 4,593,410 $ 5,426,467 $ 5,144,675 $ 5,271,129 $ 1,042,274 $ 1,058,042 $ 1,093,578 $ 1,049,016 $ 1,653,531 '.. $ 1,010,124 $ 1,354,349 $ 2,108,203 $ 2,071,218 $ 665,283 $ 682,550 $ 716,683 $ 719,517 $ 603,833 $ 716,383 $ 719,517 $ 724,600 $ 727,666 $ 11,508,097 $ 15,185,219 $ 15,330,389 $ 13,745,442 $ 10,944,384 '.. $ 13,756,343 $ 15,253,721 $ 15,081,606 $ 15,230,812 $ 12,123 $ 21,606 $ 51,208 $ 52,815 $ 46,093 $ 12,123 $ 21,606 $ 51,208 $ 52,815 $ 46,093 $ 11,520,219 $ 15,206,825 $ 15,381,596 $ 13,798,257 $10,990,477 $ 72,493 $ 56,000 $ 51,000 $ 52,000 $ 72,493 $ 56,000 $ 51,000 $ 52,000 $ 13,828,836 $ 15,309,721 $ 15,132,606 $ 15,282,812 $ 3,295,846 $ 5,832,171 $ 4,863,302 $ 3,505,492 $ 2,782,079 '.. $ 3,971,246 $ 4,307,762 $ 3,563,418 $ 3,321,839 $ 2,292,665 $ 3,998,395 $ 4,493,570 $ 4,129,655 $ 2,781,041 '.. $ 3,658,815 $ 4,396,998 $ 4,177,458 $ 4,328,435 $ 5,588,511 $ 9,830,566 $ 9,356,872 $ 7,635,147 $ 5,563,119 $ 7,630,061 $ 8,704,760 $ 7,740,876 $ 7,650,274 $ 246,894 $ 246,339 $ 317,082 $ 332,750 $ 242,703 '.. $ 307,292 $ 300,398 $ 283,497 $ 319,243 $ 225,190 $ 222,470 $ 205,906 $ 185,702 $ 290,750 '.. $ 273,853 $ 370,932 $ 385,671 $ 256,862 $ 11,234 $ 6,636 $ 19,654 $ 16,944 $ 9,561 '.. $ 403,000 $ 56,045 $ 42,066 $ 40,165 $ 483,317 $ 475,446 $ 542,642 $ 535,396 $ 543,013 ( $ 984,145 $ 727,375 $ 711,235 $ 616,270 $ 337,127 $ 379,876 $ 517,346 $ 506,218 $ 389,383 '.. $ 530,632 $ 532,524 $ 561,378 $ 580,187 $ 192,426 $ 131,216 $ 167,673 $ 173,549 $ 138,507 '.. $ 258,902 $ 285,053 $ 245,918 $ 285,582 $ 9,854 $ 22,988 $ 18,752 $ 21,486 $ 27,843 '.. $ 964 $ 21,023 $ 21,033 $ 91,800 $ 194,982 $ 233,312 $ 197,141 $ 215,055 $ 197,445 '.. $ 295,635 $ 336,923 $ 352,250 $ 252,448 $ 734,390 $ 767,391 $ 900,912 $ 916,309 $ 753,178 ( $ 1,086,134 $ 1,175,523 $ 1,180,579 $ 1,210,017 $ 148,324 $ 141,692 $ 155,849 $ 211,864 $ 240,577 '.. $ 210,725 $ 207,309 $ 195,806 $ 268,036 $ 12,377 $ 15,624 $ 2,794 $ 19,619 $ 17,342 '.. $ 27,952 $ 29,657 $ 44,415 $ 16,545 $ 53,000 $ 59,441 $ 70,518 $ 51,755 $ 77,843 '.. $ 58,500 $ 66,500 $ 61,500 $ 60,500 $ 213,700 $ 216,757 $ 229,161 $ 283,238 $ 335,761 ( $ 297,177 $ 303,467 $ 301,721 $ 345,081 $ 3,656 $ 4,355 $ 4,788 $ 2,686 $ 28,726 '.. $ 22,149 $ 23,500 $ 24,715 $ 6,827 $ 133,722 $ 141,811 $ 152,592 $ 152,959 $ 146,181 '.. $ 143,588 $ 153,085 $ 169,003 $ 179,395 $ 2,175 $ 577 $ 13,214 $ 1,099 $ - '.. $ 4,500 $ 1,000 $ 1,000 $ 1,000 $ 49,982 $ 50,445 $ 51,658 $ 50,283 $ 48,996 '.. $ 58,335 $ 60,666 $ 60,415 $ 40,000 $ 189,534 $ 197,188 $ 222,253 $ 207,027 $ 223,903 N $ 228,571 $ 238,252 $ 255,133 $ 227,222 $ 103,652 $ 104,064 $ 95,224 $ 87,865 $ 79,388 $ 103,652 $ 104,064 $ 95,224 $ 87,865 $ 79,388 $ 169,546 $ 169,114 $ 180,948 $ 189,713 $ 159,219 $ 98,183 $ 80,642 $ 103,552 $ 100,741 $ 92,727 $ 41,079 $ 48,668 $ 43,204 $ 54,949 $ 34,250 $ 50,491 $ 75,553 $ 60,065 $ 69,683 $ 64,758 $ 91,788 $ 75,880 $ 68,878 $ 83,686 $ 70,707 $ 37,077 $ 35,582 $ 43,909 $ 46,742 $ 49,513 $ 47,417 $ 75,523 $ 66,030 $ 59,871 $ 40,250 $ 46,738 $ 31,555 $ 48,378 $ 42,939 $ 21,280 $ 582,320 $ 592,516 $ 614,965 $ 648,325 $ 532,702 $ 166,746 $ 188,412 $ 191,265 $ 192,410 $ 166,746 $ 188,412 $ 191,265 $ 192,410 $ 171,103 $ 183,010 $ 177,511 $ 193,154 $ 95,003 $ 102,776 $ 111,054 $ 121,354 $ 52,332 $ 32,005 $ 35,105 $ 35,969 $ 54,739 $ 57,155 $ 69,638 $ 74,513 $ 72,910 $ 74,270 $ 82,796 $ 83,525 $ 40,000 $ 85,000 $ 60,000 $ 60,000 $ 59,558 $ 65,558 $ 70,728 $ 71,728 $ 48,804 $ 34,425 $ 56,888 $ 46,780 $ 594,447 $ 634,197 $ 663,719 $ 687,023 $ 1,088,555 $ 1,097,263 $ 1,092,249 $ 1,097,315 $ 924,286 '.. $ 1,100,000 $ 1,100,000 $ 1,100,000 $ 1,110,000 $ 573,649 $ 573,649 $ 573,649 $ 585,122 $ 497,354 '.. $ 573,649 $ 585,122 $ 596,824 $ 596,824 $ 1,662,204 $ 1,670,912 $ 1,665,898 $ 1,682,437 $ 1,421,640 I $ 1,673,649 $ 1,685,122 $ 1,696,824 $ 1,706,824 $ 9,557,627 $ 13,854,840 $ 13,627,927 $ 11,995,744 $ 9,452,706 $ 12,660,930 $ 13,657,108 $ 12,741,352 $ 12,635,121 $ 1,962,592 $ 1,351,985 $ 1,753,670 $ 1,802,514 $ 1,537,771 $ 1,167,906 $ 1,652,613 $ 2,391,255 $ 2,647,691 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) NET INCOME COGS Gross Profit Gross Margin Operating Margin (%) Net Income (%) of Operating Sales Net Income (%) of Operating Sales (after cap labor) uezauea Income siwememi Natural Gas Division 2020 2021 2022 2023 10 31 24 2022 2023 2024 2025 Actual Actual I Actual I Actual I WD Actual Budget I Budget I Budget I Budget $ 97,645 $ 1,632 $ 36,238 $ 29,060 $ 21,346 '.. $ 500 $ 500 $ (12,000) $ (13,500) $ 368,961 $ 21,954 $ (439,453) $ 677,152 $ 400,502 '.. $ 175,000 $ 250,000 $ 375,000 $ 300,000 $ 19,071 $ 56,263 $ 31,442 $ 36,134 $ 772,562 '.. $ - $ 22,426 $ 23,515 $ 25,106 $ 185,608 $ 185,608 $ 185,608 $ 185,608 $ 154,674 '.. $ 185,608 $ 185,608 $ 185,608 $ 185,608 $ (536,475) $ (477,908) $ (413,662) $ (329,463) $ (232,433) '.... $ (420,550) $ (334,050) $ (279,620) $ (203,475) $ (2,388) $ (124) $ (228) $ (5,278) $ (882) '... $ (100) $ (100) $ (300) $ (800) $ 23,458 $ 48,168 $ - $ - $ ''.... $ $ $ $ $ 155,880 $ (164,407) $ (600,055) $ 593,214 $ 1,115,769 ',.... $ (59,542) $ 124,384 $ 292,203 $ 292,939 $ 2,118,472 $ 1,187,578 $ 1,153,614 $ 2,395,727 $ 2,653,540 '... $ 1,108,365 $ 1,776,998 $ 2,683,458 $ 2,940,631 $ 6,071,828 $ 10,306,012 $ 9,899,514 $ 8,170,543 $ 6,106,133 $ 8,614,206 $ 9,432,135 $ 8,452,111 $ 8,266,544 $ 5,448,391 $ 4,900,813 $ 5,482,083 $ 5,627,714 $ 4,884,344 $ 5,214,630 $ 5,877,586 $ 6,680,496 $ 7,016,268 47% 32% 36% 41% 44% 38% 38% 44% 46% 17% 9% 11% 13% 14% 8% 11% 16% 17% 18% 8% 7% 17% 24% 8% 12% 18% 19% - - 9% 9% 12% 19% NET INCOME 2025 Net Income $ 2,940,631 Cap. Labor - Nat. Gas $ 18,500 2025 Net Income $ 2,959,131 CASH FLOW STATEMENT 2025 Net Income $ 2,940,631 Depreciation $ 1,110,000 Bond Premium $ (185,608) 2024 Cap Exp $ (392,500) 2012A Principal $ (1,895,000) 2025 Cash Flow $ 1,577,523 Hutchinson Utilities Commission Capital l r° vPlan 2025 thru 2029 PROJECT COSTS BY DEPARTMENT Department Electric - Production Electric - Distribution Electric - Transmission Electric - Fleet, Misc. Equipment Electric Division Subtotal Natural Gas - Distribution Natural Gas - Transfnission Natural Gas - Fleet, Misc. Equirunent Natural Gas Division Subtotal 2025 2026 2027 2028 $ 717,000 $ 622,865 $ 560,000 $ 325,000 $ 770,000 595,000 575,000 555,000 165,000 15,000 25,000 15,000 2029 210,000 570,000 15,000 - 240,000 305,000 530,000 180,000 1,652,000 1,472,865 1,465,000 1,425,000 975,000 423,000 423,500 407,500 317,000 312,200 8,500 - - - - 431,500 423,500 407,500 317,000 312,200 r----------------------0 0 GRAND TOTAL ____________0 $ 2,083,500 $ 1,896,365 $ 1,872,500 $ 1,742,000 $ 1,287,200 SUMMARY OF FUNDING SOURCES Department 2025 2026 2027 2028 2029 Capital Replacement Reserves $ 2,083,500 $ 1,656,365 $ 1,567,500 $ 1,212,000 $ 1,107,200 Fleet Designated Reserves- 240,000 305,000 530,000 180,000 ------------------------ _GRAND TOTAL ____________0 $ 2,083,500 $ 1,896,365 $ 1,872,500 $ 1,742,000 $ 1,287,200 Electric Production Capital Projects Electric Production Capital Expenditure Programming Account # 2025 2026 2027 2028 2029 Totals 340 $ - $ - $ - $ - $ - $ - 341 $ 117,000 $ 281,000 $ 560,000 $ 325,000 $ 210,000 $ 1,493,000 342 $ - $ 78,000 $ - $ - $ - $ 78,000 343 $ - $ - $ $ $ $ - 344 $ 420,000 $ - $ $ $ $ 420,000 345 $ 180,000 $ 263,865 $ $ $ $ 443,865 346 $ Is Is Is Is $ Totals 717,000 622,865 560,0001 $ 325,000 210,0001 $ 2,434,865 Production Capital Acct # Project List Material Labor Total 340 $ $ $ $ $ $ Total Account 340 Plant 1 - Tuck Pointing Phase III $ 40,000 $ $ 40,000 Rubber Roof Repairs - West portion of Plant 1 $ 42,000 $ $ 42,000 341 Plant 1 Pump Room Ventilation $ 30,000 $ 5,000 $ 35,000 $ 112,000 $ 5,000 $ 117,000 Total Account 341 342 $ $ $ $ $ $ Total Account 342 343 $ $ $ $ $ $ - Total Account 343 SWOIS Computer Upgrade U5 ($513,000) $ 300,000 $ $ 300,000 344 Plant 1 Control Panel Upgrade Unit 1 CO2 System Update Code Compliance $ 80,000 $ 20,000 $ 20,000 $ - $ 100,000 $ 20,000 $ 400,000 $ 20,000 $ 420,000 Total Account 344 345 Cooling Tower Recirculation and Chemical Injection Plant 1 North Ground Fans $ 130,000 $ 50,000 $ $ $ 130,000 $ 50,000 $ 180,000 $ $ 180,000 Total Account 345 346 $ $ $ $ - $ $ - Total Account 346 Total Production Capital Budget 2025 692,000 25,000 717,000 Production Capital Budget 2026 Acct # Project List Material Labor Total 340 $ $ $ $ $ $ Total Account 340 341 Plant 1 Camera System $ $ 100,000 $ $ $ $ 100,000 Plant 2 Cooling Tower Repair $ 181,000 $ $ 181,000 $ 281,000 $ $ 281,000 Total Account 341 Unit 5 Hug Controller Upgrade $ 78,000 $ $ 78,000 342 $ - $ $ - $ 78,000 $ $ 78,000 Total Account 342 343 $ $ $ $ $ $ Total Account 343 344 $ $ $ $ $ $ - Total Account 344 Plant 2 Automatic Valves - Cooling Tower $ 90,000 $ $ 90,000 345 Aux Boiler Feed Water and Piping Update $ 173,865 $ $ 173,865 $ 263,865 $ $ 263,865 Total Account 345 346 $ $ $ $ $ $ - Total Account 346 Total Production Capital Budget 2026 622,865 622,865 Electric Production Capital Projects Production Capital Budget 2027 Acct # Project List Material Labor Total 340 Total Account 340 $ $ $ $ - $ $ 341 Unit 1 Boiler House Building Repair New Roof Switch Gear Building 4160 Cooling Tower Drain Valves Plant 1 Side Stream Filter Building and Chemical Injection Total Account 341 $ 150,000 $ 60,000 $ 80,000 $ 250,000 $ $ 20,000 $ - $ $ 150,000 $ 80,000 $ 80,000 $ 250,000 $ 540,000 $ 20,000 $ 560,000 342 Total Account 342 $ $ $ 343 Total Account 343 $ $ $ 344 Total Account 344 $ $ $ 345 Total Account 345 $ $ $ 346 Total Account 346 $ $ $ - Total Production Capital Budget 2027 540,000 20,000 560,000 Production Capital Acct # Project List Material Labor Total 340 Total Account 340 $ $ $ $ $ $ 341 Plant 2 Parking Lot Repair New Roof Switch Gear Building (Sub -Stations) Total Account 341 $ 175,000 $ 140,000 $ $ 10,000 $ 175,000 $ 150,000 $ 315,000 $ 10,000 $ 325,000 342 Total Account 342 $ $ $ $ $ $ 343 Total Account 343 $ $ $ $ $ $ 344 Total Account 344 $ $ $ $ $ $ 345 Total Account 345 $ $ $ $ $ $ 346 Total Account 346 $ $ $ $ $ $ - Total Production Capital Budget 2028 is 315,000 10,000 325,000 Production Capital Budget 2029 Acct # Project List Material Labor Total 340 Total Account 340 $ $ $ $ $ $ 341 New Roof Switch Gear Building (Sub -Stations) Power Gates Plant 2 Total Account 341 $ 140,000 $ 70,000 $ $ $ 140,000 $ 70,000 $ 210,000 $ $ 210,000 342 Total Account 342 $ $ $ $ $ $ 343 Total Account 343 $ $ $ $ $ $ 344 Total Account 344 $ $ $ $ $ $ 345 Total Account 345 $ $ $ $ $ $ 346 Total Account 346 $ $ $ $ $ $ - Total Production Capital Budget 2029 210,0001$ 1 $ 210,000 Electric Distribution Capital Projects Electric Distribution Capital Expenditure Programming Account # Total 2025 2026 2027 2028 2029 360 $ $ $ $ $ $ 361 $ $ $ $ $ $ 362 $ 195,000 $ $ 30,000 $ 10,000 $ 10,000 $ 245,000 364 $ - $ $ - $ - $ - $ - 365 $ - $ $ - $ - $ 15,000 $ 15,000 366 $ 83,000 $ 83,000 $ 83,000 $ 83,000 $ 83,000 $ 415,000 367 $ 75,000 $ 125,000 $ 75,000 $ 75,000 $ 75,000 $ 425,000 368 $ 140,000 $ 140,000 $ 140,000 $ 140,000 $ 140,000 $ 700,000 369 $ - $ - $ - $ - $ - $ - 370 $ 66,000 $ 36,000 $ 36,000 $ 36,000 $ 36,000 $ 210,000 371 $ 1,000 $ 1,000 $ 1,000 $ 1,000 $ 1,000 $ 5,000 373 1 $ 210, 000 $ 210, 000 $ 210, 000 $ 210, 000 $ 210, 000 $ 11050000 Total 770,0001 $ 595,0001 $ 575,0001 $ 555,0001 $ 570,000 3,065,000 ELECTRIC DISTRIBUTION PLANT 2025 Acct # Project List Material Labor Total 360 $ $ $ 361 $ $ $ 362 Station Equipment Plant #1 Sub - Circuit Breakers Plant #1 Sub - Engineering - Willmar Line Total Account 362 $ $ $ 10,000 110,000 75,000 $ $ $ $ $ $ 10,000 110,000 75,000 $ 195,000 $ $ 195,000 364 Total account 364 $ $ $ $ $ $ 365 Right of way Clearing $ $ $ - 366 Install Duct $ 18,000 $ 65,000 $ 83,000 367 New Developments Total account 367 $ $ 60,000 $ $ 15,000 $ $ 75,000 $ 60,000 $ 15,000 $ 75,000 368 Transformer Replacements Transformer New Developments Total Account 368 $ $ 50,000 60,000 $ $ 15,000 15,000 $ $ 65,000 75,000 $ 110,000 $ 30,000 $ 140,000 369 $ - $ - $ - 370 Meters Meter Testing Equipment Total Account 370 $ $ 36,000 30,000 $ $ $ $ 36,000 30,000 $ 66,000 $ $ 66,000 371 Installation on Customer Premises (Security Lights) $ 1,000 $ $ 1,000 373 LED Street Light Conversion Total Account 373 $ 175,000 $ 35,000 $ 210,000 $ 175,000 $ 35,000 $ 210,000 Total Electric Distribution Capital Budget 2025 625,0001$ 145,0001$ 770,000 Electric Distribution Capital Projects Acct # ELECTRIC DISTRIBUTION PLANT Project List Material 2026 Labor Total 360 $ $ $ 361 $ $ $ 362 Total Account 362 $ $ $ $ $ $ $ $ $ 364 $ $ $ 365 Right of way Clearing $ $ $ 366 Install Duct $ 18,000 $ 65,000 $ 83,000 367 Energy Park Total account 367 $ $ 90,000 $ $ 35,000 $ $ 125,000 $ 90,000 $ 35,000 $ 125,000 368 Transformer Replacements Transformer New Developments Total Account 368 $ $ 50,000 60,000 $ $ 15,000 15,000 $ $ 65,000 75,000 $ 110,000 $ 30,000 $ 140,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 Street Light Conversion $ 175,000 $ 35,000 $ 210,000 Iotal Electric Distribution Capital Budget 2026 $ 430,000 $ 165,000 $ 595,000 Acct # DISTRIBUTIONELECTRIC Project List Material Labor Total 360 $ - $ $ 361 $ $ - 362 Station Equipment 3M/Plant #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 $ $ - 15,000 $ $ - 75,000 $ 60,000 $ 15,000 $ 75,000 368 Transformer Replacements Transformer New Developments Total Account 368 $ $ 50,000 60,000 $ $ 15,000 15,000 $ $ 65,000 75,000 $ 110,000 $ 30,000 $ 140,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 Street Light Conversion $ 175,000 $ 35,000 $ 210,000 Total Electric Distribution Capital Budget 2021 ols 145,OUO 1 $ 515,05ir Electric Distribution Capital Projects ELECTRIC DISTRIBUTION PLANT 2028 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 $ $ - 15,000 $ $ - 75,000 $ 60,000 $ 15,000 $ 75,000 368 Transformer Replacements Transformer New Developments Total Account 368 $ $ 50,000 60,000 $ $ 15,000 15,000 $ $ 65,000 75,000 $ 110,000 $ 30,000 $ 140,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 Street Light Conversion $ 175,000 $ 35,000 $ 210,000 otal Electric Distribution Capital Budget 2028 $ 410,0001$ 145,000 $ 555,000 DISTRIBUTIONELECTRIC Acct # Project List Material Labor Total 360 $ $ $ 361 $ $ $ 362 Station Equipment $ $ 10,000 $ $ $ $ 10,000 $ 10,000 $ $ 10,000 Total Account 362 364 $ $ $ 365 Right of way Clearing $ 15,000 $ $ 15,000 366 Install Duct $ 18,000 $ 65,000 $ 83,000 367 New Developments $ $ - 60,000 $ $ - 15,000 $ $ - 75,000 $ 60,000 $ 15,000 $ 75,000 Total account 367 Transformer Replacements $ 50,000 $ 15,000 $ 65,000 368 Transformer New Developments $ 60,000 $ 15,000 $ 75,000 $ 110,000 $ 30,000 $ 140,000 Total Account 368 369 $ - $ - $ - 370 Meters $ 36,000 $ $ 36,000 $ 36,000 $ $ 36,000 Total Account 370 371 Installation on Customer Premises (Security Lights) $ 1,000 $ $ 1,000 373 LED Street Light Conversion $ 175,000 $ 35,000 $ 210,000 $ 175,000 $ 35,000 $ 210,000 Total account 373 Total Electric Distribution Capital Budget 2029 425,000 145,000 570,000 Electric Transmission Capital Projects Electric Transmission Capital Expenditure Programming 2025 2026 2027 2028 2029 Account # Totals 350 $ $ $ $ $ $ 352 $ $ $ $ $ $ 353 $ 150,000 $ $ 10,000 $ $ $ 160,000 354 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 75,000 355 $ - $ - $ - $ - $ - $ - 356 $ $ $ $ $ $ 357 $ $ $ $ $ $ 358 $ $ $ $ $ $ - Total $ 165,000 $ 15,000 3 25,000 $ 15,000 $ 15,000 $ 235,000 TRANSMISSIONELECTRIC i Acct# Project List Material Labor Total 350 $ $ $ 352 $ $ $ 353 McLeod Sub Relay Replacement Total Account 353 $ 150,000 $ $ $ $ $ $ 150,000 $ $ $ 150,000 $ $ 150,000 354 Pole Repair or Replacement $ 15,000 $ $ 15,000 355 $ $ $ - 356 $ $ $ 357 $ $ $ 358 $ $ $ i i i i TRANSMISSIONELECTRIC i Acct# Project List Material Labor Total 350 $ $ $ 352 $ $ $ 353 Total Account 353 $ $ $ $ $ $ $ $ $ - 354 Pole Repair Replacement $ 15,000 $ $ 15,000 355 $ $ $ - 356 $ $ $ 357 $ $ $ 358 $ $ $ i WWWWWW7777777777=1i TRANSMISSIONELECTRIC i 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 Replacement $ 15,000 $ $ 15,000 355 $ $ $ - 356 $ $ $ 357 $ $ $ 358 $ $ $ 1777=,i i TRANSMISSIONELECTRIC i Acct# Project List Material Labor Total 350 $ $ $ 352 $ $ $ 353 Total Account 353 $ $ $ $ $ $ - 354 Pole Repair Replacment $ 15,000 $ $ 15,000 355 $ $ $ - 356 $ $ $ 357 $ $ $ 358 $ $ $ i i i Electric Transmission Capital Projects ELECTRIC TRANSMISSION PLANT 2029 Acct# Project List Material Labor Total 350 $ $ $ 352 $ $ $ 353 Total Account 353 $ $ $ $ $ $ - 354 Pole Repair Replacment $ 15,000 $ $ 15,000 $ $ $ - $ $ $ E $ $ $ $ $ $ 0777777, i Electric Fleet, Misc Equipment Fleet, Misc. Equipment Capital Expenditure Programming 2025 2026 2027 2028 2029 Account # I Totals 389 $ $ $ $ $ $ 390 $ $ $ $ $ $ 391 $ $ $ $ $ $ 392 $ $ 240,000 $ 305,000 $ 60,000 $ 125,000 $ 730,000 393 $ $ - $ - $ - $ - $ - 394 $ $ $ $ $ $ 395 $ $ $ $ $ $ - 396 $ $ $ $ 350,000 $ 40,000 $ 390,000 397 $ $ $ $ - $ - $ - 399 $ $ $ $ - $ - $ Administrative 2025 Acct # Project List Electric Gas Total 389 $ $ $ 390 $ $ $ 391 Total Account 391 $ $ $ $ $ $ 392 Total Account 392 $ $ $ $ $ $ 393 Total Account 393 $ $ $ $ $ 394 Total Account 394 $ $ $ $ $ $ 395 $ $ $ 396 $ $ $ 397 $ $ $ E399 $ Is Is Administrative 2026 Acct # Project List Electric Gas Total 389 $ $ $ 390 $ $ $ 391 Total Account 391 $ $ $ $ $ $ - 392 Small Bucket Truck Total Account 392 $ 240,000 $ $ $ $ 240,000 $ $ 240,000 $ $ 240,000 393 Total Account 393 $ $ $ $ $ $ 394 Total Account 394 $ $ $ $ $ $ 395 $ $ $ 396 $ $ $ 397 $ $ $ 399 $ $ $ Electric Fleet, Misc Equipment Administrative 2027 Acct # Project List Electric Gas Total 389 $ $ $ 390 $ $ $ 391 Total Account 391 $ $ $ $ $ $ 392 Small Bucket Truck Metering Van Total Account 392 $ $ 240,000 $ 65,000 $ $ $ $ $ 240,000 $ 65,000 $ 305,000 $ $ 305,000 393 Total Account 393 $ $ $ $ $ $ 394 Total Account 394 $ $ $ $ $ $ 395 $ $ $ 396 $ $ $ 397 $ $ $ 399 $ $ $ Administrative 2028 Acct # Project List Electric Gas Total 389 $ $ $ 390 $ $ $ 391 Total Account 391 $ $ $ $ $ $ 392 2014 GMC Sierra 4WD Ext Cab TRK 818 Total Account 392 $ $ 60,000 $ $ $ $ 60,000 $ 60,000 $ $ 60,000 393 Total Account 393 $ $ $ $ $ $ 394 Total Account 394 $ $ $ $ $ $ 395 $ - $ $ - 396 Vacuum Excavation Machine Directional Drill Total Account 396 $ 120,000 $ 350,000 $ $ $ 120,000 $ 350,000 $ 470,000 $ 470,000 397 $ - $ $ - 399 $ $ $ General Plant 2029 Acct # Project List Electric Gas Total 389 $ $ $ 390 $ $ $ 391 Total Account 391 $ $ $ $ $ $ 392 Chevy Bolt Service Truck #141 Total Account 392 $ 40,000 $ 85,000 $ $ $ 40,000 $ 85,000 $ 125,000 $ $ 125,000 393 Total Account 393 $ $ $ $ $ $ 394 Total Account 394 $ $ $ $ $ $ 395 $ - $ $ - 396 Air Compressor Bobcat Skid Steer Total Account 396 $ 15,000 $ 40,000 $ $ $ 15,000 $ 40,000 $ 55,000 $ $ 55,000 397 $ - $ $ - 399 $ $ $ Natural Gas Distribution Capital Projects Gas Distribution Capital Expenditure Programming Totals 2025 i 2026 2027 2028 2029 Account# 376 $ 39,000 $ 39,000 $ 21,500 $ 19,000 $ 15,000 $ 133,500 378 $ 23,500 $ 23,500 $ 25,000 $ 18,000 $ - $ 90,000 379 $ - $ - $ - $ - $ - $ - 380 $ 72,000 $ 72,500 $ 72,500 $ 70,000 $ 87,200 $ 374,200 381 $ 260,000 $ 260,000 $ 260,000 $ 210,000 $ 210,000 $ 1,200,000 383 $ - $ - $ - $ - $ - $ - 385 $ 28,500 $ 28,500 $ 28,500 $ $ $ 85,500 386 $ - $ - $ - $ $ $ - 387 $ $ $ $ $ $ Total is 423,000 $ 423,500 1 $ 407,500 $ 317,000 $ 312,200 1 $ '+ 1,883,200 GAS DISTRIBUTIONPLANT 2025 Acct # Project List Material Labor Total 376 376 Misc Developments & System Improvements City Projects Total $ 25,000 $ 7,000 $ 5,000 $ 2,000 $ 30,000 $ 9,000 $ 32,000 $ 7,000 $ 39,000 378 Improvements to Regulator Stations Total $ 20,000 $ 3,500 $ 23,500 $ 20,000 $ 3,500 $ 23,500 379 $ - $ - $ - 380 Service Lines $ 57,000 $ 15,000 $ 72,000 381 Meters, AMI and All Fittings $ 250,000 $ 10,000 $ 260,000 383 Residential Regulators $ - $ - $ - 385 Industrial Metering and Regulation $ 25,000 $ 3,500 $ 28,500 386 $ - $ - $ - 387 $ - $ - $ - Total Gas Distribution Capital Budget 2025 $ 384,000 $ 39,000 $ 423,000 GAS DISTRIBUTIONPLANT 2026 Acct # Project List Material Labor Total 376 Misc Developments & System Improvements City Projects Total $ 25,000 $ 7,000 $ 5,000 $ 2,000 $ 30,000 $ 9,000 $ 32,000 $ 7,000 $ 39,000 378 Improvements to Regulator Stations $ 20,000 $ 3,500 $ 23,500 379 $ - $ - $ - 380 Service Lines $ 57,500 $ 15,000 $ 72,500 381 Meters, AMI and All Fittings, Replace AMI Modules $ 250,000 $ 10,000 $ 260,000 383 $ - $ - $ - 385 Industrial Metering and Regulation $ 25,000 $ 3,500 $ 28,500 386 $ - $ - $ - 387 $ - $ - $ - Total Gas Distribution Capital Budget 2026 is 384,500 $ 39,000 $ 423,500 GAS DISTRIBUTIONPLANT 2027 Acct # Project List Material Labor Total 376 Misc. Developments & System Improvements City Projects Total $ 10,000 $ 7,000 $ 2,500 $ 2,000 $ 12,500 $ 9,000 $ 17,000 $ 4,500 $ 21,500 378 Improvements to Regulator Stations $ 20,000 $ 5,000 $ 25,000 379 $ - $ - $ - 380 Service Lines $ 57,500 $ 15,000 $ 72,500 381 Meters, AMI and All Fittings, Replacment AMI Modules $ 250,000 $ 10,000 $ 260,000 383 $ - $ - $ - 385 Industrial Metering and Regulation $ 25,000 $ 3,500 $ 28,500 386 $ - $ - $ - 387 $ - $ - $ - Total Gas Distribution Capital Budget 2027 is 369,500 $ 38,000 $ 407,500 Natural Gas Distribution Capital Projects GAS DISTRIBUTIONPLANT 2028 Acct # Project List Material Labor Total 376 Misc. Developments & System Improvements City Projects Total 1 $ 10,000 $ 5,000 $ 2,500 $ 1,500 $ 12,500 $ 6,500 $ 15,000 $ 4,000 $ 19,000 378 Improvements to Regulator Stations $ 15,000 $ 3,000 $ 18,000 379 $ - $ - $ - 380 Service Lines $ 55,000 $ 15,000 $ 70,000 381 Meters, AMI and All Fittings, Replacement AMI Modules $ 200,000 $ 10,000 $ 210,000 383 $ - $ - $ - 385 $ $ $ 386 $ $ $ 387 $ $ $ - Total Gas Distribution Capital Budget 2028 $ 285,000 $ 32,000 $ 317-000 GAS DISTRIBUTIONPLANT 2029 Acct # Project List Material Labor Total 376 Misc. Developments & System Improvements City Projects Total $ 10,000 $ 2,000 $ 2,500 $ 500 $ 12,500 $ 2,500 $ 12,000 $ 3,000 $ 15,000 378 $ - $ - $ - 379 $ - $ - $ - 380 Service Lines $ 55,000 $ 32,200 $ 87,200 381 Meters, AMI and All Fittings, Replacement AMI Modules $ 200,000 $ 10,000 $ 210,000 383 $ - $ - $ - 385 $ $ $ 386 $ $ $ 387 $ $ $ - Total Gas Distribution Capital Budget 2029 is 267,000 1 $ 45,200 1 $ 312,200 Natural Gas Transmission Capital Projects Gas Transmission Capital Expenditure Programming Totals 2025 2026 2027 2028 2029 Account# 365 $ $ $: $ $ $ 366 $ $ $ $ $ $ 367 $ $ $ $ $ $ 368 $ $ $ $ $ $ 369 $ $ $ $ $ $ 370 $ $ $ $ $ $ - 371 $ 8,500 1 $ $ $ $ $ 8,500 Total is 8,500 is! -is ' -is - -is - $ 8,500 ! GAS TRANSMISSION PLANT 2025 Acct # Project List Material Labor Total 365-0100 $ $ $ 366-0100 $ $ $ 367-0100 $ $ $ 368-0100 $ $ $ 369-0100 Total $ $ $ $ $ $ 370-0100 Total $ $ $ $ $ $ 371-0100 Transmitter calibration equipment - HART Communicator $ 8,500 $ $ 8,500 Total Gas Transmission Capital Budget 2025 $ 8,500 $ $ 8,500 GAS TRANSMISSION PLANT 2026 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 2026 1 $ $ $ GAS TRANSMISSION PLANT 2027 Acct # Material Labor Total 365 $ $ $ 366 $ $ $ 367 $ $ $ 368 $ $ $ 369 $ $ $ 370 $ $ $ 371 $ $ $ Total Gas Transmission Capital Budget 2027 $ $ $ GAS TRANSMISSION PLANT 2028 Acct # Project List Material Labor Total 365 $ $ $ 366 $ $ $ 367 $ $ $ 368 $ $ $ 369 $ $ $ 370 $ $ $ 371 $ $ $ Total Gas Transmission Capital Budget 2028 1 $ $ $ Natural Gas Transmission Capital Projects GAS TRANSMISSION PLANT 2029 Acct # Project List Material Labor Total 365 $ $ $ 366 $ $ $ 367 $ $ $ 368 $ $ $ 369 $ $ $ 370 $ $ $ 371 $ $ $ Total Gas Transmission Capital Budget 2029 $ $ $ Natural Gas Fleet, Misc Equipment Account # Administration Capital Expenditure programming Totals 2025 2026 2027 2028 2029 389 $ $ $ $ $ $ 390 $ $ $ $ $ $ 391 $ $ $ $ $ $ 392 $ $ $ $ $ $ 393 $ $ $ $ $ $ 394 $ $ $ $ $ $ 395 $ $ $ $ $ $ 396 $ $ $ $ $ $ 397 $ $ $ $ $ $ - Total ' $ - $ - ' is - $ - $ - $ - ADMINISTRATION 2025 Acct # Project List Electric Natural Gas Total 392 Replace Vehicle 451- 2005 Welding Truck (Per Schedule) Annual Vehicle Budget $ $ $ $ $ $ $ - $ - $ - 393 Total Account 393 $ $ $ $ - $ - $ - 394 Total Account 394 $ $ $ $ - $ - $ - Total Adniinistrution Capital Budget 2025 $ $ $ ADMINISTRATION 2026 Acct # Project List Electric Natural Gas Total $ $ $ 389 Total Acccount 389 $ - $ - $ - 390 $ $ $ $ - $ - $ - Total Account 390 $ $ $ 391 Total Account 391 $ - $ - $ - Replace Vehicle 451- 2005 Welding Truck (Per Schedule) $ $ $ 392 $ $ $ $ - $ - $ - Total Account 392 $ $ $ 393 Total Account 393 $ - $ - $ - $ $ $ 397 Total Account 397 $ - $ - $ - Total Adniinistrution Capital Budget 2026 $ $ $ ADMINISTRATION 2027 Acct # Project List Electric Natural Gas Total $ $ $ 389 Total Acccount 389 $ - $ - $ - $ $ $ 390 Total Account 390 $ - $ - $ - $ $ $ 391 Total Account 391 $ - $ - $ - 392 $ $ $ $ - $ - $ - Total Account 392 393 $ $ $ $ - $ - $ - Total Account 393 $ $ $ 394 Total Account 394 $ - $ - $ - $ $ $ 395 Total Account 395 $ - $ - $ - Total Adniinistrution Capital Budget 2027 $ $ $ Natural Gas Fleet, Misc Equipment ADMINISTRATION 2028 Acct # Project List Electric Natural Gas Total 392 Total Acccount 389 $ $ $ $ - $ - $ - 394 Total Account390 $ $ $ $ - $ - $ - 395 Total Account391 $ $ $ $ - $ - $ - Total Administration Capital Budget 2028 $ $ $ ADMINISTRATION 2029 Acct # Project List Electric Natural Gas Total 392 Total Acccount 389 $ $ - $ $ - $ $ - 394 Total Account390 $ $ $ $ - $ - $ - 395 Total Account391 $ $ $ $ - $ - $ - Total Administration Capital Budget 2029 $ $ $