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

Central tendency of sample means, Central Tendency of Sample Means As...

Central Tendency of Sample Means As was shown earlier (Advantages of SPC: feedback, the use of individual output measurements as the basis for process adjustment is inappropr

Optimal order interval, would you recommend changing to the optimal order i...

would you recommend changing to the optimal order interval?

Sequencing Method, Please Give question & answer of Sequencing Method Solut...

Please Give question & answer of Sequencing Method Solution

Compare today''s business world with the one of 40 ago, How does today's bu...

How does today's business world compare with the one of 40 ago? What is different about today and what is not so different? Electronincs assembly Inc. operates two 8 hour shifts

Ppc in mass and flow production system, PPC in Mass and Flow Production Sys...

PPC in Mass and Flow Production System Continuous  production  is the  specialized  manufacturing  of identical  articles on which  the equipment  is  fully  engaged. Continuo

Performance prism - performance and productivity measures, Performance Pris...

Performance Prism - Performance and Productivity Measures Neely and Adams (2000) argue that in their recent research managers and academics highlight the need for a fresh pers

Explain what the earliest the project can be completed, The following table...

The following table shows the activity details of a project. What the earliest the project can be completed? Activity Days Predecessor ctivities A 4 - B 5 - C 3 A D 5 A E

Explain does a valid contract exist between two persons, You are currently ...

You are currently an intern working for the largest law firm in Alabama. Your mentor and senior attorney introduces you to a new client, Dick Jefferson, the owner of House Doctor,

Explain goals should not be clearly articulated, Clearly-defined goals are ...

Clearly-defined goals are the essence of great teamwork. Which of the following statements is most true about how goals should be articulated by teams: a. Goals should not be clear

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