Results
Analysis Summary
Formulas Used
This calculator classifies items using two complementary methods: ABC (value-based) and XYZ (variability-based).
- Consumption Value = Unit Cost × Annual Usage. This ranks items by annual monetary impact.
- Percent of Total = (Consumption Value ÷ Sum of all Consumption Values) × 100.
- Cumulative % is the running total of Percent of Total; ABC categories are assigned using the cumulative thresholds you set (default A ≤ 70%, B ≤ 90%, C > 90%).
- Coefficient of Variation (CV) = Standard Deviation of monthly usage ÷ Mean monthly usage. CV measures demand variability and is used to assign X/Y/Z categories (lower CV → X, medium → Y, high → Z).
Combined category (for example A-X) helps focus inventory policies: high-value stable items (A-X) vs low-value highly variable items (C-Z).
FAQ
Provide at least: ItemID, ItemName, UnitCost, AnnualUsage. Optionally include monthly usage columns (Month1..Month12) to calculate CV.
Common defaults are A ≤ 70% and B ≤ 90% of cumulative value, but you can adjust thresholds to reflect your business priorities.
If monthly usage is missing or insufficient, the tool sets CV to N/A and assigns XYZ as N/A, but ABC classification will still work using consumption value.
A-X items are high-value and low-variability — prioritize reliable supply, tighter inventory control, and frequent review.
Yes — use the Export Results (CSV) button to download the analyzed table for sharing or further processing.
No. All analysis in this calculator runs locally in your web browser. Files you upload or paste are processed in-memory client-side and are not sent to any external server by this tool. Nothing is stored on our servers. When you press Export Results (CSV), the browser downloads a file to your device; that file is stored only where your browser saves downloads. If you run this page on a third-party website or server, review that site's privacy policy—only then might data be transmitted or logged by that host.
Other Free Supply Chain Tools
- ABC-XYZ Inventory AnalysisClassify inventory by value and variability.
- Carrying Cost Impact CalculatorQuantify the financial impact of holding inventory.
- EOQ & Reorder Point SuiteOptimize order quantities, reorder points, and safety stock.
- Inventory Turnover CalculatorMeasure inventory turnover ratio and efficiency.
- Lead Time CalculatorCalculate procurement and supply chain lead times.
- Obsolete & Slow-Moving Stock ToolIdentify and analyze slow-moving or obsolete inventory.
- Procurement Savings CalculatorCalculate cost savings and ROI on procurement decisions.
- Safety Stock CalculatorEstimate safety stock and stockout risk.
- Supplier Reliability CalculatorEvaluate supplier performance, lead times, and defect rates.