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

Order winners - operations strategy, Order Winners - Operations Strategy ...

Order Winners - Operations Strategy These are operational capabilities that directly contribute to winning business. They are generally cited as the reasons for the purchase o

Explain what standard time is applicable for operation, A recently negotiat...

A recently negotiated union contract allows workers in a shipping department 24 minutes for rest, 10 minutes for personal time, and 14 minutes for delays for each 4 hours worked. A

Explain levels of management by management skills, Explain levels of Manage...

Explain levels of Management by Management Skills. Management Skills needed successful manager, be categorized as given below: Technical skill refers to the pro

Explain the impact of increasing fuel prices on logistics, Describe the imp...

Describe the impact of increasing fuel prices on logistics network design

How can be a mapping process done, How can be a mapping process done? M...

How can be a mapping process done? Mapping processes can be awkward, long winded and a complicated process as like getting everyone to agree what the procedure looks like along

Industrial production index, Industrial Production Index The measure of...

Industrial Production Index The measure of the combined output of all products like mining, manufacturing, and electric and natural gas utilities organization in the United Sta

Explain the behaviors often incorporated by entrepreneurial, For years, Dav...

For years, David and Evie Wexler of The Little Guys Home Electronics had many ideas about how to improve the home electronics store in which they were working, but could not put th

Explain service quality addresses, 1. Can some please help me with these f...

1. Can some please help me with these fill in's? I am not sure I have the right answers One Way to identidy goals is to identify best practices through a process known as________

Explain the purpose of realistic and contrived tests, Explain the purpose o...

Explain the purpose of realistic and contrived tests as part of the installation of a new system. Both of these tests contribute to a critical activity prior to the changeover

Line Balancing, What do you understand by “line balancing”? What happens if...

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

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