Assortment Optimization Analyzer
Transform sales data into data-driven assortment recommendations instantly
What You Can Do
This skill transforms raw sales, inventory, and market data into actionable assortment insights. You'll rank SKUs by velocity, margin, and trend trajectory to identify underperformers worth pruning. Discover whitespace gaps—missing size/color/price tier combinations that competitors stock but you don't. Model the financial impact of proposed assortment changes, projecting revenue and margin shifts before implementation.
Features
scores products by velocity, margin, and trend trajectory to identify stars, cash cows, and dead weight
surfaces missing size/color/price tier combinations where competitors gain share while you have blind spots
estimates revenue and margin impact of adding, removing, or consolidating SKUs across channels
identifies unfilled demand signals and customer preference segments your assortment currently ignores
surfaces redundancies and optimization opportunities when harmonizing online, in-store, and wholesale SKU mixes
flags gaps relative to competitor assortment breadth and price tier coverage
calculates carrying cost impact of SKU rationalization to quantify working capital improvements
Example Output
Example 1: SKU Performance Analysis
- Blue Cotton T-Shirt (XS-XL): Velocity 8.2/10, Margin 42%, Trend ↑ → Keep and increase buy
- Green Wool Sweater (M-L only): Velocity 3.1/10, Margin 38%, Trend ↓ → Discontinue; missing XS, XL, XXL sizes blocking $12K annual revenue
- Fleece Jacket (Grey only): Velocity 6.7/10, Margin 51%, Trend → Gap: Navy and Black variants stock at 3 competitors; estimated $8K upside from color expansion
Example 2: Financial Impact Projection Removing 12 slow-moving SKUs (avg velocity <2.0) + adding 8 whitespace variants (Navy jacket, extended sizing):
- Annual inventory carrying cost savings: $34K
- Projected incremental revenue: $156K
- Net margin improvement: +$48K
- Shelf/warehouse space freed: 18% reduction
What's Included
- SKILL.md: full instruction set for SKU performance analysis, gap identification, and financial modeling
- Sales Data Template: structured format for uploading velocity, margin, and trend data by SKU and channel
- Assortment Gap Assessment Checklist: guide to systematically evaluate size/color/price tier coverage against competitors
- Financial Impact Model Framework: spreadsheet-ready calculations for revenue, margin, and inventory cost projections
- Assortment Recommendation Template: formatted brief for presenting findings to buyers, merchants, and leadership
Who It's For
- Merchandisers and Assortment Planners — optimizing SKU mixes and category breadth across retail channels
- Buyers and Category Managers — making data-backed decisions on new items, discontinuations, and seasonal refreshes
- Inventory Managers — reducing SKU complexity and carrying costs while maintaining revenue
- E-commerce Managers — harmonizing online and offline assortment and identifying omnichannel gaps
- Retail Operations Teams — diagnosing underperformance in store-specific assortment mixes
Best For
- Seasonal assortment planning (Q1, Q3 transitions) with sales velocity and margin analysis
- SKU rationalization projects to reduce inventory carrying costs and improve turns
- New category entry analysis—identifying whitespace and competitive assortment gaps
- Competitive assortment benchmarking against direct retailers
- Multi-channel assortment consolidation (online, in-store, wholesale) to reduce complexity
You might also like
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
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 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 systematically analyze vendor quotes by deconstructing cost structures, identifying hidden costs and margin compression points, and modeling multiple pricing scenarios. The skill enables you to forecast margin impact across volume tiers, develop proactive negotiation strategies grounded in vendor financials, and build data-backed proposals that improve both your margins and vendor sustainability—transforming reactive price-pushing into strategic partnership analysis.
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 can systematically analyze vendor performance data across multiple KPIs (sales, turn rate, on-time delivery, quality, margin contribution), identify root causes of underperformance, benchmark vendors against category standards, and develop specific improvement plans with calculated financial impact. This skill translates raw vendor metrics into compelling business cases for vendor investments, contract negotiations, or corrective actions, replacing intuition-based feedback with data-driven strategic conversations.
by cowork-os