The work in excel I need step by step please! Thank you.

5. SELF test Refer to the Kelson Sporting Equipment problem (Chapter 2, 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+ C = 900 Cutting and sewing 12R + WC = 300 Finishing YR + 14C = 100 Packaging and shipping R, C20 - The computer solution is shown in Figure 3.13. 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 dual values for the resources? Interpret each. d. If overtime can be scheduled in one of the departments, where would you recommend doing so? FIGURE 3.13 THE SOLUTION FOR THE KELSON SPORTING EQUIPMENT PROBLEM Optimal Objective Value = 3700.00000 Variable Value Reduced Cost - - - - - - - - - 500.00000 150.00000 0.00000 0.00000 Optimal Objective Value = 3700.00000 Variable Value Reduced Cost - - - - - - - - - - - - R 500.00000 150.00000 0.00000 0.00000 Constraint Slack/Surplus Dual Value - - - - - - -- - - - - - - - - - - WNE! 175.00000 0.00000 0.00000 0.00000 3.00000 28.00000 Objective Coefficient Variable Allowable Increase Allowable Decrease 5.00000 8.00000 7.00000 2.00000 1.00000 4.66667 RHS Value Allowable Increase Allowable Decrease Constraint - - - - - - - - - - - - - - WN1 900.00000 300.00000 100.00000 Infinite 100.00000 35.00000 175.00000 166.66667 25.00000