{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["dod 9"],"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 9","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},"Додаток 9\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,"Собівартість власної теплової енергії, врахована у встановлених тарифах на теплову енергію для потреб населення ",36986.79434646909,28053.95743797623,32.044669882945094,14202.75952828,42.65099398632927,237.83,13851.197909696231,32.58246670023797,8932.836908492856,12.796996572792105,8932.836908492856,12.796996572792105,0,11.730580191726098]
[2,"Витрати на утримання абонентської служби, усього, у т.ч.:",669.5004689591545,478.88538887460027,0.5470074670277738,242.4433000167641,0.2473348327394326,4.059794853822316,236.44208885783618,0.5561877418091203,190.61508008455414,0.27307120364476567,190.61508008455414,0.27307120364476567,0,0.27307120364476567]
[" 2.1","витрати на оплату праці ",486.9057312000001,348.27763570276034,0.3978205887130861,176.32105986830226,0.16875522347289848,2.9525556343455692,171.9565758344581,0.4044971014450006,138.62809549723963,0.19859572956987798,138.62809549723963,0.19859572956987798,0,0.19859572956987798]
[" 2.2","відрахування на соціальні заходи ",180.44726398272005,129.071691791443,0.14743231017706973,65.34458478719282,0.06919967133494455,1.0942171180884679,63.72710700425018,0.14990662579551722,51.375572191277016,0.07359957737859679,51.375572191277016,0.07359957737859679,0,0.07359957737859679]
[" 2.3","інші витрати абонентської служби",2.147473776434424,1.536061380396952,0.0017545681376178817,0.7776553612690422,0.009379937931589583,0.0130221013882796,0.7584060191279098,0.0017840145686025427,0.6114123960374717,0.0008758966962908803,0.6114123960374717,0.0008758966962908803,0,0.0008758966962908803]
[3,"Витрати на періодичну повірку квартирних засобів обліку",261.50065,"x","x","x","x","x","x","x",261.50064999999984,0.3746203984370641,261.50064999999984,0.3746203984370641,0,0.3746203984370641]
[4,"Витрати на придбання води для послуги з гарячого водопостачання",2233.733356462119,"x","x","x","x","x","x","x",2233.733356462119,3.2,2233.733356462119,3.2,0,3.2]
[5,"Решта витрат, крім послуг банку",22.792526223565577,16.30321155857568,0.018622364904538037,8.253758629849445,0.005250342006917761,0.1382119728936098,8.049452928726234,0.01893489889576687,6.489314664989893,0.009296457371643238,6.489314664989893,0.009296457371643238,0,0.009296457371643238]
[6,"Собівартість послуг, без урахування послуг банку",40174.321348113925,28549.14603840941,32.61029971487741,14453.456586926613,42.90357916107562,242.02800682671594,14095.689451482795,33.15758934094286,11625.175309704518,16.653984632245578,11625.175309704518,16.653984632245578,0,15.587568251179572]
[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,"Послуги банку",611.7916956565573,434.7585691128336,0.4966035489575239,220.10339980091288,0.4771884436520039,3.6857056877164864,214.65516931192073,0.5049379087453227,177.03312654372365,0.25361397917125245,177.03312654372365,0.25361397917125245,0,0.23737413580476505]
[9,"Повна планова собівартість послуг з урахуванням послуг банку",40786.113043770485,28983.904607522243,33.10690326383493,14673.559986727527,43.38076760472762,245.71371251443244,14310.344620794715,33.66252724968818,11802.208436248242,16.90759861141683,11802.208436248242,16.90759861141683,0,15.824942386984338]
[10,"Вартість послуг",40786.113043770485,28983.904607522243,"x",14673.559986727527,"x","x",14310.344620794715,"x",11802.208436248242,"x",11802.208436248242,"x",0,"x"]
[11,"Плановані тарифи на послуги, у т.ч. на послуги з централізованого опалення:","x","x",33.10690326383493,"x",43.38076760472762,245.71371251443244,"x",33.66252724968818,"x",16.90759861141683,"x",16.90759861141683,"x",15.824942386984338]
[" 11.1","вартість теплової енергії","x",28053.95743797623,32.044669882945094,14202.75952828,42.65099398632927,237.83,13851.197909696231,32.58246670023797,"x","x","x","x","x","x"]
[" 11.2","решта складових тарифу","x",929.9471695460124,1.062233380889839,470.8004584475275,0.7297736183983546,7.88371251443243,459.14671109848314,1.08006054945021,"x","x","x","x","x","x"]
[12,"Плановані тарифи на послуги, у т.ч. на послуги з централізованого опалення, з ПДВ:","x","x","x","x",null,294.8564550173189,"x",40.395032699625816,"x","x","x",20.289118333700195,"x",18.989930864381204]
["Допоміжна інформація"]
[1,"Обсяг теплової енергії, врахований у розрахунку собівартості, Гкал",155517.78306550512,117958.026481,"x",59718.115999999995,"x","x",58239.910481,"x",37559.75658450513,"x",37559.75658450513,"x",0,"x"]
[2,"Тариф на теплову енергію для потреб населення без ПДВ, грн/Гкал, у т. ч.:",237.83,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[" 2.1","повна планова собівартість теплової енергії для потреб населення, грн/Гкал",237.83,"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",875.46408,"x",450.35207,"x","x",425.11201,"x","x","x","x","x","x","x"]
[4,"Обсяг споживання населенням гарячої води, тис. куб. м","x","x","x","x","x","x","x","x",698.0416738944122,"x",698.0416738944122,"x",0,"x"]
[5,"Кількість абонентів, яким надаються послуги",33447,19157,"x",9017,"x","x",10140,"x",14290,"x",14290,"x",0,"x"]
[6,"Середньорічна кількість штатних працівників, задіяних у наданні послуг, у т. ч.:",13.169999999999998,9.420337794958684,"x",4.76919495842143,"x","x",4.651142836537252,"x",3.749662205041314,"x",3.749662205041314,"x",0,"x"]
[" 6.1","абонентської служби",13.169999999999998,9.420337794958684,"x",4.76919495842143,"x","x",4.651142836537252,"x",3.749662205041314,"x",3.749662205041314,"x",0,"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,"Середньомісячна заробітна плата, грн",3080.90186788155,3080.9018678815496,"x",3080.9018678815496,"x","x",3080.9018678815496,"x",3080.9018678815496,"x",3080.9018678815496,"x",3080.9018678815496,"x"]
[9,"Обсяг холодної води для підігріву, тис. куб. м",698.0416738944122,"x","x","x","x","x","x","x",698.0416738944122,"x",698.0416738944122,"x",0,"x"]
[10,"Вартість 1 куб. м холодної води без ПДВ, грн",3.2,"x","x","x","x","x","x","x",3.2,"x",3.2,"x",3.2,"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.13473771131877849,"x",0.1301644764132489,"x","x",0.136998977001379,"x",0.05380732696796915,"x",0.05380732696796915,"x",0]
[13,"Тривалість опалювального періоду, діб","x","x",187,"x","x","x","x","x","x","x","x","x","x","x"]
[14,"Середня температура зовнішнього повітря опалювального періоду, град. С","x","x",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]