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.

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
Get step-by-step solutions from verified subject matter experts
