{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sumcost Exhibits"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sumcost Exhibits","index":0,"n_rows":287,"n_cols":11,"rows_kept":287,"cut":false,"hidden":false,"merged":[[267,1,267,4],[238,1,238,10],[273,1,273,10]]}
[]
[]
[null,"Sumcost","AVISTA UTILITIES",null,null,null,null,null,"Natural Gas Utility"]
[null,"Company Base Case","Cost of Service General Summary",null,null,null,null,null,"Washington Jurisdiction",null,"2011-05-16"]
[null,"UG Storage 87% Sales / 13% Throughput","For the Twelve Months Ended December 31, 2010",null,null,null,null,null,null,null," "]
[null," "]
[null,"(b)","(c)","(d)","(e)","(f)","(g)","(h)","(i)","(j)","(k)"]
[null," "," "," "," "," ","Residential","Small Firm","Large Firm","Interrupt","Transport"]
[null," ",null,null,null,"System","Service","Service","Service","Service","Service"]
[null,"Description",null,null,null,"Total","Sch 101","Sch 111","Sch 121","Sch 131","Sch 146"]
[null,"Plant In Service"]
[1," Production Plant"]
[2," Underground Storage Plant",null,null,null,{"$f":"SUM(G13:K13)","v":23985999.999999996},16230602.947763452,6480811.9270165516,783486.98813077214,88839.847743890365,402258.28934533079]
[3," Distribution Plant",null,null,null,{"$f":"SUM(G14:K14)","v":272369999.99999994},216631701.47082233,44452506.043928213,3662529.1940145572,245978.34868860067,7377284.9425462708]
[4," Intangible Plant",null,null,null,{"$f":"SUM(G15:K15)","v":5988000},4712114.412357253,1022791.1357075127,88695.115226277223,6599.2153426694613,157800.12136628758]
[5," General Plant",null,null,null,{"$f":"SUM(G16:K16)","v":27861000.000000004},21891835.034236591,4788339.6050307471,417978.56918959314,31476.905380034932,731369.8861630332]
[6,"   Total Plant In Service",null,null,null,{"$f":"SUM(F13:F16)","v":330204999.99999994},259466253.8651796,56744448.71168302,4952689.8665611995,372894.31715519546,8668713.2394209225]
[]
[null,"Accum Depreciation"]
[7," Production Plant"]
[8," Underground Storage Plant",null,null,null,{"$f":"SUM(G21:K21)","v":-7993000.0000000009},-5408622.0862783836,-2159640.1956409276,-261086.11257105242,-29604.640332565479,-134046.96517707119]
[9," Distribution Plant",null,null,null,{"$f":"SUM(G22:K22)","v":-89612000.000000015},-72465961.658825859,-13685944.10085053,-1150516.2414875161,-72289.188103631153,-2237288.8107324662]
[10," Intangible Plant",null,null,null,{"$f":"SUM(G23:K23)","v":-2723000},-2140025.2286987226,-467608.26320877438,-40782.775675701021,-3066.4272589611892,-71517.305157840703]
[11," General Plant",null,null,null,{"$f":"SUM(G24:K24)","v":-8048999.9999999991},-6324517.4326323643,-1383343.9388712712,-120753.36504099044,-9093.6294965687212,-211291.63395880457]
[12,"   Total Accumulated Depreciation",null,null,null,{"$f":"SUM(F21:F24)","v":-108377000.00000001},-86339126.406435311,-17696536.498571504,-1573138.4947752601,-114053.88519172656,-2654144.7150261826]
[]
[13,"Net Plant",null,null,null,{"$f":"F17+F25","v":221827999.99999994},173127127.45874429,39047912.21311152,3379551.3717859397,258840.4319634689,6014568.5243947394]
[14,"Accumlulated Deferred FIT",null,null,null,{"$f":"SUM(G28:K28)","v":-36863000.000000007},-28965959.074611586,-6334763.5949145872,-552902.00496977789,-41628.694941905684,-967746.63056214596]
[15,"Miscellaneous Rate Base",null,null,null,{"$f":"SUM(G29:K29)","v":16384000},10710525.80356897,4741049.2321920888,573161.26827026845,64990.94506637389,294272.75090229802]
[16,"   Total Rate Base",null,null,null,{"$f":"SUM(F27:F29)","v":201348999.99999994},154871694.18770167,37454197.850389026,3399810.6350864302,282202.68208793714,5341094.6447348911]
[]
[17,"Revenue From Retail Rates",null,null,null,{"$f":"SUM(G32:K32)","v":155349999.99999997},112380889.82993896,36693944.610674754,4040107.8119443171,423102.6559151258,1811955.0915268469]
[18,"Other Operating Revenues",null,null,null,{"$f":"SUM(G33:K33)","v":1568000.0000000007},1206478.2169025689,291308.61310901493,26420.922818315215,2189.6706065529143,41602.576563548762]
[19,"   Total Revenues",null,null,null,{"$f":"SUM(F32:F33)","v":156917999.99999997},113587368.04684153,36985253.223783769,4066528.7347626323,425292.32652167871,1853557.6680903956]
[]
[null,"Operating Expenses"]
[20," Purchased Gas Costs",null,null,null,{"$f":"SUM(G37:K37)","v":96013000},66241039.786453731,26308872.814837955,3090878.4584518061,338272.78279463836,33936.157461870738]
[21," Underground Storage Expenses",null,null,null,722000,488555.62946240365,195078.22110005631,23583.657359727236,2674.1586788580353,12108.333398954759]
[22," Distribution Expenses",null,null,null,8474000,6929238.3286143523,1226397.4097085951,92868.292638671119,7845.8780215321794,217650.09101684965]
[23," Customer Accounting Expenses",null,null,null,5435000.0000000009,5194691.7866466297,214666.0527675061,16104.277251062735,1626.2544198034504,7911.6289149989097]
[24," Customer Information Expenses",null,null,null,964000,948397.1434756344,15202.979380753935,176.99480127072493,6.5553630100268494,216.32697933088602]
[25," Sales Expenses",null,null,null,109999.99999999999,108219.5910604977,1734.779804857814,20.196502219688529,0.74801860072920479,24.68461382406376]
[26," Admin & General Expenses",null,null,null,10852000.015845543,8037472.1189041706,1896088.571204226,201476.92765676943,21198.908137464641,695763.48994291178]
[27,"   Total O&M Expenses",null,null,null,{"$f":"SUM(F37:F43)","v":122570000.01584554},87947614.384617433,29858040.828803953,3425108.8046615273,371625.28543390747,967610.71232874074]
[]
[28,"Taxes Other Than Income Taxes",null,null,null,{"$f":"SUM(G46:K46)","v":7960000.0000000009},5874580.0207032915,1759745.3787084892,186440.25526102044,18700.505459758973,120533.83986744007]
[29,"Depreciation Expense"]
[30," Underground Storage Plant Depr",null,null,null,{"$f":"SUM(G48:K48)","v":419999.99999999994},284201.33569835115,113480.40562607152,13719.025056905042,1555.6047716348683,7043.6288470373947]
[31," Distribution Plant Depreciation",null,null,null,{"$f":"SUM(G49:K49)","v":6386000},5234223.2777904011,916436.32085664908,72136.476912770959,5432.5371974458267,157771.38724273298]
[32," General Plant Depreciation",null,null,null,{"$f":"SUM(G50:K50)","v":1423000},1118125.0225662636,244564.34650438797,21348.246795046514,1607.6822926596212,37354.701841642309]
[33," Amortization of Intangible Plant",null,null,null,{"$f":"SUM(G51:K51)","v":930000.00000000012},730912.61756927427,159687.54216776969,13925.680266317775,1046.8453367989412,24427.314659839387]
[34,"   Total Depr & Amort Expense",null,null,null,{"$f":"SUM(F48:F51)","v":9159000},7367462.2536242902,1434168.6151548782,121129.4290310403,9642.6695985392562,226597.03259125206]
[35,"Income Tax",null,null,null,{"$f":"SUM(G53:K53)","v":4514999.9999999916},3128680.9097030549,1133273.5472245088,93531.097391521515,6801.8946268532845,152712.55105405307]
[36,"   Total Operating Expenses",null,null,null,{"$f":"F44+F46+F52+F53","v":144204000.01584554},104318337.56864807,34185228.36989183,3826209.5863451096,406770.35511905898,1467454.135841486]
[]
[37,"Net Income",null,null,null,{"$f":"F34-F54","v":12713999.984154433},9269030.4781934619,2800024.8538919389,240319.14841752267,18521.971402619733,386103.53224890959]
[]
[38,"Rate of Return",null,null,null,{"$f":"F56/F30","v":6.3144093013396824E-2},5.9849739016605355E-2,7.4758638940197089E-2,7.0686039374488058E-2,6.5633576780989286E-2,7.2289213715679076E-2]
[39,"Return Ratio",null,null,null,{"$f":"F58/$F58","v":1},0.94782799404383666,1.1839371724657775,1.1194402516715398,1.0394254418550961,1.1448293936273977]
[]
[40,"Interest Expense",null,null,null,{"$f":"SUM(G61:K61)","v":6020000.0000000019},4630405.9072057204,1119818.1816614035,101648.67977104588,8437.39053171052,159689.84083012101]
[]
["File:  WA 2011 Gas Case / Gas COS Base Case / Summary Exhibits",null,null,null,null,null,null,null,null,null,"Page 1 of 4"]
[null,{"$f":"$B$3","v":"Sumcost"},{"$f":"$C$3","v":"AVISTA UTILITIES"},null,null,null,null,null,{"$f":"$I$3","v":"Natural Gas Utility"}]
[null,{"$f":"$B$4","v":"Company Base Case"},"Summary by Function with Margin Analysis",null,null,null,null,null,{"$f":"$I$4","v":"Washington Jurisdiction"},null,{"$f":"$K$4","v":"2011-05-16"}]
[null,{"$f":"$B$5","v":"UG Storage 87% Sales / 13% Throughput"},{"$f":"$C$5","v":"For the Twelve Months Ended December 31, 2010"}]
[]
[null,{"$f":"$B$7","v":"(b)"},{"$f":"$C$7","v":"(c)"},{"$f":"$D$7","v":"(d)"},{"$f":"$E$7","v":"(e)"},{"$f":"$F$7","v":"(f)"},{"$f":"$G$7","v":"(g)"},{"$f":"$H$7","v":"(h)"},{"$f":"$I$7","v":"(i)"},{"$f":"$J$7","v":"(j)"},{"$f":"$K$7","v":"(k)"}]
[null,null,null,null,null,{"$f":"F8","v":" "},"Residential","Small Firm","Large Firm","Interrupt","Transport"]
[null,null,null,null,null,"System","Service","Service","Service","Service","Service"]
[null,{"$f":"$B$10","v":"Description"},null,null,null,"Total","Sch 101","Sch 111","Sch 121","Sch 131","Sch 146"]
[]
[null,"Functional Cost Components at Current Rates"]
[1,"Production",null,null,null,{"$f":"SUM(G74:K74)","v":100510920.29542176},69344233.283639848,27541364.383516464,3235676.8185587949,354119.8453290952,35525.96437756317]
[2,"Underground Storage",null,null,null,{"$f":"SUM(G75:K75)","v":3971778.6494052773},2518739.9844443011,1223648.6226159886,140734.1893151195,14945.51159870425,73710.341431163644]
[3,"Distribution",null,null,null,{"$f":"SUM(G76:K76)","v":35865313.390006021},29299757.837116256,5273532.7425623136,398075.20343561011,28171.398048918789,865776.20884291467]
[4,"Common",null,null,null,{"$f":"SUM(G77:K77)","v":15001987.665166928},11218158.724738536,2655398.8619799851,265621.60063479189,25865.900938407529,836942.57687520538]
[5,"     Total Current Rate Revenue",null,null,null,{"$f":"SUM(F74:F77)","v":155349999.99999997},112380889.82993895,36693944.610674754,4040107.8119443161,423102.6559151258,1811955.0915268469]
[6,"Exclude Cost of Gas w / Revenue Exp.",null,null,null,{"$f":"SUM(G79:K79)","v":99559336.379196495},68700192.209908992,27288622.571151964,3205537.9230894623,350722.20555652078,14261.469489540681]
[7,"     Total Margin Revenue at Current Rates",null,null,null,{"$f":"F78-F79","v":55790663.620803475},43680697.620029956,9405322.0395227894,834569.88885485381,72380.450358605012,1797693.6220373062]
[]
[null,"Margin per Therm at Current Rates"]
[8,"Production",null,null,null,4.8657891637824569E-3,5.4939126529983213E-3,5.3994623299621651E-3,5.3259659135113041E-3,5.295078035991674E-3,8.4286388239589464E-4]
[9,"Underground Storage",null,null,null,2.0309125851853613E-2,2.1485799640061639E-2,2.6141478456269639E-2,2.4869706851754506E-2,2.3291948381859943E-2,2.9216675438828248E-3]
[10,"Distribution",null,null,null,0.18339218462309581,0.24993795718437203,0.11266138009733903,7.0345476551038566E-2,4.3903933623599393E-2,3.4316897744999762E-2]
[11,"Common",null,null,null,7.6710532588580224E-2,9.5695114294744976E-2,5.6728746194190077E-2,4.6939065577659082E-2,4.0310913783635459E-2,3.3174014873252514E-2]
[12,"     Total Current Margin Melded Rate per Therm",null,null,null,{"$f":"SUM(F83:F86)","v":0.28527763222731212},0.37261278377217699,0.2009310670777609,0.14748021489396346,0.11280187382508647,7.1255444044530991E-2]
[]
[null,"Functional Cost Components at Uniform Current Return"]
[13,"Production",null,null,null,{"$f":"SUM(G90:K90)","v":100510920.29542176},69344233.283639848,27541364.383516464,3235676.8185587949,354119.8453290952,35525.96437756317]
[14,"Underground Storage",null,null,null,{"$f":"SUM(G91:K91)","v":3900480.9009108176},2639337.8140589581,1053876.5589812011,127406.65527041677,14446.682621732232,65413.189978509152]
[15,"Distribution",null,null,null,{"$f":"SUM(G92:K92)","v":35928919.372059524},29989068.33950448,4745890.1108989315,370148.33359288413,27530.55976372138,796282.02829950629]
[16,"Common",null,null,null,{"$f":"SUM(G93:K93)","v":15009679.431607848},11302598.688129438,2590265.6990588498,261928.81548566028,25774.067108783856,829112.16182511626]
[17,"     Total Uniform Current Cost",null,null,null,{"$f":"SUM(F90:F93)","v":155349999.99999994},113275238.12533273,35931396.752455451,3995160.6229077564,421871.15482333268,1726333.3444806947]
[18,"Exclude Cost of Gas w / Revenue Exp.",null,null,null,{"$f":"SUM(G95:K95)","v":99559336.379196495},68700192.209908992,27288622.571151964,3205537.9230894623,350722.20555652078,14261.469489540681]
[19,"     Total Uniform Current Margin",null,null,null,{"$f":"F94-F95","v":55790663.620803446},44575045.915423736,8642774.1813034862,789622.69981829403,71148.949266811891,1712071.8749911541]
[]
[null,"Margin per Therm at Uniform Current Return"]
[20,"Production",null,null,null,4.8657891637824569E-3,5.4939126529983213E-3,5.3994623299621651E-3,5.3259659135113041E-3,5.295078035991674E-3,8.4286388239589464E-4]
[21,"Underground Storage",null,null,null,1.9944554944221433E-2,2.2514544496668377E-2,2.2514544496668377E-2,2.2514544496668371E-2,2.2514544496668381E-2,2.5927921427487868E-3]
[22,"Distribution",null,null,null,0.18371742477580391,0.255818035094586,0.10138906038618743,6.5410406617743527E-2,4.2905214231401957E-2,3.1562346784575535E-2]
[23,"Common",null,null,null,7.6749863343504116E-2,9.6415418949546944E-2,5.5337270615480667E-2,4.6286498603192214E-2,4.0167794640126944E-2,3.2863639570916654E-2]
[24,"     Total Current Uniform Margin Melded Rate per Therm",null,null,null,{"$f":"SUM(F99:F102)","v":0.28527763222731195},0.38024191119379969,0.18464033782829864,0.13953741563111544,0.11088263140418896,6.7861642380636869E-2]
[]
[25,"Margin to Cost Ratio at Current Rates",null,null,null,{"$f":"F80/F96","v":1.0000000000000004},0.97993612172400879,1.0882295247131284,1.0569223618405383,1.0173087741208227,1.0500106031159437]
[]
[]
[null,"Functional Cost Components at Proposed Rates"]
[26,"Production",null,null,null,{"$f":"SUM(G109:K109)","v":100507164.64398411},69341642.194346681,27540335.283748619,3235555.9155339329,354106.61342650885,35524.636928378575]
[27,"Underground Storage",null,null,null,{"$f":"SUM(G110:K110)","v":4852618.5091388104},3283621.0889029102,1311135.6877180357,158507.68643573698,17973.087208579796,81380.958873547555]
[28,"Distribution",null,null,null,{"$f":"SUM(G111:K111)","v":40613863.479906768},33671092.073509239,5545382.9868212715,435314.40746229654,32060.544908075819,930013.46720587881]
[29,"Common",null,null,null,{"$f":"SUM(G112:K112)","v":15583353.366970316},11753358.473180134,2688881.6523868288,270537.80251235038,26422.410371961305,844153.02851904172]
[30,"     Total Proposed Rate Revenue",null,null,null,{"$f":"SUM(F109:F112)","v":161557000},118049713.82993896,37085735.610674754,4099915.8119443171,430562.6559151258,1891072.0915268466]
[31,"Exclude Cost of Gas w / Revenue Exp.",null,null,null,{"$f":"SUM(G114:K114)","v":99555616.284268409},68697625.185600758,27287602.915235076,3205418.1462226906,350709.10060880322,14260.936601092]
[32,"     Total Margin Revenue at Proposed Rates",null,null,null,{"$f":"F113-F114","v":62001383.715731591},49352088.644338205,9798132.6954396777,894497.66572162649,79853.555306322582,1876811.1549257545]
[]
[null,"Margin per Therm at Proposed Rates"]
[33,"Production",null,null,null,4.8656073506222995E-3,5.4937073696233818E-3,5.3992605757806379E-3,5.325766905567954E-3,5.2948801821924886E-3,8.4283238827622721E-4]
[34,"Underground Storage",null,null,null,2.4813175333396616E-2,2.8010523216279656E-2,2.8010512740538313E-2,2.8010533293938527E-2,2.8010297055418441E-2,3.225708925157441E-3]
[35,"Distribution",null,null,null,0.20767322087975265,0.28722708275626113,0.11846906636632232,7.6926166659414888E-2,4.9965004687959072E-2,3.6863079314954333E-2]
[36,"Common",null,null,null,7.9683263509938124E-2,0.10026056949593541,5.7444057459122531E-2,4.7807827462130248E-2,4.1178210223422537E-2,3.3459816595717833E-2]
[37,"     Total Proposed Margin Melded Rate per Therm",null,null,null,{"$f":"SUM(F118:F121)","v":0.31703526707370966},0.42099188283809957,0.2093228971417638,0.15807029432105163,0.12444839214899255,7.4391437224105836E-2]
[]
[null,"Functional Cost Components at Uniform Proposed Return"]
[38,"Production",null,null,null,{"$f":"SUM(G125:K125)","v":100507164.64398411},69341642.194346681,27540335.283748619,3235555.9155339329,354106.61342650885,35524.636928378575]
[39,"Underground Storage",null,null,null,{"$f":"SUM(G126:K126)","v":4852618.6636225143},3283620.7281815866,1311136.0340393528,158507.61199486267,17973.230352513339,81381.059054199039]
[40,"Distribution",null,null,null,{"$f":"SUM(G127:K127)","v":40613863.361441262},33671090.011705987,5545384.0631696833,435314.25147690566,32060.728802992002,930014.30628569075]
[41,"Common",null,null,null,{"$f":"SUM(G128:K128)","v":15583353.347539358},11753358.22061095,2688881.7852532282,270537.78188631753,26422.436724591589,844153.12306427036]
[42,"     Total Uniform Proposed Cost",null,null,null,{"$f":"SUM(F125:F128)","v":161557000.01658726},118049711.15484521,37085737.166210882,4099915.5608920185,430563.00930660573,1891073.1253325387]
[43,"Exclude Cost of Gas w / Revenue Exp.",null,null,null,{"$f":"SUM(G130:K130)","v":99555616.284268409},68697625.185600758,27287602.915235076,3205418.1462226906,350709.10060880322,14260.936601092]
[44,"     Total Uniform Proposed Margin",null,null,null,{"$f":"F129-F130","v":62001383.732318848},49352085.96924445,9798134.2509758063,894497.4146693279,79853.908697802515,1876812.1887314466]
[]
[null,"Margin per Therm at Uniform Proposed Return"]
[45,"Production",null,null,null,4.8656073506222995E-3,5.4937073696233818E-3,5.3992605757806379E-3,5.325766905567954E-3,5.2948801821924886E-3,8.4283238827622721E-4]
[46,"Underground Storage",null,null,null,2.4813176123327087E-2,2.8010520139191059E-2,2.8010520139191065E-2,2.8010520139191052E-2,2.8010520139191065E-2,3.2257128960325216E-3]
[47,"Distribution",null,null,null,0.20767322027399612,0.28722706516830371,0.11846908936094537,7.6926139094606633E-2,4.9965291280416421E-2,3.6863112573683104E-2]
[48,"Common",null,null,null,7.9683263410580685E-2,0.10026056734142526,5.7444060297620489E-2,4.78078238172207E-2,4.1178251292883439E-2,3.3459820343220835E-2]
[49,"     Total Proposed Uniform Margin Melded Rate per Therm",null,null,null,{"$f":"SUM(F134:F137)","v":0.3170352671585262},0.42099186001854338,0.20932293037353755,0.15807024995658633,0.12444894289468342,7.4391478201212696E-2]
[]
[50,"Margin to Cost Ratio at Proposed Rates",null,null,null,{"$f":"F115/F131","v":0.99999999973246956},1.0000000542042693,0.9999998412415988,1.0000002806629673,0.99999557452495813,0.99999944916934236]
[]
[51,"Current Margin to Proposed Cost Ratio",null,null,null,{"$f":"F80/F131","v":0.89982933061092352},0.88508310767757969,0.95990948874640125,0.93300424927820758,0.9064108637752486,0.9578441747292693]
[]
[{"$f":"$A$63","v":"File:  WA 2011 Gas Case / Gas COS Base Case / Summary Exhibits"},null,null,null,null,null,null,null,null,null,"Page 2 of 4"]
[null,{"$f":"B3","v":"Sumcost"},{"$f":"C3","v":"AVISTA UTILITIES"},null,null,null,null,null,{"$f":"I3","v":"Natural Gas Utility"}]
[null,{"$f":"B4","v":"Company Base Case"},"Summary by Classification with Unit Cost Analysis",null,null,null,null,null,{"$f":"I4","v":"Washington Jurisdiction"},null,{"$f":"K4","v":"2011-05-16"}]
[null,{"$f":"B5","v":"UG Storage 87% Sales / 13% Throughput"},{"$f":"C5","v":"For the Twelve Months Ended December 31, 2010"},null,null,null,null,null,null,null,{"$f":"K5","v":" "}]
[]
[null,{"$f":"B7","v":"(b)"},"(c)","(d)","(e)","(f)","(g)","(h)","(i)","(j)","(k)"]
[null,null,null,null,null,{"$f":"F8","v":" "},"Residential","Small Firm","Large Firm","Interrupt","Transport"]
[null,null,null,null,null,"System","Service","Service","Service","Service","Service"]
[null,{"$f":"B10","v":"Description"},null,null,null,"Total","Sch 101","Sch 111","Sch 121","Sch 131","Sch 146"]
[]
[null,"Cost by Classification at Current Return by Schedule "]
[1,"Commodity",null,null,null,{"$f":"SUM(G155:K155)","v":98500571.599143192},66700270.301454708,27069222.155063637,3257525.8296946459,352770.13584837824,1120783.1770818257]
[2,"Demand",null,null,null,{"$f":"SUM(G156:K156)","v":29295722.661735423},20004098.782857835,8041246.769964518,728451.84660041134,59510.339117798314,462414.92319486337]
[3,"Customer",null,null,null,{"$f":"SUM(G157:K157)","v":27553705.722533539},25676520.729038563,1583475.6856466071,54130.135649259231,10822.180948949268,228756.99125015724]
[4,"     Total Current Rate Revenue",null,null,null,{"$f":"SUM(F155:F157)","v":155349999.98341215},112380889.81335111,36693944.610674761,4040107.8119443166,423102.6559151258,1811955.0915268464]
[]
[null,"Revenue per Therm at Current Rates"]
[5,"Commodity ",null,null,null,0.50366867886408018,0.5689783989160716,0.57829467930242962,0.57565054263484972,0.54977735225567781,4.4424646102987839E-2]
[6,"Demand ",null,null,null,0.14979951577796857,0.17064248834057802,0.17178957693686256,0.12872766716271675,9.2744349215781438E-2,1.8328807690671054E-2]
[7,"Customer",null,null,null,0.14089195964827103,0.2190303815579149,3.3828661886499883E-2,9.5655548377693092E-3,1.686591177406924E-2,9.0672741951145323E-3]
[8,"     Total Revenue per Therm at Current Rates",null,null,null,{"$f":"SUM(F161:F163)","v":0.79436015429031981},0.95865126881456453,0.78391291812579211,0.71394376463533582,0.65938761324552853,7.1820727988773425E-2]
[]
[null,"Cost per Unit at Current Rates"]
[9,"Commodity Cost per Therm",null,null,null,0.50366867886408018,0.5689783989160716,0.57829467930242962,0.57565054263484972,0.54977735225567781,4.4424646102987839E-2]
[10,"Demand Cost per Peak Day Therms",null,null,null,19.075865742123984,19.940369362375684,21.459977662571536,25.314562364484686,11.807606967817126,3.7283407902703716]
[11,"Customer Cost per Customer per Month",null,null,null,15.614154848086228,14.789770594458016,56.898156149716385,167.06831990512109,901.84841241243896,577.66916982362943]
[]
[null,"Cost by Classification at Uniform Current Return "]
[12,"Commodity",null,null,null,{"$f":"SUM(G172:K172)","v":98335433.636090353},66944040.078979075,26726054.302753687,3230586.2900743522,352088.9214987334,1082664.0427845169]
[13,"Demand",null,null,null,{"$f":"SUM(G173:K173)","v":29173567.877551872},20235970.163293075,7735904.1335494714,713225.17593403172,59154.561820308772,429313.84295498428]
[14,"Customer",null,null,null,{"$f":"SUM(G174:K174)","v":27840998.469769899},26095227.866472743,1469438.3161523016,51349.156899372552,10627.671504290534,214355.45874119343]
[15,"     Total Uniform Current Cost",null,null,null,{"$f":"SUM(F172:F174)","v":155349999.98341212},113275238.10874489,35931396.752455465,3995160.6229077564,421871.15482333273,1726333.3444806945]
[]
[null,"Cost per Therm at Current Return"]
[16,"Commodity ",null,null,null,0.50282426935121338,0.57105784682674843,0.5709633957523641,0.57088994781181235,0.54871570847291928,4.2913712422381234E-2]
[17,"Demand ",null,null,null,0.14917489464361577,0.17262043844780006,0.16526637427549731,0.12603690070686177,9.2189885329159948E-2,1.7016775349935918E-2]
[18,"Customer",null,null,null,0.1423609902954904,0.22260211096163873,3.1392418848468377E-2,9.0741168538137629E-3,1.6562777022551715E-2,8.4964385525621629E-3]
[19,"     Total Cost per Therm at Current Return",null,null,null,{"$f":"SUM(F178:F180)","v":0.79436015429031959},0.96628039623618722,0.76762218887632971,0.70600096537248791,0.65746837082463094,6.8426926324879317E-2]
[]
[null,"Cost per Unit at Uniform Current Return"]
[20,"Commodity Cost per Therm",null,null,null,0.50282426935121338,0.57105784682674843,0.5709633957523641,0.57088994781181235,0.54871570847291928,4.2913712422381234E-2]
[21,"Demand Cost per Peak Day Therms",null,null,null,18.996324838158259,20.171502042764399,20.645098285734989,24.785417567904911,11.737016234188248,3.4614547070797834]
[22,"Customer Cost per Customer per Month",null,null,null,15.776958119894857,15.030947449151975,52.800514414383819,158.48505215855727,885.63929202421116,541.30166348786224]
[]
[23,"Revenue to Cost Ratio at Current Rates",null,null,null,{"$f":"F158/F175","v":1.0000000000000002},0.99210464431303869,1.0212223271884688,1.0112504085014351,1.0029191403055484,1.0495974588684713]
[]
[]
[null,"Cost by Classification at Proposed Return by Schedule "]
[24,"Commodity",null,null,null,{"$f":"SUM(G192:K192)","v":100295429.194456},68244056.570079848,27245144.62871436,3293341.103039783,356892.25619168382,1155994.6364303101]
[25,"Demand",null,null,null,{"$f":"SUM(G193:K193)","v":30975948.84143436},21474156.061970551,8198377.9303351641,748736.80665702233,61667.856393775684,493010.18607784621]
[26,"Customer",null,null,null,{"$f":"SUM(G194:K194)","v":30285621.94752245},28331501.18130134,1642213.0516252404,57837.902247511367,12002.543329666272,242067.26901869007]
[27,"     Total Proposed Rate Revenue",null,null,null,{"$f":"SUM(F192:F194)","v":161556999.9834128},118049713.81335174,37085735.610674761,4099915.8119443166,430562.65591512574,1891072.0915268464]
[]
[null,"Revenue per Therm at Proposed Rates"]
[28,"Commodity ",null,null,null,0.51284642818171178,0.58214747657379429,0.58205300785354774,0.58197960420292827,0.5562015026520023,4.5820327847961029E-2]
[29,"Demand ",null,null,null,0.15839111363758107,0.18318262998024731,0.17514645632831427,0.13231230436112967,9.6106748735741182E-2,1.9541516583700024E-2]
[30,"Customer",null,null,null,0.15486122514052811,0.24167836364336379,3.5083500537832504E-2,1.0220769244602511E-2,1.8705456674354443E-2,9.5948556145101314E-3]
[31,"     Total Revenue per Therm at Proposed Rates",null,null,null,{"$f":"SUM(F198:F200)","v":0.82609876695982098},1.0070084701974054,0.7922829647196945,0.72451267780866047,0.67101370806209792,7.4956700046171193E-2]
[]
[null,"Cost per Unit at Proposed Rates"]
[32,"Commodity Cost per Therm",null,null,null,0.51284642818171178,0.58214747657379429,0.58205300785354774,0.58197960420292827,0.5562015026520023,4.5820327847961029E-2]
[33,"Demand Cost per Peak Day Therms",null,null,null,20.169942491498841,21.405743306363412,21.879319499492045,26.019488693947121,12.23568579241581,3.9750230681855259]
[34,"Customer Cost per Customer per Month",null,null,null,17.162279205605635,16.319049122343955,59.008733439642128,178.5120439738005,1000.211944138856,611.28098237042946]
[]
[null,"Cost by Classification at Uniform Proposed Return "]
[35,"Commodity",null,null,null,{"$f":"SUM(G209:K209)","v":100295429.6706135},68244055.840937734,27245145.328749102,3293340.9525691201,356892.4516729131,1155995.0966846191]
[36,"Demand",null,null,null,{"$f":"SUM(G210:K210)","v":30975949.187467154},21474155.368417844,8198378.5532095153,748736.72160853003,61667.958487607793,493010.58574365947]
[37,"Customer",null,null,null,{"$f":"SUM(G211:K211)","v":30285621.141919404},28331499.928902414,1642213.2842522766,57837.886714368571,12002.599146084935,242067.44290426001]
[38,"     Total Uniform Proposed Cost",null,null,null,{"$f":"SUM(F209:F211)","v":161557000.00000006},118049711.138258,37085737.166210897,4099915.560892019,430563.00930660579,1891073.1253325385]
[]
[null,"Cost per Therm at Proposed Return"]
[39,"Commodity ",null,null,null,0.5128464306164755,0.58214747035393766,0.58205302280877491,0.58197957761264996,0.55620180730123914,4.5820346091128138E-2]
[40,"Demand ",null,null,null,0.1583911154069706,0.18318262406398181,0.17514646963512157,0.1323122893318672,9.6106907844665079E-2,1.9541532425312102E-2]
[41,"Customer",null,null,null,0.1548612210211914,0.24167835295992976,3.5083505507571812E-2,1.0220766499678128E-2,1.8705543661884698E-2,9.5948625068378052E-3]
[42,"     Total Cost per Therm at Proposed Return",null,null,null,{"$f":"SUM(F215:F217)","v":0.82609876704463747},1.0070084473778491,0.79228299795146828,0.72451263344419536,0.67101425880778887,7.495674102327804E-2]
[]
[null,"Cost per Unit at Uniform Proposed Return"]
[43,"Commodity Cost per Therm",null,null,null,0.5128464306164755,0.58214747035393766,0.58205302280877491,0.58197957761264996,0.55620180730123914,4.5820346091128138E-2]
[44,"Demand Cost per Peak Day Therms",null,null,null,20.169942716817573,21.405742615020241,21.879321161780251,26.019485738411525,12.235706049128531,3.9750262905952694]
[45,"Customer Cost per Customer per Month",null,null,null,17.162278749085889,16.319048400957556,59.008741798500779,178.51199603200178,1000.2165955070778,611.28142147540404]
[]
[46,"Revenue to Cost Ratio at Proposed Rates",null,null,null,{"$f":"F195/F212","v":0.9999999998973288},1.0000000226607395,0.9999999580556771,1.0000000612335289,0.99999917923399728,0.99999945332325957]
[]
[47,"Current Revenue to Proposed Cost Ratio",null,null,null,{"$f":"F158/F212","v":0.96158012332125564},{"$f":"G158/G212","v":0.9519793714847159},{"$f":"H158/H212","v":0.98943549230853356},0.98541244372977044,0.98267302757035624,0.9581623614942022]
[]
[{"$f":"$A$63","v":"File:  WA 2011 Gas Case / Gas COS Base Case / Summary Exhibits"},null,null,null,null,null,null,null,null,null,"Page 3 of 4"]
[]
[null,{"$f":"$B$3","v":"Sumcost"},{"$f":"$C$3","v":"AVISTA UTILITIES"},null,null,null,null,null,{"$f":"$I$3","v":"Natural Gas Utility"}]
[null,{"$f":"$B$4","v":"Company Base Case"},"Customer Cost Analysis",null,null,null,null,null,{"$f":"$I$4","v":"Washington Jurisdiction"},null,{"$f":"$K$4","v":"2011-05-16"}]
[null,{"$f":"$B$5","v":"UG Storage 87% Sales / 13% Throughput"},{"$f":"$C$5","v":"For the Twelve Months Ended December 31, 2010"}]
[]
[null,{"$f":"$B$7","v":"(b)"},{"$f":"$C$7","v":"(c)"},{"$f":"$D$7","v":"(d)"},{"$f":"$E$7","v":"(e)"},{"$f":"$F$7","v":"(f)"},{"$f":"$G$7","v":"(g)"},{"$f":"$H$7","v":"(h)"},{"$f":"$I$7","v":"(i)"},{"$f":"$J$7","v":"(j)"},{"$f":"$K$7","v":"(k)"}]
[null,null,null,null,null,{"$f":"$F$8","v":" "},{"$f":"$G$8","v":"Residential"},{"$f":"$H$8","v":"Small Firm"},{"$f":"$I$8","v":"Large Firm"},{"$f":"$J$8","v":"Interrupt"},{"$f":"$K$8","v":"Transport"}]
[null,null,null,null,null,{"$f":"$F$9","v":"System"},{"$f":"$G$9","v":"Service"},{"$f":"$H$9","v":"Service"},{"$f":"$I$9","v":"Service"},{"$f":"$J$9","v":"Service"},{"$f":"$K$9","v":"Service"}]
[null,{"$f":"$B$10","v":"Description"},null,null,null,{"$f":"$F$10","v":"Total"},{"$f":"$G$10","v":"Sch 101"},{"$f":"$H$10","v":"Sch 111"},{"$f":"$I$10","v":"Sch 121"},{"$f":"$J$10","v":"Sch 131"},{"$f":"$K$10","v":"Sch 146"}]
[null,"Meter, Services, Meter Reading & Billing Costs by Schedule at Requested Rate of Return"]
[]
[null,"Rate Base"]
[1,"Services",null,null,null,{"$f":"SUM(G242:Q242)","v":90091000},88460185.701536,1418032.9290212239,49526.69805995794,1834.3221503688128,161420.34923245551]
[2,"Services Accum. Depr.",null,null,null,{"$f":"SUM(G243:Q243)","v":-36003000},-35351278.882600933,-566687.45539011806,-19792.317881393989,-733.04881042199963,-64508.29531713597]
[3,"Total Services",null,null,null,{"$f":"SUM(F242:F243)","v":54088000},{"$f":"SUM(G242:G243)","v":53108906.818935066},851345.47363110585,29734.380178563952,1101.2733399468132,96912.053915319542]
[]
[4,"Meters",null,null,null,{"$f":"SUM(G246:Q246)","v":38596000},32697945.974230945,4937531.0981395189,169886.93298710845,40403.74495810103,750232.24968432961]
[5,"Meters Accum. Depr.",null,null,null,{"$f":"SUM(G247:Q247)","v":-7899000},-6691913.0285638468,-1010507.7765624434,-34768.807225234988,-8268.970396518811,-153541.41725195665]
[6,"Total Meters",null,null,null,{"$f":"SUM(F246:F247)","v":30697000},{"$f":"SUM(G246:G247)","v":26006032.945667099},3927023.3215770754,135118.12576187347,32134.77456158222,596690.83243237296]
[]
[7,"Total Rate Base",null,null,null,{"$f":"SUM(G250:Q250)","v":84785000.000000015},{"$f":"G244+G248","v":79114939.764602169},{"$f":"H244+H248","v":4778368.7952081813},164852.50594043743,33236.047901529033,693602.88634769246]
[]
[8,"Return on Rate Base @ 8.23%",null,null,null,{"$f":"SUM(G252:Q252)","v":6977805.5000000009},{"$f":"G250*0.0823","v":6511159.5426267581},{"$f":"H250*0.0823","v":393259.75184563332},13567.361238898,2735.3267422958393,57083.517546415089]
[9,"Revenue Conversion Factor",null,null,null,0.62139999999999995,0.62139999999999995,0.62139999999999995,0.62139999999999995,0.62139999999999995,0.62139999999999995]
[10,"Rate Base Revenue Requirement",null,null,null,{"$f":"SUM(G254:Q254)","v":11229168.81235919},{"$f":"G252/G253","v":10478209.756399676},{"$f":"H252/H253","v":632860.88163120917},21833.539167843581,4401.8776026646919,91862.757557797057]
[]
[null,"Expenses"]
[11,"Services Depr Exp",null,null,null,{"$f":"SUM(G257:Q257)","v":2445000},2400740.9623631164,38484.315985580055,1344.1162464241397,49.782083200894064,4380.8233216786775]
[12,"Meters Depr Exp",null,null,null,{"$f":"SUM(G258:Q258)","v":1198999.9999999998},1015774.619730099,153386.35575368648,5277.6047427594322,1255.1583118655597,23306.261461589573]
[13,"Services Maintenance Exp",null,null,null,895000,878798.83898363565,14087.305851572248,492.01801249472595,18.222889351656519,1603.6142629457736]
[14,"Meters Maintenance Exp",null,null,null,679000.00000000012,575238.5044176291,86863.49921330536,2988.7352963583439,710.8027470865012,13198.458325620784]
[15,"Meter Reading",null,null,null,1456000.0000000002,1432433.8598553152,22962.176326117977,267.32824756242275,9.901046206015657,326.73452479851665]
[16,"Billing",null,null,null,3082000,3032116.1786223087,48605.37598701621,565.86927128254592,20.958121158612812,691.6179982342228]
[]
[17,"Total Expenses",null,null,null,{"$f":"SUM(F257:F263)","v":9756000},9335102.9639721047,364389.02911727835,10935.671816881608,2064.82519886924,43507.509894867544]
[18,"Revenue Conversion Factor",null,null,null,0.95600200000000002,0.95600200000000002,0.95600200000000002,0.95600200000000002,0.95600200000000002,0.95600200000000002]
[19,"Expense Revenue Requirement",null,null,null,{"$f":"SUM(G266:Q266)","v":10204999.571130605},{"$f":"G264/G265","v":9764731.6260552853},{"$f":"H264/H265","v":381159.27489406755},11438.963325266692,2159.8544761090875,45509.852379877389]
[]
[20,"Total Meter, Service, Meter Reading, and Billing Cost",null,null,null,{"$f":"SUM(G268:Q268)","v":21434168.383489795},{"$f":"G254+G266","v":20242941.382454962},{"$f":"H254+H266","v":1014020.1565252767},{"$f":"I254+I266","v":33272.502493110274},{"$f":"J254+J266","v":6561.732078773779},{"$f":"K254+K266","v":137372.60993767445}]
[]
[21,"Total Customer Bills",null,null,null,{"$f":"SUM(G270:Q270)","v":1764662},1736100,27830,324,12,396]
[]
[22,"Average Unit Cost per Month",null,null,null,{"$f":"F268/F270","v":12.14633078940318},{"$f":"G268/G270","v":11.660008860350764},36.436225530911848,102.6929089293527,546.81100656448154,346.90053014564256]
[]
[null," Fixed Costs per Customer"]
[]
[23,"Total Customer Related Cost",null,null,null,{"$f":"SUM(G276:Q276)","v":30285621.141919404},{"$f":"G211","v":28331499.928902414},{"$f":"H211","v":1642213.2842522766},57837.886714368571,12002.599146084935,242067.44290426001]
[24,"Customer Related Unit Cost per Month",null,null,null,{"$f":"F276/F270","v":17.162278749085889},{"$f":"G276/G270","v":16.319048400957556},{"$f":"H276/H270","v":59.008741798500779},178.51199603200178,1000.2165955070778,611.28142147540404]
[]
[25,"Other Non-Gas Costs",null,null,null,{"$f":"SUM(G279:Q279)","v":31715762.590399425},{"$f":"G131-G276","v":21020586.040342037},{"$f":"H131-H276","v":8155920.9667235296},{"$f":"I131-I276","v":836659.52795495931},{"$f":"J131-J276","v":67851.309551717583},{"$f":"K131-K276","v":1634744.7458271866}]
[26,"Other Non-Gas Unit Cost per Month",null,null,null,{"$f":"F279/F270","v":17.97271238934109},{"$f":"G279/G270","v":12.107935050021334},293.06219787005136,2582.2824936881461,5654.2757959764649,4128.1432975434009]
[]
[27,"Total Fixed Unit Cost per Month",null,null,null,{"$f":"F277+F280","v":35.134991138426983},{"$f":"G277+G280","v":28.426983450978888},352.07093966855211,2760.7944897201478,6654.4923914835426,4739.4247190188053]
[]
[]
[]
[]
[{"$f":"A229","v":"File:  WA 2011 Gas Case / Gas COS Base Case / Summary Exhibits"},null,null,null,null,null,null,null,null,null,"Page 4 of 4"]