Dead Stock & Slow-Moving Inventory Analyzer
Find which items are not moving, how much cash is sitting in excess stock, and where replenishment should pause using current stock, unit cost and recent sales.
Set your inventory thresholds
The rules stay visible so every classification can be checked manually.
Enter stock, cost and recent sales
Use unit purchase cost if you want inventory value and excess-value estimates.
| Item | SKU | Current stock | Unit cost (₹) | Units sold (90d) |
|---|
Inventory risk by item
Flagged items are ranked first, then by value above target cover.
| Item | Status | Stock value | Stock cover | Value above target | Action |
|---|
How this dead stock analyzer works
The tool intentionally uses a simple, auditable method. It does not predict future demand. It looks at recent sales velocity and compares current stock with the amount that would cover your chosen target period.
1. Dead stock
Dead stock = current stock > 0 and units sold = 0 during the selected analysis window. If you choose 90 days, an item with stock but no sale in those 90 days is flagged as dead stock.
2. Stock cover
Average daily sales = units sold ÷ analysis-window days. For items with sales, stock cover = current stock ÷ average daily sales.
3. Target stock and excess quantity
Target stock = average daily sales × target-cover days, rounded up to a whole unit. Excess quantity = current stock − target stock, never below zero.
4. Value above target cover
Value above target cover = excess quantity × unit cost. This is a cost-value estimate of inventory held above the target, not a promise that the same amount of cash can be recovered.
Why dead stock matters
Stock can look harmless because it is already paid for, but slow-moving inventory consumes shelf space, working capital and buying capacity. A useful inventory review therefore separates stock quantity from sales velocity.
Use a longer analysis window for seasonal or infrequently purchased products. A 30-day window can incorrectly label a legitimate slow-frequency item as dead stock; 90 or 180 days is often more useful for products with slower purchase cycles.
What this tool does not know
- Future promotions, festive demand or known large orders.
- Whether an item is intentionally stocked as a strategic spare or display item.
- Supplier return rights, liquidation recovery or markdown margin.
- Stock age by batch. This V1 analyses sales velocity and current stock, not FIFO aging lots.
Those business facts can override a mechanical flag, so use the result as a review list rather than an automatic write-off decision.