SCM KPI体系设计
- 1. Key Performance Indicators Design Document
- 2. KPI FORMATJ F M A M J J A S O N D DATA TABLE FOR INFOTOTAL LOGISTICS COST BREAKDOWNPAYROLL SUPPLIES FREIGHT INVENTORY CC OCCUPANCY COSTSKPI TITLECHARTDATA TABLECHARTS ARE AVAILABLE IN SUMMARY FOR ALL OF LOGISTICS/AGI BY FACILITY/CUSSCHARTS ARE PRESENTED IN TWO LAYOUTS SUMMARY CHARTS WITH RELATED KPI’S, BY KPI GROUPING BY KPI WITH FACILITY/CUSS AND TOTAL INFOLAST YRCOMMENTBUDGET/PLAN
- 3. Costs Costs as a percentage of Sales Cost Breakdown Payroll Breakdown (OT, Regular, Admin) Freight Inventory Carrying cost Shipment Breakdown (Rush/Regular) Productivity Cost per Order Line Cost per Invoice Lines per hour Discrepancies as a Percentage of Order Lines Manpower 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 LEGEND
- 4. Logistics Key Performance IndicatorsInventory Total Inventory Dollars Weeks of Supply Turns Inventory Accuracy Returns to AGI Returns to Suppliers Service Levels Perfect Order Inbound Perfect Order Outbound Efficiency DC Space Utilization Manpower Utilization Outbound Cube Utilization Service Level (Fill Rate and on time) OnlyFill Rate Only
- 5. Logistics CostsJ F M A M J J A S O N D DATA TABLE FOR INFOTOTAL LOGISTICS COST AS A % OF SALESJ F M A M J J A S O N D DATA TABLE FOR INFOTOTAL LOGISTICS COST BREAKDOWNJ F M A M J J A S O N D DATA TABLE FOR INFOSHIPMENTSJ F M A M J J A S O N D DATA TABLE FOR INFOPAYROLLJ F M A M J J A S O N D DATA TABLE FOR INFOFREIGHTJ F M A M J J A S O N D DATA TABLE FOR INFOINVENTORYPAYROLL SUPPLIES FREIGHT INVENTORY CC OCCUPANCY COSTSRUSH REGULAROVERTIME REGULAR ADMINCourier Carrier dc to branch carrier dc to customer carrier branch to customerBRANCH DC SUPPLIERALL OF THE ABOVE AVAILABLE FOR TOTAL LOGISTICS AND BY FACILITY/CUSS
- 6. Logistics ProductivityJ F M A M J J A S O N D DATA TABLE FOR INFOLOGISTICS COST PER ORDER LINEJ F M A M J J A S O N D DATA TABLE FOR INFOLOGISTICS COST PER INVOICEJ F M A M J J A S O N D DATA TABLE FOR INFOMANPOWER BREAKDOWNJ F M A M J J A S O N D DATA TABLE FOR INFOLINES PER HOURJ F M A M J J A S O N D DATA TABLE FOR INFOTURNOVERJ F M A M J J A S O N D DATA TABLE FOR INFODISCREPANCIES PART TIME FULL TIMEOVER SHORT DAMAGEDALL OF THE ABOVE AVAILABLE FOR TOTAL LOGISTICS AND BY FACILITY/CUSS
- 7. Logistics InventoryJ F M A M J J A S O N D DATA TABLE FOR INFOINVENTORYJ F M A M J J A S O N D DATA TABLE FOR INFOWEEKS OF SUPPLY BREAKDOWNJ F M A M J J A S O N D DATA TABLE FOR INFOTURNSJ F M A M J J A S O N D DATA TABLE FOR INFOINVENTORY ACCURACYJ F M A M J J A S O N D DATA TABLE FOR INFORETURNS TO AGIJ F M A M J J A S O N D DATA TABLE FOR INFORETURNS TO SUPPLIERS0 TO 4 5 TO 15 17 TO 26 27 TO 52 GREATER THAN 52ALL OF THE ABOVE AVAILABLE FOR TOTAL LOGISTICS AND BY FACILITY/CUSSDC BRANCH
- 8. Logistics Service LevelJ F M A M J J A S O N D DATA TABLE FOR INFOInbound Perfect OrderJ F M A M J J A S O N D DATA TABLE FOR INFOOutbound Perfect OrderPAYROLL SUPPLIES FREIGHT INVENTORY CC OCCUPANCY COSTSALL OF THE ABOVE AVAILABLE FOR TOTAL LOGISTICS AND BY FACILITY/CUSSAGI IMPACT Supplier Schedule Accuracy 69% % PO Changes 45% SUPPLIER DETAILS PO vs Physical Receipt 72% AGI EFFECTIVENESS % DRP Exceptions Handled 82%FORECAST Forecast Error (10wk) 63% Branch ORDERS Standing Orders + Recycles $20M TRANSPORT % Arrival at Branch on Time 37% O,S & D & RETURNS O,S & D $ $1M Returns $ $2M
- 9. Logistics EfficiencyJ F M A M J J A S O N D DATA TABLE FOR INFODC UTILIZATIONJ F M A M J J A S O N D DATA TABLE FOR INFOMANPOWER UTILIZATIONJ F M A M J J A S O N D DATA TABLE FOR INFOOUTBOUND SHIPMENT CUBE UTILIZATIONALL OF THE ABOVE AVAILABLE FOR TOTAL LOGISTICS AND BY FACILITY/CUSS
- 10. Logistics Inventory Detail - Weeks of SupplyJ F M A M J J A S O N D DATA TABLE FOR INFOJ F M A M J J A S O N D DATA TABLE FOR INFOEDMONTON INDUSTRIALJ F M A M J J A S O N D DATA TABLE FOR INFOEDMONTON BODY SHOPJ F M A M J J A S O N D DATA TABLE FOR INFOSASKATOONJ F M A M J J A S O N D DATA TABLE FOR INFOWINNIPEGJ F M A M J J A S O N D DATA TABLE FOR INFORICHMOND HILLALL OF THE ABOVE AVAILABLE FOR TOTAL LOGISTICS AND BY FACILITY/CUSS0 TO 4 5 TO 15 17 TO 26 27 TO 52 GREATER THAN 520 TO 4 5 TO 15 17 TO 26 27 TO 52 GREATER THAN 52TOTAL LOGISTICS WEEKS OF SUPPLY BREAKDOWN0 TO 4 5 TO 15 17 TO 26 27 TO 52 GREATER THAN 520 TO 4 5 TO 15 17 TO 26 27 TO 52 GREATER THAN 520 TO 4 5 TO 15 17 TO 26 27 TO 52 GREATER THAN 520 TO 4 5 TO 15 17 TO 26 27 TO 52 GREATER THAN 52
- 11. SupplierAllAll Edmonton Saskatoon Winnipeg Richmond HillDrop Down Box for PO Perfect Order Ratio (Rolling 53 weeks)DC Work Area EdmontonBy Supplier Buyer By Product group Product GroupBuyerBy Supplier By SKU
- 12. Impact on Supplier PerformanceSupplier Schedule Accuracy% PO Changes PO’s not Adhering to Lead Time% Manual Purchase Orders% Change in Consumer Units20104Weeks Prior to PO Due DateAllProduct GroupsBuyer Supplier
- 13. Supplier Performance DetailsPO vs ASN QuantityPO vs Physical Receipt QuantityOverages (AGI Receipts)Shortages( AGI Receipts)Damages (AGI Receipts)Percentage of Consumer UnitsWeeks12AllIndustrial Safety FleetBuyer Supplier53
- 14. Effectiveness% DRP Exceptions handled within Timeframe% O,S & D% Held on ReceiptPercentage of Consumer UnitsWeeks12AllIndustrial Safety FleetBuyer Supplier53
- 15. Branch / Customer OrderAllAll Edmonton Richmond Hill EAP’s Western Branches Central Branches Eastern Branches Industrial Safety FleetDrop Down Box for Branch Order Perfect Order RatioDC Work Area BranchProduct GroupsEdmontonBuyer By Product ClassCentral BranchesWeston Road Yonge & SteelesBuyerBy SKU
- 16. Branch Order / Forecast DetailsForecastPromo Orders HoldingBack OrdersRegular OrdersPromo Orders DueRecycled OrdersQuantity, in Consumer UnitsWeeksAllIndustrial Safety FleetBuyer Product ClassSKU1234553
- 17. Back Order Aging TableRegular $Promotional $1 week or less>1 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 Safety FleetBuyer Product ClassSKUAllRichmond Hill Edmonton EAPWork AreaSKU
- 18. Physical Returns, by TypePercentage of Consumer Units SoldWeeksDamage ReturnsConcealed DamageDefectiveNew MerchandiseAllIndustrial Safety FleetSupplier Product ClassSKURecalls1253
- 19. O,S&D (Branch to HQ & Customer to HQ)Quantity, in Consumer UnitsWeeksDamagedOveragesShortagesAllAJ Richmond Hill Edmonton MontrealWork AreaAisle12753AllCentral East WestBranch
- 20. Operations Planning CentreAll Edmonton Richmond Hill Winnipeg Saskatoon DC Work Area BranchAllAllAllFleet Common Carrier Rail ContainerAllDC Capacity Utilization506070809010011012013014015040414243Period‘000 CubeAvailablePlannedActual.....92%94%96%93%Total DC Costs506070809010011012013014015040414243Period‘000 Cube1st PlanFinal PlanActual....(-8%)+8%(-4%)(-10%).Trailer Capacity Utilization506070809010011012013014015040414243Period‘000 CubeAvailablePlannedActual.....92%94%96%93%Total Transportation Costs506070809010011012013014015040414243Period‘000 Cube1st PlanFinal PlanActual....(-8%)+8%(-4%)(-10%).
- 21. Employee RetentionDistribution Logistics TransportationIndustrial Safety FleetAllLogistics
该用户的其他文档
相关PPT