CRM实施工具-06管理报表库-管理报表1.pptVIP

pagepage目录报表概览不同职位对报表有不同的查询权限RCM用户界面和登陆路径RCM系统报表下载RCM系统报表下载RCM系统报表打印目录Shipment报表概览ShipmentSell-thru报表列表ShipmentSell-thru报表目标用户ShipmentSell-thru报表学习Shipment,Sell-thruInventorybySKUShipmentSell-thruCompletion%byModelShipmentSell-thruCompletion%byDistributorInventoryTrendReportbyDistributor报表介绍:Shipment,Sell-thruInventorybySKU报表为我们提供:总部层级的按marketname和SKU分类的Shipment和ShipmentModelMix%.总部层级的按marketname和SKU分类的Sell-thru,Inventory和Inventoryweeks.区域层级的按marketname和SKU分类的Sell-thru和Sell-thruModelMix%.数据来源:从UPD2得到的ShipmentIMEI.第二张layout中,Sell-thru数据从distributor收集得到.第三张layout中,Sell-thru数据从客户的Sell-thru收集得到.Inventory数据由RCM系统计算得到.提示:由于数据来源的不同，第一张layout和第二张法layout的sell-thru可能不同.报表介绍:Shipment,Sell-thruInventorybySKU报表可以帮助我们：:掌握Distributor层级的以下信息的每月趋势按marketname和SKU分类的Shipment按marketname和SKU分类的ShipmentModelMix%按marketname和SKU分类的Sell-thru按marketname和SKU分类的Sell-thruModelMix%按marketname和SKU分类的Inventory按marketname和SKU分类的Inventoryweeks通过period,organization,DistributorType,Distributor查询以上信息.提示:Shipment和inventory是PRC层级的数据.Sell-thru可以显示到district层级(如果account和Distributors在同一个区域).Marketname可以下钻到SKU层级.报表介绍:Shipment,Sell-thruInventorybySKU报表指引:报表分析了Distributor层级的Shipment,Sell-thru和Inventory的趋势.ShipmentSell-thru通过比较不同区域的按SKU分类的Shipment和Sell-thru来了解其增长趋势.如果Shipment和Sell-thru销售数据持续下降，需要引起注意.通过分析Distributor和account上报的Sell-thru信息的区别,检验Distributors是否及时上报了Sell-thru.对于MAR,报表中显示的是PRC层级的数据,是从MARDistributorbranch汇总得到数据.Inventory由于MAR的Shipment等于Sell-thru,所以MARDistributor的inventory在Distributor层级是0.注意inventory警告来及时满足需求.如果Inventoryweeks高于13或者低于6，需要引起注意和采取行动.正常的inventoryweeks应该高于6.如果低于6,需要采取行动来推动Shipment报表介绍:Shipment,Sell-thruInventorybySKU主要概念:Sell-thruModelMix%=ModelsSell-thru/TotalSell-thruShipmentModelMix%=ModelsShipment/TotalShipmentInventoryWeeks计算方法当前月的inventoryweeks计算方法:InvWeeks=(