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).
RECENT POSTS

What is Inventory Planning? A Brief Dictionary of Inventory-Related Terms
People involved in the supply chain are likely to have questions about various inventory terms and methods used in their jobs. This note may help by explaining these terms and showing how they relate.

Confused about AI and Machine Learning?
Are you confused about what is AI and what is machine learning? Are you unsure why knowing more will help you with your job in inventory planning? Don’t despair. You’ll be ok, and we’ll show you how some of whatever-it-is can be useful.

Centering Act: Spare Parts Timing, Pricing, and Reliability
In this article, we’ll walk you through the process of crafting a spare parts inventory plan that prioritizes availability metrics such as service levels and fill rates while ensuring cost efficiency. We’ll focus on an approach to inventory planning called Service Level-Driven Inventory Optimization. Next, we’ll discuss how to determine what parts you should include in your inventory and those that might not be necessary. Lastly, we’ll explore ways to enhance your service-level-driven inventory plan consistently.