ABC Analysis Dashboard

Updated September 22, 2023

The ABC Analysis Dashboard offers an approach for categorising inventory items into three groups, grounded on their value and sales frequency.

This dashboard can filtered by Store, Variant Grade, Product Category & Product Title.

A-class:

  • Representing top-selling products, they account for approximately 80% of your revenue.
  • These products typically have a more accurate sales forecast.
  • Frequent reorders are necessitated, often on a daily or weekly basis.
  • They are prioritised to prevent stock-outs, ensuring continuous availability.

B-class:

  • Products in this category contribute to around 15% of your revenue and may occasionally shift to A or C class.
  • They aren't as critical as A-class items but are more significant than C-class products.
  • Their performance is consistently monitored to identify potential shifts to A or C class.

C-class:

  • These items contribute to about 5% of total revenue.
  • They are produced and reordered less frequently, usually in response to an actual purchase.
  • Ideally, C-class items should stock-out after each purchase since they are low demand and pose a higher inventory cost risk due to potential overstock.

ABC Inventory Analysis can streamline inventory and improve profitability.

The analysis uses the complete historical dataset from all stores connected to Ellis.

ABC Analysis Dashboard Elements

KPI

  • A Class Variants: Count of product variants per A class, derived from an analysis of the entire historical dataset.
  • B Class Variants: Count of product variants per B class, derived from an analysis of the entire historical dataset.
  • C Class Variants: Count of product variants per C class, derived from an analysis of the entire historical dataset.
  • Total Variants: Total number of distinct product variants in classes. Source: Shopify
  • A Class Net Sales: All-time net sales of current A-class variants from orders placed in web store(s) or point of sale locations. The percentage tells how much the all-time net sales of the same variants have increased over the last 90 days. Source: Shopify
  • B Class Net Sales: All-time net sales of current B-class variants from orders placed in web store(s) or point of sale locations. The percentage tells how much the all-time net sales of the same variants have increased over the last 90 days. Source: Shopify
  • C Class Net Sales: All-time net sales of current A-class variants from orders placed in web store(s) or point of sale locations. The percentage tells how much the all-time net sales of the same variants have increased over the last 90 days. Source: Shopify

ABC Inventory Analysis

Analysis of products purchased in pos and web. The table contains the first 100 results, but the full data can be downloaded separately. Source: Shopify