Integrated Planning Senior Manager

**Auto req ID**: 285139BR
**Role**:
The role will lead the complete demand & supply cycle for Egypt Beverage Business/Egypt Snacks Business. The role will be the main point of contact between SC and Commercial Team in terms of Market requirements, commercial agendas, etc.. Accordingly, will lead the planning cycle of SC to deliver these requirements. The role will be responsible for communicating the production plans with Manufacturing facilities while ensuring the material availability for the plan by setting the Raw and Pack Material delivery schedules with Suppliers & GP. The role will also have the visibility on the long-term productions schedules and will agree on the time slots with Engineering for overhauling of lines and stoppages required for projects.

**Accountabilities**

**A-Production Planning**:

- Develop Products requirements based on forecasted volumes for all business required periods (Strategic, annual, monthly, weekly and daily) and ensure a clear communication of the requirements plans to all manufacturing plants.
- Plan Product sourcing based on manufacturing and deployment overall cost to ensure the delivery of the finished goods to sales at the optimum cost.
- Plan Products manufacturing based on updated sales plans to ensure products availability for sales & distribution in the right time.
- Ensure the timely flow of production plans to both Production & FG warehouses functions in all plants.
- Define all finished goods inventory levels based on manufacturing / transportation lead times and forecasted sales volumes.
- Plan in coordination with finished goods warehouses function the availability of the adequate storage capacity for the targeted inventory levels.
- Control the finished goods inventory working capital in coordination with the Finance function to maintain healthy cash flow for the business.
- Monitor the production function performance by issuing tracking reports for finished goods actual production verses plans and report variances.
- Follow up on the production variance analysis and ensure the development of the proper action plans to close the variance.
- Lead the Finished Goods Inventory Planning organization securing the annual volume targets achievement while reducing overall Finished goods cost through better planning leading to efficiency improvements and optimized cost

**B-Material Planning**:

- Develop Raw and Pack Material requirements based on forecasted volumes for all business required periods (Strategic, annual, monthly, weekly and daily) and ensure a clear communication of the requirements plans to GP and Suppliers.
- Control Raw and Pack Material inventory working capital in coordination with the Finance function to maintain healthy cash flow for the business and optimum level of DII.
- Plan in coordination with R&P warehouses function the availability of the adequate storage capacity for the targeted inventory levels.
- Define all R&P inventory levels (Days on hand) based on suppliers lead time, availability risk and changes in commercial requirements (forecast)
- Collaborate with GP to avail extra 3PL warehousing to store R&M beyond available owned warehouses.
- Ensure the timely flow of R&P Material plans and call outs to Suppliers avoiding any production stoppages due to lack of R&P.
- Own all Financial Control requirements and perform required GCS tests

**C-Bottles & Crates Planning (Beverages only)**:

- Develop Bottles & Crates requirements for market and manufacturing based on forecasted returnable packages volumes for all business required periods (Strategic, annual) and ensure the timely forwarding of these requirements plans to the Central procurement function.
- Develop annual bottles & crates CAPEX (Around 25 MM$ per annum) to support volume growth.
- Schedule bottles & crates delivery based on updated production plans and trade injection requirements to ensure glass availability for manufacturing plants and customers at the right time.
- Ensure the timely flow of bottles & crates delivery schedules to both materials replenishment & materials warehouses function
- Define all bottles & crates inventory levels based on their delivery lead times and forecasted production plans.
- Plan in coordination with bottles & crates warehouses function the availability of the adequate storage capacity for the targeted inventory levels.
- Control the bottles & crates CAPEX in coordination with the Finance function to maintain healthy cash flow for the business.
- Monitor the bottles & crates delivery function performance by issuing tracking reports for bottles & crates actual delivery versus delivery plans and reporting variances.
- Monitor the bottles & crates actual injection versus plan and analyze variance in coordination with sales function.
- Monitor the bottles & crates actual breakage versus plan and analyze variance in coordination with plants managers.
- Follow up on the delivery, injection and breakage variances analysis and ensure the deve