Question

Patrick wants to design an optimal network that minimizes the total cost $($i$.$e$.,$ production cost $+$ transportation cost $+$ fixed cost$)$ of both products. Which site$($s$)$ should be selected for new plants?

What production network would you recommend? Use Excel optimization model to determine the lowest$-$cost network plan.

Submit one Excel file including your answers, your model formulation, and excel output. Your answer should be in the order of the questions, and should be neat, clearly written, and concise. Highlight your answers to the questions in yellow. Graded on readability and flexibility of Excel setup. The Excel files must be executable. I have seen output in answer submissions that were clearly not generated by the submitted Excel file. If I run your Excel file, it should give the same results you submit. That means the spreadsheet has correct embedded formulae and Solver dialog boxes have all the inputs. Solver on excel should be executed and should produce the correct answer.

See attached picture for full details.