In: Statistics and Probability
Refer to the Kelson Sporting Equipment problem (Chapter 7, Problem 24). Letting R number of regular gloves C number of catcher’s mitts leads to the following formulation: The sensitivity report is shown in Figure 8.14. a. What is the optimal solution, and what is the value of the total profit contribution? b. Which constraints are binding? c. What are the shadow prices for the resources? Interpret each. d. If overtime can be scheduled in one of the departments, where would you recommend doing so? Max 5R+8C R+3/2C<900 cutting and sewing 1/2R+1/3C<300 Finshing 1/8R+1/4C<100 packaging and shipping R,C>0
Please show all steps and work using excel and solver please show formulas