Demand Forecast Optimization for FMCG Buyers
Optimize FMCG demand forecasts using historical data and seasonal analysis
What You Can Do
You can process historical transaction data, promotional calendars, and external market factors to identify demand patterns and generate actionable purchase recommendations. The skill balances inventory costs against service levels, helping you reduce costly stockouts and excess inventory waste—critical in FMCG where margins are thin and shelf life is limited. You'll gain confidence in supplier negotiations with realistic volume projections and identify slow-moving SKUs that tie up working capital.
Features
detects recurring demand patterns across holidays, events, and time periods to anticipate spikes and dips
aggregates weekly/monthly sales data to identify baseline demand and volatility patterns
generates category-specific recommendations for individual products with confidence intervals
calculates optimal safety stock levels and reorder points based on service level targets
leverages comparable SKU data and market analysis to forecast demand for products with limited history
flags underperforming inventory candidates for delisting or promotional intervention
reallocates orders across product mix when constraints force purchase trade-offs
evaluates how pricing changes and promotions impact forecasted volume
Example Output
Example 1: Seasonal Beverage Forecast
- Input: 24 months of sales data for iced tea category, promotional calendar, competitor pricing
- Output: Monthly demand forecast showing 35% spike in May-August, recommended increase Q2 purchases by 40%, safety stock adjustment to 18 days (vs. current 10), projected stockout risk reduction from 8% to 2%
Example 2: Slow-Mover Analysis
- Input: 18 months of sales for 47 SKUs in snack category
- Output: Identifies 8 SKUs with declining trends, recommends delisting 3 with <$500/year revenue, suggests promotional bundling for 5 with recovery potential, frees 12% of shelf space
Example 3: New Product Launch
- Input: Comparable product sales history, promotional support plan, target positioning
- Output: Conservative first-quarter forecast of 2,400 units, aggressive ramp to 5,100 units by Q3 if promotion succeeds, recommended initial inventory level of 1,800 units to balance risk
What's Included
- demand-forecast-optimization-fmcg.md: Complete skill instruction file with analysis framework and output specifications
- Sales data template: Standardized weekly/monthly aggregation format for inputting historical transaction data
- Seasonal analysis checklist: Structured approach for identifying and documenting recurring demand patterns
- Safety stock calculator worksheet: Framework for translating forecast confidence intervals into inventory targets
- Forecast validation guide: Process for comparing Claude's projections against actual results to refine future analyses
Who It's For
- FMCG buyers — optimizing category purchases and managing seasonal inventory swings
- Grocery merchandisers — planning promotional timing and space allocation based on demand cycles
- Supply chain planners — coordinating vendor deliveries and safety stock levels with demand realities
- Category managers — supporting business reviews with data-driven demand insights and SKU recommendations
- Retail operations managers — balancing inventory investment against service level commitments
Best For
- Seasonal purchase planning for holidays, back-to-school, and weather-driven categories
- Slow-moving SKU analysis and delisting decisions to reduce working capital tied up in inventory
- Supplier contract negotiations backed by realistic volume projections and growth forecasts
- New product launch planning when historical data is limited or unavailable
- Supply chain disruption response and demand reallocation across product mix
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