posted by .

FuelMotion is an oil company that owns two oil processing plants that produce gasoline
from crude oil. Their Georgia Plant produces 2 thousand gallons of premium, 1 thousand
gallons of medium, and 6 thousand gallons of regular gasoline every day it operates.
Their Arizona Plant produces 3 thousand gallons of premium, 4 thousand gallons of
medium and 1 thousand gallons of regular gasoline per day of operation. Chevron has
placed an order for 110 thousand gallons of premium, 80 thousand gallons of medium,
and 90 thousand gallons of regular gasoline and has asked for the order to be filled within
30 days. If it costs FuelMotion $10,000 per day to operate the Georgia Plant and $20,000
per day to operate the Arizona Plant, then determine how it can fill Chevron's order at
minimum cost. Note: it may be necessary to produce more gas than demanded, due to the
way the plants operate.

a. Formulate a linear programming model (that is, define the variables, and write down
the objective function and all constraints mathematically).
b. Create a spreadsheet model for this problem and solve with Excel Solver.
c. What is the optimal solution? What is the optimal value?

  • Math/Management -

    Georgia 30
    Arizona 16.66666667

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. Managerial Economics

    Please check Here gasoline output is mesured in thousands of gallons, fiber output in the thousands of square feet, and crude oil in thousands of barrels. The product's profits per unit output are $.50 per gallon for gasoline and $.75 …
  2. Algebra II

    An outboard motor calls for a fuel mixture that has a gasoline – to –oil ratio of 50 to 1. How many pints of oil should be added to be gallons of gasoline?
  3. Math

    Brent received two bills with his monthly gasoline statement. One bill for $92.30 showed he had bought 66L of gasoline and two liters of oil, while the other bill showed he had bought 75L of gasoline and one liter of oil for $100.75. …
  4. Algebra

    A petroleum company has two different sources of crude oil. The first source provides crude oil that is 35% hydrocarbons, and the second one provides crude oil that is 60% hydrocarbons. In order to obtain 120 gallons of crude oil that …
  5. Algebra

    The two largest oil spills together released 286 million gallons of oil into the oceans. The smaller of the two released 58 million gallons less than the larger of the two. How many million gallons did the larger one release?
  6. managerial economics

    An article in Business Week reported the discovery of a new processing technology that makes it economically feasible to turn natural gas into liquid petroleum that yields superclean gasoline, diesel fuel, or any other product derived …
  7. math

    E-Z Stop Fast Gas sold $10,957 worth of gasoline yesterday. Regular sold for $2.30 a gallon, and premium sold for $2.55 a gallon. If the station sold 420 more gallons of regular than of premium: a. How many gallons of each type of …
  8. MAth

    Your lawnmower uses a gasoline and oil mixture for fuel. For every 2 gallons of gas you add 18 ounces of oil how much oil should you add for 5 gallons of gasoline?
  9. algebra

    Kevin decides to mix grades of gasoline in his truck. He puts in 5 gallons of regular and 10 gallons of premium for a total cost of $61.30. If premium gasoline costs $0.22 more per gallon than regular, what was the price of each grade …
  10. Math

    A customer's bill for maintenance and repair at a service station showed 6 quarts of oil at $1.15 each an air filter at $3.75 an oil filter at $7.45 13 gallons of gasoline at $1.15 a gallon and 3 hours labor at $37.00 an hour What …

More Similar Questions