The following data is from a shipping company that needs to find the optimal way to meet the demand of three distribution centers from three warehouse locations where goods are stored. Use the two tables below as your source data to come up with the lowest cost solution for meeting the demand of the distribution centers.

 

(Help: You can copy the data from each table below into your spreadsheet)

Warehouse	Capacity	Dist. Ctr.	Demand
Dallas	350	ABC Storage	250
Houston	600	General Holdings	225
El Paso	200	Ed's Wholesale	275

 

Warehouse	ABD	General	Ed's
Dallas	$2.25	$2.10	$3.25
Houston	$4.50	$4.75	$3.75
El Paso	$3.50	$3.50	$3.50