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

Circumstances is a code of ethics most as well least likely, Under what cir...

Under what circumstances is a code of ethics most and least likely to be effective? Why?

Explain the role of the board of directors for a corporation, What is the r...

What is the role of the Board of directors for a corporation

Explain what are the issues of management does google needs, What are the i...

What are the issues of management does Google strategy 2010 needs to address? How could they be analysed and evaluated?

Explain units of output per dollar of input, A hamburger factory produces 4...

A hamburger factory produces 40,000 hamburgers each week. The equipment used costs $5,000 and will remain productive for 4 years. The labor cost per year is $9,500. a. What is the

Describe the problems of homelessness, Explain the problems of homelessness...

Explain the problems of homelessness based upon the developmental, situational, and human needs perspectives, what make a person become homeless, when they are well educated and no

Organizing process flows, Organizing Process Flows Five types of proc...

Organizing Process Flows Five types of process are distinguished. They are Project Production System Job Shop Production system Batch Production system

Explain management differences have impacted the success, 1. Determine what...

1. Determine what other management differences have impacted the relative success of Kodak and Fujifilm. Provide specific examples to support your response. 2. Evaluate each com

Explain their mission and strategy, Navigate to www.aboutmcdonalds.com/mcd ...

Navigate to www.aboutmcdonalds.com/mcd and access the "Our Company" located in the top tool bar. Then navigate to McDonald's FAQ to find the information needed. Describe their miss

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