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

Network diagram, 5. A network consists of the following list. Times are giv...

5. A network consists of the following list. Times are given in weeks. Activity Preceding Optimistic Probable Pessimistic A -- 5 11 14 B - 3 3 9 C -- 6 10 14 D A, B 3 5 7 E

The problem require that it get solved using excel solver, I cannot seem to...

I cannot seem to answer EX. 4a, b and c. from ISN# 978-0-13-274395-2 Pearson Chopra 5th Edition. You provide solutions to discussions questions but not chapter exercises. The probl

Compute what is its cost of common equity, The earnings, dividends, and com...

The earnings, dividends, and common stock price of Carpetto Technologies Inc. are expected to grow at 8% per year in the future. Carpetto's common stock sells for $27.75 per share,

Describe what is the total cost of a package, The Fido Dog Food Company wis...

The Fido Dog Food Company wishes to introduce a new brand of dog biscuits (composed of chicken and liver-flavoured biscuits) that meets certain nutritional requirements. The liver-

Line balancing, What happens if balance doesn''t exist

What happens if balance doesn''t exist

Disadvantages of enterprise resource planning, Disadvantages of ERP Systems...

Disadvantages of ERP Systems 1. Expense and Time in Implementation: Getting the full benefits of WRP takes time and money: Although ERP offers many strategic advantages by streaml

Ppc in job production, PPC in job Production Job production includes ...

PPC in job Production Job production includes manufacturing of products to meet particular customer requirements of special orders. The quantity included is usually small. In

Explain traffic density, Subway, with more than 20,000 out lets in the U.S....

Subway, with more than 20,000 out lets in the U.S., is planning for a new restaurant in Buffalo, New York. Three locations are being considered. The following table gives the facto

Explain impedes compliance and innovation, Identify a legal topic associate...

Identify a legal topic associated with the UK's HR that impedes compliance, innovation, growth, and sustainability. Please make sure that the legal topic is in reference to Unite

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