1. Consider the following LP formulation: Machine B hours Optimal Solution --- Machine A hours LP Model: Max 100X + 400Y s.t. 10X +8Y 80 (Machine A hours) 6X + 2Y 36 (Machine B hours) Y 8 (Machine C hours) X, Y 20 Machine C hours Objective Function X Determine the missing numbers in the Excel Sensitivity Analysis report. Explain your results. Variable Cells Cell $B$5 $C$5 Constraints Cell $D$10 $D$11 $D$12 A. B. C. D. X Y Name Name Machine A hours Machine B hours Machine C hours Final Value 1.6 8 Final Value 80 25.6 8 Reduced Objective Allowable Allowable Cost Coefficient Increase Decrease Shadow Price 0 0 10 C D 100 400 Constraint R.H. Side 80 36 8 A 1E+30 Allowable Increase 17.3333 1E+30 2 B 320 Allowable Decrease 16 10.4 3.71429 E. Suppose that a technical upgrade will allow you to increase the capacity of Machine A by 20 hours, at a cost of $160. Should you implement this upgrade? Explain your answer.