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

Manufacturing process technology, Manufacturing Process Technology New...

Manufacturing Process Technology New products are not physical realities until are manufactured. Process technology refers to the equipment, people and systems used to produce

Explain which depreciation method is preferable, 1. Your firm is considerin...

1. Your firm is considering an investment in a wind farm. Assume that the farm will cost $1 million per MW of installed capacity. The plan under consideration would deploy 10 GE 1.

Calculate the normal time for the job, A work  sampling  study  is to  b...

A work  sampling  study  is to  be made of a typist  pool. It is  left that  typists are idle  30 % of the  time. How many observations  should  be made  in order  to  have 395.5%

Describe setting up valid research designs in a company, Discuss setting up...

Discuss setting up valid research designs in a company, work environment

Explain what is your best choice using emv criterion, Dalton and Carla run ...

Dalton and Carla run a small bicycle shop called "D n C"Bicycles. They must order bicycles for the coming season. Orders for the bicycle must be placed in quantities of twenty(20).

Evaluate optimal order quantity, (a) Supply chain management is the integr...

(a) Supply chain management is the integration of the activities that procure materials and services, transform them into intermediate goods and the final product, and deliver the

Describe culture and values and ethics, Discuss culture, values, ethics, an...

Discuss culture, values, ethics, and other such elements that lead to differences in social culture; 2) Explain the business and economic implications of differences in culture and

Explain what is the utilization of pharma, Pharma Blitz develops and market...

Pharma Blitz develops and markets new technological products to be used in health care. The development of a new product operates as follows. When a new technology meets the requis

Explain why employees steal property, Discuss what you think are FOUR (4) r...

Discuss what you think are FOUR (4) reasons why employees steal property (office supplies, petty cash, cheat on travel expense reports, parts/ equipment, embezzle money) from their

Give me an instance of a preference matrix, Can anyone give me an example o...

Can anyone give me an example of a preference matrix?

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