Aged Stock: The Cost Nobody Talks About

Aged stock is one of those topics that sits quietly in the background of a retail business, rarely making it onto the agenda until it becomes impossible to ignore — a clearance event, a stocktake result, or a year-end valuation that suddenly makes the problem visible. By that point, the cost has already been accumulating for months. The conversation retailers need to have about aged stock isn't just about clearance strategy. It's about opportunity cost — what that stock, that cash, and that space could have been doing instead.

"Aged" doesn't mean the same thing across all product types, and a KPI that works perfectly for one category will give you a completely false picture in another.

"Aged" Is Not a Universal Definition

A fashion item that has been on your floor for three weeks may already be aged. A consumable product — cleaning supplies, stationery, basic homewares — could sit in rotation for two years and still be commercially viable. A seasonal product has a hard deadline after which its value drops sharply regardless of how long it's been there. A trend item can go from high demand to unmarketable in a matter of days if the cycle moves on.

This matters because retailers who apply a single aged stock definition across their entire range — "anything over 90 days is aged" — are making decisions based on a number that is correct for some products and meaningless for others. The first step in building a genuine aged stock function is defining what "aged" actually means, category by category, based on the product's natural lifecycle in your business.

A fashion accessory might be aged at four weeks. A kitchen staple might not be aged at six months. A Christmas decoration is aged on the 26th of December regardless of when it arrived. These are different problems requiring different responses, and your KPIs need to reflect that.

The KPIs Worth Knowing — And What They Actually Tell You

There is no single KPI that tells the full story of aged stock across a retail business. The right metrics depend on your product mix, your business model, and what decisions you're trying to make. Here are the key ones, how to calculate them, and what each one is actually measuring.

Stock Turn (Inventory Turnover)

Stock turn measures how many times your inventory sells through and is replaced over a given period. It is one of the most widely used retail metrics and one of the most frequently misapplied.

Calculation: Cost of Goods Sold ÷ Average Inventory Value (at cost)

A higher stock turn generally indicates healthier inventory management — product is moving. But the benchmark varies enormously by category. A grocery business might turn inventory 20–30 times per year. A jewellery retailer might turn 1–2 times. Applying a single stock turn target across a multi-category business will always produce misleading results. Calculate it by category, not just across the total business.

Weeks of Supply (WOS)

Weeks of supply tells you how long your current inventory will last at the current rate of sale. It is particularly useful for identifying lines where supply has significantly outpaced demand.

Calculation: Current Stock Units ÷ Average Weekly Sales Units

A product with 52 weeks of supply is not just slow — it represents a full year of cash tied up in a single line. For a trend product, anything above 4–6 weeks may warrant immediate action. For a replenishment staple with a reliable sales rate, 12–16 weeks might be entirely acceptable. The number only has meaning in the context of the product's expected lifecycle.

Days on Hand (DOH)

Days on hand is the daily equivalent of weeks of supply and is often more useful for fast-moving categories where weekly data is too coarse.

Calculation: (Current Stock Units ÷ Total Units Sold) × Number of Days in Period

Sell-Through Rate

Sell-through rate measures the percentage of stock received that has been sold within a defined period. It is particularly relevant for seasonal buys, trend ranges, and any product purchased as a finite batch rather than a replenishment line.

Calculation: Units Sold ÷ (Units Sold + Units Remaining) × 100

A sell-through rate of 85% or above is generally considered strong for a seasonal or fashion range. Below 70% and you are carrying meaningful residual stock that will require markdown to clear. Below 50% and you have a buying or ranging problem that needs to be understood before the next order is placed.

Aged Stock as a Percentage of Total Inventory

This is a business-level health metric — the proportion of your total inventory value that sits in product you have defined as aged.

Calculation: Value of Aged Stock (at cost) ÷ Total Inventory Value (at cost) × 100

There is no universal benchmark for this number. The right level depends on your category mix and your aged stock definitions. Track it monthly. A business that only looks at it at stocktake is always reacting, never managing.

The Hidden Cost of Holding

This is the part of the aged stock conversation that most retail businesses avoid — because the cost is real, it's ongoing, and it doesn't show up neatly in a P&L line.

Cash and opportunity cost. The cash invested in that stock is not available for anything else. It cannot be used to fund a new range, invest in a better-performing category, cover an operational cost, or simply sit in an account earning interest. If you paid $50,000 for stock that is now aged, you don't just have a stock problem — you have $50,000 that has been removed from your business's working capacity. Every month it stays, that opportunity cost grows.

Storage and warehousing. Whether you own your warehouse or lease it, every square metre occupied by aged stock is a square metre not available for productive inventory. In a leased facility, you can calculate the cost directly: your rent per square metre multiplied by the space the stock occupies. In a retail store, aged stock on the floor is occupying planogram space that a better-performing product could be using.

Insurance. Your stock insurance premium is based on total inventory value. Aged stock you are unlikely to sell at cost is inflating your insured value and your premium.

Staff time. Aged stock is counted, moved, reported on, and managed. Every stocktake hour spent on product that should have been cleared months ago is a direct labour cost. Every buyer meeting that includes aged stock review is time not spent on forward planning.

Markdown liability. The longer you hold aged stock, the deeper the markdown required to move it. A product that could have been cleared at 20% off six months ago may now require 50% off — or may not move at any margin at all. The markdown you eventually take is not just a clearance cost. It is the compounded result of every week you held the stock and did nothing.

The Opportunity Cost Calculation

The most useful exercise a retail business can do with its aged stock is a genuine opportunity cost calculation — not just "what is this stock worth," but "what has holding this stock cost us, and what could we have done with that resource instead."

It starts with the value of the aged stock at cost. Then you add the carrying costs — storage, insurance, and staff time attributable to managing that stock — over the period it has been aged. Then you consider the markdown you will need to take to clear it. The total of those three figures is the real cost of the decision to hold.

Set against that is the opportunity: if that cash had been redeployed into a faster-moving line six months ago, what would the return have been? That is the conversation a buying team should be having — not just "how do we clear this" but "how did we get here and what would the business look like if that capital had been working harder."

Building an Aged Stock Function That Actually Works

The businesses that manage aged stock well don't just have better KPIs — they have a process. Aged stock is reviewed on a regular cadence, not just at stocktake. Category managers are accountable for aged stock levels in their area. Buying teams make clearance decisions early, while product still has residual value — not late, when it doesn't. And the buying process includes an honest assessment of what "aged" will mean for each product before the order is placed.

The KPIs outlined above are tools. They tell you where the problem is and how large it is. What they cannot do is substitute for the discipline of acting on what they reveal. A business that calculates weeks of supply accurately but doesn't act when a line hits 20 weeks has done the analysis and ignored it — which is, in some ways, worse than not measuring at all.

The right set of KPIs for your business depends on your category mix, your product lifecycles, and the decisions your team needs to make. What matters is that those KPIs are defined deliberately, applied consistently by category, and connected to a process that produces action — not just a number on a spreadsheet nobody acts on.

If your business is carrying aged stock that isn't being actively managed, or if your current metrics aren't giving you a clear picture of what it's costing you, that is a solvable problem. I work with retailers to build inventory management frameworks that identify aged stock early, calculate the real cost of holding, and connect KPIs to buying and clearance decisions that actually get product moving. If that's a conversation worth having, get in touch.