Inventory Control Specialist
Coca-Cola
- Cairo
- Permanent
- Full-time
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:
- ITS Mobile Power User through maintaining the following responsibilities:
- GLS Power User through maintaining the following responsibilities:
- 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.
- 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.