Solve with excel: Problem

$2$

$-$

$$Network Design problem

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

$1$

$8$

$0$

$,$

$0$

$0$

$0$

$$units in the South,

$1$

$2$

$0$

$,$

$0$

$0$

$0$

$$units in the Midwest,

$1$

$1$

$0$

$,$

$0$

$0$

$0$

$$units in the East, and

$1$

$0$

$0$

$,$

$0$

$0$

$0$

$$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

$2$

$0$

$0$

$,$

$0$

$0$

$0$

$$or

$4$

$0$

$0$

$,$

$0$

$0$

$0$

$$units$.$ The annual fixed costs at the four locations are shown in Table

$1$

$.$

$1$

$$and Table

$1$

$.$

$2$

$,$

$$along with the cost of producing and shipping an air conditioner to each of the four markets. Formulate the problem as a linear programming model to decide where DryIce should build its factories and their capacities. You do Not need to solve it

$.$

Production and transport costs for DryIce Inc.Table $1\mathrm{.}1$ Demand Region

Table $1\mathrm{.}2$ Plant Option