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): and the perfect order.

Table 10-5
Warehouse Productivity Measures
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
Table 10-6
Measures of Order Fulfillment (Quality)
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.

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.

Table 10-8
Perfect Order Busters
Perfect Order Busters
  • Order-entry error
  • Missing information
  • Ordered item is unavailable
  • Late shipment
  • Incomplete paperwork
  • Inability to meet ship date
  • Picking error
  • Early arrival
  • Customer deduction
  • Inaccurate picking paperwork
  • Damaged shipment
  • Invoice error
  • Overcharge error
  • Credit hold
  • Error in payment processing
  • 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.

    Table 10-9
    Calculating a Perfect Order
    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.