Ajax Fuels, Inc., is developing a new additive for airplane fuels. The additive

Question

Ajax Fuels, Inc., is developing a new additive for airplane fuels. The additive is a mixture of three ingredients: A, B, and C. For the proper performance, the total amount of additive (amount of A + amount of B + amount of C) must be at least 10 ounces per gallon of fuel. However, because of safety reason, the amount of additive must not exceed 15 ounces per gallon of fuel. The mix or blend of the three ingredients is critical. At least 1 ounce of ingredient A must be used for every ounce of ingredient B, and the amount of ingredient C must be greater than or equal to one half the amount of ingredient A. If the costs per ounce for ingredients A, B, and C are $ 0.10, $0.03 and $ 0.09, respectively, find the minimum-cost mixture of A, B, and C for each gallon of airplane fuel. Formulate the problem and solve it on a computer by using the Microsoft’s Excel. You need to submit the formulation (including the definition of variables), as well as the computer output

Explanation / Answer

Ajax Fuels, Inc., is developing a new additive for airplane fuels. The additive

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.