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 the company''s competitive advantage, SWOT Analysis (3 to 4 pages) ...

SWOT Analysis (3 to 4 pages) Internal Analysis (Strengths and Weaknesses). For example: Describe the company's competitive advantage by discussing its efficiency, quality, motivati

Oprations process design, what is operation process design ? what are the i...

what is operation process design ? what are the important factors that effect a process design

Describe system safety program, You are the System Safety Engineer for a ma...

You are the System Safety Engineer for a major aerospace firm. You have been assigned to lead the system safety program for a newly developed aircraft. What are some of the key tas

Routing, Routing Meaning and Definition Routing is the first bu...

Routing Meaning and Definition Routing is the first but the important and difficult task of the production control. Routing means determination of path or route on whic

Simo or simultaneous motion charts , Simo Or Simultaneous Motion Charts  ...

Simo Or Simultaneous Motion Charts  This chart (see figure), which employs the timescale of the multiple-activity chart, is used in conjunction with (or instead of) the two h

Explain the ftc prohibit the use of this commercial, Perfect Face Cream ran...

Perfect Face Cream ran a commercial to showcase its new Wrinkle-Free Face Cream. The commercial showed an older woman with severe wrinkles followed by images of that same woman aft

Operation management, What are different benefits & limitations of Waiting ...

What are different benefits & limitations of Waiting Line Theory?

Compare human assets versus other organizational assets, The primary issue ...

The primary issue is that people want to be challenged. People want to be challenged, at least initially, in terms of their Assignments. They also want to be continuously challenge

Find out what is e, Two large, thin metal plates are parallel and close to ...

Two large, thin metal plates are parallel and close to each other. On their inner faces, the plates have surface charge densities of opposite signs and of magnitude 17.0 × 10 22 C

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.

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