Caliente City Fire Station Location Problem: Optimization Exercise, Exercises of Analytical Techniques

excel template for solution, helpful for the subject perspective analytics

Typology: Exercises

2022/2023

Uploaded on 07/17/2023

julianne-centeno
julianne-centeno 🇵🇭

2 documents

1 / 4

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Caliente City Fire Station Location Problem
Fire Station in Tract
1 2 3 4 5 6 7 8
1 2 8 18 9 23 22 16 28
Response 2 9 3 10 12 16 14 21 25
Times 3 17 8 4 20 21 8 22 17
(Minutes) 4 10 13 19 2 18 21 6 12
for a Fire 5 21 12 16 13 5 11 9 12
in Tract 6 25 15 7 21 15 3 14 8
7 14 22 18 7 13 15 2 9
8 30 24 15 14 17 9 8 3
Cost of Station 350 250 450 300 50 400 300 200
($thousands) Number
Covering
1 >= 1
Response 2 >= 1
Time 3 >= 1
<= 4 >= 1
10 5 >= 1
Minutes? 6 >= 1
7 >= 1
8 >= 1
Total
Fire Station in Tract Cost
1 2 3 4 5 6 7 8 ($thousands)
Station in Tract?
pf3
pf4

Partial preview of the text

Download Caliente City Fire Station Location Problem: Optimization Exercise and more Exercises Analytical Techniques in PDF only on Docsity!

Caliente City Fire Station Location Problem

Fire Station in Tract 1 2 3 4 5 6 7 8 1 2 8 18 9 23 22 16 28 Response 2 9 3 10 12 16 14 21 25 Times 3 17 8 4 20 21 8 22 17 (Minutes) 4 10 13 19 2 18 21 6 12 for a Fire 5 21 12 16 13 5 11 9 12 in Tract 6 25 15 7 21 15 3 14 8 7 14 22 18 7 13 15 2 9 8 30 24 15 14 17 9 8 3 Cost of Station 350 250 450 300 50 400 300 200 ($thousands) Number Covering 1 >= 1 Response 2 >= 1 Time 3 >= 1 <= 4 >= 1 10 5 >= 1 Minutes? 6 >= 1 7 >= 1 8 >= 1 Total Fire Station in Tract Cost 1 2 3 4 5 6 7 8 ($thousands) Station in Tract?

Range Name Cells

Range Name Cells

  • CostOfStation D14:K
  • MaxResponseTime B
  • NumberCovering L17:L
  • One N17:N
  • ResponseTime D5:K
  • StationInTract? D29:K
  • TotalCost N
  • CostOfStation D14:K
  • MaxResponseTime B
  • NumberCovering L17:L
  • One N17:N
  • ResponseTime D5:K
  • StationInTract? D29:K
  • TotalCost N