Job Purpose:
The role of a Demand Planner is to support the overall business, financial & supply chain management process by rigorous management of the demand signals for the various product types and customer channels. The Demand Planner works & supports in the creation and management of the operational demand plan - the SKU-Channel forecast in the SAP Advanced Planning Optimizer (APO) System. They will also play a role in the Sales Inventory and Operations Planning (SIOP) process by working with the multi-functional teams (namely Inventory Management, Sales, Marketing and Finance) to assure tight alignment in the forecast (which will drive the supply, inventory & production plans) and financial plans.
Key Responsibilities:
- Support Demand Planning & Brands to develop the consensus forecast for the brands based on statistical forecast and sales & marketing activities such as promotions (GWP, local sets) and new product launches.
- Become a valued business partner for the Brands Management team.
1.Forecast Development Process Managements:
- Leverage SAP Advanced Planning Optimizer (APO) and utilize statistical forecasting models based on the SKUs demand profiles. Adjust forecast based on sales trends, especially for new launches (gross forecast and cannibalizations).
- Develop the by SKU & aggregate forecast based on the in-market intelligence from the multi-functional teams (e.g. incorporating latest promotion plans, in-market performance of the new launches, competitive activities, macro market trends, customers’ plans, trade inventory etc.). Develop the final demand forecasts (operational forecasts) at multiple levels of aggregation for the full time horizon by channels and by key accounts (if applicable).
- Collaborate with (Affiliate) IM team and brand & sales team to manage and shape demand especially during extended out of stocks situations.
- Prepare forecast data, develop an understanding of the used statistical forecast models (Note: only basic understanding of the statistical model is expected.Leverage the regional & global COE for questions/clarifications). Maintain the Demand Planning Attributes & Master data such as Characteristics Value Combinations (CVCs), Product lifecycle (PLC’s), Demand Type (DT), Strategic Indicator (SI), History Start Date (HSD)
2.Forecast Alignment Process Managements:
- Lead the Demand Review section as part of the monthly SIOP meetings, focus the team on key trends insights and focus the team’s energy on strategic areas which makes the biggest impact to the business (e.g. key assumptions which assumptions went right/wrong, key demand drivers insights, cannibalization learnings for reapplication, key building blocks assumptions.
- Lead the pre(Branded) SIOP meetings focusing on demand trends insights, building blocks assumptions, and share scenarios planning based on risks & opportunity (R&O) assessments at the appropriate aggregate level (e.g. product families, product categories).
- Lead the Demand input meetings from multifunctional teams (Retail Sales Operation, Marketing, Finance, Inventory Management) by aggregating inputs which would have significant impacts on the sales plan to ensure that the most current and accurate market intelligence is incorporated into the demand plan.
- Lead the brands forecast vs LE reconciliation process and ensure the variance is within acceptable tolerance and the major differences are captured as part of the risks & opportunities (R&O).
- Conduct forecast sufficiency & reasonability checks and share trends analysis insights and share recommendations.
3. KPI & Process Improvement Managements:
- WFA - conduct root-cause analysis for WFA and recommend intervention plans with the appropriate teams to drive WFA improvement.
- Leverage SAP & BI reporting analytics (Bias, Attainment, Waterfall etc.) to correct forecast bias (i.e. minimize out of stocks / excess inventory) and improve consistency of attainment.
- Conduct New Product pre & post launch analysis with brands and regional demand planning team and recommend actions for future launches based on historical insights (pipeline, sell-in velocity, cannibalization, execution excellence)
- Conduct historical sales trend analysis to establish key demand drivers for the SKUs/brands/market (leverage brand & consumer insights, category mix, sell-in & sell-through trends, external category/market trends) and collaborate with sales & marketing to adjust the forecast to ensure we deliver an unbiased forecast for the entire planning horizon.
4. Change Management
- Ability to quickly ramp up and grasp detailed functional content when engaged with other cross-functional team members
- Positively drive changes and ensure goals and processes are moving forward towards excellence
- Pro-actively participate in ad-hoc projects & streamline processes as identified during course of work
5. Other tasks: as assigned by Supply Chain Manager
Key Results/Measures:
- Key KPI is WFA, Attainment & Bias should be at > target to deliver breakthrough Business Service, Inventory & Cost
Other in-process measures:
- No significant under/over shipment bias (indicative of systemic process bias)
- No significant out of stocks due to forecasting
- No significant excess inventory due to forecasting
- No significant airfreight due to forecasting