Capacitated Plant Location Model The supply chain team used Excel's Solver program to arrive at the lowest-cost network design shown in Figure 1. Which supply region will not contain a facility? 1 2 3 45778 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 A Inputs-Costs, Capacities, Demands Supply Region N. America S. America Europe Asia Africa Demand Decision Variables Supply Region N. America S. America Europe Asia Africa Constraints Supply Region N. America S. America Europe Asia Africa C Unmet Demand 13 81 117 102 115 142 Demand Region Production and Transportation Cost per 1,000,000 Units N. America S. America Europe Asia Africa D 0 0 0 13 0 Objective Function ($1,000) Cost- S 39,710 92 85 90 125 100 21 Cost Data ($1,000) Excess Capacity 0 0 0 1 8 N. America S. America 0 E 0 20 0 0 1 0 101 122 77 144 133 20 Demand Region - Production Allocation (1000 Units) N. America S. America Europe Asia Africa 0 0 20 0 0 F Europe Asia 0 Figure 1: Capacitated Plant Location Model 130 98 92 84 105 16 0 0 G 0 16 0 0 115 100 89 74 71 11 Africa 0 0 0 0 11 0 H Low Fixed Cost ($) Capacity 6,000 4,500 6,500 4,100 4,000 10 10 10 10 10 Low Capac High Capad Plants Plants (1-open) (1-open) 0 0 0 1 0 0 1 1 1 Fixed Cost ($) 9,000 6,750 9,750 6,150 6,000 K High Capacity 20 20 20 20 20

Capacitated Plant Location Model The supply chain team used Excel's Solver program to arrive at the lowest-cost network design shown in Figure 1. Which supply region will not contain a facility? Figure 1: Capacitated Plant Location Model