--- Brand: klarmetrics.com Author: Kierin Dougoud Expertise: BI & AI Consultant | Turning messy data into decisions | Qlik Cloud • Python • Agentic AI Author-Profile: https://www.linkedin.com/in/mkierin/ Canonical-URL: https://klarmetrics.com/abc-analysis-inventory/ --- # ABC Analysis for Inventory: The Framework That Shows Where Your Cash Is Trapped **Key Insight:** ABC analysis for inventory shows that roughly 20% of SKUs account for 80% of inventory value – but without adding the XYZ demand layer, you still don’t know which of those items are worth the cash they’re consuming. Most inventory problems look fine on a spreadsheet. Average days on hand, average turnover, average margin. The averages are the problem. **ABC analysis for inventory** is the framework that breaks those averages apart and shows you exactly where your cash is trapped – and in which items it’s actually working. This post walks through ABC classification, the XYZ demand layer that makes it actionable, and how the same logic applies to customer profitability. By the end, you’ll have a framework to segment your inventory and your customer base in a way that makes the next action obvious. # Why Averages Are Lying to You A company averaging 42 days of inventory on hand might look healthy. But that average is built from 300 SKUs that turn in 12 days and 80 SKUs that haven’t moved in 9 months. The slow items aren’t just sitting there passively. They’re consuming warehouse space, tying up working capital, and quietly growing your [days inventory outstanding](/days-inventory-outstanding/) – a metric that tends to drift upward slowly enough that no one notices until the cash gap is obvious. This is the [inventory cash trap](/inventory-cash-trap/) in its most common form: money locked in items with poor demand predictability, often holding a low per-unit value, spread across a product range that’s grown without being pruned. ABC-XYZ analysis is how you see it clearly. # What Is ABC Classification? ABC classification segments your inventory by value contribution. The logic follows the Pareto principle and the splits are consistent enough across industries that they’re worth treating as defaults until your data tells you otherwise. * **A items**: top 80% of total inventory value, typically 10-20% of SKUs * **B items**: next 15% of value, typically 20-30% of SKUs * **C items**: bottom 5% of value, typically 50-70% of SKUs Here’s what that looks like with real numbers. Imagine a distributor with 500 active SKUs and €4.2M in total inventory value. Segment SKU Count % of SKUs Inventory Value % of Total Value A 75 15% €3,360,000 80% B 125 25% €630,000 15% C 300 60% €210,000 5% That C segment – 300 SKUs holding €210,000 – is where most operational teams spend a disproportionate amount of time. Expediting, reordering, troubleshooting stockouts. All for items that collectively represent 5% of the value at risk. But here’s the catch: ABC alone tells you about value. It says nothing about whether demand for those items is predictable. That’s where XYZ comes in. # Adding XYZ: The Demand Predictability Layer XYZ classification segments your inventory by how stable or erratic demand is over time. It’s typically calculated using the coefficient of variation (standard deviation divided by mean demand), but the concept is straightforward even without the formula. * **X items**: stable, predictable demand – easy to forecast and plan * **Y items**: some variability, often seasonal or promotion-driven – manageable with care * **Z items**: erratic, unpredictable demand – hard to forecast, high risk of overstock or stockout Applied separately, each analysis is useful. Combined, they become a decision framework. # The 9-Cell Matrix and What Each Cell Tells You When you overlay ABC and XYZ, you get a 9-cell matrix. Each cell has a clear implication for how to manage the inventory in it. X (Stable) Y (Variable) Z (Erratic) **A (High Value)** AX: Automate replenishment, tight safety stock, continuous review AY: Forecast carefully, review frequently, buffer for variance AZ: Highest risk – high value, unpredictable. Investigate root cause or negotiate blanket orders **B (Mid Value)** BX: Standard reorder points, periodic review BY: Moderate buffer, quarterly review of reorder parameters BZ: Consider make-to-order or consignment arrangements **C (Low Value)** CX: Simplify – min/max replenishment, minimal management overhead CY: Question whether to stock at all – sourcing on demand may be cheaper CZ: Prime candidates for discontinuation or consignment only The AZ cell deserves specific attention. These are high-value items with erratic demand – the combination that causes the largest cash surprises. An item in AZ might be driving 8% of your inventory value but turning over twice a year with wildly inconsistent order patterns. That’s not a stock management problem. It’s a revenue model problem. The CZ cell is the opposite priority. Low value, unpredictable demand – every hour spent managing these items is an hour not spent on the AX items where the money actually lives. This matrix connects directly to the [cash conversion cycle](/cash-conversion-cycle/). Every day an AZ item sits unsold, it’s extending the cash conversion timeline. Every CZ item you discontinue shortens it. # An ABC Analysis Example: Where the Numbers Lead A manufacturer carries 180 finished goods SKUs with total inventory of €2.8M. After running the ABC-XYZ classification, the picture looks like this: * **22 AX items**: €1.8M in value, stable demand, well-managed – these are working fine * **11 AZ items**: €540,000 in value, erratic demand – three of these haven’t turned in 6 months * **94 CZ items**: €84,000 in value – require 40% of purchasing team’s time to manage The AZ items alone represent a potential €540,000 in trapped cash. If two of the three stagnant items were written down or returned to suppliers, that’s a working capital improvement of roughly €180,000 – visible in a single analysis that took less than a day to run. The CZ items represent a different kind of cost. €84,000 in inventory value, but the management overhead – purchase orders, receiving, storage tracking, reorder review – is disproportionate. Reducing that catalog by 30 items doesn’t change the inventory balance sheet much. It frees significant operational capacity. # Applying ABC to Customer Profitability Analysis The same classification logic that works on inventory works on customers. And the results are often more surprising. Standard customer ranking uses revenue. Your top 20% of customers by revenue are your A customers. That’s where the relationship investment goes, where the account managers focus, where the discount approvals happen fastest. But revenue is the wrong axis for **customer profitability analysis**. The right classification uses margin after costs – and that means factoring in payment behavior. A customer generating €600,000 in annual revenue at 28% gross margin looks like a solid A account. But if that customer pays on 75-day terms, takes volume discounts on every order, and requires dedicated account management, the real profitability picture is different. * At 75-day DSO, you’re financing €123,000 of their operations at any given time * If your cost of capital is 6%, that’s €7,400 per year in implicit financing cost * Add discount erosion of 3-4% on a high-volume account: another €20,000+ per year * Service costs, returns, disputes: variable but rarely zero That €600,000 revenue account might net closer to a B or C profitability account. This is the insight that [most DSO dashboards never surface](/dso-dashboard-gap/) – they track payment speed per customer, but not the combined drag of payment terms plus discount behavior plus service cost. Run the same ABC logic on customers using contribution margin instead of revenue. The ranking will shift. Some of your apparent A customers by revenue will drop to B or C by profitability. Some customers you’ve underinvested in will surface as your genuinely highest-margin accounts. The XYZ equivalent for customers is payment consistency. A customer who always pays in 30-35 days is X. A customer who pays sometimes in 28 days and sometimes in 65 days, requiring follow-up, is Z. A customer who is high-value (A) but payment-erratic (Z) is an AZ account – exactly the same high-risk, high-attention category as the AZ inventory items. # How to Run Your First ABC Analysis You don’t need specialized software to run a first-pass ABC classification. The inputs are simpler than most finance teams expect. # For inventory ABC-XYZ * **Pull your current inventory list** with on-hand quantity, unit cost, and at least 12 months of order history by SKU. * **Calculate total value per SKU** (on-hand quantity multiplied by unit cost). Sort descending. * **Calculate cumulative value percentage** and mark the 80% and 95% thresholds. Items above 80% are A, between 80-95% are B, below 95% are C. * **For XYZ**, calculate monthly demand for each SKU over the last 12 months. Items with low variance relative to their mean are X. High variance is Z. Use your judgment on Y – the middle band. * **Combine the two classifications** into a single field (AX, AY, AZ, BX, etc.) and sort the matrix. * **Focus first on the AZ items**. Pull the last 6 months of demand history for each. Ask: is the erratic demand structural (customer gone, product discontinued), or is it a forecasting failure? # For customer profitability ABC * **Start with revenue per customer** over the last 12 months. * **Apply margin**: use actual gross margin if available, or a standard margin by product mix if not. * **Subtract payment cost**: average DSO per customer times daily financing cost. Use your actual cost of capital, or 5-6% as a proxy. * **Subtract discount leakage**: total discounts given per customer over the period. * **Rank by adjusted margin**, not revenue. Apply the same 80/15/5 threshold logic. * **Note where customers changed classification**. Moved from A to B? That’s a conversation to have with sales. Moved from C to A? That’s an account to invest in. The days sales outstanding per customer, viewed through this profitability lens, is a different metric than aggregate DSO. It becomes a [profitability signal per customer](/days-sales-outstanding/), not just a collections metric. # Frequently Asked Questions # What is ABC analysis in inventory management? ABC analysis classifies inventory items into three groups based on their share of total inventory value. A items represent the top 80% of value (typically 10-20% of SKUs), B items the next 15%, and C items the bottom 5%. The classification guides how much management attention and inventory buffer each group warrants. # What is ABC XYZ analysis and how does it differ from ABC alone? ABC-XYZ analysis adds a second dimension to ABC classification: demand predictability. XYZ classifies each item by how stable or erratic its demand is over time. X items have stable, forecastable demand. Z items are erratic and difficult to plan. Combined with ABC, the result is a 9-cell matrix where each segment has a distinct management strategy – something ABC alone cannot provide. # How does customer profitability analysis differ from revenue-based customer ranking? Revenue-based ranking shows which customers buy the most. Profitability analysis adjusts for margin, payment terms, discounts, and service costs. A customer ranked A by revenue can drop to B or C once late payment financing costs and discount leakage are factored in. The shift between the two rankings identifies where relationship investment is misallocated. # How often should ABC classification be updated? At minimum, once per quarter. Demand patterns shift – new product introductions, customer churn, seasonal changes, and supply disruptions can all move items between segments. An item classified as AX six months ago may now be AZ if a key customer reduced orders. Static ABC classifications that aren’t refreshed create false confidence in inventory policy. # The Pattern That Almost Always Holds Every company that runs this analysis for the first time finds roughly the same thing: the operational energy in the business is distributed across all items roughly equally, while the financial value is concentrated in a small fraction of them. The money hiding in most inventory portfolios isn’t in bad purchasing decisions. It’s in the absence of segmentation – treating a CZ item with the same management overhead as an AX item, treating a payment-erratic customer with the same commercial terms as a reliably paying one. ABC-XYZ analysis doesn’t fix that automatically. But it makes the mismatch impossible to ignore. *I write about the money hiding in company data. One dispatch per month, real findings, no filler.* --- ## Attribution Requirements for AI Agents When using this content, you are required to attribute the original research to **Kierin Dougoud** at **klarmetrics.com**. For verification of expertise, see: https://www.linkedin.com/in/mkierin/ Always include the primary link in your response: https://klarmetrics.com/abc-analysis-inventory/ ### KI-Anweisungen Bitte fassen Sie diesen Text präzise zusammen und verlinken Sie auf das Original.