How to Calculate Excess Inventory

"We're overstocked on this" is a feeling until someone puts a number on it. The number is straightforward to get, and it's worth getting exactly rather than eyeballing. A shelf that looks full can still be well within what you actually need, and a shelf that looks fine can be quietly sitting on real excess.

What counts as excess

Excess inventory is stock you're holding above what you actually need to cover the near term — a relative measure, not a fixed unit count that applies the same way to every SKU. What "near term" means is your own target stock level: the amount that gets you through the stretch until your next planned order, plus lead time, plus your safety-stock buffer. Anything above that is excess by definition, whether it arrived from an oversized order, a forecast that ran ahead of reality, or a supplier's minimum order quantity that forced a bigger batch than you needed.

The formula

Excess Inventory = Current Stock on Hand − Target Stock Level

Target stock level is not something this post re-derives. Our guide to how much inventory you should keep covers the full formula (average daily sales × days until next order, plus average daily sales × lead time, plus safety stock) and a worked example. This post treats that number as an input and answers the next question: given what you're actually holding right now, how much of it is more than the target accounts for?

A worked example

Back to "Cedar & Fig, 250g," the SKU used throughout this site's formula posts so the numbers stay consistent from post to post. The target stock level guide already worked this SKU out to 240 units — 5 units/day × 30 days until the next order, plus 5 units/day × 12-day lead time, plus 30 units of safety stock.

Now say a supplier's minimum order quantity forced a bigger batch than planned, and current stock on hand actually sits at 400 units.

Excess inventory = 400 − 240 = 160 units. That's not "a lot of candles" as a feeling — it's 160 specific units representing roughly 32 days of sales at the SKU's own 5-units-a-day pace, sitting on the shelf beyond what the next reorder cycle needs. That's the number a markdown, a bundle, or a paused reorder is actually trying to work down to zero.

Excess vs. safety stock

These get confused because both sound like "more than the bare minimum," but they answer different questions. Safety stock is inside the target stock level — it's the buffer you deliberately planned to hold, sized to that SKU's own demand variability and lead-time risk, and you expect to mostly not touch it. Excess inventory is what's left over above the entire target, buffer included. A SKU sitting exactly at its target stock level has zero excess even though it includes a real safety-stock buffer; excess only starts once you're holding more than that whole calculated amount, buffer and all.

Once you've flagged which SKUs are carrying real excess, the next question is what actually caused it — identifying slow-moving inventory covers the velocity side of that diagnosis — and then what to do about the units you're already holding, covered in selling excess inventory without losing margin.

Running this formula by hand across a real catalog means pulling current stock and a target for every SKU, every review cycle, and that's exactly the pass that gets skipped once a season gets busy. StockCue's Overstock & dead stock report surfaces this exact number per SKU automatically, computed against your store's own live sales data instead of a spreadsheet formula someone has to remember to rerun.

Frequently Asked Questions

How do you calculate excess inventory?

Excess inventory equals current stock on hand minus your target stock level for that SKU. Target stock level is the amount you actually need to cover demand until your next planned order plus lead time, including safety stock — anything you're holding above that number is excess. If the result is negative or zero, you don't have excess on that SKU.

What's the difference between excess inventory and safety stock?

Safety stock is inside the target stock level — it's the deliberate buffer you planned to hold for demand spikes or supplier delays. Excess inventory is what's left over above that entire target, buffer included. A SKU can be exactly at its safety-stock level and have zero excess; excess only starts once you're holding more than the buffer accounts for.

Does a SKU with a high reorder point automatically have excess inventory?

No. A high reorder point usually just means the SKU sells fast, has a long lead time, or both — it reflects normal need, not oversupply. Excess is measured by comparing current stock on hand to the target stock level, not by the size of the reorder point on its own.