Click here for the Excel Data File

Formulate and solve a spreadsheet model for this problem.

a$.$ Determine a distribution plan $($number of truckloads shipped per month from each plant to each warehouse and from each

warehouse to each retail outlet$)$ that will minimize the total shipping cost.

b$.$ Determine the total shipping cost.

$\backslash$table$[[$Total cost$,$S$,464ox$