Create a Demand Forecast

You can create sales and production forecasts with the Demand Forecasts list page. Then, for each forecast, you specify various settings for that forecast in the Demand Forecast Overview page.

Forecasting functionality is used to create anticipated demand; actual demand is created from sales and production orders. During creation of the Master Production Schedule (MPS), the forecast is netted against the sales and production orders. The Forecast Type field on the forecast determines which type of requirements to take into consideration in the netting process. If the forecast is for a sales item, only sales orders net the forecast. If it is for components, only dependent demand from production order components net the forecast.

Forecasting allows your company to create "what if" scenarios and efficiently and cost-effectively plan for and meet demand. Accurate forecasting can make a critical difference in customer satisfaction levels with regard to order promising dates and on-time delivery.

With 2022 release wave 1, you can also define the right level of details in the Forecast by Location and Forecast by Variant fields in the Demand Forecast Overview page. Filters and other settings are stored in the Demand Forecast Name table. So you can easily stop and continue your work later. If your organisation has been updated to 2022 release wave 1, you must switch on the new experience in the Feature Management page.

Sales Forecasts and Production Forecasts

The forecasting functionality in application can be used to create sales or production forecasts, in combination or independently. For example, most make-to-order companies do not carry finished goods inventory, because each item is produced when it is ordered. Anticipating orders (sales forecasting) is critical for a reasonable turnaround time on the finished goods (production forecasting). As an example, component parts with lengthy delivery times, if not on order or on inventory, can delay production.

  • The sales forecast is the sales department's best guess at what will be sold in the future, and is specified by item and by period. However, the sales forecast is not always adequate for production.
  • The production forecast is the production planner's projection of how many end items and derived subassemblies to produce in specific periods to meet the forecasted sales.

In most cases, then, the production planner modifies the sales forecast to fit the conditions of production, yet still satisfies the sales forecast.

You create forecasts manually on the Demand Forecast page. Multiple forecasts can exist in the system, and are differentiated by name and type. Forecasts can be copied and edited as necessary.

Note

Only one forecast is valid for planning purposes at any time.

The forecast consists of a number of records each stating item number, forecast date, and forecasted quantity. The forecast of an item covers a period, which is defined by the forecast date and the forecast date of the next (later) forecast record. From a planning point of view, the forecasted quantity should be available at the start of the demand period.

You must designate a forecast as Sales Item, Component, or Both. The forecast type Sales Item is used for sales forecasting. The production forecast is created using the Component type. The forecast type Both is only used to give the planner an overview of both the sales forecast and the production forecast. With this option, the forecast entries are not editable. By designating these forecast types here, you can use the same worksheet to enter a sales forecast as you do a production forecast, and use the same sheet to view both forecasts simultaneously. Note that the system treats the different inputs (sales and production) differently when calculating planning, based on item, manufacturing, and production setup.

Component Forecast

The component forecast can be seen as an option forecast in relation to a parent item. This can, for example, be useful if the planner can estimate the demand for the component.

Because the component forecast is designed to define options for a parent item, the component forecast should be less than or equal to the sales item forecast quantity. If the component forecast is higher than the sales item forecast, the system treats the difference between these two types of forecasts as independent demand.

Forecasting Periods

The forecast period is valid from its starting date until the date the next forecast starts. The time interval page gives you multiple choices to insert the demand at a specific date in a period. It is therefore recommended not to change the forecast period scope unless you want to move all forecast entries to the starting date of this period.

Forecast by Locations

On the Manufacturing Setup page you can specify whether you want to consider the locations that are defined on forecasts when you calculate plans.

Use forecast by locations

If you turn on the Use Forecast by Location toggle, Business Central will respect any location codes that are specified for each demand forecast entry and calculate the remaining forecast for each location.

Consider this example: Your company purchases and sells items on two locations: EAST and WEST. For both locations, you have configured a lot-to-lot reordering policy. You create a forecast for the two locations:

  • 10 pieces for location EAST
  • 4 pieces for location WEST

Then, you create a sales order with a quantity of 12 on location WEST. The planning system will suggest that you do the following:

  • Replenish 10 pieces for location EAST, based on data from the forecast.
  • Replenish 12 pieces for location WEST, based on the sales order. The four pieces that were specified in the forecast are fully consumed by the actual demand of the sales order. For more information, see Forecast Demand is Reduced by Sales Orders.

Note

If location-based forecasts are viewed in isolation, the overall forecast might not be representative.

Do not use forecast by locations

If you turn off the Use Forecast by Location toggle, Business Central will ignore the location codes that are specified for each demand forecast entry and aggregate the forecasts into a forecast for empty locations.

Consider this example: Your company purchases and sells items on two locations: EAST and WEST. For both locations, you have configured a lot-to-lot reordering policy. You create a forecast for the two locations:

  • 10 pieces for location EAST
  • 4 pieces for location WEST

Then, you create a sales order with a quantity of 12 on location WEST. The planning system will suggest that you do the following:

  • Replenish 12 pieces for location WEST, based on the sales order.
  • Replenish 2 pieces for the empty location. The 10 and 4 pieces that were specified in the forecast are partially consumed by the actual demand of the sales order. Business Central ignored the location codes that were specified by the user and uses a blank location instead.

Note

You can set a filter by locations, but location-based results might not match planning results without filters.

To create a demand forecast

  1. Choose the Lightbulb that opens the Tell Me feature. icon, enter Demand Forecast, and then choose the related link.
  2. On the General FastTab, select a forecast in the Demand Forecast Name field. Multiple forecasts can exist and are differentiated by name and forecast type.
  3. In the Location Filter field , select the location to which this forecast will apply.
  4. In the View by field to change the period that is displayed in each column. You can select from the following intervals: Day, Week, Month, Quarter, Year, or the Accounting Period as set up in your finance area.

Note

You should consider which time interval that you want to use for future forecasts so that the time interval is consistent throughout. When you enter a forecast quantity, it is valid on the first day of the time interval that you select. For example, if you select a month, then you enter the forecast quantity on the first day of the month. If you select a quarter, then you enter the forecast quantity on the first day of the first month in the quarter.

  1. In the View as field, select how the forecast quantities are shown for the time interval. If you select Net Change, then the net change in balance is displayed for the time interval. If you select Balance at Date, then the page displays the balance as at the last day in the time interval.
  2. In the Forecast Type field, select Sales Item, Component, or Both. If you select Sales Item or Component, then you can edit the quantity by period. If you select Both, then you cannot edit the quantity, but you can choose the drop-down arrow button and view the demand forecast entries.
  3. Specify a Date Filter if you want to limit the amount of data displayed.
  4. On the Demand Forecast Matrix FastTab, enter the forecasted quantities by typing a quantity in the cell representing an item on a particular date or period. Note that in empty cells, the lookup button opens an empty page indicating that you must enter a value manually.

Note

You can also edit an existing forecast. On the Demand Forecast Matrix page, choose the Copy Demand Forecast action and populate the Demand Forecast page with an existing forecast. You can then edit quantities as appropriate.

See Also

Setting Up Manufacturing
Manufacturing Inventory
Purchasing
Design Details: Supply Planning
Setup Best Practices: Supply Planning
Work with Business Central

Find free e-learning modules for Business Central here