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 communication behaviours destroy trust, One of the most important f...

One of the most important factors determining whether organizations and their members will be high performance is the presence of trust between leaders and followers. What types of

Explain what organizations currently utilize six sigma, What is Six Sigma? ...

What is Six Sigma? Who started it? What organizations currently utilize Six Sigma

Explain opportunity costs of capital at tep, How would the EBQ change if th...

How would the EBQ change if the set-up costs were reduced by 50 percent, and the holding costs were reassessed by 40 percent, taking account of the opportunity costs of capital at

Production control function, Production control Function 1. Dispatchi...

Production control Function 1. Dispatching : Dispatching may be  defined as setting  production activities in motion through  the  release  of orders ( work order shop order)

Explain sources of power and any contingencies of power, 1. Does Clark have...

1. Does Clark have any sources of power and any contingencies of power? If so, list and discuss them. 2. To what degree were Clark's methods of influencing board members the most e

Why is this an vital concern for all businesses today, 1)What should you do...

1)What should you do after the fact when your company's information security has been breached? 2)what can you do to protect your company's data from unauthorized access? 3)W

Would like for you to advice changes that would significant, Your boss woul...

Your boss would like for you to suggest changes that would significant shorten it. what would you suggest?

Explain how much would land''s end buy, (Land's End) Geoff Gullo owns a sma...

(Land's End) Geoff Gullo owns a small firm that manufactures 'Gullo Sunglasses'. He has the opportunity to sell a particular seasonal model to Land's End. Geoff offers Land's End

Principle of scheduling, Principle of Scheduling First Principle optim...

Principle of Scheduling First Principle optimum Task Size : scheduling tens to achieve its maximum efficient task sizes are small and all tasks are of the same order of magnit

Discuss how the role of human resources as a strategic, The field of human ...

The field of human resources is evolving from providing services to an organization to becoming a strategic partner in its growth. Analyze and discuss how the role of human resourc

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