ABC-XYZ Inventory Analysis for Demand and Replenishment Planning
Do not apply one stocking policy to every item. Combine ABC value classes with XYZ demand behaviour to balance working capital, service and supply risk.
In a multi-country supply network, a high-value item, a project-critical spare, a slow-moving chemical and an accessory with intermittent demand cannot share one inventory rule. ABC-XYZ analysis classifies inventory value and demand behaviour on separate axes, making replenishment choices more visible. It is not a formula that should place orders without controls; it is a decision framework that depends on reliable data and ownership.
Use the ERP project procurement schedule guide to connect inventory with purchase milestones.
What does ABC analysis measure?
ABC classification commonly uses annual consumption value: unit cost multiplied by annual usage. A items are relatively few but represent a large portion of value, B items form a middle group, and C items are numerous with low aggregate value. Thresholds are a company policy; fixed percentages are not appropriate for every operation.
Sales value alone may also be insufficient. Project-stop risk, shelf life, hazardous storage, minimum order quantity and substitutability can be added as decision factors.
What does XYZ analysis show?
XYZ classification describes demand regularity. X items have steadier, more forecastable consumption; Y items may show seasonality or trend; Z items are intermittent or irregular. Coefficient of variation, demand intervals and zero-demand periods can support the classification. New products need an expert scenario label when history is insufficient.
Apply different policies to the nine cells
- AX: frequent review, high data quality, regular replenishment and low error tolerance.
- AZ: high capital and irregular demand; project-linked purchasing, management approval or make-to-order.
- CX: low value and stable use; less frequent batch ordering may be economic.
- CZ: low-value intermittent items; candidates for standardisation, kit ordering or removal after review.
Define the remaining cells using service level, lead time, ordering cost and holding cost.
Do not set safety stock from an average alone
Lead-time variability matters as much as demand variability. Ocean freight from China, road supply from Türkiye and Gulf delivery do not share one lead-time distribution. Store production, booking, customs and site-receipt delays as separate milestones. Set a written service-level target for critical materials and compare overstock cost with project-delay exposure.
Five data-preparation controls
- Clean item codes, units and pack conversions.
- Separate one-off project demand from recurring use.
- Do not treat zero sales caused by stockout as zero demand.
- Label returns, cancellations and intercompany transfers.
- Calculate lead time from order to receipt and retain milestone detail.
How should AI forecasting be used?
AI can combine season, project schedule, price, campaigns and route delays to produce forecasts and scenarios. Store the data period, error metric, confidence range and reason for manual overrides. The system should not create an order without approved budget, purchasing authority and relevant project controls.
KPI and alert set
- Inventory turns and days on hand
- Service level and stockout duration
- Forecast error and bias
- Excess and slow-moving inventory value
- Lead-time variance
- Expiry or shelf-life exposure
- Open purchasing actions for A and Z classes
ERP governance
Classes may be recalculated monthly or quarterly, but preserve change history. Show who calculated them, the data period and approved exceptions. GS1's identify-capture-share traceability logic supports consistent links between items, locations and movements.
Frequently asked questions
Is every A item operationally critical?
No. A may indicate high consumption value; operational criticality is a separate dimension.
Should every Z item be removed?
No. Intermittent demand may serve a project, spare-part or strategic customer requirement.
How often should ABC-XYZ be refreshed?
Monthly or quarterly may fit the business, with interim updates after project, price or supply shocks.
Connect forecasts with the site logistics ETA and risk dashboard.