Problem within that supply chain

You are required to choose a manufacturing company such as toyota or samsung or others and show the supply chain of that company showing the manufacturers suppliers factories etc. Identify a problem within that supply chain such as transportation cost or other then you are required to research data an use linear programming in excel to solve that problem.

Also use the arena simulation program and be able to gather data and implement it into the simulation. Show screenshots of the linear programming and arena simulation with explanations and analysis. a detailed brief of the assignment will also be attached below.