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

Advantages of enterprise resource planning, Advantages of ERP 1.Invento...

Advantages of ERP 1.Inventory Reduction: Through this process it is possible to procure a component as it is needed thereby avoiding cost of carrying it and excessive safety st

Transformation processes - operation function, Transformation Processes - O...

Transformation Processes - Operation Function Here are examples of transforming processes:  Information processing  Organisations which handle large quantities of data

Explain judging a worker not one sexualorienation, Which of the following s...

Which of the following statement concern sexual orientation is true/ 1.sexual orientation is protected by the eeoc/ 2.attitude toward gays a in the workplace are not changing signi

Case Study, Combine your list with the lists of a few other class members a...

Combine your list with the lists of a few other class members and categorize the items under a series of major headings.

Explain why are service typically more difficult to automate, Why are servi...

Why are services typically more difficult to standardize, automate, and make efficient?

Calculate the effectiveness of the police department, Q1. What recommendati...

Q1. What recommendations can you offer Dick Enrico to improve his chances of staying successful for the rest of his career? Normal 0 false fal

Find optimal solution affected, 1. Sydneyville manufactures household and c...

1. Sydneyville manufactures household and commercial furnishings. The office division produces two desks, rolltop and regular. Sydneyville constructs the desks in its plant outside

Determine the dominant operations performance objectives, 1. When an organi...

1. When an organisation is stepping up production or availability of a service what are the dominant operations performance objectives?  Answer: This is a very difficult questio

Explain what is the time between orders, The current order quantity for Pau...

The current order quantity for Paul's Pasta Pinwheels is 200 boxes. The order cost is $4 per order, the holding cost is $0.40 per box per year, and the annual demand is 500 boxes p

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