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

Performance prism - performance and productivity measures, Performance Pris...

Performance Prism - Performance and Productivity Measures Neely and Adams (2000) argue that in their recent research managers and academics highlight the need for a fresh pers

Travel chart, #questionI want some project of travel chart ..

#questionI want some project of travel chart ..

Describe what is role of a cio in todays global business, 1. What is the ro...

1. What is the role of a CIO in today's global business environment? 2. Dr. Carr presents a good argument in the "IT doesn't matter" reading. Present your view of Carr's central

Determine the overall project completion time, Question : (a) Under wha...

Question : (a) Under what conditions is PERT preferred to CPM in project management ? Illustrate your answer with examples of projects. (b) Several stages are involved in

Operation strategy for non profit organization, what should be the operatio...

what should be the operation strategy for non profit business?

What kind of financial ratio might provide insight, Mary Ann has always lov...

Mary Ann has always loved to cook and is interested in starting a catering business. Being aware of the failure rate of new businesses, she is considering buying an existing cateri

Explain vision statement and a mission statement, Should organizations have...

Should organizations have both a vision statement and a mission statement? If you were to lead an organization and you could have only one, a mission or vision statement, which wou

Define elements of finagle a bagels operating system, Now, please answer th...

Now, please answer the question regarding operations management. How would you describe the elements of Finagle a Bagels operating system?

After working for 30 years, After working for 30 years, Ramjee Somjee Dutt ...

After working for 30 years, Ramjee Somjee Dutt opted for VRS and started a courier company and did very well in the first four years. He was now looking for expansion of his busine

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