MI6's Q Branch is developing a new ultra dry martini. The martini is a mixture of vodka plus three liquid ingredients: A, B, and C. To ensure proper performance, the total amount of additive (amount of A plus amount of B plus amount of C) must be at least 10 ounces per gallon of vodka. For safety reasons, however, the amount of additive must not exceed 15 ounces per gallon of vodka. The mix or blend of the three ingredients is critical. At least one ounce of ingredient A must be used for every ounce of ingredient B. The amount of ingredient C must be greater than one-half the amount of ingredient A. The mixture must contain at least one ounce each of A, B, and C. The cost per ounce for ingredients A, B, and C is $10, $3, and $9 respectively. The martini must be shaken, not stirred.
Using Excel develop an LP model to deliver an optimal ultra dry martini mix. Format the cell with your objective function in sunburst yellow