Directions for Solver $($with hints$)$:

Determine your Objective Function $($cell you want solver to answer$)$

Determine your Decision Variables $($what do you want Solver to use to calculate your objective$)$

Set your constraints $($see below and convert them to excel language$)$

Fill in the shaded cells.

Constraints: Total shipped from each of the $3$ facilities $$ production capacity of each facility.

Total shipped to each of the $4$ DC$\text{'}$s $=$ Demand for that region.

All shipments $($decision variables$)0($not really needed$)$