Needing help with the change in function value

A farmer is planning the crops that will be planted in the upcoming season. The farmer can get $333.08 per metric ton of soybean, $119.42 per metric ton of barley, $143.80 per metric ton of corn, and $202.64 per metric ton of wheat. The total capacity of the farm is 350 metric tons of product. Based on rising tariffs, at most, the soybeans should constitute 25% of the total crop. Prices for barley and wheat have been declining, so corn should at least be 150 metric tons. a. Solve the linear program using Solver and write the strategy. (10 pts) b. Run a sensitivity analysis and identify the constraints that are binding. (10 pts) C. What is the change in the objective function value if the minimum for corn was 100 metric tons and the farmer acquired land that could produce 50 more metric tons of crop? (10 pts) Soybean Barley Corn Wheat 87.5 0 150 112.5 Total 333.08 119.42 143.8 202.64 73511.5 Max Contraints 1 2 350 = 350 87.5 150 3 1 all contraints are binding 3 b) 4 Variable Cells 7 B Cell Name 9 $B$2 Soybean 10 $C$2 Barley 11 $D$2 Corn $E$2 Wheat Final Reduced Objective Allowable Allowable Value Cost Coefficient increase Decrease 87.5 0 333.08 1E+30 130.44 0 -83.22 119.42 83.22 1E+30 150 0 143.8 58.84 1E+30 112.5 0 202.64 130.44 58.84 12 13 14 Constraints 15 Final Shadow Constraint Allowable Allowable 16 Cell Name Value Price R.H. Side Increase Decrease 17 $F$6 Total 350 235.25 350 1E+30 150 18 $F$7 Total 87.5 130.44 0 112.5 87.5 19 $F$8 Total 150 -58.84 150 112.5 150 20