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

historical-reports

6.8.1. Historical reports

Historical reports display information in the past based on imported, overridden, and calculated data. These reports include:

Below, we describe these reports in detail.

Forecast Error Report

The Forecast error report helps you to evaluate the forecast using MAPE. This measure uses the difference between actual data and the forecast. Thus this report can be calculated only when the Period control is set to any option, except the last period.

To demonstrate the report, we open the Inventory Planning by Month example and set the Period to Sep 2018 (see figure below).

Now, we have an evaluation of the forecasts for the first three months. The rest of the periods were not evaluated because we don't have actual data for those months.

The report data are the Absolute Percentage Error (APE) calculated for a particular planning item/period. The formula for APE is the following:

APE = 100% * delim{|}{{F - A}/A}{|},

where:

  • F – the forecast for a particular period; and
  • A – the actual demand in this period.

The report data might have gaps or even empty rows. A gap occurs when there were no actual sales in the period. Streamline can’t calculate APE in this case. An empty row arises if either the item is inactive or an intermittent model is used.

The last column of the report represents MAPE calculated across all of the periods for each planning item.

The Overall MAPE, shown in the toolbar, is MAPE weighted across all the items in the project. It is a price-weighted MAPE measure representing the overall revenue percentage error if item prices are imported. Otherwise, it is calculated based on the volume of sales. You can read more about WMAPE on Wikipedia.

You can also switch the forecast quality measure between error and accuracy. To do this, click the Settings button found on the toolbar and select the Accuracy option for the Measure of forecast quality (see figure below).

Now, the report shows the percentage accuracy of the forecasts for each period in the Accuracy section and the average accuracy across the available evaluations in the Accuracy column (see figure below).

The Overall accuracy shown in the toolbar equals to 100% - Overall MAPE now.

Historical Revenue Report

This report shows the revenue obtained during each historical period based on the sales price/unit or transaction revenue data imported from the data source.

Historical Stock On Hand Report

This report displays on-hand at the end of each past period including the current period as well (see figure below).

This report is calculated if you provide data to detemine On-hand history, which is one of:

  • On hand change or On hand (as remaining) using the Transactional spreadsheet connection or Database connection.

The Number of periods control allows you to set up the number of the last periods to show in this report. As you see from the figure above, the report shows on-hand for the last eight months.

Historical Stockout Days Report

This report shows the number of days you had run out of stock for each period in the past. The current period is also included in this report.

This report is calculated if you provide data for On-hand history. The Number of periods control allows you to set up the number of the last periods to show in this report.

Historical Turnover Report

This report shows the turnover of each planning item in each historical period (see figure below).

A drop-down at the right of the Report control sets the representation units for this report. These are two options:

  • Turns – shows how many times an item was purchased and then sold out during a period. This is the default option
  • Days – indicates how many days it takes to make one turnover cycle.

Zero value in a period means that there were no sales during this period. An empty cell means that Streamline can't calculate turnover due to zero on-hand in that period. The Number of periods control sets the number of the last periods to show in this report.


Next: Projections Reports

Download PDF

historical-reports.txt · Last modified: 2019/10/17 15:34 by admin