Demand Planning Analyst
Forecast demand patterns and optimize S&OP planning with data-driven insights
What You Can Do
You can analyze historical demand patterns, create scenario-based forecasts, and identify supply-demand risks to inform your Sales & Operations Planning cycle. The skill evaluates seasonal trends, demand volatility, and SKU-level dynamics to provide actionable recommendations for inventory positioning, production planning, and cross-functional alignment.
Features
Examine historical sales data to identify seasonal patterns, growth trends, and cyclical behavior specific to your business and product categories
Model multiple demand scenarios—base case, upside, and downside—with realistic drivers to prepare your organization for various market conditions
Flag misalignment between forecasted demand and current supply capacity, including lead time risks, capacity constraints, and obsolescence threats
Quantify seasonal factors and promotional uplift to separate baseline demand from temporary spikes and plan safety stock accordingly
Classify products by demand variability, profitability, and supply chain complexity to prioritize planning effort where it matters most
Evaluate forecast accuracy, data quality, stakeholder alignment, and planning process maturity to pinpoint readiness gaps before the S&OP cycle
Generate marketing, sales, and supply chain perspectives on demand drivers and assumptions to improve forecast buy-in across functions
Example Output
Demand Forecast Summary (Q4 2026)
| SKU | Oct Forecast | Nov Forecast | Dec Forecast | Confidence | Risk |
|---|---|---|---|---|---|
| Premium Widget | 12,500 | 15,800 | 22,400 | 85% | High seasonal demand; lead time risk |
| Standard Widget | 8,200 | 8,100 | 8,900 | 92% | Stable; adequate inventory |
| Budget Widget | 3,400 | 3,200 | 2,800 | 78% | Declining; monitor for obsolescence |
Key Risks Identified
- Premium Widget supply lag: Current lead time (60 days) insufficient for December peak; recommend PO acceleration
- Seasonal volatility unexplained: Marketing planning for Q4 promotion not reflected in forecast; coordination needed
- Inventory imbalance: Budget Widget trending below forecast; recommend 15% reduction in safety stock
S&OP Recommendations
- Increase Premium Widget capacity or secure additional supplier allocation (+3,000 units)
- Align Marketing with Supply on Q4 promotion timing; lock forecast by Sept 15
- Implement weekly consensus forecasts for high-volatility SKUs (top 20% by revenue)
What's Included
- Demand Analysis Framework: Step-by-step process for collecting, cleaning, and analyzing demand history; includes worksheets for trend isolation and outlier detection
- Scenario Forecast Templates: Pre-built models for base, upside, and downside scenarios; includes driver assumptions and sensitivity analysis worksheets
- Risk Assessment Checklist: Structured checklist to identify supply-demand misalignment, lead time risks, capacity constraints, and data quality issues
- S&OP Planning Workbook: Fillable templates for demand review, consensus building, and executive summary; includes timeline, roles, and decision gates
- SKU Segmentation Guide: Methodology to classify products by demand variability and supply chain complexity; prioritization matrix for planning focus
- Stakeholder Presentation Deck: Ready-to-customize slides for presenting demand forecasts, risks, and recommendations to sales, operations, and finance teams
Who It's For
- Demand Planners & Forecasters
- S&OP Managers & Coordinators
- Supply Chain & Operations Analysts
- Business & Finance Planners
- Procurement & Inventory Managers
Best For
- Demand forecasting and S&OP cycle preparation
- Supply chain risk identification and mitigation planning
- Inventory optimization and safety stock analysis
- Scenario planning and demand sensitivity analysis
- Cross-functional alignment and stakeholder consensus building
You might also like
This skill systematically evaluates RFQ responses across multiple dimensions—price, quality, delivery, capability, and risk—to generate scoring matrices, risk assessments, and supplier rankings. You'll make data-driven sourcing decisions with transparent methodology and reduce vendor bias through weighted evaluation criteria aligned to your procurement priorities.
You can analyze shipping expenses across multiple carriers, identify cost-saving opportunities, and evaluate carrier performance metrics to reduce logistics expenses. The skill compares rates, delivery times, reliability scores, and service quality to help you negotiate better contracts and make data-driven carrier selection decisions.
Analyze supplier capabilities and proposals using structured evaluation frameworks that score vendors across cost, quality, delivery, and risk dimensions. Claude builds comprehensive negotiation strategies with quantified leverage points, walkaway prices, and contract optimization recommendations. You'll reduce material costs by 10-20% while minimizing supply chain risks through data-driven decision-making.
You provide historical sales data, supplier lead times, and market context—Claude analyzes patterns, detects seasonality, and generates demand forecasts with confidence intervals. You get actionable inventory recommendations, scenario projections, and early warnings for demand anomalies to optimize stock levels and reduce waste.
You'll create comprehensive, data-driven vendor negotiation briefs that synthesize vendor background, pricing history, market position, and negotiation leverage into a concise, actionable brief. The skill analyzes your vendor context and generates talking points, risk assessments, and strategic recommendations tailored to your negotiation objectives.
You analyze your historical sales data, demand patterns, and inventory metrics to identify optimal stock levels, reorder points, and safety stock quantities. The skill integrates with your ERP system's data to reduce excess inventory, prevent stockouts, and provide cost-benefit analysis for inventory decisions. You get actionable recommendations on ABC analysis, seasonal adjustments, and inventory turnover optimization.
This skill quickly analyzes inventory discrepancies from cycle counts, pinpoints the likely root causes, and recommends specific corrective actions to improve accuracy. You can upload count data, review detailed variance breakdowns by location or SKU, and get actionable insights to close gaps in your inventory management.
This skill guides you through structured demand forecasting and launch planning when you have limited historical data for a new product. It builds multiple demand scenarios using comparable products, market signals, and validated growth curves, then creates cross-functional alignment frameworks to stress-test your assumptions and reduce launch risk.