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

Industrial society - operations function, Industrial Society - Operations F...

Industrial Society - Operations Function In the industrial society, estimated during the period of growth of industrialisation roughly 1820-1920, machines and the production o

Explain what is the stocks required rate of return, GD inc has preferred st...

GD inc has preferred stock outstanding that pays a dividend of $5 at the end of each year. The preferred sells for $50 a share. What is the stocks required rate of return? Show wor

Explain geographical information system help companies, 1. Briefly describe...

1. Briefly describe each of the four quantitative methods used to evaluate location alternatives. 2. How does a geographical information system help companies like Red Lobster or L

Find probability that the store is full, A drug store has two windows avail...

A drug store has two windows available for serving customers, who arrive at a Poisson rate of 40/hr. Service time is exponentially distributed with a mean of 2 min. Only one window

Offer a list one of the seven management tools, List one of the seven manag...

List one of the seven management tools and discuss how they might be used in developing a new product.

Explain change effect medical institutions, In your opinion do you think To...

In your opinion do you think Tort Reform will benefit the patients or the medical practitioners? How will this change effect medical institutions?

Explain indifferent between machines a and c, At a decision point in a deci...

At a decision point in a decision tree, which machine would you select when trying to maximize payoff when the anticipated benefit of selecting machine A is $45,000 with a probabil

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