Consider the screenshot below (if it doesn't display properly, you can download the source spreadsheet from this link) which shows a potential solution for a standard Transportation Planning problem. When it comes time to set up Solver, what solving method should you use? E vival Demand 950 831.25 2375 393.75 1187.5 1543.75 2 B D 1 Aggie Power 2 Distribution Costs 3 Los Angeles Tulsa Seattle 4 Seattle $ 356.25 s 593.75$ 59 38 5 Portland 356.25 $ 593.75 s 178.13 6 San Francisco $ 178.13 $ 475.00 S 296.88 7 Boise s 356.25 S 475.00 $ 296.88 12 Flagstaff $ 178.13 $ 475.00 $ 593.75 13 Durango $ 356.25$ 296.88 $ 593.75 14 15 Supply Available 3000 3000 3000 16 17 Distribution Plan 18 Los Angeles Tulsa Seattle 19 Seattle 950.00 0.00 0.00 20 Portland 831 25 0.00 0.00 21 San Francisco 121873 1156.25 0.00 22 Boise 0.00 593.75 0.00 27 Flagstaff 0.00 1187150 0.00 28 Durango 10.00 6230 1481 25 29 30 Total 300000 3000 00 148123 3 Relation 32 Supply Available 3000 3000 3000 33 Tol Cost 53.145 019 33 Total 950.00 831 25 2375.00 393.75 1187.50 1543.75 Relation Demand 950 831 25 2375 $93.75 11875 1343.75 3000 3000 3000 14 15 Supply Available 16 17 18 19 Seattle 20 Portland 21 San Francisco 22 Boise 27 Flagstaff 28 Durango Distribution Plan Los Angeles Tulsa 950.00 0.00 831.25 0.00 1218.75 1156.25 0.00 393.73 0.00 1187.50 0.00 62.50 Seattle 0.00 0.00 0.00 0.00 0.00 1481.25 Total 950.00 831.25 2375.00 593.75 1187.50 1543.75 Relation Demand 950 831.25 2375 593.75 1187.5 1543.75 3000.00 3000.00 1481 23 30 Total 31 Relation 32 Supply Available 33 34 Total Cost 3000 3000 3000 S3,145,019.53 Simplex LP GRG Nonlinear Evolutionary Question 18 (2 points) Consider the same decision as before, but now the table below is the Regret table for each decision alternative and state of nature. Determine which decision to select using a Minimax Regret approach. As before, enter a 1 in the blank below for decision 1 and a 2 in the blank for decision 2. 51 53 52 0 0 4. di d2 7 2 0 Your