Classify inventory items by demand variability using coefficient of variation. X is stable, Y is moderate, Z is highly variable.
XYZ analysis classifies inventory items by the predictability of their demand patterns. It uses the coefficient of variation (CV), which is the standard deviation of demand divided by the average demand. Items with low variability (CV < 0.5) are classified as X — they are easy to forecast. Moderate variability (CV 0.5–1.0) items are Y, and highly variable (CV > 1.0) items are Z.
Understanding demand variability is essential for setting appropriate safety stock levels, choosing the right forecasting method, and designing replenishment rules. X-items can use lean inventory with minimal safety stock, while Z-items need large buffers or make-to-order strategies.
This calculator lets you input the average demand and standard deviation for an item to compute its coefficient of variation and XYZ classification.
Supply-chain managers, warehouse operators, and shipping coordinators rely on precise xyz analysis data to maintain efficiency and control costs across complex distribution networks. Revisit this calculator whenever conditions change to keep your logistics plans aligned with real-world performance.
While ABC analysis focuses on value, XYZ analysis focuses on forecastability. Combining both gives a two-dimensional view of your inventory. A high-value A-item with volatile Z-demand requires very different management than a high-value A-item with stable X-demand. XYZ analysis helps you allocate forecasting effort and safety stock budgets more effectively.
CV = σ / μ Where: CV = Coefficient of Variation σ = Standard deviation of demand μ = Average (mean) demand Classification: X: CV < 0.5 (stable demand) Y: CV 0.5 – 1.0 (moderate variability) Z: CV > 1.0 (highly variable demand)
Result: CV = 0.30 — Class X
CV = 60 / 200 = 0.30. Since 0.30 < 0.5, this item is classified as X — demand is stable and highly forecastable. Minimal safety stock is needed.
Forecasting accuracy and safety stock requirements are both driven by demand variability. An X-item with CV of 0.2 needs far less safety stock than a Z-item with CV of 1.5, even if both have the same average demand. Understanding this variability allows targeted inventory investment.
Export demand data from your ERP or POS system for each SKU over 12+ periods. Use a spreadsheet to calculate mean and standard deviation, then divide to get CV. Most ERP systems can be configured to calculate and display CV automatically.
X-items respond well to simple moving averages or exponential smoothing. Y-items may need trend or seasonal models. Z-items often defy statistical forecasting — consider causal models, customer input, or judgmental adjustments for these items.
Demand patterns evolve with product lifecycle, market changes, and competitive dynamics. Run XYZ reclassification at least annually. Items graduating from Z to Y signal demand stabilization and may warrant inventory policy adjustments.
XYZ analysis classifies inventory items by demand variability using the coefficient of variation. X-items have stable, predictable demand; Y-items have moderate fluctuations; Z-items have highly unpredictable demand.
It is the ratio of the standard deviation to the mean (CV = σ/μ). A lower CV means more consistent demand relative to the average, while a higher CV indicates erratic demand patterns.
Common thresholds are X < 0.5, Y between 0.5 and 1.0, Z > 1.0. Some companies use tighter bands (e.g., X < 0.3) depending on their industry and forecasting capabilities.
ABC ranks items by value (how much they cost), while XYZ ranks items by demand predictability (how forecastable they are). They measure different dimensions and are most powerful when combined.
Z-items with erratic demand need higher safety stock, shorter review cycles, or alternative strategies like make-to-order. They are the hardest to forecast, so statistical forecast models may perform poorly.
Yes. A new product may start as Z (limited data, high variability) and migrate to Y or X as demand stabilizes. Reclassify periodically — at least annually — to keep policies aligned with current patterns.
Match the granularity to your planning frequency. If you forecast weekly, use weekly demand data. Using daily data when planning is monthly can inflate CV due to day-of-week effects.
CV is undefined when the mean is zero. Items with zero average demand (dead stock or brand-new items) should be handled separately — they cannot be classified using the standard CV formula.