Depending on what you are going to do – generate demand plans, perform revenue forecasting, or optimize your inventory, Streamline needs different data to be imported. This section describes the necessary data for each case.
Sales history information is necessary to forecast demand. It is usually represented by a set of sales transactions in the database. Each transaction says what, when, and how many were sold.
The Sales history data includes the following:
If you need to forecast by location (such as a store, warehouse, or region) or channel, the Sale history should be extended with one of the following:
To plan your sales by item category (such as a product group) and/or location category (for example, build a hierarchy of Region > City > Store), you should provide the following data:
You can import as many categories as you need.
In addition to the Item code, you can import:
This information is also used to perform revenue-based ABC analysis and calculate selling price dependent KPIs such as annual revenue, revenue next year, gross margin, and turn-earn index.
To balance your demand with supply, generate purchase plans, and identify potential stockouts and overstocks, Streamline needs the Sales history to be extended with one of the following:
If On hand change is provided, then you should additionally provide the Last on hand – the item on hand at the time of import.
You should also provide:
If the Order cycle data and Lead time data have gaps or are completely missing, the default values (Order cycle = 1 month and the Lead time = 30 days) are loaded from the program settings.
The accuracy of inventory reports can be improved, if you additionally provide the information on pending sales orders and the Lead time variance.
In transition information
This information indicates which items are being delivered now from your supplier. The following data should be provided:
If locations are used, the Location should be provided as well.
If you do not know the delivery date, you can provide the PO sendout date – the date when the purchase order was placed. It is strongly recommended to provide Streamline with one of the Delivery date or PO sendout date. The former is preferable.
Pending Sales Orders
To calculate future on-hand inventory more accurately, Streamline can account for information on pending sales orders. It describes which items are on open sales orders or are back-ordered and includes:
If locations are used, the Location from which the item is being consumed by the customer should be provided as well.
Accounting for Constraints in Optimization
If your business logic includes some constraints, for instance, minimal or maximal item lot, or order rounding, Streamline can take this information into account when building the replenishment plan. To do this, provide the following information:
Data for inventory KPIs
Streamline can calculate key inventory indicators such as expected stockout and overstock values, gross margin, and other metrics. To enable the calculations, you should provide one of the following:
The Inventory value/unit is preferable. The Item purchase price is also used to calculate the value of the purchase orders' lines recommended by Streamline.
To calculate KPIs such as annual revenue, revenue next year, gross margin, and turn-earn index, the Sales history should be extended with either the Sales price/unit or Sales price/order.
Streamline allows you to import supplier information such as:
This data is only used for display purposes in the application. It is not involved in inventory optimization process.
If you have kitted items in your inventory but want to forecast and plan only by their components, Streamline can automatically disassemble them and take into account this information. In this case, you should provide the following data:
Bill of materials information describes the components of finished products. Components can be considered as sub-assemblies (at the intermediate levels of the production process) or raw materials (at the lowest level of the process). Streamline supports an unlimited number of assembly levels. To get a materials requirements plan, you should provide Streamline with the following data:
Streamline allows you to plan products having a limited shelf life. The only data you should provide is the item Shelf life. It should be given in the data aggregation periods (days, weeks or months). This data should be returned by the Item info query.
Exported data is customized per customer requirements. This may include any information that Streamline generates such as purchase orders, forecasts, or replenishment plans.
For example, to export the purchase orders to your database, the minimum information includes supplier code, item code, and quantity to order. Streamline calls stored procedures from your database and passes the minimin information into them. Stored procedures pull all necessary fields from the database and create purchase orders. Stored procedures are created in your database according to your system requirements. Alternatively, the purchase orders can be exported to an Excel file for manual submit to 3rd party online systems.