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 sales-force composite, List the specific weaknesses of each of thes...

List the specific weaknesses of each of these approaches to developing a forecast: a. Consumer surveys. b. Sales-force composite

Draw a diagram of the factory and finding the maximum rate, Factory is a ba...

Factory is a bathtub with 50 gallons capacity, drain is outlet to market and can output 3 gallons per hour. Faucet is raw material input and allows materials in at a rate of 4 gall

Explain customization in manufacturing or services, Evaluate the statement:...

Evaluate the statement: "Special-purpose technology is a common way of offering increased customization in manufacturing or services without taking on additional labour costs." Cit

Explain basic controllable production planning problem, What are the basic ...

What are the basic controllable variables of a production planning problem? What are the four major costs? Discuss and explain each variable. Discus and explain each cost.

Explain the credibility of a source of information, What criteria do you re...

What criteria do you recommended to determine the credibility of a source of information? Develop a list of no less than 10 elements you would use to determine the credibility of f

Describe how you might use job enlargement, Explains how you might use job ...

Explains how you might use job enlargement, job rotation, and/ or job enrichment to in motivating custodians at Norman dale CC.

Explain technique to develop a forecast for the expected, air travel on Mou...

air travel on Mountain Airlines for the past 18 weeks was: Week Passengers 1 404 2 410 3 420 4 415 5 412 6 419 7 424 8 433 9 438 10 440 11 446 12 451 13 455 14 460 15 466 16 474 17

Define coaches are matched to their situation, Word paper that analyzes the...

Word paper that analyzes the two leadership case studies, "Coach Knight: A Will to Win" and "Coach K: A Matter of the Heart." Address the following questions and concepts:

Explain consumption behaviours which you consider unethical, Compile a list...

Compile a list of consumption behaviours which you consider unethical. For each behaviour listed, explain why you view it as wrong

Create a perceptual map for a particular product, Which of the following da...

Which of the following data are collected from consumers to develop a perceptual map for a particular product? A listing of all prospective brands and products Managerial jud

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