Skip to content
Enhanced Forecasting Worksheet app iconEnhanced Forecasting WorksheetFeature

Forecasting Algorithms for Microsoft Dynamics 365 Business Central

Demand patterns differ. A steady seller, a seasonal line, and a product with short shelf life do not forecast well with the same method.

Enhanced Forecasting Worksheet lets the planner choose from six forecasting algorithms for a run, so the method suits the items being forecast.

How Forecasting algorithms works in Enhanced Forecasting Worksheet

  1. The planner filters to a group of items with a similar demand pattern.
  2. The planner chooses a forecasting algorithm.
  3. The planner calculates the forecast and reviews the results.
  4. The planner compares runs if needed, then sends the chosen results on.

Key capabilities

A choice per run

Select the algorithm before calculating, so a seasonal category and a steady category can be forecast differently.

Visible in the results

The algorithm used can be shown on the worksheet through personalization, which helps when comparing runs.

Same workflow

Whatever the algorithm, results land in the same worksheet and go to the demand forecast or item planning the same way.

Paired with history settings

Algorithm choice works with the period and history settings to shape each forecast.

Details that matter on the floor

Fit the method to the items

Grouping items by demand pattern and choosing an algorithm for each group gives the planner more control than one method for everything.

Perishable and late-arriving demand

For products with short shelf life or demand that arrives late, the choice of algorithm is one way to adjust the forecast to the pattern.

Who uses Forecasting algorithms

Supply chain planners

Choose the method that suits each product group.

Inventory managers

Compare results from different algorithms before acting.

Questions about Forecasting algorithms

Can I choose the forecasting algorithm in Business Central?

With Enhanced Forecasting Worksheet, yes. Choose from six forecasting algorithms for each run.

Which algorithm should I use?

The one that fits the demand pattern of the items in the run. Running the same items with different algorithms and comparing the results is a practical way to decide.

Can I see which algorithm produced a result?

Yes. The algorithm used can be shown on the worksheet through personalization.

Enhanced Forecasting Worksheet app icon

Part of Enhanced Forecasting Worksheet

Precise, customizable inventory forecasting to prevent stockouts and optimize stock levels.

Have a question about Forecasting algorithms?

Send us a note and the Enhanced Forecasting Worksheet team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.

Ask a product question

Product Questions