Wholesale Buy Plan Optimizer
Build data-driven wholesale buy plans balancing margin and stock risk
What You Can Do
You can transform raw sales data, trend signals, and account intelligence into executable wholesale buy plans that balance growth targets with inventory risk. This skill helps you analyze historical sell-through rates by style and account tier, forecast seasonal demand based on comparable performance, and optimize unit allocation across wholesale partners to maximize turns and margins—giving you defensible, data-backed buy decisions ready for stakeholder approval.
Features
evaluate historical performance by style, size, color, and account tier to identify winning patterns
leverage market signals and comparable style performance to predict demand cycles and avoid obsolescence
distribute units across wholesale partners based on velocity profiles and growth potential
spot trending styles early and quantify chase opportunities vs. margin discipline trade-offs
build defensible assumptions and executive summaries with quantified reasoning for approval
recommend assortment splits for new account onboarding based on historical tier-level data
analyze underperforming style factors and adjust selection logic for improved turn rates
Example Output
Example 1: Seasonal Buy Plan Analysis
Account: DSW | Season: Spring 2025 | Total Units: 4,200
- 📊 Recommended Allocation:
- Core styles (proven performers): 2,100 units (50%)
- Trend-forward styles (margin-led): 1,400 units (33%)
- Test/Chase inventory: 700 units (17%)
✓ Average turn assumption: 3.2x (vs. 2.8x last year)
✓ Margin impact: +120 bps vs. conservative plan
✓ Overstock risk: Mitigated via 40% core allocation
Example 2: Account Tier Comparison
Size Mix Recommendation for New $500K Account:
- XS/S: 32% (vs. 28% tier average) — this customer skews petite
- M: 38% (tier standard)
- L/XL: 30% (vs. 32% tier average)
- 📈 Expected sell-through: 72% vs. tier average 68% based on similar customer profile
Example 3: Chase Decision Framework
Style: Bestseller Blazer (Stock: 200 units remaining | Sell Rate: 18 units/week)
✓ Reorder opportunity: 400 units recommended
✓ Margin: 58% (vs. plan target 52%)
✓ Risk: Only 2.2 weeks of sellout window remaining
✓ Decision: Chase 300 units; reduce alternate style
What's Included
- SKILL.md instruction file: framework and prompting logic for wholesale buy plan analysis
- Buy Plan Template: structured format for inputting historical data and outputting allocation recommendations
- Seasonal Demand Worksheet: comparable style lookup and trend signal assessment tool
- Account Tier Profile Framework: size/color mix benchmarking by customer type and velocity
- Stakeholder Justification Checklist: talking points and assumption documentation for buy approvals
Who It's For
- Wholesale merchandisers managing multi-account buy strategies across seasonal cycles
- Fashion brand planners balancing growth targets with inventory risk discipline
- Wholesale account managers evaluating reorder opportunities and chase decisions
- Sourcing and procurement teams justifying buy quantities to supply chain partners
- Fashion business analysts conducting post-season analysis and next-season calibration
Best For
- Building next-season buy plans across 10+ wholesale accounts with different velocity profiles
- Analyzing underperformance and recalibrating style selection for reorders
- Determining size/color mix for new wholesale account onboarding
- Evaluating chase vs. margin discipline decisions on trending styles
- Creating defensible buy justifications with quantified assumptions for stakeholder approval
You might also like
You can analyze seasonal buying decisions across multiple departments and SKUs by integrating historical sales data, trend analysis, and vendor constraints. This skill helps you build data-backed assortment strategies that balance inventory investment with markdown risk, negotiate vendor commitments confidently, and forecast gross margin impact before committing budget. You'll reduce guesswork in category allocation decisions and create presentation-ready analyses for merchandising committees.
by ecnu-icalk
You can analyze your customer portfolio to develop risk-segmented collection strategies that maximize recovery while maintaining regulatory compliance. The skill prioritizes aging receivables based on recovery likelihood, helping you allocate resources to the highest-value opportunities. It also generates customized, compliant collection communications tailored to each customer segment.
by ecnu-icalk
You can transform wholesale buy planning from intuition-based decisions into data-driven strategy. Analyze historical sales patterns across SKUs and channels, calculate optimal order quantities balancing margin targets against demand forecasts, model scenario outcomes for different assortment mixes, and generate defensible buy plans with clear margin validation. The skill helps you justify purchasing decisions to leadership and identify underperforming styles early for markdown strategy.
by ecnu-icalk
You can assess incoming closeout and overstock lots to determine acquisition viability at target margins, analyze current inventory performance to prioritize reorders vs. liquidation, and structure negotiations that balance volume commitments against margin requirements. This skill helps you identify which SKUs justify acquisition at various price points, establish minimum acceptable margin thresholds, and build data-driven clearance strategies that accelerate sell-through while protecting profitability.
by ecnu-icalk
You can systematically evaluate historical performance, upcoming trends, and operational constraints to build balanced seasonal assortments that reduce markdown pressure and improve profitability. The skill helps you determine optimal breadth versus depth across categories, identify which SKUs deserve increased or decreased allocation, and model the financial impact of assortment decisions. This approach replaces guesswork with data-driven recommendations that typically improve sell-through rates and protect margins.
by ecnu-icalk
Analyze SKU performance across size, color, and price dimensions to segment products into expand/maintain/reduce/discontinue categories. You'll evaluate seasonal trends, margin health, and channel-specific performance to build data-driven assortment strategies that balance selection breadth with inventory efficiency. The skill helps you identify profitable size-color-price combinations and plan phased inventory adjustments that protect margins while improving sell-through.
by ecnu-icalk
You can transform merchandising data into actionable visual strategies that optimize customer flow, increase dwell time, and boost conversion rates. The skill synthesizes color theory, behavioral science, spatial design principles, and inventory constraints to create floor plans, window displays, and seasonal concepts with documented strategic rationale. You'll produce data-backed merchandising recommendations that align with your retail goals and brand positioning.
by ecnu-icalk
You can rapidly assess closeout inventory positions and translate them into actionable buying strategies. This skill helps you parse vendor offers into risk/opportunity matrices, calculate multiple markdown scenarios with breakeven analysis, and build negotiation frameworks with concrete floor and ceiling positions. You'll validate inventory claims against historical performance data and identify hidden quality or fit issues before committing capital.
by ecnu-icalk