C10 B E F G H J K L M N o 1 2 Shipping Cost - ALPHA Market B 53 Market C Total Available 60 900 65 1500 45 1100 60 64 1500 1000 3 Cost ($) per appliance Market A 4 Plant 1 71 5 Plant 2 48 6 Plant 3 52 7 Total Demand 800 8 9 Market A 10 Plant 1 11 Plant 2 12 Plant 3 13 Total Received ALPHA Logistics has submitted a bid which details the costs to ship a unit from each plant to each market given in the table in the "ALPHA worksheet. The table also includes the total monthly production volume at each plant and the total demand in each market. Use Excel Solver to determine the optimal total transportation cost in dollars if Avery Appliances hires ALPHA Logistics. Market B Market C Total Shipped Available = >= 15 Total Demand 16 17 Total Cost ($) Enter the optimal total transportation cost if using ALPHA Logistics rounded to the nearest dollar: $ 18 19 20 21 Avery - ALPHA v2 Avery - OMEGA v2 Avery - BOTH v2 + 100%