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 damage and restrict water access, Please explain how you would hand...

Please explain how you would handle the following question: An environmental impact statement confirms that you are within your legal rights to build a hotel property in a scenic a

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

Explain procurement management, Which of the nine knowledge areas defined i...

Which of the nine knowledge areas defined in the Project Management Body of Knowledge includes the activities of generating, collecting, distributing, storing, retrieving and dispo

Value of a Loyal Customer (VLC), A manufacturer of business copier workstat...

A manufacturer of business copier workstations has a 75 percent customer retention rate. Their accounting department estimates the incremental contribution to profit and overhead

Generate a table that includes all of the key elements, Create a table that...

Create a table that includes all of the key elements that you think an organization must focus on to promote change

Explain supply chain risk management tools, Of the barriers to supplier dev...

Of the barriers to supplier development mentioned in this chapter, which ones, in your opinion, are the most difficult to overcome? 2. Describe the major sources of supply base ris

Explain global environmental concepts, Consider an international firm you a...

Consider an international firm you are familiar with, and consider what the firm needs to be concerned about when entering a foreign marketplace. Specifically, in terms of the chap

Compute the answers for the missing cells in the table, Process Analytics C...

Process Analytics Case let 1 Overview respond to this case let, which is based in a health care setting.. Preparation Read through the following case let. You are an operations man

Describe the differences between utilization and efficiency, Discuss the di...

Discuss the differences between utilization and efficiency as measures of system performance. Which (if any) is the most useful measure for an operations manager? Why?

Explain studies about individual voting decisions, Joan, age 40, is dissati...

Joan, age 40, is dissatisfied with her job. Martin, age 25, is satisfied with his job but thinks the union could provide better benefits beyond the associated costs. Most research

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