Answer 6.3 not 6.2, please use Excel Solver

figure 6.3:

6.2.* Consider the transportation problem having the unit shipping costs shown in the following table. Destination 2 Supply Source 1 6 7 4 40 2 5 8 6 60 Demand 30 40 30 a. Formulate a network model for this problem as a minimum-cost flow problem by drawing a network similar to Figure 6.3. b. Formulate and solve a spreadsheet model for this problem. 6.3. Reconsider Problem 6.2. Suppose now that the demand at each of the destinations has been reduced by 10, so that the new demands are 20, 30, and 20 at destinations 1, 2, and 3, respectively. Introduce a dummy destination in order to satisfy the feasible solutions property and then repeat parts a and b to determine how much each source should supply to each destina- tion for this new version of the problem, a. Formulate and solve a spreadsheet model for this problem without introducing a dummy destination. 1 3 b. Now convert this problem into a minimum-flow cost flow problem by introducing a dummy desti- nation and making the other needed adjustments. Then draw a network similar to Figure 6.3 for this minimum-cost flow problem.) c. Formulate and solve a spreadsheet model for the minimum-cost flow problem obtained in part b. Then compare the resulting optimal flow plan (while ignoring the flows into the dummy destina- tion) with the optimal flow plan obtained in part a without using a dummy destination. [80] F1 [50] $300 $500 [50] $700 [0] DC $200 [50] $400 [50] [-60] W1 x $1,000 F2 W2 [70] [-90] FIGURE 6.3 A network model for the Distribution Unlimited Co. problem as a minimum-cost flow