HomeMy WebLinkAbout20150601Miller Exhibit 14.pdf
DAVID J. MEYER VICE PRESIDENT AND CHIEF COUNSEL FOR
REGULATORY & GOVERNMENTAL AFFAIRS AVISTA CORPORATION P.O. BOX 3727 1411 EAST MISSION AVENUE SPOKANE, WASHINGTON 99220-3727
TELEPHONE: (509) 495-4316 FACSIMILE: (509) 495-8851 DAVID.MEYER@AVISTACORP.COM
BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION
IN THE MATTER OF THE APPLICATION ) OF AVISTA CORPORATION FOR THE ) CASE NO. AVU-G-15-01
AUTHORITY TO INCREASE ITS RATES ) AND CHARGES FOR ELECTRIC AND )
NATURAL GAS SERVICE TO ELECTRIC ) Exhibit No. 14 AND NATURAL GAS CUSTOMERS IN THE ) STATE OF IDAHO ) JOSEPH D. MILLER
)
FOR AVISTA CORPORATION
(NATURAL GAS)
NATURAL GAS COST OF SERVICE STUDY 1
A cost of service study is an engineering-economic study, which apportions the revenue, 2
expenses, and rate base associated with providing natural gas service to designated groups of 3
customers. It indicates whether the revenue provided by customers recovers the cost to serve those 4
customers. The study results are used as a guide in determining the appropriate rate spread among 5
the groups of customers. 6
There are three basic steps involved in a cost of service study: functionalization, 7
classification, and allocation. See the flow chart below. 8
First, the expenses and rate base associated with the natural gas system under study are 9
assigned to functional categories. The uniform system of accounts provides the basic segregation 10
into production, underground storage, and distribution. Traditionally customer accounting, 11
customer information, and sales expenses are included in the distribution function and 12
administrative and general expenses and general plant rate base are allocated to all functions. This 13
study includes a separate functional category for common costs. Administrative and general costs 14
that cannot be directly assigned to the other functions have been placed in this category. 15
Second, the expenses and rate base items are classified into three primary cost components: 16
demand, commodity and customer related. Demand (capacity) related costs are allocated to rate 17
schedules on the basis of each schedule’s contribution to system peak demand. Commodity 18
(energy) related costs are allocated based on each rate schedule’s share of commodity 19
consumption. Customer related items are allocated to rate schedules based on the number of 20
customers within each schedule. The number of customers may be weighted by appropriate 21
factors such as relative cost of metering equipment. In addition to these three cost components, 22
any revenue related expense is allocated based on the proportion of revenues by rate schedule. 23
Exhibit No. 14 Case No. AVU-G-15-01 J. Miller, Avista
Schedule 1, p. 1 of 9
Pro Forma Results of Operations by Customer Group
Underground Storage
Production / Purchased Gas Cost
Distribution and Customer Relations
Energy / Commodity Related
Customer RelatedDemand / Capacity Related
Residential
101
Small General111/112 Interruptible131/132
Transportation146
Pro Forma
Results of Operations
Functionalization
Common
Classification
Allocation
Direct AssignmentThroughputSales Therms
Firm Therms Direct AssignmentCoincident PeakNon-Coincident Peak
Direct AssignmentNumber of CustomersWeighted Number of
Customers
The final step is allocation of the costs to the various rate schedules utilizing the allocation 1
factors selected for each specific cost item. These factors are derived from usage and customer 2
information associated with the test period results of operations. 3
Exhibit No. 14 Case No. AVU-G-15-01 J. Miller, Avista
Schedule 1, p. 2 of 9
BASE CASE COST OF SERVICE STUDY 1
Production - Purchased Gas Costs 2
The Company has no natural gas production facilities to serve its retail customers. In 3
addition, the revenue and expenses associated with the gas purchased to serve sales customers and 4
pipeline transportation to get it to our system have been removed from the Company’s filing. The 5
natural gas costs included in the production function include the expenses of the gas supply 6
department. 7
The expenses of the gas supply department recorded in account 813 are classified as 8
commodity related costs. The gas scheduling process includes transportation customers, so 9
estimated scheduling dispatch labor expenses are allocated by throughput. The remaining gas 10
supply department expenses are allocated 95% by sales volumes and 5% on total throughput. 11
Underground Storage 12
Underground storage rate base, operating and maintenance expenses are classified as 13
commodity related and allocated to customer groups by winter throughput. This approach was 14
proposed by commission Staff and accepted by the Idaho Public Utilities Commission in Case No. 15
AVU-G-04-01. 16
Distribution Facilities Classification (Peak and Average) 17
Distribution mains and regulator station equipment (both general use and city gate stations) 18
are classified Demand and Commodity using the peak and average ratio for the distribution 19
system. Peak demand is defined as the average of the five-day sustained peaks from the most 20
recent three years. Average daily load is calculated by dividing annual throughput by 365 (days in 21
the year). The average daily load is divided by peak load to arrive at the system load factor of 22
44.92%. This proportion is classified as commodity related. The remaining 55.08% is classified 23
as demand related. Meters, services and industrial measuring & regulating equipment are 24
Exhibit No. 14 Case No. AVU-G-15-01 J. Miller, Avista
Schedule 1, p. 3 of 9
classified as customer related distribution plant. Distribution operating and maintenance expenses 1
are classified (and allocated) in relation to the plant accounts they are associated with. 2
Customer Relations Distribution Cost Classification 3
Customer service, customer information and sales expenses are the core of the customer 4
relations functional unit which is included with the distribution cost category. For the most part 5
these costs are classified as customer related. Exceptions include uncollectible accounts expense, 6
which is considered separately as a revenue conversion item, and any Demand Side Management 7
amortization expense recorded in Account 908. Any demand side management investment costs 8
and amortization expense included in base rates would be included with the distribution function 9
and classified to demand and commodity by the peak and average ratio. At this point in time, the 10
Company’s demand side management investments in base rates have been fully amortized. All 11
current demand side management costs are managed through the Schedule 191 Energy Efficiency 12
Rider Adjustment balancing account which is not included in this cost study. 13
Distribution Cost Allocation 14
Demand related distribution costs are allocated to customer groups (rate schedules) by each 15
groups’ contribution to the three year average five-day sustained peak. Commodity related 16
distribution costs are allocated to customer groups by annual throughput. Distribution main 17
investment has been segregated into large and small mains. Small mains are defined as less than 18
four inches, with large mains being four inches or greater. The small main costs use the same 19
demand and commodity data, but large usage customers (Schedules 131, 132, and 146) that 20
connect to large system mains have been excluded from the allocations. 21
Most customer related costs are allocated by the annualized number of customers billed 22
during the test period. Meter investment costs are allocated using the number of customers 23
weighted by the relative current cost of meters in service at December 31, 2014. Services 24
Exhibit No. 14 Case No. AVU-G-15-01 J. Miller, Avista
Schedule 1, p. 4 of 9
investment costs are allocated using the number of customers weighted by the relative current cost 1
of typical service installations. Industrial measuring and regulating equipment investment costs 2
are allocated by number of turbine meters which effectively excludes small usage customers. 3
Administrative and General Costs 4
General and intangible rate base items are allocated by the Company’s 4-factor allocator. 5
Administrative and general expenses are segregated into plant related, labor related, revenue 6
related and other. The plant related items are allocated based on total plant in service. Labor 7
related items are allocated by operating and maintenance labor expense. Revenue related items are 8
allocated by pro forma revenue. Other administrative and general expenses are allocated by the 9
Company’s 4-factor. Whenever costs are allocated by sums of other items within the study, 10
classifications are imputed from the relationship embedded in the summed items. 11
Special Contract Customer Revenue 12
Two special contract customers receive transportation service from the Company. Rates 13
for these customers were individually negotiated to cover any incremental costs together with 14
some contribution to margin. The rates for these customers are not being adjusted in this case. 15
The revenue from these special contract customers has been segregated from general rate revenue 16
and allocated back to all the other rate classes by relative rate base. In treating these revenues like 17
other operating revenues their system contribution reduces costs for all rate schedules. 18
Revenue Conversion Items 19
In this study uncollectible accounts and commission fees have been classified as revenue 20
related and are allocated by pro forma revenue. These items vary with revenue and are included in 21
the calculation of the revenue conversion factor. Income tax expense items are allocated to 22
schedules by net income before income tax less interest expense. 23
Exhibit No. 14 Case No. AVU-G-15-01 J. Miller, Avista
Schedule 1, p. 5 of 9
For the functional summaries on pages 2 and 3 of the cost of service study, these items are 1
assigned to the component cost categories. The revenue related expense items have been reduced 2
to a percent of all other costs and loaded onto each cost category by that ratio. Similarly, income 3
tax items have been assigned to cost categories by relative rate base (as is net income). 4
The following matrix outlines the methodology applied in the Company Base Case natural 5
gas cost of service study. 6
Exhibit No. 14 Case No. AVU-G-15-01 J. Miller, Avista
Schedule 1, p. 6 of 9
IPUC Case No. AVU-G-15-01 Methodology Matrix
Avista Utilities Idaho Jurisdiction
Natural Gas Cost of Service Methodology
Line Account Functional Category Classification Allocation
Underground Storage Plant1 350 - 357 Underground Storage Underground Storage Commodity E08 Winter throughput
Distribution Plant
2 374 Land Distribution Demand/Commodity/Customer from Other Dist Plant S05 Sum of accounts 376-385
3 375 Structures Distribution Demand/Commodity/Customer from Other Dist Plant S05 Sum of accounts 376-385
4 376(S) Small Mains Distribution Demand/Commodity by Peak & Average D02/E06 Coincident peak, annual therms (both excl lg use cust)
5 376(L) Large Mains Distribution Demand/Commodity by Peak & Average D01/E01 Coincident peak (all), annual throughput (all)
6 378 M&R General Distribution Demand/Commodity by Peak & Average D01/E01 Coincident peak (all), annual throughput (all)
7 379 M&R City Gate Distribution Demand/Commodity by Peak & Average D01/E01 Coincident peak (all), annual throughput (all)
8 380 Services Distribution Customer C02, Customers wei hted b current t ical service cos9 381 Meters Distribution Customer C03, Customers wei hted b avera e current meter cos10 385 Industrial M&R Distribution Customer C06, Lar e use customers 11 387 Other Distribution Demand/Commodity/Customer from Other Dist Plant S05 Sum of accounts 376-385
General Plant
12 389-399 All General Plant Common Demand/Commodity/Customer 4-Factor O&M less resource & labor, O&M labor, net direct lant, & customers
Intangible Plant
13 303 Misc Intangible Plant Distribution Demand/Commodity/Customer from Dist Plant S15 Sum of Distribution Plant in Service
14 303 Computer Software Common Demand/Commodity/Customer 4-Factor O&M less resource & labor, O&M labor, net direct lant, & customers
Reserve for Depreciation
15 Underground Storage Underground Storage Commodity same as related plant Allocations linked to related plant accounts16 Distribution Distribution Demand/Commodity/Customer same as related plant Allocations linked to related plant accounts17 General Common Demand/Commodity/Customer same as related plant Allocations linked to related plant accounts18 Intangible Distribution/Common Demand/Commodity/Customer same as related plant Allocations linked to related plant accounts
Other Rate Base
19 Accumulated Deferred FIT All Demand/Commodity/Customer from Plant in Service S17 Sum of Total Plant in Service
20 Constuction Advances Distribution Customer C10 Residential only
21 Gas Inventory Underground Storage Commodity from Underground Storage Plant S14 Sum of Underground Storage Plant in Service
22 Gain on Sale of Office Bldg Common Demand/Commodity/Customer from UG & D Plant S03 Sum of Underground Storage and Distribution Plant in Service
23 DSM Investment Distribution Demand/Commodity by Peak & Average D01/E01 Coincident peak (all), annual throughput (all)
Purchased Gas Expenses
24 804 Purchased Gas Cost Production Removed all Purchased Gas Costs from Filing N/A25 813 Other Gas Expenses Production Commodity E01/E04 Annual Throughput / Annual Sales Therms
Underground Storage O&M26 814 - 837 Underground Storage Exp Underground Storage Commodity E08 Winter throughput
Exhibit No. 14
Case No. AVU-G-15-01
J. Miller, Avista
Schedule 1, p. 7 of 9
IPUC Case No. AVU-G-15-01 Methodology Matrix
Avista Utilities Idaho Jurisdiction
Natural Gas Cost of Service Methodology
Line Account Functional Category Classification Allocation
Distribution O&M1 870 OP Super & Engineering Distribution Demand/Commodity/Customer from Dist Plant S15 Sum of Distribution Plant in Service2 871 Load Dispatching Distribution Commodity E01 Annual throughput3 874 Mains & Services Distribution Demand/Commodity/Customer from related plant S06 Sum of Mains and Services Plant in Service
4 875 M&R Station - General Distribution Demand/Commodity from related plant S08 Sum of Meas & Reg Station - General Plant in Service
5 876 M&R Station - Industrial Distribution Customer from related plant S19 Sum of Meas & Reg Station - Industrial Plant in Service
6 877 M&R Station - City Gate Distribution Demand/Commodity from related plant S09 Sum of Meas & Reg Station - City Gate Plant in Service
7 878 Meter & House Regulator Distribution Customer from related plant S07 Sum of Meter and Installation Plant in Service
8 879 Customer Installations Distribution Customer C05, Customers wei hted b avera e current meter cos9 880 Other OP Expenses Distribution Demand/Commodity/Customer from other dist expense S04 Sum of Accounts 870 - 879 and 881 - 894
10 881 Rents Distribution Demand/Commodity/Customer from other dist expense S04 Sum of Accounts 870 - 879 and 881 - 894
11 885 MT Super & Engineering Distribution Demand/Commodity/Customer from Dist Plant S15 Sum of Distribution Plant in Service12 886 MT of Structures Distribution Demand/Commodity/Customer from Other Dist Plant S05 Sum of accounts 376-38513 887 MT of Mains Distribution Demand/Commodity from related plant S21 Sum of Distribution Mains Plant in Service14 889 MT of M&R General Distribution Demand/Commodity from related plant S08 Sum of Meas & Reg Station - General Plant in Service15 890 MT of M&R Industrial Distribution Customer from related plant S19 Sum of Meas & Reg Station - Industrial Plant in Service
16 891 MT of M&R City Gate Distribution Demand/Commodity from related plant S09 Sum of Meas & Reg Station - City Gate Plant in Service
17 892 MT of Services Distribution Customer from related plant S20 Sum of Services Plant in Services
18 893 MT of Meters & Hs Reg Distribution Customer from related plant S07 Sum of Meter and Installation Plant in Service
19 894 MT of Other Equipment Distribution Demand/Commodity/Customer from Dist Plant S15 Sum of Distribution Plant in Service
Customer Accounting Expenses
20 901 Supervision Customer Relations Customer C01 All customers (unweighted)
21 902 Meter Reading Customer Relations Customer C01 All customers (unweighted)22 903 Customer Records & Collections Customer Relations Customer C01 All customers (unweighted)23 904 Uncollectible Accounts Revenue Conversion Revenue R03 Retail Sales Revenue24 905 Misc Cust Accounts Customer Relations Customer C01 All customers (unweighted)
Customer Service & Info Expenses
25 907 Supervision Customer Relations Customer C01 All customers (unweighted)
26 908 Customer Assistance Customer Relations Customer C01 All customers (unweighted)
27 908 DSM Amortization Distribution Demand/Commodity by Peak & Average D01/E01 Coincident peak (all), annual throughput (all)
28 909 Advertising Customer Relations Customer C01 All customers (unweighted)
29 910 Misc Cust Service & Info Customer Relations Customer C01 All customers (unweighted)
Sales Expenses
30 911 - 916 Sales Expenses Customer Relations Customer C01 All customers (unweighted)
Exhibit No. 14
Case No. AVU-G-15-01
J. Miller, Avista
Schedule 1, p. 8 of 9
IPUC Case No. AVU-G-15-01 Methodology Matrix
Avista Utilities Idaho Jurisdiction
Natural Gas Cost of Service Methodology
Line Account Functional Category Classification Allocation
Admin & General Expenses1 920 Salaries Common Demand/Commodity/Customer from Other O&M 4-Factor O&M less resource & labor, O&M labor, net direct lant, & customers2 921 Office Supplies Common Demand/Commodity/Customer from Other O&M 4-Factor O&M less resource & labor, O&M labor, net direct lant, & customers3 922 Admin Expense Transferred - Credit Common Demand/Commodity/Customer from Other O&M 4-Factor O&M less resource & labor, O&M labor, net direct lant, & customers
4 923 Outside Services Common Demand/Commodity/Customer from Other O&M 4-Factor O&M less resource & labor, O&M labor, net direct lant, & customers
5 924 Property Insurance Common Demand/Commodity/Customer from Plant in Service S17 Sum of Total Plant in Service
6 925 Injuries & Damages Common Demand/Commodity/Customer from Other O&M 4-Factor O&M less resource & labor, O&M labor, net direct lant, & customers
7 926 Pensions & Benefits Common Demand/Commodity/Customer from Labpr O&M S13 O&M Labor Expense
8 927 Franchise Requirements Common Demand/Commodity/Customer from Other O&M 4-Factor O&M less resource & labor, O&M labor, net direct lant, & customers9 928 Regulatory Commision Common Demand/Commodity/Customer from Other O&M 4-Factor O&M less resource & labor, O&M labor, net direct lant, & customers10 928 Commission Fees Revenue Conversion Revenue R01 Retail Sales Revenue
11 930 Miscellaneous General Common Demand/Commodity/Customer from Other O&M 4-Factor O&M less resource & labor, O&M labor, net direct lant, & customers12 931 Rents Common Demand/Commodity/Customer from Other O&M 4-Factor O&M less resource & labor, O&M labor, net direct lant, & customers13 935 MT of General Plant Common Demand/Commodity/Customer from Plant in Service S17 Sum of Total Plant in Service
Depreciation Expense
14 Underground Storage Underground Storage Commodity same as related plant Allocations linked to related plant accounts
15 Distribution Distribution Demand/Commodity/Customer same as related plant Allocations linked to related plant accounts
16 General Common Demand/Commodity/Customer same as related plant Allocations linked to related plant accounts
17 Intangible Distribution/Common Demand/Commodity/Customer same as related plant Allocations linked to related plant accounts
Taxes
18 Property Tax All Demand/Commodity/Customer from related plant S14/S15/S16 Sum of UG Plant/Sum of Dist Plant/Sum of Gen Plant
19 Miscellaneous Dist Tax Distribution Demand/Commodity/Customer from Dist Plant S15 Sum of Distribution Plant in Service20 State Income Tax Revenue Conversion Revenue R02 Net Income before Taxes less Interest Expense21 Federal Income Tax Revenue Conversion Revenue R02 Net Income before Taxes less Interest Expense22 Deferred FIT Revenue Conversion Revenue R02 Net Income before Taxes less Interest Expense23 ITC Revenue Conversion Revenue R02 Net Income before Taxes less Interest Expense
Operating Revenues
24 Revenue from Rates Revenue Revenue Pro Forma Revenue per Revenue Study
25 Special Contract Revenue All Demand/Commodity/Customer from Rate Base S01 Sum of Rate Base
26 Off System Sales Production Commodity from PGA Tracker E04 Sales Therms
27 Miscellaneous Service Revenue Distribution Demand/Commodity/Customer from Dist Plant S15 Sum of Distribution Plant in Service
28 Rent From Gas Property All Demand/Commodity/Customer from Rate Base S01 Sum of Rate Base
29 Other Gas Revenue Underground Storage Commodity from Underground Storage Plant S14 Sum of Underground Storage Plant in Service
Exhibit No. 14
Case No. AVU-G-15-01
J. Miller, Avista
Schedule 1, p. 9 of 9
AVISTA UTILITIES Natural Gas Utility
Company Base Case Cost of Service General Summary Idaho Jurisdiction
For the Year Ended December 31, 2014
(b) (c) (d) (e) (f) (g) (h) (j) (k)
Residential Large Firm Interrupt Transport
System Service Service Service Service
Line Description Total Sch 101 Sch 111 Sch 131 Sch 146
Plant In Service
1 Production Plant
2 Underground Storage Plant 11,020,000 8,033,154 2,716,189 34,278 236,379
3 Distribution Plant 185,053,000 151,801,662 31,358,997 401,267 1,491,074
4 Intangible Plant 4,645,000 4,063,089 545,334 6,149 30,428
5 General Plant 28,535,000 25,186,558 3,133,521 34,261 180,659
6 Total Plant In Service 229,253,000 189,084,463 37,754,041 475,956 1,938,540
Accum Depreciation
7 Production Plant
8 Underground Storage Plant (4,263,000) (3,107,562) (1,050,736) (13,260) (91,441)
9 Distribution Plant (64,859,000) (54,366,703) (9,894,452) (125,986) (471,859)
10 Intangible Plant (1,885,000) (1,663,805) (206,998) (2,263) (11,934)
11 General Plant (8,192,000) (7,230,709) (899,590) (9,836) (51,865)
12 Total Accumulated Depreciation (79,199,000) (66,368,779) (12,051,776) (151,346) (627,099)
13 Net Plant 150,054,000 122,715,684 25,702,265 324,610 1,311,441
14 Accumlulated Deferred FIT (32,216,000) (26,571,277) (5,305,423) (66,884) (272,415)
15 Miscellaneous Rate Base 9,660,000 7,373,459 2,098,858 26,480 161,203
16 Total Rate Base 127,498,000 103,517,866 22,495,700 284,206 1,200,229
17 Revenue From Retail Rates 36,173,000 29,139,824 6,625,127 67,596 340,452
18 Other Operating Revenues 222,000 180,330 39,100 494 2,076
19 Total Revenues 36,395,000 29,320,154 6,664,227 68,091 342,529
Operating Expenses
20 Purchased Gas Costs 335,000 234,497 96,586 1,391 2,527
21 Underground Storage Expenses 368,000 268,258 90,704 1,145 7,894
22 Distribution Expenses 6,043,000 5,082,658 884,970 8,880 66,492
23 Customer Accounting Expenses 2,228,000 2,165,164 61,228 266 1,341
24 Customer Information Expenses 365,000 358,404 6,567 5 24
25 Sales Expenses (0) (0) (0) (0) (0)
26 Admin & General Expenses 5,621,000 4,902,434 672,916 7,589 38,061
27 Total O&M Expenses 14,960,000 13,011,415 1,812,972 19,276 116,337
28 Taxes Other Than Income Taxes 1,937,000 1,580,453 335,406 4,288 16,853
29 Depreciation Expense
30 Underground Storage Plant Depr 182,000 132,671 44,859 566 3,904
31 Distribution Plant Depreciation 4,628,000 3,801,615 779,647 9,911 36,826
32 General Plant Depreciation 1,987,000 1,753,835 218,199 2,386 12,580
33 Amortization of Intangible Plant 1,113,000 907,465 193,283 2,471 9,781
34 Total Depr & Amort Expense 7,910,000 6,595,586 1,235,989 15,334 63,091
35 Income Tax 3,843,000 2,521,115 1,258,113 10,145 53,627
36 Total Operating Expenses 28,650,000 23,708,570 4,642,479 49,043 249,908
37 Net Income 7,745,000 5,611,584 2,021,748 19,048 92,620
38 Rate of Return 6.07% 5.42% 8.99% 6.70% 7.72%
39 Return Ratio 1.00 0.89 1.48 1.10 1.27
40 Interest Expense 3,404,000 2,763,767 600,601 7,588 32,044
Exhibit No. 14
Case No. AVU-G-15-01
J. Miller, Avista
Schedule 2, p. 1 of 4
AVISTA UTILITIES Natural Gas Utility
Company Base Case Summary by Function with Margin Analysis Idaho Jurisdiction
For the Year Ended December 31, 2014
(b) (c) (d) (e) (f) (g) (h) (j) (k)
Residential Large Firm Interrupt Transport
System Service Service Service Service
Line Description Total Sch 101 Sch 111 Sch 131 Sch 146
Functional Cost Components at Current Rates
1 Production 337,031 235,918 97,171 1,399 2,542
2 Underground Storage 1,719,472 1,107,975 562,773 5,581 43,144
3 Distribution 23,628,251 18,839,423 4,525,714 45,395 217,719
4 Common 10,488,246 8,956,508 1,439,469 15,221 77,048
5 Total Current Rate Revenue 36,173,000 29,139,824 6,625,127 67,596 340,452
6 Exclude Cost of Gas w / Revenue Exp. 0 0 0 0 0
7 Total Margin Revenue at Current Rates 36,173,000 29,139,824 6,625,127 67,596 340,452
Margin per Therm at Current Rates
8 Production $0.00413 $0.00423 $0.00423 $0.00423 $0.00094
9 Underground Storage $0.02105 $0.01989 $0.02452 $0.01689 $0.01593
10 Distribution $0.28921 $0.33815 $0.19722 $0.13740 $0.08041
11 Common $0.12838 $0.16076 $0.06273 $0.04607 $0.02846
12 Total Current Margin Melded Rate per Therm $0.44275 $0.52303 $0.28870 $0.20459 $0.12574
Functional Cost Components at Uniform Current Return
13 Production 337,031 235,918 97,171 1,399 2,542
14 Underground Storage 1,659,853 1,209,969 409,118 5,163 35,604
15 Distribution 23,602,001 19,789,048 3,577,829 42,775 192,349
16 Common 10,574,115 9,188,426 1,298,242 14,877 72,571
17 Total Uniform Current Cost 36,173,000 30,423,361 5,382,359 64,214 303,066
18 Exclude Cost of Gas w / Revenue Exp. 0 0 0 0 0
19 Total Uniform Current Margin 36,173,000 30,423,361 5,382,359 64,214 303,066
Margin per Therm at Uniform Current Return
20 Production $0.00413 $0.00423 $0.00423 $0.00423 $0.00094
21 Underground Storage $0.02032 $0.02172 $0.01783 $0.01563 $0.01315
22 Distribution $0.28889 $0.35519 $0.15591 $0.12947 $0.07104
23 Common $0.12943 $0.16492 $0.05657 $0.04503 $0.02680
24 Total Current Uniform Margin Melded Rate per $0.44275 $0.54606 $0.23455 $0.19435 $0.11193
25 Margin to Cost Ratio at Current Rates 1.00 0.96 1.23 1.05 1.12
Functional Cost Components at Proposed Rates
26 Production 337,028 235,917 97,171 1,399 2,542
27 Underground Storage 1,991,177 1,335,243 601,840 6,379 47,715
28 Distribution 26,005,559 20,955,352 4,766,705 50,404 233,098
29 Common 11,044,236 9,473,226 1,475,369 15,879 79,762
30 Total Proposed Rate Revenue 39,378,000 31,999,738 6,941,084 74,061 363,116
31 Exclude Cost of Gas w / Revenue Exp. 0 0 0 0 0
32 Total Margin Revenue at Proposed Rates 39,378,000 31,999,738 6,941,084 74,061 363,116
Margin per Therm at Proposed Rates
33 Production $0.00413 $0.00423 $0.00423 $0.00423 $0.00094
34 Underground Storage $0.02437 $0.02397 $0.02623 $0.01931 $0.01762
35 Distribution $0.31831 $0.37612 $0.20772 $0.15256 $0.08609
36 Common $0.13518 $0.17003 $0.06429 $0.04806 $0.02946
37 Total Proposed Margin Melded Rate per Therm $0.48198 $0.57436 $0.30247 $0.22416 $0.13411
Functional Cost Components at Uniform Proposed Return
38 Production 337,028 235,917 97,171 1,399 2,542
39 Underground Storage 1,943,529 1,416,758 479,037 6,045 41,689
40 Distribution 25,984,580 21,714,298 4,009,149 48,310 212,823
41 Common 11,112,863 9,658,576 1,362,499 15,604 76,184
42 Total Uniform Proposed Cost 39,378,000 33,025,548 5,947,856 71,358 333,237
43 Exclude Cost of Gas w / Revenue Exp. 0 0 0 0 0
44 Total Uniform Proposed Margin 39,378,000 33,025,548 5,947,856 71,358 333,237
Margin per Therm at Uniform Proposed Return
45 Production $0.00413 $0.00423 $0.00423 $0.00423 $0.00094
46 Underground Storage $0.02379 $0.02543 $0.02088 $0.01830 $0.01540
47 Distribution $0.31805 $0.38975 $0.17471 $0.14622 $0.0786048 Common 0.13602 0.17336 0.05937 0.04723 0.02814
49 Total Proposed Uniform Margin Melded Rate pe $0.48198 $0.59277 $0.25919 $0.21598 $0.12307
50 Margin to Cost Ratio at Proposed Rates 1.00 0.97 1.17 1.04 1.09
51 Current Margin to Proposed Cost Ratio 0.92 0.88 1.11 0.95 1.02
Exhibit No. 14
Case No. AVU-G-15-01
J. Miller, Avista
Schedule 2, p. 2 of 4
AVISTA UTILITIES Natural Gas Utility
Company Base Case Summary by Classification with Unit Cost Analysis Idaho Jurisdiction
For the Year Ended December 31, 2014
(b) (c) (d) (e) (f) (g) (h) (j) (k)
Residential Large Firm Interrupt Transport
System Service Service Service Service
Line Description Total Sch 101 Sch 111 Sch 131 Sch 146
Cost by Classification at Current Return by Schedule
1 Commodity 9,175,533 5,898,602 3,078,548 36,446 161,936
2 Demand 7,929,786 5,498,834 2,314,276 29,739 86,937
3 Customer 19,067,681 17,742,388 1,232,303 1,411 91,579
4 Total Current Rate Revenue 36,173,000 29,139,824 6,625,127 67,596 340,452
Revenue per Therm at Current Rates
5 Commodity $0.11231 $0.10587 $0.13415 $0.11031 $0.05981
6 Demand $0.09706 $0.09870 $0.10085 $0.09001 $0.03211
7 Customer $0.23339 $0.31845 $0.05370 $0.00427 $0.03382
8 Total Revenue per Therm at Current Rates $0.44275 $0.52303 $0.28870 $0.20459 $0.12574
Cost per Unit at Current Rates
9 Commodity Cost per Therm $0.11231 $0.10587 $0.13415 $0.11031 $0.05981
10 Demand Cost per Peak Day Therms $15.91 $14.92 $19.64 $17.04 $8.60
11 Customer Cost per Customer per Month $20.61 $19.53 $74.03 $117.59 $1,526.32
Cost by Classification at Uniform Current Return
12 Commodity 8,893,485 6,252,044 2,465,664 34,608 141,170
13 Demand 7,782,498 5,817,937 1,859,788 28,251 76,522
14 Customer 19,497,016 18,353,381 1,056,908 1,355 85,373
15 Total Uniform Current Cost 36,173,000 30,423,361 5,382,359 64,214 303,066
Cost per Therm at Current Return
16 Commodity $0.10886 $0.11222 $0.10745 $0.10475 $0.05214
17 Demand $0.09526 $0.10443 $0.08104 $0.08551 $0.02826
18 Customer $0.23864 $0.32942 $0.04606 $0.00410 $0.03153
19 Total Cost per Therm at Current Return $0.44275 $0.54606 $0.23455 $0.19435 $0.11193
Cost per Unit at Uniform Current Return
20 Commodity Cost per Therm $0.10886 $0.11222 $0.10745 $0.10475 $0.05214
21 Demand Cost per Peak Day Therms $15.62 $15.78 $15.78 $16.19 $7.57
22 Customer Cost per Customer per Month $21.07 $20.20 $63.49 $112.89 $1,422.89
23 Revenue to Cost Ratio at Current Rates 1.00 0.96 1.23 1.05 1.12
Cost by Classification at Proposed Return by Schedule
24 Commodity 10,134,992 6,686,140 3,234,367 39,960 174,525
25 Demand 8,765,515 6,209,858 2,429,824 32,583 93,250
26 Customer 20,477,493 19,103,740 1,276,893 1,519 95,341
27 Total Proposed Rate Revenue 39,378,000 31,999,738 6,941,084 74,061 363,116
Revenue per Therm at Proposed Rates
28 Commodity $0.12405 $0.12001 $0.14094 $0.12095 $0.06446
29 Demand $0.10729 $0.11146 $0.10588 $0.09862 $0.03444
30 Customer $0.25064 $0.34289 $0.05564 $0.00460 $0.03521
31 Total Revenue per Therm at Proposed Rates $0.48198 $0.57436 $0.30247 $0.22416 $0.13411
Cost per Unit at Proposed Rates
32 Commodity Cost per Therm $0.12405 $0.12001 $0.14094 $0.12095 $0.06446
33 Demand Cost per Peak Day Therms $17.59 $16.85 $20.62 $18.67 $9.23
34 Customer Cost per Customer per Month $22.13 $21.03 $76.70 $126.59 $1,589.01
Cost by Classification at Uniform Proposed Return
35 Commodity 9,909,578 6,968,613 2,744,546 38,491 157,929
36 Demand 8,647,802 6,464,886 2,066,595 31,393 84,927
37 Customer 20,820,620 19,592,049 1,136,715 1,474 90,381
38 Total Uniform Proposed Cost 39,378,000 33,025,548 5,947,856 71,358 333,237
Cost per Therm at Proposed Return
39 Commodity $0.12129 $0.12508 $0.11960 $0.11650 $0.05833
40 Demand $0.10585 $0.11604 $0.09006 $0.09502 $0.03137
41 Customer $0.25484 $0.35165 $0.04953 $0.00446 $0.03338
42 Total Cost per Therm at Proposed Return $0.48198 $0.59277 $0.25919 $0.21598 $0.12307
Cost per Unit at Uniform Proposed Return
43 Commodity Cost per Therm $0.12129 $0.12508 $0.11960 $0.11650 $0.05833
44 Demand Cost per Peak Day Therms $17.35 $17.54 $17.54 $17.99 $8.41
45 Customer Cost per Customer per Month $22.50 $21.57 $68.28 $122.83 $1,506.35
46 Revenue to Cost Ratio at Proposed Rates 1.00 0.97 1.17 1.04 1.09
47 Current Revenue to Proposed Cost Ratio 0.92 0.88 1.11 0.95 1.02
Exhibit No. 14
Case No. AVU-G-15-01
J. Miller, Avista
Schedule 2, p. 3 of 4
AVISTA UTILITIES Natural Gas Utility
Company Base Case Customer Cost Analysis Idaho Jurisdiction
For the Year Ended December 31, 2014
(b) (c) (d) (e) (f) (g) (h) (j) (k)
Residential Large Firm Interrupt Transport
System Service Service Service ServiceLine Description Total Sch 101 Sch 111 Sch 131 Sch 146
Rate Base
1 Services 57,836,000 56,620,726$ 1,162,029$ 2,528$ 50,717$
2 Services Accum. Depr. (26,039,000) (25,491,858)$ (523,170)$ (1,138)$ (22,834)$
3 Total Services 31,797,000 31,128,868 638,859 1,390 27,883
4 Meters 24,149,000 21,016,940$ 3,036,231$ 5,000$ 90,828$
5 Meters Accum. Depr. (6,476,000) (5,636,080)$ (814,221)$ (1,341)$ (24,357)$
6 Total Meters 17,673,000 15,380,860 2,222,010 3,659 66,471
7 Total Rate Base 49,470,000 46,509,728 2,860,869 5,049 94,354
8 Return on Rate Base @ 7.62% 3,769,614 3,544,041 217,998 385 7,190
9 Tax Benefit of Interest Expense (462,297) (434,633) (26,735) (47) (882)
10 Revenue Conversion Factor 0.61459 0.61459 0.61459 0.61459 0.61459
11 Rate Base Revenue Requirement 5,381,339 5,059,321 311,205 549 10,264
Expenses
12 Services Depr Exp 1,416,000 1,386,246$ 28,450$ 62$ 1,242$
13 Meters Depr Exp 675,000 587,454$ 84,867$ 140$ 2,539$
14 Services Maintenance Exp 874,999 856,614$ 17,580$ 38$ 767$
15 Meters Maintenance Exp 769,999 670,133$ 96,811$ 159$ 2,896$
16 Meter Reading 201,001 197,368$ 3,617$ 3$ 13$
17 Billing 1,779,999 1,747,834$ 32,027$ 23$ 115$
18 Total Expenses 5,716,998 5,445,649 263,352 425 7,572
19 Revenue Conversion Factor 0.994222 0.994222 0.994222 0.994222 0.994222
20 Expense Revenue Requirement 5,750,223 5,477,297 264,882 427 7,616
21 11,131,561 10,536,617 576,087 977 17,880
22 Total Customer Bills 925,202 908,483 16,647 12 60
23 Average Unit Cost per Month $12.03 $11.60 $34.61 $81.39 $298.00
24 Total Customer Related Cost 20,820,620 19,592,049 1,136,715 1,474 90,381
25 Customer Related Unit Cost per Month $22.50 $21.57 $68.28 $122.83 $1,506.35
26 Other Non-Gas Costs 18,557,380 13,433,499 4,811,141 69,884 242,856
27 Other Non-Gas Unit Cost per Month $20.06 $14.79 $289.01 $5,823.68 $4,047.60
28 Total Fixed Unit Cost per Month $42.56 $36.35 $357.29 $5,946.51 $5,553.95
Total Meter, Service, Meter Reading, and
Meter, Services, Meter Reading & Billing Costs by Schedule at Requested Rate of Return
Fixed Costs per Customer
Exhibit No. 14
Case No. AVU-G-15-01
J. Miller, Avista
Schedule 2, p. 4 of 4