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

Advantages of process layout, Advantages of Process Layout Lower C...

Advantages of Process Layout Lower Capital Investment : Less capital is needed for this layout because production apparatus is applied to maximum capacity with minimum dup

Leadership evaluation and leadership philosophy, Write an evaluation (500-7...

Write an evaluation (500-750 words) of the situation that addresses the following: The power bases used by the leader. The influence tactics used by the leader. The leadership sty

Explain estimating the mean height of a sample of seedlings, A biologist re...

A biologist reports a confidence interval of (2.0,2.4) when estimating the mean height (in centimetres) of a sample of seedlings. What is the estimated margin of error and the samp

Introduction, what is production and operation management?

what is production and operation management?

Explain expects to perform the modifications to vehicles, Honda Motor Compa...

Honda Motor Company has discovered a problem in the exhaust system of one of its automobile lines and has voluntarily agreed to make the necessary modifications to conform with gov

Explain what is the efficiency process, An assembly line currently has five...

An assembly line currently has five workstations and the time required for each is shown below 1. 42sec 2. 49 sec. 3. 32 sec. 4. 47 sec. 5. 42 sec. What is the efficiency process?

Explain intangible assets and human capital, Companies are now more and mor...

Companies are now more and more interested in using intangible assets and human capital as a way to gain an advantage over competitors. True False

Explain the four colour problem, The Four Colour Problem. Is it true that t...

The Four Colour Problem. Is it true that the countries on any given map can be coloured with four or fewer colours in such a way that adjacent countries are coloured differently?

Explain performance appraisal, Explain Performance Appraisal. It is a s...

Explain Performance Appraisal. It is a systematic and impartial assessment of an employee's performance on the assigned job, along with a view to discovering how well or worse

Explain what protocols should be considered, What protocols, if any, should...

What protocols, if any, should be considered in this needs assessment?

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