Job Description for:

Executive/Sr. Executive Forecasting & Planning

1.0 Reporting line

The position will report to the AGM – Forecasting & Planning.

2.0 Position Summary:

The Demand Planner & Forecasting Person is responsible for developing, maintaining, and continuously improving demand forecasts across a large SKU portfolio (900+ SKUs) to support supply-demand alignment, inventory optimization, and operational efficiency. The role combines statistical forecasting, ERP-based analytics, and cross-functional coordination to ensure forecast accuracy, minimize inventory imbalances, and support data-driven S&OP; decision-making

3.0 JOB RESPONSIBILITIES:

Demand Forecasting & Statistical Modelling

- Develop and maintain SKU-level demand forecasts using statistical methods (exponential smoothing, Delphi method, time-series analysis) combined with Python-based analytics.
- Monitor and report forecast accuracy metrics (MAPE, forecast bias) on a recurring cadence; investigate and correct systemic forecasting errors.
- Apply ABC/XYZ segmentation to prioritize forecasting effort and inventory policy by SKU criticality and demand variability.

Supply-Demand Alignment

- Collaborate with supply planning, logistics, and production teams to balance forecasted demand against operational and manufacturing capacity.
- Flag demand-supply gaps proactively and support scenario planning for high-variability or promotional SKUs.

Inventory & Replenishment Analysis

- Conduct inventory and replenishment analysis to optimize stock availability while minimizing excess and obsolete inventory.




- Support replenishment and transportation planning across distribution centers (MLCs/MSCs) to improve inventory turnover.

Reporting & Analytics Automation

- Build and maintain automated dashboards (Power BI, Excel) for forecast accuracy, inventory movement, service levels, and other planning KPIs.
- Ensure data integrity and reporting consistency across ERP-integrated planning workflows.
- Utilize the organization's AI-driven ERP system (MISHA) for planning visibility and process efficiency.

Root Cause Analysis & Exception Management

- Perform root cause analysis on demand fluctuations, stock imbalances, and supply planning exceptions.
- Present findings and corrective action recommendations to cross-functional stakeholders.

S&OP; Participation

- Participate in monthly/periodic S&OP; cycles, presenting forecast insights, risks, and recommendations to support business decisions.
- Coordinate with zonal/regional teams to validate causal hypotheses behind demand deviations (e.g., MTD sales variance analysis).

4.0 Qualification Requirements

- Bachelor's degree in Management, Business, Supply Chain, or a related field.
- 2–5 years of experience in demand planning, forecasting, or supply chain analytics (FMCG industry preferred).
- Certification in Supply Chain Management preferred.
- Certification/coursework in Data Analytics or applied Gen AI preferred.

5.0 Core Competencies

- Forecast accuracy (target: sustained high accuracy, tracked via MAPE)
- Forecast bias reduction
- Inventory turnover and excess/obsolete stock reduction
- On-time reporting and dashboard reliability
- S&OP; contribution quality (actionable insights, timely escalation)

📌 Sr. Executive Forecasting & Planning (New Delhi)
🏢 Modicare
📍 New Delhi