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 network design is a key business decision, Network design is a key ...

Network design is a key business decision as well as a technological decision. Why? Provide an example of a company you believe has a good network design, providing supporting rati

Explain computer criminals become more innovative, Identify potential ethic...

Identify potential ethical challenges that may be faced by security professionals as technology advances, applications become more mobile, and computer criminals become more innova

Explain why are unions exploring new collaboration solutions, Why are union...

Why are unions exploring new collaboration solutions in the face of economic/work adversity, and how did Saturn's ambitious Quality of Work Life (QWL) program address these factors

Find which among the following statements are correct, If random variable X...

If random variable X follows the Normal distribution. X~Normal(10,10). Which among the following statements are correct? Answer a. P(X b. P(X=10)=0 c. P(X>8)=1-P(X

Explain the characteristics of an effective team, Question 1: Explain h...

Question 1: Explain how a leader can enhance the performance in a team? Question 2: (a) Define ‘A Team' and explain the different stages in ‘Team Development'. (b)

Financial risk, the importance of the measurtement of market risk for finan...

the importance of the measurtement of market risk for financial institution

Performance management, Performance Management Discuss Performance Ma...

Performance Management Discuss Performance Management in the context of the identifying the relevant School of Management Theory.  Identify positives and negatives in the app

Explain xerox customer-service teams, When it comes to how a team is design...

When it comes to how a team is designed (i.e., members, communication, goals, norms, etc.) and team leadership, which of the following statements is most true based upon the studie

Problem, a firm isconsidering replacement of a machien, whoes cost price is...

a firm isconsidering replacement of a machien, whoes cost price is rs 12200 and scrap value is rs 200 the running cost is rupee given below year running cost 1 200 2 50

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