Variable Cells Final Reduced Value Cost 400 0 0 2 0 0 1 1 2 Cell Name $B$5 Solution Values XA1 $C$5 Solution Values XA2 $D$5 Solution Values XA3 $E$5 Solution Values XA4 $F$5 Solution Values xB1 $G$5 Solution Values xB2 $H$5 Solution Values xB3 $I$5 Solution Values XB4 $J$5 Solution Values xC1 $K$5 Solution Values xC2 $L$5 Solution Values xC3 $M$5 Solution Values xC4 0 0 500 300 Objective Allowable Allowable Coefficient Increase Decrease 5 2 5 8 1E+30 2 4 2 9 1E+30 5 1E+30 2 4 2 6 2 2 6 3 10 1E+30 8 11 1E+30 8 9 1E+30 8 5 3 1E+30 0 0 1 0 1 0 8 0 0 8 0 200 8 0 Constraints 500 Final Shadow Value Price 400 5 6 300 4 200 8 400 0 800 -2 200 -3 Cell Name $N$11 Retail 1 LHS $N$12 Retail 2 LHS $N$13 Retail 3 LHS $N$14 Retail 4 LHS $N$8 Factory A LHS $N$9 Factory B LHS $N$10 Factory C LHS Constraint Allowable Allowable R.H. Side Increase Decrease 400 100 400 500 100 0 100 0 200 100 0 500 1E+30 100 800 0 100 200 0 100 300 XA2 143 1A4 XB1 B2 XB4 XC1 XC2 C3 XC4 TC) 5,600 Decision Variables Objective Function Solution Values 5 4 9 4 XB3 2 300 10 9 5 0 5 6 0 11 0 400 0 0 500 0 0 200 XA2 A3 A4 XB1 EB2 xB3 XB4 C1 xC2 xC3 XC4 1 1 1 Slack 100 0 1 1 1 1 1 1 0 Factory A Factory B Factory C Retail 1 Retail 2 Retail 3 Retail 4 LHS RHS 400 500 800 800 200