{"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 UG-12____","Cost of Service General Summary",null,null,null,null,null,"Washington Jurisdiction",null,"2012-04-02"]
[null,"UG Storage 87% Sales / 13% Throughput","For the Twelve Months Ended December 31, 2011",null,null,null,null,null,null,null," "]
[null," "]
[null,"(b)","(c)","(d)","(e)","(f)","(g)","(h)","(i)","(j)","(k)"]
[null," "," "," "," "," ","General","Large General","High Load Factor","Interruptible","Transportation"]
[null," ",null,null,null,"System","Service","Service","Lg. Gen. Service","Service","Service"]
[null,"Description",null,null,null,"Total","Sch 101","Sch 111/112","Sch 121/122","Sch 131/132","Sch 146"]
[null,"Plant In Service"]
[1," Production Plant"]
[2," Underground Storage Plant",null,null,null,{"$f":"SUM(G13:K13)","v":24692999.999999996},16810767.431081217,6436148.1520863082,884854.21522159013,90802.455042609174,470427.74656827503]
[3," Distribution Plant",null,null,null,{"$f":"SUM(G14:K14)","v":302336000},240240570.86960176,48321633.103192501,3989080.7545104488,261845.29578380959,9522869.9769114889]
[4," Intangible Plant",null,null,null,{"$f":"SUM(G15:K15)","v":6528000.0000000009},5139664.3715700218,1085497.5756678674,95595.405831946919,6828.8236066273839,200413.82332353722]
[5," General Plant",null,null,null,{"$f":"SUM(G16:K16)","v":45975000},36137270.023067981,7698060.3959020255,685196.60407312657,49576.582945991344,1404896.3940108733]
[6,"   Total Plant In Service",null,null,null,{"$f":"SUM(F13:F16)","v":379532000},298328272.69532096,63541339.226848699,5654726.9796371125,409053.15737903753,11598607.940814175]
[]
[null,"Accum Depreciation"]
[7," Production Plant"]
[8," Underground Storage Plant",null,null,null,{"$f":"SUM(G21:K21)","v":-9073999.9999999981},-6177495.7951496765,-2365107.8577747205,-325159.64641480218,-33367.410887969694,-172869.28977283143]
[9," Distribution Plant",null,null,null,{"$f":"SUM(G22:K22)","v":-110234999.99999999},-87733970.817942709,-17757100.096236736,-1515678.1634261908,-78160.126847702035,-3150090.79554665]
[10," Intangible Plant",null,null,null,{"$f":"SUM(G23:K23)","v":-2644000},-2078838.5246085683,-442178.84912146674,-39285.661413579415,-2836.266809972019,-80860.698046413658]
[11," General Plant",null,null,null,{"$f":"SUM(G24:K24)","v":-13113999.999999998},-10307866.429200945,-2195809.9843797535,-195446.8355805325,-14141.3226482595,-400735.42819050787]
[12,"   Total Accumulated Depreciation",null,null,null,{"$f":"SUM(F21:F24)","v":-135066999.99999997},-106298171.56690191,-22760196.787512675,-2075570.3068351049,-128505.12719390326,-3804556.211556403]
[]
[13,"Net Plant",null,null,null,{"$f":"F17+F25","v":244465000.00000003},192030101.12841904,40781142.439336024,3579156.6728020078,280548.03018513427,7794051.7292577717]
[14,"Accumlulated Deferred FIT",null,null,null,{"$f":"SUM(G28:K28)","v":-47850999.999999993},-37612918.480507053,-8011225.9923904631,-712942.09896033921,-51572.996832267956,-1462340.4313098737]
[15,"Miscellaneous Rate Base",null,null,null,{"$f":"SUM(G29:K29)","v":13390000},9009274.237248905,3584404.0156382862,501006.3313541495,51869.108502491879,243446.30725616799]
[16,"   Total Rate Base",null,null,null,{"$f":"SUM(F27:F29)","v":210004000.00000003},163426456.88516089,36354320.462583847,3367220.9051958183,280844.1418553582,6575157.6052040663]
[]
[17,"Revenue From Retail Rates",null,null,null,{"$f":"SUM(G32:K32)","v":144082999.99999997},105607336.82815644,32015273.799189311,3894069.7031445685,365057.53474746284,2201262.1347622056]
[18,"Other Operating Revenues",null,null,null,{"$f":"SUM(G33:K33)","v":1634999.9999999981},1272613.5860287994,282839.68703258038,26173.122315415647,2179.4617927138461,51194.142830488738]
[19,"   Total Revenues",null,null,null,{"$f":"SUM(F32:F33)","v":145717999.99999997},106879950.41418524,32298113.486221891,3920242.8254599841,367236.99654017668,2252456.2775926944]
[]
[null,"Operating Expenses"]
[20," Purchased Gas Costs",null,null,null,{"$f":"SUM(G37:K37)","v":81055999.999999985},56438315.471480943,21453894.810973831,2844838.6484632031,278541.38361463422,40409.685467382827]
[21," Underground Storage Expenses",null,null,null,785000,534420.78457047569,204607.63371756175,28129.857001941775,2886.6450900436644,14955.079619977154]
[22," Distribution Expenses",null,null,null,9663000,7789701.7326101586,1453812.6677640225,112551.27422827957,8897.6621721169649,298036.6632254225]
[23," Customer Accounting Expenses",null,null,null,6071000.0000000009,5805563.5134271309,233639.13008345186,18706.599777323077,1701.1594356955095,11389.597276398961]
[24," Customer Information Expenses",null,null,null,857000,842754.80521788925,13874.976867567739,150.4010277831058,5.7846549147348387,214.03223184518905]
[25," Sales Expenses",null,null,null,3000.0000000000005,2950.133507180476,48.570514122174117,0.52649134579850343,2.0249667146096287E-2,0.7492376844055626]
[26," Admin & General Expenses",null,null,null,12161000.016533537,8928082.9975825008,2071398.5819583652,241605.16998011537,23217.174356293512,896696.09265626268]
[27,"   Total O&M Expenses",null,null,null,{"$f":"SUM(F37:F43)","v":110596000.01653352},80341789.438396275,25431276.371878926,3245982.4769699918,315249.8295733658,1261701.8997149738]
[]
[28,"Taxes Other Than Income Taxes",null,null,null,{"$f":"SUM(G46:K46)","v":7955000},5962049.7648207033,1634181.5631455956,185418.35746307831,16592.574047761937,156757.74052286008]
[29,"Depreciation Expense"]
[30," Underground Storage Plant Depr",null,null,null,{"$f":"SUM(G48:K48)","v":367000},249850.226671802,95657.326846299562,13151.156076067045,1349.55254528156,6991.7378605498297]
[31," Distribution Plant Depreciation",null,null,null,{"$f":"SUM(G49:K49)","v":7552000},5980991.606643199,1228987.2866861317,101682.473872118,6293.3414602162893,234045.29133833564]
[32," General Plant Depreciation",null,null,null,{"$f":"SUM(G50:K50)","v":3529000},2773864.6201502322,590896.25094373559,52595.080277848036,3805.4542950821847,107838.59433310218]
[33," Amortization of Intangible Plant",null,null,null,{"$f":"SUM(G51:K51)","v":639000.00000000012},502464.46061469306,106819.16017878371,9484.132287283519,684.17581747758231,19548.071101762165]
[34,"   Total Depr & Amort Expense",null,null,null,{"$f":"SUM(F48:F51)","v":12087000},9507170.914079925,2022360.0246549505,176912.8425133166,12132.524118057616,368423.69463374984]
[35,"Income Tax",null,null,null,{"$f":"SUM(G53:K53)","v":4019000.0000000088},2824737.9907626482,968319.84179558686,96316.288269699871,6781.423569625963,122844.45560244743]
[36,"   Total Operating Expenses",null,null,null,{"$f":"F44+F46+F52+F53","v":134657000.01653352},98635748.108059555,30056137.801475059,3704629.9652160867,350756.35130881128,1909727.7904740311]
[]
[37,"Net Income",null,null,null,{"$f":"F34-F54","v":11060999.983466446},8244202.3061256856,2241975.6847468317,215612.86024389742,16480.645231365401,342728.48711866327]
[]
[38,"Rate of Return",null,null,null,{"$f":"F56/F30","v":5.2670425246502187E-2},5.0445946533117667E-2,6.1670130433445748E-2,6.4032882401981461E-2,5.8682531608059488E-2,5.2124756195562914E-2]
[39,"Return Ratio",null,null,null,{"$f":"F58/$F58","v":1},0.95776607644662515,1.1708682841428402,1.2157274618972977,1.1141457721941701,0.98963993458595612]
[]
[40,"Interest Expense",null,null,null,{"$f":"SUM(G61:K61)","v":6236999.9999999991},4853673.3185689254,1079702.751972036,100004.5560356294,8340.9121385872131,195278.46128482188]
[]
["File:  WA 2012 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 UG-12____"},"Summary by Function with Margin Analysis",null,null,null,null,null,{"$f":"$I$4","v":"Washington Jurisdiction"},null,{"$f":"$K$4","v":"2012-04-02"}]
[null,{"$f":"$B$5","v":"UG Storage 87% Sales / 13% Throughput"},{"$f":"$C$5","v":"For the Twelve Months Ended December 31, 2011"}]
[]
[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":" "},"General","Large General","High Load Factor","Interruptible","Transportation"]
[null,null,null,null,null,"System","Service","Service","Lg. Gen. Service","Service","Service"]
[null,{"$f":"$B$10","v":"Description"},null,null,null,"Total","Sch 101","Sch 111/112","Sch 121/122","Sch 131/132","Sch 146"]
[]
[null,"Functional Cost Components at Current Rates"]
[1,"Production",null,null,null,{"$f":"SUM(G74:K74)","v":85018284.08362937},59197206.103877105,22502631.806894928,2983903.7256604428,292157.40329150413,42385.043905399507]
[2,"Underground Storage",null,null,null,{"$f":"SUM(G75:K75)","v":3122051.6003343882},2003079.4008570653,918253.68423924176,130623.69761123125,12386.520160511789,57708.297466338336]
[3,"Distribution",null,null,null,{"$f":"SUM(G76:K76)","v":36792216.623584375},30090389.363361899,5285910.8153300686,425418.81076454272,29371.281491028665,961126.35263683973]
[4,"Common",null,null,null,{"$f":"SUM(G77:K77)","v":19150447.692451838},14316661.960060375,3308477.4927250678,354123.46910835156,31142.329804418241,1140042.440753628]
[5,"     Total Current Rate Revenue",null,null,null,{"$f":"SUM(F74:F77)","v":144082999.99999997},105607336.82815644,32015273.799189307,3894069.7031445685,365057.53474746284,2201262.1347622056]
[6,"Exclude Cost of Gas w / Revenue Exp.",null,null,null,{"$f":"SUM(G79:K79)","v":83918005.510744825},58447653.755179673,22219939.892003421,2945496.4494320513,288236.23033425806,16679.183795444304]
[7,"     Total Margin Revenue at Current Rates",null,null,null,{"$f":"F78-F79","v":60164994.489255145},47159683.072976768,9795333.9071858861,948573.25371251721,76821.30441320478,2184582.9509667614]
[]
[null,"Margin per Therm at Current Rates"]
[8,"Production",null,null,null,5.4753640514182715E-3,6.2974570879691157E-3,6.2035193699516641E-3,6.1304530709174309E-3,6.0991483302293113E-3,8.729045638037658E-4]
[9,"Underground Storage",null,null,null,1.5536400981006428E-2,1.6829120197693118E-2,2.0150574588925906E-2,2.0849758868435594E-2,1.9266485966840809E-2,1.959624615252752E-3]
[10,"Distribution",null,null,null,0.18309070560615778,0.25280814089283271,0.11599642014283225,6.7904061703538091E-2,4.5685259083423933E-2,3.2637366577897675E-2]
[11,"Common",null,null,null,9.5299204626808243E-2,0.12028321236417598,7.2602728022999621E-2,5.6524115268408955E-2,4.8440018049973541E-2,3.8712894460918329E-2]
[12,"     Total Current Margin Melded Rate per Therm",null,null,null,{"$f":"SUM(F83:F86)","v":0.29940167526539074},0.39621793054267096,0.21495324212470945,0.15140838891130007,0.1194909114304676,7.4182790217872524E-2]
[]
[null,"Functional Cost Components at Uniform Current Return"]
[13,"Production",null,null,null,{"$f":"SUM(G90:K90)","v":85018284.08362937},59197206.103877105,22502631.806894928,2983903.7256604428,292157.40329150413,42385.043905399507]
[14,"Underground Storage",null,null,null,{"$f":"SUM(G91:K91)","v":3057369.8845998091},2081429.3152228973,796893.27068446088,109558.44287367625,11242.728364111343,58246.127454663074]
[15,"Distribution",null,null,null,{"$f":"SUM(G92:K92)","v":36852457.410220362},30616256.599490702,4859892.830255229,382104.33203458699,27620.329562539577,966583.31887731142]
[16,"Common",null,null,null,{"$f":"SUM(G93:K93)","v":19154888.621550433},14411433.438302608,3226778.8933311305,344939.53732623323,30790.602624025778,1140946.1499664374]
[17,"     Total Uniform Current Cost",null,null,null,{"$f":"SUM(F90:F93)","v":144082999.99999997},106306325.45689331,31386196.801165748,3820506.0378949391,361811.06384218083,2208160.6402038112]
[18,"Exclude Cost of Gas w / Revenue Exp.",null,null,null,{"$f":"SUM(G95:K95)","v":83918005.510744825},58447653.755179673,22219939.892003421,2945496.4494320513,288236.23033425806,16679.183795444304]
[19,"     Total Uniform Current Margin",null,null,null,{"$f":"F94-F95","v":60164994.489255145},47858671.701713637,9166256.9091623276,875009.5884628878,73574.833507922769,2191481.456408367]
[]
[null,"Margin per Therm at Uniform Current Return"]
[20,"Production",null,null,null,5.4753640514182715E-3,6.2974570879691157E-3,6.2035193699516641E-3,6.1304530709174309E-3,6.0991483302293113E-3,8.729045638037658E-4]
[21,"Underground Storage",null,null,null,1.5214522549630001E-2,1.7487386727605695E-2,1.7487386727605699E-2,1.7487386727605699E-2,1.7487386727605699E-2,1.9778879314519002E-3]
[22,"Distribution",null,null,null,0.18339048444917491,0.25722627974496887,0.10664768859748963,6.0990335836433943E-2,4.2961758833015104E-2,3.2822671046040565E-2]
[23,"Common",null,null,null,9.5321304215167588E-2,0.12107944670115194,7.0809896968624692E-2,5.505820390145906E-2,4.7892927608318148E-2,3.8743582089841792E-2]
[24,"     Total Current Uniform Margin Melded Rate per Therm",null,null,null,{"$f":"SUM(F99:F102)","v":0.2994016752653908},0.40209057026169565,0.20114849166367169,0.13966637953641614,0.11444122149916826,7.4417045631138018E-2]
[]
[25,"Margin to Cost Ratio at Current Rates",null,null,null,{"$f":"F80/F96","v":1},0.98539473403914302,1.0686296494040823,1.0840718390056243,1.044124746880092,0.9968521269384083]
[]
[]
[null,"Functional Cost Components at Proposed Rates"]
[26,"Production",null,null,null,{"$f":"SUM(G109:K109)","v":85007207.754838273},59189493.789692119,22499700.125183813,2983514.9775328762,292119.34052074264,42379.521908723364]
[27,"Underground Storage",null,null,null,{"$f":"SUM(G110:K110)","v":4484516.5861601597},2833170.2927340721,1351375.7049055272,208824.67290869306,21406.923955839899,69738.991656028156]
[28,"Distribution",null,null,null,{"$f":"SUM(G111:K111)","v":44178178.41771023},35659606.506946787,6806053.6247343551,586195.60255178961,43178.638984499383,1083144.0444927972]
[29,"Common",null,null,null,{"$f":"SUM(G112:K112)","v":20501097.241291329},15319184.238783475,3599700.3443656089,388178.45015120954,33912.631286380907,1160121.5767046567]
[30,"     Total Proposed Rate Revenue",null,null,null,{"$f":"SUM(F109:F112)","v":154171000},113001454.82815646,34256829.799189307,4166713.7031445685,390617.53474746284,2355384.1347622052]
[31,"Exclude Cost of Gas w / Revenue Exp.",null,null,null,{"$f":"SUM(G114:K114)","v":83907072.528145298},58440039.093968399,22217045.039882906,2945112.7050707228,288198.67842067737,16677.010802591332]
[32,"     Total Margin Revenue at Proposed Rates",null,null,null,{"$f":"F113-F114","v":70263927.471854702},54561415.734188057,12039784.759306401,1221600.9980738456,102418.85632678546,2338707.123959614]
[]
[null,"Margin per Therm at Proposed Rates"]
[33,"Production",null,null,null,5.4746507115391047E-3,6.2966366443903193E-3,6.2027111647408361E-3,6.1296543849101532E-3,6.0983537226577279E-3,8.7279084029056925E-4]
[34,"Underground Storage",null,null,null,2.2316494666870954E-2,2.3803231852194261E-2,2.965520030765963E-2,3.3331961623721679E-2,3.3297180696743527E-2,2.3681558925174517E-3]
[35,"Distribution",null,null,null,0.2198457880819383,0.29959860994580217,0.14935512220140157,9.3566766110985133E-2,6.7161771932866265E-2,3.6780771997139743E-2]
[36,"Common",null,null,null,0.10202050064040977,0.12870602771651665,7.899345413137808E-2,6.1959868167748747E-2,5.2749055126933071E-2,3.9394730016465498E-2]
[37,"     Total Proposed Margin Melded Rate per Therm",null,null,null,{"$f":"SUM(F118:F121)","v":0.34965743410075811},0.45840450615890338,0.26420648780518013,0.19498825028736572,0.15930636147920058,7.9416448746413265E-2]
[]
[null,"Functional Cost Components at Uniform Proposed Return"]
[38,"Production",null,null,null,{"$f":"SUM(G125:K125)","v":85007207.754838273},59189493.789692119,22499700.125183813,2983514.9775328762,292119.34052074264,42379.521908723364]
[39,"Underground Storage",null,null,null,{"$f":"SUM(G126:K126)","v":4351948.3205160853},2962766.4151087515,1134320.8253782336,155948.64195663456,16003.223250371373,82909.21482209416]
[40,"Distribution",null,null,null,{"$f":"SUM(G127:K127)","v":44302691.901148632},36529426.917572565,6044114.2104035039,477471.65183144569,34906.48648175018,1216772.6348593656]
[41,"Common",null,null,null,{"$f":"SUM(G128:K128)","v":20509152.040836506},15475942.752067387,3453581.2011493156,365125.80411284277,32250.940392285884,1182251.3431146746]
[42,"     Total Uniform Proposed Cost",null,null,null,{"$f":"SUM(F125:F128)","v":154171000.0173395},114157629.87444082,33131716.362114862,3982061.0754337991,375279.99064515001,2524312.7147048577]
[43,"Exclude Cost of Gas w / Revenue Exp.",null,null,null,{"$f":"SUM(G130:K130)","v":83907072.528145298},58440039.093968399,22217045.039882906,2945112.7050707228,288198.67842067737,16677.010802591332]
[44,"     Total Uniform Proposed Margin",null,null,null,{"$f":"F129-F130","v":70263927.489194199},55717590.78047242,10914671.322231956,1036948.3703630762,87081.31222447264,2507635.7039022665]
[]
[null,"Margin per Therm at Uniform Proposed Return"]
[45,"Production",null,null,null,5.4746507115391047E-3,6.2966366443903193E-3,6.2027111647408361E-3,6.1296543849101532E-3,6.0983537226577279E-3,8.7279084029056925E-4]
[46,"Underground Storage",null,null,null,2.1656789448615651E-2,2.4892049759095623E-2,2.4892049759095633E-2,2.4892049759095623E-2,2.4892049759095626E-2,2.8153826283200348E-3]
[47,"Distribution",null,null,null,0.22046540993765448,0.30690651408308434,0.13263477872307783,7.6212578492674016E-2,5.429493701518915E-2,4.131845351748957E-2]
[48,"Common",null,null,null,0.1020605840892362,0.13002305382189114,7.5786949496780026E-2,5.8280274648586122E-2,5.0164395038591832E-2,4.0146199681848717E-2]
[49,"     Total Proposed Uniform Margin Melded Rate per Therm",null,null,null,{"$f":"SUM(F134:F137)","v":0.34965743418704542},0.46811825430846143,0.23951648914369433,0.16551455728526593,0.13544973553553433,8.5152826667948892E-2]
[]
[50,"Margin to Cost Ratio at Proposed Rates",null,null,null,{"$f":"F115/F131","v":0.99999999975322329},{"$f":"G115/G131","v":0.97924937115749144},1.1030826677100862,1.1780731162595062,1.1761289961131578,0.9326343217717894]
[]
[51,"Current Margin to Proposed Cost Ratio",null,null,null,{"$f":"F80/F131","v":0.8562714416797701},{"$f":"G80/G131","v":0.84640563980567918},0.89744653027103938,0.91477385067916606,0.88217899398644495,0.87117237466638986]
[]
[{"$f":"$A$63","v":"File:  WA 2012 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 UG-12____"},"Summary by Classification with Unit Cost Analysis",null,null,null,null,null,{"$f":"I4","v":"Washington Jurisdiction"},null,{"$f":"K4","v":"2012-04-02"}]
[null,{"$f":"B5","v":"UG Storage 87% Sales / 13% Throughput"},{"$f":"C5","v":"For the Twelve Months Ended December 31, 2011"},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":" "},"General","Large General","High Load Factor","Interruptible","Transportation"]
[null,null,null,null,null,"System","Service","Service","Lg. Gen. Service","Service","Service"]
[null,{"$f":"B10","v":"Description"},null,null,null,"Total","Sch 101","Sch 111/112","Sch 121/122","Sch 131/132","Sch 146"]
[]
[null,"Cost by Classification at Current Return by Schedule "]
[1,"Commodity",null,null,null,{"$f":"SUM(G155:K155)","v":82692519.355139166},56140404.657716826,21826351.084496509,3010018.3620353364,289184.13151564752,1426561.1193748394]
[2,"Demand",null,null,null,{"$f":"SUM(G156:K156)","v":32126883.050810091},22095232.89373463,8570037.5995037891,829529.22693480412,65486.798292303167,566596.53234456584]
[3,"Customer",null,null,null,{"$f":"SUM(G157:K157)","v":29263597.57670898},27371699.259363234,1618885.1151890086,54522.114174426861,10386.604939512346,208104.48304280022]
[4,"     Total Current Rate Revenue",null,null,null,{"$f":"SUM(F155:F157)","v":144082999.98265824},105607336.81081469,32015273.799189307,3894069.7031445676,365057.53474746301,2201262.1347622056]
[]
[null,"Revenue per Therm at Current Rates"]
[5,"Commodity ",null,null,null,0.41150637570931697,0.47167057757550424,0.47896733014102644,0.48045001164171741,0.4498084966140371,4.8442328182010636E-2]
[6,"Demand ",null,null,null,0.15987440351524765,0.18563584149763646,0.1880647851925282,0.13240694201894465,0.10186076993071008,1.9240153677153943E-2]
[7,"Customer",null,null,null,0.145625711647387,0.22996672855496145,3.552554792257042E-2,8.7026546815221432E-3,1.6155738312055974E-2,7.0666903273831072E-3]
[8,"     Total Revenue per Therm at Current Rates",null,null,null,{"$f":"SUM(F161:F163)","v":0.71700649087195167},0.88727314762810217,0.70255766325612512,0.62155960834218416,0.56782500485680309,7.4749172186547683E-2]
[]
[null,"Cost per Unit at Current Rates"]
[9,"Commodity Cost per Therm",null,null,null,0.41150637570931697,0.47167057757550424,0.47896733014102644,0.48045001164171741,0.4498084966140371,4.8442328182010636E-2]
[10,"Demand Cost per Peak Day Therms",null,null,null,21.183994246738081,22.46681148895038,23.114161338575908,32.693383791227056,13.07382677027414,4.2939919541690923]
[11,"Customer Cost per Customer per Month",null,null,null,16.46050306737963,15.656573899568047,56.244488593579845,174.75036594367583,865.5504116260289,468.70379063693741]
[]
[null,"Cost by Classification at Uniform Current Return "]
[12,"Commodity",null,null,null,{"$f":"SUM(G172:K172)","v":82551451.378484145},56314743.786985323,21556307.792196076,2963145.3284335774,287471.82015641785,1429782.6507127448]
[13,"Demand",null,null,null,{"$f":"SUM(G173:K173)","v":32018775.348575592},22262323.116487425,8315179.4580312409,807509.61199070129,64451.792500809446,569311.36956541706]
[14,"Customer",null,null,null,{"$f":"SUM(G174:K174)","v":29512773.255598493},27729258.5360788,1514709.5509384314,49851.097470659595,9887.4511849537121,209066.6199256496]
[15,"     Total Uniform Current Cost",null,null,null,{"$f":"SUM(F172:F174)","v":144082999.98265824},106306325.43955155,31386196.801165748,3820506.0378949386,361811.06384218106,2208160.6402038112]
[]
[null,"Cost per Therm at Current Return"]
[16,"Commodity ",null,null,null,0.41080437300998401,0.47313530940808429,0.47304137787191336,0.4729682800271568,0.44714509944146935,4.8551723059103484E-2]
[17,"Demand ",null,null,null,0.15933642246110027,0.18703967074242972,0.18247206274830266,0.12889223779332432,0.10025088076902411,1.9332342531754754E-2]
[18,"Customer",null,null,null,0.14686569540086736,0.23297080719661278,3.323947217487129E-2,7.9570811468191362E-3,1.5379334715010323E-2,7.0993620089549641E-3]
[19,"     Total Cost per Therm at Current Return",null,null,null,{"$f":"SUM(F178:F180)","v":0.71700649087195167},0.8931457873471268,0.68875291279508732,0.60981759896730026,0.56277531492550381,7.4983427599813204E-2]
[]
[null,"Cost per Unit at Uniform Current Return"]
[20,"Commodity Cost per Therm",null,null,null,0.41080437300998401,0.47313530940808429,0.47304137787191336,0.4729682800271568,0.44714509944146935,4.8551723059103484E-2]
[21,"Demand Cost per Peak Day Therms",null,null,null,21.112709617645937,22.636711691147312,22.426786034553068,31.825547313707535,12.867197544581643,4.3145665403476823]
[22,"Customer Cost per Customer per Month",null,null,null,16.600662082891166,15.86109730844842,52.625145083501771,159.7791585598064,823.95426541280938,470.8707655983099]
[]
[23,"Revenue to Cost Ratio at Current Rates",null,null,null,{"$f":"F158/F175","v":1},0.99342476916734068,1.0200431100973724,1.0192549532758131,1.0089728348016964,0.99687590417290983]
[]
[]
[null,"Cost by Classification at Proposed Return by Schedule "]
[24,"Commodity",null,null,null,{"$f":"SUM(G192:K192)","v":85753071.354345724},57980735.488370329,22787528.632780958,3183671.798477143,302652.85049955174,1498482.5842177488]
[25,"Demand",null,null,null,{"$f":"SUM(G193:K193)","v":34954022.165268578},23863175.326457795,9478733.0946091861,911182.80948977463,73642.200263330786,627288.73444849206]
[26,"Customer",null,null,null,{"$f":"SUM(G194:K194)","v":33463906.463046178},31157543.995988823,1990568.0717991604,71859.09517765019,14322.483984580464,229612.81609596469]
[27,"     Total Proposed Rate Revenue",null,null,null,{"$f":"SUM(F192:F194)","v":154170999.98266047},113001454.81081694,34256829.799189307,4166713.7031445676,390617.53474746295,2355384.1347622056]
[]
[null,"Revenue per Therm at Proposed Rates"]
[28,"Commodity ",null,null,null,0.4267367335540756,0.48713234546115891,0.50005984543646254,0.50816804705718066,0.47075827766085465,5.0884595222611025E-2]
[29,"Demand ",null,null,null,0.17394321868364845,0.20048942927362259,0.20800561055160358,0.14544023948447782,0.11454600642914706,2.1301103980983713E-2]
[30,"Customer",null,null,null,0.16652789119343608,0.2617739729883149,4.3681927002944494E-2,1.1469931064247776E-2,2.2277761076022841E-2,7.797057722273259E-3]
[31,"     Total Revenue per Therm at Proposed Rates",null,null,null,{"$f":"SUM(F198:F200)","v":0.76720784343116022},0.94939574772309632,0.75174738299101063,0.66507821760590624,0.60758204516602454,7.9982756925868009E-2]
[]
[null,"Cost per Unit at Proposed Rates"]
[32,"Commodity Cost per Therm",null,null,null,0.4267367335540756,0.48713234546115891,0.50005984543646254,0.50816804705718066,0.47075827766085465,5.0884595222611025E-2]
[33,"Demand Cost per Peak Day Therms",null,null,null,23.048168204750066,24.264485654700891,25.564994726135303,35.911512611428471,14.701976494975202,4.7539521068312638]
[34,"Customer Cost per Customer per Month",null,null,null,18.823137980132927,17.822071822426935,69.15776923180907,230.31761274887882,1193.540332048372,517.14598219811865]
[]
[null,"Cost by Classification at Uniform Proposed Return "]
[35,"Commodity",null,null,null,{"$f":"SUM(G209:K209)","v":85511605.834416717},58269104.343834318,22304552.244018361,3066015.4963615593,294563.25051381142,1577370.4996886742]
[36,"Demand",null,null,null,{"$f":"SUM(G210:K210)","v":34780902.11616566},24139553.994268149,9022915.5708092675,855911.23286549258,68752.445376768737,693768.87284598523]
[37,"Customer",null,null,null,{"$f":"SUM(G211:K211)","v":33878492.049417607},31748971.51899885,1804248.5472872392,60134.346206746137,11964.294754570086,253173.34217019842]
[38,"     Total Uniform Proposed Cost",null,null,null,{"$f":"SUM(F209:F211)","v":154171000},114157629.85710131,33131716.362114869,3982061.0754337981,375279.99064515025,2524312.7147048581]
[]
[null,"Cost per Therm at Proposed Return"]
[39,"Commodity ",null,null,null,0.42553511819951118,0.48955511219112391,0.48946119289251566,0.48938810457107235,0.45817539218673276,5.3563424919379973E-2]
[40,"Demand ",null,null,null,0.1730817138640528,0.20281145895385824,0.19800294443665151,0.13661795787731976,0.10694028725358916,2.3558597640454922E-2]
[41,"Customer",null,null,null,0.1685910114538835,0.2667429247276723,3.9593247000357656E-2,9.5984621554142772E-3,1.8609739782036359E-2,8.5971122875687245E-3]
[42,"     Total Cost per Therm at Proposed Return",null,null,null,{"$f":"SUM(F215:F217)","v":0.76720784351744742},0.95910949587265448,0.72705738432952494,0.63560452460380634,0.58372541922235832,8.5719134847403622E-2]
[]
[null,"Cost per Unit at Uniform Proposed Return"]
[43,"Commodity Cost per Therm",null,null,null,0.42553511819951118,0.48955511219112391,0.48946119289251566,0.48938810457107235,0.45817539218673276,5.3563424919379973E-2]
[44,"Demand Cost per Peak Day Therms",null,null,null,22.93401539016201,24.545512220889439,24.335613913772061,33.733150706084913,13.72578266655395,5.2577765446717741]
[45,"Customer Cost per Customer per Month",null,null,null,19.056338539232666,18.160367542853479,62.684520282362477,192.73828912418634,997.02456288084056,570.21023011305954]
[]
[46,"Revenue to Cost Ratio at Proposed Rates",null,null,null,{"$f":"F195/F212","v":0.99999999988753052},0.989872117634786,1.0339588032439204,1.046371118928821,1.0408696026557283,0.93307937683053521]
[]
[47,"Current Revenue to Proposed Cost Ratio",null,null,null,{"$f":"F158/F212","v":0.93456616343318932},{"$f":"G158/G212","v":0.92510099362618525},{"$f":"H158/H212","v":0.96630290593088075},0.97790305808414935,0.97276045578632198,0.87202434228501535]
[]
[{"$f":"$A$63","v":"File:  WA 2012 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 UG-12____"},"Customer Cost Analysis",null,null,null,null,null,{"$f":"$I$4","v":"Washington Jurisdiction"},null,{"$f":"$K$4","v":"2012-04-02"}]
[null,{"$f":"$B$5","v":"UG Storage 87% Sales / 13% Throughput"},{"$f":"$C$5","v":"For the Twelve Months Ended December 31, 2011"}]
[]
[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":"General"},{"$f":"$H$8","v":"Large General"},{"$f":"$I$8","v":"High Load Factor"},{"$f":"$J$8","v":"Interruptible"},{"$f":"$K$8","v":"Transportation"}]
[null,null,null,null,null,{"$f":"$F$9","v":"System"},{"$f":"$G$9","v":"Service"},{"$f":"$H$9","v":"Service"},{"$f":"$I$9","v":"Lg. Gen. 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/112"},{"$f":"$I$10","v":"Sch 121/122"},{"$f":"$J$10","v":"Sch 131/132"},{"$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":96617000},94810708.322972581,1560947.9490761764,50760.771300257133,1952.3373577021976,192630.61929328347]
[2,"Services Accum. Depr.",null,null,null,{"$f":"SUM(G243:Q243)","v":-40424000},-39668257.897138633,-653091.69083551911,-21238.016281209253,-816.84678004650971,-80595.548964588947]
[3,"Total Services",null,null,null,{"$f":"SUM(F242:F243)","v":56193000},{"$f":"SUM(G242:G243)","v":55142450.425833948},907856.25824065728,29522.75501904788,1135.490577655688,112035.07032869452]
[]
[4,"Meters",null,null,null,{"$f":"SUM(G246:Q246)","v":42154000.000000007},36115694.54033009,5107638.6575236218,166483.01946210311,37928.321239021083,726255.46144516685]
[5,"Meters Accum. Depr.",null,null,null,{"$f":"SUM(G247:Q247)","v":-9159000},-7847028.6638251003,-1109760.9352436033,-36172.55717733554,-8240.8666847320328,-157796.97706922909]
[6,"Total Meters",null,null,null,{"$f":"SUM(F246:F247)","v":32995000.000000007},{"$f":"SUM(G246:G247)","v":28268665.876504987},3997877.7222800185,130310.46228476756,29687.454554289048,568458.48437593773]
[]
[7,"Total Rate Base",null,null,null,{"$f":"SUM(G250:Q250)","v":89188000},{"$f":"G244+G248","v":83411116.302338928},{"$f":"H244+H248","v":4905733.9805206759},159833.21730381544,30822.945131944736,680493.55470463226]
[]
[8,"Return on Rate Base @ 8.23%",null,null,null,{"$f":"SUM(G252:Q252)","v":7358010.0000000009},{"$f":"G250*0.0825","v":6881417.0949429618},{"$f":"H250*0.0825","v":404723.0533929558},13186.240427564775,2542.8929733854407,56140.718263132163]
[9,"Revenue Conversion Factor",null,null,null,0.62095,0.62095,0.62095,0.62095,0.62095,0.62095]
[10,"Rate Base Revenue Requirement",null,null,null,{"$f":"SUM(G254:Q254)","v":11849601.417183347},{"$f":"G252/G253","v":11082079.225288609},{"$f":"H252/H253","v":651780.42256696324},21235.591315830221,4095.1654293992119,90411.012582546362]
[]
[null,"Expenses"]
[11,"Services Depr Exp",null,null,null,{"$f":"SUM(G257:Q257)","v":2354000},2309991.0718846316,38031.314076459828,1236.7477321879719,47.567220468768156,4693.2990862517909]
[12,"Meters Depr Exp",null,null,null,{"$f":"SUM(G258:Q258)","v":1209000},1035818.0646975158,146489.89744617496,4774.824940211668,1087.8051994585683,20829.407716639151]
[13,"Services Maintenance Exp",null,null,null,570000,559343.63252941379,9208.941811207349,299.46737780252511,11.517976069327888,1136.4403055070181]
[14,"Meters Maintenance Exp",null,null,null,810000.00000000012,693972.40066582942,98144.596303888931,3199.0142279333754,728.80249095239071,13955.186311395957]
[15,"Meter Reading",null,null,null,1578000,1551770.2247769302,25548.090428263582,276.93444789001279,10.651324918846646,394.09902199732591]
[16,"Billing",null,null,null,3489000,3431005.2688508932,56487.507924088495,612.30943516365949,23.55036289090998,871.36342696366933]
[]
[17,"Total Expenses",null,null,null,{"$f":"SUM(F257:F263)","v":10010000},9581900.6634052135,373910.34799008316,10399.298161189212,1909.894574758812,41879.795868754911]
[18,"Revenue Conversion Factor",null,null,null,0.95530899999999996,0.95530899999999996,0.95530899999999996,0.95530899999999996,0.95530899999999996,0.95530899999999996]
[19,"Expense Revenue Requirement",null,null,null,{"$f":"SUM(G266:Q266)","v":10478285.03656932},{"$f":"G264/G265","v":10030158.475849399},{"$f":"H264/H265","v":391402.51791837317},10885.79523608509,1999.242731680338,43839.004833781437]
[]
[20,"Total Meter, Service, Meter Reading, and Billing Cost",null,null,null,{"$f":"SUM(G268:Q268)","v":22327886.45375267},{"$f":"G254+G266","v":21112237.701138008},{"$f":"H254+H266","v":1043182.9404853364},{"$f":"I254+I266","v":32121.386551915311},{"$f":"J254+J266","v":6094.4081610795502},{"$f":"K254+K266","v":134250.01741632778}]
[]
[21,"Total Customer Bills",null,null,null,{"$f":"SUM(G270:Q270)","v":1777807},1748256,28783,312,12,444]
[]
[22,"Average Unit Cost per Month",null,null,null,{"$f":"F268/F270","v":12.559229687897883},{"$f":"G268/G270","v":12.076170595804053},36.243023329233793,102.95316202536959,507.86734675662916,302.36490409082836]
[]
[null," Fixed Costs per Customer"]
[]
[23,"Total Customer Related Cost",null,null,null,{"$f":"SUM(G276:Q276)","v":33878492.049417607},{"$f":"G211","v":31748971.51899885},{"$f":"H211","v":1804248.5472872392},60134.346206746137,11964.294754570086,253173.34217019842]
[24,"Customer Related Unit Cost per Month",null,null,null,{"$f":"F276/F270","v":19.056338539232666},{"$f":"G276/G270","v":18.160367542853479},{"$f":"H276/H270","v":62.684520282362477},192.73828912418634,997.02456288084056,570.21023011305954]
[]
[25,"Other Non-Gas Costs",null,null,null,{"$f":"SUM(G279:Q279)","v":36385435.439776592},{"$f":"G131-G276","v":23968619.26147357},{"$f":"H131-H276","v":9110422.7749447171},{"$f":"I131-I276","v":976814.02415633004},{"$f":"J131-J276","v":75117.017469902552},{"$f":"K131-K276","v":2254462.361732068}]
[26,"Other Non-Gas Unit Cost per Month",null,null,null,{"$f":"F279/F270","v":20.466471017256985},{"$f":"G279/G270","v":13.710016874801843},{"$f":"H279/H270","v":316.52095941857056},3130.8141799882374,6259.7514558252124,5077.6179318289824]
[]
[27,"Total Fixed Unit Cost per Month",null,null,null,{"$f":"F277+F280","v":39.522809556489648},{"$f":"G277+G280","v":31.870384417655323},{"$f":"H277+H280","v":379.20547970093304},3323.5524691124238,7256.776018706053,5647.8281619420422]
[]
[]
[]
[]
[{"$f":"A229","v":"File:  WA 2012 Gas Case / Gas COS Base Case / Summary Exhibits"},null,null,null,null,null,null,null,null,null,"Page 4 of 4"]