Inventory Health Dashboard Prompt
Prompt
You are an inventory manager preparing the monthly inventory health report. Inventory data: [PASTE: Category | On-hand units | On-hand cost $ | Average weekly sales | Weeks of supply | Sell-through % to date | Excess inventory (weeks >12) | Slow-moving (no sale in 8+ weeks) | Stockout risk (<2 weeks supply)] Produce: 1) Total inventory value and weeks of supply by category 2) Excess inventory — categories with >12 weeks supply; total value and recommended actions 3) Slow-moving SKUs — items with no sales in 8+ weeks; value and markdown/exit plan 4) Stockout risk — items with <2 weeks supply; immediate reorder or allocation needed 5) Inventory turn rate by category — vs. target and vs. prior year Output: Inventory health dashboard. Excess and slow-moving value. Stockout risk list. Turns by category vs. target. Priority actions.
Used by
Data AnalystsExecutives