Can someone look over my work? thanks Please answer Question D

Solver Sensitivity Report X A B C D E F G H 6 Objective Cell (Max) 7 Cell Name Final Value 8 $A$13 Profit 176000 9 10 Decision Variable Cells 11 Final Reduced Objective Allowable Allowable 12 Cell Name Value Cost Coefficient Increase Decrease 13 $B$10 Units Produced Plugs (X1) 0 - 0.4 0.4 0.4 1E + 30 14 $C$10 Units Produced Rails (X2) O - 0.3 1.3 0.3 1E + 30 15 $D$10 Units Produced Rivets (X3) 0 - 0.25 0.65 0.25 1E + 30 16 $E$10 Units Produced Clips (X4) 160000 0 1.1 1E + 30 0. 13000002 17 18 Constraints 19 Final Shadow Constraint Allowable Allowable 20 Cell Name Value Price R.H. Side Increase Decrease 21 $A$16 Capacity Used 320000 0.7 320000 1E + 30 320000d. If the gross margin for clips is reduced to $0.85, can you predict what the optimal solution and profit will be? What if the gross margin is reduced to $0.95? If the gross margin for clips is reduced to $0.85, can you predict what the optimal solution and profit will be? Select the correct choice and, if necessary, fill in the answer box(es) to complete your choice. O A. 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 B. The optimal solution would not change. The profit would change to $ (Type integers or decimals rounded to two decimal places as needed.) O C. The optimal solution would not change. The profit would change, but its value cannot be determined. O D. The optimal solution and profit might change, but their values cannot be determined. O E. The optimal solution would not change. The profit would not change.Crebo Manufacturing produces four types of structural support ttingsplugs, rails, rivetsI and dipswhich are machined on two CNC machining centers. To nd an optimal solution to maximize the gross prot. the Excel addin Solver was umdl The accompanying gure shows the Solver Sensitivity Report. Using onlyr the information in the Sensitivity Report1 complete parts a through 9. Click the icon to view the Solver Sensitivity Report