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

Objectives of routing, Objectives of Routing a. Determining the most fea...

Objectives of Routing a. Determining the most feasible sequence of operations and ensuring that this sequence must be followed. b. Utilizing the physical human resources mate

Cell or group layout - process design, Cell or Group Layout - Process Desig...

Cell or Group Layout - Process Design In the years following World War II a novel form of layout was developed in Eastern Europe, suitable for many small to medium-batch opera

Explain how many people would you expect to be waiting, Suzy, a bartender, ...

Suzy, a bartender, can serve drinks at the average rate of one every 35 sec. During a hot evening recently, the bar was particularly busy and every 45 sec someone was at the bar as

Process focused production system, Process Focused Production System Th...

Process Focused Production System This is a form of production system in which production operations are grouped according to the type of process. In other words, all productio

Explain hygiene factors, Explain Hygiene Factors. Hygiene Factors: Ma...

Explain Hygiene Factors. Hygiene Factors: Maslow's require Hierarchy Theory on Motivation has been modified through Fredrick Herzberg and his contacts. Their research purport

The transformation process model and systems thinkin, #qu1) Using the trans...

#qu1) Using the transformation process model and systems thinking concepts, explain the key operations TGL works. Pay particular attention to flow of materials and the role played

Explain horizontal and vertical equity, Imagine that the U.S. Congress deci...

Imagine that the U.S. Congress decides to completely overhaul the current federal income tax system because of its tremendous complexity and is considering a flat-rate income tax w

Process design, what is process design in operation management

what is process design in operation management

Explain flowchart uses symbols to represent, A process flowchart uses symbo...

A process flowchart uses symbols to represent which of the following?

Explain should wang take the quantity discount, Wang Distributors has an an...

Wang Distributors has an annual demand for an airport metal detector of 1,400 units. The cost of a typical detector to Wang is $400. Carrying cost is estimated to be 20% of the uni

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