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…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

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