Agent skill · data analytics · davila7
abc-xyz-segmentation
Segment a SKU portfolio on value (ABC) and demand variability (XYZ), produce the 9-box with a planning policy per cell, and reallocate planner attention accordingly. Use when the user mentions ABC analysis, inventory segmentation, SKU rationalization, stok segmentasyonu, envanter sınıflandırma, or asks which items deserve forecasting effort. Differentiator - ABC alone is treated as half an answer; policy lives in the value x variability combination.
Why this skill is useful
Provides a detailed methodology for SKU segmentation that includes specific policies and validation steps, which the AI wouldn't reliably generate on its own.
What it needs
About 2k tokens when loaded. Last updated 2026-08-06. 30,138 stars on the source repository.
What this skill does
ABC-XYZ Segmentation Value tells you where the money is. Variability tells you whether forecasting, buffering or restructuring can work. Never output a classification without the policy consequences. Required data Per-SKU demand history (sku, period, qty) covering 12+ periods, plus unit value (unitprice or cost). Without unit value, ABC degrades to a volume ranking - say so and ask for prices before presenting conclusions about money. Workflow 1. ABC on annual value. Rank by annual consumption value; cumulative 80% = A, next 15% = B, rest = C. Report the actual concentration found (e.g. "15 SKUs = 80%"), not the folklore 20/80. 2. XYZ on variability. CV = std/mean of period demand per SKU. Defaults: X < 0.5, Y 0.5-1.0, Z >= 1.0. These are conventions - check the CV histogram for natural breaks and state the thresholds used. SKUs with structural zero periods (intermittent) belong in Z regardless of CV arithmetic; mean-based CV understates their risk. 3. Build the 9-box with SKU counts AND value share per cell. Value share is what makes managers act. 4. Attach the policy per cell (adapt wording to context): A-X: tight forecasting pays; low buffer, frequent review, automate replenishment A-Y: forecast + healthy buffer; investigate variability drivers A-Z: do not chase forecasts - strategic buffer, lead-time negotiation, or make-to-order B-X / C-X: min-max autopilot; withdraw planner attention B-Z: buffer or longer promise dates; check if variability is self-inflicted (promotions, batching) C-Z: rationalization shortlist - kill, consolidate, or on-demand sourcing 5. Name the reallocation. The deliverable is planner-hours and buffer money moving between cells - state explicitly which cells gain and lose attention. 6. Validate. Sum of cell value shares must equal 100%; spot-check two SKUs' classifications against their raw series before presenting. Pitfalls to check explicitly ABC computed on quantity while unit values vary 10x+ ranks the wrong items. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills davila7/abc-xyz-segmentation