Dead Stock Math: What Unmoving Inventory Costs You

The three costs of a unit that will not sell

• Capital cost. Cash tied up in stock cannot buy inventory that does sell. Price it at what that cash would earn elsewhere in your business.
• Storage cost. Warehouse or 3PL fees per unit, every month, for as long as it sits.
• Obsolescence. Seasonal relevance and resale value decay. Rates differ by category, and a seasonal item loses value faster than a staple.

The flag uses weeks of cover: how many weeks the current stock lasts at the current sales pace. Half a year of cover with no seasonal bump coming is a sensible place to start asking questions.

The clearance break-even

The question is never whether you can sell it at full price eventually. The question is whether waiting beats clearing now. Compare what clearance recovers today with what you expect from waiting, minus the carry you will pay in the meantime:

For genuinely dead products, with months of cover and no season coming, clearing now wins more often than it feels like it should. Protecting the original cost basis is sunk-cost thinking, because that cash has already left.

A worked example with a sample product

The sample store, Cascade Supply Co., sells a Last-Season Insulated Vest with a gross margin of 17.8%. The name suggests leftover stock, but the sample file has no inventory counts, so this example uses only the margin. To keep the arithmetic readable, count per $100 of full price.

• Product cost: $82.20 (the other 17.8% of the price is margin)
• A 20% clearance price: $80.00
• Result at clearance: $2.20 below cost on each $100 of full price

That looks like a loss, and it is a small one. Now look at the cost of waiting. Holding the vest only makes sense if you can later sell it for more than $82.20 plus what the wait costs. At full price you have $17.80 of room before the unit loses money. Carrying cost eats that room month by month:

The rates in that table are illustrative choices, so replace them with your own capital and storage costs. The point is the shape: at 17.8% margin there is very little room, so any stock that sits for more than a few months is likely worth less than the clearance price you could take today.

How to find dead stock in your own exports

You need two files: current stock on hand per product, and recent sales per product. Divide stock by weekly sales to get weeks of cover, then sort the list from longest cover to shortest. Products with no sales at all in the period will not divide, so list them first by hand. They are the clearest cases.

Two cautions keep the list honest. First, use sales from a window that matches the product's season, because a coat in July looks dead and is not. Second, count stock that is already on order. If a reorder is on its way for a product with 40 weeks of cover, that is the first thing to cancel.

Three ways a clearance goes wrong

• Discounting everything at once. A blanket sale teaches customers to wait, and it marks down stock that would have sold at full price. Start with the products that have the longest cover.
• Discounting too shallow. A 5% markdown on a product with 40 weeks of cover changes nothing. Pick a price that moves the units, then watch the sell-through for two weeks.
• Forgetting the codes. A clearance stacked on top of an existing code can push the price below cost. Review the active codes before any sale goes live.

What to do with the result

Sort dead stock into three piles. Clear what has no season coming. Bundle what pairs naturally with a product that does sell. Hold only what has a dated reason to sell later, such as a season that starts next month. Write the date next to every item in the hold pile, and clear it if the date passes with no sales.

Make it a monthly habit

Compute weeks of cover for every product from your inventory and sales exports each month. Anything that crosses the line goes on the clearance-or-bundle list before it ages into a write-off. ProfitFalcon ranks products by margin from an order export, and you can open the sample store to see where the low-margin products sit. The SKU rationalization guide covers what to do with them, and the profit margin calculator lets you test a clearance price against a product's cost. If you are comparing profit tools, the ProfitFalcon comparison page lists how each handles data access and price.