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 studies about individual voting decisions, Joan, age 40, is dissati...

Joan, age 40, is dissatisfied with her job. Martin, age 25, is satisfied with his job but thinks the union could provide better benefits beyond the associated costs. Most research

Oregon productivity matrix - performance measures, Oregon Productivity Matr...

Oregon Productivity Matrix - Performance Measures The Oregon productivity matrix (OPM) was developed in Oregon State University in 1986 and measures accomplishments against go

Define management practices increasing government regulation, How do you th...

How do you think management practices might change in response to increasing government regulation in the banking and health care industries?

Explain business knowledge competencies, Business knowledge competencies ar...

Business knowledge competencies are particularly important for which human resource role? Answer A) management developer B) employee advocate C) strategic partner D) functional exp

Explicitly explain the role you will take as chair, 1. When a group wants t...

1. When a group wants to achieve a consensus or unanimous decision, the responsibility of the chair is to be constantly attentive to the group process. Identify which of the pointe

Notate primary keys in each table with solid underlining, Review the inform...

Review the information currently housed in Huffman Trucking%u2019s database, in the Entities and Attributes for Fleet Truck Maintenance file on the virtual Organizations site. (Cus

Economic order quantity, The Warehouse Company supplies spare parts for its...

The Warehouse Company supplies spare parts for its two plants, Plant A and PlantB. Plant A and Plant B do not have any significant storage space. Hence you want carryminimum possib

Give an example of what team performance, Provide an example of what team p...

Provide an example of what team performance readiness might look like at various readiness levels

Describe what''s an effective mission statement, What's an effective missio...

What's an effective mission statement for the Chattanooga Ice Cream Division?

Explain corporate structure in relation to its strategy, Which company do y...

Which company do you know of that successfully has been able to successfully or not manage its corporate structure in relation to its strategy? Explain you're rational. Cite all yo

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