-Data collection from different sources and run analyses on historical data to “clean” it from events impact with the input from sales and marketing team
-Following up ROI calculations to ensure events are aligned with the plans
-Forecast baseline for each SKU by channel and region and agree on the baseline assumptions
-Preparing 18-month rolling forecast at national and branch levels and enrich the forecast with special events based on inputs from sales, marketing, customer service and customers
-Cooperation with sales and marketing teams on innovation and promotion plans.
-Use experience and learning from previous events to agree on the volume impact of new events and activities
-Prepare sell-in sell-out report to provide an outlook on the market stock to enhance demand visibility
-Facilitates meetings between functions to gain consensus on one single forecast
-Tracking the forecast from one period to another to ensure consistency and to enable the process to explain the changes
-Help identify risks and opportunities as well as evaluate the forecast by close cooperation with sales and marketing
-Measure forecast accuracy and forecast bias to ensure continuous improvement.
-Cooperate with distribution planner to replenish branches if needed
Requirements
-University Degree in Industrial Engineering, Industrial Management, Statistics
-Minimum 2 years’ experience in demand planning
-Advanced knowledge and skill in Excel
-Familiarity with statistical time series models
-Familiarity with R and Forecast pro is an advantage
