Item 2: Estimated Inventory Quantity |
![]() |
The method for calculating inventory quantity from shipping data was described in the previous section. As an example, we will explain the procedure for calculating inventory quantity ( PL equivalent) from shipping data 2022/05/09 . 1. Calculate the shipping quantity for 2022/05/09 by item rank (sequential numbers 1-5 ). 2. Specify the maximum inventory quantity (days) and safety stock (days) (sequential numbers 7-8 ) and calculate the stable operation inventory (days). The formula is stable operation inventory = (maximum inventory ( days ) - safety stock ( days ) ) / 2 + safety stock ( days ) (sequential number 9 ). 3. Calculate the stable operation inventory quantity. The formula is shipping volume * stable operation inventory (days). 4. Calculate stable operation inventory * shipping volume (sequential numbers 10-14 ). For serial numbers 16-18 , calculate stable operation inventory / number of items. 5. The key to this spreadsheet is calculating the pallet loading method. Single loads are 1 item loaded on a pallet, 2-item mixed loads are 2 items loaded on a pallet, and in mixed loads the first number indicates the number of items loaded on the pallet. The method for distinguishing single loads and mixed loads is that if the inventory per item ( PL conversion) is 0.5PL or more it is a single load, 0.5PL to 0.33 is a 2- item mixed load, 0.32 to 0.25 is a 3- item mixed load , 0.24-0.125 is a 4- item mixed load, and 0.125 or less is an 8- item mixed load. The PL conversion for mixed loads is calculated as the number of items / number of items loaded in the PL . |
Section 1: Difference between average inventory and stable operating inventory |
![]() ![]() |
The left figure shows the flow of the inventory estimation screen for tera calculation 2. Inventory refers to the quantity of goods received and stored in advance for shipment. Let's explain with an example calculation. In the diagram below , if the shipping quantity is 10 units per day, then "Maximum inventory = number of shipments * maximum inventory period = 10 * 8 = 80 units", "Average inventory = maximum inventory
/ 2 = 40 units", "Safety inventory = number of shipments * safety
inventory period = 10 * 2 = 20 units", and if the arrival period is 2 days, then "Minimum
inventory = safety inventory + (shipment quantity * arrival period) = 20
+ ( 10 * 2) = 40 units". Tera Calculation's inventory calculations do not use average inventory, but instead use the following calculation for stable operation inventory: |
|
Some people say that it is pointless to use Tera Calc to calculate inventory and receipt data when we already have actual inventory and receipt data on hand . The author believes that it is necessary to explain to data providers "where inventory data and incoming data are positioned relative to shipping data" and to calculate incoming and outgoing quantities based on a common understanding with the data provider.
|