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

Disadvantages, what are the disadvantages of operation management?..

what are the disadvantages of operation management?..

Explain comparison of processes with a direct adversary, 1. A simulation mo...

1. A simulation model goes one step further than possible with analysis tools, because it can show how the process performs ____________ over time. 2. A(n) ____________ is a met

Describe what is the productivity, A local market research firm has just wo...

A local market research firm has just won a contract for several thousand small projects involving data gathering and statistical analysis. In the past, the firm has assigned each

Explain measurements used in the selection process, Briefly, identify and d...

Briefly, identify and describe, in your own words, the different measurements used in the selection process. What are the advantages and disadvantages of each?

Corporate social responsibility, explain the concept and practice of corpor...

explain the concept and practice of corporate social responsibility (CSR).

Explain framework of the general model of planned change, Describe the fram...

Describe the framework of the general model of planned change. Include a discussion of each activity and a typical sequence of events.

How much must a company pay to keep a specially-skilled, How much should a ...

How much should a company pay to keep a specially-skilled worker? Why? How would you determine the amount to pay to keep such a worker? Explain (again, use textbook concepts) Wh

Explain expected learning curve, A time standard was set as 0.20 hour per u...

A time standard was set as 0.20 hour per unit based on the 50th unit produced. If the task has a 90 percent learning curve, what would be the expected time of the 100th, 200th, and

Explain what are the functions of a manager, What are the functions of a ma...

What are the functions of a manager? If you had to pick one as being the most important function, which would it be and why?

Explain what are the issues of management, What are the issues of managemen...

What are the issues of management does Whole Foods Market in 2010 needs to address? Analyze and evaluate the issues identified

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