Winter_Internship_Summit_PS_Case_Study.pptx

Product Supply Case Study

1. Product Supply Case study Winter Internship Summit

2. Groups distribution Group 1 Function Nadine Wafaa Khalil IT Karim Ehab Salah Eldeen PS Khaled Khaled Amara PS Mahmoud Ahmed Hamdy PS Kamal Abd El-Hameed Elnemr PS Group 2 Function Mohamed Ahmed Khalil IT Maryem Elsayed Ramadan PS Mohamed Maged Elborolosy PS Rowan Amr Osman PS Kareem Ehab Mabrouk PS Group 3 Function Adham Khaled Hegazy IT Abdallah Mohamed Shehab Ellethy PS Abdelrahman Osama Nabih PS Shady Awad Hamza PS Fadia Mostafa Mohamed Mosaad PS Team 4 PS Function Ghada Olwoy Ahmed IT Fatima Mohsen Hagag PS Hussein Ahmed Aboelnour PS Marwan Mohamed Mohamed PS Amr Mostafa Abdelghaffar PS Group 5 Function Abdelrahman Gamal Abouzeid IT Alaa Mahmoud Abdallah PS Youssef khaled Abdelaziz PS Mina Rady Bakheet PS Ahmed Elsayed Hussien PS Group 6 Function Muhammad Ahmed Zahran IT Ahmed Yasser Mohamed Riad Ali PS Habiba Amr Fouad PS Huda Ramadan Mustafa PS Ahmed Aly Almahlawy PS Group 7 Function Mohamed Aly Youssef IT Menna Yehia Zakareya PS Muhamed hossam Abdelhamid PS hassan mohamed Attia PS Manal Abdelmageed Tawfiq PS Group 8 Function Ahmed Samir Abosamaha IT Kariman Khaled Anis IT Mohamed Ayman Hafez PS Sherif Maged Mourad PS Sarah Hesham Hassan PS Group 9 Function Alfarouk Amr Sabry IT Youssef Mohamed Kersha IT Ahmed Amr Elawaad PS Mohanad Ahmed Toaima PS Zeinah Yasser Abbady PS Group 10 Function Farah Hesham Eissa IT Mohamed Samir Fattouh IT Fadi Saber Asham PS Mohamed Yasser Emam PS Ravey Hany Atia PS Aly Mohsin Adeeb PS

3. Venus innovation Grow market share by 4% in MEA region Deliver 120$MM NOS profit

4. Useful definitions Units of Measure (UoM) – BUoM, SU, MSU Operating profiles – staffed capacity Capacity calculation Capacity equation: (# of hrs staffed * 60 min/hr * PPM) / conversion factor Conversion factor = 9000 CtD Ratio Available staffed capacity of a resource or group of resources / Total demand volume required from this resource or group of resources

5. Launch in March 2023 In the common channels across 5 different markets (A, B, C, D, and E) Market A is the local market Sourced from 1 manufacturing plant in Egypt Case study details March February January

6. Launch timeline March February January Trade Channels Distributors Plant plant

7. Launch in March 2023 In the common channels across 5 different markets (A, B, C, D, and E) Market A is the local market Sourced from 1 manufacturing plant in Egypt This plant has 5 different lines These lines operate on 2 different technologies Case study details

8. forecast Volumes per market (MSU) Technology Line/Market Market A Market B Market C Market D Market E Total Technology 1 Line 1 100 8 8 116 Technology 1 Line 2 78 6 6 90 Technology 1 Line 3 98 7 11 4 15 135 Technology 2 Line 4 80 5 30 20 50 185 Technology 2 Line 5 30 2 10 6 15 63 Total 386 28 65 30 80 589

9. Market priorities Market Priority Market E 1 Market A 2 Market C 3 Market D 4 Market B 5

10. Operating profiles per line Technology Line Operating Profile PPM (BUoM) Technology 1 Line 1 24/5 51 Technology 1 Line 2 24/5 46 Technology 1 Line 3 24/5 50 Technology 2 Line 4 24/6 51 Technology 2 Line 5 15/5 46

11. On 3 rd of Jan, you were expecting 420,000 Kg from a generic raw material (RM) to arrive to your plant. However, upon receiving & inspecting the material, the site QA team blocked 30 drums (10,000 kg each) after they were contaminated while being moved from the warehouse to the staging area causing a runout on this RM Now, you are only left with 12 drums (10,000 Kg each) from the RM to operate the lines until the next shipment arrives at port on the 15 th of Jan & arrives on site on 22 nd of Jan This is assuming the demonstrated time needed for customs clearance (7 days) You are requested to manage the supply planning such that you manage to deliver the initiative launch on time with the least cost implications You can refer to the table in slide 12 for the RM consumption per line & the table in slide 13 for the Month-To-Date (MTD) shipments per line per market at the time of the runout Problem statement

12. You are also requested to use the visualization tool most relevant to visualize the projection for the needed RM consumption for the next 2 years assuming that: The market is growing 5% in JFM & AMJ and stays flat for JAS & OND (Year 1) In the 2 nd year our volume is fluctuating by quarter as follows: JFM – Volume declining 10% AMJ – Volume stays flat JAS – Volume grows 50% OND – Volume stays flat Problem statement (continued)

13. Raw material consumption per line Technology Line RM Consumption (Kg/MSU) Technology 1 Line 1 810 Technology 1 Line 2 560 Technology 1 Line 3 780 Technology 2 Line 4 914 Technology 2 Line 5 730

14. MTD shipments per line per market Technology Line/Market Market A Market B Market C Market D Market E Total Technology 1 Line 1 7 2 2 11 Technology 1 Line 2 7 3 2 12 Technology 1 Line 3 8 2 1 3 14 Technology 2 Line 4 9 2 5 16 Technology 2 Line 5 3 3 6 Total 34 5 11 1 8 59

15. Case study timeline You will be assigned to a group & you can start working on the case study as of now There will be facilitators from the team to help guide you on the case study briefing Each group is allowed to send emails asking for missing information once per day! We will reply to your inquires on the first half of the next day Last day to send your questions is Wednesday 5 pm Feel free to mail [email protected] & [email protected] with your questions Replies to the missing info can either be “Not Relevant” or an extra piece of data/information to support a stronger case study Points are calculated based on: Number of relevant information revealed Launch was secured on time or not Cost upcharge to secure the launch on time On 16 th Dec, you will present your case study to the panelists Each group will be allowed 20 mins for presentation & 20 mins for discussion

16. THANK YOU FOR JOINING