
Off-Price Inventory Margin Optimizer
Optimize off-price inventory margins with cost modeling and markdown economics analysis
What You Can Do
You can calculate precise landed costs including freight, duties, and handling fees, then model markdown scenarios across inventory depth and seasonal positioning. The skill helps you identify which clearance inventory justifies aggressive markdowns versus consolidation to salvage, and project margin impact of bulk purchases versus selective sourcing—enabling 2%+ improvements in markdown efficiency that compound to six-figure profit gains on multi-million-dollar buying budgets.
Features
accounts for acquisition price, freight, duties, off-price handling fees, and sourcing overhead to establish accurate margin baselines
stress-tests pricing strategies across inventory depth, seasonal timing, and competitor positioning to identify optimal clearance price points
determines which SKUs justify deeper markdowns for velocity versus consolidation to salvage channels based on holdback costs
projects margin impact of bulk closeout purchases versus selective style-by-style buying for volume commitment negotiations
benchmarks off-price sourcing deals against wholesale alternatives and assesses vendor reliability when terms shift
models margin outcomes across store tier distribution (flagship, secondary, outlet) to maximize blended sellthrough and recovery
evaluates make-or-break buying decisions with data-driven hold/pass recommendations based on inventory profile and margin targets
calculates markdown burden when 30-50% of seasonal inventory requires price reduction and optimizes initial buys accordingly
Example Output
Example 1: Vendor Closeout Evaluation
Input: 500 units of women's denim at $8 landed cost, competitor pricing at $24.99, seasonal window 8 weeks
Output:
- Week 1-3 markdown: $24.99 (35% margin)
- Week 4-6 markdown: $19.99 (60% velocity increase)
- Week 7-8 markdown: $14.99 (salvage consideration)
- Projected margin recovery: 42% blended
- Recommendation: ACCEPT — exceeds 35% off-price floor
Example 2: Seasonal Assortment Markdown Planning
Input: $2M fall buy across 8 departments, historical 45% markdown penetration
Output:
- Total inventory at risk: $900K
- Projected markdown dollars needed: $350K
- Department-level markdown allocation (optimized for velocity):
- Outerwear: $180K (deeper seasonal cliff)
- Dresses: $95K (trend sensitivity)
- Basics: $50K (minimal markdown)
- Accessories: $25K (low holdback cost)
- Blended margin outcome: 38% (vs. 35% baseline)
- Recommendation: PROCEED with outerwear vendor consolidation to reduce exposure
Example 3: Bulk vs. Selective Buying Decision
Input: Vendor offers 2,000 units at $6 (bulk) vs. 500 units at $8 (selective)
Output:
| Scenario | Landed Cost | Markdown Burden | Sellthrough | Blended Margin |
|---|---|---|---|---|
| Bulk | $6.00 | $340K (deeper MD) | 78% | 36% |
| Selective | $8.00 | $140K (lighter MD) | 92% | 41% |
| Decision | SELECTIVE |
Overstocking risk outweighs 25% cost savings. Lower inventory floor protects margin floor.
What's Included
- SKILL.md instruction file with off-price margin methodology and decision trees:
- Landed Cost Calculator Template: freight, duty, handling fee inputs with formula walkthrough
- Markdown Economics Worksheet: price point testing across inventory depth and competitor positioning
- Vendor Deal Evaluation Checklist: bulk vs. selective, margin floor scenarios, risk assessment
- Seasonal Assortment Markdown Budget Framework: department-level allocation model and velocity mapping
- Store Tier Allocation Matrix: margin optimization across flagship, secondary, and outlet distribution
Who It's For
- Off-Price Buyers — evaluating closeout opportunities, negotiating vendor terms, and building seasonal assortments with predictable markdown burden
- Merchandise Planners — balancing inventory depth with margin recovery targets across store tiers and seasons
- Sourcing Managers — benchmarking off-price deals against wholesale alternatives and vendor reliability assessments
- Retail Finance & Planning — modeling margin impact of bulk purchasing decisions and clearance strategy ROI
- Outlet/TJ Maxx-Format Retailers — optimizing assortment mix for 35-50% margin targets with high inventory velocity
Best For
- Vendor Closeout & Overstock Deals — evaluating make-or-break bulk purchase decisions with margin floor constraints
- Seasonal Markdown Planning — calculating dollar budgets and price point strategy for 30-50% of seasonal inventory
- Margin Recovery Optimization — modeling sell-through velocity trade-offs to maximize blended margin outcomes
- Volume Commitment Negotiations — stress-testing bulk pricing scenarios to establish floor profitability before contract lock-in
- Inventory Allocation Strategy — optimizing distribution across store tiers to balance sellthrough and margin recovery







