Select Page

Jul 17, 2019

How supply chains mitigate risk with probabilistic planning

Business forecasting has historically been a field defined by error.  Forecast errors can haunt planners years into the future, when even small discrepancies between forecasts and actuals can cost companies significant amounts of resources and lost profit.  Planners who employ point-forecast techniques are using a deterministic planning method, which more or less places all bets on one number.  This is a plan with great risks; any variance between forecasts and actuals come at a cost due to either under or over-production of goods.

Better suited, especially in supply chain planning, is a probabilistic planning model, which accounts for uncertainty of both demand and supply, and gives a range of potential outcomes (quantified by probability of occurrence).  When planners use probabilities in their forecasting models, they see an immense uplift in the usability of their short-, mid-, and long-range projections.

Figure 1:  Representation of historical sales data flowing into a probabilistic forecast for the upcoming year

Probability Distribution

Probability distribution is a superior approach to modeling uncertainty in business forecasting.  It can determine the likelihood, and conversely, the risk levels associated with each potential future outcome.  In the example above, we can see that in April of the upcoming year, the following potential sales numbers are quantified by likelihood of occurrence:

 Number of Units Projected to Sell Likelihood of Occurrence Associated Risk if Committed 50 0% 100% 45 50% 50% 37 95% 5% 30 50% 50% 25 0% 100%

Figure 2:  In this scenario, we commit to building 37 units for April sales knowing this value has the least associated risk level

Building a Probabilistic Forecast

There are various approaches to deriving a probability distribution, either from historical data or using sales team insight.  We will focus on the statistical models, including:

Coefficient of Variance (CoV):  SKUs are categorized into high-stability/low-risk or low-stability/high-risk using the amount of historical variance between forecast and actuals.

Forecast decomposition:  extracting the baseline, trends, seasonality, cycles, and residuals from a time series forecast to determine the lowest risk component (baseline) and the highest risk component (residuals).

Better Planning with Probabilities

A probabilistic approach to business planning allows decision-makers to understand associated levels of risk with each commitment.  In the example in Figure 2, the planners would know that committing to 45 or more orders for April would come with a 50% risk of overproduction.  This analysis enables supply chain leaders to evaluate the increasing levels of risk on both sides of the baseline forecast.  This means committing to quantities with confidence and optimizing inventory levels across the business.

Subscribe to our blog

Never miss industry news, technical information, or thought leadership articles.

Vanguard Software introduced its first product for decision support analysis in 1995. Today, companies across every major industry and more than 60 countries rely on the Vanguard Predictive Planning platform. Vanguard Software is based in Cary, North Carolina.

Recommended Articles

The solution to reacting swiftly and succeeding in this ‘new normal’ is the transition to a more connected and smarter supply chain of the future.

Using Every Byte of Data to Forecast Your Food Supply Chain

The need for food and beverage supply chain organizations to balance supply with increasingly varied demand is more critical than ever before.

Best Practices for Supply Chains Following a Crisis

Supply chain leaders are having to rethink every aspect of their operations, and address ever potentially permanent shift in consumer behavior.