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 contract governed by common law or the ucc, The paper must be four ...

The paper must be four to five pages excluding title page and reference pages, following APA format. Address all of the following parts of this assignment: Suppose that the F

Explain what are the internal and external factors, What are the internal a...

What are the internal and external factors (HR/Business) that will affect the global organization today when doing business overseas

Case study, Bloomsday Outfitters produces T-shirts for road races. They nee...

Bloomsday Outfitters produces T-shirts for road races. They need to acquire some new stamping machines to produce 30,000 good T-shirts per month. Their plant operates 200 hours per

Explain the specific human resources concerns, Describe the specific human ...

Describe the specific human resources concerns (competencies, labour economics, legal & regulatory systems, labour relations & unionization, and cultural norms) for one chosen coun

Which factors influence the choice of evaluation design, What factors influ...

What factors influence the choice of evaluation design? Which of these factors would have the greatest influence on your choice of an evaluation design? Which would have the smalle

Explain balogun and hailey change model, This post should be at least 200 w...

This post should be at least 200 words in length. Select one of the following approaches to understanding or implementing organizational change. Summarize this approach. Provide

Outsourcing, determine whether outsourcing of the particular manufacturing ...

determine whether outsourcing of the particular manufacturing operation makes financial sense

Explain does anyone have any insight, Does anyone have any insight into Dis...

Does anyone have any insight into Discussion Question, This was not discussed in class.

Explain ethical for employers to use information technologie, Is it ethical...

Is it ethical for employers to use information technologies to extend work into employees home lives?

Soucing, advantages and disadvantages of parallel sourcing

advantages and disadvantages of parallel sourcing

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