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

Operations Theories., Choose an Operations Management problem relating to a...

Choose an Operations Management problem relating to an organisation of your choice and undertake a critical review.

Explain which one minimizes their cost, A swim club is designing a new pool...

A swim club is designing a new pool to replace its old pool. The new pool would need to last for 10 years since the club is planning on relocating after 10 years. A concrete shell

Industrial relations, discuss the importance of a psychological contract

discuss the importance of a psychological contract

Discuss the main sources of errors in person perception, Question 1: (a...

Question 1: (a) Define personality? (b) (i) Outline the six Occupational Personality Types of Holland's Theory of Personality-Job-Fit. (ii) Explain the relationships amon

Explain successful in developing a business model, Do you anticipate that F...

Do you anticipate that Facebook will ever be successful in developing a business model that monetizes their site traffic even further? When they had their public offering, the valu

Define why is it best not to enter a percentage completion, Answer the foll...

Answer the following questions: 1) Why is it best not to enter a percentage (%) completion? 2) According to your Project Summary, is this project on schedule? Will you be ove

Explain when supply exceeds demand during the lead time, A stock out occurs...

A stock out occurs when supply exceeds demand during the lead time

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 what is the multifactor productivity for each system, A grocery cha...

A grocery chain is considering the installation of a set of 4 self-checkout lanes. The new self-checkout lane setup will replace 2 old cashier lanes that were staffed by a cashier

Explain a risk of disciplining employees, A risk of disciplining employees ...

A risk of disciplining employees is that some employees retaliate. To avoid that risk, what organizational policies might encourage low-performing employees to leave while encourag

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