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 what design capacity would be needed, In a job shop, effective capa...

In a job shop, effective capacity is only 50% of design capacity, and actual output is 80% of effective output. What design capacity would be needed to achieve an actual output of

Explain organizational complexity affect human behaviour, Given the multipl...

Given the multiple components (subsystems) of the organizational system model, organizations might be said to be complex. Drawing from your own work and organizational experiences

Explain unsecured credit and secured credit, Compare and contract unsecured...

Compare and contract unsecured credit and secured credit, and explain the key differences.

Explain cost variance and schedule variances for each task, You are the pro...

You are the project manager for the following project which started Feb. 1st, 2009. It is now March 1sr, 2009. Prepare a monthly status report for February 2009, using the project

Assignment, Hierarchical planning in operations/production management and t...

Hierarchical planning in operations/production management and types of time frames in each hierarchy

Determine the optimal order quantity as well the annual cost, The home good...

The home goods department of a large department store sells 175 units per month of a certain large bath towel. The unit cost of a towel to the store is $2.50 and the cost of placin

What means the problem may be solved with pom, Michael Plumb's job shop has...

Michael Plumb's job shop has four work areas, A, B, C, and D. Distances in feet between centers of the work areas are: A B C D A - 4 9 7 B - - 6 8 C - - - 10 D - - - - means the pr

Explain the consequences of having organizational members, These are TWO di...

These are TWO different short answer discussion questions please answer EACH question in the discussion and list references many motivational theories focus on the motivational qua

Compute the gagne-briggs, Critically evaluate the Gagne-Briggs (Gagne sound...

Critically evaluate the Gagne-Briggs (Gagne sounds like Gone-Yea. Briggs rhymes with "bigs") theory of instructional design Is it complete; what is missing; how would you change i

Explain optimized the websites for taking applications, What are your thoug...

What are your thoughts on this article ?According to an article dated February 24, 2013 in the Tech section USA Today News (electronic issue), many employers maybe missing out on h

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