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

How minimizes the number orders waiting in the queue, Which of the followin...

Which of the following rules maximizes the number of orders processed in a center and minimizes the number orders waiting in the queue? Shortest operation next First-come/fir

How business leadership accomplishing company objectives, Provide two examp...

Provide two examples of current leaders and describe how they demonstrate their leadership characteristics. What separates these characteristics from management techniques? How eff

Explain what is the maximum inventory level, A company that makes kitchen f...

A company that makes kitchen faucets has found that demand for its model faucet is fairly constant at the rate of 100,000 units per year. Each model of faucet is made using the sam

Cisco systems NPI, 1. Using an appropriate operations framework outline the...

1. Using an appropriate operations framework outline the challenges / risks faced by Cisco in introducing a new product. 2. What are the general operational / supply chain issues i

Process charts, Process Charts Process chart is the diagrammatic repr...

Process Charts Process chart is the diagrammatic representation of various tasks and activities in sequence of operation passing through the production process beginning with

Explain customization and volume and process., The product-process matrix u...

The product-process matrix used to analyze manufacturing operations brings together the elements of: a) Customization, volume, and process. b) Volume, process, and intensity.

Explain functional structure with simple structure, Explain how the followi...

Explain how the following somewhat match each other: • functional structure with simple structure • divisional structure with departmentalization by product • machine bureaucracy w

Explain evaluating their own virtual teams, Is Volvo's approach to evaluati...

Is Volvo's approach to evaluating the effectiveness of its virtual teams one that could serve as a useful model for other organizations to follow in evaluating their own virtual te

How to view intermingling of management, The chapter notes that in 2010, in...

The chapter notes that in 2010, in roughly two-thirds of U.S. firms, the CEO is also the chair of the board of directors. More broadly this can be viewed as an intermingling of man

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