The shadow price, allowable increase and decrease for the available plastics constraints are missing from the sensitivity report. What numbers should be there? Explain how you were able to deduce each number.

Question 4 Sweet Home Company manufactures plates, bowls and cups for sales in retail stores. The time required for each item to go through the two stages of production (molding and finishing), the material required (plastics), and the corresponding unit profits are given in the following table, along with the amount of each resources available in the upcoming production period. Bowls 8 Plates 5 10 6 $4.50 Cups 4 16 Molding (minutes) Finishing (minutes) Plastics (tonnes) Unit Profit Available 3,600 9,800 4,200 18 $5.20 $4.80 A linear programming model has been formulated in a spreadsheet to determine the production levels that would maximize profit. The solved spreadsheet model and corresponding sensitivity report are shown below. E F G B C Plates Bowls $4.50 $5.20 4600 3630 D Cups $4.80 325 Unit Profit Production Total Profit 8 Reources required per unit 5 8 4 Molding (minutes) Finishing (minutes) Plastics (tonnes) Used 3600 9800 4060 Available 3,600 9,800 4,200 10 6 Adjustable Cells C Cell Name $B$3 Production Plates $C$3 Production Bowls $D$3 Production Cups Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 460 o 4.5 1.5 1.5 0 -2.3 5.2 2.3 IE+30 325 0 4 .8 2.4 1.2 Constraints Cell Name $E$8 Molding (minutes) Used $E$9 Finishing (minutes) Used $E$10 Plastics (tonnes) Used Final Shadow Value Price 3600 0 .6 9800 0 .15 4060 Constraint Allowable Allowable R.H. Side Increase Decrease 3600 100 1150 9800 4600 1 400 4200