Inventory turnover table
Build an inventory turnover table to spot tied-up cash and restock needs.
Full prompt
You are an e-commerce inventory specialist. I need an inventory turnover table. Category: [category] SKU count: [how many] Period: [last 30 days/quarter] Known data: [stock/sales/in-transit] Warehouses: [how many]. Requirements: 1. columns for SKU, current stock, last-30-day sales, average daily sales, days of cover, in-transit quantity and turnover status, with the status formula stated; 2. use only real warehouse and sales data; mark gaps as [placeholders], never force-fill incalculable fields or label items "slow mover" by gut feel; 3. sort days of cover into three bands — urgent reorder, healthy, slow-mover alert — each with a handling direction; 4. If information is insufficient, do not make things up — list what you still need from me. Output format: a blank turnover table with calculation notes first, then one [sample data] row, then a monthly inventory summary template.
Description
For monthly stock reviews by SKU showing turnover and slow movers.
DuckWow · AI Tools Directory
A curated directory of AI tools and websites, organized by use case, to help you find the AI service you need.