
Planogram Optimization Analyzer
Optimize planogram layouts for maximum sales velocity and margin capture
What You Can Do
You can input historical sales data, product margins, shelf dimensions, and brand requirements into Claude to receive detailed planogram optimization analysis. The skill identifies underperforming SKU placements, recommends optimal facing allocations for fast-moving versus slow-moving items, calculates margin impact of proposed layouts, and validates compliance with brand partnership agreements—enabling you to make confident planogram reset decisions.
Features
identifies high-velocity and slow-moving SKUs to determine optimal facing allocation and shelf position
calculates gross margin impact of proposed layouts and recommends SKU sequencing to maximize margin capture
evaluates linear feet utilization and recommends adjustments to reduce dead space and improve category flow
ensures proposed layouts respect brand contractual agreements, promotional requirements, and category partnerships
models planogram changes needed to counter competitive threats or respond to market shifts
structures recommendations for regular planogram resets (4-6 annually) with phased implementation guidance
determines optimal shelf position, facing count, and displacement strategy for new SKU introductions
synthesizes sales history, margin profiles, and shelf constraints into prioritized, actionable optimization suggestions
Example Output
Example 1: Facing Reallocation Analysis
Input: 12-month sales data, current facing counts, shelf dimensions
Output:
Current Layout: SKU A (3 facings, $2.4M sales) | SKU B (5 facings, $1.8M sales)
Optimized Layout: SKU A (5 facings, projected $3.1M) | SKU B (3 facings, projected $1.6M)
Projected Impact: +$1.3M annual revenue, +8% category growth, improved velocity
Example 2: Margin Capture Recommendation
Input: Product mix with varied price points ($8–$25 range), current shelf sequence
Output:
Current Margin: 34.2% | Proposed Margin: 37.8%
Key Changes: Elevate premium SKUs (eye level), reduce facings of sub-$12 products (bottom shelf)
Annual Margin Gain: +$180K (on $5M category sales)
Example 3: New Product Launch Placement
Input: New product attributes, category benchmarks, available linear feet
Output: Recommended shelf position (eye level), initial facing count (2), displacement strategy (reduce 1 facing from declining SKU), projected first-year sales impact.
What's Included
- SKILL.md: Complete skill documentation with usage guidelines and constraints
- Planogram Analysis Template: Structured format for inputting sales data, margins, and shelf dimensions
- SKU Performance Scorecard: Metric framework to rank products by velocity, margin contribution, and shelf efficiency
- Optimization Recommendation Checklist: Validation criteria (brand compliance, space utilization, velocity targets)
- Seasonal Reset Planning Framework: Timeline and process for quarterly/semi-annual planogram resets
Who It's For
- Category Managers — responsible for optimizing category performance and planogram resets
- Merchandising Analysts — analyzing shelf layouts and recommending space allocation improvements
- Retail Operations Leaders — evaluating planogram changes for multi-store rollout and compliance
- Brand Managers — validating proposed layouts against partnership agreements and promotional requirements
- Planogram Specialists — structuring data and recommendations for retailer/team approval and execution
Best For
- Analyzing underperforming shelf layouts and identifying facing reallocation opportunities
- Planning seasonal or promotional planogram resets with data-driven recommendations
- Evaluating margin impact of proposed layout changes across product tiers
- Launching new products with optimized shelf position and facing allocation
- Validating compliance of proposed layouts with brand and contractual requirements







