Microsoft Excel 16.59 Sensitivity Report Worksheet: [Book1]Sheet3 Report Created: 4/3/22 9:57:58 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$5 Decision Variable X1 0 0.08690312 0.18 1E+30 0.08690312 $D$5 Decision Variable X2 0 0.10150411 0.22 1E+30 0.10150411 $E$5 Decision Variable X3 1.02463054 0 0.1 0.00071795 0.03896 $F$5 Decision Variable X4 0 0.03029885 0.12 1E+30 0.03029885 $G$5 Decision Variable X5 0 0.02034483 0.1 1E+30 0.02034483 $H$5 Decision Variable X6 0 0.05641379 0.09 1E+30 0.05641379 $1$5 Decision Variable X7 0 0.32398358 0.4 1E+30 0.32398358 $J$5 Decision Variable X8 1.24137931 0 0.16 0.00538462 0.07428571 $K$5 Decision Variable X9 0 0.38407882 0.5 1E+30 0.38407882 $L$5 Decision Variable X10 2.97536946 0 0.07 0.03065116 0.00041176 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $0$14 Fat Constraints 9.99014778 0 20 1E+30 10.0098522 $0$15 Cholesterol Constraints 14.8965517 0 30 1E+30 15.1034483 $0$9 Calories Constraints 420 0.00095961 420 120.8 1 $0$10 Iron Constraints 5.02463054 0 5 0.02463054 1E+30 $0$11 Calcium Constraints 400 0.00025616 400 2.5 302 $0$12 Protein Constraints 25.2216749 0 20 5.22167488 1E+30 $0$13 Fiber Constraints 12 0.00032184 12 0.21428571 3.80672269