Overstock Cost Calculator

The underlying calculation

Overstock cost is what excess stock costs before it eventually sells or is written off: excess units × unit cost × carrying rate × years held, plus the markdown eventually needed to move it.

The excess is anything above the quantity that a reasonable forecast supports over a reasonable horizon. Defining that horizon is the judgement, most businesses use twelve months, so anything beyond a year of coverage counts as overstock.

Worked through

A product selling 40 a week with 3,200 units on hand. That is 80 weeks of coverage against a target of about eleven, so roughly 2,760 units are excess.

At $18 cost, that is $49,680 of capital. At 25% carrying cost, holding it for the 69 extra weeks it will take to sell costs $16,500.

And that assumes it sells at full price. If half of it eventually needs a 40% markdown, that is a further $9,940 of lost contribution. The total cost of the over-buy is around $26,000 on a product with an annual COGS of $37,440, nearly a year's cost of goods, spent on being wrong about a forecast.

Where it goes wrong

The carrying cost is real but invisible. It never appears as a line in the accounts, which is why overstock persists for years in businesses that would never tolerate an equivalent cash expense.

It also understates the opportunity cost. The $49,680 tied up in this product could have funded stock that sells, and the return foregone on that alternative is usually larger than the carrying cost itself.

Making it useful

Set a coverage ceiling and report against it monthly. Anything above, say, twenty-six weeks of coverage goes on a list with a required action, and the list is short enough to be worked through.

Then act early. Overstock gets more expensive every month it is held, and a 20% markdown today usually beats a 50% markdown in a year, both in cash recovered and in the capital released to buy something that sells.

Preventing it rather than clearing it

Overstock nearly always originates at the buying decision rather than in the selling. A volume discount taken without the carrying cost calculation, a minimum order quantity accepted without question, or a forecast built on a good month are the three usual sources.

The single most effective control is a rule that no order may exceed a stated number of weeks of coverage without a written reason. That converts an unconsidered decision into a considered one, and most of the bad orders do not survive having to be justified.

The second control is to review the previous season's overstock before placing the next season's orders. Buying decisions are made optimistically, and the most effective corrective is the physical evidence of the last time optimism was wrong, which is usually sitting in the warehouse where it can be looked at.

One more source worth naming: overstock created by a stockout. A business that runs out, over-corrects on the next order, and then over-corrects again is oscillating rather than forecasting, and the swings get larger rather than smaller.

The fix is to change the safety stock rather than the order quantity after a stockout. Raising the buffer addresses the variability that caused it; raising the order quantity simply moves the same problem to the other end of the cycle.