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 mamdouh finally sued for national origin, Mamdouh El-Hakem was empl...

Mamdouh El-Hakem was employed by BJY, Inc., for more than a year. His manager repeatedly called Mamdouh, an Arabic employee, "Manny" or "Hank", instead of his given name. His manag

Financial risk, the importance of the measurtement of market risk for finan...

the importance of the measurtement of market risk for financial institution

Explain allowable standard deviation in the temperature, Rachel loves to ba...

Rachel loves to bake cookies, but she has an old oven that has trouble maintaining a constant temperature. if the acceptable temperature range for making the cookies is 350 plus or

Line balancing, #quest What happens if line balance doesn’t existion..

#quest What happens if line balance doesn’t existion..

Determine the optimal quantity , Suppose you are overseeing the purchasing ...

Suppose you are overseeing the purchasing of a certain commodity for the following year. The demand for this item is estimated to be 20,000 units/year, and steady throughout. Every

Explain in comparing two populations using paired difference, In comparing ...

In comparing two populations using paired differences, after the difference is found for each pair, the method for testing whether the mean difference is equal to 0 becomes the sam

Describe the peculiarity of location selection, Question 1: How is Brea...

Question 1: How is Break-even Analysis significant to investment, as well as, operational decisions Assumptions Importance of Break-even Analysis for operational deci

Explain the probability that this person actually has heart, Medical studie...

Medical studies have shown that 10 out of 100 adults have heart disease. When a person with heart disease is given an EKG test, a 0.9 probability exists that the test will be posit

Explain organizational structure, Analyze the reason for the type of organi...

Analyze the reason for the type of organizational structure employed by the organization, and identify the key positions that support that organizational structure.

Describe do you see any points of conflict, Write about your understanding ...

Write about your understanding of the assumptions of new science and their implications for leaders in the 21st Century. 1. How are they supported by The Thinking Habits of Mind

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