--%>

Formulating linear program of an oil company

An oil company blends two input streams of crude oil products alkylate and catalytic cracked to meet demand for weekly contracts for regular (12,000 barrels) mind grade ( 7,500) and premium ( 4,500 barrels) gasoline’s . each week they can purchase up to 15, 000 barrels of alkylate and up to 15,000 barrels of catalytic cracked. Because of demand they can sell all blended gasoline including any production that exceeds its contracted amounts.

Gasoline must meet minimum octane and maximum vapour pressure requirements to be classified as regular mid grade and premium. These rating values are assumed to be the simple weighted average of the crude oil products in the blend and it is assumed there is no waste.

The relevant cost prising octane and vapour pressure data are provided in teh table below:

307_crude oil.jpg

Formulate the linear program the oil company can use to determine how to blend the crude oil products into the commercial gasoline in order to maximize their weekly profit.

Implement your formulation in excel and find the optimal solution nusign solver. Sum marize your solution ( decision variable values and objective function value ) below your for mulation.

For simplicity ( and consistency when I grade) please assume a quarter is 3 month and each month requires 4 weeks.

   Related Questions in Mathematics

  • Q : What is Big-O hierarchy The big-O

    The big-O hierarchy: A few basic facts about the big-O behaviour of some familiar functions are very important. Let p(n) be a polynomial in n (of any degree). Then logbn is O(p(n)) and p(n) is O(an<

  • Q : Use MS Excel to do the computations

    Select a dataset of your interest (preferably related to your company/job), containing one variable and atleast 100 data points. [Example: Annual profit figures of 100 companies for the last financial year]. Once you select the data, you should compute 4-5 summary sta

  • Q : Ordinary Differential Equation or ODE

    What is an Ordinary Differential Equation (ODE)?

  • Q : Explain Black–Scholes model Explain

    Explain Black–Scholes model.

  • Q : Set Theory & Model of a Boolean Algebra

    II. Prove that Set Theory is a Model of a Boolean Algebra The three Boolean operations of Set Theory are the three set operations of union (U), intersection (upside down U), and complement ~.  Addition is set

  • Q : State Measuring complexity Measuring

    Measuring complexity: Many algorithms have an integer n, or two integers m and n, as input - e.g., addition, multiplication, exponentiation, factorisation and primality testing. When we want to describe or analyse the `easiness' or `hardness' of the a

  • Q : Maths A cricketer cn throw a ball to a

    A cricketer cn throw a ball to a max horizontl distnce of 100m. If he throws d same ball vertically upwards then the max height upto which he can throw is????

  • Q : Uniform scaling what is uniform scaling

    what is uniform scaling in computer graphic

  • Q : The mean of the sampling distribution

    1. Caterer determines that 87% of people who sampled the food thought it was delicious. A random sample of 144 out of population of 5000 taken. The 144 are asked to sample the food. If P-hat is the proportion saying that the food is delicious, what is the mean of the sampling distribution p-hat?<

  • Q : Explain Factorisation by Fermats method

    Factorisation by Fermat's method: This method, dating from 1643, depends on a simple and standard algebraic identity. Fermat's observation is that if we wish to nd two factors of n, it is enough if we can express n as the di fference of two squares.