Question: Decrease Cell Name Value Coefficient Increase Cost 100 0 61 8.5 7.6 -9.4 85 0 9.4 1E+30 $B$1 $B$2 $B$3 X1 (# Economy Model) X2

Decrease Cell Name Value Coefficient Increase
Decrease Cell Name Value Coefficient Increase
Decrease Cell Name Value Coefficient Increase Cost 100 0 61 8.5 7.6 -9.4 85 0 9.4 1E+30 $B$1 $B$2 $B$3 X1 (# Economy Model) X2 (# Standard Model) X3 (# Deluxe Model) 50 0 120 13.25 124 Constraints Final Name Value 150 Cell $B$ 91) Constraint#1 (number of fan motors) LHS $B$10 2) Constraint#2 (number of cooling coils) LHS 300 $B$11 3) Constraint #3 (manufacturing time in hours) LHS 1500 Shadow Constraint Allowable Allowable Price R.H. Side Increase Decrease 0 160 1E+30 10 5.9 300 128.6 30 6.9 1500 60 450 if the total manufacturing hours are increased by 20 hours, what is the impact? Profit will change, but we cannot tell exactly how it will change without reformulating and resolving the problem Profit will increase by $15.000 and the optimal solution mix will remain the same Profit will increase by 5138 and the optimal solution mix will change, but we do not know how will change There will be no impact on the profit because there are already unused manufacturing hours None of the answers are correct OE $B$11 3) Constraint #3 (manufacturing time in hours) LHS 1500 6 If the total manufacturing hours are increased by 20 hours, what is the impact? A. B. Profit will change, but we cannot tell exactly how it will change without reformulating and resolving the problem. Profit will increase by $15,000 and the optimal solution mix will remain the same Profit will increase by $138 and the optimal solution mix will change, but we do not know how it will change There will be no impact on the profit because there are already unused manufacturing hours C. D. None of the answers are correct OE. Moving to another question will save this response

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!