{"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":[[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},"Додаток 21\nдо постанови Національної комісії, що здійснює державне регулювання у сфері комунальних послуг \n06 червня 2014 року № 650                       (у редакції  постанови Національної комісії, що здійснює державне регулювання у сфері комунальних послуг \nвід 18 червня 2014 року № 757)       "]
[]
["Структура тарифу на послугу з централізованого опалення та послугу з централізованого постачання гарячої води, що надаються населенню"]
["обласним комунальним підприємством «Миколаївоблтеплоенерго» "]
["№ з/п","Назва показника","Усього на послуги","У тому числі"]
[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.689093656246,3434.605527367872,0.8754347730273,1518.9592065317895,0.7040108848529563,7.576645798815595,1915.6463208360824,1.0849003112155107,160.08356628837424,0.5166865875335145,160.08356628837424,0.5166865875335145,0,0.5166865875335145]
[" 2.1","витрати на оплату праці ",2486.112,2375.3970912045024,0.6054567829750049,1050.5227607954798,0.48689882862256967,5.240060975906567,1324.8743304090226,0.7503246072870365,110.71490879549803,0.35734404062176717,110.71490879549803,0.35734404062176717,0,0.35734404062176717]
[" 2.2","внески на соціальні заходи ",921.3531072,880.3221620003886,0.22438228377053684,389.32373515080485,0.18044470588752434,1.9419665976709737,490.9984268495838,0.27807029946057576,41.030945199611565,0.1324317014544269,41.030945199611565,0.1324317014544269,0,0.1324317014544269]
[" 2.3","інші витрати абонентської служби",187.22398645624554,178.8862741629809,0.04559570628175815,79.11271058550483,0.03666735034286219,0.3946182252380552,99.77356357747608,0.056505404467898424,8.337712293264657,0.02691084545732042,8.337712293264657,0.02691084545732042,0,0.02691084545732042]
[3,"Витрати на періодичну повірку квартирних засобів обліку",249,"x","x","x","x","x","x","x",249.00000000000074,0.8036737516459789,249.00000000000074,0.8036737516459789,0,0.8036737516459789]
[4,"Витрати на придбання води для послуги з гарячого водопостачання",1419.008643326157,"x","x","x","x","x","x","x",1419.008643326157,4.58,1419.008643326157,4.58,0,4.58]
[5,"Решта витрат, крім послуг банку",108.2222371324603,103.4027378042864,0.02635596768793101,45.73000867694427,0.021195054965628613,0.22810360978230737,57.67272912734212,0.032662167905604333,4.8194993281739125,0.01555544219328832,4.8194993281739125,0.01555544219328832,0,0.01555544219328832]
[6,"Собівартість послуг, без урахування послуг банку",146555.34424422355,139790.83184606856,35.63080364639293,61822.69530790873,28.653732266512087,308.37474940859795,77968.13653815983,44.15619661891701,6764.512398155011,21.83317693606811,6764.512398155011,21.83317693606811,0,20.506738506510167]
[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,"Послуги банку",2232.379523242281,2129.3466552565,0.5427418348300046,941.7066036047016,0.4364644530443768,4.697280447846669,1187.6400516517986,0.6726038348700449,103.03286798578078,0.33254944400392394,103.03286798578078,0.33254944400392394,0,0.3123444976736977]
[9,"Повна планова собівартість послуг з урахуванням послуг банку",148787.72376746588,141920.17850132508,36.17354548122294,62764.401911513436,29.090196719556463,313.0720298564446,79155.77658981163,44.82880045378706,6867.545266140793,22.165726380072037,6867.545266140793,22.165726380072037,0,20.819083004183867]
[10,"Вартість послуг",148825.30154948536,141956.44368376667,"x",62780.44024031344,"x","x",79176.00344345323,"x",6868.857865718718,"x",6868.857865718718,"x",0,"x"]
[11,"Плановані тарифи на послуги, у т.ч. на послуги з централізованого опалення:","x","x",36.18278898866698,"x",29.097630202958452,313.1520298564446,"x",44.84025565800299,"x",22.169962933594928,"x",22.169962933594928,"x",20.82296651157985]
[" 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",5667.354920428683,1.4445325755452418,2506.395818813442,1.1616703928629648,12.502029856444606,3160.9591016152262,1.7901663139911617,"x","x","x","x","x","x"]
[12,"Плановані тарифи на послуги, у т.ч. на послуги з централізованого опалення, з ПДВ","x","x","x","x",null,375.7824358277335,"x",53.808306789603584,"x","x","x",26.603955520313914,"x",24.987559813895817]
["Допоміжна інформація"]
[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.508276427666104,"x","x",0.5388559699707193,"x",2.0057921056356713,"x",2.0057921056356713,"x",0,"x"]
[" 7.1","абонентської служби",58,56,"x",24.508276427666104,"x","x",0.19970002247114851,"x",2.0057921056356713,"x",2.0057921056356713,"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 куб. м холодної води без ПДВ, грн",4.58,"x","x","x","x","x","x","x",4.58,"x",4.58,"x",4.58,"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]