{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["dod 5"],"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 5","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},"Додаток 5\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,"Собівартість власної теплової енергії, врахована у встановлених тарифах на теплову енергію для потреб населення ",20840.71523401467,17482.4509491513,47.70685656668897,11748.980766870001,43.58626379697264,386.73,5733.470182281301,59.16969000000002,3358.2642848633686,22.652863862015067,2889.0527229622858,22.86868934064799,469.2115619010827,21.40880581917781]
[2,"Витрати на утримання абонентської служби, усього, у т.ч.:",258.180353064,212.12589519678852,0.5788581753020713,142.55798972758672,0.5288603556279412,4.692445452188527,69.5679054692018,0.7179441541848447,46.054457867211454,0.3106561234644745,39.57671550305139,0.3132748685300833,6.477742364160063,0.2955611917555448]
[" 2.1","витрати на оплату праці ",133.75043999999997,109.89190881976702,0.2998777200721272,73.85222626469047,0.2739763286568096,2.4309233311437732,36.03968255507656,0.3719312696649974,23.858531180232937,0.16093553482657105,20.50273403637251,0.1622921768042284,3.35579714386043,0.15311559913479975]
[" 2.2","відрахування на соціальні заходи ",49.567913063999995,40.725941408605664,0.11113468305873035,27.369635053694292,0.10153562740021364,0.9009001865218824,13.356306354911375,0.13783772853784806,8.841971655394328,0.05964270920672724,7.598313233879652,0.06014548072364704,1.2436584215146755,0.05674464103935679]
[" 2.3","інші витрати абонентської служби",74.862,61.50804496841582,0.16784577217121374,41.33612840920194,0.15334839957091792,1.360621934522871,20.171916559213876,0.20817515598199932,13.353955031584183,0.09007787943117618,11.475668232799226,0.09083721100220789,1.8782867987849576,0.08570095158138828]
[3,"Витрати на періодичну повірку квартирних засобів обліку",0,"x","x","x","x","x","x","x",0,0,0,0,0,0]
[4,"Витрати на придбання води для послуги з гарячого водопостачання",437.33455000000004,"x","x","x","x","x","x","x",437.33455000000004,2.950000114034707,372.6800648651516,2.9499996864421885,64.65448513484843,2.9500025787572017]
[5,"Решта витрат, крім послуг банку",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[6,"Собівартість послуг, без урахування послуг банку",21536.230137078674,17694.576844348092,48.28571474199105,11891.538756597589,44.11512415260058,391.4224454521886,5803.038087750503,59.88763415418486,3841.65329273058,25.913520099514248,3301.3095033304885,26.13196389562026,540.3437894000912,24.654369589690557]
[7,"Розрахунковий прибуток, усього, у т.ч.:",719.4258225999945,603.4978413135001,1.646850606793623,405.57725865000003,1.5046068877242125,13.35,197.92058266350003,2.0425500000000003,115.92798128649436,0.7819815699787994,99.73070062200117,0.7894319103706736,16.197280664493196,0.7390364277041443]
[" 7.1","прибуток у тарифі на теплову енергію для потреб населення",719.4258225999945,603.4978413135001,1.646850606793623,405.57725865000003,1.5046068877242125,13.35,197.92058266350003,2.0425500000000003,115.92798128649436,0.7819815699787994,99.73070062200117,0.7894319103706736,16.197280664493196,0.7390364277041443]
[" 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,"Послуги банку",224.80460565331987,184.82903722890498,0.504369346957421,124.21329308330898,0.4608053640436848,4.088610560123117,60.61574414559599,0.6255574156988369,39.975568424414895,0.2696515320150813,34.353941454065556,0.2719332909696054,5.621626970349337,0.2564990506807545]
[9,"Повна планова собівартість послуг з урахуванням послуг банку",21761.034742731994,17879.405881576997,48.79008408894847,12015.752049680897,44.575929516644266,395.51105601231166,5863.653831896099,60.513191569883695,3881.6288611549944,26.183171631529326,3335.663444784554,26.403897186589862,545.9654163704405,24.91086864037131]
[10,"Вартість послуг",22480.460565331985,18482.903722890496,"x",12421.329308330898,"x","x",6061.574414559599,"x",3997.5568424414887,"x",3435.3941454065553,"x",562.1626970349337,"x"]
[11,"Плановані тарифи на послуги, у т.ч. на послуги з централізованого опалення:","x","x",50.43693469574209,"x",46.08053640436848,408.86105601231174,"x",62.55574156988369,"x",26.965153201508123,"x",27.19332909696054,"x",25.649905068075455]
[" 11.1","вартість теплової енергії","x",18085.9487904648,49.35370717348259,12154.558025520002,45.09087068469685,400.08000000000004,5931.390764944801,61.21224000000001,"x","x","x","x","x","x"]
[" 11.2","решта складових тарифу","x",396.954932425695,1.0832275222594963,266.7712828108961,0.9896657196716274,8.781056012311655,130.18364961479801,1.3435015698836839,"x","x","x","x","x","x"]
[12,"Плановані тарифи на послуги, у т.ч. на послуги з централізованого опалення, з ПДВ:","x","x","x","x",null,490.63326721477404,"x",75.06688988386043,"x","x","x",32.631994916352646,"x",30.779886081690545]
["Допоміжна інформація"]
[1,"Обсяг теплової енергії, врахований у розрахунку собівартості, Гкал",53889.574726591345,45205.83081000001,"x",30380.319000000003,"x","x",14825.511810000004,"x",8683.743916591338,"x",7470.464466067504,"x",1213.2794505238348,"x"]
[2,"Тариф на теплову енергію для потреб населення без ПДВ, грн/Гкал, у т. ч.:",400.08000000000004,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[" 2.1","повна планова собівартість теплової енергії для потреб населення, грн/Гкал",386.73,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[" 2.2","прибуток у тарифі на теплову енергію для потреб населення, грн/Гкал",13.35,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[3,"Загальна опалювана площа квартир, тис. кв. м","x",366.45573,"x",269.55696,"x","x",96.89877,"x","x","x","x","x","x","x"]
[4,"Обсяг споживання населенням гарячої води, тис. куб. м","x","x","x","x","x","x","x","x",148.24899426931165,"x",126.33223880597015,"x",21.916755463341506,"x"]
[5,"Кількість абонентів, яким надаються послуги",12169,7723,"x",5504,"x","x",2219,"x",4446,"x",3923,"x",523,"x"]
[6,"Середньорічна кількість штатних працівників, задіяних у наданні послуг, у т. ч.:",3,2,"x",1.656493083641979,"x","x",0.8083640522246485,"x",0.47348290641555346,"x",0.40732859716298525,"x",0.06615430925256818,"x"]
[" 6.1","абонентської служби",3,2,"x",1.656493083641979,"x","x",0.8083640522246485,"x",0.4734829064155534,"x",0.40732859716298525,"x",0.06615430925256818,"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,"Середньомісячна заробітна плата, грн",3715.2899999999995,3715.29,"x",3715.29,"x","x",3715.29,"x",3715.29,"x",3715.29,"x",3715.29,"x"]
[9,"Обсяг холодної води для підігріву, тис. куб. м",148.249,"x","x","x","x","x","x","x",148.249,"x",126.33222537801748,"x",21.91677462198252,"x"]
[10,"Вартість 1 куб. м холодної води без ПДВ, грн",2.95,"x","x","x","x","x","x","x",2.95,"x",2.95,"x",2.95,"x"]
[11,"Відсоток послуг банку, %",1,1,"x",1,"x","x",1,"x",1,"x",1,"x",1,"x"]
[12,"Питомі норми, враховані у планованих тарифах на послуги з централізованого опалення та гарячого водопостачання, Гкал/кв.м на рік; Гкал/куб.м","x","x",0.1233595960145036,"x",0.11270463578458521,"x","x",0.15300000000000005,"x",0.0585753985002846,"x",0.05913347643226021,"x",0.0553585339104228]
[13,"Тривалість опалювального періоду, діб","x","x",188,"x","x","x","x","x","x","x","x","x","x","x"]
[14,"Середня температура зовнішнього повітря опалювального періоду, град. С","x","x",-1.5,"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]