It is not a game of chance, although it often seems that many organizations have chosen to "guesstimate" their inventory needs. Others install features to assist with demand planning, but their intentions are often better than their implementations because they do not utilize the capabilities to their full potential.

The bottom line is that planning for future demand is truly not a game -- it is a skill that relies on data collection and analysis. You have to know the issues, the drivers behind the issues, and the solutions for the best possible forecasting and inventory management.

Inventory Issues

Numerous inventory obstacles occur for manufacturers, distributors, and retailers in both the financial and customer service areas. While they are commonly associated with newly-introduced stock keeping units (SKUs), unfortunately, they are also very common with long-standing SKUs as well. The most problematic situations that occur, beginning with the most critical, are: 

• Out-of-stock situations that reduce revenue and cause low order fill rates that frustrate customers due to the less-than-ideal capability to fill customer orders completely and promptly.
• Long, unknown or unreliable lead times for replenishment.
• Inventories with discontinued and obsolete SKUs that have no demand at all.
• Overstock of slow-moving, active SKUs that produce low gross margin return on the investment and the associated low inventory turnover.
• Non-optimum inventory deployment, which means there is an appropriate total inventory level but it is not positioned in sync with the demand, requiring both transportation cost and transit time to serve customers.

Overstock and Out-of-Stock Drivers

Both overstock and out-of-stock situations are driven by related factors. The primary drivers of inventory issues are forecast accuracy, safety stock policies, lead times, and stocking policies.

With forecast accuracy, over-forecasting what the demand will be creates overstock issues, low turnover, and in the worst cases, liquidation along with the associated write-off. On other hand, under-forecasting demand creates out-of-stock situations and in some cases, an inordinate amount of extra expenses due to attempts to address the issue. Even when forecasts are fairly accurate, inadequate safety stock inventories that are unable to cover short-term demand peaks and valleys have the potential to create out-of-stock situations.

Unpredictable lead times may also cause havoc and reduce forecast accuracy by either being too early or too late. If purchases are placed early, inventory is increased to minimize the possibility of running out of product. This decreases the turnover rate and creates a surplus of inventory. However, if purchase orders are not placed early enough, out-of-stock situations are prone to occur.

View article on one page