{"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-14____","Cost of Service General Summary",null,null,null,null,null,"Washington Jurisdiction"]
[null,null,"For the Twelve Months Ended June 30, 2013",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":25325000},17073924.980684992,6741209.2322652452,844171.59689389332,182012.4826472865,483681.70750858623]
[3," Distribution Plant",null,null,null,{"$f":"SUM(G14:K14)","v":344440000},273134637.31711966,55120089.708049834,4596107.8971521277,536862.13894849364,11052302.938729879]
[4," Intangible Plant",null,null,null,{"$f":"SUM(G15:K15)","v":9031000},7100814.6172856232,1499374.4372780914,130705.41855731554,16947.680371952967,283157.84650701587]
[5," General Plant",null,null,null,{"$f":"SUM(G16:K16)","v":69777999.999999985},54764980.622871853,11673786.641400093,1026629.9474951475,135658.14326859044,2176944.6449643085]
[6,"   Total Plant In Service",null,null,null,{"$f":"SUM(F13:F16)","v":448574000},352074357.53796214,75034460.018993273,6597614.860098484,871480.44523632352,13996087.137709789]
[]
[null,"Accum Depreciation"]
[7," Production Plant"]
[8," Underground Storage Plant",null,null,null,{"$f":"SUM(G21:K21)","v":-9821999.9999999981},-6621918.7032690207,-2614497.811621293,-327401.91212998307,-70591.376290686982,-187590.19668901616]
[9," Distribution Plant",null,null,null,{"$f":"SUM(G22:K22)","v":-125660000},-101026867.29842237,-19050594.449612733,-1613962.1761501005,-179081.75120471168,-3789494.3246100792]
[10," Intangible Plant",null,null,null,{"$f":"SUM(G23:K23)","v":-3951999.9999999995},-3104794.6623796774,-658409.83631977439,-57626.11064003488,-7537.1384244352921,-123632.25223607763]
[11," General Plant",null,null,null,{"$f":"SUM(G24:K24)","v":-21671999.999999989},-17009181.404724676,-3625703.0022703838,-318855.86033011606,-42133.384174337079,-676126.34850048018]
[12,"   Total Accumulated Depreciation",null,null,null,{"$f":"SUM(F21:F24)","v":-161106000},-127762762.06879574,-25949205.099824183,-2317846.0592502346,-299343.650094171,-4776843.1220356533]
[]
[13,"Net Plant",null,null,null,{"$f":"F17+F25","v":287468000},224311595.4691664,49085254.919169091,4279768.8008482493,572136.79514215258,9219244.0156741366]
[14,"Accumlulated Deferred FIT",null,null,null,{"$f":"SUM(G28:K28)","v":-54737000.000000007},-42961683.264200412,-9156039.4451297559,-805070.38882594812,-106341.93049731068,-1707864.97134658]
[15,"Miscellaneous Rate Base",null,null,null,{"$f":"SUM(G29:K29)","v":10113000.000000006},6583018.255657278,2890538.638961412,366754.52489758038,80018.41971311596,192670.16077061975]
[16,"   Total Rate Base",null,null,null,{"$f":"SUM(F27:F29)","v":242844000},187932930.46062326,42819754.113000743,3841452.9369198815,545813.28435795777,7704049.2050981764]
[]
[17,"Revenue From Retail Rates",null,null,null,{"$f":"SUM(G32:K32)","v":148485000.00000003},107941456.68724884,33798192.391850777,3762196.8009496848,730099.82668873365,2253054.2932619615]
[18,"Other Operating Revenues",null,null,null,{"$f":"SUM(G33:K33)","v":1949999.9999999977},1509359.0262808949,343591.57435696572,30809.153349889442,4372.4627538379282,61867.783258409705]
[19,"   Total Revenues",null,null,null,{"$f":"SUM(F32:F33)","v":150435000.00000003},109450815.71352974,34141783.966207743,3793005.9542995743,734472.28944257158,2314922.0765203713]
[]
[null,"Operating Expenses"]
[20," Purchased Gas Costs",null,null,null,{"$f":"SUM(G37:K37)","v":80034000.000000015},55195862.996385567,21672187.098261714,2600491.0002032663,531503.90250673308,33955.002642722291]
[21," Underground Storage Expenses",null,null,null,821000.00000000012,553512.03984767525,218540.28745073115,27366.8264975276,5900.5823594638587,15680.263844602146]
[22," Distribution Expenses",null,null,null,10291000,8333749.3215037193,1507566.8615696183,116379.56110010888,17006.748238208755,316297.50758834428]
[23," Customer Accounting Expenses",null,null,null,5909000.0000000009,5631780.8726922208,243506.50681609285,18457.500243894054,3462.3557246631422,11792.764523130158]
[24," Customer Information Expenses",null,null,null,1027000.0000000001,1009522.7080183226,17011.428777906251,191.82602508227339,13.701858934448101,260.33531975451388]
[25," Sales Expenses",null,null,null,5000,4914.9109445877439,82.820977497109311,0.93391443564884813,6.6708173974917725E-2,1.2674553055234368]
[26," Admin & General Expenses",null,null,null,13040000.013916498,9575240.8523251172,2239362.414979741,240822.69411264872,46585.845794368513,937988.20670462132]
[27,"   Total O&M Expenses",null,null,null,{"$f":"SUM(F37:F43)","v":111127000.01391651},80304583.701717198,25898257.4188333,3003710.3420969634,604473.20319054578,1315975.3480784802]
[]
[28,"Taxes Other Than Income Taxes",null,null,null,{"$f":"SUM(G46:K46)","v":8970000.0000000019},6685557.9019666184,1872607.5407269872,197295.094308684,35711.603948627853,178827.85904908308]
[29,"Depreciation Expense"]
[30," Underground Storage Plant Depr",null,null,null,{"$f":"SUM(G48:K48)","v":392000},264283.45873360377,104345.66708975229,13066.742980549108,2817.3304322896865,7486.8007638051668]
[31," Distribution Plant Depreciation",null,null,null,{"$f":"SUM(G49:K49)","v":8810000},7101024.7903755726,1323403.1632657372,107351.78311997335,13191.043482632878,265029.21975608304]
[32," General Plant Depreciation",null,null,null,{"$f":"SUM(G50:K50)","v":5080999.9999999991},3987802.2663993221,850046.00196270866,74755.750569274634,9878.171142017658,158517.80992667677]
[33," Amortization of Intangible Plant",null,null,null,{"$f":"SUM(G51:K51)","v":1394999.9999999998},1094860.0987260488,233382.04541192253,20524.359780385377,2712.0741474344882,43521.421934208636]
[34,"   Total Depr & Amort Expense",null,null,null,{"$f":"SUM(F48:F51)","v":15678000},12447970.614234548,2511176.8777301209,215698.63645018247,28598.619204374711,474555.2523807736]
[35,"Income Tax",null,null,null,{"$f":"SUM(G53:K53)","v":3472000.0000000075},2105597.9499858073,1168387.8115307468,117923.04687449083,22087.438053482925,58003.753555478943]
[36,"   Total Operating Expenses",null,null,null,{"$f":"F44+F46+F52+F53","v":139247000.01391649},101543710.16790417,31450429.648821153,3534627.1197303212,690870.86439703126,2027362.2130638158]
[]
[37,"Net Income",null,null,null,{"$f":"F34-F54","v":11187999.986083537},7907105.5456255674,2691354.3173865899,258378.83456925303,43601.425045540323,287559.86345655541]
[]
[38,"Rate of Return",null,null,null,{"$f":"F56/F30","v":4.6070728476237985E-2},4.2074082100700856E-2,6.2853100704038212E-2,6.7260705470577484E-2,7.9883407559104835E-2,3.7325808260188921E-2]
[39,"Return Ratio",null,null,null,{"$f":"F58/$F58","v":1},0.913249768177673,1.3642740799389814,1.4599444744024117,1.7339297684495374,0.81018489385164694]
[]
[40,"Interest Expense",null,null,null,{"$f":"SUM(G61:K61)","v":6701999.9999999981},5186566.2727804538,1181738.0378569411,106016.28034144166,15063.335440723398,212616.07358043839]
[]
["File:  WA 2014 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-14____"},"Summary by Function with Margin Analysis",null,null,null,null,null,{"$f":"$I$4","v":"Washington Jurisdiction"}]
[null,null,{"$f":"$C$5","v":"For the Twelve Months Ended June 30, 2013"}]
[]
[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":84243777.620245993},58099157.955682211,22812141.220610291,2737276.4765546522,559460.93619049562,35741.031208340974]
[2,"Underground Storage",null,null,null,{"$f":"SUM(G75:K75)","v":2731028.7904487276},1645318.5815217388,894944.02813286812,118586.49320792688,29592.393542410369,42587.29404378355]
[3,"Distribution",null,null,null,{"$f":"SUM(G76:K76)","v":39014445.683969013},31446438.943362925,6065210.4252425767,502762.15178085206,70775.451004766932,929258.71257789165]
[4,"Common",null,null,null,{"$f":"SUM(G77:K77)","v":22495747.905336287},16750541.206681978,4025896.7178650484,403571.67940625321,70271.045951060762,1245467.2554319452]
[5,"     Total Current Rate Revenue",null,null,null,{"$f":"SUM(F74:F77)","v":148485000.00000003},107941456.68724886,33798192.391850784,3762196.8009496843,730099.82668873365,2253054.2932619611]
[6,"Exclude Cost of Gas w / Revenue Exp.",null,null,null,{"$f":"SUM(G79:K79)","v":83322752.738099441},57475689.650526948,22570257.839590978,2707403.1047847024,553058.41203750914,16343.731159319255]
[7,"     Total Margin Revenue at Current Rates",null,null,null,{"$f":"F78-F79","v":65162247.261900589},50465767.036721908,11227934.552259807,1054793.6961649819,177041.41465122451,2236710.5621026419]
[]
[null,"Margin per Therm at Current Rates"]
[8,"Production",null,null,null,4.7055253102272713E-3,5.4325060600595634E-3,5.3381089265164645E-3,5.2646889337608395E-3,5.2332232225797077E-3,6.745453887230399E-4]
[9,"Underground Storage",null,null,null,1.3952853332762661E-2,1.4336259102408693E-2,1.9750462744388492E-2,2.0898913028401241E-2,2.4187897991079538E-2,1.4809825461701406E-3]
[10,"Distribution",null,null,null,0.19932519217346376,0.27400425765760394,0.13385274248999784,8.8603534852968749E-2,5.7849642568537953E-2,3.2315176747072016E-2]
[11,"Common",null,null,null,0.11493100044631437,0.1459535566798639,8.8847258196514359E-2,7.1122850507508995E-2,5.7437357635663405E-2,4.3311398588151959E-2]
[12,"     Total Current Margin Melded Rate per Therm",null,null,null,{"$f":"SUM(F83:F86)","v":0.33291457126276808},0.4397265794999361,0.24778857235741714,0.18588998732263984,0.1447081214178606,7.7782103270117156E-2]
[]
[null,"Functional Cost Components at Uniform Current Return"]
[13,"Production",null,null,null,{"$f":"SUM(G90:K90)","v":84243777.620245993},58099157.955682211,22812141.220610291,2737276.4765546522,559460.93619049562,35741.031208340974]
[14,"Underground Storage",null,null,null,{"$f":"SUM(G91:K91)","v":2617698.6110083912},1764832.762345531,696799.76481017459,87257.129975987365,18813.576426929543,49995.377449768726]
[15,"Distribution",null,null,null,{"$f":"SUM(G92:K92)","v":39110419.9199972},32485799.72926715,5139632.1557128858,406321.9188039219,52203.855074063198,1026462.2611391789]
[16,"Common",null,null,null,{"$f":"SUM(G93:K93)","v":22513103.848748475},16994178.234627299,3807764.5451479154,379344.63926500967,65160.158754635013,1266656.2709536194]
[17,"     Total Uniform Current Cost",null,null,null,{"$f":"SUM(F90:F93)","v":148485000.00000006},109343968.6819222,32456337.686281268,3610200.1645995709,695638.52644612337,2378854.9407509081]
[18,"Exclude Cost of Gas w / Revenue Exp.",null,null,null,{"$f":"SUM(G95:K95)","v":83322752.738099441},57475689.650526948,22570257.839590978,2707403.1047847024,553058.41203750914,16343.731159319255]
[19,"     Total Uniform Current Margin",null,null,null,{"$f":"F94-F95","v":65162247.261900619},51868279.031395249,9886079.8466902897,902797.05981486849,142580.11440861423,2362511.2095915889]
[]
[null,"Margin per Therm at Uniform Current Return"]
[20,"Production",null,null,null,4.7055253102272713E-3,5.4325060600595634E-3,5.3381089265164645E-3,5.2646889337608395E-3,5.2332232225797077E-3,6.745453887230399E-4]
[21,"Underground Storage",null,null,null,1.3373848315519006E-2,1.5377629619914984E-2,1.5377629619914977E-2,1.5377629619914979E-2,1.5377629619914981E-2,1.7386002810174702E-3]
[22,"Distribution",null,null,null,0.199815525502687,0.28306058613705543,0.1134262146237795,7.1607534828837069E-2,4.2669800246570071E-2,3.5695451593768489E-2]
[23,"Common",null,null,null,0.11501967213433498,0.14807645470021838,8.4033313172946211E-2,6.6853234372055301E-2,5.3259878109585455E-2,4.4048251277732695E-2]
[24,"     Total Current Uniform Margin Melded Rate per Therm",null,null,null,{"$f":"SUM(F99:F102)","v":0.33291457126276824},0.45194717651724836,0.21817526634315715,0.15910308775456819,0.11654053119865021,8.2156848541241695E-2]
[]
[25,"Margin to Cost Ratio at Current Rates",null,null,null,{"$f":"F80/F96","v":0.99999999999999956},0.9729601208896016,1.1357317284887953,1.1683619089114918,1.2416978018677214,0.94675130133638841]
[]
[]
[null,"Functional Cost Components at Proposed Rates"]
[26,"Production",null,null,null,{"$f":"SUM(G109:K109)","v":84208788.853442684},58075027.771274492,22802666.708521694,2736139.6100581605,559228.57661706617,35726.186971275827]
[27,"Underground Storage",null,null,null,{"$f":"SUM(G110:K110)","v":3925504.3166255844},2446135.3912670077,1216780.9786250605,158953.12607502099,38416.219666671721,65218.600991823259]
[28,"Distribution",null,null,null,{"$f":"SUM(G111:K111)","v":47910457.59748967},38403662.784484364,7567803.4366110396,626964.3397282036,85970.434199820287,1226056.6024662443]
[29,"Common",null,null,null,{"$f":"SUM(G112:K112)","v":24575249.232442066},18377491.740222983,4378936.268092989,434657.72508829919,74431.596205175461,1309731.902832618]
[30,"     Total Proposed Rate Revenue",null,null,null,{"$f":"SUM(F109:F112)","v":160620000},117302317.68724886,35966187.391850784,3956714.8009496843,758046.82668873365,2636733.2932619611]
[31,"Exclude Cost of Gas w / Revenue Exp.",null,null,null,{"$f":"SUM(G114:K114)","v":83288146.498359069},57451818.40972022,22560883.788348883,2706278.6455243062,552828.71160913317,16336.943156520912]
[32,"     Total Margin Revenue at Proposed Rates",null,null,null,{"$f":"F113-F114","v":77331853.501640931},59850499.277528636,13405303.603501901,1250436.1554253781,205218.11507960048,2620396.3501054402]
[]
[null,"Margin per Therm at Proposed Rates"]
[33,"Production",null,null,null,4.7035709756469667E-3,5.4302497903022081E-3,5.3358918624948704E-3,5.2625023630893516E-3,5.2310497204868548E-3,6.7426523139900972E-4]
[34,"Underground Storage",null,null,null,2.0055440711045772E-2,2.1314067173751387E-2,2.6853061902153853E-2,2.8012866116293139E-2,3.1400217801532827E-2,2.2679912383074671E-3]
[35,"Distribution",null,null,null,0.24477500577849295,0.33462507890154986,0.16701337193508908,0.11049212143337821,7.0269547128518392E-2,4.2636388848805419E-2]
[36,"Common",null,null,null,0.12555519346978844,0.16012976830088227,9.6638465540084012E-2,7.6601253211996428E-2,6.0838061434396726E-2,4.5546215879861698E-2]
[37,"     Total Proposed Margin Melded Rate per Therm",null,null,null,{"$f":"SUM(F118:F121)","v":0.39508921093497412},0.52149916416648567,0.29584079123982182,0.22036874312475713,0.16773887608493482,9.1124861198373597E-2]
[]
[null,"Functional Cost Components at Uniform Proposed Return"]
[38,"Production",null,null,null,{"$f":"SUM(G125:K125)","v":84208788.853442684},58075027.771274492,22802666.708521694,2736139.6100581605,559228.57661706617,35726.186971275827]
[39,"Underground Storage",null,null,null,{"$f":"SUM(G126:K126)","v":3809625.9006319321},2568421.1977044069,1014076.4182750947,126988.2716724499,27380.038228289148,72759.974751691538]
[40,"Distribution",null,null,null,{"$f":"SUM(G127:K127)","v":48008582.488032661},39467127.145011581,6620922.951411495,528567.89346673375,66955.406846103942,1325009.0912967462]
[41,"Common",null,null,null,{"$f":"SUM(G128:K128)","v":24593002.772535149},18626778.897905394,4155783.7759272219,409939.2587413484,69198.677063254872,1331302.1628979265]
[42,"     Total Uniform Proposed Cost",null,null,null,{"$f":"SUM(F125:F128)","v":160620000.01464242},118737355.01189588,34593449.854135506,3801635.0339386929,722762.6987547141,2764797.4159176401]
[43,"Exclude Cost of Gas w / Revenue Exp.",null,null,null,{"$f":"SUM(G130:K130)","v":83288146.498359069},57451818.40972022,22560883.788348883,2706278.6455243062,552828.71160913317,16336.943156520912]
[44,"     Total Uniform Proposed Margin",null,null,null,{"$f":"F129-F130","v":77331853.516283348},61285536.60217566,12032566.065786622,1095356.3884143867,169933.98714558093,2748460.4727611193]
[]
[null,"Margin per Therm at Uniform Proposed Return"]
[45,"Production",null,null,null,4.7035709756469667E-3,5.4302497903022081E-3,5.3358918624948704E-3,5.2625023630893516E-3,5.2310497204868548E-3,6.7426523139900972E-4]
[46,"Underground Storage",null,null,null,1.946341672783224E-2,2.237958787309954E-2,2.2379587873099526E-2,2.2379587873099526E-2,2.2379587873099533E-2,2.5302441746181902E-3]
[47,"Distribution",null,null,null,0.24527632682308539,0.34389143059168548,0.14611672682831195,9.3151371090785584E-2,5.4727257814538979E-2,4.6077483479222782E-2]
[48,"Common",null,null,null,0.12564589648321783,0.16230189795624217,9.1713727406423778E-2,7.224503131516867E-2,5.6560836808448707E-2,4.6296326432559182E-2]
[49,"     Total Proposed Uniform Margin Melded Rate per Therm",null,null,null,{"$f":"SUM(F134:F137)","v":0.39508921100978245},0.53400316621132937,0.26554593397033011,0.19303849264214312,0.13889873221657406,9.5578319317799171E-2]
[]
[50,"Margin to Cost Ratio at Proposed Rates",null,null,null,{"$f":"F115/F131","v":0.99999999981065479},{"$f":"G115/G131","v":0.97658440467018637},1.1140851860035506,1.1415792783529399,1.2076343204010858,0.95340514301556423]
[]
[51,"Current Margin to Proposed Cost Ratio",null,null,null,{"$f":"F80/F131","v":0.84263139054567893},{"$f":"G80/G131","v":0.82345313159794298},{"$f":"H80/H131","v":0.93312885139149959},0.96296849803549112,1.0418246380552156,0.81380488614254276]
[]
[{"$f":"$A$63","v":"File:  WA 2014 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-14____"},"Summary by Classification with Unit Cost Analysis",null,null,null,null,null,{"$f":"I4","v":"Washington Jurisdiction"}]
[null,null,{"$f":"C5","v":"For the Twelve Months Ended June 30, 2013"},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":83127205.794928998},55606634.003490843,22672684.484745871,2857962.588159624,570023.63126386399,1419901.0872687947]
[2,"Demand",null,null,null,{"$f":"SUM(G156:K156)","v":33558251.430558473},22743705.97459124,9231640.3663224094,846304.3570408558,130835.81615926587,605764.91644470009]
[3,"Customer",null,null,null,{"$f":"SUM(G157:K157)","v":32188855.704528514},29980429.639182746,1893867.5407824924,57929.855749206472,29240.379265603518,227388.28954846709]
[4,"     Total Current Rate Revenue",null,null,null,{"$f":"SUM(F155:F157)","v":148874312.93001598},108330769.61726484,33798192.39185077,3762196.8009496862,730099.8266887333,2253054.2932619615]
[]
[null,"Revenue per Therm at Current Rates"]
[5,"Commodity ",null,null,null,0.4246977236107603,0.48452082279988606,0.50036202952880771,0.50366875647166853,0.46591950819237593,4.9377373574643502E-2]
[6,"Demand ",null,null,null,0.17144944130655651,0.1981741806496656,0.20373248314203413,0.14914718088797996,0.10694110871107966,2.1065608615905188E-2]
[7,"Customer",null,null,null,0.16445318488237262,0.26123038549247563,4.1795642108556491E-2,1.0209181368806754E-2,2.3900172518430456E-2,7.9074779364602145E-3]
[8,"     Total Revenue per Therm at Current Rates",null,null,null,{"$f":"SUM(F161:F163)","v":0.76060034979968938},0.94392538894202738,0.74589015477939824,0.66302511872845526,0.59676078942188604,7.83504601270089E-2]
[]
[null,"Cost per Unit at Current Rates"]
[9,"Commodity Cost per Therm",null,null,null,0.4246977236107603,0.48452082279988606,0.50036202952880771,0.50366875647166853,0.46591950819237593,4.9377373574643502E-2]
[10,"Demand Cost per Peak Day Therms",null,null,null,24.918269927455892,26.462667420072012,28.464850467771271,35.066177012068572,20.776044303824943,4.57112650185198]
[11,"Customer Cost per Customer per Month",null,null,null,17.893831553260092,16.954696117262124,63.55900059678801,172.41028496787641,1218.3491360668133,498.65852971155061]
[]
[null,"Cost by Classification at Uniform Current Return "]
[12,"Commodity",null,null,null,{"$f":"SUM(G172:K172)","v":82842143.099523753},55958399.57502839,22089487.331452768,2765751.0088539096,552648.92906764382,1475856.2551210371]
[13,"Demand",null,null,null,{"$f":"SUM(G173:K173)","v":33345924.990664881},23090470.575185589,8682182.0646569859,794676.98004773655,119940.13804391368,658655.23273065465]
[14,"Customer",null,null,null,{"$f":"SUM(G174:K174)","v":32686244.839827407},30684411.461724192,1684668.2901715045,49772.175697926818,23049.459334565647,244343.45289921685]
[15,"     Total Uniform Current Cost",null,null,null,{"$f":"SUM(F172:F174)","v":148874312.93001604},109733281.61193818,32456337.686281256,3610200.1645995728,695638.52644612314,2378854.9407509086]
[]
[null,"Cost per Therm at Current Return"]
[16,"Commodity ",null,null,null,0.42324133545639819,0.48758588414028919,0.48749148870540021,0.4874179868942034,0.4517179694170394,5.1323226881782369E-2]
[17,"Demand ",null,null,null,0.17036466340715686,0.20119566671169375,0.1916065228858618,0.14004870742378986,9.8035321809453096E-2,2.2904881033645259E-2]
[18,"Customer",null,null,null,0.16699435093613466,0.26736443510735669,3.7178837173876392E-2,8.771524842390294E-3,1.8839907976183221E-2,8.4970974827058253E-3]
[19,"     Total Cost per Therm at Current Return",null,null,null,{"$f":"SUM(F178:F180)","v":0.76060034979968971},0.95614598595933975,0.71627684876513842,0.63623821916038359,0.5685931992026757,8.2725205398133453E-2]
[]
[null,"Cost per Unit at Uniform Current Return"]
[20,"Commodity Cost per Therm",null,null,null,0.42324133545639819,0.48758588414028919,0.48749148870540021,0.4874179868942034,0.4517179694170394,5.1323226881782369E-2]
[21,"Demand Cost per Peak Day Therms",null,null,null,24.760609521550883,26.866133605786597,26.770650111761039,32.927023733170685,19.045867522803338,4.9702389626478682]
[22,"Customer Cost per Customer per Month",null,null,null,18.17033089468303,17.352815757871515,56.538184722337967,148.13147529144885,960.39413894023528,535.84090548073868]
[]
[23,"Revenue to Cost Ratio at Current Rates",null,null,null,{"$f":"F158/F175","v":0.99999999999999956},0.98721890046418914,1.0413433800985097,1.0421019969586567,1.0495390909682158,0.94711714222926224]
[]
[]
[null,"Cost by Classification at Proposed Return by Schedule "]
[24,"Commodity",null,null,null,{"$f":"SUM(G192:K192)","v":86704360.838713139},57942590.975822747,23611623.205557063,2975731.4972459348,584030.08913131768,1590385.0709560881]
[25,"Demand",null,null,null,{"$f":"SUM(G193:K193)","v":37000555.420999125},25059773.72456608,10121297.71150586,912553.83846882696,139713.39186539518,767216.75459296617]
[26,"Customer",null,null,null,{"$f":"SUM(G194:K194)","v":37304234.977895007},34689104.2244673,2233266.474787849,68429.465234924675,34303.345692020521,279131.46771290747]
[27,"     Total Proposed Rate Revenue",null,null,null,{"$f":"SUM(F192:F194)","v":161009151.23760727},117691468.92485613,35966187.39185077,3956714.8009496862,758046.8266887333,2636733.293261962]
[]
[null,"Revenue per Therm at Proposed Rates"]
[28,"Commodity ",null,null,null,0.44297344441203074,0.50487486534431214,0.52108340834322897,0.52442358378685872,0.47736794928007603,5.5305991720301234E-2]
[29,"Demand ",null,null,null,0.18903620673113866,0.21835492116720245,0.22336627441720044,0.16082255902832371,0.11419736175057109,2.6680131907731261E-2]
[30,"Customer",null,null,null,0.19058770861656199,0.30225877941065021,4.9285815561686409E-2,1.205956432169041E-2,2.8038483104187151E-2,9.7068583729379328E-3]
[31,"     Total Revenue per Therm at Proposed Rates",null,null,null,{"$f":"SUM(F198:F200)","v":0.82259735975973136},1.0254885659221649,0.79373549832211587,0.69730570713687279,0.61960379413483424,9.1692982000970424E-2]
[]
[null,"Cost per Unit at Proposed Rates"]
[32,"Commodity Cost per Therm",null,null,null,0.44297344441203074,0.50487486534431214,0.52108340834322897,0.52442358378685872,0.47736794928007603,5.5305991720301234E-2]
[33,"Demand Cost per Peak Day Therms",null,null,null,27.474310732610896,29.157449469154503,31.208020943798982,37.811189516593387,22.185756961990222,5.789448587032739]
[34,"Customer Cost per Customer per Month",null,null,null,20.737478307555261,19.617571455253817,74.949373251933054,203.65912272299011,1429.306070500855,612.13041165111292]
[]
[null,"Cost by Classification at Uniform Proposed Return "]
[35,"Commodity",null,null,null,{"$f":"SUM(G209:K209)","v":86412755.039179131},58302514.261041947,23015003.749746196,2881649.4795261063,566240.53357795812,1647347.0152869255]
[36,"Demand",null,null,null,{"$f":"SUM(G210:K210)","v":36783269.173905127},25414580.06248628,9559193.6081519239,859879.24126892898,128557.55915323796,821058.70284476073]
[37,"Customer",null,null,null,{"$f":"SUM(G211:K211)","v":37813127.039165415},35409411.925974905,2019252.4962373746,60106.313143659849,27964.606023517936,296391.69778595434]
[38,"     Total Uniform Proposed Cost",null,null,null,{"$f":"SUM(F209:F211)","v":161009151.25224966},119126506.24950314,34593449.854135491,3801635.0339386952,722762.69875471399,2764797.4159176406]
[]
[null,"Cost per Therm at Proposed Return"]
[39,"Commodity ",null,null,null,0.44148362747340653,0.50801100781048447,0.50791665158062571,0.50784318029676068,0.46282732233097068,5.7286855901602728E-2]
[40,"Demand ",null,null,null,0.18792608912727743,0.22144647781083815,0.21096123476916606,0.15153953027937045,0.10507893260895768,2.8552497537036679E-2]
[41,"Customer",null,null,null,0.19318764323385565,0.30853508234568583,4.4562754702832386E-2,1.059274607812781E-2,2.2857395326545307E-2,1.0307086681756597E-2]
[42,"     Total Cost per Therm at Proposed Return",null,null,null,{"$f":"SUM(F215:F217)","v":0.82259735983453963},1.0379925679670086,0.76344064105262421,0.66997545665425895,0.59076365026647359,9.6146440120396012E-2]
[]
[null,"Cost per Unit at Uniform Proposed Return"]
[43,"Commodity Cost per Therm",null,null,null,0.44148362747340653,0.50801100781048447,0.50791665158062571,0.50784318029676068,0.46282732233097068,5.7286855901602728E-2]
[44,"Demand Cost per Peak Day Therms",null,null,null,27.312967482417541,29.570272345488082,29.474828508393877,35.628645217862022,20.414268989677652,6.1957421010408078]
[45,"Customer Cost per Customer per Month",null,null,null,21.0203721422026,20.024923795996251,67.766973058944686,178.88783673708289,1165.1919176465806,649.9817933902508]
[]
[46,"Revenue to Cost Ratio at Proposed Rates",null,null,null,{"$f":"F195/F212","v":0.99999999990905863},0.98795366900426496,1.0396820075333184,1.0407929129510152,1.0488184130072182,0.95368046790033123]
[]
[47,"Current Revenue to Proposed Cost Ratio",null,null,null,{"$f":"F158/F212","v":0.92463261729004287},{"$f":"G158/G212","v":0.90937586459870401},{"$f":"H158/H212","v":0.97701132828214732},0.98962598128517643,1.0101515033172863,0.8149075517397969]
[]
[{"$f":"$A$63","v":"File:  WA 2014 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-14____"},"Customer Cost Analysis",null,null,null,null,null,{"$f":"$I$4","v":"Washington Jurisdiction"}]
[null,null,{"$f":"$C$5","v":"For the Twelve Months Ended June 30, 2013"}]
[]
[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":103002999.99999999},101065613.49029186,1703052.8111253714,51839.578050303695,3702.8270035931205,178791.29352886128]
[2,"Services Accum. Depr.",null,null,null,{"$f":"SUM(G243:Q243)","v":-44476000},-43639449.584907442,-735366.70609217219,-22383.979819668428,-1598.8557014048874,-77200.873479312591]
[3,"Total Services",null,null,null,{"$f":"SUM(F242:F243)","v":58526999.999999985},{"$f":"SUM(G242:G243)","v":57426163.905384421},967686.10503319919,29455.598230635267,2103.971302188233,101590.42004954869]
[]
[4,"Meters",null,null,null,{"$f":"SUM(G246:Q246)","v":43768000},37622037.728326268,5157083.0798876602,143898.22396098243,79099.882390237311,765881.08543485252]
[5,"Meters Accum. Depr.",null,null,null,{"$f":"SUM(G247:Q247)","v":-9444000},-8117860.6357684452,-1112764.8648889386,-31049.507107647554,-17067.704471152469,-165257.28776381709]
[6,"Total Meters",null,null,null,{"$f":"SUM(F246:F247)","v":34324000},{"$f":"SUM(G246:G247)","v":29504177.092557825},4044318.2149987216,112848.71685333487,62032.177919084847,600623.7976710354]
[]
[7,"Total Rate Base",null,null,null,{"$f":"SUM(G250:Q250)","v":92850999.999999985},{"$f":"G244+G248","v":86930340.997942239},{"$f":"H244+H248","v":5012004.3200319204},142304.31508397014,64136.149221273081,702214.21772058413]
[]
[8,"Return on Rate Base @ 7.71%",null,null,null,{"$f":"SUM(G252:Q252)","v":7158812.0999999987},{"$f":"G250*0.0771","v":6702329.2909413464},{"$f":"H250*0.0771","v":386425.5330744611},10971.662692974098,4944.897104960155,54140.716186257036]
[9,"Revenue Conversion Factor",null,null,null,0.62087999999999999,0.62087999999999999,0.62087999999999999,0.62087999999999999,0.62087999999999999,0.62087999999999999]
[10,"Rate Base Revenue Requirement",null,null,null,{"$f":"SUM(G254:Q254)","v":11530105.817549283},{"$f":"G252/G253","v":10794886.759021625},{"$f":"H252/H253","v":622383.6056475665},17671.148519801085,7964.336272645528,87199.968087645015]
[]
[null,"Expenses"]
[11,"Services Depr Exp",null,null,null,{"$f":"SUM(G257:Q257)","v":2782000},2729673.2787393765,45997.620657172927,1400.1311237143082,100.00936597959343,4828.9601137568043]
[12,"Meters Depr Exp",null,null,null,{"$f":"SUM(G258:Q258)","v":1441000.0000000002},1238652.8140769091,169789.72578409154,4737.647156090653,2604.2526623179488,25215.560320590899]
[13,"Services Maintenance Exp",null,null,null,1069000.0000000002,1048893.1470066116,17674.858548712386,538.00868844377976,38.429192031698548,1855.5565642005836]
[14,"Meters Maintenance Exp",null,null,null,1053000,905136.30341636727,124072.57546887465,3462.0003160051751,1903.0382050109645,18426.082593741998]
[15,"Meter Reading",null,null,null,1578000.0000000002,1551145.894111892,26138.300498087698,294.74339589077647,21.053099706484037,400.00889442319664]
[16,"Billing",null,null,null,3380000,3322479.7985413149,55986.98078804589,631.32615849862134,45.094725607044388,856.79978653384319]
[]
[17,"Total Expenses",null,null,null,{"$f":"SUM(F257:F263)","v":11303000},10795981.235892471,439660.06174498511,11063.856838643314,4711.8772506537334,51582.968273247316]
[18,"Revenue Conversion Factor",null,null,null,0.955202,0.955202,0.955202,0.955202,0.955202,0.955202]
[19,"Expense Revenue Requirement",null,null,null,{"$f":"SUM(G266:Q266)","v":11833099.176928023},{"$f":"G264/G265","v":11302301.749674384},{"$f":"H264/H265","v":460279.67042048188},11582.74044510304,4932.859490090822,54002.156897962224]
[]
[20,"Total Meter, Service, Meter Reading, and Billing Cost",null,null,null,{"$f":"SUM(G268:Q268)","v":23363204.994477298},{"$f":"G254+G266","v":22097188.508696008},{"$f":"H254+H266","v":1082663.2760680483},{"$f":"I254+I266","v":29253.888964904123},{"$f":"J254+J266","v":12897.19576273635},{"$f":"K254+K266","v":141202.12498560722}]
[]
[21,"Total Customer Bills",null,null,null,{"$f":"SUM(G270:Q270)","v":1798880},1768267,29797,336,24,456]
[]
[22,"Average Unit Cost per Month",null,null,null,{"$f":"F268/F270","v":12.987639528193819},{"$f":"G268/G270","v":12.496522588894102},36.334640268082303,87.065145728881319,537.38315678068125,309.65378286317372]
[]
[null," Fixed Costs per Customer"]
[]
[23,"Total Customer Related Cost",null,null,null,{"$f":"SUM(G276:Q276)","v":37813127.039165415},{"$f":"G211","v":35409411.925974905},{"$f":"H211","v":2019252.4962373746},60106.313143659849,27964.606023517936,296391.69778595434]
[24,"Customer Related Unit Cost per Month",null,null,null,{"$f":"F276/F270","v":21.0203721422026},{"$f":"G276/G270","v":20.024923795996251},{"$f":"H276/H270","v":67.766973058944686},178.88783673708289,1165.1919176465806,649.9817933902508]
[]
[25,"Other Non-Gas Costs",null,null,null,{"$f":"SUM(G279:Q279)","v":39518726.477117956},{"$f":"G131-G276","v":25876124.676200755},{"$f":"H131-H276","v":10013313.569549248},{"$f":"I131-I276","v":1035250.0752707268},{"$f":"J131-J276","v":141969.381122063},{"$f":"K131-K276","v":2452068.7749751648}]
[26,"Other Non-Gas Unit Cost per Month",null,null,null,{"$f":"F279/F270","v":21.9685173425231},{"$f":"G279/G270","v":14.633607185001335},{"$f":"H279/H270","v":336.05106452157088},3081.101414496211,5915.3908800859581,5377.3438047700984]
[]
[27,"Total Fixed Unit Cost per Month",null,null,null,{"$f":"F277+F280","v":42.988889484725703},{"$f":"G277+G280","v":34.658530980997583},{"$f":"H277+H280","v":403.81803758051558},3259.989251233294,7080.5827977325389,6027.3255981603488]
[]
[]
[]
[]
[{"$f":"A229","v":"File:  WA 2014 Gas Case / Gas COS Base Case / Summary Exhibits"},null,null,null,null,null,null,null,null,null,"Page 4 of 4"]