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 is the horizon value, Current and projected cash flows for Ran...

Current and projected cash flows for Randell Global Operatons are shown below. Growth is expected to be constant after 2012, and the weighted average cost of capital is 11%. What i

Explain advantages and disadvantages of membership, Define the use of regio...

Define the use of regional trade organizations in international business. Identify the Regional Trade Organization of which the United States is a member. What are some of the adva

Oprations process design, what is operation process design ? what are the i...

what is operation process design ? what are the important factors that effect a process design

Operations layout systems, After completing your program in the University,...

After completing your program in the University, you would want to establish your own business. Relate your choice of business to any of the types of operation layout systems

Explain product focused, 1. What are the key characteristics that would cla...

1. What are the key characteristics that would classify Wheeled Coach as a repetitive focus process strategy? 2. Let's assume you are a new hire at Wheeled Coach. Your manager a

Explain making better business decision, Making Better Business Decision: D...

Making Better Business Decision: Do you provide the quizzes/exams questions for this book?

Describe concept of the internal customer, Discuss the concept of the inter...

Discuss the concept of the internal customer. Who are purchasing's internal customers?

Key issues when implementing an erp system, 1. Discuss how you interpret th...

1. Discuss how you interpret the statement 'ERP is the 'meat and potatoes' of the organisation'.  2. What are the key issues when implementing an ERP system?  3. How will tra

Explain was any sexual harassment involved in this situation, Was any sexua...

Was any sexual harassment involved in this situation? If so what kind was it?

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