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? If the number of hours available in machine a decreases by 150 and material c increases by 100, 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) 8. What if the objective function coefficient of X2 increases by $1.20 and coefficient of X3 decreases by $0.50, how would these changes affect the optimal solutions (X1, X2, X3, X4, and objective function value)? (Use 100% rule, show your work) Ch. 3 Computer solution & sensitivity analysis Max 4x1 + 6x2 + 3x3 + 1X4 s.t. 1.5X1 4X1 2x1 + 2x2 + 4x3 + 1x2 + 2x3 + 3X2 + 1x3 X2, X3, + 3x4 + 1X4 + 2x4 X4 $550 $700