{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Вариант 1 (40 штук)","Вариант 2 (800 шт)","Вариант 3 ( 2000 штук)."],"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"}

{"sheet":"Вариант 1 (40 штук)","index":0,"n_rows":24,"n_cols":20,"rows_kept":24,"cut":false,"hidden":false,"merged":[[7,5,7,7],[8,0,8,1],[8,3,8,4],[8,5,8,7],[0,0,1,4],[0,5,0,7],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,9,19],[1,5,1,7],[10,14,10,19],[2,0,2,4],[2,5,2,7],[3,0,3,1],[3,3,3,4],[3,5,3,7],[4,0,4,1],[4,3,4,4],[4,5,4,7],[5,0,5,1],[5,3,5,4],[5,5,5,7],[6,0,6,1],[6,3,6,4],[6,5,6,7],[7,0,7,1],[7,3,7,4],[10,0,10,3],[10,4,10,7],[9,0,9,10],[10,8,10,13]]}
["ВВОДНЫЕ: \nСкопируйте таблицу и вставьте свои данные в желтые ячейки",{"$nulls":4},"РЕЗУЛЬТАТ",null,null," % локализации до 65%  —  доплата +20%"," % локализации от 65% до 74% —  оплата 100%"," % локализации от 75% — скидка  50%"]
[]
["Находятся в 1 кластере продаются по 40 штук",{"$nulls":4},"Продажи",null,null,{"$f":"F24","v":10000},{"$f":"L24","v":17000},{"$f":"R24","v":17000}]
["Стоимость товара",null,250.0,null,null,"Прибыль",null,null,{"$f":"G24","v":5000},{"$f":"M24","v":8500},{"$f":"S24","v":8500}]
["Маржа",null,125.0,null,null,"Комиссия маркетплейса на логистику ",null,null,{"$f":"H24","v":1320},{"$f":"N24","v":1870},{"$f":"T24","v":935}]
["Логистика на 1 ед. товара",null,0.03,null,null,"Доставка до терминала ТК",null,null,{"$f":"$F$24*$C$6","v":300},{"$f":"$L$24*$C$6","v":510},{"$f":"$R$24*$C$6","v":510}]
["Комиссия маркетплейса",null,0.11,"В среднем с последней милей",null,"Доставка до дверей маркетплейса ТК",null,null,{"$f":"$C$8","v":1300},{"$f":"7*$C$8","v":9100},{"$f":"8*$C$8","v":10400}]
["Доставка ТК до дверей ",null,1300.0,null,null,"Прибыль минус затраты на логистику",null,null,{"$f":"I4-I5-I6-I7","v":2080},-2980,-3345]
["Ср. прирост продаж ",null,1.7,null,null,"% Прибыли минус затраты на логистику",null,null,{"$f":"100%-(I7+I5+I6)/I4","v":0.416},-0.3505882353,-0.3935294118]
[]
["Вводные",null,null,null,"Вариант 1 = 1 кластер = повышенная логистика",null,null,null,"Вариант 2 = 7 кластеров = 100% за логистику",{"$nulls":5},"Вариант 3 = 8 кластеров минус 50% на 100% за логистику"]
[null,"Стоимость товара","Маржа","Комиссия на логистику","Остаток","Выручка и Остаток в рублях","Прибыль","Комиссия на логистику\n % локализации до 65%  —  доплата +20%","Остаток","Пророст продаж в кластере","Продажи в штуках с учетом прироста","Прирост продаж","Прибыль с учетом прироста","Сумма на логистику без надбавки.\n% локализации от 65% до 74% —  оплата 100%","Остаток","Пророст продаж в кластере","Продажи в штуках с учетом прироста","Прирост продаж","Прибыль с учетом прироста","Сумма на логистику \n % локализации от 75% — скидка  50%"]
["Кластер 1",{"$f":"$C$4","v":250},{"$f":"$C$5","v":125},{"$f":"$C$7","v":0.11},40.0,{"$f":"E13*B13","v":10000},{"$f":"C13*E13","v":5000},{"$f":"(F13*D13)*1.2","v":1320},6.0,{"$f":"$C$9","v":1.7},{"$f":"I13*J13","v":10.2},{"$f":"B13*K13","v":2550},{"$f":"C13*K13","v":1275},{"$f":"L13*D13","v":280.5},5.0,{"$f":"$C$9","v":1.7},{"$f":"O13*P13","v":8.5},{"$f":"Q13*B13","v":2125},{"$f":"Q13*C13","v":1062.5},{"$f":"(R13*D13)/2","v":116.875}]
["Кластер 2",250,125,0.11,0.0,null,null,null,6.0,1.7,10.2,2550,1275,280.5,5.0,1.7,8.5,2125,1062.5,116.875]
["Кластер 3",250,125,0.11,0.0,null,null,null,6.0,1.7,10.2,2550,1275,280.5,5.0,1.7,8.5,2125,1062.5,116.875]
["Кластер 4",250,125,0.11,0.0,null,null,null,6.0,1.7,10.2,2550,1275,280.5,5.0,1.7,8.5,2125,1062.5,116.875]
["Кластер 5",250,125,0.11,0.0,null,null,null,6.0,1.7,10.2,2550,1275,280.5,4.0,1.7,6.8,1700,850,93.5]
["Кластер 6",250,125,0.11,0.0,null,null,null,5.0,1.7,8.5,2125,1062.5,233.75,4.0,1.7,6.8,1700,850,93.5]
["Кластер 7",250,125,0.11,0.0,null,null,null,5.0,1.7,8.5,2125,1062.5,233.75,4.0,1.7,6.8,1700,850,93.5]
["Кластер 8",250,125,0.11,0.0,null,null,null,0.0,1.7,0,0,0,0,4.0,1.7,6.8,1700,850,93.5]
["Кластер 9",250,125,0.11,0.0,null,null,null,{"$f":"F21*H21","v":0},1.7,0,0,0,0,4.0,1.7,6.8,1700,850,93.5]
["Кластер 10",250,125,0.11,0.0,null,null,null,0,1.7,0,0,0,0,0.0,1.7,0,0,0,0]
["Кластер 11",250,125,0.11,0.0,null,null,null,0,1.7,0,0,0,0,0.0,1.7,0,0,0,0]
["Итого",null,null,null,{"$f":"SUM(E13:E22)","v":40},10000,5000,1320,40,null,{"$f":"SUM(K13:K22)","v":68},17000,8500,1870,40,null,{"$f":"SUM(Q13:Q22)","v":68},17000,8500,935]

{"sheet":"Вариант 2 (800 шт)","index":1,"n_rows":24,"n_cols":20,"rows_kept":24,"cut":false,"hidden":false,"merged":[[7,5,7,7],[8,0,8,1],[8,3,8,4],[8,5,8,7],[0,0,1,4],[0,5,0,7],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,9,19],[1,5,1,7],[10,14,10,19],[2,0,2,4],[2,5,2,7],[3,0,3,1],[3,3,3,4],[3,5,3,7],[4,0,4,1],[4,3,4,4],[4,5,4,7],[5,0,5,1],[5,3,5,4],[5,5,5,7],[6,0,6,1],[6,3,6,4],[6,5,6,7],[7,0,7,1],[7,3,7,4],[10,0,10,3],[10,4,10,7],[9,0,9,10],[10,8,10,13]]}
["ВВОДНЫЕ: \nСкопируйте таблицу и вставьте свои данные в желтые ячейки",{"$nulls":4},"РЕЗУЛЬТАТ",null,null," % локализации до 65%  —  доплата +20%"," % локализации от 65% до 74% —  оплата 100%"," % локализации от 75% — скидка  50%"]
[]
["Находятся в 1 кластере продаются по 800 штук",{"$nulls":4},"Продажи",null,null,{"$f":"F24","v":200000},{"$f":"L24","v":340000},{"$f":"R24","v":340000}]
["Стоимость товара",null,250.0,null,null,"Прибыль",null,null,{"$f":"G24","v":100000},{"$f":"M24","v":170000},{"$f":"S24","v":170000}]
["Маржа",null,125.0,null,null,"Комиссия маркетплейса на логистику ",null,null,{"$f":"H24","v":26400},{"$f":"N24","v":37400},{"$f":"T24","v":18700}]
["Логистика на 1 ед. товара",null,0.03,null,null,"Доставка до терминала ТК",null,null,{"$f":"$F$24*$C$6","v":6000},{"$f":"$L$24*$C$6","v":10200},{"$f":"$R$24*$C$6","v":10200}]
["Комиссия маркетплейса",null,0.11,"В среднем с последней милей",null,"Доставка до дверей маркетплейса ТК",null,null,{"$f":"$C$8","v":1300},{"$f":"7*$C$8","v":9100},{"$f":"8*$C$8","v":10400}]
["Доставка ТК до дверей ",null,1300.0,null,null,"Прибыль минус затраты на логистику",null,null,{"$f":"I4-I5-I6-I7","v":66300},113300,130700]
["Ср. прирост продаж ",null,1.7,null,null,"% Прибыли минус затраты на логистику",null,null,{"$f":"100%-(I7+I5+I6)/I4","v":0.663},0.6664705882,0.7688235294]
[]
["Вводные",null,null,null,"Вариант 1 = 1 кластер = повышенная логистика",null,null,null,"Вариант 2 = 7 кластеров = 100% за логистику",{"$nulls":5},"Вариант 3 = 8 кластеров минус 50% на 100% за логистику"]
[null,"Стоимость товара","Маржа","Комиссия на логистику","Остаток","Выручка и Остаток в рублях","Прибыль","Комиссия на логистику\n % локализации до 65%  —  доплата +20%","Остаток","Пророст продаж в кластере","Продажи в штуках с учетом прироста","Прирост продаж","Прибыль с учетом прироста","Сумма на логистику без надбавки.\n% локализации от 65% до 74% —  оплата 100%","Остаток","Пророст продаж в кластере","Продажи в штуках с учетом прироста","Прирост продаж","Прибыль с учетом прироста","Сумма на логистику \n % локализации от 75% — скидка  50%"]
["Кластер 1",{"$f":"$C$4","v":250},{"$f":"$C$5","v":125},{"$f":"$C$7","v":0.11},800.0,{"$f":"E13*B13","v":200000},{"$f":"C13*E13","v":100000},{"$f":"(F13*D13)*1.2","v":26400},120.0,{"$f":"$C$9","v":1.7},{"$f":"I13*J13","v":204},{"$f":"B13*K13","v":51000},{"$f":"C13*K13","v":25500},{"$f":"L13*D13","v":5610},100.0,{"$f":"$C$9","v":1.7},{"$f":"O13*P13","v":170},{"$f":"Q13*B13","v":42500},{"$f":"Q13*C13","v":21250},{"$f":"(R13*D13)/2","v":2337.5}]
["Кластер 2",250,125,0.11,0.0,null,null,null,120.0,1.7,204,51000,25500,5610,100.0,1.7,170,42500,21250,2337.5]
["Кластер 3",250,125,0.11,0.0,null,null,null,120.0,1.7,204,51000,25500,5610,100.0,1.7,170,42500,21250,2337.5]
["Кластер 4",250,125,0.11,0.0,null,null,null,120.0,1.7,204,51000,25500,5610,100.0,1.7,170,42500,21250,2337.5]
["Кластер 5",250,125,0.11,0.0,null,null,null,120.0,1.7,204,51000,25500,5610,100.0,1.7,170,42500,21250,2337.5]
["Кластер 6",250,125,0.11,0.0,null,null,null,100.0,1.7,170,42500,21250,4675,100.0,1.7,170,42500,21250,2337.5]
["Кластер 7",250,125,0.11,0.0,null,null,null,100.0,1.7,170,42500,21250,4675,100.0,1.7,170,42500,21250,2337.5]
["Кластер 8",250,125,0.11,0.0,null,null,null,0.0,1.7,0,0,0,0,100.0,1.7,170,42500,21250,2337.5]
["Кластер 9",250,125,0.11,0.0,null,null,null,{"$f":"F21*H21","v":0},1.7,0,0,0,0,0.0,1.7,0,0,0,0]
["Кластер 10",250,125,0.11,0.0,null,null,null,0,1.7,0,0,0,0,0.0,1.7,0,0,0,0]
["Кластер 11",250,125,0.11,0.0,null,null,null,0,1.7,0,0,0,0,0.0,1.7,0,0,0,0]
["Итого",null,null,null,{"$f":"SUM(E13:E22)","v":800},200000,100000,26400,800,null,{"$f":"SUM(K13:K22)","v":1360},340000,170000,37400,800,null,{"$f":"SUM(Q13:Q22)","v":1360},340000,170000,18700]

{"sheet":"Вариант 3 ( 2000 штук).","index":2,"n_rows":24,"n_cols":20,"rows_kept":24,"cut":false,"hidden":false,"merged":[[7,5,7,7],[8,0,8,1],[8,3,8,4],[8,5,8,7],[0,0,1,4],[0,5,0,7],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,9,19],[1,5,1,7],[10,14,10,19],[2,0,2,4],[2,5,2,7],[3,0,3,1],[3,3,3,4],[3,5,3,7],[4,0,4,1],[4,3,4,4],[4,5,4,7],[5,0,5,1],[5,3,5,4],[5,5,5,7],[6,0,6,1],[6,3,6,4],[6,5,6,7],[7,0,7,1],[7,3,7,4],[10,0,10,3],[10,4,10,7],[9,0,9,10],[10,8,10,13]]}
["ВВОДНЫЕ: \nСкопируйте таблицу и вставьте свои данные в желтые ячейки",{"$nulls":4},"РЕЗУЛЬТАТ",null,null," % локализации до 65%  —  доплата +20%"," % локализации от 65% до 74% —  оплата 100%"," % локализации от 75% — скидка  50%"]
[]
["Находятся в 1 кластере продаются по 2000 штук",{"$nulls":4},"Продажи",null,null,{"$f":"F24","v":500000},{"$f":"L24","v":850000},{"$f":"R24","v":850000}]
["Стоимость товара",null,250.0,null,null,"Прибыль",null,null,{"$f":"G24","v":250000},{"$f":"M24","v":425000},{"$f":"S24","v":425000}]
["Маржа",null,125.0,null,null,"Комиссия маркетплейса на логистику ",null,null,{"$f":"H24","v":66000},{"$f":"N24","v":93500},{"$f":"T24","v":46750}]
["Логистика на 1 ед. товара",null,0.03,null,null,"Доставка до терминала ТК",null,null,{"$f":"$F$24*$C$6","v":15000},{"$f":"$L$24*$C$6","v":25500},{"$f":"$R$24*$C$6","v":25500}]
["Комиссия маркетплейса",null,0.11,"В среднем с последней милей",null,"Доставка до дверей маркетплейса ТК",null,null,{"$f":"$C$8","v":1300},{"$f":"7*$C$8","v":9100},{"$f":"8*$C$8","v":10400}]
["Доставка ТК до дверей ",null,1300.0,null,null,"Прибыль минус затраты на логистику",null,null,{"$f":"I4-I5-I6-I7","v":167700},296900,342350]
["Ср. прирост продаж ",null,1.7,null,null,"% Прибыли минус затраты на логистику",null,null,{"$f":"100%-(I7+I5+I6)/I4","v":0.6708},0.6985882353,0.8055294118]
[]
["Вводные",null,null,null,"Вариант 1 = 1 кластер = повышенная логистика",null,null,null,"Вариант 2 = 7 кластеров = 100% за логистику",{"$nulls":5},"Вариант 3 = 8 кластеров минус 50% на 100% за логистику"]
[null,"Стоимость товара","Маржа","Комиссия на логистику","Остаток","Выручка и Остаток в рублях","Прибыль","Комиссия на логистику\n % локализации до 65%  —  доплата +20%","Остаток","Пророст продаж в кластере","Продажи в штуках с учетом прироста","Прирост продаж","Прибыль с учетом прироста","Сумма на логистику без надбавки.\n% локализации от 65% до 74% —  оплата 100%","Остаток","Пророст продаж в кластере","Продажи в штуках с учетом прироста","Прирост продаж","Прибыль с учетом прироста","Сумма на логистику \n % локализации от 75% — скидка  50%"]
["Кластер 1",{"$f":"$C$4","v":250},{"$f":"$C$5","v":125},{"$f":"$C$7","v":0.11},2000.0,{"$f":"E13*B13","v":500000},{"$f":"C13*E13","v":250000},{"$f":"(F13*D13)*1.2","v":66000},300.0,{"$f":"$C$9","v":1.7},{"$f":"I13*J13","v":510},{"$f":"B13*K13","v":127500},{"$f":"C13*K13","v":63750},{"$f":"L13*D13","v":14025},300.0,{"$f":"$C$9","v":1.7},{"$f":"O13*P13","v":510},{"$f":"Q13*B13","v":127500},{"$f":"Q13*C13","v":63750},{"$f":"(R13*D13)/2","v":7012.5}]
["Кластер 2",250,125,0.11,0.0,null,null,null,300.0,1.7,510,127500,63750,14025,300.0,1.7,510,127500,63750,7012.5]
["Кластер 3",250,125,0.11,0.0,null,null,null,300.0,1.7,510,127500,63750,14025,300.0,1.7,510,127500,63750,7012.5]
["Кластер 4",250,125,0.11,0.0,null,null,null,300.0,1.7,510,127500,63750,14025,300.0,1.7,510,127500,63750,7012.5]
["Кластер 5",250,125,0.11,0.0,null,null,null,300.0,1.7,510,127500,63750,14025,200.0,1.7,340,85000,42500,4675]
["Кластер 6",250,125,0.11,0.0,null,null,null,300.0,1.7,510,127500,63750,14025,200.0,1.7,340,85000,42500,4675]
["Кластер 7",250,125,0.11,0.0,null,null,null,200.0,1.7,340,85000,42500,9350,200.0,1.7,340,85000,42500,4675]
["Кластер 8",250,125,0.11,0.0,null,null,null,0.0,1.7,0,0,0,0,100.0,1.7,170,42500,21250,2337.5]
["Кластер 9",250,125,0.11,0.0,null,null,null,{"$f":"F21*H21","v":0},1.7,0,0,0,0,100.0,1.7,170,42500,21250,2337.5]
["Кластер 10",250,125,0.11,0.0,null,null,null,0,1.7,0,0,0,0,0.0,1.7,0,0,0,0]
["Кластер 11",250,125,0.11,0.0,null,null,null,0,1.7,0,0,0,0,0.0,1.7,0,0,0,0]
["Итого",null,null,null,{"$f":"SUM(E13:E22)","v":2000},500000,250000,66000,2000,null,{"$f":"SUM(K13:K22)","v":3400},850000,425000,{"$f":"SUM(N13:N23)","v":93500},{"$f":"SUM(O13:O22)","v":2000},null,{"$f":"SUM(Q13:Q22)","v":3400},850000,425000,{"$f":"SUM(T13:T23)","v":46750}]