The following is the Excel sensitivity analysis report: Final Objective Allowable Allowable Cell Name Value Coefficient Increase Decrease $B$2 Z345-Stand 22.94 400.00 316.00 100.54 $C$2 Z345-Indust 0.00 560.00 103.30 Infinity $D$2 W250-Stand 22.94 500.00 106.23 154.33 $E$2 W250-Indust 45.87 700.00 268.49 97.91 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$4 Zinc 2500.00 21.10 2500.00 492.16 320.00 $F$5 Iron 2339.45 0.00 2800.00 Infinity 460.55 $F$6 Min Z345 22.94 0.00 0.00 2.94 Infinity $F$7 Industrial Minimum 45.87 179.82 0.00 17.78 14.02 $F$8 Max Z345 22.94 0.00 Infinity 45.87 $F$9 Max W250 68.81 289.91 0.00 3.20 21.19 Answer the following questions (each question independently): a. The maximum profit is not shown above. Use the information above, and show the profit calculation. b. The profit on Z345 - Industrial is increasing by 15%! These good news made a consultant to the company recommend Kelly increases the production of Z345. Is the consultant correct? Explain. c. Management decided to buy additional 100 pounds of zinc on top of the original 2500 pounds at a cost of $3 per pound. i. What will be the net total profit? Show your work without rerunning. Explain why you can answer the question without the re-run. ii. What is the largest price management should be willing to pay per 1 pound of zinc, if it does not want to lose money on the additional amount bought