✏️Prompts

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