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 corporate structure in relation to its strategy, Which company do y...

Which company do you know of that successfully has been able to successfully or not manage its corporate structure in relation to its strategy? Explain you're rational. Cite all yo

Difference between performance and productivity measurement, 1. Explain the...

1. Explain the link between productivity and quality?  2. Who do van Biema and Greenwald (1997) and Drucker (1991) suggest are responsible for the slow growth in service sector

Explain inhumane labor standards, A few years ago, several U.S. retailers w...

A few years ago, several U.S. retailers were sued in Los Angeles courts for human rights abuses associates with contract manufactures located in the Marianas Islands, a territory o

Explain in words your motivation to do a good job, Describe in words your m...

Describe in words your motivation to do a good job? Does your company recognize your value? Is your salary/wages indicative of your value?

Explain how is samsung currently performing, 1. In what ways has Samsung's ...

1. In what ways has Samsung's multibusiness model changed overtime? Why did its top managers make these changes? 2. How is Samsung currently performing/ What kinds of changes is

How determining the productivity of his organization, Eric Johnson makes bi...

Eric Johnson makes billiard balls in his New England plant. With recent increases in his costs, he has a newfound interest in efficiency. Eric is interested in determining the prod

Schmenner''s service-process matrix - operation strategy, Schmenner's Servi...

Schmenner's Service-Process Matrix The service-process matrix was introduced earlier. It is Schmenner's service industry equivalent of the product-process matrix. The service

Security - customer satisfaction and service quality, Security - Customer S...

Security - Customer Satisfaction and Service Quality Is the freedom from danger, risk or doubt. It involves: 1. Physical safety (will I get mugged at the automatic teller

Explain how does the market demand curve change, How does the market demand...

How does the market demand curve change (as a function of marketing expenditure) during recession? a. Shifts downward b. Remains unaffected c. Becomes ver

Thus the best decision isn''t always made, As a manager, you are expected t...

As a manager, you are expected to make logical, rational decisions that are in the best interests of the organization. However, the best decision isn't always made. Let's discuss w

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