CPG New Product Stock Simulator in Anaplan for Quick Analysis

company overview

This multi-billion dollar beverage company, headquartered in Atlanta, Georgia, is a multinational corporation, and manufacturer, retailer, and marketer of non-alcoholic bottled beverages, beverage concentrates and syrups. This company specializes in producing syrup concentrates, which are then sold to bottlers around the world. They have beverages sold in over 200 countries, under more than 500 brands.

download case study
Consumer Packaged Goods
Food & Beverage
Service category
Supply Chain
download case study
The Challenge

The company's product services team had no standardized process in place for answering important product launch questions, such as how long a new product launch would take, whether there was enough inventory to cover the launch, or what the costs related to the new launch would be. Each individual on the product services team was performing manual work in Excel to answer these frequent questions.

The Results

The Stock Simulator tool in Anaplan provides efficient and centralized analysis of new simulation requests. This tool allows for the creation of several scenarios under each simulation and provides metrics, such as material constraints, stock value, shelf life, and lead times. Additionally, this tool allows for the mitigation of constraints by overriding volumes and provides updated scenario comparison reports.

Using the Stock Simulator tool, the product services team now has a clear, standard workflow process that replaces the previous manual data entry, providing the organization increased accuracy, better collaboration routines, and quicker analysis and metrics.

The Solution

The beverage giant partnered with Accelytics to automate the ad-hoc Stock Simulation process in Anaplan. The Stock Simulation uses imported data, including history and forecast, bill of material (BOM), available stock, and master data for products, which allows users to set up a series of scenarios in Anaplan.

The Scenario Summary dashboard will have several KPIs displayed, such as unfilled, partial, and filled inventory demand by week, timing and volume of raw material with constraints, amount of inventory possible to deliver on time, and inventory value.

The solution also provides Material Manager and Material Scheduler dashboards for a view of the actions that need to be taken to fill the scenario’s demand (i.e. purchase and production plans).

Back to all

Are you ready for transformation?

Work smarter, not harder. Reach out now!

get started