Question: Objective Cell (Max) Cell Name Final Value $A$19 Total Profit 9000 Decision Variable Cells Cell Name Final Value Reduced Cost Objective Coefficient Allowable Increase Allowable

Objective Cell (Max) Cell Name Final Value $A$19

Objective Cell (Max) Cell Name Final Value $A$19 Total Profit 9000 Decision Variable Cells Cell Name Final Value Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease Number Produced Standard 40 0 225 1.00E+30 11.66666673 $B$11 $C$11 Number Produced Deluxe 0 -17.5 320 17.5 1.00E+30 Constraints Cell Name Final Value Shadow Price Constraint R.H. Side Allowable Increase Allowable Decrease $D$14 Pine Used 2800 0 5000 1.00E+30 2200 $D$15 Oak Used 0 0 750 1.00E+30 750 400 22.5 400 314.2857143 400 $D$16 Labor Uses If the available labor decreases to 300 hours, then A. The optimal values of the decision variables will not change since the change remains within the Allowable Decrease. B. The optimal values of the decision variables will change since the change exceeds the Allowable Decrease. C. The optimal profit will go down by $2250. D. The optimal profit will go down by $6750

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!