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

Explain ideas that would increase sales, Your best friend owns a small chil...

Your best friend owns a small children's clothing store located in the downtown area of a community of 50,000 citizens. Business has been slow the past year due the construction of

Explain differences between management and leadership, Suppose you realize ...

Suppose you realize one day that you are dissatisfied with your job. What might you do to improve your situation? What are the basic differences between management and leadership?

Linking strategic & operational change - operation strategy, Linking Strate...

Linking Strategic and Operational Change - Operation Strategy Quinn (1988) criticises those who see strategy formulation and implementation as the 'classic trap' where despite

Explain income levels and income distribution among nations, How do differe...

How do differences in income levels and income distribution among nations affect international businesses?

Operations function in an organisation - method study, Operations Function ...

Operations Function in an Organisation - Method Study  A procedure that has stood the test of time in the study of work entails six steps (often referred to by the acronym, SR

Describe what options does jane have, Incident 2.2 what options does Jane h...

Incident 2.2 what options does Jane have? What influence, if any, would the federal government have in this case?

Explain conflict often contributes to effective decision, Is and Why Confli...

Is and Why Conflict often contributes to effective decision making? Is an why Intuition is a valid approach to decision making in the work place?

Introduction to the operations function, Introduction to the Operations Fun...

Introduction to the Operations Function Firstly, consider the economy where gross domestic product (GDP) has been subdivided into its major divisions which are agriculture, ma

Explain a jet engine has ten components in series, A jet engine has ten com...

A jet engine has ten components in series. The average reliability of each component is 0.998. What is the reliability of the engine? (Round your answer to 3 decimal places, the

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