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

How to use the virtual organization link on the student, Resources: Univers...

Resources: University Library, Kudler Fine Foods Virtual Organization Use the Virtual Organization link on the student website to access additional company information on Kudler

Explain what is the difference among lead time and lag time, Remember that ...

Remember that once you start linking tasks in the Gantt chart, changes might become more cumbersome. What are some tools or techniques that you can use to save yourself some hea

How can controlling asist a manager to become more efficient, How can contr...

How can controlling help a manager to become more efficient?

Explain what is the contribution ratio, Foster Company makes power tools. T...

Foster Company makes power tools. The budgeted sales are $420,000, budgeted variable costs are $147,000, and budgeted fixed costs are $227,500. What is the budgeted operating in

Explain why should be performed before signing a contract, What due diligen...

What due diligence should be performed before signing a contract?

Describe potential key changes in communications, Discuss potential key cha...

Discuss potential key changes in technology, communications, and competition that Sigma will face in the future. Which will have the most impact on Sigma%u2019s future marketing st

Productivity in the service sector, Productivity in the Service Sector ...

Productivity in the Service Sector We know that the challenges for operations managers in future will lie in increasing the productivity of the service sector. As agriculture

Explain benefits of free international trade, What are the benefits and dis...

What are the benefits and disadvantages of free international trade for the United States? Examples would be helpful also.

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