主要績效顯示Design文件

KeyPerformanceIndicatorsDesignDocument第一頁，共二十二頁。KPIFORMATJFMAMJJASONDDATATABLEFORINFOTOTALLOGISTICSCOSTBREAKDOWNPAYROLLSUPPLIESFREIGHTINVENTORYCCOCCUPANCYCOSTSKPITITLECHARTDATATABLECHARTSAREAVAILABLEINSUMMARYFORALLOFLOGISTICS/AGIBYFACILITY/CUSSCHARTSAREPRESENTEDINTWOLAYOUTSSUMMARYCHARTSWITHRELATEDKPI’S,BYKPIGROUPINGBYKPIWITHFACILITY/CUSSANDTOTALINFOLASTYRCOMMENTBUDGET/PLAN第二頁，共二十二頁。CostsCostsasapercentageofSalesCostBreakdownPayrollBreakdown(OT,Regular,Admin)FreightInventoryCarryingcostShipmentBreakdown(Rush/Regular)ProductivityCostperOrderLineCostperInvoiceLinesperhourDiscrepanciesasaPercentageofOrderLinesManpowerBreakdown(ParttimevsFullTime)??TurnoverLogisticsKeyPerformanceIndicatorGroupingsNOTE:Availableonly15daysaftermonthend;Notavailableweekly

AvailableToday

NotavailableToday

SomeInfoAvailableToday

LEGEND第三頁，共二十二頁。LogisticsKeyPerformanceIndicatorsInventoryTotalInventoryDollarsWeeksofSupplyTurnsInventoryAccuracyReturnstoAGIReturnstoSuppliersServiceLevelsPerfectOrderInboundPerfectOrderOutboundEfficiencyDCSpaceUtilizationManpowerUtilizationOutboundCubeUtilization

ServiceLevel(FillRateandontime)OnlyFillRateOnly

第四頁，共二十二頁。LogisticsCostsJFMAMJJASONDDATATABLEFORINFOTOTALLOGISTICSCOSTASA%OFSALESJFMAMJJASONDDATATABLEFORINFOTOTALLOGISTICSCOSTBREAKDOWNJFMAMJJASONDDATATABLEFORINFOSHIPMENTSJFMAMJJASONDDATATABLEFORINFOPAYROLLJFMAMJJASONDDATATABLEFORINFOFREIGHTJFMAMJJASONDDATATABLEFORINFOINVENTORYPAYROLLSUPPLIESFREIGHTINVENTORYCCOCCUPANCYCOSTSRUSHREGULAROVERTIMEREGULARADMINCourierCarrierdctobranchcarrierdctocustomercarrierbranchtocustomerBRANCHDCSUPPLIERALLOFTHEABOVEAVAILABLEFORTOTALLOGISTICSANDBYFACILITY/CUSS第五頁，共二十二頁。LogisticsProductivityJFMAMJJASONDDATATABLEFORINFOLOGISTICSCOSTPERORDERLINEJFMAMJJASONDDATATABLEFORINFOLOGISTICSCOSTPERINVOICEJFMAMJJASONDDATATABLEFORINFOMANPOWERBREAKDOWNJFMAMJJASONDDATATABLEFORINFOLINESPERHOURJFMAMJJASONDDATATABLEFORINFOTURNOVERJFMAMJJASONDDATATABLEFORINFODISCREPANCIESPARTTIMEFULLTIMEOVERSHORTDAMAGEDALLOFTHEABOVEAVAILABLEFORTOTALLOGISTICSANDBYFACILITY/CUSS第六頁，共二十二頁。LogisticsInventoryJFMAMJJASONDDATATABLEFORINFOINVENTORYJFMAMJJASONDDATATABLEFORINFOWEEKSOFSUPPLYBREAKDOWNJFMAMJJASONDDATATABLEFORINFOTURNSJFMAMJJASONDDATATABLEFORINFOINVENTORYACCURACYJFMAMJJASONDDATATABLEFORINFORETURNSTOAGIJFMAMJJASONDDATATABLEFORINFORETURNSTOSUPPLIERS0TO45TO1517TO2627TO52GREATERTHAN52ALLOFTHEABOVEAVAILABLEFORTOTALLOGISTICSANDBYFACILITY/CUSSDCBRANCH第七頁，共二十二頁。LogisticsServiceLevelJFMAMJJASONDDATATABLEFORINFOInboundPerfectOrderJFMAMJJASONDDATATABLEFORINFOOutboundPerfectOrderPAYROLLSUPPLIESFREIGHTINVENTORYCCOCCUPANCYCOSTSALLOFTHEABOVEAVAILABLEFORTOTALLOGISTICSANDBYFACILITY/CUSSAGIIMPACTSupplierScheduleAccuracy 69%%POChanges 45% SUPPLIERDETAILS

POvsPhysicalReceipt 72%AGIEFFECTIVENESS%DRPExceptionsHandled 82%FORECASTForecastError(10wk) 63%BranchORDERSStandingOrders+Recycles $20MTRANSPORT%ArrivalatBranchonTime 37%O,S&D&RETURNSO,S&D$ $1MReturns$ $2M第八頁，共二十二頁。LogisticsEfficiencyJFMAMJJASONDDATATABLEFORINFODCUTILIZATIONJFMAMJJASONDDATATABLEFORINFOMANPOWERUTILIZATIONJFMAMJJASONDDATATABLEFORINFOOUTBOUNDSHIPMENTCUBEUTILIZATIONALLOFTHEABOVEAVAILABLEFORTOTALLOGISTICSANDBYFACILITY/CUSS第九頁，共二十二頁。LogisticsInventoryDetail-WeeksofSupplyJFMAMJJASONDDATATABLEFORINFOJFMAMJJASONDDATATABLEFORINFOEDMONTONINDUSTRIALJFMAMJJASONDDATATABLEFORINFOEDMONTONBODYSHOPJFMAMJJASONDDATATABLEFORINFOSASKATOONJFMAMJJASONDDATATABLEFORINFOWINNIPEGJFMAMJJASONDDATATABLEFORINFORICHMONDHILLALLOFTHEABOVEAVAILABLEFORTOTALLOGISTICSANDBYFACILITY/CUSS0TO45TO1517TO2627TO52GREATERTHAN520TO45TO1517TO2627TO52GREATERTHAN52TOTALLOGISTICSWEEKSOFSUPPLYBREAKDOWN0TO45TO1517TO2627TO52GREATERTHAN520TO45TO1517TO2627TO52GREATERTHAN520TO45TO1517TO2627TO52GREATERTHAN520TO45TO1517TO2627TO52GREATERTHAN52第十頁，共二十二頁。SupplierAllAllEdmontonSaskatoonWinnipegRichmondHillDropDownBoxforPOPerfectOrderRatio(Rolling53weeks)DCWorkAreaEdmontonBySupplierBuyerByProductgroupProductGroupBuyerBySupplierBySKU第十一頁，共二十二頁。ImpactonSupplierPerformanceSupplierScheduleAccuracy%POChangesPO’snotAdheringtoLeadTime%ManualPurchaseOrders%ChangeinConsumerUnits20104WeeksPriortoPODueDateAllProductGroupsBuyerSupplier第十二頁，共二十二頁。SupplierPerformanceDetailsPOvsASNQuantityPOvsPhysicalReceiptQuantityOverages(AGIReceipts)Shortages(AGIReceipts)Damages(AGIReceipts)PercentageofConsumerUnitsWeeks12AllIndustrialSafetyFleetBuyerSupplier53第十三頁，共二十二頁。Effectiveness%DRPExceptionshandledwithinTimeframe%O,S&D%HeldonReceiptPercentageofConsumerUnitsWeeks12AllIndustrialSafetyFleetBuyerSupplier53第十四頁，共二十二頁。Branch/CustomerOrderAllAllEdmontonRichmondHillEAP’sWesternBranchesCentralBranchesEasternBranchesIndustrialSafetyFleetDropDownBoxforBranchOrderPerfectOrderRatioDCWorkAreaBranchProductGroupsEdmontonBuyerByProductClassCentralBranchesWestonRoadYonge&SteelesBuyerBySKU第十五頁，共二十二頁。BranchOrder/ForecastDetailsForecastPromoOrdersHoldingBackOrdersRegularOrdersPromoOrdersDueRecycledOrdersQuantity,inConsumerUnitsWeeksAllIndustrialSafetyFleetBuyerProductClassSKU1234553第十六頁，共二十二頁。BackOrderAgingTableRegular$Promotional$1weekorless>1weekto2weeksPromotionalCubeRegularCube2weekto4weeks4weekto8weeks8weekto16weeks10.7.2110.6.438.2.167.6.2912.2.2716.6.564.8.106.6.162.2.091.6.06AllIndustrialSafetyFleetBuyerProductClassSKUAllRichmondHillEdmontonEAPWorkAreaSKU第十七頁，共二十二頁。PhysicalReturns,byTypePercentageofConsumerUnitsSoldWeeksDamageReturnsConcealedDamageDefectiveNewMerchandiseAllIndustrialSafetyFleetSupplierProductClassSKURecalls1253第十八頁，共二十二頁。O,S&D(BranchtoHQ&CustomertoHQ)Quantity,inConsumerUnitsWeeksDamagedOveragesShortagesAllAJRichmondHillEdmontonMontrealWorkAreaAisle12753AllCentralEastWestBranch第十九頁，共二十二頁。OperationsPlanningCentreAllEdmontonRichmondHillWinnipegSaskatoonDCWorkAreaBranchAllAllAllFleetCommonCarrierRailContainerAllDCCapacityUtilization506070809010011012013014015040414243Period‘000CubeAvailablePlannedActual.....92%94%96%93%TotalDCCosts5060708090100110120130140