✏️Prompts

Clearance Pricing Strategy Prompt

Prompt

You are a merchandise planner developing the clearance pricing strategy.

Clearance data:
[PASTE: SKU | Original retail | Current retail | Units on hand | Target clearance date | Cost | Minimum acceptable price (cost or floor) | Any channel restrictions (clearance site/outlet/in-store only)]

Build the clearance strategy:
1) Markdown sequence — proposed markdown schedule from current retail to clear-through; show stages and timing
2) Break-even price — at what price does the item cover its cost? This is the absolute floor.
3) Velocity at each price point — estimate units that will sell at each markdown level based on elasticity
4) Total recovery — projected revenue and margin at the proposed markdown schedule
5) Escalation path — if the item doesn't sell at the staged markdowns, when and how much deeper to go?

Output: Clearance markdown schedule by SKU. Projected sell-through at each stage. Total recovery estimate. Escalation plan.

Used by

Data AnalystsExecutives