Sales forecast

The sales forecast is a key feature of Demand Planner as it is used to predict future sales. It is used as input for replenishment suggestions. The forecast can be accessed via the left side menu.

mceclip0.png

The controls at the top of the Edit forecast page can be used to filter by warehouse, change how the forecast is grouped (by variant, product, category, etc.), change the date range, specify the metrics to show in the report and filter by any attribute or metric.

Forecasts can also be viewed for individual variants, products, categories, brands, etc. by clicking the Details icon mceclip2.png(this appears in various places throughout Demand Planner) and navigating to the Edit forecast tab.

mceclip1.png

Forecasting method

The default forecasting method in Demand Planner uses historical sales data for each product; the sales velocity is used excluding periods of time when a product is out-of-stock. Recent sales trends are also taken into account. 

The forecast will cover the days of stock presuming there is inventory. For example, if days of stock are set to 60 days, the forecast will predict sales for 60 days presuming your stock is fully stocked. Note that replenishment will show stock needed to be fully stocked for that amount of time, where as the forecast looks at predicted sales.

The forecast is recomputed automatically each day.

Forecast settings

The following can be configured globally and on a variant level:

Excluding sales from the forecast

By default, all sales are included in the forecast. However, it may be preferable to exclude certain sales, such as drafts and quotes. Please contact Brightpearl Support providing a list of the order statuses you wish to include or exclude and this will be configured in your account.

 

Have more questions? Submit a request