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

Rapid innovation - customers needs for a product, Rapid innovation - Custom...

Rapid innovation - Customers Needs for a Product The readiness with which the operations system can generate new products and services, and get them to market quickly. A study

Define how customers were affected the bp oil spill disaster, How customers...

How customers were affected the BP oil spill disaster in the gulf

Explain what are the risks and opportunities of the strategy, What are the ...

What are the risks and opportunities of the strategies followed by Pepsi? of Coca Cola?

Explain crises are a regular part of organizational life, How do you think ...

How do you think planning in today's organizations compares to planning 25 years ago? Do you think planning becomes more important or less important in a world where everything is

How to construct an electricity generating unit, To construct an electricit...

To construct an electricity generating unit, a company has to install 60 items. One team takes on an average 30 days to install one item. A team works for 300 days/year and managem

Gaining Trust with Culture Disparties, Ask quFor this assignment, you will ...

Ask quFor this assignment, you will apply critical thinking to what you have learned up to this point in this course regarding the successes and failures of the U.S. health care sy

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 challenges has the european union consortium faced, Describe what c...

Describe what challenges has the European Union Consortium faced in the last 2-3 years

Process flow and layouts, process flow and layout flows are at the core of ...

process flow and layout flows are at the core of lean manufacturing, do you agree or disagree?

Explain what is the assembly line efficiency, An assembly line with 30 acti...

An assembly line with 30 activities is to be balanced. The total amount of time to complete all 30 activities is 42 minutes. The longest activity takes 2.4 minutes and the shortest

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