7.9.5 Panel

The Panel of the Demand forecasting tab contains a set of properties and settings for forecasting, inventory planning, and key performance indicators. These properties and settings are set and displayed for the currently selected node in the Tree view. The Panel consists of the following tabs:

• Forecasting. It contains input settings for the forecasting process of the selected tree node. The settings can be set up at any level of the tree.

• Model. Shows the model that is used to generate forecasts for the selected planning item. The models are only available for the tree leaves.

• Inventory. Displays the inventory information on the currently selected planning item. This information is only available at the planning item level.

• KPIs. Depicts key performance indicators for the selected tree node. They can be viewed at every level of the tree.

The Forecasting tab holds options used as input information in the forecasting model building process. All the forecasting settings can be applied on an item, category or location level, generally, at every level of the tree. To put these settings into effect, re-forecast the project by clicking the Forecast button.

Here is the list of the forecasting settings:

• Forecast approach
• Model Type
• Ignore data before
• Ignore zero sales
• Ignore stockout days
• Multiplier
• Use price elasticity
• Use holidays
• Seasonality pattern
• Use promotions
• Use model from
• and adjust its level
• Material procurement
• Approval horizon
• Status

The Forecast approach control has the following options:

• Inherit. Applies the forecast approach of the parent item to this item. The applied approach is shown in the brackets.
• Bottom-up. This approach is used by default to build models for all nodes of the tree. It implies that forecasts on higher levels of the tree are calculated based on the forecast of lower levels as a simple sum, starting from tree leaves. Tree leaves models are standalone models that are calculated based on imported sales history.
• Top-down. This method implies that the item's forecast is calculated based on the parent item model and the market share the item forms in its parent category. The market share of the item is calculated based on the simple moving average of n last periods. This method is useful when the item has no prior history and you need to have some reasonable predictions, for example, in the situation of launching a new product.
• Top-down for child nodes. This approach combines the last two approaches in the following way: the Bottom-up method is applied to the selected item, and Top-down technique – to the item’s child nodes. In other words, in the example illustrated on the figure below, the forecast for the Building materials and equipments category is calculated using the Bottom-up approach, and the Concrete block and Nails are forecasted based on the Top-down method.

The Model Type gives access to manual selection of forecasting models. There are several options:

• Inherit. The model type of the parent node is used to generate the item’s forecast. Automatic selection. This is the default option meaning that Streamline's expert system is used to find the most appropriate model type.

• Seasonal & trend model includes seasonal and trend components.

• Linear trend model doesn’t show seasonality, but it consists of level and slope.

• Constant level model is just a constant value which is a mid-range level.

• Intermittent model is a model that has zero forecast. It changes the way the safety stock is calculated for this item.

• Preorder. No model is built; the item has zero forecast. This option is useful when an item is sold by preorder only.

• Inactive. Can only be chosen manually or imported to Streamline. It is usually selected for items that are no longer being sold. When selected, Streamline won’t build a model for this item, no forecast will be generated, and no safety stock will be calculated. Streamline does not generate a procurement plan for inactive items. The item will not appear in Planned orders and will only be kept for the historical record.

• Auto & preorder intermittent. Streamline’s expert system is used. If it recognizes intermittent demand in data, preorder model is used instead.

• Auto & termination. Streamline’s expert system is used. However, Streamline doesn't calculate a purchase plan for this item. This model is used when you need to know how the product will be consumed in the future based on the forecasts, but do not need Streamline to calculate the purchase plan for this product (the product is discontinued and/or is selling out, you have no possibilities to purchase it or any other reason).

Ignore data before control allows reducing the item’s sales history that is used to build the forecasting model. All the periods before the selected period are ignored. Data of the selected period is used to build the model. This option is helpful when you need to use a shorter length of history. For example, when sales volume has changed its level recently due to significant price change.

Ignore zero sales

• Yes: Streamline ignores time periods (months or weeks) when we had inventory but had no sales. So as a result, forecast will be higher that supposed to, because we don't consider lower than expected demand.
• No: Streamline considers time periods when we had inventory but had no sales, as a result, the forecast will be decreased, since we have lower demand.

Ignore stockout days:

• Yes: ignores all days that are identified as stockout days by Streamline, as a result, it lowers overall forecast
• No: Streamline considers all days when we didn't have enough inventory and as a result rises our forecast to make sure we don't have stockouts again

Multiplier. The result of the model will be multiplied by the multiplier. This option is used to increase or decrease the model output.

Use price elasticity

Feature considers not only qty sold in the past to generate a forecast but also notices the connection between an increase or decrease of sales and price change.

Use holidays enables taking into account holidays of the given calendar when Streamline is building the model for the item.

Seasonality pattern Allows to work with existing seasonal patterns or create new ones. For more see Seasonality pattern article.

Use promotions Feature considers promotions imported from data source. As for now, Streamline supports only percentage discount promos and in order for the feature to work, you need to have at least one promotion in the past and one for the future period.

Use model from Allows to copy a forecast from one item and apply it to another. Mostly used for brand new items if a similar item already exists on the market.

and adjust its level allows adjusting the level of the borrowed forecast to the level of the actual sales of the new item.

Material procurement parameter allows you to enable/disable manufacturing for the particular node of the data tree. This option gets into the action if bill of materials was imported.

• Manufacture sets the order type to Manufacturing for finished and intermediate items. This is the default option for such items.
• Purchase changes the order type from Manufacturing to Purchase for finished and intermediate items. Use this option if the item is currently purchased, not manufactured.

Approval horizon is a time fence feature that allows to lock forecast of approved time periods.

Status control helps you to set which forecasts are satisfied or need to be revised in the future. The control differs in the set of options whether a tree leaf or branch is currently selected. If a tree leaf is selected it has the following options:

• Undecided. This is the default option meaning that either the item forecast has not been reviewed yet, or the forecast was reviewed and the decision about its approval was not taken.
• Checked. This status is typically set when the forecast for an item looks good. The applied status only is a marking that doesn’t affect any other settings.
• Needs attention. This is a kind of reminder that is set when you are not sure which forecast correction to make at this time and have decided to make it later. An attention icon is added to the node and all the nodes above it to easily spot such items if the tree is collapsed. This status stays with the item whatever changes we made to the item's model in the Model tab.
• If a tree branch is selected, the Blank option is added to this control. This is the default option. Items (or categories) can have mixed statuses in this branch. If you apply any of Undecided, Approved or Needs attention statuses to the branch, Streamline applies it also to all the nodes in the tree the branch.

The Model tab shows the name of the model type chosen for the item, as well as the forecasting model structure and its coefficients in the table. Also, there’s a button “Save as pattern” that allows a user to save a particular set of coefficients to then apply that seasonality to another item. Read more.

You can adjust each of the coefficients of the model to align the forecast with your needs. Alternatively, to change the forecast, you can use the forecast overrides. Information on this tab is available only for the tree leaves. There are two types of models in Streamline, the time-series model and the intermittent demand model.

Generally, the model looks like:

An example of the time-series model is shown in the figure on the right. All cells with the yellow background are editable in Streamline.

An example of the time-series model is shown in the figure on the right. All cells with a yellow background are editable in Streamline.

• Seasonality component in the model formula is represented by the coefficients of twelve months in the table.
• Level is an average or moving average of actual sales, outliers are omitted during calculation.
• Slope is by how much (in pieces) the amount of sales increases or decreases every next period in Statistical forecast.
• Safety stock σ is unbiased standard deviation of the model on the learning set.
• Seasonality test shows how seasonal the data is based on the autocorrelation coefficient. If the test value is greater than a threshold, the seasonality component is used in the model. By default, the threshold is 0.3 and can be changed in the project settings.
• Model MAPE is the MAPE calculated based on the model response for the data that was used to build the model.
• Forecast MAPE is the MAPE of the forecast, it's only available when we forecast As of is set to some period in the past

Calculation of the forecasts

The exact formula to calculate the forecast for a period is:

Where:

• i is the number of the forecasted period;

• Nblue is the number of blue points in the Plot;

• seasonal coefficient is the seasonal coefficient of the month of i-th period. For weekly model, the seasonal coefficient is a linear combination of seasonal coefficients of two adjacent months; and

• holiday coefficient is a holiday coefficient that falls to this period.

Example

Consider an example of forecast calculation. We will use the build-in Streamline example of Multi-location Demand and Revenue Forecasting having monthly data.

Let’s take a look at the first item 00266-1 in the East location, and change the model Slope from 0 to 1.5 for demonstration purposes.

The model is built based on fourteen periods from November 2015 to December 2016. The forecasts of this model range from January 2017 to December 2017:

Let’s calculate the forecast for January 2017. It’s the first forecasted period, thus i = 1.

Several criteria trigger the intermittent demand model in Streamline. One of them - when a part of zero demand periods exceeds 60% of demand history length.

This model always returns ‘0’ as expected sales, but calculates Safety stock based on stochastic model of log-normal distribution. That is, the intermittent demand model expects that a log-normally-distributed transaction occurs with a probability of p, and no sales with probability 1-p.

The Median, Deviation, and Transaction probability are the parameters of the distribution which are estimated. Alternatively, you can set them manually in the Model tab.

The Deviation is given in orders of magnitude (o.o.m.). One order of magnitude is 10 times greater/less, so Deviation is usually very small.

There are three calculations for the item safety stock right below the Seasonality test row. The first one shows Safety stock calculated for one future period based on service level of 95%. The second one, for two periods. And the last one, for three periods. As you see, the more periods safety stock covers, the larger it supposes to be.

This model comes into play if the forecasted item has information on promotions imported and the data aggregation period is one week.

The promotional model is characterized by seven additional coefficients describing the future promotions weight into the generated forecasts (see figure on the right). Each of the coefficients corresponds to a particular day in the week.

The Inventory tab shows most of the columns of the Inventory planning tab. The table below shows a description of them.

The KPIs tab shows important performance indicators of the item.

• Inventory value shows the value of the item in stock.

• Days of supply shows how many days of the future demand, starting from the project date, the current On hand (including orders in transition) can cover.

• Expected overstock value indicates the value of the expected item overstock.

• Expected stockout value displays the value of the expected item shortage.

• Non-moving inventory value represents the balance value of the item in stock.

• Turnover | Turns/year shows how many times an item was purchased and then sold out for the last 12 months.

• Turnover | Days to sell indicates how many days it takes to complete one turnover cycle.

• Gross margin is a gross profit margin.

• Turn-earn index shows an item gross margin accumulated over the last 12 months.

• Annual revenue is the averaged item revenue over 12 months.

• Revenue next year indicates the expected item revenue for the next 12 months according to the forecasts.

Next: Confidence intervals

Download PDF