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 are the privacy requirements under hipaa, What are the privacy...

What are the privacy requirements under HIPAA? Explain why confidentiality of health information has been a controversial public policy issue. Give a real world example. How can he

Explain the strategic supply wheel according to cousins, Q. Explain the str...

Q. Explain the strategic supply wheel according to Cousins? The 'strategic supply wheel' suggests that this is imperative to keep an alignment of corporate goals along with the

Siting departments for process layout - manufacturing, Siting Departments f...

Siting Departments for Process Layout - Manufacturing One of the most significant features of the siting of departments in a process layout is its surprising complexity. Even

Explain how can the hrm professional be prepared to deal, How can the HRM p...

How can the HRM professional be prepared to deal with the variations in HR practices in the global environment

How a roofing company considered socially responsible, A roofing company ag...

A roofing company agreed to complete a job in one week and collected a 50 percent deposit, but never showed up to do the job. The same roofing company then donated $6,000 to a loca

Case study, what is continuous improvements

what is continuous improvements

Explain needed for good information literacy, 1. In two or three sentences,...

1. In two or three sentences, please summarize what you have learned about information literacy so far in your earlier courses and in this seminar. 2. Then explain how informati

Explain bebts, Champ Sports Corporation buys the assets of Delta Athletic C...

Champ Sports Corporation buys the assets of Delta Athletic Corporation. Champ continues Delta's business and retains the same personnel. Is Champ liable for Delta's debts?

Business organisation functions, ''OPERATIONS MANAGEMENT IS THE CENTRAL TO ...

''OPERATIONS MANAGEMENT IS THE CENTRAL TO THE FUNCTIONING OF ALL BUSINESS ORGANISATIONS''.with reference to the organisation of your choice discuss this statement highlighting how

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