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 challenge facing law enforcement agencies, Explain in detail the gr...

Explain in detail the greatest challenge facing law enforcement agencies in investigating exploitation, cyber stalking, and obscenity. Identify the specific challenges with overlap

Explain variations in the material characteristics, Rivets used to secure t...

Rivets used to secure the stainless steel sheet metal of aircraft wings are designed to withstand certain shearing forces. It is known that because of random variations in location

Make a fictional company and develop a memo to communicate, Create a fictio...

Create a fictional company and develop a memo to communicate the importance of a business continuity plan to the board of directors. The completed assignment should be at least 25

Introduction of operations strategy, Introduction of Operations Strategy ...

Introduction of Operations Strategy The term strategy, given in the Collins English Dictionary is, 'the art or science of the planning and conduct of a war; generalship; a lon

Operation function, meaning of operation function in operation management

meaning of operation function in operation management

Explain demand for product is not a constraint, Which of the following is t...

Which of the following is true? Once you complete the five steps, the process is complete Another constraint will always appear when the original constraint is broken Dema

Explain how they demonstrate their leadership characteristic, Provide two e...

Provide two examples of current leaders and describe how they demonstrate their leadership characteristic. What separate these characteristics from management techniques? How effec

Production Planning & Control, All of the following are time phasing requir...

All of the following are time phasing requirement of an MRP logic except Options Gross requirement will occur at the middle of a period On hand inventory will be measured

Mis, mis in decision making

mis in decision making

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