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 null and alternative hypotheses to be tested, TRUE or FALSE. The Se...

TRUE or FALSE. The Sergio Lumber Company manufacturers plywood. One step in the process is the one where the veneer is dried by passing through a huge dryer (similar to an oven) wh

Explain managerial problem solving discuss the pitfalls, Using managerial p...

Using managerial problem solving discuss the pitfalls of satisficing and escalation of commitment

Regional regulations and room of expansion, Regional Regulations and Room o...

Regional Regulations and Room of Expansion Regional Regulations: It is important to check at an early stage that the proposed location does not infringe any local regulat

Describe the actual demand for the patients, The actual demand for the pati...

The actual demand for the patients at Omaha Emergency Medical Clinic for the first six weeks of this year are as follows: Week Actual # of Patients 1 65 2 62 3 70 4 48 5 63 6 52

Customisation - service process matrix, Customisation - Service Process Mat...

Customisation - Service Process Matrix Customisation reflects the degree to which the service provided is tailored to the needs of the customer. Organisations which have a hig

Evolution of operation managment, explain the evolution of operation manage...

explain the evolution of operation management highlighting the key stage of development taken place in the operation management practices in modern day organization

Explain the quantitative, 1.   Explain the quantitative foundation of Six S...

1.   Explain the quantitative foundation of Six Sigma, and discuss how following the phases of the DMAIC improvement lifecycle ensures that the quantitative aspect of the approach

Describe set up more responsible governance, You are consulting with a comp...

You are consulting with a company that is failing. It seems the CEO (recently fired) paid no attention to the board of directors. He was also heard to say, "I don't serve stockhold

List the type of business you are managing, Our text defines the four funct...

Our text defines the four functions of a management as Planning, Organizing, Leading and Controlling. Briefly put, the plan states the desired outcome or goal and the process for

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