please help. Here 's the senstivity report and the questions related to it.

i) In the optimal strategy, how many pounds of stock X, Y, Z will be purchased, respectively? What is the minimum cost for the ranch?

ii) What would be the optimal solution if the cost of stock X increases to $2.5? What would be the minimum total cost with such an increase? Must explain how you arrived to your answer based on the given output. Do not reformulate the LP to find out the implication.

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.

Microsoft Excel 16.53 Sensitivity Report Worksheet: [Contractor_Homework1 (version 1).xlsb]Problem 3 Report Created: 9/21/21 3:12:41 PM Variable Cells Final Reduced Objective Allowable Cell Name Value Cost Coefficient Increase $B$10 x 40 0 200 66.66666667 $C$10 Y 0 100 400 1E+30 $D$10 z 0 150 250 1E+30 Allowable Decrease 200 100 150 Constraints Final Shadow Constraint Cell Name Value Price R.H. Side $B$15 Nutrients 120 0 64 $B$16 Nutrients 100 80 $B$17 Nutrients 16 $B$18 Nutrients 240 0 128 $B$19 Nutrients 0 5 80 40 Allowable Allowable Increase Decrease 56 1E+30 1E+30 37.33333333 1E+30 112 1E+30 1E+30 5 24 OOO