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

Explain why is km extremely valuable in areas of research, Why is KM extrem...

Why is KM extremely valuable in areas of research and development? How do the different components of MITRE's KM system assist in spreading knowledge throughout its labs and in sto

Define how supply chain management affected the organization, Reasearch a c...

Reasearch a company that uses supply chain management. Look how their organizational profitability is affected by the SCM. Incluce a descripiton of the company researched, expla

Explain changing the manufacturing process, Your company makes baby seats f...

Your company makes baby seats for cars and RVs. Your main product was designed some time ago, and new and better engineering data are available, but your product has a good record

Explain business relationship, Joan has been a manager with Argos for the p...

Joan has been a manager with Argos for the past 15 years. She is known to be aggressive and tough and always gets results. She is demanding of her employees and is often brusque wi

Differences among transnationals and global corporations, 1) Discuss the di...

1) Discuss the differences between transnationals and global corporations. 2) Compare political risk in the US to that of Egypt. Is there more in one country and what is the imp

Description of coyote community college its environment, Based on the descr...

Based on the description of Coyote Community College and its environment, what specific types of measures should they include in each of their perspectives of the balanced scorecar

Explain pilot test to generate the variance estimate, If a pilot test revea...

If a pilot test revealed 45% perceived poor service quality, and we decide the interval range is + 10 percent with a 95% confidence level, what is the calculated sample size to con

Explain about the just in time philosophy, Explain about the just in time p...

Explain about the just in time philosophy. Just in time (JIT): This philosophy requires which products must only be produced when there is an internal/external customer w

Explain the factors affecting motivation, Explain the factors affecting mot...

Explain the factors affecting motivation . Factors influencing motivation: Achievement-Personal satisfaction in problem solving and job completion. Advancement-Promot

What are the main factors that defines google''s success, What are the key ...

What are the key factors that defines Google's success in the industry? What are their key competencies, capabilities and resources of being a successful search engine?

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