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 a way in which resistance to change can be reduced, According to di...

According to dictionary.com, the term change is defined as follows: -verb (used with object) 1. to make the form, nature, content, future course, etc., of (something) different

Define what changes in dividends will affect the stock price, AirJet Best P...

AirJet Best Parts, Inc. is concerned regarding recent changes in its stock prices for the company and would like to determine the stock prices for key competitors. Key competitors

Explain silicon border play a role in mexico hi tech, How can Silicon borde...

How can Silicon border play a role in Mexico Hi tech manufacturing for US companies and the US market?

Explain larry is likely liable for a battery, Larry is upset with his roomm...

Larry is upset with his roommate Bill because he refuses to clean up after himself. In a fit of rage, Larry tries to slap Bill in the head, but he misses. At the time, Bill is turn

Define deming and crosbys views, Compare and contrast Deming and Crosbys vi...

Compare and contrast Deming and Crosbys views on the cost associated with a lost customer.

mba, What happens if balance doesn’t exis

What happens if balance doesn’t exist

Explain the benefits incubators bring to the small business, 1) Why is succ...

1) Why is succession planning important? How do large businesses do it and how to small business handle it? 2) Discuss the benefits incubators bring to the small business commun

Explain mamdouh finally sued for national origin, Mamdouh El-Hakem was empl...

Mamdouh El-Hakem was employed by BJY, Inc., for more than a year. His manager repeatedly called Mamdouh, an Arabic employee, "Manny" or "Hank", instead of his given name. His manag

Explain licensing contract manufacturing exporting, 1, Meridian sells sand ...

1, Meridian sells sand to customers in saudi arabia. 2, McDonald's in Germany. 3, Campbell's soup company contract with Nakano Vinegar form Campbell Nakano. 4, Flextronic

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