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

Transaction Processing Systems, Discuss the organization structure and oper...

Discuss the organization structure and operation of a university. identify the different types of Transaction Processing System that can be defined for the university specify the d

Compute the number of people involved in the processing, Analyze and evalua...

Analyze and evaluate the processing of new application at the CEUPU: - Create a process map for new applications - Calculate the time needed to process an individual application cy

Explain problem of industrial marketing in india, Explain problem of indust...

Explain problem of industrial marketing in india.   Industrial market has all individuals and organisations which acquire goods and services into the production of other product

Explain business model and strategies changed overtime, 1. Why has Southwes...

1. Why has Southwest's business model and strategies changed overtime? 2. In what ways is Southwest Trying to improve its competitive advantage in 2011? 3. Give examples of a

Why service adds value to a business products and customers, Service is the...

Service is the last activity in the Value Chain. Explain how service adds value to a business products and customers.

Explain what is the average utilization, Spalding Doughnuts wants to know a...

Spalding Doughnuts wants to know about its waiting line. Currently, Spalding Doughnuts uses a single-server, single-phase system when serving customers. Based on historical evidenc

What are the steps you took to address the issue, Consider a time when you ...

Consider a time when you have acted as a leader in the past and had to mitigate an issue. Examine how you resolved the issue. If the issue was not resolved, examine the steps you t

Explain introduce to a newly rebuilt world trade center, What types of chan...

What types of changes would you introduce to a newly rebuilt World Trade Center?

Supply chain strategies, Supply Chain Strategies  In this second secti...

Supply Chain Strategies  In this second section of the chapter we consider:  1. Breadth of supplier base - many or few suppliers?  2. Vertically integrated or virtual or

Explain team prior to raising a follow-on fund, How should foster position ...

How should foster position herself and her team prior to raising a follow-on fund?

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