How to Forecast High-Profit Intermittent Products?

How should you deal with low-volume intermittent products? We’ll discuss forecasting, inventory and supply chain optimization

Nicolas Vandeput
Analytics Vidhya
Published in
4 min readAug 28, 2020

--

📊 Should You Optimize Your Forecasting Process?

Forecasting low-volume products have always been a challenge. Historically, Croston models have been used to forecast intermittent demand (see my article Forecasting Intermittent Demand with the Croston Model). More recently, Nikolaos Kourentzes proposed a temporal aggregation method (see it here). It is usually good with intermittent demand, but not perfect.

To improve low-volume products further, you can also work with judgmental forecasts (for more info, see the second upcoming edition of my book Data Science for Supply Chain Forecasting or the book The business forecasting deal by Michael Gilliland). Using shared information by your customers or looking at the sales pipeline with your sales team might help.

In the end, an optimized, accurate forecast model will only marginally improve the forecast accuracy of low-volume items — their demand will still be inherently highly variable. What is the added value of knowing that next week’s forecast is 0.12 units and not 0.11?

📦 Should You Optimize Your Inventory Policies?

As we discussed, optimizing your forecast model or process for low-volume items will only provide marginal benefits. Henceforth, optimizing your forecast is not the right way to optimize your low-volume high-profit items. Instead, you should optimize your inventory policies.

--

--

Nicolas Vandeput
Analytics Vidhya

Consultant, Trainer, Author. I reduce forecast error by 30% 📈 and inventory levels by 20% 📦. Contact me: linkedin.com/in/vandeputnicolas