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 what ethical considerations your response, Please explain in detail...

Please explain in detail what you would do for the following scenario: A good friend of yours from college who had a wild reputation is applying at your company. The HR manager cat

Compute the value of the tax shield that the cost-depletion, You have a lea...

You have a lease on an oil and gas property with 87.5% NRI that delivers your firm annual profits of $400,000 for five years, with equal production in each year (you will need to t

Describe management implications of information technology, Briefly explain...

Briefly explain the management implications of information technology

Determine the sample size, An element of work has been measured 6 times, wi...

An element of work has been measured 6 times, with the following results (units of 0.01 minutes): 18, 20, 19, 21, 19, 22. What should be the full-study sample size?

What does acknowledging sources involve, What does acknowledging sources in...

What does acknowledging sources involve? Sources of information and the ideas of others that you use in your assignments, research and class activities may include books, journa

Explain what are these other agency relationships, As a top executive, the ...

As a top executive, the only agency relationship I am concerned about is the one between myself and the firms owners. I think that it would be a waste of my time and energy to worr

Explain criminal prosecutions hurt innocent shareholders, Respondeat superi...

Respondeat superior is the theoretical basis for holding companies criminally liable for actions of their employees. Companies oftentimes have little defense against prosecution. C

Benefits of effective operations management, what are the benefits of effec...

what are the benefits of effective operations management. Discuss.

Illustrate example of queuing theory in operation management, Illustrate th...

Illustrate the examples of the queuing theory in operation management? Example of Queuing theory, a mathematical study of the formation of waiting queues or lines (physical or

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

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