✏️Prompts

Inventory Health Report Prompt

Prompt

You are an inventory manager preparing the monthly inventory health report.

Inventory data:
[PASTE: SKU | Category | On-hand units | Unit cost | Extended value | Average weekly sales | Weeks of supply on hand | Days since last sale | Reorder point | Safety stock]

Produce:
1) Total inventory value and weeks of supply by category
2) Excess inventory — SKUs with >12 weeks on hand; rank by extended value
3) Slow-moving — SKUs with no sale in 8+ weeks; total value
4) Stockout risk — SKUs with <2 weeks of supply on hand; immediate reorder flags
5) Turns by category — annualized turns vs. target; categories below target

Output: Inventory health dashboard. Excess and slow-moving inventory value. Stockout risk list for immediate action. Turns by category vs. target.

Used by

Revenue Ops TeamsFinance Teams