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 city water supply system, The network in figure below shows the pip...

The network in figure below shows the pipeline transportation system for treated water from the treatment plant (node 1) to a city water supply system (node 14). The arc capacities

Compute the reorder point, The Norwitch Company uses a continuous review (s...

The Norwitch Company uses a continuous review (s, Q) system for inventory control.  Weekly demand for an item, Pressure Valve #5 (PV5), is distributed Normally with a mean and stan

After working for 30 years, In the table given below the Distribution Manag...

In the table given below the Distribution Manager is expected to service these DCs as per the demands placed. If the actual sales after completing week one is as follows, what woul

Models, under which topic in operations management are models found?

under which topic in operations management are models found?

How to increase customer satisfaction, Question: (a) Show how supply ch...

Question: (a) Show how supply chains can be managed more effectively to provide more effective service delivery in order to increase customer satisfaction, while also increasin

What are some new products organizational markets, What are some new produc...

What are some new products I could use that serve two business (organizational) markets?

Attitudes as well bargaining behaviours of the participants, Do you think t...

Do you think the attitudes and bargaining behaviours of the participants in collective bargaining negotiations are more or less important in the final outcome than economic conditi

Explain the scope overview and business case sections, The scope overview a...

The scope overview and business case sections of the project charter provide the high-level "what and why" of the project A. TRUE B. FALSE

Explain diversified network, USAA, which provides financial services to mil...

USAA, which provides financial services to military officers by mail and telephone, is an example of a Answer focused service. Focused network. Clustered service. Diversified netwo

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