Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 Reduced Value Cost 300 0 0 -0.458333333 400 0 Objective Coefficient 3.1 4.75 4 Allowable Increase 2.233333333 0.458333333 0.65 Allowable Decrease 0.366666667 1 E+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 1E+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). d. Suppose a worker in the molding department calls in sick. Now eight fewer hours are available that day in the molding department. How much would this affect total profit? Would it change the optimal production quantities? e. Suppose one of the workers in the molding department is also trained to do finishing. Would it be a good idea to have this worker shift some of her time from the molding to the finishing? Indicate the rate at which this would increase or decrease total profit per minute shifted. How many minutes can be shifted before this rate might change? A f. 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. 4
Step 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