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

Describe how erp systems can achieve business integration, Question 1: ...

Question 1: Describe how ERP systems can achieve business integration Analysis of conventional company information systems with respect to ERP packages examples con

Explain are restatements of the law written, Are restatements of the law wr...

Are restatements of the law written and revised by congress and state legislatures true or false

Explain the six steps in a marketing research process, Discuss the six step...

Discuss the six steps in a marketing research process

Explain it is important that lean six sigma efforts, It is important that L...

It is important that Lean Six Sigma efforts be linked specifically to strategic goals of the organization.

Digital Cell Phone Inc., Prepare Paul Jordan''s report to John Smithers usi...

Prepare Paul Jordan''s report to John Smithers using regression analysis. Provide a summary of the cell phone industry outlook as part of Paul''s response.n..

Explain even though efforts to restrict employees'', Discuss the following ...

Discuss the following statement: Even though efforts to restrict employees' free speech at work may be permissible, such efforts raise troubling questions affecting individual righ

Explain the term marketing, Explain the term Marketing. Marketing:  A...

Explain the term Marketing. Marketing:  All organisations are occupied in producing products or services meant for utilize/consumption by people at large. Wants and needs are

Describe line and staff organisation, Describe line and staff organisation....

Describe line and staff organisation. Line and Staff Organisation: As the industry grow in size and complexity, the line executives could not perform appropriately all other

Explain customer relationship management marketing, Describe the four-step ...

Describe the four-step framework for one-to-one marketing that can be adapted to CUSTOMER RELATIONSHIP MANAGEMENT marketing?

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