Question: Use Excel to solve this problem. A company is developing a new additive for gasoline. The additive is a mixture of three liquid ingredients: I,

Use Excel to solve this problem.

Use Excel to solve this problem. A company is developing a new

A company is developing a new additive for gasoline. The additive is a mixture of three liquid ingredients: I, I, and III. For proper performance, the total amount of additive must be at least 15 ounces per barrel of gasoline. However, for safety reasons, the amount of additive should not exceed 20 ounces per barrel of gasoline. At least ounce of ingredient I must be used for every ounce of ingredient ll, and at least 1 ounce of ingredient lll must be used for every ounce of ingredient I. If the costs of , I, and Ill are $0.40, $0.09, and $0.23 per ounce, respectively, use technology to find the mixture of the three ingredients that produces the minimum cost of the additive. What is the minimum cost? The mixture of ounces of ingredient l ounces of ingredient ll and ounces of ingredient ill produces the minimum cost of the additive Type integers, fractions, or mixed numbers.) The minimum cost is $per barrel Round to the nearest cent as needed.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!