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

Benefits of e-business, Benefits of E-Business There are many benefits...

Benefits of E-Business There are many benefits claimed for e-business, including: 1.      Increased capacity 7 days, 24 hours  2.      Reduced transaction costs/ cost of

Find how much does the airport need to set aside now to pay, Orlando Intern...

Orlando International Airport plans to extend passenger capacity of its existing terminal to accommodate its forecasted growth. A new terminal would be needed once the state's busi

Who was the founder of scientific management, Who was the founder of Scient...

Who was the founder of Scientific Management? Ans: The founder of Scientific Management is F.W. Taylor.

Explain disadvantages of giving teams a lot of autonomy, Using terms from t...

Using terms from this chapter, how would you characterize the teams at ICU Medical Inc.? What are some advantages and disadvantages of giving teams a lot of autonomy to make decisi

Explain what are the boundary points of the feasible region, Maxwell Manufa...

Maxwell Manufacturing makes two models of felt tip marking pens. Requirements for each lot of pens are given below. Fliptop Model Tiptop Model Available Plastic 3 4

Explain does anyone have any insight, Does anyone have any insight into Dis...

Does anyone have any insight into Discussion Question, This was not discussed in class.

Compute the overall proportion of tourists, A state department of tourism a...

A state department of tourism and recreation collects data on the number of cars with out-of-state license plates in a state park. (The group's position is that more out-of-state p

Define job evaluation, Define job evaluation. Definition: Job evaluatio...

Define job evaluation. Definition: Job evaluation is a systematic process of evaluating various jobs of an organization. Depending on the characteristics and needs of a job, jo

Forecast, Saint Louis - LAW - 822 NotesWednesday, October 31, 20122:31 PMRe...

Saint Louis - LAW - 822 NotesWednesday, October 31, 20122:31 PMReview: Causation:o The defendant must have been the proximate cause of the injury/death:Death must have been reasona

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