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

Find what will the productivity of the bakery, If charles lackey's utility ...

If charles lackey's utility costs remain constant at $500 per month, labor at $8 per hour, and cost of ingredients at $0.35 per loaf, but Charles does not purchase the blender sugg

What is acquisition management, In your own words, what do you think acquis...

In your own words, what do you think acquisition management is and what are your impressions on how it is done in the DoD?

Explain detect the presence of assignable causes, If the time order of prod...

If the time order of production has not been recorded in a set of data from a process is it possible to detect the presence of assignable causes?

Explain consumer products into brazil, What steps could a company take to a...

What steps could a company take to avoid making product design and marketing mistakes when introducing new consumer products into Brazil?

Stepping stone method, Stepping Stone Method: Continue the above ex...

Stepping Stone Method: Continue the above example containing the initial basic feasible solution obtained by least cost rule. In this there six empty cell :91,1) )1

Number of shiments and number of defective shiments, The quesstion is to de...

The quesstion is to develop a scattr diagram using total number of shiments and number of defective shiments. This is for Project management mgmt. can some one help me with this

Analyze on the price of heating oil, Question For the financial year 20...

Question For the financial year 2012-2013, it has been decided the equalization of the tax on heating oil with the tax on fuel, thus increasing the price of heating oil. Do you

Explain what is the maximum effective capacity of the system, The roller co...

The roller coaster at Treasure Island Amusement Park consists of 15 cars, each of which can carry up to three passengers. According to a time study each run takes 1.5 minutes and t

Simulation problem, neater eater hamburger joints frequency distribution op...

neater eater hamburger joints frequency distribution operation research problem

Explain what is the college education fee, On the day his son was born, a f...

On the day his son was born, a father decided to establish a fund for his son's college education. The father wants the son to be able to withdraw $4000 from the fund on his 18th b

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