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 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

Explain transnational model, Q1. Is changing the organization's domain a fe...

Q1. Is changing the organization's domain a feasible strategy for coping with a threatening environment? Can you think of an organization in the recent news that has changed its do

Explain marketing to customers and consumers, Discuss the value of marketin...

Discuss the value of marketing to the consumer, the stakeholder and stockholder. Address the following: a. the value you place on marketing b. the value of marketing to customers a

Compute the linear charge density, An infinite line charge produces a field...

An infinite line charge produces a field of 9 × 104 N/C at a distance of 2 cm. Calculate the linear charge density

Success of change initiatives is why many initiatives fail, Failure to anti...

Failure to anticipate and mitigate circumstances that might impede the success of change initiatives is why so many initiatives fail. From a business managers perspective, what doe

Annual carrying costs per pot are estimated, Garden Variety Flower Shop use...

Garden Variety Flower Shop uses 740 clay pots a month. The pots are purchased at $2 each. Annual carrying costs per pot are estimated to be 30 percent of cost, and ordering costs a

Explain what is cube per order index policy, What is Cube per order index p...

What is Cube per order index policy, and state any real life application to this warehouse policy.

Explain staff time is saved in the form of reduced staff, As throughput imp...

As throughput improves, staff time is saved in the form of reduced staff worked hours per unit of service

Explain management''s responsibility regarding risk, There is a puzzle in r...

There is a puzzle in regard to risk. What is management's responsibility regarding risk? At what level(s) does each aspect of risk management lie?

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