Do You Understand What's Driving Your Demand Planning Processes?

Do You Really Understand What’s Driving Your Demand Planning Processes?

Descriptive, predictive and prescriptive analytics should be combined to optimize your demand planning processes. 

Some years ago, a 40-year-old Midwest process manufacturer with 40,000 SKUs finally completed implementing a new ERP system and quickly worked to combine all the new data with an array of other operational software, producing tons of new data daily. The company’s goal was to build a data-driven organization making fact-based decisions in near real time. Better forecasting and demand planning processes, which in the past had been beset by low accuracy and poor adoption, were a priority. 

Pulling data into a business intelligence tool in each department, the company started generating a new series of reports designed to meet the requirements of each department. But those reports soon generated disagreements across the sales, operations, marketing and finance teams. Data were inconsistent across groups, and despite endless graphs and tables, no one was clear on how to improve business using the information. After six months, the company still struggled to leverage any new insight and began reverting to Excel reports.  

Teams were disappointed. The spreadsheet reports took a month to produce and used all the capacity of two IT staff members. When the Finance Manager who had designed the reports resigned, the organization knew it had to figure out a better plan for using their data. 

New Beginnings 

With the evolution of the digital supply chain has come vast amounts of new data for every company. But there’s no guarantee you can use that data effectively. In fact, there can be as much risk in misusing data as there is in flying blind with no data.  Forecasting and demand planning can be a challenge because they require a significant amount of quantitative analysis and subjective management judgment.   

To really exploit your new data to gain an advantage, you need a clear analytical plan, specific metrics tailored to your situation, and an understanding of what analytics and reporting will help you to enhance your demand planning processes. This blog post outlines three types of inter-related analytical tools that you need to use in concert to get the best insight from your data. 

The Analytics to Boost your Demand Planning Processes

Sure, forecasting is the mainstay of demand planning. We generate a prediction from historic actuals, maybe bring in some external factors, allow management to edit the results, and publish new forecasts to drive planning, all of which works relatively well. But what we often miss is a good understanding of the market dynamics driving our predictions, and an understanding of whether our adjustments to the plan are optimal.  Integrating descriptive, predictive and prescriptive analytics will help you to improve your forecasting and demand planning processes. Here’s where they help. 

Descriptive Analytics in Demand Planning 

Descriptive analytics are the summary measures and metrics that provide insight. Why are our error metrics (MAPE, MAE, etc.) changing so much – or not getting any better? Often, we simply act on error measures. But we really want to know how forecastable our data is and what is causing any bias. Think of descriptive analytics as the means, medians and modes, the histograms and frequency distributions, and the variance measures that you learned in college. They are critical because they tell you the underlying structure of your data.  

The key descriptive measures for demand planning are the skewness and kurtosis of your sales data.  Skewness is the measure of lumpiness at a particular end of the distribution. If you have too much skew, you can’t use means effectively and should rely on medians. For example, you ran multiple promotions at different price points for different packages in the past quarter. If sales bumped up significantly below a certain price point, your forecast will be biased unless you keep the promotion going. Instead, you’ll need to segment products for your forecast or make statistical adjustments to dampen the effect.  Either way, you need a precise understanding of the bias and descriptive analytics will get you there. 

Predictive Analytics in Demand Planning 

Predictive analytics, practically, cover any effort to use the analysis of historical data points to anticipate what will most likely happen in the future. Time series forecasting is predictive – but that’s well documented. However, newer approaches like tree analysis can be used to segment or classify sales results and build predictions from resulting likelihood estimates. These methods are powerful in many situations. They overcome some of the big weaknesses of times series, such as an inability to deduce what factors are driving the forecast. These approaches work by identifying factors that differentiate high versus low sales and incorporate a time dimension in the results to determine future trends. 

Predictive analytics can also be used to assess risk around your forecast. Do you have very low accuracy levels compared to some reasonable benchmark? Why? In more than a few situations, we’ve built predictive models to understand the drivers of error versus the forecast. By targeting these drivers, we can reduce elements of error and ultimately improve the forecast. Regression methods are a good choice for building a model that can be translated into a decision tool. 

Prescriptive Analytics in Demand Planning 

Let’s say all our forecasting and market analysis is done and we’re reasonably happy with the results. We can increase inventory for spiking demand and clear our inventory for under-performers through pricing and promotion. But that’s reactive.  Prescriptive analytics are effectively recommendation engines that guide us to the best choice among multiple product actions – given the known situation. Collaboration filters in e-commerce are the most common tools. 

In demand planning, we can use prescriptive analysis at a strategic and tactical level.  Strategically, most organizations are continuously weighing the trade-offs between revenue growth, profit margins, market share, and service levels. Since most research shows that many new product launches can fail in their first year, it would be ideal to have better insight into whether to invest more, tolerate longer, or divest products based on the company’s goals. Prescriptive analytics include algorithms to make these trade-off analyses – then put them in a modeling and what-if calculator to enable business managers to make decisions quickly in terms that senior management will appreciate. 

Make your Organization Truly Data-Driven 

Overall, descriptive, predictive and prescriptive analytics mean different things – but their real value is combining them to make your organization data-driven. Use descriptive statistics to get a real feel for your business and understand the strengths and weaknesses of your data. Once you know your data, use predictive tools to enable the organization to understand likely future outcomes of your demand planning. And lastly, simplify and automate decision-making through prescriptive analytics. While it’s not yet time to turn the business over to the robots, we can frame up our decisions in a more structured fashion. We can then provide the quantitative information to get a demand consensus to best match supply and demand. 

To learn more about the different analytics options available today, check out Logility’s two-minute guide to understanding and selecting the right descriptive, predictive, and prescriptive analytics for your business.