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 operational management strategy for a company, Identify how the cha...

Identify how the changes in the internal envirobnebt affect the Operational Management strategy for a company. For example, what impact are the following factors likely to have on

Explain widget is identical and requires a machining cycle, 3,000 widgets m...

3,000 widgets must be machined on workstation during week. Each widget is identical and requires a machining cycle time (Tc) of 36.5 minutes. All of the machining centres in the sh

Answer, A paper mill produces two grades of paper viz., X and Y. Because of...

A paper mill produces two grades of paper viz., X and Y. Because of raw material restrictions, it cannot produce more than 400 tons of grade X paper and 300 tons of grade Y paper i

Explain environmentally safe goods and why, Imagine you are a new product t...

Imagine you are a new product that sells for $1.25 an is environmentally safe. Would you spend thousands of dollars for Green Seal on your impulse product if ambivalent toward such

Explain formal partnership agreement, Suppose a partnership is set up and o...

Suppose a partnership is set up and operated without a formal partnership agreement. What problems might arise?

Explain requirements of alliance membership, In what ways might the divisio...

In what ways might the divisionalized forms of most airlines lend themselves to the requirements of alliance membership? In what ways might they be compatible with the organization

Define what should hr do about the older workers, What do companies have to...

What do companies have to do about their workforce force that has gotten older and there are not of younger to replace the aging workers? What will be the company best course of ac

Explain why is external competitiveness so important, External vs. Internal...

External vs. Internal Policies. Distinguish policies on external competitiveness from policies on internal alignment. Why is external competitiveness so important? What factors sha

Explain will any action notices be generated, The MPS for product A calls f...

The MPS for product A calls for 100 units to be completed in week 4 and 200 units in week 7 (the lead time is 1 week). Spare part demand for Item B is 10 units per week. The bill o

Explain can we solve the problem of crime, Can we solve the problem of crim...

Can we solve the problem of crime? How much responsibility does society have? Are our policies enough? What would you do differently, if anything?

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