which resources are binding constraints

machine and labor

machine and materials

labor and product 2

labor and materials

materials and product 2

What would we be willing to pay for 1 more unit of machine time

$10.20

$4.20

$0

$160

$17.50

Which decision variable(s) are non-basic?

x1

x2

x3

x2 and x3

Labor

What is the lowest value of the range of feasibility for materials?

18

10.20

160

200

5 6 Variable Cells 7 Final Reduced Objective Allowable Allowable 8 Cell Name Value Cost Coefficient Coefficient Increase Decrease 9 $B$4x1 0 - 10.2 12 10.2 1E+30 10 $C$4x2 4 0 18 2 7.28571 11 $D$4x3 48 0 15 21 1.5 12 13 Constraints Final Shadow Constraint Allowable Allowable 15 Cell Name Value Price R.H. Side Increase Decrease 16 $B$1 C1: Machine: 160 4.2 160 17.5 10 17 $B$1 C2: Labor x1 232 0 288 1E+30 56 18 $B$1 C3: Materials 200 0.6 200 13.333333 40 19 $B$1 C4: Product 2 4 0 16 1E+30 12 14 20 21