Machine learning: A new tool for better forecasting
Business volatility and the complexity of factors influencing demand are making it hard to reliably model the causes of demand variation. Machine learning can help companies overcome that challenge.
Demand forecasting is difficult, and most demand forecasting conducted today produces disappointing results and significant forecast errors. It cannot easily identify trends in the demand data, and its limited ability to understand the underlying causes of demand variability makes that variability seem worse than it would if demand drivers were clearly understood. And because it is manually intensive, it suffers from persistent bias and poor planner productivity.
"Supply Chain Shaman" Lora Cecere puts it bluntly. In her excellent book, Bricks Matter, she writes, "Within an organization, the words 'Demand Planning' stir emotions. Usually, it is not a mild reaction. Instead, it's a series of emotions defined by wild extremes including anger, despair, disillusionment, or hopelessness." She goes on to say that planning teams are dismayed by demand planning's challenges, and further claims that leaders are not optimistic about making improvements to planning processes and technologies.
What makes forecasting demand so challenging? Rather than appearing as a logical series of numbers, in today's business environment demand more often seems like a pattern of partially constrained chaos. Demand is increasingly influenced by multiple internal and external factors that drive it up and down in ways that can't be understood by simply looking at a historical time-series of aggregated demand buckets. Instead, demand should be viewed as being driven by a complex series of indicators that can be nearly impossible to manage with traditional forecasting algorithms.
However, a new technology called machine learning can help companies address demand-forecasting challenges by reliably modeling the numerous causes of demand variation. Machine learning is a computer-based discipline in which algorithms can actually "learn" from the data. Rather than following only explicitly programmed instructions, these algorithms use data to build and constantly refine a model to make predictions. I'll explain in more detail later, but first I'd like to describe several business scenarios where companies have employed machine learning in their demand forecasting. See if any of these scenarios suggest familiar attributes in your own business.
Lots of promotions. Every year, the Italian dairy producer Granarolo S.p.A. runs thousands of consumer promotions, creating forecasting scenarios for 34,000 unique stock-keeping unit (SKU) promotions. And it gets worse: Demand spikes can amount to an extraordinary 30 times baseline sales. (For more about these challenges, see the Granarolo sidebar.)
This is a common predicament. Expenses for advertising and promotions can add up to more than 20 percent of sales for many consumer products companies. Yet according to Michael Kantor, founder and chief executive officer of the Promotion Optimization Institute, only about 1 in 50 brands is able to forecast demand uplift reliably enough to guarantee consumer product availability and to evaluate the economic returns on those promotions. Without improved technology, few companies can forecast effectively in such a promotion-heavy environment. (For an example, see the sidebar about Groupe Danone.)
Lots of new products. The United Kingdom-based electronics distributor Electrocomponents plc is a top-ranked global distributor with 500,000-plus in-stock items. The company introduces 5,000 new products every month and fulfills more than 44,000 same-day orders every day from its operations in 32 countries. A few new products a month is one thing, but predicting demand for such a vast array of new products is more than a demand planner can reasonably be expected to handle. Plus, new products, by definition, are difficult to forecast. Nevertheless, planners can tap into external data to help them predict initial demand and thus decide how much marketing budget to invest in launching a new product.
Lots of "long-tail" demand. Companies whose e-commerce business is growing find themselves having to forecast demand for more slow-moving, "long-tail" items that customers order infrequently and in small quantities. Outliers are naturally hard to predict, making inventory planning notoriously difficult. Even if you can predict the average demand for certain products, you probably can't predict the demand spikes. This makes it nearly impossible to maintain a balance—having enough on hand to satisfy sudden spikes without adding unnecessary inventory and eventually holding "dead stock."
Growing complexity. Planning wasn't so complicated when Granarolo started out in the 1960s as a local collective of milk producers, but gradually complexity intensified as the company grew into a multinational concern comprising eight brands and hundreds of different dairy products, and utilizing various delivery modes. Its basic software was never designed to handle this kind of growth, and what resulted was progressively inaccurate forecasting that needed time-consuming manual activity to fine-tune. Granarolo's situation is typical of modern supply chains, which continue to increase in complexity.
Extreme seasonality. The United States-based heating, ventilation, and air conditioning (HVAC) manufacturer Lennox International Inc.'s forecasting was complicated because of its high number of SKUs (each of which had its own unique demand pattern) and a significant stock of slow-moving parts, and because it is an extremely seasonal business. Further complicating matters was the company's plans to greatly expand its distribution network, as detailed in the Lennox sidebar. There was no way the manufacturer could manage this level of complexity and variability without adopting a highly automated demand planning system.
Just too much data. In all of these companies we find a pattern that is common to most of today's businesses: a proliferation of new data. I'm referring here primarily to market and logistical data that can help companies better predict demand. Having to manage huge volumes of diverse and ever-growing data streams is more than most planners (and planning systems) can handle. Trying to incorporate them into a forecast using spreadsheets or traditional planning tools is frustrating, often futile, and can be extremely costly.
The companies in the scenarios above share an intrinsic level of complexity and scale that makes it almost impossible for planners to generate reliable forecasts. They are no longer simple and predictable businesses, able to forecast based on historic sales volumes—if they ever were! Their planners were overwhelmed.
In many cases we see, people don't start contributing to forecasts until the very end of the process. So, rather than providing input to help generate an accurate forecast in the first place, they're collaborating to adjust the forecast "output." This approach is inefficient. While some late-stage "crowd wisdom" can be useful, it can also introduce bias. A typical example is when a sales organization artificially adjusts a forecast to match revenue targets.
What else do these companies have in common? They all turned to machine learning in order to increase forecast reliability. This decision dramatically slashed inventory costs and at the same time provided better, more efficient service to customers. It also meant that planners no longer had to waste time manually overriding or adjusting forecasts.
Let's examine how machine learning enabled these improvements.
What machine learning is and does Machine learning systems were designed to handle forecasting models that can incorporate many kinds of data. Rather than following traditional programmed instructions, machine learning systems reduce demand variability by capturing and modeling all the relevant attributes that shape demand while filtering out the "noise," or random and unpredictable demand fluctuations.
As a result, they learn from the data that they process and modify their operations accordingly. For example, a machine learning system that uses Web data to quickly detect successful new products will find and learn which demand indicators—such as Web page hits, specification downloads, and time on site—are most reliable, and then will update its model over time as consumer behavior changes.
Machine learning can interpret the effect of stimuli (such as trade promotions and advertising) and demand indicators (such as social media activity) originating from each distribution channel. As information proliferates, the data concerning these causes and demand indicators become both more accessible and more manageable over time. Machine learning systems therefore can integrate and usefully model these important new data sources, including detailed market data, machine telemetry, and social media feeds, in ways that are simply not possible with legacy planning systems.
What does this mean in practical terms? For one thing, it means companies can take advantage of valuable data signals that are generated closer to the consumer, including data from points of sale and social media channels. This enables companies to understand the impact of demand drivers such as media, promotions, and new product introductions, and to then use that knowledge to significantly improve forecast quality and detail.
Could you benefit from machine learning? Would machine learning technology be beneficial for your supply chain? One way to know is by finding out whether your old planning system may be causing escalating costs. Here are three potential signs of this problem, and how machine learning can help to address them:
Inflated safety-stock levels. You can't trust your safety-stock levels to deliver the required service levels, so you keep them artificially high. By taking more demand variables into account, machine learning can help companies with a diverse range of SKU profiles, including long-tail items, to set optimal, lower levels they can trust.
Planning team "burnout." Your team is spending too much time manually adjusting and evaluating forecasts, and often is still not able to deliver them accurately enough or on time. This leads to poor productivity and morale. Machine learning takes more demand variables into account and weights each according to its significance, resulting in much more accurate forecasts. This helps planners succeed in their roles and frees up time for them to refine forecasts using their personal insights and business knowledge.
An inefficient sales and operations planning (S&OP) process. Your consensus forecast from the S&OP is unreliable, or the collaboration process behind it is too slow to adapt to the dynamic nature of the market and SKU behavior. Machine learning's high level of automation can improve the quality of the short- and mid-term forecast by picking up key trends from transactional and promotional data and providing actionable insights about those trends, thereby making the S&OP process more efficient and effective in achieving your business objectives.
If any of these situations resonate, it's likely time to take a closer look at machine learning technology. This doesn't have to mean "ripping and replacing" your existing software. Granarolo, for example, implemented machine learning technology alongside its existing systems to boost performance. Companies that implement machine learning often find that it is easy to use, and that its ability to learn from existing data means that it takes relatively less time to implement, deliver benefits, and pay for itself.
In the not-too-distant future, most supply chains will rely on software that uses machine learning technology to analyze much larger, more diverse data sets. For companies that are serious about tackling today's complex forecasting problems, this new technology will prove an invaluable tool.
GRANAROLO S.p.A.
Forecasting scenario: The Italian dairy producer Granarolo runs thousands of promotions annually, producing 34,000 item-promotion forecasting combinations and causing demand peaks of up to 30 times baseline sales.
Supply chain environment: Eight production plants, six logistics technology platforms, 35 transit depots holding inventory, a large fleet of refrigerated vehicles, and about 750 merchandisers servicing daily sales. A network of 100 wholesale distributors covers other local markets.
Benefits from machine learning: Granarolo's average forecast reliability has increased from 80 percent to 85 percent and is peaking at 95 percent for fresh milk and cream and 88 percent for yogurt and dessert products. Inventory levels and delivery times have been halved, resulting in fresher products and less waste. Overall, Granarolo has significantly raised customer service levels and sales while at the same time reducing transportation costs.
Â
LENNOX INTERNATIONAL INC.
Forecasting scenario: Lennox, a U.S.-based manufacturer of heating, ventilation, and cooling equipment, had to manage an ambitious expansion of its North American distribution network while transitioning to a three-tier design that included regional distribution centers. Lennox would have to implement this change while maintaining high service levels in both its finished-goods and aftermarket-parts businesses, and in an environment encompassing fast-moving to very slow-moving items, strong seasonality, and demand variability.
Supply chain environment: The company was shifting from a multiechelon distribution network with more than 80 locations to a network of more than 130 locations in the United States and Canada. This expansion involved:
Moving from 450,000 finished-goods and spare-parts stock-keeping unit (SKU) locations to more than 700,000
Tens of millions of dollars tied up in inventories, including a "long tail" (98 percent of SKUs responsible for 62 percent of revenues) and many slow movers with classic "lumpy" demand that is uneven in terms of timing and quantity
Many new-product introductions; in one recent year, nearly 50 percent of the finished-goods product line was replaced with new models
High product-availability targets, including 75 percent of orders for next-day delivery and 20 percent of sales to installers and contractors who need same-day pickup
Assured serviceability on finished goods for 15+ years
Highly variable independent demand, driven by external factors that are difficult to model (for example, weather and macroeconomic conditions)
Highly seasonal demand (air conditioning and heating), with little retail buffer
Benefits from machine learning: Lennox was able to automate its planning process and create an improved inventory mix over its widespread distribution network. Despite aggressively growing its distribution network by 30 percent in two years, Lennox has already cut stockouts by more than half, from 9 percent down to 4 percent, and trending toward further improvement.
J.B. Hunt President and CEO Shelley Simpson answers a question from the audience at the Tuesday afternoon keynote session at CSCMP's EDGE Conference. CSCMP President and CEO Mark Baxa listens attentively to her response.
Most of the time when CEOs present at an industry conference, they like to talk about their companies’ success stories. Not J.B. Hunt’s Shelley Simpson. Speaking today at the Council of Supply Chain Management Professionals’ (CSCMP) annual EDGE Conference, the trucking company’s president and CEO led with a story about a time that the company lost a major customer.
According to Simpson, the company had a customer of their dedicated contract business in 2001 that was consistently making late shipments with no lead time. “We were working like crazy to try to satisfy them, and lost their business,” Simpson said.
When the team at J.B. Hunt later met with the customer’s chief supply chain officer, they related all they had been doing for the company. “We told him that we were literally sitting our drivers and our trucks just for you, just to cover your shipments,” Simpson said. “And he said to us, ‘You never shared everything you were doing for us.’”
Out of that experience, came J.B. Hunt’s Customer Value Delivery framework. This framework, according to Simpson, provides a roadmap for creating value and anticipating customer needs.
Framework for Excellence
J.B. Hunt created the above framework to help them formulate better relationships with customers.
The framework consists of five steps:
Understand customer needs: It all starts, according to Simpson, with building a strong relationship with the customer and then using the information gained from those discussions to build a custom plan for the customer.
Deliver expectations: This step involves delivering on the promises made in that custom plan.
Measure results: J.B. Hunt believes that they are not done when freight makes it to the destination. They also need to measure how successful they were versus what the customer expected from them.
Communicate performance: This step involves a two-way exchange, where J.B. Hunt walks the customer through their performance and gets verbal agreement on whether or not they have met the customer’s needs.
Anticipate new value: Here J.B. Hunt looks at what they are hearing from their customer today and then uses that information to derive what the customer may be looking for in the future.
Simpson said the most important part of the process is the fourth step, communicating performance (perhaps reflecting the piece that went wrong in that initial failed customer relationship).
Not only can this framework be used to drive excellence in a company, but it can also be adapted as a model for driving personal excellence, Simpson said. Instead of understanding the customer needs, the process starts with understanding yourself: what your strengths and interests are. This understanding helps drive a personal development plan and personal goals for the year, which can be measured and assessed. For example, each year, Simpson gives herself a letter grade on each of her personal goals and communicates her assessment back to her boss. She has also found it helpful to anticipate where opportunities lie beyond what she is personally doing.
Confronted with the closed ports, most companies can either route their imports to standard East Coast destinations and wait for the strike to clear, or else re-route those containers to West Coast sites, incurring a three week delay for extra sailing time plus another week required to truck those goods back east, Ron said in an interview at the Council of Supply Chain Management Professionals (CSCMP)’s EDGE Conference in Nashville.
However, Uber Freight says its latest platform updates offer a series of mitigation options, including alternative routings, pre-booked allocation and volume during peak season, and providing daily visibility reports on shipments impacted by routings via U.S. east and gulf coast ports. And Ron said the company can also leverage its pool of some 2.3 million truck drivers who have downloaded its smartphone app, targeting them with freight hauling opportunities in the affected regions by pricing those loads “appropriately” through its surge-pricing model.
“If this [strike] continues a month, we will see severe disruptions,” Ron said. “So we can offer them alternatives. We say, if one door is closed, we can open another door? But even with that, there are no magic solutions.”
Turning around a failing warehouse operation demands a similar methodology to how emergency room doctors triage troubled patients at the hospital, a speaker said today in a session at the Council of Supply Chain Management Professionals (CSCMP)’s EDGE Conference in Nashville.
There are many reasons that a warehouse might start to miss its targets, such as a sudden volume increase or a new IT system implementation gone wrong, said Adri McCaskill, general manager for iPlan’s Warehouse Management business unit. But whatever the cause, the basic rescue strategy is the same: “Just like medicine, you do triage,” she said. “The most life-threatening problem we try to solve first. And only then, once we’ve stopped the bleeding, we can move on.”
In McCaskill’s comparison, just as a doctor might have to break some ribs through energetic CPR to get a patient’s heart beating again, a failing warehouse might need to recover by “breaking some ribs” in a business sense, such as making management changes or stock write-downs.
Once the business has made some stopgap solutions to “stop the bleeding,” it can proceed to a disciplined recovery, she said. And to reach their final goal, managers can use the classic tools of people, process, and technology to improve what she called the three most important key performance indicators (KPIs): on time in full (OTIF), inventory accuracy, and staff turnover.
CSCMP EDGE attendees gathered Tuesday afternoon for an update and outlook on the truckload (TL) market, which is on the upswing following the longest down cycle in recorded history. Kevin Adamik of RXO (formerly Coyote Logistics), offered an overview of truckload market cycles, highlighting major trends from the recent freight recession and providing an update on where the TL cycle is now.
EDGE 2024, sponsored by the Council of Supply Chain Management Professionals (CSCMP), is taking place this week in Nashville.
Citing data from the Coyote Curve index (which measures year-over-year changes in spot market rates) and other sources, Adamik outlined the dynamics of the TL market. He explained that the last cycle—which lasted from about 2019 to 2024—was longer than the typical three to four-year market cycle, marked by volatile conditions spurred by the Covid-19 pandemic. That cycle is behind us now, he said, adding that the market has reached equilibrium and is headed toward an inflationary environment.
Adamik also told attendees that he expects the new TL cycle to be marked by far less volatility, with a return to more typical conditions. And he offered a slate of supply and demand trends to note as the industry moves into the new cycle.
Supply trends include:
Carrier operating authorities are declining;
Employment in the trucking industry is declining;
Private fleets have expanded, but the expansion has stopped;
Truckload orders are falling.
Demand trends include:
Consumer spending is stable, but is still more service-centric and less goods-intensive;
After a steep decline, imports are on the rise;
Freight volumes have been sluggish but are showing signs of life.
CSCMP EDGE runs through Wednesday, October 2, at Nashville’s Gaylord Opryland Hotel & Resort.
The relationship between shippers and third-party logistics services providers (3PLs) is at the core of successful supply chain management—so getting that relationship right is vital. A panel of industry experts from both sides of the aisle weighed in on what it takes to create strong 3PL/shipper partnerships on day two of the CSCMP EDGE conference, being held this week in Nashville.
Trust, empathy, and transparency ranked high on the list of key elements required for success in all aspects of the partnership, but there are some specifics for each step of the journey. The panel recommended a handful of actions that should take place early on, including:
Establish relationships.
For 3PLs, understand and get to the heart of the shipper’s data.
Also for 3PLs: Understand the shipper’s reason for outsourcing to a 3PL, along with the shipper’s ultimate goals.
Understand company cultures and be sure they align.
Nurture long-term relationships with good communication.
For shippers, be transparent so that the 3PL fully understands your business.
And there are also some “non-negotiables” when it comes to managing the relationship:
3PLs must demonstrate their commitment to engaging with the shipper’s personnel.
3PLs must also demonstrate their commitment to process discipline, continuous improvement, and innovation.
Shippers should ensure that they understand the 3PL’s demonstrated implementation capabilities—ask to visit established clients.
Trust—which takes longer to establish than both sides may expect.
EDGE 2024 is sponsored by the Council of Supply Chain Management Professionals (CSCMP) and runs through Wednesday, October 2, at the Gaylord Opryland Resort & Convention Center in Nashville.