Stat
& Points: 0 Save Crebo Manufacturing produces four types of structural support fittings-plugs, rails, rivets, and clips-which are machined on two CNC machining centers. To find an optimal solution to maximize the gross profit, the Excel add-in Solver was used. The accompanying figure shows the Solver Sensitivity Report. Using only the information in the Sensitivity Report, complete parts a through e. i Click the icon to view the Solver Sensitivity Report. 4 Solver Sensitivity Report - X C. The optimal solution would not change. The profit would change, but its value cannot be determined. B D. The optimal solution would not change. The profit would not change. Objective Cell (Max) OE. The optimal solution might change, but the values cannot be determined. The profit would change to $ Cell Name Final Value A$13 Profit 169000 (Type integers or decimals rounded to two decimal places as needed.) Decision Variable Cells c. Suppose that the gross margin for rivets is increased to $0 85. Can you predict what the optimal solution and profit will be? Select the correct choice and, if necessary, fill in th Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease OA. The optimal solution and profit might change, but their values cannot be determined. $B$10 Units Produced Plugs (X1) 0.4 0.4 1E + 30 OO O B. The optimal solution might change, but the values cannot be determined. The profit would change to $ $C$10 Units Produced Rails (X2) - 0.3 12 0.3 E + 30 SD$10 Units Produced Rivets (X3) 0.25 0.75 0.25 1E + 30 (Type integers or decimals rounded to two decimal places as needed ) SE$10 Units Produced Clips (X4) 130000 13 IE + 30 0. 16000008 C. The optimal solution would not change. The profit would not change. OD. The optimal solution would not change. The profit would change, but its value cannot be determined. 18 Constraints Final Shadow Constraint Allowable Allowable O E. The optimal solution would not change. The profit would change to $ 20 Cell Name Value Price R.H. Side Increase Decrease (Type integers or decimals rounded to two decimal places as needed.) $A$16 Capacity Used 260000 0.7 260000 1E + 30 260000 d. If the gross margin for clips is reduced to $1.15, can you predict what the optimal solution and profit will be? What if the gross margin is reduced to $1.25? If the gross margin for clips is reduced to $1.15, can you predict what the optimal solution and profit will be? Select the correct choice and, if necessary, fill in the answer box(es) Print Done O A. The optimal solution would not change. The profit would change, but its value cannot be determined. O B. The optimal solution and profit might change, but their values cannot be determined. O C. The optimal solution would not change. The profit would change to $ (Type integers or decimals rounded to two decimal places as needed.) O D. The optimal solution might change, but the values cannot be determined. The profit would change to $ (Type integers or decimals rounded to two decimal places as needed.) O E. The optimal solution would not change. The profit would not change. Clear all Check answer Help me solve this Teach me Get more help