Job Summary
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
The Cairo Inventory Specialist is a key member of the Plant Planning & Logistics team of Cairo and will be responsible for Inventory Management to ensure adequate monitoring of inventory KPI's such as WOS, AOS, MRB and products freshness, as well as maintaining the SAP & WH technologies power user activities such as SAP WM, ITS Mobile and GLS.
This role oversees inventory analysis ensuring proper inventory levels and managing inventory at risk while also ensuring the plant has an updated planning parameters which reflect the desired inventory policy for each SKU or products/ingredients group. The Inventory Specialist will collaborate with a cross functional teams within the plant.
This role will also be responsible for monitoring the products freshness to ensure that products are available for customer orders with adequate shelf life.
Key Duties/Responsibilities
Collaborate with Master Schedulers to develop a written inventory policy for all F.G SKU's whether at SKU level or Product Group level, ensure that this policy is reviewed and updated frequently, and any change is reflected in SAP planning parameters with clear business rational.
- Monitoring the Finished Goods WOS every week, and identify the top 10 SKU's per MRP controller with high WOS value to be analyzed by Master Schedulers vs. inventory policy and ensure there is a clear narrative and corrective actions in place.
- Monitoring the Ingredients WOS every week, and identify the top 10 SKU's per MRP controller with high WOS value to be analyzed by Vendor Schedulers vs. inventory policy and ensure there is a clear narrative and corrective actions in place.
- Reporting the plant WOS results for both Ingredients and F.G on monthly basis with trend charts, and supported by narrative for off-track records and clear corrective actions with assigned owner/s for each action.
- Monitoring the Age of Stock (AOS) report for ingredients and F.G every week and identify the missing information in SAP to be shared with the owners (CRM for F.G, MS for BCH and VS for Ingredients and packaging materials).
- Follow up with all stakeholders to submit the missing information of AOS before the next report run.
- Maintaining the governance of AOS routines through measuring and analyzing the conformance to standard (% of missing information in AOS report, % of actions completion on time, Cost avoidance in USD).
- Responsible for leading the Age of Stock meetings on weekly basis and share the summary of High/Medium risks with the stake holders (Finance, CRM, Planning and VS) and agree on the required actions to mitigate those risks.
- Responsible for maintaining the MRB routine to measure plants inventory losses driven by CPS activities, and follow up with relevant functions on the execution of MRB actions. As well as measure the plant inventory losses driven by a decision made by a BU or Bottler, and follow up with CRM and Finance on provisions submission and approvals are obtained from the relevant BU's.
- Proactively identify and evaluate all finished products at risk (less 50% of remaining shelf life) to avoid obsolescence and to effectively manage inventory, to minimize negative financial impact across the total supply chain.
- Responsible for preparing and sharing the list of materials ready for destruction every month with the key stakeholders (QSE, Finance & WH) and follow up on the destruction report issuance and approvals.
- Responsible for write off of nonconforming items after ensuring all process steps and supporting documents were completed
- SAP Power User for Ware House activities through maintaining the following responsibilities:
Act as the main contact for SAP operations issues resolution as well as the subject matter expert for SAP WM transactions. Contact global support team to escalate and resolve issues as needed
- ITS Mobile Power User through maintaining the following responsibilities:
Act as the main contact for ITS operations issues resolution. Contact global support team to escalate and resolve issues as needed Responsible for the prioritization and roll out of ITS Mobile enhancements in collaboration with the global development team. This includes collecting users feedbacks and training users on new enhancements
- GLS Power User through maintaining the following responsibilities:
Quick resolution of on line label issues during production. Contact global support team to escalate and resolve issues as needed Develop the label master image for new templates or modifications to existing ones
- Compliance & Governance - Ensure that all activities are carried out in a way supporting the Company requirements such as KORE, SOX and local applicable regulations.
- OE: Ensure operational excellence and lean approach to all applicable activities carried out in Transportation and Logistics.
Minimum Requirements
- Bachelor's Degree of Engineering.
- Previous experience in supply chain roles within CPS or equivalent organization
- Business acumen, understanding finance (P&L)
- Strong interpersonal skills and experience in working within cross functional teams
- Excellent analytical skills
- Excellent English spoken and written skills
- SAP experience preferrable
- Advanced MS excel (Pivot tables, V-lookup, If equation.) and power point experience (Advanced level)
- Excellent organization, time management and follow up skills.
