With the information available at "example 5" sheet in this file facilities data.xlsx 1 , provide the set of raw material suppliers to be opened (type the name with the first capital letters and separated by comma - do not use the word "and". Check your spelling since no credit will be given in case of a typo. Introduce the facilities in the same order as shown in the Excel file. For example: Atlanta, Boston, Denver) . Also, specify the warehouses that will operate in the optimal solution: Report the total transportation plus facility operation costs: Simulataneous Location of plants and warehouses Formulate and solve the transhipment problem using the following data Raw material supplier Baltimore Cheyenne Salt Lake Transportation and production costs ($/unit) Plants Annual Fixed Capacity Atlanta Boston Chicago Denver (#units) cost Million $ $ 100 $ 80 $ 75 $ 140 1,000 $ 1.25 $ 120 $ 180 $ 150 $ 45 1,200 $ 0.80 $ 80 $ 130 $ 120 $ 38 1,500 $ 0.95 3,700 Transp. & Prod. costs ($/unit) Warehouses Capacity Annual Fixed Kentucky Nebraska Arizona (#units) cost Million $ $ 150 $ 190$ 240 900 $ 4.50 $ 175 $ 210 $ 275 600 $ 6.80 $ 165 $ 220 $ 200 1,200 $ 4.90 $ $ 175 $ 120 800 $ 3.50 3,500 Transportation and production costs ($/unit) Retailers Plant Atlanta Boston Chicago Denver 230 Warehouses LA San Antonio Seattle NY Oklahoma City Capacity (#units) Annual Fixed cost Million $ $ 2.50 $ 1.80 $ 3.90 $ $ Kentucky Nebraska Arizona Demand $ $ $ $ 90 $ 80 $ 45 $ 900 70 85 55 500 135 $ 65 95 $ 180 110 $ 220 400 800 Total demand $ $ $ 50 45 55 600 3,200 900 700 1,700 3,300 With the information available at "example 5" sheet in this file facilities data.xlsx 1 , provide the set of raw material suppliers to be opened (type the name with the first capital letters and separated by comma - do not use the word "and". Check your spelling since no credit will be given in case of a typo. Introduce the facilities in the same order as shown in the Excel file. For example: Atlanta, Boston, Denver) . Also, specify the warehouses that will operate in the optimal solution: Report the total transportation plus facility operation costs: Simulataneous Location of plants and warehouses Formulate and solve the transhipment problem using the following data Raw material supplier Baltimore Cheyenne Salt Lake Transportation and production costs ($/unit) Plants Annual Fixed Capacity Atlanta Boston Chicago Denver (#units) cost Million $ $ 100 $ 80 $ 75 $ 140 1,000 $ 1.25 $ 120 $ 180 $ 150 $ 45 1,200 $ 0.80 $ 80 $ 130 $ 120 $ 38 1,500 $ 0.95 3,700 Transp. & Prod. costs ($/unit) Warehouses Capacity Annual Fixed Kentucky Nebraska Arizona (#units) cost Million $ $ 150 $ 190$ 240 900 $ 4.50 $ 175 $ 210 $ 275 600 $ 6.80 $ 165 $ 220 $ 200 1,200 $ 4.90 $ $ 175 $ 120 800 $ 3.50 3,500 Transportation and production costs ($/unit) Retailers Plant Atlanta Boston Chicago Denver 230 Warehouses LA San Antonio Seattle NY Oklahoma City Capacity (#units) Annual Fixed cost Million $ $ 2.50 $ 1.80 $ 3.90 $ $ Kentucky Nebraska Arizona Demand $ $ $ $ 90 $ 80 $ 45 $ 900 70 85 55 500 135 $ 65 95 $ 180 110 $ 220 400 800 Total demand $ $ $ 50 45 55 600 3,200 900 700 1,700 3,300