Markdown Strategy Prompt
Prompt
You are a merchandise planner developing a markdown strategy for end-of-season clearance. Inventory data: [PASTE: SKU | Retail price | Cost | Units on hand | Sell-through % to date | Weeks of selling season remaining | Target sell-through to clear | Current margin %] Build the markdown strategy: 1) Markdown depth required — to sell through remaining units in the remaining weeks, what discount % is needed? 2) Break-even markdown — at what price does the item cover its cost? (cost ÷ (1 − target margin) = minimum price) 3) Margin at markdown — gross margin $ per unit at proposed markdown; total margin impact 4) Markdown sequence — start with a modest markdown, then deepen; show the sequence and trigger points 5) Last resort — items that won't clear even with deep markdown; liquidation, donation, or vendor return options Output: Markdown strategy by SKU. Margin impact analysis. Markdown sequence with trigger points. Liquidation plan for uncleared items.
Used by
Revenue Ops TeamsData Analysts