{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["dod 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":"dod 1","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},"Додаток 1\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,"Собівартість власної теплової енергії, врахована у встановлених тарифах на теплову енергію для потреб населення ",155861.83855072057,122897.47931471808,46.96778666614822,27745.8701142,42.65099398632927,327.67,95151.60920051807,48.39610379883768,32964.3592360025,17.173875789114955,22968.15080429949,17.643799171972518,9996.20843170301,16.183504051052747]
[2,"Витрати на утримання абонентської служби, усього, у т.ч.:",927.2240903962528,712.6874346737764,0.27236808743394336,160.89941880616644,0.2473348327394326,1.9001715333927884,551.7880158676099,0.28065095604014384,214.53665572247627,0.11176998318735488,149.04615592711892,0.11449508778217865,65.49049979535737,0.10602677765124095]
[" 2.1","витрати на оплату праці ",632.64,486.2627959540341,0.18583527824495177,109.78080635289813,0.16875522347289848,1.2964767970727349,376.481989601136,0.19148663485798725,146.37720404596587,0.07626005719224782,101.69338896861085,0.07811938137151127,44.683815077355035,0.07234149900550531]
[" 2.2","відрахування на соціальні заходи ",259.42,199.3966466337815,0.07620350891866684,45.0166552606045,0.06919967133494455,0.5316325409341945,154.379991373177,0.07852090100983032,60.0233533662185,0.03127115584979282,41.70033346964629,0.0320335892694067,18.323019896572212,0.02966431409965887]
[" 2.3","інші витрати абонентської служби",35.16409039625274,27.027992085960825,0.010329300270324773,6.1019571926638,0.009379937931589583,0.07206219538585903,20.926034893297025,0.010643420172326291,8.136098310291914,0.004238770145314249,5.65243348886179,0.004342117141260693,2.483664821430124,0.004020964546076784]
[3,"Витрати на періодичну повірку квартирних засобів обліку",798.3,"x","x","x","x","x","x","x",798.3,0.4159008505002882,554.6070711129927,0.42604108033990107,243.69292888700733,0.39453013898229644]
[4,"Витрати на придбання води для послуги з гарячого водопостачання",4030.8408000000004,"x","x","x","x","x","x","x",4030.8408000000004,2.100000146500391,2733.7150822176436,2.1000001399769417,1297.1257177823568,2.1000001602486744]
[5,"Решта витрат, крім послуг банку",19.682806249786317,15.128693094402236,0.005781739656155974,3.4155196342144105,0.005250342006917761,0.04033621270252619,11.713173460187825,0.00595756565081775,4.55411315538408,0.002372616227732419,3.163902491074426,0.00243046384656143,1.3902106643096543,0.002250701360559671]
[6,"Собівартість послуг, без урахування послуг банку",161637.8862473666,123625.29544248624,47.24593649323832,27910.18505264038,42.90357916107562,329.61050774609527,95715.11038984587,48.68271232052864,38012.59080488036,19.803919385530723,26408.683016048322,20.286765943918102,11603.90778883204,18.786311829295517]
[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,"Послуги банку",1797.7924658453317,1375.0032860134975,0.5254856435041675,310.4267296046959,0.4771884436520039,3.6660420477321023,1064.5765564088015,0.5414659610978919,422.78917983183425,0.2202660396772882,293.7265047285456,0.2256364260698677,129.06267510328865,0.20894785654423736]
[9,"Повна планова собівартість послуг з урахуванням послуг банку",163435.67871321196,125000.29872849975,47.77142213674249,28220.611782245076,43.38076760472762,333.2765497938274,96779.68694625467,49.224178281626536,38435.3799847122,20.024185425208014,26702.40952077687,20.51240236998797,11732.97046393533,18.995259685839756]
[10,"Вартість послуг",163435.67871321196,125000.29872849975,"x",28220.611782245076,"x","x",96779.68694625467,"x",38435.3799847122,"x",26702.40952077687,"x",11732.97046393533,"x"]
[11,"Плановані тарифи на послуги, у т.ч. на послуги з централізованого опалення:","x","x",47.77142213674249,"x",43.38076760472762,333.2765497938274,"x",49.224178281626536,"x",20.024185425208014,"x",20.51240236998797,"x",18.995259685839756]
[" 11.1","вартість теплової енергії","x",122897.47931471808,46.96778666614822,27745.8701142,42.65099398632927,327.67,95151.60920051807,48.39610379883768,"x","x","x","x","x","x"]
[" 11.2","решта складових тарифу","x",2102.8194137816754,0.8036354705942665,474.74166804507695,0.7297736183983546,5.606549793827419,1628.0777457366057,0.8280744827888568,"x","x","x","x","x","x"]
[12,"Плановані тарифи на послуги, у т.ч. на послуги з централізованого опалення, з ПДВ:","x","x","x","x",null,399.9318597525929,"x",59.06901393795184,"x","x","x",24.614882843985566,"x",22.794311623007705]
["Допоміжна інформація"]
[1,"Обсяг теплової енергії, врахований у розрахунку собівартості, Гкал",475667.099675651,375064.78870423924,"x",84676.26,"x","x",290388.52870423923,"x",100602.31097141177,"x",70095.37279671464,"x",30506.93817469713,"x"]
[2,"Тариф на теплову енергію для потреб населення без ПДВ, грн/Гкал, у т. ч.:",327.67,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[" 2.1","повна планова собівартість теплової енергії для потреб населення, грн/Гкал",327.67,"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",2616.6333999999997,"x",650.53279,"x","x",1966.10061,"x","x","x","x","x","x","x"]
[4,"Обсяг споживання населенням гарячої води, тис. куб. м","x","x","x","x","x","x","x","x",1919.4478660953034,"x",1301.769,"x",617.6788660953034,"x"]
[5,"Кількість абонентів, яким надаються послуги",96148,54302,"x",11797,"x","x",42505,"x",41846,"x",28639,"x",13207,"x"]
[6,"Середньорічна кількість штатних працівників, задіяних у наданні послуг, у т. ч.:",16,13,"x",2.7764493260722842,"x","x",9.521547536700455,"x",3.2986485054711983,"x",2.298356712521596,"x",1.0002917929496025,"x"]
[" 6.1","абонентської служби",16,13,"x",2.7764493260722842,"x","x",9.521547536700455,"x",3.2986485054711987,"x",2.298356712521596,"x",1.0002917929496025,"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,"Середньомісячна заробітна плата, грн",3295,3295,"x",3295,"x","x",3295,"x",3295,"x",3295,"x",3295,"x"]
[9,"Обсяг холодної води для підігріву, тис. куб. м",1919.4479999999999,"x","x","x","x","x","x","x",1919.4479999999999,"x",1301.7690867703063,"x",617.6789132296936,"x"]
[10,"Вартість 1 куб. м холодної води без ПДВ, грн",2.1,"x","x","x","x","x","x","x",2.1,"x",2.1,"x",2.1,"x"]
[11,"Відсоток послуг банку, %",1.1,1.1,"x",1.1,"x","x",1.1,"x",1.1,"x",1.1,"x",1.1,"x"]
[12,"Питомі норми, враховані у планованих тарифах на послуги з централізованого опалення та гарячого водопостачання, Гкал/кв.м на рік; Гкал/куб.м","x","x",0.1433386842437459,"x",0.1301644764132489,"x","x",0.14769769523861712,"x",0.05241210910097035,"x",0.053846245222243454,"x",0.04938964217368921]
[13,"Тривалість опалювального періоду, діб","x","x",186,"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]