Section 2 Automatic calculation Data processing for scale calculation

Terak Calculation 2 data processing screen

第２項             在庫量推定

 出荷データから在庫量を計算する方法は前項で述べた。
計算例として、出荷データ20２２/05/09から在庫量（PL換算）計算する手順を説明する。
１．アイテムランク別に20２２/05/09の出荷物量算出（連番1-5）。
２．最大在庫数（日）及び安全在庫（日）で指定し（連番7-8）、安定運用時在庫（日）を計算、計算式は安定運用時在庫＝（最大在庫(日)―安全在庫(日)）／２＋安全在庫(日)である（連番9）。
３．安定運用時在庫数量を計


写真見出し
写真説明

算、計算式は出荷量＊安定運用時在庫（日）。
４．安定運用時在庫＊出荷量で計算（連番10-14 ）。連番16-18は安定運用時在庫／アイテム数で算出。
５．この表計算のポイントは、パレット積付方法の計算。 単載積付はパレットに1アイテム積載、２混載積付はパレットに2 アイテムを積載で、混載積付は先頭数字がパレットに積載するアイテム数を示している。
単載積付と混載積付を区分する方法は、アイテム当たり在庫（PL換算）が0.5PL以上で有れば単載積付で、0.5PL~0.33は2混載積載、0.32~0.25は3混載積載0.24-0.125は4混載積載で、0.12５以下は8混載積載として計算している。
混載積載のPL換算はアイテム数／PL積載アイテム数で算出する。


写真見出し
写真説明

Tera計算では、バラ出荷のB行I_Dランクの出荷アイテム数に出荷していないアイテム数を加算している。 また、保管スペース計算時は上記計算の1.1倍（Tera設定）物量として計算している。
 Chapter 4 Tera Calculation 2_Distribution Center Size Calculation
TData is processed in Tera Calculation 0, so why further process it in Tera Calculation 2?

Data processing in Tera Calculation 0 is for Tera Calculation 1, and focuses on aggregating peak volume.
Therefore, it looks at the required inventory capacity and workload load of the equipment on the maximum shipping day.

On the other hand, data processing in Tera Calculation 2 aggregates the required storage scale. Therefore, the average volume of all shipping days is used.

Observation:
In fact, processing for Tera Calculation 2 is completed at the data processing stage of Tera Calculation 0. Data processing in Tera Calculation 2 is aggregated based on the GPLE rank and GPLI rank
of the Access "T200" table created by data processing in Tera Calculation 0. It is understood that Tera Calculation 1 is a calculation for the maximum shipping day, and Tera Calculation 2 is a calculation of the average of all shipping data.

The rank setting key for Tera Calculation 2 uses PL conversion. This is because it focuses on pallet storage in storage spaces that have a large area ratio in distribution centers. The original data is obtained from " T200 ", but the calculation data uses the average of all shipments ( Tera settings). There are two reasons for this . 1. If a specific shipping date is used, items that have not been shipped on that shipping date will be omitted from the calculation. 2. If a shipping date with many shipments is used, the size of the distribution center will be larger than necessary; shipping dates with more shipments than average can be compensated for with safety stock. The Tera settings use the average of all data, but calculations can also be performed for specific shipping dates, so please change the Tera settings to verify the difference in scale. As written in other chapters, case shipments and loose shipments are separated and calculated separately. These data include loose numbers and case conversions, PL conversions, volume conversions, and weight conversions, and tables have been made public so that you can use this Access data to try calculations other than Tera calculations.

Second-term             inventory estimation

 The method for calculating inventory quantity from shipping data was explained in the previous section. As
a calculation example, the procedure for calculating inventory quantity ( PL conversion) from shipping data 2022/05/09 will be explained. 1. Calculate shipping quantity for 2022/05/09 by item rank (serial numbers 1-5 ). 2. Specify maximum inventory quantity ( days) and safety stock (days) (serial numbers 7-8 ) and calculate stable operation inventory (days). The formula is stable operation inventory = (maximum inventory ( days ) - safety stock ( days ) ) / 2 + safety stock ( days ) (serial number 9 ). 3. Calculate stable operation inventory quantity .



Photo caption
Photo description

The formula is shipment volume * inventory during stable operation (days).
4. Calculate inventory during stable operation * shipment volume (sequential numbers 10-14 ). Serial numbers 16-18 are calculated as inventory during stable operation / number of items.
5. The key to this spreadsheet is calculating the pallet loading method. Single loading is loading one item onto a pallet, 2-item mixed loading is loading two items onto a pallet, and for mixed loading, the first number indicates the number of items loaded onto the pallet.
To distinguish between single and mixed loading, if the inventory per item ( PL conversion) is 0.5 PL or more, it is single loading; 0.5PL to 0.33 is 2- item mixed loading; 0.32 to 0.25 is 3- item mixed loading ; 0.24-0.125 is 4- item mixed loading; and 0.125 or less is 8- item mixed loading. The PL conversion for mixed loads is calculated by dividing the number of items by the number of items in the PL load.


Photo caption
Photo description

In Tera calculations, the number of unshipped items is added to the number of shipped items in row B, rank I_D for bulk shipments. Also, when calculating storage space, the amount is calculated as 1.1 times the amount calculated above ( Tera setting).