Formulate an integer programming model using excel solver, Operation Management

Assignment Help:

New fire stations are to be located in a city and the major of the city wants to decide where to locate the 2 fire stations. For planning purposes, the region has been divided into five tracts, with no more than one fire station to be located in any given tract. The decisions to be made consist of the tracts to receive a fire station and the assignment of each of the tracts to one of the fire stations. The objective is to minimize the overall average of the response times to fires.

The following table gives the average response times to a fire in each tract if that tract is served by a station in a given tract. The bottom row gives the forecasted number of fires that will occur in each of the tracts per day.

Formulate an integer programming model for this problem and solve it using Excel Solver.


Related Discussions:- Formulate an integer programming model using excel solver

Explain function of operational leadership, Create a scenario that depicts ...

Create a scenario that depicts how the first line leader should act to fulfil the purpose and function of operational leadership in his or her area

Is idea of skinner of operational focus is relevant today, 1. Is Skinner's ...

1. Is Skinner's idea of operational focus just as relevant today? (Give a considered opinion - with examples.)  Answer: The answer is yes. There are physical limitations in many

What are the advantages as well disadvantages for a u.s, What are the advan...

What are the advantages and disadvantages for a U.S.-based company entering a mature market economy?

Explain generally unnecessary to have every single function, It is generall...

It is generally unnecessary to have every single function represented on the core team of the project as that would make the team large than necessary and difficult to communicate

Compare the traditional and matrix organization, Compare and contrast the t...

Compare and contrast the traditional and matrix organization. What are its advantages and disadvantages of the matrix organization?

Strengths and weaknesses of a tiny family owned restaurant, Assume you work...

Assume you work for a family owned restaurant, WHAT ARE some of the typical strengths and weaknesses of a small family owned restaurant? What types of opportunities and threats wou

Explain diversified network, USAA, which provides financial services to mil...

USAA, which provides financial services to military officers by mail and telephone, is an example of a Answer focused service. Focused network. Clustered service. Diversified netwo

Questions, A manufacturer of business copier workstations has a 75 percent ...

A manufacturer of business copier workstations has a 75 percent customer retention rate. Their accounting department estimates the incremental contribution to profit and overead as

Determine the biggest management challenge, What does Drucker see as the bi...

What does Drucker see as the biggest management challenge for the 21st century?  Answer: Improving the productivity of the office worker.

Explain how will learning managerial problem solving help, How will learnin...

How will learning managerial problem solving help you later in life in you job?

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd