write my assignment 11847

DryIce, 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 DryIce are designing the manufacturing network and have selected four potential sites—New 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 the following table, along with the cost of producing and shipping an air conditioner to each of the four markets. Where should DryIce build its factories and how large should they be? [Hint: use the Excel template of capacitated plant location model]

Production and Transport Costs for DryIce , InNew YorkAtlantaChicagoSan DiegoAnnual fixed cost of 200, 000 plant$5. 75 million$5 million$5. 9 million$6 . 2 millionAnnual fixed cost of 400, 000 plant$9. 5 million$9. 2 million$9. 7 million$10 . 4 millionEast$ 2 1 1$ 232$255$ 299South$ 242$ 2 12$ 25 5$ 280Midwest$ 240$ 235$ 215$240West$3005 280$ 25 5$ 2 256 .120 points ]