Skip to main content

No jobs have been saved yet.

No jobs have been saved yet.

Growing together, winning together

Mgr, Demand Planning Analysis

Rotterdam, Netherlands Supply Chain Posted on: 02/11/2022 82939
Apply for role

From a secret recipe to a bold idea and very proud traditions, we build the future.

Coca-Cola European Partners (CCEP) is a major fast-moving consumer goods business in Europe and the world’s largest independent Coca-Cola bottler.

Across 13 countries, our employees make, sell and distribute the world’s most loved drinks brands to more than 300 million people.

Some of the brands you will find in our portfolio are Coca-Cola®, Fanta®, Aquarius®, Spriter®, Monster® And Capri-Sun®.
 
Leading brands, great people and a focus on (personal) growth that comes with it.
 
At CCEP, we want to provide a workplace where people are inspired to be the best they can be.  We know that engaged, motivated employees, working to their full capacity and able to reach their personal career goals, are a critical part of our Company’s long-term success.

Are you looking for a new opportunity where facts & figures and collaboration with different stakeholders are key? 
Then the role of Manager Demand Planning Analysis within the Planning and Commercialization team could be your next challenge? 

As Manager Demand Planning Analysis you will be responsible for delivering, together with your demand planning colleagues, on a weekly basis the best sales forecast (i.e. expected customer deliveries) on short term (0-3 months) and mid term (3-6 months) on time within the specifications at lowest operational cost whilst meeting agreed internal and external customer service levels.


The demand plan will be used for production planning by Supply Chain and for financial forecasting by Commercial Finance and needs to include business change initiatives e.g. baseline forecast, promotions, product innovation or pack changes across The Netherlands CCEP portfolio. 

Your main responsibility is to maintain, further develop and optimize a set of complex analysis tools, consolidating and transforming internal and external sales data from multiple sources using Excel, Access, Power BI, which will provide insights on trends, deviations versus plan and performance on SKU level by period, key accounts and channel.

You will drive continuous improvements initiatives with purpose to improve the forecast accuracy, forecast bias and customer service levels. 

You are responsible to manage the statistical forecast process where Cap Gemini consultants establish a process of generating reliable reproducible statistical baseline forecast which is refreshed every month and is made available in CCEP planning system for further planning operations.

Together with Cap Gemini you seek for delivering continuous improvement projects to increase forecast accuracy. You will play a supporting role on roll out of the new CDSP project planned in 2023.

You will also play a leading role in the monthly Outlook process for financial forecasting by Commercial Finance, the monthly 18 months long term sales forecast (MTM) to the central supply planning team and develop the yearly ABP volume budget models for the upcoming years.

This means fully taking ownership of complete volume budget process (from June to December).

This implies delivering a full volume budget by the end of the year on sku level, customer level and period level.

Close collaboration and alignment with various senior stakeholders will be a must.

These are The Coca-Cola Company (sampling volumes), CCEP Commercial Development, CCEP Account Management, CCEP Strategy & Insights and CCEP Finance and Supply Chain functions to deliver the demand plan within the specified time, cost and quality parameters. 

Furthermore, you support the monthly S&OP cycle, support preparing the weekly S&OP meeting (NL leadership team) and the monthly demand reviews with channel directors.

You will lead the weekly S&OP meeting in absence of the Senior manager Demand Planning.

You will be part of a strong performing team and you will be reporting directly to the Senior Manager Demand Planning.

So are you ready to

  • Support your demand planning colleagues with pro-active analysis on seasonality, trends and deviations on different levels (SKU, brand/pack/channel/key account) to be reflected in future forecast, using various analysis tools;
  • Review baseline forecast by SKU and by Key Account on short and long term horizon, data to be used as input to Promax;
  • Analyze, challenge, review  and collaborate with the account managers on expected uplift of national promotions by SKU and by Key Account and impact on other brands/packaging;
  • Analyze, explain and follow-up deviations between sales forecast and actual deliveries in order to correct future expectations;
  • Review historical data together with Cap Gemini consultants in order to create a Cleansed Demand History, SKU and Key Account Disaggregation and Statistical baseline forecast;
  • Work collaboratively with the different stakeholders (Cap Gemini consultants, KAMs, CDM, S&I, Supply Planning) to gather all relevant information (promotions, new initiatives, market intelligence, external inputs) by organizing regular follow-up meetings and further expand the S&OP process;
  • Make up, formalize, discuss & submit yearly ABP volume budget to Finance & Supply Chain;
  • Prepare & discuss weekly S&OP presentations.


Are you the candidate we are looking for? 

  • Bachelor or Master or equivalent with experience;
  • Bi-lingual Dutch and English;
  • Proven strong analytical skills and eye for details;
  • Born communicator;
  • Expert knowledge on Excel (incl. VBA), Access (incl. SQL) and Power-BI;
  • Proficient on data analysis, statistical, predictive modelling and machine learning;
  • Result driven and team player;
  • Sense of responsibility and ownership;
  • Commercial mindset;
  • You have experience in FMCG environment, you have knowledge of SAP APO or other planning tools.

Is this role made for you? Upload your most recent CV and a short motivation letter.

Marc Nuijten of the TA department will contact you! If you have any questions, you can always send him a message via mnuijten@ccep.com.

Be the first to know

Sign up to be the first to receive job updates.

Interested inSelect a job category from the list of options. Select a location from the list of options. Finally, click “Add” to create your job alert.

  • Supply Chain, Rotterdam, South Holland, NetherlandsRemove