Build a capacity plan

A B D E F G H 1 J L M N o 1 Demand Region 2 Production and Transportation Cost per 1,00,000 units 3 Supply Region N.America S.America Europe Asia Africa Fixed cost Low Capaci Fixed cost High Capacity 4 N.America 81 92 101 130 115 7000 10 8000 20 5 S.America 117 78 107 98 100 5555 10 6900 20 6 Europe 123 105 95 122 145 6600 10 8900 20 7 Asia 115 125 99 59 74 4100 10 6150 20 8 Africa 142 99 104 105 71 4200 10 5000 20 9 Demand 11 10 15 17 9 10 11 12 Decision Variables 13 Supply Region N.America S.America Europe Asia Africa Low Cap High Cap 14 N.America 0 0 0 0 0 15 S.America 0 0 0 0 0 0 0 16 Europe 0 0 0 0 0 0 0 17 Asia 0 0 0 0 0 0 0 18 Africa 0 0 0 0 0 0 0 19 20 21 Constraints 22 Supply Region Excess Capacity 23 N.America 0 24 S.America 0 25 Europe 0 26 Asia 0 27 Africa 0 28 29 N.America S.America Europe Asia Africa 30 Unmet Demand 11 10 15 17 9 31 32 33 Objective Function 34 0 answer 35 36 build a capcity plan 37 A B D E F G H 1 J L M N o 1 Demand Region 2 Production and Transportation Cost per 1,00,000 units 3 Supply Region N.America S.America Europe Asia Africa Fixed cost Low Capaci Fixed cost High Capacity 4 N.America 81 92 101 130 115 7000 10 8000 20 5 S.America 117 78 107 98 100 5555 10 6900 20 6 Europe 123 105 95 122 145 6600 10 8900 20 7 Asia 115 125 99 59 74 4100 10 6150 20 8 Africa 142 99 104 105 71 4200 10 5000 20 9 Demand 11 10 15 17 9 10 11 12 Decision Variables 13 Supply Region N.America S.America Europe Asia Africa Low Cap High Cap 14 N.America 0 0 0 0 0 15 S.America 0 0 0 0 0 0 0 16 Europe 0 0 0 0 0 0 0 17 Asia 0 0 0 0 0 0 0 18 Africa 0 0 0 0 0 0 0 19 20 21 Constraints 22 Supply Region Excess Capacity 23 N.America 0 24 S.America 0 25 Europe 0 26 Asia 0 27 Africa 0 28 29 N.America S.America Europe Asia Africa 30 Unmet Demand 11 10 15 17 9 31 32 33 Objective Function 34 0 answer 35 36 build a capcity plan 37