a production company that sells two types of gasoline, G1 and G2, from two types of crude oil, C1 and C2. Parmar prides itself in producing signature gasoline. As such, G1 is allowed to contain up to 6% impurities, and G2 is allowed to contain up to 4.5% impurities. G1 sells for $62 per barrel, whereas G2 sells for $76 per barrel. Up to 4200 barrels of G1 and up to 4500 barrels of G2 can be sold. The cost per barrel of each crude, their availability, and the level of impurities in each crude are listed in the table below. Before blending the crude oil into gas, any amount of each crude can be “purified” for a cost of $4.50 per barrel. Purification eliminates half of the impurities in the crude oil. Yash has hired you to solve this problem to determine how can we mximize profit.   Crude 1 Crude 2 Cost per barrel $40 $52 Impurity Percentage 10% 3% Availability 5400 4800

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...
icon
Related questions
Question

a production company that sells two types
of gasoline, G1 and G2, from two types of crude oil, C1 and C2. Parmar prides itself in producing
signature gasoline. As such, G1 is allowed to contain up to 6% impurities, and G2 is allowed to contain
up to 4.5% impurities. G1 sells for $62 per barrel, whereas G2 sells for $76 per barrel. Up to 4200
barrels of G1 and up to 4500 barrels of G2 can be sold. The cost per barrel of each crude, their
availability, and the level of impurities in each crude are listed in the table below.

Before blending the crude oil into gas, any amount of each crude can be “purified” for a cost of $4.50
per barrel. Purification eliminates half of the impurities in the crude oil. Yash has hired you to solve
this problem to determine how can we mximize profit.

  Crude 1 Crude 2
Cost per barrel $40 $52
Impurity Percentage 10% 3%
Availability 5400 4800

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 4 images

Blurred answer