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 the functional flexibility workforce, Define the functional flexibil...

Define the functional flexibility workforce. Functional flexibility (task flexibility or multi-skilled employees) associates breaking down traditional occupational restricti

Describe ethical responsibilities, Explain the difference between ethical r...

Explain the difference between ethical responsibilities and social responsibilities of a manager. Please in you own words

Compute an appropriate process capabiity ratio, The weight of nominal 1-kg ...

The weight of nominal 1-kg containers of a concentrated chemical ingrediant are shown below data. Part 0. 9475 0.9775 0.9965 1.0075 1.0180 0. 9705 0.9860 0.9975 1.0100

Explain what decision should be made by the optimist, Company must decide h...

Company must decide how many lots of chocolate muffin premix to order for its three stores. Information on pricing, sales, and inventory costs has led to the following payoff table

Explain financial ratios, Analyze the 12 financial ratios and determine whi...

Analyze the 12 financial ratios and determine which is the most useful to the greatest number of small businesses. Explain your rationale

Explain exponential smoothing, An electrical contractor's records during th...

An electrical contractor's records during the last five weeks indicate the number of job requests Week: 1 = 22 requests 2= 24 requests 3= 20 requests 4= 23 requests 5= 24 requests

Lean synchronization, what are the wastes and how to overcome them in an or...

what are the wastes and how to overcome them in an organisation?

Explain graphic project report used in project management, Which of the fol...

Which of the following is a graphic project report used in project management?

Explain market conditions profit probability, Mary Decker is thinking of su...

Mary Decker is thinking of suing the manufacturer of her car because of a defect that she believes caused her to have an accident, and kept her out of work for a year. She is suing

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