Seasonal Markdown Cadence and Inventory Clearance Matrix

Role: Senior Inventory and Pricing Strategist with 15 years of experience in seasonal consumer retail merchandise management.

Context

• Product category: {{product_category}}
• Remaining inventory on hand: {{initial_inventory_units}}
• Target weeks to full clearance: {{weeks_to_clearance}}
• Minimum gross margin floor: {{margin_floor_target}}
• Historical price elasticity data: {{historical_markdown_elasticity}}
• Store cluster profile: {{regional_cluster}}

Task

Construct a phased seasonal markdown and clearance velocity matrix to systematically clear residual inventory across regional store clusters within the designated timeframe while protecting profitability margins.

Method

1. Analyze current inventory depth in {{initial_inventory_units}} across the regional groups defined in {{regional_cluster}}.
2. Establish the target weekly exit velocity required to reach zero stock within {{weeks_to_clearance}}.
3. Map discount tiers against consumer responsiveness curves supplied in {{historical_markdown_elasticity}}.
4. Model weekly unit sales volume shifts across consecutive markdown discount stages (e.g., 20%, 40%, 60%).
5. Verify that each markdown phase complies with the financial boundary set by {{margin_floor_target}}.
6. Identify potential residual inventory pockets across slower-moving stores in {{regional_cluster}} to trigger regional transfers.
7. Calculate total recovered cash value and blended realized gross margin upon campaign conclusion.

Constraints

• MUST include explicit markdown milestones for every week in {{weeks_to_clearance}}.
• MUST NOT suggest discount tiers that violate the minimum threshold in {{margin_floor_target}}.
• MUST project sell-through percentage at both unit and revenue levels.
• Restrict recommendations to pricing and inventory re-balancing tactics.

Output format

Provide the response using the following schema:

1. Clearance Campaign Blueprint (1 summary paragraph, max 100 words).
2. Markdown Trajectory Matrix (markdown table with columns: Clearance Week, Recommended Discount %, Target Exit Velocity [Units], Cumulative Sell-Through %, Realized Unit Margin %, Projected Weekly Revenue, Residual Stock End-of-Week).
3. Cluster Rebalancing Directives (bulleted list, exactly 3 operational priorities).

Self-review

• Confirm that terminal residual stock equals zero at the end of {{weeks_to_clearance}}.
• Verify that cumulative margin metrics remain strictly above {{margin_floor_target}}.
• Check that the total unit sum matches {{initial_inventory_units}} exactly.