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 king henrys impact on the rule of law, Answer the following questio...

Answer the following questions on the Topic of The History of the American Corporation 1. Describe what is the rule of law and its importance on a successful capitalistic socie

Generic operational strategies - operation strategy, Generic Operational St...

Generic Operational Strategies - Operation Strategy Porter (1985) presented five basic generic strategies for business:  1. Cost efficiency - low cost leadership strategy

Determine the order size that will minimize the total cost, You are the Sto...

You are the Stores Manager at the Ministry of Information and you have the responsibility of managing store room No. 101 where all blank papers for this Ministry are kept. The ann

Order qualifiers - operations strategy, Order Qualifiers - Operations Strat...

Order Qualifiers - Operations Strategy These are not essential to winning business in their own right. They may however, determine the entry level whereby the organisation is

Explain cellular production is often conducted in a u-shaped, Cellular prod...

Cellular production is often conducted in a U-shaped (horseshoe-shaped) cell, rather than the rectangular cells shown in Figure 2.7b. What might be the advantages of this U shape?

Explain what will be her new productivity, Lori produces "Final Exam Care P...

Lori produces "Final Exam Care Packages" for resale by her sorority. She is currently working a total of 5 hours per day to produce 100 care packages. a) What is Lori's productivit

Production process, with the help of a diagram, describe the production pro...

with the help of a diagram, describe the production process.

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