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 is the maximum time in hours the machine, 2-10 minute breaks, ...

2-10 minute breaks, 1-20minute lunch, 1-10 minute clean up, restroom. What is the maximum time in hours the machine is available to run in a single shift?

Determine the overall project completion time, Question : (a) Under wha...

Question : (a) Under what conditions is PERT preferred to CPM in project management ? Illustrate your answer with examples of projects. (b) Several stages are involved in

Write some possible entities and attributes, Develop a list of some possibl...

Develop a list of some possible entities and attributes located in chill's restaurant database.

Explain what are the optimal solution values of x and y, Suppose the firm i...

Suppose the firm in this example considers a second product that has a unit profit of $5 and requires 2 hours for each unit produced. Assume total production capacity remains 40. U

Describe case studies with ethnographic research, 1. What benefits can be g...

1. What benefits can be gained from case studies? What dangers, if any, are there in using case studies? In what ways are they useful? Support your answers. 2. Provide some exam

Introduction, what is production and operation management?

what is production and operation management?

Coca colas change in sales remain competitive and profitable, How would you...

How would you respond to Coca Cola's change in sales policy? How would you ensure Pepsi's board that this response will allow you to remain competitive and profitable?

Explain calculated values in descending order on the same, Create a procedu...

Create a procedure in VBA to do the following actions: -Create a linear series of numbers starting at 1 (e.g. 1, 2, 3,) -Display a Message Box asking if you'd like to calculate ano

Explain what is her portfolio''s beta, An individual has $25,000 invested i...

An individual has $25,000 invested in a stock with a beta of 0.8 and another $40,000 invested in a stock with a beta of 2.0. If these are the only two investments in her portfolio,

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