Assignment Help-Solving network design problem
Ensure that Solver has been enabled on your PC. This may require you to turn Solver on in the “Add-Ins” area of Excel. For instructions on how to do this, you can go to the Office Support page and do a search for “Excel Solver Add-in.”
Quantitative answers to the questions raised in the text.
Explanations of what these solutions mean in business terms.
An explanation of the managerial implications to your solutions.
Answers to the following questions:
Consider the change in total distance as you move from two, to three, to four locations. How significant an improvement does the firm achieve in each step?
What change to your results do you see in parts C and D of question 6?
What service level impacts do you foresee as you move from two, to three, to four locations?
