Please use Excel to answer, the help is greatly appreciated. Thank you.

Drylce Inc.: Drylce, Inc., is a manufacturer of air conditioners that has seen its demand grow significantly. The data file gives information on its suppliers, potential plant and warehouse locations and its customers. Exchange Capacity Fixed cost USA Brazil China UK Japan Rate United $10,000 185 $761 $1,422 $2,161 $1,308| $1,801 $1,431 $2,151 $1,565 $1,380 $1,530 $2,211 $2,322 $1,477 $1,161 $2,423 States $764 $1,538 $1,516 $1,427 $419 $2,200 $1,000 $941 $2,238 $0.90 Germany 475 15,000 1,800,000 $109.45 $4.11 50 Japan Brazil 200 13,000 $988 $70.94 India 80 400,000 Demand 270 200 120 190 100 Management must come up with a plan to decide which facilities are going to be open and how to manage the whole supply chain. 1. Which manufacturing facilities are open? List any unused capacities at the manufacturing facilities. 2. What is the total cost of this supply chain