Question: Question 6 (2 points) Consider the screenshot below (if it doesn't display properly, you can download the source spreadsheet from this link) which shows a

Question 6 (2 points) Consider the screenshotQuestion 6 (2 points) Consider the screenshot

Question 6 (2 points) 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, which of the following is a valid constraint? B D E F G . Distribution Costs Los Angeles Tulsa Seattle S 356.25 593.75 S 59.38 S 356.25$ 593.75 S 178.13 S 178.13 S 475.00 S 296.88 s 356.25 475.00 $ 296.88 $ 178.13 $ 475.00 $ 593.75 S 356.25 S 296.88 $ 593.75 Demand 950 831.25 2375 593.75 1187.5 1543.75 3000 3000 3000 1 Aggie Power 2 3 4 Seattle 5 Portland 6 San Francisco 7 Boise 12 Flagstaff 13 Durango 14 15 Supply Available 16 17 18 19 Seattle 20 Portland 21 San Francisco 22 Boise 27 Flagstaff 28 Durango 29 30 Total 31 Relation 32 Supply Available 33 34 Total Cost Distribution Plan Los Angeles Tulsa 950.00 0.00 831.25 0.00 1218.75 1156.25 0.00 593.75 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.25 3000 3000 3000 $ 3,145,019.53 F19:F28> H19:H28 O B34 > B15:D 15 B30:D30 B32:D32 F19:F28

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!