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

Define how team building interventions help an organization, Discuss how te...

Discuss how team building interventions help an organization. Describe activities that are relevant to individuals, the group and organization relationships.

Explain christian ethical position, The approach of utilitarianism is rathe...

The approach of utilitarianism is rather democratic in that it suggest that greatest good or happiness is for the greatest number. It does provide the student with the prospect tha

Explain health care compensation practices, Health Care Compensation Practi...

Health Care Compensation Practices Please respond to the following- • Analyze the pros and cons of the different health care compensation approaches and philosophies and determi

Two handed process chart and multiple activity charts, Two Handed Process C...

Two Handed Process Chart and Multiple Activity Charts Two-handed process chart  For fixed-position manual processes such as the assembly of small devices, this type of ch

Explain treatment of mental illness in the medical model, Compare the treat...

Compare the treatment of mental illness in the medical model, the public health model, and the human service model. Which model provides the best treatment or approach in your opin

Organizational goals, outline major benefits of organizational goals and d...

outline major benefits of organizational goals and describe the situation in which have observe the benefiys

What options are open to coral to address this issue, Read Space Age Furnit...

Read Space Age Furniture Company in Chapter 9 of your text. Answer the following seven questions: (Include any MRP calculations). • What options are open to Coral to address th

What are the relevant costs involved, Process Solutions provides a computer...

Process Solutions provides a computer-based document processing service. The accountant has produced the following analysis.   Standard Modifi

Describe what is the value creation frontier, 1. What is the value creation...

1. What is the value creation frontier? How does each of the four generic business models allow a company to reach this frontier? 2. How can companies' pursuing cost leadership

What are the receipts handling in the purchasing department, Q. What are th...

Q. What are the receipts handling in the purchasing department? Receipts handling: It is the responsibility of the purchasing department: a.     Shipping and transport manag

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