A1 - fx Inputs - Costs, Capacities, Demands B D D F G H J K N R A 1 Inputs - Costs, Capacities, Demands L L M 0 1. Using Data Analysis Solver, salve the problem to obtain Figure 5-7 2 3 Supply Rorkin 4 N. America 5 S. Amerca 6 Europe 7 Asia 8 Africa 9 Demand 10 11 Decision Variables Durand Regioni Production and Transportation Cost per 1,000,000 N America IS. America Europe Asia Africa 81 92 101 130 115 117 77 108 96 100 102 105 95 119 111 115 90 59 74 142 100 103 105 71 12 14 16 7 Fixed Low Fixed High Cost(s) Capacity Cost 5) Capacity 6,000 10) 9,000 20 4,500 10 6,750 20 6,500 10 9.750 20 4,100 10 8,150 20 4,000 10 6,000 20 Some alternative scenarios to try 1. What if a plant must be built in Europe? In this case add the constraint 1162 1 in Solver and rerun. 2. What if plants must be built in every market? In this case, we need to add constraints 114:18 21 in Solver and rerun. 125 Small Large Demand Region - Production Allocation (1000 Unis Plants Plants Total N. Amenca S. America Europe Asia Africa (1=open (1=open Plants 0 0 0 0 D 0 0 0 0 0 0 D 0 D 0 0 0 D D 0 0 o 9 0 D D D 0 0 0 0 0 Exce83 Capacity 12 13 Supply Region 14 N America 15 S. America 16 Europe 17 Asia 18 Africa 19 20 Constraints 21 Supply Region 22 N. America 23 S. America 24 Europe 25 Asia 26 Africa 27 28 Unmat Demand 29 30 Oblective Function 31 Cast 32 33 N. America S. America Europe Asia Africa Question 40 2 points Save Answer Open the "SunOil.xlsx" Excel file. Select the "Complete" worksheet (under Module 5). Change the demand in South America (S. America) to 80. Solve the model by Solver to obtain optimal allocation and open/close decisions. Which of the regions will not have an open small facility under the optimal solution? O Asia Africa O N. America O South America