雅芳物流系统需求分析

1SIM-ChinaDistributionModelRequirementDesignContentProjectObjectiveProjectMilestoneChinaDistributionCostSimulationRDCDeliveryCostStructureRDCDeliveryCostSimulationRDCOperationCostSimulation(Outofscope)AnalysisToolkit–QuotationVA2ProjectObjectiveObjective1–DevelopaDistributionCostSimulationModelandintegratewithSIMsystemtoprovidemanagementcompletesupplychainsimulationresulttohelpthemmakethemostsmartdecisionwithdifferentbusinesscriteria.Input•EnvironmentFactor•Oilcosttrend•Laborcosttrend•StrategicFactor•Distributionnetwork(include:RDCnumber/RDClocation/RDCservicearea/orderdeliveryroute,…)•DistributionStrategy(MfgRDC)(frequency,push,…)•DeliveryStrategy(RDCCustomers)•Sourceofsales•Customernumbergrowth•Averageordersizegrowth•Productmixchange•Customerdistributionchange•Orderdeliveryfrequency(mailplan)•Freedeliveryvalue•…Process•CurrentSIMModel•DistributionCostSimulationModel•MfgRDCtransportationcost•RDCCustomerdeliverycost•RDCoperationalcostOutput•Servicelevel•PFR•AverageOrderTurnAroundTime•Inventorylevel•FSInventoryLIDs•TotalDistributionCost•MfgRDCtransportationcost•RDCCustomerdeliverycost•RDCoperationalcost•HistoryDate(CustomerOrder,…)3ProjectObjectiveObjective2–EnhancethecurrentOrderDeliveryCostStructuretotransparentizetheorderdeliverycost,buildupalongtermandwin-winrelationshipwith3PL.Input•Orderinformation•Weight•Volume•FromLocation•ToLocationProcess•OrderDeliveryCostStructureOutput•DeliveryCostofEachOrderAxaptaPaymentto3PL4***ThisfunctionisbuiltinAxaptasystemProjectObjectiveObjective3–ProvideasetofusefulToolkitstohelpuserconductstrategicrelateddataanalysis.Toolkit.ABCClassificationUtilities•ForecastAccuracyAnalysis•SalesPatternAnalysis•DeliveryQuotationValueAnalysis•RDCBusinessProjection•RDCInventoryFluctuationAnalysis•RDCSpaceEvaluationandProjectionAnalysis•RDCLaborEvaluationandProjectionAnalysis•SourceofSalesAnalysis•…Output.ABCClassificationReport•ForecastAccuracyReport•DeliveryQuotationVAReport•…Database5ProjectMilestoneIdeaandInitiativeStageRequirementDesignStageSystemDesignStageProgrammingStageTestingandImplementationStage•Businessprocessandrequirementunderstanding•Preliminaryideadevelopment•Marketresearch•Projectscopeidentification•Preliminaryideaapprovalbymanagement•Strategyfactoridentification•Systemoutputidentification•Datasourceidentification•Systemlogicdesign•Systemuserinterfacedesign•Systemdesignfinalapprovalbymanagement•Systemdesignandprogramspecification•Datapreparation•UAT(Useracceptancetesting)•Systemmodification•SystemimplementationJan2010April2010May2010Sep2010NowPartTimeArrangementFullTimeArrangement6July2010•Programming•UnittestingandQAT7DistributionCostModelDistributionCostStructureTotalDistribution=DistributionCost+DeliveryCost8RDCCityCustomer(BB/SP)TranspBDeliveryCountyTranspCMFGTranspAUnitCostFormulaBusinessVolumeUnitCostFormulaBusinessVolumeUnitCostFormulaBusinessVolumeUnitCostFormulaBusinessVolumeDistributionCostDeliveryCost9LineHaulDistributionCostModelDistributionCostFormulaDistributionVolumeUnitCostbyTranspModePost(after3PLconfirm)DistributionCost(payto3PL)保险费/使用税桥路费司机工资管理费油费合理利润线路运输单价环境变量•油价•工资水平•车辆利用率•…价格机制汽车折旧汽车维修/保养固定成本变动成本What-IfSimulationProcess(convertthecurrentlinehaultransportationunitcoststructureintoSIM)Remark:管理费包括：年审费、违章罚款、营业税、企业所得税等DONetworkFirstPriorityTransMode=“Truck”NoDOTransMode=theFirstPriorityTransMode,DOTransCost=DOWeight*TransModeUnitCostYesComparetheDOWeightandDOVolumewiththeWeiCriteriaandVolCriteriaDOTransMode=“TO”DOTransCost=DOWeight*TransModeUnitCostDOTransCost=Truck(1)Cost*a+Truck(2)Cost*b+…+Truck(n)Cost*m•IfDOWeight/DOVolume=StdWeight/Volume,thenuseWeightcriteria,elseuseVolumecriteria;•Trunk(1),Truck(2),…,Truck(n)arethetrucktypes,andorderbyCapacitydescend;a,b,…,marethenumbersoftrucks;•Calculatea,b,c,d,…a=If[mod(DOWeight/MaxTrunk(1)Capacity)=MinTruckCapctiy,Roundup(DOWeight/MaxTruckCapcity),Rounddown(DOWeight/MaxTruckCapcity)];RemainedDOWeight=Max(DOWeight-a*MaxTruck(1)Capacity,0);b=If[mod(DOWeight/MaxTrunk(2)Capacity)=MinTruckCapctiy,Roundup(DOWeight/MaxTruckCapcity),Rounddown(DOWeight/MaxTruckCapcity)]……MeetTruckCriteriaTransportationCostA=∑SimPeriodDOTransCostDOWeight=(∑QtybyItem*ItemGrossWeight)/SampleRateDOVolume=(∑QtybyItem*ItemGrossVolume)/SampleRateNotMeetTruckCriteriaDOInformation10LineHaulDistributionCostModelDistributionCostFormula(DetailLogicinQADandCurrentSIM)11DeliveryCostModel–FeederTransportationFeederTransportationCostFormulaDeliveryVolumebyRouteUnitCostbyRoutePost(after3PLconfirm)DeliveryCost(payto3PL)保险费/使用税桥路费司机工资管理费油费合理利润线路运输单价环境变量•油价•工资水平•车辆利用率•…价格机制汽车折旧汽车维修/保养固定成本变动成本What-IfSimulationProcess(DevelopfeedertransportationunitcoststructureintoSIM)Remark:管理费包括：年审费、违章罚款、营业税、企业所得税等12DeliveryCostModel–LastMileDeliveryDeliveryCostFormula（LastMileDelivery)DeliveryVolumebyRouteUnitCostbyRouteSetupUnitCostBenchmarkbyThekeydriverofthedeliveryunitcostisdroppointdensityCitySetupbenchmarkbythecitysizeorregionthroughquotationandmarketresearchCountryUseChinaPostunitcostofmailorMESDeliveryCost(payto3PL)13DeliveryCostModel–TotalD