P19 fx A B C D E F G H 1 Capacitated Location 2 J K L M N 3 Atlanta Birmingham Columbia Jackson Jacksonville Louisville Memphis Miami Nashville New Orlean: Orlando Capacity 4 Atlanta 0.00 0.15 0.21 0.40 0.31 0.42 0.38 0.66 0.25 0.48 0.43 15000 5 Birminghar 0.15 0.00 0.36 0.25 0.46 0.36 0.26 0.75 0.19 0.35 0.55 15000 6 Columbia 0.21 0.36 0.00 0.60 0.30 0.50 0.62 0.64 0.44 0.69 0.44 15000 7 Louisville 0.42 0.36 0.50 0.59 0.73 0.00 0.38 1.09 0.17 0.70 0.86 15000 8 Memphis 0.38 0.26 0.62 0.21 0.69 0.38 0.00 1.00 0.21 0.41 0.78 15000 9 Nashville 0.25 0.19 0.44 0.41 0.56 0.17 0.21 0.91 0.00 0.53 0.69 15000 10 Orlando 0.43 0.55 0.44 0.70 0.14 0.86 0.78 0.23 0.69 0.65 0.00 15000 11 Volume Ne 5000 3000 1400 2200 8800 3000 7800 4400 6800 5800 2200 12 13 14 15 Q2) Southeastern Foods has hired you to analyze their distribution system design. The company has eleven distribution centers, with monthly volumes as listed below. Seven of these sites have warehouses, in terms of the infrastructure available. Information has been compiled showing the cost per carton of shipping from any potential warehouse location to any distribution center. Southeastern has standardized its warehouse design so that all such facilities can handle up to 15,000 cartons in a month. (a) What is the total distribution cost (fixed warehouse costs plus variable distribution cost) for the optimal configuration? (b) Now you learn that the monthly fixed cost for operating one of these ware- houses is estimated at $3600 a month. Southeastern is debating whether to close some of these warehouses to avoid paying the fixed $3600 for each of them. i) Update the problem with the new information. What is the new opti- mal total cost? Hint: Note that we don't need to use every warehouse! If we don't use one, we can save $3600! For this, create a new set of decisions, where you plug 1 if you use the warehouse (and add the $3600 cost to the total), and 0 if you do not. ii) How many warehouses should I use in this case? iii) What is the optimal distribution system? (leave it on Excel for me to see)