Carrington oil produces gas 1 and gas 2. Gas 1 is allowed to contain up to 4% impurities, and gas 2 is allowed to contain up to 3% impurities. Gas 1 sells for $72 per barrel, whereas gas 2 sells for $84 per barrel. Up to 4200 barrels of gas 1 and up to 4,300 barrels of gas 2 can be sold. The cost per barrel of each crude, their availability and the level of impurities in each crude are listed in the Excel file.Write the model in Excel to maximize the profitsCarrington Oil Data Crude 1Crude 2 Cost per barrel$56$65 Impurity ercentage10%2% Availability40004500 Unit priceMax impurityMax salesGas 1$724%4200Gas 2$843%4300

Name: Carrington oil produces gas 1 and gas 2. Gas 1 is allowed to contain u
Uploaded: 2024-03-20T07:07:26.000Z
Channel: Bartleby
Description: Carrington oil produces gas 1 and gas 2. Gas 1 is allowed to contain up to 4% impurities, and gas 2 is allowed to contain up to 3% impurities. Gas 1 sells for $72 per barrel, whereas gas 2 sells for $84 per barrel. Up to 4200 barrels of gas 1 and up

Answered: Image /qna-images/answer/7f3bf99c-2a78-4673-8009-60d7e4238e7b.jpg

Answered: Carrington oil produces gas 1 and gas…

Algebra for College Students

10th Edition

ISBN:9781285195780

Author:Jerome E. Kaufmann, Karen L. Schwitters

Publisher:Jerome E. Kaufmann, Karen L. Schwitters

Chapter12: Algebra Of Matrices

Section12.CR: Review Problem Set

Problem 37CR

See similar textbooks

Related questions

Topic Video

Question

- Carrington oil produces gas 1 and gas 2. Gas 1 is allowed to contain up to 4% impurities, and gas 2 is allowed to contain up to 3% impurities. Gas 1 sells for $72 per barrel, whereas gas 2 sells for $84 per barrel. Up to 4200 barrels of gas 1 and up to 4,300 barrels of gas 2 can be sold. The cost per barrel of each crude, their availability and the level of impurities in each crude are listed in the Excel file.
Write the model in Excel to maximize the profits

Carrington Oil
Data		Crude 1	Crude 2
	Cost per barrel	$56	$65
	Impurity ercentage	10%	2%
	Availability	4000	4500

	Unit price	Max impurity	Max sales
Gas 1	$72	4%	4200
Gas 2	$84	3%	4300

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 5 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Optimization$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Similar questions