Job Descriptions

About the Role

The Demand Planner is responsible for all SAP APO statistical forecasting and data integrity activities. The planner will create baseline forecast models to support the monthly S&OP process. The demand planner will own and drive statistical forecast accuracy performance to achieve targets. They will collaborate with commercial teams  on history adjustments to drive robust statistical forecasts.   The demand planner is responsible for data integrity, ensuring that the weekly forecast sent to Supply is applied to the correct sku/location. Additionally Demand Planner maintain optimal stock covers in collaboration with production sites and is with regular contact with beer supply planning team and spirit market planning team.

In this role you will be responsible for:

Generate base line statistical demand forecast for at least 18 months rolling:

• Pro-actively works with IBP owning the statistical forecast and highlighting deviations to the shipment and/or depletion trends.
• Use and maintain the APO software as the primary forecasting system tool
  • Collaborate with IBP on all forecast history cleaning activities including documenting adjustments and assumptions (market trends, seasonality, promotions).
  • Maintain statistical parameters for “best fit” model & generate a baseline at least 18 month rolling.
• Maintain APO master data including CVC creation, disaggregation factors and attributes.
• Analyze outliers through appropriate reports and make corrections.
• Support scenario planning for promotions, innovation and major events (duty, economics change, etc.) through stat analysis.
• Provide reports and insights to stakeholders to maximize the use of baseline forecast.

Provide key input to S&OP/IBP process

• Participate where relevant in S&OP process to align upon consensus forecast.
• Review statistical input to Strategic Planning and AOP process and challenge projected growth based on historical trends.
• Collaborate with IBP to conduct root cause analysis to identify drivers of forecast error and work together to take the necessary corrective action to drive continuous improvement in forecast accuracy and bias performance.

Continuously improve statistical forecasting method:

• Test and implement new models
• Implement best practices
• Support system developments

Support high level of CFR by providing healthy stock across portfolio

• Close cooperation with Beer supply planning team for small pack availability
• Support for market planning team for optimal spirit availability

To be successful in this role, you will need:

• Baseline understanding of the end-to-end Supply Chain Planning processes; Supply Planning, Distribution Requirements Planning, Inventory Planning, Conversion, Logistics, Procurement and Customer Service
• Demonstrated proficiency in statistics and/or forecasting methodologies with an understanding of their financial and operational impacts
• Strong analytical, organizational and decision making skills
• Good communication skills – verbal, written and presentation.
• Proficient in MS applications e.g. Excel, SAP BW, Power BI,
• Experience working within the Demand and/or Supply Chain Planning process; Consumer Packaged Goods Industry preferred
• Experience with advanced planning software with Supply Planning (SAP APO system and Business Intelligence/BW)
• Bachelor’s degree or equivalent in appropriate supply chain, mathematical, engineering, or business degree.

Skills

• Analytical Skills
• Organisational Skills
• Proficient in MS Office
• Good communication skills

Experience

• 1 year