Present a table showing how sensitive Paul's loading strategy is to the profit per ton for each type of cargo. Which cargo's profit per ton is the loading strategy most sensitive to? Why? Please observe the table given here, especially allowable increase and allowable decrease.

 

Transcribed Image Text:

5 69 6 Variable Cells 8 9 10 11 12 13 Cell Name $B$6 Number to Make X1 $C$6 Number to Make X2 $D$6 Number to Make X3 $E$6 Number to Make X4 Final Value 4800 5000 325 1700 Reduced Objective Cost Coefficient 0 0 0 0 70 50 60 80 Allowable Increase 1E+30 1E+30 25.71428571 1E+30 Allowable Decrease 30 15 60 25 5 69 6 Variable Cells 8 9 10 11 12 13 Cell Name $B$6 Number to Make X1 $C$6 Number to Make X2 $D$6 Number to Make X3 $E$6 Number to Make X4 Final Value 4800 5000 325 1700 Reduced Objective Cost Coefficient 0 0 0 0 70 50 60 80 Allowable Increase 1E+30 1E+30 25.71428571 1E+30 Allowable Decrease 30 15 60 25 5 69 6 Variable Cells 8 9 10 11 12 13 Cell Name $B$6 Number to Make X1 $C$6 Number to Make X2 $D$6 Number to Make X3 $E$6 Number to Make X4 Final Value 4800 5000 325 1700 Reduced Objective Cost Coefficient 0 0 0 0 70 50 60 80 Allowable Increase 1E+30 1E+30 25.71428571 1E+30 Allowable Decrease 30 15 60 25