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

Define desired lot size, A firm that operates 300 days in a year and uses a...

A firm that operates 300 days in a year and uses a level material usage approach has collected the following data: Annual Demand = 30,000; Daily Demand = 100; Daily production= 300

Explain the similarities and differences of each leadership, Compare and co...

Compare and contrast the Contingency, Path-Goal, and Leader Member Exchange Theories. Describe the similarities and differences of each leadership theory. Explain some of the

Describe the similarities and differences among, Discuss the similarities a...

Discuss the similarities and differences among the organization, group, and job levels in open systems theory.

Describe reducing equipment in the production process, Design for manufactu...

Design for manufacturing and assembly delivers product improvements by emphasizing which of the following? Reducing product quality during the assembly process Simplification

Explain comparable worth, In detail, express your opinion regarding the "Co...

In detail, express your opinion regarding the "Comparable Worth" issue.

Explain investment spending sharply declined in the us, In early 2001, inve...

In early 2001, investment spending sharply declined in the U.S.. In the two months following the Sept. 11, 2001 attacks on the U.S., consumption also declined. Use AD-AS analysis t

Explain what is the purpose of registering securities, Analyze why you thin...

Analyze why you think that the Securities Act of 1933 allows for an exemption to a nonprofit educational organization? The state, based on their securities regulations, could re

Explain what is the asset turn over, Given the following information: sa...

Given the following information: sales:48,000,000 CGS:24,000,000 Variable expense:8,000,000 fixed expenses:8,000,000 inventory:6,000,000 account receivable: 3,000

Calculate seasonal index for summer, The number of visitors at a theme park...

The number of visitors at a theme park by season and year has been recorded and is given in the following table- Quarter 2003 2004 2005 2006 Winter 48 51 43 18 Spring 55

Explain matrix structure and provide examples, Some people argue that the m...

Some people argue that the matrix structure should be adopted only as a last resort because dual chains of command can create more problems that they solve. Discuss and provide exa

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