Chapter 2. ABC Analysis

I. IQ Data Analysis (Analysis by Item)

IQ Analysis is a method of analyzing the shipping volume (Quantity) for each item (Item).

  • Utilization of ABC Analysis

    Items are arranged in descending order of shipping volume and classified into three groups: A (large volume), B (medium volume), and C (small volume). This is indispensable for inventory management and distribution center planning.

  • Application of the "80/20 Rule"

    Generally, there is a tendency for 20-30% of all items (I20-I30) to account for 80% of the total shipping volume (GIQ80).

  • Analysis Tools
    • IQ Table: A table summarizing quantities and cumulative composition ratios.
    • IQ Curve (Pareto Chart): A graph visualizing the distribution of shipping volume. A "ΣIQ Curve" indicating the cumulative value is sometimes shown together.
  • ABCD Analysis

    From the C group, items that hardly move or are never shipped, known as "Dead stock," are distinguished as the D group to evaluate inventory health.


II. EQ Data Analysis (Analysis by Customer)

EQ Analysis is a method of analyzing the order quantity (Quantity) for each ordering customer (Entry/Order Entry).

  • Importance from a Logistics Perspective

    By analyzing on a "quantity" basis rather than a sales amount basis (commercial flow), the load of logistics work can be accurately grasped.

  • Distribution Trend

    Similar to IQ analysis, it is common for 20-30% of all customers (E20-E30), the key clients, to account for 80% of the total order volume (GEQ80).

  • Analysis Tools
    • EQ Table: A table ranking the order quantity for each customer.
    • EQ Curve: A graph visualizing the bias per customer. You can check if the logistics load is concentrated on specific customers.

Summary: Roles of IQ Analysis and EQ Analysis

  • IQ Analysis: Determines "which items should be managed intensively (storage location and replenishment frequency)".
  • EQ Analysis: Determines "which customers (shipping destinations) have a large impact (packing and delivery routes)".

By combining these two analyses, it becomes possible to construct an optimal layout and work structure for a distribution center.

IQ Analysis Pareto Chart Image
EQ Analysis Pareto Chart Image