Item time series generation

The item time series has the time for which the quantity changes for each item, its varying quantity and the total quantity.
The item time series is not normally generated. If the user wants to generate it, it will be necessary to build the "Generate item time series" command into the scheduling parameter.

For example, as stated below, the user can include the "item time series" command for the scheduling parameter. In such case, the item time series will be generated if the user will perform this scheduling parameter.

If the user selects the "Table view/Advanced setting/Item time series" from the menu, the item time series table will be displayed. After that, the user will be able to check the generated item time series. (This menu is only shown if time series have been generated.)

Difference between "changing quantity" and "changing quantity (by operation)"

When an item's "Inventory fluctuation method " is specified linearly, the "changing quantity" for the item time series stores the changing quantity for its time. However, when the multiple same item operations are assigned to the same time and date, the user will see the value which took into account all those things.

For example, as shown in the above chart, you can see the change on the inventory graph for the area where the two operations producing the item "Product A-Packing" are overlapping. Nonetheless, you can observe that the changing quantity, which takes into account both operations in terms of item time series, is also being stored into the "Differential quantity" for the item time series (i.e. right red arrow in the above diagram)

The "Quantity change (by operation)" property only stores the changing quantity for the corresponding operation (i.e., left red arrow area in the above table). The user is thus able to calculate the quantity for each operation by taking use of this value.

For example, as below, data for item time series is exported to Excel. After that, the user will be able to calculate the production quantity as well as the consumption quantity by multiplying the duration time between "start" and "suspend" (or "start" and "end," "resume" and "suspend," "resume" and "end") by the property value for "changing volume (by operation)."

© Since 2019 Asprova Corporation, All rights reserved.