The Smart Forecaster

Pursuing best practices in demand planning, forecasting and inventory optimization

Stop Leaking Money with Manual Inventory Controls

Stop Leaking Money with Manual Inventory Controls

An inventory professional who is responsible for 10,000 items has 10,000 things to stress over every day. Double that for someone responsible for 20,000 items. In the crush of business, routine decisions often take second place to fire-fighting: dealing with supplier hiccups, straightening out paperwork mistakes, recovering from that collision between a truck and the loading dock.

read more
Key Considerations When Evaluating your ERP system’s Forecasting Capabilities

Key Considerations When Evaluating your ERP system’s Forecasting Capabilities

Consider what is meant by “demand management”, “demand planning”, and “forecasting”. These terms imply certain standard functionality for collaboration, statistical analysis, and reporting to support a professional demand planning process.  However, in most ERP systems, “demand management” running MRP and reconciling demand and supply for the purpose of placing orders

read more
The 3 Types of Supply Chain Analytics

The 3 Types of Supply Chain Analytics

The three types of supply chain analytics are “descriptive”, “predictive”, and “prescriptive.” Each plays a different role in helping you manage your inventory. Modern supply chain software lets you exploit all three helping you to reduce inventory costs, improve on time delivery and service levels, while running a more efficient supply chain.

read more
Protect your Demand Planning Process from Regime Change

Protect your Demand Planning Process from Regime Change

No, not that kind of regime change: Nothing here about cruise missiles and stealth bombers. And no, we’re not talking about the other kind of regime change that hits closer to home: Shuffling the C-Suite at your company. In this blog, we discuss the relevance of regime change on time series data used for demand planning and forecasting.

read more
Don’t Become a Victim of Your Forecast Models

Don’t Become a Victim of Your Forecast Models

Generally, the supply chain field has lagged behind finance in terms of the use of statistical models. My university colleagues and I are chipping away at that, but we have a long way to go. Some supply chains are quite technically sophisticated, but many, perhaps more, are essentially managed as much by gut instinct as by the numbers. Is this avoidance of analytics safer than relying on models?

read more
How to Tell You Don’t Really Have an Inventory Planning and Forecasting Policy

How to Tell You Don’t Really Have an Inventory Planning and Forecasting Policy

You can’t properly manage your inventory levels, let alone optimize them, if you don’t have a handle on exactly how demand forecasts and stocking parameters (such as Min/Max, safety stocks, and reorder points, and order quantities) are determined. Many organizations cannot specify how policy inputs are calculated or identify situations calling for management overrides to the policy. If you have these problems, you may be wasting hundreds of thousands to millions of dollars each year in unnecessary shortage costs, holding costs, and ordering costs.

read more
The 3 levels of forecasting: Point forecasts, Interval forecasts, Probability forecasts

The 3 levels of forecasting: Point forecasts, Interval forecasts, Probability forecasts

There are three possible types of forecasts that can be used in demand and inventory planning processes. Point forecasting, interval forecasting, and probabilistic forecasting. Each type of forecast offers progressively more information to inventory managers that will enhance the planning process. In this video blog, Dr. Thomas Willemain explains the differences and highlights the advantages that probabilistic forecasting offers. In summary, knowing more is always better than knowing less and the probability forecast provides additional information that is crucial for inventory planning.

read more
Infrequent Updates to Inventory Planning Parameters Costs Time, Money, and Hurts Service

Infrequent Updates to Inventory Planning Parameters Costs Time, Money, and Hurts Service

Inventory planning parameters such as safety stock levels, reorder points, Min/Max settings, lead times, order quantities, and DDMRP buffers directly impact inventory spending and ability to meet customer demand. Ensuring that these inputs are optimized regularly will dramatically improve customer service levels and will reduce the amount of unnecessary inventory spending.

read more
Undershoot is Sabotaging your Service Level!

Undershoot is Sabotaging your Service Level!

Undershoot means that the lead time begins not at the reorder point but below it. Undershoot happens every time the demand that breached the reorder point took the stock down below (not down to) the reorder point. Undershoot picks your pocket before you even begin to roll the dice. It deludes the inventory professional into thinking his or her reorder points are sufficient to achieve their targets, whereas actual performance will not make the grade.

read more
The Right Forecast Accuracy Metric for Inventory Planning

The Right Forecast Accuracy Metric for Inventory Planning.

Traditional forecasting accuracy metrics aren’t applicable when the goal is to optimize inventory. It’s “service level accuracy” that matters because just setting a service target doesn’t mean you’ll actually achieve it. Poor accuracy here has extremely costly implications. The right way to measure accuracy for inventory planning is to focus on the accuracy of the service level projection. This blog explains why and details how to calculate the metric.

read more
The Real Culprits of Stockouts and Excess

The Real Culprits of Stockouts and Excess

Service level and fill rate are two important metrics for measuring how effectively customer demand is satisfied. These terms are often confused and understanding the differences can help improve your inventory planning process. This video blog (Vlog) helps illustrate the difference with a simple example using Excel

read more
5 Demand Planning Tips for Calculating Forecast Uncertainty

5 Demand Planning Tips for Calculating Forecast Uncertainty

Those who produce forecasts owe it to those who consume forecasts, and to themselves, to be aware of the uncertainty in their forecasts. This note is about how to estimate forecast uncertainty and use the estimates in your demand planning process. We focus on forecasts made in support of demand planning as well as forecasts inherent in optimizing inventory policies involving reorder points, safety stocks, and min/max levels.

read more

Recent Posts

  • BC Transit manages 30,000 discrete skus Distribution CentreOptimizing Parts Management at BC Transit
    BC Transit values its newfound ability to forecast the financial impact of stocking decisions. They are able to balance capacity against criticality and the cost of inventory. […]
  • Using advanced supply chain analyticsGaming Out Your Logistical Response to the Corona Virus
    This short note is about one way your business can develop a plan to adjust to one of the likely fallouts from the virus: sudden increases in the time it takes to get inventory replenishment from suppliers. Supply chains around the world are being disrupted. If this happens to you, how can you react in a systematic way? […]