Skip to main content

4. Forecast Models

The different forecasting methodologies available in the Demand Planning workspace and when to use each one.

T
Written by Thilo Hamann

At every level of the hierarchy — total customer, product family, or individual item — you choose which forecasting model to use as your base. The model can be different at every level and is saved as your configured strategy for that node in the hierarchy.

4.1 The Two Base Model Types

Model Type

How It Works

Sales Forecast

Uses the Sales Forecast from the Sales Forecasting module as the base. Reflects the commercial team’s assumptions about promotions, new distribution, and lift. Best for new items, new customers, or situations where you want to fully align with the sales team’s view.

Statistical Forecast

Runs a model on your historical shipment data (baselined or raw) to project future shipments. Confido evaluates multiple models and suggests the best fit based on historical accuracy. Best for mature, steady-state customers with consistent shipment patterns.

Select the best fit strategy in your demand planning workspace.

4.2 Statistical Model Options

When you select a statistical forecast, Confido evaluates several model types and recommends the best fit based on which would have been most accurate historically (lowest MAPE). You can accept the recommendation or manually select a specific model:

  • Best Fit — Confido selects the most accurate model (bottom-up) for that customer/item automatically, applied at the item level within the customer

  • Moving Average — smooths out recent shipment trends; useful for steady, low-volatility customers. The lookback period can be configured by the demand planner.

  • Single Exponential Smoothing — weights recent data more heavily; responsive to recent trends. The alpha determines the weight this model places on the most recent periods. It is a value between 0 and 1, with 1 placing the highest weight on the latest periods.

  • Seasonal Naive — repeats last year’s pattern; useful for highly seasonal businesses with predictable year-over-year patterns

  • Holt-Winters — handles both trend and seasonality; good for growing brands with seasonal patterns

  • Croston’s Method — designed for intermittent or sporadic demand; good for slow-moving items

  • Prophet — probabilistic model; good for business time series with strong seasonal patterns

For each model, based on backtesting and cross-validation, Confido can display accuracy metrics including MAPE (Mean Absolute Percentage Error) and bias, so you can evaluate which model has performed best historically before committing to it.

4.3 Setting and Saving Model Strategies

When you select a model at any level of the hierarchy, it is saved as your configured strategy for that customer/product combination. The workspace always shows you which model is currently in use at the level you are viewing. If you run statistics at an aggregate level and different items within the hierarchy are using different models, the customer-level display will show “Composite” (this follows the bottom-up methodology).

4.4 Multi-Horizon Strategy

You can also select a forecast "strategy" that lets you use different baselines for different time horizons. For instance, you could base the forecast on the Sales Forecast for the first 3 months, then switch to Confido's Best Fit model for the remaining planning buckets. To set up a multi-horizon strategy, go to Strategy → Add Multihorizon Strategy → Add Review Step, and select your options.

4.5 Forecasting methodology in Confido

The picture below summarizes the approach Confido is taking to statistical forecasting in demand planning.

Did this answer your question?