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 identify the basic control issues at unilever, Identify the basic c...

Identify the basic control issues at Unilever from all three levels? How do you think the control function should be organized and managed at Unilever?

Explain proposed investment in the warehouse extension, What overall recomm...

What overall recommendations would you make to Francis Lamouche about the proposed investment in the warehouse extension?

Explain damage and restrict water access, Please explain how you would hand...

Please explain how you would handle the following question: An environmental impact statement confirms that you are within your legal rights to build a hotel property in a scenic a

Explain projected return on the owner''s equity investment, Carter Dalton i...

Carter Dalton is well on his way to starting a new venture-- Max, Inc. He has projected a need for $350,000 in initial capital. He plans to invest $150,000 himself and either borro

Explain project implementation and communication strategy, Of all the discu...

Of all the discussions and assignments provided in this course, evaluate how Project proposal, project implementation and communication strategy might specifically support your abi

Systems approach to process planning and design, Systems Approach to Proces...

Systems Approach to Process Planning and Design Knowledge about operations strategies, product / service designs, technologies of the production system, and markets are used t

Explain relationship between business and society, Describe two forces that...

Describe two forces that you believe shape the relationship between business and society. Provide two examples (one for each force you choose). Look for flaws and strengths in spec

Define how the data resource management methods need, Discuss how the data ...

Discuss how the data resource management methods of today will need to evolve as more types of data emerge. Why the role of a data steward is considered innovative? Explain.

Explain guidelines on discrimination national origin, 2. Inez Garcia was bo...

2. Inez Garcia was born in Portland, Oregon. Her mother is from Italy and Jewish. Her father is Mexican. Under the Guidelines on Discrimination Because of Religion or National Orig

Explain how you would work to make it a effective policy, Discuss an ineffe...

Discuss an ineffective health-care policy that you personally experienced in your practice, and describe the issues that you feel made it unsuccessful. Using instrumentalism as the

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