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 recommendations would you make and why, 1. Draw a process flow...

1. Draw a process flow diagram of the process described in the case. Be sure to identify the key resources involved and the task times at each step. 2. What is utilization at ea

Explain what would be your total cost, A manufacturing firm is considering ...

A manufacturing firm is considering two locations for a plant to produce a new product. The two locations have fixed and variable costs as follows: Site Fixed Cost (Annual) Variabl

Explain why is it important to develop their products, Why is it important ...

Why is it important to develop their products/services marketing plan in writing?

Describe trade-offs between the competitive dimensions, In your organizatio...

In your organization, describe how there are trade-offs between the competitive dimensions. Give examples.

How managing and using performance data, Identify three aspects of managing...

Identify three aspects of managing and using performance data so that it is useful to the organization. Provide an example of each aspect. Be specific in your response.

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

Describe schedule of matches for the couples, Chris Lane, the head professi...

Chris Lane, the head professional at Royal Oak Country club, must develop a schedule of matches for the couples' golf league that begins its season at 4PM tomorrow. Eighteen couple

Explain charlotte inventory levels, L. Houts Plastics is a large manufactur...

L. Houts Plastics is a large manufacturer of injection moulded plastics in North Carolina. An investigation of the company's manufacturing facility in Charlotte yields the informat

Explain distinction between feasibility and acceptability, Remind yourself ...

Remind yourself of the distinction between feasibility, acceptability and vulnerability discussed. Evaluate both technologies using these criteria.

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