A demand forecasting error is not really one error; it is two errors with different costs. Overestimate and money is locked in the warehouse while the goods gradually lose value. Underestimate and you lose the sale, and sometimes the customer. Most organisations see only one of the two: the one that has a number in their monthly report.
Supply chain differs from other functions in that its decisions are chained: an error in the sales estimate reaches the purchase order, from there the production plan and then the supplier, growing at every step. That is why an accuracy gain at the start of the chain has a multiplied effect at its end.
Three points with the greatest impact
- Demand forecasting: estimating future need at item level, not at total-sales level.
- Inventory policy: setting each item's reorder point and safety stock from demand variability and lead time.
- Early disruption warning: watching for signs of supplier delay before they turn into a shortage.
An accurate forecast alone is not enough
Many projects begin with the aim of improving forecast accuracy and end with better accuracy but unchanged inventory. The reason is plain: the actual ordering decision is still made by the old rules. A forecast is only an input; what determines inventory is the ordering policy — when to order, how much, and how much safety margin to hold. Until that policy is rewritten, a better model only produces a better number on paper.
Lead time, the variable most often forgotten
Safety stock is set not only by demand variability but by lead-time variability. A supplier who sometimes delivers in ten days and sometimes in forty forces you to hold more inventory even when demand is perfectly stable. So before investing in a demand model, extract the lead-time history of each supplier; in many organisations that single table delivers the largest early improvement.
Why it matters for Iranian SMEs
In chains that depend on imports, volatility in lead times and exchange rates has turned planning from an administrative exercise into a financial decision. Ordering early carries holding cost and the risk of dead stock; ordering late can halt operations. A model that weighs those two risks together need not be complex, but it must be built on that organisation's real history rather than on generic assumptions.
A 90-day route to start
- Days 1–30: classify items by value and turnover and begin with the high-value, fast-moving group. Bring sales history, order history and each supplier's actual lead time together in one table.
- Days 31–60: build the forecast for that group and compare it with the current method. The comparison must be made on forecast error, not on the buying team's impressions.
- Days 61–90: rewrite the reorder point and safety stock for that group from the new output, and measure the effect on inventory turnover and on-time fulfilment.
Frequent mistakes
- Forecasting at total-sales level instead of item level; a correct total still produces the wrong decision.
- Leaving exceptional events in the history; a strong month driven by one large one-off order will distort next year's plan.
- Improving the model without rewriting the ordering policy.
- Ignoring lead-time variability and attributing every shortage to forecast error.
Three actions for this quarter
- Extract the lead-time history of your three main suppliers and put the average and the maximum side by side.
- Identify the ten items holding the most capital and check when their ordering policy was last written.
- Record two metrics: inventory turnover and the on-time fulfilment rate for customer orders.
Frequently asked questions
- How many years of sales history does forecasting need?
Two years is usually enough to see the seasonal pattern; but if you only have one, start and refine the model over time. A short history is no reason to postpone. - How is this different from our ERP system?
The ERP records what has happened; a forecasting model uses those same records to estimate what comes next. They are complements, not substitutes. - What if a supplier shares no data?
Your own order history is enough: order date, actual receipt date and quantity delivered are exactly what you need to assess supplier reliability.
Takeaway
Supply chain is where a small improvement at the start of the chain shows up large at its end. But sequence matters: first organise demand and lead-time history, then improve the forecast, and only then rewrite the ordering policy on that basis. Jumping from the first step to the third is the mistake that leaves most projects without a result.
Glossary
- Safety stock: extra inventory held to absorb demand variability and supply delay.
- Lead time: the interval between placing an order and actually receiving the goods.
- Reorder point: the inventory level at which a new order is placed.
- Inventory turnover: how fast inventory sells and is replaced over a period.
- Bullwhip effect: the amplification of order swings as you move from the customer end toward suppliers.
- Forecast error: the gap between the forecast quantity and the actual one, the measure of model quality.