Why inventory ties up cash
Inventory is money sitting on shelves. Excess stock means slow sales, storage costs, and risk of spoilage or obsolescence. The goal: keep enough stock to meet demand but not so much that cash is trapped.
Quick checklist to start (do now)
- Count fast-moving SKUs (top 20% that make 80% of sales).
- Identify slow SKUs (no sales in last 90 days).
- Calculate months of supply for each SKU: current units ÷ average monthly sales.
- Highlight items with months of supply > 3 (or > 1 for perishable items).
Step 1 — Separate SKUs into three piles
Action: Create three lists: A = fast sellers, B = steady, C = slow/obsolete.
- A items: top 20% SKUs by revenue — keep safety stock.
- B items: middle 50% — aim for lean stock.
- C items: bottom 30% — plan clearance or return.
Decision rule: If an SKU sold fewer than 2 units in 90 days, put it in C.
Step 2 — Set clear reorder rules
For each A/B SKU, set these numbers and automate if possible:
- Lead time (days between order and arrival).
- Average daily usage (units sold per day over last 90 days).
- Safety stock = lead time × average daily usage × 25% (round up).
- Reorder point = (lead time × average daily usage) + safety stock.
Example: Lead time 10 days, avg daily usage 2 units → safety stock = 10×2×0.25 = 5 units. Reorder point = (10×2)+5 = 25 units.
Step 3 — Reduce order frequency for slow-moving items
Action: Move C items to one of these paths:
- Clearance sale or bundle within 30 days if carrying cost > expected margin.
- Return to supplier if contract allows.
- Donate or recycle when cost of storage or handling exceeds value.
Decision rule: If storage + handling per month > 10% of item’s value, clear it.
Step 4 — Negotiate with suppliers
Actions to free cash quickly:
- Ask for longer payment terms (e.g., net 30 → net 60) for slow sellers.
- Request smaller, more frequent shipments to lower inventory on hand.
- Negotiate consignment for slow or seasonal items.
Example script: "Can we try a 60-day payment term for the next 3 months and smaller weekly deliveries? This helps us increase order frequency without extra stock."
Step 5 — Use promotions strategically
Actions:
- Run targeted discounts on C items tied to minimum purchases of A items.
- Create bundles: 1 fast seller + 1 slow seller at a small discount.
- Limit promotion length to 2–4 weeks and track lift in sales.
Decision rule: Offer a discount up to the margin needed to clear stock but not below variable cost unless tax write-off or donation is better.
Step 6 — Improve forecasting simply
Do this weekly:
- Use last 12 months of sales by SKU and adjust for seasonality.
- For new SKUs, run a 6–8 week test with small orders and scale up.
- Flag any SKU whose forecast error > 30% and review reorder policy.
Step 7 — Reduce holding costs
Actions:
- Trim storage space: rent only what you need monthly.
- Consolidate packaging to fit more on shelves and reduce handling time.
- Cross-train staff to check stock weekly and fix misplacements.
Step 8 — Turn inventory into cash fast
- Flash sale to email list for 7–14 days with clear urgency.
- Sell slow items to liquidation buyer for quick cash if margin not critical.
- Offer trade credit to regular customers (short-term) to move larger orders.
Simple KPIs to watch weekly
- Days Inventory Outstanding (DIO) = (Average Inventory / Cost of Goods Sold) × 365. Goal: lower over time.
- Inventory Turnover = COGS / Average Inventory. Higher is better; aim to improve by 10% in 3 months.
- Months of Supply per SKU. Target: 1–3 months depending on item type.
Sample 30-day action plan
- Week 1: Count top SKUs, separate A/B/C, run quick clearance on 10 worst items.
- Week 2: Set reorder points, negotiate terms with two major suppliers.
- Week 3: Launch 10-day flash sale and bundle offers, reduce storage space where possible.
- Week 4: Review KPIs, adjust forecasts, and plan next month’s orders.
Short decision rules cheat-sheet
- Sell or clear if no sales in 90 days.
- Keep 1–3 months supply for non-perishables; 1 month or less for perishables.
- If storage cost > 10% item value/month → clear or return.
- Raise reorder point if stockouts occur twice in 60 days.
Wrap-up: How to keep momentum
Pick one small change this week: run the 90-day sales check or negotiate one supplier term. Do that, measure the cash freed, and repeat. Small, consistent steps free up cash without killing sales.