User Tools

Site Tools


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

  • Type - indicates the type of the item. It is shown if bill of materials was imported.
  • Finished - indicates finished products or goods.
  • Intermediate - indicates products that are made during the manufacturing process and are used to create finished products.
  • Material - indicates materials, the items that are used to build intermediate and finished products. They represent the lowest level of the bill tree.
  • On hand – the amount of inventory that is currently in stock. Color-coding of the column:
  • Red - the items with insufficient On hand inventory to cover lead-time demand. This is an irretrievable loss.
  • Light-green – the items with On hand quantity enough to satisfy the expected lead-time demand.
  • Dark-green – the items having On hand enough to cover the demand forecst during the (lead time + order cycle) period.
  • Days/Months of supply shows how many days/months of the future demand the (On hand - Pending sales orders) quantity can cover.
  • Pending sales orders is the quantity on open sales orders.
  • Qty to receive – the amount of inventory expected from your supplier.
  • Lead time is entered in days and represents the interval of time between when a replenishment order is placed and when it is received. It's also possible to change the default value of Lead time in the inventory report setting.
  • Order cycle represents how often the item is ordered from your supplier. It can be given in sales history periods (weeks or month), days, or lead times. If it is not given, a default value is used from the inventory report settings.
  • Min lot and Max lot represent optional constraints on how few or how many of this item can be purchased from your supplier. Zero value means that the parameter is not given.
  • Rounding allows Streamline to take into account how many items come packed in a carton, allowing the application to suggest exactly the right amount of the item to order.
  • Display qty - the minimum number of units a shelf to display. This parameter typically arises in the retail business. You can control how this amount is used when final safety stock is calculated.
  • Service level is the percentage of the time (in the long run) that the item is in stock, based on the forecast. It can be changed in the inventory report settings.
  • Safety stock is the safety stock for any location’s warehouse. Its level depends on the inventory replenishment strategy. Calculation of the Safety stock can be customized in the inventory report settings. Safety stock is an assessment of the reserve stock for:
  • Safety stock debt shows the quantity of material that is required to keep the Safety stocks of all finished products that use this material on the recommended level. It is calculated for all items that are used to create finished goods and is shown if bill of materials was imported.
  • Shelf life is the desired time the item can be in stock. After the time expires, some actions should be taken as clearance sale, return to the supplier and so on. The red cell background means that even if you order 1 unit of the item, it won't be sold with the probability of more than the shelf life exceeding percentage. Thus, the item won't be ordered. To make Streamline order this item, increase the shelf life or shelf life exceeding percentage.
  • Shelf life exceeding shows the average percentage of the item’s purchase quantity that we might have to: send to a clearance sale, return to the supplier and so on. If you just discard the expired product, the percentage should be very small. If you recycle them (e.g. roast the meat or make a clearance sale), the numbers may be larger.

Streamline implies that the product moves by the FIFO rule. So if you got some goods, a newly appeared lot will never sell until we sell the expiring ones. Streamline doesn’t take into account that some lots of goods are doomed and be discarded for sure.

  • Purchase price is the price you pay the supplier for the item, imported from Excel file or 3-rd party system. If base currency or currency of supplier is imported, the column shows it.
  • Note shows the annotation for the planning item.
  • Gross margin is a gross profit margin that is calculated based on the item balance value or item purchase price (is used as a fallback if item balance value is not given) and selling price over the last 12 months. The formula looks like:

Gross_margin = (1 - item_purchase_price * inflation_coefficient ^ sellout_time / aver_sales_price) * 100%


item_purchase_price - the item purcahse price per unit imported from the datasource;

aver_sales_price - the average selling price calculated over the last 12 months;

inflation_coefficient = 1 + interest_rate;

sellout_time = (lead_time + days_to_sell)/365.25;

interest_rate – the annual interest rate that is taken from the project settings;

days_to_sell – the Average days to sell value.

2017/10/02 12:02
  • Turn-earn index is an item gross margin accumulated over the last 12 months, and calculated as:

Turn-earn_index = gross_margin * inventory_turnover

  • Order now section gives recommendations of what and how much to order today.
  • Qty column shows the item amount that should be ordered. An example of the column calculation can be found on the example calculation page.
  • Excess order shows the excess part of the order that is gotten due to the constraints such as Min lot or Rounding. For example, if you round the suggested quantity of 127 by 10, resulting in 130, then, you will have 2.3% of excess that is calculated as (130 - 127) / 130 * 100%.
  • Value shows the purchase order item value in the base currency.
inventory-information.txt · Last modified: 2019/06/14 09:34 (external edit)