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 people discriminate when prejudice impacts their, People discrimina...

People discriminate when prejudice impacts their Answer beliefs. attitudes. intentions. behavior.

Sunshine Enterprises Case Study , What is the average value of a loyal cust...

What is the average value of a loyal customer (VLC) at Abby's restaurants (see Chapter 3)? What is the best way to increase revenue given your VLC analysis

Find probability distribution of single lot containing fault, A quality con...

A quality control unit in ball-bearing manufacturing company keeps record of error in terms of the number of faulty balls (W) per a lot. The size of standard lot is 8, and the prob

Illustrate the examples of the inventory control systems, Illustrate the ex...

Illustrate the examples of the inventory control systems? Examples of inventory control systems Reorder level systems: When the current stock level decreased below a

Plan a policy for scheduling vacations, Outline a policy for scheduling vac...

Outline a policy for scheduling vacations for a Health Information Management Department that provides daily, around-the-clock service and has both full time and part time employee

Explain what will happen to the eoq, Part 1: A company is using the Econ...

Part 1: A company is using the Economic Order Quantity (EOQ) model to manage its inventories. Suppose its inventory holding cost per unit per year doubles while the annual deman

Explain how often do you think very favourable, How often do you think very...

How often do you think very favourable, intermediate, or very unfavourable situations occur to leaders in real life? Based on Fiedler's theory

Explain management rights, Identify the differences between the two theorie...

Identify the differences between the two theories of management rights. Discuss reasons why they are poles apart in determining whether management has responsibilities other than t

Integrated solutions in product design, Integrated solutions in product des...

Integrated solutions in product design and control of machinery are based on    CAD and CAM technologies.

Get a financial analysis of coca cola comparing the past 5y, Where can i fi...

Where can i find a financial analysis of coca cola comparing the past 5yrs from 2009-2013. Something in a word format would be help

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