{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["Аркуш1"],"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":"Аркуш1","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},"Додаток 30\nдо постанови Національної комісії, що здійснює державне регулювання у сфері комунальних послуг \n06 червня 2014 року № 650                       (у редакції  постанови Національної комісії, що здійснює державне регулювання у сфері комунальних послуг \nвід 27 червня 2014 року № 792)       "]
[]
["Структура тарифу на послугу з централізованого опалення та послугу з централізованого постачання гарячої води, що надаються населенню"]
[" товариством з обмеженою відповідальністю «Рівнетеплоенерго» "]
["№ з/п","Назва показника","Усього на послуги","У тому числі"]
[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,"Собівартість власної теплової енергії, врахована у встановлених тарифах на теплову енергію для потреб населення ",166466.88713056737,140766.82168459875,47.75903730188995,33381.658469991,36.619208263479514,367.77000000000004,107385.16321460773,52.747098568730635,25700.065445968623,19.393795628455187,20189.0874353421,19.768229892948437,5510.978010626523,18.135384420126474]
[2,"Витрати на утримання абонентської служби, усього, у т.ч.:",2434.426096656,1980.5432808722855,0.6719540819151415,469.6690498223247,0.5152203197398203,5.174403980210721,1510.8742310499608,0.7421344774685456,453.88281578371425,0.34250926664305104,355.1814742262608,0.3477774346516464,98.70134155745346,0.32480383127551726]
[" 2.1","витрати на оплату праці ",1582.92576,1287.7996100986834,0.4369216330952473,305.39076074632453,0.3350093548996494,3.3645290625881255,982.4088493523587,0.48255471110121745,295.1261499013167,0.22270823581489313,230.9480274631522,0.22613373263332945,64.17812243816448,0.211195711456983]
[" 2.2","відрахування на соціальні заходи ",586.632286656,477.25853550257204,0.16192315722509862,113.17781593258788,0.12415446692581007,1.2468944705951592,364.0807195699842,0.17883477593411118,109.37375115342795,0.08253567219299937,85.58933897784419,0.08380516131391189,23.784412175583753,0.07826913066595789]
[" 2.3","інші витрати абонентської служби",264.86805,215.48513527103034,0.07310929159479569,51.10047314341231,0.056056497914360855,0.5629804470274364,164.38466212761804,0.08074499043321703,49.382914728969624,0.03726535863515854,38.644107785264396,0.03783854070440507,10.738806943705224,0.03533898915257639]
[3,"Витрати на періодичну повірку квартирних засобів обліку",1822.546,"x","x","x","x","x","x","x",1822.5460000000003,1.3753305306466825,1426.2152093320158,1.3964846219616727,396.3307906679845,1.304235152533196]
[4,"Витрати на придбання води для послуги з гарячого водопостачання",6559.588767187499,"x","x","x","x","x","x","x",6559.588767187499,4.95,5055.383478749999,4.95,1504.2052884375003,4.95]
[5,"Решта витрат, крім послуг банку",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[6,"Собівартість послуг, без урахування послуг банку",177283.44799441085,142747.36496547103,48.430991383805086,33851.32751981333,37.13442858321933,372.9444039802107,108896.0374456577,53.48923304619918,34536.08302893984,26.06163542574492,27025.867597650373,26.462491949561752,7510.215431289462,24.714423403935186]
[7,"Розрахунковий прибуток, усього, у т.ч.:",715.1689416382424,604.7572620433042,0.20518062630716508,143.41305811400002,0.15732210092258106,1.5800000000000003,461.3442039293042,0.22661015237402288,110.4116795949382,0.08331891424792451,86.7356177715434,0.08492754501688156,23.6760618233948,0.07791257411915008]
[" 7.1","прибуток у тарифі на теплову енергію для потреб населення",715.1689416382424,604.7572620433042,0.20518062630716508,143.41305811400002,0.15732210092258106,1.5800000000000003,461.3442039293042,0.22661015237402288,110.4116795949382,0.08331891424792451,86.7356177715434,0.08492754501688156,23.6760618233948,0.07791257411915008]
[" 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,"Послуги банку",1634.6628460167997,1316.4843195785452,0.4466537140902427,312.1930964367127,0.3424714211582313,3.439471264728951,1004.2912231418323,0.49330323252297525,318.1785264382546,0.24010403117765156,248.9905028361484,0.24380009829515148,69.18802360210617,0.22768216510272932]
[9,"Повна планова собівартість послуг з урахуванням послуг банку",178918.11084042766,144063.84928504957,48.877645097895325,34163.52061625004,37.47690000437757,376.3838752449397,109900.32866879953,53.98253627872216,34854.26155537809,26.301739456922576,27274.858100486523,26.706292047856905,7579.403454891568,24.942105569037917]
[10,"Вартість послуг",179633.2797820659,144668.60654709287,"x",34306.93367436404,"x","x",110361.67287272883,"x",34964.67323497303,"x",27361.593718258067,"x",7603.079516714963,"x"]
[11,"Плановані тарифи на послуги, у т.ч. на послуги з централізованого опалення:","x","x",49.08282572420249,"x",37.63422210530015,377.9638752449397,"x",54.20914643109618,"x",26.385058371170498,"x",26.791219592873787,"x",25.020018143157067]
[" 11.1","вартість теплової енергії","x",141371.57894664205,47.964217928197115,33525.071528105,36.77653036440209,369.35,107846.50741853703,52.97370872110466,"x","x","x","x","x","x"]
[" 11.2","решта складових тарифу","x",3297.0276004508196,1.1186077960053804,781.8621462590381,0.8576917408980523,8.61387524493968,2515.165454191796,1.2354377099915221,"x","x","x","x","x","x"]
[12,"Плановані тарифи на послуги, у т.ч. на послуги з централізованого опалення, з ПДВ","x","x","x","x",null,453.5566502939276,"x",65.05097571731541,"x","x","x",32.149463511448545,"x",30.02402177178848]
["Допоміжна інформація"]
[1,"Обсяг теплової енергії, врахований у розрахунку собівартості, Гкал",452638.57065711543,382757.76078690134,"x",90767.7583,"x","x",291990.00248690136,"x",69880.80987021406,"x",54895.96061490088,"x",14984.849255313165,"x"]
[2,"Тариф на теплову енергію для потреб населення без ПДВ, грн/Гкал, у т. ч.:",369.35,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[" 2.1","повна планова собівартість теплової енергії для потреб населення, грн/Гкал",367.77000000000004,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[" 2.2","прибуток у тарифі на теплову енергію для потреб населення, грн/Гкал",1.58,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[3,"Загальна опалювана площа квартир, тис. кв. м","x",2947.438425,"x",911.588755,"x","x",2035.8496699999998,"x","x","x","x","x","x","x"]
[4,"Обсяг споживання населенням гарячої води, тис. куб. м","x","x","x","x","x","x","x","x",1325.1694479166665,"x",1021.2895916666665,"x",303.87985625000005,"x"]
[5,"Кількість абонентів, яким надаються послуги",105958,63375,"x",18315,"x","x",45060,"x",42583,"x",33453,"x",9130,"x"]
[6,"Середньорічна кількість штатних працівників, задіяних у наданні послуг, у т. ч.:",39,31.728705200835602,"x",7.524193471402383,"x","x",24.204511729433218,"x",7.271294799164396,"x",5.69007928145849,"x",1.5812155177059057,"x"]
[" 6.1","абонентської служби",39,31.728705200835602,"x",7.524193471402383,"x","x",24.204511729433218,"x",7.271294799164396,"x",5.69007928145849,"x",1.5812155177059057,"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,"Середньомісячна заробітна плата, грн",3382.32,3382.32,"x",3382.32,"x","x",3382.32,"x",3382.3200000000006,"x",3382.32,"x",3382.32,"x"]
[9,"Обсяг холодної води для підігріву, тис. куб. м",1325.1694479166665,"x","x","x","x","x","x","x",1325.1694479166665,"x",1021.2895916666665,"x",303.87985625000005,"x"]
[10,"Вартість 1 куб. м холодної води без ПДВ, грн",4.95,"x","x","x","x","x","x","x",4.95,"x",4.95,"x",4.95,"x"]
[11,"Відсоток послуг банку, %",0.91,0.91,"x",0.91,"x","x",0.91,"x",0.91,"x",0.91,"x",0.91,"x"]
[12,"Питомі норми, враховані у планованих тарифах на послуги з централізованого опалення та гарячого водопостачання, Гкал/кв.м на рік; Гкал/куб.м","x","x",0.1298611558906108,"x",0.09957094995100066,"x","x",0.14342414707216636,"x",0.05273349003033197,"x",0.0537516107701782,"x",0.04931175577161397]
[13,"Тривалість опалювального періоду, діб","x","x",182,"x","x","x","x","x","x","x","x","x","x","x"]
[14,"Середня температура зовнішнього повітря опалювального періоду, град. С","x","x",0.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]