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 separately compiled modules of a program, A system program that com...

A system program that combines the separately compiled modules of a program into a form suitable for execution A. assembler B. linking loader C. cross compiler D. load

What benefit would utilize the optimal order quantity yield, Garden Variety...

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

Explain it is important to have a vision, It is important to have a vision....

It is important to have a vision. If you were Jerome Byrd, how would you prepare a new vision for your department?

Rules related to the use the human body, Rules Related to the  use  the ...

Rules Related to the  use  the Human  Body: R elated to the  use  the Human  Body : a.   The two  hands should  beings  as well as  complete their  motions  at the same

Qualitative and quantitative justification, 1.  Maggie Company produces a l...

1.  Maggie Company produces a light fixture with the following unit costs:   Direct Materials: $2 Direct Labour: $2 Variable Cost: $3 Fixed Cost: $2 UNIT TOTAL COST: $9   The

Explain how might you use quality tools to determine, a) Determine the valu...

a) Determine the value of the p-bar, the mean fraction defective. Then determine the control limits for the p-chart using 99.73% confidence level (3 standard deviations). Is this p

Explain barriers to advancement opportunities for women, What are some of t...

What are some of the barriers to advancement opportunities for women and minorities in many organizations?

Explain ethnocentric, Select an MNE with which you are familiar and determi...

Select an MNE with which you are familiar and determine which staffing approach (ethnocentric, polycentric, geocentric, or regiocentric) would be most beneficial to that enterprise

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