Sterling Archer runs a tie factory. The factory makes 4 type…
Sterling Archer runs a tie factory. The factory makes 4 types of ties, Silk, Polyester, Blend 1 and Blend 2. Blend 1 and Blend 2 each are cotton polyester blends. Archer is limited each week in the number he can make by the amount of each of the three raw materials he can order from his vendor. He also has maximum demands on each tie type as well as contractually obligated minimums that he must produce. He has optimized his production strategy to maximize profit using a linear program. The sensitivity analysis is below. How much more money could Mr. Archer make each week, according to the model, if he could get is vender to sell him 10% more cotton than he currently receives at his current price? Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$3 Number of Units Silk 7000 0 3.45 1E+30 3.45 $C$3 Number of Units Poly 13625 0 2.32 2.176 0.952 $D$3 Number of Units Blend 1 13100 0 2.81 0.34 1.36 $E$3 Number of Units Blend 2 8500 0 3.25 1E+30 0.476 Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$11 Yards of Silk 875 0 1000 1E+30 125 $F$12 Yards of Poly 2000 29 2000 30 290 $F$13 Yards of Cotton 1250 27.2 1250 145 5 $F$14 Max Silk 7000 3.45 7000 1000 1000 $F$15 Max Poly 13625 0 14000 1E+30 375 $F$16 Max B1 13100 0 16000 1E+30 2900 $F$17 Max B2 8500 0.476 8500 71.42857143 2071.428571 $F$18 Min Silk 7000 0 6000 1000 1E+30 $F$19 Min Poly 13625 0 10000 3625 1E+30 $F$20 Min B1 13100 0 13000 100 1E+30 $F$21 Min B2 8500 0 6000 2500 1E+30