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

Describe how does national culture affect strategy, How does national cultu...

How does national culture affect strategy? To what extent do different approaches to strategy, different ways of thinking about strategy, reflect different underlying cultural assu

Explain what are some types of software that can help, What are some types ...

What are some types of software that can help us protect employee information? How does this software interact with our current HR technology? Explain from a conceptual stand

Explain federal trade commission, 1. Please explain, in detail, the strateg...

1. Please explain, in detail, the strategic issues both external and internal that Whole Foods' faces. 2. Please explain, in detail, the strengths, weaknesses, opportunities and th

Forecasting, what are the different steps in quantitative forecasting in ma...

what are the different steps in quantitative forecasting in manufacturing

Describe what do the results of the questionnaire suggest, How do you react...

How do you react to conflict? Do you have a typical style as a leader when dealing with a conflict situation? Complete the Conflict Style Questionnaire. What do the results of the

Describe key issues and concerns, As area sales manager for a company manuf...

As area sales manager for a company manufacturing and marketing outboard engines, you have been assigned the responsibility of conducting a research study to estimate the sales pot

Explain what is an interim plan, Answer the following questions: 1) ...

Answer the following questions: 1) What is the difference between a task dependency and a task constraint? 2) Give a real-world situation when you might used the foll

Explain managers for a large retail department store, Recently the managers...

Recently the managers for a large retail department store stated that a study has revealed that female shoppers spend on average 23.5 minutes longer in the store per visit than do

Explain simulation software such as crystal ball, Given the ease of use of ...

Given the ease of use of simulation software such as Crystal Ball, what other data used in project management should probably be simulated?

Explain what is the capacity of the factory, Hickory Manufacturing Company ...

Hickory Manufacturing Company forecasts the following demand for a product (in thousands of units) over the next five years. Year 1 2 3 4 5 Forecast demand 60 79 81 84 84 Currently

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