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