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

Operation research, six operators are to be assigned to five jobs with the ...

six operators are to be assigned to five jobs with the cost of assignment in Rs. given in the matrix below. determine the optimal assignment. which operator will have no assignment

Explain what is the cheapest cost for meeting, ABC Machine Shop, Inc., has ...

ABC Machine Shop, Inc., has a 1-year contract for the production of 48,000 gear housings for a new off-road vehicle. ABC hopes that the contract will be extended and the production

Productivity -numerically defined, Productivity -Numerically Defined T...

Productivity -Numerically Defined Total factor productivity (TFP) = Pt = Ot/(L+C+R+Q)  Partial factor productivity (PFP) = Ot/L or C or Ot/a combination of  inputs   Pt

What role do alter agents play in the execution of a road, What things shou...

What things should be taken into consideration in the creation of a roadmap for a strategic plan? What are examples of external and internal change agents? What role do change agen

Explain social learning theory explain widespread corruption, How can the s...

How can the social learning theory explain widespread corruption throughout an organization?

Explain factors that are likely to create dramatic turns, Look into the fut...

Look into the future. Consider trends in society, technology, economics, environmentalism, and politics that can influence the future of W. L. Gore & Associates (Case 24) and Googl

Learning teaching and assessment strateg, Learning Teaching and Assessment ...

Learning Teaching and Assessment Strategy: Key lectures will be delivered and immediately followed up by group tutorials in which the opportunity to critically reflect, analys

Explain vroom model leadership, Compare and contrast, the three following l...

Compare and contrast, the three following leadership models: Vroom Model leadership, Fiedler`s Contingency Model and Hersey & Blanchard Situational Theory?

Compute present value of cash flow stream by interest rates, Calculate the ...

Calculate the present value of the cash flow stream in problem 2 with the following interest rates- 1. Year 1 = 8% 2. Year 2 = 6% 3. Year 3 = 10% 4. Year 4 = 4% 5. Year 5 = 6% 6. Y

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

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