The two invisible inventory problems
Every retail and ecommerce business has two inventory problems that don't show up directly on the P&L:
- Lost sales from stock-outs. When you can't fulfill an order, the customer often goes to a competitor and never comes back. The lost revenue is invisible because it never happened.
- Trapped cash in dead stock. Inventory that's been sitting for 90+ days is cash you can't deploy on faster-moving items. The opportunity cost is invisible because it's not on the income statement.
For a typical SMB doing $2M in retail revenue, these two problems together typically destroy 10-25% of profitability — silently. Inventory analytics for small business [blocked] is the discipline of making both visible and actionable.
The five inventory metrics that matter
1. Inventory turnover ratio
Cost of goods sold / average inventory value. For most SMBs, healthy turnover is 4-6 annually. Below 3 means too much capital trapped in slow-moving stock. Above 8 means you're probably stocking out frequently.
2. Days of inventory on hand
For each SKU: current stock / average daily sales rate. Lets you see at a glance which items are about to stock out and which are over-stocked. Should be benchmarked against supplier lead time.
3. Sell-through rate by SKU
Units sold / units received in a period. A new SKU with 10% sell-through after 30 days is in trouble. One with 80% sell-through after 30 days is a winner you should reorder immediately.
4. Dead stock value
Total inventory value of items not sold in 90+ days. This is the dollar amount of trapped cash. Goal: keep it under 5% of total inventory value.
5. Stock-out incidents per week
Number of distinct SKUs that hit zero stock during the week. For high-velocity items, this is a direct measure of lost revenue.
Building the dashboard
If you're on Square [blocked] POS, Shopify [blocked], or any modern POS/ecommerce platform, the underlying inventory data is already being captured. The challenge is consolidating it into a single, actionable view.
Illuminated Intelligence [blocked] builds an inventory dashboard with all five metrics from a single OAuth connection. JARVIS, our AI business advisor [blocked], watches the dashboard daily and proactively alerts you to:
- High-velocity items projected to stock out within their reorder lead time
- New products underperforming their cohort sell-through benchmark
- Aged inventory that should be marked down or bundled to clear
- Suppliers whose lead times have lengthened (causing inventory math to fail)
A real example
A boutique retailer doing ~$3M annually in revenue connected their inventory data and discovered: $180K of cash trapped in items that hadn't sold in 6 months, $40K of estimated annual lost revenue from a single high-velocity SKU that stocked out every other week, and a supplier whose lead times had quietly extended from 3 weeks to 6, putting half their bestsellers at risk of seasonal stock-outs.
Fixing all three within 90 days unlocked $220K of working capital and increased annual revenue by ~$60K. The platform paid for itself in the first week.
Ready to see your business, illuminated? Start a free 14-day trial [blocked] of Illuminated Intelligence — no credit card required, full setup in under an hour. Or meet JARVIS [blocked], our AI business advisor that turns your data into next-step recommendations.