The Estee Lauder Companies Demand Planner in Philippines

Demand Planner

Brand: Estée Lauder Companies Corporate Departments


Key Responsibilities :

  • Support Demand Planning Manager and 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 Forecast Development Process Managements:

  • Leverage SAP Advanced Planning Optimizer (APO) and utilise statistical forecasting models based on the SKUs demand profiles

  • Adjust forecast based on sales trends, especially for new launches (gross forecast and cannibilisations)

  • Develop the by SKU & aggregate forecast based on the in-market intelligence from the multifunctional teams (eg 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 Inventory Managers and brand & sales team to manage and shape demand especially during extended out of stocks situations

  • Prepare forecast data, develops 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 & Masterdata such as Characteristics Value Combinations (CVCs), Product lifecycle (PLC’s), Demand Type (DT), Strategic Indicator (SI), History Start Date (HSD) Forecast Alignment Process Managements:

  • Lead the pre(Branded) SIOP meetings focusing on demand trends insights, building blocks assumptions, and share scenarios planning based on risks & opportunity assessments at the appropriate aggregate level (eg product families, product categories)

  • 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 (eg key assumptions which assumptions went right/wrong, key demand drivers insights, cannibilisation learnings for reapplication, key building blocks assumptions

  • Lead the Demand input meetings from multifunctional teams (Brand Sales, Marketing, Finance, Inventory Planning) 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

  • Conduct forecast sufficiency & reasonability checks and share trends analysis insights and share recommendations KPI & Process Improvement Managements:

  • WFA - conduct root-cause analysis for WFA and recommend intervention plans with the appropriate teams to drive WFA improvement

  • Leverage the regional Demand Planning ACE (Academy & Centre of Excellence) networks to learn/share/reapply best practices to improve results

  • Leverage SAP & BI reporting analytics (Bias, Attainment, Waterfall etc) to correct forecast bias (ie 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



  • Basic DP Skills minimum (CLAS assessment) >5

  • Strong analytical skills required

  • Good leadership & communication skills

  • Basic conflict management skills

  • One to three years experience within the Supply Chain or Sales Planning process areas preferred

  • Basic knowledge of Sales Strategy and Brand positioning preferred

  • Consumer Packaged Goods industry experience - a plus

  • Strong personal computer skills requiredEducation:

  • Bachelor’s Degree required

Job: Inventory Management / Logistics

Primary Location: Asia Pacific-Philippines

Job Type: Standard

Schedule: Full-time

Shift: 1st (Day) Shift

Travel: Yes, 5 % of the Time

Job Number: 160943