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

Analyze the environment and processes and procedures, Analyze the environme...

Analyze the environment, processes, and procedures at your work or school to determine which aspects can be controlled and which cannot be controlled. Explain your rationale. •From

Explain integration of social networking, Choose any company web site (it c...

Choose any company web site (it can be your own company) and evaluate its effectiveness. Write an essay of between 750-1000 words, double-spaced, focusing on such topics as the web

Explain what is the probability that both are successful, DO NOT WORK A com...

DO NOT WORK A company is considering producing two new electronic games designed for the popular Gameboy toy. Based on market data, management believes there is a 60 percent chance

Explain human resource management process first step, Explain the first ste...

Explain the first step in the Human Resource Management Process. What is the "De-recruitment", and how might it relate to this first step?

Explain what is the utilization rate of this service system, "Fast Eddie" F...

"Fast Eddie" Flournoy manages the service equipment division of Delta Airline's Atlanta terminal. He keeps a service crew on call to repair tow tractors that break down. Tractors b

Wlan standard is compatible with what other wlan standard, The 802.11g WLAN...

The 802.11g WLAN standard is compatible with what other WLAN standard? a. Bluetooth b. 802.11a c. 802.11b d. HomeRF

Key performance objectives of operation strategy, Key Performance Objective...

Key Performance Objectives of Operation Strategy There is broad consensus that supports the view that operational competitive priorities which satisfy customers such as price

Depict a p-chart based on the questionnaire results, 1. A shirt manufacture...

1. A shirt manufacturer buys cloth by the 100-yard roll from a supplier. For setting up a control chart to manage the irregularities (e.g., loose threads and tears), the followi

Explain protected group category, To be considered lawful, a voluntary affi...

To be considered lawful, a voluntary affirmative action plan must meet all of the following criteria except: a. it must be permanent b. It must exist to eliminate past imbalances b

Explain organizations periodically turn to, Organizations periodically turn...

Organizations periodically turn to _________ to meet demands for talent brought about by business growth and a desire for fresh ideas, or to replace employees who leave.

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