User Tools

Site Tools


Menu

Company Website

Video Tutorials

Documentation for Streamline 4.x

User Guide

1. General Information

2. Starting Up

3. Connecting data

4. Demand and Sales Forecasting

5. Inventory Planning

6. Reference

Action disabled: source
historical-data-corrections

4.5.4. Historical Data Corrections

Streamline enables making corrections to imported sales, on-hand and stockout days’ histories. This is especially useful when the history has some irregular data that should be amended prior to forecasting.

Watch a video tutorial (0:19)

 

The histories can only be changed at the lowermost level of the Tree view. To revert to the original value, just clear the correction. All changes are displayed in blue. To put modifications into effect, re-forecast the project by clicking the Forecast button.

Modifying Sales History

To modify actual sales:

  1. Go to the Demand forecasting tab.
  2. Select the node in the Tree view.
  3. Click the yellow cell in the Actual sales row of the Table view.
  4. Enter a new value and press Enter.

Once a correction has been made:

  • The selected node in the Tree view and the correction in the Table view will show in blue.
  • The Plot view is updated.

Modifying On-hand History

To modify historical on-hand:

  1. Go to the Demand forecasting tab.
  2. Select the node in the Tree view.
  3. Click the yellow cell in the On hand row of the Table view.
  4. Enter a new value and press Enter.

Modifying Stockout Days’ History

Streamline automatically calculates the stockout days parameter when it imports transactions. This indicator tells how many days in the period we had run out of stock. This can be modified manually, allowing Streamline to better evaluate the model when forecasting. In this case, Streamline reviews the demand in this period based on the given number of stockout days and assigns a lower weight to the sales data when the model is built.

To change the stockout days number:

  1. Go to the Demand forecasting tab.
  2. Select the node in the Tree view.
  3. Click the yellow cell in the Stockout days row of the Table view.
  4. Enter a new value and press Enter.


Next: Accounting for Lost Sales

Download PDF

historical-data-corrections.txt · Last modified: 2019/05/13 10:47 by tyler