Please slove using solver $in$ excel. please show all steps for excel. Thanks

four proposed plants are $as$ follows:

The company's long$-$range planning group developed forecasts $of$ the anticipated annual demand $at$ the distribution centers $as$ follows.

The shipping cost per unit from each plant $to$ each distribution center $isas$ follows.

constructed $in$ Toledo and $0if$ not, $y_3=1if$ a plant $is$ constructed $in$ Denver and $0if$ not, and $y_4=1if$ a plant $is$ constructed $in$ Kansas City and $0if$ not.$|$

Kansas City Capacity $x_{ij}0$ for all i and $j$ and $y_{1^{\text{'}}},y_{2^{\text{'}}},y_{3^{\text{'}}}{y}_4$$ $

What $is$ the optimal set $of$ plants $to$ open? $(Select$ all that apply.$)$

$$ Detroit Kansas City and $0if$ not.$x_{ij}0$ for all i and $j$ and $y_{1^{\text{'}}}{y}_{2^{\text{'}}},y_{3^{\text{'}}}{y}_{4}OZO$