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 what qualities do you think supervisors take, What qualities do you...

What qualities do you think supervisors take into consideration when choosing whom to give a promotion to at work?

Describe why the creation and maintenance of an ethical, Explain why the cr...

Explain why the creation and maintenance of an ethical workplace is a challenge for business and HR specifically? CITED/REFERENCE IF ANY.

Explain what remedies are available to him, Kristina places an order for a ...

Kristina places an order for a cake on Flowers bakery's web site. She then calls the baker to tell him that she will pay him $1000 for the specially designed cake if he will guaran

Explain groups differently from other employees is necessary, Compare and c...

Compare and contrast what motivates Millennials from Baby Boomers, Generation X, and Generation Y. Assess whether motivating these groups differently from other employees is necess

Explain weeks of supply, The Bawl Corporation supplies alloy ball bearings ...

The Bawl Corporation supplies alloy ball bearings to auto manufacturers in Detroit. Because of its specialized manufacturing process, considerable work-in-process and raw materials

Explain what type of information must mititech''s suppliers, 1 To ensure th...

1 To ensure that its supply chain can handle a surge in demand, MitiTech should: a. hire additional manufacturing employees b. modify its design to speed up production time

Explain why do firms segment consumer markets, Why do firms segment consume...

Why do firms segment consumer markets? Enumerate the major segmentation variables and provide real-life examples of segmentation done by firms for their products/services.

Product focused production system, Product Focused Production System ...

Product Focused Production System In this type of production processing, the production departments are organized according to the type of product / service being produced, a

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