Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Bangs Leisure Chairs produces three types of handcrafted outdoor chairs that are popular for beach, pool, and patios sling chairs, Adirondack chairs, and hammocks.

image text in transcribed 
  image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Solutions Step 1 A oneunit increase in assembly hours available will increase the profit by 1619 The ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Analytics Methods Models And Decisions

Authors: James R. Evans

2nd Edition

321997824, 978-1119298588, 978-0321997821

More Books

Students also viewed these Mathematics questions

Question

Find a value of x such that 3 1 [ a = [,7 a . - dt - dt. t 1/4

Answered: 1 week ago