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

Observation of competitor market activities, How can intelligence on compet...

How can intelligence on competitors' strategies best be gathered? A. Observation of their market activities. B. Tracking of their service volumes and market share. C. A & B.

Human resource manager for a coordinated system, You have been named human ...

You have been named human resource manager for a company that has 180 employees and no formal base pay system. What steps will you take to develope such a coordinated system?

Tracing a loop, Tracing a loop: When a closed loop is to be traced start wi...

Tracing a loop: When a closed loop is to be traced start with the empty cell which is to be evaluated ( or to be included in the solution ). Then moving clockwise draw an arrow fro

Elements of operations management, Elements of Operations Management ...

Elements of Operations Management 1. Planning  This is the setting of appropriate courses of action to achieve the systems objectives.  2. Organising  This is the

Describe how cultural diversity can affect the functioning, Explain how cul...

Explain how cultural diversity can affect the effective functioning of virtual teams operating in a global economy Assess a company's marketing strategy, with a focus on marketing

How many cells must be used to represent each constraint, In excel how many...

In excel how many cells should be used to represent each constraint?

Explain the internal and external environments, Describe the internal and e...

Describe the internal and external environments of 2 real world companies using an environmental scan. What competitive advantages does each company have and what strategies are ea

Control charts for variables, Control Charts for Variables  Two comple...

Control Charts for Variables  Two complementary charts are commonly used for the statistical control of process variables. One controls the process mean by monitoring the mean

#titCAREING FOR TODDLERle.., HOW TO CARE FOR A TODDLERn #Minimum 100 words ...

HOW TO CARE FOR A TODDLERn #Minimum 100 words accepted#

Explain the current organizational culture, Using the competing values fram...

Using the competing values framework as a point of reference, how would you describe the current organizational culture? Provide examples to support your conclusions.

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