Many Hong Kong SME owners share a truth they'd rather not face: the money they've "made" is actually sitting in the warehouse. For retail, wholesale, F&B and even online shops, inventory often locks up 30–50% of working capital. Buy too much and it becomes dead stock; buy too little and you lose customers to stockouts — this dilemma is the hidden cost that SMEs most easily overlook, yet it burns money the fastest.
Inventory is "money that isn't moving"
Industry figures suggest Hong Kong retailers lose as much as 5–10% of revenue every year to overstocked, expired or damaged goods. On the other side, research shows around 30% of customers will walk to a competitor the moment the item they want is out of stock — and many won't come back. In other words: manage inventory poorly and you bleed dead stock on one side while losing customers on the other.
The good news? You don't need a six-figure ERP system to get it right. The three moves below can all be done in Excel.
Move 1: ABC analysis — focus on the most valuable 20%
The 80/20 rule holds for inventory too: around 20% of your items typically generate 80% of revenue. Sort your items into three groups:
- A items — fast-moving and high-value (about 20% of SKUs). Watch these daily; they must never go out of stock.
- B items — mid-tier (about 30% of SKUs). Check them weekly.
- C items — slow-moving, low-value (about 50% of SKUs). A monthly look is enough, and keep order sizes small rather than buying big "bargains".
Rank by sales value, calculate the cumulative percentage, and you'll have your ABC list in minutes. Then spend 90% of your attention on A items and relax a little on B and C.
Move 2: Safety stock — one formula that prevents stockouts
Stockouts shouldn't be managed by gut feeling. Use a simple formula to work out how much buffer to hold for each item:
Safety stock = (average daily sales × longest lead time) − (average daily sales × average lead time)
Say an item sells 20 units a day on average, normally takes 3 days to restock, but has taken as long as 7 days at worst. Then safety stock is: (20 × 7) − (20 × 3) = 80 units. In other words, keep at least 80 units as a buffer to ride out restocking delays. Run this for every A item and your stockout risk drops sharply.
Move 3: Regular stocktakes + low-stock alerts
However good your system is, you still need to physically count stock on a regular schedule. A common rhythm: count A items monthly, B items quarterly, and C items every six months. A stocktake isn't just about reconciling numbers — it's also a chance to clear out expired or damaged dead stock and slim down the warehouse.
At the same time, set up a "low-stock alert" in Excel: when an item's quantity falls below its safety-stock level, have the cell turn red to remind you to reorder. A simple IF formula does the job and saves you from counting stock from memory every day.
Summary
Well-managed inventory frees up a large chunk of trapped cash and keeps every customer who walks through your door. ABC analysis, the safety-stock formula, and regular stocktakes with alerts — none of these need a big system, and you can start all three in Excel today. Once you see dead stock shrink and lost customers decline, you'll understand: inventory isn't a cost, it's profit you haven't taken back out yet.