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

Describe what makes google successful, Research Google and develop a 3 page...

Research Google and develop a 3 page paper by answering the following questions: Need cite and reference. 1) Briefly describe the organization 2) What makes Google successful

Describe specific strategies, What challenges may arise if a U.S. project m...

What challenges may arise if a U.S. project manager moves to a foreign country to manage a project for 5 years? Discuss specific strategies that the U.S. project manager could use

Describe the cleanliness and atmosphere, First, select an independent resta...

First, select an independent restaurant located in California (fast food, fast casual restaurant, casual dining restaurant or buffet restaurant) and dine in the restaurant. You wil

International, what factors have contributed to the importance of internati...

what factors have contributed to the importance of international markets on operations management

Define manager can ever give up responsibility for an action, The about whe...

The about whether or not a manager can ever give up responsibility for an action to someone who reports to them as opposed to another manager at their level? And Why?

Explain the logistics has such an important economic impact, Why or why not...

Why or why not the logistics has such an important economic impact

After working for 30 years, After working for 30 years, Ramjee Somjee Dutt ...

After working for 30 years, Ramjee Somjee Dutt opted for VRS and started a courier company and did

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