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 mechanistic or organic organization, Does Mr. Goodnight want to cre...

Does Mr. Goodnight want to create more of a mechanistic or organic organization? Explain

Explain social responsibility on the part of businesses, What are the argum...

What are the arguments for and against social responsibility on the part of businesses? Research the topic and discuss. In addition, which set of arguments is more compelling?

Compute the answers for the missing cells in the table, Process Analytics C...

Process Analytics Case let 1 Overview respond to this case let, which is based in a health care setting.. Preparation Read through the following case let. You are an operations man

Homework, what are the functions of finance, management and marketing in op...

what are the functions of finance, management and marketing in operations?

PRoject, I need to chose a operations management concept or technique in or...

I need to chose a operations management concept or technique in order to help address the issue of the DFW security wait lines. This is a group project and my teammates have starte

Explain what suggestions for improvement, You are the contracting officer's...

You are the contracting officer's representative (COR) of a program management support contract awarded to Easy Corp. It is the first year of a five-year contract. You have noti

Explain ethics addressed in the business world today, How are leadership tr...

How are leadership traits and ethics addressed in the business world today?

Explain the term total quality management, Explain the term Total Quality M...

Explain the term Total Quality Management (TQM). Total Quality Management (TQM): It is a system approach to quality in all spheres of the organisation. TQM implies meeting th

Describe professional application, "Professional Application" Please respon...

"Professional Application" Please respond to the following: • Assess your preparedness for a business leadership and management position based on what you have learned in your g

A try and cut, would you give an example ? haw it calculate.?

would you give an example ? haw it calculate.?

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