Please help to answer the questions at the bottom (analysis of an excel solver solution)

Question 4 (25 points) The following linear programming model is used for maximizing the profit of producing four products (x1, x2, x3, x4), with four resources (two manufacturing processes and two material requirements): max 2 = $50x1 + $58x2 + $52x3 + $62x4 subject to 4x + 3.5x2 + 4.6x2 + 3.9x4 0.50 (x1 + x2 + x3 + x4) X1, X2, X3, X4 20 Sensitivity Analysis for the optimal solution of this problem is shown below: Variable Cells Final Reduced Objective Allowable Allowable Name Value Cost Coefficient Increase Decrease X1 = 9.8706 0 50 11.5335 15.8961 X2 57.0301 0 58 13.2315 15.0886 X3 = 0 -13.5464 52 13.5464 1E+30 X4 = 66.9006 0 62 1E+30 6.3795 Constraints Name Process 1 Usage Process 2 Usage Material A Usage Material B Usage Ratio Final Value 500 296.1176 3132.2658 1500 66.9006 Shadow Price 8.0544 0 0 2.6146 -6.2689 Constraint R.H. Side 500 350 3600 1500 0 Allowable Increase 140.5405 1E+30 1E+30 60.8108 68.0804 Allowable Decrease 19.4805 53.8824 467.7342 329.1139 18.1598 Answer the following questions based on the sensitivity analysis provided above, and include them in your Word/pdf file. a. Which is the most valuable resource to the firm, why? b. One of the four products is not produced in the optimal solution. Which one is that? How much would the minimum profit for this product have to be for it to be produced? C. How much will the total profit increase if the availability of Material A is increased by 200 lbs.? d. If you were given the following two options, which one would you select, why? i. Purchase an additional machine for process 1. The price for the machine is $750 and it can provide an additional 100 hours of process 1. Increase the availability of raw material B up to 1560 lbs. Additional material B can be purchased for $0.5/lb. e. Supplier of Material B has recently informed that they can provide at most 1400 lbs. of Material B. Since you have already paid for the cost of the material, they will refund you the payment for the amount they are not able to fulfill, which is $0.5/lb. Can you make a conclusion on the impact of the decrease in Material B on the profit? If yes, how much will the total profit change? If not, explain why