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 the case of ellen moore living and working in korea, The case of El...

The case of Ellen Moore (A) Living and Working in Korea. Look at this case from the point of view of Andrew Kilpatrick. At this point in time, what would you do if you were Andrew?

Rating, Rating, Performance and Units of Work - Process Design  Ratin...

Rating, Performance and Units of Work - Process Design  Rating is the assessment of the worker's rate of working relative to the observer's concept of the pace corresponding

Calculate seasonal index for summer, The number of visitors at a theme park...

The number of visitors at a theme park by season and year has been recorded and is given in the following table- Quarter 2003 2004 2005 2006 Winter 48 51 43 18 Spring 55

Illustrate your discussion using a service organisation, Question 1: "Y...

Question 1: "Yield management guides the decision of how to allocate undifferentiated units of capacity to available demand in such a way as to maximize profit or revenue." Cri

Explain management principles applicable to organizing, The American Red Cr...

The American Red Cross has been asked to oversee the clean-up efforts in Japan after the earthquake and tsunami that occurred in March 2011. Analyze the management principles appli

Explain the scope of an external customers project, Project sponsors within...

Project sponsors within the contractors company have the authority to change the scope of an external customers project as they see fit. Answer Have the authority to change t

Describe the organizational design, 1) Define and discuss the advantages an...

1) Define and discuss the advantages and disadvantages of functional and matrix structures. 2) Define and discuss the advantages and disadvantages of cross-functional teams.

Explain research and industrial engineering, What future for Operations ...

What future for Operations Research/Industrial Engineering? In your own words, answer the following questions in an essay: What is this presentation about? What does th

Linear programing, Ask question #Minimum 100 words acceptNas food produces ...

Ask question #Minimum 100 words acceptNas food produces to kinds of popular dark chocolate bars. the banana and coffee. the banana bar costs 0.22 to make and sells of 0.35, where a

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