{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["Аркуш1"],"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":"Аркуш1","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                       (у редакції  постанови Національної комісії, що здійснює державне регулювання у сфері комунальних послуг \nвід 11 липня 2014 року № 899)     "]
[]
["Структура тарифу на послугу з централізованого опалення та послугу з централізованого постачання гарячої води, що надаються населенню"]
["комунальним підприємством «Харківські теплові мережі»"]
["№ з/п","Назва показника","Усього на послуги","У тому числі"]
[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,12699.438093141649,0.5409370694995761,3744.9066913745773,0.49136377086337646,3.7361246498768033,8954.531401767072,0.5647663904803187,6582.381581378353,0.25329172902904157,5282.4640718167475,0.25678125903433313,1299.9175095616051,0.24003608288042397]
[" 2.1","витрати на оплату праці ",13188.0342,8685.9345601314,0.36998046310096383,2561.3743077848917,0.3360742048298659,2.5553677240924038,6124.560252346508,0.3862788159204383,4502.099639868601,0.17324194715016125,3613.0053083864223,0.1756286534791559,889.0943314821785,0.16417558735103513]
[" 2.2","внески на соціальні заходи ",4887.485474520001,3219.007347984697,0.13711475962521721,949.245318465081,0.12454910030994831,0.947019278548645,2269.762029519616,0.14315492918011447,1668.4781265353038,0.06420346561384976,1338.9797672880084,0.0650879789793752,329.4983592472954,0.060843472672293626]
[" 2.3","інші витрати абонентської служби",1206.300000000001,794.4961850255527,0.03384184677339501,234.28706512460496,0.030740465723562316,0.23373764723575477,560.2091199009477,0.03533264537976594,411.8038149744484,0.01584631626503059,330.47899614231704,0.016064626575802023,81.3248188321314,0.015017022857095249]
[3,"Витрати на періодичну повірку квартирних засобів обліку",8457.637,"x","x","x","x","x","x","x",8457.637,0.3254520377989707,6787.385846994998,0.3299357003944145,1670.251153005003,0.3084199891491902]
[4,"Витрати на придбання води для послуги з гарячого водопостачання",111485.7444905965,"x","x","x","x","x","x","x",111485.7444905965,4.29,88253.21191007884,4.29,23232.532580517654,4.29]
[5,"Решта витрат, крім послуг банку",506.94297543043194,333.8839923775017,0.01422190706902563,98.45824579219972,0.012918563508264837,0.098227355019317,235.425746585302,0.014848409499002596,173.05898305293024,0.0066593539890626285,138.88253802673322,0.006751098064756579,34.17644502619703,0.00631084659643759]
[6,"Собівартість послуг без урахування послуг банку",1526924.3453840404,1000096.1675366221,42.59945094556423,294915.948434648,38.69549349369978,294.22435200489616,705180.2191019742,44.47603890268896,526828.1778474181,20.272483206640434,422787.84465681476,20.551771593602446,104040.33319060331,19.211552930823146]
[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,"Послуги банку",32294.552086147403,21216.196680966103,0.9037114220609812,6256.393104430155,0.8208922574431481,6.241721469487676,14959.803576535945,0.9435216527966497,11078.3554051813,0.42629795320814734,8891.546215558179,0.43221920697470184,2186.8091896231217,0.4038049399465928]
[9,"Повна планова собівартість послуг з урахуванням послуг банку",1559218.8974701879,1021312.3642175882,43.50316236762521,301172.34153907816,39.51638575114293,300.4660734743838,720140.02267851,45.41956055548561,537906.5332525994,20.69878115984858,431679.39087237295,20.98399080057715,106227.14238022643,19.61535787076974]
[10,"Вартість послуг",1614727.6043073703,1060809.834048305,"x",312819.65522150777,"x","x",747990.1788267972,"x",553917.7702590651,"x",444577.310777909,"x",109340.45948115611,"x"]
[11,"Плановані тарифи на послуги, у т.ч. на послуги з централізованого опалення:","x","x",45.18557110304905,"x",41.0446128721574,312.08607347438385,"x",47.17608263983248,"x",21.31489766040737,"x",21.610960348735095,"x",20.190246997329645]
[" 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",34249.51876648527,1.4588703986295837,10099.758041596971,1.3251745918147946,10.076073474383836,24149.7607248883,1.5231364527759697,"x","x","x","x","x","x"]
[12,"Плановані тарифи на послуги, у т.ч. на послуги з централізованого опалення, з ПДВ","x","x","x","x",null,374.5032881692606,"x",56.611299167798975,"x","x","x",25.933152418482113,"x",24.228296396795574]
["Допоміжна інформація"]
[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,210.10054134390373,"x",61.95604225710762,"x","x",148.14449908679612,"x",108.89945865609627,"x",87.3935171759919,"x",21.50594148010436,"x"]
[" 6.1","абонентської служби",319,210.10054134390373,"x",61.95604225710762,"x","x",148.14449908679612,"x",108.89945865609627,"x",87.3935171759919,"x",21.50594148010436,"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.15,"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 куб. м холодної води без ПДВ, грн",4.29,"x","x","x","x","x","x","x",4.29,"x",4.29,"x",4.29,"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]