{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["销售预估(500W)","销售预估 (270W)"],"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":"销售预估(500W)","index":0,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":false,"merged":[[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,13],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,31,0],[0,0,1,13],[0,14,1,18],[2,6,7,13],[8,0,9,13]]}
["2016年总体销售预估"]
[]
["年份",null,"销售目标","客单价","转化率","总目标UV","第一季度：成本最小化、利润最小化、客户量最大化、销售排行最大化\n第二季度：低端产品持续走量、中端产品补亏损、打造店铺3-5款爆款产品支撑店铺，同时扩展销售渠道，争取完成店铺销售/支出持平化！\n第三季度：要求产品必须到位，第三季度前关键一月，基础数据的铺垫，货源的准备，营销的手段等在此月准备充足，冲击第三、第四季度。\n第四季度：通过前三季产品T度的完成，第四季冲击全年销售额，完成产品销售利润10%参数。考虑参照大型活动拉动店铺销售指标。"]
[2016,null,{"$f":"SUM(C25:N25)","v":5338529.16666667},40,{"$f":"AVERAGE(C14:N14)","v":0.06},{"$f":"SUM(C13:N13)","v":2016483.33333333}]
["常规 ",null,{"$f":"D5*E5*F5","v":1582000},40,0.07,{"$f":"SUM(C20:N20)","v":565000}]
["付费推广",null,{"$f":"F6*D6*E6","v":1748553.33333333},40,0.07,{"$f":"SUM(C16:N18)","v":624483.333333333}]
["淘内活动",null,1630000,40,0.05,{"$f":"SUM(C19:N19)","v":815000}]
["站外",null,24000,40,0.05,{"$f":"SUM(C21:N21)","v":12000}]
["2016年1月-2016年12月年度销售目标分解"]
[]
["月份",null,"1月","2月","3月","4月","5月","6月","7月","8月","9月","10月","11月","12月"]
["销售量",null,{"$f":"C13*C14","v":4400},707.5,3116.66666666667,5666.66666666667,7466.66666666667,8600,12740,13953.3333333333,16823.3333333333,16846.6666666667,22236.6666666667,16613.3333333333]
["流量预估",null,{"$f":"SUM(C16:C21)","v":88000},14150,62333.3333333333,113333.333333333,149333.333333333,172000,182000,199333.333333333,240333.333333333,240666.666666667,317666.666666667,237333.333333333]
["转化率预估",null,0.05,0.05,0.05,0.05,0.05,0.05,0.07,0.07,0.07,0.07,0.07,0.07]
["客单价预估",null,35,35,35,35,35,40,40,40,40,45,45,45]
["直通车访客",null,{"$f":"C29/5","v":4500},{"$f":"D29/4","v":1250},{"$f":"E29/5","v":6000},{"$f":"F29/2","v":25000},{"$f":"G29/1","v":50000},{"$f":"H29/1.5","v":40000},40000,{"$f":"J29/1.2","v":50000},{"$f":"K29/1.2","v":58333.3333333333},46666.6666666667,66666.6666666667,{"$f":"N29/1","v":70000}]
["钻展",null,{"$f":"C30/6","v":2500},{"$f":"D30/5","v":400},3333.33333333333,3333.33333333333,3333.33333333333,5000,5000,3333.33333333333,5000,5000,{"$f":"M30/5","v":10000},{"$f":"N30/6","v":3333.33333333333}]
["淘宝客",null,50000,1500,2000,4000,5000,6000,6000,5000,6000,8000,20000,3000]
["淘内外活动",null,20000,5000,40000,50000,60000,80000,80000,80000,100000,100000,120000,80000]
["常规流量",null,10000,5000,10000,30000,30000,40000,50000,60000,70000,80000,100000,80000]
["站外",null,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000]
["全年预计推广费用"]
[null,null,"免费试用",null,"聚划算","陶抢购","陶抢购","聚划算","聚划算","陶抢购","聚划算","聚划算","聚划算","陶抢购"]
["项目",null,"1月","2月","3月","4月","5月","6月","7月","8月","9月","10月","11月","12月"]
["营业目标",null,{"$f":"C12*C15","v":154000},24762.5,109083.333333333,198333.333333333,261333.333333333,344000,509600,558133.333333333,672933.333333333,758100,1000650,747600]
["产品成本",null,{"$f":"C12*16.9","v":74360},11956.75,52671.6666666667,95766.6666666667,126186.666666667,145340,215306,235811.333333333,284314.333333333,284708.666666667,375799.666666667,280765.333333333]
["运费",null,{"$f":"C12*8","v":35200},5660,24933.3333333333,45333.3333333333,59733.3333333333,68800,101920,111626.666666667,134586.666666667,134773.333333333,177893.333333333,132906.666666667]
["运营推广费用",null,{"$f":"SUM(C29:C32)","v":100625},8943.75,61925,83850,84812.5,106600,109240,97700,119240,123860,194650,105197.5]
["费用细分","直通车",22500,5000,30000,50000,50000,60000,60000,60000,70000,70000,100000,70000]
[null,"钻展",15000,2000,20000,20000,20000,30000,30000,20000,30000,30000,50000,20000]
[null,"淘内，站外活动",15000,500,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000]
[null,"淘客",{"$f":"C18*C14*C15*0.55","v":48125},1443.75,1925,3850,4812.5,6600,9240,7700,9240,13860,34650,5197.5]
[null,"合计",{"$f":"C25-SUM(C26:C28)","v":-56185},-1798,-30446.6666666667,-26616.6666666667,-9399.16666666663,23260,83134.0000000001,112995.333333333,134792.333333333,214758,252307,228730.5,{"$f":"SUM(C33:N33)","v":925531.666666667}]

{"sheet":"销售预估 (270W)","index":1,"n_rows":28,"n_cols":15,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,13],[0,14,0,18],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,13],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,13],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,26,0],[1,6,5,13]]}
["2016年总体销售预估"]
["年份",null,"销售目标","客单价","转化率","总目标UV","第一季度：成本最小化、利润最小化、客户量最大化、销售排行最大化\n第二季度：低端产品持续走量、中端产品补亏损、打造店铺3-5款爆款产品支撑店铺，同时扩展销售渠道，争取完成店铺销售/支出持平化！\n第三季度：要求产品必须到位，第三季度前关键一月，基础数据的铺垫，货源的准备，营销的手段等在此月准备充足，冲击第三、第四季度。\n第四季度：通过前三季产品T度的完成，第四季冲击全年销售额，完成产品销售利润30%参数。考虑参照大型活动拉动店铺销售指标。",{"$nulls":7},"合计"]
[2016,null,{"$f":"SUM(C20:N20)","v":2700000},40,{"$f":"AVERAGE(C11:N11)","v":0.0575},{"$f":"SUM(C13:N16)","v":1119666.66666667},{"$nulls":8},{"$f":"D3*E3*F3","v":2575233.33333333}]
["常规 ",null,{"$f":"D4*E4*F4","v":1040850},45,0.09,{"$f":"SUM(C16:N16)","v":257000},{"$nulls":8},{"$f":"D4*E4*F4","v":1040850}]
["付费推广",null,{"$f":"F5*D5*E5","v":861333.333333333},40,0.05,{"$f":"SUM(C13:N14)","v":430666.666666667},{"$nulls":8},{"$f":"D5*E5*F5","v":861333.333333333}]
["淘内活动",null,{"$f":"F6*D6*E6","v":756000},35,0.05,{"$f":"SUM(C15:N15)","v":432000},{"$nulls":8},{"$f":"D6*E6*F6","v":756000}]
["2016年1月-2016年12月年度销售目标分解"]
["月份",null,"1月","2月","3月","4月","5月","6月","7月","8月","9月","10月","11月","12月"]
["销售量",null,{"$f":"C10*C11","v":2857.14285714286},{"$f":"D10*D11","v":571.428571428571},{"$f":"E10*E11","v":2857.14285714286},{"$f":"F10*F11","v":4285.71428571429},{"$f":"G10*G11","v":5714.28571428571},{"$f":"H10*H11","v":6250},{"$f":"I10*I11","v":7142.85714285714},{"$f":"J10*J11","v":6250},{"$f":"K10*K11","v":7000},{"$f":"L10*L11","v":6666.66666666667},{"$f":"M10*M11","v":9000},{"$f":"N10*N11","v":7000}]
["流量预估",null,{"$f":"(C20/C11)/C12","v":71428.5714285714},{"$f":"D20/D12/D11","v":14285.7142857143},{"$f":"(E20/E11)/E12","v":71428.5714285714},{"$f":"(F20/F11)/F12","v":85714.2857142857},{"$f":"(G20/G11)/G12","v":114285.714285714},{"$f":"(H20/H11)/H12","v":125000},{"$f":"(I20/I11)/I12","v":102040.816326531},{"$f":"(J20/J11)/J12","v":89285.7142857143},{"$f":"(K20/K11)/K12","v":100000},{"$f":"(L20/L11)/L12","v":95238.0952380952},{"$f":"(M20/M11)/M12","v":128571.428571429},{"$f":"(N20/N11)/N12","v":100000}]
["转化率预估",null,0.04,0.04,0.04,0.05,0.05,0.05,0.07,0.07,0.07,0.07,0.07,0.07]
["客单价预估",null,35,35,35,35,35,40,35,40,40,45,50,50]
["直通车访客",null,{"$f":"C25/2.5","v":8000},{"$f":"D25/1","v":5000},{"$f":"E25/2","v":10000},{"$f":"F25/2","v":10000},{"$f":"G25/1","v":25000},{"$f":"H25/1.5","v":20000},{"$f":"I25/1.5","v":20000},{"$f":"J25/1.2","v":25000},{"$f":"K25/1.2","v":33333.3333333333},{"$f":"L25/1.5","v":26666.6666666667},{"$f":"M25/1.5","v":26666.6666666667},{"$f":"N25/1","v":20000}]
["钻展",null,{"$f":"C26/2","v":5000},{"$f":"D26/2","v":1000},{"$f":"E26/1","v":20000},{"$f":"F26/1","v":20000},{"$f":"G26/1","v":30000},{"$f":"H26/1","v":20000},{"$f":"I26/3","v":10000},{"$f":"J26/2","v":10000},{"$f":"K26/2","v":15000},{"$f":"L26/1","v":30000},{"$f":"M26/2","v":20000},{"$f":"N26/1","v":20000}]
["淘内外活动，淘客",null,30000,2000,40000,30000,50000,50000,40000,40000,40000,40000,40000,30000]
["常规流量",null,5000,4000,8000,10000,15000,25000,20000,25000,30000,35000,40000,40000]
["全年预计推广费用"]
[{"$nulls":4},"免费试用","淘抢购","聚划算","淘抢购","聚划算","淘抢购","聚划算","聚划算","聚划算","淘抢购"]
["项目",null,"1月","2月","3月","4月","5月","6月","7月","8月","9月","10月","11月","12月"]
["营业目标",null,100000,20000,100000,150000,200000,250000,250000,250000,280000,300000,450000,350000]
["营业目标",null,100000,{"$f":"D9*D12","v":20000},{"$f":"E9*E12","v":100000},{"$f":"F9*F12","v":150000},{"$f":"G9*G12","v":200000},{"$f":"H9*H12","v":250000},{"$f":"I9*I12","v":250000},{"$f":"J9*J12","v":250000},{"$f":"K9*K12","v":280000},{"$f":"L9*L12","v":300000},{"$f":"M9*M12","v":450000},{"$f":"N9*N12","v":350000},{"$f":"SUM(C21:N21)","v":2700000}]
["产品成本",null,{"$f":"C9*11","v":31428.5714285714},{"$f":"D20*0.28","v":5600},{"$f":"E20*0.28","v":28000},{"$f":"F20*0.28","v":42000},{"$f":"G20*0.28","v":56000},{"$f":"H20*0.28","v":70000},{"$f":"I20*0.28","v":70000},{"$f":"J20*0.28","v":70000},{"$f":"K20*0.28","v":78400},{"$f":"L20*0.28","v":84000},{"$f":"M20*0.28","v":126000},{"$f":"N20*0.28","v":98000},{"$f":"SUM(C22:N22)","v":759428.571428571}]
["运费",null,{"$f":"C9*8","v":22857.1428571429},{"$f":"D20*0.2","v":4000},{"$f":"E20*0.2","v":20000},{"$f":"F20*0.2","v":30000},{"$f":"G20*0.2","v":40000},{"$f":"H20*0.2","v":50000},{"$f":"I20*0.2","v":50000},{"$f":"J20*0.2","v":50000},{"$f":"K20*0.2","v":56000},{"$f":"L20*0.2","v":60000},{"$f":"M20*0.2","v":90000},{"$f":"N20*0.2","v":70000},{"$f":"SUM(C23:N23)","v":542857.142857143}]
["运营推广费用",null,{"$f":"SUM(C25:C27)","v":45000},{"$f":"SUM(D25:D27)","v":7500},{"$f":"SUM(E25:E27)","v":50000},{"$f":"SUM(F25:F27)","v":50000},{"$f":"SUM(G25:G27)","v":65000},{"$f":"SUM(H25:H27)","v":60000},{"$f":"SUM(I25:I27)","v":70000},{"$f":"SUM(J25:J27)","v":60000},{"$f":"SUM(K25:K27)","v":80000},{"$f":"SUM(L25:L27)","v":80000},{"$f":"SUM(M25:M27)","v":90000},{"$f":"SUM(N25:N27)","v":50000},{"$f":"SUM(C24:N24)","v":707500}]
["费用细分","直通车",20000,5000,20000,20000,25000,30000,30000,30000,40000,40000,40000,20000,{"$f":"SUM(C25:N25)","v":320000}]
[null,"钻展",10000,2000,20000,20000,30000,20000,30000,20000,30000,30000,40000,20000,{"$f":"SUM(C26:N26)","v":272000}]
[null,"淘内，站外活动",15000,500,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,{"$f":"SUM(C27:N27)","v":115500}]
[null,"合计",{"$f":"C20-SUM(C22:C24)","v":714.28571428571},{"$f":"D20-SUM(D22:D24)","v":2900},{"$f":"E20-SUM(E22:E24)","v":2000},{"$f":"F20-SUM(F22:F24)","v":28000},{"$f":"G20-SUM(G22:G24)","v":39000},{"$f":"H20-SUM(H22:H24)","v":70000},{"$f":"I20-SUM(I22:I24)","v":60000},{"$f":"J20-SUM(J22:J24)","v":70000},{"$f":"K20-SUM(K22:K24)","v":65600},{"$f":"L20-SUM(L22:L24)","v":76000},{"$f":"M20-SUM(M22:M24)","v":144000},{"$f":"N20-SUM(N22:N24)","v":132000},{"$f":"SUM(C28:N28)","v":690214.285714286}]