Please use Solver and Sensitivity report in excel to show how to solve. Thank you in advance!

Given: Decision Variables: W=gallons of white wine to purchase and use in the production of a wine cooler blend R=gallons of rose wine to purchase and use in the production of a wine cooler blend F=gallons of fruit juice to purchase and use in the production of a wine cooler blend S=gallons of special ingredient to purchase and use in the production of a wine cooler blend Objective function: MAX: 6.00W + 7.10R + 6.35F + 4.82S Subject to: Constraints: C1 (use at least 40% white wine): C2 (use at least 25% rose wine): C3 (use no more than 33% fruit juice): C4 (use at least 10% special): C5 (Max. available white): C6 (Max. available rose): C7 (Max. available fruit juice): C8 (Max. available special): C9 (non-negativity): 0.60W -0.40R-0.40F -0.40S > 0 -0.25W + 0.75R-0.25F -0.25S > 0 -0.33W -0.33R +0.67F -0.335 0 1W 0 After running your Solver model and generating a sensitivity report, you must answer the questions listed below in your Excel file. (Continued on next page) Problem 2 - Part a) Use the Sensitivity Report that you generated and refer to your original answer. Assume that we will increase the value of the coefficient of W to $6.45: Amount of the Increase equals what value? The Allowable Increase equals what value? Is this change within the Allowable Increase? What will the new objective function value equal? Problem 2 - Part b) Use the Sensitivity Report that you generated and refer to your original answer. Assume that we will decrease the right-hand-side value of C5 to 24,800: Amount of the Decrease equals what value? The Allowable Decrease equals what value? Is this change within the Allowable Decrease? What will the new objective function value equal