Question: can you help me with these questions? Table 3. Variable cells sensitivity report for a cost minimization transportation problem with 3 source cities and 5


can you help me with these questions?


Table 3. Variable cells sensitivity report for a cost minimization transportation problem with 3 source cities and 5 destination cities. Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease SB$9 Cincinnati New York 50 0 240 20 80 $C$9 Cincinnati Boston 0 20 300 1E+30 20 SD$9 Cincinnati Chicago 50 0 160 80 220 SE$9 Cincinnati Los Angeles 0 180 500 1E+30 180 SF$9 Cincinnati Dallas 20 360 1E+30 20 $B$10 Denver New York 0 300 420 16+30 300 $C$10 Denver Boston 0 280 440 16+30 280 VI $D$10 Denver Chicago 0 260 300 1E+30 260 SE$10 Denver Los Angeles 50 0 200 100 380 SF$10 Denver Dallas 50 220 180 100 $B$11 Atlanta New York 50 0 300 80 20 SC$11 Atlanta Boston 50 0 340 20 340 SD$11 Atlanta Chicago 0 80 300 1E+30 80 SE$11 Atlanta Los Angeles 0 100 480 1E+30 100 SF$11 Atlanta Dallas 0 0 400 20 180Table 2. Constraint sensitivity report for a cost minimization transportation problem with 3 source cities and 5 destination cities. 25 Constraints 26 Final Shadow Constraint Allowable Allowable 27 Cell Name Value Price R.H. Side Increase Decrease 28 $B$12 LHS New York 100 300 100 0 50 29 $C$12 LHS Boston 50 340 50 0 50 30 $D$12 LHS Chicago 50 220 50 0 50 31 $E$12 LHS Los Angeles 50 380 50 0 32 $F$12 LHS Dallas 50 400 50 0 33 $G$9 Cincinnati LHS 100 -60 100 50 ooooo 34 $G$10 Denver LHS 100 -180 100 0 35 $G$11 Atlanta LHS 100 0 100 1E+30 26
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
