{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["dod 7"],"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,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"dod 7","index":0,"n_rows":60,"n_cols":18,"rows_kept":60,"cut":false,"hidden":false,"merged":[[6,14,7,15],[5,5,5,9],[5,3,7,4],[6,5,7,7],[6,8,7,9],[5,10,7,11],[6,12,7,13],[0,13,1,15],[31,0,31,15],[52,0,52,15],[3,0,3,15],[5,12,5,15],[2,0,2,15],[4,0,8,0],[4,1,8,1],[4,2,7,2],[4,3,4,15]],"flags":["formulas_cached_only"]}
[{"$nulls":13},"Додаток 7\nдо постанови Національної комісії, що здійснює державне регулювання у сфері комунальних послуг \n06 червня 2014 року № 650"]
[]
["Структура тарифу на послугу з централізованого опалення та послугу з централізованого постачання гарячої води, що надаються населенню"]
["комунальним підприємством «Харківські теплові мережі»"]
["№ з/п","Назва показника","Усього на послуги","У тому числі"]
[null,null,null,"усього на послугу з централізованого опалення",null,"у тому числі",{"$nulls":4},"усього на послугу з централізованого постачання гарячої води",null,"у тому числі"]
[{"$nulls":5},"з будинковими та квартирними приладами обліку теплової енергії",null,null,"без будинкових та квартирних приладів обліку теплової енергії",null,null,null,"з рушникосушильниками",null,"без рушникосушильників"]
[]
[null,null,"тис. грн","тис. грн","грн/кв.м на рік","тис. грн","грн/кв.м на рік","грн/Гкал","тис. грн","грн/кв.м на рік","тис. грн","грн/куб.м","тис. грн","грн/куб.м","тис. грн","грн/куб.м"]
[1,2,3,4,5,6,null,7,8,9,10,11,12,13,14,15]
[1,"Собівартість власної теплової енергії, врахована у встановлених тарифах на теплову енергію для потреб населення ",1387192.2012434932,987062.8454511029,42.04429196899562,291072.5834974812,38.191211159328134,290.39,695990.2619536218,43.89642410270964,400129.3557923903,15.397080085823356,322325.90028989746,15.668303536108942,77803.45550249286,14.366786012197096]
[2,"Витрати на утримання абонентської служби, усього, у т.ч.:",19281.819674520004,13215.027911714831,0.5628988006783292,3896.9477303101557,0.5113128548791253,3.8878091430227704,9318.080181404675,0.5876955782655038,6066.79176280517,0.2334517007654682,4877.232572809233,0.23708290366440576,1189.5591899959372,0.21965788307392803]
[" 2.1","витрати на оплату праці ",13188.0342,9038.578463834134,0.3850014552461885,2665.3646186130554,0.34971862256114605,2.6591141711075754,6373.213845221078,0.4019615117340932,4149.455736165866,0.15967211942198622,3335.8423145383636,0.1621557246432097,813.6134216275026,0.15023767067517074]
[" 2.2","відрахування на соціальні заходи ",4887.485474520001,3349.69717869693,0.14268153931423747,987.7841276579985,0.12960572152116076,0.9854677118124675,2361.913051038932,0.14896693624865495,1537.7882958230703,0.0591744874577881,1236.2631617679178,0.060094911552773536,301.52513405515253,0.05567808075221829]
[" 2.3","інші витрати абонентської служби",1206.300000000001,826.752269183767,0.03521580611790327,243.798984039102,0.03198851079681844,0.24322726010272788,582.953285144665,0.03676713028275564,379.5477308162341,0.014605093885693908,305.12709650295204,0.014832267468422554,74.42063431328206,0.013742131646539]
[3,"Витрати на періодичну повірку квартирних засобів обліку",8457.637,"x","x","x","x","x","x","x",8457.637,0.3254520377989707,6799.2877089164185,0.3305142514356493,1658.349291083582,0.3062222525285295]
[4,"Витрати на придбання води для послуги з гарячого водопостачання",53014.20017734658,"x","x","x","x","x","x","x",53014.20017734658,2.0399999999999996,41966.562306890635,2.04,11047.637870455948,2.04]
[5,"Решта витрат, крім послуг банку",506.94297543043194,347.4394887539417,0.014799308244707848,102.45559344748291,0.013443049691559,0.10221532864318024,244.98389530645878,0.015451246309855315,159.50348667649024,0.006137735016873474,128.2284988689836,0.006233203848812172,31.274987807506655,0.005775078426306205]
[6,"Собівартість послуг, без урахування послуг банку",1468452.8010707903,1000625.3128515717,42.62199007791866,295071.9868212388,38.715967063898816,294.38002447166593,705553.326030333,44.499570927285006,467827.4882192185,18.002121559404667,376097.2113773827,18.282133895057807,91730.27684183583,16.93844122622586]
[7,"Розрахунковий прибуток, усього, у т.ч.:",55508.706837182384,39497.469830716684,1.6824087354238413,11647.313682429598,1.5282271210144731,11.62,27850.156148287082,1.756522084346865,16011.237006465703,0.6161165005587913,12897.919905536031,0.6269695481579458,3113.317100929671,0.5748891265599032]
[" 7.1","прибуток у тарифі на теплову енергію для потреб населення",55508.706837182384,39497.469830716684,1.6824087354238413,11647.313682429598,1.5282271210144731,11.62,27850.156148287082,1.756522084346865,16011.237006465703,0.6161165005587913,12897.919905536031,0.6269695481579458,3113.317100929671,0.5748891265599032]
[" 7.2","плановий прибуток на послугу, усього, у т.ч.:",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"чистий прибуток",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"податок на прибуток",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[8,"Послуги банку",31101.255263428015,21226.995564944664,0.9041714043539287,6259.577561299357,0.8213100854063938,6.244898458605428,14967.418003645309,0.9440018981965689,9874.259698483353,0.3799640420400706,7938.676148630995,0.3859000702697093,1935.583549852357,0.35741490515889307]
[9,"Повна планова собівартість послуг з урахуванням послуг банку",1499554.0563342182,1021852.3084165164,43.52616148227259,301331.5643825382,39.53727714930521,300.6249229302714,720520.7440339782,45.44357282548157,477701.74791770184,18.382085601444736,384035.88752601366,18.668033965327517,93665.86039168818,17.295856131384753]
[10,"Вартість послуг",1555062.7631714006,1061349.778247233,"x",312978.8780649678,"x","x",748370.9001822653,"x",493712.98492416757,"x",396933.8074315497,"x",96779.17749261786,"x"]
[11,"Плановані тарифи на послуги, у т.ч. на послуги з централізованого опалення:","x","x",45.20857021769643,"x",41.06550427031969,312.2449229302714,"x",47.20009490982844,"x",18.99820210200353,"x",19.29500351348546,"x",17.870745257944655]
[" 11.1","вартість теплової енергії","x",1026560.3152818197,43.72670070441947,302719.8971799108,39.71943828034261,302.01,723840.4181019089,45.65294618705651,"x","x","x","x","x","x"]
[" 11.2","решта складових тарифу","x",34789.462965413346,1.481869513276962,10258.980885057012,1.3460659899770802,10.234922930271395,24530.48208035645,1.5471487227719285,"x","x","x","x","x","x"]
[12,"Плановані тарифи на послуги, у т.ч. на послуги з централізованого опалення, з ПДВ:","x","x","x","x",null,374.6939075163257,"x",56.64011389179412,"x","x","x",23.154004216182553,"x",21.444894309533584]
["Допоміжна інформація"]
[1,"Обсяг теплової енергії, врахований у розрахунку собівартості, Гкал",4776997.146057004,3399093.789218303,"x",1002350.57508,"x","x",2396743.214138303,"x",1377903.3568387008,"x",1109975.8954850286,"x",267927.4613536722,"x"]
[2,"Тариф на теплову енергію для потреб населення без ПДВ, грн/Гкал, у т. ч.:",302.01,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[" 2.1","повна планова собівартість теплової енергії для потреб населення, грн/Гкал",290.39,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[" 2.2","прибуток у тарифі на теплову енергію для потреб населення, грн/Гкал",11.62,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[3,"Загальна опалювана площа квартир, тис. кв. м","x",23476.73844,"x",7621.45464,"x","x",15855.283800000001,"x","x","x","x","x","x","x"]
[4,"Обсяг споживання населенням гарячої води, тис. куб. м","x","x","x","x","x","x","x","x",25987.353028111072,"x",20571.844268083645,"x",5415.5087600274255,"x"]
[5,"Кількість абонентів, яким надаються послуги",902002,484432,"x",150250,"x","x",334182,"x",417570,"x",314142,"x",103428,"x"]
[6,"Середньорічна кількість штатних працівників, задіяних у наданні послуг, у т. ч.:",319,218.63050142553382,"x",64.47142162685358,"x","x",154.15907979868024,"x",100.36949857446618,"x",80.6893341494169,"x",19.68016442504929,"x"]
[" 6.1","абонентської служби",319,218.63050142553382,"x",64.47142162685358,"x","x",154.15907979868024,"x",100.36949857446618,"x",80.6893341494169,"x",19.68016442504929,"x"]
[" 6.2","решта працівників, задіяних у наданні послуг",0,0,"x",0,"x","x",0,"x",0,"x",0,"x",0,"x"]
[7,"Середньорічна кількість позаштатних працівників за договором, задіяних у наданні послуг, у т.ч.:",0,0,"x",0,"x","x",0,"x",0,"x",0,"x",0,"x"]
[" 7.1","абонентської служби",0,0,"x",0,"x","x",0,"x",0,"x",0,"x",0,"x"]
[" 7.2","решта працівників, задіяних у наданні послуг",0,0,"x",0,"x","x",0,"x",0,"x",0,"x",0,"x"]
[8,"Середньомісячна заробітна плата, грн",3445.15,3445.15,"x",3445.15,"x","x",3445.15,"x",3445.1500000000005,"x",3445.15,"x",3445.15,"x"]
[9,"Обсяг холодної води для підігріву, тис. куб. м",25987.353028111072,"x","x","x","x","x","x","x",25987.353028111072,"x",20571.844268083645,"x",5415.5087600274255,"x"]
[10,"Вартість 1 куб. м холодної води без ПДВ, грн",2.04,"x","x","x","x","x","x","x",2.04,"x",2.04,"x",2.04,"x"]
[11,"Відсоток послуг банку, %",2,2,"x",2,"x","x",2,"x",2,"x",2,"x",2,"x"]
[12,"Питомі норми, враховані у планованих тарифах на послуги з централізованого опалення та гарячого водопостачання, Гкал/кв.м на рік; Гкал/куб.м","x","x",0.14478560545816188,"x",0.13151696394272577,"x","x",0.15116369056341347,"x",0.053022074058415775,"x",0.05395607127004698,"x",0.049474107277100096]
[13,"Тривалість опалювального періоду, діб","x","x",179,"x","x","x","x","x","x","x","x","x","x","x"]
[14,"Середня температура зовнішнього повітря опалювального періоду, град. С","x","x",-1,"x","x","x","x","x","x","x","x","x","x","x"]
["Інформаційно:"]
["1.","Питомі норми, враховані у діючих тарифах на послуги з централізованого опалення та  гарячого водопостачання , Гкал/кв.м на рік; Гкал/куб.м","x","x",0.1465,"x",null,"x","x",0.1465,"x",0.05,"x",0,"x",0,null,34.16402640264026]
["2.","Врахована у діючих тарифах на послугу з централізованого опалення тривалість опалювального періоду, діб","x","x",187,"x","x","x","x","x","x","x","x","x","x","x"]
["3.","Врахована у діючих тарифах  на послугу з централізованого опалення середня температура зовнішнього повітря опалювального періоду, град. С","x","x",-0.2,"x","x","x","x","x","x","x","x","x","x","x"]
["4.","Діючі тарифи на послуги, грн/мкв на рік; грн/Гкал; грн/мкуб","x","x",5.63,"x",0,0,"x",0,"x",13.89,"x",0,"x",0]
["5.","Діючий тариф на послугу з централізованого опалення протягом опалювального періоду, грн/мкв на міс; грн/Гкал","x","x",3.67,"x",0,0,"x",3.67,"x","x","x","x","x","x"]
["6.","Діючий тариф на послугу з централізованого опалення протягом міжопалювального періоду, грн/мкв на міс","x","x",1.96,"x",0,"x","x",1.96,"x","x","x","x","x","x"]
["7.","Діючий тариф на підігрів гарчої води (за наявності), грн/куб.м","x","x","x","x","x","x","x","x","x",0,"x",0,0,0]