What This Year’s Data Said
Table 4 provides a summary of all of the metrics from this year’s study presented in seven columns that are aimed to shed light about how companies are performing.
Column 1 – METRIC: This represents the metric that is being examined.
Columns 2-6 - QUINTILE RANKINGS: These columns split all data responses into 5 equally divided groups. Each quintile ranking indicates 20% of the responses, with the 5 groups divided categories representing
- Major Opportunity: Represents the lowest 20% of responses
- Disadvantage: Represents responses ranging in the 20-40th percentile
- Median: Represents responses ranging in the 40-60th percentile
- Advantage: Represents responses ranging in the 60-80th percentile
- Best Practice: Represents top 20% of all responses
Column 7 - MEDIAN: This indicates the actual median performance of all respondents.
|
Table 4. Quintile Performance Classifications for Metrics
Column 1 |
Column 2 |
Column 3 |
Column 4 |
Column 5 |
Column 6 |
Column 7 |
|
Metrics |
Major Opportunity |
Disadvantage |
Typical |
Advantage |
Best in Class |
MEDIAN |
|
Customer Metrics (note additional customer metrics can be found under Perfect Order Metrics section) |
|
On time shipments |
Less than xx% |
>=xx% and <xx.xx% |
>=xx% and <xx.xx% |
>=xx% and <xx.xx% |
>=xx.x% |
xx.x% |
|
Total Order Cycle Time |
Greater than xx hours |
<xx and >=xx |
<xx and >=xx |
<xx and >=xx |
<xx hours |
Xx hours |
|
Internal Order Cycle Time |
Greater than xx hours |
<xx and >=xx |
<xx and >=xx.x |
<xx and >=xx.x |
<x.x hours |
Xx hours |
|
Perfect Order Completion Index |
Less than xx% |
>=xx% and <xx% |
>=xx% and <xx% |
>=xx% and <xx.x% |
>=xx.x% |
Xx% |
|
Lost sales ( Percent of SKUs Stocked Out) |
Greater than x% |
<x% and >=x% |
<x5 and >=x.xx% |
<x.xx% and >=x.xx% |
<x.xx% |
X% |
|
Backorders as a Percent of total orders |
Greater than xx.x% |
<x.xx% and >=x% |
<x% and >=x% |
<x% and >=x.xxx% |
<x.xxx% |
x.x% |
|
Backorders as a Percent of total lines |
Greater than x% |
<x% and >=x.xx% |
<x.xx% and >=x% |
<x% and >=x.xx% |
<.xx% |
x.x% |
|
Backorders as a Percent of total dollars/units |
Greater than xx% |
<xx% and >=x.xx% |
<x.xx% and >=x% |
<x% and >=x.xx% |
<x.xx% |
x% |
|
Operations Metrics |
Major Opportunity |
Disadvantage |
Typical |
Advantage |
Best in Class |
MEDIAN |
|
Inbound Metrics |
|
Dock to Dock Cycle Time, in hours |
Greater than xx.x hours |
<xx.x and >=xx |
<xx and >=x |
<x and >=x |
<x hours |
X hours |
|
Suppliers Orders Received Hour |
Less than x per hour |
>=x and <x |
>=x and <x |
>=x and <xx |
>xx.x per hour |
X per hour |
|
Lines Received and Put Away per Hour |
Less than x.xx lines per hour |
>=x.xx and < xx.x |
>=xx.x and <xx |
>=xx and <xx.x |
>=xx.x lines per hour |
xx.x per hour |
|
Percent of supplier orders received with correct documents |
Less than xx% |
>=xx% and <xx% |
>=xx% and <xx.xx% |
>=xx.xx% and <xx% |
>=xx% |
Xx% |
|
Percent of supplier orders received damage free |
Less than xx% |
>=xx% and <xx% |
>=xx% and <xx.xx% |
>=xx.xx% and <xx% |
>=xx% |
Xx% |
|
On time receipts from supplier |
Less than xx% |
>=xx% and <xx% |
>=xx% and <xx% |
>=xx% and <xx.x% |
>=xx.x% |
Xx% |
|
Outbound Metrics |
|
Fill rate - line |
Less than xx.xx% |
>=xx.xx% and <xx.x% |
>=xx.x% and <xx.x% |
>=xx.x% and <xx.x% |
>=xx.x% |
Xx% |
|
Fill rate - order |
Less than xx% |
>=xx% and <xx.xx% |
>=xx.xx% and <xx.xx% |
>=xx.xx% and <xx.x% |
>=xx.x% |
Xx% |
|
Lines Picked and Shipped Per Hour |
Less than xx.xx lines/hour |
>=xx.xx and <xx.x |
>=xx.x and <xx |
>=xx and <xx |
>=xx lines/hour |
xx.x lines/hour |
|
Orders Picked and Shipped Per Hour |
Less than x orders/hour |
>=x and <x.xx |
>=x.xx and <x |
>=x and <xx |
>=xx orders/ hour |
x.xx per hour |
|
Cases Picked and Shipped Per Hour |
Less than xx.xx cases / hour |
>=xx.xx and <xx |
>=xx and <xxx.xx |
>=xxx.xx and <xxx.xx |
xxx.xx cases/hr |
Xxx per hour |
|
Pallets Picked and Shipped Per Hour |
Less than x.xx pallets/hour |
>=x.xx and <x.x |
>=x.x and <xx.xx |
>=xx.xx and xx.x |
>=xx.x pallets/hr |
xx.x per hour |
|
On time ready to ship |
Less than xx% |
>=xx% and xx% |
>=xx% and <xx.x% |
>=xx.x% and <xx.xx% |
>=xx.xx% |
Xx% |
Data has been removed from sample.