In a Word document (or clear handwriting), describe the formulation (identify the decision variables, the objective function and the constraints) for each problem and answer the questions in the problems. It is acceptable to use short notation and/or brief statements to represent the formulation of the problem. Screenshots of the model (use FORMULATEXT to show calculations) and Answer Reports must be included in the Word document. Attached the Excel spreadsheet model for each problem to support your answers. Use formatting (labels, colors, borders) to enhance the readability of your models. 9.5 Locating Warehouses: Southeastern Foods has hired you to analyze their distribution system design. The company has 11 distribution centers, with monthly volumes as listed below. Seven of these sites can support warehouses, in terms of the infrastructure available, and are designated by (W). Center Volume Center Volume Atlanta (W) 5000 Memphis (W) 7800 Birmingham (W) 3000 Miami 4400 Columbia (W) 1400 Nashville (W) 6800 Jackson 2200 New Orleans 5800 Jacksonville 8800 Orlando (W) 2200 Louisville (W) 3000 The monthly fixed cost for operating one of these warehouses is estimated at $3600, although there is no capacity limit in their design. Southeastern could build warehouses at any of the designated locations, but its criterion is to minimize the total of fixed operating costs and variable shipment costs. Information has been compiled showing the cost per carton of shipping from any potential warehouse location to any distribution center. Atl Bir Col Jac Jvl Lvl Mem Mia Nash New Orl Atlanta 0.00 0.15 0.21 0.40 0.31 0.42 0.38 0.66 0.25 0.48 0.43 Birmingham 0.15 0.00 0.36 0.25 0.46 0.36 0.26 0.75 0.19 0.35 0.55 Columbia 0.21 0.36 0.00 0.60 0.30 0.50 0.62 0.64 0.44 0.69 0.44 Louisville 0.42 0.36 0.50 0.59 0.73 0.00 0.38 1.09 0.17 0.70 0.86 Memphis 0.38 0.26 0.62 0.21 0.69 0.38 0.00 1.00 0.21 0.41 0.78 Nashville 0.25 0.19 0.44 0.41 0.56 0.17 0.21 0.91 0.00 0.53 0.69 Orlando 0.43 0.55 0.44 0.70 0.14 0.86 0.78 0.23 0.69 0.65 0.00 a. Build a model for this problem suited to the evolutionary solver. Initialize the model with all warehouses in the configuration. What is the minimum total cost? b. To achieve the cost in (a), which warehouse locations should be used? 5000 3000 1400 2200 8800 Center Volume Atlanta (W) Birmingham (W) Columbia (W) Jackson Jacksonville Louisville(W) Memphis (W) Miami Nashville (W) New Orleans Orlando (W) 3000 7800 4400 6800 5800 2200 Nashville Miami New Orleans Orlando Louisville Jackson Memphis Jacksonville 0.31 Birmingham Columbia 0 0.15 0.48 0.25 0.66 0.43 0.38 0.42 0.4 0.21 0.19 0.55 0.35 0.75 0.26 0.36 0.36 0.25 0.46 0 0.15 0.44 0.69 0.64 0.44 0.62 0.3 0.5 0.6 Cost per Carton Atlanta Atlanta Birmingham Columbia Louisville Memphis Nashville 0 0.21 0.36 0.17 0.86 0.7 1.09 0.38 0.73 0.36 0.42 0.5 0.59 0 0.38 0.41 1 0.21 0.78 0 0.69 0.21 0.26 0.62 0.38 0.69 0 0.53 0.21 0.91 0.17 0.41 0.56 0.25 0.19 0.44 0 0.78 0.69 0.65 0.86 0.14 0.23 0.7 0.43 0.55 0.44 Orlando In a Word document (or clear handwriting), describe the formulation (identify the decision variables, the objective function and the constraints) for each problem and answer the questions in the problems. It is acceptable to use short notation and/or brief statements to represent the formulation of the problem. Screenshots of the model (use FORMULATEXT to show calculations) and Answer Reports must be included in the Word document. Attached the Excel spreadsheet model for each problem to support your answers. Use formatting (labels, colors, borders) to enhance the readability of your models. 9.5 Locating Warehouses: Southeastern Foods has hired you to analyze their distribution system design. The company has 11 distribution centers, with monthly volumes as listed below. Seven of these sites can support warehouses, in terms of the infrastructure available, and are designated by (W). Center Volume Center Volume Atlanta (W) 5000 Memphis (W) 7800 Birmingham (W) 3000 Miami 4400 Columbia (W) 1400 Nashville (W) 6800 Jackson 2200 New Orleans 5800 Jacksonville 8800 Orlando (W) 2200 Louisville (W) 3000 The monthly fixed cost for operating one of these warehouses is estimated at $3600, although there is no capacity limit in their design. Southeastern could build warehouses at any of the designated locations, but its criterion is to minimize the total of fixed operating costs and variable shipment costs. Information has been compiled showing the cost per carton of shipping from any potential warehouse location to any distribution center. Atl Bir Col Jac Jvl Lvl Mem Mia Nash New Orl Atlanta 0.00 0.15 0.21 0.40 0.31 0.42 0.38 0.66 0.25 0.48 0.43 Birmingham 0.15 0.00 0.36 0.25 0.46 0.36 0.26 0.75 0.19 0.35 0.55 Columbia 0.21 0.36 0.00 0.60 0.30 0.50 0.62 0.64 0.44 0.69 0.44 Louisville 0.42 0.36 0.50 0.59 0.73 0.00 0.38 1.09 0.17 0.70 0.86 Memphis 0.38 0.26 0.62 0.21 0.69 0.38 0.00 1.00 0.21 0.41 0.78 Nashville 0.25 0.19 0.44 0.41 0.56 0.17 0.21 0.91 0.00 0.53 0.69 Orlando 0.43 0.55 0.44 0.70 0.14 0.86 0.78 0.23 0.69 0.65 0.00 a. Build a model for this problem suited to the evolutionary solver. Initialize the model with all warehouses in the configuration. What is the minimum total cost? b. To achieve the cost in (a), which warehouse locations should be used? 5000 3000 1400 2200 8800 Center Volume Atlanta (W) Birmingham (W) Columbia (W) Jackson Jacksonville Louisville(W) Memphis (W) Miami Nashville (W) New Orleans Orlando (W) 3000 7800 4400 6800 5800 2200 Nashville Miami New Orleans Orlando Louisville Jackson Memphis Jacksonville 0.31 Birmingham Columbia 0 0.15 0.48 0.25 0.66 0.43 0.38 0.42 0.4 0.21 0.19 0.55 0.35 0.75 0.26 0.36 0.36 0.25 0.46 0 0.15 0.44 0.69 0.64 0.44 0.62 0.3 0.5 0.6 Cost per Carton Atlanta Atlanta Birmingham Columbia Louisville Memphis Nashville 0 0.21 0.36 0.17 0.86 0.7 1.09 0.38 0.73 0.36 0.42 0.5 0.59 0 0.38 0.41 1 0.21 0.78 0 0.69 0.21 0.26 0.62 0.38 0.69 0 0.53 0.21 0.91 0.17 0.41 0.56 0.25 0.19 0.44 0 0.78 0.69 0.65 0.86 0.14 0.23 0.7 0.43 0.55 0.44 Orlando