Codified expertise for demand forecasting, safety stock optimization, replenishment planning, and promotional lift estimation at multi-location retailers. Informed by demand planners with 15+ years experience managing hundreds of SKUs. Includes forecasting method selection, ABC/XYZ analysis, seasonal transition management, and vendor negotiation frameworks. Use when forecasting demand, setting safety stock, planning replenishment, managing promotions, or optimizing inventory levels.
The inventory-demand-planning skill provides structured expertise for forecasting product demand, optimizing safety stock, planning replenishment, and evaluating promotional impacts across multi-location retail environments. It addresses the common challenges faced by demand planners, including balancing stockouts against excess inventory, managing seasonal and promotional demand shifts, and integrating complex supply chain signals from POS data, vendor portals, and ERP systems. By codifying 15+ years of professional demand planning experience, this skill enables planners to translate commercial objectives into executable purchase orders effectively and efficiently.
Core capabilities include selecting appropriate forecasting methods per SKU based on demand patterns and ABC/XYZ classifications, calculating safety stock that accounts for demand and lead time variability, adjusting forecasts for promotions and external factors, and generating purchase order recommendations that respect MOQ and EOQ constraints. It also supports monitoring forecast accuracy through metrics like MAPE and bias, enabling iterative refinement of models. Additional frameworks guide planners through vendor negotiation, seasonal transition management, and new SKU launches, ensuring a comprehensive approach to inventory optimization.
This skill is primarily targeted at senior demand planners and supply chain professionals operating in retail settings with multiple stores and regional distribution centers. Typical use cases include planning for seasonal promotions, new product launches, adjusting replenishment under changing lead times, and reviewing or generating demand forecasts for existing SKUs. Users benefit from structured guidance in balancing inventory investment with service level objectives, improving operational efficiency and decision-making across merchandising, supply chain, and finance functions.
It supports forecasting for stable, seasonal, promotional, and new SKUs, using methods selected based on demand patterns and ABC/XYZ classification. It includes moving averages and exponential smoothing for different scenarios.
The skill is designed to integrate with demand planning suites like Blue Yonder, Oracle Demantra, or Kinaxis, ERP systems such as SAP or Oracle, WMS for DC-level inventory, POS data feeds, and vendor portals for purchase order management.
Yes, it accounts for promotional lifts, cannibalization offsets, and seasonal demand changes, and provides frameworks for planning replenishment and post-promotion inventory adjustments.
The skill is illustrated for retailers managing 300–800 SKUs across 40–200 stores with regional distribution centers, though the principles can be adapted to other scales with similar planning complexities.
Forecast accuracy is monitored using metrics such as Mean Absolute Percentage Error (MAPE) and forecast bias, allowing planners to adjust models in subsequent planning cycles.
Quick Setup:
.claude/skills/Repository
affaan-m/everything-claude-code