Formulate an integer programming model

Assignment Help Operation Management
Reference no: EM1399124

2 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.

                                             response times (in times) fire in tract                                                                                    

  

Assigned station located in tract

  
  

1

  
  

2

  
  

3

  
  

4

  
  

5

  
  

1

  
  

5

  
  

12

  
  

30

  
  

20

  
  

15

  
  

2

  
  

20

  
  

4

  
  

15

  
  

10

  
  

25

  
  

3

  
  

15

  
  

20

  
  

6

  
  

15

  
  

12

  
  

4

  
  

25

  
  

15

  
  

25

  
  

4

  
  

10

  
  

5

  
  

10

  
  

25

  
  

15

  
  

12

  
  

5

  
  

Average frequency of fires

  
  

2 per day

  
  

1 per day

  
  

3 per day

  
  

1 per day

  
  

3 per day

  

Reference no: EM1399124

Questions Cloud

Illustrate what value did newscorp place on the control : Immediately prior to the Newscorp bid, the shares of Dow Jones traded at $33 per share. Illustrate what value did Newscorp place on the control of Dow Jones and Industry?
How media has changed in last century : Consider a movie or TV show as you remember it as child, as teenager, as young adult, and now. What changes can you note from personal observations and recollections?
Explain how the shelves are replenished and so on : Explain how the shelves are replenished and so on. Develop several conclusions from your observations. Make several recommendations for improvement.
Explain what health risks may arise : Explain what health risks may arise people use this hot water in the preparation and cooking and what is the equilibrium constant for this reaction
Formulate an integer programming model : 2 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.
Probability of an event : What is meant by the probability of an event? Discuss how addition and multiplication techniques are used to solve probability problems.
Where is genetic material found in plant cells : Mitochondria are the only organelles that contain their own DNA (circular) and have a double membrane. Why do you think this might be so?
Compares their performance against the goals : When Fred measures the performance of his employees and compares their performance against the goals he set for them, he is performing which of these functions?
Calculations of conditional probability : What is the conditional probability of a manager in the Division of Community Services reporting workplace sexual harassment?

Reviews

Write a Review

Operation Management Questions & Answers

  Illustrate what types for hr change could have affected

Illustrate what types for hr change could have affected reductions in workers compensation expenses, employee's turnover, also increases in customer satisfaction.

  Is there a problem with this hiring practice explain why

Traci buys Y&R clothing also likes "look," so she applied for position that day also was hired. This same system is used to hire sales associates from all races also ethnic groups, men also women. Is there a problem with this hiring practice? Expl..

  Evaluate a security breach to a corporation''s database

What do you think is the best method to evaluate a security breach to a corporation's database, employee credit cards, and corporate executive business accounts?

  What type of steel should be used to construct the bridge

What type of steel should be used to construct the bridge? How will the safety of workers be ensured during construction and steel erection?

  What is the optimal interval

What is Office Supreme's optimal ordering quantity and optimal associated cost? What is the optimal interval (in working days) between orders?

  The circulation manager of the new york times

The circulation manager of The New York Times in State College, PA is trying to decide how many copies of the upcoming Sunday edition of the paper to order so as to meet the demand of local customers

  Why it is important to measure return on investment

Why it is important to measure return on investment (ROI) of international assignments? What elements should be included in the ROI calculation?

  Justify how you would generate change

Justify how you would generate change and articulate a vision of change within a particular organization of your choosing. Conceive a rationale for the beginning of a change initiative for this company.

  Logistics pr provides services to three types of markets

Logistics PR provides services to three types of markets: Low, Intermediate and High. Each category refers to a construct of several key variables that makes the market competitively desirable.

  Calculate the hotel''s average daily cost due to overbooking

Simulate 3000 days of operation to calculate the hotel's average daily cost due to overbooking and opportunity costs.

  Consider for a moment the company footlocker

Consider for a moment the company "footlocker" Please provide me with three aspects of that business that you feel should be strengthened, and what you would do to make those improvements.

  Crossover point between existing process and the proposed

What is the crossover point between the existing process and the proposed process? If the owner expects to sell 9,000 pizzas, should he get the new oven?

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