Shipping cost per case

$\backslash$table$[[$Plants$,$Customers,Capacity,$],[$Chicago$,$Cincinnati,Indianapolis,Pittsburgh,$($cases$/$week$)],[$Akron$,$$$1\mathrm{.}70,$$$2\mathrm{.}30,$$$2\mathrm{.}50,$$$2\mathrm{.}15,3500],[$Evansville$,$$$1\mathrm{.}95,$$$2\mathrm{.}35,$$$1\mathrm{.}65,$$$2\mathrm{.}95,4000],[$Demand $($cases$),1200,2000,2500,1400,]]$

iShipping plan

$\backslash$table$[[$Plants$,$Customers$],[$Chicago$,$Cincinnati,Indianapolis,Pittsburgh,Cases shipped out$],[$Evansville$,1,1,1,1,],[$Cases received,$1,1,1,1,],[,,,,,]]$

$(10$ pts$)$ Implement this LP model on a spreadsheet by filling out the colored cells above.

b$.(10$ pts$)$ Find the optimal shipping strategy using Solver. How many cases should be shipped from each plant to each customer?

Fill in YELLOW boxes help