✏️Prompts

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