1) If the demand for model 2 increase to 3000 which of the following is true

a)objective function will decrease by 97*1000

b) Objective function will increase by 57*1000

c) objective function will increase by 97*1000

d) objective function will stay same

e) objective function will increase by 97*3000

B D E F OOOOO Slip Ring ------- Model 1 Model 2 Model 3 3,000 550 900 0 1,450 0 $50 3 4 5 Number to 6 Make 7 Buy 8 9 Cost to 10 Make 11 Buy 12 13 # Available 14 # Needed 15 16 Hours Required 17 Wiring 18 Harnessing $83 $97 $61 $130 $145 Total Cost $453,300 3,000 3,000 2,000 2,000 900 900 2 1.5 3 Used 9,525 5,000 Available 10,000 5,000 1 2 1 Final Value 453300 6 Objective Cell (Min) 7 Cell Name 8 $E$11 Buy Total Cost 9 10 Decision Variable Cells 11 12 Cell Name 13 $B$6 Make Model 1 14 $C$6 Make Model 2 15 $D$6 Make Model 3 16 $B$7 Buy Model 1 17 $C$7 Buy Model 2 18 $D$7 Buy Model 3 19 20 Constraints 21 22 Cell Name 23 $B$13 # Available Model 24 $C$13 # Available Model 25 $D$13 # Available Model 26 $E$17 Wiring Used 27 $E$18 Harnessing Used Final Value 3,000 550 900 0 1,450 0 Reduced Objective Cost Coefficient 0 50 0 83 0 130 4 61 0 97 8 145 Allowable Allowable Increase Decrease 4.0000001 1E-30 14.0000001 8.0000002 8.0000001 1E+30 1E+30 8.0000002 14.0000001 1E+30 Final Shadow Constraint Allowable Value Price R.H. Side Increase 3,000 57 3000 380 2,000 97 2000 1E+30 900 137 900 211.1111111 9,525 0 10000 1E+30 5,000 5000 633.3333333 Allowable Decrease 2900 1450 900 475 1100