I was handed this assignment in class. How do I answer these questions?

12:55 BADM 345 - Ch. 3 Practice Test questions- Computer Solution & Sensitivity analysis This is an individual assignment. No collaboration is permitted. Please write your answer in the space immediately following the question. Total 40 possible points. Due: at the beginning of Thursday class on January 30, 2020 Use the attached Excel solutions to answer the questions below. a. What are the optimal solutions to X1, X2, X3, X4, slack variables, and objective function value? b. Which constraints are binding? How can you tell? C. Which constraints have excess capacity? And by how much? d. Which resource is the most valuable to the firm? How can you tell? e. If the objective function coefficient of X1 is increased by $0.5, will the optimal solution change? Explain why or why not? f. If the number of hours available in machine a increases by 100 and material c increases by 200, will the shadow/dual prices change? How would these changes affect the objective function value? Increase or decrease? And by how much? (Use 100% rule, show your work) g. What if the objective function coefficient of X2 increases by $1.50 and coefficient of X3 decreases by $0.20, how would these changes affect the optimal solutions (X1, X2, X3, X4, and objective function value)? (Use 100% rule, show your work) 2/2 12:55 Ch. 3 Computer solution & sensitivity analysis Max 4x1 + 6x2 + 3x3 + 1X4 s.t. 1.5X1 4X1 2X1 X1, + 2x2 + 1x2 + 3x2 X2, + 4x3 + 2x3 + 1x3 X3 + 3x4 + 1X4 + 2x4 X4