DuckOK

Inventory turnover table

Build an inventory turnover table to spot tied-up cash and restock needs.

E-commerce

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.

Visit duckwow.com