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

What is an e-r diagram, Conceptual Modeling looks at how the data is struct...

Conceptual Modeling looks at how the data is structured and what the characteristics of the data are. What characteristics of data are represented in an E-R diagram?

Explain investment spending sharply declined in the us, In early 2001, inve...

In early 2001, investment spending sharply declined in the U.S.. In the two months following the Sept. 11, 2001 attacks on the U.S., consumption also declined. Use AD-AS analysis t

Describe the term orginizational culture, Define the term orginizational cu...

Define the term orginizational culture. How might this company information enhance a sales presentation?

What are individual and group decisions, What are individual and group deci...

What are individual and group decisions? Individual decisions are taken through a single individual in context of routine decisions whether guidelines are already given. Group

Significance of designing for profit in product development, Discuss the im...

Discuss the importance of designing for profit in product development. What happens when there is distortion in these goals?

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

OR, Explain OR Models

Explain OR Models

Discuss implications for leadership, Implications for leadership and a lead...

Implications for leadership and a leader's relationship with follower

Procedure of production planning, Procedure of Production Planning 1. ...

Procedure of Production Planning 1. Production Material: The  information is  derived  from an analysis  for the production  into its  separate components  and units  to det

Explain benefits and variable pay, Benefits and Variable Pay Please respond...

Benefits and Variable Pay Please respond to the following- • Analyze the types of benefits usually available in the health care industry and determine which benefits are most im

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