Skip to content
Enhanced Forecasting Worksheet app iconEnhanced Forecasting WorksheetFeature

Forecast Periods and Confidence Level for Microsoft Dynamics 365 Business Central

A forecast is only useful in the time buckets planners work in. A monthly plan needs monthly numbers, and how much history the forecast looks at changes what it predicts.

Enhanced Forecasting Worksheet lets the planner choose the period type, the number of forecast periods, the number of past periods of history, and the confidence level for each run.

How Forecast periods and confidence level works in Enhanced Forecasting Worksheet

  1. The planner chooses the period type.
  2. The planner sets the number of forecast periods and past periods.
  3. The planner sets the confidence level.
  4. The planner calculates the forecast and reviews predicted values by period.

Key capabilities

Period type

Choose week, month, quarter, or year. Predicted values come back in those buckets, with a forecast starting and ending date on each row.

How far ahead

No. of Forecast Periods sets how many periods to predict, for example the next three months.

How far back

No. of Past Periods sets how much sales history to send, for example the last 15 or 18 months.

Confidence level

Set the confidence level for the run. Confidence fields can be shown on the worksheet through personalization.

Tied to planning values

The period choice also shapes the planning expressions, for example a quarterly forecast used to set reorder points for the next quarter.

See Forecast periods and confidence level on screen

Real screens from Enhanced Forecasting Worksheet, shown with demo data.

Details that matter on the floor

Match the planning rhythm

Choosing the period type to match how the team plans keeps the forecast directly usable, whether that is a monthly demand forecast or a quarterly review of reorder points.

History shorter than asked

If an item has less history than the past periods requested, Enhanced Forecasting Worksheet offers to use the history it found. See Sales History Check.

Who uses Forecast periods and confidence level

Supply chain planners

Forecast in the same buckets the plan uses.

Inventory managers

Use a longer history window for seasonal items.

Questions about Forecast periods and confidence level

Can I forecast by week or quarter in Business Central?

With Enhanced Forecasting Worksheet, choose week, month, quarter, or year as the period type, and set how many periods to forecast and how many past periods to use.

How much history should I use?

Enough posted sales history to represent the item's demand pattern. The past periods setting decides how much history is sent; if less exists, Enhanced Forecasting Worksheet offers to use what it found.

Can I see the confidence level in the results?

Yes. Confidence and other fields, such as deltas and 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 Forecast periods and confidence level?

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