Creating lp model to deliver optimal ultra dry martini mix

Assignment Help Operation Management

Reference no: EM13103873

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

Reference no: EM13103873

Questions Cloud

What are magnitude and direction of net electrostatic force : A charge of -3.2 µC is fixed at the center of a compass. Two additional charges are fixed on the circle of the compass, which has a radius of 0.099 m. The charges on the circle are -3.95 µC at the position due north and +5.45 µC at the position du..

Proportion and probability : According to hypothetical information, 18% of all Americans have hazel colored eyes. A SRS of 25,000 Americans are surveyed and asked about their eye color

Find electric field at surface of each conductor is same : Two conductors are joined by a long copper wire. Thus A) each conductor must be at the same potential. B) no free charge can be present on either conductor. C) each conductor carries the same free charge.

Random number sets : Choose a number at random from the set of numbers from the set of numbers {1,2,3,4,5}. Now choose a number from the subset {1,...,X). Call this second number Y.

Creating lp model to deliver optimal ultra dry martini mix : 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.

What percentage of the alpha particles penetrated completely : A physicist has developed a device that generates a beam of alpha particles (each of which is a helium nucleus, consisting of two protons, two neutrons, and no electrons).

Skateworld company-probability : The Skateworld Company operates ice rinks in several major cities throughout the United States. During each session of open skating, one customer is selected at random to receive a free pass for a future open skating session.

Crm system : Development of a simple sales and invoice component where a customer fills out a form on a web page to request a truck delivery and then receives an online invoice in PDF format.

How many electrons are also emitted : The nucleus of an atom consists of protons and neutrons (no electrons). A nucleus of a carbon-12 isotope contains six protons and six neutrons.

User Account

All Pages