Demand and Supply Planning Executive

Date:  May 16, 2024
Location:  Taguig
Company:  Shiseido
Country/Region:  PH
Custom Field 4:  Employee (Permanent)
Company:  Shiseido


The Demand and Supply Planning Executive will be responsible for end-to-end Demand and Supply Planning. This will be a key person who will work closely with other functional departments (Marketing, Sales, Warehouse, Finance, and Brand Holders) to achieve the company’s KPIs and goals.


  • Leads and drives the monthly Forecast Pre-alignment and Forecast Meeting with cross-functional Sales and Marketing team
  • Represents SPH and participates in the Regional Demand Review Meeting
  • Conducts historical sales analysis and data cleansing to build statistical baseline forecast by SKU, by channel, and by door level
  • Builds the total demand plan by generating baseline forecast derived by correlating various metrics such as forecast accuracy, inventory, service level, sell-out, etc and by capturing marketing intelligence (MI)
  • Calculates and uploads 18 months rolling External Demand Plan in IBP
  • Validates the demand plan vs financial budget/latest estimates and highlights potential risks and opportunities in the demand plan vs financial budget/estimates
  • Calculates the monthly orders based on demand plan, stockholding, lead time, and pre-determined parameters based on KPI, and secures approval accordingly based on the company’s authorization guidelines
  • Calculates and submits 15 months rolling Unconstrainted Purchase Plan (UPP) to HQ
  • Drives and coordinates depletion plan with Sales and Marketing team to achieve inventory KPIs
  • Works with Order Management and Replenishment Planner to strategize stock allocation between consignment stores and outright accounts in lieu of supply constraint
  • Works with Order Management and Replenishment Planner on inventory reservation and allocation for Outright customers
  • Performs various demand and supply planning simulation and analysis
  • Works with Procurement and Master data on various mater data related concerns such as local article creation, material extension, SRP maintenance, and the like


  • Bachelor’s degree in business, supply chain or related fields
  • A minimum of 3-5 years of experience in a demand planning and supply planning in a FMCG set up
  • Solid understanding of inventory management practices and procedure
  • Strong mathematical and analytical skills
  • Capability to adapt to a demanding environment
  • Strong business acumen
  • Excellent written, verbal communication, and presentation skills
  • Proficient in MS Excel, MS Powerpoint, SAP, and forecasting application

Job Segment: Supply Planner, Supply Chain, Supply, Demand Planner, Procurement, Operations