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 Final Reduced Cell Name Value Cost $B$12 Decision Variables x1 6000 0 Objective Coefficient Increase 1 0.592592593 Allowable Allowable Decrease 1E+30 $C$12 Decision Variables x2 13555.55556 0 1.2 1E+30 0.470588235 $D$12 Decision Variables x3 0 -1.777777778 -1 1.777777778 1E+30 SE$12 Decision Variables x4 1711.111111 0 -1 1E+30 2.352941176 Constraints Final Shadow Constraint Cell Name Value $F$16 Constraint 1 (Applesauce Demand) lhs (A_ix) $F$17 Constraint 2 (Apple Juice) Ihs (A_ix) Price 6000 0.111111111 5000 0.422222222 R.H. Side 6000 5000 Allowable Allowable Increase Decrease 9625 137.9310345 2000 54250 $F$18 Constraints 3 (30% min) lhs (A_ix) $F$19 Constraint 4 (80% max) lhs (A_ix) 133.3333333 0 0 133.3333333 1E+30 -9644.444444 0 0 1E+30 9644.444444 16000 1.111111111 16000 400 7700 $F$20 Constraint 5 (Budget) lhs (A_ix) (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