A Blend Example A petroleum company produces three grades of motor oil—super, premium, and extra—from three components. The company wants to determine the optimal mix of the three components in each grade of motor oil that will maximize profit. The maximum quantities available of each component and their cost per barrel are as follows: Component Maximum Barrels Available/Day Cost/Barrel 1           4,500             $12 2            2,700              10 3            3,500             14 To ensure the appropriate blend, each grade has certain general specifications. Each grade must have a minimum amount of component 1 plus a combination of other components, as follows: Grade  ComponentSpecifications    SellingPrice/Barrel Super       At least 50% of 1                         $23                Not more than 30% of 2 Premium    At least 40% of 1                          20                  Not more than 25% of 3 Extra             At least 60% of 1                      18                     At least 10% of 2 The company wants to produce at least 3,000 barrels of each grade of motor oil. For the blend example in this chapter, if the requirement that “at least 3,000 barrels of each grade of motor oil” was changed to exactly 3,000 barrels of each grade, how would this affect the optimal solution? If the company could acquire more of one of the three components, which should it be? What would be the effect on the total profit of acquiring more of this component?

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...
icon
Related questions
Question

A Blend Example
A petroleum company produces three grades of motor oil—super, premium, and extra—from
three components. The company wants to determine the optimal mix of the three components
in each grade of motor oil that will maximize profit. The maximum quantities available of each
component and their cost per barrel are as follows:
Component
Maximum Barrels
Available/Day Cost/Barrel
1           4,500             $12
2            2,700              10
3            3,500             14
To ensure the appropriate blend, each grade has certain general specifications. Each grade
must have a minimum amount of component 1 plus a combination of other components, as
follows:
Grade  ComponentSpecifications    SellingPrice/Barrel
Super       At least 50% of 1                         $23
               Not more than 30% of 2
Premium    At least 40% of 1                          20
                 Not more than 25% of 3
Extra             At least 60% of 1                      18
                    At least 10% of 2
The company wants to produce at least 3,000 barrels of each grade of motor oil.

For the blend example in this chapter, if the requirement that “at least 3,000 barrels of each grade
of motor oil” was changed to exactly 3,000 barrels of each grade, how would this affect the optimal
solution?
If the company could acquire more of one of the three components, which should it be? What
would be the effect on the total profit of acquiring more of this component?

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Optimization models
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,