Please use excel solver to solve this problem.

2. Drylce, Inc., is a manufacturer of air conditioners that has seen its demand grow significantly. The company anticipates nationwide demand for the next year to be 180,000 units in the South, 120,000 units in the Midwest, 110,000 units in the East, and 100,000 units in the West. Managers at Drylce are designing the manufacturing network and have selected four potential sitesNew York, Atlanta, Chicago, and San Diego. Plants could have a capacity of either 200,000 or 400,000 units. The annual fixed costs at the four locations are shown in Table 5-50, along with the cost of producing and shipping an air conditioner to each of the four markets. Where should Drylce build its factories and how large should they be? Table 5-5 Production and Transport Costs for Drylce, Inc. New York Atlanta Chicago San Diego Annual fixed cost of 200,000 plant $6 million $5.5 million $5.6 million $6.1 million Annual fixed cost of 400,000 plant $10 million $9.2 million $9.3 million $10.2 million East $211 $232 $238 $299 South $232 $212 $230 $280 Midwest $240 $230 $215 $270 West $300 $280 $270 $225