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

Discuss the fundamental role of managers and leaders, In organizations ther...

In organizations there are supervisors, managers and leaders. What makes them different? Define each role and discuss the fundamental differences of each. Give position specific ex

Describe two methods for allocating costs, Explain two methods for allocati...

Explain two methods for allocating costs. Justify why you selected them and how you would make the most use of them in cost analysis. No copying and pasting or will not be ra

Explain organization to appraise performance formally, Why is it necessary ...

Why is it necessary for an organization to appraise performance formally? Describe some situations in which an organization would be wise if it did not appraise performance formall

Operation research, six operators are to be assigned to five jobs with the ...

six operators are to be assigned to five jobs with the cost of assignment in Rs. given in the matrix below. determine the optimal assignment. which operator will have no assignment

Describe ethical to reduce the number of employees, 1. Based on GM's ...

1. Based on GM's current condition, do you think it is ethical to reduce the number of employees? Why or why not?

Why might a probabilistic estimate, Why might a probabilistic estimate of t...

Why might a probabilistic estimate of the project completion time base solely on the variance of the critical path be misleading? Under what circumstances would it be acceptable?

Explain inventory decreases and inventory increases, What happens to invent...

What happens to inventory as the number of kanban cards increases? Inventory decreases Inventory increases Inventory remains the same The number of kanban cards has no

How does nestle have multiple facilities in a single country, Where in Euro...

Where in Europe, Africa, and Asia does Nestlé have operations? How many factories do they have in Spain and Thailand? Why does Nestlé have multiple facilities in a single country?

What is cutting stock problem, Consider the cutting stock problem that aris...

Consider the cutting stock problem that arises when a company manufactures sheets of standard width 100 and has commitments to supply 40 sections of width 40, 60 sections of width

Advantage of least cost method, Advantage of Least Cost Method a.      ...

Advantage of Least Cost Method a.       This method   provides accurate solution as transportation cost is consider while making  allocation. b.      It is very simple  and

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