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

How enhance ethical behavior at work, Discuss options companies use to enha...

Discuss options companies use to enhance ethical behavior at work

Understanding or knowing customer - customer satisfaction, Understanding or...

Understanding or Knowing Customer - Customer Satisfaction and Service Quality Involves making the effort to understand the customer's needs. It involves: learning the customer

Explain interest rate risk, Please give a detailed explanation on the follo...

Please give a detailed explanation on the following scenario: You are a swap dealer and know that XYZ County finance director is clueless about how to conduct interest rate risk ma

Compare the traditional and matrix organization, Compare and contrast the t...

Compare and contrast the traditional and matrix organization. What are its advantages and disadvantages of the matrix organization?

., The following process is designed to handle 120 customers a day. The cus...

The following process is designed to handle 120 customers a day. The customer is “processed” through each of the two operations, A and B, in sequence form. The average rate of each

Explain economic aspect of the triple bottom line concept, A firm's busines...

A firm's business practices toward its labor force pertain mainly to the economic aspect of the triple bottom line concept.

Explain competitive advantage of southwest airlines, What might the competi...

What might the competitive advantage be for each of the following companies? a. EBay b. Southwest Airlines c. Starbucks d. Apple f. Facebook

What are some instances that would explain strategic groups, What are some ...

What are some examples that would explain strategic groups?

Testing the optimality, Step 1 : It is observed that cost of transportation...

Step 1 : It is observed that cost of transportation is to Rs. 144. Step 2: Testing the Optimality : After obtaining the initial basic feasible solution the next step is to test

Explain the decision variables for this problem, Problem 4: Comp-Max Comput...

Problem 4: Comp-Max Computers assembles computers and computer equipment. It is about to start production of three new types of computers, called model A, B, and C, respectively. E

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