Arnoff Enterprises manufactures the central processing unit (CPU) for a line of personal computers. The CPUs are manufactured in Seattle, Columbus, and New York and shipped to warehouses in Pittsburgh, Mobile, Denver, Los Angeles, and Washington, DC for further distribution. The data below show the number of CPUs available at each plant and the number of CPUs required by each warehouse (these data are available in the Excel worksheet Group Discussion #4 - Dataset.xlsx). The shipping costs (dollars per unit) are also shown.

Arnoff Enterprises would like to find an optimal solution to determine the number of CPUs that should be shipped from each plant to each warehouse to minimize the total transportation cost. Use the techniques explained in Supplement E: Modeling the Transportation Problem to address the following:

2. (10 points) Use Excel Solver to find the optimal solution to minimize the total transportation cost. Provide the screenshot of your Excel Solver's results.

Plant Seattle Columbus New York Demand Pittsburgh $10 $2 $1 3000 Mobile $20 $10 $20 5000 Warehouse Denver Los Angeles Washington Supply $5 $9 $10 9,000 $8 $30 $6 4,000 $7 $10 $4 8,000 4000 6000 3000