Question: Answer. Cell Final Reduced Objective Allowable Allowable Name Value Cost Coefficient Increase Decrease $B$1 X1 (# Economy Model) 100 0 61 7.6 8.5 $B$2 X2
Answer.

Cell Final Reduced Objective Allowable Allowable Name Value Cost Coefficient Increase Decrease $B$1 X1 (# Economy Model) 100 0 61 7.6 8.5 $B$2 X2 (# Standard Model) -9.4 85 9.4 1E+30 $B$3 X3 (# Deluxe Model) 50 0 120 124 13.25 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$9 1) Constraint#1 (number of fan motors) LHS 150 0 160 1E+30 10 $B$10 2) Constraint#2 (number of cooling coils) LHS 300 5.9 300 128.6 30 $B$11 3) Constraint #3 (manufacturing time in hours) LHS 1500 6.9 1500 60 450 Which statement is TRUE regarding Constraint #1 (Number of fan motoralt A The constant is not binorg B. None of the answers are correct The company requires 10 additional fan motore to maximize proil D. The constraint is binding and there is no alack of surplus associated with the constant . E The company will gain an additional $150 in profit for each additional fan motor that may can obtain
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
