Key Performance Indicators

1

• Key Performance Indicators
• Design Document

2
KPI FORMAT
KPI TITLE
TOTAL LOGISTICS COST BREAKDOWN
LAST YR

• PAYROLL
• SUPPLIES
• FREIGHT
• INVENTORY CC
• OCCUPANCY COSTS

BUDGET/PLAN
CHART
DATA TABLE
J F M A M J J A S O N D DATA TABLE FOR INFO
COMMENT

• CHARTS ARE AVAILABLE
• IN SUMMARY FOR ALL OF LOGISTICS/AGI
• BY FACILITY/CUSS

• CHARTS ARE PRESENTED IN TWO LAYOUTS
• SUMMARY CHARTS WITH RELATED KPIS, BY KPI
  GROUPING
• BY KPI WITH FACILITY/CUSS AND TOTAL INFO

3
Logistics Key Performance Indicator Groupings

• 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)??
• Turnover

NOTE Available only 15 days after month end
Not available weekly

LEGEND

• Available Today

• Not available Today

• Some InfoAvailable Today

4
Logistics Key Performance Indicators

• Inventory
• 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) Only

Fill Rate Only

5
Logistics Costs
TOTAL LOGISTICS COST AS A OF SALES
TOTAL LOGISTICS COST BREAKDOWN
SHIPMENTS

• PAYROLL
• SUPPLIES
• FREIGHT
• INVENTORY CC
• OCCUPANCY COSTS

• RUSH
• REGULAR

J F M A M J J A S O N D DATA TABLE FOR INFO
J F M A M J J A S O N D DATA TABLE FOR INFO
J F M A M J J A S O N D DATA TABLE FOR INFO
PAYROLL
FREIGHT
INVENTORY

• Courier
• Carrier dc to branch
• carrier dc to customer
• carrier branch to customer

• BRANCH
• DC
• SUPPLIER

• OVERTIME
• REGULAR
• ADMIN

J F M A M J J A S O N D DATA TABLE FOR INFO
J F M A M J J A S O N D DATA TABLE FOR INFO
J F M A M J J A S O N D DATA TABLE FOR INFO
ALL OF THE ABOVE AVAILABLE FOR TOTAL LOGISTICS
AND BY FACILITY/CUSS
6
Logistics Productivity
LOGISTICS COST PER ORDER LINE
LOGISTICS COST PER INVOICE
MANPOWER BREAKDOWN

• PART TIME
• FULL TIME

J F M A M J J A S O N D DATA TABLE FOR INFO
J F M A M J J A S O N D DATA TABLE FOR INFO
J F M A M J J A S O N D DATA TABLE FOR INFO
LINES PER HOUR
TURNOVER
DISCREPANCIES

• OVER
• SHORT
• DAMAGED

J F M A M J J A S O N D DATA TABLE FOR INFO
J F M A M J J A S O N D DATA TABLE FOR INFO
J F M A M J J A S O N D DATA TABLE FOR INFO
ALL OF THE ABOVE AVAILABLE FOR TOTAL LOGISTICS
AND BY FACILITY/CUSS
7
Logistics Inventory
INVENTORY
WEEKS OF SUPPLY BREAKDOWN
TURNS

• DC
• BRANCH

• 0 TO 4
• 5 TO 15
• 17 TO 26
• 27 TO 52
• GREATER THAN 52

J F M A M J J A S O N D DATA TABLE FOR INFO
J F M A M J J A S O N D DATA TABLE FOR INFO
J F M A M J J A S O N D DATA TABLE FOR INFO
INVENTORY ACCURACY
RETURNS TO AGI
RETURNS TO SUPPLIERS
J F M A M J J A S O N D DATA TABLE FOR INFO
J F M A M J J A S O N D DATA TABLE FOR INFO
J F M A M J J A S O N D DATA TABLE FOR INFO
ALL OF THE ABOVE AVAILABLE FOR TOTAL LOGISTICS
AND BY FACILITY/CUSS
8
Logistics Service Level
Inbound Perfect Order
AGI IMPACT Supplier Schedule Accuracy
69 PO Changes
45 SUPPLIER DETAILS PO vs Physical Receipt
72 AGI EFFECTIVENESS DRP
Exceptions Handled 82

• PAYROLL
• SUPPLIES
• FREIGHT
• INVENTORY CC
• OCCUPANCY COSTS

J F M A M J J A S O N D DATA TABLE FOR INFO
Outbound Perfect Order
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
J F M A M J J A S O N D DATA TABLE FOR INFO
ALL OF THE ABOVE AVAILABLE FOR TOTAL LOGISTICS
AND BY FACILITY/CUSS
9
Logistics Efficiency
DC UTILIZATION
MANPOWER UTILIZATION
OUTBOUND SHIPMENT CUBE UTILIZATION
J F M A M J J A S O N D DATA TABLE FOR INFO
J F M A M J J A S O N D DATA TABLE FOR INFO
J F M A M J J A S O N D DATA TABLE FOR INFO
ALL OF THE ABOVE AVAILABLE FOR TOTAL LOGISTICS
AND BY FACILITY/CUSS
10
Logistics Inventory Detail - Weeks of Supply
TOTAL LOGISTICS WEEKS OF SUPPLY BREAKDOWN
EDMONTON INDUSTRIAL
EDMONTON BODY SHOP

• 0 TO 4
• 5 TO 15
• 17 TO 26
• 27 TO 52
• GREATER THAN 52

J F M A M J J A S O N D DATA TABLE FOR INFO
J F M A M J J A S O N D DATA TABLE FOR INFO
J F M A M J J A S O N D DATA TABLE FOR INFO
SASKATOON
WINNIPEG
RICHMOND HILL
J F M A M J J A S O N D DATA TABLE FOR INFO
J F M A M J J A S O N D DATA TABLE FOR INFO
J F M A M J J A S O N D DATA TABLE FOR INFO
ALL OF THE ABOVE AVAILABLE FOR TOTAL LOGISTICS
AND BY FACILITY/CUSS
11
Supplier
Drop Down Box for PO Perfect Order Ratio
(Rolling 53 weeks)
All Edmonton Saskatoon Winnipeg Richmond Hill
DC Work Area
By Supplier Buyer By Product group
By Supplier By SKU
12
Impact on Supplier Performance
13
Supplier Performance Details
Overages (AGI Receipts)
Shortages( AGI Receipts)
Damages (AGI Receipts)
Percentage of Consumer Units
53
1
2
Weeks
14
Effectiveness
DRP Exceptions handled within Timeframe
O,S D
Held on Receipt
Percentage of Consumer Units
53
1
2
Weeks
15
Branch / Customer Order
Drop Down Box for Branch Order Perfect Order
Ratio
All Edmonton Richmond Hill EAPs Western
Branches Central Branches Eastern
Branches Industrial Safety Fleet
DC Work Area Branch
Buyer By Product Class
By SKU
Weston Road Yonge Steeles
16
Branch Order / Forecast Details
Quantity, in Consumer Units
1
2
3
53
4
5
Weeks
17
Back Order Aging Table
Regular
Regular Cube
Promotional
Promotional Cube
1 week or less
gt1 week to 2 weeks
2 week to 4 weeks
4 week to 8 weeks
8 week to 16 weeks
18
Physical Returns, by Type
New Merchandise
Damage Returns
Concealed Damage
Defective
Recalls
Percentage of Consumer Units Sold
1
2
53
Weeks
19
O,SD (Branch to HQ Customer to HQ)
Damaged
Overages
Shortages
Quantity, in Consumer Units
1
2
53
7
Weeks
20
Operations Planning Centre
Fleet Common Carrier Rail Container
All Edmonton Richmond Hill Winnipeg Saskatoon
DC Work Area Branch
21
Employee Retention
Industrial Safety Fleet
Distribution Logistics Transportation