Please show all steps and solution in excel solver and answer each part. Thanks!!

Assignment 3 Question 1 1. Consider the following LP problem, in which X and Y denote the number of units of products X and Y to produce, respectively: Maximize profit = $5X+$5Y Subject to the constraints 2X+3Y = 0 (nonnegativity) The Excel Sensitivity Report for this problem is shown below. Variable Cells Cell Name Final Value 15.00 10.00 Reduced Cost 0.00 0.00 Objective Coefficient 5.00 5.00 Allowable Allowable Increase Decrease 5.00 1.67 2.50 2.50 $B$4 $C$4 Solution value X Solution value Y Constraints Cell Name Allowabl Final Valu Reduced Objective Cost Coefficient Allowable Decrease e LIT $D$7 $D$8 $D$9 Resource 1 Resource 2 Resource 3 e 60.00 80.00 15.00 1.25 0.63 0.00 60.00 80.00 18.00 Increase 60.00 8.00 1E+30 12.00 40.00 3.00