Inventory Carrying Cost Analysis

Inventory Carrying Cost Analysis#

Carrying cost components: capital cost (8-15% of inventory value, your cost of money), storage (3-5%, rent and utilities), insurance (1-2%), shrinkage and obsolescence (2-5%), handling (2-3%), and taxes (0.5-1%). Total: 20-30% annually. On $10M inventory, that's $2-3M/year in carrying costs. Every dollar of inventory reduction saves $0.20-0.30 annually.

Identifying Slow-Moving and Dead Stock#

Run an ABC-XYZ analysis quarterly. A items (top 80% of revenue): optimize availability. B items (next 15%): maintain moderate stock. C items (bottom 5%): minimize or eliminate. X items (stable demand): lean inventory. Y items (variable): moderate safety stock. Z items (sporadic): make-to-order if possible. Most companies find 15-25% of SKUs are dead stock generating zero revenue.

Economic Order Quantity in Practice#

EOQ = √(2DS/H) where D = annual demand, S = order cost, H = holding cost per unit. For a product with 10,000 annual demand, $50 order cost, and $5 holding cost: EOQ = √(2×10000×50/5) = 447 units. Order 447 units at a time, 22 times per year. This minimizes combined ordering + holding costs. Adjust for quantity discounts and minimum order requirements.

The Carrying Cost Nobody Puts on the Balance Sheet: Opportunity Cost of Capital#

A kitchenware importer sitting on $400,000 of slow-turning inventory rarely thinks of that stock as costing anything beyond the storage fee, but the capital tied up in it is not free — it is money that could have paid down a business loan, funded a new product line, or simply not been borrowed in the first place. If the business's cost of capital (its borrowing rate, or the return it could earn deploying that cash elsewhere) is 12% annually, that $400,000 in inventory carries an invisible cost of $48,000 a year, whether or not a single unit of it ever gets damaged, stolen, or written off. Most SMB owners intuitively price in storage rent and insurance because they see the invoices, but they routinely miss the capital cost because no invoice ever arrives for it — it simply shows up as reduced cash flow and a business that always feels tight on working capital despite reasonable sales. When this importer finally ran a proper carrying cost analysis including capital cost, they discovered their true carrying cost was 27% of inventory value annually, not the 12% they had informally assumed when just adding up storage and insurance line items. That gap changed how aggressively they pursued dead stock liquidation — a SKU that looked marginally profitable to keep on the shelf at a 12% assumed carrying cost was clearly a loser once the true 27% figure was applied.

Running an ABC-XYZ Analysis Step by Step#

To classify a catalog, first rank every SKU by annual revenue contribution from highest to lowest, then calculate cumulative percentage of total revenue as you move down the list. SKUs that together make up the first 80% of cumulative revenue are your A items — typically a surprisingly small share of total SKU count, often 15-20%. The next tier down to roughly 95% cumulative revenue are B items, and everything beyond that is C. A specialty food distributor running this exercise on 340 SKUs found that just 52 products (15% of the catalog) generated 81% of revenue, while 90 products generated barely 2% of revenue combined — many of those 90 had not sold a single unit in the prior six months. Layering the XYZ dimension on top — X for stable, predictable demand, Y for variable demand, Z for sporadic or one-off demand — refines the picture further: an A-item with Z-type sporadic demand (say, a large SKU ordered occasionally by one big customer) needs a very different inventory policy than an A-item with X-type steady weekly demand, even though both are top revenue contributors. Treating all A items identically, without the XYZ overlay, is a common mistake that leads to either excess safety stock on predictable items or stockouts on the sporadic ones.

What Dead Stock Actually Costs Beyond the Obvious#

When the specialty food distributor above investigated its 90 non-moving SKUs, the immediate instinct was to value the write-off at cost — call it a $35,000 problem and move on. But the fuller accounting included months of accumulated storage cost for product that had been sitting since before anyone noticed it had stopped selling, insurance premiums calculated on inventory value that included this dead stock, and warehouse space that could have been used for faster-moving SKUs, reducing pick-path efficiency for the staff working around it daily. Once all of this was totaled, the true cost of carrying those 90 dead SKUs for the additional two quarters before liquidation was closer to $61,000 — nearly double the naive write-off estimate. The practical lesson is that dead stock costs compound the longer it sits, because every additional month adds another slice of storage, insurance, and capital cost on top of a product that was never going to sell at full price anyway. Quarterly ABC-XYZ reviews exist precisely to catch this early, before a $35,000 problem quietly becomes a $61,000 one.

Turning Carrying Cost Analysis Into an Ongoing Discipline#

Carrying cost analysis is only useful if it happens on a cadence, not as a one-time exercise triggered by a cash flow scare. The businesses that manage this well set a quarterly calendar reminder to re-run the ABC-XYZ classification, recalculate their blended carrying cost percentage using current capital costs and actual insurance and storage invoices, and flag any SKU whose classification has shifted since the last review — a former A item sliding toward B or C is often the earliest signal of a product losing market relevance, well before the sales team notices the trend. AskBiz's trade intelligence tracking keeps landed cost, current stock value, and sell-through history together so this kind of quarterly review can be built from live data rather than reconstructed from scratch each time, which is usually the real reason SMBs let carrying cost analysis lapse — not because the framework is hard, but because pulling the underlying numbers together manually every quarter is tedious enough that it quietly stops happening.

Balancing Carrying Cost Against Stockout Risk#

Reducing carrying cost by aggressively cutting inventory is not free — it trades one cost for another, since thinner stock increases stockout risk and the associated cost of lost sales, expedited replenishment shipping, and customer goodwill. A homeware importer that cut safety stock across its catalog by 30% to reduce carrying cost saved roughly $22,000 annually in storage and capital cost, but stockouts on its top 20 SKUs rose from occasional to a near-monthly occurrence, and the emergency air freight used to cover the resulting gaps cost more than the carrying cost savings within the first two quarters. The right approach is not a blanket inventory cut but a SKU-by-SKU tradeoff: for A items with thin margins and high stockout cost, a higher carrying cost is often the correct economic choice; for C items with long shelf life and low stockout consequence, aggressive inventory reduction is close to free money. Running the carrying cost analysis alongside a stockout cost estimate for each SKU category, rather than optimizing one number in isolation, is what prevents this kind of false economy.