L’OréalSupplyChainDiagnosticMarch18,20041PresentationAgendaI.ProjectScopeandActivitiesII.OverviewofOurSupplyChainFindingsI.ProcessesII.InventoryReviewIII.MaturityProfilesIV.Organization/PeopleandCultureV.TechnologyIII.SupplyChainRoadmapIV.DiscussionofNextSteps2OurProjectApproachOverthepastthreeweeks,wehave:Interviewed5ExecutivesofL’OréalCanadaFacilitatedtwocross-functionalprocessworkshopsCollectedandanalyzeddataConductedahighlevelmaturityassessmentComparedL’OréalprocessandperformancetoCPGbestpracticeIdentifiedkeybusinessissuesandareasofimprovementSummarizedourfindingsinthispresentationdocumentProjectKickoffDataCollectionInterviewwithExecutivesProcessWorkshopsModelReview&ValidateBaseCaseReviewMetricsIdentify&ConsolidateIssues&OpportunitiesOpportunityPrioritizationBenefitsAssessmentFindings/RecommendationDevelopmentPresentRecommendationsDiscussNextSteps3Cross-FunctionalParticipantsSeniorManagement-SupplyChainLaurentVenot(ProjectSponsor)JeanValoisPierreMassicotteValéryMayerSalesDominiqueDeCellesIsabelleGenestAnne-MarieNelsonDionGemmityCustomerServiceEliBengioPatriciaRaposoLogistics&ProcurementValérieLacerteYvesDubéNaityJacelInformationtechnologyPierreJournelMarcelyneCraftFinanceMartinDeschênes4PresentationAgendaI.ProjectScopeandActivitiesII.OverviewofOurSupplyChainFindingsI.ProcessesII.InventoryReviewIII.MaturityProfilesIV.Organization/PeopleandCultureV.TechnologyIII.SupplyChainRoadmapIV.DiscussionofNextSteps5ProcessesDemandPlanningSupplyPlanningOrderFulfillment•DevelopSalesForecast•MaintainPromotionalPlan•Considerinventorylevels,backorderreports,safetystocklevels•Consolidateandconsiderexternaldata(POS,Nielsen,Customerdata)•ReconcileDemandPlanwithBudget•NewProductIntroductions•NetInventoryandLeadTimesfromtheForecast•DistributedRequirementPlanning•CapacityRequirementPlanning•CustomerAllocations•CommunicateforecasttoSuppliers•Receivesuppliercommitment•ProcessCustomerOrders•PlanandManageFinishedGoodsInventory•PickingandPacking•ManageOutboundProductFlow•Manageshipping&transportation•GenerateInvoice•CreditmanagementandA/R(*)Outofscope6DemandPlanning–IssuesandOpportunitiesIssuesManualandInconsistentProcessesTheforecastprocessismostlymanual,inconsistentacrossbrandsanddivisions(duetodifferentlevelsofmaturity)aswellasbothtimeandresourceconsumingThereisnoformalprocessfordeterminingwhichproductsshouldbefocusedonduringtheforecastingmeetingsNoonedepartment“ownstheforecast”ThereisnomechanismforautomaticallygeneratingabaselineforecastToomuchtimeisspentonmanualprocesses,dataclean-upandgeneratingreports,leavinginsufficienttimetoanalyzedataandmanageexceptionsL’OréalCanada’sbrandforecastsarenotallaggregatedupintooneforecastlimitingvisibilityanddatasharingL’OréalCanadadoesnothavesimulationor“whatif”capabilitiesManydisparatetoolsarebeingusedtofacilitateforecasting-Excel,Valo,SAPandOutilsGestion.Interfaceshavebeenbuiltbetweenthevarioustoolsandsystems,butmanualverificationisrequiredandthecurrenttechnologystilldoesnotmeetL’Oréal’srequirementsPOS,Nielsen,customerinformation,promotionalandadvertisinginformationarenotallintegratedinonecentralrepositoryOpportunityProcessRedesignSpendtimeforecastingproductsthatgivethehighestreturn.Notallproductlinesbenefitfromincreasedattention.Focusonhighmargin,lowvolume,bigticketitems,highprofileitemsanditemswithcomplementstomaximizeprofitabilityCommunicateandreconcileforecastassumptionsbyconductingaformalreviewaftereachplanningcyclewithallstakeholders.ReportforecasterrorandmodifyassumptionsasappropriateForecastingTool/BWImplementingaForecastingtoolwillenabletheautomaticgenerationofabaselineforecastbasedonsaleshistoryandadditionalvariables.Mostpackagesallowuserstoselectastatisticalmodel,enablethesystemtodeterminethemodelwiththegreatestfitoremployacompositemodelTheforecastingtoolselectedshouldallowforthegenerationofalertsbasedonpredefinedtolerances,highlightingtheproductsthatrequirefurtherconsiderationandmanualinterventionProductsshouldbereviewedtodeterminewhichonesarecriticalorhighmargintoplaninaForecastingtool,whilenon-criticalorstagnantproductsmaybeplannedinSAPR/3Theforecastingtoolselectedshouldprovide“WhatIf”simulationcapabilitiestodemonstratetheimpactofavariablechange(e.g.pricechange)CoordinatedatacollectionforallavailablesourcesandhouseitinacentralrepositorysuchasSAPBusinessWarehouse7DemandPlanning–IssuesandOpportunitiesIssuesOpportunityPeopleEnsurethePlanningTeamisCross-FunctionalandCross-Trained:L’OréalwillneedtoevaluatetheirresourcesskillsanddetermineifadditionalresourcesarerequiredtogainforecastingexpertiseStatisticalproficiencyandsystemexpertiseshouldbebalancedwithindustry,companyandproductknowledgeCross-trainingsharpensskills,broadensperspectivesandimprovescommunicationCreateincentivestoimprovetheaccuracyofforecasts:EstablishforecastaccuracygoalsEstablishcompensationstructureMonitorandreviewcongruenceofgoalstorewardsThiswillremovetrade-offsbetweenforecastaccuracyandperformanceagainstforecast,leverageskeyinformationandhelpseliminatebiasesL’OréalCanadahasstartedt