Loading...
HomeMy WebLinkAbout20230309Updated Direct Amen with Exhibits.pdfPreston N. Carter, ISB No. 8462 Morgan D. Goodin, ISB No. 11184 Blake W. Ringer, ISB No. 11223 Givens Pursley LLP 601 W. Bannock St. Boise, Idaho 83702 Telephone: (208) 388-1200 Facsimile: (208) 388-1300 prestoncarter@givenspursley.com morgangoodin@givenspursley.com blakeringer@givenspursley.com Attorneys for Intermountain Gas Company BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION IN THE MATTER OF THE APPLICATION OF INTERMOUNTAIN GAS COMPANY FOR AUTHORITY TO INCREASE ITS RATES AND CHARGES FOR NATURAL GAS SERVICE IN THE STATE OF IDAHO ) ) ) ) ) ) ) CASE NO. INT-G-22-07 UPDATED DIRECT TESTIMONY OF RONALD J. AMEN FOR INTERMOUNTAIN GAS COMPANY MARCH 9, 2023 RECEIVED 2023 March, 9 2:09PM IDAHO PUBLIC UTILITIES COMMISSION PAGE 2 OF 44 R. AMEN, DI INTERMOUNTAIN GAS I.INTRODUCTION Q. Please state your name and business address.1 A. My name is Ronald J. Amen and my business address is 10 Hospital Center Commons, Suite 2 400, Hilton Head Island, SC 29926. 3 Q. By whom are you employed and in what capacity?4 A. I am employed by Atrium Economics, LLC (“Atrium”) as a Managing Partner. 5 Q. On whose behalf are you testifying? 6 A. I am testifying on behalf of Intermountain Gas Company (“Intermountain” or "Company”). 7 II.STATEMENT OF QUALIFICATIONS Q. What has been the nature of your work in the energy utility consulting field? 8 A. I have over 40 years of experience in the utility industry, the last 24 years of which have 9 been in the field of utility management and economic consulting. I have advised and assisted 10 utility management, industry trade organizations, and large energy users in matters 11 pertaining to costing and pricing; competitive market analysis; regulatory planning and 12 policy development; resource planning and acquisition; strategic business planning; merger 13 and acquisition analysis; organizational restructuring; new product and service development; 14 and load research studies. I have prepared and presented expert testimony before utility 15 regulatory bodies across North America and have spoken on utility industry issues and 16 activities dealing with the pricing and marketing of gas utility services, gas and electric 17 resource planning and evaluation, and utility infrastructure replacement. Further background 18 information summarizing my work experience, presentation of expert testimony, and other 19 industry-related activities is included as Exhibit 1 to my testimony. 20 PAGE 3 OF 44 R. AMEN, DI INTERMOUNTAIN GAS Q. Have you previously testified before the Idaho Public Utilities Commission? 1 A. No. 2 III.PURPOSE OF TESTIMONY Q. Please summarize your testimony. 3 A. First, I will present the load study analysis for purposes of determining each customer class’s 4 contribution to the system’s peak load. Next, I present the development of the Company’s 5 allocated Cost of Service Study (“COSS”) for the test year ended December 31, 2022, 6 including a comprehensive overview of the schedules created in support of them. Finally, I 7 present the Company’s proposed rates and the resulting customer bill impacts based on the 8 Company’s requested revenue increase. 9 My testimony consists of the following topics: 10 Load Study and Analysis 11 Theoretical Principles of Cost Allocation 12 Intermountain’s COSS 13 A Summary of the COSS Results by Rate Class 14 Determination of Proposed Class Revenues 15 Rate Design 16 Customer Bill Impacts 17 Q. Are you sponsoring any exhibits to your direct testimony? 18 A. Yes. I am sponsoring the following 5 Exhibits, all of which were prepared by me or under 19 my supervision and direction.: 20 Exhibit 1 – Resume of Ronald J. Amen 21 Exhibit 2 – Cost of Service Study 22 PAGE 4 OF 44 R. AMEN, DI INTERMOUNTAIN GAS Exhibit 3 – Proposed Revenue Targets 1 Exhibit 4 – Proposed Rate Design and Proof of Revenue 2 Exhibit 5 – Customer Bill Impacts 3 I.LOAD STUDY AND ANALYSIS4 Q. What is a load study? 5 A. A load study determines each customer class’s contribution to the natural gas utility’s 6 pipeline system peak load. This information is used to develop allocators for purposes of 7 allocating shared costs, or costs that cannot be directly assigned, such as plant and 8 equipment, operation, and maintenance expenses (“O&M”), and some administrative costs 9 to each customer class on the basis of peak day usage. Natural gas pipeline systems are 10 designed and constructed to satisfy peak day demand under design weather conditions and 11 a load study identifies each class’s relative contribution to the peak day demand. 12 Q. Did Intermountain develop a load study in its previous general rate case proceeding, 13 No. INT-G-16-02 (“2016 Case”)? 14 A. No. In its last case, the Company reported that it did not have adequate data to perform a 15 detailed load study. Instead, the Company estimated peak demand for each class by 16 deducting known daily metered industrial and transportation demand from its aggregate peak 17 to arrive at the peak demand for the non-daily metered residential and commercial classes. 18 The Company then allocated between residential and commercial classes on the basis of 19 peak month usage. A load study requires sufficient data for each class to determine the 20 response of load in a particular class to changes in heating degree days (“HDD”). In its last 21 general rate proceeding, the Commission found that the Company lacked sufficient data to 22 PAGE 5 OF 44 R. AMEN, DI INTERMOUNTAIN GAS definitively allocate the revenue requirement between its non-daily metered classes.1 As 1 such, the Commission determined that a gradual move of 50% towards cost-of-service was 2 reasonable and warranted for the affected customer classes.2 Lastly, the Commission 3 encouraged the Company to participate with Staff and other interested parties to determine 4 the best way forward as it relates to class cost-of-service and the acquisition of appropriate 5 cost causation and load data.36 Q. Has Intermountain acquired sufficient data to develop a load study in this filing? 7 A. Yes. The Company has dramatically expanded its daily metering capability through 8 Advanced Metering Infrastructure (“AMI”). Table 1 below shows the availability of daily 9 metered data for the residential and commercial classes for each of Intermountain’s seven 10 distinct weather zones. Intermountain also had AMI in place for many of its Large Volume 11 (“LV”) customers, (Large Volume, Transport, and Interruptible Transport), however those 12 classes yielded weak regression results due either to lack of weather sensitivity, lack of 13 available data or small number of customers, and as a result, daily metered data for those 14 classes was not relied upon for projecting peak load for the LV customers. 15 Table 1 Percent of Residential and Commercial Premises with Daily Meter Readings 350 Canyon County 450 Boise 500 Sun Valley 600 Twin Falls 700 Rexburg 750 Idaho Falls 800 Pocatello Residential 93.2% 84.6% 35.3% 0.0% 45.2% 0.0% 0.0% Commercial 95.2% 87.4% 48.2% 0.0% 58.3% 0.0% 0.0% 16 Q. Please describe the characteristics of Intermountain’s gas load. 17 1 Idaho PUC Order No. 33757, Case No. INT-G-16-02 (April 28, 2017) at 28. 2 Ibid. 3 Id., at 28-29. PAGE 6 OF 44 R. AMEN, DI INTERMOUNTAIN GAS A. Intermountain serves customers throughout a geographically and economically diverse 1 service territory. There are seven primary rate classes (Residential (“RS”) Commercial 2 (“GS”), Large Volume (“LV-1”), Transport (“T-4”), Interruptible Transport (“T-3”), 3 Interruptible Snowmelt-Residential (“IS-R”), and Interruptible Snowmelt-Commercial (“IS-4 C”)). Intermountain’s customers are spread across seven diverse geographic areas with 5 differing weather patterns and elevations (Canyon County, Boise, Hailey (or Sun Valley), 6 Twin Falls, Rexburg, Idaho Falls, and Pocatello). Below is a chart showing total monthly 7 consumption for each rate class for the twelve months ended July 31, 2022. 8 Figure 1 Intermountain Monthly Consumption by Rate Class 9 Intermountain’s Residential and Commercial customers are weather sensitive and are spread 10 across all seven weather zones. The Company’s Large Volume customers are made of a mix 11 of industrial and commercial loads and use in excess of 200,000 therms per year. These 12 customers may be subject to one of three rate classes: a bundled sales tariff (LV-1), a 13 distribution system only transportation tariff (T-4), and an interruptible transportation tariff 14 (T-3). The LV customers, on average, account for roughly 50% of Intermountain’s annual 15 PAGE 7 OF 44 R. AMEN, DI INTERMOUNTAIN GAS throughput and approximately 25% of the projected design peak day. The vast majority of 1 the LV throughput reflects distribution system-only transportation and as a whole the LV 2 gas usage pattern is not weather sensitive. The Company has Residential Interruptible Snow 3 Melt Customers, which are separately metered from the premises and are fully interruptible 4 with at least two hours of notice. Similarly, there are Small Commercial Interruptible 5 Snowmelt Service customers that are also interruptible with two hours of notice. Lastly, the 6 Company has Irrigation Customers, which do not contribute to the winter peak and do not 7 factor into the load study. 8 Table 2 below provides a summary of premises and annual consumption projected 9 for the test year ended 2022 as a percentage of Intermountain’s whole system throughput. 10 Table 2 Test Year Premises and Consumption Data for Intermountain’s Gas System4 Q. How does the Company define its design day? 11 A. The Company’s design day represents the coldest temperatures that can be expected to occur 12 during an extreme cold or peak weather event. Intermountain used a statistical model to 13 develop probability-derived peak HDD values to characterize its design day, corresponding 14 4 Based on average monthly customers and total therms for the test year (January 2022 – December 2022). Premises % Premises Consumption (Therms) % Consumption Residential 368,615 91.23%284,776,158 34.64% General Service 35,008 8.66%139,956,787 17.02% Large Volume (LV-1)35 0.01%14,130,994 1.72% Transportation (Interruptible) (T-3)8 0.00%44,289,741 5.39% Transportation (Firm) (T-4)102 0.03%338,020,607 41.12% Snowmelt - Residential (IS-R)225 0.06%556,168 0.07% Snowmelt - Commercial (IS-C)53 0.01%285,603 0.03% Irrigation (IRR)9 0.00%71,046 0.01% TOTAL 404,055 822,087,104 PAGE 8 OF 44 R. AMEN, DI INTERMOUNTAIN GAS to an exceedance probability that Intermountain considers appropriate for its intended use. 1 Intermountain used exceedance probability results to review data associated with both a 50-2 year and 100-year probability event, as shown below in Table 3. The Company’s practice 3 has been to rely on a 50-year probability event, which results in a 78 heating-degree-day 4 (“HDD”), for use in the design weather model. 5 Table 3 Peak Day HDD65 Event by Region 350 Canyon County 450 Boise 500 Sun Valley 600 Twin Falls 700 Rexburg 750 Idaho Falls 800 Pocatello Total Company 50-Year Event 78 75 82 77 88 87 82 78.43 100-Year Event 81 79 85 80 91 89 85 81.75 Max Degree Days5 83 81 88 80 92 88 83 82.88 6 Q. Please describe the methodology and approach for developing the Peak Load Study. 7 A. The development of the Peak Load Study began by performing regression analyses to 8 identify weather sensitive loads, measuring the historical linear relationship between 9 metered daily volumes and HDD for each customer class and weather zone. Regressions 10 were performed on all available daily AMI data, and on monthly billing data, for the period 11 from January 1, 2019, to July 31, 2022, regressing heating degree days (using 65 degrees as 12 the baseline) against average daily use per customer for each customer class and weather 13 zone combination. The daily AMI reads were in CCF, so it was necessary to apply a monthly 14 billing adjustment factor for each rate class, month, and weather zone to account for the 15 heating value and pressure to arrive at delivered therms. The goal is to project the design day 16 peak, i.e., the 50-year event using the results of the linear regression equations or another 17 5 Max Degree Days reflect the coldest day on record. PAGE 9 OF 44 R. AMEN, DI INTERMOUNTAIN GAS reasonable estimate of peak load by rate class. The regression results were relied upon to 1 project design day load for the residential and commercial classes, or “Core”6 customer 2 classes. For the large volume classes, either due to lack of weather sensitivity (LV-1), lack 3 of consistent and strong regression results (T-4), or due to lack of data (T-3), other means of 4 estimating peak day results were used. 5 Q.Please describe the regression analyses using daily AMI metered data for the 6 residential and commercial customer classes and the development of the “Blended” 7 peak load sendout model. 8 A. As indicated in Table 1 above, there is significant penetration of daily AMI meters for the 9 residential and commercial classes for two primary weather zones, 350 Canyon County 10 (93.2% residential (“RS”) and 95.2% commercial (“GS”)); and 450 Boise (84.6% RS and 11 87.4% GS). There was moderate penetration of daily AMI meters for two additional weather 12 zones 500 Sun Valley (or Hailey) (35.3% RS and 48.2% GS); and 700 Rexburg (45.2% RS 13 and 58.3% GS). There were no daily AMI data for residential or commercial classes for 14 Twin Falls (600), Idaho Falls (750); or Pocatello (800)7. The results of the daily regressions 15 are listed below in Table 4 16 6 Core customers is defined in Intermountain’s 2021-2026 IRP as, “All residential and commercial customers of Intermountain Gas Company. Includes all customers receiving service under the RS and GS tariffs.” 7 Pocatello did reflect data for one daily metered residential customer with intermittent usage in December 2019, but that customer did not bring the percentage of daily metered customers above zero. PAGE 10 OF 44 R. AMEN, DI INTERMOUNTAIN GAS Table 4 Daily Regression Results (January 2019 – July 2022) Regression Results 350 450 500 600 700 750 800 Residential Class Adjusted R2 0.937 0.952 0.952 No data 0.562 No data 0.009 x coefficient 0.110 0.121 0.105 No data 0.056 No data 0.009 x t-stat 139.897 161.085 160.277 No data 40.964 No data 3.591 x std. error 0.001 0.001 0.001 No data 0.001 No data 0.002 y coefficient 0.271 0.404 0.346 No data 0.411 No data (0.033) y t-stat 17.666 28.024 19.449 No data 10.764 No data (0.560) y std. error 0.015 0.014 0.018 No data 0.038 No data 0.059 Commercial Class Adjusted R2 0.906 0.936 0.906 No data 0.583 No data No data x coefficient 0.451 0.468 0.243 No data 0.283 No data No data x t-stat 112.345 138.829 112.087 No data 42.799 No data No data x std. error 0.004 0.003 0.002 No data 0.007 No data No data y coefficient 1.517 1.947 0.419 No data 1.424 No data No data y t-stat 19.321 29.996 7.083 No data 7.751 No data No data y std. error 0.079 0.065 0.059 No data 0.184 No data No data 1 Typically, the average usage of customers in the same geographical location and in the same 2 customer rate class can be used to substitute data for a customer which lacks sufficient 3 information, providing that customers are of relatively similar size. Where daily results were 4 determined to be sufficiently robust, (i.e., Adjusted R2 in excess of 0.90, and where the t-5 statistic on both the x- and y-coefficients were in excess of 10.0), the results were brought 6 forward into the peak load model. Where daily results were not sufficiently strong, or where 7 data was lacking, monthly regression results were substituted for the daily data. This dataset 8 is referred to as the “Blended Model” since it includes regressions performed on both daily 9 and monthly data. The Blended Model includes daily regression results for the Residential 10 class in weather zones 350, 450, and 500; and the Commercial class in weather zones 350 11 and 450. The remaining data used in the Blended Model was based on monthly regressions. 12 PAGE 11 OF 44 R. AMEN, DI INTERMOUNTAIN GAS Q. Please describe the regression analyses using monthly billing data for the residential 1 and commercial customer classes and the development of the “Monthly” peak load 2 sendout model. 3 A. The monthly data regressions were performed on Intermountain’s monthly billing data. This 4 data had the advantage of covering all customers within the class and weather zone, and was 5 already in therms so no adjustments to the data were necessary. In the monthly data 6 regressions, average daily HDD was regressed against average daily use per customer by 7 month, for each class and weather zone. The results of the monthly data regressions for the 8 residential and commercial classes are reported in Table 5. These results are referred to as 9 the “Monthly Model.” 10 Table 5 Monthly Regression Results (January 2019 – July 2022) Regression Results 350 450 500 600 700 750 800 Residential Class Adjusted R2 0.979 0.990 0.967 0.982 0.993 0.990 0.983 x coefficient 0.115 0.126 0.162 0.101 0.071 0.085 0.093 x t-stat 44.098 64.639 35.372 48.431 75.560 65.060 48.621 x std. error 0.003 0.002 0.005 0.002 0.001 0.001 0.002 y coefficient 0.210 0.353 0.289 0.162 0.396 0.327 0.168 y t-stat 4.104 9.528 2.349 3.511 14.722 8.859 3.590 y std. error 0.051 0.037 0.123 0.046 0.027 0.037 0.047 Commercial Class Adjusted R2 0.881 0.982 0.920 0.970 0.988 0.982 0.972 x coefficient 0.522 0.582 0.320 0.507 0.412 0.447 0.463 x t-stat 17.682 47.353 22.044 36.669 58.217 47.918 37.897 x std. error 0.030 0.012 0.015 0.014 0.007 0.009 0.012 y coefficient 3.427 2.365 1.437 2.093 2.150 1.139 1.140 y t-stat 5.956 10.153 3.681 6.897 10.820 4.330 3.823 y std. error 0.575 0.233 0.390 0.303 0.199 0.263 0.298 11 Q. Was there a validation step performed to check the accuracy of the “Blended” or the 12 “Monthly” peak load sendout models in predicting the winter peak load? 13 PAGE 12 OF 44 R. AMEN, DI INTERMOUNTAIN GAS A. Yes. To check the appropriateness of the modeling results, “Blended” and “Monthly” peak 1 load sendout models were validated by comparing each to actual historical sendout, using 2 actual historical HDD by weather zone and the class/weather zone regressions for the period 3 November 1, 2021, to March 31, 2022. The results of that comparison are illustrated below. 4 Figure 2 Blended and Monthly Models versus IGC Core Sendout 5 As illustrated in Figure 2 above, the peak use during the illustrated period occurred on 6 January 2, 2022, with an average HDD across all weather zones of 53.47, and core market 7 load of 355,565 MMBtu. This HDD was slightly lower than the coldest day of the period, 8 January 1, 2022, at 57.02 HDD, but since January 1st was a holiday, the sendout was lower 9 than on January 2nd, even though the HDD was higher. As Figure 2 shows, the Monthly data 10 does a slightly better job of predicting the peak than the Blended data. This disparity could 11 be explained by the fact that daily data tends to be less stable and more volatile than monthly 12 PAGE 13 OF 44 R. AMEN, DI INTERMOUNTAIN GAS data and that some of the HDD sensitivity may be lost in the “noise” in the daily data. In 1 addition, it is likely that there may be large, highly weather-sensitive customers that are not 2 yet daily metered and therefore not reflected in the daily regressions. For these reasons, it 3 has been determined that the Monthly peak load sendout model will be the best predictor of 4 Intermountain’s design day peak. 5 Q. What were the results of the Monthly Peak Load Sendout Model for Intermountain’s 6 Core Residential and Commercial Customers? 7 A. The regression results were extrapolated from the Monthly peak load sendout model to the 8 average test year number of customers for each weather zone for each of the Core classes, 9 RS and GS. The results are shown in Table 6 below. 10 Table 6 Peak Load Sendout for Core Customers Core Rate Class Customers8 Peak Load (Therms) Residential 368,615 3,362,718 Commercial 35,008 1,485,731 Total Core Customers 403,623 4,848,449 11 Q. How did you estimate the peak day sendout for the LV rate classes? 12 A. Because the LV customers are not as weather sensitive as the residential and commercial 13 customers, forecasting their volumes using standard regression techniques based on 14 projected weather may not provide statistically significant results. Also, the LV customer 15 counts are so few that they may fall below the number required to provide an adequate 16 statistical population/sample size. As such, the maximum contract demand was used for 17 8 Based on average monthly customers for the test year (January 2022 – December 2022). Totals exclude interruptible snowmelt classes, CNG, and Irrigation. PAGE 14 OF 44 R. AMEN, DI INTERMOUNTAIN GAS these large volume customers to project loads at peak. For the LV-1 class and the T-4 class, 1 the maximum daily firm quantity (MDFQ) was used as of December 2022, including two 2 known changes that occurred in calendar year 2023. The MDFQ reflects the maximum 3 amount of daily gas and/or capacity Intermountain must be prepared to provide to its firm 4 LV customers on any given day, including the projected system peak day. These amounts 5 represent a contracted daily requirement and reflects the known peak day obligation for each 6 customer. The December update MDFQ amounts were 1,488,410 therms for the T-4 class, 7 and 77,405 therms for the LV-1 class. It is reasonable to expect that on a peak day these 8 customers will be using their full contracted MDFQ. I note that this treatment is consistent 9 with how the Peak Day Sendout was developed in the 2021 IRP.910 The daily peak sendout for the Interruptible Transport Class, T-3, was determined 11 based on the test year average daily load for the twelve months ending December 2022. T-3 12 customers are interruptible and as such there are no assurances of the amount of capacity 13 that they may be granted on any given day. However, given that Intermountain has rarely 14 interrupted these customers, it is reasonable to provide a peak day allocation for their 15 contribution to the system peak. Peak day sendout results have been provided with and 16 without the interruptible customers; and note that interruptible customers have previously 17 been excluded from Intermountain’s peak load analyses. The average daily usage for the T-18 3 customers was 121,342 therms for the test year twelve-month period ending December 31, 19 2022. 20 Q. Was the peak day sendout estimated for the Interruptible Snowmelt Classes? 21 9 Intermountain Gas Company, Integrated Resource Plan 2021- 2026, at p. 126. PAGE 15 OF 44 R. AMEN, DI INTERMOUNTAIN GAS A. Yes. The peak day sendout for the Interruptible snowmelt classes (IS-R and IS-C) were 1 estimated based on their average daily use for the month of January 2022. These classes are 2 also fully interruptible with two hours of notice and could not be assured of capacity during 3 any given peak day. However, as the Company has rarely interrupted these customers, they 4 have been included in the Peak Load Study for reference. 5 Q. Please provide the results for Intermountain’s total peak day sendout. 6 A. The results of the peak load study and the resulting allocations with and without the inclusion 7 of interruptible customers were prepared and summarized in Table 7 below. 8 Table 7 Peak Day Sendout with and without Interruptible Classes – Monthly Model For comparative purposes, the results of the Blended peak load model have been included, 9 which incorporated the daily meter readings, where appropriate. As shown below, the 10 Blended model provides a very similar class allocation relative to the peak compared to the 11 Monthly model. 12 Rate Class:Therms %Therms % Residential (RS)3,362,718 51.4%3,362,718 52.4% General Service (GS)1,485,731 22.7%1,485,731 23.2% Large Volume (LV-1)77,405 1.2%77,405 1.2% Transportation (Interruptible) (T-3)121,342 1.9%-0.0% Transportation (Firm) (T-4)1,488,410 22.8%1,488,410 23.2% Snowmelt - Residential (IS-R)2,404 0.0%-0.0% Snowmelt - Commercial (IS-C)1,421 0.0%-0.0% TOTAL 6,539,432 6,414,264 50-Year Peak Day Event - Monthly Model Firm & Interruptible Firm only PAGE 16 OF 44 R. AMEN, DI INTERMOUNTAIN GAS Table 8 Peak Day Sendout with and without Interruptible Classes – Blended Model For purposes of this allocated class cost of service study, the results shown in Table 7 were 1 selected, which use the Monthly peak load sendout model to determine the Core peak day 2 sendout since I believe it provides superior results in predicting peak day sendout as 3 illustrated above in Figure 2. These results are aligned with Intermountain’s projections of 4 peak day sendout in their 2021-2026 IRP, which projected 613,523 MMBtu for 2022 and 5 626,676 MMBtu for 2023 for firm demand (RS, GS, LV-1, and T-4). This corresponds to 6 the Monthly model result of 6,414,264 therms (641,426 MMBtu), which exceeds the IRP’s 7 estimated peak day sendout for 2023 by 14,750 MMBtu. This variance is largely attributable 8 to increases in MDFQ’s for LV-1 and T-4 since the IRP was published in 2021. The IRP 9 estimated MDFQ’s for LV-1 and T-4 classes of 140,779 MMBtu, compared to the MDFQ’s 10 of 156,582 MMBtu used in the Monthly model, a difference of 15,803 MMBtu. 11 IV.THEORETICAL PRINCIPLES OF COST ALLOCATION Q. Why do utilities conduct cost allocation studies as part of the regulatory process? 12 A. There are many purposes for utilities conducting cost allocation studies, ranging from 13 Rate Class:Therms %Therms % Residential (RS)3,224,979 51.7%3,224,979 52.7% General Service (GS)1,326,300 21.2%1,326,300 21.7% Large Volume (LV-1)77,405 1.2%77,405 1.3% Transportation (Interruptible) (T-3)121,342 1.9%-0.0% Transportation (Firm) (T-4)1,488,410 23.8%1,488,410 24.3% Snowmelt - Residential (IS-R)2,404 0.0%-0.0% Snowmelt - Commercial (IS-C)1,421 0.0%-0.0% TOTAL 6,242,262 6,117,094 50-Year Peak Day Event - Blended Model Firm & Interruptible Firm only PAGE 17 OF 44 R. AMEN, DI INTERMOUNTAIN GAS designing appropriate price signals in rates to determining the share of costs or revenue 1 requirements borne by the utility’s various rate or customer classes. In this case, an 2 embedded COSS is a useful tool for determining the allocation of Intermountain’s revenue 3 requirement among its customer classes. It is also a useful tool for rate design because it can 4 identify the important cost drivers associated with serving customers and satisfying their 5 design day demands. 6 Embedded cost studies analyze the costs for a test period based on either the book 7 value of accounting costs (a historical period) or the estimated book value of costs for a 8 forecasted test year or some combination of historical and future costs. Typically, embedded 9 cost studies are used to allocate the revenue requirement between jurisdictions, classes, and 10 between customers within a class. 11 Q. Please discuss the reasons that cost of service studies are utilized in regulatory 12 proceedings. 13 A. Cost of service studies represent an attempt to analyze which customer or group of customers 14 cause the utility to incur the costs to provide service. The requirement to develop cost studies 15 results from the nature of utility costs. Utility costs are characterized by the existence of 16 common costs. Common costs occur when the fixed costs of providing service to one or 17 more classes, or the cost of providing multiple products to the same class, use the same 18 facilities and the use by one class precludes the use by another class. 19 In addition, utility costs may be fixed or variable in nature. Fixed costs do not change 20 with the level of throughput, while variable costs change directly with changes in throughput. 21 Most non-fuel related utility costs are fixed in the short run and do not vary with changes in 22 customers’ loads. This includes the cost of distribution mains and service lines, meters, and 23 PAGE 18 OF 44 R. AMEN, DI INTERMOUNTAIN GAS regulators. The distribution assets of a gas utility do not vary with the level of throughput in 1 the short run. In the long run, main costs vary with either growing design day demand or a 2 growing number of customers. 3 Finally, utility costs exhibit significant economies of scale. Scale economies result 4 in declining average cost as gas throughput increases and marginal costs must be below 5 average costs. These characteristics have implications for both cost analysis and rate design 6 from a theoretical and practical perspective. The development of cost studies requires an 7 understanding of the operating characteristics of the utility system. Further, as discussed 8 below, different cost studies provide different contributions to the development of 9 economically efficient rates and the cost responsibility by customer class. 10 Q. Please discuss the application of economic theory to cost allocation.11 A. The allocation of costs using cost of service studies is not a theoretical economic exercise. 12 It is rather a practical requirement of regulation since rates must be set based on the cost of 13 service for the utility under cost-based regulatory models. As a general matter, utilities must 14 be allowed a reasonable opportunity to earn a return of and on the assets used to serve their 15 customers. This is the cost of service standard and equates to the revenue requirements for 16 utility service. The opportunity for the utility to earn its allowed rate of return depends on 17 the rates applied to customers producing that revenue requirement. Using the cost 18 information per unit of demand, customer, and energy developed in the cost of service study 19 to understand and quantify the allocated costs in each customer class is a useful step in the 20 rate design process to guide the development of rates. 21 However, the existence of common costs makes any allocation of costs problematic 22 from a strict economic perspective. This is theoretically true for any of the various utility 23 PAGE 19 OF 44 R. AMEN, DI INTERMOUNTAIN GAS costing methods that may be used to allocate costs. Theoretical economists have developed 1 the theory of subsidy-free prices to evaluate traditional regulatory cost allocations. Prices 2 are said to be subsidy-free so long as the price exceeds the incremental cost of providing 3 service but is less than stand-alone costs (“SAC”). The logic for this concept is that if 4 customers’ prices exceed incremental cost, those customers contribute to the fixed costs of 5 the utility. All other customers benefit from this contribution to fixed costs because it reduces 6 the cost they are required to bear. Prices must be below the SAC because the customer would 7 not be willing to participate in the service offering if prices exceed SAC. 8 SAC is an important concept for Intermountain because certain customers have 9 competitive options for the end uses supplied by natural gas through the use of alternative 10 fuels. As a result, subsidy-free prices permit all customers to benefit from the system’s scale 11 and common costs, and all customers are better off because the system is sustainable. If strict 12 application of the cost allocation study suggests rates that exceed SAC for some customers, 13 prices must nevertheless be set below the SAC, but above marginal cost, to ensure that those 14 customers make the maximum practical contribution to the common costs of the utility. 15 Q. If any allocation of common cost is problematic from a theoretical perspective, how is 16 it possible to meet the practical requirements of cost allocation? 17 A. As noted above, the practical reality of regulation often requires that common costs be 18 allocated among jurisdictions, classes of service, rate schedules, and customers within rate 19 schedules. The key to a reasonable cost allocation is an understanding of cost causation. 20 Cost causation, as alluded to earlier, addresses the need to identify which customer or group 21 of customers causes the utility to incur particular types of costs. To answer this question, it 22 is necessary to establish a linkage between a Local Distribution Company’s (“LDC's”) 23 PAGE 20 OF 44 R. AMEN, DI INTERMOUNTAIN GAS customers and the particular costs incurred by the utility in serving those customers. 1 An important element in the selection and development of a reasonable COSS 2 allocation methodology is the establishment of relationships between customer 3 requirements, load profiles and usage characteristics on the one hand and the costs incurred 4 by the Company in serving those requirements on the other hand. For example, providing a 5 customer with gas service during peak periods can have much different cost implications for 6 the utility than service to a customer who requires off-peak gas service. 7 Q. Why are the relationships between customer requirements, load profiles, and usage 8 characteristics significant to cost causation? 9 A. The Company's distribution system is designed to meet three primary objectives: (1) to 10 extend distribution services to all customers entitled to be attached to the system; (2) to meet 11 the aggregate design day peak capacity requirements of all customers entitled to service on 12 the peak day; and (3) to deliver volumes of natural gas to those customers either on a sales 13 or transportation basis. There are certain costs associated with each of these objectives. Also, 14 there is generally a direct link between the manner in which such costs are defined and their 15 subsequent allocation. 16 Customer related costs are incurred to attach a customer to the distribution system, 17 meter any gas usage and maintain the customer's account. Customer costs are a function of 18 the number of customers served and continue to be incurred whether or not the customer 19 uses any gas. They generally include capital costs associated with minimum size distribution 20 mains, services, meters, regulators and customer service and accounting expenses. 21 Demand or capacity related costs are associated with plant that is designed, installed, 22 and operated to meet maximum hourly or daily gas flow requirements, such as the 23 PAGE 21 OF 44 R. AMEN, DI INTERMOUNTAIN GAS transmission and distribution mains, or more localized distribution facilities that are 1 designed to satisfy individual customer maximum demands. Gas supply contracts also have 2 a capacity related component of cost relative to the Company's requirements for serving 3 daily peak demands and the winter peaking season. 4 Commodity related costs are those costs that vary with the throughput sold to, or 5 transported for, customers. Costs related to gas supply are classified as commodity related 6 to the extent, they vary with the amount of gas volumes purchased by the Company for its 7 sales service customers. 8 From a cost of service perspective, the best approach is a direct assignment of costs 9 where costs are incurred for a customer or class of customers and can be so identified. Where 10 costs cannot be directly assigned, the development of allocation factors by customer class 11 uses principles of both economics and engineering. This results in appropriate allocation 12 factors for different elements of costs based on cost causation. For example, we know from 13 the manner in which customers are billed that each customer requires a meter. Meters differ 14 in size and type depending on the customer’s load characteristics. These meters have 15 different costs based on size and type. Therefore, meter costs are customer-related, but 16 differences in the cost of meters are reflected by using a different meter cost for each class 17 of service. For some classes such as the largest customers, the meter cost may be unique for 18 each customer. 19 Q. How does one establish the cost and utility service relationships you previously 20 discussed? 21 A. To establish these relationships, the Company must analyze its gas system design and 22 operations, its accounting records as well as its system and customer load data (e.g., annual, 23 PAGE 22 OF 44 R. AMEN, DI INTERMOUNTAIN GAS and peak period gas consumption levels). From the results of those analyses, methods of 1 direct assignment and common cost allocation methodologies can be chosen for all of the 2 utility's plant and expense elements. 3 Q. Please explain what you mean by the term “direct assignment.” 4 A. The term direct assignment relates to a specific identification and isolation of plant and/or 5 expense incurred exclusively to serve a specific customer or group of customers. Direct 6 assignments best reflect the cost causation characteristics of serving individual customers or 7 groups of customers. Therefore, in performing a COSS, the cost analyst seeks to maximize 8 the amount of plant and expense directly assigned to particular customer groups to avoid the 9 need to rely upon other more generalized allocation methods. An alternative to direct 10 assignment is an allocation methodology supported by a special study as is done with costs 11 associated with meters and services. 12 Q. What prompts the analyst to elect to perform a special study? 13 A. When direct assignment is not readily apparent from the description of the costs recorded in 14 the various utility plant and expense accounts, then further analysis may be conducted to 15 derive an appropriate basis for cost allocation. For example, in evaluating the costs charged 16 to certain operating or administrative expense accounts, it is customary to assess the 17 underlying activities, the related services provided, and for whose benefit the services were 18 performed. 19 Q. How do you determine whether to directly assign costs to a particular customer or 20 customer class? 21 A. Direct assignments of plant and expenses to particular customers or classes of customers are 22 made on the basis of special studies wherever the necessary data are available. These 23 PAGE 23 OF 44 R. AMEN, DI INTERMOUNTAIN GAS assignments are developed by detailed analyses of the utility's maps and records, work order 1 descriptions, property records and customer accounting records. Within time and budgetary 2 constraints, the greater the magnitude of cost responsibility based upon direct assignments, 3 the less reliance need be placed on common plant allocation methodologies associated with 4 joint use plant. 5 Q. Is it realistic to assume that a large portion of the plant and expenses of a utility can 6 be directly assigned? 7 A. No. The nature of utility operations is characterized by the existence of common or joint use 8 facilities, as mentioned earlier. Out of necessity, then, to the extent a utility's plant and 9 expense cannot be directly assigned to customer groups, common allocation methods must 10 be derived to assign or allocate the remaining costs to the customer classes. The analyses 11 discussed above facilitate the derivation of reasonable allocation factors for cost allocation 12 purposes. 13 V.INTERMOUNTAIN’S COST OF SERVICE STUDY Q. Please describe the process of performing Intermountain’s COSS analysis. 14 A. Three broad steps were followed to perform the Company's COSS: (1) functionalization, (2) 15 classification, and (3) allocation. The first step, functionalization, identifies and separates 16 plant and expenses into specific categories based on the various characteristics of utility 17 operation. The Company's functional cost categories associated with gas service include 18 storage, transmission, distribution, and general (customer). The general function includes 19 costs that cannot be directly assigned to the primary operating functions of storage, 20 transmission, and distribution. These costs are functionalized in accordance with the Federal 21 Energy Regulatory Commission (FERC) Uniform System of Accounts (USOA). 22 PAGE 24 OF 44 R. AMEN, DI INTERMOUNTAIN GAS Classification of costs, the second step, further separates the functionalized plant and 1 expenses into the three cost-defining characteristics previously discussed: (1) customer, (2) 2 demand or capacity, and (3) commodity, along with an additional revenue classification 3 consisting of working capital items and revenue. The final step is the allocation of each 4 functionalized and classified cost element to the individual customer class. Costs typically 5 are allocated on customer, demand, commodity, or revenue allocation factors. 6 Q. Are there factors that can influence the overall cost allocation framework utilized by 7 a gas utility when performing a COSS? 8 A. Yes. The factors which can influence the cost allocation used to perform a COSS include: 9 (1) the physical configuration of the utility’s gas system; (2) the availability of data within 10 the utility; and (3) the state legislative and regulatory policies and evidentiary requirements 11 applicable to the utility. 12 Q. Why are these considerations relevant to conducting Intermountain’s COSS? 13 A. It is important to understand these considerations because they influence the overall context 14 within which a utility's cost study was conducted. In particular, they provide an indication 15 of where efforts should be focused for purposes of conducting a more detailed analysis of 16 the utility's gas system design and operations and understanding the regulatory environment 17 in the State of Idaho as it pertains to cost of service studies and gas ratemaking issues. 18 Q. Please explain why the physical configuration of the system is an important 19 consideration. 20 PAGE 25 OF 44 R. AMEN, DI INTERMOUNTAIN GAS A. The particulars of the physical configuration of the transmission and distribution system are 1 important. The specific characteristics of the system configuration, such as, whether the 2 distribution system is a centralized or a dispersed one, should be identified. Other such 3 characteristics are whether the utility has a single city-gate or a multiple city-gate 4 configuration, whether the utility has an integrated transmission and distribution system or 5 a distribution-only operation, and whether the system is a multiple pressure based or a single 6 pressure-based operation. 7 Q. What are the specific physical characteristics of Intermountain’s system? 8 A. The physical configuration of Intermountain’s system is a dispersed / multiple city-gate, 9 storage, transmission, distribution, and multi pressure-based system. 10 Q. What was the source of the cost data analyzed in the Company's COSS? 11 A. All cost of service data has been extracted from the Company's total cost of service (i.e., 12 total revenue requirement) and subsidiary schedules contained in this filing. 13 Q. How does the availability of data influence a COSS? 14 A. The structure of the utility’s books and records can influence the cost study framework. This 15 structure relates to attributes such as the level of detail, segregation of data by operating unit 16 or geographic region, and the types of load data available. Intermountain maintains many 17 detailed plant accounting records for its distribution-related facilities. 18 Q. How are Intermountain’s classes structured for purposes of the COSS? 19 A. The COSS evaluated five customer classes: Residential (RS, IS-R), General (GS, IS-C), 20 Large Volume (LV-1), Interruptible Transport (T-3), and Firm Transport (T-4). 21 Q. Do you propose any modifications to the current classes? 22 A. No. 23 PAGE 26 OF 44 R. AMEN, DI INTERMOUNTAIN GAS Q. Please describe the process of performing Intermountain’s COSS analysis. 1 A. The detailed process description of Intermountain’s COSS analysis is presented in Exhibit 2 2 - Cost of Service Study. Exhibit 2 provides a full scope of the COSS development 3 process and the results. 4 Q. Please discuss the content of Exhibit 2. 5 A. Exhibit 2 – Cost of Service Study consists of three sections detailing the process of 6 developing the COSS. The first section includes an introduction, the general purpose, and 7 an overview of the excel-based fully functional COSS model presented in this proceeding. 8 The second section presents the COSS development process specific to the Company 9 including Functionalization, Classification, and Allocation. The Allocation section 10 specifically describes all internal and external allocation factors and development bases and 11 processes used in the COSS. The last section depicts the results of the cost of service study, 12 including revenue requirement apportionment, comparison of cost of service with revenues 13 under present and proposed rates, and development of rate of return by customer class under 14 present and proposed rates. 15 Q. Please describe the schedules included in Exhibit 2. 16 A. The following is the list of Schedules included in Exhibit 2: 17 Schedule 1 - Account Balances, Functionalization, Classification and Allocation 18 Schedule 2 - External Allocation Factors 19 Schedule 3 - Internal Allocation Factors 20 Schedule 4 - Cost of Service and Rate of Return under Present and Proposed Rates 21 Schedule 5 - Cost of Service Allocation Study Detail by Account 22 PAGE 27 OF 44 R. AMEN, DI INTERMOUNTAIN GAS Schedule 6 - Functionalized and Classified Rate Base and Revenue Requirement, 1 and Unit Costs by Customer Class 2 Schedule 7 – Alternative Cost of Service and Rate of Return Under Present and 3 Proposed Rates 4 Q. Please explain the COSS information contained in Schedules 1 through 7. 5 A. Schedule 1 displays revenue requirements presented by FERC accounts with corresponding 6 selections of functions, classifications, and allocations methods applied to the accounts. 7 Schedule 2 and Schedule 3 depict the derivation of external and internal allocation factors 8 that are explained in detail in Exhibit 2. Schedule 4 is a summary of the cost to serve as 9 compared to revenues under present and proposed rates. Schedule 5 is a detailed cost of 10 service study presented by the FERC accounts for the individual rate classes. Schedule 6 11 presents a summary of functionalized and classified rate base and revenue requirements 12 along with derived unit cost by customer class. Lastly, Schedule 7 presents a summary of 13 the cost of service similar to Schedule 4, based on the peak load study with interruptible 14 customers included, which is discussed below in this testimony. 15 Q. How did the COSS classify and allocate underground storage plant? 16 A. The storage plant accounts contain the costs related to the Company's LNG facilities. These 17 facilities are needed to provide deliverability and reliability during peak periods. Because of 18 the cost and cycle characteristics, LNG withdrawals are typically reserved for needle peaking 19 during very cold weather events or for system integrity events. Therefore, the storage plant 20 accounts are classified as demand and allocated on a peak day basis. 21 Q. How did the COSS classify and allocate transmission plant? 22 PAGE 28 OF 44 R. AMEN, DI INTERMOUNTAIN GAS A. The transmission plant accounts contain the costs related to the Company's high pressure 1 transmission facilities. These facilities were designed and sized to provide deliverability 2 during peak periods. Therefore, the transmission plant accounts are classified as demand and 3 allocated on a peak day basis. 4 Q. How did the Company’s COSS classify and allocate investment in Distribution 5 Mains? 6 A. The Company classified 55.3% of its investment in distribution mains as customer-related 7 and 44.7% of the investment as demand-related. The customer related portion of the 8 distribution mains investment was then allocated based on the number of customers on 9 Intermountain’s distribution system. The demand related investment was allocated to the 10 customer classes based on the respective contributions to peak day demand. 11 Q. Please explain the basis for the Company’s choice of classification and allocation 12 methods?13 A. It is widely accepted that distribution mains are installed to meet both system peak period 14 load requirements and to connect customers to the LDC's gas system. Therefore, to ensure 15 that the rate classes that cause the Company to incur this plant investment or expense are 16 charged with its cost, distribution mains should be allocated to the rate classes in proportion 17 to their peak period load requirements and number of customers. 18 There are two cost factors that influence the level of distribution mains facilities 19 installed by an LDC in expanding its gas distribution system. First, the size of the distribution 20 main (i.e., the diameter of the main) is directly influenced by the sum of the peak period gas 21 demands placed on the LDC's gas system by its customers. Secondly, the total installed 22 footage of distribution mains is influenced by the need to expand the distribution system grid 23 PAGE 29 OF 44 R. AMEN, DI INTERMOUNTAIN GAS to connect new customers to the system. Therefore, to recognize that these two cost factors 1 influence the level of investment in distribution mains, it is appropriate to allocate such 2 investment based on both peak period demands and the number of customers served by the 3 LDC. 4 Q. Is the method used by the Company to determine a customer cost component of 5 distribution mains a generally accepted technique for determining customer costs? 6 A. Yes. The two most commonly used methods for determining the customer cost component 7 of distribution mains facilities consist of the following: (1) the zero-intercept approach and 8 2) the most commonly installed, minimum-sized unit of plant investment. Under the zero-9 intercept approach, a customer cost component is developed through regression analyses to 10 determine the unit cost associated with a zero-inch diameter distribution main. The method 11 regresses current unit costs associated with the various sized distribution mains installed on 12 the LDC's gas system against the size (diameter squared inches) of the weighted distribution 13 mains installed. The zero-intercept method seeks to identify that portion of plant 14 representing the smallest size pipe required merely to connect any customer to the LDC's 15 distribution system, regardless of the customer’s peak or annual gas consumption. 16 The most commonly installed, minimum-sized unit approach is intended to reflect 17 the engineering considerations associated with installing distribution mains to serve gas 18 customers. That is, the method utilizes actual current installed investment units to determine 19 the minimum distribution system rather than a statistical analysis based upon investment 20 characteristics of the entire distribution system. 21 Two of the more commonly accepted literary references relied upon when preparing 22 embedded cost of service studies, Electric Utility Cost Allocation Manual, by John J. Doran 23 PAGE 30 OF 44 R. AMEN, DI INTERMOUNTAIN GAS et al, National Association of Regulatory Utility Commissioners (“NARUC”), and Gas Rate 1 Fundamentals, American Gas Association, both describe minimum system concepts and 2 methods as an appropriate technique for determining the customer component of utility 3 distribution facilities. 4 Clearly, the existence and utilization of a customer component of distribution 5 facilities, specifically for distribution mains, is a fully supportable and commonly used 6 approach in the gas industry. 7 For purposes of determining the customer component of distribution mains to be used 8 in Intermountain’s COSS, the zero-intercept method was employed, the detailed 9 development process of which is presented in Exhibit 2. 10 Q. Was the same method to classify and allocate distribution mains utilized in the 2016 11 Case? 12 A. Yes. The Company used similar classification and allocation methods in its previous general 13 rate case proceeding. 14 Q. How did the COSS classify and allocate the remainder of the distribution plant? 15 A. Special studies were performed for the allocation of Accounts 380 (Services), 381 (Meters), 16 and 385 (Industrial Measuring and Regulating Station Equipment). The costs in account 383 17 (House Regulators) were classified and allocated based upon the results of the meters study. 18 The development steps of these are discussed in Exhibit 2. 19 The plant costs in Account 378 (Measuring and Regulating Station Equipment – 20 General) and Account 379 (Measuring and Regulating Station Equipment – City Gas 21 Stations) were classified as capacity or demand-related and allocated on a customer and peak 22 demand composite allocator. 23 PAGE 31 OF 44 R. AMEN, DI INTERMOUNTAIN GAS Account 374 (Land and Land Rights) are associated with distribution mains and 1 therefore, were allocated on the same factor as distribution mains. Account 375 (Structures 2 and Improvements) was allocated based on the allocation of the distribution plant accounts. 3 Q. How did the COSS classify and allocate general plant? 4 A. General Plant was classified and allocated to the rate schedules based upon the allocation of 5 storage, transmission, and distribution plant. Mathematically, this is the sum of storage, 6 transmission, and distribution plant accounts that were allocated by rate class. That total by 7 rate class is then divided by the total company amount to find each rate class’s percentage 8 allocation. Account 391 (Office Furniture and Equipment) was allocated based on the factor 9 derived based on the Company’s labor cost records. 10 Q. How are other rate base components classified and allocated in the COSS? 11 A. Accumulated Provision for Depreciation and Amortization is presented by FERC accounts 12 and allocated based on the same allocation factor as the related plant in service accounts. 13 This treatment ensures that the net plant for each FERC account is allocated consistently to 14 each customer class. Accumulated Deferred Income Taxes are presented on the functional 15 level and allocated based on the relevant internal plant allocator as shown in Exhibit 2. 16 Account 154 (Material and Supplies) was allocated based on the allocation of 17 storage, transmission, and distribution plant. Account 164 (LNG Inventory) balance was 18 allocated based on the peak day factor as the inventory exists to ensure reliability during 19 peak periods. Customer Account 252 (Advances for Construction) was allocated based on 20 the mains and service plant balances. 21 PAGE 32 OF 44 R. AMEN, DI INTERMOUNTAIN GAS Q. How are operation and maintenance (“O&M”), customer accounts, customer services 1 and information (“Customer”), and administrative and general (“A&G”) expenses 2 classified and allocated in COSS? 3 A. A utility’s O&M expenses generally are thought to support the corresponding plant in 4 service accounts. In general, O&M expenses are allocated based on the cost allocation 5 methods used for the Company’s corresponding plant accounts. The majority of Customer 6 expenses were classified as customer-related costs and allocated based on the average 7 number of distribution customers by class, except for Account No. 904 (Uncollectible 8 Accounts Expense), which is allocated based upon the three-year average of uncollectible 9 write-offs. A&G expenses were allocated on an account-by-account basis. Items related to 10 labor costs, such as employee pensions and benefits, were allocated based on O&M labor 11 costs. Items related to the plant in service, such as maintenance of the general plant and 12 property taxes, were allocated based on the plant allocator. The detailed classification and 13 allocation methods applied to these expense categories can be found on Schedule 1 of 14 Exhibit 2. 15 Q. Were any additional studies performed in Intermountain’s COSS? 16 A. Yes. Certain categories of gas supply and gas system control related O&M expenses include 17 salaries and benefits of personnel in the following responsibility centers: Gas Supply 18 Resource Planning, Gas Supply, and Gas Control. The corresponding labor expenses were 19 distributed among the three categories of Gas Planning, Gas Supply, and Gas Control based 20 on the time allocations reported by the personnel in these responsibility centers. These 21 expenses were first segregated between sales and transportation classes and then allocated 22 to customer classes as discussed in Exhibit 2. 23 PAGE 33 OF 44 R. AMEN, DI INTERMOUNTAIN GAS Q. Please discuss the classification and allocation of the remaining expenses. 1 A. Depreciation and amortization expense is presented on the functional level and allocated 2 based on the relevant internal plant allocator, as demonstrated in Exhibit 2. Taxes other 3 than income are allocated in a manner that reflected the specific cost associated with each 4 tax expense category. Generally, taxes can be cost classified on the basis of the tax 5 assessment method established for each tax category and can be grouped into the following 6 categories: (1) labor; (2)plant; and (3) revenue. In the Intermountain’s COSS, all non-7 income taxes were assigned to one of the above stated categories and relevant allocation 8 factors. 9 Current income taxes were allocated based on each class’s net income before taxes. 10 Income taxes for the total revenue requirement were allocated to each class based on the 11 allocation of the required net income by rate class. Income taxes at proposed revenues by 12 class were allocated to each class based on the proposed income prior to taxes for each 13 class. 14 Q. Please summarize the results of Intermountain’s COSS. 15 A. Table 9 below presents a summary of the results of the Company’s COSS that can be 16 reviewed in detail in Schedule 4 of Exhibit 2. The COSS shows an overall revenue deficiency 17 to the Company of $6.8 million. 18 PAGE 34 OF 44 R. AMEN, DI INTERMOUNTAIN GAS Table 9 Summary Results of the COSS Table 9 presents the revenue deficiency/excess for each rate class, the class rate of return 1 on net rate base at current rates, the revenue to cost ratio, and the associated parity ratio. 2 Regarding rate class revenue levels, the results show that all classes except Residential, are 3 being charged rates that recover more than their indicated costs of service. 4 Q. Please discuss the COSS results prepared based on the peak load study inclusive of the 5 interruptible customer classes. 6 A. An additional COSS analysis was prepared based on the peak load study results inclusive of 7 the interruptible customers, as discussed earlier in the testimony and presented in Table 7. 8 The summary of the COSS results under the alternative peak load allocation study 9 (“Alternative COSS”) is presented in Schedule 7 of Exhibit 2. Table 10 below depicts the 10 results of the Alternative COSS. 11 Table 10 Summary Results of the Alternative COSS Customer Classes Current Revenues Cost to Serve Current Rate of Return Deficiency/ (Surplus) Current Revenue to Cost Ratio Current Parity Ratio Residential Service 70,866,860$ 85,590,964$ 2.9%14,724,104$ 0.83 0.88 General Service 26,416,220 21,530,144 13.3%(4,886,076)1.22 1.30 Large Volume 706,333 524,521 16.0%(181,812)1.34 1.42 Transport Service(Interruptible)559,724 85,274 273.8%(474,450)6.45 6.84 Transport Service(Firm)9,799,443 7,369,901 15.0%(2,429,542)1.32 1.40 Subtotal 108,348,580$ 115,100,804$ 6,752,224$ Other Revenues 2,462,855 2,462,855 - Total System 110,811,435$ 117,563,659$ 6.1%6,752,224$ 0.94 1.00 Customer Classes Current Revenues Cost to Serve Current Rate of Return Deficiency/ (Surplus) Current Revenue to Cost Ratio Current Parity Ratio Residential Service 70,866,860$ 85,336,867$ 2.9%14,470,007$ 0.83 0.88 General Service 26,416,220 21,419,321 13.5%(4,996,899)1.23 1.30 Large Volume 706,333 518,449 16.4%(187,884)1.35 1.44 Transport Service(Interruptible)559,724 573,012 7.1%13,288 0.98 1.04 Transport Service(Firm)9,799,443 7,253,154 15.5%(2,546,289)1.34 1.43 Subtotal 108,348,580$ 115,100,804$ 6,752,224$ Other Revenues 2,462,855 2,462,855 - Total System 110,811,435$ 117,563,659$ 6.1%6,752,224$ 0.94 1.00 PAGE 35 OF 44 R. AMEN, DI INTERMOUNTAIN GAS Q. Why are you presenting an Alternative COSS in this proceeding? 1 A. The Transportation Service Interruptible class has a limited presence in the Company’s 2 design day peak for purposes of the IRP. For peak event modeling purposes, the IRP assumes 3 T-3 customers are reduced to minimal emergency plant-heat only.10 As noted earlier in 4 Section IV. Load Study and Analysis, T-3 customers are interruptible, and therefore, have 5 no assurance of the amount of capacity that they may be granted on any given peak day. 6 However, given that Intermountain has rarely interrupted these customers, it is reasonable 7 to provide a level of demand as their contribution to the system peak for purposes of the 8 COSS. The alternative COSS is intended to demonstrate the impact particularly on the 9 Transportation Interruptible class by their inclusion at a 100% load factor demand level in 10 the allocation of system demand related costs. 11 Q. How do the COSS results compare to the alternative method that is based on the peak 12 load study inclusive of the interruptible customer classes? 13 A. Table 11 below provides a comparison between the two options. As expected under the 14 Alternative COSS method Transportation Service Interruptible Class shows an increase in 15 cost to serve. However, the resulting class revenue to cost ratio (“R:C”) of .98 remains above 16 the system R:C ratio of 0.94, compared to the 6.45 R:C level when no system demand 17 contribution is attributable to the class.18 10 Ibid, at pg. 39. PAGE 36 OF 44 R. AMEN, DI INTERMOUNTAIN GAS Table 11 Comparison of COSS Results under Proposed and Alternative Methods VI.PRINCIPLES OF SOUND RATE DESIGN Q. Please identify the principles of rate design utilized in development of the Company’s 1 rate design proposals. 2 A. Several rate design principles find broad acceptance in the recognized literature on utility 3 ratemaking and regulatory policy. These principles include: 4 (1)Cost of Service; 5 (2)Efficiency; 6 (3)Value of Service; 7 (4)Stability/Gradualism; 8 (5)Non-Discrimination; 9 (6)Administrative Simplicity; and 10 (7)Balanced Budget. 11 These rate design principles draw heavily upon the “Attributes of a Sound Rate Structure” 12 developed by James Bonbright in Principles of Public Utility Rates.1113 11 Principles of Public Utility Rates, Second Edition, Page 111-113 James C. Bonbright, Albert L. Danielson, David R. Kamerschen, Public Utility Reports, Inc., 1988. Customer Classes Cost to Serve Cost to Serve (Alternative)Difference Revenue to Cost Ratio Revenue to Cost Ratio (Alternative) Residential Service 85,590,964$ 85,336,867$ 254,097$ 0.83 0.83 General Service 21,530,144 21,419,321 110,823 1.22 1.23 Large Volume 524,521 518,449 6,071 1.34 1.35 Transport Service(Interruptible)85,274 573,012 (487,739)6.45 0.98 Transport Service(Firm)7,369,901 7,253,154 116,747 1.32 1.34 Subtotal 115,100,804$ 115,100,804$ -$ Other Revenues 2,462,855 2,462,855 - Total System 117,563,659$ 117,563,659$ -$ 0.94 0.94 PAGE 37 OF 44 R. AMEN, DI INTERMOUNTAIN GAS Q. Can the objectives inherent in these principles compete with each other at times? 1 A. Yes. These principles can compete with each other, and this tension requires further 2 judgment to strike the right balance between the principles. Detailed evaluation of rate 3 design recommendations must recognize the potential and actual tension between these 4 principles. Indeed, Bonbright discusses this tension in detail. Rate design recommendations 5 must deal effectively with such tension. There are tensions between cost and value of 6 service principles as well as efficiency and simplicity. There are potential conflicts between 7 simplicity and non-discrimination and between value of service and non-discrimination. 8 Other potential conflicts arise where utilities face unique circumstances that must be 9 considered as part of the rate design process. 10 Q. How are these principles translated into the design of rates? 11 A. The overall rate design process, which includes both the apportionment of the revenues to 12 be recovered among rate classes and the determination of rate structures within rate 13 classes, consists of finding a reasonable balance between the above-described criteria or 14 guidelines that relate to the design of utility rates. Economic, regulatory, historical, and 15 social factors all enter the process. In other words, both quantitative and qualitative 16 information is evaluated before reaching a final rate design determination. Out of necessity 17 then, the rate design process must be, in part, influenced by judgmental evaluations. 18 VII.DETERMINATION OF PROPOSED CLASS REVENUES Q. Please describe the approach generally followed to allocate Intermountain’s proposed 19 revenue increase of $6.8 million to its rate schedules. 20 A. The apportionment of revenues among rate schedules consists of deriving a reasonable 21 balance between various criteria or guidelines that relate to the design of utility rates. The 22 PAGE 38 OF 44 R. AMEN, DI INTERMOUNTAIN GAS various criteria that were considered in the process included: (1) cost of service; (2) rate 1 schedule contribution to present revenue levels; and (3) customer impact considerations. These 2 criteria were evaluated for Intermountain’s rate schedules. 3 Q. Have various rate schedule revenue options been considered in conjunction with your 4 evaluation and determination of Intermountain’s interclass revenue proposal? 5 A. Yes. Using Intermountain’s proposed revenue increase, and the results of its COSS, a few 6 options were evaluated for the assignment of that increase among its rate schedules and, in 7 conjunction with Intermountain personnel and management, ultimately decided upon one of 8 those options as the preferred resolution of the interclass revenue issue. The benchmark 9 option that was evaluated under Intermountain’s proposed total revenue level was to adjust 10 the revenue level for each rate schedule so that the R:C ratio for each class was equal to 11 parity or 1.00 (Unity), as shown in Exhibit 3, under Scenario A: Revenues at Equalized Rates 12 of Return. Rate schedules above parity would suggest the need for revenue decreases in order 13 to move them closer to cost (i.e., a convergence of the resulting revenue-to-cost ratios 14 towards unity or 1.00).15 The resulting customer impact implications for the Residential Service class have led 16 to the conclusion, in consultation with the Company, to refrain from revenue reductions for 17 the remaining customer classes. From a policy perspective, Intermountain believed that 18 every rate schedule should participate in the proposed overall revenue increase. Therefore, 19 as a matter of judgment, it was decided that this fully cost-based option was not the preferred 20 solution to the interclass revenue question. It should be pointed out, however, that those class 21 revenue results represented an important guide for purposes of evaluating subsequent rate 22 design options from a cost of service perspective. 23 PAGE 39 OF 44 R. AMEN, DI INTERMOUNTAIN GAS A second option considered was assigning the increase in revenues to 1 Intermountain’s rate schedules based on an equal percentage basis of its current margin 2 revenues (see Scenario B, Equal Percentage Increase), in Exhibit 3. By definition, this 3 option resulted in each rate schedule receiving an increase in revenues equal to the system 4 average. However, when this option was evaluated against the COSS Study results (as 5 measured by changes in the revenue-to-cost ratio for each customer class); there was no 6 movement towards cost for most of Intermountain’s rate schedules (i.e., there was no 7 convergence of the resulting revenue-to-cost ratios towards unity or 1.00). While this option 8 was not the preferred solution to the interclass revenue issue, together with the fully cost-9 based option, it defined a range of results that provides further guidance to develop 10 Intermountain’s class revenue proposal. 11 A third option considered was moderately assigning the increase in revenues to all 12 Intermountain’s rate schedules (Scenario C: Moderated based on Current Parity Ratio), 13 which is the proposed revenue allocation method in this proceeding.14 Q. What was the result of this process? 15 A. The various criteria that were considered in the process included: (1) cost of service; (2) 16 class contribution to present revenue levels; and (3) customer impact considerations. After 17 further discussions with Intermountain, the conclusion reached was the appropriate 18 interclass revenue proposal would consist of adjustments, in varying proportions, to the 19 present revenue levels in all of Intermountain’s rate schedules. 20 The Residential margin revenue increase was limited to 7.79% or 1.25 of the relative 21 system increase (6.23%). The minimum increase was applied to the Interruptible Transport 22 of 0.25 of the relative system increase, which resulted in 1.56% of margin revenue increase. 23 PAGE 40 OF 44 R. AMEN, DI INTERMOUNTAIN GAS The remainder of the margin revenue increase was allocated among General Service, Large 1 Volume, and Firm Transport rate schedules, which resulted in an 3.31% margin revenue 2 increase or 0.53 of the relative system increase. This revenue apportion is shown in Direct 3 Exhibit 3 as Proposed Scenario C: Moderated based on the Current Parity Ratio. 4 Q. What is the recommended increase for each rate class? 5 A. In summary, this preferred revenue allocation approach resulted in reasonable movement of 6 the customer classes’ revenue-to-cost ratio toward unity as shown on Table 12 below, while 7 providing moderation of the revenue impact by requiring some level of revenue increase 8 responsibility from all rate schedules for the Company’s total proposed revenue requirement. 9 Table 12 Current and Proposed Parity Ratios From a class cost of service standpoint, this type of rate schedule movement, and modest 10 reduction in the existing class rate subsidies, is desirable. 11 The following Table 13 summarizes the proposed distribution margin revenue 12 change for each rate class and the percent change in distribution margin revenues resulting 13 from the above-described process. 14 Customer Classes Current Parity Ratio Proposed Parity Ratio Residential Service 0.88 0.89 General Service 1.30 1.26 Large Volume 1.42 1.38 Transport Service(Interruptible)6.84 6.55 Transport Service(Firm)1.40 1.37 Total System 1.00 1.00 PAGE 41 OF 44 R. AMEN, DI INTERMOUNTAIN GAS Table 13 Proposed Class Revenue Apportionment 1 VIII.INTERMOUNTAIN’S RATE DESIGN Q. Please summarize the rate design changes Intermountain has proposed in this rate 2 proceeding. 3 A. The proposed rate design includes (1) increases in the fixed monthly customer charges for 4 Residential and General Service classes, (2) increases in demand rates to Large Volume 5 and Firm Transport classes, (3) introduction of fixed monthly customer charges to Large 6 Volume, Interruptible Transport, and Firm Transport classes, and (4) modification of the 7 declining block rates for the Large Volume class. Once the fixed monthly customer charge 8 targets and demand rates were set for each rate class, the remaining proposed revenues for 9 each rate class were recovered through the volumetric charges. 10 Q. Please describe the changes to the monthly customer charge levels. 11 A. Table 14 provides a summary of current and proposed customer charges by rate schedule 12 as compared to the COSS results: 13 Customer Classes Margin Revenues at Current Rates Margin Revenues at Proposed Rates Proposed Revenue Change Percent Change Increase Relative to System Increase Proposed Parity Ratio Residential Service 70,866,860$ 76,387,340$ 5,520,480$ 7.79%1.25 0.89 General Service 26,416,220 27,291,245 875,025 3.31%0.53 1.26 Large Volume 706,333 729,730 23,397 3.31%0.53 1.42 Transport Service(Interruptible)559,724 568,444 8,720 1.56%0.25 6.71 Transport Service(Firm)9,799,443 10,124,045 324,602 3.31%0.53 1.37 Subtotal 108,348,580$ 115,100,804$ 6,752,224$ 6.23%1.00 Other Revenues 2,462,855 2,462,855 -- Total System 110,811,435$ 117,563,659$ 6,752,224$ 6.09%1.00 PAGE 42 OF 44 R. AMEN, DI INTERMOUNTAIN GAS Table 14 Current and Proposed Customer Charge Overall, the proposed customer charges are within reasonable range of increases 1 considering the customer unit costs per rate class supported by the COSS results, as indicated 2 on Schedule 6 of Exhibit 2. These increases to the basic customer charges will provide 3 significant improvement in the recovery of the fixed customer-related costs via fixed 4 charges. To offset the foregoing increases to the basic customer charges, all blocks of the 5 volumetric rates in the respective tariff schedules were reduced ratably based on the margin 6 revenue in each block, with one exception. The block structure of the Large Volume Firm 7 Sales Service tariff was changed, which is discussed later in this section. 8 Q. Why is the Company proposing to increase the fixed monthly customer charges? 9 A. The primary goal of rate design was to move towards recovery of fixed costs by increasing 10 all customer charges. This resulted in better alignment between the fixed costs incurred by 11 Intermountain and the charges incurred by customers. 12 Q. Please describe the changes proposed to the demand rate. 13 A. The current demand charge in Large Volume and Firm Transportation classes of $0.30 per 14 therms per month is proposed to be raised to $0.32, which will recover approximately 90% 15 of the unit demand-related costs for these customer classes. 16 Q. What changes do you propose to the Large Volume block rate structure? 17 Rate Classes Current Customer Charge COSS Unit Cost Proposed Customer Charge Change Percent Change Residential Service 5.50$ 12.23$ 9.00$ 3.50$ 63.64% Residential Service (Interruptible)5.50$ 12.23$ 8.00$ 2.50$ 45.45% General Service 9.50$ 33.14$ 15.00$ 5.50$ 57.89% General Service (Interruptible)9.50$ 33.14$ 12.50$ 3.00$ 31.58% Large Volume -$ 496.26$ 150.00$ 150.00$ - Transport Service (Firm)-$ 1,055.80$ 150.00$ 150.00$ - Transport Service (Interruptible)-$ 963.42$ 300.00$ 300.00$ - PAGE 43 OF 44 R. AMEN, DI INTERMOUNTAIN GAS A. Under Intermountain’s current tariff, any new customer under Large Volume Firm Sales 1 Service (Tariff Sheet No. 7) is required not to exceed usage of 500,000 therms annually, 2 while the current block rate is structured as follows: 3 Block 1 - First 250,000 therms per bill 4 Block 2 - Next 500,000 therms per bill 5 Block 3 - Over 750,000 therms per bill 6 Under this scenario, customers are unable to benefit from the declining block rates. By 7 reviewing historical usage patterns, a new block structure was developed as follows: 8 Block 1 - First 35,000 therms per bill 9 Block 2 - Next 35,000 therms per bill 10 Block 3 - Over 70,000 therms per bill 11 Q. Have you provided an exhibit detailing the proposed rates and corresponding 12 revenues? 13 A. Yes. Exhibit 4 shows the derivation of each rate component for each of Intermountain’s 14 tariff schedules and the corresponding revenues generated from those proposed rates. 15 Q. Have you prepared bill impacts? 16 A. Yes. Exhibit 5 provides monthly bill impacts for Residential, General, and Interruptible 17 Transportation rate classes presented as a range of monthly usage (therms) and 18 corresponding bills under current and proposed rates. The bill impacts for Large Volume and 19 Firm Transportation customers are presented as various scenarios of monthly usage and 20 MDFQ with corresponding bills under current and proposed rates. 21 PAGE 44 OF 44 R. AMEN, DI INTERMOUNTAIN GAS IX.CONCLUDING REMARKS Q. Please summarize your recommendations. 1 For purposes of Intermountain’s allocated class cost of service study, the Load Study results 2 which use the Monthly peak load sendout model to determine the Core peak day sendout are 3 recommended. It provides superior results in predicting peak day sendout. These results are 4 aligned with Intermountain’s projections of peak day sendout in its 2021-2026 IRP. 5 I recommend the Commission accept the COSS presented in Section VI of this 6 testimony, including the proposed class revenue apportionment. The COSS represents a fair 7 and reasonable allocation of cost responsibility for each rate class, based on the Company’s 8 proposed total system revenue increase. The Company’s proposed COSS allocation method 9 for distribution mains best reflects the cost causative characteristics of extending service to 10 new customers and sized to meet peak demand requirements. As such, the Commission 11 should rely on the Company’s proposed COSS to guide revenue targets for each rate class. 12 The revenue targets proposed by Intermountain reasonably balance the concepts of 13 cost of service, current revenue contributions, and gradualism, while moving all classes 14 closer to parity. Lastly, the COSS model demonstrates that fixed costs, both customer-related 15 and demand-related are materially higher than the current level of customer charges; 16 therefore, the proposed increases to customer charges should be approved by the 17 Commission to better align fixed cost occurrence with fixed cost recovery and price signals 18 received by customers. 19 Q. Does this conclude your testimony?20 A. Yes, although I reserve the right to supplement or amend my testimony before or during the 21 Commission’s hearing in this proceeding. 22 Preston N. Carter, ISB No. 8462 Morgan D. Goodin, ISB No. 11184 Blake Ringer, ISB No. 11223 Givens Pursley LLP 601 W. Bannock St. Boise, ID 83702 Telephone: (208) 388-1200 Facsimile: (208) 388-1300 prestoncarter@givenspursley.com morgangoodin@givenspursley.com blakeringer@givenspursley.com Attorneys for Intermountain Gas Company BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION IN THE MATTER OF THE APPLICATION OF INTERMOUNTAIN GAS COMPANY. FOR AUTHORITY TO INCREASE ITS RATES AND CHARGES FOR NATURAL GAS SERVICE IN THE STATE OF IDAHO Case No. INT-G-22-07 BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION UPDATED EXHIBITS 2, 3, 4, AND 5 TO ACCOMPANY THE UPDATED DIRECT TESTIMONY OF RONALD J. AMEN BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION Case No. INT-G-22-07 INTERMOUNTAIN GAS COMPANY EXHIBIT 2 SUPPLEMENTAL COST OF SERVICE ALLOCATION STUDY TEST YEAR DECEMBER 31, 2022 Witness: Ronald J. Amen INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 1 of 36 Contents I.INTRODUCTION ................................................................................................................................ 3 1.Atrium Economics Cost of Service Study Model Overview ............................................................ 3 II.INTERMOUNTAIN’S COST OF SERVICE PROCEDURES ............................................................ 4 1.Functionalization ............................................................................................................................... 4 2.Classification ..................................................................................................................................... 4 3.Allocation .......................................................................................................................................... 5 3.1. Customer Classes and Tariff Schedules .................................................................................... 5 3.2. External Allocation Factors ...................................................................................................... 5 3.3. Internal Allocation Factors ........................................................................................................ 8 III.INTERMOUNTAIN’S COST OF SERVICE RESULTS .................................................................. 10 1.Schedule 1 - Account Balances and Allocation Methods ............................................................... 10 2.Schedule 2 - External Allocation Factors ....................................................................................... 19 3.Schedule 3 - Internal Allocation Factors ........................................................................................ 20 4.Schedule 4 - Cost of Service and Rate of Return Under Present and Proposed Rates ................... 21 5.Schedule 5 - Cost of Service Allocation Study Detail by Account ................................................ 23 6.Schedule 6 - Functionalized and Classified Rate Base and Revenue Requirement, and Unit Costs by Customer Class .......................................................................................................................... 32 7. Schedule 7 – Alternative Cost of Service and Rate of Return Under Present and Proposed Rates ... 35 INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 2 of 36 I. INTRODUCTION The purpose of this document is to discuss the development and results of the Cost of Service Study (“COSS”) model and related schedules prepared for Intermountain Gas Company (“Intermountain” or the “Company”) based on the Test Year ended December 31, 2022 (“Test Year”). The document is organized into three sections. The first section includes an overview of Atrium’s COSS model used to develop the cost allocation study. The second section includes details of the methodologies adopted in the development of the study. The last section exhibits the results of the COSS study. 1. Atrium Economics Cost of Service Study Model Overview The Cost of Service Study is submitted in support of the direct testimony of Ronald J. Amen in Exhibit 2. The COSS model presented in this proceeding is an excel based model that allows the user to modify various inputs and assumptions. COSS Model Capabilities The Atrium Economics’ COSS model provides a large range of analytical capabilities including:  Unbundling of operations into functions: (i.e., production/supply, storage, transmission, distribution, metering, and billing services.)  Classification and allocation of costs into customer classes.  Reports on Rate of Return, Revenue Requirement, and Revenue-to-Cost ratio for each function and rate class.  Development of unit costs of each functional classification for each rate class.  Specification of the individual rate of return targets for each function or customer class.  Provides detailed analyses of costs of gas, income taxes, working capital, depreciation reserve, and depreciation expenses.  Use of detailed analysis of labor expenses by account to facilitate the analyses of administrative and general expenses and overhead costs.  Facilitation of direct assignment of plant investment, expenses, and revenue dollars to individual functions, classifications, or customer classes. Follows Traditional 3-Step Analysis Process The Atrium COSS Model follows the standard three-step analysis process:1) functionalization of rate base and expenses into various functional categories; 2) classification of functionalized components into demand, energy/commodity, and customer cost categories; and 3) allocation of each component among the customer classes. As part of the functionalization process, accounts for common costs that are not specifically related to the primary functions, such as general plant and administrative and general expenses, are automatically allocated to the proper function based on internally defined allocation factors. All components of the utility’s total cost of service are grouped into one of the functions. INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 3 of 36 The Atrium COSS Model provides unbundled functionalized and classified cost information by customer class; develops unbundled revenue requirements by functional classification for each customer class; and calculates unit costs by function for customer, commodity, and demand categories. Accounting costs are reported by FERC account level, and the allocation of A&G expenses, general taxes, and income taxes are clearly reported. Revenue requirements are calculated from the allocated rate base and expenses and are adjusted to reflect the user-determined target rate of return and statutory tax adjustments. The actual revenues collected are compared to the calculated cost-based revenue requirements to determine class-specific, revenue-to-cost ratios to assist in revenue allocation and pricing activities. Unit Cost Output Functionality The COSS model calculates the unit cost of each functional classification separately for each rate class based on the user-specified billing determinants. These unit cost data are among the most important outputs from an embedded cost of service analysis. They are defined as the average cost of providing service to customers per measure of service (i.e., per therm, per dekatherm of daily demand, and per customer). Unit costs are a key consideration in developing prices for bundled, unbundled, and re-bundled services. Acceptance by Utility Regulatory Commissions The format and presentation of the model’s outputs have been used in many rate case proceedings and conform to standard utility commission requirements. Where necessary, the COSS model outputs can be easily modified to meet specific jurisdictional filing requirements. II. INTERMOUNTAIN’S COST OF SERVICE PROCEDURES 1. Functionalization The following functional cost categories were identified for purposes of Intermountain’s cost allocation: • Storage • Transmission • Distribution • General (Customer) Intermountain’s assigned functional categories are presented on Schedule 1. 2. Classification The following classification categories were identified for purposes of Intermountain’s cost allocation:  Demand  Customer Intermountain’s assigned classification categories are presented on Schedule 1. INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 4 of 36 3. Allocation The allocation step involves assigning classified costs to the customer classes based on cost causation. Therefore, the allocation of costs is usually based on some measure of class loads or class service characteristics. The External (Schedule 2) and Internal (Schedule 3) Allocation Factors are utilized to allocate costs among various customer classes. Intermountain’s assigned Allocation Factors are presented on Schedule 1. 3.1.Customer Classes and Tariff Schedules The following customer classes were identified for purposes of cost allocation:  Residential Service  General Service  Large Volume  Transport Service (Interruptible)  Transport Service (Firm) 3.2.External Allocation Factors Intermountain’s External Allocation Factors are presented on Schedule 2. The External Allocation Factors are developed based on the special studies conducted using various detailed data as discussed below. Commodity and Revenue Allocation Factors Costs classified as “Commodity” are allocated among customer classes based on the weather- normalized volumes for the test year. REV – Factor developed to directly assign associated current base rate revenues to the specific class in the Test Year. COM – Factor developed to directly assign Weather Normalized Volumes/Throughput to the specific class in the Test Year. Customer Allocation Factors Customer-related costs are generally allocated based on the number of customers within each class of service, with appropriate weighting to recognize specific service characteristics. CUST – Customer Count factor is based on the average number of customers per customer class in the Test Year. CUST_SALES_TRANS - The costs associated with planning, gas supply, and control activities were specifically identified and allocated to the sales and transportation customer classes based on the time reported by the personnel in these responsibility centers. First, the expenses were segregated between sales and transport classes according to the assigned labor hours and then allocated among the customer classes. A portion of control activities was allocated to customer classes based on the number of alarms for the specifically identified customer classes and the INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 5 of 36 remaining costs were allocated based on the peak demand factor. The planning and supply related costs were allocated based on the test year weather normalized volumes. Based on these various components a composite allocator was created to incorporate this study into COSS. MTRS – Meter Allocation factor is based on the weighted customer class cost of meters used to serve gas customers in different rate classes. The analysis relies upon the Company’s records, which provide an inventory of each type and size of meter for a specific customer class, and related meter replacement costs. First, the meter records were grouped into three categories – Group 1, Group 2, and Group 3 based on the meter size. Next, the average unit cost per group for each customer class was derived. Then the relative weighting factor was derived by prorating to Residential Class unit cost. To derive the allocation basis, the weighted factor was multiplied by the test year customer bill counts for each customer class prorated by the groups. M&R – The factor was derived to allocate FERC Account 385 Industrial measuring and regulating station equipment. The analysis was performed based on the same set of data used to derive the Meters allocation factor. Similar steps were taken to develop an allocation basis, but only relying on Group 3 data and excluding the Residential Class. SERV – The analysis relies upon the data contained in the Company’s property records which provide an inventory and original cost of the service lines and service lines by diameter. The original cost data was restated in terms of current cost using Handy-Whitman indices for services to determine current unit cost. The interruptible snowmelt customer counts were removed for the purpose of this analysis, due to their shared service lines with the customer premise. The records were grouped into three groups: the Small Service group included service diameters of up to one inch, the next group of Medium Services included service diameters between one and two inches, and service lines with over two-inch diameters were identified as Large Services. Then, the unit cost per group was derived. Using meter data records, customers were grouped into similar groups (small meters, medium meters, and industrial meters). Applying service unit cost to relative customer group counts determined total estimated service costs by customer class and service cost per customer. Then the relative customer class unit cost was developed based on the Residential Class and multiplied by the test year customer count for each customer class. ACT_904 – The factor is based on the three-year (2019-2021) average of Bad Debt write-offs. Demand Allocation Factors PDAY_F&I – The factor is based on Peak Day capacity demand throughput for each customer class including Firm and Interruptible customer classes. PDAY_F – The factor is based on Peak Day capacity demand throughput for each customer class including Firm customer classes only. CUST_DEM_F&I – The composite factor is based on the CUST and PDAY_F&I factors prorated to the customer and demand components determined in the Mains Analysis. CUST_DEM_F – The composite factor is based on the CUST and PDAY_F factors prorated to the customer and demand components determined in the Mains Analysis. INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 6 of 36 Mains Analysis The allocation of investment in facilities serving a distribution function should recognize that the cost of these facilities is driven by two principal factors. First is the cost of extending the system to connect individual customers. Second is the cost associated with the capacity requirements of the customers connected. There are two widely accepted methods for the classification of mains between customer-related costs and demand-related costs. The two methods are the Minimum System Method and the Zero- Intercept Method, both relying on the Company’s property record data to determine the cost of pipe by size and type. Diameter groups that did not contain enough sample data were removed. The unit cost for pipe in any year is determined by dividing the booked costs by the amount of pipe installed in a standard unit of measurement. A variety of factors, such as the length of pipe installed, location, installation conditions, etc., cause the annual unit cost of pipe by size and type to vary significantly. Thus, a simple average of the yearly costs is not adequate for a determination of the cost for each size of the pipe as it will not reflect a consistent set of data. Therefore, the original cost data was restated in terms of current cost using the Handy-Whitman index. Zero-Intercept Study: The zero-intercept study was performed using a Weighted Linear Regression (WLR) on the cost per foot by pipe diameter. Based on this relationship, the study estimates the cost of installing a hypothetical pipe with zero capacity, which is where the estimated diameter is zero (i.e., the zero- intercept). The zero-intercept determined value is then multiplied by all quantities of distribution mains currently installed by the utility to arrive at a total minimum system cost. Total minimum system cost divided by total system cost derives the portion of the system that is considered a fixed investment and is classified as customer-related. The distribution main investment is functionalized to distribution, classified based on the results of the zero-intercept study to demand (44.7%) and customer (55.3%). The demand component of the mains investment is allocated based on each class’s allocation of peak day. The customer component of the mains investment is allocated based on each class’s number of customers. Other Mains Studies: In addition to the zero-intercept study discussed above, for comparison purposes two other mains studies were conducted: one using the minimum system method adjusted to the load-carrying capacity, and a different zero-intercept study using ordinary least squares regression. The minimum system study used 2” as the minimum-sized steel mains and 2” as the minimum-sized Zero-Intercept (Weighted Linear Regression) Material Quantity Cost 2022 Zero-Intercept Cost (2022) Customer Component Customer Component Percentage Plastic 23,707,720 $257,506,229 5.65$ 133,850,942$ 52.0% Steel 7,718,299 $520,929,589 38.38$ 296,243,752$ 56.9% Total 31,426,019 778,435,819$ 430,094,694$ 55.3% INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 7 of 36 plastic mains. The minimum system study yielded a customer component of 68.7% for distribution mains as depicted below. The zero-intercept study using ordinary least squares is simple linear regression performed for each material type with unit costs as the dependent variable and the squared pipe diameter as the independent variable. This study produced very similar results (i.e. customer component of 54.6%) as the zero-intercept WLR. 3.3.Internal Allocation Factors Internal Allocation Factors are developed within the COSS model based on the cost ratios of allocated cost based the external allocation factors, representing various forms of the composite external and internal factors as mathematical sums. INT_RATEBASE – The factor is based on the derived rate base by customer class. INT_REV_REQ – The factor is based on the derived revenue requirement by customer class. INT_REQ_INCOME – The factor is based on the derived customer class required return on the rate base. INT_TOTPLT – The factor is based on the total plant in service balance allocated to the customer classes. INT_STORPT – The factor is based on the total Storage plant in service balance allocated to the customer classes. INT_INTGPLT – The factor is based on the total Intangible plant in service balance allocated to the customer classes. INT_STOR_TRANSM_DIST_SUBTOTAL – The factor is based on the Storage, Transmission, and Distribution plant in service balances allocated to the customer classes. Minimum System Material Quantity Cost 2022 Minimum Size Cost (2022) Customer Component Customer Component Percentage Plastic 23,707,720 $257,506,229 $9.03 $214,082,249 83.1% Steel 7,718,299 $520,929,589 $46.81 $361,275,904 69.4% Total 31,426,019 $778,435,819 $575,358,154 73.9% Minimum System Adjusted for Load Carrying Capacity 68.9% Zero-Intercept (Ordinary Least Squares) Material Quantity Cost 2022 Zero-Intercept Cost (2022) Customer Component Customer Component Percentage Plastic 23,707,720 $257,506,229 8.01$ 189,853,388$ 73.7% Steel 7,718,299 $520,929,589 30.46$ 235,123,466$ 45.1% Total 31,426,019 778,435,819$ 424,976,854$ 54.6% INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 8 of 36 INT_DIST_SUBTOTAL – The factor is based on the Distribution plant in service balance by customer class excluding FERC Account 375 -Structures and Improvements. INT_DISTPT –The factor is based on the total Distribution plant in service balance allocated to the customer classes. INT_DMAINS_SERV – The factor is based on the FERC Accounts 376 - Mains and 380 - Services balances allocated to the customer classes. INT_GENPLT – The factor is based on the General plant in service balance allocated to the customer classes. INT_TRANSPT – The factor is based on the Transmission plant in service balance allocated to the customer classes. INT_CUSTACC – The factor is based on the Customer Account expenses allocated to the customer classes, excluding FERC Account 901- Supervision. INT_OML – The factor is based on the total customer class allocated labor-related Operation and Maintenance Expenses. INT_DIST_OL - The factor is based on the customer class allocated Distribution labor-related Operation Expenses. INT_DIST_ML - The factor is based on the customer class allocated Distribution labor-related Maintenance Expenses. INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 9 of 36 Intermountain Gas Company Gas Class Cost of Service Study Test Year Ended December 31, 2022 Schedule 1 - Account Balances and Allocation Methods Line No.Account Description FERC Account Account Balance Internal Allocation Factor Functional Allocation Factor Classification Allocation Factor Demand Allocation Factor Commodity Allocation Factor Customer Allocation Factor 1 RATE BASE 2 Plant in Service 3 Intangible Plant 4 Organization 301.0 2,506$ INT_STOR_TRANSM_DIST_SUBTOTAL 5 Franchises & Consents 302.0 429,487 INT_STOR_TRANSM_DIST_SUBTOTAL 6 Misc. Intangible Plant - Plant Related 303.0 11,614,559 INT_STOR_TRANSM_DIST_SUBTOTAL 7 Misc. Intangible Plant - Customer Related 303.0 0 8 Misc. Intangible Plant - Labor Related 303.0 46,414,385 INT_OML 9 Subtotal - Intangible Plant 58,460,937$ 10 Natural Gas Other Storage Plant 11 Land & Land Rights 360.0 292,588$ STORAGE DEMAND PDAY 12 Structures & improvement 361.0 10,262,812 STORAGE DEMAND PDAY 13 Gas Holders 362.0 10,746,994 STORAGE DEMAND PDAY 14 Purification Equipment 363.0 19,307,659 STORAGE DEMAND PDAY 15 Subtotal - Natural Gas Other Storage Plant 40,610,053$ 16 Transmission plant 17 Land and Land Rights 365.1 782,865$ TRANSMISSION DEMAND PDAY 18 Rights-of-Way 365.2 0 19 Structures and improvements 366.0 77,152 TRANSMISSION DEMAND PDAY 20 Mains 367.0 69,976,042 TRANSMISSION DEMAND PDAY 21 Compressor station equipment 368.0 1,734,044 TRANSMISSION DEMAND PDAY 22 Measuring and regulating station equipment 369.0 0 23 Communication equipment 370.0 714,440 TRANSMISSION DEMAND PDAY 24 Other equipment 371.0 0 25 ARO for Transmission Plant 372.0 0 26 Subtotal - Transmission plant 73,284,543$ 27 Distribution Plant 28 Land and land rights 374.0 2,102,230$ DISTRIBUTION DEMAND CUST_DEM 29 Structures and improvements 375.0 96,343 INT_DIST_SUBTOTAL 30 Mains 376.0 259,532,576 DISTRIBUTION DEMAND CUST_DEM 31 Compressor station equipment 377.0 0 32 Measuring and regulating station equipment—general 378.0 13,164,103 DISTRIBUTION DEMAND CUST_DEM 33 Measuring and regulating station equipment—city gate check stations 379.0 (306) DISTRIBUTION DEMAND CUST_DEM 34 Services 380.0 214,768,642 CUSTOMER CUSTOMER SERV 35 Meters 381.0 80,614,323 CUSTOMER CUSTOMER MTRS 36 Meter installations 382.0 0 37 House regulators 383.0 19,006,002 CUSTOMER CUSTOMER MTRS 38 House regulatory installations 384.0 0 39 Industrial measuring and regulating station equipment 385.0 13,259,048 CUSTOMER CUSTOMER M&R 40 Other property on customers' premises 386.0 0 41 Other equipment 387.0 0 42 Asset retirement costs for distribution plant 388.0 0 43 Subtotal - Distribution Plant 602,542,961$ INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 10 of 36 Intermountain Gas Company Gas Class Cost of Service Study Test Year Ended December 31, 2022 Schedule 1 - Account Balances and Allocation Methods Line No.Account Description FERC Account Account Balance Internal Allocation Factor Functional Allocation Factor Classification Allocation Factor Demand Allocation Factor Commodity Allocation Factor Customer Allocation Factor 44 General Plant 45 Land and Land Rights 389.0 3,598,925$ INT_STOR_TRANSM_DIST_SUBTOTAL 46 Structures and Improvements 390.0 26,116,861 INT_STOR_TRANSM_DIST_SUBTOTAL 47 Office Furniture and Equipment 391.0 6,451,084 INT_OML 48 Transportation Equipment 392.0 13,275,433 INT_STOR_TRANSM_DIST_SUBTOTAL 49 Stores Equipment 393.0 45,566 INT_STOR_TRANSM_DIST_SUBTOTAL 50 Tools, Shop, and Garage Equipment 394.0 8,470,075 INT_STOR_TRANSM_DIST_SUBTOTAL 51 Laboratory Equipment 395.0 0 52 Power Operated Equipment 396.0 1,875,438 INT_STOR_TRANSM_DIST_SUBTOTAL 53 Communication Equipment 397.0 3,293,258 INT_STOR_TRANSM_DIST_SUBTOTAL 54 Misc. Equipment 398.0 18,955 INT_STOR_TRANSM_DIST_SUBTOTAL 55 Other Intangible Property 399.0 0 56 ARO for General Plant 399.1 0 57 Subtotal - General Plant 63,145,595$ 58 Total Plant in Service 838,044,089$ 59 Accumulated Provision for Depreciation & Amortization 60 Intangible Plant 61 Organization 301.0 (2,506)$ INT_STOR_TRANSM_DIST_SUBTOTAL - - - - - 62 Franchises & Consents 302.0 (429,487)INT_STOR_TRANSM_DIST_SUBTOTAL - - - - - 63 Misc. Intangible Plant - Plant Related 303.0 (5,432,592)INT_STOR_TRANSM_DIST_SUBTOTAL - - - - - 64 Misc. Intangible Plant - Customer Related 303.0 0 - - - - - - 65 Misc. Intangible Plant - Labor Related 303.0 (21,709,856) INT_OML - - - - - 66 Subtotal - Intangible Plant (27,574,441)$ 67 Natural Gas Other Storage Plant 68 Land & Land Rights 360.0 -$ 0 STORAGE DEMAND PDAY - - 69 Structures & improvement 361.0 (3,070,199) 0 STORAGE DEMAND PDAY - - 70 Gas Holders 362.0 (3,787,452) 0 STORAGE DEMAND PDAY - - 71 Purification Equipment 363.0 (9,401,061) 0 STORAGE DEMAND PDAY - - 72 Subtotal - Natural Gas Other Storage Plant (16,258,712)$ 73 Transmission plant 74 Land and Land Rights 365.1 (458,901)$ 0 TRANSMISSION DEMAND PDAY - - 75 Rights-of-Way 365.2 0 0 0 0 0 - - 76 Structures and improvements 366.0 (59,206) 0 TRANSMISSION DEMAND PDAY - - 77 Mains 367.0 (49,148,032) 0 TRANSMISSION DEMAND PDAY - - 78 Compressor station equipment 368.0 (571,636) 0 TRANSMISSION DEMAND PDAY - - 79 Measuring and regulating station equipment 369.0 0 0 0 0 0 - - 80 Communication equipment 370.0 (751,405) 0 TRANSMISSION DEMAND PDAY - - 81 Other equipment 371.0 0 0 0 0 0 - - 82 ARO for Transmission Plant 372.0 0 0 0 0 0 - - 83 Subtotal - Transmission plant (50,989,180)$ INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 11 of 36 Intermountain Gas Company Gas Class Cost of Service Study Test Year Ended December 31, 2022 Schedule 1 - Account Balances and Allocation Methods Line No.Account Description FERC Account Account Balance Internal Allocation Factor Functional Allocation Factor Classification Allocation Factor Demand Allocation Factor Commodity Allocation Factor Customer Allocation Factor 84 Distribution Plant 85 Land and land rights 374.0 (440,623)$ 0 DISTRIBUTION DEMAND CUST_DEM - - 86 Structures and improvements 375.0 (20,536) INT_DIST_SUBTOTAL 0 0 0 - - 87 Mains 376.0 (118,412,542) 0 DISTRIBUTION DEMAND CUST_DEM - - 88 Compressor station equipment 377.0 0 0 0 0 0 - - 89 Measuring and regulating station equipment—general 378.0 (3,263,324) 0 DISTRIBUTION DEMAND CUST_DEM - - 90 Measuring and regulating station equipment—city gate check stations 379.0 35 0 DISTRIBUTION DEMAND CUST_DEM - - 91 Services 380.0 (116,403,632) 0 CUSTOMER CUSTOMER 0 - SERV 92 Meters 381.0 (30,565,978) 0 CUSTOMER CUSTOMER 0 - MTRS 93 Meter installations 382.0 0 0 0 0 0 - - 94 House regulators 383.0 (6,896,225) 0 CUSTOMER CUSTOMER 0 - MTRS 95 House regulatory installations 384.0 0 0 0 0 0 - - 96 Industrial measuring and regulating station equipment 385.0 (7,373,516) 0 CUSTOMER CUSTOMER 0 - M&R 97 Other property on customers' premises 386.0 0 0 0 0 0 - - 98 Other equipment 387.0 0 0 0 0 0 - - 99 Asset retirement costs for distribution plant 388.0 0 0 0 0 0 - - 100 Subtotal - Distribution Plant (283,376,341)$ 101 General Plant 102 Land and Land Rights 389.0 -$ INT_STOR_TRANSM_DIST_SUBTOTAL - - - - - 103 Structures and Improvements 390.0 (9,728,999)INT_STOR_TRANSM_DIST_SUBTOTAL - - - - - 104 Office Furniture and Equipment 391.0 (3,397,687) INT_OML - - - - - 105 Transportation Equipment 392.0 (5,130,659)INT_STOR_TRANSM_DIST_SUBTOTAL - - - - - 106 Stores Equipment 393.0 (9,895)INT_STOR_TRANSM_DIST_SUBTOTAL - - - - - 107 Tools, Shop, and Garage Equipment 394.0 (3,555,091)INT_STOR_TRANSM_DIST_SUBTOTAL - - - - - 108 Laboratory Equipment 395.0 0 - - - - - - 109 Power Operated Equipment 396.0 (685,652)INT_STOR_TRANSM_DIST_SUBTOTAL - - - - - 110 Communication Equipment 397.0 (1,749,267)INT_STOR_TRANSM_DIST_SUBTOTAL - - - - - 111 Misc. Equipment 398.0 (12,453)INT_STOR_TRANSM_DIST_SUBTOTAL - - - - - 112 Other Intangible Property 399.0 0 - - - - - - 113 ARO for General Plant 399.1 0 - - - - - - 114 Subtotal - General Plant (24,269,703)$ 115 Amortization 116 Intangible Plant 111.0 0 117 Production Plant 111.0 0 118 Natural gas storage and processing plant 111.0 0 119 Transmission plant 111.0 0 120 Distribution plant 111.0 0 121 General plant 111.0 0 122 Subtotal - Amortization - 123 Total Accumulated Provision for Depreciation & Amortization (402,468,377)$ INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 12 of 36 Intermountain Gas Company Gas Class Cost of Service Study Test Year Ended December 31, 2022 Schedule 1 - Account Balances and Allocation Methods Line No.Account Description FERC Account Account Balance Internal Allocation Factor Functional Allocation Factor Classification Allocation Factor Demand Allocation Factor Commodity Allocation Factor Customer Allocation Factor 124 Other Rate Base Items 125 Natural gas plant acquisition adjustments 114.0 -$ 126 Accumulated provision for asset acquisition adjustments 115.0 0 127 Materials And Supplies 154.0 6,402,638 INT_STOR_TRANSM_DIST_SUBTOTAL 128 Stores Expense Undistributed 163.0 0 129 Gas Stored Underground - PA 164.1 0 130 LNG Inventory 164.2 3,128,475 STORAGE DEMAND PDAY 131 Prepayments 165.0 0 132 Other regulatory assets 182.3 0 133 Miscellaneous deferred debits 186.0 0 134 Accumulated deferred income taxes 190.0 0 135 Accumulated provision for property insurance 228.1 0 136 Accumulated provision for injuries and damages 228.2 0 137 Accumulated provision for pensions and benefits 228.3 0 138 Accumulated miscellaneous operating provisions 228.4 0 139 Accumulated provision for rate refunds 229.0 0 140 Asset retirement obligations 230.0 0 141 Customer deposits 235.0 0 142 Other deferred credits 253.0 0 143 Accumulated deferred income taxes—accelerated amortization property 281.0 0 144 Accumulated deferred income taxes—Storage Plant 282.1 (2,507,487) INT_STORPT 145 Accumulated deferred income taxes—Transmission Plant 282.2 (4,524,989) INT_TRANSPT 146 Accumulated deferred income taxes—Distribution Plant 282.3 (37,204,307) INT_DISTPT 147 Accumulated deferred income taxes—General Plant 282.4 (3,898,955) INT_GENPLT 148 Accumulated deferred income taxes—other 283.0 0 149 Accumulated deferred investment tax credits 255.0 0 150 Customer advances for construction 252.0 (11,416,545) INT_DMAINS_SERV 151 Other regulatory liabilities 254.0 0 152 Working capital allowance N/A 0 153 Subtotal - Other Rate Base Items (50,021,170)$ 154 TOTAL RATE BASE 385,554,542$ INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 13 of 36 Intermountain Gas Company Gas Class Cost of Service Study Test Year Ended December 31, 2022 Schedule 1 - Account Balances and Allocation Methods Line No.Account Description FERC Account Account Balance Internal Allocation Factor Functional Allocation Factor Classification Allocation Factor Demand Allocation Factor Commodity Allocation Factor Customer Allocation Factor 155 OPERATION AND MAINTENANCE EXPENSE 156 Production, Storage, LNG, Transmission, and Distribution Expense 157 Other Gas Supply Expenses 158 Natural gas well head purchases 800.0 -$ 159 Natural gas well head purchases, intracompany transfers 800.1 0 160 Natural gas field line purchases 801.0 0 161 Natural gas gasoline plant outlet purchases 802.0 0 162 Natural gas transmission line purchases 803.0 0 163 Natural gas city gate purchases 804.0 0 164 Liquefied natural gas purchases 804.1 0 165 Other gas purchases 805.0 0 166 Purchased gas cost adjustments 805.1 0 167 Exchange gas 806.0 0 168 Well expenses—Purchased gas. 807.1 0 169 Operation of purchased gas measuring stations. 807.2 0 170 Maintenance of purchased gas measuring stations. 807.3 0 171 Purchased gas calculations expenses. 807.4 0 172 Other purchased gas expenses. 807.5 0 173 Gas withdrawn from storage—debit 808.1 0 174 Gas delivered to storage—credit 808.2 0 175 Withdrawals of liquefied natural gas held for processing—debt 809.1 0 176 Deliveries of natural gas for processing—credit 809.2 0 177 Gas used for compressor station fuel—credit 810.0 0 178 Gas used for products extraction—credit 811.0 0 179 Other gas supply expenses - Gas Supply 813.1 311,201 DISTRIBUTION CUSTOMER CUST_SALES_TRANS 180 Other gas supply expenses 813.0 43,828 DISTRIBUTION CUSTOMER CUST 181 Subtotal - Other Gas Supply Expenses 355,029$ 182 Other Storage Expenses - Operation 183 Operation supervision and engineering 840.0 (1,000)$ STORAGE DEMAND PDAY 184 Operation labor and expenses 841.0 729,867 STORAGE DEMAND PDAY 185 Rents 842.0 0 186 Fuel 842.1 261,332 STORAGE DEMAND PDAY 187 Power 842.2 120,043 STORAGE DEMAND PDAY 188 Gas losses 842.3 0 189 Subtotal - Other Storage Expenses - Operation 1,110,242$ INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 14 of 36 Intermountain Gas Company Gas Class Cost of Service Study Test Year Ended December 31, 2022 Schedule 1 - Account Balances and Allocation Methods Line No.Account Description FERC Account Account Balance Internal Allocation Factor Functional Allocation Factor Classification Allocation Factor Demand Allocation Factor Commodity Allocation Factor Customer Allocation Factor 190 Other Storage Expenses - Maintenance 191 Maintenance supervision and engineering 843.1 -$ 192 Maintenance of structures and improvements 843.2 1,410 STORAGE DEMAND PDAY 193 Maintenance of gas holders 843.3 206 STORAGE DEMAND PDAY 194 Maintenance of purification equipment 843.4 10,299 STORAGE DEMAND PDAY 195 Maintenance of liquefaction equipment 843.5 49,876 STORAGE DEMAND PDAY 196 Maintenance of vaporizing equipment 843.6 127,185 STORAGE DEMAND PDAY 197 Maintenance of compressor equipment 843.7 21,459 STORAGE DEMAND PDAY 198 Maintenance of measuring and regulating equipment 843.8 0 199 Maintenance of other equipment 843.9 32,199 STORAGE DEMAND PDAY 200 Subtotal - Other Storage Expenses - Maintenance 242,634$ 201 Transmission Operation Expenses 202 Operation supervision and engineering 850.0 -$ 203 System control and load dispatching 851.0 0 204 Communication system expenses 852.0 24,308 TRANSMISSION DEMAND PDAY 205 Compressor station labor and expenses 853.0 108,155 TRANSMISSION DEMAND PDAY 206 Gas for compressor station fuel 854.0 0 207 Other fuel and power for compressor stations 855.0 0 208 Mains expenses 856.0 1,794 TRANSMISSION DEMAND PDAY 209 Measuring and regulating station expenses 857.0 0 210 Transmission and compression of gas by others 858.0 0 211 Other expenses 859.0 0 212 Rents 860.0 0 213 Subtotal - Transmission Operation Expenses 134,257$ 214 Transmission Maintenance Expenses 215 Maintenance supervision and engineering 861.0 -$ 216 Maintenance of structures and improvements 862.0 0 217 Maintenance of mains 863.0 17,516 TRANSMISSION DEMAND PDAY 218 Transmission Mains - Pipeline Integrity 863.1 107,910 TRANSMISSION DEMAND PDAY 219 Maintenance of compressor station equipment 864.0 0 220 Maintenance of measuring and regulating station equipment 865.0 0 221 Maintenance of communication equipment 866.0 148,386 TRANSMISSION DEMAND PDAY 222 Maintenance of other equipment 867.0 0 223 Subtotal - Transmission Maintenance Expenses 273,812$ INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 15 of 36 Intermountain Gas Company Gas Class Cost of Service Study Test Year Ended December 31, 2022 Schedule 1 - Account Balances and Allocation Methods Line No.Account Description FERC Account Account Balance Internal Allocation Factor Functional Allocation Factor Classification Allocation Factor Demand Allocation Factor Commodity Allocation Factor Customer Allocation Factor 224 Distribution Operation Expenses 225 Operation supervision and engineering 870.0 4,439,416$ INT_DIST_OL 226 Operation supervision and engineering- Gas Supply and Control 870.1 58,796 DISTRIBUTION CUSTOMER CUST_SALES_TRANS 227 Distribution load dispatching 871.0 261,192 DISTRIBUTION CUSTOMER CUST_SALES_TRANS 228 Compressor station fuel and power (major only) 873.0 0 229 Mains and services expenses 874.0 4,597,235 INT_DMAINS_SERV 230 Measuring and regulating station expenses—general 875.0 423,705 DISTRIBUTION DEMAND CUST_DEM 231 Measuring and regulating station expenses—industrial 876.0 410,419 DISTRIBUTION CUSTOMER M&R 232 Measuring and regulating station expenses—city gate check stations 877.0 0 233 Meter and house regulator expenses 878.0 1,416,766 CUSTOMER CUSTOMER MTRS 234 Meter and house regulator expenses - installation credits 878.3 (1,909,122) CUSTOMER CUSTOMER MTRS 235 Customer installations expenses 879.0 2,161,755 CUSTOMER CUSTOMER CUST 236 Other expenses 880.0 6,117,348 INT_DISTPT 237 Rents 881.0 246,308 INT_DIST_OL 238 Subtotal - Distribution Operation Expenses 18,223,818$ 239 Distribution Maintenance Expenses 240 Maintenance supervision and engineering 885.0 268,452$ INT_DIST_ML 241 Maintenance of structures and improvements 886.0 0 242 Maintenance of mains 887.0 1,596,136 DISTRIBUTION DEMAND CUST_DEM 243 Distribution Mains - Pipeline Integrity 887.1 75,302 DISTRIBUTION DEMAND CUST_DEM 244 Maintenance of compressor station equipment 888.0 0 245 Maintenance of measuring and regulating station equipment—general 889.0 538,775 DISTRIBUTION DEMAND CUST_DEM 246 Maintenance of measuring and regulating station equipment—industrial 890.0 138,403 CUSTOMER CUSTOMER M&R 247 Maintenance of measuring and regulating station equipment—city gate 891.0 9,985 DISTRIBUTION DEMAND CUST_DEM 248 Maintenance of services 892.0 3,118,096 DISTRIBUTION CUSTOMER SERV 249 Maintenance of meters and house regulators 893.0 1,413,166 DISTRIBUTION CUSTOMER MTRS 250 Maintenance of other equipment 894.0 935,027 INT_DIST_ML 251 Subtotal - Distribution Maintenance Expenses 8,093,342$ 252 Total Production, Storage, LNG, Transmission, and Distribution Expense 28,433,134$ 253 Customer Accounts, Service, and Sales Expense 254 Customer Account 255 Supervision 901.0 181,076$ INT_CUSTACC 256 Meter reading expenses 902.0 1,116,986 CUSTOMER CUSTOMER CUST 257 Customer records and collection expenses 903.0 7,644,742 CUSTOMER CUSTOMER CUST 258 Uncollectible accounts 904.0 927,448 CUSTOMER CUSTOMER ACT_904 259 Miscellaneous customer accounts expenses 905.0 0 260 Subtotal - Customer Account 9,870,252$ INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 16 of 36 Intermountain Gas Company Gas Class Cost of Service Study Test Year Ended December 31, 2022 Schedule 1 - Account Balances and Allocation Methods Line No.Account Description FERC Account Account Balance Internal Allocation Factor Functional Allocation Factor Classification Allocation Factor Demand Allocation Factor Commodity Allocation Factor Customer Allocation Factor 261 Customer Service & Information Expenses 262 Supervision 907.0 -$ 263 Customer assistance expenses 908.0 83,522 CUSTOMER CUSTOMER CUST 264 Informational and instructional advertising expenses 909.0 136,800 CUSTOMER CUSTOMER CUST 265 Miscellaneous customer service and informational expenses 910.0 0 266 Subtotal - Customer Service & Information Expenses 220,322$ 267 Sales Expenses 268 Supervision 911.0 267,946$ CUSTOMER CUSTOMER CUST 269 Demonstrating and selling expenses 912.0 1,308,122 CUSTOMER CUSTOMER CUST 270 Advertising expenses 913.0 40,634 CUSTOMER CUSTOMER CUST 271 Miscellaneous sales expenses 916.0 0 272 Subtotal - Sales Expenses 1,616,702$ 273 Total Customer Accounts, Service, and Sales Expense 11,707,276$ 274 Administrative and General Expenses 275 Administrative and general salaries 920.0 6,103,487$ INT_OML 276 Administrative and general salaries - Gas Supply and Control 920.1 165,501 CUSTOMER CUSTOMER CUST_SALES_TRANS 277 Office supplies and expenses 921.0 5,836,289 INT_OML 278 Outside services employed 923.0 881,339 INT_OML 279 Property insurance 924.0 132,525 INT_TOTPLT 280 Injuries and damages 925.0 1,214,400 INT_OML 281 Employee pensions and benefits 926.0 1,702,930 INT_OML 282 Franchise requirements 927.0 0 283 Regulatory commission expenses 928.0 109,340 CUSTOMER CUSTOMER REV 284 Duplicate charges—Credit 929.0 71,492 CUSTOMER CUSTOMER REV 285 General advertising expenses 930.1 245,197 CUSTOMER CUSTOMER CUST 286 Miscellaneous general expenses 930.2 235,750 INT_DIST_SUBTOTAL 287 Rents 931.0 850,986 INT_OML 288 Maintenance of general plant 935.0 3 INT_GENPLT 289 Subtotal - Administrative and General Expenses 17,549,239$ 290 TOTAL OPERATION AND MAINTENANCE EXPENSE 57,689,649$ 291 Adjustments, Depreciation and Amortization Expense 292 Depreciation Expense 293 Depreciation expense intangible plant 403.1 4,684,938$ INT_INTGPLT 294 Depreciation expense storage and terminaling 403.2 1,110,353 INT_STORPT 295 Depreciation expense transmission 403.3 1,041,651 INT_TRANSPT 296 Depreciation expense distribution 403.4 13,476,497 INT_DISTPT 297 Depreciation expense general plant 403.5 1,693,650 INT_GENPLT 298 Subtotal - Depreciation Expense 22,007,089$ INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 17 of 36 Intermountain Gas Company Gas Class Cost of Service Study Test Year Ended December 31, 2022 Schedule 1 - Account Balances and Allocation Methods Line No.Account Description FERC Account Account Balance Internal Allocation Factor Functional Allocation Factor Classification Allocation Factor Demand Allocation Factor Commodity Allocation Factor Customer Allocation Factor 299 Amortization Expense 300 Amortization and depletion of producing natural gas land and land 404.1 -$ 301 Amortization of underground storage land and land rights 404.2 0 302 Amortization of other limited-term gas plant 404.3 0 303 Amortization of other gas plant 405.0 0 304 Amortization of gas plant acquisition adjustments 406.0 0 305 Amortization of property losses, unrecovered plant and regulatory 407.1 0 306 Amortization of conversion expense 407.2 0 307 Subtotal - Amortization Expense - 308 Total Adjustments, Depreciation and Amortization Expense 22,007,089$ 309 Taxes 310 Taxes Other Than Income Taxes 311 Taxes Other Than Income Taxes - Payroll 408.1 2,220,444$ INT_OML 312 Taxes Other Than Income Taxes - Property 408.2 2,182,729 INT_TOTPLT 313 Taxes Other Than Income Taxes - Franchise 408.3 18,505 CUSTOMER CUSTOMER REV 314 Taxes Other Than Income Taxes - IPUC Fee 408.4 520,047 CUSTOMER CUSTOMER REV 315 Subtotal - Taxes Other Than Income Taxes 4,941,725$ 316 Income Taxes 317 Income Taxes - federal taxes utility operating income 409.1 2,884,190$ INT_REQ_INCOME 318 Income Taxes - state taxes utility operating income 409.1 (124,089) INT_REQ_INCOME 319 Income Taxes - other taxes utility operating income 410.1 0 INT_REQ_INCOME 320 Provision for deferred income taxes—credit, utility operating income 411.1 0 321 Investment Tax credit Adj. 411.4 0 322 Subtotal - Income Taxes 2,760,101$ 323 Total Taxes 7,701,826$ 324 REVENUE REQUIREMENT AT EQUAL RATES OF RETURN 325 Test Year Expenses at Current Rates 87,398,564$ 326 Return on Rate Base 28,415,370$ INT_RATEBASE 327 Gross Up Items 328 Federal Income Tax 1,329,772$ INT_REQ_INCOME 329 State Income Tax 389,885 INT_REQ_INCOME 330 Uncollectible Account - Increase 16,597 CUSTOMER CUSTOMER ACT_904 331 Taxes Other Than Income Taxes - IPUC Fee 13,471 CUSTOMER CUSTOMER REV 332 TOTAL REVENUE REQUIREMENT AT EQUAL RATES OF RETURN 117,563,659$ INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 18 of 36 Intermountain Gas Company Class Cost of Service Study - Development of External Allocators Test Year Ended December 31, 2022 Schedule 2 - External Allocation Factors Allocator Code Description Classifier Total Residential Service General Service Large Volume Transport Service (Interruptible) Transport Service (Firm) RS GS LV-1 T-3 T-4 CUSTOMER EXTERNAL ALLOCATORS CUST Average Number Customers CUS 100.0%91.3%8.7%0.0%0.0%0.0% 404,055 368,840 35,071 35 8 102 CUST_SALES_TRANS Gas Supply and Control Cost Allocation CUS 100.0%34.9%16.1%2.9%2.4%43.7% 796,689 278,063 128,270 23,273 19,102 347,981 MTRS Customer Meters CUS 100.0%73.9%25.4%0.1%0.1%0.5%Weighted Customer Cost 5,991,818 4,426,077 1,520,926 7,431 6,800 30,585 M&R Industrial measuring and regulating station equipment CUS 100.0%0.0%91.0%3.1%0.4%5.5% Weighted Customer Cost 9,383 8,542 287 39 515 SERV Services CUS 100.0%81.4%17.8%0.2%0.0%0.6% Weighted Customer Cost 452,777 368,620 80,652 729 132 2,644 ACT_904 Uncollectible accounts CUS 100.0%85.4%14.2%0.1%0.0%0.3% Uncollectible accounts - Residential 476,351 476,351 Uncollectible accounts - Commercial 79,180 79,180 Uncollectible accounts - Industrial 2,473 602 128 1,743 Uncollectible accounts 558,004 476,351 79,180 602 128 1,743 COMMODITY EXTERNAL ALLOCATORS REV Total Sales and Transportation REV 100.0%65.4%24.4%0.7%0.5%9.0% 108,348,580 70,866,860 26,416,220 706,333 559,724 9,799,443 COM Weather Normalized Volumes COM 100.0%34.7%17.1%1.7%5.4%41.1% 822,087,104 285,332,326 140,313,436 14,130,994 44,289,741 338,020,607 DEMAND EXTERNAL ALLOCATORS PDAY_F&I Peak Day (Design Day) Firm & Interruptible DEM 100.0%51.5%22.7%1.2%1.9%22.8% 6,539,432 3,365,123 1,487,152 77,405 121,342 1,488,410 PDAY_F Peak Day (Design Day) Firm DEM 100.0%52.4%23.2%1.2%0.0%23.2% 6,414,264 3,362,718 1,485,731 77,405 - 1,488,410 CUST_DEM_F&I Customer and Demand Composite Factor DEM 100.0%73.5%15.0%0.5%0.8%10.2% CUST 100.0%91.3%8.7%0.0%0.0%0.0% CUST Customer Component - Zero-Intercept (WLR)55.3%55.3%50.4%4.8%0.0%0.0%0.0%PDAY_F&I 100.0%51.5%22.7%1.2%1.9%22.8%PDAY Demand Components 44.7%44.7%23.0%10.2%0.5%0.8%10.2% CUST_DEM_F Customer and Demand Composite Factor DEM 100.0%73.9%15.2%0.5%0.0%10.4% CUST 100.0%91.3%8.7%0.0%0.0%0.0% CUST Customer Component - Zero-Intercept (WLR)55.3%55.3%50.4%4.8%0.0%0.0%0.0% PDAY_F 100.0%52.4%23.2%1.2%0.0%23.2% PDAY Demand Components 44.7%44.7%23.5%10.4%0.5%0.0%10.4% INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 19 of 36 Intermountain Gas Company Gas Class Cost of Service Study Test Year Ended December 31, 2022 Schedule 3 - Internal Allocation Factors Allocator Code Total Residential Service General Service Large Volume Transport Service (Interruptible) Transport Service (Firm) ALLOCATION FACTOR BASIS INT_INTGPLT 58,460,937$ 42,742,802$ 11,603,109$ 286,780$ 64,171$ 3,764,075$ INT_STORPT 40,610,053$ 21,290,076$ 9,406,474$ 490,067$ -$ 9,423,436$ INT_TRANSPT 73,284,543$ 38,419,883$ 16,974,840$ 884,371$ -$ 17,005,449$ INT_DISTPT 602,542,961$ 451,574,887$ 117,293,442$ 2,372,208$ 233,730$ 31,068,694$ INT_GENPLT 63,145,595$ 45,205,859$ 12,646,477$ 327,590$ 26,869$ 4,938,800$ INT_TOTPLT 838,044,089$ 599,233,507$ 167,924,342$ 4,361,016$ 324,770$ 66,200,454$ INT_RATEBASE 385,554,542$ 276,755,683$ 77,030,661$ 1,941,268$ 159,490$ 29,667,440$ INT_DMAINS_SERV 474,301,218$ 366,632,963$ 77,603,185$ 1,759,895$ 65,380$ 28,239,795$ INT_OML 20,778,204$ 15,285,956$ 4,112,848$ 100,180$ 26,968$ 1,252,251$ INT_DIST_OL 10,013,478$ 7,417,696$ 1,996,966$ 47,339$ 12,297$ 539,180$ INT_DIST_ML 4,735,889$ 3,650,559$ 909,866$ 13,407$ 1,989$ 160,068$ INT_CUSTACC 9,689,176$ 8,789,833$ 892,094$ 1,765$ 376$ 5,108$ INT_DIST_SUBTOTAL 14,310,609$ 10,811,131$ 2,680,954$ 63,933$ 12,608$ 741,982$ INT_STOR_TRANSM_DIST_SUBTOTAL 716,437,557$ 511,284,846$ 143,674,756$ 3,746,647$ 233,730$ 57,497,579$ INT_REQ_INCOME 28,415,370$ 20,396,894$ 5,677,160$ 143,071$ 11,754$ 2,186,490$ INT_REV REQ 117,563,659$ 87,422,386$ 21,990,833$ 535,744$ 87,098$ 7,527,597$ ALLOCATION FACTOR INT_INTGPLT 100.00% 73.11% 19.85% 0.49% 0.11% 6.44% INT_STORPT 100.00% 52.43% 23.16% 1.21% 0.00% 23.20% INT_TRANSPT 100.00% 52.43% 23.16% 1.21% 0.00% 23.20% INT_DISTPT 100.00% 74.94% 19.47% 0.39% 0.04% 5.16% INT_GENPLT 100.00% 71.59% 20.03% 0.52% 0.04% 7.82% INT_TOTPLT 100.00% 71.50% 20.04% 0.52% 0.04% 7.90% INT_RATEBASE 100.00% 71.78% 19.98% 0.50% 0.04% 7.69% INT_DMAINS_SERV 100.00% 77.30% 16.36% 0.37% 0.01% 5.95% INT_OML 100.00% 73.57% 19.79% 0.48% 0.13% 6.03% INT_DIST_OL 100.00% 74.08% 19.94% 0.47% 0.12% 5.38% INT_DIST_ML 100.00% 77.08% 19.21% 0.28% 0.04% 3.38% INT_CUSTACC 100.00% 90.72% 9.21% 0.02% 0.00% 0.05% INT_DIST_SUBTOTAL 100.00% 75.55% 18.73% 0.45% 0.09% 5.18% INT_STOR_TRANSM_DIST_SUBTOTAL 100.00% 71.36% 20.05% 0.52% 0.03% 8.03% INT_REQ_INCOME 100.00% 71.78% 19.98% 0.50% 0.04% 7.69% INT_REV REQ 100.00% 74.36% 18.71% 0.46% 0.07% 6.40% INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 20 of 36 Intermountain Gas Company Gas Class Cost of Service Study Test Year Ended December 31, 2022 Schedule 4 – Cost of Service and Rate of Return under Present and Proposed Rates Line No.Revenue Requirement Summary Total System Residential Service General Service Large Volume Transport Service (Interruptible) Transport Service (Firm) 1 Rate Base 2 Plant in Service 838,044,089$ 599,233,507$ 167,924,342$ 4,361,016$ 324,770$ 66,200,454$ 3 Accumulated Reserve (402,468,377) (285,501,451) (81,382,259) (2,197,058) (149,704) (33,237,906) 4 Other Rate Base Items (50,021,170) (36,976,373) (9,511,423) (222,691) (15,576) (3,295,107) 5 Total Rate Base 385,554,542$ 276,755,683$ 77,030,661$ 1,941,268$ 159,490$ 29,667,440$ 6 Rate of Return Under Current ROR 7 Revenue at Current Rates 8 Gas Service Revenue 108,348,580$ 70,866,860$ 26,416,220$ 706,333$ 559,724$ 9,799,443$ 9 Other Revenues 2,462,855 1,831,422 460,689 11,223 1,825 157,697 10 Total Revenue 110,811,435$ 72,698,282$ 26,876,909$ 717,556$ 561,549$ 9,957,140$ 11 Expenses at Current Rates 12 O&M and A&G Expenses 57,689,649$ 44,374,444$ 10,013,927$ 233,642$ 55,817$ 3,011,819$ 13 Depreciation and Amortization Expense 22,007,089 15,865,943 4,390,901 110,795 11,091 1,628,360 14 Taxes Other Than Income 4,941,725 3,546,502 1,008,187 25,575 6,510 354,952 15 Total Operating Expenses 84,638,463$ 63,786,889$ 15,413,014$ 370,011$ 73,418$ 4,995,131$ 16 Earnings Before Interest and Taxes 26,172,972$ 8,911,393$ 11,463,894$ 347,545$ 488,131$ 4,962,009$ 17 Current State/Federal Income Taxes 2,760,101$ 939,761$ 1,208,938$ 36,651$ 51,476$ 523,274$ 18 Deferred Income Tax - - - - - - 19 Total Income Taxes 2,760,101$ 939,761$ 1,208,938$ 36,651$ 51,476$ 523,274$ 20 Total Expenses at Current Rates 87,398,564$ 64,726,650$ 16,621,952$ 406,662$ 124,894$ 5,518,405$ 21 Operating Income at Current Rates 23,412,871$ 7,971,632$ 10,254,956$ 310,894$ 436,655$ 4,438,734$ 22 Current Rate of Return 6.07% 2.88% 13.31% 16.02% 273.78% 14.96% 23 Relative Rate of Return 1.00 0.47 2.19 2.64 45.09 2.46 24 Current Revenue to Cost Ratio 0.94 0.83 1.22 1.34 6.45 1.32 25 Current Parity Ratio 1.00 0.88 1.30 1.42 6.84 1.40 26 Rate of Return Under Equal ROR 27 Revenue Requirement Required Return at Equal Rates of Return 28 Required Return 7.37% 7.37% 7.37% 7.37% 7.37% 7.37% 29 Required Operating Income 28,415,370$ 20,396,894$ 5,677,160$ 143,071$ 11,754$ 2,186,490$ 30 Expenses at Required Return 31 O&M and A&G Expenses 57,689,649$ 44,374,444$ 10,013,927$ 233,642$ 55,817$ 3,011,819$ 32 Depreciation and Amortization Expense 22,007,089 15,865,943 4,390,901 110,795 11,091 1,628,360 33 Taxes Other Than Income 4,941,725 3,546,502 1,008,187 25,575 6,510 354,952 INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 21 of 36 Intermountain Gas Company Gas Class Cost of Service Study Test Year Ended December 31, 2022 Schedule 4 – Cost of Service and Rate of Return under Present and Proposed Rates Line No.Revenue Requirement Summary Total System Residential Service General Service Large Volume Transport Service (Interruptible) Transport Service (Firm) 34 Total Operating Expenses 84,638,463$ 63,786,889$ 15,413,014$ 370,011$ 73,418$ 4,995,131$ 35 Deferred Income Tax -$ -$ -$ -$ -$ -$ 36 Current State/Federal Income Taxes 2,760,101 1,981,234 551,446 13,897 1,142 212,383 37 Income Taxes and Other 2,760,101$ 1,981,234$ 551,446$ 13,897$ 1,142$ 212,383$ 38 Increase - Federal Income Tax 1,329,772$ 954,526$ 265,678$ 6,695$ 550$ 102,323$ 39 Increase - State Utility Tax 389,885 279,864 77,896 1,963 161 30,001 40 Increase - Bad Debts 16,597 14,168 2,355 18 4 52 41 Increase - Annual Filing Fee 13,471 8,811 3,284 88 70 1,218 42 Revenue Increase Related Expenses 1,749,725$ 1,257,370$ 349,213$ 8,764$ 785$ 133,593$ 43 Total Expenses at Required Return 89,148,289$ 67,025,492$ 16,313,673$ 392,673$ 75,344$ 5,341,107$ 44 Total Revenue Requirement Required Return at Equal Rates of Return 117,563,659$ 87,422,386$ 21,990,833$ 535,744$ 87,098$ 7,527,597$ 45 LESS 46 Current Miscellaneous Revenue Margin 2,462,855 1,831,422 460,689 11,223 1,825 157,697 47 Total Rate Margin at Equal Rates of Return 115,100,804$ 85,590,964$ 21,530,144$ 524,521$ 85,274$ 7,369,901$ 48 Total Current Rate Margin 108,348,580$ 70,866,860$ 26,416,220$ 706,333$ 559,724$ 9,799,443$ 49 Base Rate Margin (Deficiency)/Surplus (6,752,224)$ (14,724,104)$ 4,886,076$ 181,812$ 474,450$ 2,429,542$ 50 Proposed Margin Increase 6,752,224$ 5,520,480$ 875,025$ 23,397$ 8,720$ 324,602$ 51 Total Revenue Increase as Proposed 117,563,659$ 78,218,762$ 27,751,933$ 740,953$ 570,269$ 10,281,741$ 52 Income Prior to Taxes 32,895,128$ 14,408,894$ 12,333,280$ 370,836$ 496,778$ 5,285,340$ 53 Income Taxes and Other 4,479,758$ 3,215,624$ 895,019$ 22,556$ 1,853$ 344,706$ 54 Proposed Operating Income 28,415,370$ 11,193,269$ 11,438,261$ 348,281$ 494,925$ 4,940,634$ 55 Proposed Rate of Return 7.37% 4.04% 14.85% 17.94% 310.32% 16.65% 56 Relative Rate of Return 1.00 0.55 2.01 2.43 42.11 2.26 57 Proposed Revenue to Cost Ratio 1.00 0.89 1.26 1.38 6.55 1.37 58 Proposed Parity Ratio 1.00 0.89 1.26 1.38 6.55 1.37 INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 22 of 36 Intermountain Gas Company Gas Class Cost of Service Study Test Year Ended December 31, 2022 Schedule 5 - Cost of Service Allocation Study Detail by Account Line No.Account Description FERC Account Account Balance Residential Service General Service Large Volume Transport Service (Interruptible) Transport Service (Firm) 1 RATE BASE 2 Plant in Service 3 Intangible Plant 4 Organization 301 2,506$ 1,788$ 503$ 13$ 1$ 201$ 5 Franchises & Consents 302 429,487 306,503 86,130 2,246 140 34,468 6 Misc. Intangible Plant - Plant Related 303 11,614,559 8,288,717 2,329,190 60,739 3,789 932,125 7 Misc. Intangible Plant - Customer Related 303 - - - - - - 8 Misc. Intangible Plant - Labor Related 303 46,414,385 34,145,794 9,187,288 223,781 60,241 2,797,281 9 Subtotal - Intangible Plant 58,460,937$ 42,742,802$ 11,603,109$ 286,780$ 64,171$ 3,764,075$ 10 Natural Gas Other Storage Plant 11 Land & Land Rights 360 292,588$ 153,391$ 67,772$ 3,531$ -$ 67,894$ 12 Structures & improvement 361 10,262,812 5,380,344 2,377,167 123,848 - 2,381,453 13 Gas Holders 362 10,746,994 5,634,179 2,489,318 129,691 - 2,493,806 14 Purification Equipment 363 19,307,659 10,122,162 4,472,218 232,998 - 4,480,282 15 Subtotal - Natural Gas Other Storage Plant 40,610,053$ 21,290,076$ 9,406,474$ 490,067$ -$ 9,423,436$ 16 Transmission plant 17 Land and Land Rights 365.1 782,865$ 410,422$ 181,334$ 9,447$ -$ 181,661$ 18 Rights-of-Way 365.2 - - - - - - 19 Structures and improvements 366 77,152 40,447 17,871 931 - 17,903 20 Mains 367 69,976,042 36,685,380 16,208,495 844,445 - 16,237,722 21 Compressor station equipment 368 1,734,044 909,083 401,655 20,926 - 402,379 22 Measuring and regulating station equipment 369 - - - - - - 23 Communication equipment 370 714,440 374,550 165,485 8,622 - 165,784 24 Other equipment 371 - - - - - - 25 ARO for Transmission Plant 372 - - - - - - 26 Subtotal - Transmission plant 73,284,543$ 38,419,883$ 16,974,840$ 884,371$ -$ 17,005,449$ 27 Distribution Plant 28 Land and land rights 374 2,102,230$ 1,553,455$ 318,714$ 11,454$ 22$ 218,585$ 29 Structures and improvements 375 96,343 72,784 18,049 430 85 4,995 30 Mains 376 259,532,576 191,783,131 39,347,139 1,414,019 2,662 26,985,626 31 Compressor station equipment 377 - - - - - - 32 Measuring and regulating station equipment—general 378 13,164,103 9,727,692 1,995,779 71,722 135 1,368,774 33 Measuring and regulating station equipment—city gate check stations 379 (306) (226) (46) (2) (0) (32) 34 Services 380 214,768,642 174,849,833 38,256,047 345,875 62,718 1,254,169 35 Meters 381 80,614,323 59,548,736 20,462,642 99,973 91,483 411,489 36 Meter installations 382 - - - - - - 37 House regulators 383 19,006,002 14,039,483 4,824,366 23,570 21,568 97,014 38 House regulatory installations 384 - - - - - - 39 Industrial measuring and regulating station equipment 385 13,259,048 - 12,070,752 405,166 55,057 728,073 40 Other property on customers' premises 386 - - - - - - 41 Other equipment 387 - - - - - - 42 Asset retirement costs for distribution plant 388 - - - - - - 43 Subtotal - Distribution Plant 602,542,961$ 451,574,887$ 117,293,442$ 2,372,208$ 233,730$ 31,068,694$ INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 23 of 36 Intermountain Gas Company Gas Class Cost of Service Study Test Year Ended December 31, 2022 Schedule 5 - Cost of Service Allocation Study Detail by Account Line No.Account Description FERC Account Account Balance Residential Service General Service Large Volume Transport Service (Interruptible) Transport Service (Firm) 44 General Plant 45 Land and Land Rights 389 3,598,925$ 2,568,369$ 721,730$ 18,821$ 1,174$ 288,831$ 46 Structures and Improvements 390 26,116,861 18,638,268 5,237,489 136,579 8,520 2,096,004 47 Office Furniture and Equipment 391 6,451,084 4,745,886 1,276,931 31,103 8,373 388,791 48 Transportation Equipment 392 13,275,433 9,473,998 2,662,262 69,425 4,331 1,065,418 49 Stores Equipment 393 45,566 32,518 9,138 238 15 3,657 50 Tools, Shop, and Garage Equipment 394 8,470,075 6,044,659 1,698,593 44,295 2,763 679,764 51 Laboratory Equipment 395 - - - - - - 52 Power Operated Equipment 396 1,875,438 1,338,404 376,101 9,808 612 150,513 53 Communication Equipment 397 3,293,258 2,350,230 660,432 17,222 1,074 264,300 54 Misc. Equipment 398 18,955 13,527 3,801 99 6 1,521 55 Other Intangible Property 399 - - - - - - 56 ARO for General Plant 399.1 - - - - - - 57 Subtotal - General Plant 63,145,595$ 45,205,859$ 12,646,477$ 327,590$ 26,869$ 4,938,800$ 58 Total Plant in Service 838,044,089$ 599,233,507$ 167,924,342$ 4,361,016$ 324,770$ 66,200,454$ 59 Accumulated Provision for Depreciation & Amortization 60 Intangible Plant 61 Organization 301 (2,506)$ (1,788)$ (503)$ (13)$ (1)$ (201)$ 62 Franchises & Consents 302 (429,487) (306,503) (86,130) (2,246) (140) (34,468) 63 Misc. Intangible Plant - Plant Related 303 (5,432,592) (3,876,963) (1,089,455) (28,410) (1,772) (435,992) 64 Misc. Intangible Plant - Customer Related 303 - - - - - - 65 Misc. Intangible Plant - Labor Related 303 (21,709,856) (15,971,348) (4,297,260) (104,671) (28,177) (1,308,400) 66 Subtotal - Intangible Plant (27,574,441)$ (20,156,602)$ (5,473,347)$ (135,341)$ (30,091)$ (1,779,061)$ 67 Natural Gas Other Storage Plant 68 Land & Land Rights 360 -$ -$ -$ -$ -$ -$ 69 Structures & improvement 361 (3,070,199) (1,609,571) (711,148) (37,050) - (712,430) 70 Gas Holders 362 (3,787,452) (1,985,596) (877,284) (45,706) - (878,866) 71 Purification Equipment 363 (9,401,061) (4,928,565) (2,177,560) (113,449) - (2,181,487) 72 Subtotal - Natural Gas Other Storage Plant (16,258,712)$ (8,523,732)$ (3,765,992)$ (196,204)$ -$ (3,772,783)$ 73 Transmission plant 74 Land and Land Rights 365.1 (458,901)$ (240,582)$ (106,295)$ (5,538)$ -$ (106,487)$ 75 Rights-of-Way 365.2 - - - - - - 76 Structures and improvements 366 (59,206) (31,039) (13,714) (714) - (13,739) 77 Mains 367 (49,148,032) (25,766,165) (11,384,119) (593,100) - (11,404,647) 78 Compressor station equipment 368 (571,636) (299,684) (132,408) (6,898) - (132,646) 79 Measuring and regulating station equipment 369 - - - - - - 80 Communication equipment 370 (751,405) (393,929) (174,047) (9,068) - (174,361) 81 Other equipment 371 - - - - - - 82 ARO for Transmission Plant 372 - - - - - - 83 Subtotal - Transmission plant (50,989,180)$ (26,731,398)$ (11,810,583)$ (615,319)$ -$ (11,831,880)$ INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 24 of 36 Intermountain Gas Company Gas Class Cost of Service Study Test Year Ended December 31, 2022 Schedule 5 - Cost of Service Allocation Study Detail by Account Line No.Account Description FERC Account Account Balance Residential Service General Service Large Volume Transport Service (Interruptible) Transport Service (Firm) 84 Distribution Plant 85 Land and land rights 374 (440,623)$ (325,601)$ (66,802)$ (2,401)$ (5)$ (45,815)$ 86 Structures and improvements 375 (20,536) (15,514) (3,847) (92) (18) (1,065) 87 Mains 376 (118,412,542) (87,501,648) (17,952,254) (645,151) (1,214) (12,312,275) 88 Compressor station equipment 377 - - - - - - 89 Measuring and regulating station equipment—general 378 (3,263,324) (2,411,453) (494,745) (17,780) (33) (339,313) 90 Measuring and regulating station equipment—city gate check stations 379 35 26 5 0 0 4 91 Services 380 (116,403,632) (94,767,818) (20,734,604) (187,463) (33,993) (679,754) 92 Meters 381 (30,565,978) (22,578,685) (7,758,679) (37,906) (34,687) (156,021) 93 Meter installations 382 - - - - - - 94 House regulators 383 (6,896,225) (5,094,150) (1,750,495) (8,552) (7,826) (35,201) 95 House regulatory installations 384 - - - - - - 96 Industrial measuring and regulating station equipment 385 (7,373,516) - (6,712,690) (225,318) (30,618) (404,890) 97 Other property on customers' premises 386 - - - - - - 98 Other equipment 387 - - - - - - 99 Asset retirement costs for distribution plant 388 - - - - - - 100 Subtotal - Distribution Plant (283,376,341)$ (212,694,842)$ (55,474,111)$ (1,124,661)$ (108,394)$ (13,974,332)$ 101 General Plant 102 Land and Land Rights 389 -$ -$ -$ -$ -$ -$ 103 Structures and Improvements 390 (9,728,999) (6,943,089) (1,951,058) (50,878) (3,174) (780,799) 104 Office Furniture and Equipment 391 (3,397,687) (2,499,585) (672,540) (16,382) (4,410) (204,770) 105 Transportation Equipment 392 (5,130,659) (3,661,489) (1,028,905) (26,831) (1,674) (411,760) 106 Stores Equipment 393 (9,895) (7,062) (1,984) (52) (3) (794) 107 Tools, Shop, and Garage Equipment 394 (3,555,091) (2,537,087) (712,940) (18,592) (1,160) (285,313) 108 Laboratory Equipment 395 - - - - - - 109 Power Operated Equipment 396 (685,652) (489,315) (137,501) (3,586) (224) (55,027) 110 Communication Equipment 397 (1,749,267) (1,248,362) (350,799) (9,148) (571) (140,387) 111 Misc. Equipment 398 (12,453) (8,887) (2,497) (65) (4) (999) 112 Other Intangible Property 399 - - - - - - 113 ARO for General Plant 399.1 - - - - - - 114 Subtotal - General Plant (24,269,703)$ (17,394,876)$ (4,858,225)$ (125,533)$ (11,219)$ (1,879,850)$ 115 Amortization 116 Intangible Plant 111 -$ -$ -$ -$ -$ -$ 117 Production Plant 111 - - - - - - 118 Natural gas storage and processing plant 111 - - - - - - 119 Transmission plant 111 - - - - - - 120 Distribution plant 111 - - - - - - 121 General plant 111 - - - - - - 122 Subtotal - Amortization -$ -$ -$ -$ -$ -$ 123 Total Accumulated Provision for Depreciation & Amortization (402,468,377)$ (285,501,451)$ (81,382,259)$ (2,197,058)$ (149,704)$ (33,237,906)$ INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 25 of 36 Intermountain Gas Company Gas Class Cost of Service Study Test Year Ended December 31, 2022 Schedule 5 - Cost of Service Allocation Study Detail by Account Line No.Account Description FERC Account Account Balance Residential Service General Service Large Volume Transport Service (Interruptible) Transport Service (Firm) 124 Other Rate Base Items 125 Natural gas plant acquisition adjustments 114 -$ -$ -$ -$ -$ -$ 126 Accumulated provision for asset acquisition adjustments 115 - - - - - - 127 Materials And Supplies 154 6,402,638 4,569,235 1,283,988 33,483 2,089 513,843 128 Stores Expense Undistributed 163 - - - - - - 129 Gas Stored Underground - PA 164.1 - - - - - - 130 LNG Inventory 164.2 3,128,475 1,640,123 724,646 37,753 - 725,953 131 Prepayments 165 - - - - - - 132 Other regulatory assets 182.3 - - - - - - 133 Miscellaneous deferred debits 186 - - - - - - 134 Accumulated deferred income taxes 190 - - - - - - 135 Accumulated provision for property insurance 228.1 - - - - - - 136 Accumulated provision for injuries and damages 228.2 - - - - - - 137 Accumulated provision for pensions and benefits 228.3 - - - - - - 138 Accumulated miscellaneous operating provisions 228.4 - - - - - - 139 Accumulated provision for rate refunds 229 - - - - - - 140 Asset retirement obligations 230 - - - - - - 141 Customer deposits 235 - - - - - - 142 Other deferred credits 253 - - - - - - 143 Accumulated deferred income taxes—accelerated amortization property 281 - - - - - - 144 Accumulated deferred income taxes—Storage Plant 282.1 (2,507,487) (1,314,566) (580,807) (30,259) - (581,855) 145 Accumulated deferred income taxes—Transmission Plant 282.2 (4,524,989) (2,372,254) (1,048,120) (54,606) - (1,050,010) 146 Accumulated deferred income taxes—Distribution Plant 282.3 (37,204,307) (27,882,710) (7,242,340) (146,473) (14,432) (1,918,352) 147 Accumulated deferred income taxes—General Plant 282.4 (3,898,955) (2,791,257) (780,863) (20,227) (1,659) (304,949) 148 Accumulated deferred income taxes—other 283 - - - - - - 149 Accumulated deferred investment tax credits 255 - - - - - - 150 Customer advances for construction 252 (11,416,545) (8,824,944) (1,867,927) (42,361) (1,574) (679,739) 151 Other regulatory liabilities 254 - - - - - - 152 Working capital allowance N/A - - - - - - 153 Subtotal - Other Rate Base Items (50,021,170)$ (36,976,373)$ (9,511,423)$ (222,691)$ (15,576)$ (3,295,107)$ 154 TOTAL RATE BASE 385,554,542$ 276,755,683$ 77,030,661$ 1,941,268$ 159,490$ 29,667,440$ INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 26 of 36 Intermountain Gas Company Gas Class Cost of Service Study Test Year Ended December 31, 2022 Schedule 5 - Cost of Service Allocation Study Detail by Account Line No.Account Description FERC Account Account Balance Residential Service General Service Large Volume Transport Service (Interruptible) Transport Service (Firm) 155 OPERATION AND MAINTENANCE EXPENSE 156 Production, Storage, LNG, Transmission, and Distribution Expense 157 Other Gas Supply Expenses 158 Natural gas well head purchases 800 -$ -$ -$ -$ -$ -$ 159 Natural gas well head purchases, intracompany transfers 800.1 - - - - - - 160 Natural gas field line purchases 801 - - - - - - 161 Natural gas gasoline plant outlet purchases 802 - - - - - - 162 Natural gas transmission line purchases 803 - - - - - - 163 Natural gas city gate purchases 804 - - - - - - 164 Liquefied natural gas purchases 804.1 - - - - - - 165 Other gas purchases 805 - - - - - - 166 Purchased gas cost adjustments 805.1 - - - - - - 167 Exchange gas 806 - - - - - - 168 Well expenses—Purchased gas. 807.1 - - - - - - 169 Operation of purchased gas measuring stations. 807.2 - - - - - - 170 Maintenance of purchased gas measuring stations. 807.3 - - - - - - 171 Purchased gas calculations expenses. 807.4 - - - - - - 172 Other purchased gas expenses. 807.5 - - - - - - 173 Gas withdrawn from storage—debit 808.1 - - - - - - 174 Gas delivered to storage—credit 808.2 - - - - - - 175 Withdrawals of liquefied natural gas held for processing—debt 809.1 - - - - - - 176 Deliveries of natural gas for processing—credit 809.2 - - - - - - 177 Gas used for compressor station fuel—credit 810 - - - - - - 178 Gas used for products extraction—credit 811 - - - - - - 179 Other gas supply expenses - Gas Supply 813.1 311,201 108,616 50,104 9,091 7,462 135,928 180 Other gas supply expenses 813 43,828 40,009 3,804 4 1 11 181 Subtotal - Other Gas Supply Expenses 355,029$ 148,625$ 53,908$ 9,095$ 7,462$ 135,939$ 182 Other Storage Expenses - Operation 183 Operation supervision and engineering 840 (1,000)$ (524)$ (232)$ (12)$ -$ (232)$ 184 Operation labor and expenses 841 729,867 382,637 169,059 8,808 - 169,363 185 Rents 842 - - - - - - 186 Fuel 842.1 261,332 137,005 60,532 3,154 - 60,641 187 Power 842.2 120,043 62,933 27,805 1,449 - 27,856 188 Gas losses 842.3 - - - - - - 189 Subtotal - Other Storage Expenses - Operation 1,110,242$ 582,051$ 257,164$ 13,398$ -$ 257,628$ INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 27 of 36 Intermountain Gas Company Gas Class Cost of Service Study Test Year Ended December 31, 2022 Schedule 5 - Cost of Service Allocation Study Detail by Account Line No.Account Description FERC Account Account Balance Residential Service General Service Large Volume Transport Service (Interruptible) Transport Service (Firm) 190 Other Storage Expenses - Maintenance 191 Maintenance supervision and engineering 843.1 -$ -$ -$ -$ -$ -$ 192 Maintenance of structures and improvements 843.2 1,410 739 327 17 - 327 193 Maintenance of gas holders 843.3 206 108 48 2 - 48 194 Maintenance of purification equipment 843.4 10,299 5,399 2,386 124 - 2,390 195 Maintenance of liquefaction equipment 843.5 49,876 26,148 11,553 602 - 11,574 196 Maintenance of vaporizing equipment 843.6 127,185 66,678 29,460 1,535 - 29,513 197 Maintenance of compressor equipment 843.7 21,459 11,250 4,971 259 - 4,979 198 Maintenance of measuring and regulating equipment 843.8 - - - - - - 199 Maintenance of other equipment 843.9 32,199 16,881 7,458 389 - 7,472 200 Subtotal - Other Storage Expenses - Maintenance 242,634$ 127,202$ 56,201$ 2,928$ -$ 56,302$ 201 Transmission Operation Expenses 202 Operation supervision and engineering 850 -$ -$ -$ -$ -$ -$ 203 System control and load dispatching 851 - - - - - - 204 Communication system expenses 852 24,308 12,744 5,630 293 - 5,641 205 Compressor station labor and expenses 853 108,155 56,701 25,052 1,305 - 25,097 206 Gas for compressor station fuel 854 - - - - - - 207 Other fuel and power for compressor stations 855 - - - - - - 208 Mains expenses 856 1,794 941 416 22 - 416 209 Measuring and regulating station expenses 857 - - - - - - 210 Transmission and compression of gas by others 858 - - - - - - 211 Other expenses 859 - - - - - - 212 Rents 860 - - - - - - 213 Subtotal - Transmission Operation Expenses 134,257$ 70,385$ 31,098$ 1,620$ -$ 31,154$ 214 Transmission Maintenance Expenses 215 Maintenance supervision and engineering 861 -$ -$ -$ -$ -$ -$ 216 Maintenance of structures and improvements 862 - - - - - - 217 Maintenance of mains 863 17,516 9,183 4,057 211 - 4,065 218 Transmission Mains - Pipeline Integrity 863.1 107,910 56,572 24,995 1,302 - 25,040 219 Maintenance of compressor station equipment 864 - - - - - - 220 Maintenance of measuring and regulating station equipment 865 - - - - - - 221 Maintenance of communication equipment 866 148,386 77,792 34,371 1,791 - 34,433 222 Maintenance of other equipment 867 - - - - - - 223 Subtotal - Transmission Maintenance Expenses 273,812$ 143,548$ 63,423$ 3,304$ -$ 63,537$ INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 28 of 36 Intermountain Gas Company Gas Class Cost of Service Study Test Year Ended December 31, 2022 Schedule 5 - Cost of Service Allocation Study Detail by Account Line No.Account Description FERC Account Account Balance Residential Service General Service Large Volume Transport Service (Interruptible) Transport Service (Firm) 224 Distribution Operation Expenses 225 Operation supervision and engineering 870 4,439,416$ 3,288,592$ 885,343$ 20,987$ 5,452$ 239,042$ 226 Operation supervision and engineering- Gas Supply and Control 870.1 58,796 20,521 9,466 1,718 1,410 25,681 227 Distribution load dispatching 871 261,192 91,162 42,053 7,630 6,263 114,085 228 Compressor station fuel and power (major only) 873 - - - - - - 229 Mains and services expenses 874 4,597,235 3,553,644 752,180 17,058 634 273,718 230 Measuring and regulating station expenses—general 875 423,705 313,099 64,237 2,308 4 44,056 231 Measuring and regulating station expenses—industrial 876 410,419 - 373,637 12,541 1,704 22,537 232 Measuring and regulating station expenses—city gate check stations 877 - - - - - - 233 Meter and house regulator expenses 878 1,416,766 1,046,546 359,623 1,757 1,608 7,232 234 Meter and house regulator expenses - installation credits 878.3 (1,909,122) (1,410,243) (484,600) (2,368) (2,167) (9,745) 235 Customer installations expenses 879 2,161,755 1,973,347 187,634 189 40 546 236 Other expenses 880 6,117,348 4,584,637 1,190,828 24,084 2,373 315,426 237 Rents 881 246,308 182,458 49,121 1,164 302 13,263 238 Subtotal - Distribution Operation Expenses 18,223,818$ 13,643,763$ 3,429,522$ 87,069$ 17,623$ 1,045,841$ 239 Distribution Maintenance Expenses 240 Maintenance supervision and engineering 885 268,452$ 206,931$ 51,575$ 760$ 113$ 9,073$ 241 Maintenance of structures and improvements 886 - - - - - - 242 Maintenance of mains 887 1,596,136 1,179,474 241,987 8,696 16 165,963 243 Distribution Mains - Pipeline Integrity 887.1 75,302 55,645 11,416 410 1 7,830 244 Maintenance of compressor station equipment 888 - - - - - - 245 Maintenance of measuring and regulating station equipment—general 889 538,775 398,131 81,682 2,935 6 56,021 246 Maintenance of measuring and regulating station equipment—industrial 890 138,403 - 125,999 4,229 575 7,600 247 Maintenance of measuring and regulating station equipment—city gate 891 9,985 7,378 1,514 54 0 1,038 248 Maintenance of services 892 3,118,096 2,538,539 555,416 5,022 911 18,209 249 Maintenance of meters and house regulators 893 1,413,166 1,043,887 358,709 1,753 1,604 7,213 250 Maintenance of other equipment 894 935,027 720,746 179,639 2,647 393 31,603 251 Subtotal - Distribution Maintenance Expenses 8,093,342$ 6,150,731$ 1,607,938$ 26,507$ 3,617$ 304,549$ 252 Total Production, Storage, LNG, Transmission, and Distribution Expense 28,433,134$ 20,866,305$ 5,499,255$ 143,921$ 28,703$ 1,894,950$ 253 Customer Accounts, Service, and Sales Expense 254 Customer Account 255 Supervision 901 181,076$ 164,269$ 16,672$ 33$ 7$ 95$ 256 Meter reading expenses 902 1,116,986 1,019,635 96,951 97 21 282 257 Customer records and collection expenses 903 7,644,742 6,978,463 663,540 667 142 1,930 258 Uncollectible accounts 904 927,448 791,735 131,603 1,001 213 2,896 259 Miscellaneous customer accounts expenses 905 - - - - - - 260 Subtotal - Customer Account 9,870,252$ 8,954,101$ 908,766$ 1,798$ 383$ 5,204$ INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 29 of 36 Intermountain Gas Company Gas Class Cost of Service Study Test Year Ended December 31, 2022 Schedule 5 - Cost of Service Allocation Study Detail by Account Line No.Account Description FERC Account Account Balance Residential Service General Service Large Volume Transport Service (Interruptible) Transport Service (Firm) 261 Customer Service & Information Expenses 262 Supervision 907 -$ -$ -$ -$ -$ -$ 263 Customer assistance expenses 908 83,522 76,243 7,249 7 2 21 264 Informational and instructional advertising expenses 909 136,800 124,877 11,874 12 3 35 265 Miscellaneous customer service and informational expenses 910 - - - - - - 266 Subtotal - Customer Service & Information Expenses 220,322$ 201,120$ 19,123$ 19$ 4$ 56$ 267 Sales Expenses 268 Supervision 911 267,946$ 244,593$ 23,257$ 23$ 5$ 68$ 269 Demonstrating and selling expenses 912 1,308,122 1,194,112 113,541 114 24 330 270 Advertising expenses 913 40,634 37,093 3,527 4 1 10 271 Miscellaneous sales expenses 916 - - - - - - 272 Subtotal - Sales Expenses 1,616,702$ 1,475,798$ 140,325$ 141$ 30$ 408$ 273 Total Customer Accounts, Service, and Sales Expense 11,707,276$ 10,631,019$ 1,068,214$ 1,959$ 417$ 5,668$ 274 Administrative and General Expenses 275 Administrative and general salaries 920 6,103,487$ 4,490,168$ 1,208,127$ 29,427$ 7,922$ 367,842$ 276 Administrative and general salaries - Gas Supply and Control 920.1 165,501 57,764 26,646 4,835 3,968 72,288 277 Office supplies and expenses 921 5,836,289 4,293,598 1,155,238 28,139 7,575 351,739 278 Outside services employed 923 881,339 648,377 174,453 4,249 1,144 53,116 279 Property insurance 924 132,525 94,760 26,555 690 51 10,469 280 Injuries and damages 925 1,214,400 893,401 240,379 5,855 1,576 73,189 281 Employee pensions and benefits 926 1,702,930 1,252,799 337,079 8,210 2,210 102,631 282 Franchise requirements 927 - - - - - - 283 Regulatory commission expenses 928 109,340 71,515 26,658 713 565 9,889 284 Duplicate charges—Credit 929 71,492 46,760 17,430 466 369 6,466 285 General advertising expenses 930.1 245,197 223,827 21,282 21 5 62 286 Miscellaneous general expenses 930.2 235,750 178,100 44,165 1,053 208 12,223 287 Rents 931 850,986 626,047 168,445 4,103 1,104 51,287 288 Maintenance of general plant 935 3 2 1 0 0 0 289 Subtotal - Administrative and General Expenses 17,549,239$ 12,877,120$ 3,446,458$ 87,762$ 26,697$ 1,111,202$ 290 TOTAL OPERATION AND MAINTENANCE EXPENSE 57,689,649$ 44,374,444$ 10,013,927$ 233,642$ 55,817$ 3,011,819$ 291 Adjustments, Depreciation and Amortization Expense 292 Depreciation Expense 293 Depreciation expense intangible plant 403.1 4,684,938$ 3,425,319$ 929,849$ 22,982$ 5,143$ 301,645$ 294 Depreciation expense storage and terminaling 403.2 1,110,353 582,110 257,190 13,399 - 257,654 295 Depreciation expense transmission 403.3 1,041,651 546,092 241,277 12,570 - 241,712 296 Depreciation expense distribution 403.4 13,476,497 10,099,940 2,623,389 53,057 5,228 694,884 297 Depreciation expense general plant 403.5 1,693,650 1,212,482 339,196 8,786 721 132,465 298 Subtotal - Depreciation Expense 22,007,089$ 15,865,943$ 4,390,901$ 110,795$ 11,091$ 1,628,360$ INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 30 of 36 Intermountain Gas Company Gas Class Cost of Service Study Test Year Ended December 31, 2022 Schedule 5 - Cost of Service Allocation Study Detail by Account Line No.Account Description FERC Account Account Balance Residential Service General Service Large Volume Transport Service (Interruptible) Transport Service (Firm) 299 Amortization Expense 300 Amortization and depletion of producing natural gas land and land 404.1 - - - - - - 301 Amortization of underground storage land and land rights 404.2 - - - - - - 302 Amortization of other limited-term gas plant 404.3 - - - - - - 303 Amortization of other gas plant 405 - - - - - - 304 Amortization of gas plant acquisition adjustments 406 - - - - - - 305 Amortization of property losses, unrecovered plant and regulatory 407.1 - - - - - - 306 Amortization of conversion expense 407.2 - - - - - - 307 Subtotal - Amortization Expense - - - - - - 308 Total Adjustments, Depreciation and Amortization Expense 22,007,089$ 15,865,943$ 4,390,901$ 110,795$ 11,091$ 1,628,360$ 309 Taxes 310 Taxes Other Than Income Taxes 311 Taxes Other Than Income Taxes - Payroll 408.1 2,220,444$ 1,633,520$ 439,516$ 10,706$ 2,882$ 133,821$ 312 Taxes Other Than Income Taxes - Property 408.2 2,182,729 1,560,735 437,368 11,358 846 172,422 313 Taxes Other Than Income Taxes - Franchise 408.3 18,505 12,103 4,512 121 96 1,674 314 Taxes Other Than Income Taxes - IPUC Fee 408.4 520,047 340,144 126,791 3,390 2,687 47,035 315 Subtotal - Taxes Other Than Income Taxes 4,941,725$ 3,546,502$ 1,008,187$ 25,575$ 6,510$ 354,952$ 316 Income Taxes 317 Income Taxes - federal taxes utility operating income 409.1 2,884,190$ 2,070,306$ 576,238$ 14,522$ 1,193$ 221,931$ 318 Income Taxes - state taxes utility operating income 409.1 (124,089) (89,073) (24,792) (625) (51) (9,548) 319 Income Taxes - other taxes utility operating income 410.1 - - - - - - 320 Provision for deferred income taxes—credit, utility operating income 411.1 - - - - - - 321 Investment Tax credit Adj. 411.4 - - - - - - 322 Subtotal - Income Taxes 2,760,101$ 1,981,234$ 551,446$ 13,897$ 1,142$ 212,383$ 323 Total Taxes 7,701,826$ 5,527,735$ 1,559,632$ 39,472$ 7,652$ 567,335$ 324 REVENUE REQUIREMENT AT EQUAL RATES OF RETURN 325 Test Year Expenses at Current Rates 87,398,564$ 65,768,123$ 15,964,460$ 383,909$ 74,559$ 5,207,514$ 326 Return on Rate Base 28,415,370$ 20,396,894$ 5,677,160$ 143,071$ 11,754$ 2,186,490$ 327 Gross Up Items - - - - - 328 Federal Income Tax 1,329,772$ 954,526$ 265,678$ 6,695$ 550$ 102,323$ 329 State Income Tax 389,885 279,864 77,896 1,963 161 30,001 330 Uncollectible Account - Increase 16,597 14,168 2,355 18 4 52 331 Taxes Other Than Income Taxes - IPUC Fee 13,471 8,811 3,284 88 70 1,218 332 TOTAL REVENUE REQUIREMENT AT EQUAL RATES OF RETURN 117,563,659$ 87,422,386$ 21,990,833$ 535,744$ 87,098$ 7,527,597$ INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 31 of 36 Intermountain Gas Company Gas Class Cost of Service Study Test Year Ended December 31, 2022 Schedule 6 - Functionalized and Classified Rate Base and Revenue Requirement, and Unit Costs by Customer Class Line Description TOTAL Residential Service General Service Large Volume Transport Service (Interruptible) Transport Service (Firm) 1 Functional Rate Base 2 Storage 3 Demand 28,223,514$ 14,796,355$ 6,537,390$ 340,591$ -$ 6,549,178$ 4 Commodity - - - - - - 5 Customer - - - - - - 6 Subtotal 28,223,514$ 14,796,355$ 6,537,390$ 340,591$ -$ 6,549,178$ 7 Transmission 8 Demand 22,629,066$ 11,863,430$ 5,241,553$ 273,079$ -$ 5,251,004$ 9 Commodity - - - - - - 10 Customer - - - - - - 11 Subtotal 22,629,066$ 11,863,430$ 5,241,553$ 273,079$ -$ 5,251,004$ 12 Distribution 13 Demand 155,067,456$ 114,588,013$ 23,509,421$ 844,859$ 1,590$ 16,123,573$ 14 Commodity - - - - - - 15 Customer 7,074,007 4,689,702 1,801,238 55,423 29,323 498,321 16 Subtotal 162,141,463$ 119,277,715$ 25,310,660$ 900,282$ 30,913$ 16,621,893$ 17 Customer 18 Demand -$ -$ -$ -$ -$ -$ 19 Commodity - - - - - - 20 Customer 172,560,499 130,818,182 39,941,059 427,316 128,577 1,245,365 21 Subtotal 172,560,499$ 130,818,182$ 39,941,059$ 427,316$ 128,577$ 1,245,365$ 22 Total 23 Demand 205,920,036$ 141,247,798$ 35,288,364$ 1,458,529$ 1,590$ 27,923,755$ 24 Commodity - - - - - - 25 Customer 179,634,506 135,507,885 41,742,297 482,739 157,900 1,743,686 26 TOTAL RATE BASE 385,554,542$ 276,755,683$ 77,030,661$ 1,941,268$ 159,490$ 29,667,440$ 27 Functional Revenue Requirement 28 Storage 29 Demand 5,724,478$ 3,001,094$ 1,325,956$ 69,081$ -$ 1,328,347$ 30 Commodity - - - - - - 31 Customer - - - - - - INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 32 of 36 Intermountain Gas Company Gas Class Cost of Service Study Test Year Ended December 31, 2022 Schedule 6 - Functionalized and Classified Rate Base and Revenue Requirement, and Unit Costs by Customer Class Line Description TOTAL Residential Service General Service Large Volume Transport Service (Interruptible) Transport Service (Firm) 32 Subtotal 5,724,478$ 3,001,094$ 1,325,956$ 69,081$ -$ 1,328,347$ 33 Transmission 34 Demand 4,078,066$ 2,137,952$ 944,599$ 49,213$ -$ 946,302$ 35 Commodity - - - - - - 36 Customer - - - - - - 37 Subtotal 4,078,066$ 2,137,952$ 944,599$ 49,213$ -$ 946,302$ 38 Distribution 39 Demand 38,091,335$ 28,147,817$ 5,774,940$ 207,534$ 391$ 3,960,653$ 40 Commodity - - - - - - 41 Customer 13,348,032 8,933,313 3,400,983 99,403 51,173 863,160 42 Subtotal 51,439,367$ 37,081,130$ 9,175,923$ 306,937$ 51,564$ 4,823,814$ 43 Customer 44 Demand -$ -$ -$ -$ -$ -$ 45 Commodity - - - - - - 46 Customer 56,321,748 45,202,211 10,544,354 110,514 35,535 429,134 47 Subtotal 56,321,748$ 45,202,211$ 10,544,354$ 110,514$ 35,535$ 429,134$ 48 Total 49 Demand 47,893,879$ 33,286,862$ 8,045,495$ 325,828$ 391$ 6,235,303$ 50 Commodity - - - - - - 51 Customer 69,669,780 54,135,524 13,945,337 209,917 86,708 1,292,295 52 TOTAL REVENUE REQUIREMENT AT EQUAL RATES OF RETURN 117,563,659$ 87,422,386$ 21,990,833$ 535,744$ 87,098$ 7,527,597$ 53 Demand 40.74%38.08%36.59%60.82%0.45%82.83% 54 Energy 0.00%0.00%0.00%0.00%0.00%0.00% 55 Customer 59.26%61.92%63.41%39.18%99.55%17.17% 56 Unit Costs 57 Storage 58 Demand 0.07$ 0.07$ 0.07$ 0.07$ -$ 0.07$ 59 Commodity -$ -$ -$ -$ -$ -$ 60 Customer -$ -$ -$ -$ -$ -$ INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 33 of 36 Intermountain Gas Company Gas Class Cost of Service Study Test Year Ended December 31, 2022 Schedule 6 - Functionalized and Classified Rate Base and Revenue Requirement, and Unit Costs by Customer Class Line Description TOTAL Residential Service General Service Large Volume Transport Service (Interruptible) Transport Service (Firm) 61 Transmission 62 Demand 0.05$ 0.05$ 0.05$ 0.05$ -$ 0.05$ 63 Commodity -$ -$ -$ -$ -$ -$ 64 Customer -$ -$ -$ -$ -$ -$ 65 Distribution 66 Demand 0.49$ 0.70$ 0.32$ 0.22$ -$ 0.22$ 67 Commodity -$ -$ -$ -$ -$ -$ 68 Customer 2.75$ 2.02$ 8.08$ 234.99$ 568.59$ 705.20$ 69 Customer 70 Demand -$ -$ -$ -$ -$ -$ 71 Commodity -$ -$ -$ -$ -$ -$ 72 Customer 11.62$ 10.21$ 25.05$ 261.26$ 394.83$ 350.60$ 73 Total 74 Commodity -$ -$ -$ -$ -$ -$ 75 Customer (per cust month)14.37$ 12.23$ 33.14$ 496.26$ 963.42$ 1,055.80$ 76 Demand & Customer (per cust month)24.25$ 19.75$ 52.25$ 1,266.53$ 967.76$ 6,150.00$ 77 Demand (per MDFQ)0.35$ 0.34$ 78 BILLING DETERMINANTS 79 Demand (Peak Day Demand * 12)76,971,173 40,352,622 17,828,771 928,860 0 17,860,920 80 Commodity 822,087,104 285,332,326 140,313,436 14,130,994 44,289,741 338,020,607 81 Customers (Number of Bills)4,848,663 4,426,077 420,849 423 90 1,224 82 Demand 19,211,469 941,339 18,270,130 INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 34 of 36 Intermountain Gas Company Gas Class Cost of Service Study Test Year Ended December 31, 2022 Schedule 7 – Alternative Cost of Service and Rate of Return under Present and Proposed Rates Line No.Revenue Requirement Summary Total System Residential Service General Service Large Volume Transport Service (Interruptible) Transport Service (Firm) 1 Rate Base 2 Plant in Service 838,044,089$ 596,636,016$ 166,791,463$ 4,298,951$ 5,310,640$ 65,007,019$ 3 Accumulated Reserve (402,468,377) (284,195,888) (80,812,845) (2,165,863) (2,655,725) (32,638,056) 4 Other Rate Base Items (50,021,170) (36,846,816) (9,454,917) (219,595) (264,260) (3,235,582) 5 Total Rate Base 385,554,542$ 275,593,311$ 76,523,700$ 1,913,494$ 2,390,656$ 29,133,381$ 6 Rate of Return Under Current ROR 7 Revenue at Current Rates 8 Gas Service Revenue 108,348,580$ 70,866,860$ 26,416,220$ 706,333$ 559,724$ 9,799,443$ 9 Other Revenues 2,462,855 1,825,985 458,317 11,093 12,261 155,198 10 Total Revenue 110,811,435$ 72,692,845$ 26,874,537$ 717,426$ 571,985$ 9,954,641$ 11 Expenses at Current Rates 12 O&M and A&G Expenses 57,689,649$ 44,286,352$ 9,975,506$ 231,537$ 224,909$ 2,971,345$ 13 Depreciation and Amortization Expense 22,007,089 15,804,131 4,363,942 109,318 129,739 1,599,960 14 Taxes Other Than Income 4,941,725 3,536,044 1,003,625 25,325 26,584 350,147 15 Total Operating Expenses 84,638,463$ 63,626,527$ 15,343,073$ 366,180$ 381,232$ 4,921,451$ 16 Earnings Before Interest and Taxes 26,172,972$ 9,066,318$ 11,531,464$ 351,247$ 190,753$ 5,033,190$ 17 Current State/Federal Income Taxes 2,760,101$ 956,099$ 1,216,064$ 37,041$ 20,116$ 530,781$ 18 Deferred Income Tax - - - - - - 19 Total Income Taxes 2,760,101$ 956,099$ 1,216,064$ 37,041$ 20,116$ 530,781$ 20 Total Expenses at Current Rates 87,398,564$ 64,582,626$ 16,559,137$ 403,221$ 401,348$ 5,452,232$ 21 Operating Income at Current Rates 23,412,871$ 8,110,219$ 10,315,400$ 314,206$ 170,637$ 4,502,409$ 22 Current Rate of Return 6.07% 2.94% 13.48% 16.42% 7.14% 15.45% 23 Relative Rate of Return 1.00 0.48 2.22 2.70 1.18 2.54 24 Current Revenue to Cost Ratio 0.94 0.83 1.23 1.35 0.98 1.34 25 Current Parity Ratio 1.00 0.88 1.30 1.44 1.04 1.43 INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 35 of 36 Intermountain Gas Company Gas Class Cost of Service Study Test Year Ended December 31, 2022 Schedule 7 – Alternative Cost of Service and Rate of Return under Present and Proposed Rates Line No.Revenue Requirement Summary Total System Residential Service General Service Large Volume Transport Service (Interruptible) Transport Service (Firm) 26 Rate of Return Under Equal ROR 27 Revenue Requirement Required Return at Equal Rates of Return 28 Required Return 7.37% 7.37% 7.37% 7.37% 7.37% 7.37% 29 Required Operating Income 28,415,370$ 20,311,227$ 5,639,797$ 141,025$ 176,191$ 2,147,130$ 30 Expenses at Required Return 31 O&M and A&G Expenses 57,689,649$ 44,286,352$ 9,975,506$ 231,537$ 224,909$ 2,971,345$ 32 Depreciation and Amortization Expense 22,007,089 15,804,131 4,363,942 109,318 129,739 1,599,960 33 Taxes Other Than Income 4,941,725 3,536,044 1,003,625 25,325 26,584 350,147 34 Total Operating Expenses 84,638,463$ 63,626,527$ 15,343,073$ 366,180$ 381,232$ 4,921,451$ 35 Deferred Income Tax -$ -$ -$ -$ -$ -$ 36 Current State/Federal Income Taxes 2,760,101 1,972,912 547,817 13,698 17,114 208,560 37 Income Taxes and Other 2,760,101$ 1,972,912$ 547,817$ 13,698$ 17,114$ 208,560$ 38 Increase - Federal Income Tax 1,329,772$ 950,517$ 263,929$ 6,600$ 8,245$ 100,481$ 39 Increase - State Utility Tax 389,885 278,689 77,383 1,935 2,418 29,461 40 Increase - Bad Debts 16,597 14,168 2,355 18 4 52 41 Increase - Annual Filing Fee 13,471 8,811 3,284 88 70 1,218 42 Revenue Increase Related Expenses 1,749,725$ 1,252,185$ 346,952$ 8,640$ 10,736$ 131,211$ 43 Total Expenses at Required Return 89,148,289$ 66,851,625$ 16,237,842$ 388,518$ 409,082$ 5,261,222$ 44 Total Revenue Requirement Required Return at Equal Rates of Return 117,563,659$ 87,162,852$ 21,877,638$ 529,543$ 585,273$ 7,408,353$ 45 LESS 46 Current Miscellaneous Revenue Margin 2,462,855 1,825,985 458,317 11,093 12,261 155,198 47 Total Rate Margin at Equal Rates of Return 115,100,804$ 85,336,867$ 21,419,321$ 518,449$ 573,012$ 7,253,154$ 48 Total Current Rate Margin 108,348,580$ 70,866,860$ 26,416,220$ 706,333$ 559,724$ 9,799,443$ 49 Base Rate Margin (Deficiency)/Surplus (6,752,224)$ (14,470,007)$ 4,996,899$ 187,884$ (13,288)$ 2,546,289$ 50 Proposed Margin Increase 6,752,224$ 5,520,480$ 875,025$ 23,397$ 8,720$ 324,602$ 51 Total Revenue Increase as Proposed 117,563,659$ 78,213,325$ 27,749,562$ 740,823$ 580,705$ 10,279,243$ 52 Income Prior to Taxes 32,895,128$ 14,563,819$ 12,400,849$ 374,538$ 199,400$ 5,356,522$ 53 Income Taxes and Other 4,479,758$ 3,202,119$ 889,129$ 22,233$ 27,777$ 338,501$ 54 Proposed Operating Income 28,415,370$ 11,361,700$ 11,511,721$ 352,305$ 171,623$ 5,018,021$ 55 Proposed Rate of Return 7.37% 4.12% 15.04% 18.41% 7.18% 17.22% 56 Relative Rate of Return 1.00 0.56 2.04 2.50 0.97 2.34 57 Proposed Revenue to Cost Ratio 1.00 0.90 1.27 1.40 0.99 1.39 58 Proposed Parity Ratio 1.00 0.90 1.27 1.40 0.99 1.39 INT-G-22-07 R. Amen, IGC Exhibit No. 2 - Update Page 36 of 36 Intermountain Gas Company Gas Class Cost of Service Study Test Year Ended December 31, 2022 Exhibit 3 Supplemental – Proposed Revenue Targets Line No.Description Total System Residential Service General Service Large Volume Transport Service (Interruptible) Transport Service (Firm) 1 Total Rate Base 385,554,542$ 276,755,683$ 77,030,661$ 1,941,268$ 159,490$ 29,667,440$ 2 Gas Service Revenue 108,348,580$ 70,866,860$ 26,416,220$ 706,333$ 559,724$ 9,799,443$ 3 Other Revenues 2,462,855 1,831,422 460,689 11,223 1,825 157,697 4 Total Revenue 110,811,435$ 72,698,282$ 26,876,909$ 717,556$ 561,549$ 9,957,140$ 5 Current Revenue to Cost Ratio 0.94 0.83 1.22 1.34 6.45 1.32 6 Current Parity Ratio 1.00 0.88 1.30 1.42 6.84 1.40 7 Scenario A: Revenues at Equalized Rates of Return 8 Revenue Increase/(Decrease)6,752,224$ 14,724,104$ (4,886,076)$ (181,812)$ (474,450)$ (2,429,542)$ 9 Total Rate Revenue at Equalized Rates of Return 115,100,804 85,590,964 21,530,144 524,521 85,274 7,369,901 10 Other Revenues 2,462,855 1,831,422 460,689 11,223 1,825 157,697 11 Total Revenue at Equalized Rates of Return 117,563,659$ 87,422,386$ 21,990,833$ 535,744$ 87,098$ 7,527,597$ 12 % Increase of Total Revenues 6.09%20.25%-18.18%-25.34%-84.49%-24.40% 13 % Increase of Margin Revenues 6.23%20.78%-18.50%-25.74%-84.77%-24.79% 14 Resulting Revenue to Cost Ratio 1.00 1.00 1.00 1.00 1.00 1.00 15 Resulting Parity Ratio 1.00 1.00 1.00 1.00 1.00 1.00 16 Scenario B: Equal Percentage Increase on Gas Service Revenue 17 Percent Increase 6.23%6.23%6.23%6.23%6.23%6.23% 18 Revenue Increase/(Decrease)6,752,224$ 4,416,384$ 1,646,244$ 44,018$ 34,882$ 610,696$ 19 Total Rate Revenue 115,100,804 75,283,244 28,062,464 750,351 594,606 10,410,139 20 Other Revenues 2,462,855 1,831,422 460,689 11,223 1,825 157,697 21 Total Revenue at Equal Percentage Increase 117,563,659$ 77,114,666$ 28,523,153$ 761,575$ 596,430$ 10,567,835$ 22 Resulting Revenue to Cost Ratio 1.00 0.88 1.30 1.42 6.85 1.40 23 Resulting Parity Ratio 1.00 0.88 1.30 1.42 6.85 1.40 24 Proposed Scenario C: Moderated based on the Current Parity Ratio 25 Multiple of System Increase 1.25 0.53 0.53 0.25 0.53 26 Percent Increase 7.79%3.31%3.31%1.56%3.31% 27 Revenue Increase/(Decrease)6,752,224$ 5,520,480$ 875,025$ 23,397$ 8,720$ 324,602$ 28 Total Rate Revenue 115,100,804 76,387,340 27,291,245 729,730 568,444 10,124,045 29 Other Revenues 2,462,855 1,831,422 460,689 11,223 1,825 157,697 30 Total Revenue at Proposed 117,563,659$ 78,218,762$ 27,751,933$ 740,953$ 570,269$ 10,281,741$ 31 Base Rate Margin at Proposed 115,100,804$ 76,387,340$ 27,291,245$ 729,730$ 568,444$ 10,124,045$ 32 Percent Increase on Base Rate Margin 6.23%7.79%3.31%3.31%1.56%3.31% 33 Proposed Revenue to Cost Ratio 1.00 0.89 1.26 1.38 6.55 1.37 34 Proposed Parity Ratio 1.00 0.89 1.26 1.38 6.55 1.37 INT-G-22-07 R. Amen, IGC Exhibit No. 3 - Update Page 1 of 1 Intermountain Gas Company Exhibit 4 Supplemental - Proposed Rate Design and Proof of Revenue Residential Billing Current Base Rates Proposed Base Rates Difference Description Units Determinants Rates Revenues Rates Revenues $% RS_RESIDENTIAL SERVICE Customer Charge Cust Bills 4,423,383 5.50$ 24,328,607$ 9.00$ 39,810,447$ 15,481,841$ 63.64% Distribution Charge Therms 284,776,158 0.16305$ 46,432,754$ 0.12811$ 36,482,674$ (9,950,080)$ -21.43% Total Base Revenues 70,761,360$ 76,293,121$ 5,531,761$ 7.82% IS-R_RESIDENTIAL INTERRUPTIBLE SNOWMELT SERVICE Customer Charge Cust Bills 2,694 5.50$ 14,817$ 8.00$ 21,552$ 6,735$ 45.46% Distribution Charge Therms 556,168 0.16305$ 90,683$ 0.12811$ 71,251$ (19,433)$ -21.43% Total Base Revenues 105,500$ 92,803$ (12,698)$ -12.04% Total Customer Charge Revenue Cust 24,343,424$ 39,831,999$ 15,488,576$ 63.63% Total Distribution Charge Revenue Therms 46,523,437$ 36,553,924$ (9,969,512)$ -21.43% Total Base Revenues 70,866,860$ 76,385,923$ 5,519,063$ 7.79% Target Revenue 76,387,340$ Cust Bills 4,423,383 5.50$ 24,328,607$ 9.00$ 39,810,447$ $15,481,841 63.64% Cust Bills 2,694 5.50$ 14,817 8.00$ 21,552 6,735 45.46% Therms 285,332,326 0.16305$ 46,523,437$ 0.12811$ 36,555,341$ ($9,968,096)-21.43% Total Base Revenues 70,866,860$ 76,387,340$ 5,520,479$ 7.79% Target Revenue Difference (1,416)$ Target Revenue Difference %0.00% INT-G-22-07 R. Amen, IGC Exhibit No. 4 - Update Page 1 of 6 Intermountain Gas Company Exhibit 4 Supplemental - Proposed Rate Design and Proof of Revenue General Service Billing Current Base Rates Proposed Base Rates Difference Description Units Determinants Rates Revenues Rates Revenues $% GS-1_GENERAL SERVICE Customer Charge Cust 420,100 9.50$ 3,990,950$ 15.00$ 6,301,500$ 2,310,550$ 57.90% Block 1 - First 200 therms per bill Therms 38,586,470 0.18465$ 7,124,992$ 0.17281$ 6,668,128$ (456,864)$ -6.41% Block 2 - Next 1,800 therms per bill Therms 68,565,605 0.16117 11,050,717 0.15083 10,341,750 (708,967) -6.42% Block 3 - Next 8,000 therms per bill Therms 27,582,172 0.13850 3,820,131 0.12962 3,575,201 (244,930) -6.41% Block 4 - Over 10,000 therms per bill Therms 5,222,540 0.06994 365,264 0.06545 341,815 (23,449) -6.42% 139,956,787 22,361,104$ 20,926,894$ (1,434,210)$ -6.41% Total Base Revenues 26,352,054$ 27,228,394$ 876,340$ 3.33% GS-1 IRRIGATION CUSTOMERS Customer Charge Cust 105 9.50$ 998$ 15.00$ 1,575$ 577.50$ 57.90% Block 1 - First 200 therms per bill Therms 10,699 0.18465$ 1,977$ 0.17281$ 1,849$ (127.68)$ -6.46% Block 2 - Next 1,800 therms per bill Therms 47,686 0.16117 7,686 0.15083 7,192 (493.07) -6.42% Block 3 - Next 8,000 therms per bill Therms 12,661 0.13850 1,754 0.12962 1,641 (112.43) -6.41% Block 4 - Over 10,000 therms per bill Therms 0 0.06994 - 0.06545 - - 0.00% 71,046 11,416$ 10,682$ (733.18)$ -6.42% Total Base Revenues 12,413$ 12,257$ (155.68)$ -1.25% GS-1 - COMPRESSED NATURAL GAS Customer Charge Cust 6 9.50$ 57.00$ 15.00$ 90.00$ 33.00$ 57.90% Block 1 - First 10,000 therms per bill Therms 0 0.13850$ - 0.12962$ - - 0.00% Block 2 - Over 10,000 therms per bill Therms 0 0.06994 - 0.06545 - - 0.00% 0 -$ -$ -$ 0.00% Total Base Revenues $57 $90 $33 57.90% IS-C - SMALL COMMERCIAL INTERRUPTIBLE SNOWMELT SERVICE Customer Charge Cust 638 9.50$ 6,061$ 12.50$ 7,975$ 1,914.0$ 31.58% Block 1 - First 200 therms per bill Therms 51,865 0.18465$ 9,577$ 0.17281$ 8,963$ (614)$ -6.41% Block 2 - Next 1,800 therms per bill Therms 162,461 0.16117 26,184 0.15083 24,504 (1,680) -6.42% Block 3 - Next 8,000 therms per bill Therms 71,277 0.13850 9,872 0.12962 9,239 (633) -6.41% Block 4 - Over 10,000 therms per bill Therms 0 0.06994 - 0.06545 - - 0.00% 285,603 45,633$ 42,706$ (2,927)$ -6.41% Total Base Revenues 51,694$ 50,681$ (1,013)$ -1.96% INT-G-22-07 R. Amen, IGC Exhibit No. 4 - Update Page 2 of 6 Intermountain Gas Company Exhibit 4 Supplemental - Proposed Rate Design and Proof of Revenue General Service Billing Current Base Rates Proposed Base Rates Difference Description Units Determinants Rates Revenues Rates Revenues $% General Service Total: Customer Charge Cust 420,849 3,998,066$ 6,311,140$ 2,313,075$ 57.86% Block 1 - First 200 therms per bill Therms 38,649,034 7,136,545 6,678,940 (457,606) -6.41% Block 2 - Next 1,800 therms per bill Therms 68,775,752 11,084,587 10,373,447 (711,140) -6.42% Block 3 - Next 8,000 therms per bill Therms 27,666,110 3,831,756 3,586,081 (245,675) -6.41% Block 4 - Over 10,000 therms per bill Therms 5,222,540 365,264 341,815 (23,449) -6.42% Total Base Revenues 26,416,218$ 27,291,423$ 875,204$ 3.31% Target Revenue 27,291,245$ Customer Charge Cust 420,211 9.50$ 3,992,005$ 15.00$ 6,303,165$ 2,311,161$ 57.90% Customer Charge - Interruptible Cust 638 9.50$ 6,061 12.50$ 7,975$ 1,914$ 31.58% Block 1 - First 200 therms per bill Therms 38,649,034 0.18465$ 7,136,544$ 0.17281$ 6,678,759$ (457,785)$ -6.42% Block 2 - Next 1,800 therms per bill Therms 68,775,752 0.16117 11,084,588 0.15083 10,373,550 (711,038) -6.42% Block 3 - Next 8,000 therms per bill Therms 27,666,110 0.13850 3,831,756 0.12962 3,585,962 (245,794) -6.42% Block 4 - Over 10,000 therms per bill Therms 5,222,540 0.06994 365,264 0.06545 341,834 (23,430) -6.42% 140,313,436 22,418,152$ 20,980,105$ (1,438,047)$ -6.42% Total Base Revenues 26,416,218$ 27,291,245$ 875,027$ 3.31% Target Revenue Difference 178$ Target Revenue Difference %0.00% INT-G-22-07 R. Amen, IGC Exhibit No. 4 - Update Page 3 of 6 Intermountain Gas Company Exhibit 4 Supplemental - Proposed Rate Design and Proof of Revenue Large Volume Billing Current Base Rates Proposed Base Rates Difference Description Units Determinants Rates Revenues Rates Revenues $% LV-1_LARGE VOLUME Customer Charge Cust 423 -$ -$ 150.00$ 63,450$ 63,450$ Demand Charge Demand 931,110 0.3000$ 279,333$ 0.3200$ 297,955$ 18,622$ 6.67% Overrun Demand Charge Demand 10,229 0.3000$ 3,069$ 0.3200 3,273$ 205$ 6.67% Current Block 1 - First 250,000 therms per bill Therms 14,130,994 0.03000$ 423,930$ Block 2 - Next 500,000 therms per bill Therms 0 0.01211$ - Block 3 - Over 750,000 therms per bill Therms 0 0.00307$ - 423,930$ Proposed Block 1 - First 35,000 therms per bill Therms 10,503,058 0.03000$ 315,092$ Block 2 - Next 35,000 therms per bill Therms 2,313,737 0.01483 34,321 Block 3 - Over 70,000 therms per bill Therms 1,314,200 0.01190 15,639 423,930$ 365,051$ (58,878)$ -13.89% Total Base Revenues 706,332$ 729,730$ 23,398$ 3.31% Target Revenue 729,730$ Target Revenue Difference - Target Revenue Difference %0.00% INT-G-22-07 R. Amen, IGC Exhibit No. 4 - Update Page 4 of 6 Intermountain Gas Company Exhibit 4 Supplemental - Proposed Rate Design and Proof of Revenue Transportation Billing Current Base Rates Proposed Base Rates Difference Description Units Determinants Rates Revenues Rates Revenues $% T-3 - TRANSPORT INTERRUPTIBLE Basic Service Charge Cust 90 -$ $0 300.00$ 27,000$ 27,000$ 0.00% Block 1 - First 100,000 therms per bill Therms 8,192,079 0.03853$ 315,641$ 0.03727$ 305,333$ (10,308)$ -3.27% Block 2 - Next 50,000 therms per bill Therms 3,576,050 0.01569 56,108 0.01518 54,276 (1,832) -3.27% Block 3 - Over 150,000 therms per bill Therms 32,521,612 0.00578 187,975 0.00559 181,836 (6,139) -3.27% All Volume 44,289,741 559,724$ 541,444$ (18,280)$ -3.27% Total Base Revenues 559,724$ 568,444$ 8,720$ 1.56% Target Revenue 568,444 Target Revenue Difference - Target Revenue Difference %0.00% INT-G-22-07 R. Amen, IGC Exhibit No. 4 - Update Page 5 of 6 Intermountain Gas Company Exhibit 4 Supplemental - Proposed Rate Design and Proof of Revenue Transportation Billing Current Base Rates Proposed Base Rates Difference Description Units Determinants Rates Revenues Rates Revenues $% T-4 - TRANSPORT FIRM Basic Service Charge Cust 1224 -$ -$ 150.00$ 183,600$ 183,600$ 0.00% Demand Charge Demand 17,860,920 0.3000$ 5,358,276$ 0.3200$ 5,715,494$ 357,218$ 6.67% Overrun Demand Charge Demand 409,210 0.3000$ 122,763$ 0.3200$ 130,947$ 8,184$ 6.67% Block 1 - First 250,000 therms per bill Therms 132,575,848 0.02395$ 3,175,192$ 0.02271$ 3,010,197$ (164,995)$ -5.20% Block 2 - Next 500,000 therms per bill Therms 103,757,423 0.00847 878,825 0.00803 833,158 (45,667) -5.20% Block 3 - Over 750,000 therms per bill Therms 101,687,336 0.00260 264,387 0.00246 250,648 (13,739) -5.20% All Volumes 338,020,607 4,318,404$ 4,094,003$ (224,401)$ -5.20% Total Base Revenues 9,799,443$ 10,124,045$ 324,602$ 3.31% Target Revenue 10,124,045$ Target Revenue Difference - Target Revenue Difference %0.00% INT-G-22-07 R. Amen, IGC Exhibit No. 4 - Update Page 6 of 6 CURRENT PROPOSED RATES RATES 5.50$ 9.00$ $0.16305 $0.12811 $0.55523 $0.55523 Intermountain Gas Company Exhibit 5 Supplemental – Bill Impact Residential RS_RESIDENTIAL SERVICE CUSTOMER CHARGE DISTRIBUTION CHARGE COG EE $0.01564 $0.01564 THERM CURRENT PROPOSED AMOUNT PERCENT $ $ $ Usage Per THERM 0 5.50 9.00 3.50 63.64% 10 12.84 15.99 3.15 24.54% 20 20.18 22.98 2.80 13.88% 30 27.52 29.97 2.45 8.91% 40 34.86 36.96 2.10 6.03% 50 42.20 43.95 1.75 4.15% (1)60 49.54 50.94 1.40 2.83% 70 56.87 57.93 1.05 1.85% 80 64.21 64.92 0.70 1.10% 90 71.55 71.91 0.36 0.50% 100 78.89 78.90 0.01 0.01% 110 86.23 85.89 (0.34)-0.40% 120 93.57 92.88 (0.69)-0.74% 130 100.91 99.87 (1.04)-1.03% 140 108.25 106.86 (1.39)-1.29% 150 115.59 113.85 (1.74)-1.51% 160 122.93 120.84 (2.09)-1.70% 170 130.27 127.83 (2.44)-1.87% 180 137.61 134.82 (2.79)-2.03% 190 144.94 141.81 (3.14)-2.17% 200 152.28 148.80 (3.49)-2.29% 210 159.62 155.79 (3.84)-2.40% 220 166.96 162.78 (4.19)-2.51% 230 174.30 169.77 (4.54)-2.60% 240 181.64 176.76 (4.89)-2.69% 250 188.98 183.75 (5.24)-2.77% 260 196.32 190.73 (5.58)-2.84% 270 203.66 197.72 (5.93)-2.91% 280 211.00 204.71 (6.28)-2.98% 290 218.34 211.70 (6.63)-3.04% 300 225.68 218.69 (6.98)-3.09% (1)Rs_Residential Service average monthly usage DIFFERENCE INT-G-22-07 R. Amen, IGC Exhibit No. 5 - Update Page 1 of 8 Intermountain Gas Company Exhibit 5 Supplemental – Bill Impact Residential IS-R_RESIDENTIAL INTERRUPTIBLE SNOWMELT SERVICE CURRENT PROPOSED RATES RATES CUSTOMER CHARGE 5.50$ 8.00$ DISTRIBUTION CHARGE $0.16305 $0.12811 COG $0.57313 $0.57313 EE $0.00000 $0.00000 DIFFERENCE THERM CURRENT PROPOSED AMOUNT PERCENT $ $ $ Usage Per THERM 0 5.50 8.00 2.50 45.45% 10 12.86 15.01 2.15 16.72% 20 20.22 22.02 1.80 8.91% 30 27.59 29.04 1.45 5.26% 40 34.95 36.05 1.10 3.15% 50 42.31 43.06 0.75 1.78% 60 49.67 50.07 0.40 0.81% 70 57.03 57.09 0.05 0.10% 80 64.39 64.10 (0.30)-0.46% 90 71.76 71.11 (0.64)-0.90% 100 79.12 78.12 (0.99)-1.26% 110 86.48 85.14 (1.34)-1.55% 120 93.84 92.15 (1.69)-1.80% 130 101.20 99.16 (2.04)-2.02% 140 108.57 106.17 (2.39)-2.20% 150 115.93 113.19 (2.74)-2.36% 160 123.29 120.20 (3.09)-2.51% (1)170 130.65 127.21 (3.44)-2.63% 180 138.01 134.22 (3.79)-2.75% 190 145.37 141.24 (4.14)-2.85% 200 152.74 148.25 (4.49)-2.94% 210 160.10 155.26 (4.84)-3.02% 220 167.46 162.27 (5.19)-3.10% 230 174.82 169.29 (5.54)-3.17% 240 182.18 176.30 (5.89)-3.23% 250 189.55 183.31 (6.24)-3.29% 260 196.91 190.32 (6.58)-3.34% 270 204.27 197.33 (6.93)-3.39% 280 211.63 204.35 (7.28)-3.44% 290 218.99 211.36 (7.63)-3.49% 300 226.35 218.37 (7.98)-3.53% (1)Is-R_Residential Interruptible Snowmelt Service average monthly usage INT-G-22-07 R. Amen, IGC Exhibit No. 5 - Update Page 2 of 8 CURRENT PROPOSED RATES RATES Intermountain Gas Company Exhibit 5 Supplemental – Bill Impact General Service GS-1_GENERAL SERVICE GS-1 IRRIGATION CUSTOMERS CUSTOMER CHARGE 9.50$ $15.00 Block 1 200 $0.18465 $0.17281 Block 2 1800 $0.16117 $0.15083 Block 3 8000 $0.13850 $0.12962 Block 4 10000 $0.06994 $0.06545 COG $0.56651 $0.56651 EE $0.00320 $0.00320 DIFFERENCE THERM CURRENT PROPOSED AMOUNT PERCENT $ $ $ Usage Per THERM - 9.50 15.00 5.50 57.89% 100 84.94 89.25 4.32 5.08% 200 160.37 163.50 3.13 1.95% (1)300 233.46 235.56 2.10 0.90% 400 306.55 307.61 1.06 0.35% 500 379.64 379.67 0.03 0.01% 600 452.72 451.72 (1.00)-0.22% (2)700 525.81 523.77 (2.04)-0.39% 800 598.90 595.83 (3.07)-0.51% 900 671.99 667.88 (4.11)-0.61% 1000 745.08 739.94 (5.14)-0.69% 1100 818.16 811.99 (6.17)-0.75% 1200 891.25 884.04 (7.21)-0.81% 1300 964.34 956.10 (8.24)-0.85% 1400 1,037.43 1,028.15 (9.28)-0.89% 1500 1,110.52 1,100.21 (10.31)-0.93% 1600 1,183.60 1,172.26 (11.34)-0.96% 1700 1,256.69 1,244.31 (12.38)-0.98% 1800 1,329.78 1,316.37 (13.41)-1.01% 1900 1,402.87 1,388.42 (14.45)-1.03% 2000 1,475.96 1,460.48 (15.48)-1.05% 2100 1,546.78 1,530.41 (16.37)-1.06% 2200 1,617.60 1,600.34 (17.26)-1.07% 2300 1,688.42 1,670.28 (18.14)-1.07% 2400 1,759.24 1,740.21 (19.03)-1.08% 2500 1,830.06 1,810.14 (19.92)-1.09% 2600 1,900.88 1,880.07 (20.81)-1.09% 2700 1,971.70 1,950.01 (21.70)-1.10% 2800 2,042.52 2,019.94 (22.58)-1.11% 2900 2,113.35 2,089.87 (23.47)-1.11% 3000 2,184.17 2,159.81 (24.36)-1.12% (1)GS-1 Geneneral Service average monthly usage (2)GS-1 Irrigation Service average monthly usage INT-G-22-07 R. Amen, IGC Exhibit No. 5 - Update Page 3 of 8 Intermountain Gas Company Exhibit 5 Supplemental – Bill Impact General Service GS-1 - COMPRESSED NATURAL GAS CURRENT PROPOSED RATES RATES CUSTOMER CHARGE 9.50$ 15.00$ Block 1 10,000 $0.13850 $0.12962 Block 2 10,000 $0.06994 $0.06545 COG $0.56651 $0.56651 EE $0.00000 $0.00000 DIFFERENCE THERM CURRENT PROPOSED AMOUNT PERCENT $ $ $ Usage Per THERM - 9.50 15.00 5.50 57.89% 1000 714.51 711.13 (3.38)-0.47% 2000 1,419.52 1,407.26 (12.26)-0.86% 3000 2,124.53 2,103.39 (21.14)-1.00% 4000 2,829.54 2,799.52 (30.02)-1.06% 5000 3,534.55 3,495.65 (38.90)-1.10% 6000 4,239.56 4,191.78 (47.78)-1.13% 7000 4,944.57 4,887.91 (56.66)-1.15% 8000 5,649.58 5,584.04 (65.54)-1.16% 9000 6,354.59 6,280.17 (74.42)-1.17% 10000 7,059.60 6,976.30 (83.30)-1.18% 11000 7,696.05 7,608.26 (87.79)-1.14% 12000 8,332.50 8,240.22 (92.28)-1.11% 13000 8,968.95 8,872.18 (96.77)-1.08% 14000 9,605.40 9,504.14 (101.26)-1.05% 15000 10,241.85 10,136.10 (105.75)-1.03% 16000 10,878.30 10,768.06 (110.24)-1.01% 17000 11,514.75 11,400.02 (114.73)-1.00% 18000 12,151.20 12,031.98 (119.22)-0.98% 19000 12,787.65 12,663.94 (123.71)-0.97% 20000 13,424.10 13,295.90 (128.20)-0.95% 21000 14,060.55 13,927.86 (132.69)-0.94% 22000 14,697.00 14,559.82 (137.18)-0.93% 23000 15,333.45 15,191.78 (141.67)-0.92% 24000 15,969.90 15,823.74 (146.16)-0.92% 25000 16,606.35 16,455.70 (150.65)-0.91% 26000 17,242.80 17,087.66 (155.14)-0.90% 27000 17,879.25 17,719.62 (159.63)-0.89% 28000 18,515.70 18,351.58 (164.12)-0.89% 29000 19,152.15 18,983.54 (168.61)-0.88% 30000 19,788.60 19,615.50 (173.10)-0.87% INT-G-22-07 R. Amen, IGC Exhibit No. 5 - Update Page 4 of 8 Intermountain Gas Company Exhibit 5 Supplemental – Bill Impact General Service IS-C - SMALL COMMERCIAL INTERRUPTIBLE SNOWMELT SERVICE CURRENT PROPOSED RATES RATES CUSTOMER CHARGE 9.50$ 12.50$ Block 1 200 $0.18465 $0.17281 Block 2 1800 $0.16117 $0.15083 Block 3 8000 $0.13850 $0.12962 Block 4 10000 $0.06994 $0.06545 COG $0.56651 $0.56651 EE $0.00000 $0.00000 DIFFERENCE THERM CURRENT PROPOSED AMOUNT PERCENT $ $ $ Usage Per THERM - 9.50 12.50 3.00 31.58% 100 84.62 86.43 1.82 2.15% 200 159.73 160.36 0.63 0.40% 300 232.50 232.10 (0.40)-0.17% (1)400 305.27 303.83 (1.44)-0.47% 500 378.04 375.57 (2.47)-0.65% 600 450.80 447.30 (3.50)-0.78% 700 523.57 519.03 (4.54)-0.87% 800 596.34 590.77 (5.57)-0.93% 900 669.11 662.50 (6.61)-0.99% 1000 741.88 734.24 (7.64)-1.03% 1100 814.64 805.97 (8.67)-1.06% 1200 887.41 877.70 (9.71)-1.09% 1300 960.18 949.44 (10.74)-1.12% 1400 1,032.95 1,021.17 (11.78)-1.14% 1500 1,105.72 1,092.91 (12.81)-1.16% 1600 1,178.48 1,164.64 (13.84)-1.17% 1700 1,251.25 1,236.37 (14.88)-1.19% 1800 1,324.02 1,308.11 (15.91)-1.20% 1900 1,396.79 1,379.84 (16.95)-1.21% 2000 1,469.56 1,451.58 (17.98)-1.22% 2100 1,540.06 1,521.19 (18.87)-1.23% 2200 1,610.56 1,590.80 (19.76)-1.23% 2300 1,681.06 1,660.42 (20.64)-1.23% 2400 1,751.56 1,730.03 (21.53)-1.23% 2500 1,822.06 1,799.64 (22.42)-1.23% 2600 1,892.56 1,869.25 (23.31)-1.23% 2700 1,963.06 1,938.87 (24.20)-1.23% 2800 2,033.56 2,008.48 (25.08)-1.23% 2900 2,104.07 2,078.09 (25.97)-1.23% 3000 2,174.57 2,147.71 (26.86)-1.24% (1)Is-C - Small Commercial Interruptible Snowmelt Service average monthly usage INT-G-22-07 R. Amen, IGC Exhibit No. 5 - Update Page 5 of 8 Current Rates Current Block Proposed Rates Proposed Block -$ 150.0$ 0.30000$ 0.32000$ 0.03000$ 250,000 0.03000$ 35,000 0.01211$ 500,000 0.01483$ 35,000 0.00307$ 750,000 0.01190$ 70,000 Intermountain Gas Company Exhibit 5 Supplemental – Bill Impact Large Volume LV-1_LARGE VOLUME Customer Charge Demand Charge Block 1 Block 2 Block 3 COG 0.51173$ 0.51173$ Customer Usage Scenario Monthly Average MDFQ Current Monthly Bill Proposed Monthly Bill Difference $ Difference % High Use / High Demand 40,000 6,000 23,469$ 23,663$ 194$ 0.83% High Use / Low Demand 40,000 2,000 22,269$ 22,383$ 114$ 0.51% Avg. Use / Avg. Demand 30,000 3,000 17,152$ 17,362$ 210$ 1.22% Low Use / High Demand 20,000 3,000 11,735$ 11,945$ 210$ 1.79% Low Use / Low Demand 20,000 1,000 11,135$ 11,305$ 170$ 1.53% INT-G-22-07 R. Amen, IGC Exhibit No. 5 - Update Page 6 of 8 Intermountain Gas Company Exhibit 5 Supplemental – Bill Impact Transportation T-3 - TRANSPORT INTERRUPTIBLE Current Block Current Proposed Customer Charge -$ 300$ Demand Charge -$ -$ Block 1 100,000 0.03853$ 0.03727$ Block 2 50,000 0.01569$ 0.01518$ Block 3 150,000 0.00578$ 0.00559$ COG (0.00082)$ (0.00082)$ Monthly Average Usage (Therm)MDFQ (Therm)Current Monthly Bill Proposed Monthly Bill Difference $ Difference % - - -$ 300$ 300$ 0.00% 100,000 - 3,771$ 3,945$ 174$ 4.61% 200,000 - 4,763$ 4,902$ 139$ 2.92% 300,000 - 5,259$ 5,379$ 120$ 2.28% 400,000 - 5,755$ 5,856$ 101$ 1.76% 500,000 - 6,251$ 6,333$ 82$ 1.31% 600,000 - 6,747$ 6,810$ 63$ 0.93% 700,000 - 7,243$ 7,287$ 44$ 0.61% 800,000 - 7,739$ 7,764$ 25$ 0.32% 900,000 - 8,235$ 8,241$ 6$ 0.07% 1,000,000 - 8,731$ 8,718$ (13)$ -0.15% 1,100,000 - 9,227$ 9,195$ (32)$ -0.35% 1,200,000 - 9,723$ 9,672$ (51)$ -0.52% 1,300,000 - 10,219$ 10,149$ (70)$ -0.69% 1,400,000 - 10,715$ 10,626$ (89)$ -0.83% 1,500,000 - 11,211$ 11,103$ (108)$ -0.96% 1,600,000 - 11,707$ 11,580$ (127)$ -1.08% 1,700,000 - 12,203$ 12,057$ (146)$ -1.20% 1,800,000 - 12,699$ 12,534$ (165)$ -1.30% 1,900,000 - 13,195$ 13,011$ (184)$ -1.39% 2,000,000 - 13,691$ 13,488$ (203)$ -1.48% INT-G-22-07 R. Amen, IGC Exhibit No. 5 - Update Page 7 of 8 Current Block Current Rates Proposed Rates -$ 150.00$ 0.30000$ 0.32000$ 250,000 0.02395$ 0.02271$ 500,000 0.00847$ 0.00803$ 750,000 0.00260$ 0.00246$ Intermountain Gas Company Exhibit 5 Supplemental – Bill Impact Transportation T-4 - TRANSPORT FIRM Customer Charge Demand Charge Block 1 Block 2 Block 3 COG (0.01968)$ (0.01968)$ Customer Usage Scenario Monthly Average Usage (Therm) MDFQ (Therm)Current Monthly Bill Proposed Monthly Bill Difference $ Difference % High Use / High Demand 1,000,000 150,000 52,921$ 55,506$ 2,585$ 4.88% High Use / Low Demand 1,000,000 50,000 24,889$ 25,474$ 585$ 2.35% Avg. Use / Avg. Demand 300,000 30,000 14,821$ 15,239$ 418$ 2.82% Low Use / High Demand 50,000 7,500 3,300$ 3,538$ 238$ 7.21% Low Use / Low Demand 50,000 2,500 1,898$ 2,036$ 138$ 7.27% INT-G-22-07 R. Amen, IGC Exhibit No. 5 - Update Page 8 of 8