Our current distribution center (DC) is closing.

Demand for twelve months

City	Demand
1. Amarillo	3700
2. Austin	1200
3. Brownsville	7800
4. Lubbock	3400
5. Dallas	9600
6. Fort Worth	700
7. Waco	800
8. Houston	2100
9. Galveston	1400
10. Corpus Christi	7100
11. S. Padre Island	7700
12. Laredo	3400
13. San Antonio	3000
14. El Paso	8500
15. Odessa	4200
16. Midland	1200

1. identify two new possible locations for distribution centers.

Assumptions

Assign no more than 10 stores to one DC

-Texarkana = 10 & Huntsville 6

-Texarkana = 8 & Huntsville 8

-Texarkana = 6 & Huntsville 10

- Assume 200 units per truck

- Assume fixed cost of $100 per truck

- Assume variable cost $0.50 per mile

-Texarkana to Amarillo = 491 miles (Google maps)

Include

DC locations

Which customers are served by which DC

Total Cost

Spreadsheet showing how total cost is calculated

You need to calculate the costs for a round-trip

- Austin to El Paso and El Paso back to Austin)

The DCs should be within 5 miles of an interstate.

Town/city must have a population on 10,000 so we can find enough employees to work the DC.

Where are nisr ristomers? City 1. Amarillo 2. Austin 3. Brownsville 4. Lubbock 5. Dallas 6. Fort Worth 7. Waco 8. Houston 9. Galveston 10. Corpus Christi 11. S. Padre Island 12. Laredo 13. San Antonio 14. El Paso 15. Odessa 16. Midland The DCs should be within 5 miles of an interstate