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 marketing phenomenon occurs when there exists, The following market...

The following marketing phenomenon occurs when there exists within two city blocks the following hamburger outlets: McDonald's, Burger King, Sonic, and Wendys.

Explain what are the four communication styles, 1) Describe the five major ...

1) Describe the five major principles that support communication-style theory. 2) What two dimensions of human behavior are used to identify communication style? 3) What are

Service blueprinting - process design, Service Blueprinting - Process Desig...

Service Blueprinting - Process Design Most of the recording techniques described so far had their origins in the heyday of scientific management. Service blueprinting is much

Question 2, Exercise 2: Use of a Grid Analysis (Weighted Scoring Model) to ...

Exercise 2: Use of a Grid Analysis (Weighted Scoring Model) to Help Make the North American Plant Location Decision for the RX 330 This exercise illustrates how when deciding among

Explain one test of whether marketing research, One test of whether marketi...

One test of whether marketing research should be done is whether different outcomes will lead to different marketing actions. whether different outcomes will lead to the

Find the critical path, Using the information given in the following table:...

Using the information given in the following table: (A) Identify the critical path. (B) Determine expected project duration. Activities Precedes Duration Start a,b,c - a d 5 d f 6

Explain flowchart uses symbols to represent, A process flowchart uses symbo...

A process flowchart uses symbols to represent which of the following?

Explain greatest amount of flexibility possible, To meet investor objective...

To meet investor objectives, management seeks to do which of the following in its present operations as well as shift investment from areas with declining returns to those where im

Explain what should peter recommend to gwyn, What should Peter recommend to...

What should Peter recommend to Gwyn about Dana's case?

Explain what is the production, A local market research firm has just won a...

A local market research firm has just won a contract for several thousand small projects involving data gathering and statistical analysis. In the past, the firm has assigned each

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