10.9 Tools: Measuring Warehouse Performance
Your warehouse operations have a huge impact on your customers' perceptions of your service quality. You need to measure performance carefully. You need to pay particular attention to productivity, quality, and safety. Table 10-5 and Table 10-6 identify and define some of the most common metrics for warehouse and order fulfillment activities. You need to remember that performance can be measured at different levels: The whole facility, a specific department (receiving, restocking, picking, shipping), or for an individual worker. You'll find that people often talk about warehouse throughput; that is, the total volume that a facility can process in a specific period of time (day, week, month, or year). You'll also hear a lot of discussion on inventory turnover; that is, the velocity of inventory in and out of the facility. Let's take a closer look at two other key performance indicators (KPIs): A performance indicator that looks at the availability of products that are required for purposes of picking and filling customer orders, in a warehouse. and the perfect order.
Measure | Definition | Calculation |
---|---|---|
Orders per hour picked/packed | Avg. number of orders picked and packed per person-hour | Orders picked and packed |
Total warehouse labor hrs. | ||
Lines per hour | Avg. number of order lines picked and packed per person-hour | Total lines picked and packed |
Total warehouse labor hrs. | ||
Items per hour | Avg. number of order items picked and packed per person-hour | Total items picked and packed |
Total warehouse labor hrs. | ||
Cost per order | Avg. cost to fill and order given total warehouse cost | Total warehouse costs |
Total orders | ||
Cost as a % of sales | Total warehousing cost as a percentage of total company sales | Total warehouse costs |
Total revenue |
Measure | Definition | Calculation |
---|---|---|
On-time delivery | Orders delivered on time per customer requested window | Total orders on time |
Total orders shipped | ||
Order fill rate | Orders filled completely on first shipment | Orders filled complete |
Total orders shipped | ||
Order accuracy | Orders picked, packed and shipped perfectly | Orders shipped w/o errors |
Total orders shipped | ||
Line accuracy | Lines picked, packed and shipped perfectly | Lines shipped w/o errors |
Total lines shipped | ||
Order cycle time | Time from order placement to customer receipt of delivery | Delivery date - customer order date |
Perfect order completion | Orders delivered without changes, damage, or invoice errors | # Orders Delivered Defect Free |
Total # Orders |
Product Availability
You measure product availability using a fill-rate metric; i.e., item fill rate, line fill rate, or order fill rate. Table 10-7 illustrates how you calculate these metrics for an order that consists of multiple lines. Please note that the customer has ordered different quantities for each line (i.e., a specific SKU). As a result, your choice of metric—item versus line fill rate—influences how you view service. Let's look at two scenarios. For Scenario A, the line fill rate is a respectable 90%. However, the item fill rate is 45%—a truly dismal service level. The math for Scenario B shows an item fill rate of 69% and a line fill rate of 40%. Although the item fill rate is better than the line fill rate, both are unacceptable. For both scenarios (A & B), the order fill rate is 0%; so is the perfect order rate. Your takeaway: You need to understand the nature of the metric, how it is calculated, and what the results are really telling you. This fact is true for all metrics, not just fill-rate measures. You can't afford to let poor use of metrics (either wrong metrics or wrong use of metrics) lull you into a false sense of high performance.
Line | Items Ordered | Scenario A Items Filled | Scenario B Items Filled |
---|---|---|---|
1 | 10 | 10 | 0 |
2 | 20 | 20 | 1 |
3 | 30 | 30 | 30 |
4 | 10 | 10 | 0 |
5 | 20 | 20 | 0 |
6 | 30 | 30 | 30 |
7 | 10 | 10 | 0 |
8 | 20 | 20 | 0 |
9 | 30 | 30 | 30 |
10 | 220 | 0 | 220 |
Total | 400 | 180 | 310 |
Item Fill Rate | |||
Scenario A: 180/400 = 45% | |||
Scenario B: 310/400 = 69% | |||
Line fill Rate | |||
Scenario A: 9/10 = 90% | |||
Scenario B: 4/10 = 40% |
Adapted from Coyle, Langley, Gibson, and Novack (2011)
Perfect Order Fulfillment
Increasingly, companies strive to achieve what is called the perfect order. Perfect orders are hassle free. The Supply Chain Council defines a perfect order as follows: "An order delivered to the right place, with the right product, at the right time, in the right condition, in the right package, in the right quantity, with the right documentation, to the right customer, with the correct invoice."1 Simply put, either everything was just right or nothing went wrong. The perfect order thus sets a very high performance bar. Consider how hard this is to achieve. Any kind of error busts a perfect order. Best-in-class performance is only about 90%. Nine out of ten imperfect orders fail due to one of the issues listed in Table 10-8.
Perfect Order Busters | |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
The Grocery Manufacturers Association provides performance statistics for a few components of a perfect order (see Table 10-9). If we focus on just four issues—on-time delivery, orders shipped complete, orders shipped damage free, and orders shipped with the correct documentation—the average perfect order percentage is 84%. 2 Clearly, achieving the perfect order requires action beyond the warehouse, but as a warehouse manager you have a huge impact on this metric. Pursuing "perfection" can help you avoid complacency and drive improvement as you find and remove the root causes of perfect order failures.
Perfect Order Elements | Average |
---|---|
Percent On Time Delivery (OTD) OTD to DC w/in 30 minutes |
93% |
Percent Orders Shipped Complete (Order Line Item Fill Rate) |
97% |
Percent of Orders Shipped Damage Free |
99% |
Percent of Orders Sent with the Correct Documentation Invoice Accuracy |
94% |
TOTAL PERFECT ORDER (.93 × .97 × .99 × .94 = .84) |
84% |
One final thought on measurement: As you focus on productivity and perfection, don't forget your people. You need to stay focused on safety. You might consider the following motto, "Quality First, Safety Always." To emphasize safety, you'll want to measure injuries, lost-time injuries, and near misses. Some companies even add “safety” as a sixth “S” to their 5S initiatives–turning into a 6S program.
In addition to safety, consider tracking the number of innovation ideas suggested and implemented. No one is closer to the action than the people doing the work. They can help you improve operations if your invite them to do so. As you act on their suggestions, they will be more enthusiastic and engaged team members. The bottom line: You want your employees to feel both safe and valued. If you accomplish this, employee turnover will go down, along with recruiting and training costs.
Want to try our built-in assessments?
Use the Request Full Access button to gain access to this assessment.