主要绩效显示Design文件(1)

KeyPerformanceIndicatorsDesignDocumentKPIFORMATJFMAMJJASONDDATATABLEFORINFOTOTALLOGISTICSCOSTBREAKDOWN•PAYROLL•SUPPLIES•FREIGHT•INVENTORYCC•OCCUPANCYCOSTSKPITITLECHARTDATATABLECHARTSAREAVAILABLE•INSUMMARYFORALLOFLOGISTICS/AGI•BYFACILITY/CUSSCHARTSAREPRESENTEDINTWOLAYOUTS•SUMMARYCHARTSWITHRELATEDKPI’S,BYKPIGROUPING•BYKPIWITHFACILITY/CUSSANDTOTALINFOLASTYRCOMMENTBUDGET/PLANCostsïCostsasapercentageofSalesïCostBreakdownïPayrollBreakdown(OT,Regular,Admin)ïFreightïInventoryCarryingcostïShipmentBreakdown(Rush/Regular)ProductivityïCostperOrderLineïCostperInvoiceïLinesperhourïDiscrepanciesasaPercentageofOrderLinesïManpowerBreakdown(ParttimevsFullTime)??ïTurnoverLogisticsKeyPerformanceIndicatorGroupingsNOTE:Availableonly15daysaftermonthend;NotavailableweeklyAvailableTodayNotavailableTodaySomeInfoAvailableTodayLEGENDLogisticsKeyPerformanceIndicatorsInventoryïTotalInventoryDollarsïWeeksofSupplyïTurnsïInventoryAccuracyïReturnstoAGIïReturnstoSuppliersServiceLevelsïPerfectOrderInboundïPerfectOrderOutboundEfficiencyïDCSpaceUtilizationïManpowerUtilizationïOutboundCubeUtilizationServiceLevel(FillRateandontime)OnlyFillRateOnlyLogisticsCostsJFMAMJJASONDDATATABLEFORINFOTOTALLOGISTICSCOSTASA%OFSALESJFMAMJJASONDDATATABLEFORINFOTOTALLOGISTICSCOSTBREAKDOWNJFMAMJJASONDDATATABLEFORINFOSHIPMENTSJFMAMJJASONDDATATABLEFORINFOPAYROLLJFMAMJJASONDDATATABLEFORINFOFREIGHTJFMAMJJASONDDATATABLEFORINFOINVENTORY•PAYROLL•SUPPLIES•FREIGHT•INVENTORYCC•OCCUPANCYCOSTS•RUSH•REGULAR•OVERTIME•REGULAR•ADMIN•Courier•Carrierdctobranch•carrierdctocustomer•carrierbranchtocustomer•BRANCH•DC•SUPPLIERALLOFTHEABOVEAVAILABLEFORTOTALLOGISTICSANDBYFACILITY/CUSSLogisticsProductivityJFMAMJJASONDDATATABLEFORINFOLOGISTICSCOSTPERORDERLINEJFMAMJJASONDDATATABLEFORINFOLOGISTICSCOSTPERINVOICEJFMAMJJASONDDATATABLEFORINFOMANPOWERBREAKDOWNJFMAMJJASONDDATATABLEFORINFOLINESPERHOURJFMAMJJASONDDATATABLEFORINFOTURNOVERJFMAMJJASONDDATATABLEFORINFODISCREPANCIES•PARTTIME•FULLTIME•OVER•SHORT•DAMAGEDALLOFTHEABOVEAVAILABLEFORTOTALLOGISTICSANDBYFACILITY/CUSSLogisticsInventoryJFMAMJJASONDDATATABLEFORINFOINVENTORYJFMAMJJASONDDATATABLEFORINFOWEEKSOFSUPPLYBREAKDOWNJFMAMJJASONDDATATABLEFORINFOTURNSJFMAMJJASONDDATATABLEFORINFOINVENTORYACCURACYJFMAMJJASONDDATATABLEFORINFORETURNSTOAGIJFMAMJJASONDDATATABLEFORINFORETURNSTOSUPPLIERS•0TO4•5TO15•17TO26•27TO52•GREATERTHAN52ALLOFTHEABOVEAVAILABLEFORTOTALLOGISTICSANDBYFACILITY/CUSS•DC•BRANCHLogisticsServiceLevelJFMAMJJASONDDATATABLEFORINFOInboundPerfectOrderJFMAMJJASONDDATATABLEFORINFOOutboundPerfectOrder•PAYROLL•SUPPLIES•FREIGHT•INVENTORYCC•OCCUPANCYCOSTSALLOFTHEABOVEAVAILABLEFORTOTALLOGISTICSANDBYFACILITY/CUSS12340%10%20%30%40%50%60%70%80%90%100%1234WeeksPurchaseOrderInvoiceErrorsShipNoticeErrorsClaimsNotOnTimeLineFillErrorPerfectOrderAGIIMPACTSupplierScheduleAccuracy69%%POChanges45%SUPPLIERDETAILSPOvsPhysicalReceipt72%AGIEFFECTIVENESS%DRPExceptionsHandled82%12340%10%20%30%40%50%60%70%80%90%100%1234StoreOrderLeftonDockStandingOrderClaimsNotArrivingatStoreonTimeRecyclesNotScheduledOnTimeLineFillErrorPerfectOrderFORECASTForecastError(10wk)63%BranchORDERSStandingOrders+Recycles$20MTRANSPORT%ArrivalatBranchonTime37%O,S&D&RETURNSO,S&D$$1MReturns$$2MLogisticsEfficiencyJFMAMJJASONDDATATABLEFORINFODCUTILIZATIONJFMAMJJASONDDATATABLEFORINFOMANPOWERUTILIZATIONJFMAMJJASONDDATATABLEFORINFOOUTBOUNDSHIPMENTCUBEUTILIZATIONALLOFTHEABOVEAVAILABLEFORTOTALLOGISTICSANDBYFACILITY/CUSSLogisticsInventoryDetail-WeeksofSupplyJFMAMJJASONDDATATABLEFORINFOJFMAMJJASONDDATATABLEFORINFOEDMONTONINDUSTRIALJFMAMJJASONDDATATABLEFORINFOEDMONTONBODYSHOPJFMAMJJASONDDATATABLEFORINFOSASKATOONJFMAMJJASONDDATATABLEFORINFOWINNIPEGJFMAMJJASONDDATATABLEFORINFORICHMONDHILLALLOFTHEABOVEAVAILABLEFORTOTALLOGISTICSANDBYFACILITY/CUSS•0TO4•5TO15•17TO26•27TO52•GREATERTHAN52•0TO4•5TO15•17TO26•27TO52•GREATERTHAN52TOTALLOGISTICSWEEKSOFSUPPLYBREAKDOWN•0TO4•5TO15•17TO26•27TO52•GREATERTHAN52•0TO4•5TO15•17TO26•27TO52•GREATERTHAN52•0TO4•5TO15•17TO26•27TO52•GREATERTHAN52•0TO4•5TO15•17TO26•27TO52•GREATERTHAN52SupplierAllAllEdmontonSaskatoonWinnipegRichmondHillDropDownBoxforPOPerfectOrderRatio(Rolling53weeks)DCWorkArea12340%10%20%30%40%50%60%70%80%90%100%1234WeeksPurchaseOrderInvoiceErrorsShipNoticeErrorsClaimsNotOnTimeLineFillErrorPerfectOrderEdmontonBySupplierBuyerByProductgroupProductGroupBuyerBySupplierBySKUImpactonSupplierPerformanceSupplierScheduleAccuracy%POChangesPO’snotAdheringtoLeadTime%ManualPurchaseOrders%ChangeinConsumerUnits20104WeeksPriortoPODueDateAllProductGroupsBuyerSupplierSupplierPerformanceDetailsPOvsASNQuantityPOvsPhysicalReceiptQuantityOverages(AGIReceipts)Shortages(AGIReceipts)Damages(AGIReceipts)PercentageofConsumerUnitsWeeks12AllIndustrialSafetyFleetBuyerSupplier53Effectiveness%DRPExceptionshandledwithinTimeframe%O,S&D%HeldonReceiptPercentageofConsumerUnitsWeeks12AllIndustrialSafetyFleetBuyerSupplier53Branch/CustomerOrderAllAllEdmontonRichmondHillEAP’sWesternBranchesCentralBranchesEasternBranchesIndustrialSafetyFleetDropDownBoxforBranchOrderPerfectOrderRatioDCWorkAre