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 corporate-level strategy of diversification, Why are standards impo...

Why are standards important in many industries? As standards get adapted and become dominant, how does this process influence the competitive nature of the industry? When Walmar

Explain how an mnc selects an organizational structure, Complete a 3 page p...

Complete a 3 page paper in APA format (plus cover sheet and reference page) that discusses at least three factors that influence how an MNC selects an organizational structure

Briefly explain two arguments raised in the text, Briefly state two argumen...

Briefly state two arguments raised in the text for and against tort reform

Explain alternatives favourable market unfavourable market, Karen Villagome...

Karen Villagomez, president of Wright Industries, is considering whether to build a manufacturing plant in the Ozarks. Her decision is summarized in the following table: Alternativ

Explain corporate strategic alliance, Business-level, Corporate-level, and ...

Business-level, Corporate-level, and International Strategies Using the Internet, research about the following: • Globalization • International strategic alliances • Co

Explain competitive bidding, Why do some firms no longer rely only on compe...

Why do some firms no longer rely only on competitive bidding when awarding purchase contracts?

Describe analyze the elements of a typical scope statement, Analyze the ele...

Analyze the elements of a typical scope statement and the significance of each element. As a project leader, determine how you would communicate the scope of a project to the proje

Aid how to enter the answer after the equal sign using excel, Can someone s...

Can someone show me how to enter the answer after the equal sign using excel 2010

Explain matrix structure and provide examples, Some people argue that the m...

Some people argue that the matrix structure should be adopted only as a last resort because dual chains of command can create more problems that they solve. Discuss and provide exa

Explain should health care workers receive the flu vaccine, Should health c...

Should health care workers receive the flu vaccine? I f not why not?

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