--%>

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 : Statistics Caterer determines that 37%

    Caterer determines that 37% of people who sampled the food thought it was delicious. A random sample of 144 out of population of 5000. 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 : Who had find Monte Carlo and finite

    Who had find Monte Carlo and finite differences of the binomial model?

  • Q : Explain Factorisation by trial division

    Factorisation by trial division: The essential idea of factorisation by trial division is straightforward. Let n be a positive integer. We know that n is either prime or has a prime divisor less than or equal to √n. Therefore, if we divide n in

  • Q : Explain the work and model proposed by

    Explain the work and model proposed by Richardson.

  • Q : Define Well-formed formulas or Wffs

    Wffs (Well-formed formulas): These are defined inductively by the following clauses:    (i) If  P  is an n-ary predicate and  t1, …, tn are terms, then P(t1, …, t

  • Q : Theorem-G satis es the right and left

    Let G be a group. (i) G satis es the right and left cancellation laws; that is, if a; b; x ≡ G, then ax = bx and xa = xb each imply that a = b. (ii) If g ≡ G, then (g-1)

  • Q : Properties of a group How can we say

    How can we say that the pair (G, o) is a group. Explain the properties which proof it.

  • Q : Problem on Datalog for defining

    The focus is on  the use of Datalog for defining properties  and queries on graphs. (a) Assume that P is some property of graphs  definable in the Datalog. Show that P is preserved beneath extensions  and homomo

  • Q : Calculus I need it within 4 hours. Due

    I need it within 4 hours. Due time March 15, 2014. 3PM Pacific Time. (Los Angeles, CA)

  • Q : Numerical Analysis Hi, I was wondering

    Hi, I was wondering if there is anyone who can perform numerical analysis and write a code when required. Thanks