{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Структура себeстоимости","data","РЦ по регионам"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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"}

{"sheet":"Структура себeстоимости","index":0,"n_rows":76,"n_cols":14,"rows_kept":76,"cut":false,"hidden":false,"merged":[[13,6,13,12],[14,6,14,12],[15,6,15,12],[16,6,16,12],[17,6,17,12],[52,6,52,12],[54,1,54,5],[54,6,54,13],[39,6,39,12],[30,6,30,12],[31,6,31,12],[32,6,32,12],[33,6,33,12],[34,6,34,12],[37,6,37,12],[35,6,35,12],[43,6,43,12],[44,6,44,12],[51,6,51,12],[45,6,45,12],[46,6,46,12],[26,6,26,12],[29,6,29,12],[18,6,18,12],[19,6,19,12],[20,6,20,12],[21,6,21,12],[22,6,22,12],[56,1,56,13],[6,2,6,3],[42,1,42,2],[52,1,52,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[50,1,50,2],[51,1,51,2],[49,1,49,2],[49,6,49,12],[23,6,23,12],[24,6,24,12],[25,6,25,12],[48,1,48,2],[38,6,38,12],[42,6,42,12],[61,1,61,2],[58,6,58,12],[59,6,59,12],[60,6,60,12],[61,6,61,12],[57,1,57,2],[57,6,57,12],[58,1,58,2],[59,1,59,2],[60,1,60,2],[50,6,50,12],[47,6,47,12],[48,6,48,12],[63,1,63,2],[63,6,63,12],[62,1,62,2],[62,6,62,12],[65,1,65,5],[65,6,65,13],[74,3,75,3],[74,4,75,4],[12,1,12,13],[28,1,28,13],[41,1,41,13],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[37,1,37,2],[38,1,38,2],[36,1,36,2],[36,6,36,12],[35,1,35,2],[74,10,75,10],[74,11,75,11],[74,12,75,12],[74,13,75,13],[74,5,75,5],[74,6,75,6],[74,7,75,7],[74,8,75,8],[74,9,75,9],[0,1,0,13],[4,2,4,13],[8,2,8,13],[10,2,10,13],[2,10,2,13],[2,5,2,6],[2,7,2,8],[6,5,6,6]]}
[null,"СТРУКТУРА СЕБЕСТОИМОСТИ ТОВАРА СТМ  ТС5"]
[]
[null,"Категория товара (выбрать из списка)",null,null,null,"Дата составления:   ",null,null,null,null,"* ВАЖНО! Заполняется на каждый товар отдельно *"]
[]
[null,"Продукт (наименование) "]
[]
[null,"Вес продукта нетто, кг",null,null,"кг","Продукт Импорта (Да/Нет)"]
[]
[null,"Поставщик"]
[]
[null,"Производитель "]
[]
[null,"1. Стоимость ингредиентов (сырья)  на единицу продукта* (без НДС):"]
[null,"Наименование ингредиента (сырья)","Доля ингредиента в составе готового продукта, %","Ед.измерения сырья\n (кг, л, шт.)","Количество ингредиента (сырья) в ед. объема продукта","Цена  единицы сырья, руб. без НДС ","Стоимость  сырья, руб. без НДС ",null,null,null,null,null,null,"Доля в стоимости продукта, %"]
[null,"<...>",{"$f":"$E15/$C$7","v":{"$error":"#DIV/0!"}},"кг",null,null,{"$f":"ROUND(E15*F15,3)","v":0},null,null,null,null,null,null,{"$f":"$G15/$G$27","v":{"$error":"#DIV/0!"}}]
[null,"<...>",{"$f":"$E16/$C$7","v":{"$error":"#DIV/0!"}},"л",null,null,{"$f":"ROUND(E16*F16,3)","v":0},null,null,null,null,null,null,{"$f":"$G16/$G$27","v":{"$error":"#DIV/0!"}}]
[null,"<...>",{"$f":"$E17/$C$7","v":{"$error":"#DIV/0!"}},"шт",null,null,0,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"<...>",{"$error":"#DIV/0!"},null,null,null,0,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"<...>",{"$error":"#DIV/0!"},null,null,null,0,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"<...>",{"$error":"#DIV/0!"},null,null,null,0,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"<...>",{"$error":"#DIV/0!"},null,null,null,0,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"<...>",{"$error":"#DIV/0!"},null,null,null,0,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"<...>",{"$error":"#DIV/0!"},null,null,null,0,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"<...>",{"$error":"#DIV/0!"},null,null,null,0,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"<...>",{"$error":"#DIV/0!"},null,null,null,0,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"<...>",{"$error":"#DIV/0!"},null,null,null,0,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Итого стоимость сырья, руб. без НДС:",{"$f":"SUM(C15:C26)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"SUM(G15:M26)","v":0},null,null,null,null,null,null,{"$f":"SUM(N15:N26)","v":{"$error":"#DIV/0!"}}]
[]
[null,"2. Стоимость индивидуальной и групповой упаковки на ед. товара:"]
[null,"Наименование компонента упаковки",null,"Ед.измерения компонента упаковки\n (кг, л, шт.)","Количество компонентов на 1 продукт","Цена единицы упаковки, руб. без НДС ","Стоимость  упаковки, руб. без НДС ",null,null,null,null,null,null,"Доля в стоимости упаковки, %"]
[null,"<...>",null,"кг",null,null,{"$f":"ROUND(E31*F31,3)","v":0},null,null,null,null,null,null,{"$f":"$G31/$G$40","v":{"$error":"#DIV/0!"}}]
[null,"<...>",null,"л",null,null,{"$f":"ROUND(E32*F32,3)","v":0},null,null,null,null,null,null,{"$f":"$G32/$G$40","v":{"$error":"#DIV/0!"}}]
[null,"<...>",null,"шт",null,null,0,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"<...>",null,null,null,null,0,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"<...>",null,null,null,null,0,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"<...>",null,null,null,null,0,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"<...>",null,null,null,null,0,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"<...>",null,null,null,null,0,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"<...>",null,null,null,null,0,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Итого стоимость упаковки, руб. без НДС:",null,null,null,null,{"$f":"SUM(G31:M39)","v":0},null,null,null,null,null,null,{"$f":"SUM(N31:N39)","v":{"$error":"#DIV/0!"}}]
[]
[null,"3. Затраты на производство единицы продукции "]
[null,"Статья затрат",null,"Ед.измерения статьи затрат","Количество единиц на 1 продукт","Цена, руб. без НДС ","Стоимость затрат на производство, руб. без НДС",null,null,null,null,null,null,"Доля в стоимости \nзатрат, %"]
[null,"Электроэнергия",null,"кВт/ч",null,null,{"$f":"ROUND(E44*F44,3)","v":0},null,null,null,null,null,null,{"$f":"$G44/$G$53","v":{"$error":"#DIV/0!"}}]
[null,"Вода",null,"л",null,null,{"$f":"ROUND(E45*F45,3)","v":0},null,null,null,null,null,null,{"$f":"$G45/$G$53","v":{"$error":"#DIV/0!"}}]
[null,"Расходные Материалы",null,null,null,null,0,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"ФОТ на производство",null,"руб.",null,null,0,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"<...>",null,null,null,null,0,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"<...>",null,null,null,null,0,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"<...>",null,null,null,null,0,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Стоимость заемных средств",null,"%",null,null,0,null,null,null,null,null,null,{"$f":"$G51/$G$53","v":{"$error":"#DIV/0!"}}]
[null,"Прочие расходы",null,"руб.",null,null,0,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Итого  стоимость затрат на производство, руб. без НДС:",null,null,null,null,{"$f":"SUM(G44:M51)","v":0},null,null,null,null,null,null,{"$f":"SUM(N44:N52)","v":{"$error":"#DIV/0!"}}]
[]
[null,"4. Производственная себестоимость продукции в руб. без НДС",null,null,null,null,{"$f":"ROUND(SUM(G27,G40,G53),2)","v":0}]
[]
[null,"5. Другие составляющие себестоимости "]
[null,"Входит в себестоимость",null,null,"в % от Производств Себестоимости","Фиксированная сумма, руб","Дополнительная стоимость, руб. без НДС",null,null,null,null,null,null,"Доля в Общей себестоимости, %"]
[null,"Акциз (только для алкогольной продукции, пива)",null,"Указать % или Фикс-->",null,{"$f":"$G$55*$E59","v":0},{"$f":"F59","v":0},null,null,null,null,null,null,{"$f":"$G59/$G$66","v":{"$error":"#DIV/0!"}}]
[null,"Маржа производителя, %      ",null,"Указать % или Фикс-->",null,{"$f":"$G$55*$E60","v":0},{"$f":"F60","v":0},null,null,null,null,null,null,{"$f":"$G60/$G$66","v":{"$error":"#DIV/0!"}}]
[null,"Расходы по импорту и таможенному оформлению (в случае Импорта)",null,"Указать % или Фикс-->",null,0,0,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Маржа Поставщика, %      ",null,"Указать % или Фикс-->",null,0,0,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"<...>",null,"Указать % или Фикс-->",null,0,0,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"<...>",null,"Указать % или Фикс-->",null,0,0,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[]
[null,"6. Общая себестоимость продукции в руб. без НДС",null,null,null,null,{"$f":"(G27+G40+G53+G59+G60+G61+G62+G63+G64)","v":0}]
[]
[null,"7. Региональное распределение \n     поставок продукта","РЕГИОНЫ:","Москва \nи МО","Северо-Запад","Центр","Юг","Северный\nКавказ","Волга\nСевер","Волга","Урал","Южный\nУрал","Сибирь","Единая федеральная цена, руб без НДС"]
[null,"Объемы продаж по регионам","Штук"]
[null,"Объемы продаж по регионам ","%",{"$f":"IF(SUM($D$69:$M$69)=0,0,D69/SUM($D$69:$M$69))","v":0},{"$f":"IF(SUM($D$69:$M$69)=0,0,E69/SUM($D$69:$M$69))","v":0},0,0,0,0,0,0,0,0]
[null,"Квант поставки на РЦ (паллет)","кол-во паллет"]
[null,"Транспортные расходы по каждому Региону","руб. без НДС",0,0,0,0,0,0,0,0,0,0,1.5]
[null,"Себестоимость продукции\nс транспортными расходами по регионам","руб. без НДС",0,0,0,0,0,0,0,0,0,0,{"$f":"ROUND($G$66+N$72,2)","v":1.5}]
[]
[null,"Ставка НДС, %",0.2,{"$f":"ROUND(D$73+(D$73*$C$75),2)","v":0},{"$f":"ROUND(E$73+(E$73*$C$75),2)","v":0},0,0,0,0,0,0,0,0,1.8]
[null,"Итоговая цена продукта","руб. с НДС"]

{"sheet":"data","index":1,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Фреш"]
["Бакалея Локальная"]
["Бакалея Федеральная"]
["Напитки"]
["Нон фуд"]

{"sheet":"РЦ по регионам","index":2,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Завод (знач)","Имя","Наименование филиала","Макрорегион"]
[163,"РЦ Самара","Филиал Средне-Волжский","Волга"]
[317,"РЦ 5 Казань","Филиал Приволжский","Волга"]
[323,"РЦ 5 Елабуга","Филиал Приволжский","Волга"]
[152,"РЦ Кстово","Филиал Волго-Вятский","Волга-Север"]
[242,"РЦ Вятка","Филиал Волго-Вятский","Волга-Север"]
[252,"РЦ Ярославль","Филиал Центральный","Волга-Север"]
[140,"РЦ Видное","Филиал Центральный","Москва"]
[154,"РЦ Богородск-алкоголь","Филиал Центральный","Москва"]
[180,"РЦ Подольск-Алкоголь","Филиал Центральный","Москва"]
[243,"РЦ 5 Москва Север","Филиал Центральный","Москва"]
[353,"РЦ 5 Лобня","Филиал Центральный","Москва"]
[185,"РЦ Южный","Филиал Южный","Северный Кавказ"]
[118,"РЦ Уткина Заводь","Филиал Северо-Западный","Северо-Запад"]
[182,"РЦ Адамант","Филиал Северо-Западный","Северо-Запад"]
[251,"РЦ 5 Петрозаводск Южный","Филиал Северо-Западный","Северо-Запад"]
[300,"РЦ 5 Великий Новгород Manhatta","Филиал Северо-Западный","Северо-Запад"]
[318,"РЦ 5 Толмачево","Филиал Сибирский","Сибирь"]
[253,"РЦ Пермь-Алкоголь","Филиал Уральский","Урал"]
[225,"РЦ 5 Тюмень","Филиал Уральский","Урал"]
[241,"РЦ Екатеринбург","Филиал Уральский","Урал"]
[175,"РЦ Ворсино","Филиал Центральный","Центр"]
[191,"РЦ Орел","Филиал Центрально-Черноземный","Центр"]
[202,"РЦ Рамонь-Алкоголь","Филиал Центрально-Черноземный","Центр"]
[]
["Сеть оставляет за собой право расширение и изменение действующих РЦ, что обусловлено её ростом."]