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

Calculate annual breakeven number of meals, The restaurant would serve dinn...

The restaurant would serve dinner Tuesday through Saturday. Brian has noticed a restaurant for lease. The restaurant has seven tables, each of which can seat four. Tables can be mo

Compute minimum cost service rate, Consider mean arrival rate is 1 customer...

Consider mean arrival rate is 1 customer every 4 mins and mean service time is 5/2 mins. If waiting cost is $5 per unit per min and cost of serviceing one unit is $4. Find minimum

Describe the advantages of using work sampling, Discuss the advantages of u...

Discuss the advantages of using work sampling to understand how employees allocate their time among work activities.

Explain which manufacturing system is more flexible, Three possible manufac...

Three possible manufacturing systems can be used to produce a certain product, 1) ten universal milling machines that work in series, each one is producing a specific geometry, 2)

Describe supervisor can avoid rote, How can supervisors avoid receiving "ca...

How can supervisors avoid receiving "canned" or rote answers to interview questions? This question is about the Supervisor

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

Explain what difference does it make, Use a dystopian narrative within Mart...

Use a dystopian narrative within Martin Luther King's speech. What difference does it make?

Compute the expected monetary value, Superior Products Inc. is considering ...

Superior Products Inc. is considering two potential equipment alternatives for production of their best selling product line. Option 1 involves proven equipment: Fixed cost investm

Why negative exposure in media for lack of responsiveness, Trying to create...

Trying to create a public relations campaign for a financial insitutiion that recently received negative exposure in the media for lack of responsiveness to consumers wishing to mo

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