{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["dod 12"],"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 12","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},"Додаток 12\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,"Собівартість власної теплової енергії, врахована у встановлених тарифах на теплову енергію для потреб населення ",110002.84569890029,84216.37736793509,42.28453740432571,10856.448504,42.65099398632927,289.53,73359.92886393509,44.47130263266371,25786.468330965203,15.36232545491046,20121.98356040076,15.666535056725516,5664.484770564444,14.371040419602808]
[2,"Витрати на утримання абонентської служби, усього, у т.ч.:",656.2075337907199,479.8305457967463,0.2409200359312252,61.85561257675261,0.2473348327394326,1.649623769941771,417.9749332199937,0.2533793316862368,176.37698799397373,0.10507684330957928,137.18612177830371,0.10681010545926546,39.19086621567,0.09942890576586678]
[" 2.1","витрати на оплату праці ",478.77353379071997,350.0876692237192,0.17577691663711761,45.13028073159309,0.16875522347289848,1.2035768580677042,304.95738849212614,0.18486730458605122,128.6858645670008,0.07666478819632914,100.09193879780992,0.07792938819200004,28.593925769190886,0.07254401408571842]
[" 2.2","відрахування на соціальні заходи ",177.434,129.74287657302708,0.06514311929410758,16.725331845159523,0.06919967133494455,0.44604691187406714,113.01754472786756,0.06851202710018556,47.69112342697292,0.02841205511325014,37.094182980493805,0.028880717267265422,10.596940446479117,0.026884891680148376]
[" 2.3","інші витрати абонентської служби",0,0,0,0,0.009379937931589583,0,0,0,0,0,0,0,0,0]
[3,"Витрати на періодичну повірку квартирних засобів обліку",857.4369999999999,"x","x","x","x","x","x","x",857.4370000000001,0.5108193212819468,666.9149872501646,0.5192453813634992,190.5220127498355,0.4833625046147201]
[4,"Витрати на придбання води для послуги з гарячого водопостачання",5169.941405842696,"x","x","x","x","x","x","x",5169.941405842696,3.08,3955.9295748314603,3.08,1214.0118310112362,3.08]
[5,"Решта витрат, крім послуг банку",0,0,0,0,0.005250342006917761,0,0,0,0,0,0,0,0,0]
[6,"Собівартість послуг, без урахування послуг банку",116686.43163853372,84696.20791373184,42.52545744025694,10918.304116576752,42.90357916107562,291.1796237699417,73777.90379715509,44.72468196434995,31990.22372480188,19.05822161950199,24882.014244260692,19.372590543548284,7108.209480541185,18.033831829983395]
[7,"Розрахунковий прибуток, усього, у т.ч.:",4342.667517488448,3324.6751401080996,1.669299425038659,428.588424,0,11.43,2896.0867161080996,1.7556280492223473,1017.9923773803484,0.606470417399325,794.3711259468128,0.6184799354069446,223.62125143353575,0.5673366904847861]
[" 7.1","прибуток у тарифі на теплову енергію для потреб населення",4342.667517488448,3324.6751401080996,1.669299425038659,428.588424,0,11.43,2896.0867161080996,1.7556280492223473,1017.9923773803484,0.606470417399325,794.3711259468128,0.6184799354069446,223.62125143353575,0.5673366904847861]
[" 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,"Послуги банку",1718.465910937434,1249.789414557565,0.6275117607648462,161.1120644706638,0.4771884436520039,4.296688369958605,1088.677350086901,0.6599638338641095,468.6764963798694,0.2792146942359213,364.5734231063946,0.2838488708979444,104.10307327347475,0.26411395465167803]
[9,"Повна планова собівартість послуг з урахуванням послуг банку",118404.89754947115,85945.9973282894,43.15296920102179,11079.416181047416,43.38076760472762,295.47631213990036,74866.58114724199,45.38464579821406,32458.900221181746,19.33743631373791,25246.587667367086,19.65643941444623,7212.31255381466,18.297945784635072]
[10,"Вартість послуг",122747.56506695959,89270.6724683975,"x",11508.004605047416,"x","x",77762.66786335009,"x",33476.892598562095,"x",26040.958793313897,"x",7435.933805248195,"x"]
[11,"Плановані тарифи на послуги, у т.ч. на послуги з централізованого опалення:","x","x",44.82226862606045,"x",43.38076760472762,306.9063121399003,"x",47.140273847436404,"x",19.943906731137233,"x",20.27491934985317,"x",18.865282475119855]
[" 11.1","вартість теплової енергії","x",87541.05250804318,43.95383682936437,11285.036928,42.65099398632927,300.9599999999999,76256.01558004318,46.22693068188605,"x","x","x","x","x","x"]
[" 11.2","решта складових тарифу","x",1729.619960354321,0.8684317966960763,222.96767704741615,0.7297736183983546,5.946312139900368,1506.652283306903,0.9133431655503513,"x","x","x","x","x","x"]
[12,"Плановані тарифи на послуги, у т.ч. на послуги з централізованого опалення, з ПДВ:","x","x","x","x",null,368.28757456788037,"x",56.56832861692369,"x","x","x",24.329903219823805,"x",22.638338970143824]
["Допоміжна інформація"]
[1,"Обсяг теплової енергії, врахований у розрахунку собівартості, Гкал",379935.9157907654,290872.71566999995,"x",37496.8,"x","x",253375.91566999996,"x",89063.20012076541,"x",69498.78617207462,"x",19564.41394869079,"x"]
[2,"Тариф на теплову енергію для потреб населення без ПДВ, грн/Гкал, у т. ч.:",300.96,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[" 2.1","повна планова собівартість теплової енергії для потреб населення, грн/Гкал",289.53,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[" 2.2","прибуток у тарифі на теплову енергію для потреб населення, грн/Гкал",11.43,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[3,"Загальна опалювана площа квартир, тис. кв. м","x",1991.6589500000002,"x",342.05742000000004,"x","x",1649.6015300000001,"x","x","x","x","x","x","x"]
[4,"Обсяг споживання населенням гарячої води, тис. куб. м","x","x","x","x","x","x","x","x",1678.552404494382,"x",1284.3927191011235,"x",394.1596853932585,"x"]
[5,"Кількість абонентів, яким надаються послуги",73862,40414,"x",6370,"x","x",34044,"x",33448,"x",25415,"x",8033,"x"]
[6,"Середньорічна кількість штатних працівників, задіяних у наданні послуг, у т. ч.:",13,10,"x",1.2254095268498362,"x","x",8.28042022082734,"x",2.910618877336716,"x",2.2712464711591354,"x",0.6393724061775808,"x"]
[" 6.1","абонентської служби",13,10,"x",1.2254095268498362,"x","x",8.28042022082734,"x",2.910618877336716,"x",2.2712464711591354,"x",0.6393724061775808,"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,"Середньомісячна заробітна плата, грн",3069.061114043077,3069.0611140430765,"x",3069.0611140430765,"x","x",3069.0611140430765,"x",3069.061114043076,"x",3069.0611140430765,"x",3069.0611140430765,"x"]
[9,"Обсяг холодної води для підігріву, тис. куб. м",1678.552404494382,"x","x","x","x","x","x","x",1678.552404494382,"x",1284.3927191011235,"x",394.1596853932585,"x"]
[10,"Вартість 1 куб. м холодної води без ПДВ, грн",3.08,"x","x","x","x","x","x","x",3.08,"x",3.08,"x",3.08,"x"]
[11,"Відсоток послуг банку, %",1.4,1.4,"x",1.4,"x","x",1.4,"x",1.4,"x",1.4,"x",1.4,"x"]
[12,"Питомі норми, враховані у планованих тарифах на послуги з централізованого опалення та гарячого водопостачання, Гкал/кв.м на рік; Гкал/куб.м","x","x",0.14604544401038136,"x",0.1301644764132489,"x","x",0.15359825452513973,"x",0.05305952908130578,"x",0.054110230569286495,"x",0.04963575594792529]
[13,"Тривалість опалювального періоду, діб","x","x",189,"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]