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 Causes of Organisational Change, Explain Causes of Organisational C...

Explain Causes of Organisational Change. Causes of Organisational Change: Causes of Organisational modifies are as follows: (A) External pressures (i) Change in Equipme

Explain collected information on the number of customers, Rosa's Italian re...

Rosa's Italian restaurant wants to develop forecasts of daily demand for the next week. The restaurant is closed on Mondays and experiences a seasonal pattern for the other six day

Determine the standard time by time study, 1. Is work measurement used in y...

1. Is work measurement used in your own organisation? If not, then give thought to how: alternative methods are compared; load is balanced with capacity; productivity is monitored;

Is work measurement used in organisation - process design, Is work measurem...

Is work measurement used in Organisation - Process Design Is work measurement used in your own organisation? If not, then give thought to how: alternative methods are compared

Explain sql commands that are used for data manipulation, What is the role ...

What is the role of structure query language (SQL) in database object creation and information management in a relational database? Identify three SQL commands that are used for da

Legal rules for recovery of the amounts, MJZ Corporation had a checking acc...

MJZ Corporation had a checking account with Gulfstream Bank. So that customers who close their accounts would not be embarrassed by having their checks bounce, the bank routinely h

Explain critical risk regardless of progect size or scope, Select three top...

Select three top most critical risk regardless of progect size or scope. Justify your selection. Suggest strategies for the manager to address each type of risk selected.

Explain variety of theories of motivation, There are a variety of theories ...

There are a variety of theories of motivation, many of which are complementary. Of the main motivational theories described in the text, which theory or theories do you think would

Makw or to Buy ?, • ABC Ltd. is in the business of manufacturing one type o...

• ABC Ltd. is in the business of manufacturing one type of valves for last 3 years. • Their sales have grown from 10,000 to about 50,000 valves per month. • Now they are planning t

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