库存周转大于180天商品分析\处理\改进方案研究目的:分析华北区各店铺周转天数大于180天商品的构成及存在问题对降低此类商品制定阶段目标和标准对必要商品制定处理方案对基础管理方面的问题提出具体工作要求,修正规章制度数据来源:\\jianmart\数据中心\周报表\库存周转统计数据准确度:总量数据无误差结构数据以”库存周转统计（门店）071231.rar”文件数据为基础,参考”库存周转统计（门店）080121.rar”\”华北区周转天数对比表”文件数据分析数据中”采购囤货\””采购\物流订货+调拨”\”存在2次订货”三项数据统计存在1%-5%的误差名词解释:周转大于180天商品—包含大于360天和无销售商品采购囤货---不含烟\酒\新品,主要为有采购联络函及OA通知的副食粮油等商品一.华北区各店铺周转天数大于180天商品库存总金额占比分析单位:万元门店库存金额合计大于180天金额合计占店比占比与华北区占比差异显在原因XX店777.94153.5019.73%-4.75%XX店276.5969.6025.16%0.69%XX店263.87102.3138.77%14.30%整体经营XX店276.6581.1429.33%4.85%XX店487.62119.7324.55%0.08%XX店220.2642.9719.51%-4.97%XX店406.33100.2724.68%0.20%XX店249.9269.2727.72%3.24%XX店330.82108.9832.94%8.46%外阜XX店264.43126.8447.97%23.49%整体经营XX店288.7098.7634.21%9.73%外阜XX店247.6777.5731.32%6.84%XX店279.7086.8631.05%6.58%XX店452.67124.7627.56%3.08%XX店177.1269.8539.43%14.96%整体经营XX店1417.60138.549.77%-14.70%计算口径和门店不一致,以10/11/12商品为主合计6417.881570.9324.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.94153.5022.781.18128.850.450.24XX店276.5969.6018.580.9449.460.520.09XX店263.87102.3128.084.0776.491.220.12XX店276.6581.1425.093.2451.171.330.31XX店487.62119.7328.831.9288.200.570.21XX店220.2642.9712.750.5127.661.850.20XX店406.33100.2728.122.0868.860.850.35XX店249.9269.2712.911.0054.120.830.40XX店330.82108.9823.6010.9273.620.850.00XX店264.43126.8456.2411.5157.821.270.00XX店288.7098.7621.9513.6962.170.950.00XX店247.6777.5721.142.7452.860.670.14XX店279.7086.8620.071.2963.711.790.00XX店452.67124.7636.213.0284.031.250.23XX店177.1269.8520.980.4446.691.480.25合计5000.281432.40377.3358.55985.7115.882.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%;...
