EIQ table creation screen


The table shows data for shipping date 2022/05/09, with items sorted by the number of items with the most items shipped, based on all shipping data.
Shipping destinations 1 and 2 have not been shipped, so they are left blank. By scrolling, the figures for all 438 shipping destinations are displayed.
There are 1,984 items, so they have been split across 66 pages, taking into account the display range and processing speed due to PC load.
The table is 430 rows x 1,984 columns, and is unreadable to the human eye in its current state.

Observation:
In the table above, shipping destinations 1 and 2 are left blank. This blank space means that no shipments have been made to the top 1 and 2 shipping destinations. Perhaps there are urgent items being shipped at the lower levels, but shipping is not taking place on those days.
This kind of intentional distribution of shipping dates is common at many distribution centers.

Section 3: Creation of an EIQ matrix table
The EIQ matrix table is created by dividing the EIQ table into 25 blocks (5 blocks for items x 5 blocks for shipping destinations) and aggregating the results.
From experience, we believe this is a convenient number of blocks for allocating equipment during system design.
This table can be used to calculate values ​​converted into cases, PL, or volume as needed. It
is also displayed alongside the conventional calculation, so please study while comparing it with the conventional calculation method.

The EIQ matrix table


shows that 1,099 records (rows) were shipped in the C-E_A1 block, which contains 132 items. The C-E_A1 block shipped 488 rows to the top 21 destinations,
while the C-E_A2 block shipped 185 rows, for a total of 1,009 rows (300 destinations) in the C-E_A1 block. The EIQ matrix table is set in Tera, with each block assigned a rank key percentage (%) of material, with the total being 100% as shown in the table below.

For details on rank keys, see " Chapter 2: Tera Calculation 0 - Processing Shipping Data ." The percentages for each block can be changed by changing the Tera settings during Tera Calculation 0 - Processing Data. Ranking is performed by analyzing and aggregating the entire shipping data. Extracted EIQ matrix aggregations with specified shipping dates may result in some deviation in the percentages.



The ratio of each block can be changed by changing the Tera settings when processing the Tera calculation data.
Ranking is performed by analyzing and aggregating the entire shipping data. When extracting EIQ matrix data by specifying the shipping date, there will be some deviation in the ratio.




Section 1 EIQ

Section 1: Creation of EIQ table
Although the EIQ table is called a sowing table, the vertical columns represent items and the horizontal rows represent shipping destinations.

Chapter 7 Tera calculation reference
When I worked for a 3PL company in the 1980s, the sowing charts used in apparel manufacturing were similar to EIQ charts.
Sowing involves a mother grabbing a bag of candy from the cupboard and handing it out individually to her three children. It's a traditional task that has been performed by people for ages, even outside of logistics.
Around the same time, I remember reading an article in a logistics magazine in which a software developer introduced sowing charts and work methods. I believe the origins of EIQ analysis in logistics lie in sowing charts created during bulk picking.
When I first saw an EIQ chart, I asked Professor Suzuki Shin, "Is this a sowing chart?" and he replied, "Yes, this chart has a deep meaning." I then asked him if I could create a program to create charts and graphs for use as EIQ software, which led to his guidance. I fondly recall my visits to his home.
I have incorporated what I learned during this time into my software.

Comments:
Although no specific details were announced, they suggested a method called "SEIQ" that adds product dimensions to EIQ analysis. Tera calculations are based on this "SEIQ." Tera calculations incorporate case conversion, PL conversion, volume conversion, and weight conversion.

Section 2: Creating an EIQ scatter plot
An EIQ scatter plot is a table in which each square (cell) in the EIQ table is represented by a dot, and all shipping data is displayed on one screen.

The EIQ scatter


chart is a scatter plot that shows the shipped cells as dots to display the entire EIQ table.
Unfortunately, although the overall trend can be seen, it is not possible to determine the quantity.