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

What is diversification, What is Diversification? Ans: Diversificati...

What is Diversification? Ans: Diversification is guiding activities into different lines of business.

Design of a website for a tertiary educational institution, Question: T...

Question: The importance of having a properly designed website cannot be overemphasized. Poor user interface design is often the reason why so many websites are never used. Gen

Explain what are the activities required to produce, What are the outputs o...

What are the outputs of your work unit if you are a manager at a fast-food restaurant? What are the activities required to produce those outputs? What are the inputs?

Define strong technical skills or strong communications, What types of peop...

What types of people have more difficulty being team players? What helps promote good team player behaviour? 3. What do you think is more important for a good IT professional: stro

Organisations operations strategy, Question: Operations strategies are ...

Question: Operations strategies are developed to ensure managers deliver goods or services that are better, cheaper and more responsive to customer needs. Comment on any three

Explain the logistics has such an important economic impact, Why or why not...

Why or why not the logistics has such an important economic impact

Effect on costs and employer, Effect on Costs and Employer: Accidents  are...

Effect on Costs and Employer: Accidents  are harmful when  we take into account  the business  of the  concern.  It adds to the  costs of production  directly  as well  as  indire

Explain europe and japan to adopt the new product, What triggered the new p...

What triggered the new product strategy at Minnesota Biolabs? 2. What prediction would you make for the success of getting the country general managers in Europe and Japan to adopt

Long term capacity reduction, Long term Capacity Reduction Capacity pl...

Long term Capacity Reduction Capacity planning does not necessarily mean the expansion of the capacity. It may also mean reduction of the capacity which may be done in the fol

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?

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