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

1、Key Performance IndicatorsDesign DocumentKPI FORMATJ F M A M J J A S O N DDATA TABLE FOR INFOTOTAL LOGISTICS COST BREAKDOWNPAYROLLSUPPLIESFREIGHTINVENTORY CCOCCUPANCY COSTSKPI TITLECHARTDATA TABLECHARTS ARE AVAILABLEIN SUMMARY FOR ALL OF LOGISTICS/AGIBY FACILITY/CUSSCHARTS ARE PRESENTED IN TWO LAYOU

2、TSSUMMARY CHARTS WITH RELATED KPIS, BY KPI GROUPINGBY KPI WITH FACILITY/CUSS AND TOTAL INFOLAST YRCOMMENTBUDGET/PLANCostsCosts as a percentage of Sales Cost BreakdownPayroll Breakdown (OT, Regular, Admin)FreightInventory Carrying costShipment Breakdown (Rush/Regular)ProductivityCost per Order LineCo

3、st per InvoiceLines per hourDiscrepancies as a Percentage of Order LinesManpower Breakdown(Part time vs Full Time)?TurnoverLogistics Key Performance Indicator GroupingsNOTE: Available only 15 days after month end; Not available weekly Available Today Not available Today Some InfoAvailable Today LEGE

4、NDLogistics Key Performance IndicatorsInventoryTotal Inventory DollarsWeeks of SupplyTurnsInventory AccuracyReturns to AGIReturns to SuppliersService LevelsPerfect Order InboundPerfect Order OutboundEfficiencyDC Space UtilizationManpower UtilizationOutbound Cube Utilization Service Level (Fill Rate

5、and on time) OnlyFill Rate Only Logistics CostsJ F M A M J J A S O N DDATA TABLE FOR INFOTOTAL LOGISTICS COST AS A % OF SALESJ F M A M J J A S O N DDATA TABLE FOR INFOTOTAL LOGISTICS COST BREAKDOWNJ F M A M J J A S O N DDATA TABLE FOR INFOSHIPMENTSJ F M A M J J A S O N DDATA TABLE FOR INFOPAYROLLJ F

6、 M A M J J A S O N DDATA TABLE FOR INFOFREIGHTJ F M A M J J A S O N DDATA TABLE FOR INFOINVENTORYPAYROLLSUPPLIESFREIGHTINVENTORY CCOCCUPANCY COSTSRUSHREGULAROVERTIMEREGULARADMINCourierCarrier dc to branchcarrier dc to customercarrier branch to customerBRANCHDCSUPPLIERALL OF THE ABOVE AVAILABLE FOR T

7、OTAL LOGISTICS AND BY FACILITY/CUSSLogistics ProductivityJ F M A M J J A S O N DDATA TABLE FOR INFOLOGISTICS COST PER ORDER LINEJ F M A M J J A S O N DDATA TABLE FOR INFOLOGISTICS COST PER INVOICEJ F M A M J J A S O N DDATA TABLE FOR INFOMANPOWER BREAKDOWNJ F M A M J J A S O N DDATA TABLE FOR INFOLI

8、NES PER HOURJ F M A M J J A S O N DDATA TABLE FOR INFOTURNOVERJ F M A M J J A S O N DDATA TABLE FOR INFODISCREPANCIES PART TIMEFULL TIMEOVERSHORTDAMAGEDALL OF THE ABOVE AVAILABLE FOR TOTAL LOGISTICS AND BY FACILITY/CUSSLogistics InventoryJ F M A M J J A S O N DDATA TABLE FOR INFOINVENTORYJ F M A M J

9、 J A S O N DDATA TABLE FOR INFOWEEKS OF SUPPLY BREAKDOWNJ F M A M J J A S O N DDATA TABLE FOR INFOTURNSJ F M A M J J A S O N DDATA TABLE FOR INFOINVENTORY ACCURACYJ F M A M J J A S O N DDATA TABLE FOR INFORETURNS TO AGIJ F M A M J J A S O N DDATA TABLE FOR INFORETURNS TO SUPPLIERS0 TO 45 TO 1517 TO

10、2627 TO 52GREATER THAN 52ALL OF THE ABOVE AVAILABLE FOR TOTAL LOGISTICS AND BY FACILITY/CUSSDC BRANCHLogistics Service LevelJ F M A M J J A S O N DDATA TABLE FOR INFOInbound Perfect OrderJ F M A M J J A S O N DDATA TABLE FOR INFOOutbound Perfect OrderPAYROLLSUPPLIESFREIGHTINVENTORY CCOCCUPANCY COSTS

11、ALL OF THE ABOVE AVAILABLE FOR TOTAL LOGISTICS AND BY FACILITY/CUSSAGI IMPACTSupplier Schedule Accuracy 69% PO Changes 45%SUPPLIER DETAILS PO vs Physical Receipt 72%AGI EFFECTIVENESS% DRP Exceptions Handled 82%FORECASTForecast Error (10wk) 63% Branch ORDERSStanding Orders + Recycles $20MTRANSPORT% A

12、rrival at Branch on Time 37%O,S & D & RETURNSO,S & D $ $1MReturns $ $2MLogistics EfficiencyJ F M A M J J A S O N DDATA TABLE FOR INFODC UTILIZATIONJ F M A M J J A S O N DDATA TABLE FOR INFOMANPOWER UTILIZATIONJ F M A M J J A S O N DDATA TABLE FOR INFOOUTBOUND SHIPMENTCUBE UTILIZATIONALL OF THE ABOVE

13、 AVAILABLE FOR TOTAL LOGISTICS AND BY FACILITY/CUSSLogistics Inventory Detail - Weeks of SupplyJ F M A M J J A S O N DDATA TABLE FOR INFOJ F M A M J J A S O N DDATA TABLE FOR INFOEDMONTON INDUSTRIALJ F M A M J J A S O N DDATA TABLE FOR INFOEDMONTON BODY SHOPJ F M A M J J A S O N DDATA TABLE FOR INFO

14、SASKATOONJ F M A M J J A S O N DDATA TABLE FOR INFOWINNIPEGJ F M A M J J A S O N DDATA TABLE FOR INFORICHMOND HILLALL OF THE ABOVE AVAILABLE FOR TOTAL LOGISTICS AND BY FACILITY/CUSS0 TO 45 TO 1517 TO 2627 TO 52GREATER THAN 520 TO 45 TO 1517 TO 2627 TO 52GREATER THAN 52TOTAL LOGISTICS WEEKS OF SUPPLY

15、 BREAKDOWN0 TO 45 TO 1517 TO 2627 TO 52GREATER THAN 520 TO 45 TO 1517 TO 2627 TO 52GREATER THAN 520 TO 45 TO 1517 TO 2627 TO 52GREATER THAN 520 TO 45 TO 1517 TO 2627 TO 52GREATER THAN 52SupplierAllAllEdmontonSaskatoonWinnipegRichmond HillDrop Down Box for PO Perfect Order Ratio (Rolling 53 weeks)DC

16、Work AreaEdmontonBy SupplierBuyerBy Product groupProduct GroupBuyerBy SupplierBy SKUImpact on Supplier PerformanceSupplier Schedule Accuracy% PO Changes POs not Adhering to Lead Time% Manual Purchase Orders% Change in Consumer Units20104Weeks Prior to PO Due DateAllProductGroupsBuyerSupplierSupplier

17、 Performance DetailsPO vs ASN QuantityPO vs Physical Receipt QuantityOverages (AGI Receipts)Shortages( AGI Receipts)Damages (AGI Receipts)Percentage of Consumer UnitsWeeks12AllIndustrial SafetyFleetBuyerSupplier53Effectiveness% DRP Exceptions handled within Timeframe% O,S & D% Held on ReceiptPercent

18、age of Consumer UnitsWeeks12AllIndustrial SafetyFleetBuyerSupplier53Branch / Customer OrderAllAllEdmontonRichmond HillEAPsWestern BranchesCentral BranchesEastern BranchesIndustrial SafetyFleetDrop Down Box for Branch Order Perfect Order RatioDC Work AreaBranchProduct GroupsEdmontonBuyerBy Product Cl

19、assCentral BranchesWeston RoadYonge & SteelesBuyerBy SKUBranch Order / Forecast DetailsForecastPromo Orders HoldingBack OrdersRegular OrdersPromo Orders DueRecycled OrdersQuantity, in Consumer UnitsWeeksAllIndustrial SafetyFleetBuyerProduct ClassSKU1234553Back Order Aging TableRegular $Promotional $

20、1 week or less1 week to 2 weeksPromotional CubeRegular Cube2 week to 4 weeks4 week to 8 weeks8 week to 16 weeks10.7 .21 10.6 .43 8.2 .167.6 .29 12.2 .27 16.6 .56 4.8 .10 6.6 .16 2.2 .09 1.6 .06 AllIndustrial SafetyFleetBuyerProduct ClassSKUAllRichmond HillEdmontonEAPWorkAreaSKUPhysical Returns, by TypePercentage of Consumer Units SoldWeeksDamage ReturnsConcealed DamageDefectiveNew MerchandiseAllIndustrial SafetyFleetSupplierProduct ClassSKURecalls1253O,S&D (Branch to HQ & Customer to HQ)Quantity, in Consumer UnitsWeeksDamagedOveragesShortagesAllAJRichmond HillEdmontonMontrealWork AreaAis