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

explain-inventory-dialog

6.9.3. Explain Inventory Calculation Dialog

Explain inventory calculation dialog is designed to show and explain Streamline’s planning process for each planning item. This dialog discovers the simulation modeling behind a purchase, replenishment, material requirements, and production plans generated by Streamline. It is especially useful to help understand the planning logic in the following complex cases as:

  • two-echelon planning;
  • material requirements planning; and
  • combination of both.

First of all, we give a description of this dialog, and then show how it can be of help in particular situations using built-in examples.

Description of the dialog

To open the Explain inventory calculation dialog:

  1. Go to the Inventory planning tab.
  2. Set the cursor at the planning item in question.
  3. Press Ctrl + E, or right-click with the mouse and select the Explain calculation command from the context menu.

The Explain inventory calculation dialog appears (see figure below).

This dialog is divided into two parts. The top part shows the properties of the currently selected planning item. The bottom part, a table displaying events that will happen to the item in the future based on the input data (actual events) and Streamline's simulation modeling (simulated events).

The dialog has its own color-coding helping you understand the math behind the Projected inventory levels.

Planning Item Properites

  • Item shows the code and the description of the item.
  • Location shows the code and the description (if available) of the location.
  • Debt received from lower echelon (current/max) shows current, maximal, and accumulated safety stock debts received from the lower echelon. These parameters are calculated for each planning item at each echelon in a multi-echelon model.
  • Debt passed to upper echelon (current/max) displays current and maximal safety stock debts that are passed to the upper echelon in the multi-echelon model.
  • Current time shows the current day as a fraction of the data aggregation period (longer period). Streamline determines this date as the date of the last imported transaction. This date is also shown in the title of the Streamline application window.
  • Simulation horizon shows the number of periods to simulate ahead. This number is specific for each planning item and is not less than the Forecast horizon. To get all the necessary events calculated and shown within the Purchase plan and Projected inventory levels, Streamline extends the Forecast horizon to a certain number of periods. This number is specific for each planning item and depends on the Lead time and Order cycle set for the planning item.

Table

  • Each column header of the table displays the date the particular event happens.
  • Time fraction is a numerical representation of the date shown in the table header. Zero time fraction corresponds to the last date of the previous data aggregation period. It is shown in the first column of the table.
  • Events shows events that happen along the simulation. This column is the one that breaks data aggregation periods into subperiods. Each event has a unique icon. Icons and the corresponding events are shown in the table below.

Icon Event
Placement of a replenishment, purchase, or work order recommended by Streamline (simulation).
Arrival of the order planned by Streamline (simulation).
Arrival of actual purchase or transfer order. You can view this order in the To receive tab of the In transition details dialog.
Shipment of a sales order. You can view this order in the To ship tab of the In transition details dialog.
Item write-off (simulation).
End of the data aggregation period.
  • Demand forecast indicates the final demand forecast for each data aggregation period. Streamline shows this value in the cell that corresponds to the first event of the period.
  • Manufacture forecast shows the total consumption of the item (Material or Intermediate) got from the lower echelon. For example, assume we have a Material item which is used in two Finished items directly. In Streamline, relations between these items are represented by a two-echelon model, where the material is at the highest echelon and the finished products are at the lowest one. Consequently, the total demand for these two finished products is the manufacture forecast for the material.
  • Subperiod consumption is the total of Demand forecast and Manufacture forecast brought to the subperiod time interval.
Streamline doesn't take into account the consumption for the past time period including the current date.
  • Safety stock shows how the calculated safety stock is spread out along the first order cycle period. If safety stock is determined as the demand of the future periods, Streamline also shows safety stock for all the other order cycles by indicating the difference between the current and previous order cycle.
  • Write-offs indicates how much inventory will be discarded due to the batches' shelf life within the simulation horizon. This row comes into play if inventory batches were imported, and shows the volumes of write-offs.
  • Orders in transition shows quantities that will be shipped to customers (negative values) and received to locations (positive values) within the simulation horizon. This row pulls information from the To receive and To ship tabs of the In transition details dialog. These are actual (not simulated) events that are going to happen.
  • Debt after arrival indicates the accumulated safety stock debt for each subperiod.
  • Inventory + in transition displays the calculated subperiod inventory level (at the end of the subperiod), however, without taking into account the Planned order arrivals. Streamline uses a color-coding to explain how this row is calculated (see figure below). This row shows the current item On hand in the first column of the table.

  • Planned order arrivals shows arrivals of orders planned by Streamline. Values of this row are tightly linked to the Planned orders row as they indicate the arrivals of the corresponding planned orders. Streamline displays this dependency using a color-coding once you set the cursor at the non-blank cell of the Planned orders row (see figure below).

  • Projected inventory shows the projected inventory levels at the end of each subperiod. It is the sum of the Inventory + in transition and Planned orders arrivals (see figure below). Values of this row shown at the end of each data aggregation period make up the Projected inventory level report.

  • Planned orders shows Streamline's recommendations on how much and when to place a replenishment, purchase, or work order.
The first column of the table can be a little bit misleading, showing you an order placement (an email icon) on the past date. This is due to the zero time point which is used as a starting point to run the simulation from. Do not pay attention to the date in the header for this column. Streamline always calculates the Planned orders quantity for the first column on the current date.

Buttons and Options

Buttons with Up and Down arrows on the right of the dialog allow navigating through the planning items.

Manufacture details option expands the table with all the items of the lower echelon which are linked to the current planning item based on the BOMs and shows the manufacture forecast for them.

Color-coding

The color-coding legend for the table is shown in the figure below.

  • Green numbers are the inputs for the Planned orders and Projected inventory rows calculation.
  • Black numbers are calculated values which, in turn, can also be considered as the inputs to the next level of calculations.

There are three color backgrounds for cells:

  • Green and Red backgrounds indicate that the value is used with a positive and negative sign in the calculation accordingly.
  • Grey background highlights cells which are co-dependent on each other.

Examples

The primary purpose of the Explain inventory calculation dialog is to explain how the Purchase plan and the Projected inventory levels are calculated. In this section, we will show how to use this dialog to get these plans for the following tree built-in examples:

Inventory Planning by Month

To show the capabilities of the dialog, we have slightly changed the input data of the project. We added a customer order that should be shipped on Jan 4 of 2019 and changed the default Leadtime to 10 days for item B05465-R (see figure below).

Now, let's figure out, how the first planned order of 96 units is calculated (see the first column for the Planned orders row). The figure shows the inputs used for the calculation.

To determine the quantity to order currently (current date is Dec 1, 2018 in the example), Streamline uses the same formula as shown in the Understanding purchase plan and projected inventory levels article:

Current order = MAX(CEILING(MAX(0, D(OC) + Safety stock + Qty to ship - Remaining), Rounding), Min lot),

Remaining = MAX(0, MAX(0, On hand) + Qty to receive - D(LT)).

Where:

  • D(OC) is the order cycle demand starting from the lead time. D(OC) = 125 + 3 + 10 + 24 = 162.

As Lead time = 10 days which end up on Dec 12, 2018 and the Order cycle is 1 month, we take the Subperiod consumption demand starting from the end of Dec 12, 2018 to the end of Jan 12, 2019. Since the dialog shows events at the end of the subperiod, we take the sum for the four subperiods staring from Dec 31, 2018.

  • D(LT) = Demand_forecast_for_period * Lead time, days / 30 = 197 * 10 / 30 = 66.

This value is shown in the Subperiod consumption row on the date when our planned order arrives.

  • Qty to ship and Qty to receive are the item quantities that are to be shipped/received within the lead time plus order cycle period.

As we have a shipment of 30 units that hit this interval (see figure above), Qty to ship = 30.

  • Rounding = 12, Min lot = 60, On hand = 266.

Now, let's replace the parameters with the values:

Current order = MAX(CEILING(MAX(0, 162 + 94 + 30 - 200), 12), 60) = 96,

Remaining = MAX(0, MAX(0, 266) + 0 - 66) = 200.

We highlighted the values that are used in the calculation of the Current order quantity with positive and negative signs via green and red borders correspondingly in the figure above.

explain-inventory-dialog.txt · Last modified: 2019/07/18 15:58 by admin