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

What factors are likely cause faults in valuing google stock, The managemen...

The management and Directors of Google have stated that there is no plan for Google to ever pay dividends. Yet, the stock trades at a very high price in dollar terms (around $490 p

Explain appropriate levels of control for their inventory, Hatten (2009) st...

Hatten (2009) stated, because inventory is such a significant expense, most businesses look carefully for ways to determine the appropriate levels of control for their inventory. H

Explain fledible cross functional teams, Strategy Highlits 11.2 dicusses th...

Strategy Highlits 11.2 dicusses the informal oranizational structure of W.L.Gore and Associates. Go to the firm's Website (www.gore.com) and review the scope of the firm. a. Wha

Explain the decision-making view, Describe the decision-making view and the...

Describe the decision-making view and the process view of operations management. Why are both views useful in studying the field of operations management?

Solve breakeven problem, Breakeven Problem 1. Avila Manufacturing plans ...

Breakeven Problem 1. Avila Manufacturing plans to increase capacity by adding new equipment. They have received two proposals. Fixed CostVariable Cost/Unit Proposal A $32,

Explain firms do not compete only against global competitors, Firms do not ...

Firms do not compete only against global competitors, but against- Their suppliers. Themselves. The customers of their competitors. Their competitors supply chains.

Describe strategic management concepts and cases, Threadless (in Strategy H...

Threadless (in Strategy Highlight 1.1) is an example of a firm building on its customer base to use new products and also to participate in the design and vetting of popular design

Explain intelligence help an organization better monitor, How does business...

How does business intelligence help an organization better monitor, manage, and make decisions for its business?

Explain should health care workers receive the flu vaccine, Should health c...

Should health care workers receive the flu vaccine? I f not why not?

Explain current business operating on a global scale, Introduce a new speci...

Introduce a new special form of insurance for current business operating on a global scale with a diverse work force, which includes virtual employees.

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