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

Business management, Six Operators are to be assigned to five jobs with the...

Six Operators are to be assigned to five jobs with the cost of assignment in Rs. given 10 marks in the matrix below. Determine the optimal assignment. Which operator will have no a

Explain flexible manufacturing system, Meile Machine Shop, Inc., has a 1-ye...

Meile Machine Shop, Inc., has a 1-year contract for the production of 225,000 gear housings for a new off-road vehicle. Owner Larry Meile hopes the contract will be extended and th

Explain what do you need to be a manager, What do you need to be a manager?...

What do you need to be a manager? What is the most difficult?

E - business or e-commerce, E - Business or E-Commerce E-commerce (usu...

E - Business or E-Commerce E-commerce (usually referred to by the more encompassing term 'e-business') is few suppliers? defined by IBM's Lou Gestner as being about: Verticall

Discuss how various legal-political-economic system, Discuss how various le...

Discuss how various legal, political, economic, and cultural systems may affect the brokering of a relationship with international partners.

Computer intagration, impact of computer integration in operation managemen...

impact of computer integration in operation management

Explain how does a company''s vision and plans affect, How does a company's...

How does a company's vision & plans affect its structure?

Vertically integrated or virtual organisation, Vertically Integrated or Vir...

Vertically Integrated or Virtual Organisation An organisation might decide not to source goods or services externally but to own the supplier company itself. For instance a

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