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 control board meeting to approve a scope change, Which of the follo...

Which of the following is normally not addressed in a change control board meeting to approve a scope change? Answer Cost of the change Which functional unit will perform

Explain employee benefit package, How might an employer effectively increas...

How might an employer effectively increase the perceived value employees place on their Employee Benefit package?

Explain a global corporation, A global corporation sees the world as its la...

A global corporation sees the world as its labor source as well as its marketplace. Therefore, a global corporation will locate an operation wherever it can accomplish its goals in

Define what should hr do about the older workers, What do companies have to...

What do companies have to do about their workforce force that has gotten older and there are not of younger to replace the aging workers? What will be the company best course of ac

Compute the past growth rate in earnings, The Bouchard Company's EPS was $6...

The Bouchard Company's EPS was $6.96 in 2005, up from $3.34 in 2000. The company pays out 50% of its earnings as dividends, and its common stock sells for $40. a. Calculate the

Describe what is the day supply for each item, The Following table contains...

The Following table contains data about the inventory for five items at Jones Corporation and the rate of sales for each of the five items in the upcoming year Item# Beginning U

What is usefulness of materials requirement planning, Q. What is usefulness...

Q. What is usefulness of materials requirement planning first to manufacturing operations? Materials requirement planning (MRP I) is an inventory control system that gives an a

Job shop organisation - operations function, Job Shop Organisation - Operat...

Job Shop Organisation - Operations Function Job shop systems generate special products or services to customer specification, with little likelihood that any particular produc

Explain level of competitive intensity in an industry, According to Porter,...

According to Porter, what determines the level of competitive intensity in an industry?

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