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

Describe two methods for allocating costs, Explain two methods for allocati...

Explain two methods for allocating costs. Justify why you selected them and how you would make the most use of them in cost analysis. No copying and pasting or will not be ra

Explain sample provided by the supplier, A shirt manufacturer buys cloth by...

A shirt manufacturer buys cloth by the 100-yard roll from a supplier. For setting up a control chart to manage the irregularities (e.g., loose threads and tears), the following dat

Describe your opinions about executive compensation, 1. Why some employees ...

1. Why some employees entitled to overtime and others are are exempt from being paid overtime? 2. Explain what job sharing is and how it typically works in terms of compensation

Manager case, In the table given below the Distribution Manager is expected...

In the table given below the Distribution Manager is expected to service these DCs as per the demands placed. If the actual sales after completing week one is as follows, what woul

Describe departments being located close together, A (n) ____ gives the rel...

A (n) ____ gives the relative importance of each pair of operations or departments being located close together.

Explain sql commands that are used for data manipulation, What is the role ...

What is the role of structure query language (SQL) in database object creation and information management in a relational database? Identify three SQL commands that are used for da

Explain partial health care benefits would be a good idea, Do you think tha...

Do you think that offering part-time employees partial health care benefits would be a good idea?

Question 2, Exercise 2: Use of a Grid Analysis (Weighted Scoring Model) to ...

Exercise 2: Use of a Grid Analysis (Weighted Scoring Model) to Help Make the North American Plant Location Decision for the RX 330 This exercise illustrates how when deciding among

What are the elements of supply chain management, Q. What are the elements ...

Q. What are the elements of supply chain management? The three elements of supply chain management: • Responsiveness as an example how flexibly and rapidly supply can meet d

The Strategic Significance of Design, What is the strategic significance of...

What is the strategic significance of Design in operations management?

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