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

The Strategic Significance of Design, What is the strategic significance of...

What is the strategic significance of Design in operations management?

Describe the importance of reliability in the selection, Define and discuss...

Define and discuss the importance of reliability in the selection process.

Explain the term marketing and selling, Explain the term Marketing and Sell...

Explain the term Marketing and Selling. Marketing and Selling : The marketing theory is a management orientation which holds that the key task of the organization is to find o

Explain what is my alternative hypothesis, In preparing a survey to be admi...

In preparing a survey to be administer to my university peers, it is necessary to tabulate these data once collected. How should the data be tabulated and what statistical methods

Explain what is the utilization rate of this service system, "Fast Eddie" F...

"Fast Eddie" Flournoy manages the service equipment division of Delta Airline's Atlanta terminal. He keeps a service crew on call to repair tow tractors that break down. Tractors b

Mba0038, explain strategy as an organizational process

explain strategy as an organizational process

Information required for process planning, Information required for Process...

Information required for Process Planning Quantity of work to be along with product specifications. Availability of equipment tools and personnel (giving dates e

Explain maintain its strong brand images, impressive portfolio includes som...

impressive portfolio includes some of the strongest brand names in the world. Additionally, P&G must study its consumers, use long-term perspectives, employ product innovation and

What helps ups to achieve its business objective, How the web site helps UP...

How the web site helps UPS to achieve its business objective?

Which new market was opened when apple introduced itunes, 1. When App...

1. When Apple introduced iTunes, a new market was opened. Which of the following describes this type of innovation? a. Value capture b. Presence c. O

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