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 how can efficiency of purchasing processes, How can efficiency of p...

How can efficiency of purchasing processes be improved?

Illustrate example of queuing theory in operation management, Illustrate th...

Illustrate the examples of the queuing theory in operation management? Example of Queuing theory, a mathematical study of the formation of waiting queues or lines (physical or

Explain bill what they mean for his umuc pizza business, Explain Porter's F...

Explain Porter's Five Forces Model and how Bill can use it to analyze his current business and his expansion. Be sure to address each of the 5 forces and explain to Bill what they

Explain violate a federal law, Agents and employees of Apples Corporation a...

Agents and employees of Apples Corporation and Oranges Corporation are convicted of conspiring to violate a federal law that is punishable by a term of imprisonment and a fine. Can

Find revenue from its recently won government contract, Buckeye Manufacturi...

Buckeye Manufacturing expects to generate additional revenue from its recently won government contract. Buckeye forecasts that the revenue will be $40 million in the first year, bu

Explain waste elimination plan, Do a lean waste analysis on the goal and cr...

Do a lean waste analysis on the goal and create a waste elimination plan. (List the seven forms of waste, list items in the goal by waste form, determine what could be done to redu

Explain how much should the father deposit, On the day his son was born, a ...

On the day his son was born, a father decided to establish a fund for his son's college education. The father wants the son to be able to withdraw $4000 from the fund on his 18th b

Importance of performance measurement, Importance of performance measuremen...

Importance of performance measurement  1. Research reveals that many institutional investors are basing their decisions, in part, on a review of company's non financial perfor

Describe the lewin''s change process, Question 1: Change is often resis...

Question 1: Change is often resisted because of the uncertainty and ambiguity it creates, the concern that it might not be in the organisation's best interest. (i) Discuss

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