XLS《1档》

"店课规划表" "促销时间段:2011\8.

5_8.11" "序号","供应商编码","商品店内码","商品条码","商品名称","单位","原进价","原售价","原毛利率","竞争对手促销价格","现进价","现售价","现毛利率","可供数量","拍照样品来源",,

"陈列位置",,

,,

,,

"预估销售量","预估销售额","预估亏损额合计","促销时间","备注" 门店","自备","堆头(D)","端架(N)","排面(H)","特陈(T)","地堆","其它" "1","141170","141010043","6927765502034","银光湘优米10KG","包","52","54.8000390625","0.0510948905109489",,

"47","49.9000390625","0.0581162324649298","500" "2","141141","141210173","6941287865309","山润茶籽调和油5L","瓶","71.5","75.8000390625","0.0567282321899736",,

"61.5","65.9000390625","0.0667678300455236","1200" "3","111171","113090006","6902083880781","娃哈哈桂圆莲子八宝粥360G","瓶","3.15000244140625","3.5","0.1",,

"2.80000244140625","3.20000244140625","0.125","6000" "4","111117","111190017","6901424333948","王老吉利乐包凉茶250ML","盒","1.90000122070312","2.20000122070312","0.136363636363636",,

"1.60000122070313","1.90000122070312","0.157894736842105","8000" "5","146180","143010621","6920739682213","爽口萝卜350G","包","2.60000244140625","3.5","0.257142857142857",,

"2.60000244140625","2.80000244140625","0.0714285714285713","800" "6","141106","140240127","6917878027883","雀巢全脂奶粉袋装30*400GCN","袋","27.90001953125","32.80001953125","0.149390243902439",,

"24","25.80001953125","0.0697674418604651","200" "7","141106","130130006","6917878009261","雀巢花生威化@24(32*20G)赠8*20G","盒","26.90001953125","31.80001953125","0.154088050314465",,

"23","24.80001953125","0.0725806451612904","200" "8","131002","131030026","6914973600225","德芙牛奶巧克力碗装294G","碗","38.60001953125","45","0.142222222222222",,

"34.70001953125","35.80001953125","0.0307262569832401","200" "9","131002","131030027","6914973600249","德芙黑巧克力碗装294G","碗","38.60001953125","45","0.142222222222222",,

"34.70001953125","35.80001953125","0.0307262569832401","200" "10","131002","131030030","6914973600324","德芙巧克力拼盘290.5G","碗","38.60001953125","45","0.142222222222222",,

"34.70001953125","35.80001953125","0.0307262569832401","200" "11","131113","132440080","6925861531149","旺旺碎碎冰85ML(葡萄)","根","0.800000610351563","1","0.2",,

"0.75","0.800000610351563","0.0625000000000001","5000" ,"131113","132440078","6925861531828","旺旺碎碎冰85ML(水蜜桃)","根","0.800000610351563","1","0.2",,

"0.75","0.800000610351563","0.0625000000000001","5000" ,"131113","132440082","6925861531811","旺旺碎碎冰85ML(水果)","根","0.800000610351563","1","0.2",,

"0.75","0.800000610351563","0.0625000000000001","5000" ,"131113","132440079","6925861531163","旺旺碎碎冰85ML(桔子)","根","0.800000610351563","1","0.2",,

"0.75","0.800000610351563","0.0625000000000001","5000" ,"131113","132440083","6925861531170","旺旺碎碎冰85ML(波萝)","根","0.800000610351563","1","0.2",,

"0.75","0.800000610351563","0.0625000000000001","5000" ,"131113","132440084","6925861531835","旺旺碎碎冰85ML(乳酸)","根","0.800000610351563","1","0.2",,