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

Draw a schematic layout, The flow of materials through eight departments. E...

The flow of materials through eight departments. Even though the table shows flows into and out of the different departments, assume that the direction of flow is not important. In

Determining operations strategy - traditional approaches, Determining Opera...

Determining Operations Strategy - Traditional and Emerging Approaches Three known and acknowledged procedures are presented here: the Hill, Platts and Gregory, and the Slack

Production and Operation Management, What do you understand by “line balanc...

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

Explain delays in the project mean that the center, Your in charge of a pro...

Your in charge of a project at the local community center. The center needs to remodel one of the room in time for the start of a new program. Delays in the project mean that the c

Explain progressive insurance''s products, 1 Insurance products are service...

1 Insurance products are services. Describe Progressive Insurance's products in terms of the four characteristics of services. How does Progressive deliver value to its customers?

Define sociotechnical systems theory, Discuss sociotechnical systems theory...

Discuss sociotechnical systems theory and contrast it with the open systems theories of organization development?

Explain what does the term product positioning refer to, What does the term...

What does the term product positioning refer to? A careful analysis of cross tabulations Shelf locations in major chain, grocery, and department stores Geographic segmenta

Explain what is the probability that both are successful, DO NOT WORK A com...

DO NOT WORK A company is considering producing two new electronic games designed for the popular Gameboy toy. Based on market data, management believes there is a 60 percent chance

Why is environmental analysis is vital for an organization, Q1. Why is envi...

Q1. Why is environmental analysis important for an organization? Q2. Write a double-spaced essay of between 750-1000 words on the value of business process improvement to an ind

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