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

Q3. What do you understand by “line balancing”? What happens, Q3. What do y...

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

Explain the s&op process., Describe the S&OP process. What are the major tr...

Describe the S&OP process. What are the major trade-offs that must be considered?

Preparing the research design, Preparing the Research Design: Researc...

Preparing the Research Design: Research design is the conceptual structure within which research should be conducted. A research design specifies the methods and procedure fo

Explain what do you think make up the concept, What do you think make up th...

What do you think make up the concept, package and process for the adventure playground?

What are the disadvantages of lean production, What are the disadvantages o...

What are the disadvantages of lean production? Disadvantages of lean production are as illustrated below: • Incessant cost of investment within retraining displaced or reass

Explain stakeholder relationships and social responsibility, Watch this Vid...

Watch this Video "Blue jean waste". Describe your reaction to this video and how you would respond if you were a leader of one of the corporations involved. In your journal entry

Give an example of what team performance, Provide an example of what team p...

Provide an example of what team performance readiness might look like at various readiness levels

Describe corruption and bribery, Corruption and bribery are common in some ...

Corruption and bribery are common in some countries. Would you simply avoid locating in such a country, or locate there and deal with it? If the latter, how would you deal with it?

Explain that item as well as a few other items on the return, Tony taxpayer...

Tony taxpayer´s return has come up for audit by the Internal Revenue Service (IRS). He took some deductions this year for an office in his home. Amelio Auditor at the IRS has disal

Why risk interviews are often completed with subject matter, After a risk w...

After a risk workshop has been completed, risk interviews are often completed with subject matter experts. Assess the value of the interviews to identify risk response strategies.

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