Markdown Strategy Optimizer
Optimize markdown timing, depth, and allocation to maximize clearance velocity and margin protection
What You Can Do
You can leverage Claude to analyze markdown performance across SKUs and seasons, forecast clearance velocity at different discount depths, and balance speed-to-clear against margin preservation. The skill combines your domain expertise with AI-powered pattern recognition to identify optimal markdown strategies, coordinate timing with supply chain calendars, and allocate markdown investment efficiently across your product portfolio.
Features
identifies what worked and what didn't across SKUs, categories, and seasons to inform future strategy
models how different markdown depths and durations will impact sell-through rates and inventory movement
balances aggressive markdowns needed for speed-to-clear against profitability impact and margin erosion
analyzes competitor pricing and promotion patterns to inform your own strategic positioning
identifies products at risk of becoming aging inventory before they need emergency markdowns
evaluates outcomes under different markdown depths, durations, and timing to support decision-making
aligns markdown timing with supply chain milestones, promotional windows, and inventory targets
compares markdown effectiveness across store formats and geographies to identify best practices
Example Output
Example 1: Seasonal Clearance Strategy
Input: Summer apparel inventory, historical sell-through rates, competitor markdowns
Output:
- Week 1-2: 20% markdown → estimated 45% velocity
- Week 3-4: 35% markdown → estimated 62% velocity
- Week 5-6: 50% markdown → estimated 78% velocity
- Recommendation: Start at 25% in week 1 to capture full-price demand, accelerate to 40% by week 4 to hit clearance deadline while protecting 15% margin vs. 50% emergency markdown
Example 2: Underperforming SKU Analysis
Input: Winter coat holding 8% of stock, 60-day aging trend
Output:
- Current trajectory: 90+ days to clear at regular price
- Size/color mismatch identified in M/black variant
- Recommendation: Markdown black sizes 40% immediately, maintain full price for navy and trending colors. Allocate markdown budget to black only; preserve margin on better-performing colorways
Example 3: Competitor Response Strategy
Input: Competitor launched 45% promotion on overlapping category
Output:
- Your current position: 25% markdown on comparable items
- Price elasticity analysis suggests 35-40% markdown needed to match traffic capture
- Recommendation: Selective matching on top 5 SKUs (35%), hold line on lower-velocity items, bundle slower movers with marked-down leaders to improve overall basket clearance
What's Included
- SKILL.md instruction file: complete framework for markdown strategy analysis and recommendation generation
- Historical markdown analysis template: structured format for inputting past markdown performance and extracting patterns
- Clearance velocity forecasting model: markdown depth scenarios with sell-through projections
- Margin impact calculator: quantifies profitability trade-offs at different markdown levels
- Competitor benchmarking worksheet: captures and compares competitor markdown timing, depth, and strategy
- Scenario comparison framework: side-by-side evaluation of different markdown strategies with outcomes
Who It's For
- Pricing analysts managing markdown strategy and inventory optimization across product lines
- Merchandisers planning seasonal clearance and coordinating with inventory management teams
- Retail operations managers balancing clearance velocity against margin preservation targets
- Supply chain planners coordinating markdown timing with procurement and inventory forecasts
- Category managers analyzing SKU performance and identifying products needing markdown intervention
Best For
- Planning seasonal clearance strategies for time-sensitive inventory (apparel, seasonal goods, perishables)
- Analyzing underperforming SKUs and determining optimal markdown depth and duration
- Forecasting clearance outcomes under different markdown scenarios before execution
- Comparing markdown effectiveness across regions, store formats, and distribution channels
- Competitive pricing analysis and markdown response strategy development
- Identifying products at risk of aging inventory and prioritizing markdown candidacy
- Coordinating markdown timing with promotional calendars, supply chain milestones, and inventory targets
You might also like
You can convert raw pricing data into defensible, actionable price recommendations by analyzing competitor behavior, demand elasticity, inventory health, and seasonal factors simultaneously. This skill helps you balance revenue maximization against competitive positioning and inventory velocity, enabling you to prioritize which SKUs to adjust first and justify price changes to stakeholders with quantitative rationale.
by cowork-os
You can process historical sales data and market signals to generate demand forecasts tailored to electronics SKUs, accounting for seasonality, product lifecycle stages, and supply chain lead times. The skill helps you identify optimal reorder points, calculate safety stock requirements, and flag slow-moving inventory or obsolescence risks—enabling you to make data-driven purchase order decisions that balance working capital efficiency with service level targets.
by cowork-os
You can rapidly assess current planogram performance against sales data, identify underperforming SKUs and space inefficiencies, and generate detailed shelf layout recommendations that balance profitability, velocity, and compliance. Claude processes your category mix, fixture dimensions, regulatory constraints, and competitive positioning to produce actionable planograms ready for retail operations review and store execution.
by cowork-os
Transform raw sales data into strategic insights by decomposing performance variance into specific drivers, benchmarking category health against targets, and quantifying the financial impact of merchandising decisions. You'll uncover hidden patterns in customer behavior, identify performance bottlenecks, and build executive-ready business cases backed by rigorous data analysis—moving beyond dashboards to actionable strategy.
by cowork-os
You develop strategic visual merchandising plans that integrate business objectives, customer behavior analysis, and brand guidelines into actionable retail presentations. This skill guides you through spatial psychology, color theory, product hierarchy, and sales velocity analysis to create zone-specific placement strategies, seasonal displays, and fixture specifications that drive conversion and average transaction value. You'll analyze competitor approaches, align visual hierarchy with margin targets, and build frameworks for multi-location consistency.
by cowork-os
You can upload category sales data, market metrics, and competitive intelligence, then leverage Claude to apply a diagnostic framework that identifies performance drivers, quantifies gaps against benchmarks, and prioritizes improvement opportunities by revenue impact. The skill translates raw data into executive-ready strategies with ROI projections, cutting your quarterly diagnostic phase from weeks to hours.
by cowork-os
You can strategically analyze store layouts and visual displays to identify optimization opportunities that drive unplanned purchases and improve customer navigation. This skill helps you create cohesive visual narratives aligned with brand guidelines, develop seasonal and campaign-driven display concepts, and audit existing installations against performance benchmarks to maximize conversion rates and basket size.
by cowork-os
You can systematically analyze competitor pricing strategies across product categories, quantify price-demand elasticity relationships, and identify market positioning gaps. This skill helps you build defensible pricing recommendations backed by competitive data, assess margin implications, and create scenario analyses for executive decision-making—moving beyond reactive price matching to strategic positioning.
by cowork-os