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

What are the terminal course objectives, Class, looking back over the Termi...

Class, looking back over the Terminal Course Objectives for this course, what are you looking forward to learning more about throughout your education and career?

Explain technology meets the requisite market potential, Pharma Blitz devel...

Pharma Blitz develops and markets new technological products to be used in health care. The development of a new product operates as follows. When a new technology meets the requis

Explain trial balance, Explain Trial Balance. Trial Balance : After po...

Explain Trial Balance. Trial Balance : After posting all journal entries in the ledger, a statement termed as trial balance is prepared to check the accuracy of postings in th

Process technology, Explain how process technology is chosen for an operati...

Explain how process technology is chosen for an operation.

Explain strategic analysis, Strategic analysis is an important first step i...

Strategic analysis is an important first step in setting strategic direction

How managers use queuing models in decision making process, Problem : D...

Problem : Describe how managers may use Queuing Models in the decision making process. Consider there is only one photocopy machine in your organisation. On a typical day, a

Responsibilities of operation manager, Operations Management Activities - R...

Operations Management Activities - Responsibilities of Operations Managers The nature and responsibility of operations managers is changing. Once operations or production mana

What are generally accepted accounting principles, Yvon, an accountant, is ...

Yvon, an accountant, is charged with negligence by Zesty Sauce, Inc., a client. Yvon may successfully defend against the claim if she can show that (Points : 2) scienter was lackin

What are strategies for creating an open environment, 1 Develop an ld score...

1 Develop an ld score for the current layout. What problems can you identify with the current layout? 2. Use trial and error to come up with a better layout that lowers the ld s

Appropriate control limits for the data, A quality team at Milburn Textiles...

A quality team at Milburn Textiles has been charged with setting up control charts to monitor a key dyeing process that has been improved and now stable.  The ideal temperature for

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