For the following Model:
It has sensitivity analysis below:
Max 5R+8C,
s.t.
,R+(3)/(2)C<=900 Cutting and sewing
,(1)/(2)R+(1)/(3)C<=300 Finishing
,(1)/(8)R+(1)/(4)C<=100 Packaging and shipping
,R,C>=0,
Variable Cells
able[[R,Gloves Standard,500.000,0.000,5.000,(7.000)/(2.000),(1.000)/(4.667) make it clear
Max s.t.
5R+8C
For the following Model: It has sensitivity analysis below: 76
R+3/C900Cutting and sewing /R+/C300Finishing /gR+/C100Packaging and shipping
Variable Cells Model Varlable R C
Reduced Cost 0.000 0.000
Objective Coefflclent 5.000 8.000
Allowable Inerease 7.000 2.000
Allowable Decrease 1.000 4.667
Fimal Value 500.000 150.000
Name
Gloves Standard Gloves Deluxe
Constraints Constraint Final Name Value Number 1 Cutting and Dyeing Hours Used 725.000 2 Finishing Hours Used 300.000 3 Packaging and Shipping Hours Used 100.000
Shadow Price 0.000 3.000 28.000
Constraint R.H.Side 900.000 300.000 100.000
Allowable Allowable Increase Decrease 1E+30 175.000 100.000 166.667 35.000 25.000
What is the optimal solution, and what is the value of the total profit contribution? 6 Which constraints are binding? C. Determine the objective coefficient ranges. Interpret this range d. How much will the value of the optimal solution improve if 20 extra hours of packaging and shipping time are made available?