{"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},"Додаток 82\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,"Собівартість власної теплової енергії, врахована у встановлених тарифах на теплову енергію для потреб населення ",429268.23066415126,343062.2449971499,38.035479370429265,173005.5865194,31.26704122192943,315.06,170056.6584777499,48.777554554260654,86205.98566700134,18.605099788711097,84480.72645423992,18.6389496,1725.2592127614178,17.0857038]
[2,"Витрати на утримання абонентської служби, усього, у т.ч.:",9028.504875681838,6923.923597145576,0.7676588053105257,3491.7204688310603,0.6310534245213698,6.358762587048331,3432.2031283145166,0.9844629244821355,2104.5812785362605,0.45421375786912155,2061.8127446803805,0.4548969385762965,42.768533855879916,0.4235482390221482]
[" 2.1","витрати на оплату праці ",6175.2,4735.735715473528,0.5250533415916838,2388.2218081537208,0.4316197599450339,4.349184196965438,2347.5139073198075,0.6733402191138512,1439.4642845264716,0.31066725180026833,1410.212015861458,0.3111345249048451,29.252268665013524,0.2896930468138055]
[" 2.2","внески на соціальні заходи ",2288.5291199999997,1755.0636561544895,0.194584768393878,885.075002101769,0.15995828303562956,1.6118076633953915,869.9886540527206,0.24953988520359324,533.4654638455103,0.11513328351717943,522.6245730782563,0.11530645492973558,10.84089076725401,0.10736024314919627]
[" 2.3","інші витрати абонентської служби",564.7757556818382,433.1242255175594,0.04802069532496398,218.42365857557064,0.03947538154070639,0.3977707266875023,214.70056694198877,0.061582820164691,131.65153016427877,0.028413222551673854,128.9761557406664,0.028455958741715824,2.67537442361238,0.02649494905914644]
[3,"Витрати на періодичну повірку квартирних засобів обліку",2496.888,"x","x","x","x","x","x","x",2496.888,0.5388819586227138,2446.1471519028373,0.5396924883594236,50.740848097162434,0.5025002009763496]
[4,"Витрати на придбання води для послуги з гарячого водопостачання",18070.494000000002,"x","x","x","x","x","x","x",18070.494000000002,3.9,17676.68459018397,3.9,393.8094098160316,3.9]
[5,"Решта витрат, крім послуг банку",180.09891303995676,138.11712249016784,0.015313113115147587,69.65218158874292,0.01258813473452968,0.12684339721531815,68.46494090142491,0.019637880808474367,41.98179054978892,0.009060570405223938,41.1286518999441,0.009074198365164845,0.8531386498448185,0.008448860416893328]
[6,"Собівартість послуг без урахування послуг банку",459044.2164528731,350124.2857167857,38.818451288854945,176566.95916981983,31.91068278118533,321.5456059842637,173557.32654696587,49.781655359551266,108919.9307360874,23.507256075608158,106706.49959290706,23.542613225300887,2213.431143180336,21.920201100415394]
[7,"Розрахунковий прибуток, усього, у т.ч.:",17181.08420197723,13730.765280943502,1.5223366814610328,6924.396768899999,1.251435884620485,12.609999999999998,6806.368512043503,1.9522788133346878,3450.318921033729,0.7446527910101152,3381.2669351487502,0.7460075999999999,69.05198588497898,0.6838403000000001]
[" 7.1","прибуток у тарифі на теплову енергію для потреб населення",17181.08420197723,13730.765280943502,1.5223366814610328,6924.396768899999,1.251435884620485,12.609999999999998,6806.368512043503,1.9522788133346878,3450.318921033729,0.7446527910101152,3381.2669351487502,0.7460075999999999,69.05198588497898,0.6838403000000001]
[" 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,"Послуги банку",9718.883686833678,7425.613285667943,0.8232813871493057,3744.721549769793,0.6767779319552208,6.819502162944158,3680.8917358981503,1.0557945749568562,2293.2704011657374,0.4949369156452709,2246.6891128174657,0.49568613929185484,46.58128834827174,0.4613069673554162]
[9,"Повна планова собівартість послуг з урахуванням послуг банку",468763.10013970674,357549.89900245366,39.64173267600425,180311.68071958964,32.58746071314055,328.3651081472079,177238.21828286402,50.83744993450812,111213.20113725313,24.002192991253427,108953.18870572452,24.03829936459274,2260.012431528608,22.381508067770806]
[10,"Вартість послуг",485944.184341684,371280.66428339714,"x",187236.07748848965,"x","x",184044.58679490752,"x",114663.52005828686,"x",112334.45564087328,"x",2329.064417413587,"x"]
[11,"Плановані тарифи на послуги, у т.ч. на послуги з централізованого опалення:","x","x",41.16406935746528,"x",33.83889659776104,340.97510814720795,"x",52.78972874784281,"x",24.74684578226354,"x",24.78430696459274,"x",23.065348367770806]
[" 11.1","вартість теплової енергії","x",356793.0102780934,39.5578160518903,179929.98328830002,32.518477106549916,327.67,176863.0269897934,50.72983336759534,"x","x","x","x","x","x"]
[" 11.2","решта складових тарифу","x",14487.654005303746,1.6062533055749855,7306.094200189633,1.320419491211127,13.305108147207873,7181.559805114113,2.059895380247472,"x","x","x","x","x","x"]
[12,"Плановані тарифи на послуги, у т.ч. на послуги з централізованого опалення, з ПДВ","x","x","x","x",null,409.1701297766495,"x",63.34767449741137,"x","x","x",29.741168357511288,"x",27.678418041324967]
["Допоміжна інформація"]
[1,"Обсяг теплової енергії, врахований у розрахунку собівартості, Гкал",1362496.7646294397,1088879.0865141558,"x",549119.49,"x","x",539759.5965141557,"x",273617.6781152839,"x",268141.7077834061,"x",5475.970331877794,"x"]
[2,"Тариф на теплову енергію для потреб населення без ПДВ, грн/Гкал, у т. ч.:",327.67,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[" 2.1","повна планова собівартість теплової енергії для потреб населення, грн/Гкал",315.06,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[" 2.2","прибуток у тарифі на теплову енергію для потреб населення, грн/Гкал",12.61,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[3,"Загальна опалювана площа квартир, тис. кв. м","x",9019.532570000001,"x",5533.161430000001,"x","x",3486.37114,"x","x","x","x","x","x","x"]
[4,"Обсяг споживання населенням гарячої води, тис. куб. м","x","x","x","x","x","x","x","x",4633.460000000001,"x",4532.4832282523,"x",100.97677174770041,"x"]
[5,"Кількість абонентів, яким надаються послуги",459048,193564,"x",112173,"x","x",81391,"x",265484,"x",259723,"x",5761,"x"]
[6,"Середньорічна кількість штатних працівників, задіяних у наданні послуг, у т. ч.:",166,127.30472353423465,"x",64.19951097187423,"x","x",63.105212562360414,"x",38.69527646576535,"x",37.90892515756607,"x",0.7863513081992883,"x"]
[" 6.1","абонентської служби",166,127.30472353423465,"x",64.19951097187423,"x","x",63.105212562360414,"x",38.69527646576535,"x",37.90892515756607,"x",0.7863513081992883,"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,"Середньомісячна заробітна плата, грн",3100,3100,"x",3100,"x","x",3100,"x",3100,"x",3100,"x",3100,"x"]
[9,"Обсяг холодної води для підігріву, тис. куб. м",4633.460000000001,"x","x","x","x","x","x","x",4633.460000000001,"x",4532.4832282523,"x",100.97677174770041,"x"]
[10,"Вартість 1 куб. м холодної води без ПДВ, грн",3.9,"x","x","x","x","x","x","x",3.9,"x",3.9,"x",3.9,"x"]
[11,"Відсоток послуг банку, %",2,2,"x",2,"x","x",2,"x",2,"x",2,"x",2,"x"]
[12,"Питомі норми, враховані у планованих тарифах на послуги з централізованого опалення та гарячого водопостачання, Гкал/кв. м на рік; Гкал/куб. м","x","x",0.12072455840293682,"x",0.09924154517212413,"x","x",0.1548198900344717,"x",0.0590525607462423,"x",0.059160000000000004,"x",0.05423000000000001]
[13,"Тривалість опалювального періоду, діб","x","x",172,"x","x","x","x","x","x","x","x","x","x","x"]
[14,"Середня температура зовнішнього повітря під час опалювального періоду, град. С","x","x",-0.2,"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]