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 adaption and culture shock, The first response to unfamiliar surrou...

The first response to unfamiliar surrounds, like those encountered in an overseas assignment, is: Answer: a. Adaption b. Culture shock c. Fascination d. Reverse culture shock

Traditional approach, compare between traditional and value driven approach...

compare between traditional and value driven approach

Explain strategic decision support, Strategic decision support Alignment...

Strategic decision support Alignment of information technology and management goals in healthcare is essential. This alignment assumes that information technology experts be abl

Explain technology intensive should you make it, When you're creating a onl...

When you're creating a online site, how busy, technology intensive should you make it

Compute a regression line and forecast the demand, The number of heart surg...

The number of heart surgeries performed at Heartville General Hospital has increased steadily over the past several years. Use the data below to calculate a regression line and for

Thus if a budget is prepared it can only be a crude estimate, Frequently, a...

Frequently, at the time the project charter is prepared there is only a very general understanding of the project, so if a budget is prepared it can only be a crude estimate.

Explain what is your personal professional strategy, What is your personal ...

What is your personal professional strategy to remain competitive in this environment as globalization increases?

Reduce failures and improve productivity, Question: What Maintenance po...

Question: What Maintenance policies to be done by the operations manager to reduce failures and improve productivity? • Emphasize on suitable maintenance practices. • Give a

.., what steps of lacation selection?

what steps of lacation selection?

Explain market conditions profit probability, Mary Decker is thinking of su...

Mary Decker is thinking of suing the manufacturer of her car because of a defect that she believes caused her to have an accident, and kept her out of work for a year. She is suing

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