Etude
What to Do Now That Your Demand Forecast Is Wrong
What to Do Now That Your Demand Forecast Is Wrong
The coronavirus outbreak has scrambled normal data patterns. Automated systems now need a heavy infusion of human judgment.
Etude
The coronavirus outbreak has scrambled normal data patterns. Automated systems now need a heavy infusion of human judgment.
Covid-19 is what’s known as a black swan event—something both unexpected and extreme relative to historical norms. Due to the crisis, most demand forecast models in place today are no longer accurate.
These forecasts underpin many of the essential processes and functions that create value in an enterprise. As a result, most critical operational plans suddenly don’t fit the situation on the ground. Among the projections that many businesses can no longer rely on: the revenue forecasts central to expense planning, the sales and operations planning forecasts that serve as the basis of inventory and manufacturing plans, and the demand forecasts that determine workforce planning.
For more detail on the business implications of coronavirus from Bain’s Macro Trends Group, log on to the Macro Surveillance Platform. Learn more about the platform >
The black swan touches different industries and goods in different ways. Some—including groceries, health and hygiene, pet care, video streaming and most e-commerce channels—have seen an immediate and very positive increase in demand (see Figure 1). Many more are suffering a significant drop. When the recovery begins, it too will be uneven, with wide swings in demand from industry to industry.
We are still learning the range of possible outcomes of the outbreak and the full extent of its impact, both in the near and medium terms. But it’s clear that companies will need to both update their forecasts and take a fundamentally new approach to creating them.
The more that humans have been taken out of the forecasting process and replaced with automation, the more work will be needed to correct a company’s forecasts. Machine learning models rely heavily on historic business-as-usual patterns of demand. With business now anything but usual, human judgment has become critically important. That carries its own risks.
Here are three ways to begin to hedge those risks and improve your forecasts.
Appoint a senior manager, ideally someone in charge of forecasting now or who has been in the past, to oversee updates of critical company forecasts. Create a small agile team to do the work and interface with key internal audiences across all geographies and across your broader ecosystem of suppliers, sales channels and customers. Because the impact of coronavirus varies from place to place, it helps if this is a global team that can share insight from different locations.
Setting up a virtual war room will help you gather and synthesize the latest data, such as sales across all geographies, virus development data and macroeconomic data. Forward-looking companies are investing aggressively in ways of listening and communicating both upstream and downstream within their ecosystem, in order to create a complete picture and minimize the chance of missing important signals.
It’s more important and helpful than ever to focus on the forecasts with the highest dollar impact on your business and the most significant error. Apply your forecasting SWAT team according to the Pareto principle, the idea that 20% of the forecasts account for 80% of the value.
The initial weeks and months of the crisis will bring the most societal disruption—mandatory shutdowns, quarantines, social distancing—and will most severely impact your supply chain, sales channel and customer behavior.
Companies will need to shift from complex modeling to simple, more transparent modeling. There is not enough time to collect and review all the relevant data affecting your models, so it makes sense to focus on the few critically important ones. Because of their reliance on historical signals, complex algorithms, especially machine learning, are not well suited to short-term modeling in this anomalous moment. Simple math and human judgment are the order of the day.
For industries with daily data updates, including most businesses that sell directly to consumers, it’s possible to rely to some degree on real-time data. If data takes longer to update, as it does for most business-to-business organizations, it will be more necessary to rely on business judgment.
With so much uncertainty about Covid-19 and how different actors in the economy will respond to it, scenario forecasts are critical. Relying solely on point estimate forecasts could lead to strategies and actions that are insufficient or flat-out wrong. It’s helpful to define two to four integrative scenarios that build in a number of factors affecting demand, including virus spread and the responses of customers, competitors, supply chain and government.
There are three steps to take when creating a scenario.
Companies operating in multiple places should pay close attention to their own demand trend in different locations. Others can use market research data on the closest analog to their industry, keeping in mind how customer and channel mix may vary from one spot to another, and using business judgment to adjust. For example, the reduction in restaurant demand followed a very similar slope in most countries, offset by a few days (see Figure 2).
Once you have your forecasts, you can begin to test strategies to respond to the range of projections, making sure they are robust enough to deal with a range of possible outcomes. Know the objectives of each strategy. Do you intend to optimize revenue, market share, profit, customer fulfillment rate, customer satisfaction or cash flow?
Even as companies grapple with a rapidly evolving near-term outlook, they have begun to look ahead to the medium term—the one or two quarters following the start of the recovery when the number of new cases of Covid-19 begins to drop, societal restrictions ease, and both the supply chain and sales channels largely return to their usual capacity. To begin to get a handle on this, it makes sense to start with your pre-virus forecast and then adjust up and down based on scenarios.
The scenarios should model three key uncertainties:
At some point in the future, once the pandemic has stabilized, we will find ourselves in a new normal. Many companies will need to revamp how they forecast going forward, either due to a permanent shift in customer behavior or because they rely on historical data, which may be less relevant and lead them astray.
In rebuilding, you will undoubtedly uncover many opportunities to improve your approach to forecasting and learn from that. This is not the first time forecasts have been well off the mark. Fixing demand forecasts completely upended by Covid-19 is quite urgent, but also completely doable.
The global Covid-19 pandemic has extracted a terrible human toll and spurred sweeping changes in the world economy. Across industries, executives have begun reassessing their strategies and repositioning their companies to thrive now and in the world beyond coronavirus.
Sanjin Bicanic is a principal in the Advanced Analytics practice in Bain & Company’s San Francisco office. Chris Brahm is a partner and director in the San Francisco office and leads Bain's Global Advanced Analytics practice. Cesar Brea is a partner with Bain’s Advanced Analytics and Customer Strategy & Marketing practices. He is based in Boston.
The authors would like to acknowledge the contributions of Affinity Solutions, a data-led intelligence platform that helps marketers use purchase data insights to better serve customers.