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