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 when communicating a change, When communicating a change, which rol...

When communicating a change, which role is more important: reporter of information or sense maker? Why

Explain risks to a broad generic business strategy, What are some drawbacks...

What are some drawbacks and risks to a broad generic business strategy? To a focused strategy?

Explain work study as a management tool, Explain work study as a management...

Explain work study as a management tool. Work Study as a Management Tool: Work study checks the work done in an organization and this aims at finding the best and most effici

Difference between classical and neo-classicaal theory, Explain d ifferenc...

Explain d ifference between Classical Theory and Neo-Classical Theory of Organisation. Difference between Classical Theory and Neo-Classical Theory of Organisation : The c

Explain how the ebq change if the set-up costs is reduced, How would the EB...

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

Explain current trends in the health care industry, How might a universal h...

How might a universal health insurance program change the current trends in the health care industry? In your opinion, are programs like that offered by Aetna to have surgery condu

Explain risk prevention strategies, Risk prevention strategies should inclu...

Risk prevention strategies should include less detailed planning training static designs and traditional systems all of the above none of the above

Describe what are the different types of strategies, What are the different...

What are the different types of strategies? What are the differences among these strategies? How do you determine which type of strategy is most appropriate for your organization?

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