Question: 8. Figure 15.35 shows the Solver Sensitivity Report for the Burger Office Equipment scenario from Problems 6 and 13 in Chapter 13 . Using only

 8. Figure 15.35 shows the Solver Sensitivity Report for the Burger

8. Figure 15.35 shows the Solver Sensitivity Report for the Burger Office Equipment scenario from Problems 6 and 13 in Chapter 13 . 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 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 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

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 Finance Questions!