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 sells radio frequency inventory, National Scan, Inc., sells radio f...

National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales (000)Units Feb. 19 Mar. 18 Apr. 10 May. 21 Jun. 16 Ju

Explain system of billing, Suppose you are the manager of an accounts recei...

Suppose you are the manager of an accounts receivable unit in a large company. You are switching to a new system of billing and record-keeping and need to train your three supervis

Ghant for Inventory Control, Hello! I need some help creating a ghant shed...

Hello! I need some help creating a ghant shedule for silo bins. I am harvesting, and I have large grain bins which will be filled depending on how fast we harvest. I also need to

Writing a problem statement, I want help on writing a problem statement for...

I want help on writing a problem statement for my project...

Explain method would you pursue to minimize channel conflict, D-Magic is a ...

D-Magic is a new company that has developed a revolutionary 3D television. It uses a new technology that provides a much sharper and realistic 3D experience than their competitors.

Compute your forecast of profit for a store, The XYZ Paint Shop owns and op...

The XYZ Paint Shop owns and operates a dozen shops in northern Illinois. Their signature paint is diamond polished candy apple red lacquer. Sales (X, in millions of dollars) is rel

Central tendency of sample means, Central Tendency of Sample Means As...

Central Tendency of Sample Means As was shown earlier (Advantages of SPC: feedback, the use of individual output measurements as the basis for process adjustment is inappropr

Explain why should be performed before signing a contract, What due diligen...

What due diligence should be performed before signing a contract?

Explain factors in the operating environment, The model below depicts indus...

The model below depicts industry analysis and a funnel that focuses on remote factor analysis to better understand the impact of factors in Aubrey environment you find the small sa

Public and private service sector - education, Public and Private Service S...

Public and Private Service Sector - Education 1. Life long learning; increased personal cost 2. Increase in competency/vocational qualifications 3. Global study on the

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