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

Define level capacity strategy verses just in time system, Define why a lev...

Define why a level capacity strategy could be complicated to adopt for an organisation operating a just in time system? Level capacity strategy Along with a level capacit

Explain what is the annual ordering cost, If annual demand is 24,000 units,...

If annual demand is 24,000 units, orders are placed every 0.5 months, and the cost to place an order is $50, what is the annual ordering cost?

Define productivity percentage change for each category, 1 Eric Johnson mak...

1 Eric Johnson makes billiard balls in his New England plant. With recent increases in his costs, he has a newfound interest in efficiency. Eric is interested in determining the pr

Explain type of inventory management, What are some different companies tha...

What are some different companies that could benefit from using this type of inventory management and why?

Explain things never to say to women executives, Go to www.diversityinc.com...

Go to www.diversityinc.com and search for "Things Never to Say to Women Executives". List three examples and provide a one page explanation regarding how these statements undermine

Product or service design and process selection, Product or Service Design ...

Product or Service Design and Process Selection  Can the products/services be designed to satisfy the needs of both the market and the producers/providers? For example, it may

Would this need cause you to turn down this franchise, The franchise fee is...

The franchise fee is %u201Cthe one-time payment made to become a franchisee%u201D (Hatten, 2009, p. 142). Hatten also stated that %u201Csome agreements require you to have a percen

Explain the mystery cat, In TS Elliot's book of practical cats name the mys...

In TS Elliot's book of practical cats name the mystery cat?

Explain what is the recommended production rate, The forecasted demand for ...

The forecasted demand for fudge for the next four months is 140, 160, 90 and 70 pounds. A) What is the recommended production rate if a level strategy is adopted with no back order

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