3. Generate a Statistical Forecast: The Demand Planning software looks at the historical data and tries to find a “best fit” model for individual SKUs or SKU families. This will vary from company to company and even SKUs within a company. Most Demand Planning software can select from several statistical methods to identify the best forecast approach for each SKU.
4. Prepare Forecasts for New Product Introductions: Plans and relationships for new products must be created in the system (e.g., what customers will buy them), and then forecast. Demand Planning systems will enable a forecaster to choose a product thought to have a sales trajectory similar to the new product to use as the starting point, and some systems allow users to combine profiles of two SKUs to create the new one.
5. Override the Statistical Forecast with Judgmental Input: Insight from a variety of sources might be used to change the statistical forecast generated by the Demand Planning system. For example, strong input from sales channels, or changes in market conditions, might affect the statistical view. Tweaks might also be necessary to account for different time periods in the forecast horizon (e.g., number of sales days this year).
The result of these changes is the “baseline forecast,” which is equal to the statistical forecas, plus or minus these adjustments.
6. Adjust the Baseline Forecast for Promotions: In many industries, especially consumer goods, promotions have a huge impact on sales volumes, and obviously need to be factored in for changes to the baseline forecast. Specific trade promotions with retail channels can be uniquely identified within the system and used to adjust forecast numbers.
Often, planners like to communicate both a forecast with promotional effects and one without to various stakeholders.
A good Demand Planning system should also be able to consider the potential cannibalization effect of promotions – a promotion for a given product or family could have a negative effect on sales in another product area.
7. Manage VMI and CPFR Processes: If the company is involved with Vendor Managed Inventory (VMI) programs, or is using Collaborative Planning, Forecasting and Replenishment (CPFR) with its customers, there is another step to communicate that data to both customers and internal managers responsible for these programs.
Customers may share data through the CPFR process, for example, that causes the current forecast to be raised or lowered.
8. Generate a “One Number” Forecast: Increasingly, the first seven steps are used to provide data for a Sales and Operations Planning process (S&OP) that brings together executives from key areas of the company to ultimately agree on a single forecast number and an execution plan that will drive both the demand and supply sides of the enterprise.
Urs also sees the development of web-enabled Demand Planning systems as having big benefits to the process, such as enabling data to be more easily shared and received from customers and sales channels, and in enabling sales reps to enter data and information for example through a cell phone interface.
He also says that most Demand Planning system deployments today are based on a 5-tiered technical architecture:
- The User Interface
- Web Services
- Business Logic
- Memory Resident Databases
- Databases/Data Warehouses
What would you add to this 8-step forecasting process described above? Have web-based Demand Planning tools made a big difference in the process? Let us know your thoughts at the Feedback button below.