Variable Cells:
Model Variable: U Name: US Oil Final Value 800.000 Reduced Cost 0.000 Objective Coefficient 3.000 Allowable Increases 7.000 Allowable Decrease 0.500
Model Variable: H Name: Huber Final Value 1200.000 Reduced Cost 0.000 Obj Coeffcient 5.000 Allow increase 1.000 Allowable Decrease 3.500
Constraints:
Constraint Number Name Final Value Shadow price Contraint RH Side Allowable Increase Allowable Decrease
1 Funds available 80000.000 0.093 80000.000 60000.000 15000.000
2 Risk Maximum 700.000 1.333 700.000 75.000 300.000
3 US Oil Maximum 800.000 0.000 1000.000 1E + 30 200.000
a. How much would the return for US oil have to increase before it would be beneficial to increase the investment in this stock?
b. How much would the return for Huber Steel have to decrease before it would be beneficial to reduce the investment in this stock?
c. How much would the total annual return be reduced if US Oil maximum were reduced to 900 shares?