The Smart Forecaster
Pursuing best practices in demand planning,
forecasting and inventory optimization
Improve Forecast Accuracy, Eliminate Excess Inventory, & Maximize Service Levels
In this video, Dr. Thomas Willemain, co-Founder and SVP Research, talks about improving Forecast Accuracy by Managing Error. This video is the first in our series on effective methods to Improve Forecast Accuracy. We begin by looking at how forecast error causes pain and the consequential cost related to it. Then we will explain the three most common mistakes to avoid that can help us increase revenue and prevent excess inventory. Tom concludes by reviewing the methods to improve Forecast Accuracy, the importance of measuring forecast error, and the technological opportunities to improve it.
Forecast error can be consequential
Consider one item of many
- Product X costs $100 to make and nets $50 profit per unit.
- Sales of Product X will turn out to be 1,000/month over the next 12 months.
- Consider one item of many
What is the cost of forecast error?
- If the forecast is 10% high, end the year with $120,000 of excess inventory.
- 100 extra/month x 12 months x $100/unit
- If the forecast is 10% low, miss out on $60,000 of profit.
- 100 too few/month x 12 months x $50/unit
Three mistakes to avoid
1. Ignoring error.
- Unprofessional, dereliction of duty.
- Wishing will not make it so.
- Treat accuracy assessment as data science, not a blame game.
2. Tolerating more error than necessary.
- Statistical forecasting methods can improve accuracy at scale.
- Improving data inputs can help.
- Collecting and analyzing forecast error metrics can identify weak spots.
3. Wasting time and money going too far trying to eliminate error.
- Some product/market combinations are inherently more difficult to forecast. After a point, let them be (but be alert for new specialized forecasting methods).
- Sometimes steps meant to reduce error can backfire (e.g., adjustment).
For most small-to-medium manufacturers and distributors, single-level or single-echelon inventory optimization is at the cutting edge of logistics practice. Multi-echelon inventory optimization (“MEIO”) involves playing the game at an even higher level and is therefore much less common.
You may remember the story of Goldilocks from your long-ago youth. Sometimes the porridge was too hot, sometimes it was too cold, but just once it was just right. Now that we are adults, we can translate that fairy tale into a professional principle for inventory planning: There can be too little or too much inventory, and there is some Goldilocks level that is “just right.” This blog is about finding that sweet spot.
Just-In-Time (JIT) ensures that a manufacturer produces only the necessary amount, and many companies ignore the risks inherent in reducing inventories. Combined with increased globalization and new risks of supply interruption, stock-outs have abounded. So how can you execute a real-world plan for JIT inventory amidst all this risk and uncertainty? The foundation of your response is your corporate data. Uncertainty has two sources: supply and demand. You need the facts for both.