Yoyo Foods - Demand Planner

Description :

1. Forecast Accuracy (FA)

Formula : |(Forecast Actual) / Actual| 100

Purpose : Measures how accurately demand is predicted.

Target : 85% accuracy (depends on product category).

2. Forecast Bias

Formula : (Forecast Actual)

Purpose : Identifies consistent over-forecasting or under-forecasting trends.

Target : Close to zero (balanced forecast).

3. Inventory Turnover

Formula : Cost of Goods Sold / Average Inventory

Purpose : Measures how efficiently inventory is managed.

Target : Higher turnover indicates better inventory management.

4. Customer Service Level (CSL)

Formula : (Orders Fulfilled / Orders Received) 100

Purpose : Measures product availability against customer demand.

Target : 95%.

5. Stock-Out Rate

Formula : (Stock-Out Incidents / Total Demand) 100

Purpose : Tracks lost sales opportunities due to lack of stock.

6. Slow-Moving and Obsolete (SLOB) Inventory %

Purpose : Tracks the proportion of non-moving or expired stock.

7. Demand Plan Adherence

Purpose : Evaluates how closely execution (production / supply) follows the demand plan.

8. Forecast Value Add (FVA)

Purpose : Measures the effectiveness of forecast adjustments vs. statistical baseline.

Demand Planner Job Description (JD) :

Position Title : Assistant Demand Planning Manager / Demand Planning and S&OP Leader

Department : Supply Chain / Planning

Key Responsibilities :

• Develop and maintain the monthly demand forecast by product, customer, and region.
• Analyze historical sales trends, seasonality, and market intelligence to improve forecast accuracy.
• Conduct S&OP (Sales & Operations Planning) meetings with sales, marketing, and production teams.
• Monitor forecast accuracy and bias, and take corrective actions.
• Collaborate with the supply planning team to align production and inventory with demand.
• Manage and report KPI dashboards (forecast accuracy, service level, inventory days).
• Support new product introductions with demand assumptions and rollout planning.
• Identify risks and opportunities in the demand plan and recommend mitigation strategies.
• Conduct S&OP (Sales & Operations Planning) meetings with sales, marketing, and production teams.
• Monitor forecast accuracy and bias, and take corrective actions.
• Collaborate with the supply planning team to align production and inventory with demand.
• Manage and report KPI dashboards (forecast accuracy, service level, inventory days).
• Support new product introductions with demand assumptions and rollout planning.
• Identify risks and opportunities in the demand plan and recommend mitigation strategies.
• Ensure data integrity in the planning system (SAP, O9, APO, or Excel-based models).

Required Skills and Qualifications :

(ref : iimjobs.com)