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 the challenges faced by front-line employees, Discuss how front-lin...

Discuss how front-line employees are critical to customer assessment of service quality. Identify the challenges faced by front-line employees.

Explain research and industrial engineering, What future for Operations ...

What future for Operations Research/Industrial Engineering? In your own words, answer the following questions in an essay: What is this presentation about? What does th

Explain penetrated market, Which market do customers who have purchased and...

Which market do customers who have purchased and are driving Audi automobiles represent? a. Target market b. Available market c. Potential market d.

Compute annual holding cost plus the annual ordering cost, The current orde...

The current order quantity for Paul's Pasta Pinwheels is 200 boxes. The order cost is $4 per order, the holding cost is $0.40 per box per year, and the annual demand is 500 boxes p

Explain fledible cross functional teams, Strategy Highlits 11.2 dicusses th...

Strategy Highlits 11.2 dicusses the informal oranizational structure of W.L.Gore and Associates. Go to the firm's Website (www.gore.com) and review the scope of the firm. a. Wha

Explain improving productivity, Explain Improving Productivity. Improv...

Explain Improving Productivity. Improving Productivity: The production essence is creation of goods, may be by the transformation of raw materials or through assembling vario

Define service and manufacturing organizations, Identify and discuss five d...

Identify and discuss five differences between service and manufacturing organizations.

Depict serializability graphs, Draw serializability (precedence) graphs for...

Draw serializability (precedence) graphs for the following schedules and state whether each schedule is (conflict) serializable. For each serializable schedule, determine the equiv

Explain upper control limit for an r-chart, Twenty samples of subgroup size...

Twenty samples of subgroup size 3 (n=3) were collected for a variable measurement. Determine the upper control limit (UCL) for an R-chart if the mean of the sample ranges equals

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