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

Lean Management, Please can u give me case analysis of Sunwind AB(HBC Case)...

Please can u give me case analysis of Sunwind AB(HBC Case)

Explain simple to state and very difficult to execute, The Assignment is at...

The Assignment is at the same time very simple to state and very difficult to execute. It is designed to allow you to use all the tools of strategy and analysis that you have learn

Iventory control and management, Nuvyug Industries Ltd. Has an annual requi...

Nuvyug Industries Ltd. Has an annual requirement of 5,000 pieces of brake cylinders for its popular brand of golf carts. Each brake cylinder has a carrying cost of ` 25 per unit pe

Auto Parts store manager, Needs to know how to run office affairs and to ha...

Needs to know how to run office affairs and to handle the paperwork of all customers as they come in each day, and take care of the work load of the employees as to setting up the

Compute what is its cost of common equity, The earnings, dividends, and com...

The earnings, dividends, and common stock price of Carpetto Technologies Inc. are expected to grow at 8% per year in the future. Carpetto's common stock sells for $27.75 per share,

Determine the optimal selling price, A manufacturer sells 150 tables a mont...

A manufacturer sells 150 tables a month at the price of $200 each. For each $1 decrease in price, he can sell 25 more tables. Each table costs $125 to make. (a) The demand (pric

Process capability index - asymmetrical positioning, Process Capability Ind...

Process Capability Index - Asymmetrical Positioning of the Process As stated earlier, the C p index assumes that the process mean is centred within the tolerance band, but, i

Explain finite backward scheduling, A process capacity methodology that is ...

A process capacity methodology that is used to show how well parts being produced fit into a range specified by design limits is which of the following? a. Finite backward sche

Fraction defective p chart - control charts for attributes, Fraction Defect...

Fraction Defective P Chart - Control Charts for Attributes This type of chart is used when it is impractical or inconvenient to maintain a constant sample size. Instead of pl

Hidden markov models, Hidden Markov Models: We discussed an example of...

Hidden Markov Models: We discussed an example of determining the most probable state path with the Viterbi algorithm. We also discussed in the class how to calculate the margi

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