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 are the upper and lower control chart limits, The defect rate ...

The defect rate for a product has historically been about 2.4%. What are the upper and lower control chart limits for a p-chart, if you wish to use a sample size of 100 and 3-sigma

Explain research process to start searching for participants, When is the b...

When is the best time in the research process to start searching for participants?

Explain what problems associated with planned change, What problems associa...

What problems associated with planned change should the OD practitioner be aware of? How might such problems be overcome?

Initiate an organizing campaign for the technical employees, 1) Company A w...

1) Company A wants to discourage unionization through the United Technical Workers of America. True or False: In order to do so, it can initiate an organizing campaign for the Tech

Product Design, In what ways is product strategy linked to product decision...

In what ways is product strategy linked to product decisions?

[email protected], What are all the steps involved in Work St...

What are all the steps involved in Work Study

Explain what is the roic, (Oscar's Office Building) Oscar is considering ge...

(Oscar's Office Building) Oscar is considering getting into the real estate business. He's looking at buying an existing office building for $1.8 million in cash. He wants to estim

Explain major strategic operational competitive dimension, Which of the fol...

Which of the following is not a major strategic operational competitive dimension that forms a company's competitive position?

Green supply chain management, what is the meaning of green sipply ...

what is the meaning of green sipply chain managent and is it applied in production process

Describe the term grievancein in briefly, Describe the term grievancein in ...

Describe the term grievancein in brifefy. A grievance may be: (i) Stated or unvoiced by the worker, (ii) Written or unwritten, and a ridiculous or valid, and may arise ou

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