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 single pay off, in a -------------------employees are reward by giv...

in a -------------------employees are reward by given company stock or by being allow to purchase it at a price below market value/1.gain sharing plan/2.individual payoff/3.esop/4.

Explain your terms as you apply them to the relevant facts, You are current...

You are currently an intern working for the largest law firm in Alabama. Your mentor and senior attorney introduces you to a new client, Dick Jefferson, the owner of House Doctor,

List out reasons for the decision of the Production Manager, List out reaso...

List out reasons for the decision of the Production Manager backed up by the necessary data

Explain about leadership styles, Question: (a) Write short notes on any...

Question: (a) Write short notes on any five leadership theories and on any three main leadership styles. (b) Your friend has just been appointed team leader at his place o

Explain these with the actual service delivered, Q1 Evaluate the service to...

Q1 Evaluate the service to club members and casual flyers by completing a table similar to Table 3.1. Q2 Chart the five performance objectives to show the dif¬fering expectations

Explain what is the expected return of, Assume that you have $165,00 invest...

Assume that you have $165,00 invested in stock that is returning 11.50%,$85,000 invested in a stock is returning 22.75% and $235,000 invested in a stock that is returning 10.25%. W

Define fast food restaurant averages customers per hour, 1. A hospital emer...

1. A hospital emergency room averages 50 patients per shift. A shift is 8 hours long, and the average patient requires 20 minutes in the exam room. a. How many exam rooms should

Network design, 1. What is meant by the level of threshold service of a lea...

1. What is meant by the level of threshold service of a least-cost system?

Business organisation functions, ''OPERATIONS MANAGEMENT IS THE CENTRAL TO ...

''OPERATIONS MANAGEMENT IS THE CENTRAL TO THE FUNCTIONING OF ALL BUSINESS ORGANISATIONS''.with reference to the organisation of your choice discuss this statement highlighting how

Modelling, what are the characteristics of a good model

what are the characteristics of a good model

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