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 a set of circumstances consider disciplinary action, Describe a set...

Describe a set of circumstances under which you might legitimately consider disciplinary action for a chronic complainer.

Explain the most likely outcome of leon''s lawsuit and why, Leon, a bank v...

Leon, a bank vice president, joined Fitness Center, Inc. (FC). He signed a contract for the membership. The contract stated, among other things, an exculpatory clause that FC.

Explain the utilization and the efficiency of each situation, Determine the...

Determine the utilization and the efficiency for each of these situations: a. A loan processing operation that processes an average of 7 loans per day. The operation has a design c

Supply chain, to what extent is SCM applicable to a service operation

to what extent is SCM applicable to a service operation

Advantages of the enterprise-wide systems, Q. What are the advantages of th...

Q. What are the advantages of the enterprise-wide systems? Benefits of Enterprise-wide systems (ERP) systems: a. In this system integration of software applications can easi

Compute the cost per hire for the scenario, Calculate the cost per hire for...

Calculate the cost per hire for the following scenario. Show your calculation for partial credit. If you only provide one number, and it is incorrect, I will not know how close you

Explain the different stages of group development, Question 1: There is...

Question 1: There is no use in considering non-financial issues when motivating people as many consider that money is the prime and only motivating factor. Discuss this st

Explain how might you use quality tools to determine, a) Determine the valu...

a) Determine the value of the p-bar, the mean fraction defective. Then determine the control limits for the p-chart using 99.73% confidence level (3 standard deviations). Is this p

Current risk management, Ask question #Minimum 100 words accepted1. Outline...

Ask question #Minimum 100 words accepted1. Outline the purpose and key elements of current risk management standards

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