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

Describe cloud computing and web 2.0, In this research paper, you will rese...

In this research paper, you will research cloud computing and Web 2.0 and write a two- to four-page (500-1000 word) research paper explaining the business uses of each. Using the i

Explain does anyone have any insight, Does anyone have any insight into Dis...

Does anyone have any insight into Discussion Question, This was not discussed in class.

Explain dynamic scheduling problem, Please explain how this works... I'm so...

Please explain how this works... I'm so confused! Suppose SPT rule is being used in a dynamic scheduling problem. There are five jobs A, B, C, D, and E ready to be processed at

Explain technology meets the requisite market potential, Pharma Blitz devel...

Pharma Blitz develops and markets new technological products to be used in health care. The development of a new product operates as follows. When a new technology meets the requis

Explain observation setting be natural or contrived, What are Best Practice...

What are Best Practices of college/university communications to students? Concerning this research project, what primary data would you suggest and by what methods should be used t

Explain traditional employment agencies, In what ways do executive search f...

In what ways do executive search firms differ from traditional employment agencies?

Organizational Structure & Design, How can we predict the effects of calcul...

How can we predict the effects of calculated and deliberate organizational change on informal networks and structures? How can we mitigate against unanticipated and unintended cons

Computer aided design., Computer Aided Design is one of the techniques used...

Computer Aided Design is one of the techniques used by Regal Marine in manufacturing of boats. With the aid of exapmles, critically discuss five (5) techniques that are important t

Explain most important concepts or knowledge that you gained, 1) Do you thi...

1) Do you think that the ISS Clinic investment in electronic medical records added value for the organization? How would you recommend measuring this "value"? If you do not think t

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