A statistical methodology to segment your products based on turnover and demand variability
Product segmentation refers to the activity of grouping products that have similar characteristics and serve a similar market. It is usually related to marketing (Sales Categories) or manufacturing (Production Processes). However, as a Logistics Manager, you rarely care about the product itself when managing goods flows; except for the dangerous and oversized products.
Your attention is mainly focused on the sales volumes distribution (fast/slow movers), demand variability and delivery lead time.
You want to put efforts into managing products that have:
- The highest contribution to your total turnover: ABC Analysis
- The most unstable demand: Demand Variability
In this Article, we will introduce simple statistical tools to combine ABC Analysis and Demand Variability to perform products segmentation.
You are the Operational Director of a local Distribution Center (DC) that delivers 10 Hypermarkets.
In your scope you the responsibility of
- Preparation and delivery of replenishment orders from stores
- Demand Planning and Inventory Management
What does impact your logistic performance?
This analysis will be based on the M5 Forecasting dataset of Walmart stores sales records (Link).
This repository code you will find all the code used to explain the concepts presented in the article.
Senior Supply Chain Engineer with an international experience working on Logistics and Transportation operations.
Have a look at my portfolio: Data Science for Supply Chain Portfolio
Data Science for Warehousing📦, Transportation 🚚 and Demand Forecasting 📈