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

Describe what are the benefits of working for someone else, What are the be...

What are the benefits of working for someone else? What are the advantages of being part of a company or agency that is established? Explain. Reference/Cited

How much hours of production time would you schedule for x, Plans are being...

Plans are being made to produce a product that requires 40 minutes on Resource X and 30 minutes on resource Y. Assume that there is only one of each of these resources, and that ma

Siting departments for process layout - service operations, Siting Departme...

Siting Departments for Process Layout - Service Operations In determining the relative position of service departments the costs of movement may be less important than other,

Provide source of enlightenment to the problem, Assume you are the CFO of A...

Assume you are the CFO of ABC Corporation, a multi-state supplier of janitorial supplies. The CEO as just met with you and "suggested" your job might depend on your ability to hide

Explain about leadership styles, Question: (a) Write short notes on any...

Question: (a) Write short notes on any five leadership theories and on any three main leadership styles. (b) Your friend has just been appointed team leader at his place o

What are long-term, What are long-term, departmental and Non-Economic decis...

What are long-term, departmental and Non-Economic decisions? If long term decisions, the time period covered is long and the risk included is more. Departmental decisions rela

Explain the knowledge acquisition and application phase, Discuss the pros a...

Discuss the pros and cons of the major technologies used in: a. The knowledge creation and capture phase. b. The knowledge sharing and dissemination phase. c. The knowledge acquisi

Explain top of the line products and services, Alternative strategies and l...

Alternative strategies and long term objectives for Callaway Golf. Current strategies expansion into China and India, develop new market strategies for existing markets, reduce exp

Meaning and definition of production management, Meaning and Definition of ...

Meaning and Definition of Production Management Production management is a stream of management that is associated to the production function. Production might be termed to as th

Demerits of a phased system roll-out for bombardier, 1) In your opinion, ho...

1) In your opinion, how does the visioning phase of the Bombardier ERP project impact the rest of the project? 2) What organizational outcomes did Bombardier expect with a succe

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