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 contemporary strategy analysis, Ford's (Case 4) challenge in meetin...

Ford's (Case 4) challenge in meeting the needs of shareholders versus stakeholders. What ethical challenges and dilemmas might this pose? How should a corporate strategy be adju

Explain exponential smoothing, An electrical contractor's records during th...

An electrical contractor's records during the last five weeks indicate the number of job requests Week: 1 = 22 requests 2= 24 requests 3= 20 requests 4= 23 requests 5= 24 requests

Explain meditech''s problems in introducing new products, 1. What are Medit...

1. What are Meditech's problems in introducing new products? In manufacturing ALL products? 2. What is driving these problems, both systematically and organizationally? 3. Wh

Explain what is the minimum number of workstations, An assembly line with a...

An assembly line with a number of tasks is to be balanced. The sum of the task times is 62 minutes. The line will operate for 6 hours per day. What is the minimum number of worksta

Determine control limits for a c-chart and np-chart, 1. If, instead, a cons...

1. If, instead, a constant sample size of 100 is chosen, determine the np-chart control limits. A later sample produces 15 defectives: what conclusion can be drawn?  2. 1000 bot

Operations and production management , OPERATIONS AND PRODUCTION MANAGEMENT...

OPERATIONS AND PRODUCTION MANAGEMENT   Production and operation management (POM) is defined as the design operation, and enhancement of the transformation process which converts

Explain important provisions of factory act, Explain important provisions o...

Explain important provisions of factory act, 1948. The significant provisions of Factories Act, 1948 are given below: a) Health: The following are the significant provisions

Explain what values of q and r is carmins boutique currently, Carmin's Bout...

Carmin's Boutique sells a large number of black dress shirts. The shirts, which bear the store label, are shipped from a manufacturer in Paris. Carmin's purchasing department manag

Explain goals should not be clearly articulated, Clearly-defined goals are ...

Clearly-defined goals are the essence of great teamwork. Which of the following statements is most true about how goals should be articulated by teams: a. Goals should not be clear

Explain what is the horizon value, Current and projected cash flows for Ran...

Current and projected cash flows for Randell Global Operatons are shown below. Growth is expected to be constant after 2012, and the weighted average cost of capital is 11%. What i

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