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

Describe can the person do the job, As leaders assess the capabilities of t...

As leaders assess the capabilities of their team members, two questions must be answered to determine how to organize work. These questions are: Can the person do the job? Will he/

Explain styles of leadership are situational and charismatic, The five type...

The five types of leadership styles are most applicable in certain situations. Discuss the applicability of each of the five types in project leadership situations and its usefulne

Explain effects of leadership, The Effects of Leadership on Innovative Prog...

The Effects of Leadership on Innovative Program Implementation. Dove, Maria G.; Freeley, Mary Ellen. Delta Kappa Gamma Bulletin, spring 2011, Vol. 77 Issue 3, p25-32. Read this art

Explain how much water can be transported per hour, The network in figure b...

The network in figure below shows the pipeline transportation system for treated water from the treatment plant to a city water supply system. The arc capacities represent millions

Explain terminals and arrive at a message concentrator, Messages are transm...

Messages are transmitted from low speed terminals and arrive at a message concentrator at a Poisson rate of 600/hr. They are held in a buffer until a hi-speed trunk line is free to

How business leadership accomplishing company objectives, Provide two examp...

Provide two examples of current leaders and describe how they demonstrate their leadership characteristics. What separates these characteristics from management techniques? How eff

Difference among using an exact optimization technique, What is the differe...

What is the difference between using an exact optimization technique and a heuristic to solve a problem?

Explain strategic operational competitive position, A major competitive dim...

A major competitive dimension that forms a company's strategic operational competitive position in their strategic planning is which of the following? Cost or price Focus Automatio

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