{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["dod 15"],"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 15","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},"Додаток 15\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,"Собівартість власної теплової енергії, врахована у встановлених тарифах на теплову енергію для потреб населення ",32873.05082649,30146.47266839853,56.024101523607406,6575.892855639999,43.306962297961746,369.02,23570.57981275853,61.02344390229377,2726.5781580914713,19.561996244275264,2400.144958353674,19.773687000234172,326.4331997377972,18.134536564735882]
[2,"Витрати на утримання абонентської служби, усього, у т.ч.:",198.465888,179.81645505478468,0.3341702840135164,39.22361846866395,0.25831560877017123,2.201115499455269,140.59283658612074,0.3639901582664299,18.64943294521529,0.1338014595875472,16.39418709753494,0.13506414400582414,2.255245847680351,0.1252870061013362]
[" 2.1","витрати на оплату праці ",127.413888,115.44106594734995,0.21453528144960796,25.181323505433237,0.16583704321265735,1.4131027077190095,90.25974244191671,0.2336794586002667,11.97282205265003,0.08589971988599,10.524967991962235,0.08671035557089765,1.447854060687796,0.08043349274839093]
[" 2.2","відрахування на соціальні заходи ",47.283,42.83991334750375,0.07961354819328496,9.344731080707621,0.061541744289477125,0.5243991559937166,33.495182266796135,0.08671790818436066,4.443086652496246,0.03187718795120094,3.905791349557989,0.03217801298441465,0.5372953029382563,0.029848683666431782]
[" 2.3","інші витрати абонентської служби",23.769000000000002,21.535475759930986,0.040021454370623495,4.697563882523094,0.030936821268036756,0.2636136357425428,16.83791187740789,0.04359279148180251,2.2335242400690154,0.01602455175035626,1.9634277560147164,0.01617577545051185,0.2700964840542989,0.015004829686513486]
[3,"Витрати на періодичну повірку квартирних засобів обліку",0,"x","x","x","x","x","x","x",0,0,0,0,0,0]
[4,"Витрати на придбання води для послуги з гарячого водопостачання",400.0245790872472,"x","x","x","x","x","x","x",400.0245790872472,2.87,348.36275250000006,2.87,51.66182658724717,2.87]
[5,"Решта витрат, крім послуг банку",15.66,14.188461878939762,0.026367788945431604,3.094949320556677,0.02038245702627185,0.17367956311701038,11.093512558383084,0.028720733501831266,1.4715381210602374,0.010557637275887882,1.293587389422797,0.010657269702344044,0.1779507316374404,0.00988580221678662]
[6,"Собівартість послуг, без урахування послуг банку",33487.20129357724,30340.47758533225,56.38463959656635,6618.2114234292185,43.58566036375819,371.3947950625722,23722.266161903033,61.41615479406203,3146.7237082449947,22.5763553411387,2766.1954853406323,22.789408413942343,380.52822290436217,21.139709373054004]
[7,"Розрахунковий прибуток, усього, у т.ч.:",113.13417849884098,103.75052920943615,0.19280962802824075,22.631250139999995,0.14904298444098266,1.2699999999999998,81.11927906943616,0.21001510421091835,9.383649289404826,0.0673235467731548,8.260213801715805,0.06805209064629938,1.123435487689021,0.0624108759341352]
[" 7.1","прибуток у тарифі на теплову енергію для потреб населення",113.13417849884098,103.75052920943615,0.19280962802824075,22.631250139999995,0.14904298444098266,1.2699999999999998,81.11927906943616,0.21001510421091835,9.383649289404826,0.0673235467731548,8.260213801715805,0.06805209064629938,1.123435487689021,0.0624108759341352]
[" 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,"Послуги банку",339.3973280007686,307.5174557024413,0.571489386107016,67.0792189249416,0.44176468028484006,3.7642908592179007,240.4382367774997,0.6224865646290197,31.879872298327268,0.22872402917082685,28.0248050418419,0.23088343944028933,3.8550672564853654,0.21416283079785997]
[9,"Повна планова собівартість послуг з урахуванням послуг банку",33826.598621578014,30647.995041034694,56.95612898267337,6685.29064235416,44.02742504404303,375.1590859217901,23962.704398680533,62.03864135869105,3178.6035805433216,22.805079370309528,2794.220290382474,23.020291853382634,384.38329016084754,21.353872203851864]
[10,"Вартість послуг",33939.732800076854,30751.74557024413,"x",6707.92189249416,"x","x",24043.82367774997,"x",3187.9872298327264,"x",2802.48050418419,"x",385.50672564853653,"x"]
[11,"Плановані тарифи на послуги, у т.ч. на послуги з централізованого опалення:","x","x",57.14893861070161,"x",44.17646802848401,376.4290859217901,"x",62.24865646290197,"x",22.87240291708268,"x",23.08834394402893,"x",21.416283079785998]
[" 11.1","вартість теплової енергії","x",30250.223197607964,56.21691115163565,6598.5241057799985,43.45600528240273,370.28999999999996,23651.699091827966,61.23345900650469,"x","x","x","x","x","x"]
[" 11.2","решта складових тарифу","x",501.5223726361655,0.9320274590659637,109.39778671416116,0.7204627460812761,6.1390859217901195,392.12458592200346,1.0151974563972808,"x","x","x","x","x","x"]
[12,"Плановані тарифи на послуги, у т.ч. на послуги з централізованого опалення, з ПДВ","x","x","x","x",null,451.7149031061481,"x",74.69838775548236,"x","x","x",27.70601273283472,"x",25.699539695743198]
["Допоміжна інформація"]
[1,"Обсяг теплової енергії, врахований у розрахунку собівартості, Гкал",89082.03031404801,81693.3300861702,"x",17819.881999999998,"x","x",63873.4480861702,"x",7388.700227877815,"x",6504.105355681736,"x",884.5948721960795,"x"]
[2,"Тариф на теплову енергію для потреб населення без ПДВ, грн/Гкал, у т. ч.:",370.28999999999996,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[" 2.1","повна планова собівартість теплової енергії для потреб населення, грн/Гкал",369.02,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[" 2.2","прибуток у тарифі на теплову енергію для потреб населення, грн/Гкал",1.27,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[3,"Загальна опалювана площа квартир, тис. кв. м","x",538.09828,"x",151.84378,"x","x",386.2545,"x","x","x","x","x","x","x"]
[4,"Обсяг споживання населенням гарячої води, тис. куб. м","x","x","x","x","x","x","x","x",139.38138644154955,"x",121.38075,"x",18.000636441549535,"x"]
[5,"Кількість абонентів, яким надаються послуги",19245,13549,"x",3609,"x","x",9940,"x",5696,"x",4971,"x",725,"x"]
[6,"Середньорічна кількість штатних працівників, задіяних у наданні послуг, у т. ч.:",2.996,2.766,"x",0.5921116324640999,"x","x",2.1223603847328048,"x",0.24550866014245218,"x",0.21611570940094937,"x",0.029392950741502805,"x"]
[" 6.1","абонентської служби",2.996,2.766,"x",0.5921116324640999,"x","x",2.1223603847328048,"x",0.24550866014245215,"x",0.21611570940094937,"x",0.029392950741502805,"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,"Середньомісячна заробітна плата, грн",3544,3544,"x",3544,"x","x",3544,"x",3544.0000000000005,"x",3544,"x",3544,"x"]
[9,"Обсяг холодної води для підігріву, тис. куб. м",139.38138644154955,"x","x","x","x","x","x","x",139.38138644154955,"x",121.38075,"x",18.000636441549535,"x"]
[10,"Вартість 1 куб. м холодної води без ПДВ, грн",2.87,"x","x","x","x","x","x","x",2.87,"x",2.87,"x",2.87,"x"]
[11,"Відсоток послуг банку, %",1,1,"x",1,"x","x",1,"x",1,"x",1,"x",1,"x"]
[12,"Питомі норми, враховані у планованих тарифах на послуги з централізованого опалення та гарячого водопостачання, Гкал/кв.м на рік; Гкал/куб.м","x","x",0.15181860474664627,"x",0.11735668066219107,"x","x",0.16536622378812466,"x",0.05301066675051559,"x",0.05358432334354282,"x",0.049142421995382046]
[13,"Тривалість опалювального періоду, діб","x","x",180,"x","x","x","x","x","x","x","x","x","x","x"]
[14,"Середня температура зовнішнього повітря опалювального періоду, град. С","x","x",-0.7,"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]