Explore BrainMass

A refinery blends four petroleum components into three grade

This content was STOLEN from BrainMass.com - View the original, and get the solution, here!

A refinery blends four petroleum components into three grades of gasoline - regular, premium and low lead....

(See attached file for full problem description)

© BrainMass Inc. brainmass.com September 21, 2018, 1:54 am ad1c9bdddf - https://brainmass.com/math/linear-programming/a-refinery-blends-four-petroleum-components-into-three-grade-92344


Solution Preview

Please see the attached files.

a. The model can be generalised using a number of equations.
Let xiR, xiP, xiL be the % of component i in the Regular, Premium and Low-lead products. These are calculated values and not variables.
Let yiR, yiP, yiL be the % of component i used for mixing in the Regular, ...

Solution Summary

The solution provides detailed explanations and instructions for solving the optimisation problem of oil production. It also includes the Solver instructions in Excel.