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

Calculate a tracking signal for months, The classified department of a mont...

The classified department of a monthly magazine has use a combination of qualitative and quantitative methods to forecast sales of advertising space. Results over a 20 month period

Explain survival of the fittest, From an evolutionary standpoint, is "survi...

From an evolutionary standpoint, is "survival of the fittest" selfish or selfless?

Explain what are the upper and lower control chart limits, The defect rate ...

The defect rate for a product has historically been about 2.4%. What are the upper and lower control chart limits for a p-chart, if you wish to use a sample size of 100 and 3-sigma

What are the ethics in decision making, What basic knowledge do you have re...

What basic knowledge do you have regarding the use of ethics in decision making?

How hrm is described as a primary activity, In Porter's value-chain model ...

In Porter's value-chain model a. HRM is described as a primary activity b HRM is described as a support activity c HRM is not mentioned as an activity d HRM is describe

Explain what assignment minimizes the total traffic flow, Please kindly sho...

Please kindly show step by step solutions. Six processes are to be laid out in six areas along a long corridor at Linda Babat Accounting Services. The distance between adjacent

Production control, Production Control After planning the next manageri...

Production Control After planning the next managerial production function is to control the production according to the production plans because production plans cannot be acti

List few of the strategic issues in supply chain management, The importance...

The importance of Supply Chain Management cannot be underestimated because it ensures that the right materials are at the right place at the right time at a minimal cost and maximu

Explain discussion of power and influence, From the Finding the Leader in y...

From the Finding the Leader in you highlight, we read about Nelson Mandelas use of power for the greater good. Using the books discussion of power and influence as a backdrop, anal

Explain about the vertical integration, Q. Explain about the vertical integ...

Q. Explain about the vertical integration? Backwards vertical integration a firm integrating backwards into its supply chain, the supplier included in a previous and a various

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