Supply Chain Planning Associate Analyst (MRP)

  • PepsiCo
  • New Cairo City, Cairo Governorate, Egypt

وصف الوظيفة


Overview

  • Responsible for creating and releasing Material Plan for particular categories (RMPM), working hand in hand with 3PM MPS Planning Coordinator and MRP Planning Coordinator
  • Generate the Monthly Materials Plan for 24-month rolling horizon for SKUs using the production plan and Suppliers’ feedback as key inputs
  • Escalate to supplier execution planner and Procurement any material issue that may become a potential risk
  • follow the stock movements across plants based on the updated production plan per plant and contact plants to ensure delivery of materials. And follow up on raw & packaging materials availability per plant, the open orders with suppliers and deliveries receipt on SAP.
  • Coordinate with the on-ground team the movement in & out of trucks to avoid any conflicts in shipping and storage for raw materials and finish good
  • Plan & place all fixable packaging materials requirements
  • Follow up on suppliers’ reconciliation in coordination with finance team and share the new forecast with suppliers based on the GP suppliers’ allocation
  • Support the preparation of the COSO test scripts as per their aligned timeline
  • Secure needed materials for any new trials and/or new initiatives.
  • Monitor the R&PM planning KPIs (Delivery compliance), and update ending stock report and share it with finance team
  • Manage and execute Sector SPL cascaded projects for the market

Responsibilities

Materials Planning:

  • Create Monthly MRP Plan based on production needs and available inventories
  • Identify risks and opportunities and propose constrained scenarios to maximize service (liaising with MRP Planning Coordinator, Suppliers and Procurement if applies)
  • Validate production and material plans in Weekly Plan Review Meeting
  • Validate medium- and long-term material availability based on supplier feedback
  • Monitor PR conversions and release of POs to suppliers
  • Monitor Suppliers’ performance and feedback to Procurement

Working Capital Management:

  • Check materials’ availability and propose actions for excess / shortages
  • Create inventory projections for RMPM ensuring alignment to targets. Analyse gaps and propose mitigation actions

Business Waste Management:

  • Review weekly provision snapshot to be shared with Finance
  • Create business waste projections for RMPM to minimize no-consumption risks (zero-based plan).

Qualifications

  • Proficiency in product category planning
  • Problem solving know-how
  • Analytic skills
  • Proficient with MS Office - MS Excel and MS Power point in particular
  • SAP Knowledge
  • Has business acumen: Having some knowledge of the PEP/FMCG business and material planning management - This would be important as they would likely need to follow up with stakeholders & analyze their
  • Delivers Results / Embraces a challenge / Strive to achieve: Will likely be peaks and troughs in the workload. Require someone who when the going gets tough… has the resilience and adaptability to Demonstrates perseverance and ensures high standards while raising the bar.
  • Relationship: Builds effective relationships and exercises good judgment when working with others from diverse backgrounds/ cultures - again, when following up with BUs on requests.
  • Strong organizational skills: Develops and manages project, schedules, and timelines with both the immediate and broader
  • Leadership: proactively takes initiative, follows up and drives action in others to ensure deliverables are on.