Director of Demand and Supply Planning
Get the right flavor, right time at the right store
SAS® helps Nestlé improve forecasting accuracy, increase service levels and plan profitable promotions
Nestlé Direct Store Delivery improved forecasting accuracy four percentage points and increased service levels with help from SAS® Demand-Driven Forecasting. Despite growing revenues, the company is able to hold inventory costs flat, and its sales force can better plan profitable sales promotions. Company officials say the savings have exceeded expectations.
Pizza and ice cream are seasonal and promotion-driven, and variety has exploded in recent years. Twenty years ago, consumers could choose from a dozen pizza varieties and similar number of ice cream flavors. Today, there are whole wheat crusts, gourmet toppings, no-sugar-added ice cream blends and seasonal flavors like pumpkin. With so much variety, shelf space is at a premium, making it critical for producers to ship the right amount of product to the right store at the right time. Meanwhile, Nestlé must make sure product doesn't sit too long at distribution centers, not just to reduce carrying costs but also to provide customers with the freshest, best quality products.
Managing a promotion-driven business
The heavy promotional nature of ice cream and pizza also causes demand to wax and wane by store or region. Before using SAS, Nestlé demand planners struggled to factor in the impact of promotions. The NDSD Supply Chain was also guessing at how much product needed to be stocked for special promotions designed to drive volume – and the sales team on what price to select to maximize profit. "Our existing solutions did a poor job of forecasting demand around promotions," explains Geoff Fisher, Director of Demand and Supply Planning for Nestlé.
Data was also scattered in numerous locations. Some of it was sitting in spreadsheets in regional offices and might get sent in once a week, if that. In the division that handles delivery to drugstore chains (a growing business), forecast accuracy was decreasing by the year. "It was driving a lot of service issues and increasing our carrying costs," explains Bill Grah, Senior Manager for Strategic Sourcing.
Choosing a demand-driven solution
Nestlé wanted a robust, scalable and high-speed solution that didn't require planners to spend the majority of their time administering the data, and a user-friendly reporting system. It was also looking for a vendor known for investing in customer success, and a solution that is workable for a demand planner but also sophisticated enough to be used by a statistician. "At that point the vendor list got pretty short," Fisher says, adding that SAS was the only company that could show it had successfully provided complex, demand-driven forecasting solutions to multiple similar-sized enterprises. As part of the selection process, SAS ran a proof of concept that quickly suggested the potential of the solution.
"When we switched to SAS, we saw our forecast accuracy improve immediately, we saw service take off in a positive way, and our inventories decreased," says Grah. "We actually exceeded our original projections," says Arnaud Joliff, Director of Supply Chain Integration, adding, "Forecast accuracy improvement drives safety stock, inventory days on hand, storage costs and freight costs reduction. By gaining a few points of accuracy at the national level you can generate supply chain savings immediately." The accurate forecasts have even benefited areas such as efficient route planning.
The accuracy is driven by a change from a 50,000-foot view of forecasts to a more detailed look. "We can talk about a particular deal with a retailer and know what kind of lift is generated, and then that drives the supply chain," Grah says. "There is no second-guessing."
Creating synergy between sales and planning
With SAS, we're better able to accomplish our goal of right flavor, right time, right store.
SAS Demand-Driven Forecasting interacts with the Nestlé sales team's promotional planning system. The sales team will enter in its promotion details and SAS will project the associated lifts. These promotional plans are then used to drive the forecast used by the supply chain group to ensure product is available to meet consumer demand. The sales teams have the capability to measure the impact of in-store merchandising vehicles like end cap displays to determine the incremental unit volume impact, as well as revenue impact within designated market channels (e.g., retail grocery channel).
Using SAS, the demand planners can make calculations and let salespeople know, for instance, that there isn't enough pepperoni in the pipeline near their territory to meet the estimated volume that the promotion will generate, and then work with sales to find a better promotion. They can also help sales calculate the lift for a promotion, and whether that sales increase – at that price – will make the promotion profitable. "It takes the subjectivity out of it," Grah says.
Critical to this service is that Fisher's staff doesn't need an entire weekend – or even an afternoon – to compute the data, including tens of thousands of time series calculations. When it took a long time to run data, information was released on a rigid schedule and was sometimes out of date. With SAS, it takes a few minutes to update information, so planners can publish as they update. "It's a better answer that gets out faster," Fisher says.
Achieving lasting ROI
Nestlé wants to use SAS to build additional attributes into its forecasts to further enhance the data visibility to sales and promotions. Having a better understanding of competitor activities, weather and event cannibalization on existing sales are some of the areas under review. "We are trying to understand if our promotions are impacting sales of other products," Grah explains.
Fisher says while overall forecast improvement is at 4 percentage points, some specific forecasting projects netted forecast accuracy increases of 7 percentage points or better.
With confidence in the forecasts, "People are letting that number drive through the whole organization, affecting what we produce, where we're going to ship, all the way up to our top-line financial commitments. This drives all facets of our business," Fisher says.
"With SAS, we're better able to accomplish our goal of right flavor, right time, right store," Fisher says. "It's hard to put a price tag on it, but it is really invaluable in terms of running the business effectively and better serving the customer."
Forecast demand for ice cream and pizza to lower inventory holding costs, improve service levels and assist sales in planning profitable promotions.
Forecasts are four percentage points more accurate and service levels have improved. Supply chain is more efficient, and sales and demand planning work together to plan profitable promotions.