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

Libertarian view on the importance of consumer rights, Compare a Utilitaria...

Compare a Utilitarian and a Libertarian view on the importance and enforcement of consumer rights.

Define how many spools should be tested for quality control, A clothing man...

A clothing manufacturer receives a shipment of 30 spools of wool from its supplier. Using Mil Std 105E under normal conditions, how many spools should be tested for quality control

Ans, What do you understand by “line balancing”? What happens if balance do...

What do you understand by “line balancing”? What happens if balance doesn’t exist?

What is the supply chain terminology, What is the supply chain terminology?...

What is the supply chain terminology? Supply chain terminology: • Upstream refers to processes which arise prior to an organisations supply stage. • Downstream refers to

Explain what is the value of the game, Consider the following two-person ze...

Consider the following two-person zero-sum game. Assume the two players have the same two strategy options. The payoff table shows the gains for Player A.               Player B

Explain steps in project completion have been finalized, Explain to a new p...

Explain to a new project manager how you ensure that all steps in project completion have been finalized

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

Explain key components of your business, Imagine that you are beginning the...

Imagine that you are beginning the very first social networking site, fast-food restaurant, or pizzeria, and develop a brief business plan that highlights the financial, marketing,

Explain what steps can ford motor take, The United Auto Workers union enter...

The United Auto Workers union enters into contract negotiations with the Ford Motor Company in Michigan. What are the three main subject areas the UAW can negotiate with Ford? Prov

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