Demand & Supply Planner at Abbott

DEMAND AND SUPPLY PLANNER

• This position works out of our Johannesburg location in the Nutrition Division of Abbott

ABOUT NUTRITION DIVISION

• Our nutrition business develops science-based nutrition products for people of all ages, from helping babies and children grow, to keeping adult bodies strong and active. Millions of people around the world count on our leading brands – including Similac®, PediaSure®, Pedialyte®, Ensure®, Glucerna® and ZonePerfect® – to help get the nutrients they need to live their healthiest life.
• As Demand and Supply Planner, you will be responsible for maintaining an accurate Data integrity, Analysis for Supply Chain & Finance function. Ensuring management of demand forecast supporting the Supply Organization to deliver on its objectives in both Customer Service and Inventory Management for the company to deliver sales
• You will maintain SKU forecasts that will be used for planning production and the purchase of finished goods from third parties, as well as providing a forward view of sales revenue to the Business through the S&OP process.
• The role also interfaces with Finance with regards to Supply & Finance Business Analytics & expenditure tracking.

WHAT YOU'LL DO

Demand & Supply Chain

• Monthly Business Data Analysis & Consolidation including monthly sales actualization
• Generates new forecasts by reviewing historical trends, promotion calendar, and activities available from commercial team
• To Facilitate meetings with commercial team within the S&OP process to produce unbiased forecast, gap identification or closure with sound facts and communicate supply constraints or business risks.
• To challenge forecasts when necessary, based on trend analysis, MAD & BIAS data, promotional and media phasing etc.
• Ensures agreed forecasts are communicated to source points via SNP and Supply Planners for stock planning
• Customer forecasting in APO & Sample forecast alignment & tracking
• Updates, produces, and publishes reports including the monthly forecast accuracy report, S&OP Gap initial and final reports. Provide SKU volumes to Supply Chain manager for Business Forecasts and Plan
• Ensure good or bad news are communicated early using the S&OP process to allow business alignment with relevant action points to be established to address the issues
• Joint forecasting with Top FMCG retailers
• Weekly feedback to Factory’s by Back-order report due Every Friday
• New product innovation bottom-up forecast by SKU & trend analysis post launch
• Area reporting consolidation with root cause commentary

Operations:

• Weekly Channel days on hand reporting & Management
• Business Supply Chain Master data management
• Plans replenishment of product to maintain supply service levels; manage the local S&OP process for defined brands and categories
• Co-packer Monthly forecasting alignment

Financial:

• Actualization & Management of 5 factor file monthly.
• Prepare GTN (Gross to Net) report monthly for sales deductions per customer, obtained from sales source data files.
• Support the RLBE quarterly forecasting process with populating templates from source information as required. Be able to interpret and understand the information to become a valuable business partner.
• Power Bi Data load & Validation on TMS, Channel inventory & forecast loads.
• Reconciliation of Financial, S&OP & Sales latest view for weekly business tracking for month end closure & Full year projection
• Average selling price variance analysis root cause analysis 

REQUIRED QUALIFICATIONS

• Computer Literate in Excel, Power Point, Word, Outlook
• Administrative Ability, Communication Skills, Attention to Detail
• Deadline orientation
• Proactive
• Able to work independently and part of a team
• Solution driven

PREFERRED QUALIFICATIONS

• 5 years industry experience with Supply / Demand planning for FMCG customers
• University degree related to the field of Supply Chain with Financial experience is optimum.
• Knowledge in SAP APO SNP, BPCS, MS Office (especially in MS Excel).
• Strong Excel skills
• Highly analytical and fact-based decision making.
• Customer centric and with strong customer service mindset.
• Has experience in various supply chain functions such as Demand/Supply Planning, inventory management, logistics, S&OP etc.
• Highly analytical and fact-based decision making.
• Able to work independently, think logically, challenge status quo, and consistently seek to improve current way of working to seek of productivity.
• Team working ability and ability to lead a team in a cross functional organization.
• High levels of motivation to get the job done. Act as a change catalyst
• Good understanding of the FMCG nature and business.
• Good command of English.