5月份各部销售情况.docVIP

5月份各部销售情况一、 洗涤1、 ABC分析数据5月ABC求和项:销售金额求和项:销售金额2求和项:毛利额求和项:毛利额2求和项:标注求和项:标注2A494228.1149.97%29546.5827.80%1103.80%B395862.6340.03%59137.0355.65%101335.00%C98918.7910.00%17590.316.55%177161.20%总计989009.53100.00%106273.91100.00%2894100.00%5月份单品ABC销售分析，洗涤A类商品占比低于行业10%标准，BC类商品高于行业标准。（1）、主要分析B、C类商品销售前半部分商品，加大促销力度或者买赠，查看商品陈列位置和缺断货情况，把这部分商品培养成A类或着B类。（2）、促销选品不能集中在那几个单品上，要把所有品类和品项跨全。（3）、季节性商品要突出陈列，促销要做在竞争对手前面。（4）、结构性商品和C类商品要注意商品毛利率，该赚毛利一定要赚毛利。采购在新品引进过程中一定要清楚商品的属性，不能统一商品毛利率加价。2、商品动销率总单品数零销售有销售单品数动销率2894358253687.62洗涤动销率和4月份基本持平，重点分析零销售商品，属于结构性商品和补充商品结构的商品保留，其它商品查看缺货和商品陈列，该淘汰的淘汰，提高商品动销率。3、双ABC 数据双ABC求和项:销售金额求和项:销售金额2求和项:毛利额求和项:毛利额2求和项:标注求和项:标注2A39281.33.97%1965.281.85%50.17%AA273703.1127.67%18871.5817.76%632.18%AB108611.510.98%5928.785.58%341.17%AC72632.27.34%2780.942.62%80.28%B4340.80.44%469.140.44%110.38%BA55654.835.63%7429.316.99%732.52%BB277327.9628.04%43457.9240.89%72825.16%BC58539.045.92%7780.667.32%2016.95%C4946.20.50%777.280.73%1685.81%CA1121.60.11%214.130.20%110.38%CB24063.62.43%4377.664.12%2588.91%CC68787.396.96%12221.2311.50%133446.10%总计989009.53100.00%106273.91100.00%2894100.00%双ABC分析是5月和4月（1）、重点抓AA类商品销售和库存，确保畅销商品和促销商品不能出现缺货，AC、AB类商品属于成长性商品要频繁的做促销。（2）、BB类是受关注商品，主要抓毛利但缺乏促销，增加促销商品品种。BC 类商品要加大促销力度。（3）、重点分析CA、CB类商品，这两类商品在淘汰范围之内。（分析商品性质属于补充商品结构和价格带，这2类商品可以不淘汰，其它的单品全部淘汰。）关注CC类库存，应控制库存数量。（重点分析零销售商品）4、库存性质数据库存性质求和项:销售金额求和项:销售金额2求和项:总成本求和项:总成本2求和项:标注求和项:标注2A=7970238.0398.10%797213.4271.93%220876.30%7B=3017517.11.77%169081.2215.25%29410.16%30c=90970.50.10%29604.472.67%260.90%90d=180228.80.02%21117.31.91%60.21%180e36539.20.00%87697.17.91%35912.40%总计989009.53100.00%1108366.3100.00%2894100.00%(1)、重点关注A365天商品。分析库存过高的原因，注意保持合理库存。(3)、根据库存性质查找新品要求供应商加大品牌宣传力度提高商品适销率，3个月内要求所有新品必修要达到B类商品达不到就淘汰。有些不知名品牌商品一个月零销售的应列于淘汰。5、小分销售情况数据品类号求和项:销售金额求和项:销售金额2累计占比求和项:毛利额求和项:毛利额2求和项:标注求和项:标注2单品贡献度10510101-长卷纸145840.614.75%14.75%5403.925.08%431.49%992.45%10530101-洗发水138697.714.02%28.77%12181.9611.46%30810.64%131.77%10550101-膏霜71942.67.27%36.04%12267.5611.54%32611.26%64.58%10510203-软抽纸63527.116.42%42.47%2753.962.59%250.86%743.56%10530501-牙膏62611.826.33%48.80%8838.448.32%1665.74%110.37%10520201-洗衣粉48567.84.91%53.71%2328.982.19%622.14%229.22%10510501-日用卫生巾377673.82%57.53%4856.354.57%802.76%138.14%10520203-洗衣液35641.93.60%61.13%2724.592.56%361.24%289.71%10510502-夜用卫生巾24490.72.48%63.61%3239.443.05%582.00%123.56%10530502-牙刷23856.82.41%66.02%4998.494.70%923.18%75.88%10520202-肥皂23262.82.35%68.37%1706.21.61%491.69%138.92%10550601-洁面乳20338.72.06%70.43%3612.883.40%1314.53%45.43%10510601-婴儿尿裤20025.42.02%72.45%2165.72.04%491.69%119.59%10530102-护发素18369.21.86%74.31%2603.822.45%822.83%65.55%10530201-香皂16577.51.68%75.99%1984.621.87%722.49%67.37%10510302-洁肤湿巾16294.71.65%77.63%2166.942.04%391.35%122.26%10530202-沐浴露16155.61.63%79.27%2338.862.20%963.32%49.24%10520301-洗洁精15308.961.55%80.82%428.810.40%331.14%135.75%10510201-手帕纸153061.55%82.36%1396.461.31%260.90%172.26%10510503-卫生护垫124741.26%83.62%1759.561.66%351.21%104.29%10560101-小家碧玉11315.71.14%84.77%2602.52.45%873.01%38.06%10550103-爽肤水10671.51.08%85.85%1819.311.71%551.90%56.78%10530306-染发剂103131.04%86.89%1575.021.48%291.00%104.06%10510102-短卷纸9850.31.00%87.89%630.750.59%130.45%221.72%10550201-男士护肤品8208.70.83%88.72%1416.661.33%571.97%42.14%10550102-面膜眼帖8193.30.83%89.55%1464.21.38%571.97%42.06%10550301-婴儿护肤品8039.90.81%90.36%1518.221.43%792.73%29.78%10510301-婴儿湿巾7013.90.71%91.07%809.790.76%150.52%136.83%10530302-者哩膏6395.80.65%91.71%1037.740.98%200.69%93.58%10530601-刀架4732.40.48%92.19%952.30.90%240.83%57.70%10530701-洗手液4703.80.48%92.67%625.60.59%170.59%80.97%10510202-盒抽纸3841.30.39%93.06%492.850.46%110.38%102.18%10530307-焗油膏3764.70.38%93.44%591.660.56%100.35%110.16%10530602-刀片3749.50.38%93.82%710.310.67%140.48%78.37%10530301-者哩水3572.30.36%94.18%515.080.48%190.66%55.02%10520107-花露水3519.90.36%94.53%443.80.42%200.69%51.50%10520106-杀虫剂3330.540.34%94.87%407.950.38%501.73%19.49%10520205-漂渍液2632.30.27%95.14%354.020.33%90.31%85.58%10520210-羊毛，羊绒衫洗涤剂2587.90.26%95.40%416.350.39%150.52%50.48%10520507-卫浴清洁剂2386.10.24%95.64%308.280.29%70.24%99.74%10520502-洁厕精2344.50.24%95.88%373.410.35%150.52%45.74%10510602-婴儿尿片，尿垫2220.50.22%96.10%477.50.45%80.28%81.22%10530505-牙粉2078.80.21%96.31%505.230.48%60.21%101.38%10530801-计生用品1932.40.20%96.51%386.860.36%371.28%15.28%10530203-浴盐1858.60.19%96.69%468.40.44%110.38%49.44%10520105-樟脑丸1770.50.18%96.87%267.210.25%90.31%57.56%10520302-油污净1723.40.17%97.05%248.360.23%110.38%45.84%10510605-成人尿裤1522.30.15%97.20%2130.20%30.10%148.48%10520208-柔顺剂1477.30.15%97.35%225.490.21%120.41%36.02%10520505-皮革护理剂1452.40.15%97.50%262.170.25%70.24%60.71%10530206-护理液1443.40.15%97.64%378.290.36%110.38%38.40%10550501-唇用品1429.50.14%97.79%270.70.25%260.90%16.09%10530207-爽身粉1402.70.14%97.93%237.340.22%150.52%27.36%10520509-鞋油1342.90.14%98.07%213.170.20%240.83%16.37%10530205-身体润肤品1340.60.14%98.20%217.430.20%90.31%43.59%10520503-84消毒液1214.20.12%98.32%208.780.20%100.35%35.53%10520102-液体清新剂1189.50.12%98.44%150.280.14%120.41%29.01%10530303-发蜡1175.30.12%98.56%189.770.18%140.48%24.57%10530603-剃须液1126.90.11%98.68%240.290.23%90.31%36.64%10510205-餐巾纸1086.80.11%98.79%218.20.21%40.14%79.50%10510603-成人尿片垫1034.40.10%98.89%156.320.15%40.14%75.67%#N/A908.90.09%98.98%129.60.12%50.17%53.19%10520209-洗衣消毒药水885.40.09%99.07%640.06%20.07%129.54%10520101-固体清新剂882.30.09%99.16%134.240.13%150.52%17.21%10510206-厨房专用纸812.10.08%99.24%152.80.14%40.14%59.41%10520508-地板清洁剂729.60.07%99.32%134.170.13%70.24%30.50%10550802-化妆棉706.50.07%99.39%162.460.15%270.93%7.66%10520211-内衣裤洗涤剂546.90.06%99.44%101.820.10%30.10%53.34%10530506-漱口水512.90.05%99.50%119.580.11%30.10%50.03%10520103-除味除菌剂480.20.05%99.55%78.320.07%70.24%20.07%10520206-羽绒服洗涤剂465.20.05%99.59%78.270.07%80.28%17.02%10520207-衣领净433.30.04%99.64%65.880.06%40.14%31.70%10510505-卫生棉条412.20.04%99.68%78.280.07%30.10%40.21%10550702-女士香水409.90.04%99.72%87.110.08%180.62%6.66%10520511-其他343.10.03%99.75%58.70.06%60.21%16.73%10550803-其他339.50.03%99.79%78.110.07%170.59%5.84%10550107-按摩膏296.10.03%99.82%55.260.05%30.10%28.88%10550801-甲钳类260.80.03%99.84%59.980.06%291.00%2.63%10520303-去污粉228.20.02%99.87%41.420.04%40.14%16.69%10520510-皮衣护理剂226.30.02%99.89%41.850.04%40.14%16.55%10520506-家俱护理剂223.60.02%99.91%35.060