Managing Stockouts & Overstock

Spot the twin dangers of empty shelves and dead cash, and keep stock in the healthy middle.

4 lessons 35 min 5-question assessment 70% to pass

What you’ll learn

Explain the real cost of a stockout

Explain the real cost of overstock

Spot both problems early in reports

Balance stock to avoid swinging between extremes

Lesson 1 of 4 Reading 8 min

The cost of a stockout

A stockout is when a customer wants an item and you have none. The obvious cost is the lost sale, but the hidden cost is the customer who walks to a competitor and may not come back.

Stockouts matter because they quietly erode both revenue and loyalty. Unlike a write-off, a stockout never shows up as a line in your books — you simply never earn the money you could have.

If a popular SKU with a KES 1,500 margin stocks out for 4 days at a branch selling 15 a day, that is 60 lost sales and KES 90,000 of margin gone — none of it visible in any report. Worse, a handful of those 60 customers now shop elsewhere by habit, so the real cost runs past that one week.

Key takeaways

A stockout is wanting an item you do not have.
Costs are the lost sale plus lost customer loyalty.
Stockouts never appear as a line in your books.
Example: a 4-day stockout can quietly lose KES 90,000 of margin.

Lesson 2 of 4 Reading 9 min

The cost of overstock

Overstock is the opposite trap: holding far more than you can sell in a reasonable time. It feels safe but it is cash frozen on the shelf, plus storage, handling, and the risk of obsolescence.

Overstock matters because that frozen cash cannot pay suppliers, staff, or rent, and slow stock often ends up discounted or written off. Full shelves can hide a starving bank account.

If you hold 2,000 units that cost KES 300 each, that is KES 600,000 of cash sitting still — and if you only sell 50 a week, it is over nine months of stock. That money could have bought faster-moving lines; instead it risks ending in a clearance sale at half price.

Key takeaways

Overstock is holding more than you can sell soon.
It is frozen cash plus storage and obsolescence risk.
Frozen cash cannot pay suppliers, staff, or rent.
Example: 2,000 units at KES 300 = KES 600,000 stuck, 9 months’ stock.

Lesson 3 of 4 Practice 9 min

Spotting both early

Both problems are visible early if you watch the right signals. Low-stock and zero-stock reports flag impending stockouts; days-of-stock and slow-mover reports flag building overstock.

Catching either early is far cheaper than reacting late. A reorder placed when stock dips is routine; an emergency air-freight or a clearance sale is expensive damage control.

A days-of-stock report shows you hold 9 months of one SKU but only 2 days of another. The 2-day item needs an urgent order before it stocks out; the 9-month item needs a buying freeze and maybe a promotion. One report, read weekly, catches both extremes while they are still cheap to fix.

Key takeaways

Low/zero-stock reports flag impending stockouts.
Days-of-stock and slow-mover reports flag overstock.
Catching early beats expensive late reactions.
Example: one report shows a 2-day SKU and a 9-month SKU to act on.

Lesson 4 of 4 Reading 9 min

Balancing the two

The goal is the healthy middle: enough stock to serve demand and absorb a wobble, but not so much that cash is frozen. Reorder points and safety stock are the tools that hold that line.

Balance matters because the two dangers pull against each other — over-correct a stockout and you create overstock, over-correct overstock and you create stockouts. The aim is a stable band, not a swing.

If a stockout scare makes you triple every order, in two months you swap empty shelves for KES 600,000 of dead stock. The fix is not panic buying but setting a sensible reorder point and buffer per SKU, then letting the trigger — not fear — drive the next order.

Key takeaways

Aim for the healthy middle, not either extreme.
Reorder points and safety stock hold the line.
Over-correcting one danger creates the other.
Example: panic-tripling orders turns stockouts into KES 600,000 dead stock.

| AWRA OpsHub

Managing Stockouts & Overstock

What you’ll learn

Course content

The cost of a stockout

The cost of overstock

Spotting both early

Balancing the two

Finished the material?

More in this path

Inventory Foundations

Warehouse & Locations

Units of Measure & Conversions

Need a quick answer while you read?

AwraIQ