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. Plant Seattle Columbus New York Demand Pittsburgh Mobile $10 $20 $2 $10 $1 3000 5000 Warehouse Denver Los Angeles Washington Supply $5 $9 $10 9,000 $8 530 $6 4,000 $7 $10 $4 8.000 4000 6000 3000 $20 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 Supplemente: Modeling the Transportation Problem to address the following: 1. (10 points) Formulate the linear programming model to minimize the total transportation cost. Clearly state your decision variables, objective function, and all constraints. 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. 3. (10 points) According to your results, what is the total transportation cost? How many CPUs should be manufactured in Seattle? How many CPUs should be shipped from New York to the warehouse in Washington? 4. (10 points) The Pittsburgh warehouse has just increased its order by 1,000 units, and Arnoff has authorized the Columbus plant to increase its production by 1,000 units. Do you expect this development to lead to an increase or a decrease in the total transportation cost? Solve for the new optimal solution and provide the screenshot of Excel Solver's results to support your statement