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 do the results of the questionnaire suggest, How do you react...

How do you react to conflict? Do you have a typical style as a leader when dealing with a conflict situation? Complete the Conflict Style Questionnaire. What do the results of the

Scrutinise the process sequences and calculate annual cost, Scrutinise the ...

Scrutinise the Process Sequences and Calculate Annual Cost A company produces a range of product, but the dominant demand is for three of them, A, B and C. The table shows the

Explain contract formation process that he now faces, You are currently an ...

You are currently an intern working for the largest law firm in Alabama. Your mentor and senior attorney introduces you to a new client, Dick Jefferson, the owner of House Doctor,

What is global warming, Global warming is a topic that has been on the news...

Global warming is a topic that has been on the news. In your own words, do you believe that there really is an environmental crisis or do you believe that there is "hype" to create

Contrast the code of ethics of both starbucks and mcdonalds, Analyze, compa...

Analyze, compare and contrast the code of ethics of both Starbuck's and McDonald's.

Explain inefficiency factor, A JIT system uses kanban cards to authorize mo...

A JIT system uses kanban cards to authorize movement of incoming parts. In one portion of the system, a work center uses an average of 93 parts per hour while running. The manager

Explain successful firms conduct marketing research, Why do successful firm...

Why do successful firms conduct marketing research for their products/services?

Logistics alliances for initiation and maintenance, What are the major cons...

What are the major considerations regarding logistics alliances, for: a) initiation? b) implementation? c) maintenance? d) termination?

Discuss entrepreneurship is more mundane, INC.. magazine claims, "Entrepren...

INC.. magazine claims, "Entrepreneurship is more mundane than it is sometimes portrayed . . . you don't need to be a person of mythical proportions to be very, very successful in b

Explain understanding of human behaviour, Explain understanding of human be...

Explain understanding of human behaviour. Understanding of Human Behaviour: Understanding human behaviour is significant for any one dealing along with human resources. This

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