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 appraisal process for your department, For this discussion, let us ...

For this discussion, let us put you in the department director chair, nursing director, lab director, radiology director, respiratory therapy director, or whichever hat fits best.

Explain what is the resulting productivity ratio, The total output from a p...

The total output from a production system in one day is 900 units and the total labour necessary to produce the 900 units is 900 hours. Using the appropriate productivity measure,

Service level agreements, Service Level Agreements are normally associated ...

Service Level Agreements are normally associated with   Outsourcing.

Outline suggestions for stimulate strategic entrepreneurship, As the invest...

As the investment community watches to see if Blockbuster will be able to sustain a double-digit growth rate under the new direction, the CEO is reviewing his actions as the strate

Explain framework of the general model of planned change, Describe the fram...

Describe the framework of the general model of planned change. Include a discussion of each activity and a typical sequence of events.

Explain characterize the bacterial and bacterial-like, Characterize the bac...

Characterize the bacterial and bacterial-like STIs, focusing on infectious agents and manifestations

Explain how technology can help your suggestions, Come up with 3 businesses...

Come up with 3 businesses that do not need technology to compete, and then demonstrate how technology can help your suggestions be more successful. For example - a hot dog stand. F

Logistics alliances for initiation and maintenance, What are the major cons...

What are the major considerations regarding logistics alliances, for: a) initiation? b) implementation? c) maintenance? d) termination?

Explain self-awareness and empathy, The perceptual distortion of projection...

The perceptual distortion of projection can be controlled thru a high degree of/ 1.ethical behaviour/2.cognitive consistency/3.emotional discernment/4. self-awareness and empathy/5

Explain various types of media that attracted your attention, List five adv...

List five advertisements from various types of media that attracted your attention. Discuss the characteristics that determined your selection

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