Solving network design problem

Assignment Help Business Management

Reference no: EM132392972

Solving a Network Design Problem

This assignment requires you to use a mixed integer program to solve a network design problem.

Refer to the "Hands on Excel" discussion on pages 53-56 of the textbook.

Download the MIP 9 City Example Excel file from the assignment resources and open it in Excel.

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."

Develop an answer to question 6 on page 61. In addition, solve the model with four locations.

Develop a 2- to 3-page document that includes:

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?

As you complete your assignment, be sure your paper meets the following guidelines:

Written communication: Written communication is free of errors that detract from the overall message.

APA formatting: All resources and citations should be formatted according to current APA style and formatting guidelines.

Length: 2-3 typed, double-spaced pages.

Font size and type: 10-point Arial.

Attachment:- ALTERNATIVE SERVICE LEVELS AND SENSITIVITY ANALYSIS.rar

Attachment:- City example.rar

Reference no: EM132392972

Questions Cloud

What is customer benefit package-explain triple bottom line : What is a customer benefit package? What is definition of a value chain? Explain the balanced score-card.? Explain the triple bottom line.

Gonzalez-padron addressed several ethical issues : Gonzalez-Padron (2015) addressed several ethical issues that have arisen in the 21st century.

How to make an ethical difference in your business : Before starting your discussion, read the Forbes article How to make an ethical difference in your business.

Describe the company former business strategy : How would you describe the company's former business strategy? How would you describe the new business strategy?

Solving network design problem : Solving a Network Design Problem. Explanations of what these solutions mean in business terms. An explanation of the managerial implications to your solutions.

Moral philosophy-justice and white-collar crime and power : Pick one of the following terms for your research: Moral philosophy, justice, white-collar crime, differential association, or power.

Demonstrate personal passion for your position : Demonstrate personal passion for your position and critical thinking with persuasive language, sound logic, valid claims, and credible support for the claims.

Media content reflect-influence society attitudes-behaviors : Analyze ways in which different types of media content reflect and influence society's attitudes and behaviors. Analyze various issues affecting media business

Differences between process improvement framework : Compare and contrast the fundamental differences between process improvement framework and problem-solving framework.

User Account

All Pages