8. Figure 15.350 shows the Solver Sensitivity Report for the Burger Office Equipment scenario from Problems 60 and 13 in Chapter 130. Using only the information in the Sensitivity Report, answer the following questions, explaining what information you used in the Sensitivity Report. Figure 15.35 Solver Sensitivity Report for Burger Office Equipment Problem B D E F G H 6 Variable Cells 7 Final Reduced Objective Allowable Allowable 8 Cell Name Value Cost Coefficient Increase Decrease 9 $B$4 Number Produced Standard 40 0 250 1E+30 55.55555556 10 $C$4 Number Produced Deluxe 0 -100 350 100 1E+30 11 12 Constraints 13 Final Shadow Constraint Allowable Allowable 14 Cell Name Value Price R.H. Side Increase Decrease 15 $D$7 Pine Used 2800 0 5000 1E+30 2200 16 $D$8 Oak Used 0 0 750 1E+30 750 17 $D$9 Labor Used 400 25 400 314.2857143 400 a. Explain the reduced cost associated with deluxe desks. b. If 25% of the pine is deemed to be cosmetically defective, how will the optimal solution be affected? c. The shop supervisor is suggesting that the workforce be allowed to work an additional 50 hours at an overtime premium of $18/hour. Is this a good suggestion? Why or why not? d. If the unit profit for standard desks is increased to $280, how will the optimal solution and total profit be affected? e. If the unit profit of standard desks is only $190, how will the optimal solution and total profit be affected