7.9.3 Table
The Table of the Item view shows information about the item selected in the tree view.
- Actual sales is the sales history loaded to Streamline.
- Statistical forecast is the result of statistical forecasting.
- Final Forecast overrides are the statistical forecast overrides that are made manually.
- Average sales price (if available) is the sales price averaged through the data aggregation period. This row is shown only if the sales prices were imported. Data for this row can be changed manually.
- Forecast version (disabled by default) row is shown when an additional forecast version was created using the Forecast versions button.
- Confidence limits (disabled by default) are potential forecast variability boundaries.
- Revenue (if available) is calculated based on the averaged sales price in the data history period and based on the current (or adjusted) sales price for the forecast period. This row is only shown if the sales prices were imported.
- On hand (if available) shows the inventory on hand at the end of the period. You can manually override the data of this row.
- Stockout days shows the number of days in the period you had run out of inventory. This characteristic is calculated by Streamline automatically when transactions are imported and can be changed manually.
- Projected inventory levels (if available) shows the expected inventory at the end of the period based on the forecasts. It is available if inventory information was imported.
- Ordering plan indicates the quantities that should be ordered in the corresponding periods.
- To ship shows the amount of goods to be shipped.
- Ignore actual sales allows a user to mark time periods that have to be excluded from the sales history that for any reason was not representative for the business.
- Ordering availability (disabled by default) feature is used to forbid Streamline to generate purchase orders in given periods in the future.
Context Menu
Context menu of the Table contains commonly used operations as:
- Add Note…. Adds a note to the selected cell.
- Propagate value command propagates the value of the selected cell to the right until the first non-empty cell is reached. If a cell contains a formula, the propagation command populates empty cells with this formula (not the value).
- Apply cell to Final forecast implements the value of the selected cell to the Final forecast overrides cell of the same period.
- Apply row to Final forecast implements the values of the whole row to the Final forecast overrides row.
- Export to XLSX… exports the table into Excel.