{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Class Revenue Allocation"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"Class Revenue Allocation","index":0,"n_rows":45,"n_cols":18,"rows_kept":45,"cut":false,"hidden":false,"merged":[[30,0,30,9],[26,0,26,8],[27,0,27,9],[28,0,28,9],[29,0,29,9]]}
["CLASS REVENUE ALLOCATION"]
["LINE",null,null,null,null,null,"PUBLIC",null,"ELEC.","COM.","IND.","PUB. AUTH.","CNG","ELEC. GEN.","FORT"]
["NO.","DESCRIPTION","TOTAL","RESIDENTIAL","COMMERCIAL","INDUSTRIAL","AUTHORITY","CNG","GEN.","TRANS.","TRANS.","TRANS.","TRANS.","TRANS.","BLISS"]
[null,"(a)","(b)","(c)","(d)","(e)","(f)","(g)","(h)","(i)","(j)","(k)","(l)","(m)","(n)"]
[]
[1,"Current Revenue-to-Cost Ratio (1)",{"$f":"+C35/C39","v":0.92109477635056014},{"$f":"+D35/D39","v":0.83859107305439262},{"$f":"+E35/E39","v":1.4211687002240707},{"$f":"+F35/F39","v":2.5853639671407338},{"$f":"+G35/G39","v":1.613185350881766},{"$f":"IFERROR(+H35/H39,0)","v":0},{"$f":"IFERROR(+I35/I39,0)","v":0},{"$f":"+J35/J39","v":1.2190309767095988},{"$f":"+K35/K39","v":2.7446347753002458},{"$f":"+L35/L39","v":1.2227702785648664},{"$f":"+M35/M39","v":2.1369076511372578},{"$f":"IFERROR(+N35/N39,0)","v":0},{"$f":"+O35/O39","v":0.9220374422431834}]
[null,null," "," "," "," "," "," "," "," "," ",null," "," "," "," "," "," "]
[{"$f":"+A6+1","v":2},"Revenue Allocation One - Cost of Service Study Required Revenue Changes",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "]
[{"$f":"+A8+1","v":3},"Revenue-to-Cost Ratio",{"$f":"(+C35+C10)/C39","v":0.99999999999999967},{"$f":"+(D35+D40)/D39","v":1},{"$f":"+(E35+E40)/E39","v":1},{"$f":"+(F35+F40)/F39","v":0.99999999999999978},{"$f":"+(G35+G40)/G39","v":1.0000000000000002},{"$f":"IFERROR(+(H35+H40)/H39,0)","v":0},{"$f":"IFERROR(+(I35+I40)/I39,0)","v":0},{"$f":"+(J35+J40)/J39","v":1},{"$f":"+(K35+K40)/K39","v":1},{"$f":"+(L35+L40)/L39","v":1.0000000000000002},{"$f":"+(M35+M40)/M39","v":0.99999999999999978},{"$f":"IFERROR(+(N35+N40)/N39,0)","v":0},{"$f":"+(O35+O40)/O39","v":1}," "," "," "]
[4,"Rate Design Revenue Increase",{"$f":"SUM(D10:O10)","v":14297684.148205871},{"$f":"D40","v":25153558.73774457},-7092591.8798204772,-423522.46787857194,-2328190.430636703,0,0,-136915.89712688082,-679176.47096945811,-102263.09035717801,-305054.91039928375,0,211840.55764985783," "," "," "]
[5,"% Increase - Non-Gas Revenue (2)",{"$f":"+C10/C35","v":8.5664608762702349E-2},{"$f":"+D10/D35","v":0.19247632383887558},{"$f":"+E10/E35","v":-0.29635376866776375},{"$f":"+F10/F35","v":-0.61320726493069244},{"$f":"+G10/G35","v":-0.38010842991265648},{"$f":"IFERROR(+H10/H35,0)","v":0},{"$f":"IFERROR(+I10/I35,0)","v":0},{"$f":"+J10/J35","v":-0.17967630100820406},{"$f":"+K10/K35","v":-0.63565279832519561},{"$f":"+L10/L35","v":-0.1821848980712272},{"$f":"+M10/M35","v":-0.53203405890385491},{"$f":"IFERROR(N10/N35,0)","v":0},{"$f":"+O10/O35","v":8.4554654925015862E-2}," "," "," "]
[6,"% Increase - Total Revenue (3)",{"$f":"+C10/(C35+C36)","v":5.8023819704246062E-2},{"$f":"+D10/(D35+D36)","v":0.13784747390115515},{"$f":"+E10/(E35+E36)","v":-0.16345576097461414},{"$f":"+F10/(F35+F36)","v":-0.35437399428166899},{"$f":"+G10/(G35+G36)","v":-0.20351510053166524},{"$f":"IFERROR(+H10/(H35+H36),0)","v":0},{"$f":"IFERROR(+I10/(I35+I36),0)","v":0},{"$f":"+J10/(J35+J36)","v":-0.17967630100820406},{"$f":"+K10/(K35+K36)","v":-0.63565279832519561},{"$f":"+L10/(L35+L36)","v":-0.1821848980712272},{"$f":"+M10/(M35+M36)","v":-0.53203405890385491},{"$f":"IFERROR(+N10/(N35+N36),0)","v":0},{"$f":"+O10/(O35+O36)","v":4.2838898314152461E-2}]
[7,"% Total Revenue (for GRIP)",{"$f":"(C10+C37)/($C$10+$C$37)","v":1},0.85903579910801764,9.3352016952358785E-2,1.4910438004621181E-3,2.1209496432270589E-2,0,0,3.4923346607121431E-3,2.1749317076026771E-3,2.564656363423891E-3,1.4990646000007939E-3,0,1.5180656375151123E-2]
[8,"Revenue Allocation Two  - Partial Movement Toward Cost of Service (4)"]
[9,"Revenue-to-Cost Ratio",{"$f":"+(C35+C16)/C39","v":0.99999999999999967},{"$f":"+(D35+D16)/D39","v":0.9431832912623469},{"$f":"+(E35+E16)/E39","v":1.3369349601792566},{"$f":"+(F35+F16)/F39","v":2.268291173712587},{"$f":"+(G35+G16)/G39","v":1.4905482807054129},{"$f":"IFERROR(+(H35+H16)/H39,0)","v":0},{"$f":"IFERROR(+(I35+I16)/I39,0)","v":0},{"$f":"+(J35+J16)/J39","v":1.1752247813676793},{"$f":"+(K35+K16)/K39","v":2.3957078202401969},{"$f":"+(L35+L16)/L39","v":1.1782162228518931},{"$f":"+(M35+M16)/M39","v":1.9095261209098062},{"$f":"IFERROR(+(N35+N16)/N39,0)","v":0},{"$f":"+(O35+O16)/O39","v":1}]
[10,"Rate Design Revenue Increase",{"$f":"SUM(D16:O16)","v":14297684.148205871},{"$f":"C10-E16-F16-G16-J16-K16-L16-M16-O16","v":16299386.619993722},{"$f":"+E10*$P$16","v":-1418518.3759640956},-84704.493575714398,-465638.08612734062,0,0,-27383.179425376165,-135835.29419389163,-20452.618071435601,-61010.982079856753,0,{"$f":"O10","v":211840.55764985783},0.2]
[11,"% Increase - Non-Gas Revenue (2)",{"$f":"+C16/C35","v":8.5664608762702349E-2},{"$f":"+D16/D35","v":0.12472374387077496},{"$f":"+E16/E35","v":-5.9270753733552756E-2},{"$f":"+F16/F35","v":-0.1226414529861385},{"$f":"+G16/G35","v":-7.6021685982531298E-2},{"$f":"IFERROR(+H16/H35,0)","v":0},{"$f":"IFERROR(+I16/I35,0)","v":0},{"$f":"+J16/J35","v":-3.5935260201640812E-2},{"$f":"+K16/K35","v":-0.12713055966503914},{"$f":"+L16/L35","v":-3.6436979614245441E-2},{"$f":"+M16/M35","v":-0.10640681178077098},{"$f":"IFERROR(+N16/N35,0)","v":0},{"$f":"+O16/O35","v":8.4554654925015862E-2}]
[12,"% Increase - Total Revenue (3)",{"$f":"+C16/(C35+C36)","v":5.8023819704246062E-2},{"$f":"+D16/(D35+D36)","v":8.9324508517075449E-2},{"$f":"+E16/(E35+E36)","v":-3.2691152194922836E-2},{"$f":"+F16/(F35+F36)","v":-7.0874798856333812E-2},{"$f":"+G16/(G35+G36)","v":-4.0703020106333053E-2},{"$f":"IFERROR(+H16/(H35+H36),0)","v":0},{"$f":"IFERROR(+I16/(I35+I36),0)","v":0},{"$f":"+J16/(J35+J36)","v":-3.5935260201640812E-2},{"$f":"+K16/(K35+K36)","v":-0.12713055966503914},{"$f":"+L16/(L35+L36)","v":-3.6436979614245441E-2},{"$f":"+M16/(M35+M36)","v":-0.10640681178077098},{"$f":"IFERROR(+N16/(N35+N36),0)","v":0},{"$f":"+O16/(O35+O36)","v":4.2838898314152461E-2}]
[13,"% Total Revenue (for GRIP)",{"$f":"(C16+C37)/($C$16+$C$37)","v":1},0.80907784733135391,0.12536687804983074,3.4027586165039795E-3,3.1718587397643327E-2,0,0,4.1103518119631746E-3,5.2406290925914711E-3,3.0262561126633953E-3,2.8760352122985957E-3,0,1.5180656375151123E-2]
[14,"Revenue Allocation Three - No Movement Toward Cost of Service for Classes Requiring Revenue Decreases  (5)"]
[15,"Revenue-to-Cost Ratio",{"$f":"+(C35+C22)/C39","v":0.99999999999999967},{"$f":"+(D35+D22)/D39","v":0.92897911407793377},{"$f":"+(E35+E22)/E39","v":1.4211687002240707},{"$f":"+(F35+F22)/F39","v":2.5853639671407338},{"$f":"+(G35+G22)/G39","v":1.613185350881766},{"$f":"IFERROR(+(H35+H22)/H39,0)","v":0},{"$f":"IFERROR(+(I35+I22)/I39,0)","v":0},{"$f":"+(J35+J22)/J39","v":1.2190309767095988},{"$f":"+(K35+K22)/K39","v":2.7446347753002458},{"$f":"+(L35+L22)/L39","v":1.2227702785648664},{"$f":"+(M35+M22)/M39","v":2.1369076511372578},{"$f":"IFERROR(+(N35+N22)/N39,0)","v":0},{"$f":"+(O35+O22)/O39","v":1}]
[16,{"$f":"+B10","v":"Rate Design Revenue Increase"},{"$f":"SUM(D22:O22)","v":14297684.148205871},{"$f":"C10-O22","v":14085843.590556012},0,0,0,0,0,0,0,0,0,0,{"$f":"O10","v":211840.55764985783}]
[17,{"$f":"+B11","v":"% Increase - Non-Gas Revenue (2)"},{"$f":"+C22/C35","v":8.5664608762702349E-2},{"$f":"+D22/D35","v":0.10778559887874983},{"$f":"+E22/E35","v":0},{"$f":"+F22/F35","v":0},{"$f":"+G22/G35","v":0},{"$f":"IFERROR(+H22/H35,0)","v":0},{"$f":"IFERROR(+I22/I35,0)","v":0},{"$f":"+J22/J35","v":0},{"$f":"+K22/K35","v":0},{"$f":"+L22/L35","v":0},{"$f":"+M22/M35","v":0},{"$f":"IFERROR(+N22/N35,0)","v":0},{"$f":"+O22/O35","v":8.4554654925015862E-2}]
[18,{"$f":"+B12","v":"% Increase - Total Revenue (3)"},{"$f":"+C22/(C35+C36)","v":5.8023819704246062E-2},{"$f":"+D22/(D35+D36)","v":7.7193767171055527E-2},{"$f":"+E22/(E35+E36)","v":0},{"$f":"+F22/(F35+F36)","v":0},{"$f":"+G22/(G35+G36)","v":0},{"$f":"IFERROR(+H22/(H35+H36),0)","v":0},{"$f":"IFERROR(+I22/(I35+I36),0)","v":0},{"$f":"+J22/(J35+J36)","v":0},{"$f":"+K22/(K35+K36)","v":0},{"$f":"+L22/(L35+L36)","v":0},{"$f":"+M22/(M35+M36)","v":0},{"$f":"IFERROR(+N22/(N35+N36),0)","v":0},{"$f":"+O22/(O35+O36)","v":4.2838898314152461E-2}]
[19,"% Total Revenue (for GRIP)",{"$f":"(C22+C37)/($C$22+$C$37)","v":1},0.79658835938718808,0.13337059332419871,3.8806873205144451E-3,3.4345860138986516E-2,0,0,4.2648560997759323E-3,6.0070534388386694E-3,3.1416560499732717E-3,3.2202778653730463E-3,0,1.5180656375151123E-2]
[]
["(1) Revenue-to-cost ratios are the ratios of each class' non-gas revenue (including revenue credits) to the cost of service."]
["(2) Non-gas revenue is the sum of as adjusted test year base revenue (i.e., revenue from recurring monthly charges resulting from as adjusted billing determinants), service charge revenue, special contract revenue, and other revenue credited to the cost of service for each class."]
["(3) Total revenue is the sum of non-gas revenue (see Note 2) and as adjusted gas costs.  As adjusted gas costs are calculated by multiplying the test year average cost of gas (i.e., test year gas cost revenue divided by unadjusted sales service volumes) by as adjusted sales service volumes."]
["(4)  For each class with a cost of service required revenue decrease, 20 percent of the required decrease is implemented.  The benefit of implementing less than the required decreases is assigned to the residential class."]
["(5) No revenue change assigned to a class for which the cost of service required revenue change calls for a decrease.  The resulting benefit from not implementing the required deceases is assigned to the residential class."]
[]
[null,null,null,null,null,null,null,null,{"$f":"I2","v":"ELEC."},{"$f":"J2","v":"COM."},"IND.","PUB. AUTH.","CNG","ELEC. GEN.","FORT"]
[null,"DESCRIPTION","TOTAL",{"$f":"D3","v":"RESIDENTIAL"},{"$f":"E3","v":"COMMERCIAL"},"INDUSTRIAL","AUTHORITY","CNG","GEN.","TRANS.","TRANS.","TRANS.","TRANS.","TRANS.","BLISS"]
[null,"Base With Service Charges and Other (COS)",{"$f":"SUM(D35:O35)","v":166903046.13205639},130683910.81077036,23932855.356301676,690667.72704729845,6125069.1840001764,0,0,762014.22423889511,1068470.826776721,561314.85891436029,573374.77797527798,0,2505368.3660316598]
[null,"COG Revenue",{"$f":"SUM(D36:O36)","v":79507552.499381125},51789935.288006671,19458652.153317444,504460.79455053993,5314821.1462726677,0,0,0,0,0,0,0,2439683.1172337998]
[null,"Base Revenue",{"$f":"SUM(D37:O37)","v":162934804.43205646},127095493.7177037,23637602.158273861,687783.87121664523,6087202.2648622151,0,0,755871.06,1064645.03,556803.5199999999,570737.86,0,2478664.9500000002]
[]
[null,"COS",{"$f":"SUM(D39:O39)","v":181200730.28026232},155837469.54851493,16840263.476481199,267145.25916872657,3796878.7533634729,0,0,625098.32711201429,389294.35580726294,459051.76855718222,268319.86757599429,0,2717208.9236815176]
[null,"COS Revenue Increase",{"$f":"SUM(D40:O40)","v":14297684.148205871},25153558.73774457,-7092591.8798204772,-423522.46787857194,-2328190.430636703,0,0,-136915.89712688082,-679176.47096945811,-102263.09035717801,-305054.91039928375,0,211840.55764985783]
[]
[]
[null,"Fixed Costs",null,155337661.03705975,16652474.093976872,262276.86538893759,3745587.0722482768,0,0,599090.71397608728,361091.54888898053,444906.5372109951,247468.77466921217,0,2693661.1926911413]
[null,"Bills",null,3505999.05818182,205950.50986666599,420,17059.039550000001,0,0,249,156,120,48,0,227]
[null,"Fixed Costs/Bill",null,{"$f":"+D43/D44","v":44.306247223470869},{"$f":"+E43/E44","v":80.856678163884212},{"$f":"+F43/F44","v":624.46872711651804},{"$f":"+G43/G44","v":219.56611691238365},{"$f":"IFERROR(+H43/H44,0)","v":0},{"$f":"IFERROR(+I43/I44,0)","v":0},{"$f":"+J43/J44","v":2405.9868031168162},{"$f":"+K43/K44","v":2314.6894159550034},{"$f":"+L43/L44","v":3707.5544767582924},{"$f":"+M43/M44","v":5155.5994722752539},{"$f":"IFERROR(+N43/N44,0)","v":0},{"$f":"+O43/O44","v":11866.348866480799}]