khaled ahmed singy

Supply Chain InternInternship

• Job Details:-- Worked on developing a strategic marketing plan for PepsiCo Agro Seeds Program through three phases: ‧ Operational Analysis: using different forecasting and data analysis methods for developing three years plan including multiplication rate for the seeds, total cost and selling price ‧ Marketing Planning: applying marketing plan steps on the seeds program products including situational analysis, external analysis, objectives and marketing strategy ‧ Financial Analysis: applying different financial ratios on the program for determining its profitability and developing P&L statement for the next three years - I was chosen to be the Best Intern in PepsiCo summer internship program 2019

Supply Chain InternInternship

• Job Details:Worked on four projects: ‧ Zoning of the raw materials warehouse according to Nestlé products categories ‧ Creating a methodology for measuring how much we comply with the warehouse zoning ‧ Creating a new method for inputting and analyze the out of stock data using Excel Macro ‧ Applying ABC classification on the raw materials warehouse

Supply chain InternInternship

• Job Details:- Got introduced to production planning & MRP process and concepts - Worked on re-creating sheets for Weekly production plan, DOH & Material requirements plan (Net & Gross) and linking between them using Excel