Loading...
HomeMy WebLinkAbout20121011Knox DI.pdf DAVID J. MEYER VICE PRESIDENT AND CHIEF COUNSEL FOR REGULATORY & GOVERNMENTAL AFFAIRS AVISTA CORPORATION P.O. BOX 3727 1411 EAST MISSION AVENUE SPOKANE, WASHINGTON 99220-3727 TELEPHONE: (509) 495-4316 FACSIMILE: (509) 495-8851 DAVID.MEYER@AVISTACORP.COM BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION IN THE MATTER OF THE APPLICATION ) CASE NO. AVU-E-12-08 OF AVISTA CORPORATION FOR THE ) CASE NO. AVU-G-12-07 AUTHORITY TO INCREASE ITS RATES ) AND CHARGES FOR ELECTRIC AND ) NATURAL GAS SERVICE TO ELECTRIC ) DIRECT TESTIMONY AND NATURAL GAS CUSTOMERS IN THE ) OF STATE OF IDAHO ) TARA L. KNOX ) FOR AVISTA CORPORATION (ELECTRIC AND NATURAL GAS) Knox, Di 1 Avista Corporation I. INTRODUCTION 1 Q. Please state your name, business address and 2 present position with Avista Corporation. 3 A. My name is Tara L. Knox and my business address 4 is 1411 East Mission Avenue, Spokane, Washington. I am 5 employed as a Senior Regulatory Analyst in the State and 6 Federal Regulation Department. 7 Q. Would you briefly describe your duties? 8 A. Yes. I am responsible for preparing the 9 regulatory cost of service models for the Company, as well 10 as providing support for the preparation of results of 11 operations reports. 12 Q. What is your educational background and 13 professional experience? 14 A. I am a graduate of Washington State University 15 with a Bachelor of Arts degree in General Humanities in 16 1982, and a Master of Accounting degree in 1990. As an 17 employee in the State and Federal Regulation Department at 18 Avista since 1991, I have attended several ratemaking 19 classes, including the EEI Electric Rates Advanced Course 20 that specializes in cost allocation and cost of service 21 issues. I have also been a member of the Cost of Service 22 Working Group and the Northwest Pricing and Regulatory 23 Forum, which are discussion groups made up of technical 24 Knox, Di 2 Avista Corporation professionals from regional utilities and utilities 1 throughout the United States and Canada concerned with cost 2 of service issues. 3 Q. What is the scope of your testimony in this 4 proceeding? 5 A. My testimony and exhibits will cover the 6 Company’s electric and natural gas cost of service studies 7 performed for this proceeding. Additionally, I am 8 sponsoring the electric and natural gas revenue 9 normalization adjustments to the test year results of 10 operations and the proposed Load Change Adjustment Rate 11 (LCAR) to be used in the Power Cost Adjustment (PCA). A 12 table of contents for my testimony is as follows: 13 Table of Contents Page 14 I. Introduction 1 15 II. Revenue Normalization 3 16 Electric 3 17 Natural Gas 7 18 III. Proposed Load Change Adjustment Rate 11 19 IV. Electric Cost of Service 13 20 Illustration 1 Base Case Results 21 21 V. Natural Gas Cost of Service 22 22 Illustration 2 Base Case Results 26 23 Q. Are you sponsoring any exhibits in this case? 24 A. Yes. I am sponsoring Exhibit 12 composed of six 25 schedules as follows. Schedule 1, the proposed Load Change 26 Adjustment Rate calculation; Schedule 2, the electric cost 27 of service study process description; Schedule 3, the 28 Knox, Di 3 Avista Corporation electric cost of service study summary results; Schedule 4, 1 the cost of service workshop presentation; Schedule 5, the 2 natural gas cost of service study process description; and 3 Schedule 6, the natural gas cost of service study summary 4 results. 5 Q. Were these exhibits prepared by you or under your 6 direction? 7 A. Yes, they were. 8 II. REVENUE NORMALIZATION 9 Electric Revenue Normalization 10 Q. Would you please describe the electric revenue 11 adjustment included in Company witness Ms. Andrews pro 12 forma results of operations? 13 A. Yes, I will. The electric revenue normalization 14 adjustment represents the difference between the Company’s 15 actual recorded retail revenues during the twelve months 16 ended June 2012 test period, and retail revenues on a 17 normalized (pro forma) basis. The total revenue 18 normalization adjustment increases Idaho net operating 19 income by $1,724,000, as shown in adjustment column 2.09 on 20 page 7 of Ms. Andrews Exhibit No. 10, Schedule 1. The 21 revenue normalization adjustment consists of three primary 22 components: 1) re-pricing customer usage (adjusted for any 23 known and measurable changes) at base tariff rates 24 presently in effect, 2) adjusting customer loads and 25 revenue to a 12-month calendar basis (unbilled revenue 26 Knox, Di 4 Avista Corporation adjustment), and 3) weather normalizing customer usage and 1 revenue1. 2 Q. Since these three elements are combined into a 3 single adjustment, would you please identify the impact 4 (before taxes and revenue related expenses) of each 5 component? 6 A. Yes. The re-pricing of billed usage comprises 7 the majority of the change in test year revenue. The 8 combined impact of the rate increase effective October 1, 9 20112, and the elimination of revenue and amortization 10 expense from adder schedules (Schedule 59 Residential 11 Exchange, Schedule 91 Public Purpose Tariff Rider, Schedule 12 95 Optional Renewable Power, and Schedule 99 DSIT refund)3, 13 is an increase in net revenue of $2,097,000. Re-pricing of 14 unbilled calendar usage and elimination of unbilled adder 15 schedule revenue and expense results in a net revenue 16 increase of $90,0004. Finally, the weather normalization 17 adjustment increases revenue by $530,000. The combined 18 impact of these elements is an increase of $2,717,000 19 which, after revenue-related expenses and income tax, 20 1 Documentation related to this adjustment is detailed in the Knox workpapers accompanying this case. 2 IPUC Case No. AVU-E-11-01. 3 Municipal Franchise Fee and Power Cost Adjustment revenues are eliminated in separate adjustments. 4 The unbilled adjustment consists of removing June 2011 usage billed in July 2011 from the 12 Months Ended June 2012 test year, adding June 2012 usage billed in July 2012 to the 12 Months Ended June 2012 test year, and re-pricing the net adjustment to usage at October 1, 2011 base rates. Knox, Di 5 Avista Corporation results in the increase to net operating income of 1 $1,724,000. 2 Q. Would you please briefly discuss electric weather 3 normalization? 4 A. Yes. The Company’s electric weather 5 normalization adjustment calculates the change in kWh usage 6 required to adjust actual loads during the twelve months 7 ended June 2012 test period to the amount expected if 8 weather had been normal. This adjustment incorporates the 9 effect of both heating and cooling on weather-sensitive 10 customer groups. The weather adjustment is developed from 11 regression analysis of ten years of billed usage per 12 customer and billing period heating and cooling degree-day 13 data. The resulting seasonal weather sensitivity factors 14 (use-per-customer-per-heating-degree day and use-per-15 customer-per-cooling-degree day) are applied to monthly 16 test period customers and the difference between normal 17 heating/cooling degree-days and monthly test period 18 observed heating/cooling degree-days. 19 Q. Have the seasonal weather sensitivity factors 20 been updated since the last rate case? 21 A. Yes. The factors used in the weather adjustment 22 are based on regression analysis of monthly billed usage 23 per customer from January 2001 through December 2010 which 24 Knox, Di 6 Avista Corporation is the most recent completed analysis. Autoregressive 1 terms were included in the regressions in order to correct 2 for autocorrelation in the data. 3 Q. What data did you use to determine “normal” 4 heating and cooling degree days? 5 A. Normal heating and cooling degree days are based 6 on a rolling 30-year average of heating and cooling degree-7 days reported for each month by the National Weather 8 Service for the Spokane Airport weather station. Each year 9 the normal values are adjusted to capture the most recent 10 year with the oldest year dropping off, thereby reflecting 11 the most recent information available at the end of each 12 calendar year. 13 Q. Is this proposed weather adjustment methodology 14 consistent with the methodology utilized in the Company’s 15 last general rate case in Idaho? 16 A. Yes, the process for determining the weather 17 sensitivity factors and the monthly adjustment calculation 18 is consistent with the methodology presented in Case No. 19 AVU-E-11-01. 20 Q. What was the impact of electric weather 21 normalization on the twelve months ended June 2012 test 22 year? 23 Knox, Di 7 Avista Corporation A. Weather was slightly warmer than normal during 1 the winter, and cooler than normal during the spring of 2 2012 as well as the summer of 2011 (with offsetting impacts 3 in June where it was necessary to both deduct heating 4 degree-days and add cooling degree-days). Overall, the 5 adjustment to normal required the addition of only 92 6 heating degree-days during the heating season5 and 4 cooling 7 degree-days during the cooling season. The total 8 adjustment to Idaho sales volumes was an addition of 9 6,207,276 kWhs which is approximately 0.2% of billed usage. 10 Natural Gas Revenue Normalization 11 Q. Would you please describe the natural gas revenue 12 adjustment included in Ms. Andrews pro forma results of 13 operations? 14 A. Yes. The natural gas revenue normalization 15 adjustment is similar to the electric adjustment and 16 represents the difference between the Company’s actual 17 recorded retail revenues during the twelve months ended 18 June 2012 test period and retail revenues on a normalized 19 (pro forma) basis. The adjustment includes the re-pricing 20 of pro forma sales and transportation volumes at present 21 5 The heating season includes the months of October through June. The cooling season includes the months of June through September. The early part of June typically requires heating whereas the end of June typically requires cooling, therefore, for normalization purposes June is treated as both a heating and cooling month. Knox, Di 8 Avista Corporation rates using pro forma sales volumes that have been adjusted 1 for unbilled sales, abnormal weather, and any material 2 customer load or schedule changes. The rates used exclude: 3 1) Temporary Gas Rate Adjustment Schedule 155, which 4 reflects the approved amortization rate for prior deferred 5 natural gas costs approved in the Company’s last PGA 6 filing, 2) Public Purposes Rider Adjustment Schedule 191, 7 and 3) Deferred State Income Tax Adjustment Schedule 1996. 8 Q. Does the Revenue Normalization Adjustment contain 9 a component reflecting normalized natural gas costs? 10 A. Yes. Purchase gas costs are normalized using the 11 natural gas costs approved by the Commission in Case No. 12 AVU-G-12-05, the Company’s 2012 PGA filing, as set forth 13 under Schedule 150. These natural gas costs, effective 14 October 1, 2012, are applied to the pro forma retail sales 15 volumes so that there is a matching of revenues and natural 16 gas costs. 17 Q. Have you determined the impact of each of the 18 components of this adjustment? 19 A. Yes. The re-pricing of billed revenue and 20 natural gas costs increased margin7 by $240,000. Re-pricing 21 6 Documentation related to this adjustment is detailed in the Knox workpapers accompanying this case. 7 The term “margin” in this context consists of revenues less gas costs and adder schedule amortization expenses but does not include the effect of revenue related expenses or income taxes. Knox, Di 9 Avista Corporation unbilled revenue and natural gas costs decreased margin by 1 $116,000, and the weather adjustment at present rates 2 increased margin by $282,000. 3 The total net amount of the natural gas revenue 4 normalization adjustment, which includes the related 5 purchase gas cost normalization, is an increase to net 6 operating income of $275,000, as shown in adjustment column 7 2.01, on page 5 of Ms. Andrews Exhibit No. 10, Schedule 2. 8 Q. Would you please briefly discuss natural gas 9 weather normalization? 10 A. Yes. The natural gas weather normalization 11 adjustment is developed from a regression analysis of ten 12 years of billed usage per customer and billing period 13 heating degree-day data. The resulting seasonal weather 14 sensitivity factors (use-per-customer-per-heating-degree 15 day) are applied to monthly test period customers and the 16 difference between normal heating degree-days and monthly 17 test period observed heating degree-days. This calculation 18 produces the change in therm usage required to adjust 19 existing loads to the amount expected if weather had been 20 normal. 21 Q. In your discussion of electric weather 22 normalization you indicated that the adjustment utilized 23 sensitivity factors from the ten year period January 2001 24 Knox, Di 10 Avista Corporation through December 2010. Is this true for natural gas as 1 well? 2 A. Yes, the natural gas weather adjustment utilized 3 updated weather sensitivity factors. 4 Q. What data did you use to determine “normal” 5 heating degree days? 6 A. Normal heating degree-days are based on a rolling 7 30-year average of heating degree-days reported for each 8 month by the National Weather Service for the Spokane 9 Airport weather station. Each year the normal values are 10 adjusted to capture the most recent year with the oldest 11 year dropping off, thereby reflecting the most recent 12 information available at the end of each calendar year. 13 Q. Is this proposed weather adjustment methodology 14 consistent with the methodology utilized in the Company’s 15 last general rate case in Idaho? 16 A. Yes. The process for determining the weather 17 sensitivity factors and the monthly adjustment calculation 18 are consistent with the methodology presented in Case No. 19 AVU-G-11-01. 20 Q. What was the impact of natural gas weather 21 normalization on the twelve months ended June 2012 test 22 year? 23 Knox, Di 11 Avista Corporation A. Weather was slightly warmer than normal during 1 the fall and winter months, largely offset by a cooler than 2 normal spring. The adjustment to normal required the 3 addition of 92 heating degree-days from October through 4 June.8 The adjustment to sales volumes was an addition of 5 818,604 therms which is approximately 0.7% of billed usage. 6 7 III. PROPOSED LOAD CHANGE ADJUSTMENT RATE 8 Q. What is the Load Change Adjustment Rate? 9 A. The Load Change Adjustment Rate (LCAR) is part of 10 the Power Cost Adjustment (PCA) mechanism that prices the 11 change in power supply-related costs associated with the 12 change in actual retail loads from the retail loads that 13 were used to set the PCA base costs. The LCAR 14 determination process for all Idaho investor-owned 15 utilities was established in IPUC Case No. GNR-E-10-03, 16 Order No. 32206 which was approved on March, 15, 2011. 17 Q. How is the rate determined? 18 A. The proposed LCAR in this case is determined by 19 computing the proposed revenue requirement on the 20 production and transmission costs contained within Ms. 21 Andrews’ Idaho electric pro forma total results of 22 8 Heating degree days that occur during July through September do not impact the natural gas weather normalization adjustment as the seasonal sensitivity factor is zero for summer months. Knox, Di 12 Avista Corporation operations. The production/transmission revenue 1 requirement amount is then divided by the Idaho normalized 2 retail load used to set rates in order to arrive at the 3 average production and transmission cost-per-kWh embedded 4 in proposed rates. This amount is then multiplied by the 5 proportion of production and transmission costs classified 6 as energy-related in the cost of service study. 7 Q. Do you have an exhibit schedule that shows the 8 calculation of the proposed LCAR? 9 A. Yes. Exhibit No. 12, Schedule 1 begins with the 10 identification of the production and transmission revenue, 11 expense and rate base amounts included in each of Ms. 12 Andrews’ actual, restating, and pro forma adjustments to 13 results of operations. The “Pro Forma Total Production and 14 Transmission Costs” on line 32 at the bottom of page 1 15 shows the resulting production and transmission cost 16 components. 17 Page 2 shows the revenue requirement calculation on 18 the production and transmission cost components. The rate 19 of return and debt cost percentages on Line 2 are inputs 20 from the proposed cost of capital. The normalized retail 21 load on Line 10 comes from the workpapers supporting the 22 revenue normalization and energy efficiency load 23 adjustments. Line 11 represents the average total 24 Knox, Di 13 Avista Corporation production and transmission cost-per-kWh proposed to be 1 embedded in Idaho customer retail rates. Lines 12 and 13 2 are values taken from the cost of service study supporting 3 report titled Functional Cost Summary by Classification at 4 Uniform Requested Return representing total costs at unity. 5 Line 12 shows the amount of production and transmission 6 costs classified as energy related, while Line 13 shows the 7 total production and transmission costs in the study. 8 The resulting load change adjustment rate on Line 14 9 is $0.02768 per kWh or $27.68 per MWh. The calculation of 10 the load change adjustment rate will be revised based on 11 the final production and transmission costs, and rate of 12 return, that are approved by the Commission in this case. 13 14 IV. ELECTRIC COST OF SERVICE 15 Q. Please briefly summarize your testimony related 16 to the electric cost of service study. 17 A. I believe the Base Case cost of service study 18 presented in this case is a fair and reasonable 19 representation of the costs to serve each customer group. 20 The Base Case study shows Residential Service Schedule 1, 21 Extra Large General Service Schedule 25, Pumping Service 22 Schedule 31 and the Street and Area Lighting Schedules 23 provide less than the overall rate of return under present 24 Knox, Di 14 Avista Corporation rates. General Service Schedule 11, Large General Service 1 Schedule 21 and Extra Large General Service to Clearwater 2 Paper Schedule 25P provide more than the overall rate of 3 return under present rates. 4 Q. What is an electric cost of service study and 5 what is its purpose? 6 A. An electric cost of service study is an 7 engineering-economic study, which separates the revenue, 8 expenses, and rate base associated with providing electric 9 service to designated groups of customers. The groups are 10 made up of customers with similar load characteristics and 11 facilities requirements. Costs are assigned or allocated 12 to each group based on (among other things), test period 13 load and facilities requirements, resulting in an 14 evaluation of the cost of the service provided to each 15 group. The rate of return by customer group indicates 16 whether the revenue provided by the customers in each group 17 recovers the cost to serve those customers. The study 18 results are used as a guide in determining the appropriate 19 rate spread among the groups of customers. Exhibit No. 12, 20 Schedule 2 explains the basic concepts involved in 21 performing an electric cost of service study. It also 22 details the specific methodology and assumptions utilized 23 in the Company’s Base Case cost of service study. 24 Knox, Di 15 Avista Corporation Q. What is the basis for the electric cost of 1 service study provided in this case? 2 A. The electric cost of service study provided by 3 the Company as Exhibit No. 12, Schedule 3 is based on the 4 twelve months ended June 30, 2012 test year pro forma 5 results of operations presented by Ms. Andrews in Exhibit 6 No. 10, Schedule 1. 7 Q. Would you please explain the cost of service 8 study presented in Exhibit No. 12, Schedule 3? 9 A. Yes. Exhibit No. 12, Schedule 3 is composed of a 10 series of summaries of the cost of service study results. 11 The summary on page 1 shows the results of the study by 12 FERC account category. The rate of return by rate schedule 13 and the ratio of each schedule’s return to the overall 14 return are shown on Lines 39 and 40. This summary was 15 provided to Company witness Mr. Ehrbar for his work on rate 16 spread and rate design. The results will be discussed in 17 more detail later in my testimony. 18 Pages 2 and 3 are both summaries that show the 19 revenue-to-cost relationship at current and proposed 20 revenue. Costs by category are shown first at the existing 21 schedule returns (revenue); next the costs are shown as if 22 all schedules were providing equal recovery (cost). These 23 comparisons show how far current and proposed rates are 24 Knox, Di 16 Avista Corporation from rates that would be in alignment with the cost study. 1 Page 2 shows the costs segregated into production, 2 transmission, distribution, and common functional 3 categories. Line 44 on page 2 shows the target change in 4 revenue which would produce unity in this cost study. Page 5 3 segregates the costs into demand, energy, and customer 6 classifications. Page 4 is a summary identifying specific 7 customer related costs embedded in the study. 8 The Excel model used to calculate the cost of service 9 and supporting schedules has been included in its entirety 10 both electronically and in hard copy in the workpapers 11 accompanying this case. 12 Q. Does the Company’s electric Base Case cost of 13 service study follow the methodology filed in the Company’s 14 last electric general rate case in Idaho? 15 A. In most respects, yes. In the last case (Case 16 No. AVU-E-11-01) the Company’s electric Base Case cost of 17 service study was prepared using the methodology presented 18 in Case No. AVU-E-04-01 through Case No. AVU-E-09-01 except 19 that the peak credit classification of production and 20 transmission costs was revised. While a revision to the 21 peak credit classification of production and transmission 22 costs was also proposed in Case No. AVU-E-10-01, only the 23 classification of transmission costs as 100% demand-related 24 Knox, Di 17 Avista Corporation was accepted as part of the settlement in that case. In 1 this case the Company’s Base Case cost of service study 2 utilizes the study methodology accepted in the Settlement 3 from Case No. AVU-E-10-01.9 4 Q. Given that the specific details of this 5 methodology are described in Exhibit No. 12, Schedule 2, 6 would you please give a brief overview of the key elements 7 and the history associated with those elements? 8 A. Yes. Production costs are classified to energy 9 and demand in this case using the Company’s traditional 10 peak credit assignments derived from replacement cost of 11 plant investment. Transmission costs are classified as 12 100% demand and allocated by the average of the 12 monthly 13 coincident peaks, as accepted in the Settlement in Case No. 14 AVU-E-10-01. 15 Distribution costs are classified and allocated by the 16 basic customer theory10 accepted by the Idaho Commission in 17 Case No. WWP-E-98-11. Additional direct assignment of 18 demand related distribution plant has been incorporated to 19 reflect improvements accepted by the Commission in Case No. 20 AVU-E-04-01. 21 9 This methodology contains only one methodological difference from the studies presented from Case Nos. AVU-E-04-01 through AVU-E-09-01. Namely, transmission costs are classified as 100% demand-related. 10 Basic customer theory classifies only meters, services and street lights as customer-related plant; all other distribution facilities are considered demand-related Knox, Di 18 Avista Corporation Administrative and general costs are first directly 1 assigned to production, transmission, distribution, or 2 customer relations functions. The remaining administrative 3 and general costs are categorized as common costs and have 4 been assigned to customer classes by the four-factor 5 allocator accepted by the Idaho Commission in Case No. AVU-6 E-04-01. 7 Q. The settlement in Case No. AVU-E-11-01 required 8 the convening of a public workshop regarding cost of 9 service issues before the next rate case. Please explain. 10 A. In Order No. 32371 from Case No. AVU-E-11-01 and 11 AVU-G-11-01, the Commission approved an all-party 12 Settlement Stipulation. In Section 10 of the Settlement 13 Stipulation, beginning on page 5 it states: 14 The Parties have agreed to exchange information 15 and convene a public workshop, prior to the 16 Company’s next general rate case, with respect to 17 the method of allocation of demand and energy 18 among the customer classes such as the possible 19 use of a revised peak credit method for 20 classifying production costs, as well as 21 consideration of the use of a 12 Coincident Peak 22 (CP) (whether “weighted” or not) versus a 7 CP or 23 other method for allocating transmission costs. 24 The workshop was convened on September 18, 2012 at the 25 Idaho Public Utilities Commission, and was attended by the 26 Knox, Di 19 Avista Corporation key stakeholders regarding cost of service issues.11 The 1 Company’s presentation from the workshop is included as 2 Schedule 4 of Exhibit No. 12. 3 Q. Was any consensus reached among the Parties 4 regarding the alternative peak credit classification 5 approach? 6 A. No, there was not. Even though the system load 7 factor approach to production peak credit, in the Company’s 8 view, is simple and straightforward, related to the test 9 year under evaluation, and should provide a stable 10 relationship over time, the Parties could not agree that it 11 provides for a better representation of production cost-12 causation than the traditional peak credit methodology. In 13 fact, certain parties suggested potentially removing 14 certain items, such as fuel, from the system load factor 15 methodology and classifying those costs as 100% energy 16 related. 17 Q. Was consensus reached among the parties as it 18 relates to the demand allocation factor for transmission 19 costs? 20 A. No consensus was reached. The general sentiment 21 among the parties on this issue, and even the peak credit 22 11 Parties attending the workshop included Avista, IPUC Staff, Idaho Forest Group, Clearwater Paper, Idaho Conservation League, and Community Action Partnership Association of Idaho (CAPAI). Knox, Di 20 Avista Corporation issue, is that there should be stability in methodology 1 over time, and that modifications to existing practices 2 should be well founded. Enough changes occur in cost 3 recovery relationships stemming from test year differences 4 without layering on changes to how the cost elements are 5 treated through a methodology change. 6 Q. Did the workshop influence your decision to 7 propose the traditional peak credit methodology and 8 unweighted 12CP demand for transmission in this case? 9 A. Yes it did. First, it is important to note that 10 the Company believes that the revised peak credit 11 methodology for classifying production costs into energy 12 and demand components which it proposed in Case No. AVU-E-13 11-01 is a preferable methodology. That being said, some 14 parties at the September 2012 workshop, and IPUC Staff in 15 particular, believe that methodological consistency is very 16 important, and that the Company’s traditional peak credit 17 methodology is a valid approach for production cost 18 classification. 19 With that in mind, as well as to potentially limit the 20 number of issues in this case, Avista is presenting the 21 prior traditional peak credit methodology in the cost of 22 service study. This methodology includes using 12 CP for 23 allocating transmission costs instead of a weighted 12 CP 24 Knox, Di 21 Avista Corporation as proposed in the last case. The Company, however, is 1 proposing to continue to employ the recent change to 2 classify transmission costs as 100% demand-related. 3 Q. What are the results of the Company’s electric 4 cost of service study presented in this case? 5 A. The following Illustration shows the rate of 6 return and the relationship of the customer class return to 7 the overall return (relative return ratio) at present rates 8 for each rate schedule: 9 Illustration 1 10 Customer Class Rate of Return Return Ratio Residential Service Schedule 1 5.74% 0.78 General Service Schedule 11/12 10.26% 1.40 Large General Service Schedule 21/22 8.40% 1.15 Extra Large General Service Schedule 25 7.10% 0.97 Extra Large General Service Clearwater Paper Schedule 25P 8.75% 1.20 Pumping Service Schedule 31/32 6.92% 0.95 Lighting Service Schedules 41 - 49 5.51% 0.75 Total Idaho Electric System 7.32% 1.00 As can be observed from the above table, residential, 11 extra large general service, pumping service and lighting 12 service schedules (1, 25, 31 and 41-49) show under-recovery 13 of the costs to serve them. The general service, large 14 general service, and extra large Clearwater Paper schedules 15 (11, 21, 25P) show over-recovery of the costs to serve 16 Knox, Di 22 Avista Corporation them. The summary results of this study were provided to 1 Mr. Ehrbar as an input into development of the proposed 2 electric rates. 3 4 V. NATURAL GAS COST OF SERVICE 5 Q. Please describe the natural gas cost of service 6 study and its purpose. 7 A. A natural gas cost of service study is an 8 engineering-economic study which separates the revenue, 9 expenses, and rate base associated with providing natural 10 gas service to designated groups of customers. The groups 11 are made up of customers with similar usage characteristics 12 and facility requirements. Costs are assigned in relation 13 to each group’s test year load and facilities requirements, 14 resulting in an evaluation of the cost of the service 15 provided to each group. The rate of return by customer 16 group indicates whether the revenue provided by the 17 customers in each group recovers the cost to serve those 18 customers. The study results are one of the key inputs in 19 determining the appropriate rate spread among the groups of 20 customers. Exhibit No. 12, Schedule 5 explains the basic 21 concepts involved in performing a natural gas cost of 22 service study. It also details the specific methodology 23 Knox, Di 23 Avista Corporation and assumptions utilized in the Company’s Base Case cost of 1 service study. 2 Q. What is the basis for the natural gas cost of 3 service study provided in this case? 4 A. The cost of service study provided by the Company 5 as Exhibit 12, Schedule 6 is based on the twelve months 6 ended June 2012 test year pro forma results of operations 7 presented by Ms. Andrews in Exhibit 10, Schedule 2. 8 Q. Would you please explain the natural gas cost of 9 service study presented in Schedule 6? 10 A. Yes. Exhibit 12, Schedule 6 is composed of a 11 series of summaries of the cost of service study results. 12 Page 1 shows the results of the study by FERC account 13 category. The rate of return, and the ratio of each 14 schedule’s return to the overall return, are shown on lines 15 38 and 39. This summary is provided to Mr. Ehrbar for his 16 work on rate spread and rate design, and the results will 17 be presented later in my testimony. Additional summaries 18 show the costs organized by functional category (page 2) 19 and classification (page 3), including margin and unit cost 20 analysis at current and proposed rates. Finally, page 4 is 21 a summary identifying specific customer related costs 22 embedded in the study. 23 Knox, Di 24 Avista Corporation The Excel model used to calculate the natural gas cost 1 of service and supporting schedules has been included in 2 its entirety both electronically and hard copy in the 3 natural gas workpapers accompanying this case. 4 Q. Does the Natural Gas Base Case cost of service 5 study utilize the methodology from the Company’s last 6 natural gas case in Idaho? 7 A. Yes. The Base Case cost of service study was 8 prepared using the methodology accepted by the Idaho 9 Commission in Case No. AVU-G-04-01, and presented in AVU-G-10 08-01, AVU-G-09-01, AVU-G-10-01 and AVU-G-11-01. 11 Q. What are the key elements that define the cost of 12 service methodology? 13 A. Allocations of natural gas costs reflect the 14 current Purchased Gas Adjustment methodology. Underground 15 storage costs are allocated by normalized winter 16 throughput. 17 Natural gas main investment has been segregated into 18 large and small mains. Large usage customers that take 19 service from large mains do not receive an allocation of 20 small mains. Meter installation and services investment is 21 allocated by number of customers weighted by the relative 22 current cost of those items. System facilities that serve 23 all customers are classified by the peak and average ratio 24 Knox, Di 25 Avista Corporation that reflects the system load factor, then allocated by 1 coincident peak demand and throughput, respectively. 2 General plant is allocated by the sum of all other 3 plant. Administrative & general expenses are segregated 4 into labor-related, plant-related, revenue-related, and 5 “other”. The costs are then allocated by factors 6 associated with labor, plant in service, or revenue, 7 respectively. The “other” A&G amounts get a combined 8 allocation that is one-half based on O&M expenses and one-9 half based on throughput. A detailed description of the 10 methodology is included in Exhibit 12, Schedule 5. 11 Q. What are the results of the Company’s natural gas 12 cost of service study? 13 A. I believe the Base Case cost of service study 14 presented in this filing is a fair and reasonable 15 representation of the costs to serve each customer group. 16 The study indicates that General Service (primarily 17 residential) Schedule 101, Interruptible Service Schedules 18 131/132 and Transportation Service Schedule 146 are 19 providing less than the overall return (unity), and Large 20 General Service Schedules 111/112 are providing more than 21 unity. 22 Knox, Di 26 Avista Corporation The following Illustration shows the rate of return 1 and the relative return ratio at present rates for each 2 rate schedule: 3 Illustration 2 4 Customer Class Rate of Return Return Ratio General Firm Service Schedule 101 5.40% 0.92 Large Firm Service Schedule 111/112 7.98% 1.37 Interruptible Service Schedule 131/132 5.35% 0.92 Transportation Service Schedule 146 4.69% 0.80 Total Idaho Natural Gas System 5.84% 1.00 The summary results of this study were provided to Mr. 5 Ehrbar as an input into development of the proposed rates. 6 Q. Does this conclude your pre-filed direct 7 testimony? 8 A. Yes, it does. 9 DAVID J. MEYER VICE PRESIDENT AND CHIEF COUNSEL FOR REGULATORY & GOVERNMENTAL AFFAIRS AVISTA CORPORATION P.O. BOX 3727 1411 EAST MISSION AVENUE SPOKANE, WASHINGTON 99220-3727 TELEPHONE: (509) 495-4316 FACSIMILE: (509) 495-8851 DAVID.MEYER@AVISTACORP.COM BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION IN THE MATTER OF THE APPLICATION ) CASE NO. AVU-E-12-08 OF AVISTA CORPORATION FOR THE ) CASE NO. AVU-G-12-07 AUTHORITY TO INCREASE ITS RATES ) AND CHARGES FOR ELECTRIC AND ) NATURAL GAS SERVICE TO ELECTRIC ) EXHIBIT NO. 12 AND NATURAL GAS CUSTOMERS IN THE ) STATE OF IDAHO ) TARA L. KNOX ) FOR AVISTA CORPORATION (ELECTRIC AND NATURAL GAS) Line Column Description of Adjustment (000's)Revenue Expense Plant Accumulated Depreciation Deferred Debits/Credits Deferred Tax 1 1.00 Per Results Report 101,316 226,548 585,254 (213,725) 1,765 (61,642) 2 1.01 Deferred FIT Rate Base - - - - - (285) 3 1.02 Deferred Debits and Credits - (64) - - (414) - 4 1.03 Working Capital - - - - - - 5 1.04 Restate 2011 Capital - 236 9,873 (4,733) - (835) 6 2.01 Eliminate B & O Taxes - - - - - - 7 2.02 Uncollect. Expense - - - - - - 8 2.03 Regulatory Expense - - - - - - 9 2.04 Injuries and Damages - - - - - - 10 2.05 FIT/DFIT/ ITC/PTC Expense - - - - - - 11 2.06 ID PCA - (9,871) - - - - 12 2.07 Nez Perce Settlement Adjustment - (18) - - - - 13 2.08 CS2 Levelized - 235 - - - - 14 2.09 Revenue Normalization - 9,635 - - - - 15 2.10 Misc Restating - - - - - - 16 2.11 Restate Incentives - - - - - - 17 2.12 Colstrip / CS2 Maintenance - 1,339 - - - - 18 2.13 Restate Debt Interest - - - - - - 19 3.01 Pro Forma Power Supply (73,823) (76,210) - - - - 20 3.02 Pro Forma Transmission Rev/Exp 371 3 - - - - 21 3.03 Pro Forma Labor Non-Exec - 290 - - - - 22 3.04 Pro Forma Generation Major O&M - 921 - - - - 23 3.05 Pro Forma Employee Benefits - 353 - - - - 24 3.06 Pro Forma Insurance - - - - - - 25 3.07 Pro Forma Property Tax - 380 - - - - 26 3.08 Pro Forma IS/IT Costs - 80 - - - - 27 3.09 Planned Capital Add 2012 - 534 23,728 (13,617) - (1,765) 28 3.10 Planned Capital Add 2013 AMA - 128 6,735 (6,162) - (661) 29 3.11 PF Energy Efficiency Load Adj. - (976) - - - - 30 3.12 O&M Offsets - (35) - - - - 31 3.13 Depreciation Study - (1,780) - - - - 32 Pro Forma Total 27,864 151,728 625,590 (238,237) 1,351 (65,188) Production / Transmission AVISTA UTILITIES AVERAGE PRODUCTION AND TRANSMISSION COST IDAHO ELECTRIC TWELVE MONTHS ENDED JUNE 30, 2012 Exhibit No. 12 Case No. AVU-E-12-08 T. Knox, Avista Schedule 1, p. 1 of 2 AVISTA UTILITIES AVERAGE PRODUCTION AND TRANSMISSION COST IDAHO ELECTRIC TWELVE MONTHS ENDED JUNE 30, 2012 Line ($000's) Debt Cost 1 Prod/Trans Pro Forma Rate Base 323,516 2 Cost of Capital Proposed Rate of Return 8.460% 3.01% 3 Rate Base Net Operating Income Requirement $27,369 4 Tax Effect Net Operating Income Requirement ($3,408) (Rate Base x Debt Cost x -35%) 5 Net Expense Net Operating Income Requirement 123,864 (Expense - Revenue) 6 Tax Effect Net Operating Income Requirement ($43,352) (Net Expense x -.35%) 7 Total Prod/Trans Net Operating Income Requirement $104,473 8 1 - Tax Rate Conversion Factor (Excl. Rev. Rel. Exp.) 0.65 9 Prod/Trans Revenue Requiremen $160,727 10 Test Year WA Normalized Retail Load MWh 3,364,879 with EELA Billing Determinant Adjustment 11 Prod/Trans Rev Requirement per kWh 0.04777$ 12 Cost of Service Energy Classified Production/Transmission Costs $94,413 Company Case at Unity AVU-E-12-08 13 Cost of Service Total Production/Transmission Costs $162,919 Company Case at Unity AVU-E-12-08 14 Load Change Adjustment Rate per kWh (Line 11 * Line 12 / Line 13 0.02768$ Proposed Production and Transmission Revenue Requirement Calculation of Load Change Adjustment Rate Exhibit No. 12 Case No. AVU-E-12-08 T. Knox, Avista Schedule 1, p. 2 of 2 Exhibit No. 12 Case No. AVU-E-12-08 T. Knox, Avista Schedule 2, p. 1 of 9 1. A cost of service study is an engineering-economic study, which apportions the revenue, 2 expenses, and rate base associated with providing electric service to designated groups of 3 customers. It indicates whether the revenue provided by customers recovers the cost to serve those 4 customers. The study results are used as a guide in determining the appropriate rate spread among 5 the groups of customers. 6 ELECTRIC COST OF SERVICE 1 There are three basic steps involved in a cost of service study: functionalization, 7 classification, and allocation. See flow chart below. 8 First, the expenses and rate base associated with the electric system under study are 9 assigned to functional categories. The uniform system of accounts provides the basic segregation 10 into production, transmission, and distribution. Traditionally customer accounting, customer 11 information, and sales expenses are included in the distribution function, and administrative and 12 general expenses and general plant rate base are allocated to all functions. This study includes a 13 separate functional category for common costs. Administrative and general costs that cannot be 14 directly assigned to the other functions have been placed in this category. 15 Second, the expenses and rate base items that cannot be directly assigned to customer 16 groups are classified into three primary cost components: energy, demand or customer related. 17 Energy related costs are allocated based on each rate schedule’s share of commodity consumption. 18 Demand (capacity) related costs are allocated to rate schedules on the basis of each schedule’s 19 contribution to peak demand. Customer related items are allocated to rate schedules based on the 20 number of customers within each schedule. The number of customers may be weighted by 21 appropriate factors such as relative cost of metering equipment. In addition to these three cost 22 components, any revenue related expense is allocated based on the proportion of revenues by rate 23 schedule. 24 Exhibit No. 12 Case No. AVU-E-12-08 T. Knox, Avista Schedule 2, p. 2 of 9 Customer classes shown in this flowchart are illustrative and may not match the Company’s actual rate schedules. 1 Pro Forma Results of Operations by Customer Group 1 ELECTRIC COST OF SERVICE STUDY FLOWCHART TransmissionProduction Common Energy / Commodity Related CustomerRelated Demand / Capacity Related Residential Small General Large General Extra LargeGeneral Pumping Street & AreaLights Allocation Pro Forma Results of Operations Functionalization Distribution and Customer Relations Classification Direct Assignment Number of CustomersWeighted Number of Customers Direct Assignment Coincident PeakNon-Coincident Peak Direct AssignmentGeneration Level mWh's Customer Level mWh's Exhibit No. 12 Case No. AVU-E-12-08 T. Knox, Avista Schedule 2, p. 3 of 9 The final step is allocation of the costs to the various rate schedules utilizing the allocation 1 factors selected for each specific cost item. These factors are derived from usage and customer 2 information associated with the test period results of operations. 3 Production Classification (Traditional Peak Credit) 5 BASE CASE COST OF SERVICE STUDY 4 This study utilizes a Peak Credit methodology to classify production costs into demand and 6 energy classifications. The Peak Credit method acknowledges that baseload production facilities 7 provide energy throughout the year as well as capacity during system peaks. The demand/energy 8 ratio is determined by the relationship of the current replacement cost per KW generating capacity 9 of the Company’s peaking units to the current replacement cost per KW generating capacity of the 10 Company’s thermal or hydro plant. The peak credit ratio for thermal plant is 42.00% to demand 11 and 58.00% to energy. The peak credit ratio for hydro plant is 41.83% to demand and 58.17% to 12 energy. As an intermediate resource (between peaking and baseload), Coyote Springs II has been 13 included with the thermal plant costs, whereas all other plants in the 340 to 349 FERC plant 14 accounts are considered peaking units. Fuel and load dispatching expenses are classified entirely 15 to energy. Peaking plant related costs are classified entirely to demand. Purchased Power and 16 Other Power Supply expenses are classified to demand and energy by the relative amounts of 17 assigned and allocated Production Plant in Service. 18 Production Allocation 19 Production demand related costs are allocated to the customer classes by class contribution 20 to the average of the twelve monthly system coincident peak loads. Although the Company is 21 usually technically a winter peaking utility, it experiences high summer peaks and careful 22 management of capacity requirements is required throughout the year. The use of the average of 23 twelve monthly peaks recognizes that customer capacity needs are not limited to the heating 24 Exhibit No. 12 Case No. AVU-E-12-08 T. Knox, Avista Schedule 2, p. 4 of 9 season. Energy related costs are allocated to class by pro forma annual kilowatt-hour sales 1 adjusted for losses to reflect generation level consumption. 2 Transmission Classification and Allocation 3 Transmission costs are classified as 100% demand related due in part to the fact that the 4 facilities are designed for meeting system peak loads. These costs are then allocated to the 5 customer classes by class contribution to the average of the twelve monthly system coincident peak 6 loads (12CP). The use of the average of twelve monthly peaks recognizes that customer capacity 7 needs are not limited to the heating season. 8 Distribution Facilities Classification (Basic Customer) 9 The Basic Customer method considers only services and meters and directly assigned 10 Street Lighting apparatus (FERC Accounts 369, 370, and 373 respectively) to be customer related 11 distribution plant. All other distribution plant is then considered demand related. This division 12 delineates plant which benefits an individual customer from plant which is part of the system. The 13 basic customer method provides a reasonable, clearly definable division between plant that 14 provides service only to individual customers from plant that is part of the interconnected 15 distribution network. 16 Customer Relations Distribution Cost Classification 17 Customer service, customer information and sales expenses are the core of the customer 18 relations functional unit which is included with the distribution cost category. For the most part 19 they are classified as customer related. Exceptions are sales expenses which are classified as 20 energy related and uncollectible accounts expense which is considered separately as a revenue 21 conversion item. Demand Side Management expenses (if any) recorded in Account 908 would be 22 considered separately from the other customer information costs. 23 Exhibit No. 12 Case No. AVU-E-12-08 T. Knox, Avista Schedule 2, p. 5 of 9 Any demand side management investment and amortization included in base rates would 1 be classified implicitly to demand and energy by the sum of production plant in service, then 2 allocated to rate schedules by coincident peak demand and energy consumption respectively. At 3 this point in time, the Company’s demand side management investments in base rates have been 4 fully amortized except for some minor outstanding loan balances that will remain on the books 5 until satisfied. All current demand side management costs are managed through the Schedule 91 6 Public Purpose Tariff Rider balancing account which is not included in this cost study. 7 Distribution Cost Allocation 8 Distribution demand related costs which cannot be directly assigned are allocated to 9 customer class by the average of the twelve monthly non-coincident peaks for each class. 10 Distribution facilities that serve only secondary voltage customers are allocated by the non-11 coincident peak excluding primary voltage customers or number of customers excluding primary 12 voltage customers. This includes line transformers, services, and secondary voltage overhead or 13 underground conductors and devices. The costs of specific substations and related primary voltage 14 distribution facilities are directly assigned to Extra Large General Service customers based on their 15 load ratio share of the substation capacity from which they receive service. 16 Most customer costs are allocated by average number of customers. Weighted customer 17 allocators have been developed using typical current cost of meters, estimated meter reading time, 18 and direct assignment of billing costs for hand-billed customers. Street and area light customers 19 are excluded from metering and meter reading expenses as their service is not metered. 20 Administrative and General Costs 21 Administrative and general costs which are directly associated with production, 22 transmission, distribution, or customer relations functions are directly assigned to those functions 23 and allocated to customer class by the relevant plant or number of customers. The remainder of 24 Exhibit No. 12 Case No. AVU-E-12-08 T. Knox, Avista Schedule 2, p. 6 of 9 administrative and general costs are considered common costs, and have been left in their own 1 functional category. These common costs are classified by the implicit relationship of energy, 2 demand and customer within the four-factor allocator applied to them. The four-factor allocator 3 consists of a 25% weighting of each of the following: 1) operating & maintenance expenses 4 excluding resource costs, labor expenses, and administrative and general expenses; 2) operating 5 and maintenance labor expenses excluding administrative and general labor expenses; 3) net 6 production, transmission, and distribution plant; and 4) number of customers. 7 Revenue Conversion Items 8 In this study uncollectible accounts and commission fees have been classified as revenue 9 related and are allocated by pro forma revenue. These items vary with revenue and are included in 10 the calculation of the revenue conversion factor. Income tax expense items are allocated to 11 schedules by net income before income tax adjusted by interest expense. 12 For the functional summaries on pages 2 and 3 of the cost of service study, these items are 13 assigned to component cost categories. The revenue related expense items have been reduced to a 14 percent of all other costs and loaded onto each cost category by that ratio. Similarly, income tax 15 items have been reduced to a percent of net income before tax then assigned to cost categories by 16 relative rate base (as is net income). 17 The following matrix outlines the methodology applied in the Company Base Case cost of 18 service study. 19 IPUC Case No. AVU-E-12-08 Methodology Matrix Avista Utilities Idaho Jurisdiction Electric Cost of Service Methodology Line Account Functional Category Classification Allocation Production Plant 1 Thermal Production P = Production Demand/Energy by Thermal Peak Credit D01/E02 Coincident Peak Demand/Annual Generation Level Consumption 2 Hydro Production P = Production Demand/Energy by Hydro Peak Credit D01/E02 Coincident Peak Demand/Annual Generation Level Consumption 3 Other Production (Coyote Springs) P = Production Demand/Energy by Thermal Peak Credit D01/E02 Coincident Peak Demand/Annual Generation Level Consumption 4 Other Production P = Production Demand D01 Coincident Peak Demand (12CP) Transmission Plan 5 All Transmission T = Transmission Demand D01 Coincident Peak Demand (12CP) Distribution Plan 6 360 Land D = Distribution Demand D03 Non-coincident Peak Demand (NCP) 7 361 Structures D = Distribution Demand D04/D05/D06 Direct Assign Large / Non-coincident Peak Demand Excl DA 8 362 Station Equipment D = Distribution Demand D04/D05/D06 Direct Assign Large / Non-coincident Peak Demand Excl DA 9 364 Poles Towers & Fixtures D = Distribution Demand D04/D05/D07/D08 Direct Assign Large & Lights / NCP Excl DA / NCP Secondary 10 365 Overhead Conductors & Devices D = Distribution Demand D04/D05/D07 Direct Assign Large / NCP Excl DA / NCP Secondary 11 366 Underground Conduit D = Distribution Demand D04/D05/D07 Direct Assign Large / NCP Excl DA / NCP Secondary 12 367 Underground Conductors & Devices D = Distribution Demand D04/D05/D07 Direct Assign Large / NCP Excl DA / NCP Secondary 13 368 Line Transformers D = Distribution Demand D07 Non-coincident Peak Demand Secondary 14 369 Services D = Distribution Customer C02 Secondary Customers unweighted Excl Lighting 15 370 Meters D = Distribution Customer C04 Customers weighted by Current Typical Meter Cost 16 373 Street and Area Lighting Systems D = Distribution Customer C05 Direct Assignment to Street and Area Lights General Plan 17 All General O=Other Demand/Energy/Customer by Corp Cost Allocator S23 25% direct O&M, 25% direct labor, 25% net direct plant, 25% number of customers Intangible Plan 18 301 Organization O=Other Energy/Customer by Corp Cost Allocator S23 25% direct O&M, 25% direct labor, 25% net direct plant, 25% number of customers 19 302 Franchises & Consents - Hydro Relicensing P = Production Demand/Energy by Hydro Peak Credit D01/E02 Coincident Peak Demand/Annual Generation Level Consumption 20 303 Misc Intangible Plant - Transmission Agreements T = Transmission Demand D01 Coincident Peak Demand (12CP) 21 303 Misc Intangible Plant - Software O=Other Demand/Energy/Customer by Corp Cost Allocator S23 25% direct O&M, 25% direct labor, 25% net direct plant, 25% number of customers Reserve for Depreciation/Amortizati 22 Intangible P/T/O Follows Related Plant S01/S02/S23 Sum of Production Plant / Sum of Transmission Plant / Corp Cost Allocator 23 Production P = Production Follows Related Plant D01/E02 Coincident Peak Demand/Annual Generation Level Consumption 24 Transmission T = Transmission Follows Related Plant D01 Coincident Peak Demand (12CP) 25 Distribution D = Distribution Follows Related Plant D03/D04/D05/D06/D07/D08/C02/C04/C05 - See Related Plant 26 General O=Other Demand/Energy/Customer by Corp Cost Allocator S23 25% direct O&M, 25% direct labor, 25% net direct plant, 25% number of customers Other Rate Bas 27 252 Customer Advances for Construction D = Distribution Customer S13 Sum of Account 369 Services Plant 28 282/190 Accumulated Deferred Income Tax P/T/D/O Follows Related Plant S01/S02/S03/S04 Sums of Production / Transmission / Distribution / General Plant 29 Gain on Sale of General Office Building O=Other Demand/Energy/Customer by Corp Cost Allocator S23 25% direct O&M, 25% direct labor, 25% net direct plant, 25% number of customers 30 Hydro Relicensing Related Settlements P = Production Demand/Energy by Hydro Peak Credit D01/E02 Coincident Peak Demand/Annual Generation Level Consumption 31 Demand Side Management Investment DSM Demand/Energy from Production Plant S01 Sum of Production Plant 32 Working Capital P/T/D/G Demand/Energy/Customer as in related Plant S06 Sum of Production, Transmission, Distribution, and General Plant Production O& 33 Thermal P = Production Demand/Energy by Thermal Peak Credit D01/E02 Coincident Peak Demand/Annual Generation Level Consumption 34 Thermal Fuel (501) P = Production Energy E02 Annual Generation Level Consumption 35 Hydro P = Production Demand/Energy by Hydro Peak Credit D01/E02 Coincident Peak Demand/Annual Generation Level Consumption Exhibit No. 12 Case No. AVU-E-12-08 T. Knox, Avista Schedule 2, p. 7 of 9 IPUC Case No. AVU-E-12-08 Methodology Matrix Avista Utilities Idaho Jurisdiction Electric Cost of Service Methodology Line Account Functional Category Classification Allocation Production O&M (continued) 1 Water for Power (536) P = Production Energy E02 Annual Generation Level Consumption 2 Other (Coyote Springs) P = Production Demand/Energy by Thermal Peak Credit D01/E02 Coincident Peak Demand/Annual Generation Level Consumption 3 Other Fuel (547) P = Production Energy E02 Annual Generation Level Consumption 4 Other P = Production Demand D01 Coincident Peak Demand (12CP) 5 Purchased Power and Other Expenses (555 and 557) P = Production Demand/Energy from Production Plant S01 Sum of Production Plant 6 System Control & Misc (556 ) P = Production Energy E02 Annual Generation Level Consumption Transmission O& 7 All Transmission T = Transmission Demand D01 Coincident Peak Demand (12CP) Distribution O& 8 580 OP Super & Engineering D = Distribution Demand/Customer from Other Dist Op Exp S16 Sum of Other Distribution Operating Expenses 9 581 Load Dispatching D = Distribution Demand D03 Non-coincident Peak Demand 10 582 Station Expenses D = Distribution Demand S09 Sum of Account 362 Station Equipment 11 583 Overhead Lines D = Distribution Demand S10 Sum of Accounts 364 and 365 Poles, Towers, Fixtures & Overhead Conductors 12 584 Underground Lines D = Distribution Demand S11 Sum of Accounts 366 and 367 Underground Conduit & Underground Conductors 13 585 Street Lights D = Distribution Customer S15 Sum of Account 373 Street Light and Signal Systems 14 586 Meters D = Distribution Customer S14 Sum of Account 370 Meters 15 587 Customer Installations D = Distribution Customer S13 Sum of Account 369 Services 16 588 Misc Operating Expense D = Distribution Demand/Customer from Other Dist Op Exp S16 Sum of Other Distribution Operating Expenses 17 589 Rents D = Distribution Demand D03 Non-coincident Peak Demand 18 590 MT Super & Engineering D = Distribution Demand/Customer from Other Dist Mt Exp S17 Sum of Other Distribution Maintenance Expenses 19 591 MT of Structures D = Distribution Demand S08 Sum of Account 361 Structures & Improvements 20 592 MT of Station Equipment D = Distribution Demand S09 Sum of Account 362 Station Equipment 21 593 MT of Overhead Lines D = Distribution Demand S10 Sum of Accounts 364 and 365 Poles, Towers, Fixtures & Overhead Conductors 22 594 MT of Underground Lines D = Distribution Demand S11 Sum of Accounts 366 and 367 Underground Conduit & Underground Conductors 23 595 MT of Line Transformers D = Distribution Demand S12 Sum of Account 368 Line Transformers 24 596 MT of Street Lights D = Distribution Customer S15 Sum of Account 373 Street Light and Signal Systems 25 597 MT of Meters D = Distribution Customer S14 Sum of Account 370 Meters 26 598 Misc Maintenance Expense D = Distribution Demand/Customer from Other Dist Mt Exp S17 Sum of Other Distribution Maintenance Expenses Customer Accounts Expense 27 901 Supervision C = Customer Relations Customer S18 Sum of Other Customer Accounts Expenses Excluding Uncollectibles 28 902 Meter Reading C = Customer Relations Customer C03/C06 Customers Weighted by Est. Meter Reading Time/Direct Assign Handbilled Cu 29 903 Customer Records & Collections C = Customer Relations Customer C01/C06 All Customers unweighted / Direct Assign Handbilled Cust 30 904 Uncollectible Accounts R = Revenue Conversion Revenue R01 Retail Sales Revenue 31 905 Misc Cust Accounts C = Customer Relations Customer C01 All Customers unweighted Customer Service & Info Expense 32 907 Supervision C = Customer Relations Customer C01 All Customers unweighted 33 908 Customer Assistance C = Customer Relations Customer C01 All Customers unweighted 34 908 DSM Amortization Expenses DSM Demand/Energy from Production Plant S01 Sum of Production Plant 35 909 Advertising C = Customer Relations Customer C01 All Customers unweighted 36 910 Misc Cust Service & Info C = Customer Relations Customer C01 All Customers unweighted Sales Expense 37 911 - 916 C = Customer Relations Energy E02 Annual Generation Level Consumption Exhibit No. 12 Case No. AVU-E-12-08 T. Knox, Avista Schedule 2, p. 8 of 9 IPUC Case No. AVU-E-12-08 Methodology Matrix Avista Utilities Idaho Jurisdiction Electric Cost of Service Methodology Line Account Functional Category Classification Allocation Admin & General Expenses 1 920 - 927 & 930 -935 Assigned to Production P = Production Demand/Energy from Production Plant S01 Sum of Production Plant 2 920 - 927 & 930 -935 Assigned to Transmission T = Transmission Demand/Energy from Transmission Plant S02 Sum of Transmission Plant 3 920 - 927 & 930 - 935 Assigned to Distribution D = Distribution Demand/Customer from Distribution Plant S03 Sum of Distribution Plant 4 920 - 927 & 930 - 935 Assigned to Customer Relations C = Customer Relations Customer C01 All Customers unweighted 5 920 - 935 Assigned to Other O=Other Demand/Energy/Customer by Corp Cost Allocator S23 25% direct O&M, 25% direct labor, 25% net direct plant, 25% number of customers 6 928 FERC Commission Fees P = Production Energy E02 Annual Generation Level Consumption 7 928 IPUC Commission Fees R = Revenue Conversion Revenue R01 Retail Sales Revenue Depreciation & Amortization Expen 8 Intangible P/T/O Demand/Energy/Customer as in related Plant S01/S02/S23 Sum of Production Plant / Sum of Transmission Plant / Corp Cost Alloctor 9 Production P = Production Demand/Energy by Peak Credit as in related Plant D01/E02 Coincident Peak Demand/Annual Generation Level Consumption 10 Transmission T = Transmission Demand D01 Coincident Peak Demand (12CP) 11 Distribution D = Distribution Demand/Customer as in related Plant D03/D04/D05/D06/D07/D08/C02/C04/C05 - See Related Plant 12 General O=Other Demand/Energy/Customer by Corp Cost Allocator S23 25% direct O&M, 25% direct labor, 25% net direct plant, 25% number of customers Taxes 13 Property Tax P/T/D/O Demand/Energy/Customer from related Plant S01/S02/S03/S04 Sums of Production / Transmission / Distribution / General Plant 14 State kWh Generation Taxes P = Production Demand/Energy by 1/2 Fuel, 1/2 Transmission D01/E02 Coincident Peak Demand/Annual Generation Level Consumption 15 Misc Production Taxes P = Production Demand/Energy by 1/2 Fuel, 1/2 Transmission D01/E02 Coincident Peak Demand/Annual Generation Level Consumption 16 Misc Distribution Taxes D = Distribution Demand/Customer from Distribution Plant S03 Sum of Distribution Plant 17 Idaho State Income Tax R = Revenue Conversion Revenue R03 Revenue less Expenses Before Income Taxes less Interest Expense 18 Federal Income Tax R = Revenue Conversion Revenue R03 Revenue less Expenses Before Income Taxes less Interest Expense 19 Deferred FIT R = Revenue Conversion Revenue R03 Revenue less Expenses Before Income Taxes less Interest Expense Other Income Related Item 20 CS2 Levelized Return and Boulder Write-off Amort. P = Production Demand/Energy by Peak Credit as in related Plant D01/E02 Coincident Peak Demand/Annual Generation Level Consumption Operating Revenue 21 Sales of Electricity- Retail R = Revenue from Rates Revenue Input Pro Forma Revenue per Revenue Study 22 Sales for Resale (447) P = Production Demand/Energy from Production Plant S01 Sum of Production Plant 23 Misc Service Revenue (451) D = Distribution Demand/Customer from Distribution Plant S03 Sum of Distribution Plant 24 Sales of Water & Water Power (453) P = Production Demand D01 Coincident Peak Demand (12CP) 25 Rent from Production Property (454) P = Production Demand/Energy from Production Plant S01 Sum of Production Plant 26 Rent from Transmission Property (454) T = Transmission Demand/Energy from Transmission Plant S02 Sum of Transmission Plant 27 Rent from Distribution Property (454) D = Distribution Demand/Customer from Distribution Plant S03 Sum of Distribution Plant 28 Other Electric Revenues - Generation (456) P = Production Demand/Energy from Production Plant S01 Sum of Production Plant 29 Other Electric Revenues - Wheeling (456) T = Transmission Demand/Energy from Transmission Plant S02 Sum of Transmission Plant 30 Other Electric Revenues - Energy Delivery (456) D = Distribution Demand/Customer from Distribution Plant S03 Sum of Distribution Plant Salaries & Wages (allocation factor inpu Operation & Maintenance Expenses 31 Production Total P = Production Demand/Energy from Production Plant S01 Sum of Production Plant 32 Transmission Total T = Transmission Demand/Energy from Transmission Plant S02 Sum of Transmission Plant 33 Distribution Total D = Distribution Demand/Customer from Distribution Plant S03 Sum of Distribution Plant 34 Customer Accounts Total C = Customer Relations Customer S18 Sum of Other Customer Accounts Expenses Excluding Uncollectibles 35 Customer Service Total C = Customer Relations Customer C01 All Customers unweighted 36 Sales Total C = Customer Relations Energy E02 Annual Generation Level Consumption 37 Admin & General Total O=Other Energy/Customer by Corp Cost Allocator S23 25% direct O&M, 25% direct labor, 25% net direct plant, 25% number of customers Exhibit No. 12 Case No. AVU-E-12-08 T. Knox, Avista Schedule 2, p. 9 of 9 Sumcost VISTA UTILITIES Idaho Jurisdiction Scenario: AVU-E-12-08 Company Cas Cost of Service Basic Summary Electric Utility 10-10-12 VU-E-10-01 Settlement Method For the Twelve Months Ended June 30, 2012 Transmission By Demand 12 CP (b) (c) (d) (e) (f) (g) (h) (i) (j) (k) (l) (m) Residential General Large Gen Extra Large Extra Large Pumping Street & System Service Service Service Gen Service Service CP Service rea Lights Description Total Sch 1 Sch 11-12 Sch 21-22 Sch 25 Sch 25P Sch 31-32 Sch 41-49 Plant In Service 1 Production Plant 402,565,000 149,638,011 40,682,236 80,301,297 34,458,283 89,941,661 6,239,766 1,303,746 2 Transmission Plant 193,225,000 78,729,256 19,788,854 37,732,611 15,884,481 37,989,699 2,676,142 423,958 3 Distribution Plant 449,614,000 225,605,267 64,270,329 110,145,165 9,287,020 2,737,865 15,430,461 22,137,894 4 Intangible Plant 54,867,000 23,810,109 6,166,529 9,958,073 3,823,947 9,725,364 922,792 460,186 5 General Plant 88,487,000 48,015,959 11,628,726 13,352,814 3,786,351 8,559,695 1,659,918 1,483,536 6 Total Plant In Service 1,188,758,000 525,798,603 142,536,673 251,489,960 67,240,083 148,954,284 26,929,078 25,809,319 ccum Depreciation 7 Production Plant (174,598,000) (64,910,989) (17,644,862) (34,826,500) (14,943,998) (39,000,750) (2,705,768) (565,134) 8 Transmission Plant (66,055,000) (26,914,017) (6,764,925) (12,899,095) (5,430,195) (12,986,982) (914,853) (144,932) 9 Distribution Plant (151,682,000) (75,312,738) (20,623,837) (37,302,715) (2,961,053) (731,153) (5,147,372) (9,603,132) 10 Intangible Plant (11,443,000) (5,817,267) (1,434,259) (1,838,075) (587,737) (1,397,545) (207,226) (160,891) 11 General Plant (34,403,000) (18,668,200) (4,521,151) (5,191,462) (1,472,101) (3,327,937) (645,362) (576,786) 12 Total Accumulated Depreciation (438,181,000) (191,623,212) (50,989,034) (92,057,846) (25,395,084) (57,444,367) (9,620,582) (11,050,875) 13 Net Plant 750,577,000 334,175,391 91,547,639 159,432,113 41,844,999 91,509,917 17,308,496 14,758,444 14 ccumulated Deferred FIT (119,554,000) (52,622,048) (14,256,245) (25,204,201) (6,885,548) (15,403,257) (2,673,478) (2,509,223) 15 Miscellaneous Rate Base 8,007,000 3,223,674 914,043 1,813,323 519,015 1,185,858 181,919 169,167 16 Total Rate Base 639,030,000 284,777,017 78,205,437 136,041,236 35,478,467 77,292,518 14,816,938 12,418,388 17 Revenue From Retail Rates 248,720,000 99,497,000 32,432,000 51,400,000 16,036,000 41,091,000 4,859,000 3,405,000 18 Other Operating Revenues 29,727,000 11,482,225 3,089,386 5,992,225 2,405,525 6,094,169 487,054 176,415 19 Total Revenues 278,447,000 110,979,225 35,521,386 57,392,225 18,441,525 47,185,169 5,346,054 3,581,415 Operating Expenses 20 Production Expenses 121,242,000 43,633,193 12,198,017 24,352,993 10,513,928 28,163,848 1,945,460 434,561 21 Transmission Expenses 10,671,000 4,347,884 1,092,855 2,083,813 877,233 2,098,011 147,792 23,413 22 Distribution Expenses 11,311,000 5,419,369 1,684,669 2,570,085 255,627 97,643 373,434 910,172 23 Customer Accounting Expenses 4,343,000 3,248,473 675,400 175,647 64,162 113,336 53,439 12,544 24 Customer Information Expenses 601,000 490,809 96,818 6,057 44 5 6,640 626 25 Sales Expenses 4,000 1,357 399 813 355 991 68 17 26 Admin & General Expenses 23,863,000 12,589,773 3,107,324 3,796,522 1,066,358 2,428,810 461,067 413,147 27 Total O&M Expenses 172,035,000 69,730,858 18,855,482 32,985,930 12,777,706 32,902,644 2,987,901 1,794,479 28 Taxes Other Than Income Taxes 9,171,000 3,795,741 1,035,428 1,938,010 614,626 1,454,900 187,375 144,920 29 Other Income Related Items 397,000 141,952 39,907 79,851 34,515 92,913 6,413 1,450 Depreciation Expense 30 Production Plant Depreciation 8,771,000 3,284,857 887,308 1,746,702 748,439 1,941,191 134,816 27,687 31 Transmission Plant Depreciation 3,550,000 1,446,443 363,568 693,237 291,835 697,961 49,167 7,789 32 Distribution Plant Depreciation 13,770,000 6,991,324 2,124,901 3,257,960 269,195 48,617 474,761 603,243 33 General Plant Depreciation 9,283,000 5,037,261 1,219,947 1,400,818 397,219 897,981 174,139 155,635 34 Amortization Expense 472,000 185,047 48,113 93,090 39,422 98,111 6,905 1,312 35 Total Depreciation Expense 35,846,000 16,944,931 4,643,837 7,191,808 1,746,110 3,683,860 839,788 795,666 36 Income Tax 14,195,000 4,008,667 2,920,617 3,773,418 747,990 2,285,559 298,625 160,125 37 Total Operating Expenses 231,644,000 94,622,149 27,495,271 45,969,016 15,920,947 40,419,875 4,320,102 2,896,640 38 Net Income 46,803,000 16,357,077 8,026,115 11,423,208 2,520,578 6,765,294 1,025,952 684,775 39 Rate of Return 7.32% 5.74% 10.26% 8.40% 7.10% 8.75% 6.92% 5.51% 40 Return Ratio 1.00 0.78 1.40 1.15 0.97 1.20 0.95 0.75 41 Interest Expense 19,235,000 8,571,876 2,354,008 4,094,883 1,067,913 2,326,529 445,994 373,797 42 Revenue Related Operating Expenses 1,259,000 503,646 164,168 260,183 81,173 207,999 24,596 17,236 Exhibit No. 12 Case No. AVU-E-12-08 T. Knox, Avista Schedule 3, p. 1 of 4 Sumcost VISTA UTILITIES Idaho Jurisdiction Scenario: AVU-E-12-08 Company Cas Revenue to Cost by Functional Component Summary Electric Utility 10-10-12 VU-E-10-01 Settlement Method For the Twelve Months Ended June 30, 2012 Transmission By Demand 12 CP (b) (c) (d) (e) (f) (g) (h) (i) (j) (k) (l) (m) Residential General Large Gen Extra Large Extra Large Pumping Street & System Service Service Service Gen Service Service CP Service rea Lights Description Total Sch 1 Sch 11-12 Sch 21-22 Sch 25 Sch 25P Sch 31-32 Sch 41-49 Functional Cost Components at Current Return by Schedul 1 Production 136,364,788 47,060,028 14,621,765 27,931,027 11,690,137 32,448,878 2,150,089 462,864 2 Transmission 21,689,704 7,685,638 2,701,310 4,544,899 1,736,647 4,692,231 288,429 40,550 3 Distribution 55,412,989 26,385,511 10,099,956 13,372,398 1,092,762 369,065 1,760,044 2,333,253 4 Common 35,252,519 18,365,822 5,008,969 5,551,676 1,516,454 3,580,826 660,438 568,334 5 Total Current Rate Revenue 248,720,000 99,497,000 32,432,000 51,400,000 16,036,000 41,091,000 4,859,000 3,405,000 Expressed as $/kWh 6 Production $0.04053 $0.04180 $0.04412 $0.04129 $0.03896 $0.03770 $0.03809 $0.03328 7 Transmission $0.00645 $0.00683 $0.00815 $0.00672 $0.00579 $0.00545 $0.00511 $0.00292 8 Distribution $0.01647 $0.02344 $0.03048 $0.01977 $0.00364 $0.00043 $0.03118 $0.16774 9 Common $0.01048 $0.01631 $0.01512 $0.00821 $0.00505 $0.00416 $0.01170 $0.04086 10 Total Current Melded Rates $0.07392 $0.08837 $0.09787 $0.07599 $0.05344 $0.04774 $0.08608 $0.24480 Functional Cost Components at Uniform Current Return 11 Production 135,669,121 48,969,282 13,654,976 27,233,957 11,751,370 31,407,161 2,170,311 482,063 12 Transmission 21,490,270 8,756,180 2,200,894 4,196,579 1,766,654 4,225,172 297,638 47,152 13 Distribution 56,126,482 29,467,448 8,428,038 12,355,724 1,110,937 330,840 1,813,571 2,619,924 14 Common 35,434,128 19,156,149 4,648,672 5,391,551 1,525,634 3,446,346 667,697 598,078 15 Total Uniform Current Cost 248,720,000 106,349,060 28,932,579 49,177,812 16,154,596 39,409,519 4,949,216 3,747,217 Expressed as $/kWh 16 Production $0.04032 $0.04349 $0.04121 $0.04026 $0.03916 $0.03649 $0.03845 $0.03466 17 Transmission $0.00639 $0.00778 $0.00664 $0.00620 $0.00589 $0.00491 $0.00527 $0.00339 18 Distribution $0.01668 $0.02617 $0.02543 $0.01827 $0.00370 $0.00038 $0.03213 $0.18835 19 Common $0.01053 $0.01701 $0.01403 $0.00797 $0.00508 $0.00400 $0.01183 $0.04300 20 Total Current Uniform Melded Rates $0.07392 $0.09446 $0.08731 $0.07271 $0.05383 $0.04578 $0.08768 $0.26940 21 Revenue to Cost Ratio at Current Rates 1.00 0.94 1.12 1.05 0.99 1.04 0.98 0.91 Functional Cost Components at Proposed Return by Schedul 22 Production 140,184,410 48,492,742 14,991,954 28,713,644 12,016,444 33,285,836 2,212,176 471,615 23 Transmission 23,642,289 8,489,027 2,892,935 4,935,990 1,896,563 5,067,511 316,703 43,559 24 Distribution 59,930,158 28,698,341 10,740,181 14,513,912 1,189,616 399,779 1,924,395 2,463,934 25 Common 36,356,143 18,958,890 5,146,930 5,731,454 1,565,377 3,688,875 682,726 581,892 26 Total Proposed Rate Revenue 260,113,000 104,639,000 33,772,000 53,895,000 16,668,000 42,442,000 5,136,000 3,561,000 Expressed as $/kWh 27 Production $0.04166 $0.04307 $0.04524 $0.04245 $0.04004 $0.03867 $0.03919 $0.03391 28 Transmission $0.00703 $0.00754 $0.00873 $0.00730 $0.00632 $0.00589 $0.00561 $0.00313 29 Distribution $0.01781 $0.02549 $0.03241 $0.02146 $0.00396 $0.00046 $0.03409 $0.17714 30 Common $0.01080 $0.01684 $0.01553 $0.00847 $0.00522 $0.00429 $0.01210 $0.04183 31 Total Proposed Melded Rates $0.07730 $0.09294 $0.10191 $0.07968 $0.05554 $0.04931 $0.09099 $0.25601 Functional Cost Components at Uniform Requested Return 32 Production 139,481,645 50,383,935 14,040,165 27,994,752 12,077,948 32,260,841 2,229,521 494,483 33 Transmission 23,437,170 9,549,442 2,400,283 4,576,766 1,926,703 4,607,949 324,602 51,424 34 Distribution 60,656,479 31,751,124 9,094,204 13,465,411 1,207,871 362,167 1,970,308 2,805,394 35 Common 36,537,706 19,741,741 4,792,223 5,566,316 1,574,598 3,556,553 688,952 617,321 36 Total Uniform Cost 260,113,000 111,426,243 30,326,875 51,603,244 16,787,120 40,787,511 5,213,383 3,968,622 Expressed as $/kWh 37 Production $0.04145 $0.04475 $0.04237 $0.04139 $0.04025 $0.03748 $0.03950 $0.03555 38 Transmission $0.00697 $0.00848 $0.00724 $0.00677 $0.00642 $0.00535 $0.00575 $0.00370 39 Distribution $0.01803 $0.02820 $0.02744 $0.01991 $0.00403 $0.00042 $0.03491 $0.20169 40 Common $0.01086 $0.01753 $0.01446 $0.00823 $0.00525 $0.00413 $0.01221 $0.04438 41 Total Uniform Melded Rates $0.07730 $0.09897 $0.09152 $0.07629 $0.05594 $0.04738 $0.09236 $0.28532 42 Revenue to Cost Ratio at Proposed Rates 1.00 0.94 1.11 1.04 0.99 1.04 0.99 0.90 43 Current Revenue to Proposed Cost Ratio 0.96 0.89 1.07 1.00 0.96 1.01 0.93 0.86 44 Target Revenue Increase 11,393,000 11,929,000 (2,105,000)203,000 751,000 (303,000)354,000 564,000Exhibit No. 12 Case No. AVU-E-12-08 T. Knox, Avista Schedule 3, p. 2 of 4 Sumcost VISTA UTILITIES Idaho Jurisdiction Scenario: AVU-E-12-08 Company Cas Revenue to Cost By Classification Summary Electric Utility 10-10-12 VU-E-10-01 Settlement Method For the Twelve Months Ended June 30, 2012 Transmission By Demand 12 CP (b) (c) (d) (e) (f) (g) (h) (i) (j) (k) (l) (m) Residential General Large Gen Extra Large Extra Large Pumping Street & System Service Service Service Gen Service Service CP Service rea Lights Description Total Sch 1 Sch 11-12 Sch 21-22 Sch 25 Sch 25P Sch 31-32 Sch 41-49 Cost Classifications at Current Return by Schedul 1 Energ 99,505,249 32,531,602 10,437,176 20,531,033 8,737,229 25,198,840 1,669,300 400,069 2 Demand 121,741,170 48,056,898 16,472,134 30,165,949 7,258,252 15,886,884 2,788,487 1,112,567 3 Custome 27,473,580 18,908,500 5,522,690 703,018 40,519 5,276 401,213 1,892,364 4 Total Current Rate Revenue 248,720,000 99,497,000 32,432,000 51,400,000 16,036,000 41,091,000 4,859,000 3,405,000 Expressed as Unit Cos 5 Energ $/kWh $0.02957 $0.02889 $0.03150 $0.03035 $0.02912 $0.02927 $0.02957 $0.02876 6 Demand $/kW/mo $16.47 $17.46 $20.82 $17.41 $13.03 $12.27 $12.54 $26.84 7 Custome $/Cust/mo $18.54 $15.62 $23.13 $47.07 $375.18 $439.66 $24.50 $1,225.62 Cost Classifications at Uniform Current Return 8 Energ 98,939,877 33,556,100 9,876,410 20,114,130 8,774,446 24,521,928 1,682,297 414,565 9 Demand 121,619,568 52,793,443 14,088,965 28,393,268 7,339,470 14,882,475 2,859,134 1,262,812 10 Custome 28,160,555 19,999,517 4,967,205 670,413 40,679 5,116 407,785 2,069,840 11 Total Uniform Current Cost 248,720,000 106,349,060 28,932,579 49,177,812 16,154,596 39,409,519 4,949,216 3,747,217 Expressed as Unit Cos 12 Energ $/kWh $0.02940 $0.02980 $0.02980 $0.02974 $0.02924 $0.02849 $0.02980 $0.02980 13 Demand $/kW/mo $16.45 $19.18 $17.81 $16.39 $13.18 $11.50 $12.86 $30.47 14 Custome $/Cust/mo $19.00 $16.53 $20.81 $44.89 $376.66 $426.35 $24.91 $1,340.57 15 Revenue to Cost Ratio at Current Rates 1.00 0.94 1.12 1.05 0.99 1.04 0.98 0.91 Cost Classifications at Proposed Return by Schedule 16 Energ 101,745,475 33,300,372 10,651,891 20,999,090 8,935,553 25,742,689 1,709,204 406,677 17 Demand 129,723,846 51,611,403 17,384,713 32,156,285 7,691,075 16,693,907 3,005,406 1,181,057 18 Custome 28,643,678 19,727,226 5,735,396 739,625 41,372 5,404 421,389 1,973,266 19 Total Proposed Rate Revenue 260,113,000 104,639,000 33,772,000 53,895,000 16,668,000 42,442,000 5,136,000 3,561,000 Expressed as Unit Cos 20 Energ $/kWh $0.03024 $0.02958 $0.03214 $0.03105 $0.02978 $0.02991 $0.03028 $0.02924 21 Demand $/kW/mo $17.55 $18.75 $21.98 $18.56 $13.81 $12.89 $13.52 $28.49 22 Custome $/Cust/mo $19.33 $16.30 $24.02 $49.52 $383.08 $450.36 $25.74 $1,278.02 Cost Classifications at Uniform Requested Return 23 Energ 101,178,013 34,315,179 10,099,826 20,569,136 8,972,935 25,076,643 1,720,353 423,943 24 Demand 129,574,068 56,303,142 15,038,521 30,328,109 7,772,653 15,705,622 3,066,004 1,360,017 25 Custome 29,360,919 20,807,922 5,188,529 706,000 41,533 5,247 427,026 2,184,662 26 Total Uniform Cost 260,113,000 111,426,243 30,326,875 51,603,244 16,787,120 40,787,511 5,213,383 3,968,622 Expressed as Unit Cos 27 Energ $/kWh $0.03007 $0.03048 $0.03048 $0.03041 $0.02990 $0.02913 $0.03048 $0.03048 28 Demand $/kW/mo $17.53 $20.45 $19.01 $17.50 $13.96 $12.13 $13.79 $32.81 29 Custome $/Cust/mo $19.81 $17.19 $21.73 $47.27 $384.56 $437.26 $26.08 $1,414.94 30 Revenue to Cost Ratio at Proposed Rates 1.00 0.94 1.11 1.04 0.99 1.04 0.99 0.90 31 Current Revenue to Proposed Cost Ratio 0.96 0.89 1.07 1.00 0.96 1.01 0.93 0.86 32 nnual Consumption (mWh's) 3,364,879 1,125,882 331,376 676,398 300,092 860,777 56,445 13,910 33 Monthly Average NCP Demand (kW) 615,990 229,407 65,917 144,389 46,413 107,884 18,526 3,454 34 Monthly Average Number of Customers 123,495 100,853 19,895 1,245 9 1 1,364 129 Exhibit No. 12 Case No. AVU-E-12-08 T. Knox, Avista Schedule 3, p. 3 of 4 Sumcost VISTA UTILITIES Idaho Jurisdiction Scenario: AVU-E-12-08 Company Cas Customer Cost Analysis Electric Utility 10-10-12 VU-E-10-01 Settlement Method For the Twelve Months Ended June 30, 2012 Transmission By Demand 12 CP (b) (c) (d) (e) (f) (g) (h) (i) (j) (k) (l) (m) Residential General Large Gen Extra Large Extra Large Pumping Street & System Service Service Service Gen Service Service CP Service rea Lights Description Total Sch 1 Sch 11-12 Sch 21-22 Sch 25 Sch 25P Sch 31-32 Sch 41-49 Rate Base 1 Services 45,622,000 37,307,157 7,359,316 450,806 0 0 504,721 0 2 Services Accum. Depr. (16,622,000) (13,592,556) (2,681,306) (164,247) 0 0 (183,891) 0 3 Total Services 29,000,000 23,714,602 4,678,010 286,558 0 0 320,830 0 4 Meters 20,634,000 11,920,038 6,231,158 1,759,439 35,061 6,159 682,146 0 5 Meters Accum. Depr. (1,530,000) (883,864) (462,037) (130,461) (2,600) (457) (50,581) 0 6 Total Meters 19,104,000 11,036,173 5,769,121 1,628,977 32,461 5,702 631,565 0 7 Total Rate Base 48,104,000 34,750,775 10,447,131 1,915,536 32,461 5,702 952,395 0 8 Return on Rate Base @ 8.46% 4,069,603 2,939,919 883,828 162,054 2,746 482 80,573 0 9 Revenue Conversion Facto 0.63711 0.63711 0.63711 0.63711 0.63711 0.63711 0.63711 0.63711 10 Rate Base Revenue Requiremen 6,387,629 4,614,482 1,387,253 254,360 4,310 757 126,467 0 Expenses 11 Services Depr Exp 1,255,000 1,026,270 202,445 12,401 0 0 13,884 0 12 Meters Depr Exp 1,533,000 885,597 462,943 130,717 2,605 458 50,680 0 13 Services Operations Exp 333,000 272,309 53,716 3,290 0 0 3,684 0 14 Meters Operating Exp 545,000 314,841 164,582 46,472 926 163 18,017 0 15 Meters Maintenance Exp 29,000 16,753 8,758 2,473 49 9 959 0 16 Meter Reading 430,000 336,412 66,362 4,152 16,671 1,852 4,551 0 17 Billing 2,945,000 2,402,643 473,952 29,652 2,865 318 32,505 3,065 18 Total Expenses 7,070,000 5,254,824 1,432,757 229,157 23,116 2,800 124,280 3,065 19 Revenue Conversion Facto 0.995010 0.995010 0.995010 0.995010 0.995010 0.995010 0.995010 0.995010 20 Expense Revenue Requiremen 7,105,456 5,281,177 1,439,943 230,306 23,232 2,814 124,904 3,081 21 13,493,085 9,895,660 2,827,195 484,666 27,542 3,571 251,370 3,081 22 Total Customer Bills 1,481,940 1,210,233 238,734 14,936 108 12 16,373 1,544 23 Average Unit Cost per Month $9.11 $8.18 $11.84 $32.45 $255.02 $297.57 $15.35 $2.00 24 Total Customer Related Cost 29,360,919 20,807,922 5,188,529 706,000 41,533 5,247 427,026 2,184,662 25 Customer Related Unit Cost per Month $19.81 $17.19 $21.73 $47.27 $384.56 $437.26 $26.08 $1,414.94 26 Total Distribution Demand Related Cost 51,861,024 24,639,071 7,079,654 15,152,454 1,384,083 426,568 1,989,689 1,189,506 27 Dist Demand Related Unit Cost per Month $35.00 $20.36 $29.65 $1,014.49 $12,815.59 $35,547.33 $121.52 $770.41 28 Total Distribution Unit Cost per Month $54.81 $37.55 $51.39 $1,061.76 $13,200.15 $35,984.59 $147.60 $2,185.34 Meter, Services, Meter Reading & Billing Costs by Schedule at Requested Rate of Return Total Meter, Service, Meter Reading, and Distribution Fixed Costs per Customer Exhibit No. 12 Case No. AVU-E-12-08 T. Knox, Avista Schedule 3, p. 4 of 4 Avista Utilities Cost of Service / Rate Design Workshop September 18, 2012 IPUC Workshop Exhibit No. 12 Case Nos. AVU-E-12-08 and AVU-G-12-07 T. Knox, Avista Schedule 4, Page 1 of 14 Settlement Stipulation (AVU-E-11-01) 10. Cost of Service. The Parties have agreed to exchange information and convene a public workshop, prior to the Company’s next general rate case, with respect to the method of allocation of demand and energy among the customer classes such as the possible use of a revised peak credit method for classifying production costs, as well as consideration of the use of a 12 Coincident Peak (CP) (whether “weighted” or not) versus a 7 CP or other method for allocating transmission costs. This workshop will also address the merits of inclining or declining block rates for service schedules 11, 21, 25 and 31. 2 Exhibit No. 12 Case Nos. AVU-E-12-08 and AVU-G-12-07 T. Knox, Avista Schedule 4, Page 2 of 14 Workshop Topics Item # 1 – Peak Credit Classification Method Item # 2 – Allocation of Transmission Costs Item # 3 – Merits of Inclining or Declining Block Rates 3 Exhibit No. 12 Case Nos. AVU-E-12-08 and AVU-G-12-07 T. Knox, Avista Schedule 4, Page 3 of 14 Item #1 - Peak Credit Classification Method 1.Review Previous Peak Credit Methodology 2.Discuss Avista Proposed Peak Credit Methodology 3.Why the change is preferable from Avista’s viewpoint 4.Is the Proposed Peak Credit Methodology stable over time? 4 Exhibit No. 12 Case Nos. AVU-E-12-08 and AVU-G-12-07 T. Knox, Avista Schedule 4, Page 4 of 14 Item #1 - Peak Credit Classification Method (continued) 5 Prior Method Avista’s electric system resource costs were classified to energy and demand using a comparison of the replacement cost-per-kW of the Company’s peaking units, to the replacement cost-per-kW of the Company’s thermal and hydro generating facilities (separately). •Created separate peak credit ratios applied to thermal plant and hydro plant. •Transmission costs were assigned to energy and demand by a 50/50 weighting of the thermal and hydro peak credit ratios. •Fuel and load dispatching expenses were classified entirely to energy. •Peaking plant related costs were classified entirely to demand. Exhibit No. 12 Case Nos. AVU-E-12-08 and AVU-G-12-07 T. Knox, Avista Schedule 4, Page 5 of 14 Item #1 - Peak Credit Classification Method (continued) 6 Proposed Method Uses the system load factor to determine peak credit ratio. •Stemmed from discussions at the February 2011 Cost of Service workshop. •The Classification ratio is applied to all production costs. •Calculation: One minus the load factor equals the demand percentage or peak credit ratio. Net effect – slightly increases the overall production costs that are classified as demand-related. •Using the prior method, approximately 32% of total production costs were classified as demand-related. •Under the proposed load factor peak credit method, 36.4% of total production costs would be classified as demand-related. Exhibit No. 12 Case Nos. AVU-E-12-08 and AVU-G-12-07 T. Knox, Avista Schedule 4, Page 6 of 14 Item #1 - Peak Credit Classification Method (continued) 7 Why does Avista view this methodology to be preferable? •Tied to the Company’s actual use of the system in the test year. •Actual load factor represents current use of the system vs. historical replacement cost analysis which is based on vintage investments. •Less complicated single ratio applied to all production costs vs. multiple ratios, weight dependent on each cost item’s relationship to plant investment. •Overall weighted demand/energy relationship stays the same when power costs are updated – not impacted by swings in the cost of fuel, unlike prior method. Exhibit No. 12 Case Nos. AVU-E-12-08 and AVU-G-12-07 T. Knox, Avista Schedule 4, Page 7 of 14 Item #1 - Peak Credit Classification Method (continued) 8 Will the new methodology provide a “stable” demand/energy classification over time? •Avista believes the proposed method will be more consistent over time versus the prior method. •Proposed method demand proportion has varied from 34% to 39% in the last 5 years – a range of 5%. •Prior method demand proportion has varied from 23% to 34% in the last 5 years – a range of 11% (driven in part by the cost of fuel) Exhibit No. 12 Case Nos. AVU-E-12-08 and AVU-G-12-07 T. Knox, Avista Schedule 4, Page 8 of 14 Item #2 – Allocation of Transmission Costs 9 Historically, transmission costs were included in the production peak credit classification as they were considered extension of generation facilities •Demand classified portion allocated to customer classes by 12 CP (average of the 12 monthly system coincident peak hours) In the Settlement approved in AVU-E-10-01, the methodology was changed to now classify transmission costs as 100% demand. •This is consistent with traditional NARUC approach. •While the Settlement approved transmission classification as 100% demand, it kept the 12 CP allocation and required February 2011 workshop to discuss alternatives. •In the AVU-E-11-01 general rate case, Avista proposed a weighted 12 CP allocation for transmission costs (stemming from February 2011 workshop discussions). Exhibit No. 12 Case Nos. AVU-E-12-08 and AVU-G-12-07 T. Knox, Avista Schedule 4, Page 9 of 14 Item #2 – Allocation of Transmission Costs (continued) 10 Workshop Discussion – “consideration of the use of a 12 CP (whether “weighted” or not) versus a 7 CP or other method for allocating transmission costs”. 1.12 CP (average of the monthly system coincident peaks) •Captures relative contribution to demand throughout the year •Aligns with FERC Open Access transmission cost methodology 2.Weighted 12 CP - see Handout •Weighted by Relative Monthly System Peaks •Captures seasonal impacts of capacity utilization 3.7 CP (average of 4 winter and 3 summer monthly system coincident peaks) •Assumes no transmission demand cost in shoulder months Exhibit No. 12 Case Nos. AVU-E-12-08 and AVU-G-12-07 T. Knox, Avista Schedule 4, Page 10 of 14 Item #3 – Merits of Inclining or Declining Block Rates for Schedules 11, 21, 25 and 31 11 Exhibit No. 12 Case Nos. AVU-E-12-08 and AVU-G-12-07 T. Knox, Avista Schedule 4, Page 11 of 14 Present Base Rates Schedule 1 (Residential) Basic Charge $5.25 First 600 kWh 7.848¢ Over 600 kWh 8.764¢ Schedule 11 (General Service) Basic charge $10.00 First 3,650 kWh 9.338¢ Over 3,650 kWh 6.958¢ Demand over 20 kW $5.25 Schedule 21 (Large General Service) First 250,000 kWh 6.039¢ Over 250,000 kWh 5.154¢ Demand 1st 50 kW $350 Over 50 kW $4.75 Schedule 25 (Extra Large General Service) First 500,000 kWh 5.047¢ Over 500,000 kWh 4.275¢ Demand 1st 3,000 kVa $12,500 Over 3,000 kVa $4.50 Schedule 31 (Pumping) Basic charge $8.00 1st block 8.939¢ 2nd block 8.939¢ 3rd block 7.620¢ 12 Exhibit No. 12 Case Nos. AVU-E-12-08 and AVU-G-12-07 T. Knox, Avista Schedule 4, Page 12 of 14 Support for Declining Block Rates – Schedules 11, 21, and 25: Generally, the incremental fixed costs required to provide service to commercial and industrial customers do not increase proportionately with increasing energy usage. –As most of the Company’s fixed costs of service are recovered through the energy charges (and demand charges where applicable), larger use customers are generally less costly to serve than smaller use customers on an embedded cost per kWh basis, as fixed costs are spread over a larger base of usage. –Within the Company’s commercial and industrial schedules, there is also a substantial range of energy usage. Therefore, declining block rates for commercial and industrial customers generally reflect the cost of providing service within rate schedules, as well as across rate schedules. Implementing rate structure changes can create potential customer bill volatility resulting from the new rate structure. 13 Exhibit No. 12 Case Nos. AVU-E-12-08 and AVU-G-12-07 T. Knox, Avista Schedule 4, Page 13 of 14 Merits for Inclining Block Rates: •Sends a conservation price signal, and penalizes large users. •Can promote fuel conversion – electric to natural gas fuel switching for residential customers. 14 Exhibit No. 12 Case Nos. AVU-E-12-08 and AVU-G-12-07 T. Knox, Avista Schedule 4, Page 14 of 14 Exhibit No. 12 Case No. AVU-G-12-07 T. Knox, Avista Schedule 5, p. 1 of 9 A cost of service study is an engineering-economic study, which apportions the revenue, 2 expenses, and rate base associated with providing natural gas service to designated groups of 3 customers. It indicates whether the revenue provided by customers recovers the cost to serve those 4 customers. The study results are used as a guide in determining the appropriate rate spread among 5 the groups of customers. 6 NATURAL GAS COST OF SERVICE STUDY 1 There are three basic steps involved in a cost of service study: functionalization, 7 classification, and allocation. See flow chart. 8 First, the expenses and rate base associated with the natural gas system under study are 9 assigned to functional categories. The uniform system of accounts provides the basic segregation 10 into production, underground storage, and distribution. Traditionally customer accounting, 11 customer information, and sales expenses are included in the distribution function and 12 administrative and general expenses and general plant rate base are allocated to all functions. This 13 study includes a separate functional category for common costs. Administrative and general costs 14 that cannot be directly assigned to the other functions have been placed in this category. 15 Second, the expenses and rate base items are classified into three primary cost components: 16 Demand, commodity or customer related. Demand (capacity) related costs are allocated to rate 17 schedules on the basis of each schedule’s contribution to system peak demand. Commodity 18 (energy) related costs are allocated based on each rate schedule’s share of commodity 19 consumption. Customer related items are allocated to rate schedules based on the number of 20 customers within each schedule. The number of customers may be weighted by appropriate 21 factors such as relative cost of metering equipment. In addition to these three cost components, 22 any revenue related expense is allocated based on the proportion of revenues by rate schedule. 23 Exhibit No. 12 Case No. AVU-G-12-07 T. Knox, Avista Schedule 5, p. 2 of 9 Customer classes shown in this flowchart are illustrative and may not match the Company’s actual rate schedules. 1 Pro Forma Results of Operations by Customer Group 1 NATURAL GAS COST OF SERVICE STUDY FLOWCHART Underground Storage Production / Purchased Gas Cost Distribution and Customer Relations Energy / Commodity Related Customer Related Demand / Capacity Related Residential Small General Large General Interruptible Transportation Pro Forma Results of Operations Functionalization Common Classification Allocation Direct AssignmentThroughputSales Therms Firm Therms Direct AssignmentCoincident PeakNon-Coincident Peak Direct AssignmentNumber of CustomersWeighted Number of Customers Exhibit No. 12 Case No. AVU-G-12-07 T. Knox, Avista Schedule 5, p. 3 of 9 The final step is allocation of the costs to the various rate schedules utilizing the allocation 1 factors selected for each specific cost item. These factors are derived from usage and customer 2 information associated with the test period results of operations. 3 Production - Purchased Gas Costs 5 BASE CASE COST OF SERVICE STUDY 4 The Company has no natural gas production facilities to serve its retail customers. The 6 natural gas costs included in the production function include the cost of gas purchased to serve 7 sales customers, pipeline transportation to get it to our system, and expenses of the gas supply 8 department. 9 The demand and commodity components of account 804 have been determined directly 10 from the weighted average cost of gas (WACOG) approved in the most recent purchased gas 11 adjustment (PGA) filing effective October 1, 2012. The allocation of these costs agrees with the 12 gas costs computation used to determine pro forma results of operations. 13 The expenses of the gas supply department recorded in account 813 are classified as 14 commodity related costs. The gas scheduling process includes transportation customers, so 15 estimated scheduling dispatch labor expenses are allocated by throughput. The remaining gas 16 supply department expenses are allocated by sales volumes. 17 Underground Storage 18 Underground storage rate base, operating and maintenance expenses are classified as 19 commodity related and allocated to customer groups by winter throughput. This approach was 20 proposed by commission Staff and accepted by the Idaho Public Utilities Commission in Case No. 21 AVU-G-04-01. 22 23 Exhibit No. 12 Case No. AVU-G-12-07 T. Knox, Avista Schedule 5, p. 4 of 9 Distribution Facilities Classification (Peak and Average) 1 Distribution mains and regulator station equipment (both general use and city gate stations) 2 are classified Demand and Commodity using the peak and average ratio for the distribution 3 system. Peak demand is defined as the average of the five-day sustained peaks from the most 4 recent three years. Average daily load is calculated by dividing annual throughput by 365 (days in 5 the year). The average daily load is divided by peak load to arrive at the system load factor of 6 34.40%. This proportion is classified as commodity related. The remaining 65.60% is classified 7 as demand related. Meters, services and industrial measuring & regulating equipment are 8 classified as customer related distribution plant. Distribution operating and maintenance expenses 9 are classified (and allocated) in relation to the plant accounts they are associated with. 10 Customer Relations Distribution Cost Classification 11 Customer service, customer information and sales expenses are the core of the customer 12 relations functional unit which is included with the distribution cost category. For the most part 13 these costs are classified as customer related. Exceptions include uncollectible accounts expense, 14 which is considered separately as a revenue conversion item, and any Demand Side Management 15 amortization expense recorded in Account 908. Any demand side management investment costs 16 and amortization expense included in base rates would be included with the distribution function 17 and classified to demand and commodity by the peak and average ratio. At this point in time, the 18 Company’s demand side management investments in base rates have been fully amortized. All 19 current demand side management costs are managed through the Schedule 191 Public Purpose 20 Tariff Rider balancing account which is not included in this cost study. 21 Distribution Cost Allocation 22 Demand related distribution costs are allocated to customer groups (rate schedules) by each 23 groups’ contribution to the three year average five-day sustained peak. Commodity related 24 Exhibit No. 12 Case No. AVU-G-12-07 T. Knox, Avista Schedule 5, p. 5 of 9 distribution costs are allocated to customer groups by annual throughput. Distribution main 1 investment has been segregated into large and small mains. Small mains are defined as less than 2 four inches, with large mains being four inches or greater. The small main costs use the same 3 demand and commodity data, but large usage customers (Schedules 131, and 146) that connect to 4 large system mains have been excluded from the allocations. 5 Most customer related costs are allocated by the annualized number of customers billed 6 during the test period. Meter investment costs are allocated using the number of customers 7 weighted by the relative current cost of meters in service at December 31, 2011. Services 8 investment costs are allocated using the number of customers weighted by the relative current cost 9 of typical service installations. Industrial measuring and regulating equipment investment costs 10 are allocated by number of turbine meters which effectively excludes small usage customers. 11 Administrative and General Costs 12 General and intangible rate base items are allocated by the sum of Underground Storage 13 and Distribution plant. Administrative and general expenses are segregated into plant related, 14 labor related, revenue related and other. The plant related items are allocated based on total plant 15 in service. Labor related items are allocated by operating and maintenance labor expense. 16 Revenue related items are allocated by pro forma revenue. Other administrative and general 17 expenses are allocated 50% by annual throughput (classified commodity related) and 50% by the 18 sum of operating and maintenance expenses not including purchased gas cost or administrative & 19 general expenses. Whenever costs are allocated by sums of other items within the study, 20 classifications are imputed from the relationship embedded in the summed items. 21 Special Contract Customer Revenue 22 Three special contract customers receive transportation service from the Company. Rates 23 for these customers were individually negotiated to cover any incremental costs and retain some 24 Exhibit No. 12 Case No. AVU-G-12-07 T. Knox, Avista Schedule 5, p. 6 of 9 contribution to margin. The rates for these customers are not being adjusted in this case. The 1 revenue from these special contract customers has been segregated from general rate revenue and 2 allocated back to all the other rate classes by relative rate base. In treating these revenues like 3 other operating revenues their system contribution reduces costs for all rate schedules. 4 Revenue Conversion Items 5 In this study uncollectible accounts and commission fees have been classified as revenue 6 related and are allocated by pro forma revenue. These items vary with revenue and are included in 7 the calculation of the revenue conversion factor. Income tax expense items are allocated to 8 schedules by net income before income tax less interest expense. 9 For the functional summaries on pages 2 and 3 of the cost of service study, these items are 10 assigned to the component cost categories. The revenue related expense items have been reduced 11 to a percent of all other costs and loaded onto each cost category b that ratio. Similarly, income 12 tax items have been assigned to cost categories by relative rate base (as is net income). 13 The following matrix outlines the methodology applied in the Company Base Case natural 14 gas cost of service study. 15 IPUC Case No. AVU-G-12-07 Methodology Matrix Avista Utilities Idaho Jurisdiction Natural Gas Cost of Service Methodology Line Account Functional Category Classification Allocation Underground Storage Plant 1 350 - 357 Underground Storage Underground Storage Commodity E08 Winter throughput Distribution Plan 2 374 Land Distribution Demand/Commodity/Customer from Other Dist Plant S05 Sum of accounts 376-385 3 375 Structures Distribution Demand/Commodity/Customer from Other Dist Plant S05 Sum of accounts 376-385 4 376(S) Small Mains Distribution Demand/Commodity by Peak & Average D02/E06 Coincident peak, annual therms (both excl lg use cust) 5 376(L) Large Mains Distribution Demand/Commodity by Peak & Average D01/E01 Coincident peak (all), annual throughput (all) 6 378 M&R General Distribution Demand/Commodity by Peak & Average D01/E01 Coincident peak (all), annual throughput (all) 7 379 M&R City Gate Distribution Demand/Commodity by Peak & Average D01/E01 Coincident peak (all), annual throughput (all) 8 380 Services Distribution Customer C02, Customers weighted by current typical service co 9 381 Meters Distribution Customer C03, Customers weighted by average current meter co 10 385 Industrial M&R Distribution Customer C06, Large use customers 11 387 Other Distribution Demand/Commodity/Customer from Other Dist Plant S05 Sum of accounts 376-385 General Plant 12 389-399 All General Plant Common Demand/Commodity/Customer from UG & D Plant S03 Sum of Underground Storage and Distribution Plant in Service Intangible Plant 13 303 Misc Intangible Plant Distribution Demand/Commodity/Customer from Dist Plant S15 Sum of Distribution Plant in Service 14 303 Computer Software Common Demand/Commodity/Customer from UG & D Plant S03 Sum of Underground Storage and Distribution Plant in Service Reserve for Depreciatio 15 Underground Storage Underground Storage Commodity same as related plant Allocations linked to related plant accounts 16 Distribution Distribution Demand/Commodity/Customer same as related plant Allocations linked to related plant accounts 17 General Common Demand/Commodity/Customer same as related plant Allocations linked to related plant accounts 18 Intangible Distribution/Common Demand/Commodity/Customer same as related plant Allocations linked to related plant accounts Other Rate Bas 19 Accumulated Deferred FIT All Demand/Commodity/Customer from Plant in Service S17 Sum of Total Plant in Service 20 Constuction Advances Distribution Customer C10 Residential only 21 Gas Inventory Underground Storage Commodity from Underground Storage Plant S14 Sum of Underground Storage Plant in Service 22 Gain on Sale of Office Bldg Common Demand/Commodity/Customer from UG & D Plant S03 Sum of Underground Storage and Distribution Plant in Service 23 DSM Investment Distribution Demand/Commodity by Peak & Average D01/E01 Coincident peak (all), annual throughput (all) Purchased Gas Expenses 24 804 Purchased Gas Cost Production Demand/Commodity from PGA Tracker WACOG D05/E07 PGA Demand / PGA Commodity 25 813 Other Gas Expenses Production Commodity E01/E04 Annual Throughput / Annual Sales Therms Underground Storage O&M 26 814 - 837 Underground Storage Exp Underground Storage Commodity E08 Winter throughput Exhibit No. 12 Case No. AVU-G-12-07 T. Knox, Avista Schedule 5, p. 7 of 9 IPUC Case No. AVU-G-12-07 Methodology Matrix Avista Utilities Idaho Jurisdiction Natural Gas Cost of Service Methodology Line Account Functional Category Classification Allocation Distribution O&M 1 870 OP Super & Engineering Distribution Demand/Commodity/Customer from Dist Plant S15 Sum of Distribution Plant in Service 2 871 Load Dispatching Distribution Commodity E01 Annual throughput 3 874 Mains & Services Distribution Demand/Commodity/Customer from related plant S06 Sum of Mains and Services Plant in Service 4 875 M&R Station - General Distribution Demand/Commodity from related plant S08 Sum of Meas & Reg Station - General Plant in Service 5 876 M&R Station - Industrial Distribution Customer from related plant S19 Sum of Meas & Reg Station - Industrial Plant in Service 6 877 M&R Station - City Gate Distribution Demand/Commodity from related plant S09 Sum of Meas & Reg Station - City Gate Plant in Service 7 878 Meter & House Regulator Distribution Customer from related plant S07 Sum of Meter and Installation Plant in Service 8 879 Customer Installations Distribution Customer C05, Customers weighted by average current meter co 9 880 Other OP Expenses Distribution Demand/Commodity/Customer from other dist expensesS04 Sum of Accounts 870 - 879 and 881 - 894 10 881 Rents Distribution Demand/Commodity/Customer from other dist expensesS04 Sum of Accounts 870 - 879 and 881 - 894 11 885 MT Super & Engineering Distribution Demand/Commodity/Customer from Dist Plant S15 Sum of Distribution Plant in Service 12 886 MT of Structures Distribution Demand/Commodity/Customer from Other Dist Plant S05 Sum of accounts 376-385 13 887 MT of Mains Distribution Demand/Commodity from related plant S21 Sum of Distribution Mains Plant in Service 14 889 MT of M&R General Distribution Demand/Commodity from related plant S08 Sum of Meas & Reg Station - General Plant in Service 15 890 MT of M&R Industrial Distribution Customer from related plant S19 Sum of Meas & Reg Station - Industrial Plant in Service 16 891 MT of M&R City Gate Distribution Demand/Commodity from related plant S09 Sum of Meas & Reg Station - City Gate Plant in Service 17 892 MT of Services Distribution Customer from related plant S20 Sum of Services Plant in Services 18 893 MT of Meters & Hs Reg Distribution Customer from related plant S07 Sum of Meter and Installation Plant in Service 19 894 MT of Other Equipment Distribution Demand/Commodity/Customer from Dist Plant S15 Sum of Distribution Plant in Service Customer Accounting Expense 20 901 Supervision Customer Relations Customer C01 All customers (unweighted) 21 902 Meter Reading Customer Relations Customer C01 All customers (unweighted) 22 903 Customer Records & Collections Customer Relations Customer C01 All customers (unweighted) 23 904 Uncollectible Accounts Revenue Conversion Revenue R03 Retail Sales Revenue 24 905 Misc Cust Accounts Customer Relations Customer C01 All customers (unweighted) Customer Service & Info Expense 25 907 Supervision Customer Relations Customer C01 All customers (unweighted) 26 908 Customer Assistance Customer Relations Customer C01 All customers (unweighted) 27 908 DSM Amortization Distribution Demand/Commodity by Peak & Average D01/E01 Coincident peak (all), annual throughput (all) 28 909 Advertising Customer Relations Customer C01 All customers (unweighted) 29 910 Misc Cust Service & Info Customer Relations Customer C01 All customers (unweighted) Sales Expense 30 911 - 916 Sales Expenses Customer Relations Customer C01 All customers (unweighted) Exhibit No. 12 Case No. AVU-G-12-07 T. Knox, Avista Schedule 5, p. 8 of 9 IPUC Case No. AVU-G-12-07 Methodology Matrix Avista Utilities Idaho Jurisdiction Natural Gas Cost of Service Methodology Line Account Functional Category Classification Allocation Admin & General Expense 1 920 Salaries Common Demand/Commodity/Customer from Other O&M S02/E01 50% O&M excl Gas Purchases and A&G / 50% throughput 2 921 Office Supplies Common Demand/Commodity/Customer from Other O&M S02/E01 50% O&M excl Gas Purchases and A&G / 50% throughput 3 922 Admin Expense Transferred - Credit Common Demand/Commodity/Customer from Other O&M S02/E01 50% O&M excl Gas Purchases and A&G / 50% throughput 4 923 Outside Services Common Demand/Commodity/Customer from Other O&M S02/E01 50% O&M excl Gas Purchases and A&G / 50% throughput 5 924 Property Insurance Common Demand/Commodity/Customer from Plant in Service S17 Sum of Total Plant in Service 6 925 Injuries & Damages Common Demand/Commodity/Customer from Other O&M S02/E01 50% O&M excl Gas Purchases and A&G / 50% throughput 7 926 Pensions & Benefits Common Demand/Commodity/Customer from Labpr O&M S13 O&M Labor Expense 8 927 Franchise Requirements Common Demand/Commodity/Customer from Other O&M S02/E01 50% O&M excl Gas Purchases and A&G / 50% throughput 9 928 Regulatory Commision Common Demand/Commodity/Customer from Other O&M S02/E01 50% O&M excl Gas Purchases and A&G / 50% throughput 10 928 Commission Fees Revenue Conversion Revenue R01 Retail Sales Revenue 11 930 Miscellaneous General Common Demand/Commodity/Customer from Other O&M S02/E01 50% O&M excl Gas Purchases and A&G / 50% throughput 12 931 Rents Common Demand/Commodity/Customer from Other O&M S02/E01 50% O&M excl Gas Purchases and A&G / 50% throughput 13 935 MT of General Plant Common Demand/Commodity/Customer from Plant in Service S17 Sum of Total Plant in Service Depreciation Expens 14 Underground Storage Underground Storage Commodity same as related plant Allocations linked to related plant accounts 15 Distribution Distribution Demand/Commodity/Customer same as related plant Allocations linked to related plant accounts 16 General Common Demand/Commodity/Customer same as related plant Allocations linked to related plant accounts 17 Intangible Distribution/Common Demand/Commodity/Customer same as related plant Allocations linked to related plant accounts Taxes 18 Property Tax All Demand/Commodity/Customer from related plant S14/S15/S16 Sum of UG Plant/Sum of Dist Plant/Sum of Gen Plant 19 Miscellaneous Dist Tax Distribution Demand/Commodity/Customer from Dist Plant S15 Sum of Distribution Plant in Service 20 State Income Tax Revenue Conversion Revenue R02 Net Income before Taxes less Interest Expense 21 Federal Income Tax Revenue Conversion Revenue R02 Net Income before Taxes less Interest Expense 22 Deferred FIT Revenue Conversion Revenue R02 Net Income before Taxes less Interest Expense 23 ITC Revenue Conversion Revenue R02 Net Income before Taxes less Interest Expense Operating Revenues 24 Revenue from Rates Revenue Revenue Pro Forma Revenue per Revenue Study 25 Special Contract Revenue All Demand/Commodity/Customer from Rate Base S01 Sum of Rate Base 26 Off System Sales Production Commodity from PGA Tracker E04 Sales Therms 27 Miscellaneous Service Revenue Distribution Demand/Commodity/Customer from Dist Plant S15 Sum of Distribution Plant in Service 28 Rent From Gas Property All Demand/Commodity/Customer from Rate Base S01 Sum of Rate Base 29 Other Gas Revenue Underground Storage Commodity from Underground Storage Plant S14 Sum of Underground Storage Plant in Service Exhibit No. 12 Case No. AVU-G-12-07 T. Knox, Avista Schedule 5, p. 9 of 9 Sumcost AVISTA UTILITIES Natural Gas Utility Company Base Case Cost of Service General Summary Idaho Jurisdiction 10-Oct-12 AVU-G-04-01 Method For the Year Ended June 30, 2012 (b) (c) (d) (e) (f) (g) (h) (j) (k) Residential Large Firm Interrupt Transport System Service Service Service Service Line Description Total Sch 101 Sch 111 Sch 131 Sch 146 Plant In Service 1 Production Plant 2 Underground Storage Plant 10,832,000 7,986,151 2,606,033 40,792 199,024 3 Distribution Plant 160,940,000 134,562,866 24,897,046 381,443 1,098,645 4 Intangible Plant 2,880,000 2,391,170 460,142 7,063 21,625 5 General Plant 21,237,000 17,624,022 3,400,338 52,203 160,437 6 Total Plant In Service 195,889,000 162,564,209 31,363,559 481,502 1,479,731 Accum Depreciation 7 Production Plant 8 Underground Storage Plant (3,970,000) (2,926,978) (955,128) (14,951) (72,944) 9 Distribution Plant (56,320,000) (47,953,864) (7,900,330) (122,542) (343,264) 10 Intangible Plant (1,273,000) (1,056,672) (203,614) (3,126) (9,589) 11 General Plant (7,261,000) (6,025,711) (1,162,587) (17,848) (54,854) 12 Total Accumulated Depreciation (68,824,000) (57,963,224) (10,221,659) (158,467) (480,650) 13 Net Plant 127,065,000 104,600,985 21,141,900 323,035 999,081 14 Accumlulated Deferred FIT (24,281,000) (20,150,297) (3,887,603) (59,683) (183,417) 15 Miscellaneous Rate Base 8,146,000 6,128,328 1,854,175 28,951 134,547 16 Total Rate Base 110,930,000 90,579,015 19,108,473 292,302 950,211 17 Revenue From Retail Rates 63,338,000 47,851,692 14,995,946 201,088 289,275 18 Other Operating Revenues 156,000 127,635 26,644 408 1,314 19 Total Revenues 63,494,000 47,979,327 15,022,590 201,496 290,588 Operating Expenses 20 Purchased Gas Costs 33,351,000 23,596,182 9,619,766 133,184 1,868 21 Underground Storage Expenses 275,000 202,750 66,161 1,036 5,053 22 Distribution Expenses 4,972,000 4,151,083 748,901 9,399 62,617 23 Customer Accounting Expenses 2,306,000 2,227,555 76,950 571 923 24 Customer Information Expenses 399,000 392,154 6,815 5 27 25 Sales Expenses 3,000 2,949 51 0 0 26 Admin & General Expenses 5,900,000 4,632,934 1,139,648 18,541 108,877 27 Total O&M Expenses 47,206,000 35,205,607 11,658,293 162,736 179,364 28 Taxes Other Than Income Taxes 1,024,000 854,789 159,613 2,447 7,152 29 Depreciation Expense 30 Underground Storage Plant Depr 165,000 121,650 39,697 621 3,032 31 Distribution Plant Depreciation 4,076,000 3,415,369 623,992 9,436 27,203 32 General Plant Depreciation 1,974,000 1,638,170 316,065 4,852 14,913 33 Amortization of Intangible Plant 549,000 455,625 87,881 1,349 4,145 34 Total Depr & Amort Expense 6,764,000 5,630,814 1,067,634 16,259 49,292 35 Income Tax 2,021,000 1,394,722 611,619 4,408 10,251 36 Total Operating Expenses 57,015,000 43,085,932 13,497,159 185,849 246,060 37 Net Income 6,479,000 4,893,395 1,525,430 15,646 44,529 38 Rate of Return 5.84% 5.40% 7.98% 5.35% 4.69% 39 Return Ratio 1.00 0.92 1.37 0.92 0.80 40 Interest Expense 3,339,000 2,726,434 575,166 8,798 28,601 Exhibit No. 12 Case No. AVU-G-12-07 T. Knox, Avista Schedule 6, p. 1 of 4 Sumcost AVISTA UTILITIES Natural Gas Utility Company Base Case Summary by Function with Margin Analysis Idaho Jurisdiction 10-Oct-12 AVU-G-04-01 Method For the Year Ended June 30, 2012 (b) (c) (d) (e) (f) (g) (h) (j) (k) Residential Large Firm Interrupt Transport System Service Service Service Service Line Description Total Sch 101 Sch 111 Sch 131 Sch 146 Functional Cost Components at Current Rates 1 Production 33,521,417 23,716,754 9,668,921 133,864 1,878 2 Underground Storage 1,415,902 953,474 436,491 4,833 21,105 3 Distribution 19,044,897 15,749,532 3,127,224 35,691 132,449 4 Common 9,355,784 7,431,932 1,763,310 26,700 133,843 5 Total Current Rate Revenue 63,338,000 47,851,692 14,995,946 201,088 289,275 6 Exclude Cost of Gas w / Revenue Exp. 33,188,726 23,482,973 9,573,613 132,140 0 7 Total Margin Revenue at Current Rates 30,149,274 24,368,719 5,422,333 68,948 289,275 Margin per Therm at Current Rates 8 Production $0.00424 $0.00436 $0.00436 $0.00436 $0.00073 9 Underground Storage $0.01806 $0.01780 $0.01999 $0.01223 $0.00817 10 Distribution $0.24295 $0.29399 $0.14319 $0.09036 $0.05125 11 Common $0.11935 $0.13873 $0.08074 $0.06760 $0.05179 12 Total Current Margin Melded Rate per Therm $0.38460 $0.45488 $0.24827 $0.17456 $0.11193 Functional Cost Components at Uniform Current Return 13 Production 33,521,417 23,716,754 9,668,921 133,864 1,878 14 Underground Storage 1,381,729 1,018,713 332,425 5,203 25,387 15 Distribution 19,072,494 16,256,713 2,634,104 37,400 144,277 16 Common 9,362,360 7,515,337 1,684,192 26,977 135,854 17 Total Uniform Current Cost 63,338,000 48,507,517 14,319,643 203,444 307,397 18 Exclude Cost of Gas w / Revenue Exp. 33,188,726 23,482,973 9,573,613 132,140 0 19 Total Uniform Current Margin 30,149,274 25,024,544 4,746,030 71,303 307,397 Margin per Therm at Uniform Current Return 20 Production $0.00424 $0.00436 $0.00436 $0.00436 $0.00073 21 Underground Storage $0.01763 $0.01902 $0.01522 $0.01317 $0.00982 22 Distribution $0.24330 $0.30346 $0.12061 $0.09469 $0.05583 23 Common $0.11943 $0.14029 $0.07711 $0.06830 $0.05257 24 Total Current Uniform Margin Melded Rate per $0.38460 $0.46712 $0.21731 $0.18052 $0.11894 25 Margin to Cost Ratio at Current Rates 1.00 0.97 1.14 0.97 0.94 Functional Cost Components at Proposed Rates 26 Production 33,521,324 23,716,688 9,668,895 133,864 1,878 27 Underground Storage 1,920,688 1,319,496 564,632 6,688 29,872 28 Distribution 22,530,362 18,595,034 3,734,430 44,235 156,663 29 Common 9,926,626 7,899,855 1,860,727 28,083 137,961 30 Total Proposed Rate Revenue 67,899,000 51,531,073 15,828,685 212,869 326,373 31 Exclude Cost of Gas w / Revenue Exp. 33,188,634 23,482,908 9,573,586 132,140 0 32 Total Margin Revenue at Proposed Rates 34,710,366 28,048,165 6,255,098 80,729 326,373 Margin per Therm at Proposed Rates 33 Production $0.00424 $0.00436 $0.00436 $0.00436 $0.00073 34 Underground Storage $0.02450 $0.02463 $0.02585 $0.01693 $0.01156 35 Distribution $0.28741 $0.34710 $0.17099 $0.11199 $0.06062 36 Common $0.12663 $0.14746 $0.08520 $0.07110 $0.05338 37 Total Proposed Margin Melded Rate per Therm $0.44278 $0.52356 $0.28640 $0.20438 $0.12629 Functional Cost Components at Uniform Proposed Return 38 Production 33,521,324 23,716,688 9,668,895 133,864 1,878 39 Underground Storage 1,884,238 1,389,199 453,322 7,096 34,620 40 Distribution 22,559,790 19,136,920 3,206,979 46,115 169,777 41 Common 9,933,648 7,988,967 1,776,102 28,388 140,191 42 Total Uniform Proposed Cost 67,899,000 52,231,774 15,105,298 215,462 346,466 43 Exclude Cost of Gas w / Revenue Exp. 33,188,634 23,482,908 9,573,586 132,140 0 44 Total Uniform Proposed Margin 34,710,366 28,748,866 5,531,712 83,322 346,466 Margin per Therm at Uniform Proposed Return 45 Production $0.00424 $0.00436 $0.00436 $0.00436 $0.00073 46 Underground Storag $0.02404 $0.02593 $0.02076 $0.01796 $0.01340 47 Distribution $0.28778 $0.35722 $0.14684 $0.11675 $0.0656948 Common 0.12672 0.14913 0.08132 0.07187 0.05425 49 Total Proposed Uniform Margin Melded Rate p $0.44278 $0.53664 $0.25328 $0.21095 $0.13406 50 Margin to Cost Ratio at Proposed Rates 1.00 0.98 1.13 0.97 0.94 51 Current Margin to Proposed Cost Ratio 0.87 0.85 0.98 0.83 0.83 Exhibit No. 12 Case No. AVU-G-12-07 T. Knox, Avista Schedule 6, p. 2 of 4 Sumcost AVISTA UTILITIES Natural Gas Utility Company Base Case Summary by Classification with Unit Cost Analysis Idaho Jurisdiction 10-Oct-12 AVU-G-04-01 Method For the Year Ended June 30, 2012 (b) (c) (d) (e) (f) (g) (h) (j) (k) Residential Large Firm Interrupt Transport System Service Service Service Service Line Description Total Sch 101 Sch 111 Sch 131 Sch 146 Cost by Classification at Current Return by Schedule 1 Commodity 34,160,448 23,838,005 9,991,218 172,884 158,342 2 Demand 15,568,367 11,351,736 4,131,987 27,201 57,443 3 Customer 13,609,184 12,661,951 872,741 1,003 73,489 4 Total Current Rate Revenue 63,338,000 47,851,692 14,995,946 201,088 289,275 Revenue per Therm at Current Rates 5 Commodity $0.43577 $0.44497 $0.45747 $0.43770 $0.06127 6 Demand $0.19860 $0.21190 $0.18919 $0.06886 $0.02223 7 Customer $0.17361 $0.23635 $0.03996 $0.00254 $0.02844 8 Total Revenue per Therm at Current Rates $0.80797 $0.89322 $0.68662 $0.50910 $0.11193 Cost per Unit at Current Rates 9 Commodity Cost per Therm $0.43577 $0.44497 $0.45747 $0.43770 $0.06127 10 Demand Cost per Peak Day Therms $24.94 $23.55 $32.33 $12.37 $4.72 11 Customer Cost per Customer per Month $15.09 $14.28 $56.65 $83.60 $1,224.82 Cost by Classification at Uniform Current Return 12 Commodity 34,031,219 24,006,790 9,682,672 174,093 167,665 13 Demand 15,512,746 11,562,903 3,858,320 28,310 63,214 14 Customer 13,794,035 12,937,824 778,652 1,041 76,518 15 Total Uniform Current Cost 63,338,000 48,507,517 14,319,643 203,444 307,397 Cost per Therm at Current Return 16 Commodity $0.43412 $0.44812 $0.44334 $0.44076 $0.06488 17 Demand $0.19789 $0.21584 $0.17666 $0.07167 $0.02446 18 Customer $0.17596 $0.24150 $0.03565 $0.00264 $0.02961 19 Total Cost per Therm at Current Return $0.80797 $0.90547 $0.65565 $0.51507 $0.11894 Cost per Unit at Uniform Current Return 20 Commodity Cost per Therm $0.43412 $0.44812 $0.44334 $0.44076 $0.06488 21 Demand Cost per Peak Day Therms $24.85 $23.99 $30.19 $12.87 $5.19 22 Customer Cost per Customer per Month $15.29 $14.59 $50.55 $86.75 $1,275.30 23 Revenue to Cost Ratio at Current Rates 1.00 0.99 1.05 0.99 0.94 Cost by Classification at Proposed Return by Schedule 24 Commodity 35,512,391 24,784,909 10,371,125 178,930 177,427 25 Demand 17,107,424 12,536,458 4,468,962 32,747 69,257 26 Customer 15,279,184 14,209,705 988,597 1,193 79,690 27 Total Proposed Rate Revenue 67,899,000 51,531,073 15,828,685 212,869 326,373 Revenue per Therm at Proposed Rates 28 Commodity $0.45301 $0.46265 $0.47486 $0.45300 $0.06865 29 Demand $0.21823 $0.23401 $0.20462 $0.08291 $0.02680 30 Customer $0.19491 $0.26525 $0.04526 $0.00302 $0.03084 31 Total Revenue per Therm at Proposed Rates $0.86615 $0.96191 $0.72475 $0.53893 $0.12629 Cost per Unit at Proposed Rates 32 Commodity Cost per Therm $0.45301 $0.46265 $0.47486 $0.45300 $0.06865 33 Demand Cost per Peak Day Therms $27.40 $26.00 $34.97 $14.89 $5.69 34 Customer Cost per Customer per Month $16.94 $16.03 $64.17 $99.38 $1,328.16 Cost by Classification at Uniform Proposed Return 35 Commodity 35,374,366 24,965,244 10,041,098 180,260 187,764 36 Demand 17,047,939 12,762,074 4,176,242 33,968 75,655 37 Customer 15,476,695 14,504,456 887,957 1,234 83,048 38 Total Uniform Proposed Cost 67,899,000 52,231,774 15,105,298 215,462 346,466 Cost per Therm at Proposed Return 39 Commodity $0.45125 $0.46601 $0.45975 $0.45637 $0.07265 40 Demand $0.21747 $0.23822 $0.19122 $0.08600 $0.02927 41 Customer $0.19743 $0.27075 $0.04066 $0.00312 $0.03213 42 Total Cost per Therm at Proposed Return $0.86615 $0.97499 $0.69162 $0.54549 $0.13406 Cost per Unit at Uniform Proposed Return 43 Commodity Cost per Therm $0.45125 $0.46601 $0.45975 $0.45637 $0.07265 44 Demand Cost per Peak Day Therms $27.31 $26.47 $32.68 $15.45 $6.21 45 Customer Cost per Customer per Month $17.16 $16.36 $57.64 $102.85 $1,384.13 46 Revenue to Cost Ratio at Proposed Rates 1.00 0.99 1.05 0.99 0.94 47 Current Revenue to Proposed Cost Ratio 0.93 0.92 0.99 0.93 0.83 Exhibit No. 12 Case No. AVU-G-12-07 T. Knox, Avista Schedule 6, p. 3 of 4 Sumcost AVISTA UTILITIES Natural Gas Utility Company Base Case Customer Cost Analysis Idaho Jurisdiction 10-Oct-12 AVU-G-04-01 Method For the Year Ended June 30, 2012 (b) (c) (d) (e) (f) (g) (h) (j) (k) Residential Large Firm Interrupt Transport System Service Service Service Service Line Description Total Sch 101 Sch 111 Sch 131 Sch 146 Rate Base 1 Services 49,451,000 48,578,554$ 844,170$ 1,973$ 26,303$ 2 Services Accum. Depr. (22,558,000) (22,160,017)$ (385,084)$ (900)$ (11,999)$ 3 Total Services 26,893,000 26,418,537 459,086 1,073 14,305 4 Meters 21,321,000 18,565,797$ 2,658,436$ 5,024$ 91,743$ 5 Meters Accum. Depr. (4,746,000) (4,132,699)$ (591,761)$ (1,118)$ (20,422)$ 6 Total Meters 16,575,000 14,433,099 2,066,675 3,906 71,321 7 Total Rate Base 43,468,000 40,851,635 2,525,761 4,978 85,625 8 Return on Rate Base @ 8.46% 3,677,393 3,456,048 213,679 421 7,244 9 Revenue Conversion Factor 0.63711 0.63711 0.63711 0.63711 0.63711 10 Rate Base Revenue Requirement 5,771,990 5,424,571 335,389 661 11,370 Expenses 11 Services Depr Exp 1,224,000 1,202,405$ 20,895$ 49$ 651$ 12 Meters Depr Exp 632,000 550,330$ 78,802$ 149$ 2,719$ 13 Services Maintenance Exp 418,000 410,625$ 7,136$ 17$ 222$ 14 Meters Maintenance Exp 415,000 361,372$ 51,745$ 98$ 1,786$ 15 Meter Reading 252,000 247,676$ 4,304$ 3$ 17$ 16 Billing 1,702,000 1,672,795$ 29,069$ 23$ 113$ 17 Total Expenses 4,643,000 4,445,204 191,950 338 5,509 18 Revenue Conversion Factor 0.995009 0.995009 0.995009 0.995009 0.995009 19 Expense Revenue Requirement 4,666,289 4,467,501 192,913 340 5,536 20 10,438,280 9,892,072 528,301 1,001 16,906 21 Total Customer Bills 901,972 886,495 15,405 12 60 22 Average Unit Cost per Month $11.57 $11.16 $34.29 $83.41 $281.77 23 Total Customer Related Cost 15,476,695 14,504,456 887,957 1,234 83,048 24 Customer Related Unit Cost per Month $17.16 $16.36 $57.64 $102.85 $1,384.13 25 Other Non-Gas Costs 19,233,671 14,244,410 4,643,754 82,088 263,419 26 Other Non-Gas Unit Cost per Month $21.32 $16.07 $301.44 $6,840.63 $4,390.31 27 Total Fixed Unit Cost per Month $38.48 $32.43 $359.09 $6,943.48 $5,774.44 Total Meter, Service, Meter Reading, and Meter, Services, Meter Reading & Billing Costs by Schedule at Requested Rate of Return Fixed Costs per Customer Exhibit No. 12 Case No. AVU-G-12-07 T. Knox, Avista Schedule 6, p. 4 of 4