Excel solver

Distribution Center Cincinnati St. Louis $ 16.88 Retail Stores South Terre Haute Indianapolis Ft. Wayne Bend $ $ 12.60 $ 13.88 15.38 15.38 $ $ 8.48 $ 12.75 12.75 14.25 $ $ $ 5.10 $ 7.88 10.88 13.13 $ $ 10.35 $ 14.63 14.63 16.13 Evansville $ 19.13 Bloomington $ 17.63 Dayton, OH $ 13.88 Adjust your constraints to the following: The maximum the distribution centers can supply is as follows: St. Louis 300, Evansville, 200, Bloomington 250, Dayton 150 The demand required from the retailers is as follows: Terre Haute 230, Indianapolis 170, Ft. Wayne, 140, South Bend 210, Cincinnati 150. The objective will be to minimize cost in solver. Find the shipping costs for Terre Haute, Indianapolis, Ft. Wayne, South Bend and Cincinnati. Note, these are calculations you have to add onto your spreadsheet