Question: The allowable decrease for Clay (ounces) Used constraint is missing from the sensitivity report. What numbers should be there? Explain how you were able to

 The allowable decrease for Clay (ounces) Used constraint is missing fromthe sensitivity report. What numbers should be there? Explain how you were

The allowable decrease for Clay (ounces) Used constraint is missing from the sensitivity report. What numbers should be there? Explain how you were able to deduce the number. 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). /

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!