Use the Sensitivity Report for the Camm Textiles scenario (Figure 15.37) to answer the following: 

a. Explain the reduced cost (0.14) for Fabric 2 Purchased in terms of the original data, and why it makes sense. 

b. Explain the shadow price for the dobbie loom constraint. 

c. Show where the shadow prices for the fabric constraints come from in terms of the original data and why they make sense.

Data from Figure 15.37

 

5 Objective Cell (Min) Cell $8$20 Cost Total Decision Variable Cells 10 11 12 13 14 15 16 17 18 19 A B 28728 $B$16 Fabric 3 on Dobble SCS16 Fabric 3 on Regular 20 SDS16 Fabric 3 Purchased 22 Constraints 26 Name Cell Name $B$14 Fabric 1 on Dobble SCS14 Fabrie 1 on Regular SD$14 Fabrie 1 Purchased SBS15 Fabric 2 on Dobble SCS15 Fabric 2 on Regular $D$15 Fabric 2 Purchased Cell Name $B$17 Hours Used on Dobble SCS17 Hours Used on Regular SE$14 Fabric 1 Total Yards Produced $E$15 Fabric 2 Total Yards Produced 29 $E$16 Fabric 3 Total Yards Produced D Final Value 83756.12 Final Value 30794.4 0 14206.6 10000 0 Final Value E Reduced Objective Cost Coefficient 0 0.180769231 76500 0 0 0.213636364 6552 18964 26573 45000 76500 10000 0 -0.85 0 0 0.14 0 0.15 Shadow Price -0.94 0 0.85 0.61 0.5 0.65 0 0.85 0.61 0.61 0.75 0.5 0.5 0.85 Constraint R.H. Side Allowable Increase 0.200000094 0.1500001 1E+30 Allowable Increase 6552 3022.468085 32760 45000 76500 82033.81818 10000 69413.23077 H 1E+30 1E+30 0.200000004 1E+30 0.180769231 Allowable Decrease 0.1400001 1E+30 1E+30 0.213636364 1E+30 1E+30 1E+30 1E+30 1E+30 0.14 1E+30 0.15 Allowable Decrease 8552 15775.73427 14205.6 78500 10000