{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["SCH G-6 TY"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":10,"defined_names":251,"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":"SCH G-6 TY","index":0,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["TEXAS GAS SERVICE COMPANY"]
["January 1, 2024 - December 31, 2024"]
[]
["WORKPAPER SUPPORTING TEST YEAR BENEFITS AND PAYROLL TAX "]
[]
["Line No.","FERC ","Natural Account","Account Description","Test Year","Percent","Shared Service","Central Gulf","RGV","West North","Direct","Total"]
[null,"(a)","(b)","(c)","(d)",null,"(e)","(f)","(g)","(h)","(i) = (f)+(g)+(h)","(j)=(e)+(i)"]
[1,4081,4081101,"GEN TAX FED UNEMPL INS TAX",44621.75,null,{"$f":"$E8*F$39","v":11206.79761619085},{"$f":"$E8*F$40","v":16643.384743782826},{"$f":"$E8*F$41","v":4470.2099025029511},{"$f":"$E8*F$42","v":12301.357737523367},{"$f":"SUM(H8:J8)","v":33414.952383809141},{"$f":"K8+G8","v":44621.749999999993}]
[{"$f":"A8+1","v":2},4081,4081102,"GEN TAX FICA",5934212.3200000003,null,{"$f":"$E9*F$39","v":1490383.4224732642},{"$f":"$E9*F$40","v":2213390.9762180122},{"$f":"$E9*F$41","v":594489.78752332693},{"$f":"$E9*F$42","v":1635948.1337853959},4443828.8975267354,{"$f":"K9+G9","v":5934212.3199999994}]
[3,4081,4081132,"GEN TAX STATE UNEMPL INS",162463.57,null,{"$f":"$E10*F$39","v":40802.889823771038},{"$f":"$E10*F$40","v":60596.989189318956},{"$f":"$E10*F$41","v":16275.611319815593},{"$f":"$E10*F$42","v":44788.079667094389},121660.68017622893,{"$f":"K10+G10","v":162463.56999999995}]
[4,"4081 Total",null,null,{"$f":"SUM(E8:E10)","v":6141297.6400000006},{"$f":"E11/E$30","v":0.25973341580092024},{"$f":"SUM(G8:G10)","v":1542393.109913226},{"$f":"SUM(H8:H10)","v":2290631.3501511137},{"$f":"SUM(I8:I10)","v":615235.6087456455},{"$f":"SUM(J8:J10)","v":1693037.5711900136},{"$f":"SUM(K8:K10)","v":4598904.5300867734},{"$f":"SUM(L8:L10)","v":6141297.6399999997}]
[5,9260,9260101,"A&G EMPL BEN 401(K) CO MATCH",3806366.52,null,{"$f":"$E12*F$39","v":955972.79897549201},{"$f":"$E12*F$40","v":1419729.6714766615},{"$f":"$E12*F$41","v":381322.05281638884},{"$f":"$E12*F$42","v":1049341.9967314571},{"$f":"SUM(H12:J12)","v":2850393.7210245077},{"$f":"K12+G12","v":3806366.5199999996}]
[6,9260,9260102,"A&G EMPL BEN 401(K) ADMIN",145521.48000000001,null,36547.866795196613,54277.790093949647,14578.351609313511,40117.471501540211,108973.61320480338,145521.47999999998]
[7,9260,9260112,"A&G EMPL BEN SERP ADMIN",281.61,null,70.726636151551773,105.03719772749122,28.211708654274119,77.634457466682846,210.88336384844817,281.60999999999996]
[8,9260,9260115,"A&G EMPL BEN PENSION ADMIN",36694.619999999995,null,9215.8909039432347,13686.659054987938,3676.0694883679557,10116.00055270086,27478.729096056755,36694.619999999988]
[9,9260,9260141,"A&G EMPL BEN PROFIT SHARING",2620305.5,null,658092.37493132323,977342.9455982839,262502.38042396243,722367.79904642992,1962213.1250686762,2620305.4999999995]
[10,9260,9260190,"A&G EMPL BEN RESERVE",10530974.76,null,2644864.9556894116,3927928.9731520163,1054993.7565236827,2903187.0746348873,7886109.8043105863,10530974.759999998]
[11,9260,9260302,"A&G EMPL BEN TUITION LOANS",36554.57,null,36554.57,null,null,null,0,36554.57]
[12,9260,9260307,"A&G EMPL BEN EMPLOYEE EVENTS",34136.5,null,20959.150000000001,3815.53,1177.56,8184.26,{"$f":"SUM(H19:J19)","v":13177.35},34136.5]
[13,9260,9260310,"A&G EMPL BEN SVC RECOGNITION",59200,null,59200,null,null,null,{"$f":"SUM(H20:J20)","v":0},59200]
[14,9260,9260326,"A&G EMPL BEN EMPL ASST PROGRAM",21100.26,null,21100.26,null,null,null,0,21100.26]
[15,9260,9260328,"A&G EMPL BEN DISABILITY",61181.31,null,61181.31,null,null,null,0,61181.31]
[16,9260,9260337,"A&G EMPL BEN WELLNESS PROGRAM",74.16,null,74.16,null,null,null,0,74.16]
[17,9260,9260413,"A&G EMPL BEN ACTUARY ONE GAS PENSION-SC",1204699,null,{"$f":"$E24*F$39","v":302561.37156044977},{"$f":"$E24*F$40","v":449338.47187639266},{"$f":"$E24*F$41","v":120686.82647667119},{"$f":"$E24*F$42","v":332112.33008648612},902137.62843955006,1204698.9999999998]
[18,9260,9260431,"A&G EMPL BEN ACTUARY OPEB-SC",30824,null,{"$f":"$E25*F$39","v":7741.4787569171258},{"$f":"$E25*F$40","v":11496.987261646211},{"$f":"$E25*F$41","v":3087.9503837198445},{"$f":"$E25*F$42","v":8497.5835977168135},23082.521243082869,30823.999999999993]
[19,9260,9260511,"A&G EMPL BEN ACTUARY SERP-NSC",3362,null,{"$f":"$E26*F$39","v":844.36969831155523},{"$f":"$E26*F$40","v":1253.9862176763095},{"$f":"$E26*F$41","v":336.80538509168559},{"$f":"$E26*F$42","v":926.83869892044925},2517.6303016884444,3361.9999999999995]
[20,9260,9260513,"A&G EMPL BEN ACTUARY ONE GAS PENSION-NSC",-1215596,null,{"$f":"$E27*F$39","v":-305298.16412514372},{"$f":"$E27*F$40","v":-453402.92393291224},{"$f":"$E27*F$41","v":-121778.4886662441},{"$f":"$E27*F$42","v":-335116.42327569972},-910297.8358748561,-1215595.9999999998]
[21,9260,9260531,"A&G EMPL BEN ACTUARY OPEB-NSC",127641,null,{"$f":"$E28*F$39","v":32057.166169597029},{"$f":"$E28*F$40","v":47608.582632487152},{"$f":"$E28*F$41","v":12787.083925784606},{"$f":"$E28*F$42","v":35188.167272131192},95583.833830402946,127640.99999999997]
[22,"9260 Total",null,null,{"$f":"SUM(E12:E28)","v":17503321.290000003},{"$f":"E29/E$30","v":0.74026658419907976},{"$f":"SUM(G12:G28)","v":4541740.2859916491},6453181.7106289184,1733398.5600753929,4775000.7333040368,12961581.004008345,17503321.289999995]
[23,"Total Shared Service Test Year Benefits",null,null,{"$f":"SUM(E29+E11)","v":23644618.930000003},1,6084133.3959048754,8743813.0607800316,2348634.1688210387,6468038.3044940503,17560485.53409512,23644618.929999996]
[]
[{"$f":"A30+1","v":24},4081,4081100,"GEN TAX O/H TRF TO CAPITAL",-2980794.52,null,{"$f":"$E32*F$39","v":-748629.55668683432},{"$f":"$E32*F$40","v":-1111801.0844155473},{"$f":"$E32*F$41","v":-298616.19458292273},{"$f":"$E32*F$42","v":-821747.68431469519},{"$f":"SUM(H32:J32)","v":-2232164.9633131651},{"$f":"K32+G32","v":-2980794.5199999996}]
[{"$f":"A32+1","v":25},9260,9260902,"A&G EMPL BEN O/H TRF CAPITAL",-9481479.1500000004,null,{"$f":"$E33*F$39","v":-2381283.072407139},{"$f":"$E33*F$40","v":-3536479.5292341728},{"$f":"$E33*F$41","v":-949855.21604834567},{"$f":"$E33*F$42","v":-2613861.3323103413},-7100196.07759286,{"$f":"K33+G33","v":-9481479.1499999985}]
[{"$f":"A33+1","v":26},9260,9260905,"A&G EMPL BEN O/H TRF CAPITAL - NSC",668122.13,null,{"$f":"$E34*F$39","v":167799.54828773756},{"$f":"$E34*F$40","v":249201.64864501471},{"$f":"$E34*F$41","v":66932.519715326358},{"$f":"$E34*F$42","v":184188.41335192125},500322.5817122623,{"$f":"K34+G34","v":668122.12999999989}]
[27,"Total Shared Service Test Year Benefit and Tax O/H Transferred to Capital",null,null,{"$f":"SUM(E32:E34)","v":-11794151.539999999},null,{"$f":"SUM(G32:G34)","v":-2962113.0808062358},{"$f":"SUM(H32:H34)","v":-4399078.9650047058},-1181538.8909159419,-3251420.6032731151,{"$f":"SUM(K32:K34)","v":-8832038.4591937624},-11794151.539999999]
[null,null,null,null,{"$f":"E30+E35","v":11850467.390000004},null,{"$f":"G30+G35","v":3122020.3150986396},{"$f":"H30+H35","v":4344734.0957753258},1167095.2779050968,3216617.7012209352,{"$f":"K30+K35","v":8728447.0749013573},11850467.389999997]
[]
[{"$f":"A35+1","v":28},null,null,"Service Area","Test Year Payroll Dollars","Percent of Service Area Test Year Payroll to Total"]
[{"$f":"A38+1","v":29},null,null,"SHARED SERVICES",20051949.109999903,{"$f":"E39/$E43","v":0.25115101080058155}]
[{"$f":"A39+1","v":30},null,null,"CENTRAL GULF",29779453.090000242,{"$f":"E40/$E43","v":0.37298816706612414}]
[31,null,null,"RGV",7998397.4499999844,{"$f":"E41/$E43","v":0.10018006695172088}]
[32,null,null,"WEST NORTH",22010409.020000041,{"$f":"E42/$E43","v":0.27568075518157326}]
[33,null,null,"Grand Total",79840208.670000181,{"$f":"E43/$E43","v":1}]