Question

There are six cities (cities 1-6) th Kilroy County. The county must deicrmine where to build fire stations. The county wants to build the minimum number of fire stations needed to ensure that at least one fire station is within 15 minutes (driving time) of each city. The times (in minutes) required to drive between the cities in Kilroy County are shown in Table 6, Formulate an IP that will tell Kilroy how many fire stations should be built and where they should be located. City I o 1020 30 30 City 2 10 25 35 20 City 3 20 25 15 30 20 City 4 30 355 0 5 25 City 5 30 20 30 1 10 15 5 20 15 5 20 20iss20
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Within 15 Minutes
City 1 1, 2
City 2 1, 2, 6
City 3 3, 4
City 4 3, 4, 5
City 5 4, 5, 6
City 6 2, 5, 6

min z = x1 + x2 + x3 + x4 + x5 + x6

From the table above the constraints are formulated below.

s.t. x1 + x2 >= 1 (City 1 constraint)

s.t. x1 + x2 + x6 >= 1 (City 2 constraint)

s.t. x3 + x4 >= 1 (City 3 constraint)

s.t. x3 + x4 + x5 >= 1 (City 4 constraint)

s.t. x4 + x5 + x6 >= 1 (City 5 constraint)

s.t. x2 + x5 + x6 >= 1 (City 6 constraint)

xi 0 or 1 (i 1, 2, 3, 4, 5, 6)

Solving this using Excel Solver,

K L M City 1 City 2 City 3 City 4 City 5 City 6 Variables Obiective SUM(C4:H4 Constraints City 1 City 2 SUMPRODUCT(C9:H9,$C$4:SHS4) |>= SUMPRODUCT(C10:H10,$C$4:$H$4)1 SUMPRODUCT(C11:H11,$C$4:SH$4)|>= | 1 SUMPRODUCT (C12:H12,$C$4:$H$4)1 SUMPRODUCT(C13:H13,$C$A:$H$4)1 SUMPRODUCT(C14:H14,$C$4:$H$4)1 0 0 0 12 0 0 0 0 15 16

The minimum fire station required is 2, and should be placed at City 2 & City 4.

Add a comment
Know the answer?
Add Answer to:
There are six cities (cities 1-6) th Kilroy County. The county must deicrmine where to build...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Six housing subdivisions within a city area are targeted for emergency service by a centralized f...

    Six housing subdivisions within a city area are targeted for emergency service by a centralized fire station. Where should the new fire station be located such that the maximum rectilinear travel distance is minimized? The centroid location of the subdivision are as follows: (5 points) Subdivision x-coordinate y coordinate 20 25 13 15 25 32 14 21 8 D25 4 18 Six housing subdivisions within a city area are targeted for emergency service by a centralized fire station. Where should...

  • A new large scale senior community is being developed, and one of the decisions to be...

    A new large scale senior community is being developed, and one of the decisions to be made is where to locate the two fire stations that have been allocated to the community. For planning purposes, the community has been divided into five tracts, with no more than one fire station to be located in any given tract. Each station is to respond to all of the fires that occur in the tract in which it is located as well as...

  • Facility Location Problem The X county supervisor's board has decided that a new volunteer fire station...

    Facility Location Problem The X county supervisor's board has decided that a new volunteer fire station and ambulance facility needs to be built in the county. The county has 30 rural towns that need to be served. A 10 X 10 mile grid has been overlaid on the county map and each of the towns assigned a set of X Y coordinates. The coordinates of each town along with the expected number of annual trips to each are shown in...

  • QUESTION 1 Anna the Audiophile has asked for your help to build an amplifier and filter...

    QUESTION 1 Anna the Audiophile has asked for your help to build an amplifier and filter to take small signals from her hifi system and amplify them so that she can drive her new subwoofer. The hifi system produces AC signals at varying frequencies with 250mVrms maximum magnitude Her subwoofer requires the signals to be 20 Vrms maximum magnitude. The signals that Anna is interested in are below 200 Hz. She would like the filter to attenuate signals at frequencies...

  • Question 6 After a problem and its symptoms have been identified, a theory regarding a probable...

    Question 6 After a problem and its symptoms have been identified, a theory regarding a probable cause should be established. True False 1.25 points Question 7 An open electrical circuit as a result of a failed circuit breaker is considered to be what type of failure system? a. fail-tolerant b. fail-close c. fail-open d. fail-dynamic 1.25 points Question 8 At what layer of the OSI model do the IP, ICMP, and ARP protocols operate? a. Application b. Session c. Transport...

  • Earthquake Lab: Locating the Epicenter, Determining the Magnitude, and Calculating the Time of Earthquake The goal...

    Earthquake Lab: Locating the Epicenter, Determining the Magnitude, and Calculating the Time of Earthquake The goal of this lab is to learn how seismograms are used to locate the epicenter of earthquakes, determine earthquake magnitudes, and to calculate the origin time of earthquakes. A seismogram measures the amount of shaking caused by earthquake waves. The seismogram first records the arrival of P-Waves (Primary), followed by the arrival of the S-Waves (Secondary). The S-P interval is the time difference between the...

  • 1) Come up with a single (one) question or problem 2) Think of an example with 30 data points a. ...

    1) Come up with a single (one) question or problem 2) Think of an example with 30 data points a. This data needs to be of a quantitative variable (numbers). 3) Then proceed to follow the below steps. example of 30 quantitative data points Purpose State how, when, and where data was collected List of raw data pairs Frequency distribution (table) Histogram Relative percentage polygon Sample mean Sample median Sample mode(s) Sample range Sample variance Sample standard deviation Coefficient of...

  • The chief ranger of the state's Department of Natural Resources is considering a new plan for...

    The chief ranger of the state's Department of Natural Resources is considering a new plan for fighting forest fires in the state's forest lands. The current plan uses eight fire-control stations, which are scattered throughout the interior of the state forest. Each station has a four-person staff, whose annual compensation totals $200,000. Other costs of operating each base amount to $100,000 per year. The equipment at each base has a current salvage value of $120,000. The buildings at these interior...

  • Swifty Construction Company has entered into a contract beginning January 1, 2017, to build a parking...

    Swifty Construction Company has entered into a contract beginning January 1, 2017, to build a parking complex. It has been estimated that the complex will cost $606,000 and will take 3 years to construct. The complex will be billed to the purchasing company at $896,000. The following data pertain to the construction period. 2019 Costs to date Estimated costs to complete Progress billings to date Cash collected to date 2017 $266,640 339,360 270,000 240,000 2018 $412,080 193,920 545,000 495,000 $617,000...

  • What rates should be charged? Downtown Parking Authority In January a meeting was held in the office of the mayor of Oa...

    What rates should be charged? Downtown Parking Authority In January a meeting was held in the office of the mayor of Oakmont to discuss a unicipal parking facility. The participants included the mayor, the traffic proposca the administrator of Oakmont's Downtown Parking Authority, the city planner, and the finance director. The purpose of the meeting was to consider a report Richard Stockton, executive assistant to the Parking Authority's administrator, concerning estimated costs and revenues for the proposed facility. Mr. Stockton's...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT