Question

South Coast Papers wants to mix two lubricating oils (A and B) to create a mix that has a viscosity rating of no less than 40. A has a viscosity rating of 45 and costs 60 cents per gallon; B has a viscosity rating of 37.5 and costs 40 cents per gallon. There are 2,000 gallons of A and 4,000 gallons of B available.

The company needs no less than 3,000 gallons of the mix to run the machines next month. It has a maximum oil storage capacity of 4,000 gallons. When lubricating oils are mixed, the amount of mix obtained is exactly equal to the sum of the amounts put in. The viscosity rating is the weighted average of the individual viscosities, weighted in proportion to their volumes.

How many gallons of A and how many gallons of B to use in the mix to minimize the total cost, while meeting all the constraints stated above?

Formulate the LP model for the problem. (14 Points) Hint: Suppose X amount of Oil A is mixed with Y amount of Oil B. The viscosity rating of the mix = (45X + 37.5Y)/(X + Y)

Answer 1

Minimize: 60X + 40Y

Constraints:

X <= 2000

Y <= 4000

X+Y >= 3000

X+Y <= 4000

(45X + 37.5Y)/(X+Y) >= 40

Uisng Solver:

Minimize =SUMPRODUCT(C2:D2,C6:D6)

Constraints:

X: C2 <= 2000

Y: D2 <= 4000

X+Y: C2+D2 >= 3000

X+Y: C2+D2 <= 4000

Mix: IFERROR((C5*C2+D5*D2)/(C2+D2),0) >= 40

On Solving:

X = 1000, Y = 2000

Value = 140,000