Search By Topic The Green Supply Chain Distribution Digest
Supply Chain Digest Logo
Cliff Holste

Supply Chain Digest
Material Handling Editor

Logistics News - Sorting It Out

Cliff Holste is Supply Chain Digest's Material Handling Editor. With more than 30 years experience in designing and implementing material handling and order picking systems in distribution, Holste has worked with dozens of large and smaller companies to improve distribution performance.

May 3, 2017

Sorting It Out : Profiling – Key To Optimizing Picking Strategies & Technologies

With the Focus on DC Automation – SKU & Activity Profiling all the More Important


For many companies, order profiles and demand patterns change over time – often dramatically. This is the result of several factors, most notably of course, the impact of E-commerce as well as other direct sales channels. These initiatives can cause a change in “mix” with many consumers migrating to lower prices goods while placing more frequent but smaller orders, and, in many cases, shippers consolidating distribution facilities.

As shippers consider adopting automated picking technologies, SKU and activity profiling is an important exercise to go through now to ensure DC strategy is aligned with operational dynamics, which are likely to be different than they were just a few years ago. SKU and activity profiling is also key to selecting the right approaches and technology support for order picking, which often drives 50% or more of a DCs labor costs. Automating a picking operation where SKU and activity profiling has not been optimized, will not produce the best results.

Holste Says...

...shippers should do SKU and activity profiling at least once a year. However, whenever there are changes that impact on the order fulfillment process, stock picking and replenishment operations need to be re-visited and optimized as required to remain efficient.

What do you say?

Click here to send us your comments

What is Activity Profiling?

 SKU and activity profiling is the process of gathering and analyzing data for both order profiles (orders per day/shift, lines per order, items per line, etc.) and individual SKU activity (volumes, breakdown by unit of measure, etc.). 

Although order and SKU profiling is key to consistently re-optimizing product picking arrangements and processes, few companies seem to have the data readily available even in this age of ERP, WMS, data warehouses and other software systems.

In some cases, the data is available or largely available, but is in different software systems. The data from these different sources must be merged. In other cases, key data is not available or is very hard to get at. Examples of the former might include product dimensions and weight; examples of the latter might include order line detail, which can be obtained, but only after a major effort by the IT department to search through archived data. 

In all cases, companies must carefully look at both what data is available and how accurate that data is. 

Data Needed for Order Picking System Analysis  

To determine order picking strategies and technologies, companies need to obtain and analyze the following types of data: 

  • Order mix distribution (family mix, handling unit, order increment);
  • Lines per order distribution;
  • Cube per order distribution; and
  • Lines and cube per order distribution.

Analysis should, in part, develop a SKU velocity profile, similar to the chart below.

The analysis will then also typically involve breaking this data down into movement volumes by different handling/picking units, such as full pallet, full case and split case activity.

The next step is an iterative process, and is constrained by many factors, especially if the analysis is for an existing building rather than a “green field site.” It may also be that a company wants to look only at one area, such as piece picking.

A comprehensive analysis will include both analyzing where some group of products (such as the “Very Fast” full case movers) will be stored, in what type of storage mode (e.g., double deep pallet flow rack, half pallet, etc.) and what picking strategy/technology will be used including automated piece picking and Goods-to-Person solutions.

The analysis can get very sophisticated; for example, in some businesses it makes sense to look at items that are almost always ordered as single line items, and store those in a separate area of the DC. It can also pay to look at SKU/Order relationships – a relatively slow moving SKU might make sense to store in the high-velocity area, if when it is ordered, it almost always is ordered with a Category “A” product.

The key points:

  • Order picking strategies are closely tied to sales channel order profiles and inventory replenishment;

  • Different order picking technologies are best suited to SKU velocity profiles for a given unit of measure; and

  • Different order picking system investments will have different ROI depending on the level of activity within a pick zone. SKU and order activity profiling is essential to optimizing these decisions.

Final Thoughts

Given today’s dynamic marketplace, shippers should do SKU and activity profiling at least once a year. However, whenever there are changes that impact on the order fulfillment process, stock picking and replenishment operations need to be re-visited and optimized as required to remain efficient. If automated picking technologies are being considered, it is essential that DC operations be optimized in order to realize full benefit from the investment.

Any reaction to this Expert Insight column? Send below.

Your Comments/Feedback




Follow Us

Supply Chain Digest news is available via RSS
RSS facebook twitter youtube
bloglines my yahoo
news gator


Subscribe to our insightful weekly newsletter. Get immediate access to premium contents. Its's easy and free
Enter your email below to subscribe:
Join the thousands of supply chain, logistics, technology and marketing professionals who rely on Supply Chain Digest for the best in insight, news, tools, opinion, education and solution.
Home | Subscribe | Advertise | Contact Us | Sitemap | Privacy Policy
© Supply Chain Digest 2006-2013 - All rights reserved