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

Evolutipn of operation management, discuss the evolution of operations mana...

discuss the evolution of operations management in the last 10 years

Explain fire wire sure wire surfboard''s strongest competitor, 1. Identify ...

1. Identify and describe fire wire sure wire surfboard's strongest competitor .how is this rival positioned in the marketplace? 2. What recommendation would you make to mark pri

Explain what type of information must mititech''s suppliers, 1 To ensure th...

1 To ensure that its supply chain can handle a surge in demand, MitiTech should: a. hire additional manufacturing employees b. modify its design to speed up production time

Explain what is the economic order quantity technique, What is the Economic...

What is the Economic Order Quantity technique and what are the basic assumptions the model formula follows?

Explain the change management factors, Describe the change management facto...

Describe the change management factors that shape HR-business strategy.

Explain companys competitive advantage, Which is most important for a compa...

Which is most important for a companys competitive advantage: internal consistency or market competitiveness?

Case study, Bloomsday Outfitters produces T-shirts for road races. They nee...

Bloomsday Outfitters produces T-shirts for road races. They need to acquire some new stamping machines to produce 30,000 good T-shirts per month. Their plant operates 200 hours per

Explain the similarities and differences of tqm, Describe the similarities ...

Describe the similarities and differences between TQM and Six Sigma quality-management techniques.

Explain what is the workstation cycle time, 1. Some tasks and the order in ...

1. Some tasks and the order in which they must be performed according to their assembly requirements. These are to be combined into workstations to create an assembly line. The

Expalin the fundamental ethical principle, How does utilitarianism contradi...

How does utilitarianism contradict the fundamental ethical principle: the end does not justify the means?

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