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

Define goal is to develop a strong talent management program, The goal is t...

The goal is to develop a strong talent management program globally to develop and retain talent that you have been losing to competitors. Discuss the strategies that you might use

Explain what are the issues of management does google needs, What are the i...

What are the issues of management does Google strategy 2010 needs to address? How could they be analysed and evaluated?

List few of the strategic issues in supply chain management, The importance...

The importance of Supply Chain Management cannot be underestimated because it ensures that the right materials are at the right place at the right time at a minimal cost and maximu

Explain what is job evaluation, 1) What is job evaluation? What method(s) o...

1) What is job evaluation? What method(s) of job position evaluation does employer use? Explain why. (Remember, "Job Evaluation" is not the same as "Performance Evaluation.") 2) Wh

Explain the behaviors needed from leaders, Given the new science realities,...

Given the new science realities, write your ropes to know and ropes to skip for leaders, including guidelines for planning, measuring, motivating people, managing change and inform

Define the future values of the following ordinary annuities, Find the futu...

Find the future values of the following ordinary annuities: a. FV of $800 paid each 6 months for 5 years at a nominal rate of 5%, compounded semi-annually. Round your answer to

Activities relating to analysis and control of activities, Activities relat...

Activities relating to analysis and Control of Activities The next problem after the designing of the production system is the analysis and control of the production system. It

Explain project management best practice, Give five potential underlying re...

Give five potential underlying reasons why projects commonly fail. For each potential failure point that you name, identify at least one project management best practice or techniq

20110907, I have already ordered and you all gave me a false link to the re...

I have already ordered and you all gave me a false link to the reference number above. I want my results now. And I want a refund for being late.

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