The URL can be used to link to this page

12-20-2017 HUCCPHUTCHINSON UTILITIES COMMISSION AGENDA REGULAR MEETING December 20, 2017 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. Legal d. General Manager 6. POLICIES a. Review Policies i. Purpose of this Handbook ii. Surplus Property Policy (every 3 years) b. Approve Changes i. Section 1 — Introduction ii. Definitions iii. Payments of HUC Payables 7. UNFINISHED BUSINESS a. Update on Pack Gas Discussions 8. NEW BUSINESS a. Approve 2018 Budget b. Approve Moving 2018 Pay Grid C. Conduct the Performance Review of Hutchinson Utilities Commission General Manager Pursuant to Minnesota Statute 13D.05 Subd. 3(a) 9. ADJOURN MINUTES Regular Meeting — Hutchinson Utilities Commission Wednesday, November 29, 2017 Call to Order — 3:00 p.m. President Monty Morrow called the meeting to order at 3:00 p.m. Members present: President Monty Morrow; Vice President Anthony Hanson; Secretary Mark Girard; Commissioner Robert Wendorff; and Commissioner Don Martinez. Others present: General Manager Jeremy Carter; Attorney Marc Sebora. 1. Conflict of Interest There were no conflicts of interest noted. 2. Approve Consent Agenda a. Approve Minutes b. Ratify Payment of Bills Motion by Commissioner Wendorff, second by Commissioner Girard to approve the Consent Agenda. Motion carried unanimously. 3. Approve Financial Statements General Manager Carter and Jared Martig presented the financial statements. General Manager Carter noted that for Combined Divisions we are running similar. October was a mild month. Electric Division was down in usage; 2017 was the lowest it has been in a couple of years. Gas Division on the other hand is up. Transalta through October is running 10% margin on sales compared to 2016 at 12- 13%. HUC also generated more of the sales through October 2017 versus 2016. Power cost adjustment for October was higher than normal. There was a lot of timing issues; higher than normal admin fees, and we had 5 Tuesdays in October which is the weekly day MISO bills HUC. Everything is trending as expected in the Gas Division. General Manager Carter pointed out that on the Cash designation report there is one typo error. The `Change in Cash Balance' date should be 10/31 and not 9/30. Motion by Commissioner Hanson, second by Commissioner Martinez to approve the financial statements. Motion carried unanimously. 4. Open Forum -none 5. Communication a. City Administrator— Matt Jaunich i. Mr. Jaunich communicated that the City is in the middle of budget. ii. Hotel is still planning to start this year. They are planning on moving dirt this week or next. b. Divisions i. Dan Lang, Engineering Services Manager —nothing to report ii. Dave Hunstad, Electric Transmission/Distribution Manager — all 2017 projects are completed. We are now working on miscellaneous items. iii. Randy Blake, Production Manager — Continuing to work on Generator 6 & 7. On the Work Orders, we decided to push back Plant 1 Alarm Panel Upgrade to add 6 & 7 alarms. Wanted to tell the Commission Board that I really appreciate the Commission recognizing us employees. I have been here for 40 years. President Morrow, Congratulated Randy on his years of service. President Morrow asked Randy how it is to work with CAT. Mr. Blake answered that is going very well and they are easy to work with. HDR has been great to work with also. iv. John Webster, Natural Gas Division Manager -DOT Final Protocol finished this week. Prepaid moving forward, hope to complete in Feb v. Jared Martig, Financial Manager —billing went off well this month. c. Brenda Ewing, Human Resources — Nothing to report d. Legal — Marc Sebora —Update on Pack Gas, I was finally able to make contact with Heartland, and they are having a meeting tomorrow to discuss entering into the agreement. There may be slight verbiage changes but the dollar amount originally discussed would stay the same, hopefully there will be a resolution soon. President Morrow thanked Marc for all the time he has been putting in to this. Commissioner Hanson inquired about City of New Ulm's agreement. Marc replied that agreement is finalized and payment has been received. e. General Manager — Jeremy Carter i. We have been working on our Recognition party for next Friday. ii. Working through Insurance. iii. Following up on Cost of Service study. Should have information next week. Once I have the information I will distribute. Both divisions are looking good from a financial position. iv. When we get in winter months, customers fall in to hard times. We now have 5 agencies in our area to help with assistance. Ladies up front updated the list; Crosspoint is now added to help with assistance. v. Provided Matt Jaunich with revised information on PILOT. He will talk to sub- committee and a follow-up meeting will be scheduled in December. e. Policies a. Review Policies i. Appendix A - Acknowledgement ii. Appendix B — New Employee Acknowledgement iii. Appendix C — Temporary Employee Acknowledgement iv. Appendix D - Acknowledgement v. Landlord Acknowledgement vi. Inserts with Utility Bills vii. Financial Reserve Policy b. Approve Changes 2 After Hours Reconnection Policy —as noted. Commissioner Hanson inquired if our payment options are available on tablets. General Manager Carter confirmed yes. Customers can go to our website and make a payment from any mobile device. Motion by Commissioner Girard, second by Commissioner Martinez, to approve the policy changes as recommended. Motion carried unanimously. f. Unfinished Business a. Update of Pack Gas Discussions General Manager Carter noted there is no new information to report at this time besides what Marc mentioned above. g. New Business a. Approve Charge-offs Mr. Carter and Mr. Martig discussed the Approval of Charge -Offs. This is higher than in past, our collection agency went out of business. We do not feel that we get enough money back to look for a new company. Commissioner Martinez questioned; nothing we could go for businesses to litigate? Mr. Martig replied no. Commissioner Hanson inquired from a collection standpoint is there anything new we should look at. Mr. Carter noted there is Revenue Recapture, if we get personal information, such as social security numbers, however customers are not legally obligated to provide HUC that information. People are getting numb to return calls or calls from collection agencies. Collection agency collections are significantly lower than in years past. We can change our policy with the deposits, and keep deposits on hand longer. However, we may hear customer feedback on that. If customers are good on paying, after a certain period HUC refunds the deposit. However, the policy could be changed to keep a deposit indefinite since we are invoicing and collecting revenue after the fact expenses have already been paid. There are many tenants that skip out on the landlord. Mr. Sebora commented that this has not been our practice but we are able to take people to small claims court, however the commission needs to decide. If we get judgement, we can force people to give us personal information. Mr. Martinez inquired if we normally carry out 8 years. Mr. Martig replied that it is normally 6 years, but some of these have been sitting at collection agencies. Mr. Carter added we keep these on in case money comes in. We can write these off earlier. Mr. Sebora added 6 years is Statute of Limitations. After much discussion, it was decided if there are any other thoughts to please let Mr. Carter know. Mr. Carter noted that we are always willing to look at other options. Motion by Commissioner Martinez, second by Commissioner Wendorff, to approve the Charge-offs. Motion carried unanimously. b. Discuss 2018 Budget 3 Mr. Carter spoke about the 2018 Budget. Mr. Carter highlighted for Combined Divisions, Revenues are at $40.2m with a Net Profit of $1.1 m. Would like to point out that the estimating number for Retail Customer Sales could be a little conservative. We added $200k to our Sales for Resales over the 2017 Budget; this is now at $2.5m. We are reducing our energy contract sales $192k. Mr. Carter continued to highlight that Other Revenues includes late fees, penalties and interest earnings. Commissioner Hanson inquired about the power cost adjustment; is this something you recommend to do again. Mr. Carter replied yes. Mr. Carter asked if there are any questions. We fluctuate on usage and market cost but otherwise consistent. Mr. Carter reviewed the Graphical layout for the Electric Division Revenues. Mr. Carter spoke on the Electric Division Expense Budget Highlights. We did allocate 1 FTE to the production area. There is a lot going on and we are starting to fall behind. We had a few different proposals for insurance. We decided to go with the high deductible and keep HRA the same. The employee will not see a reduction in benefits. For the Pilot, we increased the electric division expense by roughly $200k. The largest increase is paying interest on the new bonds. Mr. Carter reviewed the Graphical layout for the Electric Division Expenses. Everything is fairly consistent. Fuel is a little lower because of the price of gas. Mr. Carter showed the Summary of major areas in the Electric Division. There is an increase in revenues, however overall there is —$1 M in net loss. Commissioner Hanson inquired if the depreciation line trails off. Mr. Carter explained that it is pretty consistent for a few years yet. We have a lot of assets in the plants. Commissioner Martinez inquired when depreciation would start on the new engines. Mr. Carter explained after the engines are added. Mr. Carter spoke on the Gas Division Revenue Budget Highlights. Retail Customer Sales is $7.6m. We are consistently giving fuel cost credits this is why the net decrease in retail customer sales. There is a new company coming in but not a high gas user. There is not a large impact for 2018; we are not seeing a lot of change for growth. Other revenues is at $1.7m. Mr. Carter reviewed the Graphical layout for the Gas Division Revenues. The revenue generated by each class is fairly consistent to 2017 with each class roughly generating 1/3 of the retail sales, which is more evenly spread out then the electric division. Mr. Carter spoke on the Gas Division Expense Budget Highlights. The budget reflects an increase in 1 FTE for a Welder/Service Person. Benefits are the same as electric. Brenda left at 4:07 Mr. Carter reviewed the Graphical layout for the Gas Division Expenses. Purchased gas is largest expense on the pie chart. Mr. Carter showed the Summary of major areas in the Gas Division. There is a decrease in revenues along with a decrease in expenses; overall, there is $2.2M in net profit. There is little growth. Purchase gas will be lower, which means customers will receive benefit. Not a lot is changing- pulled out cost of service. Overall combined looks good. $1.2m this year compared to $1.4m last year. We have a good cash flow. CIP is heavier in 2018; we have new businesses coming in. 12 We have Generators 6 & 7 in there, which is financed with bond proceeds not operational cash. Still cash positive and consistent margins. Mr. Carter asked the Commission if there are any questions. Commissioner Martinez asked if he could relook at depreciation on the electric side. Otherwise, a pretty good forecast. Mr. Carter addressed the Commission Board, we still have couple of weeks before December meeting, please give me a call if any other questions. c. Discuss date for Performance Review of Hutchinson Utilities Commission General Manager. Mr. Carter noted that in the past we have had my review at the end of the Dec meeting. President Morrow asked if he sees a heavy agenda for December. Mr. Carter replied no. It was decided to have the review after the December meeting. d. Declare Employee Recognition Dinner on December 8, 2017 as an Open Meeting Motion by Commissioner Hanson, second by Commissioner Martinez, to approve Declare Employee Recognition Dinner on December 8, 2017 as an Open Meeting. Motion carried unanimously. e. Approve Rescheduling the December Regular Commission Meeting to Wednesday, December 20, 2017 President Morrow will be absent. Motion by Commissioner Girard, second by Commissioner Hanson, to approve Rescheduling the December Regular Commission Meeting to Wednesday, December 20, 2017. Motion carried unanimously. At this time, President Morrow thanked and congratulated Mr. Blake for his years of service. h. Adjourn There being no further business, a motion was made by Commissioner Martinez, second by Commissioner Girard, to adjourn the meeting at 4:24 p.m. Motion carried unanimously. ATTEST: Monty Morrow, President 5 Mark Girard, Secretary a w H N H H H D EO � N z\ O z\ H N U N x H O N w \ N p N a I- 0 a w a O a z w w w F FX N U) Q a z x m U � w Q U x U w x U a ZH- 14 U U ro m ro Q U U Q0 O m 31 O O 1-0 3' N O 1-0 O O 1-0 O m m N H O i' N i' O i' H OJ f� OJ N N i' M OJ n un i' o) H H O m O i' O i' O H un M O O un N N m O O O h un m O H m un i' Ln O M m l0 m m i, l0 m H h M H Ln H N N N M Ln Ln l0 M N O O m H m H m l0 M m N O m O N O i' m un -' H m m l0 m l0 M H M un O OJ M 61 OJ N 61 61 M l0 OJ un O H un H l0 H O H M H h h m M H un N H h m un H H H un i' Ln H 61 H H f N N N Ln N N H H H H H M N f� N CD t� 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 o H H H H H H H H H H H H 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 I I O Q0 I I r 0 I I I 0 0 0 I 0 I I 0 0 I I I I 0 0 0 0 I 0 I I I I I I 0 0 0 0 0 0 I I I I I I I I I I I I 0 0 0 0 0 0 0 0 31 31 31 31 I I I I 31 31 31 31 I I I I 31 31 31 31 O H �D 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 n n n n n n n n n O rn 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 n Ln Ln Ln Ln Ln Ln Ln Ln Ln Ln Ln I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I ,3' O O un un un un un un un un un un un un un un un un un m m m m m m OJ OJ OJ O O O O O O O O O O O O H H H H H H H H H H H H H H H H H H H H H H H H H H H H 3' 3' 3' Pa3 x W ON a H U Ln x W Q0 O Ln U x -1H Pa C C Pa (� H C7 C U 7 B N �0 U O H H O U i7 i7 0 W Q h �-0 h 0 O O O P 31 31 31 �� U W a U x x x#I- U I 1' w 4--I H 31 3' 3' ZH- H H a x x w w w O w H C7 w w w J-) N F4 W a0 i q F4 F4 F4 C7 C7 a a \ a) #1-�' 31 #1- � N 0.i W o W a a a z z N N U#�: #I- #1- rt w U1 O Pa M M H H H H H a a 1 (0 J-) J-) w w J-) Q U O O a s aaa N N O (\j r1 J-) f -I f -I J-) f -I J-) #1- x c O —1 a H H H a a �D �D r1 1 3 3 3 3 3 3 3 3�a4 �-4 rt rt #1- �-4 (0�-4 1 +) U U -- O O W W m m H a) a) a) a) a) a) a) a) a) rt Q Q rt Q rt S -I H N g W U1 w C) C) C) H H �-1 �-1 - U �/-� �/-� �/-� �/-� �/-� �/-� �/-� �E- a Ra 1 J-) J-) Ra Ra >1 (0 S -I ,D N Ot U W O U Fl O ,'� W q W a a a . 'D 'D i/1 i/1 C) O9 'D 'D I 1 I I I I I I I I I >' I S -I S -I 1 (o (o I (0 Q0 1 J-) Q QH o 04 (\J x a m H m r1 0 O O O a a m un H A o r1 r1 r1 r1 r1 r1 r1 —1 a) ,si O A A A A A A A A A 1 1 O -" A S -I -H J-) S: O 3 C —1 M H L1aQ C'J l0 l0 l0 a a C.7 1(0 (0 (0 (0 (0 (0 (0 (0 (0 a) -r1 a) r1 a) a) r1 O J-) Ra O (0 r1 z O O N N z , > > > > > > > > > � 3 a) a) a) a) \ U '0 a) U .11 N H M .D H H U) O O O w U1 r1 w #I- #I- H� ri r1 ri r1 ri r1 ri r1 -ri J-) J-) a) a) a) i) 1 x0 O x H \ \ \ U) U) x Ot a) a) a) a) a) a) a) a) a) 3 '� Z:7)i Z:7)i Z:7)i r, Z:7)i 3 H S: n H H U a U 04 O x a �7 �' ,5 �' �' �' H O O r� U H H U U U U U U U U a) a) a) -0-0 Ra �: a) a) a) (r) -0 +) is is UZ O H 1 0 1-4 'T O -- w 04 W a a a a a a a a a a) r, a) �5 ro U 'C' S -I ri H L14 PQ Pn H H N N U bi -r1 O O �: H in H in a) W ul H f2L4 a W a a a H x x x x x x x x x 61 61 Ul 4H Qa r1 Ln 'J N 3' , D a z z H a 0 �-1 O O O a a rt rt rt rt rt rt rt rt rt- (0 - N .H Ln cn O O z O H W H H H x x O 04 H H H H H H H H H N z H H W H U U U U U U W W H U1S-1 S-1 x Pa W H H H X M ,D O, D . .D O O D U M m m m m m m m m m a) x a U U W W f1 H f1 f1 f1 F4 F4 H H W W W W W W W a) a) a) � x x x x x x� 5 W Ra a '7-, '7-, m a '7-, O '7-, '7-, '7-, F4 F4 a H r1 r1 r1 r1 r1 r1 r1 r1 r1 x O -r1 Ln Ln Ln O U > H rD rD pn 9 O a 0 0 0 04 04 M M 9 x M M M M M M M M M'T'T'T'T'T'T'T U�5 N N N Q z a WO 0. cn co co co LO LO LO H U W w H H H O O O H N N N N N N w H H H 00 o 0 O O O I I I H O O N O O Ol O O I I I CD 31 31 H N N ,3' H H H f� m LnI O N m Om m l0 Ln -i' I O O O OJ OJ H L O fP � O N LED O l0 O OJ O lN H 0 m 3' lO C--0 M 3' M H M O M O M ,3' N M M Il0 N ID C-- H O H 1-0 1 00C 3' l0 O l0 3' O H H N H N l0 1-0 H N h H un i' l0 C-- l0-1 O M l0 m M H H N N M N O 3' 3' N M l031 N M H N N H H N N O O O O O O m m Ln Ln m m Ln Ln Ln Ln H H H H O O O O ,3' 3' 3' 3' H � � O rt rt Ln a a Ln rf) U O O O O 4-1 4-4 w w U H H z z x �D �D �D �D U Ol O I-- O O O Q N H I u H H H H m m m U f O O O H H H H H H H H z r-- i 6T O O O O O O O O O O O O U1 O O I I I I I I I w I I I I I I I I I I I I 0 I I ,i' Ln Ln Ln M M M . H O O O un un un un un un un Ln u� H M CSl Ol O O O un un un un un un un Ln CSl CSl H 61 N l0 N N 0 0 0 0 0 0 0 H O un OJ OJ 0 0 0 0 0 0 0 0 \ O O N H h N N H H M M H H O a w C7 00 o 0 O O O I I I H O O N O O Ol O O I I I CD 31 31 H N N ,3' H H H f� m LnI O N m Om m l0 Ln -i' I O O O OJ OJ H L O fP � O N LED O l0 O OJ O lN H 0 m 3' lO C--0 M 3' M H M O M O M ,3' N M M Il0 N ID C-- H O H 1-0 1 00C 3' l0 O l0 3' O H H N H N l0 1-0 H N h H un i' l0 C-- l0-1 O M l0 m M H H N N M N O 3' 3' N M l031 N M H N N H H N N O O O O O O m m Ln Ln m m Ln Ln Ln Ln H H H H O O O O ,3' 3' 3' 3' H � � O rt rt Ln a a Ln rf) U O O O O 4-1 4-4 w w U H H z z x �D �D �D �D U Ol O I-- O O O Q N H I u H H H H m m m U f O O O H H H H H H H H z r-- O O O O O O O H O O O O O O O O O O O O U1 O O I I I I I I I w I I I I I I I I I I I I I I ,i' Ln Ln Ln M M M a H O O O un un un un un un un Ln H H N un un un Ln CSl CSl CSl Ol O O O un un un un un un un Ln CSl CSl I I I I I I I I I I I I I I I I I I I z I I 0 0 0 0 0 0 0 H O un OJ OJ 0 0 0 0 0 0 0 0 O O F-4 a H h H H M M H H O U U w C7 M u 0 W w w w w w J-) J-) M M J-) J-) J-) J-) C7 C7 C7 C7 C7 -li -li -li -li -1 -I a a a a s -° -° H H ° -° O O O J-) J-) J-) N N N U U H H (r) cr) N N N rt rt w w -ri -ri a a a a N N N H H H H H H H H H H a a a a 0 0 0 0 0 0 0 0 U) l) l) l) 1 1 �-1 �-4 -ri -ri �-1 �-4 �-4 �-4 (0 (0 U U H H H U1 U1 a) a) U1 U1 co co H S -I O ,SZ ,Si H H -n -n r1 r1 r1 H O a H H rt rt S S �5 �5 �5 �5 H r1 +) rt w w -ri -ri a a a a rt a) a) a) M .ri ri ri Ln rt rt rt r, r, r, L U U H H C C h h un un Ln H m m m a) a) a) Ln a) a) a) Ln Ln H H N N O O in a) H O O O Q Q Q l0 '� a a N N N N N N N N l0 '� Qa a, a, a, x x x 0 0 0 0 0 0 0 0 p, U w w w z lo x x 3 31 31 31 31 31 31 31z �5 O .� .� .� W a) rt rt 0 0 0 0 0 0 0 0 W a) cn J-) q q q i7 a M H H 0 a -ri -ri -ri .Y. M Ul Ul .'�. U a) l) l) l) r1 r1 r1 U a) a) l) l-) l-) l-) l-) l-) l-) l-) U .ri co U1 U1 -ri -ri -ri W �aa r1 r1 S-1 S -I S -I S -I S -I S4 S4 S4 w �aa 4-4 a rt rt rt l) l) l) x 11 rt rt rt rt rt rt rt rt rt rt x ri 4-4 i7 �3: �3: �D �D �D U U CQ cn cn P, P, P, P, P, P, P, P, U U O U z H z U1 O w z z a H H a H a o a � z x H W 1Z-1 cHn F-4 a H h O U U w C7 M u 0 W w w w w w C7 C7 C7 C7 C7 O O O O O 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 +-) O O � 1-0 M Ln M 3' 61 f� O O O �1' � 0) �1' O O N N 3, N Q0 Q0 61 31 3' M N l0 N 3' l0 H N O O O H l0 O N M O 61 h 3' l0 O N l0 0 0 61 H CSl of � O M M CSl M un O O H H .� l0 O M 3' O O N H CSl H Q0 N L 61 un H M H O M N N h h h u� .� 61 un M O H M O l0 � r1 0) O N M 3'N l O M M h NI'- CSl CSl H N Q M H M M H H O a as q O O H O Oo Oo O O O O O O O O O O O O O O f O O O O O H O O O N O f O O O O O O O O O O O O O a-1 I I I I I I I I I I I I I I I I I I I I I I I O Ln N N O O O O O O H l0 O un O un H O O O O O O 0 O un 61 61 O O O O O O 61 M O un O un 61 O O O O O O U N H H H N N N N N N H h N N N H H N N N N N N 31 CD CD CD 31 31 31 31 31 31 CD CD 11 CD 11 CD CD 31 31 31 31 31 31 G] H E� H H H F1 W 3 U O a a) w U zo W c w w � oc) U oo U O 60 O H H 6O H N W rt -0 J-) J-) W W Op x H u U1 U1 N 11 i (0 (0 f -I H u u 61 O I O W W Ln +) 0 W � F1 H H F4 s Ln Ln U) U) U) U) U) U) C a) U U) H U) H 3 O .� U �� n Ln W U U Ln Ln u) u) 1- 0 x w w '-0 H H H H H H 10 H #I -H #1- a � x x'D 'DH H x ,H .H U) a s x x x x x x .� r x x a) U) U) x x CD +- z x x z W W W W W W v) � w � w � z z z x z W W a H U Ui Ui W a) O O O N H H w x U) W 0 H a 0 rx 1-1 +) +) u O C7 U) C7 4+ N }-I x W W Z:7) rt rt rt U a s z H H H U U x a a a a a a 1 s-4 a s-4 a s� x x H x a a a as H H U a a a a a a a) a a) a a) U H H U w U a s x\ as w w w w w w w w w as w w �-4 as z z W q w W W W 0 Q W W W x >> > > > > ri > a > a � ri W W x H H x > > a x O O U O O O O O O U x0 O a U q q U a s U O O w a O w z O ° �a x w u w cn 0 a H w co a q O H W H �D H 9 q a x U a x w u) w a U) w Q x ° H U z z a a O 0 ) H n x H u z U .HY. Ui a a a G] U)H H > U) H FC FC �D FC FC x U a W x U w w ° H O q z q z o x U q q H x a H .D C H a u z a x H H H a x W x z a x H x o H U W a a s g\ > H OPa a w x a a O q H a, q H f:4 U) f24 h O H z w H W W a C 7 x r� rG H FC W w U) FC O q FC w a a q w rx>1 z O n 3 H n FC U z U z FC F4 F4 W H Z W O O O � :' FG W W W �D W W x a x x H f7 f7 fD fD f7 O a a i/i rf) u 61 O M III ' u} l.0 l— W 6 1 O H N J' u} l� W 61 O C H N �r LO LO LO LO LO LO LO LO LO o 0 0 0 0 0 0 o r r r LO LO LO LO LO LO LO LO LO LO LO LO LO � H a 1i x oc) U z z z z z z z z 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 w w w w w w w w N b O H O -r1 Ul CJ +-) a H rt� ro w H H H H H H H H H H H H H H H H H H H H H O U q O O O O O O O O O O O O O O O O O O O O O N f7 J-) H N N N N N N N N N N N N N N N N N N N N N �' •• x � N N N N N N N N N N N N N N N N N N N N N r1 '.7 q U W H H H H H H H H H H H H H H H H H H H H H +-) O Q0 31 O M 00 H O 1-0 r M n O O O n H , n n rn n H H 0 r un M 61 61 3' 3' O 61 oo oo O O O O N in in i' in O r un i' l0 l0 N 0 H 31 oo N oo N H in l0M �n �n N 61 H M H 61 N N l0 oo l0 O 61 61 l0 H in in H r 61 r oo N N M r H H M H H 61 M �' oo r N H M l0 O H N �' 3' N H OJ l0 O l0 M 61 oo M-- H N \ H N H N O O 3' 3' H 61 61 O oo l0 l0 N N l0 N N D4 oo H H 00 00 l0 l0 l0 O O O O O O O O O O O H M q O O O O O O O O O O O O O O O O O O O O O a-1 I I I I I I I I I I I I I I I I I I I I I H I I H H M M M N in in N N O O O 3' O O O O O O O O i' O un r-- 0 O 61 in in 61 61 61 61 61 M O O O O O O O O M O un un O O O O O O O O O 3' 3' r r r r r M O m O O W H 0. a rf) x W H U U1 H H H a H U Ul H U1 u� O O O O H r� ED O H Cia C7 '7-, J-) '� N q O U1 U1 U1 +) +) +) +) O H a O O H H H H H H H Ul co co co H H H U1\ x HO O O aaa O O O O O O O q o U1 H H HH H H U U U U H H H N H H H u w a 0 � rt x w �� w a a) 4-) � H U1 in in in H f -I f -I f -I f -I a U O in a Ln Ln I Ln H ooa) o � .�, r 1-1 O .H 04 Pa H U� l0 l0 l0 a) U1 N a) r is is is is W W W W oo \� q P'. N U 0 +) x w z z O O O z �-4 H a) z x z z x�-! U) z a N Q4 U) 04 C7 W S: S: W H H H W O rt r1 w ,'D O rt rt H W 0 \ .H O C7 O O C7 H H H C7 +� U) rt Ga +) H C rt C7 N S4 W U H 'Cl ',' U U U rt U1 rl Sa S4 S4 S4 W rt N r1 N U) a x �� x W W W x � a) x rt �� x a � +) � x [� H W a U N N U a a a U N J-) >, U Ra N N N N U N N is N U a W a H w H H w a a a w S (0 J-) W N 4-I 4-I 4-I 4-I W D4 H H J-) W w o x x x O O O x +- H x �-4 a) a) a) a) x W ro (0 (0 x a q O U) u H H u u u u u U) U u a g q q q u u w a O w z u � w a w co Q a z H �Q u co W H OH q U W iW7 H U w � o w x z a H a a > O W O w o a H 0 a o a U1 U1 W roPQ u QL4 x H �D H zH- U M l.0 r oo .-.. q) r r r r W W W W oo OD LO LO Ln LO r oo (5) O Ln LO � H a - x °J w w w w w w w w w w N b O H O -r1 Ul CJ r +-) a r r r r r r r r r r o U q O O O O O O O O O O N 17 J-) H N N N N N N N N N N �' •• x N N N N O O O O 31 r1 '.7 q U Cia H H H H H H H H H H H N Ln a W H N H F4 r H H D F 0 � N z\ O z\ H N U N x r H O N f r4 \ N p N a I- 0 a H W a O a z w W W x N W u� q a z x cn U u1 W q U x U W x U O N O r Ln 31 M O 3' O O N l0 M Ln rn O r O Ln (3) Ln 3' Ln Ln (3) H r I O I l0 � I O H I O I I I I I I I I I I I I O O O O O O O O O O O O I O O O 31 31 31 31 M M M M M M M M O O M M M M M M M M M M M M O O M M M M M M M M M M M M H un O O O O O O O O O O O O N N N N N N N N N N N N O O m n O O O O O Ln -o O O M 0 0 0 0 0 3' 1-0 [-- CD O 3' O N l0 l0 1-0 3' 1-0 M H O M N H N N N 3' m N OJ O N 3' H H Ln M N H O O N O r 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 I I O O I OJ I O I l0 I O I O I O I O I I I I I I I I I I I I O O O O O O O O O O O O I O O O 61 O H O O O O O O O O O O O O O O O O O O O un O 61 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 I I I I M 3' O 31 O 31 31 M 3' un un un un un un un un un un un Ln M H H H H O 0 ocn H a H W H H H H x iJ iJ iJ iJ iJ iJ iJ iJ cn iJ Ot H H H gq q q O H H U O O O O O O O O H C7 0 O 0 0 0 0 00 0 0 H pn O N N N N NN N N ,D W N m m m m m m cn cn Pn U U cn g q q q q q q q Q q U q a o o O q w w H O o H w L14 H L14 z z z z z z z z z Ln L14 Ui Ui Ui DHy DHy DHy DHy DHy DHy DHy DHy p.' > > DHy Ln (� z w w w w z w w w w w w w w w 0 w z z H H H H H H H H a H w w w 0.W a U a I a a 0.W', a g Q Q Q Q Q Q Q Q Q 0.W', a a a s a a a a a a a a a a Q Q a U a w w a W W a wf�w a W > N > H > > W 0 0 0 0 0 0 0 0 0 r�G O x W q 0 > 0 U 0 0 q 0 Pn Pn Pn Pn Pn Pn Pn Pn Pn U U Pn U q 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 ,3' 3' 0 0 0 0 0 0 0 M M O O O O O O O I I I I I I I I I O O in in in in in in in H H H H H H H H H M FC, � W O ,31 ,x ,31 a C) o rx \ H H M b b F4 a x U U U Ln o w Ln O U1 rl ri \ N W Ln q H H �D H L . . a H U U a X\ q rn�rn�NHLnx0Hw O O O U#I- q N N O 0 0 Ln Ln Ln � a ��xxxCDFlo`f) H W H U 1-1 FC FC FC F4 x o x CQ a H H H a 04 U M x F4 a a U H H U W a w w H a w q a 0 m OD 0) LO �r z w C7 r r r r r r I- Oo 0) O H Oo Oo Oo 0) O O LO LO LO LO O O O N N N N N N N N H H H H U PQ W W p W W a r r r r w H H H H H O O O O H N N N N \ \ \ \ cn x m H H H H O 0 ocn H a H W H H H H 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 ,3' 3' 0 0 0 0 0 0 0 M M O O O O O O O I I I I I I I I I O O in in in in in in in H H H H H H H H H M FC, � W O ,31 ,x ,31 a C) o rx \ H H M b b F4 a x U U U Ln o w Ln O U1 rl ri \ N W Ln q H H �D H L . . a H U U a X\ q rn�rn�NHLnx0Hw O O O U#I- q N N O 0 0 Ln Ln Ln � a ��xxxCDFlo`f) H W H U 1-1 FC FC FC F4 x o x CQ a H H H a 04 U M x F4 a a U H H U W a w w H a w q a 0 m OD 0) LO �r z w C7 r r r r r r O U H H H H H H a H H O O O � O O O O N N N N N N N N H H H H H O PQ W W p a W N N N a w a u o H H H H H H H H ,D ,D q cn x m O 0 ocn H a H 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 ,3' 3' 0 0 0 0 0 0 0 M M O O O O O O O I I I I I I I I I O O in in in in in in in H H H H H H H H H M FC, � W O ,31 ,x ,31 a C) o rx \ H H M b b F4 a x U U U Ln o w Ln O U1 rl ri \ N W Ln q H H �D H L . . a H U U a X\ q rn�rn�NHLnx0Hw O O O U#I- q N N O 0 0 Ln Ln Ln � a ��xxxCDFlo`f) H W H U 1-1 FC FC FC F4 x o x CQ a H H H a 04 U M x F4 a a U H H U W a w w H a w q a 0 m OD 0) LO �r z w C7 r r r r r r r r H H H H H H H H O O O O O O O O N N N N N N N N H H H H H H H H N N N N N N N N H H H H H H H H a a +) co �D M � N b O O -r1 U) J-) C h S -I rl O O N f7 J-) H .D Q a ZH- m Ln f— O M m l0 i' 0 0 0 0 0 0 i' N O N Ln m f— O M Ln H N f— 3' OJ Ln OJ Ln N 61 O M i' i' O H Ln N h OJ h Ln h H Ln Ln i' M i' l0 N OJ M M M 3' OJ l0 l0 . . . . . . . . . . . . u . . . . . . . . . . . . . . . . . . . Ln N Ln l0 l0 h M Ln CSl un�' O. M � OJ M H M O M u� N u� CSl H N H l0 M l0 l0 N Ln N l0 M H N CSl l0 h �' �' m i, t` M Ln OJ i' i' O N m N t` O m H f— H Ln l0 61 N H l0 1 0 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 O O H 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 M O N N O M i, H Ln O H N Ln OJ MLn O O i' Ln O 61 N OJ H H M N 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 I I I I I I I I I I I I 1 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 �' H OJ l0 h 1 O O 1 1 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 Ln OJ OJ 61 O h O H 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 Ln Ln Ln Ln H M O O O I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I Ln Ln Ln Ln Ln Ln Ln Ln Ln Ln Ln Ln Ln Ln Ln Ln Ln Ln Ln Ln OJ OJ OJ OJ OJ OJ OJ O O O O H O OJ M �' C7 U) W O C4 Ln a) U U O x \ w H 0 W -1 l0 U H H W '7-, Cl) U N U) H C) 04 l0 h C4 W C4 U a ice. w E-1 u a o) 1 a N H ,7 O ACU, x a Gn] W a Z7 H rn� a N N N Ln C4 0C4 U f1 M W x U U U M U O M M U) f1 ,> a 04 O C4 O U) U U U z C4 �- O a H H H C4 in F4 .D - H , x x a > a 0 003 3 3 3 3 Ra Q+ Q+ w H 3 o Q H Q ox O U U) a) rt O H �n C7 o C4 rG w H z CQ o H M U) z z z z a a a +)� a z H o o ,> �5 C4 H U) F O N x O f -I f -I x F4 , u M Z W'D U) U 1 \ CJ O 1 1 1 1 1 1 1 -Q a) a 1 1 ,5 U) U) l0 W Opa f1 x W �, x Q H C4 o 1 —1 ,5.,' J-) M H U)—' a H O w Cq H �-1 I Ca H W a) a) a) a) a) a) a) a) S -I ( 0) a) ,D C4 U) Ln C4 - O C4C4 Q H H H H H H —1 rt x H 31 —1 H O C4 PQ C4 x N N P4 f1 i7 O H O ,D SZ SZ SZ SZ SZ SZ -Q b U O 3, A O Q oc) rtJ H W a .Y. � U) —1 —1 W ,7 ,7 ,7 ,7 ,7 ,7 ,7 '� H ,7 H M ,D,D O + O 0 x C4 f1 H H H H H . i r1 Ca H Z:7) OJ H r1 CSl a O Ln U) ,Y,\ q O O O O 3' M a g, H H a) a) a) a) a) a) a) O (0 r,, 61 M a) 61 C4 N U W U C4 U\ C4 M U H N O U) x U U U U U U U o) Wt ri f1 Ln H U Ln C4 H O a W x 0 H 0 x Ln O0 a) a) a) a) a) a) a) N a) +) Ln a) Ln U) a s U) O —u U C4 Fl, —1 N N a a a a a a a- H > ,5.,' >r l0 g a �.0 C4 W e p� HH U) W N W H � Ln U) O Z:7)o � J-) q z W O Q a , H a s D4 #I- a U a x x x x x x x li� z oo x z z w � U a a 0 l z H C4 0 0 �D U d o C4 O rt rt rt rt rt rt rt N SZ a rt W rt w �D W �G O g H g O z 0 0. H H U) q\ g H H H H H H H H H x ri 04 C7 x H C7 w U H H w U H a —1 U H H x a m +- W O H W U) H X a H W�D - W U) 1 04 C M M M M M M M W a) -0 rt (r) x a C4 H W W X z W U W W H z g W> W W , H x H a) a) a) a) a) a) a) - H x a) S-1 U ,SZ a) U a O U) U) C4 7 C) 7 U) PQ a z z C4 0 04 04 a U) H ,Ej H H H H H H H Ln H U S-1 r1 W H H W C4 W w h Cn H UH H Q a H Q H U U 0 04 F-4 H U a w can U U W cn cn cn cn cn cn cn N Cn M � cn Q a a a U) U H H U W a w z U) x H U) z a � Q Q � o a c pa U G, O N 61 O O LO �-o �-o LO LO LO �-o �-o �-o U 0 0 0 a H U W w H H H O O O H N N N F-4 H H H N a w H E� H H H D EO � N z\ O � H z\ H N U �D o O � a N Q O \ , N S4 -I pN U a \ U) a q w � a O a z w w w F FX N u� q a z x �Q u � w q U U w x u Q0 un un O N N Ln Ln i, 61 un OJ O 61 O H 3' H O l0 O l0 M un l0 O l0 un N CSl N un OJ OJ H M H O i, un M 61 l0 H O OJ 61 OJ 3' O 61 Ln M N . . M N . H . H . . . . un Ln l0 l0 . un . . . . . . un O M H unH . l0 . O . h . M . . . . OJ Ln OJ i, . OJ . M . OJ . . H O CSl H OJ O l0 l0 N N OJ � �, 0) M 61 H N h LnN un H N H O O Ln H N H N I N N N N N I I I I I I H N M I I I I I I I I I I O O M M O O O O 0 0 0 0 0 0 3' O M H 61 N ,3' 3' N N 31 3' 3' 3' 3' 3' 3' 3' �1' 3' N H OJ N O O H H N N H H N l0 m m O H O N (\j (\j N O O O O O O O O O O O O 0 0 0 0 0 0 O O O O O O O O O O O I I 1, O) I O I O I I I I O O O) OJ I I I I I I I O m M I I I O I O I O I I I I OJ OJ m O) I O I O I I O O N O O O Ln Ln m m i, un m O M M O un O 0 0 0 0 O O O O 61 un O O un un un un un un Ln CSl CSl CSl O un O un un un un O O O O I I I I I I I I I I I I I I I I I I I I I I I I I O O M M O O O O 0 0 0 0 0 0 3' O M O O O O ,3' 3' N N 31 3' 3' 3' 3' 3' 3' 3' �1' 3' N 3' N 31 3' 3' 3' H N H N H z a O W H H � O O O O �o �o a w O O LO H ,OT,N a Pa', o ° 0. z o q a w �l FG H cn W z H u H U U U U H SSI Q Q a a O o O O a a H N o N N N w a � 9 a s n a Q Q cn w H H H H H O (r) oa �D �D (r) (r) crz crz W +) w waa q O a a O O O O x LI -4 a) r, w w w w U w H a w w rl z z x P x q q x x x x U O w z a O O H H � O O O O �o �o w w w O O LO H ,OT,N a Pa', o ° q a w a H a) H cn W z H u U U U U co u f" W O O O O O �o �o �o �o �o LO LO LO a) H ri H H U W O O O O O H N N N N N F-4 li cn w H H H H H a) H ri H F-4 li cn H H +) �-1 +) O w q O q q a) +) r, a) a) r, H u w H w w � N ,, ( r, 6) FC; a M 1H-1 1H-1 3 �a4 V)�a4 O P a rl a a �a, -ri +) -H 1-0 �D a Q0 a a H -ri �5 �5 Ln rf) F(', Ln rf) F(', rf) F(', rr O rr 1-0 z \ Q0 H \ H \ ul ul ul ul z (r) �D H H H H w �D �D +) a) a) +) (r) a) w rt rt rt rt �7 w w rt H H U '0 H W W FC W sa U U a) U x z H x x a rx a x -ri -ri H -ri u O a u a a o° a x o Q w rt rt rt rt x> w >a) w >> u> u u q u O q O q O u z aH FG W z z O ° H rf) H a h a z a w o) U a o u �D Q x x q a o w w H x 3 O H x z n W n H oa � f:4 w o H O O O a Q Q u u u u u q 61 Cl H N M J' LO l0 r - O H H H H H H H H LO LO LO LO LO LO LO LO w w w w w w w w w 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 H H H H H H H H H +-) O l0 l0 O un l0 f� 61 H H un un H O O un H 61 O O f� N O H 1-0 oo oo M O un un O N H OJ i' H un N 61 M O M 61 l0 N Ln O 61 M H M l0 l0 un N 0 0 O 3' 3' l0 Ln M 61 l0 OJ Ln N Nl0 H O 61 N h Ln l0 61 O H H h un N Ln M H h M un l0 M of � M 0) l0 61 M M h r-1 H H H l0 3' Ln H M un N \ H H OJ a H H Oo O O O O O O O H Oo H O O O H H H N H H H Oo q O O O O O O O O O O O O O 0 0 0 0 0 0 O O O O O a-1 I I I I I I I I I I I I I I I I I I I I I I I I Ln Ln M O O O i' i' O O Ln N Ln O O O un un un Oo un un un M 0 un un 61 O O O M M O O un 61 un O O O un un un un un un un 61 u N N H u� N N h h l0 l0 H H N l0 l0 l0 N N N H H H H H O O O M 3' 3' O O m m O O O 0 0 0 0 0 0 O O O O O 3' O J-) Ra Ra i1 U H H H U U H U U U E-1 rt rt W (0 (0 (0 4-1 hh H H H ,D H H H O O a sz sz a sz sz sz Ln H H a a a Oa Oa F1 r O cn O N I 1 1 �-1 �-4 �-I U1 a a C C a rt O H N N H H H H H H H H H Ul is is H 'ri H U1 H H O q N O �+ O z\H W rt rt H H rl rt rt rt� +) +) H N H 1--1 �5 �5 H 'J 'J �/-� S -I 'J 'J 'J Pa U) U) U) J-) x O O oo a 1 'H 31 r -I 'r -I '� r L1 U U U H a N N N O -P N N N •• •• •• N CD O O l0 U1 04 U U l0 U rt U U U N61 61 l0 H l0 0 in W FC U2 U2 N N Ln W x N N N O N N Ln a Ln h � Sa �I l0 U1 \ H H a s Q0 a a s P. N N N l0 W l0 r1 'r N N 'Z, q 'Z, 'Z, Ul Ul \ O O O O l) W W W S-1 Sa x x x x x�1, 0 0 N Q, H H W 04 O O rt rt ul W O ul rt rt rt O M M W 0 \ r1 C7 x Ga +) +) H H N C7 O N H H H 0 N N N +) C7 N Sa W W rx FC 04 FC 04 rt rt 'H S -I S -I m m H 0.', H U E N U U fx f:4 N N N N Ra U H N N N -P -P -P U W Ra Ra Ra U U 04 W W S-, S-, r1 r1 �a4 W W '11, H H H S -I S -I S -I W '7—, Ra Ra Ra Ul W 0 W W x H w > > N N r0 �5 x fx N x H �5 �5 �5 'ri x 1 p, q q q U q O O i7 i7 n U) U) U a 5 U) U) U) a a a U a n n n U w a O a w z w w w wFX N Q�a a U z W � m H W H H a q u z H FC U z O x q W W U w ° ° o x H x u U) O O U H i7 O �D H H \ ( w a s w a a (0w > a a H a H a H O a O H w U oo Cl H N M J' u} l0 oo Cl LO LO LO Pa i oc) U z z z z z z z z z z z w w w w w w w w w w w N b O H O -r1 Ul U -)-I h S4 4-) a O U q O O O O O O O O O O O N f7 J-) H N N N N N N N N N N N --I r1 '.7 q U Cia H H H H H H H H H H H H N a w H E� H H H D EO � N z\ O� � H z\ H N U N � �D o o +� a N Q O \ , N S-14 N NU\ m a a q w � a o a z w w w F FX N U) q a �D x cQ u � w q U U w x u N O O 61 M H H un l0 m H H h O O M h 3' l0 N N M l0 un M O 61 OJ N OJH un i' un M h Q0 O M 3' H OJ H M O H O un O O O H I I O O H H H O I u� I H H I O I O O I O I O I O I O I I O O O O O M N Ln m CSl CSl CSl CSl H O O O O O M O O O O un O O O H N O O O O N O O O h OJ N Ln Ln 3' H O un O H h H l0 l0 M H M l0 M �' M M N N H H 00 O O O 00 00 H N N N N N O O O O O O O O O O O O O O O 0 0 0 0 0 0 O O O O O O O O O I I O O I O I O I u� I H I I I I I I �' H OJ OJ OJ OJ I O I O I O I O I O I O I O I I O O M O O O M N Ln m CSl CSl CSl CSl O O O O O O O O O 61 O O O 61 61 un un un un un un 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 I I I O M M O O O 0 0 0 0 0 0 ,3' H N H 3' 3' 3' 3' 3' �1' �1' �1' N N N N N N N N H H x H H H H � rt rt rt rt p� Sa Sa Sa Sa U1 a) a) a) a) a N C) fx -li rt O q q q q q q q q Ul .� W C) W J-) 1.li I I I H w w w W W W W W �. l� H z H r' Ul S -I H H H H H H H H a) ri a 'D rl J-) r1 N J-) J-) J-) 00 a a a a a a a a �a, U a w s-1 r, rt +) S; S; S; M a a a a a a a a D4 f2L4 a) wx a r, � U) \ a a) � � � \ \ \ \ \ \ \ \ H 1 ro q a a +) 1 .H .H .H q q q q q q q q z P z a w >1 rt �5 �5 �5 z z z z z z z z z w Z:7) �D H x u S u tr tr tr W �D �D �D �D �D �D �D �D P E 11 O a W W W C7 W O +) ul H W W W W W W W W FC rx �-1 (r) U��-1 x a a a a a a a a a U a) a) .li a) a) a) U a rt a z U1 U C 3 3 3 W a a a a a a a a w S-1 rt W H H '� U .'i a) O O O x W W W W W W W W > H u q w 9 a> w w w U q q q q q q q C) O O u H a a a x �D W Z H W O rz a U H w FG \ W FC H W W H w p w w o a a h W H z H q q a z O z O H x i7 >F-4 O U 3 O E x FC z H a H z z z H W U1 z w w H H u u a Pi w x q x x x a > a w w H a F-4 w U1 U1 u u u w O H U1 U) a 0 0 lzi U1 U1 W W 0 � � � � 9 9 O O x x x x x x x h h h h h h h H N M LO l.0 C" W Cl H N M J' LO l.0 W 0) M M M M M M LO LO LO LO LO LO LO LO LO LO LO LO LO LO LO Lr H w w w w w w w w w w w w w w w w H U W O O O O O O O O O O O O O O O O H N N N N N N N N N N N N N N N N \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ F-4 H H H H H H H H H H H H H H H H O I w H N H H H D EO � N z\ O z\ H N U N � �D o 0 N Q Ga \ ri N S -I N U E1 \ U) a a q w � a O a z w w w F FX N U� q a �D x m u � w q U U W x u Ln Q0 oc) O rn O O O Q0 O n n O n O O O O O I-- l0 N O N O O O H Ln h N O O H O un un O . . . . . . . . . . . . . . . . . . . O M O in 61 N O in 61 O H O 61 61 O 61 O of h l0 l0 O in Q0 Q0 Q0 O O 3' NCD H N H N H O H 61 l0 H N H O O O un O O oc) O O N O un un 61 O O O O O O O O O O O O O O O N O O O O N M O O O O O O O O O O O O O O O O O O O O O I I O O I O I O I O I O I O I O I O I O I O I H I O I O I OJ I l0 I O I I M H I I I l0 O O O O O O O O O O O N O O 61 N O O N in in O O O O O O O O O O O 61 O O un 61 O 61 61 un un I I I N I N I I I N I I I I I I I N I I I I I H I I I N I N I H I I I I H H I I H H M 31 3' O M 3' O O M O O O O N H H N H N N N H N N 31 N H �1' �1' N �1' 3' 3' 3' O O O Ln AM W H W O F-4 H H oc) z Q0 w w � W n F-4 � � w x u w H H U u F4 a U? z O H F4 O Uz C7 a w z w U 00 z w O N \ N H C7 H a a a x H \ as rx H a rt H \ . � S -I IH N J) w l) [ rt O H q q q q q q q q q a 0 0 W a H H Pa a a a a a a a a + a x a a a a a a a a a Uz � D4 a a a a a a a a a F� F F� F� 9 Uz 9 9 \ 9 q u, \ H H \ H \ \ \ H \ \ Z:7) \ H a O \ � q z z w w z w z z z w z z z w z O z �D �D �D �D �D �D �D ul W F-4 w w w w w w -ri w W - w H H C7 W FC FC W FC W W W FC W W +) W FC S -I W U a a a a a aa s s s xf24a u a W W a W a a a w a a a w 3 a a W Q 0 0 Q 0 Q Q Q 0 Q Q Q 0 a � Q 0 H U z O cn H cn w �D w z a H H cn H H O a w W H H z a H O) O W W O H Z U) H �D U? U? a H W U U W W W a H a W Q Ww �-I n z q > W z w W a x a a s W z x w a cQ z q a z w w w H O O w a z a w z zq C 7 Ui Ui w f24 u x P H a .D Uz O H O �C Q x o 0 � w a w � aw x x x x x a U? U? H � [x -I H w U O O O O O O O O O O q W H W H O h h h h h h h h h h x x x a a a a O H N co J' LO l.0 r- W 61 Cl H N M LO LO LO LO LO LO LO LO U z z z z z z z z z z z z z z z z z z H w w w w w w w w w w w w w w w w w w H U W O O O O O O O O O O O O O O O O O O H N N N N 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 H H H H H O O O Ln AM W H W O F-4 H H oc) z Q0 w w � W n F-4 � � w x u w H H U u F4 a U? z O H F4 O Uz C7 a w z w U 00 z w O N \ N H O w H E� H H H D EO � N z\ o z\ H N U �D o o +) a N as o \ , N S4 -I pN U a \ U) a q w � a O a z w w w F FX N u� q a z x m u � w q U x u w x u N a ZH- 14 u U � H a 1i x 00 � M � N b O O -r1 Ul h S 1J O O q N f7 J-) x U H �D q U H in O O H O O O H O H in N O O OJ O O Ln N Q0 61 61 M in N O OJ OJ H M O OJ N 3' l0 M 31 in H H OJ M in N H H Q0 O O O O O M Ln r -- Ln un un O O O un l0 l0 M ,3' in h M in O N 61 M in h M N OJ N M M M H N M N H M H N N H O O O O f O O O O OJ OJ 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 I I O O I O I O I l0 I O I O I O I O I I H H I O I O I O I O I O I O I O I I OJ O O O O O H O O O O N N O O O O O O O O O O O O O 61 O O O O 61 61 O O O O O O O un O I I N in I in I in I H I in I N I in I N I I H H I N I in I N I in I in I in I N I I H N a H W u O o 0 M 3' O O M 3' M M M 3' O 3' H N N N 31 N N N H 3' 3' H N H N N N H 3' H H W x � a a H w w o � F-4 u H q x z w H H o U a u N W z � a a a Q a W " � � +) z z w ��. H 0 q u 0 a W as Ui H a a H W u o 0 ° a q w w a n a a a a a a x z u z u x H H H H U1 H 04 LO l0 C" W 00 00 00 00 00 00 00 Oo Oo a a a N a I a l0 l— 61 rn a a a a w w a a a w a w a LO LO r LO a LO a a a a a a a U a a a a a O rt FC FC FC N N FC N FC n N N N Ln cn FC rf) FC FC FC cn a cn U W N N N N N N N N N H H H H H H H H H w z z z as z �D z w w w z w z w z z z w W �D �D �D .1i�D \ cn �D \ z z W �D �D �D �D (r) F-4 w w u w z w o o w w w w w H H H H H H H H H H a aa a I a a a a s a a a a a a a o a a w a W W u a a a w a W a a a U a w a w a s w w a W a a a W 1I W o Q Q Q QQaQoH H u oQoQQQo�o H x � a a H w w o � u H q x z w H u o U a u N W z � a O CW -1 a Q a W " � � z z w ��. H 0 q u 0 a W as Ui H a a H W u o 0 ° a q w w a n a a a a a a x z u z u x H Cl H N co J' LO l0 C" W 00 00 00 00 00 00 00 Oo Oo 61 Cl H N co J' LO l0 l— 61 w w w w w w w w w LO LO LO LO LO LO LO LO LO LO O O O O O O O O O N N N N N N N N N H U W N N N N N N N N N H H H H H H H H H O O O O O O O O O O H N N N N N N N N N N \ \ \ \ \ \ \ \ \ \ w H H H H H H H H H H x � a H w o � u H x z H u o U a N W z � a O CW -1 W " � � z z w ��. H 0 q u 0 a W as Ui H a a W u a a s a a a s a Cl H N co J' LO l0 C" W 00 00 00 00 00 00 00 Oo Oo w w w w w w w w w 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 H H H H H H H H H O l0 O N Ln O h un 61 N Ln oo H N l0 h H l0 N H H un i' f� O O O un H un un N W O U) O O O un l0 H 61 H O 61 O aT M 61 61 h q q x x o 61 O i' un 61 3' O 61 h un h M l0 N N O O OJ OJ O CSl M M l0 N un OJ M H 61 un l0 Ln f {r -K -K -K 31 O m M OJ un 61 O H H H O un O O O O O a-1 I 10 f� Il f� 0 O 1 I I I I I I I I q q q q a a a U —1 U W W W WLnN O 31 x u O O O N N O O q q q q H (\j H O O O O l0 O cr) O O O 61 61 H H H H O 61 61 61 O O O O un U N N I O O O O U I I U U U U H cn � � N � H H u� N � N N H H H H H K K K K M N O O 31 3' M N 3' H M N 3' H 3' H O 3' O 3' K K K K ZS) ZS) ZS) W a +-) z W o W W O U) O O O O O f2L4 F-4 w o u q q x x o w w I I H H H W W O O O OJ OJ O O O O O OJ OJ OJ O O O O M q O O O O O O O O O O O O O O O O O O a-1 I I I I I I I I I I I I I I I I I I H x a a a U a U w w w w Q o Q x x u O O O N N O O O O O N N N O O O O l0 O cr) O O O 61 61 O O O O O 61 61 61 O O O O un U N N I �D -li I U I I U U U U H cn � � N � H H u� N � N N H H H H H 9 O M N �' H M N O O 31 3' M N 3' H M N 3' H 3' H O 3' O 3' O 3' O H H H H 31 w H E� H H H D EO � N z\ O z\ H N U �D o o +) a N Q O \ , N S4 -I p\ N U m a a q w � a O a z w w w F FX N v� q a z x m U � w q U x U w x U a ZH- 14 U U � H a 1i x 00 � M � N b O O -li UZ h S 1J O O q N f7 J-) x U \a).. H �D q U F4 z W o W W O U) O O O O O f2L4 F-4 w o u q q x x o w w I I H H H W W a a U U M a a rn a a E W � � Q0 W 0. Z w Z Z Z z H H w w H N M I W 61 61 61 a a a H H x a a a U a U w w w w Q o Q x x u F4 z W o z O O U) O O O O O f2L4 U) o u x H a �D W rG ia7 a W cn W 0. cn H H H w 61 H N M I W 61 61 61 0 �-o �-o �-o �-o a U w w w w a a� a H U -li cr) W cr) cr) v) v) v) v) H q q a +) O O O O O O H N N N N �D -li U U U U U U U U H cn a a Q ° oa F-4 H H H H F4 W �5 O O O O O O O O U a W cn W 0. cn cn w I I I I I I I I 0 °q a w w � a a� a CD n -li cr) cr) cr) cr) v) v) v) v) H q q a +) O O O O O O O O O w w H �D -li U U U U U U U U H cn a a Q ° oa U W W H H O O a a O Z:7) Z:7) Z:7) ZS) ZS) ZS) W a a H H U) H H �D > > s-4 s-4 s-4 s-4 C" W 61 Cl H 61 61 61 61 61 61 O q z q z z H \ W W W W W W W W LO LO LO LO LO LO LO o Cl H �D a z w w w w w w w w w w W FC W FC FC c/1 ',C,' O x a x a a a a a s a w ro O O O O a) U Pa W Pa W W H a a) 4-I 4-I 4-I 4-I 4-I 4-I 4-I 4-I W W > W> \ > \ w s-4 a) a) a) a) a) a) a) a) x C) O q O O H a q q q q g q q q U F4 W U a W cn H cn cn 0 °q a w w � a a� a CD a F4 a ° z ° H W cn z cn a a Q ° oa U W W H H O O H H H H H �D > > C" W 61 Cl H 61 61 61 61 61 61 O O LO LO LO LO LO LO LO LO Cl H w w w w w w w w w w 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 H H H H H H H H H H F4 0 N M H a Q O U U W H E� H H H D EO � N z\ O z\ H N U N � �D O O � a N a O \ 4 , N � pN U a \ U) a Q w � a o a z w w w wFX N � Q a z x m U u1 W Q U x U w x U a zH- 14 U U � H a 1i x � � U " m a N b O H O - U u +- a N f7 J-) H H ,D q U W H H � 1-0 1-0 O o-) oo Ln -i n o -i o n M rn oo H rn 1-0 O O O c L N Ln i' i' N un l0 N H l0 m m m m m O O O O O Ln Ln Ln Ln Ln H H H H H O O O O O ,31 31 31 31 31 N Q0 H O r N H N H H W W W W W W �D �D �D �D �D x x x x x W U U U U U x rf) rf) rf) rf) rf) U 00 C O Q0 M W H E� H H H D EO � N z\ O z\ H N U N �D o o +) a N as O \ , N S-14 p\ N U m a a Q w � a O a z w W W W FX N U1 Q a Y �Q u U1 W Q u x u W x u a ZH- 14 u U � H a -) x 00 � M � N b O O -r1 (r) h S 1J O O Q N 17 J-) x U H .D Q u ,i' N m un m O m H OJ 61 l0 61 N 61 H h N O un h M H H H 3' f� 3' un M H oo H Q0 oc) N O 61 H N 00 H f� Ln 61 61 N H M un O M M M O f� � M O O O un O 6 6 Q0 O H H M 3' H H ,3' O M O O H H 00 61 O 00 fl N G1 O M H 00 N � N h M OJ 0 0 0 0 0 0 0 0 x 00 31 31 00 00 00 t� o 0 00 o 0 0 03 0 0 0 0 0 0 0 0 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 I I I I 0 0 0 0 0 0 0 0 N 00 00 M M M H O O N O O O N 0 0 0 0 0 0 0 0 61 00 00 61 61 0) 0) O O 0) O O O 0) I I I I I I I I I I I I I I I I I I I I I I un un un un un un un un O O O O O O O un un O 3' un un O O u H z z W o o \ \M a a u z u Q W O H O H w H U) w w a U) a W a x —1 f24 W 60 a z Q o H a H H x �D O 60 a � O W w a U) w a w w Ln rn a H W F4 H a Q U) U) U) H H a W -- 61 U) H W U) W a w h N N N x a +) +) +) a s a s 04P Wa f) z rl = UQ U) rt rt rt H Q (\J W 04 �3: F4 m a u u ,5 ,5 ,5 x H H ,5 55 \ a H O \ \ \ r� U) H w a OD 61 N co J' a s W 61 U) co M J' u7 u7 LO LO x H F-4 N O 3, x +) +) +) 60 60 H W w H H w M x M N Q w w w w �5 �5 �5 O FC, 60 w 1 F4 H C7 H C7 H C7 N H H C7 Ln H F4 1-0 U1 c x a W O �-1 O 1 1 1 O C7 O H H Q Q o M f2L4 ' z O ,5 H H a s H O H H O H O O a s H H\ O_ H N N Q Q N ul ul ul N rt z z N N W W W \ H H 3' U) = OJ U) z z N N N N M rl O O f Ul u H H -1 U) H N M N N Ul 31 J--) H H �11 N N N x x Ln W H i, H Q Ln H in is is is Ln is H H Ln rl U) U) Ln H \ H U) C7 a Ln a Ln H Ln H H Ln H PPa H Ln a F4 l0 04 l0 Qa Qa Qa l0 '� l0 a4 �D H H 1-0 Pa x H a H a Pa w w x x x as 04 W 114 (�, z ,D z w w w z (1) H H z � z O O z � C9 a CJ O H P+Cq W U) U) U) W W N F4 F4 W U) H 0.i 0i W U) U) I z 1 9 U'\ 0 C7 �� i� a 9 9 0 0 H H z O Q W J-) J-) J-) U U N x a s W a 9 a.4 W .4 U O O .Y. -li -r1 -li .4 1 .4 U H W W .Y. U C7 Pa w w I H F4 U H W W U H H H U • • U 11 a Pa Pa U H �D U�D a U) W H W w H H W -li -li -li W as U) U) w w w w 9 HHu aU)°aw H H u o u �� U u 0 0 u o x o x F4 a z �D O O H H H 'z U) a a O w O u H z z W o o a u z u W O H O H U) H U) H a U) a W x W C a z Q o H a � w a w w x a H U) U) H H a W U) w a w h U) H z o�D H m a u u u x H H OD 61 N co J' C" W 61 H N co M J' u7 u7 LO LO w w w w w w w w w w C7 C7 C7 C7 C7 C7 C7 C7 C7 C7 C7 H H H H H H H H H H 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 W H H H H H H H H H H W H H H H D EO � N z\ O� � H z\ H N U N � �D o o +� a N a O \ , N S-14 pN U a \ U) a Q w � a O a z w W W W FX N U� Q a �D x cQ U U1 W Q U x U W x U 61 O un O un ,3' Ln 3' H H N O M N M H un Oo M H un O N O 61 N 61 un un un Ln M H h 61 N N 61 O un O M H Ln N Qo Ln un O 3' r-- ,31 �,3' O M H O un (1M (3) H g' OJ N M H H H M 3' O O Ln N O O O is �o Ln N O r-- �r` OJ O un L r-- Ln O O OJ 61 O n o 0 u} O OO N N 6 to H O O M un to M M M N C" M M O O O OO w` O O O O LO Ln LO I I I I H I I LO -- I I I I I I I I I I I I I a OJ in in m W H H H H D EO � N z\ O� � H z\ H N U N � �D o o +� a N a O \ , N S-14 pN U a \ U) a Q w � a O a z w W W W FX N U� Q a �D x cQ U U1 W Q U x U W x U 61 O un O un ,3' Ln 3' H H N O M N M H un Oo M H un O N O 61 N 61 un un un Ln M H h 61 N N 61 O un O M H Ln N Qo Ln un O 3' r-- ,31 �,3' O M H O un (1M (3) H g' OJ N M H H H M 3' O O Ln N O O O h un O O O �31 O OJ O un L I-- Ln M O un L H O h r N Qo N M H 00 41z 31 Lc) Lc) -k 31 o 0 0 oc) Lc) 31 31 oc) oc) M �.o �.o �o 61 O n o 0 u} O OO O O O Cl O O O O to O O O O C" O O C" O O O OO w` O O O O LO I LO I I I I I I I LO -- I I I I I I I I I I I I I N OJ in in m O O O N in � I N N z O O O z m Lc) O O z 61 z oo oo oo z z oo O O O w m Oo Oo Oo w 61 61 w 61 61 61 w w OJ OJ O O C7 I H C7 I I I H H H C7 I N I N I I N N C7 C7 I H I H I I H H I I H H I I I H H H I N I H I I H f O O O O O 3' 3' 3' O O O O O O O O O O O O O N M O O O O O O N N N N N N N N N N N N N \ \ \ \ \ W \ \ \ \ \ \ N N N N N N N N N N N O z Q H W H H H H H O a H H H H H H W W O F4 a Qo cn Ln a U rf) I I H H I W W h W H H H a � +) H a a U1 H a 04 a a H a H H rt z 4-) H a � U rf) � 60 U) 09 Q cn cn cn cn Ufi H H U U H O 0 H a U H H H H H H H U E O Fl H H O �-4 N ow O x r1 O O a a a O rt H +- H a s H N 160 O H U1 S -I H H w w w H 'ri a al E U1 N �, U U M N U °N I O U) U in h a) W Ln i7 W W 1-o x 1 W [--N W f h W N [ H un I a s in W U in H H un un in a J-) F4 Ln W W W Ln Ln U Ln a W Ln Ln 1 1 1 Ln W C 04 Q0 cf)v v l0 04 l0 l0 Q0v H C 04 z z z � z W U1 U1 z z � z � ul ul ul z N N z O O O z U1 U1 W Pa W W W U1 w U1 N H H W S: S: W H H H W Ul W C7 x H H 0 U1 z 0 11 rt rt C7 O O 0 H H H C7 N H O O W W H H f -I a z H W J-) .11 'ri �11 �11 U U U H H 0. Pa U.Y. H H .Y. -ri H .Y. U 'ri S -I S -I .'�. Ra Ra .4 W W W .Y. U H H U U F4 I q U H W U H H N N U N N U a s Fl U 'ri a N M Z W W U1 H H W Ra �/-� Q W W W 'ri J-) J-) W H H W a a a w ,S,' H H O r W x H H H x N W H H x W4-) rt rt x N N x0 O O x N H O O O U', ,'� ,'� U a Q a s U O ,'�',', U H H U U U U U z U O U1 H W H z O O a Q a H U1 Pa z W W W U1 H O H W W U z x U a Uz a a o H Uz w w a H w ° a a w W Pa H H 0 w a O U W H fxy.' " 0 H w w a U U a U x z a o o H 0 0 Q z w W U1 H H W H \ Fa H Q F4 a a a a a x o Uz a z U w w w x Pa W x z a a U1 U1 H H 0. 41z -k -k -k -k -k M l.0 61 O co J' u} r`- OO 61 Cl l.0 l.0 to C" I— C" C" C" C" C" OO w` err err LO LO LO LO LO LO LO -- �r z z z z z z z z z z z z w w w w w w w w w w w w C7 C7 C7 C7 C7 C7 C7 C7 C7 C7 C7 C7 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 O W H H H H H H H H H H H H O O O O O O O O N l0 �n 3' 0-) un un M Ln co Ln H • • M N N ,3' 3' N N O un un OJ 3' O h N Ln N OJ l0 I O M M 61 h H m N O un O O O un m mLn l0 N O O H N f� Ln O l0 i' OJ OJ O � O O O l0 61 O 61 O M O O l0 N Ln N h h i' Ln ,3' Ln OJ O l0 O O N N� m N N O m N un M i' O M un OJ O H h N H 61 H H 3' N H O l0 H l0 H N N h N H H un l0 H H H H 0 0 31 31 O t� O H 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 31 31 H O O O w rt x w O O O O O O O O O O O O O O O H H I I 3' N 00 I l0 I O I O I I I I I I I I I I I I I I I O O O O O O O O O O O O O O O I I 3' O O O h Ol O H O O CW7 cn rt CW7 03 03 O 61 O O U + U I I 4-)-) x+ I x U Uz U U N O un O O O un m mLn l0 N O O H N f� Ln O l0 i' OJ OJ O � O O O l0 61 O 61 O M O O l0 N Ln N h h i' Ln ,3' Ln OJ O l0 O O N N� m N N O m N un M i' O M un OJ O H h N H 61 H H 3' N H O l0 H l0 H N N h N H H un l0 H H H H 0 0 31 31 o t� o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 31 31 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 O O I I 3' N I O I l0 I O I O I I I I I I I I I I I I I I I O O O O O O O O O O O O O O O I I 3' O O O h Ol O H O O O O O O O O O O O O O O O O O h 03 O O 03 03 O 61 O O O O O O O O O O O O O O O O O m m I I I I I I I I I I I I I I I I I I I I I I I I I h M O O M O M M un un un un un un un un un un un un un un un O O H H U? a � CD 0 o n a c Q Ln Lnw H H H H\ U W CQ m . a H W cn � a�� x w-1 Q Q Q FE �l -• W ~cHnl QF4 Q `� x a s a U Q U H N Q w W Q0 l0N P� P� i/1 ,T. 114 O O Q O Q Q Q 1�H W N . H rz W H W W W N N O 0. c 0. a 0 c f2L4 Sa H H H H Fa U 1 3' , Q H '0 a l0 a C7 a a w Q m H\ C7 a Q C. Pa OJ Pa z L14 04 Ui Ui x x= x x H M z �. 04 Ln Pa H L14 L14 L14 L14 U1 l0 1-a Q H H 31 W rG Ln H rG H H U? : : : : O W a \ N F4 \ Q0 \ \ \ wx H Q Q Q Q\\ \\ w a: a Uz lzi co co 'T 'T x M M = M M O L14 x �, N ,D H H W ,D ,D ,D \\ W H H W �'7. w w w M M H W �-1 . rl Wrlri W W WW W W W W H w H a f -I a a I W F4 F4 F4 F4 F4 W W W F4 W O R, N N U W W> a a a a a W C7 >> x 04 H 4-1 a +) +) W a a a a a s a a a a a a�D cn F4 �D H .li a Q U Q U Q Q 04 Pa � a i 7 W UU Cn� F4 a a Uz U z a H O H U H U H W C7 Q W z o w o w f:4 w Q as x w a a w w H PQ W w` W W W Ol Ol Ol Ol LO LO LO LO LO LO LO w w w w w w w w C7 C7 C7 C7 C7 C7 C7 C7 H H H H H H H H O O O O O O O O N N N N N N N N O 31 31 31 31 31 31 31 M H H H H H H H H N N N N N N N H H H H H H H H I w H E� H H H D EO � N z\ O z\ H N O �D o o +� a N a O \ , N S-14 N U E1 \ U) a a Q w � a O a z w w w F FX N � Q a z x W U � w Q u O w x u f� O 61 N Ln f� O 3' 3' H O 3' 3' � oc) Ln 3' 3' O Ln oc) 31 M oc) r r N O M l0 31 Ln O N (\j O H H H H H 00 Q0 Ln i' Q0 oc) m O h O ,3' � N N H Ln h l0 M m N M f� CSl H � H O O un oc) O Ln O oc) O L 0 oc) O O 0 o0 O O O O O O Q0 O O O O O O O O H H O O I I O l0 H H I l0 O I I O O I I I I O M un un I O I O I O H I un I I O l0 O un N O CD n o0 o n o 31 31 31 Q0 m m 0 0 0 31 o0 0 o0 O O O O O O O O O O O O O O O O O O O I I O l0 I l0 I O I l0 I O I I O O I I I I O M un un I O I O I O I 3' I un I I O l0 O un N O un O oc) oc) m O M M O O O h M O N O oc) 61 O 00 O 00 00 00 61 61 61 O O O oc) 61 O 61 I I I I I I I I I I I I I I I I I I I M O O M O M O O 0 0 0 0 M M M O O M O N 3' 3' N 3' N 31 3' 3' 3' 3' 3' N N N 3' �1' N �1' a ;l, M a) u a) H z z H J-) H J-) H H n O U H O H h W w I-- H �D H a U H H x �D H 0 H GW -1 H U F-4 oa Ot w � H u x a u u x w w l) o 0 h a a H H U a u u Q Q Q w w w 0. �D H H O N n r o w U1 � H U1 H N N N H co a x � a w H a H w w oa xQ w w w w a r� O w x H C7 0. pa U rt a) Gia U U U O H U H H U O O O O H w U? H H co LO l0 I— Oo H O Q O H Q O Q �-1 O +) O Q Q Q Q H H W f-1 H W f-1 W a s H J-) a) a) C H W W W w w W H H J-) z H J-) C7 J-) C7 C7 C7 C7 C7 0 a U a U a z z oo ro H H O O O O O rn a a) O a a) a N N N o CO L O a a a a O 10 ¢ +) -H � w w w Uz w U Ln � w w � w � N N un -ri 1 �5 �5 Ln H H H H W 9 W Q0 \ a \ \ 'D0 rr 1-0 \ \ \ Uz \ a z z c z co z z w O 1\ z z z z w z w �D �7 w a O O �D w a �D w Uz Uz w \ .l +-) co a) w w w w H rt w x O w O W x a +- a W a +) W a O O x H U H U a) U x W a W a W a ri W W a a U H H w w U -ri —1 -ri U a) U W L14 .l W L14 .li L14 H H W ,S,' r1 O ,s; W L14 L14 L14 J-) U1 Pa W u Q� Q� Q �� U > u 0> Q Q Q Q a ;l, M u H z z H H H n O U O H h W w I-- u a U H H x 0 O H GW -1 H GH -1 0 F-4 oa z w a H x a u u x w w o 0 h a a H H H a u u Q Q Q w w w 0. �D H H O N n r o w a � H H H N N N x � w H a H w w oa xQ w w w w a C w x H C7 0. pa U U U U U H H H H H H H H O O O O O O Cl H co LO l0 I— Oo N N O O O O O O O �o �o �o �o �o �o �o N N N N N w w w w w w w H H H C7 C7 C7 C7 C7 C7 C7 C7 H H H H H H H O O O O O O O N N N N N N N N N N N N N N N F-4 H H H H H H H a ;l, M z z H H n O H h a w u a U H H x H GW -1 H GH -1 0 F-4 oa z w H x a u u u h a a H H H a u u Q Q Q w w w N n r O H n O H H H H N N N w w w w w w w w C7 C7 C7 C7 C7 C7 C7 C7 H H H H H H H H O O O O O O O O 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 a w H N H H H D EO � N z\ O z\ H N U �D o o +� a N a O \ , N S-14 pN U a \ U) a Q w � a O a z w w w F FX N U1 Q a z x m U � w Q U U w x U � n 00 o 0 O O oc) is O un un N 61 H H M 0 0 H 61 O 3' l0 H H 0) O O I I O O O O un N CSl N u� l0 N l0 CSl H l0 �' H N N Ln H N I I Q h M M x Ln M cn h CSl CSl CSl Oo Z7 a O N N H a w H N H H H D EO � N z\ O z\ H N U �D o o +� a N a O \ , N S-14 pN U a \ U) a Q w � a O a z w w w F FX N U1 Q a z x m U � w Q U U w x U � n 00 o 0 O O oc) O O I I 31 I I h un 0 0 oo O OJ OJ O M O I I O I I O O O O un O O I I I I I W I I I I I a I I Q h M M x Ln M cn h CSl CSl CSl h Z7 a O O O N H 0) O z 0) 61 of of of of Oo O O O O I I H H M I u7 I H I H I H I I I I H N N N x I u7 I in N O O O (V O O 0. O O O O O M M o a o 3' H C7 a H 3' 3' CD cn 3' oo O rG rn N N N H N Q0 Q0 ri ri Ln C7 Ln + z Q0 cn cn z li 04 z � F a U1 a s x 4-) x W W U S U x w x U cn H U z i i ,3' H O 3' H f� M l0 H N O N O 61 3' 31 M CSl l0 un Q0 H H l0 O 61 N m M [-- ,31 ,3' l0 N O H N H H H O ,3' H 61 H N O O O O O ,3' O O O O O M O O Ln Ln 0 un O l0 M M N H O H H M � 00 00 o n oc) oc) 31 31 31 31 31 0 0 0 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 h M M O Ln M N h CSl CSl CSl h O O O O O 0) 0) O oo 0) 61 of of of of Oo O O O O I I H H I H I u7 I H I H I H I I I I H N N N I H I u7 I in I I in in O O O M O O O O O O O O M M M M ,3' 3' 3' N 3' 3' 3' 3' 3' 3' 3' 3' N N N N H � H O � H rt O Q0 I un Q0 � � z ro 4-) O x a) U U U z O H H 'Z, ri ri U1 a) a) Q a -li ro o C) Q Q Q Ul W W J-) .H I I H W W W w FA a) a � li a) +� +� 00 a a a a �a, a TI Si S; M a a a a x a a rt a) a) 1-0 a a a a w Ln z a a Q a .� Q Q Q Q z n W z z z z z Z:7) � w x � H � tr tr w H �D �D �D � w H H -ri rt a) W W C7 rt w w w w +- .H r1 .11 W W W W S: a H S -I S -I US -I S -I S -I a a a a a U .li a) a) U a) Pa H U) ,7 J-) ,S,' �:,5.,' W J-) Pa Pa Pa Pa S-1 W H H '� rt a) O +) x rt W W W W H Q �D X> w O U Q Q Q Q O U H a a x �D W Z O H U1 a U H U1 W FG \ W U1 H W W f24 w a a w 0 h z H H W z Q a W z O cn z O cn z H H qq FC C'J > C+ O FxG a Pad Q 0 x u u u H w o H 0 3 x x x x x x H f7 f7 f7 fD H M Oo 61 Cl H N M M M M M M M LO LO LO LO LO LO LO LO Lo LO z z z z z z z z z z z w w w w w w w w w w w C7 C7 C7 C7 C7 C7 C7 C7 C7 C7 C7 H H H H H H H H H H H 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 H D EO � N z\ O z\ H N U �D o o +� a N Q O \ , N S4 -I N U E1 \ U) a a Q w � a o a z w w w F FX N � Q a z x m u � w Q u u w x u Ln O O O O n O O O O O n n O O O O h O O O O N O O O O Ln N h O un un O . . . . . . . . . . . . . . . . M O un un O. l0 un 00 O Ln M N O 61 l0 H h M 00 61 M N 31 M N N N 31 oc) oo M H 61 H H M un O n L Ln Ln N H 0 0 0 0 0 0 0 0 0 0 0 0 03 o o �.o 03 o O O O O O O O O O O O O O O O O O O I I 0 0 I 0 I 0 I 0 I 0 I 0 I 0 I 0 I 0 I 0 I 0 I H I o I o I I I M H o O O O 03 O O O O O O O O N O O O N O O O O M O O O O O O O O 61 O O 61 61 O I I I I I I I I I I I I I I I I I I M M M O M M M M M M M M O M M O O M N N N H N N N N N N N N 3' N N 3' 3' N Q w a a \ Q F-4 W a a w Q C7 Uz H w a a H a x Uz H \ cn rx Uz a O H \ F-4 'D 7 z IH H U1 w b H x o a H Q Q Q Q Q Q Q Q Q Q Q Q Q a O O w w w w w w w w w w w + w w W a, H H Pa a a a a a a a a a a a a a a x Q0 a a a a a a a a a a a a a cn Q0 a a a a a a a a a a a a a a Q0 Q z w \ Q un w a Q O z a H H 0 z a u a o w o ,7 ,7 ,7 Er) ,7 ,7 ,7 w H v) UZ u a F-4 w w N w w w w w w w w ri w w H H C7 W W W U W W W W W W W W +) W W U W x x a U? H .D W W H O O O O O O O Q W H O h h a a a h a a a a a a a a x a a a w w w w w w W W W W W W W W O H x Q Q Q U1 Q Q Q Q Q Q Q Q FC Q Q U H U Q w a a \ Q F-4 W a a w Q Uz w H Uz Uz O F-4 z H x o a H �D U? cwn a H W H a o H w a z w a z Q z w °a w a Q O z a H H 0 z a u a o w o z w w H 3 u a H H x a \ x U1 U1 x N H Q U1 U1 U? W x x a U? H .D W W H O O O O O O O Q W H O h h h h h h h h h h h x x a a W O co LO l.0 f`� 61 O LO LO LO LO LO LO LO LO LO LO LO LO LO LO LO LO LO LO LO LO z z z 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 w w w C7 C7 C7 C7 C7 C7 C7 C7 C7 C7 C7 C7 C7 C7 C7 C7 C7 H H H H H H H H H H H H H H H H 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 \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ F-4 H H H H H H H H H H H H H H H H Q w a a \ Q F-4 W a a w Q O W H E� H H H D EO � N z\ O z\ H N U �D O o +� a N a O \ , N S4 -I p\ N U m a a Q w � a O a z w w w F FX N � Q a �D x cQ u u1 W Q u U w x u a ZH- 14 u U � H a 1i x 00 � M � N b O O -ri Ul h -) ri 1J O O Q N f7 J-) •• x � H .D Q O O N O O O O 3' r-- CD �O O un O O un O N O h Ln O O l0 H O H l0 h M O H M O H 31 l0 O H N H O O O O 3' O un O f� un H un O O Ln 31 O Ol un Ol h O N Ln O N CSl H 31 N M Ln 61 h Ln 0 o t� o 0 o n Oo Oo x o 0 0 o n o n o Oo Oo 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 I I I a I I I I I I I I I I O O H O O O un N N W O O O O l0 O un O N N O O Ol O O O OJ Ol Ol O O O O OJ O OJ O Ol Ol I I in in I H I u7 I N I in I H I I H H I u7 I in I in I in I N I in I H I u7 I I H H M M O a M O O O M M M M O M O M O O z H ° w o u a z w a ° a a U) w H a x z u U u H H W W W W W W Ol Ol Ol W OD 61 r r r z r r r r C7 C7 C7 C7 C7 C7 �o z w w w w w w w w O O O O O O O O O C7 C7 C7 C7 C7 C7 C7 C7 U a) O O O O O O O N N a N N N N N N N N N N +� N N N N H H H H H W H H H ri H H H H H H H H H z H Ha) U1 U1 W I +) W W W cn rt W W H W cn W W a H H U1 H a H Ui H H H H H J-) H W W a a Ul a I a 0-)a a a a a O a u u M a a a w a w a a a a a a) a rn a a U a u a Q 0 a a a a a H a l0 FC FC FC 7y FC H Ln FC FC FC FC FC W FC Ln \ \ rG \ \ crz Q Q Q fFx4 Q H Q Q Q Q Q Q cn cn �D �D .1 �D U) �D O z z W �D �D �D �D H �D a) H H W W W U W z W O O i7 w W W W rt W W i7 W W W H W I x x W W W W ri W +) W x x a a a a a s .Y, a a a a f a i a H H .4 W W W W U a) H a s U a a U a w a z a s w a a a a +) a li a w W W O W H W H W W x W W W W rt W +) W W W x Q Q Q Q a Q a H H u Q Q Q Q x Q �D Q x x u O x u a w H z 3 a H � w z a Q w a W H a w u w a z o x z w Q a w a H w H 0 a a a z H ° w o u a z w a ° a a U) w a x z u z u H H W W W W W W Ol Ol Ol OD 61 r r r r r r r r C7 C7 C7 C7 C7 C7 �o �o �o w w w w w w w w O O O O O O O O O C7 C7 C7 C7 C7 C7 C7 C7 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 H H H H H H H H H W H H H H H H H H x a 3 � z w u w z o x z w w a H H °a � a w H w a ca xn a a a a a U) H H Ol O N co W W W W W W Ol Ol Ol w w w w w w w w w C7 C7 C7 C7 C7 C7 C7 C7 C7 H H H H H H H H H 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 H H H H H H H H H I O O n cc) O oo n O O Q0 rn rn Q0 H Ln Ln O O Ln i, N O un un 61 oo [-- -1 H M H h l0 M N 0 M +-) W J-) u N 61 Cl H 61 61 x O Cl zr W w Q � o O 0 O o0 O o0 o0 O O a-1 I I I I I a au w a O w w w �a O O N N N 0 0 O O 61 61 61 U �D L U H H H U O x a H H H a a0 �D M N M N O 3' O O 3' �1' w H E� H H H D EO � N z\ 0 z\ H N U N � �D o o +� a N a o \ , N S4 -I pN U a \ U) a Q w � a 0 a z w w w F FX N � Q a z x m 0 � w Q 0 x 0 w x 0 a ZH- 14 U N u � H a 1i x 00 � N b O O -ri Ul h -) ri 1J CD U Q N f7 J-) H .D Q H un N z w N a � w w Q ww z z 0 0 x x � N N Q z w w w 0 0 F4 x x 0 0 .i. co co w w H H z z H H W J-) u N 61 Cl H 61 61 x O Cl zr W w H � cn Q rt kO kO Q w F-4 a au w a O w w w �a 0 O cn a H 0 0 Q Q a Q o 0 w w �D L U H H H O x a z w a a0 �D 5 5 N D4 D4 u w � \ \ u a w Q Q H \ a o � � z 0 wn F-4 O w W w H x a a a x H a w rt rt a a H a N J-) w w w O Q Q H a H N z w N a � w w Q ww z z 0 0 x x � N N Q z w w w 0 0 F4 x x 0 0 .i. co co w w H H z z H H W u 61 Cl H 61 61 a O Cl W cn H cn cn kO kO kO Q w w � a au w a O w w w �a 0 a H 0 0 0 0 Q o 0 H w L U H H H O x a z w H H �D 5 5 N z w N a � w w Q ww z z 0 0 x x � N N Q z w w w 0 0 F4 x x 0 0 .i. co co w w H H z z H H 61 Cl H 61 61 61 O Cl kO kO kO w w w w w 0 0 0 0 0 0 O O O O O N N N N N N F-4 H H H H H N z w N a � w w Q ww z z 0 0 x x � N N Q z w w w 0 0 F4 x x 0 0 .i. co co w w H H z z H H HUTCHINSON UTILITIES COMMISSION COMBINED DIVISIONS FINANCIAL REPORT FOR NOVEMBER, 2017 Salaries & Benefits Purchased Commodities Transmission Generator Fuel/Chem. Depreciation Transfers (Elect./City) Operating Expense Debt Interest TOTAL EXPENSES NET PROFIT/(LOSS) $ 427,617 $ 449,720 $ (22,103) $ 1,742,395 $ 1,460,874 $ 281,521 $ 185,455 $ 161,752 $ 23,703 $ 30,848 $ 46,653 $ (15,805) $ 317,333 $ 311,526 $ 5,807 $ 154,003 $ 150,657 $ 3,345 $ 125,330 $ 135,840 $ (10,510) $ 61,258 $ 67,676 $ (6,418) $ 3,044,240 $ 2,784,698 $ 259,542 $ 394,298 $ 459,337 $ 91.6% of Year Comp. 2017 2016 pi . Combined Division Di % Chnq Full Yr Bud % of Bud Customer Revenue $ 3,074,661 $ 2,676,041 $ 398,620 Sales for Resale $ 180,357 $ 162,420 $ 17,937 NU Transportation $ 74,899 $ 70,466 $ 4,434 Electric Division Transfer $ 54,308 $ 53,931 $ 378 Other Revenues $ 42,852 $ 278,713 $ (235,861) Interest Income $ 11,460 $ 2,465 $ 8,995 TOTAL REVENUES $ 3,438,537 $ 3,244,035 $ 194,503 Salaries & Benefits Purchased Commodities Transmission Generator Fuel/Chem. Depreciation Transfers (Elect./City) Operating Expense Debt Interest TOTAL EXPENSES NET PROFIT/(LOSS) $ 427,617 $ 449,720 $ (22,103) $ 1,742,395 $ 1,460,874 $ 281,521 $ 185,455 $ 161,752 $ 23,703 $ 30,848 $ 46,653 $ (15,805) $ 317,333 $ 311,526 $ 5,807 $ 154,003 $ 150,657 $ 3,345 $ 125,330 $ 135,840 $ (10,510) $ 61,258 $ 67,676 $ (6,418) $ 3,044,240 $ 2,784,698 $ 259,542 $ 394,298 $ 459,337 $ Because of the early meeting time this month a few estimates were used but most of the high dollar items are accurate. 2017 91.6% of Year Comp. Chnq 2017 2016 10NNNNNNNN� Di % Chnq Full Yr Bud % of Bud 14.9% $ 31,938,579 $ 31,147,148 $ 791,432 2.5% $ 36,743,052 86.9% 11.0% $ 1,988,774 $ 1,767,561 $ 221,214 12.5% $ 2,310,110 86.1% 6.3% $ 830,777 $ 767,939 $ 62,838 8.2% $ 734,878 113.0% 0.7% $ 597,391 $ 593,236 $ 4,155 0.7% $ 651,700 91.7% (84.6%) $ 681,929 $ 792,764 $ (110,834) (14.0%) $ 498,808 136.7% 364.9% $ 126,255 $ 49,778 $ 76,477 153.6% $ 100,000 126.3% 6.0% $ 36,163,705 $ 35,118,424 $ 1,045,281 3.0% $ 41,038,548 88.1% (4.91%) $ 5,044,955 $ 5,231,633 $ (186,677) (3.6%) $ 6,005,227 84.0% 19.3% $ 18,056,422 $ 17,120,191 $ 936,230 5.5% $ 20,990,267 86.0% 14.7% $ 2,311,722 $ 2,124,648 $ 187,074 8.8% $ 2,550,000 90.7% (33.9%) $ 845,097 $ 1,082,233 $ (237,136) (21.9%) $ 1,249,801 67.6% 1.9% $ 3,490,667 $ 3,443,000 $ 47,667 1.4% $ 3,808,000 91.7% 2.2% $ 1,694,028 $ 1,645,185 $ 48,842 3.0% $ 1,700,647 99.6% (7.7%) $ 1,966,401 $ 1,769,556 $ 196,845 11.1% $ 2,583,006 76.1% (9.5%) $ 692,957 $ 744,436 $ (51,479) 6.9% $ 760,588 91.1% 9.3% $ 34,102,249 $ 33,160,883 $ 941,366 2.8% $ 39,647,536 86.0% (14.2%) $ 2,061,457 $ 1,957,542 $ 103,915 5.31% $ 1,391,013 148.2% Because of the early meeting time this month a few estimates were used but most of the high dollar items are accurate. 2017 HUC Budget Target 30.0% 10NNNNNNNN� 4.5%hP��llNllNldl November November YTD YTD 2017 2016 Change 2017 2016 Change Gross Margin % 35.7% 36.0% -0.3% 32.9% 33.8% -0.9% Operating Income Per Revenue $ (%) 12.4% 8.9% 3.4% 6.0% 6.1% -0.2% Net Income Per Revenue $ (%): 11.5% 14.2% -2.7% 5.7% 5.6% 0.1% Because of the early meeting time this month a few estimates were used but most of the high dollar items are accurate. 2017 HUC Budget Target 30.0% 10NNNNNNNN� 4.5%hP��llNllNldl 3.4% HUTCHINSON UTILITIES COMMISSION ELECTRIC DIVISION FINANCIAL REPORT FOR NOVEMBER, 2017 NOW 91.6% of Year Comp. 2.2% 2017 2016 1.6% 2E % Chng 2017 2016 $0.0859 2E % Chng Full Yr Bud % of Bud Electric Division Total Power Supply Exp. per KWH: $0.0711 $0.0655 $0.0056 $0.0730 $0.0689 $0.0041 $0.0758 Customer Revenue 1,906,238 1,776,701 129,537 7.3% 23,240,158 22,958,935 281,222 1.2% 25,185,461 92.3% Sales for Resale 180,357 162,420 17,937 11.0% 1,988,774 1,767,561 221,214 12.5% 2,310,110 86.1% Other Revenues 19,414 21,139 (1,725) (8.2%) 419,218 324,794 94,424 29.1% 280,200 149.6% Interest Income 5,730 1,233 4,498 364.9% 63,127 24,889 38,238 153.6% 50,000 126.3% TOTALREVENUES 2,111,738 1,961,493 150,246 7.7% 25,711,278 25,076,179 635,098 2.5% 27,825,771 92.4% Salaries & Benefits 341,091 348,612 (7,521) (2.2%) 3,958,536 4,097,701 (139,165) (3.4%) 4,727,135 83.7% Purchased Power 1,076,919 917,125 159,794 17.4% 13,060,202 12,351,604 708,598 5.7% 14,208,043 91.9% Transmission 185,455 161,752 23,703 14.7% 2,311,722 2,124,648 187,074 8.8% 2,550,000 90.7% Generator Fuel/Chem. 30,848 46,653 (15,805) (33.9%) 845,097 1,082,233 (237,136) (21.9%) 1,249,801 67.6% Depreciation 233,333 225,000 8,333 3.7% 2,566,667 2,475,000 91,667 3.7% 2,800,000 91.7% Transfers (Elect./City) 123,408 116,803 6,605 5.7% 1,357,491 1,277,003 80,488 6.3% 1,333,516 101.8% Operating Expense 92,524 100,682 (8,159) (8.1%) 1,389,040 1,235,296 153,744 12.4% 1,746,330 79.5% Debt Interest 2,551 (2,551) (100.0%) 19,116 28,061 (8,946) (31.9%) 25,488 75.0% TOTAL EXPENSES 2,083,579 1,919,179 164,401 8.6% 25,507,870 24,671,546 836,324 3.4% 28,640,313 89.1% NET PROFIT/(LOSS) 28,159 42,314 (14,155) (33.5%)j $ 203,408 $ 404,633 $ (201,225) (49.7%) $ (814,542) (25.0%) 91.6% of Year Comp. 2017 2016 % Chng 2017 2016 2E % Chng Full Yr Bud % of Bud Electric Division Residential 3,897,856 3,560,322 337,534 9.48% 44,828,258 46,095,182 (1,266,924) (2.75%) 50,432,797 88.9% All Electric 247,527 181,866 65,661 36.10% 2,072,190 2,071,521 669 0.03% 2,611,705 79.3% Small General 1,481,281 1,332,002 149,279 1 . b 16,310,603 16,269,005 41,598 0.26 o 1 5,853 95.5% Large General 6,041,963 5,866,757 175,206 2.99% 68,951,343 67,869,279 1,082,064 1.59% 79,262,499 87.0% Industrial 9,651,000 9,748,000 (97,000) (1.00%) 124,319,000 128,746,000 (4,427,000) (3.44%) 134,707,856 92.3% Total KWH Sold 21,319,627 20,688,947 630,680 3.05% 256,481,394 261,050,987 (4,569,593) (1.75%) 284,100,710 90.3% November November YTD YTD 2017 HLIC 2017 2016 Change 2017 2016 Change Budget Targe Gross Margin % 27.9% 30.9% -3.0% 26.2% 28.0% -1.8% 22.5% Operating Income Per Revenue 0.8% 2.2% -1.4% -0.4% 1.4% -1.8% -3.0% 0%-5% Net Income Per Revenue $ (%): 1.3% 2.2% -0.8% 0.8% 1.6% -0.8% -2.9% Customer Revenue per KWH: $0.0894 $0.0859 $0.0035 $0.0902 $0.0875 $0.0026 $0.0881 Total Power Supply Exp. per KWH: $0.0711 $0.0655 $0.0056 $0.0730 $0.0689 $0.0041 $0.0758 The Electric division in November 2017 had a net profit decline of $14,155. Increased Customer Revenue was mainly due to the power cost adjustment as usage was relatively flat. Sales for Resale of $180,357 consisted of $17,455 in market sales, $34,400 in the monthly tolling fee from Transalta, $32,502 in energy sales to Transalta, and $96,000 in capacity sales to SMMPA. November 2016 Sales for Resale of $162,420 consisted of $6,316 in market sales, $34,400 in monthly tolling fees from Transalta, $55,204 in Transalta energy sales, and $66,500 in capacity sales to SMMPA. November 2015 Sales for Resale of $86,361 consisted of $3,530 market sales, $34,400 in Transalta tolling fees, $6,431 in Transalta energy sales, and capacity sales to SMMPA for $42,000. Overall Purchased Power increased by $159,794. MRES purchases increased by $46,171 and market purchases/MISO costs increased by $113,623. The power cost adjustment for November 2017 was $.0048/kwhr bringing in an additional $101,312 of revenue for the month and $1,614,026 for the year. Last year's power cost adjustments through November 2016 generated $687,476 in additional revenue. Total PCA collections through October 2015 were $385,433 HUTCHINSON UTILITIES COMMISSION GAS DIVISION FINANCIAL REPORT FOR NOVEMBER, 2017 Salaries & Benefits $ 2017 2016 2E Gas Division $ 665,476 $ 543,749 $ 121,728 Customer Revenue $ 1,168,423 $ 899,340 $ 269,084 Transportation $ 74,899 $ 70,466 $ 4,434 Electric Div. Transfer $ 54,308 $ 53,931 $ 378 Other Revenues $ 23,438 $ 257,574 $ (234,136) Interest Income $ 5,730 $ 1,233 $ 4,498 TOTAL REVENUES $ 1,326,799 $ 1,282,542 $ 44,257 Salaries & Benefits $ 86,526 $ 101,108 $ (14,582) Purchased Gas $ 665,476 $ 543,749 $ 121,728 Operating Expense $ 32,806 $ 35,157 $ (2,351) Depreciation $ 84,000 $ 86,526 $ (2,526) Transfers (City) $ 30,594 $ 33,854 $ (3,260) Debt Interest $ 61,258 $ 65,125 $ (3,867) TOTAL EXPENSES $ 960,661 $ 865,520 $ 95,141 NET PROFIT/(LOSS) $ 366,138 $ 417,023 $ (50,884) (14.4%) 91.6% of Year Comp. %Chna 2017 2016 2E %Chna Full Yr Bud %of Bud 29.9% $ 8,698,422 $ 8,188,212 $ 510,209 6.2% $ 11,557,591 75.3% 6.3% $ 830,777 $ 767,939 $ 62,838 8.2% $ 734,878 113.0% 0.7% $ 597,391 $ 593,236 $ 4,155 0.7% $ 651,700 91.7% (90.9%) $ 262,711 $ 467,969 $ (205,258) (43.9%) $ 218,608 120.2% 364.9% $ 63,127 $ 24,889 $ 38,238 153.6% $ 50,000 126.3% 3.5% $ 10,452,428 $ 10,042,245 $ 410,183 4.1% $ 13,212,777 79.1% (14.4%) $ 1,086,420 $ 1,133,932 $ (47,512) (4.2%) $ 1,278,092 22.4% $ 4,996,220 $ 4,768,587 $ 227,633 4.8% $ 6,782,224 (6.7%) $ 577,361 $ 534,260 $ 43,101 8.1% $ 836,676 (2.9%) $ 924,000 $ 968,000 $ (44,000) (4.5%) $ 1,008,000 (9.6%) $ 336,537 $ 368,182 $ (31,646) (8.6%) $ 367,131 0.0% $ 673,842 $ 716,375 $ (42,533) JL22L $ 735,100 11.09/c $ 8,594,379 $ 8,489,337 $ 105,042 1.2% $ 11,007,223 (12.2%) $ 1,858,049 $ 1,552,908 $ 305,140 19.6% $ 2,205,554 85.0% 73.7% 69.0% 91.7% 91.7% 91.7% 78.1% 84.2% I WiM November 91.6% of Year Comp. 2017 2016 Di %Chnq 2017 2016 Di %Chnq Full YrBud %of Bud Gas Division Change Budget Target Gross Margin % 48.2% 45.8% 2.4% 49.6% 49.0% 0.7% Residential 49,622,691 33,766,088 15,856,603 46.96% 322,315,746 306,293,953 16,021,793 5.23% 449,582,000 71.7% Commercial 44,411,292 25,394,319 19,016,973 74.89% 271,378,259 233,104,977 38,273,282 16.42% 420,183,000 64.6% Industrial 90,907,408 70,418,817 20,488,591 29.10%1 765,029,230 696,448,808 68,580,422 9.85% 786,836,000 97.2% Total CF Sold 184,941,391 129,579,224 55,362,167 42.72% 1,358,723,235 1,235,847,738 122,875,497 9.94% 1,656,601,000 82.0% Net Profit for November 2017 decreased by $50,884 in the gas division over November 2016. However, there was a $236,000 payment received on the Lafayette improvements in Other Revenues in November 2016. The increase in net profit on normal operations would have been $185,116 over last year without that payment. The fuel credit adjustment for November 2017 was $1.3624/MCF providing credits to the customers of $135,413 for the month and $658,502 for the year. Fuel credit adjustments totalled $44,625 through November of 2016. November November YTD YTD 2017 HUC 2017 2016 Change 2017 2016 Change Budget Target Gross Margin % 48.2% 45.8% 2.4% 49.6% 49.0% 0.7% 46.2% IIIIIIIIIIIIIIIIIIIIIIII �� Operating Income Per Revenue $ (%) 30.9% 21.8% 9.1% 21.9% 18.6% 3.3% 20.6% Net Income Per Revenue $ (%): 28.2% 40.7% -12.5% 18.3% 16.3% 2.1% �pyN�NNpNp�p�p�p�N� 17.0% ��MflIII�IIIIIIIIIIppIIppIIppIIppIIpp Contracted Customer Rev. per CF: $0.0038 $0.0036 $0.0002 $0.0038 $0.0034 $0.0004 $0.0041 �NIIIIIIIIII Customer Revenue per CF: $0.0087 $0.0109 -$0.0022 $0.0098 $0.0108 -$0.0010 $0.0096 Total Power Supply Exp. per CF: $0.0036 $0.0043 ($0.0006) $0.0038 $0.0039 ($0.0002) $0.0042 Net Profit for November 2017 decreased by $50,884 in the gas division over November 2016. However, there was a $236,000 payment received on the Lafayette improvements in Other Revenues in November 2016. The increase in net profit on normal operations would have been $185,116 over last year without that payment. The fuel credit adjustment for November 2017 was $1.3624/MCF providing credits to the customers of $135,413 for the month and $658,502 for the year. Fuel credit adjustments totalled $44,625 through November of 2016. Current Assets Unrestricted/Undesignated Cash Cash Petty Cash Designated Cash Capital Expenditures - Current Yr Payment in Lieu of Taxes Rate Stabilization - Electric Rate Stabiliation - 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, 2017 Electric Gas Total Total Net Change Division Division 2017 2016 Total (YTD) 21,567,477.21 3,255,128.74 24,822,605.95 11,957,182.01 12,865,423.94 680.00 170.00 850.00 850.00 - 113,365.34 1,261,751.93 1,375,117.27 475,650.36 899,466.91 829,200.00 367,131.00 1,196,331.00 1,305,256.00 (108,925.00) 314,539.41 - 314,539.41 452,283.25 (137,743.84) - 646,058.37 646,058.37 566,773.20 79,285.17 400,000.00 100,000.00 500,000.00 500,000.00 - 137,946.88 - 137,946.88 11,402.72 126,544.16 - 2,118,025.05 2,118,025.05 195,375.00 1,922,650.05 - 2,188,694.02 2,188,694.02 2,188,694.02 - 23,363,208.84 9,936,959.11 33,300,167.95 17,653,466.56 15,646,701.39 1,693,616.89 1,273,739.14 2,967,356.03 2,799,771.85 167,584.18 22,224.58 9,191.09 31,415.67 - 31,415.67 1,715,841.47 1,282,930.23 2,998,771.70 2,799,771.85 198,999.85 1,244,724.85 411,077.91 1,655,802.76 1,473,587.34 182,215.42 (19,722.52) 37,193.77 17,471.25 9,447.73 8,023.52 177,415.66 - 177,415.66 144,352.89 33,062.77 1,746,060.00 - 1,746,060.00 388,200.00 1,357,860.00 - 582,020.00 582,020.00 129,400.00 452,620.00 3,148,477.99 1,030,291.68 4,178,769.67 2,144,987.96 2,033,781.71 28,227,528.30 12,250,181.02 690,368.40 89,042,232.08 (52, 572, 592.08) 3,798,724.58 40,958,732.98 3,901,323.35 41,260,565.70 (15,249,901.36) 287,424.21 30,199,411.90 40,477,709.32 22,598,226.37 17,879,482.95 4,591,691.75 4,590,287.00 1,404.75 130,302,797.78 129,510,003.63 792,794.15 (67,822,493.44) (64,186,667.19) (3,635,826.25) 4,086,148.79 1,007,725.69 3,078,423.10 71,158,144.88 70,921,349.13 236,795.75 Total Assets 69,186,261.28 42,449,592.92 111,635,854.20 93,519,575.50 18,116,278.70 HUTCHINSON UTILITIES COMMISSION BALANCE SHEET - CONSOLIDATED NOVEMBER 30, 2017 Total Liabilities and Net Position 69,186,261.28 42,449,592.92 111,635,854.20 93,519,575.50 18,116,278.70 Electric Gas Total Total Net Change Division Division 2017 2016 Total (YTD) Current Liabilities Current Portion of Long-term Debt Bonds Payable - 1,220,000.00 1,220,000.00 1,285,000.00 (65,000.00) Bond Premium - 185,608.32 185,608.32 185,608.32 - Accounts Payable 2,164,877.48 1,208,340.67 3,373,218.15 4,342,216.03 (968,997.88) Accrued Expenses Accrued I nterest (1,132.86) 0.20 (1,132.66) - (1,132.66) Accrued Payroll (3,411.62) 42,384.49 38,972.87 305,445.82 (266,472.95) Total Current Liabilities 2,160,333.00 2,656,333.68 4,816,666.68 6,118,270.17 (1,301,603.49) Long -Term Liabilities Noncurrent Portion of Long-term Debt 2017 Bonds 17,172,913.31 - 17,172,913.31 465,000.00 16,707,913.31 2012 Bonds - 13,975,000.00 13,975,000.00 15,255,000.00 (1,280,000.00) Bond Premium 2012 - 1,484,866.19 1,484,866.19 1,670,474.51 (185,608.32) Pension Liability- Electric 4,226,202.00 - 4,226,202.00 2,775,239.00 1,450,963.00 Pension Liability- Nat Gas - 1,408,734.00 1,408,734.00 925,080.00 483,654.00 Accrued Vacation Payable 286,389.60 92,553.90 378,943.50 356,049.33 22,894.17 Accrued Severance 66,478.09 25,572.23 92,050.32 90,772.86 1,277.46 Deferred Outflows - Electric 569,910.00 - 569,910.00 396,226.00 173,684.00 Deferred Outflows - Nat Gas - 189,970.00 189,970.00 132,076.00 57,894.00 Total Long -Term Liabilities 22,321,893.00 17,176,696.32 39,498,589.32 22,065,917.70 17,432,671.62 Net Position Retained Earnings 44,704,035.28 22,616,562.92 67,320,598.20 65,335,387.63 1,985,210.57 Total Net Position 44,704,035.28 22,616,562.92 67,320,598.20 65,335,387.63 1,985,210.57 Total Liabilities and Net Position 69,186,261.28 42,449,592.92 111,635,854.20 93,519,575.50 18,116,278.70 Hutchinson Utilities Commission Cash -Designations Report, Combined 11/30/2017 Savings, Checking, Investments varies varies Total Operating Funds Debt Reserve Requirements Bond Covenants - sinking fund Debt Reserve Requirements Bond Covenants -1 year Max. P & I Total Reserve Requirement varies 33,300,167.95 19,840,193.14 13,459,974.81 33,300,167.95 19,840,193.14 13,459,974.81 2,255,971.93 2,093,046.92 162,925.01 2,188,694.02 2,188,694.02 - 4,444,665.95 4,281,740.94 162,925.01 Operating Reserve Min 60 days of 2017 Operating Bud. 5,973,256.00 5,973,256.00 Rate Stabalization Funds HUC Change in 960,597.78 Financial Charter 1,196,331.00 Balance, Balance, Cash/Reserve 500,000.00 Institution Current Interest Rate Annual Interest November 2017 October 2017 Position 3.06 12,080,184.78 12,080,184.78 RONA 0.80% 0.05% 1.31% 2.17% Savings, Checking, Investments varies varies Total Operating Funds Debt Reserve Requirements Bond Covenants - sinking fund Debt Reserve Requirements Bond Covenants -1 year Max. P & I Total Reserve Requirement varies 33,300,167.95 19,840,193.14 13,459,974.81 33,300,167.95 19,840,193.14 13,459,974.81 2,255,971.93 2,093,046.92 162,925.01 2,188,694.02 2,188,694.02 - 4,444,665.95 4,281,740.94 162,925.01 Operating Reserve Min 60 days of 2017 Operating Bud. 5,973,256.00 5,973,256.00 Rate Stabalization Funds HUC 960,597.78 960,597.78 PILOT Funds Charter 1,196,331.00 1,196,331.00 Catastrophic Funds Risk Mitigation Amount 500,000.00 500,000.00 Capital Reserves 5 Year CIP ( 2017-2021 Fleet & Infrastructure Maintenance) 3,450,000.00 3,450,000.00 Total Earmarked Funds 3.06 12,080,184.78 12,080,184.78 YE YE YE YE YTD HUC 2013 2014 2015 2016 2017 Target Debt to Asset 29.7% 28.8°% 32.0°% 32.2°% 39.7°% Current Ratio 2.08 2.26 2.52 3.06 7.00 18,112,875 RONA 0.80% 0.05% 1.31% 2.17% 2.06% Ftt Total and Electric cash increased significantly due to receiving $17 million in bond proceeds. Change in Cash Balance (From 12/31/14 to 11/30/2017) Month End Electric Elec. Change Natural Gas Gas Change Total Total Change 11/30/2017 23,363,209 9,936,959 33,300,168 12/31/2016 8,612,801 14,750,408 9,500,074 436,885 18,112,875 15,187,293 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 Total and Electric cash increased significantly due to receiving $17 million in bond proceeds. Hutchinson Utilities Commission Cash -Designations Report, Electric 11/30/2017 Savings, Checking, Investments varies varies varies 33,300,167.95 19,840,193.14 13,459,974.81 Total HUC Operating Funds 33,300,167.95 19,840,193.14 13,459,974.81 Debt Restricted Requirements Bond Covenants - sinking fund 137,946.88 137,946.88 Operating Reserve Min 60 days of 2017 Operating Bud. 4,306,719.00 4,306,719.00 Rate Stabalization Funds $400K -$1.2K Change in 314,539.41 Financial Charter 829,200.00 Balance, Balance, Cash/Reserve 400,000.00 Institution Current Interest Rate Annual Interest November 2017 October 2017 Position Current Ratio 2.77 8,600,458.41 8,600,458.41 3.57 12.19 1.81 NN �I Savings, Checking, Investments varies varies varies 33,300,167.95 19,840,193.14 13,459,974.81 Total HUC Operating Funds 33,300,167.95 19,840,193.14 13,459,974.81 Debt Restricted Requirements Bond Covenants - sinking fund 137,946.88 137,946.88 Operating Reserve Min 60 days of 2017 Operating Bud. 4,306,719.00 4,306,719.00 Rate Stabalization Funds $400K -$1.2K 314,539.41 314,539.41 PILOT Funds Charter 829,200.00 829,200.00 Catastrophic Funds Risk Mitigation Amount 400,000.00 400,000.00 Capital Reserves 5 Year CIP ( 2017-2021 Fleet & Infrastructure Maintenance) 2,750,000.00 2,750,000.00 Total Designated Funds Current Ratio 2.77 8,600,458.41 8,600,458.41 3.57 12.19 YE YE YE YE YTD APPA Ratio HUC 2013 2014 2015 2016 2017 5K -10K Cust. Target Debt to Asset Ratio 8.0% 7.4% 13.2% 16.1% 35.4% 29.5% VIII Current Ratio 2.77 2.48 2.95 3.57 12.19 1.81 NN �I RONA -2.7% -3.1% -1.2% -0.4% 0.3% NA Electric Division cash increased significantly due to receiving $17 million in bond proceeds. Hutchinson Utilities Commission Cash -Designations Report, Gas 11/30/2017 Savings, Checking, Investments Total HUC Operating Funds varies varies varies 33,300,167.95 19,840,193.14 13,459,974.81 Debt Restricted Requirements Bond Covenants - sinking fund Debt Restricted Requirements Bond Covenants -1 year Max. P & I Total Restricted Requirements 33,300,167.95 19,840,193.14 13,459,974.81 2,118,025.05 1,955,100.04 162,925.01 2,188,694.02 2,188,694.02 - 4,306,719.07 4,143,794.06 162,925.01 Operating Reserve Min 60 days of 2017 Operating Bud. 1,666,537.00 1,666,537.00 Rate Stabalization Funds $200K -$600K Change in 646,058.37 Financial Charter 367,131.00 Balance, Balance, Cash/Reserve 100,000.00 Institution Current Interest Rate Annual Interest November 2017 October 2017 Position Current Ratio 1.31 3,479,726.37 3,479,726.37 2.59 2.77 TBD N �l1l Savings, Checking, Investments Total HUC Operating Funds varies varies varies 33,300,167.95 19,840,193.14 13,459,974.81 Debt Restricted Requirements Bond Covenants - sinking fund Debt Restricted Requirements Bond Covenants -1 year Max. P & I Total Restricted Requirements 33,300,167.95 19,840,193.14 13,459,974.81 2,118,025.05 1,955,100.04 162,925.01 2,188,694.02 2,188,694.02 - 4,306,719.07 4,143,794.06 162,925.01 Operating Reserve Min 60 days of 2017 Operating Bud. 1,666,537.00 1,666,537.00 Rate Stabalization Funds $200K -$600K 646,058.37 646,058.37 PILOT Funds Charter 367,131.00 367,131.00 Catastrophic Funds Risk Mitigation Amount 100,000.00 100,000.00 Capital Reserves 5 Year CIP ( 2017-2021 Fleet & Infrastructure Maintenance) 700,000.00 700,000.00 Total Earmarked Funds Current Ratio 1.31 3,479,726.37 3,479,726.37 YE YE YE YE YTD HUC 2013 2014 2015 2016 2017 APGA Ratio Target Debt to Asset 58.6% 55.6% 54.8% 51.5% 46.7% TBD VIII Current Ratio 1.31 2.07 2.17 2.59 2.77 TBD N �l1l RONA 5.8% 4.3% 4.7% 5.6% 5.3% TBDp�� Gas Division cash decreased due to bond payment made in November. -O G N( C f6 - � L C' 5 f N L C6 - t i u a'` � e `1 c 7i U �2�� 0 00 00 z z z z I- I- 1- 0) 1- zzzzzzzzzzz O N N N N 63'0 X0000000 O r 00 0) N O O to to 0 00 0 O (O to c 1n O 1n C\1 1- O C\1 0 O 0 M N V r (O M W O O N N00000 (O V M Ol) V V N(O Om(O� m� ON V U) 00 00030000II)OONI�OOOOOOOIO 00 co 0) 1)N O1) V r (OM ln O1) 1)01-0 O (ACA (A N (A W0 M O (O (O V V r r to N r O M O O V V W (O OO O N (O r V 0') N (A V M O l) O ON V a Ar-Ml0000)(00 to 0—O(0 V 7-7 V N V 00 V7WN CC( — V Lo 0 0 0 0 0 0 0 0 0 O N V 0 0 0 0 0 0 0 W 00 0000000 O N �O NOO 1) 1)O NO CO 00 0000000 O M V Lo Lo 0 L 1-1-01-0 V 00 0000000 O 00 (A 00 MN V N (OM O 1 O O O 0 0 0 0 0 0 0 O 1,- (A Oc Oc -- M V M C) to M 1) In 1) 1) 1) 1) O 1) 1) O CA O CA O CA (O (O CA r V (O V V V V V V (O rN M CA OCA (O 1)O M 1)(O 1)r N N N N N N N N N O O (A O C A N N 1) N N N N 7 M (O M N 1 1) O O O O O l) O O O l) O V N 0 0 0 0 0 0 C Co::) (O 00 O0I m V 0001) to to V r 1)1)00001)0 m m m 1-O m1 -(A M (O (AOI -N0000 MO O V V O M W — Mr M 0 r 0000 NN NO 1) 1) 00 O (A r 1) C C 1� N " M N (A V N (A W 00 L6 to to M M M m M 0 to V r m 0'1 N 0 0 � r M V V V V V V V V l) r CA CA CA l) l) O V l) l) l) CO CO N N N N N N N N O O (A (A (A N N l) N N N N O M (O N (\I 1n O O 0 0 0 0 0 0 OI O 0 0 0 0 0 0 0 0 0 0 OI O 0 0 0 0 0 0 0 0 0 O 0 0 0 0 0 0 0 0 0 0 0 O 0000000000 00000000000O 0000000000 00000000000O 0000000000 O V O O O O O O O O O V 1) to 1) Lr) Lr) Lr) 0Lr) Lr) O N(00000001)0 V V V V V V V O I- N M V N0 1n 1n O 1n 1n 1n O V) V N N N N N N N N O O O O O N N Lo N N N N (1) 1- (`') (`') 16 0000 0000 04M NM 00000000MM MO O O O O 00000 ^ OO (\I (\I (\I O N N (\I (\I N N N N NNNO o 0 N N N N N N N N Cy O 62-5 O N N N N V MIO N N nN N 6 N O In In G N N NnO On OO N� 0000- O� 0 0 0- 0 0 0 0 0 0 0 0- 0 0 (D CD (D (D (D r (D r (D r r r (D (D (D (D (D (D r (D 000000000 00000000000 1-1-OOM MM N N N N N N N N N N N N N N N N N N N N O O N O N N O O O O O O N N N O O 0 00 00 00 00 00 - - - MO MO M0 00 00 00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o 0 00 00001) MM O� I- 1-00 m 00 O to O O O to V (A to � V O r W r W N (A V 777"97M7" -.0001 00-.V? N(O N N- N N - -- N- -- N N M 0 0 0 0 0 0 0 0 0 0 0 0 0 o 0 0 0 0 0 o 000000000 O0000000 0 0 0 1) 0 0 0 �O � n O M O n � 0 0 [-, VO . '1OA)000 . N O N N— N— N N N N M M 0 Z z W C6 N N N N N N N m m m -0-0-0-0-0 "6 '6 "60 f6 ~ C C y0 N Y U U U N N N Q Q Q Q Q Q Q 2- YJ N N N N N N H H HU UU U U U U :U Q 'C J J J mC C CC CCC m F 3 3 3 3 3 3 3 UU UUUULLLL1.L 0 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 N N N N N N N N N N N � v} 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 NN N N N N N N N N N 2121 01 01 01 01 01 01 01 > > > > > > > > > > > C C C C C C C C C C C LL LL LL LL LL LL LL LL LL 2 2 2 2 2 2 2 2 2 2 2 N N N N N N N N N N N N N N N N N N N N w w w w w w w w w w w w w i5 i5 i5 i5 i5 i5 i5 UUUUUUUUUUU N � v} of a 0 0 0 0 0 0 0 M to M N (A (A O I- <n V V N <n O I- O r (D O O O N O a (IJ w to o0 O CA V O OCOO O i O M O = M 0 M M O N ^+ m Ch ao > i 00 r i i i i F N cu m 0 ^gym L w w w w N U) N N 0') V In J N n V to y .0 (n to am -I c Y th R o O O O p o 8 d pO pO th OO O O O O O O O O O O O O O O O O O O O O O O 0 o n 0 1n O O Lo Co > w (» 00 0) 00 r(A CO V C f06 co co O t 0 O Y �^ ^2 U rq M m D r1 U op O y O 0 0 0 0 0 Co e O a O m O O O OIn In O O O N V In N n w O I� Lo N n 7 O f6 FA M N T M l0 N > M CO CO �.,.. M C6 V 1LQ O O 0 0 0 0 0 G \ 0 o F 0 o 00 0 o O � Q; ON (0 O w O N m In n O 00 O C6 M 000 O > O r O (MO M 000 V to O O V N 00CL / w N \ \\l F � � m -Y.) Q U Y F '6 [0 (6 N o O Q ~ m d v N w O Q O 7 y E W U (7 `w 0 (7 ELECTRIC DIVISION Operating Revenue November 2017 CLASS AMOUNT KWH /KWH Street Lights $22.50 413 $0.05448 Electric Residential Service $398,052.70 3,897,856 $0.10212 All Electric Residential Service $24,451.35 247,527 $0.09878 Electric Small General Service $147,893.98 1,481,281 $0.09984 Electric Large General Service $570,371.32 6,041,963 $0.09440 Electric Large Industrial Service $765,445.80 9,651,000 $0.07931 Total $1,906,237.65 21,320,040 $0.08941 Power Adjustment $0.00480 Rate Without Power Adjustment $0.08461 Electric Division Year -to -Date 02017 $Amount 02016$A—nt s2017KWH/10 02016KWH/10 30,000,000 29,000,000 28,000,000 27,000,000 26,000,000 25,000,000 24,000,000 23,000,000 22,000,000 21,000,000 20,000,000 19,000,000 18,000,000 17,000,000 16,000,000 15,000,000 14,000,000 13,000,000 12,000,000 11,000,000 10,000,000 9,000,000 8,000,000 7,000,000 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 0 IL Street Lights Residential All Elec. Small Gen. Large Gen. Large For Resale Total Resid. Srv. Srv. Industrial NOTE: Sales for resale includes capacity sales, market sales and Transalta sales. NATURAL GAS DIVISION Operating Revenue NOVEMBER 2017 CLASS AMOUNT MCF/$ MCF Residential $416,394.54 49,623 $8.39116 Commercial $353,157.33 44,411 $7.95202 Large Industrial $398,871.31 90,907 $4.38769 Total $1,168,423.18 184,941 $6.31782 Fuel Adjustment -$0.00136 Rate Without Fuel Adjustment $7.67782 Natural Gas Division Year -to -Date ® 2017 $ Amount 0 2016 $ Amount ® 2017 MCF 0 2016 MCF 10,000,000 9,000,000 8,000,000 7,000,000 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 0 Gas Residential Gas Commercial Large Industrial Total eReliability I Monthly Statistics Monthly Report - Hutchinson Utilities Commission Hutchinson Utilities Commission I �-, M I YearMinimum duration Substation II 2017 V Month Maximum duration Circuit 11 - November ----- [VI Annual Report? Top-level Cause Remove Major Events? 0 Yes * No https:Hreliability.publicpower.org/reports/monthly/utility/91 ?year=2017&month= 11 &is ... 12/15/2017 r 1 1 IEEE 1366 Statistics Metric Nov 2017 Nov 2016 SAIDI 1.747 0.169 SAIFI 0.0182 0.0567 CAI D I 96 3 ASAI 99.9958% 99.9995% Momentary Interruptions 0 1 Sustained Interruptions 1 0 Circuit Ranking - Worst Performing Ranked by Outage Count Circuit Substation Fdr#22 Plant 2 Ranked by Customer Interruptions Circuit Substation Fdr#22 Plant 2 Number of Outages 1 Customer Interruptions 130 Ranked by Customer Minutes of Duration Circuit Substation Customer Minutes of Duration Fdr#22 Plant 2 12,480 I r , r r' r p• t ' 1 • 1' MAMIM. oil KA iN 0x a �` (10 N .—'-...................... ........... =... ....... _.... Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov 2016 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 Historical Monthly SAIR Chart 0.020 Monthly SAIR k/SA|Hvalues 0.015 0.010 O.DO& j,, 0.000'—~��~�~��=�=--._~---. Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov 2016 2017 2017 2017 2017 2017 2017 2017 3017 2017 2017 2017 https:llreliability.publicpower.orglreportslmonthlylutilityl9l?year---,2017&month=ll&is..,,... 12/15/2017 Electrical Fo|una Causes Ranked by Duration Duration Electrical Failure Customers Customer Minutes of Address Interrupted Duration Interruption Century Ave 130 96 Sw Total Customers Affected for the Morift EEM= P(,.)\xvenng Strong Cornn-iunities 12,480 9mlqI =I- 11/06/2017 130 130 https://reliability.publicpower.org/reports/monthly/utility/9 I ?year-=2017&month 11 is ... 12/15/2017 Work Order Description 11701 Plant 1 Door & Window Replacement 11702 Unit #8 Field Breaker/Voltage Control 11703 Unit #8 Boiler Non -Return Valve 11704 Plant I Alarm Panel Upgrade 11705 Unit #1 Control System Batteries 11706 Plant I Electrical Panel Upgrades 11707 Unit #1 Gas Valve Upgrade 11708 Units 6 and 7 IMM210"m ".1 Percentage Completed Cancel 50% 100% 0% 100% 0% 100® 25% Total Total Materials Labor Budgeted Actual Difference $ 150,000.00 $ 20,000.00 $ 170,000.00 $ 7,943.87 $ (162,056.13) 95,000.00 5,000.00 $ 100,000.00 120,807.71 $ 20,807.71 40,000.00 1,000.00 $ 41,000.00 20,224.37 $ (20,775.63) 10,000.00 6,000.00 $ 16,000.00 - $ (16,000.00) 8,500.00 - $ 8,500.00 1,816.97 $ (6,683.03) 10,000.00 $ 10,000.00 350.28 $ (9,649.72) 57,959.49 $ 57,959.49 2,732,709.84 $ 2,732,709.84 $ 163,500.00 $ 12,000.00 $ 175,500.00 $ 2,933,868.66 $ 2,758,368.66 Percentage Completed Cancel 50% 100% 0% 100% 0% 100® 25% Electric Distribution Work Total Total Percentage Order Description Materials Labor Budgeted Actual Difference Completed 21701 Pole Repair or Replacement 15,000.00 - 15,000.00 - $ (15,000.00) 0% 21702 Hutch Substation Roof Replacement 10,000.00 - 10,000.00 - $ (10,000.00) 0% 21703 Station Equipment 10,000.00 - 10,000.00 - $ (10,000.00) 0% 21704 Poless, Towers, Fixtures N Hwy 15 Fdr 12A 10,000.00 5,000.00 15,000.00 - $ (15,000.00) 0% 21705 Right of Way Clearing 2,500.00 2,500.00 182.00 $ (2,318.00) 0% 21706 Duct for Reconductor 20,000.00 65,000.00 85,000.00 105,299.55 $ 20,299.55 95% 21707 Reconductor Feeder 17 45,000.00 45,000.00 90,000.00 207,306.77 $ 117,306.77 95% 21708 Reconductor Feeder 16 20,000.00 25,000.00 45,000.00 445.89 $ (44,554.11) 0% 21709 Hutchinson High School 35,000.00 25,000.00 60,000.00 33,755.03 $ (26,244.97) 75% 21710 New Developments 50,000.00 - 50,000.00 128,980.22 $ 78,980.22 80% 21711 Hutchinson High School 25,000.00 1,000.00 26,000.00 21,123.23 $ (4,876.77) 100% 21712 Transformer Replacements 40,000.00 10,000.00 50,000.00 857.74 $ (49,142.26) 0% 21713 New Developments 50,000.00 - 50,000.00 18,829.41 $ (31,170.59) 80% 21714 Meters 30,000.00 - 30,000.00 6,685.08 $ (23,314.92) 20% $ 360,000.00 $ 178,500.00 $ 538,500.00 $ 523,464.92 $ (15,035.08) Work Order Description 51701 Vactron 51702 F550 Dump Truck 51703 F550 Super Duty Bucket Truck 51704 Tractor Backhow 51705 Lift Administrative Total Total Percentage Budgeted Actual Difference Completed 60,000.00 37,864.00 22,136.00 100% 30,000.00 - 30,000.00 0% 130,000.00 131,206.11 (1,206.11) 100% 60,000.00 61,827.19 (1,827.19) 100% 17,000.00 16,733.20 $ (266.80) 100% $ 297,000.00 $ 247,630.50 $ (49,369.50) Total Percentage Natural Gas Difference Completed 1,404.75 Work - $ (503,000.00) Cancel 226.50 Total Order Description Materials Labor Budgeted 61701 Transmission Lateral to HCP - ROW Easements $ 500,000.00 $ 3,000.00 $ 503,000.00 $ 61702 Transmission Lateral to HCP - Materials and Permits $ 500,000.00 $ 3,000.00 $ 503,000.00 $ 61703 Interconnect Station - Hanska 200,000.00 10,000.00 $ 210,000.00 61704 Misc Developments and Improvements 30,000.00 15,000.00 $ 45,000.00 61705 Specific Gravity Meter - Hutchinson 40,000.00 1,000.00 $ 41,000.00 61706 SCADA Equipment - Hanska 15,000.00 5,000.00 $ 20,000.00 61708 Regulator Station Improvements 15,000.00 3,000.00 $ 18,000.00 61709 Service Lines 55,000.00 20,000.00 $ 75,000.00 61710 Meters, Regulators, AMI Modules 70,000.00 3,500.00 $ 73,500.00 61711 Industrial Metering and Regulation 20,000.00 3,500.00 $ 23,500.00 61712 Gas Detection Equipment 5,000.00 - $ 5,000.00 Total Percentage Actual Difference Completed 1,404.75 $ (501,595.25) Cancel - $ (503,000.00) Cancel 226.50 $ (209,773.50) Cancel 93,506.91 $ 48,506.91 0% 6,758.49 $ (34,241.51) 100% 163.39 $ (19,836.61) Cancel - $ (18,000.00) 0% 83,425.94 $ 8,425.94 10% 75,542.37 $ 2,042.37 5% 9,688.06 $ (13,811.94) 0% - $ (5,000.00) 0% C 1,450,000.00 67,000.00 $ 1,517,000.00 t HUTCHINSON UTILITIES COMMISSION 9T, Board Action Form iiiiiiiiiiiiiiiiiiiiiillillillillillillilliillillillillillillilliilliillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliilllI Agenda Item: Review Policies Presenter: Jeremy Carter Agenda Item Type: Time Requested (Minutes): 5 Review Policies Attachments: Yes BACKGROUND/EXPLANATION OFAGENDA ITEM: As part of HUC's standard operating procedures, a continual policy review is practiced. This month, the following policies were reviewed and no changes are recommended on these policies at this time: i. Purpose of this Handbook ii. Surplus Property Policy BOARD ACTION REQUESTED: None Fiscal Impact: Included in current budget: Budget Change: PROJECT SECTION: Total Project Cost: RemainingCost: EXEMPT PURPOSE OF THIS HANDBOOK The contents of this Employee Handbook are for information only. The Hutchinson Utilities Commission does not intend to create a contract by the publication and issuance of this Handbook and under no circumstances is it to be construed as a contract of employment. Employees are considered to be "at will". The Commission reserves the right to change the policies and procedures in this Handbook at any time without notice. NON-EXEMPT PURPOSE OF THIS HANDBOOK The contents of this Employee Handbook are for information only. The Hutchinson Utilities Commission does not intend to create a contract by the publication and issuance of this Handbook and under no circumstances is it to be construed as a contract of employment. Employees are considered to be "at will". The Commission reserves the right to change the policies and procedures in this Handbook at any time without notice. Amended August 29, 2012 Policy on Disposal of Surplus Property DISPOSAL OF EXCESS PROPERTY DECLARATION OF SURPLUS; SALE AUTHORIZATION. The General Manager may, from time to time, recommend to the Hutchinson Utilities Commission that certain personal property (chattels) owned by the Hutchinson Utilities Commission is no longer needed for utility purpose and should be sold. By action of the Commission, this property shall be declared surplus, the value estimated and the General Manager authorized to dispose of that property in the manner stated herein. SURPLUS VALUED UNDER $5,000 The General Manager may sell surplus property with a fair market value of less than $5,000 through negotiated sale. Surplus personal computers greater than three years old may be donated directly to public schools in the city. SURPLUS VALUED OVER $5,000 The General Manager shall offer for public sale, to the highest bidder, surplus property with a fair market value over $5,000. Notice of the public sale shall be given stating time and place of sale and generally describing the property to be sold at least ten days prior to the date of sale by publication once in the official newspaper. The sale shall be to the person submitting the highest bid. EXCEPTIONS Surplus property may be transferred or sold to other state agencies or government units or eligible non-profit organizations in accordance with state law without regard to the requirements of this policy. DISPOSITION OF PROCEEDS All receipts from sales of surplus property under this policy shall be placed in the fund from which it was purchased. PERSONS INELIGIBLE TO PURCHASE HUTCHINSON UTILITIES EMPLOYEES No employee of the utilities, a member of the Commission, or an advisor serving the Utilities in a professional capacity, may be a purchaser of property under this policy. PROHIBITED PURCHASES It is unlawful for any person to be a purchaser of property under this policy if that purchase is prohibited by the terms of this policy. OS HUTCHINSON UTILITIES COMMISSION 9T, Board Action Form iiiiiiiiiiiiiiiiiiiiiillillillillillillilliillillillillillillilliilliillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliilllI Agenda Item: Approve Policy Changes Presenter: Jeremy Carter Agenda Item Type: Time Requested (Minutes): 5 App Changes to Policies Attachments: Yes BACKGROUND/EXPLANATION OFAGENDA ITEM: As part of HUC's standard operating procedures, a continual policy review is practiced. The following revisions to the policies below are recommended. i. Section 1 — Introduction ii. Definitions iii. Payments of HUC Payables BOARD ACTION REQUESTED: Approve Policy Changes Fiscal Impact: Included in current budget: Budget Change: PROJECT SECTION: Total Project Cost: RemainingCost: EXEMPT SECTION I - INTRODUCTION We are pleased to welcome you to the Hutchinson Utilities Commission. This Handbook has been prepared to familiarize you with our operating policies and procedures as well as your responsibilities as an employee. We hope you will find your work interesting and rewarding. When you become an employee of Hutchinson Utilities Commission, you represent Hutchinson Utilities to our customers and the general public. We should strive to show the best image possible. Should you have any questions regarding policies or procedures, kindly talk with your Director, Manager or Supervisor. WELCOME TO HUTCHINSON UTILITIES COMMISSION WHAT IS HUTCHINSON UTILITIES COMMISSION? The Municipal Electric Light Plant was established in 1935 as a result of a special election authorizing the establishment of a new generating plant and distribution system through a bond issue of $250,000 to pay for the construction. The vote was 1,187 for and 128 against. Contracts were awarded for the construction of a new power plant building at the intersection of State Highways 7 and 15. The contract included three (3) 625 hp 430 kw diesel generating units, switchboard, a complete distribution system and other auxiliary equipment. On November 28 1936, construction was completed and by January of 1937, over 600 customers were connected. By the end of March, the system was serving 1,171. The City Charter was amended in 1935 to create a Utilities Commission to manage and operate the system. In 1960, the City constructed a natural gas distribution system, buying natural gas from Northern Natural Gas Company, and selling it to the citizens of Hutchinson and the surrounding rural area. Natural gas ��,s was also used in firing the dual generating units of the light plant. In 2003, in order to control natural gas transportation costs, Hutchinson Utilities constructed a high pressure natural gas transnik )n pipeline to serve this community. This transmission line is interconnected with Northern Border Pipeline near Trimont, Minnesota which allows Hutchinson Utilities to transport natural gas to its customers in addition to other municipal utilities and industrial end users located along the pipeline corridor. Since 1936, the Hutchinson Utilities Commission, consisting of three (3) qualified voters of the City of Hutchinson, has operated the Municipal Electric Plant and the Natural Gas Distribution System. It was established by Section 17 of the City Charter that the Commissioners be appointed by the City Council, one (1) every two years, for a six year term. No Commissioner can serve more than two (2) successive terms. The Commission elects a President, Vice President, and Secretary. In November of 1987, the City Charter was amended to expand the Utilities Commission to a five (5) -member board. Each Commissioner's term will be five (5) years and no Commissioner can serve more than two (2) successive terms. The City Charter gives the Commission full, absolute and exclusive control of and power over the Electric and Natural Gas Operations of Hutchinson Utilities. The Commission hires a General Manager to manage the day-to-day operation of the Utilities. The Hutchinson Utilities Commission has, for many years, made substantial cash contributions to the General Fund of the City of Hutchinson from surplus earnings of both the electric and gas divisions of the Utilities. Hutchinson Utilities Commission has provided and will continue to provide to its customers, electricity and natural gas at the lowest possible cost. NON-EXEMPT SECTION 1 - INTRODUCTION We are pleased to welcome you to the Hutchinson Utilities Commission. This Handbook has been prepared to familiarize you with our operating policies and procedures as well as your responsibilities as an employee. We hope you will find your work interesting and rewarding. When you become an employee of Hutchinson Utilities Commission, you represent Hutchinson Utilities to our customers and the general public. We should strive to show the best image possible. Should you have any questions regarding policies or procedures, kindly talk with your Director or Manager. WELCOME TO HUTCHINSON UTILITIES COMMISSION WHAT IS HUTCHINSON UTILITIES COMMISSION? The Municipal Electric Light Plant was established in 1935 as a result of a special election authorizing the establishment of a new generating plant and distribution system through a bond issue of $250,000 to pay for the construction. The vote was 1,187 for and 128 against. Contracts were awarded for the construction of a new power plant building at the intersection of State Highways 7 and 15. The contract included three (3) 625 hp 430 kw diesel generating units, switchboard, a complete distribution system and other auxiliary equipment. On November 28 1936, construction was completed and by January of 1937, over 600 customers were connected. By the end of March, the system was serving 1,171. The City Charter was amended in 1935 to create a Utilities Commission to manage and operate the system. In 1960, the City constructed a natural gas distribution system, buying natural gas from Northern Natural Gas Company, and selling it to the citizens of Hutchinson and the surrounding rural area. Natural gas ��,s was also used in firing the dual generating units of the light plant. In 2003, in order to control natural gas transportation costs, Hutchinson Utilities constructed a high pressure natural gas transm�ss� on pipeline to serve this community. This transmission line is interconnected with Northern Border Pipeline near Trimont, Minnesota which allows Hutchinson Utilities to transport natural gas to its customers in addition to other municipal utilities and industrial end users located along the pipeline corridor. Since 1936, the Hutchinson Utilities Commission, consisting of three (3) qualified voters of the City of Hutchinson, has operated the Municipal Electric Plant and the Natural Gas Distribution System. It was established by Section 17 of the City Charter that the Commissioners be appointed by the City Council, one (1) every two years, for a six year term. No Commissioner can serve more than two (2) successive terms. The Commission elects a President, Vice President, and Secretary. In November of 1987, the City Charter was amended to expand the Utilities Commission to a five (5) -member board. Each Commissioner's term will be five (5) years and no Commissioner can serve more than two (2) successive terms. The City Charter gives the Commission full, absolute and exclusive control of and power over the Electric and Natural Gas Operations of Hutchinson Utilities. The Commission hires a General Manager to manage the day-to-day operation of the Utilities. The Hutchinson Utilities Commission has, for many years, made substantial cash contributions to the General Fund of the City of Hutchinson from surplus earnings of both the electric and gas divisions of the Utilities. Hutchinson Utilities Commission has provided and will continue to provide to its customers, electricity and natural gas at the lowest possible cost. EXEMPT DEFINITIONS In this Handbook, the following terms shall have the meanings as listed below: "Commission" means the Hutchinson Utilities Commission. "Essential employees" means power plant operators, system controllers, line workers, and natural gas service workers. "Exempt employees" means executive, professional and administrative employees as those terms are defined in the Fair Labor Standards Act ("FLSA") and who are not subject to the minimum wage and overtime provisions of the FLSA. "General Manager" means the Chief Executive of Hutchinson Utilities who is appointed by the Commission. "Immediate family" means spouse or significant other, parent, stepparent, guardian, child, adult, adult child, stepchild, sibling, grandparent, grandchild, and any in-law. "Non-exempt employees" are employees who are generally paid hourly and are subject to the minimum wage and overtime provisions of the FLSA. "Regular full-time employee" means an employee who has been appointed to an authorized, budgeted position who is not temporary or probationary and who is regularly scheduled to work 40 hours during a work week. Generally, regular full-time employees are eligible for Utility benefit programs subject to the terms, conditions and limitations of each benefit program. "Seniority" means length of consecutive employment as a regular full-time employee with Hutchinson Utilities. "Staff personnel' means 1 n.izeeto Hi' Natural Gas I ivisioti [)r;ctor, i kiffl ti igAaliknf.e. afiagel Manager of keetiie Production Manager, Nlanagciol' Electric Transmission/Distribution Manager, Engineering Services Manager, F4iatiee Fiean6,d Manager, Accountant, Administrative Coordinator, Purchasing Agent/Inventory Agent, Computer Systems Analyst, Energy Conservation Administrator, and Accounts Supervisor. "Temporary employee" means an employee who may work up to 40 hours per week but for a maximum of 24 weeks per year, even if not consecutive weeks. Temporary positions are eligible for legally mandated benefits such as Social Security but are ineligible for Utility benefit programs. "Utility" and "Utilities" means Hutchinson Utilities. "Working days" means Monday through Friday. NON-EXEMPT DEFINITIONS In this Handbook, the following terms shall have the meanings as listed below: "Commission" means the Hutchinson Utilities Commission. "Essential employees" means power plant operators, system controllers, line workers, and natural gas service workers. "Exempt employees" means executive, professional and administrative employees as those terms are defined in the Fair Labor Standards Act ("FLSA") and who are not subject to the minimum wage and overtime provisions of the FLSA. "General Manager" means the Chief Executive of Hutchinson Utilities who is appointed by the Commission. "Immediate family" means spouse or significant other, parent, stepparent, guardian, child, adult child, stepchild, sibling, grandparent, grandchild, and any in-law. "Non-exempt employees" are employees who are generally paid hourly and are subject to the minimum wage and overtime provisions of the FLSA. "Regular full-time employee" means an employee who has been appointed to an authorized, budgeted position who is not temporary or probationary and who is regularly scheduled to work 40 hours during a work week. Generally, regular full-time employees are eligible for Utility benefit programs subject to the terms, conditions and limitations of each benefit program. "Seniority" means length of consecutive employment as a regular full-time employee with Hutchinson Utilities. "Staff personnel" means 1 n.izeeto Hi' Natural Gas I ivisioti [)r;ctor, i kiffl ti igAaliknf.e. afiagel Manager of keetiie Production Manager, Nlanagciol' Electric Transmission/Distribution Manager, Engineering Services Manager, f 4iatiee Fiean6,d Manager, Accountant, Administrative Coordinator, Purchasing Agent / Inventory Agent, Computer Systems Analyst, Energy Conservation Administrator, and Accounts Supervisor. "Temporary employee" means an employee who may work up to 40 hours per week but for a maximum of 24 weeks per year, even if not consecutive weeks. Temporary positions are eligible for legally mandated benefits such as Social Security but are ineligible for Utility benefit programs. "Utility" and "Utilities" means Hutchinson Utilities. "Working days" means Monday through Friday. Amended December 240, 2015 Policy on Payments of Hutchinson Utilities Commission Payables The Hutchinson Utilities Commission Accountant and Financial Manager are hereby authorized to issue warrant(s) drawn from the proper funds. (Resolution 153 was amended on March 25, 2009 and reads as follows): Resolution 153 authorizes HUC Accountant or HUC Financial Manager to transfer funds by wire or other electronic means. Claims shall be paid upon proper presentation during the year 20178. This policy shall be reviewed on an annual basis. HUTCHINSON UTILITIES COMMISSION�� Board Action Form �'Ylkll'M1'k� Agenda Item: 2018 Electric & Natural Gas Operating Budgets Presenter: Jeremy Carter Agenda Item Type: Time Requested (Minutes): 10 New Business Attachments: Yes BACKGROUND/EXPLANATION OF AGENDA ITEM: Attached is the final 2018 operating budgets and capital expenditures for the Electric and Natural Gas Divisions. At the November Commission meeting on 11-29-17 the 2018 budgets were reviewed and the major changes budgeted from 2017 to 2018 were discussed in detail. Power Cost Adjustment's (PCA's) along with Fuel Cost Adjustment (FCA) credits have been budgeted in the Electric & Natural Gas divisions for 2018. The one minor change to the Electric division budget from what was previously presented at the November meeting is increasing depreciation $100,000 to account for the installation of units 6 & 7. BOARD ACTION REQUESTED: Approve 2018 Electric and Natural Gas Division Budgets & CIP Fiscal Impact: Included in current budget: Yes Budget Change: PROJECT SECTION: Total Project Cost: Remaining Cost: HUTCHINSON UTILITIES COMMISSION 2018 BUDGET 2018 SUMMARY 2018 Operating Budget - Electric Division General 2018 Budget Items o Budget currently reflects the addition of (1) Electric Division FTE over the 2017 budget (Plant Mechanic). o Budget currently reflects a 4% Health Insurance premium decrease compared to the 2017 budget based on increasing to a $6450/$12900 deductible program and continuing to qualify for the small group plan. The plan also continues to include the HRA embedded 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 Dental plan for 2018 will see a 5% increase, while the LTD and Basic Life & AD&D will remain unchanged from the 2017 rates. Worker's Comp expense is budgeted at a 4% increase over 2017 rates. 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 reflects a slight decrease in the budgeted amount for 2018 to administer the Conservation Improvement Plan (CIP) to the current intentions of the State Program and State Statute language. (1.5% energy savings goal) However, the budgeted amount may not all be expended in 2018. 2017 Budget $357,201; 2018 Budget $346,442 o Budget reflects an Electric Division transfer amount of $1,029,711. This is an increase of $200,511 over the 2017 budget. The transfer amount includes the PILOT Phase-in to 3.25% and street light reimbursement. Budget also continues the Tree Program & reimbursement for IT, HR, Legal. Electric Operating Revenues o Retail Sales Forecast: o For 2018, retails sales are budgeted comparable to 2017 and based off the rolling average of billable KWHR's from 2009 — October 2017, which equates to 284,063,797 KWHRs. The 2018 budget reflects the 2017 current electric rates for all classes. o Power Cost Adjustment: o Power Cost Adjustments (PCA's) of $1,300,000 are budgeted and allocated between the different customer rate classifications. 2018 will be the 12th consecutive year without a rate increase; last rate increase was in 2006. o KWHR Allocation used to determine KWHR retail sales by customer classes are as follows: o Electric Residential 17.6% o All Electric Residential .9% o Electric Small General Service 6.1% o Electric Large General Service 27.0% o Large Industrial 48.4% o Wholesale sales (Sales for Resale): o Capacity Sales with SMPPA for 2018 are budgeted at $1,292,000 o Energy Sales revenue from an energy contract is budgeted at $1,027,200. This amount is based on HUC's unit #1 called upon for 18,000 MWHR's (450 Hrs.). Market sales are budgeted at $200,000 in 2018. o Other Revenues: o The 2018 budget shows $208,800 budgeted in miscellaneous revenue areas. In addition, the 2018 budget reflects $50,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 226,008 MWHR's at an average blended price of $54.33 per/MWHR. HUC will receive 219,000 MWHR's, while 7,008 MWHR's will be system loss power purchased (— 3.2% system loss). MRES power received equates to 74.7% of power supply needed based on 2018 projections. o LMP expense is budgeted on a 2014 -Oct. 2017 average HUC LMP price. The budget reflects an average market price of $26.82 per MWHR and purchasing 62,354 MWHRs. LMP power needs equate to 21.3% of power supply needed based on 2018 projections. The ability to purchase power off the market at this average rate is directly impacted by HUC's ability to self -generate power during high market price times. 0 11,800 MWHR's are budget for Hedging. Generation hedging equates to 4.0% of power supply needed based on 2018 projections. o Electric Production Expenses: o Fuel: Includes $150,950 in natural gas contracted at $2.565 per MCF for unit #8 hedging, $133,632 at a spot market price of $2.90 per MCF for units #3, #4, #5, #6, #7 hedging & market sales, and $522,000 in natural gas budgeted for the energy contract. Other misc. budget for fuel oil, chemicals, lubricants, water & sewer, and boilers. o In addition, includes $656,366 for 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. The 1/3 transport expense is adjusted annually to reflect the current years P&I schedule. o The 2018 budget reflects generating 11,800 MWHR's for hedging purposes and 600 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 $80,000 over the 2017 budget. The 2018 increase is primarily due to two factors: 1) Reduction in net book value of HUC's transmission facilities, which reduces the amount of revenue received to offset expenses. 2) Factoring in slight reduction in load demand in the GRE zonal territory. o $20,000 is budgeted in 2018 to do transmission relay testing. o Electric Distribution Expenses: o Roughly, 82% 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 and builds outs for new developments. 2018 Capital Budgets for Electric Division Electric Production Capital Budget - $14,939,702 o Plant 1 cooling tower piping replacement - $357,000 o Unit #8 building spancrete joint replacement - $10,000 o Soft start motor controllers - Unit #1 generator vent fans - $8,000 o Unit #1 LM -6000 blade replacement - $150,000 o Data logger for Unit #1 - $30,000 o Unit #1 control building air conditioning upgrade - $15,000 o Unit #6 & #7 Installation - $14,369,702 Electric Distribution Capital Budget -$410,000 o Roof replacement Hutch substation — $10,000 o Uponor new feeder — $85,000 o MITGI new feeder - $80,000 o Station equipment - $10,000 o Duct Installation — $15,000 o Re -conductor replacement (FDR # 16 & #17) - $30,000 o Century court apartments — $30,000 o Century Avenue trail work, feeder #22 - $10,000 o Transformer replacements - $40,000 o Plant #14160 Generator transformer replacement - $70,000 o Meters — $30,000 Electric Distribution/Transmission Capital Budget (As Necessary) - $116,000 o Transmission Pole Repair & Replacement - $15,000 o New Developments - $101,000 Electric Division Fleet Budget -$216,500 o F550 Super Duty Bucket Truck - $140,000 o Metering Van - $25,750 o Production Truck - $25,000 o F150 Truck - $25,750 2018 Operating Budget - Gas Division General 2018 Budget Items o Budget currently reflects the addition of (1) Natural Gas Division FTE over the 2017 budget (Welder/Service Person). o Budget currently reflects a 4% Health Insurance premium decrease compared to the 2017 budget based on increasing to a $6450/$12900 deductible program and continuing to qualify for the small group plan. The plan also continues to include the HRA embedded 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 Dental plan for 2018 will see a 5% increase, while the LTD and Basic Life & AD&D will remain unchanged from the 2017 rates. Worker's Comp expense is budgeted at a 4% increase over 2017 rates. 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 slight decrease in the budgeted amount for 2018 to administer the Conservation Improvement Plan (CIP) to the current intentions of the State Program and State Statute language. (1.5% energy savings goal) However, the budgeted amount may not all be expended in 2018. 2017 Budget $183,710; 2018 Budget $163,189 o Budget reflects a Natural Gas Division transfer amount of $369,142. This is a decrease of $2,011 over the 2017 budget. The transfer amount includes the PILOT Phase-in to 3.25%. Budget also continues the Tree Program, & reimbursement for IT, HR, Legal. Natural Gas Operating Revenues o Retail Sales Forecast: o Retail (Residential & Commercial) sales forecasted on a 4 -year average (2013-2016) at 809,115 MCF for 2018. o Industrial sales forecasted on a 4 -year average (2013-2016) at 722,844 MCF for 2018. Two of the three industrial customers are transport customers with HUC providing the commodity as a pass through. Industrial transport sales are based off a transport charge on transported volumes of 722,844 MCF at a blended gas price of $3.00 per DTH with an offsetting expense for HUC to purchase the natural gas. o Fuel Cost Adjustment: o Fuel Cost Adjustment (FCA's) credits of $650,000 are budgeted and allocated between residential, commercial, and (1) industrial customer, excluding the contracted transport industrial customers. o Other Revenues: o Budgeted $739,440 for the New Ulm Contract o Budgeted $656,366 for the capacity used on the pipeline by the Electric Division's generation/production area. This is a transfer between divisions. o Operating Revenue to maintain the Brownton system is included in the budget. ($27K) Natural Gas Operating Expenses o Purchased Gas Expense o Retail Customers: The expense for this class is based off a 4 -year average (2013-2016) consumption level at 809,115 MCFS. Contracted Gas makes up —78% of the DTH's needed for retail customers at an average price of $4.00 per DTH. The remaining — 22% of retail gas needed will be purchased swing gas at an estimated price of $3.05 per DTH. Total average weighted natural gas price budgeted for retail customers is $3.79 per DTH. o Industrial Customers: consumption based on a 4 -year average. (2013-2016). The budget is based on 722,844 MCFS at an estimated blended gas price of $3.00 DTH. * Total blended budgeted expense is $3.42 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. 2018 Capital Budgets for Gas Division Natural Gas Transmission Capital Budget - $1,596,000 o Potential Transmission Lateral to HCP - $1,000,000 o Potential ROW Easements —Transmission Lateral to HCP - $500,000 o Metering Upgrade at Lafayette Substation - $90,000 o Locator - $6,000 Natural Gas Distribution Capital Budget - $365,000 o Meters, AMI, All Fittings - $90,000 o Improvements to Regulator Stations - $15,000 o Service Lines - $55,000 o Misc. Developments & System Improvements - $125,000 o Industrial Metering & Regulation (Includes Units #6 & #7) - $80,000 Natural Gas Division Fleet Budget -$37,080 o Silverado 1500 w/Utility Body -$37,080 3 m 00 ri O N 0 0 0 0 0 0 0 0 r -I Ln O N N O O N M 0 0 1-0 r- rI1 0 00 m171 O O O ri O r -I -, O O N l0 O L. � C11 l.0 l.0 � O It 00 rn � O O Ln l0 N ri ri ri rNi 171 171 O It It 1.0 It N --I O O 00 (01 00 '-' 0) r rj c I r -I n c -I c -I M ri m 441- r14 00 � In O O O to 00 O M 0 0 0 to O O ri lC N O lc:� M 00 O 4:t M (n O (n w N O ri w ri O M In (n O 1- 4:t Lr M I, w 4* ri Cl ,I* N ri O M 4/1- N O O 00 O 00 O 00 Ln r -I O r- O O O R* O r -I O 00 I� 00 O 111 moo 't ri W 0 DD ,i r -i o mLn rn o M l0 m r -I r, l0 't TT O� O L. � m Lin l.0 l.0 � N It 00 rn ri 00 m W N ri ri ri I, 00 M O m m It rn W ri 00 (01 00 l0 0) N c I r -I O Lfi N c -I M ri m 441- r14 00 � TT 0 0 0 0 0 0 0 0 0 1.0 1.0 It ri m 00 O O O It l0 `1 1-0 1-0 -1 Ln It N m O N N 0 00 r -I N c I 1.0 r, � O al O O N Ln 00 N 1.0 O r -I O 171 N Il r -I I� N O l0 O r I 00 N L' 00 O O I, O r- N O R* 00 0 0- LN R* N m N c -I In O O N O In ,* M (n In O O 00 O M 00 w ri G1 O O ri O 00 ri 00 O M O O N 00 N O O M 00 O M (n O O N 00 1- N w w in G1 G1 In N r -I lC Q1 N M ri N ri Q1 ri M 171 I, O ri O Ln i0 00 N N 1.0 0 0 0 It 0 00 M N N O 00 O l0 O Ln to Ln o O rn oo O m 0 N O rn Ln t O O oo 1.6 qq O 171 Ln N oo I- Ln I- lC l0 O N cI m rI N M N M TT O m oo r- Ln r- io oo R* ri Ln 171 171 Ln o0 0o ri o Ln m n1 rn 1.0 00 1.0 00 N 00 171 Ln ri N I, O r, R* 00 ri ri 171 N O N O N 171 N N ri 00 00 m 00 M Ln 171 N c -I m r -I N n ri M N ri 00 00 It It ri 171 00 I, Ln 00 m m O i0 N N ,t t Ql O t N Ln O ri O Ln Ln ri m Ln � M m 171 00 t N m O Ln N 171 1.0 I, 00 00 N m 00 R* Ln O c -I m r -I N n N M O i0 r -I O m m Ln N (n Ln O r- Ln r- r- m m o0 r- Ln O oo Ln O r- Ln O 171 O N 00 I� IT N ZF 111 1.0 ri ri N It N r, O N r- m Ln m r- i t rn R* Lr Z c -I c -I ff N N N N O� O L. � m Lin l.0 l.0 � N It 00 rn ri 00 m W N ri ri ri I, 00 M O m m It rn W ri 00 (01 00 l0 0) N c I Q; m M LLI 441- r14 00 t m Ln l0 00 r -i 1.6.0 p V i.1-, a v l171 r -i 00 41 m R* rr ZF l0 c -I l0 c -I tl1 ri ri r- �t 0) m 1� m - r, "D "D FO Ln Ln r -I 00 m M i/1- r14 m Ln o oo 171 171 I, O rr -I NO O N Ln O 171 I- Ln � 00 06 O m rn r% r -I I, O O 00 N ri I� l0 0o I- Ln Ln 171 N m � 0 0 0 0 0 0 0 0 0 1.0 1.0 It ri m 00 O O O It l0 `1 1-0 1-0 -1 Ln It N m O N N 0 00 r -I N c I 1.0 r, � O al O O N Ln 00 N 1.0 O r -I O 171 N Il r -I I� N O l0 O r I 00 N L' 00 O O I, O r- N O R* 00 0 0- LN R* N m N c -I In O O N O In ,* M (n In O O 00 O M 00 w ri G1 O O ri O 00 ri 00 O M O O N 00 N O O M 00 O M (n O O N 00 1- N w w in G1 G1 In N r -I lC Q1 N M ri N ri Q1 ri M 171 I, O ri O Ln i0 00 N N 1.0 0 0 0 It 0 00 M N N O 00 O l0 O Ln to Ln o O rn oo O m 0 N O rn Ln t O O oo 1.6 qq O 171 Ln N oo I- Ln I- lC l0 O N cI m rI N M N M TT O m oo r- Ln r- io oo R* ri Ln 171 171 Ln o0 0o ri o Ln m n1 rn 1.0 00 1.0 00 N 00 171 Ln ri N I, O r, R* 00 ri ri 171 N O N O N 171 N N ri 00 00 m 00 M Ln 171 N c -I m r -I N n ri M N ri 00 00 It It ri 171 00 I, Ln 00 m m O i0 N N ,t t Ql O t N Ln O ri O Ln Ln ri m Ln � M m 171 00 t N m O Ln N 171 1.0 I, 00 00 N m 00 R* Ln O c -I m r -I N n N M O i0 r -I O m m Ln N (n Ln O r- Ln r- r- m m o0 r- Ln O oo Ln O r- Ln O 171 O N 00 I� IT N ZF 111 1.0 ri ri N It N r, O N r- m Ln m r- i t rn R* Lr Z c -I c -I ff N N N N O L. � OC H a O v1 W Iy LLI W p V i.1-, a v cc H_j N > v 3 ~ ,= v a c v a �u H a,�� Z O� FO W 0 0 0 0 0 0 0 0 0 1.0 1.0 It ri m 00 O O O It l0 `1 1-0 1-0 -1 Ln It N m O N N 0 00 r -I N c I 1.0 r, � O al O O N Ln 00 N 1.0 O r -I O 171 N Il r -I I� N O l0 O r I 00 N L' 00 O O I, O r- N O R* 00 0 0- LN R* N m N c -I In O O N O In ,* M (n In O O 00 O M 00 w ri G1 O O ri O 00 ri 00 O M O O N 00 N O O M 00 O M (n O O N 00 1- N w w in G1 G1 In N r -I lC Q1 N M ri N ri Q1 ri M 171 I, O ri O Ln i0 00 N N 1.0 0 0 0 It 0 00 M N N O 00 O l0 O Ln to Ln o O rn oo O m 0 N O rn Ln t O O oo 1.6 qq O 171 Ln N oo I- Ln I- lC l0 O N cI m rI N M N M TT O m oo r- Ln r- io oo R* ri Ln 171 171 Ln o0 0o ri o Ln m n1 rn 1.0 00 1.0 00 N 00 171 Ln ri N I, O r, R* 00 ri ri 171 N O N O N 171 N N ri 00 00 m 00 M Ln 171 N c -I m r -I N n ri M N ri 00 00 It It ri 171 00 I, Ln 00 m m O i0 N N ,t t Ql O t N Ln O ri O Ln Ln ri m Ln � M m 171 00 t N m O Ln N 171 1.0 I, 00 00 N m 00 R* Ln O c -I m r -I N n N M O i0 r -I O m m Ln N (n Ln O r- Ln r- r- m m o0 r- Ln O oo Ln O r- Ln O 171 O N 00 I� IT N ZF 111 1.0 ri ri N It N r, O N r- m Ln m r- i t rn R* Lr Z c -I c -I ff N N N N 0 0 0 0 0 0 0 0 0 Vol 0 0 0 0 0 0 0 0 Vol O1 t ri 1.0 t 1.0 O O Ln oo O O t Ln t ri I- Ql r, 00 R* Cfi O 00 00 I- O O O It O O � r i r-i 1-0 Ln m m Ln O tG N O O N r I O O Cl u1 O ri m O m Ln t O N N N N ri 00 N M U v � c O N N 00 m LM ,.., Ln r- O l0 O O O -1 m O dl O a) O Ln L 1.0 1.0 O N O Ql O rl (V It O ri O I, 41 r- N Q L v I� 00 Ql Ln O O � Ln O O l0 O ri N N O tC (C w N Ql m 1.0 O Ql ri r% Ql o0 O I- O Ln 1.0 ri qq tG O I, O O r- n Ln O 00 Ln O O I- `-' 00 00 O 0N r-I N N`' N r-I N N r-I N Ln Ln m v C m W 1* lC lC 00 Ln o,* o o o 00 O O N O m O m ++ O m (n w O 00 O O O 00 1n O O 00 O in 4* O m [1• 00 rl I* m O m N 00 O rl lC O O rl O w O I� m rl -a N M ri O O r% C71 00 O m lC O O N O 00 O lC - rl w N I, N O 4* rl O Ln O 00 O m (n O m I4% O N N m O w in N m A Ln N rl 00 O w in Q1 Ln w w N r4 00 1n ri N w O ri N 00 1*N ri ri (n rl rl N rl N O N '!/i... r-I Q) 00 Ql O It 0 0 0 rl I, m 0 r-I O It O 00 m N r, 1.0 rn m 0 00 ri O O N m It 0 0 0 ri m 00 r4 cf v Ln N m 00 O m r-I N O r% r-I O O 00 O Ln m M L't Ln m Ln m o r- o o o Ln r- oo o a; o m o Ln o RT 3 O r-I I- t O t r-I o0 Ln N N O Ln t O m t N RE rl m ri 1.0 ri O ri ri m N 00 I- N Ln N oo m I- W 00 + — Ln r% N c-I N c-I c-I 06 N rI N cI N Z N O O 1.0 1.0 It r- ri Ql 00 1.0 rl ri 1.0 i0 o0 I, r, Ln i0 1.0 Ln to [1'. Q 3 N m N O l0 ri l0 ' i l0 Ln 00 m C oo c-I R* m N 00 lzl Ql N Ql Ql It lzl m l0 c-I 00 c-I 1� qz rl.. 4•Q) V O I- r-I It r-I N It N O r-I Ln -i O r-I i0 O r4%LM (,) 1.0 m mIt t m Ln rq O N ri Ql N O m m rl O' m N r- 00 41 ri Ql It m F, Ln N-i o0 t 1.0 1n N — Ln c-I l0 O c-I 1� m N ri N ri ri n W -A N i/� i/� vi- W O Ln -1 00 m 00 O ri O 00 00 ri It m 1.0 N N.;I m 1.0 Ln t Ln m ri I- r- rl O m o0 m O N Ln Ql m N 3 Ql r- m ri Q1 Ql Q1 Ql O I- 1.0 Ql O m N 1.0 ri N rl% QO r-I c-I Q1 l0 l0 Lr 00 00 l0 Lr c-I l0 l0 l0 Lr lC c '.. 00 N It Ql 't r-I N ri R* 00 O 00 It ri N ri m rl (Q N O I-0 m -1-1 It (n Ln r- r- oo oo O r- Ln LM rl Ln ri I, ri c-I lC F O N ri N - m 00 O 1.0 m m Ln O 00 m 00 ri O Ql I- r- N n Olt (C I, N 00 41 m Ql O 1.0 W ri m I, Ln 1.0 Ql i0 m m LO 3 O m Ln N I- oo N I- N O oo I- oo Ln Ln lC 00 Q N N Ln c-I Ql 00 dl F M Ln O N 00 zF m N O 00 R 1.0 ri I- O m I, m ri N Ql Ln ri N t N ri t O 00 I-R O -1 1-0 m ri t oo Ln m r- oo oo to q;r rl Ln ri I, ri lC m LLI �' ` v N LLI O ' LLI � a s Q� H v O •� Z +.. p C C� C v k �.+ Z ,^� N v v �.+ �+ v CC L W V a 'a O H _O � W v W a F u. W z v v a i O V a1 i� a N OC i W W� � �y cj � cj ,� O �. a i cj X J � W � H QJ q, � Q z O m t � u Q H � i Qj W w c, Cc a o a a O O X c, a za s i- v CD c, o a i- 4 O a, o p to z H-i� H H F W F N o 0 0 0 0 0 0 Vol 0 0 0 0 0 0 0 0 O1 r-I al 00 I- N N N0 r-4m t 0 Ln al O N M c O r,-1 O"D r, 0, o a1 r, O LO LO m IR +o N o o o ai o N o u r- 00 (n t O c-I c-I N U o N N O M 00 I, O N 1.0 O 1.0 It ri 00 O ri ri It 1.0 1.0 O R* O N ri 1.0 O R* a1.. L L v m m t Ln i0 t V1 N N O t O V1 M ca w o r i -- O Z ZF Lr rn N N m ri 00 M c 1 Ln � ri 00 1.0 1-0 Ln rl o < o o v ri r I r-I O m N O tC O O w 00 O N O O N1* O ++ O ri O1* O O O m (n O O H O 00 RT w N N O1* m O O N N O O ri ri ri W Ln -a N V) O ai k I:i O 00 r% O 00 ai O I:i 00 m 3 ri n V1 m V1 00 V1 W a1 O O w O N R* rl m 00 00 N N w N ri m w O m a1 w (n N 00 M M N C*4 ri Ln ri a1 N ri O N 4/1• 4/1• f1,... 00 m 0 00 O 00 O N N It O ri 1.0 O m RT +, ri m It I- O O O N al N O m I- O N V1' 0J l0 u1 It 00 r, 1.0 O N O N O ri 1.0 ri N Ln "a It N O Z rI 00 O N 00 N 00 I� l0 Lr r% to 3 r, oo O m Ln ri Ln ri r- 00 O 1.0 m m O O m It 00 N r- 1.0 N N N I- O m 00 r- O N, ZF m m m ri l0 ri ri N N ri ri ri O N Z 0 It ri N al 1.0 N 1.0 O al I- 00 N O m m rl N m Ln al 1.0 1.0 m 00 m t i0 O Ln N m N O j 3 O m l0 al r-I al r I m N 00 N N Ln l0 r% tC V a) t Ln ri I- 00 i ri 00 I- N 1.0 It r- W RT Q m oo Ln m t m O oo a, 0 O oo r- Ln ct N 00 m N m I- N 00 1.0 Ln a1 r-1 N ri 1.0 Ln O ri It 1.0 I- 00 Q1 O N Q O ri N i/1• i/1• '1/!• i0 Ln O t m N W 00 O ri m O 00 m W N (0 1.0 ri N 1.0 m m I- O r- N m 00 O m R* to 3 O 00 1.0 ri 00 al al R* r- 00 .-i al al 00 R* M v r I c I O l0 c I ai Lr 1� r I 00 00 l0 00 r I tC p Q m 00 -1 Il It 1.0 .-i N t 00 O O 00 N 111 N Ln O r, l0 N to m al O N Ln W a1 tC r-I c-I Lr O � N i/1• i/1• '1/!• al t O Ln O N O O r- 00 It 1.0 00 O N 00'.. (0 00 O al I, O .-i 1.0 m m 1.0 O I, 1.0 O V1 N 3 m Ln N Ln O N W 00 O N 00 ri ri O R* M v l0 rr l0 00 O Z ZF m ZF O N Lr O Z tC Nom' Q O Ln 1.0 O O 4 ri a1 I- 1.0 O O 1.0 1.0 W N I, 00 O 00 r- N m N It O 1.0 1.0 00 00 Ln ri m l0 tC O lc: r-z O r-4 r-i r'1 N i/1 i/1 'V1• Qj H C3 a OC i H ,O v1 W N W a C i of � O jZ LU1W/1 W LLI Ji a .a 'a lb c� a C.1 v C` v v a F_ 1i LL. i v� O c�i W � W v a 'V i X J W E•+ a 1► .V •+ of L Q Z W ,N = v t v F a i i 4 v -Q F F w OAC V V Z W O= FO W a s O 1► O 0 FO Z 2018 ELE T I C OPERATING REVENUES Energy Sales Revenue Sales - Electric Energy (440, 442, 444) Power Cost Adjustments Other Energy Sales (447) Total Energy Sales Revenue (440, 442, 444, 447) Revenue From Other Sources Revenue From Other Sources (450,451) Security Lights (454.01) Pole Rental (454.02, 454.03) Total Revenue From Other Sources (450, 451, 454) TOTAL OPERATING REVENUES OPERATING EXPENSES Production Operations Operation Supervison & Engineering (546) Fuel (547) Operating Supplies and Expense (550) Total Production Operations (546, 547, 550) Maintenance Operations Structures (554) Generating Units (554) Other Equipment (554) Total Maintenance Operations (554) Other Power Supply Expense Purchased Power (555) System Control & Load Dispatch (556) Engineering Services (557) Total Other Power Supply Expense (555, 556, 557) Transmission Expense Transmission Expense Operation (560) Transmission Expense Operation (565) Transmission Expense Operation (567) Transmission Expense Maintenance (574) Total Transmission Expense (560, 565, 567, 574) Distribution Expense: Distribution Operation (580, 581, 586, 588, 589) Distribution Maintenance (592, 594, 595, 596, 598) Total Distribution Expense (580 ,581, 586, 588, 589, 592, 594, 595, 596, 598) Customer Service and Collection Meter Reading (902) Collection Expense (903) Bad Debt Write offs (904) Customer Services (906) Total Customer Service and Collection (902, 903, 904, 906) Sales Expense Supervison (911) Misc. Selling Expense (916) Total Sales Expense (911, 916) Detailed Income Statement Electric Division 2014 Actual I 2015 Actual I 2016 Actual N 2016 Budget I 2017 Budget I 2018 Budget $ 25,090,910 $ 25,390,141 $ 24,923,358 $ 24,344,238 $ 24,085,461 $ 24,025,189 $ - $ - $ - $ - $ 1,100,000 $ 1,300,000 $ 678,293 $ 1,114,918 $ 1,931,859 $ 1,907,820 $ 2,310,110 $ 2,519,200 $ 25,769,204 $ 26,505,059 $ 26,855,217 $ 26,252,058 $ 27,495,571 $ 27,844,389 $ 292,778 $ 285,738 $ 282,041 $ 270,200 $ 270,200 $ 198,800 $ 11,301 $ 11,269 $ 11,253 $ 10,000 $ 10,000 $ 10,000 $ 16 $ - $ - $ - $ - $ - $ 304,095 $ 297,007 $ 293,294 $ 26,073,299 $ 26,802,066 $ 27,148,511 $ 280,200 $ 280,200 $ 208,800 $ 26,532,258 $ 27,775,771 $ 28,053,189 $ 1,037,894 $ 1,045,830 $ 1,065,718 $ 1,678,384 $ 1,599,193 $ 1,784,518 $ 1,918,251 $ 1,390,880 $ 1,721,375 $ 1,859,370 $ 1,772,101 $ 1,519,048 $ 146,501 $ 165,871 $ 149,533 $ 155,500 $ 155,500 $ 155,500 $ 3,102,646 $ 2,602,580 $ 2,936,626 $ 3,693,254 $ 3,526,794 $ 3,459,066 $ 6,165 $ 3,184 $ 9,160 $ 7,000 $ 10,000 $ 10,000 $ 375,626 $ 339,876 $ 343,228 $ 451,230 $ 483,496 $ 523,881 $ 118,081 $ 121,123 $ 98,275 $ 40,000 $ 40,000 $ 40,000 $ 499,872 $ 464,184 $ 450,663 $ 498,230 $ 533,496 $ 573,881 $ 13,850,238 $ 14,706,630 $ 13,521,486 $ 13,875,028 $ 14,208,043 $ 14,000,000 $ 328,571 $ 353,405 $ 368,091 $ 514,668 $ 488,152 $ 441,157 $ 9,162 $ 8,148 $ - $ - $ - $ - $ 14,187,971 $ 15,068,183 $ 13,889,577 $ 14,389,696 $ 14,696,195 $ 14,441,157 $ 144,106 $ 144,105 $ 144,105 $ 145,000 $ 145,000 $ 145,000 $ 1,512,071 $ 1,785,988 $ 2,215,298 $ 1,875,000 $ 2,550,000 $ 2,630,000 $ - $ - $ - $ 10,000 $ 10,000 $ 10,000 $ 28,361 $ 23,231 $ 16,956 $ 26,622 $ 76,483 $ 52,155 $ 1,684,538 $ 1,953,325 $ 2,376,359 $ 2,056,622 $ 2,781,483 $ 2,837,155 $ 606,544 $ 630,699 $ 606,292 $ 1,224,224 $ 1,190,420 $ 1,162,449 $ 256,554 $ 263,446 $ 363,615 $ 256,876 $ 274,166 $ 357,335 $ 863,097 $ 894,144 $ 969,907 $ 1,481,100 $ 1,464,586 $ 1,519,784 $ 17,153 $ 23,258 $ 26,057 $ 21,331 $ 10,361 $ 23,299 $ 115,324 $ 152,037 $ 160,532 $ 186,095 $ 209,666 $ 167,649 $ 10,875 $ 4,658 $ 18,634 $ 8,250 $ 5,500 $ 5,500 $ 47,286 $ 49,517 $ 41,404 $ 55,682 $ 58,078 $ 59,720 $ 190,638 $ 229,470 $ 246,627 $ 271,358 $ 283,605 $ 256,168 $ 5,010 $ - $ - $ - $ - $ - $ 339,637 $ 220,968 $ 294,666 $ 360,851 $ 357,201 $ 346,442 $ 344,647 $ 220,968 $ 294,666 $ 360,851 $ 357,201 $ 346,442 Detailed Income Statement Electric Division Administrative and General Adminstrative and General Labor (920) Office Supplies and Expenses (921) Outside Services (923) Property Insurance (924) Employee Pension & Benefits (926) Regulatory Expense (928) Misc. General Expense (930) Maint. Of General Plant (935) Total Administrative and General (920, 921, 923, 924, 926, 928, 930, 935) Other Expenses Depreciation Expense (403) Payment in Lieu of Taxes (408) Contribution To City - Roadway Lighting (408) Total Other Expenses (403, 407, 408) TOTAL OPERATING EXPENSES OPERATING INCOME (LOSS) NONOPERATING REVENUES/(EXPENSES) Merchandise & Contract Work, Net Interest Income Misc. Income Bond Service Fees Interest Expense - 2017B Bonds Gain (Loss) On Disposal Amortization --Development Study 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 & PCA) 2014 Actual I 2015 Actual I 2016 Actual N 2016 Budget I 2017 Budget I 2018 Budget $ 467,125 $ 452,383 $ 433,081 $ 254,183 $ 248,368 $ 274,966 $ 109,766 $ 106,060 $ 116,859 $ 91,736 $ 88,869 $ 77,427 $ 1,266,411 $ 1,355,579 $ 1,497,078 $ 24,305 $ 23,322 $ 18,084 $ 87,491 $ 67,948 $ 68,225 $ 63,752 $ 46,508 $ 36,585 $ 2,364,769 $ 2,389,037 $ 2,522,305 $ 417,549 $ 439,059 $ 449,079 $ 222,750 $ 322,664 $ 277,400 $ 80,306 $ 110,306 $ 80,306 $ 105,000 $ 88,200 $ 86,000 $ 189,134 $ 199,958 $ 178,250 $ 30,000 $ 30,000 $ 30,000 $ 119,636 $ 102,836 $ 102,836 $ 46,850 $ 46,842 $ 46,938 $ 1,211,225 $ 1,339,865 $ 1,250,809 $ 2,744,769 $ 2,816,301 $ 2,820,447 $ 2,700,000 $ 2,800,000 $ 2,900,000 $ 1,123,897 $ 384,391 $ 754,469 $ 754,469 $ 681,816 $ 882,327 $ - $ 146,739 $ 144,535 $ 144,535 $ 147,384 $ 147,384 $ 3,868,666 $ 3,347,431 $ 3,719,451 $ 3,599,004 $ 3,629,200 $ 3,929,711 $ 27,106,844 $ 27,169,322 $ 27,406,181 $ 27,561,340 $ 28,612,425 $ 28,614,173 $ (1,033,545) $ (367,256) $ (257,670) $ (1,029,082) $ (836,654) $ (560,984) $ 41,724 $ (49,243) $ (24,216) $ - $ - $ (1,000) $ 14,860 $ 15,978 $ 4,186 $ 57,500 $ 50,000 $ 50,000 $ 35,408 $ 129,966 $ 83,272 $ - $ - $ - $ (450) $ - $ (900) $ (2,400) $ (2,400) $ (2,400) $ (40,082) $ (35,196) $ (30,185) $ (30,613) $ (25,488) $ (606,763) $ 23,159 $ - $ 20,379 $ $ $ $ (525,943) $ (262,972) $ - $ $ $ $ (451,324) $ (201,466) $ 52,536 $ 24,487 $ 22,112 $ (560,163) $ (1,484,869) $ (568,722) $ (205,134) $ (1,004,595) $ (814,542) $ (1,121,147) $ 19,475,027 $ 20,088,271 $ 19,653,225 $ 20,637,802 $ 21,537,968 $ 21,311,259 $ 6,598,272 $ 6,713,795 $ 7,495,286 $ 5,894,456 $ 6,237,803 $ 6,741,930 25.3% 25.0% 27.6% 22.2% 22.5% 24.0% -4.0% -1.4% -0.9% -3.9% -3.0% -2.0% -5.7% -2.1% -0.8% -3.8% -2.9% -4.0% -7.0% -1.8% -3.0% NET INCOME 2018 Net Income $ (1,121,147) Cap. Labor- Production $ 2,000 Cap. Labor- Distribution $ 267,000 2018 Net Income $ (852,147) CASH FLOW STATEMENT 2018 Net Income $ (1,121,147) Depreciation $ 2,900,000 2018 Cap Exp $ (1,196,500) 2017/18 SIDE Proceeds $ 98,500 2018 Electric Cash Flow $ 680,853 2018 Cap Exp (As necessary)':,t6 17f7, � :4 � :4'144� 10 C4 1 llzl �Fm ) I ) k • • t I Hutchinson Utilities Commission Capital Improvement Plan 2018 thra 2022 PROJECTS BY DEPARTMENT Department Project # Priority 2018 2019 2020 2021 2022 Total Administration Chevrolet Tahoe 827 3 28,644 28,644 Administration Total 28,644 28,644 Electric - Distribution Dodge Ram 1500 226E 2 28,982 28,982 Vactron Trailer 270E 1 67,531 67,531 Vactron Drill 270E- 1 1 157,571 157,571 Roof Replacement - Hutch Sub 361-18-1 3 10,000 10,000 Station Equipment 362-18-1 2 10,000 10,000 Station Equipment 362-19-1 2 10,000 10,000 Station Equipment 362-20-1 2 10,000 10,000 Station Equipment 362-21-1 2 10,000 10,000 Station Equipment 362-22-1 2 10,000 10,000 Duct Installation 366-18-1 3 15,000 15,000 Duct Installation 366-19-1 3 15,000 15,000 Duct Installation 366-20-1 3 15,000 15,000 Duct Installation 366-21-1 3 15,000 15,000 Duct Installation 366-22-1 3 15,000 15,000 Uponnor Building New Feed 367-18-1 2 85,000 85,000 New Re -Conductor (Fdr #16 & #15) 367-18-2 2 30,000 30,000 Century Ave Trail Work 367-18-3 3 10,000 10,000 New Developments 367-18-4 6 51,000 51,000 MITGI New Feed 367-18-5 2 80,000 80,000 Century Court Appt 367-18-6 1 20,000 20,000 Energy Park Infrastructure 367-19-1 6 75,000 75,000 Fdr #15 & #14 Reconductor 367-19-2 2 30,000 30,000 New Developments 367-19-3 6 51,000 51,000 Fdr #12A Reconductor 367-20-1 2 30,000 30,000 Fdr#14 Reconductor 367-20-2 2 75,000 75,000 New Developments 367-20-3 6 51,000 51,000 New Developments 367-21-1 6 51,000 51,000 Fdr # 22 Loop 367-21-2 2 60,000 60,000 New Developments 367-22-1 6 51,000 51,000 Transformer Replacement 368-18-1 1 40,000 40,000 Transformers - New Developments 368-18-2 6 50,000 50,000 Century Court Apartments 368-18-3 2 10,000 10,000 Plant 14160 Generator Transformer Replacement 368-18-4 1 70,000 70,000 Transformer Replacement 368-19-1 1 40,000 40,000 Transformers - New Developments 368-19-2 6 50,000 50,000 Transformer Replacement 368-20-1 1 40,000 40,000 Transformers - New Developments 368-20-2 6 50,000 50,000 Fdr #12A Reconductor 368-20-3 6 15,000 15,000 Transformer Replacement 368-21-1 1 40,000 40,000 Transformers - New Developments 368-21-2 6 50,000 50,000 Transformer Replacement 368-22-1 1 40,000 40,000 Produced Using the Plan -It Capital Planning Software Page 1 Thursday, December 07, 2017 Department Project # Priority 2018 2019 2020 2021 2022 Total Transformers - New Development 368-22-2 Meters 370-18-1 Meters 370-19-1 Meters 370-20-1 Meters 370-21-1 Meters 370-22-1 Ford F550 Super Duty Bucket Truck 572E Ford F350 Super Duty Service Truck 573E Ford F350 Super Duty Service Truck 574E GMC Metering Van 939E Dodge Dakota 44 995E John Deere 310 Backhoe TBD - 2 Electric - Distribution Total Electric - Production 30,000 Unit 8 Building Spancrete Joint Replacement 341-18-1 Unit 1 Control Building A/C Upgrade 341-18-2 Plant 2 Parking Lot Replacement 341-19-1 Plant 2 Building Repainting 341-19-2 Roof Replacement Plant 1 341-20-1 Plant 1 Cooling Tower Piping Replacement 343-18-1 Unit 1 LM -6000 Blade Replacement 344-18-1 Motor Controllers 344-18-2 Units 6 & 7 344-18-3 Unit 8 Controls Upgrade 344-19-1 Unit 5 Air Inlet Heating Loop Upgrade 344-19-2 Unit #8 Hot Gas Path Inspection 344-20-1 Unit#8 Boiler Retube 344-21-1 Unit#8 Steam Turbine Inspection/Overhaul 344-22-1 Data Logger 345-18-1 Dodge Dakota 44 410E Chevrolet Silverado 542J Electric - Production Total Electric - Transmission 28,982 Engineering Transmission Loop HTI 353-22-1 Pole Repair or Replacement 354-18 Pole Repair or Replacement 354-19 Pole Repair or Replacement 354-20 Pole Repair or Replacement 354-21 Pole Repair or Replacement 354-22 Electric - Transmission Total Engineering Ford F-150 X -cab 650 Engineering Total GRAND TOTAL 6 50,000 50,000 2 30,000 30,000 2 30,000 30,000 2 30,000 30,000 2 30,000 30,000 2 30,000 30,000 1 140,000 140,000 1 53,045 53,045 1 54,636 54,636 3 25,750 25,750 2 28,982 28,982 1 87,418 87,418 676,750 354,045 458,054 481,102 253,964 2,223,915 3 10,000 10,000 3 15,000 15,000 3 80,000 80,000 3 100,000 100,000 3 30,000 30,000 2 357,000 357,000 1 150,000 150,000 3 8,000 8,000 1 14,369,702 14,369, 702 3 80,000 80,000 3 10,000 10,000 3 150,000 150,000 2 300,000 300,000 3 175,000 175,000 2 30,000 30,000 3 25,000 25,000 3 26,523 26,523 14,964,702 296,523 180,000 300,000 175,000 15,916,225 3 75,000 75,000 6 15,000 15,000 6 15,000 15,000 6 15,000 15,000 6 15,000 15,000 6 15,000 15,000 15,000 15,000 15,000 15,000 90,000 150,000 1 25,750 25,750 25,750 25,750 15,682,202 694,212 653,054 796,102 518,964 18,344,534 Produced Using the Plan -It Capital Planning Software Page 2 Thursday, December• 07, 2017 Hutchinson Utilities Commission Capital Improvement Plan 2018 thra 2022 PROJECTS BY FUNDING SOURCE Source Project # Priority 2018 Bond Proceeds Units 6 & 7 344-18-3 1 14 369 702 Bond Proceeds Total Capital Replacement Reserves Unit 8 Building Spancrete Joint Replacement 341-18-1 Unit 1 Control Building A/C Upgrade 341-18-2 Plant 2 Parking Lot Replacement 341-19-1 Plant 2 Building Repainting 341-19-2 Roof Replacement Plant 1 341-20-1 Plant 1 Cooling Tower Piping Replacement 343-18-1 Unit 1 LM -6000 Blade Replacement 344-18-1 Motor Controllers 344-18-2 Unit 8 Controls Upgrade 344-19-1 Unit 5 Air Inlet Heating Loop Upgrade 344-19-2 Unit #8 Hot Gas Path Inspection 344-20-1 Unit#8 Boiler Retube 344-21-1 Unit#8 Steam Turbine Inspection/Overhaul 344-22-1 Data Logger 345-18-1 Engineering Transmission Loop HTI 353-22-1 Pole Repair or Replacement 354-18 Pole Repair or Replacement 354-19 Pole Repair or Replacement 354-20 Pole Repair or Replacement 354-21 Pole Repair or Replacement 354-22 Roof Replacement - Hutch Sub 361-18-1 Station Equipment 362-18-1 Station Equipment 362-19-1 Station Equipment 362-20-1 Station Equipment 362-21-1 Station Equipment 362-22-1 Duct Installation 366-18-1 Duct Installation 366-19-1 Duct Installation 366-20-1 Duct Installation 366-21-1 Duct Installation 366-22-1 Uponnor Building New Feed 367-18-1 New Re -Conductor (Fdr #16 & #15) 367-18-2 Century Ave Trail Work 367-18-3 New Developments 367-18-4 MITGI New Feed 367-18-5 Century Court Appt 367-18-6 Energy Park Infrastructure 367-19-1 Fdr #15 & #14 Reconductor 367-19-2 14,369,702 3 10,000 3 15,000 3 3 3 2 357,000 1 150,000 3 8,000 3 3 3 2 3 2 30,000 3 6 15,000 6 6 6 6 3 10,000 2 10,000 2 2 2 2 3 15,000 3 3 3 3 2 85,000 2 30,000 3 10,000 6 51,000 2 80,000 1 20,000 6 2 2019 2020 2021 2022 Total 80,000 100,000 75,000 30,000 14,369, 702 14,369,702 10,000 15,000 80,000 100,000 30,000 357,000 150,000 8,000 80,000 10,000 150,000 300,000 175,000 30,000 75,000 15,000 15,000 15,000 15,000 15,000 10,000 10,000 10,000 10,000 10,000 10,000 15,000 15,000 15,000 15,000 15,000 85,000 30,000 10,000 51,000 80,000 20,000 75,000 30,000 Produced Using the Plan -It Capital Planning Software Page 1 Thursday, December 07, 2017 30,000 80,000 10,000 150,000 300,000 175,000 75,000 15,000 15,000 15,000 15,000 10,000 10,000 10,000 10,000 15,000 15,000 15,000 15,000 75,000 30,000 14,369, 702 14,369,702 10,000 15,000 80,000 100,000 30,000 357,000 150,000 8,000 80,000 10,000 150,000 300,000 175,000 30,000 75,000 15,000 15,000 15,000 15,000 15,000 10,000 10,000 10,000 10,000 10,000 10,000 15,000 15,000 15,000 15,000 15,000 85,000 30,000 10,000 51,000 80,000 20,000 75,000 30,000 Produced Using the Plan -It Capital Planning Software Page 1 Thursday, December 07, 2017 Source Project # Priority 2018 2019 2020 2021 2022 Total New Developments 367-19-3 Fdr #12A Reconductor 367-20-1 Fdr #14 Reconductor 367-20-2 New Developments 367-20-3 New Developments 367-21-1 Fdr # 22 Loop 367-21-2 New Developments 367-22-1 Transformer Replacement 368-18-1 Transformers - New Developments 368-18-2 Century Court Apartments 368-18-3 Plant 14160 Generator Transformer Replacement 368-18-4 Transformer Replacement 368-19-1 Transformers - New Developments 368-19-2 Transformer Replacement 368-20-1 Transformers - New Developments 368-20-2 Fdr #12A Reconductor 368-20-3 Transformer Replacement 368-21-1 Transformers - New Developments 368-21-2 Transformer Replacement 368-22-1 Transformers - New Development 368-22-2 Meters 370-18-1 Meters 370-19-1 Meters 370-20-1 Meters 370-21-1 Meters 370-22-1 Capital Replacement Reserves Total 50,000 Fleet Designated Reserves Dodge Ram 1500 226E Vactron Trailer 270E Vactron Drill 270E- 1 Dodge Dakota 44 410E Chevrolet Silverado 542J Ford F550 Super Duty Bucket Truck 572E Ford F350 Super Duty Service Truck 573E Ford F350 Super Duty Service Truck 574E Ford F-150 X -cab 650 Chevrolet Tahoe 827 GMC Metering Van 939E Dodge Dakota 44 995E John Deere 310 Backhoe TBD - 2 Fleet Designated Reserves Total GRAND TOTAL 6 6 51,000 51,000 2 30,000 30,000 2 75,000 75,000 6 51,000 51,000 6 51,000 51,000 2 60,000 60,000 6 51,000 51,000 1 40,000 40,000 6 50,000 50,000 2 10,000 10,000 1 70,000 70,000 1 40,000 40,000 6 50,000 50,000 1 40,000 40,000 6 50,000 50,000 6 15,000 15,000 1 40,000 40,000 6 50,000 50,000 1 40,000 40,000 6 50,000 50,000 2 30,000 30,000 2 30,000 30,000 2 30,000 30,000 2 30,000 30,000 2 30,000 30,000 1,096,000 586,000 511,000 571,000 461,000 3,225,000 2 28,982 28,982 1 67,531 67,531 1 157,571 157,571 3 25,000 25,000 3 26,523 26,523 1 140,000 140,000 1 53,045 53,045 1 54,636 54,636 1 25,750 25,750 3 28,644 28,644 3 25,750 25,750 2 28,982 28,982 1 87,418 87,418 216,500 108,212 142,054 225,102 57,964 749,832 15,682,202 694,212 653,054 796,102 518,964 18,344,534 Produced Using the Plan -It Capital Planning Software Page 2 Thursday, December 07, 2017 2018 Budget Electric Davaszon Detail GL NUMBER DESCRIPTION 2015 ACTUALS 2016 ACTUALS 2017 APPROVED BUDGET 2018 REQUESTED BUDGET REVENUES 1-00-400-440-0000 Residential Sales (Electric) 4,844,525 5,029,631 5,081,090 5,104,229 1-00-400-440-0100 All Electric 236,439 239,630 259,092 254,096 1-00-400-442-0000 Small General Service - Single 1,621,751 1,730,236 1,687,402 1,721,391 1-00-400-442-0200 Large General Service 5,808,937 5,580,399 6,171,369 6,008,636 1-00-400-442-0300 Large General Service - Demand 1,332,403 1,257,204 1,333,752 1,326,999 1-00-400-442-0400 Industrial 9,513,635 9,073,317 8,678,712 8,945,042 1-00-400-442-0500 Industrial Demand 1,885,520 1,868,300 1,826,660 1,817,412 1-00-400-444-0000 Street Lighting 146,931 144,641 147,384 147,384 1-00-400-447-0000 Sales For Resale 1,114,918 1,931,859 2,310,110 2,519,200 1-00-400-450-0000 Forfeited Discounts 27,567 30,381 25,000 25,000 1-00-400-450-0100 Collection Fee 27,280 27,400 21,000 21,000 1-00-400-450-0200 Reconnection Fee 24,700 23,610 20,000 20,000 1-00-400-450-0300 Fee For Returned Checks 3,900 3,360 4,000 2,600 1-00-400-450-0400 Late Payment Charge 201,591 196,590 200,000 130,000 1-00-400-451-0100 Temporary Connection 700 700 200 200 1-00-400-454-0100 Security Lights 11,269 11,253 10,000 10,000 1-00-400-454-0200 Pole Rental - Telephone Company - - - - 1-00-400-454-0300 Pole Rental - Cable Tv - - - - 1-00-415-105-0000 Electric Services - Labor 55,356 44,443 - - 1-00-415-105-0100 Electric Services - Material - - - - 1-00-415-106-0000 Street Lighting - Labor - 11,550 - - 1-00-415-107-0000 Third Party Damage - Labor - - - - 1-00-415-107-0100 Third Party Damage - Material - - - - 1-00-419-000-0000 Interest And Dividend Income 15,978 48,579 50,000 50,000 1-00-419-000-0200 Investment FMV Adjustment - (44,393) - - 1-00-421-000-0000 Misc Income - - - - 1-00-421-000-0100 Gain On Disposal - Electric - 20,379 - - 1-00-421-000-0200 Loss On Disposal - Electric - - - - 1-00-421-000-0400 Misc. Income - Electric 129,966 83,272 - - 1-00-421-000-0500 Misc Income - Interruptible Cr - - - - TOTAL REVENUES 27,003,366 27,312,341 27,825,771 28,103,189 GL NUMBER DESCRIPTION 2015 ACTUALS 2016 ACTUALS 2017 APPROVED BUDGET 2018 REQUESTED BUDGET 1-00-401-916-0300 Other Programs - - - - 1-00-403-000-0150 Depreciation Contributed Asset - - - - 1-00-407-000-0000 Amortization - Development Stu - - - - 1-00-408-000-0000 Payment In Lieu Of Taxes To City 384,391 754,469 681,816 882,327 1-00-416-103-0000 Trucks - - - - 1-00-416-104-0000 Trucks - Labor 588 352 - - 1-00-416-106-0100 Street Lighting - Material 67,518 46,495 - - 1-00-428-000-0000 Amortization Of Debt Disc Elec 262,972 - - - 1-00-428-000-0200 Prior Period Adjustment -Elect - - - - Totals for dept 00 -ELECTRIC MISCELLANEOUS 715,469 801,316 681,816 882,327 ��Illffffffffflllllllllllllllllllllllll��ll 1-01-401-546-0000 Production Operations 1-01-401-546-0100 Supervision 147,366 162,823 1,009,482 1,129,394 1-01-401-546-0200 Training - Labor 10,284 13,790 - - 1-01-401-546-0300 Training - Expense 7,433 22,511 25,000 25,000 1-01-401-546-0400 Operating Labor 682,437 665,863 - - 1-01-401-546-0500 Vacation 76,528 90,098 - - 1-01-401-546-0600 Other - Labor 316 1,841 - - 1-01-401-546-0700 Sick Leave 49,701 40,822 5,035 8,124 1-01-401-546-0800 Holiday Pay 61,568 58,979 - - 1-01-401-546-1200 Building Maintenance Labor - - - - 1-01-401-546-1300 Engineering - Labor - - - - 1-01-401-546-1400 Cad - Labor - - - - 1-01-401-546-1500 Drug And Alcohol Testing - Lab 134 - - - 1-01-401-546-1600 Meetings & Travel - Labor (Sta 1,978 3,740 - - 1-01-401-546-1700 Meetings & Travel - Expense (S 4,923 5,251 15,000 45,000 1-01-401-546-1800 PRODUCTION BENEFITS - - 544,676 577,000 1-01-401-547-0101 Generator #1 Natural Gas 179,944 486,968 689,400 522,000 1-01-401-547-0102 Generator #1 Aux Boiler 2,030 2,285 5,000 5,000 1-01-401-547-0103 Generator #1 Water & Sewer 10,672 14,406 16,000 16,000 1-01-401-547-0104 Generator #1 Transportation 641,833 647,166 651,700 656,366 1-01-401-547-0201 Generator #2 Natural Gas - - - - 1-01-401-547-0202 Generator #2 Fuel Oil - - 100 100 1-01-401-547-0301 Generator #3 Natural Gas 17,755 34,585 38,300 14,500 1-01-401-547-0302 Generator #3 Fuel Oil 9,139 13,192 15,000 15,000 1-01-401-547-0401 Generator #4 Natural Gas 25,149 39,501 38,300 14,500 1-01-401-547-0402 Generator #4 Fuel Oil 17,087 14,055 15,000 15,000 1-01-401-547-0501 Generator #5 Natural Gas 73,256 102,344 134,816 102,080 1-01-401-547-0602 Generator #6 Fuel Oil - - - 1,276 1-01-401-547-0701 Generator #7 Natural Gas - - - 1,276 1-01-401-547-0702 Generator #7 Fuel Oil - - - - 1-01-401-547-0801 Generator #8 Natural Gas 407,239 359,130 163,485 150,950 1-01-401-547-0901 Generator #9 Natural Gas 6,776 7,743 5,000 5,000 1-01-401-547-0902 Generator #9 Fuel Oil - - - - 1-01-401-550-0101 Generator #1 Lubricants 2,130 66 2,500 2,500 1-01-401-550-0102 Generator #2 Lubricants - - - - 1-01-401-550-0103 Generator #3 Lubricants 2,183 19,371 2,000 2,000 1-01-401-550-0104 Generator #4 Lubricants 1,383 1,991 2,000 2,000 1-01-401-550-0105 Generator #5 Lubricants 2,064 1,839 3,500 3,500 GL NUMBER DESCRIPTION 2015 ACTUALS 2016 ACTUALS 2017 APPROVED BUDGET 2018 REQUESTED BUDGET 1-01-401-550-0106 Generator #6 Lubricants - - - - 1-01-401-550-0107 Generator #7 Lubricants - - - - 1-01-401-550-0108 Generator #8 Lubricants - 723 1,500 1,500 1-01-401-550-0109 Generator #9 Lubricants 745 745 1,000 1,000 1-01-401-550-0200 Supplies 33,754 14,091 12,000 12,000 1-01-401-550-0301 Generator #1 Chemicals 18,825 19,339 34,000 34,000 1-01-401-550-0302 Plant #1 Chemicals 44,671 35,674 55,000 55,000 1-01-401-550-0400 Uniforms & Laundry 20,218 15,468 10,000 10,000 1-01-401-550-0500 Waste Disposal 29,492 31,745 26,000 26,000 1-01-401-550-0600 Vehicle/Equipment Fuel 2,365 1,889 5,500 5,500 1-01-401-550-0700 Permits And Rent 8,041 6,592 500 500 1-01-402-554-0000 Production Maintenance - - - - 1-01-402-554-0100 Maint Power Prod Plant - Build 3,184 9,160 10,000 10,000 1-01-402-554-0101 Generator #1 Labor 51,868 68,097 353,496 351,381 1-01-402-554-0102 Generator #1 Material 25,336 43,613 50,000 50,000 1-01-402-554-0106 Generator #1 Outside Services 975 4,951 25,000 40,000 1-01-402-554-0201 Generator #2 Labor 6,431 937 - - 1-01-402-554-0202 Generator #2 Material 10 458 500 500 1-01-402-554-0301 Generator #3 Labor 24,157 29,014 - - 1-01-402-554-0302 Generator #3 Material 9,748 32,414 9,000 7,500 1-01-402-554-0401 Generator #4 Labor 20,546 23,890 - - 1-01-402-554-0402 Generator #4 Material 4,133 20,242 7,500 7,500 1-01-402-554-0501 Generator #5 Labor 44,470 24,165 - - 1-01-402-554-0502 Generator #5 Material 28,725 20,970 10,000 35,000 1-01-402-554-0601 Generator #6 Labor - - - - 1-01-402-554-0602 Generator #6 Material - - - - 1-01-402-554-0701 Generator #7 Labor - - - - 1-01-402-554-0702 Generator #7 Material - - - - 1-01-402-554-0801 Generator #8 Labor 61,337 35,106 - - 1-01-402-554-0802 Generator #8 Material 31,600 17,527 20,000 24,000 1-01-402-554-0901 Generator #9 Labor 24,505 17,966 - - 1-01-402-554-0902 Generator #9 Material 6,036 3,878 8,000 8,000 1-01-402-554-1001 Accessory Plant - Labor 48,853 40,280 - - 1-01-402-554-1002 Accessory Plant - Materials 12,153 18,797 20,000 20,000 1-01-402-554-1101 Vehicles - Labor 1,324 606 - - 1-01-402-554-1102 Vehicles - Material 1,559 380 2,000 2,000 1-01-402-554-1201 Maintenance Other - Labor 6,654 6,971 - - 1-01-402-554-1202 Maintenance Other - Materials 3,712 6,142 7,000 7,000 1-01-402-554-1203 Outside Services 26,304 23,295 11,000 11,000 1-01-402-554-1300 Obsolete Material Charged Off 20,564 1,804 - - Totals for dept 01 -ELECTRIC PRODUCTION 3,063,603 3,387,289 4,060,290 4,032,947 2017 2018 2015 2016 APPROVED REQUESTED GL NUMBER DESCRIPTION ACTUALS ACTUALS BUDGET BUDGET Dept 02 -ELECTRIC DISTRIBUTION 1-02-416-106-0000 Street Lighting - Labor - - - - 1-02-401-555-0000 Electric Purchased Power - - - - 1-02-401-555-0200 Purchased Power 14,706,630 13,521,486 14,208,043 14,000,000 1-02-401-580-0000 Electric Distribution Operation - - - - 1-02-401-580-0100 Supervision 84,531 84,210 76,799 97,375 1-02-401-580-0200 Training - Labor 22,407 14,324 - - 1-02-401-580-0300 Training - Expense 1,136 1,522 5,000 5,000 1-02-401-580-0400 Meetings & Travel - Labor (Sta 6,631 9,649 - - 1-02-401-580-0500 Meetings & Travel - Expense (S 5,274 2,154 3,000 3,000 1-02-401-580-0600 DISTRIBUTION BENEFITS - - 378,580 380,000 1-02-401-581-0100 Line - Labor 51,278 57,919 57,388 57,082 1-02-401-581-0200 Line - Materials 10,363 10,108 15,000 15,000 1-02-401-586-0100 Meter - Labor 68,152 43,703 1,688 47,847 1-02-401-586-0200 Meter - Materials 25 1,849 - 2,000 1-02-401-588-0100 Vacation 66,353 67,827 274,282 163,691 1-02-401-588-0200 Materials 13,248 9,212 10,000 10,000 1-02-401-588-0300 Other Labor - 2,843 251,496 250,153 1-02-401-588-0400 Vehicles/Equipment Fuel 16,464 14,482 20,000 20,000 1-02-401-588-0500 Sick Leave 30,566 36,043 2,820 1,850 1-02-401-588-0600 Holiday Pay 41,773 40,600 - - 1-02-401-588-1000 Call Time 21,762 24,303 - - 1-02-401-588-1100 Building Maintenance - Labor 66,364 18,112 58,867 86,451 1-02-401-588-1200 Service Connection - Labor 673 301 - - 1-02-401-588-1300 Mapping/Gps - Labor 3,342 - - - 1-02-401-588-1400 Switching - Labor 1,875 1,804 - - 1-02-401-588-1500 Engineering - Labor 21 - - - 1-02-401-588-1600 Cad - Labor - - - - 1-02-401-588-1700 Drug And Alcohol Testing - Lab - - - - 1-02-401-588-1900 Uniforms & Laundry 28,607 17,454 18,000 18,000 1-02-401-588-2000 Engineering Tech - Labor 59,407 57,292 - - 1-02-401-588-2100 Transformer Oil Testing Labor 1,378 64,394 - - 1-02-401-588-2200 Territory Service Agreements 29,068 26,187 17,500 5,000 1-02-401-589-0000 Rents & Leases (Dakota Rail) - - - - 1-02-402-592-0000 Electric Distribution Maintenance - - - - 1-02-402-592-0100 Building & Grounds - Labor 9,986 9,967 9,307 9,605 1-02-402-592-0200 Building & Grounds - Materials 100 83 1,000 1,000 1-02-402-592-0400 Structures & Equipment - Contr - 2,070 1,000 1,000 1-02-402-592-0500 Structures & Equipment - Mater - 1,375 1,000 1,000 1-02-402-594-0100 Line - Labor 73,130 168,930 107,181 190,552 1-02-402-594-0200 Line - Materials 27,035 36,044 20,000 20,000 1-02-402-595-0100 Transformer - Labor 5,492 3,020 5,908 5,876 1-02-402-595-0200 Transformer - Materials 5,079 13,029 8,000 8,000 1-02-402-596-0100 Street Lighting - Labor 67,264 46,121 60,764 60,440 1-02-402-596-0200 Street Lighting - Materials 23,007 17,198 15,000 15,000 1-02-402-598-0201 Vehicles - Labor 14,314 5,527 27,006 26,862 1-02-402-598-0202 Vehicles - Material 19,453 16,434 12,000 12,000 1-02-402-598-0301 Power Equipment - Labor 5,037 10,215 - - 1-02-402-598-0302 Power Equipment - Materials 4,171 20,665 4,000 4,000 1-02-402-598-0400 Obsolete Materials Charged Off 325 - - - 1-02-402-598-0501 Other Equipment - Labor 8,880 11,638 - - 1-02-402-598-0502 Other Equipment - Materials 171 1,299 2,000 2,000 1-02-408-000-0100 Roadway Lighting 146,739 144,535 147,384 147,384 1-02-416-101-0000 Material & Contracted Labor 659 (30) - - 1-02-416-105-0000 Electric Services - Labor 27,890 19,132 - - 1-02-416-107-0000 Third Party Damage - Labor 7,697 14,260 - - 1-02-416-107-0100 Third Party Damage - Material - - - 1,000 Totals for dept 02 -ELECTRIC DISTRIBUTION 15,783,757 14,669,290 15,820,013 15,668,168 GL NUMBER DESCRIPTION 1-03-401-556-0100 System Control Labor 1-03-401-556-0200 Vacation 1-03-401-556-0300 Sick Leave 1-03-401-556-0400 Holiday Pay 1-03-401-556-0500 Mcg Software 1-03-401-556-0600 Training - Labor 1-03-401-556-0700 Training - Expense 1-03-401-556-0800 SYSTEM CONTROL BENEFITS 1-03-401-557-0000 Professional Services - Outside 1-03-401-557-0100 Rw Beck 1-03-401-560-0000 Electric Transmission Operation 1-03-401-560-0100 Station Expense - Labor 1-03-401-560-0200 Line Expense - Labor 1-03-401-565-0100 Transmission Expense 1-03-401-567-0100 Materials 1-03-401-567-0200 Outside Services 1-03-402-574-0000 Electric Transmission Maintenance 1-03-402-574-0100 Labor 1-03-402-574-0200 Materials 1-03-402-574-0300 Outside Services 1-03-402-574-0400 Ita Maintenance Totals for dept 03 -ELECTRIC TRANSMISSION 1-06-401-902-0100 Meter Reading - Labor 1-06-401-902-0200 Meter Reading - Materials 1-06-401-903-0000 Collection Expense 1-06-401-903-0100 Collection - Labor 1-06-401-903-0200 Collection - Materials 1-06-401-903-0300 Vacation 1-06-401-903-0400 Supervisor 1-06-401-903-0500 Sick Leave 1-06-401-903-0600 Holiday Pay 1-06-401-903-1101 Meetings & Travel - Labor (Sta 1-06-401-903-1102 Meetings & Travel - Expense (S 1-06-401-903-1201 Training - Labor 1-06-401-903-1202 Training - Expense 1-06-401-903-1300 COLLECTION BENEFITS 1-06-401-904-0000 Bad Debt Write Offs 1-06-401-906-0100 Customer Service - Labor Totals for dept 06 -CUSTOMER SERVICE 89 - 2,750 2,750 2017 2018 2015 2016 APPROVED REQUESTED ACTUALS ACTUALS BUDGET BUDGET 0r i f FFFFM 271,800 282,926 297,679 256,130 21,511 23,787 - - 11,034 5,186 2,009 1,427 15,509 16,118 - - 33,550 39,650 36,600 36,600 - 276 - - - 148 1,000 1,000 - - 150,864 146,000 8,148 - - - 144,105 144,105 145,000 145,000 1,785,988 2,215,298 2,550,000 2,630,000 - - 10,000 10,000 12,719 11,375 16,483 18,155 5,694 1,556 10,000 10,000 4,818 4,025 50,000 24,000 2,314,876 3,269,635 3,278,312 f2,,,7rr((44,450 /�I �ri�01,14 �IIIIIIII��I��IIII�IIIII�� 18,414 22,530 10,361 23,299 4,844 3,527 - - 11,655 11,841 4,317 16, 642 92,407 96,839 129,082 72,000 8,601 6,161 - - 29,124 31,194 41,484 42,657 3,956 8,864 544 600 5,863 5,633 - - 342 - - - 89 - 2,750 2,750 - - 31,489 33,000 4,658 18,634 5,500 5,500 49,517 41,404 58,078 59,720 229,470 246,627 283,605 256,168 GL NUMBER DESCRIPTION 1-07-401-911-0000 Supervision (Conservation Impr 1-07-401-916-0100 Labor Imp 1-07-401-916-0200 Tree Planting 1-07-401-916-0301 Cip - Residential 1-07-401-916-0302 Cip- Commercial 1-07-401-916-0303 Cip - Industrial 1-07-401-916-0304 Cip - Marketing 1-07-401-916-0305 Doc - Cip Assessment 1-07-401-916-0400 Cip - Transfer To Assets Totals for dept 07 -CONSERVATION IMPROVEMENT 2017 2018 2015 2016 APPROVED REQUESTED ACTUALS ACTUALS BUDGET BUDGET 49,768 53,242 43,201 67,392 22,500 22,500 30,000 22,500 55,657 69,918 48,698 43,182 41,925 83,471 88,510 77,098 29,909 41,718 123,792 113,270 3,367 1,814 5,000 5,000 17,844 22,003 13,000 13,000 - - 5,000 5,000 220,970 294,666 357,201 346,442 1-08-431-000-0100 Interest - Customers Deposits - - - - 1-08-401-920-0000 General & Administrative - - - - 1-08-401-920-0100 Supervision Salaries 86,771 87,137 106,693 106,409 1-08-401-920-0200 General Salaries Labor 298,357 272,612 331,354 340,889 1-08-401-920-0300 Vacation 40,022 45,899 - - 1-08-401-920-0500 Sick Leave 11,355 7,572 1,012 1,781 1-08-401-920-0600 Holiday Pay 19,284 19,861 - - 1-08-401-920-0700 Engineering - Labor - - - - 1-08-401-920-0800 Cad - Labor - - - - 1-08-401-920-0900 Drug And Alcohol Testing - Lab - - - - 1-08-401-921-0100 Telephone 32,918 33,891 32,250 32,250 1-08-401-921-0200 Office Supplies 14,075 13,842 18,750 18,750 1-08-401-921-0300 Lease/Service Agreements 23,447 24,443 24,750 24,750 1-08-401-921-0400 Postage 1,832 2,976 4,500 4,500 1-08-401-921-0500 Mail Services - Ups, Fedex 1,605 1,602 2,400 2,400 1-08-401-921-0600 It Admin And Support 173,207 193,941 236,264 191,000 1-08-401-921-0700 Advertising/Printing 1,284 4,271 3,750 3,750 1-08-401-923-0000 Outside Services - - - - 1-08-401-923-0200 Legal Services 34,556 34,987 31,500 31,500 1-08-401-923-0300 Engineering Services - - 30,000 - 1-08-401-923-0400 Misc Services 17,663 51,315 18,000 18,000 1-08-401-923-0500 Human Resources Services 48,217 24,806 24,806 24,806 1-08-401-923-0600 Drug Testing Services 5,625 5,751 6,000 6,000 1-08-401-924-0100 Property Insurance 27,784 27,105 30,000 32,000 1-08-401-924-0200 Boiler Insurance 35,778 35,750 40,200 39,000 1-08-401-924-0300 General Liability 25,308 14,572 18,000 15,000 1-08-401-924-0400 Excess Liability Insurance (No - - - - 1-08-401-926-0101 Health Insurance 719,849 653,422 188,708 167,000 1-08-401-926-0200 Fica Taxes 229,569 226,848 - - 1-08-401-926-0300 Pera 284,516 501,427 - - 1-08-401-926-0400 Uniforms 178 1,310 - - 1-08-401-926-0500 Brea kroom/Recognition Banquet 10,821 7,194 11,250 11,250 1-08-401-926-0700 Unemployment Compensation Obso 89 - - - 1-08-401-926-0800 Life/Ltd/Ad&D Insurance 19,242 18,858 - - 1-08-401-926-0900 Worker'S Compensation 59,899 56,978 - - 1-08-401-926-1000 Dental Insurance 31,416 31,041 - - 1-08-401-926-1100 Pandemic Flu Supplies - - - - 1-08-401-928-0000 Regulatory Expenses 23,322 18,084 30,000 30,000 1-08-401-930-0100 Commissioners Labor 14,517 15,273 15,836 15,836 GL NUMBER DESCRIPTION 1-08-401-930-0201 Meetings & Travel - Labor (Sta 1-08-401-930-0202 Meetings & Travel - Expense (S 1-08-401-930-0301 Training - Labor 1-08-401-930-0302 Training - Expense 1-08-401-930-0400 Dues/Membership Expense 1-08-401-930-0500 Utility Expenses - Water/Waste 1-08-401-930-0600 Mapp Dues 1-08-401-930-0800 Misc Expense 1-08-401-935-0101 Grounds - Labor 1-08-401-935-0102 Grounds - Materials 1-08-401-935-0103 Grounds - Outside Services 1-08-401-935-0200 Misc Expenses 1-08-401-935-0201 Misc Other - Labor 1-08-401-935-0202 Misc Other - Materials 1-08-401-935-0203 Vehicles/Equipment Fuel 1-08-401-935-0301 Vehicles - Labor 1-08-401-935-0302 Vehicles - Material 1-08-403-000-0100 Electric Depreciation 1-08-427-000-0000 Interest Expense 1-08-427-000-0200 Bond Service Fees 1-08-427-000-0300 Interest - Development Study 1-08-427-000-0700 Interest - 2017B Bonds Electric Totals for dept 08 -GENERAL & ADMINISTRATION 2015 2016 ACTUALS ACTUALS 2017 APPROVED BUDGET 2018 REQUESTED BUDGET 66 99 - - 3,643 2,569 9,000 9,000 23,448 24,970 36,000 36,000 26,275 25,006 42,000 42,000 - 308 - - 1,962 1,424 942 1,038 2,861 2,912 9,600 9,600 16,058 12,726 31,800 31,800 247 198 - - 954 175 - - 22,080 17,587 - - 1,163 917 2,400 2,400 1,183 646 2,100 2,100 2,816,301 2,820,447 2,800,000 2,900,000 - 900 2,400 2,400 35,196 30,185 25,488 606,763 5,243,943 5,373,837 4,167,753 4,759,972 2018 NATURAL GAS Detailed Income Statement Gas Division 2014 Actual I 2015 Actual I 2016 Actual 11 2016 Budget I 2017 Budget I 2018 Budget OPERATING REVENUES Energy Sales Revenue Sales - Natural Gas --Retail Contract Sales to Large Customers (Includes 3M & HTI transport) New Ulm 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 Total Purchased Gas Transmission Gas Transmission Operations (856) Gas Transmission Maintenance (863) Total Transmission (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 Supervison (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) $ 8,559,893 $ 6,812,881 $ 7,080,905 $ 8,612,023 $ 8,315,151 $ 7,646,416 $ 6,066,290 $ 3,110,620 $ 2,798,172 ,;', $ 3,578,643 $ 3,242,440 $ 2,792,000 $ 808,575 $ 776,164 $ 831,969 $ 730,636 $ 734,878 $ 739,440 $ 700,000 $ 641,833 $ 647,166 $ 647,166 $ 651,700 $ 656,366 $ 16,134,757 $ 11,341,498 $ 11,358,212 $ 13,568,468 $ 12,944,169 $ 11,834,222 $ 16,134,757 $ 11,341,498 $ 11,358,212 $ $ $ 71,400 $ $ $ 13,568,468 $ $ 12,944,169 $ 71,400 11,905,622 $ 5,385,632 $ 3,545,049 $ 3,730,312 $ 4,161,898 $ 4,102,910 $ 3,300,000 $ 5,074,637 $ 2,443,772 $ 1,967,555 $ 3,052,857 $ 2,679,314 $ 2,300,000 $ 10,460,268 $ 5,988,821 $ 5,697,867 $ 7,214,755 $ 6,782,224 $ 5,600,000 $ 106,984 $ 115,115 $ 114,734 $ 163,760 $ 165,464 $ 175,765 $ 23,535 $ 4,337 $ 4,720 ,;', $ 10,171 $ 10,241 $ 11,742 $ 130,520 $ 119,452 $ 119,454 $ 173,931 $ 175,705 $ 187,507 $ 145,915 $ 166,328 $ 164,821 $ 358,088 $ 356,441 $ 440,517 $ 104,425 $ 87,715 $ 127,199 ,:', $ 109,692 $ 112,864 $ 192,670 $ 2,921 $ 9,497 $ 966 $ 835 $ 871 $ 872 $ 184,837 $ 159,849 $ 156,974 $ 131,631 $ 137,054 $ 148,821 $ 438,098 $ 423,389 $ 449,960 $ 600,246 $ 607,230 $ 782,880 $ 99,918 $ 156,591 $ 101,887 $ 148,837 $ 159,657 $ 179,698 $ 22,554 $ 9,322 $ 641 $ 24,228 $ 25,251 $ 25,266 $ 53,973 $ 49,641 $ 28,015 $ 188,250 $ 195,159 $ 201,759 $ 176,445 $ 215,554 $ 130,543 $ 361,315 $ 380,067 $ 406,723 $ 14,034 $ 19,029 $ 21,319 $ 17,453 $ 8,477 $ 19,062 $ 94,356 $ 124,394 $ 131,344 ,;', $ 152,259 $ 171,546 $ 125,766 $ 8,898 $ 3,811 $ 15,246 „' $ 6,750 $ 4,500 $ 4,500 $ 38,689 $ 40,514 $ 33,876 $ 45,558 $ 47,519 $ 48,861 $ 155,976 $ 187,748 $ 201,785 $ 222,020 $ 232,042 $ 198,189 $ 1,670 $ - $ - $ - $ - $ - $ 113,212 $ 73,656 $ 98,222 $ 179,806 $ 183,710 $ 163,189 $ 114,882 $ 73,656 $ 98,222 $ 179,806 $ 183,710 $ 163,189 $ 155,708 $ 155,341 $ 144,361 $ 139,183 $ 146,353 $ 150,184 $ 84,728 $ 82,789 $ 91,656 ,;' $ 74,250 $ 107,554 $ 90,800 $ 36,589 $ 35,353 $ 38,953 ,:', $ 26,769 $ 36,769 $ 26,769 $ 75,057 $ 72,711 $ 63,349 $ 70,000 $ 58,800 $ 59,000 $ 422,137 $ 451,860 $ 499,026 $ 63,045 $ 66,653 $ 61,750 $ 19,886 $ 19,082 $ 14,796 ,;', $ 20,000 $ 20,000 $ 20,000 $ 71,584 $ 55,594 $ 55,813 „' $ 79,758 $ 68,558 $ 68,558 $ 52,160 $ 38,052 $ 29,934 $ 31,233 $ 31,228 $ 31,292 $ 917,849 $ 910,782 $ 937,888 $ 504,237 $ 535,915 $ 508,353 Other Expenses Depreciation Expense (403) Payment in Lieu of Taxes (408) Total Other Expenses (403, 408) TOTAL OPERATING EXPENSES OPERATING INCOME (LOSS) NONOPERATING REVENUES/(EXPENSES) Merchandise & Contract Work, Net Interest Income Misc. Income Bond Premium Interest Expense - Bonds Interest Expense - Customer Deposits Gain (Loss) On Disposal Amortization of Bond Discount and Issuance Costs Amortization --Development Study 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 & FCA) Detailed Income Statement Gas Division 2014 Actua l I 2015 Actual I 2016 Actua l 2016 Budget 1 2017 Budget 1 2018 Budget $ 1,002,804 $ 1,008,133 $ 1,001,952 $ 1,056,000 $ 1,008,000 $ 1,008,000 $ 605,176 $ 206,980 $ 406,252 ,:', $ 406,252 $ 367,131 $ 369,142 $ 1,607,980 $ 1,215,113 $ 1,408,204 $ 14,002,017 $ 9,134,516 $ 9,043,923 $ 2,132,740 $ 2,206,982 $ 2,314,289 $ 31,269 $ 56,008 $ 29,206 $ 14,860 $ 15,978 $ 4,186 $ 5,235 28,316 $ 271,227 $ 185,608 $ 185,608 $ 185,608 $ (864,000) $ (821,833) $ (777,633) $ (434) $ (96) $ (2,661) $ 22,100 $ - $ 20,379 $ (605,361) $ (536,020) $ (269,688)'''' $ 1,527,378 $ 1,670,962 $ 2,044,601 $ 1,462,252 $ 1,375,131 $ 1,377,142 $ 10,718,563 $ 10,272,024 $ 9,223,983 $ 2,849,906 $ 2,672,145 $ 2,681,639 $ 27,000 $ 33,000 $ (23,500) $ 57,500 $ 50,000 $ 50,000 2018 Cap Exp $ (498,080) $ 185,608 $ 185,608 $ 185,608 $ (781,500) $ (735,100) $ (674,100) $ (200.00) $ (100) $ (100) $ (511,592) $ (466,592) $ (462,092) $ 2,338,314 $ 2,205,553 $ 2,219,547 $ 10,590,788 $ 6,108,273 $ 5,817,321 $ 7,388,686 $ 6,957,929 $ 5,787,507 $ 5,543,970 $ 5,233,225 $ 5,540,891 $ 6,179,782 $ 5,986,240 $ 6,118,115 34% 46% 49% 46% 46% 51% 13% 19% 20% 21% 21% 23% 9% 15% 18% 17% 17% 19% - - - 14% 17% 20% NET INCOME 2018 Net Income $ 2,219,547 Cap. Labor- Natural Gas $ 102,700 2018 Net Income $ 2,322,247 CASH FLOW STATEMENT 2018 Net Income $ 2,219,547 Depreciation $ 1,008,000 2018 Cap Exp $ (498,080) 2012A Principal $ (1,295,000) 2018 SIDE Proceeds $ 5,000 2018 Gas Cash Flow $ 1,439,467 2018 Cap Exp (As necessary) ', 1y747 a � 'k'l I IT � i i j J T, � PE ili 1�v i ) 14 �'i I L 51 IL :1-0 � I ■ Hutchinson Utilities Commission Capital Improvement Plan 2018 thra 2022 PROJECTS BY DEPARTMENT Department Project # Priority 2018 2019 2020 2021 2022 Total Natural Gas - Distribution Ford Dump Truck 037 1 46,371 46,371 Chevrolet Silverado w/Utility Body 130 1 67,238 67,238 Ford F550 Welding Truck 357 2 84,686 84,686 Misc Developments & System Improvements 376G-18-1 6 125,000 125,000 Misc Developments & System Improvements 376G-19-1 6 75,000 75,000 Misc Developments & System Improvements 376G-20-1 6 75,000 75,000 Misc Developments & System Improvements 376G-21-1 6 75,000 75,000 Misc Developments & System Improvements 376G-22-1 6 50,000 50,000 Regulator Station Improvements 378G-18-1 2 15,000 15,000 Regulator Station Improvements 378G-19-1 2 15,000 15,000 Regulator Station Improvements 378G-20-1 2 15,000 15,000 Regulator Station Improvements 378G-21-1 2 15,000 15,000 Service Lines 380G-18-1 2 55,000 55,000 Service Lines 380G-19-1 2 55,000 55,000 Service Lines 380G-20-1 2 55,000 55,000 Service Lines 380G-21-1 2 55,000 55,000 Service Lines 380G-22-1 2 55,000 55,000 Meters, AMI & All Fittings 381G-18-1 2 90,000 90,000 Meters, AMI & All Fittings 381G-19-1 2 90,000 90,000 Meters, AMI & All Fittings 381G-20-1 2 90,000 90,000 Meters, AMI & All Fittings 381G-21-1 2 90,000 90,000 Meters, AMI & All Fittings 381G-22-1 2 90,000 90,000 Industrial Metering & Regulation 385G-18-1 2 80,000 80,000 Industrial Metering & Regulation 385G-19-1 2 30,000 30,000 Industrial Metering & Regulation 385G-20-1 2 30,000 30,000 Chevrolet Metering Service Truck 433E 3 37,080 37,080 Ford F350 Super Duty Pickup 623 1 66,837 66,837 Ford F-150 X -cab 651 1 38,192 38,192 Chevrolet 4 Door X -cab 948 1 41,734 41,734 Natural Gas - Distribution Total 402,080 370,029 349,686 235,000 350,343 1,707,138 Natural Gas - Transmission ROW Easements - Transmission Lateral to HCP 365G-18-1 6 500,000 500,000 ROW Easements (Damages) Tran Lateral to HCP 365G-19-1 3 300,000 300,000 Transmission Lateral - Materials, Eng, Permitting 367G-18-1 6 1,000,000 1,000,000 Transmission Lateral to HCP 367G-19-1 1 8,000,000 8,000,000 Metering Upgrade - Lafayetter Interconnect 369G-18-1 1 90,000 90,000 Interconnect Station, Pig, Launching Station 369G-19-1 6 1,000,000 1,000,000 Locator 370G-18-1 3 6,000 6,000 SCADA Equipment - HCP Interconnect Station 370G-19-1 1 25,000 25,000 Natural Gas - Transmission Total 1,596,000 9,325,000 10,921,000 GRAND TOTAL 1,998,080 9,695,029 349,686 235,000 350,343 12,628,138 Produced Using the Plan -It Capital Planning Software Page 1 Friday, December 08, 2017 Hutchinson Utilities Commission Capital Improvement Plan 2018 thra 2022 PROJECTS BY FUNDING SOURCE Source Project # Priority 2018 2019 2020 2021 2022 Total Capital Replacement Reserves ROW Easements - Transmission Lateral to HCP 365G-18-1 6 500,000 500,000 ROW Easements (Damages) Tran Lateral to HCP 365G-19-1 3 300,000 300,000 Transmission Lateral - Materials, Eng, Permitting 367G-18-1 6 1,000,000 1,000,000 Transmission Lateral to HCP 367G-19-1 1 8,000,000 8,000,000 Metering Upgrade - Lafayetter Interconnect 369G-18-1 1 90,000 90,000 Interconnect Station, Pig, Launching Station 369G-19-1 6 1,000,000 1,000,000 Locator 370G-18-1 3 6,000 6,000 SCADA Equipment - HCP Interconnect Station 370G-19-1 1 25,000 25,000 Misc Developments & System Improvements 376G-18-1 6 125,000 125,000 Misc Developments & System Improvements 376G-19-1 6 75,000 75,000 Misc Developments & System Improvements 376G-20-1 6 75,000 75,000 Misc Developments & System Improvements 376G-21-1 6 75,000 75,000 Misc Developments & System Improvements 376G-22-1 6 50,000 50,000 Regulator Station Improvements 378G-18-1 2 15,000 15,000 Regulator Station Improvements 378G-19-1 2 15,000 15,000 Regulator Station Improvements 378G-20-1 2 15,000 15,000 Regulator Station Improvements 378G-21-1 2 15,000 15,000 Service Lines 380G-18-1 2 55,000 55,000 Service Lines 380G-19-1 2 55,000 55,000 Service Lines 380G-20-1 2 55,000 55,000 Service Lines 380G-21-1 2 55,000 55,000 Service Lines 380G-22-1 2 55,000 55,000 Meters, AMI & All Fittings 381G-18-1 2 90,000 90,000 Meters, AMI & All Fittings 381G-19-1 2 90,000 90,000 Meters, AMI & All Fittings 381G-20-1 2 90,000 90,000 Meters, AMI & All Fittings 381G-21-1 2 90,000 90,000 Meters, AMI & All Fittings 381G-22-1 2 90,000 90,000 Industrial Metering & Regulation 385G-18-1 2 80,000 80,000 Industrial Metering & Regulation 385G-19-1 2 30,000 30,000 Industrial Metering & Regulation 385G-20-1 2 30,000 30,000 Capital Replacement Reserves Total 1,961,000 9,590,000 265,000 235,000 195,000 12,246,000 Fleet Designated Reserves Ford Dump Truck 037 1 46,371 46,371 Chevrolet Silverado w/Utility Body 130 1 67,238 67,238 Ford F550 Welding Truck 357 2 84,686 84,686 Chevrolet Metering Service Truck 433E 3 37,080 37,080 Ford F350 Super Duty Pickup 623 1 66,837 66,837 Ford F-150 X -cab 651 1 38,192 38,192 Chevrolet 4 Door X -cab 948 1 41,734 41,734 Fleet Designated Reserves Total 37,080 105,029 84,686 155,343 382,138 Produced Using the Plan -It Capital Planning Software Page 1 Friday, December 08, 2017 Source Project # Priority GRAND TOTAL 2018 2019 2020 1,998,080 9,695,029 349,686 2021 2022 235,000 350,343 Total 12,628,138 Produced Using the Plan -It Capital Planning Software Page 2 Friday, December• 08, 2017 2018 Budget Natural Gas Davaszon0 0 0 Detail GL NUMBER DESCRIPTION 2015 ACTUALS 2016 ACTUALS 2017 APPROVED BUDGET 2018 REQUESTED BUDGET REVENUES 2-00-400-450-0100 Collection Fee 2-00-400-450-0200 Reconnection Fee - 2-00-400-450-0300 FEE FOR RETURNED CHECKS 1,400 2-00-400-450-0400 Late Payment Charge - - - 70,000 2-00-400-480-0000 Residential Sales (Gas) 3,731,066 3,839,034 4,474,618 3,812,700 2-00-400-481-0000 Commercial & Industrial Sales 2,748,161 2,824,329 3,388,924 3,388,924 2-00-400-481-0400 Large Industrial 301,208.00 417,542.00 451,609 444,792 2-00-400-481-0401 Large Industrial Contract 3,110,620.00 2,755,692.00 3,200,440 2,750,000 2-00-400-481-0500 Large Industrial - Demand 32,446.00 42,480.00 42,000 42,000 2-00-400-481-0600 Large Interruptible - - - - 2-00-400-489-0000 New Ulm Transportation 776,164.00 831,969.00 734,878 739,440 2-00-400-489-0100 Transportation - Electric Divi 641,833.00 647,166.00 651,700 656,366 2-00-415-105-0100 Natural Gas Services 25,291.00 17,929.00 - - 2-00-415-108-0000 Operating & Maint-Brownton 30,717.00 41,937.00 33,000 27,000 2-00-415-109-0000 Emergency Response-Brownton - 1,852.00 - - 2-00-419-000-0000 Interest And Dividend Income 15,978.00 48,579.00 50,000 50,000 2-00-419-000-0100 Interest Income-Bond Premium 185,608.00 185,608.00 185,608 185,608 2-00-419-000-0200 Investment FMV Adjustment - (44,393.00) - - 2-00-421-000-0000 Misc Income - 2-00-421-000-0101 Gain On Disposal - Gas 20,379.00 2-00-421-000-0201 Loss On Disposal - Gas - - 2-00-421-000-0600 Misc. Income - Gas 28,316.00 271,227.00 - - TOTAL REVENUE 11,627,408 11,901,330 13,212,777 12,168,230 GL NUMBER DESCRIPTION 2015 ACTUALS 2016 ACTUALS 2017 APPROVED BUDGET 2018 REQUESTED BUDGET 2-04-401-807-0100 Dept 00 - MISCELLANEOUS 3,545,049.00 3,730,312.00 4,102,910 2-00-401-916-0300 Other Programs - - - - 2-00-408-000-0000 Payment In Lieu Of Taxes To City 206,980 406,252 367,131 369,142 2-00-416-103-0000 Trucks - - - - 2-00-416-104-0000 Trucks - Labor 147.00 88.00 26,607.00 - 2-00-428-000-0100 Amortization Of Debt Disc Gas - - 9,990.00 8,000 2-00-428-000-0300 Prior Period Adjustment-NGas - - - - Totals for dept 00 -ELECTRIC MISCELLANEOUS 207,127 406,340 367,131 369,142 Dept 04 -GAS DISTRIBUTION 2-04-401-807-0000 Gas Purchased Power - - 2-04-401-807-0100 Gas For Retail 3,545,049.00 3,730,312.00 4,102,910 3,300,000 2-04-401-807-0101 Contract Gas For Retail 2,443,772.00 1,967,555.00 2,679,314 2,300,000 2-04-401-870-0000 ASSETS - - - - 2-04-401-870-0100 Supervision 111,137.00 112,867.00 125,383 169,017 2-04-401-870-0200 Training - Labor 28,045.00 26,607.00 - - 2-04-401-870-0300 Training - Expense 9,726.00 9,990.00 8,000 10,000 2-04-401-870-0400 Meetings & Travel - Labor (Sta 5,179.00 4,434.00 - - 2-04-401-870-0500 Meetings & Travel - Expense (S 12,241.00 10,923.00 12,500 12,500 2-04-401-870-0600 GAS DISTRIBUTION BENEFITS - - 210,558 249,000 2-04-401-874-0100 Labor (Mains And Services) 36,026.00 64,410.00 78,364 124,270 2-04-401-874-0200 Labor (M & R General Services) 1,754.00 333.00 - - 2-04-401-874-0300 Labor (M & R Industrial Servic 2,324.00 1,392.00 2-04-401-874-0400 Labor (M & R Station - City Ga 14,899.00 14,175.00 - - 2-04-401-874-0500 Materials 13,912.00 19,740.00 17,500 35,000 2-04-401-874-0600 Public Awareness - Labor 4,548.00 3,779.00 - 8,400 2-04-401-874-0700 Public Awareness - Material 14,251.00 23,370.00 17,000 25,000 2-04-401-878-0100 Reinstalling Or Changing Of Me 9,497.00 966.00 871 872 2-04-401-880-0100 Vacation 49,637.00 48,962.00 - - 2-04-401-880-0200 Other Labor - 1,306.00 - - 2-04-401-880-0300 Odorant - 7,958.00 25,000 25,000 2-04-401-880-0400 Vehicle/Equipment Fuel 13,928.00 11,902.00 13,000 18,500 2-04-401-880-0500 Misc Expense 197.00 34.00 500 1,500 2-04-401-880-0600 Testing Meters - Outside Servi 551.00 1,500.00 - - 2-04-401-880-0700 Sick Leave 25,542.00 18,179.00 2,112 3,571 2-04-401-880-0800 Holiday Pay 26,894.00 26,946.00 - - 2-04-401-880-1200 Call Time 23,077.00 22,578.00 - - 2-04-401-880-1300 Building Maintenance - Labor 10,344.00 10,219.00 87,942 88,000 2-04-401-880-1500 Uniforms & Laundry 9,680.00 7,209.00 8,500 12,000 2-04-401-880-1600 Contract Locating - - - - 2-04-401-880-1700 Drug And Alcohol Testing - Lab 2-04-401-880-1800 Engineering - Labor 2-04-401-880-1900 Cad - Labor - - 2-04-401-880-2100 Union Representative Meetings 181.00 250 2-04-401-880-2200 Drug And Alcohol Testing - Out - - 2-04-402-892-0000 Gas Distribution Maintenance - - - - 2-04-402-892-0100 Labor Mains 91,782.00 27,115.00 69,657 69,698 2-04-402-892-0200 Labor (M & R General Service) 30,488.00 53,101.00 - - 2-04-402-892-0300 Labor (M & R Industrial Servic 4,603.00 1,904.00 2-04-402-892-0400 Labor (M & R Station - City Ga 8,480.00 2,569.00 - - 2-04-402-892-0500 Materials 21,239.00 17,198.00 80,000 100,000 GL NUMBER DESCRIPTION 2-04-402-892-0600 Outside Service - Painting 2-04-402-893-0100 Meter- Labor 2-04-402-895-0101 Vehicles - Labor 2-04-402-895-0102 Vehicles - Material 2-04-402-895-0201 Power Equipment - Labor 2-04-402-895-0202 Power Equipment - Materials 2-04-402-895-0300 Obsolete Material Charged Off 2-04-402-895-0401 Other Equipment - Labor 2-04-402-895-0402 Other Equipment - Materials 2-04-416-105-0100 Time & Material - Installation 2-04-416-107-0100 Third Party Damage - Material 2-04-416-108-0000 Operating & Maint-Brownton 2-04-416-109-0000 Emergency Response-Brownton Totals for dept 04 -GAS DISTRIBUTION 2017 2018 2015 2016 APPROVED REQUESTED ACTUALS ACTUALS BUDGET BUDGET - - 10,000 10,000 9,322.00 641.00 25,251 25,266 15,371.00 6,097.00 170,659 170,759 15,403.00 11, 794.00 10,000 15,000 9,686.00 5,979.00 - - 368.00 1,070.00 5,000 5,000 1,540.00 (747.00) 1,000 11000 3,747.00 1,743.00 - - 3,526.00 2,079.00 8,500 10,000 5,040.00 22,482.00 - 31,000 143.00 763.00 2-05-401-856-0800 7,000 7,134.00 9,179.00 - 10,500 - - 15,038.00 2,000 6,640,082 6,310,794 7,769,521 6,840,103 Dept 05 -GAS TRANSMISSION 2-05-401-856-0000 Gas Transmission Operations 15,066.00 18,433.00 - - 2-05-401-856-0100 Line - Labor 50,912.00 50,882.00 69,724 69,765 2-05-401-856-0200 Line - Outside Services 24,284.00 28,931.00 26,000 26,000 2-05-401-856-0400 M & R Station - City Gate - La 264.00 892.00 - - 2-05-401-856-0500 Materials 10,819.00 10,383.00 6,500 10,000 2-05-401-856-0600 Utilities (Electric, Satellite) 6,774.00 8,238.00 7,500 7,500 2-05-401-856-0700 Railroad Licenses 5,691.00 4,163.00 5,000 7,500 2-05-401-856-0800 Public Awareness - Labor 1,334.00 3,782.00 - - 2-05-401-856-0900 Public Awareness - Material 15,038.00 7,463.00 17,000 19,000 2-05-401-856-1000 GAS TRANSMISSION BENEFITS - - 33,740 36,000 2-05-402-863-0000 Gas Transmission Maintenance - - - - 2-05-402-863-0100 Line - Labor 3,996.00 3,590.00 1,741 1,742 2-05-402-863-0200 Line - Outside Services - - 7,500 7,500 2-05-402-863-0400 M & R Station - City Gate - La - 312.00 - - 2-05-402-863-0500 Materials 341.00 818.00 1,000 2,500 Totals for dept 05 -GAS TRANSMISSION 119,453 119,454 175,705 187,507 Dept 06 -CUSTOMER SERVICE 2-06-401-902-0100 Meter Reading - Labor 15,066.00 18,433.00 8,477 19,062 2-06-401-902-0200 Meter Reading - Materials 3,963.00 2,886.00 - - 2-06-401-903-0000 Collection Expense - - - - 2-06-401-903-0100 Collection - Labor 9,536.00 9,688.00 3,532 13,615 2-06-401-903-0200 Collection - Materials 75,606.00 79,232.00 105,613 48,000 2-06-401-903-0300 Vacation 7,038.00 5,041.00 - - 2-06-401-903-0400 Supervisor 23,829.00 25,522.00 33,942 34,901 2-06-401-903-0500 Sick Leave 3,236.00 7,252.00 445 - 2-06-401-903-0600 Holiday Pay 4,797.00 4,609.00 - 2-06-401-903-1101 Meetings & Travel - Labor (Sta - - 2-06-401-903-1102 Meetings & Travel - Expense (S 280.00 2-06-401-903-1201 Training - Labor 73.00 - - 2-06-401-903-1202 Training - Expense - 2,250 2,250 2-06-401-903-1300 COLLECTION BENEFITS - - 25,764 27,000 2-06-401-904-0000 Bad Debt Write Offs 3,811.00 15,246.00 4,500 4,500 2-06-401-906-0100 Customer Service - Labor 40,514.00 33,876.00 47,519 48,861 Totals for dept 06 -CUSTOMER SERVICE 187,749 201,785 232,042 198,189 GL NUMBER DESCRIPTION 2015 ACTUALS 2016 ACTUALS 2017 APPROVED BUDGET 2018 REQUESTED BUDGET 2-08-401-920-0000 Dept 07 -CONSERVATION IMPROVEMENT - - 2-07-401-911-0000 Supervision (Conservation Impr 2-08-401-920-0100 Supervision Salaries - - 2-07-401-916-0100 Labor Imp 16,589.00 17,747.00 43,201 22,464 2-07-401-916-0200 Tree Planting 7,500.00 7,500.00 - 7,500 2-07-401-916-0301 Cip- Residential 18,552.00 23,306.00 67,463 62,986 2-07-401-916-0302 Cip- Commercial 13,975.00 27,824.00 55,123 49,833 2-07-401-916-0303 Cip-Industrial 9,970.00 13,906.00 1,923 4,406 2-07-401-916-0304 Cip- Marketing 1,122.00 605.00 5,000 5,000 2-07-401-916-0305 Doc - Cip Assessment 5,948.00 7,334.00 6,000 6,000 2-07-401-916-0400 Cip - Transfer To Assets - - 5,000 5,000 Totals for dept 07 -CONSERVATION IMPROVEMENT 73,656 98,222 183,710 163,189 Dept 08 -GENERAL & ADMINISTRATION 2-08-431-000-0100 Interest - Customers Deposits 96.00 2,661.00 100 100 2-08-401-920-0000 General & Administrative - - - - 2-08-401-920-0100 Supervision Salaries 28,924.00 29,046.00 35,564 35,470 2-08-401-920-0200 General Salaries Labor 99,452.00 90,871.00 110,451 113,630 2-08-401-920-0300 Vacation 13,341.00 15,300.00 - - 2-08-401-920-0500 Sick Leave 3,785.00 2,524.00 338 1,084 2-08-401-920-0600 Holiday Pay 6,428.00 6,620.00 - - 2-08-401-920-0700 Engineering - Labor - - 2-08-401-920-0800 Cad - Labor 2-08-401-920-0900 Drug And Alcohol Testing - Lab - - - - 2-08-401-921-0100 Telephone 10,973.00 11,297.00 10,750 10,750 2-08-401-921-0200 Office Supplies 4,692.00 4,614.00 6,250 6,250 2-08-401-921-0300 Lease/Service Agreements 7,816.00 8,148.00 8,250 8,250 2-08-401-921-0400 Postage 611.00 992.00 1,500 1,500 2-08-401-921-0500 Mail Services - Ups, Fedex 535.00 534.00 800 800 2-08-401-921-0600 It Admin And Support 57,736.00 64,647.00 78,754 62,000 2-08-401-921-0700 Advertising/Printing 428.00 1,424.00 1,250 1,250 2-08-401-923-0000 Outside Services - - - - 2-08-401-923-0200 Legal Services 11,519.00 11,662.00 10,500 10,500 2-08-401-923-0300 Engineering Services - - 10,000 - 2-08-401-923-0400 Misc Services 5,888.00 17,105.00 6,000 6,000 2-08-401-923-0500 Human Resources Services 16,072.00 8,269.00 8,269 8,269 2-08-401-923-0600 Drug Testing Services 1,875.00 1,917.00 2,000 2,000 2-08-401-924-0100 Property Insurance 22,732.00 22,177.00 20,000 21,000 2-08-401-924-0200 Boiler Insurance 29,273.00 29,250.00 26,800 26,000 2-08-401-924-0300 General Liability 20,706.00 11,922.00 12,000 12,000 2-08-401-924-0400 Excess Liability Insurance (No - - - - 2-08-401-926-0101 Health Insurance 239,950.00 217,807.00 62,903 58,000 2-08-401-926-0200 Fica Taxes 76,523.00 75,616.00 - - 2-08-401-926-0300 Pera 94,839.00 166,886.00 2-08-401-926-0400 Uniforms 59.00 437.00 - - 2-08-401-926-0500 Brea kroom/Recognition Banquet 3,607.00 2,398.00 3,750 3,750 2-08-401-926-0700 Unemployment Compensation Obso 30.00 - - - 2-08-401-926-0800 Life/Ltd/Ad&D Insurance 6,414.00 6,286.00 2-08-401-926-0900 Worker'S Compensation 19,966.00 18,993.00 2-08-401-926-1000 Dental Insurance 10,472.00 10,347.00 2-08-401-926-1100 Pandemic Flu Supplies - - - - 2-08-401-928-0000 Regulatory Expenses 19,082.00 14,796.00 20,000 20,000 GL NUMBER DESCRIPTION 2-08-401-930-0100 Commissioners Labor 2-08-401-930-0201 Meetings & Travel - Labor (Sta 2-08-401-930-0202 Meetings & Travel - Expense (S 2-08-401-930-0301 Training - Labor 2-08-401-930-0302 Training - Expense 2-08-401-930-0400 Dues/Membership Expense 2-08-401-930-0500 Utility Expenses - Water/Waste 2-08-401-930-0800 Misc Expense 2-08-401-935-0101 Grounds - Labor 2-08-401-935-0102 Grounds - Materials 2-08-401-935-0103 Grounds - Outside Services 2-08-401-935-0200 Misc Expenses 2-08-401-935-0201 Misc Other- Labor 2-08-401-935-0202 Misc Other- Materials 2-08-401-935-0203 Vehicles/Equipment Fuel 2-08-401-935-0301 Vehicles - Labor 2-08-401-935-0302 Vehicles - Material 2-08-403-000-0200 Gas Depreciation 2-08-427-000-0000 Interest Expense 2-08-427-000-0600 Interest - 2003 Bonds Gas Totals for dept 08 -GENERAL & ADMINISTRATION 2017 2018 2015 2016 APPROVED REQUESTED ACTUALS ACTUALS BUDGET BUDGET 11,877.00 12,496.00 10,558 10,558 54.00 81.00 2,980.00 2,102.00 6,000 6,000 19,184.00 20,430.00 24,000 24,000 21,498.00 20,459.00 28,000 28,000 - 245.00 - - 1,605.00 1,165.00 628 692 2,341.00 2,383.00 6,400 6,400 13,139.00 10,412.00 21,200 21,200 202.00 162.00 - - 780.00 143.00 18,065.00 14,390.00 - - 951.00 750.00 1,600 1,600 968.00 529.00 1,400 1,400 1,008,133.00 1,002, 208.00 1,008,000 1,008,000 821,833.00 777,633.00 - - - - 735,100 674,100 2,737,434 2,720,134 2,279,115 2,190,553 HUTCHINSON UTILITIES COMMISSION�� Board Action Form �'Ylkll'M1'k� Agenda Item: Consideration of 2018 Non -Union Pay Grid & Performance Increase / Merit Guide Presenter: Jeremy Carter Agenda Item Type: Time Requested (Minutes): 5 New Business Attachments: Yes BACKGROUND/EXPLANATION OF AGENDA ITEM: Per the objectives of the HUC Compensation Plan for non-union employees as established as part of the HUC Exempt Employee Handbook, 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 to accomplish these objectives. Attached is the recommended non-union pay grid for 2018 that incorporates a 2% market increase to the grid. It is noted that the adjustment is to the grid only and does not result in pay increases for non-union employees as, per the plan, employee pay increases are determined by performance. It was noted in 2016 that HUC would work to develop a performance/merit pay guide where increases get smaller as actual pay gets closer to the competitive market rate. Beyond market, only outstanding performance is rewarded with meaningful salary increases above the overall market movement. As this has not yet been developed, it is recommended to continue to utilize the existing merit increase guide (attached) for increases awarded in early 2018. The base union increase is designated as 4% for 2018. It is recommended that performance increases be added to the employee's base wage up to the 2018 maximum rate, and any additional amount be paid On a lump sum BOARD ACTION REQUESTED: Approve the proposed 2018 non-union pay grid and the 2018 merit guide with the lump sum payment component for non-union performance increases . Fiscal Impact: Included in current budget: Yes Budget Change: PROJECT SECTION: Total Project Cost: Remaining Cost: O O Ln m N OJ + OJ co c O O � � Q C E aJ N C i aJ [0 N N (p Lfl Lfl l0 l0 I� ri IL ri ri ri ri ri N V N o m rl m lt lt io o m ri m N m N O o0 00 o rl m oo to c 2 � m to lq� m mlq� io N 0 to N ri ri m Il N O ri m oo to N N Rto r -I n m r -I m m I, m N't m n O m to m m n r -I m m't r -I m aJ U N N N m m m m m t l0 Ln Ln Ln Ln Ln to to N N N o0 00 C R m N I� ` m ` m Ln Ln I� m N to c -I c -I l0 to 00 I� c -I c -I I� R q 00 ri Ln m m I, N n N 00 t O n t ri m I, to to to l0 Ln Ln l0 l0 l0 I, n 00 00 m m O ri ri N m m t m l0 I, 00 00 l0 N I, ri Ln O l0 m m l0 m t N l0 00 00 00 O m r -I m d m m 00 m O Il to Ln l0 00 ri l0 N O m O m 00 l0 Ln Il ri 'a N t Ln I, m O N -Zt <D 00 ri m l0 m ri Ln 00 ri Ln m m 00 i N N N N N m m m m m q t N 00 Ln Ln Ln to to to N N 7 m m to m m N m m to m to O to 00 N m to N m to �t m O N O O m m 0 00 l0 m 0 l0 m I, 00 l0 O It O m 0 00 110 = -a l0 m 00 O m I, 't r -I r, l0 m m 1,0 N N I, m I, m 00 m m co Ln Il m m l0 ri Il lq� ri O O ri m Il N 00 l0 l0 00 ri Il lq� C c m o ri m O to l0 I, m ri m Ln I, m ri -q ,o m N Ln m N l0 N 'r2— ri N N N N N N N m m m m m ri ri ri ri Ln Ln Ln to to N (p Lfl Lfl l0 l0 I� ri IL ri ri ri ri ri N V N m O N m O m r -I I, m r -I l0 l0 m N O I, n r -I N It m N c 2 N ri ri N Ln N io O m N Ln m O N m N to m � mio O ri N � r -I I, O N n n n N to m l0 I, mq Ln N mo Ln ri Ln r -I r -I O aJ U N ri ri ri m m O 00 moo l0 Ln Ln ri 't n N N m l0 I, t ri C R m N I� ` m ` m Ln Ln I� m N to c -I c -I l0 to 00 I� c -I c -I I� R q 00 ri Ln m m I, N n N 00 t O n t ri m I, to to to l0 Ln Ln l0 l0 l0 I, n 00 00 m m O ri ri N m m t m l0 I, 00 m 00 N m m l0 00 r -I I, m r -I r -I r -I r -I r -I r -I r -I r -I r -I r -I ri d Ln 00 m 00 lq� ri m 00 m O m I, m O m O N l0 m ri N l0 'a N m Ln l0 00 O ri m Ln 00 O N Ln 00 O qt n O qt 00 N 1,0 c O q to O O l0 00 00 O 00 q t N 00 ri m Ln m 00 N Ln l0 7 m m to m m N m m to m to O to 00 N m to N m to �t m O N O O m m 0 00 l0 m 0 l0 m I, 00 l0 O It O m 0 00 110 = -a O I, r -I m ri I, O n 00 l0 O It 00 m I, to m N m m O O ti oo to N m m m o0 0o ri N to N ri m O Ln ` N n to m Ln R C I, ,t O Ln m Ln to Ln O to m to n to r -I n l0 n O 00 m 00 O m l0 m r -I O 00 O It ri r -I N 00 N l0 m 00 m Ln N l0 � 'r2— ri N N N N N N N m m m m m-zt ri ri ri ri ri ri ri ri ri co N ri o0 o 0o ri N -q o N Ln ri N o ri N N -q to m m oo m oo r,� N oo ri r,� In m N r� r� ri oo Ln m r� to Ln Ln oo N I, N m ri m ri N m ri N N l0 00 ri m m 00 00 m N m Ln m 00 N ri Ln l0 -q o n �t m Ln N l0 I, n m -q -q N 00 I, o to ri N -zt m �t N ri oo N oo N oo N m -zt m Ln ri o -zt m o m Ln oo ri zF f-: ri Z oo rl f ri to ri f-: m C to m o 00 m ��-Zt Ln Ln Ln to to to N N o0 0o m m o o ri N m m ri ri ri ri ri ri aJ R ri N m t Ln to n oo m O ri ri ri N ri m't ri ri Ln ri to ri N ri oo ri m ri 0 N ri N N N C7 N (p Lfl Lfl l0 l0 I� ri IL ri ri ri ri ri N V N m-Zt m m m 00 A N N l0 lzt to 00 m N mzt N l0 ri m N N 0 c 2 00 Ln O 00 l0 l0 Il m N Il In ri O N Ln O Il n 00 m O O N � Ln I� m O N � l0 00 ri m l0 m N Ln 00 N Ln m m 00 m 00 aJ U U I, O m I, Ln 00 l 0 N l0 N r -I 't 't 't m 't ~ m m r -I 00 't C R 00 O Ln ri m O m m 00 mlzz N m 00 I� O n m l0 m l0 O R m I, O It I, N to O m O l0 N 00 It r -I m l0 It m N N m Ln Ln l0 l0 l0 I, n 00 00 m m O O ri N N m t m l0 I, 00 m 00 N m m l0 00 r -I I, m r, ri to ri O ri n r -I I, to O d Ln 00 m 00 lq� ri m 00 m O m I, m O m O N l0 m ri N l0 'a N m Ln l0 00 O ri m Ln 00 O N Ln 00 O qt n O qt 00 N 1,0 i N N N N N m m m m m 00 l0 m 00 Ln Ln Ln l0 l0 l0 I� n 7 O m Ln m m m m l0 l0 O I� Ln to N n Ln 00 l0 Il lq� Ln O m l0 I, to m m 00 I, m I, 00 m r -I m I, It m l0 00 It N O = -a 00 m Ln -zt ri l0 O m l0 O -q O 00 OLn Ln l0 Ln Zt m N O m ti ri m Ln 00 N l0 N 00 to lz� In 't to m m m I, l0 n O to ri R C m O ri N -zt Ln n 00 O N �t 1,0 00 O m Ln 00 ri -zt 00 ri Ln N 'r2— ri N N N N N N N m m m m m-zt �-zt ri -zt Ln Ln Ln D <D N (p Lfl Lfl l0 l0 I� ri IL ri ri ri ri ri N V N m m N mzt ri ri ri 00 ri O 00 O O m N Il, to m 00 Il, zt c 2 0o Ln ri ri m to O oo Ln oo O to Ln In ri lz� m O Ln O oo ri T zt m O O Il, to O N O m 00 m l0 Il, 00 N It N r -I m I, m aJ U U I, O m I, Ln 00 l 0 N l0 N r -I 't 't 't m 't ~ m m r -I 00 't + UU R 00 O Ln ri m O m m 00 mlzz N m 00 I� O n m l0 m l0 O m I, O It I, N to O m O l0 N 00 It r -I m l0 It m N N m Ln Ln l0 l0 l0 I, n 00 00 m m O O ri N N m t m l0 I, 00 ri ri ri ri ri ri ri ri ri ri ri d O O ri l0 00 -t O m m m 00 l0 m 00 l0 O 00 O O N O Ln O m Ln m m m m l0 l0 O I� Ln to N n Ln 00 l0 Il lq� Ln m l0 I, to m m 00 I, m I, 00 m r -I m I, It m l0 00 It N O -a to n Ln ri l0 ri I, to m I, N "0o Ln Ln ri Ln m l0 m O N oo to to 0o ri N ` ` to ri m m m m m m 0 ri N N ff�l m R l0 m N Ln Ln Ln m m N l0 l0 l0 O I, t n m n m 00 00 00 t m m m Ln O N r -I m r -I l0 N m m r -I O m m m ri ri ri ri ri ri ri ri ti CD N ri ri ri O m Il, m to O to to -Zt f\ f\ m 00 O m N l0 -Zt <D ri N m oo O N N lz� oo O ri oo to O In m N Ln to In m m Ln 00 -Zt m -Zt m Il, N O m 00 m l0 N l0 l0 N ri m l0 l0 ri 00 Il, ri O m Il, f\ f\ f\ 00 N ri m Il, f\ 00 N O -Zt f\ ri m 00 N 00 Ln m m Ln m Ln m � I� N O ri Ln m � 00 l0 m Ln m N ZF I- O m l0 m m I- ri Ln O Lr O Ln ri I- m O I- Ln m ��-Zt Ln Ln Ln m to to N N o0 0o m m O O ri N N m ri ri ri ri ri ri aJ R i ri N m Ln to n oo m O ri ri ri N ri m-Zt ri ri m ri to ri N ri oo ri m ri 0 N ri N N N C7 N (p Lfl Lfl l0 l0 I� ri IL ri ri ri ri ri N V N O 0A N C C Q c Q c 2 C O O N O N * E � UO v C aJ T N L C C aN-+ N ate+ � ate+ C C .� _ C N O o_ O � O N E O O o aJ U U a o Q Q Q v U Ln Q C OO C C ~ U C O U + UU o OJ OJ fo fo uc c v Uo a, 2 fo C C W 0_ LL Lu Z C7 N IL r- o0 00 0o m o V O N C Q c Q c O O O N C N * E > UO C aJ T L C C aN-+ N ate+ U ate+ YO ro C .� _ C ? O U O � O N E O O U-0 U C O a o Q Q Q Lu U HUC Non -Union Merit Increase Guide Results - The results of the exempt (non-union) employee's evaluation will normally have the following effect on his/her salary per the following Merit Increase Guide: Review Score % Increase 0 to 1.0 0% 1.1 to 1.99 Straight 1% increase 2.0 to 2.75 -1% of Union % increase 2.76 to 3.5 Union % increase 3.51 to 4.25 +1% of Union % increase 4.26 to 5.0 +2% of Union % increase 5 — Outstanding — Performance is exceptional in all areas and is recognizable as being far superior to others. 4 — Exceeds Job Requirements — Results clearly exceed most positions requirements. Performance is of high quality and is achieved on a consistent basis. 3 — Meets Job Requirements — Competent and dependable level of performance. Meets performance standards of the job. 2 — Needs Improvement — Performance is deficient in certain area(s). Improvement is necessary. 1 — Unsatisfactory — Results are generally unacceptable and require immediate improvement.