{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["dod 21"],"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 21","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},"Додаток 21\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,"Собівартість власної теплової енергії, врахована у встановлених тарифах на теплову енергію для потреб населення ",141184.4242701087,136252.8235808964,34.7290129056777,60258.006092699994,27.928526326693497,300.57,75994.81748819641,43.038634139795896,4931.600689212305,15.917261154695328,4931.600689212305,15.917261154695328,0,14.590822725137386]
[2,"Витрати на утримання абонентської служби, усього, у т.ч.:",3594.6890936562454,3454.343879848917,0.880465813706204,1527.6885211456367,0.708056768691724,7.620188064210963,1926.6553587032804,1.0911351304921157,140.3452138073287,0.45297897392005043,140.3452138073287,0.45297897392005043,0,0.45297897392005043]
[" 2.1","витрати на оплату праці ",2486.112,2389.048273180144,0.6089362857298842,1056.560015547653,0.4896969900490801,5.270175109754094,1332.4882576324912,0.7546366516996545,97.063726819856,0.3132834115745135,97.063726819856,0.3132834115745135,0,0.3132834115745135]
[" 2.2","відрахування на соціальні заходи ",921.3531072,885.3812900405615,0.22567178749149513,391.5611417619602,0.1814817045121891,1.953126895674867,493.8201482786012,0.2796683431198919,35.97181715943863,0.11610283232951468,35.97181715943863,0.11610283232951468,0,0.11610283232951468]
[" 2.3","інші витрати абонентської служби",187.22398645624554,179.91431662821148,0.045857740484824626,79.56736383602362,0.036878074130454776,0.39688605878200284,100.34695279218786,0.056830135672569296,7.309669828034068,0.02359273001602225,7.309669828034068,0.02359273001602225,0,0.02359273001602225]
[3,"Витрати на періодичну повірку квартирних засобів обліку",249,"x","x","x","x","x","x","x",248.99999999999997,0.8036737516459764,248.99999999999997,0.8036737516459764,0,0.8036737516459764]
[4,"Витрати на придбання води для послуги з гарячого водопостачання",604.1630686650668,"x","x","x","x","x","x","x",604.1630686650668,1.9499999999999997,604.1630686650668,1.9499999999999997,0,1.9499999999999997]
[5,"Решта витрат, крім послуг банку",108.2222371324603,103.99698353935636,0.026507432936576925,45.99281470314855,0.021316860937939882,0.22941449961119914,58.00416883620782,0.03284987428928618,4.225253593103932,0.013637451433034053,4.225253593103932,0.013637451433034053,0,0.013637451433034053]
[6,"Собівартість послуг, без урахування послуг банку",145740.49866956248,139811.1644442847,35.635986152320484,61831.68742854878,28.657899956323163,308.4196025638222,77979.4770157359,44.1626191445773,5929.334225277805,19.13755133169439,5929.334225277805,19.13755133169439,0,17.811112902136447]
[7,"Розрахунковий прибуток, усього, у т.ч.:",37.57778201952523,36.265182441600004,0.00924350744403705,16.0383288,0.007433483401987823,0.07999999999999999,20.2268536416,0.011455204215935296,1.3125995779252237,0.004236553522891927,1.3125995779252237,0.004236553522891927,0,0.003883507395984267]
[" 7.1","прибуток у тарифі на теплову енергію для потреб населення",37.57778201952523,36.265182441600004,0.00924350744403705,16.0383288,0.007433483401987823,0.07999999999999999,20.2268536416,0.011455204215935296,1.3125995779252237,0.004236553522891927,1.3125995779252237,0.004236553522891927,0,0.003883507395984267]
[" 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,"Послуги банку",2219.9707073844975,2129.6562887318723,0.5428207562400689,941.8435394520119,0.43652792040190586,4.697963490819626,1187.8127492798603,0.6727016398293386,90.31441865262535,0.2914993078967099,90.31441865262535,0.2914993078967099,0,0.27129436156648373]
[9,"Повна планова собівартість послуг з урахуванням послуг банку",147960.469376947,141940.82073301656,36.17880690856055,62773.53096800079,29.094427876725067,313.1175660546418,79167.28976501577,44.83532078440664,6019.64864393043,19.4290506395911,6019.64864393043,19.4290506395911,0,18.08240726370293]
[10,"Вартість послуг",147998.0471589665,141977.08591545816,"x",62789.56929680079,"x","x",79187.51661865736,"x",6020.961243508355,"x",6020.961243508355,"x",0,"x"]
[11,"Плановані тарифи на послуги, у т.ч. на послуги з централізованого опалення:","x","x",36.188050416004586,"x",29.101861360127057,313.19756605464175,"x",44.846775988622575,"x",19.43328719311399,"x",19.43328719311399,"x",18.086290771098913]
[" 11.1","вартість теплової енергії","x",136289.088763338,34.73825641312173,60274.044421499995,27.935959810095486,300.65,76015.044341838,43.05008934401183,"x","x","x","x","x","x"]
[" 11.2","решта складових тарифу","x",5687.997152120166,1.4497940028828549,2515.524875300798,1.1659015500315701,12.547566054641795,3172.4722768193606,1.7966866446107472,"x","x","x","x","x","x"]
[12,"Плановані тарифи на послуги, у т.ч. на послуги з централізованого опалення, з ПДВ","x","x","x","x",null,375.8370792655701,"x",53.816131186347086,"x","x","x",23.31994463173679,"x",21.703548925318696]
["Допоміжна інформація"]
[1,"Обсяг теплової енергії, врахований у розрахунку собівартості, Гкал",469722.2752440653,453314.78052000003,"x",200479.11,"x","x",252835.67052,"x",16407.494724065295,"x",16407.494724065295,"x",0,"x"]
[2,"Тариф на теплову енергію для потреб населення без ПДВ, грн/Гкал, у т. ч.:",300.65,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[" 2.1","повна планова собівартість теплової енергії для потреб населення, грн/Гкал",300.57,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[" 2.2","прибуток у тарифі на теплову енергію для потреб населення, грн/Гкал",0.08,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[3,"Загальна опалювана площа квартир, тис. кв. м","x",3923.3140300000005,"x",2157.5791500000005,"x","x",1765.73488,"x","x","x","x","x","x","x"]
[4,"Обсяг споживання населенням гарячої води, тис. куб. м","x","x","x","x","x","x","x","x",309.8272147000343,"x",309.8272147000343,"x",0,"x"]
[5,"Кількість абонентів, яким надаються послуги",94007,85768,"x",45038,"x","x",40730,"x",8239,"x",8239,"x",0,"x"]
[6,"Середньорічна кількість штатних працівників, задіяних у наданні послуг, у т. ч.:",0,0,"x",0,"x","x",0,"x",0,"x",0,"x",0,"x"]
[" 6.1","абонентської служби",0,0,"x",0,"x","x",0,"x",0,"x",0,"x",0,"x"]
[" 6.2","решта працівників, задіяних у наданні послуг",0,0,"x",0,"x","x",0,"x",0,"x",0,"x",0,"x"]
[7,"Середньорічна кількість позаштатних працівників за договором, задіяних у наданні послуг, у т.ч.:",58,56,"x",24.64912316973808,"x","x",0.5450672751117126,"x",2.017319202785333,"x",2.017319202785333,"x",0,"x"]
[" 7.1","абонентської служби",58,56,"x",24.64912316973808,"x","x",0.20200193215640067,"x",2.017319202785333,"x",2.017319202785333,"x",0,"x"]
[" 7.2","решта працівників, задіяних у наданні послуг",0,0,"x",0,"x","x",0,"x",0,"x",0,"x",0,"x"]
[8,"Середньомісячна заробітна плата, грн",3572,3572,"x",3572,"x","x",3572,"x",3572,"x",3572,"x",3572,"x"]
[9,"Обсяг холодної води для підігріву, тис. куб. м",309.8272147000343,"x","x","x","x","x","x","x",309.8272147000343,"x",309.8272147000343,"x",0,"x"]
[10,"Вартість 1 куб. м холодної води без ПДВ, грн",1.95,"x","x","x","x","x","x","x",1.95,"x",1.95,"x",1.95,"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.11554384305046313,"x",0.09291854252484778,"x","x",0.1431900526991912,"x",0.05295691903614908,"x",0.05295691903614908,"x",0]
[13,"Тривалість опалювального періоду, діб","x","x",164,"x","x","x","x","x","x","x","x","x","x","x"]
[14,"Середня температура зовнішнього повітря опалювального періоду, град. С","x","x",0,"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]