Bangs Leisure Chairs produces three types of handcrafted outdoor chairs that are popular for beach, pool,...

 
  

Transcribed Image Text:

Bangs Leisure Chairs produces three types of handcrafted outdoor chairs that are popular for beach, pool, and patios sling chairs, Adirondack chairs, and hammocks. The Solver Sensitivity Report for the optimal solution is provided Use the information the Solve Sensitivity Report provides to answer the following questions. Click the icon to view the Solver Sensitivity Report. The reduced cost for implies that the unit for these items must the Allowable Increase and Allowable Decrease limits, such a change by at least $4 767 before it becomes profitable to produce them. Since a unit profit increase of more than $4.767 is change the optimal solution and the problem have to be re-solved A 22222222222223 21 Bangs Leisure Chairs Sensitivity Report 23 Variable Cells 24 Final Reduced Objective Allowable Allowable 25 Cell Name Value Cost Coefficient Increase Decrease 26 $B$14 27 $C$14 Quantity Produced Sling Chairs Quantity Produced Adironack 0 -4.767 42 4.767 1E+30 22.586 0 100 2.266 8.549 28 $D$14 Quantity Produced Hammocks 1.609 89 39.333 2 29 30 Constraints 31 Final Cell Name Value Shadow Price Constraint Allowable Allowable R.H. Side Increase Decrease 33 SE$15 Cutting Hours Used 45.797 0 49 1E+30 4.199 34 $E$16 Assembling Hours Used 49 1.609 49 31.833 35 $E$17 Finishing Hours Used 35.203 0 49 1E+30 25.804 36 $E$18 Total Hours Used 130 19.342 130 46.663 Bangs Leisure Chairs produces three types of handcrafted outdoor chairs that are popular for beach, pool, and patios sling chairs, Adirondack chairs, and hammocks. The Solver Sensitivity Report for the optimal solution is provided Use the information the Solve Sensitivity Report provides to answer the following questions. Click the icon to view the Solver Sensitivity Report. The reduced cost for implies that the unit for these items must the Allowable Increase and Allowable Decrease limits, such a change by at least $4 767 before it becomes profitable to produce them. Since a unit profit increase of more than $4.767 is change the optimal solution and the problem have to be re-solved A 22222222222223 21 Bangs Leisure Chairs Sensitivity Report 23 Variable Cells 24 Final Reduced Objective Allowable Allowable 25 Cell Name Value Cost Coefficient Increase Decrease 26 $B$14 27 $C$14 Quantity Produced Sling Chairs Quantity Produced Adironack 0 -4.767 42 4.767 1E+30 22.586 0 100 2.266 8.549 28 $D$14 Quantity Produced Hammocks 1.609 89 39.333 2 29 30 Constraints 31 Final Cell Name Value Shadow Price Constraint Allowable Allowable R.H. Side Increase Decrease 33 SE$15 Cutting Hours Used 45.797 0 49 1E+30 4.199 34 $E$16 Assembling Hours Used 49 1.609 49 31.833 35 $E$17 Finishing Hours Used 35.203 0 49 1E+30 25.804 36 $E$18 Total Hours Used 130 19.342 130 46.663

Answer rating: 100% (QA)

Solutions Step 1 A oneunit increase in assembly hours available will increase the profit by 1619 The ... View the full answer