Quantitative Analysis / Business Report(3000 words)
Develop an Excel workbook with multiple worksheets, each representing a supply network model for MiniToys under different scenarios optimized using Solver.
Write a 3,000-3,500 word business report summarizing the case, the objectives, the issues identified, and your analysis of the different networks options under consideration, together with recommendations and conclusion. Answer each of the case questions separately in a separate section at the end of the report. Use summary tables and figures to present the findings where necessary and appropriate. Show the mathematical formulation of the problem and the Solver setup in the appendix.