库存周转大于180天商品处理与改进方案.doc

库存周转大于180天商品分析\处理\改进方案研究目的:分析华北区各店铺周转天数大于180天商品的构成及存在问题 对降低此类商品制定阶段目标和标准 对必要商品制定处理方案 对基础管理方面的问题提出具体工作要求,修正规章制度 数据来源: 数据准确度:总量数据无误差 结构数据以”库存周转统计（门店）071231.rar”文件数据为基础,参考” 库存周转统计（门店）080121.rar” \”华北区周转天数对比表”文件数据 分析数据中”采购囤货\”” 采购\物流订货+调拨”\” 存在2次订货”三项数据统计存在1%-5%的误差名词解释: 周转大于180天商品—包含大于360天和无销售商品 采购囤货---不含烟\酒\新品,主要为有采购联络函及OA通知的副食粮油等商品 一. 华北区各店铺周转天数大于180天商品库存总金额占比分析单位:万元门店库存金额合计大于180天金额合计占店比占比与华北区占比差异显在原因XX店777.94 153.50 19.73%-4.75%　XX店276.59 69.60 25.16%0.69%　XX店263.87 102.31 38.77%14.30%整体经营XX店276.65 81.14 29.33%4.85%　XX店487.62 119.73 24.55%0.08%　XX店220.26 42.97 19.51%-4.97%　XX店406.33 100.27 24.68%0.20%　XX店249.92 69.27 27.72%3.24%　XX店330.82 108.98 32.94%8.46%外阜XX店264.43 126.84 47.97%23.49%整体经营XX店288.70 98.76 34.21%9.73%外阜XX店247.67 77.57 31.32%6.84%　XX店279.70 86.86 31.05%6.58%　XX店452.67 124.76 27.56%3.08%　XX店177.12 69.85 39.43%14.96%整体经营XX店1417.60 138.54 9.77%-14.70%计算口径和门店不一致,以10/11/12商品为主合计6417.88 1570.93 24.48%0.00%　占比100.0%24.48%24.48%0.00%　小结:1. XX店\XX店\XX3家店铺占比明显比华北区平均占比偏高,显在原因为整体经营问题造成店铺整体周转慢;2. XX店\XX店偏高的显在原因为地域偏远,直配\协配路途较长,送货成本高造成安全库存较其他店铺高,因此周转比北京地区店铺蛮5-10天.3. XX店\XX店为北京郊区店铺,店铺2007年整体周转比华北区慢3-9天.二. 华北区各店铺周转天数大于180天商品库存配送方式占比分析单位:万元门店库存金额合计大于180天金额合计直配直流协配日配自采XX店777.94 153.50 22.78 1.18 128.85 0.45 0.24 XX店276.59 69.60 18.58 0.94 49.46 0.52 0.09 XX店263.87 102.31 28.08 4.07 76.49 1.22 0.12 XX店276.65 81.14 25.09 3.24 51.17 1.33 0.31 XX店487.62 119.73 28.83 1.92 88.20 0.57 0.21 XX店220.26 42.97 12.75 0.51 27.66 1.85 0.20 XX店406.33 100.27 28.12 2.08 68.86 0.85 0.35 XX店249.92 69.27 12.91 1.00 54.12 0.83 0.40 XX店330.82 108.98 23.60 10.92 73.62 0.85 0.00 XX店264.43 126.84 56.24 11.51 57.82 1.27 0.00 XX店288.70 98.76 21.95 13.69 62.17 0.95 0.00 XX店247.67 77.57 21.14 2.74 52.86 0.67 0.14 XX店279.70 86.86 20.07 1.29 63.71 1.79 0.00 XX店452.67 124.76 36.21 3.02 84.03 1.25 0.23 XX店177.12 69.85 20.98 0.44 46.69 1.48 0.25 合计5000.28 1432.40 377.33 58.55 985.71 15.88 2.54 占比100.0%28.65%7.55%1.17%19.71%0.32%0.05%门店库存金额合计占比大于180天金额合计占比直配占比直流占比协配占比日配占比自采占比XX16.30%10.72%14.84%0.77%83.94%0.29%0.16%XX5.76%4.86%26.70%1.35%71.06%0.75%0.13%XX6.19%7.14%27.45%3.98%74.76%1.19%0.12%XXX5.98%5.66%30.92%3.99%63.07%1.64%0.38%XXX11.02%8.36%24.08%1.60%73.67%0.48%0.18%XXX4.74%3.00%29.67%1.19%64.37%4.31%0.47%XXX9.22%7.00%28.05%2.07%68.68%0.85%0.35%XX店5.47%4.84%18.64%1.44%78.13%1.20%0.58%XX店8.10%7.61%21.66%10.02%67.55%0.78%0.00%XX店6.38%8.86%44.34%9.07%45.58%1.00%0.00%XX店6.36%6.89%22.23%13.86%62.95%0.96%0.00%XX店5.71%5.42%27.25%3.53%68.15%0.86%0.18%XX店6.54%6.06%23.11%1.49%73.35%2.06%0.00%XX店9.16%8.71%29.02%2.42%67.35%1.00%0.18%XX店3.95%4.88%30.04%0.63%66.85%2.12%0.35%合计100.00%100.00%26.34%4.09%68.82%1.11%0.18%小结:1. 剔除配送中心库存后,华北区大于180天商品库存占总库存比提高4.17%;2. 在大于180天商品库存中,协配\直配占总库存27.26%,占大于180天商品库存95.16%;XX店直配协配比例基本持平;3. 日配和生鲜自采此类高周转商品,周转大于180天的有库存18.42万元,占总库存0.37%;XXX等门店占比较高;此类商品不应出现周转大于180天的现象,要迅速处理;4. XX\XX店直流商品库存,受经营定位影响(百货占比高)占比较高.三. 华北区各店铺周转天数大于180天商品库存商品状态及退货方式占比分析 单位:万元门店库存金额合计大于180天金额合计可退货不可退货正常暂终正常暂终XX777.94 153.50 117.87 1.47 26.14 8.01 XX276.59 69.60 48.58 1.99 13.42 5.61 XX263.87 102.31 68.21 1.30 30.79 2.01 XXX276.65 81.14 51.37 1.80 24.12 3.85 XXX487.62 119.73 84.37 2.68 30.73 1.95 XXX220.26 42.97 27.57 1.23 13.44 0.73 XXX406.33 100.27 75.55 1.81 19.80 3.10 XX店249.92 69.27 52.20 1.20 15.15 0.72 XX店330.82 108.98 90.36 1.48 16.37 0.77 XX店264.43 126.84 105.89 2.77 16.20 1.99 XX店288.70 98.76 74.11 2.41 18.80 3.44 XX店247.67 77.57 60.74 1.30 13.44 2.09 XX店279.70 86.86 72.32 1.78 11.49 1.27 XX店452.67 124.76 96.65 1.81 23.39 2.90 XX店177.12 69.85 47.24 0.88 20.88 0.85 合计5000.28 1432.40 1073.03 25.90 294.17 39.29 占比100.0%28.65%21.46%0.52%5.88%0.79%门店库存金额合计大于180天金额合计占比可退货占店比不可退货占店比正常暂终正常暂终XX777.94 10.72%76.79%0.96%17.03%5.22%XX276.59 4.86%69.81%2.85%19.28%8.06%XX263.87 7.14%。