MRP Planning Associate Analyst
Summary
Plans and executes weekly material requirements (MRP) for PepsiCo’s Egypt supply chain, aligning production with inventory and supplier data to prevent shortages and excess.
Overview This role is responsible for leading the weekly Make planning cycle, creating and releasing the Material Plan for particular categories. MRP plan will also need to be issued to the Bern Make planning organization on a agreed frequency. Working with the Bern team, the individual will escalate any Make supply issue and support resolution, monitoring and managing supply exceptions Also accountable for completing the Monthly Materials Plan for 24-month rolling horizon for SKUs using the production plan and Suppliers’ feedback as key inputs to ensure supply. Utilizes escalation path to MRP Planning Lead & Procurement for any material issue that may become a potential risk. Responsibilities Materials Planning: Create Monthly MRP Plan based on production needs and available inventories Ensures MRP plan is shared (Country Front End) with Bern Make planning organization for relevant SKU’s 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. Analyze 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 Experience – 1 – 3 years in associated function Qualifications: University degree preferably engineering or logistics Experience in Material Planning or familiar Supply Planning tasks Proficiency in product category planning - FMCG background preferred Abilities: Problem solving know-how Strong Analytic skills Very good collaboration skills and ability to interact with multi-cultural teams spread across geographies Experience in using planning systems, BY- JDA preferred Experience in ERP (SAP) usage is a must Demonstrated proficiency in Microsoft Office: Outlook, Excel