Guest Post: New Technology, Analytical Tools and Information Sharing Help Retailers with Sales Forecasts in a Post-COVID World

Dr. Misty Blessley, Associate Professor of Statistics, Operations, and Data Science at Temple University, shares her insights with our readers monthly.

The COVID-19 pandemic changed the way people live. When viewing the demand side of a business-to-consumer (B2C) transaction, our behavior as consumers and the new normal are inextricably linked and continue to evolve. A recent Wall Street Journal article states that “merchants veered between product shortages and overstuffed inventories in rapidly changing consumer markets” as a result of the COVID-19 pandemic. But now that inventories have been worked through, companies are looking for better ways to manage the flow of goods on the fly and make sure they have merchandise where it needs to be to boost sales and maintain margins. What does this mean for post-COVID sales forecasting?

That past behavior is a good predictor of future behavior is the premise on which time- series forecasts (the topic of Chapter 4 in your Heizer/Render/Munson text) stand. Forecasts were based on known patterns of seasonality and the economic outlook over the forecast horizon. However, retailers increasingly recognize that boosting sales and maintaining margins requires them to see and respond to changes in demand as it is happening. In other words, in customer driven markets, the objective is to match the supply of merchandise to consumer demand.

Macy’s has been upgrading its forecasting abilities over the past several years with new technology

Retailers are looking to new technology and analytics that are capable of capturing trends in data that predict future demand. For example, Dr. Martens (a $1.2 billion shoe manufacturer) is currently working to leverage a new order-management system containing a customer-data platform to provide better insight into customer spending. Macy’s Department Store has benefitted from a recent forecasting system upgrade, by recognizing and responding to increasing demand for work-wear over leisure-wear. Retailers are turning to sophisticated algorithms but are also increasing their communications with suppliers as part of having merchandise where it needs to be, in lockstep response to consumer demand.

Classroom discussion questions:
1. What “new normal” could have driven the change to work wear from leisure-wear for Macy’s?
2. Who should be included in a firm’s post-pandemic sales and operations planning (S&OP) process?
3. What is the role of operations and supply chain managers in creating new forecasting methods and then monitoring, controlling, and adapting the forecasts resulting from these new approaches?

Good OM Reading: Enhancing Sales & Operations Planning with Integrated Business Planning (IBP)

As we note in Chapter 13, Sales & Operations Planning (S&OP) is a critical element in making aggregate planning work.  A recent report by McKinsey & Company advises that the unprecedented challenges created by Covid, the war in Ukraine, and what have become chronic supply chain issues, suggest that S&OP be replaced by a more encompassing approach. They call their approach Integrated Business Planning (IBP).

McKinsey’s more encompassing IBP approach consists of five essentials:
1. A business – focused design that covers the midterm time horizon (3 – 24 months) and enables strategy implementation and target achievement.
2. High-quality process management with cross-functional decision makers empowered to resolve issues immediately.
3. Accountability and performance management with shared metrics to encourage collaboration across stakeholders with set targets and clear direction to resolve the trade-offs among conflicting Key Performance Indicators.
4. Effective use of data, analytics, and technology so timely integrated information is available to optimize real-time decision making.
5. Specialized organizational roles and capabilities with specific process owners to promote functional excellence and cross-functional collaboration.

McKinsey’s research indicates that this more encompassing well-functioning IBP process, can yield one or two additional percentage points in EBIT and increased service levels, while lowering freight costs and capital intensity. Additionally, customer delivery penalties and missed sales are reduced, as well as making planners more productive.

Classroom discussion questions:
1. How does McKinsey’s IBP differ from the standard S&OP discussed in Chapter 13?

2. What are the organizational changes appropriate to move from a S&OP process to an IBP process?