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

inventory-report

6.9. Inventory Planning

The Inventory planning tab is used to generate inventory replenishment recommendations. It is represented by a table and is calculated based on forecasts and a set of inventory parameters used as inputs.

The parameters and outcomes of the report are the following:

Parameters: On hand, To receive, Delivery date, To ship, Lead time, Order cycle, Min lot, Max lot, Rounding, Service level, Display qty, Shelf life, peridos, Shelf life exceeding, Safety stock.

Outcomes: Dys of supply, Safety stock, Reorder point, Max inventory, Gross margin, Turn-earn index, Current qty to order, Projected inventory levels, Purchase plan, Replenishment plan, Stockouts and Overstocks.

Description of the outcomes and parameters is given in the Table section.

Safety stock can be used as input for the report in case if you need to set it manually. All information entered into the software manually has higher priority over Streamline’s defaults and outcomes.

The report can be recalculated on demand when you click the Forecast button, or automatically, when you adjusting the forecast or changing the parameters of the report using the Export/Import parameters scenario.

To learn how you can change the parameters, refer to the Setting the replenishment parameters.

Toolbar

  • Settings button gives access to the report settings.
  • Export report exports entire inventory report table to Excel.
  • Export parameters creates an Excel spreadsheet where inventory parameters can be edited.
  • Import parameters loads the spreadsheet created using the Export parameters button. You can optionally choose any other Excel file to load. To do this:
  1. Click on a little triangle near the button.
  2. Select the Choose file… command.

  1. Choose the file and click OK.

Table

  • Category – item's category such as product group or sales point.
  • Item code – an identifier of a planning item also known as SKU.
  • Description – a description of the item.
  • 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%

where:

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.
2017/07/28 08:45
  • Reorder point is the inventory level at which a replenishment order should be placed. This is the sum of the lead time demand and the safety stock.
  • Max inventory is the maximum inventory level for an item in the current period.

The Reorder point and Max inventory columns are visible when the Min/Max inventory replenishment strategy is applied.

  • Stockout is an expected inventory shortage. Red color of the cell in this column indicates a stockout. It can only happen when On Hand quantity does not cover the projected demand for the time period before the first delivery date:

Stockout = MAX(0, [Lead Time Demand - On Hand - In Transition + Pending sales orders]);

  • Overstock shows the item’s expected redundant quantity for the nearest (lead time + order cycle) period. The green color of the cell in this column indicates an overstock.

Overstock = MAX(0, MAX{0, On Hand - Pending sales orders - Demand from Now to PO Arrival} + In Transition - Demand[from PO arrival to Lead Time + Order Cycle] - Safety Stock)

In the case of a capacity limit (Max Lot Qty) that forces us to increase the first ordered, Overstock = 0.

  • Demand forecast section shows the expected future demand in every forecasting period within the forecast horizon.

The color-coding of this section:

  • Green color indicates the future periods which On hand + InTrn(LT+OC)PndSales(LT+OC) can cover.
  • Red color indicates the periods with stockouts.
  • Projected inventory levels section shows the expected future item quantity in stock at the end of each period. In order to calculate the levels, Streamline simulates future consumption and replenishment events.

The color-coding of this section:

  • Green color indicates the future periods which On hand + InTrn(LT+OC)PndSales(LT+OC) can cover.
  • Red color indicates the periods with stockouts.
  • Purchase plan or Replenishment plan (if the Distribution center is activated) section shows the item quantity to be ordered by the 1-st day of each period. It is calculated based on demand forecast and replenishment events. Empty cells in the purchase/replenishment plan mean that Streamline doesn't have sufficient information to make reliable recommendations for those periods.

The Demand forecast, Projected inventory levels and Purchase plan are invisible by default. Any of them can be shown using an option in the inventory report setting.


Next: Distribution Center

Download PDF

inventory-report.txt · Last modified: 2019/07/11 14:49 by admin