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?