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

The best alternative is to build large wing, Chris Suit is administrator fo...

Chris Suit is administrator for Lowell Hospital. She is trying to determine whether to build a large wing on the existing hospital, a small wing or no wing at all. POPULATION TR

Explain the various ways hr supports managers, 1) Discuss the various ways ...

1) Discuss the various ways HR supports managers. 2) Discuss the difference between the focus on Affirmative Action and the focus on equality. 3) Discuss two of the protected class

Explain if you agree abandoned the property, As an appellate judge, you hav...

As an appellate judge, you have been assigned the following court case. When Gayle Benz left her husband, Jeffrey, she left personal property valued at $10,000 at their residence.

Explain collective bargaining, Explain collective bargaining Collectiv...

Explain collective bargaining Collective Bargaining : Collective Bargaining constitutes the negotiations among the management and the union with the final objective of agreein

Explain bagel has a competitive advantage, After viewing the video, do you ...

After viewing the video, do you think Finagle a Bagel has a competitive advantage? If so, what is it? If not, why not?

Explain the smallest index rule to find the optimal tableau, Consider the L...

Consider the LP z¤ = max x1 + x2 + 2x3 s.t. x1 + 5x2 + 4x3 • 60 2x1 + 3x2 + 2x3 • 90 xi ¸ 0 8 i = 1; :::; 3: (a) Use the simplex method and follow the smallest index rule to f

Explain mechanical license hand-out, Find a cover song from one of your CD'...

Find a cover song from one of your CD's. If you have no CD, use one from the library. Looking at the credits & using the Mechanical License hand-out as a reference, submit the foll

Explain benefit of taking the money versus losing control, Your new small b...

Your new small business has really grown, but now it needs a substantial infusion of capital. A venture capitalist firm has agreed to invest the money you need. In return, the vent

How might the imposition of a quota on cell phones impact, Nokia Corporatio...

Nokia Corporation, headquartered in Finland, is a world leader in the cell phone industry. Because much of Finland is heavily forested and sparsely populated, it is difficult and e

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