iii) What would be the optimal solution if the cost of stock Z decreases to 80 cents? Must explain how you arrived to your answer based on the given output. Do not reformulate the LP to find out the implication. iv) What will be the total cost if only 80 ounces of ingredient A are required? Must explain how you arrived to your answer based on the given output. Do not reformulate the LP to find out the implication. v) What will be the total cost if 90 ounces of ingredient B are required? Must explain how you arrived to your answer based on the given output. Do not reformulate the LP to find out the implication. Variable Cells Allowable Decrease Final Reduced Objective Allowable Value Cost Coefficient Increase 40 0 2 0.666666667 0 1 4 1E+30 0 1.5 2.5 1E+30 Cell Name $P$6 Objective function X $Q$6 Objective function Y $R$6 Objective function 2 2 1 1.5 Constraints Cell Name $S$10 A minimum requirement LHS (Used) $S$11 B minimum requirement LHS (Used) $S$12 C minimum requirement LHS (Used) $S$13 D minimum requirement LHS (Used) $S$14 Maximum Stock Z LHS (Used) Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 120 0 64 56 1E+30 80 1 80 1E+30 37.33333333 40 0 16 24 1E+30 240 0 128 112 1E+30 0 0 80 1E+30 80