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 what the term data redundancy means, Describe what the term "data r...

Describe what the term "data redundancy" means in database design. Explain if it is bad and if a normalized database design is always the best design. Discuss the pros and cons of

Explain maintaining both individual and team identity, What are some of the...

What are some of the challenges inherent in maintaining both individual and team identity? Please provide real world examples.

Describe writing process to produce quality documents, Explain your persona...

Explain your personal writing process. What has worked for you in your effort to produce quality documents? What is your biggest writing challenge?

Explain strategic and budgetary decisions, Identify and discuss factors tha...

Identify and discuss factors that can increase the size and complexity of the information system structure (beyond those discussed in the text). •Make at least three recommendation

Trade off between delivery and flexibility, Trade off Between Delivery and ...

Trade off Between Delivery and Flexibility Pagell et al (2000) argue that the trade-off concept is based on Skinner's quandary that a manufacturing plant could not be configur

Order qualifiers - operations strategy, Order Qualifiers - Operations Strat...

Order Qualifiers - Operations Strategy These are not essential to winning business in their own right. They may however, determine the entry level whereby the organisation is

Explain golden rules apply to all projects, Consider how these 10 Golden Ru...

Consider how these 10 Golden Rules apply to all projects and apply three of them to your project.

Explain allocated cells a balanced transportation model, The number of allo...

The number of allocated cells a balanced transportation model with 3 sources and 3 destinations should have in order NOT to be degenerate is

Explain unethical behaviour proposed by saul gellerman, Of the four commonl...

Of the four commonly held rationalizations for unethical behaviour proposed by Saul Gellerman, which one do you thing gets use most often? Why?

Describe a metaheuristic of your choosing to your grandma, Because of the c...

Because of the complexity of scheduling problems, we discussed that met heuristics are a common approach to solving scheduling problems in practice. a. Create a visual graphic

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