Note: You are asked to find the optimal shipping schedule that would minimize total transportation cost $($subject to constraints that represent limits on supply and demand$).$

The demand at Portland, St$.$ Paul, LV$,$ Tuscon and Cleveland has to be met by shipments from the $4$ origins.

Formulas for cost minimization, supply and demand are shaded in light blue.

The range B$22$:F$25$ should display the optimal shipping schedule $($optimal solution$)-$you will use Excel's Solver $($more explanations will be provided in class$).$