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 affirmative action plan requiring it to hire a woman, 1 In Johnson ...

1 In Johnson v. Transportation Agency, Santa Clara County, a female employee was promoted to the position of road dispatcher, despite the fact that a male candidate had scored two

Clean systems disimillar from traditional production systems, Explain how l...

Explain how lean systems differ from traditional production systems?

Explain switching methods, Which of the following switching methods is fast...

Which of the following switching methods is faster? A. cut-through mode B. source-route C.store and forward D. translational

Explain establishing team operating principles, Team operating principles a...

Team operating principles are sometimes included in a project charter to enhance team functioning. Which of the following statements accurately describes the value of establishing

Explain significant differences between x.25 and frame relay, Name two sign...

Name two significant differences between X.25 and frame relay?

Control chart - sample mean chart & sample range chart, Control Chart - Sam...

Control Chart - Sample Mean Chart & Sample Range Chart As sample values are progressively plotted on the charts, they are examined for patterns which may be tested against a s

Increasing pace of change - service operations management, Increasing Pace ...

Increasing Pace of Change - Service Operations Management The establishment of service operations management. Total quality management (TQM) widely adopted, ISO 9000, theory o

Why the production manager is asked to reduce the safety, The annual demand...

The annual demand for a product is 15,600 units. The weekly demand is 300 units with a standard deviation of 90 units. The cost to place an order is $31.20, and the time from order

Explain major reasons why companies adopt total quality, Discuss the three ...

Discuss the three major reasons why companies adopt total quality. Also, discuss the initial key steps are involved in the adoption process.

Explain industrial products and consumer products, Compare and contrast ind...

Compare and contrast industrial products and consumer products

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