Sensitivity Analysis practice problem

Constraints Cell Name Cell Value Formula Status Slack Not SE$15 Cardstock Materials Used 1173.333333 SE$15

Constraints cell Name Cardstock Materials Used Satin Materials Used Plain Fabric Materials Used Leather Materials Used Cell Value 1173.333333 2000 3800 1000 Formula Objective Coefficient 40 Constraint R.H. Side 1200 2000 1000 Status Bind-ng Bindng Bind-ng Bindng Allowable Increase Slack 26.66665667 3700 SENSITIVITY REPORT Variable Cells cell $B$14 $c$14 $D$14 Constraints cell Name Quantity Produced Model 1 Quantity Produced Model 2 Quantity Produced Model 3 Name Cardstock Materials Used Satin Materials Used Plain Fabric Materials Used Leather Materials Used Final Value 66.66665667 26.66665667 Final Value 1173.333333 Reduced Cost Shadow Price 5.454545455 Allowable Increase IE+30 181.8181818 IE+30 12.82051282 Allowable IE+30 4.772727273 Allowable 25.66566667 58.82352941 3700 83.33333333