供应链的力量

1、商品列表一(样表)ID商品名称商品类型单件商品售价单件商品毛利平均每月销售量商品每月销售额商品每月毛利新方法是否节约成本1光明酸牛奶纯白饮料类5.60.48138772.8066.36+2蒙牛活性乳酸菌饮料草莓饮料类3.20.2435112.008.55-3达能维爽酸乳酪饮品芦荟饮料类3.20.172270.403.71+4全佳屋型纯鲜牛奶饮料类50.462271135.00104.49-5可口可乐(易拉罐)饮料类1.750.135801015.0077.44-6大湖100%橙汁(2L)饮料类19.81.7118356.4030.83+7桂冠贡丸食品类5.50.012401320.002.01

2、-8德芙牛奶黑巧克力精巧装食品类53.83.57552959.00196.31-9天府花生(300g)食品类30.20267801.0052.65-10吃不厌话梅食品类7.50.0787652.505.77+11金嗓子喉片食品类5.80.241269.602.90-12阿竹醉螃蜞食品类11.90.4023273.709.09-13梅林清蒸猪肉食品类8.20.6399811.8062.81+14波蜜八宝粥食品类3.20.2244140.809.74+15康师傅面霸120香辣牛肉面食品类3.20.053591148.8019.29-16乐惠清香梗米(10kg)食品类40.21.69863457.2

3、0145.03-17三角地速冻虾仁食品类13.60.281051428.0029.92-18白猫超浓缩无泡洗衣粉日用品类23.21.43471090.4067.12-19威廉太太保鲜膜简装日用品类3.90.3849191.1018.38-20佳洁士茶爽牙膏日用品类8.20.031771451.405.16-21高露洁旋风型牙刷日用品类3.70.06138510.607.89-22舒洁盒装面纸(200)日用品类7.20.641801296.00115.11+23(加长型)妙洁绒里手套日用品类9.50.4062589.0024.74-24飘柔滋润去屑2合1洗发露日用品类49.53.04137678

4、1.50416.52-25131双层微波炉饭盒日用品类50.101470.001.41-26红心电熨斗RH128小豕电类691.6612828.0019.86-27P伊莱克斯XBYC30B1饭煲小豕电类18818.7171316.00130.97-28万里牌9408C电吹风小豕电类270.4914378.006.82-29清华同方电话机TSD(22)-03小豕电类793.51292291.00101.72-商品列表二（按照月平均销售量来排序）ID商品名称商品类型单件商品售价单件商品毛利平均每月销售量商品每月销售额商品每月毛利新方法是否节约成本5可口可乐（易拉罐）饮料类1.750.1358010

5、15.0077.44-15康师傅面霸120香辣牛肉面食品类3.20.053591148.8019.29-9天府花生（300g）食品类30.20267801.0052.65-7桂冠贡丸食品类5.50.012401320.002.01-4全佳屋型纯鲜牛奶:饮料类50.462271135.00104.49-22舒洁盒装面纸（200）日用品类7.20.641801296.00115.11-20佳洁士茶爽牙膏日用品类8.20.031771451.405.16+1光明酸牛奶纯白饮料类5.60.48138772.8066.36-21高露洁旋风型牙刷日用品类3.70.06138510.607.89-24飘柔滋

6、润去屑2合1洗发露日用品类49.53.041376781.50416.52+17三角地速冻虾仁食品类13.60.281051428.0029.92+13梅林清蒸猪肉食品类8.20.6399811.8062.81-10吃不厌话梅食品类7.50.0787652.505.77-16P乐惠清香梗米（10kg）食品类40.21.69863457.20145.03+23（加长型）妙洁绒里手套日用品类9.50.4062589.0024.74-8德芙牛奶黑巧克力精巧装食品类53.83.57552959.00196.31+19威廉太太保鲜膜简装日用品类3.90.3849191.1018.38-18白猫超浓缩无泡

7、洗衣粉日用品类23.21.43471090.4067.12-14波蜜八宝粥食品类3.20.2244140.809.74-2蒙牛活性乳酸菌饮料草莓饮料类3.20.2435112.008.55-29清华冋方电话机 TSD（22）-03小豕电类793.51292291.00101.72+12阿竹醉螃蜞食品类11.90.4023273.709.09-3r达能维爽酸乳酪饮品芦荟饮料类3.20.172270.403.71-6大湖100滋汁（2L）饮料类19.81.7118356.4030.83-28万里牌9408C电吹风小豕电类270.4914378.006.82-25131双层微波炉饭盒日用品类50.1

8、01470.001.41-26红心电熨斗RH128小豕电类691.6612828.0019.86-11金嗓子喉片食品类5.80.241269.602.90-27伊莱克斯XBYC30B1饭煲小豕电类18818.7171316.00130.97+商品列表三(按照单件毛利来排序)ID商品名称商品类型单件商品售价单件商品毛利平均每月销售量商品每月销售额商品每月毛利新方法是否节约成本27伊莱克斯XBYC30B1饭煲小豕电类18818.7171316.00130.97+8德芙牛奶黑巧克力精巧装食品类53.83.57552959.00196.31+29清华冋方电话机TSD(22)-03小豕电类793.512

9、92291.00101.72+24飘柔滋润去屑2合1洗发露日用品类49.53.041376781.50416.52+6大湖 100%橙汁 (2L)饮料类19.81.7118356.4030.83-16乐惠清香梗米(10kg)食品类40.21.69863457.20145.03+26红心电熨斗RH128小豕电类691.6612828.0019.86-18白猫超浓缩无泡洗衣粉日用品类23.21.43471090.4067.12-22舒洁盒装面纸(200)日用品类7.20.641801296.00115.11-13梅林清蒸猪肉食品类8.20.6399811.8062.81-28万里牌9408C电吹风

10、小豕电类270.4914378.006.82-1光明酸牛奶纯白饮料类5.60.48138772.8066.36-4全佳屋型纯鲜牛奶饮料类50.462271135.00104.49-23(加长型)妙洁绒里手套日用品类9.50.4062589.0024.74-12阿竹醉螃蜞食品类11.90.4023273.709.09-19威廉太太保鲜膜简装日用品类3.90.3849191.1018.38-17三角地速冻虾仁食品类13.60.281051428.0029.92+2蒙牛活性乳酸菌饮料草莓:饮料类:3.20.2435112.008.55-11金嗓子喉片食品类5.80.241269.602.90-14波

11、蜜八宝粥食品类3.20.2244140.809.74-9天府花生(300g)食品类30.20267801.0052.65-3达能维爽酸乳酪饮品芦荟饮料类13.20.172270.403.71-5可口可乐(易拉罐)饮料类1.750.135801015.0077.44-25131双层微波炉饭盒日用品类50.101470.001.41-10吃不厌话梅食品类7.50.0787652.505.77-21高露洁旋风型牙刷日用品类3.70.06138510.607.89-15康师傅面霸120香辣牛肉面食品类3.20.053591148.8019.29-20佳洁士茶爽牙膏日用品类8.20.031771451.

12、405.16+7桂冠贡丸食品类5.50.012401320.002.01-商品列表四(按照月平均毛利来排序)ID商品名称商品类型单件商品售价单件商品毛利平均每月销售量商品每月销售额商品每月毛利新方法是否节约成本24飘柔滋润去屑2合1洗发露日用品类49.53.041376781.50416.52+8德芙牛奶黑巧克力精巧装食品类53.83.57552959.00196.31+16乐惠清香梗米(10kg)食品类40.21.69863457.20145.03+27伊莱克斯XBYC30B1饭煲小豕电类18818.7171316.00130.97+22舒洁盒装面纸(200)日用品类7.20.6418012

13、96.00115.11-4全佳屋型纯鲜牛奶饮料类50.462271135.00104.49-29清华冋方电话机 TSD(22)-03小豕电类793.51292291.00101.72+5可口可乐(易拉罐)饮料类1.750.135801015.0077.44-18白猫超浓缩无泡洗衣粉日用品类23.21.43471090.4067.12-1光明酸牛奶纯白饮料类5.60.48138772.8066.36-13梅林清蒸猪肉食品类8.20.6399811.8062.81-9天府花生(300g)食品类30.20267801.0052.65-6大湖100滋汁(2L)饮料类19.81.7118356.4030

14、.83-17三角地速冻虾仁食品类13.60.281051428.0029.92+23(加长型)妙洁绒里手套日用品类9.50.4062589.0024.74-26红心电熨斗RH128小豕电类691.6612828.0019.86-15康师傅面霸120香辣牛肉面食品类3.20.053591148.8019.29-19 威廉太太保鲜膜简装日用品类3.90.3849191.1018.38-14波蜜八宝粥食品类3.20.2244140.809.74-12阿竹醉螃蜞食品类11.90.4023273.709.09-2蒙牛活性乳酸菌饮料草莓饮料类3.20.2435112.008.55-21高露洁旋风型牙刷日用

15、品类3.70.06138510.607.89-28万里牌9408C电吹风小豕电类270.4914378.006.82-10吃不厌话梅食品类7.50.0787652.505.77-20佳洁士茶爽牙膏日用品类8.20.031771451.405.16+3达能维爽酸乳酪饮品芦荟饮料类3.20.172270.403.71-11金嗓子喉片食品类5.80.241269.602.90-7桂冠贡丸食品类5.50.012401320.002.01-25131双层微波炉饭盒日用品类50.101470.001.41-商品列表五(按照月平均销售额来排序)ID商品名称商品类型单件商品售价单件商品毛利平均每月销售量商品每

16、月销售额商品每月毛利新方法是否节约成本24飘柔滋润去屑2合1洗发露日用品类49.53.041376781.50416.52+16乐惠清香梗米(10kg)食品类40.21.69863457.20145.03+8德芙牛奶黑巧克力精巧装食品类53.83.57552959.00196.31+29清华同方电话机TSD(22)-03小豕电类793.51292291.00101.72+20佳洁士茶爽牙膏日用品类8.20.031771451.405.16+17三角地速冻虾仁食品类13.60.281051428.0029.92+7桂冠贡丸食品类5.50.012401320.002.01-27伊莱克斯XBYC30

17、B1饭煲小豕电类18818.7171316.00130.97+22舒洁盒装面纸(200)日用品类7.20.641801296.00115.11-15康师傅面霸120香辣牛肉面食品类3.20.053591148.8019.29-4全佳屋型纯鲜牛奶饮料类50.462271135.00104.49-18白猫超浓缩无泡洗衣粉日用品类23.21.43471090.4067.12-5可口可乐(易拉罐)饮料类1.750.135801015.0077.44-26红心电熨斗RH128小豕电类691.6612828.0019.86-13梅林清蒸猪肉食品类8.20.6399811.8062.81-9天府花生(300g)食品类30.20267801.0052.65-1光明酸牛奶纯白饮料类5.60.48138772.8066.36-10吃不厌话梅食品类7.50.0787652.505.77-23(加长型)妙洁绒里手套日用品类9.50.4062589.0024.74-21高露洁旋风型牙刷日用品类3.70.06138510.607.89-28万里牌9408C电吹风小豕电类270.491