Please help doing this in excel, thank you! 1. Solve the following…

Question Answered step-by-step Please help doing this in excel, thank you! 1. Solve the following… Please help doing this in excel, thank you! 1. Solve the following LP problem Max Z= 8X1 + 10X2 S.T. XI + 4X2 < 12 3X1 + 2X2 á 12 2X1+ X258 XI, X2>0  2. Solve the following LP problem Max Z= 3X1 + 5X2 S.T. 4X1 + 3X2 à 24 2X1+ 3X2 <18 XI, X2>0  3. Given the following LP problem: Max z= 5X1 + 7X2 S.T. XI 5 6 2X1 + 3X2 519 XI + X2 á 8 XI, X220 a) Solve the problem. b) Identify the reduced costs and interpret each. c) Calculate the range of optimality for each objective function coefficient. d) Identify the slacks for the resources and calculate the shadow price for each resource Math Statistics and Probability BUS 12461 Share QuestionEmailCopy link Comments (0)