Reduce stocks, increase income and reduce costs through stratification

Item stratification is a new term for many, but it is important to know its meaning and process methodology. This is because it allows you to understand the quantitative ratio of stocks, as well as maintain the optimal amount of goods in storage. This means that it allows you not to freeze excess funds in the warehouse stock balances, but to increase the working capital and, at the same time, the store's revenue. So what is stratification, how can it be done correctly, and what benefits does it provide? Read about all this in our article.

What is stratification and why is it needed?

Stratification (Stock stratification / Item stratification) is the result of the classification of stocks into categories. This segmentation helps the company decide which items should be left in stock and which should not. In other words, this tool allows a company to store the right products in the right quantity and in the right place.

Without proper stratification of items in your warehouse and store, restocking issues can arise. Here is some of them:

  1. The emergence of Out-Of-Stock (Sales OOS, "out of stock"), which will lead to a decrease in the level of customer service;
  2. Occurrence of Over-stock (overstock, re-stocking) - when SKUs are stored in a warehouse or at a point of sale in quantities exceeding the standard balance;
  3. Errors in the estimation of reserves that affect the financial condition of the company.

Inventory stratification helps you classify items and therefore apply a forecasting and replenishment strategy to them. These strategies are very helpful in maintaining the optimal quantity of items in storage. However, manually implementing such strategies is labor-intensive and there is a risk of a human factor.

How does stratification help maintain optimal stock?


Stratification does not replace forecasting, but helps in making purchasing decisions. Correctly performing product stratification has the following benefits for your company:

  • Improving the level of customer service;
  • Returning the margin provided by other companies (distributors, suppliers);
  • Increased opportunities for reinvestment;
  • Increase in EBITDA (Earnings Before Interest, Taxes, Depreciation and Amortization) - profit before interest, taxes and accrued depreciation.

Stratifying your company's inventory helps you focus not only on products with high sales and turnover, but also on products with low turnover (slow moving).

Analyze your business processes with our demand forecasting and ordering checklist and see what can be improved and automated!

Download a check-list

Stock stratification methods

The first thing your company needs to do is create an action plan and define criteria for stratification. To do this, it is necessary to identify the processes used, checkpoints, and also what data is available to analyze the achievement of this goal.

Most companies stratify their products in one form or another, but few apply a methodology with more than one or two breakpoints.

Examples of control points:

  • Maximizing GMROII (Return on Investment in Residuals) in terms of cost reduction and profit enhancement.
  • Reduction of COGS (minimization of purchase prices and transport costs), optimal use of economies of scale in procurement
  • Optimization of the frequency / schedule of purchases
  • Increased inventory turnover

Typically, a company has to take into account numerous criteria, milestones, and data to properly stratify the residuals. It is best to use specialized tools to improve the quality of the process. Let's take a look at what solutions are there.

Stock stratification in SR Warehouse Replenishment solution

To automate stratification at different levels of the company, the Consulting for Retail (C4R) team offers solution - SR Warehouse Replenishment, which enables complex decisions to be made through a simple, efficient and fast process. In addition, the tool promptly provides all the information necessary for making a decision.

Stock stratification is about determining the origin of your current inventory based on the most recent orders. To do this, SR Warehouse Replenishment analyzes the last confirmed order bids that were saved by the system. The number of such orders is parameterized by the user.

When working with the SR Warehouse Replenishment solution, all data on the movement of goods is collected in a database and analyzed. As a result, you get a visual representation of the structure of inventory balances.

The base stock is designed to smooth out the frequency of orders, delays in deliveries, and statistical forecast errors. For accurate sales forecasting and demand in the C4R portfolio there are solutions based on the SR Demand Forecasting module.

The safety stock is calculated automatically and takes into account the Supplier Service Level (meeting delivery deadlines), the Target Service Level based on the ABC classification.

Safety stock allows the user to add his own adjustment to the amount suggested by the system to cover presentation balances or weather-related risks.

Promo allows you to take into account multithreaded optimization when placing orders for products participating in a constant flow and promotions.

Investment – an investment purchase, which involves the purchase of an increased amount of products at reduced prices, taking into account storage costs, financial costs and price differences. Investment purchases are recommended when the system calculates the total benefit.

Reference rounding – rounding associated with the supplier's packaging (for example, products can only be shipped in boxes or pallets).

Rounding off an order – restrictions related to transport and logistics, or restrictions related to supplier orders.

As a result, each order in the system is, as it were, distributed to different “inventory levels” (basic, insurance, reserve, etc.). "Layers" of the same type from each order are summed up and the final proportion by layers is fixed. For example, the basic stock accounts for 45%, the insurance stock - 30%, and so on for all "layers". The result is visual information about the structure, which the system saves as a stratification for the current date.

The information received is easy to work with, analyze and make decisions about the order. Depending on the analysis tasks, stratification can be performed at the item level in the order, the entire order, warehouses, stores, etc. The analysis of the stratification obtained in the system gives you an understanding of what actions need to be taken in order to reduce one or several "layers" at the general level.

With the C4R SR Warehouse Replenishment solution, you can use strategies that combine multiple checkpoints. Thanks to this, your company can get better Item stratification. This helps to keep the right products in stock. At the same time, it is possible to identify products with low turnover, with the aim of writing off or selling at reduced / special prices for customers. The ultimate goal should be to reinvest the freed up money in goods that actually turn around, thereby improving your company's bottom line.

All questions about C4R solutions for retail, distribution and logistics, as well as audit and consulting services for retail, ask our consultants at +38 (044) 492-67-00, write to [email protected] or fill out the callback form. We will help you optimize and automate your retail processes.

The author of the material is Anton Tsemerov,
ERP Consultant Consulting for Retail

Request a demo or consultation