please do it in excel file

please do it in excel file

1. (40 points) Find the shadow price associated with the third constraint for the problem (1) max inax X+Y subject to 3x +2y 0 Y>0 (1) X+Y subject to 3X + 2Y 1 Y > 0 (Draw the feasible region and corner points using desmos. Insert the images in the excel file. Follow the instructions given in class.) 2. (60 points) What is the optimal solution to the following problem. If any of the variable takes value zero in the optimal solution, then what is the reduced cost associated with that variable? What are the binding constraints? max 80 X + 500Y subject to X +5Y 0 Y > 0 1. (40 points) Find the shadow price associated with the third constraint for the problem (1) max inax X+Y subject to 3x +2y 0 Y>0 (1) X+Y subject to 3X + 2Y 1 Y > 0 (Draw the feasible region and corner points using desmos. Insert the images in the excel file. Follow the instructions given in class.) 2. (60 points) What is the optimal solution to the following problem. If any of the variable takes value zero in the optimal solution, then what is the reduced cost associated with that variable? What are the binding constraints? max 80 X + 500Y subject to X +5Y 0 Y > 0