Based on the Excel output below, what happens when the profit contribution for both products X and Y are changed to $4.75 each? This question is independent of the previous question so the assumption is that you've 'reset' the problem to its original output values shown and are now applying the change indicated in this current question only. Max 4X + 5Y s.t. 1 X + 2 Y <= 10 labour in hours 6 X + 6 Y <= 36 material available in kg 8 X + 4 Y <= 40 storage available in sq m Solution Decision Variables X Y items Produced 2 4 Maximize Total Profit 28 Constraints Amount Used (LHS) Amount Available (RHS) labour in hours 10 <= 10 material avail in kg 36 <= 36 storage avail in sq m 32 <= 40 Sensitivity report Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$18 items Produced X 2 0 4 1 1.5 $C$18 items Produced Y 4 0 5 3 1 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$23 labour in hours Amount Used (LHS) 10 1 10 2 2 $B$24 material avail.

Answer rating: 100% (QA)

Changing the profit contribution for both products X and Y to 475 each will not affect the optimal s... View the full answer