{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["dod 2"],"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 2","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},"Додаток 2\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,"Собівартість власної теплової енергії, врахована у встановлених тарифах на теплову енергію для потреб населення ",556414.5187427355,405466.07177508686,33.675419511338426,219755.3838236137,31.663700126136167,274.8,185710.68795147317,36.41298586481192,150948.44696764866,13.990542455379957,71730.6297875705,14.658363636760296,79217.81718007816,13.436255418530806]
[2,"Витрати на утримання абонентської служби, усього, у т.ч.:",20341.7615960653,13766.21662376692,1.1433339363261514,7461.044039297567,1.0750328705386119,9.329896115967912,6305.172584469354,1.236278658627741,6575.544972298379,0.6094494044176367,3093.290734342372,0.6321229933780499,3482.2542379560077,0.590630479846202]
[" 2.1","витрати на оплату праці ",6699.240055550261,4533.687477546681,0.376539095050041,2457.1778038119883,0.354045210555339,3.0726549162932395,2076.509673734693,0.40714898120244025,2165.5525780035805,0.2007126001661344,1018.7267751175142,0.20817979098190245,1146.8258028860664,0.19451488259403776]
[" 2.2","відрахування на соціальні заходи ",2482.7383645869268,1680.1845791788,0.1395453886255452,910.6300940927229,0.13120915503180863,1.1387259119782744,769.5544850860772,0.15088941243362436,802.5537854081269,0.07438408962156941,377.5401428585508,0.07715143053789306,425.0136425495762,0.0720872154893504]
[" 2.3","інші витрати абонентської служби",11159.78317592811,7552.344567041439,0.6272494526505652,4093.236141392855,0.5897785049514642,5.1185152876963995,3459.108425648584,0.6782402649916767,3607.4386088866722,0.33435271462993293,1697.023816366307,0.3467917718582544,1910.4147925203652,0.32402838176281384]
[3,"Витрати на періодичну повірку квартирних засобів обліку",6716.09450241628,"x","x","x","x","x","x","x",6716.094502416283,0.6224761311425541,3159.4085331045208,0.6456343586063761,3556.685969311762,0.6032549599106551]
[4,"Витрати на придбання води для послуги з гарячого водопостачання",42725.70930672,"x","x","x","x","x","x","x",42725.70930672,3.96,19378.240368278854,3.96,23347.468938441143,3.9599999999999995]
[5,"Решта витрат, крім послуг банку",367.3405406769198,248.59643712608914,0.02064683062776424,134.7348379080413,0.019413419729857655,0.16848339646071156,113.86159921804784,0.02232526759017247,118.74410355083067,0.011005707282367602,55.86001416140998,0.011415156994403134,62.884089389420694,0.010665866807176594]
[6,"Собівартість послуг, без урахування послуг банку",626565.424688614,419480.88483597984,34.83940027829234,227351.1627008193,32.758146416404635,284.2983795124286,192129.72213516055,37.67158979102984,207084.53985263416,19.193473698222515,97417.42943745767,19.907536145739126,109667.11041517649,18.600806725094838]
[7,"Розрахунковий прибуток, усього, у т.ч.:",22272.779134534536,16230.446832336082,1.3479971420113632,8796.612889591523,1.267469801264548,11,7433.83394274456,1.4575794924051353,6042.332302198454,0.5600289920275819,2871.313419444234,0.5867612809474645,3171.01888275422,0.5378413741042171]
[" 7.1","прибуток у тарифі на теплову енергію для потреб населення",22272.779134534536,16230.446832336082,1.3479971420113632,8796.612889591523,1.267469801264548,11,7433.83394274456,1.4575794924051353,6042.332302198454,0.5600289920275819,2871.313419444234,0.5867612809474645,3171.01888275422,0.5378413741042171]
[" 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,"Послуги банку",3260.493486548485,2189.5041792377688,0.18184621819248092,1186.672239147793,0.17098299606868939,1.4839114548363248,1002.8319400899754,0.19662899137404508,1070.9893073107166,0.0992638326143221,503.96353194423074,0.10298641922958088,567.025775366486,0.09617411105125154]
[9,"Повна планова собівартість послуг з урахуванням послуг банку",629825.9181751625,421670.3890152176,35.021246496484814,228537.83493996708,32.92912941247332,285.78229096726494,193132.55407525052,37.86821878240388,208155.52915994488,19.29273753083684,97921.3929694019,20.010522564968706,110234.13619054298,18.69698083614609]
[10,"Вартість послуг",652098.697309697,437900.8358475537,"x",237334.4478295586,"x","x",200566.38801799508,"x",214197.86146214334,"x",100792.70638884614,"x",113405.1550732972,"x"]
[11,"Плановані тарифи на послуги, у т.ч. на послуги з централізованого опалення:","x","x",36.36924363849618,"x",34.19659921373787,296.78229096726494,"x",39.32579827480901,"x",19.85276652286442,"x",20.597283845916174,"x",19.234822210250307]
[" 11.1","вартість теплової енергії","x",421696.51860742294,35.023416653349784,228551.9967132052,32.93116992740072,285.8,193144.52189421773,37.87056535721706,"x","x","x","x","x","x"]
[" 11.2","решта складових тарифу","x",16204.317240130738,1.3458269851463933,8782.45111635339,1.2654292863371572,10.982290967264936,7421.866123777349,1.455232917591953,"x","x","x","x","x","x"]
[12,"Плановані тарифи на послуги, у т.ч. на послуги з централізованого опалення, з ПДВ:","x","x","x","x",null,356.1387491607179,"x",47.19095792977081,"x","x","x",24.716740615099408,"x",23.08178665230037]
["Допоміжна інформація"]
[1,"Обсяг теплової енергії, врахований у розрахунку собівартості, Гкал",2024798.1031395032,1475495.1665760074,"x",799692.0808719567,"x","x",675803.0857040508,"x",549302.9365634958,"x",261028.49267674854,"x",288274.4438867473,"x"]
[2,"Тариф на теплову енергію для потреб населення без ПДВ, грн/Гкал, у т. ч.:",285.8,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[" 2.1","повна планова собівартість теплової енергії для потреб населення, грн/Гкал",274.8,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[" 2.2","прибуток у тарифі на теплову енергію для потреб населення, грн/Гкал",11,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[3,"Загальна опалювана площа квартир, тис. кв. м","x",12040.4163529,"x",6940.293868000001,"x","x",5100.1224849,"x","x","x","x","x","x","x"]
[4,"Обсяг споживання населенням гарячої води, тис. куб. м","x","x","x","x","x","x","x","x",10789.320532,"x",4893.49504249466,"x",5895.82548950534,"x"]
[5,"Кількість абонентів, яким надаються послуги",460664,248155,"x",140491,"x","x",107664,"x",212509,"x",197672,"x",14837,"x"]
[6,"Середньорічна кількість штатних працівників, задіяних у наданні послуг, у т. ч.:",165,111.66317785185838,"x",60.519452097119476,"x","x",51.1437257547389,"x",53.33682214814165,"x",25.09089337008141,"x",28.245928778060236,"x"]
[" 6.1","абонентської служби",165,111.66317785185838,"x",60.519452097119476,"x","x",51.1437257547389,"x",53.33682214814165,"x",25.09089337008141,"x",28.245928778060236,"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,"Середньомісячна заробітна плата, грн",3383.4545735102324,3383.454573510232,"x",3383.4545735102324,"x","x",3383.4545735102324,"x",3383.454573510232,"x",3383.4545735102324,"x",3383.4545735102324,"x"]
[9,"Обсяг холодної води для підігріву, тис. куб. м",10789.320532,"x","x","x","x","x","x","x",10789.320532,"x",4893.49504249466,"x",5895.82548950534,"x"]
[10,"Вартість 1 куб. м холодної води без ПДВ, грн",3.96,"x","x","x","x","x","x","x",3.96,"x",3.96,"x",3.96,"x"]
[11,"Відсоток послуг банку, %",0.5,0.5,"x",0.5,"x","x",0.5,"x",0.5,"x",0.5,"x",0.5,"x"]
[12,"Питомі норми, враховані у планованих тарифах на послуги з централізованого опалення та гарячого водопостачання, Гкал/кв.м на рік; Гкал/куб.м","x","x",0.12254519472830576,"x",0.11522452738768621,"x","x",0.13250722658228503,"x",0.05091172654796199,"x",0.053341934631587686,"x",0.04889467037311065]
[13,"Тривалість опалювального періоду, діб","x","x",172,"x","x","x","x","x","x","x","x","x","x","x"]
[14,"Середня температура зовнішнього повітря опалювального періоду, град. С","x","x",1.8,"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]