6 Consider the information in Practice Question 1. Assuming the fixed cost of opening each facility as the following table, use the Excel Solver to find the best supply chain network design when (a) multiple sourcing is allowed, (b) each market can only order from one supplier (Note: Costs are in million dollars). 4 Kentucky Pennsylvania N. Carolina California Fixed Cost ($) 1,200,000 800,000 1,500,000 500,000

Consider the information in Practice Question 1. Assuming the fixed cost of opening each facility as the following table, use the Excel Solver to find the best supply chain network design when (a) multipl sourcing is allowed, (b) each market can only order from one supplier (Note: Costs are in million dollars)