Friday
April 18, 2014

Homework Help: Math/Management

Posted by Carla on Wednesday, October 17, 2012 at 3:17am.

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?

Answer this Question

First Name:
School Subject:
Answer:

Related Questions

Algebra - A petroleum company has two different sources of crude oil. The first ...
math - Tema Oil Refinery ( TOR ) is the only company mandated to refine crude ...
math! - an oil well produceds 2500 barrels of oil during its firt month of ...
science - Questions about oil: 1. what is the main product we get from oil? 2. ...
Math - Ok please help me. Here is my stats question Suppose there is a 20% ...
Chemistry - Hello! I was wondering why is it that it is safe to eat olive oil, ...
Statistics - Ok please help me. Here is my stats question Suppose there is a 20...
chemistry - Looking up the specifications of an oil online, the spec sheet ...
History - Which of the following statements about John D. Rockefeller is most ...
Math - An oil-drilling company knows that it costs $25,000 to sink a test well. ...

Search
Members