2. A transportation network is displayed below for six stores. The shipment cost per unit is also displayed below along each arc. As indicated in the below graph, Store 2 currently has 35 extra units, and Store 3 currently has 30 extra units. Also, Store 4 needs 40 more units, and Store 6 needs 25 more units. Transportation Costs 20 +30 10 12 3. 5 15 10 15 10 13 9 -25 2 6 +35 15 4 -40 5 22 The maximum number of units that can be shipped along each route is displayed in the below graph: Maximum Capacity 3 10. 15 1 3 5 5 20 20 20 15 20 (2 6 20 10 Create a spreadsheet and use Solver to determine whether or not it is possible to ship all of the extra units from Store 2 and Store 3 to Store 4 and Store 6. If it is possible, what is the minimum total transportation cost? If it is not possible, state this in your spreadsheet. Upload your spreadsheet, and be sure to clearly label your answer. Because of population growth, the state of Washington has been given an additional seat in the House of Representatives, making a total of ten. The state legislature, which is currently controlled by the Republicans, needs to develop a plan for redistricting the state. There are 18 major cities in the state of Washington that need to be assigned to 1 of the 10 congressional districts. The table below gives the numbers of registered Democrats and registered Republicans in each city. Each district must contain between 100,000 and 400,000 of these registered voters. Use Evolutionary Solver to assign each city to 1 of the 10 congressional districts in order to maximize the number of districts that have more registered Republicans than registered Democrats. (Hint: Consider using the SUMIF function in Excel; decision variables must be >= 1 and