- Suppose The Profit Per Stein Increases By 0 30 And The Profit Per Plate Decreases By 0 25 Will This Change The Optima 1 (29.14 KiB) Viewed 36 times
BestCeramics manufactures plates, mugs, and steins. The time required for each item to go through the two stages of production (molding and finishing). The material required (clay) is subject to certain limitation. A linear programming model has been formulated to determine the production levels that would maximize profit, and the corresponding sensitivity report is shown below, where the objective coefficient for the decision variables Production Plates, Production Mugs, and Production Steins are the unit profits of these products. Variable Cells Cell Name $C$13 Production Plates $D$13 Production Mugs $E$13 Production Steins Final Value 300 0 400 Reduced Objective Cost Coefficient 0 3.1 -0.458333333 4.75 0 4 Allowable Increase 2.233333333 0.458333333 0.65 Allowable Decrease 0.366666667 1E+30 1.375 Constraints Final Cell Name Value $F$8 Molding (minutes) Used 2400 $F$9 Finishing(minutes) Used 7200 $F$10 Clay(ounces) Used 2700 Shadow Price 0.216666667 0.279166667 0 Constraint R.H. Side 2400 7200 3000 Allowable Increase 200 2400 1 E+30 Allowable Decrease 600 2400 For each of the following parts, answer the question without re-solving the problem with Solver. Note: Each part is independent (i.e., any change made in one part does not apply to any other parts). /