**** USE EXCEL SOLVER AND PLEASE SHOW FORMULAS***

1. What is the optimal solution, and what is the value of the total profit contribution? 2. Which constraints are binding? 3. What are the shadow prices for the resources? Interpret each. 4. If overtime can be scheduled in one of the departments, where would you recommend doing so?

5. 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: Max 5R + 8C s.t. R +3/2C 0 The sensitivity report is shown in Figure 8.14. Figure 8.14. Sensitivity Report for the Kelson Sporting Equipment Problem Variable Cells Model Reduced Objective Allowable Allowable Name Final Value Variable Cost Coefficient Increase Decrease R Gloves Standard 500.000 0.000 5.000 7.000 1.000 Gloves Deluxe 150.000 0.000 8.000 2.000 4.667 Constraints Constraint Shadow Constraint R.H. Allowable Allowable Name Final Value Number Price Side Increase Decrease 1 Cutting and Dyeing Hours Used 725.000 0.000 900.000 1E+30 175.000 2 Finishing Hours Used 300.000 3.000 300.000 100.000 166.667 3 Packaging and Shipping Hours 100.000 28.000 100.000 35.000 25.000 Used