3. (28 points) Consider the optimization problem below. Max 10S+9D Subject to (s.t) -S+1D 5630 Cutting and Dyeing 10 s+ D5600 Sewing 1S+DS 708 Finishing Is+DS135 Inspection and Packaging 10 4 S20 and D20 Excel-Solver was used to analyze the above linear optimization problem including its sensitivity analysis. The outputs are as shown below: Par, Inc. Parameters RHS Constraints Cutting and Dyeing Sewing Finishing Inspection and Packaging Objective Coefficients 0.7 0.3 1 01 10 l 0.83333 .66667 0.25 9.00 630 600 708 135 0 Model Bags Produced 540 Total Profit $7.668.00 LHS RHS Constraints Cutting and Dyeing Sewing Finishing Inspection and Packaging 630 480 630 600 708 708 117 135 Microsoft Excel 16.0 Sensitivity Report Worksheet: [Par.xlsx]Model Report Created: 11/20/2019 4:07:34 PM Variable Cells Cell Name $B$14 Bags Produced S $C$14 Bags Produced D Final Reduced Objective Allowable Allowable Value Cost Coefficient increase Decrease 540 10 3.5 3.7 252 9 5.285714286 2.333333333 Constraints Cell- Name $B$19 Cutting and Dyeing LHS $B$20 Sewing LHS $B$21 Finishing LHS $B$22 Inspection and Packaging LHS Final Shadow Constraint Allowable Value Price R.H. Side Increase 630 4.375 630 52.36363636 480 0 600 1E +30 708 6.9375 708 192 117 0 135 1E+30 Allowable Decrease 134.4 120 128 18 Using the above outputs, answer the questions below: (a)(4 points) what are the optimal values of the decision variables? (b) (2 points) what is the optimal solution? (c) (4 points) specify the ranges in the objective function coefficients for which the current solution will remain optimal. (d) (8 points) what are the shadow prices for each constraint? Interpret each shadow price. (e) (4 points) specify the ranges in the right-hand side of each constraint for which the current shadow prices remain valid. (f) (4 points) What are the reduced cost for each of the decision variables? Interpret each of the values of the reduced costs. () (2 points) Which tool in excel was used in analyzing the above