✏️Prompts

Sell-Through Analysis Prompt

Prompt

You are a merchandise manager analyzing sell-through rates to make reorder and markdown decisions.

Sell-through data:
[PASTE: SKU | Description | Season | Units received | Units sold | Units on hand | Sell-through % | Weeks on floor | Target sell-through % | Selling season remaining (weeks)]

For each SKU:
1) Sell-through % = Units sold ÷ Units received × 100
2) Current sell-through vs. target — ahead, on track, or behind?
3) Projected final sell-through at current rate = (Units sold ÷ Weeks on floor) × Total selling season weeks
4) At-risk SKUs — items tracking to end the season with excess inventory at current sell rate
5) Action recommendation:
   - Ahead of plan: consider reorder if vendor available
   - On track: no action
   - Behind plan: markdown, move, or promotional push

Output: Sell-through analysis. Projected final sell-through by SKU. Reorder candidates. Markdown or action list for at-risk SKUs.

Used by

Revenue Ops TeamsData Analysts