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 hrm role in the international context, 1. Compare the issue(s) face...

1. Compare the issue(s) faced with the staffing approaches to one of a larger company. 2. Analyze the complexity of the HRM role in the international context. 3. Compare the

Explain ethical and conflict of interest issues, Public corporations are le...

Public corporations are led by CEOs and other upper-echelon leaders who, in turn report to shareholders and board of directors (BODs). Interestingly, even though the board overseas

Explain if overachievement is acceptable, If overachievement is acceptable,...

If overachievement is acceptable, the appropriate di+ variable can be dropped from the objective function.

Explain the service organization worry about world class, Why should a serv...

Why should a service organization worry about being world class if it does not compete outside its own national border? What impact does the Internet have on this?

Explain needed for good information literacy, 1. In two or three sentences,...

1. In two or three sentences, please summarize what you have learned about information literacy so far in your earlier courses and in this seminar. 2. Then explain how informati

Explain uninformed aspiring international business executive, Our Internati...

Our International Management text cites in Reading 1.2 that:"U.S Management theories contain a number of idiosyncrasies not necessarily shared by management elsewhere" and then pro

Explain what type of human resource strategy did lenovo, Overview: This cas...

Overview: This case explores the mission to become a major player in the global personal computer industry. Lenovo acquired IBM%u2019s personal computer division in 2004 to become

Linear programming problem, Explain the graphical method of solving Linear ...

Explain the graphical method of solving Linear Programming Problem

How the organization you researched could become productive, Make one solid...

Make one solid recommendation for how the organization you researched could become more productive by applying one of the lessons learned. Explain your rationale.

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