The URL can be used to link to this page

12-21-2016 HUCMMINUTES Regular Meeting — Hutchinson Utilities Commission Wednesday, December 21, 2016 Call to order — 3:00 p.m. President Luhring called the meeting to order. Members present: President Donna Luhring; Vice President Monty Morrow; Commissioner Anthony Hanson; Commissioner Robert Wendorff; Attorney Marc Sebora; General Manager Jeremy Carter. Absent: Secretary Mark Girard GM Carter and the Board presented President Luhring with a meter lamp to thank her for her three years of service on the Commission Board. 1. Conflict of Interest None 2. Approve Consent Agenda a. Approve Minutes b. Ratify Payment of Bills A motion was made by Commissioner Hanson, seconded by Commissioner Wendorff to approve the Consent Agenda. Motion was unanimously carried. 3. Approve Financial Statements Jared Martig presented the financial statements. The Board commended HUC staff on their efforts with their budgeting in 2016. After discussion, a motion was made by Vice President Morrow, seconded by Commissioner Wendorff to approve the financial statements. Motion was unanimously carried. 4. Open Forum 5. Communication a. City Administrator — Matthew Jaunich i. Not present. b. Divisions i. John Webster Nothing to report. ii. Dan Lang — 1. Nothing to report. iii. Jared Martig - 1. Nothing to report. iv. Randy Blake — 1. The new power plant operator starts next week. v. Dave Hunstad — 1. Nothing to report. vi. Brenda Ewing — 1. Nothing to report. c. Legal — Attorney Sebora i. Attorney Sebora extended a thank you to President Luhring for her service on the Board. d. General Manager — Jeremy Carter i. Clean Power Plan Update — GM Carter is monitoring the activity. The legislature is changing so the Plan is in a holding pattern for the next couple months. ii. GM Carter and Dave Hunstad were involved in discussions with Zefe Energy to receive first round funding through the Volkswagen settlement agreement to install electric charging stations in town. HUC has been in contact with the City of Hutchinson regarding potential sites and feasibility. 6. Policies a. Review Policies i. Purpose of this Handbook ii. Definitions iii. Inserts with Utility Bills No changes were recommended. b. Approve Changes i. Section 1 — Introduction ii. Payments of HUC Payables iii. Landlord Acknowledgement The recommended changes to Section 1 — Introduction; Payments of HUC Payables; and Landlord Acknowledgement were to clean up language and for clarification. A motion was made by Commissioner Hanson, seconded by Vice President Morrow to approve the changes to Section 1 — Introduction; Payments of HUC Payables; and Landlord Acknowledgement. Motion was unanimously carried. (Changes attached.) 7. Unfinished Business a. Update on Pack Gas Discussions A final settlement agreement was sent to the City of Fairfax, New Ulm and Heartland Corn for their Board's approval. 2 8. New Business a. Approve 2017 Budget GM Carter presented the final 2017 budget. After discussion, a motion was made by Commissioner Hanson, seconded by Commissioner Wendorff to approve the 2017 budget. Motion was unanimously carried. (2017 budget attached.) b. Approve Moving 2017 Pay Grid 3% and Using the 2016 Merit Guide for 2017 Non -Union Increases with the Lump Sum Component GM Carter presented the proposed 2016 non-union merit increase for increases in 2017 along with the 2017 3% increase pay grid. GM Carter explained HUC will be utilizing the current merit system while developing a structure for the 2017 system. A motion was made by Commissioner Wendorff, seconded by Commissioner Hanson to approve moving the 2017 pay grid 3% and using the 2016 merit guide for 2017 non-union increases with the lump sum component. Motion was unanimously carried. (2017 pay grid and 2016 merit guide attached.) c. Approve Letter of Agreement — Medical 2017 GM Carter presented the letter of agreement for 2017 to the IBEW Union contract. HUC is moving from Blue Cross Blue Shield (BCBS) to a small group plan with Health Partners for 2017 medical insurance. Because the current number of HUC employees subscribing to health insurance coverage is 50 or below, it allows the organization and its employees to take advantage of reduced premiums for 2017 under the Affordable Care Act, which will lead to significant savings for 2017. However, by switching to a small group plan the in -network, deductible and out -of -network deductible along with the out -of -network out-of- pocket maximum are higher than the negotiated benefits under the current 2016 plan. To avoid the reduction in benefit levels under the collective bargaining agreement while still achieving the premiums savings for 2017, GM Carter recommended the Commission approve the IBEW Letter of Agreement, whereby HUC will cover the increased benefit exposure above the current 2016 plan for 2017. A motion was made by Vice President Morrow, seconded by Commissioner Hanson to approve the Letter of Agreement — Medical 2017. Motion was unanimously carried. (Letter of Agreement attached.) d. Approve Organizational Chart GM Carter presented the updated HUC organizational chart. Since 2014, HUC management has worked diligently to identify and create the best organizational structure to streamline operations, control personnel costs, provide for efficient work flow and communication, while at the same time continuing to achieve a high level of service to Hutchinson Utilities' customers. 3 Significant changes to the organizational structure are as follows: i. Rescinding the Director of Electric Division and Customer/HR Manager positions. ii. Repositioning the Customer Service and Energy Conservation Administration functions underneath the Financial Manager. iii. Repositioning the Metering Crew and Metering Technician positions from the Manager of Engineering Services to the Manager of Electric Trans/Distribution. A motion was made by Vice President Morrow, seconded by Commissioner Wendorff to approve the organizational chart. Motion was unanimously carried. (Organizational charts attached.) e. Approve CIP Rebate Jared Martig presented the CIP rebate explaining Menards changed out all the lights in their store. Motion was made by Commissioner Hanson, seconded by Commissioner Wendorff. Motion was unanimously carried. (CIP Rebate attached.) President Luhring thanked HUC staff and the Commission for the opportunity to work together. Conduct the Performance Review of Hutchinson Utilities Commission General Manager Pursuant to Minnesota Statute 13D.05 Subd. 3(a) President Luhring introduced the agenda item, the General Manager's annual performance review. President Luhring advised GM Carter that he has the option to have the performance review conducted as either an open session or closed session of the Utility Commission. GM Carter indicated his decision to conduct the review as part of a closed session. President Luhring entertained a motion to go into closed session to conduct the General Manager's performance review. A motion was made by Commissioner Hanson, seconded by Vice President Morrow to go into closed session to conduct the General Manager's performance review. Motion was unanimously carried. The Commission then proceeded into a closed session at 3:32 p.m. 4 Hutchinson Utilities Commission Summary of Closed Meeting Proceedings General Manager Performance Appraisal Wednesday, December 21, 2016 On December 21, 2016, the Hutchinson Utilities Commission conducted a closed meeting for the annual performance appraisal for General Manager, Jeremy Carter. Individuals present included General Manager Jeremy Carter, Commission Members Donna Luhring, Anthony Hanson, Monty Morrow, and Bob Wendorff, City Attorney Marc Sebora, and City of Hutchinson Human Resources Director Brenda Ewing. Commissioner Mark Girard was absent. Mr. Carter exercised his right to close the proceedings to the public as permitted under Minnesota Statute 13D.05, Subdivision 3(a). Motion by Hanson, second by Morrow to go into closed session to conduct the General Manager's performance review. The motion passed unanimously. The Commission then proceeded into a closed session at 3:32 p.m. The Commission reviewed Mr. Carter's performance for the current calendar year. The review is required per the terms of the employment contract in place between the Hutchinson Utilities Commission and General Manager Carter. Mr. Carter's performance was evaluated in the following areas: Organizational Management, Fiscal/Business Management, Program Development, Relationship & Communication with the Commission, Long -Range Planning, and Relationships with Public & Outside Organizations. The consensus of the Commission is that Mr. Carter's cumulative performance for the review period was found to be 3.99 on the rating scale of 0 — 5, and, per the Hutchinson Utilities Commission, is meeting and exceeding job requirements on the ratings scale. The employment contract between Hutchinson Utilities and Mr. Carter indicates that salary increases for the General Manager are subject to the provisions of the Compensation Plan section of the Hutchinson Utilities Commission Exempt Employee Handbook. Motion by Hanson, second by Wendorff to approve a 2017 salary of $148,512, or a 4% annual increase of $5,712 over the 2016 salary. Motion carried unanimously. Motion by Morrow, second by Wendorff to close the closed session. The motion passed unanimously. The Commission proceeded into open session at 4:08 p.m. Motion to adjourn by Hanson, second by Wendorff . The motion carried unanimously, and the meeting adjourned at 4:09 p.m. i 1 7 A ATTEST: Monty M rrow, Vice President 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, 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 is 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 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 IIutchinson 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 L—it;��.-int-imp*wee- 4d+�.,•� gra} 3i x+Ei nl"Jectric and Natural Gas c) erationS ON ILItCllinSUi1 I Itilities. 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 3 our 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 HUI'CHIINSON UTILITIES COMMISSION WHAT Is HUTCHINSON UTILITIES COMMISSION? 'fhe :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 lip 430 kxv 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 Cas Company, and selling it to the citizens of I lutchinson and the surrounding rural area. '_Natural gas is 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 pipeline to serve this community. This transmission line is interconnected with Northern Border Pipeline near Trimont, Minnesota which allows Ilutchinson 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 I lutchinson, 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 Citv ,.;..lit ,,.lower Man, .. j4W. rNat ral (:.,.. r444ibtftk4fi S,.-steRlacctric and Natural (ills LiL1e_a1iuns ot_Flutchinson l!tilitics. 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. Amended j--..---)7 0 46December 21. 2016 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 24x62017. This policy shall be reviewed on an annual basis. Landlord Acknowledgement A signed Landlord Acknowledgement provides the following: • Confirmation and documentation of the landlord/owner. • Request of HUC to provide utility service to tenants. • The understanding that the tenant will be responsible for all utility costs between the date service is required by the tenant and the date the tenant requests read- out of services. • The landlord/owner agrees to be responsible for and to pay all utility charges from the read-out date given by the tenant until services are established with a new tenant. • The understanding that failure to pay these charges could result in disconnection of electric service. HUC is not responsible for any damages alleged to be caused by service disconnection. Disconnection/reconnection fees apply. • The landlord/owner has the option to sato contact HUC to assure confirm that the +emsant has put the utility service has been placed in the tenant's name. • The landlord /owner can request the disconnection of services as long as the account is in the landlord's/owner's name. Disconnection/reconnection fees apply. HUTCHINSON UTILITIES COMMISSION 2017 BUDGET 2012 BUDGET SUMMARY 2017 Operating Budget - Electric Division General 2017 Budget Items o Budget currently reflects a reduction in (2) Electric Division FTE's from the 2016 budget (Plant Operator & Metering Crew Chief). o Budget currently reflects — 13% Health Insurance Plan premium decrease based on an increased $3600/$7200 deductible program and HUC qualifying for the small group plan, which continues to include the HRA embedded within the insurance plan. In addition, the budget reflects an 80%/20% premium split for exempt and non-exempt employees. The Dental plan for 2017 will see a 0% increase, while the LTD and Basic Life & AD&D will see slight decreases from the 2016 rates. The Worker's Comp is estimated at a 5% increase over 2016 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 increase in the budgeted amount for 2017 to administer the Conservation Improvement Plan (CIP) to the current intentions of the State Program and State Statute language. (1.5% energy savings goal) 2016 Budget $540,657; 2017 Budget $540,911; budget amount will not necessarily all be expended in 2017. o Budget reflects a HUC transfer amount of $1,397,258. This is a decrease of $108,925 from 2016. Continues the 2.75% PILOT transfer formula amount while maintaining street light reimbursement, Tree Program, & reimbursement for IT, HR, Legal. Electric Operating Revenues o Retail Sales Forecast: o For 2017, retails sales are based off the rolling average of billable KWHR's from 2009 — October of 2016 which equates to 284,100,710 KWHRs (.16% decrease over 2016). The 2017 budget reflects the 2016 current electric rates for all classes except the large industrial. This rate reduction follows a 3 -year phase in schedule. (Year 3 of 3) o Power Cost Adjustment: o New in 2017, a Power Cost Adjustment (PCA) of $1,100,000 is factored into the 2017 budget. 2017 will be the eleventh consecutive year without a rate increase; last rate increase was in 2006. o KWHR Allocation used to determine KWHR retail sales by customer classes areas follows: o Electric Residential 17.8% o All Electric Residential .9% o Electric Small General Service 6.0% o Electric Large General Service 27.9% o Large Industrial 47.4% o Wholesale sales (Sales for Resale): o Capacity Sales with SMPPA for 2017 are budgeted at $1,004,500 o Energy Sales revenue from an energy contract is budgeted at $1,205,610. This amount is based on RUC's unit #1 called upon for 18,000 MWHR's (450 Hrs.). Market sales are budgeted at $100,000 in the 2017 budget. o Other Revenues: o The 2017 budget shows the same amounts budgeted for in the misc. revenue areas as 2016. In addition, the 2017 budget shows $100,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.77 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 2017 projections. o LMP expense is budgeted on a 2012 -Oct. 2016 (4.83 year) average HUC LMP price. Using a market price of $28.57 per MWHR and purchasing 62,392 MWHRs. LMP power needs equate to 21.3% of power supply needed based on 2017 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. o 11,800 MWHR's are budget for Hedging. Generation hedging equates to 4.0% of power supply needed based on 2017 projections. o Electric Production Expenses: o Fuel: Includes $163,485 in natural gas contracted at $2.595 per MCF for unit #8 hedging, $211,416 at a spot price of $3.83 per MCF for units #3, #4, #5 hedging & market sales, and $689,400 in natural gas budgeted for the energy contract. Other misc. budget for fuel oil, water & sewer, and boilers. o In addition, includes $651,700 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 Spot market price for natural gas is $3.83. (2011-2015 avg.) o The 2017 budget reflects generating 11,800 MWHR's for hedging purposes and 500 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 $675,000 over the 2016 budget. The 2017 increase is primarily due to two factors: 1) the average transmission zonal price increasing from $4.68/kW in 2016 to $5.26/kW in 2017. GRE's rate increase along with the projected decrease in network load is the major reasons for the zonal price rate change. 2) Budgeting MISO transmission fees at the projected 2016 year end costs increases the MISO transmission budget for 2017. o $10,000 is in the 2017 transmission budget for GRE to provide transmission planning services for HUC to continually meet NERC reliability requirements. o Electric Distribution Expenses: o Roughly 90% 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. 2017 Additional Operating Budget Noteworthy Items o It is anticipated HUC will see a significant increase in PCA's compared to 2016 because of the increase budgeted costs of purchasing base load energy and transmission services. o Staff is continuing to review the latest EPA rulings (Cross State Air Rule & 111d Clean Air Act) to understand the future potential impacts to HUC's core business operations. o Management is continuing to review organizational operations for opportunities to reduce costs, take advantage of revenue opportunities, streamline operations, and reallocate resources to achieve long-term sustainability. 2017 Capital Budgets for Electric Division Electric Production Capital Budget - $313,500 o Plant 1 window replacement (phase 2) - $150,000 o Unit #8 generator field breaker/voltage control replacement - $95,000 o Unit #8 boiler non -return valve - $40,000 o Plant 1 alarm panel upgrade - $10,000 o Unit #1 control system batteries - $8,500 o Plant 1 electrical panel upgrades - $10,000 Electric Distribution Capital Budget -$245,000 o Roof replacement Hutch substation — $10,000 o Pole, Towers, Fixtures — $10,000 o Station equipment - $10,000 o Duct Installation — $20,000 o Re -conductor replacement (FDR # 16 & #17) - $65,000 o Hutchinson High School —$60,000 o Transformer replacements - $40,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 -$297,000 o Vactron w/heater - $60,000 o F550 Dump Truck - $30,000 o Genie Lift - $17,000 o F550 Super Duty Bucket Truck - $130,000 o Tractor Backhoe - $60,000 2017 Operating Budget - Gas Division General 2017 Budget Items o Budget currently reflects — 13% Health Insurance Plan premium decrease based on an increased $3600/$7200 deductible program and HUC qualifying for the small group plan, which continues to include the HRA embedded within the insurance plan. In addition, the budget reflects an 80%/20% premium split for exempt and non-exempt employees. The Dental plan for 2017 will see a 0% increase, while the LTD and Basic Life & AD&D will see slight decreases from the 2016 rates. The Worker's Comp is estimated at a 5% increase over 2016 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 increase in the budgeted amount for 2017 to administer the Conservation Improvement Plan (CIP) to the current intentions of the State Program and State Statute language. (1.5% energy savings goal) 2016 Budget $540,657; 2017 Budget $540,911; budget amount will not necessarily all be expended in 2017. o Budget reflects a HUC transfer amount of $1,397,258. This is a decrease of $108,925 from 2016. Continues the 2.75% PILOT transfer formula amount while maintaining street light reimbursement, Tree Program, & reimbursement for IT, HR, Legal. Natural Gas Operating Revenues o Retail Sales Forecast: o Retail (Residential & Commercial) sales have been forecasted on a 5+ yearly average (2011-2016) at 869,765 MCF for 2017. o Industrial sales have been forecasted on a 5+ yearly average (2011-2016) at 786,836 MCF for 2017. Two of the three industrial customers are transport customers with HUC providing the commodity as a pass through. The industrial transport sales are based off a transport charge based on transport volume of 786,836 MCF and a blended gas price of $3.41 per MCF with an off -setting expense for HUC to purchase the natural gas. o Fuel Cost Adjustment: o A Fuel Cost Adjustment (FCA) is not factored into the 2017 budget. o Other Revenues: o Budgeted $734,878 for the New Ulm Contract o Budgeted $651,700 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. ($33K) Natural Gas Operating Expenses o Purchased Gas Expense o Retail Customers: The expense for this class is based off a 5+ year average (2011-2016) consumption level at 869,765 MCF,s, Contracted Gas makes up "76% of the MCF's needed for retail customers at an average weighted price of $4.98. The remaining ~ 24% of retail gas needed will be purchased swing gas at an estimated price of $3.83. The $3.83 swing gas price is based on daily pricing so there is more volatility than the swing gas price used for the Industrial Customers which is based on the 1st of the month pricing. Total average weighted natural gas price budgeted is $4.71. o Industrial Customers: consumption based on a 5+ yearly average. (2011-2016). The budget is based on 786,836 MCF,s at an estimated blended gas price of $3.41. * Total blended budgeted expense is $4.09 per MCF. o Natural Gas Transmission Expense o Mostly personnel costs, routine maintenance & repairs based on MNOPS Program requirements. o Natural Gas Distribution Expense o Mostly personnel costs, Routine maintenance & repairs based on MNOPS Program requirements. 2017 Additional Operating Budget Noteworthy Items o Staff is continuing to explore partnership opportunities to leverage the Natural Gas Transmission Pipeline Hutchinson Utilities Commission owns. o Management is continuing to review organizational operations for opportunities to reduce costs, take advantage of revenue opportunities, streamline operations, and reallocate resources to achieve long-term sustainability. 2017 Capital Budgets for Gas Division Natural Gas Transmission Capital Budget -.$1,255,000 o Potential Lateral Transmission Expansion - $1,000,000 o Potential Hanska Interconnect station - $215,000 o Specific gravity meter - $40,000 Natural Gas Distribution Capital Budget - $95,000 o Industrial metering and regulation - $20,000 o Meters, regulators, AMI Modules - $70,000 o Gas detection equipment - $5,000 Natural Gas Division Capital Budget (As Necessary) - $:L00,000 o Misc. developments & system improvements - $30,000 o Service Lines - $55,000 o Improvements to regulator stations - $15,000 ELECTRIC DIVISION Dollar % change YEAR j2014TActual5 Actual 2016 Budget 2017 Budget Inc/(Decr.) 2016/2017 REVENUES:Residential -- Residential 5,,080,964 3,731,066 5,030,722 5,105,571 74,849 1.49% Small General 1,6,281,621,751 3,081,815 1,581,216 1,613,269 32,053 2.03% Large General 7,175,480 7,141,340 7,076,630 7,175,398 98,768 1.40% Industrial 11,001,396 11,399,155 10,511,135 10,043,839 (467,296) -4.45% Power Cost Adjustments - - - 1,100,000 1,100,000 0.00% Street Lighting 139,533 146,931 144,535 147,384 2,849 1.97% Sales for Resale 678,293 1,114,918 11907,820 2,310,110 402,290 21.09% Other Revenues 339,705 426,973 280,200 280,200 - 0.00% In terest Earnings 14,860 15,978 57,500 50,000 (7,500) -13.04% TOTAL REVENUES: 26,123,768 26,948,010 26,589,758 27,825,771 1,236,0134.65% 1.5% EXPENSES: 10,460,268 5,988,821 7,214,755 6,782,224 (432,531) -6.0% Personnel Costs 4,495,713 4,588,701 4,798,888 4,727,137 (71,751) -1.5% Purchased Power 13,850,238 14,706,630 13,875,028 14,208,043 333,015 2.4% Transmission 1,512,071 1,785,988 1,875,000 2,550,000 675,000 36.00% Generator Fuel/Chemicals 1,328,850 841,038 1,341,604 1,249,801 (91,803) -6.84% Depreciation 2,744,769 2,816,301 2,700,000 2,800,000 100,000 3.70% Transfers (Electric/City) 1,823,897 1,026,224 1,401,635 1,333,516 (68,119) -4.86% Operating Expense 1,812,567 1,716,653 1,571,585 1,746,330 174,745 11.12% Debt Interest 40,532 35,196 30,613 25,488 (5,126) -16.74% TOTAL EXPENSES: 27,608,637 27,516,732 27,594,353 28,640,313 1,045,961 3.79% NET PROFIT/(LOSS) $ (1,484,869) $ (568,722) $ (1,004,595) $ (814,542) 190,052 -18.92% GAS DIVISION Dollar % change YEAR 2014 Actual 2015 Actual 2016 Budget 2017 Budget Inc/(Decr.) 2016/2017 REVENUES: -- Residential 4,706,389 3,731,066 4,588,522 4,474,618 (113,904) -2.48% Commercial 3,853,504 3,081,815 4,023,501 3,882,533 (140,968) -3.50% Contracted Industrial 6,066,290 3,110,620 3,578,643 3,200,440 (378,203) -10.57% NU Transportation 808,575 776,164 730,636 734,878 4,242 0.58% Electric Division Transfer 700,000 641,833 647,166 651,700 4,534 0.70% Other Revenues 244,212 269,932 212,608 218,608 6,000 2.82% Interest Earnings 14,860 15,978 57,500 50,000 (7,500) -13.04% TOTAL REVENUES: 16,393,830 11,627,408 13,838,576 13,212,777 (625,799) -4.52% EXPENSES: Personnel Costs 1,274,037 1,341,770 1,259,800 1,278,092 18,291 1.5% Purchased Gas 10,460,268 5,988,821 7,214,755 6,782,224 (432,531) -6.0% Depreciation 1,002,804 1,008,133 1,056,000 11008,000 (48,000) -4.55% Transfers (City) 605,176 206,980 406,252 367,131 (39,121) -9.63% Operating Expense 660,168 588,908 781,955 836,676 54,721 7.00% Debt Interest 864,000 821,833 781,500 735,100 (46,400) -5.94% TOTAL EXPENSES: 14,866,452 9,956,446 11,500,263 11,007,223 (493,039) -4.29% NET PROFIT/(LOSS) $ 1,527,378 $ 1,670,962 $ 2,338,314 $ 2,205,554 (132,760) -5.68% 2012 BUDGET ELECTRIC Detailed Income Statement Electric Division l 2013 Actual I 2014 Actual 2015 Actual I 2015 Budget 2016 Budget 1 2017 Budget Energy Sales Revenue 129,568 S 144,106 $ 144,105 $ 145,000 S 145,000 Sales- Electric Energy (440, 442, 444) $ 24,598.181 $ 25,090,910 $ 25,390,141 $ 24,570,604 S 24,344.238 $ 24,085,461 Power Cost Adjustments $ - $ - $ - $ - $ - $ 1,100,000 Other Energy Sales (447) $ 891,276 S 678,293 $ 1,114,918 $ 994,000 $ 1,907,820 $ 2,310,110 Total Energy Sales Revenue (440, 442, 444, 447) $ 25,489,457 $ 25,769,204 $ 26,505,059 $ 25,564,604 $ 26,252,058 $ 27,495,571 Revenue From Other Sources S 1,711,119 S 2,056,622 $ 2,781,483 $ 560,929 3 606,544 Revenue From Other Sources (450,45L $ 297,525 $ 292,778 $ 285,738 $ 270,200 $ 270,200 $ 270,200 Security Lights (454 01) $ 11,033 S 11,301 $ 11,269 $ 10,000 $ 10,000 $ 10,000 Pole Renta! (454 02 454.03 $ 32 $ 16 $ - $ - $ - $ - Total Revenue From Other Sources (450, 451, 454) $ 308,589 $ 304,095 S 297,007 $ 280,200 $ 280,2D0 $ 280,200 TOTAL OPERATING REVENUES S 25,798,046 $ 26,073,299 $ 26,802,066 $ 25,844,804 $ 26,532,258 $ 27,775,771 OPERATING EXPENSES Production Operations Operal on Supervision 8 Eng nearing (546) Fuel (547) Operating Supplies and Expense (550, Total Production Operations (546, 547, 550) Maintenance Operations Structures (554) Generating Units (554) Other Equpment (554) Total Maintenance Operations (554) Other Power Supply Expense Purchased Power (555) System Control 6 Load Dispatch (556, Eng neering Services (557) Total Other Power Supply Expense (555, 556, 557) Transmission Expense Transm.sslon Expense Operation (560) Transm.ssion Expense Operation (565; Transmsslon Expense Operation (567) Transm. ss�an Expense Maintenance (574) Total Transmission Expense 1560, 565, 567, 574) Distribution Expense: D.stnbution Operation (580, 581, 586, 586. 58.9; Dstributlen Maintenance (592) Dstribution Maintenance (594) D stribution Maintenance (595) Dstribution Maintenance (596) Distribution Maintenance (598) Dstribution Maintenance (592, 594, 595, 596, 598) Total Distribution Expense (580 ,581, $86, 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 (9 16) Total Sales Expense (911, 916) Administrative and General Adminstretive and General Labor (920) Office Supplies and Expenses (921) Outs de Services (923) Properly Insurance (924) Employee Pension 8 Benefits (926) Regulatory Expense (928) Misc General Expense (930) Me nt. Of General Plant (935) Total Administrative and General (920, 921, 923, 924, 926, 928, 930, 935) Other Expenses Deprec,atlon Expense (403) Payment in Lieu of Taxes (408) Contribution To City - Roadway Lighting (4081 Total Other Expenses (403, 407, 408) $ 1,126.083 $ 1.037,894 $ 1,045,830 S 1.677.897 $ 1,678.384 $ 1.599,193 $ 2,405,737 $ 1.918.251 $ 1,390,880 $ 1,795025 $ 1,859,370 S 1,772,101 $ 162,780 $ 146,501 S 165,871 $ 117.600 $ 155,500 $ 155 500 $ 3,694,599 $ 3,102,646 $ 2,602,580 $ 3,590,522 $ 3,693,254 S 3,526,794 $ 448 $ 6.165 3 3,184 $ 5,000 $ 7,000 $ 10,000 $ 318,352 $ 375,626 $ 339.876 $ 418 538 S 451,230 $ 483,496 S 180.501 S 118,081 $ 121,123 S 35.000 $ 40,000 $ 40,000 $ 499,300 $ 499,872 S 464,184 $ 458,538 $ 498,230 S 533,496 $ 13,342,967 S 13,B50,238 $ 14,706,630 $ 14.862,607 S 13.875,028 $ 14,208,043 $ 330,932 $ 328,571 $ 353,405 S 482.005 $ 514,668 $ 488 152 $ 95,932 $ 9,162 $ 8.148 $ - $ $ S 13,769,830 $ 14,187,971 $ 15,068,183 $ 15,344,612 $ 14,389,696 $ 14,696,195 $ 129,568 S 144,106 $ 144,105 $ 145,000 S 145,000 $ 145,000 $ 1,289,968 S 1,512,071 $ 1,785,988 $ 1,535,000 $ 1,875,000 $ 2,550000 $ 82 $ - $ - $ 100 $ 10,000 $ 10 000 $ 73,734 $ 28.361 $ 23.231 $ 31,019 $ 26,622 $ 76.483 S 1,493,352 S 1,6114,538 $ 1,953,325 S 1,711,119 S 2,056,622 $ 2,781,483 $ 560,929 3 606,544 S 630,699 $ 1,173,208 $ 1,224,224 $ 1,190.420 $ 18,151 $ 16,327 $ 10.086 S 12.253 $ 11,893 $ 12,307 $ 163,965 $ 123,852 $ 100,165 $ 133.281 $ 118,176 $ 127,181 $ 22,859 $ 12,207 $ 10,571 $ 13,197 $ 13,411 $ 13,908 $ 65,695 S 53,582 $ 90,272 $ 68.451 $ 70,659 $ 75,764 $ 51,151 $ 50,586 $ 52,351 S 41,756 $ 42.737 $ 45,006 $ 321 821 $ 256,554 $ 263,446 S 268,938 $ 256,876 $ 274,166 $ 882,750 S 863,097 $ 894,144 $ 1,442,146 $ 1,481,100 $ 1,464,586 $ 18,794 S 17,153 $ 23,258 $ 21,108 $ 21,331 $ 10,361 S 127,589 $ 115,324 $ 152.037 $ 176,059 $ 186,095 $ 209,667 $ 5,070 $ 10,875 $ 4 658 $ 8 250 $ 8,250 S 5.500 $ 40,260 S 47,286 $ 49,517 $ 53.347 $ 55,682 $ 58,078 $ 191,713 $ 190,638 $ 229,470 $ 258,763 $ 271,358 $ 283,606 5 - $ 5684 $ 5.010 $ - $ - $ - $ $ 192,057 $ 339,637 $ 220.968 $ 374,942 $ 360,851 S 357,20'. $ 197,740 $ 344,647 $ 220,968 $ 374,942 $ 360,851 $ 357,201 $ 520,388 $ 467,125 $ 452,383 $ 455,177 $ 417,549 $ 439.059 $ 281,574 $ 254,183 $ 248,368 $ 222,300 5 222,750 $ 322,664 $ 147.846 $ 109,766 $ 106,060 $ 112,931 $ 80.306 $ 110.306 $ 102 512 $ 91.736 $ 88,969 S 105,000 $ 105,000 $ 88,200 $ 1.240.786 $ 1,266,411 $ 1,355,579 $ 212,705 $ 189,134 $ 199,958 $ 23.980 $ 24,305 $ 23,322 S 30,000 $ 30.000 $ 30,000 $ 95,031 $ 87,491 $ 67,948 $ 106,136 $ 119.636 $ 102.836 $ 71,061 $ 63,752 $ 46,508 S 47,861 $ 46,850 $ 46.842 $ 2,483,179 $ 2,364,769 $ 2,389,037 S 1,292,110 $ 1,211,225 $ 1,339,865 $ 2,612,388 $ 2,744,769 $ 2,816,301 $ 2.700,000 $ 2,700,000 $ 2,800,000 $ 912.000 $ 1,123,897 $ 384,391 $ 384,391 $ 754,469 $ 681,816 $ 142,666 $ $ 146,739 $ 146.739 $ 144,535 $ 147.384 $ 3,667,055 S 3,868,666 $ 3,347,431 $ 3,231,130 $ 3,599,004 $ 3,629,200 TOTAL OPERATING EXPENSES OPERATING INCOME (LOSS) NONOPERATING REVENUESI(EXPENSES) Merchandise & Contract Work. Net Interest Income Misc. Income Bond Service Fees Interest Expense -Fronds Gain (Loss) On Dsposal 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 Saks Net Income (%) of 0peraring Sales {otter cap lobar & PCA) Detailed Income Statement Electric Division 2013 Actual 2014 Actual2015 Actual 2015 Budget 2016 Budget 2017 Budget $ 26,879,519 $ 27,106,844 $ 27,169,322 5 27,703,882 $ 27,561,340 5 28,612,426 $ (1,081,473) $ (1,033,545) $ (367,256) $ (1,859,078) $ (1,029,082) $ (836,655) $ {21,474) $ 41,724 $ (49,243) S - $ $ - $ 37,970 $ 14.860 $ 15,978 $ 32,500 $ 57,500 $ 50,000 $ 58 031 $ 35,408 $ 129,966 S - $ - $ , $ (2,400) $ (450) $ - $ (2,400, S (2,400, $ (2,400) $ 185.537) $ (40,082) $ (35,196) $ (35,613 S (30,6131 $ (25,488) $ 10,000 $ 23,159 $ - $ - $ - $ - $ 2017 Net Income $ (814,542) $ (525,943) $ (525,943) $ (262,972) S (262.972) $ $ $ (529,353) $ (451,324) $ (201,466) $ (268,484) $ 24,488 $ 22,113 $ (1,610,826) $ (1,484,869) $ (568,722) $ (2,127,562) $ (1,004,594) 5 (814,542) $ 19,457,081 $ 19,475,027 $ 20,088,271 $ 21,104,790 $ 20,637,802 $ 21,537,968 $ 6,340,964 $ 6,598,272 $ 6,713,795 $ 4,740,014 $ 5,894,456 $ 6,237,803 24.69 15.3% 25.0% 18.3% 11.2% 22.5% -0.2% -4.0% -1.4% -7.2% -3.9% -3.0% -6.1% -5.7% -2.1% -8.2% -3.8% -2.9% ' -7.0% -1.89 -2.2% NET INCOME 2017 Net Income $ (814,542) Capitalized Labor - Production $ 32,000 Capitalized Labor - Distribution $ 158,500 2017 Net Income $ (624,042) CASH FLOW STATEMENT 2017 Net Income $ (814,542) Depreciation $ 2,800,000 2017 Cap Exp $ (855,500) 2016 Cash Proceeds SOE $ 75,000 2003B Principal $ (125,000) 2017 Electric Cash Flow $ 1,079,958 2017 Cap Exp (A5 necessary) $ 116,000 Electric Division Operating Revenues 2017 ELECTRIC BUDGETED REVENUES Sales for Resale, $2,310,110,8% Street Lighting, $147,384 ,1% �\ Other Revenue, $280,200 , 1% Interest Earnings, $501000,0% Residential, $5,105,571, 18% Small General, Industrial, $10,043,839, 36% Sales by Customer Class Electrical Residential (all electric included) $ Electrical Small General Service $ Sub -Total $ Sales by Customer Class Electrical Large General Service Electric Large Industrial Sub -Total NOTAL DEMAND, METER, ENERGY Roadway Lighting Meter Charge 480,090.00 99,240.00 579,330.00 Demand Charge $ 1,333,751.60 $ 1,826,659.80 $ 3,160,411.40 Revenues Energy Charge $ 4,625,480.62 $ 1,514,028.75 $ 6,139,509.37 Energy Charge $ 5,841,646.15 $ 8,217,179.22 $ 14,058,825.37 Totals $ 5,105,570.62 $ 1,613,268.75 $ 6,718,839.37 Totals $ 7,175,397.75 $ 10,043,839.02 $ 17,219,236.77 $ 3,739,741.40 $ 20,198,334.74 $ 23,938,076.14 $ 147,384.02 Total Sales --440, 442, 444 + Rdwy Ug. $ 24,085,460.15 Electric Division Number of meters Year Residential Residential All Electric Small General Service Large General Service Large Industrial Total 1990 4,539 290 599 79 1 5,508 1991 4,435 239 575 78 1 5,328 1992 4,456 266 563 77 1 5,363 1993 4,456 260 628 84 1 5,429 1994 4,463 260 632 82 2 5,439 1995 4,722 239 668 87 2 5,718 1996 4,786 237 705 92 2 5,822 1997 4,935 244 735 95 2 6,011 1998 5,114 239 742 100 2 6,197 1999 5,197 241 752 104 2 6,296 2000 5,315 239 774 109 2 6,439 2001 5,358 248 779 114 2 6,501 2002 5,437 246 799 115 2 6,599 2003 5,541 248 810 118 2 6,719 2004 5,626 249 797 118 2 6,792 2005 5,685 253 802 117 2 6,859 2006 5,741 263 816 119 3 6,942 2007 5,754 261 816 117 3 6,951 2008 5,787 273 777 128 3 6,968 2009 5,813 271 807 125 3 7,019 2010 5,815 270 814 125 3 7,027 2011 5,830 258 811 122 3 7,024 2012 5,846 255 815 122 3 7,041 2013 5,851 256 815 126 3 7,051 2014 5,859 257 816 125 3 7,060 2015 5,888 258 827 112 3 7,088 2016 5,899 256 827 111 3 7,096 # of Meters Months Annualized Ext. Meter Charge Annual Revenue Residential Meters = 6,155 12 73,860 $ 6.50 $ 480,090 Small GS Meters = 827 12 9,924 $ 10.00 $ 99,240 2017 METER CHARGE REVENUE $ 579,330 X_RevsrhlieAtlocatlonbyRatetaass 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 Electric Large General Demand 42% 42% 41% 44% 46% 45% 45% 46% 44% 45% 48% 47% 46% 45% 47% 47% 45% 45% 44% Jectnral Large Industrial Demand 58% 58% 59% 56% 54% 55% 55% 54% 56% 55% 52% 53% 54% 55% 53% 53% 55% 55% 56% rhe 8 year trend seems to 1ndlcate that about 46.1. o/ the demand should be allocated to Large General Demand, and 54% to Large /ndustdal Demand Total Total KW Demand for 041 and 051 rate codes = .._._._ _ _ _ __ _ ,.. ..R_. _ . ,m _�_. ..,� _ __.. .� By Class Total KW Demand Extension Electric Large General Demand 46% 222,292 _ 3 1,333,752 Electrical Large Industrial Demand 54% 260,951 $ 7.00 Month 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 Jen 20,571 36,391 35,062 35,845 34,896 40,935 39,404 40,799 38,572 39,663 40,343 37,801 37,578 38,155 36,446 35,751 35,324 35,603 35,207 Feb 33,165 36,590 35,467 36,242 37,603 39,997 38,964 39,969 38,354 39,865 41,090 36,423 35,445 38,349 35,837 36,255 35,631 35,098 34,433 Mar 32,995 36,598 38,499 35,362 37,228 39,974 42,058 39,625 38,358 40,549 40,361 37,967 37,741 38,133 39,626 35,885 36,852 36,843 37,166 Apr 38,490 37,908 37,553 35,714 44,700 43,591 45,269 41,326 42,423 43,221 43,395 38,553 39,994 39,135 38,612 37,186 31,539 38,418 38,288 May 43,648 39,143 40,005 36,627 42,632 44,818 46,540 42,187 44,871 44,931 42,843 42,812 43,470 46,498 43.422 41,044 47,131 41,739 41,141 June 44,213 42,115 42,989 41,734 47,631 48.288 46.115 49,815 47.125 49,435 47.085 44,967 48,005 51,694 47,163 45.798 44.301 44,772 42,981 July 45,416 45,144 43,392 46,540 45,648 49.681 49,389 49,703 49,449 52,234 50,877 45,565 47,484 49,210 48,071 45,871 45,090 46,838 45,256 August 39,285 45,654 45,290 45.656 47,602 38,155 47,579 50,513 50.482 51,792 52,000 46.454 50,517 49,623 45,823 47,017 44,816 45,907 46,451 Sept 43,300 45,034 44,639 45,231 46,579 50,260 48,471 48,083 45,598 51,225 48,065 44,751 46,351 46,331 44,247 45,655 47,215 47,680 47,680 October 39,219 39,983 44,508 41,385 45,455 46,814 43,405 46,347 42.696 48,415 48,567 41,099 43,360 43,351 39,080 40,420 38,836 39,642 39.642 November 38,125 39,950 43,010 40,640 41,052 39,689 43,698 42,474 40,921 41,829 42,849 38,063 40,018 37,646 36,579 35,761 37,140 38,589 38.589 December 36.155 37,129 36,580 40,212 38,796 40,605 37,604 39,743 40,274 40,606 38,690 38,333 37,846 35,910 34,946 35,418 36,635 36,030 36,030 Total 454.582 481,639 486,994 481.188 510,022 522,807 528.496 530,584 519.123 543,765 538,173 494,797 507,809 514,035 489,852 482,061 480,510 487,159 482,864 % change yy 5.95% 1.11% -1,19% 5.99% 2.51% 1.09% 0.40% -2.16% 4.75% -1.03% -8.06% 263% 1.23% 4.70% -1.59% -0.32% 1.38% -0.88% X_RevsrhlieAtlocatlonbyRatetaass 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 Electric Large General Demand 42% 42% 41% 44% 46% 45% 45% 46% 44% 45% 48% 47% 46% 45% 47% 47% 45% 45% 44% Jectnral Large Industrial Demand 58% 58% 59% 56% 54% 55% 55% 54% 56% 55% 52% 53% 54% 55% 53% 53% 55% 55% 56% rhe 8 year trend seems to 1ndlcate that about 46.1. o/ the demand should be allocated to Large General Demand, and 54% to Large /ndustdal Demand Total Total KW Demand for 041 and 051 rate codes = .._._._ _ _ _ __ _ ,.. ..R_. _ . ,m _�_. ..,� _ __.. .� By Class AfloCidiOn Caitiila(bn" Extension Electric Large General Demand 46% 222,292 _ 3 1,333,752 Electrical Large Industrial Demand 54% 260,951 $ 7.00 $ 1,826,660 TOTAL 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 Jectric Large General Demand 190,480 201,344 200,424 209,558 234,292 235,927 238,786 241,544 230,443 244,694 270,336 230,468 233,539 228.825 228.572 225,111 218,310 217,799 212.460 JecbtcalLarge Industrial Demand 265,656 279,900 286,570 271,630 279,330 286,880 289,710 289,040 288,680 299,071 295,630 262,320 274,270 285,210 261,280 256.950 262,200 269,360 270,404 Total Demand 456,136 481,244 486,994 481,188 513,622 522,807 528,496 530,584 519,123 543.765 565,966 492,788 507.609 514,035 489.852 482.061 480.510 487,159 482,864 X_RevsrhlieAtlocatlonbyRatetaass 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 Electric Large General Demand 42% 42% 41% 44% 46% 45% 45% 46% 44% 45% 48% 47% 46% 45% 47% 47% 45% 45% 44% Jectnral Large Industrial Demand 58% 58% 59% 56% 54% 55% 55% 54% 56% 55% 52% 53% 54% 55% 53% 53% 55% 55% 56% rhe 8 year trend seems to 1ndlcate that about 46.1. o/ the demand should be allocated to Large General Demand, and 54% to Large /ndustdal Demand Total Total KW Demand for 041 and 051 rate codes = e......,...._ 483,243 ..� . _� ..,.. on KW Applicable Unit By Class Rate Extension Electric Large General Demand 46% 222,292 $ 6.00 3 1,333,752 Electrical Large Industrial Demand 54% 260,951 $ 7.00 $ 1,826,660 TOTAL 3 3,180,411` Sobs W Cvslomer Q 1998 1999 2000 2001 2002 2003 2004 7005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 S -RV Lgt4s 113,160 103,516 95,588 93.212 84.568 73801 72.758 104,328 7006 2007 2048 2009 2010 100,514 97.306 97,616 100565 100.453 StI MLi916>t 1.132.800 1,054.430 1.040,890 1.062810 1.049.881 418277 Sam 1.748 118.592 127414 124.275 99,290 98,575 6.931 7.014 8.154 4,145 3.523 pactrlcal RwNwltbl 40,931.643 41,472.997 42942.673 44,051.388 47,152663 48194200 4&107,656 49867804 49931.627 51.088707 49.397.391 47,288.811 60,422541 50985,858 50.726,192 57,175.792 50550.807 /9467888 NIpg91cs1 Rs110e14is1 2364.685 2,149.460 2,508113 2516382 2886.528 277&190 2507.374 2643,511 2629.173 2813032 2673.401 2546,491 2,667,220 ZSX355 2.340244 2.879334 2,694,481 2451150 pscflcd S -M 0-1 S- 17.902,143 24667005 1&371.449 18381,160 18782464 19,697943 18892852 18,757.085 18.674359 19 292.M4 1&702,897 9,624,043 9,619,062 9,726,219 9645.115 9.590.112 9513,090 9,372947 pslrlcal SmMl G-1 Electrksl Lsr9s G -,V Setwca - 61,106,435 - 86,528,810 - 70,970.941 71543508 - 76.56&166 75547,365 - 75025.022 - 77.405.135 76,993.511 79,100,495 81,203,714 7.828,881 78765584 7,639320 8.115475 K402901 7,716.681 7451.140 7.582950 Elsctrc Largs lrtt bW 160.221.800 157.442.000 160.334000 149334.DOD 15070&000 756088000 148.295,000 ISZO04000 158,081.000 163346.000 158,12&000 128727000 81,514.597 141.509.000 80.125.637 140,O6S000 8Z 193045 00,487.539 79067..541 7&054.119 Ssbs for P..." 5 706350 .31,571000 13,315 DQQ 515A000 10..696.000 7 S23000 12.301.000 173000 74,000 19,308,000 11.650000 1.952 5.997.000 4.755000 129.470000 1599D.D00 127,066.000 134.419.000 142.752000 T41al S.I. 330,479.077 330,291.704 309.576654 340.555447 307904.510 310.31&776 304207.747 301.556.411 30&502.272 335162282 322,279,678 275.712600 299.667315 296.540.909 15,48a WO 11.790000 10 .880000 29&872.117 291,285.210 295,610589 x00.667030 %Inddec-Pnv Yr. 1W 00% -31% .6.3% 18.0% -941% 80% .2.0% 49% 1.8% 04% •3.8% .14.4% 9.7% .1.4% 98% •14% a". 1.7% Lees Ra6b. Sec Lts," St. Lu 295.526707 297460.750 295125.176 287826.425 295874061 302,303008 290.826106 301.277.335 30&309.680 315846866 310305.403 273 600 810 MS71,740 29167&514 292.777.797 27&715.438 283715,859 299683.054 %Elecbic C-onssempU by Custa^�er'Class 1988 1990 2000 2001 2002 2003 2004 2005 7006 2007 2048 2009 2010 2011 2012 2013 2014 2015 pactrcelRskp4lsl 14.34% 1394% 1455% 1530% 1594% 1594% 15.65% 1665% 16.30% 18.19% 1502% 1727% 1716% 1746% 1794% 1636% 1782% 1705% AN Elac9k/4 RaaW." EJactrk415MW 083% 079% 085% 087% 090% 092% 056% 088% 0.56% 0.89% 093% 093% 0.91% 0.90% 083% 096% 095% 0.65% Garrrsl Serviu 627% 997% 8.22% 639% 835% 6.52% 650% 8.23% &10% 6.11% 503% 348% 3.28% 3.33% 141% 3.44% 3.35% pactrlc, Sold11-1Cil Sarv6a 000% 000% 0.00% 000% 000:4 000% 000% 000% 0.00% 0.00% 000% Z68% 2.67% 2.79% 2.97% 324% .sono) Lat9s G-1 S.M. 22.45% 2237% 2405% 2555% 26 55% 2400% 25 60% 2569% 2514% 25.08% 2617% 2&05% 27.77% 2747% 29 277% 2.63% 2.62% Ebctrk L."ltW4trW 5011 5293% 5433% 51 50.94 5163% 50 5085% 5181% 6175% 50 BB% 4710% 46, l8.02X .07% 45.79% 2880% 27.% 85 26.94% TOTAL 100.00% 10000% 100.00% 10000% 10000% 10000% 10000% 10000% 100.00% 100.00% 10000% 10000% 1559% 47.35% 1925% 100.00% 100.00% 100.00% 1W 00% 10000% 10000% P..I wRW1/R S".f/ 20/6• 244,10071045 Unit Sales (MW's) -info from Power Cost Adjustment Spreadsheet 2016 2015 2014 2013 2012 2011 2010 2009 Average St Dev Jan 22,103 22,859 23,577 22,990 22,567 24,766 23,606 21,385 22,982 1,045 Feb 22,583 22,259 21,168 21,104 21,114 22,174 22,595 20,305 21,663 823 Mar 22,715 23,535 22,283 20,917 22,178 24,806 23,235 21,011 22,585 1,401 Apr 20,838 21,979 22,034 22,859 22,440 22,250 22,917 21,800 22,140 435 May 22,754 21,867 21,594 21,132 24,086 23,396 22,847 20,059 22,217 1,390 Jun 25,987 27,295 25,171 20,147 25,119 26,593 26,601 24,313 25,153 2,395 Jul 25,370 28,621 27,605 33,144 30,035 28,311 27,894 26,040 28,378 2,256 Aug 30,222 27,338 26,250 25,383 28,064 30,174 30,933 26,336 28,088 2,275 Sep 23,561 26,332 26,140 24,784 22,275 24,249 24,441 24,945 24,591 1,263 October 23,675 22,626 22,999 22,876 22,631 21,668 21,801 23,692 22,746 766 November - 22,054 20,001 20,139 20,511 21,418 22,561 20,195 20,983 1,001 December - 22,256 24,235 22,745 21,136 21,099 23,460 23,104 22,577 1,271 239,808 289,020 283,057 278,220 282,158 290,905 292,892 273,187 284,101 Expected 2017 Sales Iculatlon of Rest for KWHR Rate Energy 2017 Total KWHR Rest Add in FCA to Energy Total Energy ctrical Residential 0.05810 0.0872 0.0291 - 0.05810 Electrical Residential 0.05810 0.0872 0.0291 0.05810 ctncal Small General Service 0.05810 0.0911 0.0330 0.05810 cbical Small General Service 0.05810 0.0855 0.0274 0.05810 chical Large General Service 0.05810 0.0737 0.0156 - 0.05810 chic Large Industrial 0.05810 0.0610 0.0029 0.05810 Predicted Sales for 2017 = 284.100,710 $ 579,330.00 Large General Demand $ 1,333,751.60 2017 $ 1,826,659.80 Annual Revenue Annual Revenue Capacity Sales $ 675,500.00 Sales for Resale $ 1,232,320.00 Total Revenue ected $ 25,845,896.14 Allocation % KWHR Allocations to be used in 2019 Allocation % KWHR Albcatiorx to be used In 2017 % Allocation KWHR Sales 2017 KWHR Rate Large General Demand KWHR Rate Rate Extension Extension $ 20,198,334.74 Energy Cost Mark-up EnergLCost Energy Cost Mark-up KWHR Rate 50,432,797.19 Electrical Residential 17.7517% 50,432.797.19 $ 0.05810 $ 0.02910 $ 0.08720 $ 4,397,739.92 AN Electrical Residential 0.9193% 2,611,705.31 $ 0.05810 $ 0.02910 $ 0.08720 $ 227,740.70 Electrical Small General Service 3.3431% 9,497,909.82 $ 005810 $ 0.03300 $ 0.09110 $ 865,259.58 Electrical Small General Service 2.6709% 7,587,943.43 $ 0.05810 $ 0.02740 $ 0.08550 $ 648,769.16 Electrical Large General Service 27.8994% 79,262,498.64 $ 0.05810 $ 0.01560 $ 0.07370 $ 5,841,646.15 Electric Largelndustnal 47.4155% 134,707,856.05 $ 0.05810 $ 0.00290 $ 0.06100 $ 8,217,179.22 $ 8,217,179.22 100.0000% 284,100,710.45 284,100,710.45 $ 20,198,334.74 Predicted Sales for 2018 = 284,100,710 $ 579,330.00 Large General Demand $ 1,333,751.60 2018 $ 1,826,659.80 Annual Revenue Annual Revenue Capacity Sales $ 675,500.00 Sales for Resale $ 1,232,320.00 Total Revenue ected $ 25,845,896.14 Allocation % KWHR Allocations to be used in 2019 Allocation % KWHR Allocations to be used in 2018 % Allocation KWHR Sales 2018 KWHR Rate Large General Demand KWHR Rate Rate Extension Extension $ 20,198,334.74 Energy Cost Mark-up Enemy Cost Energy Cost Mark-up KWHR Rate 50,432,797.19 Electrical Residential 17.7517% 50,432,797.19 $ 0.06000 $ 0.02720 S 0.08720 $ 4,397,739.92 All Electrical Residential 0.9193% 2,611,705.31 $ 0.06000 $ 0.02720 $ 0.08720 $ 227,740.70 Electrical Small General Service 3.3431% 9,497,909.82 $ 0.06000 $ 0.03110 $ 0.09110 $ 865,259.58 Electrical Small General Service 2.6709% 7,587,943.43 $ 0.06000 $ 0.02550 $ 0.08550 $ 648,769.16 Electrical Large General Service 27.8994% 79,262,498.64 $ 0.06000 $ 0.01370 $ 0.07370 $ 5,841,646.15 Electric Large Industrial 47.4155% 134,707,856.05 $ 0.06000 $ 0.00100 $ 0.06100 $ 8,217,179.22 $ 8,217,179.22 100.0000% 284,100,710.45 284,100,710.45 $ 20,198,334.74 Predicted Sales for 2019 = 284,100,710 $ 579,330.00 Large General Demand $ 1,333,751.60 2019 $ 1,826,659.80 Annual Revenue Annual Revenue Capacity Sales $ 675,500.00 Sales for Resale $ 1,232,320.00 Total Revenue ected $ 25,845,896.14 Allocation % KWHR Allocations to be used in 2019 % Alocation KWHR Sates 2019 % Allocation KWHR Sales 2020 KWHR Rate Large General Demand Extension Rate Extension Extension $ 20,198,334.74 Energy Cost Mark-up KWHR Rate Energy Cost Electrical Residential 17.7517% 50,432,797.19 $ 0.06000 S 0.02720 $ 0.08720 $ 4,397,739.92 All Electrical Residential 0.9193% 2,611.705.31 $ 0.06000 S 0.02720 S 0.08720 S 227,740.70 Electrical Small General Service 3.3431% 9,497,909.82 $ 0.06000 S 0.03110 $ 0.09110 $ 865,259.58 Electrical Small General Service 2.6709% 7,587,943.43 $ 0.06000 $ 0.02550 S 0.08550 S 648,769.16 Electrical Large General Service 27.8994% 79,262,498.64 $ 0.06000 $ 0.01370 $ 0.07370 S 5,841,646.15 Electric Large Industrial 47.4155% 134,707,856.05 S 0.06000 $ 0.00100 $ 0.06100 $ 6,217,179.22 $ 5,841,646.15 100.0000% 284,100,710.45 134,707,856.05 $ 0.06000 $ $ 20,198,334.74 Predicted Sales for 2020 = 284,100,710 $ 579,330.00 Large General Demand $ 1,333,751.60 2020 $ 1,826,659.80 KWHR Sales Annual Revenue Capacity Sales $ 675,500.00 Sales for Resale $ 1,232,320.00 Total Revenue ected $ 25,845,896.14 Add in Roadway Lighting: $ 147,384.02 Allocation % KWHR Albcabons to be used in 2020 % Allocation KWHR Sales 2020 $ 579,330.00 Large General Demand KWHR Rate Extension Extension $ 20,198,334.74 Capacity Sales $ 1,004,500.00 Energy Cost Energy Cost Ma rf< no _Mark-up KWHR Rate Electrical Residential Electrical Residential 17.7517% 50,432,797.19 $ 0.06000 $ 0.02720 $ 0.08720 $ 4,397,739.92 All Electrical Residential 0.9193% 2,611,705.31 $ 0.06000 S 0.02720 $ 0.08720 $ 227,740.70 Electrical Small General Service 3.3431% 9,497,909.82 $ 0.06000 S 0.03110 $ 0.09110 $ 865,259.58 Electrical Small General Service 2.6709% 7,587,943.43 $ 0.06000 S 0.02550 $ 0.08550 $ 648,769.16 Electrical Large General Service 27.8994% 79,262,498.64 $ 0.06000 $ 0.01370 $ 0.07370 $ 5,841,646.15 Electric Large Industrial 47.4155% 134,707,856.05 $ 0.06000 $ 0.00100 $ 0.06100 $ 8,217,179.22 100.0000% 100.0000% 284,100,710.45 $ 20,198,334.74 $ 20,198,334.74 Predicted Sales for 2021 = 284,100,710 $ 579,330.00 Large General Demand $ 1,333,751.60 2021 $ 1,826,659.80 KWHR Sales AnnualRevenue Capacity Sales $ 675,500.00 Sales for Resale $ 1,232,320.00 Total Revenue ected $ 25,845,896.14 Add in Roadway Lighting: $ 147,384.02 Allocation % KWHR Allocations to be used in 2021 % Allocation KWHR Saks 2021 $ 579,330.00 Large General Demand KWHR Rate Industrial Demand Extension KWHR Sales $ 20,198,334.74 Capacity Sales $ 1,004,500.00 Energy Cost $ 1,232.320.00 Ma rf< no KWHR Rate Add in Roadway Lighting: Electrical Residential 17.7517% 50,432,797.19 $ 0.06000 $ 0.02720 $ 0.08720 $ 4,397,739.92 All Electrical Residential 0.9193% 2,611.705.31 $ 0.06000 $ 0.02720 $ 0.08720 $ 227,740.70 Electrical Small General Service 3.3431% 9,497,909.82 $ 0.06000 $ 0.03110 $ 0.09110 $ 865,259.58 Electrical Small General Service 2.6709% 7,587,943.43 $ 0.06000 $ 0.02550 $ 0.08550 $ 648,769.16 Electrical Large General Service 27.8994% 79,262,498.64 $ 0.06000 $ 0.01370 $ 0.07370 $ 5,841,646.15 Electric Large Industrial 47.4155% 134,707.856.05 $ 0.06000 $ 0.00100 $ 0.06100 S 8.217,179.22 100.0000% 284,100,710.45 $ 20,198,334.74 Total Revenue projected 2017 Meter Charge $ 579,330.00 Large General Demand $ 1,333,751.60 Industrial Demand $ 1,826,659.80 KWHR Sales S 20,198,334.74 Capacity Sales $ 675,500.00 Sales for Resale $ 1,232,320.00 Total Revenue ected $ 25,845,896.14 Add in Roadway Lighting: $ 147,384.02 Retail Op. Revenue $ 23,938,076.14 Total Revenue oroiected 2018 Meter Charge $ 579,330.00 Large General Demand $ 1,333,751.60 Industrial Demand $ 1,826,659.80 KWHR Sales $ 20,198,334.74 Capacity Sales $ 1,004,500.00 Sales for Resale $ 1,232.320.00 Total Revenue pro ected $ 26,174,896.14 Add in Roadway Lighting: $ 150,331.70 Retail Op. Revenue $ 23,938,076.14 Total Revenue projected 2019 Meter Charge $ 579,330.00 Large General Demand $ 1,333,751.60 Industrial Demand S 1,826,659.80 KWHR Sales $ 20,198,334.74 Capacity Sales S 1,292,000.00 Sales for Resale $ 1,232,320.00 Total Revenue ected $ 26,462,396.14 Add in Roadway Lighting: S 153,338.33 Retail Op. Revenue $ 23,938076.14 Total Revenue protected 2020 Meter Charge S 579,330.00 Large General Demand $ 1,333,751.60 Industrial Demand S 1,826,659.80 KWHR Sales $ 20,198,334.74 Capacity Sales $ 1,532,000.00 Sales for Resale $ 1,232,320.00 Total Revenue 'ected $ 26,702,396.14 Add in Roadway Ligftirg: $ 156,405.10 Retail Op. Revenue $ 23,938,076.14 Total Revenue proiected 2021 Meter Charge $ 579,330.00 Large General Demand S 1,333,751.60 Industrial Demand $ 1,826,659.80 KWHR Sales $ 20.198,334.74 Capacity Sates $ 680,000.00 Sates for Resale $ 1,232,320.00 Total Revenueprojected $ 25,850,396.14 Add in Roadway Lighting: $ 159,533.20 Retail Op. Revenue $ 23,938,076.14 Updated 7114/16 2016 St. light Inve tory in use - 2017 Budget Feb 6023 Mar 6361 Total KWHR Use 70,535 Apr Total Street Total Annual Cost for Street Fixture lYpe Input Wattage Average hours of use per day Days per Year Total number Total O & M Liaht Energy Cost (Annual) Cost (Annual) $ 1,776.50 $ 650.43 and Wattage of units 55 Lighting $ 2,426.93 100 LED 0.05 12 365 100 HPS 0.118 12 365 98 $ 3,165.40 $ 2,735.12 $ 5,900.52 150 HPS 0.179 12 365 1687 $ 54,490.10 $ 71,422.65 $ 125,912.75 250 HPS 0.295 12 365 107 $ 3,456.10 $ 7,465.75 $ 10,921.85 400 HPS 0.465 12 365 2 $ 64.60 $ 219.96 $ 284.56 175 MV 0.214 12 365 5 $ 161.50 $ 253.08 $ 414.58 250 MV 0.294 12 365 0 $ - $ - $ - 400 MV 0.459 12 365 1 $ 32.30 $ 108.56 $ 140.86 Total Costs for Lighting 1,900 $ 61,370.00 1 $ 82,205.13 $ 143 575.13 Energy Cost per KWHR $ 0.0540 Annual O & M cost per unit, based on RW Beck Study, this includes the carrying cost for inventory $ 32.30 Jan 6093 Feb 6023 Mar 6361 Total KWHR Use 70,535 Apr 5116 Energy Rate $ 0.0540 May 5766 Annual Energy Charge $ 3,808.89 June 6125 July 5484 August 5409 Sept 5402 Fees associated with relamping the signal lights Oct 5812 are relatively minor, as a consequence, they are Nov 6027 included in with the energy charges. Dec 6917 Rate Schedule for Lighting, er unit, per month Type Energy Charge 0& M Charge Total 100-150 HPS $ 3.64 $ 2.69 $ 6.33 250 HPS $ 6.00 $ 2.69 $ 8.69 400 HPS $ 9.45 $ 2.69 $ 12.15 175 MV $ 4.35 $ 2.69 $ 7.04 250 MV $ 5.98 $ 2.69 $ 8.67 400 MV $ 9.33 $ 2.69 $ 12.02 Total Charge for Signal Lighting and Roadway Lighting $ 147,364.02 (1) This informaiton comes from usage information not included in the Transaction Recap Reports Legend MW: 20 30 35 40 MW: 5 30 35 40 45 Capacity Sales: 2013-2025 Contract 2 Contract 3 - SMMPA Contract 4 - AEP 2013 2014 21 5 20 16 2017 2018 2019 2020 2019 2020 2021 2022 2023 2024 2025 Jan $ $16,000.00 $ $ 42,000.00 $ 66,500 00 $ 96,000.0C $ 116,000 00 $ 136.000.00 $ $ 6,750.00 $ 146,250 00 I $ 146,250.00 $ 146,250.00 $ 146,250.00 $ 146,250 00 Feb $ $16,000.00 $ $ 42,000.00 $ 66,500 00 $ 96,000.00 $ 116,000-00 $ 3,36.000.00 $ $ 6,750.00 $ 146,250.00 $ 146,250.00 $ 146,250.00 $ 146,250.00 $ 146,250.00 Mar $ $ 16,000.00 $ $ 42,000.00 $ 66,500 00 $ 96,000.00 $ 116,000.00 5 136,000.00 $ $ 6.750.00 $ 146,250.00 $ 146,250.00 $ 146,250.00 $ 146,250.00 $ 146,250.00 Apr May $ - $ $ 16,000.00 16600DOO $ $ $ 42,000.00 $__42,D0_0.00 $ 66,500 00 $ 66,500.00 $ 16,000.00 96,000-00 $ 116,000.00 $ 116,00000 $ 136.00000 $ 136,00000 $ - $ $ 6,750.00 $ 6,750.00 $ 146,250.00 $ 146,250.00 $ 146,250.00 $ 146,250.00 $ 146,250.00 $ 146,250.00 $ 146,250.00 $ 146,250.00 i $ 146,2S0.00 $ 146,250.00 $ 16,000.00 $ $ 42,000.00 $ 66,500.00 $ 96000.00 $ 136,000.00 $ 136,000.00 $ Jun $ 6.750.00 $ 146,250.00 $ 146,250.00 $ 146,250.00 $ 146,250.00 $ 146,250.00 $ Jul $ 16,000.00 $ $ 42,000.00 $ 66,500.00 $ 96,000.00 $ 116,000.00 $ 196,000.00 $ $ 6,750.00 $ 146,250 00 $ 146,250.00 $ 146,250 00 $ 146,250.00 $ 146,250 00 $ Aug $ 16,000.00 $ $ 42,000.00 $ 66,500.00 $ 96,000:00 $ 116,000.00 $ 136.000. D0 $ $ 6,750.00 $ 146,250 00 $ 146,250 00 $ 146,250.00 $ 146,250.00 $ 146,250 00 $ Sep $ 16,000.00 $ $ 42,000.00 $ 66,500 00 $ 96,000.00 $ 116,000.00 $ 136MOD $ $ 6,750.00 $ 146,250.00 $ 146,250.00 $ 146,250.00 $ 146,250.00 $ 146,250 00 $ Oct $ 16,000.(x1 $ $ 42,000.00 $ 66,500 00 $ 96,000 00 $ 116,13MOD $ 136,000.00 5 $ 6,750.00 $ 146,250 00 $ 146,250.00 $ 146,250.00 $ 146,250.00 $ 146,250 00 $ Nov $ 16,00000 $ $ 42,000.00 $ 66,50000 $ 96,000.00 $ 116,000.00 $ 136.000.00 $ $ 6,750.00 j $ 146,250.00 $ 146,250.00 1 $ 146,250.00 $ 146,250.00 $ 146,250-00 $ Dec $ 16,000.00 $ $ 42,000.00 $ 66,50000 $ 96,000.00 $ 116,000M $ 136,000(x? $ $ 6,750.00 $ 146,250.00 $ 146,250.00 $ 146,250.00 $ 146,250.00 , $ 146,250.00 $ $ 112,000.00 $ 80,000.00 $ 294,000.00 $ 675,500.00 ; $ 1,004,500.00 $ 1,292,000.00 $ 1,532,D00.00 $ 680,000.00 $ 47,250.00 $ 1,057,500.00 $ 1,755,000.00 $ 1,755,000.00 $ 1,755,000.00 I $ 1,755,000.00 1 $ 731,250.00 Legend MW: 20 30 35 40 MW: 5 30 35 40 45 Electric Division Operating Expenses $28,612,426 2017 ELECTRIC BUDGETED EXPENSES Depreciation, $2,800,000_ pilot/Roadway Lighting, Transmission, $2,550,000 , 10% $829,200, 3% 9% CIP Program, $314,000, I 1% Operating Materials, $383,782, 1% Operating Expenses, $926,651, 3% `Personnel Costs, $4,727,137, 16% 1 Fuel/Chem./Lubricants, Purchased Power, $1,901,501, 7% $14,208,043, WA Market Purchases Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Market Purchases LMP Expense ; $/MWHR Market Purchases $ Forecasted PU $/MWHR Purchases off rket-2017 5 2011 Power Supply Expenses -Sales + System Losses -expected expense for 2017 1,384 2,800 Sales System Losses Power Supply Units 2,326 Jan 22,982 3.20% 23,717 Feb 21,663 3.20% 22,356 Mar 22,585 3.20% 23,308 Apr 22,140 3.20% 22,848 May 22,217 3.20% 22,928 Jun 25,153 3.20% 25,958 Jul 28,378 3.20% 29,286 Aug 28,088 3.20% 28,986 Sep 24,591 3.20Yo 25,378 Oct 22,746 3.20% 23,474 Nov 20,983 3.20% 21,654 Dec 22,577 3.20% 23,299 284,101 293,192 Market Purchases Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Market Purchases LMP Expense ; $/MWHR Market Purchases $ Forecasted PU $/MWHR Purchases off rket-2017 5 2011 2012 3,239 1,384 2,800 1,888 3,061 2,326 2,115 1,778 3,296 3,351 5,263 6,003 8,632 8,569 6,869 5,952 3,225 2,303 1,967 1,958 1,398 1,676 1,821 1,516 _ 43,686 38,704 43,686 38,704 1,574,270.33 $ 1,176,579.05 36.04 $ 30.40 $ 2013 2014 2015 2016 3,434 3,466 4,349 4,224 4,371 5,120 5,611 4,700 4,179 5,051 5,034 5,038 3,197 3,860 4,417 4,787 3,977 4,055 5,720 5,070 5,462 6,195 7,647 7,045 5,681 6,436 8,607 6,581 5,449 6,819 8,670 7,022 4,009 5,578 8,247 5,994 3,453 4,446 5,976 4,346 3,484 4,166 5,001 3,897 4,650 5,055 - 50,593 59,842 74,334 54,807 50,593 59,842 74,334 54,807 1,623,777.34 2,040,035.49 1,785,487.06 1,220,299.78 32.09 $ 34.09 $ 24.02 $ 22.27 28.57 *Market Purchases come from Econ Data sheets In MWHR Forecast MRES MWHR Supply Agreement MWHR Market Purchases MWHR Hedged Generation 293,192 219,000 62,392 11,800 74.70% 21.28% 4.02% $ 11,994,630.00 $ 1,782,785.49 Power Expense - $ 13,777,415.49 MWHR $ USED MWHR NEEDED POWER SUPPLY BUDGET MRES - supplied power $ 54.77 $ 219,000 11,994,630.00 MRES - system loss power purchased $ 54.77 $ 7,008 383,828.16 MARKET PURCHASES $ 28.57 $ 62,392 1,782,785.49 MCG ENERGY SOLUTIONS $ - $ - 46,800.00 TOTAL Power Purchased 288,399.93 = L7 2017 FUEL EXPENSE BUDGET- GENERATION Generated for Hedging Unit MWHR's MCF Needed MWHR's MCF MCF Needed Total Fuel Price # 5 3,500 30,800 $ 3.83 $ 117,964 # 3 1000 10,000 $ 3.83 $ 38,300 # 4 1000 10,000 $ 3.83 $ 38,300 # 8 6,300 63,000 $ 2.595 $ 163,485 Total 11,800 113,800 $ - $ 358,049 * Unit #8 has contracted gas at $2.595 per/MCF Generated for Sales Unit Heat Rate MWHR's MCF Needed MCF Total Fuel Price # 5 8.8 500 4,400 $ 3.83 $ 16,852.00 # 3 10 - - $ 3.83 $ - # 4 10 - - $ 3.83 $ - # 1 10 18,000 180,000 $ 3.83 $ 689,400.00 18,500 184,400 $ 706,252.00 Total Unit Fuel Expenses ( Hedging Hefting & Sales to Resales Sales For Resale Activity) Total Fuel Expense # 1 $ - $ 689,400.00 $ 689,400.00 # 3 $ 38,300.00 $ - $ 38,300.00 # 4 $ 38,300.00 $ - $ 38,300.00 # 5 $ 117,964.00 $ 16,852.00 $ 134,816.00 # 8 $ 163,485.00 $ - $ 163,485.00 Total Expense: $ 358,049.00 $ 706,252.00 $ 1,064,301.00 Hutchinson, MN MRES Purchased Power Costs for 2017 Total 309,600 226,008,000 $ 4,489,200 $ 99,072 $ 7,119,252 $ (22,601) $ 11,684,923 $ 678,024 $ 14,960 $ 12,377,907 54.77 0.0% -0.3% 3.6% 3.0% -0.3% 4.1% -0.3% 1.3% 3.9% 4.1% ) 2017 Mb$ouri Rhrer Demand Energy Demand MISO Capacity Energy Ancillary Services Subtotal Rate Dues Cost Ave Month (kW) kWh Cost Co M Credit Credit 61 Adder Adder I$) ($) (m) Jan -17 25,800 19,195,200 $ 412,800 S 8,256 $ 604,649 S (1,920) $ 1,023,785 $ 57,586 $ 1,236 $ 1,082,607 56.40 Feb -17 25,800 17,337,600 $ 412,800 $ 8,256 $ 546,134 $ (1,734) $ 965,4S7 $ 52,013 $ 1,130 $ 1,018,599 58.75 Mar -17 25,800 19,195,200 $ 270,900 $ 8,256 $ 604,649 $ (1,920) $ 881,885 $ 57,586 $ 1,215 $ 940,686 49.01 Apr -17 25,800 18,576,000 $ 270,900 $ 8,256 $ 585,144 $ (1,858) S 862,442 5 55,728 $ 1,145 $ 919,315 4949 May -17 25,800 19,195,200 $ 270,900 $ 8,256 $ 604,649 $ (1,920) $ 881,885 $ 57,586 $ 1,230 $ 940,701 49.01 Jun -17 25,800 18,576,000 $ S41,800 $ 8,256 $ 585,144 $ (1,858) $ 1,133,342 $ 55,728 $ 1,345 $ 1,190,415 64.08 Jul -17 25,800 19,195,200 $ 541,800 $ 8,256 $ 604,649 $ (1,920) $ 1,152,785 S 57,586 S 1,533 $ 1,211,904 63.14 Aug -17 25,800 19,195,200 $ 541,800 $ 8,256 $ 604,649 $ (1,920) $ 1,152,785 $ 57,586 $ 1,461 $ 1,211,832 63.13 Sep -17 25,800 18,576,000 $ 270,900 $ 8,256 $ 585,144 $ (1,858) $ 862,442 $ 55,728 $ 1,193 $ 919,363 49.49 Oct -17 25,800 19,195,200 $ 270,900 $ 8,256 $ 604,649 $ (1,920) $ 881,885 $ 57,586 $ 1,175 $ 940,646 49.00 Nov -17 25,800 18,576,000 $ 270,900 $ 8,256 $ 5B5,144 $ (1,858) $ 862,442 $ 55,728 $ 1,116 $ 919,286 49.49 Dec -17 25.800 19,195,200 $ 412,800 $ 8,256 $ 604,649 5 (1,920) $ 1,023,785 $ 57,586 $ 1,181 $ 1,082,552 56.40 Total 309,600 226,008,000 $ 4,489,200 $ 99,072 $ 7,119,252 $ (22,601) $ 11,684,923 $ 678,024 $ 14,960 $ 12,377,907 54.77 0.0% -0.3% 3.6% 3.0% -0.3% 4.1% -0.3% 1.3% 3.9% 4.1% All rates and load forecasts are subject to change. The rates used In the projections are based on the current available information for each specific rate as shown in the Area Meeting padcet The MRE5 credit for Ancillary Services is $0.10 per MWh. The Rate Adder is $3.00 per MWh. Please contact Tun Miller at MRES with any questions regarding the projections. Average cost by season (millsAwh) Dec. -Feb. 57.1 March -May 49.2 June -Aug. 63.4 Sep. -Nov. 49.3 Average cost by season (mlllsAWh Dec. -Feb. 5S.1 March -May 46.7 June -Aug. 61.7 Sep. -Nov. 46.9 2016 Missouri River Demand Energy Demand MISO Capacity Energy Ancillary Services Subtotal Rate Dues Cost Ave Month kW (kWh) Cost Cost M Credit M Adder (S) ($) Im) Jan -16 25,800 19,195,200 $ 406,350 $ $ 585,454 $ (1,920) $ 989,884 $ 57,586 $ 1,227 $ 1,048,697 54.63 Feb -16 25,800 17,956,800 $ 406,350 $ $ S47,682 $ (1,796) $ 952,237 $ 53,870 $ 1,129 $ 1,007,236 56.09 Mar -16 25,800 19,195,200 $ 251,550 $ S 585,454 $ (1,920) $ 835,084 $ 57,586 $ 1,179 $ 893,849 46.57 Apr -16 25,800 18,576,000 $ 251,550 $ S S66,568 $ (1,858) $ 816,260 $ 55,728 $ 1,130 $ 873,118 47.00 May -16 25,800 19,195,200 $ 251,550 $ $ 585,454 $ (1,920) $ 835,084 $ 57,586 $ 1,167 $ 893,837 46.57 Jun -16 25,800 18,576,000 $ 535,350 $ $ 566,568 $ (1,858) $ 1,100,060 $ 55,728 $ 1,348 $ 1,157,136 62.29 Jul -16 25,800 19,195,200 $ 535,350 $ $ 585,454 $ (1,920) $ 1,118,884 $ 57,586 $ 1,426 $ 1,177,896 61.36 Aug -16 25,800 19,195,200 $ 535,350 $ $ 585,454 $ (1,920) $ 1,118,884 $ 57,586 S 1,496 $ 1,177,966 61.37 Sep -16 25,800 18,576,000 $ 251,550 $ $ 566,568 $ (1,858) $ 816,260 $ 55,728 $ 1,235 $ 873,223 47.01 Oct -16 25,800 19,195,200 $ 251,SS0 $ $ 585,454 $ (1,920) $ 835,084 $ 57,586 $ 1,161 $ 893,831 46.57 Nov -16 25,800 18,576,000 $ 251,550 $ $ 566,568 $ (1,858) $ 816,260 $ 55,728 5 1,103 $ 873,091 47.00 Dec -16 25.800 19.195,200 $ 406,350 $ $ 585,454 $ (1,920) $ 989,884 $ 57,586 5 1,167 $ 1,048,637 54.63 Total 309,600 226,627,200 $ 4,334,400 $ $ 6,912,130 $ (22,663) $ 11,223,867 $ 679,882 $ 14,768 $ 11,918,516 52.59 All rates and load forecasts are subject to change. The rates used In the projections are based on the current available information for each specific rate as shown in the Area Meeting padcet The MRE5 credit for Ancillary Services is $0.10 per MWh. The Rate Adder is $3.00 per MWh. Please contact Tun Miller at MRES with any questions regarding the projections. Average cost by season (millsAwh) Dec. -Feb. 57.1 March -May 49.2 June -Aug. 63.4 Sep. -Nov. 49.3 Average cost by season (mlllsAWh Dec. -Feb. 5S.1 March -May 46.7 June -Aug. 61.7 Sep. -Nov. 46.9 2012 BU GET NATURAL GAS Detailed Income Statement Gas Division 2013 Actual 1 2014 Actual 1 2015 Actual 1 2015 Budget 2016 Budget 1 2017 Budget OPERATING REVENUES Sales - Natural Gas -Retail Contract Sales to Large Customers (Includes 3M 8 HTI transport) New Ulm Transportation Transportation -Electric Division 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 Adminstrabve and General Labor (920) Office Supplies and Expenses (921) Outside Services (923) Property Insurance (924) Employee Pension 8 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 Lleu of Taxes (408) Total Other Expenses (403, 408) TOTAL OPERATING EXPENSES $ 8,356,513 $ 8,559,893 $ 6,812,881 $ 7,980.628 $ 8,612,023 $ 8.357,151 $ 3,646.509 $ 6,066,290 $ 3,110,620 $ 4,034,279 $ 3.578,643 $ 3,200,440 $ 785,149 $ 808,575 $ 776,164 $ 725,100 $ 730,636 $ 734,878 $ 1,100,000 $ 700,000 $ 641,833 $ 641,833 $ 647,166 $ 651,700 $ 13,888,170 $ 16,134,757 $ 11,341,498 $ 13,381,840 $ 13,568,468 $ 12,944,169 $ 4,549,969 $ 5,385,632 $ 3,545.049 $ 4,064,314 $ 4,161,898 $ 4,102,910 $ 2,950,652 $ 5,074,637 $ 2,443,772 $ 3,516,110 $ 3,052,857 $ 2,679,314 $ 7,500,621 $ 10,460,268 $ 5,988,821 $ 7,580,424 $ 7,214,755 $ 6,782,224 $ 114,377 $ 106,984 $ 115,115 $ 163,151 $ 163,760 $ 165,464 $ 4,001 $ 23,535 $ 4,337 S 18,018 $ 10,171 $ 10,241 $ 118,378 $ 130,520 $ 119,452 $ 181,169 $ 173,931 $ 175,705 $ 161,338 $ 145,915 $ 166,328 $ 370,308 $ 358,088 $ 356,441 $ 76,123 $ 104,425 $ 87,715 $ 93,799 $ 109,692 $ 112,864 $ 240 $ 2,921 $ 9,497 $ 759 $ 835 $ 871 $ 168,179 $ 184,837 $ 159,849 $ 175,552 $ 131,631 S 137,054 $ 405,879 $ 438,098 $ 423,389 $ 640,419 $ 600,246 $ 607,230 $ 126,902 $ 99,918 $ 156,591 $ 166,270 $ 148,837 $ 159,657 $ 9,932 $ 22,554 $ 9.322 $ 13,807 $ 24,228 $ 25,251 $ 47,403 $ 53,973 $ 49,641 $ 169.240 $ 188,250 $ 195,159 $ 184,237 $ 176,445 $ 215,554 $ 349,318 $ 361,315 $ 380,067 $ 15,377 $ 14,034 $ 19,029 $ 17,270 $ 17,453 $ 8,477 $ 104,391 $ 94,356 $ 124,394 $ 144,048 $ 152,259 $ 171,545 $ 4,148 $ 8,898 $ 3,811 $ 6,750 $ 6,750 $ 4,500 $ 32,940 $ 38,689 $ 40.514 $ 43,647 $ 45,556 $ 47,519 $ 156,856 $ 155,976 $ 187,748 $ 211,715 $ 222,020 $ 232,041 $ 1,895 $ 1,670 $ - $ - $ - $ - $ 64,019 $ 113,212 $ 73,656 $ 228,170 $ 179,806 $ 183,710 $ 65,913 $ 114,882 $ 73,656 $ 228,170 $ 179,806 $ 183,710 $ 173,463 $ 155,708 $ 155,341 $ 151,726 $ 139,183 $ 146,353 $ 93,858 $ 84,728 $ 82,789 $ 74,100 $ 74,250 $ 107,555 $ 49,282 $ 36,589 $ 35,353 $ 37,644 $ 26,769 $ 36,769 $ 83,874 $ 75,057 $ 72,711 $ 70.000 $ 70,000 $ 58,800 $ 413,595 $ 422,137 $ 451,860 $ 70,902 $ 63,045 $ 66,653 $ 19,620 S 19.886 $ 19,082 $ 20,000 $ 20,000 $ 20,000 $ 77,753 S 71,584 $ 55 594 $ 70,758 $ 79,758 $ 68,558 $ 58,141 $ 52,160 $ 38,052 $ 31,907 $ 31,233 $ 31,228 $ 969,586 $ 917,849 $ 910,782 $ 527,036 $ 504,237 $ 535,915 $ 1,027,662 $ 1,002,804 $ 1,078,133 $ 1,056,000 $ 1,056,000 $ 1,008,000 $ 491,077 $ 605,176 $ 206.980 $ 206,980 $ 406,252 $ 367,131 $ 1,518,739 $ 1,607,980 $ 1,215,113 $ 1,262,980 $ 1,462,252 $ 1,375,131 $ 10,920,209 $ 14,002,017 $ 9,134,516 $ 10,981,229 $ 10,718,563 $ 10,272,023 OPERATING INCOME (LOSS) $ 2,967,961 $ 2,132,740 $ 2,206,982 $ 2,400,611 $ 2,849,906 $ 2,672,146 new-Q0gcnrcnacal Merchandise g Contract Work, Net Interest Income Misc. income Bond Premium Misc. Expense Interest Expense - Bonds Interest Expense - Customer Deposits Gain (Loss) On Disposal Amortization of Bond Discount and Issuance Costs Amortization—Development Study TOTAL NONOPERATING REVENUESIEXPENSES NET INCOME COGS Gross Prorn Gross Margin Operating Margin (%) Net Income (%) of Operating Sales Net Income (%) of Operating Sales (after cap labor & FCA) Detailed Income Statement Gas Division 2013 Actual 1 2014 Actual 1 2015 Actual 1 2015 Budget 1 2016 Budget 1 2017 Budget $ 57,400 $ 31,269 $ 56,008 $ 27,000 $ 27,000 $ 33,000 $ 37,970 $ 14,860 $ 15,978 $ 32,500 $ 57,500 $ 50,000 $ 1,008 5,235 $ 28,316 $ - $ - $ $ 185,608 $ 185,608 $ 185,608 $ 185,608 $ 185,608 $ 185,608 $ - $ - $ • 5 $ - $ $ (1,271,801) $ (864,000) $ (821,833) $ (825,500) $ (781,500) $ (735,100) $ (2,346) $ (434) $ (96) $ (1,000.00) $ (200) $ (100) $ $ 22,100 $ - $ $ $ - $ $ $ $ $ $ $ (992,161) $ (605,361) $ (536,020) $ (581,392) $ (511,592) $ (466,592) $ 1,975,600 $ 1,527,378 $ 1,670,962 $ 1,819,219 $ 2,338,314 $ 2,205,554 $ 7,618,999 $ 10,590,788 $ 6,108,273 $ 7,761,593 $ 7,388,686 $ 6,957,929 $ 6,269,171 $ 5,543,970 $ 5,233,225 $ 5,620,247 $ 6,179,782 $ 5,986,240 45% 34% 46% 42% 46% 46% 219 13% 19% 18% 21% 21% 14% 9% 15% 14% 17% 17% 14% 17% 18% NET INCOME WITH ADJUSTMENTS 2017 Net Income $ 2,205,554 Capitalized Labor- Natural Gas $ 67,000 2017 Net Income $ 2,272,554 CASH FLOW STATEMENT 2017 Net Income $ 2,205,554 Depreciation $ 1,008,000 2017 Cap Exp $ (1,350,000) 2017 Cap Exp Reimbursed $ 215,000 2012A Principal $ (1,220,000) 2017 Gas Cash Flow $ 858,554 2017 Cap Exp (As necessary) I, $ 1001000 $18,000,000 $16,000,000 $14,000,000 $12,000,000 $10,000,000 $8,000,000 $6►000►000 $4,000,000 $2,000,000 Gas Division Operating Revenues Industrial, $3,200,440, 24% Commercial, $3,8 29% 2017 GAS BUDGETED REVENUES Electric Transfer, $651700 5% Other Revenues, $33,000 ,' New Ulm, $734,878, 6% �'0% Interest Earnings, j $50,000,0% -----Bond Premium, $185,608 ,2% esidential, $4,474,618, 34% Natural Gas Sales Volumes by Customer Class in MCF (Top Table) and Sales by Customer Class in Percent (Bottom Table) Residential 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 464,345 4" 143 475,703 499,621 448,368 428,775 431,480 442.775 483,752 444,371 417,391 434,537 364,652 470,578 475.387 387,205 Commercial 399601 406,659 422,202 430,071 382,785 366,548 381,519 388,223 445,484 420,842 400,221 399,781 325.027 392,469 401,727 295,186 Large lndustnal -Ohly 82.402 79,941 82,173 90.772 89,918 112.884 78.589 132,447 143.877 117,920 - - - - - 52.806 UFC - Contract 4,738 7,781 Brownton - Contract 31% 31% 30% 31% 28% 29% 35% 40% 37% 40% 45% 44% 46% 42% 22,594 18,701 3M - Contract 420,748 425,264 416,627 453,160 362,898 376.111 482,606 636,986 633,075 652,338 742,444 729,898 656,281 671,649 711,378 653,447 HTI- Contract 117,920 97,701 91,431 74.353 82.059 94,373 79,017 System Load Iorchrde 3M d HT) 946.348 930,743 980,078 1,020,664 921,071 908.207 891,588 963.445 1,073,113 865,213 817,612 834,317 689,679 863,147 877,114 761,680 Total Load 1.367.096 1,356,007 1.396,705 1,473,824 1,283,969 1,284,318 1,374,194 1,600,431 1,706,188 1,635,471 1,657,757 1,655,646 1,420,313 1,616,855 1,682,865 1,494,144 -0.81%. 3.00% 5.52% .12.88% 0.03% 7.00% 1646%. 6.61% 4.14% 1.36% -0.13% -14.21:'. 13.84% 4.08% -11.21% Residenba 2000 2001 2002 2003 2004 Annual 2005 2006 Ratia Class 2007 an SyWem 2008 2009 2010 2011 2012 20.13 2014 2015 49'-. 48% 49% 49% 49% 47% 48". 46 45°: 51% 51% 52% 53% 55% 54% 50.84% Commerco, 42`6 44 ;'. 43% 42% 42% 40% 43% 40 *,/. 42% 49% 49% 48% 47% 45% 46% 38.75% Large Industrial - OHLY 9". 9% 8% 9% 10% 12% 9% 14% 13% 0% 0% 0% 0% 0% 0% 6.93% Large Industrial - UFC/Brownton 3.48% 3M using total load 31% 31% 30% 31% 28% 29% 35% 40% 37% 40% 45% 44% 46% 42% 42% 44% HTI usnig total bad 6% 6% 5% 5% 6% 5% 2017—Natural Gas Sales Lam Purchases 669.765 Forecasted FCAC - Transport[ Demand T $ Demand S Total S Purchases 700.577 3M Transport Agreement $ 0.6067 036 $ 900 $ 252,208 3 172,800 425.008 Purchases 86,259 HTI Transport Agreement $ 11143 $ 087 S 10.33 S 75.045 $ 21.073 $ 98.118 d Purchases 1,656,601 S 120.000 00 FM Transport $ 98,118 33 $ 334.424 68 S 430,543.01 3M Transport S 425.007.72 S 2.344 889.09 Sub Total Total System 1.164200.05 $10,393,392.02 System Gas Unit Sales Rite System Sales Add-in FCAC Sales klential 52% 449,582 3 908 4 0922 $ $ 4 D8220 mnerdel 39% 337,034 $ 9.08 3.060268 $ - $ 3,D60,268 rsbkai - only t t meter, 6% 52.882 $ 8.54 451.610 $ - $ 451.610 hstrial - UFC/Brovmto%n Contract 3% 30 $ 3.88 117.439 $ $ 117.439 100% _ 7 14-468 S 5 ,TU ZF Transport $ Demand $ HM Transport $ 75,045.33 $ 21,07300 3M Transport S 252,207.72 S 172.800 00 Commodity Cost - 3M S335 3M and HT1 commodity costs based on tonbacts b purchasing cost, pass through cost Corrroodity Cosi - HTI 53.88 Customer Charga/ iM Energy Charge Total Sales Residential $ 392,418.00 S 4.082,200.28 S 4.474.61828 Commercial $ 208.656 00 $ 3,060268.15 S 3.268,924 15 trdustft - 0" $ 42,000 DO $ 451.609.82 $ 493,609 62 Industrial - UFC4Brohntown Contract S . S 120.000 00 S 120.000 00 FM Transport $ 98,118 33 $ 334.424 68 S 430,543.01 3M Transport S 425.007.72 S 2.344 889.09 $ 2.769.898.81 Total Sales 1.164200.05 $10,393,392.02 $ 11.557592 07 System Total Sales S 643.074.00 $ 7.714.07825 $ 8.357 15225 Gas Division Number of Meters Small Large Commercial Industrial Industrial Year Residential Firm Firm Firm Interruptible Total 1990 3335 460 0 3 18 3816 1991 3327 432 0 3 12 3774 1992 3367 486 0 3 11 3867 1993 3489 446 0 3 12 3950 1994 3572 452 0 3 12 4039 1995 3686 454 0 3 12 4155 1996 3742 474 0 3 10 4229 1997 3857 481 0 3 8 4349 1998 4029 462 0 2 7 4500 1999 4155 479 0 2 6 4642 2000 4254 482 0 2 6 4744 2001 4309 485 0 2 6 4802 2002 4382 498 0 2 6 4888 2003 4472 498 0 2 6 4978 2004 4557 494 0 2 6 5059 2005 4617 498 0 2 6 5123 2006 4700 506 0 2 1 5209 2007 4719 513 0 2 0 5234 2008 4809 488 0 2 0 5299 2009 4868 524 0 2 0 5394 2010 4918 525 0 2 0 5445 2011 4922 530 0 2 0 5454 2012 4941 526 0 3 0 5470 2013 4961 536 0 4 0 5501 2014 4984 549 0 4 0 5537 2015 5027 552 0 5 0 5584 2016 5031 552 0 5 0 5588 # of Meters Months Annualized Ext. Meter Charge Annual Revenue Residential Meters = 5,031 12 60,372 $ 6.50 $ 392,418 Commercial GS Meters = 552 12 6,624 $ 31.50 $ 208,656 2016 METER CHARGE REVENUE $ 601,074 Gas Division Operating Expenses Debt Interest, $735,100, 7% Purchased Gas, $6,782,224, 62% 2017 GAS BUDGETED EXPENSES Depreciation, $1,008,000 Pilot, $367,131, 3% ,9% t Operating Expenses, $419,255, 4% Operating Materials,' $276,913, 2% Personnel Costs, $1,278,092, 12% ' tCIP Program, $140,509, 1% 2017 ESTIMATED ENERGY CONSUMPTION !DTH'S) INCLUDES BROWNTON 2017 CONTRACT GAS DTH's 2017 SWING GAS DTH's 2017 HTI GAS DTH's 2017 3M GAS DTH's 2017 TOTAL GAS DTH's 2017 SYSTEM GAS DTH's 2016 HT1 & 3M GAS DTH'S JANUARY 108,504 51,175 1 2, _�32 88,296 260,009 159,679 100,330 FEBRUARY 100,800 36,759 10,587 79,073 227,219 137,559 89,660 MARCH 90,999 1 2,1 50 8,324 70,404 181,877 103,149 78,728 APRIL 52,497 13,447 6,055 59,334 131,333 65,944 65,389 MAY 30,798 3,565 5,063 48,340 87,766 34,363 53.403 JUNE 21,699 1,750 4,830 42,506 70,785 23,449 47,336 JULY 19.602 2,955 5,153 42,103 69,813 22,557 47,256 AUGUST 19,602 1,788 5,139 43,494 70.023 21,390 48,634 SEPTEMBER 20,997 1.692 4,851 42,093 69,633 22,689 46,944 OCTOBER 43,396 7,509 5.795 52,823 109,525 50.907 58,618 NOVEMBER 69,300 25,335 8,037 60,050 162,722 94,635 68,087 DECEMBER 95,904 37,540 10,392 72,060 215,895 133,444 82,451 $138,809 674,100 195,665 86,259 700,577 1,656,601 869,765 786,836 20'. 7 NATURAL GAS EXPENSE CONTRACT SWING GAS HT1 GAS 3M GAS 2017 TOTAL 2017 SYSTEM PER HM 3 TI & & 3M GAS $3.83 EXPENSE 2017 SYSTEM EXPENSE DTH EXPENSE EXPENSE JANUARY $ 539,927.96 $195,768 $46,058 $308,514 $1.090,268 $735,696 $4.61 $354,572 FEBRUARY $ 501,592.00 $140,622 $47,574 $325,326 $1,015,114 $642,214 $4.67 $372,899 MARCH $ 452,821 .14 $46,481 $43,292 $249,340 $791,934 $499,302 $4.84 $292,632 APRIL $ 261 ,230.91 $51.439 $20,640 $182,751 - $516,061 $312,670 $4.74 $203,391 MAY $ 1 53,254.27 $13,639 $17,112 $150.830 $334,634 $166,893 $4.86 $167,942 JUNE $ 107,976.64 $6,694 $16.493 $135.005 $266,168 $114,671 $4.89 $151,498 JULY $ 97,541 .73 $11,305 $18,589 $137,498 $264,934 $108,847 $4.83 $156,087 AUGUST $ 97,541.73 $6,838 $18.118 $138,809 $261,308 $104,380 $4.88 $156,927 SEPTEMBER $ 104,483.41 $6,474 $16,532 $133,524 $261,014 $110,958 $4.89 $150,057 OCTOBER $ 215,953.27 $28,725 $20,299 $166,928 $431,905 $244,678 $4.81 $187,227 NOVEMBER $ 344,844.50 $96,919 $28,643 $190,972 $661,378 $441.763 $4.67 $219.615 DECEMBER $ 477,228.96 $143,609 $41,075 $225.393 $887,306 $62,838 $4.65 $266,468 $3,354,397 $748,514 $334,424 $2,344,890 $6,782,224 $4,102,910 $4.72 $2,679,314 CONTRACT CONTRACT VOLUME 1 1 2 5 4 5 Q 7 $ 9 TOTAL CONTRACT VOLUMES JAN-'. 7 12,056 12,056 12,056 12,056 12.056 12.056 12,056 12,056 12.056 108,504 FEB -17 11.200 11.200 11.200 11,200 11.200 11,200 11,200 11,200 11,200 100,800 MAR -17 10,1 1 1 10,1 1 1 10,1 1 1 10,1 1 1 10.1 1 1 1 0,1 1 1 10.1 1 1 10.1 1 1 10,1 1 1 90,999 APR -17 5,833 5,833 5,833 5,833 5.833 5.833 5,833 5.833 5,833 52,497 MAY -17 3.422 3,422 3,422 3,422 3,422 3,422 3,422 3,422 3,422 30,798 JUN -17 2,411 2,411 2,411 2,411 2.411 2.411 2,411 2.411 2,411 21,699 JuL-17 2,178 2,178 2,178 2,178 2.178 2.178 2,178 2.178 2,178 19,602 AUG -17 2,178 2,178 2,178 2,178 2,178 2,178 2,178 2,176 2,178 19.602 SEP -l7 2,333 2,333 2,333 2,333 2.333 2,333 2,333 2,333 2,333 20,997 OCT -17 4,822 4,822 4,822 4,822 4,822 4,822 4,822 4,822 4,822 43,398 Nov -17 7,700 7,700 7,700 7,700 7,700 7,700 7,700 7,700 7,700 69,300 DEC -17 10,656 10,656 10,656 10,656 10,656 10,656 10,656 10,656 10,656 95,904 CONTRACT PRICE 1 2 a 4 5 5 7 $ 9 JAN -17 $5.0750 $5.0400 $5.3000 $5.2150 $4.9600 $4.7900 $4.5850 $5.0700 $4.7500 FEB -17 $5.0750 $5.0400 $5.3000 $5.2150 $4.9600 $4.7900 $4.5850 $5.0700 $4.7500 MAR -17 $5.0750 $5.0400 $5.3000 $5.2150 $4.9600 $4.7900 $4.5850 $5.0700 $4.7500 APR -17 $5.0750 $5.0400 $5.3000 $5.2150 $4.9600 $4.7900 $4.5850 $5.0700 $4.7500 MAY -17 $5.0750 $5.0400 $5.3000 $5.2150 $4.9600 $4.7900 $4.5850 $5.0700 $4.7500 JUN -17 $5.0750 $5.0400 $5.3000 $5.2150 $4.9600 $4.7900 $4.5850 $5.0700 $4.7500 JUL--17 $5.0750 $5.0400 $5.3000 $5.2150 $4.9600 $4.7900 $4.5850 $5.0700 $4.7500 AUG -17 $5.0750 $5.0400 $5.3000 $5.2150 $4.9600 $4.7900 $4.5850 $5.0700 $4.7500 SEP -17 $5.0750 $5.0400 $5.3000 $5.2150 $4.9600 $4.7900 $4.5850 $5.0700 $4.7500 OCT -17 $5.07511 $5.0400 $5.3000 $5.2150 $4.9600 $4.7900 $4.5850 $5.0700 $4.7500 Nov -17 $5.0750 $5.0400 $5.3000 $5.2150 $4.9600 $4.7900 $4.5850 $5.0700 $4.7500 DEC -17 $5.0750 $5.0400 $5.3000 $5.215C $4.9600 $4.7900 $4585-- $5.0700 $4.7500 CONTRACT PRICE EXTENSION 1 2 3 4 5 a 7 8 CONTRACT EXPENSE JAN -17 $61,184 $60,762 $63,897 $62,872 $59.798 $57,748 $55.277 $61.124 $57,266 $539,928 FEB -17 $56,840 $56,448 $59,360 $58,408 $55,552 $53,648 $51,352 $56,784 $53,200 $501,592 MAR -17 $51,313 $50,959 $53,588 $52,729 $50,151 $48,432 $46,359 $51,263 $48,027 $452,821 APR -17 $29,602 $29,398 $30,915 $30,419 $28,932 $27,940 $26,744 $29,573 $27,707 $261,231 MAY -17 $17,367 $17,247 $18,137 $17,846 $16,973 $16,391 $15,69; $17,350 $16,255 $153,254 JUN -17 $12,236 $12,151 $12,778 $12.573 $11,959 $11.549 $11.054 $12,224 $11,452 $107,977 JUL-17 $1 1,053 $10,977 $11,543 $11,35e $10,803 $10,433 $9,986 $11,042 $10,346 $97,542 AUG -17 $11,053 $10,977 $11,543 $11.35e $10,803 $10,433 $9,986 $11,042 $10,346 $97,542 SEP -17 $11.840 $11.758 $12,365 $12,167 $11,572 $1 1 ,175 $10,697 $11.828 $11.082 $104,483 OCT -17 $24,472 $24,303 $25,557 $25,147 $23,917 $23,097 $22,109 $24,448 $22,905 $215,953 Nov -17 $39,078 $38,808 $40,810 $40,156 $38,192 $36,883 $35,305 $39,039 $36,575 $344,845 DEC -17 $54,079 $53,706 $56,477 $55,571 $52,854 $51,042 $48,858 $54,026 $50,616 $477,229 2012 BUDGET GENERAL Account # i AccountDesoliptlon 2011 Actual 2012 Actual 2013 Actual 2014 Actual i 2015 Actual 2016 YTD (Posted as of 09/19/16) 2015 Budget 2016 Budget 2017 Budget REVENUES 400-440-0000 Residential Sales (Electric) (5,000,154.23) (4,972,886.41) (4,922,372.74) (4,905,669.45) (4,844,524.90) (3,442,750.55) (4,808,321.00) (4,785,539.00) (4,857,862.00) 400.440-0100 All Electric (255,178.37) (229,672.33) (254,116.31) (256,404.04) (236,439.40) (161,001.23) (243,414.00) (245,183.00) (247,709.00) 400-442-0000 Small General Service - Single (1,706,668.31) (1,723,012.51) (1,646,365.26) (1,612,427.75) (1,621,751.29) (1,170,801.34) (1,651,099.00) (1,581,216.00) (1,613,269.00) 400.442-0200 Large General Service (5,989,074.29) (6,135,021.91) (5,887,235.31) (5,836,007.77) (5,808,936.66) (3,768,952.81) (5,887,895.00) (5,744,159.00) (5,841,646.00) 400442-0300 Large General Service - Demand (1,380,068.19) (1,406,906.81) (1,369,484.20) (1,339,472.00) (1,332,402.92) (852,062.10) (1,330,488.00) (1,332,471.00) (1,333,752.00) 400-442-0400 Industrial (9,696,410.50) (8,934,797.94) (8,576,955.00) (9,165,996.42) (9,513,634.99) (6,272.030.54) (8,680,458.00) (8,686,229.00) (8,217,179.00) 400-442-0500 Industrial Demand (1,996,470.00) (1,828.960.00) (1,798,650.00) (1,835,400.00) (1,885,520.00) (1,267,770.00) (1,822,190.00) (1,824,906.00) (1,826,660.00) 400-444-0000 Street Lighting (143,377.73) (148,967.55) (143,001.71) (139,532.90) (146,930.97) (72,292.23) (146,739.00) (144,535.00) (147,384.00) 400447-0000 Sales For Resale (1,234,285.53) (1,618,582.46) (891,276.08) (678,293.49) (1,114,917.61) (1,273,893.73) (994,000.00) (1,907,820.00) (2,310,110.00) 400450-0000 Forfeited Discounts (30,906.03) (26,128.46) (28,689.96) (29,773.38) (27,567.01) (20,088.13) (25,000.00) (25,000.00) (25,000.00) 400450-0100 Collection Fee (21,520.00) (31,000.00) (29,960.00) (29,120.00) (27,280.00) (18,240.00) (21,000.00) (21,000.00) (21,000.00) 400450-0200 Reconnection Fee (20,720.00) (29,980.00) (29,590.00) (26,100.00) (24,700.00) (15,580.00) (20,000.00) (20,000.00) (20,000.00) 400.450-0300 Fee For Returned Checks (5,190.00) (5,010.00) (4,320.00) (3,390.00) (3,900-00) (2,340.00) (4,000.00) (4,000.00) (4,000.00) 400.450-0400 Late Payment Charge (217,050.00) (207,375.00) (204,465.00) (203,895.00) (201,590.91) (130,785.00) (200,000.00) (200,000.00) (200,000.00) 400451-0100 Temporary Connection (200.00) (200.00) (500.00) (500.00) (700.00) (500.00) (200.00 200.00 200.00 400454.0100 Security Lights (10,585.00) (11,002.00) (11,033.00) (11,301.00) (11,269.00) (7,482.00) (10,000.00) (10,000.00) (10,000.00) 400454-0300 Pole Rental - Cable Tv (264.25) (133.00) (31.50) (15.75) _ 400480-0000 Residential Sales (Gas) (4,327,787.79) (3,697,538.12) (4,626,722.25) (4,706,388.58) (3,731,066.35) (2,467,212.42) (4,258,334.00) (4,588,522.00) (4,474,618.00) 400481-0000 Commercial & Industrial Sales (3,823,161.64) (3,150,924.56) (3,729,790.43) (3,853,503.60) (2,748,161.17) (1,787,713.64) (3,722,294.00) (3,628,501.00) (3,388,924.00) 400.481-0400 LargeIndusMal -Ohly (0.50) (301,207.84) (433,424.19) - (360,000.00) (451,609.00) 400-481-0401 Large Industrial Contract (3M 8 HTI) (4,246,779.86) (2,826,423.90) (3.646,509.21) (6,066,289.59) (3,110,619.59) (1,530,348.97) (4,034,279.00) (3,578,643.00) (3,200,440.00) 400481-0500 Large Industrial - Demand(Ohly) (32,445.63) (28,257.88) - (35,000.00) (42,000.00) 400489-0000 New Ulm Transportation (724,187.29) (755,472.41) (785,148.57) (808,575.00) (776,164.46) (458,149.50) (725,100.00) (730,636.00) (734,878.00) 400489-0100 Transportation - Electric Divi (1,100,000.00) (1,099,999.56) (1,099,999.56) (700,000.00) (641,833.0(1) (377,513.50) (641,833.00) (647,166.00) (651,700.00) PRODUCTION LABOR ACCOUNTS 401-546-0100 Supervision 210,956.10 233,694.72 234,771.95 168,082.58 147,366.43 112,830.07 1,042,030.79 1,044,484.00 1,009,482.00 401-546.0200 Training - Labor 8,883.96 10,015.73 33,735.18 13,698.84 10.283.63 9,667.59 - - - 401-546-0300 Training - Expense 3,434.38 15,873.09 17,039.40 3,183.54 7,433.12 20,362.08 7,500.00 25,000.00 25,000.00 401-546-0400 Operating Labor 559,483.83 539,516.93 631,036.97 642,766.03 685,596.51 442,221.26 - - _ 401-546-0500 Vacation 82,420.19 84,003.87 88,363.04 94,375.80 76,528.29 49,748.80 - - 401-546.0600 Other - Labor 1,295.19 1,317.78 1,059.72 1,558.06 316.15 1,248.72 - - 401-546-0700 Sick Leave 30,891.32 31,412.26 35,759.32 40,946.29 49,701.36 22,881.13 - - 5,035.00 401-546-0800 Holiday Pay 54,840.66 54,984.54 61,978.94 61,443.21 61,568.30 34,233.92 - - 401-546-1200 Building Maintenance Labor 141.07 301.03 218.02 1,623.29 - 401-546-1300 Engineering - Labor - - 99.00 - - 401-546.1500 Drug And Alcohol Testing - Lab 94.00 1,602.00 630.00 224.001 134.00 401-546-1600 Meetings & Travel- Labor(Sta 14,096.03 12,201.86 10,089.45 4,945.501 1,978.40 3,739.68 - - 401-546-1700 Meetings & Travel - Expense (S 12,935.45 8,308.85 11,301.67 5,047.29 4,923.43 1.179.98 8,000.00 15,000.00 15,000.00 401-546-1800 Production Benefits - - 620,366.15 593,900.00 544,676.00 Account # AccouDescription 2011 Actual 2012 Actual 2013 Actual 2014 Actual 2015 Actual 2016 YTD (Posted as of 09/19/16) I 2015 Budget 2016 Budget 2017 Budget FUEL ACCOUNTS 401-547-0101 Generator#1 Natural Gas 356,207.93 466,390.87 413,416.96 156,955.11 179,943.77 210,751.35 511,500.00 619,200.00 689,400.00 401-547-0102 Generator #1 Aux Boiler 2,614.54 2,725.54 6,305.34 3,909.10 2,029.64 1,008.82 6,000.00 5,000.00 5,000.00 401-547-0103 Generator#1 Water& Sewer 12.700.85 22,018.38 16,239.65 14,457.32 10,672.31 8,137.13 16,000.00 16,000.00 16,000.00 401-547-0104 Generator#1 Transportation 1,100,000.00 1,099,999.56 1,099,999.56 700,000.00 641,833.00 377,513.50 641,833.00 647,166.00 651,700.00 401-547-0201 Generator #2 Natural Gas 129.66 2,947.48 3,028.75 28.60 - - 500.00 - - 401-547-0202 Generator #2 Fuel Oil 433.48 - 507.86 - 100.00 100.00 100.00 401-547-0301 Generator #3 Natural Gas 44,562.87 19,250.12 20,991.12 17,297.43 17,755.37 17,732.84 20,925.00 27,090.00 38,300.00 401-547-0302 Generator#3 Fuel Oil 15,678.84 19,151.99 21.334.09 12,350.57 9,138.64 10,856.43 15,000.00 15,000.00 15,000.00 401-547-0401 Generator #4 Natural Gas 34,640.64 18,178.57 24,633.30 24,923.32 25,148.71 16,520.07 20,925.00 27,090.00 38,300.00 401-547-0402 Generator #4 Fuel Oil 13,918.50 18,061.36 19,592.61 20,969.59 17,087.13 10,513.06 15,000.00 15,000.00 15,000.00 401-547-0501 Generator #5 Natural Gas - - 247,087.84 168,131.43 73,255.75 38,709.75 204,600.00 153,252.00 134,816.00 401-547-0701 Generator 97 Natural Gas 39,432.20 272.50 - - - - - - - 401-547-0702 Generator #7 Fuel Oil 12,826.40 - - - - - - - - 401-547-0801 Generator #8 Natural Gas 38,000.53 149,516.27 528,619.00 792,565.00 407,238.79 256,894.31 337,642.00 329,472.00 163,485.00 401-547-0901 Generator #9 Natural Gas 21,681.15 16,622.68 4,488.79 6,155.69 6,776.47 5,136.12 5,000.00 5,000.00 5,000.00 PRODUCTION OPERATING SUPPLY & EXPENSE ACCOUNTS 401-550-0101 Generator#1 Lubricants 420.62 2,218.87 2,130.23 55.73 3,000.00 2,500.00 2,500.00 401-550-0102 Generator #2 Lubricants 40.00 - - - - - - - 401-550.0103 Generator#3 Lubricants 3,423.36 1,875.45 3,338.06 3,106.54 2,182.51 2,764.12 3,000.00 2,000.00 2,000.00 401-550-0104 Generator#4 Lubricants 2,764.80 1,905.99 1,409.25 2,172.09 1,382.59 1.382.06 2,000.00 2,000.00 2,000.00 401-550-0105 Generator#5 Lubricants - - 3,772.51 1,937.00 2,064.18 572.14 6,400.00 3,500.00 3,500.00 401-550-0106 Generator #6 Lubricants - - - - - - - _ 401.550-0107 Generator #7 Lubricants 4,024.72 - - - - - 401-550-0108 Generator #8 Lubricants 258.23 - 657.35 - 723.08 3,000.00 1,500.00 1,500.00 401-550-0109 Generator 09 Lubricants - 629.55 629.55 629.55 744.55 744.55 500.00 1,000.00 1,000.00 401-550-0200 Supplies 8,894.93 16,765.73 14,707.43 12,226.72 33.754.05 7,203.52 10,000.00 12,000.00 12,000.00 401-550-0301 Generator#1 Chemicals 24,133.80 45,577.79 22,608.37 24,203.64 18,825.09 13,500.20 37,000.00 34,000.00 34,000.00 401-550-0302 Plant #1 Chemicals 8,456.17 24,842.23 58,477.78 49,880.49 44,670.74 29,507.13 15,000.00 55,000.00 55,000.00 401-550-0400 Uniforms & Laundry 14,458.25 14,992.78 18,744.19 18,694.08 20,218.21 10,054.05 13,500.00 10,000.00 10,000.00 401-550-0500 Waste Disposal 14,077.49 21,092.97 31,329.00 29,195.94 29,491.87 18,881.60 18,000.00 26,000.00 26,000.00 401-550-0600 Vehicle/Equipment Fuel 4,423.14 5.257.84 4,807.37 4,354.60 2.365.33 1,244.79 6,000.00 5,500.00 5,500.00 401-550-0700 Permits And Rent 180.00 70.00 1 80.00 1 100.00 8,041.42 6,591.57 200.00 1 500.00 1 500.00 PRODUCTION - MAINTENANCE EXPENSE ACCOUNTS 402-554-0100 Maint Power Prod Plant - Build 525.82 821.51 448.05 6,164.74 3,184.47 6,473.95 5,000.00 7,000.00 10,000.00 402-554-0101 Generator#1 Labor 36,268.61 56,366.89 73,089.78 91,536.43 51,867.66 46,248.89 304,437.70 324,230.00 353,496.00 402-554-0106 Generator#1 Outside Services 66,666.87 27,781.93 22,062.57 15,255.00 975.00 322.47 25,000.00 25,000.00 25,000.00 402-554-0102 Generator#1 Material 67,767.15 129,403.36 78,888.14 57,433.80 25,335.85 29,770.30 50,000.00 50,000.00 50,000.00 402-554-0201 Generator#2 Labor 1,025.98 345.16 1,104.90 872.61 6,430.79 97.59 - - - 402-554-0202 Generator #2 Material - 36.38 67.77 - 9.691 32.86 100.00 500.00 500.00 Account # Account Description 2011 Actual 2012 Actual 2013 Actual 2014 Actual 2015 Actual 2016 YTD (Posted as of 09/19/16) 2015 Budget 2016 Budget 2017 Budget 402.554-0301 Generator#3 Labor 5,262.33 3.477.27 16,549.11 22,507.83 24,156.86 10,731.85 - - - 402-554-0302 Generator #3 Material (2,411.40) 18,299.67 3,947.92 3,222.93 9,747.91 9,704.12 8,000.00 6,000.00 9,000.00 402-554-0401 Generator#4 Labor 5,535.44 5,280.72 24,833.15 18,247.18 20,546.00 20,339.77 - - - 402-554-0402 Generator#4 Material 1,170.15 918.95 8,732.22 7,495.18 4,132.66 13,932.37 6,000.00 7,500.00 7,500.00 402-554-0501 Generator#5 Labor 186.82 565.19 21,172.07 32,558.09 44,469.66 15,514.23 - - - 402-554-0502 Generator #5 Material 4.30 17,933.48 24,898.20 28,725.32 10,891.33 10,000.00 10,000.00 10,000.00 402-554-0601 Generator#6 Labor 174.44 - - - - - - - 402-554-0602 Generator #6 Material - - - 402-554-0701 Generator#7 Labor 2,743.32 - 402.554-0702 Generator #7 Material 299.28 - - - - - - 402-554-0801 Generator #8 Labor 10,073.75 23,409.98 24,837.42 48,272.68 61,336.60 31,370.08 - - - 402-554-0802 Generator #8 Material 8.468.40 8,517.58 12,927.34 33,568.94 31,600.37 14,983.81 10,000.00 20,000.00 20,000.00 402-554-0901 Generator #9 Labor 8,716.01 11,086.10 10,618.66 15,485.30 24,505.21 16,603.73 - - - 402-554-0902 Generator #9 Material 193.17 6,190.49 1,587.15 4,272.14 6,036.19 3,497.12 5,000.00 8,000.00 8,000.00 402-554-1001 Accessory Plant - Labor 67,761.33 109,509.89 75,575.93 59,331.26 48,852.98 25,222.68 - - - 402-554-1002 Accessory Plant - Materials 26,809.50 34,428.09 59,689.49 15,926.50 12,153.19 12,930.39 20,000.00 20,000.00 20,000.00 402-554.1101 Vehicles -Labor 1,730.34 1,208.74 2.573.26 3,361.81 1,324.02 449.71 - _ _ 402-554-1102 Vehicles - Material 2,341.76 2,452.82 1,574.61 2,856.15 1,558.59 128.50 2,000.00 2,000.00 2,000.00 402.554-1201 Maintenance Other - Labor 6,694.64 2,293.98 19.301.65 17,739.82 6,653.96 5,961.34 - - _ 402-554-1202 Maintenance Other - Materials 2,353.41 4,052.42 8,188.69 11,762.96 3,711.90 3,261.69 5,000.00 10,000.00 7,000.00 402.554-1203 Outside Services 5,276.81 6,462.70 12,829.96 7,102.84 26,304.43 22,908.94 8,000.00 8,000.00 11,000.00 402-554-1300 Obsolete Material Charged Off 767.00 20,564.34 1 785.48 - PURCHASED POWER 401-555-0200 Purchased Power 15,440,922.21 14,823,407.37 13.342,966.97 1 13,850,238.11 14,706,629.79 7,908,315.36 14,862,607.00 13,875,028.00 14,208,043.00 SYSTEM CONTROL & LOAD DISPATCH - LABOR ACCOUNTS 401-556.0100 System Control Labor 228,872.66 225,947.18 232,829.15 242,611.40 271,800.14 192,216.57 304,294.11 321,198.00 297,679.00 401-556-0200 Vacation 21,619.55 29,282.16 20,970.98 24,344.40 21,511.39 21,244.08 - - - 401-556-0300 Sick Leave 7,762.66 6,318.02 18,783.81 8,964.66 11,034.36 5,244.01 - 2,009.00 401-556-0400 Holiday Pay 13,801.44 17,117.12 16,187.78 16,050.64 15,508.86 11,152.18 - - - 401-556-0500 Mcg Software 36,600.00 54,090.00 36,600.00 36,600.00 33,550.00 27,450.00 36,600.00 36,600.00 36,600.00 401-556-0600 Training - Labor 2,237.92 1,918.95 - - 401-556-0700 Training - Expense 11.95 2,482.74 3,641.15 1,000.00 1,000.00 1,000.00 401-556-0800 System Control Benefits - 140,110.75 155,870.00 150,864.00 OUTSIDE PROFESSIONAL SERVICES ACCOUNTS 401-557-0000 Professional Services - Outside - 851.88 9,550.00 1 3,772.70 8,148.00 - 401-557-0100 Rw Beck 25,364.97 18,039.34 86,381.661 5,388.82 TRANSMISSION - LABOR ACCOUNTS 401-560-0100 Station Expense . Labor 129,567.60 129,567.60 129,567.60 144,105.52 144,105.48 84,061.53 145,000.00145,000.00 145,000.00 401-560.0200 Line Expense - Labor - - Account # Account Description f 2011 Actual 2012 Actual 2013 Actual 2014 Actual 2015 Actual 2016 YTD (Posted as of 09/19/16) 2015 Budget 2016 Budget 2017 Budget OPERATIONS, SUPPLIES b EXPENSE ACCOUNTS 401-565-0100 Transmission Expense 969,927.14 1,289,968.04 1,512,071.19 1,785,988.24 1,146,559.54 1,535,000.00 1,875,000.00 2,550,000.00 401-567-0100 Materials 258.80 173 91 59.11 100.00 - - 401-567-0200 Outside Services 22.75 - - 10,000.00 10,000.00 TRANSMISSION - MAINTENANCE ACCOUNTS (labor, materials, oubide services) 402-574.0100 Labor 10,879.84 1 18,445.64 1 11,421.081 17.613.741 12,719.391 5,388.20 1 16,018.97 1 16,622.00 1 16,483.00 402.574-0200 Materials 1,152.81 1 11,363.19 14,560.29 5,878.67 5,693.55 1 1,081.451 15,000.00 1 10,000.00 10,000.00 402-574-0300 Outside Services 465.13 1 42,781.00 1 47,752.931 4,869.04 1 4,818.00 1 4,02525 1 - - 50,000.00 DISTRIBUTION - LABOR ACCOUNTS 401-580-0100 Supervision 69,246.39 74,351.58 79,681.24 75,383.66 84,531.35 56,040.19 86,115.01 89,672.00 76,799.00 401-580-0200 Training - Labor 18,919.69 23,708.73 19,550.27 20,446.95 22,406.58 8,037.71 - - 401-580-0300 Training - Expense 6,962.32 8,829.47 2,916.85 3,172.50 1,136.09 198.00 3,000.00 5,000.00 5,000.00 401-580-0400 Meetings d Travel - Labor (Sta 4,962.42 3,678.76 3,673.02 4,642.56 6,631.13 5,359.35 - - - 401-580-0500 Meetings d Travel - Expense IS 2,566.68 3.240.16 2,528.77 3,603.00 5,274.23 906.05 3,000.00 3,000.00 3,000.00 401-580-0600 Distribution Benefits 426,860.56 427,148.00 378,580.00 DISTRIBUTION OVERHEAD 8 UNDERGROUND EXPENSE ACCOUNTS 401-581-0100 Line - Labor 1 30,901.79 1 29,165.87 49,038.78 54,893.00 1 51,277.98 38,996.34 50,481.21 52,567.00 57,388.00 401.581-0200 Line -Materials 30,261.491 42,056.20 1 9,224.65 1 9,578.261 10,362.58 1 8,861.13 1 15,000.00 15,000.00 15,000.00 DISTRIBUTION METER EXPENSE ACCOUNTS 401-586.0100 Meter - Labor 12,363.00 28,123.501 54,352.90 66,427.44 1 68,152.27 1 31,359.60 1 20,044.01 1 20,872.00 1 1,688.00 401-586-0200 Meter -Materials 583.82 1 2.808.52 13.016.461 4,966.04 1 25.03 5,000.00 1 - - DISTRIBUTION - EXPENSE ACCOUNTS pabor, materials, tealirrp, service agreenrenf..ect) 401-588-0100 Vacation 50,522.50 56,122.33 52,941.02 63,292.87 66,353.06 51,254.91 241,270.51 251,237.00 274,282.00 401-588-0200 Materials 9,218.95 1,607.88 4,420.57 2,060.70 13,248.07 8,688.55 4,000.00 10,000.00 10,000.00 401-588-0300 other Labor 242.68 74.25 271.50 30.75 - 775.01 221,226.50 230,365.00 251,496.00 401-588-0400 Vehicles/Equipment Fuel 26,191.09 24,651.17 23,708.71 22,681.84 16,463.57 9,878.89 - 20,000.00 20,000.00 401-588-0500 Sick Leave 35,339.70 33,631.52 41,236.88 33.351.52 30.565.87 31,602.98 - - 2,820.00 401-588-0600 Holiday Pay 38,336.57 40,165.63 40,287.69 39,741.12 41,773.44 23,118.56 - - - 401-588-1000 Call Time 20,959.23 22,177.31 21,567.62 23,726.20 21,762.22 15,732.27 - - - 401-588-1100 Building Maintenance - Labor 30.412.78 37,312.79 37,666.90 74,856.83 66,363.61 12,788.16 57,210.62 59,363.00 58,867.00 401-588-1200 Service Connection - Labor 431.38 1,115.94 1,257.93 1,014.83 673.23 - - - - 401-588-1300 Mapping/Gps - Labor 43,346.41 36,029.41 2,297.08 783.48 3,341.56 - - - 401-588-1400 Switching - Labor 6,254.73 6,391.84 7,924.85 2,457.22 1,874.73 1,575.88 - - 401-588.1500 Engineering - Labor - - - - 21.37 - - - 401-588-1600 Cad - Labor - - 401-588-1700 Drug And Alcohol Testing - Lab - 65.49 - - - - - 401-588-1900 Uniforms d Laundry 15,597.31 13,408.05 15,239.45 16,361.78 28.607.24 11,836.92 15,000.00 15,000.00 18,000.00 401-588-2000 Engineering Tech - Labor 44,409.92 50,971.57 50,161.75 52,184.42 59,407.16 32,578.09 - - 401-588-2100 Transformer Oil Testing Labor 1,544.71 195.00 4,959.00 1,377.68 1,106.16 - - 401-588-2200 Territory Service Agreements 23,512.44 26,763.20 26,964.54 25,927.58 29,068.48 25,000.00 25,000.00 17,500,00 Account 111 Account Doncrlpllon 2011 Actual 2012 Actual 2013 Actual 2014 Actual ji 2015 Actual 2016 YTD (Posted as Of 09/19/16) 2015 Budget 2016 Budget 2017 Budget DISTRIBUTION - MAINTENANCE OF STRUCTURES 8 STATION EQUIPMENT 402-592-0100 Building 8 Grounds - Labor 5,522.17 4,653.05 12,129.85 12,069.32 9,986.42 6,734.34 8,253.42 8,893.00 9,307.00 402-592-0200 Building 8 Grounds - Materials 5,424.46 7.78 701.29 4,257.54 99.99 61.62 1,000.00 1,000.00 1,000.00 i 402-592-0400 Structures 8 Equipment - Contr 1,220.00 - - 2,070.00 1,000.00 1,000.00 1,000.00 402-592-0500 Structures 8 Equipment- Mater 3,649.00 2,125.02 4,099.57 1,375.00 2,000.00 1,000.00 1,000.00 DISTRIBUTION - MAINTENANCE OF OVERHEAD & UNDERGROUND UNES 402-594-0100 Line - Labor 66,807.61 86,638.94 1 113,D66.251 106,728.53 1 73,129.71 1 141,230.49 1 94,281.09 1 98,176.00 107,181.00 402-594-0200 Line - Materials 29,075.30 45,287.75 1 50,899.04 1 17,123.16 27,035.28 5,921.32 39,000.00 1 20,000.00 1 20,000.00 DISTRIBUTION -TRANSFORMER MAINTENANCE 402-595.0100 Transformer - Labor 2,704.65 3,899.93 9,962.031 5,996.64 1 5,492.12 1 2,515.58 1 5,196.60 1 5,411.00 5,908.00 402-595-0200 Transformer - Materials 3,928.501 6,694.58 1 12,896,821 6,210.77 5,079.16 5,838.66 1 8,000.00 1 8,000.00 1 8,000.00 DISTRIBUTION - STREET LIGHTING & SIGNAL MAINTENANCE 402-596-0100 Street Lighting - Labor 50,231.11 1 52,732.03 1 53,210.801 38,859.071 67,264.48 1 29,857.61 1 53,450.70 1 55,659.00 1 60,764.00 402-596-0200 Street Lighting - Materials 18,436.11 18,514.58 12,484.04 1 14,722.86 23,007.32 1 13,759.27 1 15,000.00 1 15,000.00 1 15,000.00 DISTRIBUTION - EQUIPMENT MAINTENANCE 402-598-0201 Vehicles - Labor 15,274.73 13,208.43 11,524.34 11,830.39 14,314.39 4,499.96 23,755.87 24,737.00 27,006.00 402-598-0202 Vehicles - Material 14,261.89 7,798.69 14,239.59 15,518.53 19,452.76 8,794.37 11,000.00 12,000.00 12,000.00 402-598-0301 Power Equipment - Labor 2,038.76 1,930.87 2,165.42 5,887.38 5.037.37 9,114.06 - - - 402-598-0302 Power Equipment - Materials 2.582.01 12,624.63 2,194.48 5,905.43 4,170.54 15,682.36 4,000.00 4,000.00 4,000.00 402-598-0400 Obsolete Materials Charged Off - 114.91 9,535.09 931.39 325.26 - - - 402-598-0501 Other Equipment - Labor 5,662.70 5,108.66 8,966.50 9,106.40 8,879.64 10,598.70 1 - I - - 402-598-0502 Other Equipment - Materials 4,175.40 5,859.88 2,525.861 1,406.10 1 171.47 1 1,009.34 1 3,000.00 1 2,000.00 1 2,000.00 GAS PURCHASE ACCOUNT'S 401-807-0100 Gas For Retail 5,604,375.15 4,244,212.62 4,549,968.98 5,385,631.52 3,545.049.24 2,346,757.44 4,064,314.00 4,161,898.00 4,102,910.00 401-807-0101 Contract Gas For Retail 3,424,329.04 2,156,625.05 2,950,652.13 1 5,074,636.65 2,443,772.18 1,010,849.10 3,516,110.00 3,052,857.00 2,679,314.00 GAS - OPERATION TRANSMISSION ACCOUNTS 401-856-0100 Line - Labor 46,176.67 52,332.37 54,057.29 52,707.52 50,912.38 32,456.58 60,710.22 66,837.00 69,724.00 401-856-0200 Line -Outside Services 25,320.00 25,650.03 25.324.33 25,652.25 24,283.55 16,638.33 28,000.00 26,000.00 26,000.00 401.856-0400 M 8 R Station - City Gate - La - 120.64 94.14 263.56 707.40 - - - 401-856-0500 Materials 2,989.73 8.670.65 5.770.99 4,599.08 10.818.66 2.860.73 6,000.00 6,500.00 6,500.00 401-856-0600 Utilities (Electric. Satellite 5,654.75 5,805.58 7,756.06 6.813.93 6,773.68 3,814.78 8,000.00 7,500.00 7,500.00 401-856-0700 Railroad Licenses 3,864.60 3,992.78 4,293.97 4,215.49 5,691.26 2,593.73 6,000.00 5,000.00 5,000.00 401-856-0800 Public Awareness - Labor 1,403.27 864.27 4,009.27 1,921.64 1,334.16 3,337.76 - - - 401-856-0900 Public Awareness - Material 10,090.00 8,296.34 13,164.60 10,980.40 15,038.03 2,390.95 17,000.00 17,000.00 17,000.00 401-856-1000 Gas Transmission Benefits - - - - - - 37,440.63 34,923.00 33,740.00 GAS - MAINTENANCE TRANSMISSION ACCOUNTS 402-863.0100 Line - Labor 1,358.03 789.38 225.541 2,491.68 1 3,995.96 1 1,251.46 1 1,517.76 1 11671.00 1 11741.00 402-863-0200 Line -Outside Services 8.114.62 3,450.00 15,000.00 7,500.00 7,500.00 402-863-0400 M 8 R Station - City Gate - Labor 118.281 301.60 1 180.961 311.96 1 - - Account # Accoura DescrlPUorr 2011 Actual 2012 Actual 2013 Actual 2014 Actual 2015 Actual 2016 YTD (Posted as of 09/19/16) 2015 Budget 2016 Budget 2017 Budget 402-863-0500 Materials 1,485.43 2,704.17 144.51 21,043.45 340.56 62.94 1,500.00 1,000.00 1,000.00 GAS - OPERATION DISTRIBUTION ACCOUNTS 401-870-0100 Supervision 90,226.53 81,486.69 100,122.64 87,880.74 111,137.22 71,667.44 106,072.79 120,306.00 125,383.00 401-870-0200 Training - Labor 34,241.19 22,573.09 45,728.20 34,281.31 28,045.47 20,431.50 - - - 401-870-0300 Training- Expense 4,923.41 7,107.13 9,129.57 7,542.26 9,725.55 7,571.79 12,000.00 8,000.00 8,000.00 401-870-0400 Meetings A Travel - Labor (Sta 9.838.40 6,897.00 3,319.68 9,551.68 5,179.43 2,771.20 - - - 401.870-0500 Meetings & Travel - Expense (S 7,084.92 2,228.17 3,037.48 6,659.30 12,240.59 9,183.43 1 8,000.00 12,500.00 12,500.00 401-870-0600 Gas Distribution Benefits 244,235.51 1 217,282.00 1 210,558.00 GAS - MAINS & SERVICE ACCOUNTS 401-874-0100 Labor (Mains And Services) 39,487.08 31,582.04 41,682.23 43,032.29 36,026.24 47,495.73 65,299.00 75,192.00 78,364.00 401-874-0200 Labor (M & R General Services) 4,128.09 3,411.23 2,069.24 7,711.25 1,753.74 - - - - 401-874-0300 Labor (M & R Industrial Servic 5,903.32 1,720.58 773.33 3,862.18 2,323.65 725.60 - 401-874-0400 Labor (M & R Station - City Ga 5,926.00 4,674.87 2,320.89 14,357.64 14,898.81 11,751.10 - - - 401-874-0500 Materials 13,553.72 16,078.90 10,549.37 13,768.56 13,912.44 14,743.96 13,500.00 17,500.00 17,500.00 401-874-0600 Public Awareness -Labor 5,619.51 2,770.13 4,543.09 5,844.71 4,548.27 2,169.40 1 - I- I- 401.874-0700 Public Awareness -Material 16,377.91 12,303.86 14,184.86 15,848.19 1 14,251.39 1 32,599.29 15,000.00 17,000.00 17,000.00 GAS - METERS 401-878.0100 Reinstalling Or Changing Of Meter- L 984.49 1 60.63 1 239.85 1 2,920.71 1 9,497.24 1 928.69 1 758.88 1 835.00 1 871.00 GAS - MISC EXPENSE ACCOUNTS 401-880-0100 Vacation 44,487.58 85,066.67 43,827.00 49,879.03 49,637.46 31,367.46 - - - 401-880-0200 Other Labor 235.22 249.11 98.58 1,296.22 - 1,305.60 - - - 401-880-0300 Odorant 9,481.53 - 10,234.28 6,506.93 - 7.957.65 - 25,000.00 25,000.00 401-880-0400 Vehicle/Equipment Fuel 23,374.21 22,503.50 23,484.37 24,172.31 13,927.58 7,507.67 24,000.00 13,000.00 13,000.00 401-880-0500 Mist Expense 476.70 456.11 239.19 196.12 196.68 3.52 500.00 500.00 500.00 401-880-0600 Testing Meters - Outside Services - - - - 551.33 - - - - 401-880-0700 Sick Leave 19,276.73 19,504.71 21,400.76 20,655.41 25,541.89 13.288.65 - - 2,112.00 401-880-0800 Holiday Pay 24,962.71 26,848.90 27,930.66 29,394.10 26,893.67 15,906.11 - - - 401-880-1200 Call Time 19,719.09 20,548.06 20,898.35 21,069.11 23,076.75 16,166.86 - - - 401-880-1300 Building Maintenance -Labor 10,737.27 13,863.24 9,592.70 21,393.66 10,343.70 7,940.54 140,902.43 84,381.00 87,942.00 401-880-1500 Uniforms 8 Laundry 10,810.25 10,199.18 10,200.31 9,581.03 9,680.37 4,510.24 10,000.00 8,500.00 8,500.00 401-880-1700 Drug And Alcohol Testing - Labor 28.41 30.75 - - - - 401-880-2100 Union Representative Meetings 272.62 1 662.63 181.40 150.00 250.00 - GAS - DISTRIBUTION LINES (SERVICES & MAINS) 402-892-0100 Labor Mains 78,723.18 94.953.48 74,785.31 69,688.46 91,781.69 12,749.40 111,270.00 66,837.00 69,657.00 402-892-0200 Labor (M & R General Service) 1,478.38 3,565.28 16,914.34 2,438.09 30,487.74 28,577.29 - - - 402.892-0300 Labor (M & R Industrial Servic 439.78 1,635.15 578.80 3,826.26 4,602.67 429.54 402-892-0400 Labor (M & R Station - City Ga 3,657.91 5,499.31 12,819.23 6,694.58 8,479.58 1,932.01 - - _ 402-892-0500 Materials 24,365.00 28,254.01 21,804.11 17,270.42 21,239.01 13,212.35 40,000.00 72,000.00 80,000.00 402-892-0600 1 OutsideService- Painting 14,090.00 15,000.00 10,000.00 10,000.00 Account # Account Description 2011 Actual 2012 Actual 2013 Actual 2014 Actual 2015 Actual I 2016 YTD (Posted as of 09/19/16) 2015 Budget 2016 Budget 2017 Budget GAS - METERS 8 HOUSE REGULATORS 402-893-0100 1 Meter- Labor 113.014.371 20,778.891 9,932.17 1 22,553.65 322 46 13,807.46 24,228.00 25,251.00 GAS - MAINT OF OTHER PLANT ACCOUNTS ----- 402-895-0100 Labor - - - - - 145,740.04 163,750.00 170,659.00 402-895-0101 Vehicles - Labor 12,248.19 8,188.05 7,780.13 10,063.25 15,371.47 4,029.52 - - - 402-895-0102 Vehicles - Material 8,744.13 10,626.25 9,730.18 9,540.43 15,402.56 7,013.54 10,000.00 10,000.00 10,000.00 402-895-0201 Power Equipment -Labor 23,081.37 16,175.86 16,210.22 12,360.08 9,685.60 5,793.92 - - - 402-895-0202 Power Equipment - Materials 8,096.32 4,511.08 3,494.84 1,810.16 367.99 703.71 7,500.00 5,000.00 5,000.00 402-895-0300 Obsolete Material Charged Off 1,521.17 9.51 1,540.00 199.53 -1,00000 1,000.00 402-895-0401 Other Equipment -Labor 8,111.95 5,065.37 5,578.85 1,654.22 3,747.38 1,302.32 - - - 402-895-0402 Other Equipment - Materials 5,351.12 13,071.83 4,608.81 18,545.18 3,525.79 1,966.68 6,000.00 8,500.00 8,500.00 CUSTOMER SERVICE - METER READING (Shared Divfslon EMmses) 401-902-0100 Meter Reading -Labor 135,619.42 1 56,030.76 33,908.04 31,186.52 33,480.02 25,102.02 37,377.61 38,784.00 18,838.00 401-902-0200 Meter Reading - Materials 4,215.59 33.62 1 262.72 8,807.42 6,412.50 1,000.00 CUSTOMER SERVICE -COLLECTION EXPENSE (Shared Dhrislon Expenses) 401-903-0100 Collection -Labor 11,063.25 15,644.45 24,946.88 35,146.83 21,191.12 12,820.89 26,698.29 27,703.00 7,849.00 401-903-0200 Collection - Materials 118,844.42 115,084.87 114,723.63 98,792.55 168,012.52 116,076.69 165,000.00 175,000.00 234,695.00 401-903.0300 Vacation 3,459.86 (39.743.08) 9,395.73 13,547.80 15,639.04 10,466.58 - - - 401-903-0400 Supervisor 58,366.98 56,386.25 59,214.24 47,607.21 52,952.99 38,060.09 69,281.33 72,314.00 75,426.00 401-903-0500 Sick Leave 2,831.51 3,271.74 11,987.48 5,308.42 7,191.87 5,736.86 - - 989.00 401-903-0600 Holiday Pay 5,050.72 6,442.72 6,633.43 8,462.98 10,659.76 5,718.92 - - 401-903-1101 Meetings 8 Travel - Labor (Sta 634.08 680.32 - - - - 401-903-1102 Meetings 8 Travel - Expense IS - 1,279.82 658.00 172.48 621.26 2,000.00 - 401-903-1201 Training - Labor 634.08 217.68 - - - - - 401.903.1202 Training-Expense 1,577.63 558.00 4,419.77 641.26 162.72 4,000.00 5,000.00 5,000.00 401-903-1300 Customer Service Benefits - - - 53,127.49 58,337.00 57,253.00 CUSTOMER SERVICE -COLLECTIONS d BAD DEBT WRITE OFFS (Shared DWlslon Expenses) 401-904-0000 Bad Debt Write Offs 6,222.55 1 5,801.94 1 9,217.60 1 19,773.22 1 8,469.80 1 260.53 15,000.00 15,000.00 10,000.00 401-906-0100 Customer Service -Labor 173,475.87 1 81,489.53 73,200.78 1 85,974.77 1 90,030.36 1 62,167.87 1 96,993.87 1 101,240.00 1 105,597.00 CONSERVATION IMPROVEMENT PROGRAM (Shared Dhr skm Expenses) 401-911-0000 Supervision (Conservation Impr 8,167.121 8.171.121 7,578.04 1 6,679.53 - CONSERVATION IMPROVEMENT PROGRAM (Shared DWislon Expenses) 401.916-0100 Labor Imp 59,342.21 60,777.98 61,709.14 62,298.45 66,357.08 48,797.26 - - 86,402.00 401-916-0200 Tree Planting 30,000.00 29,475.91 29,394.64 30,000.00 30,000.00 - 30,000.00 30,000.00 30,000.00 401-916-0300 Other Programs - - 77,084.80 81,702.00 - 401-916-0301 Cip- Residential 54,841.17 64,357.79 62,217.37 75,551.00 74,209.29 59,515.23 94,571.00 116,936.00 116,161.00 401-916-0302 Cip- Commercial 232.118.83 233.102.21 32,284.45 23,980.50 55,899.78 29,336.06 133,166.00 149,554.00 143,633.00 401-916-0303 Cip-Industrial 960.60 44,040.00 40,000.00 1 225,458.64 39,878.01 206,291.00 1 123,465.00 1 125,715.00 401-916-0304 Cip - Marketing 17,715.18 17,899.76 14,135.97 9,282.10 4,488.92 1,763.68 21,000.00 10,000.00 10,000.00 401-916-0305 Doe- ClpAssessment 24,539.90 18,250.28 16,334.23 26,278.96 23,791.51 14,912.50 21,000.00 19,000.00 19,000.00 401-916.0400 Cip - Transfer To Assets (200,000.00) (201,962.62) - - 20,000.00 10,000.00 10,000.00 Account Description Account # 2011 Actual � I 2012 Actual 2013 Actual 2014 Actual j I 2015 Actual 2016 YTD (Posted as of 09/19/16) 2015 Budget 2016 Budget 2017 Budget ADMINISTRATIVE & GENERAL SALARIES (Shared Division Expenses) 401-920-0100 Supervision Salaries 118,524.51 132,629.60 131,691.23 117.889.42 115,694.70 81,362.20 - - 142,257.00 401-920-0200 General Salaries Labor 389,244.75 404,157.56 421,379.18 413,394.32 397,809.45 243,325.22 606,902.40 556,732.00 441,805.00 401-920-0300 Vacation 56,974.05 57,751.21 81,748.64 47,029.70 53,363.16 23,904.79 - - _ 401-920-0500 Sick Leave 31,884.08 20,769.57 23;723.09 14,192.74 15,140.21 6,739.05 - - 1,350.00 401-920-0600 Holiday Pay 30,383.49 32,767.41 35,308.22 30,327.36 25,711.83 15,193.43 - _ _ ADMINISTRATIVE & GENERAL OFFICE SUPPLIES & EXPENSES (Shared Division Expenses) 401-921-0100 Telephone 39,701.30 37,365.15 52,456.61 38,441.62 43,891.18 31,196.97 43,000.00 42,000.00 43,000.00 401-921-0200 Office Supplies 24,738.49 33,311.26 27,475.92 25,466.12 18,766.17 12,494.50 28,000.00 28,000.00 25,000.00 401-921-0300 Lease/ServiceAgreements 114,625.99 33,123.12 31,574.17 30,429.61 31,262.72 28,994.68 32,000.00 34,000.00 33,000.00 401-921-0400 Postage 2,928.87 8,206.02 13,952.97 2,577.68 2,442.32 3,968.00 6,000.00 6,000.00 6,000.00 401-921-0500 Mail Services - Ups, Fedex 3,938.21 4,257.95 3,611.52 1,534.74 2,139.84 1,649.82 3,900.00 3,500.00 3,200.00 401-921-0600 It Admin And Support 109,214.22 1 220,719.10 1 241,246.67 1 235,952.25 230,942.26 1 221,011.88 1 173,000.00 173,000.00 315,018.00 401-921-0700 Adverttsing/Printing 3,182.21 4,699.84 5,114.54 4,508.41 1,712.56 1 549.00 10,500.00 10,500.00 5,000.00 ADMINISTRATIVE & GENERAL OUTSIDE SERVICES (Shared DW elon Expensas) 401-923-0200 Legal Services 81,571.35 50,719.23 102,257.09 43,074.04 46,075A0 36,149.01 42,000.00 42,000.00 42,000.00 401-923-0300 Engineering Services 33,900.00 73,168.85 6,856.37 9,426.20 - - 20,000.00 - 40,000.00 401-923-0400 Misc Services 25,425.00 23,700.00 21,500.00 21,950.00 23,550.00 22,525.00 22,500.00 24,000.00 24,000.00 401-923-0500 Human Resources Services 48,033.77 45,337.50 57,850.00 64,155.00 64,288.93 49,723.47 58,075.00 33,075.00 33,075.00 401-923-0600 Drug Testing Services 7,485.00 7,395.00 8,664.00 7,749.00 7,500.00 7,668.00 8,000.00 8,000.00 8,000.00 ADMINISTRATIVE & GENERAL PROPERTY INSURANCE (Shared Division Expenses) 401-924-0100 Property Insurance 59,491.00 57,071.00 58,174.00 51,608.00 50,516.00 29,103.45 53,000.00 1 53,000.00 1 50,000.00 401-924-0200 Boiler Insurance 62,565.00 66,912.00 66,640.00 61,327.00 1 65,050.00 1 37,918.561 67,000.00 1 67,000.00 67,000.00 401-924-0300 General Liability 83,377.00 65,354.00 61,572-001 53.858.00 4S,oI4.00j 19,930.00 1 55,000.00 1 55,000.00 30,000.00 EMPLOYEE PENSION & BENEFITS (Shared Division Expenses) 401-926-0101 Administrative Benefits 838.734.06 836,674.48 864,532.13 903,684.00 959,798.16 606,064.13 283,606.20 237,178.00 251,611.00 401-926-0200 Fica Taxes 288.799.58 296.146.93 311,352.39 315,318.00 306,092.30 204,976.12 - - - 401-926-0300 Pera 289,085.09 295,011.57 310,182.06 304,149.64 379,354.59 209,615.40 - _ 401-926-0400 Uniforms 300.91 199.95 199.95 265.80 236.89 1,586.76 - - _ 401-926-0500 Breakroom/Recognition Banquet 12,811.00 14,570.87 15,094.18 13,724.26 14,428.36 4,689.86 - 15,000.00 15,000.00 401-926-0700 Unemployment Compensation Ohso 473.12 118.28 - - - - 401-926-0800 Life/Ltd/Ad&D Insurance 23,512.16 19,492.52 38,744.59 28,637.80 25,655.92 17,672.76 - - 401-926-0900 Worker•S Compensation 70,810.13 79,967.23 64,944.00 71,539.90 79,865.53 45,325.00 - - 401-926-1000 Dental insurance 36,951.80 40,326.05 49,332.41 50,755.37 41,888.06 29.135.98 - _ 401-926-1100 Pandemic Flu Supplies - - - - - - - - REGULATORY EXPENSE (Shared DWasion Expenses) 401-928-0000 Regulatory Expenses 52,273.44 96,227.33 43,599.88 44,191.581 42,404.17 1 31,989.16 1 50,000.00 1 50,000.00 1 50,000.00 Account # Account Description 2011 Actual 2012 Actual 2013 Actual 2014 Actual 2015 Actual 2016 YTD ( (Posted as of 09/19/16) 2015 Budget 2016 Budget 2017 Budget MISC GENERAL EXPENSE ACCOUNTS (SharedDivision Expenses) 401-930-0100 Commissioners Labor 25,812.52 28,862.19 25,685.99 26.393.90 26,393.90 17,257.55 26,393.90 26,394.00 26,394.00 401-930-0201 Meetings 8 Travel - Labor (Sta - 463.38 1,534.80 - - - - - 401-930.0202 Meetings 8 Travel - Expense (S 4,105.01 5,025.67 7,087.58 1,206.08 120.61 80.88 - - 401-930-0301 Training - Labor 5,056.35 4,359.16 4,660.80 1,684.56 - - - - 401-930-0302 Training - Expense 13,915.22 6,271.94 4,838.83 10,219.03 6,623.07 519.09 18,000.00 18,000.00 15,000.00 401-930-0400 Dues/Membership Expense 58,666.52 68,919.21 58,187.24 45,800.64 1 42,632.00 1 28,563.251 60,000.00 85,000.00 1 60,000.00 401-930.0500 Utility Expenses - Water/Waste 76,145.35 71,282.57 71,784.43 72,235.94 47,772.40 35,620.08 72,500.00 70,000.00 70,000.00 401-930-0800 Misc Expense 448.40 - 75.99 455.00 - - MAINTENAMCE OF GENERAL PLANT (Shared DMWw Expenses) 401-935-0101 Grounds - Labor 753.02 - 176.93 3,297.55 3,567.19 1,101.42 1,525.62 1,583.00 1,570.00 401-935-0102 Grounds -Materials 1,368.70 4,303.83 34,601.37 19,932.27 5,202.09 4,039.52 16,000.00 16,000.00 16,000.00 401-935-0103 Grounds - Outside Services 29,093.76 26,647.80 47,459.21 35,025.34 29,196.99 3,604.30 54,742.00 53,000.00 53,000.00 401-935-0200 Misc Expenses 1,128.75 4,773.88 795.01 380.78 449.64 360.78 - - - 401-935-0201 Misc Other - Labor 1,563.88 1,986.47 447.71 1,682.73 1,733.95 - 401-935-0202 MiscOther- Materials 37,239.67 42,194.43 39,327.94 44,190.44 40,145.01 20,918.40 - - _ 401-935-0203 Vehicles/Equipment Fuel 10,725.88 3,006.56 3,240.96 2,969.13 2,114.171 1,075.451 4,000.00 4,000.00 4,000.00 401-935-0301 Vehicles - Labor - 35.00 -- - _ 401-935-0302 Vehicles - Material 1,146.90 4,972.37 1 3,153.191 8,433.601 2,151.38 11 608. 1 3,500.00 3,500.00 3,500.00 DEPRECIATION 403-000-0100 Electric Depreciation 2,284,769.68 2,289,199.48 2,612,388.36 2,744,768.64 2,816,300.87 1,575,000.00 2,700,000.00 1 2,700,000.00 2,800,000.00 403-000-0200 Gas Depreciation 1,042,071.10 1,043,233.85 1,027,662.35 1,002,803.96 1,008,133.11 616,000.00 1,056,000.00 1,056,000.00 1 1,008,000.00 DEBT 407-000-0000 Amortzation - Development Study 725,078.00 473,196.00 525,942.94 525,943.20 262,971.60 262,971.60 - - PILOT 6 ROADWAY LIGHTING (Shared DMslon Expenses) 408-000-0000 Payment In Lieu Of Taxes To City 1,105,613,13 1,136,724.11 1,403,077.07 1,729,073.00 591,371.00 665,042.74 591,371.00 1,160,721.00 1,048,947.00 408-000-0100 Roadway Lighting 143,000.00 148,585.28 142,666.32 146,739.00 84,312.01 146,739.00 144,535.00 147,384.00 REVENUES FROM JOBBING 6 CONTRACT WORK (Shared Dhrision Expenses) 415-101-0000 Material 8 Contracted Labor (22,625.34) (14,660.20) (36,678.33) (149.50) - - - _ 415-103-0000 Other Revenue- Trucks (5,413.50) (13,995.75) (9,243.50) 415-104-0000 Other Revenue - Labor (17,490.09) (35,414.47) (16,351.93) (255.00) - - - 415-105-0000 Electric Services (1,552.11) (1,658.97) (1,831.82) (77,459.49) (55,355.92) (26,531.53) - - 415-105-0100 Natural Gas Services (1,164.78) (4,416.49) (4,912.30) (50,515.83) (25,290.60) (10,834.54) _ 415-106.0000 Street Lighting 246.75 - - _ 415-107-0000 Third Party Damage - Electric (4,860.54) - (11,550.00) - - 415-107-0100 Third Party Damage - Natural Gas 415-108-0000 Operating 8 Maint-Brownton (26,246.60) (42,353.02) (39,771.99) (23,666.07) (27,000.00) (27,000.00) (33,000.00) INTEREST EARNINGS (Shared Dhrision Expenses) 419.000-0000 Interest And Dividend Income(55,734.89) (56,252.21) (75,940.54) (29,720.52) (31,956.25) (27,143.87) (65,000.00) (115,000.00) (1001000.00) 419-000-0100 Interest Income -Bond Premium (77,336.80) (185,608.32) (185,608.32)1(185.608.32) (108,271.52) (185,608.32) (185,608.32) (185,608.32) Account # Account Description 2011 Actual 2012 Actual 2013 Actual T 2014 Actual 2015 Actual 2016 YTD (Posted as of 09/19/16) 2015 Budget 2016 Budget 2017 Budget MISC NON-OPERATING INCOME ACCOUNTS 421-000-0400 Misc.Income- Electric (28,626.68) (294,299.32) (58,031.05) (35,407.84) (129,966.39) (22,376.14) 421-000-0500 Misc Income - Interruptible Cr _ 421-000-0600 Misc.Income - Gas (1,361.34) (227,442.98) (1,008.23) (5,234.50) (28,315.72) (6,512.02) - - 421-000-0100 Gain On Disposal - Electric (157,996.86) (4,581.80) (10,000.00) (23,159.01) - 421-000-0101 Gain On Disposal -Gas (120.00) (22,100.00) 421-000-0200 Loss On Disposal - Electric - - i - _ INTEREST CHARGES, LONG-TERM DEBT, JOBBING & CONTRACT WORK EXPENSE ACCOUNTS..ETC. (Shawl Wsbn E)cpertaes) 428-000-0000 Amortization Of Debt Disc Elec 1,864.04 1,864.08 428-000-0100 Amortization Of Debt Disc Gas 29,203.36 36,187.04 - - - - - - 416-101-0000 Material 8 Contracted Labor 20,647.13 20,744.38 38,032.16 17,400.17 824.21 (37.52) 428-000-0200 Prior Period Adjustment -Elect - 22,679.18 - - - 416-103-0000 Trucks 17,000.00 - - 428.000-0300 Prior Period Adjustment-NGas - - 588,559.11 - - - 416-104.0000 Trucks - Labor 8,380.12 5,512.68 9,858.07 289.38 734.40 - - - _ 416-105-0000 Electric Services 3,001.12 2,722.48 3,304.67 22,961.55 27,890.29 9,897.84 - - _ 416-105-0100 Natural Gas Services 711.02 1,634.14 2,228.42 12,462.01 4,874.63 18,114.37 - - - 416-106-0000 Street Lighting 245.52 552.79 260.56 34,324.32 66,862.84 41,354.05 - - - 416-106-0100 Street Lighting - Material - - 131.44 - 654.70 35.96 - - - 416-107-0000 Third Party Damage - Electric 299.11 1,024.59 993.67 4,529.58 7,697.31 10,938.64 - - - 416-107-0100 Third Party Damage -Natural Gas 540.00 - - 186.92 143.19 762.98 416-108-0000 Operating 8 Maint-Brownton - 4,188.87 9,736.60 3,725.45 3,556.59 416-10940000 Emergency Response-Brownton - - 340.87 710.84 - _ _ 427-000-0200 Bond Service Fees 1,850.00 1,850.00 2.400.00 450.00 450.00 2,400.00 2,400.00 2,400.00 4274000-0300 Interest - Development Study 145,408.50 109,153.33 40,521.71 - - _ 427-000-0600 Interest -2003 Bonds Gas 956,151.76 1,326,967.73 1,271,801.23 863,999.55 821,833.37 455,875.00 825,500.00 781,500.00 735,100.00 427-000-0700 Interest -2003 Bonds Electric 55,130.68 50,068.10 45,015.55 40,081.70 35,195.86 17,857.35 35,612.50 30,612.50 25,487.50 431-000-0100 Interest - Customers Deposits 847.37 351.42 2,345.64 434.14 96.16 683.49 1,000.00 200.00 100.00 i 2016 PAY GRID % Between Grades: 6% Range: 35.0% Starting midpoint: 0 2017 PAY GRID 3% Increase to Grid % Between Grades Range Starting midpoint 6% 35.0% 0 Salary Range Salary Range PtsGrade Min Mid Max Pts Grade Min Mid j Max 0 - 135 1 38,723.40 45,500.00 52,276.60 0 - 1135 1 39,885.11 46,865.00 53,844.89 136 - 154 2 41,046.81 48,230.00 55,413.19 136 - 1154 2 42,278.21 49,676.90 57,075.59 155 - 174 3 43,509.62 51,123.80 58,737.98 155 - 174 3 44,814.91 52,657.51 60,500.12 175 - 195 4 46,120.19 54,191.23 62,262.26 175 - 195 4 47,503.80 55,816.96 64,130.13 196 - 1217 5 48,887.41 57,442.70 651998.00 196 - 217 5 50,354.03 59,165.98 67,977.94 218 - 1241 6 51,820.65 60,889.26 69,957.88 218 - 241 6 53,375.27 62,715.94 72,056.61 242 - 1267 7 54,929.89 64,542.62 74,155.35 242 - 267 7 56,577.79 66,478.90 76,380.01 268 - 1295 8 58,225.68 68,415.18 78,604.67 268 - 1295 8 59,972.45 70,467.63 80,962.81 296 - 1325 9 61,719.22 72,520.09 83,320.95 296 - 325 9 63,570.80 74,695.69 85,820.58 326 - 1357 10 65,422.38 76,871.29 88,320.21 326 - 357 10 67,385.05 79,177.43 90,969.81 358 - 1391 11 69,347.72 81,483.57 93,619.42 358 - 391 11 71,428.15 83,928.08 96,428.00 392 - 1427 12 73,508.58 86,372.58 99,236.59 392 - 427 12 75,713.84 88,963.76 102,213.68 428 - 1465 13 77,919.10 91,554.94 105,190.78 428 - 1465 13 80,256.67 94,301.59 108,346.50 466 - 1505 14 82,594.24 97,048.24 111,502.23 466 - 505 14 85,072.07 99,959.68 114,847.30 506 - 1545 15 87,549.90 102,871.13 118,192.36_ 506 - 545 15 90,176.39 105,957.26 121,738.13 546 - 585 16 92,802.89 109,043.40 125,283.90 546 - 585 16 95,586.98 112,314.70 129,042.42 586 - 1625 17 98,371.07 115,586.00 132,800.94 586 - 625 17 101,322.20 119,053.58 136,784.97 626 - 1665 18 104,273.33 122,521.16 140,768.99 626 - 665 18 107,401.53 126,196.80 144,992.06 666 - 705 19 110,529.73 129,872.43 149,215.13 666 - 705 19 113,845.62 133,768.60 153,691.59 706 - 745 20 117,161.51 137,664.78 158,168.04 706 - 745 20 120,676.36 141,794.72 162,913.08 746 - 785 21 124,191.20 145,924.66 167,658.12 746 - 785 21 127,916.94 150,302.40 172,687.87 786 - 825 22 131,642.68 154,680.14 177,717.61 _' 786 - 825 1 22 1 135,591.961 159,320.551 183,049.14 Proposed 2016 HUC Non-union Merit Increase Guide for Increases in January 2017 The performance appraisal process is the application of performance standards to past performance. In appraising an employee, these are the basic levels of performance: 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. 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: 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 ( Union % increase is 3%) RICK OAKES BUSINESS MANAGER OCAL. UNION 949 INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS MEM 129D9 NICOLLETAVENUE SOUTH, BURNSVILLE. MINNESOTA 55337 TELEPHONE: 9521890-8484 FAX: 9521890-2241 December 14, 2016 Via Email Jeremy Carter General Manager Hutchinson Utilities Commission 225 Michigan Street Hutchinson MN 55350 Re: Letter of Agreement — Medical 2017 Dear Mr. Carter: This is a Letter of Agreement between Hutchinson Utilities Commission (HUC) and IBEW Local Union 949 regarding the Commission moving the medical plan from Blue Cross Blue Shield to the small group plan with Health Partners for 2017. The Commission has agreed to cover all additional deductible costs and out-of-pocket maximums, above the negotiated limits, through the current Health Reimbursement Account (HRA). This would include in -network deductible costs above $2,500/$5,000 and out -of - network deductible costs above $5,000/$10,000. In addition, it would include out -of -network out-of-pocket maximums above $10,000/$20,000. The Commission will continue to use the HRA that is currently being used. If the above conditions are acceptable, please sign below and return. " I V MIKE O'CONNOR Business Representative IBEW Local 949 JEREMY CARTER General Manager Hutchinson Utilities Commission C/� www.ibewlocW949.org "'�'7 HUC Medical Plan Renewal Information Eir.plcyre Mcntll•; Premium% Sn;alp 20'; Family Emp.oyer Monthly Premiums Single 3C;: Family Total Monthly Premiums Single Employee Single Premiums Employee Family Premiums Deductible (Single/Family) Office Visit Co -pay Ccirsurance Prescriptions HSA Contributions (Single/Family) Annual Out -of -Pocket Exposure (Single/Family) 8CBS 2016 BCdS Jan vary 2017 Renewal $122.20 $131.48 $309.80 $333.34 $488.77 $525.92 5:.239.19 51,333.37 $610.97 I $657.40 $1,548.99 $1,666.71 ISCdS.2017 Renewal Premium.lE.Lpacts Changes (Increases from 2016 Rates) 7.6% increase +S9.28/mo I +$111.36/yr 7.6% increase In -Network $3,000/$6,000 HSA Plan HSA / HRA I Out -of -Network Deductible (Single/Family) $5,000/$10,000 HSA Plan Out-ol Pocket Maximum (Singh -/Family) $10,000/$20,000 HSA / HRA Office Visit Co pay .. . - . Coinsurance 0% after ded' Prescriptions 0% after .•. HSA Conl•ib.rt'or.s {S'rg1(!/Fan1ily) $2,0D0/$4,000 Annual Out -of -Pocket Exposure (Smple/Family) M1S,000 ` h;crrnsrd M Net:vurk cleductihie uffse! h•v mcrr?a•:v HUC HRA n•(mhur.rment funr.,. •i:'r:: ; 00P r.lux.; ul:• :4 !e + I-; RA & HSA Frwq;;L y,., Cow!•I;ut:o^% In -Network 53,000/$6,000 HSA Plan HSA / HRA Out -of -Network $5.000/S10,000 HSA Plan $10,000/$IU,0W HSA / HRA Health.Partners J_'nuary 2017 $112.16 $267.07 $448.62 $1.068.25 $560.78 H_ra lth_Partners 2017 Premium Im yacts Changes (Decreases from 2016 Rates) 8.2% decrease 13.79% decrease In -Network $3,600/$7,200 HSA Plan HSA / HRA Out -of -Network $10,000/$20,000 HSA Plan $30,000/$60,000 HSA / HRA HUTCHINSON UTILITIES COMMISSION m-, Reading z<bedupng wdl -- wRb twit— ze — I billing; -- Reader manpower will be pra Hded by electric and natural gas uldibez. HUTCHINSON UTILITIES COMMISSION MNer Reatling ac�epuling w K remain— cgalom.. service / biging; Mere, Reader manpower — be pr.—d Ey electric and --.1 Baa utilipez. Lighting Retrofit Incentive Application for Business Customers H. LED High or Low -Bay — DLC Listed High -Bay or Low -Bay LED Luminaires Only (See www.DesignLights.org for DLC Qualified Product List) Installed Equipment Specifications (One for One Replacements Only) Incentive Per Unit Quantity Total Incentive <_ 75W Replacing 150 Watt or larger $45.00 LED High -Bay s 110W Replacing 175 Watt or larger $55.00 Or Low -Bay s 160W Replacing 250 Watt or larger $80.00 Replacing HID or <_ 275W Replacing 400 Watt or larger $95.00 721 $68,495 Incandescent < 40OW Replacing 750 Watt or larger $140.00 5 600W Replacing 750 Watt or larger $185.00 <_ 75W Replacing 2 Lamp T5HO or 3 Lamp T8 High Ballast Factor $10.00 LED High -Bay 51low Replacing 2 Lamp T5HO or 3 Lamp T8 High Ballast Factor $10.00 5160W Replacing 3 Lamp T51-10 or 4 Lamp T8 High Ballast Factor $15.00 Or Low -Bay Replacing T8 or TSHO 5 275W Replacing 4 Lamp T5HO or 6 Lamp T8 High Ballast Factor $15.00 Fluorescent 5 40OW Replacing 6 or 8 Lamp T5HO or 12 Lamp T8 High Ballast Factor $25.00 <_ 60OW Replacing 10 Lamp T5HO or 16 Lamp T8 High Ballast Factor $30.00 LED High or Low -Bay Occupancy Sensor • This is an additional incentive to add occupancy sensors to control the high or low - bay LED fixtures listed above. • The presence of occupancy sensor control must be clearly noted on the invoice. 0 High or low -bay occupancy sensor incentives may not be combined with any other $10.00 Per Controlled Fixture Control occupancy sensor incentive. Subtotal $ 68,495 Page 6 of 11 V8.1 3-8-2016 Lighting Retrofit Incentive Application for Business Customers • I hereby certify that: 1. The information contained in this application is accurate and complete: 2. All installation is complete and the unit(s) is operational prior to submitting application; 3. All rules of this incentive program have been followed; 4. 1 have read and understand the terms and conditions applicable to this incentive program as set forth in this application. including those set forth on page 11 below: and 5. Any old lighting equipment replaced has been properly disposed of or recycled in accordance with applicable State and Federal regulations. Replaced equipment must not be reused or sold for use in another location. The customer agrees to verification of equipment installation which may include a site inspection by a program or utility representative. The customer understands that it is not allowed to receive more than one incentive from this program on any piece of equipment. The customer agrees to indemnify. defend. hold harmless and release The Utility from any claims, damages, liabilities. costs and expenses (including reasonable attorneys' fees) arising from or relating to the removal, disposal, installation or operation of any equipment or related materials in connection with the programs described in this application. including any incidental, special or consequential damages. Please sign and complete all information below. Nang iFGoi'�iol,9 a Nancy Eldridge Tice (if applicable) Date Purchasing 111/30/16 Member Utility Use Only Date Received Pre -Inspected? Date Inspected: Post -Inspected? DP t-Inspe ed: 7 t 07-26-2016 -201 12-08- 2016 ® Yes Q No Initials:NN Q1 Yes t7 No Initials: NN Incentive Approved M Yes ZI No Amount :$ 68,495.00 Date Approved 12-08-2016 Utility or Program Representative Nick Nelson BES Page 10 of 11 V8.1 3-8-2016