1. (100 points) Using Excel Solver, generate the sensitivity report for the following problem: max 3A + 2B st A + B = 10 3A + B = 24 A + 2B = 16 A, B = 0 What is the optimal solution and optimal value of the objective function? What does the sensitivity report say about the coefficientof A, optimal solution and optimal value of objective function? Interpret the shadow price for the first constraint. Are there any non-binding constraints? (Submit only the excel sheet).Please attach the solved excel document answer.BusinessBUSI2013 2013

Order your essay today and save 20% with the discount code ESSAYHELP