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

Factor for plant location choice - availability of transport, Factor for pl...

Factor for plant Location choice - Availability of Transport There are five basic modes of physical transportation air road rail water and pipeline. Goods intended for export

Explain charge of maintaining hospital supplies, Barbara Flynn is in charge...

Barbara Flynn is in charge of maintaining hospital supplies at General Hospital. During the past year, the mean lead time demand for bandage BX-5 was 60 (and was normally distribut

Explain various goods from similar amount of resources, Explain various num...

Explain various numbers of goods as output from similar amount of resources (input) in improving productivity. Management can raise productivity that is management can get vari

Explain type of cost-plus contract provides the seller, Which type of cost-...

Which type of cost-plus contract provides the seller with a guaranteed dollar-value profit rather than as a percentage? Answer Cost-sharing Cost-plus-award-fee Cost-plu

Explain what amount of safety stock is appropriate, Given this information:...

Given this information: Lead-time demand = 630 pounds Standard deviation of lead time demand = 40 pounds (Assume normality.) Acceptable stockout risk during lead time = 4

Explain reliable when choosing health care providers, Look at this website:...

Look at this website: customer satisfaction WHYY news report.mht 1. Do you feel that consumer/patient reviews are reliable when choosing health care providers? 2. Do you feel tha

Explain significant values of an organization, Symbols, stories, and heroes...

Symbols, stories, and heroes are important because they ------------------------ entertain executive level management. Address the concerns of government. Acquaint customers to the

Explain a company''s financial and operational requirements, Decisions abou...

Decisions about pay structure in global companies affects: Answer (1) a company's financial and operational requirements. (2) The cost and availability of qualified workers. (3) Th

Explain optimal number of bookcases are produced, Question: S&V Industries ...

Question: S&V Industries manufactures book cases. Different sizes of cases are kept in inventory. The company has 80 man-hours and 36 pounds of wood available each day. 2 pounds of

Statistical process control - mean and range charts, Statistical Process Co...

Statistical Process Control - Mean and Range Charts 1. SPC can be used as a means of preventing product non-conformance  2. Causes of variability may be categorised as comm

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