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