What proffit (Z-Value) will be obtained of the optimal solution is implemented

How much poinds of unused pine is available

How many unused pressing hours are available

How much would the profit need to change before the western paneling would be produced? Explain why

PanelPine produces three types of pressed paneling from pine and spruce. The three types of paneling are Western, Old English and Colonial. Each sheet must be cut and pressed. Each sheet of Western requires five pounds of pine, two pounds of spruce, one hour of cutting and two hours of pressing. Each sheet of Old English requires four pounds of pine, five pounds of spruce, one hour of cutting and four hours of pressing. Each sheet of Colonial requires four pounds of pine, two pounds of spruce, two hours of cutting and two hours of pressing. There are 200 pounds of pine, 160 pounds of spruce, 50 hours of cutting and 80 hours of pressing available each day. The profit per sheet is $4 for Western, $10 for Old English and $8 for Colonial. The Excel sensitivity analysis is shown below: Allowable Increase $2.00 $6.00 $12.00 Allowable Decrease 1E+30 $6.00 $3.00 Adjustable Cells Final Reduced Objective Cell Name Value Cost Coefficient $C$23 WESTERN 0.00 -$2.00 $4.00 $D$23 OLD ENGLISH 10.00 $0.00 $10.00 $E$23 COLONIAL 20.00 $0.00 $8.00 Constraints Final Shadow Constraint Cell Name Value Price R.H. Side $F$25 PINE 120 $0.00 200 $F$26 SPRUCE 90 $0.00 160 $F$27 CUTTING 50 $2.00 50 $F$28 PRESSING 80 $2.00 80 Es What is the optimal solution for each type of paneling? Western- $0.00 Old English- $10.00 Colonial- $20.00 Allowable Increase 1E+30 1E+30 30 52.5 Allowable Decrease 80 70 30 30 What profit (Z value) will be obtained of the optimal solution is implemented