Advanced Analytics Forecasting

WHITE PAPER

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.

probabilities in business forecasting figure 1

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.

Top 4 Barriers to Sales Team Accuracy

WHITE PAPER

About Vanguard Software

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.

Request demo
Get a quote
Chat now!