Assignment
Solving a Network Design Problem
This assignment requires you to use a mixed integer program to solve a network design problem.
1. Refer to the "Hands on Excel" discussion on pages 53-56 of the textbook.
2. Download the MIP 9 City Example Excel file from the assignment resources and open it in Excel.
3. 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."
4. Develop an answer to question 6 on page 61. In addition, solve the model with four locations.
5. Develop a 2- to 3-page document that includes:
o Quantitative answers to the questions raised in the text.
o Explanations of what these solutions mean in business terms.
o An explanation of the managerial implications to your solutions.
o 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?
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.
Attachment:- Reading.rar