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

Tree diagram of activity sampling, Tree Diagram of Activity Sampling A...

Tree Diagram of Activity Sampling Activity sampling is not restricted to the binary condition (working/not working); if the sample is large, additional useful information may

Explain the proper marketing, Marketing strategy consists of selecting a se...

Marketing strategy consists of selecting a segment of the market as the company's target market and designing the proper marketing "mix" that meets the needs of that segment. Discu

Explain what is your assessment of the health of the project, On day 51, a ...

On day 51, a project has an earned value of $600, an actual cost of $650, and a planned cost of $560. Compute the SV, CV, and CPI for the project. What is your assessment of the he

Explain what do you think sally should do, Case 2 Individual or Team Reward...

Case 2 Individual or Team Reward? Jack Hopson has been making wood furniture for more than ten years. He recently joined Metropolitan Furniture and has some ideas for Sally Boston,

Explain what is the value of the coefficient, Forecasting 1. Briefly des...

Forecasting 1. Briefly describe when qualitative versus quantitative forecasting methods would be used? 2. Linear Regression. a. Describe what linear regression is and how

Explain employee involvement will improve decision making, As OB practition...

As OB practitioners we know that emotions form preferences before we consciously evaluate those choices and this impacts the quality of the decisions made at the company. The presi

Explain middle class population, Consider the table below. This time, the h...

Consider the table below. This time, the historical profitability of eight locations is listed in the table. Devise a regression equation and predict the profitability of a new sit

Describe independent populations where the variances, In order to test the ...

In order to test the difference in population's means, samples were collected for two independent populations where the variances are assumed equal and the population normally dist

Explain project layout, Give an example of a project layout. Describe the s...

Give an example of a project layout. Describe the site and how the environment is organized?

Calculate first''s rop, First printing has contracts with legal firms in Sa...

First printing has contracts with legal firms in San Francisco to copy their court documents. Daily demand is almost constant at 12,500 pages of documents. The lead time for paper

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