Demand Planning Specialist

Description & Requirements:

Position Overview:

• CPS (Commercial Products Supply) is a key part of the Advantaged Supply Chain of the Technical Function of The Coca-Cola Company. CPS manufactures concentrates and beverage bases for sale to bottling partners all over the world. This global organization manages a network of 19 manufacturing plants in 18 different countries along with 2 office locations (Atlanta & Drogheda, Ireland). CPS also manages complex additional materials supply chains (e.g. juice, coffee, tea, milk, etc.) on behalf of bottling partners.
• This role is responsible for managing the short, medium & long term demand plans for CPS Cairo plant – and periodically other CPS locations - working closely with Plants’ teams (in particular Planning & Logistics, CRM, Finance) and other Shared Services Functions (in particular Customer services & Portfolio management), Bottlers and Business Unit partners.
• This role is utilizing in-depth demand analytics and tools expertise to continuously improve the quality and accuracy of collaborative demand plans, while ensuring an integrated and robust demand planning process is in place, consistent with CPS demand rewiring standards.

Key Duties/Responsibilities:

• Develop strategic collaboration with BUs and key bottlers in order to proactively translate business changes into meaningful short term, medium & long term demand plans. Leverage portfolio segmentation in order to create system alignment
• Develop the sales demand plans (RE, RS, BP) for presentation and review with Cairo plant LT as part of CPS ongoing business activities such as S&OP’s, Rolling Estimate, and Business Planning. Provide detailed analysis of these plans, leveraging data segmentation, through an understanding of the demand drivers, risks and opportunities and issue recommendations to the SC SS and Plant LT’s.
• Provide in depth 6 month forecast analytics to assist CS representatives to collaborate efficiently and aid in the interrogation of the demand, with the aim of establishing a consensus forecast for the plant. Train CS team members in uploading, reviewing & fixing bottler forecasts in the system.
• Ensure system data accuracy through the validation of weekly / monthly demand plans, the creation of frozen versions on time & in full, the weekly volumes requirements transfers to planning, and APO master data maintenance. In particular, ensure key business changes (PLM, business models, SPS…) are reflected on time in the system.
• Establish, participate in and support the routines with the plant teams in Cairo in terms of managing and making recommendations for detailed demand requirements and address the materials planning needs, ensuring the business is correctly planning for immediate and long term demand.
• Develop & run demand reports to support CRM and CS in managing bottler and BU engagement activities and participate in demand discussions with partners such as ESOP, IPM calls…to establish a consensus forecast. Build through CRM & CS the appropriate level of collaboration and engagement with BU & bottlers to identify and implement the initiatives required to deliver targeted improvements in Forecast accuracy.
• Work in tight collaboration with other demand analysts within East shared services team to drive process improvement across the region and periodically manage key tasks for other East plants as required by the team back up plans. This includes updating & validating system data, running reports & representing the DP function in other East plants / Partners routine meetings.
• Drive the evolution of local process & information flows towards standard RACI, process flows, routines, reports & metrics…as per Demand planning rewiring outcomes.
• Report demand KPIs and establish root cause analysis and improvement actions in the demand field which positively impact the downstream processes and CPS global KPIs, in particular OTIF & Inventory losses.

Work Location

• CPS Site in Cairo, Egypt

Manager:

• CPS Supply Chain SS Demand Planning Manager – East