欢迎来到天天文库
浏览记录
ID:12424046
大小:354.00 KB
页数:7页
时间:2018-07-17
《库存周转大于180天商品分析处理改进方案》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、库存周转大于180天商品分析处理改进方案研究目的:分析华北区各店铺周转天数大于180天商品的构成及存在问题对降低此类商品制定阶段目标和标准对必要商品制定处理方案对基础管理方面的问题提出具体工作要求,修正规章制度数据来源:\jianmart数据中心周报表库存周转统计数据准确度:总量数据无误差结构数据以”库存周转统计(门店)071231.rar”文件数据为基础,参考”库存周转统计(门店)080121.rar””华北区周转天数对比表”文件数据分析数据中”采购囤货””采购物流订货+调拨””存在2次订货”三项数据统计存在1%-5%的误差名词解释:周转大于
2、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
3、%-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%计
4、算口径和门店不一致,以10/11/12商品为主合计6417.881570.9324.48%0.00% 占比100.0%24.48%24.48%0.00% 小结:1.XX店XX店XX3家店铺占比明显比华北区平均占比偏高,显在原因为整体经营问题造成店铺整体周转慢;1.XX店XX店偏高的显在原因为地域偏远,直配协配路途较长,送货成本高造成安全库存较其他店铺高,因此周转比北京地区店铺蛮5-10天.2.XX店XX店为北京郊区店铺,店铺2007年整体周转比华北区慢3-9天.一.华北区各店铺周转天数大于180天商品库存配送方式占比分析单位:万元门店库存金额合计大于18
5、0天金额合计直配直流协配日配自采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.
6、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合计5
7、000.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
8、.02%8
此文档下载收益归作者所有