{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["dod 27"],"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 27","index":0,"n_rows":60,"n_cols":18,"rows_kept":60,"cut":false,"hidden":false,"merged":[[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],[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]],"flags":["formulas_cached_only"]}
[{"$nulls":13},"Додаток 27\nдо постанови Національної комісії, що здійснює державне регулювання у сфері комунальних послуг \n06 червня 2014 року № 650                       (у редакції  постанови Національної комісії, що здійснює державне регулювання у сфері комунальних послуг \nвід 13 червня 2014 року № 664)       "]
[]
["Структура тарифу на послугу з централізованого опалення та послугу з централізованого постачання гарячої води, що надаються населенню"]
[" товариством з обмеженою відповідальністю «Енергія-Новий Розділ»"]
["№ з/п","Назва показника","Усього на послуги","У тому числі"]
[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,"Собівартість власної теплової енергії, врахована у встановлених тарифах на теплову енергію для потреб населення ",18338.27031839367,16137.693444995202,40.61377709764077,3825.56876,37.7509274986017,259.22,12312.124684995202,41.59386075493175,2200.5768733984655,13.883765762766345,2200.5768733984655,13.883765762766345,0,12.726785282535818]
[2,"Витрати на утримання абонентської служби, усього, у т.ч.:",383.51284336479995,331.36264743363586,0.833941278363267,78.55215471614683,0.7751570769174209,5.32268293238561,252.81049271748904,0.8540657847862774,52.15019593116416,0.32902331817769187,52.15019593116416,0.32902331817769187,0,0.32902331817769187]
[" 2.1","витрати на оплату праці ",249.754008,215.79238017674524,0.5430852716182757,51.1553024020432,0.5048033987366046,3.466276080908199,164.63707777470205,0.5561908982618863,33.96162782325477,0.2142689452571279,33.96162782325477,0.2142689452571279,0,0.2142689452571279]
[" 2.2","відрахування на соціальні заходи ",92.5588353648,79.97265609350178,0.20126740166173296,18.95815507019721,0.18708013957178568,1.2846019155845787,61.014501023304575,0.20612434689585504,12.58617927129822,0.07940807111229162,12.58617927129822,0.07940807111229162,0,0.07940807111229162]
[" 2.3","інші витрати абонентської служби",41.2,35.597611163388834,0.0895886050832584,8.438697243906413,0.0832735386090305,0.5718049358928319,27.158913919482423,0.09175053962853608,5.60238883661117,0.03534630180827237,5.60238883661117,0.03534630180827237,0,0.03534630180827237]
[3,"Витрати на періодичну повірку квартирних засобів обліку",181.40425,"x","x","x","x","x","x","x",181.40425000000005,1.1445063091482652,181.40425000000005,1.1445063091482652,0,1.1445063091482652]
[4,"Витрати на придбання води для послуги з гарячого водопостачання",339.19,"x","x","x","x","x","x","x",339.19,2.14,339.19,2.14,0,2.14]
[5,"Решта витрат, крім послуг банку",1.5,1.2960295326476516,0.0032617210588564947,0.3072341229577577,0.0030318035901346053,0.020818140869884653,0.988795409689894,0.0033404322680292255,0.20397046735234842,0.001286879920204091,0.20397046735234842,0.001286879920204091,0,0.001286879920204091]
[6,"Собівартість послуг, без урахування послуг банку",19243.877411758465,16470.352121961485,41.450980097062896,3904.428148839105,38.529116379109254,264.5635010732555,12565.92397312238,42.45126697198605,2773.525289796982,17.498582270012506,2773.525289796982,17.498582270012506,0,16.34160178978198]
[7,"Розрахунковий прибуток, усього, у т.ч.:",1073.894542987485,945.0281093088,2.3783548196211206,224.02644,2.210705498915106,15.180000000000001,721.0016693088,2.4357488089648323,128.86643367868493,0.81303743645858,128.86643367868493,0.81303743645858,0,0.7452843167536983]
[" 7.1","прибуток у тарифі на теплову енергію для потреб населення",1073.894542987485,945.0281093088,2.3783548196211206,224.02644,2.210705498915106,15.180000000000001,721.0016693088,2.4357488089648323,128.86643367868493,0.81303743645858,128.86643367868493,0.81303743645858,0,0.7452843167536983]
[" 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,"Послуги банку",309.40769474232417,265.20883600919217,0.6674518007616855,62.86986683511328,0.6204033788531629,4.2600533158363785,202.3389691740789,0.6835586159535668,44.19885873313199,0.2788571528904227,44.19885873313199,0.2788571528904227,0,0.26020638740917273]
[9,"Повна планова собівартість послуг з урахуванням послуг банку",19553.285106500793,16735.56095797068,42.118431897824586,3967.2980156742183,39.149519757962416,268.8235543890919,12768.26294229646,43.13482558793962,2817.7241485301142,17.77743942290293,2817.7241485301142,17.77743942290293,0,16.601808177191153]
[10,"Вартість послуг",20627.17964948828,17680.589067279478,"x",4191.324455674218,"x","x",13489.26461160526,"x",2946.5905822087993,"x",2946.5905822087993,"x",0,"x"]
[11,"Плановані тарифи на послуги, у т.ч. на послуги з централізованого опалення:","x","x",44.4967867174457,"x",41.36022525687753,284.0035543890919,"x",45.570574396904455,"x",18.59047685936151,"x",18.59047685936151,"x",17.34709249394485]
[" 11.1","вартість теплової енергії","x",17082.721554304004,42.992131917261894,4049.5952,39.9616329975168,274.40000000000003,13033.126354304002,44.02960956389658,"x","x","x","x","x","x"]
[" 11.2","решта складових тарифу","x",597.8675129754738,1.5046548001838043,141.72925567421817,1.3985922593607214,9.603554389091894,456.1382573012579,1.5409648330078736,"x","x","x","x","x","x"]
[12,"Плановані тарифи на послуги, у т.ч. на послуги з централізованого опалення, з ПДВ","x","x","x","x",null,340.80426526691025,"x",54.68468927628535,"x","x","x",22.30857223123381,"x",20.816510992733818]
["Допоміжна інформація"]
[1,"Обсяг теплової енергії, врахований у розрахунку собівартості, Гкал",70744.04104001877,62254.81616,"x",14758,"x","x",47496.81616,"x",8489.22488001877,"x",8489.22488001877,"x",0,"x"]
[2,"Тариф на теплову енергію для потреб населення без ПДВ, грн/Гкал, у т. ч.:",274.40000000000003,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[" 2.1","повна планова собівартість теплової енергії для потреб населення, грн/Гкал",259.22,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[" 2.2","прибуток у тарифі на теплову енергію для потреб населення, грн/Гкал",15.18,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[3,"Загальна опалювана площа квартир, тис. кв. м","x",397.3453,"x",101.33708,"x","x",296.00822,"x","x","x","x","x","x","x"]
[4,"Обсяг споживання населенням гарячої води, тис. куб. м","x","x","x","x","x","x","x","x",158.5,"x",158.5,"x",0,"x"]
[5,"Кількість абонентів, яким надаються послуги",13304,8215,"x",1847,"x","x",6368,"x",5089,"x",5089,"x",0,"x"]
[6,"Середньорічна кількість штатних працівників, задіяних у наданні послуг, у т. ч.:",6.1,5.369999999999999,"x",1.2494187666948813,"x","x",4.021101332738902,"x",0.7187015096753321,"x",0.7187015096753321,"x",0,"x"]
[" 6.1","абонентської служби",6.1,5.369999999999999,"x",1.2494187666948813,"x","x",4.021101332738902,"x",0.7187015096753321,"x",0.7187015096753321,"x",0,"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,"Середньомісячна заробітна плата, грн",3411.94,3411.9400000000005,"x",3411.94,"x","x",3411.94,"x",3411.94,"x",3411.94,"x",0,"x"]
[9,"Обсяг холодної води для підігріву, тис. куб. м",158.5,"x","x","x","x","x","x","x",158.5,"x",158.5,"x",0,"x"]
[10,"Вартість 1 куб. м холодної води без ПДВ, грн",2.14,"x","x","x","x","x","x","x",2.14,"x",2.14,"x",2.14,"x"]
[11,"Відсоток послуг банку, %",1.5,1.5,"x",1.5,"x","x",1.5,"x",1.5,"x",1.5,"x",1.5,"x"]
[12,"Питомі норми, враховані у планованих тарифах на послуги з централізованого опалення та гарячого водопостачання, Гкал/кв.м на рік; Гкал/куб.м","x","x",0.1566768655876891,"x",0.1456327733145656,"x","x",0.16045776080137236,"x",0.05355977842283135,"x",0.05355977842283135,"x",0]
[13,"Тривалість опалювального періоду, діб","x","x",186,"x","x","x","x","x","x","x","x","x","x","x"]
[14,"Середня температура зовнішнього повітря опалювального періоду, град. С","x","x",-0.4,"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]