CPG New Product Stock Simulator in Anaplan for Quick Analysis

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 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 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).

‍

‍