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

Operational Management, I have a take home exam that I need to be solved 10...

I have a take home exam that I need to be solved 100 % correct , please . I need it within 23 hours EXACTLY from now please . Thank you so much and I am really looking forward to s

Explain trend-adjusted exponential smoothing model, After plotting demand f...

After plotting demand for four periods, an emergency room manager has concluded that a trend-adjusted exponential smoothing model is appropriate to predict future demand. The initi

Compute the aggregate production rate, The BackPack Company produces a line...

The BackPack Company produces a line of backpacks. The manager, Jill Nicholas, has decided that the BackPack Company must have very good customer service. She has asked you to d

Activity sampling - process design, Activity Sampling - Process Design ...

Activity Sampling - Process Design This is a method of finding the percentage occurrence of a certain activity by statistical sampling and random observation. It is used when

Presume semi-annual coupon payments, What is the yield to maturity of a 16-...

What is the yield to maturity of a 16-year bond that pays a coupon rate of 8% per year, has a $1,000 par value, and is currently priced at $916? Round your answer to the nearest wh

Explain testing your business perspective of a typical ie, Page maximum req...

Page maximum required for this question. This is testing your business perspective of a typical IE problem. Given that you have a starting standard time for a job of ninety (90) mi

Explain actual and forcasted demand level, The following are monthly actual...

The following are monthly actual and forcasted demand level for may through December for units of product manufactured by N. Month Actual demand Forecast demand May 100 102

Explain which style did you find most effective, Think back to teachers you...

Think back to teachers you have had, and identify one each who fits a supportive style, directive style, participative style, and achievement-oriented style according to the path-g

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