A B C D E 1 F Concessionaire scenario G H 2 3 4 X, = # lb sausage 250 5 X2 = # lb chili 500 6 7 Revenue 2500 8 9 Constraints LHS RHS 10 limited beef slack/surplus 250 = 250 13 chili requirement 0 500 250 250 14 15 16 Microsoft Excel 10.0 Sensitivity Report 17 18 Adjustable Cells 19 Final Reduced 20 Cell Name Objective Allowable Value Allowable Cost Coefficient Increase 21 $B$4 Decrease x 1 = # lb sausage 250 22 $B$5 x 2 = # 1b chili 0 14 500 4 0 w 1E+30 23 1E+30 2.33 24 Constraints 25 Final 26 Shadow Cell Constraint Name Allowable Value Allowable Price R.H. Side Increase 27 $C$10 limited beef LHS Decrease 250 $C$11 0 28 400 limited pork LHS 1E+30 200 150 30 29 $C$12 200 37.5 sausage requireme 25 30 $C$13 250 -14 250 chili requirement L 41.67 500 68.18 0 250 250 1E+30