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
- The planner filters to a group of items with a similar demand pattern.
- The planner chooses a forecasting algorithm.
- The planner calculates the forecast and reviews the results.
- 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.
Related Enhanced Forecasting Worksheet features
All Enhanced Forecasting Worksheet features →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.