{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["dod 3"],"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 3","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},"Додаток 3\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,"Собівартість власної теплової енергії, врахована у встановлених тарифах на теплову енергію для потреб населення ",83765.0266597644,62531.55209658694,38.40504714708217,27976.128800000002,36.418383544631716,290.48,34555.42329658694,40.179564695343664,21233.474563177457,15.606808607539394,21162.095727404816,15.611561243050605,71.37883577264158,14.314807466400378]
[2,"Витрати на утримання абонентської служби, усього, у т.ч.:",1279.1522100788986,898.2917664520013,0.5517044833484605,401.8887316186156,0.5231652340102287,4.172866074328892,496.4030348333857,0.577196166340204,380.86044362689745,0.2799360995856747,379.5571280182164,0.28000437317837645,1.3033156086810371,0.26137596395729246]
[" 2.1","витрати на оплату праці ",780.5447999999999,548.1419346831885,0.3366527159326613,245.2344272806731,0.3192379294112932,2.54630284789402,302.9075074025154,0.3522078628852093,232.40286531681136,0.17081834760728212,231.60757589534987,0.17086000848027344,0.7952894214614779,0.15949286402692314]
[" 2.2","відрахування на соціальні заходи ",289.26990287999996,203.14140099358968,0.12476349652464427,90.88387875021745,0.11830957663982526,0.9436598354295239,112.25752224337222,0.13052823398525856,86.12850188641029,0.06330527962325876,85.83376762681667,0.06332071914278935,0.2947342595936237,0.05910805540837772]
[" 2.3","інші витрати абонентської служби",209.33750719889886,147.00843077522308,0.09028827089115492,65.77042558772507,0.08561772795911031,0.6829033910053481,81.238005187498,0.09446006946973613,62.32907642367579,0.0458124723551338,62.11578449604985,0.04582364555531364,0.21329192762593543,0.042775044521991594]
[3,"Витрати на періодичну повірку квартирних засобів обліку",647.53406,"x","x","x","x","x","x","x",647.5340599999998,0.4759437797716059,645.3181794545858,0.47605985766158565,2.2158805454140404,0.44438807431911076]
[4,"Витрати на придбання води для послуги з гарячого водопостачання",5278.84088,"x","x","x","x","x","x","x",5278.84088,3.8799989628963623,5259.493794723149,3.8799989633084597,19.347085276850645,3.87999885086802]
[5,"Решта витрат, крім послуг банку",28.26516982958563,19.8493729950388,0.012190903314489982,8.880454696705932,0.01156027724591269,0.09220698470258469,10.968918298332865,0.012754187920752084,8.415796834546834,0.006185691846424476,8.386997730944731,0.006187200474308934,0.028799103602101476,0.005775572252006537]
[6,"Собівартість послуг, без урахування послуг банку",90998.81897967288,63449.693236033985,38.96894253374513,28386.897986315325,36.95310905588786,294.74507305903154,35062.795249718656,40.76951504960462,27549.1257436389,20.24887314163946,27454.85182733171,20.253811637673333,94.2739163071894,18.906345927796806]
[7,"Розрахунковий прибуток, усього, у т.ч.:",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[" 7.1","прибуток у тарифі на теплову енергію для потреб населення",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[" 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,"Послуги банку",863.5058534311781,602.086731696668,0.3697840296963498,269.36890881421766,0.35065538575140903,2.7968944950079706,332.7178228824504,0.38687001965100287,261.4191217345101,0.19214557594529674,260.524537832544,0.19219243831428362,0.8945839019660612,0.1794060687677064]
[9,"Повна планова собівартість послуг з урахуванням послуг банку",91862.32483310407,64051.77996773065,39.33872656344147,28656.26689512954,37.30376444163927,297.5419675540395,35395.513072601105,41.15638506925563,27810.54486537341,20.441018717584758,27715.376365164255,20.446004075987616,95.16850020915545,19.085751996564515]
[10,"Вартість послуг",91862.32483310407,64051.77996773065,"x",28656.26689512954,"x","x",35395.513072601105,"x",27810.54486537341,"x",27715.376365164255,"x",95.16850020915545,"x"]
[11,"Плановані тарифи на послуги, у т.ч. на послуги з централізованого опалення:","x","x",39.33872656344147,"x",37.30376444163927,297.5419675540395,"x",41.15638506925563,"x",20.441018717584758,"x",20.446004075987616,"x",19.085751996564515]
[" 11.1","вартість теплової енергії","x",62531.55209658694,38.40504714708217,27976.128800000002,36.418383544631716,290.48,34555.42329658694,40.179564695343664,"x","x","x","x","x","x"]
[" 11.2","решта складових тарифу","x",1520.2278711437102,0.9336794163593015,680.1380951295396,0.885380897007551,7.061967554039451,840.089776014167,0.9768203739119568,"x","x","x","x","x","x"]
[12,"Плановані тарифи на послуги, у т.ч. на послуги з централізованого опалення, з ПДВ:","x","x","x","x",null,357.0503610648474,"x",49.387662083106754,"x","x","x",24.53520489118514,"x",22.902902395877415]
["Допоміжна інформація"]
[1,"Обсяг теплової енергії, врахований у розрахунку собівартості, Гкал",288367.62138448225,215269.7331884706,"x",96310,"x","x",118959.73318847059,"x",73097.88819601163,"x",72852.16100042968,"x",245.7271955819388,"x"]
[2,"Тариф на теплову енергію для потреб населення без ПДВ, грн/Гкал, у т. ч.:",290.48,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[" 2.1","повна планова собівартість теплової енергії для потреб населення, грн/Гкал",290.48,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[" 2.2","прибуток у тарифі на теплову енергію для потреб населення, грн/Гкал",0,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[3,"Загальна опалювана площа квартир, тис. кв. м","x",1628.21183,"x",768.187,"x","x",860.02483,"x","x","x","x","x","x","x"]
[4,"Обсяг споживання населенням гарячої води, тис. куб. м","x","x","x","x","x","x","x","x",1360.5263636615568,"x",1355.54,"x",4.986363661556854,"x"]
[5,"Кількість абонентів, яким надаються послуги",60513,31854,"x",13419,"x","x",18435,"x",28659,"x",28558,"x",101,"x"]
[6,"Середньорічна кількість штатних працівників, задіяних у наданні послуг, у т. ч.:",20,10.529,"x",6.283673333822046,"x","x",6.613946826641133,"x",4.769216600726649,"x",4.7531843151252255,"x",0.01603228560142356,"x"]
[" 6.1","абонентської служби",17,8.95,"x",5.341122333748739,"x","x",6.597222383446489,"x",4.053834110617651,"x",4.040206667856442,"x",0.013627442761210027,"x"]
[" 6.2","решта працівників, задіяних у наданні послуг",3,1.5790000000000002,"x",0.9425510000733069,"x","x",0.01672444319464358,"x",0.7153824901089973,"x",0.7129776472687839,"x",0.002404842840213534,"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,"Середньомісячна заробітна плата, грн",3826.2,3826.2,"x",3826.2,"x","x",3826.2,"x",3826.2,"x",3826.2,"x",3826.2,"x"]
[9,"Обсяг холодної води для підігріву, тис. куб. м",1360.526,"x","x","x","x","x","x","x",1360.526,"x",1355.5396378152448,"x",4.986362184755321,"x"]
[10,"Вартість 1 куб. м холодної води без ПДВ, грн",3.88,"x","x","x","x","x","x","x",3.88,"x",3.88,"x",3.88,"x"]
[11,"Відсоток послуг банку, %",0.94,0.94,"x",0.94,"x","x",0.94,"x",0.94,"x",0.94,"x",0.94,"x"]
[12,"Питомі норми, враховані у планованих тарифах на послуги з централізованого опалення та гарячого водопостачання, Гкал/кв.м на рік; Гкал/куб.м","x","x",0.1322123628032297,"x",0.1253731187848792,"x","x",0.13832127752459264,"x",0.05372765287640937,"x",0.05374401419392248,"x",0.04927983842743176]
[13,"Тривалість опалювального періоду, діб","x","x",177,"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]