2. Remember the Sonoma Apple problem in the previous homework. This problem is based on that but realize it is a bit different. The problem was solved in Excel and the sensitivity report is shown below. Answer the following questions based on the sensitivity report. (If a question can't be answered using the sensitivity report say so. You don't need to change the model and solve it.) Variable Cells Cell Name $B$12 Decision Variables x1 $C$12 Decision Variables x2 $D$12 Decision Variables x3 $E$12 Decision Variables x4 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 6000 0 1 0.592592593 1E+30 13555.55556 0 1.2 1E+30 0.470588235 0 -1.777777778 -1 1.777777778 1E+30 1711.111111 0 -1 1E+30 2.352941176 Constraints Final Shadow Value Price 6000 0.111111111 0.422222222 133.3333333 0 -9644.444444 0 16000 1.111111111 Cell Name $F$16 Constraint 1 (Applesauce Demand) Ihs (A_ix) $F$17 Constraint 2 (Apple Juice) Ihs (A_ix) $F$18 Constraints 3 (30% min) Ihs (A_ix) $F$19 Constraint 4 (80% max) Ihs (A_ix) $F$20 Constraint 5 (Budget) Ihs (A_ix) 5000 Constraint Allowable Allowable R.H. Side Increase Decrease 6000 9625 137.9310345 5000 2000 54250 0 133.3333333 1E+30 0 1E+30 9644.444444 16000 400 7700 (a) How many jars of apple sauce and apple juice should Sonoma Apple produce? (b) How much money should Sonoma Apple allocate for each product type? (c) What is the profit of the optimal solution? (d) Which constraints are non-binding? (e) What would happen if the max demand for applesauce is increased to 8000? (f) What would happen if the max demand for apple juice is increased to 8000? (g) What would be the value of having $1000 more budget? (h) How much would Sonoma Apple lose if there is $1000 less budget? 2. Remember the Sonoma Apple problem in the previous homework. This problem is based on that but realize it is a bit different. The problem was solved in Excel and the sensitivity report is shown below. Answer the following questions based on the sensitivity report. (If a question can't be answered using the sensitivity report say so. You don't need to change the model and solve it.) Variable Cells Cell Name $B$12 Decision Variables x1 $C$12 Decision Variables x2 $D$12 Decision Variables x3 $E$12 Decision Variables x4 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 6000 0 1 0.592592593 1E+30 13555.55556 0 1.2 1E+30 0.470588235 0 -1.777777778 -1 1.777777778 1E+30 1711.111111 0 -1 1E+30 2.352941176 Constraints Final Shadow Value Price 6000 0.111111111 0.422222222 133.3333333 0 -9644.444444 0 16000 1.111111111 Cell Name $F$16 Constraint 1 (Applesauce Demand) Ihs (A_ix) $F$17 Constraint 2 (Apple Juice) Ihs (A_ix) $F$18 Constraints 3 (30% min) Ihs (A_ix) $F$19 Constraint 4 (80% max) Ihs (A_ix) $F$20 Constraint 5 (Budget) Ihs (A_ix) 5000 Constraint Allowable Allowable R.H. Side Increase Decrease 6000 9625 137.9310345 5000 2000 54250 0 133.3333333 1E+30 0 1E+30 9644.444444 16000 400 7700 (a) How many jars of apple sauce and apple juice should Sonoma Apple produce? (b) How much money should Sonoma Apple allocate for each product type? (c) What is the profit of the optimal solution? (d) Which constraints are non-binding? (e) What would happen if the max demand for applesauce is increased to 8000? (f) What would happen if the max demand for apple juice is increased to 8000? (g) What would be the value of having $1000 more budget? (h) How much would Sonoma Apple lose if there is $1000 less budget