Demand Forecasting & Assortment Optimization for FMCG Buyers
Forecast FMCG demand and optimize product assortment using sales data & seasonal patterns
What You Can Do
This skill processes complex FMCG sales datasets to identify demand patterns, seasonal volatility, and promotional impact on your category. You can forecast future demand with confidence, optimize your SKU mix to eliminate dead inventory and stockouts, and align assortment resets with historical seasonal cycles—enabling data-driven buying decisions that balance shelf constraints, supplier minimums, and margin targets.
Features
Analyzes historical sales velocity and seasonal patterns to project future demand by SKU and time period
Identifies weekly, monthly, and annual demand cycles to inform assortment timing and promotional calendars
Ranks products by velocity, margin contribution, and shelf efficiency to surface discontinuation and expansion candidates
Quantifies lift and baseline demand shifts driven by past promotions to refine future promotional strategy
Compares current product mix against demand forecasts to identify overstocked and understocked SKUs
Recommends product count and mix adjustments to maximize sales per linear foot and inventory turns
Benchmarks category performance across store banners, regions, or formats to identify localization opportunities
Generates first-order and reorder quantity recommendations aligned with supplier minimums and lead times
Example Output
Example 1: Seasonal Demand Forecast
Category: Carbonated Soft Drinks | Period: Q2-Q3 2025
Forecast Summary:
• May demand: 12,400 cases (baseline seasonal increase)
• June demand: 14,800 cases (summer peak begins)
• July demand: 16,200 cases (peak consumption period)
• August demand: 15,100 cases (school prep demand declines)
SKU-Level Recommendations:
✓ Increase 20oz single-serve allocation by 35% (higher velocity in warm months)
✓ Reduce 2L family pack SKUs by 15% (lower turns in summer vs. winter)
✓ Introduce seasonal flavor variant (historical 8% category lift in June-July)
Example 2: SKU Rationalization Recommendation
Analysis: Current Assortment vs. Optimal Mix
Discontinuation Candidates (dead inventory risk):
• Artisanal Vanilla Pudding (4oz) — 0.3 cases/week, 18% shelf space
• Regional Yogurt Brand — 1.2 cases/week, 22% space, 8% margin
Expansion Opportunities:
• Probiotic Drinkable Yogurt — 6.8 cases/week, growing +12% YoY
• Private Label Greek Yogurt — 8.2 cases/week, 18% margin vs. 12% national brand
Projected Impact: 8 linear feet freed up, +$3,200/month category margin
What's Included
- SKILL.md: Full instruction set and framework for demand analysis and assortment optimization
- Sales Data Template: Structured format for historical transaction data (SKU-level sales, dates, promotional flags)
- Seasonal Pattern Worksheet: Guide to identify and document annual and weekly demand cycles by category
- SKU Performance Scorecard: Framework to rank products by velocity, margin, turns, and shelf efficiency
- Promotional Calendar Tracker: Template to map past and planned promotions against demand forecasts for impact analysis
Who It's For
- FMCG/Grocery Category Managers — Optimize assortment mixes and plan seasonal resets using data-driven insights
- Retail Buyers — Forecast demand and rationalize SKU portfolios to reduce waste and maximize shelf productivity
- Merchandising Teams — Align promotional calendars and pricing strategies with historical demand patterns and seasonal cycles
- Supply Chain & Inventory Planners — Generate replenishment forecasts and optimize stock levels across store formats
- New Category Entrants — Develop initial assortment strategies and demand baselines for recently added product lines
Best For
- Seasonal Assortment Resets — Plan Q4 holiday, summer beverage, or back-to-school assortments using historical demand forecasts
- SKU Rationalization & Discontinuation — Identify underperforming products and dead inventory candidates to reduce shelf clutter
- Promotional Calendar Planning — Align promotions with peak demand periods and quantify expected lift impact
- Multi-Format Assortment Strategy — Customize product mix and quantities across store banners or geographic regions
- Supplier Consolidation & New Product Launch — Forecast demand for new SKUs and calculate space reallocation from lower-velocity items
You might also like
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 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 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
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.
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 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