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

Rapid innovation - customers needs for a product, Rapid innovation - Custom...

Rapid innovation - Customers Needs for a Product The readiness with which the operations system can generate new products and services, and get them to market quickly. A study

Explain the market equilibrium conditions in this market, John Barks owns B...

John Barks owns Barks Computer Screens Inc. and wants to identify the supply and demand for screens in his market. The company can produce large screens called Wides or small scree

Define the temporal flexibility workforce, Define the temporal flexibility ...

Define the temporal flexibility workforce. Temporal flexibility can be accomplished by varying the hours worked through employees within response to changes into demand for

Explain a star product is one that, A star product is one that A) in the...

A star product is one that A) in the growth stage but has a low market share B) Has negative to low earning characteristics C) Continues to increase market share even at t

Operations sequence analysis, Operations Sequence Analysis Being an ea...

Operations Sequence Analysis Being an early approach to process layouts operations sequence analysis develop a good scheme for arrangement of department graphically analysis t

Describe the aspects of total quality management, Discuss the aspects of To...

Discuss the aspects of Total Quality Management (TQM) and how they apply in service- and product-based businesses.

Explain how would you handle this situation, New Employee Issue You have a ...

New Employee Issue You have a new employee who is in his/her probationary period, the first 90 days of employment. The employee has missed several days of work and has been late at

OR, Ask Managers, as decision makers can purchase computer software to solv...

Ask Managers, as decision makers can purchase computer software to solve specific Operations Research (OR) formulations and as such it is not important for them to learn the OR tec

What kind of transmission path does a fixed wireless signal, What type of t...

What type of transmission path does a fixed wireless signal require?

Describe the biggest organizational managerial mistake, • Determine the big...

• Determine the biggest organizational managerial mistake you have seen or read about and determine how this mistake affected the organization. • Discuss ways to ease the transi

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