abc-xyz-segmentation

Segment SKU portfolios by value and demand variability into a 9-box policy matrix.

30.5k|3.5k|Updated Jul 4, 2025
One-click install
npx skills add https://github.com/davila7/claude-code-templates --skill abc-xyz-segmentation
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: abc-xyz-segmentation
Source: https://github.com/davila7/claude-code-templates/tree/main/cli-tool/components/skills/operations/abc-xyz-segmentation
Command: npx skills add https://github.com/davila7/claude-code-templates --skill abc-xyz-segmentation

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Inventory planners often rank SKUs by value alone (ABC) and ignore demand variability, leading to wasted forecasting effort on erratic items and over-buffering of stable ones. This Skill combines ABC value analysis with XYZ variability analysis to produce a 9-box segmentation where every cell carries a concrete planning policy.

Core Features & Use Cases

  • ABC value classification: Ranks SKUs by annual consumption value with cumulative 80/15/5 thresholds, reporting the actual concentration found rather than assumed 20/80 splits.
  • XYZ variability classification: Computes coefficient of variation per SKU with configurable thresholds, and forces intermittent-demand SKUs into Z regardless of CV arithmetic.
  • 9-box policy matrix: Produces SKU counts and value share per cell, attaches a planning policy per cell (buffering, forecasting, make-to-order, rationalization), and names the planner-attention reallocation.
  • Use Case: A supply chain analyst with 12 months of SKU demand history and unit prices asks which items deserve forecasting effort; the Skill returns the 9-box, per-cell policies, and a C-Z rationalization shortlist.

Quick Start

Analyze my SKU demand history and unit prices with ABC-XYZ segmentation and give me the 9-box with a planning policy per cell.

Frequently Asked Questions about abc-xyz-segmentation

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I perform ABC-XYZ analysis on inventory SKUs?

Rank SKUs by annual consumption value for ABC (cumulative 80% = A, next 15% = B, rest = C), then compute the coefficient of variation of period demand for XYZ (X < 0.5, Y 0.5-1.0, Z >= 1.0). Combine both into a 9-box matrix and attach a planning policy to each occupied cell.

What data is needed for ABC-XYZ inventory segmentation?

You need per-SKU demand history with sku, period, and quantity covering at least 12 periods, plus a unit price or cost per SKU. Without unit values, ABC degrades to a volume ranking and conclusions about money cannot be drawn.

Why is ABC analysis alone not enough for inventory planning?

ABC shows where the money is but says nothing about forecastability. A high-value SKU with erratic demand (A-Z) needs strategic buffers or make-to-order, while a stable A-X item rewards tight forecasting, so policy must come from the value-variability combination.

How should intermittent demand SKUs be classified in XYZ analysis?

SKUs with structural zero-demand periods belong in Z regardless of their computed CV, because mean-based CV understates their risk. Treat them as candidates for buffering, longer promise dates, or rationalization rather than forecasting.

When should ABC-XYZ segmentation be re-run?

Classifications rot as demand patterns shift, so re-run the segmentation quarterly and track SKU migrations between cells. A dominant C-Z population usually signals assortment bloat rather than a planning problem.