| Prioritize products for review | ABC analysis | Product name and annual revenue | Revenue-ranked A, B and C groups. This tool uses revenue, not annual consumption cost. |
|---|
| Measure how fast stock sells | Inventory turnover | Period COGS and average inventory at cost | Turnover ratio and days inventory outstanding for the selected period. |
|---|
| Find stock held too long | Inventory aging | Product quantities, unit costs and purchase dates | Age buckets and value tied up in older stock. |
|---|
| Investigate products with no movement | Dead stock calculator | Product stock, cost and last movement date | Candidates for review; a movement date alone does not prove future demand is zero. |
|---|
| Decide when to order | Reorder point | Average daily demand, lead time and safety stock | A stock trigger to compare against inventory position. |
|---|
| Decide how much to buy | Replenishment quantity | Demand, coverage period, stock, incoming units and commitments | Suggested units to order under the entered assumptions. |
|---|
| Compare inventory profitability | GMROI | Sales, COGS and average inventory cost | Gross profit per unit of currency invested in average stock. |
|---|
| Review sales of available units | Sell-through rate | Opening units, receipts and net units sold | Percentage of available units sold during one period. |
|---|