Question
Crebo Manufacturing produces four types of structural support fittingsplugs, rails, rivets, and clipswhich are machined on two CNC machining centers. To find an optimal solution
Crebo Manufacturing produces four types of structural support fittingsplugs, rails, rivets, and clipswhich 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 d through e.
d. If the gross margin for clips is reduced to $1.05, can you predict what the optimal solution and profit will be? What if the gross margin is reduced to 1.15$?
If the gross margin for clips is reduced to $1.05, 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.
*The optimal solution would not change. The profit would change to $__.
*The optimal solution and profit might change, but their values cannot be determined.
*The optimal solution would not change. The profit would not change.
*The optimal solution would not change. The profit would change to $___. (Type integers or decimals rounded to two decimal places as needed.)
*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.)
What if the gross margin is reduced to $1.20? Select the correct choice and, if necessary, fill in the answer box(es) to complete your choice.
*The optimal solution would not change. The profit would change, but its value cannot be determined.
*The optimal solution would not change. The profit would not change.
*The optimal solution would not change. The profit would change to $__. (Type integers or decimals rounded to two decimal places as needed.)
*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.)
*The optimal solution and profit might change, but their values cannot be determined.
e. Suppose that an additional 800 minutes of machine capacity is available. How will the optimal solution and profit change? What if planned maintenance reduces capacity by 400 minutes?
How will the optimal solution and profit change if an additional 800 minutes of machine capacity is available? Select the correct choice and, if necessary, fill in the answer box(es) to complete your choice.
*The optimal solution might change, but the values cannot be determined. The profit would change to $__.
*The optimal solution would not change. The profit would not change.
*The optimal solution would not change. The profit would change to $_. (Type integers or decimals rounded to two decimal places as needed.)
*The optimal solution and profit might change, but their values cannot be determined.
*The optimal solution would not change. The profit would change, but its value cannot be determined.
How will the optimal solution and profit change if the machine capacity available is reduced by 400 minutes? Select the correct choice and, if necessary, fill in the answer box(es) to complete your choice. *The optimal solution would not change. The profit would not change. *The optimal solution and profit might change, but their values cannot be determined. *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.) *The optimal solution would not change. The profit would change, but its value cannot be determined. *The optimal solution would not change. The profit would change to $__. (Type integers or decimals rounded to two decimal places as needed.)
Solver Sensitivity Report D F G H Final Value 156000 Final Value A B 6 Objective Cell (Max) 7 Cell Name 8 $A$13 Profit 9 10 Decision Variable Cells 11 12 Cell Name 13 $B$10 Units Produced Plugs (X1) 14 $C$10 Units Produced Rails (X2) 15 $D$10 Units Produced Rivets (X3) 16 $E$10 Units Produced Clips (X4) 17 18 Constraints 19 20 Cell Name 21 $A$16 Capacity Used 0 Reduced Cost -0.3 -0.2 -0.15 0 Objective Coefficient 0.3 1.4 0.75 1.2 Allowable Allowable Increase Decrease 0.3 1E + 30 0.2 1E +30 0.15 1E +30 1E +30 0.22000009 0 0 130000 Final Value 260000 Shadow Price 0.7 Constraint R.H. Side 260000 Allowable Increase 1E + 30 Allowable Decrease 260000 Solver Sensitivity Report D F G H Final Value 156000 Final Value A B 6 Objective Cell (Max) 7 Cell Name 8 $A$13 Profit 9 10 Decision Variable Cells 11 12 Cell Name 13 $B$10 Units Produced Plugs (X1) 14 $C$10 Units Produced Rails (X2) 15 $D$10 Units Produced Rivets (X3) 16 $E$10 Units Produced Clips (X4) 17 18 Constraints 19 20 Cell Name 21 $A$16 Capacity Used 0 Reduced Cost -0.3 -0.2 -0.15 0 Objective Coefficient 0.3 1.4 0.75 1.2 Allowable Allowable Increase Decrease 0.3 1E + 30 0.2 1E +30 0.15 1E +30 1E +30 0.22000009 0 0 130000 Final Value 260000 Shadow Price 0.7 Constraint R.H. Side 260000 Allowable Increase 1E + 30 Allowable Decrease 260000Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started