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 consumer products into brazil, What steps could a company take to a...

What steps could a company take to avoid making product design and marketing mistakes when introducing new consumer products into Brazil?

Explain various health care plans, The first step in the Model of Scientifi...

The first step in the Model of Scientific Inquiry is to identify the question or problem needing further study. The following seven situations are typical everyday problems in busi

Linear programming, Premier coatings Zambia ‘PCZ’ produce both interior and...

Premier coatings Zambia ‘PCZ’ produce both interior and exterior paints from two raw materials, Ml and M2. A market survey indicates that the daily demand for interior paint cannot

Explain what does the project portfolio illustrate, What does the project p...

What does the project portfolio illustrate? How might it be useful to management?

Explain what additional facts could cause the decision, Ema graduated from ...

Ema graduated from a very prestigious college and was in her second year of medical school. Ema's parents did not have the resources to help her pay for college. For the past six y

Imagine this is the only position of its kind organization, Imagine this is...

Imagine this is the only position of its kind in the organization. From this perspective, design a performance appraisal program to assess your job performance.

Find estimated costs for each of the three product, Madden Industries manuf...

Madden Industries manufactures three models of a product in a single plant with two departments cutting and assembly. The company has estimated costs for each of the three product

Examples of variations - operations function, Examples of Variations - Oper...

Examples of Variations - Operations Function Volume                                                                                                 Low: Small quantities

Explain what effective leadership means, Describe what effective leadership...

Describe what effective leadership means to you. Who determines a leader's effectiveness? Provide details and examples to support your thoughts.

Types of benchmarking, Briefly discuss benchmarking as process improvement ...

Briefly discuss benchmarking as process improvement tool. Explain six types of benchmarking and give four reasons why some businesses have failed to derive maximum benefit from it.

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