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

How many stamping machines are required, Bloomsday Outfitters produces T-sh...

Bloomsday Outfitters produces T-shirts for road races. They need to acquire some new stamping machines to produce 30,000 good T-shirts per month. Their plant operates 200 hours per

Explain in your opinion are the protections necessary, Identify and discuss...

Identify and discuss each of the warranty protections that apply to the sale of goods under Article 2A of the Uniform Commercial Code (UCC). Provide an example for each that is not

Compute the slope and the intercept of the trend equation, Demand for a sur...

Demand for a surgical procedure at St. Elsewhere Hospital has increased steadily over the past few years: Year 1 2 3 4 5 Heart Transplants 45 50 52 56 61 Use the

Explain five common reasons that projects crash, Discuss two of the five co...

Discuss two of the five common reasons that projects crash. Relate your response to a project failure that you have experienced or witnessed

Define coaches are matched to their situation, Word paper that analyzes the...

Word paper that analyzes the two leadership case studies, "Coach Knight: A Will to Win" and "Coach K: A Matter of the Heart." Address the following questions and concepts:

Explain managing consumer trust, Why does the Baltzan text draw a dist...

Why does the Baltzan text draw a distinction between e-business and e-commerce? • The Baltzan text lists four challenges for Web-based e-business (pp. 103 - 104). See

Describe what you would/could do as a manager, Discuss what you would/could...

Discuss what you would/could do as a manager, or what you have experienced, to create 3 different "orange splats" or emotional episodes at work that are low cost with high emotion

Explain skills associated with effective project manage, Determine which of...

Determine which of the eight traits or skills associated with being an effective project manager would be the most effective when managing a group of newly hired engineers. Justify

Line balancing, What do you understand by “line balancing”? What happens if...

What do you understand by “line balancing”? What happens if balance doesn’t exist?

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