屈臣氏库存管理培训

1EasternChinaRetailAcademyManagementProgrammeTheStockManagementCycle零售学院管理项目库存管理2EasternChinaToday’sAgendaUnderstandthesignificanceofstockmanagement了解库存管理的意义identifythekeystages指出关键步骤Howtodointheindividualstages每一阶段的关键原则thechangeinlast6months过去6个月的变化Q&A答疑3EasternChina为什么库存管理很重要？4EasternChina好的库存管理对我们意味着什么？毛利Otherincome现金收益现金收益=（占用现金-投入现金）*投资收益率=（销售*帐期-平均库存）*收益率=销售*（帐期-周转次数）*收益率5EasternChina1.101.040.840.820.750.840.880.900.950.770.760.810.810.750.760.750.820.800.810.700.750.800.850.900.951.001.051.101.15Jan.Feb.Mar.Apr.MayJun.Jul.Aug.Sep.Oct.Nov.Dec.2,0082,0092008StockValuePerStore1.411.341.251.271.101.131.141.061.261.131.291.101.040.950.771.160.760.840.900.880.700.800.901.001.101.201.301.401.50Jan.Feb.Mar.Apr.MayJun.Jul.Aug.Sep.Oct.Nov.Dec.2,0072,00876stores107stores107stores129stores6EasternChinaStockWeeksCoverTrend11.5010.558.8710.239.629.599.958.728.799.6610.619.617.797.859.068.937.868.098.308.517.008.009.0010.0011.0012.00Jan.Feb.Mar.Apr.May.Jun.Jul.Aug.Sep.Oct.Nov.Dec.2,0072,0087.127.107.407.617.627.797.107.277.797.858.107.797.859.068.937.868.098.308.515.006.007.008.009.0010.00Jan.Feb.Mar.Apr.May.Jun.Jul.Aug.Sep.Oct.Nov.Dec.2,0092,0087EasternChina关键步骤8EasternChinaTheStockManagementCycleManualorderDatabaseAccuracyPlanogramsKVSIMSystemSet-upReceiving&ClaimsMerchandisingStockRoomManagementExpiryDateCheckingReturnstoWarehouse/SupplierPromotionManagementMarkdownsStockAdjustments数据库的准确性ReportsManagement报表管理库存调整降价促销管理返回给仓库/供应商商品的有效期检查商品陈列和销售库房管理收货及索赔订货陈列图建立KVSIM系统9EasternChinaWouldyouriskbuildinghere?你会冒险在这里建房子吗？PhysicalStockSystemStock系统库存真实库存Inanidealworld…10EasternChinaTheStockManagementCycle库存管理RegionSOHSKUQty.Variance=0SKUQty.SOHaccuracyasofSTKday%Northis199timesstocktakeandGrandTotal883,473666,86075.48%Eastis198timesstocktakeandGrandTotal842,863628,18574.53%Southis223timesstocktakeandGrandTotal1,113,223836,47375.14%Nationalis700timesstocktakeandGRANDTOTAL3,170,1292,392,70175.48%数据的准确性数据截至7月11EasternChina库存调整•店铺在何种情况下发现库存有可能不准？-负库存报表？-零库存报表？-收货/退货差异-缺货检查-循环盘点•用何种代码调整-16+/17-缺货检查-11+/15-日常盘点-18+/19-收货差异（目前已经不要求店铺做）-35+/36-退货差异12EasternChinaTheStockManagementCycleDatabaseAccuracyPlanogramsKVSIMSystemSet-upStockAdjustments数据库的准确性库存调整陈列图建立KVSIM系统13EasternChinaRightPOGPlanogramofonemeter1米陈列图•陈列图的目的是-------•我们怎么保证陈列图的一致14EasternChinaTheStockManagementCycleOrderDatabaseAccuracyPlanogramsKVSIMSystemSet-upStockAdjustments数据库的准确性库存调整订货陈列图建立KVSIM系统A：自动补货B：店铺自行订货的货品15EasternChinaA：自动补货货品NoofSKUsrolledouttoallstores:3,655(99%)DEPTDESCNoofSKUsAllstoresStartweek2002Men'sGrooming175Y162001SanitaryProtection149Y172003Bath/Deo/Talc265Y192004Baby144Y192006Haircare664Y222007PaperGoods/Cotton83Y222008Oral197Y226001Fashion379Y246003Home63Y243001Facial921Y253002Hand/Body/DepilatoryY251001/1002Healthcare247Y281003FirstAid/NonMedical80Y281004Vitamins59Y281005Dietary/HealthFoods44Y281010FamilyPlanning97Y281007/1008OtherHealthcare5Y285001GiftConfectionery33Y295002Choc/Candies/Countlines225Y（除巧克力）295003Snacks/biscuits/Food212Y295004/5005Beverages/Sundries1452916EasternChinaAROOSDepartmentalPerformanceDEPTDESCOOS%StockTurn2002Men's7.70%4.75↓2.41%6.972001Sanpro15.78%3.48↓2.03%2.872003Bath9.05%4.50↓4.82%5.172004Baby8.54%7.11↓1.62%6.96DEPTDESCOOS%StockTurn2006Haircare4.70%7.03↓2.49%7.362007Paper6.30%2.35↓4.38%2.242008Oral8.40%4.08↓2.84%3.606001Fashion13.79%4.71↓6.00%4.916003Home12.34%4.25↓3.03%5.0617EasternChinaAutoreplenishmentlogic•考虑仓库的配货周期与到店的在途时间长短•考虑每个货品在每家店铺的平均销售•考虑每个货品在每家店铺的排面量和满架量•考虑商品销售随季节的变化•考虑促销和团购对销售的影响•店铺的库存一旦低于Min，系统会跑订单到max•店铺的库存包括当前库存+在途库存-预留转出库存-退货库存•订单可以在035报表中查询，并且看到平均销售及供应管理部设置的Min&Max18EasternChina035报表19EasternChinaB：未上自动补货专柜&巧克力•专柜•街货—供应商一般一周送1次•仓货—店铺每周向仓库订2次正常陈列图货品（部分高销售店铺除外）•巧克力•外区店铺不可订货，上海市内供应商直送建议订货量=可变因数*平均周销售-（店铺库存+在途库存）•可变因数—陈列图仓货2.5（A类货品）、2（B、C类货品）直流货、街货320EasternChina店铺库存后台订货21EasternChina开放店铺自行订货类型生效日期结束日期信息提供部门更新周期每月TOP50月初月底营运行政每月店铺装修改造改造开始当天改造结束当天营运行政新店开店当天开店六周后营运行政陈列图做促销促销开始前6天促销结束前一周周末广州采购每三周专柜货品上海采购货品每月更新,店铺上专柜的信息收到后立即更新手工订单和同天自动补货订单互不影响，但是由于手工订单会增大库存，所以如果没有相应的销售增大，会影响下一次的自动补货订单22EasternChinaMonitordelivery监控到货检查订单生成情况•订货第二天检查WTCCN035-补货结果摘要报表是否在RMS系统中生成（整张订单未生成，传输问题/IT）检查订货失败报表•没有足够库存/属性问题/税区问题23EasternChina属性的检查与申报每次订货完毕打印订货失败报表()•选择因为属性原因导致订货失败的货品上报营运部以下情况属性改变店铺不可订货品•非陈列图非当期促销货品•仓库已没有库存的下图货品•清货货品•抢货而关闭订货货品（供应链公告）•季节转换关闭订货货品（巧克力、唇膏、手霜等，见供应链公告）24EasternChina零库存检查YN每周选一天进行陈列图货位缺货检查DoGapCheckonceaweek将所有陈列图缺货的货品输入HHT（缺货检查功能）ScanGapitemsintoHHTGapCheckFunction在后台“缺货检查”中打印缺货报表PrintoffOOSReportinRSIM筛选系统有库存和没有库存的记录Separatethezerostockandnon-zerostockrecord系统有库存？Systemhasstock?在货架上查“暂无存货”牌，并追查缺货原因。PutTemporallyOOSticketinfrontofthepricetagandtracetheOOSreason.检查系统库存是否在其他货位上Checkifthestockisinotherlocation?在其他货位上？Otherlocation?N进行日常盘点，填写《日常盘点表》使用15（-）进行库存调整。AdjustthestockwithReasonCode15(-).将其他货位上的货品填补到陈列图空缺上Fillthegapwiththestockinotherlocations25EasternChina借助零库存报表26EasternChina反馈供应管理部•.自动补货数量过多:Min3周销售并且排面量+2自动补货数量过少:（Min1周销售）货品没有自动补货:货品为店铺陈列图货品,但系统未设置Min/Max值货品不应进行自动补货:货品为店铺非陈列图货品,但系统设置Min/Max值货品设置自动补货,但长时间未来货:货品设置了Min/Max,