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 buckroe beach virginia illegal, Buckroe Beach Virginia illegal put ...

Buckroe Beach Virginia illegal put what in someone's swimsuit

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

Describe what is the workstation cycle time, Some tasks and the order in wh...

Some tasks and the order in which they must be performed according to their assembly requirements are shown in the following table. These re to be combined into workstations to cre

Explain panel interviewing and its strengths and weaknesses, You're going t...

You're going to have to stretch your imagination for this question:. Assume you're involved in a panel interview team. Identify one strength and one weakness in this interview appr

Explain the company is expected to maintain growth rate, The Lo Tech Co. ju...

The Lo Tech Co. just issued a dividend of $2.30 per share on its common stock. The company is expected to maintain a constant 7 percent growth rate in its dividends indefinitely.

Explain smells of alcohol, You have a new employee who is in his/her probat...

You have a new employee who is in his/her probationary period, the first 90 days of employment. The employee has missed several days of work and has been late at least two days thi

Playground explained in this case study, What does the concept of interacti...

What does the concept of interactive design mean for a service such as the adventure playground described in this case study?

Explain first-line supervisor understand the organization, Why should a fir...

Why should a first-line supervisor understand the organization's objectives?

Explain management retreat at a regional casino, Please explain in detail w...

Please explain in detail what you would do for the following scenario: You have just finished laying off 25 people because of a need to cut costs. You are then invited to a managem

Explain counteract prejudice, Counteracting Prejudice One of the simplest a...

Counteracting Prejudice One of the simplest and most powerful ways to counteract prejudice and discrimination is to articulate and share stereotypes and preconceived notions. How c

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