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
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, ...
The solution provides detailed explanations and instructions for solving the optimisation problem of oil production. It also includes the Solver instructions in Excel.