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 artists and producers royalties, Downloading music, radio, and vide...

Downloading music, radio, and video programs from the Internet is easier than in the past, but some companies are still worried that people will illegally obtain copies of this pro

Explain growth and globalization strategies, Given Pitney Bowes' growth and...

Given Pitney Bowes' growth and globalization strategies, analyze the forces for and against maintaining an organizational culture that supports diversity as a business imperative

Explain counteract prejudice, Counteracting Prejudice One of the simplest a...

Counteracting Prejudice One of the simplest and most powerful ways to counteract prejudice and discrimination is to articulate and share stereotypes and preconceived notions. How c

Capacity planning, outsourcing as external source of capacity

outsourcing as external source of capacity

Operation Management, n the table given below the Distribution Manager is e...

n the table given below the Distribution Manager is expected to service these DCs as per the demands placed. If the actual sales after completing week one is as follows, what would

Depict a fish-bone chart showing causes of defective product, Boston Electr...

Boston Electric Generators has been getting many complaints from its major customer, House Station, about the quality of its shipments of home generators. Daniel shimshak , the pla

Which amendment has had the most impact throughout history, What are the fa...

What are the facts of the case? What is the key constitutional issue presented? Do you agree or disagree with Angel Raich's postion? Review the amendments to the U.S. Constituti

Concept of a productivity boundary and operating efficiency, 1. Porter (199...

1. Porter (1996) attempts to resolve the issue of Skinner's quandary with trade-offs by introducing the concept of a productivity boundary and operating efficiencies. Explain where

Explain what is the annual rate of return, You discover an antique in your ...

You discover an antique in your attic that you purchased at an estate sale 10 years ago for $400. You auction it in eBay and receive $8000 for your item. What is the annual rate of

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