Dead Stock and Margin Alarms: Free the Cash on Your Shelf

Gazeloft 5 min read

The pain: the shelf that eats money twice

There are two silent thieves in every retail shop, and neither one touches the cash box.

The first is dead stock. That premium cereal you bought because a customer asked once. The fancy shampoo that looked good beside the regular one. The carton of a new biscuit brand the distributor talked you into. They sit on the shelf month after month, and because they are not rotting or leaking, they do not feel like a loss. But every naira inside them is a naira that cannot buy indomie, sugar or milk, the products that turn over every single day. Dead stock is capital in prison.

The second thief is the margin leak. Supplier prices in this economy climb in small steps, ₦200 here, ₦500 there, while shelf prices move in big embarrassing jumps that owners delay as long as possible. In the gap between those two speeds, products slide below a healthy margin, and some slide below cost entirely. The shop stays busy, the shelves stay moving, and the profit quietly thins. Busy but broke is not a paradox, it is arithmetic.

Both thieves share one trick: they are invisible day to day. You only catch them by comparing records over time, which is exactly the work nobody does by hand.

What the two cards do

Two of Gazeloft's eight shelf insight cards are built to catch them, computed from one shelf read with a 365-day movement lookback:

Dead stock lists the products that have stopped moving, so you can see exactly how much cash is trapped and in what. It turns a vague feeling of "some things are slow" into a number and a list of names.

Margin alarm flags products selling below a healthy margin. Because Gazeloft costs every sale at the weighted-average cost, which updates on every restock, the alarm catches the exact moment a product's true cost creeps up under a sleeping shelf price. Not at year end. Now.

Beside them, the total shelf value card tells you what the whole shelf is worth, so you can see dead stock as a percentage of your working capital, which is the number that should keep an owner honest.

Step by step: in the app

  1. Keep recording sales through the cart and restocks with true costs. Both cards feed on this history.
  2. Open your retail space's insights weekly and read the dead stock card. For each item on it, pick one of the four fates: discount it to move, bundle it with a fast mover, return it to the supplier if you can, or accept the small loss and clear it. The one wrong answer is "leave it and hope".
  3. Read the margin alarm card. For each flagged product, either raise the shelf price or renegotiate the cost. Check the product's current weighted-average cost right there before deciding the new price.
  4. After acting, watch next week's cards. Dead stock shrinking and margin alarms clearing is the scoreboard.

Step by step: on the web dashboard

  1. Log in at gazeloft.com and open the space's insights.
  2. Review dead stock alongside total shelf value to see the trapped percentage of your capital.
  3. Work through margin alarm items and update selling prices in the products area, on the spot, with the keyboard.

A worked example: Ngozi frees ₦74,000

Ngozi runs a boutique-and-provisions shop in Aba. Her shelf value card reads ₦1.1 million. Her dead stock card lists items with no sale in over 90 days:

  • 12 bottles of a premium shampoo, cost ₦2,500 each: ₦30,000
  • 8 packs of imported cereal, cost ₦3,800 each: ₦30,400
  • A shelf of hair accessories, total cost about ₦14,000

Total trapped: about ₦74,400, nearly 7 percent of everything she owns in stock, earning nothing for a quarter of a year.

She acts. Shampoo drops from ₦3,200 to ₦2,600 and gets a spot beside the fast-moving regular brand: nine bottles sell in three weeks, returning ₦23,400. The cereal goes into a "breakfast bundle" with milk and sugar at a small discount: six bundles clear. The accessories go on a ₦500 clearance basket by the door and melt away. Within a month, roughly ₦60,000 of trapped cash is back in her hand. She puts it straight into indomie and sugar, which turn over weekly at around a 15 percent margin. The same money that earned ₦0 for 90 days now earns roughly ₦9,000 a month, every month.

Meanwhile the margin alarm card flags two products. Sugar's weighted-average cost has crept to ₦1,020 while she still sells at ₦1,100, a margin of ₦80 where she believes she earns ₦200. And a soap line is actually below cost after the last restock: average cost ₦520, shelf price ₦500. She has been paying customers ₦20 to take soap away. Sugar moves to ₦1,250, soap to ₦600. Nobody protests, because the street prices moved months ago. Everyone else had already repriced. Only her shelf was still living in the past.

Tips and pitfalls

  • Judge dead stock by the money, not the item. ₦30,000 sleeping in shampoo is ₦30,000 that could be turning over weekly in noodles.
  • Clear dead stock at a small loss without shame. Recovering 80 percent of trapped cash and redeploying it beats owning a museum of full-price mistakes.
  • Let the margin alarm, not customer complaints, trigger price reviews. Customers will never tell you your price is too low.
  • When the alarm flags a product, check the last few restock costs before repricing. Sometimes the fix is a better supplier, not a higher price.
  • Watch what dead stock teaches you about buying. If distributor-pushed novelties keep landing on the card, the cheapest fix is saying no at the van.

Set the money free

Somewhere on your shelf right now, cash is sleeping in products that stopped moving, and margins are leaking under prices that stopped being true. Two cards, read weekly, end both. Stop guessing. Start seeing, at gazeloft.com.

Frequently asked questions

How does Gazeloft decide something is dead stock?

The card surfaces products that have stopped moving based on your actual sales history, with a lookback of up to 365 days behind the picture.

What is a healthy margin?

It varies by product and shop, but the alarm exists to flag products that have slipped below a healthy level, especially after restocks raise the weighted-average cost while the shelf price stays still.

Can a product be selling below cost without me noticing?

Easily, and it happens in real shops every month. Because every restock updates the average cost automatically, the margin alarm catches it the week it happens instead of at year end.

Should I ever just throw dead stock away?

Almost never as a first move. Discounting, bundling and supplier returns recover real cash. Binning is the last resort after the cheaper exits are tried.

Will clearing dead stock mess up my profit figures?

No, it will make them truthful. Discounted sales record at their real prices against real average costs, so your books show exactly what the clearance earned.

Tags: shelf value, pricing, margin alarm, dead stock, cash flow

Keep reading

All articles · Start free on Gazeloft