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 management techniques, Provide two examples of current leaders and ...

Provide two examples of current leaders and describe how they demonstrate their leadership characteristics. What separates these characteristics from management techniques? How eff

Explain evaluation or rewards systems a source of conflict, How are differe...

How are different evaluation or rewards systems a source of conflict?

LINE BALANCING, WHAT DO YOU UNDERSTAND BY LINE BALANCING

WHAT DO YOU UNDERSTAND BY LINE BALANCING

Describe confidence interval calculator, Practical Application Scenario ...

Practical Application Scenario To complete this scenario, use the Confidence Interval Calculator and the Area Gas Prices %u2013 Random Sample documents, provided in the Resource

Describe why it is both a business pressure, Explain why IT is both a busin...

Explain why IT is both a business pressure and an enabler of response activities that counter business pressures?

Explain risk assessment methodologies, Discussion 1- Thinking about any act...

Discussion 1- Thinking about any activity that you engage in that involves risk, developed a risk management plan for that activity. Discussion 2- Compare and contrast the follo

Explain work is a combination of precision machining, Layout Homework Probl...

Layout Homework Problems 6. Avalanche, Inc. is a manufacturer of premium snow skis. The work is a combination of precision machining and skilled craftsmanship. Before completion, s

Explain organization''s strategic direction, Why should HPT Practitioners c...

Why should HPT Practitioners care about the organization's strategic direction?

Describe i am trying but it said that is an error on the sys, I lost my ren...

I lost my rental book and I need to pay for it and I am trying but it said that is an error on the system and I can't pay for it, can you help me to figure this out please.

Explain marketing is considered both an art and a science, Marketing is con...

Marketing is considered both an art and a science. How do the 4Ps, or marketing mix, help us bridge the gap between art and science? a. Marketing is about advertising.

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