Use Solver to create a Sensitivity Report for question 24 at the end of Chapter 3 and

Question:

Use Solver to create a Sensitivity Report for question 24 at the end of Chapter 3 and answer the following questions:

a. Are there alternate optimal solutions to this problem? Explain.

b. What is the highest possible octane rating for regular gasoline, assuming the company wants to maximize its profits? What is the octane rating for supreme gasoline at this solution?

c. What is the highest possible octane rating for supreme gasoline, assuming the company wants to maximize its profits? What is the octane rating for regular gasoline at this solution?

d. Which of the two profit-maximizing solutions identified in parts b and c would you recommend that the company implement? Why?

e. If the company could buy another 150 barrels of input 2 at a cost of $17 per barrel, should they do it? Why?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: