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

Compute the npv, Expando, Inc., is considering the possibility of building ...

Expando, Inc., is considering the possibility of building an additional factory that would produce a new addition to their product line. The company is currently considering two op

Tracing a loop, Tracing a loop: When a closed loop is to be traced start wi...

Tracing a loop: When a closed loop is to be traced start with the empty cell which is to be evaluated ( or to be included in the solution ). Then moving clockwise draw an arrow fro

Explain improvement that would benefit any organization, From the video, de...

From the video, determine how the hiring practices at Barcelona Restaurant Group could be leveraged at businesses that do not have such a tight focus on customer service. Provide s

Explain regulatory organizations ccupational safety, "Regulatory Organizati...

"Regulatory Organizations" Please respond to the following: • Evaluate the effectiveness of JCAHOs recommendations for emergency preparedness. Discuss which recommendations should

Explain how training and education of work forces are differ, Explain how t...

Explain how the training and education of work force differ from that of the middle level managers. The training and education of work force differ from that of the middle le

Production and Operation Management, What do you understand by “line balanc...

What do you understand by “line balancing”? What happens if balance doesn’t exist?

Describe how to create a work breakdown structure, Final Paper The final si...

Final Paper The final six to eight page paper must demonstrate understanding of new learning in the field of project management. It is mandatory to have research from the classroom

Control charts for attributes - statistical process control, Control Charts...

Control Charts for Attributes - Statistical Process Control Attribute data assume only two values, such as pass/fail or good/bad: they are counted rather than measured. Many q

Describe in light of accounting scandals, One of the most influential piece...

One of the most influential pieces of legislation was the Sarbanes-Oxley Act of 2002. This act greatly increased the transparency of financial disclosure in light of accounting sca

Explain decision quality requirement that is significant, A large municipal...

A large municipality (250,000 citizens) is trying to decide where to locate a new community recreational center. The problem is relatively unstructured. There is a decision quality

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