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 how does a company''s vision and plans affect, How does a company's...

How does a company's vision & plans affect its structure?

Types of process technologies - batch production, Types of Process Technolo...

Types of Process Technologies - Batch Production Under this system the manufacturing is done in batches or groups or lots either on the basis of customer order or with a hope

What happen to the degree of objective risk, If a corporation doubles the n...

If a corporation doubles the number of exposure units, what may be said to happen to the degree of objective risk? Explain your answer and state the basic principle illustrated.

Factors for best path for data among two points on a network, Name three fa...

Name three factors that a router must consider when determining the best path for data between two points on a network?

Activities and advantage that providing facility to customer, Consider the ...

Consider the Gleneagles Hotel in Scotland - it is unique, not part of a chain. It is a six star hotel with world class sports facilities with two championship golf courses, which h

Production control function, Production control Function 1. Dispatchi...

Production control Function 1. Dispatching : Dispatching may be  defined as setting  production activities in motion through  the  release  of orders ( work order shop order)

Explain marketing objectives in each stage, Imagine that you are the produc...

Imagine that you are the product manager for a new electric car similar to the Chevrolet Volt. Using all of your knowledge of the new product life cycle, speculate on the stages

Explain advantages of division of labour, Explain advantages of Division of...

Explain advantages of Division of Labour.  As the same worker does similar work repeatedly:- (i) It gains proficiency and skill on the job and becomes a professional. (ii

Explain how many machines should be purchased, Up, up, and away is a produc...

Up, up, and away is a producer of kites and wind socks. Relevant data on a bottleneck operation in the shop for the upcoming fiscal year are given in the following table: Item Kite

Explain traditional employment agencies, In what ways do executive search f...

In what ways do executive search firms differ from traditional employment agencies?

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