Товарный и финансовый учет на маркетплейс. Заказы, оптимизация по регионам.Озон, Мегамаркет, ЯMarket, Wildberries, AliExpress, Avito, Яндекс FBY, LeroyMerlin. Цены и скидки, этикетки и маркировка. Учет комиссии и начислений.

ABC and XYZ analysis — methods of classification and sales analysis


ABC and XYZ analysis are methods of sorting products or customers to streamline sales and purchasing. They help you understand which SKUs generate the most revenue and which are sold the most consistently.

General Concepts

ABC and XYZ analysis are methods of classifying and analyzing data that are commonly used in inventory management, sales, and product range.

ABC Analysis (Classification by Importance)

Divides the catalog by revenue or profit volume:

  • Group A (Highly Important): 20% of products that generate 80% of the results.

  • Group B (Average): Approximately 30% of products that generate 15% of the results.

  • Group C (Low Importance): Approximately 50% of products that generate only 5% of the results.

XYZ Analysis (Stability Classification)

Evaluates how predictable and stable a product's sales are:

  • Group X (Stable): Consistent demand, easy to forecast.

  • Group Y (Fluctuating): Demand moderately changes (e.g., due to seasonality).

  • Group Z (Unpredictable): One-time sales, demand chaotic.

Combined ABC-XYZ Analysis

Combines two methods. The extreme groups are:

  • AX — ideal product: generates a lot of revenue and sells consistently.

  • CZ — outsider: generates pennies and is ordered once a year.

Why is this practical?

  • Focus on essentials: You control group A products with predictable demand to ensure they never run out.

  • Budget optimization: Group A products are purchased in bulk. Group C products are kept at minimum stock levels or on backorder to avoid tying up capital in inventory.

  • Accurate planning: Purchasing and production are planned based on actual stable demand.

Examples of Actions Based on Analysis

  • Product AA (High Revenue + Stable Demand):

    • Action: Always keep in stock with a buffer, actively promote.
  • Product BC (Medium Revenue + Unstable Demand):

    • Action: Purchase in small batches, monitor trends.
  • Product CA (Low Revenue + Stable Demand):

    • Action: Keep in the catalog (e.g., packets or sugar sticks), but do not inflate inventory levels.